explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xn51

Settings
# exclusive inclusive rows x rows loops node
1. 62.211 20,785.272 ↑ 1.1 5,416 1

GroupAggregate (cost=99,332.32..107,933.53 rows=5,995 width=541) (actual time=20,637.458..20,785.272 rows=5,416 loops=1)

  • Group Key: th.id
2.          

CTE contacted_theaters_cte

3. 0.779 13.917 ↑ 2.8 59 1

GroupAggregate (cost=1,283.75..1,321.76 rows=168 width=50) (actual time=13.466..13.917 rows=59 loops=1)

  • Group Key: ct_1.theater_id
4. 0.164 13.138 ↑ 11.4 210 1

Sort (cost=1,283.75..1,289.73 rows=2,394 width=82) (actual time=13.119..13.138 rows=210 loops=1)

  • Sort Key: ct_1.theater_id
  • Sort Method: quicksort Memory: 41kB
5. 0.174 12.974 ↑ 11.4 210 1

Hash Join (cost=81.86..1,149.38 rows=2,394 width=82) (actual time=3.502..12.974 rows=210 loops=1)

  • Hash Cond: (ct_1.user_id = us.id)
6. 10.982 10.982 ↓ 1.2 210 1

Seq Scan on data_recovery_contacted_theaters ct_1 (cost=0.00..983.40 rows=177 width=26) (actual time=1.640..10.982 rows=210 loops=1)

  • Filter: ((contacted_date >= '2018-01-15'::date) AND (contacted_date <= '2018-01-21'::date))
  • Rows Removed by Filter: 40150
7. 1.062 1.818 ↑ 1.0 2,705 1

Hash (cost=48.05..48.05 rows=2,705 width=72) (actual time=1.818..1.818 rows=2,705 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 209kB
8. 0.756 0.756 ↑ 1.0 2,705 1

Seq Scan on decrypted_users us (cost=0.00..48.05 rows=2,705 width=72) (actual time=0.020..0.756 rows=2,705 loops=1)

9. 4.408 20,723.061 ↑ 10.5 7,738 1

Nested Loop Left Join (cost=98,010.57..99,006.77 rows=81,082 width=1,399) (actual time=20,637.372..20,723.061 rows=7,738 loops=1)

  • Join Filter: false
10. 3.635 20,718.653 ↑ 10.5 7,738 1

Merge Left Join (cost=98,010.57..98,195.95 rows=81,082 width=1,399) (actual time=20,637.367..20,718.653 rows=7,738 loops=1)

  • Merge Cond: (th.id = mg.theater_id)
11. 52.150 20,709.901 ↓ 1.3 7,680 1

Nested Loop Left Join (cost=97,565.62..97,732.66 rows=5,995 width=1,323) (actual time=20,632.259..20,709.901 rows=7,680 loops=1)

  • Join Filter: (((s.country_id)::text = (th.country_id)::text) AND ((s.id)::text = (th.state_id)::text))
  • Rows Removed by Join Filter: 196677
12. 3.193 20,642.391 ↓ 1.3 7,680 1

Merge Left Join (cost=97,565.62..97,626.12 rows=5,995 width=1,209) (actual time=20,631.788..20,642.391 rows=7,680 loops=1)

  • Merge Cond: (th.id = ct.theater_id)
13. 6.360 20,625.172 ↓ 1.3 7,680 1

Merge Left Join (cost=97,556.05..97,600.64 rows=5,995 width=1,167) (actual time=20,617.763..20,625.172 rows=7,680 loops=1)

  • Merge Cond: (th.id = dj.theater_id)
14. 7.210 20,478.964 ↑ 1.0 5,720 1

Sort (cost=83,369.70..83,384.69 rows=5,995 width=131) (actual time=20,478.285..20,478.964 rows=5,720 loops=1)

  • Sort Key: th.id
  • Sort Method: quicksort Memory: 1509kB
15. 3.279 20,471.754 ↑ 1.0 5,720 1

Hash Left Join (cost=78,688.06..82,993.53 rows=5,995 width=131) (actual time=20,450.450..20,471.754 rows=5,720 loops=1)

  • Hash Cond: (th.circuit_id = ci.id)
16. 7.665 20,463.400 ↑ 1.0 5,720 1

Hash Right Join (cost=78,505.00..82,794.72 rows=5,995 width=110) (actual time=20,445.215..20,463.400 rows=5,720 loops=1)

  • Hash Cond: (id.theater_id = th.id)
17. 11.014 13.945 ↓ 1.0 13,808 1

Bitmap Heap Scan on theater_aliases id (cost=279.90..4,512.80 rows=13,352 width=15) (actual time=3.340..13.945 rows=13,808 loops=1)

  • Recheck Cond: ((source_id)::text = 'BOE'::text)
  • Heap Blocks: exact=347
18. 2.931 2.931 ↓ 1.0 13,808 1

Bitmap Index Scan on ix_theater_aliases_source_id (cost=0.00..276.56 rows=13,352 width=0) (actual time=2.931..2.931 rows=13,808 loops=1)

  • Index Cond: ((source_id)::text = 'BOE'::text)
19. 4.235 20,441.790 ↑ 1.0 5,720 1

Hash (cost=78,150.17..78,150.17 rows=5,995 width=103) (actual time=20,441.790..20,441.790 rows=5,720 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 784kB
20. 4.129 20,437.555 ↑ 1.0 5,720 1

Hash Right Join (cost=76,284.17..78,150.17 rows=5,995 width=103) (actual time=20,411.976..20,437.555 rows=5,720 loops=1)

  • Hash Cond: (pr.theater_id = th.id)
21. 0.354 21.807 ↓ 1.0 3,174 1

Append (cost=0.00..1,852.60 rows=3,147 width=10) (actual time=0.086..21.807 rows=3,174 loops=1)

22. 21.453 21.453 ↓ 1.0 3,174 1

Seq Scan on theater_properties_test_20180101 pr (cost=0.00..1,852.60 rows=3,147 width=10) (actual time=0.086..21.453 rows=3,174 loops=1)

  • Filter: (as_of_date = '2018-01-15'::date)
  • Rows Removed by Filter: 94954
23. 4.278 20,411.619 ↑ 1.0 5,720 1

Hash (cost=76,209.23..76,209.23 rows=5,995 width=101) (actual time=20,411.619..20,411.619 rows=5,720 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 762kB
24. 5.299 20,407.341 ↑ 1.0 5,720 1

Hash Right Join (cost=74,300.33..76,209.23 rows=5,995 width=101) (actual time=20,359.705..20,407.341 rows=5,720 loops=1)

  • Hash Cond: (ta.theater_id = th.id)
25. 43.167 60.358 ↓ 8.1 5,748 1

Bitmap Heap Scan on theater_aliases ta (cost=1,197.79..3,104.83 rows=708 width=15) (actual time=17.550..60.358 rows=5,748 loops=1)

  • Recheck Cond: (((source_id)::text = ANY ('{AMC,AGILE,ALAMODRAFTHOUSE,ALLURE,AZTECADELRIOBRAVO,BNB,BONNERMALL,CMX,CAPRITHEATRE,CARIBBEANCINEMAS,CENTEREDGE,CINELEO,CINECENTRE,CINEMACOLIBRI,CINEMAPARAMOUNT,CINEMAGIC,CINEMAGIC-USA,CINEMARK,CINEMARK-PERU,CINEMASDELCOUNTRY,CINEMASHENRY,CINEMEX,CINEPLANET,CINEPOLIS,CINEPOLISPERU,CINERAMA,CINESTAR,CITICINEMAS,COBB-IMPORT,EMS,EASYWARE,EXHIBIDORADELBRAVO,FILMBOT,FINO,HARKINS,KWIC,LANDMARK,LIMELIGHT,LOEKS,LOOKCINEMAS,MJR,MALCO,MANUAL-ENTRY,MARCUS,MARQUEE,MAYA,MOVIEHEROES,NCSOFTWARE,NATIONALAMUSEMENTS,OCEANCINEMAS,OMNITERM,OMNITERM-ALT,ORPHEUM,PACIFIC,PACIFIC-VISTA,POHNPEI,RTS,RADIANT,ALT-TAX-RADIANT,RADIANT-HEADQUARTERS,READING,READINGVISTA,REGAL,RETRIEVER,RETRIEVER-AU,RETRIEVER2,SENSIBLE,SOUTHERNTHEATRES,STARLIGHT,STUDIOMOVIEGRILL,SYSTEMBCN,SYUFY,TAPOS,TAPOS-AU,TEXASCINEMAS,THELOT,TITAN,UVK,ULTRASTAR,VEEZI,VENUE,VISTA,WUNDERLANDGAMES}'::text[])) AND (source_type = 'EXT'::text))
  • Heap Blocks: exact=815
26. 0.110 17.191 ↓ 0.0 0 1

BitmapAnd (cost=1,197.79..1,197.79 rows=708 width=0) (actual time=17.191..17.191 rows=0 loops=1)

27. 10.097 10.097 ↑ 1.2 6,266 1

Bitmap Index Scan on ix_theater_aliases_source_id (cost=0.00..413.23 rows=7,251 width=0) (actual time=10.097..10.097 rows=6,266 loops=1)

  • Index Cond: ((source_id)::text = ANY ('{AMC,AGILE,ALAMODRAFTHOUSE,ALLURE,AZTECADELRIOBRAVO,BNB,BONNERMALL,CMX,CAPRITHEATRE,CARIBBEANCINEMAS,CENTEREDGE,CINELEO,CINECENTRE,CINEMACOLIBRI,CINEMAPARAMOUNT,CINEMAGIC,CINEMAGIC-USA,CINEMARK,CINEMARK-PERU,CINEMASDELCOUNTRY,CINEMASHENRY,CINEMEX,CINEPLANET,CINEPOLIS,CINEPOLISPERU,CINERAMA,CINESTAR,CITICINEMAS,COBB-IMPORT,EMS,EASYWARE,EXHIBIDORADELBRAVO,FILMBOT,FINO,HARKINS,KWIC,LANDMARK,LIMELIGHT,LOEKS,LOOKCINEMAS,MJR,MALCO,MANUAL-ENTRY,MARCUS,MARQUEE,MAYA,MOVIEHEROES,NCSOFTWARE,NATIONALAMUSEMENTS,OCEANCINEMAS,OMNITERM,OMNITERM-ALT,ORPHEUM,PACIFIC,PACIFIC-VISTA,POHNPEI,RTS,RADIANT,ALT-TAX-RADIANT,RADIANT-HEADQUARTERS,READING,READINGVISTA,REGAL,RETRIEVER,RETRIEVER-AU,RETRIEVER2,SENSIBLE,SOUTHERNTHEATRES,STARLIGHT,STUDIOMOVIEGRILL,SYSTEMBCN,SYUFY,TAPOS,TAPOS-AU,TEXASCINEMAS,THELOT,TITAN,UVK,ULTRASTAR,VEEZI,VENUE,VISTA,WUNDERLANDGAMES}'::text[]))
28. 6.984 6.984 ↑ 1.0 34,997 1

Bitmap Index Scan on ix_theater_aliases_source_type (cost=0.00..783.96 rows=35,138 width=0) (actual time=6.984..6.984 rows=34,997 loops=1)

  • Index Cond: (source_type = 'EXT'::text)
29. 15.976 20,341.684 ↑ 1.1 5,416 1

Hash (cost=73,027.61..73,027.61 rows=5,995 width=94) (actual time=20,341.684..20,341.684 rows=5,416 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 688kB
30. 495.283 20,325.708 ↑ 1.1 5,416 1

Bitmap Heap Scan on theaters th (cost=743.85..73,027.61 rows=5,995 width=94) (actual time=77.225..20,325.708 rows=5,416 loops=1)

  • Recheck Cond: ((country_id)::text = 'US'::text)
  • Filter: (SubPlan 2)
  • Rows Removed by Filter: 6948
  • Heap Blocks: exact=3808
31. 60.389 60.389 ↓ 1.0 12,364 1

Bitmap Index Scan on ix_theaters_country_49 (cost=0.00..742.35 rows=11,991 width=0) (actual time=60.389..60.389 rows=12,364 loops=1)

  • Index Cond: ((country_id)::text = 'US'::text)
32.          

SubPlan (for Bitmap Heap Scan)

33. 6,417.681 19,770.036 ↓ 0.0 0 12,364

Append (cost=0.16..2,989.58 rows=816 width=0) (actual time=1.599..1.599 rows=0 loops=12,364)

34. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20060101 on theater_properties_test_20060101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
35. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20060201 on theater_properties_test_20060201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
36. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20060301 on theater_properties_test_20060301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
37. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20060401 on theater_properties_test_20060401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
38. 210.188 210.188 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20060501 (cost=0.00..2.82 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 81
39. 123.640 123.640 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20060601 (cost=0.00..2.01 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 45
40. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20060701 on theater_properties_test_20060701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
41. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20060801 on theater_properties_test_20060801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
42. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20060901 on theater_properties_test_20060901 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
43. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20061001 on theater_properties_test_20061001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
44. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20061101 on theater_properties_test_20061101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
45. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20061201 on theater_properties_test_20061201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
46. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20070101 on theater_properties_test_20070101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
47. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20070201 on theater_properties_test_20070201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
48. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20070301 on theater_properties_test_20070301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
49. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20070401 on theater_properties_test_20070401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
50. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20070501 on theater_properties_test_20070501 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
51. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20070601 on theater_properties_test_20070601 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
52. 160.732 160.732 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20070701 (cost=0.00..2.26 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 56
53. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20070801 on theater_properties_test_20070801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
54. 259.644 259.644 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20070901 (cost=0.00..3.29 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 102
55. 160.732 160.732 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20071001 (cost=0.00..2.33 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 59
56. 86.548 86.548 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20071101 (cost=0.00..1.67 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 30
57. 111.276 111.276 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20071201 (cost=0.00..1.90 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 40
58. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080101 on theater_properties_test_20080101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
59. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080201 on theater_properties_test_20080201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
60. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080301 on theater_properties_test_20080301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
61. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080401 on theater_properties_test_20080401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
62. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080501 on theater_properties_test_20080501 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
63. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080601 on theater_properties_test_20080601 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
64. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080701 on theater_properties_test_20080701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
65. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20080801 on theater_properties_test_20080801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
66. 74.184 74.184 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20080901 (cost=0.00..1.47 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 21
67. 24.728 24.728 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20081001 (cost=0.00..1.02 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 1
68. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20081101 (cost=0.00..1.14 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 6
69. 160.732 160.732 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20081201 (cost=0.00..2.42 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 63
70. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20090101 on theater_properties_test_20090101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
71. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20090201 on theater_properties_test_20090201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
72. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20090301 on theater_properties_test_20090301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
73. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20090401 on theater_properties_test_20090401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
74. 61.820 61.820 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20090501 (cost=0.00..1.31 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 14
75. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20090601 on theater_properties_test_20090601 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
76. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20090701 (cost=0.00..1.11 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 5
77. 173.096 173.096 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20090801 (cost=0.00..2.46 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 65
78. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20090901 (cost=0.00..1.16 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
79. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20091001 on theater_properties_test_20091001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
80. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20091101 on theater_properties_test_20091101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
81. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20091201 on theater_properties_test_20091201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
82. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100101 on theater_properties_test_20100101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
83. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100201 on theater_properties_test_20100201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
84. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100301 on theater_properties_test_20100301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
85. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100401 on theater_properties_test_20100401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
86. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100501 on theater_properties_test_20100501 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
87. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100601 on theater_properties_test_20100601 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
88. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100701 on theater_properties_test_20100701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
89. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100801 on theater_properties_test_20100801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
90. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20100901 on theater_properties_test_20100901 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
91. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20101001 on theater_properties_test_20101001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
92. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20101101 on theater_properties_test_20101101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
93. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20101201 on theater_properties_test_20101201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
94. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20110101 on theater_properties_test_20110101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
95. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20110201 on theater_properties_test_20110201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
96. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20110301 on theater_properties_test_20110301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
97. 123.640 123.640 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20110401 (cost=0.00..1.88 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 39
98. 185.460 185.460 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20110501 (cost=0.00..2.60 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 71
99. 24.728 24.728 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20110601 (cost=0.00..1.04 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 2
100. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20110701 on theater_properties_test_20110701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
101. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20110801 on theater_properties_test_20110801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
102. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20110901 on theater_properties_test_20110901 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
103. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20111001 on theater_properties_test_20111001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
104. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20111101 on theater_properties_test_20111101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
105. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20111201 on theater_properties_test_20111201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
106. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20120101 on theater_properties_test_20120101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
107. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20120201 (cost=0.00..1.14 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 6
108. 98.912 98.912 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20120301 (cost=0.00..1.70 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 31
109. 86.548 86.548 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20120401 (cost=0.00..1.58 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 26
110. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20120501 on theater_properties_test_20120501 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
111. 111.276 111.276 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20120601 (cost=0.00..1.79 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 35
112. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20120701 on theater_properties_test_20120701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
113. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20120801 on theater_properties_test_20120801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
114. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20120901 (cost=0.00..1.16 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
115. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20121001 on theater_properties_test_20121001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
116. 24.728 24.728 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20121101 (cost=0.00..1.02 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 1
117. 61.820 61.820 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20121201 (cost=0.00..1.29 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 13
118. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20130101 on theater_properties_test_20130101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
119. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20130201 on theater_properties_test_20130201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
120. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20130301 (cost=0.00..1.16 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
121. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20130401 on theater_properties_test_20130401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
122. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20130501 on theater_properties_test_20130501 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
123. 61.820 61.820 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20130601 (cost=0.00..1.31 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 14
124. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20130701 on theater_properties_test_20130701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
125. 24.728 24.728 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20130801 (cost=0.00..1.04 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 2
126. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20130901 (cost=0.00..1.11 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 5
127. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20131001 on theater_properties_test_20131001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
128. 61.820 61.820 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20131101 (cost=0.00..1.31 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 14
129. 49.456 49.456 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20131201 (cost=0.00..1.31 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 14
130. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140101 on theater_properties_test_20140101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
131. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140201 on theater_properties_test_20140201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
132. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140301 on theater_properties_test_20140301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
133. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140401 on theater_properties_test_20140401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
134. 24.728 24.728 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140501 on theater_properties_test_20140501 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
135. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140601 on theater_properties_test_20140601 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
136. 234.916 234.916 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20140701 (cost=0.00..3.05 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 91
137. 61.820 61.820 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140801 on theater_properties_test_20140801 (cost=0.15..4.18 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
138. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20140901 on theater_properties_test_20140901 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
139. 86.548 86.548 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20141001 (cost=0.00..1.56 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 25
140. 49.456 49.456 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20141101 on theater_properties_test_20141101 (cost=0.15..4.17 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
141. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20141201 on theater_properties_test_20141201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
142. 74.184 74.184 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150101 (cost=0.00..1.41 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 18
143. 49.456 49.456 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150201 (cost=0.00..1.23 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 10
144. 123.640 123.640 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150301 (cost=0.00..1.92 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 41
145. 234.916 234.916 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150401 (cost=0.00..3.07 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 92
146. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150501 (cost=0.00..1.16 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
147. 74.184 74.184 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150601 (cost=0.00..1.47 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 21
148. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20150701 on theater_properties_test_20150701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
149. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150801 (cost=0.00..1.16 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
150. 49.456 49.456 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20150901 (cost=0.00..1.27 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 12
151. 49.456 49.456 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20151001 (cost=0.00..1.25 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 11
152. 49.456 49.456 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20151101 (cost=0.00..1.27 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 12
153. 173.096 173.096 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20151201 (cost=0.00..2.42 rows=1 width=0) (actual time=0.014..0.014 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 63
154. 37.092 37.092 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20160101 on theater_properties_test_20160101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
155. 49.456 49.456 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20160201 (cost=0.00..1.25 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 11
156. 74.184 74.184 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20160301 (cost=0.00..1.54 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 24
157. 37.092 37.092 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20160401 (cost=0.00..1.18 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 8
158. 321.464 321.464 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20160501 (cost=0.00..3.95 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 131
159. 346.192 346.192 ↓ 0.0 0 12,364

Seq Scan on theater_properties_test_20160601 (cost=0.00..4.17 rows=1 width=0) (actual time=0.028..0.028 rows=0 loops=12,364)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 141
160. 49.456 49.456 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20160701 on theater_properties_test_20160701 (cost=0.15..4.17 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
161. 74.184 74.184 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20160801 on theater_properties_test_20160801 (cost=0.28..4.31 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
162. 61.820 61.820 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20160901 on theater_properties_test_20160901 (cost=0.28..4.31 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
163. 61.820 61.820 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20161001 on theater_properties_test_20161001 (cost=0.29..4.31 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
164. 74.184 74.184 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20161101 on theater_properties_test_20161101 (cost=0.29..4.31 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
165. 86.548 86.548 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20161201 on theater_properties_test_20161201 (cost=0.29..4.32 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
166. 346.192 346.192 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20170101 on theater_properties_test_20170101 (cost=0.44..4.46 rows=1 width=0) (actual time=0.028..0.028 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
167. 272.008 272.008 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20170201 on theater_properties_test_20170201 (cost=0.44..4.46 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
168. 197.824 197.824 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20170301 on theater_properties_test_20170301 (cost=0.44..4.46 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
169. 160.732 160.732 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20170401 on theater_properties_test_20170401 (cost=0.44..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
170. 160.732 160.732 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20170501 on theater_properties_test_20170501 (cost=0.44..4.46 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
171. 185.460 185.460 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20170601 on theater_properties_test_20170601 (cost=0.44..4.46 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
172. 210.188 210.188 ↓ 0.0 0 12,364

Index Only Scan using ix_theater_properties_test_is_reporting_20170701 on theater_properties_test_20170701 (cost=0.44..4.61 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=12,364)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
173. 166.608 166.608 ↓ 0.0 0 9,256

Index Only Scan using ix_theater_properties_test_is_reporting_20170801 on theater_properties_test_20170801 (cost=0.44..4.83 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=9,256)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
174. 154.904 154.904 ↓ 0.0 0 9,112

Index Only Scan using ix_theater_properties_test_is_reporting_20170901 on theater_properties_test_20170901 (cost=0.44..4.81 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=9,112)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
175. 278.349 278.349 ↓ 0.0 0 8,979

Index Only Scan using ix_theater_properties_test_is_reporting_20171001 on theater_properties_test_20171001 (cost=0.44..4.83 rows=1 width=0) (actual time=0.031..0.031 rows=0 loops=8,979)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
176. 35.628 124.698 ↓ 0.0 0 8,907

Bitmap Heap Scan on theater_properties_test_20171101 (cost=4.68..89.15 rows=25 width=0) (actual time=0.014..0.014 rows=0 loops=8,907)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=66
177. 89.070 89.070 ↓ 0.0 0 8,907

Bitmap Index Scan on uq_theater_properties_test_20171101 (cost=0.00..4.68 rows=25 width=0) (actual time=0.010..0.010 rows=0 loops=8,907)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
178. 26.523 123.774 ↓ 0.0 0 8,841

Bitmap Heap Scan on theater_properties_test_20171201 (cost=4.70..96.14 rows=27 width=0) (actual time=0.014..0.014 rows=0 loops=8,841)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=38
179. 97.251 97.251 ↓ 0.0 0 8,841

Bitmap Index Scan on uq_theater_properties_test_20171201 (cost=0.00..4.70 rows=27 width=0) (actual time=0.011..0.011 rows=0 loops=8,841)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
180. 26.409 123.242 ↓ 0.0 0 8,803

Bitmap Heap Scan on theater_properties_test_20180101 (cost=4.71..99.58 rows=28 width=0) (actual time=0.014..0.014 rows=0 loops=8,803)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=61
181. 96.833 96.833 ↓ 0.0 0 8,803

Bitmap Index Scan on uq_theater_properties_test_20180101 (cost=0.00..4.71 rows=28 width=0) (actual time=0.011..0.011 rows=0 loops=8,803)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
182. 26.226 113.646 ↓ 0.0 0 8,742

Bitmap Heap Scan on theater_properties_test_20180201 (cost=4.68..89.44 rows=25 width=0) (actual time=0.013..0.013 rows=0 loops=8,742)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=48
183. 87.420 87.420 ↓ 0.0 0 8,742

Bitmap Index Scan on uq_theater_properties_test_20180201 (cost=0.00..4.68 rows=25 width=0) (actual time=0.010..0.010 rows=0 loops=8,742)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
184. 26.082 113.022 ↓ 0.0 0 8,694

Bitmap Heap Scan on theater_properties_test_20180301 (cost=4.69..93.23 rows=26 width=0) (actual time=0.013..0.013 rows=0 loops=8,694)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=183
185. 86.940 86.940 ↓ 0.0 0 8,694

Bitmap Index Scan on uq_theater_properties_test_20180301 (cost=0.00..4.69 rows=26 width=0) (actual time=0.010..0.010 rows=0 loops=8,694)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
186. 25.533 110.643 ↓ 0.0 0 8,511

Bitmap Heap Scan on theater_properties_test_20180401 (cost=4.69..92.82 rows=26 width=0) (actual time=0.013..0.013 rows=0 loops=8,511)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=25
187. 85.110 85.110 ↓ 0.0 0 8,511

Bitmap Index Scan on uq_theater_properties_test_20180401 (cost=0.00..4.69 rows=26 width=0) (actual time=0.010..0.010 rows=0 loops=8,511)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
188. 25.458 110.318 ↓ 0.0 0 8,486

Bitmap Heap Scan on theater_properties_test_20180501 (cost=4.70..96.18 rows=27 width=0) (actual time=0.013..0.013 rows=0 loops=8,486)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=26
189. 84.860 84.860 ↓ 0.0 0 8,486

Bitmap Index Scan on uq_theater_properties_test_20180501 (cost=0.00..4.70 rows=27 width=0) (actual time=0.010..0.010 rows=0 loops=8,486)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
190. 33.840 135.360 ↓ 0.0 0 8,460

Bitmap Heap Scan on theater_properties_test_20180601 (cost=4.69..94.74 rows=26 width=0) (actual time=0.016..0.016 rows=0 loops=8,460)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=748
191. 101.520 101.520 ↑ 13.0 2 8,460

Bitmap Index Scan on uq_theater_properties_test_20180601 (cost=0.00..4.69 rows=26 width=0) (actual time=0.012..0.012 rows=2 loops=8,460)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
192. 23.136 123.392 ↓ 0.0 0 7,712

Bitmap Heap Scan on theater_properties_test_20180701 (cost=4.68..91.72 rows=25 width=0) (actual time=0.016..0.016 rows=0 loops=7,712)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=282
193. 100.256 100.256 ↓ 0.0 0 7,712

Bitmap Index Scan on uq_theater_properties_test_20180701 (cost=0.00..4.68 rows=25 width=0) (actual time=0.013..0.013 rows=0 loops=7,712)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
194. 14.860 126.310 ↓ 0.0 0 7,430

Bitmap Heap Scan on theater_properties_test_20180801 (cost=4.69..95.09 rows=26 width=0) (actual time=0.017..0.017 rows=0 loops=7,430)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=67
195. 111.450 111.450 ↓ 0.0 0 7,430

Bitmap Index Scan on uq_theater_properties_test_20180801 (cost=0.00..4.69 rows=26 width=0) (actual time=0.015..0.015 rows=0 loops=7,430)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
196. 22.089 125.171 ↓ 0.0 0 7,363

Bitmap Heap Scan on theater_properties_test_20180901 (cost=4.66..84.89 rows=23 width=0) (actual time=0.017..0.017 rows=0 loops=7,363)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=185
197. 103.082 103.082 ↓ 0.0 0 7,363

Bitmap Index Scan on uq_theater_properties_test_20180901 (cost=0.00..4.66 rows=23 width=0) (actual time=0.014..0.014 rows=0 loops=7,363)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
198. 21.534 129.204 ↓ 0.0 0 7,178

Bitmap Heap Scan on theater_properties_test_20181001 (cost=4.68..91.88 rows=25 width=0) (actual time=0.018..0.018 rows=0 loops=7,178)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=42
199. 107.670 107.670 ↓ 0.0 0 7,178

Bitmap Index Scan on uq_theater_properties_test_20181001 (cost=0.00..4.68 rows=25 width=0) (actual time=0.015..0.015 rows=0 loops=7,178)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
200. 14.272 107.040 ↓ 0.0 0 7,136

Bitmap Heap Scan on theater_properties_test_20181101 (cost=4.67..87.71 rows=24 width=0) (actual time=0.015..0.015 rows=0 loops=7,136)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=12
201. 92.768 92.768 ↓ 0.0 0 7,136

Bitmap Index Scan on uq_theater_properties_test_20181101 (cost=0.00..4.67 rows=24 width=0) (actual time=0.013..0.013 rows=0 loops=7,136)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
202. 21.372 106.860 ↓ 0.0 0 7,124

Bitmap Heap Scan on theater_properties_test_20181201 (cost=4.71..100.11 rows=28 width=0) (actual time=0.015..0.015 rows=0 loops=7,124)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=16
203. 85.488 85.488 ↓ 0.0 0 7,124

Bitmap Index Scan on uq_theater_properties_test_20181201 (cost=0.00..4.71 rows=28 width=0) (actual time=0.012..0.012 rows=0 loops=7,124)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
204. 21.324 106.620 ↓ 0.0 0 7,108

Bitmap Heap Scan on theater_properties_test_20190101 (cost=4.71..100.31 rows=28 width=0) (actual time=0.015..0.015 rows=0 loops=7,108)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=9
205. 85.296 85.296 ↓ 0.0 0 7,108

Bitmap Index Scan on uq_theater_properties_test_20190101 (cost=0.00..4.71 rows=28 width=0) (actual time=0.012..0.012 rows=0 loops=7,108)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
206. 21.297 99.386 ↓ 0.0 0 7,099

Bitmap Heap Scan on theater_properties_test_20190201 (cost=4.68..89.96 rows=25 width=0) (actual time=0.014..0.014 rows=0 loops=7,099)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=10
207. 78.089 78.089 ↓ 0.0 0 7,099

Bitmap Index Scan on uq_theater_properties_test_20190201 (cost=0.00..4.68 rows=25 width=0) (actual time=0.011..0.011 rows=0 loops=7,099)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
208. 21.267 106.335 ↓ 0.0 0 7,089

Bitmap Heap Scan on theater_properties_test_20190301 (cost=4.68..90.77 rows=25 width=0) (actual time=0.015..0.015 rows=0 loops=7,089)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=13
209. 85.068 85.068 ↓ 0.0 0 7,089

Bitmap Index Scan on uq_theater_properties_test_20190301 (cost=0.00..4.68 rows=25 width=0) (actual time=0.012..0.012 rows=0 loops=7,089)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
210. 14.152 99.064 ↓ 0.0 0 7,076

Bitmap Heap Scan on theater_properties_test_20190401 (cost=4.68..90.48 rows=25 width=0) (actual time=0.014..0.014 rows=0 loops=7,076)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=10
211. 84.912 84.912 ↓ 0.0 0 7,076

Bitmap Index Scan on uq_theater_properties_test_20190401 (cost=0.00..4.68 rows=25 width=0) (actual time=0.012..0.012 rows=0 loops=7,076)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
212. 21.198 105.990 ↓ 0.0 0 7,066

Bitmap Heap Scan on theater_properties_test_20190501 (cost=4.69..94.53 rows=26 width=0) (actual time=0.015..0.015 rows=0 loops=7,066)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=19
213. 84.792 84.792 ↓ 0.0 0 7,066

Bitmap Index Scan on uq_theater_properties_test_20190501 (cost=0.00..4.69 rows=26 width=0) (actual time=0.012..0.012 rows=0 loops=7,066)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
214. 21.141 112.752 ↓ 0.0 0 7,047

Bitmap Heap Scan on theater_properties_test_20190601 (cost=4.67..88.58 rows=24 width=0) (actual time=0.016..0.016 rows=0 loops=7,047)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=89
215. 91.611 91.611 ↓ 0.0 0 7,047

Bitmap Index Scan on uq_theater_properties_test_20190601 (cost=0.00..4.67 rows=24 width=0) (actual time=0.013..0.013 rows=0 loops=7,047)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
216. 20.874 139.160 ↓ 0.0 0 6,958

Bitmap Heap Scan on theater_properties_test_20190701 (cost=4.70..99.84 rows=27 width=0) (actual time=0.020..0.020 rows=0 loops=6,958)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=9
217. 118.286 118.286 ↓ 0.0 0 6,958

Bitmap Index Scan on uq_theater_properties_test_20190701 (cost=0.00..4.70 rows=27 width=0) (actual time=0.017..0.017 rows=0 loops=6,958)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
218. 20.847 76.439 ↓ 0.0 0 6,949

Bitmap Heap Scan on theater_properties_test_20190801 (cost=4.40..38.66 rows=10 width=0) (actual time=0.011..0.011 rows=0 loops=6,949)

  • Recheck Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Filter: is_reporting
  • Heap Blocks: exact=1
219. 55.592 55.592 ↓ 0.0 0 6,949

Bitmap Index Scan on uq_theater_properties_test_20190801 (cost=0.00..4.40 rows=10 width=0) (actual time=0.008..0.008 rows=0 loops=6,949)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
220. 97.272 97.272 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20190901 (cost=0.00..2.33 rows=8 width=0) (actual time=0.014..0.014 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 59
221. 48.636 48.636 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20191001 (cost=0.00..1.52 rows=8 width=0) (actual time=0.007..0.007 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 23
222. 20.844 20.844 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20191101 (cost=0.00..1.16 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
223. 20.844 20.844 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20191201 (cost=0.00..1.14 rows=6 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 6
224. 13.896 13.896 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200101 (cost=0.00..1.02 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 1
225. 97.272 97.272 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200201 (cost=0.00..2.42 rows=7 width=0) (actual time=0.014..0.014 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 63
226. 34.740 34.740 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200301 (cost=0.00..1.31 rows=7 width=0) (actual time=0.005..0.005 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 14
227. 20.844 20.844 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200401 (cost=0.00..1.16 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
228. 20.844 20.844 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200501 (cost=0.00..1.16 rows=7 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
229. 27.792 27.792 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200601 (cost=0.00..1.23 rows=5 width=0) (actual time=0.004..0.004 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 10
230. 20.844 20.844 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200701 (cost=0.00..1.09 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 4
231. 20.844 20.844 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20200801 on theater_properties_test_20200801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
232. 27.792 27.792 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20200901 (cost=0.00..1.16 rows=7 width=0) (actual time=0.004..0.004 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 7
233. 20.844 20.844 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20201001 on theater_properties_test_20201001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
234. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20201101 on theater_properties_test_20201101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
235. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20201201 on theater_properties_test_20201201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
236. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20210101 on theater_properties_test_20210101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
237. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20210201 on theater_properties_test_20210201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
238. 34.740 34.740 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20210301 (cost=0.00..1.29 rows=6 width=0) (actual time=0.005..0.005 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 13
239. 13.896 13.896 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20210401 (cost=0.00..1.02 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 1
240. 97.272 97.272 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20210501 (cost=0.00..2.42 rows=7 width=0) (actual time=0.014..0.014 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 63
241. 34.740 34.740 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20210601 (cost=0.00..1.31 rows=7 width=0) (actual time=0.005..0.005 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 14
242. 20.844 20.844 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20210701 on theater_properties_test_20210701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
243. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20210801 on theater_properties_test_20210801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
244. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20210901 on theater_properties_test_20210901 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
245. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20211001 on theater_properties_test_20211001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
246. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20211101 on theater_properties_test_20211101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
247. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20211201 on theater_properties_test_20211201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
248. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220101 on theater_properties_test_20220101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
249. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220201 on theater_properties_test_20220201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
250. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220301 on theater_properties_test_20220301 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
251. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220401 on theater_properties_test_20220401 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
252. 55.584 55.584 ↓ 0.0 0 6,948

Seq Scan on theater_properties_test_20220501 (cost=0.00..1.63 rows=7 width=0) (actual time=0.008..0.008 rows=0 loops=6,948)

  • Filter: (is_reporting AND (theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)))
  • Rows Removed by Filter: 28
253. 20.844 20.844 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220601 on theater_properties_test_20220601 (cost=0.16..8.21 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
254. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220701 on theater_properties_test_20220701 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
255. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220801 on theater_properties_test_20220801 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
256. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20220901 on theater_properties_test_20220901 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
257. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20221001 on theater_properties_test_20221001 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
258. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20221101 on theater_properties_test_20221101 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
259. 13.896 13.896 ↓ 0.0 0 6,948

Index Only Scan using ix_theater_properties_test_is_reporting_20221201 on theater_properties_test_20221201 (cost=0.16..8.21 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=6,948)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2018-01-15'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 0
260. 2.469 5.075 ↑ 1.0 6,047 1

Hash (cost=107.47..107.47 rows=6,047 width=29) (actual time=5.075..5.075 rows=6,047 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 432kB
261. 2.606 2.606 ↑ 1.0 6,047 1

Seq Scan on circuits ci (cost=0.00..107.47 rows=6,047 width=29) (actual time=0.463..2.606 rows=6,047 loops=1)

262. 2.541 139.848 ↓ 1.4 3,587 1

Sort (cost=14,186.35..14,192.98 rows=2,652 width=1,044) (actual time=139.468..139.848 rows=3,587 loops=1)

  • Sort Key: dj.theater_id
  • Sort Method: quicksort Memory: 373kB
263. 1.752 137.307 ↓ 1.3 3,535 1

Hash Left Join (cost=1.99..14,035.54 rows=2,652 width=1,044) (actual time=46.394..137.307 rows=3,535 loops=1)

  • Hash Cond: (dj.justification_id = (ju.id)::text)
264. 134.005 134.005 ↓ 1.3 3,535 1

Seq Scan on data_recovery_justifications dj (cost=0.00..14,025.92 rows=2,652 width=14) (actual time=44.812..134.005 rows=3,535 loops=1)

  • Filter: ((booking_date >= '2018-01-15'::date) AND (booking_date <= '2018-01-21'::date))
  • Rows Removed by Filter: 646260
265. 0.029 1.550 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=1,032) (actual time=1.550..1.550 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
266. 1.521 1.521 ↑ 1.0 44 1

Seq Scan on justifications ju (cost=0.00..1.44 rows=44 width=1,032) (actual time=1.509..1.521 rows=44 loops=1)

267. 0.049 14.026 ↑ 1.9 87 1

Sort (cost=9.57..9.99 rows=168 width=50) (actual time=14.020..14.026 rows=87 loops=1)

  • Sort Key: ct.theater_id
  • Sort Method: quicksort Memory: 29kB
268. 13.977 13.977 ↑ 2.8 59 1

CTE Scan on contacted_theaters_cte ct (cost=0.00..3.36 rows=168 width=50) (actual time=13.478..13.977 rows=59 loops=1)

269. 14.909 15.360 ↓ 27.0 27 7,680

Materialize (cost=0.00..1.63 rows=1 width=154) (actual time=0.000..0.002 rows=27 loops=7,680)

270. 0.451 0.451 ↓ 50.0 50 1

Seq Scan on states s (cost=0.00..1.62 rows=1 width=154) (actual time=0.434..0.451 rows=50 loops=1)

  • Filter: ((country_id)::text = 'US'::text)
271. 0.045 5.117 ↑ 4.3 141 1

Sort (cost=444.94..446.47 rows=609 width=84) (actual time=5.102..5.117 rows=141 loops=1)

  • Sort Key: mg.theater_id
  • Sort Method: quicksort Memory: 31kB
272. 0.139 5.072 ↑ 13.8 44 1

Hash Left Join (cost=81.86..416.78 rows=609 width=84) (actual time=3.943..5.072 rows=44 loops=1)

  • Hash Cond: (mg.user_id = nu.id)
273. 3.205 3.205 ↑ 1.0 44 1

Seq Scan on data_recovery_mg_ignored_dates mg (cost=0.00..313.52 rows=45 width=28) (actual time=2.101..3.205 rows=44 loops=1)

  • Filter: ((ignored_date >= '2018-01-15'::date) AND (ignored_date <= '2018-01-21'::date))
  • Rows Removed by Filter: 13391
274. 1.019 1.728 ↑ 1.0 2,705 1

Hash (cost=48.05..48.05 rows=2,705 width=72) (actual time=1.728..1.728 rows=2,705 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 209kB
275. 0.709 0.709 ↑ 1.0 2,705 1

Seq Scan on decrypted_users nu (cost=0.00..48.05 rows=2,705 width=72) (actual time=0.017..0.709 rows=2,705 loops=1)

276. 0.000 0.000 ↓ 0.0 0 7,738

Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.000..0.000 rows=0 loops=7,738)

  • One-Time Filter: false
Planning time : 254.446 ms
Execution time : 20,810.157 ms