How to analyze PostgreSQL logs?
Posted on July 28, 2009
Filed Under PostgreSQL | Leave a Comment
Sometimes you need to analyze what actually is hitting your database. It could be due to poor performance or just maybe for improvement purposes. Whatever is the reason, here are the options that I enable to achieve this:
Edit postgresql.conf file and enable the following options:
- log_destination = ’stderr’
- redirect_stderr = on
- log_directory = ‘pg_log’
- log_filename = ‘postgresql-%Y-%m-%d.log’
- client_min_messages = notice
- log_min_messages = notice
- log_min_duration_statement = 0
- log_line_prefix = ‘[%t] <%d>’
The comments in that file are quite sufficient to understand and change values according to your need. Once you’re done, don’t forget to restart PostgreSQL.
After that just tail -f postgresql-2009-07-20.log and maybe throw some grep and/or grep -v
Comments
Leave a Reply