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 