The following values are returned as results to operations performed with Query Explain .
Plan records
| Key | Type | Subject to change? | Description |
|---|---|---|---|
|
indexes_used
|
List of Generic Structs | Yes, the contents in the Struct response are subject to change. | List of indexes selected for this query. See below . |
Indexes used
The contents of indexes used are subject to change as Datastore mode evolves.
| Key | Type | Description |
|---|---|---|
|
query_scope
|
String | The scope at which a query is run. For example Collection
, Collection Group
and Includes Ancestors
. |
|
properties
|
String | The index fields in a format, for example (age ASC, __name__ ASC)
. |
Execution statistics
Aggregated execution statistics for the query.
| Key | Type | Field subject to change? | Description |
|---|---|---|---|
|
results_returned
|
long | No | Total number of results returned, including entities, projections, aggregation results, keys. |
|
execution_duration
|
Duration | No | Total time to execute the query in the backend. |
|
read_operations
|
long | No | Total billable read operations. |
|
debug_stats
|
Generic Struct | Yes, the contents in the Struct response are subject to change. | Debugging statistics from the execution of the query. See below . |
Debug statistics
The following results are helpful for debugging use cases and analysis of raw, optional statistics.
The contents of debug stats are subject to change as Datastore mode evolves.
| Key | Type | Description |
|---|---|---|
|
index_entries_scanned
|
String | Total number of index entries inspected during the query. |
|
documents_scanned
|
String | Total number of documents scanned during the query. |
|
billing_details
|
Generic Struct | Billing details including metrics like: "documents_billable", "index_entries_billable", "min_query_cost". |

