explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a2D : PG9.5-CountWithFilter

Settings
# exclusive inclusive rows x rows loops node
1. 23.150 399.957 ↑ 1.0 1 1

Aggregate (cost=75,373.63..75,373.64 rows=1 width=0) (actual time=399.956..399.957 rows=1 loops=1)

2. 376.807 376.807 ↑ 1.0 60,291 1

Seq Scan on daily (cost=0.00..75,221.39 rows=60,898 width=0) (actual time=0.103..376.807 rows=60,291 loops=1)

  • Filter: (t_min < 0)
  • Rows Removed by Filter: 3844620
Planning time : 0.058 ms
Execution time : 399.987 ms