Collected PostgreSQL Properties

  • postgres.activity:
[
  {
    "type": "postgres.activity",
    "entity": "192.0.2.3",
    "key": {
      "datname": "redmine",
      "procpid": "10193",
      "usename": "readonly",
      "usesysid": "101610"
    }
    ]
  • postgres.info:
[{
    "type": "postgres.info",
    "entity": "192.0.2.3",
    "key": {},
    "tags": {
      "current_database": "redmine",
      "current_user": "readonly",
      "port": "5432",
      "server_address": "192.0.2.3",
      "start_time": "2016-05-26 10:03:07.871886+00",
      "version": "PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit"
    },
    "date": "2016-05-27T12:35:57Z"
  }
  ]
  • postgres.pg_class:
[{
    "type": "postgres.pg_class",
    "entity": "192.0.2.3",
    "key": {
      "relname": "attachments"
    },
    "tags": {
      "relpages": "78",
      "reltuples": "3084"
    },
    "date": "2016-05-27T12:35:57Z"
  }
  ]