Module monitors one or more postgres servers.
Requirements:
python-psycopg2
package. You have to install it manually.
Following charts are drawn:
-
Database size MB
- size
-
Current Backend Processes processes
- active
-
Write-Ahead Logging Statistics files/s
- total
- ready
- done
-
Checkpoints writes/s
- scheduled
- requested
-
Current connections to db count
- connections
-
Tuples returned from db tuples/s
- sequential
- bitmap
-
Tuple reads from db reads/s
- disk
- cache
-
Transactions on db transactions/s
- committed
- rolled back
-
Tuples written to db writes/s
- inserted
- updated
- deleted
- conflicts
-
Locks on db count per type
- locks
For all available options please see module configuration file.
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
.