ankane / pghero

A performance dashboard for Postgres
MIT License
8.16k stars 452 forks source link

[Idea] Allow sorting of tables on the Maintenance tab #480

Open geoffharcourt opened 1 year ago

geoffharcourt commented 1 year ago

The Maintenance tab is a huge benefit to us when folks are checking to see if a table might have stopped being auto-vacuumed, auto-analyzed, etc. We have > 250 tables, so it can be difficult to spot problematic tables without reading every row.

It would be really cool if you could sort the tables on this page by the last vacuumed, last analyzed, and dead rows columns to more quickly find problems.

(Also, making dead_rows=true the default would be great, it's super useful!)

I'd be happy to do a PR for this, but I wanted to check if there was interest before doing so.