[QAN] Add jit_* metrics from PGSM to PMM

Description

Actual result: PMM supports PGSM as query source, but it doesn't using any of jit_* metrics. 

Expected result: PMM consumer also jit_* metrics in case of PG 15 and higher.

Description: Those metrics are included in PGSM 2.0 with PG 15 and higher. Jit metrics are time, count and sum type. Such types are already implemented in PMM and calculation should be same. 

Suggested implementation
1. Change model in pmm-agent to also scrape jit metrics.
2. Send such metrics to pmm-server
3. Add those fields into clickhouse
4. Expose those fields on FE

How to test

None

How to document

None

Activity

Show:

Jiří Čtvrtka September 21, 2023 at 8:32 AM

More info after discussion with PG team:
1. jit_* metrics are disabled by default
2. Its included in PGSM and PGSS too
3. PG team will figure out if its included in total time metrics etc.
4. In around 70% it would not be much helpful for DBAs
5. Could cause bigger load on CPU/RAM

Details

Assignee

Reporter

Priority

Needs QA

Yes

Needs Doc

Yes

Smart Checklist

Created September 19, 2023 at 11:54 AM
Updated November 13, 2024 at 8:32 AM