物理执行计划中，property列含义

OB Cloud
#1

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】3.2.4
【问题描述】下面括号中的是什么含义
例如：(table_type:1, version:0-1710838130747143-1710838130747143, logical_rc:3, physical_rc:3)

table_rows:3, physical_range_rows:3, logical_range_rows:3, index_back_rows:0, output_rows:3, est_method:local_storage, avaiable_index_name[departments], estimation info[table_id:1110506744103903, (table_type:1, version:0-1710838130747143-1710838130747143, logical_rc:3, physical_rc:3), (table_type:7, version:1710838120618723-1710838120618723-1710838154023066, logical_rc:0, physical_rc:0), (table_type:0, version:1710838154023066-1710838154023066-9223372036854775807, logical_rc:0, physical_rc:0)]

image
image692×219 56.6 KB

1 个赞
#3

图片太糊了，你查询的是哪张表的内容

#4

image
image1147×48 2.4 KB

语法麻烦贴一下。

#5

图片中是该语句的执行计划
SELECT
department_name,
(SELECT AVG(salary)
FROM test.employees1
where employees1.department_id = departments.department_id group by department_id ) AS avg_salary
FROM test.departments;

执行计划中最后一行访问的是departments表，最后一行的property列的信息在下面
table_rows:3, physical_range_rows:3, logical_range_rows:3, index_back_rows:0, output_rows:3, est_method:local_storage, avaiable_index_name[departments], estimation info[table_id:1110506744103903, (table_type:1, version:0-1710838130747143-1710838130747143, logical_rc:3, physical_rc:3), (table_type:7, version:1710838120618723-1710838120618723-1710838154023066, logical_rc:0, physical_rc:0), (table_type:0, version:1710838154023066-1710838154023066-9223372036854775807, logical_rc:0, physical_rc:0)] |

#6

为该语句的执行计划
SELECT
department_name,
(SELECT AVG(salary)
FROM test.employees1
where employees1.department_id = departments.department_id group by department_id ) AS avg_salary
FROM test.departments;

#7

请问你的困惑是什么，看起来property含义很清楚，比如table_rows:3, physical_range_rows:3, logical_range_rows:3,就是统计信息估计有3行，物理行有3行，逻辑行也是3行

#8

不明白version是什么含义？而且它的table_type既有1，又有7和0