IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
PostgreSQL statement metricset
edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.
PostgreSQL statement metricset
editThis is the statement metricset of the PostgreSQL module.
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",
"agent": {
"hostname": "host.example.com",
"name": "host.example.com"
},
"event": {
"dataset": "postgresql.statement",
"duration": 115000,
"module": "postgresql"
},
"metricset": {
"name": "statement"
},
"postgresql": {
"statement": {
"database": {
"oid": 12379
},
"query": {
"calls": 2,
"id": "1592910677",
"memory": {
"local": {
"dirtied": 0,
"hit": 0,
"read": 0,
"written": 0
},
"shared": {
"dirtied": 0,
"hit": 0,
"read": 0,
"written": 0
},
"temp": {
"read": 0,
"written": 0
}
},
"rows": 3,
"text": "SELECT * FROM pg_stat_statements",
"time": {
"max": {
"ms": 0.388
},
"mean": {
"ms": 0.235
},
"min": {
"ms": 0.082
},
"stddev": {
"ms": 0.153
},
"total": {
"ms": 0.47000000000000003
}
}
},
"user": {
"id": 10
}
}
},
"service": {
"address": "172.26.0.2:5432",
"type": "postgresql"
}
}