log_statement vs Statistics Collector (pg_stat_database,, etc) - Mailing list pgsql-admin

From Nik Tek
Subject log_statement vs Statistics Collector (pg_stat_database,, etc)
Date
Msg-id CAHySzWUsa2DMp8jgACMAF+J_6o6fycQx3BEf=yBbZMiQE-S-uw@mail.gmail.com
Whole thread Raw
Responses Re: log_statement vs Statistics Collector (pg_stat_database,, etc)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade 9.0 -> 9.3 general questions : things to watch out for
Next
From: Matheus de Oliveira
Date:
Subject: Re: log_statement vs Statistics Collector (pg_stat_database,, etc)