pgcenter 还是21年更新的了,对PG 16.9 居然还能用
➜ /workspace wget https://github.com/lesovsky/pgcenter/releases/download/v0.9.2/pgcenter_0.9.2_linux_amd64.tar.gz ➜ /workspace tar zxvf pgcenter_0.9.2_linux_amd64.tar.gz
README.md
pgcenter➜ /workspace ./pgcenter --version
pgcenter v0.9.2 7ebd54847cbbf72a98cbde39e9afc3845cba9839-release➜ /workspace ./pgcenter top -h 127.0.0.1 -dpostgres -Upostgres
pgcenter v0.9.2 (7ebd54847cbbf72a98cbde39e9afc3845cba9839, release): Help for interactive commands )t
general actions: a,f,r,w mode: 'a' activity, 'f' functions, 'r' replication, 'w' WAL, ms,t,i 's' tables sizes, 't' tables, 'i' indexes.d,D 'd' pg_stat_database switch, 'X' pg_stat_database menu. x,X 'x' pg_stat_statements switch, 'X' pg_stat_statements menu. _p,P 'p' pg_stat_progress_* switch, 'P' pg_stat_progress_* menu.Left,Right,<,/ 'Left,Right' change column sort, '<' desc/asc sort toggle, '/' set filter.Up,Down 'Up' increase column width, 'Down' decrease column width.C,E,R config: 'C' show config, 'E' edit configs, 'R' reload config.~ start psql session.l open log file with pager.extra stats actions:B,N,F,L 'B' diskstat, 'N' nicstat, 'F' filesystems, L' logtail.activity actions:-,_ '-' cancel backend by pid, '_' terminate backend by pid.n,m 'n' set new mask, 'm' show current mask.k,K 'k' cancel group of queries using mask, 'K' terminate group of backends using mask.I show IDLE connections toggle.A change activity age threshold.G get query report.other actions:, Q ',' show system tables on/off, 'Q' reset postgresql statistics counters.z 'z' set refresh interval.h,F1 show this tab.q,Ctrl+Q quit.Type 'q' or 'Esc' to continue.