Releases: percona/pg_stat_monitor
Releases · percona/pg_stat_monitor
2.3.1
What's Changed
- Bump github/codeql-action from 3.29.0 to 3.29.2 by @dependabot[bot] in #547
- PGSM 2.2.0 release by @artemgavrilov in #545
- PKG-922 fix rhel10 build by @EvgeniyPatlan in #548
- Bump github/codeql-action from 3.29.2 to 3.29.3 by @dependabot[bot] in #549
- Bump github/codeql-action from 3.29.3 to 3.29.4 by @dependabot[bot] in #550
- Bump github/codeql-action from 3.29.4 to 3.29.5 by @dependabot[bot] in #552
- Bump actions/checkout from 4.2.2 to 5.0.0 by @dependabot[bot] in #554
- Bump github/codeql-action from 3.29.7 to 3.29.9 by @dependabot[bot] in #553
- Bump github/codeql-action from 3.29.9 to 3.29.10 by @dependabot[bot] in #555
- Bump github/codeql-action from 3.29.10 to 3.29.11 by @dependabot[bot] in #557
- Bump codecov/codecov-action from 5.4.3 to 5.5.0 by @dependabot[bot] in #556
- Bump github/codeql-action from 3.29.11 to 3.30.0 by @dependabot[bot] in #559
- PG-1900 Remove compatibility with PG-12 by @artemgavrilov in #558
- Bump github/codeql-action from 3.30.0 to 3.30.1 by @dependabot[bot] in #561
- Bump codecov/codecov-action from 5.5.0 to 5.5.1 by @dependabot[bot] in #562
- Bump github/codeql-action from 3.30.1 to 3.30.3 by @dependabot[bot] in #563
- PG-1931 Fix API compatibility by @artemgavrilov in #564
- PG-1907 PG-18 Support by @artemgavrilov in #560
- Bump github/codeql-action from 3.30.3 to 3.30.5 by @dependabot[bot] in #569
- Bump github/codeql-action from 3.30.5 to 3.30.6 by @dependabot[bot] in #572
- Bump ossf/scorecard-action from 2.4.2 to 2.4.3 by @dependabot[bot] in #571
- Bump github/codeql-action from 3.30.6 to 4.30.8 by @dependabot[bot] in #573
- Update readme by @artemgavrilov in #570
- Bump apache/skywalking-eyes from 0.7.0 to 0.8.0 by @dependabot[bot] in #575
- Bump github/codeql-action from 4.30.8 to 4.30.9 by @dependabot[bot] in #574
- Bump github/codeql-action from 4.30.9 to 4.31.0 by @dependabot[bot] in #577
- Bump actions/upload-artifact from 4.6.2 to 5.0.0 by @dependabot[bot] in #576
- Bump github/codeql-action from 4.31.0 to 4.31.2 by @dependabot[bot] in #578
- PG-2005: Do not keep unnecessary entries in the query stack by @dutow in #579
- Backport buils scripts fixes from 2.2.0 release branch by @artemgavrilov in #580
- fix llvm dependency for bullseye by @Manika-Percona in #581
- fix llvm for ol8 by @Manika-Percona in #585
- PG-2014 Initalize nested query stack to fix crash on DDL by @jeltz in #584
Full Changelog: 2.2.0...2.3.1
Contributors
jeltz, dutow, and 4 other contributors
Assets 2
2.2.0
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
Contributors
dutow, EvgeniyPatlan, and 3 other contributors
Assets 2
2.1.1
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
Contributors
jeltz, artemgavrilov, and 3 other contributors
Assets 2
2.1.0
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
Contributors
dutow, artemgavrilov, and 3 other contributors
Assets 2
2.0.4
2.0.3
2.0.2
2.0.1
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.
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