explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wHQl

Settings
# exclusive inclusive rows x rows loops node
1. 1,734.481 50,176.063 ↑ 27.5 100,544 1

HashAggregate (cost=1,276,583.21..1,318,032.71 rows=2,763,300 width=124) (actual time=50,092.310..50,176.063 rows=100,544 loops=1)

  • Group Key: e1.country_id, e1.movie_id, time_bucket('01:00:00'::interval, ec1.changed_at)
2. 6,584.929 48,441.582 ↑ 1.1 2,604,508 1

Hash Join (cost=435,755.15..1,248,950.21 rows=2,763,300 width=18) (actual time=18,850.441..48,441.582 rows=2,604,508 loops=1)

  • Hash Cond: (ec1.event_id = e1.id)
3. 3,288.424 23,175.685 ↓ 1.0 18,535,732 1

Custom Scan (ChunkAppend) on event_change ec1 (cost=0.00..757,972.62 rows=18,405,404 width=14) (actual time=2.886..23,175.685 rows=18,535,732 loops=1)

  • Chunks excluded during startup: 44
4. 3,449.393 3,449.393 ↓ 1.0 1,172,753 1

Index Only Scan using _hyper_11_192_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_192_chunk ec1_1 (cost=0.43..43,913.35 rows=1,156,131 width=14) (actual time=2.883..3,449.393 rows=1,172,753 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 1092
5. 2,704.229 2,704.229 ↓ 1.0 2,230,000 1

Index Only Scan using _hyper_11_208_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_208_chunk ec1_2 (cost=0.43..75,066.92 rows=2,206,228 width=14) (actual time=1.734..2,704.229 rows=2,230,000 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 0
6. 4,222.828 4,222.828 ↓ 1.0 1,878,266 1

Index Only Scan using _hyper_11_209_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_209_chunk ec1_3 (cost=0.43..68,000.29 rows=1,860,772 width=14) (actual time=1.587..4,222.828 rows=1,878,266 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 161
7. 1,603.409 1,603.409 ↓ 1.0 1,938,229 1

Index Only Scan using _hyper_11_217_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_217_chunk ec1_4 (cost=0.43..64,108.79 rows=1,937,098 width=14) (actual time=0.816..1,603.409 rows=1,938,229 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 0
8. 471.507 471.507 ↑ 1.0 1,138,739 1

Index Only Scan using _hyper_11_218_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_218_chunk ec1_5 (cost=0.43..39,432.60 rows=1,148,718 width=14) (actual time=0.166..471.507 rows=1,138,739 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 0
9. 813.328 813.328 ↓ 1.0 1,718,879 1

Index Only Scan using _hyper_11_224_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_224_chunk ec1_6 (cost=0.43..58,510.91 rows=1,715,980 width=14) (actual time=0.301..813.328 rows=1,718,879 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 0
10. 451.645 451.645 ↑ 1.0 1,057,473 1

Index Only Scan using _hyper_11_226_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_226_chunk ec1_7 (cost=0.43..35,164.09 rows=1,060,019 width=14) (actual time=0.200..451.645 rows=1,057,473 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 0
11. 827.338 827.338 ↓ 1.0 763,852 1

Index Only Scan using _hyper_11_228_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_228_chunk ec1_8 (cost=0.43..45,005.92 rows=763,006 width=14) (actual time=0.167..827.338 rows=763,852 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 330398
12. 31.773 31.773 ↑ 1.0 27,810 1

Index Only Scan using _hyper_11_232_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_232_chunk ec1_9 (cost=0.42..2,156.09 rows=28,094 width=14) (actual time=0.148..31.773 rows=27,810 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 7978
13. 975.168 975.168 ↓ 1.0 1,308,110 1

Index Only Scan using _hyper_11_233_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_233_chunk ec1_10 (cost=0.43..55,388.33 rows=1,260,380 width=14) (actual time=0.437..975.168 rows=1,308,110 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 393661
14. 1,057.216 1,057.216 ↑ 1.0 1,518,127 1

Index Only Scan using _hyper_11_247_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_247_chunk ec1_11 (cost=0.43..69,419.47 rows=1,519,430 width=14) (actual time=0.247..1,057.216 rows=1,518,127 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 521734
15. 2.174 2.174 ↓ 1.0 1,261 1

Index Only Scan using _hyper_11_248_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_248_chunk ec1_12 (cost=0.29..161.28 rows=1,215 width=14) (actual time=0.130..2.174 rows=1,261 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 658
16. 718.974 718.974 ↓ 1.0 1,045,157 1

Index Only Scan using _hyper_11_249_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_249_chunk ec1_13 (cost=0.43..41,974.71 rows=1,014,345 width=14) (actual time=0.168..718.974 rows=1,045,157 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 355842
17. 986.213 986.213 ↑ 1.0 1,127,635 1

Index Only Scan using _hyper_11_250_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_250_chunk ec1_14 (cost=0.43..68,119.13 rows=1,138,158 width=14) (actual time=0.230..986.213 rows=1,127,635 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 438650
18. 0.437 0.437 ↑ 1.0 638 1

Index Only Scan using _hyper_11_251_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_251_chunk ec1_15 (cost=0.28..52.95 rows=650 width=14) (actual time=0.073..0.437 rows=638 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 125
19. 58.764 58.764 ↓ 1.1 55,178 1

Index Only Scan using _hyper_11_253_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_253_chunk ec1_16 (cost=0.42..4,313.03 rows=51,010 width=14) (actual time=0.191..58.764 rows=55,178 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 21538
20. 33.996 33.996 ↑ 1.0 35,465 1

Index Only Scan using _hyper_11_254_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_254_chunk ec1_17 (cost=0.42..2,540.76 rows=37,152 width=14) (actual time=0.089..33.996 rows=35,465 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 7080
21. 4.448 4.448 ↓ 1.0 4,828 1

Index Only Scan using _hyper_11_255_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_255_chunk ec1_18 (cost=0.29..324.47 rows=4,739 width=14) (actual time=0.094..4.448 rows=4,828 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 978
22. 10.272 10.272 ↓ 1.0 10,462 1

Index Only Scan using _hyper_11_256_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_256_chunk ec1_19 (cost=0.29..600.61 rows=10,213 width=14) (actual time=0.113..10.272 rows=10,462 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 2850
23. 2.863 2.863 ↓ 1.0 3,001 1

Index Only Scan using _hyper_11_257_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_257_chunk ec1_20 (cost=0.29..226.83 rows=2,955 width=14) (actual time=0.075..2.863 rows=3,001 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 748
24. 1,060.741 1,060.741 ↓ 1.0 1,253,415 1

Index Only Scan using _hyper_11_258_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_258_chunk ec1_21 (cost=0.43..61,862.81 rows=1,250,760 width=14) (actual time=0.228..1,060.741 rows=1,253,415 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 440280
25. 4.173 4.173 ↓ 1.0 6,035 1

Index Only Scan using _hyper_11_259_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_259_chunk ec1_22 (cost=0.29..314.65 rows=6,010 width=14) (actual time=0.064..4.173 rows=6,035 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 684
26. 3.253 3.253 ↑ 1.0 3,314 1

Index Only Scan using _hyper_11_260_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_260_chunk ec1_23 (cost=0.29..257.88 rows=3,314 width=14) (actual time=0.057..3.253 rows=3,314 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 974
27. 325.359 325.359 ↓ 1.0 183,655 1

Index Only Scan using _hyper_11_261_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_261_chunk ec1_24 (cost=0.43..15,713.96 rows=176,386 width=14) (actual time=0.380..325.359 rows=183,655 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 93297
28. 0.104 0.104 ↓ 1.1 35 1

Index Only Scan using _hyper_11_262_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_262_chunk ec1_25 (cost=0.15..3.16 rows=32 width=14) (actual time=0.082..0.104 rows=35 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 35
29. 10.427 10.427 ↑ 1.1 7,612 1

Index Only Scan using _hyper_11_263_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_263_chunk ec1_26 (cost=0.42..840.13 rows=8,065 width=14) (actual time=0.109..10.427 rows=7,612 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 1804
30. 1.748 1.748 ↓ 1.0 1,703 1

Index Only Scan using _hyper_11_264_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_264_chunk ec1_27 (cost=0.29..138.08 rows=1,680 width=14) (actual time=0.111..1.748 rows=1,703 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 289
31. 2.131 2.131 ↑ 1.0 2,089 1

Index Only Scan using _hyper_11_265_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_265_chunk ec1_28 (cost=0.29..237.11 rows=2,191 width=14) (actual time=0.075..2.131 rows=2,089 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 85
32. 0.105 0.105 ↓ 1.1 17 1

Seq Scan on _hyper_11_266_chunk ec1_29 (cost=0.00..1.90 rows=16 width=14) (actual time=0.057..0.105 rows=17 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 31
33. 4.165 4.165 ↓ 1.0 3,705 1

Index Only Scan using _hyper_11_299_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_299_chunk ec1_30 (cost=0.29..401.18 rows=3,651 width=14) (actual time=0.089..4.165 rows=3,705 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 254
34. 23.668 23.668 ↑ 1.0 16,108 1

Index Only Scan using _hyper_11_300_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_300_chunk ec1_31 (cost=0.42..1,671.27 rows=16,294 width=14) (actual time=0.083..23.668 rows=16,108 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 8939
35. 0.652 0.652 ↓ 1.0 623 1

Index Only Scan using _hyper_11_301_chunk_event_change_event_start_time_seat_sold_c_1 on _hyper_11_301_chunk ec1_32 (cost=0.28..58.99 rows=621 width=14) (actual time=0.084..0.652 rows=623 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 169
36. 0.920 0.920 ↓ 1.0 849 1

Index Only Scan using _hyper_11_129752_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129752_chunk ec1_33 (cost=0.28..75.85 rows=818 width=14) (actual time=0.061..0.920 rows=849 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 210
37. 0.737 0.737 ↓ 1.0 892 1

Index Only Scan using _hyper_11_129753_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129753_chunk ec1_34 (cost=0.28..54.79 rows=888 width=14) (actual time=0.062..0.737 rows=892 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 90
38. 0.250 0.250 ↓ 1.0 215 1

Index Only Scan using _hyper_11_129754_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129754_chunk ec1_35 (cost=0.28..20.38 rows=213 width=14) (actual time=0.077..0.250 rows=215 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 46
39. 1.028 1.028 ↓ 1.0 1,064 1

Index Only Scan using _hyper_11_129755_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129755_chunk ec1_36 (cost=0.28..75.21 rows=1,037 width=14) (actual time=0.068..1.028 rows=1,064 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 172
40. 0.326 0.326 ↑ 1.1 245 1

Index Only Scan using _hyper_11_129756_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129756_chunk ec1_37 (cost=0.28..26.44 rows=277 width=14) (actual time=0.104..0.326 rows=245 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 51
41. 0.936 0.936 ↓ 1.0 1,023 1

Index Only Scan using _hyper_11_129757_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129757_chunk ec1_38 (cost=0.28..71.57 rows=1,006 width=14) (actual time=0.075..0.936 rows=1,023 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 120
42. 14.723 14.723 ↓ 1.2 11,500 1

Index Only Scan using _hyper_11_129758_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129758_chunk ec1_39 (cost=0.42..1,162.37 rows=9,970 width=14) (actual time=0.081..14.723 rows=11,500 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 2093
43. 0.975 0.975 ↓ 1.1 1,108 1

Index Only Scan using _hyper_11_129759_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_129759_chunk ec1_40 (cost=0.28..77.21 rows=1,053 width=14) (actual time=0.060..0.975 rows=1,108 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 241
44. 0.055 0.055 ↑ 1.0 22 1

Seq Scan on _hyper_11_426390_chunk ec1_41 (cost=0.00..2.24 rows=22 width=14) (actual time=0.028..0.055 rows=22 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 41
45. 0.215 0.215 ↓ 1.0 202 1

Index Only Scan using _hyper_11_426690_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_426690_chunk ec1_42 (cost=0.28..15.39 rows=201 width=14) (actual time=0.063..0.215 rows=202 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 24
46. 0.043 0.043 ↑ 1.0 17 1

Seq Scan on _hyper_11_426691_chunk ec1_43 (cost=0.00..1.84 rows=17 width=14) (actual time=0.022..0.043 rows=17 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 25
47. 0.079 0.079 ↑ 1.0 61 1

Seq Scan on _hyper_11_426692_chunk ec1_44 (cost=0.00..3.44 rows=63 width=14) (actual time=0.017..0.079 rows=61 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 11
48. 0.026 0.026 ↑ 1.2 6 1

Seq Scan on _hyper_11_426837_chunk ec1_45 (cost=0.00..1.48 rows=7 width=14) (actual time=0.018..0.026 rows=6 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 18
49. 0.032 0.032 ↓ 0.0 0 1

Seq Scan on _hyper_11_426838_chunk ec1_46 (cost=0.00..1.18 rows=1 width=14) (actual time=0.032..0.032 rows=0 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 9
50. 0.032 0.032 ↑ 1.2 8 1

Seq Scan on _hyper_11_426839_chunk ec1_47 (cost=0.00..1.50 rows=10 width=14) (actual time=0.019..0.032 rows=8 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 17
51. 0.049 0.049 ↓ 1.0 23 1

Seq Scan on _hyper_11_426840_chunk ec1_48 (cost=0.00..2.12 rows=22 width=14) (actual time=0.018..0.049 rows=23 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 41
52. 0.241 0.241 ↓ 1.0 83 1

Index Only Scan using _hyper_11_426841_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_426841_chunk ec1_49 (cost=0.28..20.01 rows=82 width=14) (actual time=0.080..0.241 rows=83 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 22
53. 0.544 0.544 ↓ 1.0 613 1

Index Only Scan using _hyper_11_426842_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_426842_chunk ec1_50 (cost=0.28..41.91 rows=609 width=14) (actual time=0.069..0.544 rows=613 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 44
54. 0.722 0.722 ↓ 1.0 820 1

Index Only Scan using _hyper_11_426843_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_426843_chunk ec1_51 (cost=0.28..52.55 rows=819 width=14) (actual time=0.064..0.722 rows=820 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 35
55. 1.107 1.107 ↓ 1.0 995 1

Index Only Scan using _hyper_11_427781_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_427781_chunk ec1_52 (cost=0.28..79.18 rows=982 width=14) (actual time=0.059..1.107 rows=995 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 281
56. 0.551 0.551 ↑ 1.0 568 1

Index Only Scan using _hyper_11_427796_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_427796_chunk ec1_53 (cost=0.28..37.96 rows=568 width=14) (actual time=0.067..0.551 rows=568 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 99
57. 0.043 0.043 ↑ 1.0 22 1

Seq Scan on _hyper_11_427811_chunk ec1_54 (cost=0.00..1.68 rows=23 width=14) (actual time=0.024..0.043 rows=22 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 12
58. 0.043 0.043 ↑ 1.5 2 1

Seq Scan on _hyper_11_427982_chunk ec1_55 (cost=0.00..1.32 rows=3 width=14) (actual time=0.039..0.043 rows=2 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 14
59. 0.046 0.046 ↑ 1.0 10 1

Seq Scan on _hyper_11_428134_chunk ec1_56 (cost=0.00..1.80 rows=10 width=14) (actual time=0.035..0.046 rows=10 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 30
60. 0.858 0.858 ↑ 1.0 1,145 1

Index Only Scan using _hyper_11_428196_chunk_event_change_event_start_time_seat_sol_1 on _hyper_11_428196_chunk ec1_57 (cost=0.28..71.77 rows=1,153 width=14) (actual time=0.061..0.858 rows=1,145 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 45
61. 0.059 0.059 ↑ 1.0 23 1

Seq Scan on _hyper_11_428197_chunk ec1_58 (cost=0.00..2.06 rows=23 width=14) (actual time=0.037..0.059 rows=23 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 31
62. 0.043 0.043 ↑ 1.0 30 1

Seq Scan on _hyper_11_428330_chunk ec1_59 (cost=0.00..2.18 rows=30 width=14) (actual time=0.018..0.043 rows=30 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 29
63. 0.029 0.029 ↑ 1.3 11 1

Seq Scan on _hyper_11_428519_chunk ec1_60 (cost=0.00..1.40 rows=14 width=14) (actual time=0.019..0.029 rows=11 loops=1)

  • Filter: ((seat_sold_count_change > 0) AND (event_start_time > (now() - '90 days'::interval)))
  • Rows Removed by Filter: 9
64. 0.048 0.048 ↑ 126.0 1 1

Index Only Scan using _hyper_11_428900_chunk_event_change_event_start_time_seat_sold_ on _hyper_11_428900_chunk ec1_61 (cost=0.16..16.19 rows=126 width=14) (actual time=0.047..0.048 rows=1 loops=1)

  • Index Cond: ((event_start_time > (now() - '90 days'::interval)) AND (seat_sold_count_change > 0))
  • Heap Fetches: 1
65. 1,309.807 18,680.968 ↓ 1.0 2,729,963 1

Hash (cost=402,764.58..402,764.58 rows=2,639,246 width=12) (actual time=18,680.967..18,680.968 rows=2,729,963 loops=1)

  • Buckets: 4194304 Batches: 1 Memory Usage: 150072kB
66. 17,371.161 17,371.161 ↓ 1.0 2,729,963 1

Index Only Scan using event_id_country_id_movie_id_idx on event e1 (cost=0.56..402,764.58 rows=2,639,246 width=12) (actual time=0.434..17,371.161 rows=2,729,963 loops=1)

  • Index Cond: ((country_id = 1700) AND (movie_id IS NOT NULL))
  • Heap Fetches: 280316
Planning time : 123.003 ms
Execution time : 50,287.803 ms