Postgres chart

[moshloop]

The config item:

conf: select json_object_agg(name, concat(setting, unit)) from  pg_settings where source != 'default'

The topology:

- lookup:
    postgres:
    - connection: "connection://{{ .Values.connectionName }}"
      display:
        expr: results.rows[0].version
      name: Version query
      query: SELECT VERSION()
      results: 1
      test: {}
      transform: {}
  name: Version
- headline: true
  lookup:
    postgres:
    - connection: "connection://{{ .Values.connectionName }}"
      display:
        expr: results.rows[0].pg_size_pretty
      name: Size query
      query: SELECT pg_size_pretty(pg_database_size('mission_control'))
      results: 1
      test: {}
      transform: {}
  name: Size
- headline: true
  lookup:
    postgres:
    - connection: "connection://{{ .Values.connectionName }}"
      display:
        expr: results.rows[0].sum
      name: Active connections query
      query: SELECT sum(numbackends) FROM pg_stat_database
      results: 1
  name: Connections

Playbooks

• Run SQL
• Kill Connection
• Run Maintenance
• Vaccumm all tables
• Reset pg_stat_tables