Postgres profile report (StartID: 546, EndID: 569)

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-16 04:00:01+02 - 2026-07-17 03:00:01+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
etendo2017012499.56508282113973239345671805219805726699533227594324232856 MB-2808 kB
postgres1186799.8411557030241985063365319201286617726431 kB
Total2135682499.56509437114676263347656868223458916719653236254341952862 MB-2808 kB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
etendo5102942587.4446.6771895771503130392038632423243816281
postgres561913.00127410223349
template163468.9947949235278
Total5114907609.4346.6772071130503130392043212423243816908

Cluster statistics

MetricValue
Scheduled checkpoints275
Requested checkpoints1
Checkpoint write time (s)9346.17
Checkpoint sync time (s)4.25
Checkpoints buffers written114627
Background buffers written
Backend buffers written142814
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated503618
WAL generated3687 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default2876 MB-2816 kB
pg_global542 kB

SQL query statistics

Top SQL by execution time

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

adb1c31f79

[948be82f]

etendo131.6721.61131670.074131670.074131670.0741

73e3636bec

[f410d7e7]

etendo78.1212.822882580.2710.1327.6480.095288258

4108c96b3f

[ca2988bd]

etendo47.487.791102730.411123.8901196.977335.34465

228d74fbf5

[cd9c0fd2]

etendo33.505.501347933504.38033504.38033504.3801

44dc303aa7

[5048ce93]

etendo19.923.27156751.0980.9619.2660.23418142

9166c19b70

[2d9f0a32]

etendo17.592.89629940.2790.0076.2030.15062994

0c133f89fa

[47df1ade]

etendo16.582.7223720.918658.164988.15084.21523

b9bb8a4422

[eb812a48]

etendo16.582.72720.707657.787987.98784.23123

bc36ffa2de

[10010380]

etendo13.142.16504000.2610.0078.9160.14150400

1d911b5cd9

[1c4d8fed]

etendo9.941.6325073.9641.65115.4041.4572507

671fe12038

[66c83919]

etendo8.541.4019012678538.4078538.4078538.4071

9c83facac5

[411377d4]

etendo6.431.05181420.3520.3143.5040.08318286

30f8741426

[754ab419]

etendo6.301.03125970.5000.1484.5880.16712597

503324b603

[d34207c3]

etendo6.201.022535520.0210.0052.7610.012289256

900b170462

[c6452b42]

etendo5.310.87251930.2110.0036.2830.12225194

5c5d70e7d3

[91a7becf]

etendo5.260.86252250.2090.0071.6660.12325225

8665977e38

[9568025a]

etendo5.250.86252160.2080.0074.6780.12725216

0b651ca53d

[7318d810]

etendo5.210.856744335208.5295208.5295208.5291

c9e2eb425b

[de5cc8a]

etendo4.970.8212600980.0030.0022.1610.0031900243

785a907bc3

[92946197]

etendo4.650.76950202.119191.309223.4807.39023

Top SQL by executions

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

c9e2eb425b

[de5cc8a]

etendo190024337.1512600980.0030.0022.1610.0035.0

9625146448

[b7edb1a4]

etendo2896015.662896010.0100.0070.4690.0052.9

0c13a0abe2

[4ed26d58]

etendo2892625.66312020.0100.0062.3940.0073.0

503324b603

[d34207c3]

etendo2892565.662535520.0210.0052.7610.0126.2

73e3636bec

[f410d7e7]

etendo2882585.642882580.2710.1327.6480.09578.1

9ea37f4950

[39cec726]

etendo2564055.012564050.0090.0070.4780.0042.4

df99961951

[9cb9259b]

etendo1628863.181628860.0180.0121.9270.0092.9

1b3d7b3f6d

[a00bdbff]

etendo1189692.330.0070.0041.0850.0040.8

891e82e5c1

[5a0bb3c]

etendo1006641.971006640.0030.0020.2840.0020.3

cb01d0ae5c

[3dd6e0f1]

etendo633651.24633650.0050.0030.5580.0050.3

9166c19b70

[2d9f0a32]

etendo629941.23629940.2790.0076.2030.15017.6

5c208ba241

[381eb299]

etendo533241.04533240.0140.0100.3250.0050.7

397ca8ed7d

[8593c304]

etendo505000.99505000.0050.0030.6140.0070.2

bc36ffa2de

[10010380]

etendo504000.99504000.2610.0078.9160.14113.1

ebd66f2e50

[2f2197e3]

etendo493120.96307510.0130.0060.4010.0090.7

fa1b74d06f

[c1b84187]

etendo471680.923437500.0410.0140.9010.0391.9

ffadc5ac47

[25ee072c]

etendo334020.65334010.0200.0110.3550.0080.7

d7389ab8e1

[af192082]

etendo313710.61313710.0020.0020.0890.0020.1

e98333ebd8

[3427f07b]

etendo253470.50253470.0050.0030.7920.0060.1

d897242fe6

[c07a3787]

etendo252700.49252700.0050.0030.2240.0040.1

Top SQL by shared blocks fetched

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

4108c96b3f

[ca2988bd]

etendo1080678714.99100.0047.5110265

73e3636bec

[f410d7e7]

etendo954679913.2599.9778.1288258288258

44dc303aa7

[5048ce93]

etendo60775708.43100.0019.91567518142

0c133f89fa

[47df1ade]

etendo46762916.4999.9816.62323

b9bb8a4422

[eb812a48]

etendo46761536.4999.9816.623

adb1c31f79

[948be82f]

etendo30419774.2284.23131.71

58d3d7b94c

[303fdc1e]

etendo21989983.05100.001.2222223

9c83facac5

[411377d4]

etendo21880123.0499.996.41814218286

c9e2eb425b

[de5cc8a]

etendo19002432.64100.005.012600981900243

785a907bc3

[92946197]

etendo16362492.2799.974.695023

5fa24dc926

[22217272]

etendo16181192.25100.002.15103723

75cdc9279a

[c0534667]

etendo14645072.03100.003.933

29e9be51ce

[b8952a6a]

etendo14396982.00100.002.273321222

c2b6cfc2bf

[ad3afc69]

etendo13271681.84100.004.39491342608

9625146448

[b7edb1a4]

etendo9082101.26100.002.9289601289601

0c13a0abe2

[4ed26d58]

etendo9064651.26100.003.031202289262

503324b603

[d34207c3]

etendo8311211.15100.006.2253552289256

9ea37f4950

[39cec726]

etendo7764501.08100.002.4256405256405

7c49e0fca3

[37eecc4]

etendo7611451.06100.004.42506

0f194ad1e6

[6d193752]

etendo6348480.88100.002.02549619

Top SQL by shared blocks read

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

adb1c31f79

[948be82f]

etendo47960893.9484.23131.71

f8cc1c12b0

[4f2bfd2e]

etendo32350.6398.870.9125

73e3636bec

[f410d7e7]

etendo24610.4899.9778.1288258288258

50b8978166

[b54ea3e2]

etendo23940.4798.891.334

12a81791af

[7eea2aca]

etendo19230.3897.850.290089008

9cbca4d83c

[b7b6a128]

etendo14910.2987.910.113311331

cbb0d2e65e

[4ec9dd54]

etendo13020.2692.090.42020

0c247acdf0

[948be82f]

template19750.1997.612.81

0c133f89fa

[47df1ade]

etendo9610.1999.9816.62323

b9bb8a4422

[eb812a48]

etendo9610.1999.9816.623

2e0b729b87

[948be82f]

postgres9410.1897.683.11

b8b9950890

[532de794]

etendo6650.1398.520.616021602

de891c1f5b

[a3acbb25]

etendo5490.1194.990.18

6951a2f5d4

[43f0ca83]

etendo5420.1193.420.0410410

785a907bc3

[92946197]

etendo4970.1099.974.695023

93accebb93

[bdc0f458]

etendo3710.0799.690.389796

ec2a223d8f

[313e71e6]

etendo3370.0775.510.044

9425961593

[7e6ec72b]

etendo3030.0699.670.42989022665

cb9c289625

[15eb0b0]

etendo2420.0597.280.112661266

2be957f8e4

[96b90f61]

etendo2410.0597.150.021102110

Top SQL by shared blocks dirtied

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

73e3636bec

[f410d7e7]

etendo6856933.5699.9778.1288258288258

adb1c31f79

[948be82f]

etendo6287330.7784.23131.71

0c133f89fa

[47df1ade]

etendo159627.8199.9816.62323

b9bb8a4422

[eb812a48]

etendo159627.8199.9816.623

fdd1193fad

[3b0e4e8a]

etendo41932.0599.963.55411946

d0b36135c7

[a0544a5f]

etendo32211.5899.963.73288846

b8b9950890

[532de794]

etendo23911.1798.520.616021602

140f3eb685

[59d1e156]

etendo18490.9099.530.92323

9cbca4d83c

[b7b6a128]

etendo16260.8087.910.113311331

c525c04235

[d2f1c69a]

etendo15700.7799.400.1304304

cbb0d2e65e

[4ec9dd54]

etendo13860.6892.090.42020

167f11efcd

[76ede534]

etendo12920.6399.790.11

9b16673e73

[423e83ff]

etendo12770.6298.900.11

f68dd8a1a9

[d422fd3a]

etendo10060.49100.000.744

4813705ddb

[6f2d0383]

etendo8250.4099.990.313401340

6a18f0bfd3

[b26b8c5c]

etendo5000.2499.080.1504504

bda4372001

[a3318de1]

etendo4120.2099.880.1236117

07181527b0

[f6f43f8d]

etendo3950.19100.000.03058913

65758f3c61

[2616291e]

etendo3800.1999.940.2574432

1251dece16

[7e502be6]

etendo3580.1899.970.432

Top SQL by shared blocks written

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

adb1c31f79

[948be82f]

etendo5842522.6940.9184.23131.71

0c247acdf0

[948be82f]

template1550.020.0497.612.81

2e0b729b87

[948be82f]

postgres550.020.0497.683.11

Top SQL by temp usage

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

cb01d0ae5c

[3dd6e0f1]

etendo6493199.1952521.530.36336563365

397ca8ed7d

[8593c304]

etendo5175199.1942017.230.25050050500

e98333ebd8

[3427f07b]

etendo2597799.182138.740.12534725347

d897242fe6

[c07a3787]

etendo2589499.192118.650.12527025270

3432bfcfac

[e0507c7b]

etendo2581899.182118.650.12519425194

30a0a7aa59

[61d99bdd]

etendo1312699.181084.430.11281112811

879611f3e6

[d2326a4]

etendo1292499.171074.390.11261212612

b3159008fe

[2aa6d467]

etendo1293299.171074.390.11262012620

638f3e98f1

[334a4ee5]

etendo1301099.181074.390.11269812698

1718660f21

[c3367c88]

etendo1292699.171074.390.11261412614

512a12de5c

[e3e1fb4c]

etendo1291199.171074.390.11259912599

0631edbc5b

[ff0ffbbc]

etendo1299699.181074.390.11268412684

42c36ef013

[a8fa8b7f]

etendo1290999.191044.270.11259712597

ecb9fef4c4

[1e99af1b]

etendo110.040.011

8c0c233a5c

[46d460c2]

etendo5698.2110.040.05656

439672e8c5

[86dedc92]

etendo8698.8410.040.08686

47dfd612ff

[dc5467f4]

etendo785.7110.040.077

Complete list of SQL texts

QueryIDQuery Text
cb9c289625SELECT APRM_ISPAYMENTCONFIRMED($1,$2) AS RESULT FROM DUAL
7c49e0fca3select 1 as id from dual where exists ( select 1 from ( SELECT a.DateAcct as dateacct FROM M_InOut a WHERE a.ad_client_id = $1 AND a.ad_org_id in ('0', '1000003', 'E5C644C994CA4E6DB384AF0325704F1E', '1000002') AND a.posted = 'N' AND a.processed = 'Y' AND (a.processing = 'N' OR a.processing IS NULL) AND EXISTS ( SELECT 1 FROM c_period p WHERE a.DateAcct >= p.StartDate AND a.DateAcct < p.EndDate + 1 AND EXISTS ( SELECT 1 FROM c_periodcontrol pc WHERE pc.c_period_id = p.c_period_id AND ad_org_getperiodcontrolallow(a.ad_org_id) = pc.ad_org_id AND pc.docbasetype = $2 AND pc.periodstatus = 'O' ) )) b where 1=1 )
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
879611f3e6insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
bc36ffa2dedelete from ad_context_info
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
ecb9fef4c4insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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)
ffadc5ac47SELECT coalesce(t.MSGTEXT, m.MSGTEXT) AS MSGTEXT FROM AD_MESSAGE m left join AD_MESSAGE_TRL t on m.AD_MESSAGE_ID = t.AD_MESSAGE_ID and t.AD_LANGUAGE = $1 WHERE m.VALUE=$2
65758f3c61INSERT INTO last_stat_user_functions( server_id, sample_id, datid, funcid, schemaname, funcname, funcargs, calls, total_time, self_time, trg_fn ) SELECT sserver_id, s_id, qres.datid, funcid, schemaname, funcname, funcargs, dbl.calls AS calls, dbl.total_time AS total_time, dbl.self_time AS self_time, dbl.trg_fn FROM dblink($18, t_query) AS dbl ( funcid oid, schemaname name, funcname name, funcargs text, calls bigint, total_time double precision, self_time double precision, trg_fn boolean )
b3159008feinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
9166c19b70delete from ad_context_info
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)
ec2a223d8fselect advcrmacti0_.Advcrm_Activity_ID as Advcrm_A9_143_1_, advcrmacti0_.Advcrm_Activity_Related_ID as Advcrm_A1_143_1_, advcrmacti0_.Advcrm_Activity_Related_ID as Advcrm_A1_143_0_, advcrmacti0_.AD_Client_ID as AD_Clien2_143_0_, advcrmacti0_.AD_Org_ID as AD_Org_I3_143_0_, advcrmacti0_.Created as Created4_143_0_, advcrmacti0_.Createdby as Createdb5_143_0_, advcrmacti0_.Updated as Updated6_143_0_, advcrmacti0_.Updatedby as Updatedb7_143_0_, advcrmacti0_.Isactive as Isactive8_143_0_, advcrmacti0_.Advcrm_Activity_ID as Advcrm_A9_143_0_, advcrmacti0_.Related_To as Related10_143_0_, advcrmacti0_.C_Bpartner_ID as C_Bpart11_143_0_, advcrmacti0_.C_Order_ID as C_Order12_143_0_, advcrmacti0_.C_Invoice_ID as C_Invoi13_143_0_, advcrmacti0_.C_Project_ID as C_Proje14_143_0_, advcrmacti0_.M_Product_ID as M_Produ15_143_0_, advcrmacti0_.Advcrm_Opportunity_ID as Advcrm_16_143_0_, advcrmacti0_.Advcrm_Lead_ID as Advcrm_17_143_0_, advcrmacti0_.EM_Psat_Request_ID as EM_Psat18_143_0_, advcrmacti0_.Quotation_ID as Quotati19_143_0_ from advcrm_activity_related advcrmacti0_ where advcrmacti0_.Advcrm_Activity_ID=$1
638f3e98f1insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
e98333ebd8insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
5c208ba241SELECT AD_CLIENT_ID,AD_ORG_ID, ISACTIVE, UPDATED,UPDATEDBY,ALIAS, COMBINATION, DESCRIPTION, ISFULLYQUALIFIED, C_ACCTSCHEMA_ID, ACCOUNT_ID, M_PRODUCT_ID, C_BPARTNER_ID,AD_ORGTRX_ID, C_LOCFROM_ID, C_LOCTO_ID, C_SALESREGION_ID, C_PROJECT_ID, C_CAMPAIGN_ID, C_ACTIVITY_ID, USER1_ID,USER2_ID, '' as UseSuspenseBalancing, '' as SuspenseBalancing_Acct, '' as UseSuspenseError, '' as SuspenseError_Acct, '' as UseCurrencyBalancing, '' as CurrencyBalancing_Acct, '' as RetainedEarning_Acct, '' as IncomeSummary_Acct, '' as InterCompanyDueTo_Acct, '' as InterCompanyDueFrom_Acct FROM C_ValidCombination WHERE C_ValidCombination_ID=$1
9ea37f4950select max(this_.Lastpayment) as y0_ from FIN_Payment_Sched_Inv_V this_ where this_.C_Invoice_ID=$1 and this_.Isactive=$2 limit $3
fdd1193fadINSERT INTO last_stat_indexes( server_id, sample_id, datid, relid, indexrelid, schemaname, relname, indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit, relsize, relsize_diff, tablespaceid, indisunique, in_sample, relpages_bytes, relpages_bytes_diff ) SELECT sserver_id, s_id, qres.datid, relid, indexrelid, schemaname, relname, indexrelname, dbl.idx_scan AS idx_scan, dbl.idx_tup_read AS idx_tup_read, dbl.idx_tup_fetch AS idx_tup_fetch, dbl.idx_blks_read AS idx_blks_read, dbl.idx_blks_hit AS idx_blks_hit, dbl.relsize AS relsize, dbl.relsize_diff AS relsize_diff, CASE WHEN tablespaceid=$19 THEN qres.tablespaceid ELSE tablespaceid END tablespaceid, indisunique, $20, dbl.relpages_bytes, dbl.relpages_bytes_diff FROM dblink($21, t_query) AS dbl ( relid oid, indexrelid oid, schemaname name, relname name, indexrelname name, idx_scan bigint, idx_tup_read bigint, idx_tup_fetch bigint, idx_blks_read bigint, idx_blks_hit bigint, relsize bigint, relsize_diff bigint, tablespaceid oid, indisunique bool, relpages_bytes bigint, relpages_bytes_diff bigint )
cb01d0ae5cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
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)
8c0c233a5cinsert 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)
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)
30a0a7aa59insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $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
0f194ad1e6SELECT st.relid,st.schemaname,st.relname,st.seq_scan,st.seq_tup_read,st.idx_scan,st.idx_tup_fetch,st.n_tup_ins,st.n_tup_upd,st.n_tup_del,st.n_tup_hot_upd,st.n_live_tup,st.n_dead_tup,st.n_mod_since_analyze,$1 as n_ins_since_vacuum,st.last_vacuum,st.last_autovacuum,st.last_analyze,st.last_autoanalyze,st.vacuum_count,st.autovacuum_count,st.analyze_count,st.autoanalyze_count,stio.heap_blks_read,stio.heap_blks_hit,stio.idx_blks_read,stio.idx_blks_hit,stio.toast_blks_read,stio.toast_blks_hit,stio.tidx_blks_read,stio.tidx_blks_hit,CASE locked.objid WHEN st.relid THEN $2 ELSE pg_catalog.pg_table_size(st.relid) - coalesce(pg_catalog.pg_relation_size(class.reltoastrelid),$3) END relsize,$4 relsize_diff,class.reltablespace AS tablespaceid,class.reltoastrelid,class.relkind,class.relpages::bigint * current_setting($5)::bigint AS relpages_bytes,$6 AS relpages_bytes_diff FROM pg_catalog.pg_stat_all_tables st JOIN pg_catalog.pg_statio_all_tables stio USING (relid, schemaname, relname) JOIN pg_catalog.pg_class class ON (st.relid = class.oid) LEFT OUTER JOIN LATERAL (WITH RECURSIVE deps (objid) AS (SELECT relation FROM pg_catalog.pg_locks WHERE granted AND locktype = $7 AND mode=$8 UNION SELECT refobjid FROM pg_catalog.pg_depend d JOIN deps dd ON (d.objid = dd.objid)) SELECT objid FROM deps) AS locked ON (st.relid = locked.objid)
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
1251dece16ANALYZE last_stat_indexes
9425961593select finpayment0_.FIN_Payment_Schedule_Invoice as FIN_Pay10_374_1_, finpayment0_.FIN_Payment_Scheduledetail_ID as FIN_Paym1_374_1_, finpayment0_.FIN_Payment_Scheduledetail_ID as FIN_Paym1_374_0_, finpayment0_.AD_Client_ID as AD_Clien2_374_0_, finpayment0_.AD_Org_ID as AD_Org_I3_374_0_, finpayment0_.Created as Created4_374_0_, finpayment0_.Createdby as Createdb5_374_0_, finpayment0_.Updated as Updated6_374_0_, finpayment0_.Updatedby as Updatedb7_374_0_, finpayment0_.FIN_Payment_Detail_ID as FIN_Paym8_374_0_, finpayment0_.FIN_Payment_Schedule_Order as FIN_Paym9_374_0_, finpayment0_.FIN_Payment_Schedule_Invoice as FIN_Pay10_374_0_, finpayment0_.Amount as Amount11_374_0_, finpayment0_.Isactive as Isactiv12_374_0_, finpayment0_.Writeoffamt as Writeof13_374_0_, finpayment0_.Iscanceled as Iscance14_374_0_, finpayment0_.C_Bpartner_ID as C_Bpart15_374_0_, finpayment0_.C_Activity_ID as C_Activ16_374_0_, finpayment0_.M_Product_ID as M_Produ17_374_0_, finpayment0_.C_Campaign_ID as C_Campa18_374_0_, finpayment0_.C_Project_ID as C_Proje19_374_0_, finpayment0_.C_Salesregion_ID as C_Sales20_374_0_, finpayment0_.C_Costcenter_ID as C_Costc21_374_0_, finpayment0_.User1_ID as User22_374_0_, finpayment0_.User2_ID as User23_374_0_, finpayment0_.DoubtfulDebt_Amount as Doubtfu24_374_0_, finpayment0_.Isinvoicepaid as Isinvoi25_374_0_ from FIN_Payment_ScheduleDetail finpayment0_ where finpayment0_.FIN_Payment_Schedule_Invoice=$1
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)
397ca8ed7dinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
439672e8c5insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
5c5d70e7d3delete from ad_context_info
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)
8665977e38delete from ad_context_info
2be957f8e4select isinvoicepaid, fin_payment_schedule_order, fin_payment_schedule_invoice from fin_payment_scheduledetail where fin_payment_scheduledetail_id=v_p_fin_psd_id
df99961951select financialm0_.C_Settlement_ID as C_Settle1_310_0_, financialm0_.AD_Client_ID as AD_Clien2_310_0_, financialm0_.AD_Org_ID as AD_Org_I3_310_0_, financialm0_.IsActive as IsActive4_310_0_, financialm0_.Created as Created5_310_0_, financialm0_.CreatedBy as CreatedB6_310_0_, financialm0_.Updated as Updated7_310_0_, financialm0_.UpdatedBy as UpdatedB8_310_0_, financialm0_.DocumentNo as Document9_310_0_, financialm0_.DateTrx as DateTrx10_310_0_, financialm0_.C_DocType_ID as C_DocTy11_310_0_, financialm0_.Processing as Process12_310_0_, financialm0_.Processed as Process13_310_0_, financialm0_.Posted as Posted14_310_0_, financialm0_.C_Project_ID as C_Proje15_310_0_, financialm0_.C_Campaign_ID as C_Campa16_310_0_, financialm0_.C_Activity_ID as C_Activ17_310_0_, financialm0_.User1_ID as User18_310_0_, financialm0_.User2_ID as User19_310_0_, financialm0_.CreateFrom as CreateF20_310_0_, financialm0_.C_Currency_ID as C_Curre21_310_0_, financialm0_.Cancelednotchargeamt as Cancele22_310_0_, financialm0_.Generatedamt as Generat23_310_0_, financialm0_.Chargedamt as Charged24_310_0_, financialm0_.Description as Descrip25_310_0_, financialm0_.CreateFile as CreateF26_310_0_, financialm0_.DateAcct as DateAcc27_310_0_, financialm0_.Settlementtype as Settlem28_310_0_, financialm0_.SettlementOpen as Settlem29_310_0_, financialm0_.CopyFrom as CopyFro30_310_0_, financialm0_.IsGenerated as IsGener31_310_0_, financialm0_.IsTemplate as IsTempl32_310_0_ from C_Settlement financialm0_ where financialm0_.C_Settlement_ID=$1
1b3d7b3f6dselect this_.AD_Sequence_Config_ID as AD_Seque1_112_0_, this_.AD_Client_ID as AD_Clien2_112_0_, this_.AD_Org_ID as AD_Org_I3_112_0_, this_.Isactive as Isactive4_112_0_, this_.Created as Created5_112_0_, this_.Createdby as Createdb6_112_0_, this_.Updated as Updated7_112_0_, this_.Updatedby as Updatedb8_112_0_, this_.Generator as Generato9_112_0_, this_.AD_Reference_ID as AD_Refe10_112_0_, this_.DB_Sequence_Name as DB_Sequ11_112_0_, this_.DB_Sequence_Initial as DB_Sequ12_112_0_, this_.DB_Sequence_Increment as DB_Sequ13_112_0_ from ad_sequence_config this_ where this_.AD_Reference_ID=$1 and this_.AD_Org_ID in ($2, $3, $4, $5) and this_.AD_Client_ID in ($6, $7) and this_.Isactive=$8
d0b36135c7INSERT INTO last_stat_tables( server_id, sample_id, datid, relid, schemaname, relname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, n_mod_since_analyze, n_ins_since_vacuum, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit, relsize, relsize_diff, tablespaceid, reltoastrelid, relkind, in_sample, relpages_bytes, relpages_bytes_diff ) SELECT sserver_id, s_id, qres.datid, dbl.relid, dbl.schemaname, dbl.relname, dbl.seq_scan AS seq_scan, dbl.seq_tup_read AS seq_tup_read, dbl.idx_scan AS idx_scan, dbl.idx_tup_fetch AS idx_tup_fetch, dbl.n_tup_ins AS n_tup_ins, dbl.n_tup_upd AS n_tup_upd, dbl.n_tup_del AS n_tup_del, dbl.n_tup_hot_upd AS n_tup_hot_upd, dbl.n_live_tup AS n_live_tup, dbl.n_dead_tup AS n_dead_tup, dbl.n_mod_since_analyze AS n_mod_since_analyze, dbl.n_ins_since_vacuum AS n_ins_since_vacuum, dbl.last_vacuum, dbl.last_autovacuum, dbl.last_analyze, dbl.last_autoanalyze, dbl.vacuum_count AS vacuum_count, dbl.autovacuum_count AS autovacuum_count, dbl.analyze_count AS analyze_count, dbl.autoanalyze_count AS autoanalyze_count, dbl.heap_blks_read AS heap_blks_read, dbl.heap_blks_hit AS heap_blks_hit, dbl.idx_blks_read AS idx_blks_read, dbl.idx_blks_hit AS idx_blks_hit, dbl.toast_blks_read AS toast_blks_read, dbl.toast_blks_hit AS toast_blks_hit, dbl.tidx_blks_read AS tidx_blks_read, dbl.tidx_blks_hit AS tidx_blks_hit, dbl.relsize AS relsize, dbl.relsize_diff AS relsize_diff, CASE WHEN dbl.tablespaceid=$19 THEN qres.tablespaceid ELSE dbl.tablespaceid END AS tablespaceid, dbl.reltoastrelid, dbl.relkind, $20, dbl.relpages_bytes, dbl.relpages_bytes_diff FROM dblink($21, t_query) AS dbl ( relid oid, schemaname name, relname name, seq_scan bigint, seq_tup_read bigint, idx_scan bigint, idx_tup_fetch bigint, n_tup_ins bigint, n_tup_upd bigint, n_tup_del bigint, n_tup_hot_upd bigint, n_live_tup bigint, n_dead_tup bigint, n_mod_since_analyze bigint, n_ins_since_vacuum bigint, last_vacuum timestamp with time zone, last_autovacuum timestamp with time zone, last_analyze timestamp with time zone, last_autoanalyze timestamp with time zone, vacuum_count bigint, autovacuum_count bigint, analyze_count bigint, autoanalyze_count bigint, heap_blks_read bigint, heap_blks_hit bigint, idx_blks_read bigint, idx_blks_hit bigint, toast_blks_read bigint, toast_blks_hit bigint, tidx_blks_read bigint, tidx_blks_hit bigint, relsize bigint, relsize_diff bigint, tablespaceid oid, reltoastrelid oid, relkind char, relpages_bytes bigint, relpages_bytes_diff bigint )
bda4372001INSERT INTO sample_stat_tables ( server_id, sample_id, datid, relid, tablespaceid, 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, relpages_bytes, relpages_bytes_diff ) SELECT cur.server_id AS server_id, cur.sample_id AS sample_id, cur.datid AS datid, cur.relid AS relid, cur.tablespaceid AS tablespaceid, cur.seq_scan - COALESCE(lst.seq_scan,$4) AS seq_scan, cur.seq_tup_read - COALESCE(lst.seq_tup_read,$5) AS seq_tup_read, cur.idx_scan - COALESCE(lst.idx_scan,$6) AS idx_scan, cur.idx_tup_fetch - COALESCE(lst.idx_tup_fetch,$7) AS idx_tup_fetch, cur.n_tup_ins - COALESCE(lst.n_tup_ins,$8) AS n_tup_ins, cur.n_tup_upd - COALESCE(lst.n_tup_upd,$9) AS n_tup_upd, cur.n_tup_del - COALESCE(lst.n_tup_del,$10) AS n_tup_del, cur.n_tup_hot_upd - COALESCE(lst.n_tup_hot_upd,$11) AS n_tup_hot_upd, cur.n_live_tup AS n_live_tup, cur.n_dead_tup AS n_dead_tup, cur.n_mod_since_analyze AS n_mod_since_analyze, cur.n_ins_since_vacuum AS n_ins_since_vacuum, cur.last_vacuum AS last_vacuum, cur.last_autovacuum AS last_autovacuum, cur.last_analyze AS last_analyze, cur.last_autoanalyze AS last_autoanalyze, cur.vacuum_count - COALESCE(lst.vacuum_count,$12) AS vacuum_count, cur.autovacuum_count - COALESCE(lst.autovacuum_count,$13) AS autovacuum_count, cur.analyze_count - COALESCE(lst.analyze_count,$14) AS analyze_count, cur.autoanalyze_count - COALESCE(lst.autoanalyze_count,$15) AS autoanalyze_count, cur.heap_blks_read - COALESCE(lst.heap_blks_read,$16) AS heap_blks_read, cur.heap_blks_hit - COALESCE(lst.heap_blks_hit,$17) AS heap_blks_hit, cur.idx_blks_read - COALESCE(lst.idx_blks_read,$18) AS idx_blks_read, cur.idx_blks_hit - COALESCE(lst.idx_blks_hit,$19) AS idx_blks_hit, cur.toast_blks_read - COALESCE(lst.toast_blks_read,$20) AS toast_blks_read, cur.toast_blks_hit - COALESCE(lst.toast_blks_hit,$21) AS toast_blks_hit, cur.tidx_blks_read - COALESCE(lst.tidx_blks_read,$22) AS tidx_blks_read, cur.tidx_blks_hit - COALESCE(lst.tidx_blks_hit,$23) AS tidx_blks_hit, cur.relsize AS relsize, cur.relsize - COALESCE(lst.relsize,$24) AS relsize_diff, cur.relpages_bytes AS relpages_bytes, cur.relpages_bytes - COALESCE(lst.relpages_bytes,$25) AS relpages_bytes_diff FROM last_stat_tables cur JOIN last_stat_database dbcur USING (server_id, sample_id, datid) LEFT JOIN last_stat_database dblst ON (dblst.server_id, dblst.sample_id, dblst.datid, dblst.stats_reset) = (dbcur.server_id, dbcur.sample_id - $26, dbcur.datid, 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) WHERE (cur.server_id, cur.sample_id, cur.in_sample) = (sserver_id, s_id, $27)
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
d7389ab8e1SELECT $4 FROM ONLY "profile"."last_stat_tablespaces" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "sample_id" OPERATOR(pg_catalog.=) $2 AND "tablespaceid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
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
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
d897242fe6insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
1718660f21insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
900b170462delete from ad_context_info
4108c96b3fselect productbyp0_.M_Product_Price_Warehouse_V_ID as M_Produc1_469_, productbyp0_.AD_Client_ID as AD_Clien2_469_, productbyp0_.AD_Org_ID as AD_Org_I3_469_, productbyp0_.Isactive as Isactive4_469_, productbyp0_.Updated as Updated5_469_, productbyp0_.Updatedby as Updatedb6_469_, productbyp0_.Created as Created7_469_, productbyp0_.Createdby as Createdb8_469_, productbyp0_.M_Product_ID as M_Produc9_469_, productbyp0_.M_Warehouse_ID as M_Wareh10_469_, productbyp0_.M_Productprice_ID as M_Produ11_469_, productbyp0_.QTY_Available as QTY_Ava12_469_, productbyp0_.QTY_Onhand as QTY_Onh13_469_, productbyp0_.QTY_Reserved as QTY_Res14_469_, productbyp0_.QTY_Ordered as QTY_Ord15_469_, productbyp0_.Pricelist as Priceli16_469_, productbyp0_.Pricestd as Pricest17_469_, productbyp0_.Pricelimit as Priceli18_469_, productbyp0_.Orgwarehouse as Orgware19_469_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID=product1_.M_Product_ID cross join M_ProductPrice pricingpro4_ cross join M_PriceList_Version pricingpri5_ cross join M_PriceList pricingpri9_ where productbyp0_.M_Productprice_ID=pricingpro4_.M_ProductPrice_ID and pricingpro4_.M_PriceList_Version_ID=pricingpri5_.M_PriceList_Version_ID and pricingpri5_.M_PriceList_ID=pricingpri9_.M_PriceList_ID and (upper(product1_.Value) like upper($1) escape $12 or upper(product1_.Name) like upper($2) escape $13 or upper((product1_.Value||$14||coalesce(to_char((select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID=product1_.M_Product_ID and producttrl2_.AD_Language=$15)), to_char(product1_.Name), $16))) like upper($3) escape $17 or upper((product1_.Value||$18||coalesce(to_char((select producttrl3_.Name from M_Product_Trl producttrl3_ where producttrl3_.M_Product_ID=product1_.M_Product_ID and producttrl3_.AD_Language=$19)), to_char(product1_.Name), $20))) like upper($4) escape $21) and (productbyp0_.AD_Org_ID in ($22 , $23)) and productbyp0_.Isactive=$24 and AD_ORG_ISINNATURALTREE(productbyp0_.Orgwarehouse, $5, $6)=$25 and pricingpri5_.IsActive=$26 and AD_ORG_ISINNATURALTREE(pricingpro4_.AD_Org_ID, $7, $8)=$27 and pricingpri9_.IsSOPriceList=$28 and pricingpri9_.C_Currency_ID=$29 and pricingpro4_.M_PriceList_Version_ID=$30 and productbyp0_.M_Warehouse_ID=$31 and (productbyp0_.AD_Client_ID in ($9 , $10)) and productbyp0_.Isactive=$32 order by product1_.Value, product1_.Name, product1_.M_Product_ID limit $11
228d74fbf5COPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout
c525c04235INSERT INTO AD_Process_Run (AD_Org_ID, AD_Client_ID, Isactive, Created, Createdby, Updated, UpdatedBy, AD_Process_Run_ID, Status, Start_Time, Runtime, Log, AD_Process_Request_ID, Scheduler_Instance) VALUES ($1, $2, 'Y', NOW(), $3, NOW(), $4, $5, $6, NOW(), $7, $8, $9, $10)
503324b603select financialm0_.C_Invoice_ID as C_Invoi13_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Invoice_ID=$1
f68dd8a1a9ANALYZE last_stat_tables
47dfd612ffinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
3432bfcfacinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
512a12de5cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
b9bb8a4422SELECT * FROM take_sample_subset(1,0)
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
0631edbc5binsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_5ad_context_info153 GB635266351163510
etendopg_defaultpg_temp_10ad_context_info102 GB505935059250591
etendopg_defaultpg_temp_5ad_context_info81 GB125971259712597
etendopg_defaultpg_temp_6ad_context_info31 GB257212565925658
etendopg_defaultpg_temp_3ad_context_info31 GB253162531425313
etendopg_defaultpg_temp_3ad_context_info31 GB252132520825207
etendopg_defaultpg_temp_3ad_context_info11 GB127531273112730
etendopg_defaultpg_temp_4ad_context_info10 GB126291262512624
etendopg_defaultpg_temp_4ad_context_info10 GB127451272912728
etendopg_defaultpg_temp_8ad_context_info10 GB126281261212611
etendopg_defaultpg_temp_5ad_context_info10 GB126171261612615
etendopg_defaultpg_temp_6ad_context_info10 GB126111260712606
etendopg_defaultpublicc_bpartner7914 MB637134193131610142
c_bpartner(TOAST)
etendopg_defaultpublicadvcrm_activity6694 MB4161545142520105386
advcrm_activity(TOAST)
etendopg_defaultpublicad_org_tree6096 MB780315
etendopg_defaultpg_catalogpg_class4051 MB60266355116218531887672818871375
etendopg_defaultpublicpsat_checklist_result3881 MB66130926031363231
psat_checklist_result(TOAST)
etendopg_defaultpublicfact_acct3417 MB13
fact_acct(TOAST)
etendopg_defaultprofilelast_stat_database2132 MB970468888
etendopg_defaultpublicad_audit_trail1527 MB31691291715
ad_audit_trail(TOAST)

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpg_temp_5ad_context_info1669191514.61
etendopg_defaultpublicc_invoice35475263.1176012236.66
etendopg_defaultpg_temp_10ad_context_info106774839.35
etendopg_defaultpg_temp_5ad_context_info98891138.66
etendopg_defaultpublicm_productprice10712580.9431500342.76
etendopg_defaultpublicm_product13082931.1523423122.05
etendopg_defaultpublicfin_payment_schedule8789800.7725487082.23
etendopg_defaultprofilelast_stat_tables31667662.771043820.09
etendopg_defaultpg_temp_6ad_context_info27578992.41
etendopg_defaultpg_temp_3ad_context_info27057902.37
etendopg_defaultpg_temp_3ad_context_info27000672.36
etendopg_defaultpg_catalogpg_class11319260.9913270531.16
etendopg_defaultpublicpsat_activity_materials135510.0121777241.91
etendopg_defaultpublicad_tab7946580.706175230.54
etendopg_defaultpublicm_product_trl13639271.19
etendopg_defaultpg_catalogpg_attribute5213200.467613900.67
etendopg_defaultpublicc_debt_payment4668700.417849860.69
etendopg_defaultpublicc_bpartner11335810.99719370.06
etendopg_defaultpublicad_textinterfaces4126350.365099220.45
etendopg_defaultpublicadvcrm_activity8568200.7548540.00

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpublicad_audit_trail13038828.9619510.4345.34
etendopg_defaultpublicfact_acct6728314.9485.60
etendopg_defaultpublicad_image7880.18180.005644312.548860.2065.83
etendopg_defaultpublicpsat_checklist_result150463.3434950.7897.60
etendopg_defaultpublicc_orderline149043.3118430.4195.16
etendopg_defaultpublicc_invoice58301.2961741.3799.89
etendopg_defaultpublicc_orderlinetax73631.641410.0367.49
etendopg_defaultpublicad_session_usage_audit48921.096030.1384.84
etendopg_defaultpublicc_order38210.856560.1598.44
etendopg_defaultpublicfin_payment_schedule38010.844730.1199.88
etendopg_defaultpublicfin_payment31600.701810.0478.87
etendopg_defaultpublicfin_payment_scheduledetail27160.605620.1290.23
etendopg_defaultpublicad_process_run26980.601170.03110.00100.0095.73
etendopg_defaultpublicfin_finacc_transaction27800.6280.0075.05
etendopg_defaultpublicadvcrm_activity_related20870.464180.0982.89
etendopg_defaultpublicfin_payment_detail19060.422380.0561.61
etendopg_defaultpublicprsync_entry9760.22580.018990.20170.0089.53
etendopg_defaultpg_catalogpg_attribute14360.324960.1199.85
etendopg_defaultprofilesample_stat_tables17720.391080.0296.05
etendopg_defaultpublicc_ordertax18220.40380.0166.81

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
etendopg_defaultpublicc_invoice2896053415590362984741426909
c_invoice(TOAST)
etendopg_defaultpg_temp_5ad_context_info63511635106352663525
etendopg_defaultprofilelast_stat_indexes54119129754119218586590434531328364
etendopg_defaultpg_temp_10ad_context_info50592505915059350592
etendopg_defaultprofilelast_stat_tables328883199328885418652906874602780225
etendopg_defaultpg_temp_6ad_context_info25659256582572125720
etendopg_defaultpg_temp_3ad_context_info25314253132531625315
etendopg_defaultpg_temp_3ad_context_info25208252072521325212
etendopg_defaultpg_catalogpg_attribute2433324333103945173264651352683
etendopg_defaultpg_temp_3ad_context_info12731127301275312752
etendopg_defaultpg_temp_4ad_context_info12729127281274512744
etendopg_defaultpg_temp_4ad_context_info12625126241262912628
etendopg_defaultpg_temp_5ad_context_info12616126151261712616
etendopg_defaultpg_temp_8ad_context_info12612126111262812627
etendopg_defaultpg_temp_6ad_context_info12607126061261112610
etendopg_defaultpg_temp_5ad_context_info12597125971259712597
etendopg_defaultpg_catalogpg_statistic1640813551216609121027101760
pg_statistic(TOAST)237523691581025284
etendopg_defaultprofilelast_stat_user_functions8257904825746380239453
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class1887672818871375602617654586635511621853
etendopg_defaultpg_catalogpg_depend46334633112058084463550254

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
etendopg_defaultpublicc_invoice28960523123
c_invoice(TOAST)
etendopg_defaultpg_temp_5ad_context_info63510
etendopg_defaultprofilelast_stat_indexes1297254119264723
etendopg_defaultpg_temp_10ad_context_info50591
etendopg_defaultprofilelast_stat_tables31995432888264723
etendopg_defaultpg_temp_6ad_context_info25658
etendopg_defaultpg_temp_3ad_context_info25313
etendopg_defaultpg_temp_3ad_context_info25207
etendopg_defaultpg_catalogpg_attribute24333111
etendopg_defaultpg_catalogpg_statistic16408135512
pg_statistic(TOAST)23694
etendopg_defaultpg_temp_3ad_context_info12730
etendopg_defaultpg_temp_4ad_context_info12728
etendopg_defaultpg_temp_4ad_context_info12624
etendopg_defaultpg_temp_5ad_context_info12615
etendopg_defaultpg_temp_8ad_context_info12611
etendopg_defaultpg_temp_6ad_context_info12606
etendopg_defaultpg_temp_5ad_context_info12597
etendopg_defaultprofilelast_stat_user_functions904468257264723
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class672813751887111
etendopg_defaultpg_catalogpg_depend463311

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_5ad_context_info4208 kB4208 kB6351163510
etendopg_defaultpg_temp_10ad_context_info3368 kB3368 kB5059250591
etendopg_defaultpg_temp_6ad_context_info1712 kB1712 kB2565925658
etendopg_defaultpg_temp_3ad_context_info1696 kB1696 kB2531425313
etendopg_defaultpg_temp_4ad_context_info864 kB864 kB1262512624
etendopg_defaultprofilesample_stat_indexes1432 kB192 kB12451335
etendopg_defaultprofilelast_stat_tables1248 kB120 kB3288831993288854
etendopg_defaultprofilesample_stat_user_functions568 kB96 kB880998
etendopg_defaultprofilesample_stat_tables_total336 kB64 kB160184
etendopg_defaultprofilesample_stat_database232 kB48 kB6476
etendopg_defaultpublicad_process_request56 kB32 kB328322
ad_process_request(TOAST)
etendopg_defaultprofilesample_stat_cluster56 kB32 kB1415
etendopg_defaultprofilelast_stat_database40 kB32 kB8888
etendopg_defaultprofilesample_stat_indexes_total96 kB32 kB6884
etendopg_defaultprofilesample_statements_total136 kB32 kB3951
sample_statements_total(TOAST)
etendopg_defaultprofilesample_stat_user_func_total56 kB32 kB2838
etendopg_defaultpublicad_ep_instance_para32 kB24 kB8585
ad_ep_instance_para(TOAST)

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
etendopg_defaultpublicm_productpricem_productprice_key104600831486572.76
etendopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx83535925344342.22
etendopg_defaultpublicm_productm_product_key115464423182932.03
etendopg_defaultpublicpsat_activity_materialspsat_activity_mater_produni1831121771861.91
etendopg_defaultpublicc_invoicec_invoice_key29069217614811.54
etendopg_defaultpublicm_product_trlm_product_trl_product_langu_un136315313635401.19
etendopg_defaultpg_catalogpg_classpg_class_oid_index60381812300501.08
etendopg_defaultpublicc_invoicec_invoice_bpartner64009053770.79
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc8807930.77
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index3259837113260.62
etendopg_defaultpublicc_invoicec_invoice_paid6990440.61
etendopg_defaultpublicc_invoicec_invoice_posted13806987720.61
etendopg_defaultpublicc_invoicec_invoice_salesrep6476500.57
etendopg_defaultpublicad_tabad_tab_window3025596109270.53
etendopg_defaultpublicc_invoicec_invoice_updated5945760.52
etendopg_defaultpublicc_invoicec_invoice_docno5856480.51
etendopg_defaultpublicc_debt_paymentc_debt_payment_invoice_idx2766805546950.49
etendopg_defaultpublicpsat_checklist_resultpsat_chcklist_res_result_uk7505182150.45
etendopg_defaultpublicad_textinterfacesad_textinterfaces_key2419844900220.43
etendopg_defaultpublicc_invoicec_invoice_order23218100.28

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
etendopg_defaultpublicpsat_checklist_resultpsat_chcklist_res_result_uk75033390.7499.36
etendopg_defaultpublicad_audit_trailad_audit_trail_pk17480.3974.57
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc14050.3199.84
etendopg_defaultpublicc_invoicec_invoice_paid11640.2699.83
etendopg_defaultpublicc_orderlinec_orderline_key96158950.2096.94
etendopg_defaultpublicc_invoicec_invoice_posted13808880.2099.87
etendopg_defaultpublicad_image(TOAST)pg_toast_74472_index138098860.2097.96
etendopg_defaultpublicm_inoutlinem_inoutline_orderline92118630.1996.90
etendopg_defaultpublicc_orderlinec_orderline_order2340968530.1999.18
etendopg_defaultpublicc_invoicec_invoice_docno7110.1699.88
etendopg_defaultpublicc_invoicec_invoice_updated5360.1299.91
etendopg_defaultpublicad_session_usage_auditad_session_usage_audit_key5240.1289.07
etendopg_defaultpublicc_invoicec_invoice_bpartner64004210.0999.95
etendopg_defaultpublicc_invoicelinec_invoiceline_inoutline9383630.0887.13
etendopg_defaultpublicc_invoicec_invoice_key2906923440.0899.98
etendopg_defaultpublicadvcrm_activity_relatedadvcrm_unique_project83390.0887.74
etendopg_defaultpublicfin_payment_scheduledetailfin_pay_scheduledetail_in27133080.0796.24
etendopg_defaultpublicc_invoicec_invoice_salesrep3050.0799.95
etendopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx8353592560.0699.99
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index3259832470.0599.97

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
etendopg_defaultprofilesample_statementsix_sample_stmts_qid912 kB304 kB11771249
etendopg_defaultprofilesample_stat_tablespk_sample_stat_tables856 kB96 kB16812162
etendopg_defaultpublicc_invoicec_invoice_salesrep1936 kB48 kB289605
etendopg_defaultpublicad_process_runad_process_run_ad_prequest_id352 kB32 kB119119315
etendopg_defaultpublicc_invoicec_invoice_bpartner2592 kB24 kB289605
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index720 kB16 kB2433324333
postgrespg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index88 kB8192 bytes12151215
etendopg_defaultprofilesample_statements_totalpk_sample_statements_total40 kB8192 bytes2739

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 kB289605
etendopg_defaultpublicc_invoicec_invoice_docno2144 kB289605
etendopg_defaultpublicc_invoicec_invoice_paid1976 kB-16 kB289605
etendopg_defaultpublicc_invoicec_invoice_updated1584 kB-40 kB289605
etendopg_defaultpublicc_invoicec_invoice_ad_user1584 kB-8192 bytes289605
etendopg_defaultpublicc_invoicec_invoice_bp_extref_idx8192 bytes289605
etendopg_defaultpublicc_invoicec_invoice_salesrep1936 kB48 kB289605
etendopg_defaultpublicad_process_runad_process_run_ould_be_killed8192 bytes252252315

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicad_org_isinnaturaltree125854532.457.960.0000.000
etendopublicad_isorgincluded190105624.5924.590.0000.000
etendoprofiletake_sample2316.580.020.7210.001
etendoprofiletake_sample_subset2316.560.060.7200.003
etendoprofiletake_sample2316.501.650.7180.072
etendopublicad_istriggerenabled116136815.6915.690.0000.000
etendoprofilecollect_obj_stats239.202.840.4000.123
etendoprofiledblink6217.817.810.0130.013
etendopublicad_column_identifier77344.003.960.0010.001
etendoprofilesample_dbobj_delta233.513.510.1520.152
etendopublicto_char50327803.433.430.0000.000
etendopublicc_order_post130.890.000.0680.000
etendopublicc_order_post1130.890.000.0680.000
etendopublicc_order_post1130.890.320.0680.025
etendoprofilecollect_pg_stat_statements_stats210.820.350.0390.017
etendopublicto_number4285590.810.810.0000.000
etendopublicaprm_ispaymentconfirmed97080.790.790.0000.000
etendopublicprouti_qtyremainingorderline93700.710.710.0000.000
etendopublicprouti_delavailablewithoutres23260.520.520.0000.000
etendopublicprouti_deliveryavailable23260.510.510.0000.000

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicto_char50327803.433.430.0000.000
etendopublicad_isorgincluded190105624.5924.590.0000.000
etendopublicad_org_isinnaturaltree125854532.457.960.0000.000
etendopublicad_istriggerenabled116136815.6915.690.0000.000
etendopublicto_number4285590.810.810.0000.000
etendopublicobequals4265130.480.480.0000.000
etendopublicto_char461810.100.100.0000.000
etendopublicto_char458540.080.080.0000.000
etendopublicto_char211280.060.060.0000.000
etendopublicsubstract_days133560.010.010.0000.000
etendopublicuuid_generate_v4106920.120.120.0000.000
etendopublicaprm_ispaymentconfirmed97080.790.790.0000.000
etendopublicprouti_qtyremainingorderline93700.710.710.0000.000
etendopublicad_column_identifier77344.003.960.0010.001
etendopublicget_uuid35640.230.110.0000.000
etendopublicadd_days23940.000.000.0000.000
etendopublicprouti_delavailablewithoutres23260.520.520.0000.000
etendopublicprouti_deliveryavailable23260.510.510.0000.000
etendopublicto_date12610.000.000.0000.000
etendopubliclowerequaltimestamp12230.010.010.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicc_invoice_trg28960525.7518.520.0000.000
etendopublicc_invoice_trg22896057.944.660.0000.000
etendopubliceinv_gene_chk_restrictions_trg2896055.702.790.0000.000
etendopublicpruti_inherit_invoice_contact2896055.002.810.0000.000
etendopublicau_advcrm_activity_trg1330.510.460.0040.003
etendopublicc_orderline_trg21890.290.110.0020.001
etendopublicau_c_bpartner_trg60.170.160.0280.027
etendopublicad_preference_mod_trg3390.130.110.0000.000
etendopublicau_m_product_trg20.090.090.0470.044
etendopublicc_orderlinetax_trg590.090.060.0020.001
etendopublicm_inoutline_trg290.080.040.0030.001
etendopublicc_orderline2_trg1890.080.060.0000.000
etendopublicc_orderline_trg1890.070.070.0000.000
etendopublicadvcrm_create_activity1280.070.030.0010.000
etendopublicad_process_request_trg3280.070.050.0000.000
etendopublicau_psat_request_trg120.070.060.0060.005
etendopublicpsat_set_rel_request_activity230.070.040.0030.002
etendopubliccus_act_log_desc_ol_trg180.050.020.0030.001
etendopublicau_psat_activity_materials_trg110.050.040.0040.004
etendopublicc_ordline_chk_restrictions_trg1890.050.040.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables263288831993288854
etendopg_defaultprofilelast_stat_indexes26541191297541192
etendopg_defaultprofilelast_stat_user_functions268257904825746
etendopg_defaultpublicc_invoice23289605
etendopg_defaultpg_catalogpg_statistic21640813551
postgrespg_defaultpg_catalogpg_type1157157
postgrespg_defaultpg_catalogpg_attribute112151215
postgrespg_defaultpg_catalogpg_class1107388107129
postgrespg_defaultpg_catalogpg_statistic1478375
etendopg_defaultpg_catalogpg_type121872189
etendopg_defaultpg_catalogpg_attribute12433324333
etendopg_defaultpg_catalogpg_class11887672818871375
etendopg_defaultpg_catalogpg_index1527527
etendopg_defaultpublicad_ep_instance_para18585
etendopg_defaultpublicad_pinstance115302828
etendopg_defaultpublicad_process_run1304304315
etendopg_defaultpublicprsync_entry15041006268969
etendopg_defaultprofilelast_stat_database18888

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables47233288831993288854
etendopg_defaultprofilelast_stat_indexes4723541191297541192
etendopg_defaultprofilelast_stat_user_functions47238257904825746
etendopg_defaultpublicc_invoice123289605
etendopg_defaultprofilelast_stat_tablespaces224444
etendopg_defaultpublicad_session152518581831
etendopg_defaultpublicad_process_request16328322
postgrespg_globalpg_catalogpg_pltemplate3
postgrespg_globalpg_catalogpg_tablespace3
postgrespg_globalpg_catalogpg_shdepend3719720
postgrespg_globalpg_catalogpg_authid3
postgrespg_globalpg_catalogpg_database3
postgrespg_globalpg_catalogpg_shdescription3
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_tablespace3
etendopg_globalpg_catalogpg_shdepend3719720

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc90 MB233992 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_key62 MB232752 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_bpartner57 MB232544 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_docno48 MB232144 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_paid43 MB231933 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_posted43 MB231922 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_salesrep42 MB231853 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_updated35 MB231570 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_ad_user35 MB231562 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_order29 MB231305 kB23 MB
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes10 MB26395 kB1529 kB
etendopg_defaultprofilelast_stat_tablespk_last_stat_tables5776 kB26221 kB1209 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index1096 kB11096 kB4304 kB
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index752 kB2376 kB4724 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index720 kB1720 kB4304 kB
etendopg_defaultpublicprsync_entryprsync_entry_key456 kB1456 kB4112 kB
etendopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index368 kB493 kB3896 kB
etendopg_defaultpublicad_process_runad_process_run_ad_prequest_id320 kB1320 kB10 MB
etendopg_defaultpublicad_process_runad_process_run_key312 kB1312 kB10 MB
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_tables241383102117024 kB
etendopublicad_process_run5135531911 MB
etendopublicfin_payment_schedule606176015 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_run513553120232026-07-16 19:29:40.749568+0211 MB
etendoprofilesample_stat_tables24138310284432026-07-16 23:00:44.928998+027024 kB
etendopublicfin_payment_schedule6061761602025-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-15 05:00:03.654971+02
pg_conf_load_time2026-07-16 05:00:04.153843+022026-07-16 06:00:02+02
pg_postmaster_start_time2026-07-15 05:00:03.780547+02
pg_postmaster_start_time2026-07-16 05:00:04.286147+022026-07-16 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