pg_table_def
, stl_query
, stl_querytext
, stl_tr_conflict
, stl_explain
, stl_alert_event_log
, stl_ddltext
, stl_scan
, stl_save
, stl_hashjoin
, stl_hash
, stl_plan_info
, stl_return
, and information_schema.table_constraints
.
- execution time
select (endtime - starttime) as execution_time_in_ms
from stl_query
where query = QUERY_ID;