doc-exports/docs/dws/dev/dws_04_0602.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

8.4 KiB

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

-

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