Skip to content
Mirror of git://git.postgresql.org/git/pg_top.git
C Groff Other
Failed to load latest commit information.
machine Removal of hpux8-related files
.gitignore Ignore ctag files
.hgignore Updated the ignore file and fixed the Makefile to include the database
.hgtags Added tag v3.6.2-beta4 for changeset 40305117300a
FAQ Update docs and man pages
HISTORY Set to 3.7.0-beta1
INSTALL Renamed 'ptop' to 'pg_top'.
LICENSE Update docs and man pages
Makefile.am Put main loop into separate function
Porting monitor the disk space of the server
README Update docs and man pages
TODO Set to 3.7.0-beta1
Y2K Renamed 'ptop' to 'pg_top'.
autogen.sh Changed to /bin/sh as opposed to /bin/bash because there's no reason to
boolean.h Ran pgindent to clean up formatting of the code and make it all uniform.
c.h Ran pgindent from PostgreSQL 8.3.0.
color.c Ran pgindent from PostgreSQL 8.3.0.
color.h Ran pgindent from PostgreSQL 8.3.0.
commands.c Add 2 sig figs to CALLS for pg_stat_statements
commands.h Map function pointers to commands
config.guess [svn] Create release 3.6.1
config.sub [svn] Create release 3.6.1
configure.ac Bump version to 4.0.0 devel
display.c monitor the disk space of the server
display.h monitor the disk space of the server
getopt.c Added support for OpenBSD, tested on 4.2.
help.h Proof of concept for pg_stat_statements
layout.h monitor the disk space of the server
loadavg.h Updates for freebsd 9
machine.h Put main loop into separate function
message.h Ran pgindent to clean up formatting of the code and make it all uniform.
os.h macosx 10.4 (intel) support, sysctl() calls
pg.c Add 2 sig figs to CALLS for pg_stat_statements
pg.h Allow sorting of pg_stat_statements view
pg_top.1.in Improvement of docs, help messages and addition of long options
pg_top.c Allow sorting of pg_stat_statements view
pg_top.h Allow sorting of pg_stat_statements view
pg_trace.h Can now specific database name, username, password, and port for the
port.h Ran pgindent from PostgreSQL 8.3.0.
remote.h Added functionality to display i/o stats per process for remote Linux
screen.c Use strncpy instead of strcpy
screen.h Ran pgindent to clean up formatting of the code and make it all uniform.
sigconv.awk [svn] Create release 3.6.1
sprompt.c Can now specific database name, username, password, and port for the
username.c Renamed 'ptop' to 'pg_top'.
username.h Used more strict types, hopefully a good thing.
utils.c Added a format_b() function to format strings from numbers that in in
utils.h Added a format_b() function to format strings from numbers that in in
version.c Renamed 'ptop' to 'pg_top'.
version.h Ran pgindent to clean up formatting of the code and make it all uniform.

README

								  pg_top
							 Version 3.7.0

							   Mark Wong
						and a cast of ... a few


pg_top is 'top' for PostgreSQL. It is derived from Unix Top. Similar to top,
pg_top allows you to monitor PostgreSQL processes. It also allows you to:

    * View currently running SQL statement of a process.
    * View query plan of a currently running SELECT statement.
    * View locks held by a process.
    * View user table statistics.
    * View user index statistics.

CAVEAT: version 3 of pg_top has internal commands that kill and renice
processes.  Although I have taken steps to insure that pg_top makes
appropriate checks with these commands, I cannot guarantee that these
internal commands are totally secure.  IF YOU INSTALL pg_top SET-USER-ID
TO ROOT, YOU DO SO AT YOUR OWN RISK!  I realize that some operating
systems will require pg_top to run setuid root, and I will do everything
I can to make sure that pg_top is a secure setuid program.

To compile and install "pg_top", read the file "INSTALL" and follow the
directions and advice contained therein.

If you make any kind of change to "pg_top" that you feel would be
beneficial to others who use this program, or if you find and fix a bug,
please send the change to the pg_top mailing list.

In order to monitor a remote database, the pg_proctab extension needs to be
created on the database to be monitored.  Any operating system that pg_proctab
supports can be monitored remotely on any operating system.  See details for
pg_protab here:

http://pgxn.org/dist/pg_proctab/

Be sure to read the FAQ enclosed with the distrubution.  It contains
answers to the most commonly asked questions about the configuration,
installation, and operation of pg_top.


AVAILABILITY

Project home page:

http://ptop.projects.postgresql.org/

If you have git, you can download the source code:

git clone git://git.postgresql.org/git/pg_top.git


GRATITUDE

Selena Deckelmann & Gabrielle Roth, and the beer & free wi-fi at County Cork
pub in Portland, OR, USA.


LICENSE

pg_top is distributed free of charge under the same terms as the BSD
license.  For an official statement, please refer to the file "LICENSE"
which should be included with the source distribution.


AUTHOR

Mark Wong
Something went wrong with that request. Please try again.