Orca DEBUG

Debug GUC

SET client_min_messages=log;
SET optimizer_print_optimization_context=on;
set optimizer_print_memo_after_exploration=on;
set optimizer_print_memo_after_implementation=on;
set optimizer_print_memo_after_optimization=on;
set optimizer_cte_inlining=on;

// 调 xform
set optimizer_print_xform to on;
set optimizer_print_xform_results to on;

set optimizer_print_optimization_stats=on;
set optimizer_print_query to on; // 原始 query + preprocess 后（内存信息）
set optimizer_minidump to always;    // 全部 dxl 信息
set optimizer_print_plan to on;  // 物理 plan （内存信息）

// 调莫名其妙的问题，看 statemachine 状态
set optimizer_print_job_scheduler to on;

trace

SET client_min_messages=log;
GPOS_TRACE_FORMAT("[NL JOIN] Using replicated logic. Using inner distribution. %d", 3);
GPOS_TRACE(GPOS_WSZ_LIT("Queued job is executing -> wait"));