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

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

N/A

Query ID

user_id

Text

N/A

Database user who performs queries

table_name

Text

N/A

Name of a foreign table on OBS

file_type

Text

N/A

Format of files storing the underlying data

time_stamp

time_stam

N/A

Scanning start time

actual_time

Double

N/A

Scanning execution time, in seconds

file_scanned

Bigint

N/A

Number of files scanned

data_size

Double

N/A

Size of data scanned, in bytes

billing_info

Text

N/A

Reserved column
Parent Topic: System Catalogs