Postgres Pro
Downloads
Home   >   mailing lists

Re: Query runtime differences- trying to understand why. - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Query runtime differences- trying to understand why.
Date
Msg-id 8c86407b-a9c3-2e21-afeb-b948fe240fe7@a-kretschmer.de
Whole thread Raw
In response to Query runtime differences- trying to understand why.  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
Responses RE: [EXT] Re: Query runtime differences- trying to understand why.
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: "Dirschel, Steve"
Date:
Subject: Query runtime differences- trying to understand why.
Next
From: "Dirschel, Steve"
Date:
Subject: RE: [EXT] Re: Query runtime differences- trying to understand why.