/*dddbs='postgres.db',traceparent='00-00000000000000000000000000000001-0000000000000001-01'*/ select count(*) from pg_tracing_test r join pg_tracing_test s using (a);
 count 
-------
 10000
(1 row)

SELECT span_operation, deparse_info, parameters, lvl from peek_ordered_spans where trace_id='00000000000000000000000000000001';
                              span_operation                              |    deparse_info    | parameters | lvl 
--------------------------------------------------------------------------+--------------------+------------+-----
 select count(*) from pg_tracing_test r join pg_tracing_test s using (a); |                    |            |   0
 Planner                                                                  |                    |            |   1
 ExecutorRun                                                              |                    |            |   1
 Aggregate                                                                |                    |            |   2
 Hash Join                                                                | Hash Cond: (a = a) |            |   3
 SeqScan on pg_tracing_test r                                             |                    |            |   4
 Hash                                                                     |                    |            |   4
 SeqScan on pg_tracing_test s                                             |                    |            |   5
(8 rows)

-- +-----------------------------------------+
-- | A: HashJoin                             |
-- ++-----------------+----------------------+
--  | B: SeqScan      |
--  +-----------------+
--    +--------------------+
--    | C: Hash            |
--    +--------------------+
--    | D: SeqScan   |
--    +--------------+
SELECT span_id AS span_a_id,
        get_epoch(span_start) as span_a_start,
        get_epoch(span_end) as span_a_end
		from pg_tracing_peek_spans
        where trace_id='00000000000000000000000000000001' AND span_operation='Hash Join' \gset
SELECT span_id AS span_b_id,
        get_epoch(span_start) as span_b_start,
        get_epoch(span_end) as span_b_end
		from pg_tracing_peek_spans
        where parent_id =:'span_a_id' and span_operation='SeqScan on pg_tracing_test r' \gset
SELECT span_id AS span_c_id,
        get_epoch(span_start) as span_c_start,
        get_epoch(span_end) as span_c_end
		from pg_tracing_peek_spans
        where parent_id =:'span_a_id' and span_operation='Hash' \gset
SELECT span_id AS span_d_id,
        get_epoch(span_start) as span_d_start,
        get_epoch(span_end) as span_d_end
		from pg_tracing_peek_spans
        where parent_id =:'span_c_id' and span_operation='SeqScan on pg_tracing_test s' \gset
SELECT :span_a_end >= :span_c_end as root_ends_last,
       :span_c_start >= :span_b_start as hash_start_after_seqscan,
       :span_c_start = :span_d_start as hash_start_same_as_child_seqscan,
       :span_d_end <= :span_c_end as nested_seq_scan_end_before_parent;
 root_ends_last | hash_start_after_seqscan | hash_start_same_as_child_seqscan | nested_seq_scan_end_before_parent 
----------------+--------------------------+----------------------------------+-----------------------------------
 t              | t                        | t                                | t
(1 row)

-- Clean created spans
CALL clean_spans();