Postgres profile report (StartID: 474, EndID: 497)

pg_profile version 0.3.6

Server name: local

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

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

Report sections

Server statistics

Database statistics

DatabaseTransactionsBlock statisticsTuplesTemp filesSizeGrowth
CommitsRollbacksDeadlocksHit(%)ReadHitRetFetInsUpdDelSizeFiles
etendo2184884590.8116797878166033758390688581248703616757413257464334062851 MB-224 kB
postgres1186999.8411597029481985156365388201286617726375 kB
Total2303574590.8516799037166736706392673737252357496777533266124351782858 MB-224 kB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
etendo4065348780.3541.7574992075117812550233840406216287851279422128
postgres562012.74127212228350
template163468.9347962235278
Total4077314802.0241.7575167249117812550234303406216287851279422756

Cluster statistics

MetricValue
Scheduled checkpoints275
Requested checkpoints1
Checkpoint write time (s)10744.75
Checkpoint sync time (s)3.06
Checkpoints buffers written129473
Background buffers written
Backend buffers written142839
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated507914
WAL generated3782 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default2871 MB-208 kB
pg_global542 kB

SQL query statistics

Top SQL by execution time

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

adb1c31f79

[948be82f]

etendo150.7618.80150755.530150755.530150755.5301

73e3636bec

[f410d7e7]

etendo69.748.702874880.2430.1309.6030.080287488

e4360f260c

[88d6e75c]

etendo68.418.53125700.9820.19368408.50718907.03012

7ed479c7e5

[1b1541f8]

etendo57.577.181260400.4570.00211.1020.576126041

12e95683ca

[bf906a1d]

etendo54.036.74125324.3123.78116.9080.70812532

228d74fbf5

[cd9c0fd2]

etendo33.694.201343333685.68733685.68733685.6871

a12a07df32

[94db0ed9]

etendo23.982.9948391598.7215.0762528.077715.25915

44dc303aa7

[5048ce93]

etendo22.702.83175661.1250.9644.3490.23820181

aaf3c93842

[c69b6fc3]

etendo22.392.79756570.2960.0032.8570.15275658

0c133f89fa

[47df1ade]

etendo16.692.0823725.666640.3771042.66584.19823

b9bb8a4422

[eb812a48]

etendo16.692.08725.467640.1881042.45384.18123

66c3814b4e

[aa6f0851]

etendo12.751.59503590.2530.0033.3130.13150360

4108c96b3f

[ca2988bd]

etendo9.501.181027133.829119.413210.31213.43171

671fe12038

[66c83919]

etendo8.481.0618972668480.9138480.9138480.9131

9c83facac5

[411377d4]

etendo7.060.88201810.3600.3132.1410.07619599

6f5312535e

[75b8a9cd]

etendo6.800.85924550.0730.0680.8890.02292455

503324b603

[d34207c3]

etendo6.190.772535520.0210.0051.6290.011288451

f38aca3f97

[f51b4fb0]

etendo5.260.66251400.2090.0072.8740.11925140

0b651ca53d

[7318d810]

etendo5.190.656743515188.0455188.0455188.0451

1d911b5cd9

[1c4d8fed]

etendo5.140.6413723.7431.72014.8731.4971372

Top SQL by executions

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

9625146448

[b7edb1a4]

etendo2889107.092889100.0100.0071.2600.0052.9

0c13a0abe2

[4ed26d58]

etendo2885457.08306020.0110.0061.0280.0063.0

503324b603

[d34207c3]

etendo2884517.072535520.0210.0051.6290.0116.2

73e3636bec

[f410d7e7]

etendo2874887.052874880.2430.1309.6030.08069.7

1b3d7b3f6d

[a00bdbff]

etendo2758856.770.0070.0040.4730.0031.9

c9e2eb425b

[de5cc8a]

etendo2750986.752721400.0030.0020.4660.0010.8

9ea37f4950

[39cec726]

etendo2564076.292564070.0090.0072.3610.0062.4

df99961951

[9cb9259b]

etendo1628103.991628100.0180.0120.9510.0082.9

50ca7aecdc

[d43a51d5]

etendo1260643.091260640.0050.0030.9830.0050.6

7ed479c7e5

[1b1541f8]

etendo1260413.091260400.4570.00211.1020.57657.6

891e82e5c1

[5a0bb3c]

etendo1010642.481010640.0020.0020.4670.0030.3

6f5312535e

[75b8a9cd]

etendo924552.27924550.0730.0680.8890.0226.8

ee46524d09

[b7b1303a]

etendo904392.22904390.0150.0130.5140.0021.4

aaf3c93842

[c69b6fc3]

etendo756581.86756570.2960.0032.8570.15222.4

b8d861c28d

[a50eb7d7]

etendo756581.86756580.0050.0030.7950.0060.4

5c208ba241

[381eb299]

etendo534781.31534780.0140.0100.6830.0060.8

5444a9a88c

[b9a22c26]

etendo507791.25507790.0050.0020.1830.0040.2

66c3814b4e

[aa6f0851]

etendo503601.24503590.2530.0033.3130.13112.8

fa1b74d06f

[c1b84187]

etendo449131.103270790.0400.0140.7390.0381.8

ebd66f2e50

[2f2197e3]

etendo427761.05267000.0140.0060.2980.0080.6

Top SQL by shared blocks fetched

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

73e3636bec

[f410d7e7]

etendo952725612.6799.9769.7287488287488

44dc303aa7

[5048ce93]

etendo67404548.97100.0022.71756620181

0c133f89fa

[47df1ade]

etendo47925766.3899.9816.72323

b9bb8a4422

[eb812a48]

etendo47924386.3899.9816.723

adb1c31f79

[948be82f]

etendo30356094.0484.26150.81

4108c96b3f

[ca2988bd]

etendo24855163.3199.999.5102771

9c83facac5

[411377d4]

etendo23259913.0999.997.12018119599

58d3d7b94c

[303fdc1e]

etendo22852073.04100.001.2242923

f286a2747c

[4221d0a4]

etendo21785222.90100.001.93838

785a907bc3

[92946197]

etendo16337652.1799.974.763823

5fa24dc926

[22217272]

etendo16181192.15100.002.25103723

a12a07df32

[94db0ed9]

etendo16053832.14100.0024.0483915

c2b6cfc2bf

[ad3afc69]

etendo10972301.46100.002.75246001443

aa89455035

[1c366983]

etendo10828141.4499.894.4255413

29e9be51ce

[b8952a6a]

etendo10719761.43100.001.65874960

9625146448

[b7edb1a4]

etendo9002641.20100.002.9288910288910

0c13a0abe2

[4ed26d58]

etendo8981881.19100.003.030602288545

6902d69fcf

[ec8ea67e]

etendo8880581.18100.003.12626

6f5312535e

[75b8a9cd]

etendo8643511.15100.006.89245592455

503324b603

[d34207c3]

etendo8295111.10100.006.2253552288451

Top SQL by shared blocks read

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

adb1c31f79

[948be82f]

etendo47791691.9884.26150.81

f8cc1c12b0

[4f2bfd2e]

etendo32510.6398.860.9126

73e3636bec

[f410d7e7]

etendo24940.4899.9769.7287488287488

9cbca4d83c

[b7b6a128]

etendo21990.4288.920.221562156

50b8978166

[b54ea3e2]

etendo20750.4099.522.367

12a81791af

[7eea2aca]

etendo19060.3798.850.41677316773

cbb0d2e65e

[4ec9dd54]

etendo17350.3392.170.52929

aa89455035

[1c366983]

etendo12320.2499.894.4255413

0c247acdf0

[948be82f]

template19760.1997.612.71

2e0b729b87

[948be82f]

postgres9460.1897.662.91

1e7f08819e

[c94f617e]

etendo9350.1897.180.2298298

0c133f89fa

[47df1ade]

etendo9040.1799.9816.72323

b9bb8a4422

[eb812a48]

etendo9040.1799.9816.723

cc93eb92d8

[48b1758d]

etendo8770.1799.815.09999

032d1e73d2

[fe5aed7e]

etendo8770.1799.815.09999

1e43f28979

[c3f6c9c8]

etendo8490.1691.490.366

b8b9950890

[532de794]

etendo7530.1499.321.440084008

cea7aeb9ae

[274025e4]

etendo5440.1097.340.012225

968e467a3b

[a2f4e2db]

etendo5170.1099.610.41414

785a907bc3

[92946197]

etendo4940.1099.974.763823

Top SQL by shared blocks dirtied

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

73e3636bec

[f410d7e7]

etendo6865429.3099.9769.7287488287488

adb1c31f79

[948be82f]

etendo6263826.7384.26150.81

0c133f89fa

[47df1ade]

etendo158546.7799.9816.72323

b9bb8a4422

[eb812a48]

etendo158546.7799.9816.723

b8b9950890

[532de794]

etendo52232.2399.321.440084008

fdd1193fad

[3b0e4e8a]

etendo42071.8099.963.65411946

d0b36135c7

[a0544a5f]

etendo32231.3899.973.63288846

cc93eb92d8

[48b1758d]

etendo30711.3199.815.09999

032d1e73d2

[fe5aed7e]

etendo30711.3199.815.09999

9cbca4d83c

[b7b6a128]

etendo24961.0788.920.221562156

1e7f08819e

[c94f617e]

etendo23170.9997.180.2298298

cbb0d2e65e

[4ec9dd54]

etendo19780.8492.170.52929

24a71b82fd

[cbb8c03]

etendo17450.7499.852.8108108

140f3eb685

[59d1e156]

etendo16890.7299.520.92121

2f8789e4ba

[e4b84551]

etendo13940.5999.361.29292

9b16673e73

[423e83ff]

etendo12800.5598.910.11

c525c04235

[d2f1c69a]

etendo11760.5099.290.1223223

167f11efcd

[76ede534]

etendo11580.4999.320.01

1e43f28979

[c3f6c9c8]

etendo9140.3991.490.366

2f7131461f

[1538926a]

etendo8240.3598.670.45858

Top SQL by shared blocks written

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

adb1c31f79

[948be82f]

etendo5822521.3840.7684.26150.81

0c247acdf0

[948be82f]

template1550.020.0497.612.71

2e0b729b87

[948be82f]

postgres550.020.0497.662.91

Top SQL by temp usage

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

12e95683ca

[bf906a1d]

etendo137063680.17169760.741368259584.0054.01253212532

7ed479c7e5

[1b1541f8]

etendo6598353996.06109339.12260258215.9857.6126040126041

50ca7aecdc

[d43a51d5]

etendo12919699.1640.1410910.010.6126064126064

b8d861c28d

[a50eb7d7]

etendo7753699.196290.000.47565875658

5444a9a88c

[b9a22c26]

etendo5203699.194220.000.25077950779

a4a671fe58

[d357095d]

etendo1284497.573120.000.11253212532

61bc3cba28

[ee759ab3]

etendo2617299.182140.000.12553925539

fda73c8819

[11e97f3b]

etendo110.000.011

612b800127

[307229c6]

etendo3697.2210.000.03636

a6bd2516ad

[801537c6]

etendo5198.0410.000.05151

6e8832531a

[b349c30c]

etendo110.000.011

5c9911f091

[d43a2c87]

etendo2495.8310.000.02424

b3eeff8931

[e53a3cf3]

etendo110.000.011

Complete list of SQL texts

QueryIDQuery Text
891e82e5c1SELECT $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
24a71b82fdSELECT AD_EXTENSION_POINT_HANDLER(v_ep_instance, v_extension_point_id)
c9e2eb425bSELECT LEVELNO FROM AD_ORG_TREE WHERE AD_ORG_ID = p_orgid AND AD_PARENT_ORG_ID = p_parentorgid AND AD_CLIENT_ID = p_clientid
fda73c8819insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2f7131461finsert into C_InvoiceLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Invoice_ID, Line, Financial_Invoice_Line, M_Product_ID, QtyInvoiced, PriceList, PriceActual, PriceLimit, LineNetAmt, C_UOM_ID, C_Tax_ID, IsDescription, PriceStd, Excludeforwithholding, Iseditlinenetamt, Taxbaseamt, Line_Gross_Amount, Gross_Unit_Price, C_Bpartner_ID, grosspricestd, Grosspricelist, IsDeferred, Explode, Match_Lccosts, 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)
7ed479c7e5delete from ad_context_info
aa89455035SELECT ID, SUM(QTY) AS QTY, SUM(QTYCREDIT) AS QTYCREDIT, SUM(QTY_REF) AS QTY_REF, SUM(QTYCREDIT_REF) AS QTYCREDIT_REF FROM ( SELECT m.C_ElementValue_ID as id, (COALESCE(f.AMTACCTDR,$8) - COALESCE(f.AMTACCTCR, $9)) AS qty, (COALESCE(f.AMTACCTCR,$10) - COALESCE(f.AMTACCTDR, $11)) AS qtyCredit, $12 as qty_ref, $13 as qtyCredit_ref FROM C_ElementValue m, Fact_Acct f, C_Period p, C_Year y WHERE m.AD_Org_ID IN ($14,$15,$16,$17) AND m.AD_Client_ID IN ($18,$19) AND $20=$21 AND f.DATEACCT >= to_date($1) AND f.DATEACCT < to_date($2) AND f.C_ACCTSCHEMA_ID = $3 AND f.FACTACCTTYPE <> $22 AND f.FACTACCTTYPE <> $23 AND m.C_ElementValue_ID = f.Account_ID AND $24=$25 AND f.AD_ORG_ID IN ($26) AND f.C_PERIOD_ID = p.C_PERIOD_ID AND p.C_YEAR_ID = y.C_YEAR_ID AND Y.YEAR IN ($27) and not exists (select $28 from ad_org_closing, c_year year where open_fact_acct_group_id = f.fact_acct_group_id and ad_org_closing.c_year_id = year.c_year_id and year.year <> $4) UNION ALL SELECT m.C_ElementValue_ID as id, $29 AS QTY, $30 as qtyCredit, (COALESCE(f.AMTACCTDR,$31) - COALESCE(f.AMTACCTCR, $32)) AS qty_ref, (COALESCE(f.AMTACCTCR,$33) - COALESCE(f.AMTACCTDR, $34)) AS qtyCredit_ref FROM C_ElementValue m, Fact_Acct f, C_Period p, C_Year y WHERE m.AD_Org_ID IN($35,$36,$37,$38) AND m.AD_Client_ID IN($39,$40) AND ($41=$42 OR to_char($43)=to_char($5) ) AND $44=$45 AND f.C_ACCTSCHEMA_ID = $6 AND f.FACTACCTTYPE <> $46 AND f.FACTACCTTYPE <> $47 AND m.C_ElementValue_ID = f.Account_ID AND $48=$49 AND f.AD_ORG_ID IN ($50) AND f.C_PERIOD_ID = p.C_PERIOD_ID AND p.C_YEAR_ID = y.C_YEAR_ID AND y.YEAR IN ($51) and not exists (select $52 from ad_org_closing, c_year year where open_fact_acct_group_id = f.fact_acct_group_id and ad_org_closing.c_year_id = year.c_year_id and year.year <> $7) ) AA GROUP BY ID
1d911b5cd9select adsystem0_.AD_System_ID as AD_Syste1_115_0_, adsystem0_.AD_Client_ID as AD_Clien2_115_0_, adsystem0_.AD_Org_ID as AD_Org_I3_115_0_, adsystem0_.IsActive as IsActive4_115_0_, adsystem0_.Created as Created5_115_0_, adsystem0_.CreatedBy as CreatedB6_115_0_, adsystem0_.Updated as Updated7_115_0_, adsystem0_.UpdatedBy as UpdatedB8_115_0_, adsystem0_.Name as Name9_115_0_, adsystem0_.Info as Info10_115_0_, adsystem0_.Version as Version11_115_0_, adsystem0_.ReleaseNo as Release12_115_0_, adsystem0_.TAD_Recordrange as TAD_Rec13_115_0_, adsystem0_.TAD_Recordrange_Info as TAD_Rec14_115_0_, adsystem0_.TAD_Transactionalrange as TAD_Tra15_115_0_, adsystem0_.TAD_Theme as TAD_The16_115_0_, adsystem0_.Instance_Key as Instanc17_115_0_, adsystem0_.Activation_Key as Activat18_115_0_ from AD_System adsystem0_ where adsystem0_.AD_System_ID=$1
5fa24dc926SELECT st.*,stio.idx_blks_read,stio.idx_blks_hit,CASE l.relation WHEN st.indexrelid THEN $1 ELSE pg_relation_size(st.indexrelid) END relsize,$2,pg_class.reltablespace as tablespaceid,(ix.indisunique OR con.conindid IS NOT NULL) AS indisunique,pg_class.relpages::bigint * current_setting($3)::bigint AS relpages_bytes,$4 AS relpages_bytes_diff FROM pg_catalog.pg_stat_all_indexes st JOIN pg_catalog.pg_statio_all_indexes stio USING (relid, indexrelid, schemaname, relname, indexrelname) JOIN pg_catalog.pg_index ix ON (ix.indexrelid = st.indexrelid) JOIN pg_catalog.pg_class ON (pg_class.oid = st.indexrelid) LEFT OUTER JOIN pg_catalog.pg_constraint con ON (con.conindid = ix.indexrelid AND con.contype in ($5,$6)) LEFT OUTER JOIN LATERAL (SELECT relation FROM pg_catalog.pg_locks WHERE (relation = st.indexrelid AND granted AND locktype = $7 AND mode=$8)) l ON (l.relation = st.indexrelid)
cea7aeb9aeselect orderline0_.C_OrderLine_ID as col_0_0_, orderline0_.QtyOrdered-sum(coalesce(procuremen3_.Qty, $10))-sum(coalesce(invoicelin4_.QtyInvoiced, $11)) as col_1_0_, (select uom5_.Name from C_UOM uom5_ where uom5_.C_UOM_ID=orderline0_.C_UOM_ID) as col_2_0_, (select product6_.Name from M_Product product6_ where product6_.M_Product_ID=orderline0_.M_Product_ID) as col_3_0_, orderline0_.Line as col_4_0_, $12 as col_5_0_, $13 as col_6_0_, coalesce(materialmg2_.QuantityOrder, orderline0_.QuantityOrder*(orderline0_.QtyOrdered-coalesce(orderline0_.QtyInvoiced, $14))/(case when orderline0_.QtyOrdered<>$15 then orderline0_.QtyOrdered else $16 end)) as col_7_0_, materialmg2_.M_InOutLine_ID as col_8_0_, orderline0_.DateOrdered as col_9_0_, orderline0_.Created as col_10_0_, aduser7_.Name as col_11_0_, orderline0_.Updated as col_12_0_, aduser8_.Name as col_13_0_, order1_.DatePromised as col_14_0_, (select warehouse9_.Name from M_Warehouse warehouse9_ where warehouse9_.M_Warehouse_ID=order1_.M_Warehouse_ID) as col_15_0_, order1_.DocumentNo as col_16_0_, order1_.GrandTotal as col_17_0_ from C_OrderLine orderline0_ inner join C_Order order1_ on orderline0_.C_Order_ID=order1_.C_Order_ID left outer join M_InOutLine materialmg2_ on orderline0_.M_Inoutline_ID=materialmg2_.M_InOutLine_ID left outer join M_MatchPO procuremen3_ on orderline0_.C_OrderLine_ID=procuremen3_.C_OrderLine_ID and (procuremen3_.C_InvoiceLine_ID is not null) left outer join C_InvoiceLine invoicelin4_ on orderline0_.C_OrderLine_ID=invoicelin4_.C_OrderLine_ID and (invoicelin4_.C_InvoiceLine_ID is null or invoicelin4_.C_Invoice_ID=$1) cross join AD_User aduser7_ cross join AD_User aduser8_ where orderline0_.CreatedBy=aduser7_.AD_User_ID and orderline0_.UpdatedBy=aduser8_.AD_User_ID and (order1_.AD_Client_ID in ($17 , $2)) and (orderline0_.AD_Org_ID in ($3 , $4)) and order1_.DateOrdered>=now()-$18 and order1_.IsSOTrx=$5 and order1_.IsTaxIncluded=$6 and order1_.C_Currency_ID=$7 and order1_.C_BPartner_ID=$8 and (order1_.DocStatus in ($19 , $20)) and order1_.InvoiceRule<>$21 group by orderline0_.QtyOrdered , orderline0_.DateOrdered , orderline0_.Line , orderline0_.C_OrderLine_ID , orderline0_.Created , aduser7_.Name , orderline0_.Updated , aduser8_.Name , orderline0_.Explode , orderline0_.Aumqty , orderline0_.C_UOM_ID , orderline0_.M_Product_ID , orderline0_.C_Aum , materialmg2_.M_InOutLine_ID , order1_.C_Order_ID , order1_.DocumentNo , order1_.DateOrdered , order1_.GrandTotal , order1_.DatePromised , coalesce(orderline0_.A_Asset_ID, order1_.A_Asset_ID) , coalesce(orderline0_.C_Project_ID, order1_.C_Project_ID) , coalesce(orderline0_.C_Costcenter_ID, order1_.C_Costcenter_ID) , coalesce(orderline0_.User1_ID, order1_.User1_ID) , coalesce(orderline0_.User2_ID, order1_.User2_ID) , order1_.C_DocType_ID , order1_.C_BPartner_ID , order1_.M_Warehouse_ID , coalesce(materialmg2_.QuantityOrder, orderline0_.QuantityOrder*(orderline0_.QtyOrdered-coalesce(orderline0_.QtyInvoiced, 0))/(case when orderline0_.QtyOrdered<>0 then orderline0_.QtyOrdered else null end)) , invoicelin4_.C_InvoiceLine_ID having orderline0_.Explode=$22 or orderline0_.QtyOrdered-sum(coalesce(procuremen3_.Qty, $23))<>$24 and (invoicelin4_.C_InvoiceLine_ID is null or sum(coalesce(invoicelin4_.QtyInvoiced, $25))-coalesce(orderline0_.QtyOrdered, $26)-sum(coalesce(procuremen3_.Qty, $27))<$28) order by order1_.DocumentNo desc, orderline0_.Line asc limit $9
ebd66f2e50select financialm0_.C_Settlement_Generate_ID as C_Settl11_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Settlement_Generate_ID=$1
58d3d7b94cUPDATE last_stat_tables ulst SET in_sample = $5 FROM ( SELECT cur.server_id AS server_id, cur.sample_id AS sample_id, cur.datid AS datid, cur.relid AS relid, tcur.relid AS toastrelid, -- Seq. scanned blocks rank row_number() OVER (ORDER BY (cur.seq_scan - COALESCE(lst.seq_scan,$6)) * cur.relsize + (tcur.seq_scan - COALESCE(tlst.seq_scan,$7)) * tcur.relsize DESC) scan_rank, row_number() OVER (ORDER BY cur.n_tup_ins + cur.n_tup_upd + cur.n_tup_del - COALESCE(lst.n_tup_ins + lst.n_tup_upd + lst.n_tup_del, $8) + COALESCE(tcur.n_tup_ins + tcur.n_tup_upd + tcur.n_tup_del, $9) - COALESCE(tlst.n_tup_ins + tlst.n_tup_upd + tlst.n_tup_del, $10) DESC) dml_rank, row_number() OVER (ORDER BY cur.n_tup_upd+cur.n_tup_del - COALESCE(lst.n_tup_upd + lst.n_tup_del, $11) + COALESCE(tcur.n_tup_upd + tcur.n_tup_del, $12) - COALESCE(tlst.n_tup_upd + tlst.n_tup_del, $13) DESC) vacuum_dml_rank, row_number() OVER (ORDER BY cur.n_dead_tup / NULLIF(cur.n_live_tup+cur.n_dead_tup, $14) DESC NULLS LAST) dead_pct_rank, row_number() OVER (ORDER BY cur.n_mod_since_analyze / NULLIF(cur.n_live_tup, $15) DESC NULLS LAST) mod_pct_rank, -- Read rank row_number() OVER (ORDER BY cur.heap_blks_read - COALESCE(lst.heap_blks_read,$16) + cur.idx_blks_read - COALESCE(lst.idx_blks_read,$17) + cur.toast_blks_read - COALESCE(lst.toast_blks_read,$18) + cur.tidx_blks_read - COALESCE(lst.tidx_blks_read,$19) DESC) read_rank, -- Page processing rank row_number() OVER (ORDER BY cur.heap_blks_read+cur.heap_blks_hit+cur.idx_blks_read+cur.idx_blks_hit+ cur.toast_blks_read+cur.toast_blks_hit+cur.tidx_blks_read+cur.tidx_blks_hit- COALESCE(lst.heap_blks_read+lst.heap_blks_hit+lst.idx_blks_read+lst.idx_blks_hit+ lst.toast_blks_read+lst.toast_blks_hit+lst.tidx_blks_read+lst.tidx_blks_hit, $20) DESC) gets_rank, -- Vacuum rank row_number() OVER (ORDER BY cur.vacuum_count - COALESCE(lst.vacuum_count, $21) + cur.autovacuum_count - COALESCE(lst.autovacuum_count, $22) DESC) vacuum_rank, row_number() OVER (ORDER BY cur.analyze_count - COALESCE(lst.analyze_count,$23) + cur.autoanalyze_count - COALESCE(lst.autoanalyze_count,$24) DESC) analyze_rank FROM -- main relations diff last_stat_tables cur JOIN last_stat_database dbcur USING (server_id, sample_id, datid) LEFT OUTER JOIN last_stat_database dblst ON (dblst.server_id, dblst.datid, dblst.sample_id, dblst.stats_reset) = (dbcur.server_id, dbcur.datid, dbcur.sample_id - $25, dbcur.stats_reset) LEFT OUTER JOIN last_stat_tables lst ON (lst.server_id, lst.sample_id, lst.datid, lst.relid) = (dblst.server_id, dblst.sample_id, dblst.datid, cur.relid) -- toast relations diff LEFT OUTER JOIN last_stat_tables tcur ON (tcur.server_id, tcur.sample_id, tcur.datid, tcur.relid) = (dbcur.server_id, dbcur.sample_id, dbcur.datid, cur.reltoastrelid) LEFT OUTER JOIN last_stat_tables tlst ON (tlst.server_id, tlst.sample_id, tlst.datid, tlst.relid) = (dblst.server_id, dblst.sample_id, dblst.datid, lst.reltoastrelid) WHERE (cur.server_id, cur.sample_id, cur.in_sample) = (sserver_id, s_id, $26) AND cur.relkind IN ($27,$28)) diff WHERE least( scan_rank, dml_rank, dead_pct_rank, mod_pct_rank, vacuum_dml_rank, read_rank, gets_rank, vacuum_rank, analyze_rank ) <= topn AND (ulst.server_id, ulst.sample_id, ulst.datid, ulst.in_sample) = (diff.server_id, diff.sample_id, diff.datid, $29) AND (ulst.relid = diff.relid OR ulst.relid = diff.toastrelid)
612b800127insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
5c208ba241SELECT 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, '' as UseSuspenseBalancing, '' as SuspenseBalancing_Acct, '' as UseSuspenseError, '' as SuspenseError_Acct, '' as UseCurrencyBalancing, '' as CurrencyBalancing_Acct, '' as RetainedEarning_Acct, '' as IncomeSummary_Acct, '' as InterCompanyDueTo_Acct, '' as InterCompanyDueFrom_Acct FROM C_ValidCombination WHERE C_ValidCombination_ID=$1
9ea37f4950select max(this_.Lastpayment) as y0_ from FIN_Payment_Sched_Inv_V this_ where this_.C_Invoice_ID=$1 and this_.Isactive=$2 limit $3
fdd1193fadINSERT INTO last_stat_indexes( server_id, sample_id, datid, relid, indexrelid, schemaname, relname, indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit, relsize, relsize_diff, tablespaceid, indisunique, in_sample, relpages_bytes, relpages_bytes_diff ) SELECT sserver_id, s_id, qres.datid, relid, indexrelid, schemaname, relname, indexrelname, dbl.idx_scan AS idx_scan, dbl.idx_tup_read AS idx_tup_read, dbl.idx_tup_fetch AS idx_tup_fetch, dbl.idx_blks_read AS idx_blks_read, dbl.idx_blks_hit AS idx_blks_hit, dbl.relsize AS relsize, dbl.relsize_diff AS relsize_diff, CASE WHEN tablespaceid=$19 THEN qres.tablespaceid ELSE tablespaceid END tablespaceid, indisunique, $20, dbl.relpages_bytes, dbl.relpages_bytes_diff FROM dblink($21, t_query) AS dbl ( relid oid, indexrelid oid, schemaname name, relname name, indexrelname name, idx_scan bigint, idx_tup_read bigint, idx_tup_fetch bigint, idx_blks_read bigint, idx_blks_hit bigint, relsize bigint, relsize_diff bigint, tablespaceid oid, indisunique bool, relpages_bytes bigint, relpages_bytes_diff bigint )
9c83facac5select this_.Psat_Activity_Materials_ID as Psat_Act1_723_0_, this_.AD_Client_ID as AD_Clien2_723_0_, this_.AD_Org_ID as AD_Org_I3_723_0_, this_.Isactive as Isactive4_723_0_, this_.Created as Created5_723_0_, this_.Createdby as Createdb6_723_0_, this_.Updated as Updated7_723_0_, this_.Updatedby as Updatedb8_723_0_, this_.Advcrm_Activity_ID as Advcrm_A9_723_0_, this_.M_Product_ID as M_Produ10_723_0_, this_.Estimatedqty as Estimat11_723_0_, this_.Invoiceable as Invoice12_723_0_, this_.Generaterequisition as Generat13_723_0_, this_.M_Requisition_ID as M_Requi14_723_0_, this_.C_Orderline_ID as C_Order15_723_0_ from psat_activity_materials this_ where this_.Advcrm_Activity_ID=$1 and this_.Isactive=$2
f286a2747cSELECT COALESCE(SUM(AMTACCTCR-AMTACCTDR), $5) AS NAME FROM FACT_ACCT, C_PERIOD, C_YEAR, (SELECT C_ELEMENTVALUE_ID FROM C_ELEMENTVALUE WHERE C_ELEMENTVALUE.ACCOUNTTYPE = $1) AA WHERE FACT_ACCT.C_PERIOD_ID = C_PERIOD.C_PERIOD_ID AND C_PERIOD.C_YEAR_ID = C_YEAR.C_YEAR_ID AND FACT_ACCT.ACCOUNT_ID = AA.C_ELEMENTVALUE_ID AND FACT_ACCT.FACTACCTTYPE <> $6 AND $7=$8 AND FACT_ACCT.DATEACCT >= TO_DATE($2) AND FACT_ACCT.DATEACCT < TO_DATE($3) AND FACT_ACCT.C_ACCTSCHEMA_ID = $4 AND C_YEAR.YEAR IN ($9) AND FACT_ACCT.AD_ORG_ID IN ($10)
9b16673e73vacuum analyze AD_Process_Run
0c133f89faSELECT profile.take_sample()
cc93eb92d8SELECT * FROM C_Invoice_Post0($1)
cbb0d2e65einsert into advcrm_activity (AD_Client_ID, AD_Org_ID, Created, Createdby, Updated, Updatedby, Isactive, Type_Activity, Name, Date_Start, Date_End, Status, AD_User_ID, Duration_Hours, Direction_Call, Visibility, Priority, Isallday, Istemplate, EM_Psat_Activity_Category_ID, EM_Psat_Request_ID, EM_Advcrm1_Newso, EM_Psat_Add_Consumption, EM_Psat_Lineno, em_psat_create_order, EM_Psat_Addmaterials, EM_Psat_Checklist_ID, EM_Psat_Invoicerule, EM_Psat_Finish_Activity, Advcrm_Activity_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)
0c13a0abe2select finpayment0_.C_Invoice_ID as C_Invoic8_373_1_, finpayment0_.Fin_Payment_Schedule_ID as Fin_Paym1_373_1_, finpayment0_.Fin_Payment_Schedule_ID as Fin_Paym1_373_0_, finpayment0_.AD_Client_ID as AD_Clien2_373_0_, finpayment0_.AD_Org_ID as AD_Org_I3_373_0_, finpayment0_.Created as Created4_373_0_, finpayment0_.Createdby as Createdb5_373_0_, finpayment0_.Updated as Updated6_373_0_, finpayment0_.Updatedby as Updatedb7_373_0_, finpayment0_.C_Invoice_ID as C_Invoic8_373_0_, finpayment0_.C_Order_ID as C_Order_9_373_0_, finpayment0_.Duedate as Duedate10_373_0_, finpayment0_.Fin_Paymentmethod_ID as Fin_Pay11_373_0_, finpayment0_.C_Currency_ID as C_Curre12_373_0_, finpayment0_.Amount as Amount13_373_0_, finpayment0_.Paidamt as Paidamt14_373_0_, finpayment0_.Outstandingamt as Outstan15_373_0_, finpayment0_.Isactive as Isactiv16_373_0_, finpayment0_.FIN_Payment_Priority_ID as FIN_Pay17_373_0_, finpayment0_.Update_Payment_Plan as Update_18_373_0_, finpayment0_.OrigDueDate as OrigDue19_373_0_, finpayment0_.Description as Descrip20_373_0_, finpayment0_.EM_Aprm_Modif_Paym_Sched as EM_Aprm21_373_0_, finpayment0_.EM_Aprm_Modif_Paym_Out_Sched as EM_Aprm22_373_0_, finpayment0_.ExpectedDate as Expecte23_373_0_ from FIN_Payment_Schedule finpayment0_ where finpayment0_.C_Invoice_ID=$1
f8cc1c12b0select --REQUEST psat_request.description as reqdesc, psat_request.requestdate, --ACTIVITY coalesce(advcrm_activity.em_psat_activity_num,psat_request.documentno) as documentno, advcrm_activity.type_activity, advcrm_activity.name as actname, advcrm_activity.description as actdesc, advcrm_activity.date_start, advcrm_activity.date_end, advcrm_activity.em_psat_namesign as namesign, advcrm_activity.em_psat_sign as actsign, -- case when chresseconduser.result is not null and chresseconduser.result <> $1 then activityuser.name || $2 || (select pcv."name" from psat_checklist_value pcv where pcv.psat_check_type_id = chresseconduser.psat_check_type_id and pcv.value = chresseconduser.result limit $3 ) else activityuser.name end as usernameact, -- advcrm_activity.em_psat_observations as actobservations, chresmachinetime.result as timemachine, chresworktime.result as worktime, coalesce(chresworkdone.result,chresworkdone.description) as logactivity, coalesce(chresmovementtime.result,$4) as timemovement, coalesce(chreskms.result,$5) as kms, coalesce(chreshrsguard.result,$6) as hoursGuard, --ORG ad_org.ad_org_id, --BPARTNER c_bpartner.value as valuepartner, upper(c_bpartner.name) as namepartner, upper(c_bpartner.name2) as name2partner, contactuser.name as contactname, contactuser.email as contactmail, contactuser.phone as contactphone, --ADDRESSREQUEST c_location.address1 as address1, c_location.address2 as address2, c_location.postal as bppostal, c_location.city as bpcity, c_location_description(c_location.c_location_id) || $7|| upper(coalesce(c_country_trl.name, c_country.name)) || $8 AS locationdesc, --PRODUCT m_product.name as prodreqname, coalesce(m_attributesetinstance.description, psat_request.additional_info) as attributedesc, --CONSUMPTION coalesce(psat_related_products.em_cus_specific_id,prodconsum.value) as prodconsumvalue, coalesce(em_cus_specific_name,prodconsum.name) as prodconsumname, coalesce(cus_specific_mats_price.pricelist, psat_activity_consumption.priceactual) as consumpriceprod, coalesce(psat_activity_consumption.qty,$9) as consumitionQty, (select count($10) from advcrm_activity ac left join psat_activity_consumption pac on ac.advcrm_activity_id = pac.advcrm_activity_id where ac.advcrm_activity_id = advcrm_activity.advcrm_activity_id) as totalConsumitions, ROW_NUMBER() OVER (ORDER BY psat_activity_consumption.psat_activity_consumption_id ) as rownumber from advcrm_activity left join psat_request on advcrm_activity.em_psat_request_id = psat_request.psat_request_id left join psat_activity_consumption on advcrm_activity.advcrm_activity_id = psat_activity_consumption.advcrm_activity_id left join psat_related_products on psat_request.m_product_id=psat_related_products.m_product_id and psat_related_products.m_material_id=psat_activity_consumption.m_product_id left join psat_checklist_result chresmachinetime on advcrm_activity.advcrm_activity_id = chresmachinetime.advcrm_activity_id and chresmachinetime.psat_check_type_id= $11 left join psat_checklist_result chresworktime on advcrm_activity.advcrm_activity_id = chresworktime.advcrm_activity_id and chresworktime.psat_check_type_id= $12 left join psat_checklist_result chresmovementtime on advcrm_activity.advcrm_activity_id = chresmovementtime.advcrm_activity_id and chresmovementtime.psat_check_type_id= $13 left join psat_checklist_result chreskms on advcrm_activity.advcrm_activity_id = chreskms.advcrm_activity_id and chreskms.psat_check_type_id= $14 left join psat_checklist_result chreshrsguard on advcrm_activity.advcrm_activity_id = chreshrsguard.advcrm_activity_id and chreshrsguard.psat_check_type_id= $15 left join psat_checklist_result chresworkdone on advcrm_activity.advcrm_activity_id = chresworkdone.advcrm_activity_id and chresworkdone.psat_check_type_id= $16 left join psat_checklist_result chresseconduser on advcrm_activity.advcrm_activity_id = chresseconduser.advcrm_activity_id and chresseconduser.psat_check_type_id= $17 left join c_bpartner on psat_request.c_bpartner_id=c_bpartner.c_bpartner_id left join cus_specific_mats_price on c_bpartner.c_bpartner_id = cus_specific_mats_price.c_bpartner_id left join c_bpartner_location on psat_request.c_bpartner_location_id=c_bpartner_location.c_bpartner_location_id left join c_location on c_bpartner_location.c_location_id=c_location.c_location_id left join c_region on c_location.c_region_id=c_region.c_region_id left join c_country on c_location.c_country_id=c_country.c_country_id left join c_country_trl on c_country.c_country_id=c_country_trl.c_country_id and c_country_trl.ad_language=$18 left join m_product on psat_request.m_product_id=m_product.m_product_id left join m_attributesetinstance on psat_request.m_attributesetinstance_id=m_attributesetinstance.m_attributesetinstance_id left join m_product prodconsum on psat_activity_consumption.m_product_id = prodconsum.m_product_id left join c_doctype on psat_request.c_doctype_id=c_doctype.c_doctype_id left join ad_user activityuser on advcrm_activity.ad_user_id=activityuser.ad_user_id left join ad_user contactuser on coalesce(psat_request.requestor_id,psat_request.affected_contact_id)=contactuser.ad_user_id left join ad_org on psat_request.ad_org_id=ad_org.ad_org_id left join ad_orginfo on ad_org.ad_org_id=ad_orginfo.ad_org_id left join c_location c_locationorg on ad_orginfo.c_location_id=c_locationorg.c_location_id left join c_region c_regionorg on c_locationorg.c_region_id=c_regionorg.c_region_id where advcrm_activity.advcrm_activity_id in ($19)
44dc303aa7select this_.Psat_Activity_Consumption_ID as Psat_Act1_722_0_, this_.AD_Client_ID as AD_Clien2_722_0_, this_.AD_Org_ID as AD_Org_I3_722_0_, this_.Isactive as Isactive4_722_0_, this_.Created as Created5_722_0_, this_.Createdby as Createdb6_722_0_, this_.Updated as Updated7_722_0_, this_.Updatedby as Updatedb8_722_0_, this_.Advcrm_Activity_ID as Advcrm_A9_722_0_, this_.M_Product_ID as M_Produ10_722_0_, this_.Qty as Qty11_722_0_, this_.Priceactual as Priceac12_722_0_, this_.M_Attributesetinstance_ID as M_Attri13_722_0_, this_.M_Locator_ID as M_Locat14_722_0_, this_.Psat_Activity_Materials_ID as Psat_Ac15_722_0_, this_.Invoiced as Invoice16_722_0_, this_.isProcessed as isProce17_722_0_, this_.Description as Descrip18_722_0_, this_.M_Inoutline_ID as M_Inout19_722_0_ from psat_activity_consumption this_ where this_.Psat_Activity_Materials_ID=$1 and this_.Isactive=$2
b8b9950890INSERT INTO ad_session_usage_audit (ad_session_usage_audit_id, ad_client_id, ad_org_id, createdby, updatedby, ad_session_id, object_id, ad_module_id, command, classname, object_type, process_time) VALUES (get_uuid(),$10,$11,$1,$2,$3,$4,$5,$6,$7,$8,to_number($9))
140f3eb685SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)
671fe12038COPY public.ad_audit_trail (ad_audit_trail_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, ad_table_id, record_id, record_revision, ad_user_id, event_time, processtype, process_id, action, ad_column_id, old_char, new_char, old_nchar, new_nchar, old_number, new_number, old_date, new_date, old_text, new_text) TO stdout
0b651ca53dCOPY 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
6f5312535eSELECT REPLACE(REPLACE(SQL_RECORD_IDENTIFIER, ':c_language', '''' || p_Language || ''''), ':c_ID', p_Record_ID) FROM AD_TABLE WHERE UPPER(TABLENAME)=UPPER(p_TableName)
167f11efcdvacuum analyze prsync_entry
12a81791afSELECT coalesce(( select ol.qtyordered - coalesce(sum(abs(coalesce(( select sum(il.movementqty) from m_inoutline il left join m_inout i on i.m_inout_id=il.m_inout_id where i.docstatus<>$2 and il.c_orderline_id=ol.c_orderline_id ),$3))), $4) restante from c_orderline ol where ol.c_orderline_id=p_record_id group by ol.c_orderline_id), $5)
a6bd2516adinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
e4360f260cUPDATE C_Invoice SET Processing=$2 WHERE C_Invoice_ID = $1 AND Processed=$3 AND (Processing=$4 OR Processing IS NULL) AND Posted<>$5
785a907bc3select invoice0_.C_Invoice_ID as C_Invoic1_249_, invoice0_.AD_Client_ID as AD_Clien2_249_, invoice0_.AD_Org_ID as AD_Org_I3_249_, invoice0_.IsActive as IsActive4_249_, invoice0_.Created as Created5_249_, invoice0_.CreatedBy as CreatedB6_249_, invoice0_.Updated as Updated7_249_, invoice0_.UpdatedBy as UpdatedB8_249_, invoice0_.IsSOTrx as IsSOTrx9_249_, invoice0_.DocumentNo as Documen10_249_, invoice0_.DocStatus as DocStat11_249_, invoice0_.DocAction as DocActi12_249_, invoice0_.Processing as Process13_249_, invoice0_.Processed as Process14_249_, invoice0_.Posted as Posted15_249_, invoice0_.C_DocType_ID as C_DocTy16_249_, invoice0_.C_DocTypeTarget_ID as C_DocTy17_249_, invoice0_.C_Order_ID as C_Order18_249_, invoice0_.Description as Descrip19_249_, invoice0_.IsPrinted as IsPrint20_249_, invoice0_.SalesRep_ID as SalesRe21_249_, invoice0_.DateInvoiced as DateInv22_249_, invoice0_.DatePrinted as DatePri23_249_, invoice0_.DateAcct as DateAcc24_249_, invoice0_.C_BPartner_ID as C_BPart25_249_, invoice0_.C_BPartner_Location_ID as C_BPart26_249_, invoice0_.POReference as PORefer27_249_, invoice0_.IsDiscountPrinted as IsDisco28_249_, invoice0_.DateOrdered as DateOrd29_249_, invoice0_.C_Currency_ID as C_Curre30_249_, invoice0_.C_PaymentTerm_ID as C_Payme31_249_, invoice0_.C_Charge_ID as C_Charg32_249_, invoice0_.ChargeAmt as ChargeA33_249_, invoice0_.TotalLines as TotalLi34_249_, invoice0_.GrandTotal as GrandTo35_249_, invoice0_.M_PriceList_ID as M_Price36_249_, invoice0_.IsTaxIncluded as IsTaxIn37_249_, invoice0_.C_Campaign_ID as C_Campa38_249_, invoice0_.C_Project_ID as C_Proje39_249_, invoice0_.C_Activity_ID as C_Activ40_249_, invoice0_.CreateFrom as CreateF41_249_, invoice0_.GenerateTo as Generat42_249_, invoice0_.AD_User_ID as AD_User43_249_, invoice0_.CopyFrom as CopyFro44_249_, invoice0_.IsSelfService as IsSelfS45_249_, invoice0_.AD_OrgTrx_ID as AD_OrgT46_249_, invoice0_.User1_ID as User47_249_, invoice0_.User2_ID as User48_249_, invoice0_.Withholdingamount as Withhol49_249_, invoice0_.Taxdate as Taxdate50_249_, invoice0_.C_Withholding_ID as C_Withh51_249_, invoice0_.Ispaid as Ispaid52_249_, invoice0_.EM_Einv_Generated as EM_Einv53_249_, invoice0_.Totalpaid as Totalpa54_249_, invoice0_.EM_Einv_Sent as EM_Einv55_249_, invoice0_.OutstandingAmt as Outstan56_249_, invoice0_.DaysTillDue as DaysTil57_249_, invoice0_.DueAmt as DueAmt58_249_, invoice0_.LastCalculatedOnDate as LastCal59_249_, invoice0_.FIN_Paymentmethod_ID as FIN_Pay60_249_, invoice0_.FIN_Payment_Priority_ID as FIN_Pay61_249_, invoice0_.Finalsettlement as Finalse62_249_, invoice0_.Daysoutstanding as Daysout63_249_, invoice0_.Percentageoverdue as Percent64_249_, invoice0_.C_Costcenter_ID as C_Costc65_249_, invoice0_.Calculate_Promotions as Calcula66_249_, invoice0_.A_Asset_ID as A_Asset67_249_, invoice0_.EM_APRM_Addpayment as EM_APRM68_249_, invoice0_.Iscashvat as Iscashv69_249_, invoice0_.EM_APRM_Processinvoice as EM_APRM70_249_, invoice0_.EM_Obcma_C_Poc_Email_ID as EM_Obcm71_249_, invoice0_.Prepaymentamt as Prepaym72_249_, invoice0_.Createfromorders as Createf73_249_, invoice0_.Createfrominouts as Createf74_249_, invoice0_.EM_Advcrm_Newactivity as EM_Advc75_249_, invoice0_.Paidamtatinvoicing as Paidamt76_249_, invoice0_.BPartner_ExtRef as BPartne77_249_, invoice0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc78_249_, invoice0_.EM_Prouti_Recalculate_Price as EM_Prou79_249_, invoice0_.EM_Ml_Select_Product as EM_Ml_S80_249_, invoice0_.EM_Prouti_Pricecalculatetdate as EM_Prou81_249_, invoice0_.EM_Prouti_Totalizations as EM_Prou82_249_ from C_Invoice invoice0_ left outer join FIN_Payment_Schedule finpayment1_ on invoice0_.C_Invoice_ID=finpayment1_.C_Invoice_ID where invoice0_.Processed=$7 and (invoice0_.Ispaid=$8 or finpayment1_.Updated>=invoice0_.LastCalculatedOnDate or invoice0_.OutstandingAmt<>$9 or invoice0_.Finalsettlement is null) and (invoice0_.AD_Org_ID in ($1 , $2 , $3 , $4)) and (invoice0_.AD_Client_ID in ($5 , $6)) and invoice0_.IsActive=$10
0c247acdf0VACUUM (FULL, VERBOSE, ANALYZE)
2e0b729b87VACUUM (FULL, VERBOSE, ANALYZE)
adb1c31f79VACUUM (FULL, VERBOSE, ANALYZE)
a12a07df32SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM(AMOUNT) AS AMOUNT, SUM(QTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(AMOUNTREF) AS AMOUNTREF, SUM(QTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, SUM(CONVAMOUNT) AS CONVAMOUNT, SUM(CONVAMOUNTREF) AS CONVAMOUNTREF, C_CURRENCY_SYMBOL($1, $6, $7) AS CONVSYM, C_CURRENCY_ISOSYM($2) AS CONVISOSYM, MIN(WSYMBOL) AS WSYMBOL FROM (SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, SUM(LINENETAMT) AS AMOUNT, SUM(QTYORDERED) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(LINENETREF) AS AMOUNTREF, SUM(QTYORDEREDREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, C_CURRENCY_CONVERT(SUM(LINENETAMT), TRCURRENCYID, $3, TO_DATE(TRDATE), $8, TRCLIENTID, TRORGID) AS CONVAMOUNT, $9 AS CONVAMOUNTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, MIN(WSYMBOL) AS WSYMBOL FROM (SELECT to_char(AD_COLUMN_IDENTIFIER(to_char($10), to_char( C_BPARTNER.C_BPARTNER_ID), to_char($11))) AS NIVEL1, to_char($12) AS NIVEL2, to_char($13) AS NIVEL3, to_char($14) AS NIVEL4, to_char($15) AS NIVEL5, to_char($16) AS NIVEL6, to_char($17) AS NIVEL7, to_char($18) AS NIVEL8, to_char($19) AS NIVEL9, to_char($20) AS NIVEL10, to_char($21) AS NIVEL11, C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, C_ORDERLINE.QTYORDERED*M_PRODUCT.WEIGHT AS WEIGHT, $22 AS LINENETREF, $23 AS QTYORDEREDREF, $24 AS WEIGHTREF, C_UOM.UOMSYMBOL, COALESCE(C_ORDERLINE.C_CURRENCY_ID, C_ORDER.C_CURRENCY_ID) AS TRCURRENCYID, TO_DATE(COALESCE(C_ORDER.DATEORDERED, NOW())) AS TRDATE, C_ORDERLINE.AD_CLIENT_ID AS TRCLIENTID, C_ORDERLINE.AD_ORG_ID AS TRORGID, (select uomsymbol from c_uom where c_uom_id = aci.c_uom_weight_id) as WSYMBOL FROM C_ORDER left join ad_clientinfo aci on aci.ad_client_id =c_order.ad_client_id left join AD_USER on C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = $25 AND C_ORDER.PROCESSED = $26 AND C_ORDER.DOCSTATUS NOT IN ($27, $28, $29) AND $30=$31 AND C_ORDER.AD_ORG_ID IN ($32) AND C_ORDER.AD_CLIENT_ID IN ($33,$34) AND $35=$36 AND C_ORDER.DATEORDERED >= to_date($4) AND C_ORDER.DATEORDERED < to_date($5) ) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, NIVEL11 ORDER BY NIVEL1
df99961951select financialm0_.C_Settlement_ID as C_Settle1_310_0_, financialm0_.AD_Client_ID as AD_Clien2_310_0_, financialm0_.AD_Org_ID as AD_Org_I3_310_0_, financialm0_.IsActive as IsActive4_310_0_, financialm0_.Created as Created5_310_0_, financialm0_.CreatedBy as CreatedB6_310_0_, financialm0_.Updated as Updated7_310_0_, financialm0_.UpdatedBy as UpdatedB8_310_0_, financialm0_.DocumentNo as Document9_310_0_, financialm0_.DateTrx as DateTrx10_310_0_, financialm0_.C_DocType_ID as C_DocTy11_310_0_, financialm0_.Processing as Process12_310_0_, financialm0_.Processed as Process13_310_0_, financialm0_.Posted as Posted14_310_0_, financialm0_.C_Project_ID as C_Proje15_310_0_, financialm0_.C_Campaign_ID as C_Campa16_310_0_, financialm0_.C_Activity_ID as C_Activ17_310_0_, financialm0_.User1_ID as User18_310_0_, financialm0_.User2_ID as User19_310_0_, financialm0_.CreateFrom as CreateF20_310_0_, financialm0_.C_Currency_ID as C_Curre21_310_0_, financialm0_.Cancelednotchargeamt as Cancele22_310_0_, financialm0_.Generatedamt as Generat23_310_0_, financialm0_.Chargedamt as Charged24_310_0_, financialm0_.Description as Descrip25_310_0_, financialm0_.CreateFile as CreateF26_310_0_, financialm0_.DateAcct as DateAcc27_310_0_, financialm0_.Settlementtype as Settlem28_310_0_, financialm0_.SettlementOpen as Settlem29_310_0_, financialm0_.CopyFrom as CopyFro30_310_0_, financialm0_.IsGenerated as IsGener31_310_0_, financialm0_.IsTemplate as IsTempl32_310_0_ from C_Settlement financialm0_ where financialm0_.C_Settlement_ID=$1
1b3d7b3f6dselect this_.AD_Sequence_Config_ID as AD_Seque1_112_0_, this_.AD_Client_ID as AD_Clien2_112_0_, this_.AD_Org_ID as AD_Org_I3_112_0_, this_.Isactive as Isactive4_112_0_, this_.Created as Created5_112_0_, this_.Createdby as Createdb6_112_0_, this_.Updated as Updated7_112_0_, this_.Updatedby as Updatedb8_112_0_, this_.Generator as Generato9_112_0_, this_.AD_Reference_ID as AD_Refe10_112_0_, this_.DB_Sequence_Name as DB_Sequ11_112_0_, this_.DB_Sequence_Initial as DB_Sequ12_112_0_, this_.DB_Sequence_Increment as DB_Sequ13_112_0_ from ad_sequence_config this_ where this_.AD_Reference_ID=$1 and this_.AD_Org_ID in ($2, $3, $4, $5) and this_.AD_Client_ID in ($6, $7) and this_.Isactive=$8
d0b36135c7INSERT INTO last_stat_tables( server_id, sample_id, datid, relid, schemaname, relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, n_mod_since_analyze, n_ins_since_vacuum, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit, relsize, relsize_diff, tablespaceid, reltoastrelid, relkind, in_sample, relpages_bytes, relpages_bytes_diff ) SELECT sserver_id, s_id, qres.datid, dbl.relid, dbl.schemaname, dbl.relname, dbl.seq_scan AS seq_scan, dbl.seq_tup_read AS seq_tup_read, dbl.idx_scan AS idx_scan, dbl.idx_tup_fetch AS idx_tup_fetch, dbl.n_tup_ins AS n_tup_ins, dbl.n_tup_upd AS n_tup_upd, dbl.n_tup_del AS n_tup_del, dbl.n_tup_hot_upd AS n_tup_hot_upd, dbl.n_live_tup AS n_live_tup, dbl.n_dead_tup AS n_dead_tup, dbl.n_mod_since_analyze AS n_mod_since_analyze, dbl.n_ins_since_vacuum AS n_ins_since_vacuum, dbl.last_vacuum, dbl.last_autovacuum, dbl.last_analyze, dbl.last_autoanalyze, dbl.vacuum_count AS vacuum_count, dbl.autovacuum_count AS autovacuum_count, dbl.analyze_count AS analyze_count, dbl.autoanalyze_count AS autoanalyze_count, dbl.heap_blks_read AS heap_blks_read, dbl.heap_blks_hit AS heap_blks_hit, dbl.idx_blks_read AS idx_blks_read, dbl.idx_blks_hit AS idx_blks_hit, dbl.toast_blks_read AS toast_blks_read, dbl.toast_blks_hit AS toast_blks_hit, dbl.tidx_blks_read AS tidx_blks_read, dbl.tidx_blks_hit AS tidx_blks_hit, dbl.relsize AS relsize, dbl.relsize_diff AS relsize_diff, CASE WHEN dbl.tablespaceid=$19 THEN qres.tablespaceid ELSE dbl.tablespaceid END AS tablespaceid, dbl.reltoastrelid, dbl.relkind, $20, dbl.relpages_bytes, dbl.relpages_bytes_diff FROM dblink($21, t_query) AS dbl ( relid oid, schemaname name, relname name, seq_scan bigint, seq_tup_read bigint, idx_scan bigint, idx_tup_fetch bigint, n_tup_ins bigint, n_tup_upd bigint, n_tup_del bigint, n_tup_hot_upd bigint, n_live_tup bigint, n_dead_tup bigint, n_mod_since_analyze bigint, n_ins_since_vacuum bigint, last_vacuum timestamp with time zone, last_autovacuum timestamp with time zone, last_analyze timestamp with time zone, last_autoanalyze timestamp with time zone, vacuum_count bigint, autovacuum_count bigint, analyze_count bigint, autoanalyze_count bigint, heap_blks_read bigint, heap_blks_hit bigint, idx_blks_read bigint, idx_blks_hit bigint, toast_blks_read bigint, toast_blks_hit bigint, tidx_blks_read bigint, tidx_blks_hit bigint, relsize bigint, relsize_diff bigint, tablespaceid oid, reltoastrelid oid, relkind char, relpages_bytes bigint, relpages_bytes_diff bigint )
968e467a3bSELECT COUNT( DISTINCT $3 || C_BPARTNER.C_BPARTNER_ID ) AS COUNT FROM C_ORDER left join AD_USER on C_ORDER.SALESREP_ID = AD_USER.AD_USER_ID, C_BPARTNER left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID, C_BP_GROUP, C_ORDERLINE, M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM, AD_ORG WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AND C_ORDER.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID AND C_ORDER.AD_ORG_ID = AD_ORG.AD_ORG_ID AND C_ORDER.ISSOTRX = $4 AND C_ORDER.PROCESSED = $5 AND C_ORDER.DOCSTATUS NOT IN ($6, $7, $8) AND $9=$10 AND C_ORDER.AD_ORG_ID IN ($11) AND C_ORDER.AD_CLIENT_ID IN ($12,$13) AND $14=$15 AND $16=$17 AND C_ORDER.DATEORDERED >= to_date($1) AND C_ORDER.DATEORDERED < to_date($2)
b8d861c28dinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
66c3814b4edelete from ad_context_info
c2b6cfc2bfselect text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, texttrl.ad_language as trlLang, texttrl.text as trlText, texttrl.istranslated as isTranslated, 1 as orderSeq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = '/org/openbravo/erpCommon/security/Login.html' and text.isused = 'Y' and texttrl.ad_language = 'en_US' UNION select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, texttrl.ad_language as trlLang, texttrl.text as trlText, texttrl.istranslated as isTranslated, 3 as orderSeq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename is null and text.isused = 'Y' and texttrl.ad_language = 'en_US' UNION select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, 'en_US' as trlLang, text.text as trlText, 'N' as isTranslated, 2 as orderSeq from ad_textinterfaces text where text.ad_textinterfaces_id NOT IN (SELECT t.ad_textinterfaces_id FROM ad_textInterfaces t, ad_textinterfaces_trl trl WHERE t.ad_textinterfaces_id = trl.ad_textinterfaces_id and trl.ad_language = 'en_US') and (text.filename is null OR text.filename = '/org/openbravo/erpCommon/security/Login.html' ) and text.isused = 'Y' order by orderSeq
6e8832531ainsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
50b8978166select order_comp0_.C_Order_ID as C_Order_1_265_0_, order_comp0_.AD_Client_ID as AD_Clien2_265_0_, order_comp0_.AD_Org_ID as AD_Org_I3_265_0_, (coalesce((select case when sum(abs(ol.qtyordered)) = $51 or order_comp0_.iscancelled = $52 or order_comp0_.cancelledorder_id is not null then $53 else round(coalesce(sum(abs(ol.qtydelivered)), $54)/sum(abs(ol.qtyordered)) * $55, $56) end from c_orderline ol where ol.c_order_id=order_comp0_.c_order_id and ol.c_order_discount_id is null),$57)) as formula28_0_, (coalesce(prouti_delavailablewithoutres(order_comp0_.c_order_id),$58)) as formula29_0_, (coalesce(prouti_deliveryavailable(order_comp0_.c_order_id),$59)) as formula30_0_, (select sum(prouti_qtyremainingorderline(ol.c_orderline_id)) from c_orderline ol where ol.c_order_id = order_comp0_.c_order_id) as formula31_0_, (select case when sum(ol.qtyordered)=$60 then $61 else trunc((sum(least(ol.qtyordered, coalesce(pool.qtyordered,$62))) / sum(ol.qtyordered) ) * $63) end from c_orderline ol left join c_orderline pool on pool.em_prouti_orderline_id=ol.c_orderline_id where ol.c_order_id=order_comp0_.c_order_id) as formula32_0_, (coalesce((select case when sum(abs(ol.qtyordered)) = $64 or order_comp0_.iscancelled = $65 or order_comp0_.cancelledorder_id is not null then $66 else round(coalesce(sum(abs(ol.qtyinvoiced)), $67)/sum(abs(ol.qtyordered)) * $68, $69) end from c_orderline ol where ol.c_order_id=order_comp0_.c_order_id and ol.c_order_discount_id is null), $70)) as formula33_0_, (coalesce((select case when sum(fps.amount) = $71 then $72 else round(sum(fps.paidamt)/sum(fps.amount) * $73, $74) end from FIN_Payment_Schedule fps where fps.c_order_id=order_comp0_.c_order_id),$75)) as formula34_0_ from C_Order order_comp0_ where order_comp0_.C_Order_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, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50)
ee46524d09SELECT TO_CHAR(COALESCE(TO_CHAR(T.Name),$1)) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=$2) L, C_BPartner T WHERE C_BPartner_ID=$3
9cbca4d83cINSERT INTO AD_AUDIT_TRAIL (AD_AUDIT_TRAIL_ID, AD_USER_ID, AD_TABLE_ID, AD_COLUMN_ID, PROCESSTYPE, PROCESS_ID, RECORD_ID, RECORD_REVISION, ACTION, EVENT_TIME, OLD_CHAR, NEW_CHAR, AD_CLIENT_ID, AD_ORG_ID) VALUES (GET_UUID(), V_USER_ID, $33, $34, v_process_type, v_process_id, v_record_id, v_record_rev, v_action, v_time, v_old_CHAR, v_new_CHAR, V_CLIENT, V_ORG)
9625146448select min(this_.Duedate) as y0_ from FIN_Payment_Schedule this_ where this_.C_Invoice_ID=$1 and this_.Outstandingamt<>$2 and this_.Isactive=$3 limit $4
29e9be51ceselect adtab0_.AD_Table_ID as col_0_0_, adwindowac2_.IsReadWrite as col_1_0_ from AD_Tab adtab0_ left outer join AD_Window adwindow1_ on adtab0_.AD_Window_ID=adwindow1_.AD_Window_ID left outer join AD_Window_Access adwindowac2_ on adwindow1_.AD_Window_ID=adwindowac2_.AD_Window_ID where adwindowac2_.AD_Role_ID=$1
5444a9a88cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
12e95683cadelete from ad_context_info
fa1b74d06fselect financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Settlement_Cancel_ID=$1
1e43f28979insert into M_Product (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, C_UOM_ID, IsSummary, IsStocked, IsPurchased, IsSold, IsBOM, IsInvoicePrintDetails, IsPickListPrintDetails, IsVerified, M_Product_Category_ID, C_TaxCategory_ID, Discontinued, Processing, ProductType, M_Locator_ID, Ispriceprinted, Enforce_Attribute, Calculated, Production, Qtytype, Isquantityvariable, Isdeferredrevenue, Isdeferredexpense, Bookusingpoprice, EM_Advcrm_Newactivity, IsGeneric, CreateVariants, Updateinvariants, ManageVariants, Print_Description, Returnable, Ispricerulebased, Unique_Per_Document, Relateprodcattoservice, Relateprodtoservice, Islinkedtoproduct, Allow_Deferred_Sell, EM_Prlab_Qtylabels, EM_Psat_Isrepairable, EM_Psat_Isavailablesat, Ismodifytax, Relateprodcattaxtoservice, Copyservicemodifytaxconfig, M_Product_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53)
aaf3c93842delete from ad_context_info
1e7f08819eINSERT 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)
4108c96b3fselect productbyp0_.M_Product_Price_Warehouse_V_ID as M_Produc1_469_, productbyp0_.AD_Client_ID as AD_Clien2_469_, productbyp0_.AD_Org_ID as AD_Org_I3_469_, productbyp0_.Isactive as Isactive4_469_, productbyp0_.Updated as Updated5_469_, productbyp0_.Updatedby as Updatedb6_469_, productbyp0_.Created as Created7_469_, productbyp0_.Createdby as Createdb8_469_, productbyp0_.M_Product_ID as M_Produc9_469_, productbyp0_.M_Warehouse_ID as M_Wareh10_469_, productbyp0_.M_Productprice_ID as M_Produ11_469_, productbyp0_.QTY_Available as QTY_Ava12_469_, productbyp0_.QTY_Onhand as QTY_Onh13_469_, productbyp0_.QTY_Reserved as QTY_Res14_469_, productbyp0_.QTY_Ordered as QTY_Ord15_469_, productbyp0_.Pricelist as Priceli16_469_, productbyp0_.Pricestd as Pricest17_469_, productbyp0_.Pricelimit as Priceli18_469_, productbyp0_.Orgwarehouse as Orgware19_469_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID=product1_.M_Product_ID cross join M_ProductPrice pricingpro4_ cross join M_PriceList_Version pricingpri5_ cross join M_PriceList pricingpri9_ where productbyp0_.M_Productprice_ID=pricingpro4_.M_ProductPrice_ID and pricingpro4_.M_PriceList_Version_ID=pricingpri5_.M_PriceList_Version_ID and pricingpri5_.M_PriceList_ID=pricingpri9_.M_PriceList_ID and (upper(product1_.Value) like upper($1) escape $12 or upper(product1_.Name) like upper($2) escape $13 or upper((product1_.Value||$14||coalesce(to_char((select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID=product1_.M_Product_ID and producttrl2_.AD_Language=$15)), to_char(product1_.Name), $16))) like upper($3) escape $17 or upper((product1_.Value||$18||coalesce(to_char((select producttrl3_.Name from M_Product_Trl producttrl3_ where producttrl3_.M_Product_ID=product1_.M_Product_ID and producttrl3_.AD_Language=$19)), to_char(product1_.Name), $20))) like upper($4) escape $21) and (productbyp0_.AD_Org_ID in ($22 , $23)) and productbyp0_.Isactive=$24 and AD_ORG_ISINNATURALTREE(productbyp0_.Orgwarehouse, $5, $6)=$25 and pricingpri5_.IsActive=$26 and AD_ORG_ISINNATURALTREE(pricingpro4_.AD_Org_ID, $7, $8)=$27 and pricingpri9_.IsSOPriceList=$28 and pricingpri9_.C_Currency_ID=$29 and pricingpro4_.M_PriceList_Version_ID=$30 and productbyp0_.M_Warehouse_ID=$31 and (productbyp0_.AD_Client_ID in ($9 , $10)) and productbyp0_.Isactive=$32 order by product1_.Value, product1_.Name, product1_.M_Product_ID limit $11
228d74fbf5COPY 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
c525c04235INSERT INTO AD_Process_Run (AD_Org_ID, AD_Client_ID, Isactive, Created, Createdby, Updated, UpdatedBy, AD_Process_Run_ID, Status, Start_Time, Runtime, Log, AD_Process_Request_ID, Scheduler_Instance) VALUES ($1, $2, 'Y', NOW(), $3, NOW(), $4, $5, $6, NOW(), $7, $8, $9, $10)
503324b603select financialm0_.C_Invoice_ID as C_Invoi13_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Invoice_ID=$1
a4a671fe58insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
5c9911f091insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
50ca7aecdcinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2f8789e4baSELECT aprm_gen_paymentschedule_inv($1) FROM DUAL
b3eeff8931insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
b9bb8a4422SELECT * FROM take_sample_subset(1,0)
6902d69fcfSELECT COALESCE(SUM(AMTACCTCR-AMTACCTDR), $3) AS NAME FROM FACT_ACCT, C_PERIOD, C_YEAR, (SELECT C_ELEMENTVALUE_ID FROM C_ELEMENTVALUE WHERE C_ELEMENTVALUE.ACCOUNTTYPE = $1) AA WHERE FACT_ACCT.C_PERIOD_ID = C_PERIOD.C_PERIOD_ID AND C_PERIOD.C_YEAR_ID = C_YEAR.C_YEAR_ID AND FACT_ACCT.ACCOUNT_ID = AA.C_ELEMENTVALUE_ID AND FACT_ACCT.FACTACCTTYPE <> $4 AND $5=$6 AND FACT_ACCT.C_ACCTSCHEMA_ID = $2 AND C_YEAR.YEAR IN ($7) AND FACT_ACCT.AD_ORG_ID IN ($8)
61bc3cba28insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
73e3636becupdate C_Invoice set Updated=$1, LastCalculatedOnDate=$2 where C_Invoice_ID=$3
f38aca3f97delete from ad_context_info
032d1e73d2SELECT C_INVOICE_POST(p_PInstance_ID, $2)

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_7ad_context_info557 GB126611126535126534
etendopg_defaultpg_temp_3ad_context_info214 GB758937584175840
etendopg_defaultpg_temp_5ad_context_info110 GB125321253212532
etendopg_defaultpg_temp_5ad_context_info104 GB512765120651205
etendopg_defaultpg_temp_4ad_context_info32 GB260212595025949
etendopg_defaultpublicfact_acct27 GB1047691708133304814
fact_acct(TOAST)
etendopg_defaultpublicadvcrm_activity4570 MB28418571748291251109
advcrm_activity(TOAST)
etendopg_defaultpublicc_bpartner4555 MB35372046281156566111075
c_bpartner(TOAST)
etendopg_defaultpublicc_invoice4258 MB187352966186836673290519606
c_invoice(TOAST)
etendopg_defaultpg_catalogpg_class4083 MB60776167356044861874672818741375
etendopg_defaultpublicpsat_checklist_result3165 MB54117510221591918
psat_checklist_result(TOAST)
etendopg_defaultpublicc_order2195 MB14750245263507132471201
c_order(TOAST)
etendopg_defaultprofilelast_stat_database2178 MB1018259292
etendopg_defaultpublicm_inout2069 MB1761161222603126024
m_inout(TOAST)
etendopg_defaultpublicad_audit_trail1523 MB33172632859
ad_audit_trail(TOAST)
etendopg_defaultpublicc_uom1174 MB751566041360416
c_uom(TOAST)
etendopg_defaultpublicm_product777 MB219413065773778631
m_product(TOAST)
etendopg_defaultprofilelast_stat_tablespaces568 MB363794646
last_stat_tablespaces(TOAST)
etendopg_defaultpublicc_invoiceline441 MB8938495031262523227
c_invoiceline(TOAST)
etendopg_defaultpg_catalogpg_attribute389 MB9228649112155102420324203

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpg_temp_7ad_context_info6623805336.15
etendopg_defaultpg_temp_3ad_context_info2396338413.08
etendopg_defaultpg_temp_5ad_context_info137192127.49
etendopg_defaultpublicc_invoice44570192.4377833414.25
etendopg_defaultpg_temp_5ad_context_info109122255.95
etendopg_defaultpublicfact_acct34326551.87280710.02
etendopg_defaultpublicfin_payment_schedule8878800.4825643661.40
etendopg_defaultprofilelast_stat_tables32712731.791055560.06
etendopg_defaultpg_temp_4ad_context_info28123361.53
etendopg_defaultpg_catalogpg_class11137350.6112893900.70
etendopg_defaultpublicpsat_activity_materials135670.0123184791.27
etendopg_defaultpublicc_bpartner15760100.865450600.30
etendopg_defaultpublicm_product7662830.428457640.46
etendopg_defaultpublicc_elementvalue5495580.3010592580.58
etendopg_defaultpublicc_debt_payment4867960.278178400.45
etendopg_defaultpg_catalogpg_attribute4637900.256800760.37
etendopg_defaultpublicad_tab5519570.304760440.26
etendopg_defaultpublicm_productprice2652930.147453910.41
etendopg_defaultprofilelast_stat_indexes5697880.312065340.11
etendopg_defaultpublicc_order5192520.281767300.10

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpg_temp_5ad_context_info1368290781.740.26
etendopg_defaultpg_temp_7ad_context_info260367315.5596.07
etendopg_defaultpublicad_audit_trail1300580.7829990.0247.36
etendopg_defaultpublicfact_acct672610.4023030.0197.99
etendopg_defaultpublicad_image7850.00250.00563510.348850.0166.29
etendopg_defaultpublicc_invoiceline141070.089870.0186.82
etendopg_defaultpublicc_invoice58260.0361180.0499.90
etendopg_defaultpublicc_invoicelinetax80490.052640.0063.19
etendopg_defaultpublicad_session_usage_audit44790.036370.0092.92
etendopg_defaultpublicfin_payment_schedule37980.025870.0099.87
etendopg_defaultpublicpsat_checklist_result100.0035020.0299.34
etendopg_defaultpublicfin_payment_scheduledetail27220.027010.0097.95
etendopg_defaultpublicfin_payment31580.021850.0076.53
etendopg_defaultpublicad_process_run26160.021180.0090.00100.0095.78
etendopg_defaultpublicfin_payment_detail19060.012420.0061.73
etendopg_defaultpublicc_orderline80.0020090.0199.63
etendopg_defaultpg_catalogpg_attribute14230.014850.0099.83
etendopg_defaultprofilesample_stat_tables17730.011080.0096.12
etendopg_defaultpg_catalogpg_statistic11860.01870.005510.00200.0099.52
etendopg_defaultpublicm_matchpo9850.012150.0092.84

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
etendopg_defaultpublicc_invoice7329051960618785649323529661868366
c_invoice(TOAST)
etendopg_defaultpg_temp_7ad_context_info126535126534126611126610
etendopg_defaultpg_temp_3ad_context_info75841758407589375892
etendopg_defaultprofilelast_stat_indexes54119135354119218586590434587328420
etendopg_defaultpg_temp_5ad_context_info51206512055127651275
etendopg_defaultprofilelast_stat_tables328883351328884618652906877482870334
etendopg_defaultpg_temp_4ad_context_info25950259492602126020
etendopg_defaultpg_catalogpg_attribute242032420392950612864911215510
etendopg_defaultpg_temp_5ad_context_info12532125321253212532
etendopg_defaultpg_catalogpg_statistic164551354021731810232183399
pg_statistic(TOAST)240923991383121456
etendopg_defaultprofilelast_stat_user_functions82571096825746383241607
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class1874672818741375607717624506616735604486
etendopg_defaultpg_catalogpg_depend45884588102058324420049924
etendopg_defaultprofilesample_stat_tables33513368256063691433555
etendopg_defaultpg_catalogpg_type21652165123060010139194410
etendopg_defaultpublicad_session_usage_audit40084286708
ad_session_usage_audit(TOAST)
etendopg_defaultprofilesample_statements14101474495103871181474
sample_statements(TOAST)
etendopg_defaultpublicad_audit_trail285935683221317263
ad_audit_trail(TOAST)
etendopg_defaultprofilesample_stat_indexes13021322222077541451392
postgrespg_defaultpg_catalogpg_attribute121512153781181809441025

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
etendopg_defaultpublicc_invoice29051960623123
c_invoice(TOAST)
etendopg_defaultpg_temp_7ad_context_info126534
etendopg_defaultpg_temp_3ad_context_info75840
etendopg_defaultprofilelast_stat_indexes1353254119264723
etendopg_defaultpg_temp_5ad_context_info51205
etendopg_defaultprofilelast_stat_tables33514632888264723
etendopg_defaultpg_temp_4ad_context_info25949
etendopg_defaultpg_catalogpg_attribute24203111
etendopg_defaultpg_catalogpg_statistic16455135401
pg_statistic(TOAST)23994
etendopg_defaultpg_temp_5ad_context_info12532
etendopg_defaultprofilelast_stat_user_functions1096468257264723
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class672813751874111
etendopg_defaultpg_catalogpg_depend458811
etendopg_defaultprofilesample_stat_tables336812
etendopg_defaultpublicad_session22302211119
ad_session(TOAST)
etendopg_defaultpg_catalogpg_type2165111
etendopg_defaultprofilesample_statements147412
sample_statements(TOAST)
etendopg_defaultprofilesample_stat_indexes13222
etendopg_defaultpublicprsync_entry898864374112
prsync_entry(TOAST)391
postgrespg_defaultpg_catalogpg_attribute1215111

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_7ad_context_info8384 kB8384 kB126535126534
etendopg_defaultpg_temp_5ad_context_info3384 kB3384 kB5120651205
etendopg_defaultpg_temp_4ad_context_info1720 kB1720 kB2595025949
etendopg_defaultpublicad_process_run11 MB648 kB304304315
ad_process_run(TOAST)72 kB32 kB
etendopg_defaultprofilesample_stat_indexes1432 kB184 kB13021322
etendopg_defaultprofilesample_stat_user_functions560 kB104 kB1029921
etendopg_defaultprofilesample_stat_tables_total336 kB56 kB152184
etendopg_defaultpublicc_invoice23 MB48 kB73290519606
c_invoice(TOAST)
etendopg_defaultprofilesample_stat_database232 kB48 kB5664
etendopg_defaultprofilesample_stat_tables7048 kB40 kB33513368
etendopg_defaultprofilesample_stat_indexes_total96 kB32 kB6064
etendopg_defaultprofilesample_statements_total136 kB32 kB3639
sample_statements_total(TOAST)
etendopg_defaultprofilesample_stat_user_func_total56 kB32 kB2230
etendopg_defaultpublicad_ep_instance_para32 kB24 kB922922
ad_ep_instance_para(TOAST)
etendopg_defaultpublicfin_payment_schedule15 MB16 kB93321622
fin_payment_schedule(TOAST)
etendopg_defaultprofilelast_stat_indexes1568 kB8192 bytes541191353541192
etendopg_defaultpg_temp_6ad_context_info8192 bytes8192 bytes126125
etendopg_defaultpg_temp_9ad_context_info8192 bytes8192 bytes3635

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
etendopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx83616725208161.38
etendopg_defaultpublicpsat_activity_materialspsat_activity_mater_produni1971923176441.26
etendopg_defaultpublicc_invoicec_invoice_key30586518086910.99
etendopg_defaultpg_catalogpg_classpg_class_oid_index58860911996660.65
etendopg_defaultpublicc_elementvaluec_elementvalue_key52956910592580.58
etendopg_defaultpublicc_invoicec_invoice_bpartner4552910264300.56
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc8820240.48
etendopg_defaultpublicm_productm_product_key4125248214090.45
etendopg_defaultpublicm_productpricem_productprice_key2441467342090.40
etendopg_defaultpublicc_invoicec_invoice_posted14807003580.38
etendopg_defaultpublicc_invoicec_invoice_paid6945140.38
etendopg_defaultpublicc_invoicec_invoice_salesrep6509350.36
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index2857546298530.34
etendopg_defaultpublicc_invoicec_invoice_updated5954340.32
etendopg_defaultpublicc_invoicec_invoice_docno845867030.32
etendopg_defaultpublicc_debt_paymentc_debt_payment_invoice_idx2886785787440.32
etendopg_defaultpublicm_product_trlm_product_trl_product_langu_un5072175074850.28
etendopg_defaultpublicad_tabad_tab_window2329484703550.26
etendopg_defaultpublicc_bpartnerc_bpartner_key1929883882690.21
etendopg_defaultpublicpsat_checklist_resultpsat_chcklist_res_result_uk7113497990.19

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
etendopg_defaultpublicpsat_checklist_resultpsat_chcklist_res_result_uk71133350.0299.05
etendopg_defaultpublicad_audit_trailad_audit_trail_pk26950.0276.45
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc14310.0199.84
etendopg_defaultpublicfact_acctfact_acct_dateacct9912440.0191.58
etendopg_defaultpublicc_invoicec_invoice_paid11210.0199.84
etendopg_defaultpublicc_orderlinec_orderline_order2674239940.0199.51
etendopg_defaultpublicc_orderlinec_orderline_key176889060.0198.29
etendopg_defaultpublicad_image(TOAST)pg_toast_74472_index137838850.0197.96
etendopg_defaultpublicc_invoicec_invoice_posted14808700.0199.88
etendopg_defaultpublicm_inoutlinem_inoutline_orderline160928700.0198.21
etendopg_defaultpublicc_invoicec_invoice_docno846980.0099.88
etendopg_defaultpublicc_invoicec_invoice_updated5480.0099.91
etendopg_defaultpublicad_session_usage_auditad_session_usage_audit_key5090.0093.99
etendopg_defaultpublicc_invoicelinec_invoiceline_orderline17044770.0091.08
etendopg_defaultpublicc_invoicec_invoice_bpartner455293670.0099.96
etendopg_defaultpublicc_invoicec_invoice_key3058653460.0099.98
etendopg_defaultpublicadvcrm_activity_relatedadvcrm_unique_project33300.0068.39
etendopg_defaultpublicc_invoicec_invoice_salesrep3110.0099.95
etendopg_defaultpublicfin_payment_scheduledetailfin_pay_scheduledetail_in12913060.0092.15
etendopg_defaultpublicfact_acctfact_acct_key103010.0067.35

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
etendopg_defaultprofilesample_statementsix_sample_stmts_qid928 kB312 kB11081210
etendopg_defaultpublicad_process_runad_process_run_key408 kB104 kB146146315
etendopg_defaultpublicc_invoicec_invoice_bpartner2640 kB96 kB73289913
etendopg_defaultpublicc_invoicec_invoice_ad_user1608 kB64 kB73289913
etendopg_defaultprofilesample_statementspk_sample_statements_n488 kB56 kB632626
etendopg_defaultpublicc_invoicec_invoice_order1376 kB32 kB73289913
etendopg_defaultpublicc_invoicec_invoice_paid1968 kB32 kB73289913
etendopg_defaultpublicc_invoicec_invoice_updated1608 kB32 kB73289913
etendopg_defaultprofilesample_stat_user_functionspk_sample_stat_user_functions240 kB32 kB176167
etendopg_defaultpublicc_invoicec_invoice_key2768 kB16 kB73289913
etendopg_defaultprofilelast_stat_tablespk_last_stat_tables232 kB16 kB32888330532888
etendopg_defaultpublicc_invoicec_invoice_docno2152 kB8192 bytes73289913
etendopg_defaultprofilesample_statements_totalpk_sample_statements_total40 kB8192 bytes2124

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
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc4024 kB-8192 bytes73289913
etendopg_defaultpublicc_invoicec_invoice_paid1968 kB32 kB73289913
etendopg_defaultpublicc_invoicec_invoice_updated1608 kB32 kB73289913
etendopg_defaultpublicc_invoicec_invoice_bp_extref_idx8192 bytes73289913
etendopg_defaultpublicc_invoicec_invoice_salesrep1872 kB-24 kB73289913
etendopg_defaultpublicad_process_runad_process_run_ould_be_killed8192 bytes225225315

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicad_column_identifier9817024.5724.160.0000.000
etendoprofiletake_sample2316.690.020.7260.001
etendoprofiletake_sample_subset2316.670.060.7250.002
etendoprofiletake_sample2316.621.650.7220.072
etendoprofilecollect_obj_stats239.152.770.3980.120
etendopublicad_istriggerenabled11692098.938.930.0000.000
etendoprofiledblink6217.967.960.0130.013
etendopublicc_invoice_post995.041.270.0510.013
etendopublicc_invoice_post0984.980.010.0510.000
etendopublicad_org_isinnaturaltree2457364.671.280.0000.000
etendopublicad_isorgincluded2781114.134.130.0000.000
etendoprofilesample_dbobj_delta233.543.540.1540.154
etendopublicad_extension_point_handler2243.190.120.0140.001
etendopublicto_char31216362.492.490.0000.000
etendopublicprouti_ep_updatepurchasecol1251.451.430.0120.011
etendopublicprouti_qtyremainingorderline182281.281.280.0000.000
etendopublicaprm_gen_paymentschedule_inv921.150.640.0130.007
etendopublicto_date1080630.840.840.0000.000
etendopublicprouti_deliveryavailable46140.830.830.0000.000
etendopublicc_order_post160.820.000.0510.000

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicto_char31216362.492.490.0000.000
etendopublicad_istriggerenabled11692098.938.930.0000.000
etendopublicobequals4266640.440.440.0000.000
etendopublicto_char3724610.810.810.0000.000
etendopublicto_char3722240.590.590.0000.000
etendopublicto_number3262460.800.800.0000.000
etendopublicad_isorgincluded2781114.134.130.0000.000
etendopublicad_org_isinnaturaltree2457364.671.280.0000.000
etendopublicto_date1080630.840.840.0000.000
etendopublicad_column_identifier9817024.5724.160.0000.000
etendopublicadd_days578220.060.060.0000.000
etendopublicto_char293670.080.080.0000.000
etendopublicuuid_generate_v4263040.290.290.0000.000
etendopublicprouti_qtyremainingorderline182281.281.280.0000.000
etendopublicc_currency_convert_precision142170.050.050.0000.000
etendopublicc_currency_convert142150.120.070.0000.000
etendopublicsubstract_days123340.010.010.0000.000
etendopublicaprm_ispaymentconfirmed100820.820.820.0000.000
etendopublicget_uuid87680.530.240.0000.000
etendopublicto_date83040.040.040.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicc_invoice_trg29059223.0818.500.0000.000
etendopublicc_invoice_trg22905926.364.610.0000.000
etendopubliceinv_gene_chk_restrictions_trg2905194.152.690.0000.000
etendopublicpruti_inherit_invoice_contact2905923.742.710.0000.000
etendopublicau_c_bpartner_trg1200.630.620.0050.005
etendopublicc_invoiceline_trg23810.580.210.0020.001
etendopublicau_advcrm_activity_trg1580.470.410.0030.003
etendopublicau_m_product_trg90.350.320.0390.036
etendopublicc_orderline_trg21640.260.100.0020.001
etendopublicc_invoiceline_trg33810.250.220.0010.001
etendopublicc_invoicelinetax_trg1580.220.120.0010.001
etendopublicad_preference_mod_trg3290.100.090.0000.000
etendopublicc_invoiceline_before_trg3780.090.090.0000.000
etendopublicc_invline_chk_restrictions_trg3730.090.080.0000.000
etendopublicm_inoutline_trg490.090.040.0020.001
etendopublicm_transaction_trg750.070.040.0010.001
etendopublicc_orderlinetax_trg760.070.050.0010.001
etendopublicc_invoicetax_trg2570.060.060.0000.000
etendopublicau_m_productprice_trg170.060.050.0030.003
etendopublicc_orderline2_trg1490.060.040.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables263288833513288846
etendopg_defaultprofilelast_stat_indexes26541191353541192
etendopg_defaultprofilelast_stat_user_functions2682571096825746
etendopg_defaultpublicc_invoice2373290519606
etendopg_defaultpublicad_ep_instance_para16922922
postgrespg_defaultpg_catalogpg_type1157157
postgrespg_defaultpg_catalogpg_attribute112151215
postgrespg_defaultpg_catalogpg_class1107388107129
postgrespg_defaultpg_catalogpg_statistic1478361
etendopg_defaultpg_catalogpg_type121652165
etendopg_defaultpg_catalogpg_attribute12420324203
etendopg_defaultpg_catalogpg_class11874672818741375
etendopg_defaultpg_catalogpg_index1527527
etendopg_defaultpg_catalogpg_statistic11645513540
etendopg_defaultpublicad_process_run1304304315
etendopg_defaultpublicprsync_entry1450898374864
etendopg_defaultprofilelast_stat_database19292

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables47233288833513288846
etendopg_defaultprofilelast_stat_indexes4723541191353541192
etendopg_defaultprofilelast_stat_user_functions472382571096825746
etendopg_defaultpublicad_ep_instance_para28922922
etendopg_defaultpublicc_invoice12373290519606
etendopg_defaultprofilelast_stat_tablespaces244646
etendopg_defaultpublicad_session1191922302211
etendopg_defaultpublicad_process_request15312307
etendopg_defaultprofilelast_stat_database139292
postgrespg_globalpg_catalogpg_tablespace3
postgrespg_globalpg_catalogpg_shdepend3711710
postgrespg_globalpg_catalogpg_authid3
postgrespg_globalpg_catalogpg_auth_members3
postgrespg_globalpg_catalogpg_database3
postgrespg_globalpg_catalogpg_shdescription3
postgrespg_globalpg_catalogpg_shseclabel3
postgrespg_globalpg_catalogpg_subscription3
etendopg_globalpg_catalogpg_pltemplate3
etendopg_globalpg_catalogpg_tablespace3
etendopg_globalpg_catalogpg_shdepend3710710

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc90 MB234001 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_key62 MB232758 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_bpartner58 MB232572 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_docno48 MB232145 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_paid43 MB231917 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_posted43 MB231899 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_salesrep41 MB231832 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_updated36 MB231585 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_ad_user35 MB231554 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_order30 MB231350 kB23 MB
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes10 MB26392 kB1529 kB
etendopg_defaultprofilelast_stat_tablespk_last_stat_tables5768 kB26221 kB1210 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index1016 kB11016 kB4328 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index664 kB1664 kB4328 kB
etendopg_defaultpublicprsync_entryprsync_entry_key400 kB1400 kB3544 kB
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index376 kB1376 kB4648 kB
etendopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index336 kB485 kB3760 kB
etendopg_defaultpublicad_process_runad_process_run_ad_prequest_id328 kB1328 kB10 MB
etendopg_defaultpublicad_process_runad_process_run_key312 kB1312 kB10 MB
etendopg_defaultpublicad_ep_instance_paraad_ep_instance_para_key256 kB1616 kB30 kB

Top tables by dead tuples ratio

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

DBSchemaTableLiveDead%DeadLast AVSize
etendopg_temp_7ad_context_info1126534998384 kB
etendoprofilesample_stat_tables241563228117048 kB
etendopublicad_process_run5129531911 MB
etendopublicfin_payment_schedule6058531015 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
etendopg_temp_7ad_context_info11265342530631998384 kB
etendopublicad_process_run512953143072026-07-13 01:10:07.037084+0211 MB
etendoprofilesample_stat_tables24156322893032026-07-13 23:00:44.011478+027048 kB
etendopublicfin_payment_schedule605853114102025-05-14 08:30:29.130156+0215 MB

Cluster settings during the report interval

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