[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: [GENERAL] explain analyze output with parallel workers - question about meaning of information for e
From: hubert depesz lubaczewski <depesz () depesz ! com>
Date: 2017-11-17 15:12:54
Message-ID: 20171117151253.GA27124 () depesz ! com
[Download RAW message or body]
Hi,
up to parallel executions, when we had node in explain analyze showing
"loops=x" with x more than 1, it meant that the "actual time" had to be
multiplied by loops to get real time spent in a node.
For example, check step 13 in https://explain.depesz.com/s/gNBd
It shows time of 3ms, but loops of 1873, so the actual time is ~ 5600ms.
But with parallel execution it seems to be no longer the case.
For example:
https://explain.depesz.com/s/LTMp
or
https://explain.depesz.com/s/QHRi
It looks that the actual time is really actual time, and loops is
"worker nodes + 1".
Is that really the case? Should I, for explain.depesz.com, when dealing
with partial* and parallel* nodes, use "loops=1" for calculation of
exclusive/inclusive time? always? some other nodes?
or am I missing something in here?
Best regards,
depesz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic