explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5KX1

Settings
# exclusive inclusive rows x rows loops node
1. 2,595.837 5,101.336 ↓ 1.4 444 1

HashAggregate (cost=11,701.75..11,704.92 rows=317 width=16) (actual time=5,097.499..5,101.336 rows=444 loops=1)

  • Group Key: machine_id
2. 2,505.499 2,505.499 ↑ 1.2 291,933 1

Seq Scan on cq_occurrence_history foreve (cost=0.00..9,977.17 rows=344,917 width=16) (actual time=0.015..2,505.499 rows=291,933 loops=1)