Pg Activity Versions Save

pg_activity is a top like application for PostgreSQL server activity monitoring.

v3.5.0

3 weeks ago

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 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

v3.4.2

9 months ago

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

v3.4.1

9 months ago

Fixed

  • Add more compatibility for old attr versions (#376).

Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.4.0...v3.4.1

v3.4.0

10 months ago

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 integer> option).

Fixed

  • Fix a crash when trying to reconnect.

Full Changelog: https://github.com/dalibo/pg_activity/compare/v3.3.0...v3.4.0

v3.3.0

1 year ago

Fixed

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

v3.2.0

1 year ago

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.

v3.1.1

1 year ago

Fixed

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

v3.1.0

1 year ago

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 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.

v3.0.3

1 year ago

v3.0.2

1 year ago
  • 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