pg_activity 1.6.0

Change log:

• Add the --min-duration flag to only show laggy queries (@kmoppel)
• Add the --duration-mode and the shortcut (T) to choose the duration modes: query, transaction, backend (@nilshamerlinck )
• Move to dalibo labs (@daamien)
• Expand current 1-3s refresh interval to 0.5-5s (@kmoppel)
• Add a refresh dbsize interative action shortcut (D) (Fabio Renato Geiss)
• Add --verbose-mode in man page (@julmon)

Bug fixes:

• Fix #130: change the handling of parallel workers and fix a problem with PoWA (fix: @blogh @julmon, report: @debnet)
• Fix #118: psycopg2 has to be installed manually before pg_activity (fix: @blogh, report: @kmoppel)
• Fix issue with undefined debug variable (@pensnarik)
• Fix #119: some columns have been shifted in Waiting / Blocking views (fix: @julmon, report: @kmoppel)
• Fix #113: Do not try to display query duration if not there (fix: @julmon, report: @pmpetit)

pg_activity 1.5.0

Change log:

• Add active connections to summary (@crisnamurti)
• Add application_name (@michelmilezzi)
• Doc update about system info + examples (@Krysztophe)
• More consistent version comparission (@nseinlet)
• New option to avoid total db sizes (@nseinlet)
• Add PGSERVICE support (@julmon)
• New option to change queries display mode on start (Fabio Renato Geiss)
• Save running queries list as CSV with --output option (@julmon)
• Try to reconnect to PostgreSQL cluster (@julmon)

Bug fixes:

• Fix #76: cast client column to text and return 'local' if null (@julmon)
• Fix #75: state column does not exist with postgres prior to 9.2 (@julmon)
• Fix #74: ignore psutil warnings when fetching memory stats (@julmon)

pg_activity 1.4.0

Change log:

• Support of new PostgreSQL version format (@fabriziomello)
• PostgreSQL 10 support
• state column in all views (@mdelca)
• Option to cancel a backend (@fabriziomello)

Bug fixes:

• e9d4ab1 process['database'] can be None for some maintenance processes

pg_activity 1.3.1

Add PostgreSQL 9.6 support.

pg_activity 1.3.0

Change log:

• Python 3 support.
• #45: Adds support for using pg_activity with Amazon RDS.
• #41: Handle PGUSER, PGPORT and PGHOST environment variables.
• #43: Display database name in header.

Bug fixes:

• #39: Depraction: warning get_memory_percent() is depracted
• 1f195b8, cca010c: New way of checking privileges of the system user running pg_activity.

v1.2.0

Multiple fixes:

• psutils v2 API support.
• #33: Catch also TypeError error when trying to fetch process name.
• #13: Man page is not installed by default, have to use option --with-man.
• bug fix on infinite recursion loop due to bad method wrapping.

pg_activity 1.1.1

bug fix: crash in degraded mode due to a typo.

pg_activity 1.1.0

pg_activity 1.1.0

Change log:

• code separation between data extraction and UI
• bug fix: remove USER column header in WAITING and BLOCKING views
• new way for IOPS counting: only reads & writes done by postgress backends are considered
• tag/untag process
• capability to terminate all tagged backend at the same time
• change license to PostgreSQL License model
• new option: --blocksize=BLOCKSIZE (default: 4096), used by IOPS counting
• bug fix: an error was thrown on WAITING/BLOCKING views with some old psycopg2 versions