declare @ignore_last_executions_before datetime = dateadd(day, -10, getdate());

select top (30)
 object_schema_name(a.object_id, b.database_id),
 object_name(a.object_id, b.database_id),
 substring(t.text, d.s, d.l), c.query_plan,
 e.avg_worker_time, qs.execution_count, qs.total_worker_time, qs.last_worker_time--, qs.*
from
 sys.dm_exec_query_stats qs outer apply
 (select cast(value as int) from sys.dm_exec_plan_attributes(qs.plan_handle) where attribute = N'objectid') a(object_id) outer apply
 (select cast(value as int) from sys.dm_exec_plan_attributes(qs.plan_handle) where attribute = N'dbid') b(database_id) outer apply
 (select try_cast(query_plan as xml) from sys.dm_exec_text_query_plan(qs.plan_handle, qs.statement_start_offset, qs.statement_end_offset)) c(query_plan) cross apply
 sys.dm_exec_sql_text(qs.sql_handle) t outer apply
 (select (qs.statement_start_offset / 2) + 1, (isnull(nullif(qs.statement_end_offset, -1), datalength(t.text)) - qs.statement_start_offset) / 2 + 1) d(s, l) cross apply
 (select qs.total_worker_time / qs.execution_count) e(avg_worker_time)
where
 qs.last_execution_time > @ignore_last_executions_before
order by
 e.avg_worker_time desc
option
 (recompile);