1.1.1

Bugs Fixed

PG-520: pg_stat_monitor does not work with PostgreSQL15

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

Changed

• PG-380: Bump version from 1.0.0-rc.2 to 1.0.0.

1.0.0-rc.2

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

PG-284: Bump version to 1.0.0-rc.1.

1.0.0-Beta-2

1.0.0-Beta-2

0.9.2-BETA1

Bug

• [PG-169] - PostgreSQL - 12 Regression test suite was crashing.
• [PG-185] - Relations column in pg_stat_monitor has incorrect values
• [PG-196] - Process new dimensions/primary keys properly in pg_stat_monitor
• [PG-197] - pg_stat_monitor: ERROR: unrecognized node type: 226
• [PG-203] - pg_stat_monitor: Possible Memory Leak
• [PG-225] - pg_stat_monitor: Testcase 'predicate-gin' deadlock.

Improvement

• [PG-173] - pg_stat_monitor: WAL usage statistics
• [PG-195] - Align defaults for time interval with PMM
• [PG-200] - pg_stat_monitor: Add application name to the bucket ID

REL0_9_1

PG-190: Missing query, if query elapsed time is greater than bucket time.

REL0_9_0_STABLE

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.