Redshift Observatory

System Table Tracker

System view pg_catalog.svl_datashare_cross_region_usage version 1.0.47470 / 2023-03-11

schema	name	column	data type
pg_catalog	svl_datashare_cross_region_usage	end_time	int8
pg_catalog	svl_datashare_cross_region_usage	query	int4
pg_catalog	svl_datashare_cross_region_usage	segment	int8
pg_catalog	svl_datashare_cross_region_usage	source_region	char(64)
pg_catalog	svl_datashare_cross_region_usage	start_time	int8
pg_catalog	svl_datashare_cross_region_usage	transferred_data	int8

View Text

SELECT stl_s3client.query,
       stl_s3client.segnum AS segment,
       min(stl_s3client.start_time) AS start_time,
       max(stl_s3client.end_time) AS end_time,
       sum(stl_s3client.transfer_size) AS transferred_data,
       stl_s3client.region AS source_region
FROM stl_s3client
WHERE stl_s3client.is_xregion = 1
  AND stl_s3client.query <> -1
  AND stl_s3client.segnum <> -1
  AND stl_s3client.userid <> 1
GROUP BY stl_s3client.query, stl_s3client.segnum, stl_s3client.region

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