Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_OBSSCANINFO

PG_OBSSCANINFO

Updated at: Dec 30, 2020 GMT+08:00

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

-

Query ID

user_id

text

-

Database user who performs queries

table_name

text

-

Name of a foreign table on OBS

file_type

text

-

Format of files storing the underlying data

time_stamp

time_stam

-

Scanning start time

actual_time

double

-

Scanning execution time, in seconds

file_scanned

bigint

-

Number of files scanned

data_size

double

-

Size of data scanned, in bytes

billing_info

text

-

Reserved columns

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel