Re: Temporary files usage in explain - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Temporary files usage in explain
Date
Msg-id 93c44e419911beb7ba28ab5f75f2fc113273e643.camel@cybertec.at
Whole thread Raw
In response to Temporary files usage in explain  (Matteo Bonardi <mbona92@gmail.com>)
List pgsql-general
On Tue, 2021-04-27 at 11:15 +0200, Matteo Bonardi wrote:
> I have a query that creates a large number of temporary files, in this example ~ 45GB.
> Looking at the query plan I can't figure out where temporary files are being generated.
> 
> Explain plan: https://explain.depesz.com/s/BXGT
> 
> Usually I'm looking for "external merge Disk" to see temp files usage but, in this case, the only reference to that
is299,368kB in the last but one node of explain.
 
> Can anyone help me understand where the 45GB are in that explain?

I see at first glance: Sort Method: external merge Disk: 299,368kB

To see all, use EXPLAIN (ANALYZE, BUFFERS).

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: Matteo Bonardi
Date:
Subject: Temporary files usage in explain
Next
From: David Rowley
Date:
Subject: Re: Temporary files usage in explain