public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Usman Khan <[email protected]>
To: Daulat <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: Postgres capacity planning.
Date: Thu, 24 Oct 2024 08:17:24 +0500
Message-ID: <CAPnRvGvVFHBmn=zay6G289A=8G1-83Gb-gOtLwVjtFEGfpCJLw@mail.gmail.com> (raw)
In-Reply-To: <CALfOM6Lm11GJD8sVnNcha9SgzXtqrn97jmt_K=SSCpM7W97ppg@mail.gmail.com>
References: <CALfOM6Lm11GJD8sVnNcha9SgzXtqrn97jmt_K=SSCpM7W97ppg@mail.gmail.com>

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 <[email protected]> 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.
>
>
>

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Postgres capacity planning.
  In-Reply-To: <CAPnRvGvVFHBmn=zay6G289A=8G1-83Gb-gOtLwVjtFEGfpCJLw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox