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. 15,824.383 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. 1,987.356 126,923.095 ↑ 22.9 1,745 5 / 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. 43,709.697 124,935.739 ↑ 1.3 10,139,000 5 / 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. 2,316.705 81,226.042 ↑ 1.3 10,139,000 5 / 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. 1,220.545 78,909.337 ↑ 1.3 10,139,000 5 / 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. 8,804.337 8,804.337 ↓ 4.0 4,698,225 1 / 5

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. 7,495.791 7,495.791 ↓ 4.0 4,305,194 1 / 5

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. 363.679 363.679 ↓ 4.0 3,474,669 1 / 5

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. 370.690 370.690 ↓ 4.0 3,473,053 1 / 5

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. 1,893.872 1,893.872 ↓ 4.0 3,472,032 1 / 5

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. 8,190.040 8,190.040 ↓ 4.0 3,424,649 1 / 5

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. 8,383.435 8,383.435 ↓ 4.0 3,295,735 1 / 5

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. 5,294.201 5,294.201 ↓ 4.0 3,262,285 1 / 5

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. 2,821.990 2,821.990 ↓ 4.0 3,249,450 1 / 5

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. 6,813.226 6,813.226 ↓ 2.0 1,491,686 2 / 5

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. 3,016.560 3,016.560 ↓ 4.0 2,980,434 1 / 5

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. 4,372.991 4,372.991 ↑ 1.3 596,047 5 / 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. 3,869.030 3,869.030 ↓ 1.3 574,006 3 / 5

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. 5,512.672 5,512.672 ↓ 2.0 860,711 2 / 5

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. 3,275.612 3,275.612 ↓ 4.0 1,719,190 1 / 5

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. 827.107 827.107 ↓ 2.4 317,228 1 / 5

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. 217.824 217.824 ↓ 2.4 228,121 1 / 5

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. 375.526 375.526 ↓ 2.4 228,042 1 / 5

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. 202.174 202.174 ↓ 2.4 227,725 1 / 5

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. 719.220 719.220 ↓ 2.4 227,434 1 / 5

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. 330.870 330.870 ↓ 2.4 227,389 1 / 5

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. 814.405 814.405 ↓ 2.4 227,361 1 / 5

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. 507.370 507.370 ↓ 2.4 227,330 1 / 5

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. 376.751 376.751 ↓ 2.4 227,195 1 / 5

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. 637.110 637.110 ↓ 2.4 227,186 1 / 5

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. 312.186 312.186 ↓ 2.4 227,161 1 / 5

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. 357.545 357.545 ↓ 2.4 226,962 1 / 5

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. 539.320 539.320 ↓ 2.4 226,996 1 / 5

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. 103.212 103.212 ↓ 2.4 226,968 1 / 5

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. 111.130 111.130 ↓ 2.4 226,775 1 / 5

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. 207.569 207.569 ↓ 2.4 226,551 1 / 5

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. 254.130 254.130 ↓ 2.4 133,493 1 / 5

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. 317.214 317.214 ↓ 1.7 73,120 1 / 5

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