Metricbeat postgresql 13.x, statement module needs update

Elastic Stack Beats
1

Hi,

I've been trying to get metricbeat to work with postgres. It works fine, however, I noticed some of the default dashboards had no data, after further investigation, I've" found that the time fields are always empty.

"postgresql": {
      "statement": {
        "user": {
          "id": 10
        },
        "database": {
          "oid": 13445
        },
        "query": {
          "calls": 6278239,
          "rows": 6278239,
          "time": {
            "mean": {},
            "stddev": {},
            "total": {},
            "min": {},
            "max": {}
          },
          "memory": {
            "shared": {
              "read": 8,
              "dirtied": 27780,
              "written": 27779,
              "hit": 6333822
            },
            "local": {
              "written": 0,
              "hit": 0,
              "read": 0,
              "dirtied": 0
            },
            "temp": {
              "read": 0,
              "written": 0
            }
          },
          "id": 9183934075978990000,
          "text": "insert into test_table(test) values ($1)"
        }
      }

After some research, I've found that postgres has updated their statement statistics: PostgreSQL: Documentation: 13: F.29. pg_stat_statements

Metricbeat looks for the field total_time, but that field no longer exists. This in turn makes it so the dashboard is empty of top queries and it's durations. Should I file this as a bug on github, or an enhancement, or what can I do?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.