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.
Have a nice day.
Alex Balashov <abalashov@xxxxxxxxxxxxxxx>, 23 Eki 2024 Çar, 15:13 tarihinde şunu yazdı:
> On Oct 23, 2024, at 8:02 am, Daulat <daulat.dba@xxxxxxxxx> 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