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.
