explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4s5y

Settings
# exclusive inclusive rows x rows loops node
1. 615.774 13,208.410 ↑ 14.8 2,294 1

GroupAggregate (cost=666,492.03..695,738.20 rows=33,930 width=36) (actual time=10,329.723..13,208.410 rows=2,294 loops=1)

  • Group Key: day_str, region_id, operator
2. 10,656.222 12,592.636 ↓ 1.2 2,694,298 1

Sort (cost=666,492.03..672,256.44 rows=2,305,763 width=36) (actual time=10,329.699..12,592.636 rows=2,694,298 loops=1)

  • Sort Key: day_str, region_id, operator
  • Sort Method: external merge Disk: 131072kB
3. 1,936.414 1,936.414 ↓ 1.2 2,694,298 1

Seq Scan on streaming_trips (cost=0.00..296,711.63 rows=2,305,763 width=36) (actual time=0.955..1,936.414 rows=2,694,298 loops=1)