Help Center/ GaussDB(DWS)/ Standard Data Warehouse (9.1.0.x)/ System Catalogs and System Views/ System Catalogs/ PG_OBSSCANINFO
Updated on 2024-09-30 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