Re: log_statement vs Statistics Collector (pg_stat_database,, etc)

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: log_statement vs Statistics Collector (pg_stat_database,, etc)
Дата
Msg-id CAJghg4J6+d7VU4tcSK8o_LEcEFkh3LH6zSOY6Az_ghbojEOdGw@mail.gmail.com
обсуждение исходный текст
Ответ на log_statement vs Statistics Collector (pg_stat_database,, etc)  (Nik Tek <niktek2005@gmail.com>)
Ответы Re: log_statement vs Statistics Collector (pg_stat_database,, etc)
Список pgsql-admin
Дерево обсуждения

On Thu, Dec 24, 2015 at 7:32 PM, Nik Tek <niktek2005@gmail.com> wrote:
I wanted to capture all the DML statements executed in the database information (execution time, ).

Question:
Can anyone point me pros and cons on either of the approaches.

In my testing, I haven't found any performance degrade on application operations when enabled the additional logging (below logging).

Besides log_min_duration_statement, you can use tools like pg_stat_statements [1] and POWA [2]. POWA authors even did a comparison of performance impact of having log_min_duration_statement (to latter process with pgBadger), using POWA extension and nothing, see [3].

[1] http://www.postgresql.org/docs/current/static/pgstatstatements.html
[2] http://dalibo.github.io/powa/
[3] https://github.com/dalibo/powa/wiki/POWA-vs-pgBadger


--
Matheus de Oliveira


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

Предыдущее
От: Nik Tek
Дата:
Сообщение: log_statement vs Statistics Collector (pg_stat_database,, etc)
Следующее
От: "Scott Neville"
Дата:
Сообщение: Re: Slow planning time