amazon-aurora / babelfish_extensions / 24425394748

78%

main: 77%

Build Type

push

github

Committed by manisha-deshpande

Commit Message

Add session-level diagnostic function sys.routine_parse_cache_stats

Changes:
- Add sys.routine_parse_cache_stats() returning cache_hits, cache_misses,
  cache_writes, cache_evictions, cache_errors per backend session
- Hits: counted on confirmed cache reuse in pltsql_compile (from_cache
  valid or bbf_ext_xmin valid) and do_compile cache restore
- Misses: counted only when caching was enabled but cache was empty/stale
- Writes: counted in pltsql_fill_cache_columns on successful serialization
- Evictions: counted at invalidate_function for from_cache entries, GUC-off
  hash table eviction, and explicit kill switch (cache columns NULLed)
- Errors: counted in PG_CATCH blocks before PG_RE_THROW
- Tests: stats calls throughout verify file to track counter progression

Task: BABEL-6037
Signed-off-by: Manisha Deshpande <mmdeshp@amazon.com>

Coverage Stats

29 of 33 new or added lines in 3 files covered. (87.88%)

212 existing lines in 6 files now uncovered.

53822 of 69850 relevant lines covered (77.05%)

400961.28 hits per line