explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oumA

Settings
# exclusive inclusive rows x rows loops node
1. 0.069 0.069 ↓ 3.0 30 1

CTE Scan on possible_items (cost=15.75..15.95 rows=10 width=325) (actual time=0.011..0.069 rows=30 loops=1)

2.          

CTE possible_items

3. 0.031 0.031 ↓ 3.0 30 1

Seq Scan on items (cost=0.00..15.75 rows=10 width=325) (actual time=0.008..0.031 rows=30 loops=1)

  • Filter: ((deleted IS NOT TRUE) AND (tour_level <= tour_level))
  • Rows Removed by Filter: 2