Updated on 2023-10-23 GMT+08:00

GS_OBSSCANINFO

GS_OBSSCANINFO defines OBS runtime information scanned in cluster acceleration scenarios. (Due to specification changes, the current version no longer supports the current feature. Do not use this feature.) Each record corresponds to a piece of runtime information of a foreign table on OBS in a query. (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.)

Table 1 GS_OBSSCANINFO columns

Name

Type

Reference

Description

query_id

bigint

-

Query ID

user_id

text

-

Database user who performs the query

table_name

text

-

Name of a foreign table on OBS

file_type

text

-

Format of the file that stores underlying data

time_stamp

timestamp with time zone

-

Scanning start time

actual_time

double precision

-

Scanning execution time, in seconds

file_scanned

bigint

-

Number of files scanned

data_size

double precision

-

Size of data scanned, in bytes

billing_info

text

-

Reserved