Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_burst_query_execution	action	char(20)
pg_catalog	stl_burst_query_execution	backup_id	char(30)
pg_catalog	stl_burst_query_execution	burst_cluster_id	char(38)
pg_catalog	stl_burst_query_execution	burst_query_id	int4
pg_catalog	stl_burst_query_execution	cluster_arn	char(128)
pg_catalog	stl_burst_query_execution	cluster_backup_version	int8
pg_catalog	stl_burst_query_execution	connection_guid	char(100)
pg_catalog	stl_burst_query_execution	endtime	timestamp
pg_catalog	stl_burst_query_execution	error	char(350)
pg_catalog	stl_burst_query_execution	exec_time_wo_compilation	int8
pg_catalog	stl_burst_query_execution	fetch_complete	int4
pg_catalog	stl_burst_query_execution	max_vis_xid	int8
pg_catalog	stl_burst_query_execution	num_pce_segs	int4
pg_catalog	stl_burst_query_execution	num_tuples	int4
pg_catalog	stl_burst_query_execution	pid	int8
pg_catalog	stl_burst_query_execution	query	int8
pg_catalog	stl_burst_query_execution	query_sb_version	int8
pg_catalog	stl_burst_query_execution	reported_peak_usage_bytes	int8
pg_catalog	stl_burst_query_execution	spectrum_file_count	int4
pg_catalog	stl_burst_query_execution	starttime	timestamp
pg_catalog	stl_burst_query_execution	userid	int4
pg_catalog	stl_burst_query_execution	xen_error_code	int4
pg_catalog	stl_burst_query_execution	xid	int8

View Text

SELECT stll_burst_query_execution.action,
       stll_burst_query_execution.userid,
       stll_burst_query_execution.pid,
       stll_burst_query_execution.xid,
       stll_burst_query_execution.query,
       stll_burst_query_execution.backup_id,
       stll_burst_query_execution.cluster_backup_version,
       stll_burst_query_execution.starttime,
       stll_burst_query_execution.endtime,
       stll_burst_query_execution.cluster_arn,
       stll_burst_query_execution.max_vis_xid,
       stll_burst_query_execution.query_sb_version,
       stll_burst_query_execution.num_tuples,
       stll_burst_query_execution.fetch_complete,
       stll_burst_query_execution.error,
       stll_burst_query_execution.connection_guid,
       stll_burst_query_execution.xen_error_code,
       stll_burst_query_execution.burst_cluster_id,
       stll_burst_query_execution.burst_query_id,
       stll_burst_query_execution.reported_peak_usage_bytes,
       stll_burst_query_execution.exec_time_wo_compilation,
       stll_burst_query_execution.spectrum_file_count,
       stll_burst_query_execution.num_pce_segs
FROM stll_burst_query_execution

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