explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B1hNr

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 2.846 ↑ 1.0 1 1

Unique (cost=15.73..15.79 rows=1 width=883) (actual time=2.814..2.846 rows=1 loops=1)

2. 2.515 2.811 ↓ 11.0 11 1

Sort (cost=15.73..15.74 rows=1 width=883) (actual time=2.811..2.811 rows=11 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
  • Sort Method: quicksort Memory: 30kB
3. 0.005 0.296 ↓ 11.0 11 1

Nested Loop (cost=6.02..15.72 rows=1 width=883) (actual time=0.136..0.296 rows=11 loops=1)

4. 0.009 0.261 ↓ 5.0 5 1

Nested Loop (cost=5.88..15.47 rows=1 width=887) (actual time=0.124..0.261 rows=5 loops=1)

5. 0.039 0.207 ↓ 5.0 5 1

Hash Join (cost=5.46..15.02 rows=1 width=895) (actual time=0.099..0.207 rows=5 loops=1)

  • Hash Cond: (industries.eatery_id = group_dishes.eatery_id)
6. 0.104 0.104 ↓ 1.0 117 1

Seq Scan on industries (cost=0.00..9.12 rows=115 width=8) (actual time=0.011..0.104 rows=117 loops=1)

  • Filter: (active AND is_published)
  • Rows Removed by Filter: 95
7. 0.007 0.064 ↑ 1.0 1 1

Hash (cost=5.44..5.44 rows=1 width=887) (actual time=0.064..0.064 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
8. 0.005 0.057 ↑ 1.0 1 1

Nested Loop (cost=0.99..5.44 rows=1 width=887) (actual time=0.055..0.057 rows=1 loops=1)

9. 0.033 0.033 ↑ 1.0 1 1

Index Scan using dishes_pkey on dishes (cost=0.56..2.78 rows=1 width=883) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: (id = 55,561,764)
10. 0.019 0.019 ↑ 1.0 1 1

Index Scan using group_dishes_pkey on group_dishes (cost=0.43..2.65 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (id = dishes.group_dish_id)
11. 0.045 0.045 ↑ 1.0 1 5

Index Scan using eatery_shipping_fees_eatery_id_unique_idx on eatery_shipping_fees (cost=0.42..0.44 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=5)

  • Index Cond: (eatery_id = group_dishes.eatery_id)
  • Filter: (active AND is_published)
12. 0.030 0.030 ↑ 1.5 2 5

Index Only Scan using eatery_supply_menus_industry_id_idx on eatery_supply_menus (cost=0.14..0.22 rows=3 width=4) (actual time=0.004..0.006 rows=2 loops=5)

  • Index Cond: (industry_id = industries.id)
  • Heap Fetches: 11
Planning time : 2.710 ms
Execution time : 3.087 ms