explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hD0L

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 4.472 ↑ 2.5 2 1

Sort (cost=486.22..486.23 rows=5 width=65) (actual time=4.472..4.472 rows=2 loops=1)

  • Sort Key: (CASE WHEN COALESCE(group_dishes.is_extra_group_dish, false) THEN 1 ELSE 0 END), group_dishes."order", group_dishes.name
  • Sort Method: quicksort Memory: 25kB
2. 0.005 4.453 ↑ 2.5 2 1

Nested Loop (cost=438.62..486.16 rows=5 width=65) (actual time=4.450..4.453 rows=2 loops=1)

3. 0.030 0.030 ↑ 1.0 1 1

Index Scan using eatery_shipping_fees_eatery_id_unique_idx on eatery_shipping_fees (cost=0.28..8.30 rows=1 width=4) (actual time=0.028..0.030 rows=1 loops=1)

  • Index Cond: (eatery_id = 1346382)
  • Filter: (active AND (NOT closed) AND (city_id = 50))
4. 0.011 4.418 ↑ 2.5 2 1

Hash Join (cost=438.34..477.81 rows=5 width=65) (actual time=4.417..4.418 rows=2 loops=1)

  • Hash Cond: (eatery_supply_menus.group_dish_id = group_dishes.id)
5. 0.005 0.005 ↑ 356.7 6 1

Seq Scan on eatery_supply_menus (cost=0.00..31.40 rows=2,140 width=4) (actual time=0.004..0.005 rows=6 loops=1)

6. 0.005 4.402 ↑ 9.0 4 1

Hash (cost=437.89..437.89 rows=36 width=65) (actual time=4.402..4.402 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 4.397 4.397 ↑ 9.0 4 1

Seq Scan on group_dishes (cost=0.00..437.89 rows=36 width=65) (actual time=4.295..4.397 rows=4 loops=1)

  • Filter: (active AND is_published AND (eatery_id = 1346382))
  • Rows Removed by Filter: 16484