CI observer: Send pg_stat_*** snapshots (special kind of monitoring)
Goal
As a DLE user, I'm able to see various stats for each observed session, including (but not limited to):
- pg_stat_statements
- pg_stat_database
- pg_stat_user_tables / pg_stat_user_indexes / pg_stat_userio_tables / pg_stat_userio_indexes
- etc.
useful picture: https://dataegret.com/2020/10/postgres-13-observability-updates/
TODO / How to implement
Options (we need to choose implementation);
- simply do snapshots before and after. Then analyze it afterward. In the future: visualize.
- use pgCenter. Upload the file, allow downloading it. In the future: visualize.
- use some monitoring agent/exporter (e.g., Prometheus exporter)
Difficulties:
- if we have a lot of tables/indexes, snapshots might be huge
Acceptance criteria
tbd
Edited by Nikolay Samokhvalov