explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eEmN

Settings
# exclusive inclusive rows x rows loops node
1. 3.668 142,778.886 ↑ 5.4 7,392 1

Sort (cost=3,676,154.71..3,676,354.71 rows=40,000 width=28) (actual time=142,778.391..142,778.886 rows=7,392 loops=1)

  • Sort Key: (time_bucket_gapfill('1 day'::interval, "timestamp")), bucket DESC
  • Sort Method: quicksort Memory: 757kB
  • Buffers: shared hit=30 read=187968 written=2, temp read=78693 written=78848
2. 1.298 142,775.218 ↑ 5.4 7,392 1

Custom Scan (GapFill) (cost=3,672,997.17..3,673,097.17 rows=40,000 width=0) (actual time=142,773.440..142,775.218 rows=7,392 loops=1)

  • Buffers: shared hit=30 read=187968 written=2, temp read=78693 written=78848
3. 10.029 142,773.920 ↑ 5.7 6,963 1

Sort (cost=3,672,997.17..3,673,097.17 rows=40,000 width=0) (actual time=142,773.431..142,773.920 rows=6,963 loops=1)

  • Sort Key: _hyper_1_4_chunk.bucket DESC, (time_bucket_gapfill('1 day'::interval, _hyper_1_4_chunk."timestamp"))
  • Sort Method: quicksort Memory: 736kB
  • Buffers: shared hit=30 read=187968 written=2, temp read=78693 written=78848
4. 16.413 142,763.891 ↑ 5.7 6,963 1

Finalize GroupAggregate (cost=3,489,727.36..3,669,939.62 rows=40,000 width=0) (actual time=134,676.603..142,763.891 rows=6,963 loops=1)

  • Group Key: (time_bucket_gapfill('1 day'::interval, _hyper_1_4_chunk."timestamp")), _hyper_1_4_chunk.bucket
  • Buffers: shared hit=30 read=187968 written=2, temp read=78693 written=78848
5. 0.000 142,747.478 ↑ 18.3 8,723 1

Gather Merge (cost=3,489,727.36..3,667,739.62 rows=160,000 width=52) (actual time=134,676.276..142,747.478 rows=8,723 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=210006 read=1056790 written=5, temp read=575698 written=576741
6. 9,936.780 634,615.475 ↑ 22.9 1,745 5

Partial GroupAggregate (cost=3,488,727.30..3,647,682.02 rows=40,000 width=52) (actual time=122,092.524..126,923.095 rows=1,745 loops=5)

  • Group Key: (time_bucket_gapfill('1 day'::interval, _hyper_1_4_chunk."timestamp")), _hyper_1_4_chunk.bucket
  • Buffers: shared hit=210006 read=1056790 written=5, temp read=575698 written=576741
7. 218,548.485 624,678.695 ↑ 1.3 10,139,000 5

Sort (cost=3,488,727.30..3,520,418.24 rows=12,676,378 width=20) (actual time=122,086.536..124,935.739 rows=10,139,000 loops=5)

  • Sort Key: (time_bucket_gapfill('1 day'::interval, _hyper_1_4_chunk."timestamp")), _hyper_1_4_chunk.bucket DESC
  • Sort Method: external merge Disk: 250416kB
  • Worker 0: Sort Method: external merge Disk: 330288kB
  • Worker 1: Sort Method: external merge Disk: 352312kB
  • Worker 2: Sort Method: external merge Disk: 458864kB
  • Worker 3: Sort Method: external merge Disk: 295000kB
  • Buffers: shared hit=210006 read=1056790 written=5, temp read=575698 written=576741
8. 11,583.525 406,130.210 ↑ 1.3 10,139,000 5

Result (cost=0.00..1,688,659.49 rows=12,676,378 width=20) (actual time=16.819..81,226.042 rows=10,139,000 loops=5)

  • Buffers: shared hit=209866 read=1056790 written=5
9. 6,102.724 394,546.685 ↑ 1.3 10,139,000 5

Parallel Append (cost=0.00..1,530,204.76 rows=12,676,378 width=20) (actual time=16.814..78,909.337 rows=10,139,000 loops=5)

  • Buffers: shared hit=209866 read=1056790 written=5
10. 44,021.686 44,021.686 ↓ 4.0 4,698,225 1

Parallel Seq Scan on _hyper_1_4_chunk (cost=0.00..135,012.24 rows=1,174,549 width=20) (actual time=41.985..44,021.686 rows=4,698,225 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=117394 written=2
11. 37,478.957 37,478.957 ↓ 4.0 4,305,194 1

Parallel Seq Scan on _hyper_1_5_chunk (cost=0.00..123,721.87 rows=1,076,258 width=20) (actual time=30.154..37,478.957 rows=4,305,194 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=107578 written=1
12. 1,818.397 1,818.397 ↓ 4.0 3,474,669 1

Parallel Seq Scan on _hyper_1_25_chunk (cost=0.00..99,842.17 rows=868,878 width=20) (actual time=0.047..1,818.397 rows=3,474,669 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=86809
13. 1,853.449 1,853.449 ↓ 4.0 3,473,053 1

Parallel Seq Scan on _hyper_1_11_chunk (cost=0.00..99,800.12 rows=868,475 width=20) (actual time=0.035..1,853.449 rows=3,473,053 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=86773
14. 9,469.358 9,469.358 ↓ 4.0 3,472,032 1

Parallel Seq Scan on _hyper_1_20_chunk (cost=0.00..99,770.43 rows=868,228 width=20) (actual time=35.142..9,469.358 rows=3,472,032 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=36251 read=50496
15. 40,950.201 40,950.201 ↓ 4.0 3,424,649 1

Parallel Seq Scan on _hyper_1_2_chunk (cost=0.00..98,409.33 rows=856,155 width=20) (actual time=74.265..40,950.201 rows=3,424,649 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=85567
16. 41,917.174 41,917.174 ↓ 4.0 3,295,735 1

Parallel Seq Scan on _hyper_1_26_chunk (cost=0.00..94,705.61 rows=824,174 width=20) (actual time=14.346..41,917.174 rows=3,295,735 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=82341
17. 26,471.006 26,471.006 ↓ 4.0 3,262,285 1

Parallel Seq Scan on _hyper_1_7_chunk (cost=0.00..93,748.27 rows=815,751 width=20) (actual time=5.932..26,471.006 rows=3,262,285 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=81512
18. 14,109.951 14,109.951 ↓ 4.0 3,249,450 1

Parallel Seq Scan on _hyper_1_29_chunk (cost=0.00..93,374.59 rows=812,573 width=20) (actual time=42.201..14,109.951 rows=3,249,450 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=1 read=81185
19. 34,066.132 34,066.132 ↓ 2.0 1,491,686 2

Parallel Seq Scan on _hyper_1_3_chunk (cost=0.00..85,757.30 rows=746,287 width=20) (actual time=215.179..17,033.066 rows=1,491,686 loops=2)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=74563
20. 15,082.800 15,082.800 ↓ 4.0 2,980,434 1

Parallel Seq Scan on _hyper_1_1_chunk (cost=0.00..85,671.57 rows=745,571 width=20) (actual time=9.596..15,082.800 rows=2,980,434 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=74488
21. 21,864.955 21,864.955 ↑ 1.3 596,047 5

Parallel Seq Scan on _hyper_1_6_chunk (cost=0.00..85,668.51 rows=745,501 width=20) (actual time=44.669..4,372.991 rows=596,047 loops=5)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=74486
22. 19,345.149 19,345.149 ↓ 1.3 574,006 3

Parallel Seq Scan on _hyper_1_30_chunk (cost=0.00..49,471.67 rows=430,511 width=20) (actual time=47.690..6,448.383 rows=574,006 loops=3)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=43014
23. 27,563.360 27,563.360 ↓ 2.0 860,711 2

Parallel Seq Scan on _hyper_1_32_chunk (cost=0.00..49,454.43 rows=430,362 width=20) (actual time=6.948..13,781.680 rows=860,711 loops=2)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=42999
24. 16,378.058 16,378.058 ↓ 4.0 1,719,190 1

Parallel Seq Scan on _hyper_1_31_chunk (cost=0.00..49,391.11 rows=429,808 width=20) (actual time=14.107..16,378.058 rows=1,719,190 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=42944
25. 4,135.535 4,135.535 ↓ 2.4 317,228 1

Parallel Seq Scan on _hyper_1_22_chunk (cost=0.00..9,909.14 rows=132,210 width=20) (actual time=29.665..4,135.535 rows=317,228 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=7924
26. 1,089.122 1,089.122 ↓ 2.4 228,121 1

Parallel Seq Scan on _hyper_1_18_chunk (cost=0.00..7,123.91 rows=95,060 width=20) (actual time=21.188..1,089.122 rows=228,121 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=5698
27. 1,877.632 1,877.632 ↓ 2.4 228,042 1

Parallel Seq Scan on _hyper_1_12_chunk (cost=0.00..7,122.44 rows=95,030 width=20) (actual time=19.638..1,877.632 rows=228,042 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5695
28. 1,010.871 1,010.871 ↓ 2.4 227,725 1

Parallel Seq Scan on _hyper_1_19_chunk (cost=0.00..7,112.56 rows=94,904 width=20) (actual time=33.195..1,010.871 rows=227,725 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5687
29. 3,596.101 3,596.101 ↓ 2.4 227,434 1

Parallel Seq Scan on _hyper_1_27_chunk (cost=0.00..7,104.75 rows=94,783 width=20) (actual time=12.494..3,596.101 rows=227,434 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=5683
30. 1,654.351 1,654.351 ↓ 2.4 227,389 1

Parallel Seq Scan on _hyper_1_15_chunk (cost=0.00..7,101.18 rows=94,745 width=20) (actual time=62.822..1,654.351 rows=227,389 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5678
31. 4,072.024 4,072.024 ↓ 2.4 227,361 1

Parallel Seq Scan on _hyper_1_23_chunk (cost=0.00..7,101.09 rows=94,740 width=20) (actual time=46.555..4,072.024 rows=227,361 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5678
32. 2,536.852 2,536.852 ↓ 2.4 227,330 1

Parallel Seq Scan on _hyper_1_13_chunk (cost=0.00..7,099.79 rows=94,719 width=20) (actual time=22.039..2,536.852 rows=227,330 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5677
33. 1,883.753 1,883.753 ↓ 2.4 227,195 1

Parallel Seq Scan on _hyper_1_9_chunk (cost=0.00..7,095.08 rows=94,672 width=20) (actual time=37.626..1,883.753 rows=227,195 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5673
34. 3,185.551 3,185.551 ↓ 2.4 227,186 1

Parallel Seq Scan on _hyper_1_24_chunk (cost=0.00..7,095.01 rows=94,668 width=20) (actual time=52.726..3,185.551 rows=227,186 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5673
35. 1,560.931 1,560.931 ↓ 2.4 227,161 1

Parallel Seq Scan on _hyper_1_10_chunk (cost=0.00..7,094.82 rows=94,655 width=20) (actual time=24.716..1,560.931 rows=227,161 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5673
36. 1,787.723 1,787.723 ↓ 2.4 226,962 1

Parallel Seq Scan on _hyper_1_28_chunk (cost=0.00..7,089.19 rows=94,546 width=20) (actual time=17.877..1,787.723 rows=226,962 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5669
37. 2,696.602 2,696.602 ↓ 2.4 226,996 1

Parallel Seq Scan on _hyper_1_17_chunk (cost=0.00..7,088.80 rows=94,587 width=20) (actual time=13.919..2,696.602 rows=226,996 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5668
38. 516.062 516.062 ↓ 2.4 226,968 1

Parallel Seq Scan on _hyper_1_14_chunk (cost=0.00..7,087.80 rows=94,520 width=20) (actual time=20.121..516.062 rows=226,968 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5668
39. 555.652 555.652 ↓ 2.4 226,775 1

Parallel Seq Scan on _hyper_1_8_chunk (cost=0.00..7,082.34 rows=94,490 width=20) (actual time=10.758..555.652 rows=226,775 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=2 read=5663
40. 1,037.844 1,037.844 ↓ 2.4 226,551 1

Parallel Seq Scan on _hyper_1_21_chunk (cost=0.00..7,075.12 rows=94,408 width=20) (actual time=25.001..1,037.844 rows=226,551 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=3 read=5656
41. 1,270.650 1,270.650 ↓ 2.4 133,493 1

Parallel Seq Scan on _hyper_1_16_chunk (cost=0.00..4,168.33 rows=55,622 width=20) (actual time=38.911..1,270.650 rows=133,493 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared read=3334
42. 1,586.072 1,586.072 ↓ 1.7 73,120 1

Parallel Seq Scan on _hyper_1_33_chunk (cost=0.00..2,472.26 rows=43,017 width=20) (actual time=11.835..1,586.072 rows=73,120 loops=1)

  • Filter: (("timestamp" >= '2018-06-19 22:00:00'::timestamp without time zone) AND ("timestamp" <= '2020-04-20 14:40:00'::timestamp without time zone))
  • Buffers: shared hit=1 read=1826 written=2
Planning time : 1,729.241 ms
Execution time : 142,787.502 ms