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