search

catalyst / moodle-tool_lockstats

Moodle cron / task API lock statistics admin tool
https://moodle.org/plugins/tool_lockstats
6 stars 13 forks source link

New report on the heaviest tasks in cumulative seconds #101

Open brendanheywood opened 4 years ago

brendanheywood commented 4 years ago

More or less this wrapped in table lib + all the row helpers for the adhoc / cron tasks / lock links

        classname,
        sum(duration) dur,
    sum(lockcount) cnt
FROM {tool_lockstats_history}

GROUP BY component, classname
ORDER BY sum(duration) DESC