Postgresql Slow Query Log

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??!?