> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-docs-fix-500-query-results.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Server Dashboard

> Monitor active sessions, server metrics, and slow queries in real time

What this screen shows is what your account is allowed to see. A MySQL user without the `PROCESS` privilege gets only its own connections in the session list. A PostgreSQL role that is neither a superuser nor a member of `pg_monitor` gets everyone's backends with the Query column blank. An empty or half-blank dashboard is nearly always a privilege, not a fault.

Open it from **Database > Server Dashboard**. A Dashboard toolbar button is available too: right-click the toolbar, choose **Customize Toolbar**, and drag it in.

<Frame caption="Server Dashboard showing active sessions, metrics, and slow queries">
  <img className="block dark:hidden" src="https://mintcdn.com/ngquct-docs-fix-500-query-results/HJY892UtvXUv1PFn/images/server-dashboard.png?fit=max&auto=format&n=HJY892UtvXUv1PFn&q=85&s=5dc71f8550209615a3a0f273234c8457" alt="Server Dashboard" width="3024" height="1704" data-path="images/server-dashboard.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-docs-fix-500-query-results/HJY892UtvXUv1PFn/images/server-dashboard-dark.png?fit=max&auto=format&n=HJY892UtvXUv1PFn&q=85&s=a58068af53f190bb4c791fd7fd84b167" alt="Server Dashboard" width="3024" height="1704" data-path="images/server-dashboard-dark.png" />
</Frame>

The panels stack top to bottom. Drag the dividers between Active Sessions, Server Metrics, and Slow Queries to resize them; the positions are remembered across launches.

## Active Sessions

Every connection to the server except this one, sortable, one row each.

| Column         | Holds                                                                 |
| -------------- | --------------------------------------------------------------------- |
| PID            | Process or session ID                                                 |
| User, Database | Who is connected, and to what                                         |
| State          | active, idle or sleeping, in the engine's own wording                 |
| Duration       | How long the current operation has been running                       |
| Query          | The statement, truncated at 1,000 characters. Hover for the full text |

Two buttons sit on each row. **Cancel Query** stops the running statement and leaves the connection up: `pg_cancel_backend` on PostgreSQL, `KILL QUERY` on MySQL. **Terminate Session** ends the connection itself with `pg_terminate_backend` or `KILL`, and the server rolls back any transaction that session had open. Both confirm first, and a refusal from the server comes back as an **Action Failed** alert.

## Slow Queries

Queries still running after 1 second, longest first, with elapsed time, SQL, user, and database.

ClickHouse is the exception: its list comes from `system.query_log`, so it holds the 20 most recent *finished* queries that took over a second, newest first, and no database.

## Refreshing

The interval menu offers 1s, 2s, 5s (the default), 10s, 30s, and Off. **Pause** stops the cycle without changing the interval and is dimmed while the interval is Off. **Refresh Now** runs a single pass. The time of the last refresh sits on the right.

## What each engine reports

| Database                            | Sessions | Metrics                                                                                                              | Slow queries | Cancel | Terminate |
| ----------------------------------- | :------: | -------------------------------------------------------------------------------------------------------------------- | :----------: | :----: | :-------: |
| PostgreSQL / Redshift / CockroachDB |    Yes   | Connections, cache hit ratio, database size, uptime, active queries                                                  |      Yes     |   Yes  |    Yes    |
| MySQL / MariaDB                     |    Yes   | Connected threads, running threads, uptime, total queries, slow queries, max connections, bytes received, bytes sent |      Yes     |   Yes  |    Yes    |
| SQL Server                          |    Yes   | User sessions, uptime, database size                                                                                 |      Yes     |    -   |    Yes    |
| ClickHouse                          |    Yes   | Active queries, active merges, part mutations, disk usage                                                            |      Yes     |    -   |    Yes    |
| DuckDB                              |     -    | Database size, block size, total blocks, memory limit, threads                                                       |       -      |    -   |     -     |
| SQLite                              |     -    | Database size, page count, page size, journal mode, cache size                                                       |       -      |    -   |     -     |

Every other engine has no dashboard provider, so the menu item and the toolbar button are dimmed.