Redshift Observatory

System Table Tracker

System view pg_catalog.stl_burst_user_temp_table_stats version 1.0.70890 / 2024-07-14

schema	name	column	data type
pg_catalog	stl_burst_user_temp_table_stats	block_replication_end_time	timestamp
pg_catalog	stl_burst_user_temp_table_stats	block_replication_start_time	timestamp
pg_catalog	stl_burst_user_temp_table_stats	blocks_not_in_s3	int8
pg_catalog	stl_burst_user_temp_table_stats	metadata_deserialize_duration_burst_ms	float8
pg_catalog	stl_burst_user_temp_table_stats	metadata_serialize_duration_main_ms	float8
pg_catalog	stl_burst_user_temp_table_stats	num_temp_tables	int4
pg_catalog	stl_burst_user_temp_table_stats	query	int8
pg_catalog	stl_burst_user_temp_table_stats	query_exec_state	char(30)
pg_catalog	stl_burst_user_temp_table_stats	query_priority	int4
pg_catalog	stl_burst_user_temp_table_stats	recordtime	timestamp
pg_catalog	stl_burst_user_temp_table_stats	total_blocks	int8
pg_catalog	stl_burst_user_temp_table_stats	xid	int8

View Text

SELECT stll_burst_user_temp_table_stats.recordtime,
       stll_burst_user_temp_table_stats.xid,
       stll_burst_user_temp_table_stats.query,
       stll_burst_user_temp_table_stats.query_priority,
       stll_burst_user_temp_table_stats.total_blocks,
       stll_burst_user_temp_table_stats.blocks_not_in_s3,
       stll_burst_user_temp_table_stats.num_temp_tables,
       stll_burst_user_temp_table_stats.block_replication_start_time,
       stll_burst_user_temp_table_stats.block_replication_end_time,
       stll_burst_user_temp_table_stats.metadata_serialize_duration_main_ms,
       stll_burst_user_temp_table_stats.metadata_deserialize_duration_burst_ms,
       stll_burst_user_temp_table_stats.query_exec_state
FROM stll_burst_user_temp_table_stats

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