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 по дате отправления:

Предыдущее
От: "Crowson, Sarah J Ms (Contractor) Northrop Grumman"
Дата:
Сообщение: on Server Status (Status) window (UN CLASSIFIED)
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: on Server Status (Status) window (UNCLASSIFIED)