explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WGO8

Settings
# exclusive inclusive rows x rows loops node
1. 0.850 543.825 ↓ 0.0 0 1

Update on aggregate_event_seating_quantitative_summary_change aesqsc1 (cost=25.10..97,814.80 rows=72 width=203) (actual time=543.825..543.825 rows=0 loops=1)

  • Update on aggregate_event_seating_quantitative_summary_change aesqsc1
  • Update on _hyper_2_1_chunk aesqsc1_1
  • Update on _hyper_2_2_chunk aesqsc1_2
  • Update on _hyper_2_3_chunk aesqsc1_3
  • Update on _hyper_2_4_chunk aesqsc1_4
  • Update on _hyper_2_5_chunk aesqsc1_5
  • Update on _hyper_2_6_chunk aesqsc1_6
  • Update on _hyper_2_7_chunk aesqsc1_7
  • Update on _hyper_2_8_chunk aesqsc1_8
  • Update on _hyper_2_9_chunk aesqsc1_9
  • Update on _hyper_2_10_chunk aesqsc1_10
  • Update on _hyper_2_11_chunk aesqsc1_11
  • Update on _hyper_2_12_chunk aesqsc1_12
  • Update on _hyper_2_13_chunk aesqsc1_13
  • Update on _hyper_2_14_chunk aesqsc1_14
  • Update on _hyper_2_15_chunk aesqsc1_15
  • Update on _hyper_2_16_chunk aesqsc1_16
  • Update on _hyper_2_17_chunk aesqsc1_17
  • Update on _hyper_2_18_chunk aesqsc1_18
  • Update on _hyper_2_19_chunk aesqsc1_19
  • Update on _hyper_2_20_chunk aesqsc1_20
  • Update on _hyper_2_21_chunk aesqsc1_21
  • Update on _hyper_2_22_chunk aesqsc1_22
  • Update on _hyper_2_23_chunk aesqsc1_23
  • Update on _hyper_2_24_chunk aesqsc1_24
  • Update on _hyper_2_25_chunk aesqsc1_25
  • Update on _hyper_2_26_chunk aesqsc1_26
  • Update on _hyper_2_27_chunk aesqsc1_27
  • Update on _hyper_2_28_chunk aesqsc1_28
  • Update on _hyper_2_29_chunk aesqsc1_29
  • Update on _hyper_2_30_chunk aesqsc1_30
  • Update on _hyper_2_31_chunk aesqsc1_31
  • Update on _hyper_2_32_chunk aesqsc1_32
  • Update on _hyper_2_33_chunk aesqsc1_33
  • Update on _hyper_2_34_chunk aesqsc1_34
  • Update on _hyper_2_35_chunk aesqsc1_35
  • Update on _hyper_2_36_chunk aesqsc1_36
  • Update on _hyper_2_37_chunk aesqsc1_37
  • Update on _hyper_2_38_chunk aesqsc1_38
  • Update on _hyper_2_39_chunk aesqsc1_39
  • Update on _hyper_2_40_chunk aesqsc1_40
  • Update on _hyper_2_41_chunk aesqsc1_41
  • Update on _hyper_2_42_chunk aesqsc1_42
  • Update on _hyper_2_43_chunk aesqsc1_43
  • Update on _hyper_2_44_chunk aesqsc1_44
  • Update on _hyper_2_45_chunk aesqsc1_45
  • Update on _hyper_2_46_chunk aesqsc1_46
  • Update on _hyper_2_47_chunk aesqsc1_47
  • Update on _hyper_2_48_chunk aesqsc1_48
  • Update on _hyper_2_49_chunk aesqsc1_49
  • Update on _hyper_2_50_chunk aesqsc1_50
  • Update on _hyper_2_51_chunk aesqsc1_51
  • Update on _hyper_2_52_chunk aesqsc1_52
  • Update on _hyper_2_53_chunk aesqsc1_53
  • Update on _hyper_2_54_chunk aesqsc1_54
  • Update on _hyper_2_55_chunk aesqsc1_55
  • Update on _hyper_2_56_chunk aesqsc1_56
  • Update on _hyper_2_57_chunk aesqsc1_57
  • Update on _hyper_2_58_chunk aesqsc1_58
  • Update on _hyper_2_59_chunk aesqsc1_59
  • Update on _hyper_2_60_chunk aesqsc1_60
  • Update on _hyper_2_61_chunk aesqsc1_61
  • Update on _hyper_2_62_chunk aesqsc1_62
  • Update on _hyper_2_63_chunk aesqsc1_63
  • Update on _hyper_2_64_chunk aesqsc1_64
  • Update on _hyper_2_65_chunk aesqsc1_65
  • Update on _hyper_2_66_chunk aesqsc1_66
  • Update on _hyper_2_67_chunk aesqsc1_67
  • Update on _hyper_2_68_chunk aesqsc1_68
  • Update on _hyper_2_69_chunk aesqsc1_69
  • Update on _hyper_2_70_chunk aesqsc1_70
  • Update on _hyper_2_71_chunk aesqsc1_71
2. 0.046 0.055 ↓ 0.0 0 1

Hash Join (cost=25.10..1,230.63 rows=1 width=228) (actual time=0.055..0.055 rows=0 loops=1)

  • Hash Cond: ((aesqsc3.event_start_time = aesqsc1.event_start_time) AND (aesqsc3.event_id = aesqsc1.event_id) AND (aesqsc3.created_at = aesqsc1.created_at))
3. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aesqsc3 (cost=25.09..1,229.47 rows=100 width=144) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Limit (cost=25.09..1,228.47 rows=100 width=112) (never executed)

5. 0.000 0.000 ↓ 0.0 0

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (never executed)

  • Sort Key: aesqsc2.event_start_time
14. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2 (cost=0.12..1.55 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
15. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_1 (cost=0.29..995.56 rows=147 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
16. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_2 (cost=0.42..4,484.31 rows=664 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
17. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_3 (cost=0.29..3,066.35 rows=459 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
18. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_4 (cost=0.28..64.38 rows=8 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
19. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_5 (cost=0.43..75,480.77 rows=11,432 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
20. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_6 (cost=0.42..4,212.36 rows=635 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
21. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_7 (cost=0.43..37,824.05 rows=5,696 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
22. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_8 (cost=0.29..3,499.03 rows=517 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
23. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_9 (cost=0.42..7,063.48 rows=1,064 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
24. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_10 (cost=0.29..3,125.85 rows=455 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
25. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_11 (cost=0.42..7,352.03 rows=1,108 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
26. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_12 (cost=0.42..5,603.34 rows=847 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
27. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_13 (cost=0.42..6,880.68 rows=1,038 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
28. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_14 (cost=0.29..3,428.40 rows=512 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
29. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_15 (cost=0.29..563.12 rows=76 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
30. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_16 (cost=0.29..861.10 rows=121 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
31. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_17 (cost=0.29..3,082.77 rows=464 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
32. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_18 (cost=0.43..44,605.53 rows=6,745 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
33. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_19 (cost=0.42..7,375.15 rows=1,115 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
34. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_20 (cost=0.28..92.58 rows=9 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
35. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_21 (cost=0.42..4,235.63 rows=638 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
36. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_22 (cost=0.42..8,108.72 rows=1,220 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
37. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_23 (cost=0.43..52,385.16 rows=7,926 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
38. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_24 (cost=0.42..5,145.72 rows=776 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
39. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_25 (cost=0.28..102.68 rows=10 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
40. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_26_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_26_chunk aesqsc2_26 (cost=0.42..6,121.80 rows=924 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
41. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_27_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_27_chunk aesqsc2_27 (cost=0.42..7,463.26 rows=1,127 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
42. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_28_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_28_chunk aesqsc2_28 (cost=0.28..62.12 rows=7 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
43. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_29_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_29_chunk aesqsc2_29 (cost=0.43..35,537.41 rows=5,374 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
44. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_30_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_30_chunk aesqsc2_30 (cost=0.27..25.37 rows=2 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
45. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_31_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_31_chunk aesqsc2_31 (cost=0.28..45.18 rows=5 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
46. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_32_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_32_chunk aesqsc2_32 (cost=0.28..42.16 rows=4 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
47. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_33_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_33_chunk aesqsc2_33 (cost=0.42..9,067.17 rows=1,366 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
48. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_34_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_34_chunk aesqsc2_34 (cost=0.29..433.80 rows=57 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
49. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_35_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_35_chunk aesqsc2_35 (cost=0.43..48,709.67 rows=7,378 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
50. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_36_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_36_chunk aesqsc2_36 (cost=0.28..35.38 rows=3 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
51. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_37_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_37_chunk aesqsc2_37 (cost=0.42..30,801.22 rows=4,657 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
52. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_38_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_38_chunk aesqsc2_38 (cost=0.43..40,860.67 rows=6,178 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
53. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_39_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_39_chunk aesqsc2_39 (cost=0.28..64.15 rows=6 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
54. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_40_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_40_chunk aesqsc2_40 (cost=0.43..35,846.74 rows=5,415 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
55. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_41_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_41_chunk aesqsc2_41 (cost=0.42..10,251.53 rows=1,549 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
56. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_42_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_42_chunk aesqsc2_42 (cost=0.15..12.23 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
57. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_43_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_43_chunk aesqsc2_43 (cost=0.42..33,107.98 rows=5,010 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
58. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_44_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_44_chunk aesqsc2_44 (cost=0.29..2,600.41 rows=377 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
59. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_45_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_45_chunk aesqsc2_45 (cost=0.43..36,798.88 rows=5,543 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
60. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_46_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_46_chunk aesqsc2_46 (cost=0.14..4.08 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
61. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_47_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_47_chunk aesqsc2_47 (cost=0.27..23.22 rows=2 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
62. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_48_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_48_chunk aesqsc2_48 (cost=0.28..35.09 rows=5 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
63. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_49_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_49_chunk aesqsc2_49 (cost=0.28..43.29 rows=6 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
64. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_50_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_50_chunk aesqsc2_50 (cost=0.28..52.82 rows=7 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
65. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_51_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_51_chunk aesqsc2_51 (cost=0.15..12.93 rows=2 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
66. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_52_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_52_chunk aesqsc2_52 (cost=0.27..20.65 rows=2 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
67. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_53_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_53_chunk aesqsc2_53 (cost=0.14..3.47 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
68. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_54_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_54_chunk aesqsc2_54 (cost=0.15..14.71 rows=2 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
69. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_55_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_55_chunk aesqsc2_55 (cost=0.42..4,099.50 rows=620 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
70. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_56_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_56_chunk aesqsc2_56 (cost=0.14..3.79 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
71. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_57_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_57_chunk aesqsc2_57 (cost=0.13..3.17 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
72. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_58_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_58_chunk aesqsc2_58 (cost=0.14..7.12 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
73. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_59_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_59_chunk aesqsc2_59 (cost=0.14..3.27 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
74. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_60_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_60_chunk aesqsc2_60 (cost=0.13..3.24 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
75. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_61_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_61_chunk aesqsc2_61 (cost=0.14..3.48 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
76. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_62_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_62_chunk aesqsc2_62 (cost=0.14..6.72 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
77. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_63_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_63_chunk aesqsc2_63 (cost=0.14..3.41 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
78. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_64_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_64_chunk aesqsc2_64 (cost=0.13..3.21 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
79. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_65_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_65_chunk aesqsc2_65 (cost=0.13..3.19 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
80. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_66_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_66_chunk aesqsc2_66 (cost=0.13..3.16 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
81. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_67_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_67_chunk aesqsc2_67 (cost=0.13..3.17 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
82. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_68_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_68_chunk aesqsc2_68 (cost=0.13..3.17 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
83. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_69_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_69_chunk aesqsc2_69 (cost=0.13..3.17 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
84. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_70_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_70_chunk aesqsc2_70 (cost=0.13..3.16 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
85. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_2_71_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_71_chunk aesqsc2_71 (cost=0.13..3.16 rows=1 width=30) (never executed)

  • Filter: (materialized_at IS NULL)
86. 0.000 0.000 ↓ 0.0 0

Index Scan using event_pkey on event e1 (cost=0.43..1.47 rows=1 width=14) (never executed)

  • Index Cond: (id = aesqsc2.event_id)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using venue_pkey on venue v1 (cost=0.28..0.30 rows=1 width=18) (never executed)

  • Index Cond: (id = e1.venue_id)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using cinema_pkey on cinema c1 (cost=0.27..0.30 rows=1 width=10) (never executed)

  • Index Cond: (id = v1.cinema_id)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using locality_pkey on locality l1 (cost=0.28..0.31 rows=1 width=14) (never executed)

  • Index Cond: (id = v1.locality_id)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using google_place_pkey on google_place gp1 (cost=0.29..0.54 rows=1 width=14) (never executed)

  • Index Cond: (id = l1.google_place_id)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using country_pkey on country c2 (cost=0.14..0.16 rows=1 width=10) (never executed)

  • Index Cond: (id = gp1.country_id)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using locality_weather_measurement_locality_id_time_idx on locality_weather_measurement lwm1 (cost=0.43..2.26 rows=1 width=30) (never executed)

  • Index Cond: ((locality_id = l1.id) AND (date_trunc('hour'::text, aesqsc2.created_at) = measurement_time))
93. 0.001 0.009 ↓ 0.0 0 1

Hash (cost=0.00..0.00 rows=1 width=102) (actual time=0.009..0.009 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
94. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on aggregate_event_seating_quantitative_summary_change aesqsc1 (cost=0.00..0.00 rows=1 width=102) (actual time=0.008..0.008 rows=0 loops=1)

95. 0.129 12.246 ↓ 100.0 100 1

Nested Loop (cost=25.37..1,422.48 rows=1 width=208) (actual time=3.181..12.246 rows=100 loops=1)

96. 0.144 6.817 ↑ 1.0 100 1

Subquery Scan on aesqsc3_1 (cost=25.09..1,229.47 rows=100 width=144) (actual time=3.130..6.817 rows=100 loops=1)

97. 0.062 6.673 ↑ 1.0 100 1

Limit (cost=25.09..1,228.47 rows=100 width=112) (actual time=3.116..6.673 rows=100 loops=1)

98. 0.309 6.611 ↑ 893.3 100 1

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (actual time=3.114..6.611 rows=100 loops=1)

99. 0.185 6.302 ↑ 893.3 100 1

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (actual time=3.073..6.302 rows=100 loops=1)

100. 0.067 5.617 ↑ 893.3 100 1

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (actual time=3.009..5.617 rows=100 loops=1)

101. 0.111 5.350 ↑ 893.3 100 1

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (actual time=2.989..5.350 rows=100 loops=1)

102. 0.137 4.939 ↑ 893.3 100 1

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (actual time=2.928..4.939 rows=100 loops=1)

103. 0.043 4.502 ↑ 893.3 100 1

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (actual time=2.903..4.502 rows=100 loops=1)

104. 0.128 4.159 ↑ 893.3 100 1

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (actual time=2.884..4.159 rows=100 loops=1)

105. 0.108 3.731 ↑ 893.3 100 1

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (actual time=2.853..3.731 rows=100 loops=1)

106. 0.084 3.023 ↑ 893.3 100 1

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (actual time=2.766..3.023 rows=100 loops=1)

  • Sort Key: aesqsc2_72.event_start_time
107. 0.018 0.018 ↓ 0.0 0 1

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2_72 (cost=0.12..1.55 rows=1 width=30) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: (materialized_at IS NULL)
108. 0.309 0.309 ↑ 1.5 100 1

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_73 (cost=0.29..995.56 rows=147 width=30) (actual time=0.081..0.309 rows=100 loops=1)

  • Filter: (materialized_at IS NULL)
109. 0.053 0.053 ↑ 664.0 1 1

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_74 (cost=0.42..4,484.31 rows=664 width=30) (actual time=0.053..0.053 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
110. 0.049 0.049 ↑ 459.0 1 1

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_75 (cost=0.29..3,066.35 rows=459 width=30) (actual time=0.049..0.049 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
111. 0.042 0.042 ↑ 8.0 1 1

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_76 (cost=0.28..64.38 rows=8 width=30) (actual time=0.042..0.042 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
112. 0.053 0.053 ↑ 11,432.0 1 1

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_77 (cost=0.43..75,480.77 rows=11,432 width=30) (actual time=0.053..0.053 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
113. 0.046 0.046 ↑ 635.0 1 1

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_78 (cost=0.42..4,212.36 rows=635 width=30) (actual time=0.046..0.046 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
114. 0.044 0.044 ↑ 5,696.0 1 1

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_79 (cost=0.43..37,824.05 rows=5,696 width=30) (actual time=0.043..0.044 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
115. 0.044 0.044 ↑ 517.0 1 1

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_80 (cost=0.29..3,499.03 rows=517 width=30) (actual time=0.044..0.044 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
116. 0.060 0.060 ↑ 1,064.0 1 1

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_81 (cost=0.42..7,063.48 rows=1,064 width=30) (actual time=0.060..0.060 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
117. 0.037 0.037 ↑ 455.0 1 1

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_82 (cost=0.29..3,125.85 rows=455 width=30) (actual time=0.037..0.037 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
118. 0.048 0.048 ↑ 1,108.0 1 1

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_83 (cost=0.42..7,352.03 rows=1,108 width=30) (actual time=0.048..0.048 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
119. 0.047 0.047 ↑ 847.0 1 1

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_84 (cost=0.42..5,603.34 rows=847 width=30) (actual time=0.047..0.047 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
120. 0.041 0.041 ↑ 1,038.0 1 1

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_85 (cost=0.42..6,880.68 rows=1,038 width=30) (actual time=0.041..0.041 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
121. 0.045 0.045 ↑ 512.0 1 1

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_86 (cost=0.29..3,428.40 rows=512 width=30) (actual time=0.045..0.045 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
122. 0.025 0.025 ↑ 76.0 1 1

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_87 (cost=0.29..563.12 rows=76 width=30) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
123. 0.028 0.028 ↑ 121.0 1 1

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_88 (cost=0.29..861.10 rows=121 width=30) (actual time=0.027..0.028 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
124. 0.051 0.051 ↑ 464.0 1 1

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_89 (cost=0.29..3,082.77 rows=464 width=30) (actual time=0.050..0.051 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
125. 0.057 0.057 ↑ 6,745.0 1 1

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_90 (cost=0.43..44,605.53 rows=6,745 width=30) (actual time=0.057..0.057 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
126. 0.056 0.056 ↑ 1,115.0 1 1

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_91 (cost=0.42..7,375.15 rows=1,115 width=30) (actual time=0.056..0.056 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
127. 0.049 0.049 ↑ 9.0 1 1

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_92 (cost=0.28..92.58 rows=9 width=30) (actual time=0.049..0.049 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
128. 0.039 0.039 ↑ 638.0 1 1

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_93 (cost=0.42..4,235.63 rows=638 width=30) (actual time=0.039..0.039 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
129. 0.053 0.053 ↑ 1,220.0 1 1

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_94 (cost=0.42..8,108.72 rows=1,220 width=30) (actual time=0.053..0.053 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
130. 0.041 0.041 ↑ 7,926.0 1 1

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_95 (cost=0.43..52,385.16 rows=7,926 width=30) (actual time=0.041..0.041 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
131. 0.047 0.047 ↑ 776.0 1 1

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_96 (cost=0.42..5,145.72 rows=776 width=30) (actual time=0.046..0.047 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
132. 0.033 0.033 ↑ 10.0 1 1

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_97 (cost=0.28..102.68 rows=10 width=30) (actual time=0.033..0.033 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
133. 0.047 0.047 ↑ 924.0 1 1

Index Scan Backward using _hyper_2_26_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_26_chunk aesqsc2_98 (cost=0.42..6,121.80 rows=924 width=30) (actual time=0.047..0.047 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
134. 0.044 0.044 ↑ 1,127.0 1 1

Index Scan Backward using _hyper_2_27_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_27_chunk aesqsc2_99 (cost=0.42..7,463.26 rows=1,127 width=30) (actual time=0.044..0.044 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
135. 0.033 0.033 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_28_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_28_chunk aesqsc2_100 (cost=0.28..62.12 rows=7 width=30) (actual time=0.033..0.033 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
136. 0.054 0.054 ↑ 5,374.0 1 1

Index Scan Backward using _hyper_2_29_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_29_chunk aesqsc2_101 (cost=0.43..35,537.41 rows=5,374 width=30) (actual time=0.054..0.054 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
137. 0.027 0.027 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_30_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_30_chunk aesqsc2_102 (cost=0.27..25.37 rows=2 width=30) (actual time=0.027..0.027 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
138. 0.030 0.030 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_31_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_31_chunk aesqsc2_103 (cost=0.28..45.18 rows=5 width=30) (actual time=0.030..0.030 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
139. 0.025 0.025 ↑ 4.0 1 1

Index Scan Backward using _hyper_2_32_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_32_chunk aesqsc2_104 (cost=0.28..42.16 rows=4 width=30) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
140. 0.053 0.053 ↑ 1,366.0 1 1

Index Scan Backward using _hyper_2_33_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_33_chunk aesqsc2_105 (cost=0.42..9,067.17 rows=1,366 width=30) (actual time=0.053..0.053 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
141. 0.048 0.048 ↑ 57.0 1 1

Index Scan Backward using _hyper_2_34_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_34_chunk aesqsc2_106 (cost=0.29..433.80 rows=57 width=30) (actual time=0.048..0.048 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
142. 0.043 0.043 ↑ 7,378.0 1 1

Index Scan Backward using _hyper_2_35_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_35_chunk aesqsc2_107 (cost=0.43..48,709.67 rows=7,378 width=30) (actual time=0.043..0.043 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
143. 0.032 0.032 ↑ 3.0 1 1

Index Scan Backward using _hyper_2_36_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_36_chunk aesqsc2_108 (cost=0.28..35.38 rows=3 width=30) (actual time=0.032..0.032 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
144. 0.049 0.049 ↑ 4,657.0 1 1

Index Scan Backward using _hyper_2_37_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_37_chunk aesqsc2_109 (cost=0.42..30,801.22 rows=4,657 width=30) (actual time=0.049..0.049 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
145. 0.041 0.041 ↑ 6,178.0 1 1

Index Scan Backward using _hyper_2_38_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_38_chunk aesqsc2_110 (cost=0.43..40,860.67 rows=6,178 width=30) (actual time=0.041..0.041 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
146. 0.057 0.057 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_39_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_39_chunk aesqsc2_111 (cost=0.28..64.15 rows=6 width=30) (actual time=0.057..0.057 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
147. 0.070 0.070 ↑ 5,415.0 1 1

Index Scan Backward using _hyper_2_40_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_40_chunk aesqsc2_112 (cost=0.43..35,846.74 rows=5,415 width=30) (actual time=0.070..0.070 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
148. 0.036 0.036 ↑ 1,549.0 1 1

Index Scan Backward using _hyper_2_41_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_41_chunk aesqsc2_113 (cost=0.42..10,251.53 rows=1,549 width=30) (actual time=0.035..0.036 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
149. 0.037 0.037 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_42_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_42_chunk aesqsc2_114 (cost=0.15..12.23 rows=1 width=30) (actual time=0.037..0.037 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
150. 0.058 0.058 ↑ 5,010.0 1 1

Index Scan Backward using _hyper_2_43_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_43_chunk aesqsc2_115 (cost=0.42..33,107.98 rows=5,010 width=30) (actual time=0.057..0.058 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
151. 0.044 0.044 ↑ 377.0 1 1

Index Scan Backward using _hyper_2_44_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_44_chunk aesqsc2_116 (cost=0.29..2,600.41 rows=377 width=30) (actual time=0.044..0.044 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
152. 0.054 0.054 ↑ 5,543.0 1 1

Index Scan Backward using _hyper_2_45_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_45_chunk aesqsc2_117 (cost=0.43..36,798.88 rows=5,543 width=30) (actual time=0.054..0.054 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
153. 0.022 0.022 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_46_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_46_chunk aesqsc2_118 (cost=0.14..4.08 rows=1 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
154. 0.028 0.028 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_47_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_47_chunk aesqsc2_119 (cost=0.27..23.22 rows=2 width=30) (actual time=0.028..0.028 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
155. 0.036 0.036 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_48_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_48_chunk aesqsc2_120 (cost=0.28..35.09 rows=5 width=30) (actual time=0.036..0.036 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
156. 0.026 0.026 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_49_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_49_chunk aesqsc2_121 (cost=0.28..43.29 rows=6 width=30) (actual time=0.026..0.026 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
157. 0.026 0.026 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_50_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_50_chunk aesqsc2_122 (cost=0.28..52.82 rows=7 width=30) (actual time=0.026..0.026 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
158. 0.038 0.038 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_51_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_51_chunk aesqsc2_123 (cost=0.15..12.93 rows=2 width=30) (actual time=0.038..0.038 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
159. 0.025 0.025 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_52_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_52_chunk aesqsc2_124 (cost=0.27..20.65 rows=2 width=30) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
160. 0.031 0.031 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_53_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_53_chunk aesqsc2_125 (cost=0.14..3.47 rows=1 width=30) (actual time=0.031..0.031 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
161. 0.028 0.028 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_54_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_54_chunk aesqsc2_126 (cost=0.15..14.71 rows=2 width=30) (actual time=0.028..0.028 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
162. 0.042 0.042 ↑ 620.0 1 1

Index Scan Backward using _hyper_2_55_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_55_chunk aesqsc2_127 (cost=0.42..4,099.50 rows=620 width=30) (actual time=0.042..0.042 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
163. 0.023 0.023 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_56_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_56_chunk aesqsc2_128 (cost=0.14..3.79 rows=1 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
164. 0.027 0.027 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_57_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_57_chunk aesqsc2_129 (cost=0.13..3.17 rows=1 width=30) (actual time=0.027..0.027 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
165. 0.020 0.020 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_58_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_58_chunk aesqsc2_130 (cost=0.14..7.12 rows=1 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
166. 0.030 0.030 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_59_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_59_chunk aesqsc2_131 (cost=0.14..3.27 rows=1 width=30) (actual time=0.030..0.030 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
167. 0.017 0.017 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_60_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_60_chunk aesqsc2_132 (cost=0.13..3.24 rows=1 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
168. 0.017 0.017 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_61_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_61_chunk aesqsc2_133 (cost=0.14..3.48 rows=1 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
169. 0.025 0.025 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_62_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_62_chunk aesqsc2_134 (cost=0.14..6.72 rows=1 width=30) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
170. 0.028 0.028 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_63_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_63_chunk aesqsc2_135 (cost=0.14..3.41 rows=1 width=30) (actual time=0.028..0.028 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
171. 0.023 0.023 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_64_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_64_chunk aesqsc2_136 (cost=0.13..3.21 rows=1 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
172. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_65_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_65_chunk aesqsc2_137 (cost=0.13..3.19 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
173. 0.022 0.022 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_66_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_66_chunk aesqsc2_138 (cost=0.13..3.16 rows=1 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
174. 0.017 0.017 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_67_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_67_chunk aesqsc2_139 (cost=0.13..3.17 rows=1 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
175. 0.016 0.016 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_68_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_68_chunk aesqsc2_140 (cost=0.13..3.17 rows=1 width=30) (actual time=0.015..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
176. 0.018 0.018 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_69_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_69_chunk aesqsc2_141 (cost=0.13..3.17 rows=1 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
177. 0.022 0.022 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_70_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_70_chunk aesqsc2_142 (cost=0.13..3.16 rows=1 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
178. 0.023 0.023 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_71_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_71_chunk aesqsc2_143 (cost=0.13..3.16 rows=1 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
179. 0.600 0.600 ↑ 1.0 1 100

Index Scan using event_pkey on event e1_1 (cost=0.43..1.47 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=100)

  • Index Cond: (id = aesqsc2_72.event_id)
180. 0.300 0.300 ↑ 1.0 1 100

Index Scan using venue_pkey on venue v1_1 (cost=0.28..0.30 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = e1_1.venue_id)
181. 0.300 0.300 ↑ 1.0 1 100

Index Scan using cinema_pkey on cinema c1_1 (cost=0.27..0.30 rows=1 width=10) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = v1_1.cinema_id)
182. 0.300 0.300 ↑ 1.0 1 100

Index Scan using locality_pkey on locality l1_1 (cost=0.28..0.31 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = v1_1.locality_id)
183. 0.300 0.300 ↑ 1.0 1 100

Index Scan using google_place_pkey on google_place gp1_1 (cost=0.29..0.54 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = l1_1.google_place_id)
184. 0.200 0.200 ↑ 1.0 1 100

Index Scan using country_pkey on country c2_1 (cost=0.14..0.16 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (id = gp1_1.country_id)
185. 0.500 0.500 ↓ 0.0 0 100

Index Scan using locality_weather_measurement_locality_id_time_idx on locality_weather_measurement lwm1_1 (cost=0.43..2.26 rows=1 width=30) (actual time=0.005..0.005 rows=0 loops=100)

  • Index Cond: ((locality_id = l1_1.id) AND (date_trunc('hour'::text, aesqsc2_72.created_at) = measurement_time))
186. 5.300 5.300 ↑ 1.0 1 100

Index Scan using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summary_2 on _hyper_2_1_chunk aesqsc1_1 (cost=0.29..1.92 rows=1 width=102) (actual time=0.051..0.053 rows=1 loops=100)

  • Index Cond: ((event_id = aesqsc3_1.event_id) AND (created_at = aesqsc3_1.created_at))
  • Filter: (aesqsc3_1.event_start_time = event_start_time)
187. 0.125 102.502 ↓ 0.0 0 1

Nested Loop (cost=25.51..1,464.73 rows=1 width=208) (actual time=102.502..102.502 rows=0 loops=1)

188. 0.112 9.277 ↑ 1.0 100 1

Subquery Scan on aesqsc3_2 (cost=25.09..1,229.47 rows=100 width=144) (actual time=4.335..9.277 rows=100 loops=1)

189. 0.058 9.165 ↑ 1.0 100 1

Limit (cost=25.09..1,228.47 rows=100 width=112) (actual time=4.313..9.165 rows=100 loops=1)

190. 0.412 9.107 ↑ 893.3 100 1

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (actual time=4.312..9.107 rows=100 loops=1)

191. 0.317 8.695 ↑ 446.6 200 1

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (actual time=1.644..8.695 rows=200 loops=1)

192. 0.126 7.378 ↑ 446.6 200 1

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (actual time=1.618..7.378 rows=200 loops=1)

193. 0.168 6.852 ↑ 446.6 200 1

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (actual time=1.601..6.852 rows=200 loops=1)

194. 0.152 6.084 ↑ 446.6 200 1

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (actual time=1.581..6.084 rows=200 loops=1)

195. 0.224 5.132 ↑ 446.6 200 1

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (actual time=1.564..5.132 rows=200 loops=1)

196. 0.214 4.508 ↑ 446.6 200 1

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (actual time=1.546..4.508 rows=200 loops=1)

197. 0.236 3.694 ↑ 446.6 200 1

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (actual time=1.522..3.694 rows=200 loops=1)

198. 0.097 1.858 ↑ 446.6 200 1

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (actual time=1.500..1.858 rows=200 loops=1)

  • Sort Key: aesqsc2_144.event_start_time
199. 0.032 0.032 ↓ 0.0 0 1

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2_144 (cost=0.12..1.55 rows=1 width=30) (actual time=0.032..0.032 rows=0 loops=1)

  • Filter: (materialized_at IS NULL)
200. 0.332 0.332 ↓ 1.4 200 1

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_145 (cost=0.29..995.56 rows=147 width=30) (actual time=0.038..0.332 rows=200 loops=1)

  • Filter: (materialized_at IS NULL)
201. 0.023 0.023 ↑ 664.0 1 1

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_146 (cost=0.42..4,484.31 rows=664 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
202. 0.027 0.027 ↑ 459.0 1 1

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_147 (cost=0.29..3,066.35 rows=459 width=30) (actual time=0.027..0.027 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
203. 0.020 0.020 ↑ 8.0 1 1

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_148 (cost=0.28..64.38 rows=8 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
204. 0.026 0.026 ↑ 11,432.0 1 1

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_149 (cost=0.43..75,480.77 rows=11,432 width=30) (actual time=0.026..0.026 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
205. 0.020 0.020 ↑ 635.0 1 1

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_150 (cost=0.42..4,212.36 rows=635 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
206. 0.020 0.020 ↑ 5,696.0 1 1

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_151 (cost=0.43..37,824.05 rows=5,696 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
207. 0.017 0.017 ↑ 517.0 1 1

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_152 (cost=0.29..3,499.03 rows=517 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
208. 0.020 0.020 ↑ 1,064.0 1 1

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_153 (cost=0.42..7,063.48 rows=1,064 width=30) (actual time=0.019..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
209. 0.022 0.022 ↑ 455.0 1 1

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_154 (cost=0.29..3,125.85 rows=455 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
210. 0.037 0.037 ↑ 1,108.0 1 1

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_155 (cost=0.42..7,352.03 rows=1,108 width=30) (actual time=0.037..0.037 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
211. 0.020 0.020 ↑ 847.0 1 1

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_156 (cost=0.42..5,603.34 rows=847 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
212. 0.020 0.020 ↑ 1,038.0 1 1

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_157 (cost=0.42..6,880.68 rows=1,038 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
213. 0.019 0.019 ↑ 512.0 1 1

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_158 (cost=0.29..3,428.40 rows=512 width=30) (actual time=0.018..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
214. 0.018 0.018 ↑ 76.0 1 1

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_159 (cost=0.29..563.12 rows=76 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
215. 0.014 0.014 ↑ 121.0 1 1

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_160 (cost=0.29..861.10 rows=121 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
216. 0.017 0.017 ↑ 464.0 1 1

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_161 (cost=0.29..3,082.77 rows=464 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
217. 0.019 0.019 ↑ 6,745.0 1 1

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_162 (cost=0.43..44,605.53 rows=6,745 width=30) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
218. 0.023 0.023 ↑ 1,115.0 1 1

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_163 (cost=0.42..7,375.15 rows=1,115 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
219. 0.028 0.028 ↑ 9.0 1 1

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_164 (cost=0.28..92.58 rows=9 width=30) (actual time=0.028..0.028 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
220. 0.020 0.020 ↑ 638.0 1 1

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_165 (cost=0.42..4,235.63 rows=638 width=30) (actual time=0.019..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
221. 0.022 0.022 ↑ 1,220.0 1 1

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_166 (cost=0.42..8,108.72 rows=1,220 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
222. 0.016 0.016 ↑ 7,926.0 1 1

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_167 (cost=0.43..52,385.16 rows=7,926 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
223. 0.018 0.018 ↑ 776.0 1 1

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_168 (cost=0.42..5,145.72 rows=776 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
224. 0.016 0.016 ↑ 10.0 1 1

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_169 (cost=0.28..102.68 rows=10 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
225. 0.019 0.019 ↑ 924.0 1 1

Index Scan Backward using _hyper_2_26_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_26_chunk aesqsc2_170 (cost=0.42..6,121.80 rows=924 width=30) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
226. 0.018 0.018 ↑ 1,127.0 1 1

Index Scan Backward using _hyper_2_27_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_27_chunk aesqsc2_171 (cost=0.42..7,463.26 rows=1,127 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
227. 0.023 0.023 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_28_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_28_chunk aesqsc2_172 (cost=0.28..62.12 rows=7 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
228. 0.019 0.019 ↑ 5,374.0 1 1

Index Scan Backward using _hyper_2_29_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_29_chunk aesqsc2_173 (cost=0.43..35,537.41 rows=5,374 width=30) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
229. 0.023 0.023 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_30_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_30_chunk aesqsc2_174 (cost=0.27..25.37 rows=2 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
230. 0.015 0.015 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_31_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_31_chunk aesqsc2_175 (cost=0.28..45.18 rows=5 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
231. 0.017 0.017 ↑ 4.0 1 1

Index Scan Backward using _hyper_2_32_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_32_chunk aesqsc2_176 (cost=0.28..42.16 rows=4 width=30) (actual time=0.016..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
232. 0.017 0.017 ↑ 1,366.0 1 1

Index Scan Backward using _hyper_2_33_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_33_chunk aesqsc2_177 (cost=0.42..9,067.17 rows=1,366 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
233. 0.030 0.030 ↑ 57.0 1 1

Index Scan Backward using _hyper_2_34_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_34_chunk aesqsc2_178 (cost=0.29..433.80 rows=57 width=30) (actual time=0.030..0.030 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
234. 0.021 0.021 ↑ 7,378.0 1 1

Index Scan Backward using _hyper_2_35_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_35_chunk aesqsc2_179 (cost=0.43..48,709.67 rows=7,378 width=30) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
235. 0.019 0.019 ↑ 3.0 1 1

Index Scan Backward using _hyper_2_36_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_36_chunk aesqsc2_180 (cost=0.28..35.38 rows=3 width=30) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
236. 0.018 0.018 ↑ 4,657.0 1 1

Index Scan Backward using _hyper_2_37_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_37_chunk aesqsc2_181 (cost=0.42..30,801.22 rows=4,657 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
237. 0.020 0.020 ↑ 6,178.0 1 1

Index Scan Backward using _hyper_2_38_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_38_chunk aesqsc2_182 (cost=0.43..40,860.67 rows=6,178 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
238. 0.018 0.018 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_39_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_39_chunk aesqsc2_183 (cost=0.28..64.15 rows=6 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
239. 0.016 0.016 ↑ 5,415.0 1 1

Index Scan Backward using _hyper_2_40_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_40_chunk aesqsc2_184 (cost=0.43..35,846.74 rows=5,415 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
240. 0.017 0.017 ↑ 1,549.0 1 1

Index Scan Backward using _hyper_2_41_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_41_chunk aesqsc2_185 (cost=0.42..10,251.53 rows=1,549 width=30) (actual time=0.016..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
241. 0.017 0.017 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_42_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_42_chunk aesqsc2_186 (cost=0.15..12.23 rows=1 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
242. 0.042 0.042 ↑ 5,010.0 1 1

Index Scan Backward using _hyper_2_43_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_43_chunk aesqsc2_187 (cost=0.42..33,107.98 rows=5,010 width=30) (actual time=0.042..0.042 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
243. 0.039 0.039 ↑ 377.0 1 1

Index Scan Backward using _hyper_2_44_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_44_chunk aesqsc2_188 (cost=0.29..2,600.41 rows=377 width=30) (actual time=0.039..0.039 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
244. 0.020 0.020 ↑ 5,543.0 1 1

Index Scan Backward using _hyper_2_45_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_45_chunk aesqsc2_189 (cost=0.43..36,798.88 rows=5,543 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
245. 0.027 0.027 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_46_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_46_chunk aesqsc2_190 (cost=0.14..4.08 rows=1 width=30) (actual time=0.027..0.027 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
246. 0.017 0.017 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_47_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_47_chunk aesqsc2_191 (cost=0.27..23.22 rows=2 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
247. 0.018 0.018 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_48_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_48_chunk aesqsc2_192 (cost=0.28..35.09 rows=5 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
248. 0.031 0.031 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_49_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_49_chunk aesqsc2_193 (cost=0.28..43.29 rows=6 width=30) (actual time=0.030..0.031 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
249. 0.019 0.019 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_50_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_50_chunk aesqsc2_194 (cost=0.28..52.82 rows=7 width=30) (actual time=0.018..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
250. 0.022 0.022 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_51_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_51_chunk aesqsc2_195 (cost=0.15..12.93 rows=2 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
251. 0.018 0.018 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_52_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_52_chunk aesqsc2_196 (cost=0.27..20.65 rows=2 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
252. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_53_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_53_chunk aesqsc2_197 (cost=0.14..3.47 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
253. 0.019 0.019 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_54_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_54_chunk aesqsc2_198 (cost=0.15..14.71 rows=2 width=30) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
254. 0.022 0.022 ↑ 620.0 1 1

Index Scan Backward using _hyper_2_55_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_55_chunk aesqsc2_199 (cost=0.42..4,099.50 rows=620 width=30) (actual time=0.021..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
255. 0.031 0.031 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_56_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_56_chunk aesqsc2_200 (cost=0.14..3.79 rows=1 width=30) (actual time=0.030..0.031 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
256. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_57_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_57_chunk aesqsc2_201 (cost=0.13..3.17 rows=1 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
257. 0.020 0.020 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_58_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_58_chunk aesqsc2_202 (cost=0.14..7.12 rows=1 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
258. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_59_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_59_chunk aesqsc2_203 (cost=0.14..3.27 rows=1 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
259. 0.021 0.021 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_60_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_60_chunk aesqsc2_204 (cost=0.13..3.24 rows=1 width=30) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
260. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_61_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_61_chunk aesqsc2_205 (cost=0.14..3.48 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
261. 0.020 0.020 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_62_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_62_chunk aesqsc2_206 (cost=0.14..6.72 rows=1 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
262. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_63_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_63_chunk aesqsc2_207 (cost=0.14..3.41 rows=1 width=30) (actual time=0.012..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
263. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_64_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_64_chunk aesqsc2_208 (cost=0.13..3.21 rows=1 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
264. 0.017 0.017 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_65_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_65_chunk aesqsc2_209 (cost=0.13..3.19 rows=1 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
265. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_66_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_66_chunk aesqsc2_210 (cost=0.13..3.16 rows=1 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
266. 0.016 0.016 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_67_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_67_chunk aesqsc2_211 (cost=0.13..3.17 rows=1 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
267. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_68_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_68_chunk aesqsc2_212 (cost=0.13..3.17 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
268. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_69_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_69_chunk aesqsc2_213 (cost=0.13..3.17 rows=1 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
269. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_70_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_70_chunk aesqsc2_214 (cost=0.13..3.16 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
270. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_71_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_71_chunk aesqsc2_215 (cost=0.13..3.16 rows=1 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
271. 1.600 1.600 ↑ 1.0 1 200

Index Scan using event_pkey on event e1_2 (cost=0.43..1.47 rows=1 width=14) (actual time=0.008..0.008 rows=1 loops=200)

  • Index Cond: (id = aesqsc2_144.event_id)
272. 0.600 0.600 ↑ 1.0 1 200

Index Scan using venue_pkey on venue v1_2 (cost=0.28..0.30 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: (id = e1_2.venue_id)
273. 0.400 0.400 ↑ 1.0 1 200

Index Scan using cinema_pkey on cinema c1_2 (cost=0.27..0.30 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = v1_2.cinema_id)
274. 0.800 0.800 ↑ 1.0 1 200

Index Scan using locality_pkey on locality l1_2 (cost=0.28..0.31 rows=1 width=14) (actual time=0.004..0.004 rows=1 loops=200)

  • Index Cond: (id = v1_2.locality_id)
275. 0.600 0.600 ↑ 1.0 1 200

Index Scan using google_place_pkey on google_place gp1_2 (cost=0.29..0.54 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: (id = l1_2.google_place_id)
276. 0.400 0.400 ↑ 1.0 1 200

Index Scan using country_pkey on country c2_2 (cost=0.14..0.16 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = gp1_2.country_id)
277. 1.000 1.000 ↓ 0.0 0 200

Index Scan using locality_weather_measurement_locality_id_time_idx on locality_weather_measurement lwm1_2 (cost=0.43..2.26 rows=1 width=30) (actual time=0.005..0.005 rows=0 loops=200)

  • Index Cond: ((locality_id = l1_2.id) AND (date_trunc('hour'::text, aesqsc2_144.created_at) = measurement_time))
278. 93.100 93.100 ↓ 0.0 0 100

Index Scan using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summary_2 on _hyper_2_2_chunk aesqsc1_2 (cost=0.42..2.34 rows=1 width=102) (actual time=0.931..0.931 rows=0 loops=100)

  • Index Cond: ((event_id = aesqsc3_2.event_id) AND (created_at = aesqsc3_2.created_at))
  • Filter: (aesqsc3_2.event_start_time = event_start_time)
279. 0.065 5.572 ↓ 0.0 0 1

Nested Loop (cost=25.50..1,459.48 rows=1 width=208) (actual time=5.572..5.572 rows=0 loops=1)

280. 0.078 5.307 ↑ 1.0 100 1

Subquery Scan on aesqsc3_3 (cost=25.09..1,229.47 rows=100 width=144) (actual time=3.161..5.307 rows=100 loops=1)

281. 0.049 5.229 ↑ 1.0 100 1

Limit (cost=25.09..1,228.47 rows=100 width=112) (actual time=3.140..5.229 rows=100 loops=1)

282. 0.193 5.180 ↑ 893.3 100 1

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (actual time=3.139..5.180 rows=100 loops=1)

283. 0.266 4.987 ↑ 446.6 200 1

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (actual time=1.437..4.987 rows=200 loops=1)

284. 0.142 4.321 ↑ 446.6 200 1

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (actual time=1.406..4.321 rows=200 loops=1)

285. 0.084 3.979 ↑ 446.6 200 1

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (actual time=1.391..3.979 rows=200 loops=1)

286. 0.039 3.495 ↑ 446.6 200 1

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (actual time=1.375..3.495 rows=200 loops=1)

287. 0.197 3.056 ↑ 446.6 200 1

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (actual time=1.362..3.056 rows=200 loops=1)

288. 0.046 2.659 ↑ 446.6 200 1

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (actual time=1.351..2.659 rows=200 loops=1)

289. 0.103 2.213 ↑ 446.6 200 1

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (actual time=1.337..2.213 rows=200 loops=1)

290. 0.091 1.510 ↑ 446.6 200 1

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (actual time=1.315..1.510 rows=200 loops=1)

  • Sort Key: aesqsc2_216.event_start_time
291. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2_216 (cost=0.12..1.55 rows=1 width=30) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (materialized_at IS NULL)
292. 0.185 0.185 ↓ 1.4 200 1

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_217 (cost=0.29..995.56 rows=147 width=30) (actual time=0.022..0.185 rows=200 loops=1)

  • Filter: (materialized_at IS NULL)
293. 0.017 0.017 ↑ 664.0 1 1

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_218 (cost=0.42..4,484.31 rows=664 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
294. 0.027 0.027 ↑ 459.0 1 1

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_219 (cost=0.29..3,066.35 rows=459 width=30) (actual time=0.027..0.027 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
295. 0.015 0.015 ↑ 8.0 1 1

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_220 (cost=0.28..64.38 rows=8 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
296. 0.021 0.021 ↑ 11,432.0 1 1

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_221 (cost=0.43..75,480.77 rows=11,432 width=30) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
297. 0.018 0.018 ↑ 635.0 1 1

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_222 (cost=0.42..4,212.36 rows=635 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
298. 0.017 0.017 ↑ 5,696.0 1 1

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_223 (cost=0.43..37,824.05 rows=5,696 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
299. 0.014 0.014 ↑ 517.0 1 1

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_224 (cost=0.29..3,499.03 rows=517 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
300. 0.017 0.017 ↑ 1,064.0 1 1

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_225 (cost=0.42..7,063.48 rows=1,064 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
301. 0.013 0.013 ↑ 455.0 1 1

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_226 (cost=0.29..3,125.85 rows=455 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
302. 0.018 0.018 ↑ 1,108.0 1 1

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_227 (cost=0.42..7,352.03 rows=1,108 width=30) (actual time=0.017..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
303. 0.027 0.027 ↑ 847.0 1 1

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_228 (cost=0.42..5,603.34 rows=847 width=30) (actual time=0.027..0.027 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
304. 0.036 0.036 ↑ 1,038.0 1 1

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_229 (cost=0.42..6,880.68 rows=1,038 width=30) (actual time=0.036..0.036 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
305. 0.014 0.014 ↑ 512.0 1 1

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_230 (cost=0.29..3,428.40 rows=512 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
306. 0.015 0.015 ↑ 76.0 1 1

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_231 (cost=0.29..563.12 rows=76 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
307. 0.015 0.015 ↑ 121.0 1 1

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_232 (cost=0.29..861.10 rows=121 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
308. 0.016 0.016 ↑ 464.0 1 1

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_233 (cost=0.29..3,082.77 rows=464 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
309. 0.018 0.018 ↑ 6,745.0 1 1

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_234 (cost=0.43..44,605.53 rows=6,745 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
310. 0.017 0.017 ↑ 1,115.0 1 1

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_235 (cost=0.42..7,375.15 rows=1,115 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
311. 0.020 0.020 ↑ 9.0 1 1

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_236 (cost=0.28..92.58 rows=9 width=30) (actual time=0.019..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
312. 0.038 0.038 ↑ 638.0 1 1

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_237 (cost=0.42..4,235.63 rows=638 width=30) (actual time=0.038..0.038 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
313. 0.018 0.018 ↑ 1,220.0 1 1

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_238 (cost=0.42..8,108.72 rows=1,220 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
314. 0.015 0.015 ↑ 7,926.0 1 1

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_239 (cost=0.43..52,385.16 rows=7,926 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
315. 0.016 0.016 ↑ 776.0 1 1

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_240 (cost=0.42..5,145.72 rows=776 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
316. 0.037 0.037 ↑ 10.0 1 1

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_241 (cost=0.28..102.68 rows=10 width=30) (actual time=0.037..0.037 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
317. 0.017 0.017 ↑ 924.0 1 1

Index Scan Backward using _hyper_2_26_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_26_chunk aesqsc2_242 (cost=0.42..6,121.80 rows=924 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
318. 0.027 0.027 ↑ 1,127.0 1 1

Index Scan Backward using _hyper_2_27_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_27_chunk aesqsc2_243 (cost=0.42..7,463.26 rows=1,127 width=30) (actual time=0.026..0.027 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
319. 0.013 0.013 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_28_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_28_chunk aesqsc2_244 (cost=0.28..62.12 rows=7 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
320. 0.036 0.036 ↑ 5,374.0 1 1

Index Scan Backward using _hyper_2_29_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_29_chunk aesqsc2_245 (cost=0.43..35,537.41 rows=5,374 width=30) (actual time=0.036..0.036 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
321. 0.014 0.014 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_30_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_30_chunk aesqsc2_246 (cost=0.27..25.37 rows=2 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
322. 0.014 0.014 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_31_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_31_chunk aesqsc2_247 (cost=0.28..45.18 rows=5 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
323. 0.014 0.014 ↑ 4.0 1 1

Index Scan Backward using _hyper_2_32_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_32_chunk aesqsc2_248 (cost=0.28..42.16 rows=4 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
324. 0.014 0.014 ↑ 1,366.0 1 1

Index Scan Backward using _hyper_2_33_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_33_chunk aesqsc2_249 (cost=0.42..9,067.17 rows=1,366 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
325. 0.014 0.014 ↑ 57.0 1 1

Index Scan Backward using _hyper_2_34_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_34_chunk aesqsc2_250 (cost=0.29..433.80 rows=57 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
326. 0.015 0.015 ↑ 7,378.0 1 1

Index Scan Backward using _hyper_2_35_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_35_chunk aesqsc2_251 (cost=0.43..48,709.67 rows=7,378 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
327. 0.018 0.018 ↑ 3.0 1 1

Index Scan Backward using _hyper_2_36_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_36_chunk aesqsc2_252 (cost=0.28..35.38 rows=3 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
328. 0.016 0.016 ↑ 4,657.0 1 1

Index Scan Backward using _hyper_2_37_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_37_chunk aesqsc2_253 (cost=0.42..30,801.22 rows=4,657 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
329. 0.016 0.016 ↑ 6,178.0 1 1

Index Scan Backward using _hyper_2_38_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_38_chunk aesqsc2_254 (cost=0.43..40,860.67 rows=6,178 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
330. 0.026 0.026 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_39_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_39_chunk aesqsc2_255 (cost=0.28..64.15 rows=6 width=30) (actual time=0.026..0.026 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
331. 0.032 0.032 ↑ 5,415.0 1 1

Index Scan Backward using _hyper_2_40_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_40_chunk aesqsc2_256 (cost=0.43..35,846.74 rows=5,415 width=30) (actual time=0.032..0.032 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
332. 0.013 0.013 ↑ 1,549.0 1 1

Index Scan Backward using _hyper_2_41_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_41_chunk aesqsc2_257 (cost=0.42..10,251.53 rows=1,549 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
333. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_42_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_42_chunk aesqsc2_258 (cost=0.15..12.23 rows=1 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
334. 0.017 0.017 ↑ 5,010.0 1 1

Index Scan Backward using _hyper_2_43_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_43_chunk aesqsc2_259 (cost=0.42..33,107.98 rows=5,010 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
335. 0.018 0.018 ↑ 377.0 1 1

Index Scan Backward using _hyper_2_44_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_44_chunk aesqsc2_260 (cost=0.29..2,600.41 rows=377 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
336. 0.016 0.016 ↑ 5,543.0 1 1

Index Scan Backward using _hyper_2_45_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_45_chunk aesqsc2_261 (cost=0.43..36,798.88 rows=5,543 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
337. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_46_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_46_chunk aesqsc2_262 (cost=0.14..4.08 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
338. 0.013 0.013 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_47_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_47_chunk aesqsc2_263 (cost=0.27..23.22 rows=2 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
339. 0.014 0.014 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_48_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_48_chunk aesqsc2_264 (cost=0.28..35.09 rows=5 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
340. 0.015 0.015 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_49_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_49_chunk aesqsc2_265 (cost=0.28..43.29 rows=6 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
341. 0.013 0.013 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_50_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_50_chunk aesqsc2_266 (cost=0.28..52.82 rows=7 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
342. 0.020 0.020 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_51_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_51_chunk aesqsc2_267 (cost=0.15..12.93 rows=2 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
343. 0.015 0.015 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_52_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_52_chunk aesqsc2_268 (cost=0.27..20.65 rows=2 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
344. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_53_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_53_chunk aesqsc2_269 (cost=0.14..3.47 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
345. 0.016 0.016 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_54_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_54_chunk aesqsc2_270 (cost=0.15..14.71 rows=2 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
346. 0.031 0.031 ↑ 620.0 1 1

Index Scan Backward using _hyper_2_55_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_55_chunk aesqsc2_271 (cost=0.42..4,099.50 rows=620 width=30) (actual time=0.031..0.031 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
347. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_56_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_56_chunk aesqsc2_272 (cost=0.14..3.79 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
348. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_57_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_57_chunk aesqsc2_273 (cost=0.13..3.17 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
349. 0.016 0.016 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_58_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_58_chunk aesqsc2_274 (cost=0.14..7.12 rows=1 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
350. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_59_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_59_chunk aesqsc2_275 (cost=0.14..3.27 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
351. 0.023 0.023 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_60_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_60_chunk aesqsc2_276 (cost=0.13..3.24 rows=1 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
352. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_61_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_61_chunk aesqsc2_277 (cost=0.14..3.48 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
353. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_62_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_62_chunk aesqsc2_278 (cost=0.14..6.72 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
354. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_63_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_63_chunk aesqsc2_279 (cost=0.14..3.41 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
355. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_64_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_64_chunk aesqsc2_280 (cost=0.13..3.21 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
356. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_65_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_65_chunk aesqsc2_281 (cost=0.13..3.19 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
357. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_66_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_66_chunk aesqsc2_282 (cost=0.13..3.16 rows=1 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
358. 0.021 0.021 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_67_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_67_chunk aesqsc2_283 (cost=0.13..3.17 rows=1 width=30) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
359. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_68_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_68_chunk aesqsc2_284 (cost=0.13..3.17 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
360. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_69_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_69_chunk aesqsc2_285 (cost=0.13..3.17 rows=1 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
361. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_70_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_70_chunk aesqsc2_286 (cost=0.13..3.16 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
362. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_71_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_71_chunk aesqsc2_287 (cost=0.13..3.16 rows=1 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
363. 0.600 0.600 ↑ 1.0 1 200

Index Scan using event_pkey on event e1_3 (cost=0.43..1.47 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: (id = aesqsc2_216.event_id)
364. 0.400 0.400 ↑ 1.0 1 200

Index Scan using venue_pkey on venue v1_3 (cost=0.28..0.30 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = e1_3.venue_id)
365. 0.200 0.200 ↑ 1.0 1 200

Index Scan using cinema_pkey on cinema c1_3 (cost=0.27..0.30 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=200)

  • Index Cond: (id = v1_3.cinema_id)
366. 0.400 0.400 ↑ 1.0 1 200

Index Scan using locality_pkey on locality l1_3 (cost=0.28..0.31 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = v1_3.locality_id)
367. 0.400 0.400 ↑ 1.0 1 200

Index Scan using google_place_pkey on google_place gp1_3 (cost=0.29..0.54 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = l1_3.google_place_id)
368. 0.200 0.200 ↑ 1.0 1 200

Index Scan using country_pkey on country c2_3 (cost=0.14..0.16 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=200)

  • Index Cond: (id = gp1_3.country_id)
369. 0.400 0.400 ↓ 0.0 0 200

Index Scan using locality_weather_measurement_locality_id_time_idx on locality_weather_measurement lwm1_3 (cost=0.43..2.26 rows=1 width=30) (actual time=0.002..0.002 rows=0 loops=200)

  • Index Cond: ((locality_id = l1_3.id) AND (date_trunc('hour'::text, aesqsc2_216.created_at) = measurement_time))
370. 0.200 0.200 ↓ 0.0 0 100

Index Scan using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summary_2 on _hyper_2_3_chunk aesqsc1_3 (cost=0.42..2.29 rows=1 width=102) (actual time=0.002..0.002 rows=0 loops=100)

  • Index Cond: ((event_id = aesqsc3_3.event_id) AND (created_at = aesqsc3_3.created_at))
  • Filter: (aesqsc3_3.event_start_time = event_start_time)
371. 0.022 5.218 ↓ 0.0 0 1

Nested Loop (cost=25.36..1,300.48 rows=1 width=202) (actual time=5.218..5.218 rows=0 loops=1)

372. 0.075 4.996 ↑ 1.0 100 1

Subquery Scan on aesqsc3_4 (cost=25.09..1,229.47 rows=100 width=144) (actual time=2.812..4.996 rows=100 loops=1)

373. 0.041 4.921 ↑ 1.0 100 1

Limit (cost=25.09..1,228.47 rows=100 width=112) (actual time=2.797..4.921 rows=100 loops=1)

374. 0.196 4.880 ↑ 893.3 100 1

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (actual time=2.796..4.880 rows=100 loops=1)

375. 0.182 4.684 ↑ 446.6 200 1

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (actual time=1.139..4.684 rows=200 loops=1)

376. 0.181 4.102 ↑ 446.6 200 1

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (actual time=1.122..4.102 rows=200 loops=1)

377. 0.122 3.721 ↑ 446.6 200 1

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (actual time=1.110..3.721 rows=200 loops=1)

378. 0.037 3.199 ↑ 446.6 200 1

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (actual time=1.096..3.199 rows=200 loops=1)

379. 0.211 2.762 ↑ 446.6 200 1

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (actual time=1.083..2.762 rows=200 loops=1)

380. 0.079 2.351 ↑ 446.6 200 1

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (actual time=1.071..2.351 rows=200 loops=1)

381. 0.057 1.872 ↑ 446.6 200 1

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (actual time=1.055..1.872 rows=200 loops=1)

382. 0.064 1.215 ↑ 446.6 200 1

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (actual time=1.038..1.215 rows=200 loops=1)

  • Sort Key: aesqsc2_288.event_start_time
383. 0.011 0.011 ↓ 0.0 0 1

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2_288 (cost=0.12..1.55 rows=1 width=30) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (materialized_at IS NULL)
384. 0.157 0.157 ↓ 1.4 200 1

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_289 (cost=0.29..995.56 rows=147 width=30) (actual time=0.012..0.157 rows=200 loops=1)

  • Filter: (materialized_at IS NULL)
385. 0.016 0.016 ↑ 664.0 1 1

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_290 (cost=0.42..4,484.31 rows=664 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
386. 0.014 0.014 ↑ 459.0 1 1

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_291 (cost=0.29..3,066.35 rows=459 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
387. 0.023 0.023 ↑ 8.0 1 1

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_292 (cost=0.28..64.38 rows=8 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
388. 0.018 0.018 ↑ 11,432.0 1 1

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_293 (cost=0.43..75,480.77 rows=11,432 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
389. 0.011 0.011 ↑ 635.0 1 1

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_294 (cost=0.42..4,212.36 rows=635 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
390. 0.012 0.012 ↑ 5,696.0 1 1

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_295 (cost=0.43..37,824.05 rows=5,696 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
391. 0.011 0.011 ↑ 517.0 1 1

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_296 (cost=0.29..3,499.03 rows=517 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
392. 0.013 0.013 ↑ 1,064.0 1 1

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_297 (cost=0.42..7,063.48 rows=1,064 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
393. 0.012 0.012 ↑ 455.0 1 1

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_298 (cost=0.29..3,125.85 rows=455 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
394. 0.015 0.015 ↑ 1,108.0 1 1

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_299 (cost=0.42..7,352.03 rows=1,108 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
395. 0.015 0.015 ↑ 847.0 1 1

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_300 (cost=0.42..5,603.34 rows=847 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
396. 0.014 0.014 ↑ 1,038.0 1 1

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_301 (cost=0.42..6,880.68 rows=1,038 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
397. 0.016 0.016 ↑ 512.0 1 1

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_302 (cost=0.29..3,428.40 rows=512 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
398. 0.013 0.013 ↑ 76.0 1 1

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_303 (cost=0.29..563.12 rows=76 width=30) (actual time=0.012..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
399. 0.010 0.010 ↑ 121.0 1 1

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_304 (cost=0.29..861.10 rows=121 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
400. 0.015 0.015 ↑ 464.0 1 1

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_305 (cost=0.29..3,082.77 rows=464 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
401. 0.014 0.014 ↑ 6,745.0 1 1

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_306 (cost=0.43..44,605.53 rows=6,745 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
402. 0.015 0.015 ↑ 1,115.0 1 1

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_307 (cost=0.42..7,375.15 rows=1,115 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
403. 0.016 0.016 ↑ 9.0 1 1

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_308 (cost=0.28..92.58 rows=9 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
404. 0.013 0.013 ↑ 638.0 1 1

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_309 (cost=0.42..4,235.63 rows=638 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
405. 0.013 0.013 ↑ 1,220.0 1 1

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_310 (cost=0.42..8,108.72 rows=1,220 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
406. 0.011 0.011 ↑ 7,926.0 1 1

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_311 (cost=0.43..52,385.16 rows=7,926 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
407. 0.013 0.013 ↑ 776.0 1 1

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_312 (cost=0.42..5,145.72 rows=776 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
408. 0.011 0.011 ↑ 10.0 1 1

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_313 (cost=0.28..102.68 rows=10 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
409. 0.015 0.015 ↑ 924.0 1 1

Index Scan Backward using _hyper_2_26_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_26_chunk aesqsc2_314 (cost=0.42..6,121.80 rows=924 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
410. 0.014 0.014 ↑ 1,127.0 1 1

Index Scan Backward using _hyper_2_27_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_27_chunk aesqsc2_315 (cost=0.42..7,463.26 rows=1,127 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
411. 0.012 0.012 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_28_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_28_chunk aesqsc2_316 (cost=0.28..62.12 rows=7 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
412. 0.016 0.016 ↑ 5,374.0 1 1

Index Scan Backward using _hyper_2_29_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_29_chunk aesqsc2_317 (cost=0.43..35,537.41 rows=5,374 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
413. 0.012 0.012 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_30_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_30_chunk aesqsc2_318 (cost=0.27..25.37 rows=2 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
414. 0.011 0.011 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_31_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_31_chunk aesqsc2_319 (cost=0.28..45.18 rows=5 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
415. 0.010 0.010 ↑ 4.0 1 1

Index Scan Backward using _hyper_2_32_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_32_chunk aesqsc2_320 (cost=0.28..42.16 rows=4 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
416. 0.015 0.015 ↑ 1,366.0 1 1

Index Scan Backward using _hyper_2_33_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_33_chunk aesqsc2_321 (cost=0.42..9,067.17 rows=1,366 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
417. 0.041 0.041 ↑ 57.0 1 1

Index Scan Backward using _hyper_2_34_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_34_chunk aesqsc2_322 (cost=0.29..433.80 rows=57 width=30) (actual time=0.041..0.041 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
418. 0.012 0.012 ↑ 7,378.0 1 1

Index Scan Backward using _hyper_2_35_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_35_chunk aesqsc2_323 (cost=0.43..48,709.67 rows=7,378 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
419. 0.015 0.015 ↑ 3.0 1 1

Index Scan Backward using _hyper_2_36_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_36_chunk aesqsc2_324 (cost=0.28..35.38 rows=3 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
420. 0.012 0.012 ↑ 4,657.0 1 1

Index Scan Backward using _hyper_2_37_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_37_chunk aesqsc2_325 (cost=0.42..30,801.22 rows=4,657 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
421. 0.014 0.014 ↑ 6,178.0 1 1

Index Scan Backward using _hyper_2_38_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_38_chunk aesqsc2_326 (cost=0.43..40,860.67 rows=6,178 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
422. 0.025 0.025 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_39_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_39_chunk aesqsc2_327 (cost=0.28..64.15 rows=6 width=30) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
423. 0.011 0.011 ↑ 5,415.0 1 1

Index Scan Backward using _hyper_2_40_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_40_chunk aesqsc2_328 (cost=0.43..35,846.74 rows=5,415 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
424. 0.012 0.012 ↑ 1,549.0 1 1

Index Scan Backward using _hyper_2_41_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_41_chunk aesqsc2_329 (cost=0.42..10,251.53 rows=1,549 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
425. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_42_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_42_chunk aesqsc2_330 (cost=0.15..12.23 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
426. 0.013 0.013 ↑ 5,010.0 1 1

Index Scan Backward using _hyper_2_43_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_43_chunk aesqsc2_331 (cost=0.42..33,107.98 rows=5,010 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
427. 0.016 0.016 ↑ 377.0 1 1

Index Scan Backward using _hyper_2_44_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_44_chunk aesqsc2_332 (cost=0.29..2,600.41 rows=377 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
428. 0.023 0.023 ↑ 5,543.0 1 1

Index Scan Backward using _hyper_2_45_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_45_chunk aesqsc2_333 (cost=0.43..36,798.88 rows=5,543 width=30) (actual time=0.023..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
429. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_46_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_46_chunk aesqsc2_334 (cost=0.14..4.08 rows=1 width=30) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
430. 0.011 0.011 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_47_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_47_chunk aesqsc2_335 (cost=0.27..23.22 rows=2 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
431. 0.013 0.013 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_48_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_48_chunk aesqsc2_336 (cost=0.28..35.09 rows=5 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
432. 0.012 0.012 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_49_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_49_chunk aesqsc2_337 (cost=0.28..43.29 rows=6 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
433. 0.012 0.012 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_50_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_50_chunk aesqsc2_338 (cost=0.28..52.82 rows=7 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
434. 0.016 0.016 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_51_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_51_chunk aesqsc2_339 (cost=0.15..12.93 rows=2 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
435. 0.015 0.015 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_52_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_52_chunk aesqsc2_340 (cost=0.27..20.65 rows=2 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
436. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_53_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_53_chunk aesqsc2_341 (cost=0.14..3.47 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
437. 0.012 0.012 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_54_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_54_chunk aesqsc2_342 (cost=0.15..14.71 rows=2 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
438. 0.016 0.016 ↑ 620.0 1 1

Index Scan Backward using _hyper_2_55_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_55_chunk aesqsc2_343 (cost=0.42..4,099.50 rows=620 width=30) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
439. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_56_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_56_chunk aesqsc2_344 (cost=0.14..3.79 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
440. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_57_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_57_chunk aesqsc2_345 (cost=0.13..3.17 rows=1 width=30) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
441. 0.025 0.025 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_58_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_58_chunk aesqsc2_346 (cost=0.14..7.12 rows=1 width=30) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
442. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_59_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_59_chunk aesqsc2_347 (cost=0.14..3.27 rows=1 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
443. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_60_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_60_chunk aesqsc2_348 (cost=0.13..3.24 rows=1 width=30) (actual time=0.012..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
444. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_61_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_61_chunk aesqsc2_349 (cost=0.14..3.48 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
445. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_62_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_62_chunk aesqsc2_350 (cost=0.14..6.72 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
446. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_63_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_63_chunk aesqsc2_351 (cost=0.14..3.41 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
447. 0.025 0.025 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_64_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_64_chunk aesqsc2_352 (cost=0.13..3.21 rows=1 width=30) (actual time=0.025..0.025 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
448. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_65_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_65_chunk aesqsc2_353 (cost=0.13..3.19 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
449. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_66_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_66_chunk aesqsc2_354 (cost=0.13..3.16 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
450. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_67_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_67_chunk aesqsc2_355 (cost=0.13..3.17 rows=1 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
451. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_68_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_68_chunk aesqsc2_356 (cost=0.13..3.17 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
452. 0.017 0.017 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_69_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_69_chunk aesqsc2_357 (cost=0.13..3.17 rows=1 width=30) (actual time=0.016..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
453. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_70_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_70_chunk aesqsc2_358 (cost=0.13..3.16 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
454. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_71_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_71_chunk aesqsc2_359 (cost=0.13..3.16 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
455. 0.600 0.600 ↑ 1.0 1 200

Index Scan using event_pkey on event e1_4 (cost=0.43..1.47 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: (id = aesqsc2_288.event_id)
456. 0.400 0.400 ↑ 1.0 1 200

Index Scan using venue_pkey on venue v1_4 (cost=0.28..0.30 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = e1_4.venue_id)
457. 0.200 0.200 ↑ 1.0 1 200

Index Scan using cinema_pkey on cinema c1_4 (cost=0.27..0.30 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=200)

  • Index Cond: (id = v1_4.cinema_id)
458. 0.400 0.400 ↑ 1.0 1 200

Index Scan using locality_pkey on locality l1_4 (cost=0.28..0.31 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = v1_4.locality_id)
459. 0.400 0.400 ↑ 1.0 1 200

Index Scan using google_place_pkey on google_place gp1_4 (cost=0.29..0.54 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = l1_4.google_place_id)
460. 0.200 0.200 ↑ 1.0 1 200

Index Scan using country_pkey on country c2_4 (cost=0.14..0.16 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=200)

  • Index Cond: (id = gp1_4.country_id)
461. 0.400 0.400 ↓ 0.0 0 200

Index Scan using locality_weather_measurement_locality_id_time_idx on locality_weather_measurement lwm1_4 (cost=0.43..2.26 rows=1 width=30) (actual time=0.002..0.002 rows=0 loops=200)

  • Index Cond: ((locality_id = l1_4.id) AND (date_trunc('hour'::text, aesqsc2_288.created_at) = measurement_time))
462. 0.200 0.200 ↓ 0.0 0 100

Index Scan using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summary_2 on _hyper_2_4_chunk aesqsc1_4 (cost=0.28..0.70 rows=1 width=96) (actual time=0.002..0.002 rows=0 loops=100)

  • Index Cond: ((event_id = aesqsc3_4.event_id) AND (created_at = aesqsc3_4.created_at))
  • Filter: (aesqsc3_4.event_start_time = event_start_time)
463. 0.062 6.387 ↓ 0.0 0 1

Nested Loop (cost=25.52..1,475.73 rows=1 width=203) (actual time=6.387..6.387 rows=0 loops=1)

464. 0.074 5.025 ↑ 1.0 100 1

Subquery Scan on aesqsc3_5 (cost=25.09..1,229.47 rows=100 width=144) (actual time=2.790..5.025 rows=100 loops=1)

465. 0.055 4.951 ↑ 1.0 100 1

Limit (cost=25.09..1,228.47 rows=100 width=112) (actual time=2.779..4.951 rows=100 loops=1)

466. 0.206 4.896 ↑ 893.3 100 1

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (actual time=2.778..4.896 rows=100 loops=1)

467. 0.202 4.690 ↑ 446.6 200 1

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (actual time=1.086..4.690 rows=200 loops=1)

468. 0.221 4.088 ↑ 446.6 200 1

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (actual time=1.070..4.088 rows=200 loops=1)

469. 0.079 3.667 ↑ 446.6 200 1

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (actual time=1.025..3.667 rows=200 loops=1)

470. 0.091 3.188 ↑ 446.6 200 1

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (actual time=1.009..3.188 rows=200 loops=1)

471. 0.073 2.697 ↑ 446.6 200 1

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (actual time=0.996..2.697 rows=200 loops=1)

472. 0.067 2.224 ↑ 446.6 200 1

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (actual time=0.965..2.224 rows=200 loops=1)

473. 0.053 1.757 ↑ 446.6 200 1

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (actual time=0.944..1.757 rows=200 loops=1)

474. 0.051 1.104 ↑ 446.6 200 1

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (actual time=0.927..1.104 rows=200 loops=1)

  • Sort Key: aesqsc2_360.event_start_time
475. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2_360 (cost=0.12..1.55 rows=1 width=30) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (materialized_at IS NULL)
476. 0.152 0.152 ↓ 1.4 200 1

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_361 (cost=0.29..995.56 rows=147 width=30) (actual time=0.012..0.152 rows=200 loops=1)

  • Filter: (materialized_at IS NULL)
477. 0.013 0.013 ↑ 664.0 1 1

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_362 (cost=0.42..4,484.31 rows=664 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
478. 0.014 0.014 ↑ 459.0 1 1

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_363 (cost=0.29..3,066.35 rows=459 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
479. 0.011 0.011 ↑ 8.0 1 1

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_364 (cost=0.28..64.38 rows=8 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
480. 0.014 0.014 ↑ 11,432.0 1 1

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_365 (cost=0.43..75,480.77 rows=11,432 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
481. 0.019 0.019 ↑ 635.0 1 1

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_366 (cost=0.42..4,212.36 rows=635 width=30) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
482. 0.011 0.011 ↑ 5,696.0 1 1

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_367 (cost=0.43..37,824.05 rows=5,696 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
483. 0.011 0.011 ↑ 517.0 1 1

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_368 (cost=0.29..3,499.03 rows=517 width=30) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
484. 0.012 0.012 ↑ 1,064.0 1 1

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_369 (cost=0.42..7,063.48 rows=1,064 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
485. 0.012 0.012 ↑ 455.0 1 1

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_370 (cost=0.29..3,125.85 rows=455 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
486. 0.014 0.014 ↑ 1,108.0 1 1

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_371 (cost=0.42..7,352.03 rows=1,108 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
487. 0.012 0.012 ↑ 847.0 1 1

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_372 (cost=0.42..5,603.34 rows=847 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
488. 0.023 0.023 ↑ 1,038.0 1 1

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_373 (cost=0.42..6,880.68 rows=1,038 width=30) (actual time=0.022..0.023 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
489. 0.010 0.010 ↑ 512.0 1 1

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_374 (cost=0.29..3,428.40 rows=512 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
490. 0.012 0.012 ↑ 76.0 1 1

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_375 (cost=0.29..563.12 rows=76 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
491. 0.010 0.010 ↑ 121.0 1 1

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_376 (cost=0.29..861.10 rows=121 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
492. 0.012 0.012 ↑ 464.0 1 1

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_377 (cost=0.29..3,082.77 rows=464 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
493. 0.013 0.013 ↑ 6,745.0 1 1

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_378 (cost=0.43..44,605.53 rows=6,745 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
494. 0.011 0.011 ↑ 1,115.0 1 1

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_379 (cost=0.42..7,375.15 rows=1,115 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
495. 0.017 0.017 ↑ 9.0 1 1

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_380 (cost=0.28..92.58 rows=9 width=30) (actual time=0.016..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
496. 0.015 0.015 ↑ 638.0 1 1

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_381 (cost=0.42..4,235.63 rows=638 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
497. 0.016 0.016 ↑ 1,220.0 1 1

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_382 (cost=0.42..8,108.72 rows=1,220 width=30) (actual time=0.015..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
498. 0.011 0.011 ↑ 7,926.0 1 1

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_383 (cost=0.43..52,385.16 rows=7,926 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
499. 0.014 0.014 ↑ 776.0 1 1

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_384 (cost=0.42..5,145.72 rows=776 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
500. 0.010 0.010 ↑ 10.0 1 1

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_385 (cost=0.28..102.68 rows=10 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
501. 0.017 0.017 ↑ 924.0 1 1

Index Scan Backward using _hyper_2_26_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_26_chunk aesqsc2_386 (cost=0.42..6,121.80 rows=924 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
502. 0.014 0.014 ↑ 1,127.0 1 1

Index Scan Backward using _hyper_2_27_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_27_chunk aesqsc2_387 (cost=0.42..7,463.26 rows=1,127 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
503. 0.012 0.012 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_28_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_28_chunk aesqsc2_388 (cost=0.28..62.12 rows=7 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
504. 0.012 0.012 ↑ 5,374.0 1 1

Index Scan Backward using _hyper_2_29_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_29_chunk aesqsc2_389 (cost=0.43..35,537.41 rows=5,374 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
505. 0.011 0.011 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_30_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_30_chunk aesqsc2_390 (cost=0.27..25.37 rows=2 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
506. 0.012 0.012 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_31_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_31_chunk aesqsc2_391 (cost=0.28..45.18 rows=5 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
507. 0.010 0.010 ↑ 4.0 1 1

Index Scan Backward using _hyper_2_32_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_32_chunk aesqsc2_392 (cost=0.28..42.16 rows=4 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
508. 0.012 0.012 ↑ 1,366.0 1 1

Index Scan Backward using _hyper_2_33_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_33_chunk aesqsc2_393 (cost=0.42..9,067.17 rows=1,366 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
509. 0.024 0.024 ↑ 57.0 1 1

Index Scan Backward using _hyper_2_34_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_34_chunk aesqsc2_394 (cost=0.29..433.80 rows=57 width=30) (actual time=0.023..0.024 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
510. 0.012 0.012 ↑ 7,378.0 1 1

Index Scan Backward using _hyper_2_35_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_35_chunk aesqsc2_395 (cost=0.43..48,709.67 rows=7,378 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
511. 0.012 0.012 ↑ 3.0 1 1

Index Scan Backward using _hyper_2_36_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_36_chunk aesqsc2_396 (cost=0.28..35.38 rows=3 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
512. 0.012 0.012 ↑ 4,657.0 1 1

Index Scan Backward using _hyper_2_37_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_37_chunk aesqsc2_397 (cost=0.42..30,801.22 rows=4,657 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
513. 0.014 0.014 ↑ 6,178.0 1 1

Index Scan Backward using _hyper_2_38_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_38_chunk aesqsc2_398 (cost=0.43..40,860.67 rows=6,178 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
514. 0.012 0.012 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_39_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_39_chunk aesqsc2_399 (cost=0.28..64.15 rows=6 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
515. 0.011 0.011 ↑ 5,415.0 1 1

Index Scan Backward using _hyper_2_40_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_40_chunk aesqsc2_400 (cost=0.43..35,846.74 rows=5,415 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
516. 0.011 0.011 ↑ 1,549.0 1 1

Index Scan Backward using _hyper_2_41_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_41_chunk aesqsc2_401 (cost=0.42..10,251.53 rows=1,549 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
517. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_42_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_42_chunk aesqsc2_402 (cost=0.15..12.23 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
518. 0.022 0.022 ↑ 5,010.0 1 1

Index Scan Backward using _hyper_2_43_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_43_chunk aesqsc2_403 (cost=0.42..33,107.98 rows=5,010 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
519. 0.014 0.014 ↑ 377.0 1 1

Index Scan Backward using _hyper_2_44_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_44_chunk aesqsc2_404 (cost=0.29..2,600.41 rows=377 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
520. 0.015 0.015 ↑ 5,543.0 1 1

Index Scan Backward using _hyper_2_45_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_45_chunk aesqsc2_405 (cost=0.43..36,798.88 rows=5,543 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
521. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_46_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_46_chunk aesqsc2_406 (cost=0.14..4.08 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
522. 0.024 0.024 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_47_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_47_chunk aesqsc2_407 (cost=0.27..23.22 rows=2 width=30) (actual time=0.023..0.024 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
523. 0.012 0.012 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_48_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_48_chunk aesqsc2_408 (cost=0.28..35.09 rows=5 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
524. 0.012 0.012 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_49_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_49_chunk aesqsc2_409 (cost=0.28..43.29 rows=6 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
525. 0.010 0.010 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_50_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_50_chunk aesqsc2_410 (cost=0.28..52.82 rows=7 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
526. 0.015 0.015 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_51_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_51_chunk aesqsc2_411 (cost=0.15..12.93 rows=2 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
527. 0.012 0.012 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_52_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_52_chunk aesqsc2_412 (cost=0.27..20.65 rows=2 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
528. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_53_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_53_chunk aesqsc2_413 (cost=0.14..3.47 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
529. 0.014 0.014 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_54_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_54_chunk aesqsc2_414 (cost=0.15..14.71 rows=2 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
530. 0.015 0.015 ↑ 620.0 1 1

Index Scan Backward using _hyper_2_55_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_55_chunk aesqsc2_415 (cost=0.42..4,099.50 rows=620 width=30) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
531. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_56_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_56_chunk aesqsc2_416 (cost=0.14..3.79 rows=1 width=30) (actual time=0.008..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
532. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_57_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_57_chunk aesqsc2_417 (cost=0.13..3.17 rows=1 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
533. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_58_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_58_chunk aesqsc2_418 (cost=0.14..7.12 rows=1 width=30) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
534. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_59_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_59_chunk aesqsc2_419 (cost=0.14..3.27 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
535. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_60_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_60_chunk aesqsc2_420 (cost=0.13..3.24 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
536. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_61_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_61_chunk aesqsc2_421 (cost=0.14..3.48 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
537. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_62_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_62_chunk aesqsc2_422 (cost=0.14..6.72 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
538. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_63_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_63_chunk aesqsc2_423 (cost=0.14..3.41 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
539. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_64_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_64_chunk aesqsc2_424 (cost=0.13..3.21 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
540. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_65_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_65_chunk aesqsc2_425 (cost=0.13..3.19 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
541. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_66_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_66_chunk aesqsc2_426 (cost=0.13..3.16 rows=1 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
542. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_67_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_67_chunk aesqsc2_427 (cost=0.13..3.17 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
543. 0.009 0.009 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_68_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_68_chunk aesqsc2_428 (cost=0.13..3.17 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
544. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_69_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_69_chunk aesqsc2_429 (cost=0.13..3.17 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
545. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_70_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_70_chunk aesqsc2_430 (cost=0.13..3.16 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
546. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_71_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_71_chunk aesqsc2_431 (cost=0.13..3.16 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
547. 0.600 0.600 ↑ 1.0 1 200

Index Scan using event_pkey on event e1_5 (cost=0.43..1.47 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: (id = aesqsc2_360.event_id)
548. 0.400 0.400 ↑ 1.0 1 200

Index Scan using venue_pkey on venue v1_5 (cost=0.28..0.30 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = e1_5.venue_id)
549. 0.400 0.400 ↑ 1.0 1 200

Index Scan using cinema_pkey on cinema c1_5 (cost=0.27..0.30 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = v1_5.cinema_id)
550. 0.400 0.400 ↑ 1.0 1 200

Index Scan using locality_pkey on locality l1_5 (cost=0.28..0.31 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = v1_5.locality_id)
551. 0.400 0.400 ↑ 1.0 1 200

Index Scan using google_place_pkey on google_place gp1_5 (cost=0.29..0.54 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = l1_5.google_place_id)
552. 0.200 0.200 ↑ 1.0 1 200

Index Scan using country_pkey on country c2_5 (cost=0.14..0.16 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=200)

  • Index Cond: (id = gp1_5.country_id)
553. 0.400 0.400 ↓ 0.0 0 200

Index Scan using locality_weather_measurement_locality_id_time_idx on locality_weather_measurement lwm1_5 (cost=0.43..2.26 rows=1 width=30) (actual time=0.002..0.002 rows=0 loops=200)

  • Index Cond: ((locality_id = l1_5.id) AND (date_trunc('hour'::text, aesqsc2_360.created_at) = measurement_time))
554. 1.300 1.300 ↓ 0.0 0 100

Index Scan using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summary_2 on _hyper_2_5_chunk aesqsc1_5 (cost=0.43..2.45 rows=1 width=97) (actual time=0.013..0.013 rows=0 loops=100)

  • Index Cond: ((event_id = aesqsc3_5.event_id) AND (created_at = aesqsc3_5.created_at))
  • Filter: (aesqsc3_5.event_start_time = event_start_time)
555. 0.000 6.360 ↓ 0.0 0 1

Nested Loop (cost=25.50..1,463.48 rows=1 width=208) (actual time=6.360..6.360 rows=0 loops=1)

556. 0.100 6.061 ↑ 1.0 100 1

Subquery Scan on aesqsc3_6 (cost=25.09..1,229.47 rows=100 width=144) (actual time=3.627..6.061 rows=100 loops=1)

557. 0.051 5.961 ↑ 1.0 100 1

Limit (cost=25.09..1,228.47 rows=100 width=112) (actual time=3.611..5.961 rows=100 loops=1)

558. 0.216 5.910 ↑ 893.3 100 1

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (actual time=3.609..5.910 rows=100 loops=1)

559. 0.143 5.694 ↑ 446.6 200 1

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (actual time=1.342..5.694 rows=200 loops=1)

560. 0.089 4.951 ↑ 446.6 200 1

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (actual time=1.316..4.951 rows=200 loops=1)

561. 0.168 4.462 ↑ 446.6 200 1

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (actual time=1.300..4.462 rows=200 loops=1)

562. 0.179 3.894 ↑ 446.6 200 1

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (actual time=1.282..3.894 rows=200 loops=1)

563. 0.105 3.315 ↑ 446.6 200 1

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (actual time=1.265..3.315 rows=200 loops=1)

564. 0.162 2.810 ↑ 446.6 200 1

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (actual time=1.235..2.810 rows=200 loops=1)

565. 0.212 2.248 ↑ 446.6 200 1

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (actual time=1.215..2.248 rows=200 loops=1)

566. 0.089 1.436 ↑ 446.6 200 1

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (actual time=1.189..1.436 rows=200 loops=1)

  • Sort Key: aesqsc2_432.event_start_time
567. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2_432 (cost=0.12..1.55 rows=1 width=30) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (materialized_at IS NULL)
568. 0.207 0.207 ↓ 1.4 200 1

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_433 (cost=0.29..995.56 rows=147 width=30) (actual time=0.014..0.207 rows=200 loops=1)

  • Filter: (materialized_at IS NULL)
569. 0.011 0.011 ↑ 664.0 1 1

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_434 (cost=0.42..4,484.31 rows=664 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
570. 0.013 0.013 ↑ 459.0 1 1

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_435 (cost=0.29..3,066.35 rows=459 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
571. 0.053 0.053 ↑ 8.0 1 1

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_436 (cost=0.28..64.38 rows=8 width=30) (actual time=0.053..0.053 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
572. 0.018 0.018 ↑ 11,432.0 1 1

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_437 (cost=0.43..75,480.77 rows=11,432 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
573. 0.012 0.012 ↑ 635.0 1 1

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_438 (cost=0.42..4,212.36 rows=635 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
574. 0.010 0.010 ↑ 5,696.0 1 1

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_439 (cost=0.43..37,824.05 rows=5,696 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
575. 0.012 0.012 ↑ 517.0 1 1

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_440 (cost=0.29..3,499.03 rows=517 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
576. 0.011 0.011 ↑ 1,064.0 1 1

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_441 (cost=0.42..7,063.48 rows=1,064 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
577. 0.010 0.010 ↑ 455.0 1 1

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_442 (cost=0.29..3,125.85 rows=455 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
578. 0.014 0.014 ↑ 1,108.0 1 1

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_443 (cost=0.42..7,352.03 rows=1,108 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
579. 0.014 0.014 ↑ 847.0 1 1

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_444 (cost=0.42..5,603.34 rows=847 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
580. 0.016 0.016 ↑ 1,038.0 1 1

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_445 (cost=0.42..6,880.68 rows=1,038 width=30) (actual time=0.015..0.016 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
581. 0.012 0.012 ↑ 512.0 1 1

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_446 (cost=0.29..3,428.40 rows=512 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
582. 0.050 0.050 ↑ 76.0 1 1

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_447 (cost=0.29..563.12 rows=76 width=30) (actual time=0.050..0.050 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
583. 0.013 0.013 ↑ 121.0 1 1

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_448 (cost=0.29..861.10 rows=121 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
584. 0.015 0.015 ↑ 464.0 1 1

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_449 (cost=0.29..3,082.77 rows=464 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
585. 0.015 0.015 ↑ 6,745.0 1 1

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_450 (cost=0.43..44,605.53 rows=6,745 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
586. 0.055 0.055 ↑ 1,115.0 1 1

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_451 (cost=0.42..7,375.15 rows=1,115 width=30) (actual time=0.055..0.055 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
587. 0.018 0.018 ↑ 9.0 1 1

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_452 (cost=0.28..92.58 rows=9 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
588. 0.011 0.011 ↑ 638.0 1 1

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_453 (cost=0.42..4,235.63 rows=638 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
589. 0.013 0.013 ↑ 1,220.0 1 1

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_454 (cost=0.42..8,108.72 rows=1,220 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
590. 0.012 0.012 ↑ 7,926.0 1 1

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_455 (cost=0.43..52,385.16 rows=7,926 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
591. 0.011 0.011 ↑ 776.0 1 1

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_456 (cost=0.42..5,145.72 rows=776 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
592. 0.029 0.029 ↑ 10.0 1 1

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_457 (cost=0.28..102.68 rows=10 width=30) (actual time=0.029..0.029 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
593. 0.015 0.015 ↑ 924.0 1 1

Index Scan Backward using _hyper_2_26_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_26_chunk aesqsc2_458 (cost=0.42..6,121.80 rows=924 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
594. 0.012 0.012 ↑ 1,127.0 1 1

Index Scan Backward using _hyper_2_27_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_27_chunk aesqsc2_459 (cost=0.42..7,463.26 rows=1,127 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
595. 0.015 0.015 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_28_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_28_chunk aesqsc2_460 (cost=0.28..62.12 rows=7 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
596. 0.020 0.020 ↑ 5,374.0 1 1

Index Scan Backward using _hyper_2_29_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_29_chunk aesqsc2_461 (cost=0.43..35,537.41 rows=5,374 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
597. 0.013 0.013 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_30_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_30_chunk aesqsc2_462 (cost=0.27..25.37 rows=2 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
598. 0.014 0.014 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_31_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_31_chunk aesqsc2_463 (cost=0.28..45.18 rows=5 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
599. 0.014 0.014 ↑ 4.0 1 1

Index Scan Backward using _hyper_2_32_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_32_chunk aesqsc2_464 (cost=0.28..42.16 rows=4 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
600. 0.014 0.014 ↑ 1,366.0 1 1

Index Scan Backward using _hyper_2_33_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_33_chunk aesqsc2_465 (cost=0.42..9,067.17 rows=1,366 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
601. 0.012 0.012 ↑ 57.0 1 1

Index Scan Backward using _hyper_2_34_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_34_chunk aesqsc2_466 (cost=0.29..433.80 rows=57 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
602. 0.011 0.011 ↑ 7,378.0 1 1

Index Scan Backward using _hyper_2_35_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_35_chunk aesqsc2_467 (cost=0.43..48,709.67 rows=7,378 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
603. 0.011 0.011 ↑ 3.0 1 1

Index Scan Backward using _hyper_2_36_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_36_chunk aesqsc2_468 (cost=0.28..35.38 rows=3 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
604. 0.017 0.017 ↑ 4,657.0 1 1

Index Scan Backward using _hyper_2_37_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_37_chunk aesqsc2_469 (cost=0.42..30,801.22 rows=4,657 width=30) (actual time=0.016..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
605. 0.017 0.017 ↑ 6,178.0 1 1

Index Scan Backward using _hyper_2_38_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_38_chunk aesqsc2_470 (cost=0.43..40,860.67 rows=6,178 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
606. 0.017 0.017 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_39_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_39_chunk aesqsc2_471 (cost=0.28..64.15 rows=6 width=30) (actual time=0.016..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
607. 0.017 0.017 ↑ 5,415.0 1 1

Index Scan Backward using _hyper_2_40_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_40_chunk aesqsc2_472 (cost=0.43..35,846.74 rows=5,415 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
608. 0.013 0.013 ↑ 1,549.0 1 1

Index Scan Backward using _hyper_2_41_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_41_chunk aesqsc2_473 (cost=0.42..10,251.53 rows=1,549 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
609. 0.013 0.013 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_42_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_42_chunk aesqsc2_474 (cost=0.15..12.23 rows=1 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
610. 0.015 0.015 ↑ 5,010.0 1 1

Index Scan Backward using _hyper_2_43_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_43_chunk aesqsc2_475 (cost=0.42..33,107.98 rows=5,010 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
611. 0.017 0.017 ↑ 377.0 1 1

Index Scan Backward using _hyper_2_44_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_44_chunk aesqsc2_476 (cost=0.29..2,600.41 rows=377 width=30) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
612. 0.012 0.012 ↑ 5,543.0 1 1

Index Scan Backward using _hyper_2_45_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_45_chunk aesqsc2_477 (cost=0.43..36,798.88 rows=5,543 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
613. 0.010 0.010 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_46_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_46_chunk aesqsc2_478 (cost=0.14..4.08 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
614. 0.012 0.012 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_47_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_47_chunk aesqsc2_479 (cost=0.27..23.22 rows=2 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
615. 0.012 0.012 ↑ 5.0 1 1

Index Scan Backward using _hyper_2_48_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_48_chunk aesqsc2_480 (cost=0.28..35.09 rows=5 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
616. 0.020 0.020 ↑ 6.0 1 1

Index Scan Backward using _hyper_2_49_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_49_chunk aesqsc2_481 (cost=0.28..43.29 rows=6 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
617. 0.011 0.011 ↑ 7.0 1 1

Index Scan Backward using _hyper_2_50_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_50_chunk aesqsc2_482 (cost=0.28..52.82 rows=7 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
618. 0.020 0.020 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_51_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_51_chunk aesqsc2_483 (cost=0.15..12.93 rows=2 width=30) (actual time=0.020..0.020 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
619. 0.014 0.014 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_52_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_52_chunk aesqsc2_484 (cost=0.27..20.65 rows=2 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
620. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_53_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_53_chunk aesqsc2_485 (cost=0.14..3.47 rows=1 width=30) (actual time=0.011..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
621. 0.021 0.021 ↑ 2.0 1 1

Index Scan Backward using _hyper_2_54_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_54_chunk aesqsc2_486 (cost=0.15..14.71 rows=2 width=30) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
622. 0.022 0.022 ↑ 620.0 1 1

Index Scan Backward using _hyper_2_55_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_55_chunk aesqsc2_487 (cost=0.42..4,099.50 rows=620 width=30) (actual time=0.022..0.022 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
623. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_56_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_56_chunk aesqsc2_488 (cost=0.14..3.79 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
624. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_57_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_57_chunk aesqsc2_489 (cost=0.13..3.17 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
625. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_58_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_58_chunk aesqsc2_490 (cost=0.14..7.12 rows=1 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
626. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_59_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_59_chunk aesqsc2_491 (cost=0.14..3.27 rows=1 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
627. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_60_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_60_chunk aesqsc2_492 (cost=0.13..3.24 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
628. 0.018 0.018 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_61_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_61_chunk aesqsc2_493 (cost=0.14..3.48 rows=1 width=30) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
629. 0.015 0.015 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_62_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_62_chunk aesqsc2_494 (cost=0.14..6.72 rows=1 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
630. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_63_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_63_chunk aesqsc2_495 (cost=0.14..3.41 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
631. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_64_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_64_chunk aesqsc2_496 (cost=0.13..3.21 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
632. 0.026 0.026 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_65_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_65_chunk aesqsc2_497 (cost=0.13..3.19 rows=1 width=30) (actual time=0.026..0.026 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
633. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_66_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_66_chunk aesqsc2_498 (cost=0.13..3.16 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
634. 0.012 0.012 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_67_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_67_chunk aesqsc2_499 (cost=0.13..3.17 rows=1 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
635. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_68_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_68_chunk aesqsc2_500 (cost=0.13..3.17 rows=1 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
636. 0.014 0.014 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_69_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_69_chunk aesqsc2_501 (cost=0.13..3.17 rows=1 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
637. 0.035 0.035 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_70_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_70_chunk aesqsc2_502 (cost=0.13..3.16 rows=1 width=30) (actual time=0.034..0.035 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
638. 0.011 0.011 ↑ 1.0 1 1

Index Scan Backward using _hyper_2_71_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_71_chunk aesqsc2_503 (cost=0.13..3.16 rows=1 width=30) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
639. 0.600 0.600 ↑ 1.0 1 200

Index Scan using event_pkey on event e1_6 (cost=0.43..1.47 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: (id = aesqsc2_432.event_id)
640. 0.400 0.400 ↑ 1.0 1 200

Index Scan using venue_pkey on venue v1_6 (cost=0.28..0.30 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = e1_6.venue_id)
641. 0.400 0.400 ↑ 1.0 1 200

Index Scan using cinema_pkey on cinema c1_6 (cost=0.27..0.30 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = v1_6.cinema_id)
642. 0.400 0.400 ↑ 1.0 1 200

Index Scan using locality_pkey on locality l1_6 (cost=0.28..0.31 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = v1_6.locality_id)
643. 0.400 0.400 ↑ 1.0 1 200

Index Scan using google_place_pkey on google_place gp1_6 (cost=0.29..0.54 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = l1_6.google_place_id)
644. 0.400 0.400 ↑ 1.0 1 200

Index Scan using country_pkey on country c2_6 (cost=0.14..0.16 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=200)

  • Index Cond: (id = gp1_6.country_id)
645. 0.600 0.600 ↓ 0.0 0 200

Index Scan using locality_weather_measurement_locality_id_time_idx on locality_weather_measurement lwm1_6 (cost=0.43..2.26 rows=1 width=30) (actual time=0.003..0.003 rows=0 loops=200)

  • Index Cond: ((locality_id = l1_6.id) AND (date_trunc('hour'::text, aesqsc2_432.created_at) = measurement_time))
646. 0.300 0.300 ↓ 0.0 0 100

Index Scan using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summary_2 on _hyper_2_6_chunk aesqsc1_6 (cost=0.42..2.33 rows=1 width=102) (actual time=0.003..0.003 rows=0 loops=100)

  • Index Cond: ((event_id = aesqsc3_6.event_id) AND (created_at = aesqsc3_6.created_at))
  • Filter: (aesqsc3_6.event_start_time = event_start_time)
647. 0.048 7.523 ↓ 0.0 0 1

Nested Loop (cost=25.51..1,474.48 rows=1 width=203) (actual time=7.523..7.523 rows=0 loops=1)

648. 0.099 7.075 ↑ 1.0 100 1

Subquery Scan on aesqsc3_7 (cost=25.09..1,229.47 rows=100 width=144) (actual time=3.866..7.075 rows=100 loops=1)

649. 0.072 6.976 ↑ 1.0 100 1

Limit (cost=25.09..1,228.47 rows=100 width=112) (actual time=3.852..6.976 rows=100 loops=1)

650. 0.271 6.904 ↑ 893.3 100 1

LockRows (cost=25.09..1,075,010.14 rows=89,330 width=112) (actual time=3.851..6.904 rows=100 loops=1)

651. 0.326 6.633 ↑ 446.6 200 1

Nested Loop Left Join (cost=25.09..1,074,116.84 rows=89,330 width=112) (actual time=1.317..6.633 rows=200 loops=1)

652. 0.094 5.707 ↑ 446.6 200 1

Nested Loop (cost=24.66..871,211.86 rows=89,330 width=82) (actual time=1.293..5.707 rows=200 loops=1)

653. 0.105 5.213 ↑ 446.6 200 1

Nested Loop (cost=24.51..856,677.57 rows=89,330 width=76) (actual time=1.277..5.213 rows=200 loops=1)

654. 0.103 4.508 ↑ 446.6 200 1

Nested Loop (cost=24.22..808,061.45 rows=89,330 width=70) (actual time=1.255..4.508 rows=200 loops=1)

655. 0.242 3.805 ↑ 446.6 200 1

Nested Loop (cost=23.94..779,991.53 rows=89,330 width=60) (actual time=1.241..3.805 rows=200 loops=1)

656. 0.147 3.163 ↑ 446.6 200 1

Nested Loop (cost=23.67..753,082.83 rows=89,330 width=54) (actual time=1.229..3.163 rows=200 loops=1)

657. 0.155 2.416 ↑ 446.6 200 1

Nested Loop (cost=23.39..726,505.63 rows=89,330 width=40) (actual time=1.215..2.416 rows=200 loops=1)

658. 0.087 1.461 ↑ 446.6 200 1

Merge Append (cost=22.96..595,101.45 rows=89,330 width=30) (actual time=1.196..1.461 rows=200 loops=1)

  • Sort Key: aesqsc2_504.event_start_time
659. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using aggregate_event_seating_quantitative_summa_event_start_time_idx on aggregate_event_seating_quantitative_summary_change aesqsc2_504 (cost=0.12..1.55 rows=1 width=30) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (materialized_at IS NULL)
660. 0.239 0.239 ↓ 1.4 200 1

Index Scan Backward using _hyper_2_1_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_1_chunk aesqsc2_505 (cost=0.29..995.56 rows=147 width=30) (actual time=0.031..0.239 rows=200 loops=1)

  • Filter: (materialized_at IS NULL)
661. 0.015 0.015 ↑ 664.0 1 1

Index Scan Backward using _hyper_2_2_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_2_chunk aesqsc2_506 (cost=0.42..4,484.31 rows=664 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
662. 0.026 0.026 ↑ 459.0 1 1

Index Scan Backward using _hyper_2_3_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_3_chunk aesqsc2_507 (cost=0.29..3,066.35 rows=459 width=30) (actual time=0.026..0.026 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
663. 0.012 0.012 ↑ 8.0 1 1

Index Scan Backward using _hyper_2_4_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_4_chunk aesqsc2_508 (cost=0.28..64.38 rows=8 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
664. 0.015 0.015 ↑ 11,432.0 1 1

Index Scan Backward using _hyper_2_5_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_5_chunk aesqsc2_509 (cost=0.43..75,480.77 rows=11,432 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
665. 0.021 0.021 ↑ 635.0 1 1

Index Scan Backward using _hyper_2_6_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_6_chunk aesqsc2_510 (cost=0.42..4,212.36 rows=635 width=30) (actual time=0.021..0.021 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
666. 0.012 0.012 ↑ 5,696.0 1 1

Index Scan Backward using _hyper_2_7_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_7_chunk aesqsc2_511 (cost=0.43..37,824.05 rows=5,696 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
667. 0.011 0.011 ↑ 517.0 1 1

Index Scan Backward using _hyper_2_8_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_8_chunk aesqsc2_512 (cost=0.29..3,499.03 rows=517 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
668. 0.013 0.013 ↑ 1,064.0 1 1

Index Scan Backward using _hyper_2_9_chunk_aggregate_event_seating_quantitative_summa_eve on _hyper_2_9_chunk aesqsc2_513 (cost=0.42..7,063.48 rows=1,064 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
669. 0.013 0.013 ↑ 455.0 1 1

Index Scan Backward using _hyper_2_10_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_10_chunk aesqsc2_514 (cost=0.29..3,125.85 rows=455 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
670. 0.013 0.013 ↑ 1,108.0 1 1

Index Scan Backward using _hyper_2_11_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_11_chunk aesqsc2_515 (cost=0.42..7,352.03 rows=1,108 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
671. 0.015 0.015 ↑ 847.0 1 1

Index Scan Backward using _hyper_2_12_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_12_chunk aesqsc2_516 (cost=0.42..5,603.34 rows=847 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
672. 0.011 0.011 ↑ 1,038.0 1 1

Index Scan Backward using _hyper_2_13_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_13_chunk aesqsc2_517 (cost=0.42..6,880.68 rows=1,038 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
673. 0.010 0.010 ↑ 512.0 1 1

Index Scan Backward using _hyper_2_14_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_14_chunk aesqsc2_518 (cost=0.29..3,428.40 rows=512 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
674. 0.011 0.011 ↑ 76.0 1 1

Index Scan Backward using _hyper_2_15_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_15_chunk aesqsc2_519 (cost=0.29..563.12 rows=76 width=30) (actual time=0.011..0.011 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
675. 0.010 0.010 ↑ 121.0 1 1

Index Scan Backward using _hyper_2_16_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_16_chunk aesqsc2_520 (cost=0.29..861.10 rows=121 width=30) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
676. 0.013 0.013 ↑ 464.0 1 1

Index Scan Backward using _hyper_2_17_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_17_chunk aesqsc2_521 (cost=0.29..3,082.77 rows=464 width=30) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
677. 0.012 0.012 ↑ 6,745.0 1 1

Index Scan Backward using _hyper_2_18_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_18_chunk aesqsc2_522 (cost=0.43..44,605.53 rows=6,745 width=30) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
678. 0.014 0.014 ↑ 1,115.0 1 1

Index Scan Backward using _hyper_2_19_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_19_chunk aesqsc2_523 (cost=0.42..7,375.15 rows=1,115 width=30) (actual time=0.014..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
679. 0.015 0.015 ↑ 9.0 1 1

Index Scan Backward using _hyper_2_20_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_20_chunk aesqsc2_524 (cost=0.28..92.58 rows=9 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
680. 0.015 0.015 ↑ 638.0 1 1

Index Scan Backward using _hyper_2_21_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_21_chunk aesqsc2_525 (cost=0.42..4,235.63 rows=638 width=30) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
681. 0.019 0.019 ↑ 1,220.0 1 1

Index Scan Backward using _hyper_2_22_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_22_chunk aesqsc2_526 (cost=0.42..8,108.72 rows=1,220 width=30) (actual time=0.019..0.019 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
682. 0.014 0.014 ↑ 7,926.0 1 1

Index Scan Backward using _hyper_2_23_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_23_chunk aesqsc2_527 (cost=0.43..52,385.16 rows=7,926 width=30) (actual time=0.013..0.014 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
683. 0.040 0.040 ↑ 776.0 1 1

Index Scan Backward using _hyper_2_24_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_24_chunk aesqsc2_528 (cost=0.42..5,145.72 rows=776 width=30) (actual time=0.040..0.040 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)
684. 0.010 0.010 ↑ 10.0 1 1

Index Scan Backward using _hyper_2_25_chunk_aggregate_event_seating_quantitative_summa_ev on _hyper_2_25_chunk aesqsc2_529 (cost=0.28..102.68 rows=10 width=30) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: (materialized_at IS NULL)