pg_stat_monitor icon indicating copy to clipboard operation
pg_stat_monitor copied to clipboard

PG-17 Support

Open artemgavrilov opened this issue 9 months ago • 2 comments

Resolves https://github.com/percona/pg_stat_monitor/issues/454

Full PG17 diff: https://github.com/postgres/postgres/compare/REL_16_STABLE...REL_17_BETA2 Docs about pg_stat_statements fields: https://www.postgresql.org/docs/17/pgstatstatements.html

Addressed changes:

  1. Rename of blk_read_time and blk_write_time to shared_blk_read_time and shared_blk_write_time https://github.com/postgres/postgres/commit/13d00729d422c84b1764c24251abcc785ea4adb1
  2. Add local_blk_read_time and local_blk_write_time https://github.com/postgres/postgres/commit/5147ab1dd34ad81c169c85fa3c7d11a782a1555b
  3. Remove "deadcode" macros https://github.com/postgres/postgres/commit/75680c3d805e2323cd437ac567f0677fdfc7b680
  4. Add jit_deform_time and jit_deform_count https://github.com/postgres/postgres/commit/5a3423ad8ee171fbf08317917981effe47d211eb
  5. Add statement entry timestamps stats_since and minmax_stats_since https://github.com/postgres/postgres/commit/dc9f8a798307244d791b71f666f50de319799e7c https://www.postgresql.org/message-id/flat/72e80e7b160a6eb189df9ef6f068cce3765d37f8.camel%40moonset.ru
  6. Fix nesting level tracking issues (not back-ported because changes behavior) https://github.com/postgres/postgres/commit/76db9cb6368eb553ec334fe05e1258f2439bf07f

Added code was formatted with pgindent

artemgavrilov avatar May 07 '24 14:05 artemgavrilov

Codecov Report

Attention: Patch coverage is 81.01266% with 15 lines in your changes missing coverage. Please review.

Project coverage is 84.82%. Comparing base (c796995) to head (bc90dca).

Files Patch % Lines
pg_stat_monitor.c 80.51% 3 Missing and 12 partials :warning:
Additional details and impacted files
@@            Coverage Diff             @@
##             main     #463      +/-   ##
==========================================
+ Coverage   84.56%   84.82%   +0.26%     
==========================================
  Files           3        3              
  Lines        1270     1292      +22     
  Branches      196      196              
==========================================
+ Hits         1074     1096      +22     
- Misses         98       99       +1     
+ Partials       98       97       -1     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

codecov[bot] avatar Jun 05 '24 22:06 codecov[bot]

@codeforall Please check last commit. It restores/fixed previous behavior for PG less than 17 because nesting level fix should not be back-ported (similar to pg_stat_statements). level_tracking_1.out result matches to level_tracking test output on main branch.

artemgavrilov avatar Jun 13 '24 12:06 artemgavrilov