What's Changed

• Bump codecov/codecov-action from 5.3.1 to 5.4.0 by @dependabot in #520
• Bump ossf/scorecard-action from 2.4.0 to 2.4.1 by @dependabot in #521
• Bump github/codeql-action from 3.28.9 to 3.28.10 by @dependabot in #522
• Bump actions/upload-artifact from 4.6.0 to 4.6.1 by @dependabot in #523
• Bump github/codeql-action from 3.28.10 to 3.28.11 by @dependabot in #524
• Adds date timestamp to keep packages in different directories. by @maqeel75 in #527
• Bump actions/upload-artifact from 4.6.1 to 4.6.2 by @dependabot in #526
• Bump github/codeql-action from 3.28.11 to 3.28.13 by @dependabot in #525
• Bump github/codeql-action from 3.28.13 to 3.28.14 by @dependabot in #528
• PG-1370 PGSM 2.1.1 release by @artemgavrilov in #514
• Update CODEOWNERS by @artemgavrilov in #529
• Bump codecov/codecov-action from 5.4.0 to 5.4.2 by @dependabot in #531
• Bump github/codeql-action from 3.28.14 to 3.28.16 by @dependabot in #532
• Bump github/codeql-action from 3.28.16 to 3.28.17 by @dependabot in #533
• Bump codecov/codecov-action from 5.4.2 to 5.4.3 by @dependabot in #535
• Bump github/codeql-action from 3.28.17 to 3.28.18 by @dependabot in #534
• Bump ossf/scorecard-action from 2.4.1 to 2.4.2 by @dependabot in #537
• Bump github/codeql-action from 3.28.18 to 3.28.19 by @dependabot in #540
• Bump github/codeql-action from 3.28.19 to 3.29.0 by @dependabot in #541
• PG-1621: fix cmd_type mostly showing 0 values by @dutow in #538
• PG-1313 Fix decode_error_level SQL function by @artemgavrilov in #539
• Add back case for zero cmd_type value in get_cmd_type function by @artemgavrilov in #543
• PG-1674: Fix comment parsing logic at two places by @dutow in #542
• Correctly get version from release branch by @EvgeniyPatlan in #546

Full Changelog: 2.1.1...2.2.0

What's Changed

• Replace REL_17_BETA2 with REL_17_STABLE in CI by @artemgavrilov in #483
• Add timeouts to CI jobs by @artemgavrilov in #484
• Add OSSF Scorecard by @artemgavrilov in #487
• [StepSecurity] ci: Harden GitHub Actions by @step-security-bot in #488
• Bump actions/checkout from 4.1.1 to 4.2.2 by @dependabot in #490
• Bump github/codeql-action from 3.27.3 to 3.27.4 by @dependabot in #493
• Bump ossf/scorecard-action from 2.3.1 to 2.4.0 by @dependabot in #492
• Bump codecov/codecov-action from 4.6.0 to 5.0.2 by @dependabot in #491
• Create pull_request_template.md by @artemgavrilov in #489
• Fixes llvm-devel package installation issue. by @maqeel75 in #494
• Bump github/codeql-action from 3.27.4 to 3.27.5 by @dependabot in #495
• Bump codecov/codecov-action from 5.0.2 to 5.0.7 by @dependabot in #496
• Bump codecov/codecov-action from 5.0.7 to 5.1.1 by @dependabot in #497
• Bump github/codeql-action from 3.27.5 to 3.27.6 by @dependabot in #498
• Bump github/codeql-action from 3.27.6 to 3.27.9 by @dependabot in #499
• Bump codecov/codecov-action from 5.1.1 to 5.1.2 by @dependabot in #501
• Bump actions/upload-artifact from 4.4.3 to 4.5.0 by @dependabot in #502
• Bump github/codeql-action from 3.27.9 to 3.28.0 by @dependabot in #503
• Bump actions/upload-artifact from 4.5.0 to 4.6.0 by @dependabot in #505
• Bump github/codeql-action from 3.28.0 to 3.28.1 by @dependabot in #504
• Add issue assingees by @artemgavrilov in #508
• Bump github/codeql-action from 3.28.1 to 3.28.5 by @dependabot in #510
• Bump codecov/codecov-action from 5.1.2 to 5.3.1 by @dependabot in #509
• Bump github/codeql-action from 3.28.5 to 3.28.8 by @dependabot in #511
• Bump github/codeql-action from 3.28.8 to 3.28.9 by @dependabot in #513
• Bump apache/skywalking-eyes from 0.6.0 to 0.7.0 by @dependabot in #512
• Add OSSF best practices badge by @artemgavrilov in #507
• PG-1349 Prevent LWLock deadlocks from happening by @jeltz in #518

New Contributors

• @step-security-bot made their first contribution in #488
• @jeltz made their first contribution in #518

Full Changelog: 2.1.0...2.1.1

What's Changed

• [DISTPG-724]: Updated version of pg_stat_monitor and fixed build scri… by @maqeel75 in #436
• Rename .ddeb extension to .deb by @maqeel75 in #437
• Fix integer overflow by @artemgavrilov in #435
• Fix IPC::Run perl module name in CI by @artemgavrilov in #438
• Fix cppcheck workflow by @artemgavrilov in #441
• Fix partition_prune testcase by @artemgavrilov in #440
• Fix workflows after CI image upgrade by @artemgavrilov in #445
• Add dependabot config by @artemgavrilov in #443
• Bump actions/checkout from 2 to 4 by @dependabot in #449
• Bump actions/upload-artifact from 2 to 4 by @dependabot in #450
• [Proposal] Add issue templates by @artemgavrilov in #446
• Add forum badge in readme by @artemgavrilov in #447
• Bump codecov/codecov-action from 2 to 4 by @dependabot in #451
• Update code-of-conduct.md by @artemgavrilov in #453
• Tune CI triggers by @artemgavrilov in #444
• Updated README to reflect badge for pg-16 and content on the landing page. by @Naeem-Akhter in #455
• Create SECURITY.md by @artemgavrilov in #452
• Added a tap test case to load multiple PPG extensions in the server before running a test load. by @Naeem-Akhter in #456
• [PKG-33]: Updates scripts to build pg_stat_monitor by @maqeel75 in #459
• [PKG-33]: Fixes PPG repo name issue from Jenkins. by @maqeel75 in #460
• [PKG-33]: Fixes PPG repo name issue for EL9. by @maqeel75 in #461
• Add license headers validation by @artemgavrilov in #458
• Remove redundant pgsm unistallation step from readme by @artemgavrilov in #462
• percona-release.sh is required from release-1.0-28 branch to setup AR… by @maqeel75 in #464
• Needs to install percona-release package to get GPG key. by @maqeel75 in #465
• Fixes clang version issue that conflicts with llvm version in percona… by @maqeel75 in #468
• PGXN integration by @artemgavrilov in #470
• PGXN integration complete by @artemgavrilov in #471
• Add CODEOWNERS file by @artemgavrilov in #472
• Add instructions for Trunk, add PGXN badge by @artemgavrilov in #473
• [PG-810] PG-17 Support by @artemgavrilov in #463
• [PKG-140]: Updates build scripts to build pg_stat_monitor with LLVM 1… by @maqeel75 in #476
• [PG-644] Add option to disable application name tracking by @artemgavrilov in #469
• [PKG-144]: Fixes issue in command to get clang version. by @maqeel75 in #478
• Drop CI workflows for PG11 by @artemgavrilov in #479
• Drop adopters list by @artemgavrilov in #480
• PG-592 Treat queries with different parent queries as separate entries by @dutow in #403
• Format sources by @artemgavrilov in #475
• Prepare release 2.1.0 by @artemgavrilov in #482

New Contributors

• @maqeel75 made their first contribution in #436
• @artemgavrilov made their first contribution in #435
• @dependabot made their first contribution in #449

Full Changelog: 2.0.4...2.1.0

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

Bugs Fixed
GH-425 - pg_stat_monitor crashes PostgreSQL if Citus library is loaded

Release highlights
This release adds support for PostgreSQL version 16 by resolving compilation and API change issues.

Release highlights
This release fixes the server crash when running pgsm_enable_query_plan is enabled, addresses the incorrect behaviour with the non-default number of buckets configured, and improves the memory context handling for pg_stat_monitor.

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

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

Bugs Fixed

PG-520: pg_stat_monitor does not work with PostgreSQL15

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