aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/plugin/postgresql.php
diff options
context:
space:
mode:
Diffstat (limited to 'plugin/postgresql.php')
-rw-r--r--plugin/postgresql.php130
1 files changed, 0 insertions, 130 deletions
diff --git a/plugin/postgresql.php b/plugin/postgresql.php
deleted file mode 100644
index 4cfae41..0000000
--- a/plugin/postgresql.php
+++ /dev/null
@@ -1,130 +0,0 @@
1<?php
2
3# Collectd Postgresql plugin
4
5require_once 'conf/common.inc.php';
6require_once 'type/GenericStacked.class.php';
7
8## LAYOUT
9# postgresql-X/pg_blks-heap_hit.rrd
10# postgresql-X/pg_blks-heap_read.rrd
11# postgresql-X/pg_blks-idx_hit.rrd
12# postgresql-X/pg_blks-idx_read.rrd
13# postgresql-X/pg_blks-tidx_hit.rrd
14# postgresql-X/pg_blks-tidx_read.rrd
15# postgresql-X/pg_blks-toast_hit.rrd
16# postgresql-X/pg_blks-toast_read.rrd
17# postgresql-X/pg_db_size.rrd
18# postgresql-X/pg_n_tup_c-del.rrd
19# postgresql-X/pg_n_tup_c-hot_upd.rrd
20# postgresql-X/pg_n_tup_c-ins.rrd
21# postgresql-X/pg_n_tup_c-upd.rrd
22
23$obj = new Type_GenericStacked($CONFIG, $_GET);
24$obj->rrd_format = '%5.1lf%s';
25
26switch($obj->args['type']) {
27 case 'pg_blks':
28 $obj->legend = array(
29 'heap_hit' => 'Heap hit',
30 'heap_read' => 'Heap read',
31 'idx_hit' => 'Index hit',
32 'idx_read' => 'Index read',
33 'tidx_hit' => 'Toast index hit',
34 'tidx_read' => 'Toast index read',
35 'toast_hit' => 'Toast hit',
36 'toast_read' => 'Toast read',
37 );
38 $obj->rrd_title = sprintf('PostgreSQL Disk I/O (%s)',
39 !empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
40 $obj->rrd_vertical = 'Blocks';
41 break;
42 case 'pg_db_size':
43 $obj->legend = array(
44 'value' => 'Size',
45 );
46 $obj->colors = array(
47 'value' => '0000ff',
48 );
49 $obj->rrd_title = sprintf('PostgreSQL DB size (%s)',
50 !empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
51 $obj->rrd_vertical = 'Bytes';
52 break;
53 case 'pg_n_tup_c':
54 $obj->order = array(
55 'ins',
56 'upd',
57 'hot_upd',
58 'del',
59 );
60 $obj->legend = array(
61 'ins' => 'Insert',
62 'upd' => 'Update',
63 'hot_upd' => 'Hot Update',
64 'del' => 'Delete',
65 );
66 $obj->colors = array(
67 'ins' => '00ff00',
68 'upd' => 'ff7c00',
69 'hot_upd' => '0000ff',
70 'del' => 'ff0000',
71 );
72 $obj->rrd_title = sprintf('PostgreSQL Row actions (%s)',
73 !empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
74 $obj->rrd_vertical = 'Rows';
75 break;
76 case 'pg_n_tup_g':
77 $obj->order = array('live', 'dead');
78 $obj->legend = array(
79 'live' => 'Live',
80 'dead' => 'Dead',
81 );
82 $obj->colors = array(
83 'live' => '00ff00',
84 'dead' => 'ff0000',
85 );
86 $obj->rrd_title = sprintf('PostgreSQL Table states (%s)',
87 !empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
88 $obj->rrd_vertical = 'Rows';
89 break;
90 case 'pg_numbackends':
91 $obj->legend = array(
92 'value' => 'Backends',
93 );
94 $obj->colors = array(
95 'value' => '0000ff',
96 );
97 $obj->rrd_title = sprintf('PostgreSQL Backends (%s)',
98 !empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
99 $obj->rrd_vertical = 'Number';
100 break;
101 case 'pg_scan':
102 $obj->legend = array(
103 'seq' => 'Sequential',
104 'seq_tup_read' => 'Sequential rows',
105 'idx' => 'Index',
106 'idx_tup_fetch' => 'Index Rows',
107 );
108 $obj->rrd_title = sprintf('PostgreSQL Scans (%s)',
109 !empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
110 $obj->rrd_vertical = 'Scans / Rows';
111 break;
112 case 'pg_xact':
113 $obj->legend = array(
114 'commit' => 'Commit',
115 'rollback' => 'Rollback',
116 );
117 $obj->colors = array(
118 'commit' => '00ff00',
119 'rollback' => 'ff0000',
120 );
121 $obj->rrd_title = sprintf('PostgreSQL Transactions (%s)',
122 !empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
123 $obj->rrd_vertical = 'Transactions';
124 break;
125 default:
126 $obj->rrd_title = sprintf('%s/%s', $obj->args['pinstance'], $obj->args['type']);
127 break;
128}
129
130$obj->rrd_graph();