Cloudflare D1Install

Summary

Retrieve table statistics

Inputs

• databaseId (required) — The unique identifier of your Cloudflare D1 database. You can find this in your Cloudflare Dashboard under D1 databases.
• builderTable (required) — The table to query; select a table from the list or enter its name.

Output shape

an object containing table statistics such as row count, storage size, and column count

The response includes a success flag and the statistics data; additional metadata may be present but the result is not paginated.

Examples

Example 1: Obtain row count and storage size for the "users" table

Set Database ID to the target database, choose Table "users" in the builder, then execute Table Statistics.

Example 2: Check total storage usage of a large table

Select the desired table via the builder, provide the Database ID, and run Table Statistics.

Example 3: Get column count and distinct value metrics

Choose a table in the builder, enter the Database ID, and execute Table Statistics to receive aggregated metrics.