explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rX3m

Settings
# exclusive inclusive rows x rows loops node
1. 2.882 5,568.844 ↑ 3,140.8 554 1

Subquery Scan on s1 (cost=245,338.91..498,395.98 rows=1,740,004 width=88) (actual time=1,766.738..5,568.844 rows=554 loops=1)

2. 2.124 5,565.962 ↑ 3,140.8 554 1

Finalize GroupAggregate (cost=245,338.91..472,295.92 rows=1,740,004 width=48) (actual time=1,766.713..5,565.962 rows=554 loops=1)

  • Group Key: (time_bucket('7 days'::interval, tilt_data.read_time))
3. 759.786 5,563.838 ↑ 879.6 2,215 1

Gather Merge (cost=245,338.91..399,572.60 rows=1,948,215 width=168) (actual time=1,760.454..5,563.838 rows=2,215 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 2,969.324 4,804.052 ↑ 1,172.2 554 4 / 4

Partial GroupAggregate (cost=244,838.87..272,438.58 rows=649,405 width=168) (actual time=1,730.787..4,804.052 rows=554 loops=4)

  • Group Key: (time_bucket('7 days'::interval, tilt_data.read_time))
5. 627.617 1,834.728 ↓ 2.3 1,514,833 4 / 4

Sort (cost=244,838.87..246,462.38 rows=649,405 width=38) (actual time=1,727.137..1,834.728 rows=1,514,833 loops=4)

  • Sort Key: (time_bucket('7 days'::interval, tilt_data.read_time))
  • Sort Method: quicksort Memory: 195314kB
  • Worker 0: Sort Method: quicksort Memory: 159458kB
  • Worker 1: Sort Method: quicksort Memory: 153102kB
  • Worker 2: Sort Method: quicksort Memory: 162122kB
6. 1,207.111 1,207.111 ↓ 2.3 1,514,833 4 / 4

Parallel Index Scan using new_data_station_idx on tilt_data (cost=0.56..182,142.84 rows=649,405 width=38) (actual time=2.456..1,207.111 rows=1,514,833 loops=4)

  • Index Cond: (station = 'c08883c0-fbe5-11e9-bd6e-aec49259cebb'::uuid)
  • Filter: ((read_time)::date <= '2020-01-13'::date)
  • Rows Removed by Filter: 5396
Planning time : 1.165 ms
Execution time : 5,580.300 ms