NAME¶
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 USERNAME, --username=USERNAME
-
Database user name (default: $USER).
- -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).
- --help
-
Show this help message and exit.
- --version
-
Show program's version number and exit.
ENVIRONMENT VARIABLES¶
- PGPASSWORD
-
PostgreSQL password
- PGPASSFILE
-
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 TIME+, descending.
- Space Pause on/off.
- v Change queries display mode: full, truncated, indented
- UP / DOWN 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¶
- 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.
EXAMPLES¶
PGPASSWORD='mypassword' pg_activity -U pgadmin -h 127.0.0.1 --no-client -C
pg_activity -h /tmp
