public inbox for [email protected]
help / color / mirror / Atom feedFrom: yudhi s <[email protected]>
To: pgsql-general <[email protected]>
Subject: Queries for monitor
Date: Tue, 8 Apr 2025 16:08:22 +0530
Message-ID: <CAEzWdqcUQk=M4N+T=GONrZ_0wi12bxM5_a-0W5Ax1tgKa0U3TQ@mail.gmail.com> (raw)
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
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]
Subject: Re: Queries for monitor
In-Reply-To: <CAEzWdqcUQk=M4N+T=GONrZ_0wi12bxM5_a-0W5Ax1tgKa0U3TQ@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