explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X1Oc

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

Nested Loop Left Join (cost=30.34..111.92 rows=7 width=200) (actual rows= loops=)

  • Join Filter: (merchant_promotion.category_id = merchant_promotion_category.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=30.34..109.74 rows=7 width=159) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on merchant_promotion (cost=30.07..55.61 rows=7 width=120) (actual rows= loops=)

  • Recheck Cond: (id = ANY ('{1,2,3,4,5,6,7}'::integer[]))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on merchant_promotion_pkey (cost=0.00..30.06 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (id = ANY ('{1,2,3,4,5,6,7}'::integer[]))
5. 0.000 0.000 ↓ 0.0

Index Scan using daypart_mp_index on merchant_promotion_daypart_constraint (cost=0.28..7.72 rows=1 width=39) (actual rows= loops=)

  • Index Cond: (merchant_promotion.id = merchant_promotion_id)
6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.15 rows=10 width=41) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on merchant_promotion_category (cost=0.00..1.10 rows=10 width=41) (actual rows= loops=)