EXPLAIN feature request - Mailing list pgsql-hackers

From Joshua D. Drake
Subject EXPLAIN feature request
Date
Msg-id 465F3808.4060504@commandprompt.com
Whole thread Raw
List pgsql-hackers
Hello,

-> INDEX Scan USING tickets_q1_import6 ON tickets_q1 tickets 
(cost=0.00..2.06 rows=1 width=0)
-> INDEX Scan USING tickets_q1_import6 ON tickets_q1 tickets 
(cost=0.00..2.06 rows=1 width=0)


Note that those are actually *2* different tables in different schemas. 
It would be great if it looked like this instead:

-> INDEX Scan USING tickets_q1_import6 ON foo.tickets_q1 public.tickets 
(cost=0.00..2.06 rows=1 width=0)
-> INDEX Scan USING tickets_q1_import6 ON bar.tickets_q1 public.tickets 
(cost=0.00..2.06 rows=1 width=0)

Sincerely,

Joshua D. Drake


-- 
      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Hash joins vs small-integer join values
Next
From: "CAJ CAJ"
Date:
Subject: Re: Command tags in create/drop scripts