Skip to main content

Server Dashboard

The dashboard shows active sessions, key server metrics, and slow-running queries with configurable auto-refresh. Open it from the menu bar View > Server Dashboard. A Dashboard toolbar button is also available: right-click the toolbar, choose Customize Toolbar, and drag it in.
Server Dashboard

Server Dashboard showing active sessions, metrics, and slow queries

Active Sessions

A sortable table of all connections to the server, showing:
  • PID - process or session ID
  • User - connected user
  • Database - target database
  • State - current status (active, idle, sleeping)
  • Duration - how long the current operation has been running
  • Query - the SQL statement being executed (truncated, hover for full text)

Kill and Cancel

Each session row has action buttons:
  • Cancel Query (stop icon) - cancels the running query without terminating the connection (pg_cancel_backend on PostgreSQL, KILL QUERY on MySQL)
  • Terminate Session (x icon) - kills the entire connection
Both actions show a confirmation alert before executing. If the server rejects the action, an Action Failed alert shows the error.

Server Metrics

A horizontal strip of metric cards. What is shown depends on the database:

Slow Queries

A list of queries running longer than 1 second, sorted by duration. Each entry shows the elapsed time, SQL text, user, and database. The dashboard panels sit in a vertical split. Drag the dividers between Active Sessions, Server Metrics, and Slow Queries to resize each section; positions are remembered across launches.

Auto-refresh

The dashboard toolbar provides refresh controls:
  • Interval picker - choose 1s, 2s, 5s (default), 10s, 30s, or Off
  • Pause/Resume - temporarily stop refreshing without changing the interval (disabled when the interval is Off)
  • Refresh Now - runs a manual refresh
  • Last refresh time - shown on the right

Database Support

For databases without a dashboard provider (Redis, MongoDB, and others), the menu item and toolbar button are disabled.