explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cjDg

Settings
# exclusive inclusive rows x rows loops node
1. 3.413 17,468.076 ↑ 3,138.5 554 1

Subquery Scan on s1 (cost=457,289.46..587,182.95 rows=1,738,755 width=88) (actual time=5,283.699..17,468.076 rows=554 loops=1)

2. 11,773.470 17,464.663 ↑ 3,138.5 554 1

GroupAggregate (cost=457,289.46..561,101.63 rows=1,738,755 width=48) (actual time=5,283.673..17,464.663 rows=554 loops=1)

  • Group Key: (time_bucket('7 days'::interval, tilt_data.read_time))
3. 2,330.293 5,691.193 ↓ 3.0 6,023,315 1

Sort (cost=457,289.46..462,318.07 rows=2,011,443 width=38) (actual time=5,269.481..5,691.193 rows=6,023,315 loops=1)

  • Sort Key: (time_bucket('7 days'::interval, tilt_data.read_time))
  • Sort Method: quicksort Memory: 667180kB
4. 3,360.900 3,360.900 ↓ 3.0 6,023,315 1

Index Scan using new_data_station_idx on tilt_data (cost=0.56..246,693.40 rows=2,011,443 width=38) (actual time=0.046..3,360.900 rows=6,023,315 loops=1)

  • Index Cond: (station = 'c08883c0-fbe5-11e9-bd6e-aec49259cebb'::uuid)
  • Filter: ((read_time)::date <= '2020-01-13'::date)
Planning time : 0.262 ms
Execution time : 17,497.332 ms