explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9wSb

Settings
# exclusive inclusive rows x rows loops node
1. 0.328 15,549.974 ↑ 3,138.4 554 1

Sort (cost=551,745.49..556,092.16 rows=1,738,666 width=88) (actual time=15,549.933..15,549.974 rows=554 loops=1)

  • Sort Key: s1.bucket
  • Sort Method: quicksort Memory: 102kB
2. 1.141 15,549.646 ↑ 3,138.4 554 1

Subquery Scan on s1 (cost=301,990.04..371,536.68 rows=1,738,666 width=88) (actual time=15,539.122..15,549.646 rows=554 loops=1)

3. 12,192.202 15,548.505 ↑ 3,138.4 554 1

HashAggregate (cost=301,990.04..345,456.69 rows=1,738,666 width=48) (actual time=15,539.101..15,548.505 rows=554 loops=1)

  • Group Key: time_bucket('7 days'::interval, tilt_data.read_time)
4. 3,356.303 3,356.303 ↓ 3.0 6,019,715 1

Index Scan using new_data_station_idx on tilt_data (cost=0.56..246,678.71 rows=2,011,321 width=38) (actual time=0.062..3,356.303 rows=6,019,715 loops=1)

  • Index Cond: (station = 'c08883c0-fbe5-11e9-bd6e-aec49259cebb'::uuid)
  • Filter: ((read_time)::date <= '2020-01-13'::date)