Skip to main content

Overview tab

The Overview tab is the first screen you see after connecting to a database. It aggregates findings from health, indexes, queries, and bloat into a single summary so you can see what needs attention without opening each tab individually.

What it shows​

  • Database size, table count, index count
  • Installed extensions (used to conditionally show PostGIS and pgvector tabs)
  • Top tables by size
  • Degradation findings with severity levels: CRITICAL, HIGH, MEDIUM, and LOW (informational)

Each finding links to the relevant tab for deeper inspection.

How it works​

The Overview tab runs a consolidated set of catalog and statistics queries so the first screen can summarize database health without requiring you to open every tab.

The tab refreshes while active and keeps the previous content visible while fresh data loads in the background.

Trustworthy rates​

Rate-based signals on the Overview — such as the cache-hit ratio — are computed over a recent window between refreshes, not as a lifetime average since the last statistics reset. This keeps a long-running instance from reporting a healthy average while the last few minutes tell a different story. Until a full window is available (for example, immediately after connecting), the value is shown as cumulative and is deliberately not escalated into an alert.

Conditional navigation​

pocketPG detects installed extensions and adapts extension-specific navigation accordingly. If an extension such as PostGIS or pgvector is absent, the related page explains what is missing instead of failing silently.