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 or click the Dashboard button in the toolbar overflow menu.
Server Dashboard

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
  • Terminate Session (x icon) - kills the entire connection
Both actions show a confirmation alert before executing.

Server Metrics

A horizontal strip of key metrics displayed as cards:
DatabaseMetrics shown
PostgreSQLActive connections, cache hit ratio, database size, uptime, active queries
MySQL/MariaDBThreads connected, threads running, uptime, total queries, slow queries, max connections
MSSQLActive connections, uptime, database size
ClickHouseActive queries, merges, disk usage
DuckDBDatabase size, memory limit, threads
SQLiteDatabase size, journal mode, cache size

Slow Queries

A collapsible list of queries running longer than 1 second, sorted by duration. Each entry shows the elapsed time, SQL text, user, and database.

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
  • Manual refresh - click or press Cmd+R
  • Last refresh time - shown on the right

Database Support

FeaturePostgreSQLMySQLMSSQLClickHouseDuckDBSQLite
Active SessionsYesYesYesYes--
Server MetricsYesYesYesYesYesYes
Slow QueriesYesYesYesYes--
Kill SessionYesYesYesYes--
Cancel QueryYesYes----
NoSQL databases (Redis, MongoDB, etc.) do not support the dashboard. The menu item and toolbar button are hidden for these connections.