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.
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. |