Queries for monitor - Mailing list pgsql-general

From yudhi s
Subject Queries for monitor
Date
Msg-id CAEzWdqcUQk=M4N+T=GONrZ_0wi12bxM5_a-0W5Ax1tgKa0U3TQ@mail.gmail.com
Whole thread Raw
List 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?


Regards
Yudhi

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Slow timestamp query after upgrading from Pg13 to Pg16
Next
From: Atul Kumar
Date:
Subject: Wal file query