explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F8lX

Settings
# exclusive inclusive rows x rows loops node
1. 41.253 152.364 ↓ 2.0 5,266 1

Seq Scan on g_challenge chall (cost=0.00..48,139.62 rows=2,645 width=3,932) (actual time=0.088..152.364 rows=5,266 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 25
2.          

SubPlan (forSeq Scan)

3. 111.111 111.111 ↑ 1,000.0 1 5,291

Function Scan on generate_series alldays (cost=0.00..15.00 rows=1,000 width=1) (actual time=0.021..0.021 rows=1 loops=5,291)

Planning time : 0.429 ms
Execution time : 160.681 ms