explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fhBN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 413,074.227 ↑ 1.0 1 1

Finalize Aggregate (cost=1,074,927.05..1,074,927.06 rows=1 width=8) (actual time=413,074.227..413,074.227 rows=1 loops=1)

2. 23.490 413,074.944 ↓ 1.5 3 1

Gather (cost=1,074,926.84..1,074,927.05 rows=2 width=8) (actual time=413,066.072..413,074.944 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.003 413,051.454 ↑ 1.0 1 3

Partial Aggregate (cost=1,073,926.84..1,073,926.85 rows=1 width=8) (actual time=413,051.454..413,051.454 rows=1 loops=3)

4. 0.000 413,051.451 ↓ 0.0 0 3

Append (cost=0.00..1,072,910.75 rows=406,433 width=0) (actual time=413,051.451..413,051.451 rows=0 loops=3)

5. 0.001 0.001 ↓ 0.0 0 3

Parallel Seq Scan on mote_data (cost=0.00..0.00 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
6. 323.099 323.099 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_1_chunk (cost=0.00..12,621.85 rows=2,572 width=0) (actual time=323.099..323.099 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 113760
7. 367.576 367.576 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_2_chunk (cost=0.00..13,278.00 rows=2,536 width=0) (actual time=367.575..367.576 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 114984
8. 352.974 352.974 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_3_chunk (cost=0.00..13,377.03 rows=2,405 width=0) (actual time=352.974..352.974 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 117047
9. 412.661 412.661 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_4_chunk (cost=0.00..14,733.04 rows=2,583 width=0) (actual time=412.661..412.661 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 128368
10. 519.916 519.916 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_5_chunk (cost=0.00..13,363.11 rows=2,293 width=0) (actual time=519.916..519.916 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 118068
11. 531.649 531.649 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_6_chunk (cost=0.00..12,136.98 rows=1,687 width=0) (actual time=531.649..531.649 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 108888
12. 617.438 617.438 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_7_chunk (cost=0.00..13,484.71 rows=2,565 width=0) (actual time=617.438..617.438 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 110110
13. 624.350 624.350 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_8_chunk (cost=0.00..13,804.05 rows=2,623 width=0) (actual time=624.350..624.350 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 116031
14. 582.556 582.556 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_9_chunk (cost=0.00..12,701.54 rows=2,426 width=0) (actual time=582.556..582.556 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 99956
15. 609.306 609.306 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_10_chunk (cost=0.00..13,449.80 rows=2,432 width=0) (actual time=609.306..609.306 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 110062
16. 598.181 598.181 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_11_chunk (cost=0.00..13,155.96 rows=2,268 width=0) (actual time=598.181..598.181 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 109665
17. 568.872 568.872 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_12_chunk (cost=0.00..12,540.57 rows=2,125 width=0) (actual time=568.872..568.872 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 102405
18. 277.169 277.169 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_13_chunk (cost=0.00..7,873.65 rows=1,740 width=0) (actual time=277.168..277.169 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 67745
19. 204.489 204.489 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_14_chunk (cost=0.00..5,370.31 rows=246 width=0) (actual time=204.489..204.489 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 55433
20. 321.415 321.415 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_15_chunk (cost=0.00..7,819.57 rows=1 width=0) (actual time=321.415..321.415 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 75754
21. 331.381 331.381 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_16_chunk (cost=0.00..7,824.72 rows=208 width=0) (actual time=331.381..331.381 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 75077
22. 369.430 369.430 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_17_chunk (cost=0.00..9,924.98 rows=1,939 width=0) (actual time=369.429..369.430 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 77820
23. 554.337 554.337 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_18_chunk (cost=0.00..11,834.89 rows=2,592 width=0) (actual time=554.336..554.337 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 87159
24. 281.539 281.539 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_19_chunk (cost=0.00..6,627.74 rows=577 width=0) (actual time=281.539..281.539 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 64363
25. 588.222 588.222 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_20_chunk (cost=0.00..13,258.92 rows=3,342 width=0) (actual time=588.222..588.222 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 120182
26. 303.993 303.993 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_21_chunk (cost=0.00..6,393.12 rows=2,360 width=0) (actual time=303.993..303.993 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 46402
27. 535.995 535.995 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_22_chunk (cost=0.00..13,749.40 rows=3,872 width=0) (actual time=535.995..535.995 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 115017
28. 604.363 604.363 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_23_chunk (cost=0.00..14,080.58 rows=3,298 width=0) (actual time=604.363..604.363 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 127599
29. 248.536 248.536 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_24_chunk (cost=0.00..5,956.61 rows=1 width=0) (actual time=248.536..248.536 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 60468
30. 256.618 256.618 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_25_chunk (cost=0.00..5,907.82 rows=1 width=0) (actual time=256.618..256.618 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 55615
31. 1,741.106 1,741.106 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_26_chunk (cost=0.00..10,497.27 rows=2,238 width=0) (actual time=1,741.106..1,741.106 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 76654
32. 3,475.732 3,475.732 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_27_chunk (cost=0.00..10,733.26 rows=1,641 width=0) (actual time=3,475.732..3,475.732 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 77215
33. 3,899.297 3,899.297 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_28_chunk (cost=0.00..12,112.33 rows=1,805 width=0) (actual time=3,899.297..3,899.297 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 77320
34. 3,508.031 3,508.031 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_29_chunk (cost=0.00..10,103.18 rows=968 width=0) (actual time=3,508.031..3,508.031 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 59941
35. 3,625.349 3,625.349 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_30_chunk (cost=0.00..11,896.53 rows=776 width=0) (actual time=3,625.349..3,625.349 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 71059
36. 4,009.763 4,009.763 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_31_chunk (cost=0.00..14,354.71 rows=1,211 width=0) (actual time=4,009.763..4,009.763 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 81514
37. 4,656.656 4,656.656 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_32_chunk (cost=0.00..14,052.46 rows=1,596 width=0) (actual time=4,656.656..4,656.656 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 70818
38. 4,175.219 4,175.219 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_33_chunk (cost=0.00..13,876.69 rows=1,937 width=0) (actual time=4,175.219..4,175.219 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 65081
39. 4,191.905 4,191.905 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_34_chunk (cost=0.00..14,405.60 rows=1,854 width=0) (actual time=4,191.905..4,191.905 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 70846
40. 4,507.710 4,507.710 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_35_chunk (cost=0.00..13,699.14 rows=1,083 width=0) (actual time=4,507.710..4,507.710 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 71782
41. 24.920 24.920 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_36_chunk (cost=0.00..21.47 rows=1 width=0) (actual time=24.920..24.920 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 15
42. 4,967.044 4,967.044 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_37_chunk (cost=0.00..18,403.97 rows=9,755 width=0) (actual time=4,967.044..4,967.044 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 70235
43. 11,316.218 11,316.218 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_38_chunk (cost=0.00..33,257.64 rows=17,630 width=0) (actual time=11,316.218..11,316.218 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 126928
44. 8,836.433 8,836.433 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_39_chunk (cost=0.00..28,218.46 rows=14,958 width=0) (actual time=8,836.433..8,836.433 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 107688
45. 8,381.163 8,381.163 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_40_chunk (cost=0.00..22,061.28 rows=11,695 width=0) (actual time=8,381.163..8,381.163 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 84194
46. 7,274.911 7,274.911 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_41_chunk (cost=0.00..18,781.95 rows=9,955 width=0) (actual time=7,274.911..7,274.911 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 71678
47. 5,467.024 5,467.024 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_42_chunk (cost=0.00..12,973.14 rows=6,876 width=0) (actual time=5,467.024..5,467.024 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 49508
48. 8,382.017 8,382.017 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_43_chunk (cost=0.00..13,747.49 rows=7,287 width=0) (actual time=8,382.017..8,382.017 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 52462
49. 5,583.297 5,583.297 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_44_chunk (cost=0.00..12,214.81 rows=6,479 width=0) (actual time=5,583.297..5,583.297 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 46646
50. 3,275.386 3,275.386 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_45_chunk (cost=0.00..8,727.86 rows=4,626 width=0) (actual time=3,275.386..3,275.386 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 33309
51. 3,733.287 3,733.287 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_46_chunk (cost=0.00..11,606.23 rows=6,152 width=0) (actual time=3,733.287..3,733.287 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 44292
52. 9,008.843 9,008.843 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_47_chunk (cost=0.00..13,582.99 rows=7,200 width=0) (actual time=9,008.843..9,008.843 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 51832
53. 7,533.324 7,533.324 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_48_chunk (cost=0.00..10,025.73 rows=5,314 width=0) (actual time=7,533.324..7,533.324 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 38259
54. 6,267.178 6,267.178 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_49_chunk (cost=0.00..9,999.50 rows=5,300 width=0) (actual time=6,267.178..6,267.178 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 38160
55. 5,140.588 5,140.588 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_50_chunk (cost=0.00..10,603.58 rows=5,620 width=0) (actual time=5,140.588..5,140.588 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 40462
56. 10,625.280 10,625.280 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_51_chunk (cost=0.00..10,601.39 rows=5,620 width=0) (actual time=10,625.280..10,625.280 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 40460
57. 10,283.443 10,283.443 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_52_chunk (cost=0.00..10,768.29 rows=5,708 width=0) (actual time=10,283.442..10,283.443 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 41094
58. 5,374.340 5,374.340 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_53_chunk (cost=0.00..7,566.36 rows=4,010 width=0) (actual time=5,374.340..5,374.340 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 28873
59. 4,134.203 4,134.203 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_54_chunk (cost=0.00..8,511.06 rows=4,511 width=0) (actual time=4,134.203..4,134.203 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 32482
60. 3,541.795 3,541.795 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_55_chunk (cost=0.00..7,253.03 rows=3,845 width=0) (actual time=3,541.795..3,541.795 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 27679
61. 3,099.406 3,099.406 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_56_chunk (cost=0.00..6,611.53 rows=3,505 width=0) (actual time=3,099.406..3,099.406 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 25231
62. 2,641.632 2,641.632 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_57_chunk (cost=0.00..6,636.51 rows=3,518 width=0) (actual time=2,641.632..2,641.632 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 25327
63. 3,325.270 3,325.270 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_58_chunk (cost=0.00..5,272.88 rows=2,795 width=0) (actual time=3,325.270..3,325.270 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20120
64. 4,816.904 4,816.904 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_59_chunk (cost=0.00..7,487.07 rows=3,969 width=0) (actual time=4,816.904..4,816.904 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 28571
65. 2,241.885 2,241.885 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_60_chunk (cost=0.00..5,638.62 rows=2,990 width=0) (actual time=2,241.885..2,241.885 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 21517
66. 4,023.848 4,023.848 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_61_chunk (cost=0.00..3,614.99 rows=2,578 width=0) (actual time=4,023.848..4,023.848 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 13146
67. 3,900.775 3,900.775 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_62_chunk (cost=0.00..5,432.94 rows=2,880 width=0) (actual time=3,900.775..3,900.775 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20733
68. 2,066.754 2,066.754 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_63_chunk (cost=0.00..3,608.35 rows=1,912 width=0) (actual time=2,066.754..2,066.754 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 13770
69. 3,708.487 3,708.487 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_64_chunk (cost=0.00..4,395.14 rows=2,330 width=0) (actual time=3,708.486..3,708.487 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 16773
70. 1,599.945 1,599.945 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_65_chunk (cost=0.00..4,012.56 rows=2,127 width=0) (actual time=1,599.945..1,599.945 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 15311
71. 891.961 891.961 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_66_chunk (cost=0.00..3,012.31 rows=2,148 width=0) (actual time=891.961..891.961 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 10955
72. 3,074.620 3,074.620 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_67_chunk (cost=0.00..4,434.90 rows=2,351 width=0) (actual time=3,074.620..3,074.620 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 16925
73. 3,465.907 3,465.907 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_68_chunk (cost=0.00..4,464.46 rows=2,367 width=0) (actual time=3,465.906..3,465.907 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 17038
74. 1,017.386 1,017.386 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_69_chunk (cost=0.00..1,637.68 rows=1,168 width=0) (actual time=1,017.386..1,017.386 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 5958
75. 1,991.746 1,991.746 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_70_chunk (cost=0.00..5,077.47 rows=2,691 width=0) (actual time=1,991.746..1,991.746 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 19375
76. 958.573 958.573 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_71_chunk (cost=0.00..1,038.59 rows=741 width=0) (actual time=958.573..958.573 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 3776
77. 1,049.350 1,049.350 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_72_chunk (cost=0.00..2,264.43 rows=1,615 width=0) (actual time=1,049.350..1,049.350 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 8234
78. 1,266.919 1,266.919 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_73_chunk (cost=0.00..3,162.47 rows=2,255 width=0) (actual time=1,266.919..1,266.919 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 11501
79. 941.738 941.738 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_74_chunk (cost=0.00..2,256.09 rows=1,609 width=0) (actual time=941.738..941.738 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 8205
80. 1,799.927 1,799.927 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_75_chunk (cost=0.00..4,146.53 rows=2,198 width=0) (actual time=1,799.927..1,799.927 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 15825
81. 2,632.843 2,632.843 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_76_chunk (cost=0.00..5,471.57 rows=2,900 width=0) (actual time=2,632.843..2,632.843 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20878
82. 3,749.997 3,749.997 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_77_chunk (cost=0.00..5,660.04 rows=3,000 width=0) (actual time=3,749.997..3,749.997 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 21597
83. 2,333.702 2,333.702 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_78_chunk (cost=0.00..4,398.60 rows=2,332 width=0) (actual time=2,333.701..2,333.702 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 16784
84. 6,159.081 6,159.081 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_79_chunk (cost=0.00..6,686.41 rows=3,544 width=0) (actual time=6,159.081..6,159.081 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 25516
85. 5,650.538 5,650.538 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_80_chunk (cost=0.00..6,241.58 rows=3,309 width=0) (actual time=5,650.538..5,650.538 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 23822
86. 9,606.235 9,606.235 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_81_chunk (cost=0.00..6,143.74 rows=3,257 width=0) (actual time=9,606.235..9,606.235 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 23448
87. 3,850.760 3,850.760 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_82_chunk (cost=0.00..2,968.41 rows=2,118 width=0) (actual time=3,850.759..3,850.760 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 10795
88. 4,292.088 4,292.088 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_83_chunk (cost=0.00..5,076.58 rows=2,692 width=0) (actual time=4,292.088..4,292.088 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 19373
89. 5,907.003 5,907.003 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_84_chunk (cost=0.00..5,467.03 rows=2,898 width=0) (actual time=5,907.003..5,907.003 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20864
90. 4,208.483 4,208.483 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_85_chunk (cost=0.00..4,815.20 rows=2,552 width=0) (actual time=4,208.483..4,208.483 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 18373
91. 5,691.865 5,691.865 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_86_chunk (cost=0.00..4,417.77 rows=2,341 width=0) (actual time=5,691.864..5,691.865 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 16855
92. 3,774.933 3,774.933 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_87_chunk (cost=0.00..4,190.84 rows=2,222 width=0) (actual time=3,774.933..3,774.933 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 15988
93. 2,916.996 2,916.996 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_88_chunk (cost=0.00..4,506.54 rows=2,389 width=0) (actual time=2,916.995..2,916.996 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 17200
94. 3,791.712 3,791.712 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_89_chunk (cost=0.00..4,466.73 rows=2,368 width=0) (actual time=3,791.712..3,791.712 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 17045
95. 3,433.513 3,433.513 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_90_chunk (cost=0.00..4,483.72 rows=2,377 width=0) (actual time=3,433.513..3,433.513 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 17110
96. 2,817.071 2,817.071 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_91_chunk (cost=0.00..4,434.94 rows=2,351 width=0) (actual time=2,817.071..2,817.071 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 16926
97. 1,141.371 1,141.371 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_92_chunk (cost=0.00..2,208.38 rows=1,575 width=0) (actual time=1,141.371..1,141.371 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 8033
98. 1,907.615 1,907.615 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_93_chunk (cost=0.00..3,058.94 rows=2,182 width=0) (actual time=1,907.614..1,907.615 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 11124
99. 2,118.237 2,118.237 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_94_chunk (cost=0.00..5,007.19 rows=2,654 width=0) (actual time=2,118.237..2,118.237 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 19106
100. 1,534.265 1,534.265 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_95_chunk (cost=0.00..3,512.74 rows=2,505 width=0) (actual time=1,534.265..1,534.265 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 12776
101. 2,881.795 2,881.795 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_96_chunk (cost=0.00..3,892.21 rows=2,063 width=0) (actual time=2,881.795..2,881.795 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 14853
102. 3,241.422 3,241.422 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_97_chunk (cost=0.00..4,829.06 rows=2,560 width=0) (actual time=3,241.422..3,241.422 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 18431
103. 2,057.777 2,057.777 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_98_chunk (cost=0.00..5,581.59 rows=2,958 width=0) (actual time=2,057.777..2,057.777 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 21299
104. 4,349.848 4,349.848 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_99_chunk (cost=0.00..8,202.25 rows=4,348 width=0) (actual time=4,349.848..4,349.848 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 31301
105. 4,042.607 4,042.607 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_100_chunk (cost=0.00..5,787.22 rows=3,068 width=0) (actual time=4,042.607..4,042.607 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 22087
106. 2,049.501 2,049.501 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_101_chunk (cost=0.00..4,825.52 rows=2,558 width=0) (actual time=2,049.501..2,049.501 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 18415
107. 3,166.983 3,166.983 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_102_chunk (cost=0.00..7,808.26 rows=4,139 width=0) (actual time=3,166.983..3,166.983 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 29797
108. 2,782.703 2,782.703 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_103_chunk (cost=0.00..8,096.80 rows=4,292 width=0) (actual time=2,782.703..2,782.703 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 30897
109. 4,366.826 4,366.826 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_104_chunk (cost=0.00..10,165.10 rows=5,387 width=0) (actual time=4,366.826..4,366.826 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 38787
110. 3,624.751 3,624.751 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_105_chunk (cost=0.00..6,985.00 rows=3,702 width=0) (actual time=3,624.751..3,624.751 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 26655
111. 2,308.565 2,308.565 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_106_chunk (cost=0.00..4,346.29 rows=2,303 width=0) (actual time=2,308.565..2,308.565 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 16585
112. 2,692.124 2,692.124 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_107_chunk (cost=0.00..5,121.86 rows=2,715 width=0) (actual time=2,692.124..2,692.124 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 19545
113. 1,949.490 1,949.490 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_108_chunk (cost=0.00..5,493.15 rows=2,912 width=0) (actual time=1,949.489..1,949.490 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20963
114. 2,275.457 2,275.457 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_109_chunk (cost=0.00..5,789.49 rows=3,069 width=0) (actual time=2,275.457..2,275.457 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 22095
115. 2,649.824 2,649.824 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_110_chunk (cost=0.00..5,446.47 rows=2,887 width=0) (actual time=2,649.824..2,649.824 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20787
116. 2,825.576 2,825.576 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_111_chunk (cost=0.00..5,453.30 rows=2,890 width=0) (actual time=2,825.576..2,825.576 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20810
117. 2,915.653 2,915.653 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_112_chunk (cost=0.00..4,822.11 rows=2,556 width=0) (actual time=2,915.653..2,915.653 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 18403
118. 2,274.920 2,274.920 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_113_chunk (cost=0.00..4,837.15 rows=2,565 width=0) (actual time=2,274.920..2,274.920 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 18457
119. 2,358.940 2,358.940 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_114_chunk (cost=0.00..5,439.78 rows=2,883 width=0) (actual time=2,358.940..2,358.940 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20761
120. 3,234.012 3,234.012 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_115_chunk (cost=0.00..5,875.78 rows=3,115 width=0) (actual time=3,234.012..3,234.012 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 22421
121. 2,207.698 2,207.698 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_116_chunk (cost=0.00..5,998.41 rows=3,180 width=0) (actual time=2,207.698..2,207.698 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 22890
122. 1,999.269 1,999.269 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_117_chunk (cost=0.00..5,047.45 rows=2,678 width=0) (actual time=1,999.269..1,999.269 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 19273
123. 1,899.843 1,899.843 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_118_chunk (cost=0.00..3,862.65 rows=2,048 width=0) (actual time=1,899.843..1,899.843 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 14740
124. 2,950.661 2,950.661 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_119_chunk (cost=0.00..5,315.92 rows=2,818 width=0) (actual time=2,950.661..2,950.661 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 20285
125. 1,291.705 1,291.705 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_120_chunk (cost=0.00..2,337.09 rows=1,667 width=0) (actual time=1,291.705..1,291.705 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 8502
126. 1,716.303 1,716.303 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_121_chunk (cost=0.00..4,929.98 rows=2,613 width=0) (actual time=1,716.303..1,716.303 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 18813
127. 3,283.974 3,283.974 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_122_chunk (cost=0.00..6,211.86 rows=3,293 width=0) (actual time=3,283.974..3,283.974 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 23705
128. 1,749.452 1,749.452 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_123_chunk (cost=0.00..3,926.26 rows=2,081 width=0) (actual time=1,749.452..1,749.452 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 14984
129. 1,984.001 1,984.001 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_124_chunk (cost=0.00..5,070.09 rows=2,689 width=0) (actual time=1,984.001..1,984.001 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 19362
130. 3,015.648 3,015.648 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_125_chunk (cost=0.00..4,648.40 rows=2,464 width=0) (actual time=3,015.648..3,015.648 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 17737
131. 2,133.257 2,133.257 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_126_chunk (cost=0.00..3,901.19 rows=2,068 width=0) (actual time=2,133.257..2,133.257 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 14885
132. 916.905 916.905 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_127_chunk (cost=0.00..3,254.28 rows=2,321 width=0) (actual time=916.905..916.905 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 11837
133. 784.252 784.252 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_128_chunk (cost=0.00..2,755.19 rows=1,965 width=0) (actual time=784.252..784.252 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 10023
134. 1,432.697 1,432.697 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_129_chunk (cost=0.00..4,132.92 rows=2,191 width=0) (actual time=1,432.697..1,432.697 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 15773
135. 12,269.649 12,269.649 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_130_chunk (cost=0.00..12,577.70 rows=1,290 width=0) (actual time=12,269.649..12,269.649 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 15773
136. 12,269.649 12,269.649 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_130_chunk (cost=0.00..12,577.70 rows=1,290 width=0) (actual time=12,269.649..12,269.649 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 56714
137. 5,430.762 5,430.762 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_131_chunk (cost=0.00..11,344.20 rows=873 width=0) (actual time=5,430.762..5,430.762 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 48611
138. 2,849.089 2,849.089 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_132_chunk (cost=0.00..8,047.34 rows=520 width=0) (actual time=2,849.089..2,849.089 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 35222
139. 2,283.726 2,283.726 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_133_chunk (cost=0.00..8,008.58 rows=595 width=0) (actual time=2,283.726..2,283.726 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 30518
140. 1,416.360 1,416.360 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_134_chunk (cost=0.00..5,341.80 rows=451 width=0) (actual time=1,416.360..1,416.360 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 15426
141. 58.466 58.466 ↓ 0.0 0 3

Parallel Seq Scan on _hyper_1_135_chunk (cost=0.00..52.22 rows=1 width=0) (actual time=58.466..58.466 rows=0 loops=3)

  • Filter: ((site_id = 13) AND ("time" < clock_timestamp()) AND ("time" > (clock_timestamp() - '02:00:00'::interval)))
  • Rows Removed by Filter: 115
Planning time : 131.832 ms
Execution time : 413,076.084 ms