Sorry. DB is Aurora Postgres 14.6. Hints are enabled via extension pg_hint_plan. But my question isn't so much about
thehints but the execution plan and where the time is going and why it appears for 1 execution of the query skipping
lockedrows seems to take a lot more time than another execution of the query.
Regards
-----Original Message-----
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Sent: Wednesday, November 29, 2023 3:10 PM
To: pgsql-general@lists.postgresql.org
Subject: [EXT] Re: Query runtime differences- trying to understand why.
External Email: Use caution with links and attachments.
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)
https://urldefense.com/v3/__http://www.enterprisedb.com__;!!GFN0sa3rsbfR8OLyAw!eF3r308h3pnOusNslRf-zZZ1LUoQFkGOKK47Sm1ByfdIdLAtF0xPY4-4Xuo_F25zoV12fGtyNUelCdG10fZEKldOigKm0FXp$