Обсуждение: index only scans are not shown graphically

Linux Mint 17

pdAdminIII 1.18.1 Jan 21 2014


select id from incremental where id in (-10, 1,20,300000000)


"Index Only Scan using incremental_pkey on public.incremental
(cost=0.29..21.23 rows=4 width=4) (actual time=0.016..0.024 rows=2
loops=1)"
"  Output: id"
"  Index Cond: (incremental.id = ANY ('{-10,1,20,300000000}'::integer[]))"
"  Heap Fetches: 2"
"  Buffers: shared hit=9"
"Total runtime: 0.046 ms"


shows question-mark icon instead of graphical plan representation

-- 
Segmentation fault

<p dir="ltr">Hi,<p dir="ltr">Le 30 oct. 2014 21:43, "Марк Коренберг" <<a
href="mailto:socketpair@gmail.com">socketpair@gmail.com</a>>a écrit :<br /> ><br /> > Linux Mint 17<br />
><br/> > pdAdminIII 1.18.1 Jan 21 2014<br /> ><br /> ><br /> > select id from incremental where id in
(-10,1,20,300000000)<br /> ><br /> ><br /> > "Index Only Scan using incremental_pkey on public.incremental<br
/>> (cost=0.29..21.23 rows=4 width=4) (actual time=0.016..0.024 rows=2<br /> > loops=1)"<br /> > "  Output:
id"<br/> > "  Index Cond: (<a href="http://incremental.id">incremental.id</a> = ANY
('{-10,1,20,300000000}'::integer[]))"<br/> > "  Heap Fetches: 2"<br /> > "  Buffers: shared hit=9"<br /> >
"Totalruntime: 0.046 ms"<br /> ><br /> ><br /> > shows question-mark icon instead of graphical plan
representation<br/> ><p dir="ltr">The question mark is used when we don't have a specific icon. The last new nodes
don'thave that. We'll need to find someone to create icons for us. If anybody's up for the job, that'd be great. 

Hello,

Monday, November 3, 2014, 9:40:24 AM, Guillaume Lelarge wrote:

GL> The question mark is used when we don't have a specific icon.
GL> The last new nodes don't have that. We'll need to find someone to
GL> create icons for us. If anybody's up for the job, that'd be great.


I've looked at 9.4's postgresql/src/backend/commands/explain.c,

(http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/commands/explain.c;h=d99e5a86f0d5eaf61445affac52c1831d2e39c12;hb=refs/heads/REL9_4_STABLE#l846)
Afaics, we're missing the following nodes:

Insert
Update
Delete
Foreign Scan
Index Only Scan
BitmapAnd
BitmapOr
Values Scan (shows up as a Seq Scan)
LockRows

I've recently made icons for DML, just for fun, so if no professional
designer engages in, I could give it a try.
Existing node icons are perfectly styled and have some ideas and logic
put into them. I'm not sure I understand that fully. If there were
some public discussions on existing node icons, please point them out!

My thoughts on new icons:
* DML: a pencil and a table with few blocks coloured (red=delete,
orange=update, green=insert). Attached ex_update.png for example. Not
sure about black crosses in the blocks.
* Foreign Scan: like ex_cte_scan.png, but with "FDW" label on a table.
* Index Only Scan: like ex_scan.png, but a binary-tree-like structure of
blocks instead of a table.
* BitmapAnd, BitmapOr: two lists of randomly chosen small "1"/"0",
with "and"/"or" between the lists.
* Values Scan: like ex_scan.png, but just several separate blocks
instead of a table.
* LockRows: like ex_update.png, but with a padlock instead of a pen.

Please share your opinions and ideas.

By the way, I couldn't find out, what a Seek node is and how to get it
into a plan.

--
Best regards,
 J.F.