explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JFq

Settings
# exclusive inclusive rows x rows loops node
1. 6.788 7.331 ↑ 1,164.0 1 1

Gather (cost=3,256.53..108,904.74 rows=1,164 width=186) (actual time=1.945..7.331 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.018 0.543 ↓ 0.0 0 3 / 3

Nested Loop (cost=2,256.53..107,781.55 rows=485 width=186) (actual time=0.543..0.543 rows=0 loops=3)

3. 0.001 0.522 ↓ 0.0 0 3 / 3

Nested Loop (cost=2,256.10..106,790.91 rows=485 width=844) (actual time=0.521..0.522 rows=0 loops=3)

4. 0.001 0.516 ↓ 0.0 0 3 / 3

Nested Loop (cost=2,255.67..105,980.28 rows=1,455 width=819) (actual time=0.515..0.516 rows=0 loops=3)

5. 0.077 0.510 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on instrument_master_record ir (cost=2,255.23..57,520.78 rows=6,195 width=818) (actual time=0.510..0.510 rows=0 loops=3)

  • Recheck Cond: (record @> '{"ID_ISIN": "KR6213501820"}'::jsonb)
  • Heap Blocks: exact=1
6. 0.433 0.433 ↑ 14,868.0 1 1 / 3

Bitmap Index Scan on gix_instrumentmasterrecord_record (cost=0.00..2,251.51 rows=14,868 width=0) (actual time=1.298..1.298 rows=1 loops=1)

  • Index Cond: (record @> '{"ID_ISIN": "KR6213501820"}'::jsonb)
7. 0.005 0.005 ↑ 1.0 1 1 / 3

Index Scan using ix_instrumentmastermeta_id on instrument_master_meta i (cost=0.43..7.81 rows=1 width=17) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (id = ir.id)
  • Filter: (('2020-04-12'::date >= start_date) AND ('2020-04-12'::date <= COALESCE(end_date, '3999-12-31'::date)))
8. 0.005 0.005 ↑ 1.0 1 1 / 3

Index Scan using ix_marketmastermeta_idbplinstrument on market_master_meta m (cost=0.43..0.55 rows=1 width=34) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((id_bpl_instrument)::text = (i.id_bpl_instrument)::text)
  • Filter: (('2020-04-12'::date >= start_date) AND ('2020-04-12'::date <= COALESCE(end_date, '3999-12-31'::date)))
9. 0.003 0.003 ↑ 1.0 1 1 / 3

Index Scan using pk_marketmasterrecord_id on market_master_record mr (cost=0.43..2.03 rows=1 width=743) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (id = m.id)
Planning time : 0.811 ms
Execution time : 7.385 ms