[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Query runtime differences- trying to understand why.
From:       Andreas Kretschmer <andreas () a-kretschmer ! de>
Date:       2023-11-29 21:09:31
Message-ID: 8c86407b-a9c3-2e21-afeb-b948fe240fe7 () a-kretschmer ! de
[Download RAW message or body]



Am 29.11.23 um 21:25 schrieb Dirschel, Steve:
>
> I have a question on the execution time of a query and the 
> fluctuations I'm seeing.  I enabled auto_trace to capture some actual 
> executions of a query by an app.  Below are 2 executions of it.  The 
> top one took 1.697 milliseconds. The 2nd one took 31.241 
> milliseconds.  Note the query has hints in it
>

what database are you using? PostgreSQL doesn't hav hints...

Regards, Andreas

-- 
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com



[prev in list] [next in list] [prev in thread] [next in thread]