Postgres profile report (StartID: 522, EndID: 545)

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-15 04:00:01+02 - 2026-07-16 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
etendo2024024499.69510479162927683453899479320199206705123230824311332858 MB3128 kB
postgres1186999.8411617031071985100365365201286617726431 kB48 kB
Total2142714499.69511640163630790455884579323852856725243239484329052864 MB3176 kB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
etendo8079337715.8545.22104442112703267802041742422243217274
postgres561912.80127492225349
template163429.0347937237278
Total8091298737.6845.22104617541703267802046362422243217901

Cluster statistics

MetricValue
Scheduled checkpoints275
Requested checkpoints1
Checkpoint write time (s)9645.54
Checkpoint sync time (s)4.12
Checkpoints buffers written114511
Background buffers written
Backend buffers written142856
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated505711
WAL generated3680 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default2878 MB3176 kB
pg_global542 kB

SQL query statistics

Top SQL by execution time

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

adb1c31f79

[948be82f]

etendo141.9319.24141929.886141929.886141929.8861

4108c96b3f

[ca2988bd]

etendo121.5916.481837894.074811.0361511.47181.486136

73e3636bec

[f410d7e7]

etendo76.4310.362882890.2650.1336.2320.089288289

228d74fbf5

[cd9c0fd2]

etendo33.144.491346733143.33933143.33933143.3391

44dc303aa7

[5048ce93]

etendo30.004.07225621.1200.9658.7950.21626780

30f8741426

[754ab419]

etendo22.403.04756000.2960.0074.1080.15175600

0c133f89fa

[47df1ade]

etendo17.582.3823764.322665.6481659.805200.47823

b9bb8a4422

[eb812a48]

etendo17.572.38764.083665.4601659.626200.48623

f97c043282

[ba2aa98f]

etendo16.812.28631240.2660.0043.1630.13663125

c9e2eb425b

[de5cc8a]

etendo12.591.7131812460.0030.0024.3520.0034809183

bae62a2427

[1e392225]

etendo8.921.21378120.2360.0083.3240.12737812

9c83facac5

[411377d4]

etendo8.881.20267800.3590.3146.1630.08424737

91da98e10b

[6388fe1]

etendo8.871.20378430.2340.0062.8150.12637843

671fe12038

[66c83919]

etendo8.651.1718995548653.7008653.7008653.7001

8b2efa3bb8

[5d8577b1]

etendo6.820.92126020.5410.1743.5450.15912602

503324b603

[d34207c3]

etendo6.150.832535520.0210.0051.0380.011289259

11b3a7981f

[61e12bc8]

etendo5.560.75308694.619676.854716.29412.6818

73e6ea4442

[e5d755b6]

etendo5.480.74253700.2160.0044.5660.13125371

0b651ca53d

[7318d810]

etendo5.290.726744315287.3965287.3965287.3961

1d911b5cd9

[1c4d8fed]

etendo5.220.7113763.7921.72213.6731.3571376

Top SQL by executions

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

c9e2eb425b

[de5cc8a]

etendo480918359.4431812460.0030.0024.3520.00312.6

9625146448

[b7edb1a4]

etendo2896403.582896400.0100.0070.6670.0052.9

0c13a0abe2

[4ed26d58]

etendo2892703.58312550.0110.0066.5430.0143.1

503324b603

[d34207c3]

etendo2892593.572535520.0210.0051.0380.0116.1

73e3636bec

[f410d7e7]

etendo2882893.562882890.2650.1336.2320.08976.4

9ea37f4950

[39cec726]

etendo2564103.172564100.0090.0070.6810.0042.4

df99961951

[9cb9259b]

etendo1628862.011628860.0180.0120.4460.0072.9

1b3d7b3f6d

[a00bdbff]

etendo1355391.680.0070.0040.5170.0031.0

891e82e5c1

[5a0bb3c]

etendo1009391.251009390.0030.0021.0850.0050.3

42c36ef013

[a8fa8b7f]

etendo756030.93756030.0050.0030.5510.0050.4

30f8741426

[754ab419]

etendo756000.93756000.2960.0074.1080.15122.4

f97c043282

[ba2aa98f]

etendo631250.78631240.2660.0043.1630.13616.8

672a36c08c

[1d47a1d6]

etendo631250.78631250.0050.0030.4030.0050.3

5c208ba241

[381eb299]

etendo535340.66535340.0140.0100.4140.0050.7

fa1b74d06f

[c1b84187]

etendo471680.583437500.0410.0152.3980.0411.9

ebd66f2e50

[2f2197e3]

etendo471680.58294140.0130.0050.2600.0080.6

9a14d74991

[9dd4b5e8]

etendo380360.47380360.0050.0020.4790.0060.2

91da98e10b

[6388fe1]

etendo378430.47378430.2340.0062.8150.1268.9

0cabfbfcff

[431cc709]

etendo378340.47378340.0050.0030.5330.0050.2

bae62a2427

[1e392225]

etendo378120.47378120.2360.0083.3240.1278.9

Top SQL by shared blocks fetched

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

4108c96b3f

[ca2988bd]

etendo2783519726.61100.00121.61837136

73e3636bec

[f410d7e7]

etendo95405779.1299.9776.4288289288289

44dc303aa7

[5048ce93]

etendo89589728.56100.0030.02256226780

0c133f89fa

[47df1ade]

etendo49253354.7199.9817.62323

b9bb8a4422

[eb812a48]

etendo49251974.7199.9817.623

c9e2eb425b

[de5cc8a]

etendo48091834.60100.0012.631812464809183

adb1c31f79

[948be82f]

etendo30393292.9184.24141.91

9c83facac5

[411377d4]

etendo29361942.81100.008.92678024737

58d3d7b94c

[303fdc1e]

etendo23541322.25100.001.4242823

11b3a7981f

[61e12bc8]

etendo23421642.2499.995.63088

c2b6cfc2bf

[ad3afc69]

etendo22038362.11100.004.27089471953

33cc012c09

[c910dbed]

etendo21966292.10100.002.66969

50a5548e03

[290a395c]

etendo19082131.8299.902.258914

785a907bc3

[92946197]

etendo16351461.5699.974.799023

5fa24dc926

[22217272]

etendo16181191.55100.002.25103723

29e9be51ce

[b8952a6a]

etendo11917111.14100.002.167141119

75cdc9279a

[c0534667]

etendo9763380.93100.002.722

9625146448

[b7edb1a4]

etendo9081340.87100.002.9289640289640

0c13a0abe2

[4ed26d58]

etendo9062090.87100.003.131255289270

503324b603

[d34207c3]

etendo8311270.79100.006.1253552289259

Top SQL by shared blocks read

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

adb1c31f79

[948be82f]

etendo47911893.4884.24141.91

f8cc1c12b0

[4f2bfd2e]

etendo32310.6399.461.82519

73e3636bec

[f410d7e7]

etendo24010.4799.9776.4288289288289

50b8978166

[b54ea3e2]

etendo20840.4198.280.717

50a5548e03

[290a395c]

etendo18210.3699.902.258914

12a81791af

[7eea2aca]

etendo17370.3497.460.267336733

9cbca4d83c

[b7b6a128]

etendo13100.2687.910.111601160

0c247acdf0

[948be82f]

template19750.1997.612.81

0c133f89fa

[47df1ade]

etendo9600.1999.9817.62323

b9bb8a4422

[eb812a48]

etendo9600.1999.9817.623

2e0b729b87

[948be82f]

postgres9460.1897.672.81

b8b9950890

[532de794]

etendo7040.1498.690.719591959

cbb0d2e65e

[4ec9dd54]

etendo6790.1391.790.21010

de891c1f5b

[a3acbb25]

etendo5810.1188.900.04

6951a2f5d4

[43f0ca83]

etendo5450.1187.310.0209209

93accebb93

[bdc0f458]

etendo5100.1099.370.259584

785a907bc3

[92946197]

etendo4970.1099.974.799023

bc23716c25

[d706119e]

etendo4260.0833.850.01501

b1ad12ea83

[da3ad8a5]

etendo4220.0896.790.29393

1e43f28979

[c3f6c9c8]

etendo4110.0891.990.233

Top SQL by shared blocks dirtied

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

73e3636bec

[f410d7e7]

etendo6615432.3399.9776.4288289288289

adb1c31f79

[948be82f]

etendo6281530.7084.24141.91

0c133f89fa

[47df1ade]

etendo160207.8399.9817.62323

b9bb8a4422

[eb812a48]

etendo160207.8399.9817.623

fdd1193fad

[3b0e4e8a]

etendo41582.0399.963.75411946

d0b36135c7

[a0544a5f]

etendo31941.5699.963.73289046

b8b9950890

[532de794]

etendo29451.4498.690.719591959

140f3eb685

[59d1e156]

etendo18550.9199.541.02323

c525c04235

[d2f1c69a]

etendo14730.7299.280.1289289

9cbca4d83c

[b7b6a128]

etendo14130.6987.910.111601160

167f11efcd

[76ede534]

etendo12860.6399.860.11

9b16673e73

[423e83ff]

etendo12800.6398.920.11

f68dd8a1a9

[d422fd3a]

etendo10220.50100.000.744

4813705ddb

[6f2d0383]

etendo8160.40100.000.313411341

cbb0d2e65e

[4ec9dd54]

etendo6880.3491.790.21010

174962df65

[f75cc0f0]

etendo6580.3296.740.1284284

6a18f0bfd3

[b26b8c5c]

etendo5100.2598.510.1437437

1e43f28979

[c3f6c9c8]

etendo4730.2391.990.233

07181527b0

[f6f43f8d]

etendo4530.22100.000.03294214

b1ad12ea83

[da3ad8a5]

etendo4280.2196.790.29393

Top SQL by shared blocks written

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

adb1c31f79

[948be82f]

etendo5832022.6640.8284.24141.91

0c247acdf0

[948be82f]

template1550.020.0497.612.81

2e0b729b87

[948be82f]

postgres550.020.0497.672.81

Top SQL by temp usage

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

42c36ef013

[a8fa8b7f]

etendo7748199.1962925.860.47560375603

672a36c08c

[1d47a1d6]

etendo6469499.1952621.630.36312563125

0cabfbfcff

[431cc709]

etendo3877699.1831713.030.23783437834

9a14d74991

[9dd4b5e8]

etendo3897899.1931713.030.23803638036

81cc426779

[46877beb]

etendo2599899.182128.720.12537125371

ff457cdd0b

[d9039e57]

etendo2584799.182128.720.12522025220

c08aa8dece

[4f3a6e26]

etendo1290599.171074.400.11259312593

3206d9f66d

[ed220fa0]

etendo1291499.191044.280.11260212602

971157465f

[29915bc4]

etendo4197.5610.040.04141

5b4cd5cfb2

[3690ec76]

etendo8798.8510.040.08787

bc97791e8a

[3a9e42cc]

etendo6298.3910.040.06262

14877321dd

[7af77c2e]

etendo6298.3910.040.06262

cd763a3fab

[cd1d3b6d]

etendo4297.6210.040.04242

4ea59d9fea

[d3a32005]

etendo2596.0010.040.02525

d14c05e898

[da9cf904]

etendo16299.3810.040.0162162

7b1c8e2529

[e285487d]

etendo3597.1410.040.03535

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
91da98e10bdelete from ad_context_info
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
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
672a36c08cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
bae62a2427delete from ad_context_info
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)
50a5548e03SELECT * FROM ( SELECT $10 AS RN1, C.* FROM ( SELECT VALUE, NAME, DATEACCT, COALESCE(SUM(AMTACCTDR),$11) AS AMTACCTDR, COALESCE(SUM(AMTACCTCR),$12) AS AMTACCTCR, COALESCE(SUM(AMTACCTDR-AMTACCTCR),$13) AS TOTAL, MAX(FACT_ACCT_ID) AS FACT_ACCT_ID, FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname, DESCRIPTION, ISDEBIT, $14 AS TOTALACCTDR, $15 AS TOTALACCTCR, $16 AS TOTALACCTSUB, $17 AS PREVIOUSDEBIT, $18 AS PREVIOUSCREDIT, $19 AS PREVIOUSTOTAL, $20 AS FINALDEBIT, $21 AS FINALCREDIT, $22 AS FINALTOTAL, TO_CHAR(DATEACCT,$23) AS DATEACCTNUMBER, $1 AS groupby, $24 as bpid, $25 as bpname, $26 as pdid, $27 as pdname, $28 as pjid, $29 as pjname, factaccttype , $30 AS AMTACCTDRPREVSUM, $31 AS AMTACCTCRPREVSUM FROM (SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME, DATEACCT, AMTACCTDR, AMTACCTCR, FACT_ACCT_ID, FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION, CASE $2 WHEN $32 THEN c_bpartner.c_bpartner_id WHEN $33 THEN m_product.m_product_id WHEN $34 THEN c_project.c_project_id ELSE $35 END AS groupbyid, CASE $3 WHEN $36 THEN (select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) WHEN $37 THEN (select to_char(value || $38 || name) from m_product p where p.m_product_id = m_product.m_product_id) WHEN $39 THEN (select to_char(value || $40 || name) from c_project pj where pj.c_project_id = c_project.c_project_id) ELSE $41 END AS groupbyname, CASE WHEN (AMTACCTDR > $42 AND AMTACCTCR = $43) OR (AMTACCTCR < $44 AND AMTACCTDR = $45) THEN $46 ELSE $47 END AS ISDEBIT, CASE WHEN FACT_ACCT.FACTACCTTYPE = $48 THEN $49 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = $50 THEN $51 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = $52 THEN $53 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = $54 THEN $55 END) END) END) END AS FACTACCTTYPE FROM FACT_ACCT LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE ($4=$56 OR FACT_ACCT.ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = $5) and value <= ( select value from c_elementvalue where c_elementvalue_id = $6) and c_elementvalue.ELEMENTLEVEL = $57 )) AND FACT_ACCT.AD_ORG_ID IN ($58,$59,$60,$61) AND FACT_ACCT.AD_CLIENT_ID IN ($62,$63) AND $64=$65 AND FACT_ACCT.C_ACCTSCHEMA_ID = $7 AND FACT_ACCT.DATEACCT >= TO_DATE($8) AND FACT_ACCT.DATEACCT < TO_DATE($9) AND FACT_ACCT.AD_ORG_ID IN ($66) AND $67=$68 AND $69=$70) D WHERE $71=$72 GROUP BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> $73 ORDER BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, FACT_ACCT_ID, DESCRIPTION, ISDEBIT LIMIT $74 OFFSET $75 ) C ) B WHERE $76=$77
971157465finsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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)
5b4cd5cfb2insert 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
bc97791e8ainsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
9b16673e73vacuum analyze AD_Process_Run
0cabfbfcffinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
6951a2f5d4SELECT CASE WHEN MIN(a.suma) = $2 THEN $3 ELSE ROUND(COALESCE(SUM(ABS(inv.qtyinvoiced)), $4)/MIN(a.suma) * $5, $6) END FROM m_inoutline minline JOIN c_invoiceline inv on minline.m_inoutline_id=inv.m_inoutline_id, (SELECT COALESCE(SUM(ABS(g.movementqty)), $7) AS suma FROM m_inoutline g WHERE g.m_inout_id =p_minoutid ) a WHERE minline.m_inout_id=p_minoutid AND EXISTS (SELECT $8 FROM c_invoice i WHERE i.c_invoice_id = inv.c_invoice_id AND i.processed = $9 AND i.docstatus <> $10 AND i.docstatus <> $11 AND i.docstatus <> $12)
81cc426779insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
0c133f89faSELECT profile.take_sample()
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)
c08aa8deceinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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)
8b2efa3bb8delete from ad_context_info
11b3a7981fselect invoicecan0_.C_Order_ID as col_0_0_, organizati2_.Name as col_1_0_, invoicecan0_.C_Doctype_ID as col_2_0_, invoicecan0_.Documentno as col_3_0_, businesspa3_.Name as col_4_0_, invoicecan0_.Dateordered as col_5_0_, case when $5=$6 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end as col_6_0_, case when invoicecan0_.Term=$7 then $8 when invoicecan0_.Term=$9 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $10=$11 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $12=$13 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end as col_7_0_, invoicecan0_.Term as col_8_0_, case when invoicecan0_.Term=$14 then $15 when invoicecan0_.Term=$16 then case when invoicecan0_.Term=$17 then $18 when invoicecan0_.Term=$19 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $20=$21 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $22=$23 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end when invoicecan0_.Term=$24 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then $25 else invoicecan0_.Pendinglines end as col_9_0_, invoicecan0_.Qtyordered as col_10_0_, invoicecan0_.Qtydelivered as col_11_0_, case when $26=$27 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end-(case when $28=$29 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end) as col_12_0_, invoicecan0_.Amountlinesgross as col_13_0_, invoicecan0_.Created as col_14_0_, invoicecan0_.Createdby as col_15_0_, invoicecan0_.Updated as col_16_0_, invoicecan0_.Updatedby as col_17_0_, documentty4_.C_DocType_ID as C_DocTyp1_225_0_, aduser5_.AD_User_ID as AD_User_1_129_1_, aduser6_.AD_User_ID as AD_User_1_129_2_, documentty4_.AD_Client_ID as AD_Clien2_225_0_, documentty4_.AD_Org_ID as AD_Org_I3_225_0_, documentty4_.IsActive as IsActive4_225_0_, documentty4_.Created as Created5_225_0_, documentty4_.CreatedBy as CreatedB6_225_0_, documentty4_.Updated as Updated7_225_0_, documentty4_.UpdatedBy as UpdatedB8_225_0_, documentty4_.Name as Name9_225_0_, documentty4_.PrintName as PrintNa10_225_0_, documentty4_.Description as Descrip11_225_0_, documentty4_.DocBaseType as DocBase12_225_0_, documentty4_.IsSOTrx as IsSOTrx13_225_0_, documentty4_.DocSubTypeSO as DocSubT14_225_0_, documentty4_.C_DocTypeShipment_ID as C_DocTy15_225_0_, documentty4_.C_DocTypeInvoice_ID as C_DocTy16_225_0_, documentty4_.IsDocNoControlled as IsDocNo17_225_0_, documentty4_.DocNoSequence_ID as DocNoSe18_225_0_, documentty4_.GL_Category_ID as GL_Cate19_225_0_, documentty4_.DocumentNote as Documen20_225_0_, documentty4_.IsDefault as IsDefau21_225_0_, documentty4_.DocumentCopies as Documen22_225_0_, documentty4_.AD_Table_ID as AD_Tabl23_225_0_, documentty4_.Orgfiltered as Orgfilt24_225_0_, documentty4_.C_Doctype_Reversed_ID as C_Docty25_225_0_, documentty4_.IsExpense as IsExpen26_225_0_, documentty4_.Isreversal as Isrever27_225_0_, documentty4_.IsReturn as IsRetur28_225_0_, documentty4_.C_Doctypeorder_ID as C_Docty29_225_0_, documentty4_.C_Doctypesimpinvoice_ID as C_Docty30_225_0_, documentty4_.EM_OBWPL_Useoutbound as EM_OBWP31_225_0_, documentty4_.EM_Prouti_C_Doctypeorder_ID as EM_Prou32_225_0_, documentty4_.C_Doctypeaggrinvoice_ID as C_Docty33_225_0_, documentty4_.EM_OBWPL_IsGroup as EM_OBWP34_225_0_, documentty4_.EM_OBWPL_GenerateShipment as EM_OBWP35_225_0_, documentty4_.EM_OBWPL_Shipmentdoctype_ID as EM_OBWP36_225_0_, documentty4_.EM_Pruti_Inforeport2 as EM_Prut37_225_0_, documentty4_.EM_Pruti_Inforeport as EM_Prut38_225_0_, aduser5_.AD_Client_ID as AD_Clien2_129_1_, aduser5_.AD_Org_ID as AD_Org_I3_129_1_, aduser5_.IsActive as IsActive4_129_1_, aduser5_.Created as Created5_129_1_, aduser5_.CreatedBy as CreatedB6_129_1_, aduser5_.Updated as Updated7_129_1_, aduser5_.UpdatedBy as UpdatedB8_129_1_, aduser5_.Name as Name9_129_1_, aduser5_.Description as Descrip10_129_1_, aduser5_.Password as Passwor11_129_1_, aduser5_.Email as Email12_129_1_, aduser5_.Supervisor_ID as Supervi13_129_1_, aduser5_.C_BPartner_ID as C_BPart14_129_1_, aduser5_.Processing as Process15_129_1_, aduser5_.EmailUser as EmailUs16_129_1_, aduser5_.EmailUserPW as EmailUs17_129_1_, aduser5_.C_BPartner_Location_ID as C_BPart18_129_1_, aduser5_.C_Greeting_ID as C_Greet19_129_1_, aduser5_.Title as Title20_129_1_, aduser5_.Comments as Comment21_129_1_, aduser5_.Phone as Phone22_129_1_, aduser5_.Phone2 as Phone23_129_1_, aduser5_.Fax as Fax24_129_1_, aduser5_.LastContact as LastCon25_129_1_, aduser5_.LastResult as LastRes26_129_1_, aduser5_.Birthday as Birthda27_129_1_, aduser5_.AD_OrgTrx_ID as AD_OrgT28_129_1_, aduser5_.Firstname as Firstna29_129_1_, aduser5_.Lastname as Lastnam30_129_1_, aduser5_.UserName as UserNam31_129_1_, aduser5_.Default_Ad_Client_ID as Default32_129_1_, aduser5_.Default_Ad_Language as Default33_129_1_, aduser5_.Default_Ad_Org_ID as Default34_129_1_, aduser5_.Default_Ad_Role_ID as Default35_129_1_, aduser5_.Default_M_Warehouse_ID as Default36_129_1_, aduser5_.IsLocked as IsLocke37_129_1_, aduser5_.AD_Image_ID as AD_Imag38_129_1_, aduser5_.Grant_Portal_Access as Grant_P39_129_1_, aduser5_.LastPasswordUpdate as LastPas40_129_1_, aduser5_.Isexpiredpassword as Isexpir41_129_1_, aduser5_.Commercialauth as Commerc42_129_1_, aduser5_.Viasms as Viasms43_129_1_, aduser5_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_1_, aduser5_.Viaemail as Viaemai45_129_1_, aduser5_.EM_Pruti_Isbillingcontact as EM_Prut46_129_1_, aduser5_.EM_Advcrm_Newsletter as EM_Advc47_129_1_, aduser5_.EM_Pruti_Isordercontact as EM_Prut48_129_1_, aduser5_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_1_, aduser5_.EM_Advcrm_sat_user as EM_Advc50_129_1_, aduser6_.AD_Client_ID as AD_Clien2_129_2_, aduser6_.AD_Org_ID as AD_Org_I3_129_2_, aduser6_.IsActive as IsActive4_129_2_, aduser6_.Created as Created5_129_2_, aduser6_.CreatedBy as CreatedB6_129_2_, aduser6_.Updated as Updated7_129_2_, aduser6_.UpdatedBy as UpdatedB8_129_2_, aduser6_.Name as Name9_129_2_, aduser6_.Description as Descrip10_129_2_, aduser6_.Password as Passwor11_129_2_, aduser6_.Email as Email12_129_2_, aduser6_.Supervisor_ID as Supervi13_129_2_, aduser6_.C_BPartner_ID as C_BPart14_129_2_, aduser6_.Processing as Process15_129_2_, aduser6_.EmailUser as EmailUs16_129_2_, aduser6_.EmailUserPW as EmailUs17_129_2_, aduser6_.C_BPartner_Location_ID as C_BPart18_129_2_, aduser6_.C_Greeting_ID as C_Greet19_129_2_, aduser6_.Title as Title20_129_2_, aduser6_.Comments as Comment21_129_2_, aduser6_.Phone as Phone22_129_2_, aduser6_.Phone2 as Phone23_129_2_, aduser6_.Fax as Fax24_129_2_, aduser6_.LastContact as LastCon25_129_2_, aduser6_.LastResult as LastRes26_129_2_, aduser6_.Birthday as Birthda27_129_2_, aduser6_.AD_OrgTrx_ID as AD_OrgT28_129_2_, aduser6_.Firstname as Firstna29_129_2_, aduser6_.Lastname as Lastnam30_129_2_, aduser6_.UserName as UserNam31_129_2_, aduser6_.Default_Ad_Client_ID as Default32_129_2_, aduser6_.Default_Ad_Language as Default33_129_2_, aduser6_.Default_Ad_Org_ID as Default34_129_2_, aduser6_.Default_Ad_Role_ID as Default35_129_2_, aduser6_.Default_M_Warehouse_ID as Default36_129_2_, aduser6_.IsLocked as IsLocke37_129_2_, aduser6_.AD_Image_ID as AD_Imag38_129_2_, aduser6_.Grant_Portal_Access as Grant_P39_129_2_, aduser6_.LastPasswordUpdate as LastPas40_129_2_, aduser6_.Isexpiredpassword as Isexpir41_129_2_, aduser6_.Commercialauth as Commerc42_129_2_, aduser6_.Viasms as Viasms43_129_2_, aduser6_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_2_, aduser6_.Viaemail as Viaemai45_129_2_, aduser6_.EM_Pruti_Isbillingcontact as EM_Prut46_129_2_, aduser6_.EM_Advcrm_Newsletter as EM_Advc47_129_2_, aduser6_.EM_Pruti_Isordercontact as EM_Prut48_129_2_, aduser6_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_2_, aduser6_.EM_Advcrm_sat_user as EM_Advc50_129_2_ from c_invoice_candidate_v invoicecan0_ inner join C_Order order1_ on invoicecan0_.C_Order_ID=order1_.C_Order_ID inner join AD_Org organizati2_ on invoicecan0_.AD_Org_ID=organizati2_.AD_Org_ID inner join C_BPartner businesspa3_ on invoicecan0_.C_Bpartner_ID=businesspa3_.C_BPartner_ID inner join C_DocType documentty4_ on invoicecan0_.C_Doctype_ID=documentty4_.C_DocType_ID inner join AD_User aduser5_ on invoicecan0_.Createdby=aduser5_.AD_User_ID inner join AD_User aduser6_ on invoicecan0_.Updatedby=aduser6_.AD_User_ID where (invoicecan0_.Term=$30 and invoicecan0_.Qtydelivered<>$31 and ($32=$33 and (exists (select $34 from C_OrderLine orderline7_ where orderline7_.C_Order_ID=order1_.C_Order_ID and orderline7_.QtyDelivered-orderline7_.QtyInvoiced<>$35)) or $36=$37) or invoicecan0_.Term=$38 and (exists (select $39 from C_OrderLine orderline8_ where orderline8_.C_Order_ID=order1_.C_Order_ID and orderline8_.QtyOrdered-orderline8_.QtyInvoiced<>$40)) or invoicecan0_.Term=$41 and (exists (select $42 from C_OrderLine orderline9_ where orderline9_.C_Order_ID=order1_.C_Order_ID and orderline9_.QtyDelivered<>$43 and orderline9_.QtyOrdered<>orderline9_.QtyInvoiced))) and (invoicecan0_.AD_Client_ID in ($44 , $1)) and (invoicecan0_.AD_Org_ID in ($2 , $3)) order by organizati2_.Name, businesspa3_.Name, invoicecan0_.Dateordered limit $4
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
4813705ddbupdate C_Invoice set Updated=$1, DaysTillDue=$2, LastCalculatedOnDate=$3 where C_Invoice_ID=$4
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
30f8741426delete from ad_context_info
167f11efcdvacuum analyze prsync_entry
14877321ddinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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)
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)
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
9a14d74991insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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 )
de891c1f5bselect shipmentin0_.M_InOut_ID as M_InOut_1_415_0_, shipmentin0_.AD_Client_ID as AD_Clien2_415_0_, shipmentin0_.AD_Org_ID as AD_Org_I3_415_0_, (select C_GETINVOICESTATUSFROMSHIPMENT(shipmentin0_.m_inout_id) from dual) as formula26_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_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)
42c36ef013insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
6a18f0bfd3insert into prsync_entry (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Jsonentry, Type_Of_Data, Status, Process, Processing, Prsync_Entry_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
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)
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
f97c043282delete from ad_context_info
93accebb93SELECT o.C_Order_ID, org.Name as adorgname, COALESCE(dttrl.Name, dt.Name) as cdoctypename, o.DocumentNo, bp.Name as cbpartnername, o.DateOrdered, o.totallines as amountlines, ( SELECT sum((ol.qtyordered - ol.qtydelivered) * ol.priceactual) FROM c_orderline ol WHERE ol.c_order_id = o.c_order_id AND ol.qtyordered <> ol.qtydelivered AND ol.directship = $2 AND ol.m_product_id IS NOT NULL ) as TotalLines FROM C_Order o JOIN AD_Org org ON o.AD_Org_ID = org.AD_Org_ID JOIN C_BPartner bp ON o.C_BPartner_ID = bp.C_BPartner_ID JOIN C_DocType dt ON o.C_DocType_ID = dt.C_DocType_ID LEFT JOIN C_DocType_trl dttrl ON dt.C_DocType_ID = dttrl.C_DocType_ID AND dttrl.ad_language = $1 WHERE o.docstatus = $3 AND o.isdelivered = $4 AND dt.isreturn = $5 AND dt.docbasetype = $6 AND dt.docsubtypeso NOT IN ($7, $8, $9) AND EXISTS ( SELECT $10 FROM C_ORDERLINE ol WHERE ol.c_order_id = o.c_order_id AND ol.qtyordered <> ol.qtydelivered AND ol.directship = $11 AND ol.m_product_id IS NOT NULL ) AND o.ad_client_id IN ($12,$13) AND o.ad_org_id IN ($14,$15,$16,$17) AND $18=$19 AND $20=$21 AND o.ad_org_id IN ($22) ORDER BY org.Name, bp.Name, DateOrdered
75cdc9279aSELECT td0.AD_User_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),$2)),$3)) AS NAME, $4 AS DESCRIPTION FROM AD_User td0 WHERE td0.AD_Client_ID IN ($5,$6) AND td0.AD_Org_ID IN ($7,$8) AND (EXISTS (select ad_user_id from ad_user left join c_bpartner on td0.c_bpartner_id=c_bpartner.c_bpartner_id where c_bpartner.isemployee=$9)) AND (td0.isActive = $10 OR td0.AD_User_ID = ($1) ) ORDER BY 2 LIMIT $11 OFFSET $12
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)
33cc012c09select count(*) AS TOTAL from ad_column c, ad_field f, ad_tab tb, ad_table t, ad_window_access wa, ad_window w, ad_role r where r.ad_role_ID = $1 and ad_reference_value_ID = $2 and ad_reference_id = $3 and f.ad_column_id = c.ad_column_id and tb.ad_tab_id = f.ad_tab_id and tb.ad_window_id = wa.ad_window_id and tb.ad_window_id = w.ad_window_id and wa.ad_role_id = r.ad_role_id and wa.isactive = $4 and w.isactive=$5 and t.isActive=$6 and tb.isActive=$7 and tb.ad_table_id = t.ad_table_id and ( (TO_NUMBER(t.accessLevel)=$8 and instr(r.userLevel,$9)!=$10) or (TO_NUMBER(t.accessLevel)=$11 and instr(r.userLevel,$12)!=$13) or (TO_NUMBER(t.accessLevel)=$14 and (instr(r.userLevel,$15)!=$16 or instr(r.userLevel,$17)!=$18)) or (TO_NUMBER(t.accessLevel)=$19 and (instr(r.userLevel,$20)!=$21 or instr(r.userLevel,$22)!=$23)) ) and not exists (select $24 from ad_table_access ta where t.ad_table_id = ta.ad_table_id and ta.ad_role_id = r.ad_role_id and ta.isActive=$25 and ta.isExclude = $26)
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
cd763a3fabinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
4ea59d9feainsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
f68dd8a1a9ANALYZE last_stat_tables
bc23716c25SELECT * FROM ( SELECT $10 AS RN1, C.* FROM ( SELECT VALUE, NAME, DATEACCT, COALESCE(SUM(AMTACCTDR),$11) AS AMTACCTDR, COALESCE(SUM(AMTACCTCR),$12) AS AMTACCTCR, COALESCE(SUM(AMTACCTDR-AMTACCTCR),$13) AS TOTAL, MAX(FACT_ACCT_ID) AS FACT_ACCT_ID, FACT_ACCT_GROUP_ID, ID, groupbyid, groupbyname, DESCRIPTION, ISDEBIT, $14 AS TOTALACCTDR, $15 AS TOTALACCTCR, $16 AS TOTALACCTSUB, $17 AS PREVIOUSDEBIT, $18 AS PREVIOUSCREDIT, $19 AS PREVIOUSTOTAL, $20 AS FINALDEBIT, $21 AS FINALCREDIT, $22 AS FINALTOTAL, TO_CHAR(DATEACCT,$23) AS DATEACCTNUMBER, $1 AS groupby, $24 as bpid, $25 as bpname, $26 as pdid, $27 as pdname, $28 as pjid, $29 as pjname, factaccttype , $30 AS AMTACCTDRPREVSUM, $31 AS AMTACCTCRPREVSUM FROM (SELECT FACT_ACCT.ACCTVALUE AS VALUE, FACT_ACCT.ACCTDESCRIPTION AS NAME, DATEACCT, AMTACCTDR, AMTACCTCR, FACT_ACCT_ID, FACT_ACCT_GROUP_ID, FACT_ACCT.ACCOUNT_ID AS ID, FACT_ACCT.DESCRIPTION, CASE $2 WHEN $32 THEN c_bpartner.c_bpartner_id WHEN $33 THEN m_product.m_product_id WHEN $34 THEN c_project.c_project_id ELSE $35 END AS groupbyid, CASE $3 WHEN $36 THEN (select to_char(name) from c_bpartner b where b.c_bpartner_id = c_bpartner.c_bpartner_id) WHEN $37 THEN (select to_char(value || $38 || name) from m_product p where p.m_product_id = m_product.m_product_id) WHEN $39 THEN (select to_char(value || $40 || name) from c_project pj where pj.c_project_id = c_project.c_project_id) ELSE $41 END AS groupbyname, CASE WHEN (AMTACCTDR > $42 AND AMTACCTCR = $43) OR (AMTACCTCR < $44 AND AMTACCTDR = $45) THEN $46 ELSE $47 END AS ISDEBIT, CASE WHEN FACT_ACCT.FACTACCTTYPE = $48 THEN $49 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = $50 THEN $51 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = $52 THEN $53 ELSE (CASE WHEN FACT_ACCT.FACTACCTTYPE = $54 THEN $55 END) END) END) END AS FACTACCTTYPE FROM FACT_ACCT LEFT JOIN C_BPARTNER ON FACT_ACCT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID LEFT JOIN M_PRODUCT ON FACT_ACCT.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID LEFT JOIN C_PROJECT ON FACT_ACCT.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID WHERE ($4=$56 OR FACT_ACCT.ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = $5) and value <= ( select value from c_elementvalue where c_elementvalue_id = $6) and c_elementvalue.ELEMENTLEVEL = $57 )) AND FACT_ACCT.AD_ORG_ID IN ($58,$59,$60,$61) AND FACT_ACCT.AD_CLIENT_ID IN ($62,$63) AND $64=$65 AND FACT_ACCT.C_ACCTSCHEMA_ID = $7 AND FACT_ACCT.DATEACCT >= TO_DATE($8) AND FACT_ACCT.DATEACCT < TO_DATE($9) AND FACT_ACCT.AD_ORG_ID IN ($66) AND $67=$68 AND FACT_ACCT.C_BPARTNER_ID IN($69) AND $70=$71) D WHERE $72=$73 GROUP BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, DESCRIPTION, ISDEBIT HAVING SUM(AMTACCTDR) - SUM(AMTACCTCR) <> $74 ORDER BY groupbyname, groupbyid, VALUE, NAME, ID, DATEACCT, FACTACCTTYPE, FACT_ACCT_GROUP_ID, FACT_ACCT_ID, DESCRIPTION, ISDEBIT LIMIT $75 OFFSET $76 ) C ) B WHERE $77=$78
ff457cdd0binsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
b1ad12ea83SELECT C_ORDERLINETAX_INSERT(new.AD_Org_ID, new.C_Order_ID, new.C_OrderLine_ID, new.UpdatedBy, new.C_Tax_ID, new.C_Tax_ID, v_newLineNetAmt, v_newLineAlternate, v_Prec)
d14c05e898insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
7b1c8e2529insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
73e6ea4442delete from ad_context_info
b9bb8a4422SELECT * FROM take_sample_subset(1,0)
3206d9f66dinsert 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
07181527b0DELETE FROM last_stat_indexes WHERE server_id=sserver_id AND sample_id != s_id
174962df65insert into psat_checklist_result (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Advcrm_Activity_ID, Result, Psat_Check_Type_ID, Psat_Checklist_Group_ID, Description, Psat_Checklist_Result_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_5ad_context_info213 GB759767596375962
etendopg_defaultpg_temp_8ad_context_info154 GB634616341363412
etendopg_defaultpg_temp_8ad_context_info91 GB126021260212602
etendopg_defaultpg_temp_7ad_context_info62 GB382253820038199
etendopg_defaultpg_temp_3ad_context_info62 GB380513803438033
etendopg_defaultpg_temp_4ad_context_info31 GB254962545825457
etendopg_defaultpg_temp_6ad_context_info31 GB252342522725226
etendopg_defaultpublicpsat_activity_consumption12 GB468199665
psat_activity_consumption(TOAST)
etendopg_defaultpg_temp_6ad_context_info10 GB126211262112620
etendopg_defaultpublicadvcrm_activity9269 MB5761564144910108485
advcrm_activity(TOAST)
etendopg_defaultpublicc_bpartner8063 MB6491260483566344103
c_bpartner(TOAST)
etendopg_defaultpublicpsat_checklist_result5053 MB86152027143081414
psat_checklist_result(TOAST)
etendopg_defaultpublicfact_acct4994 MB191991767966268
fact_acct(TOAST)
etendopg_defaultpg_catalogpg_class4057 MB60356160986024691879672818791373
etendopg_defaultprofilelast_stat_database2173 MB1016999292
etendopg_defaultpublicm_inout1893 MB161427373613169
m_inout(TOAST)
etendopg_defaultpublicad_audit_trail1526 MB31771461529
ad_audit_trail(TOAST)
etendopg_defaultpublicc_invoice1322 MB582987991402454428970628
c_invoice(TOAST)
etendopg_defaultpublicm_product943 MB266282350529581173
m_product(TOAST)
etendopg_defaultpublicc_order821 MB55276575175422188157
c_order(TOAST)

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpg_temp_5ad_context_info2395465514.62
etendopg_defaultpg_temp_8ad_context_info1675683410.23
etendopg_defaultpg_temp_8ad_context_info112410886.86
etendopg_defaultpublicc_invoice35796292.1876033214.64
etendopg_defaultpublicm_productprice27843541.7082040385.01
etendopg_defaultpublicm_product30034131.8356815373.47
etendopg_defaultpg_temp_7ad_context_info61226843.74
etendopg_defaultpg_temp_3ad_context_info60657213.70
etendopg_defaultprofilelast_stat_tables34080192.081065560.07
etendopg_defaultpublicfin_payment_schedule8789720.5425472561.55
etendopg_defaultpublicpsat_activity_materials189080.0129232831.78
etendopg_defaultpublicm_product_trl28256571.72
etendopg_defaultpg_temp_4ad_context_info27430541.67
etendopg_defaultpg_temp_6ad_context_info27002461.65
etendopg_defaultpg_catalogpg_class11118190.6812880860.79
etendopg_defaultpublicfact_acct23648741.44175320.01
etendopg_defaultpublicc_bpartner15698810.965293150.32
etendopg_defaultpublicad_column5805480.3511031980.67
etendopg_defaultpublicc_orderline7800410.488632550.53
etendopg_defaultpublicpsat_activity_consumption15682820.96340.00

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpublicad_audit_trail13027228.7818120.4045.03
etendopg_defaultpublicfact_acct6728514.8726210.5897.07
etendopg_defaultpublicad_image7890.17320.015641312.468850.2066.24
etendopg_defaultpublicpsat_checklist_result150263.3236440.8198.45
etendopg_defaultpublicc_orderline148963.2919030.4298.98
etendopg_defaultpublicc_invoice58301.2962781.3999.89
etendopg_defaultpublicm_inoutline86521.9110460.2386.47
etendopg_defaultpublicc_orderlinetax73621.633120.0772.50
etendopg_defaultpublicad_session_usage_audit47681.056330.1487.59
etendopg_defaultpublicfin_payment_schedule38020.844760.1199.88
etendopg_defaultpublicc_order38180.844170.0998.38
etendopg_defaultpublicfin_payment31620.702010.0484.43
etendopg_defaultpublicfin_payment_scheduledetail27160.605980.1395.15
etendopg_defaultpublicm_inout30080.662450.0598.76
etendopg_defaultpublicad_process_run26920.591200.03110.00100.0095.66
etendopg_defaultpublicfin_payment_detail19060.422410.0561.67
etendopg_defaultpg_catalogpg_attribute14380.324860.1199.84
etendopg_defaultpg_catalogpg_statistic11520.25810.026540.14160.0099.52
etendopg_defaultprofilesample_stat_tables17720.391070.0296.15
etendopg_defaultpublicprsync_entry9240.20550.018590.19160.0089.20

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
etendopg_defaultpublicc_invoice4289706285826593222987991402454
c_invoice(TOAST)
etendopg_defaultpg_temp_5ad_context_info75963759627597675975
etendopg_defaultpg_temp_8ad_context_info63413634126346163460
etendopg_defaultprofilelast_stat_indexes5411913115411918586590434547328378
etendopg_defaultpg_temp_7ad_context_info38200381993822538224
etendopg_defaultpg_temp_3ad_context_info38034380333805138050
etendopg_defaultprofilelast_stat_tables328903383328905318652910078572999899
etendopg_defaultpg_temp_4ad_context_info25458254572549625495
etendopg_defaultpg_temp_6ad_context_info25227252262523425233
etendopg_defaultpg_catalogpg_attribute242532425392948833035901275381
etendopg_defaultpg_temp_6ad_context_info12621126201262112620
etendopg_defaultpg_temp_8ad_context_info12602126021260212602
etendopg_defaultpg_catalogpg_statistic163831357421669210468287356
pg_statistic(TOAST)237423771404921889
etendopg_defaultprofilelast_stat_user_functions8257979825736377237299
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class1879672818791373603517628380616098602469
etendopg_defaultpg_catalogpg_depend4603460372058174434550034
etendopg_defaultprofilesample_stat_tables33833093256070461423258
etendopg_defaultpg_catalogpg_type21712171123062510145994530
etendopg_defaultprofilesample_statements13911312444585341151312
sample_statements(TOAST)
etendopg_defaultprofilesample_stat_indexes12601198222094791371254

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
etendopg_defaultpublicc_invoice2897062823123
c_invoice(TOAST)
etendopg_defaultpg_temp_5ad_context_info75962
etendopg_defaultpg_temp_8ad_context_info63412
etendopg_defaultprofilelast_stat_indexes131154119264723
etendopg_defaultpg_temp_7ad_context_info38199
etendopg_defaultpg_temp_3ad_context_info38033
etendopg_defaultprofilelast_stat_tables33835332890264723
etendopg_defaultpg_temp_4ad_context_info25457
etendopg_defaultpg_temp_6ad_context_info25226
etendopg_defaultpg_catalogpg_attribute24253111
etendopg_defaultpg_catalogpg_statistic16383135742
pg_statistic(TOAST)23774
etendopg_defaultpg_temp_6ad_context_info12620
etendopg_defaultpg_temp_8ad_context_info12602
etendopg_defaultprofilelast_stat_user_functions979368257264723
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class672813731879111
etendopg_defaultpg_catalogpg_depend460311
etendopg_defaultprofilesample_stat_tables309312
etendopg_defaultpg_catalogpg_type2171111
etendopg_defaultpublicad_session1796177415
ad_session(TOAST)
etendopg_defaultprofilesample_statements13122
sample_statements(TOAST)

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_5ad_context_info5040 kB5040 kB7596375962
etendopg_defaultpg_temp_8ad_context_info4216 kB4216 kB6341363412
etendopg_defaultpg_temp_7ad_context_info2544 kB2544 kB3820038199
etendopg_defaultpg_temp_3ad_context_info2544 kB2544 kB3803438033
etendopg_defaultpg_temp_6ad_context_info864 kB864 kB1262112620
etendopg_defaultpg_catalogpg_statistic4688 kB-72 kB1638313574
pg_statistic(TOAST)4648 kB896 kB23742377
etendopg_defaultprofilesample_statements2976 kB344 kB13911312
sample_statements(TOAST)
etendopg_defaultprofilesample_stat_indexes1432 kB192 kB12601198
etendopg_defaultprofilelast_stat_tables1232 kB120 kB3289033833289053
etendopg_defaultpg_catalogpg_attribute4512 kB104 kB2425324253
etendopg_defaultprofilesample_stat_user_functions568 kB96 kB955833
etendopg_defaultprofilesample_stat_cluster56 kB32 kB109
etendopg_defaultprofilesample_statements_total136 kB32 kB3945
sample_statements_total(TOAST)
etendopg_defaultprofilesample_stat_user_func_total56 kB32 kB2430
postgrespg_defaultpg_catalogpg_statistic256 kB16 kB478374
pg_statistic(TOAST)72 kB8192 bytes1515
etendopg_defaultpublicad_ep_instance_para32 kB24 kB8282
ad_ep_instance_para(TOAST)
etendopg_defaultpublicfin_payment_schedule15 MB16 kB1212
fin_payment_schedule(TOAST)

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
etendopg_defaultpublicm_productpricem_productprice_key272519282027495.01
etendopg_defaultpublicm_productm_product_key282345656680773.46
etendopg_defaultpublicpsat_activity_materialspsat_activity_mater_produni2479229229841.78
etendopg_defaultpublicm_product_trlm_product_trl_product_langu_un282484928252531.72
etendopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx83548225338541.55
etendopg_defaultpublicc_invoicec_invoice_key29141317639091.08
etendopg_defaultpg_catalogpg_classpg_class_oid_index58731711970130.73
etendopg_defaultpublicad_columnad_column_key54690710983280.67
etendopg_defaultpublicpsat_checklist_resultpsat_chcklist_res_result_uk10469345410.57
etendopg_defaultpublicc_invoicec_invoice_bpartner59879038660.55
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc8810280.54
etendopg_defaultpublicc_orderlinec_orderline_order22640468023370.49
etendopg_defaultpublicc_invoicec_invoice_posted13867020500.43
etendopg_defaultpublicc_invoicec_invoice_paid6969230.43
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index3030666651400.41
etendopg_defaultpublicc_invoicec_invoice_salesrep6462430.39
etendopg_defaultpublicc_invoicec_invoice_updated5947870.36
etendopg_defaultpublicc_invoicec_invoice_docno45858180.36
etendopg_defaultpublicad_tabad_tab_window2890805840740.36
etendopg_defaultpublicc_debt_paymentc_debt_payment_invoice_idx2641125294890.32

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
etendopg_defaultpublicpsat_checklist_resultpsat_chcklist_res_result_uk104633430.7499.64
etendopg_defaultpublicfact_acctfact_acct_dateacct7922050.4985.66
etendopg_defaultpublicad_audit_trailad_audit_trail_pk15810.3574.07
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc14200.3199.84
etendopg_defaultpublicc_invoicec_invoice_paid12080.2799.83
etendopg_defaultpublicc_orderlinec_orderline_order22640469750.2299.88
etendopg_defaultpublicc_invoicec_invoice_posted13869180.2099.87
etendopg_defaultpublicad_image(TOAST)pg_toast_74472_index138068850.2097.95
etendopg_defaultpublicc_orderlinec_orderline_key75748040.1896.51
etendopg_defaultpublicm_inoutlinem_inoutline_orderline69077960.1896.17
etendopg_defaultpublicc_invoicec_invoice_docno47170.1699.88
etendopg_defaultpublicad_session_usage_auditad_session_usage_audit_key5390.1290.07
etendopg_defaultpublicc_invoicec_invoice_updated5380.1299.91
etendopg_defaultpublicc_invoicec_invoice_bpartner59874330.1099.95
etendopg_defaultpublicc_invoicelinec_invoiceline_inoutline4853720.0874.50
etendopg_defaultpublicc_invoicec_invoice_key2914133440.0899.98
etendopg_defaultpublicadvcrm_activity_relatedadvcrm_unique_project63420.0883.42
etendopg_defaultpublicfin_payment_scheduledetailfin_pay_scheduledetail_in27193070.0796.25
etendopg_defaultpublicpsat_checklist_resultpsat_checklist_result_key4743010.0787.27
etendopg_defaultpublicc_invoicec_invoice_salesrep2970.0799.95

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
etendopg_defaultprofilesample_statementsix_sample_stmts_qid888 kB296 kB11261178
etendopg_defaultpublicad_process_runad_process_run_key424 kB112 kB213213315
etendopg_defaultprofilesample_stat_tablespk_sample_stat_tables856 kB96 kB19782015
etendopg_defaultpublicad_process_runad_process_run_ad_prequest_id360 kB56 kB159159315
etendopg_defaultprofilesample_statementspk_sample_statements_n480 kB48 kB815797
etendopg_defaultprofilesample_stat_user_functionspk_sample_stat_user_functions240 kB24 kB227150
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc3992 kB16 kB4289678
etendopg_defaultpublicc_invoicec_invoice_order1320 kB8192 bytes4289678
etendopg_defaultpublicc_invoicec_invoice_ad_user1592 kB8192 bytes4289678
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes424 kB8192 bytes54119131154119
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index696 kB8192 bytes2425324253
etendopg_defaultprofilesample_statements_totalpk_sample_statements_total40 kB8192 bytes3036

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_doc3992 kB16 kB4289678
etendopg_defaultpublicc_invoicec_invoice_paid1992 kB-8192 bytes4289678
etendopg_defaultpublicc_invoicec_invoice_updated1624 kB4289678
etendopg_defaultpublicc_invoicec_invoice_ad_user1592 kB8192 bytes4289678
etendopg_defaultpublicc_invoicec_invoice_bp_extref_idx8192 bytes4289678
etendopg_defaultpublicc_invoicec_invoice_salesrep1888 kB-48 kB4289678
etendopg_defaultpublicad_process_runad_process_run_ould_be_killed8192 bytes238238315
postgrespg_defaultpg_catalogpg_classpg_class_tblspc_relfilenode_index16 kB107258107

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicad_org_isinnaturaltree318036280.6719.740.0000.000
etendopublicad_isorgincluded481330261.0761.070.0000.000
etendoprofiletake_sample2317.580.020.7640.001
etendoprofiletake_sample_subset2317.560.060.7630.003
etendoprofiletake_sample2317.491.750.7610.076
etendopublicad_istriggerenabled116231114.2814.280.0000.000
etendoprofilecollect_obj_stats239.482.920.4120.127
etendoprofiledblink6218.098.090.0130.013
etendopublicto_char91323086.046.040.0000.000
etendoprofilesample_dbobj_delta233.993.990.1740.174
etendopublicad_column_identifier77313.953.920.0010.001
etendopublicobequals25518552.812.810.0000.000
etendopublicto_number8814251.581.580.0000.000
etendoprofilecollect_pg_stat_statements_stats200.860.360.0430.018
etendopublicaprm_ispaymentconfirmed98410.820.820.0000.000
etendopublicprouti_qtyremainingorderline82020.590.590.0000.000
etendopublicc_order_post80.490.000.0620.000
etendopublicc_order_post180.490.000.0620.000
etendopublicc_order_post180.490.180.0620.023
etendopublicc_invoice_create040.440.000.1110.000

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicto_char91323086.046.040.0000.000
etendopublicad_isorgincluded481330261.0761.070.0000.000
etendopublicad_org_isinnaturaltree318036280.6719.740.0000.000
etendopublicobequals25518552.812.810.0000.000
etendopublicad_istriggerenabled116231114.2814.280.0000.000
etendopublicto_number8814251.581.580.0000.000
etendopublicround1052480.090.090.0000.000
etendopublicto_char222460.060.060.0000.000
etendopublicsubstract_days129870.010.010.0000.000
etendopublicuuid_generate_v4114600.130.130.0000.000
etendopublicaprm_ispaymentconfirmed98410.820.820.0000.000
etendopublicprouti_qtyremainingorderline82020.590.590.0000.000
etendopublicad_column_identifier77313.953.920.0010.001
etendopublicadd_days68980.010.010.0000.000
etendopublicto_date66340.020.020.0000.000
etendopubliclowerequaltimestamp62920.050.030.0000.000
etendopublicget_uuid38200.250.120.0000.000
etendopublicprouti_delavailablewithoutres19710.340.340.0000.000
etendopublicprouti_deliveryavailable19710.340.340.0000.000
etendopublicinstr17800.030.010.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicc_invoice_trg28971025.1718.540.0000.000
etendopublicc_invoice_trg22897107.624.590.0000.000
etendopubliceinv_gene_chk_restrictions_trg2897065.352.750.0000.000
etendopublicpruti_inherit_invoice_contact2897104.672.730.0000.000
etendopublicau_advcrm_activity_trg1360.440.400.0030.003
etendopublicc_orderline_trg22000.390.150.0020.001
etendopublicau_m_product_trg30.140.130.0470.042
etendopublicad_preference_mod_trg3750.120.110.0000.000
etendopublicc_orderlinetax_trg1050.120.080.0010.001
etendopublicau_c_bpartner_trg100.100.100.0100.010
etendopubliccus_act_log_desc_ol_trg260.100.040.0040.001
etendopublicc_orderline_trg2000.090.080.0000.000
etendopublicau_psat_activity_materials_trg190.070.060.0040.003
etendopublicad_process_request_trg2970.070.050.0000.000
etendopublicc_invoiceline_trg2300.070.030.0020.001
etendopublicadvcrm_create_activity1320.060.030.0000.000
etendopublicpsat_set_rel_activity_request120.060.010.0050.001
etendopublicm_inoutline_trg180.050.030.0030.002
etendopublicc_orderline2_trg2000.050.050.0000.000
etendopublicau_psat_request_trg70.050.050.0080.007

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables263289033833289053
etendopg_defaultprofilelast_stat_indexes2654119131154119
etendopg_defaultprofilelast_stat_user_functions268257979825736
etendopg_defaultpublicc_invoice23428970628
etendopg_defaultpg_catalogpg_statistic21638313574
postgrespg_defaultpg_catalogpg_type1157157
postgrespg_defaultpg_catalogpg_attribute112151215
postgrespg_defaultpg_catalogpg_class1107388107130
postgrespg_defaultpg_catalogpg_statistic1478374
etendopg_defaultpg_catalogpg_type121712171
etendopg_defaultpg_catalogpg_attribute12425324253
etendopg_defaultpg_catalogpg_class11879672818791373
etendopg_defaultpg_catalogpg_index1527527
etendopg_defaultpublicad_ep_instance_para18282
etendopg_defaultpublicad_pinstance110202019
etendopg_defaultpublicad_process_run1304304315
etendopg_defaultpublicm_stock_proposed13
etendopg_defaultpublicprsync_entry146192219883
etendopg_defaultprofilelast_stat_database19292

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables47233289033833289053
etendopg_defaultprofilelast_stat_indexes472354119131154119
etendopg_defaultprofilelast_stat_user_functions47238257979825736
etendopg_defaultpublicc_invoice123428970628
etendopg_defaultprofilelast_stat_tablespaces224444
etendopg_defaultpublicad_session152017961774
etendopg_defaultpublicad_process_request15312307
etendopg_defaultprofilelast_stat_database139292
postgrespg_globalpg_catalogpg_pltemplate3
postgrespg_globalpg_catalogpg_tablespace3
postgrespg_globalpg_catalogpg_shdepend3716716
postgrespg_globalpg_catalogpg_authid3
postgrespg_globalpg_catalogpg_auth_members3
postgrespg_globalpg_catalogpg_database3
postgrespg_globalpg_catalogpg_db_role_setting3
postgrespg_globalpg_catalogpg_shseclabel3
postgrespg_globalpg_catalogpg_replication_origin3
postgrespg_globalpg_catalogpg_subscription3
etendopg_globalpg_catalogpg_pltemplate3
etendopg_globalpg_catalogpg_shdepend3716716

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc90 MB233991 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_key62 MB232752 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_bpartner57 MB232526 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_docno48 MB232144 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_paid43 MB231935 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_posted43 MB231934 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_salesrep42 MB231858 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_updated36 MB231586 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_ad_user35 MB231551 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_order29 MB231308 kB23 MB
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes10 MB26396 kB1530 kB
etendopg_defaultprofilelast_stat_tablespk_last_stat_tables5776 kB26221 kB1199 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index1064 kB11064 kB4512 kB
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index752 kB2376 kB4720 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index696 kB1696 kB4512 kB
etendopg_defaultpublicprsync_entryprsync_entry_key432 kB1432 kB3864 kB
etendopg_defaultpublicad_process_runad_process_run_ad_prequest_id328 kB1328 kB10 MB
etendopg_defaultpublicad_process_runad_process_run_key320 kB1320 kB10 MB
etendopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index264 kB388 kB4349 kB
etendopg_defaultpg_catalogpg_classpg_class_relname_nsp_index184 kB1184 kB688 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
etendoprofilesample_stat_tables244422825107024 kB
etendopublicad_process_run5135531911 MB
etendopublicfin_payment_schedule6061012015 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
etendopublicad_process_run513553143072026-07-14 19:14:39.949916+0211 MB
etendoprofilesample_stat_tables24442282575322026-07-15 23:00:43.988358+027024 kB
etendopublicfin_payment_schedule60610122402025-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-14 05:00:04.191608+02
pg_conf_load_time2026-07-15 05:00:03.654971+022026-07-15 06:00:02+02
pg_postmaster_start_time2026-07-14 05:00:04.325131+02
pg_postmaster_start_time2026-07-15 05:00:03.780547+022026-07-15 06:00:02+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