Re: Explain analyse with track_io_timing

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Explain analyse with track_io_timing
Date: 2022-03-10 06:10:24
Message-ID: CAFS1N4hKfeoU7HEED51heWzHpF+=L5Y4y9cy1OLT3b+j60tHKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 it. Thank you.
Regards,
Jay

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Moises Lopez 2022-03-12 01:00:20 Re: Optimal configuration for server
Previous Message Julien Rouhaud 2022-03-10 06:05:28 Re: Explain analyse with track_io_timing