• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_OBSSCANINFO

PG_OBSSCANINFO

PG_OBSSCANINFO defines the OBS runtime information scanned in cluster acceleration scenarios. Each record corresponds to a piece of runtime information of a foreign table on OBS in a query.

Table 1 PG_OBSSCANINFO columns

Name

Type

Reference

Description

query_id

bigint

-

Specifies a query ID.

user_id

text

-

Specifies a database user who performs queries.

table_name

text

-

Specifies the name of a foreign table on OBS.

file_type

text

-

Specifies the format of files storing the underlying data.

time_stamp

time_stam

-

Specifies the scanning start time.

actual_time

double

-

Specifies the scanning execution time in seconds.

file_scanned

bigint

-

Specifies the number of files scanned.

data_size

double

-

Specifies the size of data scanned in bytes.

billing_info

text

-

Specifies the reserved fields.