Opened 5 years ago
Last modified 4 years ago
#30897 closed New feature
Improved QuerySet.explain() for newer versions of MariaDB, MySQL and PostgreSQL. — at Version 3
Reported by: | Nick Pope | Owned by: | Nick Pope |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | Normal | Keywords: | explain, analyze, mariadb, mysql, postgresql |
Cc: | Triage Stage: | Ready for checkin | |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description (last modified by )
- MySQL 8.0.16+ has support for EXPLAIN FORMAT=TREE.
- MySQL 8.0.18+ has support for EXPLAIN ANALYZE.
- MariaDB 10.1.0+ has support for ANALYZE. (Was
EXPLAIN ANALYZE
before 10.1.0.) - PostgreSQL 12+ has support for a new SETTINGS option to
EXPLAIN
.
Change History (3)
comment:1 by , 5 years ago
Has patch: | set |
---|
comment:2 by , 5 years ago
Triage Stage: | Unreviewed → Accepted |
---|
comment:3 by , 5 years ago
Description: | modified (diff) |
---|---|
Keywords: | postgresql added |
Summary: | Improved QuerySet.explain() for newer versions of MariaDB and MySQL. → Improved QuerySet.explain() for newer versions of MariaDB, MySQL and PostgreSQL. |
Note:
See TracTickets
for help on using tickets.
PR