Temporary files usage in explain

Поиск
Список
Период
Сортировка
От Matteo Bonardi
Тема Temporary files usage in explain
Дата
Msg-id CAPosY76DbSZxwszm2TJJ-A=vhunb_6Gf7k8B31T0uOQgeyb9wg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Temporary files usage in explain  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Temporary files usage in explain  (David Rowley <dgrowleyml@gmail.com>)
Список 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.


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 по дате отправления:

Предыдущее
От: Charles Clavadetscher
Дата:
Сообщение: Re: About to know the info of foreign table reference used in any of call ,views,functions
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Temporary files usage in explain