Suggestions on pg_statviz Extension

From: Rajiv Harlalka <rajivharlalka009(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Suggestions on pg_statviz Extension
Date: 2023-05-26 20:20:38
Message-ID: CAO4XbphnjLzbu_w6ZFcTS+qWTzUCcVRJT63Fs_otshA6Bhhx5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Everyone,
I am working on a PostgreSQL extension pg_statviz
<https://github.com/vyruss/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_statviz

Thanking you,
Rajiv Harlalka,
rajivharlalka.tech
Indian Institute of Technology, Kharagpur

Browse pgsql-general by date

  From Date Subject
Next Message Tumasgiu Rossini 2023-05-26 20:40:04 Re: PostgreSQL GSSAPI Windows AD
Previous Message Jean-Philippe Chenel 2023-05-26 18:35:55 Re: PostgreSQL GSSAPI Windows AD