17376383442
74%

Ran 01 Sep 2025 11:36AM UTC

Jobs 1

Files 43

Run time 1min

Badge

Embed ▾

Committed 01 Sep 2025 11:33AM UTC coverage: 64.095%. Remained the same

Build # 17376383442

Build Type

push

github

Committed by

pashagolub

Commit Message

[+] improve recommendation metrics, closes #764 (#921)

* [+] improve recommendation metrics, closes #764

Refactor PostgreSQL recommendation metrics to consolidate multiple
findings per metric type.

The changes consolidate all 8 recommendation metrics to use
an aggregation pattern that combines multiple database objects into
comma-separated strings instead of separate rows, limiting results to
50 items with overflow indicators, and actionable guidance templates
were added to extra_info fields.

* [-] fix `metric_storage_name` properties in YAML, fixes #920

* [+] improve "Recommendations" dashboard

* [-] fix object name aggregation by @0xgouda

* [-] tweak recommendations for `reco_add_index` metric

Latest versions of pg_qualstats return not only CREATE INDEX but
affected queries array. So use CREATE INDEX as is in recommendations,
and output `queryids` if available in `extra_info`.

Due to long recommendation text limit concatenated output to 10 items.
Reported by @0xgouda.

------

Co-authored-by: Ahmed Gouda <gouda0x@gmail.com>

Run Details

3215 of 5016 relevant lines covered (64.09%)

0.73 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	17376383442.1	01 Sep 2025 11:36AM UTC	43	64.09	GitHub Action Run

cybertec-postgresql / pgwatch / 17376383442
74%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 17376383442

cybertec-postgresql / pgwatch / 17376383442 74%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 17376383442

cybertec-postgresql / pgwatch / 17376383442
74%

README BADGES
x