Re: Explain analyse with track_io_timing

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема Re: Explain analyse with track_io_timing
Дата
Msg-id CAFS1N4hKfeoU7HEED51heWzHpF+=L5Y4y9cy1OLT3b+j60tHKg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Explain analyse with track_io_timing  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-performance


Is it a parallel query?  If yes the total time is only the time spent in the
main process, and the IO time is sum of all IO time spent in main process and
the parallel workers, which can obviously be a lot more than the total
execution time.
Yes, there are parallel workers, that explains it. Thank you.
Regards,
Jay
 

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Explain analyse with track_io_timing
Следующее
От: Moises Lopez
Дата:
Сообщение: Re: Optimal configuration for server