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

PG_OBSSCANINFO

PG_OBSSCANINFO defines OBS runtime information scanned in database instance acceleration scenarios. Each record corresponds to a piece of runtime information of a foreign table on OBS in a query. (Due to specification changes, the current version no longer supports the current feature. Do not use this feature.)

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 column