Re: improve EXPLAIN for wide tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: improve EXPLAIN for wide tables
Date
Msg-id 2033734.1734388914@sss.pgh.pa.us
Whole thread Raw
In response to Re: improve EXPLAIN for wide tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I had a thought about this: I don't think EXPLAIN is ever required
to print the names of join alias variables (since the planner flattens
all join alias variables to some kind of expression over their
underlying columns).  So we could skip assigning column names to
join RTEs at all, if we know that it's EXPLAIN rather than view/rule
decompilation.  That might let us skip all the mess around
unique-ifying JOIN USING column names, too.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Crash: invalid DSA memory alloc request
Next
From: Peter Smith
Date:
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation