Postgres profile report (StartID: 570, EndID: 593)

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
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	209047	27		99.66	509247	148984670	338097002	25264267	673456	323809	432963			2863 MB	5992 kB
postgres	11867			99.84	1162	703242	1985219	365428	2012	866	1772			6359 kB	-72 kB
Total	220914	27		99.66	510409	149687912	340082221	25629695	675468	324675	434735			2869 MB	5920 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	6091687	641.12			42.96	84638325	74094829	208690	2420			2435		15416
postgres	5619	12.67				127322		230						349
template1	6344	8.92				47817		229						278
Total	6103650	662.71			42.96	84813464	74094829	209149	2420			2435		16043

Cluster statistics

Metric	Value
Scheduled checkpoints	275
Requested checkpoints	1
Checkpoint write time (s)	9682.48
Checkpoint sync time (s)	2.46
Checkpoints buffers written	121941
Background buffers written
Backend buffers written	143146
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated	504551
WAL generated	3742 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

Tablespace	Path	Size	Growth
pg_default		2883 MB	5920 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
adb1c31f79 [948be82f]	etendo	141.59	21.36		141587.437	141587.437	141587.437		1
73e3636bec [f410d7e7]	etendo	74.04	11.17	288169	0.257	0.132	9.623	0.091	288169
4108c96b3f [ca2988bd]	etendo	62.43	9.42	653	867.128	141.628	1132.650	103.697	72
2b98e8b0ee [3e7c63ef]	etendo	34.95	5.27	100840	0.347	0.007	5.079	0.175	100840
228d74fbf5 [cd9c0fd2]	etendo	33.35	5.03	13499	33352.279	33352.279	33352.279		1
0c133f89fa [47df1ade]	etendo	16.86	2.54	23	732.985	671.450	1013.957	77.123	23
b9bb8a4422 [eb812a48]	etendo	16.85	2.54		732.773	671.267	1013.761	77.129	23
43ccd38b48 [359b313d]	etendo	14.64	2.21	5701	16.654	10.486	31.357	2.670	879
2cbac7b1a6 [f56befd3]	etendo	13.30	2.01	50517	0.263	0.007	2.105	0.140	50517
1d911b5cd9 [1c4d8fed]	etendo	11.58	1.75	2874	4.030	1.773	12.623	1.428	2874
44dc303aa7 [5048ce93]	etendo	11.23	1.69	8839	1.085	0.985	7.166	0.241	10353
e384d56110 [859f236f]	etendo	9.66	1.46	8574	15.941	12.725	41.753	2.479	606
32bad3f686 [acf905dd]	etendo	8.90	1.34	38088	0.234	0.006	2.679	0.129	38088
671fe12038 [66c83919]	etendo	8.48	1.28	1903556	8481.827	8481.827	8481.827		1
c9e2eb425b [de5cc8a]	etendo	7.01	1.06	1852284	0.002	0.002	1.864	0.002	2836414
75cdc9279a [c0534667]	etendo	6.47	0.98	5	1293.718	1285.296	1307.227	8.639	5
503324b603 [d34207c3]	etendo	6.23	0.94	253552	0.022	0.005	2.006	0.012	289222
9166c19b70 [2d9f0a32]	etendo	5.23	0.79	12600	0.415	0.109	2.884	0.142	12600
0b651ca53d [7318d810]	etendo	5.21	0.79	674469	5206.980	5206.980	5206.980		1
847a368de1 [c1b80c7a]	etendo	5.14	0.77	25220	0.204	0.007	1.200	0.114	25220

Top SQL by executions

Query ID	Database	Executions	%Total	Rows	Mean(ms)	Min(ms)	Max(ms)	StdErr(ms)	Elapsed(s)
c9e2eb425b [de5cc8a]	etendo	2836414	46.47	1852284	0.002	0.002	1.864	0.002	7.0
9625146448 [b7edb1a4]	etendo	289530	4.74	289530	0.010	0.007	1.188	0.005	2.9
0c13a0abe2 [4ed26d58]	etendo	289268	4.74	31210	0.011	0.006	0.543	0.005	3.1
503324b603 [d34207c3]	etendo	289222	4.74	253552	0.022	0.005	2.006	0.012	6.2
73e3636bec [f410d7e7]	etendo	288169	4.72	288169	0.257	0.132	9.623	0.091	74.0
9ea37f4950 [39cec726]	etendo	256407	4.20	256407	0.009	0.007	1.213	0.005	2.4
df99961951 [9cb9259b]	etendo	162886	2.67	162886	0.018	0.012	1.617	0.008	2.9
1b3d7b3f6d [a00bdbff]	etendo	146058	2.39		0.007	0.004	0.748	0.004	1.0
8c36a5bf11 [f560cf4b]	etendo	100918	1.65	100918	0.005	0.002	0.635	0.005	0.5
891e82e5c1 [5a0bb3c]	etendo	100902	1.65	100902	0.003	0.002	0.306	0.002	0.3
2b98e8b0ee [3e7c63ef]	etendo	100840	1.65	100840	0.347	0.007	5.079	0.175	35.0
5c208ba241 [381eb299]	etendo	53622	0.88	53622	0.014	0.010	2.029	0.010	0.8
e7485b12e8 [6b33f9cf]	etendo	50610	0.83	50610	0.005	0.003	0.657	0.005	0.2
2cbac7b1a6 [f56befd3]	etendo	50517	0.83	50517	0.263	0.007	2.105	0.140	13.3
fa1b74d06f [c1b84187]	etendo	49312	0.81	359375	0.041	0.014	1.952	0.041	2.0
ebd66f2e50 [2f2197e3]	etendo	47168	0.77	29414	0.014	0.006	0.323	0.009	0.6
ffadc5ac47 [25ee072c]	etendo	38546	0.63	38539	0.020	0.008	0.185	0.008	0.8
5e81d39fe4 [7890bc51]	etendo	38149	0.63	38149	0.005	0.002	0.387	0.005	0.2
32bad3f686 [acf905dd]	etendo	38088	0.62	38088	0.234	0.006	2.679	0.129	8.9
d7389ab8e1 [af192082]	etendo	28423	0.47	28423	0.002	0.002	0.030	0.001	0.1

Top SQL by shared blocks fetched

Query ID	Database	blks fetched	%Total	Hits(%)	Elapsed(s)	Rows	Executions
4108c96b3f [ca2988bd]	etendo	14783890	17.43	100.00	62.4	653	72
73e3636bec [f410d7e7]	etendo	9557338	11.27	99.97	74.0	288169	288169
0c133f89fa [47df1ade]	etendo	5017285	5.92	99.98	16.9	23	23
b9bb8a4422 [eb812a48]	etendo	5017147	5.92	99.98	16.9		23
44dc303aa7 [5048ce93]	etendo	3472281	4.09	100.00	11.2	8839	10353
e384d56110 [859f236f]	etendo	3285832	3.87	100.00	9.7	8574	606
adb1c31f79 [948be82f]	etendo	3043012	3.59	84.23	141.6		1
c9e2eb425b [de5cc8a]	etendo	2836414	3.34	100.00	7.0	1852284	2836414
75cdc9279a [c0534667]	etendo	2462551	2.90	100.00	6.5	5	5
58d3d7b94c [303fdc1e]	etendo	2402089	2.83	100.00	1.3	2510	23
3a735c6f6a [e9eb49bd]	etendo	2241628	2.64	100.00	3.4	281	95
29e9be51ce [b8952a6a]	etendo	2059025	2.43	100.00	3.2	10650	1775
43ccd38b48 [359b313d]	etendo	1807172	2.13	100.00	14.6	5701	879
785a907bc3 [92946197]	etendo	1637876	1.93	99.97	4.7	870	23
5fa24dc926 [22217272]	etendo	1618119	1.91	100.00	2.1	51037	23
c2b6cfc2bf [ad3afc69]	etendo	1494789	1.76	100.00	4.7	1070496	2941
9c83facac5 [411377d4]	etendo	978549	1.15	100.00	2.9	10353	8167
9625146448 [b7edb1a4]	etendo	907896	1.07	100.00	2.9	289530	289530
0c13a0abe2 [4ed26d58]	etendo	906492	1.07	100.00	3.1	31210	289268
7c49e0fca3 [37eecc4]	etendo	834048	0.98	100.00	4.8	2	554

Query ID	Database	Reads	%Total	Hits(%)	Elapsed(s)	Rows	Executions
adb1c31f79 [948be82f]	etendo	480029	94.04	84.23	141.6		1
f8cc1c12b0 [4f2bfd2e]	etendo	3238	0.63	99.36	1.6	21	10
73e3636bec [f410d7e7]	etendo	2477	0.49	99.97	74.0	288169	288169
9cbca4d83c [b7b6a128]	etendo	1915	0.38	88.58	0.2	1822	1822
50b8978166 [b54ea3e2]	etendo	1620	0.32	97.59	0.4		10
1e43f28979 [c3f6c9c8]	etendo	1316	0.26	91.28	0.4	10	10
12a81791af [7eea2aca]	etendo	1188	0.23	90.58	0.0	1322	1322
0c247acdf0 [948be82f]	template1	971	0.19	97.61	2.7		1
2e0b729b87 [948be82f]	postgres	948	0.19	97.65	2.7		1
0c133f89fa [47df1ade]	etendo	932	0.18	99.98	16.9	23	23
b9bb8a4422 [eb812a48]	etendo	932	0.18	99.98	16.9		23
b8b9950890 [532de794]	etendo	774	0.15	98.90	0.9	2524	2524
de891c1f5b [a3acbb25]	etendo	579	0.11	88.04	0.0		4
93accebb93 [bdc0f458]	etendo	557	0.11	98.63	0.1	2997	2
6951a2f5d4 [43f0ca83]	etendo	528	0.10	86.27	0.0	205	205
cbb0d2e65e [4ec9dd54]	etendo	505	0.10	92.66	0.1	8	8
785a907bc3 [92946197]	etendo	497	0.10	99.97	4.7	870	23
ebf986aa9f [95980309]	etendo	388	0.08	99.60	0.1	250	11
9425961593 [7e6ec72b]	etendo	303	0.06	99.65	0.4	28102	21302
0c9140d9a9 [cccacad4]	etendo	288	0.06	88.53	0.0	274	274

Top SQL by shared blocks dirtied

Query ID	Database	Dirtied	%Total	Hits(%)	Elapsed(s)	Rows	Executions
73e3636bec [f410d7e7]	etendo	72838	34.83	99.97	74.0	288169	288169
adb1c31f79 [948be82f]	etendo	62585	29.92	84.23	141.6		1
0c133f89fa [47df1ade]	etendo	15888	7.60	99.98	16.9	23	23
b9bb8a4422 [eb812a48]	etendo	15888	7.60	99.98	16.9		23
fdd1193fad [3b0e4e8a]	etendo	4199	2.01	99.96	3.6	54119	46
b8b9950890 [532de794]	etendo	3456	1.65	98.90	0.9	2524	2524
d0b36135c7 [a0544a5f]	etendo	3206	1.53	99.97	3.7	32890	46
9cbca4d83c [b7b6a128]	etendo	2077	0.99	88.58	0.2	1822	1822
140f3eb685 [59d1e156]	etendo	1836	0.88	99.55	0.9	23	23
c525c04235 [d2f1c69a]	etendo	1561	0.75	99.33	0.1	307	307
1e43f28979 [c3f6c9c8]	etendo	1409	0.67	91.28	0.4	10	10
9b16673e73 [423e83ff]	etendo	1284	0.61	98.92	0.1		1
f68dd8a1a9 [d422fd3a]	etendo	981	0.47	100.00	0.6		42
4813705ddb [6f2d0383]	etendo	815	0.39	99.99	0.3	1338	1338
174962df65 [f75cc0f0]	etendo	672	0.32	96.74	0.1	297	297
6a18f0bfd3 [b26b8c5c]	etendo	655	0.31	98.68	0.1	761	761
cbb0d2e65e [4ec9dd54]	etendo	538	0.26	92.66	0.1	8	8
167f11efcd [76ede534]	etendo	496	0.24	99.55	0.1		1
bda4372001 [a3318de1]	etendo	432	0.21	99.88	0.1	2539	17
65758f3c61 [2616291e]	etendo	395	0.19	99.99	0.3	5744	32

Top SQL by shared blocks written

Query ID	Database	Written	%Total	%BackendW	Hits(%)	Elapsed(s)	Executions
adb1c31f79 [948be82f]	etendo	58442	22.05	40.83	84.23	141.6	1
0c247acdf0 [948be82f]	template1	55	0.02	0.04	97.61	2.7	1
2e0b729b87 [948be82f]	postgres	55	0.02	0.04	97.65	2.7	1

Query ID

Database

Written

%Total

%BackendW

Hits(%)

Elapsed(s)

Rows

Executions

adb1c31f79

[948be82f]

etendo

58442

22.05

40.83

84.23

141.6

0c247acdf0

[948be82f]

template1

0.02

0.04

97.61

2.7

2e0b729b87

[948be82f]

postgres

0.02

0.04

97.65

2.7

Top SQL by temp usage

Query ID	Database	Local fetched	Hits(%)	Local (blk)				Temp (blk)				Elapsed(s)	Rows	Executions
Query ID	Database	Local fetched	Hits(%)	Write	%Total	Read	%Total	Write	%Total	Read	%Total	Elapsed(s)	Rows	Executions
8c36a5bf11 [f560cf4b]	etendo	103414	99.19			835	34.29					0.5	100918	100918
e7485b12e8 [6b33f9cf]	etendo	51864	99.19			421	17.29					0.2	50610	50610
5e81d39fe4 [7890bc51]	etendo	39091	99.19			317	13.02					0.2	38149	38149
1624b38914 [25022289]	etendo	26114	99.18			213	8.75					0.1	25484	25484
c1deedb9c8 [c6131ffe]	etendo	25835	99.18			211	8.67					0.1	25211	25211
b039ad7443 [3f5ba964]	etendo	12925	99.17			107	4.39					0.1	12613	12613
0b66826a19 [6f637536]	etendo	12912	99.17			107	4.39					0.1	12600	12600
b561df93c5 [a08400ce]	etendo	13013	99.18			107	4.39					0.1	12701	12701
cb01d0ae5c [3dd6e0f1]	etendo	12912	99.19			104	4.27					0.1	12600	12600
da21d1cd03 [9e227079]	etendo	240	98.33			4	0.16					0.0	237	237
9824754258 [ea37d44a]	etendo	278	98.56			4	0.16					0.0	275	275
fadc79e0e0 [55ff48e0]	etendo	27	96.30			1	0.04					0.0	27	27
d20baf16f4 [bd689f61]	etendo	41	97.56			1	0.04					0.0	41	41
18a7378ff7 [c7fedf86]	etendo	28	96.43			1	0.04					0.0	28	28
c42a2e4205 [ca0829e7]	etendo	23	95.65			1	0.04					0.0	23	23
a4410aa255 [d2721eaa]	etendo	24	95.83			1	0.04					0.0	24	24

Complete list of SQL texts

QueryID	Query Text
7c49e0fca3	select 1 as id from dual where exists ( select 1 from ( SELECT a.DateAcct as dateacct FROM M_InOut a WHERE a.ad_client_id = $1 AND a.ad_org_id in ('0', '1000003', 'E5C644C994CA4E6DB384AF0325704F1E', '1000002') AND a.posted = 'N' AND a.processed = 'Y' AND (a.processing = 'N' OR a.processing IS NULL) AND EXISTS ( SELECT 1 FROM c_period p WHERE a.DateAcct >= p.StartDate AND a.DateAcct < p.EndDate + 1 AND EXISTS ( SELECT 1 FROM c_periodcontrol pc WHERE pc.c_period_id = p.c_period_id AND ad_org_getperiodcontrolallow(a.ad_org_id) = pc.ad_org_id AND pc.docbasetype = $2 AND pc.periodstatus = 'O' ) )) b where 1=1 )
891e82e5c1	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
c9e2eb425b	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
1d911b5cd9	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
5fa24dc926	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)
1624b38914	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
ffadc5ac47	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
65758f3c61	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 )
9166c19b70	delete from ad_context_info
ebd66f2e50	select financialm0_.C_Settlement_Generate_ID as C_Settl11_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Settlement_Generate_ID=$1
58d3d7b94c	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)
43ccd38b48	select advcrm_act0_.Advcrm_Activity_ID as Advcrm_A1_140_, advcrm_act0_.AD_Client_ID as AD_Clien2_140_, advcrm_act0_.AD_Org_ID as AD_Org_I3_140_, advcrm_act0_.Created as Created4_140_, advcrm_act0_.Createdby as Createdb5_140_, advcrm_act0_.Updated as Updated6_140_, advcrm_act0_.Updatedby as Updatedb7_140_, advcrm_act0_.Isactive as Isactive8_140_, advcrm_act0_.Type_Activity as Type_Act9_140_, advcrm_act0_.Name as Name10_140_, advcrm_act0_.Description as Descrip11_140_, advcrm_act0_.Date_Start as Date_St12_140_, advcrm_act0_.Date_End as Date_En13_140_, advcrm_act0_.Status as Status14_140_, advcrm_act0_.C_Location_ID as C_Locat15_140_, advcrm_act0_.AD_User_ID as AD_User16_140_, advcrm_act0_.Duration_Hours as Duratio17_140_, advcrm_act0_.Duration_Minutes as Duratio18_140_, advcrm_act0_.Advcrm_Activity_Parent_ID as Advcrm_19_140_, advcrm_act0_.Email_Reminder_Sent as Email_R20_140_, advcrm_act0_.External_Activity_ID as Externa21_140_, advcrm_act0_.Direction_Call as Directi22_140_, advcrm_act0_.Visibility as Visibil23_140_, advcrm_act0_.Priority as Priorit24_140_, advcrm_act0_.Auxiliary as Auxilia25_140_, advcrm_act0_.Reminder_Time as Reminde26_140_, advcrm_act0_.Email_Reminder_Time as Email_R27_140_, advcrm_act0_.Date_Closed as Date_Cl28_140_, advcrm_act0_.Isallday as Isallda29_140_, advcrm_act0_.Istemplate as Istempl30_140_, advcrm_act0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc31_140_, advcrm_act0_.EM_Psat_Activity_Category_ID as EM_Psat32_140_, advcrm_act0_.EM_Psat_Request_Template_ID as EM_Psat33_140_, advcrm_act0_.EM_Advcrm1_Stack_Pl_Act_Li_ID as EM_Advc34_140_, advcrm_act0_.EM_Psat_Request_ID as EM_Psat35_140_, advcrm_act0_.EM_Advcrm1_Newso as EM_Advc36_140_, advcrm_act0_.EM_Psat_Add_Consumption as EM_Psat37_140_, advcrm_act0_.EM_Psat_Lineno as EM_Psat38_140_, advcrm_act0_.em_psat_create_order as em_psat39_140_, advcrm_act0_.EM_Psat_Addmaterials as EM_Psat40_140_, advcrm_act0_.EM_Psat_Checklist_ID as EM_Psat41_140_, advcrm_act0_.EM_Psat_Sign as EM_Psat42_140_, advcrm_act0_.EM_Psat_Namesign as EM_Psat43_140_, advcrm_act0_.EM_Psat_Observations as EM_Psat44_140_, advcrm_act0_.EM_Psat_Activity_Planned_ID as EM_Psat45_140_, advcrm_act0_.EM_Psat_Invoicerule as EM_Psat46_140_, advcrm_act0_.EM_Psat_Activity_Num as EM_Psat47_140_, advcrm_act0_.EM_Psat_Finish_Activity as EM_Psat48_140_, advcrm_act0_.Advcrm_Group_ID as Advcrm_49_140_, advcrm_act0_.EM_Psat_Date_Complete as EM_Psat50_140_, advcrm_act0_.EM_Psat_Complete_User_ID as EM_Psat51_140_ from advcrm_activity advcrm_act0_ where advcrm_act0_.EM_Psat_Request_ID=$1 and (advcrm_act0_.AD_Org_ID in ($2 , $3 , $4 , $5)) and (advcrm_act0_.AD_Client_ID in ($6 , $7)) order by advcrm_act0_.Date_Start desc, advcrm_act0_.Advcrm_Activity_ID desc limit $8
5c208ba241	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
9ea37f4950	select max(this_.Lastpayment) as y0_ from FIN_Payment_Sched_Inv_V this_ where this_.C_Invoice_ID=$1 and this_.Isactive=$2 limit $3
fdd1193fad	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 )
cb01d0ae5c	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2b98e8b0ee	delete from ad_context_info
b039ad7443	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
9c83facac5	select this_.Psat_Activity_Materials_ID as Psat_Act1_723_0_, this_.AD_Client_ID as AD_Clien2_723_0_, this_.AD_Org_ID as AD_Org_I3_723_0_, this_.Isactive as Isactive4_723_0_, this_.Created as Created5_723_0_, this_.Createdby as Createdb6_723_0_, this_.Updated as Updated7_723_0_, this_.Updatedby as Updatedb8_723_0_, this_.Advcrm_Activity_ID as Advcrm_A9_723_0_, this_.M_Product_ID as M_Produ10_723_0_, this_.Estimatedqty as Estimat11_723_0_, this_.Invoiceable as Invoice12_723_0_, this_.Generaterequisition as Generat13_723_0_, this_.M_Requisition_ID as M_Requi14_723_0_, this_.C_Orderline_ID as C_Order15_723_0_ from psat_activity_materials this_ where this_.Advcrm_Activity_ID=$1 and this_.Isactive=$2
9b16673e73	vacuum analyze AD_Process_Run
6951a2f5d4	SELECT CASE WHEN MIN(a.suma) = $2 THEN $3 ELSE ROUND(COALESCE(SUM(ABS(inv.qtyinvoiced)), $4)/MIN(a.suma) * $5, $6) END FROM m_inoutline minline JOIN c_invoiceline inv on minline.m_inoutline_id=inv.m_inoutline_id, (SELECT COALESCE(SUM(ABS(g.movementqty)), $7) AS suma FROM m_inoutline g WHERE g.m_inout_id =p_minoutid ) a WHERE minline.m_inout_id=p_minoutid AND EXISTS (SELECT $8 FROM c_invoice i WHERE i.c_invoice_id = inv.c_invoice_id AND i.processed = $9 AND i.docstatus <> $10 AND i.docstatus <> $11 AND i.docstatus <> $12)
0c133f89fa	SELECT profile.take_sample()
cbb0d2e65e	insert into advcrm_activity (AD_Client_ID, AD_Org_ID, Created, Createdby, Updated, Updatedby, Isactive, Type_Activity, Name, Date_Start, Date_End, Status, AD_User_ID, Duration_Hours, Direction_Call, Visibility, Priority, Isallday, Istemplate, EM_Psat_Activity_Category_ID, EM_Psat_Request_ID, EM_Advcrm1_Newso, EM_Psat_Add_Consumption, EM_Psat_Lineno, em_psat_create_order, EM_Psat_Addmaterials, EM_Psat_Checklist_ID, EM_Psat_Invoicerule, EM_Psat_Finish_Activity, Advcrm_Activity_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30)
0c13a0abe2	select finpayment0_.C_Invoice_ID as C_Invoic8_373_1_, finpayment0_.Fin_Payment_Schedule_ID as Fin_Paym1_373_1_, finpayment0_.Fin_Payment_Schedule_ID as Fin_Paym1_373_0_, finpayment0_.AD_Client_ID as AD_Clien2_373_0_, finpayment0_.AD_Org_ID as AD_Org_I3_373_0_, finpayment0_.Created as Created4_373_0_, finpayment0_.Createdby as Createdb5_373_0_, finpayment0_.Updated as Updated6_373_0_, finpayment0_.Updatedby as Updatedb7_373_0_, finpayment0_.C_Invoice_ID as C_Invoic8_373_0_, finpayment0_.C_Order_ID as C_Order_9_373_0_, finpayment0_.Duedate as Duedate10_373_0_, finpayment0_.Fin_Paymentmethod_ID as Fin_Pay11_373_0_, finpayment0_.C_Currency_ID as C_Curre12_373_0_, finpayment0_.Amount as Amount13_373_0_, finpayment0_.Paidamt as Paidamt14_373_0_, finpayment0_.Outstandingamt as Outstan15_373_0_, finpayment0_.Isactive as Isactiv16_373_0_, finpayment0_.FIN_Payment_Priority_ID as FIN_Pay17_373_0_, finpayment0_.Update_Payment_Plan as Update_18_373_0_, finpayment0_.OrigDueDate as OrigDue19_373_0_, finpayment0_.Description as Descrip20_373_0_, finpayment0_.EM_Aprm_Modif_Paym_Sched as EM_Aprm21_373_0_, finpayment0_.EM_Aprm_Modif_Paym_Out_Sched as EM_Aprm22_373_0_, finpayment0_.ExpectedDate as Expecte23_373_0_ from FIN_Payment_Schedule finpayment0_ where finpayment0_.C_Invoice_ID=$1
f8cc1c12b0	select --REQUEST psat_request.description as reqdesc, psat_request.requestdate, --ACTIVITY coalesce(advcrm_activity.em_psat_activity_num,psat_request.documentno) as documentno, advcrm_activity.type_activity, advcrm_activity.name as actname, advcrm_activity.description as actdesc, advcrm_activity.date_start, advcrm_activity.date_end, advcrm_activity.em_psat_namesign as namesign, advcrm_activity.em_psat_sign as actsign, -- case when chresseconduser.result is not null and chresseconduser.result <> $1 then activityuser.name \|\| $2 \|\| (select pcv."name" from psat_checklist_value pcv where pcv.psat_check_type_id = chresseconduser.psat_check_type_id and pcv.value = chresseconduser.result limit $3 ) else activityuser.name end as usernameact, -- advcrm_activity.em_psat_observations as actobservations, chresmachinetime.result as timemachine, chresworktime.result as worktime, coalesce(chresworkdone.result,chresworkdone.description) as logactivity, coalesce(chresmovementtime.result,$4) as timemovement, coalesce(chreskms.result,$5) as kms, coalesce(chreshrsguard.result,$6) as hoursGuard, --ORG ad_org.ad_org_id, --BPARTNER c_bpartner.value as valuepartner, upper(c_bpartner.name) as namepartner, upper(c_bpartner.name2) as name2partner, contactuser.name as contactname, contactuser.email as contactmail, contactuser.phone as contactphone, --ADDRESSREQUEST c_location.address1 as address1, c_location.address2 as address2, c_location.postal as bppostal, c_location.city as bpcity, c_location_description(c_location.c_location_id) \|\| $7\|\| upper(coalesce(c_country_trl.name, c_country.name)) \|\| $8 AS locationdesc, --PRODUCT m_product.name as prodreqname, coalesce(m_attributesetinstance.description, psat_request.additional_info) as attributedesc, --CONSUMPTION coalesce(psat_related_products.em_cus_specific_id,prodconsum.value) as prodconsumvalue, coalesce(em_cus_specific_name,prodconsum.name) as prodconsumname, coalesce(cus_specific_mats_price.pricelist, psat_activity_consumption.priceactual) as consumpriceprod, coalesce(psat_activity_consumption.qty,$9) as consumitionQty, (select count($10) from advcrm_activity ac left join psat_activity_consumption pac on ac.advcrm_activity_id = pac.advcrm_activity_id where ac.advcrm_activity_id = advcrm_activity.advcrm_activity_id) as totalConsumitions, ROW_NUMBER() OVER (ORDER BY psat_activity_consumption.psat_activity_consumption_id ) as rownumber from advcrm_activity left join psat_request on advcrm_activity.em_psat_request_id = psat_request.psat_request_id left join psat_activity_consumption on advcrm_activity.advcrm_activity_id = psat_activity_consumption.advcrm_activity_id left join psat_related_products on psat_request.m_product_id=psat_related_products.m_product_id and psat_related_products.m_material_id=psat_activity_consumption.m_product_id left join psat_checklist_result chresmachinetime on advcrm_activity.advcrm_activity_id = chresmachinetime.advcrm_activity_id and chresmachinetime.psat_check_type_id= $11 left join psat_checklist_result chresworktime on advcrm_activity.advcrm_activity_id = chresworktime.advcrm_activity_id and chresworktime.psat_check_type_id= $12 left join psat_checklist_result chresmovementtime on advcrm_activity.advcrm_activity_id = chresmovementtime.advcrm_activity_id and chresmovementtime.psat_check_type_id= $13 left join psat_checklist_result chreskms on advcrm_activity.advcrm_activity_id = chreskms.advcrm_activity_id and chreskms.psat_check_type_id= $14 left join psat_checklist_result chreshrsguard on advcrm_activity.advcrm_activity_id = chreshrsguard.advcrm_activity_id and chreshrsguard.psat_check_type_id= $15 left join psat_checklist_result chresworkdone on advcrm_activity.advcrm_activity_id = chresworkdone.advcrm_activity_id and chresworkdone.psat_check_type_id= $16 left join psat_checklist_result chresseconduser on advcrm_activity.advcrm_activity_id = chresseconduser.advcrm_activity_id and chresseconduser.psat_check_type_id= $17 left join c_bpartner on psat_request.c_bpartner_id=c_bpartner.c_bpartner_id left join cus_specific_mats_price on c_bpartner.c_bpartner_id = cus_specific_mats_price.c_bpartner_id left join c_bpartner_location on psat_request.c_bpartner_location_id=c_bpartner_location.c_bpartner_location_id left join c_location on c_bpartner_location.c_location_id=c_location.c_location_id left join c_region on c_location.c_region_id=c_region.c_region_id left join c_country on c_location.c_country_id=c_country.c_country_id left join c_country_trl on c_country.c_country_id=c_country_trl.c_country_id and c_country_trl.ad_language=$18 left join m_product on psat_request.m_product_id=m_product.m_product_id left join m_attributesetinstance on psat_request.m_attributesetinstance_id=m_attributesetinstance.m_attributesetinstance_id left join m_product prodconsum on psat_activity_consumption.m_product_id = prodconsum.m_product_id left join c_doctype on psat_request.c_doctype_id=c_doctype.c_doctype_id left join ad_user activityuser on advcrm_activity.ad_user_id=activityuser.ad_user_id left join ad_user contactuser on coalesce(psat_request.requestor_id,psat_request.affected_contact_id)=contactuser.ad_user_id left join ad_org on psat_request.ad_org_id=ad_org.ad_org_id left join ad_orginfo on ad_org.ad_org_id=ad_orginfo.ad_org_id left join c_location c_locationorg on ad_orginfo.c_location_id=c_locationorg.c_location_id left join c_region c_regionorg on c_locationorg.c_region_id=c_regionorg.c_region_id where advcrm_activity.advcrm_activity_id in ($19)
44dc303aa7	select this_.Psat_Activity_Consumption_ID as Psat_Act1_722_0_, this_.AD_Client_ID as AD_Clien2_722_0_, this_.AD_Org_ID as AD_Org_I3_722_0_, this_.Isactive as Isactive4_722_0_, this_.Created as Created5_722_0_, this_.Createdby as Createdb6_722_0_, this_.Updated as Updated7_722_0_, this_.Updatedby as Updatedb8_722_0_, this_.Advcrm_Activity_ID as Advcrm_A9_722_0_, this_.M_Product_ID as M_Produ10_722_0_, this_.Qty as Qty11_722_0_, this_.Priceactual as Priceac12_722_0_, this_.M_Attributesetinstance_ID as M_Attri13_722_0_, this_.M_Locator_ID as M_Locat14_722_0_, this_.Psat_Activity_Materials_ID as Psat_Ac15_722_0_, this_.Invoiced as Invoice16_722_0_, this_.isProcessed as isProce17_722_0_, this_.Description as Descrip18_722_0_, this_.M_Inoutline_ID as M_Inout19_722_0_ from psat_activity_consumption this_ where this_.Psat_Activity_Materials_ID=$1 and this_.Isactive=$2
b8b9950890	INSERT INTO ad_session_usage_audit (ad_session_usage_audit_id, ad_client_id, ad_org_id, createdby, updatedby, ad_session_id, object_id, ad_module_id, command, classname, object_type, process_time) VALUES (get_uuid(),$10,$11,$1,$2,$3,$4,$5,$6,$7,$8,to_number($9))
fadc79e0e0	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
140f3eb685	SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)
671fe12038	COPY public.ad_audit_trail (ad_audit_trail_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, ad_table_id, record_id, record_revision, ad_user_id, event_time, processtype, process_id, action, ad_column_id, old_char, new_char, old_nchar, new_nchar, old_number, new_number, old_date, new_date, old_text, new_text) TO stdout
e7485b12e8	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
4813705ddb	update C_Invoice set Updated=$1, DaysTillDue=$2, LastCalculatedOnDate=$3 where C_Invoice_ID=$4
0b66826a19	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
0b651ca53d	COPY public.fact_acct (fact_acct_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_acctschema_id, account_id, datetrx, dateacct, c_period_id, ad_table_id, record_id, line_id, gl_category_id, c_tax_id, m_locator_id, postingtype, c_currency_id, amtsourcedr, amtsourcecr, amtacctdr, amtacctcr, c_uom_id, qty, m_product_id, c_bpartner_id, ad_orgtrx_id, c_locfrom_id, c_locto_id, c_salesregion_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, description, a_asset_id, fact_acct_group_id, seqno, factaccttype, docbasetype, acctvalue, acctdescription, record_id2, c_withholding_id, c_doctype_id, c_costcenter_id, ismodify, datebalanced) TO stdout
167f11efcd	vacuum analyze prsync_entry
5e81d39fe4	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
9425961593	select finpayment0_.FIN_Payment_Schedule_Invoice as FIN_Pay10_374_1_, finpayment0_.FIN_Payment_Scheduledetail_ID as FIN_Paym1_374_1_, finpayment0_.FIN_Payment_Scheduledetail_ID as FIN_Paym1_374_0_, finpayment0_.AD_Client_ID as AD_Clien2_374_0_, finpayment0_.AD_Org_ID as AD_Org_I3_374_0_, finpayment0_.Created as Created4_374_0_, finpayment0_.Createdby as Createdb5_374_0_, finpayment0_.Updated as Updated6_374_0_, finpayment0_.Updatedby as Updatedb7_374_0_, finpayment0_.FIN_Payment_Detail_ID as FIN_Paym8_374_0_, finpayment0_.FIN_Payment_Schedule_Order as FIN_Paym9_374_0_, finpayment0_.FIN_Payment_Schedule_Invoice as FIN_Pay10_374_0_, finpayment0_.Amount as Amount11_374_0_, finpayment0_.Isactive as Isactiv12_374_0_, finpayment0_.Writeoffamt as Writeof13_374_0_, finpayment0_.Iscanceled as Iscance14_374_0_, finpayment0_.C_Bpartner_ID as C_Bpart15_374_0_, finpayment0_.C_Activity_ID as C_Activ16_374_0_, finpayment0_.M_Product_ID as M_Produ17_374_0_, finpayment0_.C_Campaign_ID as C_Campa18_374_0_, finpayment0_.C_Project_ID as C_Proje19_374_0_, finpayment0_.C_Salesregion_ID as C_Sales20_374_0_, finpayment0_.C_Costcenter_ID as C_Costc21_374_0_, finpayment0_.User1_ID as User22_374_0_, finpayment0_.User2_ID as User23_374_0_, finpayment0_.DoubtfulDebt_Amount as Doubtfu24_374_0_, finpayment0_.Isinvoicepaid as Isinvoi25_374_0_ from FIN_Payment_ScheduleDetail finpayment0_ where finpayment0_.FIN_Payment_Schedule_Invoice=$1
12a81791af	SELECT coalesce(( select ol.qtyordered - coalesce(sum(abs(coalesce(( select sum(il.movementqty) from m_inoutline il left join m_inout i on i.m_inout_id=il.m_inout_id where i.docstatus<>$2 and il.c_orderline_id=ol.c_orderline_id ),$3))), $4) restante from c_orderline ol where ol.c_orderline_id=p_record_id group by ol.c_orderline_id), $5)
e384d56110	select product0_.M_Product_ID as M_Produc1_455_, product0_.AD_Client_ID as AD_Clien2_455_, product0_.AD_Org_ID as AD_Org_I3_455_, product0_.IsActive as IsActive4_455_, product0_.Created as Created5_455_, product0_.CreatedBy as CreatedB6_455_, product0_.Updated as Updated7_455_, product0_.UpdatedBy as UpdatedB8_455_, product0_.Value as Value9_455_, product0_.Name as Name10_455_, product0_.Description as Descrip11_455_, product0_.DocumentNote as Documen12_455_, product0_.Help as Help13_455_, product0_.UPC as UPC14_455_, product0_.SKU as SKU15_455_, product0_.C_UOM_ID as C_UOM_I16_455_, product0_.SalesRep_ID as SalesRe17_455_, product0_.IsSummary as IsSumma18_455_, product0_.IsStocked as IsStock19_455_, product0_.IsPurchased as IsPurch20_455_, product0_.IsSold as IsSold21_455_, product0_.IsBOM as IsBOM22_455_, product0_.IsInvoicePrintDetails as IsInvoi23_455_, product0_.IsPickListPrintDetails as IsPickL24_455_, product0_.IsVerified as IsVerif25_455_, product0_.M_Product_Category_ID as M_Produ26_455_, product0_.Classification as Classif27_455_, product0_.Volume as Volume28_455_, product0_.Weight as Weight29_455_, product0_.ShelfWidth as ShelfWi30_455_, product0_.ShelfHeight as ShelfHe31_455_, product0_.ShelfDepth as ShelfDe32_455_, product0_.UnitsPerPallet as UnitsPe33_455_, product0_.C_TaxCategory_ID as C_TaxCa34_455_, product0_.S_Resource_ID as S_Resou35_455_, product0_.Discontinued as Discont36_455_, product0_.DiscontinuedBy as Discont37_455_, product0_.Processing as Process38_455_, product0_.S_ExpenseType_ID as S_Expen39_455_, product0_.ProductType as Product40_455_, product0_.ImageURL as ImageUR41_455_, product0_.DescriptionURL as Descrip42_455_, product0_.GuaranteeDays as Guarant43_455_, product0_.VersionNo as Version44_455_, product0_.M_AttributeSet_ID as M_Attri45_455_, product0_.M_AttributeSetInstance_ID as M_Attri46_455_, product0_.DownloadURL as Downloa47_455_, product0_.M_FreightCategory_ID as M_Freig48_455_, product0_.M_Locator_ID as M_Locat49_455_, product0_.AD_Image_ID as AD_Imag50_455_, product0_.C_BPartner_ID as C_BPart51_455_, product0_.Ispriceprinted as Isprice52_455_, product0_.Name2 as Name53_455_, product0_.Stock_Min as Stock_M54_455_, product0_.Enforce_Attribute as Enforce55_455_, product0_.Calculated as Calcula56_455_, product0_.MA_Processplan_ID as MA_Proc57_455_, product0_.Production as Product58_455_, product0_.Capacity as Capacit59_455_, product0_.Delaymin as Delaymi60_455_, product0_.MRP_Planner_ID as MRP_Pla61_455_, product0_.MRP_Planningmethod_ID as MRP_Pla62_455_, product0_.Qtymax as Qtymax63_455_, product0_.Qtymin as Qtymin64_455_, product0_.Qtystd as Qtystd65_455_, product0_.Qtytype as Qtytype66_455_, product0_.Stockmin as Stockmi67_455_, product0_.EM_Aeat347_Isleasebusiness as EM_Aeat68_455_, product0_.Attrsetvaluetype as Attrset69_455_, product0_.EM_Aeat347_Situation as EM_Aeat70_455_, product0_.Isquantityvariable as Isquant71_455_, product0_.Isdeferredrevenue as Isdefer72_455_, product0_.EM_Aeat347_Referenceid as EM_Aeat73_455_, product0_.EM_Aeat347_Locationtype as EM_Aeat74_455_, product0_.Revplantype as Revplan75_455_, product0_.EM_Aeat347_Streetname as EM_Aeat76_455_, product0_.Periodnumber as Periodn77_455_, product0_.EM_Aeat347_Streetnumbertype as EM_Aeat78_455_, product0_.Isdeferredexpense as Isdefer79_455_, product0_.EM_Aeat347_Streetnumber as EM_Aeat80_455_, product0_.Expplantype as Expplan81_455_, product0_.EM_Aeat347_Streetnumberqua as EM_Aeat82_455_, product0_.Periodnumber_Exp as Periodn83_455_, product0_.DefaultPeriod as Default84_455_, product0_.EM_Aeat347_Building as EM_Aeat85_455_, product0_.DefaultPeriod_Exp as Default86_455_, product0_.EM_Aeat347_Hall as EM_Aeat87_455_, product0_.Bookusingpoprice as Bookusi88_455_, product0_.EM_Aeat347_Hallway as EM_Aeat89_455_, product0_.EM_Advcrm_Newactivity as EM_Advc90_455_, product0_.EM_Aeat347_Floor as EM_Aeat91_455_, product0_.C_Uom_Weight_ID as C_Uom_W92_455_, product0_.M_Brand_ID as M_Brand93_455_, product0_.EM_Aeat347_Apartment as EM_Aeat94_455_, product0_.EM_Aeat347_Complement as EM_Aeat95_455_, product0_.IsGeneric as IsGener96_455_, product0_.EM_Aeat347_Location as EM_Aeat97_455_, product0_.Generic_Product_ID as Generic98_455_, product0_.CreateVariants as CreateV99_455_, product0_.EM_Aeat347_County as EM_Aea100_455_, product0_.Characteristic_Desc as Charac101_455_, product0_.EM_Aeat347_Countycode as EM_Aea102_455_, product0_.EM_Aeat347_Regioncode as EM_Aea103_455_, product0_.Updateinvariants as Update104_455_, product0_.EM_Aeat347_Zipcode as EM_Aea105_455_, product0_.ManageVariants as Manage106_455_, product0_.Prod_Cat_Selection as Prod_C107_455_, product0_.Product_Selection as Produc108_455_, product0_.Print_Description as Print_109_455_, product0_.Returnable as Return110_455_, product0_.Overdue_Return_Days as Overdu111_455_, product0_.Ispricerulebased as Ispric112_455_, product0_.Unique_Per_Document as Unique113_455_, product0_.Relateprodcattoservice as Relate114_455_, product0_.Relateprodtoservice as Relate115_455_, product0_.Islinkedtoproduct as Islink116_455_, product0_.Quantity_Rule as Quanti117_455_, product0_.Allow_Deferred_Sell as Allow_118_455_, product0_.Deferred_Sell_Max_Days as Deferr119_455_, product0_.EM_Prlab_Qtylabels as EM_Prl120_455_, product0_.M_Product_Status_ID as M_Prod121_455_, product0_.EM_Psat_Isrepairable as EM_Psa122_455_, product0_.EM_Psat_Isavailablesat as EM_Psa123_455_, product0_.Ismodifytax as Ismodi124_455_, product0_.Relateprodcattaxtoservice as Relate125_455_, product0_.Copyservicemodifytaxconfig as Copyse126_455_ from M_Product product0_ where (upper((product0_.Value\|\|$3\|\|coalesce(to_char((select producttrl1_.Name from M_Product_Trl producttrl1_ where producttrl1_.M_Product_ID=product0_.M_Product_ID and producttrl1_.AD_Language=$4)), to_char(product0_.Name), $5))) like upper($1) escape $6) and (exists (select $7 from psat_request psat_reque2_ inner join M_Product product3_ on psat_reque2_.M_Product_ID=product3_.M_Product_ID where product3_.M_Product_ID=product0_.M_Product_ID and (psat_reque2_.AD_Org_ID in ($8 , $9 , $10 , $11)) and (psat_reque2_.AD_Client_ID in ($12 , $13)))) order by product0_.Value, product0_.Name limit $2
785a907bc3	select invoice0_.C_Invoice_ID as C_Invoic1_249_, invoice0_.AD_Client_ID as AD_Clien2_249_, invoice0_.AD_Org_ID as AD_Org_I3_249_, invoice0_.IsActive as IsActive4_249_, invoice0_.Created as Created5_249_, invoice0_.CreatedBy as CreatedB6_249_, invoice0_.Updated as Updated7_249_, invoice0_.UpdatedBy as UpdatedB8_249_, invoice0_.IsSOTrx as IsSOTrx9_249_, invoice0_.DocumentNo as Documen10_249_, invoice0_.DocStatus as DocStat11_249_, invoice0_.DocAction as DocActi12_249_, invoice0_.Processing as Process13_249_, invoice0_.Processed as Process14_249_, invoice0_.Posted as Posted15_249_, invoice0_.C_DocType_ID as C_DocTy16_249_, invoice0_.C_DocTypeTarget_ID as C_DocTy17_249_, invoice0_.C_Order_ID as C_Order18_249_, invoice0_.Description as Descrip19_249_, invoice0_.IsPrinted as IsPrint20_249_, invoice0_.SalesRep_ID as SalesRe21_249_, invoice0_.DateInvoiced as DateInv22_249_, invoice0_.DatePrinted as DatePri23_249_, invoice0_.DateAcct as DateAcc24_249_, invoice0_.C_BPartner_ID as C_BPart25_249_, invoice0_.C_BPartner_Location_ID as C_BPart26_249_, invoice0_.POReference as PORefer27_249_, invoice0_.IsDiscountPrinted as IsDisco28_249_, invoice0_.DateOrdered as DateOrd29_249_, invoice0_.C_Currency_ID as C_Curre30_249_, invoice0_.C_PaymentTerm_ID as C_Payme31_249_, invoice0_.C_Charge_ID as C_Charg32_249_, invoice0_.ChargeAmt as ChargeA33_249_, invoice0_.TotalLines as TotalLi34_249_, invoice0_.GrandTotal as GrandTo35_249_, invoice0_.M_PriceList_ID as M_Price36_249_, invoice0_.IsTaxIncluded as IsTaxIn37_249_, invoice0_.C_Campaign_ID as C_Campa38_249_, invoice0_.C_Project_ID as C_Proje39_249_, invoice0_.C_Activity_ID as C_Activ40_249_, invoice0_.CreateFrom as CreateF41_249_, invoice0_.GenerateTo as Generat42_249_, invoice0_.AD_User_ID as AD_User43_249_, invoice0_.CopyFrom as CopyFro44_249_, invoice0_.IsSelfService as IsSelfS45_249_, invoice0_.AD_OrgTrx_ID as AD_OrgT46_249_, invoice0_.User1_ID as User47_249_, invoice0_.User2_ID as User48_249_, invoice0_.Withholdingamount as Withhol49_249_, invoice0_.Taxdate as Taxdate50_249_, invoice0_.C_Withholding_ID as C_Withh51_249_, invoice0_.Ispaid as Ispaid52_249_, invoice0_.EM_Einv_Generated as EM_Einv53_249_, invoice0_.Totalpaid as Totalpa54_249_, invoice0_.EM_Einv_Sent as EM_Einv55_249_, invoice0_.OutstandingAmt as Outstan56_249_, invoice0_.DaysTillDue as DaysTil57_249_, invoice0_.DueAmt as DueAmt58_249_, invoice0_.LastCalculatedOnDate as LastCal59_249_, invoice0_.FIN_Paymentmethod_ID as FIN_Pay60_249_, invoice0_.FIN_Payment_Priority_ID as FIN_Pay61_249_, invoice0_.Finalsettlement as Finalse62_249_, invoice0_.Daysoutstanding as Daysout63_249_, invoice0_.Percentageoverdue as Percent64_249_, invoice0_.C_Costcenter_ID as C_Costc65_249_, invoice0_.Calculate_Promotions as Calcula66_249_, invoice0_.A_Asset_ID as A_Asset67_249_, invoice0_.EM_APRM_Addpayment as EM_APRM68_249_, invoice0_.Iscashvat as Iscashv69_249_, invoice0_.EM_APRM_Processinvoice as EM_APRM70_249_, invoice0_.EM_Obcma_C_Poc_Email_ID as EM_Obcm71_249_, invoice0_.Prepaymentamt as Prepaym72_249_, invoice0_.Createfromorders as Createf73_249_, invoice0_.Createfrominouts as Createf74_249_, invoice0_.EM_Advcrm_Newactivity as EM_Advc75_249_, invoice0_.Paidamtatinvoicing as Paidamt76_249_, invoice0_.BPartner_ExtRef as BPartne77_249_, invoice0_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc78_249_, invoice0_.EM_Prouti_Recalculate_Price as EM_Prou79_249_, invoice0_.EM_Ml_Select_Product as EM_Ml_S80_249_, invoice0_.EM_Prouti_Pricecalculatetdate as EM_Prou81_249_, invoice0_.EM_Prouti_Totalizations as EM_Prou82_249_ from C_Invoice invoice0_ left outer join FIN_Payment_Schedule finpayment1_ on invoice0_.C_Invoice_ID=finpayment1_.C_Invoice_ID where invoice0_.Processed=$7 and (invoice0_.Ispaid=$8 or finpayment1_.Updated>=invoice0_.LastCalculatedOnDate or invoice0_.OutstandingAmt<>$9 or invoice0_.Finalsettlement is null) and (invoice0_.AD_Org_ID in ($1 , $2 , $3 , $4)) and (invoice0_.AD_Client_ID in ($5 , $6)) and invoice0_.IsActive=$10
0c247acdf0	VACUUM (FULL, VERBOSE, ANALYZE)
2e0b729b87	VACUUM (FULL, VERBOSE, ANALYZE)
adb1c31f79	VACUUM (FULL, VERBOSE, ANALYZE)
ebf986aa9f	select fin_paymen0_.FIN_Payment_Scheduledetail_ID as FIN_Paym1_374_, fin_paymen0_.AD_Client_ID as AD_Clien2_374_, fin_paymen0_.AD_Org_ID as AD_Org_I3_374_, fin_paymen0_.Created as Created4_374_, fin_paymen0_.Createdby as Createdb5_374_, fin_paymen0_.Updated as Updated6_374_, fin_paymen0_.Updatedby as Updatedb7_374_, fin_paymen0_.FIN_Payment_Detail_ID as FIN_Paym8_374_, fin_paymen0_.FIN_Payment_Schedule_Order as FIN_Paym9_374_, fin_paymen0_.FIN_Payment_Schedule_Invoice as FIN_Pay10_374_, fin_paymen0_.Amount as Amount11_374_, fin_paymen0_.Isactive as Isactiv12_374_, fin_paymen0_.Writeoffamt as Writeof13_374_, fin_paymen0_.Iscanceled as Iscance14_374_, fin_paymen0_.C_Bpartner_ID as C_Bpart15_374_, fin_paymen0_.C_Activity_ID as C_Activ16_374_, fin_paymen0_.M_Product_ID as M_Produ17_374_, fin_paymen0_.C_Campaign_ID as C_Campa18_374_, fin_paymen0_.C_Project_ID as C_Proje19_374_, fin_paymen0_.C_Salesregion_ID as C_Sales20_374_, fin_paymen0_.C_Costcenter_ID as C_Costc21_374_, fin_paymen0_.User1_ID as User22_374_, fin_paymen0_.User2_ID as User23_374_, fin_paymen0_.DoubtfulDebt_Amount as Doubtfu24_374_, fin_paymen0_.Isinvoicepaid as Isinvoi25_374_ from FIN_Payment_ScheduleDetail fin_paymen0_ left outer join FIN_Payment_Schedule fin_paymen1_ on fin_paymen0_.FIN_Payment_Schedule_Order=fin_paymen1_.Fin_Payment_Schedule_ID left outer join C_Order order2_ on fin_paymen1_.C_Order_ID=order2_.C_Order_ID left outer join C_BPartner businesspa3_ on order2_.C_BPartner_ID=businesspa3_.C_BPartner_ID left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen1_.FIN_Payment_Priority_ID=fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_Payment_Schedule fin_paymen5_ on fin_paymen0_.FIN_Payment_Schedule_Invoice=fin_paymen5_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice6_ on fin_paymen5_.C_Invoice_ID=invoice6_.C_Invoice_ID left outer join C_BPartner businesspa7_ on invoice6_.C_BPartner_ID=businesspa7_.C_BPartner_ID left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen5_.FIN_Payment_Priority_ID=fin_paymen8_.FIN_Payment_Priority_ID where (fin_paymen0_.FIN_Payment_Detail_ID is null) and (fin_paymen0_.AD_Org_ID in ($8)) and (invoice6_.C_Invoice_ID is not null) and fin_paymen5_.Fin_Paymentmethod_ID=$9 and invoice6_.C_Currency_ID=$10 and invoice6_.IsSOTrx=$11 and coalesce(fin_paymen5_.ExpectedDate, fin_paymen1_.ExpectedDate)<$1 and (fin_paymen0_.AD_Org_ID in ($2 , $3 , $4 , $5)) and (fin_paymen0_.AD_Client_ID in ($6 , $7)) and fin_paymen0_.Isactive=$12 order by coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen5_.ExpectedDate, fin_paymen1_.ExpectedDate), coalesce(businesspa7_.Name, businesspa3_.Name) desc, coalesce(invoice6_.DocumentNo, order2_.DocumentNo), coalesce(order2_.DocumentNo, invoice6_.DocumentNo), fin_paymen0_.Amount
df99961951	select financialm0_.C_Settlement_ID as C_Settle1_310_0_, financialm0_.AD_Client_ID as AD_Clien2_310_0_, financialm0_.AD_Org_ID as AD_Org_I3_310_0_, financialm0_.IsActive as IsActive4_310_0_, financialm0_.Created as Created5_310_0_, financialm0_.CreatedBy as CreatedB6_310_0_, financialm0_.Updated as Updated7_310_0_, financialm0_.UpdatedBy as UpdatedB8_310_0_, financialm0_.DocumentNo as Document9_310_0_, financialm0_.DateTrx as DateTrx10_310_0_, financialm0_.C_DocType_ID as C_DocTy11_310_0_, financialm0_.Processing as Process12_310_0_, financialm0_.Processed as Process13_310_0_, financialm0_.Posted as Posted14_310_0_, financialm0_.C_Project_ID as C_Proje15_310_0_, financialm0_.C_Campaign_ID as C_Campa16_310_0_, financialm0_.C_Activity_ID as C_Activ17_310_0_, financialm0_.User1_ID as User18_310_0_, financialm0_.User2_ID as User19_310_0_, financialm0_.CreateFrom as CreateF20_310_0_, financialm0_.C_Currency_ID as C_Curre21_310_0_, financialm0_.Cancelednotchargeamt as Cancele22_310_0_, financialm0_.Generatedamt as Generat23_310_0_, financialm0_.Chargedamt as Charged24_310_0_, financialm0_.Description as Descrip25_310_0_, financialm0_.CreateFile as CreateF26_310_0_, financialm0_.DateAcct as DateAcc27_310_0_, financialm0_.Settlementtype as Settlem28_310_0_, financialm0_.SettlementOpen as Settlem29_310_0_, financialm0_.CopyFrom as CopyFro30_310_0_, financialm0_.IsGenerated as IsGener31_310_0_, financialm0_.IsTemplate as IsTempl32_310_0_ from C_Settlement financialm0_ where financialm0_.C_Settlement_ID=$1
da21d1cd03	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
1b3d7b3f6d	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, $5) and this_.AD_Client_ID in ($6, $7) and this_.Isactive=$8
d0b36135c7	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 )
b561df93c5	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
bda4372001	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)
de891c1f5b	select shipmentin0_.M_InOut_ID as M_InOut_1_415_0_, shipmentin0_.AD_Client_ID as AD_Clien2_415_0_, shipmentin0_.AD_Org_ID as AD_Org_I3_415_0_, (select C_GETINVOICESTATUSFROMSHIPMENT(shipmentin0_.m_inout_id) from dual) as formula26_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50)
32bad3f686	delete from ad_context_info
c2b6cfc2bf	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 = 'en_US' UNION select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, texttrl.ad_language as trlLang, texttrl.text as trlText, texttrl.istranslated as isTranslated, 3 as orderSeq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename is null and text.isused = 'Y' and texttrl.ad_language = 'en_US' UNION select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, 'en_US' as trlLang, text.text as trlText, 'N' as isTranslated, 2 as orderSeq from ad_textinterfaces text where text.ad_textinterfaces_id NOT IN (SELECT t.ad_textinterfaces_id FROM ad_textInterfaces t, ad_textinterfaces_trl trl WHERE t.ad_textinterfaces_id = trl.ad_textinterfaces_id and trl.ad_language = 'en_US') and (text.filename is null OR text.filename = '/org/openbravo/erpCommon/security/Login.html' ) and text.isused = 'Y' order by orderSeq
d7389ab8e1	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
6a18f0bfd3	insert into prsync_entry (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Jsonentry, Type_Of_Data, Status, Process, Processing, Prsync_Entry_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
50b8978166	select order_comp0_.C_Order_ID as C_Order_1_265_0_, order_comp0_.AD_Client_ID as AD_Clien2_265_0_, order_comp0_.AD_Org_ID as AD_Org_I3_265_0_, (coalesce((select case when sum(abs(ol.qtyordered)) = $51 or order_comp0_.iscancelled = $52 or order_comp0_.cancelledorder_id is not null then $53 else round(coalesce(sum(abs(ol.qtydelivered)), $54)/sum(abs(ol.qtyordered)) * $55, $56) end from c_orderline ol where ol.c_order_id=order_comp0_.c_order_id and ol.c_order_discount_id is null),$57)) as formula28_0_, (coalesce(prouti_delavailablewithoutres(order_comp0_.c_order_id),$58)) as formula29_0_, (coalesce(prouti_deliveryavailable(order_comp0_.c_order_id),$59)) as formula30_0_, (select sum(prouti_qtyremainingorderline(ol.c_orderline_id)) from c_orderline ol where ol.c_order_id = order_comp0_.c_order_id) as formula31_0_, (select case when sum(ol.qtyordered)=$60 then $61 else trunc((sum(least(ol.qtyordered, coalesce(pool.qtyordered,$62))) / sum(ol.qtyordered) ) * $63) end from c_orderline ol left join c_orderline pool on pool.em_prouti_orderline_id=ol.c_orderline_id where ol.c_order_id=order_comp0_.c_order_id) as formula32_0_, (coalesce((select case when sum(abs(ol.qtyordered)) = $64 or order_comp0_.iscancelled = $65 or order_comp0_.cancelledorder_id is not null then $66 else round(coalesce(sum(abs(ol.qtyinvoiced)), $67)/sum(abs(ol.qtyordered)) * $68, $69) end from c_orderline ol where ol.c_order_id=order_comp0_.c_order_id and ol.c_order_discount_id is null), $70)) as formula33_0_, (coalesce((select case when sum(fps.amount) = $71 then $72 else round(sum(fps.paidamt)/sum(fps.amount) * $73, $74) end from FIN_Payment_Schedule fps where fps.c_order_id=order_comp0_.c_order_id),$75)) as formula34_0_ from C_Order order_comp0_ where order_comp0_.C_Order_ID in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50)
9cbca4d83c	INSERT INTO AD_AUDIT_TRAIL (AD_AUDIT_TRAIL_ID, AD_USER_ID, AD_TABLE_ID, AD_COLUMN_ID, PROCESSTYPE, PROCESS_ID, RECORD_ID, RECORD_REVISION, ACTION, EVENT_TIME, OLD_CHAR, NEW_CHAR, AD_CLIENT_ID, AD_ORG_ID) VALUES (GET_UUID(), V_USER_ID, $33, $34, v_process_type, v_process_id, v_record_id, v_record_rev, v_action, v_time, v_old_CHAR, v_new_CHAR, V_CLIENT, V_ORG)
9625146448	select min(this_.Duedate) as y0_ from FIN_Payment_Schedule this_ where this_.C_Invoice_ID=$1 and this_.Outstandingamt<>$2 and this_.Isactive=$3 limit $4
29e9be51ce	select adtab0_.AD_Table_ID as col_0_0_, adwindowac2_.IsReadWrite as col_1_0_ from AD_Tab adtab0_ left outer join AD_Window adwindow1_ on adtab0_.AD_Window_ID=adwindow1_.AD_Window_ID left outer join AD_Window_Access adwindowac2_ on adwindow1_.AD_Window_ID=adwindowac2_.AD_Window_ID where adwindowac2_.AD_Role_ID=$1
d20baf16f4	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
93accebb93	SELECT o.C_Order_ID, org.Name as adorgname, COALESCE(dttrl.Name, dt.Name) as cdoctypename, o.DocumentNo, bp.Name as cbpartnername, o.DateOrdered, o.totallines as amountlines, ( SELECT sum((ol.qtyordered - ol.qtydelivered) * ol.priceactual) FROM c_orderline ol WHERE ol.c_order_id = o.c_order_id AND ol.qtyordered <> ol.qtydelivered AND ol.directship = $2 AND ol.m_product_id IS NOT NULL ) as TotalLines FROM C_Order o JOIN AD_Org org ON o.AD_Org_ID = org.AD_Org_ID JOIN C_BPartner bp ON o.C_BPartner_ID = bp.C_BPartner_ID JOIN C_DocType dt ON o.C_DocType_ID = dt.C_DocType_ID LEFT JOIN C_DocType_trl dttrl ON dt.C_DocType_ID = dttrl.C_DocType_ID AND dttrl.ad_language = $1 WHERE o.docstatus = $3 AND o.isdelivered = $4 AND dt.isreturn = $5 AND dt.docbasetype = $6 AND dt.docsubtypeso NOT IN ($7, $8, $9) AND EXISTS ( SELECT $10 FROM C_ORDERLINE ol WHERE ol.c_order_id = o.c_order_id AND ol.qtyordered <> ol.qtydelivered AND ol.directship = $11 AND ol.m_product_id IS NOT NULL ) AND o.ad_client_id IN ($12,$13) AND o.ad_org_id IN ($14,$15,$16,$17) AND $18=$19 AND $20=$21 AND o.ad_org_id IN ($22) ORDER BY org.Name, bp.Name, DateOrdered
75cdc9279a	SELECT td0.AD_User_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),$2)),$3)) AS NAME, $4 AS DESCRIPTION FROM AD_User td0 WHERE td0.AD_Client_ID IN ($5,$6) AND td0.AD_Org_ID IN ($7,$8) AND (EXISTS (select ad_user_id from ad_user left join c_bpartner on td0.c_bpartner_id=c_bpartner.c_bpartner_id where c_bpartner.isemployee=$9)) AND (td0.isActive = $10 OR td0.AD_User_ID = ($1) ) ORDER BY 2 LIMIT $11 OFFSET $12
847a368de1	delete from ad_context_info
fa1b74d06f	select financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Settlement_Cancel_ID=$1
1e43f28979	insert into M_Product (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, C_UOM_ID, IsSummary, IsStocked, IsPurchased, IsSold, IsBOM, IsInvoicePrintDetails, IsPickListPrintDetails, IsVerified, M_Product_Category_ID, C_TaxCategory_ID, Discontinued, Processing, ProductType, M_Locator_ID, Ispriceprinted, Enforce_Attribute, Calculated, Production, Qtytype, Isquantityvariable, Isdeferredrevenue, Isdeferredexpense, Bookusingpoprice, EM_Advcrm_Newactivity, IsGeneric, CreateVariants, Updateinvariants, ManageVariants, Print_Description, Returnable, Ispricerulebased, Unique_Per_Document, Relateprodcattoservice, Relateprodtoservice, Islinkedtoproduct, Allow_Deferred_Sell, EM_Prlab_Qtylabels, EM_Psat_Isrepairable, EM_Psat_Isavailablesat, Ismodifytax, Relateprodcattaxtoservice, Copyservicemodifytaxconfig, M_Product_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53)
c1deedb9c8	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
18a7378ff7	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
c42a2e4205	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
4108c96b3f	select productbyp0_.M_Product_Price_Warehouse_V_ID as M_Produc1_469_, productbyp0_.AD_Client_ID as AD_Clien2_469_, productbyp0_.AD_Org_ID as AD_Org_I3_469_, productbyp0_.Isactive as Isactive4_469_, productbyp0_.Updated as Updated5_469_, productbyp0_.Updatedby as Updatedb6_469_, productbyp0_.Created as Created7_469_, productbyp0_.Createdby as Createdb8_469_, productbyp0_.M_Product_ID as M_Produc9_469_, productbyp0_.M_Warehouse_ID as M_Wareh10_469_, productbyp0_.M_Productprice_ID as M_Produ11_469_, productbyp0_.QTY_Available as QTY_Ava12_469_, productbyp0_.QTY_Onhand as QTY_Onh13_469_, productbyp0_.QTY_Reserved as QTY_Res14_469_, productbyp0_.QTY_Ordered as QTY_Ord15_469_, productbyp0_.Pricelist as Priceli16_469_, productbyp0_.Pricestd as Pricest17_469_, productbyp0_.Pricelimit as Priceli18_469_, productbyp0_.Orgwarehouse as Orgware19_469_ from M_Product_Price_Warehouse_v productbyp0_ left outer join M_Product product1_ on productbyp0_.M_Product_ID=product1_.M_Product_ID cross join M_ProductPrice pricingpro4_ cross join M_PriceList_Version pricingpri5_ cross join M_PriceList pricingpri9_ where productbyp0_.M_Productprice_ID=pricingpro4_.M_ProductPrice_ID and pricingpro4_.M_PriceList_Version_ID=pricingpri5_.M_PriceList_Version_ID and pricingpri5_.M_PriceList_ID=pricingpri9_.M_PriceList_ID and (upper(product1_.Value) like upper($1) escape $12 or upper(product1_.Name) like upper($2) escape $13 or upper((product1_.Value\|\|$14\|\|coalesce(to_char((select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID=product1_.M_Product_ID and producttrl2_.AD_Language=$15)), to_char(product1_.Name), $16))) like upper($3) escape $17 or upper((product1_.Value\|\|$18\|\|coalesce(to_char((select producttrl3_.Name from M_Product_Trl producttrl3_ where producttrl3_.M_Product_ID=product1_.M_Product_ID and producttrl3_.AD_Language=$19)), to_char(product1_.Name), $20))) like upper($4) escape $21) and (productbyp0_.AD_Org_ID in ($22 , $23)) and productbyp0_.Isactive=$24 and AD_ORG_ISINNATURALTREE(productbyp0_.Orgwarehouse, $5, $6)=$25 and pricingpri5_.IsActive=$26 and AD_ORG_ISINNATURALTREE(pricingpro4_.AD_Org_ID, $7, $8)=$27 and pricingpri9_.IsSOPriceList=$28 and pricingpri9_.C_Currency_ID=$29 and pricingpro4_.M_PriceList_Version_ID=$30 and productbyp0_.M_Warehouse_ID=$31 and (productbyp0_.AD_Client_ID in ($9 , $10)) and productbyp0_.Isactive=$32 order by product1_.Value, product1_.Name, product1_.M_Product_ID limit $11
0c9140d9a9	INSERT INTO AD_AUDIT_TRAIL (AD_AUDIT_TRAIL_ID, AD_USER_ID, AD_TABLE_ID, AD_COLUMN_ID, PROCESSTYPE, PROCESS_ID, RECORD_ID, RECORD_REVISION, ACTION, EVENT_TIME, OLD_NUMBER, NEW_NUMBER, AD_CLIENT_ID, AD_ORG_ID) VALUES (GET_UUID(), V_USER_ID, $33, $34, v_process_type, v_process_id, v_record_id, v_record_rev, v_action, v_time, v_old_NUMBER, v_new_NUMBER, V_CLIENT, V_ORG)
228d74fbf5	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
a4410aa255	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
c525c04235	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)
503324b603	select financialm0_.C_Invoice_ID as C_Invoi13_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Invoice_ID=$1
f68dd8a1a9	ANALYZE last_stat_tables
3a735c6f6a	select psat_reque0_.Psat_Request_ID as Psat_Req1_735_, psat_reque0_.AD_Client_ID as AD_Clien2_735_, psat_reque0_.AD_Org_ID as AD_Org_I3_735_, psat_reque0_.Isactive as Isactive4_735_, psat_reque0_.Created as Created5_735_, psat_reque0_.Createdby as Createdb6_735_, psat_reque0_.Updated as Updated7_735_, psat_reque0_.Updatedby as Updatedb8_735_, psat_reque0_.C_Doctype_ID as C_Doctyp9_735_, psat_reque0_.Documentno as Documen10_735_, psat_reque0_.Priority as Priorit11_735_, psat_reque0_.Status as Status12_735_, psat_reque0_.C_Bpartner_ID as C_Bpart13_735_, psat_reque0_.C_Bpartner_Location_ID as C_Bpart14_735_, psat_reque0_.AD_User_ID as AD_User15_735_, psat_reque0_.Subject as Subject16_735_, psat_reque0_.Description as Descrip17_735_, psat_reque0_.Supervisor_ID as Supervi18_735_, psat_reque0_.Sgpcrm_Securitygroups_ID as Sgpcrm_19_735_, psat_reque0_.Requestdate as Request20_735_, psat_reque0_.Dateclosed as Dateclo21_735_, psat_reque0_.Resolution as Resolut22_735_, psat_reque0_.Psat_Parent_Request_ID as Psat_Pa23_735_, psat_reque0_.Location_Notes as Locatio24_735_, psat_reque0_.C_Orderline_ID as C_Order25_735_, psat_reque0_.psat_addactivitiesfromtemplate as psat_ad26_735_, psat_reque0_.Change_Status as Change_27_735_, psat_reque0_.Requestor_ID as Request28_735_, psat_reque0_.Affected_Contact_ID as Affecte29_735_, psat_reque0_.Notified_By_ID as Notifie30_735_, psat_reque0_.Poreference as Porefer31_735_, psat_reque0_.Additional_Info as Additio32_735_, psat_reque0_.M_Product_ID as M_Produ33_735_, psat_reque0_.M_Attributesetinstance_ID as M_Attri34_735_, psat_reque0_.EM_Cus_Clonerequest as EM_Cus_35_735_, psat_reque0_.Psat_Checklist_ID as Psat_Ch36_735_ from psat_request psat_reque0_ inner join M_Product product1_ on psat_reque0_.M_Product_ID=product1_.M_Product_ID where upper((product1_.Value\|\|$9\|\|coalesce(to_char((select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID=product1_.M_Product_ID and producttrl2_.AD_Language=$10)), to_char(product1_.Name), $11)))=upper($1) and (psat_reque0_.AD_Org_ID in ($2 , $3 , $4 , $5)) and (psat_reque0_.AD_Client_ID in ($6 , $7)) order by psat_reque0_.Documentno, psat_reque0_.Psat_Request_ID limit $8
9824754258	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
b9bb8a4422	SELECT * FROM take_sample_subset(1,0)
73e3636bec	update C_Invoice set Updated=$1, LastCalculatedOnDate=$2 where C_Invoice_ID=$3
8c36a5bf11	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
2cbac7b1a6	delete from ad_context_info
174962df65	insert into psat_checklist_result (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Advcrm_Activity_ID, Result, Psat_Check_Type_ID, Psat_Checklist_Group_ID, Description, Psat_Checklist_Result_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)

Schema object statistics

Top tables by estimated sequentially scanned volume

DB	Tablespace	Schema	Table	~SeqBytes	SeqScan	IxScan	IxFet	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	pg_temp_8	ad_context_info	363 GB	100941			100927		100926
etendo	pg_default	pg_temp_3	ad_context_info	103 GB	51146			51092		51091
etendo	pg_default	pg_temp_9	ad_context_info	62 GB	38347			38321		38320
etendo	pg_default	pg_temp_5	ad_context_info	61 GB	12600			12600		12600
etendo	pg_default	pg_temp_4	ad_context_info	31 GB	25607			25595		25594
etendo	pg_default	pg_temp_7	ad_context_info	31 GB	25230			25230		25229
etendo	pg_default	public	advcrm_activity	17 GB	1060	2163	2111	8	90		72
etendo	pg_default	public	advcrm_activity(TOAST)
etendo	pg_default	public	psat_activity_consumption	17 GB	6421	18	16	14	14		13
etendo	pg_default	public	psat_activity_consumption(TOAST)
etendo	pg_default	public	c_bpartner	12 GB	9441	22475	156275	1	8		5
etendo	pg_default	public	c_bpartner(TOAST)
etendo	pg_default	pg_temp_5	ad_context_info	11 GB	12852			12849		12848
etendo	pg_default	pg_temp_6	ad_context_info	11 GB	12867			12842		12841
etendo	pg_default	pg_temp_4	ad_context_info	10 GB	12600			12600		12599
etendo	pg_default	pg_catalog	pg_class	4052 MB	6028	615172	602653	1879	6728	1879	1376
etendo	pg_default	public	m_product	2791 MB	787	3325106	3395675	10	7		2
etendo	pg_default	public	m_product(TOAST)
etendo	pg_default	public	psat_checklist_result	2536 MB	43	1990	2761	312	31		30
etendo	pg_default	public	psat_checklist_result(TOAST)
etendo	pg_default	profile	last_stat_database	2134 MB	97241			88		88
etendo	pg_default	public	ad_audit_trail	1529 MB	3	164	115	2283
etendo	pg_default	public	ad_audit_trail(TOAST)
etendo	pg_default	public	psat_request	990 MB	375	3352	11348	1	5		1
etendo	pg_default	public	psat_request(TOAST)
etendo	pg_default	public	m_inout	873 MB	74	911	2412	6	10		7
etendo	pg_default	public	m_inout(TOAST)
etendo	pg_default	public	c_invoice	751 MB	33	304181	1390840		289533
etendo	pg_default	public	c_invoice(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	pg_temp_8	ad_context_info	42219889	28.17
etendo	pg_default	public	c_invoice	3559737	2.37	7620327	5.08
etendo	pg_default	pg_temp_3	ad_context_info	10872079	7.25
etendo	pg_default	public	m_product	3715202	2.48	6680170	4.46
etendo	pg_default	pg_temp_5	ad_context_info	7270408	4.85
etendo	pg_default	pg_temp_9	ad_context_info	6145141	4.10
etendo	pg_default	public	m_productprice	1548410	1.03	4562348	3.04
etendo	pg_default	profile	last_stat_tables	3498780	2.33	106950	0.07
etendo	pg_default	public	fin_payment_schedule	894544	0.60	2593010	1.73
etendo	pg_default	public	m_product_trl			3469535	2.31
etendo	pg_default	pg_temp_4	ad_context_info	2729881	1.82
etendo	pg_default	pg_temp_7	ad_context_info	2698568	1.80
etendo	pg_default	pg_catalog	pg_class	1112969	0.74	1286177	0.86
etendo	pg_default	public	ad_tab	1288003	0.86	935435	0.62
etendo	pg_default	public	advcrm_activity	2181430	1.46	6585	0.00
etendo	pg_default	public	psat_activity_consumption	2155472	1.44	69	0.00
etendo	pg_default	public	c_bpartner	1648502	1.10	48168	0.03
etendo	pg_default	public	c_debt_payment	487898	0.33	820543	0.55
etendo	pg_default	pg_catalog	pg_attribute	487170	0.33	715859	0.48
etendo	pg_default	public	ad_textinterfaces	549346	0.37	605748	0.40

DB	Tablespace	Schema	Table	Heap	Ix	TOAST	TOAST-Ix	Hit(%)
Blks	%Total	Blks	%Total	Blks	%Total	Blks	%Total
etendo	pg_default	public	ad_audit_trail	130523	28.92	2447	0.54					46.26
etendo	pg_default	public	ad_image	791	0.18	24	0.01	56472	12.51	886	0.20	33.46
etendo	pg_default	public	psat_checklist_result	15073	3.34	3657	0.81					97.83
etendo	pg_default	public	c_invoice	5830	1.29	6288	1.39					99.89
etendo	pg_default	public	ad_session_usage_audit	5040	1.12	677	0.15					88.90
etendo	pg_default	public	fin_payment_schedule	3796	0.84	801	0.18					99.87
etendo	pg_default	public	fin_payment	3164	0.70	263	0.06					88.28
etendo	pg_default	public	fin_payment_scheduledetail	2720	0.60	668	0.15					93.61
etendo	pg_default	public	ad_process_run	2700	0.60	122	0.03	11	0.00	10	0.00	95.75
etendo	pg_default	public	fin_payment_detail	1910	0.42	266	0.06					84.64
etendo	pg_default	public	prsync_entry	1042	0.23	78	0.02	884	0.20	17	0.00	91.67
etendo	pg_default	pg_catalog	pg_attribute	1441	0.32	479	0.11					99.84
etendo	pg_default	profile	sample_stat_tables	1781	0.39	108	0.02					96.15
etendo	pg_default	pg_catalog	pg_statistic	1174	0.26	73	0.02	604	0.13	21	0.00	99.53
etendo	pg_default	public	c_orderline	8	0.00	1450	0.32					97.77
etendo	pg_default	profile	last_stat_indexes	954	0.21	112	0.02					99.86
etendo	pg_default	public	c_debt_payment	940	0.21	119	0.03					99.92
etendo	pg_default	pg_catalog	pg_depend	780	0.17	145	0.03					99.43
etendo	pg_default	profile	sample_statements	746	0.17	136	0.03					97.53
etendo	pg_default	pg_temp_8	ad_context_info	835	0.19							100.00

Top DML tables

DB	Tablespace	Schema	Table	Ins	Upd	Del	Upd(HOT)	SeqScan	SeqFet	IxScan	IxFet
etendo	pg_default	public	c_invoice		289533			33	1513182	304181	1390840
etendo	pg_default	public	c_invoice(TOAST)
etendo	pg_default	pg_temp_8	ad_context_info	100927		100926		100941	100940
etendo	pg_default	profile	last_stat_indexes	54119	1294	54119	1	185	865904	34530	328361
etendo	pg_default	pg_temp_3	ad_context_info	51092		51091		51146	51145
etendo	pg_default	pg_temp_9	ad_context_info	38321		38320		38347	38346
etendo	pg_default	profile	last_stat_tables	32890	3454	32890	49	186	529100	8048	3084680
etendo	pg_default	pg_temp_4	ad_context_info	25595		25594		25607	25606
etendo	pg_default	pg_temp_7	ad_context_info	25230		25229		25230	25229
etendo	pg_default	pg_catalog	pg_attribute	24253		24253		125	94610	303977	1266555
etendo	pg_default	pg_temp_5	ad_context_info	12849		12848		12852	12851
etendo	pg_default	pg_temp_6	ad_context_info	12842		12841		12867	12866
etendo	pg_default	pg_temp_5	ad_context_info	12600		12600		12600	12600
etendo	pg_default	pg_temp_4	ad_context_info	12600		12599		12600	12599
etendo	pg_default	pg_catalog	pg_statistic		16424		13278	2	16634	104203	86890
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	2396		2397				14107	22142
etendo	pg_default	profile	last_stat_user_functions	8257	888	8257	37	386	243761
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_catalog	pg_class	1879	6728	1879	1376	6028	17627920	615172	602653
etendo	pg_default	pg_catalog	pg_depend	4600		4600		10	205860	44316	50012
etendo	pg_default	profile	sample_stat_tables	3454		3326		25	606723	142	3518
etendo	pg_default	pg_catalog	pg_type	2171		2171		12	30607	112513	105311
etendo	pg_default	profile	sample_statements	1447		1448		49	510453	109	1448
etendo	pg_default	profile	sample_statements(TOAST)

Top tables by updated/deleted tuples

DB	Tablespace	Schema	Table	Upd	Upd(HOT)	Del	AutoVacuum	Analyze	AutoAnalyze
etendo	pg_default	public	c_invoice	289533			23	1	23
etendo	pg_default	public	c_invoice(TOAST)
etendo	pg_default	pg_temp_8	ad_context_info			100926
etendo	pg_default	profile	last_stat_indexes	1294	1	54119	26	47	23
etendo	pg_default	pg_temp_3	ad_context_info			51091
etendo	pg_default	pg_temp_9	ad_context_info			38320
etendo	pg_default	profile	last_stat_tables	3454	49	32890	26	47	23
etendo	pg_default	pg_temp_4	ad_context_info			25594
etendo	pg_default	pg_temp_7	ad_context_info			25229
etendo	pg_default	pg_catalog	pg_attribute			24253	1	1	1
etendo	pg_default	pg_catalog	pg_statistic	16424	13278		2
etendo	pg_default	pg_catalog	pg_statistic(TOAST)			2397	4
etendo	pg_default	pg_temp_5	ad_context_info			12848
etendo	pg_default	pg_temp_6	ad_context_info			12841
etendo	pg_default	pg_temp_5	ad_context_info			12600
etendo	pg_default	pg_temp_4	ad_context_info			12599
etendo	pg_default	profile	last_stat_user_functions	888	37	8257	26	47	23
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_catalog	pg_class	6728	1376	1879	1	1	1
etendo	pg_default	pg_catalog	pg_depend			4600		1	1
etendo	pg_default	profile	sample_stat_tables			3326		1	2
etendo	pg_default	pg_catalog	pg_type			2171	1	1	1
etendo	pg_default	public	ad_session	1977	1920			1	15
etendo	pg_default	public	ad_session(TOAST)

Top growing tables

DB	Tablespace	Schema	Table	Size	Growth	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	pg_temp_8	ad_context_info	6688 kB	6688 kB	100927		100926
etendo	pg_default	pg_temp_3	ad_context_info	3376 kB	3376 kB	51092		51091
etendo	pg_default	pg_temp_4	ad_context_info	1712 kB	1712 kB	25595		25594
etendo	pg_default	pg_temp_7	ad_context_info	1696 kB	1696 kB	25230		25229
etendo	pg_default	pg_temp_5	ad_context_info	864 kB	864 kB	12849		12848
etendo	pg_default	pg_catalog	pg_statistic	4824 kB	-48 kB		16424		13278
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	4400 kB	504 kB	2396		2397
etendo	pg_default	pg_catalog	pg_attribute	4768 kB	400 kB	24253		24253
etendo	pg_default	profile	sample_stat_indexes	1432 kB	184 kB	1242		1301
etendo	pg_default	profile	sample_stat_user_functions	560 kB	88 kB	864		874
etendo	pg_default	profile	sample_stat_tables_total	336 kB	64 kB	152		176
etendo	pg_default	profile	sample_stat_database	232 kB	48 kB	68		76
etendo	pg_default	profile	last_stat_database	40 kB	32 kB	88		88
etendo	pg_default	profile	sample_stat_indexes_total	96 kB	32 kB	72		80
etendo	pg_default	profile	sample_statements_total	136 kB	32 kB	42		45
etendo	pg_default	profile	sample_statements_total(TOAST)
etendo	pg_default	profile	sample_stat_user_func_total	56 kB	32 kB	22		28
etendo	pg_default	public	ad_ep_instance_para	16 kB	8192 bytes	30		30
etendo	pg_default	public	ad_ep_instance_para(TOAST)
etendo	pg_default	profile	sample_stat_tables	7064 kB	8192 bytes	3454		3326

Top indexes by blocks fetched

DB	Tablespace	Schema	Table	Index	Scans	Blks	%Total
etendo	pg_default	public	m_product	m_product_key	3325083	6668136	4.45
etendo	pg_default	public	m_productprice	m_productprice_key	1511940	4550931	3.04
etendo	pg_default	public	m_product_trl	m_product_trl_product_langu_un	3467143	3468339	2.31
etendo	pg_default	public	fin_payment_schedule	fin_paym_sch_inv_idx	835441	2534710	1.69
etendo	pg_default	public	c_invoice	c_invoice_key	297462	1781628	1.19
etendo	pg_default	pg_catalog	pg_class	pg_class_oid_index	586352	1195012	0.80
etendo	pg_default	public	psat_activity_materials	psat_activity_mater_produni	8254	975652	0.65
etendo	pg_default	public	ad_tab	ad_tab_window	457402	923709	0.62
etendo	pg_default	public	c_invoice	c_invoice_bpartner	5338	902620	0.60
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc		880571	0.59
etendo	pg_default	public	c_invoice	c_invoice_posted	1380	700581	0.47
etendo	pg_default	public	c_invoice	c_invoice_paid		699284	0.47
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	303642	666225	0.44
etendo	pg_default	public	psat_checklist_result	psat_chcklist_res_result_uk	1104	658139	0.44
etendo	pg_default	public	c_invoice	c_invoice_salesrep		648442	0.43
etendo	pg_default	public	c_invoice	c_invoice_updated		594456	0.40
etendo	pg_default	public	c_invoice	c_invoice_docno		585498	0.39
etendo	pg_default	public	ad_textinterfaces	ad_textinterfaces_key	286881	581628	0.39
etendo	pg_default	public	c_debt_payment	c_debt_payment_invoice_idx	289222	579835	0.39
etendo	pg_default	public	c_settlement	c_settlement_key	160360	321786	0.21

DB	Tablespace	Schema	Table	Index	Scans	Blk Reads	%Total	Hits(%)
etendo	pg_default	public	psat_checklist_result	psat_chcklist_res_result_uk	1104	3351	0.74	99.49
etendo	pg_default	public	ad_audit_trail	ad_audit_trail_pk		2214	0.49	75.78
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc		1417	0.31	99.84
etendo	pg_default	public	c_invoice	c_invoice_paid		1205	0.27	99.83
etendo	pg_default	public	c_invoice	c_invoice_posted	1380	900	0.20	99.87
etendo	pg_default	public	ad_image(TOAST)	pg_toast_74472_index	6955	886	0.20	95.99
etendo	pg_default	public	c_orderline	c_orderline_order2	8456	757	0.17	97.06
etendo	pg_default	public	c_invoice	c_invoice_docno		716	0.16	99.88
etendo	pg_default	public	c_orderline	c_orderline_key	2207	599	0.13	91.26
etendo	pg_default	public	m_inoutline	m_inoutline_orderline	2464	577	0.13	92.30
etendo	pg_default	public	ad_session_usage_audit	ad_session_usage_audit_key		576	0.13	91.61
etendo	pg_default	public	c_invoice	c_invoice_updated		542	0.12	99.91
etendo	pg_default	public	c_invoice	c_invoice_bpartner	5338	458	0.10	99.95
etendo	pg_default	public	fin_payment_schedule	fin_payment_schedule_key	22032	404	0.09	99.26
etendo	pg_default	public	c_invoiceline	c_invoiceline_inoutline	453	354	0.08	74.01
etendo	pg_default	public	c_invoice	c_invoice_key	297462	344	0.08	99.98
etendo	pg_default	public	c_invoice	c_invoice_salesrep		309	0.07	99.95
etendo	pg_default	public	fin_payment_scheduledetail	fin_pay_scheduledetail_in	3375	308	0.07	97.03
etendo	pg_default	public	psat_checklist_result	psat_checklist_result_key	690	304	0.07	89.93
etendo	pg_default	public	fin_payment_schedule	fin_paym_sch_inv_idx	835441	256	0.06	99.99

Top growing indexes

DB	Tablespace	Schema	Table	Index	Index		Table
DB	Tablespace	Schema	Table	Index	Size	Growth	Ins	Upd	Del
etendo	pg_default	profile	sample_statements	ix_sample_stmts_qid	920 kB	320 kB	1196		1255
etendo	pg_default	public	ad_process_run	ad_process_run_key	432 kB	152 kB	185	185	315
etendo	pg_default	profile	sample_statements	pk_sample_statements_n	488 kB	56 kB	750		1020
etendo	pg_default	public	c_invoice	c_invoice_paid	2008 kB	32 kB		289533
etendo	pg_default	public	c_invoice	c_invoice_posted	1992 kB	24 kB		289533
etendo	pg_default	public	c_invoice	c_invoice_updated	1608 kB	24 kB		289533
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	736 kB	8192 bytes	24253		24253
etendo	pg_default	profile	sample_statements_total	pk_sample_statements_total	40 kB	8192 bytes	27		30

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	public	c_invoice	c_invoice_client_org_date_doc	3992 kB			289533
etendo	pg_default	public	c_invoice	c_invoice_docno	2144 kB			289533
etendo	pg_default	public	c_invoice	c_invoice_paid	2008 kB	32 kB		289533
etendo	pg_default	public	c_invoice	c_invoice_updated	1608 kB	24 kB		289533
etendo	pg_default	public	c_invoice	c_invoice_ad_user	1584 kB			289533
etendo	pg_default	public	c_invoice	c_invoice_bp_extref_idx	8192 bytes			289533
etendo	pg_default	public	c_invoice	c_invoice_salesrep	1920 kB	-16 kB		289533
etendo	pg_default	public	ad_process_run	ad_process_run_ould_be_killed	8192 bytes		264	264	315

User function statistics

Top functions by total time

DB	Schema	Function	Executions	Time (s)
DB	Schema	Function	Executions	Total	Self	Mean	Mean self
etendo	public	ad_org_isinnaturaltree	1850417	46.24	11.33	0.000	0.000
etendo	public	ad_isorgincluded	2836922	35.01	35.01	0.000	0.000
etendo	profile	take_sample	23	16.86	0.02	0.733	0.001
etendo	profile	take_sample_subset	23	16.84	0.06	0.732	0.003
etendo	profile	take_sample	23	16.77	1.70	0.729	0.074
etendo	public	ad_istriggerenabled	1160788	12.16	12.16	0.000	0.000
etendo	profile	collect_obj_stats	23	9.28	2.83	0.403	0.123
etendo	profile	dblink	621	7.90	7.90	0.013	0.013
etendo	public	to_char	9730604	6.13	6.13	0.000	0.000
etendo	public	ad_column_identifier	7729	3.91	3.88	0.001	0.001
etendo	profile	sample_dbobj_delta	23	3.62	3.62	0.158	0.158
etendo	public	to_number	777094	1.33	1.33	0.000	0.000
etendo	profile	collect_pg_stat_statements_stats	23	0.93	0.40	0.040	0.017
etendo	public	aprm_ispaymentconfirmed	10251	0.82	0.82	0.000	0.000
etendo	public	obequals	426605	0.46	0.46	0.000	0.000
etendo	public	c_order_post	4	0.37	0.00	0.092	0.000
etendo	public	c_order_post1	4	0.37	0.00	0.091	0.000
etendo	public	c_order_post1	4	0.37	0.14	0.091	0.034
etendo	public	get_uuid	4971	0.31	0.15	0.000	0.000
etendo	profile	dblink_connect	63	0.28	0.28	0.004	0.004

Top functions by executions

DB	Schema	Function	Executions	Time (s)
DB	Schema	Function	Executions	Total	Self	Mean	Mean self
etendo	public	to_char	9730604	6.13	6.13	0.000	0.000
etendo	public	ad_isorgincluded	2836922	35.01	35.01	0.000	0.000
etendo	public	ad_org_isinnaturaltree	1850417	46.24	11.33	0.000	0.000
etendo	public	ad_istriggerenabled	1160788	12.16	12.16	0.000	0.000
etendo	public	to_number	777094	1.33	1.33	0.000	0.000
etendo	public	obequals	426605	0.46	0.46	0.000	0.000
etendo	public	to_char	19732	0.06	0.06	0.000	0.000
etendo	public	uuid_generate_v4	14913	0.16	0.16	0.000	0.000
etendo	public	substract_days	13573	0.01	0.01	0.000	0.000
etendo	public	aprm_ispaymentconfirmed	10251	0.82	0.82	0.000	0.000
etendo	public	ad_column_identifier	7729	3.91	3.88	0.001	0.001
etendo	public	get_uuid	4971	0.31	0.15	0.000	0.000
etendo	public	add_days	3680	0.00	0.00	0.000	0.000
etendo	public	prouti_qtyremainingorderline	2813	0.21	0.21	0.000	0.000
etendo	public	to_date	1650	0.01	0.01	0.000	0.000
etendo	public	lowerequaltimestamp	1452	0.01	0.01	0.000	0.000
etendo	public	prouti_delavailablewithoutres	657	0.15	0.15	0.000	0.000
etendo	public	prouti_deliveryavailable	632	0.13	0.13	0.000	0.000
etendo	profile	dblink	621	7.90	7.90	0.013	0.013
etendo	public	to_date	525	0.01	0.01	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	c_invoice_trg	289533	24.25	18.44	0.000	0.000
etendo	public	c_invoice_trg2	289533	7.11	4.59	0.000	0.000
etendo	public	einv_gene_chk_restrictions_trg	289533	4.93	2.76	0.000	0.000
etendo	public	pruti_inherit_invoice_contact	289533	4.30	2.73	0.000	0.000
etendo	public	au_m_product_trg	17	0.49	0.44	0.029	0.026
etendo	public	au_advcrm_activity_trg	101	0.30	0.27	0.003	0.003
etendo	public	c_orderline_trg2	102	0.25	0.10	0.002	0.001
etendo	public	au_c_bpartner_trg	9	0.20	0.20	0.023	0.022
etendo	public	ad_preference_mod_trg	547	0.17	0.15	0.000	0.000
etendo	public	au_psat_request_trg	19	0.11	0.10	0.006	0.005
etendo	public	m_inoutline_trg	34	0.08	0.04	0.002	0.001
etendo	public	c_orderlinetax_trg	57	0.07	0.05	0.001	0.001
etendo	public	ad_process_request_trg	318	0.07	0.05	0.000	0.000
etendo	public	c_orderline_trg	102	0.06	0.06	0.001	0.001
etendo	public	cus_act_log_desc_ol_trg	18	0.06	0.02	0.003	0.001
etendo	public	m_product_trg	17	0.05	0.05	0.003	0.003
etendo	public	advcrm_create_activity	99	0.05	0.02	0.001	0.000
etendo	public	au_psat_activity_materials_trg	11	0.04	0.04	0.004	0.003
etendo	public	c_orderline2_trg	102	0.04	0.03	0.000	0.000
etendo	public	au_m_productprice_trg	9	0.04	0.03	0.004	0.003

Vacuum-related statistics

Top tables by vacuum operations

DB	Tablespace	Schema	Table	Vacuum count	Autovacuum count	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	profile	last_stat_tables		26	32890	3454	32890	49
etendo	pg_default	profile	last_stat_indexes		26	54119	1294	54119	1
etendo	pg_default	profile	last_stat_user_functions		26	8257	888	8257	37
etendo	pg_default	public	c_invoice		23		289533
etendo	pg_default	pg_catalog	pg_statistic		2		16424		13278
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	129
postgres	pg_default	pg_catalog	pg_statistic		1		478		374
etendo	pg_default	pg_catalog	pg_type		1	2171		2171
etendo	pg_default	pg_catalog	pg_attribute		1	24253		24253
etendo	pg_default	pg_catalog	pg_class		1	1879	6728	1879	1376
etendo	pg_default	pg_catalog	pg_index		1	527		527
etendo	pg_default	public	ad_pinstance	1				47
etendo	pg_default	public	ad_process_run	1		307	307	315
etendo	pg_default	public	m_stock_proposed	1				1
etendo	pg_default	public	prsync_entry	1		757	1515	215	1476
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	32890	3454	32890	49
etendo	pg_default	profile	last_stat_indexes	47	23	54119	1294	54119	1
etendo	pg_default	profile	last_stat_user_functions	47	23	8257	888	8257	37
etendo	pg_default	public	c_invoice	1	23		289533
etendo	pg_default	profile	last_stat_tablespaces	24		46		46
etendo	pg_default	public	ad_session	1	15	59	1977		1920
etendo	pg_default	public	ad_process_request	1	5	3	302		298
etendo	pg_default	public	ad_preference		5		553		531
etendo	pg_default	public	prsync_entry	2	2	757	1515	215	1476
postgres	pg_global	pg_catalog	pg_pltemplate	3
postgres	pg_global	pg_catalog	pg_tablespace	3
postgres	pg_global	pg_catalog	pg_shdepend	3		712		712
postgres	pg_global	pg_catalog	pg_authid	3
postgres	pg_global	pg_catalog	pg_auth_members	3
postgres	pg_global	pg_catalog	pg_database	3
postgres	pg_global	pg_catalog	pg_db_role_setting	3
postgres	pg_global	pg_catalog	pg_shseclabel	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

Top indexes by estimated vacuum load

DB	Tablespace	Schema	Table	Index	~Vacuum bytes	Vacuum cnt	Autovacuum cnt	IX size	Relsize
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc	90 MB		23	3992 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_key	62 MB		23	2752 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_bpartner	57 MB		23	2525 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_docno	48 MB		23	2144 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_paid	44 MB		23	1938 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_posted	44 MB		23	1937 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_salesrep	42 MB		23	1853 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_updated	36 MB		23	1583 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_ad_user	35 MB		23	1566 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_order	29 MB		23	1304 kB	23 MB
etendo	pg_default	profile	last_stat_indexes	pk_last_stat_indexes	10 MB		26	395 kB	1529 kB
etendo	pg_default	profile	last_stat_tables	pk_last_stat_tables	5680 kB		26	217 kB	1215 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	1128 kB		1	1128 kB	4768 kB
etendo	pg_default	pg_catalog	pg_statistic	pg_statistic_relid_att_inh_index	752 kB		2	376 kB	4796 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	736 kB		1	736 kB	4768 kB
etendo	pg_default	public	prsync_entry	prsync_entry_key	472 kB	1		472 kB	4136 kB
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	pg_toast_2619_index	368 kB		4	93 kB	4400 kB
etendo	pg_default	public	ad_process_run	ad_process_run_ad_prequest_id	328 kB	1		328 kB	10 MB
etendo	pg_default	public	ad_process_run	ad_process_run_key	312 kB	1		312 kB	10 MB
etendo	pg_default	public	prsync_entry(TOAST)	pg_toast_137611_index	256 kB	1	1	128 kB	6768 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	Size
etendo	pg_temp_8	ad_context_info	1	100926	99	6688 kB
etendo	profile	sample_stat_tables	24254	3156	11	7064 kB
etendo	public	ad_process_run	5140	531	9	11 MB
etendo	public	fin_payment_schedule	60619	14	0	15 MB

Top tables by modified tuples ratio

Table shows modified tuples statistics since last analyze.

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

DB	Schema	Table	Live	Dead	Mod	%Mod	Last AA	Size
etendo	pg_temp_8	ad_context_info	1	100926	201853	199		6688 kB
etendo	profile	sample_stat_tables	24254	3156	1136	4	2026-07-17 22:00:41.915738+02	7064 kB
etendo	public	ad_process_run	5140	531	202	3	2026-07-17 19:29:38.788053+02	11 MB
etendo	public	fin_payment_schedule	60619	14	20	0	2025-05-14 08:30:29.130156+02	15 MB

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	1572864	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	1048576	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-16 05:00:04.153843+02
pg_conf_load_time	2026-07-17 05:00:03.984525+02			2026-07-17 06:00:02+02
pg_postmaster_start_time	2026-07-16 05:00:04.286147+02
pg_postmaster_start_time	2026-07-17 05:00:04.118924+02			2026-07-17 06:00:02+02
pg_stat_statements.max	10000		/etc/postgresql/10/main/postgresql.conf:663
pg_stat_statements.track	all		/etc/postgresql/10/main/postgresql.conf:664
random_page_cost	1.1		/etc/postgresql/10/main/postgresql.conf:307
server_encoding	UTF8
shared_buffers	524288	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	10485	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	6922115330454611200
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