- Notifications
You must be signed in to change notification settings - Fork0
PostgreSQL Stat Progress (pg_stat_progress) CLI Monitor
License
NotificationsYou must be signed in to change notification settings
noborus/pgsp
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
A CUI tool that monitors PostgreSQL's pg_stat_progress*.
Supported progress reports are ANALYZE, CLUSTER, CREATE INDEX, VACUUM, COPY, and BASE_BACKUP.SeeProgress Reporting for more information.
go 1.18 or later
go install github.com/noborus/pgsp/cmd/pgsp@latestShows a progress bar if pg_stat_progress* is updated while waiting while running.
$pgsp --dsn'host=/var/run/postgresql port=5432'Using config file: /home/noborus/.pgsp.yamlquit: q, ctrl+c, escpg_stat_progress_basebackup pid | 402006 phase | streaming database files backup_total | 10976660480 backup_streamed | 6093522944 tablespaces_total | 1 tablespaces_streamed | 0█████████████████████████░░░░░░░░░░░░░░░░░░ 56%
It is also possible to specify one of theanalyze,basebackup,cluster,createindex,vacuums,copy for monitoring.
pgsp basebackupMonitors PostgreSQL's pg_stat_progress_*.Usage: pgsp [flags] pgsp [command]Available Commands: analyze analyze basebackup basebackup cluster cluster copy copy createindex createindex help Help about any command vacuum vacuumFlags: -a, --AfterCompletion int Time to display after completion(Seconds) (default 10) -i, --Interval float Update interval(Seconds) (default 0.5) --config string config file (default is $HOME/.pgsp.yaml) --dsn string PostgreSQL data source name -f, --fullscreen Display in Full Screen -h, --help help for pgsp -t, --toggle Help message for toggle -v, --version display version informationUse "pgsp [command] --help" for more information about a command.
About
PostgreSQL Stat Progress (pg_stat_progress) CLI Monitor
Topics
Resources
License
Stars
Watchers
Forks
Packages0
No packages published