Querious Docs

PostgreSQL Server Views

What each subview of the Server view is for.

The Server view covers everything about the server that isn't about one schema object. Its subviews are listed in the sidebar on the left. Each has its own page with columns explained.

The Server view's subview list
The Server view's subview list

Subviews #

View Use it to
Server Status See the server's health: version, connections, transaction counts, cache efficiency, checkpoints, and per-database statistics.
Activity See every connected session, what it's doing, and for how long. Cancel queries or terminate connections.
Locks Find locks in progress and which sessions are blocking others.
Statements Rank query patterns by cumulative time, using pg_stat_statements.
Replication Check WAL streaming, standbys, replication slots, and archiver health.
Index Usage Find unused and redundant indexes.
Extensions Browse, install, update, and remove extensions.
Variables View and edit configuration settings, grouped by category.
Roles Create and manage roles and their attributes.