plugin/postgresql: support for all predefined queries

- pg_blks
- pg_n_tup_c
- pg_n_tup_g
- pg_numbackends
- pg_scan
- pg_xact

1 files changed, 89 insertions, 3 deletions

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;
 }