Monitoring and Server Administration
Harry
· 13 Sep 2026
· 1 views
Dashboard
Click a server to see the Dashboard with sessions, transactions per second, cache hit ratio, and tablespace usage. It refreshes live, so load spikes become visible.
Activity and Locks
The Dashboard's Activity tab lists running queries; the Locks tab shows blocking chains. Identify the PID holding a lock and decide to cancel or let it finish.
Roles and Privileges
Login/Group Roles define authentication and ownership; the Membership tab grants roles to roles. Grant privileges per database, schema or table from object Properties > Security.
Maintenance
Right-click a database > Maintenance runs VACUUM or ANALYZE (or both) to reclaim space and refresh planner statistics - the classic response to slow queries.
Key Points
- Dashboard monitors load and sessions.
- Activity and Locks expose stuck queries.
- Roles and grants centralize access.
- VACUUM/ANALYZE maintenance keeps queries fast.