Diagram 'Explain query' incorrect display of "InitPlan"
От | Alexander Kirpa |
---|---|
Тема | Diagram 'Explain query' incorrect display of "InitPlan" |
Дата | |
Msg-id | 4411E7EA.11324.294AEF4D@localhost обсуждение исходный текст |
Список | pgadmin-support |
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.88rows=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) -> IndexScan 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 usingfki_wid on pr (cost=0.00..10915.45 rows=46113 width=16) Index Cond: ("outer".wid = pr.wid) -> Index Scan usingnid_pk on p_n (cost=0.00..4.07 rows=1 width=51) Index Cond: ("outer".nid = p_n.nid) ---------------------- Best regards,Alexander Kirpa
В списке pgadmin-support по дате отправления: