Re: EXPLAIN omits schema? - Mailing list pgsql-hackers

From Dave Page
Subject Re: EXPLAIN omits schema?
Date
Msg-id 467002FD.5000802@postgresql.org
Whole thread Raw
In response to Re: EXPLAIN omits schema?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> As already noted, it'd usually be clutter in lines that are too long
> already.  Also, conditionally adding a schema name isn't very good
> because it makes life even more complicated for programs that are
> parsing EXPLAIN output (yes, there are some).

Well, yes - that's precisely what pgAdmin does, which is why I'd want to 
see the schema name all the time. Up until now though all we've done is 
graphically represent the plan, so the object names haven't really been 
an issue. To take that further and allow the user to drill down to 
further information, or to provide tools to help tune queries we need to 
know for certain what table we're dealing with.

Regards, Dave



pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: EXPLAIN omits schema?
Next
From: Andrew Dunstan
Date:
Subject: Re: EXPLAIN omits schema?