执行_引擎_配置文件
提供有关运行时查询执行的配置文件信息。ID 的层次结构，从最高级别到实际执行是：
-
PATH_ID -
BASEPLAN_ID -
LOCALPLAN_ID -
OPERATOR_ID
收集每一实际执行引擎 (EE) 运算符实例的计数器（从 COUNTER_NAME 列输出）。
以下列组合形成唯一键：
-
TRANSACTION_ID -
STATEMENT_ID -
NODE_NAME -
OPERATOR_ID -
COUNTER_NAME -
COUNTER_TAG
特权
非超级用户：不需要任何显式权限。您只会看到您有权查看的表的记录。
计数器名称
COUNTER_NAME 的值可以是以下任意值：
示例
以下两项查询显示 EXECUTION_ENGINE_PROFILES 表的内容：
=> SELECT operator_name, operator_id, counter_name, counter_value FROM EXECUTION_ENGINE_PROFILES WHERE operator_name = 'Scan' ORDER BY counter_value DESC; operator_name | operator_id | counter_name | counter_value ---------------+-------------+--------------+------------------ Scan | 20 | end time | 1559929719983785 Scan | 20 | start time | 1559929719983737 Scan | 18 | end time | 1559929719983358 Scan | 18 | start time | 1559929718069860 Scan | 16 | end time | 1559929718069319 Scan | 16 | start time | 1559929718069188 Scan | 14 | end time | 1559929718068611 Scan | 18 | end time | 1559929717579145 Scan | 18 | start time | 1559929717579083 Scan | 16 | end time | 1559929717578509 Scan | 18 | end time | 1559929717379346 Scan | 18 | start time | 1559929717379307 Scan | 16 | end time | 1559929717378879 Scan | 16 | start time | 1559929716894312 Scan | 14 | end time | 1559929716893599 Scan | 14 | start time | 1559929716893501 Scan | 12 | end time | 1559929716892721 Scan | 16 | start time | 1559929716666110 ... => SELECT DISTINCT counter_name FROM execution_engine_profiles; counter_name ----------------------------------------------------- reserved rid memory (bytes) rows filtered by SIPs expression rows output by sort chunk rows scanned squared join inner execution time (us) current unbalanced memory requested (bytes) clock time (us) join outer clock time (us) exception handling execution time (us) peak memory capacity (bytes) bytes received peak memory requested (bytes) send time (us) ROS blocks encoded current size of temp files (bytes) peak memory allocations (count) current unbalanced memory overhead (bytes) rows segmented ...
以下查询包括 path_id 列，该列将此查询优化器的路径（通过 EXPLAIN 命令的文本输出）与合并错误信息相连接。
=> SELECT operator_name, path_id, counter_name, counter_value FROM execution_engine_profiles where operator_name = 'Join'; operator_name | path_id | counter_name | counter_value ---------------+---------+-----------------------------------------------------+------------------ Join | 64 | current memory allocations (count) | 0 Join | 64 | peak memory allocations (count) | 57 Join | 64 | current memory requested (bytes) | 0 Join | 64 | peak memory requested (bytes) | 1698240 Join | 64 | current memory overhead (bytes) | 0 Join | 64 | peak memory overhead (bytes) | 0 Join | 64 | current memory padding (bytes) | 0 Join | 64 | peak memory padding (bytes) | 249840 Join | 64 | current memory capacity (bytes) | 0 Join | 64 | peak memory capacity (bytes) | 294912 Join | 64 | current unbalanced memory allocations (count) | 145 Join | 64 | peak unbalanced memory allocations (count) | 146 Join | 64 | current unbalanced memory requested (bytes) | 116506 Join | 64 | peak unbalanced memory requested (bytes) | 1059111 Join | 64 | current unbalanced memory overhead (bytes) | 3120 Join | 64 | peak unbalanced memory overhead (bytes) | 3120 ...