pg_activity

Command line tool for PostgreSQL server activity monitoring.

Dependencies

• python ≥ 2.6
• psycopg2 ≥ 2.2.1
• psutil ≥ 0.5.1

Installation from sources: setuptools ≥ 0.6.14

Installation

sudo python setup.py install

Installation with man page

sudo python setup.py install --with-man

Usage

pg_activity works localy or remotely. In local execution context, to obtain sufficient rights to display system informations, the system user running pg_activity must be the same user running postgresql server (postgres by default), or have more rights like root. Otherwise, pg_activity can fallback to a degraded mode without displaying system informations. On the same way, PostgreSQL user used to connect to the database must be super-user.
ex:

sudo -u postgres pg_activity -U postgres

Options

pg_activity [options]

Options:
	--version            Show program's version number and exit 
	-U USERNAME, --username=USERNAME
                    	  Database user name (default: "postgres").
	-p PORT, --port=PORT  Database server port (default: "5432").
	-h HOSTNAME, --host=HOSTNAME
						  Database server host or socket directory (default:
                    	  "localhost").
    -d DBNAME, --dbname=DBNAME
                          Database name to connect to (default: "postgres").
	-C, --no-color        Disable color usage.
	--blocksize=BLOCKSIZE Filesystem blocksize (default: 4096).
	--rds                 Enable support for AWS RDS.
	--help                Show this help message and exit.
	--debug               Enable debug mode for traceback tracking.
    

Display options, you can exclude some columns by using them :
	--no-database         Disable DATABASE.
	--no-user             Disable USER.
	--no-client           Disable CLIENT.
	--no-cpu              Disable CPU%.
	--no-mem              Disable MEM%.
	--no-read             Disable READ/s.
	--no-write            Disable WRITE/s.
	--no-time             Disable TIME+.
	--no-wait             Disable W.

Interactives commands

Key	Action
C	Activate/deactivate colors
r	Sort by READ/s, descending
w	Sort by WRITE/s, descending
c	Sort by CPU%, descending
m	Sort by MEM%, descending
t	Sort by TIME+, descending
Space	Pause on/off
v	Change queries display mode: full, truncated, indented
UP/DOWN	Scroll processes list
q	Quit
+	Increase refresh time. Maximum value : 3s
-	Decrease refresh time. Minimum Value : 1s
F1/1	Running queries list
F2/2	Waiting queries list
F3/3	Blocking queries list
h	Help page
R	Refresh

Navigation mode

Key	Action
UP	Move up the cursor
DOWN	Move down the cursor
k	Terminate the current backend/tagged backends
Space	Tag or untag the process
q	Quit
Other	Back to activity

Screenshot