explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WWF2 : 11

Settings
# exclusive inclusive rows x rows loops node
1. 34.279 27,920.333 ↑ 1.0 1 1

Aggregate (cost=687,626.95..687,626.96 rows=1 width=0) (actual time=27,920.332..27,920.333 rows=1 loops=1)

2. 27,886.054 27,886.054 ↑ 63.0 210,183 1

Seq Scan on t_traffic_weather_linkroad (cost=0.00..654,519.88 rows=13,242,829 width=0) (actual time=12,926.084..27,886.054 rows=210,183 loops=1)

  • Filter: (status > 0)
  • Rows Removed by Filter: 14984
Planning time : 0.096 ms
Execution time : 27,920.373 ms