Postgres profile report (StartID: 433, EndID: 456)

pg_profile version 0.3.6

Server name: local

Report interval: 2026-07-17 04:00:01+02 - 2026-07-18 03:00:02+02

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

Report sections

Server statistics

Database statistics

DatabaseTransactionsBlock statisticsTuplesTemp filesSizeGrowth
CommitsRollbacksDeadlocksHit(%)ReadHitRetFetInsUpdDelSizeFiles
etendo62274296.119875072438137485485674293908891380707252551327793124 MB-1736 kB
postgres1186799.8113137027751985089365312201286617726415 kB
Total74141296.219888202508414987470763297562011382719261211345513131 MB-1736 kB

Statement statistics by database

DatabaseCallsTime (s)Fetched (blk)Dirtied (blk)Temp (blk)Local (blk)Statements
ExecReadWriteTrgSharedLocalSharedLocalReadWriteReadWrite
etendo313527391.591.31326975473720977773
postgres561910.57127428231349
template163508.1747909239278
Total325496410.331.31328728843725678400

Cluster statistics

MetricValue
Scheduled checkpoints275
Requested checkpoints1
Checkpoint write time (s)2261.73
Checkpoint sync time (s)0.59
Checkpoints buffers written159545
Background buffers written3351
Backend buffers written514464
Backend fsync count
Bgwriter interrupts (too many buffers)6
Number of buffers allocated989080
WAL generated3346 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

TablespacePathSizeGrowth
pg_default3144 MB-1736 kB
pg_global542 kB

SQL query statistics

Top SQL by execution time

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

95572914af

[cd9c0fd2]

etendo190.5746.44903190565.841190565.841190565.8411

9fab4770a7

[948be82f]

etendo82.5120.1182511.72982511.72982511.7291

e72111fc0b

[165cfe9e]

etendo24.075.86231046.308899.1731399.041116.06523

8b95a6d8be

[5bf034e8]

etendo24.065.861046.104898.9931398.841116.05823

ab75f0d002

[ea3ffc6b]

etendo9.302.2710115223.3462.72913.0370.6152779

780c1676b8

[58bd0761]

etendo7.821.9127672.8261.24111.0450.7322767

5205357fc7

[9829805d]

etendo5.431.3254326118.07920.805512.704100.58146

7bbf8dc24b

[ec3901fa]

etendo5.211.2731671113.25224.033258.35286.59546

a5e40a232d

[6d193752]

etendo3.490.8529647151.547128.019196.05615.57123

579c04f6a4

[22217272]

etendo3.480.8551244151.379114.145455.31066.10323

63598c4dc1

[32078409]

etendo2.960.72492.507256.129661.595135.1936

8ce5c7c2fd

[a8855ea7]

template12.830.6927610.26710.17310.5540.067276

94981812f5

[d6e97f55]

postgres2.810.6855210.1650.11520.1911.494276

09dd3ceb9c

[ac17e023]

postgres2.770.6727610.0270.10910.5291.600276

6e1c6d0949

[dccac99b]

template12.710.6626410.2540.10212.7900.652264

53f041022a

[1c089a92]

etendo2.240.55282297.46468.150132.84517.69323

0c247acdf0

[948be82f]

template12.120.522123.5532123.5532123.5531

2e0b729b87

[948be82f]

postgres2.100.512103.5382103.5382103.5381

7dfdbbb662

[ec61c564]

postgres2.030.5010567.6987.01116.5590.999264

236f42a0f2

[92e68786]

etendo1.570.3813211.9181.65813.5220.943132

Top SQL by executions

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

09a13047d0

[e0488e43]

etendo9771830.02977180.0040.0022.9510.0100.4

47521f7ce5

[4ef2b412]

etendo3570010.97357000.0040.0020.3040.0040.1

b5ae6f04c1

[bb90fd8a]

etendo3538210.87353820.0140.0080.3330.0070.5

fe26995756

[a0abb6c3]

etendo88322.7188320.0120.0080.0620.0030.1

0773a44802

[141ca58a]

etendo63851.9663850.0040.0020.0450.0030.0

c33f21cc29

[a38abef0]

etendo57881.7857880.0040.0020.6810.0090.0

4fcdb10468

[6f9b1a85]

etendo57881.780.0020.0000.0880.0020.0

ae36bf3fd6

[2049516b]

etendo57861.780.0010.0000.0560.0010.0

23c054b2cf

[cdfab523]

etendo44161.36220800.0170.0110.0800.0040.1

52730573e2

[708934a0]

etendo44161.3644160.0080.0060.0370.0020.0

e30a458893

[f8bb1c8e]

etendo44161.3644160.0070.0040.0280.0020.0

74c239e6b0

[31bc0d20]

etendo40631.2540600.0070.0020.8740.0160.0

790e624f67

[43179118]

etendo34201.0534200.0140.0090.0920.0030.0

0395cd7d8f

[90d234b8]

template130360.930.0110.0090.0490.0020.0

6c3324a757

[30e34f7a]

etendo30350.930.0040.0030.0390.0010.0

ab75f0d002

[ea3ffc6b]

etendo27790.8510115223.3462.72913.0370.6159.3

780c1676b8

[58bd0761]

etendo27670.8527672.8261.24111.0450.7327.8

3244975284

[1c67a9f6]

etendo20790.6420790.0180.0130.0960.0030.0

18dfa40a69

[13286d05]

etendo18120.5618120.0030.0010.0330.0010.0

81fe7b492c

[77376af6]

etendo18030.550.0220.0121.2500.0290.0

Top SQL by shared blocks fetched

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

9fab4770a7

[948be82f]

etendo660047820.0888.7682.51

ab75f0d002

[ea3ffc6b]

etendo504096115.33100.009.310115222779

e72111fc0b

[165cfe9e]

etendo492745314.9999.9924.12323

8b95a6d8be

[5bf034e8]

etendo492731514.9999.9924.123

53f041022a

[1c089a92]

etendo26205937.97100.002.2282223

579c04f6a4

[22217272]

etendo16298954.96100.003.55124423

a5e40a232d

[6d193752]

etendo7962632.42100.003.52964723

780c1676b8

[58bd0761]

etendo3459511.0599.967.827672767

5205357fc7

[9829805d]

etendo3394101.0399.995.45432646

95572914af

[cd9c0fd2]

etendo3191080.9733.00190.69031

efb10843fa

[3c3a10c1]

etendo3178260.97100.000.426823

7bbf8dc24b

[ec3901fa]

etendo2952300.90100.005.23167146

63598c4dc1

[32078409]

etendo2725100.8399.813.06

823682fddf

[505cb7c7]

etendo2478590.7599.990.95210

82e3327dfb

[11efae27]

etendo2385150.7399.991.06262

078231c619

[fb4a8a01]

etendo2335800.7199.981.06060

fb78e2110c

[3f26be12]

etendo2140540.6599.990.95555

b5ae6f04c1

[bb90fd8a]

etendo2067640.6399.990.53538235382

09a13047d0

[e0488e43]

etendo1954360.59100.000.49771897718

ffbe6ea696

[6ff0b59f]

etendo1503550.4699.820.73535

Top SQL by shared blocks read

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

9fab4770a7

[948be82f]

etendo74211075.0388.7682.51

95572914af

[cd9c0fd2]

etendo21379421.6233.00190.69031

819231741d

[ee6bcd7b]

etendo89520.910.110.81162981

8653e9fcc7

[63a051b4]

etendo42440.430.210.41252221

cb65787e2e

[34618be5]

etendo32740.330.330.4868101

5d2713997e

[9874a2f8]

etendo12140.120.1369301

2e0b729b87

[948be82f]

postgres10550.1197.402.11

0c247acdf0

[948be82f]

template110530.1197.412.11

dd164d7c5b

[51d43ddf]

etendo8380.080.590.0256421

fb03d4bd20

[14a0b57d]

etendo7060.070.140.0245231

421633828b

[5015950f]

etendo7050.070.140.0245151

e4e07d6aaa

[c7b7b73b]

etendo6070.060.1149501

65c1fa73a0

[b144b45b]

etendo5870.068.850.062231

fbc203961c

[8d9c7ac8]

etendo5520.060.0153631

63598c4dc1

[32078409]

etendo5190.0599.813.06

e72111fc0b

[165cfe9e]

etendo4590.0599.9924.12323

8b95a6d8be

[5bf034e8]

etendo4590.0599.9924.123

bbb18aaa85

[15e80a0c]

etendo4450.0474.500.1169477

6fb557c71c

[d72dce4a]

etendo3640.040.0127181

7b763ebacb

[1ffd803f]

etendo3280.0398.540.0341

Top SQL by shared blocks dirtied

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

9fab4770a7

[948be82f]

etendo31912385.6688.7682.51

e72111fc0b

[165cfe9e]

etendo155654.1899.9924.12323

8b95a6d8be

[5bf034e8]

etendo155654.1899.9924.123

5205357fc7

[9829805d]

etendo41131.1099.995.45432646

7bbf8dc24b

[ec3901fa]

etendo31790.85100.005.23167146

860971ea70

[a2b1d8b5]

etendo17830.4899.681.02323

bbb5ea7d4a

[dbbb08c5]

etendo16030.4399.350.1281281

bfac77ea29

[d422fd3a]

etendo10920.2999.921.046

ab52f02a40

[7de5e657]

etendo6200.17100.000.04960221

627abb38ab

[b8b908b]

etendo6000.1699.880.3402923

3cf9d838f3

[7e502be6]

etendo4950.1399.920.846

fae50d9c18

[b746d230]

etendo3910.1099.970.22216

5695e7218b

[2c3218e3]

etendo3780.10100.000.5541244

74c239e6b0

[31bc0d20]

etendo3710.10100.000.040604063

53f041022a

[1c089a92]

etendo2980.08100.002.2282223

ea88e6845b

[b6b4a757]

etendo2510.07100.000.0571571

def99b80b7

[7cf22f68]

etendo2470.0799.970.3134621

218b1cd7d6

[fe32196]

etendo2420.06100.000.1256256

a98f2159e7

[85ebc5b1]

etendo2420.0699.850.140

0c247acdf0

[948be82f]

template12390.0697.412.11

Top SQL by shared blocks written

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

9fab4770a7

[948be82f]

etendo17563425.9334.1488.7682.51

0c247acdf0

[948be82f]

template1550.010.0197.412.11

2e0b729b87

[948be82f]

postgres550.010.0197.402.11

Top SQL by temp usage

No data in this section

Complete list of SQL texts

QueryIDQuery Text
627abb38abINSERT INTO sample_stat_tables ( server_id, sample_id, datid, relid, tablespaceid, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, n_mod_since_analyze, n_ins_since_vacuum, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit, relsize, relsize_diff, relpages_bytes, relpages_bytes_diff ) SELECT cur.server_id AS server_id, cur.sample_id AS sample_id, cur.datid AS datid, cur.relid AS relid, cur.tablespaceid AS tablespaceid, cur.seq_scan - COALESCE(lst.seq_scan,$4) AS seq_scan, cur.seq_tup_read - COALESCE(lst.seq_tup_read,$5) AS seq_tup_read, cur.idx_scan - COALESCE(lst.idx_scan,$6) AS idx_scan, cur.idx_tup_fetch - COALESCE(lst.idx_tup_fetch,$7) AS idx_tup_fetch, cur.n_tup_ins - COALESCE(lst.n_tup_ins,$8) AS n_tup_ins, cur.n_tup_upd - COALESCE(lst.n_tup_upd,$9) AS n_tup_upd, cur.n_tup_del - COALESCE(lst.n_tup_del,$10) AS n_tup_del, cur.n_tup_hot_upd - COALESCE(lst.n_tup_hot_upd,$11) AS n_tup_hot_upd, cur.n_live_tup AS n_live_tup, cur.n_dead_tup AS n_dead_tup, cur.n_mod_since_analyze AS n_mod_since_analyze, cur.n_ins_since_vacuum AS n_ins_since_vacuum, cur.last_vacuum AS last_vacuum, cur.last_autovacuum AS last_autovacuum, cur.last_analyze AS last_analyze, cur.last_autoanalyze AS last_autoanalyze, cur.vacuum_count - COALESCE(lst.vacuum_count,$12) AS vacuum_count, cur.autovacuum_count - COALESCE(lst.autovacuum_count,$13) AS autovacuum_count, cur.analyze_count - COALESCE(lst.analyze_count,$14) AS analyze_count, cur.autoanalyze_count - COALESCE(lst.autoanalyze_count,$15) AS autoanalyze_count, cur.heap_blks_read - COALESCE(lst.heap_blks_read,$16) AS heap_blks_read, cur.heap_blks_hit - COALESCE(lst.heap_blks_hit,$17) AS heap_blks_hit, cur.idx_blks_read - COALESCE(lst.idx_blks_read,$18) AS idx_blks_read, cur.idx_blks_hit - COALESCE(lst.idx_blks_hit,$19) AS idx_blks_hit, cur.toast_blks_read - COALESCE(lst.toast_blks_read,$20) AS toast_blks_read, cur.toast_blks_hit - COALESCE(lst.toast_blks_hit,$21) AS toast_blks_hit, cur.tidx_blks_read - COALESCE(lst.tidx_blks_read,$22) AS tidx_blks_read, cur.tidx_blks_hit - COALESCE(lst.tidx_blks_hit,$23) AS tidx_blks_hit, cur.relsize AS relsize, cur.relsize - COALESCE(lst.relsize,$24) AS relsize_diff, cur.relpages_bytes AS relpages_bytes, cur.relpages_bytes - COALESCE(lst.relpages_bytes,$25) AS relpages_bytes_diff FROM last_stat_tables cur JOIN last_stat_database dbcur USING (server_id, sample_id, datid) LEFT JOIN last_stat_database dblst ON (dblst.server_id, dblst.sample_id, dblst.datid, dblst.stats_reset) = (dbcur.server_id, dbcur.sample_id - $26, dbcur.datid, dbcur.stats_reset) LEFT OUTER JOIN last_stat_tables lst ON (lst.server_id, lst.sample_id, lst.datid, lst.relid) = (dblst.server_id, dblst.sample_id, dblst.datid, cur.relid) WHERE (cur.server_id, cur.sample_id, cur.in_sample) = (sserver_id, s_id, $27)
218b1cd7d6UPDATE AD_Process_Request SET Updatedby = $1, AD_User_ID = $2, Status = $3, Channel = $4, Previous_Fire_Time = TO_TIMESTAMP($5, $6), Next_Fire_Time = TO_TIMESTAMP($7, $8), Scheduled_Finish = TO_TIMESTAMP($9, $10), Ob_Context = $11, Updated = NOW() WHERE AD_Process_Request_ID = $12
82e3327dfbSELECT coalesce(sum(mpl.movementqty * coalesce(m_get_cost(mpl.m_product_id, TO_DATE(p_date), $3, $4, $5, $6, $7, $8),$9)),$10) FROM M_ProductionLine mpl LEFT JOIN M_Productionplan mpp on mpp.m_productionplan_id = mpl.m_productionplan_id LEFT JOIN ma_wrphase mwrph on mwrph.ma_wrphase_id = mpp.ma_wrphase_id where mwrph.ma_workrequirement_id = p_workrequirement_id
18dfa40a69SELECT $1 FROM DUAL
0773a44802SELECT $4 FROM ONLY "profile"."sample_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
fb03d4bd20COPY public.m_production (m_production_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, description, movementdate, iscreated, posted, processed, processing, ad_orgtrx_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, documentno, endtime, issotrx, starttime, validating, c_costcenter_id, a_asset_id) TO stdout
bbb18aaa85select column0_.ad_column_id as ad_colum1_0_, column0_.isactive as isactive2_0_, column0_.name as name3_0_, column0_.columnName as columnNa4_0_, column0_.fieldLength as fieldLen5_0_, column0_.defaultValue as defaultV6_0_, column0_.issessionattr as issessio7_0_, column0_.iskey as iskey8_0_, column0_.issecondarykey as issecond9_0_, column0_.isparent as isparen10_0_, column0_.isupdateable as isupdat11_0_, column0_.isidentifier as isident12_0_, column0_.ismandatory as ismanda13_0_, column0_.isencrypted as isencry14_0_, column0_.isdesencryptable as isdesen15_0_, column0_.istranslated as istrans16_0_, column0_.valueMin as valueMi17_0_, column0_.valueMax as valueMa18_0_, column0_.position as positio19_0_, column0_.seqno as seqno20_0_, column0_.sqlLogic as sqlLogi21_0_, column0_.isusedsequence as isuseds22_0_, column0_.ad_table_id as ad_tabl23_0_, column0_.ad_reference_id as ad_refe24_0_, column0_.ad_reference_value_id as ad_refe25_0_, column0_.istransient as istrans26_0_, column0_.istransientcondition as istrans27_0_, column0_.allowed_cross_org_link as allowed28_0_, column0_.is_child_property_in_parent as is_chil29_0_, column0_.ad_module_id as ad_modu30_0_, column0_.updated as updated31_0_ from ad_column column0_ where column0_.ad_table_id=$1 order by column0_.position asc
e72111fc0bSELECT profile.take_sample()
53f041022aUPDATE 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)
3244975284select adclient0_.AD_Client_ID as AD_Clien1_18_0_, adclient0_.AD_Org_ID as AD_Org_I2_18_0_, adclient0_.IsActive as IsActive3_18_0_, adclient0_.Created as Created4_18_0_, adclient0_.CreatedBy as CreatedB5_18_0_, adclient0_.Updated as Updated6_18_0_, adclient0_.UpdatedBy as UpdatedB7_18_0_, adclient0_.Value as Value8_18_0_, adclient0_.Name as Name9_18_0_, adclient0_.Description as Descrip10_18_0_, adclient0_.SMTPHost as SMTPHos11_18_0_, adclient0_.RequestEMail as Request12_18_0_, adclient0_.RequestUser as Request13_18_0_, adclient0_.RequestUserPW as Request14_18_0_, adclient0_.RequestFolder as Request15_18_0_, adclient0_.AD_Language as AD_Lang16_18_0_, adclient0_.IsMultiLingualDocument as IsMulti17_18_0_, adclient0_.IsSmtpAuthorization as IsSmtpA18_18_0_, adclient0_.C_Currency_ID as C_Curre19_18_0_, adclient0_.Acctdim_Centrally_Maintained as Acctdim20_18_0_, adclient0_.Project_Acctdim_Isenable as Project21_18_0_, adclient0_.Project_Acctdim_Header as Project22_18_0_, adclient0_.Project_Acctdim_Lines as Project23_18_0_, adclient0_.Project_Acctdim_Breakdown as Project24_18_0_, adclient0_.Bpartner_Acctdim_Isenable as Bpartne25_18_0_, adclient0_.Bpartner_Acctdim_Header as Bpartne26_18_0_, adclient0_.Bpartner_Acctdim_Lines as Bpartne27_18_0_, adclient0_.Bpartner_Acctdim_Breakdown as Bpartne28_18_0_, adclient0_.Product_Acctdim_Isenable as Product29_18_0_, adclient0_.Product_Acctdim_Header as Product30_18_0_, adclient0_.Product_Acctdim_Lines as Product31_18_0_, adclient0_.Product_Acctdim_Breakdown as Product32_18_0_, adclient0_.Costcenter_Acctdim_Header as Costcen33_18_0_, adclient0_.Costcenter_Acctdim_Lines as Costcen34_18_0_, adclient0_.Costcenter_Acctdim_Breakdown as Costcen35_18_0_, adclient0_.User1_Acctdim_Isenable as User36_18_0_, adclient0_.User1_Acctdim_Header as User37_18_0_, adclient0_.User1_Acctdim_Lines as User38_18_0_, adclient0_.User1_Acctdim_Breakdown as User39_18_0_, adclient0_.User2_Acctdim_Isenable as User40_18_0_, adclient0_.User2_Acctdim_Header as User41_18_0_, adclient0_.User2_Acctdim_Lines as User42_18_0_, adclient0_.User2_Acctdim_Breakdown as User43_18_0_, adclient0_.Costcenter_Acctdim_Isenable as Costcen44_18_0_, adclient0_.Org_Acctdim_Isenable as Org_Acc45_18_0_, adclient0_.Org_Acctdim_Header as Org_Acc46_18_0_, adclient0_.Org_Acctdim_Lines as Org_Acc47_18_0_, adclient0_.Org_Acctdim_Breakdown as Org_Acc48_18_0_, adclient0_.EM_Man_Processplan_ID as EM_Man_49_18_0_, adclient0_.DaysToPasswordExpiration as DaysToP50_18_0_, adclient0_.EM_Man_Locator_ID as EM_Man_51_18_0_, adclient0_.EM_Man_Pricelist_ID as EM_Man_52_18_0_, adclient0_.EM_Man_Doctype_ID as EM_Man_53_18_0_, adclient0_.EM_Man_Mails as EM_Man_54_18_0_ from AD_Client adclient0_ where adclient0_.AD_Client_ID=$1
7b763ebacbselect manufactur0_.MA_Workrequirement_ID as MA_Workr1_572_, manufactur0_.AD_Client_ID as AD_Clien2_572_, manufactur0_.AD_Org_ID as AD_Org_I3_572_, manufactur0_.IsActive as IsActive4_572_, manufactur0_.Created as Created5_572_, manufactur0_.Createdby as Createdb6_572_, manufactur0_.Updated as Updated7_572_, manufactur0_.Updatedby as Updatedb8_572_, manufactur0_.Name as Name9_572_, manufactur0_.MA_Processplan_ID as MA_Proc10_572_, manufactur0_.Quantity as Quantit11_572_, manufactur0_.Launchdate as Launchd12_572_, manufactur0_.StartDate as StartDa13_572_, manufactur0_.EndDate as EndDate14_572_, manufactur0_.Closed as Closed15_572_, manufactur0_.Explote as Explote16_572_, manufactur0_.Processed as Process17_572_, manufactur0_.DocumentNo as Documen18_572_, manufactur0_.Explodephases as Explode19_572_, manufactur0_.Secondaryqty as Seconda20_572_, manufactur0_.Secondaryunit as Seconda21_572_, manufactur0_.Conversionrate as Convers22_572_, manufactur0_.Estimatedtime as Estimat23_572_, manufactur0_.Runtime as Runtime24_572_, manufactur0_.C_Doctype_ID as C_Docty25_572_, manufactur0_.Createworkrequirement as Createw26_572_, manufactur0_.em_man_product_id as em_man_27_572_, manufactur0_.em_man_attributevalue_id as em_man_28_572_, manufactur0_.em_man_product_modif_id as em_man_29_572_, manufactur0_.EM_Man_Checked as EM_Man_30_572_, manufactur0_.EM_Man_Btn_Check as EM_Man_31_572_, manufactur0_.EM_Man_Description as EM_Man_32_572_, manufactur0_.EM_Man_C_Order_ID as EM_Man_33_572_, manufactur0_.EM_Man_Add_Orderline as EM_Man_34_572_, manufactur0_.em_man_benefit as em_man_35_572_, manufactur0_.em_man_cost_totalvoz as em_man_36_572_, manufactur0_.em_man_costtotal_vozorder as em_man_37_572_, manufactur0_.em_man_cost_workforcetotal as em_man_38_572_, manufactur0_.em_man_mat_cost_total as em_man_39_572_ from MA_WorkRequirement manufactur0_ where (manufactur0_.AD_Org_ID in ($4 , $5 , $6)) and (manufactur0_.MA_Workrequirement_ID not in (select manufactur1_.MA_Workrequirement_ID from MA_WorkRequirement manufactur1_ where manufactur1_.Closed=$7)) and (manufactur0_.MA_Workrequirement_ID not in (select materialmg2_.EM_Man_M_Workrequeriment_ID from M_InOutLine materialmg2_ cross join M_InOut materialmg3_ where materialmg2_.M_InOut_ID=materialmg3_.M_InOut_ID and (materialmg2_.EM_Man_M_Workrequeriment_ID is not null) and materialmg3_.DocStatus<>$8 and materialmg3_.IsSOTrx=$9)) and (manufactur0_.AD_Client_ID in ($1 , $2)) and manufactur0_.IsActive=$10 order by manufactur0_.MA_Workrequirement_ID desc limit $3
ae36bf3fd6COMMIT
579c04f6a4SELECT 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)
5695e7218bINSERT INTO last_stat_user_functions( server_id, sample_id, datid, funcid, schemaname, funcname, funcargs, calls, total_time, self_time, trg_fn ) SELECT sserver_id, s_id, qres.datid, funcid, schemaname, funcname, funcargs, dbl.calls AS calls, dbl.total_time AS total_time, dbl.self_time AS self_time, dbl.trg_fn FROM dblink($18, t_query) AS dbl ( funcid oid, schemaname name, funcname name, funcargs text, calls bigint, total_time double precision, self_time double precision, trg_fn boolean )
6c3324a757select 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) and this_.AD_Client_ID in ($5, $6) and this_.Isactive=$7
74c239e6b0SELECT $4 FROM ONLY "profile"."tables_list" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "datid" OPERATOR(pg_catalog.=) $2 AND "relid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
63598c4dc1select workrequir0_.MA_Workrequirement_ID as MA_Workr1_572_0_, workrequir0_.AD_Client_ID as AD_Clien2_572_0_, workrequir0_.AD_Org_ID as AD_Org_I3_572_0_, (select workrequir0_.closed from dual) as formula23_0_, (select mi.movementdate from m_inoutline minl LEFT JOIN m_inout mi on minl.m_inout_id = mi.m_inout_id where mi.issotrx = $51 and minl.em_man_repairnumber = workrequir0_.documentno and minl.m_product_id = workrequir0_.em_man_product_id) as formula24_0_, (select mi.documentno from m_inoutline minl LEFT JOIN m_inout mi on minl.m_inout_id = mi.m_inout_id where mi.issotrx = $52 and minl.em_man_repairnumber = workrequir0_.documentno and minl.m_product_id = workrequir0_.em_man_product_id) as formula25_0_, (select mi.documentno from m_inout mi left join m_inoutline on mi.m_inout_id=m_inoutline.m_inout_id where m_inoutline.EM_Man_M_Workrequeriment_ID = workrequir0_.ma_workrequirement_id and mi.issotrx = $53 and mi.docstatus != $54) as formula26_0_, (select mi.dateacct from m_inout mi left join m_inoutline on mi.m_inout_id=m_inoutline.m_inout_id where m_inoutline.EM_Man_M_Workrequeriment_ID = workrequir0_.ma_workrequirement_id and mi.issotrx = $55 and mi.docstatus != $56) as formula27_0_ from MA_WorkRequirement workrequir0_ where workrequir0_.MA_Workrequirement_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)
cb65787e2eCOPY public.ma_wrphase (ma_wrphase_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, ma_workrequirement_id, ma_process_id, quantity, donequantity, costcenteruse, preptime, closed, seqno, noqty, groupuse, ma_sequence_id, name, description, outsourced, startdate, enddate, estimatedtime, runtime, usedmaterial, em_man_modification_id, em_man_control_quality) TO stdout
efb10843faUPDATE 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, cur.relsize IS NOT NULL AS relsize_avail, cur.relpages_bytes IS NOT NULL AS relpages_avail, row_number() OVER (ORDER BY cur.relsize - COALESCE(lst.relsize, $6) + COALESCE(tcur.relsize,$7) - COALESCE(tlst.relsize, $8) DESC NULLS LAST) growth_rank, row_number() OVER (ORDER BY cur.relpages_bytes - COALESCE(lst.relpages_bytes, $9) + COALESCE(tcur.relpages_bytes,$10) - COALESCE(tlst.relpages_bytes, $11) DESC NULLS LAST) pagegrowth_rank FROM -- main relations diff last_stat_tables cur LEFT OUTER JOIN last_stat_tables lst ON (lst.server_id, lst.sample_id, lst.datid, lst.relid) = (cur.server_id, cur.sample_id - $12, cur.datid, cur.relid) -- toast relations diff LEFT OUTER JOIN last_stat_tables tcur ON (tcur.server_id, tcur.sample_id, tcur.datid, tcur.relid) = (cur.server_id, cur.sample_id, cur.datid, cur.reltoastrelid) LEFT OUTER JOIN last_stat_tables tlst ON (tlst.server_id, tlst.sample_id, tlst.datid, tlst.relid) = (lst.server_id, lst.sample_id, lst.datid, lst.reltoastrelid) WHERE cur.sample_id=s_id AND cur.server_id=sserver_id AND cur.relkind IN ($13,$14)) diff WHERE ((relsize_avail AND growth_rank <= topn) OR ((NOT relsize_avail) AND relpages_avail AND pagegrowth_rank <= topn)) AND (ulst.server_id, ulst.sample_id, ulst.datid, in_sample) = (diff.server_id, diff.sample_id, diff.datid, $15) AND (ulst.relid = diff.relid OR ulst.relid = diff.toastrelid)
fb78e2110cselect man_get_benefit_wk(new.em_man_ma_workrequirement_id)
790e624f67select adlanguage0_.AD_Language_ID as AD_Langu1_52_0_, adlanguage0_.AD_Language as AD_Langu2_52_0_, adlanguage0_.AD_Client_ID as AD_Clien3_52_0_, adlanguage0_.AD_Org_ID as AD_Org_I4_52_0_, adlanguage0_.IsActive as IsActive5_52_0_, adlanguage0_.Created as Created6_52_0_, adlanguage0_.CreatedBy as CreatedB7_52_0_, adlanguage0_.Updated as Updated8_52_0_, adlanguage0_.UpdatedBy as UpdatedB9_52_0_, adlanguage0_.Name as Name10_52_0_, adlanguage0_.LanguageISO as Languag11_52_0_, adlanguage0_.CountryCode as Country12_52_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_52_0_, adlanguage0_.IsSystemLanguage as IsSyste14_52_0_, adlanguage0_.Processing as Process15_52_0_, adlanguage0_.Pixelsize as Pixelsi16_52_0_, adlanguage0_.Translatedby as Transla17_52_0_, adlanguage0_.Isrtl as Isrtl18_52_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=$1
47521f7ce5SELECT $4 FROM ONLY "profile"."last_stat_tablespaces" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "sample_id" OPERATOR(pg_catalog.=) $2 AND "tablespaceid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
421633828bCOPY public.ma_weemployee (ma_weemployee_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, m_production_id, c_bpartner_id) TO stdout
823682fddfSELECT distinct ma_workrequirement.ma_workrequirement_id, m_product.m_product_id AS lisonId, m_product.value AS lison, m_product.NAME AS lisonName, m_product_category.NAME AS categoryname, m_attributevalue.value AS lisonNo, COALESCE(modWk.documentno, $1) AS nameMod, ma_process.NAME AS procName, ma_process.ma_process_id AS procId, ma_wrphase.ma_wrphase_id AS procWrPhaseId, COALESCE(modWk.man_product_modifications_id, $2) AS idMod, COALESCE( (SELECT String_agg(ad_user.NAME, $3) FROM m_productionplan LEFT JOIN ad_user ON m_productionplan.createdby = ad_user.ad_user_id WHERE m_productionplan.ma_wrphase_id = ma_wrphase.ma_wrphase_id), $4) AS users, COALESCE(modProc.documentno, $5) AS nameModProc, COALESCE(modProc.man_product_modifications_id, $6) AS idModProc, ma_wrphase.em_man_control_quality AS controlQuality, string_agg(COALESCE(M_ProductionPlan.M_ProductionPlan_ID, $7),$8) AS idProductionPlan, COALESCE(M_ProductionPlan.rejectedquantity, $9) AS qtyRealizada, ma_process.em_man_invoice_method as invoicemethod, coalesce(ma_process.em_man_qtyprocess,$10) as qtyprocess, coalesce(ma_workrequirement.em_man_description,$11) as description, CASE WHEN man_modification_processes.description = $12 then $13 ELSE COALESCE(man_modification_processes.description, $14) end AS descriptionModWk, CASE WHEN (select count(*) from man_wr_times where man_wr_times.ma_workrequirement_id = ma_workrequirement.ma_workrequirement_id and time_end is not null) > $15 then $16 ELSE $17 end AS haveTimeWk FROM ma_workrequirement LEFT JOIN m_product ON m_product.m_product_id = ma_workrequirement.em_man_product_id LEFT JOIN m_product_category ON m_product.m_product_category_id = m_product_category.m_product_category_id LEFT JOIN m_attributevalue ON m_attributevalue.m_attributevalue_id = ma_workrequirement.em_man_attributevalue_id LEFT JOIN man_product_modifications modWk ON modWk.man_product_modifications_id = ma_workrequirement.em_man_product_modif_id LEFT JOIN ma_wrphase ON ma_workrequirement.ma_workrequirement_id = ma_wrphase.ma_workrequirement_id LEFT JOIN M_ProductionPlan ON M_ProductionPlan.ma_wrphase_id = ma_wrphase.ma_wrphase_id LEFT JOIN ma_process ON ma_process.ma_process_id = ma_wrphase.ma_process_id LEFT JOIN man_product_modifications modProc ON ma_wrphase.em_man_modification_id = modProc.man_product_modifications_id left join man_modification_processes ON man_modification_processes.ma_process_id = ma_process.ma_process_id and man_modification_processes.man_product_modifications_id = modProc.man_product_modifications_id where ma_workrequirement.documentno = $18group by ma_workrequirement.ma_workrequirement_id, m_product.m_product_id , m_product.value, m_product.NAME, m_product_category.NAME , m_attributevalue.value , COALESCE(modWk.documentno, '') , ma_process.NAME, ma_process.ma_process_id, ma_wrphase.ma_wrphase_id, COALESCE(modWk.man_product_modifications_id, ''), COALESCE(modProc.documentno, ''), ma_wrphase.em_man_control_quality, COALESCE(modProc.man_product_modifications_id, ''), COALESCE(M_ProductionPlan.rejectedquantity, 0), ma_process.em_man_invoice_method, coalesce(ma_process.em_man_qtyprocess,1), man_modification_processes.description
dd164d7c5bCOPY public.man_wr_times (man_wr_times_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, ma_workrequirement_id, ad_user_id, time_start, time_end, time_pause, time_total_pause) TO stdout
780c1676b8select 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
8b95a6d8beSELECT * FROM take_sample_subset(1,0)
8653e9fcc7COPY public.man_wr_voces (man_wr_voces_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, ma_workrequirement_id, m_product_id, man_product_modifications_id, qty_fact_voz) TO stdout
a5e40a232dSELECT 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)
4fcdb10468BEGIN
ffbe6ea696insert into C_OrderLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, C_Order_ID, Line, C_BPartner_ID, C_BPartner_Location_ID, DateOrdered, M_Product_ID, M_Warehouse_ID, DirectShip, C_UOM_ID, QtyOrdered, QtyDelivered, QtyInvoiced, C_Currency_ID, PriceList, PriceActual, Discount, ChargeAmt, C_Tax_ID, IsDescription, PriceStd, CANCELPRICEAD, Iseditlinenetamt, Gross_Unit_Price, Line_Gross_Amount, grosspricestd, Manage_Reservation, Manage_Prereservation, Explode, Print_Description, Relate_Orderline, EM_Man_Inoutline_ID, EM_Man_Ma_Workrequirement_ID, C_OrderLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40)
52730573e2SELECT Name,GAAP,IsAccrual,CostingMethod,C_Currency_ID,HasAlias, IsTradeDiscountPosted, IsDiscountCorrectsTax, AD_Client_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, '' as C_AcctSchema_ID FROM C_AcctSchema WHERE C_AcctSchema_ID=$1
81fe7b492cselect adpreferen0_.AD_Preference_ID as AD_Prefe1_83_, adpreferen0_.AD_Client_ID as AD_Clien2_83_, adpreferen0_.AD_Org_ID as AD_Org_I3_83_, adpreferen0_.IsActive as IsActive4_83_, adpreferen0_.Created as Created5_83_, adpreferen0_.CreatedBy as CreatedB6_83_, adpreferen0_.Updated as Updated7_83_, adpreferen0_.UpdatedBy as UpdatedB8_83_, adpreferen0_.AD_Window_ID as AD_Windo9_83_, adpreferen0_.AD_User_ID as AD_User10_83_, adpreferen0_.Attribute as Attribu11_83_, adpreferen0_.Value as Value12_83_, adpreferen0_.Property as Propert13_83_, adpreferen0_.IsPropertyList as IsPrope14_83_, adpreferen0_.VisibleAt_Client_ID as Visible15_83_, adpreferen0_.VisibleAt_Org_ID as Visible16_83_, adpreferen0_.VisibleAt_Role_ID as Visible17_83_, adpreferen0_.Selected as Selecte18_83_, adpreferen0_.AD_Module_ID as AD_Modu19_83_, adpreferen0_.Inherited_From as Inherit20_83_ from AD_Preference adpreferen0_ where coalesce(adpreferen0_.VisibleAt_Client_ID, '0')='0' and (adpreferen0_.VisibleAt_Role_ID is null) and (coalesce(adpreferen0_.VisibleAt_Org_ID, '0') in ($1)) and (adpreferen0_.AD_User_ID is null) and (adpreferen0_.AD_Window_ID is null) and adpreferen0_.IsPropertyList=$2 and adpreferen0_.Property=$3 and (adpreferen0_.AD_Org_ID in ($4)) and (adpreferen0_.AD_Client_ID in ($5)) and adpreferen0_.IsActive='Y' order by adpreferen0_.AD_Preference_ID
def99b80b7INSERT INTO sample_stat_indexes ( server_id, sample_id, datid, indexrelid, tablespaceid, idx_scan, idx_tup_read, idx_tup_fetch, idx_blks_read, idx_blks_hit, relsize, relsize_diff, indisunique, relpages_bytes, relpages_bytes_diff ) SELECT cur.server_id AS server_id, cur.sample_id AS sample_id, cur.datid AS datid, cur.indexrelid AS indexrelid, cur.tablespaceid AS tablespaceid, cur.idx_scan - COALESCE(lst.idx_scan,$4) AS idx_scan, cur.idx_tup_read - COALESCE(lst.idx_tup_read,$5) AS idx_tup_read, cur.idx_tup_fetch - COALESCE(lst.idx_tup_fetch,$6) AS idx_tup_fetch, cur.idx_blks_read - COALESCE(lst.idx_blks_read,$7) AS idx_blks_read, cur.idx_blks_hit - COALESCE(lst.idx_blks_hit,$8) AS idx_blks_hit, cur.relsize, cur.relsize - COALESCE(lst.relsize,$9) AS relsize_diff, cur.indisunique, cur.relpages_bytes AS relpages_bytes, cur.relpages_bytes - COALESCE(lst.relpages_bytes,$10) AS relpages_bytes_diff FROM last_stat_indexes cur JOIN last_stat_database dbcur USING (server_id, sample_id, datid) LEFT JOIN last_stat_database dblst ON (dblst.server_id, dblst.sample_id, dblst.datid, dblst.stats_reset) = (dbcur.server_id, dbcur.sample_id - $11, dbcur.datid, dbcur.stats_reset) LEFT OUTER JOIN last_stat_indexes lst ON (lst.server_id, lst.sample_id, lst.datid, lst.indexrelid) = (dblst.server_id, dblst.sample_id, dblst.datid, cur.indexrelid) WHERE (cur.server_id, cur.sample_id, cur.in_sample) = (sserver_id, s_id, $12)
ab52f02a40DELETE FROM last_stat_indexes WHERE server_id=sserver_id AND sample_id != s_id
3cf9d838f3ANALYZE last_stat_indexes
a98f2159e7ANALYZE last_stat_user_functions
fbc203961cCOPY public.man_product_processes (man_product_processes_id, m_product_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, ma_process_id, description) TO stdout
0395cd7d8fSHOW server_version
236f42a0f2SELECT SUM(n_dead_tup) AS total_dead_tuples FROM pg_stat_user_tables WHERE n_dead_tup > $1
0c247acdf0VACUUM (FULL, VERBOSE, ANALYZE)
2e0b729b87VACUUM (FULL, VERBOSE, ANALYZE)
9fab4770a7VACUUM (FULL, VERBOSE, ANALYZE)
5205357fc7INSERT 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 )
5d2713997eCOPY public.ad_ref_data_loaded (ad_ref_data_loaded_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, ad_module_id, generic_id, specific_id, ad_table_id) TO stdout
fe26995756SELECT 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
860971ea70SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)
c33f21cc29SELECT $4 FROM ONLY "profile"."sample_stat_tablespaces" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "sample_id" OPERATOR(pg_catalog.=) $2 AND "tablespaceid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
8ce5c7c2fdSELECT checkpoints_timed,checkpoints_req FROM pg_stat_bgwriter
09dd3ceb9cSELECT sum(blks_read) AS blks_read,sum(blks_hit) AS blks_hit FROM pg_stat_database
65c1fa73a0COPY public.ad_process_run (ad_process_run_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, status, start_time, runtime, result, ad_process_request_id, report, end_time, log, ad_process_run_group_id, scheduler_instance, should_be_killed) TO stdout
ea88e6845bSELECT 1 FROM ONLY "public"."ad_client" x WHERE "ad_client_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
fae50d9c18DELETE FROM samples s USING servers n WHERE n.server_id = s.server_id AND s.server_id = sserver_id AND s.sample_time < now() - (COALESCE(n.max_sample_age,ret) || $7)::interval AND (s.server_id,s.sample_id) NOT IN (SELECT server_id,sample_id FROM bl_samples WHERE server_id = sserver_id)
b5ae6f04c1SELECT coalesce(t.MSGTEXT, m.MSGTEXT) AS MSGTEXT FROM AD_MESSAGE m left join AD_MESSAGE_TRL t on m.AD_MESSAGE_ID = t.AD_MESSAGE_ID and t.AD_LANGUAGE = $1 WHERE m.VALUE=$2
e4e07d6aaaCOPY public.ad_field_trl (ad_field_trl_id, ad_field_id, ad_language, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, description, help, istranslated) TO stdout
95572914afCOPY 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
23c054b2cfSELECT C_AcctSchema_Element_ID,SeqNo,Name,ElementType,C_Element_ID,IsMandatory,IsBalanced, Org_ID,C_ElementValue_ID,C_BPartner_ID,M_Product_ID,C_Activity_ID,C_Location_ID, C_Campaign_ID,C_Project_ID,C_SalesRegion_ID FROM C_AcctSchema_Element WHERE C_AcctSchema_ID=$1 AND IsActive='Y' ORDER BY SeqNo
bfac77ea29ANALYZE last_stat_tables
94981812f5SELECT $1,sum(pg_stat_get_db_xact_commit(oid)) FROM pg_database UNION ALL SELECT $2,sum(pg_stat_get_db_xact_rollback(oid)) FROM pg_database
6fb557c71cCOPY public.obtl_tax_parameter (obtl_tax_parameter_id, ad_client_id, ad_org_id, created, createdby, updated, updatedby, isactive, c_tax_id, obtl_tax_report_parameter_id) TO stdout
bbb5ea7d4aINSERT 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)
6e1c6d0949SELECT buffers_checkpoint,buffers_clean,buffers_backend,buffers_alloc FROM pg_stat_bgwriter
09a13047d0SELECT $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
ab75f0d002select 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 = 'es_ES' 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 = 'es_ES' UNION select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, 'es_ES' 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 = 'es_ES') and (text.filename is null OR text.filename = '/org/openbravo/erpCommon/security/Login.html' ) and text.isused = 'Y' order by orderSeq
7bbf8dc24bINSERT 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 )
7dfdbbb662SELECT datname,pg_database_size(oid) FROM pg_database ORDER BY 1
819231741dCOPY public.c_orderline (c_orderline_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, datedelivered, dateinvoiced, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, m_shipper_id, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, c_charge_id, chargeamt, c_tax_id, s_resourceassignment_id, ref_orderline_id, m_attributesetinstance_id, isdescription, quantityorder, m_product_uom_id, m_offer_id, pricestd, cancelpricead, c_order_discount_id, iseditlinenetamt, taxbaseamt, m_inoutline_id, c_return_reason_id, gross_unit_price, line_gross_amount, grosspricelist, c_costcenter_id, grosspricestd, a_asset_id, m_warehouse_rule_id, user1_id, quotationline_id, user2_id, create_reservation, c_project_id, so_res_status, manage_reservation, manage_prereservation, explode, bom_parent_id, print_description, overdue_return_days, relate_orderline, replacedorderline_id, c_aum, aumqty, returnline, em_man_inoutline_id, em_man_product_modifi_id, em_man_ma_workrequirement_id) TO stdout
e30a458893SELECT UseSuspenseBalancing,SuspenseBalancing_Acct, UseSuspenseError,SuspenseError_Acct, UseCurrencyBalancing, CurrencyBalancing_Acct, RetainedEarning_Acct,IncomeSummary_Acct, InterCompanyDueTo_Acct,InterCompanyDueFrom_Acct FROM C_AcctSchema_GL WHERE C_AcctSchema_ID=$1
078231c619select (select man_get_costot_vocesorder_wk(p_workrequirement_id)) -((select man_get_costotoalwokrefortwk(p_workrequirement_id,v_created)) +(select man_get_costotoal_mats_wk(p_workrequirement_id,v_created)) +(select mp.em_man_fixedcost from m_product mp where mp.m_product_id = v_product_id))

Schema object statistics

Top tables by estimated sequentially scanned volume

DBTablespaceSchemaTable~SeqBytesSeqScanIxScanIxFetInsUpdDelUpd(HOT)
etendopg_defaultpg_catalogpg_class3944 MB59395925515841231801657818011325
etendopg_defaultpg_catalogpg_proc2594 MB143175089106125
pg_proc(TOAST)18474838
etendopg_defaultpublicm_productionplan2543 MB85881022
m_productionplan(TOAST)
etendopg_defaultprofilelast_stat_database2205 MB941918888
etendopg_defaultpublicad_textinterfaces_trl993 MB2541127736245846
ad_textinterfaces_trl(TOAST)
etendopg_defaultprofilelast_stat_tablespaces536 MB342814444
last_stat_tablespaces(TOAST)
etendopg_defaultpublicma_workrequirement509 MB65814197607565
ma_workrequirement(TOAST)
postgrespg_defaultpg_catalogpg_class447 MB44063834638096107388107128
etendopg_defaultpublicad_table394 MB72011641164
ad_table(TOAST)
etendopg_defaultpg_catalogpg_attribute283 MB7025343711314772317723177
etendopg_defaultprofilelast_stat_indexes279 MB18633499327439543261483543262
etendopg_defaultprofilelast_stat_tables214 MB186892730001193167140293167174
etendopg_defaultprofilesample_stat_tables188 MB25135384040293600
etendopg_defaultprofilesample_statements136 MB49110137314281373
sample_statements(TOAST)
etendopg_defaultpublicc_location136 MB87151818
c_location(TOAST)
etendopg_defaultpublicad_image111 MB3
ad_image(TOAST)18002487788
etendopg_defaultpublicm_inoutline77 MB5254915055034
m_inoutline(TOAST)
etendopg_defaultpg_catalogpg_index74 MB163177279203644512512
etendopg_defaultprofilelast_stat_user_functions67 MB3895658551565820
last_stat_user_functions(TOAST)
etendopg_defaultpublicad_column59 MB1211536383
ad_column(TOAST)

Top tables by blocks fetched

DBTablespaceSchemaTableHeapIxTOASTTOAST-Ix
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultprofilelast_stat_tables341399415.861068800.50
etendopg_defaultpg_catalogpg_class10848855.0412397225.76
etendopg_defaultpublicad_textinterfaces_trl221073810.27636630.30
etendopg_defaultpg_catalogpg_attribute4181521.946079982.82
etendopg_defaultprofilelast_stat_indexes5753602.672057790.96
etendopg_defaultpublicad_image1240.006233282.90147900.07
etendopg_defaultpg_catalogpg_proc4148581.931610630.7522390.0175080.03
etendopg_defaultpg_catalogpg_index1925140.893688291.71
etendopg_defaultpg_catalogpg_type1521230.713264891.52
etendopg_defaultpg_catalogpg_operator3011061.401105900.51
etendopg_defaultpublicm_inoutline3632731.69186720.09
etendopg_defaultpg_catalogpg_cast448160.213155921.47
etendopg_defaultpublicad_textinterfaces3357831.5699220.05
etendopg_defaultpublicm_productionplan3254861.512800.00
etendopg_defaultpg_catalogpg_namespace1115220.521248060.58
etendopg_defaultpg_catalogpg_statistic675400.311306430.61125350.06197470.09
etendopg_defaultprofilelast_stat_database1883180.871110.00
etendopg_defaultpg_catalogpg_constraint1123910.52642100.30
etendopg_defaultpg_catalogpg_depend503930.231030890.48
postgrespg_defaultpg_catalogpg_attribute432410.20884500.41

Top tables by blocks read

DBTablespaceSchemaTableHeapIxTOASTTOAST-IxHit(%)
Blks%TotalBlks%TotalBlks%TotalBlks%Total
etendopg_defaultpublicad_image780.0152140177.5280631.2017.03
etendopg_defaultpg_catalogpg_attribute18270.275310.0899.77
etendopg_defaultprofilesample_stat_tables20640.31160.0096.31
etendopg_defaultpublicad_column18690.281910.0385.63
etendopg_defaultpublicad_process_run18330.27730.01140.00200.0096.12
etendopg_defaultpg_catalogpg_statistic9860.15870.015190.08200.0099.30
etendopg_defaultpublicad_process_request13540.20180.0093.99
etendopg_defaultpg_catalogpg_trigger8310.122800.0499.07
etendopg_defaultpublicman_product_processes11040.1660.00
etendopg_defaultpg_catalogpg_depend8070.121540.0299.37
etendopg_defaultprofilelast_stat_indexes8560.13820.0199.88
etendopg_defaultpg_catalogpg_constraint8210.12770.0199.49
etendopg_defaultpg_catalogpg_proc6810.10680.011200.02100.0099.85
etendopg_defaultprofilesample_statements7480.11910.0197.64
etendopg_defaultpublicobtl_tax_parameter7280.1150.00
etendopg_defaultprofilelast_stat_tables6700.10450.0199.98
etendopg_defaultpublicma_weemployee7050.1080.000.83
etendopg_defaultpg_catalogpg_attrdef6060.09370.0197.60
etendopg_defaultpg_catalogpg_class2710.042840.0499.98
etendopg_defaultpublicm_inoutline4680.0799.88

Top DML tables

DBTablespaceSchemaTableInsUpdDelUpd(HOT)SeqScanSeqFetIxScanIxFet
etendopg_defaultprofilelast_stat_indexes54326148354326218687394033499327439
etendopg_defaultprofilelast_stat_tables316714029316717418650949089273000119
etendopg_defaultpg_catalogpg_attribute231772317770903502534371131477
etendopg_defaultpg_catalogpg_statistic1179396112129636105746409
pg_statistic(TOAST)12471245755211059
etendopg_defaultprofilelast_stat_user_functions5658551565820389168510
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_class1801657818011325593917311898592551584123
etendopg_defaultpg_catalogpg_depend4358435892067894232748054
etendopg_defaultprofilesample_stat_tables40293600256954661353840
etendopg_defaultpg_catalogpg_type206620661229196155196147034
etendopg_defaultprofilesample_stat_indexes14831498252735851391613
etendopg_defaultprofilesample_statements14281373495118561101373
sample_statements(TOAST)
postgrespg_defaultpg_catalogpg_attribute121512153781493940185329
postgrespg_globalpg_catalogpg_shdepend67167191560153101586
etendopg_globalpg_catalogpg_shdepend67167191560153101586
etendopg_defaultprofilesample_stat_user_functions551683259960790683
etendopg_defaultpg_catalogpg_index512512163265206177279203644
postgrespg_defaultpg_catalogpg_class107388107128440611390443834638096
etendopg_defaultpublicad_process_run281281743645101228158
ad_process_run(TOAST)1050
postgrespg_defaultpg_catalogpg_depend259259102205024202203
postgrespg_defaultpg_catalogpg_statistic478364284121961487
pg_statistic(TOAST)15155867

Top tables by updated/deleted tuples

DBTablespaceSchemaTableUpdUpd(HOT)DelVacuumAutoVacuumAnalyzeAutoAnalyze
etendopg_defaultprofilelast_stat_indexes1483254326284723
etendopg_defaultprofilelast_stat_tables40297431671284723
etendopg_defaultpg_catalogpg_attribute23177111
etendopg_defaultpg_catalogpg_statistic1179396112
pg_statistic(TOAST)12453
etendopg_defaultpg_catalogpg_class657813251801111
etendopg_defaultprofilelast_stat_user_functions551205658284723
last_stat_user_functions(TOAST)
etendopg_defaultpg_catalogpg_depend435811
etendopg_defaultprofilesample_stat_tables360012
etendopg_defaultpg_catalogpg_type2066111
etendopg_defaultprofilesample_stat_indexes149812
etendopg_defaultprofilesample_statements137312
sample_statements(TOAST)
postgrespg_defaultpg_catalogpg_attribute1215111
etendopg_defaultprofilesample_stat_user_functions68312
postgrespg_globalpg_catalogpg_shdepend6713
etendopg_globalpg_catalogpg_shdepend6713
etendopg_defaultpg_catalogpg_index512111
postgrespg_defaultpg_catalogpg_class388128107111
postgrespg_defaultpg_catalogpg_statistic4783641
pg_statistic(TOAST)15
etendopg_defaultpublicad_process_request2892841
ad_process_request(TOAST)
etendopg_defaultpublicad_process_run2811
ad_process_run(TOAST)

Top growing tables

DBTablespaceSchemaTableSizeGrowthInsUpdDelUpd(HOT)
etendopg_defaultpublicad_process_run4928 kB224 kB281281
ad_process_run(TOAST)56 kB
etendopg_defaultpg_catalogpg_depend3128 kB8192 bytes43584358

Top indexes by blocks fetched

DBTablespaceSchemaTableIndexScansBlks%Total
etendopg_defaultpg_catalogpg_classpg_class_oid_index57014611621315.40
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index2533085609972.61
etendopg_defaultpg_catalogpg_castpg_cast_source_target_index3123433155431.47
etendopg_defaultpg_catalogpg_typepg_type_oid_index1484893059181.42
etendopg_defaultpg_catalogpg_indexpg_index_indexrelid_index1473483021571.40
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes334992057790.96
etendopg_defaultpg_catalogpg_procpg_proc_oid_index632861313300.61
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index610531306340.61
etendopg_defaultpg_catalogpg_namespacepg_namespace_oid_index1045011090460.51
etendopg_defaultprofilelast_stat_tablespk_last_stat_tables89271068800.50
postgrespg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index39401859950.40
etendopg_defaultpg_catalogpg_dependpg_depend_reference_index33615767610.36
etendopg_defaultpublicad_messagead_message_value_un33870698540.32
etendopg_defaultpublicad_message_trlad_message_trl_message_lang_un34032680660.32
etendopg_defaultpg_catalogpg_indexpg_index_indrelid_index29915666370.31
etendopg_defaultpublicad_textinterfaces_trlad_textinterfaces_trl_un_key12773636620.30
etendopg_defaultpg_catalogpg_operatorpg_operator_oprname_l_r_n_index27044597160.28
postgrespg_globalpg_catalogpg_db_role_settingpg_db_role_setting_databaseid_rol_index56704567470.26
etendopg_globalpg_catalogpg_db_role_settingpg_db_role_setting_databaseid_rol_index54084541040.25
etendopg_defaultpg_catalogpg_constraintpg_constraint_conrelid_index24110503530.23

Top indexes by blocks read

DBTablespaceSchemaTableIndexScansBlk Reads%TotalHits(%)
etendopg_defaultpublicad_image(TOAST)pg_toast_117268_index180080631.2045.48
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index2533082910.0499.95
etendopg_defaultpg_catalogpg_triggerpg_trigger_tgrelid_tgname_index140742740.0499.11
etendopg_defaultpublicm_inoutlinem_inoutline_product10192380.0498.28
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index332350.0399.50
etendopg_defaultpublicm_inoutlineem_man_wkreq_il_idx9972010.0393.34
etendopg_defaultpg_catalogpg_classpg_class_relname_nsp_index50891470.0299.41
etendopg_defaultpublicma_workrequirementma_workrequirement_key5361400.0292.68
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index61053870.0199.93
etendopg_defaultpublicad_columnad_column_name1850.011.16
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes33499820.0199.96
etendopg_defaultpg_catalogpg_dependpg_depend_reference_index33615780.0199.90
etendopg_defaultpg_catalogpg_dependpg_depend_depender_index8712760.0199.71
etendopg_defaultpg_catalogpg_classpg_class_oid_index570146700.0199.99
etendopg_defaultpublicad_fieldad_field_column476700.0192.72
etendopg_defaultprofilesample_statementsix_sample_stmts_qid21680.0197.59
etendopg_defaultpg_catalogpg_classpg_class_tblspc_relfilenode_index670.0199.53
etendopg_defaultpublicad_columnad_column_key487580.0194.09
etendopg_defaultpg_catalogpg_constraintpg_constraint_conrelid_index24110550.0199.89
etendopg_defaultpublicc_orderlinetaxc_orderlinetax_derline_tax_un530.0150.47

Top growing indexes

DBTablespaceSchemaTableIndexIndexTable
SizeGrowthInsUpdDel
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index680 kB16 kB2317723177
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index1032 kB8192 bytes2317723177
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index232 kB8192 bytes2182
etendopg_defaultpg_catalogpg_dependpg_depend_depender_index1728 kB8192 bytes43584358
postgrespg_defaultpg_catalogpg_dependpg_depend_reference_index264 kB8192 bytes259259

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_defaultpg_catalogpg_classpg_class_tblspc_relfilenode_index104 kB180152531801
postgrespg_defaultpg_catalogpg_classpg_class_tblspc_relfilenode_index16 kB107260107
etendopg_defaultpublicad_process_runad_process_run_ould_be_killed8192 bytes268268

User function statistics

Top functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendoprofiletake_sample2324.060.031.0460.001
etendoprofiletake_sample_subset2324.030.071.0450.003
etendoprofiletake_sample2323.972.471.0420.107
etendoprofilecollect_obj_stats2313.433.960.5840.172
etendoprofiledblink62110.8210.820.0170.017
etendoprofilesample_dbobj_delta235.875.870.2550.255
etendopublicequal15032663.041.030.0000.000
etendopublicto_number15037632.012.010.0000.000
etendopublicad_column_identifier27601.061.050.0000.000
etendopublicman_get_costotoal_mats_wk621.001.000.0160.016
etendopublicman_get_benefit_wk601.000.010.0170.000
etendoprofilecollect_pg_stat_statements_stats230.980.520.0420.022
etendoprofiledblink_connect690.320.320.0050.005
etendopublicobequals2926780.300.300.0000.000
etendopublicpg_stat_statements690.090.090.0010.001
etendopublicma_workeffort_validate10.080.010.0810.010
etendopublicc_gettax350.060.000.0020.000
etendopublicc_gettax350.060.000.0020.000
etendopublicc_gettax350.060.000.0020.000
etendopublicc_gettax350.060.050.0020.002

Top functions by executions

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicto_number15037632.012.010.0000.000
etendopublicequal15032663.041.030.0000.000
etendopublicobequals2926780.300.300.0000.000
etendopublicto_char61560.020.020.0000.000
etendopublicto_char33770.010.010.0000.000
etendopublicad_column_identifier27601.061.050.0000.000
etendopublicad_isorgincluded9710.030.030.0000.000
etendopublicad_istriggerenabled7860.020.020.0000.000
etendoprofiledblink62110.8210.820.0170.017
etendopublicuuid_generate_v43630.000.000.0000.000
etendopublicround3210.000.000.0000.000
etendopublicto_date2170.000.000.0000.000
etendopublicadd_days1580.000.000.0000.000
etendopublicman_get_import_voz1380.010.010.0000.000
etendopublicget_uuid1210.010.010.0000.000
etendopublicman_get_costot_vocesorder_wk950.000.000.0000.000
etendopublicad_get_org_le_bu750.000.000.0000.000
etendopublicpg_stat_statements690.090.090.0010.001
etendoprofiledblink_connect690.320.320.0050.005
etendopublicman_get_costotoalwokrefortwk620.020.020.0000.000

Top trigger functions by total time

DBSchemaFunctionExecutionsTime (s)
TotalSelfMeanMean self
etendopublicman_orderline_after_trg350.590.010.0170.000
etendopublicman_wr_voces_trg210.370.010.0170.000
etendopublicman_ma_wrphase_trg20.070.000.0330.001
etendopublicc_orderline_trg2370.060.030.0020.001
etendopublicman_orderline_before_trg20.050.000.0230.000
etendopublicman_wr_times_trg20.040.000.0220.001
etendopublicad_process_request_trg2900.030.020.0000.000
etendopublicc_orderlinetax_trg370.020.010.0010.000
etendopublicc_orderline_trg370.010.010.0000.000
etendopublicintr_c_orderline_trg350.010.000.0000.000
etendopublicm_inoutline_trg40.010.000.0020.001
etendopublicm_transaction_trg40.010.000.0020.001
etendopublicc_ordertax_trg370.010.000.0000.000
etendopublicc_orderline2_trg370.010.000.0000.000
etendopublicintr_m_inoutline_trg40.000.000.0010.000
etendopublicc_order_chk_restrinctions_trg500.000.000.0000.000
etendopublicc_ordline_chk_restrictions_trg370.000.000.0000.000
etendopublicm_transaction_trg240.000.000.0010.001
etendopublicc_order_trg2440.000.000.0000.000
etendopublicc_order_trg370.000.000.0000.000

Vacuum-related statistics

Top tables by vacuum operations

DBTablespaceSchemaTableVacuum countAutovacuum countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables283167140293167174
etendopg_defaultprofilelast_stat_indexes28543261483543262
etendopg_defaultprofilelast_stat_user_functions285658551565820
etendopg_defaultpg_catalogpg_statistic2117939611
postgrespg_defaultpg_catalogpg_type1157157
postgrespg_defaultpg_catalogpg_attribute112151215
postgrespg_defaultpg_catalogpg_class1107388107128
postgrespg_defaultpg_catalogpg_statistic1478364
etendopg_defaultpg_catalogpg_type120662066
etendopg_defaultpg_catalogpg_attribute12317723177
etendopg_defaultpg_catalogpg_class11801657818011325
etendopg_defaultpg_catalogpg_index1512512
etendopg_defaultprofilelast_stat_database18888

Top tables by analyze operations

DBTablespaceSchemaTableAnalyze countAutoanalyze countInsUpdDelUpd(HOT)
etendopg_defaultprofilelast_stat_tables47233167140293167174
etendopg_defaultprofilelast_stat_indexes4723543261483543262
etendopg_defaultprofilelast_stat_user_functions47235658551565820
etendopg_defaultprofilelast_stat_tablespaces224444
postgrespg_globalpg_catalogpg_tablespace3
postgrespg_globalpg_catalogpg_shdepend3671671
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
etendopg_globalpg_catalogpg_tablespace3
etendopg_globalpg_catalogpg_shdepend3671671
etendopg_globalpg_catalogpg_authid3
etendopg_globalpg_catalogpg_auth_members3
etendopg_globalpg_catalogpg_database3

Top indexes by estimated vacuum load

DBTablespaceSchemaTableIndex~Vacuum bytesVacuum cntAutovacuum cntIX sizeRelsize
etendopg_defaultprofilelast_stat_indexespk_last_stat_indexes11 MB28413 kB1542 kB
etendopg_defaultprofilelast_stat_tablespk_last_stat_tables5824 kB28206 kB1187 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index1032 kB11032 kB4112 kB
etendopg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index680 kB1680 kB4112 kB
etendopg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index464 kB2232 kB2872 kB
etendopg_defaultpg_catalogpg_typepg_type_typname_nsp_index192 kB1192 kB472 kB
etendopg_defaultpg_catalogpg_classpg_class_relname_nsp_index184 kB1184 kB680 kB
etendopg_defaultpg_catalogpg_statistic(TOAST)pg_toast_2619_index168 kB356 kB2240 kB
postgrespg_defaultpg_catalogpg_attributepg_attribute_relid_attnam_index112 kB1112 kB408 kB
etendopg_defaultpg_catalogpg_classpg_class_oid_index104 kB1104 kB680 kB
etendopg_defaultpg_catalogpg_classpg_class_tblspc_relfilenode_index104 kB1104 kB680 kB
etendopg_defaultpg_catalogpg_typepg_type_oid_index96 kB196 kB472 kB
postgrespg_defaultpg_catalogpg_attributepg_attribute_relid_attnum_index80 kB180 kB408 kB
etendopg_defaultpg_catalogpg_indexpg_index_indrelid_index72 kB172 kB464 kB
etendopg_defaultpg_catalogpg_indexpg_index_indexrelid_index72 kB172 kB464 kB
postgrespg_defaultpg_catalogpg_typepg_type_typname_nsp_index40 kB140 kB104 kB
postgrespg_defaultpg_catalogpg_statisticpg_statistic_relid_att_inh_index40 kB140 kB240 kB
postgrespg_defaultpg_catalogpg_typepg_type_oid_index32 kB132 kB104 kB
postgrespg_defaultpg_catalogpg_classpg_class_relname_nsp_index32 kB132 kB104 kB
postgrespg_defaultpg_catalogpg_classpg_class_oid_index16 kB116 kB104 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
etendopublicad_process_request47371105440 kB

Top tables by modified tuples ratio

Table shows modified tuples statistics since last analyze.

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

DBSchemaTableLiveDeadMod%ModLast AASize
etendopublicad_process_request4737112002026-05-12 12:12:32.032373+025440 kB

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_size7864328kB/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_mem524288kB/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-17 02:00:03.91261+02
pg_conf_load_time2026-07-18 02:00:04.388267+022026-07-18 03:00:02+02
pg_postmaster_start_time2026-07-17 02:00:04.029848+02
pg_postmaster_start_time2026-07-18 02:00:04.504754+022026-07-18 03:00:02+02
pg_stat_statements.max10000/etc/postgresql/10/main/postgresql.conf:660
pg_stat_statements.trackall/etc/postgresql/10/main/postgresql.conf:661
random_page_cost1.1/etc/postgresql/10/main/postgresql.conf:307
server_encodingUTF8
shared_buffers2621448kB/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_mem5242kB/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_identifier6876315319645054122
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