explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jx0q

Settings
# exclusive inclusive rows x rows loops node
1. 2.708 5,861.741 ↑ 3,138.4 554 1

Subquery Scan on s1 (cost=245,594.24..600,618.60 rows=1,738,666 width=88) (actual time=1,953.188..5,861.741 rows=554 loops=1)

2. 1.892 5,859.033 ↑ 3,138.4 554 1

Finalize GroupAggregate (cost=245,594.24..574,538.61 rows=1,738,666 width=48) (actual time=1,953.163..5,859.033 rows=554 loops=1)

  • Group Key: (time_bucket('7 days'::interval, tilt_data.read_time))
3. 706.523 5,857.141 ↑ 951.8 2,045 1

Gather Merge (cost=245,594.24..501,875.38 rows=1,946,439 width=168) (actual time=1,945.921..5,857.141 rows=2,045 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 2,957.845 5,150.618 ↑ 1,269.7 511 4 / 4

Partial GroupAggregate (cost=244,594.20..272,168.76 rows=648,813 width=168) (actual time=1,922.046..5,150.618 rows=511 loops=4)

  • Group Key: (time_bucket('7 days'::interval, tilt_data.read_time))
5. 1,021.903 2,192.773 ↓ 2.3 1,504,929 4 / 4

Sort (cost=244,594.20..246,216.24 rows=648,813 width=38) (actual time=1,918.232..2,192.773 rows=1,504,929 loops=4)

  • Sort Key: (time_bucket('7 days'::interval, tilt_data.read_time))
  • Sort Method: external merge Disk: 91792kB
  • Worker 0: Sort Method: external merge Disk: 72464kB
  • Worker 1: Sort Method: external merge Disk: 69200kB
  • Worker 2: Sort Method: external merge Disk: 71704kB
6. 1,170.870 1,170.870 ↓ 2.3 1,504,929 4 / 4

Parallel Index Scan using new_data_station_idx on tilt_data (cost=0.56..181,959.60 rows=648,813 width=38) (actual time=0.089..1,170.870 rows=1,504,929 loops=4)

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