explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7I1Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on public.journal (cost=1,310,770.86..1,840,559.36 rows=1 width=327) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,310,770.86..1,840,559.36 rows=1 width=327) (actual rows= loops=)

  • Output: 'D004'::character(4), g_t0.onbehalf_of_comp_id, NULL::character(3), g_t0.dsaiom, 'Trader n''existe pas dans BR_TRADER'::character varying(100), 'R'::character(1), 0, '2019-07-01'::date
  • Join Filter: ((g_t0.dsaiom = g_t1.dsaiom) AND (g_t0.security_id = g_t1.amr_code))
3. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=1,310,770.86..1,840,494.03 rows=1 width=31) (actual rows= loops=)

  • Output: g_t0.onbehalf_of_comp_id, g_t0.dsaiom, g_t0.security_id
  • Merge Cond: (((rtrim(ltrim((g_t2.trader_mnemo)::text))) = (rtrim(ltrim((g_t0.onbehalf_of_comp_id)::text)))) AND (g_t2.dsaiom = g_t0.dsaiom))
  • Filter: (g_t2.ctraderbdm IS NULL)
4. 0.000 0.000 ↓ 0.0

Sort (cost=104.13..107.88 rows=1,500 width=19) (actual rows= loops=)

  • Output: g_t2.trader_mnemo, g_t2.dsaiom, g_t2.ctraderbdm, (rtrim(ltrim((g_t2.trader_mnemo)::text)))
  • Sort Key: (rtrim(ltrim((g_t2.trader_mnemo)::text))), g_t2.dsaiom
5. 0.000 0.000 ↓ 0.0

Seq Scan on public.w_ordre_trader_tu4 g_t2 (cost=0.00..25.00 rows=1,500 width=19) (actual rows= loops=)

  • Output: g_t2.trader_mnemo, g_t2.dsaiom, g_t2.ctraderbdm, rtrim(ltrim((g_t2.trader_mnemo)::text))
6. 0.000 0.000 ↓ 0.0

Sort (cost=1,310,666.73..1,324,928.45 rows=5,704,687 width=31) (actual rows= loops=)

  • Output: g_t0.onbehalf_of_comp_id, g_t0.dsaiom, g_t0.security_id, (rtrim(ltrim((g_t0.onbehalf_of_comp_id)::text)))
  • Sort Key: (rtrim(ltrim((g_t0.onbehalf_of_comp_id)::text))), g_t0.dsaiom
7. 0.000 0.000 ↓ 0.0

Seq Scan on public.w_order_tu4 g_t0 (cost=0.00..670,494.85 rows=5,704,687 width=31) (actual rows= loops=)

  • Output: g_t0.onbehalf_of_comp_id, g_t0.dsaiom, g_t0.security_id, rtrim(ltrim((g_t0.onbehalf_of_comp_id)::text))
  • Filter: (g_t0.order_type <> 'I'::bpchar)
8. 0.000 0.000 ↓ 0.0

Seq Scan on public.w_ordre_inst_tu4 g_t1 (cost=0.00..36.93 rows=1,893 width=25) (actual rows= loops=)

  • Output: g_t1.dsaiom, g_t1.amr_code, g_t1.cinstbdm, g_t1.ccontrbdm, g_t1.tick_size_denominator, g_t1.trading_unit_id
  • Filter: (g_t1.cinstbdm IS NOT NULL)