Get time-series metrics for SQL queries
Authorization
A service token or OAuth token must have at least one of the following access or scopes in order to use this API endpoint:
Service Token Accesses
read_branch, delete_branch, create_branch, connect_production_branch, connect_branch
OAuth Scopes
| Resource | Scopes |
|---|---|
| Organization | read_branches |
| Database | read_branches |
| Branch | read_branch |
Authorizations
The access token received from the authorization server in the OAuth 2.0 flow.
Path Parameters
Organization name slug from list_organizations. Example: acme.
Database name slug from list_databases. Example: app-db.
Branch name from list_branches. Example: main.
Query Parameters
Metric names to retrieve
avg_parallel_workers, avg_shard_queries, block_cache_hit_ratio, blocks_dirtied, blocks_hit, blocks_read, blocks_written, cpu_duration_millis, egress_bytes, egress_bytes_per_query, index_usage_percent, ingress_bytes, ingress_bytes_per_query, io_duration_millis, latency_max, latency_min, latency_p50, latency_p95, latency_p99, latency_p999, max_egress_bytes, max_ingress_bytes, max_shard_queries, plan_change_score, queries, query_errors, routing_index_usage_percent, rows_affected_per_query, rows_read, rows_read_per_query, rows_read_per_returned, rows_returned, rows_returned_per_query, rows_written, total_duration_millis, traffic_control_throttled, traffic_control_warnings Query pattern IDs to retrieve metrics for
Filter by query fingerprint
Keyspace for the query fingerprint
Named time period to retrieve. Defaults to 12h.
15m, 1h, 3h, 6h, 12h, 1d, 2d, 7d, 8d Start of a custom time range as an ISO 8601 timestamp
End of a custom time range as an ISO 8601 timestamp
Number of data points to return
Filter by tablet type
primary, replica, rdonly Filter by traffic budget ID
Filter by traffic rule ID
Filter by search terms

