Answer by Peter K. ·
you could try
select sp.name as "System profile name", count(*) "Nr of high res measurements" from measurement_high as mh, dynamic_measure as dm, systemprofile as sp where mh.measure_id = dm.id and sp.id = dm.system_id group by sp.name
(tested on postgres)
which would give you the amount of measurements for the "high" resolution (i.e. 1 aggregated value per minute) and repeat the statement slightly modified for measurement_mid (1 value per hour) and measurment_low (1 value per day).
No guarantees that our data structures are optimized for this, though, so if you want to execute this regularly on a larger system I don't know how it'll perform. Best regards,
Slow PWH Query 1 Answer
Performance Warehouse messages 1 Answer