# Premium Prometheus Metrics

| metric_name | labels | promql | example | code_ref |
| --- | --- | --- | --- | --- |
| `tidbcloud_db_total_connection` | `instance_id, instance_name` | `sum(tidb_server_connections{tidb_cluster_id="<cluster_id>"})` | `tidbcloud_db_total_connection{instance_id="70001",instance_name="premium-demo"} 42` | `QueryDBTotalConnection`, `BuildDBTotalConnectionQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_active_connections` | `instance_id, instance_name` | `sum(tidb_server_tokens{tidb_cluster_id="<cluster_id>"})` | `tidbcloud_db_active_connections{instance_id="70001",instance_name="premium-demo"} 9` | `QueryDBActiveConnections`, `BuildDBActiveConnectionsQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_disconnections` | `result, instance_id, instance_name` | `sum(rate(tidb_server_disconnection_total{tidb_cluster_id="<cluster_id>"}[2m])) by (result)` | `tidbcloud_db_disconnections{result="ok",instance_id="70001",instance_name="premium-demo"} 0.2` | `QueryDBDisconnections`, `BuildDBDisconnectionsQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_database_time` | `sql_type, instance_id, instance_name` | `sum(rate(tidb_server_handle_query_duration_seconds_sum{tidb_cluster_id="<cluster_id>", sql_type!="internal"}[2m])) by (sql_type)` | `tidbcloud_db_database_time{sql_type="Select",instance_id="70001",instance_name="premium-demo"} 1.6` | `QueryDBDatabaseTime`, `BuildDBDatabaseTimeQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_query_per_second` | `type, instance_id, instance_name` | `sum(rate(tidb_executor_statement_total{tidb_cluster_id="<cluster_id>"}[2m])) by (type)` | `tidbcloud_db_query_per_second{type="Select",instance_id="70001",instance_name="premium-demo"} 120` | `QueryDBQueryPerSecond`, `BuildDBQueryPerSecondQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_failed_queries` | `type, instance_id, instance_name` | `sum(rate(tidb_server_execute_error_total{tidb_cluster_id="<cluster_id>"}[2m])) by (type)` | `tidbcloud_db_failed_queries{type="planner",instance_id="70001",instance_name="premium-demo"} 0.05` | `QueryDBFailedQueries`, `BuildDBFailedQueriesQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_command_per_second` | `type, instance_id, instance_name` | `sum(rate(tidb_server_query_total{tidb_cluster_id="<cluster_id>"}[2m])) by (type)` | `tidbcloud_db_command_per_second{type="Query",instance_id="70001",instance_name="premium-demo"} 140` | `QueryDBCommandPerSecond`, `BuildDBCommandPerSecondQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_queries_using_plan_cache_ops` | `type, instance_id, instance_name` | `sum(rate(tidb_server_plan_cache_total{tidb_cluster_id="<cluster_id>"}[2m])) by (type)` | `tidbcloud_db_queries_using_plan_cache_ops{type="prepared",instance_id="70001",instance_name="premium-demo"} 18` | `QueryDBQueriesUsingPlanCacheOps`, `BuildDBQueriesUsingPlanCacheOpsQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_average_query_duration` | `sql_type, instance_id, instance_name` | `sum(rate(tidb_server_handle_query_duration_seconds_sum{tidb_cluster_id="<cluster_id>", sql_type!="internal"}[2m])) by (sql_type) / sum(rate(tidb_server_handle_query_duration_seconds_count{tidb_cluster_id="<cluster_id>", sql_type!="internal"}[2m])) by (sql_type) > 0` | `tidbcloud_db_average_query_duration{sql_type="Select",instance_id="70001",instance_name="premium-demo"} 0.013` | `QueryDBAverageQueryDuration`, `BuildDBAverageQueryDurationQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_transaction_per_second` | `txn_mode, type, instance_id, instance_name` | `sum(rate(tidb_session_transaction_duration_seconds_count{tidb_cluster_id="<cluster_id>", scope=~"general"}[2m])) by (type, txn_mode)` | `tidbcloud_db_transaction_per_second{txn_mode="optimistic",type="commit",instance_id="70001",instance_name="premium-demo"} 23` | `QueryDBTransactionPerSecond`, `BuildDBTransactionPerSecondQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_changefeed_latency` | `changefeed_id, instance_id, instance_name` | `max by(changefeed) (ticdc_owner_checkpoint_ts_lag{tidb_cluster_id="<cluster_id>", changefeed!=""})` | `tidbcloud_changefeed_latency{changefeed_id="cf-01",instance_id="70001",instance_name="premium-demo"} 4` | `QueryTiCDCLatencySeconds`, `BuildTiCDCLatencyQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_changefeed_checkpoint_ts` | `changefeed_id, instance_id, instance_name` | `max by(changefeed) (ticdc_owner_checkpoint_ts{tidb_cluster_id="<cluster_id>", changefeed!=""})` | `tidbcloud_changefeed_checkpoint_ts{changefeed_id="cf-01",instance_id="70001",instance_name="premium-demo"} 4523456789012345` | `QueryTiCDCCheckpointTS`, `BuildTiCDCCheckpointTSQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_changefeed_status` | `changefeed_id, instance_id, instance_name` | `max by(changefeed) (ticdc_owner_status{tidb_cluster_id="<cluster_id>", changefeed!=""})` | `tidbcloud_changefeed_status{changefeed_id="cf-01",instance_id="70001",instance_name="premium-demo"} 1` | `QueryChangefeedStatus`, `BuildChangefeedStatusQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_changefeed_Replica_rows` | `changefeed_id, instance_id, instance_name` | `sum by(changefeed) (rate(ticdc_sink_total_flushed_rows_count{tidb_cluster_id="<cluster_id>", changefeed!=""}[1m])) or sum by(changefeed) (rate(ticdc_sinkv2_batch_row_count_sum{tidb_cluster_id="<cluster_id>", changefeed!=""}[1m])) or sum by(changefeed) (rate(ticdc_sink_batch_row_count_sum{tidb_cluster_id="<cluster_id>", changefeed!=""}[1m]))` | `tidbcloud_changefeed_Replica_rows{changefeed_id="cf-01",instance_id="70001",instance_name="premium-demo"} 860` | `QueryTiCDCReplicaRowsPerSecond`, `BuildTiCDCReplicaRowsQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_ticdc_owner_resolved_ts_lag` | `changefeed_id, instance_id, instance_name` | `max by(changefeed) (ticdc_owner_resolved_ts_lag{tidb_cluster_id="<cluster_id>", changefeed!=""})` | `tidbcloud_ticdc_owner_resolved_ts_lag{changefeed_id="cf-01",instance_id="70001",instance_name="premium-demo"} 2` | `QueryTiCDCResolvedTS`, `BuildTiCDCChangefeedResolvedTsLagQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_resource_manager_resource_unit_read_request_unit` | `resource_group, instance_id, instance_name` | `rate(resource_manager_resource_unit_read_request_unit_sum{tidb_cluster_id=~".*<cluster_id>", type=~"|tp"}[2m])` | `tidbcloud_resource_manager_resource_unit_read_request_unit{resource_group="default",instance_id="70001",instance_name="premium-demo"} 12.5` | `QueryRURead`, `BuildRUReadQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_resource_manager_resource_unit_write_request_unit` | `resource_group, instance_id, instance_name` | `rate(resource_manager_resource_unit_write_request_unit_sum{tidb_cluster_id=~".*<cluster_id>", type=~"|tp"}[2m])` | `tidbcloud_resource_manager_resource_unit_write_request_unit{resource_group="default",instance_id="70001",instance_name="premium-demo"} 6.5` | `QueryRUWrite`, `BuildRUWriteQuerier`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_row_storage_used_bytes` | `instance_id, instance_name` | `quantile_over_time(0.5, sum(avg by(keyspace_id, region_id) (tikv_store_size_bytes{tidb_cluster_id="<cluster_id>", type="used"}))[5m]) or vector(0)` | `tidbcloud_db_row_storage_used_bytes{instance_id="70001",instance_name="premium-demo"} 128849018880` | `QueryDBRowStorageUsedBytes`, `buildNextGenStorageUsagePromQL`, `BuildDBRowStorageUsedBytesQuerier`, `clusterLabels`, `VecMetric.asInstanceLevelElement` |
| `tidbcloud_db_columnar_storage_used_bytes` | `instance_id, instance_name` | `quantile_over_time(0.5, sum(avg by(keyspace_id, region_id) (tikv_store_size_bytes{tidb_cluster_id="<cluster_id>", type="tiflash_used"}))[5m]) or vector(0)` | `tidbcloud_db_columnar_storage_used_bytes{instance_id="70001",instance_name="premium-demo"} 34359738368` | `QueryDBColumnarStorageUsedBytes`, `buildNextGenStorageUsagePromQL`, `BuildDBColumnarStorageUsedBytesQuerier`, `clusterLabels`, `VecMetric.asInstanceLevelElement` |