powa-team / powa-web

PoWA user interface
http://powa.readthedocs.io/
73 stars 31 forks source link

Visible ratio #65

Closed anayrat closed 4 years ago

anayrat commented 5 years ago

Hello,

I have an idea of new feature : compute a kind of visible ratio between relpages and relallvisible to know which table should be vacuumed for Index-only-scan

Regards,

rjuju commented 4 years ago

It would be nice, but unfortunately, those are counters visible in local database only. By design, we want to avoid to connect on all databases on a given server when doing a snapshot, so that's something we won't be able to do. I'm closing this issue as I don't see the per-database object problem being solved any time soon.