public inbox for [email protected]
help / color / mirror / Atom feedFrom: Marc Millas <[email protected]>
To: David Rowley <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: explain
Date: Thu, 24 Apr 2025 15:51:01 +0200
Message-ID: <CADX_1aZ3b_XKt31NWjpxV7BUyh2poCERiRZ85UGJ=2+6aTKrbQ@mail.gmail.com> (raw)
In-Reply-To: <CAApHDvqN-mSE=9cgApVfp0qQtuasD_-p6PTRqygT8+HrPtb2zA@mail.gmail.com>
References: <CADX_1aZDtzTaoV5XNi__VbQCj7iPGaU6i5XANjjPwLwF7Acsww@mail.gmail.com>
<CAApHDvqN-mSE=9cgApVfp0qQtuasD_-p6PTRqygT8+HrPtb2zA@mail.gmail.com>
Thanks !
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Thu, Apr 24, 2025 at 3:41 PM David Rowley <[email protected]> wrote:
> 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: <CADX_1aZ3b_XKt31NWjpxV7BUyh2poCERiRZ85UGJ=2+6aTKrbQ@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