root node id: 00000000-0000-0000-0000-000000000000 Top time-consuming leaf span: +----+----------------+--------------+--------------------------+ | ID | Leaf Span Name | Elapsed Time | HOSTS | +----+----------------+--------------+--------------------------+ | 10 | optimize | 433 μs | OBSERVER (10.198.40.115) | | 7 | parse | 82 μs | OBSERVER (10.198.40.115) | | 8 | resolve | 226 μs | OBSERVER (10.198.40.115) | | 9 | rewrite | 405 μs | OBSERVER (10.198.40.115) | | 11 | code_generate | 129 μs | OBSERVER (10.198.40.115) | +----+----------------+--------------+--------------------------+ Tags & Logs: ------------------------------------- 10 - optimize Elapsed: 433 μs OBSERVER (10.198.40.115) 7 - parse Elapsed: 82 μs OBSERVER (10.198.40.115) 8 - resolve Elapsed: 226 μs OBSERVER (10.198.40.115) 9 - rewrite Elapsed: 405 μs OBSERVER (10.198.40.115) 11 - code_generate Elapsed: 129 μs OBSERVER (10.198.40.115) Details: +---+------------------------------+-------------+-------------------------+ | ID| Span Name | Elapsed Time| HOSTS | +---+------------------------------+-------------+-------------------------+ | 1 | TRACE | - | | | 2 | └─com_query_process | 104.824 ms | OBSERVER (10.198.40.115)| | 3 | └─mpquery_single_stmt | 104.804 ms | | | 4 | ├─sql_compile | 1.648 ms | | | 5 | │ ├─pc_get_plan | 11 μs | OBSERVER (10.198.40.115)| | 6 | │ └─hard_parse | 1.571 ms | | | 7 | │ ├─parse | 82 μs | OBSERVER (10.198.40.115)| | 8 | │ ├─resolve | 226 μs | OBSERVER (10.198.40.115)| | 9 | │ ├─rewrite | 405 μs | OBSERVER (10.198.40.115)| | 10| │ ├─optimize | 433 μs | OBSERVER (10.198.40.115)| | 11| │ ├─code_generate | 129 μs | OBSERVER (10.198.40.115)| | 12| │ └─pc_add_plan | 41 μs | OBSERVER (10.198.40.115)| | 13| └─sql_execute | 103.075 ms | | | 14| ├─open | 24 μs | OBSERVER (10.198.40.115)| | 15| ├─response_result | 102.917 ms | | | 16| │ ├─get_das_id | 1 μs | OBSERVER (10.198.40.115)| | 17| │ └─do_local_das_task | 34 μs | OBSERVER (10.198.40.115)| | 18| └─close | 76 μs | | | 19| ├─close_das_task | 14 μs | OBSERVER (10.198.40.115)| | 20| └─end_transaction | 3 μs | OBSERVER (10.198.40.115)| +---+------------------------------+-------------+-------------------------+ Tags & Logs: ------------------------------------- 1 - 2 - com_query_process Elapsed: 104.824 ms OBSERVER (10.198.40.115) tags: [{'sess_id': 3221759268}, {'action_name': ''}, {'module_name': ''}, {'client_info': ''}, {'receive_ts': 1733208736639912}, {'log_trace_id': 'YB420AC62873-000628578DC7707E-0-0'}] 3 - mpquery_single_stmt Elapsed: 104.804 ms 4 - sql_compile Elapsed: 1.648 ms tags: [{'sql_text': '/* ApplicationName=DBeaver 24.1.3 - SQLEditor */ select avg(WC004_STATUS) from WF004_FLOWRUN_20220513\nLIMIT 0, 200'}, {'hit_plan': False}, {'sql_id': 'D53E9CA07B1D1F73E3C617552F95CF6C'}, {'database_id': 504077}, {'plan_hash': 2318541382026610600}] 5 - pc_get_plan Elapsed: 11 μs OBSERVER (10.198.40.115) 6 - hard_parse Elapsed: 1.571 ms 7 - parse Elapsed: 82 μs OBSERVER (10.198.40.115) 8 - resolve Elapsed: 226 μs OBSERVER (10.198.40.115) 9 - rewrite Elapsed: 405 μs OBSERVER (10.198.40.115) 10 - optimize Elapsed: 433 μs OBSERVER (10.198.40.115) 11 - code_generate Elapsed: 129 μs OBSERVER (10.198.40.115) 12 - pc_add_plan Elapsed: 41 μs OBSERVER (10.198.40.115) 13 - sql_execute Elapsed: 103.075 ms 14 - open Elapsed: 24 μs OBSERVER (10.198.40.115) 15 - response_result Elapsed: 102.917 ms 16 - get_das_id Elapsed: 1 μs OBSERVER (10.198.40.115) 17 - do_local_das_task Elapsed: 34 μs OBSERVER (10.198.40.115) 18 - close Elapsed: 76 μs 19 - close_das_task Elapsed: 14 μs OBSERVER (10.198.40.115) 20 - end_transaction Elapsed: 3 μs OBSERVER (10.198.40.115) tags: [{'trans_id': 0}]