This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.
« PostgreSQL module PostgreSQL bgwriter metricset »
Elastic Docs ›Metricbeat Reference [master] ›Modules ›PostgreSQL module

PostgreSQL activity metricset

edit

PostgreSQL activity metricset

edit

This is the activity metricset of the PostgreSQL module.

This is a default metricset. If the host module is unconfigured, this metricset is enabled by default.

Fields

For 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.activity",
        "duration": 115000,
        "module": "postgresql"
    },
    "metricset": {
        "name": "activity",
        "period": 10000
    },
    "postgresql": {
        "activity": {
            "application_name": "",
            "backend_start": "2021-03-05T19:01:40.467Z",
            "backend_type": "client backend",
            "client": {
                "address": "192.168.128.1",
                "hostname": "",
                "port": 33414
            },
            "database": {
                "name": "postgres",
                "oid": 13395
            },
            "pid": 2236,
            "query": "SELECT * FROM pg_stat_activity",
            "query_start": "2021-03-05T19:01:40.469Z",
            "state": "idle",
            "state_change": "2021-03-05T19:01:40.471Z",
            "user": {
                "id": 10,
                "name": "postgres"
            }
        }
    },
    "service": {
        "address": "192.168.128.2:5432",
        "type": "postgresql"
    }
}
« PostgreSQL module PostgreSQL bgwriter metricset »