Skip site navigation (1) Skip section navigation (2)

New PostgreSQL session monitor

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>, PostgreSQL-announce <pgsql-announce(at)postgreSQL(dot)org>, PostgreSQL-Admin <pgsql-admin(at)postgreSQL(dot)org>
Subject: New PostgreSQL session monitor
Date: 2001-03-17 05:13:37
Message-ID: 200103170513.AAA18304@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-announcepgsql-general
I have written a database session monitor for PostgreSQL.  Attached is
the README file that contains information on where to get it and what it
does.

---------------------------------------------------------------------------

                              P G   M O N I T O R

pgmonitor (version 0.21, 2001-03-16)

The main web site for pgmonitor is:
	http://greatbridge.org/project/pgmonitor/projdisplay.php

You can download the most recent version from
	ftp://ftp.greatbridge.org/pub/pgmonitor

This tool allows monitoring of PostgreSQL activity.  It requires Tcl/Tk
8.0 or later.  It may require modification of the 'ps' flags for certain
platforms.  It is known to run on *BSD, Linux, and HPUX.

Pgmonitor only works when run on the database server machine.  To use it
remotely, log into the remote machine, set the DISPLAY variable to point
to your local X server, and start pgmonitor.  Pgmonitor will then run on
the remote machine, but will display on your local machine.

Pgmonitor uses 'ps' to display backend process activity.  It uses 'gdb'
to display running queries, and 'kill' to cancel queries and terminate
database connections.

Pgmonitor stores your most recent refresh and sort settings in the file
~/.pgmonitor.  This file is used to reload your defaults every time
pgmonitor is started.

If you are running PostgreSQL 7.1 or earlier, the 'query' button will
not work unless you compile PostgreSQL with debug symbols (-g), or apply
the supplied patch 'query_display.diff' and recompile PostgreSQL.  The
later method is recommended.

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Responses

pgsql-announce by date

Next:From: Marek PętlickiDate: 2001-03-17 11:54:57
Subject: Re: New PostgreSQL session monitor
Previous:From: Tom LaneDate: 2001-03-16 16:39:09
Subject: NOTICE about updating to 7.1beta6 from earlier betas

pgsql-admin by date

Next:From: jrenizDate: 2001-03-17 05:19:35
Subject: trigger problem!
Previous:From: Tom LaneDate: 2001-03-15 19:42:59
Subject: Re: psql bug? Segfault from source users != dest users

pgsql-general by date

Next:From: jrenizDate: 2001-03-17 05:22:44
Subject: Trigger problem
Previous:From: Russell HiresDate: 2001-03-17 01:46:52
Subject: Re: Re: URL for gmake

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group