Minor issues and improvements

[MatteoGioioso]

Backend

• improve queries list table: add refreshing, options, filters and orders
• Avoid running completely random query. At least restrict the type of statements that can be run.
  SELECT, UPDATE only.
• Add Heap Fetches into indexes stats: https://www.pgmustard.com/docs/explain/heap-fetches
• Some NodeType have additional info and Operation should include those. Ex: Nested Loop Join as Join Type: Anti, the operation name should be Nested Loop Anti Join. I think same should go for Left, Right joins
• Add JIT stats
• Triggers
• Join Filters not displaying
• Add I/O timings
• Add subplans
• Add Functions: https://dba.stackexchange.com/questions/84414/explain-analyze-shows-no-details-for-queries-inside-a-plpgsql-function
• Sometimes negative blocks can be seen: https://explain.depesz.com/s/F4ze#html, due to incorrect parsing of the Planning section
• Improve workers: https://www.pgmustard.com/docs/explain/workers (You can work out the values for the main thread by subtracting the worker statistics from the total)
• INSERTS are not supported: https://explain.depesz.com/s/5L4n
• Memoize: https://explain.depesz.com/s/yDmb
• Citus plan: https://explain.depesz.com/s/lsv7#html

Frontend

• Extremely annoying popover behavior; increase showing delay
• Warning colors for rows: https://explain.depesz.com/help#colors-rows
• Big numbers should have , and . to be better visualized
• Hover on table's row is ugly, if background color is set on the cell it won't show hover effect
• In the Node column Operation the indentation if the node is deeply nested, it will force the operation name on a new line
• Popover on nodes chips. To get some explanation
• Detailed node table can be closed
• Detailed node table can go forward and backward, following summary level order
• Query visualization should have PlanID or Alias displaying
• Error handling
• Sticky table header: difficult to see with big plans
• When going back to Diagram from Table, the fitView is offset
• Generic table for stats misalignment with Node name and time
• More parameters for optimization analytics
• Replace tooltip where ever is ok

---

https://www.pgmustard.com/docs/explain

---

Plans for testing:

• With incremental sort and many workers: https://explain.depesz.com/s/x6opm
• With sort and workers: https://explain.depesz.com/s/dLcS
• With subplans: https://explain.dalibo.com/plan/2193h1g2b47eee9a#raw
• With triggers: https://explain.depesz.com/s/SI4I
• With optimizations: https://explain.depesz.com/s/X3Bw, https://explain.depesz.com/s/F4ze https://explain.depesz.com/s/cNzt
• Huge plan: https://explain.depesz.com/s/8Zts#html
• Optimizations and workers: https://explain.depesz.com/s/D7Y2