ArangoDB v3.10 reached End of Life (EOL) and is no longer supported.

This documentation is outdated. Please see the most recent stable version.

AQL Execution and Performance

This chapter describes AQL features related to query execution and query performance

Query statistics

All queries that have successfully run to completion return statistics about the execution

Parsing queries

Clients can check if given AQL queries are syntactically valid using an HTTP API or JavaScript API

Explaining queries

You can explain and profile AQL queries to inspect the execution plans and to understand the performance characteristics, as well as create debug packages for reporting issues

Query Profiling

For understanding the performance of specific queries, you can profile them to identify slow parts of query execution plans

Query Optimization

AQL queries are sent through an optimizer before execution that creates an initial execution plan, looks for optimization opportunities, and applies them

Caching query results

AQL provides an optional query results cache in single server deployments