The following values are returned as results to operations performed with Firestore Query Explain.
Plan records
| Key | Type | Field 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 Cloud Firestore 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 documents, 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 statistics are subject to change as Cloud Firestore 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", "knn_vector_index_entries_billable", "min_query_cost". |
