Cloudflare Docs
D1
Cloudflare Docs
D1
GitHub icon
Visit D1 on GitHub
Set theme to dark (⇧+D)
  1. Products
  2. D1
  3. Platform
  4. Metrics and analytics

Metrics and analytics

D1 exposes database analytics that allow you to inspect query volume, response size, and query latency across all and/or each database in your account.

The metrics displayed in the Cloudflare dashboard charts are queried from Cloudflare’s GraphQL Analytics API. You can access the metrics programmatically via GraphQL or HTTP client.

​​ Metrics

D1 currently exports the below metrics:

Metric GraphQL Field Name Description
Read Queries (qps) readQueries The number of read queries issued against a database. This is the raw number of read queries, and is not used for billing.
Write Queries (qps) writeQueries The number of write queries issued against a database. This is the raw number of write queries, and is not used for billing.
Query Response (bytes) queryBatchResponseBytes The total response size of the serialized query response, including any/all column names, rows and metadata. Reported in bytes.
Query Latency (ms) queryBatchTimeMs The total query response time, including response serialization, on the server-side. Reported in milliseconds.

Metrics can be queried (and are retained) for the past 31 days.

​​ View via the dashboard

Per-database analytics for D1 are available in the Cloudflare dashboard. To view current and historical metrics for a database:

  1. Log in to the Cloudflare dashboard and select your account.
  2. Go to Workers & Pages > D1.
  3. Select an existing database.
  4. Select the Metrics tab.

You can optionally select a time window to query. This defaults to the last 24 hours.

​​ Query via the GraphQL API

You can programmatically query analytics for your D1 databases via the GraphQL Analytics API. This API queries the same dataset as the Cloudflare dashboard, and supports GraphQL introspection.

D1’s GraphQL dataset is d1AnalyticsAdaptiveGroups and requires an accountTag filter with your Cloudflare account ID.

​​ Examples

To query the sum of readQueries, writeQueries for a given $databaseId, grouping by databaseId and date:


query {
	viewer {
		accounts(filter: { accountTag: $accountId }) {
			d1AnalyticsAdaptiveGroups(
				limit: 10000
				filter: {
					date_geq: $startDate
					date_leq: $endDate
					databaseId: $databaseId
				}
				orderBy: [date_DESC]
			) {
				sum {
					readQueries
					writeQueries
				}
				dimensions {
					date
					databaseId
				} 
			}
		}
	}

}

To query both the average queryBatchTimeMs and the 90th percentile queryBatchTimeMs per database:


query {
	viewer {
		accounts(filter: { accountTag: $accountId }) {
			d1AnalyticsAdaptiveGroups(
				limit: 10000
				filter: {
					date_geq: $startDate
					date_leq: $endDate
					databaseId: $databaseId
				}
				orderBy: [date_DESC]
			) {
				quantiles {
					queryBatchTimeMsP90
				}
				dimensions {
					date
					databaseId
				} 
			}
		}
	}

}

To query your account-wide readQueries and writeQueries:


query {
	viewer {
		accounts(filter: { accountTag: $accountId }) {
			d1AnalyticsAdaptiveGroups(
				limit: 10000
				filter: {
					date_geq: $startDate
					date_leq: $endDate
					databaseId: $databaseId
				}
			) {
				sum {
					readQueries
					writeQueries
				}
			}
		}
	}

}