Pg Activity Versions Save

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

v2.1.1

3 years ago

Bug fixes:

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

v2.1.0

3 years ago

Bug fixes:

  • Update man page to mention <connection string> argument
  • Try to reconnect indefinitely when connection is lost

Changes:

  • 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
  • Add a --hide-queries-in-logs option to hide pg_activity's queries from server logs

v2.0.3

3 years ago

Bug fix:

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

v2.0.2

3 years ago

Bug fixes:

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

v2.0.0

3 years ago

Change log:

  • 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

v2.0.0a3

3 years ago

Change log:

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

v2.0.0a2

3 years ago

Change log:

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

v2.0.0a1

3 years ago

Change log:

  • Require Python >= 3.6 (#145)
  • Rewrite the UI, clean up many things (#145)
  • Add type hints, checked with mypy (#145)
  • Add tests, run with Python 3.6 to 3.9 in Travis-CI (#145)
  • Let k/j keys scroll the process list in interactive mode (#145)
  • Change keys to cancel ('C') and terminate ('K') a process in interactive mode (#145)
  • Drop support for color de-activation (#145)
  • Make the confirmation dialog for interactive actions nicer (#145)
  • Add user and client columns in blocking and waiting queries mode (#145)
  • Add a --no-pid option flag (#145)
  • Drop compatibility for ancient psutil versions (#145)
  • Update installation instructions (#152)
  • Change author information and project URL to Dalibo (#152)
  • Declare the license correctly in setup.py (#152)
  • Add more classifiers for PyPI (#152)
  • Add keywords for PyPI (#152)

v1.6.2

3 years ago

Bump version to 1.6.2

Bug fixes:

  • Fix problems with versions of PostgreSQL older than 9.2. With this release of PostgreSQL, the column state was added in pg_stat_activity. The column current_query was also renamed to query. (fix: @blogh)

v1.6.1

4 years ago

Bug fix:

  • Fix #139 : Fix duration mode for v11+ (@blogh)