explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w74i

Settings
# exclusive inclusive rows x rows loops node
1. 0.323 484,578.832 ↑ 3.4 190 1

Hash Left Join (cost=664,361.62..703,232.91 rows=639 width=814) (actual time=484,509.877..484,578.832 rows=190 loops=1)

  • Hash Cond: ("*SELECT* 1".cof_c_planofinanceiro_id = pf.cof_c_planofinanceiro_id)
2. 0.071 484,578.452 ↑ 3.4 190 1

Hash Left Join (cost=664,354.04..703,063.88 rows=639 width=773) (actual time=484,509.800..484,578.452 rows=190 loops=1)

  • Hash Cond: ("*SELECT* 1".c_activity_id = ac.c_activity_id)
3. 0.075 484,578.371 ↑ 3.4 190 1

Hash Left Join (cost=664,352.84..703,060.96 rows=639 width=776) (actual time=484,509.782..484,578.371 rows=190 loops=1)

  • Hash Cond: ("*SELECT* 1".user1_id = u1.c_elementvalue_id)
4. 0.009 484,577.915 ↑ 3.4 190 1

Nested Loop Left Join (cost=664,294.08..703,000.51 rows=639 width=766) (actual time=484,509.390..484,577.915 rows=190 loops=1)

5. 20.672 484,577.336 ↑ 3.4 190 1

Hash Left Join (cost=664,293.79..702,800.02 rows=639 width=754) (actual time=484,509.374..484,577.336 rows=190 loops=1)

  • Hash Cond: ("*SELECT* 1".cof_c_custody_id = cu.cof_c_custody_id)
  • Filter: (CASE WHEN (bai.t_integer IS NOT NULL) THEN ("*SELECT* 1".duedate + ('1 day'::interval * ((bai.t_integer + cu.cof_diasadeslocar))::double precision)) ELSE ("*SELECT* 1".duedate + ('1 day'::interval * (cu.cof_diasadeslocar)::double precision)) END = '2019-04-07'::date)
  • Rows Removed by Filter: 42605
6. 6.953 484,556.648 ↑ 3.0 42,795 1

Hash Left Join (cost=664,292.23..702,442.97 rows=127,849 width=782) (actual time=484,498.348..484,556.648 rows=42,795 loops=1)

  • Hash Cond: (t.cof_c_bankintegration_id = bai.cof_c_bankintegration_id)
7. 22.569 484,549.679 ↑ 3.0 42,795 1

Hash Left Join (cost=664,290.84..702,022.31 rows=127,849 width=785) (actual time=484,498.323..484,549.679 rows=42,795 loops=1)

  • Hash Cond: ("*SELECT* 1".cof_titulo_id = t.cof_titulo_id)
  • Filter: ((t.cof_billfoldtype IS NULL) OR ((t.cof_billfoldtype)::text = 'CS'::text))
8. 26.303 484,486.483 ↑ 3.0 42,795 1

Unique (cost=656,108.63..692,225.97 rows=127,849 width=3,648) (actual time=484,457.667..484,486.483 rows=42,795 loops=1)

9. 288.066 484,460.180 ↑ 3.0 42,795 1

Sort (cost=656,108.63..656,428.25 rows=127,849 width=3,648) (actual time=484,457.666..484,460.180 rows=42,795 loops=1)

  • Sort Key: "*SELECT* 1".ad_org_id, "*SELECT* 1".ad_client_id, "*SELECT* 1".documentno, "*SELECT* 1".c_invoice_id, "*SELECT* 1".c_order_id, "*SELECT* 1".c_bpartner_id, "*SELECT* 1".issotrx, "*SELECT* 1".dateinvoiced, "*SELECT* 1".dateacct, "*SELECT* 1".netdays, "*SELECT* 1".duedate, "*SELECT* 1".daysdue, (("*SELECT* 1".discountdate)::timestamp without time zone), "*SELECT* 1".discountamt, "*SELECT* 1".grandtotal, "*SELECT* 1".paidamt, "*SELECT* 1".openamt, "*SELECT* 1".c_currency_id, "*SELECT* 1".c_conversiontype_id, "*SELECT* 1".c_paymentterm_id, "*SELECT* 1".ispayschedulevalid, (NULL::numeric), "*SELECT* 1".invoicecollectiontype, "*SELECT* 1".c_campaign_id, "*SELECT* 1".c_project_id, "*SELECT* 1".c_activity_id, "*SELECT* 1".ad_orgtrx_id, "*SELECT* 1".ad_user_id, "*SELECT* 1".c_bpartner_location_id, "*SELECT* 1".c_charge_id, "*SELECT* 1".c_doctype_id, "*SELECT* 1".c_doctypetarget_id, "*SELECT* 1".c_dunninglevel_id, "*SELECT* 1".chargeamt, "*SELECT* 1".c_payment_id, "*SELECT* 1".created, "*SELECT* 1".createdby, "*SELECT* 1".dateordered, "*SELECT* 1".dateprinted, "*SELECT* 1".description, "*SELECT* 1".docaction, "*SELECT* 1".docstatus, "*SELECT* 1".dunninggrace, "*SELECT* 1".generateto, "*SELECT* 1".isactive, "*SELECT* 1".isapproved, "*SELECT* 1".isdiscountprinted, "*SELECT* 1".isindispute, "*SELECT* 1".ispaid, "*SELECT* 1".isprinted, "*SELECT* 1".isselfservice, "*SELECT* 1".istaxincluded, "*SELECT* 1".istransferred, "*SELECT* 1".m_pricelist_id, "*SELECT* 1".m_rma_id, "*SELECT* 1".paymentrule, "*SELECT* 1".poreference, "*SELECT* 1".posted, "*SELECT* 1".processedon, "*SELECT* 1".processing, "*SELECT* 1".ref_invoice_id, "*SELECT* 1".reversal_id, "*SELECT* 1".salesrep_id, "*SELECT* 1".sendemail, "*SELECT* 1".totallines, "*SELECT* 1".updated, "*SELECT* 1".updatedby, "*SELECT* 1".user1_id, "*SELECT* 1".user2_id, "*SELECT* 1".ide_nnf, "*SELECT* 1".lbr_nfestatus, "*SELECT* 1".ide_serie, "*SELECT* 1".ide_tpnf, "*SELECT* 1".cof_processed, "*SELECT* 1".cof_processed2, "*SELECT* 1".cof_borderoname, "*SELECT* 1".cof_titulo_nossonumero, "*SELECT* 1".cof_bankintegrationname, "*SELECT* 1".cof_occurrencevalue, "*SELECT* 1".cof_occurrencename, "*SELECT* 1".cof_titulo_id, "*SELECT* 1".cof_recordhistory, "*SELECT* 1".lbr_transactiontype, "*SELECT* 1".infnfe_id, "*SELECT* 1".lbr_nfentrada, "*SELECT* 1".cof_serienfentrada, "*SELECT* 1".lbr_nfmodel, "*SELECT* 1".cof_otheramt, "*SELECT* 1".cof_insuranceamt, "*SELECT* 1".cof_modfrete, "*SELECT* 1".cof_sourceinvoice_id, "*SELECT* 1".cof_composescashflow, "*SELECT* 1".cof_payfrom_location_id, "*SELECT* 1".cof_orgst_id, "*SELECT* 1".cof_isindustrialization, "*SELECT* 1".lbr_docfiscal_id, "*SELECT* 1".cof_qtycheck, "*SELECT* 1".c_bp_group_id, "*SELECT* 1".cof_c_custody_id, "*SELECT* 1".bpartner_value, "*SELECT* 1".cof_c_planofinanceiro_id, "*SELECT* 1".cof_openamtconverted, "*SELECT* 1".cof_grandtotalconverted, "*SELECT* 1".cof_exibiremrelatorios, "*SELECT* 1".rv_openitem_id, (NULL::character varying), "*SELECT* 1".cof_c_bankintegration_id, "*SELECT* 1".cof_c_bankoccurrence_id, (NULL::timestamp without time zone), ('N'::text), "*SELECT* 1".cof_titulo_numdoc, "*SELECT* 1".cof_checkallocateamt
  • Sort Method: quicksort Memory: 29932kB
10. 5.883 484,172.114 ↑ 3.0 42,795 1

Append (cost=41,797.59..527,783.03 rows=127,849 width=3,648) (actual time=25,433.266..484,172.114 rows=42,795 loops=1)

11. 0.408 25,827.522 ↑ 34.9 622 1

Subquery Scan on *SELECT* 1 (cost=41,797.59..136,260.72 rows=21,731 width=1,270) (actual time=25,433.265..25,827.522 rows=622 loops=1)

12. 371.449 25,827.114 ↑ 34.9 622 1

Hash Left Join (cost=41,797.59..135,989.08 rows=21,731 width=1,266) (actual time=25,433.264..25,827.114 rows=622 loops=1)

  • Hash Cond: (bp_1.c_bp_group_id = bpg.c_bp_group_id)
13. 0.526 25,455.661 ↑ 34.9 622 1

Hash Left Join (cost=41,796.46..47,554.09 rows=21,731 width=818) (actual time=25,428.881..25,455.661 rows=622 loops=1)

  • Hash Cond: (i.c_bpartner_id = bp_1.c_bpartner_id)
14. 0.573 25,447.869 ↑ 34.9 622 1

Hash Join (cost=40,404.96..46,105.54 rows=21,731 width=799) (actual time=25,421.600..25,447.869 rows=622 loops=1)

  • Hash Cond: (i.c_paymentterm_id = p.c_paymentterm_id)
15. 21.317 25,447.273 ↑ 34.9 622 1

Hash Right Join (cost=40,401.72..46,040.86 rows=21,731 width=790) (actual time=25,421.570..25,447.273 rows=622 loops=1)

  • Hash Cond: (df.c_invoice_id = i.c_invoice_id)
16. 5.118 5.118 ↑ 1.0 30,081 1

Seq Scan on lbr_docfiscal df (cost=0.00..5,468.81 rows=30,081 width=22) (actual time=0.002..5.118 rows=30,081 loops=1)

17. 0.353 25,420.838 ↑ 34.9 622 1

Hash (cost=40,130.08..40,130.08 rows=21,731 width=774) (actual time=25,420.838..25,420.838 rows=622 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 484kB
18. 0.407 25,420.485 ↑ 34.9 622 1

Hash Right Join (cost=37,343.03..40,130.08 rows=21,731 width=774) (actual time=25,414.749..25,420.485 rows=622 loops=1)

  • Hash Cond: (t_1.c_invoice_id = i.c_invoice_id)
19. 0.024 10.100 ↑ 97.2 97 1

Hash Left Join (cost=5.34..2,738.94 rows=9,429 width=260) (actual time=0.118..10.100 rows=97 loops=1)

  • Hash Cond: (t_1.cof_c_bankoccurrence_id = bo.cof_c_bankoccurrence_id)
20. 0.036 10.048 ↑ 97.2 97 1

Hash Left Join (cost=1.67..2,709.35 rows=9,429 width=224) (actual time=0.087..10.048 rows=97 loops=1)

  • Hash Cond: (t_1.cof_c_bankintegration_id = bi.cof_c_bankintegration_id)
21. 10.001 10.001 ↑ 97.2 97 1

Index Scan using idx_cof_titulo_coalesce_c_invoicepayschedule_id on cof_titulo t_1 (cost=0.29..2,677.04 rows=9,429 width=201) (actual time=0.069..10.001 rows=97 loops=1)

  • Index Cond: (COALESCE(c_invoicepayschedule_id, '0'::numeric) = '0'::numeric)
  • Filter: (isvalid = 'Y'::bpchar)
  • Rows Removed by Filter: 12072
22. 0.004 0.011 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=29) (actual time=0.011..0.011 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
23. 0.007 0.007 ↑ 1.0 17 1

Seq Scan on cof_c_bankintegration bi (cost=0.00..1.17 rows=17 width=29) (actual time=0.004..0.007 rows=17 loops=1)

24. 0.012 0.028 ↑ 1.0 74 1

Hash (cost=2.74..2.74 rows=74 width=43) (actual time=0.028..0.028 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
25. 0.016 0.016 ↑ 1.0 74 1

Seq Scan on cof_c_bankoccurrence bo (cost=0.00..2.74 rows=74 width=43) (actual time=0.006..0.016 rows=74 loops=1)

26. 1.110 25,409.978 ↑ 34.9 622 1

Hash (cost=37,066.06..37,066.06 rows=21,731 width=520) (actual time=25,409.978..25,409.978 rows=622 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 483kB
27. 0.602 25,408.868 ↑ 34.9 622 1

Hash Left Join (cost=3,106.01..37,066.06 rows=21,731 width=520) (actual time=25.600..25,408.868 rows=622 loops=1)

  • Hash Cond: (i.c_invoice_id = df_1.c_invoice_id)
28. 0.510 25,402.337 ↑ 34.9 622 1

Hash Join (cost=2,185.00..35,978.86 rows=21,731 width=520) (actual time=19.658..25,402.337 rows=622 loops=1)

  • Hash Cond: (bpl.c_location_id = loc.c_location_id)
29. 0.535 25,397.736 ↑ 34.9 622 1

Hash Join (cost=1,555.48..35,292.29 rows=21,731 width=526) (actual time=15.556..25,397.736 rows=622 loops=1)

  • Hash Cond: (i.c_bpartner_location_id = bpl.c_bpartner_location_id)
30. 0.545 25,390.749 ↑ 34.9 622 1

Hash Join (cost=596.11..34,275.86 rows=21,731 width=520) (actual time=9.093..25,390.749 rows=622 loops=1)

  • Hash Cond: (i.c_bpartner_id = b.c_bpartner_id)
31. 0.803 25,386.452 ↑ 34.9 622 1

Hash Join (cost=13.92..33,636.61 rows=21,731 width=520) (actual time=5.332..25,386.452 rows=622 loops=1)

  • Hash Cond: (i.c_doctype_id = d.c_doctype_id)
32. 25,385.572 25,385.572 ↑ 34.9 622 1

Index Scan using idx_c_invoice_docstatus_ispayschedulevalid_issotrx on c_invoice i (cost=0.42..33,564.86 rows=21,731 width=516) (actual time=5.250..25,385.572 rows=622 loops=1)

  • Index Cond: ((docstatus = ANY ('{CO,CL}'::bpchar[])) AND (issotrx = 'Y'::bpchar))
  • Filter: ((ispayschedulevalid <> 'Y'::bpchar) AND (cof_composescashflow = 'Y'::bpchar) AND (invoiceopen(c_invoice_id, '0'::numeric) <> '0'::numeric))
  • Rows Removed by Filter: 96708
33. 0.027 0.077 ↑ 1.0 200 1

Hash (cost=11.00..11.00 rows=200 width=10) (actual time=0.077..0.077 rows=200 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
34. 0.050 0.050 ↑ 1.0 200 1

Seq Scan on c_doctype d (cost=0.00..11.00 rows=200 width=10) (actual time=0.002..0.050 rows=200 loops=1)

35. 2.149 3.752 ↑ 1.0 19,000 1

Hash (cost=344.69..344.69 rows=19,000 width=6) (actual time=3.752..3.752 rows=19,000 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 980kB
36. 1.603 1.603 ↑ 1.0 19,000 1

Index Only Scan using c_bpartner_pkey on c_bpartner b (cost=0.29..344.69 rows=19,000 width=6) (actual time=0.017..1.603 rows=19,000 loops=1)

  • Heap Fetches: 0
37. 2.482 6.452 ↑ 1.0 20,239 1

Hash (cost=706.39..706.39 rows=20,239 width=12) (actual time=6.452..6.452 rows=20,239 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1166kB
38. 3.970 3.970 ↑ 1.0 20,239 1

Seq Scan on c_bpartner_location bpl (cost=0.00..706.39 rows=20,239 width=12) (actual time=0.005..3.970 rows=20,239 loops=1)

39. 2.321 4.091 ↑ 1.0 20,521 1

Hash (cost=373.00..373.00 rows=20,521 width=6) (actual time=4.091..4.091 rows=20,521 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1038kB
40. 1.770 1.770 ↑ 1.0 20,521 1

Index Only Scan using c_location_pkey on c_location loc (cost=0.29..373.00 rows=20,521 width=6) (actual time=0.015..1.770 rows=20,521 loops=1)

  • Heap Fetches: 0
41. 3.384 5.929 ↑ 1.0 29,985 1

Hash (cost=545.00..545.00 rows=30,081 width=6) (actual time=5.929..5.929 rows=29,985 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1398kB
42. 2.545 2.545 ↑ 1.0 30,081 1

Index Only Scan using idx_lbr_docfiscal_c_invoice_id on lbr_docfiscal df_1 (cost=0.29..545.00 rows=30,081 width=6) (actual time=0.016..2.545 rows=30,081 loops=1)

  • Heap Fetches: 0
43. 0.010 0.023 ↑ 1.0 55 1

Hash (cost=2.55..2.55 rows=55 width=15) (actual time=0.023..0.023 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
44. 0.013 0.013 ↑ 1.0 55 1

Seq Scan on c_paymentterm p (cost=0.00..2.55 rows=55 width=15) (actual time=0.003..0.013 rows=55 loops=1)

45. 2.723 7.266 ↑ 1.0 19,000 1

Hash (cost=1,154.00..1,154.00 rows=19,000 width=25) (actual time=7.266..7.266 rows=19,000 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1350kB
46. 4.543 4.543 ↑ 1.0 19,000 1

Seq Scan on c_bpartner bp_1 (cost=0.00..1,154.00 rows=19,000 width=25) (actual time=0.002..4.543 rows=19,000 loops=1)

47. 0.001 0.004 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=6) (actual time=0.004..0.004 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
48. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on c_bp_group bpg (cost=0.00..1.06 rows=6 width=6) (actual time=0.002..0.003 rows=6 loops=1)

49. 38.626 458,338.709 ↑ 2.5 42,173 1

Subquery Scan on *SELECT* 2 (cost=28,761.96..391,522.31 rows=106,118 width=1,198) (actual time=368.450..458,338.709 rows=42,173 loops=1)

50. 87,266.272 458,300.083 ↑ 2.5 42,173 1

Hash Left Join (cost=28,761.96..389,930.54 rows=106,118 width=1,170) (actual time=368.448..458,300.083 rows=42,173 loops=1)

  • Hash Cond: (bp_2.c_bp_group_id = bpg_1.c_bp_group_id)
51. 37.066 371,033.805 ↑ 2.5 42,173 1

Hash Left Join (cost=28,760.82..65,263.60 rows=106,118 width=851) (actual time=367.730..371,033.805 rows=42,173 loops=1)

  • Hash Cond: (i_1.c_bpartner_id = bp_2.c_bpartner_id)
52. 30.632 370,990.571 ↑ 2.5 42,173 1

Hash Left Join (cost=27,369.32..63,593.47 rows=106,118 width=832) (actual time=361.546..370,990.571 rows=42,173 loops=1)

  • Hash Cond: (i_1.c_invoice_id = df_2.c_invoice_id)
53. 48.072 370,930.609 ↑ 2.5 42,173 1

Hash Left Join (cost=21,524.50..56,937.11 rows=106,118 width=816) (actual time=332.202..370,930.609 rows=42,173 loops=1)

  • Hash Cond: ((i_1.c_invoice_id = t_2.c_invoice_id) AND (ips.c_invoicepayschedule_id = t_2.c_invoicepayschedule_id))
54. 370,484.272 370,812.637 ↑ 2.5 42,173 1

Hash Join (cost=12,984.13..47,600.84 rows=106,118 width=562) (actual time=262.285..370,812.637 rows=42,173 loops=1)

  • Hash Cond: (ips.c_invoice_id = i_1.c_invoice_id)
  • Join Filter: (invoiceopen(i_1.c_invoice_id, ips.c_invoicepayschedule_id) <> '0'::numeric)
  • Rows Removed by Join Filter: 97734
55. 68.551 68.551 ↓ 1.0 163,333 1

Seq Scan on c_invoicepayschedule ips (cost=0.00..6,008.43 rows=163,307 width=54) (actual time=0.005..68.551 rows=163,333 loops=1)

  • Filter: (isvalid = 'Y'::bpchar)
  • Rows Removed by Filter: 61
56. 43.938 259.814 ↑ 1.0 73,412 1

Hash (cost=12,059.59..12,059.59 rows=73,963 width=514) (actual time=259.814..259.814 rows=73,412 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 26960kB
57. 29.259 215.876 ↑ 1.0 73,412 1

Hash Left Join (cost=3,106.01..12,059.59 rows=73,963 width=514) (actual time=19.023..215.876 rows=73,412 loops=1)

  • Hash Cond: (i_1.c_invoice_id = df_3.c_invoice_id)
58. 31.194 181.036 ↑ 1.0 73,412 1

Hash Join (cost=2,185.00..10,572.94 rows=73,963 width=514) (actual time=13.428..181.036 rows=73,412 loops=1)

  • Hash Cond: (bpl_1.c_location_id = loc_1.c_location_id)
59. 31.362 146.045 ↑ 1.0 73,412 1

Hash Join (cost=1,555.48..9,749.23 rows=73,963 width=520) (actual time=9.623..146.045 rows=73,412 loops=1)

  • Hash Cond: (i_1.c_bpartner_location_id = bpl_1.c_bpartner_location_id)
60. 30.528 108.679 ↑ 1.0 73,412 1

Hash Join (cost=596.11..8,595.66 rows=73,963 width=514) (actual time=3.606..108.679 rows=73,412 loops=1)

  • Hash Cond: (i_1.c_bpartner_id = b_1.c_bpartner_id)
61. 31.402 74.635 ↑ 1.0 73,412 1

Hash Join (cost=13.92..7,819.27 rows=73,963 width=514) (actual time=0.078..74.635 rows=73,412 loops=1)

  • Hash Cond: (i_1.c_doctype_id = d_1.c_doctype_id)
62. 43.171 43.171 ↑ 1.0 73,412 1

Index Scan using idx_c_invoice_docstatus_ispayschedulevalid_issotrx on c_invoice i_1 (cost=0.42..7,607.50 rows=73,963 width=510) (actual time=0.012..43.171 rows=73,412 loops=1)

  • Index Cond: ((docstatus = ANY ('{CO,CL}'::bpchar[])) AND (ispayschedulevalid = 'Y'::bpchar) AND (issotrx = 'Y'::bpchar))
  • Filter: (cof_composescashflow = 'Y'::bpchar)
  • Rows Removed by Filter: 47
63. 0.024 0.062 ↑ 1.0 200 1

Hash (cost=11.00..11.00 rows=200 width=10) (actual time=0.062..0.062 rows=200 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
64. 0.038 0.038 ↑ 1.0 200 1

Seq Scan on c_doctype d_1 (cost=0.00..11.00 rows=200 width=10) (actual time=0.003..0.038 rows=200 loops=1)

65. 2.102 3.516 ↑ 1.0 19,000 1

Hash (cost=344.69..344.69 rows=19,000 width=6) (actual time=3.516..3.516 rows=19,000 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 980kB
66. 1.414 1.414 ↑ 1.0 19,000 1

Index Only Scan using c_bpartner_pkey on c_bpartner b_1 (cost=0.29..344.69 rows=19,000 width=6) (actual time=0.009..1.414 rows=19,000 loops=1)

  • Heap Fetches: 0
67. 2.451 6.004 ↑ 1.0 20,239 1

Hash (cost=706.39..706.39 rows=20,239 width=12) (actual time=6.004..6.004 rows=20,239 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1166kB
68. 3.553 3.553 ↑ 1.0 20,239 1

Seq Scan on c_bpartner_location bpl_1 (cost=0.00..706.39 rows=20,239 width=12) (actual time=0.003..3.553 rows=20,239 loops=1)

69. 2.259 3.797 ↑ 1.0 20,521 1

Hash (cost=373.00..373.00 rows=20,521 width=6) (actual time=3.797..3.797 rows=20,521 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1038kB
70. 1.538 1.538 ↑ 1.0 20,521 1

Index Only Scan using c_location_pkey on c_location loc_1 (cost=0.29..373.00 rows=20,521 width=6) (actual time=0.010..1.538 rows=20,521 loops=1)

  • Heap Fetches: 0
71. 3.305 5.581 ↑ 1.0 29,985 1

Hash (cost=545.00..545.00 rows=30,081 width=6) (actual time=5.581..5.581 rows=29,985 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1398kB
72. 2.276 2.276 ↑ 1.0 30,081 1

Index Only Scan using idx_lbr_docfiscal_c_invoice_id on lbr_docfiscal df_3 (cost=0.29..545.00 rows=30,081 width=6) (actual time=0.010..2.276 rows=30,081 loops=1)

  • Heap Fetches: 0
73. 13.521 69.900 ↑ 1.0 41,323 1

Hash (cost=7,919.29..7,919.29 rows=41,405 width=266) (actual time=69.900..69.900 rows=41,323 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 11358kB
74. 9.628 56.379 ↓ 1.0 41,420 1

Hash Left Join (cost=5.05..7,919.29 rows=41,405 width=266) (actual time=0.052..56.379 rows=41,420 loops=1)

  • Hash Cond: (t_2.cof_c_bankoccurrence_id = bo_1.cof_c_bankoccurrence_id)
75. 9.826 46.727 ↓ 1.0 41,420 1

Hash Left Join (cost=1.38..7,801.82 rows=41,405 width=230) (actual time=0.026..46.727 rows=41,420 loops=1)

  • Hash Cond: (t_2.cof_c_bankintegration_id = bi_1.cof_c_bankintegration_id)
76. 36.893 36.893 ↓ 1.0 41,420 1

Seq Scan on cof_titulo t_2 (cost=0.00..7,664.65 rows=41,405 width=207) (actual time=0.014..36.893 rows=41,420 loops=1)

  • Filter: (isvalid = 'Y'::bpchar)
  • Rows Removed by Filter: 12072
77. 0.003 0.008 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=29) (actual time=0.008..0.008 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
78. 0.005 0.005 ↑ 1.0 17 1

Seq Scan on cof_c_bankintegration bi_1 (cost=0.00..1.17 rows=17 width=29) (actual time=0.002..0.005 rows=17 loops=1)

79. 0.012 0.024 ↑ 1.0 74 1

Hash (cost=2.74..2.74 rows=74 width=43) (actual time=0.024..0.024 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
80. 0.012 0.012 ↑ 1.0 74 1

Seq Scan on cof_c_bankoccurrence bo_1 (cost=0.00..2.74 rows=74 width=43) (actual time=0.003..0.012 rows=74 loops=1)

81. 4.396 29.330 ↑ 1.0 29,985 1

Hash (cost=5,468.81..5,468.81 rows=30,081 width=22) (actual time=29.330..29.330 rows=29,985 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1908kB
82. 24.934 24.934 ↑ 1.0 30,081 1

Seq Scan on lbr_docfiscal df_2 (cost=0.00..5,468.81 rows=30,081 width=22) (actual time=0.005..24.934 rows=30,081 loops=1)

83. 2.708 6.168 ↑ 1.0 19,000 1

Hash (cost=1,154.00..1,154.00 rows=19,000 width=25) (actual time=6.168..6.168 rows=19,000 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1350kB
84. 3.460 3.460 ↑ 1.0 19,000 1

Seq Scan on c_bpartner bp_2 (cost=0.00..1,154.00 rows=19,000 width=25) (actual time=0.004..3.460 rows=19,000 loops=1)

85. 0.002 0.006 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=6) (actual time=0.006..0.006 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 0.004 0.004 ↑ 1.0 6 1

Seq Scan on c_bp_group bpg_1 (cost=0.00..1.06 rows=6 width=6) (actual time=0.003..0.004 rows=6 loops=1)

87.          

SubPlan (forHash Left Join)

88. 0.000 0.000 ↑ 1.0 1 42,173

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=42,173)

89. 5.959 40.627 ↓ 1.0 41,420 1

Hash (cost=7,664.65..7,664.65 rows=41,405 width=16) (actual time=40.627..40.627 rows=41,420 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2495kB
90. 34.668 34.668 ↓ 1.0 41,420 1

Seq Scan on cof_titulo t (cost=0.00..7,664.65 rows=41,405 width=16) (actual time=0.019..34.668 rows=41,420 loops=1)

  • Filter: (isvalid = 'Y'::bpchar)
  • Rows Removed by Filter: 12072
91. 0.005 0.016 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=10) (actual time=0.016..0.016 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
92. 0.011 0.011 ↑ 1.0 17 1

Seq Scan on cof_c_bankintegration bai (cost=0.00..1.17 rows=17 width=10) (actual time=0.005..0.011 rows=17 loops=1)

93. 0.006 0.016 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=9) (actual time=0.016..0.016 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
94. 0.010 0.010 ↑ 1.0 25 1

Seq Scan on cof_c_custody cu (cost=0.00..1.25 rows=25 width=9) (actual time=0.006..0.010 rows=25 loops=1)

95. 0.570 0.570 ↑ 1.0 1 190

Index Scan using c_bpartner_pkey on c_bpartner bp (cost=0.29..0.31 rows=1 width=34) (actual time=0.003..0.003 rows=1 loops=190)

  • Index Cond: ("*SELECT* 1".c_bpartner_id = c_bpartner_id)
96. 0.172 0.381 ↑ 1.0 1,145 1

Hash (cost=44.45..44.45 rows=1,145 width=32) (actual time=0.381..0.381 rows=1,145 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 90kB
97. 0.209 0.209 ↑ 1.0 1,145 1

Seq Scan on c_elementvalue u1 (cost=0.00..44.45 rows=1,145 width=32) (actual time=0.007..0.209 rows=1,145 loops=1)

98. 0.004 0.010 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=19) (actual time=0.010..0.010 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
99. 0.006 0.006 ↑ 1.0 9 1

Seq Scan on c_activity ac (cost=0.00..1.09 rows=9 width=19) (actual time=0.005..0.006 rows=9 loops=1)

100. 0.027 0.057 ↑ 1.0 159 1

Hash (cost=5.59..5.59 rows=159 width=32) (actual time=0.057..0.057 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
101. 0.030 0.030 ↑ 1.0 159 1

Seq Scan on cof_c_planofinanceiro pf (cost=0.00..5.59 rows=159 width=32) (actual time=0.005..0.030 rows=159 loops=1)