Redshift Observatory

System Table Tracker

System view pg_catalog.svl_datashare_cross_region_usage version 1.0.63205 / 2024-02-14

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