SYS_DATASHARE_CROSS_REGION_USAGE - Amazon Redshift
Table columnsSample queries

SYS_DATASHARE_CROSS_REGION_USAGE

Use the SYS_DATASHARE_CROSS_REGION_USAGE view to get a summary of cross-Region data transferred usage caused by cross-Region datasharing query. SYS_DATASHARE_CROSS_REGION_USAGE aggregates details at the segment level.

SYS_DATASHARE_CROSS_REGION_USAGE is visible only to superusers. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
query_id integer The ID of the query. Use this value to join other system tables and views.
child_query_sequence integer The sequence of the rewritten user query, starting with 1.
segment_id bigint The number of the segment. A query consists of multiple segments, and each segment consists of one or more steps.
start_time time The time in UTC that the data transfer began.
end_time time The time in UTC that the data transfer ended.
transferred_data bigint The number of bytes of data transferred from a producer Region to a consumer Region.
source_region char(25) The producer Region that the query transferred data from.

Sample queries

The following example shows a SYS_DATASHARE_CROSS_REGION_USAGE view.

SELECT query_id, segment_id, transferred_data, source_region
from sys_datashare_cross_region_usage
where query_id = pg_last_query_id()
order by query_id, segment_id;

  query_id | segment_id | transferred_data | source_region 
-----------+------------+------------------+---------------
    200048 |          2 |          4194304 |    us-west-1  
    200048 |          2 |          4194304 |    us-east-2