Re: "actual time" in QUERY PLAN for parallel operation when loops is bigger than 1

2021-11-16 Thread Guillaume Lelarge
Hi, Le mer. 17 nov. 2021 à 06:32, tanghy.f...@fujitsu.com < tanghy.f...@fujitsu.com> a écrit : > Wednesday, November 17, 2021 6:29 AM, nikolai.berkoff < > nikolai.berk...@pm.me> wrote: > > > > Parallel query is explained in > > https://www.postgresql.org/docs/14/how-parallel-query-works.html and

RE: "actual time" in QUERY PLAN for parallel operation when loops is bigger than 1

2021-11-16 Thread tanghy.f...@fujitsu.com
Wednesday, November 17, 2021 6:29 AM, nikolai.berkoff wrote: > > Parallel query is explained in > https://www.postgresql.org/docs/14/how-parallel-query-works.html and > https://www.postgresql.org/docs/14/parallel-plans.html > > The docs seem clear to me that as the nodes are executed in parallel

Re: "actual time" in QUERY PLAN for parallel operation when loops is bigger than 1

2021-11-16 Thread nikolai.berkoff
> https://www.postgresql.org/docs/14/using-explain.html > The doc says > > "the loops value reports the total number of executions of the node, and the > > actual time and rows values shown are averages per-execution. This is done > > to make the numbers comparable with the way that the cost

"actual time" in QUERY PLAN for parallel operation when loops is bigger than 1

2021-11-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/using-explain.html Description: https://www.postgresql.org/docs/14/using-explain.html The doc says "the loops value reports the total number of executions of the node, and the actual time