Redshift Observatory

System Table Tracker

System view pg_catalog.stl_sage_mode_simulation_summary version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_sage_mode_simulation_summary	avg_runtime_ms	float8
pg_catalog	stl_sage_mode_simulation_summary	cost_rpu_ms	float8
pg_catalog	stl_sage_mode_simulation_summary	num_queries	int8
pg_catalog	stl_sage_mode_simulation_summary	num_skipped_queries	int8
pg_catalog	stl_sage_mode_simulation_summary	num_transitions	int8
pg_catalog	stl_sage_mode_simulation_summary	params	char(400)
pg_catalog	stl_sage_mode_simulation_summary	simulation_id	char(36)
pg_catalog	stl_sage_mode_simulation_summary	total_queries	int8
pg_catalog	stl_sage_mode_simulation_summary	trace_chunk_end_time	timestamp
pg_catalog	stl_sage_mode_simulation_summary	trace_chunk_start_time	timestamp
pg_catalog	stl_sage_mode_simulation_summary	trace_id	int4
pg_catalog	stl_sage_mode_simulation_summary	update_elapsed_ms	float8
pg_catalog	stl_sage_mode_simulation_summary	update_time	timestamp

View Text

SELECT stll_sage_mode_simulation_summary.simulation_id,
       stll_sage_mode_simulation_summary.update_time,
       stll_sage_mode_simulation_summary.update_elapsed_ms,
       stll_sage_mode_simulation_summary.params,
       stll_sage_mode_simulation_summary.trace_id,
       stll_sage_mode_simulation_summary.trace_chunk_start_time,
       stll_sage_mode_simulation_summary.trace_chunk_end_time,
       stll_sage_mode_simulation_summary.cost_rpu_ms,
       stll_sage_mode_simulation_summary.avg_runtime_ms,
       stll_sage_mode_simulation_summary.num_queries,
       stll_sage_mode_simulation_summary.total_queries,
       stll_sage_mode_simulation_summary.num_transitions,
       stll_sage_mode_simulation_summary.num_skipped_queries
FROM stll_sage_mode_simulation_summary

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