cybertec-postgresql / pgwatch / 20057129747
75%

DEFAULT BRANCH: master
Ran
Jobs 1
Files 44
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 73.988%. Remained the same
20057129747

push

github

web-flow 
[+] add `stat_statements_jit` metric (#1054)

* Add `stat_statements_jit` metric.

It queries `pg_stat_statements` to identify queries
with high percent of execution time spent in JIT.

* Add `JIT %` panel to `Health Check` dashboard.

It queries the `stat_statements_jit` metric table to
identify the percentage of jit in the current total
query execution time within the specified grafana
time window.

* Add `Top n by JIT %` panel to `Global Health` dashboard.

It queries the `stat_statements_jit` metric table to
identify the percentage of jit in the current total
query execution time for each dbname
within the specified grafana time window.

* Add `Auto` option to `$online_interval` variable.

The `Auto` option will contain a value identical to the current
time range, so we can partially avoid the imprecision of `$__timeGroup()`

* Revert removing the label of `$online_interval`

* Update JIT Panel to order by biggest value.

* require pg 15 at least for `stat_statements_jit` metric.

the minimum version where `jit_generation_time` field
is available in `pg_stat_statements`.

* Adjust num of decimals and threshold in JIT panel.

* Use table view instead of time series for JIT panel in `0-health-check`.

* Remove `stat_statements_jit` metric.

- `jit_generation_time` is now queried directly in `stat_statements` metric.

* Update `JIT %` panels in health dashboards to query `stat_statements` metric.

`stat_statements_jit` metric has been removed and jit is now queried directly
via `stat_statements`

* Add `JIT %` column to `Enhanced Query Performance Analysis Table` panel.

* Remove `stat_statements_jit` from panel description.

* Remove `jit_generation_time` field from `stat_statements_no_query_text` metric.

3766 of 5090 relevant lines covered (73.99%)

0.84 hits per line

Jobs
ID Job ID Ran Files Coverage
1 20057129747.1 44
73.99
 GitHub Action Run
Source Files on build 20057129747