public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Rowley <[email protected]>
To: Marc Millas <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: explain
Date: Fri, 25 Apr 2025 01:41:34 +1200
Message-ID: <CAApHDvqN-mSE=9cgApVfp0qQtuasD_-p6PTRqygT8+HrPtb2zA@mail.gmail.com> (raw)
In-Reply-To: <CADX_1aZDtzTaoV5XNi__VbQCj7iPGaU6i5XANjjPwLwF7Acsww@mail.gmail.com>
References: <CADX_1aZDtzTaoV5XNi__VbQCj7iPGaU6i5XANjjPwLwF7Acsww@mail.gmail.com>

On Fri, 25 Apr 2025 at 01:32, Marc Millas <[email protected]> wrote:
> Nested Loop Left Join  (cost=941400.77..966327.57 rows=3 width=653) (actual time=52655.694..62533.811 rows=346 loops=1)
>   Buffers: shared hit=10068265 read=396705 dirtied=1858 written=218, temp read=429687 written=115187
>   I/O Timings: read=79368.246 write=11.486
>
> So, the total execution time is 52655 ms ok
> and the total time for i/o is...79368 ms
>
> how ???

The 79.3 seconds is the total time spent doing reads for all parallel
workers. 52.6 seconds is the wall clock time elapsed to execute the
query.

David

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: explain
  In-Reply-To: <CAApHDvqN-mSE=9cgApVfp0qQtuasD_-p6PTRqygT8+HrPtb2zA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox