Redshift Observatory

System Table Tracker

System view pg_catalog.stl_pg_query_execution_info version 1.0.71912 / 2024-08-02

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