1 |
Target --default-- |
2 |
directory-desc = "PostgreSQL" |
3 |
rrd-datafile = %dataDir%/%auto-target-name%.rrd |
4 |
target-type = pg_stat |
5 |
pg_user = postgresql |
6 |
pg_pass = "" |
7 |
|
8 |
# change this for your configuration |
9 |
parse-script = "/data/cricket/parse_pg_stat.pl %auto-target-name%" |
10 |
|
11 |
datasource --default-- |
12 |
rrd-ds-type = DERIVE |
13 |
rrd-min = 0 |
14 |
rrd-heartbeat = 1800 |
15 |
precision = integer |
16 |
|
17 |
datasource numbackends |
18 |
ds-source = "exec:0:%parse-script%" |
19 |
datasource xact_commit |
20 |
ds-source = "exec:1:%parse-script%" |
21 |
datasource xact_rollback |
22 |
ds-source = "exec:2:%parse-script%" |
23 |
datasource blks_read |
24 |
ds-source = "exec:3:%parse-script%" |
25 |
datasource blks_hit |
26 |
ds-source = "exec:4:%parse-script%" |
27 |
|
28 |
targetType pg_stat |
29 |
ds = "numbackends, xact_commit, xact_rollback, blks_read, blks_hit" |
30 |
view = "Transactions: numbackends xact_commit xact_rollback, |
31 |
Disk: blks_read blks_hit" |
32 |
|
33 |
|
34 |
# which host to connect to? (it will use template1 database) |
35 |
#target hostname.domain |
36 |
# user pg_username |
37 |
# pass pg_password |