[Django] #35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL 17+.

19 views
Skip to first unread message

Django

unread,
Oct 21, 2024, 5:37:10 PM10/21/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz | Owner: Mariusz Felisiak
Felisiak |
Type: New | Status: assigned
feature |
Component: Database | Version: dev
layer (models, ORM) |
Severity: Normal | Keywords: postgreSQL
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
PostgreSQL 17 added support for the `MEMORY`/`SERIALIZE` option to
`EXPLAIN`, check out
​[https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-EXPLAIN
release notes].
--
Ticket URL: <https://code.djangoproject.com/ticket/35856>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Oct 21, 2024, 6:51:48 PM10/21/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgreSQL | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Natalia Bidart):

* stage: Unreviewed => Accepted

Comment:

Sounds good, thank you for the report Mariusz! Would you like to prepare a
patch?
--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:1>

Django

unread,
Oct 22, 2024, 1:52:25 AM10/22/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgreSQL | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Mariusz Felisiak):

Replying to [comment:1 Natalia Bidart]:
> Sounds good, thank you for the report Mariusz! Would you like to prepare
a patch?

Yes, or one of my Djangonauts would do this. I've already assigned it to
myself.
--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:2>

Django

unread,
Oct 22, 2024, 8:10:52 AM10/22/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: ajosephau
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgreSQL | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by ajosephau):

* owner: Mariusz Felisiak => ajosephau

--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:3>

Django

unread,
Oct 22, 2024, 11:56:27 AM10/22/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Anthony
| Joseph
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgreSQL | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* cc: Mariusz Felisiak (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:4>

Django

unread,
Oct 23, 2024, 9:45:45 PM10/23/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Anthony
| Joseph
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgreSQL | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Anthony Joseph):

* has_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:5>

Django

unread,
Oct 24, 2024, 10:08:16 AM10/24/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Anthony
| Joseph
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgreSQL | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* needs_better_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:6>

Django

unread,
Oct 29, 2024, 3:58:05 PM10/29/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Anthony
| Joseph
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgreSQL | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* needs_better_patch: 1 => 0
* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:7>

Django

unread,
Oct 30, 2024, 10:54:58 AM10/30/24
to django-...@googlegroups.com
#35856: Add support for MEMORY/SERIALIZE option to QuerySet.explain() on PostgreSQL
17+.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Anthony
| Joseph
Type: New feature | Status: closed
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: postgreSQL | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sarah Boyce <42296566+sarahboyce@…>):

* resolution: => fixed
* status: assigned => closed

Comment:

In [changeset:"3a8f52fbc6fe2ff646a2da4165497d82117e4a92" 3a8f52f]:
{{{#!CommitTicketReference repository=""
revision="3a8f52fbc6fe2ff646a2da4165497d82117e4a92"
Fixed #35856 -- Added QuerySet.explain() support for MEMORY/SERIALIZE
option on PostgreSQL 17+.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35856#comment:8>
Reply all
Reply to author
Forward
0 new messages