I'm not sure if authors would consider this beyond the scope of pev2 given the embeddable Vue component, however the thing I found myself wanting after submitting a few query plans was a dashboard that automatically monitored recent queries from pgstat and displayed a list – where in one click you could add the EXPLAIN ANALYZE ... block at the beginning, rerun the query, and then see the corresponding pev2 visualization.
pghero does this well and offers a docker container which you can spin up alongside your Postgres container and get a ton of useful information automatically.
Thank you for the truly excellent tool!
I'm not sure if authors would consider this beyond the scope of
pev2given the embeddable Vue component, however the thing I found myself wanting after submitting a few query plans was a dashboard that automatically monitored recent queries frompgstatand displayed a list – where in one click you could add theEXPLAIN ANALYZE ...block at the beginning, rerun the query, and then see the correspondingpev2visualization.pgherodoes this well and offers a docker container which you can spin up alongside your Postgres container and get a ton of useful information automatically.Thanks for the consideration!