[2024-02-21 14:09:10.247814] TRACE [TRACE] after_process (obmp_base.cpp:145) [7415][T1_L0_G0][T1][YB427F000001-000611DAD841BF55-0-0] [lt=63] [slow query](TRACE=begin_ts=1708495745162128 2024-02-21 06:09:05.162128|[process_begin] u=0 in_queue_time:68, receive_ts:1708495745162059, enqueue_ts:1708495745162062|[start_sql] u=0 addr:{ip:"127.0.0.1", port:37062}|[query_begin] u=1 trace_id:YB427F000001-000611DAD841BF55-0-0|[before_processor_run] u=4 |[session] u=2 sid:3221487619, tenant_id:1|[parse_begin] u=13 stmt:"ALTER SYSTEM RESTORE mysql FROM 'file:///data/backup/data,file:///data/backup' WITH 'pool_list=hf_pool'", stmt_len:103|[transform_with_outline_begin] u=32 |[transform_with_outline_end] u=2 |[resolve_begin] u=2 |[resolve_end] u=7 |[parse_begin] u=82058 stmt:"select status from __all_restore_job_history where tenant_id=1 and job_id=11", stmt_len:76|[calc_partition_location_begin] u=45 |[tl_calc_part_id_end] u=1 |[get_location_cache_begin] u=0 |[get_location_cache_end] u=2 |[calc_partition_location_end] u=1 |[pc_choose_plan] u=1 |[check_priv] u=2 |[plan_id] u=0 plan_id:1376|[do_open_plan_begin] u=10 plan_id:1376|[sql_start_stmt_begin] u=0 |[sql_start_stmt_end] u=10 |[exec_plan_begin] u=0 |[exec_plan_end] u=2 |[do_open_plan_end] u=0 |[storage_table_scan_begin] u=6 |[S_table_scan_begin] u=3 |[S_table_scan_end] u=9 |[storage_table_scan_end] u=0 |[close_plan_begin] u=18 |[S_revert_iter_begin] u=1 |[S_revert_iter_end] u=5 |[start_end_stmt] u=1 |[end_stmt] u=0 |[close_plan_end] u=0 |[affected_rows] u=0 affected_rows:-1|[store_found_rows] u=1 found_rows:0, return_rows:0|[auto_end_plan_begin] u=0 |[auto_end_plan_end] u=1 |[get_location_cache_begin] u=3 |[parse_begin] u=1000780 stmt:"select status from __all_restore_job_history where tenant_id=1 and job_id=11", stmt_len:76|[calc_partition_location_begin] u=17 |[tl_calc_part_id_end] u=2 |[get_location_cache_begin] u=0 |[get_location_cache_end] u=3 |[calc_partition_location_end] u=0 |[pc_choose_plan] u=2 |[check_priv] u=3 |[plan_id] u=0 plan_id:1376|[do_open_plan_begin] u=11 plan_id:1376|[sql_start_stmt_begin] u=0 |[sql_start_stmt_end] u=11 |[exec_plan_begin] u=0 |[exec_plan_end] u=2 |[do_open_plan_end] u=0 |[storage_table_scan_begin] u=7 |[S_table_scan_begin] u=3 |[S_table_scan_end] u=8 |[storage_table_scan_end] u=0 |[close_plan_begin] u=19 |[S_revert_iter_begin] u=0 |[S_revert_iter_end] u=4 |[start_end_stmt] u=1 |[end_stmt] u=0 |[close_plan_end] u=0 |[affected_rows] u=1 affected_rows:-1|[store_found_rows] u=0 found_rows:0, return_rows:0|[auto_end_plan_begin] u=0 |[auto_end_plan_end] u=2 |[parse_begin] u=1000530 stmt:"select status from __all_restore_job_history where tenant_id=1 and job_id=11", stmt_len:76|[calc_partition_location_begin] u=17 |[tl_calc_part_id_end] u=1 |[get_location_cache_begin] u=0 |[get_location_cache_end] u=4 |[calc_partition_location_end] u=0 |[pc_choose_plan] u=2 |[check_priv] u=2 |[plan_id] u=1 plan_id:1376|[do_open_plan_begin] u=11 plan_id:1376|[sql_start_stmt_begin] u=0 |[sql_start_stmt_end] u=10 |[exec_plan_begin] u=0 |[exec_plan_end] u=2 |[do_open_plan_end] u=0 |[storage_table_scan_begin] u=7 |[S_table_scan_begin] u=3 |[S_table_scan_end] u=8 |[storage_table_scan_end] u=0 |[close_plan_begin] u=17 |[S_revert_iter_begin] u=1 |[S_revert_iter_end] u=4 |[start_end_stmt] u=1 |[end_stmt] u=0 |[close_plan_end] u=0 |[affected_rows] u=1 affected_rows:-1|[store_found_rows] u=0 found_rows:0, return_rows:0|[auto_end_plan_begin] u=0 |[auto_end_plan_end] u=2 |[parse_begin] u=1000457 stmt:"select status from __all_restore_job_history where tenant_id=1 and job_id=11", stmt_len:76|[calc_partition_location_begin] u=21 |[tl_calc_part_id_end] u=0 |[get_location_cache_begin] u=1 |[get_location_cache_end] u=4 |[calc_partition_location_end] u=0 |[pc_choose_plan] u=2 |[check_priv] u=3 |[plan_id] u=1 plan_id:1376|[do_open_plan_begin] u=12 plan_id:1376|[sql_start_stmt_begin] u=1 |[sql_start_stmt_end] u=10 |[exec_plan_begin] u=1 |[exec_plan_end] u=2 |[do_open_plan_end] u=0 |[storage_table_scan_begin] u=8 |[S_table_scan_begin] u=3 |[S_table_scan_end] u=8 |[storage_table_scan_end] u=1 |[close_plan_begin] u=21 |[S_revert_iter_begin] u=1 |[S_revert_iter_end] u=4 |[start_end_stmt] u=1 |[end_stmt] u=0 |[close_plan_end] u=0 |[affected_rows] u=1 affected_rows:-1|[store_found_rows] u=0 found_rows:0, return_rows:0|[auto_end_plan_begin] u=0 |[auto_end_plan_end] u=2 |[parse_begin] u=1000680 stmt:"select status from __all_restore_job_history where tenant_id=1 and job_id=11", stmt_len:76|[calc_partition_location_begin] u=17 |[tl_calc_part_id_end] u=1 |[get_location_cache_begin] u=1 |[get_location_cache_end] u=3 |[calc_partition_location_end] u=0 |[pc_choose_plan] u=2 |[check_priv] u=3 |[plan_id] u=1 plan_id:1376|[do_open_plan_begin] u=10 plan_id:1376|[sql_start_stmt_begin] u=1 |[sql_start_stmt_end] u=10 |[exec_plan_begin] u=0 |[exec_plan_end] u=2 |[do_open_plan_end] u=0 |[storage_table_scan_begin] u=7 |[S_table_scan_begin] u=14 |[S_table_scan_end] u=8 |[storage_table_scan_end] u=0 |[close_plan_begin] u=20 |[S_revert_iter_begin] u=1 |[S_revert_iter_end] u=5 |[start_end_stmt] u=1 |[end_stmt] u=0 |[close_plan_end] u=0 |[affected_rows] u=0 affected_rows:-1|[store_found_rows] u=1 found_rows:0, return_rows:0|[auto_end_plan_begin] u=0 |[auto_end_plan_end] u=2 |[parse_begin] u=1000364 stmt:"select status from __all_restore_job_history where tenant_id=1 and job_id=11", stmt_len:76|[calc_partition_location_begin] u=16 |[tl_calc_part_id_end] u=1 |[get_location_cache_begin] u=0 |[get_location_cache_end] u=4 |[calc_partition_location_end] u=0 |[pc_choose_plan] u=2 |[check_priv] u=2 |[plan_id] u=1 plan_id:1376|[do_open_plan_begin] u=11 plan_id:1376|[sql_start_stmt_begin] u=0 |[sql_start_stmt_end] u=9 |[exec_plan_begin] u=1 |[exec_plan_end] u=2 |[do_open_plan_end] u=0 |[storage_table_scan_begin] u=6 |[S_table_scan_begin] u=4 |[S_table_scan_end] u=7 |[storage_table_scan_end] u=0 |[close_plan_begin] u=53 |[S_revert_iter_begin] u=1 |[S_revert_iter_end] u=5 |[start_end_stmt] u=1 |[end_stmt] u=0 |[close_plan_end] u=0 |[affected_rows] u=0 affected_rows:-1|[store_found_rows] u=0 found_rows:0, return_rows:1|[auto_end_plan_begin] u=1 |[auto_end_plan_end] u=2 |[session] u=66 sid:3221487619, tenant_id:1|[query_end] u=15 |[session] u=4 sid:3221487619, tenant_id:1|[process_end] u=6 run_ts:1708495745162133|total_timeu=5085682)