APMIA Postgres extension reporting wrong value for Shared Buffer Cache

Products

• DX SaaS

Issue/Introduction

APMIA infrastructure agent Postgres Database extension is reporting value for metric Shared Buffer Usage : Shared Buffer Cache which seems wrong.

 

Path:

Metric Name: SuperDomain|<node/hostname>|Infrastructure|Agent|Postgres Databases|<database IP/Hostname>|Databases|<database-name>|Shared Buffer Usage:Shared Buffer Cache

Current metric value is 9.2GB

Current value on the database side is:
postgres=# SHOW shared_buffers;
 shared_buffers 
----------------
 8GB
(1 row)

Resolution

Following changes are made to the APMIA Postgres extension to address the issue of wrong metric values for Shared Buffer Cache.

Rename the original metric Shared Buffer Cache to its proper name.

Disk Block Cache Hit

Remove the metric Shared Buffer Cache for individual databases.

Correct the query for metric Shared Buffer Cache for Postgres server level.

The APMIA Postgres extension metrics changes have been added in the DXO2 SaaS 25.10.1 release.