explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LLxT

Settings
# exclusive inclusive rows x rows loops node
1. 0.200 5.590 ↓ 15.0 15 1

Nested Loop (cost=2,193.44..2,297.26 rows=1 width=105) (actual time=3.125..5.590 rows=15 loops=1)

2. 0.018 5.300 ↓ 15.0 15 1

Nested Loop (cost=2,193.01..2,295.37 rows=1 width=827) (actual time=3.095..5.300 rows=15 loops=1)

3. 0.013 5.087 ↓ 15.0 15 1

Nested Loop (cost=2,192.58..2,294.81 rows=1 width=819) (actual time=3.073..5.087 rows=15 loops=1)

4. 2.078 4.959 ↓ 4.6 23 1

Bitmap Heap Scan on instrument_master_record ir (cost=2,192.15..2,252.47 rows=5 width=818) (actual time=2.992..4.959 rows=23 loops=1)

  • Recheck Cond: ((record @> '{"TICKER": "SERBGB"}'::jsonb) AND (record @> '{"CRNCY": "RSD"}'::jsonb))
  • Filter: (((record ->> 'CPN_TYP'::text) <> 'FLOATING'::text) AND (((record ->> 'MATURITY'::text))::date >= '2021-04-24 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=35
5. 2.881 2.881 ↓ 2.3 35 1

Bitmap Index Scan on gix_instrumentmasterrecord_record (cost=0.00..2,192.15 rows=15 width=0) (actual time=2.881..2.881 rows=35 loops=1)

  • Index Cond: ((record @> '{"TICKER": "SERBGB"}'::jsonb) AND (record @> '{"CRNCY": "RSD"}'::jsonb))
6. 0.115 0.115 ↑ 1.0 1 23

Index Scan using ix_instrumentmastermeta_id on instrument_master_meta i (cost=0.43..8.46 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=23)

  • Index Cond: (id = ir.id)
  • Filter: (('2020-04-12'::date >= start_date) AND ('2020-04-12'::date <= COALESCE(end_date, '3999-12-31'::date)))
  • Rows Removed by Filter: 0
7. 0.195 0.195 ↑ 1.0 1 15

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

  • 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)))
  • Rows Removed by Filter: 1
8. 0.090 0.090 ↑ 1.0 1 15

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

  • Index Cond: (id = m.id)
  • Filter: ((record ->> 'TRADE_STATUS'::text) = 'true'::text)
Planning time : 0.946 ms
Execution time : 5.647 ms