Postgres profile report (StartID: 477, EndID: 500)

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-19 04:00:02+01 - 2026-07-20 03:00:02+01

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
openbravo783411576094.742190106263947497510234620325443709984100814975526128562893310 GB310 MB
postgres1170599.9534865773819059193480486391 kB
Total795116576094.742190109743948155248234639384633710332148814975526128562893310 GB310 MB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
openbravo1191148816152.03157.7147186144232482824618225541783197135571
postgres56128.6286756345
template163488.277176276
Total1192344816168.92157.7147187083552482824618225541783197136192

Cluster statistics

MetricValue
Scheduled checkpoints276
Requested checkpoints
Checkpoint write time (s)40867.31
Checkpoint sync time (s)16.84
Checkpoints buffers written1206688
Background buffers written100651
Backend buffers written48471
Backend fsync count
Bgwriter interrupts (too many buffers)708
Number of buffers allocated21578831
WAL generated8354 MB
WAL segments archived523
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default310 GB310 MB
pg_global1014 kB

SQL query statistics

Top SQL by execution time

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

4aae53f3da

[5b93a467]

openbravo2621.5216.2118996.55616384.202282388.03922596.782138

9918228dba

[9603f2b6]

openbravo2601.8816.09211729602.148551.670861.30330.0184321

59ed037ff5

[f51c7e38]

openbravo1494.669.24522164985.38452520.58488698.1979259.12823

634a705cf9

[3111e984]

openbravo1488.239.205221285.04724.4943502.131544.1005221

6aeca8addc

[e0869ab2]

openbravo1091.626.757910.2567563.8009522.078248.421138

66933eedde

[a6742d25]

openbravo706.624.3733295838.5020.0224789.95434.21083113

416d959161

[fb2a3095]

openbravo650.434.024713.2564224.93521033.9141787.980138

ec8c626e99

[cd9c0fd2]

openbravo365.992.266093365993.553365993.553365993.5531

67a75a3409

[7318d810]

openbravo345.772.1438093045345773.374345773.374345773.3741

22615c404b

[c1020a32]

openbravo188.281.1617188282.073188282.073188282.0731

86332db8f0

[92ec818a]

openbravo182.581.1330646465182583.138182583.138182583.1381

6e47e0b2e7

[c4153bc0]

openbravo168.341.042020016825.209450.9428506.104551.887204

b57306362a

[ba9b8900]

openbravo168.311.041111151.498140.130440.60010.0631111

439a14cffe

[f3303a00]

openbravo167.361.04150.640137.998439.60910.0561111

2fc2aa8125

[3fe437d2]

openbravo150.900.93649723.2260.0241922.56765.3716497

2e210c7585

[cd0b881c]

openbravo137.210.8532707206137207.107137207.107137207.1071

be462fba22

[569d183d]

openbravo126.540.7814263260126543.175126543.175126543.1751

695482b977

[ae9bc6b7]

openbravo124.210.7714407320124207.749124207.749124207.7491

ff35139986

[a35d3b99]

openbravo115.610.721150100.53243.3521924.54776.4471150

7efafc5af2

[74267a2]

openbravo115.570.711150100.49543.3271924.51776.4301150

Top SQL by executions

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

10410964a2

[6df21622]

openbravo6098045.116098040.0030.0014.1990.0081.7

a46753d96b

[d2788d4]

openbravo5455184.585455180.0030.0011.2190.0031.5

7247cdc8b5

[aada7118]

openbravo2450072.05110120.0100.00310.1070.0352.4

784dd58a53

[c7e884e0]

openbravo2080021.742080020.0030.00210.6020.0230.7

f2e5c3fd88

[2b8e321f]

openbravo1994951.671994950.0060.0020.8410.0041.1

1b89da5cec

[6f9b1a85]

openbravo1795071.510.0010.0000.1590.0010.1

8a7672d920

[2049516b]

openbravo1755031.470.0010.0000.2430.0010.1

03a1d4e90c

[1c1c8a81]

openbravo1729541.451729540.0030.0020.2740.0020.5

08c88cedcc

[6d0d7fc]

openbravo1636181.371636180.0050.0020.3980.0040.8

b93f3a3e02

[30f21dca]

openbravo1383911.161383910.2550.2054.6530.06035.3

ab6445a3b6

[a5716dbe]

openbravo1383911.161383910.2290.2032.1090.04431.7

2bbd1014ed

[d9433e44]

openbravo1223301.031223300.0030.0020.2620.0020.3

9a0540688d

[263f5b0b]

openbravo1174970.99643990.0040.0010.5920.0040.4

7f59edd627

[81592075]

openbravo1151400.971151400.0030.0020.8870.0030.3

281ee3922a

[5d6197e1]

openbravo1016500.851016500.0070.0041.1960.0120.7

1452c325d3

[880044aa]

openbravo1003870.841003870.0020.0010.0660.0010.2

59de48c20b

[3081048d]

openbravo901350.76901350.0040.0020.4450.0030.4

943d79be4b

[b86e6a95]

openbravo860360.72860360.0020.0010.0380.0000.1

66933eedde

[a6742d25]

openbravo831130.7033295838.5020.0224789.95434.210706.6

b9a73dbea9

[2b7ebfcc]

openbravo818800.69818800.0090.0070.7240.0050.8

Top SQL by shared blocks fetched

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

4aae53f3da

[5b93a467]

openbravo148819094831.5493.682621.5138

66933eedde

[a6742d25]

openbravo73309608915.5499.99706.6332958383113

6aeca8addc

[e0869ab2]

openbravo66207310414.0399.941091.6138

59ed037ff5

[f51c7e38]

openbravo4304393079.1299.591494.7522123

634a705cf9

[3111e984]

openbravo4294553179.1099.591488.252215221

416d959161

[fb2a3095]

openbravo1378125372.9232.19650.4138

6e47e0b2e7

[c4153bc0]

openbravo1275527932.7099.94168.32020016204

b4d6b6665e

[72db11e8]

openbravo806907021.7199.6859.4138

2fc2aa8125

[3fe437d2]

openbravo688469451.4699.78150.964976497

9918228dba

[9603f2b6]

openbravo588102541.25100.002601.92117294321

b57306362a

[ba9b8900]

openbravo374259920.7999.91168.311111111

439a14cffe

[f3303a00]

openbravo373785860.7999.92167.41111

f570d33a96

[57d3e9b9]

openbravo208919080.4496.6757.5138

22615c404b

[c1020a32]

openbravo141774080.3083.33188.3171

ff35139986

[a35d3b99]

openbravo133586210.2899.48115.611501150

7efafc5af2

[74267a2]

openbravo133566060.2899.48115.611501150

4cb9cc1cbf

[ea4e56b9]

openbravo133552110.2899.48115.511501150

9f02b11411

[74c1276a]

openbravo133183740.28100.0021.27849

b51ae16f3e

[e945b846]

openbravo123279260.2699.4625.552

03d9123317

[94eb716f]

openbravo123020090.2690.5818.722

Top SQL by shared blocks read

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

4aae53f3da

[5b93a467]

openbravo9407794342.5493.682621.5138

416d959161

[fb2a3095]

openbravo9344746242.2532.19650.4138

67a75a3409

[7318d810]

openbravo40216371.820.00345.8380930451

22615c404b

[c1020a32]

openbravo23632231.0783.33188.3171

59ed037ff5

[f51c7e38]

openbravo17630530.8099.591494.7522123

634a705cf9

[3111e984]

openbravo17611000.8099.591488.252215221

86332db8f0

[92ec818a]

openbravo16734770.760.00182.6306464651

03d9123317

[94eb716f]

openbravo11589680.5290.5818.722

089f5b9354

[9c2209ed]

openbravo9871760.452.0993.2200971621

b88437ee76

[4def43cd]

openbravo9805730.441.6386.272842011

2e210c7585

[cd0b881c]

openbravo9636770.44137.2327072061

695482b977

[ae9bc6b7]

openbravo9535570.4314.30124.2144073201

be462fba22

[569d183d]

openbravo8774730.407.75126.5142632601

e1739d379d

[6f92ba97]

openbravo8704470.394.1787.370358611

ffcd2dfda5

[336527ac]

openbravo7408650.3376.9124585801

58f46f2fd3

[54e476f8]

openbravo7386320.338.098.66926621

214f622e78

[ab56bf1d]

openbravo7380890.3384.6911.2246

f570d33a96

[57d3e9b9]

openbravo6960040.3196.6757.5138

84dd1037ec

[90c9c123]

openbravo6719320.3069.4562.951073

ec8c626e99

[cd9c0fd2]

openbravo6604900.303.19366.060931

Top SQL by shared blocks dirtied

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

d545a87b3d

[a03a69a5]

openbravo18273410.0398.2230.95667256672

6758866a26

[eb67e33f]

openbravo967025.3197.3612.86731267312

8d75ee1767

[3695269c]

openbravo698243.8397.2414.31600516005

7efafc5af2

[74267a2]

openbravo642923.5399.48115.611501150

ff35139986

[a35d3b99]

openbravo642923.5399.48115.611501150

4cb9cc1cbf

[ea4e56b9]

openbravo642923.5399.48115.511501150

22615c404b

[c1020a32]

openbravo407182.2383.33188.3171

101ed24576

[205b8c88]

openbravo384232.1198.616.81333613336

43a80059e4

[bfd8039a]

openbravo344111.8999.4252.311431143

fec93ea334

[2ff59f28]

openbravo302391.6699.946.76156261562

e1739d379d

[6f92ba97]

openbravo302271.664.1787.370358611

7cdb887c2a

[8f1d721]

openbravo295781.6299.7420.769176917

fa5e805d20

[6bdd6481]

openbravo295721.6298.908.269176917

26959f7c7a

[d3eb78]

openbravo274901.5193.577.41343513435

75890e23a4

[baa0f6d7]

openbravo242311.3399.8712.979617961

320ed06a6d

[41b729f2]

openbravo205811.1397.843.148414841

d5c8e0e271

[89ff8432]

openbravo193181.0697.081.264286428

86ae00e408

[12018251]

openbravo191971.0590.823.753435343

b25c4a7154

[fd3270b5]

openbravo176730.9799.920.81318813188

1b416379ea

[97b6b91a]

openbravo170750.9497.602.749814981

Top SQL by shared blocks written

Query IDDatabaseWritten%Total%BackendWHits(%)Elapsed(s)RowsExecutions

03d9123317

[94eb716f]

openbravo20420.154.2190.5818.722

2e210c7585

[cd0b881c]

openbravo70.000.01137.2327072061

Top SQL by temp usage

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

c5d3b5bcfa

[20b0132a]

openbravo7286099.1859530.190.37108471084

7537b8243c

[1f7436a8]

openbravo1053599.62402.030.01042010420

de314a5f3c

[61de99de]

openbravo948199.58402.030.093669366

145f4813e8

[b3fcd991]

openbravo956899.61371.880.094619461

e2c4a72c8d

[f9c6c1e1]

openbravo849899.58361.830.083928392

38988e8d9f

[b3e83c24]

openbravo845099.59351.780.083548354

2d3fd9a51f

[d08e63cd]

openbravo565899.49291.470.055785578

d92125f1e7

[d5ffdaf6]

openbravo472399.45261.320.046524652

a9d2b2152f

[fedec8dd]

openbravo643599.61251.270.063696369

f445aa8f91

[39b71312]

openbravo521299.54241.220.051455145

c44dfe02a3

[c3b2e232]

openbravo477799.50241.220.047144714

2b29a08c4c

[ff8319c1]

openbravo588199.59241.220.058165816

a62165991d

[48156064]

openbravo561499.61221.120.055555555

db31012b71

[5c49a5c1]

openbravo572399.62221.120.056665666

cfc6a9aece

[cd3a05ed]

openbravo573599.62221.120.056785678

2d3aa8cefc

[4c8bf5b0]

openbravo264099.20211.070.025862586

570c0e7d22

[6ad7f5b5]

openbravo529099.60211.070.052345234

fd1086c39a

[b14a7825]

openbravo467199.55211.070.046174617

fd0b1d2b52

[cd29d294]

openbravo453199.54211.070.044734473

ffbb2a6f9d

[3961f04f]

openbravo378999.47201.010.037363736

Complete list of SQL texts

QueryIDQuery Text
26959f7c7ainsert into M_Transaction_Cost (AD_Client_ID, AD_Org_ID, Created, Createdby, Updated, Updatedby, Isactive, M_Transaction_ID, Cost, CostDate, C_Currency_ID, IsUnitCost, DateAcct, M_Transaction_Cost_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)
08c88cedccSELECT $2 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
7efafc5af2SELECT C_ORDER_POST1(p_PInstance_ID, $2)
7cdb887c2ainsert into M_ProductionLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, M_ProductionPlan_ID, Line, M_Product_ID, MovementQty, M_Locator_ID, M_AttributeSetInstance_ID, C_UOM_ID, Calculated, Rejectedquantity, EM_Cactl_Added_Manually, M_ProductionLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18)
a46753d96bSELECT $2 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
86ae00e408insert 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)
03a1d4e90cSELECT $2 FROM ONLY "public"."c_currency" x WHERE "c_currency_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
7537b8243cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
8a7672d920COMMIT
101ed24576update C_Invoice set Updated=$1, DaysTillDue=$2, LastCalculatedOnDate=$3 where C_Invoice_ID=$4
c5d3b5bcfainsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
9a0540688dSELECT LEVELNO FROM AD_ORG_TREE WHERE AD_ORG_ID = p_orgid AND AD_PARENT_ORG_ID = p_parentorgid AND AD_CLIENT_ID = p_clientid
b9a73dbea9SELECT AD_CLIENT_ID,AD_ORG_ID, ISACTIVE, UPDATED,UPDATEDBY,ALIAS, COMBINATION, DESCRIPTION, ISFULLYQUALIFIED, C_ACCTSCHEMA_ID, ACCOUNT_ID, M_PRODUCT_ID, C_BPARTNER_ID,AD_ORGTRX_ID, C_LOCFROM_ID, C_LOCTO_ID, C_SALESREGION_ID, C_PROJECT_ID, C_CAMPAIGN_ID, C_ACTIVITY_ID, USER1_ID,USER2_ID, $2 as UseSuspenseBalancing, $3 as SuspenseBalancing_Acct, $4 as UseSuspenseError, $5 as SuspenseError_Acct, $6 as UseCurrencyBalancing, $7 as CurrencyBalancing_Acct, $8 as RetainedEarning_Acct, $9 as IncomeSummary_Acct, $10 as InterCompanyDueTo_Acct, $11 as InterCompanyDueFrom_Acct FROM C_ValidCombination WHERE C_ValidCombination_ID=$1
f2e5c3fd88SELECT $2 FROM ONLY "public"."m_product" x WHERE "m_product_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
fec93ea334UPDATE 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)
59de48c20bSELECT $2 FROM ONLY "public"."c_bpartner_location" x WHERE "c_bpartner_location_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
b93f3a3e02select count(*) as y0_ from AD_TreeNode this_ where this_.Node_ID=$1 and this_.Parent_ID<>$2 and this_.IsActive=$3
634a705cf9WITH orders AS ( SELECT SUM(ol.qtyordered) AS total FROM c_orderline ol JOIN c_order o ON o.c_order_id = ol.c_order_id WHERE ol.m_product_id = p_product AND o.ad_org_id = p_org AND o.issotrx = $6 AND o.dateordered BETWEEN current_date - v_days_consum AND current_date - $7 ), production AS ( SELECT SUM(pl.movementqty) AS total FROM m_productionline pl JOIN m_productionplan pp ON pp.m_productionplan_id = pl.m_productionplan_id JOIN m_production p ON p.m_production_id = pp.m_production_id WHERE pl.m_product_id = p_product AND pl.ad_org_id = p_org AND p.movementdate BETWEEN current_date - v_days_consum AND current_date - $8 ) SELECT COALESCE(orders.total, $9) + COALESCE(production.total, $10) FROM orders, production
ffcd2dfda5COPY public.prpass_pass_inst_hist (prpass_pass_inst_hist_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, value, status, c_orderline_id, c_order_id, dateordered, c_bpartner_id, m_product_id, obpos_applications_id, cancel, ad_creation_org_id, expirationdate, prpass_timeslots_detail_id, prpass_timeslots_res_id, time_first_pick, validate_manual, unlimited) TO stdout
8d75ee1767INSERT INTO Fact_Acct (Fact_Acct_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy, C_AcctSchema_ID,Account_ID, AcctValue, AcctDescription,DateTrx,DateAcct, C_Period_ID,AD_Table_ID,Record_ID,Line_ID, GL_Category_ID,C_Tax_ID,PostingType,C_Currency_ID, AmtSourceDR,AmtSourceCR,AmtAcctDR,AmtAcctCR, C_UOM_ID,Qty,M_Locator_ID,M_Product_ID,C_BPartner_ID,AD_OrgTrx_ID,C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID,C_Campaign_ID,C_Activity_ID,User1_ID,User2_ID,Description, Fact_Acct_Group_ID, SeqNo, DocBaseType, Record_ID2, A_ASSET_ID, C_WithHolding_ID, C_DocType_ID, C_Costcenter_ID, FACTACCTTYPE) VALUES ($1, $2, $3,$48,now(),$4,now(),$5, $6, $7, $8, $9, TO_DATE($10), TO_DATE($11), $12, $13, $14, $15, $16, $17, $18, $19, TO_NUMBER($20), TO_NUMBER($21), TO_NUMBER($22), TO_NUMBER($23), $24, TO_NUMBER($25), $26,$27, $28, $29,$30, $31, $32,$33, $34, $35,$36, $37, $38, $39, TO_NUMBER($40), $41, $42, $43, $44, $45, $46, $47)
ffbb2a6f9dinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
f445aa8f91insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2fc2aa8125select materialmg0_.M_Costing_ID as M_Costin1_453_, materialmg0_.Created as Created2_453_, materialmg0_.Createdby as Createdb3_453_, materialmg0_.Updated as Updated4_453_, materialmg0_.Updatedby as Updatedb5_453_, materialmg0_.AD_Client_ID as AD_Clien6_453_, materialmg0_.AD_Org_ID as AD_Org_I7_453_, materialmg0_.M_Product_ID as M_Produc8_453_, materialmg0_.DateFrom as DateFrom9_453_, materialmg0_.DateTo as DateTo10_453_, materialmg0_.IsManual as IsManua11_453_, materialmg0_.C_InvoiceLine_ID as C_Invoi12_453_, materialmg0_.Qty as Qty13_453_, materialmg0_.Price as Price14_453_, materialmg0_.Cumstock as Cumstoc15_453_, materialmg0_.Costtype as Costtyp16_453_, materialmg0_.Ispermanent as Isperma17_453_, materialmg0_.Cost as Cost18_453_, materialmg0_.Cumcost as Cumcost19_453_, materialmg0_.Isproduction as Isprodu20_453_, materialmg0_.Isactive as Isactiv21_453_, materialmg0_.M_Warehouse_ID as M_Wareh22_453_, materialmg0_.M_Transaction_ID as M_Trans23_453_, materialmg0_.C_Currency_ID as C_Curre24_453_, materialmg0_.Originalcost as Origina25_453_ from M_Costing materialmg0_ where materialmg0_.M_Product_ID=$1 and materialmg0_.DateFrom<=$2 and materialmg0_.Costtype=$7 and (materialmg0_.Cost is not null) and (materialmg0_.Cumstock is not null) and (materialmg0_.Cumcost is not null) and (materialmg0_.M_Warehouse_ID is null) and materialmg0_.AD_Org_ID=$3 and (materialmg0_.AD_Client_ID in ($4 , $5)) and materialmg0_.Isactive=$8 order by materialmg0_.DateFrom desc, materialmg0_.DateTo desc, materialmg0_.Created desc limit $6
320ed06a6dinsert into C_InvoiceLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, C_OrderLine_ID, M_InOutLine_ID, Line, Description, Financial_Invoice_Line, M_Product_ID, QtyInvoiced, PriceList, PriceActual, LineNetAmt, C_UOM_ID, C_Tax_ID, IsDescription, PriceStd, Excludeforwithholding, Iseditlinenetamt, Line_Gross_Amount, Gross_Unit_Price, C_Bpartner_ID, grosspricestd, Grosspricelist, IsDeferred, Explode, Match_Lccosts, EM_Prdd_Distribute_Dimensions, EM_Priuti_Discount, EM_Priuti_Updatepricelist, EM_Priuti_Pricelist_Updated, C_InvoiceLine_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)
a62165991dinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2d3aa8cefcinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
b88437ee76COPY public.c_order (c_order_id, 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, dateprinted, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, poreference, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, m_shipper_id, c_charge_id, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, posted, ad_user_id, copyfrom, dropship_bpartner_id, dropship_location_id, dropship_user_id, isselfservice, ad_orgtrx_id, user1_id, user2_id, deliverynotes, c_incoterms_id, incotermsdescription, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, fin_payment_priority_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, c_return_reason_id, rm_addorphanline, a_asset_id, calculate_promotions, c_costcenter_id, convertquotation, c_reject_reason_id, validuntil, quotation_id, so_res_status, create_polines, iscashvat, rm_pickfromreceipt, cancelandreplace, confirmcancelandreplace, cancelledorder_id, replacedorder_id, iscancelled, replacementorder_id, em_aprm_addpayment, bpartner_extref, em_obmfm_selectfreight, em_obmfm_delivery_period_id, em_obmfm_delivery_charges, em_obmfm_freight_id, em_obmfm_weight, em_obmfm_weight_uom_id, em_obmfm_set_weight, em_aeatsii_fecha_operacion, em_aeatsii_descripcion_sii, em_obdisc_addpack, em_obpos_applications_id, em_obpos_sendemail, em_obpos_email_status, em_obpos_app_cashup_id, em_obpos_createdabsolute, em_obpos_notinvoiceoncashup, em_obpos_rejected_quotat_id, em_obpos_isdeleted, em_obpos_islayaway, em_obpos_prepaymentamt, em_obpos_prepaymentlimitamt, em_obpos_prepaymentlaylimitamt, em_obpos_rounding_amount, em_ml_select_product, em_ml_select_product_byattrib, em_prouti_order_stock, em_prouti_pregenerate_minout, em_prouti_sotopo, em_prouti_generate_pick_inv, em_prouti_order_id, em_prouti_grandtotalinitial, em_prouti_dateclosed, em_prouti_totallinesinitial, em_prouti_changebpartner, em_prouti_recalculate_price, em_prouti_pricecalculatetdate, em_prouti_reactiveorder, em_prouti_totalizations, em_prouti_invoiced, em_prouti_received, em_prouti_initial_received, em_obcma_c_poc_email_id, em_obsmail_emailaddress, em_obwpl_generatepicking, em_obwpl_isinpickinglist, em_obwpl_readypl, em_obpos_sequencename, em_obpos_sequencenumber, em_prres_reservation_id, em_prres_responsible_id, em_prres_diners, em_prrgr_locator_id, em_advcrm_newactivity, em_advcrm_opportunity_id, em_prres_sended, em_prres_printed, em_pricm_order_id, em_prouti_status_of_review, em_prouti_validate_order, em_prouti_start_review, em_prtoma_tomaticket_id, em_prtoma_jsonorder, em_prtoma_grossamount, em_sgpcrm_securitygroups_id, em_cactl_iscopy, em_prres_paid_on_credit, em_cactl_internal_notes_group, em_prqc_clauses_selector, em_rcinv_contractdate, em_rcinv_initialdate, em_rcinv_enddate, em_rcinv_frequency, em_rcinv_renewautomatically, em_rcinv_renovationtimes, em_rcinv_freqrenovationtime, em_rcinv_ordercontract_id, em_rcinv_freqtime, em_rcinv_cancelcontract, em_rcinv_cancelleddate, em_rcinv_iscancelled, em_psat_activity_id, em_prqr_execute, em_prqr_execute_purchase, em_prqr_return_select_prod, em_prqr_credit_purchase_id, em_prqr_executecredit, em_paytef_transactionreference, em_cactl_forceselectedproject, em_cactl_indirect_cost_id, em_cactl_calculate_cost, em_cactl_totalcost, em_cactl_verified_return, em_prouti_select_soline, em_prouti_addlines_btn, em_prouti_return_quantity, em_prouti_initial_bp_id, em_prouti_changebpartner_bgt, em_cactl_duplicate_budget, em_prcpr_is_cloned, em_prres_orig_order_id) TO stdout
58f46f2fd3COPY public.prpass_pass_inst (prpass_pass_inst_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, value, status, c_orderline_id, c_order_id, dateordered, c_bpartner_id, m_product_id, obpos_applications_id, cancel, ad_creation_org_id, expirationdate, em_cactl_gl_journal_id, prpass_timeslots_detail_id, prpass_timeslots_res_id, time_first_pick, validate_manual, unlimited) TO stdout
be462fba22COPY public.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, financial_invoice_line, account_id, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, c_charge_id, chargeamt, c_uom_id, c_tax_id, s_resourceassignment_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, c_invoice_discount_id, c_projectline_id, m_offer_id, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, periodnumber, grosspricestd, a_asset_id, defplantype, grosspricelist, c_project_id, isdeferred, c_period_id, c_costcenter_id, user1_id, user2_id, explode, bom_parent_id, match_lccosts, c_aum, aumqty, em_prdd_distribute_dimensions, em_priuti_discount, em_priuti_updatepricelist, em_priuti_pricelist_updated) TO stdout
f570d33a96SELECT * 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 and ci.dateinvoiced >= current_date - $12 group by ci.documentno, EXTRACT($13 FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno)>$14 order by max(dateinvoiced) desc ) as f) AAA where not exists (select $15 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $16) != $17)
4aae53f3daSELECT * FROM (select c_order_id AS referencekey_id, ad_column_identifier_std($2, c_order_id) AS record_id, $3 AS ad_role_id, $4 AS ad_user_id, $5 || documentno AS description, $6 AS isActive, $7 AS ad_org_id, ad_client_id AS ad_client_id, now() AS created, $8 AS createdBy, now() AS updated, $9 AS updatedBy from c_order where ( em_prouti_Received <> (coalesce((select case when sum(abs(ol.qtyordered)) = $10 then $11 else trunc(coalesce(sum(abs(coalesce(( select least(coalesce(abs(sum(il.movementqty)), $12), abs(ol.qtyordered)) from m_inoutline il left join m_inout i on i.m_inout_id=il.m_inout_id where i.docstatus<>$13 and il.c_orderline_id=ol.c_orderline_id ),$14))), $15)/sum(abs(ol.qtyordered)) * $16, $17) end from c_orderline ol where ol.c_order_id=c_order.c_order_id and ol.c_order_discount_id is null ),$18)) or em_prouti_Invoiced <> (coalesce(( select case when sum(abs(ol.qtyordered)) = $19 then $20 else round(coalesce(sum(abs(coalesce(( select least(coalesce(abs(sum(il.qtyinvoiced)), $21), abs(ol.qtyordered)) from c_invoiceline il left join c_invoice i on i.c_invoice_id=il.c_invoice_id where i.docstatus<>$22 and il.c_orderline_id=ol.c_orderline_id ),$23))), $24)/sum(abs(ol.qtyordered)) * $25, $26) end from c_orderline ol where ol.c_order_id=c_order.c_order_id and ol.c_order_discount_id is null), $27)) ) and issotrx=$28 and docstatus <> $29) AAA where not exists (select $30 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $31) != $32)
db31012b71insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
281ee3922aSELECT $2 FROM ONLY "public"."c_order" x WHERE "c_order_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
de314a5f3cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
570c0e7d22insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
fa5e805d20insert into M_Transaction (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, MovementType, M_Locator_ID, M_Product_ID, MovementDate, MovementQty, M_ProductionLine_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)
10410964a2SELECT $2 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
e1739d379dCOPY public.c_invoice (c_invoice_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, posted, c_doctype_id, c_doctypetarget_id, c_order_id, description, isprinted, salesrep_id, dateinvoiced, dateprinted, dateacct, c_bpartner_id, c_bpartner_location_id, poreference, isdiscountprinted, dateordered, c_currency_id, c_paymentterm_id, c_charge_id, chargeamt, totallines, grandtotal, m_pricelist_id, istaxincluded, c_campaign_id, c_project_id, c_activity_id, createfrom, generateto, ad_user_id, copyfrom, isselfservice, ad_orgtrx_id, user1_id, user2_id, withholdingamount, taxdate, c_withholding_id, ispaid, totalpaid, outstandingamt, daystilldue, dueamt, lastcalculatedondate, fin_paymentmethod_id, fin_payment_priority_id, finalsettlement, daysoutstanding, percentageoverdue, c_costcenter_id, calculate_promotions, a_asset_id, iscashvat, prepaymentamt, createfromorders, createfrominouts, em_aprm_addpayment, em_aprm_processinvoice, paidamtatinvoicing, bpartner_extref, em_einv_generated, em_einv_sent, em_aeatsii_send, em_aeatsii_issent, em_aeatsii_fecha_operacion, em_aeatsii_clave_tipo, em_aeatsii_motivo_rectif, em_aeatsii_clave_tipo_fc, em_aeatsii_tipo_rectif, em_aeatsii_dua, em_aeatsii_fecha_dua, em_aeatsii_estado, em_aeatsii_error_registral, em_aeatsii_modif, em_aeatsii_modified, em_aeatsii_description_id, em_aeatsii_descripcion_sii, em_aeatsii_fecha_reg_cont, em_aeatsii_dup, em_aeatsii_error_code, em_aeatsii_error_msg, em_aeatsii_unsubscribe, em_aeatsii_pur_description_id, em_aeatsii_multi_dua, em_aeatsii_ejercicio, em_aeatsii_periodo, em_aeatsii_autofactura, em_aeatsii_invoice_id, em_aeatsii_insiidate, em_aeatsii_cause_exemption_id, em_aeatsii_isauthorization, em_aeatsii_authorizationno, em_obpos_rounding_amount, em_ml_select_product, em_prouti_recalculate_price, em_prouti_pricecalculatetdate, em_prouti_totalizations, em_obcma_c_poc_email_id, em_obpos_sequencename, em_obpos_sequencenumber, em_advcrm_newactivity, em_priuti_createpurchinv, em_priuti_generated, em_priuti_date_complete, em_priuti_user_complete_id, em_priuti_status_of_review, em_priuti_validate, em_priuti_start_review, em_prges_expediente_id, em_prges_annotation_id, em_prges_record_number, em_prges_grantotal, em_sgpcrm_securitygroups_id, em_prges_poreference, em_cactl_createfromship) TO stdout
1b89da5cecBEGIN
b4d6b6665eSELECT * FROM (select inst.prpass_pass_inst_id AS referencekey_id, inst.value AS record_id, $2 AS ad_role_id, $3 AS ad_user_id, $4||inst.value AS description, $5 AS isActive, inst.ad_org_id, inst.ad_client_id, now() AS created, $6 AS createdBy, now() AS updated, $7 AS updatedBy from prpass_pass_inst inst where value IN ( select value from prpass_pass_inst where created >= current_date - $8 group by value having count(value) > $9 )) AAA where not exists (select $10 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $11) != $12)
67a75a3409COPY public.fact_acct (fact_acct_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_acctschema_id, account_id, datetrx, dateacct, c_period_id, ad_table_id, record_id, line_id, gl_category_id, c_tax_id, m_locator_id, postingtype, c_currency_id, amtsourcedr, amtsourcecr, amtacctdr, amtacctcr, c_uom_id, qty, m_product_id, c_bpartner_id, ad_orgtrx_id, c_locfrom_id, c_locto_id, c_salesregion_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, description, a_asset_id, fact_acct_group_id, seqno, factaccttype, docbasetype, acctvalue, acctdescription, record_id2, c_withholding_id, c_doctype_id, c_costcenter_id, ismodify, datebalanced) TO stdout
9f02b11411select materialmg0_.M_Transaction_ID as M_Transa1_558_, materialmg0_.AD_Client_ID as AD_Clien2_558_, materialmg0_.AD_Org_ID as AD_Org_I3_558_, materialmg0_.IsActive as IsActive4_558_, materialmg0_.Created as Created5_558_, materialmg0_.CreatedBy as CreatedB6_558_, materialmg0_.Updated as Updated7_558_, materialmg0_.UpdatedBy as UpdatedB8_558_, materialmg0_.MovementType as Movement9_558_, materialmg0_.M_Locator_ID as M_Locat10_558_, materialmg0_.M_Product_ID as M_Produ11_558_, materialmg0_.MovementDate as Movemen12_558_, materialmg0_.MovementQty as Movemen13_558_, materialmg0_.M_InventoryLine_ID as M_Inven14_558_, materialmg0_.M_MovementLine_ID as M_Movem15_558_, materialmg0_.M_InOutLine_ID as M_InOut16_558_, materialmg0_.M_ProductionLine_ID as M_Produ17_558_, materialmg0_.C_ProjectIssue_ID as C_Proje18_558_, materialmg0_.M_AttributeSetInstance_ID as M_Attri19_558_, materialmg0_.M_Product_Uom_Id as M_Produ20_558_, materialmg0_.QuantityOrder as Quantit21_558_, materialmg0_.C_UOM_ID as C_UOM_I22_558_, materialmg0_.M_Internal_Consumptionline_ID as M_Inter23_558_, materialmg0_.TransactionCost as Transac24_558_, materialmg0_.TrxProcessDate as TrxProc25_558_, materialmg0_.M_Costing_Algorithm_ID as M_Costi26_558_, materialmg0_.IsCostCalculated as IsCostC27_558_, materialmg0_.C_Currency_ID as C_Curre28_558_, materialmg0_.Costing_Status as Costing29_558_, materialmg0_.Checkreservedqty as Checkre30_558_, materialmg0_.Isprocessed as Isproce31_558_, materialmg0_.Checkpricedifference as Checkpr32_558_, materialmg0_.EM_Prouti_Exported as EM_Prou33_558_, materialmg0_.Manualcostadjustment as Manualc34_558_, materialmg0_.IsCostPermanent as IsCostP35_558_, materialmg0_.EM_Pricm_Inoutline_ID as EM_Pric36_558_ from M_Transaction materialmg0_ inner join M_ProductionLine manufactur1_ on materialmg0_.M_ProductionLine_ID=manufactur1_.M_ProductionLine_ID inner join M_ProductionPlan materialmg2_ on manufactur1_.M_ProductionPlan_ID=materialmg2_.M_ProductionPlan_ID where materialmg2_.Line<$1 and materialmg2_.M_Production_ID=$2 and manufactur1_.M_Product_ID=$3 and manufactur1_.MovementQty>0 and materialmg0_.IsCostCalculated='N' and (materialmg0_.AD_Org_ID in ($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)) and (materialmg0_.AD_Client_ID in ($42 , $43)) and materialmg0_.IsActive='Y'
7f59edd627SELECT 1 FROM ONLY "public"."m_locator" x WHERE "m_locator_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
1452c325d3SELECT 1 FROM ONLY "public"."m_attributesetinstance" x WHERE "m_attributesetinstance_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
d5c8e0e271INSERT 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 )
84dd1037ecINSERT INTO prpass_pass_trans_hist ( prpass_pass_trans_hist_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, prpass_pass_inst_hist_id, ad_validation_org_id, ad_validation_user_id, obpos_applications_id) SELECT prpass_pass_trans_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, prpass_pass_inst_id, ad_validation_org_id, ad_validation_user_id, obpos_applications_id FROM prpass_pass_trans WHERE prpass_pass_inst_id = ANY ($1)
86332db8f0COPY public.m_transaction (m_transaction_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, movementtype, m_locator_id, m_product_id, movementdate, movementqty, m_inventoryline_id, m_movementline_id, m_inoutline_id, m_productionline_id, c_projectissue_id, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, m_internal_consumptionline_id, transactioncost, trxprocessdate, m_costing_algorithm_id, iscostcalculated, c_currency_id, costing_status, checkreservedqty, isprocessed, checkpricedifference, manualcostadjustment, iscostpermanent, em_prouti_exported, em_pricm_inoutline_id) TO stdout
03d9123317select order0_.C_Order_ID as C_Order_1_276_, order0_.AD_Client_ID as AD_Clien2_276_, order0_.AD_Org_ID as AD_Org_I3_276_, order0_.IsActive as IsActive4_276_, order0_.Created as Created5_276_, order0_.CreatedBy as CreatedB6_276_, order0_.Updated as Updated7_276_, order0_.UpdatedBy as UpdatedB8_276_, order0_.IsSOTrx as IsSOTrx9_276_, order0_.DocumentNo as Documen10_276_, order0_.DocStatus as DocStat11_276_, order0_.DocAction as DocActi12_276_, order0_.Processing as Process13_276_, order0_.Processed as Process14_276_, order0_.C_DocType_ID as C_DocTy15_276_, order0_.C_DocTypeTarget_ID as C_DocTy16_276_, order0_.Description as Descrip17_276_, order0_.IsDelivered as IsDeliv18_276_, order0_.IsInvoiced as IsInvoi19_276_, order0_.IsPrinted as IsPrint20_276_, order0_.IsSelected as IsSelec21_276_, order0_.SalesRep_ID as SalesRe22_276_, order0_.DateOrdered as DateOrd23_276_, order0_.DatePromised as DatePro24_276_, order0_.DatePrinted as DatePri25_276_, order0_.DateAcct as DateAcc26_276_, order0_.C_BPartner_ID as C_BPart27_276_, order0_.BillTo_ID as BillTo_28_276_, order0_.C_BPartner_Location_ID as C_BPart29_276_, order0_.POReference as PORefer30_276_, order0_.IsDiscountPrinted as IsDisco31_276_, order0_.C_Currency_ID as C_Curre32_276_, order0_.PaymentRule as Payment33_276_, order0_.C_PaymentTerm_ID as C_Payme34_276_, order0_.InvoiceRule as Invoice35_276_, order0_.DeliveryRule as Deliver36_276_, order0_.FreightCostRule as Freight37_276_, order0_.FreightAmt as Freight38_276_, order0_.DeliveryViaRule as Deliver39_276_, order0_.M_Shipper_ID as M_Shipp40_276_, order0_.C_Charge_ID as C_Charg41_276_, order0_.ChargeAmt as ChargeA42_276_, order0_.PriorityRule as Priorit43_276_, order0_.TotalLines as TotalLi44_276_, order0_.GrandTotal as GrandTo45_276_, order0_.M_Warehouse_ID as M_Wareh46_276_, order0_.M_PriceList_ID as M_Price47_276_, order0_.IsTaxIncluded as IsTaxIn48_276_, order0_.C_Campaign_ID as C_Campa49_276_, order0_.C_Project_ID as C_Proje50_276_, order0_.C_Activity_ID as C_Activ51_276_, order0_.Posted as Posted52_276_, order0_.AD_User_ID as AD_User53_276_, order0_.CopyFrom as CopyFro54_276_, order0_.DropShip_BPartner_ID as DropShi55_276_, order0_.DropShip_Location_ID as DropShi56_276_, order0_.DropShip_User_ID as DropShi57_276_, order0_.IsSelfService as IsSelfS58_276_, order0_.AD_OrgTrx_ID as AD_OrgT59_276_, order0_.User1_ID as User60_276_, order0_.User2_ID as User61_276_, order0_.Deliverynotes as Deliver62_276_, order0_.C_Incoterms_ID as C_Incot63_276_, order0_.Incotermsdescription as Incoter64_276_, order0_.Generatetemplate as Generat65_276_, order0_.Delivery_Location_ID as Deliver66_276_, order0_.CopyFromPO as CopyFro67_276_, order0_.FIN_Paymentmethod_ID as FIN_Pay68_276_, order0_.FIN_Payment_Priority_ID as FIN_Pay69_276_, order0_.RM_PickFromShipment as RM_Pick70_276_, order0_.RM_ReceiveMaterials as RM_Rece71_276_, order0_.EM_Obcma_C_Poc_Email_ID as EM_Obcm72_276_, order0_.RM_CreateInvoice as RM_Crea73_276_, order0_.C_Return_Reason_ID as C_Retur74_276_, order0_.RM_AddOrphanLine as RM_AddO75_276_, order0_.A_Asset_ID as A_Asset76_276_, order0_.Calculate_Promotions as Calcula77_276_, order0_.C_Costcenter_ID as C_Costc78_276_, order0_.Convertquotation as Convert79_276_, order0_.C_Reject_Reason_ID as C_Rejec80_276_, order0_.validuntil as validun81_276_, order0_.Quotation_ID as Quotati82_276_, order0_.SO_Res_Status as SO_Res_83_276_, order0_.Create_POLines as Create_84_276_, order0_.EM_Obdisc_Addpack as EM_Obdi85_276_, order0_.Iscashvat as Iscashv86_276_, order0_.EM_OBMFM_Selectfreight as EM_OBMF87_276_, order0_.EM_OBMFM_Delivery_Period_ID as EM_OBMF88_276_, order0_.RM_Pickfromreceipt as RM_Pick89_276_, order0_.Cancelandreplace as Cancela90_276_, order0_.EM_Advcrm_Newactivity as EM_Advc91_276_, order0_.EM_APRM_AddPayment as EM_APRM92_276_, order0_.EM_OBMFM_Delivery_Charges as EM_OBMF93_276_, order0_.EM_OBMFM_Freight_ID as EM_OBMF94_276_, order0_.EM_Obwpl_Generatepicking as EM_Obwp95_276_, order0_.EM_Advcrm_Opportunity_ID as EM_Advc96_276_, order0_.EM_OBMFM_Weight as EM_OBMF97_276_, order0_.EM_Obwpl_Isinpickinglist as EM_Obwp98_276_, order0_.EM_Rcinv_Contractdate as EM_Rcin99_276_, order0_.EM_Obwpl_Readypl as EM_Obw100_276_, order0_.EM_Rcinv_Initialdate as EM_Rci101_276_, order0_.EM_Rcinv_Enddate as EM_Rci102_276_, order0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgp103_276_, order0_.EM_OBMFM_Weight_Uom_ID as EM_OBM104_276_, order0_.EM_Rcinv_Frequency as EM_Rci105_276_, order0_.EM_OBMFM_Set_Weight as EM_OBM106_276_, order0_.EM_Rcinv_Renewautomatically as EM_Rci107_276_, order0_.EM_Aeatsii_Fecha_Operacion as EM_Aea108_276_, order0_.EM_Ml_Select_Product as EM_Ml_109_276_, order0_.EM_Rcinv_Renovationtimes as EM_Rci110_276_, order0_.Confirmcancelandreplace as Confir111_276_, order0_.EM_Aeatsii_Descripcion_Sii as EM_Aea112_276_, order0_.EM_Obpos_Applications_ID as EM_Obp113_276_, order0_.EM_Rcinv_Freqrenovationtime as EM_Rci114_276_, order0_.EM_Obpos_Sendemail as EM_Obp115_276_, order0_.EM_Rcinv_Ordercontract_ID as EM_Rci116_276_, order0_.EM_Obpos_Email_Status as EM_Obp117_276_, order0_.EM_Rcinv_Freqtime as EM_Rci118_276_, order0_.Cancelledorder_id as Cancel119_276_, order0_.EM_Obpos_App_Cashup_ID as EM_Obp120_276_, order0_.EM_Obpos_Createdabsolute as EM_Obp121_276_, order0_.Replacedorder_id as Replac122_276_, order0_.EM_OBPOS_NotInvoiceOnCashUp as EM_OBP123_276_, order0_.EM_Obpos_Rejected_Quotat_ID as EM_Obp124_276_, order0_.EM_Obpos_Isdeleted as EM_Obp125_276_, order0_.Iscancelled as Iscanc126_276_, order0_.EM_Obpos_Islayaway as EM_Obp127_276_, order0_.EM_Obpos_Prepaymentamt as EM_Obp128_276_, order0_.Replacementorder_ID as Replac129_276_, order0_.EM_Obpos_Prepaymentlimitamt as EM_Obp130_276_, order0_.EM_Obpos_Prepaymentlaylimitamt as EM_Obp131_276_, order0_.EM_Obpos_Rounding_Amount as EM_Obp132_276_, order0_.BPartner_ExtRef as BPartn133_276_, order0_.EM_Obpos_Sequencename as EM_Obp134_276_, order0_.EM_Prqc_Clauses_Selector as EM_Prq135_276_, order0_.EM_Obpos_Sequencenumber as EM_Obp136_276_, order0_.EM_Rcinv_Cancelcontract as EM_Rci137_276_, order0_.EM_Rcinv_Cancelleddate as EM_Rci138_276_, order0_.EM_Rcinv_Iscancelled as EM_Rci139_276_, order0_.EM_Psat_Activity_ID as EM_Psa140_276_, order0_.EM_OBSMAIL_EmailAddress as EM_OBS141_276_, order0_.EM_Prouti_Order_Stock as EM_Pro142_276_, order0_.EM_Prouti_Pregenerate_Minout as EM_Pro143_276_, order0_.EM_Prouti_Sotopo as EM_Pro144_276_, order0_.EM_Prouti_Generate_Pick_Inv as EM_Pro145_276_, order0_.EM_Pricm_Order_ID as EM_Pri146_276_, order0_.EM_Prouti_Order_ID as EM_Pro147_276_, order0_.EM_Prouti_Grandtotalinitial as EM_Pro148_276_, order0_.EM_Prouti_Dateclosed as EM_Pro149_276_, order0_.EM_Prouti_Totallinesinitial as EM_Pro150_276_, order0_.EM_Prouti_Changebpartner as EM_Pro151_276_, order0_.EM_Prouti_Recalculate_Price as EM_Pro152_276_, order0_.em_prqr_execute as em_prq153_276_, order0_.EM_Prouti_Pricecalculatetdate as EM_Pro154_276_, order0_.EM_Prqr_Execute_Purchase as EM_Prq155_276_, order0_.EM_Prouti_Reactiveorder as EM_Pro156_276_, order0_.EM_Prqr_Return_Select_Prod as EM_Prq157_276_, order0_.EM_Prouti_Totalizations as EM_Pro158_276_, order0_.em_prouti_Invoiced as em_pro159_276_, order0_.em_prouti_Received as em_pro160_276_, order0_.em_prouti_initial_received as em_pro161_276_, order0_.EM_Prouti_Status_Of_Review as EM_Pro162_276_, order0_.EM_Prouti_Validate_Order as EM_Pro163_276_, order0_.EM_Prouti_Start_Review as EM_Pro164_276_, order0_.EM_Ml_Select_Product_Byattrib as EM_Ml_165_276_, order0_.EM_Prres_Reservation_ID as EM_Prr166_276_, order0_.EM_Prres_Responsible_ID as EM_Prr167_276_, order0_.EM_Prres_Diners as EM_Prr168_276_, order0_.EM_Prres_Sended as EM_Prr169_276_, order0_.EM_Prres_Printed as EM_Prr170_276_, order0_.EM_Prouti_Initial_Bp_ID as EM_Pro171_276_, order0_.EM_Prouti_Addlines_Btn as EM_Pro172_276_, order0_.EM_Prtoma_Tomaticket_ID as EM_Prt173_276_, order0_.EM_Cactl_IsCopy as EM_Cac174_276_, order0_.EM_Prtoma_Jsonorder as EM_Prt175_276_, order0_.EM_Prres_Paid_On_Credit as EM_Prr176_276_, order0_.EM_Prtoma_Grossamount as EM_Prt177_276_, order0_.EM_Cactl_Internal_Notes_Group as EM_Cac178_276_, order0_.EM_Prouti_Changebpartner_Bgt as EM_Pro179_276_, order0_.EM_Prrgr_Locator_ID as EM_Prr180_276_, order0_.EM_Paytef_Transactionreference as EM_Pay181_276_, order0_.EM_Cactl_Indirect_Cost_ID as EM_Cac182_276_, order0_.EM_Cactl_Calculate_Cost as EM_Cac183_276_, order0_.EM_Cactl_Totalcost as EM_Cac184_276_, order0_.EM_Cactl_Forceselectedproject as EM_Cac185_276_, order0_.EM_Cactl_Verified_Return as EM_Cac186_276_, order0_.EM_Cactl_Duplicate_Budget as EM_Cac187_276_, order0_.EM_Prres_Orig_Order_ID as EM_Prr188_276_, order0_.EM_Prcpr_Is_Cloned as EM_Prc189_276_, order0_.EM_Prouti_Select_Soline as EM_Pro190_276_, order0_.EM_Prouti_Return_Quantity as EM_Pro191_276_, order0_.EM_Prqr_Executecredit as EM_Prq192_276_, order0_.Em_Prqr_Credit_Purchase_ID as Em_Prq193_276_ from C_Order order0_ cross join C_DocType documentty1_ where order0_.C_DocTypeTarget_ID=documentty1_.C_DocType_ID and order0_.IsSOTrx=$43 and documentty1_.IsReturn=$44 and (order0_.Updated>$1 or order0_.Processed=$45) and (order0_.AD_Org_ID in ($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)) and (order0_.AD_Client_ID in ($40 , $41)) order by order0_.DateOrdered desc, order0_.C_Order_ID desc limit $42
9918228dbaselect prges_conf0_.Prges_Config_ID as Prges_Co1_830_1_, prges_conf0_.AD_Client_ID as AD_Clien2_830_1_, prges_conf0_.AD_Org_ID as AD_Org_I3_830_1_, prges_conf0_.Created as Created4_830_1_, prges_conf0_.Createdby as Createdb5_830_1_, prges_conf0_.Updated as Updated6_830_1_, prges_conf0_.Updatedby as Updatedb7_830_1_, prges_conf0_.Isactive as Isactive8_830_1_, prges_conf0_.Url as Url9_830_1_, prges_conf0_.Token as Token10_830_1_, prges_conf0_.C_Doctype_ID as C_Docty11_830_1_, prges_conf0_.Hold_Seconds as Hold_Se12_830_1_, prges_conf0_.Addon as Addon13_830_1_, prgesrecor1_.Prges_Config_ID as Prges_C16_831_3_, prgesrecor1_.Prges_Records_ID as Prges_Re1_831_3_, prgesrecor1_.Prges_Records_ID as Prges_Re1_831_0_, prgesrecor1_.AD_Client_ID as AD_Clien2_831_0_, prgesrecor1_.AD_Org_ID as AD_Org_I3_831_0_, prgesrecor1_.Created as Created4_831_0_, prgesrecor1_.Createdby as Createdb5_831_0_, prgesrecor1_.Updated as Updated6_831_0_, prgesrecor1_.Updatedby as Updatedb7_831_0_, prgesrecor1_.Isactive as Isactive8_831_0_, prgesrecor1_.Action as Action9_831_0_, prgesrecor1_.Url as Url10_831_0_, prgesrecor1_.Jsoninfo as Jsoninf11_831_0_, prgesrecor1_.Error as Error12_831_0_, prgesrecor1_.Process as Process13_831_0_, prgesrecor1_.Status as Status14_831_0_, prgesrecor1_.C_Invoice_ID as C_Invoi15_831_0_, prgesrecor1_.Prges_Config_ID as Prges_C16_831_0_ from prges_config prges_conf0_ left outer join prges_records prgesrecor1_ on prges_conf0_.Prges_Config_ID=prgesrecor1_.Prges_Config_ID where prges_conf0_.Prges_Config_ID=$1
1b416379eainsert 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, IsDescription, Manage_Prereservation, C_Bpartner_ID, Explode, EM_Obwpl_Editlines_Pe, EM_Obwpl_Removeline, 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)
089f5b9354COPY public.m_productionline (m_productionline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, m_productionplan_id, line, m_product_id, movementqty, m_locator_id, description, m_attributesetinstance_id, m_product_uom_id, quantityorder, c_uom_id, calculated, productiontype, rejectedquantity, calccost, componentcost, ma_wrphaseproduct_id, divisiongroupqty, em_cactl_losses, em_cactl_added_manually) TO stdout
d545a87b3dupdate C_Invoice set Updated=$1, LastCalculatedOnDate=$2 where C_Invoice_ID=$3
ff35139986SELECT * FROM C_Order_Post($1)
ab6445a3b6select this_.AD_TreeNode_ID as AD_TreeN1_125_0_, this_.AD_Tree_ID as AD_Tree_2_125_0_, this_.Node_ID as Node_ID3_125_0_, this_.AD_Client_ID as AD_Clien4_125_0_, this_.AD_Org_ID as AD_Org_I5_125_0_, this_.IsActive as IsActive6_125_0_, this_.Created as Created7_125_0_, this_.CreatedBy as CreatedB8_125_0_, this_.Updated as Updated9_125_0_, this_.UpdatedBy as Updated10_125_0_, this_.Parent_ID as Parent_11_125_0_, this_.SeqNo as SeqNo12_125_0_ from AD_TreeNode this_ where this_.Node_ID=$1 and this_.Parent_ID<>$2 and this_.IsActive=$3
66933eeddeselect f.id, f.hour, CASE WHEN f.reservation_type = $1 AND f.multiplier is not null THEN f.available * f.multiplier ELSE f.available END as available, CASE WHEN f.reservation_type = $2 AND f.multiplier is not null THEN f.reserved * f.multiplier ELSE f.reserved END as reserved, f.slot_type FROM ( select ptd.prpass_timeslots_detail_id as id, to_char(ptd.hour, $3) as hour, coalesce( (select qtyavailable from prpass_timeslots_exceptions pte where pte.prpass_timeslots_id = ptd.prpass_timeslots_id and (ptd.hour is null OR (to_char(pte.hour, $4) = to_char(ptd.hour, $5))) and pte.date = $6::date), CASE WHEN (EXTRACT($7 FROM ($8::timestamp - CURRENT_DATE)) / $9 >= pt.agency_reservation_time) OR (ptd.qtyavailable_agency > $10 AND pt.agency_reservation_time is null) THEN CASE WHEN $11 THEN COALESCE(ptd.qtyavailable_agency, COALESCE(ptd.qtyavailable_online, qtyavailable)) WHEN $12 AND ptd.qtyavailable_online = $13 THEN ptd.qtyavailable_online ELSE (COALESCE(ptd.qtyavailable_online, qtyavailable)) - ptd.qtyavailable_agency END ELSE CASE WHEN pt.slot_type = $14 AND $15 THEN COALESCE(ptd.qtyavailable_online, ptd.qtyavailable) ELSE ptd.qtyavailable END END) as available, coalesce( (select sum( CASE WHEN pt.reservation_type = $16 AND f.cart is not null AND pt.multiplier is not null THEN floor((f.qtyreservation + pt.multiplier - $17) / pt.multiplier) ELSE f.qtyreservation END) from( select CASE WHEN max(ptr.c_orderline_id) is not null THEN count(ppi.prpass_pass_inst_id) ELSE max(ptr.qtyreservation) END as qtyreservation, cart from prpass_timeslots_res ptr left join c_orderline col on col.c_orderline_id = ptr.c_orderline_id left join c_order co on co.c_order_id = col.c_order_id left join prpass_pass_inst ppi on ppi.c_orderline_id = col.c_orderline_id where ptr.prpass_timeslots_detail_id = ptd.prpass_timeslots_detail_id and ptr.date = $18::date and (pt.slot_type <> $19 or (pt.slot_type = $20 and CASE WHEN $21 THEN co.em_obpos_applications_id is null OR ptr.c_orderline_id is null ELSE co.em_obpos_applications_id is not null OR ptr.c_orderline_id is null END)) and (CASE WHEN (EXTRACT($22 FROM (ptr.date - CURRENT_DATE)) / $23 >= pt.agency_reservation_time) OR (ptd.qtyavailable_agency > $24 AND pt.agency_reservation_time is null) THEN CASE WHEN $25 THEN ptr.agency = $26 ELSE ptr.agency = $27 END ELSE $28 END) and (ppi.status <>$29 or ppi.status is null) and cart is not null group by cart ) as f), $30) as reserved, pt.multiplier, pt.reservation_type, pt.slot_type from prpass_timeslots_detail ptd join prpass_timeslots pt on pt.prpass_timeslots_id = ptd.prpass_timeslots_id where ptd.prpass_timeslots_id = $31 order by 2 asc) AS f
7247cdc8b5select c_import_e0_.C_IMPORT_ENTRY_ID as C_IMPORT1_257_, c_import_e0_.AD_Client_ID as AD_Clien2_257_, c_import_e0_.AD_Org_ID as AD_Org_I3_257_, c_import_e0_.Isactive as Isactive4_257_, c_import_e0_.Created as Created5_257_, c_import_e0_.Createdby as Createdb6_257_, c_import_e0_.Updated as Updated7_257_, c_import_e0_.Updatedby as Updatedb8_257_, c_import_e0_.Imported as Imported9_257_, c_import_e0_.Jsoninfo as Jsoninf10_257_, c_import_e0_.ImportStatus as ImportS11_257_, c_import_e0_.Typeofdata as Typeofd12_257_, c_import_e0_.Errorinfo as Errorin13_257_, c_import_e0_.AD_Role_ID as AD_Role14_257_, c_import_e0_.Createdtimestamp as Created15_257_, c_import_e0_.EM_Obpos_Applications_ID as EM_Obpo16_257_, c_import_e0_.Responseinfo as Respons17_257_ 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
214f622e78select prpass_pas0_.Prpass_Pass_Inst_ID as Prpass_P1_878_, prpass_pas0_.AD_Client_ID as AD_Clien2_878_, prpass_pas0_.AD_Org_ID as AD_Org_I3_878_, prpass_pas0_.Isactive as Isactive4_878_, prpass_pas0_.Created as Created5_878_, prpass_pas0_.Createdby as Createdb6_878_, prpass_pas0_.Updated as Updated7_878_, prpass_pas0_.Updatedby as Updatedb8_878_, prpass_pas0_.Value as Value9_878_, prpass_pas0_.Status as Status10_878_, prpass_pas0_.C_Orderline_ID as C_Order11_878_, prpass_pas0_.C_Order_ID as C_Order12_878_, prpass_pas0_.Dateordered as Dateord13_878_, prpass_pas0_.C_Bpartner_ID as C_Bpart14_878_, prpass_pas0_.M_Product_ID as M_Produ15_878_, prpass_pas0_.Obpos_Applications_ID as Obpos_A16_878_, prpass_pas0_.Cancel as Cancel17_878_, prpass_pas0_.AD_Creation_Org_ID as AD_Crea18_878_, prpass_pas0_.Expirationdate as Expirat19_878_, prpass_pas0_.EM_Cactl_Gl_Journal_ID as EM_Cact20_878_, prpass_pas0_.Prpass_Timeslots_Detail_ID as Prpass_21_878_, prpass_pas0_.Prpass_Timeslots_Res_ID as Prpass_22_878_, prpass_pas0_.Time_First_Pick as Time_Fi23_878_, prpass_pas0_.Validate_Manual as Validat24_878_, prpass_pas0_.Unlimited as Unlimit25_878_ from prpass_pass_inst prpass_pas0_ where (upper(prpass_pas0_.Value) like upper($1) escape $43) and (prpass_pas0_.AD_Org_ID in ($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)) and (prpass_pas0_.AD_Client_ID in ($40 , $41)) order by prpass_pas0_.Value, prpass_pas0_.Prpass_Pass_Inst_ID limit $42
695482b977COPY public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_obmfm_isfreightamt, em_obmfm_freight_definition_id, em_obpos_epccode, em_obpos_serialnumber, em_obpos_isdeleted, em_obpos_service_proposed, em_obpos_qtydeleted, em_obpos_canbedelivered, em_obpos_ispaid, em_obpos_pricereason_id, em_obrdm_delivery_mode, em_obrdm_delivery_date, em_obrdm_delivery_time, em_obrdm_amttopayindelivery, em_prouti_closeline, em_prouti_orderline_id, em_prouti_qtyinitial, em_prouti_linenetamtinitial, em_obwpl_readypl, em_obbom_ingredientsarray, em_prpass_autovalidation, em_prres_qtysenttokitchen, em_prres_menu_section_id, em_prres_menu_oline_id, em_prres_combination_link, em_prres_current_eat, em_psat_activity_log_id, em_psat_act_consumption_id, em_cactl_variety_product_id, em_cactl_priceoperative, em_prres_qtyprintinkitchen, em_cactl_before_order_price, em_cactl_c_bpartner_id, em_cactl_subject_request, em_cactl_aditional_info, em_cactl_totalcostline, em_prouti_cancelreason_id, em_prouti_canceled, em_prouti_canceledby, em_prouti_recalculate_qtyinit, em_prres_ismoved, em_prres_operativeqty_initial) TO stdout
fd1086c39ainsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
38988e8d9finsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
145f4813e8insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
943d79be4bSELECT $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
b57306362adelete from prpass_timeslots_res where Prpass_Timeslots_Res_ID=$1
75890e23a4SELECT * 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)
43a80059e4SELECT * FROM C_Invoice_Create($8, v_Record_ID)
22615c404bselect invoice0_.C_Invoice_ID as C_Invoic1_260_, invoice0_.AD_Client_ID as AD_Clien2_260_, invoice0_.AD_Org_ID as AD_Org_I3_260_, invoice0_.IsActive as IsActive4_260_, invoice0_.Created as Created5_260_, invoice0_.CreatedBy as CreatedB6_260_, invoice0_.Updated as Updated7_260_, invoice0_.UpdatedBy as UpdatedB8_260_, invoice0_.IsSOTrx as IsSOTrx9_260_, invoice0_.DocumentNo as Documen10_260_, invoice0_.DocStatus as DocStat11_260_, invoice0_.DocAction as DocActi12_260_, invoice0_.Processing as Process13_260_, invoice0_.Processed as Process14_260_, invoice0_.Posted as Posted15_260_, invoice0_.C_DocType_ID as C_DocTy16_260_, invoice0_.C_DocTypeTarget_ID as C_DocTy17_260_, invoice0_.C_Order_ID as C_Order18_260_, invoice0_.Description as Descrip19_260_, invoice0_.IsPrinted as IsPrint20_260_, invoice0_.SalesRep_ID as SalesRe21_260_, invoice0_.DateInvoiced as DateInv22_260_, invoice0_.DatePrinted as DatePri23_260_, invoice0_.DateAcct as DateAcc24_260_, invoice0_.C_BPartner_ID as C_BPart25_260_, invoice0_.C_BPartner_Location_ID as C_BPart26_260_, invoice0_.POReference as PORefer27_260_, invoice0_.IsDiscountPrinted as IsDisco28_260_, invoice0_.DateOrdered as DateOrd29_260_, invoice0_.C_Currency_ID as C_Curre30_260_, invoice0_.C_PaymentTerm_ID as C_Payme31_260_, invoice0_.C_Charge_ID as C_Charg32_260_, invoice0_.ChargeAmt as ChargeA33_260_, invoice0_.TotalLines as TotalLi34_260_, invoice0_.GrandTotal as GrandTo35_260_, invoice0_.M_PriceList_ID as M_Price36_260_, invoice0_.IsTaxIncluded as IsTaxIn37_260_, invoice0_.C_Campaign_ID as C_Campa38_260_, invoice0_.C_Project_ID as C_Proje39_260_, invoice0_.C_Activity_ID as C_Activ40_260_, invoice0_.CreateFrom as CreateF41_260_, invoice0_.GenerateTo as Generat42_260_, invoice0_.AD_User_ID as AD_User43_260_, invoice0_.CopyFrom as CopyFro44_260_, invoice0_.IsSelfService as IsSelfS45_260_, invoice0_.AD_OrgTrx_ID as AD_OrgT46_260_, invoice0_.User1_ID as User47_260_, invoice0_.User2_ID as User48_260_, invoice0_.Withholdingamount as Withhol49_260_, invoice0_.Taxdate as Taxdate50_260_, invoice0_.C_Withholding_ID as C_Withh51_260_, invoice0_.Ispaid as Ispaid52_260_, invoice0_.EM_Einv_Generated as EM_Einv53_260_, invoice0_.Totalpaid as Totalpa54_260_, invoice0_.EM_Einv_Sent as EM_Einv55_260_, invoice0_.OutstandingAmt as Outstan56_260_, invoice0_.DaysTillDue as DaysTil57_260_, invoice0_.DueAmt as DueAmt58_260_, invoice0_.LastCalculatedOnDate as LastCal59_260_, invoice0_.FIN_Paymentmethod_ID as FIN_Pay60_260_, invoice0_.FIN_Payment_Priority_ID as FIN_Pay61_260_, invoice0_.Finalsettlement as Finalse62_260_, invoice0_.Daysoutstanding as Daysout63_260_, invoice0_.Percentageoverdue as Percent64_260_, invoice0_.C_Costcenter_ID as C_Costc65_260_, invoice0_.Calculate_Promotions as Calcula66_260_, invoice0_.A_Asset_ID as A_Asset67_260_, invoice0_.EM_APRM_Addpayment as EM_APRM68_260_, invoice0_.Iscashvat as Iscashv69_260_, invoice0_.EM_APRM_Processinvoice as EM_APRM70_260_, invoice0_.EM_Obcma_C_Poc_Email_ID as EM_Obcm71_260_, invoice0_.Prepaymentamt as Prepaym72_260_, invoice0_.Createfromorders as Createf73_260_, invoice0_.Createfrominouts as Createf74_260_, invoice0_.EM_Advcrm_Newactivity as EM_Advc75_260_, invoice0_.Paidamtatinvoicing as Paidamt76_260_, invoice0_.EM_Obpos_Rounding_Amount as EM_Obpo77_260_, invoice0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc78_260_, invoice0_.BPartner_ExtRef as BPartne79_260_, invoice0_.EM_Aeatsii_Send as EM_Aeat80_260_, invoice0_.EM_Obpos_Sequencename as EM_Obpo81_260_, invoice0_.EM_Aeatsii_Issent as EM_Aeat82_260_, invoice0_.EM_Obpos_Sequencenumber as EM_Obpo83_260_, invoice0_.EM_Aeatsii_Fecha_Operacion as EM_Aeat84_260_, invoice0_.EM_Aeatsii_Clave_Tipo as EM_Aeat85_260_, invoice0_.EM_Aeatsii_Motivo_Rectif as EM_Aeat86_260_, invoice0_.EM_Prouti_Recalculate_Price as EM_Prou87_260_, invoice0_.EM_Aeatsii_Clave_Tipo_Fc as EM_Aeat88_260_, invoice0_.EM_Ml_Select_Product as EM_Ml_S89_260_, invoice0_.EM_Prouti_Pricecalculatetdate as EM_Prou90_260_, invoice0_.EM_Aeatsii_Tipo_Rectif as EM_Aeat91_260_, invoice0_.EM_Prouti_Totalizations as EM_Prou92_260_, invoice0_.EM_Aeatsii_Dua as EM_Aeat93_260_, invoice0_.EM_Aeatsii_Fecha_Dua as EM_Aeat94_260_, invoice0_.EM_Aeatsii_Estado as EM_Aeat95_260_, invoice0_.EM_Aeatsii_Error_Registral as EM_Aeat96_260_, invoice0_.EM_Aeatsii_Modif as EM_Aeat97_260_, invoice0_.EM_Aeatsii_Modified as EM_Aeat98_260_, invoice0_.EM_Aeatsii_Description_ID as EM_Aeat99_260_, invoice0_.EM_Aeatsii_Descripcion_Sii as EM_Aea100_260_, invoice0_.EM_Aeatsii_Fecha_Reg_Cont as EM_Aea101_260_, invoice0_.EM_Aeatsii_Dup as EM_Aea102_260_, invoice0_.EM_Aeatsii_Error_Code as EM_Aea103_260_, invoice0_.EM_Aeatsii_Error_Msg as EM_Aea104_260_, invoice0_.EM_Aeatsii_Unsubscribe as EM_Aea105_260_, invoice0_.EM_Aeatsii_Pur_Description_ID as EM_Aea106_260_, invoice0_.EM_Aeatsii_Multi_Dua as EM_Aea107_260_, invoice0_.EM_Aeatsii_Ejercicio as EM_Aea108_260_, invoice0_.EM_Aeatsii_Periodo as EM_Aea109_260_, invoice0_.EM_Aeatsii_Autofactura as EM_Aea110_260_, invoice0_.EM_Aeatsii_Invoice_ID as EM_Aea111_260_, invoice0_.EM_Aeatsii_Insiidate as EM_Aea112_260_, invoice0_.EM_Aeatsii_Cause_Exemption_ID as EM_Aea113_260_, invoice0_.EM_Aeatsii_Isauthorization as EM_Aea114_260_, invoice0_.EM_Aeatsii_Authorizationno as EM_Aea115_260_, invoice0_.EM_Priuti_Createpurchinv as EM_Pri116_260_, invoice0_.EM_Priuti_Generated as EM_Pri117_260_, invoice0_.EM_Priuti_Date_Complete as EM_Pri118_260_, invoice0_.EM_Prges_Expediente_ID as EM_Prg119_260_, invoice0_.EM_Priuti_User_Complete_ID as EM_Pri120_260_, invoice0_.EM_Prges_Annotation_ID as EM_Prg121_260_, invoice0_.EM_Prges_Record_Number as EM_Prg122_260_, invoice0_.EM_Priuti_Status_Of_Review as EM_Pri123_260_, invoice0_.EM_Prges_Grantotal as EM_Prg124_260_, invoice0_.EM_Priuti_Validate as EM_Pri125_260_, invoice0_.EM_Priuti_Start_Review as EM_Pri126_260_, invoice0_.EM_Prges_Poreference as EM_Prg127_260_, invoice0_.em_cactl_createfromship as em_cac128_260_ 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'
c44dfe02a3insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
6e47e0b2e7select passinst.value as pass, m_product.name as name, m_product.em_prpass_doc_required as requiresDocumentation , coalesce(co.documentno,$1) as ticket, case when pt.slot_type = $2 then ptr.date::date else (ptr.date::date || $3 || ptd.hour::time)::timestamp end as hour, pt.slot_type as slot_type, passinst.unlimited as unlimited from prpass_pass_inst passinst join m_product on m_product.m_product_id=passinst.m_product_id left join c_order co on co.c_order_id = passinst.c_order_id left join prpass_timeslots_res ptr on ptr.prpass_timeslots_res_id = passinst.prpass_timeslots_res_id left join prpass_timeslots_detail ptd on ptd.prpass_timeslots_detail_id = ptr.prpass_timeslots_detail_id left join prpass_timeslots pt on pt.prpass_timeslots_id = ptd.prpass_timeslots_id where (passinst.status NOT IN ($4,$5,$6,$7) AND case when m_product.em_prpass_org_selection=$8 then (exists (select $9 from prpass_organization passorg where passorg.m_product_id=m_product.m_product_id and passorg.ad_orgtrx_id=$10)) else (not exists (select $11 from prpass_organization passorg where passorg.m_product_id=m_product.m_product_id and passorg.ad_orgtrx_id=$12)) end AND case when passinst.unlimited != $13 then not exists (select $14 from prpass_pass_trans passtrans where passtrans.prpass_pass_inst_id=passinst.prpass_pass_inst_id and passtrans.ad_validation_org_id=$15) else $16=$17 end) and (m_product.em_prpass_ispass is not null and m_product.em_prpass_ispass = $18 and m_product.isactive = $19) and (m_product.em_prpass_datefrom is null or m_product.em_prpass_datefrom <= CURRENT_DATE) and (m_product.em_prpass_dateto is null or m_product.em_prpass_dateto >= CURRENT_DATE)
784dd58a53SELECT $2 FROM ONLY "public"."c_uom" x WHERE "c_uom_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
2e210c7585COPY public.m_transaction_cost (m_transaction_cost_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, m_transaction_id, cost, costdate, c_currency_id, m_costadjustmentline_id, isunitcost, dateacct) TO stdout
fd0b1d2b52insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
cfc6a9aeceinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
ec8c626e99COPY 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
2d3fd9a51finsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
d92125f1e7insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2bbd1014edSELECT $2 FROM ONLY "public"."c_doctype" x WHERE "c_doctype_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
6aeca8addcSELECT * FROM (select fa.fin_financial_account_id AS referencekey_id, ad_column_identifier_std($2, fa.fin_financial_account_id) AS record_id, $3 AS ad_role_id, $4 AS ad_user_id, $5 || fa.name || $6 || fa.currentbalance || $7 || (fa.initialbalance + (select sum(depositamt) - sum(paymentamt) from fin_finacc_transaction where fa.fin_financial_account_id=fin_finacc_transaction.fin_financial_account_id and fin_finacc_transaction.processed=$8)) || $9|| fa.currentbalance- (fa.initialbalance + (select sum(depositamt) - sum(paymentamt) from fin_finacc_transaction where fa.fin_financial_account_id=fin_finacc_transaction.fin_financial_account_id and fin_finacc_transaction.processed=$10)) AS description, $11 AS isActive, $12 AS ad_org_id, fa.ad_client_id AS ad_client_id, now() AS created, $13 AS createdBy, now() AS updated, $14 AS updatedBy from fin_financial_account fa where fa.currentbalance <> fa.initialbalance + (select sum(depositamt) - sum(paymentamt) from fin_finacc_transaction where fa.fin_financial_account_id=fin_finacc_transaction.fin_financial_account_id and fin_finacc_transaction.processed=$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)
b51ae16f3eselect order0_.C_Order_ID as C_Order_1_276_, order0_.AD_Client_ID as AD_Clien2_276_, order0_.AD_Org_ID as AD_Org_I3_276_, order0_.IsActive as IsActive4_276_, order0_.Created as Created5_276_, order0_.CreatedBy as CreatedB6_276_, order0_.Updated as Updated7_276_, order0_.UpdatedBy as UpdatedB8_276_, order0_.IsSOTrx as IsSOTrx9_276_, order0_.DocumentNo as Documen10_276_, order0_.DocStatus as DocStat11_276_, order0_.DocAction as DocActi12_276_, order0_.Processing as Process13_276_, order0_.Processed as Process14_276_, order0_.C_DocType_ID as C_DocTy15_276_, order0_.C_DocTypeTarget_ID as C_DocTy16_276_, order0_.Description as Descrip17_276_, order0_.IsDelivered as IsDeliv18_276_, order0_.IsInvoiced as IsInvoi19_276_, order0_.IsPrinted as IsPrint20_276_, order0_.IsSelected as IsSelec21_276_, order0_.SalesRep_ID as SalesRe22_276_, order0_.DateOrdered as DateOrd23_276_, order0_.DatePromised as DatePro24_276_, order0_.DatePrinted as DatePri25_276_, order0_.DateAcct as DateAcc26_276_, order0_.C_BPartner_ID as C_BPart27_276_, order0_.BillTo_ID as BillTo_28_276_, order0_.C_BPartner_Location_ID as C_BPart29_276_, order0_.POReference as PORefer30_276_, order0_.IsDiscountPrinted as IsDisco31_276_, order0_.C_Currency_ID as C_Curre32_276_, order0_.PaymentRule as Payment33_276_, order0_.C_PaymentTerm_ID as C_Payme34_276_, order0_.InvoiceRule as Invoice35_276_, order0_.DeliveryRule as Deliver36_276_, order0_.FreightCostRule as Freight37_276_, order0_.FreightAmt as Freight38_276_, order0_.DeliveryViaRule as Deliver39_276_, order0_.M_Shipper_ID as M_Shipp40_276_, order0_.C_Charge_ID as C_Charg41_276_, order0_.ChargeAmt as ChargeA42_276_, order0_.PriorityRule as Priorit43_276_, order0_.TotalLines as TotalLi44_276_, order0_.GrandTotal as GrandTo45_276_, order0_.M_Warehouse_ID as M_Wareh46_276_, order0_.M_PriceList_ID as M_Price47_276_, order0_.IsTaxIncluded as IsTaxIn48_276_, order0_.C_Campaign_ID as C_Campa49_276_, order0_.C_Project_ID as C_Proje50_276_, order0_.C_Activity_ID as C_Activ51_276_, order0_.Posted as Posted52_276_, order0_.AD_User_ID as AD_User53_276_, order0_.CopyFrom as CopyFro54_276_, order0_.DropShip_BPartner_ID as DropShi55_276_, order0_.DropShip_Location_ID as DropShi56_276_, order0_.DropShip_User_ID as DropShi57_276_, order0_.IsSelfService as IsSelfS58_276_, order0_.AD_OrgTrx_ID as AD_OrgT59_276_, order0_.User1_ID as User60_276_, order0_.User2_ID as User61_276_, order0_.Deliverynotes as Deliver62_276_, order0_.C_Incoterms_ID as C_Incot63_276_, order0_.Incotermsdescription as Incoter64_276_, order0_.Generatetemplate as Generat65_276_, order0_.Delivery_Location_ID as Deliver66_276_, order0_.CopyFromPO as CopyFro67_276_, order0_.FIN_Paymentmethod_ID as FIN_Pay68_276_, order0_.FIN_Payment_Priority_ID as FIN_Pay69_276_, order0_.RM_PickFromShipment as RM_Pick70_276_, order0_.RM_ReceiveMaterials as RM_Rece71_276_, order0_.EM_Obcma_C_Poc_Email_ID as EM_Obcm72_276_, order0_.RM_CreateInvoice as RM_Crea73_276_, order0_.C_Return_Reason_ID as C_Retur74_276_, order0_.RM_AddOrphanLine as RM_AddO75_276_, order0_.A_Asset_ID as A_Asset76_276_, order0_.Calculate_Promotions as Calcula77_276_, order0_.C_Costcenter_ID as C_Costc78_276_, order0_.Convertquotation as Convert79_276_, order0_.C_Reject_Reason_ID as C_Rejec80_276_, order0_.validuntil as validun81_276_, order0_.Quotation_ID as Quotati82_276_, order0_.SO_Res_Status as SO_Res_83_276_, order0_.Create_POLines as Create_84_276_, order0_.EM_Obdisc_Addpack as EM_Obdi85_276_, order0_.Iscashvat as Iscashv86_276_, order0_.EM_OBMFM_Selectfreight as EM_OBMF87_276_, order0_.EM_OBMFM_Delivery_Period_ID as EM_OBMF88_276_, order0_.RM_Pickfromreceipt as RM_Pick89_276_, order0_.Cancelandreplace as Cancela90_276_, order0_.EM_Advcrm_Newactivity as EM_Advc91_276_, order0_.EM_APRM_AddPayment as EM_APRM92_276_, order0_.EM_OBMFM_Delivery_Charges as EM_OBMF93_276_, order0_.EM_OBMFM_Freight_ID as EM_OBMF94_276_, order0_.EM_Obwpl_Generatepicking as EM_Obwp95_276_, order0_.EM_Advcrm_Opportunity_ID as EM_Advc96_276_, order0_.EM_OBMFM_Weight as EM_OBMF97_276_, order0_.EM_Obwpl_Isinpickinglist as EM_Obwp98_276_, order0_.EM_Rcinv_Contractdate as EM_Rcin99_276_, order0_.EM_Obwpl_Readypl as EM_Obw100_276_, order0_.EM_Rcinv_Initialdate as EM_Rci101_276_, order0_.EM_Rcinv_Enddate as EM_Rci102_276_, order0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgp103_276_, order0_.EM_OBMFM_Weight_Uom_ID as EM_OBM104_276_, order0_.EM_Rcinv_Frequency as EM_Rci105_276_, order0_.EM_OBMFM_Set_Weight as EM_OBM106_276_, order0_.EM_Rcinv_Renewautomatically as EM_Rci107_276_, order0_.EM_Aeatsii_Fecha_Operacion as EM_Aea108_276_, order0_.EM_Ml_Select_Product as EM_Ml_109_276_, order0_.EM_Rcinv_Renovationtimes as EM_Rci110_276_, order0_.Confirmcancelandreplace as Confir111_276_, order0_.EM_Aeatsii_Descripcion_Sii as EM_Aea112_276_, order0_.EM_Obpos_Applications_ID as EM_Obp113_276_, order0_.EM_Rcinv_Freqrenovationtime as EM_Rci114_276_, order0_.EM_Obpos_Sendemail as EM_Obp115_276_, order0_.EM_Rcinv_Ordercontract_ID as EM_Rci116_276_, order0_.EM_Obpos_Email_Status as EM_Obp117_276_, order0_.EM_Rcinv_Freqtime as EM_Rci118_276_, order0_.Cancelledorder_id as Cancel119_276_, order0_.EM_Obpos_App_Cashup_ID as EM_Obp120_276_, order0_.EM_Obpos_Createdabsolute as EM_Obp121_276_, order0_.Replacedorder_id as Replac122_276_, order0_.EM_OBPOS_NotInvoiceOnCashUp as EM_OBP123_276_, order0_.EM_Obpos_Rejected_Quotat_ID as EM_Obp124_276_, order0_.EM_Obpos_Isdeleted as EM_Obp125_276_, order0_.Iscancelled as Iscanc126_276_, order0_.EM_Obpos_Islayaway as EM_Obp127_276_, order0_.EM_Obpos_Prepaymentamt as EM_Obp128_276_, order0_.Replacementorder_ID as Replac129_276_, order0_.EM_Obpos_Prepaymentlimitamt as EM_Obp130_276_, order0_.EM_Obpos_Prepaymentlaylimitamt as EM_Obp131_276_, order0_.EM_Obpos_Rounding_Amount as EM_Obp132_276_, order0_.BPartner_ExtRef as BPartn133_276_, order0_.EM_Obpos_Sequencename as EM_Obp134_276_, order0_.EM_Prqc_Clauses_Selector as EM_Prq135_276_, order0_.EM_Obpos_Sequencenumber as EM_Obp136_276_, order0_.EM_Rcinv_Cancelcontract as EM_Rci137_276_, order0_.EM_Rcinv_Cancelleddate as EM_Rci138_276_, order0_.EM_Rcinv_Iscancelled as EM_Rci139_276_, order0_.EM_Psat_Activity_ID as EM_Psa140_276_, order0_.EM_OBSMAIL_EmailAddress as EM_OBS141_276_, order0_.EM_Prouti_Order_Stock as EM_Pro142_276_, order0_.EM_Prouti_Pregenerate_Minout as EM_Pro143_276_, order0_.EM_Prouti_Sotopo as EM_Pro144_276_, order0_.EM_Prouti_Generate_Pick_Inv as EM_Pro145_276_, order0_.EM_Pricm_Order_ID as EM_Pri146_276_, order0_.EM_Prouti_Order_ID as EM_Pro147_276_, order0_.EM_Prouti_Grandtotalinitial as EM_Pro148_276_, order0_.EM_Prouti_Dateclosed as EM_Pro149_276_, order0_.EM_Prouti_Totallinesinitial as EM_Pro150_276_, order0_.EM_Prouti_Changebpartner as EM_Pro151_276_, order0_.EM_Prouti_Recalculate_Price as EM_Pro152_276_, order0_.em_prqr_execute as em_prq153_276_, order0_.EM_Prouti_Pricecalculatetdate as EM_Pro154_276_, order0_.EM_Prqr_Execute_Purchase as EM_Prq155_276_, order0_.EM_Prouti_Reactiveorder as EM_Pro156_276_, order0_.EM_Prqr_Return_Select_Prod as EM_Prq157_276_, order0_.EM_Prouti_Totalizations as EM_Pro158_276_, order0_.em_prouti_Invoiced as em_pro159_276_, order0_.em_prouti_Received as em_pro160_276_, order0_.em_prouti_initial_received as em_pro161_276_, order0_.EM_Prouti_Status_Of_Review as EM_Pro162_276_, order0_.EM_Prouti_Validate_Order as EM_Pro163_276_, order0_.EM_Prouti_Start_Review as EM_Pro164_276_, order0_.EM_Ml_Select_Product_Byattrib as EM_Ml_165_276_, order0_.EM_Prres_Reservation_ID as EM_Prr166_276_, order0_.EM_Prres_Responsible_ID as EM_Prr167_276_, order0_.EM_Prres_Diners as EM_Prr168_276_, order0_.EM_Prres_Sended as EM_Prr169_276_, order0_.EM_Prres_Printed as EM_Prr170_276_, order0_.EM_Prouti_Initial_Bp_ID as EM_Pro171_276_, order0_.EM_Prouti_Addlines_Btn as EM_Pro172_276_, order0_.EM_Prtoma_Tomaticket_ID as EM_Prt173_276_, order0_.EM_Cactl_IsCopy as EM_Cac174_276_, order0_.EM_Prtoma_Jsonorder as EM_Prt175_276_, order0_.EM_Prres_Paid_On_Credit as EM_Prr176_276_, order0_.EM_Prtoma_Grossamount as EM_Prt177_276_, order0_.EM_Cactl_Internal_Notes_Group as EM_Cac178_276_, order0_.EM_Prouti_Changebpartner_Bgt as EM_Pro179_276_, order0_.EM_Prrgr_Locator_ID as EM_Prr180_276_, order0_.EM_Paytef_Transactionreference as EM_Pay181_276_, order0_.EM_Cactl_Indirect_Cost_ID as EM_Cac182_276_, order0_.EM_Cactl_Calculate_Cost as EM_Cac183_276_, order0_.EM_Cactl_Totalcost as EM_Cac184_276_, order0_.EM_Cactl_Forceselectedproject as EM_Cac185_276_, order0_.EM_Cactl_Verified_Return as EM_Cac186_276_, order0_.EM_Cactl_Duplicate_Budget as EM_Cac187_276_, order0_.EM_Prres_Orig_Order_ID as EM_Prr188_276_, order0_.EM_Prcpr_Is_Cloned as EM_Prc189_276_, order0_.EM_Prouti_Select_Soline as EM_Pro190_276_, order0_.EM_Prouti_Return_Quantity as EM_Pro191_276_, order0_.EM_Prqr_Executecredit as EM_Prq192_276_, order0_.Em_Prqr_Credit_Purchase_ID as Em_Prq193_276_ from C_Order order0_ cross join C_DocType documentty1_ where order0_.C_DocTypeTarget_ID=documentty1_.C_DocType_ID and (order0_.DocStatus=$1 or order0_.DocStatus=$2) and (order0_.EM_Obcma_C_Poc_Email_ID is null) and order0_.CreatedBy=$3 and order0_.IsSOTrx=$45 and documentty1_.IsReturn=$46 and (order0_.AD_Org_ID in ($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)) and (order0_.AD_Client_ID in ($42 , $43)) order by order0_.DocumentNo desc, order0_.C_Order_ID desc limit $44
4cb9cc1cbfSELECT C_ORDER_POST1($1, $2, $3)
6758866a26insert 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 ( get_uuid(), $1, $2, $14, to_timestamp(to_char($3), to_char($15)), $4, to_timestamp(to_char($5), to_char($16)), $6, to_number($7), $8, $9, $10, $11, $12, $13 )
439a14cffeDELETE FROM ONLY "public"."prpass_timeslots_res" WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "prpass_timeslots_rel_res_id"::pg_catalog.text
59ed037ff5UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption(rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = $1 AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = $2
e2c4a72c8dinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
416d959161SELECT * FROM (SELECT c_order_id AS referencekey_id, ad_column_identifier_std($2, c_order_id) AS record_id, $3 AS ad_role_id, $4 AS ad_user_id, em_prouti_totalizations AS description, $5 AS isActive, ad_org_id, ad_client_id, now() AS created, $6 AS createdBy, now() AS updated, $7 AS updatedBy FROM c_order WHERE em_prouti_totalizations IS NOT NULL) AAA where not exists (select $8 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, $9) != $10)
b25c4a7154update M_Transaction_Last set Updated=$1, M_Transaction_ID=$2 where M_Transaction_Last_ID=$3
a9d2b2152finsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2b29a08c4cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
openbravopg_defaultpublicc_order2109 GB277141579102112327083540136448056
c_order(TOAST)
openbravopg_defaultpg_temp_12ad_context_info323 GB711017109171090
openbravopg_defaultpublicprpass_timeslots_res263 GB10245048214720007878226112111024
prpass_timeslots_res(TOAST)
openbravopg_defaultpublicprpass_pass_inst104 GB171071049726381853270211323851573483
prpass_pass_inst(TOAST)
openbravopg_defaultpublicad_audit_trail54 GB1031296059094569
ad_audit_trail(TOAST)
openbravopg_defaultpublicfact_acct31 GB12586127870160614164
fact_acct(TOAST)
openbravopg_defaultpublicprpass_pass_trans30 GB6108515263410062715107
openbravopg_defaultpublicc_bpartner17 GB160316303650144539763976
c_bpartner(TOAST)
openbravopg_defaultpublicm_transaction13 GB114849526412291413329937858
m_transaction(TOAST)
openbravopg_defaultpublicm_product11 GB112620155553846039
m_product(TOAST)
openbravopg_defaultpg_catalogpg_class10 GB7653126053911710623002394329923942
openbravopg_defaultpublicc_orderline8695 MB1711745531254655027629211048927
c_orderline(TOAST)
openbravopg_defaultpublicm_productionline7879 MB187351094633547599001980018880
m_productionline(TOAST)
openbravopg_defaultpublicc_invoiceline7433 MB15646307652366796725020751794
c_invoiceline(TOAST)
openbravopg_defaultpublicc_invoice7098 MB15217642070145316343710525416576
c_invoice(TOAST)
openbravopg_defaultpublicm_inoutline5983 MB15644713155371955739420751918
m_inoutline(TOAST)
openbravopg_defaultprofilelast_stat_database5183 MB132681921849292
openbravopg_defaultpublicfin_payment_schedule5112 MB12646747078803685981793365
fin_payment_schedule(TOAST)
openbravopg_defaultpublicc_orderlinetax4748 MB164776245762320691889
c_orderlinetax(TOAST)
openbravopg_defaultpublicc_invoicelinetax4715 MB164166207724420691888
c_invoicelinetax(TOAST)

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicfin_finacc_transaction65572073015.7475287090.18
openbravopg_defaultpublicc_order48231114211.58603541121.45
openbravopg_defaultpublicprpass_timeslots_res51346386812.32157622620.38
openbravopg_defaultpublicc_orderline883005162.124006891039.62
openbravopg_defaultpublicc_invoice704046381.692327406065.59
openbravopg_defaultpublicm_inoutline558832041.342266785755.44
openbravopg_defaultpublicc_invoiceline532831881.282267504395.44
openbravopg_defaultpublicm_inout561760911.352220927525.3351320.00595560.00
openbravopg_defaultpublicprpass_pass_inst1623849833.90570621541.37
openbravopg_defaultpublicm_costing707236201.7035118820.08
openbravopg_defaultpublicm_productionline206872620.50319149360.77
openbravopg_defaultpublicprpass_pass_trans40342170.10452095941.09
openbravopg_defaultpublicm_productionplan99673240.24383456030.92
openbravopg_defaultpublicprpass_timeslots_exceptions300064390.72110135160.26
openbravopg_defaultpublicad_treenode6896650.02213447300.51
openbravopg_defaultpg_temp_12ad_context_info212428970.51
openbravopg_defaultpublicm_transaction32046440.08106765120.26
openbravopg_defaultpublicm_product52433340.1343169840.10
openbravopg_defaultpublicfin_payment_schedule79108600.1912482310.03
openbravopg_defaultpublicm_storage_detail24941290.0647366300.11

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicc_order18892277386.264040180.1865.11
openbravopg_defaultpublicfact_acct40240161.84815770.0428.64
openbravopg_defaultpublicc_invoice22262971.028261920.3898.99
openbravopg_defaultpublicm_productionline20789320.95828690.0495.89
openbravopg_defaultpublicprpass_pass_inst14993610.683211160.1599.17
openbravopg_defaultpublicm_transaction16800230.771015600.0587.17
openbravopg_defaultpublicfin_payment_schedule16282510.74691210.0381.47
openbravopg_defaultpublicc_orderline10521540.482325760.1199.74
openbravopg_defaultpublicc_invoiceline10504750.481097900.0599.59
openbravopg_defaultpublicm_inoutline9116910.42499480.0299.66
openbravopg_defaultpublicprpass_pass_trans6626450.30669530.0398.52
openbravopg_defaultpublicad_image2040.006473580.30129280.013.19
openbravopg_defaultpublicm_productionplan5648870.26865750.0498.65
openbravopg_defaultpublicm_inout6212100.28240380.0133840.008880.0099.77
openbravopg_defaultpublicc_orderlinetax6080820.28345270.0224.26
openbravopg_defaultpublicc_invoicelinetax6038360.28225970.0122.18
openbravopg_defaultpublicad_audit_trail4151320.1978570.0094.15
openbravopg_defaultpublicfin_payment_scheduledetail3666070.17449080.0268.98
openbravopg_defaultpublicfin_finacc_transaction818600.043128820.1499.94
openbravopg_defaultpublicm_costing1510410.07418480.0299.74

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
openbravopg_defaultprofilelast_stat_indexes71047161971047184113675243422427901
openbravopg_defaultpg_temp_12ad_context_info71091710907110171100
openbravopg_defaultpublicc_invoice343710525416576170358615217642070145316
c_invoice(TOAST)
openbravopg_defaultprofilelast_stat_tables414583768414544918466329687644310635
openbravopg_defaultpublicm_stock_aux17033423671703331802321966183176
m_stock_aux(TOAST)
openbravopg_defaultpublicobmobc_logclient67337284053
obmobc_logclient(TOAST)11
openbravopg_defaultpublicm_storage_detail636354544214373377591382249824918
m_storage_detail(TOAST)
openbravopg_defaultpublicc_import_entry110761107611074314755501303988201423
c_import_entry(TOAST)14832148321999073802
openbravopg_defaultpublicad_ep_instance_para309413094151568238388
ad_ep_instance_para(TOAST)
openbravopg_defaultpublicm_transaction14133299378581306464651484952641229
m_transaction(TOAST)
openbravopg_defaultpg_catalogpg_statistic2462523832952603858101
pg_statistic(TOAST)46944701102568203327
openbravopg_defaultpublicm_productionline99001980018880120097162873510946335475
m_productionline(TOAST)
openbravopg_defaultpublicc_orderline762921104892711440732071174553125465502
c_orderline(TOAST)
openbravopg_defaultprofilelast_stat_user_functions1244316101244369388370044
last_stat_user_functions(TOAST)
openbravopg_defaultpublicprpass_pass_inst70211323851573483171180118610710497263818532
prpass_pass_inst(TOAST)
openbravopg_defaultpg_catalogpg_class300239432992394276532562177712605391171062
openbravopg_defaultpg_temp_6ad_context_info10419104181140011399
openbravopg_defaultpublicfact_acct1606141641380930452586127870
fact_acct(TOAST)
openbravopg_defaultpublicfin_payment236216362664958029115832
fin_payment(TOAST)
openbravopg_defaultpublicc_order3540136448056277201828039714157910211232708
c_order(TOAST)

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
openbravopg_defaultpublicc_invoice10525416576
c_invoice(TOAST)
openbravopg_defaultprofilelast_stat_indexes1619710471564623
openbravopg_defaultpg_temp_12ad_context_info71090
openbravopg_defaultpublicm_storage_detail6363545442211
m_storage_detail(TOAST)
openbravopg_defaultpublicm_stock_aux423673180217033111185
m_stock_aux(TOAST)
openbravopg_defaultprofilelast_stat_tables376849414541564623
openbravopg_defaultpublicc_import_entry110761107475168
c_import_entry(TOAST)148329
openbravopg_defaultpublicad_ep_instance_para30941475659
ad_ep_instance_para(TOAST)
openbravopg_defaultpublicm_transaction29937858
m_transaction(TOAST)
openbravopg_defaultpg_catalogpg_statistic24625238321
pg_statistic(TOAST)47019
openbravopg_defaultpg_catalogpg_class2394323942299523
openbravopg_defaultpublicc_orderline211048927
c_orderline(TOAST)
openbravopg_defaultpublicm_productionline1980018880
m_productionline(TOAST)
openbravopg_defaultpublicprpass_pass_inst1323834835157
prpass_pass_inst(TOAST)
openbravopg_defaultpublicfin_payment163626649
fin_payment(TOAST)
openbravopg_defaultprofilelast_stat_user_functions161069124431564623
last_stat_user_functions(TOAST)
openbravopg_defaultpublicm_transaction_last13846511
openbravopg_defaultpublicc_order136448056
c_order(TOAST)
openbravopg_defaultpublicfin_finacc_transaction120052396
fin_finacc_transaction(TOAST)
openbravopg_defaultpublicad_sequence108931076957104
ad_sequence(TOAST)

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
openbravopg_defaultpublicfact_acct31 GB14 MB160614164
fact_acct(TOAST)
openbravopg_defaultpublicc_order7801 MB11 MB3540136448056
c_order(TOAST)
openbravopg_defaultpublicc_orderline8706 MB11 MB7629211048927
c_orderline(TOAST)
openbravopg_defaultpublicm_productionline7890 MB11 MB99001980018880
m_productionline(TOAST)
openbravopg_defaultpublicc_invoiceline7437 MB4536 kB725020751794
c_invoiceline(TOAST)
openbravopg_defaultpublicm_inoutline5986 MB3736 kB739420751918
m_inoutline(TOAST)
openbravopg_defaultpublicm_inout4179 MB3608 kB346191845624
m_inout(TOAST)30 MB
openbravopg_defaultpublicprpass_pass_inst_hist5792 MB2552 kB5157
prpass_pass_inst_hist(TOAST)
openbravopg_defaultpublicfin_finacc_transaction3429 MB2000 kB2517120052396
fin_finacc_transaction(TOAST)
openbravopg_defaultpublicc_invoicetax2781 MB1960 kB404231603105
c_invoicetax(TOAST)
openbravopg_defaultpublicprpass_pass_trans_hist4821 MB1768 kB5107
openbravopg_defaultpublicprpass_timeslots_res263 MB888 kB226112111024
prpass_timeslots_res(TOAST)
openbravopg_defaultpublicm_productionplan1243 MB792 kB1677
m_productionplan(TOAST)
openbravopg_defaultpublicobre_reservation184 kB8192 bytes374230337613
obre_reservation(TOAST)480 kB288 kB47574756
openbravopg_defaultpublicm_production498 MB40 kB7013970
m_production(TOAST)
openbravopg_defaultprofilelast_stat_user_functions336 kB16 kB1244316101244369
last_stat_user_functions(TOAST)
openbravopg_defaultprofilelast_stat_tables1560 kB8192 bytes4145837684145449
openbravopg_defaultpg_temp_6ad_context_info8192 bytes8192 bytes220219
openbravopg_defaultpg_temp_5ad_context_info8192 bytes8192 bytes1110
openbravopg_defaultpg_temp_9ad_context_info8192 bytes8192 bytes2221

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
openbravopg_defaultpublicm_inoutlinem_inoutline_orderline563296442261055575.43
openbravopg_defaultpublicc_invoicelinec_invoiceline_orderline563018372259743525.42
openbravopg_defaultpublicm_inoutm_inout_key551486382210405575.31
openbravopg_defaultpublicc_orderlineem_obpos_orderedqty528596152129523035.11
openbravopg_defaultpublicc_invoicec_invoice_key521664692095293675.03
openbravopg_defaultpublicc_orderlinec_orderline_product67570961407244563.38
openbravopg_defaultpublicc_orderc_order_key14104566561200581.35
openbravopg_defaultpublicc_orderlinec_orderline_key11555992462428391.11
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_orderline10667826461012371.11
openbravopg_defaultpublicprpass_pass_transprpass_pass_trans_inst10851509451402891.08
openbravopg_defaultpublicm_productionlinem_productionline_prodplan6594681265142960.64
openbravopg_defaultpublicm_productionplanm_productionplan_key6417510257196790.62
openbravopg_defaultpublicad_treenodead_treenode_tree_node_un703814213376000.51
openbravopg_defaultpublicc_invoicec_invoice_client_org_date_doc138168366350.40
openbravopg_defaultpublicm_productionplanm_productionplan_production3088558123869450.30
openbravopg_defaultpublicprpass_timeslots_resprpass_tslots_res_date_idx3134731118347450.28
openbravopg_defaultpublicprpass_timeslots_exceptionsprpass_tslots_exc_timeslt_idx2838823110134600.26
openbravopg_defaultpublicm_transactionm_transaction_calculated820474891630.18
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_value181960006550.14
openbravopg_defaultpublicm_productionlinem_productionline_key201237249578370.12

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
openbravopg_defaultpublicc_invoicec_invoice_client_org_date_doc1386805890.3195.96
openbravopg_defaultpublicfin_finacc_transactionfin_finacc_tr_account_line122843024290.1493.83
openbravopg_defaultpublicc_orderc_order_client_org_date_docno26852519070.1238.73
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_value18192342270.1196.10
openbravopg_defaultpublicc_orderlinec_orderline_key115559921928740.0999.58
openbravopg_defaultpublicc_orderc_order_key14104566804860.0499.86
openbravopg_defaultpublicm_productionplanm_productionplan_key6417510727050.0399.72
openbravopg_defaultpublicc_orderc_order_documentno_id335672210.0375.61
openbravopg_defaultpublicc_invoicec_invoice_order613760.0378.10
openbravopg_defaultpublicprpass_pass_transprpass_pass_trans_inst10851509594670.0399.87
openbravopg_defaultpublicc_invoicelinec_invoiceline_invoice83101546970.0283.86
openbravopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx198937486200.0294.25
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_orderline10667826433760.0299.91
openbravopg_defaultpublicc_invoicec_invoice_key52166469430290.0299.98
openbravopg_defaultpublicm_productionlinem_productionline_prodplan6594681419530.0299.84
openbravopg_defaultpublicm_transactionm_transsaction_product3813399130.0293.16
openbravopg_defaultpublicm_costingm_costing_product_date28193365010.0298.95
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_pk313150.0188.38
openbravopg_defaultpublicm_inoutlinem_inoutline_orderline56329644308310.0199.99
openbravopg_defaultpublicm_productionm_production_key147620305510.0193.14

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
openbravopg_defaultpublicfact_acctfact_acct_line_id2807 MB9792 kB160214162
openbravopg_defaultpublicfact_acctfact_acct_table_record_id3021 MB6416 kB160094162
openbravopg_defaultpublicc_orderlineem_obpos_orderedqty920 MB3288 kB762912177
openbravopg_defaultpublicc_invoicec_invoice_client_org_date_doc951 MB2384 kB343788678
openbravopg_defaultpublicm_productionlinem_productionline_prodplan1169 MB2032 kB9900920
openbravopg_defaultpublicc_invoicec_invoice_key411 MB1264 kB343788678
openbravopg_defaultpublicc_orderlinec_orderline_product862 MB1200 kB762912177
openbravopg_defaultpublicm_inoutm_inout_key403 MB616 kB34613560
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_key915 MB448 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_prd_ix702 MB400 kB5157
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_key1037 MB360 kB5107
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_part_ix702 MB352 kB5157
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_vlo_ix797 MB352 kB5107
openbravopg_defaultpublicm_productionlineem_cactl_m_prodline_prodorg1850 MB248 kB2105174
openbravopg_defaultpublicm_requisitionlinem_requisitionln_requisit_idx30 MB232 kB33212
openbravopg_defaultpublicm_requisitionlineem_cactl_reqln_bp_idx28 MB232 kB32955
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_ord_ix702 MB232 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_pos_ix603 MB224 kB5157
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_pos_ix590 MB208 kB5107
openbravopg_defaultpublicprpass_timeslots_resprpass_timeslots_res_key71 MB208 kB1316706565

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_defaultpublicfact_acctfact_acct_line_id2807 MB9792 kB160214162
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_ord_ix702 MB232 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_ol_ix702 MB168 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_part_ix702 MB352 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_pos_ix603 MB224 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_prd_ix702 MB400 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_sta_ix267 MB136 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_unl_ix267 MB136 kB5157
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_val_ix482 MB104 kB5157
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_ins_ix795 MB5107
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_pos_ix590 MB208 kB5107
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_vlo_ix797 MB352 kB5107

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopubliccactl_calculate_consumption52211493.451492.990.2860.286
openbravopublicc_order_post1150115.600.030.1010.000
openbravopublicc_order_post11150115.560.020.1000.000
openbravopublicc_order_post11150115.5410.240.1000.009
openbravopublicc_invoice_create114352.277.630.0460.007
openbravoprofiletake_sample2339.560.011.7200.000
openbravoprofiletake_sample_subset2339.550.041.7190.002
openbravoprofiletake_sample2339.513.391.7180.147
openbravopublicc_invoice_post114335.2811.540.0310.010
openbravopublicpricm_createproductprice333235.1717.480.0110.005
openbravopublicad_extension_point_handler687431.422.780.0050.000
openbravopublicm_inout_create114329.990.030.0260.000
openbravopublicm_inout_create114329.967.380.0260.006
openbravoprofiledblink62128.2428.240.0450.045
openbravopublicto_date768711819.6819.680.0000.000
openbravopublicm_inout_post114518.7910.030.0160.009
openbravoprofilecollect_pg_stat_statements_stats2217.720.460.8060.021
openbravopublicm_get_stock_param821813.4613.250.0020.002
openbravopublicm_update_inventory6363513.4511.700.0000.000
openbravopublicad_column_identifier2872013.0212.820.0000.000

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicto_date768711819.6819.680.0000.000
openbravopublicto_char35017171.831.830.0000.000
openbravopublicsubstract_days23717031.791.790.0000.000
openbravopublicad_istriggerenabled153946910.0710.070.0000.000
openbravopublicadd_days10448481.321.320.0000.000
openbravopublicto_date6337481.391.390.0000.000
openbravopublicuuid_generate_v44632841.551.550.0000.000
openbravopublicsubstract_days4160240.460.460.0000.000
openbravopublicto_char3190540.360.360.0000.000
openbravopublicto_number1862760.690.690.0000.000
openbravopublicget_uuid1544282.831.280.0000.000
openbravopublicad_isorgincluded1389242.112.110.0000.000
openbravopublictrunc1149060.230.230.0000.000
openbravopublictrunc1146100.240.240.0000.000
openbravopublicround792810.140.140.0000.000
openbravopublicm_update_inventory6363513.4511.700.0000.000
openbravopublicm_update_stockaux588009.498.830.0000.000
openbravopublicadd_days587420.080.080.0000.000
openbravopublicobequals513960.200.200.0000.000
openbravopublicad_ep_instance_para_insert308061.391.030.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicpricm_productprice338135.420.080.0100.000
openbravopublicm_productionline_trg2970021.854.040.0010.000
openbravopubliccactl_m_prodline_losses_trg990012.802.710.0010.000
openbravopubliccactl_product_org297009.761.490.0000.000
openbravopublicm_transaction_trg440708.574.500.0000.000
openbravopublicc_orderline_trg2287337.932.370.0000.000
openbravopublicau_c_order_trg171846.566.320.0000.000
openbravopublicc_invoiceline_trg293256.072.200.0010.000
openbravopublicaeatsii_invoice_trg1115433.941.850.0000.000
openbravopublicc_invoice_trg1115433.933.220.0000.000
openbravopublicc_orderline2_trg287333.102.940.0000.000
openbravopublicc_invoice_trg21086912.511.410.0000.000
openbravopublicc_orderlinetax_trg97041.871.550.0000.000
openbravopublicc_invoicelinetax_trg93251.851.230.0000.000
openbravopublicm_inoutline_trg94691.801.760.0000.000
openbravopublicc_orderline_trg287331.651.450.0000.000
openbravopublicpriuti_c_invoice_ref_trg1086911.510.900.0000.000
openbravopublicintr_c_orderline_trg287331.430.520.0000.000
openbravopublicc_ordline_chk_restrictions_trg287331.391.290.0000.000
openbravopublicpruti_inherit_invoice_contact1086911.360.760.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
openbravopg_defaultpublicad_ep_instance_para4753094130941
openbravopg_defaultprofilelast_stat_tables1564145837684145449
openbravopg_defaultprofilelast_stat_indexes15671047161971047
openbravopg_defaultprofilelast_stat_user_functions1561244316101244369
openbravopg_defaultpublicm_stock_aux11117033423671703331802
openbravopg_defaultpublicc_import_entry75110761107611074
openbravopg_defaultpublicad_sequence571089310769
openbravopg_defaultpublicobre_reservation41374230337613
openbravopg_defaultpublicobpos_applications3548824881
openbravopg_defaultpublicfin_financial_account3024572457
openbravopg_defaultpublicobre_resource1326602657
openbravopg_defaultpg_catalogpg_class53002394329923942
openbravopg_defaultpublicm_transaction_last513846
openbravopg_defaultpublicm_storage_detail26363545442
postgrespg_globalpg_catalogpg_shdepend1143144
postgrespg_globalpg_catalogpg_database11919
openbravopg_globalpg_catalogpg_shdepend17877
openbravopg_defaultpg_catalogpg_type1138150
openbravopg_defaultpg_catalogpg_attribute119001990
openbravopg_globalpg_catalogpg_database11717

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
openbravopg_defaultpublicad_ep_instance_para6593094130941
openbravopg_defaultpublicm_stock_aux18517033423671703331802
openbravopg_defaultpublicc_import_entry168110761107611074
openbravopg_defaultpublicad_sequence1041089310769
openbravopg_defaultpublicobpos_applications7748824881
openbravopg_defaultprofilelast_stat_tables46234145837684145449
openbravopg_defaultprofilelast_stat_indexes462371047161971047
openbravopg_defaultprofilelast_stat_user_functions46231244316101244369
openbravopg_defaultpublicobre_reservation51374230337613
openbravopg_defaultpublicfin_financial_account3724572457
openbravopg_defaultpublicobre_resource2726602657
openbravopg_defaultpg_catalogpg_class233002394329923942
openbravopg_defaultprofilelast_stat_tablespaces224646
openbravopg_defaultpublicm_storage_detail116363545442
openbravopg_defaultpublicm_transaction_last1113846
openbravopg_defaultpublicad_process_request53494481
openbravopg_defaultpublicc_bpartner539763976
openbravopg_defaultpg_catalogpg_type3138150
openbravopg_defaultprofilelast_stat_database39292
openbravopg_defaultprofilesample_stat_tables321592295

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
openbravopg_defaultpublicm_stock_auxm_stock_aux_aux_id284 MB1112616 kB4400 kB
openbravopg_defaultpublicad_ep_instance_paraad_ep_instance_para_key160 MB475344 kB31 kB
openbravopg_defaultpublicc_import_entryem_prres_organization_idx101 MB751384 kB1244 kB
openbravopg_defaultprofilelast_stat_indexespk_last_stat_indexes84 MB155552 kB2040 kB
openbravopg_defaultpublicm_stock_auxm_stock_aux_storage_detail_id79 MB111728 kB4400 kB
openbravopg_defaultpublicc_import_entryc_import_entry_key70 MB75952 kB1244 kB
openbravopg_defaultpublicm_stock_auxm_stock_aux_key67 MB111616 kB4400 kB
openbravopg_defaultpublicc_import_entryem_prres_typeofdata_idx66 MB75904 kB1244 kB
openbravopg_defaultpublicc_import_entryc_import_entry_type_status63 MB75856 kB1244 kB
openbravopg_defaultpublicc_import_entryem_obpos_application_fk57 MB75784 kB1244 kB
openbravopg_defaultpublicc_import_entryc_import_entry_idx50 MB75680 kB1244 kB
openbravopg_defaultprofilelast_stat_tablespk_last_stat_tables44 MB151296 kB1558 kB
openbravopg_defaultpublicm_storage_detailm_storage_detail_un40 MB220 MB29 MB
openbravopg_defaultpublicm_storage_detailm_storage_detail_uom31 MB215 MB29 MB
openbravopg_defaultpublicm_storage_detailm_storage_detail_locator28 MB214 MB29 MB
openbravopg_defaultpublicm_storage_detailm_storagedet_qtyorderonhand28 MB214 MB29 MB
openbravopg_defaultpublicm_storage_detailm_storage_detail_product19 MB29896 kB29 MB
openbravopg_defaultpublicm_storage_detailm_storage_detail_key18 MB29016 kB29 MB
openbravopg_defaultpublicm_transaction_lastm_trx_last_product_org_wh13 MB52648 kB3552 kB
openbravopg_defaultpublicm_storage_detailm_storagedet_qtyonhand12 MB26120 kB29 MB

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
openbravopublicprpass_timeslots_res722399141015162026-04-30 12:07:18.698105+01263 MB
openbravopg_catalogpg_statistic107641879142026-07-19 10:33:06.789292+017064 kB
openbravopublicc_invoice70378711151776142026-07-08 00:23:08.546646+017098 MB
openbravopublicm_requisitionline31869150539132026-07-06 12:22:50.3815+01184 MB
openbravopg_toastpg_toast_232469135171930122026-05-19 02:38:47.391039+0130 MB
openbravoprofilesample_stat_tables272793733122026-07-19 04:00:30.723333+018672 kB
openbravopublicm_storage_detail513136856112026-07-19 15:17:40.789195+0129 MB
openbravopublicm_product156881806102026-02-20 19:44:18.669967+0010 MB
openbravopublicfin_finacc_transaction661571070748192026-04-02 14:41:49.577329+013429 MB
openbravopublicc_order729503469193487801 MB
openbravopublicprpass_pass_inst6751795775672026-07-16 21:52:27.999093+016280 MB
openbravopublicfact_acct38088463280021462025-07-31 23:28:10.407953+0131 GB
openbravopublicad_process_run21096132952026-06-01 11:38:18.108022+0122 MB
openbravopublicc_orderline1443529779766858706 MB
openbravopg_catalogpg_attribute37245135032026-07-19 15:13:25.008744+016840 kB
openbravopublicm_inout726857526292632025-10-20 23:54:32.431835+014179 MB
openbravopublicm_production1544624503203498 MB
openbravopublicprpass_pass_trans5551292077032026-07-16 21:39:42.083421+015152 MB
openbravopg_toastpg_toast_261925103412026-07-20 01:00:33.383514+017288 kB
openbravopublicm_productionline2010893022476317890 MB

Top tables by modified tuples ratio

Table shows modified tuples statistics since last analyze.

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

DBSchemaTableLiveDeadMod%ModLast AASize
openbravopg_catalogpg_statistic1076418799854593779457064 kB
openbravopublicm_productionline20108930224763185957592026-04-18 16:29:40.193815+017890 MB
openbravopublicm_production15446245032013106382026-04-24 10:39:04.707798+01498 MB
openbravopg_catalogpg_attribute372451350271072026-07-19 15:14:24.201052+016840 kB
openbravopublicprpass_pass_trans555129207704523072026-07-16 21:03:29.20469+015152 MB
openbravopublicm_product156881806124572026-07-13 10:43:57.196489+0110 MB
openbravopublicprpass_pass_inst_hist12378125098093772026-07-16 19:56:26.433478+015792 MB
openbravopublicprpass_pass_inst675179577565030962026-07-18 11:00:16.903044+016280 MB
openbravopublicfin_finacc_transaction661571070748139988352026-06-27 12:53:00.341557+013429 MB
openbravopublicc_invoice7037871115177645233952026-07-16 12:28:46.256497+017098 MB
openbravopublicc_invoicetax87453813275748850652026-02-09 12:46:03.970918+002781 MB
openbravopublicc_order729503469193445552052026-06-29 09:41:55.68684+017801 MB
openbravopublicprpass_pass_trans_hist14003589078465452026-07-16 20:00:37.093696+014821 MB
openbravopublicc_invoiceline142713765080562748842026-02-28 09:04:55.209925+007437 MB
openbravopublicm_inoutline142746072995260178942026-03-06 11:59:32.517041+005986 MB
openbravopublicc_orderline1443529779766849940932026-07-06 00:03:35.926283+018706 MB
openbravopublicm_storage_detail513136856180932026-07-19 16:47:26.118612+0129 MB
openbravopublicm_productionplan345686310110734332026-02-28 13:31:59.297829+001243 MB
openbravopublicad_process_run21096132963422026-07-19 20:34:29.990966+0122 MB
openbravopublicfact_acct380884632800214104390422026-06-25 13:36:17.490096+0131 GB

Cluster settings during the report interval

Defined settings
Settingreset_valUnitSourceNotes
archive_command/bin/true/var/lib/postgresql/10/main/postgresql.auto.conf:3
archive_modeon/etc/postgresql/10/main/postgresql.conf:217
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_size110100488kB/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/09-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/09-pgbadger.conf:10
log_checkpointson/etc/postgresql/10/main/conf.d/09-pgbadger.conf:1
log_connectionson/etc/postgresql/10/main/conf.d/09-pgbadger.conf:2
log_disconnectionson/etc/postgresql/10/main/conf.d/09-pgbadger.conf:3
log_line_prefix%t [%p]:[%l-1] db=%d,user=%u,app=%a,client=%h/etc/postgresql/10/main/conf.d/09-pgbadger.conf:5
log_lock_waitson/etc/postgresql/10/main/conf.d/09-pgbadger.conf:6
log_min_duration_statement5000ms/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:35
log_temp_files0kB/etc/postgresql/10/main/conf.d/09-pgbadger.conf:8
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_connections500/etc/postgresql/10/main/postgresql.conf:64
max_locks_per_transaction128/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:17
max_parallel_workers16/etc/postgresql/10/main/postgresql.conf:167
max_parallel_workers_per_gather4/etc/postgresql/10/main/postgresql.conf:166
max_stack_depth2048kB
max_standby_streaming_delay10800000ms/etc/postgresql/10/main/postgresql.conf:264
max_wal_size57344MB/etc/postgresql/10/main/postgresql.conf:209
max_worker_processes16/etc/postgresql/10/main/postgresql.conf:165
min_wal_size1024MB/etc/postgresql/10/main/postgresql.conf:210
pg_conf_load_time2026-05-19 04:01:11.408995+01
pg_postmaster_start_time2026-05-19 04:01:11.687059+01
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_buffers36700168kB/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/09-pgbadger.conf:9
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
wal_keep_segments2500/etc/postgresql/10/main/postgresql.conf:237
wal_receiver_timeout601000ms/etc/postgresql/10/main/postgresql.conf:271
wal_sender_timeout0ms/etc/postgresql/10/main/postgresql.conf:238
work_mem36700kB/etc/postgresql/10/main/postgresql.conf:122
Default settings
Settingreset_valUnitSourceNotes
allow_in_place_tablespacesoff
allow_system_table_modsoff
application_name
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/etc/postgresql/10/main/postgresql.conf:259
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/09-pgbadger.conf:4
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/09-pgbadger.conf:7
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_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_sync_workers_per_subscription2
max_wal_senders10/etc/postgresql/10/main/postgresql.conf:235
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_identifier7195940715332384199
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_levelreplica/etc/postgresql/10/main/postgresql.conf:180
wal_log_hintsoff
wal_receiver_status_interval10s
wal_retrieve_retry_interval5000ms
wal_segment_size20488kB
wal_sync_methodfdatasync
wal_writer_delay200ms
wal_writer_flush_after1288kB
xmlbinarybase64
xmloptioncontent
zero_damaged_pagesoff