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

# Mapping of metrics used in system.dashboards to Prometheus metrics in `system.custom_metrics`

> Mapping of metrics used in system.dashboards to Prometheus metrics in system.custom_metrics

<h2 id="mapping-of-metrics-used-in-systemdashboards-to-prometheus-metrics-in-systemcustom_metrics">
  Mapping of metrics used in system.dashboards to Prometheus metrics in `system.custom_metrics`
</h2>

The table below provides the mapping for the metrics used in `system.dashboards` to Prometheus metrics in `system.custom_metrics`.\
This is useful for customers who want to monitor for the same metrics found in `system.dashboards`.

<h3 id="mapping-table-for-metrics-in-systemdashboards-to-prometheus-metrics-in-systemcustom_metrics">
  Mapping table for metrics in system.dashboards to Prometheus metrics in system.custom\_metrics
</h3>

| Dashboard | Title | Prometheus Metric Name (system.custom\_metrics) |
| - | - | - |
| Overview | Queries/second | ClickHouseProfileEvents\_Query |
| Overview | CPU Usage (cores) | ClickHouseProfileEvents\_OSCPUVirtualTimeMicroseconds |
| Overview | Queries Running | ClickHouseMetrics\_Query |
| Overview | Merges Running | ClickHouseMetrics\_Merge |
| Overview | Selected Bytes/second | ClickHouseProfileEvents\_SelectedBytes |
| Overview | IO Wait | ClickHouseProfileEvents\_OSIOWaitMicroseconds |
| Overview | CPU Wait | ClickHouseProfileEvents\_OSCPUWaitMicroseconds |
| Overview | OS CPU Usage (Userspace) | ClickHouseAsyncMetrics\_OSUserTimeNormalized |
| Overview | OS CPU Usage (Kernel) | ClickHouseAsyncMetrics\_OSSystemTimeNormalized |
| Overview | Read From Disk | ClickHouseProfileEvents\_OSReadBytes |
| Overview | Read From Filesystem | ClickHouseProfileEvents\_OSReadChars |
| Overview | Memory (tracked) | ClickHouseMetrics\_MemoryTracking |
| Overview | Load Average (15 minutes) | ClickHouseAsyncMetrics\_LoadAverage15 |
| Overview | Selected Rows/second | ClickHouseProfileEvents\_SelectedRows |
| Overview | Inserted Rows/second | ClickHouseProfileEvents\_InsertedRows |
| Overview | Total MergeTree Parts | ClickHouseAsyncMetrics\_TotalPartsOfMergeTreeTables |
| Overview | Max Parts For Partition | ClickHouseAsyncMetrics\_MaxPartCountForPartition |
| Cloud overview | Queries/second | ClickHouseProfileEvents\_Query |
| Cloud overview | CPU Usage (cores) | ClickHouseProfileEvents\_OSCPUVirtualTimeMicroseconds |
| Cloud overview | Queries Running | ClickHouseMetrics\_Query |
| Cloud overview | Merges Running | ClickHouseMetrics\_Merge |
| Cloud overview | Selected Bytes/second | ClickHouseProfileEvents\_SelectedBytes |
| Cloud overview | IO Wait (local fs) | ClickHouseProfileEvents\_OSIOWaitMicroseconds |
| Cloud overview | S3 read wait | ClickHouseProfileEvents\_ReadBufferFromS3Microseconds |
| Cloud overview | S3 read errors/sec | ProfileEvent\_ReadBufferFromS3RequestsErrors |
| Cloud overview | CPU Wait | ClickHouseProfileEvents\_OSCPUWaitMicroseconds |
| Cloud overview | OS CPU Usage (Userspace, normalized) | ClickHouseAsyncMetrics\_OSUserTimeNormalized |
| Cloud overview | OS CPU Usage (Kernel, normalized) | ClickHouseAsyncMetrics\_OSSystemTimeNormalized |
| Cloud overview | Read From Disk (bytes/sec) | ClickHouseProfileEvents\_OSReadBytes |
| Cloud overview | Read From Filesystem (bytes/sec) | ClickHouseProfileEvents\_OSReadChars |
| Cloud overview | Memory (tracked, bytes) | ClickHouseMetrics\_MemoryTracking |
| Cloud overview | Load Average (15 minutes) | ClickHouseAsyncMetrics\_LoadAverage15 |
| Cloud overview | Selected Rows/sec | ClickHouseProfileEvents\_SelectedRows |
| Cloud overview | Inserted Rows/sec | ClickHouseProfileEvents\_InsertedRows |
| Cloud overview | Total MergeTree Parts | ClickHouseAsyncMetrics\_TotalPartsOfMergeTreeTables |
| Cloud overview | Max Parts For Partition | ClickHouseAsyncMetrics\_MaxPartCountForPartition |
| Cloud overview | Read From S3 (bytes/sec) | ClickHouseProfileEvents\_ReadBufferFromS3Bytes |
| Cloud overview | Filesystem Cache Size | ClickHouseMetrics\_FilesystemCacheSize |
| Cloud overview | Disk S3 write req/sec | ClickHouseProfileEvents\_DiskS3PutObject + ClickHouseProfileEvents\_DiskS3UploadPart + ClickHouseProfileEvents\_DiskS3CreateMultipartUpload + ClickHouseProfileEvents\_DiskS3CompleteMultipartUpload |
| Cloud overview | Disk S3 read req/sec | ClickHouseProfileEvents\_DiskS3GetObject + ClickHouseProfileEvents\_DiskS3HeadObject + ClickHouseProfileEvents\_DiskS3ListObjects |
| Cloud overview | FS cache hit rate | ClickHouseProfileEvents\_CachedReadBufferReadFromCacheBytes / (ClickHouseProfileEvents\_CachedReadBufferReadFromCacheBytes + ClickHouseProfileEvents\_CachedReadBufferReadFromSourceBytes) |
| Cloud overview | Page cache hit rate | greatest(0, (sum(ClickHouseProfileEvents\_OSReadChars) - sum(ClickHouseProfileEvents\_OSReadBytes)) /  (sum(ClickHouseProfileEvents\_OSReadChars) + sum(ClickHouseProfileEvents\_ReadBufferFromS3Bytes))) |
| Cloud overview | Network receive bytes/sec | ClickHouseProfileEvents\_NetworkReceiveBytes |
| Cloud overview | Network send bytes/sec | ClickHouseProfileEvents\_NetworkSendBytes |

Related links:\
[https://clickhouse.com/docs/integrations/prometheus](https://clickhouse.com/docs/integrations/prometheus)