root node id: 00000000-0000-0000-0000-000000000000 Top time-consuming leaf span: +----+-----------------------------+--------------+---------------------------+ | ID | Leaf Span Name | Elapsed Time | HOSTS | +----+-----------------------------+--------------+---------------------------+ | 4 | ob_proxy_server_process_req | 39.029 s | OBPROXY (1.1.1.553) | | 12 | rewrite | 9.292 ms | OBSERVER (1.1.1.554) | | 11 | resolve | 5.593 ms | OBSERVER (1.1.1.554) | | 13 | optimize | 209.694 ms | OBSERVER (1.1.1.554) | | 14 | code_generate | 2.184 ms | OBSERVER (1.1.1.554) | +----+-----------------------------+--------------+---------------------------+ Tags & Logs: ------------------------------------- 4 - ob_proxy_server_process_req Elapsed: 39.029 s OBPROXY (1.1.1.553) 12 - rewrite Elapsed: 9.292 ms OBSERVER (1.1.1.554) 11 - resolve Elapsed: 5.593 ms OBSERVER (1.1.1.554) 13 - optimize Elapsed: 209.694 ms OBSERVER (1.1.1.554) 14 - code_generate Elapsed: 2.184 ms OBSERVER (1.1.1.554) Details: +---+-----------------------------------------+-------------+--------------------------+ | ID| Span Name | Elapsed Time| HOSTS | +---+-----------------------------------------+-------------+--------------------------+ | 1 | TRACE | - | | | 2 | └─ob_proxy | 39.030 s | | | 3 | ├─ob_proxy_partition_location_lookup | 8 μs | OBPROXY (1.1.1.553) | | 4 | ├─ob_proxy_server_process_req | 39.029 s | OBPROXY (1.1.1.553) | | 5 | └─com_query_process | 39.030 s | | | 6 | └─mpquery_single_stmt | 39.030 s | | | 7 | ├─sql_compile | 230.304 ms | | | 8 | │ ├─pc_get_plan | 361 μs | OBSERVER (1.1.1.554)| | 9 | │ └─hard_parse | 229.882 ms | | | 10| │ ├─parse | 663 μs | OBSERVER (1.1.1.554)| | 11| │ ├─resolve | 5.593 ms | OBSERVER (1.1.1.554)| | 12| │ ├─rewrite | 9.292 ms | OBSERVER (1.1.1.554)| | 13| │ ├─optimize | 209.694 ms | OBSERVER (1.1.1.554)| | 14| │ ├─code_generate | 2.184 ms | OBSERVER (1.1.1.554)| | 15| │ └─pc_add_plan | 230 μs | OBSERVER (1.1.1.554)| | 16| └─sql_execute | 38.799 s | | | 17| ├─open | 579 μs | OBSERVER (1.1.1.554)| | 18| ├─response_result | 38.798 s | | | 19| │ ├─px_schedule | 626 μs | OBSERVER (1.1.1.554)| | 20| │ ├─do_local_das_task | 167 μs | OBSERVER (1.1.1.554)| | 21| │ └─px_schedule | 1 μs | OBSERVER (1.1.1.554)| | 22| └─close | 355 μs | | | 23| ├─close_das_task | 29 μs | OBSERVER (1.1.1.554)| | 24| └─end_transaction | 13 μs | OBSERVER (1.1.1.554)| +---+-----------------------------------------+-------------+--------------------------+ Tags & Logs: ------------------------------------- 1 - 2 - ob_proxy Elapsed: 39.030 s tags: [{'client_host': '10.32.192.34:28481'}, {'query_end_ts': 1729689773807591}, {'query_start_ts': 1729689734779218}] 3 - ob_proxy_partition_location_lookup Elapsed: 8 μs OBPROXY (1.1.1.553) 4 - ob_proxy_server_process_req Elapsed: 39.029 s OBPROXY (1.1.1.553) 5 - com_query_process Elapsed: 39.030 s tags: [{'sess_id': 3222675387}, {'action_name': ''}, {'module_name': ''}, {'client_info': ''}, {'receive_ts': 1729689734779218}, {'log_trace_id': 'YB420AFCD2A4-000622533FCE7BA6-0-0'}] 6 - mpquery_single_stmt Elapsed: 39.030 s 7 - sql_compile Elapsed: 230.304 ms tags: [{'sql_id': '17F1ECE4E8CD0803A03A460D6EA3FDAE'}, {'database_id': 500003}, {'plan_hash': 1572148389065452751}, {'hit_plan': False}, {'sql_text': "SELECT****HIDE***"}] 8 - pc_get_plan Elapsed: 361 μs OBSERVER (1.1.1.554) 9 - hard_parse Elapsed: 229.882 ms 10 - parse Elapsed: 663 μs OBSERVER (1.1.1.554) 11 - resolve Elapsed: 5.593 ms OBSERVER (1.1.1.554) 12 - rewrite Elapsed: 9.292 ms OBSERVER (1.1.1.554) 13 - optimize Elapsed: 209.694 ms OBSERVER (1.1.1.554) 14 - code_generate Elapsed: 2.184 ms OBSERVER (1.1.1.554) 15 - pc_add_plan Elapsed: 230 μs OBSERVER (1.1.1.554) 16 - sql_execute Elapsed: 38.799 s 17 - open Elapsed: 579 μs OBSERVER (1.1.1.554) 18 - response_result Elapsed: 38.798 s 19 - px_schedule Elapsed: 626 μs OBSERVER (1.1.1.554) 20 - do_local_das_task Elapsed: 167 μs OBSERVER (1.1.1.554) 21 - px_schedule Elapsed: 1 μs OBSERVER (1.1.1.554) 22 - close Elapsed: 355 μs 23 - close_das_task Elapsed: 29 μs OBSERVER (1.1.1.554) 24 - end_transaction Elapsed: 13 μs OBSERVER (1.1.1.554) tags: [{'trans_id': 153749943}]