Redshift Observatory

System Table Tracker

System view pg_catalog.stl_burst_manager_personalization version 1.0.71629 / 2024-07-27

schema	name	column	data type
pg_catalog	stl_burst_manager_personalization	account_id	char(38)
pg_catalog	stl_burst_manager_personalization	auto_wlm_per_query_max_memory_mb	int4
pg_catalog	stl_burst_manager_personalization	auto_wlm_total_memory_mb	int4
pg_catalog	stl_burst_manager_personalization	backup_id	char(100)
pg_catalog	stl_burst_manager_personalization	backup_midfix	char(100)
pg_catalog	stl_burst_manager_personalization	backup_prefix	char(100)
pg_catalog	stl_burst_manager_personalization	burst_account_id	char(38)
pg_catalog	stl_burst_manager_personalization	burst_cluster_id	char(38)
pg_catalog	stl_burst_manager_personalization	burst_cluster_version	char(50)
pg_catalog	stl_burst_manager_personalization	burst_requested_nodes	int4
pg_catalog	stl_burst_manager_personalization	cluster_arn	char(128)
pg_catalog	stl_burst_manager_personalization	cluster_id	char(38)
pg_catalog	stl_burst_manager_personalization	cluster_name	char(70)
pg_catalog	stl_burst_manager_personalization	creds_access_key	char(100)
pg_catalog	stl_burst_manager_personalization	creds_expiration	timestamp
pg_catalog	stl_burst_manager_personalization	creds_secret_key	char(100)
pg_catalog	stl_burst_manager_personalization	creds_session_token	char(100)
pg_catalog	stl_burst_manager_personalization	endtime	timestamp
pg_catalog	stl_burst_manager_personalization	error	char(250)
pg_catalog	stl_burst_manager_personalization	instance_type	char(100)
pg_catalog	stl_burst_manager_personalization	is_commit_based_cold_start	int4
pg_catalog	stl_burst_manager_personalization	main_instance_type	char(100)
pg_catalog	stl_burst_manager_personalization	main_num_nodes	int4
pg_catalog	stl_burst_manager_personalization	main_num_slices	int4
pg_catalog	stl_burst_manager_personalization	num_nodes	int4
pg_catalog	stl_burst_manager_personalization	pid	int8
pg_catalog	stl_burst_manager_personalization	query	int4
pg_catalog	stl_burst_manager_personalization	refreshed_backup_id	char(100)
pg_catalog	stl_burst_manager_personalization	refreshed_version	int4
pg_catalog	stl_burst_manager_personalization	refreshing_backup_id	char(100)
pg_catalog	stl_burst_manager_personalization	refreshing_version	int4
pg_catalog	stl_burst_manager_personalization	starttime	timestamp
pg_catalog	stl_burst_manager_personalization	userid	int4
pg_catalog	stl_burst_manager_personalization	xid	int8

View Text

SELECT stll_burst_manager_personalization.userid,
       stll_burst_manager_personalization.pid,
       stll_burst_manager_personalization.xid,
       stll_burst_manager_personalization.starttime,
       stll_burst_manager_personalization.endtime,
       stll_burst_manager_personalization.cluster_arn,
       stll_burst_manager_personalization.backup_id,
       stll_burst_manager_personalization.backup_prefix,
       stll_burst_manager_personalization.backup_midfix,
       stll_burst_manager_personalization.creds_access_key,
       stll_burst_manager_personalization.creds_secret_key,
       stll_burst_manager_personalization.creds_session_token,
       stll_burst_manager_personalization.creds_expiration,
       stll_burst_manager_personalization.cluster_id,
       stll_burst_manager_personalization.cluster_name,
       stll_burst_manager_personalization.error,
       stll_burst_manager_personalization.account_id,
       stll_burst_manager_personalization.query,
       stll_burst_manager_personalization.auto_wlm_total_memory_mb,
       stll_burst_manager_personalization.auto_wlm_per_query_max_memory_mb,
       stll_burst_manager_personalization.instance_type,
       stll_burst_manager_personalization.num_nodes,
       stll_burst_manager_personalization.burst_cluster_id,
       stll_burst_manager_personalization.burst_account_id,
       stll_burst_manager_personalization.burst_cluster_version,
       stll_burst_manager_personalization.main_instance_type,
       stll_burst_manager_personalization.main_num_nodes,
       stll_burst_manager_personalization.main_num_slices,
       stll_burst_manager_personalization.refreshed_backup_id,
       stll_burst_manager_personalization.refreshed_version,
       stll_burst_manager_personalization.refreshing_backup_id,
       stll_burst_manager_personalization.refreshing_version,
       stll_burst_manager_personalization.burst_requested_nodes,
       stll_burst_manager_personalization.is_commit_based_cold_start
FROM stll_burst_manager_personalization

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