explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k94S

Settings
# exclusive inclusive rows x rows loops node
1. 850.881 2,557.959 ↑ 5.0 2 3

Parallel Hash Join (cost=74,961.58..150,466.44 rows=10 width=152) (actual time=699.960..852.653 rows=2 loops=3)

  • Hash Cond: (i.menu_item_id = mi.menu_item_id)
2. 730.725 730.725 ↑ 1.2 724,723 3

Parallel Seq Scan on items i (cost=0.00..73,126.90 rows=905,890 width=80) (actual time=0.005..243.575 rows=724,723 loops=3)

3. 0.180 976.353 ↑ 5.0 2 3

Parallel Hash (cost=74,961.45..74,961.45 rows=10 width=146) (actual time=325.451..325.451 rows=2 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 72kB
4. 976.173 976.173 ↑ 5.0 2 3

Parallel Seq Scan on menu_items mi (cost=0.00..74,961.45 rows=10 width=146) (actual time=280.309..325.391 rows=2 loops=3)

  • Filter: (menu_category_id = 'ba135de9-3e96-4eee-8482-7183cef94628'::text)
  • Rows Removed by Filter: 733,467
Planning time : 0.210 ms
Execution time : 859.274 ms