Redshift Observatory

System Table Tracker

System view pg_catalog.stl_query_step_times version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_query_step_times	duration	int8
pg_catalog	stl_query_step_times	off_cpu	int8
pg_catalog	stl_query_step_times	on_cpu	int8
pg_catalog	stl_query_step_times	query	int4
pg_catalog	stl_query_step_times	segment	int4
pg_catalog	stl_query_step_times	slice	int4
pg_catalog	stl_query_step_times	step	int4
pg_catalog	stl_query_step_times	step_common	char(32)
pg_catalog	stl_query_step_times	step_name	char(32)
pg_catalog	stl_query_step_times	step_shared	char(32)
pg_catalog	stl_query_step_times	step_specific	char(32)
pg_catalog	stl_query_step_times	step_type	char(32)
pg_catalog	stl_query_step_times	xid	int8

View Text

SELECT stll_query_step_times.xid,
       stll_query_step_times.query,
       stll_query_step_times.segment,
       stll_query_step_times.step,
       stll_query_step_times.slice,
       stll_query_step_times.step_name,
       stll_query_step_times.step_type,
       stll_query_step_times.step_specific,
       stll_query_step_times.step_shared,
       stll_query_step_times.step_common,
       stll_query_step_times.duration,
       stll_query_step_times.on_cpu,
       stll_query_step_times.off_cpu
FROM stll_query_step_times

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