explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hlXv : Optimization for: plan #kXhr

Settings

Optimization path:

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

Nested Loop (cost=8.99..75.66 rows=10,000 width=248) (actual time=0.022..0.022 rows=0 loops=1)

2. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=8.99..15.66 rows=100 width=212) (actual time=0.022..0.022 rows=0 loops=1)

3. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=8.99..15.06 rows=1 width=340) (actual time=0.022..0.022 rows=0 loops=1)

4. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=8.91..14.92 rows=1 width=325) (actual time=0.022..0.022 rows=0 loops=1)

5. 0.002 0.022 ↓ 0.0 0 1

Bitmap Heap Scan on offer_incentive oi (cost=8.82..10.83 rows=1 width=309) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: (((contact_fk)::text = '0035600000LtwlOAAR'::text) AND ((incentive_id)::text = '000OND'::text))
  • Filter: ((offer_id)::text = '4313DD'::text)
6. 0.000 0.020 ↓ 0.0 0 1

BitmapAnd (cost=8.82..8.82 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

7. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on incentive_offer_contact_fk_uidx (cost=0.00..2.14 rows=39 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((contact_fk)::text = '0035600000LtwlOAAR'::text)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on offer_incentive_incentive_id (cost=0.00..6.63 rows=362 width=0) (never executed)

  • Index Cond: ((incentive_id)::text = '000OND'::text)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using offer_incentive_group_id_idx on offer_incentive_group oig (cost=0.08..4.09 rows=1 width=24) (never executed)

  • Index Cond: (id = oi.incentive_group_fk)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using offer_pkey on offer o (cost=0.08..0.15 rows=1 width=23) (never executed)

  • Index Cond: (id = oig.offer_fk)
11. 0.000 0.000 ↓ 0.0 0

Function Scan on jsonb_each t (cost=0.00..0.30 rows=100 width=32) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Function Scan on jsonb_to_recordset x (cost=0.00..0.30 rows=100 width=68) (never executed)

Planning time : 0.826 ms
Execution time : 0.131 ms