Redshift Observatory

System Table Tracker

System view pg_catalog.stl_pg_query_execution_info version 1.0.75672 / 2024-09-28

schema name column data type
pg_catalog stl_pg_query_execution_info checkpoint int4
pg_catalog stl_pg_query_execution_info pid int4
pg_catalog stl_pg_query_execution_info query_id int8
pg_catalog stl_pg_query_execution_info recordtime timestamp
pg_catalog stl_pg_query_execution_info time_consumption_us int8
pg_catalog stl_pg_query_execution_info user_id int4
pg_catalog stl_pg_query_execution_info xid int8

View Text

SELECT stll_pg_query_execution_info.recordtime,
       stll_pg_query_execution_info.query_id,
       stll_pg_query_execution_info.pid,
       stll_pg_query_execution_info.xid,
       stll_pg_query_execution_info.user_id,
       stll_pg_query_execution_info.checkpoint,
       stll_pg_query_execution_info.time_consumption_us
FROM stll_pg_query_execution_info


Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers