20956867976
75%

Ran 13 Jan 2026 12:37PM UTC

Jobs 1

Files 46

Run time 1min

Badge

Embed ▾

Committed 13 Jan 2026 12:33PM UTC coverage: 75.296%. Remained the same

Build # 20956867976

Build Type

push

github

Committed by

web-flow

Commit Message

[*] refactor `reco_add_index` metric (#1117)

* Refactor `reco_add_index` metric

split the result into separate rows in the
form `query_id | recommended_index_ddl ...`.

order queries by total_exec_time from
pg_stat_statements.

* Add new `Missing Indexes` panel to `Index overview` dashboard

* Return only 1 row per distinct recommendation in `reco_add_index`

* Align column names and sizes in `Invalid indexes` panel with the rest.

* Increase `min_selectivity` for index advisor

* Update `Missing Indexes` panel description

* Use `min_selectivty => 90` in `reco_add_index`

* Improve `Missing Indexes` panel query.

Its enough to rely on `max(time)` to get the latest
fetch results.

* Improve 'Missing Indexes' panel description

Run Details

4011 of 5327 relevant lines covered (75.3%)

0.86 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	20956867976.1	13 Jan 2026 12:37PM UTC	46	75.3	GitHub Action Run

cybertec-postgresql / pgwatch / 20956867976
75%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20956867976

cybertec-postgresql / pgwatch / 20956867976 75%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20956867976

cybertec-postgresql / pgwatch / 20956867976
75%

README BADGES
x