MIME-Version: 1.0
References: 
 <CALfOM6Lm11GJD8sVnNcha9SgzXtqrn97jmt_K=SSCpM7W97ppg@mail.gmail.com>
In-Reply-To: 
 <CALfOM6Lm11GJD8sVnNcha9SgzXtqrn97jmt_K=SSCpM7W97ppg@mail.gmail.com>
From: Muhammad Usman Khan <usman.k@bitnine.net>
Date: Thu, 24 Oct 2024 08:17:24 +0500
Message-ID: 
 <CAPnRvGvVFHBmn=zay6G289A=8G1-83Gb-gOtLwVjtFEGfpCJLw@mail.gmail.com>
Subject: Re: Postgres capacity planning.
To: Daulat <daulat.dba@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b0234506253071c6"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPnRvGvVFHBmn%3Dzay6G289A%3D8G1-83Gb-gOtLwVjtFEGfpCJLw%40mail.gmail.com>
Precedence: bulk

--000000000000b0234506253071c6
Content-Type: text/plain; charset="UTF-8"

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.dba@gmail.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.
>
>
>

--000000000000b0234506253071c6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smart=
mail=3D"gmail_signature"><div dir=3D"ltr"><div>Hi,</div><div><br>For Postgr=
eSQL capacity planning, you can explore several freeware tools and approach=
es that help monitor and forecast database resource utilization. Some of th=
e approaches are as follows:<br>* pgmetrics: A tool used to collects and re=
ports PostgreSQL metrics such as database size, table sizes, buffer cache u=
tilization, index usage etc<br>* pg_stat_statements: Tracks execution stati=
stics for all SQL queries<br>* pgCluu: It provides detailed reports and cha=
rts based on system statistics and PostgreSQL performance.<br>* you can use=
 the combination of Prometheus and Grafana<br>* Pgbadger: It generates perf=
ormance reports based on log files.</div></div></div></div><br></div><br><d=
iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, 23 O=
ct 2024 at 17:02, Daulat &lt;<a href=3D"mailto:daulat.dba@gmail.com">daulat=
.dba@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"ltr">Hello Everyone.<div><br></div><div>Could any=
one please suggest any freeware tools, scripts, or ideas for creating a cap=
acity planning solution for a PostgreSQL database? Thank you.</div><div><br=
></div><div><br></div></div>
</blockquote></div>

--000000000000b0234506253071c6--