Hi,
For PostgreSQL capacity planning, you can explore several freeware tools and approaches that help monitor and forecast database resource utilization. Some of the approaches are as follows:
* pgmetrics: A tool used to collects and reports PostgreSQL metrics such as database size, table sizes, buffer cache utilization, index usage etc
* pg_stat_statements: Tracks execution statistics for all SQL queries
* pgCluu: It provides detailed reports and charts based on system statistics and PostgreSQL performance.
* you can use the combination of Prometheus and Grafana
* Pgbadger: It generates performance reports based on log files.
On Wed, 23 Oct 2024 at 17:02, Daulat <daulat.dba@xxxxxxxxx> wrote:
Hello Everyone.Could anyone please suggest any freeware tools, scripts, or ideas for creating a capacity planning solution for a PostgreSQL database? Thank you.
