#30897: Improved QuerySet.explain() for newer versions of MariaDB, MySQL and
PostgreSQL.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: explain, analyze, | Triage Stage: Accepted
mariadb, mysql, postgresql |
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Nick Pope):
* keywords: explain, analyze, mariadb, mysql => explain, analyze, mariadb,
mysql, postgresql
Old description:
> - 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.)
New description:
- 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`.
--
--
Ticket URL: <https://code.djangoproject.com/ticket/30897#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/065.443cb4be130c6194f75f6e3dcab6dac1%40djangoproject.com.
