プランID

• MySQL

(5.6)
ない模様

• Oracle

(12cR1)

select /* TEST */ * from tab1;

select sql_id,sql_text,child_number,plan_hash_value
from v$sql
where sql_text like '%TEST%'
;

• PostgreSQL

(9.4)
ない模様

• SQL Server

(2014)

select /* TEST */ * from tab1;

select t1.sql_handle,t2.text,t1.plan_handle,t3.query_plan
from sys.dm_exec_query_stats t1
cross apply sys.dm_exec_sql_text(t1.sql_handle) t2
cross apply sys.dm_exec_query_plan(t1.plan_handle) t3
where t2.text like '%TEST%'
;