pganalyze Log Insights
Welcome to pganalyze Log Insights - the best way to monitor and analyze your PostgreSQL log files, and give you insights into how to tune your database better, or to explain why your database might be slow at a given moment.
- Install on Amazon RDS & Amazon Aurora
- Install on Heroku Postgres
- Install on Self-Hosted Server
- Tuning Log Config Settings
Internally in pganalyze each log line gets assigned one of the event types below, to uniquely identify the circumstances under which such an event was triggered.
These classifications are then used for alerting and filtering purposes, and allow you to quickly find the corresponding documentation for an event.
Log Event Categories:
- WAL & Checkpoints
- Standby Servers
- Constraint Violations
- Application / User Errors
Log event types in comparison to SQLSTATE
Those familiar with SQL error codes (SQLSTATE) might ask themselves: Why invent yet another log line categorization system?
In our experience working with Postgres logs, whilst the SQL error codes in logs are useful (if they are being output), they unfortunately cover less than 50% of the useful log events we encountered.
Where available this documentation includes a reference to the corresponding SQLSTATE code, so you can match it up.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →