blob: 052de94f484b7a2620a03c7d87cf992f3776ae41 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
# 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
For all available options please see module [configuration file](postgres.conf).
```yaml
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`.
---
[]()
|
