Description

It monitors Postgres DB agent metrics like statiotables toastblks hit, idxblks hit, database blks hit, statioindexes buffer hits.

Prerequisites

The database you want to monitor should connect from the Gateway. Gateway Management profile should be added to the device. Database type credentials should be added against the device in the portal.

Metric Parameters

Metric Parameters
ParameterDescription
Frequency
  • Frequency is the interval in which you want to probe and collect metric data from the target device/resource
  • Frequency is defined in minutes (min).
  • Warning ThresholdIf the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user.
    Critical ThresholdIf the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user.
    AlertThe alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user.

    Metrics

    postgresql.statiotables.toastblkshit

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionNumber of buffer hits in this table's TOAST table (if any).
    CategoryApplication
    Collector TypeGateway
    Monitor NameG2 PostgreSQL Database BlockHits Monitor
    UnitNULL

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency5Manual
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    postgresql.statiotables.idxblkshit

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionNumber of buffer hits in all indexes on this table.
    CategoryApplication
    Collector TypeGateway
    Monitor NameG2 PostgreSQL Database BlockHits Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency5Manual
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    postgresql.database.blkshit

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionNumber of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system's file system cache).
    CategoryApplication
    Collector TypeGateway
    Monitor NameG2 PostgreSQL Database BlockHits Monitor
    UnitNULL

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency5Manual
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    postgresql.statioindexes.bufferhits

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionNumber of buffer hits in this index.
    CategoryApplication
    Collector TypeGateway
    Monitor NameG2 PostgreSQL Database BlockHits Monitor
    UnitNULL

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency5Manual
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph