-
Type: Improvement
-
Status: Resolved
-
Priority: Critical
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 2.12
-
Component/s: None
The hourly statistic is run using
select nx_update_studio_stats()
It takes 72s to execute and it generates important io activity.
It also load a big portion of the nxp_logs into the shared buffers (25%) which interfere with other db actions.
This needs to be improved.