log_statement vs Statistics Collector (pg_stat_database,, etc)

[Nik Tek <niktek2005@xxxxxxxxx>]

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