explain.depesz.com

PostgreSQL's explain analyze made readable

Result: URqi

Settings
# exclusive inclusive rows x rows loops node
1. 0.700 111.279 ↓ 11.0 11 1

Unique (cost=60.70..60.76 rows=1 width=883) (actual time=110.542..111.279 rows=11 loops=1)

2. 107.275 110.579 ↓ 297.0 297 1

Sort (cost=60.70..60.71 rows=1 width=883) (actual time=110.531..110.579 rows=297 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: 191kB
3. 0.353 3.304 ↓ 297.0 297 1

Nested Loop (cost=50.99..60.69 rows=1 width=883) (actual time=0.839..3.304 rows=297 loops=1)

4. 0.134 2.247 ↓ 88.0 88 1

Nested Loop (cost=50.84..60.44 rows=1 width=887) (actual time=0.817..2.247 rows=88 loops=1)

5. 0.271 1.145 ↓ 88.0 88 1

Hash Join (cost=50.42..59.98 rows=1 width=895) (actual time=0.734..1.145 rows=88 loops=1)

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

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

  • Filter: (active AND is_published)
  • Rows Removed by Filter: 95
7. 0.052 0.653 ↑ 1.0 11 1

Hash (cost=50.29..50.29 rows=11 width=887) (actual time=0.653..0.653 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 6kB
8. 0.042 0.601 ↑ 1.0 11 1

Nested Loop (cost=1.01..50.29 rows=11 width=887) (actual time=0.186..0.601 rows=11 loops=1)

9. 0.405 0.405 ↑ 1.0 11 1

Index Scan using dishes_pkey on dishes (cost=0.58..21.03 rows=11 width=883) (actual time=0.130..0.405 rows=11 loops=1)

  • Index Cond: (id = ANY ('{36949362,36949363,36949361,36949364,36949377,36949376,36949443,36949444,55305968,36949449,36949487}'::integer[]))
10. 0.154 0.154 ↑ 1.0 1 11

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

  • Index Cond: (id = dishes.group_dish_id)
11. 0.968 0.968 ↑ 1.0 1 88

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.010..0.011 rows=1 loops=88)

  • Index Cond: (eatery_id = group_dishes.eatery_id)
  • Filter: (active AND is_published)
12. 0.704 0.704 ↑ 1.0 3 88

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.005..0.008 rows=3 loops=88)

  • Index Cond: (industry_id = industries.id)
  • Heap Fetches: 297
Planning time : 5.509 ms
Execution time : 111.755 ms