Skip to content

postgres

Module monitors one or more postgres servers.

Requirements:

  • python-psycopg2 package. You have to install it manually.

Following charts are drawn:

  1. Database size MB
    * size

  2. Current Backend Processes processes
    * active

  3. Write-Ahead Logging Statistics files/s
    * total
    * ready
    * done

  4. Checkpoints writes/s
    * scheduled
    * requested

  5. Current connections to db count
    * connections

  6. Tuples returned from db tuples/s
    * sequential
    * bitmap

  7. Tuple reads from db reads/s
    * disk
    * cache

  8. Transactions on db transactions/s
    * committed
    * rolled back

  9. Tuples written to db writes/s
    * inserted
    * updated
    * deleted
    * conflicts

  10. Locks on db count per type
    * locks

configuration

socket:
  name         : 'socket'
  user         : 'postgres'
  database     : 'postgres'

tcp:
  name         : 'tcp'
  user         : 'postgres'
  database     : 'postgres'
  host         : 'localhost'
  port         : 5432

When no configuration file is found, module tries to connect to TCP/IP socket: localhost:5432.