Diagram 'Explain query' incorrect display of "InitPlan"

From: "Alexander Kirpa" <pgadmin(at)bilteks(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Diagram 'Explain query' incorrect display of "InitPlan"
Date: 2006-03-10 18:56:10
Message-ID: 4411E7EA.11324.294AEF4D@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.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

Browse pgadmin-support by date

  From Date Subject
Next Message Crowson, Sarah J Ms (Contractor) Northrop Grumman 2006-03-10 19:06:49 <command string not enabled> on Server Status (Status) window (UN CLASSIFIED)
Previous Message Dave Page 2006-03-10 14:47:50 Re: Edit grid crashes adding new rows to table with autoincrement primary key.