PostgreSQL Databases


The PostgreSQL Databases page lists databases discovered on a monitored PostgreSQL server. Use it to review database inventory and begin database-focused troubleshooting.

Mini DBA PostgreSQL databases

What To Review

  • Database names.
  • State and availability indicators where available.
  • Size or activity signals where available.
  • Alerts or health indicators connected to a database.

Workflow

  1. Open Databases for the PostgreSQL server.
  2. Review the database list.
  3. Use Activity, Queries, Indexes, and Permissions for deeper investigation.

How To Use PostgreSQL Database Inventory

The Databases page gives context for a monitored PostgreSQL server before you start deeper troubleshooting. Use it to confirm which databases Mini DBA discovered, whether you are viewing the correct environment, and which database owns the workload you are investigating.

Database inventory is important on shared PostgreSQL servers because several applications may use the same instance. If an alert, query, or log entry references a database name, confirm the target here before opening PostgreSQL Activity, PostgreSQL Queries, or PostgreSQL Indexes.

If a database is missing, check the connection target, role privileges, cloud provider restrictions, and collection status. The setup guidance in Connect To PostgreSQL explains the monitoring role and host OS login options.

PostgreSQL Databases FAQ

Is this page for tuning?

It is mainly inventory and context. Use Activity, Queries, Waits, Indexes, and Health Checks for tuning evidence.

Why is an expected database missing?

The monitoring role may not have visibility, collection may not have completed, or the connection may target a different server.

Can this page help with audits?

Yes. It can support database inventory review when combined with Reports and Enterprise View.

Next Steps From Inventory

After selecting the relevant PostgreSQL database, move to the evidence page that matches the symptom. Use Activity for current sessions, Queries for statement cost, Waits for delay patterns, Indexes for schema support, and Logs for server messages. If a database appears missing, review the connection target and monitoring role grants.

Related Pages