pg_activity
pg_activity copied to clipboard
dalibo
pg_activity is a top like application for PostgreSQL server activity monitoring.
Hi. This looks like a really cool tool but I can not manage to get the CPU% column to show under MacOS (10.15.7). I launch like this `pg_activity --dbname=web` I...
Can pg_activity ignore columns? Thanks. ``` File "/usr/local/bin/pg_activity", line 8, in sys.exit(main()) File "/usr/local/lib/python3.8/dist-packages/pgactivity/cli.py", line 299, in main ui.main(term, dataobj, host, options, dsn) File "/usr/local/lib/python3.8/dist-packages/pgactivity/ui.py", line 196, in main pg_procs.set_items(data.pg_get_activities(ui.duration_mode))...
Example: ``` psycopg2.errors.InsufficientPrivilege: permission denied for function pg_ls_tmpdir ```
Using `pg_activity 3.0.0a1` (commit 560070616458b606efd0c1d06166be0bec534ce9) against an AWS RDS/Aurora database, the following traceback occurs with `psycopg2-binary==2.9.3` ``` $ pg_activity -U -h -d --rds --no-db-size Traceback (most recent call last): File...
See discussion at #291. From postgres 13, maybe we could rely on `leader_pid` column of `pg_stat_activity` view as first sort step on SQL side?
@Krysztophe was surprised that we couldn't see the idle sessions. This is something that we could display when we have more filters available.
I'm thinking of replacing blessed with [rich](https://github.com/willmcgugan/rich) as a terminal rendering library. Rich is now mature and provides high level features that would be nice for us as we could...
Currently, we have those infos in the header part : (the 3 last lines are removed in non local mode) ``` PostgreSQL 13.2 - benoit-dalibo - postgres@/var/run/postgresql:5433/postgres - Ref.: 2s...
As noticed in #239, and described in more details in #257, scrolling is broken when queries are wrapped. At the moment, I don't see any good solution to this issue:...