search

AlexTatiyants / pev

Postgres Explain Visualizer
MIT License
2.77k stars 194 forks source link

navigating a large query is hard, especially side scrolling #14

Closed wholtz closed 8 years ago

wholtz commented 8 years ago

I have a large query that creates a output several monitor widths wide and a couple monitor heights tall. The browser vertical scroll bar works for moving up and down. However, the brower's side-to-side scroll bar doesn't work because pev adds another horizontal scroll bar within the page. This means that I can only scroll side to side when I have navigated to the bottom of the page and made pev's scroll bar visible. This would be much easier if pev's scroll bar was removed. Additionally, it would be useful to be able to zoom in or out on a large tree. Thanks!

vsg commented 8 years ago

+1!

AlexTatiyants commented 8 years ago

agreed. Once I find a bit of time, I'll try to find a solution. Also, if you have an example of a plan like that, it would really help.

vsg commented 8 years ago 
EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON)
select 
(select count(*) from INFORMATION_SCHEMA.tables), 
(select count(*) from INFORMATION_SCHEMA.tables), 
(select count(*) from INFORMATION_SCHEMA.tables), 
(select count(*) from INFORMATION_SCHEMA.tables), 
(select count(*) from INFORMATION_SCHEMA.tables), 
(select count(*) from INFORMATION_SCHEMA.tables)
from INFORMATION_SCHEMA.tables
AlexTatiyants commented 8 years ago

I added a "Dot" view mode in commit https://github.com/AlexTatiyants/pev/commit/7fc812bc761c95e508e1c540393b12b03cdf1d03 which should address this.