dalibo/pg_activity

📋 Changes

• Strip comments from SQL queries emitted by pg_activity (#442).
• Remove the "tuples returned/s" metric from the header, it provided misleading information (#441, reported by @kmoppel)
• Fix a difference in wrapping behavior introduced in blessed 1.26 (#455, reported by @asarubbo)

🐛 Fixed

• Fix `--hide-queries-in-logs` to also disable log_statements when it is used
• (Kouber Saparev).
• Fix deprecated syntax of the `license` field in packaging metadata; require
• setuptools version 77.0.0 or higher accordingly.
• Remove dummy `setup.py` file.
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.6.0...v3.6.1

✨ Added

• The color of cells in the process table can now be customized through the
• configuration file.
• Add non-negative counterparts of many `--no-...` command-line option, thus
• allowing to enable respective feature/behaviour even if disabled in the
• configuration.
• Add a `y` command to copy focused query to the system clipboard, using
• OSC 52 escape sequence (#311).
• Add the `xmin` column to the query display (#425).

🐛 Fixed

• Fix configuration of the color of `appname` column (#415).
• Fix `datetimeutc` column in CSV export showing wrong "minutes" value (#429).

📋 Changed

• Exit with status 0 upon keyboard interrupt.

🗑️ Removed

• Python 3.8 is no longer supported.
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.5.1...v3.6.0

🐛 Fixed

• Resolve a warning about usage of a deprecated Python `datetime` API from
• Python 3.12.
• Resolve setuptools warnings about packages 'pgactivity.profiles' and
• 'pgactivity.queries' being absent from `packages` configuration by getting
• back to setuptools "automatic discovery" (#411).

📦 Misc

• Turn Python warnings into errors when running the test suite.
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.5.0...v3.5.1

✨ Added

• The *rollback ratio* is now displayed in the "global" header (#385).
• Make header's sections display configurable through the `[header]` section of the configuration file.
• Configuration profiles can now be defined at `${XDG_CONFIG_HOME:~/.config}/pg_activity/<profile>.conf` or `/etc/pg_activity/<profile>.conf` as selected from the command line through `--profile <profile>`.
• Some built-in profiles are distributed with pg\_activity.

📋 Changed

• The help text for `K` action, displayed in the footer, has been rephrased as "terminate underlying session".
• Rephrase the help text of `--no-{inst,sys,proc}-info` options and group them into a dedicated section of `--help` output.

🐛 Fixed

• At startup, do not show a traceback upon failure to connect to PostgreSQL.
• Fix password prompt not shown with psycopg2 backend.
• Fix retrieval of I/O statistics on BSD systems (#393).
• Fix spelling mistakes in the man page.

🗑️ Removed

• Python 3.7 is no longer supported.

📦 Misc

• Document how to *hack* on pg\_activity in the `README`.
• Add a [pre-commit](https://pre-commit.com/) configuration.
• Require psycopg >= 3.1 (when using the psycopg backend) to get a more robust
• detection of connection password need.
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.4.2...v3.5.0

🐛 Fixed

• Fix package installation by not installing `tests` and `docs` directories
• (#378).
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.4.1...v3.4.2

🐛 Fixed

• Add more compatibility for old attr versions (#376).
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.4.0...v3.4.1

✨ Added

• Improve rendering of the `client` column by possibly abbreviating IP
• addresses.
• Add support for configuring pg\_activity from a configuration file in INI
• format and installed at `${XDG_CONFIG_HOME:~/.config}/pg_activity.conf` or
• `/etc/pg_activity.conf`.
• Determine which columns to hide from reading the configuration file (`hidden =
• yes|no` option).
• Determine columns width from the configuration file (`width = <positive
• + 1 more

🐛 Fixed

• Fix a crash when trying to reconnect.
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.3.0...v3.4.0

🐛 Fixed

• Replace the previous header column separator (`⋅`) by a comma to improve user
• experience in situations where that character did not render well (#356,

🐛 Fixed

• Handle conversion between PostgreSQL encoding names and Python ones while
• decoding the `query` column from `pg_stat_activity` with
• `pg_database.encoding` (#348).
• Fix typos in man pages, spotted by codespell.

✨ Added

• When using the psycopg backend, set `client_encoding` to `auto` if unspecified
• in the connection string. This will help getting the appropriate client
• encoding from locale settings, even if the connection database has a different
• one.
• Fall back to a permissive-but-hopefully-more-robust loader for character type
• values if client encoding is really `ascii`, when using the psycopg backend.

📦 Misc.

• Add compatibility with old humanize (>= 0.5.1), to make packaging easier on
• old platforms such as RHEL 8.
• Adjust log messages prefix, removing the "Hint" word and adding the level
• name, as we now emit messages for different purposes.

🐛 Fixed

• Fix crash on startup with no "connection string" argument and the psycopg
• backend #346.

✨ Added

• Add support for Psycopg 3 database driver, as an alternative to psycopg2.
• Packagers and users installing from `pip` are encouraged to install the
• `psycopg` dependency instead of psycopg2.
• Add `psycopg` and `psycopg2` setuptools extras to ease complete installation
• from pip.
• Prepare statements for execution when using the `psycopg` database driver for
• better performance.

🐛 Fixed

• Rework decoding of the `query` column to (hopefully) make it more robust
• (see #149 for the original report, #302 for a new problem raised while fixing
• the previous one and #332 for the latest update).
• Fix a few typos in the man page.

📦 Misc.

• Add a change log file and update the release how-to accordingly.
• Use [codespell](https://github.com/codespell-project/codespell) to check
• misspellings.
• Add Project-URLs core metadata for Python packaging.
• Install the project in *develop* mode in Tox test environment.
• Require blessed >= 1.15.0, as earlier versions are not compatible with Python
• 3.7.

📋 Changes

• Fix a regression where pg_activity would crash if the pidfile could not be read.
• Fix compatibility problems with mypy, flake8 and python 3.11

📋 Changes

• Fix a division by zero where there is no swap (https://github.com/dalibo/pg_activity/issues/318) (Reported by

💥 Breaking change:

• Drop support for Python 3.6
• Attr 18.1 is required

📋 Change log:

• Add more information to the header (instance and process stats) (Tests
• by @Krysztophe)
• Add the --refresh option to the cli to set the refresh rate (#293)
• (Requested by @crysman)
• Add the --debug-file option to enable logging (still mostly unused)
• Add hints about runtime disabled features (#300) (Reported by @rutchkiwi)
• The SUPERUSER privilege is not longer required (#277) (Requested by
• @Raymondmax)
• + 1 more

🐛 Bug fixes:

• Add the --no-walreceiver to disable wal receiver stats for Aurora
• (#301) (Reported by @grutz)
• Add the --no-tempfiles option to disable temp file statistics and
• add it to the --rds command (#303) (Reported by @adityabaradwaj)
• Fix server information queries for v12/v13 (Reported and fixed by
• @kmoppel-cognite)
• Fix InvalidTextRepresentation errors (#275) (Fix proposed by
• @ssharunas)
• + 4 more

🐛 Fixed

• compatibility with attrs older than 18.1 #285

🐛 Fixed

• Fix encoding errors when some database encoding is not UTF-8 https://github.com/dalibo/pg_activity/pull/212
• Fix blocking the query tab for multiple blockers https://github.com/dalibo/pg_activity/pull/241
• Avoid refreshing the header in pause/interractive https://github.com/dalibo/pg_activity/pull/248
• Fix various scrolling issues https://github.com/dalibo/pg_activity/pull/247
• Improve performance during refresh https://github.com/dalibo/pg_activity/pull/249
• Fix IOW status https://github.com/dalibo/pg_activity/pull/252
• Fix typo in manpage https://github.com/dalibo/pg_activity/pull/238

✨ Added

• Handle scrolling with PAGE_UP/PAGE_DOWN and HOME/END https://github.com/dalibo/pg_activity/pull/251
• Introduce a new `--filter` option https://github.com/dalibo/pg_activity/pull/256

📋 Changed

• Remove trailing commas after system information in header https://github.com/dalibo/pg_activity/pull/255
• Document authentication https://github.com/dalibo/pg_activity/pull/254
• Add missing colum qualifier for dbname https://github.com/dalibo/pg_activity/pull/263

🗑️ Deprecated

• Support for Python 3.6 will be dropped in next release.
• Full Changelog: https://github.com/dalibo/pg_activity/compare/v2.2.1...v2.3.0

📋 Changes

• Display the wait_event, when available, in running and blocking queries
• Display `virtualxid` locks in blocking queries
• Gracefully handle keyboard interrupt (SIGINT)
• Rename `--verbose-mode` option as `-w/--query-display-mode` (#189)
• Remove random spaces from queries that wrap (#208)
• Fix a possibly `TypeError` when computing size growth (#233)
• Fix version decoding for pg >= 10 (#200)
• Rework the header part of the UI (more compact and extensible)
• + 3 more

📋 Changes

• Fix tests for Python 3.10a7 (#205)
• Use GH actions for CI

📋 Changes

• Produce nicer error messages for DSN syntax errors
• Handle replication connection (with a `NULL` datname) correctly (#203)

📋 Changes

• Define pg_activity script as an entry point, fixing installation in virtualenvs and `/usr/local` in particular (#197, #196)
• Add support for running as `python -m pgactivity`

📋 Changes

• Fix test issues with Python 3.10 (#194)
• Add python-3.10-dev to travis test matrix

📋 Changes

• Document requirement on psycopg2 version
• Fix query name for 'get_active_connections' (#190)

📋 Changes

• Update man page to mention `<connection string>` argument
• Try to reconnect indefinitely when connection is lost
• Use yellow instead of orange for `PAUSE`
• Move SQL queries from Python code to individual SQL files
• Truncate long database names on Python side
• Do not display IDLE queries as None for old postgresql versions
• Let libpq handle default values for connection options (hostname, port, database name and user name)
• Set `application_name='pg_activity'` for client connections
• + 1 more

📋 Changes

• Fix sorting logic when the duration field is None (#168)

📋 Changes

• Handle absence of some fields in memory info on OSX (#165)
• Handle 'query' field possibly being empty when display processes (#165)

📋 Changes

• Add a connection string argument (#151, #147)
• Clear screen when exiting help and avoid clearing the screen when not needed
• Handle ZeroDivisionError in Data.pg_get_db_info()
• Handle reconnection to postgres
• Update screenshot in README

📋 Changes

• Fix compatibility issue with old blessed version in help
• Drop --debug option, no longer handled
• Avoid screen refresh when in help view

📋 Changes

• Ensure compatibility with older blessed version (1.15)
• Update man page
• Set shebang to use python3 in main script