PATCH: Add missing nodes to graphical explain plan

From: "J(dot)F(dot) Oster" <jinfroster(at)mail(dot)ru>
To: pgadmin-hackers(at)postgresql(dot)org
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Марк Коренберг <socketpair(at)gmail(dot)com>
Subject: PATCH: Add missing nodes to graphical explain plan
Date: 2014-11-05 14:25:10
Message-ID: 1976486278.20141105172510@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Hello,

Per recent discussion on pgadmin-support ("index only scans are not
shown graphically"),

JFO> Insert
JFO> Update
JFO> Delete
JFO> Foreign Scan
JFO> Index Only Scan
JFO> BitmapAnd
JFO> BitmapOr
JFO> Values Scan (shows up as a Seq Scan)
JFO> LockRows
+ Merge Append.

Please note, that besides 10 new icons there are two icons for
existing nodes in the attachment, Bitmap Heap Scan and Bitmap Index
Scan.
I've changed them for unity with BitmapOr, BitmapAnd, which hopefully
will result in an intuitive understanding of the concept by users.
But I was thinking of bitmap index scans as an analogue for Oracle's
bitmap indexes. Then I've read explanations by Tom Lane
http://www.postgresql.org/message-id/12553.1135634231@sss.pgh.pa.us
and it appears that Postgres doesn't build literally a chain of 0's
and 1's, but an array of tuple pointers. Nevertheless, if it is
possible, I'd like these two icons to be committed too. You decide :)

--
Best regards,
J.F.

Attachment Content-Type Size
141105_explain_nodes_pgadmin-include-images.zip application/x-zip-compressed 13.8 KB
141105_explain_nodes.patch application/octet-stream 11.7 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Katharina Büchse 2014-11-05 17:03:17 Re: zweidimensionale Statistiken in Postgres
Previous Message Ashesh Vashi 2014-11-05 08:51:08 Re: Some trivial patch

Browse pgadmin-support by date

  From Date Subject
Next Message Campbell, Lance 2014-11-05 18:06:19 views not displaying indexes
Previous Message Dave Barter 2014-11-05 09:46:05 OSX UI Crashes