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
Hi,
On Thu, Mar 10, 2022 at 10:40:17AM +0530, Jayadevan M wrote:
>
> What is the unit of I/O Timings in explain (analyze, buffers) ?
milliseconds
> There is a plan with quite a few nodes. In each case, the value of I/O
> Timings is much more than the time for the outer node. A few lines from th
Hello team,
What is the unit of I/O Timings in explain (analyze, buffers) ? There is a
plan with quite a few nodes. In each case, the value of I/O Timings is
much more than the time for the outer node. A few lines from the plan -
Hash Left Join (cost=14320945.22..7099974624.27 rows=19433506270
