Updated on 2024-10-14 GMT+08:00

PG_OBSSCANINFO

PG_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 technical support before using it.)

Table 1 PG_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