explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ECF4

Settings
# exclusive inclusive rows x rows loops node
1. 0.128 6,576.234 ↑ 40,902.9 473 1

Append (cost=0.03..97,594.16 rows=19,347,092 width=159) (actual time=6,576.003..6,576.234 rows=473 loops=1)

2. 166.339 166.738 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_1_chunk (cost=0.03..26.30 rows=769,000 width=143) (actual time=166.738..166.738 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 768492
3. 0.399 0.399 ↑ 1.0 769 1

Seq Scan on compress_hyper_2_80_chunk (cost=0.00..26.30 rows=769 width=152) (actual time=0.022..0.399 rows=769 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 135
4. 2,346.311 2,349.291 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_2_chunk (cost=0.03..79.09 rows=2,357,000 width=155) (actual time=2,349.291..2,349.291 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 2356306
5. 2.980 2.980 ↑ 1.0 2,357 1

Seq Scan on compress_hyper_2_81_chunk (cost=0.00..79.09 rows=2,357 width=152) (actual time=0.045..2.980 rows=2,357 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 370
6. 56.867 57.049 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_3_chunk (cost=0.04..8.41 rows=230,000 width=148) (actual time=57.049..57.049 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 229647
7. 0.182 0.182 ↑ 1.0 230 1

Seq Scan on compress_hyper_2_82_chunk (cost=0.00..8.41 rows=230 width=152) (actual time=0.015..0.182 rows=230 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 43
8. 55.879 56.065 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_4_chunk (cost=0.04..8.10 rows=209,000 width=151) (actual time=56.065..56.065 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 208991
9. 0.186 0.186 ↑ 1.0 209 1

Seq Scan on compress_hyper_2_83_chunk (cost=0.00..8.10 rows=209 width=152) (actual time=0.012..0.186 rows=209 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 39
10. 20.747 20.818 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_5_chunk (cost=0.04..3.23 rows=80,000 width=151) (actual time=20.818..20.818 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 79719
11. 0.071 0.071 ↑ 1.0 80 1

Seq Scan on compress_hyper_2_84_chunk (cost=0.00..3.23 rows=80 width=152) (actual time=0.010..0.071 rows=80 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 18
12. 29.262 29.383 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_6_chunk (cost=0.04..4.58 rows=104,000 width=153) (actual time=29.383..29.383 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 103909
13. 0.121 0.121 ↑ 1.0 104 1

Seq Scan on compress_hyper_2_85_chunk (cost=0.00..4.58 rows=104 width=152) (actual time=0.011..0.121 rows=104 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 22
14. 10.768 10.821 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_7_chunk (cost=2.36..2.36 rows=1,000 width=148) (actual time=10.821..10.821 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 38819
15. 0.053 0.053 ↓ 39.0 39 1

Index Scan using compress_hyper_2_86_chunk__compressed_hypertable_2_event__ts_me on compress_hyper_2_86_chunk (cost=0.14..2.36 rows=1 width=256) (actual time=0.011..0.053 rows=39 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
16. 4.405 4.430 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_8_chunk (cost=1.31..1.31 rows=1,000 width=142) (actual time=4.430..4.430 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 17334
17. 0.025 0.025 ↓ 18.0 18 1

Seq Scan on compress_hyper_2_87_chunk (cost=0.00..1.31 rows=1 width=256) (actual time=0.011..0.025 rows=18 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 7
18. 3.759 3.786 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_9_chunk (cost=1.29..1.29 rows=1,000 width=142) (actual time=3.786..3.786 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 14677
19. 0.027 0.027 ↓ 15.0 15 1

Seq Scan on compress_hyper_2_88_chunk (cost=0.00..1.29 rows=1 width=256) (actual time=0.014..0.027 rows=15 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 8
20. 3.341 3.361 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_10_chunk (cost=1.26..1.26 rows=1,000 width=143) (actual time=3.361..3.361 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 13352
21. 0.020 0.020 ↓ 14.0 14 1

Seq Scan on compress_hyper_2_89_chunk (cost=0.00..1.26 rows=1 width=256) (actual time=0.009..0.020 rows=14 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 7
22. 13.172 13.228 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_11_chunk (cost=0.05..2.77 rows=51,000 width=153) (actual time=13.228..13.228 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 50688
23. 0.056 0.056 ↑ 1.0 51 1

Seq Scan on compress_hyper_2_90_chunk (cost=0.00..2.77 rows=51 width=152) (actual time=0.010..0.056 rows=51 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 11
24. 2.168 2.183 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_12_chunk (cost=1.21..1.21 rows=1,000 width=143) (actual time=2.183..2.183 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 9415
25. 0.015 0.015 ↓ 10.0 10 1

Seq Scan on compress_hyper_2_91_chunk (cost=0.00..1.21 rows=1 width=256) (actual time=0.008..0.015 rows=10 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 7
26. 2.760 2.775 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_13_chunk (cost=1.26..1.26 rows=1,000 width=142) (actual time=2.775..2.775 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 12527
27. 0.015 0.015 ↓ 13.0 13 1

Seq Scan on compress_hyper_2_92_chunk (cost=0.00..1.26 rows=1 width=256) (actual time=0.007..0.015 rows=13 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 8
28. 8.505 8.534 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_14_chunk (cost=1.60..1.60 rows=1,000 width=145) (actual time=8.534..8.534 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 37653
29. 0.029 0.029 ↓ 38.0 38 1

Seq Scan on compress_hyper_2_93_chunk (cost=0.00..1.60 rows=1 width=256) (actual time=0.007..0.029 rows=38 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 10
30. 5.636 5.659 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_15_chunk (cost=1.44..1.44 rows=1,000 width=145) (actual time=5.659..5.659 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 24424
31. 0.023 0.023 ↓ 25.0 25 1

Seq Scan on compress_hyper_2_94_chunk (cost=0.00..1.44 rows=1 width=256) (actual time=0.009..0.023 rows=25 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 10
32. 52.609 52.778 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_16_chunk (cost=0.04..8.18 rows=214,000 width=155) (actual time=52.778..52.778 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 213841
33. 0.169 0.169 ↑ 1.0 214 1

Seq Scan on compress_hyper_2_95_chunk (cost=0.00..8.18 rows=214 width=152) (actual time=0.009..0.169 rows=214 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 40
34. 65.354 65.544 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_17_chunk (cost=0.04..10.09 rows=278,000 width=156) (actual time=65.544..65.544 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 277293
35. 0.190 0.190 ↑ 1.0 278 1

Seq Scan on compress_hyper_2_96_chunk (cost=0.00..10.09 rows=278 width=152) (actual time=0.018..0.190 rows=278 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 49
36. 31.794 31.917 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_18_chunk (cost=0.04..4.76 rows=120,000 width=153) (actual time=31.917..31.917 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 119162
37. 0.123 0.123 ↑ 1.0 120 1

Seq Scan on compress_hyper_2_97_chunk (cost=0.00..4.76 rows=120 width=152) (actual time=0.011..0.123 rows=120 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 21
38. 32.200 32.307 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_19_chunk (cost=0.04..5.20 rows=148,000 width=151) (actual time=32.307..32.307 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 147525
39. 0.107 0.107 ↑ 1.0 148 1

Seq Scan on compress_hyper_2_98_chunk (cost=0.00..5.20 rows=148 width=152) (actual time=0.011..0.107 rows=148 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 28
40. 43.222 43.371 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_20_chunk (cost=0.04..6.59 rows=175,000 width=153) (actual time=43.371..43.371 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 174791
41. 0.149 0.149 ↑ 1.0 175 1

Seq Scan on compress_hyper_2_99_chunk (cost=0.00..6.59 rows=175 width=152) (actual time=0.010..0.149 rows=175 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 32
42. 36.248 36.362 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_21_chunk (cost=0.04..6.25 rows=151,000 width=154) (actual time=36.362..36.362 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 150849
43. 0.114 0.114 ↑ 1.0 151 1

Seq Scan on compress_hyper_2_100_chunk (cost=0.00..6.25 rows=151 width=152) (actual time=0.011..0.114 rows=151 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 29
44. 27.024 27.115 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_22_chunk (cost=0.04..4.79 rows=119,000 width=154) (actual time=27.115..27.115 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 118116
45. 0.091 0.091 ↑ 1.0 119 1

Seq Scan on compress_hyper_2_101_chunk (cost=0.00..4.79 rows=119 width=152) (actual time=0.010..0.091 rows=119 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 24
46. 59.813 59.989 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_23_chunk (cost=0.03..8.74 rows=261,000 width=161) (actual time=59.989..59.989 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 260307
47. 0.176 0.176 ↑ 1.0 261 1

Seq Scan on compress_hyper_2_102_chunk (cost=0.00..8.74 rows=261 width=152) (actual time=0.022..0.176 rows=261 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 38
48. 31.640 31.733 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_24_chunk (cost=0.04..5.16 rows=147,000 width=158) (actual time=31.733..31.733 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 146971
49. 0.093 0.093 ↑ 1.0 147 1

Seq Scan on compress_hyper_2_103_chunk (cost=0.00..5.16 rows=147 width=124) (actual time=0.010..0.093 rows=147 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 26
50. 49.494 49.642 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_25_chunk (cost=0.04..8.21 rows=216,000 width=156) (actual time=49.642..49.642 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 215340
51. 0.148 0.148 ↑ 1.0 216 1

Seq Scan on compress_hyper_2_104_chunk (cost=0.00..8.21 rows=216 width=124) (actual time=0.011..0.148 rows=216 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 41
52. 62.894 63.079 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_26_chunk (cost=0.04..10.04 rows=275,000 width=156) (actual time=63.079..63.079 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 274072
53. 0.185 0.185 ↑ 1.0 275 1

Seq Scan on compress_hyper_2_105_chunk (cost=0.00..10.04 rows=275 width=152) (actual time=0.013..0.185 rows=275 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 48
54. 38.347 38.467 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_27_chunk (cost=0.04..6.55 rows=170,000 width=155) (actual time=38.467..38.467 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 169660
55. 0.120 0.120 ↑ 1.0 170 1

Seq Scan on compress_hyper_2_106_chunk (cost=0.00..6.55 rows=170 width=152) (actual time=0.020..0.120 rows=170 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 34
56. 88.071 88.364 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_28_chunk (cost=0.04..12.10 rows=339,000 width=157) (actual time=88.364..88.364 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 338945
57. 0.293 0.293 ↑ 1.0 339 1

Seq Scan on compress_hyper_2_107_chunk (cost=0.00..12.10 rows=339 width=152) (actual time=0.013..0.293 rows=339 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 69
58. 20.702 20.765 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_29_chunk (cost=0.04..3.42 rows=94,000 width=153) (actual time=20.764..20.765 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 93210
59. 0.063 0.063 ↑ 1.0 94 1

Seq Scan on compress_hyper_2_108_chunk (cost=0.00..3.42 rows=94 width=152) (actual time=0.009..0.063 rows=94 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 20
60. 62.212 62.394 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_30_chunk (cost=0.04..9.96 rows=271,000 width=161) (actual time=62.394..62.394 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 270713
61. 0.182 0.182 ↑ 1.0 271 1

Seq Scan on compress_hyper_2_109_chunk (cost=0.00..9.96 rows=271 width=152) (actual time=0.011..0.182 rows=271 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 46
62. 11.754 11.798 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_31_chunk (cost=0.05..2.85 rows=54,000 width=150) (actual time=11.798..11.798 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 53870
63. 0.044 0.044 ↑ 1.0 54 1

Seq Scan on compress_hyper_2_110_chunk (cost=0.00..2.85 rows=54 width=152) (actual time=0.013..0.044 rows=54 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 14
64. 6.722 6.751 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_32_chunk (cost=1.49..1.49 rows=1,000 width=152) (actual time=6.751..6.751 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 28745
65. 0.029 0.029 ↓ 29.0 29 1

Seq Scan on compress_hyper_2_111_chunk (cost=0.00..1.49 rows=1 width=256) (actual time=0.006..0.029 rows=29 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 10
66. 4.868 4.888 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_33_chunk (cost=1.41..1.41 rows=1,000 width=159) (actual time=4.888..4.888 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 23127
67. 0.020 0.020 ↓ 24.0 24 1

Seq Scan on compress_hyper_2_112_chunk (cost=0.00..1.41 rows=1 width=256) (actual time=0.006..0.020 rows=24 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 9
68. 22.294 22.367 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_34_chunk (cost=0.04..3.49 rows=95,000 width=153) (actual time=22.367..22.367 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 94893
69. 0.073 0.073 ↑ 1.0 95 1

Seq Scan on compress_hyper_2_113_chunk (cost=0.00..3.49 rows=95 width=152) (actual time=0.009..0.073 rows=95 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 24
70. 51.753 51.896 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_35_chunk (cost=0.04..8.69 rows=231,000 width=154) (actual time=51.896..51.896 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 230913
71. 0.143 0.143 ↑ 1.0 231 1

Seq Scan on compress_hyper_2_114_chunk (cost=0.00..8.69 rows=231 width=152) (actual time=0.013..0.143 rows=231 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 64
72. 163.579 164.100 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_36_chunk (cost=0.04..22.25 rows=599,000 width=160) (actual time=164.100..164.100 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 598763
73. 0.521 0.521 ↑ 1.0 599 1

Seq Scan on compress_hyper_2_115_chunk (cost=0.00..22.25 rows=599 width=152) (actual time=0.020..0.521 rows=599 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 141
74. 40.371 40.489 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_37_chunk (cost=0.04..6.74 rows=178,000 width=158) (actual time=40.489..40.489 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 177021
75. 0.118 0.118 ↑ 1.0 178 1

Seq Scan on compress_hyper_2_116_chunk (cost=0.00..6.74 rows=178 width=152) (actual time=0.011..0.118 rows=178 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 41
76. 103.784 104.089 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_38_chunk (cost=0.04..15.43 rows=424,000 width=163) (actual time=104.089..104.089 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 423743
77. 0.305 0.305 ↑ 1.0 424 1

Seq Scan on compress_hyper_2_117_chunk (cost=0.00..15.43 rows=424 width=152) (actual time=0.030..0.305 rows=424 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 90
78. 48.180 48.345 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_39_chunk (cost=0.04..7.97 rows=196,000 width=161) (actual time=48.345..48.345 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 195508
79. 0.165 0.165 ↑ 1.0 196 1

Seq Scan on compress_hyper_2_118_chunk (cost=0.00..7.97 rows=196 width=152) (actual time=0.015..0.165 rows=196 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 42
80. 16.799 16.891 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_40_chunk (cost=0.05..3.31 rows=70,000 width=159) (actual time=16.891..16.891 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 69175
81. 0.092 0.092 ↑ 1.0 70 1

Seq Scan on compress_hyper_2_119_chunk (cost=0.00..3.31 rows=70 width=152) (actual time=0.041..0.092 rows=70 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 35
82. 58.669 58.834 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_41_chunk (cost=0.04..10.39 rows=252,000 width=159) (actual time=58.834..58.834 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 251173
83. 0.165 0.165 ↑ 1.0 252 1

Seq Scan on compress_hyper_2_120_chunk (cost=0.00..10.39 rows=252 width=152) (actual time=0.011..0.165 rows=252 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 99
84. 53.036 53.206 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_42_chunk (cost=0.04..10.31 rows=231,000 width=162) (actual time=53.206..53.206 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 230516
85. 0.170 0.170 ↑ 1.0 231 1

Seq Scan on compress_hyper_2_121_chunk (cost=0.00..10.31 rows=231 width=152) (actual time=0.026..0.170 rows=231 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 114
86. 68.723 68.909 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_43_chunk (cost=0.04..13.56 rows=305,000 width=161) (actual time=68.909..68.909 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 304365
87. 0.186 0.186 ↑ 1.0 305 1

Seq Scan on compress_hyper_2_122_chunk (cost=0.00..13.56 rows=305 width=152) (actual time=0.016..0.186 rows=305 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 140
88. 97.460 97.739 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_44_chunk (cost=0.04..17.29 rows=400,000 width=160) (actual time=97.739..97.739 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 399057
89. 0.279 0.279 ↑ 1.0 400 1

Seq Scan on compress_hyper_2_123_chunk (cost=0.00..17.29 rows=400 width=152) (actual time=0.020..0.279 rows=400 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 183
90. 62.698 62.910 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_45_chunk (cost=0.05..11.85 rows=255,000 width=159) (actual time=62.909..62.910 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 254033
91. 0.212 0.212 ↑ 1.0 255 1

Seq Scan on compress_hyper_2_124_chunk (cost=0.00..11.85 rows=255 width=152) (actual time=0.013..0.212 rows=255 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 133
92. 60.051 60.250 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_46_chunk (cost=0.04..8.57 rows=206,000 width=162) (actual time=60.250..60.250 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 205602
93. 0.199 0.199 ↑ 1.0 206 1

Seq Scan on compress_hyper_2_125_chunk (cost=0.00..8.57 rows=206 width=152) (actual time=0.014..0.199 rows=206 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 80
94. 114.427 114.795 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_47_chunk (cost=0.04..17.36 rows=440,000 width=161) (actual time=114.795..114.795 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 439924
95. 0.368 0.368 ↑ 1.0 440 1

Seq Scan on compress_hyper_2_126_chunk (cost=0.00..17.36 rows=440 width=152) (actual time=0.019..0.368 rows=440 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 149
96. 87.485 87.821 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_48_chunk (cost=0.05..11.74 rows=246,000 width=160) (actual time=87.821..87.821 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 245993
97. 0.336 0.336 ↑ 1.0 246 1

Seq Scan on compress_hyper_2_127_chunk (cost=0.00..11.74 rows=246 width=152) (actual time=0.020..0.336 rows=246 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 133
98. 35.998 36.123 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_49_chunk (cost=0.05..4.88 rows=97,000 width=158) (actual time=36.123..36.123 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 96257
99. 0.125 0.125 ↑ 1.0 97 1

Seq Scan on compress_hyper_2_128_chunk (cost=0.00..4.88 rows=97 width=152) (actual time=0.018..0.125 rows=97 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 53
100. 66.252 66.463 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_50_chunk (cost=0.04..10.43 rows=237,000 width=153) (actual time=66.463..66.463 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 236486
101. 0.211 0.211 ↑ 1.0 237 1

Seq Scan on compress_hyper_2_129_chunk (cost=0.00..10.43 rows=237 width=152) (actual time=0.030..0.211 rows=237 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 117
102. 21.586 21.668 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_51_chunk (cost=0.05..4.96 rows=102,000 width=154) (actual time=21.668..21.668 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 101117
103. 0.082 0.082 ↑ 1.0 102 1

Seq Scan on compress_hyper_2_130_chunk (cost=0.00..4.96 rows=102 width=152) (actual time=0.012..0.082 rows=102 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 55
104. 57.373 57.520 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_52_chunk (cost=0.04..10.48 rows=261,000 width=157) (actual time=57.520..57.520 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 260856
105. 0.147 0.147 ↑ 1.0 261 1

Seq Scan on compress_hyper_2_131_chunk (cost=0.00..10.48 rows=261 width=152) (actual time=0.013..0.147 rows=261 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 97
106. 141.549 141.901 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_53_chunk (cost=0.04..24.59 rows=648,000 width=155) (actual time=141.901..141.901 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 647994
107. 0.352 0.352 ↑ 1.0 648 1

Seq Scan on compress_hyper_2_132_chunk (cost=0.00..24.59 rows=648 width=152) (actual time=0.021..0.352 rows=648 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 199
108. 79.498 79.754 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_54_chunk (cost=0.04..12.34 rows=323,000 width=150) (actual time=79.754..79.754 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 322355
109. 0.256 0.256 ↑ 1.0 323 1

Seq Scan on compress_hyper_2_133_chunk (cost=0.00..12.34 rows=323 width=152) (actual time=0.024..0.256 rows=323 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 104
110. 77.007 77.207 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_55_chunk (cost=0.04..13.80 rows=334,000 width=157) (actual time=77.207..77.207 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 333466
111. 0.200 0.200 ↑ 1.0 334 1

Seq Scan on compress_hyper_2_134_chunk (cost=0.00..13.80 rows=334 width=152) (actual time=0.018..0.200 rows=334 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 130
112. 92.259 92.496 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_56_chunk (cost=0.04..17.18 rows=404,000 width=155) (actual time=92.496..92.496 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 403304
113. 0.237 0.237 ↑ 1.0 404 1

Seq Scan on compress_hyper_2_135_chunk (cost=0.00..17.18 rows=404 width=152) (actual time=0.019..0.237 rows=404 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 170
114. 86.926 87.212 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_57_chunk (cost=0.04..13.59 rows=327,000 width=159) (actual time=87.211..87.212 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 326264
115. 0.286 0.286 ↑ 1.0 327 1

Seq Scan on compress_hyper_2_136_chunk (cost=0.00..13.59 rows=327 width=152) (actual time=0.017..0.286 rows=327 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 120
116. 32.943 33.034 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_58_chunk (cost=0.04..6.75 rows=153,000 width=161) (actual time=33.034..33.034 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 152087
117. 0.091 0.091 ↑ 1.0 153 1

Seq Scan on compress_hyper_2_137_chunk (cost=0.00..6.75 rows=153 width=152) (actual time=0.014..0.091 rows=153 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 67
118. 49.352 49.479 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_59_chunk (cost=0.05..9.89 rows=219,000 width=160) (actual time=49.479..49.479 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 218990
119. 0.127 0.127 ↑ 1.0 219 1

Seq Scan on compress_hyper_2_138_chunk (cost=0.00..9.89 rows=219 width=152) (actual time=0.011..0.127 rows=219 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 92
120. 13.192 13.235 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_60_chunk (cost=0.05..3.26 rows=61,000 width=162) (actual time=13.235..13.235 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 60332
121. 0.043 0.043 ↑ 1.0 61 1

Seq Scan on compress_hyper_2_139_chunk (cost=0.00..3.26 rows=61 width=152) (actual time=0.011..0.043 rows=61 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 40
122. 12.847 12.901 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_61_chunk (cost=0.08..4.44 rows=54,000 width=159) (actual time=12.901..12.901 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 53886
123. 0.054 0.054 ↑ 1.0 54 1

Seq Scan on compress_hyper_2_140_chunk (cost=0.00..4.44 rows=54 width=152) (actual time=0.008..0.054 rows=54 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 61
124. 11.439 11.482 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_62_chunk (cost=0.08..4.55 rows=54,000 width=159) (actual time=11.482..11.482 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 53780
125. 0.043 0.043 ↑ 1.0 54 1

Seq Scan on compress_hyper_2_141_chunk (cost=0.00..4.55 rows=54 width=152) (actual time=0.009..0.043 rows=54 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 70
126. 14.709 14.758 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_63_chunk (cost=0.07..4.74 rows=68,000 width=159) (actual time=14.758..14.758 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 67899
127. 0.049 0.049 ↑ 1.0 68 1

Seq Scan on compress_hyper_2_142_chunk (cost=0.00..4.74 rows=68 width=152) (actual time=0.008..0.049 rows=68 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 71
128. 7.084 7.119 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_64_chunk (cost=0.10..3.03 rows=30,000 width=159) (actual time=7.119..7.119 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 29876
129. 0.035 0.035 ↑ 1.0 30 1

Seq Scan on compress_hyper_2_143_chunk (cost=0.00..3.03 rows=30 width=152) (actual time=0.009..0.035 rows=30 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 52
130. 12.642 12.692 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_65_chunk (cost=0.08..4.46 rows=57,000 width=159) (actual time=12.692..12.692 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 56452
131. 0.050 0.050 ↑ 1.0 57 1

Seq Scan on compress_hyper_2_144_chunk (cost=0.00..4.46 rows=57 width=152) (actual time=0.008..0.050 rows=57 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 60
132. 45.653 45.779 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_66_chunk (cost=0.05..10.01 rows=205,000 width=161) (actual time=45.779..45.779 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 204440
133. 0.126 0.126 ↑ 1.0 205 1

Seq Scan on compress_hyper_2_145_chunk (cost=0.00..10.01 rows=205 width=152) (actual time=0.011..0.126 rows=205 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 116
134. 14.950 15.011 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_67_chunk (cost=0.08..4.94 rows=61,000 width=159) (actual time=15.011..15.011 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 60197
135. 0.061 0.061 ↑ 1.0 61 1

Index Scan using compress_hyper_2_146_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_146_chunk (cost=0.14..4.94 rows=61 width=152) (actual time=0.007..0.061 rows=61 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
136. 30.019 30.125 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_68_chunk (cost=0.06..8.72 rows=135,000 width=161) (actual time=30.125..30.125 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 134308
137. 0.106 0.106 ↑ 1.0 135 1

Index Scan using compress_hyper_2_147_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_147_chunk (cost=0.15..8.72 rows=135 width=152) (actual time=0.011..0.106 rows=135 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
138. 72.907 73.162 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_69_chunk (cost=0.06..17.02 rows=282,000 width=160) (actual time=73.162..73.162 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 281558
139. 0.255 0.255 ↑ 1.0 282 1

Index Scan using compress_hyper_2_148_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_148_chunk (cost=0.28..17.02 rows=282 width=152) (actual time=0.011..0.255 rows=282 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
140. 109.242 109.529 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_70_chunk (cost=0.05..23.29 rows=454,000 width=162) (actual time=109.529..109.529 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 453888
141. 0.287 0.287 ↑ 1.0 454 1

Index Scan using compress_hyper_2_149_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_149_chunk (cost=0.28..23.29 rows=454 width=152) (actual time=0.013..0.287 rows=454 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
142. 145.898 146.279 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_71_chunk (cost=0.05..30.60 rows=602,000 width=160) (actual time=146.279..146.279 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 601510
143. 0.381 0.381 ↑ 1.0 602 1

Index Scan using compress_hyper_2_183_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_183_chunk (cost=0.28..30.60 rows=602 width=152) (actual time=0.011..0.381 rows=602 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
144. 172.133 172.657 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_72_chunk (cost=0.05..34.13 rows=689,000 width=158) (actual time=172.657..172.657 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 688367
145. 0.524 0.524 ↑ 1.0 689 1

Index Scan using compress_hyper_2_185_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_185_chunk (cost=0.28..34.13 rows=689 width=152) (actual time=0.021..0.524 rows=689 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
146. 377.389 378.358 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_73_chunk (cost=0.05..68.13 rows=1,483,000 width=158) (actual time=378.358..378.358 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 1482261
147. 0.969 0.969 ↑ 1.0 1,483 1

Index Scan using compress_hyper_2_187_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_187_chunk (cost=0.28..68.13 rows=1,483 width=152) (actual time=0.010..0.969 rows=1,483 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
148. 149.635 150.108 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_74_chunk (cost=0.05..25.55 rows=523,000 width=161) (actual time=150.107..150.108 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 522426
149. 0.473 0.473 ↑ 1.0 523 1

Index Scan using compress_hyper_2_189_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_189_chunk (cost=0.28..25.55 rows=523 width=152) (actual time=0.013..0.473 rows=523 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
150. 43.126 43.253 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_75_chunk (cost=0.06..9.61 rows=162,000 width=160) (actual time=43.253..43.253 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 161214
151. 0.127 0.127 ↑ 1.0 162 1

Seq Scan on compress_hyper_2_191_chunk (cost=0.00..9.61 rows=162 width=152) (actual time=0.014..0.127 rows=162 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 127
152. 52.815 52.955 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_76_chunk (cost=0.06..12.53 rows=223,000 width=163) (actual time=52.955..52.955 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 222476
153. 0.140 0.140 ↑ 1.0 223 1

Index Scan using compress_hyper_2_193_chunk__compressed_hypertable_2_event__ts_m on compress_hyper_2_193_chunk (cost=0.27..12.53 rows=223 width=152) (actual time=0.013..0.140 rows=223 loops=1)

  • Index Cond: (event = 'page_view'::v1_event_name)
154. 29.479 29.571 ↓ 0.0 0 1

Custom Scan (DecompressChunk) on _hyper_1_77_chunk (cost=0.06..8.19 rows=129,000 width=162) (actual time=29.571..29.571 rows=0 loops=1)

  • Filter: (id > 33058000)
  • Rows Removed by Filter: 128368
155. 0.092 0.092 ↑ 1.0 129 1

Seq Scan on compress_hyper_2_197_chunk (cost=0.00..8.19 rows=129 width=152) (actual time=0.018..0.092 rows=129 loops=1)

  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 126
156. 0.010 0.010 ↓ 0.0 0 1

Index Scan using _hyper_1_78_chunk_v1_id_idx on _hyper_1_78_chunk (cost=0.42..1.54 rows=1 width=161) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
157. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_79_chunk_v1_id_idx on _hyper_1_79_chunk (cost=0.42..1.54 rows=1 width=161) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
158. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_182_chunk_v1_id_idx on _hyper_1_182_chunk (cost=0.42..1.55 rows=1 width=161) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
159. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_184_chunk_v1_id_idx on _hyper_1_184_chunk (cost=0.42..1.54 rows=1 width=158) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
160. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_186_chunk_v1_id_idx on _hyper_1_186_chunk (cost=0.42..1.54 rows=1 width=160) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
161. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_188_chunk_v1_id_idx on _hyper_1_188_chunk (cost=0.29..1.42 rows=1 width=158) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
162. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_190_chunk_v1_id_idx on _hyper_1_190_chunk (cost=0.29..1.41 rows=1 width=158) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
163. 0.004 0.004 ↓ 0.0 0 1

Index Scan using _hyper_1_192_chunk_v1_id_idx on _hyper_1_192_chunk (cost=0.29..1.41 rows=1 width=157) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
164. 0.004 0.004 ↓ 0.0 0 1

Index Scan using _hyper_1_194_chunk_v1_id_idx on _hyper_1_194_chunk (cost=0.29..1.41 rows=1 width=159) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
165. 0.197 0.197 ↓ 5.7 473 1

Index Scan using _hyper_1_198_chunk_v1_id_idx on _hyper_1_198_chunk (cost=0.42..10.35 rows=83 width=161) (actual time=0.012..0.197 rows=473 loops=1)

  • Index Cond: (id > 33058000)
  • Filter: (event = 'page_view'::v1_event_name)
  • Rows Removed by Filter: 300
Planning time : 11.765 ms
Execution time : 6,578.275 ms