explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Amth

Settings
# exclusive inclusive rows x rows loops node
1. 5,847.220 48,472.687 ↑ 1.0 10 1

Limit (cost=33,608,146.58..33,608,147.78 rows=10 width=1,455) (actual time=48,472.655..48,472.687 rows=10 loops=1)

  • Functions: 657
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 52.517 ms, Inlining 60.288 ms, Optimization 3320.319 ms, Emission 2463.549 ms, Total 5896.674 ms
2. 0.027 42,625.467 ↑ 1,757.5 10 1

Result (cost=33,608,146.58..33,610,255.58 rows=17,575 width=1,455) (actual time=42,625.462..42,625.467 rows=10 loops=1)

3. 326.440 42,625.440 ↑ 1,757.5 10 1

Sort (cost=33,608,146.58..33,608,190.52 rows=17,575 width=1,427) (actual time=42,625.440..42,625.440 rows=10 loops=1)

  • Sort Key: po.po_data_pagto, po.po_id
  • Sort Method: top-N heapsort Memory: 30kB
4. 838.042 42,299.000 ↓ 15.7 276,129 1

Nested Loop Left Join (cost=4.66..33,607,766.79 rows=17,575 width=1,427) (actual time=1.037..42,299.000 rows=276,129 loops=1)

5. 93.372 39,804.184 ↓ 15.7 276,129 1

Nested Loop Left Join (cost=4.39..33,601,394.98 rows=17,575 width=1,178) (actual time=0.986..39,804.184 rows=276,129 loops=1)

  • Join Filter: (((turno.rht_inicio)::text <= (po.po_hora_transacao)::text) AND ((turno.rht_termino)::text >= (po.po_hora_transacao)::text) AND (turno.refo_id = po.refo_id))
6. 1,003.128 39,710.812 ↓ 15.7 276,129 1

Nested Loop Left Join (cost=4.11..33,600,690.56 rows=17,575 width=1,170) (actual time=0.978..39,710.812 rows=276,129 loops=1)

  • Join Filter: (cb.cb_id = eobtp.cb_id)
  • Rows Removed by Join Filter: 18316262
7. 1,533.376 37,879.297 ↓ 15.7 276,129 1

Nested Loop Left Join (cost=4.11..33,579,856.04 rows=17,575 width=1,161) (actual time=0.944..37,879.297 rows=276,129 loops=1)

  • Join Filter: (cct.cef_id = po.cef_id)
  • Rows Removed by Join Filter: 29821932
8. 97.254 34,965.276 ↓ 15.7 276,129 1

Nested Loop Left Join (cost=4.11..33,551,388.56 rows=17,575 width=1,154) (actual time=0.894..34,965.276 rows=276,129 loops=1)

  • Join Filter: ((loja.refo_id = po.refo_id) AND (loja.co_id = po.co_id) AND (loja.rlt_terminal = po.po_num_terminal))
9. 136.444 34,868.022 ↓ 15.7 276,129 1

Nested Loop Left Join (cost=3.84..33,551,035.66 rows=17,575 width=1,136) (actual time=0.883..34,868.022 rows=276,129 loops=1)

10. 90.401 34,455.449 ↓ 15.7 276,129 1

Nested Loop Left Join (cost=3.56..33,545,709.22 rows=17,575 width=1,094) (actual time=0.863..34,455.449 rows=276,129 loops=1)

11. 77.571 3,438.600 ↓ 15.7 276,129 1

Nested Loop (cost=1.29..521,170.00 rows=17,575 width=569) (actual time=0.176..3,438.600 rows=276,129 loops=1)

12. 630.981 2,808.771 ↓ 15.7 276,129 1

Nested Loop (cost=0.85..500,160.88 rows=17,575 width=495) (actual time=0.163..2,808.771 rows=276,129 loops=1)

  • Join Filter: (po.eobtp_id = eobtp.eobtp_id)
  • Rows Removed by Join Filter: 10163503
13. 265.681 1,625.532 ↓ 15.7 276,129 1

Nested Loop (cost=0.85..416,580.86 rows=17,575 width=454) (actual time=0.106..1,625.532 rows=276,129 loops=1)

  • Join Filter: (po.co_id = co.co_id)
  • Rows Removed by Join Filter: 4418064
14. 255.507 1,083.722 ↓ 15.7 276,129 1

Nested Loop (cost=0.85..396,799.91 rows=17,575 width=445) (actual time=0.082..1,083.722 rows=276,129 loops=1)

15. 288.657 552.086 ↓ 15.7 276,129 1

Nested Loop (cost=0.56..391,330.48 rows=17,575 width=388) (actual time=0.071..552.086 rows=276,129 loops=1)

  • Join Filter: ((20 + po.po_tipo_transacao) = tt.tt_id)
  • Rows Removed by Join Filter: 1656805
16. 263.429 263.429 ↑ 1.3 276,129 1

Index Scan using po_2019_11_refo_id_cef_id_ceg_id_cp_id_idx on po_2019_11 po (cost=0.56..330,068.60 rows=351,499 width=374) (actual time=0.040..263.429 rows=276,129 loops=1)

  • Index Cond: (refo_id = 6105)
  • Filter: ((po_data_pagto >= '2019-11-01'::date) AND (po_data_pagto <= '2019-11-18'::date) AND (po_tipo_transacao = ANY ('{1,2,3,4}'::integer[])))
  • Rows Removed by Filter: 32537
17. 0.000 0.000 ↑ 1.4 7 276,129

Materialize (cost=0.00..1.15 rows=10 width=16) (actual time=0.000..0.000 rows=7 loops=276,129)

18. 0.023 0.023 ↑ 1.0 10 1

Seq Scan on tipo_transacao tt (cost=0.00..1.10 rows=10 width=16) (actual time=0.021..0.023 rows=10 loops=1)

19. 276.129 276.129 ↑ 1.0 1 276,129

Index Scan using ceg_cef_refo_refopr_ceg_id_idx on ceg_cef_refo_refopr ccrr (cost=0.29..0.31 rows=1 width=73) (actual time=0.001..0.001 rows=1 loops=276,129)

  • Index Cond: (refopr_id = po.refopr_id)
20. 276.113 276.129 ↑ 4.5 17 276,129

Materialize (cost=0.00..2.14 rows=76 width=13) (actual time=0.000..0.001 rows=17 loops=276,129)

21. 0.016 0.016 ↑ 4.5 17 1

Seq Scan on cad_operadora co (cost=0.00..1.76 rows=76 width=13) (actual time=0.014..0.016 rows=17 loops=1)

22. 552.227 552.258 ↑ 8.4 38 276,129

Materialize (cost=0.00..8.77 rows=318 width=45) (actual time=0.000..0.002 rows=38 loops=276,129)

23. 0.031 0.031 ↑ 2.8 113 1

Seq Scan on empresa_operadora_bandeira_tipo_produto eobtp (cost=0.00..7.18 rows=318 width=45) (actual time=0.010..0.031 rows=113 loops=1)

24. 552.258 552.258 ↑ 1.0 1 276,129

Index Scan using importacao_dados_at_pkey on importacao_dados_at ida (cost=0.43..1.20 rows=1 width=82) (actual time=0.002..0.002 rows=1 loops=276,129)

  • Index Cond: (ida_id = po.ida_id)
25. 2,485.161 30,926.448 ↑ 1.0 1 276,129

Limit (cost=2.27..1,879.04 rows=1 width=533) (actual time=0.103..0.112 rows=1 loops=276,129)

26. 276.176 28,441.287 ↑ 1.0 1 276,129

Nested Loop Left Join (cost=2.27..1,879.04 rows=1 width=533) (actual time=0.103..0.103 rows=1 loops=276,129)

  • Join Filter: (cpa.cpa_status = csp.csp_id)
  • Rows Removed by Join Filter: 3
27. 0.000 27,889.029 ↑ 1.0 1 276,129

Nested Loop Left Join (cost=2.27..1,877.98 rows=1 width=519) (actual time=0.101..0.101 rows=1 loops=276,129)

28. 828.528 27,889.029 ↑ 1.0 1 276,129

Nested Loop (cost=1.70..1,877.35 rows=1 width=118) (actual time=0.101..0.101 rows=1 loops=276,129)

  • Join Filter: (tr.eobtp_id = to_eobtp.eobtp_id)
  • Rows Removed by Join Filter: 37
29. 0.000 26,232.255 ↑ 1.0 1 276,129

Nested Loop Left Join (cost=1.70..1,866.20 rows=1 width=99) (actual time=0.095..0.095 rows=1 loops=276,129)

30. 554.420 26,232.255 ↑ 1.0 1 276,129

Nested Loop Left Join (cost=0.99..1,865.43 rows=1 width=65) (actual time=0.095..0.095 rows=1 loops=276,129)

31. 0.000 12,978.063 ↑ 1.0 1 276,129

Unique (cost=0.84..1,794.62 rows=1 width=55) (actual time=0.047..0.047 rows=1 loops=276,129)

32. 1,104.657 12,978.063 ↑ 1.0 1 276,129

Nested Loop (cost=0.84..1,794.62 rows=1 width=55) (actual time=0.046..0.047 rows=1 loops=276,129)

33. 1,533.286 11,045.160 ↑ 38.0 1 276,129

Append (cost=0.42..70.92 rows=38 width=40) (actual time=0.040..0.040 rows=1 loops=276,129)

  • -> Index Scan using cpa_2021_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2021 cpa_37 (cost=0.15..2.37 rows=1 width=60)(actual time=0.002..0.175 rows=0 loops=47)
34. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_0000_po_data_pagto_po_id_to_id_cpa_status_cpa_descricao_idx on cpa_0000 cpa (cost=0.42..1.54 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
35. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_01_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_01 cpa_1 (cost=0.29..1.41 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
36. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_02_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_02 cpa_2 (cost=0.29..1.40 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
37. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_03_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_03 cpa_3 (cost=0.29..1.40 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
38. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_04_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_04 cpa_4 (cost=0.29..1.40 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
39. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_05_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_05 cpa_5 (cost=0.29..1.41 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
40. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_06_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_06 cpa_6 (cost=0.29..1.41 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
41. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_07_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_07 cpa_7 (cost=0.29..1.41 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
42. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_08_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_08 cpa_8 (cost=0.41..1.54 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
43. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_09_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_09 cpa_9 (cost=0.41..1.53 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
44. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_10_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_10 cpa_10 (cost=0.41..1.54 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
45. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_11_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_11 cpa_11 (cost=0.42..1.54 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
46. 276.129 276.129 ↓ 0.0 0 276,129

Index Only Scan using cpa_2018_12_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2018_12 cpa_12 (cost=0.43..1.55 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
47. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_01_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_01 cpa_13 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
48. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_02_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_02 cpa_14 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
49. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_03_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_03 cpa_15 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
50. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_04_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_04 cpa_16 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
51. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_05_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_05 cpa_17 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
52. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_06_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_06 cpa_18 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
53. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_07_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_07 cpa_19 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
54. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_08_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_08 cpa_20 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
55. 552.258 552.258 ↓ 0.0 0 276,129

Index Only Scan using cpa_2019_09_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_09 cpa_21 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,129)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
56. 552.254 552.254 ↓ 0.0 0 276,127

Index Only Scan using cpa_2019_10_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_10 cpa_22 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=0 loops=276,127)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
57. 288.184 288.184 ↑ 1.0 1 144,092

Index Only Scan using cpa_2019_11_po_data_pagto_po_id_to_id_cpa_status_cpa_descri_idx on cpa_2019_11 cpa_23 (cost=0.56..1.68 rows=1 width=29) (actual time=0.002..0.002 rows=1 loops=144,092)

  • Index Cond: ((po_data_pagto = po.po_data_pagto) AND (po_id = po.po_id))
  • Heap Fetches: 0
58. 8.178 8.178 ↓ 0.0 0 47

Index Scan using cpa_2019_12_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2019_12 cpa_24 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.174 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
59. 10.763 10.763 ↓ 0.0 0 47

Index Scan using cpa_2020_01_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_01 cpa_25 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.229 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
60. 8.413 8.413 ↓ 0.0 0 47

Index Scan using cpa_2020_02_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_02 cpa_26 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.179 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
61. 8.225 8.225 ↓ 0.0 0 47

Index Scan using cpa_2020_03_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_03 cpa_27 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.175 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
62. 8.413 8.413 ↓ 0.0 0 47

Index Scan using cpa_2020_04_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_04 cpa_28 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.179 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
63. 8.178 8.178 ↓ 0.0 0 47

Index Scan using cpa_2020_05_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_05 cpa_29 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.174 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
64. 9.729 9.729 ↓ 0.0 0 47

Index Scan using cpa_2020_06_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_06 cpa_30 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.207 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
65. 8.601 8.601 ↓ 0.0 0 47

Index Scan using cpa_2020_07_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_07 cpa_31 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.183 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
66. 8.178 8.178 ↓ 0.0 0 47

Index Scan using cpa_2020_08_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_08 cpa_32 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.174 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
67. 8.178 8.178 ↓ 0.0 0 47

Index Scan using cpa_2020_09_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_09 cpa_33 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.174 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
68. 8.178 8.178 ↓ 0.0 0 47

Index Scan using cpa_2020_10_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_10 cpa_34 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.174 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
69. 8.178 8.178 ↓ 0.0 0 47

Index Scan using cpa_2020_11_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_11 cpa_35 (cost=0.15..2.37 rows=1 width=60) (actual time=0.002..0.174 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
70. 8.225 8.225 ↓ 0.0 0 47

Index Scan using cpa_2020_12_po_id_po_data_pagto_to_id_cpa_data_idx on cpa_2020_12 cpa_36 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.175 rows=0 loops=47)

  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
  • Index Cond: ((po_id = po.po_id) AND (po_data_pagto = po.po_data_pagto))
71. 271.630 828.246 ↑ 38.0 1 276,082

Append (cost=0.42..44.98 rows=38 width=27) (actual time=0.003..0.003 rows=1 loops=276,082)

72. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_0000_to_data_venda_to_id_to_tipo_transacao_to_idt_aceler_idx on to_0000 tr (cost=0.42..1.54 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
73. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_01_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_01 tr_1 (cost=0.29..1.29 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
74. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_02_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_02 tr_2 (cost=0.29..1.23 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
75. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_03_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_03 tr_3 (cost=0.29..1.20 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
76. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_04_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_04 tr_4 (cost=0.29..1.20 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
77. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_05_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_05 tr_5 (cost=0.29..1.32 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
78. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_06_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_06 tr_6 (cost=0.29..1.29 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
79. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_07_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_07 tr_7 (cost=0.29..1.32 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
80. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_08_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_08 tr_8 (cost=0.41..1.48 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
81. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_09_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_09 tr_9 (cost=0.41..1.48 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
82. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_10_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_10 tr_10 (cost=0.41..1.48 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
83. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_11_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_11 tr_11 (cost=0.42..1.54 rows=1 width=26) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
84. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2018_12_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2018_12 tr_12 (cost=0.43..1.55 rows=1 width=26) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
85. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_01_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_01 tr_13 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
86. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_02_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_02 tr_14 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
87. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_03_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_03 tr_15 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
88. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_04_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_04 tr_16 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
89. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_05_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_05 tr_17 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
90. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_06_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_06 tr_18 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
91. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_07_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_07 tr_19 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_08_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_08 tr_20 (cost=0.56..1.69 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
93. 4.456 4.456 ↑ 1.0 1 2

Index Only Scan using to_2019_09_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_09 tr_21 (cost=0.56..1.69 rows=1 width=27) (actual time=0.020..2.228 rows=1 loops=2)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
94. 264.070 264.070 ↑ 1.0 1 132,035

Index Only Scan using to_2019_10_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_10 tr_22 (cost=0.56..1.69 rows=1 width=27) (actual time=0.002..0.002 rows=1 loops=132,035)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
95. 288.090 288.090 ↑ 1.0 1 144,045

Index Only Scan using to_2019_11_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_11 tr_23 (cost=0.56..1.69 rows=1 width=27) (actual time=0.002..0.002 rows=1 loops=144,045)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
96. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2019_12_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2019_12 tr_24 (cost=0.12..0.21 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
97. 0.000 0.000 ↓ 0.0 0

Index Only Scan using to_2020_01_to_data_venda_to_id_to_tipo_transacao_to_idt_ace_idx on to_2020_01 tr_25 (cost=0.12..0.21 rows=1 width=27) (never executed)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = cpa.to_id))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
  • Heap Fetches: 0
98. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_02_pkey on to_2020_02 tr_26 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_03_pkey on to_2020_03 tr_27 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
100. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_04_pkey on to_2020_04 tr_28 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_05_pkey on to_2020_05 tr_29 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
102. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_06_pkey on to_2020_06 tr_30 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_07_pkey on to_2020_07 tr_31 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_08_pkey on to_2020_08 tr_32 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_09_pkey on to_2020_09 tr_33 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_10_pkey on to_2020_10 tr_34 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_11_pkey on to_2020_11 tr_35 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2020_12_pkey on to_2020_12 tr_36 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using to_2021_pkey on to_2021 tr_37 (cost=0.14..0.66 rows=1 width=40) (never executed)

  • Index Cond: ((to_id = cpa.to_id) AND (to_data_venda = cpa.cpa_data))
  • Filter: ((NOT to_idt_acelerado) AND (to_tipo_transacao = 1))
110. 0.000 12,699.772 ↓ 0.0 0 276,082

Append (cost=0.15..70.42 rows=38 width=38) (actual time=0.046..0.046 rows=0 loops=276,082)

111. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_0000_to_data_venda_to_id_cca_data_cca_data1_cca_status__idx on cca_0000 cca (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
112. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_01_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_01 cca_1 (cost=0.41..1.53 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
113. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_02_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_02 cca_2 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
114. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_03_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_03 cca_3 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
115. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_04_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_04 cca_4 (cost=0.28..1.40 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
116. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_05_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_05 cca_5 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
117. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_06_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_06 cca_6 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
118. 276.082 276.082 ↓ 0.0 0 276,082

Seq Scan on cca_2018_07 cca_7 (cost=0.00..1.12 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Filter: ((to_id = tr.to_id) AND (to_data_venda = cpa.cpa_data))
  • Rows Removed by Filter: 8
119. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_08_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_08 cca_8 (cost=0.28..1.40 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
120. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_09_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_09 cca_9 (cost=0.28..1.40 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
121. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_10_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_10 cca_10 (cost=0.28..1.40 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
122. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_11_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_11 cca_11 (cost=0.28..1.40 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
123. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2018_12_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2018_12 cca_12 (cost=0.28..1.40 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
124. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_01_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_01 cca_13 (cost=0.56..1.68 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
125. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_02_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_02 cca_14 (cost=0.56..1.68 rows=1 width=37) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
126. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_03_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_03 cca_15 (cost=0.56..1.68 rows=1 width=37) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
127. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_04_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_04 cca_16 (cost=0.56..1.68 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
128. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_05_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_05 cca_17 (cost=0.56..1.68 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
129. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_06_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_06 cca_18 (cost=0.56..1.68 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
130. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_07_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_07 cca_19 (cost=0.56..1.68 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
131. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_08_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_08 cca_20 (cost=0.56..1.68 rows=1 width=35) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
132. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_09_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_09 cca_21 (cost=0.56..1.68 rows=1 width=35) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
133. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_10_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_10 cca_22 (cost=0.56..1.68 rows=1 width=52) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
134. 552.164 552.164 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_11_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_11 cca_23 (cost=0.43..1.55 rows=1 width=50) (actual time=0.002..0.002 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
135. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2019_12_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2019_12 cca_24 (cost=0.41..1.53 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
136. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_01_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_01 cca_25 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
137. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_02_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_02 cca_26 (cost=0.28..1.40 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
138. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_03_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_03 cca_27 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
139. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_04_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_04 cca_28 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
140. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_05_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_05 cca_29 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
141. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_06_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_06 cca_30 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
142. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_07_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_07 cca_31 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
143. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_08_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_08 cca_32 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
144. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_09_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_09 cca_33 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
145. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_10_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_10 cca_34 (cost=0.28..1.40 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
146. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_11_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_11 cca_35 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
147. 276.082 276.082 ↓ 0.0 0 276,082

Index Only Scan using cca_2020_12_to_data_venda_to_id_cca_data_cca_data1_cca_stat_idx on cca_2020_12 cca_36 (cost=0.15..2.37 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Index Cond: ((to_data_venda = cpa.cpa_data) AND (to_id = tr.to_id))
  • Heap Fetches: 0
148. 276.082 276.082 ↓ 0.0 0 276,082

Seq Scan on cca_2021 cca_37 (cost=0.00..1.03 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=276,082)

  • Filter: ((to_id = tr.to_id) AND (to_data_venda = cpa.cpa_data))
  • Rows Removed by Filter: 2
149. 0.000 0.000 ↓ 0.0 0 276,082

Nested Loop (cost=0.71..0.76 rows=1 width=50) (actual time=0.000..0.000 rows=0 loops=276,082)

150. 0.000 0.000 ↓ 0.0 0 276,082

Index Only Scan using idx_idcia_id_emissao on importacao_dados_cliente_item_at idcia_1 (cost=0.57..0.59 rows=1 width=31) (actual time=0.000..0.000 rows=0 loops=276,082)

  • Index Cond: ((idcia_id = cca.idcia_id) AND (idcia_dataemissao = cca.cca_data))
  • Heap Fetches: 0
151. 0.000 0.000 ↓ 0.0 0

Index Scan using empresa_operadora_bandeira_tipo_produto_pkey on empresa_operadora_bandeira_tipo_produto idcia_eobtp (cost=0.15..0.17 rows=1 width=23) (never executed)

  • Index Cond: (eobtp_id = idcia_1.eobtp_id)
152. 828.246 828.246 ↑ 8.4 38 276,082

Seq Scan on empresa_operadora_bandeira_tipo_produto to_eobtp (cost=0.00..7.18 rows=318 width=23) (actual time=0.001..0.003 rows=38 loops=276,082)

153. 0.000 0.000 ↓ 0.0 0 276,082

Index Scan using idx_idcia_dados_complementares_fk_idcia_id on idcia_dados_complementares idc (cost=0.56..0.62 rows=1 width=409) (actual time=0.000..0.000 rows=0 loops=276,082)

  • Index Cond: (idcia_id = cca.idcia_id)
154. 276.082 276.082 ↑ 1.0 3 276,082

Seq Scan on cad_status_pagamento csp (cost=0.00..1.03 rows=3 width=10) (actual time=0.000..0.001 rows=3 loops=276,082)

155. 276.129 276.129 ↓ 0.0 0 276,129

Index Scan using po_moedas_pkey on po_moedas pm (cost=0.29..0.30 rows=1 width=50) (actual time=0.001..0.001 rows=0 loops=276,129)

  • Index Cond: (po_id = po.po_id)
156. 0.000 0.000 ↓ 0.0 0 276,129

Materialize (cost=0.27..1.40 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=276,129)

157. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using idx_loja on loja (cost=0.27..1.39 rows=1 width=34) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (refo_id = 6105)
  • Heap Fetches: 0
158. 1,380.630 1,380.645 ↑ 1.0 108 276,129

Materialize (cost=0.00..2.62 rows=108 width=15) (actual time=0.000..0.005 rows=108 loops=276,129)

159. 0.015 0.015 ↑ 1.0 108 1

Seq Scan on cef_categoria cct (cost=0.00..2.08 rows=108 width=15) (actual time=0.007..0.015 rows=108 loops=1)

160. 828.370 828.387 ↑ 1.2 67 276,129

Materialize (cost=0.00..2.20 rows=80 width=13) (actual time=0.000..0.003 rows=67 loops=276,129)

161. 0.017 0.017 ↑ 1.1 75 1

Seq Scan on cad_bandeira cb (cost=0.00..1.80 rows=80 width=13) (actual time=0.007..0.017 rows=75 loops=1)

162. 0.000 0.000 ↓ 0.0 0 276,129

Materialize (cost=0.27..1.42 rows=2 width=28) (actual time=0.000..0.000 rows=0 loops=276,129)

163. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using idx_turno on turno (cost=0.27..1.41 rows=2 width=28) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (refo_id = 6105)
  • Heap Fetches: 0
164. 1,656.774 1,656.774 ↓ 0.0 0 276,129

Index Only Scan using idx_cac_origem on cad_ajuste_conta cac (cost=0.28..0.30 rows=1 width=30) (actual time=0.006..0.006 rows=0 loops=276,129)

  • Index Cond: ((cac_banco_orig = po.po_num_banco) AND (cac_agencia_orig = po.po_num_agencia) AND (cac_conta_orig = po.po_num_cc))
  • Heap Fetches: 0
Planning time : 67.036 ms
Execution time : 48,555.761 ms