Postgres profile report (StartID: 476, EndID: 499)

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-19 04:00:02+02 - 2026-07-20 03:00:02+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
openbravo104965124499.991916193233812389175512542313332526812270745264314627523 GB1725186720 GB101 MB
postgres11705100.00765837819016673480486383 kB
Total116670124499.991916263234470767175702709013336007292270745264314627523 GB1725186720 GB101 MB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
openbravo5744819817465.455.853344777011350185369132251966450415866
postgres561210.8086779345
template163486.157176276
Total5746015817482.395.853344870966350185369132251966450416487

Cluster statistics

MetricValue
Scheduled checkpoints276
Requested checkpoints
Checkpoint write time (s)25669.52
Checkpoint sync time (s)6.13
Checkpoints buffers written298873
Background buffers written
Backend buffers written13871
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated191633
WAL generated2043 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default20 GB101 MB
pg_global766 kB

SQL query statistics

Top SQL by execution time

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

29bf42b1ab

[7d43ad7e]

openbravo8922.0351.03133324301115253.2321107817.5051124579.3685643.5388

4af3e2b8c4

[26c6f357]

openbravo5656.8432.36634953707104.388697490.002725206.1928279.8338

3f546d3e2b

[a0643fcb]

openbravo475.652.72786427759455.63957668.90861064.6831050.0198

fe2c4fe6df

[4c390f69]

openbravo233.631.34511866729203.20419942.72839046.1026087.3848

241cae8477

[42430e3c]

openbravo226.791.30574018928348.71321831.88132394.6643870.5018

c5df179779

[2870663b]

openbravo180.871.03139673830.0130.00710.5770.00513967383

b52b0c82ea

[4f5926de]

openbravo150.660.86272353918832.01713968.01426243.3544763.2928

08db126a91

[b0ebb687]

openbravo121.120.69303529615139.59913606.53517211.9401323.2838

018c5dd71e

[eb509fc7]

openbravo77.600.4427234919700.5039109.30212205.456958.1748

f0238ffe1b

[806faf8c]

openbravo77.590.4459467977586.53077586.53077586.5301

0b24cb5d2f

[738f9776]

openbravo75.000.4358940075001.79075001.79075001.7901

33f5216a17

[5b59cf42]

openbravo61.950.35139673830.0040.0035.8180.00313967383

d3dcdac298

[ce4e88c2]

openbravo60.350.35137646370.0040.00311.0830.00413764637

61aed5765c

[9c0a6d60]

openbravo59.620.344221987.4641929.8432112.23436.40430

24e13ace2f

[1e425839]

openbravo58.910.34307222104.0622088.8152131.7739.55228

12a0f36339

[acae3908]

openbravo43.750.25172254.35994.555422.70195.925172

f314672ade

[cd9c0fd2]

openbravo42.430.24259242425.19842425.19842425.1981

75c88383e3

[196c6f74]

openbravo41.030.23139673830.0030.0023.8200.00213967383

225c51d0db

[ab242de4]

openbravo40.440.2312547140442.18240442.18240442.1821

7e35c14916

[be51200d]

openbravo36.780.211510477.612447.247678.01628.79777

Top SQL by executions

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

c5df179779

[2870663b]

openbravo1396738324.31139673830.0130.00710.5770.005180.9

33f5216a17

[5b59cf42]

openbravo1396738324.31139673830.0040.0035.8180.00362.0

75c88383e3

[196c6f74]

openbravo1396738324.31139673830.0030.0023.8200.00241.0

d3dcdac298

[ce4e88c2]

openbravo1376463723.96137646370.0040.00311.0830.00460.3

19825253ef

[cf182c3a]

openbravo3153920.5583090.0260.00814.2010.0608.1

74a1d87233

[3cb4d968]

openbravo1224730.211224730.0030.0021.0770.0030.4

8e8235137e

[b19ed954]

openbravo925530.16925530.0090.00363.2010.2080.9

5f8e9d0065

[8e21a910]

openbravo892210.16892210.0070.0020.8090.0060.7

93a759b1da

[6f9b1a85]

openbravo732260.130.0020.0000.4860.0040.1

9455753479

[2049516b]

openbravo719940.130.0010.0000.0970.0010.1

caede7e47b

[3051ec96]

openbravo442490.08442490.2280.10699.6191.67110.1

1eec949137

[6b7612aa]

openbravo435940.08435940.0030.0020.8120.0040.1

3ca20ddb6c

[afe3cf8b]

openbravo305280.05305280.0250.0122.2330.0240.7

3e80950586

[5c26872c]

openbravo167900.03167900.0150.0073.8780.0310.2

5a0394da1d

[c228f769]

openbravo162890.03162890.0320.0150.7880.0160.5

0483033486

[2e63909b]

openbravo159410.037980.0050.0040.2220.0030.1

27b400c7db

[8a770ed5]

openbravo126050.02126050.0800.0165.6370.1101.0

d1e21ddf3e

[c78d8d00]

openbravo122860.02122860.3060.0333.7780.1763.8

f6ccd5bccc

[231ef314]

openbravo122840.02122840.5190.1604.5710.3236.4

bb4767275d

[c28fb106]

openbravo122840.02122840.0040.0030.1070.0030.1

Top SQL by shared blocks fetched

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

4af3e2b8c4

[26c6f357]

openbravo255295659476.32100.005656.86349538

3f546d3e2b

[a0643fcb]

openbravo1895739875.67100.00475.678642778

29bf42b1ab

[7d43ad7e]

openbravo1232558313.6899.998922.0133324308

241cae8477

[42430e3c]

openbravo762552182.2899.97226.857401898

b52b0c82ea

[4f5926de]

openbravo492738191.47100.00150.727235398

08db126a91

[b0ebb687]

openbravo479504481.4399.97121.130352968

c5df179779

[2870663b]

openbravo419171911.25100.00180.91396738313967383

d3dcdac298

[ce4e88c2]

openbravo275443160.82100.0060.31376463713764637

018c5dd71e

[eb509fc7]

openbravo274467590.82100.0077.627234918

fe2c4fe6df

[4c390f69]

openbravo219434370.6699.99233.651186678

61aed5765c

[9c0a6d60]

openbravo213048730.64100.0059.642230

133291c890

[be089ba]

openbravo165177030.49100.0033.96

75c88383e3

[196c6f74]

openbravo139673830.42100.0041.01396738313967383

33f5216a17

[5b59cf42]

openbravo139673830.42100.0062.01396738313967383

12a0f36339

[acae3908]

openbravo116067520.3599.9743.7172172

0a9b2d6035

[68af0d51]

openbravo111695470.33100.0020.56

9c8be0ed8f

[4fe628d8]

openbravo83294960.25100.0014.76

905bffc89c

[92975a8e]

openbravo65496170.2099.9934.12323

382d19fc6d

[40fd3671]

openbravo65494790.2099.9934.123

30c2ffe6a6

[2dc8e362]

openbravo61135120.18100.0015.56

Top SQL by shared blocks read

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

241cae8477

[42430e3c]

openbravo194789.8599.97226.857401898

08db126a91

[b0ebb687]

openbravo145467.3699.97121.130352968

29bf42b1ab

[7d43ad7e]

openbravo140477.1099.998922.0133324308

d3457bdce0

[25bcd965]

openbravo121156.1396.554.38501

06fe4b78a1

[1a2c25cc]

openbravo120406.0997.361.551

4af3e2b8c4

[26c6f357]

openbravo108825.50100.005656.86349538

caede7e47b

[3051ec96]

openbravo95614.8399.1910.14424944249

b2ca99ce15

[e84afa23]

openbravo50122.5399.913.7319608

181fd1b092

[b76c5e2]

openbravo39612.0093.251.114381438

3f546d3e2b

[a0643fcb]

openbravo38831.96100.00475.678642778

4f42690015

[38c3f6e1]

openbravo37251.8897.310.8132428

d7c0920e78

[2951fe49]

openbravo36441.8499.451.881

8cb37f78ee

[e2543c48]

openbravo32991.6798.181.813281328

017d00aa12

[a852adf9]

openbravo31111.5795.200.6132428

12a0f36339

[acae3908]

openbravo30271.5399.9743.7172172

2d19e5b311

[b34f1d1f]

openbravo29781.5190.601.0818818

70caf7bb1e

[f7c054b4]

openbravo29071.4790.790.6833833

b813d9bb61

[1aab69d2]

openbravo25821.3199.876.93030

fe2c4fe6df

[4c390f69]

openbravo24341.2399.99233.651186678

616a44c111

[97aab45d]

openbravo22731.1592.170.5815815

Top SQL by shared blocks dirtied

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

caede7e47b

[3051ec96]

openbravo9755327.8699.1910.14424944249

382d19fc6d

[40fd3671]

openbravo179975.1499.9934.123

905bffc89c

[92975a8e]

openbravo179975.1499.9934.12323

8cb37f78ee

[e2543c48]

openbravo77552.2198.181.813281328

4f42690015

[38c3f6e1]

openbravo70202.0097.310.8132428

50e85a5d5e

[fed47e50]

openbravo66331.8999.857.113281328

48f140c821

[edb3cd2d]

openbravo59601.7099.830.4132428

f398687456

[f1896355]

openbravo57981.6699.540.9396396

4f9621bcb7

[ddcc675a]

openbravo55221.5898.940.8365365

313b1ecda9

[978c2f22]

openbravo54991.5799.632.654415441

24f0f61153

[84a8bcfc]

openbravo52341.4997.970.9768768

6b67fe6923

[5d2e4e6c]

openbravo50731.4597.840.812631263

d1c0672c81

[a1b7c5f]

openbravo49881.4298.361.211961196

fe62dd3708

[fcea205c]

openbravo48851.3996.340.711921192

528c231cbe

[b1de800e]

openbravo47881.3799.150.313411341

2239971ca6

[71f33a7c]

openbravo46921.3499.461.012821282

2d19e5b311

[b34f1d1f]

openbravo44031.2690.601.0818818

616a44c111

[97aab45d]

openbravo43751.2592.170.5815815

604436a476

[3afdf1db]

openbravo41231.1898.360.822032203

181fd1b092

[b76c5e2]

openbravo40901.1793.251.114381438

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]

openbravo1786916290.873511706695.138922.0133324308

241cae8477

[42430e3c]

openbravo11391555.7911397793.09226.857401898

24e13ace2f

[1e425839]

openbravo2595781.322597460.7058.93072228

7e35c14916

[be51200d]

openbravo2251511.142250740.6136.8151077

fe2c4fe6df

[4c390f69]

openbravo1616290.821617250.44233.651186678

d3457bdce0

[25bcd965]

openbravo98290.0598350.034.38501

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)
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)
06fe4b78a1select this_.C_Order_ID as c_order_1_255_0_, this_.AD_Client_ID as ad_clien2_255_0_, this_.AD_Org_ID as ad_org_i3_255_0_, this_.IsActive as isactive4_255_0_, this_.Created as created5_255_0_, this_.CreatedBy as createdb6_255_0_, this_.Updated as updated7_255_0_, this_.UpdatedBy as updatedb8_255_0_, this_.IsSOTrx as issotrx9_255_0_, this_.DocumentNo as documen10_255_0_, this_.DocStatus as docstat11_255_0_, this_.DocAction as docacti12_255_0_, this_.Processing as process13_255_0_, this_.Processed as process14_255_0_, this_.C_DocType_ID as c_docty15_255_0_, this_.C_DocTypeTarget_ID as c_docty16_255_0_, this_.Description as descrip17_255_0_, this_.IsDelivered as isdeliv18_255_0_, this_.IsInvoiced as isinvoi19_255_0_, this_.IsPrinted as isprint20_255_0_, this_.IsSelected as isselec21_255_0_, this_.SalesRep_ID as salesre22_255_0_, this_.DateOrdered as dateord23_255_0_, this_.DatePromised as datepro24_255_0_, this_.DatePrinted as datepri25_255_0_, this_.DateAcct as dateacc26_255_0_, this_.C_BPartner_ID as c_bpart27_255_0_, this_.BillTo_ID as billto_28_255_0_, this_.C_BPartner_Location_ID as c_bpart29_255_0_, this_.POReference as porefer30_255_0_, this_.IsDiscountPrinted as isdisco31_255_0_, this_.C_Currency_ID as c_curre32_255_0_, this_.PaymentRule as payment33_255_0_, this_.C_PaymentTerm_ID as c_payme34_255_0_, this_.InvoiceRule as invoice35_255_0_, this_.DeliveryRule as deliver36_255_0_, this_.FreightCostRule as freight37_255_0_, this_.FreightAmt as freight38_255_0_, this_.DeliveryViaRule as deliver39_255_0_, this_.M_Shipper_ID as m_shipp40_255_0_, this_.C_Charge_ID as c_charg41_255_0_, this_.ChargeAmt as chargea42_255_0_, this_.PriorityRule as priorit43_255_0_, this_.TotalLines as totalli44_255_0_, this_.GrandTotal as grandto45_255_0_, this_.M_Warehouse_ID as m_wareh46_255_0_, this_.M_PriceList_ID as m_price47_255_0_, this_.IsTaxIncluded as istaxin48_255_0_, this_.C_Campaign_ID as c_campa49_255_0_, this_.C_Project_ID as c_proje50_255_0_, this_.C_Activity_ID as c_activ51_255_0_, this_.Posted as posted52_255_0_, this_.AD_User_ID as ad_user53_255_0_, this_.CopyFrom as copyfro54_255_0_, this_.DropShip_BPartner_ID as dropshi55_255_0_, this_.DropShip_Location_ID as dropshi56_255_0_, this_.DropShip_User_ID as dropshi57_255_0_, this_.IsSelfService as isselfs58_255_0_, this_.AD_OrgTrx_ID as ad_orgt59_255_0_, this_.User1_ID as user60_255_0_, this_.User2_ID as user61_255_0_, this_.Deliverynotes as deliver62_255_0_, this_.C_Incoterms_ID as c_incot63_255_0_, this_.Incotermsdescription as incoter64_255_0_, this_.Generatetemplate as generat65_255_0_, this_.Delivery_Location_ID as deliver66_255_0_, this_.CopyFromPO as copyfro67_255_0_, this_.FIN_Paymentmethod_ID as fin_pay68_255_0_, this_.FIN_Payment_Priority_ID as fin_pay69_255_0_, this_.RM_PickFromShipment as rm_pick70_255_0_, this_.RM_ReceiveMaterials as rm_rece71_255_0_, this_.EM_Obcma_C_Poc_Email_ID as em_obcm72_255_0_, this_.RM_CreateInvoice as rm_crea73_255_0_, this_.C_Return_Reason_ID as c_retur74_255_0_, this_.RM_AddOrphanLine as rm_addo75_255_0_, this_.A_Asset_ID as a_asset76_255_0_, this_.Calculate_Promotions as calcula77_255_0_, this_.C_Costcenter_ID as c_costc78_255_0_, this_.Convertquotation as convert79_255_0_, this_.C_Reject_Reason_ID as c_rejec80_255_0_, this_.validuntil as validun81_255_0_, this_.Quotation_ID as quotati82_255_0_, this_.SO_Res_Status as so_res_83_255_0_, this_.Create_POLines as create_84_255_0_, this_.EM_Obdisc_Addpack as em_obdi85_255_0_, this_.Iscashvat as iscashv86_255_0_, this_.EM_OBMFM_Selectfreight as em_obmf87_255_0_, this_.EM_OBMFM_Delivery_Period_ID as em_obmf88_255_0_, this_.RM_Pickfromreceipt as rm_pick89_255_0_, this_.Cancelandreplace as cancela90_255_0_, this_.EM_APRM_AddPayment as em_aprm91_255_0_, this_.EM_OBMFM_Delivery_Charges as em_obmf92_255_0_, this_.Confirmcancelandreplace as confirm93_255_0_, this_.EM_Fash_Datelimit as em_fash94_255_0_, this_.EM_OBMFM_Freight_ID as em_obmf95_255_0_, this_.EM_Obwpl_Generatepicking as em_obwp96_255_0_, this_.Cancelledorder_id as cancell97_255_0_, this_.EM_Fash_Datevalue as em_fash98_255_0_, this_.EM_OBMFM_Weight as em_obmf99_255_0_, this_.EM_Obwpl_Isinpickinglist as em_obw100_255_0_, this_.EM_Fash_Sendbeforedate as em_fas101_255_0_, this_.EM_Obwpl_Readypl as em_obw102_255_0_, this_.EM_Poss_Businessdate as em_pos103_255_0_, this_.Replacedorder_id as replac104_255_0_, this_.EM_Fash_Order_Type_ID as em_fas105_255_0_, this_.Iscancelled as iscanc106_255_0_, this_.EM_OBMFM_Weight_Uom_ID as em_obm107_255_0_, this_.Replacementorder_ID as replac108_255_0_, this_.EM_OBMFM_Set_Weight as em_obm109_255_0_, this_.BPartner_ExtRef as bpartn110_255_0_, this_.C_Alternate_Location_ID as c_alte111_255_0_, this_.EM_Obpos_Applications_ID as em_obp112_255_0_, this_.EM_Obpos_Sendemail as em_obp113_255_0_, this_.EM_Obpos_Email_Status as em_obp114_255_0_, this_.EM_Obpos_App_Cashup_ID as em_obp115_255_0_, this_.EM_Obpos_Createdabsolute as em_obp116_255_0_, this_.EM_OBPOS_NotInvoiceOnCashUp as em_obp117_255_0_, this_.EM_Obpos_Rejected_Quotat_ID as em_obp118_255_0_, this_.EM_Obpos_Isdeleted as em_obp119_255_0_, this_.EM_Obpos_Islayaway as em_obp120_255_0_, this_.EM_Obpos_Prepaymentamt as em_obp121_255_0_, this_.EM_Obpos_Prepaymentlimitamt as em_obp122_255_0_, this_.EM_Fash_Servefrom as em_fas123_255_0_, this_.EM_Obpos_Prepaymentlaylimitamt as em_obp124_255_0_, this_.EM_Obpos_Rounding_Amount as em_obp125_255_0_, this_.EM_Obpos_Sequencename as em_obp126_255_0_, this_.EM_Obpos_Sequencenumber as em_obp127_255_0_, this_.EM_Prpp_Generatepicking as em_prp128_255_0_, this_.EM_Api_Resend as em_api129_255_0_, this_.C_Invoice_Alternate_Loc_ID as c_invo130_255_0_, this_.EM_OBSMAIL_EmailAddress as em_obs131_255_0_, this_.EM_Prouti_Order_Stock as em_pro132_255_0_, this_.EM_Prouti_Pregenerate_Minout as em_pro133_255_0_, this_.EM_Prouti_Sotopo as em_pro134_255_0_, this_.EM_Prouti_Generate_Pick_Inv as em_pro135_255_0_, this_.EM_Prouti_Order_ID as em_pro136_255_0_, this_.EM_Prouti_Grandtotalinitial as em_pro137_255_0_, this_.EM_Prouti_Dateclosed as em_pro138_255_0_, this_.EM_Prouti_Totallinesinitial as em_pro139_255_0_, this_.EM_Prouti_Changebpartner as em_pro140_255_0_, this_.EM_Prouti_Recalculate_Price as em_pro141_255_0_, this_.EM_Prouti_Pricecalculatetdate as em_pro142_255_0_, this_.EM_Prouti_Reactiveorder as em_pro143_255_0_, this_.EM_Izi_Exported as em_izi144_255_0_, this_.EM_Prouti_Totalizations as em_pro145_255_0_, this_.EM_Izijoy_Export_Enjoy as em_izi146_255_0_, this_.EM_Izi_Splio_Exported as em_izi147_255_0_, this_.em_prouti_Invoiced as em_pro148_255_0_, this_.em_prouti_Received as em_pro149_255_0_, this_.em_prouti_initial_received as em_pro150_255_0_, this_.EM_Prouti_Status_Of_Review as em_pro151_255_0_, this_.EM_Prouti_Validate_Order as em_pro152_255_0_, this_.EM_Poss_Orgloc_Locid as em_pos153_255_0_, this_.EM_Prouti_Start_Review as em_pro154_255_0_, this_.EM_Obpos_Skip_Tax_Calculation as em_obp155_255_0_, this_.EM_Prpgr_Ticketno as em_prp156_255_0_, this_.EM_Prouti_Addlines_Btn as em_pro157_255_0_, this_.EM_Prgr_Locator_ID as em_prg158_255_0_, this_.EM_Prrgr_Locator_ID as em_prr159_255_0_, this_.EM_Avisver_Export as em_avi160_255_0_, this_.EM_Prgr_Assigned_ID as em_prg161_255_0_, this_.EM_Prouti_Select_Soline as em_pro162_255_0_, this_.EM_Prgr_Assign as em_prg163_255_0_ from C_Order this_ where this_.EM_Izijoy_Export_Enjoy=$1 and this_.AD_Org_ID in ($2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21) and this_.AD_Client_ID in ($22, $23) and this_.IsActive=$24
b813d9bb61select 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), $3) from C_OrderLine orderline6_ where order0_.C_Order_ID=orderline6_.C_Order_ID and orderline6_.EM_Obpos_Isdeleted=$4) as col_21_0_, (select min(case when orderline7_.EM_Obrdm_Delivery_Date is null or orderline7_.EM_Obrdm_Delivery_Time is null then $5 else to_timestamp((to_char(orderline7_.EM_Obrdm_Delivery_Date, $6)||$7||to_char(orderline7_.EM_Obrdm_Delivery_Date, $8)||$9||to_char(orderline7_.EM_Obrdm_Delivery_Date, $10)||$11||to_char(orderline7_.EM_Obrdm_Delivery_Time, $12)||$13||to_char(orderline7_.EM_Obrdm_Delivery_Time, $14)), $15) 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 $16 else case when documentty1_.IsReturn=$17 then $18 when documentty1_.DocSubTypeSO=$19 then $20 when order0_.EM_Obpos_Islayaway=$21 then $22 else $23 end end as col_23_0_, order0_.InvoiceRule as col_24_0_, order0_.EM_Prpgr_Ticketno as col_25_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 $24=$25 and order0_.AD_OrgTrx_ID=$1 and order0_.AD_Client_ID=$26 and order0_.EM_Obpos_Isdeleted=$27 and (order0_.DocStatus not in ($28 , $29 , $30 , $31 , $32)) and (order0_.DocStatus<>$33 or order0_.Iscancelled=$34) order by col_4_0_ desc, col_3_0_ desc limit $2
24e13ace2fSELECT 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 )
9455753479COMMIT
f6ccd5bcccSELECT AD_COLUMN_IDENTIFIER(p_TableName, p_Record_ID, v_Language ) FROM DUAL
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
d7c0920e78select invoice0_.C_Invoice_ID as c_invoic1_239_, invoice0_.AD_Client_ID as ad_clien2_239_, invoice0_.AD_Org_ID as ad_org_i3_239_, invoice0_.IsActive as isactive4_239_, invoice0_.Created as created5_239_, invoice0_.CreatedBy as createdb6_239_, invoice0_.Updated as updated7_239_, invoice0_.UpdatedBy as updatedb8_239_, invoice0_.IsSOTrx as issotrx9_239_, invoice0_.DocumentNo as documen10_239_, invoice0_.DocStatus as docstat11_239_, invoice0_.DocAction as docacti12_239_, invoice0_.Processing as process13_239_, invoice0_.Processed as process14_239_, invoice0_.Posted as posted15_239_, invoice0_.C_DocType_ID as c_docty16_239_, invoice0_.C_DocTypeTarget_ID as c_docty17_239_, invoice0_.C_Order_ID as c_order18_239_, invoice0_.Description as descrip19_239_, invoice0_.IsPrinted as isprint20_239_, invoice0_.SalesRep_ID as salesre21_239_, invoice0_.DateInvoiced as dateinv22_239_, invoice0_.DatePrinted as datepri23_239_, invoice0_.DateAcct as dateacc24_239_, invoice0_.C_BPartner_ID as c_bpart25_239_, invoice0_.C_BPartner_Location_ID as c_bpart26_239_, invoice0_.POReference as porefer27_239_, invoice0_.IsDiscountPrinted as isdisco28_239_, invoice0_.DateOrdered as dateord29_239_, invoice0_.C_Currency_ID as c_curre30_239_, invoice0_.C_PaymentTerm_ID as c_payme31_239_, invoice0_.C_Charge_ID as c_charg32_239_, invoice0_.ChargeAmt as chargea33_239_, invoice0_.TotalLines as totalli34_239_, invoice0_.GrandTotal as grandto35_239_, invoice0_.M_PriceList_ID as m_price36_239_, invoice0_.IsTaxIncluded as istaxin37_239_, invoice0_.C_Campaign_ID as c_campa38_239_, invoice0_.C_Project_ID as c_proje39_239_, invoice0_.C_Activity_ID as c_activ40_239_, invoice0_.CreateFrom as createf41_239_, invoice0_.GenerateTo as generat42_239_, invoice0_.AD_User_ID as ad_user43_239_, invoice0_.CopyFrom as copyfro44_239_, invoice0_.IsSelfService as isselfs45_239_, invoice0_.AD_OrgTrx_ID as ad_orgt46_239_, invoice0_.User1_ID as user47_239_, invoice0_.User2_ID as user48_239_, invoice0_.Withholdingamount as withhol49_239_, invoice0_.Taxdate as taxdate50_239_, invoice0_.C_Withholding_ID as c_withh51_239_, invoice0_.Ispaid as ispaid52_239_, invoice0_.Totalpaid as totalpa53_239_, invoice0_.OutstandingAmt as outstan54_239_, invoice0_.DaysTillDue as daystil55_239_, invoice0_.DueAmt as dueamt56_239_, invoice0_.LastCalculatedOnDate as lastcal57_239_, invoice0_.FIN_Paymentmethod_ID as fin_pay58_239_, invoice0_.FIN_Payment_Priority_ID as fin_pay59_239_, invoice0_.Finalsettlement as finalse60_239_, invoice0_.Daysoutstanding as daysout61_239_, invoice0_.Percentageoverdue as percent62_239_, invoice0_.C_Costcenter_ID as c_costc63_239_, invoice0_.Calculate_Promotions as calcula64_239_, invoice0_.A_Asset_ID as a_asset65_239_, invoice0_.EM_APRM_Addpayment as em_aprm66_239_, invoice0_.Iscashvat as iscashv67_239_, invoice0_.EM_APRM_Processinvoice as em_aprm68_239_, invoice0_.EM_Obcma_C_Poc_Email_ID as em_obcm69_239_, invoice0_.Prepaymentamt as prepaym70_239_, invoice0_.Createfromorders as createf71_239_, invoice0_.Createfrominouts as createf72_239_, invoice0_.Paidamtatinvoicing as paidamt73_239_, invoice0_.BPartner_ExtRef as bpartne74_239_, invoice0_.EM_Obpos_Rounding_Amount as em_obpo75_239_, invoice0_.EM_Obpos_Sequencename as em_obpo76_239_, invoice0_.EM_Obpos_Sequencenumber as em_obpo77_239_, invoice0_.C_Alternate_Location_ID as c_alter78_239_, invoice0_.EM_Prouti_Recalculate_Price as em_prou79_239_, invoice0_.EM_Prouti_Pricecalculatetdate as em_prou80_239_, invoice0_.EM_Poss_Orgloc_Locid as em_poss81_239_, invoice0_.EM_Prouti_Totalizations as em_prou82_239_, invoice0_.Einvoice_Status as einvoic83_239_, invoice0_.Einvoice_Generated as einvoic84_239_, invoice0_.Einvoice_ExternalID as einvoic85_239_, invoice0_.Einvoice_Send_Status as einvoic86_239_, invoice0_.Einvoice_Sent as einvoic87_239_, invoice0_.EM_Fash_Datevalue as em_fash88_239_, invoice0_.EM_Api_Resend as em_api_89_239_ from C_Invoice invoice0_ left outer join FIN_Payment_Schedule finpayment1_ on invoice0_.C_Invoice_ID=finpayment1_.C_Invoice_ID where invoice0_.Processed='Y' and (invoice0_.Ispaid='N' or finpayment1_.Updated>=invoice0_.LastCalculatedOnDate or invoice0_.OutstandingAmt<>0 or invoice0_.Finalsettlement is null) and invoice0_.IsActive='Y'
30c2ffe6a6SELECT * FROM (select f.c_invoice_id as referencekey_id, $2 as ad_role_id, $3 as ad_user_id, $4 || f.documentno|| $5 as description, $6 as isActive, f.ad_org_id, f.ad_client_id, now() as created, $7 as createdBy, now() as updated, $8 as updatedBy, ad_column_identifier($9, f.c_invoice_id, $10) AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id=ci.c_order_id where ci.issotrx=$11 and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT($12 FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno)>$13 order by max(dateinvoiced) desc ) as f) AAA where not exists (select $14 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $15) != $16)
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 )
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
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)
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)
241cae8477select "_"."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 ) "_"
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 ) "_"
9c8be0ed8fSELECT * 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 exists (select $13 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 and bpl.istaxlocation = $14 group by bpl.c_bpartner_id, bpl.istaxlocation having count(distinct(l.c_country_id)) > $15 )) AAA where not exists (select $16 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $17) != $18)
33f5216a17SELECT 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) )
3e80950586SELECT 1 FROM ONLY "public"."c_bpartner" x WHERE "c_bpartner_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
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)
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)
1eec949137SELECT $4 FROM ONLY "profile"."last_stat_tablespaces" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "sample_id" OPERATOR(pg_catalog.=) $2 AND "tablespaceid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
93a759b1daBEGIN
2239971ca6select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
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
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)
27b400c7dbselect c_import_e0_.C_IMPORT_ENTRY_ID as c_import1_236_0_, c_import_e0_.AD_Client_ID as ad_clien2_236_0_, c_import_e0_.AD_Org_ID as ad_org_i3_236_0_, c_import_e0_.Isactive as isactive4_236_0_, c_import_e0_.Created as created5_236_0_, c_import_e0_.Createdby as createdb6_236_0_, c_import_e0_.Updated as updated7_236_0_, c_import_e0_.Updatedby as updatedb8_236_0_, c_import_e0_.Imported as imported9_236_0_, c_import_e0_.Jsoninfo as jsoninf10_236_0_, c_import_e0_.ImportStatus as imports11_236_0_, c_import_e0_.Typeofdata as typeofd12_236_0_, c_import_e0_.Errorinfo as errorin13_236_0_, c_import_e0_.AD_Role_ID as ad_role14_236_0_, c_import_e0_.Createdtimestamp as created15_236_0_, c_import_e0_.EM_Obpos_Applications_ID as em_obpo16_236_0_, c_import_e0_.Responseinfo as respons17_236_0_, c_import_e0_.Isnonblocking as isnonbl18_236_0_ from C_IMPORT_ENTRY c_import_e0_ where c_import_e0_.C_IMPORT_ENTRY_ID=$1
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)
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)
225c51d0dbCOPY public.c_import_entry_archive (c_import_entry_archive_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, imported, jsoninfo, importstatus, typeofdata, errorinfo, ad_role_id, responseinfo, em_obpos_applications_id, isnonblocking) TO stdout
12a0f36339SELECT COALESCE(sum(month_total_amount),$1) AS month_total_amount, COALESCE(sum(week_total_amount),$2) AS week_total_amount, COALESCE(sum(day_total_amount),$3) AS day_total_amount, COALESCE(sum(month_total_units),$4) AS month_total_units, COALESCE(sum(week_total_units),$5) AS week_total_units, COALESCE(sum(day_total_units),$6) AS day_total_units, COALESCE(sum(month_total_amount_ret),$7) AS month_total_amount_ret, COALESCE(sum(week_total_amount_ret),$8) AS week_total_amount_ret, COALESCE(sum(day_total_amount_ret),$9) AS day_total_amount_ret, COALESCE(sum(month_total_units_ret),$10) AS month_total_units_ret, COALESCE(sum(week_total_units_ret),$11) AS week_total_units_ret, COALESCE(sum(day_total_units_ret),$12) AS day_total_units_ret FROM ( SELECT -- Pedidos CASE WHEN ol.line_gross_amount > $13 THEN ol.line_gross_amount END month_total_amount, CASE WHEN ol.line_gross_amount > $14 THEN ol.qtyordered END month_total_units, CASE WHEN o.created >= d.actual_week_date AND ol.line_gross_amount > $15 THEN ol.line_gross_amount END AS week_total_amount, CASE WHEN o.created >= d.actual_week_date AND ol.line_gross_amount > $16 THEN ol.qtyordered END AS week_total_units, CASE WHEN o.created >= d.actual_date AND ol.line_gross_amount > $17 THEN ol.line_gross_amount END AS day_total_amount, CASE WHEN o.created >= d.actual_date AND ol.line_gross_amount > $18 THEN ol.qtyordered END AS day_total_units, -- Devos CASE WHEN ol.line_gross_amount < $19 THEN ol.line_gross_amount END month_total_amount_ret, CASE WHEN ol.line_gross_amount < $20 THEN ol.qtyordered END month_total_units_ret, CASE WHEN o.created >= d.actual_week_date AND ol.line_gross_amount < $21 THEN ol.line_gross_amount END AS week_total_amount_ret, CASE WHEN o.created >= d.actual_week_date AND ol.line_gross_amount < $22 THEN ol.qtyordered END AS week_total_units_ret, CASE WHEN o.created >= d.actual_date AND ol.line_gross_amount < $23 THEN ol.line_gross_amount END AS day_total_amount_ret, CASE WHEN o.created >= d.actual_date AND ol.line_gross_amount < $24 THEN ol.qtyordered END AS day_total_units_ret FROM c_orderline ol LEFT JOIN c_order o ON ol.c_order_id = o.c_order_id LEFT JOIN c_doctype cd ON cd.c_doctype_id=o.c_doctypetarget_id , ( SELECT trunc(now()) actual_date, date_trunc($25,now()) actual_week_date, date_trunc($26,now()) actual_month_date FROM dual) d WHERE o.ad_org_id = $27 AND o.created >= d.actual_month_date AND cd.docsubtypeso<>$28 AND o.issotrx=$29 ) AS f1
3ca20ddb6cselect adlanguage0_.AD_Language_ID as ad_langu1_51_0_, adlanguage0_.AD_Language as ad_langu2_51_0_, adlanguage0_.AD_Client_ID as ad_clien3_51_0_, adlanguage0_.AD_Org_ID as ad_org_i4_51_0_, adlanguage0_.IsActive as isactive5_51_0_, adlanguage0_.Created as created6_51_0_, adlanguage0_.CreatedBy as createdb7_51_0_, adlanguage0_.Updated as updated8_51_0_, adlanguage0_.UpdatedBy as updatedb9_51_0_, adlanguage0_.Name as name10_51_0_, adlanguage0_.LanguageISO as languag11_51_0_, adlanguage0_.CountryCode as country12_51_0_, adlanguage0_.IsBaseLanguage as isbasel13_51_0_, adlanguage0_.IsSystemLanguage as issyste14_51_0_, adlanguage0_.Processing as process15_51_0_, adlanguage0_.Pixelsize as pixelsi16_51_0_, adlanguage0_.Translatedby as transla17_51_0_, adlanguage0_.Isrtl as isrtl18_51_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=$1
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, $20), QTYORDERONHAND=QTYORDERONHAND + v_qtyorder, DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY), PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, $21), 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, $22)=COALESCE(p_product_uom, $23)
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
5a0394da1dSELECT coalesce(t.MSGTEXT, m.MSGTEXT) AS MSGTEXT FROM AD_MESSAGE m left join AD_MESSAGE_TRL t on m.AD_MESSAGE_ID = t.AD_MESSAGE_ID and t.AD_LANGUAGE = $1 WHERE m.VALUE=$2
bb4767275dSELECT coalesce(ad_language,$1) FROM AD_CLIENT WHERE ad_client_id=$2
d1e21ddf3eSELECT REPLACE(REPLACE(SQL_RECORD_IDENTIFIER, $4, $5 || p_Language || $6), $7, p_Record_ID) FROM AD_TABLE WHERE UPPER(TABLENAME)=UPPER(p_TableName)
f314672adeCOPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout
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=$3 order by c_import_e0_.Created, c_import_e0_.Createdtimestamp limit $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)
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)
b2ca99ce15select "_"."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", 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" from ( SELECT O.c_order_id , O.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" 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 WHERE $1=$2 AND O.issotrx <> $3 AND O.dateordered >= CURRENT_DATE - INTERVAL $4 ) "$Table" ) "_"
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))
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, $60, 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, $61 )
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_order89 GB976335116502916438151330
c_order(TOAST)
openbravopg_defaultpublicc_bpartner28 GB16810316201043786249182
c_bpartner(TOAST)
openbravopg_defaultpublicad_orgtype27 GB3492903364364
openbravopg_defaultpublicfin_payment13 GB2123299231077562316648
fin_payment(TOAST)
openbravopg_defaultpublicfin_payment_schedule10 GB2457684766093610117311707148
fin_payment_schedule(TOAST)
openbravopg_defaultpublicad_user8767 MB8056432095642060289322277
ad_user(TOAST)
openbravopg_defaultpublicm_inout7484 MB17520850669520850669768768
m_inout(TOAST)424764040
openbravopg_defaultpublicm_transaction7436 MB122009824821721316
m_transaction(TOAST)
openbravopg_defaultpg_catalogpg_class6185 MB7132803947802930
openbravopg_defaultpublicm_inoutline3932 MB6224696705459175261355
m_inoutline(TOAST)
openbravopg_defaultpublicc_location3256 MB481542278633143945226226
c_location(TOAST)
openbravopg_defaultpublicc_invoice3149 MB127721347913435493
c_invoice(TOAST)
openbravopg_defaultprofilelast_stat_database2805 MB1232339292
openbravopg_defaultpublicad_table1789 MB2516600600
ad_table(TOAST)
openbravopg_defaultpg_catalogpg_proc1592 MB8256202489296
pg_proc(TOAST)17664853
openbravopg_defaultpublicc_orderline1185 MB158752136284360143827501117
c_orderline(TOAST)
openbravopg_defaultpublicobcfr_ticketreprint966 MB1818818818
obcfr_ticketreprint(TOAST)5533581820
openbravopg_defaultpublicm_product959 MB24230970783227876
m_product(TOAST)
openbravopg_defaultpublicobcfr_ticket927 MB134883619815
obcfr_ticket(TOAST)3255357012
openbravopg_defaultprofilelast_stat_tablespaces683 MB437334646
last_stat_tablespaces(TOAST)

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicm_inout52184758416.13156918211848.50191480.001046280.00
openbravopg_defaultpublicm_inoutline52822419616.33714900592.21
openbravopg_defaultpublicc_bpartner_location351786351.09526553031.63
openbravopg_defaultpublicc_location335612961.04464762941.44
openbravopg_defaultpublicc_order497662631.54220746000.68
openbravopg_defaultpublicad_org286628040.89284395790.88250930.00754560.00
openbravopg_defaultpublicc_orderline291070170.9027550390.09
openbravopg_defaultpublicm_costing279357020.86
openbravopg_defaultpublicc_country133236700.41133231790.41
openbravopg_defaultpublicfin_payment_schedule74685100.23173687500.54
openbravopg_defaultpublicad_user67850710.21169761670.52
openbravopg_defaultpublicfin_payment_detail107952740.331221660.00
openbravopg_defaultpublicm_matchpo25927080.0878200100.24
openbravopg_defaultpublicm_product33285270.1063219150.20
openbravopg_defaultpublicc_bpartner46827310.1431104520.10
openbravopg_defaultpublicfin_payment_scheduledetail58055680.181612590.00
openbravopg_defaultprofilelast_stat_tables47231880.151342930.00
openbravopg_defaultpublicc_import_entry32116960.1010613090.031091640.002323120.01
openbravopg_defaultpublicad_orgtype34932670.113840.00
openbravopg_defaultpg_catalogpg_class15564440.0516286970.05

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicc_orderline1970.103234616.8899.90
openbravopg_defaultpublicc_order2760.142834514.7999.96
openbravopg_defaultpublicm_inoutline970.052355712.29100.00
openbravopg_defaultpublicfin_payment_schedule900.05124016.4799.95
openbravopg_defaultpublicobmobc_logclient26091.3669523.6399.00
openbravopg_defaultpublicfin_payment_scheduledetail670.0394824.9599.84
openbravopg_defaultpublicm_inout900.0571883.75100.00
openbravopg_defaultpublicfin_payment_detail350.0257993.0399.95
openbravopg_defaultpublicc_invoiceline920.0549912.6094.96
openbravopg_defaultpublicad_user300.0241262.1599.98
openbravopg_defaultpublicc_orderlinetax740.0439282.0589.99
openbravopg_defaultpublicobcfr_tickettax680.0438422.0086.38
openbravopg_defaultpublicc_import_entry_archive2480.1310220.5324651.29870.0599.70
openbravopg_defaultpublicc_invoice930.0534021.7899.58
openbravopg_defaultpublicc_invoicelinetax590.0330831.6185.37
openbravopg_defaultpublicc_bpartner280.0130591.6099.96
openbravopg_defaultpublicobcfr_ticketreprint1880.1028371.4880.0098.54
openbravopg_defaultpublicc_bpartner_location200.0128031.46100.00
openbravopg_defaultpublicfin_finacc_transaction810.0427291.4297.68
openbravopg_defaultpublicobcfr_ticket1790.0922001.1550.0098.80

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
openbravopg_defaultprofilelast_stat_indexes672981633672982183107091641217408347
openbravopg_defaultprofilelast_stat_tables392384356392385418462780894824180815
openbravopg_defaultpublicc_import_entry778777877787359273207501
c_import_entry(TOAST)11849118491896660627
openbravopg_defaultpublicobmobc_logclient44250
obmobc_logclient(TOAST)
openbravopg_defaultprofilelast_stat_user_functions9039909903948391271170
last_stat_user_functions(TOAST)
openbravopg_defaultpublicc_import_entry_archive328511254717778
c_import_entry_archive(TOAST)1084997751422364
openbravopg_defaultpg_catalogpg_statistic110679509295140245580
pg_statistic(TOAST)140914102858759106
openbravopg_defaultprofilesample_stat_tables43564558237170441474749
openbravopg_defaultpublicc_orderline1438275011171196611158752136284360
c_orderline(TOAST)
openbravopg_defaultpublicfin_payment756231664821150837752329923107
fin_payment(TOAST)
openbravopg_defaultprofilesample_stat_indexes14041624202342211541675
openbravopg_defaultpublicfin_payment_scheduledetail7562258729252775769866
fin_payment_scheduledetail(TOAST)
openbravopg_defaultprofilesample_statements1282141140433770971411
sample_statements(TOAST)
openbravopg_defaultpublicfin_finacc_transaction818156949328143
fin_finacc_transaction(TOAST)
openbravopg_defaultpublicfin_payment_schedule117311707148243072771957684766093610
fin_payment_schedule(TOAST)
openbravopg_defaultpublicad_sequence22862189282847534753
ad_sequence(TOAST)
openbravopg_defaultpublicc_order81513309779916396633511650291643
c_order(TOAST)
openbravopg_defaultpublicobpos_applications192017761469198150720127507
obpos_applications(TOAST)
openbravopg_defaultpublicm_inout7687681712392263520850669520850669
m_inout(TOAST)424764040
openbravopg_defaultpublicc_orderlinetax143824472447
c_orderlinetax(TOAST)

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
openbravopg_defaultprofilelast_stat_indexes1633267298354623
openbravopg_defaultprofilelast_stat_tables43565439238354623
openbravopg_defaultpublicc_import_entry778777877796
c_import_entry(TOAST)1184958
openbravopg_defaultpg_catalogpg_statistic1106795091
pg_statistic(TOAST)14103
openbravopg_defaultprofilelast_stat_user_functions909489039354623
last_stat_user_functions(TOAST)
openbravopg_defaultprofilesample_stat_tables45582
openbravopg_defaultpublicc_orderline27501117
c_orderline(TOAST)
openbravopg_defaultpublicfin_payment2316648
fin_payment(TOAST)
openbravopg_defaultpublicad_sequence22862189119
ad_sequence(TOAST)
openbravopg_defaultpublicfin_payment_scheduledetail2258729
fin_payment_scheduledetail(TOAST)
openbravopg_defaultpublicobpos_applications192017761631
obpos_applications(TOAST)
openbravopg_defaultprofilesample_stat_indexes16242
openbravopg_defaultpublicfin_finacc_transaction1569
fin_finacc_transaction(TOAST)
openbravopg_defaultpublicm_storage_detail141413
m_storage_detail(TOAST)
openbravopg_defaultprofilesample_statements14112
sample_statements(TOAST)
openbravopg_defaultpublicc_order1330
c_order(TOAST)
openbravopg_defaultpublicfin_payment_schedule11701487
fin_payment_schedule(TOAST)
openbravopg_defaultpublicobpos_app_cashup942117
obpos_app_cashup(TOAST)
openbravopg_defaultpublicm_inout768
m_inout(TOAST)
openbravopg_defaultprofilesample_stat_user_functions7672

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
openbravopg_defaultprofilesample_stat_tables9312 kB1160 kB43564558
openbravopg_defaultpublicm_inoutline656 MB944 kB1355
m_inoutline(TOAST)
openbravopg_defaultprofilelast_stat_indexes1936 kB928 kB672981633672982
openbravopg_defaultpg_catalogpg_statistic4968 kB832 kB110679509
pg_statistic(TOAST)3728 kB80 kB14091410
openbravopg_defaultprofilelast_stat_tables1488 kB744 kB3923843563923854
openbravopg_defaultprofilesample_statements3144 kB320 kB12821411
sample_statements(TOAST)
openbravopg_defaultprofilesample_stat_indexes1784 kB208 kB14041624
openbravopg_defaultpublicad_process_run2744 kB152 kB305305
ad_process_run(TOAST)864 kB40 kB22
openbravopg_defaultprofilelast_stat_user_functions256 kB144 kB9039909903948
last_stat_user_functions(TOAST)
openbravopg_defaultprofilesample_stat_user_functions632 kB80 kB616767
openbravopg_defaultprofilesample_stat_tables_total344 kB56 kB120136
openbravopg_defaultpublicad_ep_instance_para48 kB40 kB6868
ad_ep_instance_para(TOAST)
openbravopg_defaultprofilesample_stat_database232 kB40 kB5660
openbravopg_defaultprofilelast_stat_database40 kB32 kB9292
openbravopg_defaultprofileindexes_list136 kB32 kB2015
openbravopg_defaultprofilesample_statements_total136 kB32 kB4554
sample_statements_total(TOAST)
openbravopg_defaultpublicad_process_request96 kB8192 bytes304300
ad_process_request(TOAST)184 kB

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
openbravopg_defaultpublicm_inoutm_inout_key520849419156912901148.50
openbravopg_defaultpublicm_inoutlinem_inoutline_orderline21802397658006912.03
openbravopg_defaultpublicc_bpartner_locationc_bplocation_bpartner17419401523818561.62
openbravopg_defaultpublicc_locationc_location_key15422786464747541.44
openbravopg_defaultpublicad_orgad_org_key28436371284365580.88
openbravopg_defaultpublicm_costingm_costing_product_date27934766279350000.86
openbravopg_defaultpublicc_orderc_order_key6323748191273600.59
openbravopg_defaultpublicfin_payment_schedulefin_payment_schedule_key5758370173198020.54
openbravopg_defaultpublicad_userad_user_partner5509207165680930.51
openbravopg_defaultpublicc_countryc_country_key13316684133168210.41
openbravopg_defaultpublicm_matchpom_matchpo_inout260047278199680.24
openbravopg_defaultpublicm_productm_product_key308320961837990.19
openbravopg_defaultpublicm_inoutlinem_inoutline_product63508555571290.17
openbravopg_defaultpublicc_bpartnerc_bpartner_key102135430686580.09
openbravopg_defaultpublicc_orderc_order_client_org_date_docno21226186380.08
openbravopg_defaultpublicc_orderlineem_obpos_orderedqty52249122503780.07
openbravopg_defaultpg_catalogpg_classpg_class_oid_index75664315262720.05
openbravopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index57808011712310.04
openbravopg_defaultpublicm_storage_detailm_storage_detail_un2002536087210.02
openbravopg_defaultpublicm_transactionm_transaction_inoutline2009506067260.02

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
openbravopg_defaultpublicc_orderc_order_client_org_date_docno212151527.9199.42
openbravopg_defaultpublicc_orderlineem_obpos_orderedqty522491141717.3999.37
openbravopg_defaultpublicc_orderlinec_orderline_key9697140967.3684.05
openbravopg_defaultpublicm_inoutlinem_inoutline_product635085108805.6899.80
openbravopg_defaultpublicm_inoutlinem_inoutline_orderline21802397108715.6799.98
openbravopg_defaultpublicfin_payment_schedulefin_payment_schedule_key575837092284.8299.95
openbravopg_defaultpublicc_orderc_order_dateordered_id3852962.7666.43
openbravopg_defaultpublicm_inoutm_inout_key52084941952492.74100.00
openbravopg_defaultpublicfin_payment_scheduledetailfin_pymt_schdet_det_idx272451692.7081.49
openbravopg_defaultpublicfin_payment_detailfin_payment_detail_key181251322.6875.35
openbravopg_defaultpublicc_orderc_order_ad_orgtrx8147462.4886.90
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_pk44632.3395.95
openbravopg_defaultpublicad_userad_user_partner550920724551.2899.99
openbravopg_defaultpublicc_bpartner_locationc_bplocation_location50524451.2896.37
openbravopg_defaultpublicc_bpartnerc_bpartner_key102135424181.2699.92
openbravopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx54122871.1962.92
openbravopg_defaultpublicc_invoicec_invoice_key508720201.0590.19
openbravopg_defaultpublicfin_payment_scheduledetailfin_pay_scheduledetail_or1284816300.8596.37
openbravopg_defaultpublicc_orderlinetaxc_orderlinetax_orderline244715200.7990.26
openbravopg_defaultpublicc_orderlinetaxc_orderlinetax_key14960.7874.22

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
openbravopg_defaultprofilelast_stat_indexespk_last_stat_indexes504 kB368 kB67298163167298
openbravopg_defaultprofilesample_statementsix_sample_stmts_qid1056 kB360 kB8931022
openbravopg_defaultpublicad_process_runad_process_run_key752 kB184 kB287287
openbravopg_defaultprofilelast_stat_tablespk_last_stat_tables288 kB136 kB39238430239238
openbravopg_defaultprofilesample_stat_tablespk_sample_stat_tables1112 kB80 kB22532605
openbravopg_defaultpublicad_process_runad_process_run_ad_prequest_id608 kB48 kB231231
openbravopg_defaultprofilesample_stat_indexespk_sample_stat_indexes432 kB32 kB9121193
openbravopg_defaultprofilesample_statementspk_sample_statements_n504 kB32 kB649837
openbravopg_defaultpublicad_process_runad_process_run_status240 kB24 kB249249
openbravopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index80 kB8192 bytes13041294
openbravopg_defaultprofilesample_stat_user_functionspk_sample_stat_user_functions264 kB8192 bytes298355

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 bytes191191

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicm_get_cost139673832185.9177.040.0000.000
openbravopublicm_get_cost139673832108.87193.000.0000.000
openbravopublicm_get_no_trx_product_cost139673831344.6668.510.0000.000
openbravopublicm_get_no_trx_product_cost139673831276.16967.020.0000.000
openbravopublicm_get_product_cost13967383366.75366.750.0000.000
openbravopublicad_get_org_le_bu13764651309.18309.180.0000.000
openbravopublictrunc16597226183.18183.180.0000.000
openbravopublicto_date13972994111.73111.730.0000.000
openbravopublicc_currency_convert_precision1396738392.8192.810.0000.000
openbravopublicsubstract_days2856667337.6937.690.0000.000
openbravoprofiletake_sample2334.060.031.4810.001
openbravoprofiletake_sample_subset2334.030.091.4800.004
openbravoprofiletake_sample2333.942.521.4760.109
openbravopublicretstk_product_stock_json40022.1718.490.0550.046
openbravoprofiledblink62119.5619.560.0310.031
openbravoprofilecollect_obj_stats2314.984.250.6510.185
openbravopublicretstk_product_stock_json_loc40012.368.870.0310.022
openbravopublicad_column_identifier_std142648.410.470.0010.000
openbravopublicad_column_identifier142787.977.870.0010.001
openbravopublicm_get_stock_param13287.076.920.0050.005

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicsubstract_days2856667337.6937.690.0000.000
openbravopublictrunc16597226183.18183.180.0000.000
openbravopublicto_date13972994111.73111.730.0000.000
openbravopublicc_currency_convert_precision1396738392.8192.810.0000.000
openbravopublicm_get_cost139673832185.9177.040.0000.000
openbravopublicm_get_cost139673832108.87193.000.0000.000
openbravopublicm_get_no_trx_product_cost139673831344.6668.510.0000.000
openbravopublicm_get_no_trx_product_cost139673831276.16967.020.0000.000
openbravopublicm_get_product_cost13967383366.75366.750.0000.000
openbravopublicad_get_org_le_bu13764651309.18309.180.0000.000
openbravopublictrunc15851325.935.930.0000.000
openbravopublicto_char1311330.410.410.0000.000
openbravopublicad_istriggerenabled982810.990.990.0000.000
openbravopublicto_number469120.410.410.0000.000
openbravopublicad_isorgincluded196520.420.420.0000.000
openbravopublicuuid_generate_v4157260.100.100.0000.000
openbravopublicad_column_identifier142787.977.870.0010.001
openbravopublicad_column_identifier_std142648.410.470.0010.000
openbravopublicretstk_basic_json111885.530.180.0000.000
openbravopublicretstk_basic_json_lang111885.350.220.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicc_orderline2_trg41880.590.530.0000.000
openbravopublicfash_orderline_check_status41880.400.380.0000.000
openbravopublicc_ordline_chk_restrictions_trg41880.320.290.0000.000
openbravopublicc_bpartner_trg3110.260.250.0010.001
openbravopublicaprm_fin_pmt_check_trg30540.250.200.0000.000
openbravopublicc_orderline_trg241880.240.200.0000.000
openbravopublicfash_copy_c_orderline41880.210.090.0000.000
openbravopublicfash_update_fshordline_trg41880.210.180.0000.000
openbravopublicaprm_fin_pmt_detail_check_trg15120.200.170.0000.000
openbravopublicm_transaction_trg13160.190.140.0000.000
openbravopublicc_order_chk_restrinctions_trg18760.190.130.0000.000
openbravopublicphieco_orderline_trg41880.190.160.0000.000
openbravopublicc_orderline_trg41880.180.150.0000.000
openbravopublicintr_c_orderline_trg41880.170.140.0000.000
openbravopublicaprm_fin_finacc_tran_check_trg15500.150.130.0000.000
openbravopublicc_bpartner_location_trg5430.140.070.0000.000
openbravopublicobcfr_obpos_applications_trg17880.100.070.0000.000
openbravopublicfash_set_qtyinitial41880.080.060.0000.000
openbravopublicfin_financial_account_trg27160.080.070.0000.000
openbravopublicc_order_trg13280.070.040.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
openbravopg_defaultpublicc_import_entry77778777877787
openbravopg_defaultprofilelast_stat_tables353923843563923854
openbravopg_defaultprofilelast_stat_indexes35672981633672982
openbravopg_defaultprofilelast_stat_user_functions359039909903948
openbravopg_defaultpublicobpos_applications1619201776
openbravopg_defaultpg_catalogpg_statistic1110679509
openbravopg_defaultpublicad_ep_instance_para16868
openbravopg_defaultpublicad_sequence122862189
openbravopg_defaultprofilelast_stat_database19292

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
openbravopg_defaultpublicc_import_entry96778777877787
openbravopg_defaultprofilelast_stat_tables46233923843563923854
openbravopg_defaultprofilelast_stat_indexes4623672981633672982
openbravopg_defaultprofilelast_stat_user_functions46239039909903948
openbravopg_defaultpublicobpos_applications3119201776
openbravopg_defaultprofilelast_stat_tablespaces234646
openbravopg_defaultpublicad_sequence1922862189
openbravopg_defaultpublicad_process_request8304300
openbravopg_defaultpublicfin_financial_account8726701
openbravopg_defaultprofilelast_stat_database39292
openbravopg_defaultpublicad_ep_instance_para26868
openbravopg_defaultprofilesample_stat_tables243564558
openbravopg_defaultprofilesample_stat_indexes214041624
openbravopg_defaultprofilesample_statements212821411
openbravopg_defaultprofilesample_stat_user_functions2616767
openbravopg_defaultprofilesample_stat_tablespaces12632
openbravopg_defaultprofilesample_stat_database15660
openbravopg_defaultprofilesample_stat_tables_total1120136
openbravopg_defaultprofilesample_stat_indexes_total16068
openbravopg_defaultprofilesample_statements_total14554

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
openbravopg_defaultprofilelast_stat_indexespk_last_stat_indexes17 MB35486 kB1936 kB
openbravopg_defaultpublicc_import_entryc_import_entry_key13 MB77159 kB1336 kB
openbravopg_defaultpublicc_import_entryc_import_entry_type_status_idx12 MB77141 kB1336 kB
openbravopg_defaultprofilelast_stat_tablespk_last_stat_tables9920 kB35281 kB1483 kB
openbravopg_defaultpublicc_import_entryem_obpos_application_fk9472 kB77108 kB1336 kB
openbravopg_defaultpublicc_import_entryc_import_entry_idx9144 kB77104 kB1336 kB
openbravopg_defaultpublicc_import_entry(TOAST)pg_toast_53108_index4584 kB5871 kB2334 kB
openbravopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index272 kB1272 kB4968 kB
openbravopg_defaultpublicobpos_applicationsobpos_app_prefix256 kB1616 kB158 kB
openbravopg_defaultpublicobpos_applicationsobpos_terminal_key_id_un256 kB1616 kB158 kB
openbravopg_defaultpublicobpos_applicationsobpos_value_un256 kB1616 kB158 kB
openbravopg_defaultpublicobpos_applicationsobpos_app_pk256 kB1616 kB158 kB
openbravopg_defaultpublicobpos_applicationsobpos_app_tertype256 kB1616 kB158 kB
openbravopg_defaultpublicobpos_applicationsobpos_applications_name256 kB1616 kB158 kB
openbravopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index240 kB380 kB3709 kB
openbravopg_defaultpublicobpos_applicationsobpos_applications_master_idx128 kB168192 bytes158 kB
openbravopg_defaultpublicad_sequencead_sequence_name104 kB1104 kB240 kB
openbravopg_defaultpublicad_sequencead_sequence_key56 kB156 kB240 kB
openbravopg_defaultpublicad_ep_instance_paraad_ep_instance_para_key16 kB116 kB48 kB
openbravopg_defaultprofilelast_stat_databasepk_last_stat_database16 kB116 kB40 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_tables310784558122026-07-17 23:00:56.394842+029312 kB
openbravopg_catalogpg_attribute3505731002026-07-19 03:13:30.46086+025184 kB

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_tables310784558224562026-07-19 20:01:03.274239+029312 kB
openbravopg_catalogpg_attribute3505731062012026-07-19 03:13:30.814358+025184 kB
openbravopublicm_inoutline1511289013550656 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-19 03:00:05.329789+02
pg_postmaster_start_time2026-07-19 03:00:05.874892+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