explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e4z4

Settings
# exclusive inclusive rows x rows loops node
1. 21.203 3,306.704 ↑ 144.9 5,505 1

GroupAggregate (cost=6,501,247.21..7,502,347.61 rows=797,769 width=508) (actual time=3,281.737..3,306.704 rows=5,505 loops=1)

  • Group Key: th.id
2.          

CTE contacted_theaters_cte

3. 0.384 9.470 ↑ 5.6 39 1

GroupAggregate (cost=1,574.30..1,626.11 rows=217 width=50) (actual time=9.112..9.470 rows=39 loops=1)

  • Group Key: ct_1.theater_id
4. 0.240 9.086 ↑ 12.0 273 1

Sort (cost=1,574.30..1,582.48 rows=3,273 width=82) (actual time=8.987..9.086 rows=273 loops=1)

  • Sort Key: ct_1.theater_id
  • Sort Method: quicksort Memory: 46kB
5. 0.245 8.846 ↑ 12.0 273 1

Hash Join (cost=85.77..1,383.21 rows=3,273 width=82) (actual time=3.307..8.846 rows=273 loops=1)

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

Seq Scan on data_recovery_contacted_theaters ct_1 (cost=0.00..1,182.42 rows=231 width=26) (actual time=0.243..5.548 rows=273 loops=1)

  • Filter: ((contacted_date >= '2017-10-20'::date) AND (contacted_date <= '2017-10-26'::date))
  • Rows Removed by Filter: 47822
7. 1.607 3.053 ↑ 1.0 2,834 1

Hash (cost=50.34..50.34 rows=2,834 width=72) (actual time=3.053..3.053 rows=2,834 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 218kB
8. 1.446 1.446 ↑ 1.0 2,834 1

Seq Scan on decrypted_users us (cost=0.00..50.34 rows=2,834 width=72) (actual time=0.010..1.446 rows=2,834 loops=1)

9. 12.391 3,285.501 ↑ 1,334.0 8,474 1

Sort (cost=6,499,621.10..6,527,882.07 rows=11,304,387 width=272) (actual time=3,281.722..3,285.501 rows=8,474 loops=1)

  • Sort Key: th.id
  • Sort Method: quicksort Memory: 2570kB
10. 0.000 3,273.110 ↑ 1,334.0 8,474 1

Nested Loop Left Join (cost=3,461,062.45..3,745,680.72 rows=11,304,387 width=272) (actual time=3,236.057..3,273.110 rows=8,474 loops=1)

  • Join Filter: false
  • Join Filter: false
11. 9.740 3,257.684 ↑ 1,334.0 8,474 1

Merge Right Join (cost=3,461,062.45..3,632,636.85 rows=11,304,387 width=272) (actual time=3,236.052..3,257.684 rows=8,474 loops=1)

  • Merge Cond: (nu.id = mg.user_id)
12. 2.478 3.941 ↑ 6.0 472 1

Sort (cost=212.85..219.94 rows=2,834 width=72) (actual time=3.698..3.941 rows=472 loops=1)

  • Sort Key: nu.id
  • Sort Method: quicksort Memory: 323kB
13. 1.463 1.463 ↑ 1.0 2,834 1

Seq Scan on decrypted_users nu (cost=0.00..50.34 rows=2,834 width=72) (actual time=0.006..1.463 rows=2,834 loops=1)

14. 7.895 3,244.003 ↑ 94.1 8,474 1

Materialize (cost=3,460,849.60..3,464,838.45 rows=797,769 width=216) (actual time=3,232.316..3,244.003 rows=8,474 loops=1)

15. 12.077 3,236.108 ↑ 94.1 8,474 1

Sort (cost=3,460,849.60..3,462,844.02 rows=797,769 width=216) (actual time=3,232.312..3,236.108 rows=8,474 loops=1)

  • Sort Key: mg.user_id
  • Sort Method: quicksort Memory: 2580kB
16. 10.058 3,224.031 ↑ 94.1 8,474 1

Hash Left Join (cost=3,266,554.01..3,300,840.36 rows=797,769 width=216) (actual time=3,138.119..3,224.031 rows=8,474 loops=1)

  • Hash Cond: (((th.country_id)::text = (s.country_id)::text) AND ((th.state_id)::text = (s.id)::text))
17. 16.358 3,213.973 ↑ 94.1 8,474 1

Hash Left Join (cost=3,266,551.64..3,288,686.35 rows=797,769 width=207) (actual time=3,138.039..3,213.973 rows=8,474 loops=1)

  • Hash Cond: (th.circuit_id = ci.id)
18. 9.821 3,197.615 ↑ 94.1 8,474 1

Merge Left Join (cost=3,266,359.81..3,278,423.81 rows=797,769 width=186) (actual time=3,130.850..3,197.615 rows=8,474 loops=1)

  • Merge Cond: (th.id = mg.theater_id)
19. 17.455 3,187.794 ↑ 94.8 8,413 1

Merge Left Join (cost=3,266,027.44..3,276,096.68 rows=797,769 width=166) (actual time=3,129.329..3,187.794 rows=8,413 loops=1)

  • Merge Cond: (th.id = ct.theater_id)
20. 42.440 3,170.339 ↑ 94.8 8,413 1

Merge Left Join (cost=3,266,014.68..3,274,088.30 rows=797,769 width=124) (actual time=3,119.784..3,170.339 rows=8,413 loops=1)

  • Merge Cond: (th.id = id.theater_id)
  • -> Sort (cost=6489.63..6524.78 rows=14058 width=15) (actual time=18.778..26.186 rows=16757 loops=1)...skipping...
21. 10.612 3,127.899 ↑ 94.8 8,413 1

Merge Left Join (cost=3,259,525.05..3,265,527.04 rows=797,769 width=117) (actual time=3,101.001..3,127.899 rows=8,413 loops=1)

  • Merge Cond: (th.id = ta.theater_id)
22. 9.214 3,098.844 ↑ 99.4 8,025 1

Merge Left Join (cost=3,255,497.75..3,259,501.87 rows=797,769 width=117) (actual time=3,085.092..3,098.844 rows=8,025 loops=1)

  • Merge Cond: (th.id = dj.theater_id)
23. 10.898 2,998.343 ↑ 144.9 5,505 1

Sort (cost=3,238,296.13..3,240,290.55 rows=797,769 width=95) (actual time=2,995.700..2,998.343 rows=5,505 loops=1)

  • Sort Key: th.id
  • Sort Method: quicksort Memory: 974kB
24. 75.917 2,987.445 ↑ 144.9 5,505 1

Bitmap Heap Scan on theaters th (cost=56,466.54..3,160,092.38 rows=797,769 width=95) (actual time=10.634..2,987.445 rows=5,505 loops=1)

  • Recheck Cond: ((country_id)::text = 'US'::text)
  • Filter: (SubPlan 2)
  • Rows Removed by Filter: 6909
  • Heap Blocks: exact=10592
25. 6.652 6.652 ↑ 32.0 49,791 1

Bitmap Index Scan on ix_theaters_country_49 (cost=0.00..56,267.10 rows=1,595,539 width=0) (actual time=6.652..6.652 rows=49,791 loops=1)

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

SubPlan (for Bitmap Heap Scan)

27. 2,904.876 2,904.876 ↓ 0.0 0 12,414

Index Only Scan using ix_theater_properties_is_reporting on theater_properties (cost=0.57..41.55 rows=43 width=0) (actual time=0.234..0.234 rows=0 loops=12,414)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2017-10-20'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 5319
28. 4.586 91.287 ↓ 1.4 4,013 1

Sort (cost=17,201.62..17,208.54 rows=2,770 width=30) (actual time=89.383..91.287 rows=4,013 loops=1)

  • Sort Key: dj.theater_id
  • Sort Method: quicksort Memory: 411kB
29. 3.902 86.701 ↓ 1.4 4,013 1

Hash Left Join (cost=1.99..17,043.23 rows=2,770 width=30) (actual time=17.399..86.701 rows=4,013 loops=1)

  • Hash Cond: (dj.justification_id = (ju.id)::text)
30. 82.740 82.740 ↓ 1.4 4,013 1

Seq Scan on data_recovery_justifications dj (cost=0.00..17,006.83 rows=2,770 width=14) (actual time=17.326..82.740 rows=4,013 loops=1)

  • Filter: ((booking_date >= '2017-10-20'::date) AND (booking_date <= '2017-10-26'::date))
  • Rows Removed by Filter: 784709
31. 0.031 0.059 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=18) (actual time=0.059..0.059 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
32. 0.028 0.028 ↑ 1.0 44 1

Seq Scan on justifications ju (cost=0.00..1.44 rows=44 width=18) (actual time=0.006..0.028 rows=44 loops=1)

33. 6.124 18.443 ↓ 8.8 5,495 1

Sort (cost=4,027.30..4,028.87 rows=627 width=8) (actual time=15.904..18.443 rows=5,495 loops=1)

  • Sort Key: ta.theater_id
  • Sort Method: quicksort Memory: 457kB
34. 6.210 12.319 ↓ 9.6 6,018 1

Bitmap Heap Scan on theater_aliases ta (cost=2,181.99..3,998.17 rows=627 width=8) (actual time=6.214..12.319 rows=6,018 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=954
35. 0.045 6.109 ↓ 0.0 0 1

BitmapAnd (cost=2,181.99..2,181.99 rows=627 width=0) (actual time=6.109..6.109 rows=0 loops=1)

36. 1.515 1.515 ↑ 1.0 6,535 1

Bitmap Index Scan on ix_theater_aliases_source_id (cost=0.00..412.25 rows=6,571 width=0) (actual time=1.515..1.515 rows=6,535 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[]))
37. 4.549 4.549 ↓ 1.0 35,307 1

Bitmap Index Scan on ix_theater_aliases_source_type (cost=0.00..1,769.18 rows=34,768 width=0) (actual time=4.549..4.549 rows=35,307 loops=1)

  • Index Cond: (source_type = 'EXT'::text)
38. 9.740 3,257.684 ↑ 1,334.0 8,474 1

Merge Right Join (cost=3,461,062.45..3,632,636.85 rows=11,304,387 width=272) (actual time=3,236.052..3,257.684 rows=8,474 loops=1)

  • Merge Cond: (nu.id = mg.user_id)
39. 2.478 3.941 ↑ 6.0 472 1

Sort (cost=212.85..219.94 rows=2,834 width=72) (actual time=3.698..3.941 rows=472 loops=1)

  • Sort Key: nu.id
  • Sort Method: quicksort Memory: 323kB
40. 1.463 1.463 ↑ 1.0 2,834 1

Seq Scan on decrypted_users nu (cost=0.00..50.34 rows=2,834 width=72) (actual time=0.006..1.463 rows=2,834 loops=1)

41. 7.895 3,244.003 ↑ 94.1 8,474 1

Materialize (cost=3,460,849.60..3,464,838.45 rows=797,769 width=216) (actual time=3,232.316..3,244.003 rows=8,474 loops=1)

42. 12.077 3,236.108 ↑ 94.1 8,474 1

Sort (cost=3,460,849.60..3,462,844.02 rows=797,769 width=216) (actual time=3,232.312..3,236.108 rows=8,474 loops=1)

  • Sort Key: mg.user_id
  • Sort Method: quicksort Memory: 2580kB
43. 9.993 3,224.031 ↑ 94.1 8,474 1

Hash Left Join (cost=3,266,554.01..3,300,840.36 rows=797,769 width=216) (actual time=3,138.119..3,224.031 rows=8,474 loops=1)

  • Hash Cond: (((th.country_id)::text = (s.country_id)::text) AND ((th.state_id)::text = (s.id)::text))
44. 9.251 3,213.973 ↑ 94.1 8,474 1

Hash Left Join (cost=3,266,551.64..3,288,686.35 rows=797,769 width=207) (actual time=3,138.039..3,213.973 rows=8,474 loops=1)

  • Hash Cond: (th.circuit_id = ci.id)
45. 8.259 3,197.615 ↑ 94.1 8,474 1

Merge Left Join (cost=3,266,359.81..3,278,423.81 rows=797,769 width=186) (actual time=3,130.850..3,197.615 rows=8,474 loops=1)

  • Merge Cond: (th.id = mg.theater_id)
46. 7.891 3,187.794 ↑ 94.8 8,413 1

Merge Left Join (cost=3,266,027.44..3,276,096.68 rows=797,769 width=166) (actual time=3,129.329..3,187.794 rows=8,413 loops=1)

  • Merge Cond: (th.id = ct.theater_id)
47. 16.254 3,170.339 ↑ 94.8 8,413 1

Merge Left Join (cost=3,266,014.68..3,274,088.30 rows=797,769 width=124) (actual time=3,119.784..3,170.339 rows=8,413 loops=1)

  • Merge Cond: (th.id = id.theater_id)
48. 10.612 3,127.899 ↑ 94.8 8,413 1

Merge Left Join (cost=3,259,525.05..3,265,527.04 rows=797,769 width=117) (actual time=3,101.001..3,127.899 rows=8,413 loops=1)

  • Merge Cond: (th.id = ta.theater_id)
49. 9.214 3,098.844 ↑ 99.4 8,025 1

Merge Left Join (cost=3,255,497.75..3,259,501.87 rows=797,769 width=117) (actual time=3,085.092..3,098.844 rows=8,025 loops=1)

  • Merge Cond: (th.id = dj.theater_id)
50. 10.898 2,998.343 ↑ 144.9 5,505 1

Sort (cost=3,238,296.13..3,240,290.55 rows=797,769 width=95) (actual time=2,995.700..2,998.343 rows=5,505 loops=1)

  • Sort Key: th.id
  • Sort Method: quicksort Memory: 974kB
51. 75.917 2,987.445 ↑ 144.9 5,505 1

Bitmap Heap Scan on theaters th (cost=56,466.54..3,160,092.38 rows=797,769 width=95) (actual time=10.634..2,987.445 rows=5,505 loops=1)

  • Recheck Cond: ((country_id)::text = 'US'::text)
  • Filter: (SubPlan 2)
  • Rows Removed by Filter: 6909
  • Heap Blocks: exact=10592
52. 6.652 6.652 ↑ 32.0 49,791 1

Bitmap Index Scan on ix_theaters_country_49 (cost=0.00..56,267.10 rows=1,595,539 width=0) (actual time=6.652..6.652 rows=49,791 loops=1)

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

SubPlan (for Bitmap Heap Scan)

54. 2,904.876 2,904.876 ↓ 0.0 0 12,414

Index Only Scan using ix_theater_properties_is_reporting on theater_properties (cost=0.57..41.55 rows=43 width=0) (actual time=0.234..0.234 rows=0 loops=12,414)

  • Index Cond: ((theater_id = th.id) AND (as_of_date >= ('2017-10-20'::date - ('180 DAYS'::cstring)::interval)) AND (is_reporting = true))
  • Filter: is_reporting
  • Heap Fetches: 5319
55. 4.586 91.287 ↓ 1.4 4,013 1

Sort (cost=17,201.62..17,208.54 rows=2,770 width=30) (actual time=89.383..91.287 rows=4,013 loops=1)

  • Sort Key: dj.theater_id
  • Sort Method: quicksort Memory: 411kB
56. 3.902 86.701 ↓ 1.4 4,013 1

Hash Left Join (cost=1.99..17,043.23 rows=2,770 width=30) (actual time=17.399..86.701 rows=4,013 loops=1)

  • Hash Cond: (dj.justification_id = (ju.id)::text)
57. 82.740 82.740 ↓ 1.4 4,013 1

Seq Scan on data_recovery_justifications dj (cost=0.00..17,006.83 rows=2,770 width=14) (actual time=17.326..82.740 rows=4,013 loops=1)

  • Filter: ((booking_date >= '2017-10-20'::date) AND (booking_date <= '2017-10-26'::date))
  • Rows Removed by Filter: 784709
58. 0.031 0.059 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=18) (actual time=0.059..0.059 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
59. 0.028 0.028 ↑ 1.0 44 1

Seq Scan on justifications ju (cost=0.00..1.44 rows=44 width=18) (actual time=0.006..0.028 rows=44 loops=1)

60. 6.124 18.443 ↓ 8.8 5,495 1

Sort (cost=4,027.30..4,028.87 rows=627 width=8) (actual time=15.904..18.443 rows=5,495 loops=1)

  • Sort Key: ta.theater_id
  • Sort Method: quicksort Memory: 457kB
61. 6.210 12.319 ↓ 9.6 6,018 1

Bitmap Heap Scan on theater_aliases ta (cost=2,181.99..3,998.17 rows=627 width=8) (actual time=6.214..12.319 rows=6,018 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=954
62. 0.045 6.109 ↓ 0.0 0 1

BitmapAnd (cost=2,181.99..2,181.99 rows=627 width=0) (actual time=6.109..6.109 rows=0 loops=1)

63. 1.515 1.515 ↑ 1.0 6,535 1

Bitmap Index Scan on ix_theater_aliases_source_id (cost=0.00..412.25 rows=6,571 width=0) (actual time=1.515..1.515 rows=6,535 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[]))
64. 4.549 4.549 ↓ 1.0 35,307 1

Bitmap Index Scan on ix_theater_aliases_source_type (cost=0.00..1,769.18 rows=34,768 width=0) (actual time=4.549..4.549 rows=35,307 loops=1)

  • Index Cond: (source_type = 'EXT'::text)
65. 16.830 26.186 ↓ 1.2 16,757 1

Sort (cost=6,489.63..6,524.78 rows=14,058 width=15) (actual time=18.778..26.186 rows=16,757 loops=1)

  • Sort Key: id.theater_id
  • Sort Method: quicksort Memory: 1034kB
66. 8.375 9.356 ↑ 1.0 13,860 1

Bitmap Heap Scan on theater_aliases id (cost=485.37..5,521.10 rows=14,058 width=15) (actual time=1.025..9.356 rows=13,860 loops=1)

  • Recheck Cond: ((source_id)::text = 'BOE'::text)
  • Heap Blocks: exact=379
67. 0.981 0.981 ↑ 1.0 13,860 1

Bitmap Index Scan on ix_theater_aliases_source_id (cost=0.00..481.86 rows=14,058 width=0) (actual time=0.981..0.981 rows=13,860 loops=1)

  • Index Cond: ((source_id)::text = 'BOE'::text)
68. 0.050 9.564 ↑ 4.7 46 1

Sort (cost=12.76..13.30 rows=217 width=50) (actual time=9.542..9.564 rows=46 loops=1)

  • Sort Key: ct.theater_id
  • Sort Method: quicksort Memory: 28kB
69. 9.514 9.514 ↑ 5.6 39 1

CTE Scan on contacted_theaters_cte ct (cost=0.00..4.34 rows=217 width=50) (actual time=9.116..9.514 rows=39 loops=1)

70. 0.094 1.562 ↓ 1.7 105 1

Sort (cost=332.37..332.53 rows=62 width=28) (actual time=1.518..1.562 rows=105 loops=1)

  • Sort Key: mg.theater_id
  • Sort Method: quicksort Memory: 29kB
71. 1.468 1.468 ↑ 1.2 53 1

Seq Scan on data_recovery_mg_ignored_dates mg (cost=0.00..330.52 rows=62 width=28) (actual time=0.864..1.468 rows=53 loops=1)

  • Filter: ((ignored_date >= '2017-10-20'::date) AND (ignored_date <= '2017-10-26'::date))
  • Rows Removed by Filter: 13382
72. 3.719 7.107 ↑ 1.0 6,259 1

Hash (cost=113.59..113.59 rows=6,259 width=29) (actual time=7.107..7.107 rows=6,259 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 445kB
73. 3.388 3.388 ↑ 1.0 6,259 1

Seq Scan on circuits ci (cost=0.00..113.59 rows=6,259 width=29) (actual time=0.008..3.388 rows=6,259 loops=1)

74. 0.033 0.065 ↑ 1.0 50 1

Hash (cost=1.62..1.62 rows=50 width=15) (actual time=0.065..0.065 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
75. 0.032 0.032 ↑ 1.0 50 1

Seq Scan on states s (cost=0.00..1.62 rows=50 width=15) (actual time=0.008..0.032 rows=50 loops=1)

  • Filter: ((country_id)::text = 'US'::text)
76. 0.000 0.000 ↓ 0.0 0 8,474

Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.000..0.000 rows=0 loops=8,474)

  • One-Time Filter: false
Planning time : 6.930 ms
Execution time : 3,316.577 ms