PostgreSQL activity metricset

edit

PostgreSQL activity metricset

edit

This is the activity metricset of the PostgreSQL module.

Fields

edit

For a description of each field in the metricset, see the exported fields section.

Here is an example document generated by this metricset:

{
    "@timestamp": "2016-05-23T08:05:34.853Z",
    "beat": {
        "hostname": "host.example.com",
        "name": "host.example.com"
    },
    "metricset": {
        "host": "postgresql:5432",
        "module": "postgresql",
        "name": "activity",
        "rtt": 115
    },
    "postgresql": {
        "activity": {
            "application_name": "",
            "backend_start": "2016-09-06T07:33:18.323Z",
            "client": {
                "address": "172.17.0.14",
                "hostname": "",
                "port": 57436
            },
            "database": {
                "name": "postgres",
                "oid": 12379
            },
            "pid": 162,
            "query": "SELECT * FROM pg_stat_activity",
            "query_start": "2016-09-06T07:33:18.325Z",
            "state": "active",
            "state_change": "2016-09-06T07:33:18.325Z",
            "transaction_start": "2016-09-06T07:33:18.325Z",
            "user": {
                "id": 10,
                "name": "postgres"
            },
            "waiting": false
        }
    },
    "type": "metricsets"
}