#Postresql

PostreSQL

PostgreSQL is an open-source database management system. Metricly can be used to monitor your PostgreSQL database(s). Prerequisites Linux Agent Configure Navigate to the collectors folder, /opt/netuitive-agent/conf/collectors. Open the PostgresqlCollector.conf file. Change the enabled setting to True. Update the dbname setting to the name of your database. Update the user and password settings to the proper credentials used to access the database. Save the configuration file, and restart the Linux Agent.

postgresql metrics

Collected 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 PostgreSQLbuffer cache so a read was not necessary. average 0 none none yes no no Blocks Read postgres.database.*.blks_read The number of disk blocks read in the database.