explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OxC0

Settings
# exclusive inclusive rows x rows loops node
1. 1,677.241 1,936.649 ↓ 0.0 0 1

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

2. 218.212 259.408 ↑ 2.0 110 1

Bitmap Heap Scan on menu_items (cost=14.12..867.77 rows=218 width=183) (actual time=54.172..259.408 rows=110 loops=1)

  • Recheck Cond: (restaurant_id = '02032f8c-3377-4d3a-9401-df3ea832e16c'::uuid)
  • Heap Blocks: exact=61
3. 41.196 41.196 ↑ 2.0 110 1

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

  • Index Cond: (restaurant_id = '02032f8c-3377-4d3a-9401-df3ea832e16c'::uuid)