explain.depesz.com

PostgreSQL's explain analyze made readable

Result: efoh

Settings
# exclusive inclusive rows x rows loops node
1. 5.013 44,363.447 ↑ 1.0 1 1

HashAggregate (cost=2,827,009.12..2,827,009.13 rows=1 width=8) (actual time=44,363.447..44,363.447 rows=1 loops=1)

  • Group Key: status
2. 44,358.434 44,358.434 ↑ 1.0 28,455 1

Seq Scan on request (cost=0.00..2,826,865.50 rows=28,725 width=8) (actual time=27,475.910..44,358.434 rows=28,455 loops=1)

  • Filter: ((start_time >= '2020-09-07 23:00:00'::timestamp without time zone) AND (start_time <= '2020-09-08 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,558,413
Planning time : 0.189 ms
Execution time : 44,363.550 ms