Re: explain - Mailing list pgsql-general

From David Rowley
Subject Re: explain
Date
Msg-id CAApHDvr26fhQr0EYHoD7aJC+QJzOmkqVgggciPS7A+9kjiP2MQ@mail.gmail.com
Whole thread Raw
In response to Re: explain  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: explain
List pgsql-general
On Fri, 25 Apr 2025 at 03:06, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> On Fri, 2025-04-25 at 01:41 +1200, David Rowley wrote:
> > 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.
>
> But wouldn't it read "loops=3" or similar then?

Only if the Nested Loop was below the Gather / Gather Merge node.

David



pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: pg_comebinebackup
Next
From: Laurenz Albe
Date:
Subject: Re: explain