Details
Description
STR:
- Install PMM 2.28.0
- Add PDPGSQL to monitoring
- Run sysbench read-only script, for example:
/usr/share/sysbench/oltp_point_select.lua --rate=0 --db-driver=pgsql --pgsql-user=postgres --pgsql-db=sbtest --percentile=99 --time=1000 --threads=1 --report-interval=10 --tables=1 --table_size=1000000 --rand-type=uniform run
- Open QAN page in a few minutes and select last 30 min period
- Click on Total
- Compare QPS values
Actual result:
See QPS, Sum and and Query time:
Expected result: Values should match.
I checked the same for not so intensive load and in this case the values were the same.
See:
Additional information: With pg_statements everything looks ok
I checked the same scenario for MySQL and found that we have the same problem
And the same problem exists for Mongo. I think all DB are affected in case of time range like from 2022-06-10 06:20:00 to 2022-06-10 06:20:00
Attachments
Issue Links
- mentioned in
-
Page Loading...
1.
|
[RN] QPS/Sum values don't match with QPS/Sum on Query details |
![]() |
Open | Unassigned |