explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dmTe

Settings
# exclusive inclusive rows x rows loops node
1. 44.353 171.337 ↑ 1.7 1,576 1

Seq Scan on g_challenge chall (cost=0.00..48,139.62 rows=2,645 width=3,932) (actual time=0.090..171.337 rows=1,576 loops=1)

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

SubPlan (for Seq Scan)

3. 126.984 126.984 ↑ 500.0 2 5,291

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

Planning time : 0.418 ms
Execution time : 173.866 ms