MIME-Version: 1.0
From: yudhi s <learnerdatabase99@gmail.com>
Date: Tue, 8 Apr 2025 16:08:22 +0530
Message-ID: <CAEzWdqcUQk=M4N+T=GONrZ_0wi12bxM5_a-0W5Ax1tgKa0U3TQ@mail.gmail.com>
Subject: Queries for monitor
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006ad326063241f45b"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqcUQk%3DM4N%2BT%3DGONrZ_0wi12bxM5_a-0W5Ax1tgKa0U3TQ%40mail.gmail.com>
Precedence: bulk

--0000000000006ad326063241f45b
Content-Type: text/plain; charset="UTF-8"

Hello All,
I am trying to configure basic monitoring for our postgres database using
data dictionary views as below. Want to understand if these are accurate or
if I am making any mistakes here by querying this way. And also ,
it's something we want to do for the application specific sessions/queries
and want to exclude the system related sessions/queries , so how can that
be done in the same query?

https://gist.github.com/databasetech0073/5d8113eaba13ac62352f97521ce68a43

Regards
Yudhi

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

<div dir=3D"ltr">Hello All,<br>I am trying to configure basic monitoring fo=
r our postgres database using data dictionary views as below. Want to under=
stand if these are accurate or if I am making any mistakes here by=C2=A0que=
rying this way. And also , it&#39;s=C2=A0something we want to do for the ap=
plication specific sessions/queries and want to exclude the system related =
sessions/queries , so how can that be done in the same=C2=A0query?<div><br>=
</div><div><a href=3D"https://gist.github.com/databasetech0073/5d8113eaba13=
ac62352f97521ce68a43">https://gist.github.com/databasetech0073/5d8113eaba13=
ac62352f97521ce68a43</a></div><div><br></div><div>Regards</div><div>Yudhi</=
div></div>

--0000000000006ad326063241f45b--