Enable pg_stat_statements extension for limited statements only

Поиск
Список
Период
Сортировка
От Sayyid Ali Sajjad Rizavi
Тема Enable pg_stat_statements extension for limited statements only
Дата
Msg-id CAHxW8BC_n9c=2DJatqmas54HSTd9j2LVBG-OvoLUK4Sg-Qm+rw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Enable pg_stat_statements extension for limited statements only  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi, I'd like to propose a change and get advice if I should work on it.

The extension pg_stat_statements is very helpful, but the downside is that it will take up too much disk space when storing query stats if it's enabled for all statements like SELECT, INSERT, UPDATE, DELETE.

For example, deletes do not happen too frequently; so I'd like to be able to enable pg_stat_statements only for the DELETE statement, maybe using some flags.

Another possibility is if we can limit the tables to which pg_stat_statements logs results.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New docs chapter on Transaction Management and related changes
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: generic plans and "initial" pruning