explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yHQh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 625,995.546 ↑ 1.0 1 1

Finalize Aggregate (cost=805,386,197.52..805,386,197.53 rows=1 width=8) (actual time=625,995.545..625,995.546 rows=1 loops=1)

2. 1,072.233 626,946.671 ↓ 1.1 9 1

Gather (cost=805,386,196.69..805,386,197.50 rows=8 width=8) (actual time=625,926.736..626,946.671 rows=9 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
3. 1,325.808 625,874.438 ↑ 1.0 1 9 / 9

Partial Aggregate (cost=805,385,196.69..805,385,196.70 rows=1 width=8) (actual time=625,874.438..625,874.438 rows=1 loops=9)

4. 22,461.775 624,548.630 ↑ 1.1 22,795,182 9 / 9

Parallel Hash Left Join (cost=483,827.81..805,321,179.88 rows=25,606,724 width=0) (actual time=614,014.625..624,548.630 rows=22,795,182 loops=9)

  • Hash Cond: (a_110.tx_codigo_mc = b.codigo_mc)
5. 2,492.248 598,745.734 ↑ 1.1 22,795,182 9 / 9

Parallel Append (cost=0.44..804,386,861.45 rows=25,606,684 width=8) (actual time=38,343.402..598,745.734 rows=22,795,182 loops=9)

6. 18,726.577 18,726.577 ↓ 4.0 9,944,337 1 / 9

Parallel Index Scan using mc_transacciones_202003_tx_codigo_mc_idx on mc_transacciones_202003 a_110 (cost=0.56..53,587,070.26 rows=2,472,388 width=8) (actual time=2,047.131..168,539.189 rows=9,944,337 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 8,399,064
7. 21,283.411 21,283.411 ↓ 4.0 9,732,456 1 / 9

Parallel Index Scan using mc_transacciones_202005_tx_codigo_mc_idx on mc_transacciones_202005 a_112 (cost=0.56..34,758,689.31 rows=2,438,796 width=8) (actual time=61,111.098..191,550.698 rows=9,732,456 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 10,434,411
8. 21,449.128 21,449.128 ↓ 4.0 12,839,728 1 / 9

Parallel Index Scan using mc_transacciones_202009_tx_codigo_mc_idx on mc_transacciones_202009 a_116 (cost=0.56..30,861,261.23 rows=3,214,202 width=8) (actual time=79,272.138..193,042.151 rows=12,839,728 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 6,585,978
9. 20,806.670 20,806.670 ↓ 4.0 10,542,725 1 / 9

Parallel Index Scan using mc_transacciones_202007_tx_codigo_mc_idx on mc_transacciones_202007 a_114 (cost=0.56..30,611,807.13 rows=2,627,710 width=8) (actual time=79,114.283..187,260.033 rows=10,542,725 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 7,170,789
10. 22,255.492 22,255.492 ↓ 4.0 12,279,209 1 / 9

Parallel Index Scan using mc_transacciones_202008_tx_codigo_mc_idx on mc_transacciones_202008 a_115 (cost=0.56..30,242,927.02 rows=3,073,508 width=8) (actual time=80,582.741..200,299.430 rows=12,279,209 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 6,850,196
11. 41,467.288 41,467.288 ↓ 4.0 9,210,216 1 / 9

Parallel Index Scan using mc_transacciones_201908_tx_codigo_mc_idx on mc_transacciones_201908 a_103 (cost=0.44..47,726,720.06 rows=2,285,740 width=8) (actual time=1,058.026..373,205.590 rows=9,210,216 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 15,317,319
12. 42,229.323 42,229.323 ↓ 4.0 9,333,287 1 / 9

Parallel Index Scan using mc_transacciones_201910_tx_codigo_mc_idx on mc_transacciones_201910 a_105 (cost=0.44..46,911,616.59 rows=2,333,792 width=8) (actual time=2,262.826..380,063.905 rows=9,333,287 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 15,516,787
13. 46,261.522 46,261.522 ↓ 4.0 8,076,802 1 / 9

Parallel Index Scan using mc_transacciones_201904_tx_codigo_mc_idx on mc_transacciones_201904 a_99 (cost=0.44..46,746,468.58 rows=2,022,260 width=8) (actual time=454.822..416,353.697 rows=8,076,802 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 13,716,145
14. 34,786.737 34,786.737 ↓ 4.0 8,958,733 1 / 9

Parallel Index Scan using mc_transacciones_201909_tx_codigo_mc_idx on mc_transacciones_201909 a_104 (cost=0.44..46,023,971.14 rows=2,237,839 width=8) (actual time=3,302.923..313,080.635 rows=8,958,733 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 15,048,048
15. 32,850.839 32,850.839 ↓ 4.0 8,864,475 1 / 9

Parallel Index Scan using mc_transacciones_201905_tx_codigo_mc_idx on mc_transacciones_201905 a_100 (cost=0.44..45,408,448.61 rows=2,209,364 width=8) (actual time=1.435..295,657.549 rows=8,864,475 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 11,935,905
16. 31,909.668 31,909.668 ↓ 4.0 8,914,438 1 / 9

Parallel Index Scan using mc_transacciones_201907_tx_codigo_mc_idx on mc_transacciones_201907 a_102 (cost=0.44..45,086,622.33 rows=2,229,550 width=8) (actual time=472.035..287,187.011 rows=8,914,438 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 14,029,599
17. 36,013.307 36,013.307 ↓ 2.0 5,125,597 2 / 9

Parallel Index Scan using mc_transacciones_201912_tx_codigo_mc_idx on mc_transacciones_201912 a_107 (cost=0.44..44,911,152.99 rows=2,542,360 width=8) (actual time=889.137..162,059.883 rows=5,125,597 loops=2)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 7,631,640
18. 31,058.630 31,058.630 ↓ 4.0 8,397,751 1 / 9

Parallel Index Scan using mc_transacciones_201906_tx_codigo_mc_idx on mc_transacciones_201906 a_101 (cost=0.44..43,654,657.93 rows=2,093,873 width=8) (actual time=402.252..279,527.666 rows=8,397,751 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 12,355,621
19. 36,695.409 36,695.409 ↓ 1.0 2,330,212 4 / 9

Parallel Index Scan using mc_transacciones_201911_tx_codigo_mc_idx on mc_transacciones_201911 a_106 (cost=0.44..42,515,714.41 rows=2,317,097 width=8) (actual time=485.796..82,564.670 rows=2,330,212 loops=4)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 3,657,651
20. 30,712.237 30,712.237 ↓ 2.0 4,177,804 2 / 9

Parallel Index Scan using mc_transacciones_201903_tx_codigo_mc_idx on mc_transacciones_201903 a_98 (cost=0.44..39,555,188.19 rows=2,081,872 width=8) (actual time=258.904..138,205.065 rows=4,177,804 loops=2)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 5,655,790
21. 27,887.184 27,887.184 ↑ 2.2 1,133,501 9 / 9

Parallel Index Scan using mc_transacciones_202001_tx_codigo_mc_idx on mc_transacciones_202001 a_108 (cost=0.44..30,261,131.77 rows=2,547,682 width=8) (actual time=212.496..27,887.184 rows=1,133,501 loops=9)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 766,572
22. 14,151.900 14,151.900 ↓ 1.3 3,410,927 3 / 9

Parallel Index Scan using mc_transacciones_202006_tx_codigo_mc_idx on mc_transacciones_202006 a_113 (cost=0.44..29,515,439.99 rows=2,557,033 width=8) (actual time=16,846.860..42,455.700 rows=3,410,927 loops=3)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 2,294,589
23. 10,182.928 10,182.928 ↓ 4.0 8,126,661 1 / 9

Parallel Index Scan using mc_transacciones_202004_tx_codigo_mc_idx on mc_transacciones_202004 a_111 (cost=0.43..26,762,432.09 rows=2,034,027 width=8) (actual time=12,285.804..91,646.356 rows=8,126,661 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 6,319,159
24. 22,822.356 22,822.356 ↓ 1.3 3,376,011 3 / 9

Parallel Index Scan using mc_transacciones_202002_tx_codigo_mc_idx on mc_transacciones_202002 a_109 (cost=0.43..26,586,636.53 rows=2,530,113 width=8) (actual time=529.504..68,467.069 rows=3,376,011 loops=3)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 1,583,389
25. 20,577.253 20,577.253 ↓ 4.0 7,933,633 1 / 9

Parallel Index Scan using mc_transacciones_201901_tx_codigo_mc_idx on mc_transacciones_201901 a_96 (cost=0.43..24,454,719.32 rows=1,982,924 width=8) (actual time=811.114..185,195.276 rows=7,933,633 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 2,849,030
26. 22,235.961 22,235.961 ↓ 4.0 7,209,753 1 / 9

Parallel Index Scan using mc_transacciones_201902_tx_codigo_mc_idx on mc_transacciones_201902 a_97 (cost=0.43..21,763,973.35 rows=1,800,962 width=8) (actual time=1,392.561..200,123.649 rows=7,209,753 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 2,099,075
27. 9,889.632 9,889.632 ↓ 4.0 6,302,464 1 / 9

Parallel Index Scan using mc_transacciones_202010_tx_codigo_mc_idx on mc_transacciones_202010 a_117 (cost=0.43..16,311,163.68 rows=1,580,273 width=8) (actual time=39,187.027..89,006.685 rows=6,302,464 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
  • Rows Removed by Filter: 4,232,937
28. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201101_tx_codigo_mc_idx on mc_transacciones_201101 a (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
29. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201102_tx_codigo_mc_idx on mc_transacciones_201102 a_1 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
30. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201103_tx_codigo_mc_idx on mc_transacciones_201103 a_2 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
31. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201104_tx_codigo_mc_idx on mc_transacciones_201104 a_3 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
32. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201105_tx_codigo_mc_idx on mc_transacciones_201105 a_4 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
33. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201106_tx_codigo_mc_idx on mc_transacciones_201106 a_5 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
34. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201107_tx_codigo_mc_idx on mc_transacciones_201107 a_6 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
35. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201108_tx_codigo_mc_idx on mc_transacciones_201108 a_7 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
36. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201109_tx_codigo_mc_idx on mc_transacciones_201109 a_8 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
37. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201110_tx_codigo_mc_idx on mc_transacciones_201110 a_9 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
38. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201111_tx_codigo_mc_idx on mc_transacciones_201111 a_10 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
39. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201112_tx_codigo_mc_idx on mc_transacciones_201112 a_11 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
40. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201201_tx_codigo_mc_idx on mc_transacciones_201201 a_12 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
41. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201202_tx_codigo_mc_idx on mc_transacciones_201202 a_13 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
42. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201203_tx_codigo_mc_idx on mc_transacciones_201203 a_14 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
43. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201204_tx_codigo_mc_idx on mc_transacciones_201204 a_15 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
44. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201205_tx_codigo_mc_idx on mc_transacciones_201205 a_16 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
45. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201206_tx_codigo_mc_idx on mc_transacciones_201206 a_17 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
46. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201207_tx_codigo_mc_idx on mc_transacciones_201207 a_18 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
47. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201208_tx_codigo_mc_idx on mc_transacciones_201208 a_19 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
48. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201209_tx_codigo_mc_idx on mc_transacciones_201209 a_20 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
49. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201210_tx_codigo_mc_idx on mc_transacciones_201210 a_21 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
50. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201211_tx_codigo_mc_idx on mc_transacciones_201211 a_22 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
51. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201212_tx_codigo_mc_idx on mc_transacciones_201212 a_23 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
52. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201301_tx_codigo_mc_idx on mc_transacciones_201301 a_24 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
53. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201302_tx_codigo_mc_idx on mc_transacciones_201302 a_25 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
54. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201303_tx_codigo_mc_idx on mc_transacciones_201303 a_26 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
55. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201304_tx_codigo_mc_idx on mc_transacciones_201304 a_27 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
56. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201305_tx_codigo_mc_idx on mc_transacciones_201305 a_28 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
57. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201306_tx_codigo_mc_idx on mc_transacciones_201306 a_29 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
58. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201307_tx_codigo_mc_idx on mc_transacciones_201307 a_30 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
59. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201308_tx_codigo_mc_idx on mc_transacciones_201308 a_31 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
60. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201309_tx_codigo_mc_idx on mc_transacciones_201309 a_32 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
61. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201310_tx_codigo_mc_idx on mc_transacciones_201310 a_33 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
62. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201311_tx_codigo_mc_idx on mc_transacciones_201311 a_34 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
63. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201312_tx_codigo_mc_idx on mc_transacciones_201312 a_35 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
64. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201401_tx_codigo_mc_idx on mc_transacciones_201401 a_36 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
65. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201402_tx_codigo_mc_idx on mc_transacciones_201402 a_37 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
66. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201403_tx_codigo_mc_idx on mc_transacciones_201403 a_38 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
67. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201404_tx_codigo_mc_idx on mc_transacciones_201404 a_39 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
68. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201405_tx_codigo_mc_idx on mc_transacciones_201405 a_40 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
69. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201406_tx_codigo_mc_idx on mc_transacciones_201406 a_41 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
70. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201407_tx_codigo_mc_idx on mc_transacciones_201407 a_42 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
71. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201408_tx_codigo_mc_idx on mc_transacciones_201408 a_43 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
72. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201409_tx_codigo_mc_idx on mc_transacciones_201409 a_44 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
73. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201410_tx_codigo_mc_idx on mc_transacciones_201410 a_45 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
74. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201411_tx_codigo_mc_idx on mc_transacciones_201411 a_46 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
75. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201412_tx_codigo_mc_idx on mc_transacciones_201412 a_47 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
76. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201501_tx_codigo_mc_idx on mc_transacciones_201501 a_48 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
77. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201502_tx_codigo_mc_idx on mc_transacciones_201502 a_49 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
78. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201503_tx_codigo_mc_idx on mc_transacciones_201503 a_50 (cost=0.14..9.23 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
79. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201504_tx_codigo_mc_idx on mc_transacciones_201504 a_51 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
80. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201505_tx_codigo_mc_idx on mc_transacciones_201505 a_52 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
81. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201506_tx_codigo_mc_idx on mc_transacciones_201506 a_53 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
82. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201507_tx_codigo_mc_idx on mc_transacciones_201507 a_54 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
83. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201508_tx_codigo_mc_idx on mc_transacciones_201508 a_55 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
84. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201509_tx_codigo_mc_idx on mc_transacciones_201509 a_56 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
85. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201510_tx_codigo_mc_idx on mc_transacciones_201510 a_57 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
86. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201511_tx_codigo_mc_idx on mc_transacciones_201511 a_58 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
87. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201512_tx_codigo_mc_idx on mc_transacciones_201512 a_59 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
88. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201601_tx_codigo_mc_idx on mc_transacciones_201601 a_60 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
89. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201602_tx_codigo_mc_idx on mc_transacciones_201602 a_61 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
90. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201603_tx_codigo_mc_idx on mc_transacciones_201603 a_62 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
91. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201604_tx_codigo_mc_idx on mc_transacciones_201604 a_63 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
92. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201605_tx_codigo_mc_idx on mc_transacciones_201605 a_64 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
93. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201606_tx_codigo_mc_idx on mc_transacciones_201606 a_65 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
94. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201607_tx_codigo_mc_idx on mc_transacciones_201607 a_66 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
95. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201608_tx_codigo_mc_idx on mc_transacciones_201608 a_67 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
96. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201609_tx_codigo_mc_idx on mc_transacciones_201609 a_68 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
97. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201610_tx_codigo_mc_idx on mc_transacciones_201610 a_69 (cost=0.14..9.23 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
98. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201611_tx_codigo_mc_idx on mc_transacciones_201611 a_70 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
99. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201612_tx_codigo_mc_idx on mc_transacciones_201612 a_71 (cost=0.14..9.23 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
100. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201701_tx_codigo_mc_idx on mc_transacciones_201701 a_72 (cost=0.14..9.23 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
101. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201702_tx_codigo_mc_idx on mc_transacciones_201702 a_73 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
102. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201703_tx_codigo_mc_idx on mc_transacciones_201703 a_74 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
103. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201704_tx_codigo_mc_idx on mc_transacciones_201704 a_75 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
104. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201705_tx_codigo_mc_idx on mc_transacciones_201705 a_76 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
105. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201706_tx_codigo_mc_idx on mc_transacciones_201706 a_77 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
106. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201707_tx_codigo_mc_idx on mc_transacciones_201707 a_78 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
107. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201708_tx_codigo_mc_idx on mc_transacciones_201708 a_79 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
108. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201709_tx_codigo_mc_idx on mc_transacciones_201709 a_80 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
109. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201710_tx_codigo_mc_idx on mc_transacciones_201710 a_81 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
110. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201711_tx_codigo_mc_idx on mc_transacciones_201711 a_82 (cost=0.14..9.23 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
111. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201712_tx_codigo_mc_idx on mc_transacciones_201712 a_83 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
112. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201801_tx_codigo_mc_idx on mc_transacciones_201801 a_84 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
113. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201802_tx_codigo_mc_idx on mc_transacciones_201802 a_85 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
114. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201803_tx_codigo_mc_idx on mc_transacciones_201803 a_86 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
115. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201804_tx_codigo_mc_idx on mc_transacciones_201804 a_87 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
116. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201805_tx_codigo_mc_idx on mc_transacciones_201805 a_88 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
117. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201806_tx_codigo_mc_idx on mc_transacciones_201806 a_89 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
118. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201807_tx_codigo_mc_idx on mc_transacciones_201807 a_90 (cost=0.14..9.23 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
119. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201808_tx_codigo_mc_idx on mc_transacciones_201808 a_91 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
120. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201809_tx_codigo_mc_idx on mc_transacciones_201809 a_92 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
121. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201810_tx_codigo_mc_idx on mc_transacciones_201810 a_93 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
122. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201811_tx_codigo_mc_idx on mc_transacciones_201811 a_94 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
123. 0.001 0.001 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_201812_tx_codigo_mc_idx on mc_transacciones_201812 a_95 (cost=0.14..9.23 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
124. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202011_tx_codigo_mc_idx on mc_transacciones_202011 a_118 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
125. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202012_tx_codigo_mc_idx on mc_transacciones_202012 a_119 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
126. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202101_tx_codigo_mc_idx on mc_transacciones_202101 a_120 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
127. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202102_tx_codigo_mc_idx on mc_transacciones_202102 a_121 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
128. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202103_tx_codigo_mc_idx on mc_transacciones_202103 a_122 (cost=0.14..9.23 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
129. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202104_tx_codigo_mc_idx on mc_transacciones_202104 a_123 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
130. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202105_tx_codigo_mc_idx on mc_transacciones_202105 a_124 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
131. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202106_tx_codigo_mc_idx on mc_transacciones_202106 a_125 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
132. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202107_tx_codigo_mc_idx on mc_transacciones_202107 a_126 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
133. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202108_tx_codigo_mc_idx on mc_transacciones_202108 a_127 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
134. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202109_tx_codigo_mc_idx on mc_transacciones_202109 a_128 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
135. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202110_tx_codigo_mc_idx on mc_transacciones_202110 a_129 (cost=0.14..9.23 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
136. 0.000 0.000 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202111_tx_codigo_mc_idx on mc_transacciones_202111 a_130 (cost=0.14..9.23 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
137. 0.002 0.002 ↓ 0.0 0 1 / 9

Parallel Index Scan using mc_transacciones_202112_tx_codigo_mc_idx on mc_transacciones_202112 a_131 (cost=0.14..9.23 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ((tx_codigo_mandante)::text <> ALL ('{MASTERCARD,VISA,UNIONPAY,MAESTRO,ACCOR,AMIPASS,SODEXHO}'::text[]))
138. 1,189.051 3,341.121 ↑ 1.5 3,410,459 9 / 9

Parallel Hash (cost=399,897.61..399,897.61 rows=5,115,661 width=8) (actual time=3,341.121..3,341.121 rows=3,410,459 loops=9)

  • Buckets: 4,194,304 Batches: 16 Memory Usage: 107,904kB
139. 2,152.070 2,152.070 ↑ 1.5 3,410,459 9 / 9

Parallel Seq Scan on dim_pub_trx_boletas_electronicas_sii b (cost=0.00..399,897.61 rows=5,115,661 width=8) (actual time=0.375..2,152.070 rows=3,410,459 loops=9)

Planning time : 32.631 ms