Incorrect Total runtime Reported by Explain Analyze!?

Поиск
Список
Период
Сортировка
От Jozsef Szalay
Тема Incorrect Total runtime Reported by Explain Analyze!?
Дата
Msg-id E387E2E9622FDD408359F98BF183879E2BDE92@dc1.storediq.com
обсуждение исходный текст
Ответы Re: Incorrect Total runtime Reported by Explain Analyze!?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Incorrect Total runtime Reported by Explain Analyze!?  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance

Hi All,

 

I have seen it on occasion that the total runtime reported by explain analyze was much higher than the actual time the query needed to complete. The differences in my case ranged between 20-120 seconds. I’m just curious if anyone else has experienced this and whether there is something that I can do to convince explain analyze to report the execution time of the query itself rather than the time of its own execution. Engine version is 8.1.1.

 

Thanks for the help!

 

В списке pgsql-performance по дате отправления:

Предыдущее
От: J@Planeti.Biz
Дата:
Сообщение: Query optimization with X Y JOIN
Следующее
От: "Craig A. James"
Дата:
Сообщение: Re: Query optimization with X Y JOIN