> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> 包含 `/dashboard` 页面（可通过 HTTP 接口访问）使用的查询，可用于监控和故障排查。

# system.dashboards

<div id="description">
  ## 描述
</div>

包含可通过 [HTTP 接口](/zh/concepts/features/interfaces/http) 访问的 `/dashboard` 页面所使用的查询。
该表可用于监控和故障排查。仪表盘中的每个图表在该表中都对应一行。

<Note>
  `/dashboard` 页面不仅可以渲染来自 `system.dashboards` 的查询，还可以渲染来自任何具有相同 schema 的表的查询。
  这可用于创建自定义仪表盘。
</Note>

<div id="columns">
  ## 列
</div>

* `dashboard` ([String](/zh/reference/data-types)) — 仪表盘名称。
* `title` ([String](/zh/reference/data-types)) — 图表标题。
* `query` ([String](/zh/reference/data-types)) — 用于获取要显示数据的查询。

<div id="example">
  ## 示例
</div>

```sql theme={null}
SELECT *
FROM system.dashboards
WHERE title ILIKE '%CPU%'
```

```text theme={null}
Row 1:
──────
dashboard: overview
title:     CPU Usage (cores)
query:     SELECT toStartOfInterval(event_time, INTERVAL {rounding:UInt32} SECOND)::INT AS t, avg(ProfileEvent_OSCPUVirtualTimeMicroseconds) / 1000000
FROM system.metric_log
WHERE event_date >= toDate(now() - {seconds:UInt32}) AND event_time >= now() - {seconds:UInt32}
GROUP BY t
ORDER BY t WITH FILL STEP {rounding:UInt32}

Row 2:
──────
dashboard: overview
title:     CPU Wait
query:     SELECT toStartOfInterval(event_time, INTERVAL {rounding:UInt32} SECOND)::INT AS t, avg(ProfileEvent_OSCPUWaitMicroseconds) / 1000000
FROM system.metric_log
WHERE event_date >= toDate(now() - {seconds:UInt32}) AND event_time >= now() - {seconds:UInt32}
GROUP BY t
ORDER BY t WITH FILL STEP {rounding:UInt32}

Row 3:
──────
dashboard: overview
title:     OS CPU Usage (Userspace)
query:     SELECT toStartOfInterval(event_time, INTERVAL {rounding:UInt32} SECOND)::INT AS t, avg(value)
FROM system.asynchronous_metric_log
WHERE event_date >= toDate(now() - {seconds:UInt32}) AND event_time >= now() - {seconds:UInt32} AND metric = 'OSUserTimeNormalized'
GROUP BY t
ORDER BY t WITH FILL STEP {rounding:UInt32}

Row 4:
──────
dashboard: overview
title:     OS CPU Usage (Kernel)
query:     SELECT toStartOfInterval(event_time, INTERVAL {rounding:UInt32} SECOND)::INT AS t, avg(value)
FROM system.asynchronous_metric_log
WHERE event_date >= toDate(now() - {seconds:UInt32}) AND event_time >= now() - {seconds:UInt32} AND metric = 'OSSystemTimeNormalized'
GROUP BY t
ORDER BY t WITH FILL STEP {rounding:UInt32}
```