Redshift Observatory

System Table Tracker

System view pg_catalog.stl_burst_manager_personalization version 1.0.41533 / 2022-09-18

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	cluster_arn	char(120)
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	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	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
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