Accurate statistics collection within an hour with 10-minute snapshots

[Sshumeev]

Good day!
There are such

Sample_id Sample_time
16158 "2026-02-10 11:00:00+00"
16157 "2026-02-10 10:50:00+00"
16156 "2026-02-10 10:40:00+00"
16155 "2026-02-10 10:30:00+00"
16154 "2026-02-10 10:20:00+00"
16153 "2026-02-10 10:10:00+00"
16152 "2026-02-10 10:00:00+00"

To collect statistics for an hour(10:00:00+00-11:00:00+00) , need to perform

SELECT profile.get_report(2,16153,16158);

i.e. start with Sample_id = 16153 ?

The documentation states:
"Every sample contains statistic information about database workload since previous sample"

[zubkov-andrei]

Hi! No, you should call get_report(2,16152,16158). You should specify exact report boundaries in sample terms. In such call the first sample data, collected since sample 16151 wont'be included in the report.