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.

On Wed, 23 Oct 2024 at 17:02, Daulat <daulat(dot)dba(at)gmail(dot)com> 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.
>
>
>