explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w81K

Settings
# exclusive inclusive rows x rows loops node
1. 613.217 14,730.175 ↑ 14.8 2,294 1

GroupAggregate (cost=666,492.03..695,738.20 rows=33,930 width=36) (actual time=11,728.969..14,730.175 rows=2,294 loops=1)

  • Group Key: day_str, region_id, operator
2. 11,169.377 14,116.958 ↓ 1.2 2,694,298 1

Sort (cost=666,492.03..672,256.44 rows=2,305,763 width=36) (actual time=11,728.951..14,116.958 rows=2,694,298 loops=1)

  • Sort Key: day_str, region_id, operator
  • Sort Method: external merge Disk: 131072kB
3. 2,947.581 2,947.581 ↓ 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.725..2,947.581 rows=2,694,298 loops=1)