Snapshot pg_stat_progres_* views?

powa-team / powa-archivist

powa-archivist: the powa PostgreSQL extension

http://powa.readthedocs.io/

PostgreSQL License

51 stars 20 forks source link

Snapshot pg_stat_progres_* views? #37

Closed rjuju closed 3 years ago

rjuju commented 3 years ago

The (current) list of views is:

pg_stat_progress_vacuum (9.6+)
pg_stat_progress_create_index (12+)
pg_stat_progress_cluster (12+)
pg_stat_progress_analyze (13+)
pg_stat_progress_basebackup (13+)

Should we snapshot all of them? Note that they only expose oids, so without a remote database access from UI (or a copy of the remote database's catalog), I'm afraid that it won't be that useful.

frost242 commented 3 years ago

Hi rjuju, On a first though, I don't find this feature very useful. Maybe it's helpful to know that you have a VACUUM or CREATE INDEX running for a long time and having a performance impact on the production. But this can be achieved with some other monitoring system (check_pga, etc.). Hope it helps

marco44 commented 3 years ago

Yeah, same point of view for me. I don't feel this belongs to powa, it's going to be hard to integrate to what the tool is right now

rjuju commented 3 years ago

Ok, I'll close this as wonfix then. Thanks for the feedback.