obclient(root@sys)[oceanbase]> set ob_enable_show_trace = on; Query OK, 0 rows affected (0.001 sec) obclient(root@sys)[oceanbase]> CREATE TABLE analytics_table73 ( user_id INT, event_name VARCHAR(100), event_date DATE, metric_value DECIMAL(10,2) ); Query OK, 0 rows affected (30.132 sec) obclient(root@sys)[oceanbase]> show trace; +-------------------------------------------------------+----------------------------+--------------+ | Operation | StartTime | ElapseTime | +-------------------------------------------------------+----------------------------+--------------+ | com_query_process | 2026-03-09 12:56:36.819504 | 30131.202 ms | | └── mpquery_single_stmt | 2026-03-09 12:56:36.819511 | 30131.172 ms | | ├── sql_compile | 2026-03-09 12:56:36.819528 | 0.720 ms | | │ ├── pc_get_plan | 2026-03-09 12:56:36.819533 | 0.023 ms | | │ └── hard_parse | 2026-03-09 12:56:36.819641 | 0.581 ms | | │ ├── parse | 2026-03-09 12:56:36.819642 | 0.122 ms | | │ └── resolve | 2026-03-09 12:56:36.819817 | 0.358 ms | | └── sql_execute | 2026-03-09 12:56:36.820276 | 30130.296 ms | | ├── open | 2026-03-09 12:56:36.820277 | 30130.114 ms | | │ └── cmd_open | 2026-03-09 12:56:36.820278 | 30130.069 ms | | │ ├── end_transaction | 2026-03-09 12:56:36.820280 | 0.001 ms | | │ ├── sql_compile | 2026-03-09 12:56:36.826371 | 0.469 ms | | │ │ ├── pc_get_plan | 2026-03-09 12:56:36.826413 | 0.009 ms | | │ │ └── hard_parse | 2026-03-09 12:56:36.826558 | 0.246 ms | | │ │ ├── parse | 2026-03-09 12:56:36.826560 | 0.031 ms | | │ │ └── resolve | 2026-03-09 12:56:36.826704 | 0.051 ms | | │ ├── open | 2026-03-09 12:56:36.826957 | 0.124 ms | | │ │ └── cmd_open | 2026-03-09 12:56:36.826957 | 0.088 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.826959 | 0.001 ms | | │ ├── close | 2026-03-09 12:56:36.827163 | 0.001 ms | | │ ├── close | 2026-03-09 12:56:36.836819 | 0.098 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.836820 | 0.015 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.836877 | 0.002 ms | | │ ├── close | 2026-03-09 12:56:36.842393 | 0.090 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.842394 | 0.012 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.842445 | 0.002 ms | | │ ├── close | 2026-03-09 12:56:36.847504 | 0.082 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.847505 | 0.006 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.847548 | 0.002 ms | | │ ├── close | 2026-03-09 12:56:36.865014 | 0.139 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.865015 | 0.010 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.865063 | 0.014 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.865115 | 0.002 ms | | │ ├── close | 2026-03-09 12:56:36.870445 | 0.078 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.870446 | 0.010 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.870490 | 0.002 ms | | │ ├── close | 2026-03-09 12:56:36.874808 | 0.064 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.874809 | 0.005 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.874842 | 0.002 ms | | │ ├── sql_compile | 2026-03-09 12:56:36.880905 | 0.251 ms | | │ │ ├── pc_get_plan | 2026-03-09 12:56:36.880909 | 0.007 ms | | │ │ └── hard_parse | 2026-03-09 12:56:36.880963 | 0.161 ms | | │ │ ├── parse | 2026-03-09 12:56:36.880964 | 0.019 ms | | │ │ └── resolve | 2026-03-09 12:56:36.881057 | 0.031 ms | | │ ├── open | 2026-03-09 12:56:36.881256 | 0.114 ms | | │ │ └── cmd_open | 2026-03-09 12:56:36.881257 | 0.081 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.881258 | 0.001 ms | | │ ├── close | 2026-03-09 12:56:36.881444 | 0.001 ms | | │ ├── close | 2026-03-09 12:56:36.882126 | 0.050 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.882127 | 0.005 ms | | │ ├── sql_compile | 2026-03-09 12:56:36.889735 | 0.260 ms | | │ │ ├── pc_get_plan | 2026-03-09 12:56:36.889742 | 0.007 ms | | │ │ └── hard_parse | 2026-03-09 12:56:36.889799 | 0.161 ms | | │ │ ├── parse | 2026-03-09 12:56:36.889800 | 0.016 ms | | │ │ └── resolve | 2026-03-09 12:56:36.889890 | 0.032 ms | | │ ├── open | 2026-03-09 12:56:36.890109 | 0.118 ms | | │ │ └── cmd_open | 2026-03-09 12:56:36.890109 | 0.084 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.890110 | 0.001 ms | | │ ├── close | 2026-03-09 12:56:36.890308 | 0.001 ms | | │ ├── close | 2026-03-09 12:56:36.890930 | 0.050 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.890931 | 0.005 ms | | │ ├── close | 2026-03-09 12:56:36.898569 | 0.083 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.898570 | 0.010 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.898618 | 0.002 ms | | │ ├── close | 2026-03-09 12:56:36.930347 | 0.060 ms | | │ │ ├── close_das_task | 2026-03-09 12:56:36.930348 | 0.012 ms | | │ │ └── end_transaction | 2026-03-09 12:56:36.930385 | 0.002 ms | | │ ├── close | 2026-03-09 12:56:36.935944 | 0.035 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.935944 | 0.009 ms | | │ ├── close | 2026-03-09 12:56:36.937943 | 0.048 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.937945 | 0.015 ms | | │ ├── close | 2026-03-09 12:56:36.938434 | 0.030 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.938434 | 0.007 ms | | │ ├── close | 2026-03-09 12:56:36.938744 | 0.028 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.938745 | 0.005 ms | | │ ├── close | 2026-03-09 12:56:36.939038 | 0.027 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.939038 | 0.005 ms | | │ ├── close | 2026-03-09 12:56:36.939282 | 0.020 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.939282 | 0.003 ms | | │ ├── close | 2026-03-09 12:56:36.939654 | 0.034 ms | | │ │ └── close_das_task | 2026-03-09 12:56:36.939655 | 0.005 ms | | │ └── close | 2026-03-09 12:56:36.941364 | 0.057 ms | | │ └── close_das_task | 2026-03-09 12:56:36.941365 | 0.024 ms | | └── close | 2026-03-09 12:57:06.950430 | 0.004 ms | +-------------------------------------------------------+----------------------------+--------------+