log_statement vs Statistics Collector (pg_stat_database,, etc)

Поиск
Список
Период
Сортировка
От Nik Tek
Тема log_statement vs Statistics Collector (pg_stat_database,, etc)
Дата
Msg-id CAHySzWUsa2DMp8jgACMAF+J_6o6fycQx3BEf=yBbZMiQE-S-uw@mail.gmail.com
обсуждение исходный текст
Ответы Re: log_statement vs Statistics Collector (pg_stat_database,, etc)
Список pgsql-admin
Дерево обсуждения
Hi pg gurus,

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).

log_error_verbosity = verbose
log_min_duration_statement = 0
log_statement = 'mod'
log_checkpoints = on


--
Thank you
NikTeki

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade 9.0 -> 9.3 general questions : things to watch out for
Следующее
От: Matheus de Oliveira
Дата:
Сообщение: Re: log_statement vs Statistics Collector (pg_stat_database,, etc)