explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kXhr

Settings

Optimization(s) for this plan:

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

Nested Loop (cost=9.11..19.19 rows=1 width=137) (actual time=0.122..0.122 rows=0 loops=1)

2. 0.001 0.122 ↓ 0.0 0 1

Nested Loop (cost=9.02..19.04 rows=1 width=122) (actual time=0.121..0.122 rows=0 loops=1)

3. 0.003 0.121 ↓ 0.0 0 1

Nested Loop (cost=8.94..14.95 rows=1 width=106) (actual time=0.121..0.121 rows=0 loops=1)

4. 0.078 0.078 ↑ 1.0 1 1

Index Scan using contact_winet_uidx on contact c (cost=0.11..4.12 rows=1 width=19) (actual time=0.077..0.078 rows=1 loops=1)

  • Index Cond: ((winet_id__c)::text = '16704439422'::text)
5. 0.003 0.040 ↓ 0.0 0 1

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

  • Recheck Cond: (((contact_fk)::text = (c.sfid)::text) AND ((incentive_id)::text = '000OND'::text))
  • Filter: ((offer_id)::text = '4313CY'::text)
6. 0.002 0.037 ↓ 0.0 0 1

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

7. 0.035 0.035 ↓ 0.0 0 1

Bitmap Index Scan on incentive_offer_contact_fk_uidx (cost=0.00..2.15 rows=40 width=0) (actual time=0.034..0.035 rows=0 loops=1)

  • Index Cond: ((contact_fk)::text = (c.sfid)::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)
Planning time : 1.612 ms
Execution time : 0.209 ms