get some poorly performing queries & their query plans

get_query_plans.sql

-- Thanks to: https://blobeater.blog/2019/11/20/execution-plans-in-azure-sql-database/
SELECT top 10 (total_logical_reads/execution_count) as ReadsPerExec,
  (total_logical_writes/execution_count) as WritesPerExec,
  (total_physical_reads/execution_count) PhyReadsPerExec,
  Execution_count, sql_handle, plan_handle, total_worker_time
FROM sys.dm_exec_query_stats
ORDER BY (total_logical_reads + total_logical_writes) Desc

SELECT * FROM sys.dm_exec_query_plan (0x060028007491E823E0C7342EC101000001000000000000000000000000000000000000000000000000000000)

/*
select top 1 * FROM sys.dm_exec_query_stats
*/