I don't sure what you asking for but there is no any tool enough for the progresses. If you look some enterprise thing you can check pganalyze. PostgreSQL have enough monitoring extensions anyway. One of them is pgbadger, you can look at it.
> On Oct 23, 2024, at 8:02 am, Daulat <daulat.dba@gmail.com> wrote: > > Could anyone please suggest any freeware tools, scripts, or ideas for creating a capacity planning solution for a PostgreSQL database? Thank you.
I suppose this is one of those areas where "knowing Postgres well" is the idea, and it's unlikely that this can be replaced with a tool.
-- Alex Balashov Principal Consultant Evariste Systems LLC Web: https://evaristesys.com Tel: +1-706-510-6800