Temporary files usage in explain

From: Matteo Bonardi <mbona92(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Temporary files usage in explain
Date: 2021-04-27 09:15:06
Message-ID: CAPosY76DbSZxwszm2TJJ-A=vhunb_6Gf7k8B31T0uOQgeyb9wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everybody,

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?

Thanks,
Matteo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2021-04-27 09:30:36 Re: Temporary files usage in explain
Previous Message Charles Clavadetscher 2021-04-27 07:31:25 Re: About to know the info of foreign table reference used in any of call ,views,functions