Re: Postgres capacity planning.

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.