Postgres Pro
Downloads
Home   >   mailing lists

Temporary files usage in explain - Mailing list pgsql-general

From Matteo Bonardi
Subject Temporary files usage in explain
Date
Msg-id CAPosY76DbSZxwszm2TJJ-A=vhunb_6Gf7k8B31T0uOQgeyb9wg@mail.gmail.com
Whole thread Raw
Responses Re: Temporary files usage in explain
Re: Temporary files usage in explain
List pgsql-general
Tree view
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.


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

pgsql-general by date:

Previous
From: Charles Clavadetscher
Date:
Subject: Re: About to know the info of foreign table reference used in any of call ,views,functions
Next
From: Laurenz Albe
Date:
Subject: Re: Temporary files usage in explain