#30897 closed New feature (fixed)
Improved QuerySet.explain() for newer versions of MariaDB, MySQL and PostgreSQL. — at Version 12
| 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 ANALYZEbefore 10.1.0.) - PostgreSQL 12+ has support for a new SETTINGS option to
EXPLAIN.
Updated 2020-08-20:
- MySQL 8.0.21+ has support for EXPLAIN ANALYZE FORMAT=TREE.
- PostgreSQL 13+ has support for a new WAL option to
EXPLAIN.
Change History (12)
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. |
comment:4 by , 5 years ago
| Needs tests: | set |
|---|---|
| Patch needs improvement: | set |
comment:6 by , 5 years ago
| Needs tests: | unset |
|---|---|
| Patch needs improvement: | unset |
Patch improved, tests added.
comment:7 by , 5 years ago
| Triage Stage: | Accepted → Ready for checkin |
|---|
comment:11 by , 5 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
comment:12 by , 4 years ago
| Description: | modified (diff) |
|---|
Note:
See TracTickets
for help on using tickets.
PR