> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-refactor-theme-engine-v2.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-refactor-theme-engine-v2/DWaRdsQUS-EjY9hl/images/server-dashboard.png?fit=max&auto=format&n=DWaRdsQUS-EjY9hl&q=85&s=c9a03b3b44b92c53c271abfacec8c956" alt="Server Dashboard" width="3024" height="1704" data-path="images/server-dashboard.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-refactor-theme-engine-v2/DWaRdsQUS-EjY9hl/images/server-dashboard-dark.png?fit=max&auto=format&n=DWaRdsQUS-EjY9hl&q=85&s=33b3c96aa0c6ab828b0c52ac9f6b6872" 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 |

On PostgreSQL 9.1 an idle session shows an empty Query: that server keeps only the running statement, not the last one.

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 |    Yes   | Connections, cache hit ratio, database size, uptime, active queries                                                  |      Yes     |   Yes  |    Yes    |
| CockroachDB           |    Yes   | Connections, 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.