explain.depesz.com

PostgreSQL's explain analyze made readable

Result: owxu

Settings
# exclusive inclusive rows x rows loops node
1. 0.395 14,631.410 ↑ 7,138.6 554 1

Sort (cost=999,093.07..1,008,979.98 rows=3,954,764 width=88) (actual time=14,631.363..14,631.410 rows=554 loops=1)

  • Sort Key: s1.bucket
  • Sort Method: quicksort Memory: 102kB
2. 1.353 14,631.015 ↑ 7,138.6 554 1

Subquery Scan on s1 (cost=407,556.07..565,746.63 rows=3,954,764 width=88) (actual time=14,593.714..14,631.015 rows=554 loops=1)

3. 12,147.532 14,629.662 ↑ 7,138.6 554 1

HashAggregate (cost=407,556.07..506,425.17 rows=3,954,764 width=48) (actual time=14,593.691..14,629.662 rows=554 loops=1)

  • Group Key: time_bucket('7 days'::interval, tilt_data.read_time)
4. 2,482.130 2,482.130 ↑ 1.0 6,023,315 1

Index Scan using new_data_station_idx on tilt_data (cost=0.56..241,647.67 rows=6,033,033 width=38) (actual time=0.095..2,482.130 rows=6,023,315 loops=1)

  • Index Cond: (station = 'c08883c0-fbe5-11e9-bd6e-aec49259cebb'::uuid)
  • Filter: (read_time <= '2020-01-13 14:59:59.999-09'::timestamp with time zone)