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

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.

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.