Re: [PERFORM] Explain Analyze - actual time in loops

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] Explain Analyze - actual time in loops
Дата
Msg-id 15789.1504878289@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] Explain Analyze - actual time in loops  (Neto pr <netopr9@gmail.com>)
Ответы Re: [PERFORM] Explain Analyze - actual time in loops
Список pgsql-performance
Neto pr <netopr9@gmail.com> writes:
> After analyzing, I saw that in some places of the plan, it is being used
> Parallelism. Does this explain why the final value spent (in minutes) to go
> through the index (184 minutes) is greater than the total query time (66
> minutes)?

I was just about to ask you about that.  If this is under a Gather node,
I believe that the numbers include time expended in all processes.
So if you had three or more workers these results would make sense.
        regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Neto pr
Дата:
Сообщение: Re: [PERFORM] Explain Analyze - actual time in loops
Следующее
От: Neto pr
Дата:
Сообщение: Re: [PERFORM] Explain Analyze - actual time in loops