From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Matteo Bonardi <mbona92(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Temporary files usage in explain |
Date: | 2021-04-27 09:30:36 |
Message-ID: | 93c44e419911beb7ba28ab5f75f2fc113273e643.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 is 299,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
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2021-04-27 09:38:17 | Re: Temporary files usage in explain |
Previous Message | Matteo Bonardi | 2021-04-27 09:15:06 | Temporary files usage in explain |