MIME-Version: 1.0
From: sud <suds1434@gmail.com>
Date: Sat, 27 Apr 2024 19:31:12 +0530
Message-ID: <CAD=mzVXXQq6c4_L_fcG2GeYWRuAuEh+t5XLuCGaPj+1iFSCSPw@mail.gmail.com>
Subject: Monitoring and debugging historical performance
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a87fe3061714742c"
Archived-At: <https://www.postgresql.org/message-id/CAD%3DmzVXXQq6c4_L_fcG2GeYWRuAuEh%2Bt5XLuCGaPj%2B1iFSCSPw%40mail.gmail.com>
Precedence: bulk

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

Hi All,
While looking option to see how one can monitor database performance for
debugging into historical database performance issues (historical database
wait events , CPU/memory utilization in past, query execution times in past
, executions paths at any point in time in past etc), It appears there
exists some options as i googled in the internet like
pg_sentinel,pgsnapper, pg_collector. Wanted to check, if anybody used these
utilities and suggest any of them to use for a longer term use?

Regards
Sud

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

<div dir=3D"ltr">Hi All,<br>While looking option to see how one can monitor=
 database performance for debugging into historical database performance is=
sues (historical database wait events , CPU/memory utilization in past, que=
ry execution times in past , executions paths at any point in time in past =
etc), It appears there exists some options as i googled in the internet lik=
e pg_sentinel,pgsnapper, pg_collector. Wanted to check, if anybody used the=
se utilities and suggest any of them to use for a longer term use?<br><div>=
<br></div><div>Regards</div><div>Sud</div></div>

--000000000000a87fe3061714742c--