Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
PG_ACTIVICommand line tool for PostgreSQL server activity monitoPG_ACTIVITY(1)

NAME
       pg_activity - Realtime PostgreSQL database server monitoring tool

SYNOPSIS
       pg_activity [option..]

DESCRIPTION
       Command line tool for PostgreSQL	server activity	monitoring.

       pg_activity must	run on the same	server than the	instance and as	the
       user running the	instance (or root) to show CPU,	MEM, READ or WRITE
       columns and other system	informations.

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

       --rds
		 Enable	support	for AWS	RDS.

       --output=FILEPATH
		 Store running queries as CSV.

       --no-db-size
		 Skip total size of DB.

       --verbose-mode=VERBOSE_MODE
		 Queries display mode. Values: 1-TRUNCATED, 2-FULL(default), 3-INDENTED

       --help
		 Show this help	message	and exit.

       --version
		 Show program's	version	number and exit.

ENVIRONMENT VARIABLES
       PGPASSWORD
	     PostgreSQL	password.

       PGPORT
		 Database server port.

       PGUSER
		 Database user name.

       PGHOST
		 Database server host or socket	directory.

       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.

       --no-app-name
		 Disable App.

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

       pg_activity -h /var/run/postgresql

       pg_activity -h myserver -p 5433 -d nagios -U nagios

pg_activity 1.5.0		  2019-03-03			PG_ACTIVITY(1)

NAME | SYNOPSIS | DESCRIPTION | COMMAND-LINE OPTIONS | ENVIRONMENT VARIABLES | DISPLAY OPTIONS | INTERACTIVE COMMANDS | NAVIGATION MODE | EXAMPLES

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=pg_activity&sektion=1&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help