Re: Work_mem

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Work_mem
Дата
Msg-id CAMkU=1xPtXPf6S4gqD8Fs1k2gG0PyE1mjToNsXbZ85zgY66YOw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Work_mem  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Ответы Re: Work_mem  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Список pgsql-admin


On Mon, Apr 8, 2024 at 1:57 PM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
I dont see any long running queries under pg_stat_activity or pg_stat_statements.

With pg_stat_activity, you would need to catch them "in the act", but there are no columns there which describe temp file usage anyway.

pg_stat_statements has the columns "temp_blks_read" and "temp_blks_written", in all supported versions, so you should be able to spot the queries using temp files there.  Unless maybe your pg_stat_statements.max setting is too low and those queries are forced out.

Or you could set log_temp_files = 0.  That would log all statements using temp files into the PostgreSQL server log.

Cheers,

Jeff

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Satish Chikkathammaiah [NMC - IT]"
Дата:
Сообщение: Re: Auditing in Postgres
Следующее
От: Rajesh Kumar
Дата:
Сообщение: Re: Work_mem