explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 092O

Settings
# exclusive inclusive rows x rows loops node
1. 547.332 627.899 ↓ 0.0 0 1

Update on menu_items (cost=14.12..867.77 rows=218 width=183) (actual time=627.899..627.899 rows=0 loops=1)

2. 62.272 80.567 ↑ 7.8 28 1

Bitmap Heap Scan on menu_items (cost=14.12..867.77 rows=218 width=183) (actual time=25.944..80.567 rows=28 loops=1)

  • Recheck Cond: (restaurant_id = '2bc4d2a4-34c1-4e72-8764-9b76184228dd'::uuid)
  • Heap Blocks: exact=10
3. 18.295 18.295 ↑ 7.8 28 1

Bitmap Index Scan on index_menu_items_on_restaurant_id (cost=0.00..14.07 rows=218 width=0) (actual time=18.295..18.295 rows=28 loops=1)

  • Index Cond: (restaurant_id = '2bc4d2a4-34c1-4e72-8764-9b76184228dd'::uuid)