Finding the longest running cron jobs in Magento using MySQL:

SELECT job_code,scheduled_at,executed_at,finished_at,TIMEDIFF(finished_at,executed_at) AS timediff FROM cron_schedule ORDER BY timediff DESC LIMIT 20;