explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uKl6

Settings
# exclusive inclusive rows x rows loops node
1. 714.590 14,472.666 ↑ 14.7 2,294 1

GroupAggregate (cost=685,029.92..715,577.37 rows=33,750 width=36) (actual time=10,735.896..14,472.666 rows=2,294 loops=1)

  • Group Key: day_str, region_id, operator
2. 11,580.995 13,758.076 ↓ 1.1 2,694,298 1

Sort (cost=685,029.92..691,055.03 rows=2,410,046 width=36) (actual time=10,735.869..13,758.076 rows=2,694,298 loops=1)

  • Sort Key: day_str, region_id, operator
  • Sort Method: external merge Disk: 131080kB
3. 2,177.081 2,177.081 ↓ 1.1 2,694,298 1

Seq Scan on streaming_trips (cost=0.00..297,754.46 rows=2,410,046 width=36) (actual time=0.027..2,177.081 rows=2,694,298 loops=1)