explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NIm4

Settings
# exclusive inclusive rows x rows loops node
1. 34.665 97.904 ↑ 1.0 1 1

Aggregate (cost=54,990.82..54,990.83 rows=1 width=0) (actual time=97.904..97.904 rows=1 loops=1)

2. 63.239 63.239 ↑ 1.0 210,183 1

Index Only Scan using t_traffic_weather_linkroad_index on t_traffic_weather_linkroad (cost=0.42..54,465.02 rows=210,320 width=0) (actual time=0.055..63.239 rows=210,183 loops=1)

  • Index Cond: (status = 1)
  • Heap Fetches: 0
Planning time : 0.069 ms
Execution time : 97.937 ms