SHOW ANALYZE If you ever had to do query performance troubleshooting with MariaDB, you should be familiar with MariaDB’s ANALYZE for statements feature. It does what EXPLAIN ANALYZE does in some other database systems: ANALYZE query runs the query and produces EXPLAIN output, amended with the data from the query execution: There is also the … Continue reading 10.9 preview feature: SHOW ANALYZE and EXPLAIN FOR CONNECTION support