From 54145cacca8e99155c0bb328b8ac0c0e8737f8cd Mon Sep 17 00:00:00 2001
From: Pim van den Berg
Date: Tue, 15 Mar 2011 21:12:00 +0100
Subject: plugin/postgresql: support for all predefined queries

- pg_blks
- pg_n_tup_c
- pg_n_tup_g
- pg_numbackends
- pg_scan
- pg_xact
---
 plugin/postgresql.php | 92 +++++++++++++++++++++++++++++++++++++++++++++++++--
 1 file changed, 89 insertions(+), 3 deletions(-)

(limited to 'plugin')

diff --git a/plugin/postgresql.php b/plugin/postgresql.php
index 9680a4f..1eadc8d 100644
--- a/plugin/postgresql.php
+++ b/plugin/postgresql.php
@@ -27,6 +27,21 @@ $obj->heigth = $heigth;
 $obj->rrd_format = '%5.1lf%s';
 
 switch($obj->args['type']) {
+	case 'pg_blks':
+		$obj->ds_names = array(
+			'heap_hit'   => 'Heap hit',
+			'heap_read'  => 'Heap read',
+			'idx_hit'    => 'Index hit',
+			'idx_read'   => 'Index read',
+			'tidx_hit'   => 'Toast index hit',
+			'tidx_read'  => 'Toast index read',
+			'toast_hit'  => 'Toast hit',
+			'toast_read' => 'Toast read',
+		);
+		$obj->rrd_title = sprintf('PostgreSQL Disk I/O (%s)',
+			!empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
+		$obj->rrd_vertical = 'Blocks';
+	break;
 	case 'pg_db_size':
 		$obj->ds_names = array(
 			'value' => 'Size',
@@ -34,13 +49,84 @@ switch($obj->args['type']) {
 		$obj->colors = array(
 			'value' => '0000ff',
 		);
-		$obj->rrd_title = sprintf('DB Size %s',
+		$obj->rrd_title = sprintf('PostgreSQL DB size (%s)',
+			!empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
+		$obj->rrd_vertical = 'Bytes';
+	break;
+	case 'pg_n_tup_c':
+		$obj->order = array(
+			'ins',
+			'upd',
+			'hot_upd',
+			'del',
+		);
+		$obj->ds_names = array(
+			'ins'     => 'Insert',
+			'upd'     => 'Update',
+			'hot_upd' => 'Hot Update',
+			'del'     => 'Delete',
+		);
+		$obj->colors = array(
+			'ins'     => '00ff00',
+			'upd'     => 'ff7c00',
+			'hot_upd' => '0000ff',
+			'del'     => 'ff0000',
+		);
+		$obj->rrd_title = sprintf('PostgreSQL Row actions (%s)',
+			!empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
+		$obj->rrd_vertical = 'Rows';
+	break;
+	case 'pg_n_tup_g':
+		$obj->order = array('live', 'dead');
+		$obj->ds_names = array(
+			'live' => 'Live',
+			'dead' => 'Dead',
+		);
+		$obj->colors = array(
+			'live' => '00ff00',
+			'dead' => 'ff0000',
+		);
+		$obj->rrd_title = sprintf('PostgreSQL Table states (%s)',
+			!empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
+		$obj->rrd_vertical = 'Rows';
+	break;
+	case 'pg_numbackends':
+		$obj->ds_names = array(
+			'value' => 'Backends',
+		);
+		$obj->colors = array(
+			'value' => '0000ff',
+		);
+		$obj->rrd_title = sprintf('PostgreSQL Backends (%s)',
+			!empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
+		$obj->rrd_vertical = 'Number';
+	break;
+	case 'pg_scan':
+		$obj->ds_names = array(
+			'seq'           => 'Sequential',
+			'seq_tup_read'  => 'Sequential rows',
+			'idx'           => 'Index',
+			'idx_tup_fetch' => 'Index Rows',
+		);
+		$obj->rrd_title = sprintf('PostgreSQL Scans (%s)',
+			!empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
+		$obj->rrd_vertical = 'Scans / Rows';
+	break;
+	case 'pg_xact':
+		$obj->ds_names = array(
+			'commit'   => 'Commit',
+			'rollback' => 'Rollback',
+		);
+		$obj->colors = array(
+			'commit'   => '00ff00',
+			'rollback' => 'ff0000',
+		);
+		$obj->rrd_title = sprintf('PostgreSQL Transactions (%s)',
 			!empty($obj->args['pinstance']) ? $obj->args['pinstance'] : '');
-		$obj->rrd_vertical = 'Size';
+		$obj->rrd_vertical = 'Transactions';
 	break;
 	default:
 		$obj->rrd_title = sprintf('%s/%s', $obj->args['pinstance'], $obj->args['type']);
-		$obj->rrd_vertical = 'Ops per second';
 	break;
 }
 
-- 
cgit v1.1