pgcenter

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,                                                                                         m
    s,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.