Hi Everyone,
I am working on a PostgreSQL extension
pg_statviz [1] as a part of GSoC'23 with the motivation of developing a tool that helps dba's monitor their running database effortlessly. The extension would accumulate statistics about the database over a regular period of time and after a long interval time series analysis could be performed on the collected statistics.
The tool being minimal, would store just the right information that could help in analyzing any performance bottlenecks. The project is currently at alpha level and has a number of additional modules proposed by me such as:
- stats of growing database such as size, buffers hit/cache from pg_stat_user_* views.
- stats on the locks imposed on tables from pg_locks view.
- Replication statistics wrt to current_lag and bytes transferred from pg_stat_replication view.
- Functions stats such as running time from pg_stat_user_functions view.
Suggestions from the community regarding any module that they would like to have in such a tool.
I Would also be happy to answer any questions regarding the project overall.
[1]:
https://github.com/vyruss/pg_statvizThanking you,