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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
