Release Notes

Below is the complete list of release notes for every version of pg_stat_monitor.

2.0.4

Bug Fixes

GH-425 - Resolving a possible issue that could lead to pg_stat_monitor deadlocking in pgsm_store

2.0.3

Bug Fixes

GH-425 - pg_stat_monitor crashes PostgreSQL if there is citus library loaded

2.0.2

Bug Fixes

GH-418 - Fixed compilation issue with PG16 and added meson.build file.

2.0.1

Bug Fixes

PG-613 - Fixed the issue with segmentation fault error when the query plan is enabled on large queries.

PG-624 - Fixed the server crash when running pgbench with pg_stat_monitor loaded by improving the handling of the dynamic number of buckets.

2.0.0

Improvements

PG-310: Bucket is “Done” vs still being current/last

PG-400: Add timezone in datetime columns in pg_stat_monitor view.

PG-435: PostgreSQL 15 Support by adding newly introduced columns

PG-488: Update query buffer overflow management to use dynamic shared memory

PG-543: PostgreSQL’s pg_stat_statements compatible view.

PG-545: Same query text should generate same queryid

PG-569: Make all data types of pg_stat_monitor view compatible with pg_stat_statements

PG-586: CPU and user timing should be captured for utility statements as well

PG-588: Fix missing query and query normalization issue; rearchitect pg_stat_monitor

PG-606: New GUC required for enabling/disabling of pgsm_query_id calculation

PG-607: Allow histogram to track queries in sub-ms time brackets

Bug Fixes

PG-306: bucket_start_time - TEXT vs TIMESTAMP?

PG-320: Remove state/state_code fields from pg_stat_monitor_view.

PG-321: Remove redundant cmd_type/cmd_type_text columns in pg_stat_monitor view.

PG-354: Remove pg_stat_monitor_settings view

PG-373: Remove wal fields for PG12 and below

PG-518: Internal Functions should NOT be visible in PGSM API.

PG-579: Querying pg_stat_monitor view crashes the server when pg_stat_monitor.so is not configured in shared_preload_libraries

PG-582: blk_read_time and blk_write_time are not being rounded.

PG-583: Rounded time based values are not consistent

PG-597: Remove rounding off for floating point values

PG-569: Make all data types of pg_stat_monitor view compatible with pg_stat_statements

1.1.1

Improvements

PG-462: Initial Support for PostgreSQL15 was added

1.1.0

Improvements

PG-474: Make pg_stat_monitor compiled with CLANG

PG-159: Change the bucket start time scheme to align with the bucket time size

PG-293: Add the ability to control features added on top of pg_stat_monitor using GUC (Grand Unified Configuration) parameters

PG-300: Improve compatibility with PMM by making QueryIDs persistent for the same queries across different buckets and regardless of the node / client a query is executed on.

PG-362: Fix the pgsm_normalized_query default value to provide query examples in the pg_stat_monitor view by default.

PG-439: Remove warning of comparison of unsigned enum expression

Bugs Fixed

PG-221: Fixed the issue with pg_stat_monitor crashing when querying JSON with parallel workers enabled

PG-289: Fixed the issue with pg_stat_monitor failing to build on C11 compilers by removing ‘for’ loop initial declarations

PG-449: Fix comments visibility by correcting the behavior of the pgsm_extract_comments parameter

PG-453: Fixed query normalization for INSERT statements in PostgreSQL 13 and earlier versions

PG-455: Fixed the issue with data collection for any value specified for pgsm_bucket_time parameter within the min / max range

1.0.1

Bugs Fixed

PG-382: Histogram default settings changed to prevent the PostgreSQL server to crash

PG-417: Addressed security vulnerabilities to prevent an attacker from precreating functions

DISTPG-427: Fixed the issue with the extensions not working when pg_stat_monitor is enabled by replacing the return with goto exit for the pgsm_emit_log_hook function

1.0.0

Bump version from 1.0.0-rc.2 to 1.0.0.

1.0.0-rc.2

Improvements

PG-331: Changed the default value for the pg_stat_monitor.pgsm_query_max_len parameter from 1024 to 2048 for better data presentation in PMM

PG-355: Changed the collection of sys_time and user_time metrics so that they are now presented as an accumulative value

PG-286: Improved pg_stat_monitor performance by decreasing the overhead by more than 50%.

PG-267: Added test case to verify histogram feature

PG-359: Documentation: updated the pg_stat_monitor_settings view reference.

PG-344: Documentation: Updated the extensions order and behavior with data collection for PostgreSQL 14.

PG-358: Documentation: data display of ** blk ** and ** wal ** columns when both pg_stat_monitor and pg_stat_statements are loaded together.

Bugs Fixed

PG-350: Fixed bucket time overflow

PG-338: Fixed query calls count by setting the default value for pg_stat_monitor.pgsm_track to top.

PG-291: Fixed calls count.

PG-325: Fixed deadlock that occurred when the query length exceeded the pgsm_query_max_len value.

PG-326: Added validation for pgsm_histogram_min and pgsm_histogram_max ranges

PG-329: Fixed creation of pg_stat_monitor_errors view on SQL files.

PG-296: Fixed issue with the application name not displaying in the view when changed.

PG-290: Fixed issue with PostgreSQL crashing after enabling debug log level and when pg_stat_monitor is enabled.

PG-166: Fixed issue with displaying the actual system time values instead of NULL

PG-369: Fixed issue with incorrect wal_bytes values for PostgreSQL 11 and 12 that caused Query Analytics failure in PMM by ignoring the WalUsage variable value for these versions.

1.0.0-rc.1

Improvements

PG-165: Recycle expired buckets

PG-167: Make SQL error codes readable by updating their data types

PG-193: Create a comment based tags to identify different parameters

PG-199: Documentation: Add the integration with PMM section in User Guide

PG-210: Documentation: Update column names per POstgreSQL version to match the upstream ones

Bugs Fixed

PG-177: Fixed the error in histogram ranges

PG-214: Fixed the issue with the display of the error message as part of the query column in pg_stat_monitor view

PG-246: Fixed the issue with significant CPU and memory resource usage when pg_stat_monitor.pgsm_enable_query_plan parameter is enabled

PG-262: Fixed the way the comments are extracted in pg_stat_monitor view

PG-271: Fixed the issue with enabling the pg_stat_monitor.pgsm_overflow_target configuration parameter.

PG-272: Fixed the server crash when calling the pg_stat_monitor_reset() function by using the correct PGSM_MAX_BUCKETS GUC as the limit to the loop

REL0_9_0_STABLE

Improvements

PG-186: Add support to monitor query execution plan

PG-147: Store top query, instead of parent query.

PG-188: Added a new column to monitor the query state i.e PARSING/PLANNING/ACTIVE/FINISHED.

PG-180: Schema Qualified table/relations names.

Regression Test Suite.

Bugs Fixed

PG-189: Regression crash in case of PostgreSQL 11.

PG-187: Compilation Error for PostgreSQL 11 and PostgreSQL 12.

PG-186: Add support to monitor query execution plan.

PG-182: Added a new option for the query buffer overflow.

PG-181: Segmentation fault in case of track_utility is ON.

Some Code refactoring.

REL0_8_1

PG-147: Stored Procedure Support add parentid to track caller.

PG-177: Error in Histogram ranges.

REL0_8_0_STABLE

Improvements

Column userid (int64) was removed. Column dbid (int64) was removed.

Column user (string) was added (replacement for userid). Column datname (string) was added (replacement for dbid).

PG-176: Extract fully qualified relations name.

PG-175: Only Superuser / Privileged user can view IP address.

PG-174: Code cleanup.

PG-173: Added new WAL usage statistics.

PG-172: Exponential histogram for time buckets.

PG-164: Query timing will be four decimal places instead of two.

PG-167: SQLERRCODE must be in readable format.

Bugs Fixed

PG-169: Fixing message buffer overrun and incorrect index access to fix the server crash.

PG-168: “calls” and histogram parameter does not match.

PG-166: Display actual system time instead of null.

PG-165: Recycle expired buckets.

PG-150: Error while logging CMD Type like SELECT, UPDATE, INSERT, DELETE.

REL0_7_2

PG-165: Recycle expired buckets.

PG-164: Query timing will be four decimal places instead of two.

PG-161: Miscellaneous small issues.

REL0_7_1

PG-158: Segmentation fault while using pgbench with clients > 1.

PG-159: Bucket start time (bucket_start_time) should be aligned with bucket_time.

PG-160: Integration with PGXN.

REL0_7_0_STABLE

Improvements

PG-153: Capture and record the application_name executing the query.

PG-145: Add a new View/Query to show the actual Database name and Username.

PG-110; Aggregate the number of warnings.

PG-109: Log failed queries or queries with warning messages.

PG-150: Differentiate different types of queries such as SELECT, UPDATE, INSERT or DELETE.

Bugs Fixed

PG-111 Show information for incomplete buckets.

PG-148 Loss of query statistics/monitoring due to not enough “slots” available.

v0.6.0

Initial Release.

Master

Improvements

PG-156: Adding a placeholder replacement function for the prepared statement