log_statement vs Statistics Collector (pg_stat_database,, etc)

From: Nik Tek <niktek2005(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: Nik Tek <niktek2005(at)gmail(dot)com>
Subject: log_statement vs Statistics Collector (pg_stat_database,, etc)
Date: 2015-12-24 21:32:13
Message-ID: CAHySzWUsa2DMp8jgACMAF+J_6o6fycQx3BEf=yBbZMiQE-S-uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matheus de Oliveira 2015-12-27 13:35:52 Re: log_statement vs Statistics Collector (pg_stat_database,, etc)
Previous Message Bruce Momjian 2015-12-24 16:55:40 Re: pg_upgrade 9.0 -> 9.3 general questions : things to watch out for