Re: Query runtime differences- trying to understand why.

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Query runtime differences- trying to understand why.
Date: 2023-11-29 21:09:31
Message-ID: 8c86407b-a9c3-2e21-afeb-b948fe240fe7@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dirschel, Steve 2023-11-29 21:14:44 RE: [EXT] Re: Query runtime differences- trying to understand why.
Previous Message Dirschel, Steve 2023-11-29 20:25:05 Query runtime differences- trying to understand why.