/*traceparent='00-00000000000000000000000000000001-0000000000000001-01'*/ SELECT * from pg_tracing_test where a=1 OR b='2' OR c=3; a | b | c ---+----------------------+--- 1 | 1 | 1 2 | 2 | 2 3 | 3 | 3 (3 rows) -- PG < 18 -- +-----------------------------------------------------------------------------------------+ -- | A: BitmapOr | -- ++-----------------------------+-------------------------------+--------------------------+ -- |B: Bitmap Index Scan (a=1) |C: Bitmap Index Scan (b='2') |D: Bitmap Index Scan (c=3)| -- +-----------------------------+-------------------------------+--------------------------+ -- PG >= 18 -- +-----------------------------------------------------------------------------------------+ -- | A: BitmapOr | -- ++-----------------------------+-------------------------------+--------------------------+ -- |B: Bitmap Index Scan (c=1) |C: Bitmap Index Scan (b='2') |D: Bitmap Index Scan (a=1)| -- +-----------------------------+-------------------------------+--------------------------+ SELECT span_operation, deparse_info, parameters, pos_start, pos_end, lvl from peek_ordered_spans_with_pos where trace_id='00000000000000000000000000000001'; span_operation | deparse_info | parameters | pos_start | pos_end | lvl ----------------------------------------------------------+---------------------------------------------------------+------------+-----------+---------+----- SELECT * from pg_tracing_test where a=$1 OR b=$2 OR c=$3 | | {1,'2',3} | 1 | 11 | 0 Planner | | | 2 | 3 | 1 ExecutorRun | | | 4 | 10 | 1 BitmapHeapScan on pg_tracing_test | Recheck Cond: ((a = 1) OR (b = '2'::bpchar) OR (c = 3)) | | 5 | 9 | 2 BitmapOr | | | 5 | 8 | 3 BitmapIndexScan on pg_tracing_index_a | Index Cond: (a = 1) | | 5 | 6 | 4 BitmapIndexScan on pg_tracing_index_b | Index Cond: (b = '2'::bpchar) | | 6 | 7 | 4 BitmapIndexScan on pg_tracing_index_c | Index Cond: (c = 3) | | 7 | 8 | 4 (8 rows) -- Clean created spans CALL clean_spans();