Re: improve EXPLAIN for wide tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: improve EXPLAIN for wide tables
Date: 2024-12-16 16:21:23
Message-ID: 1980561.1734366083@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sami Imseih <samimseih(at)gmail(dot)com> writes:
> Looking further into this improvement, I started to question if it is
> necessary to make columns unique for EXPLAIN purposes?

Yes, otherwise references to them elsewhere in the plan will be
ambiguous.

It looks like your proposal tries to dodge that by unique-ifying
in some cases but not others, which strikes me as a totally
random and confusing thing to do.

Is there any reason to think that 52c707483 wasn't a sufficient
response to this issue?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2024-12-16 16:40:59 Re: Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS
Previous Message Sami Imseih 2024-12-16 16:07:42 improve EXPLAIN for wide tables