pg_activity: Realtime postgresql database server monitoring tool

SYNOPSIS

pg_activity [-UphdC]

DESCRIPTION

pg_activity is a htop like application for PostgreSQL server activity monitoring.

COMMAND-LINE OPTIONS

-U \s-1USERNAME\s0, --username=USERNAME

        Database user name (default: $USER).

-p \s-1PORT\s0, --port=PORT

Database server port (default: "5432").

-h \s-1HOSTNAME\s0, --host=HOSTNAME

Database server host or socket directory (default: "localhost").

-d \s-1DBNAME\s0, --dbname=DBNAME

Database name to connect to (default: "postgres").

-C, --no-color

Disable color usage.

--blocksize=BLOCKSIZE

Filesystem blocksize (default: 4096).

--help

Show this help message and exit.

--version

Show program's version number and exit.

ENVIRONMENT VARIABLES

\s-1PGPASSWORD\s0: PostgreSQL password
\s-1PGPASSFILE\s0: Path to .pgpass file (default is ~/.pgpass)

DISPLAY OPTIONS

--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.

INTERACTIVE COMMANDS

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 \s-1TIME+\s0, descending.
Space Pause on/off.
v Change queries display mode: full, truncated, indented
\s-1UP\s0 / \s-1DOWN\s0 Scroll process list.
q Quit
+ Increase refresh time. Maximum value : 3s
- Decrease refesh time. Minimum Value : 1s
F1/1 Running queries monitoring.
F2/2 Waiting queries monitoring.
F3/3 Blocking queries monitoring.
h Help page.
R Refresh.

NAVIGATION MODE

\s-1UP\s0 Move up the cursor.
\s-1DOWN\s0 Move down the cursor.
k Terminate the current backend/tagged backends.
Space Tag or untag the process.
q Quit.
Other Back to activity.

EXAMPLES

PGPASSWORD='mypassword' pg_activity -U pgadmin -h 127.0.0.1 --no-client -C

pg_activity -h /tmp