explain.depesz.com

PostgreSQL's explain analyze made readable

Result: abFx

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

CTE Scan on possible_items (cost=15.75..15.95 rows=10 width=325) (actual time=0.013..0.074 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.009..0.031 rows=30 loops=1)

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