explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RlHU

Settings
# exclusive inclusive rows x rows loops node
1. 611.254 12,467.075 ↑ 14.9 2,294 1

GroupAggregate (cost=735,695.92..769,802.14 rows=34,200 width=36) (actual time=9,646.731..12,467.075 rows=2,294 loops=1)

  • Group Key: day_str, region_id, operator
2. 9,925.283 11,855.821 ↑ 1.0 2,694,298 1

Sort (cost=735,695.92..742,431.66 rows=2,694,298 width=36) (actual time=9,646.715..11,855.821 rows=2,694,298 loops=1)

  • Sort Key: day_str, region_id, operator
  • Sort Method: external merge Disk: 131072kB
3. 1,930.538 1,930.538 ↑ 1.0 2,694,298 1

Seq Scan on streaming_trips2 (cost=0.00..300,574.98 rows=2,694,298 width=36) (actual time=0.305..1,930.538 rows=2,694,298 loops=1)