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",
"beat": {
"hostname": "host.example.com",
"name": "host.example.com"
},
"metricset": {
"host": "postgresql:5432",
"module": "postgresql",
"name": "statement",
"rtt": 115
},
"postgresql": {
"statement": {
"user": {
"id": 10
},
"database": {
"oid": "12407"
},
"query": {
"id": "3240664890",
"text": "SELECT pg_sleep(?);",
"calls": "2",
"rows": "2",
"time": {
"total": 120066.497,
"min": 60029.533,
"max": 60036.964,
"mean": 60033.2485,
"stddev": 3.71549999999843
},
"memory": {
"shared": {
"hit": 0,
"read": 0,
"dirtied": 0,
"written": 0,
},
"local": {
"hit": 0,
"read": 0,
"dirtied": 0,
"written": 0,
},
"temp": {
"read": 0,
"written": 0,
}
}
}
}
}
}