explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x58

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 0.047 ↓ 1.6 16 1

Seq Scan on items (cost=4.93..20.68 rows=10 width=325) (actual time=0.028..0.047 rows=16 loops=1)

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

Initplan (forSeq Scan)

3. 0.018 0.018 ↑ 1.0 1 1

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

  • Filter: (user_id = 244)
  • Rows Removed by Filter: 233
Planning time : 0.112 ms
Execution time : 0.073 ms