Command line tool for PostgreSQL server activity monitoring.
python≥ 2.6psycopg2≥ 2.2.1psutil≥ 0.5.1
Installation from sources:
setuptools ≥ 0.6.14
sudo python setup.py install
sudo python setup.py install --with-man
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
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.
| 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 |
| 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 |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent