Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Diagram 'Explain query' incorrect display of "InitPlan"



At current time "InitPlan" display as last part
of explain diagram.
See below sample output for check incorrect diagram
--------------------
Limit  (cost=9.86..180.39 rows=22 width=55)
  InitPlan
    ->  Index Scan using pw_ux on pw  (cost=0.00..4.93 rows=1 width=4)
          Index Cond: (wr = '30'::text)
    ->  Index Scan using pw_ux on pw  (cost=0.00..4.93 rows=1 width=4)
          Index Cond: (wr = 'day'::text)
  ->  Nested Loop  (cost=0.00..24362.63 rows=3143 width=55)
        ->  Nested Loop  (cost=0.00..11528.88 rows=3143 width=12)
              ->  Nested Loop  (cost=0.00..37.01 rows=1 width=12)
                    ->  Nested Loop  (cost=0.00..33.77 rows=1 width=8)
                          ->  Index Scan using wwl_pk on wwl w1  
(cost=0.00..13.73 rows=4 width=4)
                                Index Cond: (wid = $0)
                          ->  Index Scan using wwl_pk on wwl w2  
(cost=0.00..5.00 rows=1 width=4)
                                Index Cond: ((w2.wid = $1) AND 
("outer".wid = w2.wid))
                    ->  Index Scan using w_pk on warranty  
(cost=0.00..3.23 rows=1 width=4)
                          Index Cond: ("outer".wid = w.wid)
              ->  Index Scan using fki_wid on pr  
(cost=0.00..10915.45 rows=46113 width=16)
                    Index Cond: ("outer".wid = pr.wid)
        ->  Index Scan using nid_pk on p_n  (cost=0.00..4.07 rows=1 
width=51)
              Index Cond: ("outer".nid = p_n.nid)
----------------------

Best regards,
 Alexander Kirpa




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group