The PostgreSQL Server Log page shows PostgreSQL log information collected by Mini DBA. Use it to troubleshoot errors, connection issues, deadlocks, slow statements, and configuration problems.
When To Use It
- PostgreSQL reports errors.
- Connections fail.
- Deadlocks or lock waits occur.
- Query performance changes.
- Health checks indicate server-level issues.
Workflow
- Open Server Log.
- Review entries around the incident time.
- Match log messages to Activity, Queries, or Deadlocks.
- Check Service Log if Mini DBA itself is failing to collect PostgreSQL data.
How To Use PostgreSQL Logs In Mini DBA
The PostgreSQL Server Log page is most useful when it is used with a time window. Start with the exact time an application error, slow request, failed login, or deadlock occurred. Then review nearby log entries for database errors, authentication failures, cancelled statements, checkpoint messages, deadlock details, and configuration warnings.
PostgreSQL log visibility depends on server configuration and hosting platform. Self-managed PostgreSQL installations often allow direct access to server logs, while managed cloud services may expose logs through provider-specific views, exports, or APIs. If the page has limited log detail, confirm that the monitored account has access to the required log source and that PostgreSQL logging settings capture the events you need.
For slow-query investigations, logs are most valuable when combined with PostgreSQL Queries and PostgreSQL Waits. A log line can show an error or duration, while Mini DBA performance pages help explain the resource pattern behind it.
PostgreSQL Log FAQ
Why are some log entries missing?
Logging settings, retention, cloud platform limits, and account permissions can all affect what Mini DBA can show.
Should I enable every PostgreSQL log option?
No. More logging can increase noise and overhead. Enable the settings that support your operational goals, such as errors, deadlocks, and slow statements.
Where do I look if Mini DBA collection fails?
Use Service Log for Mini DBA collection errors and this page for PostgreSQL server messages.