Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs/ GS_OBSSCANINFO
Updated on 2025-06-12 GMT+08:00
View PDF

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

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.
Parent Topic: System Catalogs