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