explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NmMD

Settings
# exclusive inclusive rows x rows loops node
1. 0.277 23.835 ↓ 10.0 10 1

Unique (cost=56.30..56.36 rows=1 width=883) (actual time=23.550..23.835 rows=10 loops=1)

2. 22.224 23.558 ↓ 110.0 110 1

Sort (cost=56.30..56.30 rows=1 width=883) (actual time=23.547..23.558 rows=110 loops=1)

  • Sort Key: dishes.id, 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: 81kB
3. 0.116 1.334 ↓ 110.0 110 1

Nested Loop (cost=46.59..56.29 rows=1 width=883) (actual time=0.557..1.334 rows=110 loops=1)

4. 0.072 1.018 ↓ 50.0 50 1

Nested Loop (cost=46.44..56.04 rows=1 width=887) (actual time=0.515..1.018 rows=50 loops=1)

5. 0.176 0.646 ↓ 50.0 50 1

Hash Join (cost=46.02..55.58 rows=1 width=895) (actual time=0.456..0.646 rows=50 loops=1)

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

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

  • Filter: (active AND is_published)
  • Rows Removed by Filter: 95
7. 0.032 0.335 ↑ 1.0 10 1

Hash (cost=45.90..45.90 rows=10 width=887) (actual time=0.335..0.335 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 5kB
8. 0.022 0.303 ↑ 1.0 10 1

Nested Loop (cost=1.00..45.90 rows=10 width=887) (actual time=0.110..0.303 rows=10 loops=1)

9. 0.201 0.201 ↑ 1.0 10 1

Index Scan using dishes_pkey on dishes (cost=0.57..19.30 rows=10 width=883) (actual time=0.065..0.201 rows=10 loops=1)

  • Index Cond: (id = ANY ('{55561755,55561760,55561759,55561758,55561757,55561756,55561764,55561763,55561762,55561761}'::integer[]))
10. 0.080 0.080 ↑ 1.0 1 10

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

  • Index Cond: (id = dishes.group_dish_id)
11. 0.300 0.300 ↑ 1.0 1 50

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.006..0.006 rows=1 loops=50)

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

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.003..0.004 rows=2 loops=50)

  • Index Cond: (industry_id = industries.id)
  • Heap Fetches: 110
Planning time : 11.004 ms
Execution time : 24.401 ms