explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dZu4

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 15.019 ↑ 385.5 4 1

Sort (cost=846.95..850.81 rows=1,542 width=65) (actual time=15.019..15.019 rows=4 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.017 14.982 ↑ 385.5 4 1

Hash Join (cost=665.78..765.30 rows=1,542 width=65) (actual time=14.969..14.982 rows=4 loops=1)

  • Hash Cond: (group_dishes.eatery_id = eatery_shipping_fees.eatery_id)
3. 0.042 12.461 ↑ 477.0 4 1

Hash Join (cost=580.32..654.88 rows=1,908 width=65) (actual time=12.452..12.461 rows=4 loops=1)

  • Hash Cond: (eatery_supply_menus.group_dish_id = group_dishes.id)
4. 0.008 0.008 ↑ 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.008 rows=6 loops=1)

5. 4.457 12.411 ↑ 1.0 14,670 1

Hash (cost=396.71..396.71 rows=14,689 width=65) (actual time=12.411..12.411 rows=14,670 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1397kB
6. 7.954 7.954 ↑ 1.0 14,670 1

Seq Scan on group_dishes (cost=0.00..396.71 rows=14,689 width=65) (actual time=0.009..7.954 rows=14,670 loops=1)

  • Filter: (active AND is_published)
  • Rows Removed by Filter: 1818
7. 0.662 2.504 ↓ 1.0 1,930 1

Hash (cost=61.50..61.50 rows=1,917 width=4) (actual time=2.504..2.504 rows=1,930 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
8. 1.842 1.842 ↓ 1.0 1,930 1

Seq Scan on eatery_shipping_fees (cost=0.00..61.50 rows=1,917 width=4) (actual time=0.019..1.842 rows=1,930 loops=1)

  • Filter: (active AND (NOT closed) AND (city_id = 50))
  • Rows Removed by Filter: 191