Patrick Crosby's Internet Presents

Postgresql Slow Query Log

08 Feb 2008

Set the following variable in postgresql.conf to log all queries that take longer than 100 milliseconds:

log_min_duration_statement = 100

They will show up in the main postgresql.log file.

pgFouine looks like an intriguing postgresql log file analyzer, except it’s written in PHP??!?


Related Posts

  1. Automatic Production Log Performance Reports Rawk Logrotate
  2. gettext 1.10.0 and rails 2.0
  3. My 5 Must-have vim Plugins
  4. Jekyll Exclude Files
  5. Autotest with Rails Tip -- Ignore Files for Less CPU Usage
You should follow me on Twitter: @patrickxb