Postgres profile report (StartID: 356, EndID: 379)

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-14 04:00:02+02 - 2026-07-15 03:00:01+02

Warning!Report includes 23 sample(s) with setting pg_stat_statements.track = all.Value of %Total columns may be incorrect.

Report sections

Server statistics

Database statistics

DatabaseTransactionsBlock statisticsTuplesTemp filesSizeGrowth
CommitsRollbacksDeadlocksHit(%)ReadHitRetFetInsUpdDelSizeFiles
openbravo1668311196100.005815734452844922014402511141749375524786310538716119650 GB1715947621 GB111 MB
postgres1173999.994266395619060983503506327 kB
Total1785701196100.005819934459484482016308609141784410524786310538716119650 GB1715947621 GB111 MB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
openbravo5793946418459.2912.603592470465426848391417732313962723960
postgres564111.2289892365
template163486.157176276
Total5795145318476.6512.603592567533426848391417732313962724601

Cluster statistics

MetricValue
Scheduled checkpoints276
Requested checkpoints
Checkpoint write time (s)28600.33
Checkpoint sync time (s)5.78
Checkpoints buffers written346565
Background buffers written
Backend buffers written15131
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated58166
WAL generated2250 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default21 GB111 MB
pg_global814 kB48 kB

SQL query statistics

Top SQL by execution time

Query IDDatabaseExec (s)%TotalRowsExecution times (ms)Executions
MeanMinMaxStdErr

29bf42b1ab

[7d43ad7e]

openbravo8795.0147.60132324261099375.9441096047.6071103787.4402617.3568

4af3e2b8c4

[26c6f357]

openbravo5599.1430.30633580699892.309687870.279711795.2117259.0258

d11440f550

[dfbf0ec0]

openbravo748.074.05413721.751108.6856468.6811831.243201

3f546d3e2b

[a0643fcb]

openbravo470.102.54783553058762.46957257.23961415.3641176.6358

2841013087

[dab326f6]

openbravo206.821.12570165925852.38220690.07333386.8323833.2828

fe2c4fe6df

[4c390f69]

openbravo205.601.11510896525700.26620481.81631236.2713803.3958

c5df179779

[2870663b]

openbravo178.840.97138660060.0130.0064.5040.00513866006

b52b0c82ea

[4f5926de]

openbravo127.930.69270970215990.99113079.03117676.5201614.7358

08db126a91

[b0ebb687]

openbravo104.910.57302089613113.42811911.90314339.302853.2158

a3d3811d66

[3933d71e]

openbravo88.010.481475368.26315.31312779.3111423.857239

d51f6611c2

[1c821f88]

openbravo83.800.45151055.4975.7825996.897272.2391510

f0238ffe1b

[806faf8c]

openbravo77.000.4258951476996.59876996.59876996.5981

018c5dd71e

[eb509fc7]

openbravo75.480.4127096549435.0169164.7899749.679209.1778

0b24cb5d2f

[738f9776]

openbravo74.730.4058431774729.72974729.72974729.7291

61aed5765c

[9c0a6d60]

openbravo65.190.357321975.4761931.0472058.33731.19633

e0fba79faa

[86dd33b4]

openbravo59.080.32138660060.0040.0034.1970.00213866006

3a2c9ad99b

[3373e588]

openbravo58.640.32239502094.2882075.5162196.55921.72428

d3dcdac298

[ce4e88c2]

openbravo56.270.30136632850.0040.0033.8580.00213663285

905bffc89c

[92975a8e]

openbravo47.400.26232061.0461158.10311084.4231953.64723

382d19fc6d

[40fd3671]

openbravo47.400.262060.7921157.75711084.2331953.66523

Top SQL by executions

Query IDDatabaseExecutions%TotalRowsMean(ms)Min(ms)Max(ms)StdErr(ms)Elapsed(s)

c5df179779

[2870663b]

openbravo1386600623.93138660060.0130.0064.5040.005178.8

e0fba79faa

[86dd33b4]

openbravo1386600623.93138660060.0040.0034.1970.00259.1

75c88383e3

[196c6f74]

openbravo1386600623.93138660060.0030.0021.6910.00136.6

d3dcdac298

[ce4e88c2]

openbravo1366328523.58136632850.0040.0033.8580.00256.3

19825253ef

[cf182c3a]

openbravo3376640.5885950.0260.0078.1490.0538.7

74a1d87233

[3cb4d968]

openbravo1223070.211223070.0030.0020.1440.0020.4

8e8235137e

[b19ed954]

openbravo1000060.171000060.0090.0035.7980.0260.9

5f8e9d0065

[8e21a910]

openbravo964970.17964970.0080.0022.2250.0090.7

93a759b1da

[6f9b1a85]

openbravo786490.140.0020.0000.4700.0030.1

9455753479

[2049516b]

openbravo775040.130.0010.0000.4470.0020.1

0483033486

[2e63909b]

openbravo757550.13153660.0050.0030.9000.0050.4

d1e21ddf3e

[c78d8d00]

openbravo653530.11653530.3150.03015.6300.18020.6

37386bc419

[e35d0938]

openbravo609620.11609620.5290.15516.4860.32232.2

bb4767275d

[c28fb106]

openbravo609620.11609620.0040.0020.1780.0020.2

4afd055f76

[db96914]

openbravo544440.09544440.0010.0010.0190.0000.1

41ed5172b0

[cc474ce1]

openbravo544440.09544440.0010.0010.0190.0000.0

ebe11b089e

[710731c2]

openbravo451000.08451000.4750.2044.9130.17821.4

2e2f56a414

[9abf1353]

openbravo451000.08451000.4580.1854.8820.17920.6

caede7e47b

[3051ec96]

openbravo450020.08450020.2520.108221.5562.16211.3

c8a950bd0d

[2d3f6bad]

openbravo383040.07383040.0180.0150.3140.0040.7

Top SQL by shared blocks fetched

Query IDDatabaseblks fetched%TotalHits(%)Elapsed(s)RowsExecutions

4af3e2b8c4

[26c6f357]

openbravo253210647070.48100.005599.16335808

3f546d3e2b

[a0643fcb]

openbravo1888513185.26100.00470.178355308

d11440f550

[dfbf0ec0]

openbravo1593981794.44100.00748.141201

29bf42b1ab

[7d43ad7e]

openbravo1223420543.41100.008795.0132324268

2841013087

[dab326f6]

openbravo757606682.11100.00206.857016598

b52b0c82ea

[4f5926de]

openbravo490235471.36100.00127.927097028

08db126a91

[b0ebb687]

openbravo476992231.33100.00104.930208968

c5df179779

[2870663b]

openbravo416064281.16100.00178.81386600613866006

d51f6611c2

[1c821f88]

openbravo304903010.85100.0083.815101510

d3dcdac298

[ce4e88c2]

openbravo273349800.76100.0056.31366328513663285

018c5dd71e

[eb509fc7]

openbravo273073750.76100.0075.527096548

a3d3811d66

[3933d71e]

openbravo242499830.68100.0088.01475239

61aed5765c

[9c0a6d60]

openbravo232909060.65100.0065.273233

fe2c4fe6df

[4c390f69]

openbravo218489560.61100.00205.651089658

133291c890

[be089ba]

openbravo164338880.46100.0033.86

a89f0eb5f9

[84642cf4]

openbravo140745910.39100.0032.848201

75c88383e3

[196c6f74]

openbravo138660060.39100.0036.61386600613866006

e0fba79faa

[86dd33b4]

openbravo138660060.39100.0059.11386600613866006

0a9b2d6035

[68af0d51]

openbravo110803490.31100.0020.86

3ad5b7fed4

[3bd25d52]

openbravo104225510.29100.0012.5303081751

Top SQL by shared blocks read

Query IDDatabaseReads%TotalHits(%)Elapsed(s)RowsExecutions

caede7e47b

[3051ec96]

openbravo46336.6799.6211.34500245002

f3f57fdf42

[4ae26da8]

openbravo35095.0599.024.166

a874297fd2

[67d29389]

openbravo35095.0599.024.166

cee3b65d37

[adb7202f]

openbravo33704.8599.9313.12

d94df8c714

[c5313281]

openbravo30424.3899.581.72

181fd1b092

[b76c5e2]

openbravo27814.0095.471.315021502

017d00aa12

[a852adf9]

openbravo21183.0596.950.8142028

8cb37f78ee

[e2543c48]

openbravo20863.0098.932.414111411

4f42690015

[38c3f6e1]

openbravo20762.9998.631.3142028

2d19e5b311

[b34f1d1f]

openbravo17392.5094.741.4844844

604436a476

[3afdf1db]

openbravo16522.3898.280.823012301

68de33d5d7

[ca50d0e4]

openbravo15772.2797.550.8870870

70caf7bb1e

[f7c054b4]

openbravo15252.2095.210.9843843

c5a2827c73

[60a12c3a]

openbravo14982.1698.550.72222

66bc870e45

[d37bd6d7]

openbravo12771.8496.890.7747747

616a44c111

[97aab45d]

openbravo12281.7795.530.9776776

3ff50f5232

[e81c3c12]

openbravo11551.6694.860.8791791

8d633ecaab

[ee4ba68d]

openbravo11491.6596.980.5760760

d1c0672c81

[a1b7c5f]

openbravo10961.5898.951.612011201

6b67fe6923

[5d2e4e6c]

openbravo10591.5298.911.212011201

Top SQL by shared blocks dirtied

Query IDDatabaseDirtied%TotalHits(%)Elapsed(s)RowsExecutions

caede7e47b

[3051ec96]

openbravo10369224.2999.6211.34500245002

382d19fc6d

[40fd3671]

openbravo187904.40100.0047.423

905bffc89c

[92975a8e]

openbravo187904.40100.0047.42323

f3f57fdf42

[4ae26da8]

openbravo97462.2899.024.166

a874297fd2

[67d29389]

openbravo97462.2899.024.166

8cb37f78ee

[e2543c48]

openbravo82611.9498.932.414111411

50e85a5d5e

[fed47e50]

openbravo78481.8499.987.213771377

4f42690015

[38c3f6e1]

openbravo77721.8298.631.3142028

528c231cbe

[b1de800e]

openbravo73921.7399.780.941134113

48f140c821

[edb3cd2d]

openbravo61811.4599.840.5135426

f398687456

[f1896355]

openbravo60201.4199.700.9432432

313b1ecda9

[978c2f22]

openbravo55601.3099.722.550345034

fe62dd3708

[fcea205c]

openbravo54261.2799.210.611871187

24f0f61153

[84a8bcfc]

openbravo51701.2198.801.0742742

6b67fe6923

[5d2e4e6c]

openbravo51451.2198.911.212011201

d1c0672c81

[a1b7c5f]

openbravo50211.1898.951.612011201

604436a476

[3afdf1db]

openbravo45571.0798.280.823012301

2d19e5b311

[b34f1d1f]

openbravo45571.0794.741.4844844

181fd1b092

[b76c5e2]

openbravo42611.0095.471.315021502

4f9621bcb7

[ddcc675a]

openbravo41770.9899.370.8273273

Top SQL by shared blocks written

No data in this section

Top SQL by temp usage

Query IDDatabaseLocal fetchedHits(%)Local (blk)Temp (blk)Elapsed(s)RowsExecutions
Write%TotalRead%TotalWrite%TotalRead%Total

29bf42b1ab

[7d43ad7e]

openbravo1777277476.813492688289.238795.0132324268

d11440f550

[dfbf0ec0]

openbravo339336414.6622829455.83748.141201

2841013087

[dab326f6]

openbravo11318834.8911325072.89206.857016598

3a2c9ad99b

[3373e588]

openbravo2581911.122583590.6658.62395028

7e35c14916

[be51200d]

openbravo2434281.052433440.6239.0162484

fe2c4fe6df

[4c390f69]

openbravo1593970.691594930.41205.651089658

102454699d

[1596f0d4]

openbravo1004040.43580530.1519.41203

fb45d4a61f

[61e8ee09]

openbravo704810.30704790.1823.7502

d3457bdce0

[25bcd965]

openbravo97050.0497110.024.28481

Complete list of SQL texts

QueryIDQuery Text
d1c0672c81insert into M_InOutLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Line, Description, M_InOut_ID, C_OrderLine_ID, M_Locator_ID, M_Product_ID, C_UOM_ID, MovementQty, IsInvoiced, M_AttributeSetInstance_ID, IsDescription, Manage_Prereservation, C_Bpartner_ID, Explode, EM_Obwpl_Editlines_Pe, EM_Obwpl_Removeline, Salesrep_ID, EM_Prpp_Qtyverified, EM_Pruti_Voidlines, EM_Pruti_Isvoid, M_InOutLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28)
181fd1b092insert into C_OrderLineTax (C_Orderline_ID, C_Tax_ID, AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Taxbaseamt, Taxamt, Line, C_Order_ID, C_Orderlinetax_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)
133291c890SELECT * FROM (select bp.c_bpartner_id AS REFERENCEKEY_ID, $2 AS AD_ROLE_ID, $3 AS AD_USER_ID, $4 || AD_COLUMN_IDENTIFIER($5, bp.C_BPARTNER_ID, $6) || $7 AS DESCRIPTION, $8 AS ISACTIVE, bp.AD_ORG_ID AS AD_ORG_ID, bp.AD_CLIENT_ID AS AD_CLIENT_ID, now() AS CREATED, $9 AS CREATEDBY, now() AS UPDATED, $10 AS UPDATEDBY, AD_COLUMN_IDENTIFIER($11, bp.C_BPARTNER_ID, $12) AS RECORD_ID from c_bpartner bp where not exists (select $13 from c_bpartner_location bpl0 where bpl0.c_bpartner_id = bp.c_bpartner_id and bpl0.istaxlocation = $14 ) and exists (select $15 from c_bpartner_location bpl inner join c_location l on (bpl.c_location_id = l.c_location_id) where bpl.c_bpartner_id = bp.c_bpartner_id group by bpl.c_bpartner_id having count(distinct(l.c_country_id)) > $16 )) AAA where not exists (select $17 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $18) != $19)
4afd055f76SELECT CASE WHEN $2.typtype = $3 THEN $2.typbasetype ELSE $1.atttypid END
102454699dselect businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL as col_0_0_, businesspa0_.EM_Gcnv_Uniquecreditnote as col_1_0_, businesspa0_.C_BPartner_ID as col_2_0_, businesspa0_.AD_Org_ID as col_3_0_, businesspa0_.Name as col_4_0_, businesspa0_.Name as col_5_0_, businesspa0_.Value as col_6_0_, businesspa0_.Description as col_7_0_, businesspa0_.TaxID as col_8_0_, businesspa0_.SO_Bp_Taxcategory_ID as col_9_0_, businesspa0_.M_PriceList_ID as col_10_0_, businesspa0_.FIN_Paymentmethod_ID as col_11_0_, businesspa0_.C_PaymentTerm_ID as col_12_0_, businesspa0_.InvoiceRule as col_13_0_, aduserlist4_.Email as col_14_0_, aduserlist4_.AD_User_ID as col_15_0_, aduserlist4_.Phone as col_16_0_, aduserlist4_.Phone2 as col_17_0_, coalesce(aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) as col_18_0_, aduserlist4_.Lastname as col_19_0_, pricingpri1_.IsTaxIncluded as col_20_0_, pricingpri1_.C_Currency_ID as col_21_0_, pricingpri1_.Name as col_22_0_, businesspa0_.C_BP_Group_ID as col_23_0_, businesspa5_.Name as col_24_0_, businesspa0_.SO_CreditLimit as col_25_0_, businesspa0_.SO_CreditUsed as col_26_0_, businesspa0_.IsTaxExempt as col_27_0_, businesspa0_.Customer_Blocking as col_28_0_, businesspa0_.SO_Order_Blocking as col_29_0_, businesspa0_.Birthday as col_30_0_, businesspa0_.Birthplace as col_31_0_, businesspa0_.IsActive as col_32_0_, businesspa0_.Is_Customer_Consent as col_33_0_, businesspa0_.Is_Customer_Consent_PapFormat as col_34_0_, adlanguage2_.AD_Language as col_35_0_, adlanguage2_.Name as col_36_0_, greeting3_.C_Greeting_ID as col_37_0_, greeting3_.Name as col_38_0_, aduserlist4_.Comments as col_39_0_, businesspa0_.SO_CreditLimit-businesspa0_.SO_CreditUsed as col_40_0_, aduserlist4_.Commercialauth as col_41_0_, aduserlist4_.Viaemail as col_42_0_, aduserlist4_.Viasms as col_43_0_, businesspa0_.business_partner_type as col_44_0_, businesspa0_.BP_Currency_ID as col_45_0_, businesspa0_.SO_Creditminamt as col_46_0_, now() as col_47_0_ from C_BPartner businesspa0_ inner join M_PriceList pricingpri1_ on businesspa0_.M_PriceList_ID=pricingpri1_.M_PriceList_ID left outer join AD_Language adlanguage2_ on businesspa0_.AD_Language=adlanguage2_.AD_Language left outer join C_Greeting greeting3_ on businesspa0_.C_Greeting_ID=greeting3_.C_Greeting_ID left outer join AD_User aduserlist4_ on businesspa0_.C_BPartner_ID=aduserlist4_.C_BPartner_ID cross join C_BP_Group businesspa5_ where businesspa0_.C_BP_Group_ID=businesspa5_.C_BP_Group_ID and $8=$9 and businesspa0_.IsCustomer=$10 and (businesspa0_.AD_Client_ID in ($11 , $12)) and (businesspa0_.AD_Org_ID in ($1 , $2 , $3 , $4 , $5 , $6)) and businesspa0_.IsActive=$13 and (aduserlist4_.AD_User_ID in (select aduser6_.AD_User_ID from AD_User aduser6_ where aduser6_.EM_OBRETCO_Default_Pos_Contact=$14 and aduser6_.C_BPartner_ID=businesspa0_.C_BPartner_ID)) and $15=$16 group by businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL , businesspa0_.EM_Gcnv_Uniquecreditnote , businesspa0_.C_BPartner_ID , businesspa0_.AD_Org_ID , businesspa0_.Name , businesspa0_.Name , businesspa0_.Value , businesspa0_.Description , businesspa0_.TaxID , businesspa0_.SO_Bp_Taxcategory_ID , businesspa0_.M_PriceList_ID , businesspa0_.FIN_Paymentmethod_ID , businesspa0_.C_PaymentTerm_ID , businesspa0_.InvoiceRule , aduserlist4_.Email , aduserlist4_.AD_User_ID , aduserlist4_.Phone , aduserlist4_.Phone2 , coalesce(aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) , aduserlist4_.Lastname , pricingpri1_.IsTaxIncluded , pricingpri1_.C_Currency_ID , pricingpri1_.Name , businesspa0_.C_BP_Group_ID , businesspa5_.Name , businesspa0_.SO_CreditLimit , businesspa0_.SO_CreditUsed , businesspa0_.IsTaxExempt , businesspa0_.Customer_Blocking , businesspa0_.SO_Order_Blocking , businesspa0_.Birthday , businesspa0_.Birthplace , businesspa0_.IsActive , businesspa0_.Is_Customer_Consent , businesspa0_.Is_Customer_Consent_PapFormat , adlanguage2_.AD_Language , adlanguage2_.Name , greeting3_.C_Greeting_ID , greeting3_.Name , aduserlist4_.Comments , businesspa0_.SO_CreditLimit-businesspa0_.SO_CreditUsed , aduserlist4_.Commercialauth , aduserlist4_.Viaemail , aduserlist4_.Viasms , businesspa0_.business_partner_type , businesspa0_.BP_Currency_ID , businesspa0_.SO_Creditminamt , now() having $17=$18 order by businesspa0_.C_BPartner_ID limit $7
75c88383e3SELECT COUNT(*) FROM M_COSTING WHERE p_MovementDate BETWEEN DATEFROM AND DATETO AND M_PRODUCT_ID = p_Product_ID AND costtype NOT IN ($8 , $9) AND(v_CostType IS NULL OR v_CostType = COSTTYPE)
d51f6611c2SELECT row_to_json(f) FROM ( SELECT prod.m_product_id as id, ad_column_identifier_std($7, prod.m_product_id) as identifier, CASE WHEN prod.isgeneric = $8 THEN $9 ELSE $10 END as "isGeneric", concat(prod.value, $11, prod.name) as name, $12 as show, cast(retstk_basic_json($13, prod.m_brand_id) as json) as brand, cast(retstk_basic_json($14, prod.m_product_category_id) as json) as "productCategory", (CASE WHEN prod.isgeneric = $15 AND (SELECT count($16) FROM m_product_ch pch LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pch.m_characteristic_id WHERE pch.m_product_id = p_product_id AND ch.em_retstk_horizontal_axis = $17 AND EXISTS (SELECT $18 FROM m_product bprod WHERE bprod.generic_product_id = prod.m_product_id) ) > $19 THEN ( SELECT array_to_json(array_agg(row_to_json(d))) FROM ( SELECT chv.m_ch_value_id as id, chv.name as identifier, chv.skcode as label_skcode, chv.name as label_name, cast(retstk_basic_json($20, chv.m_characteristic_id) as json) as characteristic FROM m_product_ch_value pchv LEFT JOIN m_ch_value chv ON chv.m_ch_value_id = pchv.m_ch_value_id LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = chv.m_characteristic_id WHERE pchv.m_product_id IN (SELECT m_product_id FROM m_product WHERE generic_product_id = p_product_id) AND ch.em_retstk_horizontal_axis = $21 GROUP BY chv.m_ch_value_id ORDER BY coalesce(chv.em_retstk_seqno, $22) asc, chv.name asc ) d ) ELSE ( SELECT array_to_json(array_agg(row_to_json(d))) FROM (SELECT $23 as id, $24 as label_skcode, $25 as label_name FROM dual) d ) END) as "horizontalValues", (CASE WHEN prod.isgeneric = $26 AND (SELECT count($27) FROM m_product_ch pch LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pch.m_characteristic_id WHERE pch.m_product_id = prod.m_product_id AND ch.em_retstk_horizontal_axis != $28 AND CASE WHEN v_hideVariantCh = $29 THEN pch.isvariant = $30 ELSE $31=$32 END) > $33 THEN ( SELECT array_to_json(array_agg(row_to_json(vv))) FROM ( SELECT v.id as id, p_product_id as "genericId", v.description as description, (SELECT array_to_json(array_agg(row_to_json(d))) FROM ( SELECT m_ch_value_id as id, name as identifier, skcode as label_skcode, name as label_name, cast(retstk_basic_json($34, m_characteristic_id) as json) as characteristic FROM m_ch_value WHERE m_ch_value_id = ANY (string_to_array(variantcombinations,$35)) ORDER BY m_ch_value_id ) d) as values, (SELECT array_to_json(array_agg(row_to_json(s))) FROM ( SELECT ( SELECT row_to_json(f) FROM (SELECT m_warehouse.m_warehouse_id as id, m_warehouse.name as identifier, coalesce(m_warehouse.em_retstk_htmlcolor, $36) as "htmlColor", $37 as "show" FROM m_warehouse WHERE m_warehouse.m_warehouse_id = stk.m_warehouse_id ) as f) as warehouse, stk.stock FROM ( SELECT r.m_warehouse_id, array_to_json(array_agg(row_to_json(r))) as stock FROM ( SELECT wh.m_warehouse_id, CASE WHEN (SELECT count($38) FROM m_product_ch pch LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pch.m_characteristic_id WHERE pch.m_product_id = p_product_id AND ch.em_retstk_horizontal_axis = $39 ) > $40 THEN pchv.m_ch_value_id ELSE $41 END as size, sum(qtyonhand) as qtyonhand, sum(preqtyonhand) as preqtyonhand, coalesce((SELECT sum(ol.qtyordered - ol.qtydelivered) FROM c_orderline ol LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id WHERE o.issotrx = $42 AND o.docstatus = $43 AND o.m_warehouse_id = wh.m_warehouse_id AND ol.m_product_id = p_product_id),$44)+ sum((case when mi.available = $45 then qtyonhand else $46 end)) as qtypending FROM m_storage_detail sd LEFT JOIN m_locator bin ON bin.m_locator_id = sd.m_locator_id LEFT JOIN m_inventorystatus mi ON mi.m_inventorystatus_id=bin.m_inventorystatus_id LEFT JOIN m_warehouse wh ON wh.m_warehouse_id = bin.m_warehouse_id LEFT JOIN m_product p ON p.m_product_id = sd.m_product_id LEFT JOIN m_product_ch_value pchv ON p.m_product_id = pchv.m_product_id LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pchv.m_characteristic_id WHERE wh.em_retstk_breakbylocator=$47 AND EXISTS (SELECT $48 FROM m_product WHERE m_product_id = sd.m_product_id AND generic_product_id = p_product_id) AND (SELECT count($49) FROM m_product_ch_value WHERE m_product_id = sd.m_product_id AND m_ch_value_id = ANY (string_to_array(variantcombinations,$50))) = array_length(string_to_array(variantcombinations,$51), $52) AND CASE WHEN (SELECT count($53) FROM m_product_ch pch LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pch.m_characteristic_id WHERE pch.m_product_id = p_product_id AND ch.em_retstk_horizontal_axis = $54 ) > $55 THEN ch.em_retstk_horizontal_axis = $56 ELSE $57 = $58 END AND wh.m_warehouse_id IN ( SELECT wh.m_warehouse_id FROM m_warehouse wh WHERE CASE WHEN coalesce((SELECT em_retstk_org_filters FROM ad_org WHERE ad_org_id = p_org_id), $59) = $60 THEN EXISTS (SELECT $61 FROM retstk_org_warehouse WHERE m_warehouse_id = wh.m_warehouse_id AND ad_org_id = p_org_id) ELSE NOT EXISTS (SELECT $62 FROM retstk_org_warehouse WHERE m_warehouse_id = wh.m_warehouse_id AND ad_org_id = p_org_id) AND ad_client_id = p_client_id END ) GROUP BY wh.m_warehouse_id, pchv.m_ch_value_id) as r GROUP BY r.m_warehouse_id ) as stk ) as s) as stock, ( SELECT array_to_json(array_agg(row_to_json(var))) FROM ( SELECT p.m_product_id as productid, $63 as productimg FROM m_product p WHERE p.generic_product_id = p_product_id ) as var ) as variantsproducts FROM ( SELECT replace(variantcombinations,$64,$65) as id, variantcombinations, (SELECT string_agg(m_ch_value.name, $66 ORDER BY m_characteristic.name ASC) FROM m_ch_value JOIN m_characteristic ON m_characteristic.m_characteristic_id=m_ch_value.m_characteristic_id WHERE m_ch_value_id = ANY (string_to_array(variantcombinations,$67))) as description FROM (SELECT p.m_product_id, string_agg(chval.m_ch_value_id, $68 ORDER BY chval.m_ch_value_id) AS variantcombinations FROM m_product_ch_value chval LEFT JOIN m_product p ON chval.m_product_id = p.m_product_id LEFT JOIN m_product_ch pch ON chval.m_product_id = pch.m_product_id AND pch.m_characteristic_id = chval.m_characteristic_id WHERE p.generic_product_id = p_product_id AND p.isactive = $69 AND chval.m_characteristic_id NOT IN (SELECT m_characteristic_id FROM m_characteristic WHERE em_retstk_horizontal_axis = $70) AND CASE WHEN v_hideVariantCh = $71 THEN pch.isvariant = $72 ELSE $73=$74 END GROUP BY p.m_product_id ) AS principal GROUP BY variantcombinations ) as v ) As vv ) WHEN prod.isgeneric = $75 THEN (SELECT array_to_json(array_agg(row_to_json(vv))) FROM ( SELECT v.id as id, p_product_id as "genericId", v.description as description, (SELECT array_to_json(array_agg(row_to_json(d))) FROM ( SELECT m_ch_value_id as id, name as identifier, skcode as label_skcode, name as label_name, cast(retstk_basic_json($76, m_characteristic_id) as json) as characteristic FROM m_ch_value WHERE m_ch_value_id = ANY (string_to_array(variantcombinations,$77)) ORDER BY m_ch_value_id ) d) as values, (SELECT array_to_json(array_agg(row_to_json(s))) FROM ( SELECT ( SELECT row_to_json(f) FROM (SELECT m_warehouse.m_warehouse_id as id, m_warehouse.name as identifier, coalesce(m_warehouse.em_retstk_htmlcolor, $78) as "htmlColor", $79 as "show" FROM m_warehouse WHERE m_warehouse.m_warehouse_id = stk.m_warehouse_id ) as f) as warehouse, stk.stock FROM ( SELECT r.m_warehouse_id, array_to_json(array_agg(row_to_json(r))) as stock FROM ( SELECT wh.m_warehouse_id, CASE WHEN (SELECT count($80) FROM m_product_ch pch LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pch.m_characteristic_id WHERE pch.m_product_id = p_product_id AND ch.em_retstk_horizontal_axis = $81 ) > $82 THEN pchv.m_ch_value_id ELSE $83 END as size, sum(qtyonhand) as qtyonhand, sum(preqtyonhand) as preqtyonhand, greatest(coalesce((SELECT sum(ol.qtyordered - ol.qtydelivered) FROM c_orderline ol LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id WHERE o.issotrx = $84 AND o.docstatus = $85 AND o.m_warehouse_id = wh.m_warehouse_id AND ol.m_product_id = ANY (string_to_array(string_agg(sd.m_product_id, $86), $87))),$88),$89)+ sum((case when mi.available = $90 then qtyonhand else $91 end)) as qtypending FROM m_storage_detail sd LEFT JOIN m_locator bin ON bin.m_locator_id = sd.m_locator_id LEFT JOIN m_inventorystatus mi ON mi.m_inventorystatus_id=bin.m_inventorystatus_id LEFT JOIN m_warehouse wh ON wh.m_warehouse_id = bin.m_warehouse_id LEFT JOIN m_product p ON p.m_product_id = sd.m_product_id LEFT JOIN m_product_ch_value pchv ON p.m_product_id = pchv.m_product_id LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pchv.m_characteristic_id WHERE wh.em_retstk_breakbylocator=$92 AND EXISTS (SELECT $93 FROM m_product WHERE m_product_id = sd.m_product_id AND generic_product_id = p_product_id) --AND (SELECT count(1) FROM m_product_ch_value WHERE m_product_id = sd.m_product_id AND m_ch_value_id = ANY (string_to_array(variantcombinations,'/'))) = array_length(string_to_array(variantcombinations,'/'), 1) AND CASE WHEN (SELECT count($94) FROM m_product_ch pch LEFT JOIN m_characteristic ch ON ch.m_characteristic_id = pch.m_characteristic_id WHERE pch.m_product_id = p_product_id AND ch.em_retstk_horizontal_axis = $95 ) > $96 THEN ch.em_retstk_horizontal_axis = $97 ELSE $98 = $99 END AND wh.m_warehouse_id IN ( SELECT wh.m_warehouse_id FROM m_warehouse wh WHERE CASE WHEN coalesce((SELECT em_retstk_org_filters FROM ad_org WHERE ad_org_id = p_org_id), $100) = $101 THEN EXISTS (SELECT $102 FROM retstk_org_warehouse WHERE m_warehouse_id = wh.m_warehouse_id AND ad_org_id = p_org_id) ELSE NOT EXISTS (SELECT $103 FROM retstk_org_warehouse WHERE m_warehouse_id = wh.m_warehouse_id AND ad_org_id = p_org_id) AND ad_client_id = p_client_id END ) GROUP BY wh.m_warehouse_id, pchv.m_ch_value_id) as r GROUP BY r.m_warehouse_id ) as stk ) as s) as stock, ( SELECT array_to_json(array_agg(row_to_json(var))) FROM ( SELECT p.m_product_id as productid, $104 as productimg FROM m_product p WHERE p.generic_product_id = p_product_id ) as var ) as variantsproducts FROM ( SELECT replace(variantcombinations,$105,$106) as id, variantcombinations, $107 as description FROM (SELECT p.generic_product_id, string_agg(chval.m_ch_value_id, $108 ORDER BY chval.m_ch_value_id) AS variantcombinations FROM m_product_ch_value chval LEFT JOIN m_product p ON chval.m_product_id = p.m_product_id LEFT JOIN m_product_ch pch ON chval.m_product_id = pch.m_product_id AND pch.m_characteristic_id = chval.m_characteristic_id WHERE p.generic_product_id = p_product_id AND p.isactive = $109 AND CASE WHEN v_hideVariantCh = $110 THEN pch.isvariant = $111 ELSE $112=$113 END --AND chval.m_characteristic_id NOT IN (SELECT m_characteristic_id FROM m_characteristic WHERE em_retstk_horizontal_axis = 'Y') GROUP BY p.generic_product_id ) AS principal GROUP BY variantcombinations ) as v ) As vv) ELSE (SELECT array_to_json(array_agg(row_to_json(s))) FROM ( SELECT ( SELECT row_to_json(f) FROM (SELECT m_warehouse.m_warehouse_id as id, m_warehouse.name as identifier, coalesce(m_warehouse.em_retstk_htmlcolor, $114) as "htmlColor", $115 as "show" FROM m_warehouse WHERE m_warehouse.m_warehouse_id = stk.m_warehouse_id ) as f) as warehouse, stk.stock FROM ( SELECT r.m_warehouse_id, array_to_json(array_agg(row_to_json(r))) as stock FROM ( SELECT wh.m_warehouse_id, $116 as "isStandardProduct", ( SELECT row_to_json(var) FROM ( SELECT p.m_product_id as productid, $117 as productimg FROM m_product p WHERE p.m_product_id = p_product_id ) as var ) as product, ( SELECT row_to_json(f) FROM (SELECT m_warehouse.m_warehouse_id as id, m_warehouse.name as identifier, coalesce(m_warehouse.em_retstk_htmlcolor, $118) as "htmlColor", $119 as "show" FROM m_warehouse WHERE m_warehouse.m_warehouse_id = wh.m_warehouse_id ) as f) as warehouse, sum(qtyonhand) as qtyonhand, sum(preqtyonhand) as preqtyonhand, coalesce((SELECT sum(ol.qtyordered - ol.qtydelivered) FROM c_orderline ol LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id WHERE o.issotrx = $120 AND o.docstatus = $121 AND o.m_warehouse_id = wh.m_warehouse_id AND ol.m_product_id = p_product_id),$122)+ sum((case when mi.available = $123 then qtyonhand else $124 end)) as qtypending FROM m_storage_detail sd LEFT JOIN m_locator bin ON bin.m_locator_id = sd.m_locator_id LEFT JOIN m_inventorystatus mi ON mi.m_inventorystatus_id=bin.m_inventorystatus_id LEFT JOIN m_warehouse wh ON wh.m_warehouse_id = bin.m_warehouse_id LEFT JOIN m_product p ON p.m_product_id = sd.m_product_id WHERE wh.em_retstk_breakbylocator=$125 AND (sd.m_product_id = p_product_id OR sd.m_product_id IN (SELECT m_product_id FROM m_product WHERE generic_product_id = p_product_id)) AND wh.m_warehouse_id IN ( SELECT wh.m_warehouse_id FROM m_warehouse wh WHERE CASE WHEN coalesce((SELECT em_retstk_org_filters FROM ad_org WHERE ad_org_id = p_org_id), $126) = $127 THEN EXISTS (SELECT $128 FROM retstk_org_warehouse WHERE m_warehouse_id = wh.m_warehouse_id AND ad_org_id = p_org_id) ELSE NOT EXISTS (SELECT $129 FROM retstk_org_warehouse WHERE m_warehouse_id = wh.m_warehouse_id AND ad_org_id = p_org_id) AND ad_client_id = p_client_id END ) GROUP BY wh.m_warehouse_id) as r GROUP BY r.m_warehouse_id ) as stk ) as s) END) as "verticalValues" FROM m_product prod WHERE prod.m_product_id = p_product_id ) As f
9455753479COMMIT
d3457bdce0SELECT c_country.countrycode as "Code Pays", SUBSTRING(c_order.ad_org_id,$1,$2) as "Code magasin", ad_org.name as "Nom magasin", TO_CHAR(c_order.dateordered::date, $3) as Date, SUM(c_orderline.linenetamt) As "CA HT", $4 As Traffic, COUNT(DISTINCT CASE WHEN subquery.total_linenetamt > $5 THEN c_order.c_order_id ELSE $6 END) - COUNT(DISTINCT CASE WHEN subquery.total_linenetamt < $7 THEN c_order.c_order_id ELSE $8 END) AS "Nombre de tickets" FROM c_orderline INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id LEFT JOIN ad_org ON c_order.ad_org_id = ad_org.ad_org_id LEFT JOIN c_country ON ad_org.em_obretco_dbp_countryid = c_country.c_country_id INNER JOIN ( SELECT c_order_id, SUM(linenetamt) AS total_linenetamt FROM c_orderline GROUP BY c_order_id ) AS subquery ON c_orderline.c_order_id = subquery.c_order_id WHERE c_order.issotrx = $9 AND c_orderline.qtyordered <> $10 AND c_order.dateordered >= CURRENT_DATE - INTERVAL $11 GROUP BY TO_CHAR(c_order.dateordered::date, 'yyyy-mm-dd'), c_country.countrycode, c_order.ad_org_id, ad_org.name
4af3e2b8c4select "_"."m_warehouse_id" as "m_warehouse_id", "_"."ad_org_id" as "ad_org_id", "_"."Almacén" as "Entrepot", "_"."Ubicación" as "Emplacement", "_"."m_product_id" as "m_product_id", "_"."Cantidad" as "Qté stock", "_"."Cantidad Reservada" as "Quantite Reserve", "_"."Valoración Inventario" as "Valo PA HT Stock", "_"."last_purchase" as "last_purchase" from ( select w.m_warehouse_id , sd.ad_org_id , w.name as "Almacén" , l.value as "Ubicación" , sd.m_product_id , sd.qtyonhand "Cantidad" , sd.reservedqty "Cantidad Reservada" , round(coalesce(sd.qtyonhand * coalesce(m_get_cost(sd.m_product_id,now()::timestamp,$1,sd.ad_org_id, sd.ad_client_id,$2,$3,$4),$5),$6),$7) as "Valoración Inventario" ,(SELECT coalesce(MAX(m_inout.movementdate), current_date) FROM m_inoutline LEFT JOIN m_inout on m_inoutline.m_inout_id=m_inout.m_inout_id WHERE m_inout.docstatus<>$8 and m_inout.issotrx = $9 and m_inoutline.m_product_id = sd.m_product_id) as "last_purchase" from m_storage_detail sd inner join m_locator l on l.m_locator_id = sd.m_locator_id inner join m_warehouse w on w.m_warehouse_id = l.m_warehouse_id ) "_"
c5df179779SELECT ot.islegalentity FROM ad_org o JOIN ad_orgtype ot ON o.ad_orgtype_id = ot.ad_orgtype_id WHERE o.ad_org_id = p_org_id
c8a950bd0dSELECT TO_CHAR(COALESCE(TO_CHAR(T.Name),$1)) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=$2) L, M_Characteristic T WHERE M_Characteristic_ID=$3
0483033486SELECT LEVELNO FROM AD_ORG_TREE WHERE AD_ORG_ID = p_orgid AND AD_PARENT_ORG_ID = p_parentorgid AND AD_CLIENT_ID = p_clientid
caede7e47binsert into obmobc_logclient ( obmobc_logclient_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, tstamp, deviceid, context, msg, loglevel, cache_session_id, isonline ) values ( $1, $2, $3, $15, to_timestamp(to_char($4), to_char($16)), $5, to_timestamp(to_char($6), to_char($17)), $7, to_number($8), $9, $10, $11, $12, $13, $14 )
3a2c9ad99bSELECT DISTINCT ON (bp.c_bpartner_id) bp.c_bpartner_id, bp.updated, bp.AD_Language, CAST(bp.birthday AS varchar), bp.is_customer_consent, bp.isactive, usr.created, usr.firstname, usr.lastname, usr.commercialauth, usr.em_izir_updated_optin AS updatedCommercialauth, usr.email, usr.viasms, usr.viaemail, usr.phone, c_country.countrycode AS description /*Replace by countrycode*/, c_location.regionname, c_location.postal, c_location.city, c_location.address1, grt.name, grp.value, created_user.default_ad_org_id AS created_by_org FROM c_bpartner bp LEFT JOIN ad_user usr ON bp.c_bpartner_id = usr.c_bpartner_id LEFT JOIN c_bpartner_location ON bp.c_bpartner_id = c_bpartner_location.c_bpartner_id LEFT JOIN c_location ON c_bpartner_location.c_location_id = c_location.c_location_id LEFT JOIN c_country ON c_country.c_country_id = c_location.c_country_id LEFT JOIN c_greeting grt ON bp.c_greeting_id = grt.c_greeting_id LEFT JOIN c_bp_group grp ON bp.c_bp_group_id = grp.c_bp_group_id LEFT JOIN ad_user created_user ON bp.createdby = created_user.ad_user_id WHERE ( bp.updated >= now() - $1 OR usr.updated >= now() - $2 )
4f42690015insert into c_invoiceline (c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, m_inoutline_id, line, description, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_uom_id, c_tax_id, m_attributesetinstance_id, pricestd, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, grosspricestd, grosspricelist, a_asset_id, c_project_id, user1_id, user2_id, c_costcenter_id) select get_uuid(), i.ad_client_id, i.ad_org_id, $3, i.created, i.createdby, i.updated, i.updatedby, i.c_invoice_id, ol.c_orderline_id, max(iol.m_inoutline_id), row_number() over (partition by i.c_invoice_id order by o.documentno, ol.line) * $5 as line, ol.description, ol.m_product_id, ol.qtyordered, ol.pricelist, ol.priceactual, ol.pricelimit, ol.linenetamt, ol.c_uom_id, ol.c_tax_id, ol.m_attributesetinstance_id, ol.pricestd, ol.linenetamt , (case when pl.istaxincluded = $6 then ol.line_gross_amount else $7 end), ol.gross_unit_price, ol.c_bpartner_id, ol.grosspricestd, ol.grosspricelist, ol.a_asset_id, ol.c_project_id, ol.user1_id, ol.user2_id, ol.c_costcenter_id from c_order o, m_pricelist pl, obpos_applications ap, ad_org org, c_doctype dt, c_invoice i, c_orderline ol left join m_inoutline iol on ol.c_orderline_id = iol.c_orderline_id where ol.c_order_id = o.c_order_id and o.m_pricelist_id = pl.m_pricelist_id and o.m_pricelist_id = i.m_pricelist_id and o.em_obpos_applications_id = ap.obpos_applications_id and o.ad_org_id = org.ad_org_id and $8=$9 and o.c_doctype_id = dt.c_doctype_id and dt.c_doctypeaggrinvoice_id = i.c_doctype_id and o.em_obpos_app_cashup_id = $1 and o.em_obpos_islayaway = $10 and o.invoicerule = $11 and (ol.qtyordered <> $12 and ol.em_obpos_isdeleted = $13) and o.c_doctype_id in (org.em_obpos_c_doctype_id, org.em_obpos_c_doctyperet_id) and not exists (select $14 from c_orderline ol2 where ol2.qtyinvoiced <> $15 and ol2.c_order_id = o.c_order_id) and o.em_obpos_notinvoiceoncashup = $16 and o.iscashvat = i.iscashvat and i.documentno = $2 and i.c_bpartner_id = o.c_bpartner_id and coalesce(i.bpartner_extref, n$17) = coalesce(o.bpartner_extref, n$18) and i.c_bpartner_location_id = coalesce(o.billto_id, o.c_bpartner_location_id) and coalesce(i.ad_user_id, $19) = coalesce(o.ad_user_id, $20) group by i.ad_client_id, i.ad_org_id, i.created, i.createdby, i.updated, i.updatedby, i.c_invoice_id, ol.c_orderline_id, ol.description, ol.m_product_id, ol.qtyordered, ol.pricelist, ol.priceactual, ol.pricelimit, ol.linenetamt, ol.c_uom_id, ol.c_tax_id, ol.m_attributesetinstance_id, ol.pricestd, ol.linenetamt , ol.line_gross_amount, ol.gross_unit_price, ol.c_bpartner_id, ol.grosspricestd, ol.grosspricelist, ol.a_asset_id, ol.c_project_id, ol.user1_id, ol.user2_id, ol.c_costcenter_id, pl.istaxincluded, o.documentno, ol.line, o.c_order_id, o.ad_user_id, o.bpartner_extref order by o.documentno, ol.line
a3d3811d66SELECT retstk_product_stock_json($1, $2, f.m_product_id) as stk FROM ( SELECT distinct coalesce(generic_product_id, m_product_id) as m_product_id FROM m_product WHERE EXISTS (SELECT $3 FROM obretco_prol_product WHERE obretco_productlist_id = $4 AND obretco_prol_product.m_product_id = m_product.m_product_id) AND isactive = $5 AND isstocked = $6 AND producttype = $7 AND (sku ilike $8 OR name ilike $9 OR value ilike $10 OR description ilike $11) ) as f
604436a476insert into C_Import_Entry_Archive (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Imported, Jsoninfo, ImportStatus, Typeofdata, AD_Role_ID, EM_Obpos_Applications_ID, Responseinfo, Isnonblocking, C_Import_Entry_Archive_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16)
3ad5b7fed4SELECT UPPER(a.ATTNAME::TEXT), UPPER(t.TYPNAME::TEXT), CASE t.TYPNAME WHEN $2::name THEN a.atttypmod - $3 WHEN $4::name THEN a.atttypmod - $5 ELSE $6::integer END, CASE t.TYPNAME WHEN $7::name THEN $8 WHEN $9::name THEN $10 WHEN $11::name THEN $12 ELSE CASE a.ATTLEN WHEN $13 THEN a.ATTTYPMOD - $14 ELSE a.ATTLEN END END, CASE t.typname WHEN $15::name THEN $16 WHEN $17::name THEN $18 WHEN $19::name THEN $20 ELSE CASE atttypmod WHEN $21 THEN $22 ELSE coalesce(numeric_precision, $23) END END, coalesce(numeric_scale, $24), not a.attnotnull, CASE a.atthasdef WHEN $25 THEN (SELECT pg_get_expr(adbin, adrelid) FROM pg_attrdef WHERE pg_attrdef.adrelid = c.oid AND pg_attrdef.adnum = a.attnum) ELSE $26::text END, col_description(c.oid,isc.ordinal_position) FROM pg_class c JOIN pg_attribute a ON c.oid = a.attrelid JOIN pg_type t ON a.atttypid = t.oid JOIN pg_namespace n ON c.relnamespace = n.oid LEFT JOIN information_schema.columns isc on isc.table_name = c.relname AND isc.column_name = a.attname WHERE n.nspname = current_schema() AND a.attnum > $27 AND c.relname = $1 ORDER BY a.attnum
74a1d87233SELECT $4 FROM ONLY "profile"."last_stat_database" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "sample_id" OPERATOR(pg_catalog.=) $2 AND "datid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
382d19fc6dSELECT * FROM take_sample_subset(1,0)
f3f57fdf42SELECT * FROM M_InOut_Post0($1)
fe2c4fe6dfselect "_"."c_order_id" as "c_order_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."m_pricelist_id" as "m_pricelist_id", "_"."Documento" as "Documento", "_"."Estado Pedido" as "Estado Pedido", "_"."Accion Pedido" as "Accion Pedido", "_"."Tipo Documento" as "Tipo Documento", "_"."Descripción" as "Descripción", "_"."Fecha Pedido" as "Fecha Pedido", "_"."Fecha Comprometida" as "Fecha Comprometida", "_"."c_bpartner_id" as "c_bpartner_id", "_"."Referencia Proveedor" as "Referencia Proveedor", "_"."c_currency_id" as "c_currency_id", "_"."Currency ISO" as "Currency ISO", "_"."m_warehouse_id" as "m_warehouse_id", "_"."Ciudad" as "Ciudad", "_"."Codigo Postal" as "Codigo Postal", "_"."Pais" as "Pais", "_"."Region" as "Region", "_"."TPV Name" as "TPV Name", "_"."Vendedor" as "Vendedor", "_"."Nombre y Apellido Vendedor" as "Nombre y Apellido Vendedor", "_"."salesrep_id" as "salesrep_id", cast("_"."Fecha Pedido" as date) as "t0_0", cast("_"."Fecha Comprometida" as date) as "t1_0" from ( select "c_order_id", "ad_org_id", "isactive", "issotrx", "m_pricelist_id", "Documento", "Estado Pedido", "Accion Pedido", "Tipo Documento", "Descripción", "Fecha Pedido", "Fecha Comprometida", "c_bpartner_id", "Referencia Proveedor", "c_currency_id", "Currency ISO", "m_warehouse_id", "Ciudad", "Codigo Postal", "Pais", "Region", "TPV Name", "Vendedor", "Nombre y Apellido Vendedor", "salesrep_id" from ( SELECT O.c_order_id , (case when DT.isreturn = $1 then O.ad_orgtrx_id else O.ad_org_id end) ad_org_id , O.isactive , O.issotrx , O.m_pricelist_id , O.documentno as "Documento" , O.docstatus as "Estado Pedido" , O.docaction as "Accion Pedido" , O.processed as "Procesado" , DT.name as "Tipo Documento" , O.description as "Descripción" , O.dateordered as "Fecha Pedido" , O.datepromised as "Fecha Comprometida" , O.c_bpartner_id , O.poreference "Referencia Proveedor" , O.c_currency_id , cu.iso_code "Currency ISO" , O.m_warehouse_id , cl.city as "Ciudad" , cl.postal as "Codigo Postal" , cc."name" as "Pais" , cr."name" as "Region" , OA."name" as "TPV Name" , coalesce(au.name,$2) as "Vendedor" , concat(coalesce(au.firstname,$3),$4,coalesce(au.lastname,$5)) as "Nombre y Apellido Vendedor" , O.salesrep_id FROM c_order O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id left join obpos_applications OA on OA.obpos_applications_id = O.em_obpos_applications_id left join ad_user au on au.ad_user_id = O.salesrep_id WHERE $6=$7 AND O.issotrx = $8 AND O.dateordered >= CURRENT_DATE - INTERVAL $9 ) "$Table" ) "_"
b52b0c82easelect "_"."c_bpartner_id" as "c_bpartner_id", "_"."Identificador" as "Code du Tiers", "_"."Nombre Fiscal" as "Nom Fiscal", "_"."Nombre Comercial" as "Nom du Tiers", "_"."Prospecto" as "Prospect", "_"."Proveedor" as "Fournisseur", "_"."Cliente" as "Client", "_"."Empleado" as "Employé", "_"."NIF" as "TAX", "_"."m_pricelist_id" as "m_pricelist_id", "_"."po_pricelist_id" as "po_pricelist_id", "_"."salesrep_id" as "salesrep_id", "_"."location" as "location", "_"."contact" as "contact", "_"."birthday" as "birthday", "_"."created" as "created", "_"."is_customer_consent" as "is_customer_consent", "_"."birthday_partner" as "birthday_partner" from ( SELECT c_bpartner_id , value as "Identificador" , name as "Nombre Fiscal" , name2 as "Nombre Comercial" , isprospect as "Prospecto" , isvendor as "Proveedor" , iscustomer as "Cliente" , isemployee as "Empleado" , taxid as "NIF" , m_pricelist_id , po_pricelist_id , salesrep_id , (select concat(cl.address1,$1, cl.city,$2, cl.postal,$3, cc.name) from c_bpartner_location cbl inner join c_location cl on cbl.c_location_id = cl.c_location_id left join c_country cc on cc.c_country_id = cl.c_country_id where cbl.c_bpartner_id = c_bpartner.c_bpartner_id limit $4) as location , (select concat(u.phone, $5, u.email, $6, u.commercialauth) from ad_user u where u.c_bpartner_id = c_bpartner.c_bpartner_id LIMIT $7) as contact -- ✅ AJOUTÉ , (select birthday from ad_user u where u.c_bpartner_id = c_bpartner.c_bpartner_id LIMIT $8) as birthday , created , is_customer_consent , birthday as birthday_partner FROM c_bpartner ) "_"
6b67fe6923insert into M_Transaction (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, MovementType, M_Locator_ID, M_Product_ID, MovementDate, MovementQty, M_InOutLine_ID, M_AttributeSetInstance_ID, C_UOM_ID, TrxProcessDate, IsCostCalculated, Costing_Status, Checkreservedqty, Isprocessed, Checkpricedifference, EM_Prouti_Exported, Manualcostadjustment, IsCostPermanent, M_Transaction_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25)
c5a2827c73SELECT count(*) FROM aprm_finacc_transaction_v inner join fin_finacc_transaction ON aprm_finacc_transaction_v.aprm_finacc_transaction_v_id = fin_finacc_transaction.fin_finacc_transaction_id WHERE aprm_finacc_transaction_v.fin_financial_account_id=$1
fb45d4a61fselect orderline0_.M_Product_ID as col_0_0_, product1_.Name as col_1_0_, sum(orderline0_.QtyOrdered) as col_2_0_, uom3_.Name as col_3_0_, product1_.C_UOM_ID as col_4_0_ from C_OrderLine orderline0_ cross join M_Product product1_ cross join C_UOM uom3_ cross join C_Order order5_ cross join M_Product product7_ where orderline0_.M_Product_ID=product1_.M_Product_ID and product1_.C_UOM_ID=uom3_.C_UOM_ID and orderline0_.C_Order_ID=order5_.C_Order_ID and orderline0_.M_Product_ID=product7_.M_Product_ID and order5_.DocStatus=$61 and order5_.IsSOTrx=$62 and $63=$64 and orderline0_.AD_Client_ID=$1 and (product7_.Name like $2) and (orderline0_.AD_Org_ID in ($3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 , $37 , $38 , $39 , $40 , $41 , $42 , $43 , $44 , $45 , $46 , $47 , $48 , $49 , $50 , $51 , $52 , $53 , $54 , $55 , $56 , $57 , $58 , $59)) group by product1_.Name , uom3_.Name , orderline0_.M_Product_ID , product1_.C_UOM_ID order by sum(orderline0_.QtyOrdered) desc limit $60
a874297fd2SELECT M_INOUT_POST(PInstance_ID, $2)
0a9b2d6035SELECT * FROM (SELECT DISTINCT iol.m_product_id as referencekey_id, $2 as ad_role_id, $3 as ad_user_id, $4 || p.name || $5 as description, $6 as isactive, iol.ad_org_id as ad_org_id, iol.ad_client_id as ad_client_id, now() as created, $7 as createdBy, now() as updated, $8 as updatedBy, p.name as RECORD_ID FROM m_inoutline iol JOIN m_inout io ON iol.m_inout_id = io.m_inout_id AND io.issotrx = $9 AND io.docstatus = $10 JOIN m_transaction t ON iol.m_inoutline_id = t.m_inoutline_id JOIN c_bpartner bp ON io.c_bpartner_id = bp.c_bpartner_id JOIN m_product p ON iol.m_product_id = p.m_product_id JOIN m_costing_rule cr ON ad_isorgincluded(io.ad_org_id, cr.ad_org_id, io.ad_client_id) >= $11 AND cr.datefrom <= t.trxprocessdate AND cr.dateto > t.trxprocessdate JOIN m_costing_algorithm ca ON cr.m_costing_algorithm_id = ca.m_costing_algorithm_id AND ca.classname = $12 WHERE NOT EXISTS (SELECT $13 FROM m_matchpo mp WHERE mp.m_inoutline_id = iol.m_inoutline_id AND mp.c_orderline_id IS NOT NULL) AND NOT EXISTS (SELECT $14 FROM m_costing c WHERE c.m_product_id = iol.m_product_id AND c.costtype IN ($15, $16) AND c.datefrom <= t.trxprocessdate AND c.dateto > t.trxprocessdate) AND NOT EXISTS (SELECT $17 FROM m_productprice pp JOIN m_pricelist_version ppv ON pp.m_pricelist_version_id = ppv.m_pricelist_version_id JOIN m_pricelist pl ON pl.m_pricelist_id = ppv.m_pricelist_id WHERE pp.m_product_id = iol.m_product_id AND (bp.po_pricelist_id = ppv.m_pricelist_id OR (bp.po_pricelist_id IS NULL AND pl.issopricelist = $18)) AND ppv.validfrom <= t.trxprocessdate) AND NOT EXISTS (SELECT $19 FROM c_orderline ol JOIN c_order o ON ol.c_order_id = o.c_order_id AND o.issotrx = $20 AND o.processed = $21 WHERE ol.m_product_id = iol.m_product_id AND o.c_bpartner_id = bp.c_bpartner_id AND ad_isorgincluded(o.ad_org_id, cr.ad_org_id, io.ad_client_id) >= $22)) AAA where not exists (select $23 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $24) != $25)
93a759b1daBEGIN
ebe11b089eSELECT retstk_basic_json_lang(p_tablename, p_record_id, $3)
0b24cb5d2fCOPY public.obcfr_ticket (obcfr_ticket_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, documentno, obpos_applications_id, ticketdate, json, seqno, prevhash, hash, hashtime, export) TO stdout
29bf42b1abselect "_"."m_transaction_id" as "m_transaction_id", "_"."m_locator_id" as "m_locator_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."ad_client_id" as "ad_client_id", "_"."ad_org_id" as "ad_org_id", "_"."updated" as "updated", "_"."m_product_id" as "m_product_id", "_"."trxprocessdate" as "Date mvt", "_"."Type de mouvement" as "Type mvt", "_"."Quantité de mouvement" as "Qté mvt", "_"."€ Coût de transaction" as "€ Coût de transaction", "_"."€ Coût moyen du produit" as "€ Coût moyen du produit", "_"."Nom de l'inventaire" as "Nom de l'inventaire", "_"."Bon de livraison" as "Bon de livraison", "_"."Document Commande" as "Document Commande", "_"."TPV" as "TPV", "_"."Type de document" as "Type doc" from ( SELECT mt.m_transaction_id , mt.m_locator_id , ml.m_warehouse_id , mt.ad_client_id , mt.ad_org_id , mt.updated , mt.m_product_id , trunc(mt.trxprocessdate) as trxprocessdate , mt.movementtype as "Type de mouvement" , mt.movementqty as "Quantité de mouvement" , mt.transactioncost as "€ Coût de transaction" , m_get_cost(mt.m_product_id, mt.trxprocessdate, $1, mt.ad_org_id, mt.ad_client_id, $2, $3, $4) AS "€ Coût moyen du produit" , coalesce(mi2."name", $5) as "Nom de l'inventaire" , coalesce(mi4."documentno", $6) as "Bon de livraison" , coalesce(o."documentno", $7) as "Document Commande" , coalesce(oa."name", $8) as "TPV" , coalesce(cd."name", $9) as "Type de document" FROM m_transaction mt LEFT JOIN m_locator ml on ml.m_locator_id = mt.m_locator_id left join m_inventoryline mi on mi.m_inventoryline_id = mt.m_inventoryline_id left join m_inventory mi2 on mi2.m_inventory_id = mi.m_inventory_id left join m_inoutline mi3 on mi3.m_inoutline_id = mt.m_inoutline_id left join m_inout mi4 on mi4.m_inout_id = mi3.m_inout_id left join c_orderline ol on ol.c_orderline_id = mi3.c_orderline_id left join c_order o on o.c_order_id = ol.c_order_id left join obpos_applications oa on o.em_obpos_applications_id = oa.obpos_applications_id left join c_doctype cd on cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = $10 ) "_"
f0238ffe1bCOPY public.obcfr_ticketreprint (obcfr_ticketreprint_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, obcfr_ticket_id, documentno, obpos_applications_id, terminal, printdate, json, seqno, prevhash, hash, hashtime, export) TO stdout
a89f0eb5f9select businesspa0_.C_BPartner_Location_ID as col_0_0_, businesspa1_.C_BPartner_ID as col_1_0_, coalesce(location2_.Address1, location2_.Postal, location2_.City, businesspa0_.Name) as col_2_0_, coalesce(location2_.Address2, $9) as col_3_0_, location2_.Postal as col_4_0_, location2_.City as col_5_0_, coalesce((select countrytrl4_.Name from C_Country_Trl countrytrl4_ where countrytrl4_.C_Country_ID=location2_.C_Country_ID and countrytrl4_.AD_Language=$10), country5_.Name) as col_6_0_, location2_.C_Country_ID as col_7_0_, businesspa0_.IsBillTo as col_8_0_, businesspa0_.IsShipTo as col_9_0_, businesspa0_.Isdefault_Shipto as col_10_0_, businesspa0_.Isdefault_Billto as col_11_0_, coalesce(region3_.Name, $11) as col_12_0_, coalesce(region3_.C_Region_ID, $12) as col_13_0_, businesspa0_.Created as col_14_0_, businesspa0_.Updated as col_15_0_, coalesce((location2_.Address1||case when location2_.Address2 is not null then $13 end||location2_.Address2), location2_.Address1, location2_.Address2, location2_.Postal, location2_.City) as col_16_0_, case when businesspa0_.IsActive=$14 and businesspa1_.IsActive=$15 then $16 else $17 end as col_17_0_, now() as col_18_0_ from C_BPartner_Location businesspa0_ inner join C_BPartner businesspa1_ on businesspa0_.C_BPartner_ID=businesspa1_.C_BPartner_ID left outer join C_Location location2_ on businesspa0_.C_Location_ID=location2_.C_Location_ID left outer join C_Region region3_ on location2_.C_Region_ID=region3_.C_Region_ID cross join C_Country country5_ where location2_.C_Country_ID=country5_.C_Country_ID and $18=$19 and businesspa1_.IsCustomer=$20 and (businesspa1_.M_PriceList_ID is not null) and businesspa0_.IsActive=$21 and businesspa1_.IsActive=$22 and (businesspa0_.AD_Client_ID in ($23 , $24)) and (businesspa0_.AD_Org_ID in ($1 , $2 , $3 , $4 , $5 , $6)) and businesspa0_.C_BPartner_Location_ID>$7 order by businesspa0_.C_BPartner_Location_ID limit $8
24f0f61153insert into M_InOut (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocAction, DocStatus, Processing, Processed, C_DocType_ID, Description, C_Order_ID, DateOrdered, IsPrinted, MovementType, MovementDate, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, M_Warehouse_ID, DeliveryRule, FreightCostRule, FreightAmt, DeliveryViaRule, ChargeAmt, PriorityRule, CreateFrom, GenerateTo, AD_User_ID, SalesRep_ID, AD_OrgTrx_ID, UpdateLines, Calculate_Freight, RM_Receipt_PickEdit, RM_Shipment_Pickedit, Process_Goods_Java, Isnettingshipment, Iscompletelyinvoiced, EM_Obwpack_Packing, Invoicefromshipment, EM_Obwpack_Processed, EM_Obwpack_Reactivated, EM_Obwpack_Packingrequired, EM_OBEUCI_Ship, EM_Prouti_Changebpartner, EM_Pruti_Createfrom, EM_Izi_Exported, M_InOut_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52)
e0fba79faaSELECT count(*) FROM DUAL WHERE EXISTS (SELECT $14 FROM m_costing WHERE datefrom <= p_movementdate AND dateto > p_movementdate AND m_product_id = p_product_id AND COALESCE(m_warehouse_id, p_warehouse_id, $15) = COALESCE(p_warehouse_id, m_warehouse_id, $16) AND ad_org_id IN (v_legal_entity,$17) AND cost IS NOT NULL AND costtype IN ($18, $19) AND costtype = COALESCE(v_CostType, costtype) )
5f8e9d0065SELECT 1 FROM ONLY "public"."ad_client" x WHERE "ad_client_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
905bffc89cSELECT profile.take_sample()
313b1ecda9insert into C_IMPORT_ENTRY (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Jsoninfo, ImportStatus, Typeofdata, AD_Role_ID, Createdtimestamp, Isnonblocking, C_IMPORT_ENTRY_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)
616a44c111insert into OBCFR_Ticket (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Obpos_Applications_ID, Ticketdate, Json, Seqno, Prevhash, Hash, Hashtime, Export, Documentno, Obcfr_Ticket_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17)
2e2f56a414SELECT row_to_json(f) FROM (SELECT coalesce(p_record_id,$3) as id, coalesce(ad_column_identifier_std(p_tablename, p_record_id), $4) as identifier FROM dual) as f
61aed5765cselect businesspa0_.C_BPartner_Location_ID as col_0_0_, businesspa1_.C_BPartner_ID as col_1_0_, coalesce(location2_.Address1, location2_.Postal, location2_.City, businesspa0_.Name) as col_2_0_, coalesce(location2_.Address2, $11) as col_3_0_, location2_.Postal as col_4_0_, location2_.City as col_5_0_, coalesce((select countrytrl4_.Name from C_Country_Trl countrytrl4_ where countrytrl4_.C_Country_ID=location2_.C_Country_ID and countrytrl4_.AD_Language=$12), country5_.Name) as col_6_0_, location2_.C_Country_ID as col_7_0_, businesspa0_.IsBillTo as col_8_0_, businesspa0_.IsShipTo as col_9_0_, businesspa0_.Isdefault_Shipto as col_10_0_, businesspa0_.Isdefault_Billto as col_11_0_, coalesce(region3_.Name, $13) as col_12_0_, coalesce(region3_.C_Region_ID, $14) as col_13_0_, businesspa0_.Created as col_14_0_, businesspa0_.Updated as col_15_0_, coalesce((location2_.Address1||case when location2_.Address2 is not null then $15 end||location2_.Address2), location2_.Address1, location2_.Address2, location2_.Postal, location2_.City) as col_16_0_, case when businesspa0_.IsActive=$16 and businesspa1_.IsActive=$17 then $18 else $19 end as col_17_0_, now() as col_18_0_ from C_BPartner_Location businesspa0_ inner join C_BPartner businesspa1_ on businesspa0_.C_BPartner_ID=businesspa1_.C_BPartner_ID left outer join C_Location location2_ on businesspa0_.C_Location_ID=location2_.C_Location_ID left outer join C_Region region3_ on location2_.C_Region_ID=region3_.C_Region_ID cross join C_Country country5_ where location2_.C_Country_ID=country5_.C_Country_ID and $20=$21 and businesspa1_.IsCustomer=$22 and (businesspa1_.M_PriceList_ID is not null) and (businesspa0_.Updated>$1 or businesspa1_.Updated>$2 or location2_.Updated>$3) and (businesspa0_.AD_Client_ID in ($23 , $24)) and (businesspa0_.AD_Org_ID in ($4 , $5 , $6 , $7 , $8 , $9)) and $25=$26 order by businesspa0_.C_BPartner_Location_ID limit $10
3f546d3e2bselect "_"."c_orderline_id" as "c_orderline_id", "_"."c_order_id" as "c_order_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "Actif", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", cast("_"."Fecha Pedido" as date) as "Date Commande", cast("_"."Fecha Comprometida" as date) as "Date de livraison engagée", cast("_"."Fecha Enviada" as date) as "Fecha Enviada", "_"."Descripción" as "Description ligne", "_"."Cantidad Pedido" as "Qté vendue", "_"."Precio Lista" as "Prix List", "_"."Precio Actual" as "Prix Actuel", "_"."Precio Limite" as "Prix Limite", "_"."Importe Linea" as "Montant net ligne", "_"."Importe TTC" as "Importe TTC", "_"."Descuento" as "€ Remise", "_"."Cantidad Recibida" as "Quantite reçue", cast("_"."Fecha Recepción" as date) as "Fecha Recepción", cast("_"."bp_created" as date) as "bp_created", "_"."bp_country" as "bp_country", "_"."isdelivered" as "isdelivered" from ( SELECT OL.c_orderline_id , OL.c_order_id , (case when cd.isreturn = $1 then O.ad_orgtrx_id else OL.ad_org_id end) ad_org_id , OL.isactive , O.issotrx , OL.c_bpartner_id , OL.c_currency_id , OL.m_product_id , OL.m_warehouse_id , P.m_product_category_id , OL.line , OL.dateordered as "Fecha Pedido" , OL.datepromised as "Fecha Comprometida" , OL.datedelivered as "Fecha Enviada" , OL.description as "Descripción" , OL.qtyordered "Cantidad Pedido" , OL.pricelist "Precio Lista" , OL.priceactual "Precio Actual" , OL.pricelimit "Precio Limite" , OL.linenetamt "Importe Linea" , OL.line_gross_amount "Importe TTC" , OL.discount as "Descuento" , (SELECT SUM(movementqty) FROM m_inoutline IOL WHERE IOL.c_orderline_id = OL.c_orderline_id) as "Cantidad Recibida" , (SELECT MAX(movementdate) FROM m_inoutline IOL INNER JOIN m_inout IO on IO.m_inout_id = IOL.m_inout_id WHERE IOL.c_orderline_id = OL.c_orderline_id) as "Fecha Recepción" , BP.created as "bp_created" , (select cc.name from c_bpartner_location cbl inner join c_location cl on cbl.c_location_id = cl.c_location_id left join c_country cc on cc.c_country_id = cl.c_country_id where cbl.c_bpartner_id = BP.c_bpartner_id limit $2) as bp_country , O.isdelivered FROM c_orderline OL LEFT JOIN c_order O on O.c_order_id = OL.c_order_id left join c_doctype cd on O.c_doctype_id = cd.c_doctype_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id LEFT JOIN c_bpartner BP on BP.c_bpartner_id = O.c_bpartner_id WHERE $3=$4 AND O.issotrx = $5 AND OL.dateordered >= CURRENT_DATE - INTERVAL $6 ) "_"
017d00aa12insert into c_invoicelinetax (c_invoicelinetax_id, c_tax_id, c_invoice_id, c_invoiceline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, recalculate) select get_uuid(), olt.c_tax_id, i.c_invoice_id, il.c_invoiceline_id, i.ad_client_id, i.ad_org_id, $2, i.created, i.createdby, i.updated, i.updatedby, olt.taxbaseamt, olt.taxamt, olt.line, $4 from c_order o, c_orderline ol, c_orderlinetax olt, c_invoice i, c_invoiceline il where o.c_order_id = ol.c_order_id and ol.c_orderline_id = olt.c_orderline_id and ol.c_orderline_id = il.c_orderline_id and il.c_invoice_id = i.c_invoice_id and i.documentno = $1 and i.c_bpartner_id = o.c_bpartner_id and i.c_bpartner_location_id = coalesce(o.billto_id, o.c_bpartner_location_id) and coalesce(i.ad_user_id, $6) = coalesce(o.ad_user_id, $7)
cee3b65d37select order0_.C_Order_ID as col_0_0_, documentty1_.C_DocType_ID as col_1_0_, order0_.DocStatus as col_2_0_, order0_.DocumentNo as col_3_0_, order0_.Created as col_4_0_, order0_.DateOrdered as col_5_0_, order0_.DateOrdered as col_6_0_, order0_.DateOrdered as col_7_0_, businesspa2_.C_BPartner_ID as col_8_0_, businesspa2_.Name as col_9_0_, order0_.GrandTotal as col_10_0_, order0_.GrandTotal as col_11_0_, order0_.GrandTotal as col_12_0_, order0_.Iscancelled as col_13_0_, organizati3_.AD_Org_ID as col_14_0_, organizati3_.Value as col_15_0_, organizati3_.Name as col_16_0_, organizati5_.AD_Org_ID as col_17_0_, organizati5_.Name as col_18_0_, order0_.IsDelivered as col_19_0_, order0_.BPartner_ExtRef as col_20_0_, (select coalesce(max(orderline6_.EM_Obrdm_Delivery_Mode), $4) from C_OrderLine orderline6_ where order0_.C_Order_ID=orderline6_.C_Order_ID and orderline6_.EM_Obpos_Isdeleted=$5) as col_21_0_, (select min(case when orderline7_.EM_Obrdm_Delivery_Date is null or orderline7_.EM_Obrdm_Delivery_Time is null then $6 else to_timestamp((to_char(orderline7_.EM_Obrdm_Delivery_Date, $7)||$8||to_char(orderline7_.EM_Obrdm_Delivery_Date, $9)||$10||to_char(orderline7_.EM_Obrdm_Delivery_Date, $11)||$12||to_char(orderline7_.EM_Obrdm_Delivery_Time, $13)||$14||to_char(orderline7_.EM_Obrdm_Delivery_Time, $15)), $16) end) from C_OrderLine orderline7_ where order0_.C_Order_ID=orderline7_.C_Order_ID) as col_22_0_, case when documentty1_.C_DocType_ID=organizati3_.EM_Gcnv_C_Doctypegcard_ID then $17 else case when documentty1_.IsReturn=$18 then $19 when documentty1_.DocSubTypeSO=$20 then $21 when order0_.EM_Obpos_Islayaway=$22 then $23 else $24 end end as col_23_0_, (select array_to_string(array_agg(distinct invoice11_.DocumentNo), $25) from C_InvoiceLine invoicelin10_ inner join C_Invoice invoice11_ on invoicelin10_.C_Invoice_ID=invoice11_.C_Invoice_ID inner join C_OrderLine orderline12_ on invoicelin10_.C_OrderLine_ID=orderline12_.C_OrderLine_ID inner join C_Order order13_ on orderline12_.C_Order_ID=order13_.C_Order_ID where order13_.C_Order_ID=order0_.C_Order_ID) as col_24_0_, order0_.InvoiceRule as col_25_0_, order0_.EM_Prpgr_Ticketno as col_26_0_ from C_Order order0_ inner join C_DocType documentty1_ on order0_.C_DocType_ID=documentty1_.C_DocType_ID inner join C_BPartner businesspa2_ on order0_.C_BPartner_ID=businesspa2_.C_BPartner_ID inner join AD_Org organizati3_ on order0_.AD_Org_ID=organizati3_.AD_Org_ID inner join OBPOS_APPLICATIONS obpos_appl4_ on order0_.EM_Obpos_Applications_ID=obpos_appl4_.Obpos_Applications_ID left outer join AD_Org organizati5_ on order0_.AD_OrgTrx_ID=organizati5_.AD_Org_ID where (upper((select array_to_string(array_agg(distinct invoice15_.DocumentNo), $26) from C_InvoiceLine invoicelin14_ inner join C_Invoice invoice15_ on invoicelin14_.C_Invoice_ID=invoice15_.C_Invoice_ID inner join C_OrderLine orderline16_ on invoicelin14_.C_OrderLine_ID=orderline16_.C_OrderLine_ID inner join C_Order order17_ on orderline16_.C_Order_ID=order17_.C_Order_ID where order17_.C_Order_ID=order0_.C_Order_ID)) like upper($1)) and $27=$28 and order0_.AD_Client_ID=$29 and order0_.AD_OrgTrx_ID=$2 and order0_.EM_Obpos_Isdeleted=$30 and (order0_.DocStatus not in ($31 , $32 , $33 , $34 , $35)) and (order0_.DocStatus<>$36 or order0_.Iscancelled=$37) order by col_4_0_ desc, col_3_0_ desc limit $3
08db126a91select "_"."c_orderline_id" as "c_orderline_id", "_"."c_order_id" as "c_order_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "Actif", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."line" as "line", cast("_"."Fecha Pedido" as date) as "Date Commande", cast("_"."Fecha Comprometida" as date) as "Date de livraison engagée", cast("_"."Fecha Enviada" as date) as "Fecha Enviada", "_"."Descripción" as "Description ligne", "_"."Cantidad Pedido" as "Qté Commandée", "_"."Precio Lista" as "Prix List", "_"."Precio Actual" as "Prix Actuel", "_"."Precio Limite" as "Prix Limite", "_"."Importe Linea" as "Montant net ligne", "_"."Descuento" as "€ Remise", "_"."Cantidad Recibida" as "Quantite reçue", cast("_"."Fecha Recepción" as date) as "Fecha Recepción" from ( SELECT OL.c_orderline_id , OL.c_order_id , OL.ad_org_id , OL.isactive , O.issotrx , OL.c_bpartner_id , OL.c_currency_id , OL.m_product_id , OL.m_warehouse_id , P.m_product_category_id , OL.line , OL.dateordered as "Fecha Pedido" , OL.datepromised as "Fecha Comprometida" , OL.datedelivered as "Fecha Enviada" , OL.description as "Descripción" , OL.qtyordered "Cantidad Pedido" , OL.pricelist "Precio Lista" , OL.priceactual "Precio Actual" , OL.pricelimit "Precio Limite" , OL.linenetamt "Importe Linea" , OL.discount as "Descuento" , (SELECT SUM(movementqty) FROM m_inoutline IOL WHERE IOL.c_orderline_id = OL.c_orderline_id) as "Cantidad Recibida" , (SELECT MAX(movementdate) FROM m_inoutline IOL INNER JOIN m_inout IO on IO.m_inout_id = IOL.m_inout_id WHERE IOL.c_orderline_id = OL.c_orderline_id) as "Fecha Recepción" FROM c_orderline OL LEFT JOIN c_order O on O.c_order_id = OL.c_order_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id WHERE $1=$2 AND O.issotrx <> $3 AND OL.dateordered >= CURRENT_DATE - INTERVAL $4 ) "_"
8e8235137eSELECT 1 FROM ONLY "public"."ad_org" x WHERE "ad_org_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
528c231cbeUPDATE M_STORAGE_DETAIL SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0), QTYORDERONHAND=QTYORDERONHAND + v_qtyorder, DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY), PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0), PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder, AD_CLIENT_ID=p_client, UPDATED=TO_DATE(NOW()), UPDATEDBY=p_user WHERE M_PRODUCT_ID=p_product AND M_LOCATOR_ID=p_locator AND M_ATTRIBUTESETINSTANCE_ID=v_attributesetinstance AND C_UOM_ID=p_uom AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')
2d19e5b311insert into OBCFR_TicketReprint (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Obcfr_Ticket_ID, Obpos_Applications_ID, Printdate, Json, Prevhash, Hash, Hashtime, Documentno, Terminal, Seqno, Export, Obcfr_Ticketreprint_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19)
7e35c14916select distinct aduser0_.Name as col_0_0_, aduser0_.UserName as col_1_0_, aduser0_.AD_User_ID as col_2_0_, aduser0_.Firstname as col_3_0_, aduser0_.Lastname as col_4_0_ from AD_User aduser0_ cross join AD_User_Roles aduserrole1_ cross join AD_Role adrole2_ cross join AD_Form_Access adformacce3_ cross join OBPOS_APPLICATIONS obpos_appl4_ cross join AD_Role_OrgAccess adroleorga5_ where aduser0_.IsActive=$21 and (aduser0_.UserName is not null) and (aduser0_.Password is not null) and aduserrole1_.IsActive=$22 and adrole2_.IsActive=$23 and obpos_appl4_.Value=$1 and aduser0_.AD_User_ID=aduserrole1_.AD_User_ID and aduserrole1_.AD_Role_ID=adrole2_.AD_Role_ID and adrole2_.IsPortal=$24 and (adformacce3_.IsActive=$25 and adrole2_.AD_Role_ID=adformacce3_.AD_Role_ID and adformacce3_.AD_Form_ID=$2 or adrole2_.IsManual=$26) and (adroleorga5_.AD_Role_ID=adrole2_.AD_Role_ID and adroleorga5_.AD_Org_ID=obpos_appl4_.AD_Org_ID and adroleorga5_.IsActive=$27 or adrole2_.IsManual=$28 and not (exists (select adroleorga6_.AD_Role_OrgAccess_ID from AD_Role_OrgAccess adroleorga6_ where adroleorga6_.AD_Role_ID=adrole2_.AD_Role_ID and adroleorga6_.IsActive=$29 and (adroleorga6_.AD_Org_ID in ($3 , $4 , $5 , $6 , $7 , $8))))) and (aduser0_.AD_Org_ID in ($9 , $10 , $11 , $12 , $13 , $14) or obpos_appl4_.AD_Org_ID in ($15 , $16 , $17 , $18 , $19 , $20)) and ( not (exists (select obpos_term7_.Obpos_Userterminal_Access_ID from OBPOS_Userterminal_Access obpos_term7_ where obpos_term7_.AD_User_ID=aduser0_.AD_User_ID)) or exists (select obpos_term8_.Obpos_Userterminal_Access_ID from OBPOS_Userterminal_Access obpos_term8_ where obpos_term8_.AD_User_ID=aduser0_.AD_User_ID and obpos_term8_.Obpos_Applications_ID=obpos_appl4_.Obpos_Applications_ID)) order by aduser0_.Name
bb4767275dSELECT coalesce(ad_language,$1) FROM AD_CLIENT WHERE ad_client_id=$2
d94df8c714INSERT INTO AD_TreeNode ( ad_treeNode_Id, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, AD_Tree_ID, Node_ID, Parent_ID, SeqNo ) SELECT get_uuid(), a.ad_client_id, a.ad_org_id, a.isactive, now(), $3, now(), $5, (SELECT ad_tree_id from ad_tree where treetype = $1 AND ad_tree.ad_client_id = a.ad_client_id) AS treeID, a.C_BPartner_id, $7, $9 FROM C_BPartner a WHERE NOT EXISTS (SELECT $10 FROM AD_TREENODE tn INNER JOIN AD_TREE t ON (t.ad_tree_id=tn.ad_tree_id) WHERE t.treetype = $2 AND $11=$12 AND a.C_BPartner_id = tn.node_id)
d1e21ddf3eSELECT REPLACE(REPLACE(SQL_RECORD_IDENTIFIER, $4, $5 || p_Language || $6), $7, p_Record_ID) FROM AD_TABLE WHERE UPPER(TABLENAME)=UPPER(p_TableName)
68de33d5d7INSERT INTO M_MATCHPO ( M_MatchPO_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, M_InOutLine_ID, C_OrderLine_ID, M_Product_ID, DateTrx, Qty, Processing, Processed, Posted ) VALUES ( v_MatchPO_ID, Cur_SLines.AD_Client_ID, Cur_SLines.AD_Org_ID, $260, TO_DATE(NOW()), v_User, TO_DATE(NOW()), v_User, Cur_SLines.M_InOutLine_ID, Cur_SLines.C_OrderLine_ID, Cur_SLines.M_Product_ID, TO_DATE(NOW()), v_Qty, $261, $262, $263 )
41ed5172b0SELECT CASE WHEN $2.typtype = $3 THEN $2.typtypmod ELSE $1.atttypmod END
d3dcdac298SELECT AD_LEGALENTITY_ORG_ID FROM AD_Org WHERE AD_Org_ID = p_org_id
19825253efselect c_import_e0_.C_IMPORT_ENTRY_ID as c_import1_236_, c_import_e0_.AD_Client_ID as ad_clien2_236_, c_import_e0_.AD_Org_ID as ad_org_i3_236_, c_import_e0_.Isactive as isactive4_236_, c_import_e0_.Created as created5_236_, c_import_e0_.Createdby as createdb6_236_, c_import_e0_.Updated as updated7_236_, c_import_e0_.Updatedby as updatedb8_236_, c_import_e0_.Imported as imported9_236_, c_import_e0_.Jsoninfo as jsoninf10_236_, c_import_e0_.ImportStatus as imports11_236_, c_import_e0_.Typeofdata as typeofd12_236_, c_import_e0_.Errorinfo as errorin13_236_, c_import_e0_.AD_Role_ID as ad_role14_236_, c_import_e0_.Createdtimestamp as created15_236_, c_import_e0_.EM_Obpos_Applications_ID as em_obpo16_236_, c_import_e0_.Responseinfo as respons17_236_, c_import_e0_.Isnonblocking as isnonbl18_236_ from C_IMPORT_ENTRY c_import_e0_ where c_import_e0_.Typeofdata=$1 and c_import_e0_.ImportStatus='Initial' order by c_import_e0_.Created, c_import_e0_.Createdtimestamp limit $2
66bc870e45insert into FIN_Payment_ScheduleDetail (AD_Client_ID, AD_Org_ID, Created, Createdby, Updated, Updatedby, FIN_Payment_Schedule_Order, Amount, Isactive, Writeoffamt, Iscanceled, C_Bpartner_ID, DoubtfulDebt_Amount, Isinvoicepaid, FIN_Payment_Scheduledetail_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2841013087select "_"."fin_payment_detail_v_id" as "fin_payment_detail_v_id", "_"."ad_client_id" as "ad_client_id", "_"."ad_org_id" as "ad_org_id", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_order_id" as "c_order_id", "_"."orderno" as "Comande No.", "_"."invoiceno" as "Facture No.", "_"."paymentno" as "Paiement No.", "_"."duedate" as "Date comptable", "_"."paymentdate" as "Date de paiement", "_"."invoicedamt" as "Montant de la facture", "_"."expected" as "Attendu", "_"."paidamt" as "Montant payé", "_"."expectedconverted" as "Converti attendu", "_"."paidconverted" as "Payé converti", "_"."paymentmethod" as "Mode de paiement", "_"."status" as "Status" from ( select fpdv.fin_payment_detail_v_id , fpdv.ad_client_id , (case when cd.isreturn = $1 then co.ad_orgtrx_id else fpdv.ad_org_id end) ad_org_id , fpdv.c_bpartner_id , fpdv.fin_payment_sched_ord_v_id as "c_order_id" , fpdv.orderno , fpdv.invoiceno , fpdv.paymentno , fpdv.duedate , fpdv.paymentdate , fpdv.invoicedamt , fpdv.expected , fpdv.paidamt , fpdv.expectedconverted , fpdv.paidconverted , fp.name as "paymentmethod" , fpdv.status from fin_payment_detail_v fpdv left join c_order co on co.c_order_id = fpdv.fin_payment_sched_ord_v_id left join c_doctype cd on co.c_doctype_id = cd.c_doctype_id left join fin_paymentmethod fp on fp.fin_paymentmethod_id = fpdv.fin_paymentmethod_id where co.issotrx = $2 ) "_"
4f9621bcb7insert into C_Order (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, C_DocType_ID, C_DocTypeTarget_ID, Description, IsDelivered, IsInvoiced, IsPrinted, IsSelected, SalesRep_ID, DateOrdered, DatePromised, DateAcct, C_BPartner_ID, BillTo_ID, C_BPartner_Location_ID, IsDiscountPrinted, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, InvoiceRule, DeliveryRule, FreightCostRule, DeliveryViaRule, ChargeAmt, PriorityRule, TotalLines, GrandTotal, M_Warehouse_ID, M_PriceList_ID, IsTaxIncluded, Posted, AD_User_ID, CopyFrom, IsSelfService, AD_OrgTrx_ID, Generatetemplate, CopyFromPO, FIN_Paymentmethod_ID, RM_PickFromShipment, RM_ReceiveMaterials, RM_CreateInvoice, RM_AddOrphanLine, Calculate_Promotions, Convertquotation, Create_POLines, EM_Obdisc_Addpack, Iscashvat, EM_OBMFM_Selectfreight, RM_Pickfromreceipt, Cancelandreplace, EM_APRM_AddPayment, Confirmcancelandreplace, EM_Obwpl_Generatepicking, EM_Obwpl_Isinpickinglist, EM_Fash_Sendbeforedate, EM_Obwpl_Readypl, EM_Poss_Businessdate, Iscancelled, EM_OBMFM_Set_Weight, EM_Obpos_Applications_ID, EM_Obpos_Sendemail, EM_Obpos_App_Cashup_ID, EM_Obpos_Createdabsolute, EM_OBPOS_NotInvoiceOnCashUp, EM_Obpos_Isdeleted, EM_Obpos_Islayaway, EM_Obpos_Prepaymentamt, EM_Obpos_Prepaymentlimitamt, EM_Obpos_Prepaymentlaylimitamt, EM_Obpos_Rounding_Amount, EM_Obpos_Sequencename, EM_Obpos_Sequencenumber, EM_Prpp_Generatepicking, EM_Api_Resend, EM_OBSMAIL_EmailAddress, EM_Prouti_Order_Stock, EM_Prouti_Pregenerate_Minout, EM_Prouti_Sotopo, EM_Prouti_Generate_Pick_Inv, EM_Prouti_Changebpartner, EM_Prouti_Recalculate_Price, EM_Prouti_Reactiveorder, EM_Izi_Exported, EM_Izijoy_Export_Enjoy, EM_Izi_Splio_Exported, em_prouti_Invoiced, em_prouti_Received, em_prouti_initial_received, EM_Prouti_Status_Of_Review, EM_Prouti_Validate_Order, EM_Prouti_Start_Review, EM_Obpos_Skip_Tax_Calculation, EM_Prouti_Addlines_Btn, EM_Avisver_Export, EM_Prouti_Select_Soline, EM_Prgr_Assign, C_Order_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109)
d11440f550select businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL as col_0_0_, businesspa0_.EM_Gcnv_Uniquecreditnote as col_1_0_, businesspa0_.C_BPartner_ID as col_2_0_, businesspa0_.AD_Org_ID as col_3_0_, businesspa0_.Name as col_4_0_, businesspa0_.Name as col_5_0_, businesspa0_.Value as col_6_0_, businesspa0_.Description as col_7_0_, businesspa0_.TaxID as col_8_0_, businesspa0_.SO_Bp_Taxcategory_ID as col_9_0_, businesspa0_.M_PriceList_ID as col_10_0_, businesspa0_.FIN_Paymentmethod_ID as col_11_0_, businesspa0_.C_PaymentTerm_ID as col_12_0_, businesspa0_.InvoiceRule as col_13_0_, aduserlist4_.Email as col_14_0_, aduserlist4_.AD_User_ID as col_15_0_, aduserlist4_.Phone as col_16_0_, aduserlist4_.Phone2 as col_17_0_, coalesce(aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) as col_18_0_, aduserlist4_.Lastname as col_19_0_, pricingpri1_.IsTaxIncluded as col_20_0_, pricingpri1_.C_Currency_ID as col_21_0_, pricingpri1_.Name as col_22_0_, businesspa0_.C_BP_Group_ID as col_23_0_, businesspa5_.Name as col_24_0_, businesspa0_.SO_CreditLimit as col_25_0_, businesspa0_.SO_CreditUsed as col_26_0_, businesspa0_.IsTaxExempt as col_27_0_, businesspa0_.Customer_Blocking as col_28_0_, businesspa0_.SO_Order_Blocking as col_29_0_, businesspa0_.Birthday as col_30_0_, businesspa0_.Birthplace as col_31_0_, businesspa0_.IsActive as col_32_0_, businesspa0_.Is_Customer_Consent as col_33_0_, businesspa0_.Is_Customer_Consent_PapFormat as col_34_0_, adlanguage2_.AD_Language as col_35_0_, adlanguage2_.Name as col_36_0_, greeting3_.C_Greeting_ID as col_37_0_, greeting3_.Name as col_38_0_, aduserlist4_.Comments as col_39_0_, businesspa0_.SO_CreditLimit-businesspa0_.SO_CreditUsed as col_40_0_, aduserlist4_.Commercialauth as col_41_0_, aduserlist4_.Viaemail as col_42_0_, aduserlist4_.Viasms as col_43_0_, businesspa0_.business_partner_type as col_44_0_, businesspa0_.BP_Currency_ID as col_45_0_, businesspa0_.SO_Creditminamt as col_46_0_, now() as col_47_0_ from C_BPartner businesspa0_ inner join M_PriceList pricingpri1_ on businesspa0_.M_PriceList_ID=pricingpri1_.M_PriceList_ID left outer join AD_Language adlanguage2_ on businesspa0_.AD_Language=adlanguage2_.AD_Language left outer join C_Greeting greeting3_ on businesspa0_.C_Greeting_ID=greeting3_.C_Greeting_ID left outer join AD_User aduserlist4_ on businesspa0_.C_BPartner_ID=aduserlist4_.C_BPartner_ID cross join C_BP_Group businesspa5_ where businesspa0_.C_BP_Group_ID=businesspa5_.C_BP_Group_ID and $9=$10 and businesspa0_.IsCustomer=$11 and (businesspa0_.AD_Client_ID in ($12 , $13)) and (businesspa0_.AD_Org_ID in ($1 , $2 , $3 , $4 , $5 , $6)) and businesspa0_.IsActive=$14 and (aduserlist4_.AD_User_ID in (select aduser6_.AD_User_ID from AD_User aduser6_ where aduser6_.EM_OBRETCO_Default_Pos_Contact=$15 and aduser6_.C_BPartner_ID=businesspa0_.C_BPartner_ID)) and businesspa0_.C_BPartner_ID>$7 group by businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL , businesspa0_.EM_Gcnv_Uniquecreditnote , businesspa0_.C_BPartner_ID , businesspa0_.AD_Org_ID , businesspa0_.Name , businesspa0_.Name , businesspa0_.Value , businesspa0_.Description , businesspa0_.TaxID , businesspa0_.SO_Bp_Taxcategory_ID , businesspa0_.M_PriceList_ID , businesspa0_.FIN_Paymentmethod_ID , businesspa0_.C_PaymentTerm_ID , businesspa0_.InvoiceRule , aduserlist4_.Email , aduserlist4_.AD_User_ID , aduserlist4_.Phone , aduserlist4_.Phone2 , coalesce(aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) , aduserlist4_.Lastname , pricingpri1_.IsTaxIncluded , pricingpri1_.C_Currency_ID , pricingpri1_.Name , businesspa0_.C_BP_Group_ID , businesspa5_.Name , businesspa0_.SO_CreditLimit , businesspa0_.SO_CreditUsed , businesspa0_.IsTaxExempt , businesspa0_.Customer_Blocking , businesspa0_.SO_Order_Blocking , businesspa0_.Birthday , businesspa0_.Birthplace , businesspa0_.IsActive , businesspa0_.Is_Customer_Consent , businesspa0_.Is_Customer_Consent_PapFormat , adlanguage2_.AD_Language , adlanguage2_.Name , greeting3_.C_Greeting_ID , greeting3_.Name , aduserlist4_.Comments , businesspa0_.SO_CreditLimit-businesspa0_.SO_CreditUsed , aduserlist4_.Commercialauth , aduserlist4_.Viaemail , aduserlist4_.Viasms , businesspa0_.business_partner_type , businesspa0_.BP_Currency_ID , businesspa0_.SO_Creditminamt , now() having $16=$17 order by businesspa0_.C_BPartner_ID limit $8
8cb37f78eeinsert into C_OrderLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Order_ID, Line, C_BPartner_ID, DateOrdered, Description, M_Product_ID, M_Warehouse_ID, DirectShip, C_UOM_ID, QtyOrdered, QtyDelivered, C_Currency_ID, PriceList, PriceActual, LineNetAmt, Discount, ChargeAmt, C_Tax_ID, IsDescription, PriceStd, CANCELPRICEAD, Iseditlinenetamt, Gross_Unit_Price, Line_Gross_Amount, GrossPriceList, grosspricestd, Manage_Reservation, Manage_Prereservation, Explode, EM_OBMFM_IsFreightAmt, EM_Phieco_Deeenet, Print_Description, EM_Obwpl_Readypl, EM_Phieco_Deanet, EM_Phieco_Deeegross, Relate_Orderline, EM_Obrdm_Delivery_Mode, EM_Phieco_Deagross, em_fash_prodset_isvalidate, EM_Fash_Exclude_Productset, EM_Obpos_Isdeleted, EM_Obpos_Service_Proposed, EM_Prouti_Closeline, EM_Obpos_Canbedelivered, EM_Obpos_Ispaid, EM_Phieco_Pmcbnet, EM_Phieco_Pmcbgross, Salesrep_ID, EM_Izi_Splio_Exported, EM_Prouti_Recalculate_Qtyinit, C_OrderLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58)
37386bc419SELECT AD_COLUMN_IDENTIFIER(p_TableName, p_Record_ID, v_Language ) FROM DUAL
3ff50f5232insert into C_OrderTax (C_Order_ID, C_Tax_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, TaxBaseAmt, TaxAmt, Line, C_OrderTax_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
018c5dd71eselect c_bpartner_id , trunc(created) as created , (select cc.name from c_bpartner_location cbl inner join c_location cl on cbl.c_location_id = cl.c_location_id left join c_country cc on cc.c_country_id = cl.c_country_id where cbl.c_bpartner_id = c_bpartner.c_bpartner_id limit $1) as bp_country from c_bpartner where $2=$3 and isactive = $4
48f140c821update c_orderline set qtyinvoiced=qtyordered where c_orderline_id in ( select ol.c_orderline_id from c_order o, c_orderline ol, c_orderlinetax olt, c_invoice i, c_invoiceline il where o.c_order_id = ol.c_order_id and ol.c_orderline_id = olt.c_orderline_id and ol.c_orderline_id = il.c_orderline_id and il.c_invoice_id = i.c_invoice_id and i.documentno = $1 and i.c_bpartner_id = o.c_bpartner_id and i.c_bpartner_location_id = coalesce(o.billto_id, o.c_bpartner_location_id) and coalesce(i.ad_user_id, $2) = coalesce(o.ad_user_id, $3))
8d633ecaabinsert into C_Import_Entry_Archive (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Imported, Jsoninfo, ImportStatus, Typeofdata, AD_Role_ID, Responseinfo, Isnonblocking, C_Import_Entry_Archive_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
f398687456insert into C_Order (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, C_DocType_ID, C_DocTypeTarget_ID, Description, IsDelivered, IsInvoiced, IsPrinted, IsSelected, SalesRep_ID, DateOrdered, DatePromised, DateAcct, C_BPartner_ID, BillTo_ID, C_BPartner_Location_ID, IsDiscountPrinted, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, InvoiceRule, DeliveryRule, FreightCostRule, DeliveryViaRule, ChargeAmt, PriorityRule, TotalLines, GrandTotal, M_Warehouse_ID, M_PriceList_ID, IsTaxIncluded, Posted, AD_User_ID, CopyFrom, IsSelfService, AD_OrgTrx_ID, Generatetemplate, CopyFromPO, FIN_Paymentmethod_ID, RM_PickFromShipment, RM_ReceiveMaterials, RM_CreateInvoice, RM_AddOrphanLine, Calculate_Promotions, Convertquotation, Create_POLines, EM_Obdisc_Addpack, Iscashvat, EM_OBMFM_Selectfreight, RM_Pickfromreceipt, Cancelandreplace, EM_APRM_AddPayment, Confirmcancelandreplace, EM_Obwpl_Generatepicking, EM_Obwpl_Isinpickinglist, EM_Fash_Sendbeforedate, EM_Obwpl_Readypl, EM_Poss_Businessdate, Iscancelled, EM_OBMFM_Set_Weight, EM_Obpos_Applications_ID, EM_Obpos_Sendemail, EM_Obpos_App_Cashup_ID, EM_Obpos_Createdabsolute, EM_OBPOS_NotInvoiceOnCashUp, EM_Obpos_Isdeleted, EM_Obpos_Islayaway, EM_Obpos_Prepaymentamt, EM_Obpos_Prepaymentlimitamt, EM_Obpos_Prepaymentlaylimitamt, EM_Obpos_Rounding_Amount, EM_Obpos_Sequencename, EM_Obpos_Sequencenumber, EM_Prpp_Generatepicking, EM_Api_Resend, EM_Prouti_Order_Stock, EM_Prouti_Pregenerate_Minout, EM_Prouti_Sotopo, EM_Prouti_Generate_Pick_Inv, EM_Prouti_Changebpartner, EM_Prouti_Recalculate_Price, EM_Prouti_Reactiveorder, EM_Izi_Exported, EM_Izijoy_Export_Enjoy, EM_Izi_Splio_Exported, em_prouti_Invoiced, em_prouti_Received, em_prouti_initial_received, EM_Prouti_Status_Of_Review, EM_Prouti_Validate_Order, EM_Prouti_Start_Review, EM_Obpos_Skip_Tax_Calculation, EM_Prouti_Addlines_Btn, EM_Avisver_Export, EM_Prouti_Select_Soline, EM_Prgr_Assign, C_Order_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108)
70caf7bb1einsert into OBCFR_TicketTax (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Obcfr_Ticket_ID, Obpos_Applications_ID, Taxrate, Taxbase, Taxamt, Prevhash, Hash, Hashtime, Documentno, Terminal, Seqno, Export, Obcfr_Tickettax_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20)
fe62dd3708INSERT INTO m_stock_proposed ( m_stock_proposed_id, ad_client_id, ad_org_id, isactive, created , createdby, updated, updatedby, ad_pinstance_id, priority, m_storage_detail_id, quantity, qtyorder, isfinal ) VALUES ( get_uuid(), v_ClientID, v_OrgID, 'Y', TO_DATE(NOW()), v_AD_User_ID, TO_DATE(NOW()), v_AD_User_ID, p_uuid, v_Count, Cur_Stock.M_STORAGE_DETAIL_ID, Cur_Stock.Qty, Cur_Stock.QtyOrder, 'Y' )
50e85a5d5eSELECT * FROM M_GET_STOCK_PARAM($1, $2, TO_NUMBER($3), $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, TO_NUMBER($17), $18, $19, $20, $21, $22, $23)

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
openbravopg_defaultpublicc_order85 GB93101594584931586684479152
c_order(TOAST)
openbravopg_defaultpublicad_user30 GB2824049461040499116271311264
ad_user(TOAST)
openbravopg_defaultpublicc_bpartner29 GB176161281121043525274221
c_bpartner(TOAST)
openbravopg_defaultpublicad_table16 GB1520913137228269712
ad_table(TOAST)
openbravopg_defaultpublicfin_payment15 GB2418978188758102486713
fin_payment(TOAST)
openbravopg_defaultpublicad_column14 GB218011518228426024035
ad_column(TOAST)
openbravopg_defaultpublicad_orgtype13 GB17320068181
openbravopg_defaultpublicfin_payment_schedule10 GB2457265236048859124012379190
fin_payment_schedule(TOAST)
openbravopg_defaultpublicm_transaction8616 MB142006144809342375
m_transaction(TOAST)
openbravopg_defaultpg_catalogpg_class8227 MB899013732891100377166640169510
openbravopg_defaultpublicm_inout7443 MB1751669189651669255582786023
m_inout(TOAST)43426607925261
openbravopg_defaultpublicm_product5271 MB91832130743641886
m_product(TOAST)
openbravopg_defaultprofilelast_stat_database4807 MB1230669292
openbravopg_defaultpublicc_invoice3914 MB15269456606852446504
c_invoice(TOAST)
openbravopg_defaultpublicm_inoutline3904 MB622428326541607124318718701
m_inoutline(TOAST)
openbravopg_defaultpg_catalogpg_constraint3793 MB12881565751480871118118
pg_constraint(TOAST)
openbravopg_defaultpublicc_orderline3546 MB393364339896594150338331220
c_orderline(TOAST)
openbravopg_defaultpublicc_location3520 MB521639069335033521261263
c_location(TOAST)
openbravopg_defaultprofilelast_stat_tablespaces1952 MB416464444
last_stat_tablespaces(TOAST)
openbravopg_defaultpg_catalogpg_proc1814 MB927869501272051013810123
pg_proc(TOAST)5842154281616

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicm_inout51768978315.02155657297045.16202560.001131360.00
openbravopg_defaultpublicm_inoutline52410906615.21713681482.07
openbravopg_defaultpublicad_user444568541.291217782453.53
openbravopg_defaultpublicc_bpartner_location353548491.03524335931.52
openbravopg_defaultpublicc_location354850091.03493764291.43
openbravopg_defaultpublicc_order510619951.48333871720.97
openbravopg_defaultpublicad_org284246550.82281873230.82264960.00796620.00
openbravopg_defaultpublicc_orderline328045270.9542858950.12
openbravopg_defaultpublicc_bpartner248169970.7252227820.15
openbravopg_defaultpublicc_country143101730.42143097280.42
openbravopg_defaultpublicm_costing277329480.80
openbravopg_defaultpublicfin_payment_schedule74193420.22172437530.50
openbravopg_defaultpublicm_product42744220.1267389770.20
openbravopg_defaultpublicm_matchpo25785860.0777742360.23
openbravopg_defaultpublicfin_payment_detail85820290.25975760.00
openbravopg_defaultpublicfin_payment_scheduledetail57637350.171456470.00
openbravopg_defaultpublicm_storage_detail44621640.1311397950.03
openbravopg_defaultpublicc_import_entry38151220.1111133250.031004410.002346840.01
openbravopg_defaultpg_catalogpg_class20905130.0627702880.08
openbravopg_defaultpg_catalogpg_type10502030.0337983410.11

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicc_invoiceline1000.17656811.2899.54
openbravopg_defaultpublicobmobc_logclient26534.5619803.4099.55
openbravopg_defaultpublicc_orderline2660.4632355.5699.99
openbravopg_defaultpublicc_orderlinetax790.1431075.3493.61
openbravopg_defaultpublicc_import_entry_archive2560.442330.4025764.42900.1599.76
openbravopg_defaultpublicad_treenode10.0030455.2399.65
openbravopg_defaultpublicfin_finacc_transaction820.1427554.7398.84
openbravopg_defaultpublicm_inoutline1830.3122433.85100.00
openbravopg_defaultpublicfin_payment_scheduledetail640.1122563.8899.96
openbravopg_defaultpublicm_transaction1260.2219923.4299.88
openbravopg_defaultpublicc_invoicelinetax600.1019493.3590.83
openbravopg_defaultpublicobcfr_ticketreprint1930.3315722.7080.0199.15
openbravopg_defaultpublicobcfr_tickettax610.1013922.3993.61
openbravopg_defaultpublicm_matchpo390.0714132.4399.99
openbravopg_defaultpublicm_inout890.1512192.09620.11120.02100.00
openbravopg_defaultpublicobcfr_ticket1820.3111541.9830.0199.33
openbravopg_defaultpublicc_ordertax440.0811021.8992.31
openbravopg_defaultpublicc_order1810.319071.56100.00
openbravopg_defaultpublicfin_payment1540.267871.3599.96
openbravopg_defaultpublicc_import_entry2510.4310.005630.9799.98

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
openbravopg_defaultprofilelast_stat_indexes67294157467295184107671241149405338
openbravopg_defaultprofilelast_stat_tables392304176392323318663451291794109668
openbravopg_defaultpublicc_import_entry811981198119383344219996
c_import_entry(TOAST)12159121591910461750
openbravopg_defaultpublicobmobc_logclient45005
obmobc_logclient(TOAST)
openbravopg_defaultprofilelast_stat_user_functions9039994903945388268812
last_stat_user_functions(TOAST)
openbravopg_defaultpg_catalogpg_statistic12608211657338741282236
pg_statistic(TOAST)180618043091264430
openbravopg_defaultpublicc_import_entry_archive339011309668097
c_import_entry_archive(TOAST)11279101957436517
openbravopg_defaultpg_catalogpg_depend71087115442773453642
openbravopg_defaultpg_catalogpg_attribute340246643421204331447742195557916
openbravopg_defaultpublicad_message_trl201134611223408021213411439
ad_message_trl(TOAST)
openbravopg_defaultpublicad_element_trl814971454945082158167
ad_element_trl(TOAST)
openbravopg_defaultprofilesample_stat_tables3823404715398605
openbravopg_defaultpublicc_orderline1503383312203586361793364339896594
c_orderline(TOAST)
openbravopg_defaultpublicad_textinterfaces_trl4610311314982100465360
ad_textinterfaces_trl(TOAST)
openbravopg_defaultpublicm_storage_detail264119939755437131047914837791
m_storage_detail(TOAST)
openbravopg_defaultpublicm_inoutline3187187016899053322428326541607124
m_inoutline(TOAST)
openbravopg_defaultpublicad_ref_list_trl39705982996840263987
ad_ref_list_trl(TOAST)
openbravopg_defaultpublicfin_payment810248671324171208171897818875
fin_payment(TOAST)
openbravopg_defaultpublicfin_payment_scheduledetail8112442785193185725347
fin_payment_scheduledetail(TOAST)
openbravopg_defaultpg_catalogpg_rewrite1842184117811393
pg_rewrite(TOAST)1408140810576244

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
openbravopg_defaultprofilelast_stat_indexes157467295374623
openbravopg_defaultprofilelast_stat_tables41763339232374623
openbravopg_defaultpublicc_import_entry8119811972105
c_import_entry(TOAST)1215953
openbravopg_defaultpg_catalogpg_statistic126081165721
pg_statistic(TOAST)18046
openbravopg_defaultpublicad_message_trl11346112222
ad_message_trl(TOAST)
openbravopg_defaultprofilelast_stat_user_functions994459039374623
last_stat_user_functions(TOAST)
openbravopg_defaultpublicad_element_trl814971422
ad_element_trl(TOAST)
openbravopg_defaultpg_catalogpg_attribute4664204342112
openbravopg_defaultpg_catalogpg_depend71151
openbravopg_defaultpublicad_textinterfaces_trl461031111
ad_textinterfaces_trl(TOAST)
openbravopg_defaultpublicm_storage_detail41199391
m_storage_detail(TOAST)
openbravopg_defaultprofilesample_stat_tables40472
openbravopg_defaultpublicad_ref_list_trl397059811
ad_ref_list_trl(TOAST)
openbravopg_defaultpublicc_orderline38331220
c_orderline(TOAST)
openbravopg_defaultpublicfin_payment2486713
fin_payment(TOAST)
openbravopg_defaultpublicfin_payment_scheduledetail2442785
fin_payment_scheduledetail(TOAST)
openbravopg_defaultpublicad_sequence2440241520
ad_sequence(TOAST)
openbravopg_defaultpg_catalogpg_trigger1704284721
pg_trigger(TOAST)
openbravopg_defaultpublicobpos_applications19821933734
obpos_applications(TOAST)
openbravopg_defaultpublicad_tab_trl192537711
ad_tab_trl(TOAST)

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
openbravopg_defaultpg_catalogpg_attribute6400 kB1072 kB340246643421204
openbravopg_defaultpublicad_textinterfaces_trl1424 kB664 kB4610311
ad_textinterfaces_trl(TOAST)
openbravopg_defaultpg_catalogpg_trigger3200 kB352 kB472170447228
pg_trigger(TOAST)
openbravopg_defaultpublicad_process_run3136 kB120 kB248248
ad_process_run(TOAST)992 kB32 kB19
openbravopg_defaultpg_catalogpg_proc2056 kB80 kB1013810123
pg_proc(TOAST)1040 kB56 kB1616
openbravopg_defaultpg_catalogpg_class1024 kB136 kB166640169510
openbravopg_defaultpublicad_module256 kB128 kB226526
ad_module(TOAST)
openbravopg_defaultpublicc_location68 MB128 kB261263
c_location(TOAST)
openbravopg_defaultpg_catalogpg_type640 kB56 kB332335
openbravopg_defaultpublicobcfr_terminalmonitor80 MB48 kB76
openbravopg_defaultprofilelast_stat_cluster40 kB32 kB2323
openbravopg_defaultprofilelast_stat_archiver48 kB32 kB2323
last_stat_archiver(TOAST)
openbravopg_defaultprofilefuncs_list88 kB32 kB295
funcs_list(TOAST)
openbravopg_defaultpublicad_process_request128 kB16 kB378365
ad_process_request(TOAST)120 kB
openbravopg_defaultprofilelast_stat_user_functions248 kB16 kB9039994903945
last_stat_user_functions(TOAST)
openbravopg_defaultprofilesample_stat_tablespaces64 kB8192 bytes2024
openbravopg_defaultprofileindexes_list136 kB8192 bytes3811
openbravopg_defaultprofilesample_statements_total160 kB8192 bytes2727
sample_statements_total(TOAST)
openbravopg_defaultprofilesample_stat_user_func_total64 kB8192 bytes2024

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
openbravopg_defaultpublicm_inoutm_inout_key516675983155646656245.16
openbravopg_defaultpublicad_userad_user_partner403686151213947423.52
openbravopg_defaultpublicm_inoutlinem_inoutline_orderline21735630656013471.90
openbravopg_defaultpublicc_bpartner_locationc_bplocation_bpartner17337402521345701.51
openbravopg_defaultpublicc_locationc_location_key16388205493670401.43
openbravopg_defaultpublicc_orderc_order_key10148875306496870.89
openbravopg_defaultpublicad_orgad_org_key28182463281816300.82
openbravopg_defaultpublicm_costingm_costing_product_date27732012277322460.80
openbravopg_defaultpublicfin_payment_schedulefin_payment_schedule_key5716959171957260.50
openbravopg_defaultpublicc_countryc_country_key14309272143094240.42
openbravopg_defaultpublicm_matchpom_matchpo_inout257970477588340.23
openbravopg_defaultpublicm_productm_product_key320133464273920.19
openbravopg_defaultpublicm_inoutlinem_inoutline_product63464855362430.16
openbravopg_defaultpublicc_bpartnerc_bpartner_key159049747813290.14
openbravopg_defaultpg_catalogpg_typepg_type_oid_index188276537701860.11
openbravopg_defaultpublicc_orderlineem_obpos_orderedqty64924827794670.08
openbravopg_defaultpg_catalogpg_classpg_class_oid_index125079825148800.07
openbravopg_defaultpublicc_orderc_order_client_org_date_docno20024286920.07
openbravopg_defaultpublicc_country_trlc_country_trl_country_langu_un102353220470800.06
openbravopg_defaultpg_catalogpg_collationpg_collation_oid_index84962816992580.05

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
openbravopg_defaultpublicc_invoicelinec_invoiceline_orderline35431036766.3199.66
openbravopg_defaultpublicad_treenodead_treenode_tree_node_un62630425.2368.55
openbravopg_defaultpublicfin_finacc_transactionfin_finacc_transaction_key2319218483.1797.53
openbravopg_defaultpublicm_inoutlinem_inoutline_key1384818473.1796.40
openbravopg_defaultpublicm_transactionm_transaction_key15492.6678.12
openbravopg_defaultpublicc_invoicelinec_invoiceline_inoutline174014412.4884.65
openbravopg_defaultpublicc_orderlinetaxc_orderlinetax_orderline417113622.3494.02
openbravopg_defaultpublicc_orderlinetaxc_orderlinetax_key10411.7982.75
openbravopg_defaultpublicc_orderlinec_orderline_product2456438481.4699.92
openbravopg_defaultpublicc_invoicelinetaxc_invoicelinetax_invoiceline8091.3980.11
openbravopg_defaultpublicc_invoicelinec_invoiceline_key13638081.3990.09
openbravopg_defaultpublicc_invoicelinetaxc_invoicelinetax_key7671.3281.14
openbravopg_defaultpublicm_matchpom_matchpo_ship8827531.2989.28
openbravopg_defaultpublicc_orderlineem_obpos_deliveredqty7521.2995.58
openbravopg_defaultpublicc_orderlinec_orderline_order27511.2995.59
openbravopg_defaultpublicc_orderlinec_orderline_order7491.2995.61
openbravopg_defaultpublicm_matchpom_matchpo_key6571.1374.88
openbravopg_defaultpublicc_orderlinetaxc_orderlinetax_orderid6401.1088.30
openbravopg_defaultpublicfin_payment_scheduledetailfin_pay_scheduledetail_in12215811.0092.50
openbravopg_defaultpublicobcfr_tickettaxobcfr_tickettax_term_hash5790.9981.90

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
openbravopg_defaultpublicad_textinterfaces_trlad_textinterfaces_trl_un_key592 kB328 kB4299
openbravopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index976 kB152 kB340244603421
openbravopg_defaultpg_catalogpg_triggerpg_trigger_tgrelid_tgname_index1112 kB32 kB4721676472
openbravopg_defaultprofilesample_statementspk_sample_statements_n624 kB24 kB489452
openbravopg_defaultpublicad_process_runad_process_run_status272 kB24 kB172172
openbravopg_defaultprofilelast_stat_indexespk_last_stat_indexes504 kB8192 bytes67294157467295
openbravopg_defaultpg_catalogpg_classpg_class_oid_index128 kB8192 bytes166130169
openbravopg_defaultprofilesample_stat_user_functionspk_sample_stat_user_functions336 kB8192 bytes223335

Unused indexes

This table contains non-scanned indexes (during report period), ordered by number of DML operations on underlying tables. Constraint indexes are excluded.

DBTablespacesSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
openbravopg_defaultpublicad_process_runad_process_run_ould_be_killed8192 bytes153153

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicm_get_cost138660062148.5775.340.0000.000
openbravopublicm_get_cost138660062073.23190.850.0000.000
openbravopublicm_get_no_trx_product_cost138660061322.2667.640.0000.000
openbravopublicm_get_no_trx_product_cost138660061254.62954.460.0000.000
openbravopublicm_get_product_cost13866006359.80359.800.0000.000
openbravopublicad_get_org_le_bu13663312300.21300.210.0000.000
openbravopublictrunc17453447178.35178.350.0000.000
openbravopublicto_date13881830108.44108.440.0000.000
openbravopublicretstk_product_stock_json1519101.3487.390.0670.058
openbravopublicc_currency_convert_precision1386600692.0792.070.0000.000
openbravoprofiletake_sample2347.400.032.0610.001
openbravoprofiletake_sample_subset2347.380.092.0600.004
openbravoprofiletake_sample2347.282.492.0560.108
openbravopublicretstk_product_stock_json_loc151942.8428.960.0280.019
openbravopublicsubstract_days2842803937.6637.660.0000.000
openbravopublicad_column_identifier6638336.3535.930.0010.001
openbravopublicad_column_identifier_std6344335.842.000.0010.000
openbravoprofiledblink62132.6532.650.0530.053
openbravopublicretstk_basic_json4553222.180.750.0000.000
openbravopublicretstk_basic_json_lang4553221.430.890.0000.000

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicsubstract_days2842803937.6637.660.0000.000
openbravopublictrunc17453447178.35178.350.0000.000
openbravopublicto_date13881830108.44108.440.0000.000
openbravopublicc_currency_convert_precision1386600692.0792.070.0000.000
openbravopublicm_get_cost138660062148.5775.340.0000.000
openbravopublicm_get_cost138660062073.23190.850.0000.000
openbravopublicm_get_no_trx_product_cost138660061322.2667.640.0000.000
openbravopublicm_get_no_trx_product_cost138660061254.62954.460.0000.000
openbravopublicm_get_product_cost13866006359.80359.800.0000.000
openbravopublicad_get_org_le_bu13663312300.21300.210.0000.000
openbravopublictrunc10477783.883.880.0000.000
openbravopublicto_char2600040.700.700.0000.000
openbravopublicto_char1818420.500.500.0000.000
openbravopublicad_istriggerenabled1519581.361.360.0000.000
openbravopublicad_isorgincluded803811.751.750.0000.000
openbravopublicad_column_identifier6638336.3535.930.0010.001
openbravopublicad_column_identifier_std6344335.842.000.0010.000
openbravoinformation_schema_pg_truetypid544440.420.420.0000.000
openbravoinformation_schema_pg_truetypmod544440.270.270.0000.000
openbravopublicto_number523640.450.450.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicintr_m_inoutline_trg28832.300.180.0010.000
openbravopublicm_inoutline_trg37531.310.550.0000.000
openbravopublicm_transaction_trg23460.790.360.0000.000
openbravopublicc_orderline2_trg53360.750.680.0000.000
openbravopublicfash_orderline_check_status53360.560.530.0000.000
openbravopublicc_ordline_chk_restrictions_trg53360.400.370.0000.000
openbravopublicc_bpartner_trg3220.320.300.0010.001
openbravopublicc_orderline_trg253360.300.250.0000.000
openbravopublicm_matchpo_trg8700.300.120.0000.000
openbravopublicfash_copy_c_orderline53360.280.120.0000.000
openbravopublicad_process_trl_trg5960.280.260.0000.000
openbravopublicfash_update_fshordline_trg53360.270.240.0000.000
openbravopublicaprm_fin_pmt_check_trg32240.270.210.0000.000
openbravopublicm_ioline_chk_restrictions_trg32190.250.200.0000.000
openbravopublicphieco_orderline_trg53360.230.200.0000.000
openbravopublicc_orderline_trg53360.230.190.0000.000
openbravopublicm_storage_detail_trg39810.210.170.0000.000
openbravopublicaprm_fin_pmt_detail_check_trg15960.200.180.0000.000
openbravopublicintr_c_orderline_trg53360.200.170.0000.000
openbravopublicad_table_mod_trg9710.190.160.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
openbravopg_defaultpublicc_import_entry72811981198119
openbravopg_defaultprofilelast_stat_tables373923041763923233
openbravopg_defaultprofilelast_stat_indexes3767294157467295
openbravopg_defaultprofilelast_stat_user_functions379039994903945
openbravopg_defaultpublicad_ep_instance_para12160160
openbravopg_defaultpublicobpos_applications719821933
openbravopg_defaultpublicad_element_trl28149714
openbravopg_defaultpublicad_message_trl220113461122
openbravopg_defaultprofilelast_stat_database29292
openbravopg_defaultpg_catalogpg_attribute1340246643421204
openbravopg_defaultpg_catalogpg_rewrite118421841
openbravopg_defaultpg_catalogpg_statistic112608211657
openbravopg_defaultpublicad_fieldgroup_trl1244124
openbravopg_defaultpublicad_menu_trl12900218
openbravopg_defaultpublicad_module1226526
openbravopg_defaultpublicad_process_trl12596141
openbravopg_defaultpublicad_ref_list_trl13970598
openbravopg_defaultpublicad_reference_trl11680389
openbravopg_defaultpublicad_tab_trl11925377
openbravopg_defaultpublicad_table19712

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
openbravopg_defaultpublicc_import_entry105811981198119
openbravopg_defaultprofilelast_stat_tables46233923041763923233
openbravopg_defaultprofilelast_stat_indexes462367294157467295
openbravopg_defaultprofilelast_stat_user_functions46239039994903945
openbravopg_defaultpublicobpos_applications3419821933
openbravopg_defaultprofilelast_stat_tablespaces224444
openbravopg_defaultpublicad_sequence2024402415
openbravopg_defaultpublicad_process_request9378365
openbravopg_defaultpublicfin_financial_account9850849
openbravopg_defaultpublicad_ep_instance_para5160160
openbravopg_defaultprofilelast_stat_database49292
openbravopg_defaultpublicad_module3226526
openbravopg_defaultprofilesample_stat_user_functions3544735
openbravopg_defaultpg_catalogpg_attribute2340246643421204
openbravopg_defaultpg_catalogpg_rewrite218421841
openbravopg_defaultpublicad_element_trl28149714
openbravopg_defaultpublicad_message_trl220113461122
openbravopg_defaultpublicad_session249214152
openbravopg_defaultprofilesample_stat_tables238234047
openbravopg_defaultprofilesample_stat_tables_total296104

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
openbravopg_defaultprofilelast_stat_indexespk_last_stat_indexes18 MB37501 kB1936 kB
openbravopg_defaultpublicc_import_entryc_import_entry_key14 MB72192 kB1308 kB
openbravopg_defaultpublicc_import_entryc_import_entry_type_status_idx13 MB72184 kB1308 kB
openbravopg_defaultprofilelast_stat_tablespk_last_stat_tables11 MB37304 kB1478 kB
openbravopg_defaultpublicc_import_entryc_import_entry_idx9216 kB72128 kB1308 kB
openbravopg_defaultpublicc_import_entryem_obpos_application_fk8952 kB72124 kB1308 kB
openbravopg_defaultpublicc_import_entry(TOAST)pg_toast_53108_index5512 kB53104 kB1902 kB
openbravopg_defaultpublicad_message_trlad_message_trl_key3184 kB21592 kB3816 kB
openbravopg_defaultpublicad_message_trlad_message_trl_message_lang_un2912 kB21456 kB3816 kB
openbravopg_defaultpublicad_element_trlad_element_trl_key2288 kB21144 kB3800 kB
openbravopg_defaultpublicad_element_trlad_element_trl_element_lang_un2000 kB21000 kB3800 kB
openbravopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index1544 kB11544 kB6400 kB
openbravopg_defaultprofilesample_statementsix_sample_stmts_qid1208 kB11208 kB3328 kB
openbravopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index976 kB1976 kB6400 kB
openbravopg_defaultprofilesample_statementspk_sample_statements_n624 kB1624 kB3328 kB
openbravopg_defaultpublicad_textinterfaces_trlad_textinterfaces_trl_key592 kB1592 kB1424 kB
openbravopg_defaultpublicad_textinterfaces_trlad_textinterfaces_trl_un_key592 kB1592 kB1424 kB
openbravopg_defaultpublicad_ref_list_trlad_ref_list_trl_key584 kB1584 kB1480 kB
openbravopg_defaultpublicad_ref_list_trlad_ref_list_trl_ref_list_la_un520 kB1520 kB1480 kB
openbravopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index480 kB596 kB5264 kB

Top tables by dead tuples ratio

Data in this section is not differential. This data is valid for last report sample only.

DBSchemaTableLiveDead%DeadLast AVSize
openbravoprofilesample_stat_tables314176319162026-07-13 15:00:45.960183+029928 kB
openbravopg_toastpg_toast_26191857602026-07-15 02:00:14.947814+025264 kB
openbravopublicc_location339271948068 MB

Top tables by modified tuples ratio

Table shows modified tuples statistics since last analyze.

Data in this section is not differential. This data is valid for last report sample only.

DBSchemaTableLiveDeadMod%ModLast AASize
openbravoprofilesample_stat_tables314176319256862026-07-14 19:00:08.524875+029928 kB
openbravopublicc_location339271948189002025-11-13 15:11:45.991636+0168 MB
openbravopublicobcfr_terminalmonitor1903890542080 MB

Cluster settings during the report interval

Defined settings
Settingreset_valUnitSourceNotes
checkpoint_completion_target0.9/etc/postgresql/10/main/postgresql.conf:211
client_encodingUTF8
cluster_name10/main/etc/postgresql/10/main/postgresql.conf:477
config_file/etc/postgresql/10/main/postgresql.conf
data_checksumson
data_directory/var/lib/postgresql/10/main
DateStyleISO, DMY/etc/postgresql/10/main/postgresql.conf:566
default_text_search_configpg_catalog.spanish/etc/postgresql/10/main/postgresql.conf:588
effective_cache_size98304008kB/etc/postgresql/10/main/postgresql.conf:315
effective_io_concurrency200/etc/postgresql/10/main/postgresql.conf:164
external_pid_file/var/run/postgresql/10-main.pid/etc/postgresql/10/main/postgresql.conf:49
hba_file/etc/postgresql/10/main/pg_hba.conf
ident_file/etc/postgresql/10/main/pg_ident.conf
lc_collatees_ES.UTF-8
lc_ctypees_ES.UTF-8
lc_messagesen_US.UTF-8/etc/postgresql/10/main/conf.d/15-pgbadger.conf:11
lc_monetaryes_ES.UTF-8/etc/postgresql/10/main/postgresql.conf:583
lc_numericen_US.UTF-8/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:38
lc_timees_ES.UTF-8/etc/postgresql/10/main/postgresql.conf:585
listen_addresses*/etc/postgresql/10/main/postgresql.conf:59
log_autovacuum_min_duration0ms/etc/postgresql/10/main/conf.d/15-pgbadger.conf:9
log_checkpointson/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:26
log_connectionson/etc/postgresql/10/main/conf.d/15-pgbadger.conf:1
log_disconnectionson/etc/postgresql/10/main/conf.d/15-pgbadger.conf:2
log_line_prefix%t [%p]:[%l-1] db=%d,user=%u,app=%a,client=%h/etc/postgresql/10/main/conf.d/15-pgbadger.conf:4
log_lock_waitson/etc/postgresql/10/main/conf.d/15-pgbadger.conf:5
log_min_duration_statement1000ms/etc/postgresql/10/main/conf.d/15-pgbadger.conf:10
log_temp_files0kB/etc/postgresql/10/main/conf.d/15-pgbadger.conf:7
log_timezonelocaltime/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:22
maintenance_work_mem2097152kB/etc/postgresql/10/main/postgresql.conf:123
max_connections200/etc/postgresql/10/main/postgresql.conf:64
max_locks_per_transaction128/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:17
max_stack_depth2048kB
min_wal_size4096MB/etc/postgresql/10/main/postgresql.conf:210
pg_conf_load_time2026-07-12 03:00:05.386027+02
pg_postmaster_start_time2026-07-12 03:00:05.961796+02
pg_stat_statements.max10000/etc/postgresql/10/main/postgresql.conf:660
pg_stat_statements.trackall/etc/postgresql/10/main/postgresql.conf:661
random_page_cost1.1/etc/postgresql/10/main/postgresql.conf:307
server_encodingUTF8
shared_buffers32768008kB/etc/postgresql/10/main/postgresql.conf:113
shared_preload_libraries$libdir/pg_stat_statements/etc/postgresql/10/main/postgresql.conf:659
sslon/etc/postgresql/10/main/postgresql.conf:79
ssl_cert_file/etc/ssl/certs/ssl-cert-snakeoil.pem/etc/postgresql/10/main/postgresql.conf:84
ssl_key_file/etc/ssl/private/ssl-cert-snakeoil.key/etc/postgresql/10/main/postgresql.conf:85
stats_temp_directory/var/run/postgresql/10-main.pg_stat_tmp/etc/postgresql/10/main/postgresql.conf:493
TimeZonelocaltime/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:23
timezone_abbreviationsDefault
track_functionsall/etc/postgresql/10/main/conf.d/15-pgbadger.conf:8
versionPostgreSQL 10.23 (Ubuntu 10.23-0ubuntu0.18.04.2) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
wal_buffers20488kB/etc/postgresql/10/main/postgresql.conf:198
work_mem32768kB/etc/postgresql/10/main/postgresql.conf:122
Default settings
Settingreset_valUnitSourceNotes
allow_in_place_tablespacesoff
allow_system_table_modsoff
application_name
archive_command
archive_modeoff
archive_timeout0s
array_nullson
authentication_timeout60s
autovacuumon
autovacuum_analyze_scale_factor0.1
autovacuum_analyze_threshold50
autovacuum_freeze_max_age200000000
autovacuum_max_workers3
autovacuum_multixact_freeze_max_age400000000
autovacuum_naptime60s
autovacuum_vacuum_cost_delay20ms
autovacuum_vacuum_cost_limit-1
autovacuum_vacuum_scale_factor0.2
autovacuum_vacuum_threshold50
autovacuum_work_mem-1kB
backend_flush_after08kB
backslash_quotesafe_encoding
bgwriter_delay200ms
bgwriter_flush_after648kB
bgwriter_lru_maxpages100
bgwriter_lru_multiplier2
block_size8192
bonjouroff
bonjour_name
bytea_outputhex
check_function_bodieson
checkpoint_flush_after328kB
checkpoint_timeout300s
checkpoint_warning30s
client_min_messagesnotice
commit_delay0
commit_siblings5
constraint_exclusionpartition
cpu_index_tuple_cost0.005
cpu_operator_cost0.0025
cpu_tuple_cost0.01
cursor_tuple_fraction0.1
data_sync_retryoff
db_user_namespaceoff
deadlock_timeout1000ms
debug_assertionsoff
debug_pretty_printon
debug_print_parseoff
debug_print_planoff
debug_print_rewrittenoff
default_statistics_target100/etc/postgresql/10/main/postgresql.conf:329
default_tablespace
default_transaction_deferrableoff
default_transaction_isolationread committed
default_transaction_read_onlyoff
default_with_oidsoff
dynamic_library_path$libdir
dynamic_shared_memory_typeposix/etc/postgresql/10/main/postgresql.conf:127
enable_bitmapscanon
enable_gathermergeon
enable_hashaggon
enable_hashjoinon
enable_indexonlyscanon
enable_indexscanon
enable_materialon
enable_mergejoinon
enable_nestloopon
enable_seqscanon
enable_sorton
enable_tidscanon
escape_string_warningon
event_sourcePostgreSQL
exit_on_erroroff
extra_float_digits0
force_parallel_modeoff
from_collapse_limit8
fsyncon
full_page_writeson
geqoon
geqo_effort5
geqo_generations0
geqo_pool_size0
geqo_seed0
geqo_selection_bias2
geqo_threshold12
gin_fuzzy_search_limit0
gin_pending_list_limit4096kB
hot_standbyon
hot_standby_feedbackoff
huge_pagestry
idle_in_transaction_session_timeout0ms
ignore_checksum_failureoff
ignore_system_indexesoff
integer_datetimeson
IntervalStylepostgres
join_collapse_limit8
krb_caseins_usersoff
krb_server_keyfileFILE:/etc/postgresql-common/krb5.keytab
local_preload_libraries
lock_timeout0ms
lo_compat_privilegesoff
log_destinationstderr
log_directorylog
log_durationoff/etc/postgresql/10/main/conf.d/15-pgbadger.conf:3
log_error_verbositydefault
log_executor_statsoff
log_file_mode384
log_filenamepostgresql-%Y-%m-%d_%H%M%S.log
logging_collectoroff
log_hostnameoff
log_min_error_statementerror
log_min_messageswarning
log_parser_statsoff
log_planner_statsoff
log_replication_commandsoff
log_rotation_age1440min
log_rotation_size10240kB
log_statementnone/etc/postgresql/10/main/conf.d/15-pgbadger.conf:6
log_statement_statsoff
log_truncate_on_rotationoff
max_files_per_process1000
max_function_args100
max_identifier_length63
max_index_keys32
max_logical_replication_workers4
max_parallel_workers8
max_parallel_workers_per_gather2
max_pred_locks_per_page2
max_pred_locks_per_relation-2
max_pred_locks_per_transaction64
max_prepared_transactions0
max_replication_slots10
max_standby_archive_delay30000ms
max_standby_streaming_delay30000ms
max_sync_workers_per_subscription2
max_wal_senders10
max_wal_size1024MB/etc/postgresql/10/main/postgresql.conf:209
max_worker_processes8
min_parallel_index_scan_size648kB
min_parallel_table_scan_size10248kB
old_snapshot_threshold-1min
operator_precedence_warningoff
parallel_setup_cost1000
parallel_tuple_cost0.1
password_encryptionmd5
pg_profile.topn20
pg_stat_statements.saveon
pg_stat_statements.track_utilityon
port5432/etc/postgresql/10/main/postgresql.conf:63
post_auth_delay0s
pre_auth_delay0s
quote_all_identifiersoff
replacement_sort_tuples150000
restart_after_crashon
row_securityon
search_path"$user", public
segment_size1310728kB
seq_page_cost1
server_version10.23 (Ubuntu 10.23-0ubuntu0.18.04.2)
server_version_num100023
session_preload_libraries
session_replication_roleorigin
ssl_ca_file
ssl_ciphersHIGH:MEDIUM:+3DES:!aNULL
ssl_crl_file
ssl_dh_params_file
ssl_ecdh_curveprime256v1
ssl_prefer_server_cipherson
standard_conforming_stringson
statement_timeout0ms
superuser_reserved_connections3
synchronize_seqscanson
synchronous_commiton
synchronous_standby_names
syslog_facilitylocal0
syslog_identpostgres
syslog_sequence_numberson
syslog_split_messageson
system_identifier7083440090454890352
tcp_keepalives_count0
tcp_keepalives_idle0s
tcp_keepalives_interval0s
temp_buffers10248kB
temp_file_limit-1kB
temp_tablespaces
trace_notifyoff
trace_recovery_messageslog
trace_sortoff
track_activitieson
track_activity_query_size1024
track_commit_timestampoff
track_countson
track_io_timingoff
transaction_deferrableoff
transaction_isolationdefault
transaction_read_onlyoff
transform_null_equalsoff
unix_socket_directories/var/run/postgresql/etc/postgresql/10/main/postgresql.conf:66
unix_socket_group
unix_socket_permissions511
update_process_titleon
vacuum_cost_delay0ms
vacuum_cost_limit200
vacuum_cost_page_dirty20
vacuum_cost_page_hit1
vacuum_cost_page_miss10
vacuum_defer_cleanup_age0
vacuum_freeze_min_age50000000
vacuum_freeze_table_age150000000
vacuum_multixact_freeze_min_age5000000
vacuum_multixact_freeze_table_age150000000
wal_block_size8192
wal_compressionoff
wal_consistency_checking
wal_keep_segments0
wal_levelreplica
wal_log_hintsoff
wal_receiver_status_interval10s
wal_receiver_timeout60000ms
wal_retrieve_retry_interval5000ms
wal_segment_size20488kB
wal_sender_timeout60000ms
wal_sync_methodfdatasync
wal_writer_delay200ms
wal_writer_flush_after1288kB
xmlbinarybase64
xmloptioncontent
zero_damaged_pagesoff