id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30897	Improved QuerySet.explain() for newer versions of MariaDB, MySQL and PostgreSQL.	Nick Pope	Nick Pope	"- MySQL 8.0.16+ has support for [https://dev.mysql.com/doc/refman/8.0/en/explain.html#explain-execution-plan EXPLAIN FORMAT=TREE].
- MySQL 8.0.18+ has support for [https://dev.mysql.com/doc/refman/8.0/en/explain.html#explain-analyze EXPLAIN ANALYZE].
- MariaDB 10.1.0+ has support for [https://mariadb.com/kb/en/library/analyze-statement/ ANALYZE]. (Was `EXPLAIN ANALYZE` before 10.1.0.)
- PostgreSQL 12+ has support for a new [https://www.postgresql.org/docs/12/sql-explain.html#SQL-EXPLAIN SETTINGS] option to `EXPLAIN`.

**Updated 2020-08-24:**

- MySQL 8.0.21+ has support for [https://dev.mysql.com/doc/refman/8.0/en/explain.html#explain-analyze EXPLAIN ANALYZE FORMAT=TREE].
  - **Note:** We are not removing restriction on use of `ANALYZE` with `FORMAT` until more than one format is supported with this combination of options. (See [https://github.com/django/django/pull/13333#pullrequestreview-473197627 review].)
- PostgreSQL 13+ has support for a new [https://www.postgresql.org/docs/13/sql-explain.html#SQL-EXPLAIN WAL] option to `EXPLAIN`. ''(Note: Requires `ANALYZE` option.)''"	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed	explain, analyze, mariadb, mysql, postgresql		Ready for checkin	1	0	0	0	0	0