Обсуждение: Temporary Files

Поиск
Список
Период
Сортировка

Temporary Files

От
"Campbell, Lance"
Дата:

PostgreSQL 13.3

 

Is there a way to see, track or log the queries that result in temporary file creation?

 

Thanks,

 

Lance Campbell

Re: Temporary Files

От
Muhammet Kurtoğlu
Дата:
Hi,
pg_stat_statements
pgbadger

Campbell, Lance <lance@illinois.edu>, 14 Eyl 2021 Sal, 16:37 tarihinde şunu yazdı:

PostgreSQL 13.3

 

Is there a way to see, track or log the queries that result in temporary file creation?

 

Thanks,

 

Lance Campbell



--

Re: Temporary Files

От
Tom Lane
Дата:
"Campbell, Lance" <lance@illinois.edu> writes:
> Is there a way to see, track or log the queries that result in temporary file creation?

The log_temp_files setting might be of use.

            regards, tom lane

Re: Temporary Files

От
"Campbell, Lance"
Дата:
Thanks Tom for responding.  I think this will help me out.

Lance

On 9/14/21, 8:58 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

    "Campbell, Lance" <lance@illinois.edu> writes:
    > Is there a way to see, track or log the queries that result in temporary file creation?

    The log_temp_files setting might be of use.

                regards, tom lane

Re: Temporary Files

От
Jayson Hreczuck
Дата:
I'll second pg_badger.  Very useful tool for this.

On Tue, Sep 14, 2021 at 10:20 AM Campbell, Lance <lance@illinois.edu> wrote:
Thanks Tom for responding.  I think this will help me out.

Lance

On 9/14/21, 8:58 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

    "Campbell, Lance" <lance@illinois.edu> writes:
    > Is there a way to see, track or log the queries that result in temporary file creation?

    The log_temp_files setting might be of use.

                        regards, tom lane



--


Jayson Hreczuck | Principal Database Administrator

C: +1 617.571.9861130 Turner St, Ste 530, Waltham, MA 02453