Re: Explain Analyze - actual time in loops

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neto pr <netopr9(at)gmail(dot)com>
Cc: Igor Neyman <ineyman(at)perceptron(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Explain Analyze - actual time in loops
Date: 2017-09-08 13:44:49
Message-ID: 15789.1504878289@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Neto pr <netopr9(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Neto pr 2017-09-08 14:02:37 Re: Explain Analyze - actual time in loops
Previous Message Neto pr 2017-09-08 13:08:08 Re: Explain Analyze - actual time in loops