explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 55t67

Settings
# exclusive inclusive rows x rows loops node
1. 6.995 7.569 ↑ 3,763.0 1 1

Gather (cost=3,256.53..109,732.58 rows=3,763 width=160) (actual time=2.039..7.569 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.019 0.574 ↓ 0.0 0 3 / 3

Nested Loop (cost=2,256.53..108,334.33 rows=1,568 width=160) (actual time=0.574..0.574 rows=0 loops=3)

3. 0.001 0.551 ↓ 0.0 0 3 / 3

Nested Loop (cost=2,256.10..106,825.98 rows=1,619 width=818) (actual time=0.551..0.551 rows=0 loops=3)

4. 0.001 0.543 ↓ 0.0 0 3 / 3

Nested Loop (cost=2,255.67..106,011.25 rows=1,455 width=819) (actual time=0.543..0.543 rows=0 loops=3)

5. 0.081 0.538 ↓ 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.538..0.538 rows=0 loops=3)

  • Recheck Cond: (record @> '{"ID_CUSIP_NOT_VALIDATED": "AO0994183"}'::jsonb)
  • Heap Blocks: exact=1
6. 0.457 0.457 ↑ 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.370..1.370 rows=1 loops=1)

  • Index Cond: (record @> '{"ID_CUSIP_NOT_VALIDATED": "AO0994183"}'::jsonb)
7. 0.004 0.004 ↑ 1.0 1 1 / 3

Index Scan using ix_instrumentmastermeta_id on instrument_master_meta i (cost=0.43..7.82 rows=1 width=17) (actual time=0.011..0.011 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)) AND ('2020-04-12'::date >= start_date) AND ('2020-04-12'::date <= COALESCE(end_date, '3999-12-31'::date)))
8. 0.007 0.007 ↑ 1.0 1 1 / 3

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

  • Index Cond: ((id_bpl_instrument)::text = (i.id_bpl_instrument)::text)
9. 0.004 0.004 ↑ 1.0 1 1 / 3

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

  • Index Cond: (id = m.id)
Planning time : 0.911 ms
Execution time : 7.624 ms