SYS_DATASHARE_CROSS_REGION_USAGE - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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