explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yCJo

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 0.050 ↓ 3.2 16 1

Seq Scan on items (cost=4.95..20.34 rows=5 width=325) (actual time=0.032..0.050 rows=16 loops=1)

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

CTE user_tour_level

3. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on user_stats (cost=0.00..4.93 rows=1 width=4) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (user_id = 244)
  • Rows Removed by Filter: 233
4.          

Initplan (forSeq Scan)

5. 0.023 0.023 ↑ 1.0 1 1

CTE Scan on user_tour_level (cost=0.00..0.02 rows=1 width=4) (actual time=0.021..0.023 rows=1 loops=1)

Planning time : 0.136 ms
Execution time : 0.080 ms