Use Query Explain

Query Explain lets you submit Datastore mode queries to the backend and receive detailed performance statistics on backend query execution in return. It functions like the EXPLAIN ANALYZE operation in many relational database systems.

You can send Query Explain requests using the Datastore mode client libraries.

Query Explain results help you understand how your queries are executed, showing you inefficiencies and the location of likely server-side bottlenecks.

Query Explain:

  • Provides insights on planning phase so you can adjust your query indexes and boost efficiency.
  • Helps you understand your cost and performance on a per-query basis and lets you quickly iterate through different query patterns in order to optimize their usage.