Re: Query runtime differences- trying to understand why.
От
Andreas Kretschmer
Тема
Re: Query runtime differences- trying to understand why.
Дата
Msg-id
8c86407b-a9c3-2e21-afeb-b948fe240fe7@a-kretschmer.de
Ответ на
Query runtime differences- trying to understand why. (Dirschel, Steve)
Список
Дерево обсуждения
Query runtime differences- trying to understand why. "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Re: Query runtime differences- trying to understand why. Andreas Kretschmer <andreas@a-kretschmer.de>
RE: [EXT] Re: Query runtime differences- trying to understand why. "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
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 по дате отправления
От: Dirschel, Steve
Дата:
