explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rKwB

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.746 ↓ 0.0 0 1

Unique (cost=153.92..153.98 rows=1 width=256) (actual time=1.746..1.746 rows=0 loops=1)

2. 0.024 1.745 ↓ 0.0 0 1

Sort (cost=153.92..153.93 rows=1 width=256) (actual time=1.745..1.745 rows=0 loops=1)

  • Sort Key: dishes.name, dishes.price, dishes.group_dish_id, dishes.created_by, dishes.created_at, dishes.updated_at, dishes.image, dishes.updated_by, dishes.order_count, dishes.description, dishes.active, dishes.additional_fee, dishes.block_id, dishes.block_phone_number, dishes.deleted_at, dishes.block_country_code, dishes.name_ts, dishes.unit, dishes.unit_quantity, dishes.is_losupply
  • Sort Method: quicksort Memory: 25kB
3. 0.203 1.721 ↓ 0.0 0 1

Hash Join (cost=31.20..153.91 rows=1 width=256) (actual time=1.721..1.721 rows=0 loops=1)

  • Hash Cond: (eatery_shipping_fees.eatery_id = group_dishes.eatery_id)
4. 1.142 1.142 ↑ 1.0 1,958 1

Seq Scan on eatery_shipping_fees (cost=0.00..115.24 rows=1,990 width=4) (actual time=0.010..1.142 rows=1,958 loops=1)

  • Filter: (active AND is_published)
  • Rows Removed by Filter: 2,466
5. 0.002 0.376 ↑ 1.0 1 1

Hash (cost=31.19..31.19 rows=1 width=264) (actual time=0.376..0.376 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
6. 0.044 0.374 ↑ 1.0 1 1

Hash Join (cost=24.83..31.19 rows=1 width=264) (actual time=0.299..0.374 rows=1 loops=1)

  • Hash Cond: (eatery_supply_menus.industry_id = industries.id)
7. 0.052 0.052 ↓ 1.0 327 1

Seq Scan on eatery_supply_menus (cost=0.00..5.16 rows=316 width=4) (actual time=0.008..0.052 rows=327 loops=1)

8. 0.003 0.278 ↓ 2.0 2 1

Hash (cost=24.82..24.82 rows=1 width=268) (actual time=0.278..0.278 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
9. 0.026 0.275 ↓ 2.0 2 1

Hash Join (cost=16.77..24.82 rows=1 width=268) (actual time=0.215..0.275 rows=2 loops=1)

  • Hash Cond: (industries.eatery_id = group_dishes.eatery_id)
10. 0.056 0.056 ↓ 1.2 136 1

Seq Scan on industries (cost=0.00..7.60 rows=118 width=8) (actual time=0.005..0.056 rows=136 loops=1)

  • Filter: (active AND is_published)
  • Rows Removed by Filter: 125
11. 0.005 0.193 ↑ 1.0 1 1

Hash (cost=16.76..16.76 rows=1 width=260) (actual time=0.193..0.193 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
12. 0.005 0.188 ↑ 1.0 1 1

Nested Loop (cost=0.71..16.76 rows=1 width=260) (actual time=0.187..0.188 rows=1 loops=1)

13. 0.161 0.161 ↑ 1.0 1 1

Index Scan using dishes_pkey on dishes (cost=0.42..8.44 rows=1 width=256) (actual time=0.160..0.161 rows=1 loops=1)

  • Index Cond: (id = 169,800)
14. 0.022 0.022 ↑ 1.0 1 1

Index Scan using group_dishes_pkey on group_dishes (cost=0.29..8.31 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (id = dishes.group_dish_id)
Planning time : 1.517 ms
Execution time : 1.900 ms