select
 ps.plan_handle,
 t.statement_text, cast(qp.query_plan as xml) as query_plan,
 qs.execution_count, qs.min_elapsed_time, qs.max_elapsed_time
from
 sys.dm_exec_procedure_stats ps join
 sys.dm_exec_query_stats qs on qs.plan_handle = ps.plan_handle cross apply
 sys.dm_exec_sql_text(qs.plan_handle) st cross apply
 (select case qs.statement_end_offset when -1 then datalength(st.text) else qs.statement_end_offset end) a(statement_end_offset) cross apply
 (select substring(st.text, qs.statement_start_offset / 2 + 1, (a.statement_end_offset - qs.statement_start_offset) / 2 + 1)) t(statement_text)	cross apply
 sys.dm_exec_text_query_plan(ps.plan_handle, qs.statement_start_offset, qs.statement_end_offset) qp
where
 ps.database_id = db_id('ИмяБазы') and ps.object_id = object_id('ИмяХП')
order by
 ps.plan_handle;