IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
PostgreSQL database metricset
editPostgreSQL database metricset
editThis is the database metricset of the PostgreSQL module.
This is a default metricset. If the host module is unconfigured, this metricset is enabled by default.
Fields
editFor a description of each field in the metricset, see the exported fields section.
Here is an example document generated by this metricset:
{
"@timestamp": "2017-10-12T08:05:34.853Z",
"event": {
"dataset": "postgresql.database",
"duration": 115000,
"module": "postgresql"
},
"metricset": {
"name": "database",
"period": 10000
},
"postgresql": {
"database": {
"blocks": {
"hit": 43969,
"read": 381,
"time": {
"read": {
"ms": 0
},
"write": {
"ms": 0
}
}
},
"conflicts": 0,
"deadlocks": 0,
"name": "postgres",
"number_of_backends": 2,
"oid": 13395,
"rows": {
"deleted": 42,
"fetched": 26418,
"inserted": 98,
"returned": 53201,
"updated": 14
},
"stats_reset": "2021-03-05T18:39:18.089Z",
"temporary": {
"bytes": 0,
"files": 0
},
"transactions": {
"commit": 445,
"rollback": 5
}
}
},
"service": {
"address": "192.168.128.2:5432",
"type": "postgresql"
}
}