| From: | yudhi s <learnerdatabase99(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Queries for monitor |
| Date: | 2025-04-08 10:38:22 |
| Message-ID: | CAEzWdqcUQk=M4N+T=GONrZ_0wi12bxM5_a-0W5Ax1tgKa0U3TQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul Kumar | 2025-04-08 11:44:07 | Wal file query |
| Previous Message | Laurenz Albe | 2025-04-08 06:40:11 | Re: Slow timestamp query after upgrading from Pg13 to Pg16 |