GS_OBSSCANINFO

GS_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 GS_OBSSCANINFO columns

Name

Type

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.