Postgres monitoring via jdbc_response probe not showing all metrics

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The postgres monitoring via jdbc_response 1.25 is giving metrics for the Database Statistics and Process State Monitoring groups but nothing for the General Table Statistics, Table Index Monitoring, Table Hit Monitoring and Table Lock Monitoring groups. Why? Are there any special permissions needed to collect metrics from these groups?

What is the procedure to configure the metrics? Do we need to use other probes in combination? how does it work?

Environment

UIM 20.4

 jdbc_response 1.25

Resolution

Statistics are collected from the PostgreSQL statistics collector subsystem. Ensure that the system is configured to collect information. The statistics collector is controlled by configuration parameters that are typically set in postgresql.conf. For more information see, https://www.postgresql.org/docs.