RE: [EXT] Re: Query runtime differences- trying to understand why.

2023-11-29 Thread Dirschel, Steve
other execution of the query. Regards -Original Message- From: Andreas Kretschmer 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 attach

Re: Query runtime differences- trying to understand why.

2023-11-29 Thread Andreas Kretschmer
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 t