explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lmg

Settings
# exclusive inclusive rows x rows loops node
1. 1.047 275,753.035 ↑ 1.4 148 1

GroupAggregate (cost=1,142,665.78..1,142,673.78 rows=200 width=36) (actual time=275,751.468..275,753.035 rows=148 loops=1)

  • Group Key: data_logs.data_log_io_id
2. 1.363 275,751.988 ↑ 1.7 240 1

Sort (cost=1,142,665.78..1,142,666.78 rows=400 width=20) (actual time=275,751.446..275,751.988 rows=240 loops=1)

  • Sort Key: data_logs.data_log_io_id
  • Sort Method: quicksort Memory: 43kB
3. 68.343 275,750.625 ↑ 1.7 240 1

HashAggregate (cost=1,142,640.49..1,142,644.49 rows=400 width=20) (actual time=275,750.020..275,750.625 rows=240 loops=1)

  • Group Key: data_logs.data_log_io_id, (max(data_logs.data_log_value)), (max(data_logs.data_log_date))
4. 1.103 275,682.282 ↑ 1.4 295 1

Append (cost=553,877.07..1,142,637.49 rows=400 width=20) (actual time=89,671.882..275,682.282 rows=295 loops=1)

5. 1.058 89,673.494 ↑ 1.4 147 1

Finalize GroupAggregate (cost=553,877.07..553,883.07 rows=200 width=20) (actual time=89,671.878..89,673.494 rows=147 loops=1)

  • Group Key: data_logs.data_log_io_id
6. 0.455 89,672.436 ↑ 1.4 285 1

Sort (cost=553,877.07..553,878.07 rows=400 width=20) (actual time=89,671.858..89,672.436 rows=285 loops=1)

  • Sort Key: data_logs.data_log_io_id
  • Sort Method: quicksort Memory: 47kB
7. 31.198 89,671.981 ↑ 1.4 285 1

Gather (cost=553,817.78..553,859.78 rows=400 width=20) (actual time=89,669.584..89,671.981 rows=285 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
8. 2,398.280 89,640.783 ↑ 1.4 142 2

Partial HashAggregate (cost=552,817.78..552,819.78 rows=200 width=20) (actual time=89,640.464..89,640.783 rows=142 loops=2)

  • Group Key: data_logs.data_log_io_id
9. 22,292.243 87,242.503 ↑ 2.4 916,589 2

Hash Join (cost=1,250.67..536,536.00 rows=2,170,904 width=20) (actual time=268.732..87,242.503 rows=916,589 loops=2)

  • Hash Cond: (data_logs.data_log_io_id = io.io_id)
10. 36,998.619 64,937.111 ↓ 1.1 9,740,047 2

Append (cost=0.00..512,937.92 rows=8,493,445 width=20) (actual time=4.909..64,937.111 rows=9,740,047 loops=2)

11. 0.005 0.005 ↓ 0.0 0 2

Parallel Seq Scan on data_logs (cost=0.00..0.00 rows=1 width=20) (actual time=0.004..0.005 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
12. 0.004 0.004 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1_chunk (cost=0.00..19.44 rows=629 width=20) (actual time=0.002..0.004 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
13. 0.043 0.043 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_2_chunk (cost=0.00..2.00 rows=1 width=20) (actual time=0.041..0.043 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
14. 0.252 0.264 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_3_chunk (cost=1.24..2.34 rows=1 width=20) (actual time=0.263..0.264 rows=0 loops=2)

  • Recheck Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
15. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
16. 0.015 0.015 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_4_chunk (cost=0.00..2.00 rows=1 width=20) (actual time=0.013..0.015 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
17. 0.000 0.010 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_5_chunk (cost=1.24..2.34 rows=1 width=20) (actual time=0.008..0.010 rows=0 loops=2)

  • Recheck Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
18. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_5_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.008..0.010 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
19. 0.016 0.024 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_6_chunk (cost=1.24..2.34 rows=1 width=20) (actual time=0.022..0.024 rows=0 loops=2)

  • Recheck Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
20. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_6_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.006..0.008 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
21. 0.004 0.004 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_7_chunk (cost=0.00..19.44 rows=629 width=20) (actual time=0.002..0.004 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
22. 0.000 0.010 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_8_chunk (cost=1.24..2.34 rows=1 width=20) (actual time=0.009..0.010 rows=0 loops=2)

  • Recheck Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
23. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_8_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.008..0.011 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
24. 0.012 0.020 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_9_chunk (cost=21.26..45.33 rows=16 width=20) (actual time=0.018..0.020 rows=0 loops=2)

  • Recheck Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
25. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_9_chunk_data_logs_date_idx (cost=0.00..21.25 rows=28 width=0) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
26. 1.319 1.319 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_10_chunk (cost=0.00..56.90 rows=60 width=20) (actual time=1.317..1.319 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
27. 1.256 1.256 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_11_chunk (cost=0.00..58.64 rows=43 width=20) (actual time=1.254..1.256 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
28. 1.142 1.142 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_12_chunk (cost=0.00..55.79 rows=53 width=20) (actual time=1.140..1.142 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
29. 3.582 3.582 ↑ 1.2 1,282 2

Parallel Seq Scan on _hyper_1_13_chunk (cost=0.00..85.37 rows=1,558 width=20) (actual time=0.740..3.582 rows=1,282 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
30. 8.082 8.082 ↑ 1.2 2,962 2

Parallel Seq Scan on _hyper_1_14_chunk (cost=0.00..114.26 rows=3,484 width=20) (actual time=0.070..8.082 rows=2,962 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
31. 9.087 9.087 ↑ 1.2 3,222 2

Parallel Seq Scan on _hyper_1_15_chunk (cost=0.00..124.86 rows=3,791 width=20) (actual time=0.069..9.087 rows=3,222 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
32. 7.853 7.853 ↑ 1.2 2,798 2

Parallel Seq Scan on _hyper_1_16_chunk (cost=0.00..107.37 rows=3,291 width=20) (actual time=0.054..7.853 rows=2,798 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
33. 7.119 7.119 ↑ 1.2 2,481 2

Parallel Seq Scan on _hyper_1_17_chunk (cost=0.00..95.78 rows=2,919 width=20) (actual time=0.064..7.119 rows=2,481 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
34. 7.520 7.520 ↑ 1.2 2,700 2

Parallel Seq Scan on _hyper_1_18_chunk (cost=0.00..110.65 rows=3,176 width=20) (actual time=0.075..7.520 rows=2,700 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
35. 5.141 5.141 ↑ 1.2 1,928 2

Parallel Seq Scan on _hyper_1_19_chunk (cost=0.00..74.03 rows=2,269 width=20) (actual time=0.068..5.141 rows=1,928 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
36. 6.687 6.687 ↑ 1.2 2,424 2

Parallel Seq Scan on _hyper_1_20_chunk (cost=0.00..93.78 rows=2,852 width=20) (actual time=0.057..6.687 rows=2,424 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
37. 9.941 9.941 ↑ 1.2 3,622 2

Parallel Seq Scan on _hyper_1_21_chunk (cost=0.00..138.92 rows=4,261 width=20) (actual time=0.065..9.941 rows=3,622 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
38. 19.478 19.478 ↑ 1.2 7,087 2

Parallel Seq Scan on _hyper_1_22_chunk (cost=0.00..272.06 rows=8,338 width=20) (actual time=0.059..19.478 rows=7,087 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
39. 13.139 13.139 ↑ 1.2 4,912 2

Parallel Seq Scan on _hyper_1_23_chunk (cost=0.00..188.70 rows=5,780 width=20) (actual time=0.062..13.139 rows=4,912 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
40. 25.263 25.263 ↑ 1.2 9,584 2

Parallel Seq Scan on _hyper_1_24_chunk (cost=0.00..367.12 rows=11,275 width=20) (actual time=0.060..25.263 rows=9,584 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
41. 27.798 27.798 ↑ 1.2 10,432 2

Parallel Seq Scan on _hyper_1_25_chunk (cost=0.00..400.09 rows=12,272 width=20) (actual time=0.055..27.798 rows=10,432 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
42. 30.108 30.108 ↑ 1.2 11,222 2

Parallel Seq Scan on _hyper_1_26_chunk (cost=0.00..433.04 rows=13,203 width=20) (actual time=0.057..30.108 rows=11,222 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
43. 64.731 64.731 ↑ 1.2 24,500 2

Parallel Seq Scan on _hyper_1_27_chunk (cost=0.00..941.44 rows=28,829 width=20) (actual time=0.059..64.731 rows=24,500 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
44. 0.028 0.028 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_28_chunk (cost=0.00..1.00 rows=1 width=20) (actual time=0.027..0.028 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
45. 60.235 60.235 ↑ 1.2 22,009 2

Parallel Seq Scan on _hyper_1_29_chunk (cost=0.00..846.51 rows=25,901 width=20) (actual time=0.093..60.235 rows=22,009 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
46. 53.661 53.661 ↑ 1.2 18,088 2

Parallel Seq Scan on _hyper_1_30_chunk (cost=0.00..861.21 rows=21,281 width=20) (actual time=0.069..53.661 rows=18,088 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
47. 62.308 62.308 ↑ 1.2 20,343 2

Parallel Seq Scan on _hyper_1_31_chunk (cost=0.00..1,140.99 rows=23,933 width=20) (actual time=0.059..62.308 rows=20,343 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
48. 78.631 78.631 ↑ 1.2 20,408 2

Parallel Seq Scan on _hyper_1_32_chunk (cost=0.00..1,988.15 rows=24,010 width=20) (actual time=0.065..78.631 rows=20,408 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
49. 77.480 77.480 ↑ 1.2 16,092 2

Parallel Seq Scan on _hyper_1_33_chunk (cost=0.00..2,361.97 rows=18,931 width=20) (actual time=0.062..77.480 rows=16,092 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
50. 78.675 78.675 ↑ 1.2 13,064 2

Parallel Seq Scan on _hyper_1_34_chunk (cost=0.00..2,767.54 rows=15,369 width=20) (actual time=0.064..78.675 rows=13,064 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
51. 63.758 63.758 ↑ 1.2 8,850 2

Parallel Seq Scan on _hyper_1_35_chunk (cost=0.00..2,540.19 rows=10,412 width=20) (actual time=0.059..63.758 rows=8,850 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
52. 65.608 65.608 ↑ 1.3 9,613 2

Parallel Seq Scan on _hyper_1_36_chunk (cost=0.00..2,759.50 rows=12,234 width=20) (actual time=0.060..65.608 rows=9,613 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
53. 70.144 70.144 ↑ 1.2 12,754 2

Parallel Seq Scan on _hyper_1_37_chunk (cost=0.00..2,719.13 rows=15,075 width=20) (actual time=0.062..70.144 rows=12,754 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
54. 0.029 0.029 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_38_chunk (cost=0.00..1.00 rows=1 width=20) (actual time=0.028..0.029 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
55. 84.054 84.054 ↑ 1.2 17,561 2

Parallel Seq Scan on _hyper_1_39_chunk (cost=0.00..2,853.93 rows=21,529 width=20) (actual time=0.081..84.054 rows=17,561 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
56. 76.459 76.459 ↑ 1.2 17,414 2

Parallel Seq Scan on _hyper_1_40_chunk (cost=0.00..2,676.30 rows=20,486 width=20) (actual time=0.070..76.459 rows=17,414 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
57. 88.259 88.259 ↑ 1.2 25,046 2

Parallel Seq Scan on _hyper_1_41_chunk (cost=0.00..2,708.00 rows=29,466 width=20) (actual time=0.073..88.259 rows=25,046 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
58. 278.718 278.718 ↓ 1.2 99,538 2

Parallel Seq Scan on _hyper_1_42_chunk (cost=0.00..4,806.22 rows=82,948 width=20) (actual time=0.060..278.718 rows=99,538 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
59. 301.624 301.624 ↓ 1.2 101,565 2

Parallel Seq Scan on _hyper_1_43_chunk (cost=0.00..5,154.56 rows=84,638 width=20) (actual time=0.080..301.624 rows=101,565 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
60. 449.973 449.973 ↓ 1.2 162,428 2

Parallel Seq Scan on _hyper_1_44_chunk (cost=0.00..5,977.34 rows=135,356 width=20) (actual time=0.065..449.973 rows=162,428 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
61. 461.316 461.316 ↓ 1.2 163,734 2

Parallel Seq Scan on _hyper_1_45_chunk (cost=0.00..5,853.68 rows=136,445 width=20) (actual time=0.070..461.316 rows=163,734 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
62. 464.023 464.023 ↓ 1.2 169,862 2

Parallel Seq Scan on _hyper_1_46_chunk (cost=0.00..6,069.27 rows=141,551 width=20) (actual time=0.065..464.023 rows=169,862 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
63. 379.402 379.402 ↓ 1.2 143,842 2

Parallel Seq Scan on _hyper_1_47_chunk (cost=0.00..5,590.10 rows=119,873 width=20) (actual time=0.064..379.402 rows=143,842 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
64. 465.158 465.158 ↓ 1.2 144,824 2

Parallel Seq Scan on _hyper_1_48_chunk (cost=0.00..8,812.31 rows=120,688 width=20) (actual time=0.181..465.158 rows=144,824 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
65. 557.879 557.879 ↓ 1.2 156,860 2

Parallel Seq Scan on _hyper_1_49_chunk (cost=0.00..12,642.74 rows=130,716 width=20) (actual time=0.070..557.879 rows=156,860 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
66. 585.069 585.069 ↓ 1.1 166,303 2

Parallel Seq Scan on _hyper_1_50_chunk (cost=0.00..13,504.36 rows=153,824 width=20) (actual time=0.066..585.069 rows=166,303 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
67. 563.459 563.459 ↓ 1.1 148,412 2

Parallel Seq Scan on _hyper_1_51_chunk (cost=0.00..14,517.12 rows=130,475 width=20) (actual time=0.063..563.459 rows=148,412 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
68. 547.360 547.360 ↓ 1.2 137,894 2

Parallel Seq Scan on _hyper_1_52_chunk (cost=0.00..14,300.15 rows=116,010 width=20) (actual time=0.065..547.360 rows=137,894 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
69. 628.608 628.608 ↓ 1.2 165,930 2

Parallel Seq Scan on _hyper_1_53_chunk (cost=0.00..14,640.70 rows=139,247 width=20) (actual time=0.065..628.608 rows=165,930 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
70. 635.089 635.089 ↓ 1.1 175,020 2

Parallel Seq Scan on _hyper_1_54_chunk (cost=0.00..14,343.12 rows=154,675 width=20) (actual time=0.074..635.089 rows=175,020 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
71. 1,406.245 1,406.245 ↓ 1.2 475,568 2

Parallel Seq Scan on _hyper_1_55_chunk (cost=0.00..28,159.72 rows=400,448 width=20) (actual time=0.064..1,406.245 rows=475,568 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
72. 1,286.924 1,286.924 ↓ 1.2 442,430 2

Parallel Seq Scan on _hyper_1_56_chunk (cost=0.00..21,701.13 rows=373,609 width=20) (actual time=0.059..1,286.924 rows=442,430 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
73. 0.017 0.017 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_57_chunk (cost=0.00..1.00 rows=1 width=20) (actual time=0.015..0.017 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
74. 0.051 0.051 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_58_chunk_data_logs_date_idx on _hyper_1_58_chunk (cost=0.15..2.37 rows=1 width=20) (actual time=0.049..0.051 rows=0 loops=2)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
75. 1,355.694 1,355.694 ↓ 1.2 469,766 2

Parallel Seq Scan on _hyper_1_59_chunk (cost=0.00..23,152.29 rows=396,286 width=20) (actual time=0.064..1,355.694 rows=469,766 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
76. 1,398.094 1,398.094 ↓ 1.2 473,620 2

Parallel Seq Scan on _hyper_1_60_chunk (cost=0.00..23,189.74 rows=400,983 width=20) (actual time=0.057..1,398.094 rows=473,620 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
77. 0.018 0.018 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_61_chunk_data_logs_date_idx on _hyper_1_61_chunk (cost=0.15..2.37 rows=1 width=20) (actual time=0.016..0.018 rows=0 loops=2)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
78. 0.018 0.018 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_62_chunk (cost=0.00..1.00 rows=1 width=20) (actual time=0.016..0.018 rows=0 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
79. 0.009 0.009 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_63_chunk_data_logs_date_idx on _hyper_1_63_chunk (cost=0.15..2.37 rows=1 width=20) (actual time=0.007..0.009 rows=0 loops=2)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
80. 1,304.638 1,304.638 ↓ 1.1 444,312 2

Parallel Seq Scan on _hyper_1_64_chunk (cost=0.00..21,366.24 rows=393,416 width=20) (actual time=0.062..1,304.638 rows=444,312 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
81. 1,403.069 1,403.069 ↓ 1.2 483,675 2

Parallel Seq Scan on _hyper_1_65_chunk (cost=0.00..23,330.51 rows=404,501 width=20) (actual time=0.065..1,403.069 rows=483,675 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
82. 1,466.701 1,466.701 ↓ 1.2 495,996 2

Parallel Seq Scan on _hyper_1_66_chunk (cost=0.00..24,538.17 rows=419,945 width=20) (actual time=0.084..1,466.701 rows=495,996 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
83. 2,535.856 2,535.856 ↓ 1.1 956,424 2

Parallel Seq Scan on _hyper_1_67_chunk (cost=0.00..44,176.13 rows=837,609 width=20) (actual time=0.056..2,535.856 rows=956,424 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
84. 5,225.988 5,225.988 ↓ 1.1 2,151,265 2

Parallel Seq Scan on _hyper_1_68_chunk (cost=0.00..94,537.68 rows=1,887,045 width=20) (actual time=0.060..5,225.988 rows=2,151,265 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
85. 1,403.323 1,403.323 ↓ 1.1 513,730 2

Parallel Seq Scan on _hyper_1_69_chunk (cost=0.00..24,580.59 rows=449,439 width=20) (actual time=0.031..1,403.323 rows=513,730 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
86. 1,378.242 1,378.242 ↓ 1.2 513,696 2

Parallel Seq Scan on _hyper_1_70_chunk (cost=0.00..21,720.83 rows=443,989 width=20) (actual time=0.064..1,378.242 rows=513,696 loops=2)

  • Filter: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
87. 346.825 346.825 ↑ 1.0 90,958 2

Parallel Index Scan using _hyper_1_71_chunk_data_logs_date_idx on _hyper_1_71_chunk (cost=0.43..6,186.67 rows=91,939 width=20) (actual time=0.113..346.825 rows=90,958 loops=2)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
88. 0.060 0.060 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_72_chunk_data_logs_date_idx on _hyper_1_72_chunk (cost=0.15..17.03 rows=210 width=20) (actual time=0.058..0.060 rows=0 loops=2)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
89. 0.026 0.026 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_73_chunk_data_logs_date_idx on _hyper_1_73_chunk (cost=0.15..17.03 rows=210 width=20) (actual time=0.024..0.026 rows=0 loops=2)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
90. 0.042 0.042 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_74_chunk_data_logs_date_idx on _hyper_1_74_chunk (cost=0.43..1.54 rows=1 width=20) (actual time=0.040..0.042 rows=0 loops=2)

  • Index Cond: (data_log_date <= ('2019-03-01 07:00:00+02'::timestamp with time zone + '00:00:10'::interval))
91. 1.155 13.149 ↑ 1.0 469 2

Hash (cost=1,244.81..1,244.81 rows=469 width=4) (actual time=13.149..13.149 rows=469 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
92. 11.994 11.994 ↑ 1.0 469 2

Index Scan using io_pkey on io (cost=0.28..1,244.81 rows=469 width=4) (actual time=0.427..11.994 rows=469 loops=2)

  • Filter: (io_type = 4)
  • Rows Removed by Filter: 1344
93. 0.781 186,007.685 ↑ 1.4 148 1

Finalize GroupAggregate (cost=588,744.42..588,750.42 rows=200 width=20) (actual time=186,006.623..186,007.685 rows=148 loops=1)

  • Group Key: data_logs_1.data_log_io_id
94. 0.072 186,006.904 ↑ 2.7 148 1

Sort (cost=588,744.42..588,745.42 rows=400 width=20) (actual time=186,006.608..186,006.904 rows=148 loops=1)

  • Sort Key: data_logs_1.data_log_io_id
  • Sort Method: quicksort Memory: 36kB
95. 7.400 186,006.832 ↑ 2.7 148 1

Gather (cost=588,685.13..588,727.13 rows=400 width=20) (actual time=186,005.130..186,006.832 rows=148 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
96. 5,275.576 185,999.432 ↑ 1.4 148 1

Partial HashAggregate (cost=587,685.13..587,687.13 rows=200 width=20) (actual time=185,999.066..185,999.432 rows=148 loops=1)

  • Group Key: data_logs_1.data_log_io_id
97. 48,135.970 180,723.856 ↑ 1.2 2,000,278 1

Hash Join (cost=1,250.67..570,014.26 rows=2,356,117 width=20) (actual time=507.327..180,723.856 rows=2,000,278 loops=1)

  • Hash Cond: (data_logs_1.data_log_io_id = io_1.io_id)
98. 80,083.417 132,583.859 ↓ 2.3 21,191,119 1

Append (cost=0.00..544,532.36 rows=9,209,415 width=20) (actual time=1.024..132,583.859 rows=21,191,119 loops=1)

99. 0.006 0.006 ↓ 0.0 0 1

Parallel Seq Scan on data_logs data_logs_1 (cost=0.00..0.00 rows=1 width=20) (actual time=0.003..0.006 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
100. 0.005 0.005 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_1_chunk _hyper_1_1_chunk_1 (cost=0.00..19.44 rows=629 width=20) (actual time=0.003..0.005 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
101. 0.014 0.014 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_2_chunk _hyper_1_2_chunk_1 (cost=0.00..2.00 rows=1 width=20) (actual time=0.012..0.014 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
102. 0.384 0.399 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on _hyper_1_3_chunk _hyper_1_3_chunk_1 (cost=1.24..2.34 rows=1 width=20) (actual time=0.399..0.399 rows=0 loops=1)

  • Recheck Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
103. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.013..0.015 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
104. 0.011 0.011 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_4_chunk _hyper_1_4_chunk_1 (cost=0.00..2.00 rows=1 width=20) (actual time=0.009..0.011 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
105. 0.006 0.031 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on _hyper_1_5_chunk _hyper_1_5_chunk_1 (cost=1.24..2.34 rows=1 width=20) (actual time=0.029..0.031 rows=0 loops=1)

  • Recheck Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
106. 0.025 0.025 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_5_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.023..0.025 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
107. 0.018 0.026 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on _hyper_1_6_chunk _hyper_1_6_chunk_1 (cost=1.24..2.34 rows=1 width=20) (actual time=0.024..0.026 rows=0 loops=1)

  • Recheck Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
108. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_6_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.006..0.008 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
109. 0.004 0.004 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_7_chunk _hyper_1_7_chunk_1 (cost=0.00..19.44 rows=629 width=20) (actual time=0.002..0.004 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
110. 0.006 0.026 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on _hyper_1_8_chunk _hyper_1_8_chunk_1 (cost=1.24..2.34 rows=1 width=20) (actual time=0.024..0.026 rows=0 loops=1)

  • Recheck Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
111. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_8_chunk_data_logs_date_idx (cost=0.00..1.24 rows=1 width=0) (actual time=0.018..0.020 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
112. 0.017 0.026 ↓ 0.0 0 1

Parallel Bitmap Heap Scan on _hyper_1_9_chunk _hyper_1_9_chunk_1 (cost=21.26..45.33 rows=16 width=20) (actual time=0.024..0.026 rows=0 loops=1)

  • Recheck Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
113. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_9_chunk_data_logs_date_idx (cost=0.00..21.25 rows=28 width=0) (actual time=0.007..0.009 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
114. 0.154 0.154 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_10_chunk _hyper_1_10_chunk_1 (cost=0.00..56.90 rows=60 width=20) (actual time=0.152..0.154 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
115. 0.113 0.113 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_11_chunk _hyper_1_11_chunk_1 (cost=0.00..58.64 rows=43 width=20) (actual time=0.111..0.113 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
116. 0.097 0.097 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_12_chunk _hyper_1_12_chunk_1 (cost=0.00..55.79 rows=53 width=20) (actual time=0.095..0.097 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
117. 6.447 6.447 ↓ 1.6 2,563 1

Parallel Seq Scan on _hyper_1_13_chunk _hyper_1_13_chunk_1 (cost=0.00..85.37 rows=1,558 width=20) (actual time=0.103..6.447 rows=2,563 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
118. 14.365 14.365 ↓ 1.7 5,923 1

Parallel Seq Scan on _hyper_1_14_chunk _hyper_1_14_chunk_1 (cost=0.00..114.26 rows=3,484 width=20) (actual time=0.010..14.365 rows=5,923 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
119. 15.898 15.898 ↓ 1.7 6,444 1

Parallel Seq Scan on _hyper_1_15_chunk _hyper_1_15_chunk_1 (cost=0.00..124.86 rows=3,791 width=20) (actual time=0.015..15.898 rows=6,444 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
120. 13.981 13.981 ↓ 1.7 5,595 1

Parallel Seq Scan on _hyper_1_16_chunk _hyper_1_16_chunk_1 (cost=0.00..107.37 rows=3,291 width=20) (actual time=0.010..13.981 rows=5,595 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
121. 11.823 11.823 ↓ 1.7 4,962 1

Parallel Seq Scan on _hyper_1_17_chunk _hyper_1_17_chunk_1 (cost=0.00..95.78 rows=2,919 width=20) (actual time=0.025..11.823 rows=4,962 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
122. 12.993 12.993 ↓ 1.7 5,400 1

Parallel Seq Scan on _hyper_1_18_chunk _hyper_1_18_chunk_1 (cost=0.00..110.65 rows=3,176 width=20) (actual time=0.016..12.993 rows=5,400 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
123. 9.713 9.713 ↓ 1.7 3,857 1

Parallel Seq Scan on _hyper_1_19_chunk _hyper_1_19_chunk_1 (cost=0.00..74.03 rows=2,269 width=20) (actual time=0.022..9.713 rows=3,857 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
124. 11.826 11.826 ↓ 1.7 4,848 1

Parallel Seq Scan on _hyper_1_20_chunk _hyper_1_20_chunk_1 (cost=0.00..93.78 rows=2,852 width=20) (actual time=0.020..11.826 rows=4,848 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
125. 17.850 17.850 ↓ 1.7 7,243 1

Parallel Seq Scan on _hyper_1_21_chunk _hyper_1_21_chunk_1 (cost=0.00..138.92 rows=4,261 width=20) (actual time=0.011..17.850 rows=7,243 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
126. 34.086 34.086 ↓ 1.7 14,174 1

Parallel Seq Scan on _hyper_1_22_chunk _hyper_1_22_chunk_1 (cost=0.00..272.06 rows=8,338 width=20) (actual time=0.010..34.086 rows=14,174 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
127. 24.829 24.829 ↓ 1.7 9,825 1

Parallel Seq Scan on _hyper_1_23_chunk _hyper_1_23_chunk_1 (cost=0.00..188.70 rows=5,780 width=20) (actual time=0.023..24.829 rows=9,825 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
128. 49.052 49.052 ↓ 1.7 19,167 1

Parallel Seq Scan on _hyper_1_24_chunk _hyper_1_24_chunk_1 (cost=0.00..367.12 rows=11,275 width=20) (actual time=0.020..49.052 rows=19,167 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
129. 51.184 51.184 ↓ 1.7 20,863 1

Parallel Seq Scan on _hyper_1_25_chunk _hyper_1_25_chunk_1 (cost=0.00..400.09 rows=12,272 width=20) (actual time=0.000..51.184 rows=20,863 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
130. 51.788 51.788 ↓ 1.7 22,445 1

Parallel Seq Scan on _hyper_1_26_chunk _hyper_1_26_chunk_1 (cost=0.00..433.04 rows=13,203 width=20) (actual time=0.015..51.788 rows=22,445 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
131. 115.084 115.084 ↓ 1.7 48,999 1

Parallel Seq Scan on _hyper_1_27_chunk _hyper_1_27_chunk_1 (cost=0.00..941.44 rows=28,829 width=20) (actual time=0.010..115.084 rows=48,999 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
132. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_28_chunk _hyper_1_28_chunk_1 (cost=0.00..1.00 rows=1 width=20) (actual time=0.006..0.008 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
133. 103.154 103.154 ↓ 1.7 44,018 1

Parallel Seq Scan on _hyper_1_29_chunk _hyper_1_29_chunk_1 (cost=0.00..846.51 rows=25,901 width=20) (actual time=0.020..103.154 rows=44,018 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
134. 85.412 85.412 ↓ 1.7 36,177 1

Parallel Seq Scan on _hyper_1_30_chunk _hyper_1_30_chunk_1 (cost=0.00..861.21 rows=21,281 width=20) (actual time=0.008..85.412 rows=36,177 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
135. 96.641 96.641 ↓ 1.7 40,686 1

Parallel Seq Scan on _hyper_1_31_chunk _hyper_1_31_chunk_1 (cost=0.00..1,140.99 rows=23,933 width=20) (actual time=0.015..96.641 rows=40,686 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
136. 101.152 101.152 ↓ 1.7 40,817 1

Parallel Seq Scan on _hyper_1_32_chunk _hyper_1_32_chunk_1 (cost=0.00..1,988.15 rows=24,010 width=20) (actual time=0.009..101.152 rows=40,817 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
137. 83.937 83.937 ↓ 1.7 32,183 1

Parallel Seq Scan on _hyper_1_33_chunk _hyper_1_33_chunk_1 (cost=0.00..2,361.97 rows=18,931 width=20) (actual time=0.008..83.937 rows=32,183 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
138. 74.625 74.625 ↓ 1.7 26,128 1

Parallel Seq Scan on _hyper_1_34_chunk _hyper_1_34_chunk_1 (cost=0.00..2,767.54 rows=15,369 width=20) (actual time=0.020..74.625 rows=26,128 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
139. 51.647 51.647 ↓ 1.7 17,699 1

Parallel Seq Scan on _hyper_1_35_chunk _hyper_1_35_chunk_1 (cost=0.00..2,540.19 rows=10,412 width=20) (actual time=0.022..51.647 rows=17,699 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
140. 59.074 59.074 ↓ 1.6 19,226 1

Parallel Seq Scan on _hyper_1_36_chunk _hyper_1_36_chunk_1 (cost=0.00..2,759.50 rows=12,234 width=20) (actual time=0.008..59.074 rows=19,226 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
141. 75.354 75.354 ↓ 1.7 25,509 1

Parallel Seq Scan on _hyper_1_37_chunk _hyper_1_37_chunk_1 (cost=0.00..2,719.13 rows=15,075 width=20) (actual time=0.007..75.354 rows=25,509 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
142. 0.016 0.016 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_38_chunk _hyper_1_38_chunk_1 (cost=0.00..1.00 rows=1 width=20) (actual time=0.014..0.016 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
143. 93.102 93.102 ↓ 1.6 35,122 1

Parallel Seq Scan on _hyper_1_39_chunk _hyper_1_39_chunk_1 (cost=0.00..2,853.93 rows=21,529 width=20) (actual time=0.008..93.102 rows=35,122 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
144. 90.944 90.944 ↓ 1.7 34,827 1

Parallel Seq Scan on _hyper_1_40_chunk _hyper_1_40_chunk_1 (cost=0.00..2,676.30 rows=20,486 width=20) (actual time=0.007..90.944 rows=34,827 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
145. 128.437 128.437 ↓ 1.7 50,093 1

Parallel Seq Scan on _hyper_1_41_chunk _hyper_1_41_chunk_1 (cost=0.00..2,708.00 rows=29,466 width=20) (actual time=0.006..128.437 rows=50,093 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
146. 497.530 497.530 ↓ 2.4 199,075 1

Parallel Seq Scan on _hyper_1_42_chunk _hyper_1_42_chunk_1 (cost=0.00..4,806.22 rows=82,948 width=20) (actual time=0.010..497.530 rows=199,075 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
147. 508.303 508.303 ↓ 2.4 203,130 1

Parallel Seq Scan on _hyper_1_43_chunk _hyper_1_43_chunk_1 (cost=0.00..5,154.56 rows=84,638 width=20) (actual time=0.010..508.303 rows=203,130 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
148. 786.093 786.093 ↓ 2.4 324,855 1

Parallel Seq Scan on _hyper_1_44_chunk _hyper_1_44_chunk_1 (cost=0.00..5,977.34 rows=135,356 width=20) (actual time=0.010..786.093 rows=324,855 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
149. 784.689 784.689 ↓ 2.4 327,469 1

Parallel Seq Scan on _hyper_1_45_chunk _hyper_1_45_chunk_1 (cost=0.00..5,853.68 rows=136,445 width=20) (actual time=0.015..784.689 rows=327,469 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
150. 824.658 824.658 ↓ 2.4 339,723 1

Parallel Seq Scan on _hyper_1_46_chunk _hyper_1_46_chunk_1 (cost=0.00..6,069.27 rows=141,551 width=20) (actual time=0.024..824.658 rows=339,723 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
151. 717.255 717.255 ↓ 2.4 287,685 1

Parallel Seq Scan on _hyper_1_47_chunk _hyper_1_47_chunk_1 (cost=0.00..5,590.10 rows=119,873 width=20) (actual time=0.041..717.255 rows=287,685 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
152. 749.459 749.459 ↓ 2.4 289,649 1

Parallel Seq Scan on _hyper_1_48_chunk _hyper_1_48_chunk_1 (cost=0.00..8,812.31 rows=120,688 width=20) (actual time=0.041..749.459 rows=289,649 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
153. 817.750 817.750 ↓ 2.4 313,719 1

Parallel Seq Scan on _hyper_1_49_chunk _hyper_1_49_chunk_1 (cost=0.00..12,642.74 rows=130,716 width=20) (actual time=0.017..817.750 rows=313,719 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
154. 853.673 853.673 ↓ 2.2 332,606 1

Parallel Seq Scan on _hyper_1_50_chunk _hyper_1_50_chunk_1 (cost=0.00..13,504.36 rows=153,824 width=20) (actual time=0.012..853.673 rows=332,606 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
155. 761.682 761.682 ↓ 2.3 296,823 1

Parallel Seq Scan on _hyper_1_51_chunk _hyper_1_51_chunk_1 (cost=0.00..14,517.12 rows=130,475 width=20) (actual time=0.014..761.682 rows=296,823 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
156. 713.368 713.368 ↓ 2.4 275,787 1

Parallel Seq Scan on _hyper_1_52_chunk _hyper_1_52_chunk_1 (cost=0.00..14,300.15 rows=116,010 width=20) (actual time=0.011..713.368 rows=275,787 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
157. 852.073 852.073 ↓ 2.4 331,861 1

Parallel Seq Scan on _hyper_1_53_chunk _hyper_1_53_chunk_1 (cost=0.00..14,640.70 rows=139,247 width=20) (actual time=0.008..852.073 rows=331,861 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
158. 908.326 908.326 ↓ 2.3 350,040 1

Parallel Seq Scan on _hyper_1_54_chunk _hyper_1_54_chunk_1 (cost=0.00..14,343.12 rows=154,675 width=20) (actual time=0.007..908.326 rows=350,040 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
159. 2,383.258 2,383.258 ↓ 2.4 951,135 1

Parallel Seq Scan on _hyper_1_55_chunk _hyper_1_55_chunk_1 (cost=0.00..28,159.72 rows=400,448 width=20) (actual time=0.016..2,383.258 rows=951,135 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
160. 2,133.998 2,133.998 ↓ 2.4 884,861 1

Parallel Seq Scan on _hyper_1_56_chunk _hyper_1_56_chunk_1 (cost=0.00..21,701.13 rows=373,609 width=20) (actual time=0.010..2,133.998 rows=884,861 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
161. 0.009 0.009 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_57_chunk _hyper_1_57_chunk_1 (cost=0.00..1.00 rows=1 width=20) (actual time=0.007..0.009 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
162. 0.027 0.027 ↓ 0.0 0 1

Parallel Index Scan using _hyper_1_58_chunk_data_logs_date_idx on _hyper_1_58_chunk _hyper_1_58_chunk_1 (cost=0.15..2.37 rows=1 width=20) (actual time=0.020..0.027 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
163. 2,251.220 2,251.220 ↓ 2.4 939,531 1

Parallel Seq Scan on _hyper_1_59_chunk _hyper_1_59_chunk_1 (cost=0.00..23,152.29 rows=396,286 width=20) (actual time=0.009..2,251.220 rows=939,531 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
164. 2,380.105 2,380.105 ↓ 2.4 947,239 1

Parallel Seq Scan on _hyper_1_60_chunk _hyper_1_60_chunk_1 (cost=0.00..23,189.74 rows=400,983 width=20) (actual time=0.011..2,380.105 rows=947,239 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
165. 0.021 0.021 ↓ 0.0 0 1

Parallel Index Scan using _hyper_1_61_chunk_data_logs_date_idx on _hyper_1_61_chunk _hyper_1_61_chunk_1 (cost=0.15..2.37 rows=1 width=20) (actual time=0.019..0.021 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
166. 0.008 0.008 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_62_chunk _hyper_1_62_chunk_1 (cost=0.00..1.00 rows=1 width=20) (actual time=0.006..0.008 rows=0 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
167. 0.010 0.010 ↓ 0.0 0 1

Parallel Index Scan using _hyper_1_63_chunk_data_logs_date_idx on _hyper_1_63_chunk _hyper_1_63_chunk_1 (cost=0.15..2.37 rows=1 width=20) (actual time=0.008..0.010 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
168. 2,276.463 2,276.463 ↓ 2.3 888,623 1

Parallel Seq Scan on _hyper_1_64_chunk _hyper_1_64_chunk_1 (cost=0.00..21,366.24 rows=393,416 width=20) (actual time=0.020..2,276.463 rows=888,623 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
169. 2,393.201 2,393.201 ↓ 2.4 967,350 1

Parallel Seq Scan on _hyper_1_65_chunk _hyper_1_65_chunk_1 (cost=0.00..23,330.51 rows=404,501 width=20) (actual time=0.021..2,393.201 rows=967,350 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
170. 2,476.190 2,476.190 ↓ 2.4 991,993 1

Parallel Seq Scan on _hyper_1_66_chunk _hyper_1_66_chunk_1 (cost=0.00..24,538.17 rows=419,945 width=20) (actual time=0.017..2,476.190 rows=991,993 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
171. 4,697.564 4,697.564 ↓ 2.3 1,912,848 1

Parallel Seq Scan on _hyper_1_67_chunk _hyper_1_67_chunk_1 (cost=0.00..44,176.13 rows=837,609 width=20) (actual time=0.020..4,697.564 rows=1,912,848 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
172. 10,365.910 10,365.910 ↓ 2.3 4,302,530 1

Parallel Seq Scan on _hyper_1_68_chunk _hyper_1_68_chunk_1 (cost=0.00..94,537.68 rows=1,887,045 width=20) (actual time=0.020..10,365.910 rows=4,302,530 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
173. 2,601.148 2,601.148 ↓ 2.3 1,027,460 1

Parallel Seq Scan on _hyper_1_69_chunk _hyper_1_69_chunk_1 (cost=0.00..24,580.59 rows=449,439 width=20) (actual time=0.028..2,601.148 rows=1,027,460 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
174. 2,612.471 2,612.471 ↓ 2.3 1,027,392 1

Parallel Seq Scan on _hyper_1_70_chunk _hyper_1_70_chunk_1 (cost=0.00..21,720.83 rows=443,989 width=20) (actual time=0.037..2,612.471 rows=1,027,392 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
175. 2,765.135 2,765.135 ↓ 2.3 1,138,760 1

Parallel Seq Scan on _hyper_1_71_chunk _hyper_1_71_chunk_1 (cost=0.00..22,859.31 rows=491,087 width=20) (actual time=0.028..2,765.135 rows=1,138,760 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
176. 0.028 0.028 ↓ 0.0 0 1

Parallel Index Scan using _hyper_1_72_chunk_data_logs_date_idx on _hyper_1_72_chunk _hyper_1_72_chunk_1 (cost=0.15..17.03 rows=210 width=20) (actual time=0.026..0.028 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
177. 0.026 0.026 ↓ 0.0 0 1

Parallel Index Scan using _hyper_1_73_chunk_data_logs_date_idx on _hyper_1_73_chunk _hyper_1_73_chunk_1 (cost=0.15..17.03 rows=210 width=20) (actual time=0.024..0.026 rows=0 loops=1)

  • Index Cond: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
178. 1,903.457 1,903.457 ↓ 2.4 754,182 1

Parallel Seq Scan on _hyper_1_74_chunk _hyper_1_74_chunk_1 (cost=0.00..14,923.35 rows=316,823 width=20) (actual time=0.038..1,903.457 rows=754,182 loops=1)

  • Filter: (data_log_date <= ('2019-04-01 07:00:00+03'::timestamp with time zone + '00:00:10'::interval))
179. 1.201 4.027 ↑ 1.0 469 1

Hash (cost=1,244.81..1,244.81 rows=469 width=4) (actual time=4.025..4.027 rows=469 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
180. 2.826 2.826 ↑ 1.0 469 1

Index Scan using io_pkey on io io_1 (cost=0.28..1,244.81 rows=469 width=4) (actual time=0.039..2.826 rows=469 loops=1)

  • Filter: (io_type = 4)
  • Rows Removed by Filter: 1344