Skip to main content
Version: 下一篇

Monitoring:PostgreSQL database monitoring

Collect and monitor the general performance indicators of PostgreSQL database. Support PostgreSQL 10+.

Configuration parameter

Parameter nameParameter help description
Monitoring HostMonitored IPV4, IPV6 or domain name. Note⚠️Without protocol header (eg: https://, http://)
Monitoring nameIdentify the name of this monitoring. The name needs to be unique
PortPort provided by the database. The default is 5432
Query timeoutSet the timeout time when SQL query does not respond to data, unit: ms, default: 3000ms
Database nameDatabase instance name, optional
UsernameDatabase connection user name, optional
PasswordDatabase connection password, optional
URLDatabase connection URL,optional,If configured, the database name, user name, password and other parameters in the URL will overwrite the above configured parameters
Collection intervalInterval time of monitor periodic data collection, unit: second, and the minimum interval that can be set is 10 seconds
Whether to detectWhether to detect and check the availability of monitoring before adding monitoring. Adding and modifying operations will continue only after the detection is successful
Description remarksFor more information about identifying and describing this monitoring, users can note information here

Collection indicator

Indicator set:basic

Indicator nameIndicator unitIndicator help description
server_versionnoneVersion number of the database server
portnoneDatabase server exposure service port
server_encodingnoneCharacter set encoding of database server
data_directorynoneDatabase storage data disk address
max_connectionsconnectionsDatabase maximum connections

Indicator set:state

Indicator nameIndicator unitIndicator help description
namenoneDatabase name, or share-object is a shared object
conflictstimesThe number of queries canceled in the database due to a conflict with recovery
deadlocksnumberNumber of deadlocks detected in the database
blks_readtimesThe number of disk blocks read in the database
blks_hittimesTimes the disk block has been found to be in the buffer, so there is no need to read it once (This only includes hits in the PostgreSQL buffer, not in the operating system file system buffer)
blk_read_timemsTime spent by the backend reading data file blocks in the database
blk_write_timemsTime spent by the backend writing data file blocks in the database
stats_resetnoneThe last time these statistics were reset

Indicator set:activity

Indicator nameIndicator unitIndicator help description
runningconnectionsNumber of current client connections