Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_xrestore	backup_id	char(256)
pg_catalog	stl_xrestore	catalog_download_end_time	timestamp
pg_catalog	stl_xrestore	catalog_download_start_time	timestamp
pg_catalog	stl_xrestore	data_skew_cluster	float8
pg_catalog	stl_xrestore	guid_pool_hit_rate	float8
pg_catalog	stl_xrestore	node	int4
pg_catalog	stl_xrestore	node_occ_mean	float8
pg_catalog	stl_xrestore	node_occ_variance	float8
pg_catalog	stl_xrestore	num_guids_created_on_demand	int4
pg_catalog	stl_xrestore	slice_transfer_end_time	timestamp
pg_catalog	stl_xrestore	slice_transfer_start_time	timestamp
pg_catalog	stl_xrestore	xrestore_source	int4
pg_catalog	stl_xrestore	xrestore_type	int4

View Text

SELECT stll_xrestore.backup_id,
       stll_xrestore.node,
       stll_xrestore.catalog_download_start_time,
       stll_xrestore.catalog_download_end_time,
       stll_xrestore.slice_transfer_start_time,
       stll_xrestore.slice_transfer_end_time,
       stll_xrestore.guid_pool_hit_rate,
       stll_xrestore.num_guids_created_on_demand,
       stll_xrestore.node_occ_mean,
       stll_xrestore.node_occ_variance,
       stll_xrestore.data_skew_cluster,
       stll_xrestore.xrestore_type,
       stll_xrestore.xrestore_source
FROM stll_xrestore

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