explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XQD1 : Optimization for: plan #8GK6

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 64,106.830 ↑ 1.0 1 1

Limit (cost=1,326,213.64..1,326,213.65 rows=1 width=8) (actual time=64,106.829..64,106.830 rows=1 loops=1)

2. 1,653.024 64,106.827 ↑ 1.0 1 1

HashAggregate (cost=1,326,213.64..1,326,213.65 rows=1 width=8) (actual time=64,106.827..64,106.827 rows=1 loops=1)

  • Group Key: "timestamp
3. 62,453.803 62,453.803 ↑ 1.0 5,004,576 1

Seq Scan on event (cost=0.00..1,301,190.76 rows=5,004,576 width=8) (actual time=0.007..62,453.803 rows=5,004,576 loops=1)