Redshift Observatory

System Table Tracker

System view pg_catalog.stl_datashare_query_info version 1.0.59596 / 2023-11-12

schema	name	column	data type
pg_catalog	stl_datashare_query_info	changed_headers	int8
pg_catalog	stl_datashare_query_info	compute_node_end_time	timestamp
pg_catalog	stl_datashare_query_info	compute_node_start_time	timestamp
pg_catalog	stl_datashare_query_info	current_ddl_version	int8
pg_catalog	stl_datashare_query_info	current_dml_version	int8
pg_catalog	stl_datashare_query_info	current_sb_version	int8
pg_catalog	stl_datashare_query_info	current_sructure_version	int8
pg_catalog	stl_datashare_query_info	leader_node_end_time	timestamp
pg_catalog	stl_datashare_query_info	leader_node_start_time	timestamp
pg_catalog	stl_datashare_query_info	leaderpid	int4
pg_catalog	stl_datashare_query_info	node	int4
pg_catalog	stl_datashare_query_info	num_cols_grafted	int4
pg_catalog	stl_datashare_query_info	query	int4
pg_catalog	stl_datashare_query_info	refresh_queue_end_time	timestamp
pg_catalog	stl_datashare_query_info	refresh_queue_start_time	timestamp
pg_catalog	stl_datashare_query_info	sb_download_grafting_end_time	timestamp
pg_catalog	stl_datashare_query_info	sb_download_grafting_start_time	timestamp
pg_catalog	stl_datashare_query_info	sb_download_mode	char(16)
pg_catalog	stl_datashare_query_info	schema_name_table_name	char(256)
pg_catalog	stl_datashare_query_info	superblock_type	char(256)
pg_catalog	stl_datashare_query_info	table_grafting_mode	char(16)
pg_catalog	stl_datashare_query_info	table_id	int4
pg_catalog	stl_datashare_query_info	table_size	int8
pg_catalog	stl_datashare_query_info	target_ddl_version	int8
pg_catalog	stl_datashare_query_info	target_dml_version	int8
pg_catalog	stl_datashare_query_info	target_sb_version	int8
pg_catalog	stl_datashare_query_info	target_structure_version	int8
pg_catalog	stl_datashare_query_info	total_log_entries_changed	int8
pg_catalog	stl_datashare_query_info	total_num_cols	int4
pg_catalog	stl_datashare_query_info	total_sb_batches	int4
pg_catalog	stl_datashare_query_info	total_sb_download_seconds	float8
pg_catalog	stl_datashare_query_info	total_sb_size	int8
pg_catalog	stl_datashare_query_info	userid	int4
pg_catalog	stl_datashare_query_info	xid	int8

View Text

SELECT stll_datashare_query_info.userid,
       stll_datashare_query_info.leaderpid,
       stll_datashare_query_info.xid,
       stll_datashare_query_info.query,
       stll_datashare_query_info.table_id,
       stll_datashare_query_info.current_dml_version,
       stll_datashare_query_info.current_sructure_version,
       stll_datashare_query_info.current_sb_version,
       stll_datashare_query_info.current_ddl_version,
       stll_datashare_query_info.target_dml_version,
       stll_datashare_query_info.target_structure_version,
       stll_datashare_query_info.target_sb_version,
       stll_datashare_query_info.target_ddl_version,
       stll_datashare_query_info.leader_node_start_time,
       stll_datashare_query_info.leader_node_end_time,
       stll_datashare_query_info.node,
       stll_datashare_query_info.compute_node_start_time,
       stll_datashare_query_info.compute_node_end_time,
       stll_datashare_query_info.refresh_queue_start_time,
       stll_datashare_query_info.refresh_queue_end_time,
       stll_datashare_query_info.sb_download_grafting_start_time,
       stll_datashare_query_info.sb_download_grafting_end_time,
       stll_datashare_query_info.total_sb_download_seconds,
       stll_datashare_query_info.total_sb_batches,
       stll_datashare_query_info.changed_headers,
       stll_datashare_query_info.table_grafting_mode,
       stll_datashare_query_info.sb_download_mode,
       stll_datashare_query_info.superblock_type,
       stll_datashare_query_info.schema_name_table_name,
       stll_datashare_query_info.table_size,
       stll_datashare_query_info.total_log_entries_changed,
       stll_datashare_query_info.total_sb_size,
       stll_datashare_query_info.num_cols_grafted,
       stll_datashare_query_info.total_num_cols
FROM stll_datashare_query_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