D1 Query Meta

Schema for d1_query-meta

DatabaseSQLiteServerlessEdge ComputingSQLCloudflareWorkers

Properties

Name	Type	Description
changed_db	boolean	Denotes if the database has been altered in some way, like deleting rows.
changes	number	Rough indication of how many rows were modified by the query, as provided by SQLite's `sqlite3_total_changes()`.
duration	number	The duration of the SQL query execution inside the database. Does not include any network communication.
last_row_id	number	The row ID of the last inserted row in a table with an `INTEGER PRIMARY KEY` as provided by SQLite. Tables created with `WITHOUT ROWID` do not populate this.
rows_read	number	Number of rows read during the SQL query execution, including indices (not all rows are necessarily returned).
rows_written	number	Number of rows written during the SQL query execution, including indices.
served_by_colo	object
served_by_primary	boolean	Denotes if the query has been handled by the database primary instance.
served_by_region	object
size_after	number	Size of the database after the query committed, in bytes.
timings	object	Various durations for the query.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "$id": "https://raw.githubusercontent.com/api-evangelist/cloudflare-d1/main/json-schema/d1_query-meta.json",
  "title": "D1 Query Meta",
  "description": "Schema for d1_query-meta",
  "properties": {
    "changed_db": {
      "description": "Denotes if the database has been altered in some way, like deleting rows.",
      "type": "boolean",
      "x-auditable": true
    },
    "changes": {
      "description": "Rough indication of how many rows were modified by the query, as provided by SQLite's `sqlite3_total_changes()`.",
      "type": "number",
      "x-auditable": true
    },
    "duration": {
      "description": "The duration of the SQL query execution inside the database. Does not include any network communication.",
      "type": "number",
      "x-auditable": true
    },
    "last_row_id": {
      "description": "The row ID of the last inserted row in a table with an `INTEGER PRIMARY KEY` as provided by SQLite. Tables created with `WITHOUT ROWID` do not populate this.",
      "type": "number",
      "x-auditable": true
    },
    "rows_read": {
      "description": "Number of rows read during the SQL query execution, including indices (not all rows are necessarily returned).",
      "type": "number",
      "x-auditable": true
    },
    "rows_written": {
      "description": "Number of rows written during the SQL query execution, including indices.",
      "type": "number",
      "x-auditable": true
    },
    "served_by_colo": {
      "$ref": "#/components/schemas/d1_served-by-colo"
    },
    "served_by_primary": {
      "description": "Denotes if the query has been handled by the database primary instance.",
      "type": "boolean",
      "x-auditable": true
    },
    "served_by_region": {
      "$ref": "#/components/schemas/d1_served-by-region"
    },
    "size_after": {
      "description": "Size of the database after the query committed, in bytes.",
      "type": "number",
      "x-auditable": true
    },
    "timings": {
      "description": "Various durations for the query.",
      "properties": {
        "sql_duration_ms": {
          "description": "The duration of the SQL query execution inside the database. Does not include any network communication.",
          "type": "number",
          "x-auditable": true
        }
      },
      "type": "object"
    }
  },
  "type": "object"
}