Postgres db monitoring is not working

Products

• DX SaaS

Issue/Introduction

Not able to report a custom Postgresql monitoring metric

Environment

DXO2 25.8.1.7 APMIA Postgresql monitoring extension

Resolution

Suggestion is to use lowercase for the query resultset column name in the metric mapping configuration to help address the issue.

The root cause of the issue is the mismatched column name case.  By default, postgresql would convert column names in a select query to lower case unless the names being enclosed in quotes to preserve their uppercase or mixed case for referencing later. 

Thus, the column name in the resultSet would also expect lowercase by default.

Existing 

To