Re: Proposal: Progressive explain

Rafael Thofehrn Castro <rafaelthca@gmail.com>

From: Rafael Thofehrn Castro <rafaelthca@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: torikoshia <torikoshia@oss.nttdata.com>, Andrei Lepikhov <lepihov@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2025-03-31T14:43:21Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add some new hooks so extensions can add details to EXPLAIN.
- 4fd02bf7cf94 18.0 cited

> I haven't looked into the code yet, but when I ran below commands during
> make installcheck, there was an error and an assertion failure

Thanks for the report. I actually made a nasty mistake in the last
patch after code refactoring, which is to not properly check that
a QueryDesc is already being tracked. So every subquery call
in the same query is allocating DSAs and those segments are not
being properly cleared. So the patch is broken and probably explains
your crashes.

Just made a 1 line fix and make installcheck looks clean now. Will
do more tests before sending another version.