Changelog
[2.4.0]
Added
- Our name and version are now in
pg_get_loaded_modules() for PostgreSQL 18+
- Support for
EXEC_BACKEND builds (PG-2547)
- Add PostgreSQL 19 support (PG-2424): add generic and custom plan counts, support property graphs, use ComputeConstantLengths API for constants squashing
- Backport test cases from pg_stat_statements
Changed
- Both username and datname are now empty if we cannot get real values (PG-1459)
- Save username and
application_name before executing commands (PG-2281, PG-2557)
- Add
STABLE, LEAKPROOF and PARALLEL SAFE to functions
- Set unit for
pg_stat_monitor.pgsm_query_max_len to bytes
- Do not leave the
pgsm_create_view() function after running CREATE EXTENSION
- Specifying
USE_PGXS is no longer necessary when building with make
- Deprecate the
pgsm_track_application_names parameter, application name now tracked always (PG-2602)
- Show
NULL instead of 'unknown' when application_name is not set
Removed
- PostgreSQL 13 support (PG-2187)
- The deprecated
pgsm_overflow_target GUC parameter (PG-2279)
- Support for non-PGXS builds
Fixed
- Fix memory leak by scoping local memory context to the current transaction (PG-2229)
- Confusion of
local_blk_read_time and local_blk_write_time where writes were recorded in both fields
- Performance bug when saving
application_name
- Off-by-one bug in comment extraction (PG-2485)
- Potential buffer overflow with deeply nested queries (PG-2511)
- Potential buffer overread in comment extraction (PG-2540)
- Do not access
PlannedStmt after we call standard_ProcessUtility() (PG-2486)
- Various improvements to the stability of our test suite
- Make sure that for prepared statements utility statement exec info read at the executor start hook, where data is not yet modified by query itself
- Do not acquire LWLock under spinlock
- Race condition where we could leak memory for the parent query
plans now counts only actual planner invocations instead of every execution: utility statements and executions that reuse a cached plan no longer bump the counter
- Normalize the query text of utility statements (PG-2623)
- Hide sensitive data for users who has no privileges (PG-2624)
- Fix buffer overflow in query normalization (PG-2735)
[2.3.2] - 2026-03-02
Fixed
- Always truncate query strings at multi-byte character boundaries (PG-2116)
- Fix buffer overflow with high
pgsm_max_buckets
- Silence some compialtion warnings (Andrei Lepikhov)
[2.3.1] - 2025-11-27
Added
- PostgreSQL 18 support (PG-1907)
- Columns to track parallel worker activity
- Add tracking of
wal_buffers_full
- Support constant lists squashing in query jumbling
Removed
Fixed
- Fix returned vaules from C function (PG-1931)
- Reduce memory usage by deleteing unnecessary entires from the query stack (PG-2005)
- Fix crash due to unitialized values on the query string stack (PG-2014)
[2.2.0] - 2025-06-30
Fixed
- Fix comment removal in query hash calculation (PG-1674)
- Fix performance issue in comment extraction in large queries (PG-1674)
- Fix error levels in PostreSQL 17 (PG-1313)
- Fix bug where
cmd_type often was 0 (PG-1621)