Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
EXPLAIN feature request
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: pgsql-hackers(at)postgresql(dot)org
- Subject: EXPLAIN feature request
- Date: Thu, 31 May 2007 14:03:04 -0700
- Message-id: <465F3808.4060504@commandprompt.com> <text/plain>
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/
- Prev by Date: Hash joins vs small-integer join values
- Next by Date: Re: Command tags in create/drop scripts
- Previous by thread: Hash joins vs small-integer join values
- Indexes: