explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AN3N

Settings
# exclusive inclusive rows x rows loops node
1. 10.218 2,392.689 ↑ 1.0 100 1

Limit (cost=2,670,417.65..2,670,423.9 rows=100 width=237) (actual time=2,382.339..2,392.689 rows=100 loops=1)

  • Buffers: shared hit=2790258
2. 0.156 2,382.471 ↑ 105,738.3 100 1

Aggregate (cost=2,670,417.65..3,331,282.03 rows=10,573,830 width=237) (actual time=2,382.337..2,382.471 rows=100 loops=1)

  • Buffers: shared hit=2790258
3. 328.419 2,382.315 ↑ 104,691.4 101 1

Sort (cost=2,670,417.65..2,696,852.23 rows=10,573,830 width=221) (actual time=2,382.307..2,382.315 rows=101 loops=1)

  • Sort Key: th.name DESC, tr_69.uid, tr_69.uid_user, tr_69.id_theater, tr_69.ticket_count, tr_69.id_country, tr_69.ticketing_solution, tr_69.provider, tr_69.referral_detail, tr_69.starts_at, tr_69.updated_at, tr_69.total_amount, tr_69.currency, tr_69.total_fee, tr_69.id_external_transaction, tr_69.state, usr.email
  • Sort Method: quicksort Memory: 52561kB
  • Buffers: shared hit=2790258
4. 80.695 2,053.896 ↑ 60.5 174,746 1

Merge Join (cost=595,211.01..780,549.84 rows=10,573,830 width=221) (actual time=1,943.584..2,053.896 rows=174,746 loops=1)

  • Buffers: shared hit=2790258
5. 90.747 112.998 ↑ 5.4 7,299 1

Sort (cost=9,101.66..9,200.6 rows=39,574 width=29) (actual time=111.788..112.998 rows=7,299 loops=1)

  • Sort Key: ((th.id)::text)
  • Sort Method: quicksort Memory: 4860kB
  • Buffers: shared hit=5684
6. 22.251 22.251 ↑ 1.0 39,574 1

Seq Scan on theater th (cost=0..6,079.74 rows=39,574 width=29) (actual time=0.011..22.251 rows=39,574 loops=1)

  • Buffers: shared hit=5684
7. 219.603 1,860.203 ↓ 1.7 174,746 1

Sort (cost=586,109.35..586,371.19 rows=104,739 width=204) (actual time=1,830.914..1,860.203 rows=174,746 loops=1)

  • Sort Key: sh.id_theater
  • Sort Method: quicksort Memory: 52561kB
  • Buffers: shared hit=2784574
8. 116.865 1,640.600 ↓ 1.7 174,746 1

Hash Join (cost=569,156.88..577,375.98 rows=104,739 width=204) (actual time=1,484.236..1,640.6 rows=174,746 loops=1)

  • Buffers: shared hit=2784574
9. 10.892 49.674 ↑ 1.0 151,057 1

Append (cost=0..7,574.11 rows=151,892 width=32) (actual time=0.02..49.674 rows=151,057 loops=1)

  • Buffers: shared hit=4916
10. 6.769 6.769 ↓ 1.0 26,660 1

Seq Scan on detail_concession dt (cost=0..1,101.75 rows=26,540 width=32) (actual time=0.019..6.769 rows=26,660 loops=1)

  • Filter: (dt.type = ANY ('{CONCESSION,OTHER}'::text[]))
  • Buffers: shared hit=770
11. 32.013 32.013 ↑ 1.0 124,397 1

Seq Scan on detail_other dt_1 (cost=0..5,712.9 rows=125,352 width=32) (actual time=0.009..32.013 rows=124,397 loops=1)

  • Filter: (dt_1.type = ANY ('{CONCESSION,OTHER}'::text[]))
  • Buffers: shared hit=4146
12. 58.098 1,474.061 ↓ 1.6 170,345 1

Hash (cost=567,847.65..567,847.65 rows=104,739 width=188) (actual time=1,474.061..1,474.061 rows=170,345 loops=1)

  • Buffers: shared hit=2779658
13. 77.868 1,415.963 ↓ 1.6 170,345 1

Gather (cost=74,438.54..567,847.65 rows=104,739 width=188) (actual time=515.074..1,415.963 rows=170,345 loops=1)

  • Buffers: shared hit=2779658
14. 216.094 1,338.095 ↓ 1.3 34,069 5

Nested Loop (cost=73,438.54..556,373.75 rows=26,185 width=188) (actual time=461.345..1,338.095 rows=34,069 loops=5)

  • Buffers: shared hit=2779658
15. 172.488 1,121.999 ↓ 3.5 92,556 5

Hash Join (cost=73,438.11..543,704.5 rows=26,186 width=165) (actual time=461.259..1,121.999 rows=92,556 loops=5)

  • Buffers: shared hit=2098202
16. 0.000 489.095 ↑ 1.2 440,468 5

Append (cost=0.42..468,178.7 rows=527,733 width=152) (actual time=0.178..489.095 rows=440,468 loops=5)

  • Buffers: shared hit=643401
17. 0.177 0.177 ↓ 0.0 0 1

Index Scan using transaction_default_id_theater_idx on transaction_default tr_69 (cost=0.42..111.27 rows=1 width=181) (actual time=0.176..0.177 rows=0 loops=1)

  • Index Cond: (tr_69.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=226
18. 144.391 144.391 ↓ 1.8 136,619 1

Index Scan using transaction_p0692_id_theater_idx on transaction_p0692 tr_21 (cost=0.42..30,213.27 rows=77,621 width=152) (actual time=0.136..144.391 rows=136,619 loops=1)

  • Index Cond: (tr_21.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=35887
19. 163.042 163.042 ↓ 1.8 129,518 1

Index Scan using transaction_p4093_id_theater_idx on transaction_p4093 tr_40 (cost=0.42..30,573.58 rows=70,630 width=152) (actual time=0.183..163.042 rows=129,518 loops=1)

  • Index Cond: (tr_40.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=30181
20. 136.995 136.995 ↓ 1.7 133,265 1

Index Scan using transaction_p0905_id_theater_idx on transaction_p0905 tr_29 (cost=0.42..30,318.67 rows=76,835 width=152) (actual time=0.178..136.995 rows=133,265 loops=1)

  • Index Cond: (tr_29.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=34286
21. 114.602 114.602 ↓ 1.8 112,824 1

Index Scan using transaction_w0681_id_theater_idx on transaction_w0681 tr_56 (cost=0.42..25,706.91 rows=61,241 width=154) (actual time=0.196..114.602 rows=112,824 loops=1)

  • Index Cond: (tr_56.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=26410
22. 108.044 108.044 ↓ 1.8 110,971 1

Index Scan using transaction_b9114_id_theater_idx on transaction_b9114 tr_3 (cost=0.42..24,397.74 rows=61,044 width=152) (actual time=0.074..108.044 rows=110,971 loops=1)

  • Index Cond: (tr_3.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=31537
23. 110.495 110.495 ↓ 1.8 107,373 1

Index Scan using transaction_p0704_id_theater_idx on transaction_p0704 tr_23 (cost=0.29..22,308.78 rows=58,232 width=152) (actual time=0.105..110.495 rows=107,373 loops=1)

  • Index Cond: (tr_23.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=31083
24. 101.824 101.824 ↓ 1.8 91,292 1

Index Scan using transaction_p0664_id_theater_idx on transaction_p0664 tr_20 (cost=0.29..20,579.81 rows=51,153 width=152) (actual time=0.11..101.824 rows=91,292 loops=1)

  • Index Cond: (tr_20.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=24483
25. 85.587 85.587 ↓ 1.8 82,539 1

Index Scan using transaction_p0743_id_theater_idx on transaction_p0743 tr_25 (cost=0.29..17,421.36 rows=45,320 width=152) (actual time=0.13..85.587 rows=82,539 loops=1)

  • Index Cond: (tr_25.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=23111
26. 69.381 69.381 ↓ 1.7 73,015 1

Index Scan using transaction_p0134_id_theater_idx on transaction_p0134 tr_6 (cost=0.29..15,376.85 rows=42,789 width=151) (actual time=0.061..69.381 rows=73,015 loops=1)

  • Index Cond: (tr_6.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=20058
27. 90.718 90.718 ↓ 1.7 69,417 1

Index Scan using transaction_p0703_id_theater_idx on transaction_p0703 tr_22 (cost=0.29..15,033.39 rows=40,095 width=152) (actual time=0.134..90.718 rows=69,417 loops=1)

  • Index Cond: (tr_22.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=17245
28. 60.109 60.109 ↓ 1.8 59,864 1

Index Scan using transaction_b0261_id_theater_idx on transaction_b0261 tr_2 (cost=0.29..12,418.47 rows=33,039 width=152) (actual time=0.06..60.109 rows=59,864 loops=1)

  • Index Cond: (tr_2.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=17230
29. 48.873 48.873 ↓ 1.8 42,790 1

Index Scan using transaction_w1312_id_theater_idx on transaction_w1312 tr_58 (cost=0.29..11,295.89 rows=24,197 width=154) (actual time=0.174..48.873 rows=42,790 loops=1)

  • Index Cond: (tr_58.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=9694
30. 51.521 51.521 ↓ 1.8 49,441 1

Index Scan using transaction_p1133_id_theater_idx on transaction_p1133 tr_37 (cost=0.29..10,313.79 rows=27,541 width=152) (actual time=0.163..51.521 rows=49,441 loops=1)

  • Index Cond: (tr_37.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=13269
31. 48.458 48.458 ↓ 1.8 46,706 1

Index Scan using transaction_w3300_id_theater_idx on transaction_w3300 tr_59 (cost=0.29..9,258.54 rows=25,334 width=152) (actual time=0.186..48.458 rows=46,706 loops=1)

  • Index Cond: (tr_59.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=12833
32. 62.610 62.610 ↓ 1.8 44,954 1

Index Scan using transaction_p0993_id_theater_idx on transaction_p0993 tr_32 (cost=0.29..8,650.78 rows=24,606 width=151) (actual time=0.154..62.61 rows=44,954 loops=1)

  • Index Cond: (tr_32.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=14935
33. 50.506 50.506 ↓ 1.8 40,892 1

Index Scan using transaction_p0736_id_theater_idx on transaction_p0736 tr_24 (cost=0.29..8,335.46 rows=22,146 width=152) (actual time=0.155..50.506 rows=40,892 loops=1)

  • Index Cond: (tr_24.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=12021
34. 51.322 51.322 ↓ 1.7 41,313 1

Index Scan using transaction_p0983_id_theater_idx on transaction_p0983 tr_31 (cost=0.29..7,935.93 rows=24,191 width=151) (actual time=0.14..51.322 rows=41,313 loops=1)

  • Index Cond: (tr_31.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=14321
35. 44.265 44.265 ↓ 1.7 43,237 1

Index Scan using transaction_b0059_id_theater_idx on transaction_b0059 tr (cost=0.29..7,600.24 rows=26,082 width=150) (actual time=0.045..44.265 rows=43,237 loops=1)

  • Index Cond: (tr.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=15165
36. 40.149 40.149 ↓ 1.8 37,084 1

Index Scan using transaction_p9556_id_theater_idx on transaction_p9556 tr_54 (cost=0.29..7,093.84 rows=20,864 width=151) (actual time=0.182..40.149 rows=37,084 loops=1)

  • Index Cond: (tr_54.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=11725
37. 39.669 39.669 ↓ 1.8 34,259 1

Index Scan using transaction_p5869_id_theater_idx on transaction_p5869 tr_46 (cost=0.29..7,735.19 rows=19,161 width=152) (actual time=0.277..39.669 rows=34,259 loops=1)

  • Index Cond: (tr_46.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=7387
38. 34.027 34.027 ↓ 1.8 28,685 1

Index Scan using transaction_p6940_id_theater_idx on transaction_p6940 tr_48 (cost=0.29..7,717.82 rows=15,892 width=154) (actual time=0.169..34.027 rows=28,685 loops=1)

  • Index Cond: (tr_48.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=6812
39. 33.606 33.606 ↓ 1.8 28,803 1

Index Scan using transaction_p6310_id_theater_idx on transaction_p6310 tr_47 (cost=0.29..6,740.23 rows=16,201 width=151) (actual time=0.161..33.606 rows=28,803 loops=1)

  • Index Cond: (tr_47.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=9623
40. 40.200 40.200 ↓ 1.7 33,189 1

Index Scan using transaction_b0121_id_theater_idx on transaction_b0121 tr_1 (cost=0.29..6,200.63 rows=19,263 width=150) (actual time=0.039..40.2 rows=33,189 loops=1)

  • Index Cond: (tr_1.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=11668
41. 32.990 32.990 ↓ 1.8 33,993 1

Index Scan using transaction_p3829_id_theater_idx on transaction_p3829 tr_39 (cost=0.29..6,011.67 rows=19,129 width=150) (actual time=0.162..32.99 rows=33,993 loops=1)

  • Index Cond: (tr_39.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=12433
42. 12.504 12.504 ↑ 1.7 10,631 3

Index Scan using transaction_p0925_id_theater_idx on transaction_p0925 tr_30 (cost=0.29..5,574.5 rows=18,026 width=150) (actual time=0.081..12.504 rows=10,631 loops=3)

  • Index Cond: (tr_30.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=11968
43. 33.175 33.175 ↓ 1.8 28,198 1

Index Scan using transaction_p0629_id_theater_idx on transaction_p0629 tr_19 (cost=0.29..5,508.26 rows=16,106 width=151) (actual time=0.097..33.175 rows=28,198 loops=1)

  • Index Cond: (tr_19.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=8598
44. 31.891 31.891 ↓ 1.9 30,013 1

Index Scan using transaction_w7519_id_theater_idx on transaction_w7519 tr_64 (cost=0.29..5,307.74 rows=16,094 width=153) (actual time=0.186..31.891 rows=30,013 loops=1)

  • Index Cond: (tr_64.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=6510
45. 16.263 16.263 ↓ 1.7 22,072 1

Index Scan using transaction_w6300_id_theater_idx on transaction_w6300 tr_61 (cost=0.29..5,284.74 rows=12,724 width=153) (actual time=0.176..16.263 rows=22,072 loops=1)

  • Index Cond: (tr_61.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=4086
46. 5.727 5.727 ↑ 1.7 6,865 3

Index Scan using transaction_w8330_id_theater_idx on transaction_w8330 tr_67 (cost=0.29..5,154.48 rows=11,576 width=153) (actual time=0.079..5.727 rows=6,865 loops=3)

  • Index Cond: (tr_67.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=4597
47. 9.497 9.497 ↑ 1.1 12,648 2

Index Scan using transaction_p5756_id_theater_idx on transaction_p5756 tr_44 (cost=0.29..5,111.38 rows=13,958 width=152) (actual time=0.076..9.497 rows=12,648 loops=2)

  • Index Cond: (tr_44.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=6881
48. 19.974 19.974 ↓ 1.7 26,812 1

Index Scan using transaction_p1093_id_theater_idx on transaction_p1093 tr_36 (cost=0.29..4,977.26 rows=15,656 width=150) (actual time=0.112..19.974 rows=26,812 loops=1)

  • Index Cond: (tr_36.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=9333
49. 17.277 17.277 ↓ 1.7 23,910 1

Index Scan using transaction_p8418_id_theater_idx on transaction_p8418 tr_51 (cost=0.29..4,818.62 rows=13,982 width=151) (actual time=0.154..17.277 rows=23,910 loops=1)

  • Index Cond: (tr_51.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=7253
50. 15.815 15.815 ↓ 1.8 21,224 1

Index Scan using transaction_p0761_id_theater_idx on transaction_p0761 tr_26 (cost=0.29..4,053.17 rows=11,611 width=151) (actual time=0.1..15.815 rows=21,224 loops=1)

  • Index Cond: (tr_26.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=7194
51. 16.034 16.034 ↓ 1.6 21,685 1

Index Scan using transaction_w6500_id_theater_idx on transaction_w6500 tr_63 (cost=0.29..3,980.66 rows=13,182 width=149) (actual time=0.15..16.034 rows=21,685 loops=1)

  • Index Cond: (tr_63.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=8465
52. 16.029 16.029 ↓ 1.6 20,942 1

Index Scan using transaction_p5823_id_theater_idx on transaction_p5823 tr_45 (cost=0.29..3,807.73 rows=12,749 width=150) (actual time=0.138..16.029 rows=20,942 loops=1)

  • Index Cond: (tr_45.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=8160
53. 15.325 15.325 ↓ 1.7 20,150 1

Index Scan using transaction_p0619_id_theater_idx on transaction_p0619 tr_18 (cost=0.29..3,798.8 rows=11,614 width=151) (actual time=0.074..15.325 rows=20,150 loops=1)

  • Index Cond: (tr_18.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=5926
54. 15.716 15.716 ↓ 1.8 20,149 1

Index Scan using transaction_p0252_id_theater_idx on transaction_p0252 tr_15 (cost=0.29..3,609.72 rows=11,458 width=150) (actual time=0.065..15.716 rows=20,149 loops=1)

  • Index Cond: (tr_15.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=7338
55. 15.164 15.164 ↓ 1.7 18,986 1

Index Scan using transaction_p1038_id_theater_idx on transaction_p1038 tr_35 (cost=0.29..3,405.71 rows=11,323 width=150) (actual time=0.109..15.164 rows=18,986 loops=1)

  • Index Cond: (tr_35.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=7537
56. 15.090 15.090 ↓ 1.7 17,620 1

Index Scan using transaction_p0995_id_theater_idx on transaction_p0995 tr_33 (cost=0.29..3,210.19 rows=10,635 width=149) (actual time=0.118..15.09 rows=17,620 loops=1)

  • Index Cond: (tr_33.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=7098
57. 14.571 14.571 ↓ 1.7 17,174 1

Index Scan using transaction_p5044_id_theater_idx on transaction_p5044 tr_42 (cost=0.29..3,076.42 rows=10,244 width=150) (actual time=0.13..14.571 rows=17,174 loops=1)

  • Index Cond: (tr_42.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=7103
58. 14.287 14.287 ↓ 1.8 16,337 1

Index Scan using transaction_p8517_id_theater_idx on transaction_p8517 tr_52 (cost=0.29..3,368.01 rows=9,309 width=151) (actual time=0.141..14.287 rows=16,337 loops=1)

  • Index Cond: (tr_52.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=5146
59. 13.002 13.002 ↓ 1.8 16,015 1

Index Scan using transaction_p0331_id_theater_idx on transaction_p0331 tr_16 (cost=0.29..2,844.68 rows=9,070 width=151) (actual time=0.058..13.002 rows=16,015 loops=1)

  • Index Cond: (tr_16.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=5858
60. 8.817 8.817 ↓ 1.9 10,600 1

Index Scan using transaction_p9520_id_theater_idx on transaction_p9520 tr_53 (cost=0.29..2,671.27 rows=5,679 width=153) (actual time=0.141..8.817 rows=10,600 loops=1)

  • Index Cond: (tr_53.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2650
61. 8.564 8.564 ↓ 1.9 10,901 1

Index Scan using transaction_p3000_id_theater_idx on transaction_p3000 tr_38 (cost=0.29..2,668.87 rows=5,889 width=153) (actual time=0.111..8.564 rows=10,901 loops=1)

  • Index Cond: (tr_38.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2696
62. 12.595 12.595 ↓ 1.7 14,600 1

Index Scan using transaction_p0485_id_theater_idx on transaction_p0485 tr_17 (cost=0.29..2,640.26 rows=8,402 width=150) (actual time=0.071..12.595 rows=14,600 loops=1)

  • Index Cond: (tr_17.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=6134
63. 11.901 11.901 ↓ 1.7 13,963 1

Index Scan using transaction_p4956_id_theater_idx on transaction_p4956 tr_41 (cost=0.29..2,637.23 rows=8,225 width=149) (actual time=0.118..11.901 rows=13,963 loops=1)

  • Index Cond: (tr_41.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=6057
64. 6.671 6.671 ↓ 1.7 8,645 1

Index Scan using transaction_w8010_id_theater_idx on transaction_w8010 tr_65 (cost=0.29..2,258.62 rows=5,018 width=152) (actual time=0.151..6.671 rows=8,645 loops=1)

  • Index Cond: (tr_65.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2276
65. 8.019 8.019 ↓ 1.8 10,013 1

Index Scan using transaction_w8624_id_theater_idx on transaction_w8624 tr_68 (cost=0.29..2,255.88 rows=5,588 width=152) (actual time=0.159..8.019 rows=10,013 loops=1)

  • Index Cond: (tr_68.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2299
66. 8.459 8.459 ↓ 1.8 10,073 1

Index Scan using transaction_p0194_id_theater_idx on transaction_p0194 tr_10 (cost=0.29..1,978.7 rows=5,616 width=151) (actual time=0.051..8.459 rows=10,073 loops=1)

  • Index Cond: (tr_10.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=3348
67. 7.686 7.686 ↓ 1.8 9,189 1

Index Scan using transaction_p0096_id_theater_idx on transaction_p0096 tr_4 (cost=0.29..1,882.03 rows=5,107 width=152) (actual time=0.028..7.686 rows=9,189 loops=1)

  • Index Cond: (tr_4.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2775
68. 8.670 8.670 ↓ 1.8 9,751 1

Index Scan using transaction_p0151_id_theater_idx on transaction_p0151 tr_8 (cost=0.29..1,866.1 rows=5,390 width=151) (actual time=0.041..8.67 rows=9,751 loops=1)

  • Index Cond: (tr_8.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=3503
69. 7.847 7.847 ↓ 1.7 9,432 1

Index Scan using transaction_p0867_id_theater_idx on transaction_p0867 tr_28 (cost=0.29..1,836.61 rows=5,581 width=148) (actual time=0.105..7.847 rows=9,432 loops=1)

  • Index Cond: (tr_28.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=4001
70. 7.484 7.484 ↓ 1.7 9,043 1

Index Scan using transaction_p0798_id_theater_idx on transaction_p0798 tr_27 (cost=0.29..1,769.84 rows=5,374 width=148) (actual time=0.099..7.484 rows=9,043 loops=1)

  • Index Cond: (tr_27.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=3819
71. 6.540 6.540 ↓ 1.7 7,882 1

Index Scan using transaction_p5505_id_theater_idx on transaction_p5505 tr_43 (cost=0.28..1,573.07 rows=4,653 width=147) (actual time=0.116..6.54 rows=7,882 loops=1)

  • Index Cond: (tr_43.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=3216
72. 5.000 5.000 ↓ 1.7 6,150 1

Index Scan using transaction_w6423_id_theater_idx on transaction_w6423 tr_62 (cost=0.28..1,482.93 rows=3,619 width=143) (actual time=0.139..5 rows=6,150 loops=1)

  • Index Cond: (tr_62.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2384
73. 6.491 6.491 ↓ 1.7 7,372 1

Index Scan using transaction_w1200_id_theater_idx on transaction_w1200 tr_57 (cost=0.28..1,379.41 rows=4,365 width=149) (actual time=0.144..6.491 rows=7,372 loops=1)

  • Index Cond: (tr_57.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=3285
74. 5.737 5.737 ↓ 1.7 6,781 1

Index Scan using transaction_w8101_id_theater_idx on transaction_w8101 tr_66 (cost=0.28..1,272.71 rows=4,027 width=149) (actual time=0.161..5.737 rows=6,781 loops=1)

  • Index Cond: (tr_66.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=3023
75. 5.060 5.060 ↓ 1.7 6,090 1

Index Scan using transaction_p7963_id_theater_idx on transaction_p7963 tr_49 (cost=0.28..1,208.83 rows=3,625 width=147) (actual time=0.131..5.06 rows=6,090 loops=1)

  • Index Cond: (tr_49.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2626
76. 4.511 4.511 ↓ 1.8 5,557 1

Index Scan using transaction_p0160_id_theater_idx on transaction_p0160 tr_9 (cost=0.28..1,119.71 rows=3,069 width=152) (actual time=0.041..4.511 rows=5,557 loops=1)

  • Index Cond: (tr_9.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=1729
77. 4.955 4.955 ↓ 1.7 5,520 1

Index Scan using transaction_w4100_id_theater_idx on transaction_w4100 tr_60 (cost=0.28..1,053.3 rows=3,278 width=148) (actual time=0.141..4.955 rows=5,520 loops=1)

  • Index Cond: (tr_60.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2374
78. 4.522 4.522 ↓ 1.7 5,196 1

Index Scan using transaction_w0310_id_theater_idx on transaction_w0310 tr_55 (cost=0.28..1,040.98 rows=3,072 width=146) (actual time=0.132..4.522 rows=5,196 loops=1)

  • Index Cond: (tr_55.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2235
79. 4.889 4.889 ↓ 1.7 5,572 1

Index Scan using transaction_p0217_id_theater_idx on transaction_p0217 tr_13 (cost=0.28..1,026.69 rows=3,313 width=150) (actual time=0.048..4.889 rows=5,572 loops=1)

  • Index Cond: (tr_13.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2407
80. 3.724 3.724 ↓ 1.8 4,568 1

Index Scan using transaction_p0198_id_theater_idx on transaction_p0198 tr_11 (cost=0.28..879.59 rows=2,601 width=151) (actual time=0.047..3.724 rows=4,568 loops=1)

  • Index Cond: (tr_11.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=1571
81. 3.886 3.886 ↓ 1.7 4,469 1

Index Scan using transaction_p0199_id_theater_idx on transaction_p0199 tr_12 (cost=0.28..859.47 rows=2,681 width=149) (actual time=0.057..3.886 rows=4,469 loops=1)

  • Index Cond: (tr_12.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=2049
82. 2.653 2.653 ↓ 1.7 3,281 1

Index Scan using transaction_p1016_id_theater_idx on transaction_p1016 tr_34 (cost=0.28..667.03 rows=1,943 width=146) (actual time=0.098..2.653 rows=3,281 loops=1)

  • Index Cond: (tr_34.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=1322
83. 2.180 2.180 ↓ 1.8 2,510 1

Index Scan using transaction_p0146_id_theater_idx on transaction_p0146 tr_7 (cost=0.28..472.62 rows=1,414 width=151) (actual time=0.037..2.18 rows=2,510 loops=1)

  • Index Cond: (tr_7.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=1128
84. 1.848 1.848 ↓ 1.9 2,023 1

Index Scan using transaction_p0133_id_theater_idx on transaction_p0133 tr_5 (cost=0.28..395.41 rows=1,063 width=150) (actual time=0.038..1.848 rows=2,023 loops=1)

  • Index Cond: (tr_5.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=918
85. 1.567 1.567 ↓ 1.7 1,622 1

Index Scan using transaction_p0221_id_theater_idx on transaction_p0221 tr_14 (cost=0.28..304.06 rows=956 width=149) (actual time=0.055..1.567 rows=1,622 loops=1)

  • Index Cond: (tr_14.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=830
86. 1.046 1.046 ↓ 1.7 422 1

Seq Scan on transaction_p8100 tr_50 (cost=0..96.65 rows=246 width=144) (actual time=0.016..1.046 rows=422 loops=1)

  • Filter: (tr_50.id_theater = ANY ('{P0703,P5044,W8010,P0993,P0096,W8330,P3829,P0925,P0664,P1133,P5756,P0160,P3000,B0261,P7963,P6940,P9556,P0146,W0681,P0761,W6423,P1093,P0867,P0151,P0948,P0133,P0134,P0217,P1016,P5505,B0059,B9114,P0692,P8418,P1038,P0331,P0194,P8517,P0619,W3300,P6310,B0121,P0983,P0995,P0221,P4093,P9520,W0310,P0798,P0508,W1200,P0704,P5823,W6300,P0629,P0252,P0198,P0485,W6500,W8101,P5869,P0905,W4100,W1312,W7519,P0743,P8100,P4956,P0736,P0395,W8624,P0199}'::text[]))
  • Buffers: shared hit=72
87. 77.276 460.416 ↓ 1.4 175,631 5

Hash (cost=71,889.94..71,889.94 rows=123,820 width=30) (actual time=460.416..460.416 rows=175,631 loops=5)

  • Buffers: shared hit=1454673
88. 348.663 383.140 ↓ 1.4 175,631 5

Nested Loop (cost=0.86..71,889.94 rows=123,820 width=30) (actual time=0.15..383.14 rows=175,631 loops=5)

  • Buffers: shared hit=1454673
89. 34.468 34.468 ↑ 1.2 34,182 5

Index Scan using idx_ticketing_v2_showtime2_starts_at on showtime2 sh (cost=0.43..5,292.25 rows=41,653 width=30) (actual time=0.062..34.468 rows=34,182 loops=5)

  • Index Cond: ((sh.starts_at >= '2019-07-01 00:00:00'::timestamp without time zone) AND (sh.starts_at < '2019-08-13 23:59:59'::timestamp without time zone))
  • Buffers: shared hit=145537
90. 0.009 0.009 ↑ 1.8 5 170,912

Index Scan using idx_ticketing_v2_transaction_has_showtime_uid_showtime on transaction_has_showtime tas (cost=0.43..1.51 rows=9 width=32) (actual time=0.006..0.009 rows=5 loops=170,912)

  • Index Cond: (tas.uid_showtime = sh.uid)
  • Buffers: shared hit=1309136
91. 0.002 0.002 ↓ 0.0 0 462,781

Index Scan using user_pkey on user usr (cost=0.43..0.48 rows=1 width=39) (actual time=0.002..0.002 rows=0 loops=462,781)

  • Index Cond: (usr.uid = tr_69.uid_user)
  • Buffers: shared hit=681456