Postgres profile report (StartID: 618, EndID: 641)

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-19 04:00:01+02 - 2026-07-20 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
etendo1986682099.74506519195492976210741876384609186663903217074295052855 MB-11 MB
postgres1186999.8311657032071985078365311201286617726399 kB40 kB
Total2105372099.74507684196196183212726954388262296684023225734312772861 MB-11 MB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
etendo16784400908.7746.73151130434660652892081602416242614507
postgres561912.96127526235349
template163469.0447468237278
Total16796365930.7646.73151305428660652892086322416242615134

Cluster statistics

MetricValue
Scheduled checkpoints275
Requested checkpoints1
Checkpoint write time (s)9376.25
Checkpoint sync time (s)6.68
Checkpoints buffers written112727
Background buffers written
Backend buffers written142706
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated501637
WAL generated3670 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default2875 MB-11 MB
pg_global542 kB

SQL query statistics

Top SQL by execution time

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

4108c96b3f

[ca2988bd]

etendo361.2438.814635909.913803.0861691.99587.200397

adb1c31f79

[948be82f]

etendo125.3013.46125298.419125298.419125298.4191

73e3636bec

[f410d7e7]

etendo76.728.242883220.2660.1336.7020.090288322

c9e2eb425b

[de5cc8a]

etendo35.373.8090190990.0030.0025.7670.00313528346

228d74fbf5

[cd9c0fd2]

etendo33.723.621349933716.66833716.66833716.6681

a3313bd40b

[82c041c2]

etendo21.932.36756200.2900.0032.9380.14275621

0c133f89fa

[47df1ade]

etendo17.331.8623753.631669.3631232.961130.03323

b9bb8a4422

[eb812a48]

etendo17.331.86753.438669.2011232.791130.03023

5c87b0f400

[12d7a4ea]

etendo16.981.82629500.2700.0082.9620.13462950

68df615c0c

[c63702b7]

etendo16.611.78630310.2640.0075.0340.12663031

82ff706627

[faf3330c]

etendo15.841.70203719.911697.212774.57719.16422

1d911b5cd9

[1c4d8fed]

etendo11.261.2127744.0591.67214.3201.5952774

671fe12038

[66c83919]

etendo8.540.9219038678535.8668535.8668535.8661

8d70b1244b

[9d1e690d]

etendo8.110.87378370.2140.0072.9190.10937837

503324b603

[d34207c3]

etendo6.060.652535520.0210.0050.8200.010289369

0b651ca53d

[7318d810]

etendo5.200.566745585196.8755196.8755196.8751

785a907bc3

[92946197]

etendo4.730.51694205.833194.832220.1076.48323

c2b6cfc2bf

[ad3afc69]

etendo4.470.4810304311.5790.9038.8200.8462831

7c49e0fca3

[37eecc4]

etendo4.460.488.8467.23419.8561.633504

d0b36135c7

[a0544a5f]

etendo3.740.403287881.33521.891200.88256.69646

Top SQL by executions

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

c9e2eb425b

[de5cc8a]

etendo1352834680.5490190990.0030.0025.7670.00335.4

9625146448

[b7edb1a4]

etendo2896941.722896940.0100.0071.0230.0052.9

503324b603

[d34207c3]

etendo2893691.722535520.0210.0050.8200.0106.1

0c13a0abe2

[4ed26d58]

etendo2893691.72312930.0100.0060.9700.0053.0

73e3636bec

[f410d7e7]

etendo2883221.722883220.2660.1336.7020.09076.7

9ea37f4950

[39cec726]

etendo2564041.532564040.0090.0072.6550.0072.4

1b3d7b3f6d

[a00bdbff]

etendo2080951.240.0060.0040.4990.0031.3

df99961951

[9cb9259b]

etendo1628860.971628860.0180.0120.4040.0072.9

891e82e5c1

[5a0bb3c]

etendo1007720.601007720.0030.0020.0610.0010.3

a3313bd40b

[82c041c2]

etendo756210.45756200.2900.0032.9380.14221.9

31575b9c84

[58eaeec5]

etendo756210.45756210.0050.0030.4220.0050.4

753e2f546e

[51919d48]

etendo630400.38630400.0050.0030.9930.0060.3

68df615c0c

[c63702b7]

etendo630310.38630310.2640.0075.0340.12616.6

e71569bd69

[d2ee2fda]

etendo629540.37629540.0050.0030.4970.0050.3

5c87b0f400

[12d7a4ea]

etendo629500.37629500.2700.0082.9620.13417.0

5c208ba241

[381eb299]

etendo538050.32538050.0140.0112.4990.0120.8

fa1b74d06f

[c1b84187]

etendo493120.293593750.0400.0151.0200.0382.0

ebd66f2e50

[2f2197e3]

etendo493120.29307510.0140.0060.3230.0080.7

a28450b83c

[b23cd0f0]

etendo378430.23378430.0050.0030.4610.0050.2

8d70b1244b

[9d1e690d]

etendo378370.23378370.2140.0072.9190.1098.1

Top SQL by shared blocks fetched

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

4108c96b3f

[ca2988bd]

etendo8288837654.78100.00361.24635397

c9e2eb425b

[de5cc8a]

etendo135283468.94100.0035.4901909913528346

73e3636bec

[f410d7e7]

etendo95471396.3199.9776.7288322288322

82ff706627

[faf3330c]

etendo64788854.28100.0015.820322

0c133f89fa

[47df1ade]

etendo47910393.1799.9817.32323

b9bb8a4422

[eb812a48]

etendo47909013.1799.9817.323

adb1c31f79

[948be82f]

etendo30405952.0184.22125.31

58d3d7b94c

[303fdc1e]

etendo23227971.54100.001.3240323

785a907bc3

[92946197]

etendo16360961.0899.974.769423

5fa24dc926

[22217272]

etendo16181191.07100.002.15103723

c2b6cfc2bf

[ad3afc69]

etendo12555270.83100.004.510304312831

11b3a7981f

[61e12bc8]

etendo11769100.7899.923.0114

9625146448

[b7edb1a4]

etendo9086240.60100.002.9289694289694

0c13a0abe2

[4ed26d58]

etendo9069560.60100.003.031293289369

503324b603

[d34207c3]

etendo8313470.55100.006.1253552289369

9ea37f4950

[39cec726]

etendo7765000.51100.002.4256404256404

7c49e0fca3

[37eecc4]

etendo7585200.50100.004.5504

0f194ad1e6

[6d193752]

etendo6335620.42100.002.02548719

7e97660189

[24aa4a29]

etendo5603710.37100.001.821622155

df99961951

[9cb9259b]

etendo4896700.32100.002.9162886162886

Top SQL by shared blocks read

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

adb1c31f79

[948be82f]

etendo47987694.1684.22125.31

e3ffffd609

[23e506a2]

etendo32880.650.660.0431

73e3636bec

[f410d7e7]

etendo24800.4999.9776.7288322288322

50b8978166

[b54ea3e2]

etendo21510.4299.442.160

12a81791af

[7eea2aca]

etendo19880.3998.790.51779917799

11b3a7981f

[61e12bc8]

etendo9920.1999.923.0114

0c247acdf0

[948be82f]

template19770.1997.582.81

2e0b729b87

[948be82f]

postgres9490.1997.663.01

0c133f89fa

[47df1ade]

etendo9340.1899.9817.32323

b9bb8a4422

[eb812a48]

etendo9340.1899.9817.323

3db6ec29e3

[262cee45]

etendo5880.1299.521.51313

ce6a86d8e2

[61de0adf]

etendo5880.1299.521.51313

b8b9950890

[532de794]

etendo5650.1198.690.515011501

cbb0d2e65e

[4ec9dd54]

etendo5340.1090.340.166

785a907bc3

[92946197]

etendo4970.1099.974.769423

b1ad12ea83

[da3ad8a5]

etendo4340.0996.680.2120120

1e7f08819e

[c94f617e]

etendo3810.0797.820.1107107

24a71b82fd

[cbb8c03]

etendo3730.0799.781.64949

db982ac21b

[2c476950]

etendo3470.0796.980.2120120

3712ef7645

[5b6852b2]

etendo3440.0798.070.2129129

Top SQL by shared blocks dirtied

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

73e3636bec

[f410d7e7]

etendo6961033.3699.9776.7288322288322

adb1c31f79

[948be82f]

etendo6237629.9084.22125.31

0c133f89fa

[47df1ade]

etendo158937.6299.9817.32323

b9bb8a4422

[eb812a48]

etendo158937.6299.9817.323

fdd1193fad

[3b0e4e8a]

etendo40531.9499.963.65411946

d0b36135c7

[a0544a5f]

etendo32521.5699.973.73287846

b8b9950890

[532de794]

etendo19490.9398.690.515011501

140f3eb685

[59d1e156]

etendo17030.8299.520.92222

3db6ec29e3

[262cee45]

etendo14990.7299.521.51313

ce6a86d8e2

[61de0adf]

etendo14990.7299.521.51313

c525c04235

[d2f1c69a]

etendo13940.6799.220.1265265

f2247347b1

[5a960627]

etendo10240.4999.801.72929

2e4c60dda8

[655cd7a1]

etendo10240.4999.801.72929

09d3ab2d00

[f574fa6a]

etendo10240.4999.801.72929

24a71b82fd

[cbb8c03]

etendo8680.4299.781.64949

4813705ddb

[6f2d0383]

etendo8040.39100.000.313451345

f68dd8a1a9

[d422fd3a]

etendo7490.36100.000.534

1e7f08819e

[c94f617e]

etendo6380.3197.820.1107107

5a01956e14

[2424fc9a]

etendo6350.3099.681.01313

07181527b0

[f6f43f8d]

etendo5870.28100.000.03529515

Top SQL by shared blocks written

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

adb1c31f79

[948be82f]

etendo5838322.8640.9184.22125.31

0c247acdf0

[948be82f]

template1550.020.0497.582.81

2e0b729b87

[948be82f]

postgres550.020.0497.663.01

Top SQL by temp usage

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

31575b9c84

[58eaeec5]

etendo7749699.1962825.890.47562175621

753e2f546e

[51919d48]

etendo6461299.1852721.720.36304063040

e71569bd69

[d2ee2fda]

etendo6451499.1952321.560.36295462954

a28450b83c

[b23cd0f0]

etendo3878899.1831813.110.23784337843

b5b8008cb0

[155c5d36]

etendo1294399.171084.450.11262812628

71c019dfbe

[3ce2fef5]

etendo1296099.171084.450.11264512645

89ed435807

[e8f7715e]

etendo1291499.171074.410.11260212602

6757558638

[ce05bc80]

etendo1290299.181064.370.11259012590

2b694e3baa

[23248c6]

etendo1190.9110.040.01111

Complete list of SQL texts

QueryIDQuery Text
2b694e3baainsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
24a71b82fdSELECT AD_EXTENSION_POINT_HANDLER(v_ep_instance, v_extension_point_id)
c9e2eb425bSELECT LEVELNO FROM AD_ORG_TREE WHERE AD_ORG_ID = p_orgid AND AD_PARENT_ORG_ID = p_parentorgid AND AD_CLIENT_ID = p_clientid
5c87b0f400delete from ad_context_info
b5b8008cb0insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
1d911b5cd9select adsystem0_.AD_System_ID as AD_Syste1_115_0_, adsystem0_.AD_Client_ID as AD_Clien2_115_0_, adsystem0_.AD_Org_ID as AD_Org_I3_115_0_, adsystem0_.IsActive as IsActive4_115_0_, adsystem0_.Created as Created5_115_0_, adsystem0_.CreatedBy as CreatedB6_115_0_, adsystem0_.Updated as Updated7_115_0_, adsystem0_.UpdatedBy as UpdatedB8_115_0_, adsystem0_.Name as Name9_115_0_, adsystem0_.Info as Info10_115_0_, adsystem0_.Version as Version11_115_0_, adsystem0_.ReleaseNo as Release12_115_0_, adsystem0_.TAD_Recordrange as TAD_Rec13_115_0_, adsystem0_.TAD_Recordrange_Info as TAD_Rec14_115_0_, adsystem0_.TAD_Transactionalrange as TAD_Tra15_115_0_, adsystem0_.TAD_Theme as TAD_The16_115_0_, adsystem0_.Instance_Key as Instanc17_115_0_, adsystem0_.Activation_Key as Activat18_115_0_ from AD_System adsystem0_ where adsystem0_.AD_System_ID=$1
5fa24dc926SELECT st.*,stio.idx_blks_read,stio.idx_blks_hit,CASE l.relation WHEN st.indexrelid THEN $1 ELSE pg_relation_size(st.indexrelid) END relsize,$2,pg_class.reltablespace as tablespaceid,(ix.indisunique OR con.conindid IS NOT NULL) AS indisunique,pg_class.relpages::bigint * current_setting($3)::bigint AS relpages_bytes,$4 AS relpages_bytes_diff FROM pg_catalog.pg_stat_all_indexes st JOIN pg_catalog.pg_statio_all_indexes stio USING (relid, indexrelid, schemaname, relname, indexrelname) JOIN pg_catalog.pg_index ix ON (ix.indexrelid = st.indexrelid) JOIN pg_catalog.pg_class ON (pg_class.oid = st.indexrelid) LEFT OUTER JOIN pg_catalog.pg_constraint con ON (con.conindid = ix.indexrelid AND con.contype in ($5,$6)) LEFT OUTER JOIN LATERAL (SELECT relation FROM pg_catalog.pg_locks WHERE (relation = st.indexrelid AND granted AND locktype = $7 AND mode=$8)) l ON (l.relation = st.indexrelid)
e3ffffd609select psat_check0_.Psat_Checklist_Result_ID as Psat_Che1_730_, psat_check0_.AD_Client_ID as AD_Clien2_730_, psat_check0_.AD_Org_ID as AD_Org_I3_730_, psat_check0_.Isactive as Isactive4_730_, psat_check0_.Created as Created5_730_, psat_check0_.Createdby as Createdb6_730_, psat_check0_.Updated as Updated7_730_, psat_check0_.Updatedby as Updatedb8_730_, psat_check0_.Advcrm_Activity_ID as Advcrm_A9_730_, psat_check0_.Result as Result10_730_, psat_check0_.Psat_Check_Type_ID as Psat_Ch11_730_, psat_check0_.Psat_Checklist_Group_ID as Psat_Ch12_730_, psat_check0_.AD_Image_ID as AD_Imag13_730_, psat_check0_.Description as Descrip14_730_ from psat_checklist_result psat_check0_ where psat_check0_.Advcrm_Activity_ID=$1 and (psat_check0_.AD_Org_ID in ($2 , $3 , $4 , $5)) and (psat_check0_.AD_Client_ID in ($6 , $7)) order by psat_check0_.Result, psat_check0_.Psat_Checklist_Result_ID limit $8
5a01956e14SELECT C_INVOICE_POST($3, p_Invoice_ID)
7e97660189select t.ad_tab_id from ad_tab t where t.ad_window_id = $1 and t.seqno = ( select max(seqno) from ad_tab where ad_window_id = t.ad_window_id and tabLevel = (TO_NUMBER($2)-$4) and seqno < TO_NUMBER($3) )
3db6ec29e3SELECT * FROM C_Invoice_Create0($1)
db982ac21bINSERT INTO C_ORDERLINETAX ( C_OrderLineTax_ID, C_OrderLine_ID, C_Order_ID, C_Tax_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, TaxBaseAmt, TaxAmt, Line) VALUES ( GET_UUID(), p_orderline_id, p_order_id, p_tax_id, v_Client_ID, p_org_id, $20, TO_DATE(NOW()), p_user_id, TO_DATE(NOW()), p_user_id, v_TaxBaseAmount, ROUND(ROUND(v_TaxBaseAmount, p_StdPrecision) * v_Rate/$21, p_StdPrecision), v_LineNo)
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)
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 )
71c019dfbeinsert 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
753e2f546einsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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))
31575b9c84insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
140f3eb685SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)
f2247347b1SELECT C_ORDER_POST1(p_PInstance_ID, $2)
3712ef7645SELECT C_INVOICELINETAX_INSERT(new.AD_Org_ID, new.C_Invoice_ID, new.C_InvoiceLine_ID, new.UpdatedBy, new.C_Tax_ID, new.C_Tax_ID, v_newLineNetAmt, v_newLineAlternate, v_Prec)
ce6a86d8e2SELECT * FROM C_Invoice_Create(p_PInstance_ID, $2)
11b3a7981fselect invoicecan0_.C_Order_ID as col_0_0_, organizati2_.Name as col_1_0_, invoicecan0_.C_Doctype_ID as col_2_0_, invoicecan0_.Documentno as col_3_0_, businesspa3_.Name as col_4_0_, invoicecan0_.Dateordered as col_5_0_, case when $5=$6 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end as col_6_0_, case when invoicecan0_.Term=$7 then $8 when invoicecan0_.Term=$9 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $10=$11 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $12=$13 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end as col_7_0_, invoicecan0_.Term as col_8_0_, case when invoicecan0_.Term=$14 then $15 when invoicecan0_.Term=$16 then case when invoicecan0_.Term=$17 then $18 when invoicecan0_.Term=$19 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $20=$21 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $22=$23 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end when invoicecan0_.Term=$24 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then $25 else invoicecan0_.Pendinglines end as col_9_0_, invoicecan0_.Qtyordered as col_10_0_, invoicecan0_.Qtydelivered as col_11_0_, case when $26=$27 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end-(case when $28=$29 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end) as col_12_0_, invoicecan0_.Amountlinesgross as col_13_0_, invoicecan0_.Created as col_14_0_, invoicecan0_.Createdby as col_15_0_, invoicecan0_.Updated as col_16_0_, invoicecan0_.Updatedby as col_17_0_, documentty4_.C_DocType_ID as C_DocTyp1_225_0_, aduser5_.AD_User_ID as AD_User_1_129_1_, aduser6_.AD_User_ID as AD_User_1_129_2_, documentty4_.AD_Client_ID as AD_Clien2_225_0_, documentty4_.AD_Org_ID as AD_Org_I3_225_0_, documentty4_.IsActive as IsActive4_225_0_, documentty4_.Created as Created5_225_0_, documentty4_.CreatedBy as CreatedB6_225_0_, documentty4_.Updated as Updated7_225_0_, documentty4_.UpdatedBy as UpdatedB8_225_0_, documentty4_.Name as Name9_225_0_, documentty4_.PrintName as PrintNa10_225_0_, documentty4_.Description as Descrip11_225_0_, documentty4_.DocBaseType as DocBase12_225_0_, documentty4_.IsSOTrx as IsSOTrx13_225_0_, documentty4_.DocSubTypeSO as DocSubT14_225_0_, documentty4_.C_DocTypeShipment_ID as C_DocTy15_225_0_, documentty4_.C_DocTypeInvoice_ID as C_DocTy16_225_0_, documentty4_.IsDocNoControlled as IsDocNo17_225_0_, documentty4_.DocNoSequence_ID as DocNoSe18_225_0_, documentty4_.GL_Category_ID as GL_Cate19_225_0_, documentty4_.DocumentNote as Documen20_225_0_, documentty4_.IsDefault as IsDefau21_225_0_, documentty4_.DocumentCopies as Documen22_225_0_, documentty4_.AD_Table_ID as AD_Tabl23_225_0_, documentty4_.Orgfiltered as Orgfilt24_225_0_, documentty4_.C_Doctype_Reversed_ID as C_Docty25_225_0_, documentty4_.IsExpense as IsExpen26_225_0_, documentty4_.Isreversal as Isrever27_225_0_, documentty4_.IsReturn as IsRetur28_225_0_, documentty4_.C_Doctypeorder_ID as C_Docty29_225_0_, documentty4_.C_Doctypesimpinvoice_ID as C_Docty30_225_0_, documentty4_.EM_OBWPL_Useoutbound as EM_OBWP31_225_0_, documentty4_.EM_Prouti_C_Doctypeorder_ID as EM_Prou32_225_0_, documentty4_.C_Doctypeaggrinvoice_ID as C_Docty33_225_0_, documentty4_.EM_OBWPL_IsGroup as EM_OBWP34_225_0_, documentty4_.EM_OBWPL_GenerateShipment as EM_OBWP35_225_0_, documentty4_.EM_OBWPL_Shipmentdoctype_ID as EM_OBWP36_225_0_, documentty4_.EM_Pruti_Inforeport2 as EM_Prut37_225_0_, documentty4_.EM_Pruti_Inforeport as EM_Prut38_225_0_, aduser5_.AD_Client_ID as AD_Clien2_129_1_, aduser5_.AD_Org_ID as AD_Org_I3_129_1_, aduser5_.IsActive as IsActive4_129_1_, aduser5_.Created as Created5_129_1_, aduser5_.CreatedBy as CreatedB6_129_1_, aduser5_.Updated as Updated7_129_1_, aduser5_.UpdatedBy as UpdatedB8_129_1_, aduser5_.Name as Name9_129_1_, aduser5_.Description as Descrip10_129_1_, aduser5_.Password as Passwor11_129_1_, aduser5_.Email as Email12_129_1_, aduser5_.Supervisor_ID as Supervi13_129_1_, aduser5_.C_BPartner_ID as C_BPart14_129_1_, aduser5_.Processing as Process15_129_1_, aduser5_.EmailUser as EmailUs16_129_1_, aduser5_.EmailUserPW as EmailUs17_129_1_, aduser5_.C_BPartner_Location_ID as C_BPart18_129_1_, aduser5_.C_Greeting_ID as C_Greet19_129_1_, aduser5_.Title as Title20_129_1_, aduser5_.Comments as Comment21_129_1_, aduser5_.Phone as Phone22_129_1_, aduser5_.Phone2 as Phone23_129_1_, aduser5_.Fax as Fax24_129_1_, aduser5_.LastContact as LastCon25_129_1_, aduser5_.LastResult as LastRes26_129_1_, aduser5_.Birthday as Birthda27_129_1_, aduser5_.AD_OrgTrx_ID as AD_OrgT28_129_1_, aduser5_.Firstname as Firstna29_129_1_, aduser5_.Lastname as Lastnam30_129_1_, aduser5_.UserName as UserNam31_129_1_, aduser5_.Default_Ad_Client_ID as Default32_129_1_, aduser5_.Default_Ad_Language as Default33_129_1_, aduser5_.Default_Ad_Org_ID as Default34_129_1_, aduser5_.Default_Ad_Role_ID as Default35_129_1_, aduser5_.Default_M_Warehouse_ID as Default36_129_1_, aduser5_.IsLocked as IsLocke37_129_1_, aduser5_.AD_Image_ID as AD_Imag38_129_1_, aduser5_.Grant_Portal_Access as Grant_P39_129_1_, aduser5_.LastPasswordUpdate as LastPas40_129_1_, aduser5_.Isexpiredpassword as Isexpir41_129_1_, aduser5_.Commercialauth as Commerc42_129_1_, aduser5_.Viasms as Viasms43_129_1_, aduser5_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_1_, aduser5_.Viaemail as Viaemai45_129_1_, aduser5_.EM_Pruti_Isbillingcontact as EM_Prut46_129_1_, aduser5_.EM_Advcrm_Newsletter as EM_Advc47_129_1_, aduser5_.EM_Pruti_Isordercontact as EM_Prut48_129_1_, aduser5_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_1_, aduser5_.EM_Advcrm_sat_user as EM_Advc50_129_1_, aduser6_.AD_Client_ID as AD_Clien2_129_2_, aduser6_.AD_Org_ID as AD_Org_I3_129_2_, aduser6_.IsActive as IsActive4_129_2_, aduser6_.Created as Created5_129_2_, aduser6_.CreatedBy as CreatedB6_129_2_, aduser6_.Updated as Updated7_129_2_, aduser6_.UpdatedBy as UpdatedB8_129_2_, aduser6_.Name as Name9_129_2_, aduser6_.Description as Descrip10_129_2_, aduser6_.Password as Passwor11_129_2_, aduser6_.Email as Email12_129_2_, aduser6_.Supervisor_ID as Supervi13_129_2_, aduser6_.C_BPartner_ID as C_BPart14_129_2_, aduser6_.Processing as Process15_129_2_, aduser6_.EmailUser as EmailUs16_129_2_, aduser6_.EmailUserPW as EmailUs17_129_2_, aduser6_.C_BPartner_Location_ID as C_BPart18_129_2_, aduser6_.C_Greeting_ID as C_Greet19_129_2_, aduser6_.Title as Title20_129_2_, aduser6_.Comments as Comment21_129_2_, aduser6_.Phone as Phone22_129_2_, aduser6_.Phone2 as Phone23_129_2_, aduser6_.Fax as Fax24_129_2_, aduser6_.LastContact as LastCon25_129_2_, aduser6_.LastResult as LastRes26_129_2_, aduser6_.Birthday as Birthda27_129_2_, aduser6_.AD_OrgTrx_ID as AD_OrgT28_129_2_, aduser6_.Firstname as Firstna29_129_2_, aduser6_.Lastname as Lastnam30_129_2_, aduser6_.UserName as UserNam31_129_2_, aduser6_.Default_Ad_Client_ID as Default32_129_2_, aduser6_.Default_Ad_Language as Default33_129_2_, aduser6_.Default_Ad_Org_ID as Default34_129_2_, aduser6_.Default_Ad_Role_ID as Default35_129_2_, aduser6_.Default_M_Warehouse_ID as Default36_129_2_, aduser6_.IsLocked as IsLocke37_129_2_, aduser6_.AD_Image_ID as AD_Imag38_129_2_, aduser6_.Grant_Portal_Access as Grant_P39_129_2_, aduser6_.LastPasswordUpdate as LastPas40_129_2_, aduser6_.Isexpiredpassword as Isexpir41_129_2_, aduser6_.Commercialauth as Commerc42_129_2_, aduser6_.Viasms as Viasms43_129_2_, aduser6_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_2_, aduser6_.Viaemail as Viaemai45_129_2_, aduser6_.EM_Pruti_Isbillingcontact as EM_Prut46_129_2_, aduser6_.EM_Advcrm_Newsletter as EM_Advc47_129_2_, aduser6_.EM_Pruti_Isordercontact as EM_Prut48_129_2_, aduser6_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_2_, aduser6_.EM_Advcrm_sat_user as EM_Advc50_129_2_ from c_invoice_candidate_v invoicecan0_ inner join C_Order order1_ on invoicecan0_.C_Order_ID=order1_.C_Order_ID inner join AD_Org organizati2_ on invoicecan0_.AD_Org_ID=organizati2_.AD_Org_ID inner join C_BPartner businesspa3_ on invoicecan0_.C_Bpartner_ID=businesspa3_.C_BPartner_ID inner join C_DocType documentty4_ on invoicecan0_.C_Doctype_ID=documentty4_.C_DocType_ID inner join AD_User aduser5_ on invoicecan0_.Createdby=aduser5_.AD_User_ID inner join AD_User aduser6_ on invoicecan0_.Updatedby=aduser6_.AD_User_ID where (invoicecan0_.Term=$30 and invoicecan0_.Qtydelivered<>$31 and ($32=$33 and (exists (select $34 from C_OrderLine orderline7_ where orderline7_.C_Order_ID=order1_.C_Order_ID and orderline7_.QtyDelivered-orderline7_.QtyInvoiced<>$35)) or $36=$37) or invoicecan0_.Term=$38 and (exists (select $39 from C_OrderLine orderline8_ where orderline8_.C_Order_ID=order1_.C_Order_ID and orderline8_.QtyOrdered-orderline8_.QtyInvoiced<>$40)) or invoicecan0_.Term=$41 and (exists (select $42 from C_OrderLine orderline9_ where orderline9_.C_Order_ID=order1_.C_Order_ID and orderline9_.QtyDelivered<>$43 and orderline9_.QtyOrdered<>orderline9_.QtyInvoiced))) and (invoicecan0_.AD_Client_ID in ($44 , $1)) and (invoicecan0_.AD_Org_ID in ($2 , $3)) order by organizati2_.Name, businesspa3_.Name, invoicecan0_.Dateordered limit $4
2e4c60dda8SELECT C_ORDER_POST1($1, $2, $3)
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
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)
a3313bd40bdelete 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)
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
8d70b1244bdelete from ad_context_info
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 )
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
a28450b83cinsert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
50b8978166select order_comp0_.C_Order_ID as C_Order_1_265_0_, order_comp0_.AD_Client_ID as AD_Clien2_265_0_, order_comp0_.AD_Org_ID as AD_Org_I3_265_0_, (coalesce((select case when sum(abs(ol.qtyordered)) = $51 or order_comp0_.iscancelled = $52 or order_comp0_.cancelledorder_id is not null then $53 else round(coalesce(sum(abs(ol.qtydelivered)), $54)/sum(abs(ol.qtyordered)) * $55, $56) end from c_orderline ol where ol.c_order_id=order_comp0_.c_order_id and ol.c_order_discount_id is null),$57)) as formula28_0_, (coalesce(prouti_delavailablewithoutres(order_comp0_.c_order_id),$58)) as formula29_0_, (coalesce(prouti_deliveryavailable(order_comp0_.c_order_id),$59)) as formula30_0_, (select sum(prouti_qtyremainingorderline(ol.c_orderline_id)) from c_orderline ol where ol.c_order_id = order_comp0_.c_order_id) as formula31_0_, (select case when sum(ol.qtyordered)=$60 then $61 else trunc((sum(least(ol.qtyordered, coalesce(pool.qtyordered,$62))) / sum(ol.qtyordered) ) * $63) end from c_orderline ol left join c_orderline pool on pool.em_prouti_orderline_id=ol.c_orderline_id where ol.c_order_id=order_comp0_.c_order_id) as formula32_0_, (coalesce((select case when sum(abs(ol.qtyordered)) = $64 or order_comp0_.iscancelled = $65 or order_comp0_.cancelledorder_id is not null then $66 else round(coalesce(sum(abs(ol.qtyinvoiced)), $67)/sum(abs(ol.qtyordered)) * $68, $69) end from c_orderline ol where ol.c_order_id=order_comp0_.c_order_id and ol.c_order_discount_id is null), $70)) as formula33_0_, (coalesce((select case when sum(fps.amount) = $71 then $72 else round(sum(fps.paidamt)/sum(fps.amount) * $73, $74) end from FIN_Payment_Schedule fps where fps.c_order_id=order_comp0_.c_order_id),$75)) as formula34_0_ from C_Order order_comp0_ where order_comp0_.C_Order_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50)
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
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
68df615c0cdelete from ad_context_info
1e7f08819eINSERT INTO Fact_Acct (Fact_Acct_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy, C_AcctSchema_ID,Account_ID, AcctValue, AcctDescription,DateTrx,DateAcct, C_Period_ID,AD_Table_ID,Record_ID,Line_ID, GL_Category_ID,C_Tax_ID,PostingType,C_Currency_ID, AmtSourceDR,AmtSourceCR,AmtAcctDR,AmtAcctCR, C_UOM_ID,Qty,M_Locator_ID,M_Product_ID,C_BPartner_ID,AD_OrgTrx_ID,C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID,C_Campaign_ID,C_Activity_ID,User1_ID,User2_ID,Description, Fact_Acct_Group_ID, SeqNo, DocBaseType, Record_ID2, A_ASSET_ID, C_WithHolding_ID, C_DocType_ID, C_Costcenter_ID, FACTACCTTYPE) VALUES ($1, $2, $3,$48,now(),$4,now(),$5, $6, $7, $8, $9, TO_DATE($10), TO_DATE($11), $12, $13, $14, $15, $16, $17, $18, $19, TO_NUMBER($20), TO_NUMBER($21), TO_NUMBER($22), TO_NUMBER($23), $24, TO_NUMBER($25), $26,$27, $28, $29,$30, $31, $32,$33, $34, $35,$36, $37, $38, $39, TO_NUMBER($40), $41, $42, $43, $44, $45, $46, $47)
4108c96b3fselect productbyp0_.M_Product_Price_Warehouse_V_ID as M_Produc1_469_, productbyp0_.AD_Client_ID as AD_Clien2_469_, productbyp0_.AD_Org_ID as AD_Org_I3_469_, productbyp0_.Isactive as Isactive4_469_, productbyp0_.Updated as Updated5_469_, productbyp0_.Updatedby as Updatedb6_469_, productbyp0_.Created as Created7_469_, productbyp0_.Createdby as Createdb8_469_, productbyp0_.M_Product_ID as M_Produc9_469_, productbyp0_.M_Warehouse_ID as M_Wareh10_469_, productbyp0_.M_Productprice_ID as M_Produ11_469_, productbyp0_.QTY_Available as QTY_Ava12_469_, productbyp0_.QTY_Onhand as QTY_Onh13_469_, productbyp0_.QTY_Reserved as QTY_Res14_469_, productbyp0_.QTY_Ordered as QTY_Ord15_469_, productbyp0_.Pricelist as Priceli16_469_, productbyp0_.Pricestd as Pricest17_469_, productbyp0_.Pricelimit as Priceli18_469_, productbyp0_.Orgwarehouse as Orgware19_469_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID=product1_.M_Product_ID cross join M_ProductPrice pricingpro4_ cross join M_PriceList_Version pricingpri5_ cross join M_PriceList pricingpri9_ where productbyp0_.M_Productprice_ID=pricingpro4_.M_ProductPrice_ID and pricingpro4_.M_PriceList_Version_ID=pricingpri5_.M_PriceList_Version_ID and pricingpri5_.M_PriceList_ID=pricingpri9_.M_PriceList_ID and (upper(product1_.Value) like upper($1) escape $12 or upper(product1_.Name) like upper($2) escape $13 or upper((product1_.Value||$14||coalesce(to_char((select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID=product1_.M_Product_ID and producttrl2_.AD_Language=$15)), to_char(product1_.Name), $16))) like upper($3) escape $17 or upper((product1_.Value||$18||coalesce(to_char((select producttrl3_.Name from M_Product_Trl producttrl3_ where producttrl3_.M_Product_ID=product1_.M_Product_ID and producttrl3_.AD_Language=$19)), to_char(product1_.Name), $20))) like upper($4) escape $21) and (productbyp0_.AD_Org_ID in ($22 , $23)) and productbyp0_.Isactive=$24 and AD_ORG_ISINNATURALTREE(productbyp0_.Orgwarehouse, $5, $6)=$25 and pricingpri5_.IsActive=$26 and AD_ORG_ISINNATURALTREE(pricingpro4_.AD_Org_ID, $7, $8)=$27 and pricingpri9_.IsSOPriceList=$28 and pricingpri9_.C_Currency_ID=$29 and pricingpro4_.M_PriceList_Version_ID=$30 and productbyp0_.M_Warehouse_ID=$31 and (productbyp0_.AD_Client_ID in ($9 , $10)) and productbyp0_.Isactive=$32 order by product1_.Value, product1_.Name, product1_.M_Product_ID limit $11
228d74fbf5COPY public.ad_image (ad_image_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, imageurl, binarydata, width, height, mimetype) TO stdout
6757558638insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
e71569bd69insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
b1ad12ea83SELECT C_ORDERLINETAX_INSERT(new.AD_Org_ID, new.C_Order_ID, new.C_OrderLine_ID, new.UpdatedBy, new.C_Tax_ID, new.C_Tax_ID, v_newLineNetAmt, v_newLineAlternate, v_Prec)
89ed435807insert 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
09d3ab2d00SELECT * FROM C_Order_Post($1)
07181527b0DELETE FROM last_stat_indexes WHERE server_id=sserver_id AND sample_id != s_id
82ff706627select invoicecan0_.C_Order_ID as col_0_0_, organizati2_.Name as col_1_0_, invoicecan0_.C_Doctype_ID as col_2_0_, invoicecan0_.Documentno as col_3_0_, businesspa3_.Name as col_4_0_, invoicecan0_.Dateordered as col_5_0_, case when $5=$6 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end as col_6_0_, case when invoicecan0_.Term=$7 then $8 when invoicecan0_.Term=$9 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $10=$11 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $12=$13 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end as col_7_0_, invoicecan0_.Term as col_8_0_, case when invoicecan0_.Term=$14 then $15 when invoicecan0_.Term=$16 then case when invoicecan0_.Term=$17 then $18 when invoicecan0_.Term=$19 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $20=$21 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $22=$23 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end when invoicecan0_.Term=$24 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then $25 else invoicecan0_.Pendinglines end as col_9_0_, invoicecan0_.Qtyordered as col_10_0_, invoicecan0_.Qtydelivered as col_11_0_, case when $26=$27 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end-(case when $28=$29 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end) as col_12_0_, invoicecan0_.Amountlinesgross as col_13_0_, invoicecan0_.Created as col_14_0_, invoicecan0_.Createdby as col_15_0_, invoicecan0_.Updated as col_16_0_, invoicecan0_.Updatedby as col_17_0_, documentty4_.C_DocType_ID as C_DocTyp1_225_0_, aduser5_.AD_User_ID as AD_User_1_129_1_, aduser6_.AD_User_ID as AD_User_1_129_2_, documentty4_.AD_Client_ID as AD_Clien2_225_0_, documentty4_.AD_Org_ID as AD_Org_I3_225_0_, documentty4_.IsActive as IsActive4_225_0_, documentty4_.Created as Created5_225_0_, documentty4_.CreatedBy as CreatedB6_225_0_, documentty4_.Updated as Updated7_225_0_, documentty4_.UpdatedBy as UpdatedB8_225_0_, documentty4_.Name as Name9_225_0_, documentty4_.PrintName as PrintNa10_225_0_, documentty4_.Description as Descrip11_225_0_, documentty4_.DocBaseType as DocBase12_225_0_, documentty4_.IsSOTrx as IsSOTrx13_225_0_, documentty4_.DocSubTypeSO as DocSubT14_225_0_, documentty4_.C_DocTypeShipment_ID as C_DocTy15_225_0_, documentty4_.C_DocTypeInvoice_ID as C_DocTy16_225_0_, documentty4_.IsDocNoControlled as IsDocNo17_225_0_, documentty4_.DocNoSequence_ID as DocNoSe18_225_0_, documentty4_.GL_Category_ID as GL_Cate19_225_0_, documentty4_.DocumentNote as Documen20_225_0_, documentty4_.IsDefault as IsDefau21_225_0_, documentty4_.DocumentCopies as Documen22_225_0_, documentty4_.AD_Table_ID as AD_Tabl23_225_0_, documentty4_.Orgfiltered as Orgfilt24_225_0_, documentty4_.C_Doctype_Reversed_ID as C_Docty25_225_0_, documentty4_.IsExpense as IsExpen26_225_0_, documentty4_.Isreversal as Isrever27_225_0_, documentty4_.IsReturn as IsRetur28_225_0_, documentty4_.C_Doctypeorder_ID as C_Docty29_225_0_, documentty4_.C_Doctypesimpinvoice_ID as C_Docty30_225_0_, documentty4_.EM_OBWPL_Useoutbound as EM_OBWP31_225_0_, documentty4_.EM_Prouti_C_Doctypeorder_ID as EM_Prou32_225_0_, documentty4_.C_Doctypeaggrinvoice_ID as C_Docty33_225_0_, documentty4_.EM_OBWPL_IsGroup as EM_OBWP34_225_0_, documentty4_.EM_OBWPL_GenerateShipment as EM_OBWP35_225_0_, documentty4_.EM_OBWPL_Shipmentdoctype_ID as EM_OBWP36_225_0_, documentty4_.EM_Pruti_Inforeport2 as EM_Prut37_225_0_, documentty4_.EM_Pruti_Inforeport as EM_Prut38_225_0_, aduser5_.AD_Client_ID as AD_Clien2_129_1_, aduser5_.AD_Org_ID as AD_Org_I3_129_1_, aduser5_.IsActive as IsActive4_129_1_, aduser5_.Created as Created5_129_1_, aduser5_.CreatedBy as CreatedB6_129_1_, aduser5_.Updated as Updated7_129_1_, aduser5_.UpdatedBy as UpdatedB8_129_1_, aduser5_.Name as Name9_129_1_, aduser5_.Description as Descrip10_129_1_, aduser5_.Password as Passwor11_129_1_, aduser5_.Email as Email12_129_1_, aduser5_.Supervisor_ID as Supervi13_129_1_, aduser5_.C_BPartner_ID as C_BPart14_129_1_, aduser5_.Processing as Process15_129_1_, aduser5_.EmailUser as EmailUs16_129_1_, aduser5_.EmailUserPW as EmailUs17_129_1_, aduser5_.C_BPartner_Location_ID as C_BPart18_129_1_, aduser5_.C_Greeting_ID as C_Greet19_129_1_, aduser5_.Title as Title20_129_1_, aduser5_.Comments as Comment21_129_1_, aduser5_.Phone as Phone22_129_1_, aduser5_.Phone2 as Phone23_129_1_, aduser5_.Fax as Fax24_129_1_, aduser5_.LastContact as LastCon25_129_1_, aduser5_.LastResult as LastRes26_129_1_, aduser5_.Birthday as Birthda27_129_1_, aduser5_.AD_OrgTrx_ID as AD_OrgT28_129_1_, aduser5_.Firstname as Firstna29_129_1_, aduser5_.Lastname as Lastnam30_129_1_, aduser5_.UserName as UserNam31_129_1_, aduser5_.Default_Ad_Client_ID as Default32_129_1_, aduser5_.Default_Ad_Language as Default33_129_1_, aduser5_.Default_Ad_Org_ID as Default34_129_1_, aduser5_.Default_Ad_Role_ID as Default35_129_1_, aduser5_.Default_M_Warehouse_ID as Default36_129_1_, aduser5_.IsLocked as IsLocke37_129_1_, aduser5_.AD_Image_ID as AD_Imag38_129_1_, aduser5_.Grant_Portal_Access as Grant_P39_129_1_, aduser5_.LastPasswordUpdate as LastPas40_129_1_, aduser5_.Isexpiredpassword as Isexpir41_129_1_, aduser5_.Commercialauth as Commerc42_129_1_, aduser5_.Viasms as Viasms43_129_1_, aduser5_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_1_, aduser5_.Viaemail as Viaemai45_129_1_, aduser5_.EM_Pruti_Isbillingcontact as EM_Prut46_129_1_, aduser5_.EM_Advcrm_Newsletter as EM_Advc47_129_1_, aduser5_.EM_Pruti_Isordercontact as EM_Prut48_129_1_, aduser5_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_1_, aduser5_.EM_Advcrm_sat_user as EM_Advc50_129_1_, aduser6_.AD_Client_ID as AD_Clien2_129_2_, aduser6_.AD_Org_ID as AD_Org_I3_129_2_, aduser6_.IsActive as IsActive4_129_2_, aduser6_.Created as Created5_129_2_, aduser6_.CreatedBy as CreatedB6_129_2_, aduser6_.Updated as Updated7_129_2_, aduser6_.UpdatedBy as UpdatedB8_129_2_, aduser6_.Name as Name9_129_2_, aduser6_.Description as Descrip10_129_2_, aduser6_.Password as Passwor11_129_2_, aduser6_.Email as Email12_129_2_, aduser6_.Supervisor_ID as Supervi13_129_2_, aduser6_.C_BPartner_ID as C_BPart14_129_2_, aduser6_.Processing as Process15_129_2_, aduser6_.EmailUser as EmailUs16_129_2_, aduser6_.EmailUserPW as EmailUs17_129_2_, aduser6_.C_BPartner_Location_ID as C_BPart18_129_2_, aduser6_.C_Greeting_ID as C_Greet19_129_2_, aduser6_.Title as Title20_129_2_, aduser6_.Comments as Comment21_129_2_, aduser6_.Phone as Phone22_129_2_, aduser6_.Phone2 as Phone23_129_2_, aduser6_.Fax as Fax24_129_2_, aduser6_.LastContact as LastCon25_129_2_, aduser6_.LastResult as LastRes26_129_2_, aduser6_.Birthday as Birthda27_129_2_, aduser6_.AD_OrgTrx_ID as AD_OrgT28_129_2_, aduser6_.Firstname as Firstna29_129_2_, aduser6_.Lastname as Lastnam30_129_2_, aduser6_.UserName as UserNam31_129_2_, aduser6_.Default_Ad_Client_ID as Default32_129_2_, aduser6_.Default_Ad_Language as Default33_129_2_, aduser6_.Default_Ad_Org_ID as Default34_129_2_, aduser6_.Default_Ad_Role_ID as Default35_129_2_, aduser6_.Default_M_Warehouse_ID as Default36_129_2_, aduser6_.IsLocked as IsLocke37_129_2_, aduser6_.AD_Image_ID as AD_Imag38_129_2_, aduser6_.Grant_Portal_Access as Grant_P39_129_2_, aduser6_.LastPasswordUpdate as LastPas40_129_2_, aduser6_.Isexpiredpassword as Isexpir41_129_2_, aduser6_.Commercialauth as Commerc42_129_2_, aduser6_.Viasms as Viasms43_129_2_, aduser6_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_2_, aduser6_.Viaemail as Viaemai45_129_2_, aduser6_.EM_Pruti_Isbillingcontact as EM_Prut46_129_2_, aduser6_.EM_Advcrm_Newsletter as EM_Advc47_129_2_, aduser6_.EM_Pruti_Isordercontact as EM_Prut48_129_2_, aduser6_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_2_, aduser6_.EM_Advcrm_sat_user as EM_Advc50_129_2_ from c_invoice_candidate_v invoicecan0_ inner join C_Order order1_ on invoicecan0_.C_Order_ID=order1_.C_Order_ID inner join AD_Org organizati2_ on invoicecan0_.AD_Org_ID=organizati2_.AD_Org_ID inner join C_BPartner businesspa3_ on invoicecan0_.C_Bpartner_ID=businesspa3_.C_BPartner_ID inner join C_DocType documentty4_ on invoicecan0_.C_Doctype_ID=documentty4_.C_DocType_ID inner join AD_User aduser5_ on invoicecan0_.Createdby=aduser5_.AD_User_ID inner join AD_User aduser6_ on invoicecan0_.Updatedby=aduser6_.AD_User_ID where (invoicecan0_.Term=$30 and invoicecan0_.Qtydelivered<>$31 and ($32=$33 and (exists (select $34 from C_OrderLine orderline7_ where orderline7_.C_Order_ID=order1_.C_Order_ID and orderline7_.QtyDelivered-orderline7_.QtyInvoiced<>$35)) or $36=$37) or invoicecan0_.Term=$38 and (exists (select $39 from C_OrderLine orderline8_ where orderline8_.C_Order_ID=order1_.C_Order_ID and orderline8_.QtyOrdered-orderline8_.QtyInvoiced<>$40)) or invoicecan0_.Term=$41 and (exists (select $42 from C_OrderLine orderline9_ where orderline9_.C_Order_ID=order1_.C_Order_ID and orderline9_.QtyDelivered<>$43 and orderline9_.QtyOrdered<>orderline9_.QtyInvoiced))) and (invoicecan0_.AD_Client_ID in ($44 , $1)) and (invoicecan0_.AD_Org_ID in ($2 , $3)) order by invoicecan0_.Dateordered desc, invoicecan0_.C_Invoice_Candidate_V_ID limit $4

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_4ad_context_info213 GB757167570975708
etendopg_defaultpg_temp_5ad_context_info153 GB633036328763286
etendopg_defaultpg_temp_6ad_context_info152 GB629556295562954
etendopg_defaultpg_temp_9ad_context_info62 GB378923788937888
etendopg_defaultpublicad_org_tree31 GB4040692
etendopg_defaultpg_temp_6ad_context_info11 GB127281272612725
etendopg_defaultpg_temp_7ad_context_info11 GB127041270112700
etendopg_defaultpg_temp_3ad_context_info10 GB127251270812707
etendopg_defaultpg_temp_7ad_context_info10 GB125901259012590
etendopg_defaultpg_catalogpg_class3989 MB59346075765954111873672818731372
etendopg_defaultpublicfact_acct3680 MB145638111
fact_acct(TOAST)
etendopg_defaultprofilelast_stat_database2181 MB1015339292
etendopg_defaultpublicm_productprice1331 MB399791898079189841
m_productprice(TOAST)
etendopg_defaultpublicc_order1227 MB82816621237991427344
c_order(TOAST)
etendopg_defaultpublicc_invoice888 MB3929569413519181829005280
c_invoice(TOAST)
etendopg_defaultpublicc_orderline757 MB1385979138587909182220496
c_orderline(TOAST)
etendopg_defaultpublicm_inout565 MB4830803080
m_inout(TOAST)
etendopg_defaultprofilelast_stat_tablespaces544 MB348014444
last_stat_tablespaces(TOAST)
etendopg_defaultpublicadvcrm_activity467 MB29966961817
advcrm_activity(TOAST)
postgrespg_defaultpg_catalogpg_class374 MB36803238232138107388107129

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpublicm_productprice80881004.122383404512.14
etendopg_defaultpublicm_product83207834.24167059538.51
etendopg_defaultpg_temp_4ad_context_info2390037312.17
etendopg_defaultpg_temp_5ad_context_info166956998.50
etendopg_defaultpg_temp_6ad_context_info165583598.43
etendopg_defaultpublicc_invoice35326601.8076012923.87
etendopg_defaultpublicm_product_trl82292394.19
etendopg_defaultpg_temp_9ad_context_info60662233.09
etendopg_defaultpublicc_orderline22513341.1526345831.34
etendopg_defaultpublicad_org_tree40406922.0620.00
etendopg_defaultpublicfin_payment_schedule8808170.4525605771.30
etendopg_defaultprofilelast_stat_tables32794221.671055170.05
etendopg_defaultpg_catalogpg_class11029260.5612708400.65
etendopg_defaultpublicc_bpartner8944530.4614579050.74
etendopg_defaultpublicc_debt_payment4243440.227137940.36
etendopg_defaultpg_catalogpg_attribute4359690.226390520.33
etendopg_defaultpublicad_textinterfaces3748630.195430580.28
etendopg_defaultprofilelast_stat_indexes5687580.292054470.10
etendopg_defaultpg_temp_3ad_context_info7055070.36
etendopg_defaultpublicc_tax3408490.173640250.19

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpublicfact_acct6729915.004260.0986.69
etendopg_defaultpublicad_image7880.1850.005647012.598860.2031.39
etendopg_defaultpublicc_orderline149323.3320580.4699.65
etendopg_defaultpublicc_invoice58331.3065021.4599.89
etendopg_defaultpublicc_orderlinetax73761.644860.1173.09
etendopg_defaultpublicfin_payment_schedule38010.855060.1199.87
etendopg_defaultpublicfin_payment_scheduledetail27240.616400.1494.94
etendopg_defaultpublicfin_payment31620.701940.0479.71
etendopg_defaultpublicpsat_checklist_result32900.730.66
etendopg_defaultpublicad_process_run25970.58810.0260.00100.0095.49
etendopg_defaultpublicfin_payment_detail19080.432510.0670.39
etendopg_defaultpg_catalogpg_attribute14340.324850.1199.82
etendopg_defaultprofilesample_stat_tables17820.401090.0296.18
etendopg_defaultpg_catalogpg_statistic11760.26670.016270.14150.0099.45
etendopg_defaultpublicprsync_entry9720.2210.007640.17150.0064.24
etendopg_defaultprofilelast_stat_indexes9580.211100.0299.86
etendopg_defaultpublicc_debt_payment9400.211180.0399.91
etendopg_defaultpublicm_inoutline30.009910.2298.75
etendopg_defaultpg_catalogpg_depend7790.171440.0399.43
etendopg_defaultprofilesample_statements7390.161380.0397.46

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
etendopg_defaultpublicc_invoice18290052803917886462956941351918
c_invoice(TOAST)
etendopg_defaultpg_temp_4ad_context_info75709757087571675715
etendopg_defaultpg_temp_5ad_context_info63287632866330363302
etendopg_defaultpg_temp_6ad_context_info62955629546295562954
etendopg_defaultprofilelast_stat_indexes5411913165411918586590434540328383
etendopg_defaultpg_temp_9ad_context_info37889378883789237891
etendopg_defaultprofilelast_stat_tables328783355328785818652890877832880305
etendopg_defaultpg_catalogpg_attribute241932419370940302661631146253
etendopg_defaultpg_temp_6ad_context_info12726127251272812727
etendopg_defaultpg_temp_3ad_context_info12708127071272512724
etendopg_defaultpg_temp_7ad_context_info12701127001270412703
etendopg_defaultpg_temp_7ad_context_info12590125901259012590
etendopg_defaultpg_catalogpg_statistic16109135112166878923972691
pg_statistic(TOAST)228622891240318682
etendopg_defaultprofilelast_stat_user_functions8257847825742389245915
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class1873672818731372593417595819607576595411
etendopg_defaultpg_catalogpg_depend4582458582058154415349889
etendopg_defaultprofilesample_stat_tables33553324256098991523507
etendopg_defaultpg_catalogpg_type215721591230630126445118907
etendopg_defaultprofilesample_statements13631388495091711181388
sample_statements(TOAST)
etendopg_defaultprofilesample_stat_indexes13161287252386061621360

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
etendopg_defaultpublicc_invoice2900528023123
c_invoice(TOAST)
etendopg_defaultpg_temp_4ad_context_info75708
etendopg_defaultpg_temp_5ad_context_info63286
etendopg_defaultpg_temp_6ad_context_info62954
etendopg_defaultprofilelast_stat_indexes131654119274723
etendopg_defaultpg_temp_9ad_context_info37888
etendopg_defaultprofilelast_stat_tables33555832878274723
etendopg_defaultpg_catalogpg_attribute24193111
etendopg_defaultpg_catalogpg_statistic16109135111
pg_statistic(TOAST)22894
etendopg_defaultpg_temp_6ad_context_info12725
etendopg_defaultpg_temp_3ad_context_info12707
etendopg_defaultpg_temp_7ad_context_info12700
etendopg_defaultpg_temp_7ad_context_info12590
etendopg_defaultprofilelast_stat_user_functions847428257274723
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class672813721873111
etendopg_defaultpg_catalogpg_depend458511
etendopg_defaultprofilesample_stat_tables332412
etendopg_defaultpg_catalogpg_type2159111
etendopg_defaultprofilesample_statements138812
sample_statements(TOAST)
etendopg_defaultprofilesample_stat_indexes128712

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
etendopg_defaultpg_temp_4ad_context_info5032 kB5032 kB7570975708
etendopg_defaultpg_temp_5ad_context_info4224 kB4224 kB6328763286
etendopg_defaultpg_temp_9ad_context_info2552 kB2552 kB3788937888
etendopg_defaultpg_temp_6ad_context_info872 kB872 kB1272612725
postgrespg_defaultpg_catalogpg_statistic224 kB32 kB478334
pg_statistic(TOAST)56 kB32 kB1515
etendopg_defaultpublicfin_payment_schedule15 MB48 kB482
fin_payment_schedule(TOAST)
etendopg_defaultprofilesample_statements_total136 kB32 kB4251
sample_statements_total(TOAST)
etendopg_defaultpublicad_ep_instance_para32 kB24 kB305305
ad_ep_instance_para(TOAST)
etendopg_defaultpublicc_invoice23 MB24 kB1829005280
c_invoice(TOAST)
etendopg_defaultprofilesample_stat_user_functions568 kB16 kB847755
etendopg_defaultprofilesample_stat_indexes1432 kB8192 bytes13161287
etendopg_defaultpg_temp_3ad_context_info8192 bytes8192 bytes1514

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
etendopg_defaultpublicm_productpricem_productprice_key79179062383187712.13
etendopg_defaultpublicm_productm_product_key8311339166799208.49
etendopg_defaultpublicm_product_trlm_product_trl_product_langu_un822836382288014.19
etendopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx83580325360561.29
etendopg_defaultpublicc_orderlinec_orderline_order281544424788681.26
etendopg_defaultpublicc_invoicec_invoice_key29405617730990.90
etendopg_defaultpublicc_bpartnerc_bpartner_key72557814520760.74
etendopg_defaultpg_catalogpg_classpg_class_oid_index58102611842680.60
etendopg_defaultpublicc_invoicec_invoice_bpartner2098881520.45
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc8820070.45
etendopg_defaultpublicc_invoicec_invoice_paid6978870.36
etendopg_defaultpublicc_invoicec_invoice_posted14086954780.35
etendopg_defaultpublicc_invoicec_invoice_salesrep6511300.33
etendopg_defaultpublicc_invoicec_invoice_updated5953870.30
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index2654825888110.30
etendopg_defaultpublicc_invoicec_invoice_docno195864820.30
etendopg_defaultpublicad_textinterfacesad_textinterfaces_key2583335223520.27
etendopg_defaultpublicc_debt_paymentc_debt_payment_invoice_idx2516425044890.26
etendopg_defaultpublicc_taxc_tax_key1788373576790.18
etendopg_defaultpublicc_invoicec_invoice_order13227520.16

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
etendopg_defaultpublicpsat_checklist_resultpsat_chcklist_res_result_uk132890.73
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc14350.3299.84
etendopg_defaultpublicc_invoicec_invoice_paid12410.2899.82
etendopg_defaultpublicc_orderlinec_orderline_order28154449970.2299.96
etendopg_defaultpublicc_invoicec_invoice_posted14089270.2199.87
etendopg_defaultpublicc_orderlinec_orderline_key236999080.2098.75
etendopg_defaultpublicad_image(TOAST)pg_toast_74472_index69078860.2095.90
etendopg_defaultpublicm_inoutlinem_inoutline_orderline170808710.1998.30
etendopg_defaultpublicc_invoicec_invoice_docno197280.1699.88
etendopg_defaultpublicc_invoicec_invoice_updated5480.1299.91
etendopg_defaultpublicc_invoicec_invoice_bpartner2095460.1299.94
etendopg_defaultpublicad_session_usage_auditad_session_usage_audit_key4800.1189.21
etendopg_defaultpublicad_audit_trailad_audit_trail_pk4080.0965.01
etendopg_defaultpublicc_invoicec_invoice_key2940563480.0899.98
etendopg_defaultpublicc_invoicec_invoice_salesrep3080.0799.95
etendopg_defaultpublicfin_payment_scheduledetailfin_pay_scheduledetail_in13553080.0792.47
etendopg_defaultpublicfin_payment_schedulefin_paym_sch_inv_idx8358032560.0699.99
etendopg_defaultpublicfin_payment_scheduledetailfin_payment_scheduledetail_key4512460.0581.85
etendopg_defaultpublicfin_payment_detailfin_payment_detail_key4642450.0582.54
etendopg_defaultpublicc_invoicec_invoice_ad_user12360.0599.89

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
etendopg_defaultprofilesample_statementsix_sample_stmts_qid936 kB328 kB10731081
etendopg_defaultpublicad_process_runad_process_run_key448 kB152 kB238238
etendopg_defaultpublicc_invoicec_invoice_ad_user1680 kB96 kB18289972
etendopg_defaultprofilesample_stat_tablespk_sample_stat_tables864 kB96 kB18602329
etendopg_defaultpublicc_invoicec_invoice_order1384 kB72 kB18289972
etendopg_defaultprofilesample_statementspk_sample_statements_n480 kB56 kB778969
etendopg_defaultpublicc_invoicec_invoice_key2784 kB32 kB18289972
etendopg_defaultpublicc_invoicec_invoice_posted2008 kB32 kB18289972
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc4008 kB16 kB18289972
etendopg_defaultpublicc_invoicec_invoice_paid2000 kB16 kB18289972
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index768 kB16 kB2419324193
etendopg_defaultpg_catalogpg_typepg_type_oid_index88 kB8192 bytes21552157

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_doc4008 kB16 kB18289972
etendopg_defaultpublicc_invoicec_invoice_paid2000 kB16 kB18289972
etendopg_defaultpublicc_invoicec_invoice_updated1584 kB18289972
etendopg_defaultpublicc_invoicec_invoice_bp_extref_idx8192 bytes18289972
etendopg_defaultpublicc_invoicec_invoice_salesrep1880 kB-32 kB18289972
postgrespg_defaultpg_catalogpg_classpg_class_tblspc_relfilenode_index16 kB107259107
etendopg_defaultpublicad_process_runad_process_run_ould_be_killed8192 bytes224224

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicad_org_isinnaturaltree9015020228.9955.670.0000.000
etendopublicad_isorgincluded13528842173.48173.480.0000.000
etendoprofiletake_sample2317.330.020.7540.001
etendoprofiletake_sample_subset2317.310.060.7530.002
etendoprofiletake_sample2317.262.260.7500.098
etendopublicad_istriggerenabled116898315.5915.590.0000.000
etendopublicto_char1651844312.4612.460.0000.000
etendoprofilecollect_obj_stats239.272.870.4030.125
etendopublicobequals73425508.678.670.0000.000
etendoprofiledblink6217.847.840.0130.013
etendopublicad_column_identifier77284.023.990.0010.001
etendoprofilesample_dbobj_delta233.583.580.1560.156
etendopublicc_order_post291.690.000.0580.000
etendopublicc_order_post1291.690.000.0580.000
etendopublicc_order_post1291.680.520.0580.018
etendopublicc_invoice_post191.600.450.0840.024
etendopublicad_extension_point_handler691.570.040.0230.001
etendopublicc_invoice_create0121.440.000.1200.000
etendopublicc_invoice_create121.440.200.1200.017
etendopublicprouti_qtyremainingorderline177991.371.370.0000.000

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicto_char1651844312.4612.460.0000.000
etendopublicad_isorgincluded13528842173.48173.480.0000.000
etendopublicad_org_isinnaturaltree9015020228.9955.670.0000.000
etendopublicobequals73425508.678.670.0000.000
etendopublicad_istriggerenabled116898315.5915.590.0000.000
etendopublicto_number6646201.311.310.0000.000
etendopublicround3506580.310.310.0000.000
etendopublicto_char357420.080.080.0000.000
etendopublicto_char325190.050.050.0000.000
etendopublicto_char325180.070.070.0000.000
etendopublicto_date196050.070.070.0000.000
etendopubliclowerequaltimestamp189210.140.080.0000.000
etendopublicprouti_qtyremainingorderline177991.371.370.0000.000
etendopublicsubstract_days127510.010.010.0000.000
etendopublicadd_days114510.010.010.0000.000
etendopublicaprm_ispaymentconfirmed103730.830.830.0000.000
etendopublicuuid_generate_v478930.090.090.0000.000
etendopublicad_column_identifier77284.023.990.0010.001
etendopublicprouti_delavailablewithoutres40080.730.730.0000.000
etendopublicprouti_deliveryavailable40080.710.710.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicc_invoice_trg29007025.4418.300.0000.000
etendopublicc_invoice_trg22900707.894.610.0000.000
etendopubliceinv_gene_chk_restrictions_trg2900525.652.790.0000.000
etendopublicpruti_inherit_invoice_contact2900705.002.830.0000.000
etendopublicc_orderline_trg29330.500.200.0010.000
etendopublicc_invoiceline_trg22820.420.180.0020.001
etendopublicau_c_bpartner_trg230.240.240.0100.010
etendopublicc_orderline2_trg9330.150.130.0000.000
etendopublicc_orderline_trg9330.150.130.0000.000
etendopublicc_orderlinetax_trg1730.140.100.0010.001
etendopublicc_invoicelinetax_trg1290.140.070.0010.001
etendopublicc_ordline_chk_restrictions_trg9330.120.110.0000.000
etendopubliccus_delete_ol200.110.110.0060.005
etendopublicau_advcrm_activity_trg240.100.090.0040.004
etendopublicad_preference_mod_trg2700.080.080.0000.000
etendopublicc_invoiceline_before_trg2800.070.070.0000.000
etendopublicc_invline_chk_restrictions_trg2800.050.050.0000.000
etendopublicad_process_request_trg2460.050.030.0000.000
etendopublicc_order_chk_restrinctions_trg4220.040.040.0000.000
etendopublicc_ordertax_trg1690.040.040.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables273287833553287858
etendopg_defaultprofilelast_stat_indexes2754119131654119
etendopg_defaultprofilelast_stat_user_functions278257847825742
etendopg_defaultpublicc_invoice231829005280
etendopg_defaultpublicad_ep_instance_para5305305
postgrespg_defaultpg_catalogpg_type1157157
postgrespg_defaultpg_catalogpg_attribute112151215
postgrespg_defaultpg_catalogpg_class1107388107129
postgrespg_defaultpg_catalogpg_statistic1478334
etendopg_defaultpg_catalogpg_type121572159
etendopg_defaultpg_catalogpg_attribute12419324193
etendopg_defaultpg_catalogpg_class11873672818731372
etendopg_defaultpg_catalogpg_index1527527
etendopg_defaultpg_catalogpg_statistic11610913511
etendopg_defaultprofilelast_stat_database19292

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables47233287833553287858
etendopg_defaultprofilelast_stat_indexes472354119131654119
etendopg_defaultprofilelast_stat_user_functions47238257847825742
etendopg_defaultpublicc_invoice1231829005280
etendopg_defaultprofilelast_stat_tablespaces224444
etendopg_defaultpublicad_ep_instance_para10305305
etendopg_defaultpublicad_process_request16312307
etendopg_defaultprofilelast_stat_database139292
postgrespg_globalpg_catalogpg_pltemplate3
postgrespg_globalpg_catalogpg_tablespace3
postgrespg_globalpg_catalogpg_shdepend3709710
postgrespg_globalpg_catalogpg_authid3
postgrespg_globalpg_catalogpg_auth_members3
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

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
etendopg_defaultpublicc_invoicec_invoice_client_org_date_doc90 MB234003 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_key62 MB232761 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_bpartner57 MB232522 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_docno48 MB232144 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_posted44 MB231949 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_paid44 MB231948 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_salesrep42 MB231849 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_ad_user36 MB231603 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_updated35 MB231567 kB23 MB
etendopg_defaultpublicc_invoicec_invoice_order30 MB231328 kB23 MB
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes10 MB27392 kB1530 kB
etendopg_defaultprofilelast_stat_tablespk_last_stat_tables5664 kB27209 kB1216 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index1168 kB11168 kB4304 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index768 kB1768 kB4304 kB
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index376 kB1376 kB4776 kB
etendopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index368 kB493 kB4400 kB
etendopg_defaultpg_catalogpg_classpg_class_relname_nsp_index184 kB1184 kB688 kB
etendopg_defaultpublicc_invoicec_invoice_bp_extref_idx184 kB238192 bytes23 MB
etendopg_defaultpg_catalogpg_typepg_type_typname_nsp_index152 kB1152 kB496 kB
postgrespg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index120 kB1120 kB408 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_tables245332904107072 kB
etendopublicad_process_run5125291510136 kB
etendopublicfin_payment_schedule606752015 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
etendoprofilesample_stat_tables24533290490632026-07-19 23:00:03.573965+027072 kB
etendopublicad_process_run51252914802026-07-20 01:09:05.665094+0210136 kB
etendopublicfin_payment_schedule6067525002025-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-18 05:00:04.324135+02
pg_conf_load_time2026-07-19 05:00:03.850135+022026-07-19 06:00:02+02
pg_postmaster_start_time2026-07-18 05:00:04.449179+02
pg_postmaster_start_time2026-07-19 05:00:03.976791+022026-07-19 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