explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GuC1

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 16,453.951 ↑ 1.0 1 1

Aggregate (cost=38,321.17..38,321.18 rows=1 width=40) (actual time=16,453.951..16,453.951 rows=1 loops=1)

2. 0.022 16,453.933 ↑ 5.2 38 1

Hash Join (cost=38,232.77..38,320.19 rows=196 width=48) (actual time=16,452.652..16,453.933 rows=38 loops=1)

  • Hash Cond: (oi.c_doctype_id = dt.c_doctype_id)
3. 0.071 16,453.872 ↑ 9.7 128 1

Subquery Scan on oi (cost=38,220.44..38,304.53 rows=1,246 width=64) (actual time=16,452.530..16,453.872 rows=128 loops=1)

  • Filter: (oi.daysdue > 0)
  • Rows Removed by Filter: 1196
4. 8.290 16,453.801 ↑ 2.8 1,324 1

HashAggregate (cost=38,220.44..38,257.81 rows=3,737 width=3,648) (actual time=16,452.508..16,453.801 rows=1,324 loops=1)

  • Group 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
5. 0.222 16,445.511 ↑ 2.8 1,324 1

Append (cost=71.14..37,174.08 rows=3,737 width=3,648) (actual time=40.876..16,445.511 rows=1,324 loops=1)

6. 0.010 59.862 ↑ 59.7 13 1

Subquery Scan on *SELECT* 1 (cost=71.14..11,792.10 rows=776 width=1,278) (actual time=40.875..59.862 rows=13 loops=1)

7. 15.344 59.852 ↑ 59.7 13 1

Nested Loop Left Join (cost=71.14..11,782.40 rows=776 width=1,274) (actual time=40.874..59.852 rows=13 loops=1)

  • Join Filter: (bpg.c_bp_group_id = bp.c_bp_group_id)
8. 0.009 44.508 ↑ 59.7 13 1

Nested Loop Left Join (cost=71.14..8,565.34 rows=776 width=826) (actual time=37.696..44.508 rows=13 loops=1)

  • Join Filter: (bp.c_bpartner_id = i.c_bpartner_id)
9. 0.011 44.486 ↑ 59.7 13 1

Hash Left Join (cost=70.85..8,551.19 rows=776 width=807) (actual time=37.687..44.486 rows=13 loops=1)

  • Hash Cond: (t.cof_c_bankoccurrence_id = bo.cof_c_bankoccurrence_id)
10. 0.012 44.419 ↑ 59.7 13 1

Hash Left Join (cost=63.54..8,541.80 rows=776 width=774) (actual time=37.628..44.419 rows=13 loops=1)

  • Hash Cond: (t.cof_c_bankintegration_id = bi.cof_c_bankintegration_id)
11. 0.010 44.394 ↑ 59.7 13 1

Nested Loop Left Join (cost=61.05..8,536.88 rows=776 width=747) (actual time=37.611..44.394 rows=13 loops=1)

12. 0.014 44.319 ↑ 59.7 13 1

Nested Loop Left Join (cost=60.63..6,295.67 rows=776 width=542) (actual time=37.601..44.319 rows=13 loops=1)

13. 0.018 44.292 ↑ 59.7 13 1

Hash Join (cost=60.34..5,042.79 rows=776 width=526) (actual time=37.597..44.292 rows=13 loops=1)

  • Hash Cond: (i.c_paymentterm_id = p.c_paymentterm_id)
14. 0.005 44.241 ↑ 59.7 13 1

Nested Loop Left Join (cost=55.68..5,035.98 rows=776 width=517) (actual time=37.556..44.241 rows=13 loops=1)

15. 0.013 44.184 ↑ 59.7 13 1

Nested Loop (cost=55.39..4,591.60 rows=776 width=517) (actual time=37.549..44.184 rows=13 loops=1)

16. 0.021 44.132 ↑ 59.7 13 1

Nested Loop (cost=55.10..4,352.48 rows=776 width=523) (actual time=37.530..44.132 rows=13 loops=1)

17. 0.008 44.072 ↑ 59.7 13 1

Nested Loop (cost=54.81..3,539.40 rows=776 width=517) (actual time=37.516..44.072 rows=13 loops=1)

18. 0.039 0.039 ↑ 1.0 1 1

Index Only Scan using c_bpartner_pkey on c_bpartner b (cost=0.29..1.41 rows=1 width=6) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: (c_bpartner_id = '5005922'::numeric)
  • Heap Fetches: 1
19. 0.023 44.025 ↑ 59.7 13 1

Hash Join (cost=54.52..3,530.24 rows=776 width=517) (actual time=37.475..44.025 rows=13 loops=1)

  • Hash Cond: (i.c_doctype_id = d.c_doctype_id)
20. 43.617 43.931 ↑ 59.7 13 1

Bitmap Heap Scan on c_invoice i (cost=39.80..3,513.43 rows=776 width=513) (actual time=37.400..43.931 rows=13 loops=1)

  • Recheck Cond: (c_bpartner_id = '5005922'::numeric)
  • Filter: ((ispayschedulevalid <> 'Y'::bpchar) AND (docstatus = ANY ('{CO,CL}'::bpchar[])) AND (docstatus = 'CO'::bpchar) AND (invoiceopen(c_invoice_id, '0'::numeric) <> '0'::numeric))
  • Rows Removed by Filter: 3039
  • Heap Blocks: exact=1499
21. 0.314 0.314 ↓ 1.1 3,072 1

Bitmap Index Scan on c_invoice_documentno_target (cost=0.00..39.61 rows=2,878 width=0) (actual time=0.314..0.314 rows=3,072 loops=1)

  • Index Cond: (c_bpartner_id = '5005922'::numeric)
22. 0.027 0.071 ↑ 1.0 210 1

Hash (cost=12.10..12.10 rows=210 width=10) (actual time=0.071..0.071 rows=210 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
23. 0.044 0.044 ↑ 1.0 210 1

Seq Scan on c_doctype d (cost=0.00..12.10 rows=210 width=10) (actual time=0.001..0.044 rows=210 loops=1)

24. 0.039 0.039 ↑ 1.0 1 13

Index Scan using c_bpartner_location_pkey on c_bpartner_location bpl (cost=0.29..1.05 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=13)

  • Index Cond: (c_bpartner_location_id = i.c_bpartner_location_id)
25. 0.039 0.039 ↑ 1.0 1 13

Index Only Scan using c_location_pkey on c_location loc (cost=0.29..0.31 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=13)

  • Index Cond: (c_location_id = bpl.c_location_id)
  • Heap Fetches: 0
26. 0.052 0.052 ↓ 0.0 0 13

Index Only Scan using idx_lbr_docfiscal_c_invoice_id on lbr_docfiscal df_1 (cost=0.29..0.56 rows=1 width=6) (actual time=0.004..0.004 rows=0 loops=13)

  • Index Cond: (c_invoice_id = i.c_invoice_id)
  • Heap Fetches: 0
27. 0.011 0.033 ↑ 1.0 74 1

Hash (cost=3.74..3.74 rows=74 width=15) (actual time=0.032..0.033 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
28. 0.022 0.022 ↑ 1.0 74 1

Seq Scan on c_paymentterm p (cost=0.00..3.74 rows=74 width=15) (actual time=0.003..0.022 rows=74 loops=1)

29. 0.013 0.013 ↓ 0.0 0 13

Index Scan using idx_lbr_docfiscal_c_invoice_id on lbr_docfiscal df (cost=0.29..1.60 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=13)

  • Index Cond: (c_invoice_id = i.c_invoice_id)
30. 0.065 0.065 ↓ 0.0 0 13

Index Scan using idx_cof_titulo_c_invoice_id_c_invoicepayschedule_id_isvalid on cof_titulo t (cost=0.42..2.88 rows=1 width=211) (actual time=0.005..0.005 rows=0 loops=13)

  • Index Cond: ((c_invoice_id = i.c_invoice_id) AND (isvalid = 'Y'::bpchar))
  • Filter: (COALESCE(c_invoicepayschedule_id, '0'::numeric) = '0'::numeric)
31. 0.004 0.013 ↑ 1.0 22 1

Hash (cost=2.22..2.22 rows=22 width=33) (actual time=0.013..0.013 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
32. 0.009 0.009 ↑ 1.0 22 1

Seq Scan on cof_c_bankintegration bi (cost=0.00..2.22 rows=22 width=33) (actual time=0.003..0.009 rows=22 loops=1)

33. 0.022 0.056 ↑ 1.0 147 1

Hash (cost=5.47..5.47 rows=147 width=40) (actual time=0.056..0.056 rows=147 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
34. 0.034 0.034 ↑ 1.0 147 1

Seq Scan on cof_c_bankoccurrence bo (cost=0.00..5.47 rows=147 width=40) (actual time=0.005..0.034 rows=147 loops=1)

35. 0.007 0.013 ↑ 1.0 1 13

Materialize (cost=0.29..2.51 rows=1 width=25) (actual time=0.001..0.001 rows=1 loops=13)

36. 0.006 0.006 ↑ 1.0 1 1

Index Scan using c_bpartner_pkey on c_bpartner bp (cost=0.29..2.51 rows=1 width=25) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (c_bpartner_id = '5005922'::numeric)
37. 0.000 0.000 ↑ 6.0 1 13

Materialize (cost=0.00..1.09 rows=6 width=6) (actual time=0.000..0.000 rows=1 loops=13)

38. 0.002 0.002 ↑ 6.0 1 1

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

39. 1.242 16,385.427 ↑ 2.3 1,311 1

Subquery Scan on *SELECT* 2 (cost=3,915.48..25,381.99 rows=2,961 width=1,205) (actual time=7,174.025..16,385.427 rows=1,311 loops=1)

40. 1,678.138 16,384.185 ↑ 2.3 1,311 1

Hash Left Join (cost=3,915.48..25,337.57 rows=2,961 width=1,177) (actual time=7,174.023..16,384.185 rows=1,311 loops=1)

  • Hash Cond: (bp_1.c_bp_group_id = bpg_1.c_bp_group_id)
41. 0.598 14,706.043 ↑ 2.3 1,311 1

Hash Left Join (cost=3,914.34..16,277.31 rows=2,961 width=859) (actual time=7,173.057..14,706.043 rows=1,311 loops=1)

  • Hash Cond: (t_1.cof_c_bankoccurrence_id = bo_1.cof_c_bankoccurrence_id)
42. 0.864 14,705.398 ↑ 2.3 1,311 1

Hash Left Join (cost=3,907.03..16,262.05 rows=2,961 width=826) (actual time=7,173.007..14,705.398 rows=1,311 loops=1)

  • Hash Cond: (t_1.cof_c_bankintegration_id = bi_1.cof_c_bankintegration_id)
43. 0.984 14,704.521 ↑ 2.3 1,311 1

Nested Loop Left Join (cost=3,904.54..16,250.28 rows=2,961 width=799) (actual time=7,172.990..14,704.521 rows=1,311 loops=1)

  • Join Filter: (t_1.c_invoice_id = i_1.c_invoice_id)
44. 2.958 14,699.604 ↑ 2.3 1,311 1

Nested Loop (cost=3,904.12..14,758.25 rows=2,961 width=594) (actual time=7,172.964..14,699.604 rows=1,311 loops=1)

45. 2.235 40.550 ↓ 1.5 2,876 1

Hash Left Join (cost=3,903.70..8,104.17 rows=1,964 width=546) (actual time=13.922..40.550 rows=2,876 loops=1)

  • Hash Cond: (i_1.c_bpartner_id = bp_1.c_bpartner_id)
46. 2.642 38.305 ↓ 1.5 2,876 1

Nested Loop Left Join (cost=3,901.18..8,074.64 rows=1,964 width=527) (actual time=13.902..38.305 rows=2,876 loops=1)

47. 3.217 32.787 ↓ 1.5 2,876 1

Nested Loop Left Join (cost=3,900.89..5,285.17 rows=1,964 width=511) (actual time=13.896..32.787 rows=2,876 loops=1)

48. 1.077 23.818 ↓ 1.5 2,876 1

Nested Loop (cost=3,900.60..4,441.60 rows=1,964 width=511) (actual time=13.888..23.818 rows=2,876 loops=1)

49. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using c_bpartner_pkey on c_bpartner b_1 (cost=0.29..1.41 rows=1 width=6) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (c_bpartner_id = '5005922'::numeric)
  • Heap Fetches: 1
50. 2.425 22.734 ↓ 1.5 2,876 1

Hash Join (cost=3,900.31..4,420.56 rows=1,964 width=511) (actual time=13.880..22.734 rows=2,876 loops=1)

  • Hash Cond: (i_1.c_doctype_id = d_1.c_doctype_id)
51. 5.667 20.241 ↓ 1.5 2,876 1

Hash Join (cost=3,885.59..4,400.58 rows=1,964 width=507) (actual time=13.807..20.241 rows=2,876 loops=1)

  • Hash Cond: (loc_1.c_location_id = bpl_1.c_location_id)
52. 1.779 1.779 ↓ 1.0 22,683 1

Index Only Scan using c_location_pkey on c_location loc_1 (cost=0.29..410.65 rows=22,664 width=6) (actual time=0.008..1.779 rows=22,683 loops=1)

  • Heap Fetches: 448
53. 1.798 12.795 ↓ 1.5 2,876 1

Hash (cost=3,860.75..3,860.75 rows=1,964 width=513) (actual time=12.795..12.795 rows=2,876 loops=1)

  • Buckets: 4096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1085kB
54. 1.414 10.997 ↓ 1.5 2,876 1

Hash Join (cost=1,108.66..3,860.75 rows=1,964 width=513) (actual time=7.251..10.997 rows=2,876 loops=1)

  • Hash Cond: (i_1.c_bpartner_location_id = bpl_1.c_bpartner_location_id)
55. 2.486 2.721 ↓ 1.5 2,876 1

Bitmap Heap Scan on c_invoice i_1 (cost=40.10..2,787.03 rows=1,964 width=507) (actual time=0.362..2.721 rows=2,876 loops=1)

  • Recheck Cond: (c_bpartner_id = '5005922'::numeric)
  • Filter: ((docstatus = ANY ('{CO,CL}'::bpchar[])) AND (ispayschedulevalid = 'Y'::bpchar) AND (docstatus = 'CO'::bpchar))
  • Rows Removed by Filter: 176
  • Heap Blocks: exact=1499
56. 0.235 0.235 ↓ 1.1 3,072 1

Bitmap Index Scan on c_invoice_documentno_target (cost=0.00..39.61 rows=2,878 width=0) (actual time=0.235..0.235 rows=3,072 loops=1)

  • Index Cond: (c_bpartner_id = '5005922'::numeric)
57. 3.060 6.862 ↑ 1.0 22,363 1

Hash (cost=788.25..788.25 rows=22,425 width=12) (actual time=6.862..6.862 rows=22,363 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1261kB
58. 3.802 3.802 ↑ 1.0 22,363 1

Seq Scan on c_bpartner_location bpl_1 (cost=0.00..788.25 rows=22,425 width=12) (actual time=0.003..3.802 rows=22,363 loops=1)

59. 0.027 0.068 ↑ 1.0 210 1

Hash (cost=12.10..12.10 rows=210 width=10) (actual time=0.068..0.068 rows=210 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
60. 0.041 0.041 ↑ 1.0 210 1

Seq Scan on c_doctype d_1 (cost=0.00..12.10 rows=210 width=10) (actual time=0.003..0.041 rows=210 loops=1)

61. 5.752 5.752 ↓ 0.0 0 2,876

Index Only Scan using idx_lbr_docfiscal_c_invoice_id on lbr_docfiscal df_3 (cost=0.29..0.42 rows=1 width=6) (actual time=0.002..0.002 rows=0 loops=2,876)

  • Index Cond: (c_invoice_id = i_1.c_invoice_id)
  • Heap Fetches: 0
62. 2.876 2.876 ↓ 0.0 0 2,876

Index Scan using idx_lbr_docfiscal_c_invoice_id on lbr_docfiscal df_2 (cost=0.29..1.41 rows=1 width=22) (actual time=0.001..0.001 rows=0 loops=2,876)

  • Index Cond: (c_invoice_id = i_1.c_invoice_id)
63. 0.003 0.010 ↑ 1.0 1 1

Hash (cost=2.51..2.51 rows=1 width=25) (actual time=0.010..0.010 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
64. 0.007 0.007 ↑ 1.0 1 1

Index Scan using c_bpartner_pkey on c_bpartner bp_1 (cost=0.29..2.51 rows=1 width=25) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (c_bpartner_id = '5005922'::numeric)
65. 14,656.096 14,656.096 ↓ 0.0 0 2,876

Index Scan using idx_c_invoicepayschedule_c_invoice_id_c_invoicepayschedule_id on c_invoicepayschedule ips (cost=0.42..3.36 rows=3 width=54) (actual time=5.005..5.096 rows=0 loops=2,876)

  • Index Cond: (c_invoice_id = i_1.c_invoice_id)
  • Filter: ((isvalid = 'Y'::bpchar) AND (invoiceopen(i_1.c_invoice_id, c_invoicepayschedule_id) <> '0'::numeric))
  • Rows Removed by Filter: 2
66. 3.933 3.933 ↓ 0.0 0 1,311

Index Scan using idx_cof_titulo_c_invoicepayschedule_id_isvalid on cof_titulo t_1 (cost=0.42..0.49 rows=1 width=217) (actual time=0.003..0.003 rows=0 loops=1,311)

  • Index Cond: ((c_invoicepayschedule_id = ips.c_invoicepayschedule_id) AND (isvalid = 'Y'::bpchar))
67. 0.005 0.013 ↑ 1.0 22 1

Hash (cost=2.22..2.22 rows=22 width=33) (actual time=0.013..0.013 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
68. 0.008 0.008 ↑ 1.0 22 1

Seq Scan on cof_c_bankintegration bi_1 (cost=0.00..2.22 rows=22 width=33) (actual time=0.004..0.008 rows=22 loops=1)

69. 0.023 0.047 ↑ 1.0 147 1

Hash (cost=5.47..5.47 rows=147 width=40) (actual time=0.047..0.047 rows=147 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
70. 0.024 0.024 ↑ 1.0 147 1

Seq Scan on cof_c_bankoccurrence bo_1 (cost=0.00..5.47 rows=147 width=40) (actual time=0.003..0.024 rows=147 loops=1)

71. 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
72. 0.003 0.003 ↑ 1.0 6 1

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

73.          

SubPlan (for Hash Left Join)

74. 0.000 0.000 ↑ 1.0 1 1,311

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

75. 0.007 0.039 ↑ 1.0 33 1

Hash (cost=11.91..11.91 rows=33 width=6) (actual time=0.039..0.039 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
76. 0.017 0.032 ↑ 1.0 33 1

Bitmap Heap Scan on c_doctype dt (cost=1.50..11.91 rows=33 width=6) (actual time=0.018..0.032 rows=33 loops=1)

  • Recheck Cond: (docbasetype = 'ARI'::bpchar)
  • Heap Blocks: exact=8
77. 0.015 0.015 ↑ 1.0 33 1

Bitmap Index Scan on idx_c_doctype_docbasetype_lbr_hasopenitems_ad_org_id_ad_client_ (cost=0.00..1.49 rows=33 width=0) (actual time=0.015..0.015 rows=33 loops=1)

  • Index Cond: (docbasetype = 'ARI'::bpchar)
Planning time : 7.458 ms
Execution time : 16,454.813 ms