Search Postgresql Archives

Queries for monitor

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux