explainQuery
Show the execution plan of a SQL query, with optional EXPLAIN ANALYZE on PostgreSQL and MySQL/MariaDB
Return the execution plan for a SQL query. Supports an optional analyze parameter for actual execution statistics on PostgreSQL and MySQL/MariaDB. EXPLAIN ANALYZE is only allowed for read-only statements (SELECT, SHOW) since it actually executes the query, even when read-only mode is disabled. Every EXPLAIN runs read-only (see Read-Only Transactions), so on MySQL/MariaDB plain EXPLAIN of write statements is rejected; PostgreSQL still plans them. SQLite always uses EXPLAIN QUERY PLAN and does not support ANALYZE. Always available regardless of read-only mode.