explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PLrQ

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

Aggregate (cost=276.18..276.19 rows=1 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=248.97..276.18 rows=2 width=0) (never executed)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on eatery_promotions eatery_promotions (cost=5.45..32.36 rows=74 width=4) (never executed)

  • Filter: (deleted_at IS NULL)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on eatery_promotion_eatery_id_idx (cost=0..5.43 rows=153 width=0) (never executed)

  • Index Cond: (eatery_id = 557,700)
5. 0.000 0.000 ↓ 0.0

Hash (cost=241.36..241.36 rows=173 width=4) (never executed)

6. 0.000 0.000 ↓ 0.0

Seq Scan on promotions promotions (cost=0..241.36 rows=173 width=4) (never executed)

  • Filter: ((deleted_at IS NULL) AND eatery_only AND active AND is_merchant_visible)