MySQL & MariaDB
EXPLAIN FORMAT=JSON SELECT * FROM orders WHERE status = 'paid';
-- or MySQL 8.0.18+ actual timings:
EXPLAIN ANALYZE SELECT * FROM orders WHERE status = 'paid';Supports both EXPLAIN FORMAT=JSON (MySQL & MariaDB) and EXPLAIN ANALYZE tree text.