Postgres profile report (StartID: 337, EndID: 360)

pg_profile version 0.3.6

Server name: local

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

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

Report sections

Server statistics

Database statistics
Statement statistics by database
Cluster statistics
Tablespace statistics

SQL query statistics

Top SQL by execution time
Top SQL by executions
Top SQL by shared blocks fetched
Top SQL by shared blocks read
Top SQL by shared blocks dirtied
Top SQL by shared blocks written
Top SQL by temp usage
Complete list of SQL texts

Schema object statistics

Top tables by estimated sequentially scanned volume
Top tables by blocks fetched
Top tables by blocks read
Top DML tables
Top tables by updated/deleted tuples
Top growing tables
Top indexes by blocks fetched
Top indexes by blocks read
Top growing indexes
Unused indexes

User function statistics

Top functions by total time
Top functions by executions
Top trigger functions by total time

Vacuum-related statistics

Top tables by vacuum operations
Top tables by analyze operations
Top indexes by estimated vacuum load
Top tables by dead tuples ratio
Top tables by modified tuples ratio

Cluster settings during the report interval

Server statistics

Database statistics

Database	Transactions			Block statistics			Tuples					Temp files		Size	Growth
Database	Commits	Rollbacks	Deadlocks	Hit(%)	Read	Hit	Ret	Fet	Ins	Upd	Del	Size	Files	Size	Growth
etendo	60579	7		96.08	1001514	24573057	126773701	21891724	1381363	26334	133057			3122 MB	-1016 kB
postgres	11869			99.81	1313	703323	1985165	365528	2012	866	1772			6463 kB	32 kB
Total	72448	7		96.18	1002827	25276380	128758866	22257252	1383375	27200	134829			3128 MB	-984 kB

Statement statistics by database

Database	Calls	Time (s)				Fetched (blk)		Dirtied (blk)		Temp (blk)		Local (blk)		Statements
Database	Calls	Exec	Read	Write	Trg	Shared	Local	Shared	Local	Read	Write	Read	Write	Statements
etendo	318723	414.21			8.80	37512189		376227						8845
postgres	5620	10.79				127690		236						350
template1	6350	8.12				47815		237						278
Total	330693	433.12			8.80	37687694		376700						9473

Cluster statistics

Metric	Value
Scheduled checkpoints	275
Requested checkpoints	1
Checkpoint write time (s)	2484.66
Checkpoint sync time (s)	0.61
Checkpoints buffers written	162242
Background buffers written	4000
Backend buffers written	513714
Backend fsync count
Bgwriter interrupts (too many buffers)	13
Number of buffers allocated	1002628
WAL generated	3383 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

Tablespace	Path	Size	Growth
pg_default		3142 MB	-968 kB
pg_global		542 kB

SQL query statistics

Top SQL by execution time

Query ID	Database	Exec (s)	%Total	Rows	Execution times (ms)				Executions
Query ID	Database	Exec (s)	%Total	Rows	Mean	Min	Max	StdErr	Executions
95572914af [cd9c0fd2]	etendo	188.01	43.41	903	188009.979	188009.979	188009.979		1
9fab4770a7 [948be82f]	etendo	80.57	18.60		80573.969	80573.969	80573.969		1
e72111fc0b [165cfe9e]	etendo	23.80	5.49	23	1034.754	918.420	1628.818	165.703	23
8b95a6d8be [5bf034e8]	etendo	23.79	5.49		1034.537	918.209	1628.600	165.708	23
82e3327dfb [11efae27]	etendo	7.85	1.81	485	16.181	14.961	22.497	0.929	485
078231c619 [fb4a8a01]	etendo	6.32	1.46	385	16.414	15.153	23.810	0.985	385
5205357fc7 [9829805d]	etendo	5.43	1.25	54326	118.084	21.385	518.351	106.653	46
7bbf8dc24b [ec3901fa]	etendo	5.00	1.15	31671	108.677	25.095	227.522	81.432	46
ab75f0d002 [ea3ffc6b]	etendo	4.99	1.15	532348	3.408	2.545	9.514	0.685	1463
63598c4dc1 [32078409]	etendo	4.89	1.13		244.688	44.946	880.964	231.787	20
fb78e2110c [3f26be12]	etendo	3.63	0.84	222	16.345	15.310	22.900	0.761	222
823682fddf [505cb7c7]	etendo	3.57	0.82	154	52.457	3.948	264.856	38.118	68
780c1676b8 [58bd0761]	etendo	3.50	0.81	1336	2.620	1.226	8.981	0.979	1336
579c04f6a4 [22217272]	etendo	3.36	0.78	49016	152.699	120.549	465.472	76.002	22
a5e40a232d [6d193752]	etendo	3.13	0.72	28358	142.100	125.093	165.070	8.984	22
94981812f5 [d6e97f55]	postgres	2.71	0.63	528	10.266	0.117	11.700	0.643	264
09dd3ceb9c [ac17e023]	postgres	2.58	0.60	252	10.252	0.168	11.568	0.646	252
6e1c6d0949 [dccac99b]	template1	2.58	0.60	252	10.232	0.098	10.635	0.643	252
8ce5c7c2fd [a8855ea7]	template1	2.56	0.59	252	10.142	0.093	10.522	1.104	252
383476269e [75f62629]	etendo	2.16	0.50	31	69.693	34.038	318.755	62.105	31

Top SQL by executions

Query ID	Database	Executions	%Total	Rows	Mean(ms)	Min(ms)	Max(ms)	StdErr(ms)	Elapsed(s)
09a13047d0 [e0488e43]	etendo	97515	29.49	97515	0.004	0.002	18.454	0.064	0.4
47521f7ce5 [4ef2b412]	etendo	35403	10.71	35403	0.004	0.002	8.032	0.054	0.1
b5ae6f04c1 [bb90fd8a]	etendo	18937	5.73	18937	0.015	0.008	0.435	0.010	0.3
fe26995756 [a0abb6c3]	etendo	8832	2.67	8832	0.012	0.008	0.327	0.005	0.1
0773a44802 [141ca58a]	etendo	5867	1.77	5867	0.004	0.002	0.321	0.005	0.0
6c3324a757 [30e34f7a]	etendo	5425	1.64		0.005	0.003	0.052	0.002	0.0
4fcdb10468 [6f9b1a85]	etendo	5347	1.62		0.002	0.000	0.100	0.003	0.0
ae36bf3fd6 [2049516b]	etendo	5341	1.62		0.001	0.000	0.041	0.001	0.0
c33f21cc29 [a38abef0]	etendo	5276	1.60	5276	0.004	0.002	0.230	0.004	0.0
23c054b2cf [cdfab523]	etendo	4224	1.28	21120	0.017	0.011	0.088	0.004	0.1
52730573e2 [708934a0]	etendo	4224	1.28	4224	0.009	0.006	0.060	0.002	0.0
e30a458893 [f8bb1c8e]	etendo	4224	1.28	4224	0.007	0.004	0.071	0.002	0.0
74c239e6b0 [31bc0d20]	etendo	3313	1.00	3299	0.008	0.002	1.986	0.036	0.0
0395cd7d8f [90d234b8]	template1	2640	0.80		0.011	0.009	0.040	0.002	0.0
18dfa40a69 [13286d05]	etendo	2410	0.73	2410	0.003	0.002	0.017	0.001	0.0
7531c1665f [8aff38a8]	etendo	2315	0.70	2283	0.003	0.002	0.018	0.002	0.0
abcc32ea62 [d553b28a]	etendo	2280	0.69	2280	0.102	0.067	1.277	0.036	0.2
1794fad412 [2dd25169]	etendo	2280	0.69	2280	0.026	0.015	0.416	0.013	0.1
ea88e6845b [b6b4a757]	etendo	1846	0.56	1846	0.006	0.002	0.074	0.004	0.0
85648edf27 [f9eb6039]	etendo	1846	0.56	1846	0.005	0.002	1.298	0.030	0.0

Top SQL by shared blocks fetched

Query ID	Database	blks fetched	%Total	Hits(%)	Elapsed(s)	Rows	Executions
9fab4770a7 [948be82f]	etendo	6599545	17.51	88.76	80.6		1
e72111fc0b [165cfe9e]	etendo	4646266	12.33	99.99	23.8	23	23
8b95a6d8be [5bf034e8]	etendo	4646128	12.33	99.99	23.8		23
ab75f0d002 [ea3ffc6b]	etendo	2653033	7.04	100.00	5.0	532348	1463
53f041022a [1c089a92]	etendo	2315576	6.14	100.00	2.1	2646	23
82e3327dfb [11efae27]	etendo	1864085	4.95	100.00	7.8	485	485
579c04f6a4 [22217272]	etendo	1559030	4.14	100.00	3.4	49016	22
078231c619 [fb4a8a01]	etendo	1488936	3.95	99.99	6.3	385	385
823682fddf [505cb7c7]	etendo	911864	2.42	99.58	3.6	154	68
fb78e2110c [3f26be12]	etendo	861101	2.28	100.00	3.6	222	222
a5e40a232d [6d193752]	etendo	761644	2.02	100.00	3.1	28358	22
63598c4dc1 [32078409]	etendo	563649	1.50	99.94	4.9		20
383476269e [75f62629]	etendo	482648	1.28	99.99	2.2	31	31
8c11584bf9 [dbe5263b]	etendo	467446	1.24	100.00	2.0	60	60
ffbe6ea696 [6ff0b59f]	etendo	451552	1.20	99.87	2.1	106	106
491dedbb59 [22879b7e]	etendo	390024	1.03	99.99	1.6	101	101
86970244f8 [3e74368]	etendo	387957	1.03	100.00	1.7	101	101
189e1713fc [6bb4764a]	etendo	348330	0.92	99.97	1.5	87	87
5205357fc7 [9829805d]	etendo	339728	0.90	99.99	5.4	54326	46
de8541e1aa [100abf77]	etendo	319311	0.85	99.96	1.4	41	41

Query ID	Database	Reads	%Total	Hits(%)	Elapsed(s)	Rows	Executions
9fab4770a7 [948be82f]	etendo	741951	73.90	88.76	80.6		1
95572914af [cd9c0fd2]	etendo	209475	20.87	34.36	188.0	903	1
819231741d [ee6bcd7b]	etendo	8924	0.89	0.17	0.8	115997	1
2d5eee73ff [676cf476]	etendo	5134	0.51	36.13	0.3	21	21
85c5b336fc [b917487a]	etendo	4828	0.48	0.12	0.4	115997	1
8653e9fcc7 [63a051b4]	etendo	4227	0.42	0.45	0.4	125004	1
823682fddf [505cb7c7]	etendo	3869	0.39	99.58	3.6	154	68
cb65787e2e [34618be5]	etendo	3265	0.33	0.64	0.4	86807	1
e1fa83416e [c5d78cc9]	etendo	2419	0.24	55.85	0.5	157768	1
5d2713997e [9874a2f8]	etendo	1214	0.12		0.1	36930	1
2e0b729b87 [948be82f]	postgres	1055	0.11	97.41	2.2		1
0c247acdf0 [948be82f]	template1	1054	0.10	97.41	2.1		1
dd164d7c5b [51d43ddf]	etendo	837	0.08	0.83	0.0	25637	1
421633828b [5015950f]	etendo	704	0.07	0.42	0.0	24509	1
fb03d4bd20 [14a0b57d]	etendo	703	0.07	0.71	0.0	24517	1
e4e07d6aaa [c7b7b73b]	etendo	607	0.06		0.1	14950	1
ffbe6ea696 [6ff0b59f]	etendo	594	0.06	99.87	2.1	106	106
fbc203961c [8d9c7ac8]	etendo	549	0.05	0.54	0.0	15363	1
e72111fc0b [165cfe9e]	etendo	473	0.05	99.99	23.8	23	23
8b95a6d8be [5bf034e8]	etendo	473	0.05	99.99	23.8		23

Top SQL by shared blocks dirtied

Query ID	Database	Dirtied	%Total	Hits(%)	Elapsed(s)	Rows	Executions
9fab4770a7 [948be82f]	etendo	319316	84.77	88.76	80.6		1
e72111fc0b [165cfe9e]	etendo	15435	4.10	99.99	23.8	23	23
8b95a6d8be [5bf034e8]	etendo	15435	4.10	99.99	23.8		23
5205357fc7 [9829805d]	etendo	4219	1.12	99.99	5.4	54326	46
7bbf8dc24b [ec3901fa]	etendo	3158	0.84	100.00	5.0	31671	46
860971ea70 [a2b1d8b5]	etendo	1800	0.48	99.69	1.0	23	23
bbb5ea7d4a [dbbb08c5]	etendo	1653	0.44	99.27	0.1	287	287
bfac77ea29 [d422fd3a]	etendo	992	0.26	99.93	0.9		44
ffbe6ea696 [6ff0b59f]	etendo	531	0.14	99.87	2.1	106	106
627abb38ab [b8b908b]	etendo	527	0.14	99.88	0.3	3416	21
ab52f02a40 [7de5e657]	etendo	486	0.13	100.00	0.1	44878	19
3cf9d838f3 [7e502be6]	etendo	480	0.13	99.90	0.7		40
fae50d9c18 [b746d230]	etendo	367	0.10	99.96	0.2	21	15
c2a2eb3923 [ffb6404]	etendo	340	0.09	98.88	0.3	5	5
79064e5d0c [d5eb7d45]	etendo	340	0.09	98.88	0.3	5	5
5695e7218b [2c3218e3]	etendo	333	0.09	99.98	0.4	4674	38
9b785e47a4 [2a7c06f1]	etendo	328	0.09	97.33	0.1	106	106
efbdf5f84a [c2b69e40]	etendo	328	0.09	96.46	0.1	106	106
74c239e6b0 [31bc0d20]	etendo	313	0.08	100.00	0.0	3299	3313
53f041022a [1c089a92]	etendo	295	0.08	100.00	2.1	2646	23

Top SQL by shared blocks written

Query ID	Database	Written	%Total	%BackendW	Hits(%)	Elapsed(s)	Executions
9fab4770a7 [948be82f]	etendo	174671	25.69	34.00	88.76	80.6	1
0c247acdf0 [948be82f]	template1	55	0.01	0.01	97.41	2.1	1
2e0b729b87 [948be82f]	postgres	55	0.01	0.01	97.41	2.2	1

Query ID

Database

Written

%Total

%BackendW

Hits(%)

Elapsed(s)

Rows

Executions

9fab4770a7

[948be82f]

etendo

174671

25.69

34.00

88.76

80.6

0c247acdf0

[948be82f]

template1

0.01

97.41

2.1

2e0b729b87

[948be82f]

postgres

0.01

97.41

2.2

Top SQL by temp usage

No data in this section

Complete list of SQL texts

QueryID	Query Text
86970244f8	select man_get_costotoal_mats_wk(v_ma_workrequirement_id,v_created)
627abb38ab	INSERT 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)
c2a2eb3923	SELECT M_INOUT_POST(PInstance_ID, $2)
de8541e1aa	insert into MA_WRPhase (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, Outsourced, Startdate, Enddate, Estimatedtime, Runtime, Usedmaterial, EM_Man_Control_Quality, MA_Wrphase_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)
82e3327dfb	SELECT 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
18dfa40a69	SELECT $1 FROM DUAL
0773a44802	SELECT $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
fb03d4bd20	COPY 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
e72111fc0b	SELECT profile.take_sample()
53f041022a	UPDATE 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)
ae36bf3fd6	COMMIT
579c04f6a4	SELECT 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)
491dedbb59	select man_get_benefit_wk(v_ma_workrequirement_id)
9b785e47a4	INSERT 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)
5695e7218b	INSERT 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 )
1794fad412	SELECT coalesce ((SELECT COALESCE(TO_CHAR(MAX(TT.Name)), TO_CHAR(T.Name)) FROM AD_Window_Trl TT WHERE TT.AD_Window_ID=T.AD_Window_ID AND TT.AD_LANGUAGE=L.AD_LANGUAGE), $1) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=$2) L, AD_Window T WHERE AD_Window_ID=$3
6c3324a757	select 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
74c239e6b0	SELECT $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
63598c4dc1	select 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)
cb65787e2e	COPY 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
fb78e2110c	select man_get_benefit_wk(new.ma_workrequirement_id)
47521f7ce5	SELECT $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
421633828b	COPY 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
823682fddf	SELECT 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
dd164d7c5b	COPY 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
780c1676b8	select 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
8b95a6d8be	SELECT * FROM take_sample_subset(1,0)
8653e9fcc7	COPY 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
2d5eee73ff	select adimage0_.AD_Image_ID as AD_Image1_51_0_, adimage0_.AD_Client_ID as AD_Clien2_51_0_, adimage0_.AD_Org_ID as AD_Org_I3_51_0_, adimage0_.IsActive as IsActive4_51_0_, adimage0_.Created as Created5_51_0_, adimage0_.CreatedBy as CreatedB6_51_0_, adimage0_.Updated as Updated7_51_0_, adimage0_.UpdatedBy as UpdatedB8_51_0_, adimage0_.Name as Name9_51_0_, adimage0_.ImageURL as ImageUR10_51_0_, adimage0_.BinaryData as BinaryD11_51_0_, adimage0_.Width as Width12_51_0_, adimage0_.Height as Height13_51_0_, adimage0_.Mimetype as Mimetyp14_51_0_ from AD_Image adimage0_ where adimage0_.AD_Image_ID=$1
189e1713fc	insert into man_wr_voces (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, MA_Workrequirement_ID, M_Product_ID, QTY_Fact_Voz, MAN_Wr_Voces_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)
a5e40a232d	SELECT 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)
4fcdb10468	BEGIN
ffbe6ea696	insert 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)
52730573e2	SELECT 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
383476269e	SELECT * FROM MA_WorkEffort_Validate($1)
ab52f02a40	DELETE FROM last_stat_indexes WHERE server_id=sserver_id AND sample_id != s_id
3cf9d838f3	ANALYZE last_stat_indexes
7531c1665f	SELECT LEVELNO FROM AD_ORG_TREE WHERE AD_ORG_ID = p_orgid AND AD_PARENT_ORG_ID = p_parentorgid AND AD_CLIENT_ID = p_clientid
fbc203961c	COPY 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
0395cd7d8f	SHOW server_version
0c247acdf0	VACUUM (FULL, VERBOSE, ANALYZE)
2e0b729b87	VACUUM (FULL, VERBOSE, ANALYZE)
9fab4770a7	VACUUM (FULL, VERBOSE, ANALYZE)
5205357fc7	INSERT 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 )
5d2713997e	COPY 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
fe26995756	SELECT 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
860971ea70	SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)
c33f21cc29	SELECT $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
8ce5c7c2fd	SELECT checkpoints_timed,checkpoints_req FROM pg_stat_bgwriter
09dd3ceb9c	SELECT sum(blks_read) AS blks_read,sum(blks_hit) AS blks_hit FROM pg_stat_database
ea88e6845b	SELECT 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
fae50d9c18	DELETE 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)
85c5b336fc	COPY public.c_orderlinetax (c_orderlinetax_id, c_orderline_id, c_tax_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, taxbaseamt, taxamt, line, c_order_id) TO stdout
b5ae6f04c1	SELECT 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
efbdf5f84a	SELECT 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)
e1fa83416e	COPY public.man_product_containers (man_product_containers_id, m_product_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, m_attributevalue_id) TO stdout
e4e07d6aaa	COPY 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
95572914af	COPY 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
23c054b2cf	SELECT 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
bfac77ea29	ANALYZE last_stat_tables
abcc32ea62	SELECT REPLACE(REPLACE(SQL_RECORD_IDENTIFIER, ':c_language', '''' \|\| p_Language \|\| ''''), ':c_ID', p_Record_ID) FROM AD_TABLE WHERE UPPER(TABLENAME)=UPPER(p_TableName)
79064e5d0c	SELECT * FROM M_INOUT_POST0($1)
94981812f5	SELECT $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
bbb5ea7d4a	INSERT 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)
8c11584bf9	UPDATE MA_WRPHASE SET DONEQUANTITY=DONEQUANTITY + Cur_ProductionPlan.PRODUCTIONQTY, RUNTIME=Cur_ProductionPlan.RUNTIME, UPDATED=TO_DATE(NOW()) WHERE MA_WRPhase_ID=Cur_ProductionPlan.MA_WRPHASE_ID
6e1c6d0949	SELECT buffers_checkpoint,buffers_clean,buffers_backend,buffers_alloc FROM pg_stat_bgwriter
09a13047d0	SELECT $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
ab75f0d002	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, 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
7bbf8dc24b	INSERT 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 )
819231741d	COPY 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
e30a458893	SELECT 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
85648edf27	SELECT 1 FROM ONLY "public"."ad_org" x WHERE "ad_org_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x
078231c619	select (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

DB	Tablespace	Schema	Table	~SeqBytes	SeqScan	IxScan	IxFet	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	public	m_productionplan	19 GB	640	1034	1440	60
etendo	pg_default	public	m_productionplan(TOAST)
etendo	pg_default	pg_catalog	pg_class	3941 MB	5935	593895	585328	1801	6578	1801	1325
etendo	pg_default	pg_catalog	pg_proc	2592 MB	1430	75423	106779	1		1
etendo	pg_default	pg_catalog	pg_proc(TOAST)			1881	4919	1		1
etendo	pg_default	profile	last_stat_database	2200 MB	93992			88		88
etendo	pg_default	public	ma_workrequirement	1361 MB	173	2661	135080	28	554		530
etendo	pg_default	public	ma_workrequirement(TOAST)
etendo	pg_default	public	c_orderline	908 MB	13	1752	2805	106
etendo	pg_default	public	c_orderline(TOAST)
etendo	pg_default	profile	last_stat_tablespaces	531 MB	33990			44		44
etendo	pg_default	profile	last_stat_tablespaces(TOAST)
postgres	pg_default	pg_catalog	pg_class	398 MB	3922	34363	34117	107	388	107	130
etendo	pg_default	public	ad_table	333 MB	609	1179	1179
etendo	pg_default	public	ad_table(TOAST)
etendo	pg_default	pg_catalog	pg_attribute	282 MB	70	256745	1139383	23177		23177
etendo	pg_default	profile	last_stat_indexes	279 MB	186	33545	327485	54326	1529	54326	3
etendo	pg_default	public	m_inoutline	262 MB	17	7080	2276719	48	66		8
etendo	pg_default	public	m_inoutline(TOAST)
etendo	pg_default	public	m_transaction	214 MB	12	10	10	49	10		1
etendo	pg_default	public	m_transaction(TOAST)
etendo	pg_default	profile	last_stat_tables	213 MB	186	8487	2738232	31671	3732	31671	62
etendo	pg_default	public	c_orderlinetax	189 MB	5	118		106
etendo	pg_default	public	c_orderlinetax(TOAST)
etendo	pg_default	profile	sample_stat_tables	186 MB	25	152	4060	3732		3789
etendo	pg_default	profile	sample_statements	137 MB	49	110	1431	1432		1431
etendo	pg_default	profile	sample_statements(TOAST)
etendo	pg_default	public	ad_textinterfaces_trl	136 MB	348	1893	855537
etendo	pg_default	public	ad_textinterfaces_trl(TOAST)
etendo	pg_default	public	ad_image	111 MB	3	349	266
etendo	pg_default	public	ad_image(TOAST)			1821	2518954
etendo	pg_default	public	ma_wrphase	77 MB	3	1136	2799	41	60		42
etendo	pg_default	public	ma_wrphase(TOAST)

Top tables by blocks fetched

DB	Tablespace	Schema	Table	Heap		Ix		TOAST		TOAST-Ix
DB	Tablespace	Schema	Table	Blks	%Total	Blks	%Total	Blks	%Total	Blks	%Total
etendo	pg_default	profile	last_stat_tables	3134325	14.42	104589	0.48
etendo	pg_default	public	m_productionplan	2450875	11.28	3464	0.02
etendo	pg_default	pg_catalog	pg_class	1085741	5.00	1242406	5.72
etendo	pg_default	pg_catalog	pg_attribute	422477	1.94	614836	2.83
etendo	pg_default	profile	last_stat_indexes	576933	2.66	207304	0.95
etendo	pg_default	public	m_inoutline	659027	3.03	40024	0.18
etendo	pg_default	public	ad_image	390	0.00	532	0.00	631135	2.90	14958	0.07
etendo	pg_default	pg_catalog	pg_proc	415116	1.91	161745	0.74	2286	0.01	7650	0.04
etendo	pg_default	pg_catalog	pg_index	193313	0.89	370195	1.70
etendo	pg_default	pg_catalog	pg_type	152204	0.70	326680	1.50
etendo	pg_default	pg_catalog	pg_operator	289896	1.33	106256	0.49
etendo	pg_default	pg_catalog	pg_cast	44923	0.21	316560	1.46
etendo	pg_default	public	ma_workrequirement	314660	1.45	10080	0.05
etendo	pg_default	public	ad_textinterfaces_trl	302913	1.39	9008	0.04
etendo	pg_default	pg_catalog	pg_namespace	116605	0.54	130448	0.60
etendo	pg_default	pg_catalog	pg_statistic	69530	0.32	135734	0.62	14793	0.07	20360	0.09
etendo	pg_default	pg_catalog	pg_constraint	145074	0.67	81191	0.37
etendo	pg_default	pg_catalog	pg_trigger	146109	0.67	59947	0.28
etendo	pg_default	profile	last_stat_database	187920	0.86	111	0.00
etendo	pg_default	pg_catalog	pg_depend	50403	0.23	103109	0.47

DB	Tablespace	Schema	Table	Heap	Ix	TOAST	TOAST-Ix	Hit(%)
Blks	%Total	Blks	%Total	Blks	%Total	Blks	%Total
etendo	pg_default	public	ad_image	77	0.01	3	0.00	522225	76.06	8055	1.17	18.03
etendo	pg_default	public	c_orderline	17891	2.61	267	0.04					86.79
etendo	pg_default	public	c_orderlinetax	9676	1.41	371	0.05					68.00
etendo	pg_default	public	ma_wrphase	6594	0.96	118	0.02					64.92
etendo	pg_default	public	m_transaction	4562	0.66	162	0.02					85.20
etendo	pg_default	public	m_inoutline	3945	0.57	598	0.09					99.35
etendo	pg_default	pg_catalog	pg_attribute	1905	0.28	533	0.08					99.76
etendo	pg_default	public	ma_weemployee	2121	0.31	64	0.01					43.76
etendo	pg_default	public	ad_column	1869	0.27	206	0.03					88.98
etendo	pg_default	public	ad_process_run	1948	0.28	74	0.01	15	0.00	25	0.00	95.88
etendo	pg_default	profile	sample_stat_tables	2027	0.30	14	0.00					96.35
etendo	pg_default	public	man_wr_times	1691	0.25	69	0.01					72.40
etendo	pg_default	pg_catalog	pg_statistic	1026	0.15	85	0.01	575	0.08	20	0.00	99.29
etendo	pg_default	public	m_production	1419	0.21	36	0.01					71.91
etendo	pg_default	public	ad_process_request	1355	0.20	21	0.00					93.96
etendo	pg_default	public	ad_ref_data_loaded	1214	0.18							0.00
etendo	pg_default	pg_catalog	pg_trigger	836	0.12	286	0.04					99.46
etendo	pg_default	public	obtl_tax_parameter	1092	0.16							40.00
etendo	pg_default	pg_catalog	pg_depend	805	0.12	155	0.02					99.37
etendo	pg_default	profile	last_stat_indexes	862	0.13	82	0.01					99.88

Top DML tables

DB	Tablespace	Schema	Table	Ins	Upd	Del	Upd(HOT)	SeqScan	SeqFet	IxScan	IxFet
etendo	pg_default	profile	last_stat_indexes	54326	1529	54326	3	186	873940	33545	327485
etendo	pg_default	profile	last_stat_tables	31671	3732	31671	62	186	509490	8487	2738232
etendo	pg_default	pg_catalog	pg_attribute	23177		23177		70	89461	256745	1139383
etendo	pg_default	pg_catalog	pg_statistic		11907		9867	2	12992	63753	48724
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	1271		1273				7839	11592
etendo	pg_default	profile	last_stat_user_functions	5658	599	5658	18	386	167034
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_catalog	pg_class	1801	6578	1801	1325	5935	17300251	593895	585328
etendo	pg_default	pg_catalog	pg_depend	4360		4360		9	206771	42335	48063
etendo	pg_default	profile	sample_stat_tables	3732		3789		25	689012	152	4060
etendo	pg_default	pg_catalog	pg_type	2066		2066		12	29197	155296	147126
etendo	pg_default	profile	sample_stat_indexes	1529		1511		25	277093	162	1638
etendo	pg_default	profile	sample_statements	1432		1431		49	515213	110	1431
etendo	pg_default	profile	sample_statements(TOAST)
postgres	pg_default	pg_catalog	pg_attribute	1215		1215		37	7991	39411	85342
postgres	pg_global	pg_catalog	pg_shdepend	671		671		9	15601	5312	1587
etendo	pg_global	pg_catalog	pg_shdepend	671		671		9	15601	5312	1587
etendo	pg_default	profile	sample_stat_user_functions	599		578		25	106680	93	578
etendo	pg_default	pg_catalog	pg_index	512		512		163	265187	177959	204685
postgres	pg_default	pg_catalog	pg_class	107	388	107	130	3922	1012640	34363	34117
etendo	pg_default	public	ma_workrequirement	28	554		530	173	3274538	2661	135080
etendo	pg_default	public	ma_workrequirement(TOAST)
etendo	pg_default	public	ad_process_run	287	287			7	35381	10130	8177
etendo	pg_default	public	ad_process_run(TOAST)	5						11	50
postgres	pg_default	pg_catalog	pg_depend	259		259		12	22056	2420	2203

Top tables by updated/deleted tuples

DB	Tablespace	Schema	Table	Upd	Upd(HOT)	Del	AutoVacuum	Analyze	AutoAnalyze
etendo	pg_default	profile	last_stat_indexes	1529	3	54326	29	47	23
etendo	pg_default	profile	last_stat_tables	3732	62	31671	29	47	23
etendo	pg_default	pg_catalog	pg_attribute			23177	1	1	1
etendo	pg_default	pg_catalog	pg_statistic	11907	9867		2
etendo	pg_default	pg_catalog	pg_statistic(TOAST)			1273	3
etendo	pg_default	pg_catalog	pg_class	6578	1325	1801	1	1	1
etendo	pg_default	profile	last_stat_user_functions	599	18	5658	29	47	23
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_catalog	pg_depend			4360		1	1
etendo	pg_default	profile	sample_stat_tables			3789		1	2
etendo	pg_default	pg_catalog	pg_type			2066	1	1	1
etendo	pg_default	profile	sample_stat_indexes			1511		1	2
etendo	pg_default	profile	sample_statements			1431		1	2
etendo	pg_default	profile	sample_statements(TOAST)
postgres	pg_default	pg_catalog	pg_attribute			1215	1	1	1
postgres	pg_global	pg_catalog	pg_shdepend			671		3
etendo	pg_global	pg_catalog	pg_shdepend			671		3
etendo	pg_default	profile	sample_stat_user_functions			578		1	2
etendo	pg_default	public	ma_workrequirement	554	530
etendo	pg_default	public	ma_workrequirement(TOAST)
etendo	pg_default	pg_catalog	pg_index			512	1	1	1
postgres	pg_default	pg_catalog	pg_class	388	130	107	1	1	1
postgres	pg_default	pg_catalog	pg_statistic	478	334		1
postgres	pg_default	pg_catalog	pg_statistic(TOAST)			15
etendo	pg_default	public	ad_process_run	287				1	1
etendo	pg_default	public	ad_process_run(TOAST)

Top growing tables

DB	Tablespace	Schema	Table	Size	Growth	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	public	ad_process_run	4008 kB	232 kB	287	287
etendo	pg_default	public	ad_process_run(TOAST)	56 kB	16 kB	5
etendo	pg_default	pg_catalog	pg_statistic	2536 kB	32 kB		11907		9867
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	2128 kB	56 kB	1271		1273
etendo	pg_default	public	ad_session_usage_audit	1864 kB	72 kB	248
etendo	pg_default	public	ad_session_usage_audit(TOAST)
etendo	pg_default	public	c_orderline	70 MB	64 kB	106
etendo	pg_default	public	c_orderline(TOAST)
etendo	pg_default	public	c_orderlinetax	38 MB	40 kB	106
etendo	pg_default	public	c_orderlinetax(TOAST)
etendo	pg_default	public	ad_process_request	5432 kB	32 kB	5	285		279
etendo	pg_default	public	ad_process_request(TOAST)
postgres	pg_default	pg_catalog	pg_statistic	248 kB	16 kB		478		334
postgres	pg_default	pg_catalog	pg_statistic(TOAST)	64 kB	8192 bytes	15		15
etendo	pg_default	public	m_inoutline	15 MB	24 kB	48	66		8
etendo	pg_default	public	m_inoutline(TOAST)
etendo	pg_default	public	m_transaction	18 MB	16 kB	49	10		1
etendo	pg_default	public	m_transaction(TOAST)
etendo	pg_default	public	ma_wrphase	26 MB	16 kB	41	60		42
etendo	pg_default	public	ma_wrphase(TOAST)
etendo	pg_default	pg_catalog	pg_depend	3112 kB	8192 bytes	4360		4360
etendo	pg_default	public	m_production	5664 kB	8192 bytes	31	31		31
etendo	pg_default	public	m_production(TOAST)
etendo	pg_default	public	ma_weemployee	5648 kB	8192 bytes	31
etendo	pg_default	public	man_wr_times	6752 kB	8192 bytes	31	31		29
etendo	pg_default	public	man_wr_times(TOAST)

Top indexes by blocks fetched

DB	Tablespace	Schema	Table	Index	Scans	Blks	%Total
etendo	pg_default	pg_catalog	pg_class	pg_class_oid_index	571214	1164278	5.36
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	256608	567700	2.61
etendo	pg_default	pg_catalog	pg_cast	pg_cast_source_target_index	313351	316559	1.46
etendo	pg_default	pg_catalog	pg_type	pg_type_oid_index	148612	306164	1.41
etendo	pg_default	pg_catalog	pg_index	pg_index_indexrelid_index	147858	303180	1.40
etendo	pg_default	profile	last_stat_indexes	pk_last_stat_indexes	33545	207304	0.95
etendo	pg_default	pg_catalog	pg_statistic	pg_statistic_relid_att_inh_index	63753	135734	0.62
etendo	pg_default	pg_catalog	pg_proc	pg_proc_oid_index	63455	131674	0.61
etendo	pg_default	pg_catalog	pg_namespace	pg_namespace_oid_index	104508	109059	0.50
etendo	pg_default	profile	last_stat_tables	pk_last_stat_tables	8487	104589	0.48
postgres	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	39411	86025	0.40
etendo	pg_default	pg_catalog	pg_depend	pg_depend_reference_index	33621	76778	0.35
etendo	pg_default	pg_catalog	pg_constraint	pg_constraint_conrelid_index	31589	66029	0.30
etendo	pg_default	pg_catalog	pg_index	pg_index_indrelid_index	28888	64328	0.30
etendo	pg_default	pg_catalog	pg_trigger	pg_trigger_tgrelid_tgname_index	26891	59209	0.27
etendo	pg_default	pg_catalog	pg_operator	pg_operator_oprname_l_r_n_index	26002	57411	0.26
postgres	pg_global	pg_catalog	pg_db_role_setting	pg_db_role_setting_databaseid_rol_index	54204	54224	0.25
etendo	pg_global	pg_catalog	pg_db_role_setting	pg_db_role_setting_databaseid_rol_index	54092	54134	0.25
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	79	47017	0.22
etendo	pg_default	pg_catalog	pg_operator	pg_operator_oid_index	21494	46284	0.21

DB	Tablespace	Schema	Table	Index	Scans	Blk Reads	%Total	Hits(%)
etendo	pg_default	public	ad_image(TOAST)	pg_toast_117268_index	1821	8055	1.17	46.15
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	256608	293	0.04	99.95
etendo	pg_default	pg_catalog	pg_trigger	pg_trigger_tgrelid_tgname_index	26891	280	0.04	99.53
etendo	pg_default	public	m_inoutline	m_inoutline_product	2523	275	0.04	98.82
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	79	237	0.03	99.50
etendo	pg_default	public	m_inoutline	em_man_wkreq_il_idx	2402	231	0.03	96.93
etendo	pg_default	pg_catalog	pg_class	pg_class_relname_nsp_index	5213	145	0.02	99.43
etendo	pg_default	public	ma_workrequirement	ma_workrequirement_key	2661	140	0.02	98.61
etendo	pg_default	public	c_orderlinetax	c_orderlinetax_derline_tax_un		124	0.02	61.13
etendo	pg_default	public	c_orderlinetax	c_orderlinetax_key		111	0.02	65.20
etendo	pg_default	public	c_orderlinetax	c_orderlinetax_orderline	106	109	0.02	82.89
etendo	pg_default	public	c_orderline	c_orderline_key	106	108	0.02	83.02
etendo	pg_default	public	man_wr_voces	man_wr_voces_key	176	97	0.01	88.07
etendo	pg_default	pg_catalog	pg_statistic	pg_statistic_relid_att_inh_index	63753	85	0.01	99.94
etendo	pg_default	public	ad_column	ad_column_name	2	85	0.01	50.29
etendo	pg_default	profile	last_stat_indexes	pk_last_stat_indexes	33545	82	0.01	99.96
etendo	pg_default	pg_catalog	pg_depend	pg_depend_reference_index	33621	79	0.01	99.90
etendo	pg_default	pg_catalog	pg_depend	pg_depend_depender_index	8714	76	0.01	99.71
etendo	pg_default	pg_catalog	pg_class	pg_class_oid_index	571214	71	0.01	99.99
etendo	pg_default	public	ad_field	ad_field_column	482	70	0.01	92.81

Top growing indexes

DB	Tablespace	Schema	Table	Index	Index		Table
DB	Tablespace	Schema	Table	Index	Size	Growth	Ins	Upd	Del
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	1152 kB	16 kB	23177		23177
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	752 kB	16 kB	23177		23177
etendo	pg_default	public	ad_session_usage_audit	ad_session_usage_audit_key	368 kB	16 kB	148
etendo	pg_default	pg_catalog	pg_depend	pg_depend_depender_index	1696 kB	8192 bytes	4360		4360
postgres	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	144 kB	8192 bytes	1215		1215
etendo	pg_default	public	c_orderline	c_orderline_key	6712 kB	8192 bytes	106
etendo	pg_default	public	c_orderline	em_man_ol_ma_wkreq_id_idx	6712 kB	8192 bytes	106
etendo	pg_default	public	c_orderlinetax	c_orderlinetax_derline_tax_un	11 MB	8192 bytes	106
etendo	pg_default	public	c_orderlinetax	c_orderlinetax_key	6712 kB	8192 bytes	106
etendo	pg_default	public	c_orderlinetax	c_orderlinetax_orderline	6712 kB	8192 bytes	106
etendo	pg_default	public	ma_wrphase	ma_wrphase_key	5032 kB	8192 bytes	41	18
etendo	pg_default	public	ma_wrphase	ma_wrphase_workrequirement	5032 kB	8192 bytes	41	9
etendo	pg_default	public	m_inoutline	m_inoutline_key	2232 kB	8192 bytes	48	32
etendo	pg_default	public	m_production	m_production_key	1440 kB	8192 bytes	31
etendo	pg_default	public	m_transaction	m_transaction_inoutline	2232 kB	8192 bytes	49	9
etendo	pg_default	public	man_wr_times	man_wr_times_key	1504 kB	8192 bytes	28	2
etendo	pg_default	public	man_wr_times	man_wr_times_ma_wkreq_id_idx	1504 kB	8192 bytes	28	2
etendo	pg_default	public	ma_weemployee	ma_weemployee_production_idx	1440 kB	8192 bytes	31
etendo	pg_default	public	ma_weemployee	ma_weemployee_key	1440 kB	8192 bytes	28
etendo	pg_default	public	c_orderline	c_orderline_product	6712 kB	8192 bytes

Unused indexes

This table contains non-scanned indexes (during report period), ordered by number of DML operations on underlying tables. Constraint indexes are excluded.

DB	Tablespaces	Schema	Table	Index	Index		Table
DB	Tablespaces	Schema	Table	Index	Size	Growth	Ins	Upd	Del
etendo	pg_default	pg_catalog	pg_class	pg_class_tblspc_relfilenode_index	104 kB		1801	5253	1801
postgres	pg_default	pg_catalog	pg_class	pg_class_tblspc_relfilenode_index	16 kB		107	258	107
etendo	pg_default	public	ad_process_run	ad_process_run_ould_be_killed	8192 bytes		262	262
etendo	pg_default	public	ma_weemployee	ma_weemployee_production_idx	1440 kB	8192 bytes	31

User function statistics

Top functions by total time

DB	Schema	Function	Executions	Time (s)
DB	Schema	Function	Executions	Total	Self	Mean	Mean self
etendo	profile	take_sample	23	23.80	0.03	1.035	0.001
etendo	profile	take_sample_subset	23	23.77	0.07	1.033	0.003
etendo	profile	take_sample	23	23.70	2.53	1.030	0.110
etendo	profile	collect_obj_stats	23	13.21	3.97	0.574	0.173
etendo	profile	dblink	621	10.55	10.55	0.017	0.017
etendo	public	man_get_costotoal_mats_wk	486	7.89	7.85	0.016	0.016
etendo	public	man_get_benefit_wk	385	6.34	0.03	0.016	0.000
etendo	profile	sample_dbobj_delta	23	5.79	5.79	0.252	0.252
etendo	public	equal	2268062	4.58	1.56	0.000	0.000
etendo	public	to_number	2268504	3.02	3.02	0.000	0.000
etendo	public	ma_workeffort_validate	31	2.16	0.13	0.070	0.004
etendo	public	ad_column_identifier	2760	1.08	1.07	0.000	0.000
etendo	profile	collect_pg_stat_statements_stats	23	0.98	0.51	0.043	0.022
etendo	profile	dblink_connect	69	0.32	0.32	0.005	0.005
etendo	public	obequals	292260	0.28	0.28	0.000	0.000
etendo	public	m_inout_post0	5	0.25	0.00	0.051	0.000
etendo	public	m_inout_post	6	0.25	0.12	0.042	0.020
etendo	public	c_gettax	106	0.16	0.00	0.002	0.000
etendo	public	c_gettax	106	0.16	0.00	0.002	0.000
etendo	public	c_gettax	106	0.16	0.00	0.002	0.000

Top functions by executions

DB	Schema	Function	Executions	Time (s)
DB	Schema	Function	Executions	Total	Self	Mean	Mean self
etendo	public	to_number	2268504	3.02	3.02	0.000	0.000
etendo	public	equal	2268062	4.58	1.56	0.000	0.000
etendo	public	obequals	292260	0.28	0.28	0.000	0.000
etendo	public	to_char	7321	0.02	0.02	0.000	0.000
etendo	public	to_char	4404	0.01	0.01	0.000	0.000
etendo	public	add_days	2923	0.00	0.00	0.000	0.000
etendo	public	ad_column_identifier	2760	1.08	1.07	0.000	0.000
etendo	public	ad_istriggerenabled	2653	0.06	0.06	0.000	0.000
etendo	public	ad_isorgincluded	2600	0.05	0.05	0.000	0.000
etendo	public	to_date	1662	0.02	0.02	0.000	0.000
etendo	public	uuid_generate_v4	1455	0.01	0.01	0.000	0.000
etendo	public	round	950	0.00	0.00	0.000	0.000
etendo	profile	dblink	621	10.55	10.55	0.017	0.017
etendo	public	man_get_import_voz	551	0.04	0.04	0.000	0.000
etendo	public	man_get_costotoal_mats_wk	486	7.89	7.85	0.016	0.016
etendo	public	man_get_costot_vocesorder_wk	466	0.02	0.02	0.000	0.000
etendo	public	man_get_costotoalwokrefortwk	447	0.08	0.08	0.000	0.000
etendo	public	man_get_benefit_wk	385	6.34	0.03	0.016	0.000
etendo	public	get_uuid	373	0.02	0.01	0.000	0.000
etendo	public	c_currency_convert_precision	260	0.00	0.00	0.000	0.000

Top trigger functions by total time

DB	Schema	Function	Executions	Time (s)
DB	Schema	Function	Executions	Total	Self	Mean	Mean self
etendo	public	man_ma_wrphase_trg	101	3.33	0.03	0.033	0.000
etendo	public	man_wr_voces_trg	116	1.96	0.03	0.017	0.000
etendo	public	man_orderline_after_trg	106	1.77	0.02	0.017	0.000
etendo	public	man_wr_times_trg	62	1.11	0.01	0.018	0.000
etendo	public	c_orderline_trg2	106	0.20	0.06	0.002	0.001
etendo	public	m_inoutline_trg	114	0.11	0.04	0.001	0.000
etendo	public	m_transaction_trg	60	0.05	0.02	0.001	0.000
etendo	public	c_orderlinetax_trg	106	0.04	0.02	0.000	0.000
etendo	public	ad_process_request_trg	290	0.03	0.02	0.000	0.000
etendo	public	intr_m_inoutline_trg	114	0.03	0.01	0.000	0.000
etendo	public	intr_c_orderline_trg	106	0.02	0.01	0.000	0.000
etendo	public	ma_wrphase_trg	101	0.02	0.02	0.000	0.000
etendo	public	c_orderline_trg	106	0.02	0.02	0.000	0.000
etendo	public	m_ioline_chk_restrictions_trg	114	0.02	0.01	0.000	0.000
etendo	public	m_storage_detail_trg	156	0.01	0.01	0.000	0.000
etendo	public	c_orderline2_trg	106	0.01	0.01	0.000	0.000
etendo	public	c_ordertax_trg	106	0.01	0.01	0.000	0.000
etendo	public	m_productionline_trg	2	0.01	0.00	0.005	0.002
etendo	public	m_transaction_trg2	49	0.01	0.01	0.000	0.000
etendo	public	c_order_chk_restrinctions_trg	132	0.01	0.00	0.000	0.000

Vacuum-related statistics

Top tables by vacuum operations

DB	Tablespace	Schema	Table	Autovacuum count	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	profile	last_stat_tables	29	31671	3732	31671	62
etendo	pg_default	profile	last_stat_indexes	29	54326	1529	54326	3
etendo	pg_default	profile	last_stat_user_functions	29	5658	599	5658	18
etendo	pg_default	pg_catalog	pg_statistic	2		11907		9867
postgres	pg_default	pg_catalog	pg_type	1	157		157
postgres	pg_default	pg_catalog	pg_attribute	1	1215		1215
postgres	pg_default	pg_catalog	pg_class	1	107	388	107	130
postgres	pg_default	pg_catalog	pg_statistic	1		478		334
etendo	pg_default	pg_catalog	pg_type	1	2066		2066
etendo	pg_default	pg_catalog	pg_attribute	1	23177		23177
etendo	pg_default	pg_catalog	pg_class	1	1801	6578	1801	1325
etendo	pg_default	pg_catalog	pg_index	1	512		512
etendo	pg_default	profile	last_stat_database	1	88		88

Top tables by analyze operations

DB	Tablespace	Schema	Table	Analyze count	Autoanalyze count	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	profile	last_stat_tables	47	23	31671	3732	31671	62
etendo	pg_default	profile	last_stat_indexes	47	23	54326	1529	54326	3
etendo	pg_default	profile	last_stat_user_functions	47	23	5658	599	5658	18
etendo	pg_default	profile	last_stat_tablespaces	22		44		44
postgres	pg_global	pg_catalog	pg_pltemplate	3
postgres	pg_global	pg_catalog	pg_tablespace	3
postgres	pg_global	pg_catalog	pg_shdepend	3		671		671
postgres	pg_global	pg_catalog	pg_authid	3
postgres	pg_global	pg_catalog	pg_auth_members	3
postgres	pg_global	pg_catalog	pg_shdescription	3
postgres	pg_global	pg_catalog	pg_db_role_setting	3
postgres	pg_global	pg_catalog	pg_replication_origin	3
postgres	pg_global	pg_catalog	pg_subscription	3
etendo	pg_global	pg_catalog	pg_pltemplate	3
etendo	pg_global	pg_catalog	pg_tablespace	3
etendo	pg_global	pg_catalog	pg_shdepend	3		671		671
etendo	pg_global	pg_catalog	pg_auth_members	3
etendo	pg_global	pg_catalog	pg_database	3
etendo	pg_global	pg_catalog	pg_shdescription	3
etendo	pg_global	pg_catalog	pg_db_role_setting	3

Top indexes by estimated vacuum load

DB	Tablespace	Schema	Table	Index	~Vacuum bytes	Autovacuum cnt	IX size	Relsize
etendo	pg_default	profile	last_stat_indexes	pk_last_stat_indexes	12 MB	29	413 kB	1542 kB
etendo	pg_default	profile	last_stat_tables	pk_last_stat_tables	6040 kB	29	206 kB	1178 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	1152 kB	1	1152 kB	4112 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	752 kB	1	752 kB	4112 kB
etendo	pg_default	pg_catalog	pg_statistic	pg_statistic_relid_att_inh_index	432 kB	2	216 kB	2820 kB
etendo	pg_default	pg_catalog	pg_type	pg_type_typname_nsp_index	184 kB	1	184 kB	488 kB
etendo	pg_default	pg_catalog	pg_class	pg_class_relname_nsp_index	184 kB	1	184 kB	680 kB
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	pg_toast_2619_index	152 kB	3	52 kB	2100 kB
postgres	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	144 kB	1	144 kB	408 kB
etendo	pg_default	pg_catalog	pg_class	pg_class_oid_index	104 kB	1	104 kB	680 kB
etendo	pg_default	pg_catalog	pg_class	pg_class_tblspc_relfilenode_index	104 kB	1	104 kB	680 kB
postgres	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	96 kB	1	96 kB	408 kB
etendo	pg_default	pg_catalog	pg_type	pg_type_oid_index	88 kB	1	88 kB	488 kB
etendo	pg_default	pg_catalog	pg_index	pg_index_indrelid_index	72 kB	1	72 kB	464 kB
etendo	pg_default	pg_catalog	pg_index	pg_index_indexrelid_index	72 kB	1	72 kB	464 kB
postgres	pg_default	pg_catalog	pg_type	pg_type_typname_nsp_index	40 kB	1	40 kB	104 kB
postgres	pg_default	pg_catalog	pg_statistic	pg_statistic_relid_att_inh_index	40 kB	1	40 kB	248 kB
postgres	pg_default	pg_catalog	pg_type	pg_type_oid_index	32 kB	1	32 kB	104 kB
postgres	pg_default	pg_catalog	pg_class	pg_class_relname_nsp_index	32 kB	1	32 kB	104 kB
postgres	pg_default	pg_catalog	pg_class	pg_class_oid_index	16 kB	1	16 kB	104 kB

Top tables by dead tuples ratio

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

DB	Schema	Table	Live	Dead	%Dead	Last AV	Size
etendo	public	ad_process_request	4730	8	0		5432 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.

DB	Schema	Table	Live	Dead	Mod	%Mod	Last AA	Size
etendo	public	ad_process_request	4730	8	20	0	2026-05-12 12:12:32.032373+02	5432 kB

Cluster settings during the report interval

Defined settings
Setting	reset_val	Unit	Source	Notes
checkpoint_completion_target	0.9		/etc/postgresql/10/main/postgresql.conf:211
client_encoding	UTF8
cluster_name	10/main		/etc/postgresql/10/main/postgresql.conf:477
config_file	/etc/postgresql/10/main/postgresql.conf
data_checksums	on
data_directory	/var/lib/postgresql/10/main
DateStyle	ISO, DMY		/etc/postgresql/10/main/postgresql.conf:566
default_text_search_config	pg_catalog.spanish		/etc/postgresql/10/main/postgresql.conf:588
effective_cache_size	786432	8kB	/etc/postgresql/10/main/postgresql.conf:315
effective_io_concurrency	200		/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_collate	es_ES.UTF-8
lc_ctype	es_ES.UTF-8
lc_messages	en_US.UTF-8		/etc/postgresql/10/main/conf.d/15-pgbadger.conf:11
lc_monetary	es_ES.UTF-8		/etc/postgresql/10/main/postgresql.conf:583
lc_numeric	en_US.UTF-8		/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:38
lc_time	es_ES.UTF-8		/etc/postgresql/10/main/postgresql.conf:585
log_autovacuum_min_duration	0	ms	/etc/postgresql/10/main/conf.d/15-pgbadger.conf:9
log_checkpoints	on		/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:26
log_connections	on		/etc/postgresql/10/main/conf.d/15-pgbadger.conf:1
log_disconnections	on		/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_waits	on		/etc/postgresql/10/main/conf.d/15-pgbadger.conf:5
log_min_duration_statement	1000	ms	/etc/postgresql/10/main/conf.d/15-pgbadger.conf:10
log_temp_files	0	kB	/etc/postgresql/10/main/conf.d/15-pgbadger.conf:7
log_timezone	localtime		/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:22
maintenance_work_mem	524288	kB	/etc/postgresql/10/main/postgresql.conf:123
max_locks_per_transaction	128		/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:17
max_stack_depth	2048	kB
max_wal_size	4096	MB	/etc/postgresql/10/main/postgresql.conf:209
min_wal_size	1024	MB	/etc/postgresql/10/main/postgresql.conf:210
pg_conf_load_time	2026-07-13 02:00:03.757252+02
pg_conf_load_time	2026-07-14 02:00:04.136929+02			2026-07-14 03:00:02+02
pg_postmaster_start_time	2026-07-13 02:00:03.861944+02
pg_postmaster_start_time	2026-07-14 02:00:04.238903+02			2026-07-14 03:00:02+02
pg_stat_statements.max	10000		/etc/postgresql/10/main/postgresql.conf:660
pg_stat_statements.track	all		/etc/postgresql/10/main/postgresql.conf:661
random_page_cost	1.1		/etc/postgresql/10/main/postgresql.conf:307
server_encoding	UTF8
shared_buffers	262144	8kB	/etc/postgresql/10/main/postgresql.conf:113
shared_preload_libraries	$libdir/pg_stat_statements		/etc/postgresql/10/main/postgresql.conf:659
ssl	on		/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
TimeZone	localtime		/etc/postgresql/10/main/conf.d/01-openbravo-standard-postgres10.conf:23
timezone_abbreviations	Default
track_functions	all		/etc/postgresql/10/main/conf.d/15-pgbadger.conf:8
version	PostgreSQL 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_buffers	2048	8kB	/etc/postgresql/10/main/postgresql.conf:198
work_mem	5242	kB	/etc/postgresql/10/main/postgresql.conf:122
Default settings
Setting	reset_val	Unit	Source	Notes
allow_in_place_tablespaces	off
allow_system_table_mods	off
application_name
archive_command
archive_mode	off
archive_timeout	0	s
array_nulls	on
authentication_timeout	60	s
autovacuum	on
autovacuum_analyze_scale_factor	0.1
autovacuum_analyze_threshold	50
autovacuum_freeze_max_age	200000000
autovacuum_max_workers	3
autovacuum_multixact_freeze_max_age	400000000
autovacuum_naptime	60	s
autovacuum_vacuum_cost_delay	20	ms
autovacuum_vacuum_cost_limit	-1
autovacuum_vacuum_scale_factor	0.2
autovacuum_vacuum_threshold	50
autovacuum_work_mem	-1	kB
backend_flush_after	0	8kB
backslash_quote	safe_encoding
bgwriter_delay	200	ms
bgwriter_flush_after	64	8kB
bgwriter_lru_maxpages	100
bgwriter_lru_multiplier	2
block_size	8192
bonjour	off
bonjour_name
bytea_output	hex
check_function_bodies	on
checkpoint_flush_after	32	8kB
checkpoint_timeout	300	s
checkpoint_warning	30	s
client_min_messages	notice
commit_delay	0
commit_siblings	5
constraint_exclusion	partition
cpu_index_tuple_cost	0.005
cpu_operator_cost	0.0025
cpu_tuple_cost	0.01
cursor_tuple_fraction	0.1
data_sync_retry	off
db_user_namespace	off
deadlock_timeout	1000	ms
debug_assertions	off
debug_pretty_print	on
debug_print_parse	off
debug_print_plan	off
debug_print_rewritten	off
default_statistics_target	100		/etc/postgresql/10/main/postgresql.conf:329
default_tablespace
default_transaction_deferrable	off
default_transaction_isolation	read committed
default_transaction_read_only	off
default_with_oids	off
dynamic_library_path	$libdir
dynamic_shared_memory_type	posix		/etc/postgresql/10/main/postgresql.conf:127
enable_bitmapscan	on
enable_gathermerge	on
enable_hashagg	on
enable_hashjoin	on
enable_indexonlyscan	on
enable_indexscan	on
enable_material	on
enable_mergejoin	on
enable_nestloop	on
enable_seqscan	on
enable_sort	on
enable_tidscan	on
escape_string_warning	on
event_source	PostgreSQL
exit_on_error	off
extra_float_digits	0
force_parallel_mode	off
from_collapse_limit	8
fsync	on
full_page_writes	on
geqo	on
geqo_effort	5
geqo_generations	0
geqo_pool_size	0
geqo_seed	0
geqo_selection_bias	2
geqo_threshold	12
gin_fuzzy_search_limit	0
gin_pending_list_limit	4096	kB
hot_standby	on
hot_standby_feedback	off
huge_pages	try
idle_in_transaction_session_timeout	0	ms
ignore_checksum_failure	off
ignore_system_indexes	off
integer_datetimes	on
IntervalStyle	postgres
join_collapse_limit	8
krb_caseins_users	off
krb_server_keyfile	FILE:/etc/postgresql-common/krb5.keytab
listen_addresses	localhost
local_preload_libraries
lock_timeout	0	ms
lo_compat_privileges	off
log_destination	stderr
log_directory	log
log_duration	off		/etc/postgresql/10/main/conf.d/15-pgbadger.conf:3
log_error_verbosity	default
log_executor_stats	off
log_file_mode	384
log_filename	postgresql-%Y-%m-%d_%H%M%S.log
logging_collector	off
log_hostname	off
log_min_error_statement	error
log_min_messages	warning
log_parser_stats	off
log_planner_stats	off
log_replication_commands	off
log_rotation_age	1440	min
log_rotation_size	10240	kB
log_statement	none		/etc/postgresql/10/main/conf.d/15-pgbadger.conf:6
log_statement_stats	off
log_truncate_on_rotation	off
max_connections	100		/etc/postgresql/10/main/postgresql.conf:64
max_files_per_process	1000
max_function_args	100
max_identifier_length	63
max_index_keys	32
max_logical_replication_workers	4
max_parallel_workers	8
max_parallel_workers_per_gather	2
max_pred_locks_per_page	2
max_pred_locks_per_relation	-2
max_pred_locks_per_transaction	64
max_prepared_transactions	0
max_replication_slots	10
max_standby_archive_delay	30000	ms
max_standby_streaming_delay	30000	ms
max_sync_workers_per_subscription	2
max_wal_senders	10
max_worker_processes	8
min_parallel_index_scan_size	64	8kB
min_parallel_table_scan_size	1024	8kB
old_snapshot_threshold	-1	min
operator_precedence_warning	off
parallel_setup_cost	1000
parallel_tuple_cost	0.1
password_encryption	md5
pg_profile.topn	20
pg_stat_statements.save	on
pg_stat_statements.track_utility	on
port	5432		/etc/postgresql/10/main/postgresql.conf:63
post_auth_delay	0	s
pre_auth_delay	0	s
quote_all_identifiers	off
replacement_sort_tuples	150000
restart_after_crash	on
row_security	on
search_path	"$user", public
segment_size	131072	8kB
seq_page_cost	1
server_version	10.23 (Ubuntu 10.23-0ubuntu0.18.04.2)
server_version_num	100023
session_preload_libraries
session_replication_role	origin
ssl_ca_file
ssl_ciphers	HIGH:MEDIUM:+3DES:!aNULL
ssl_crl_file
ssl_dh_params_file
ssl_ecdh_curve	prime256v1
ssl_prefer_server_ciphers	on
standard_conforming_strings	on
statement_timeout	0	ms
superuser_reserved_connections	3
synchronize_seqscans	on
synchronous_commit	on
synchronous_standby_names
syslog_facility	local0
syslog_ident	postgres
syslog_sequence_numbers	on
syslog_split_messages	on
system_identifier	6876315319645054122
tcp_keepalives_count	0
tcp_keepalives_idle	0	s
tcp_keepalives_interval	0	s
temp_buffers	1024	8kB
temp_file_limit	-1	kB
temp_tablespaces
trace_notify	off
trace_recovery_messages	log
trace_sort	off
track_activities	on
track_activity_query_size	1024
track_commit_timestamp	off
track_counts	on
track_io_timing	off
transaction_deferrable	off
transaction_isolation	default
transaction_read_only	off
transform_null_equals	off
unix_socket_directories	/var/run/postgresql		/etc/postgresql/10/main/postgresql.conf:66
unix_socket_group
unix_socket_permissions	511
update_process_title	on
vacuum_cost_delay	0	ms
vacuum_cost_limit	200
vacuum_cost_page_dirty	20
vacuum_cost_page_hit	1
vacuum_cost_page_miss	10
vacuum_defer_cleanup_age	0
vacuum_freeze_min_age	50000000
vacuum_freeze_table_age	150000000
vacuum_multixact_freeze_min_age	5000000
vacuum_multixact_freeze_table_age	150000000
wal_block_size	8192
wal_compression	off
wal_consistency_checking
wal_keep_segments	0
wal_level	replica
wal_log_hints	off
wal_receiver_status_interval	10	s
wal_receiver_timeout	60000	ms
wal_retrieve_retry_interval	5000	ms
wal_segment_size	2048	8kB
wal_sender_timeout	60000	ms
wal_sync_method	fdatasync
wal_writer_delay	200	ms
wal_writer_flush_after	128	8kB
xmlbinary	base64
xmloption	content
zero_damaged_pages	off