viewvc.cgi/cricket/parse_pg_stat.pl

#!/usr/bin/perl -w

use strict;
use DBI;

my $user = "dpavlin";
my $host = shift @ARGV || '';
$host = ";host=$host" if ($host);

my $sql = "select sum(numbackends),sum(xact_commit),sum(xact_rollback),sum(blks_read),sum(blks_hit) from pg_stat_database";

my $dbh = DBI->connect("DBI:Pg:dbname=template1$host",$user,"") || die $DBI::errstr;
my $sth=$dbh->prepare($sql);

if ($sth->execute()) {
        print join("\n",$sth->fetchrow_array()),"\n";
}

undef $sth;
$dbh->disconnect();
1	#!/usr/bin/perl -w
2
3	use strict;
4	use DBI;
5
6	my $user = "dpavlin";
7	my $host = shift @ARGV \|\| '';
8	$host = ";host=$host" if ($host);
9
10	my $sql = "select sum(numbackends),sum(xact_commit),sum(xact_rollback),sum(blks_read),sum(blks_hit) from pg_stat_database";
11
12	my $dbh = DBI->connect("DBI:Pg:dbname=template1$host",$user,"") \|\| die $DBI::errstr;
13	my $sth=$dbh->prepare($sql);
14
15	if ($sth->execute()) {
16	print join("\n",$sth->fetchrow_array()),"\n";
17	}
18
19	undef $sth;
20	$dbh->disconnect();