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

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-18 04:00:01+01 - 2026-07-19 03:00:01+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
openbravo869605572996.6414711417542373735292162782077533930357648860825652559697313237 MB37310 GB362 MB
postgres1170799.90635657730190613934826876391 kB
Total881312572996.6514711481042380312592162972691433933840328860825652629697313237 MB37310 GB362 MB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
openbravo1280477916570.25192.6347980476952475419821688261969169719414437223240053
postgres56128.7486756345
template163488.207176276
Total1281673916587.19192.6347981416272475419821688261969169719414437223240674

Cluster statistics

MetricValue
Scheduled checkpoints276
Requested checkpoints
Checkpoint write time (s)46941.17
Checkpoint sync time (s)20.58
Checkpoints buffers written1417163
Background buffers written112624
Backend buffers written179931
Backend fsync count
Bgwriter interrupts (too many buffers)814
Number of buffers allocated24012318
WAL generated10166 MB
WAL segments archived635
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default310 GB362 MB
pg_global1014 kB

SQL query statistics

Top SQL by execution time

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

9918228dba

[9603f2b6]

openbravo2614.1315.76206281604.984553.002795.20129.4914321

4aae53f3da

[5b93a467]

openbravo2561.1615.4418559.13216430.295193047.25815180.866138

59ed037ff5

[f51c7e38]

openbravo1248.507.53343954282.64447614.08870873.1506900.00423

634a705cf9

[3111e984]

openbravo1244.177.503439361.78325.2123462.141654.1133439

6aeca8addc

[e0869ab2]

openbravo1097.336.627951.6407609.76412758.024470.988138

416d959161

[fb2a3095]

openbravo665.704.014823.9094205.95617634.3631744.016138

66933eedde

[a6742d25]

openbravo654.713.9590598425.9890.62110420.495141.23525192

ec8c626e99

[cd9c0fd2]

openbravo362.722.196087362724.584362724.584362724.5841

67a75a3409

[7318d810]

openbravo341.952.0638074329341950.986341950.986341950.9861

2fc2aa8125

[3fe437d2]

openbravo202.621.22741827.3070.0072043.00871.5037420

6e47e0b2e7

[c4153bc0]

openbravo201.421.212429186812.191435.1537163.891573.612248

22615c404b

[c1020a32]

openbravo191.091.156191093.618191093.618191093.6181

86332db8f0

[92ec818a]

openbravo182.441.1030630373182435.376182435.376182435.3761

4a3e0e1397

[4f62fc29]

openbravo174.781.055243694.99643158.69344658.314572.3124

2e210c7585

[cd0b881c]

openbravo138.270.8332690643138272.341138272.341138272.3411

b57306362a

[ba9b8900]

openbravo127.490.77851149.812136.391173.2854.558851

439a14cffe

[f3303a00]

openbravo126.760.76148.953135.472171.7124.611851

be462fba22

[569d183d]

openbravo125.210.7514255140125210.795125210.795125210.7951

695482b977

[ae9bc6b7]

openbravo122.570.7414398784122573.625122573.625122573.6251

f570d33a96

[57d3e9b9]

openbravo121.840.73923.047309.55566630.7575754.719132

Top SQL by executions

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

10410964a2

[6df21622]

openbravo6708225.236708220.0030.0011.9870.0031.9

a46753d96b

[d2788d4]

openbravo5909484.615909480.0030.0014.1250.0071.6

7247cdc8b5

[aada7118]

openbravo3041012.37109490.0100.0034.1820.0242.9

f2e5c3fd88

[2b8e321f]

openbravo2129391.662129390.0060.0020.5350.0041.2

784dd58a53

[c7e884e0]

openbravo2127841.662127840.0030.0020.7050.0030.7

1b89da5cec

[6f9b1a85]

openbravo1961341.530.0010.0000.1710.0010.1

8a7672d920

[2049516b]

openbravo1921601.500.0010.0000.1430.0010.1

03a1d4e90c

[1c1c8a81]

openbravo1909811.491909810.0030.0021.1020.0030.6

08c88cedcc

[6d0d7fc]

openbravo1798741.401798740.0050.0020.4420.0040.9

b93f3a3e02

[30f21dca]

openbravo1373751.071373750.2520.2033.9780.05634.6

ab6445a3b6

[a5716dbe]

openbravo1373751.071373750.2280.2043.6960.04131.3

2bbd1014ed

[d9433e44]

openbravo1344071.051344070.0030.0022.3300.0070.4

7f59edd627

[81592075]

openbravo1219050.951219050.0030.0020.5580.0020.3

281ee3922a

[5d6197e1]

openbravo1114530.871114530.0080.0048.4150.0290.8

9a0540688d

[263f5b0b]

openbravo1029100.80573600.0040.0010.1350.0030.4

1452c325d3

[880044aa]

openbravo1000600.781000600.0020.0010.2360.0010.2

b9a73dbea9

[2b7ebfcc]

openbravo975960.76975960.0090.0070.8990.0050.9

59de48c20b

[3081048d]

openbravo876180.68876180.0040.0020.2190.0020.4

943d79be4b

[b86e6a95]

openbravo860460.67860460.0020.0012.6550.0090.1

6f6f25cdd3

[a342a193]

openbravo707530.55707530.0040.0020.7510.0050.3

Top SQL by shared blocks fetched

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

4aae53f3da

[5b93a467]

openbravo148793404731.0196.222561.2138

66933eedde

[a6742d25]

openbravo71443321714.8999.98654.790598425192

6aeca8addc

[e0869ab2]

openbravo66177583513.7999.961097.3138

59ed037ff5

[f51c7e38]

openbravo2945582276.1499.441248.5343923

634a705cf9

[3111e984]

openbravo2938796636.1299.441244.234393439

6e47e0b2e7

[c4153bc0]

openbravo1455853753.0399.88201.42429186248

416d959161

[fb2a3095]

openbravo1376111882.8759.65665.7138

2fc2aa8125

[3fe437d2]

openbravo906316341.8999.82202.674187420

b4d6b6665e

[72db11e8]

openbravo808540871.6999.7046.8138

92c3ea2c6b

[427f2756]

openbravo675887731.41100.0063.81111

c180ac6f1a

[2266d068]

openbravo625220531.30100.0061.126719

9918228dba

[9603f2b6]

openbravo588064101.23100.002614.12062814321

a828594740

[50544ba4]

openbravo307226050.64100.0029.155

0278eca167

[85280afd]

openbravo307219610.6496.5435.355

b57306362a

[ba9b8900]

openbravo285703490.6099.99127.5851851

439a14cffe

[f3303a00]

openbravo285314940.59100.00126.8851

4a3e0e1397

[4f62fc29]

openbravo245991030.51100.00174.8524

f570d33a96

[57d3e9b9]

openbravo205446000.4397.08121.8132

2d90ae2e61

[8790d132]

openbravo194853880.4199.9420.1409

03d9123317

[94eb716f]

openbravo184381400.38100.0016.633

Top SQL by shared blocks read

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

4aae53f3da

[5b93a467]

openbravo5631131137.5196.222561.2138

416d959161

[fb2a3095]

openbravo5552814236.9959.65665.7138

67a75a3409

[7318d810]

openbravo40195332.68342.0380743291

214f622e78

[ab56bf1d]

openbravo21881811.4645.5418.7295

22615c404b

[c1020a32]

openbravo21798431.4584.62191.161

86332db8f0

[92ec818a]

openbravo16715541.110.00182.4306303731

59ed037ff5

[f51c7e38]

openbravo16593771.1199.441248.5343923

634a705cf9

[3111e984]

openbravo16576771.1099.441244.234393439

0278eca167

[85280afd]

openbravo10622160.7196.5435.355

089f5b9354

[9c2209ed]

openbravo9924020.661.4293.5200862591

b88437ee76

[4def43cd]

openbravo9801540.651.5386.672801921

41fb274cbd

[4a05f158]

openbravo9700510.6514.5411.211

2e210c7585

[cd0b881c]

openbravo9631880.64138.3326906431

695482b977

[ae9bc6b7]

openbravo9522890.6314.30122.6143987841

37f1ce8b4f

[1a997f87]

openbravo9468840.6314.8010.91

be462fba22

[569d183d]

openbravo8768340.587.75125.2142551401

e1739d379d

[6f92ba97]

openbravo8550720.575.8685.470320031

ffcd2dfda5

[336527ac]

openbravo7404170.4977.0124513301

58f46f2fd3

[54e476f8]

openbravo7389730.498.048.56919381

84dd1037ec

[90c9c123]

openbravo6761340.4577.1585.372174

Top SQL by shared blocks dirtied

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

d545a87b3d

[a03a69a5]

openbravo1836028.4798.3031.05712057120

6758866a26

[eb67e33f]

openbravo1044644.8296.1025.06932669326

2c756b6487

[4211bbca]

openbravo955364.4043.1215.62

8d75ee1767

[3695269c]

openbravo813573.7596.9916.51870918709

7efafc5af2

[74267a2]

openbravo600422.7799.45111.910881088

ff35139986

[a35d3b99]

openbravo600422.7799.45111.910881088

4cb9cc1cbf

[ea4e56b9]

openbravo600422.7799.45111.910881088

22615c404b

[c1020a32]

openbravo424191.9684.62191.161

fec93ea334

[2ff59f28]

openbravo366981.6999.887.76899468994

101ed24576

[205b8c88]

openbravo351081.6298.636.41234412344

e1739d379d

[6f92ba97]

openbravo338981.565.8685.470320031

7cdb887c2a

[8f1d721]

openbravo337561.5699.6923.075677567

fa5e805d20

[6bdd6481]

openbravo314101.4598.808.672717271

26959f7c7a

[d3eb78]

openbravo313921.4592.547.81530815308

75890e23a4

[baa0f6d7]

openbravo246041.1399.7913.979537953

43a80059e4

[bfd8039a]

openbravo241091.1199.3436.0792792

320ed06a6d

[41b729f2]

openbravo237351.0997.353.755735573

98d4183d4b

[6ee18a4d]

openbravo226091.0450.571.02

86ae00e408

[12018251]

openbravo222521.0388.844.361736173

d5c8e0e271

[89ff8432]

openbravo210900.9795.051.670257025

Top SQL by shared blocks written

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

2c756b6487

[4211bbca]

openbravo800424.6844.4843.1215.62

98d4183d4b

[6ee18a4d]

openbravo219021.2812.1750.571.02

2ce9536368

[76ede534]

openbravo90240.535.0261.480.22

8b47e0efaf

[429b2ffc]

openbravo75570.444.2070.470.82

214f622e78

[ab56bf1d]

openbravo38180.222.1245.5418.7295

5a62f392ad

[1e5d1bbf]

openbravo9880.060.5591.420.62

296d3e9f8b

[bffafbed]

openbravo1900.010.1188.640.12

b57c313cf3

[ccea5876]

openbravo1620.010.0985.740.11

1838b6bc4e

[9a64cac6]

openbravo910.010.0580.541.32

60617a23d2

[423e83ff]

openbravo710.000.0495.350.52

Top SQL by temp usage

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

7e62f3b264

[6e3dad39]

openbravo40323697.3016513297.30115.493636

a065237476

[4f137456]

openbravo112012.7045872.703.2261

6f6f25cdd3

[a342a193]

openbravo7251799.1959126.480.37075370753

3b6d5ffa92

[1a9c4c53]

openbravo1057799.59431.930.01045210452

a2199342ef

[cf29166b]

openbravo1083799.60431.930.01071510715

abd1ffd3da

[2ad727c8]

openbravo855899.51421.880.084398439

1072260572

[cff679c3]

openbravo829399.57361.610.081908190

c912725120

[48f3ff5f]

openbravo933999.63351.570.092439243

8c3443e752

[15983ca0]

openbravo677499.57291.300.066926692

81212fd9dc

[b538d346]

openbravo772199.62291.300.076437643

8b41e9f2f7

[6fdecd59]

openbravo735299.63271.210.072777277

b509362d49

[a37345e3]

openbravo522199.50261.160.051525152

d39b22263f

[acc7aa2f]

openbravo589499.58251.120.058285828

97022e6f16

[7f561d8d]

openbravo510099.55231.030.050405040

842e889b6e

[b597e01f]

openbravo610399.62231.030.060436043

88921879fa

[4ddd357d]

openbravo509099.59210.940.050365036

6f5fce3e92

[3a828a25]

openbravo329699.42190.850.032463246

0cb9051ec1

[a5d17c63]

openbravo430899.56190.850.042514251

654a1b7b38

[1de636a9]

openbravo377099.52180.810.037253725

3d74d8c5f6

[2eb47d62]

openbravo416299.57180.810.041154115

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)
8c3443e752insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
37f1ce8b4fSELECT $2 FROM ONLY "public"."c_orderline" x WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "em_cactl_variety_product_id"::pg_catalog.text FOR KEY SHARE OF x
3b6d5ffa92insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
654a1b7b38insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
5a62f392advacuum analyze AD_PInstance
8a7672d920COMMIT
101ed24576update C_Invoice set Updated=$1, DaysTillDue=$2, LastCalculatedOnDate=$3 where C_Invoice_ID=$4
c180ac6f1aselect businesspa0_.C_BPartner_ID as C_BPartn1_203_, businesspa0_.AD_Client_ID as AD_Clien2_203_, businesspa0_.AD_Org_ID as AD_Org_I3_203_, businesspa0_.IsActive as IsActive4_203_, businesspa0_.Created as Created5_203_, businesspa0_.CreatedBy as CreatedB6_203_, businesspa0_.Updated as Updated7_203_, businesspa0_.UpdatedBy as UpdatedB8_203_, businesspa0_.Value as Value9_203_, businesspa0_.Name as Name10_203_, businesspa0_.Name2 as Name11_203_, businesspa0_.Description as Descrip12_203_, businesspa0_.IsSummary as IsSumma13_203_, businesspa0_.C_BP_Group_ID as C_BP_Gr14_203_, businesspa0_.IsOneTime as IsOneTi15_203_, businesspa0_.IsProspect as IsProsp16_203_, businesspa0_.IsVendor as IsVendo17_203_, businesspa0_.IsCustomer as IsCusto18_203_, businesspa0_.IsEmployee as IsEmplo19_203_, businesspa0_.IsSalesRep as IsSales20_203_, businesspa0_.ReferenceNo as Referen21_203_, businesspa0_.DUNS as DUNS22_203_, businesspa0_.URL as URL23_203_, businesspa0_.AD_Language as AD_Lang24_203_, businesspa0_.TaxID as TaxID25_203_, businesspa0_.IsTaxExempt as IsTaxEx26_203_, businesspa0_.C_InvoiceSchedule_ID as C_Invoi27_203_, businesspa0_.Rating as Rating28_203_, businesspa0_.SalesVolume as SalesVo29_203_, businesspa0_.NumberEmployees as NumberE30_203_, businesspa0_.NAICS as NAICS31_203_, businesspa0_.FirstSale as FirstSa32_203_, businesspa0_.AcqusitionCost as Acqusit33_203_, businesspa0_.PotentialLifeTimeValue as Potenti34_203_, businesspa0_.ActualLifeTimeValue as ActualL35_203_, businesspa0_.ShareOfCustomer as ShareOf36_203_, businesspa0_.PaymentRule as Payment37_203_, businesspa0_.SO_CreditLimit as SO_Cred38_203_, businesspa0_.SO_CreditUsed as SO_Cred39_203_, businesspa0_.C_PaymentTerm_ID as C_Payme40_203_, businesspa0_.M_PriceList_ID as M_Price41_203_, businesspa0_.IsDiscountPrinted as IsDisco42_203_, businesspa0_.SO_Description as SO_Desc43_203_, businesspa0_.POReference as PORefer44_203_, businesspa0_.PaymentRulePO as Payment45_203_, businesspa0_.PO_PriceList_ID as PO_Pric46_203_, businesspa0_.PO_PaymentTerm_ID as PO_Paym47_203_, businesspa0_.DocumentCopies as Documen48_203_, businesspa0_.C_Greeting_ID as C_Greet49_203_, businesspa0_.InvoiceRule as Invoice50_203_, businesspa0_.DeliveryRule as Deliver51_203_, businesspa0_.DeliveryViaRule as Deliver52_203_, businesspa0_.SalesRep_ID as SalesRe53_203_, businesspa0_.BPartner_Parent_ID as BPartne54_203_, businesspa0_.SOCreditStatus as SOCredi55_203_, businesspa0_.AD_Forced_Org_ID as AD_Forc56_203_, businesspa0_.ShowPriceInOrder as ShowPri57_203_, businesspa0_.Invoicegrouping as Invoice58_203_, businesspa0_.FixMonthDay as FixMont59_203_, businesspa0_.FixMonthDay2 as FixMont60_203_, businesspa0_.Fixmonthday3 as Fixmont61_203_, businesspa0_.Isworker as Isworke62_203_, businesspa0_.UPC as UPC63_203_, businesspa0_.C_Salary_Category_ID as C_Salar64_203_, businesspa0_.Invoice_Printformat as Invoice65_203_, businesspa0_.Last_Days as Last_Da66_203_, businesspa0_.PO_Bankaccount_ID as PO_Bank67_203_, businesspa0_.PO_BP_TaxCategory_ID as PO_BP_T68_203_, businesspa0_.PO_Fixmonthday as PO_Fixm69_203_, businesspa0_.PO_Fixmonthday2 as PO_Fixm70_203_, businesspa0_.PO_Fixmonthday3 as PO_Fixm71_203_, businesspa0_.SO_Bankaccount_ID as SO_Bank72_203_, businesspa0_.SO_Bp_Taxcategory_ID as SO_Bp_T73_203_, businesspa0_.Fiscalcode as Fiscalc74_203_, businesspa0_.Isofiscalcode as Isofisc75_203_, businesspa0_.EM_Einv_Einvoice as EM_Einv76_203_, businesspa0_.PO_C_Incoterms_ID as PO_C_In77_203_, businesspa0_.EM_Einv_Format_Id as EM_Einv78_203_, businesspa0_.SO_C_Incoterms_ID as SO_C_In79_203_, businesspa0_.EM_Einv_Platform_Id as EM_Einv80_203_, businesspa0_.FIN_Paymentmethod_ID as FIN_Pay81_203_, businesspa0_.EM_Einv_Email as EM_Einv82_203_, businesspa0_.PO_Paymentmethod_ID as PO_Paym83_203_, businesspa0_.FIN_Financial_Account_ID as FIN_Fin84_203_, businesspa0_.EM_Einv_Deliverymode as EM_Einv85_203_, businesspa0_.PO_Financial_Account_ID as PO_Fina86_203_, businesspa0_.Customer_Blocking as Custome87_203_, businesspa0_.Vendor_Blocking as Vendor_88_203_, businesspa0_.SO_Payment_Blocking as SO_Paym89_203_, businesspa0_.PO_Payment_Blocking as PO_Paym90_203_, businesspa0_.SO_Invoice_Blocking as SO_Invo91_203_, businesspa0_.PO_Invoice_Blocking as PO_Invo92_203_, businesspa0_.SO_Order_Blocking as SO_Orde93_203_, businesspa0_.PO_Order_Blocking as PO_Orde94_203_, businesspa0_.SO_Goods_Blocking as SO_Good95_203_, businesspa0_.PO_Goods_Blocking as PO_Good96_203_, businesspa0_.Iscashvat as Iscashv97_203_, businesspa0_.EM_Advcrm_Newactivity as EM_Advc98_203_, businesspa0_.Update_Currency as Update_99_203_, businesspa0_.BP_Currency_ID as BP_Cur100_203_, businesspa0_.Birthplace as Birthp101_203_, businesspa0_.Birthday as Birthd102_203_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgp103_203_, businesspa0_.Is_Customer_Consent as Is_Cus104_203_, businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL as EM_OBS105_203_, businesspa0_.EM_Obsepad_Mandate_Identifier as EM_Obs106_203_, businesspa0_.EM_Obsmail_Language as EM_Obs107_203_, businesspa0_.EM_Obsepad_Mandate_Date as EM_Obs108_203_, businesspa0_.EM_Aeatsii_Rep_Taxid as EM_Aea109_203_, businesspa0_.EM_Aeatsii_Menor as EM_Aea110_203_, businesspa0_.EM_Pricm_Isintercompany as EM_Pri111_203_, businesspa0_.EM_Psat_Billtobpartner_ID as EM_Psa112_203_, businesspa0_.EM_Psat_Locator_ID as EM_Psa113_203_, businesspa0_.EM_Psat_Mobile_Request as EM_Psa114_203_, businesspa0_.EM_Prges_Glitem_ID as EM_Prg115_203_, businesspa0_.EM_Rrhh_Exemployee as EM_Rrh116_203_, businesspa0_.EM_Rrhh_Candidate as EM_Rrh117_203_, businesspa0_.EM_Prpass_No_Print_Pass as EM_Prp118_203_, businesspa0_.EM_Rrhh_Holidays_Supervisor as EM_Rrh119_203_, businesspa0_.EM_Cactal_Emp_No as EM_Cac120_203_, businesspa0_.EM_Cactal_Emp_Relationship_No as EM_Cac121_203_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as EM_Obw122_203_, businesspa0_.EM_Pruti_Addbp as EM_Pru123_203_, businesspa0_.EM_Prpass_Generatepassemployee as EM_Prp124_203_, businesspa0_.EM_Rrhh_Mainworkstation_ID as EM_Rrh125_203_, businesspa0_.EM_Rrhh_Bp_Transfer_Code as EM_Rrh126_203_, businesspa0_.EM_OBTIK_Tax_ID_Key as EM_OBT127_203_ from C_BPartner businesspa0_ where (upper((businesspa0_.Value||$3||businesspa0_.Name||$4||coalesce(to_char(businesspa0_.TaxID), $5)||$6||coalesce(to_char(businesspa0_.Name2), $7))) like upper($1) escape $8) and (exists (select $9 from C_Order order1_ inner join C_BPartner businesspa2_ on order1_.C_BPartner_ID=businesspa2_.C_BPartner_ID cross join C_DocType documentty3_ where order1_.C_DocTypeTarget_ID=documentty3_.C_DocType_ID and order1_.IsSOTrx=$10 and documentty3_.IsReturn=$11 and businesspa2_.C_BPartner_ID=businesspa0_.C_BPartner_ID and (order1_.AD_Org_ID in ($12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 , $37 , $38 , $39 , $40 , $41 , $42 , $43 , $44 , $45 , $46 , $47 , $48 , $49)) and (order1_.AD_Client_ID in ($50 , $51)))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit $2
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
abd1ffd3dainsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
3d74d8c5f6insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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)
6f5fce3e92insert 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)
2c756b6487vacuum analyze obmobc_logclient
60617a23d2vacuum analyze AD_Process_Run
92c3ea2c6bselect sum(order0_.GrandTotal) as col_0_0_ 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)) limit $42
8b47e0efafvacuum analyze M_Stock_Proposed
c912725120insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
41fb274cbddelete from cactl_variety_product where Cactl_Variety_Product_ID=$1
88921879fainsert 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
a065237476select cactl_vari0_.Cactl_Variety_Product_ID as Cactl_Va1_366_, cactl_vari0_.AD_Client_ID as AD_Clien2_366_, cactl_vari0_.AD_Org_ID as AD_Org_I3_366_, cactl_vari0_.Isactive as Isactive4_366_, cactl_vari0_.Created as Created5_366_, cactl_vari0_.Createdby as Createdb6_366_, cactl_vari0_.Updated as Updated7_366_, cactl_vari0_.Updatedby as Updatedb8_366_, cactl_vari0_.M_Product_ID as M_Produc9_366_, cactl_vari0_.C_Bpartner_ID as C_Bpart10_366_, cactl_vari0_.C_Uom_ID as C_Uom_I11_366_, cactl_vari0_.Price as Price12_366_, cactl_vari0_.Cactl_Variety_ID as Cactl_V13_366_, cactl_vari0_.Pricelist as Priceli14_366_, cactl_vari0_.Date_From as Date_Fr15_366_, cactl_vari0_.Date_To as Date_To16_366_, cactl_vari0_.Vendorproductno as Vendorp17_366_, cactl_vari0_.Iscurrentvendor as Iscurre18_366_, cactl_vari0_.Isprocessing as Isproce19_366_ from cactl_variety_product cactl_vari0_ left outer join C_BPartner businesspa1_ on cactl_vari0_.C_Bpartner_ID=businesspa1_.C_BPartner_ID left outer join C_UOM uom2_ on cactl_vari0_.C_Uom_ID=uom2_.C_UOM_ID left outer join cactl_variety cactl_vari3_ on cactl_vari0_.Cactl_Variety_ID=cactl_vari3_.Cactl_Variety_ID where (cactl_vari0_.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 (cactl_vari0_.AD_Client_ID in ($1 , $2)) and cactl_vari0_.Isactive=$42 order by businesspa1_.Value, businesspa1_.Name, businesspa1_.TaxID, businesspa1_.Name2, uom2_.Name, cactl_vari0_.Price, cactl_vari3_.Name, cactl_vari3_.Value, cactl_vari0_.Cactl_Variety_Product_ID limit $3
4a3e0e1397select businesspa0_.C_BPartner_ID as C_BPartn1_203_, businesspa0_.AD_Client_ID as AD_Clien2_203_, businesspa0_.AD_Org_ID as AD_Org_I3_203_, businesspa0_.IsActive as IsActive4_203_, businesspa0_.Created as Created5_203_, businesspa0_.CreatedBy as CreatedB6_203_, businesspa0_.Updated as Updated7_203_, businesspa0_.UpdatedBy as UpdatedB8_203_, businesspa0_.Value as Value9_203_, businesspa0_.Name as Name10_203_, businesspa0_.Name2 as Name11_203_, businesspa0_.Description as Descrip12_203_, businesspa0_.IsSummary as IsSumma13_203_, businesspa0_.C_BP_Group_ID as C_BP_Gr14_203_, businesspa0_.IsOneTime as IsOneTi15_203_, businesspa0_.IsProspect as IsProsp16_203_, businesspa0_.IsVendor as IsVendo17_203_, businesspa0_.IsCustomer as IsCusto18_203_, businesspa0_.IsEmployee as IsEmplo19_203_, businesspa0_.IsSalesRep as IsSales20_203_, businesspa0_.ReferenceNo as Referen21_203_, businesspa0_.DUNS as DUNS22_203_, businesspa0_.URL as URL23_203_, businesspa0_.AD_Language as AD_Lang24_203_, businesspa0_.TaxID as TaxID25_203_, businesspa0_.IsTaxExempt as IsTaxEx26_203_, businesspa0_.C_InvoiceSchedule_ID as C_Invoi27_203_, businesspa0_.Rating as Rating28_203_, businesspa0_.SalesVolume as SalesVo29_203_, businesspa0_.NumberEmployees as NumberE30_203_, businesspa0_.NAICS as NAICS31_203_, businesspa0_.FirstSale as FirstSa32_203_, businesspa0_.AcqusitionCost as Acqusit33_203_, businesspa0_.PotentialLifeTimeValue as Potenti34_203_, businesspa0_.ActualLifeTimeValue as ActualL35_203_, businesspa0_.ShareOfCustomer as ShareOf36_203_, businesspa0_.PaymentRule as Payment37_203_, businesspa0_.SO_CreditLimit as SO_Cred38_203_, businesspa0_.SO_CreditUsed as SO_Cred39_203_, businesspa0_.C_PaymentTerm_ID as C_Payme40_203_, businesspa0_.M_PriceList_ID as M_Price41_203_, businesspa0_.IsDiscountPrinted as IsDisco42_203_, businesspa0_.SO_Description as SO_Desc43_203_, businesspa0_.POReference as PORefer44_203_, businesspa0_.PaymentRulePO as Payment45_203_, businesspa0_.PO_PriceList_ID as PO_Pric46_203_, businesspa0_.PO_PaymentTerm_ID as PO_Paym47_203_, businesspa0_.DocumentCopies as Documen48_203_, businesspa0_.C_Greeting_ID as C_Greet49_203_, businesspa0_.InvoiceRule as Invoice50_203_, businesspa0_.DeliveryRule as Deliver51_203_, businesspa0_.DeliveryViaRule as Deliver52_203_, businesspa0_.SalesRep_ID as SalesRe53_203_, businesspa0_.BPartner_Parent_ID as BPartne54_203_, businesspa0_.SOCreditStatus as SOCredi55_203_, businesspa0_.AD_Forced_Org_ID as AD_Forc56_203_, businesspa0_.ShowPriceInOrder as ShowPri57_203_, businesspa0_.Invoicegrouping as Invoice58_203_, businesspa0_.FixMonthDay as FixMont59_203_, businesspa0_.FixMonthDay2 as FixMont60_203_, businesspa0_.Fixmonthday3 as Fixmont61_203_, businesspa0_.Isworker as Isworke62_203_, businesspa0_.UPC as UPC63_203_, businesspa0_.C_Salary_Category_ID as C_Salar64_203_, businesspa0_.Invoice_Printformat as Invoice65_203_, businesspa0_.Last_Days as Last_Da66_203_, businesspa0_.PO_Bankaccount_ID as PO_Bank67_203_, businesspa0_.PO_BP_TaxCategory_ID as PO_BP_T68_203_, businesspa0_.PO_Fixmonthday as PO_Fixm69_203_, businesspa0_.PO_Fixmonthday2 as PO_Fixm70_203_, businesspa0_.PO_Fixmonthday3 as PO_Fixm71_203_, businesspa0_.SO_Bankaccount_ID as SO_Bank72_203_, businesspa0_.SO_Bp_Taxcategory_ID as SO_Bp_T73_203_, businesspa0_.Fiscalcode as Fiscalc74_203_, businesspa0_.Isofiscalcode as Isofisc75_203_, businesspa0_.EM_Einv_Einvoice as EM_Einv76_203_, businesspa0_.PO_C_Incoterms_ID as PO_C_In77_203_, businesspa0_.EM_Einv_Format_Id as EM_Einv78_203_, businesspa0_.SO_C_Incoterms_ID as SO_C_In79_203_, businesspa0_.EM_Einv_Platform_Id as EM_Einv80_203_, businesspa0_.FIN_Paymentmethod_ID as FIN_Pay81_203_, businesspa0_.EM_Einv_Email as EM_Einv82_203_, businesspa0_.PO_Paymentmethod_ID as PO_Paym83_203_, businesspa0_.FIN_Financial_Account_ID as FIN_Fin84_203_, businesspa0_.EM_Einv_Deliverymode as EM_Einv85_203_, businesspa0_.PO_Financial_Account_ID as PO_Fina86_203_, businesspa0_.Customer_Blocking as Custome87_203_, businesspa0_.Vendor_Blocking as Vendor_88_203_, businesspa0_.SO_Payment_Blocking as SO_Paym89_203_, businesspa0_.PO_Payment_Blocking as PO_Paym90_203_, businesspa0_.SO_Invoice_Blocking as SO_Invo91_203_, businesspa0_.PO_Invoice_Blocking as PO_Invo92_203_, businesspa0_.SO_Order_Blocking as SO_Orde93_203_, businesspa0_.PO_Order_Blocking as PO_Orde94_203_, businesspa0_.SO_Goods_Blocking as SO_Good95_203_, businesspa0_.PO_Goods_Blocking as PO_Good96_203_, businesspa0_.Iscashvat as Iscashv97_203_, businesspa0_.EM_Advcrm_Newactivity as EM_Advc98_203_, businesspa0_.Update_Currency as Update_99_203_, businesspa0_.BP_Currency_ID as BP_Cur100_203_, businesspa0_.Birthplace as Birthp101_203_, businesspa0_.Birthday as Birthd102_203_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgp103_203_, businesspa0_.Is_Customer_Consent as Is_Cus104_203_, businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL as EM_OBS105_203_, businesspa0_.EM_Obsepad_Mandate_Identifier as EM_Obs106_203_, businesspa0_.EM_Obsmail_Language as EM_Obs107_203_, businesspa0_.EM_Obsepad_Mandate_Date as EM_Obs108_203_, businesspa0_.EM_Aeatsii_Rep_Taxid as EM_Aea109_203_, businesspa0_.EM_Aeatsii_Menor as EM_Aea110_203_, businesspa0_.EM_Pricm_Isintercompany as EM_Pri111_203_, businesspa0_.EM_Psat_Billtobpartner_ID as EM_Psa112_203_, businesspa0_.EM_Psat_Locator_ID as EM_Psa113_203_, businesspa0_.EM_Psat_Mobile_Request as EM_Psa114_203_, businesspa0_.EM_Prges_Glitem_ID as EM_Prg115_203_, businesspa0_.EM_Rrhh_Exemployee as EM_Rrh116_203_, businesspa0_.EM_Rrhh_Candidate as EM_Rrh117_203_, businesspa0_.EM_Prpass_No_Print_Pass as EM_Prp118_203_, businesspa0_.EM_Rrhh_Holidays_Supervisor as EM_Rrh119_203_, businesspa0_.EM_Cactal_Emp_No as EM_Cac120_203_, businesspa0_.EM_Cactal_Emp_Relationship_No as EM_Cac121_203_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as EM_Obw122_203_, businesspa0_.EM_Pruti_Addbp as EM_Pru123_203_, businesspa0_.EM_Prpass_Generatepassemployee as EM_Prp124_203_, businesspa0_.EM_Rrhh_Mainworkstation_ID as EM_Rrh125_203_, businesspa0_.EM_Rrhh_Bp_Transfer_Code as EM_Rrh126_203_, businesspa0_.EM_OBTIK_Tax_ID_Key as EM_OBT127_203_ from C_BPartner businesspa0_ where exists (select $3 from C_Order order1_ inner join C_BPartner businesspa2_ on order1_.C_BPartner_ID=businesspa2_.C_BPartner_ID where (upper((order1_.DocumentNo||$4||coalesce(to_char(order1_.DateOrdered), $5)||$6||coalesce(to_char(order1_.GrandTotal), $7))) like upper($1) escape $8) and businesspa2_.C_BPartner_ID=businesspa0_.C_BPartner_ID and (order1_.AD_Org_ID in ($9 , $10 , $11 , $12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 , $37 , $38 , $39 , $40 , $41 , $42 , $43 , $44 , $45 , $46)) and (order1_.AD_Client_ID in ($47 , $48))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit $2
a828594740select sum(order0_.GrandTotal) as col_0_0_ from C_Order order0_ cross join C_DocType documentty1_ where order0_.C_DocTypeTarget_ID=documentty1_.C_DocType_ID and order0_.IsSOTrx=$42 and documentty1_.IsReturn=$43 and (order0_.AD_Org_ID in ($1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 , $37 , $38)) and (order0_.AD_Client_ID in ($39 , $40)) limit $41
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)
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
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
7e62f3b264select cactl_vari0_.Cactl_Variety_Product_ID as Cactl_Va1_366_, cactl_vari0_.AD_Client_ID as AD_Clien2_366_, cactl_vari0_.AD_Org_ID as AD_Org_I3_366_, cactl_vari0_.Isactive as Isactive4_366_, cactl_vari0_.Created as Created5_366_, cactl_vari0_.Createdby as Createdb6_366_, cactl_vari0_.Updated as Updated7_366_, cactl_vari0_.Updatedby as Updatedb8_366_, cactl_vari0_.M_Product_ID as M_Produc9_366_, cactl_vari0_.C_Bpartner_ID as C_Bpart10_366_, cactl_vari0_.C_Uom_ID as C_Uom_I11_366_, cactl_vari0_.Price as Price12_366_, cactl_vari0_.Cactl_Variety_ID as Cactl_V13_366_, cactl_vari0_.Pricelist as Priceli14_366_, cactl_vari0_.Date_From as Date_Fr15_366_, cactl_vari0_.Date_To as Date_To16_366_, cactl_vari0_.Vendorproductno as Vendorp17_366_, cactl_vari0_.Iscurrentvendor as Iscurre18_366_, cactl_vari0_.Isprocessing as Isproce19_366_ from cactl_variety_product cactl_vari0_ left outer join C_BPartner businesspa1_ on cactl_vari0_.C_Bpartner_ID=businesspa1_.C_BPartner_ID left outer join C_UOM uom2_ on cactl_vari0_.C_Uom_ID=uom2_.C_UOM_ID left outer join cactl_variety cactl_vari3_ on cactl_vari0_.Cactl_Variety_ID=cactl_vari3_.Cactl_Variety_ID where (cactl_vari0_.AD_Org_ID in ($4 , $5 , $6 , $7 , $8 , $9 , $10)) and (cactl_vari0_.AD_Client_ID in ($1 , $2)) and cactl_vari0_.Isactive=$11 order by businesspa1_.Value, businesspa1_.Name, businesspa1_.TaxID, businesspa1_.Name2, uom2_.Name, cactl_vari0_.Price, cactl_vari3_.Name, cactl_vari3_.Value, cactl_vari0_.Cactl_Variety_Product_ID limit $3
98d4183d4bvacuum analyze C_Import_Entry_Archive
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
8b41e9f2f7insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
2ce9536368vacuum analyze prsync_entry
97022e6f16insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
7f59edd627SELECT $2 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
0278eca167select 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_.C_Order_ID desc limit $42
2d90ae2e61select businesspa0_.C_BPartner_ID as C_BPartn1_203_, businesspa0_.AD_Client_ID as AD_Clien2_203_, businesspa0_.AD_Org_ID as AD_Org_I3_203_, businesspa0_.IsActive as IsActive4_203_, businesspa0_.Created as Created5_203_, businesspa0_.CreatedBy as CreatedB6_203_, businesspa0_.Updated as Updated7_203_, businesspa0_.UpdatedBy as UpdatedB8_203_, businesspa0_.Value as Value9_203_, businesspa0_.Name as Name10_203_, businesspa0_.Name2 as Name11_203_, businesspa0_.Description as Descrip12_203_, businesspa0_.IsSummary as IsSumma13_203_, businesspa0_.C_BP_Group_ID as C_BP_Gr14_203_, businesspa0_.IsOneTime as IsOneTi15_203_, businesspa0_.IsProspect as IsProsp16_203_, businesspa0_.IsVendor as IsVendo17_203_, businesspa0_.IsCustomer as IsCusto18_203_, businesspa0_.IsEmployee as IsEmplo19_203_, businesspa0_.IsSalesRep as IsSales20_203_, businesspa0_.ReferenceNo as Referen21_203_, businesspa0_.DUNS as DUNS22_203_, businesspa0_.URL as URL23_203_, businesspa0_.AD_Language as AD_Lang24_203_, businesspa0_.TaxID as TaxID25_203_, businesspa0_.IsTaxExempt as IsTaxEx26_203_, businesspa0_.C_InvoiceSchedule_ID as C_Invoi27_203_, businesspa0_.Rating as Rating28_203_, businesspa0_.SalesVolume as SalesVo29_203_, businesspa0_.NumberEmployees as NumberE30_203_, businesspa0_.NAICS as NAICS31_203_, businesspa0_.FirstSale as FirstSa32_203_, businesspa0_.AcqusitionCost as Acqusit33_203_, businesspa0_.PotentialLifeTimeValue as Potenti34_203_, businesspa0_.ActualLifeTimeValue as ActualL35_203_, businesspa0_.ShareOfCustomer as ShareOf36_203_, businesspa0_.PaymentRule as Payment37_203_, businesspa0_.SO_CreditLimit as SO_Cred38_203_, businesspa0_.SO_CreditUsed as SO_Cred39_203_, businesspa0_.C_PaymentTerm_ID as C_Payme40_203_, businesspa0_.M_PriceList_ID as M_Price41_203_, businesspa0_.IsDiscountPrinted as IsDisco42_203_, businesspa0_.SO_Description as SO_Desc43_203_, businesspa0_.POReference as PORefer44_203_, businesspa0_.PaymentRulePO as Payment45_203_, businesspa0_.PO_PriceList_ID as PO_Pric46_203_, businesspa0_.PO_PaymentTerm_ID as PO_Paym47_203_, businesspa0_.DocumentCopies as Documen48_203_, businesspa0_.C_Greeting_ID as C_Greet49_203_, businesspa0_.InvoiceRule as Invoice50_203_, businesspa0_.DeliveryRule as Deliver51_203_, businesspa0_.DeliveryViaRule as Deliver52_203_, businesspa0_.SalesRep_ID as SalesRe53_203_, businesspa0_.BPartner_Parent_ID as BPartne54_203_, businesspa0_.SOCreditStatus as SOCredi55_203_, businesspa0_.AD_Forced_Org_ID as AD_Forc56_203_, businesspa0_.ShowPriceInOrder as ShowPri57_203_, businesspa0_.Invoicegrouping as Invoice58_203_, businesspa0_.FixMonthDay as FixMont59_203_, businesspa0_.FixMonthDay2 as FixMont60_203_, businesspa0_.Fixmonthday3 as Fixmont61_203_, businesspa0_.Isworker as Isworke62_203_, businesspa0_.UPC as UPC63_203_, businesspa0_.C_Salary_Category_ID as C_Salar64_203_, businesspa0_.Invoice_Printformat as Invoice65_203_, businesspa0_.Last_Days as Last_Da66_203_, businesspa0_.PO_Bankaccount_ID as PO_Bank67_203_, businesspa0_.PO_BP_TaxCategory_ID as PO_BP_T68_203_, businesspa0_.PO_Fixmonthday as PO_Fixm69_203_, businesspa0_.PO_Fixmonthday2 as PO_Fixm70_203_, businesspa0_.PO_Fixmonthday3 as PO_Fixm71_203_, businesspa0_.SO_Bankaccount_ID as SO_Bank72_203_, businesspa0_.SO_Bp_Taxcategory_ID as SO_Bp_T73_203_, businesspa0_.Fiscalcode as Fiscalc74_203_, businesspa0_.Isofiscalcode as Isofisc75_203_, businesspa0_.EM_Einv_Einvoice as EM_Einv76_203_, businesspa0_.PO_C_Incoterms_ID as PO_C_In77_203_, businesspa0_.EM_Einv_Format_Id as EM_Einv78_203_, businesspa0_.SO_C_Incoterms_ID as SO_C_In79_203_, businesspa0_.EM_Einv_Platform_Id as EM_Einv80_203_, businesspa0_.FIN_Paymentmethod_ID as FIN_Pay81_203_, businesspa0_.EM_Einv_Email as EM_Einv82_203_, businesspa0_.PO_Paymentmethod_ID as PO_Paym83_203_, businesspa0_.FIN_Financial_Account_ID as FIN_Fin84_203_, businesspa0_.EM_Einv_Deliverymode as EM_Einv85_203_, businesspa0_.PO_Financial_Account_ID as PO_Fina86_203_, businesspa0_.Customer_Blocking as Custome87_203_, businesspa0_.Vendor_Blocking as Vendor_88_203_, businesspa0_.SO_Payment_Blocking as SO_Paym89_203_, businesspa0_.PO_Payment_Blocking as PO_Paym90_203_, businesspa0_.SO_Invoice_Blocking as SO_Invo91_203_, businesspa0_.PO_Invoice_Blocking as PO_Invo92_203_, businesspa0_.SO_Order_Blocking as SO_Orde93_203_, businesspa0_.PO_Order_Blocking as PO_Orde94_203_, businesspa0_.SO_Goods_Blocking as SO_Good95_203_, businesspa0_.PO_Goods_Blocking as PO_Good96_203_, businesspa0_.Iscashvat as Iscashv97_203_, businesspa0_.EM_Advcrm_Newactivity as EM_Advc98_203_, businesspa0_.Update_Currency as Update_99_203_, businesspa0_.BP_Currency_ID as BP_Cur100_203_, businesspa0_.Birthplace as Birthp101_203_, businesspa0_.Birthday as Birthd102_203_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgp103_203_, businesspa0_.Is_Customer_Consent as Is_Cus104_203_, businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL as EM_OBS105_203_, businesspa0_.EM_Obsepad_Mandate_Identifier as EM_Obs106_203_, businesspa0_.EM_Obsmail_Language as EM_Obs107_203_, businesspa0_.EM_Obsepad_Mandate_Date as EM_Obs108_203_, businesspa0_.EM_Aeatsii_Rep_Taxid as EM_Aea109_203_, businesspa0_.EM_Aeatsii_Menor as EM_Aea110_203_, businesspa0_.EM_Pricm_Isintercompany as EM_Pri111_203_, businesspa0_.EM_Psat_Billtobpartner_ID as EM_Psa112_203_, businesspa0_.EM_Psat_Locator_ID as EM_Psa113_203_, businesspa0_.EM_Psat_Mobile_Request as EM_Psa114_203_, businesspa0_.EM_Prges_Glitem_ID as EM_Prg115_203_, businesspa0_.EM_Rrhh_Exemployee as EM_Rrh116_203_, businesspa0_.EM_Rrhh_Candidate as EM_Rrh117_203_, businesspa0_.EM_Prpass_No_Print_Pass as EM_Prp118_203_, businesspa0_.EM_Rrhh_Holidays_Supervisor as EM_Rrh119_203_, businesspa0_.EM_Cactal_Emp_No as EM_Cac120_203_, businesspa0_.EM_Cactal_Emp_Relationship_No as EM_Cac121_203_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as EM_Obw122_203_, businesspa0_.EM_Pruti_Addbp as EM_Pru123_203_, businesspa0_.EM_Prpass_Generatepassemployee as EM_Prp124_203_, businesspa0_.EM_Rrhh_Mainworkstation_ID as EM_Rrh125_203_, businesspa0_.EM_Rrhh_Bp_Transfer_Code as EM_Rrh126_203_, businesspa0_.EM_OBTIK_Tax_ID_Key as EM_OBT127_203_ from C_BPartner businesspa0_ where (upper((businesspa0_.Value||$4||businesspa0_.Name||$5||coalesce(to_char(businesspa0_.TaxID), $6)||$7||coalesce(to_char(businesspa0_.Name2), $8))) like upper($1) escape $9) and (exists (select $10 from C_Order order1_ inner join C_BPartner businesspa2_ on order1_.C_BPartner_ID=businesspa2_.C_BPartner_ID cross join C_DocType documentty3_ where order1_.C_DocTypeTarget_ID=documentty3_.C_DocType_ID and order1_.IsSOTrx=$11 and documentty3_.IsReturn=$12 and (order1_.Updated>$2 or order1_.Processed=$13) and businesspa2_.C_BPartner_ID=businesspa0_.C_BPartner_ID and (order1_.AD_Org_ID in ($14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 , $37 , $38 , $39 , $40 , $41 , $42 , $43 , $44 , $45 , $46 , $47 , $48 , $49 , $50 , $51)) and (order1_.AD_Client_ID in ($52 , $53)))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit $3
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
1838b6bc4evacuum analyze AD_Alert
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
6f6f25cdd3insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
ff35139986SELECT * FROM C_Order_Post($1)
b509362d49insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
0cb9051ec1insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
d39b22263finsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
81212fd9dcinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
842e889b6einsert 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)
296d3e9f8bvacuum analyze AD_Process_Request
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'
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
b57c313cf3vacuum analyze AD_Session
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
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
a2199342efinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
1072260572insert 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)
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
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)

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
openbravopg_defaultpublicc_order2106 GB277151306775378322654009135447598
c_order(TOAST)
openbravopg_defaultpg_temp_13ad_context_info319 GB708517076370762
openbravopg_defaultpublicprpass_timeslots_res197 GB769303783674622531618851098769
prpass_timeslots_res(TOAST)
openbravopg_defaultpublicad_audit_trail47 GB90894745863497
ad_audit_trail(TOAST)
openbravopg_defaultpublicprpass_pass_trans45 GB91107355310979083237217
openbravopg_defaultpublicprpass_pass_inst37 GB61128878229623792479741564472503951
prpass_pass_inst(TOAST)
openbravopg_defaultpublicc_bpartner21 GB199321139278056950675066
c_bpartner(TOAST)
openbravopg_defaultpublicm_product17 GB1764415909979848212423
m_product(TOAST)
openbravopg_defaultpublicc_orderline17 GB26684771212560725885392248539522
c_orderline(TOAST)
openbravopg_defaultpublicm_transaction13 GB117238333341431609234069988
m_transaction(TOAST)
openbravopg_defaultpublicm_storage_detail11 GB4071506405107642787050049443
m_storage_detail(TOAST)
openbravopg_defaultpg_catalogpg_class10057 MB7356127367811726823452290234722900
openbravopg_defaultpublicm_productionline7867 MB1467131319316396109032172520715
m_productionline(TOAST)
openbravopg_defaultpublicc_invoiceline7428 MB15646436752369919812018801648
c_invoiceline(TOAST)
openbravopg_defaultpublicc_invoice7098 MB15217604470321940385810689415977
c_invoice(TOAST)
openbravopg_defaultpublicm_inoutline5979 MB15646040955368688828518801742
m_inoutline(TOAST)
openbravopg_defaultprofilelast_stat_database5182 MB132649921849292
openbravopg_defaultpublicm_inout4172 MB15533775555344573391393165300
m_inout(TOAST)243813517
openbravopg_defaultpublicfin_finacc_transaction3425 MB1531739123428983013144492772
fin_finacc_transaction(TOAST)
openbravopg_defaultpg_temp_9ad_context_info2801 MB940690119010

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicc_order74334740416.95697181241.59
openbravopg_defaultpublicfin_finacc_transaction65548080414.9576150160.17
openbravopg_defaultpublicprpass_timeslots_res51180291511.6793021560.21
openbravopg_defaultpublicc_orderline897049282.053725606468.50
openbravopg_defaultpublicc_invoice706357111.612329103015.31
openbravopg_defaultpublicm_inoutline559041181.282267373235.17
openbravopg_defaultpublicc_invoiceline533070721.222267748415.17
openbravopg_defaultpublicm_inout561921251.282221325225.0751260.00594840.00
openbravopg_defaultpublicprpass_pass_inst1677118263.83601521471.37
openbravopg_defaultpublicm_costing936545522.1448049800.11
openbravopg_defaultpublicprpass_pass_trans60687070.14461782541.05
openbravopg_defaultpublicm_productionline105879680.24152527240.35
openbravopg_defaultpublicm_productionplan52476860.12199340700.45
openbravopg_defaultpublicad_treenode8118150.02221082220.50
openbravopg_defaultpg_temp_13ad_context_info210937890.48
openbravopg_defaultpublicm_product102317590.2385846560.20
openbravopg_defaultpublicm_transaction38937120.09122256770.28
openbravopg_defaultpublicm_storage_detail37667550.0952204250.12
openbravopg_defaultpublicfin_payment_schedule72891720.1713065520.03
openbravopg_defaultpublicad_audit_trail62447450.14641220.00

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
openbravopg_defaultpublicc_order11349523777.157633460.5285.95
openbravopg_defaultpublicprpass_pass_inst29612852.013699560.2598.54
openbravopg_defaultpublicc_invoice21299221.457300120.5099.06
openbravopg_defaultpublicc_orderline20524931.402621340.1899.50
openbravopg_defaultpublicm_productionline19496081.331156640.0892.01
openbravopg_defaultpublicm_transaction18160241.231800580.1287.62
openbravopg_defaultpublicprpass_pass_trans13249290.901240610.0897.23
openbravopg_defaultpublicc_invoiceline10374970.711288800.0999.58
openbravopg_defaultpublicm_inoutline9094010.62677650.0599.65
openbravopg_defaultpublicfin_payment_schedule8881230.60741560.0588.81
openbravopg_defaultpublicobmobc_logclient3464810.244068540.281060.00600.0073.28
openbravopg_defaultpublicm_productionplan5543040.381302980.0997.28
openbravopg_defaultpublicad_image2100.00290.006488000.44129560.016.03
openbravopg_defaultpublicm_inout6151990.42258530.0233810.008520.0099.77
openbravopg_defaultpublicfin_finacc_transaction585960.042298700.1699.96
openbravopg_defaultpublicm_costing1670200.11577520.0499.77
openbravopg_defaultpublicc_import_entry_archive155290.0184470.011540850.10185520.0186.99
openbravopg_defaultpublicfact_acct28200.001039740.0794.79
openbravopg_defaultpublicm_production677480.05156680.0194.86
openbravopg_defaultpublicad_audit_trail692000.0557540.0098.81

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
openbravopg_defaultpublicobmobc_logclient69739171422126021914332750
obmobc_logclient(TOAST)23277124
openbravopg_defaultprofilelast_stat_indexes710471640710471184113675243452427922
openbravopg_defaultpg_temp_13ad_context_info70763707627085170850
openbravopg_defaultpublicad_session_usage_audit1004115339214579831128115339
ad_session_usage_audit(TOAST)
openbravopg_defaultpublicc_invoice385810689415977170320035217604470321940
c_invoice(TOAST)
openbravopg_defaultprofilelast_stat_tables414673679414634518466344085714144333
openbravopg_defaultpublicm_stock_aux19349459071934934620351898200546
m_stock_aux(TOAST)
openbravopg_defaultpublicm_storage_detail870500494434072088267615064051076427
m_storage_detail(TOAST)
openbravopg_defaultpublicc_import_entry110331103311081132026661366294247701
c_import_entry(TOAST)17837178372434788725
openbravopg_defaultpublicad_ep_instance_para291592915948599224727
ad_ep_instance_para(TOAST)
openbravopg_defaultpublicc_import_entry_archive35435791195397125685791
c_import_entry_archive(TOAST)1483431077100126526102
openbravopg_defaultpublicm_transaction16092340699881306303731723833334143
m_transaction(TOAST)
openbravopg_defaultpg_catalogpg_statistic285692745911525011042793
pg_statistic(TOAST)54955485124696247565
openbravopg_defaultpublicm_productionline109032172520715120086259467131319316396
m_productionline(TOAST)
openbravopg_defaultpublicc_orderline8539224853952222879857566847712125607258
c_orderline(TOAST)
openbravopg_defaultpublicprpass_pass_inst797415644725039516416541111288782296237924
prpass_pass_inst(TOAST)
openbravopg_defaultprofilelast_stat_user_functions1244316381244388391373290
last_stat_user_functions(TOAST)
openbravopg_defaultpublicfact_acct1871452383075334060
fact_acct(TOAST)
openbravopg_defaultpg_catalogpg_class345229023472290073562469475512736781172682
openbravopg_defaultpublicprsync_entry486682081428880
prsync_entry(TOAST)4136187981418798

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
openbravopg_defaultpublicobmobc_logclient17142222
obmobc_logclient(TOAST)322
openbravopg_defaultpublicad_session_usage_audit1153391
ad_session_usage_audit(TOAST)
openbravopg_defaultpublicc_invoice10689415977
c_invoice(TOAST)
openbravopg_defaultprofilelast_stat_indexes16401710471564623
openbravopg_defaultpg_temp_13ad_context_info70762
openbravopg_defaultpublicm_storage_detail7050049443313
m_storage_detail(TOAST)
openbravopg_defaultpublicm_stock_aux459073462019349127217
m_stock_aux(TOAST)
openbravopg_defaultprofilelast_stat_tables367945414631564623
openbravopg_defaultpublicc_import_entry1103311081125215
c_import_entry(TOAST)1783728
openbravopg_defaultpublicc_import_entry_archive579122
c_import_entry_archive(TOAST)310772
openbravopg_defaultpublicm_transaction34069988
m_transaction(TOAST)
openbravopg_defaultpg_catalogpg_statistic28569274591
pg_statistic(TOAST)548510
openbravopg_defaultpublicad_ep_instance_para29159452651
ad_ep_instance_para(TOAST)
openbravopg_defaultpg_catalogpg_class2290222900347622
openbravopg_defaultpublicprpass_pass_inst15644395172501
prpass_pass_inst(TOAST)
openbravopg_defaultpublicc_orderline2248595223
c_orderline(TOAST)
openbravopg_defaultpublicm_productionline2172520715
m_productionline(TOAST)
openbravopg_defaultpublicfin_payment189497645
fin_payment(TOAST)
openbravopg_defaultpublicprsync_entry886622
prsync_entry(TOAST)187982
openbravopg_defaultpublicm_stock_proposed1582822
m_stock_proposed(TOAST)2

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
openbravopg_defaultpublicm_productionline7879 MB12 MB109032172520715
m_productionline(TOAST)
openbravopg_defaultpublicc_orderline8695 MB12 MB85392248539522
c_orderline(TOAST)
openbravopg_defaultpublicc_order7790 MB12 MB4009135447598
c_order(TOAST)
openbravopg_defaultpublicc_invoiceline7433 MB5064 kB812018801648
c_invoiceline(TOAST)
openbravopg_defaultpublicm_inoutline5983 MB4200 kB828518801742
m_inoutline(TOAST)
openbravopg_defaultpublicm_inout4176 MB3952 kB391393165300
m_inout(TOAST)30 MB
openbravopg_defaultpublicprpass_pass_inst_hist5789 MB3592 kB7250
prpass_pass_inst_hist(TOAST)
openbravopg_defaultpublicprpass_pass_trans_hist4819 MB2520 kB7217
openbravopg_defaultpublicfin_finacc_transaction3427 MB2464 kB3013144492772
fin_finacc_transaction(TOAST)
openbravopg_defaultpublicm_productionplan1242 MB912 kB1892
m_productionplan(TOAST)
openbravopg_defaultpublicprpass_timeslots_res262 MB816 kB18851098769
prpass_timeslots_res(TOAST)
openbravopg_defaultpublicc_import_entry400 kB-48 kB110331103311081
c_import_entry(TOAST)472 kB448 kB1783717837
openbravopg_defaultpg_temp_17ad_context_info40 kB40 kB294293
openbravopg_defaultpg_catalogpg_statistic7064 kB24 kB2856927459
pg_statistic(TOAST)7288 kB54955485
openbravopg_defaultpublicad_ep_instance_para32 kB8192 bytes2915929159
ad_ep_instance_para(TOAST)
openbravopg_defaultpublicm_product10 MB8192 bytes2423
m_product(TOAST)
openbravopg_defaultpg_temp_12ad_context_info8192 bytes8192 bytes9563
openbravopg_defaultpg_temp_6ad_context_info8192 bytes8192 bytes65
openbravopg_defaultpg_temp_5ad_context_info8192 bytes8192 bytes199167

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
openbravopg_defaultpublicm_inoutlinem_inoutline_orderline563314182261172385.16
openbravopg_defaultpublicc_invoicelinec_invoiceline_orderline562987452259663275.15
openbravopg_defaultpublicm_inoutm_inout_key551483132210432015.04
openbravopg_defaultpublicc_invoicec_invoice_key521660542095409504.78
openbravopg_defaultpublicc_orderlineem_obpos_orderedqty504415372032378984.64
openbravopg_defaultpublicc_orderlinec_orderline_product45039721209171082.76
openbravopg_defaultpublicc_orderc_order_key15078935599735791.37
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_orderline11234515486014981.11
openbravopg_defaultpublicc_orderlinec_orderline_key11899836476361411.09
openbravopg_defaultpublicprpass_pass_transprpass_pass_trans_inst11073517460828401.05
openbravopg_defaultpublicad_treenodead_treenode_tree_node_un805779220319850.50
openbravopg_defaultpublicc_invoicec_invoice_client_org_date_doc138168012270.38
openbravopg_defaultpublicm_productionplanm_productionplan_key3882069155612720.35
openbravopg_defaultpublicm_productionlinem_productionline_prodplan246434699392560.23
openbravopg_defaultpublicm_productm_product_key414849383589640.19
openbravopg_defaultpublicm_transactionm_transaction_calculated853476514210.17
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_value415470929730.16
openbravopg_defaultpublicc_orderc_order_client_org_date_docno657765868100.15
openbravopg_defaultpublicfin_finacc_transactionfin_finacc_tr_account_line1361652136030.12
openbravopg_defaultpublicm_costingm_costing_product_date3287947568380.11

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
openbravopg_defaultpublicc_invoicec_invoice_client_org_date_doc1385816710.4096.54
openbravopg_defaultpublicc_orderc_order_client_org_date_docno65775027170.3492.37
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_value41542345770.1696.69
openbravopg_defaultpublicfin_finacc_transactionfin_finacc_tr_account_line136162165370.1595.85
openbravopg_defaultpublicc_orderlinec_orderline_key118998362001810.1499.58
openbravopg_defaultpublicc_orderc_order_documentno_id12501305810.0968.36
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_pk1154130.0866.05
openbravopg_defaultpublicprpass_pass_transprpass_pass_trans_inst110735171121800.0899.76
openbravopg_defaultpublicm_productionplanm_productionplan_key38820691050030.0799.33
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_context995330.0718.37
openbravopg_defaultpublicc_orderc_order_key15078935953700.0699.84
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_timestamp754690.0555.19
openbravopg_defaultpublicm_productionlinem_productionline_prodplan2464346694690.0599.30
openbravopg_defaultpublicprpass_pass_instprpass_pass_inst_orderline11234515636940.0499.87
openbravopg_defaultpublicm_transactionm_transsaction_product4396632540.0490.56
openbravopg_defaultpublicc_invoicec_invoice_order603340.0478.35
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_cache545470.0452.72
openbravopg_defaultpublicc_invoicelinec_invoiceline_invoice79321538600.0483.32
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_term_date4519320.0475.51
openbravopg_defaultpublicm_costingm_costing_product_date32879503350.0398.94

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
openbravopg_defaultpublicc_orderlineem_obpos_orderedqty917 MB3232 kB8539129633
openbravopg_defaultpublicc_invoicec_invoice_client_org_date_doc949 MB2904 kB385890917
openbravopg_defaultpublicm_productionlinem_productionline_prodplan1167 MB2160 kB10448967
openbravopg_defaultpublicc_invoicec_invoice_key410 MB1608 kB385890917
openbravopg_defaultpublicc_orderlinec_orderline_product861 MB1344 kB8539129633
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_ord_ix702 MB592 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_ol_ix702 MB568 kB7250
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_key1036 MB560 kB7217
openbravopg_defaultpublicm_inoutm_inout_key402 MB544 kB39134016
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_key915 MB520 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_part_ix702 MB512 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_prd_ix702 MB488 kB7250
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_vlo_ix796 MB488 kB7217
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_pos_ix589 MB328 kB7217
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_pos_ix603 MB304 kB7250
openbravopg_defaultpublicprpass_timeslots_resprpass_timeslots_res_key71 MB216 kB1050611435
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_sta_ix267 MB208 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_unl_ix267 MB208 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_val_ix482 MB152 kB7250
openbravopg_defaultpublicm_requisitionlinem_requisitionln_requisit_idx30 MB128 kB1553

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_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_ord_ix702 MB592 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_ol_ix702 MB568 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_part_ix702 MB512 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_pos_ix603 MB304 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_prd_ix702 MB488 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_sta_ix267 MB208 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_unl_ix267 MB208 kB7250
openbravopg_defaultpublicprpass_pass_inst_histprpass_pass_inst_hist_val_ix482 MB152 kB7250
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_ins_ix795 MB7217
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_pos_ix589 MB328 kB7217
openbravopg_defaultpublicprpass_pass_trans_histprpass_pass_trans_hist_vlo_ix796 MB488 kB7217
openbravopg_defaultpublicm_requisitionlineem_cactl_reqln_prod_idx30 MB56 kB1174

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopubliccactl_calculate_consumption34391247.621247.390.3630.363
openbravopublicc_order_post1088111.900.030.1030.000
openbravopublicc_order_post11088111.870.020.1030.000
openbravopublicc_order_post11088111.8510.330.1030.009
openbravopublicpricm_createproductprice371561.0729.070.0160.008
openbravopublicc_invoice_create107149.906.890.0470.006
openbravopublicto_char2912727749.6849.680.0000.000
openbravoprofiletake_sample2345.710.011.9870.001
openbravoprofiletake_sample_subset2345.690.041.9870.002
openbravoprofiletake_sample2345.654.151.9850.180
openbravopublicto_char2912689340.4940.490.0000.000
openbravopublicto_date1351698934.0734.070.0000.000
openbravopublicc_invoice_post107134.0511.300.0320.011
openbravoprofiledblink62134.0434.040.0550.055
openbravopublicad_extension_point_handler647530.902.660.0050.000
openbravopublicm_inout_create107129.370.030.0270.000
openbravopublicm_inout_create107129.347.140.0270.007
openbravoprofilecollect_pg_stat_statements_stats2222.990.361.0450.017
openbravopublicm_inout_post108318.9310.100.0170.009
openbravopublicm_get_stock_param896016.1815.950.0020.002

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicto_char2912727749.6849.680.0000.000
openbravopublicto_char2912689340.4940.490.0000.000
openbravopublicto_date1351698934.0734.070.0000.000
openbravopublicto_char69236103.703.700.0000.000
openbravopublicsubstract_days32361142.522.520.0000.000
openbravopublicto_char27830921.541.540.0000.000
openbravopublicto_number27509684.544.540.0000.000
openbravopublicad_istriggerenabled162172610.5610.560.0000.000
openbravopublicadd_days12073181.551.550.0000.000
openbravopublicto_date7893931.701.690.0000.000
openbravopublicuuid_generate_v44711651.631.630.0000.000
openbravopublicsubstract_days1787110.210.210.0000.000
openbravopublicget_uuid1570553.021.390.0000.000
openbravopublictrunc1454410.330.330.0000.000
openbravopublicad_isorgincluded1346852.172.170.0000.000
openbravopublictrunc1139810.240.240.0000.000
openbravopublicround725700.130.130.0000.000
openbravopublicm_update_inventory7004915.2513.290.0000.000
openbravopublicm_update_stockaux6483010.7810.030.0000.000
openbravopublicadd_days581130.080.080.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
openbravopublicpricm_productprice390561.290.100.0160.000
openbravopublicm_productionline_trg3262824.694.570.0010.000
openbravopubliccactl_m_prodline_losses_trg1090314.763.260.0010.000
openbravopubliccactl_product_org3262810.961.700.0000.000
openbravopublicm_transaction_trg501619.965.360.0000.000
openbravopublicc_orderline_trg2310277.652.390.0000.000
openbravopublicau_c_order_trg175556.846.590.0000.000
openbravopublicc_invoiceline_trg2100005.802.160.0010.000
openbravopublicc_invoice_trg1136044.033.310.0000.000
openbravopublicaeatsii_invoice_trg1136043.931.880.0000.000
openbravopublicc_orderline2_trg310273.042.860.0000.000
openbravopublicc_invoice_trg21107522.551.450.0000.000
openbravopublicc_orderlinetax_trg94151.731.420.0000.000
openbravopublicc_invoicelinetax_trg90091.711.130.0000.000
openbravopublicc_orderline_trg310271.701.500.0000.000
openbravopublicm_storage_detail_trg700491.541.150.0000.000
openbravopublicpriuti_c_invoice_ref_trg1107521.520.900.0000.000
openbravopublicpricm_skipped_transaction_trg158171.471.410.0000.000
openbravopublicc_ordline_chk_restrictions_trg310271.461.360.0000.000
openbravopublicintr_c_orderline_trg310241.450.560.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
openbravopg_defaultpublicad_ep_instance_para4522915929159
openbravopg_defaultprofilelast_stat_tables1564146736794146345
openbravopg_defaultprofilelast_stat_indexes156710471640710471
openbravopg_defaultprofilelast_stat_user_functions1561244316381244388
openbravopg_defaultpublicm_stock_aux12719349459071934934620
openbravopg_defaultpublicc_import_entry125110331103311081
openbravopg_defaultpublicobre_reservation4941726174188
openbravopg_defaultpublicobpos_applications4458825882
openbravopg_defaultpublicfin_financial_account3428742874
openbravopg_defaultpublicobre_resource1429122912
openbravopg_defaultpublicad_sequence91200311872
openbravopg_defaultpublicm_transaction_last7115213
openbravopg_defaultpg_catalogpg_class63452290234722900
openbravopg_defaultpublicm_storage_detail387050049443
openbravopg_defaultpublicad_alert225293
openbravopg_defaultpublicad_pinstance21062123529200
openbravopg_defaultpublicad_process_request27498388480
openbravopg_defaultpublicad_process_run23953953592
openbravopg_defaultpublicc_import_entry_archive235435791
openbravopg_defaultpublicm_stock_proposed210815828

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
openbravopg_defaultpublicad_ep_instance_para6512915929159
openbravopg_defaultpublicm_stock_aux21719349459071934934620
openbravopg_defaultpublicc_import_entry215110331103311081
openbravopg_defaultpublicad_sequence1201200311872
openbravopg_defaultpublicobpos_applications9258825882
openbravopg_defaultprofilelast_stat_tables46234146736794146345
openbravopg_defaultprofilelast_stat_indexes4623710471640710471
openbravopg_defaultprofilelast_stat_user_functions46231244316381244388
openbravopg_defaultpublicobre_reservation5841726174188
openbravopg_defaultpublicfin_financial_account4428742874
openbravopg_defaultpublicobre_resource3029122912
openbravopg_defaultpg_catalogpg_class223452290234722900
openbravopg_defaultprofilelast_stat_tablespaces214444
openbravopg_defaultpublicm_storage_detail1387050049443
openbravopg_defaultpublicm_transaction_last11115213
openbravopg_defaultpublicc_bpartner750675066
openbravopg_defaultpublicad_process_request247498388480
openbravopg_defaultpg_catalogpg_type4232228
openbravopg_defaultpublicad_session13478371128762
openbravopg_defaultpublicad_pinstance211062123529200

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_timestamp587 MB2294 MB1412 MB
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_pk485 MB2242 MB1412 MB
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_cache422 MB2211 MB1412 MB
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_term_date406 MB2203 MB1412 MB
openbravopg_defaultpublicobmobc_logclientobmobc_logclient_context378 MB2189 MB1412 MB
openbravopg_defaultpublicm_stock_auxm_stock_aux_aux_id324 MB1272616 kB4400 kB
openbravopg_defaultpublicc_import_entryem_prres_organization_idx168 MB1241384 kB1056 kB
openbravopg_defaultpublicad_ep_instance_paraad_ep_instance_para_key152 MB452344 kB28 kB
openbravopg_defaultpublicc_import_entryc_import_entry_key115 MB124952 kB1056 kB
openbravopg_defaultpublicc_import_entryem_prres_typeofdata_idx109 MB124904 kB1056 kB
openbravopg_defaultpublicc_import_entryc_import_entry_type_status104 MB124856 kB1056 kB
openbravopg_defaultpublicc_import_entryem_obpos_application_fk95 MB124784 kB1056 kB
openbravopg_defaultpublicm_stock_auxm_stock_aux_storage_detail_id87 MB122728 kB4400 kB
openbravopg_defaultprofilelast_stat_indexespk_last_stat_indexes82 MB152552 kB2040 kB
openbravopg_defaultpublicm_stock_auxm_stock_aux_key73 MB122616 kB4400 kB
openbravopg_defaultpublicc_import_entryc_import_entry_idx72 MB109680 kB1080 kB
openbravopg_defaultpublicm_storage_detailm_storage_detail_un60 MB320 MB29 MB
openbravopg_defaultpublicm_storage_detailm_storage_detail_uom45 MB315 MB29 MB
openbravopg_defaultprofilelast_stat_tablespk_last_stat_tables43 MB148296 kB1540 kB
openbravopg_defaultpublicm_storage_detailm_storage_detail_locator42 MB314 MB29 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_res721081138575162026-04-30 12:07:18.698105+01262 MB
openbravoprofilesample_stat_tables272065237162026-07-17 17:00:47.297023+018672 kB
openbravopg_catalogpg_statistic107641795142026-07-18 13:44:48.950217+017064 kB
openbravopublicc_invoice70344341062737132026-07-08 00:23:08.546646+017098 MB
openbravopg_catalogpg_attribute372355500122026-07-17 16:18:46.858639+016840 kB
openbravopg_toastpg_toast_26192483358122026-07-18 22:38:10.984245+017288 kB
openbravopg_toastpg_toast_232469135171930122026-05-19 02:38:47.391039+0130 MB
openbravopublicm_requisitionline31861141393112026-07-06 12:22:50.3815+01184 MB
openbravopublicm_product156881806102026-02-20 19:44:18.669967+0010 MB
openbravopublicfin_finacc_transaction661319369782792026-04-02 14:41:49.577329+013427 MB
openbravopublicc_order729149468614887790 MB
openbravopublicc_orderline1442766878521758695 MB
openbravopublicprpass_pass_inst6733154208952026-07-16 21:52:27.999093+016280 MB
openbravopublicm_inout726511425913132025-10-20 23:54:32.431835+014176 MB
openbravopublicprpass_pass_trans5539651566322026-07-16 21:39:42.083421+015152 MB
openbravopublicm_productionline2009903022147917879 MB
openbravopg_toastpg_toast_2278562016102026-06-29 05:14:25.739162+016104 kB
openbravopublicad_process_run1991915002026-06-01 11:38:18.108022+0122 MB
openbravopublicc_invoiceline142641265034807433 MB
openbravopublicm_inoutline142672132951805983 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_statistic1076417959829296782647064 kB
openbravopublicm_productionline20099030221479182987592026-04-18 16:29:40.193815+017879 MB
openbravopg_catalogpg_attribute372355500342082026-07-18 14:48:49.041364+016840 kB
openbravopublicm_product156881806124572026-07-13 10:43:57.196489+0110 MB
openbravopublicprpass_pass_inst_hist12372968097578072026-07-16 19:56:26.433478+015789 MB
openbravopublicfin_finacc_transaction661319369782738536152026-06-27 12:53:00.341557+013427 MB
openbravopublicc_order729149468614843833652026-06-29 09:41:55.68684+017790 MB
openbravopublicprpass_pass_trans553965156633385252026-07-16 21:03:29.20469+015152 MB
openbravoprofilesample_stat_tables272065237168052026-07-18 21:00:10.229722+018672 kB
openbravopublicprpass_pass_trans_hist13998482077954752026-07-16 20:00:37.093696+014819 MB
openbravopublicc_invoice7034434106273734364842026-07-16 12:28:46.256497+017098 MB
openbravopublicc_invoiceline142641265034861816342026-02-28 09:04:55.209925+007433 MB
openbravopublicm_inoutline142672132951859232042026-03-06 11:59:32.517041+005983 MB
openbravopublicm_requisitionline318611413931797342026-07-16 12:22:03.316362+01184 MB
openbravopublicc_orderline1442766878521747067632026-07-06 00:03:35.926283+018695 MB
openbravopublicm_productionplan345518610110566632026-02-28 13:31:59.297829+001242 MB
openbravopublicprpass_pass_inst673315420892489332026-07-18 11:00:16.903044+016280 MB
openbravopublicad_process_run1991915029812026-07-18 21:40:11.641015+0122 MB
openbravopublicm_inout726511425913111388012026-07-11 14:36:35.462074+014176 MB
openbravopublicprpass_timeslots_res7210811385751003312026-07-16 20:03:13.270013+01262 MB

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