Firestore Enterprise edition with MongoDB compatibility is now available! Learn more.

Query Explain report reference
Stay organized with collections Save and categorize content based on your preferences.

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.

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)`.

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.

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".