New

The executive guide to generative AI

Read more
About usPartnersSupport|Login

WARNING: Version 6.2 of Metricbeat has passed its EOL date.

This documentation is no longer being maintained and may be removed. If you are running this version, we strongly advise you to upgrade. For the latest information, see the current release documentation.

« PostgreSQL module PostgreSQL bgwriter metricset »
Elastic Docs ›Metricbeat Reference [6.2] ›Modules ›PostgreSQL module

PostgreSQL activity metricset

edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.

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": "2017-10-12T08: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": "2017-12-07T07:31:48.923Z",
            "client": {
                "address": "172.18.0.27",
                "hostname": "",
                "port": 53398
            },
            "database": {
                "name": "postgres",
                "oid": 12379
            },
            "pid": 348,
            "query": "SELECT * FROM pg_stat_activity",
            "query_start": "2017-12-07T07:31:48.925Z",
            "state": "active",
            "state_change": "2017-12-07T07:31:48.925Z",
            "transaction_start": "2017-12-07T07:31:48.925Z",
            "user": {
                "id": 10,
                "name": "postgres"
            },
            "waiting": false
        }
    }
}
« PostgreSQL module PostgreSQL bgwriter metricset »

On this page

Was this helpful?
Feedback