PostgreSQL is an open-source database management system. Metricly can be used to monitor your PostgreSQL database(s).


f you haven’t installed the Linux agent already, see the instructions on this page for how to install it. If you need to disable the Linux integration or view the unique API key assigned to your account, navigate to the Integrations page under the user account drop-down menu and click the integration designated as Infrastructure under the Integration column.

Collector Configuration

  1. Navigate to the collectors folder.
    The default location is /opt/netuitive-agent/conf/collectors.
  2. Open the PostgresqlCollector.conf file.
    This configuration file will only be available in agent versions 0.3.1 or later. Otherwise, you will have to create a configuration file with the same name.
  3. Change the enabled setting to True.
  4. Update the dbname setting to the name of your database.
  5. Update the user and password settings to the proper credentials used to access the database.
  6. Save the configuration file, and restart the Linux Agent.

Additional Configuration Options

  • Collector Options

    Option Default Description
    enabled False Enable collecting PostgreSQL metrics.
    host localhost Hostname to collect from
    dbname postgres Database that contains list of databases in PostgreSQL.
    user postgres Username used for database authentication.
    password postgres Password used for database authentication.
    port 5432 Port to collect from.
    metrics_whitelist “^database.*” Regex list to match metrics to transmit. Mutually exclusive with metrics_blacklist option.
    byte_unit Default numeric output(s).
    extended Enable collecting extended database stats.
    has_admin Setting that notes if admin privileges are required to run some queries.
    measure_collector_time Measure the collector’s run time in milliseconds.
    metrics List of enabled metrics to collect.
    metrics_blacklist Regex list to match metrics to block. Mutually exclusive with metrics_whitelist option.
    password_provider Tells the agent whether to authenticate with the supplied password or
    the .pgpass file password.
    pg_version The version of PostgreSQL you wish to monitor.
    sslmode Defines server certificate verification method to use for SSL
    connections (if any). Available values include disableallowpreferrequireverify-ca,
    and verify-full. Full details included 
    underscore Enables converting underscores (“_”) to periods (“.”).


Redhat 6 and 7
CentOS 6 and 7
Amazon Linux (latest)
Ubuntu 12, 14, 15, and 16
Debian 7, 8, and 9
Linux Agent



Friendly Name Fully Qualified Name (FQN) Description Statistic Units Min Max Sparse Data Strategy (SDS) BASE CORR UTIL
Blocks Hit postgres.database.*.blks_hit The number of times disk blocks were found already in the PostgreSQL
buffer cache so a read was not necessary.
average 0 none none
Blocks Read postgres.database.*.blks_read The number of disk blocks read in the database. average 0 none none
Connections postgres.database.*.connections The number of connections to the database. average 0 none none
Backend Connections postgres.database.*.numbackends The number of backends currently connected to the database. average 0 none none
Database Size postgres.database.*.size The size of the database. average 0 none none
Deleted Rows postgres.database.*.tup_deleted Number of rows deleted by queries in the database. average 0 none none
Fetched Rows postgres.database.*.tup_fetched Number of rows fetched by queries in the database. average 0 none none
Inserted Rows postgres.database.*.tup_inserted Number of rows inserted by queries in the database. average 0 none none
Returned Rows postgres.database.*.tup_returned Number of rows returned by queries in the database. average 0 none none
Updated Rows postgres.database.*.tup_updated Number of rows updated by queries in the database. average 0 none none
Committed Transactions postgres.database.*.xact_commit Number of transactions in the database that have been committed. average 0 none none
Rolled Back Transactions postgres.database.*.xact_rollback Number of transactions in the database that have been rolled back. average 0 none none