Postgres profile report (StartID: 498, EndID: 521)

pg_profile version 0.3.6

Server name: local

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

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

Report sections

Server statistics

Database statistics
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	201740	40		99.67	516726	158474161	397870820	30637554	668458	322813	431133			2854 MB	1536 kB
postgres	11867			99.84	1159	703039	1985068	365335	2012	866	1772			6383 kB	8192 bytes
Total	213607	40		99.68	517885	159177200	399855888	31002889	670470	323679	432905			2860 MB	1544 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	3809508	746.01			40.42	81170597	90103396	201231	2416			10469	106	17788
postgres	5619	12.93				127318		223						349
template1	6350	8.99				47957		235						278
Total	3821477	767.93			40.42	81345872	90103396	201689	2416			10469	106	18415

Cluster statistics

Metric	Value
Scheduled checkpoints	275
Requested checkpoints	1
Checkpoint write time (s)	9466.58
Checkpoint sync time (s)	3.86
Checkpoints buffers written	112443
Background buffers written
Backend buffers written	142512
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated	504118
WAL generated	3659 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

Tablespace	Path	Size	Growth
pg_default		2874 MB	1552 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	150.55	19.61		150554.938	150554.938	150554.938		1
73e3636bec [f410d7e7]	etendo	70.76	9.21	288351	0.245	0.132	12.194	0.081	288351
e4360f260c [88d6e75c]	etendo	63.75	8.30	3	21248.993	0.201	63746.524	30050.293	3
1af62bac16 [debbd96a]	etendo	51.53	6.71	69008	25763.727	25634.808	25892.645	128.919	2
228d74fbf5 [cd9c0fd2]	etendo	36.57	4.76	13445	36574.472	36574.472	36574.472		1
9974be53aa [9cfc287]	etendo	34.73	4.52	100857	0.344	0.007	5.526	0.173	100857
6f5312535e [75b8a9cd]	etendo	32.72	4.26	73939	0.432	0.069	2.129	0.093	75756
8b2efa3bb8 [5d8577b1]	etendo	28.21	3.67	88409	0.319	0.007	6.541	0.160	88409
44dc303aa7 [5048ce93]	etendo	17.75	2.31	14302	1.095	0.968	7.517	0.175	16210
0c133f89fa [47df1ade]	etendo	16.67	2.17	23	724.988	655.531	991.448	81.738	23
b9bb8a4422 [eb812a48]	etendo	16.67	2.17		724.788	655.357	991.157	81.730	23
1e7d029944 [6d5528b2]	etendo	13.70	1.78	1749	595.450	564.083	641.718	21.050	23
4108c96b3f [ca2988bd]	etendo	11.80	1.54	872	178.734	120.140	896.332	175.917	66
671fe12038 [66c83919]	etendo	9.11	1.19	1898025	9105.043	9105.043	9105.043		1
3954a8172d [408c9f6]	etendo	9.03	1.18	37843	0.239	0.007	3.935	0.127	37843
c2b6cfc2bf [ad3afc69]	etendo	7.20	0.94	987125	2.642	1.026	10.657	1.393	2724
9c83facac5 [411377d4]	etendo	6.92	0.90	16210	0.344	0.313	2.958	0.063	20107
503324b603 [d34207c3]	etendo	6.20	0.81	253552	0.021	0.005	5.135	0.015	289285
1d911b5cd9 [1c4d8fed]	etendo	5.64	0.73	1454	3.877	1.818	14.347	1.486	1454
0b651ca53d [7318d810]	etendo	5.41	0.70	674405	5409.626	5409.626	5409.626		1

Top SQL by executions

Query ID	Database	Executions	%Total	Rows	Mean(ms)	Min(ms)	Max(ms)	StdErr(ms)	Elapsed(s)
c9e2eb425b [de5cc8a]	etendo	461478	12.08	362923	0.003	0.002	1.478	0.003	1.3
9625146448 [b7edb1a4]	etendo	289711	7.58	289711	0.010	0.007	0.935	0.005	2.9
0c13a0abe2 [4ed26d58]	etendo	289300	7.57	31327	0.010	0.006	1.358	0.006	3.0
503324b603 [d34207c3]	etendo	289285	7.57	253552	0.021	0.005	5.135	0.015	6.2
73e3636bec [f410d7e7]	etendo	288351	7.55	288351	0.245	0.132	12.194	0.081	70.8
9ea37f4950 [39cec726]	etendo	256410	6.71	256410	0.009	0.007	0.844	0.005	2.4
df99961951 [9cb9259b]	etendo	162949	4.26	162949	0.018	0.012	1.619	0.008	2.9
1b3d7b3f6d [a00bdbff]	etendo	114983	3.01		0.007	0.004	0.331	0.003	0.8
915a7e9440 [98fb8dd5]	etendo	100881	2.64	100881	0.005	0.003	0.416	0.004	0.5
9974be53aa [9cfc287]	etendo	100857	2.64	100857	0.344	0.007	5.526	0.173	34.7
891e82e5c1 [5a0bb3c]	etendo	100827	2.64	100827	0.003	0.002	0.283	0.001	0.3
3206d9f66d [ed220fa0]	etendo	88417	2.31	88417	0.005	0.002	0.931	0.006	0.4
8b2efa3bb8 [5d8577b1]	etendo	88409	2.31	88409	0.319	0.007	6.541	0.160	28.2
6f5312535e [75b8a9cd]	etendo	75756	1.98	73939	0.432	0.069	2.129	0.093	32.7
f3d76f43df [dfbb15d8]	etendo	68998	1.81	68998	0.038	0.035	0.366	0.004	2.6
5c208ba241 [381eb299]	etendo	53720	1.41	53720	0.014	0.010	0.235	0.004	0.8
fa1b74d06f [c1b84187]	etendo	49288	1.29	359291	0.040	0.015	1.060	0.039	2.0
ebd66f2e50 [2f2197e3]	etendo	49288	1.29	30767	0.013	0.005	0.366	0.008	0.7
12e891cf77 [7183adf7]	etendo	37845	0.99	37845	0.005	0.003	0.547	0.006	0.2
3954a8172d [408c9f6]	etendo	37843	0.99	37843	0.239	0.007	3.935	0.127	9.0

Top SQL by shared blocks fetched

Query ID	Database	blks fetched	%Total	Hits(%)	Elapsed(s)	Rows	Executions
73e3636bec [f410d7e7]	etendo	9538480	11.73	99.97	70.8	288351	288351
1af62bac16 [debbd96a]	etendo	5901861	7.26	100.00	51.5	69008	2
44dc303aa7 [5048ce93]	etendo	5414140	6.66	100.00	17.7	14302	16210
6f5312535e [75b8a9cd]	etendo	4975616	6.12	100.00	32.7	73939	75756
0c133f89fa [47df1ade]	etendo	4779936	5.88	99.98	16.7	23	23
b9bb8a4422 [eb812a48]	etendo	4779798	5.88	99.98	16.7		23
c2b6cfc2bf [ad3afc69]	etendo	4383916	5.39	100.00	7.2	987125	2724
adb1c31f79 [948be82f]	etendo	3038387	3.74	84.24	150.6		1
4108c96b3f [ca2988bd]	etendo	3023870	3.72	99.99	11.8	872	66
9c83facac5 [411377d4]	etendo	2403546	2.95	100.00	6.9	16210	20107
58d3d7b94c [303fdc1e]	etendo	2265924	2.79	100.00	1.2	2304	23
785a907bc3 [92946197]	etendo	1634863	2.01	99.97	4.6	1060	23
5fa24dc926 [22217272]	etendo	1618119	1.99	100.00	2.1	51037	23
29e9be51ce [b8952a6a]	etendo	1053306	1.29	100.00	1.6	5544	924
75cdc9279a [c0534667]	etendo	988206	1.21	100.00	2.6	2	2
f286a2747c [4221d0a4]	etendo	961174	1.18	100.00	0.8	18	18
1e7d029944 [6d5528b2]	etendo	915533	1.13	100.00	13.7	1749	23
9625146448 [b7edb1a4]	etendo	901823	1.11	100.00	2.9	289711	289711
0c13a0abe2 [4ed26d58]	etendo	899660	1.11	100.00	3.0	31327	289300
11b3a7981f [61e12bc8]	etendo	877462	1.08	99.93	2.1	107	3

Query ID	Database	Reads	%Total	Hits(%)	Elapsed(s)	Rows	Executions
adb1c31f79 [948be82f]	etendo	478730	93.74	84.24	150.6		1
f8cc1c12b0 [4f2bfd2e]	etendo	3227	0.63	98.50	0.7	9	7
73e3636bec [f410d7e7]	etendo	2490	0.49	99.97	70.8	288351	288351
50b8978166 [b54ea3e2]	etendo	2097	0.41	98.19	0.7		16
12a81791af [7eea2aca]	etendo	1780	0.35	95.60	0.1	3985	3985
0c247acdf0 [948be82f]	template1	973	0.19	97.61	2.8		1
0c133f89fa [47df1ade]	etendo	967	0.19	99.98	16.7	23	23
b9bb8a4422 [eb812a48]	etendo	967	0.19	99.98	16.7		23
2e0b729b87 [948be82f]	postgres	948	0.19	97.66	2.9		1
b8b9950890 [532de794]	etendo	670	0.13	98.64	0.6	1786	1786
9cbca4d83c [b7b6a128]	etendo	659	0.13	86.79	0.1	542	542
11b3a7981f [61e12bc8]	etendo	657	0.13	99.93	2.1	107	3
cbb0d2e65e [4ec9dd54]	etendo	561	0.11	92.10	0.2	8	8
6951a2f5d4 [43f0ca83]	etendo	553	0.11	88.09	0.0	211	211
de891c1f5b [a3acbb25]	etendo	548	0.11	89.29	0.0		4
833f4dacaa [4ad53bb0]	etendo	518	0.10	99.70	0.7	185	185
785a907bc3 [92946197]	etendo	496	0.10	99.97	4.6	1060	23
ec2a223d8f [313e71e6]	etendo	340	0.07	1.16	0.0	1	1
c35de5a948 [cea8e40e]	etendo	305	0.06	99.76	1.0	129	6
9425961593 [7e6ec72b]	etendo	299	0.06	99.71	0.5	33433	25326

Top SQL by shared blocks dirtied

Query ID	Database	Dirtied	%Total	Hits(%)	Elapsed(s)	Rows	Executions
73e3636bec [f410d7e7]	etendo	66911	33.18	99.97	70.8	288351	288351
adb1c31f79 [948be82f]	etendo	62841	31.16	84.24	150.6		1
0c133f89fa [47df1ade]	etendo	15908	7.89	99.98	16.7	23	23
b9bb8a4422 [eb812a48]	etendo	15908	7.89	99.98	16.7		23
fdd1193fad [3b0e4e8a]	etendo	4204	2.08	99.96	3.5	54119	46
d0b36135c7 [a0544a5f]	etendo	3190	1.58	99.97	3.7	32888	46
b8b9950890 [532de794]	etendo	2738	1.36	98.64	0.6	1786	1786
140f3eb685 [59d1e156]	etendo	1851	0.92	99.56	1.0	23	23
c525c04235 [d2f1c69a]	etendo	1453	0.72	99.28	0.1	278	278
9b16673e73 [423e83ff]	etendo	1279	0.63	98.93	0.1		1
f68dd8a1a9 [d422fd3a]	etendo	891	0.44	100.00	0.6		40
4813705ddb [6f2d0383]	etendo	806	0.40	100.00	0.3	1333	1333
9cbca4d83c [b7b6a128]	etendo	670	0.33	86.79	0.1	542	542
cbb0d2e65e [4ec9dd54]	etendo	556	0.28	92.10	0.2	8	8
cc93eb92d8 [48b1758d]	etendo	475	0.24	99.72	1.3	16	16
032d1e73d2 [fe5aed7e]	etendo	475	0.24	99.72	1.3	16	16
bda4372001 [a3318de1]	etendo	415	0.21	99.88	0.1	2408	17
65758f3c61 [2616291e]	etendo	382	0.19	99.94	0.2	5744	32
1e7f08819e [c94f617e]	etendo	353	0.18	95.65	0.0	48	48
07181527b0 [f6f43f8d]	etendo	348	0.17	100.00	0.0	25883	11

Top SQL by shared blocks written

Query ID	Database	Written	%Total	%BackendW	Hits(%)	Elapsed(s)	Executions
adb1c31f79 [948be82f]	etendo	58281	22.86	40.90	84.24	150.6	1
0c247acdf0 [948be82f]	template1	55	0.02	0.04	97.61	2.8	1
2e0b729b87 [948be82f]	postgres	55	0.02	0.04	97.66	2.9	1

Query ID

Database

Written

%Total

%BackendW

Hits(%)

Elapsed(s)

Rows

Executions

adb1c31f79

[948be82f]

etendo

58281

22.86

40.90

84.24

150.6

0c247acdf0

[948be82f]

template1

0.02

0.04

97.61

2.8

2e0b729b87

[948be82f]

postgres

0.02

0.04

97.66

2.9

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
7ed479c7e5 [1b1541f8]	etendo	8057	0.16	106	100.00	8044	76.84					0.1	7	7
915a7e9440 [98fb8dd5]	etendo	103389	99.19			839	8.01					0.5	100881	100881
3206d9f66d [ed220fa0]	etendo	90613	99.19			735	7.02					0.4	88417	88417
12e891cf77 [7183adf7]	etendo	38787	99.18			317	3.03					0.2	37845	37845
80f5bc22ff [136114ff]	etendo	25941	99.18			212	2.03					0.1	25314	25314
b8baa88ff6 [39aea14e]	etendo	25829	99.18			212	2.03					0.1	25202	25202
61bc3cba28 [ee759ab3]	etendo	12913	99.19			104	0.99					0.1	12601	12601
71d20126f7 [598f1cd0]	etendo	207	98.07			4	0.04					0.0	204	204
5be93a04bd [7e394a5]	etendo	1				1	0.01					0.0	1	1
c7ac2b0d2b [a9a223ef]	etendo	7	85.71			1	0.01					0.0	7	7

Complete list of SQL texts

QueryID	Query Text
3954a8172d	delete from ad_context_info
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
5be93a04bd	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
9974be53aa	delete from ad_context_info
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
80f5bc22ff	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
7ed479c7e5	delete from ad_context_info
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)
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 )
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)
ec2a223d8f	select advcrmacti0_.Advcrm_Activity_ID as Advcrm_A9_143_1_, advcrmacti0_.Advcrm_Activity_Related_ID as Advcrm_A1_143_1_, advcrmacti0_.Advcrm_Activity_Related_ID as Advcrm_A1_143_0_, advcrmacti0_.AD_Client_ID as AD_Clien2_143_0_, advcrmacti0_.AD_Org_ID as AD_Org_I3_143_0_, advcrmacti0_.Created as Created4_143_0_, advcrmacti0_.Createdby as Createdb5_143_0_, advcrmacti0_.Updated as Updated6_143_0_, advcrmacti0_.Updatedby as Updatedb7_143_0_, advcrmacti0_.Isactive as Isactive8_143_0_, advcrmacti0_.Advcrm_Activity_ID as Advcrm_A9_143_0_, advcrmacti0_.Related_To as Related10_143_0_, advcrmacti0_.C_Bpartner_ID as C_Bpart11_143_0_, advcrmacti0_.C_Order_ID as C_Order12_143_0_, advcrmacti0_.C_Invoice_ID as C_Invoi13_143_0_, advcrmacti0_.C_Project_ID as C_Proje14_143_0_, advcrmacti0_.M_Product_ID as M_Produ15_143_0_, advcrmacti0_.Advcrm_Opportunity_ID as Advcrm_16_143_0_, advcrmacti0_.Advcrm_Lead_ID as Advcrm_17_143_0_, advcrmacti0_.EM_Psat_Request_ID as EM_Psat18_143_0_, advcrmacti0_.Quotation_ID as Quotati19_143_0_ from advcrm_activity_related advcrmacti0_ where advcrmacti0_.Advcrm_Activity_ID=$1
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
b8baa88ff6	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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 )
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
f286a2747c	SELECT COALESCE(SUM(AMTACCTCR-AMTACCTDR), $5) AS NAME FROM FACT_ACCT, C_PERIOD, C_YEAR, (SELECT C_ELEMENTVALUE_ID FROM C_ELEMENTVALUE WHERE C_ELEMENTVALUE.ACCOUNTTYPE = $1) AA WHERE FACT_ACCT.C_PERIOD_ID = C_PERIOD.C_PERIOD_ID AND C_PERIOD.C_YEAR_ID = C_YEAR.C_YEAR_ID AND FACT_ACCT.ACCOUNT_ID = AA.C_ELEMENTVALUE_ID AND FACT_ACCT.FACTACCTTYPE <> $6 AND $7=$8 AND FACT_ACCT.DATEACCT >= TO_DATE($2) AND FACT_ACCT.DATEACCT < TO_DATE($3) AND FACT_ACCT.C_ACCTSCHEMA_ID = $4 AND C_YEAR.YEAR IN ($9) AND FACT_ACCT.AD_ORG_ID IN ($10)
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()
cc93eb92d8	SELECT * FROM C_Invoice_Post0($1)
833f4dacaa	SELECT COALESCE(SUM(AMTACCTDR),$4) AS TOTALACCTDR, COALESCE(SUM(AMTACCTCR),$5) AS TOTALACCTCR, COALESCE(SUM(AMTACCTDR-AMTACCTCR),$6) AS TOTAL FROM FACT_ACCT WHERE $7=$8 AND FACT_ACCT.C_ACCTSCHEMA_ID = $1 AND FACT_ACCT.ACCOUNT_ID = $2 AND DATEACCT < TO_DATE($3) AND FACT_ACCT.AD_ORG_ID IN ($9)
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))
71d20126f7	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)
8b2efa3bb8	delete from ad_context_info
11b3a7981f	select invoicecan0_.C_Order_ID as col_0_0_, organizati2_.Name as col_1_0_, invoicecan0_.C_Doctype_ID as col_2_0_, invoicecan0_.Documentno as col_3_0_, businesspa3_.Name as col_4_0_, invoicecan0_.Dateordered as col_5_0_, case when $5=$6 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end as col_6_0_, case when invoicecan0_.Term=$7 then $8 when invoicecan0_.Term=$9 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $10=$11 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $12=$13 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end as col_7_0_, invoicecan0_.Term as col_8_0_, case when invoicecan0_.Term=$14 then $15 when invoicecan0_.Term=$16 then case when invoicecan0_.Term=$17 then $18 when invoicecan0_.Term=$19 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then case when $20=$21 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end else case when $22=$23 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end end when invoicecan0_.Term=$24 and invoicecan0_.Qtydelivered<invoicecan0_.Qtyordered then $25 else invoicecan0_.Pendinglines end as col_9_0_, invoicecan0_.Qtyordered as col_10_0_, invoicecan0_.Qtydelivered as col_11_0_, case when $26=$27 then invoicecan0_.Amountlinesgross else invoicecan0_.Amountlines end-(case when $28=$29 then invoicecan0_.Notinvoicedlinesgross else invoicecan0_.Notinvoicedlines end) as col_12_0_, invoicecan0_.Amountlinesgross as col_13_0_, invoicecan0_.Created as col_14_0_, invoicecan0_.Createdby as col_15_0_, invoicecan0_.Updated as col_16_0_, invoicecan0_.Updatedby as col_17_0_, documentty4_.C_DocType_ID as C_DocTyp1_225_0_, aduser5_.AD_User_ID as AD_User_1_129_1_, aduser6_.AD_User_ID as AD_User_1_129_2_, documentty4_.AD_Client_ID as AD_Clien2_225_0_, documentty4_.AD_Org_ID as AD_Org_I3_225_0_, documentty4_.IsActive as IsActive4_225_0_, documentty4_.Created as Created5_225_0_, documentty4_.CreatedBy as CreatedB6_225_0_, documentty4_.Updated as Updated7_225_0_, documentty4_.UpdatedBy as UpdatedB8_225_0_, documentty4_.Name as Name9_225_0_, documentty4_.PrintName as PrintNa10_225_0_, documentty4_.Description as Descrip11_225_0_, documentty4_.DocBaseType as DocBase12_225_0_, documentty4_.IsSOTrx as IsSOTrx13_225_0_, documentty4_.DocSubTypeSO as DocSubT14_225_0_, documentty4_.C_DocTypeShipment_ID as C_DocTy15_225_0_, documentty4_.C_DocTypeInvoice_ID as C_DocTy16_225_0_, documentty4_.IsDocNoControlled as IsDocNo17_225_0_, documentty4_.DocNoSequence_ID as DocNoSe18_225_0_, documentty4_.GL_Category_ID as GL_Cate19_225_0_, documentty4_.DocumentNote as Documen20_225_0_, documentty4_.IsDefault as IsDefau21_225_0_, documentty4_.DocumentCopies as Documen22_225_0_, documentty4_.AD_Table_ID as AD_Tabl23_225_0_, documentty4_.Orgfiltered as Orgfilt24_225_0_, documentty4_.C_Doctype_Reversed_ID as C_Docty25_225_0_, documentty4_.IsExpense as IsExpen26_225_0_, documentty4_.Isreversal as Isrever27_225_0_, documentty4_.IsReturn as IsRetur28_225_0_, documentty4_.C_Doctypeorder_ID as C_Docty29_225_0_, documentty4_.C_Doctypesimpinvoice_ID as C_Docty30_225_0_, documentty4_.EM_OBWPL_Useoutbound as EM_OBWP31_225_0_, documentty4_.EM_Prouti_C_Doctypeorder_ID as EM_Prou32_225_0_, documentty4_.C_Doctypeaggrinvoice_ID as C_Docty33_225_0_, documentty4_.EM_OBWPL_IsGroup as EM_OBWP34_225_0_, documentty4_.EM_OBWPL_GenerateShipment as EM_OBWP35_225_0_, documentty4_.EM_OBWPL_Shipmentdoctype_ID as EM_OBWP36_225_0_, documentty4_.EM_Pruti_Inforeport2 as EM_Prut37_225_0_, documentty4_.EM_Pruti_Inforeport as EM_Prut38_225_0_, aduser5_.AD_Client_ID as AD_Clien2_129_1_, aduser5_.AD_Org_ID as AD_Org_I3_129_1_, aduser5_.IsActive as IsActive4_129_1_, aduser5_.Created as Created5_129_1_, aduser5_.CreatedBy as CreatedB6_129_1_, aduser5_.Updated as Updated7_129_1_, aduser5_.UpdatedBy as UpdatedB8_129_1_, aduser5_.Name as Name9_129_1_, aduser5_.Description as Descrip10_129_1_, aduser5_.Password as Passwor11_129_1_, aduser5_.Email as Email12_129_1_, aduser5_.Supervisor_ID as Supervi13_129_1_, aduser5_.C_BPartner_ID as C_BPart14_129_1_, aduser5_.Processing as Process15_129_1_, aduser5_.EmailUser as EmailUs16_129_1_, aduser5_.EmailUserPW as EmailUs17_129_1_, aduser5_.C_BPartner_Location_ID as C_BPart18_129_1_, aduser5_.C_Greeting_ID as C_Greet19_129_1_, aduser5_.Title as Title20_129_1_, aduser5_.Comments as Comment21_129_1_, aduser5_.Phone as Phone22_129_1_, aduser5_.Phone2 as Phone23_129_1_, aduser5_.Fax as Fax24_129_1_, aduser5_.LastContact as LastCon25_129_1_, aduser5_.LastResult as LastRes26_129_1_, aduser5_.Birthday as Birthda27_129_1_, aduser5_.AD_OrgTrx_ID as AD_OrgT28_129_1_, aduser5_.Firstname as Firstna29_129_1_, aduser5_.Lastname as Lastnam30_129_1_, aduser5_.UserName as UserNam31_129_1_, aduser5_.Default_Ad_Client_ID as Default32_129_1_, aduser5_.Default_Ad_Language as Default33_129_1_, aduser5_.Default_Ad_Org_ID as Default34_129_1_, aduser5_.Default_Ad_Role_ID as Default35_129_1_, aduser5_.Default_M_Warehouse_ID as Default36_129_1_, aduser5_.IsLocked as IsLocke37_129_1_, aduser5_.AD_Image_ID as AD_Imag38_129_1_, aduser5_.Grant_Portal_Access as Grant_P39_129_1_, aduser5_.LastPasswordUpdate as LastPas40_129_1_, aduser5_.Isexpiredpassword as Isexpir41_129_1_, aduser5_.Commercialauth as Commerc42_129_1_, aduser5_.Viasms as Viasms43_129_1_, aduser5_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_1_, aduser5_.Viaemail as Viaemai45_129_1_, aduser5_.EM_Pruti_Isbillingcontact as EM_Prut46_129_1_, aduser5_.EM_Advcrm_Newsletter as EM_Advc47_129_1_, aduser5_.EM_Pruti_Isordercontact as EM_Prut48_129_1_, aduser5_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_1_, aduser5_.EM_Advcrm_sat_user as EM_Advc50_129_1_, aduser6_.AD_Client_ID as AD_Clien2_129_2_, aduser6_.AD_Org_ID as AD_Org_I3_129_2_, aduser6_.IsActive as IsActive4_129_2_, aduser6_.Created as Created5_129_2_, aduser6_.CreatedBy as CreatedB6_129_2_, aduser6_.Updated as Updated7_129_2_, aduser6_.UpdatedBy as UpdatedB8_129_2_, aduser6_.Name as Name9_129_2_, aduser6_.Description as Descrip10_129_2_, aduser6_.Password as Passwor11_129_2_, aduser6_.Email as Email12_129_2_, aduser6_.Supervisor_ID as Supervi13_129_2_, aduser6_.C_BPartner_ID as C_BPart14_129_2_, aduser6_.Processing as Process15_129_2_, aduser6_.EmailUser as EmailUs16_129_2_, aduser6_.EmailUserPW as EmailUs17_129_2_, aduser6_.C_BPartner_Location_ID as C_BPart18_129_2_, aduser6_.C_Greeting_ID as C_Greet19_129_2_, aduser6_.Title as Title20_129_2_, aduser6_.Comments as Comment21_129_2_, aduser6_.Phone as Phone22_129_2_, aduser6_.Phone2 as Phone23_129_2_, aduser6_.Fax as Fax24_129_2_, aduser6_.LastContact as LastCon25_129_2_, aduser6_.LastResult as LastRes26_129_2_, aduser6_.Birthday as Birthda27_129_2_, aduser6_.AD_OrgTrx_ID as AD_OrgT28_129_2_, aduser6_.Firstname as Firstna29_129_2_, aduser6_.Lastname as Lastnam30_129_2_, aduser6_.UserName as UserNam31_129_2_, aduser6_.Default_Ad_Client_ID as Default32_129_2_, aduser6_.Default_Ad_Language as Default33_129_2_, aduser6_.Default_Ad_Org_ID as Default34_129_2_, aduser6_.Default_Ad_Role_ID as Default35_129_2_, aduser6_.Default_M_Warehouse_ID as Default36_129_2_, aduser6_.IsLocked as IsLocke37_129_2_, aduser6_.AD_Image_ID as AD_Imag38_129_2_, aduser6_.Grant_Portal_Access as Grant_P39_129_2_, aduser6_.LastPasswordUpdate as LastPas40_129_2_, aduser6_.Isexpiredpassword as Isexpir41_129_2_, aduser6_.Commercialauth as Commerc42_129_2_, aduser6_.Viasms as Viasms43_129_2_, aduser6_.EM_Sgpcrm_Securitygroups_ID as EM_Sgpc44_129_2_, aduser6_.Viaemail as Viaemai45_129_2_, aduser6_.EM_Pruti_Isbillingcontact as EM_Prut46_129_2_, aduser6_.EM_Advcrm_Newsletter as EM_Advc47_129_2_, aduser6_.EM_Pruti_Isordercontact as EM_Prut48_129_2_, aduser6_.EM_Smfsws_Default_Ws_Role_ID as EM_Smfs49_129_2_, aduser6_.EM_Advcrm_sat_user as EM_Advc50_129_2_ from c_invoice_candidate_v invoicecan0_ inner join C_Order order1_ on invoicecan0_.C_Order_ID=order1_.C_Order_ID inner join AD_Org organizati2_ on invoicecan0_.AD_Org_ID=organizati2_.AD_Org_ID inner join C_BPartner businesspa3_ on invoicecan0_.C_Bpartner_ID=businesspa3_.C_BPartner_ID inner join C_DocType documentty4_ on invoicecan0_.C_Doctype_ID=documentty4_.C_DocType_ID inner join AD_User aduser5_ on invoicecan0_.Createdby=aduser5_.AD_User_ID inner join AD_User aduser6_ on invoicecan0_.Updatedby=aduser6_.AD_User_ID where (invoicecan0_.Term=$30 and invoicecan0_.Qtydelivered<>$31 and ($32=$33 and (exists (select $34 from C_OrderLine orderline7_ where orderline7_.C_Order_ID=order1_.C_Order_ID and orderline7_.QtyDelivered-orderline7_.QtyInvoiced<>$35)) or $36=$37) or invoicecan0_.Term=$38 and (exists (select $39 from C_OrderLine orderline8_ where orderline8_.C_Order_ID=order1_.C_Order_ID and orderline8_.QtyOrdered-orderline8_.QtyInvoiced<>$40)) or invoicecan0_.Term=$41 and (exists (select $42 from C_OrderLine orderline9_ where orderline9_.C_Order_ID=order1_.C_Order_ID and orderline9_.QtyDelivered<>$43 and orderline9_.QtyOrdered<>orderline9_.QtyInvoiced))) and (invoicecan0_.AD_Client_ID in ($44 , $1)) and (invoicecan0_.AD_Org_ID in ($2 , $3)) order by organizati2_.Name, businesspa3_.Name, invoicecan0_.Dateordered limit $4
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
1e7d029944	select a.id, ev.value as account_id, ev.name, a.initialamt as SALDO_INICIAL, a.amtacctcr, a.amtacctdr, A.INITIALAMT+A.AMTACCTDR-A.AMTACCTCR AS SALDO_FINAL, a.groupbyid, CASE ad_column_identifier ($17,groupbyid,TO_CHAR($1)) WHEN $18 THEN $19 ELSE ad_column_identifier ($20,groupbyid,TO_CHAR($2)) END AS groupbyname from( SELECT sum(case when (DATEACCT < TO_DATE($3) or (DATEACCT = TO_DATE($4) and F.FACTACCTTYPE = $5)) then F.AMTACCTDR - F.AMTACCTCR else $21 end) as initialamt, sum(case when (DATEACCT >= TO_DATE($6) AND F.FACTACCTTYPE not in($22, $23, $24)) or (DATEACCT = TO_DATE($7) and F.FACTACCTTYPE = $8) then F.AMTACCTDR else $25 end) as AMTACCTDR, sum(case when (DATEACCT >= TO_DATE($9) AND F.FACTACCTTYPE not in($26, $27, $28)) or (DATEACCT = TO_DATE($10) and F.FACTACCTTYPE = $11) then F.AMTACCTCR else $29 end) as AMTACCTCR, F.ACCOUNT_ID AS ID, to_char($30) AS groupbyid FROM FACT_ACCT F WHERE F.AD_ORG_ID IN($31) AND F.AD_CLIENT_ID IN($32,$33) AND F.AD_ORG_ID IN ($34,$35,$36,$37) AND DATEACCT < TO_DATE($12) AND $38=$39 AND F.C_ACCTSCHEMA_ID = $13 AND F.ISACTIVE=$40 group by F.ACCOUNT_ID ) a, c_elementvalue ev where a.id = ev.c_elementvalue_id and ev.elementlevel = $14 AND $41=$42 AND EV.VALUE >= $15 AND EV.VALUE <= $16 and (a.initialamt <>$43 or a.amtacctcr <>$44 or a.amtacctdr<>$45) order by ev.value, ev.name, id, groupbyname
4813705ddb	update C_Invoice set Updated=$1, DaysTillDue=$2, LastCalculatedOnDate=$3 where C_Invoice_ID=$4
12e891cf77	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
6f5312535e	SELECT REPLACE(REPLACE(SQL_RECORD_IDENTIFIER, ':c_language', '''' \|\| p_Language \|\| ''''), ':c_ID', p_Record_ID) FROM AD_TABLE WHERE UPPER(TABLENAME)=UPPER(p_TableName)
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)
e4360f260c	UPDATE C_Invoice SET Processing=$2 WHERE C_Invoice_ID = $1 AND Processed=$3 AND (Processing=$4 OR Processing IS NULL) AND Posted<>$5
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)
915a7e9440	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
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 )
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)
c7ac2b0d2b	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
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
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
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
1e7f08819e	INSERT INTO Fact_Acct (Fact_Acct_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy, C_AcctSchema_ID,Account_ID, AcctValue, AcctDescription,DateTrx,DateAcct, C_Period_ID,AD_Table_ID,Record_ID,Line_ID, GL_Category_ID,C_Tax_ID,PostingType,C_Currency_ID, AmtSourceDR,AmtSourceCR,AmtAcctDR,AmtAcctCR, C_UOM_ID,Qty,M_Locator_ID,M_Product_ID,C_BPartner_ID,AD_OrgTrx_ID,C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID,C_Campaign_ID,C_Activity_ID,User1_ID,User2_ID,Description, Fact_Acct_Group_ID, SeqNo, DocBaseType, Record_ID2, A_ASSET_ID, C_WithHolding_ID, C_DocType_ID, C_Costcenter_ID, FACTACCTTYPE) VALUES ($1, $2, $3,$48,now(),$4,now(),$5, $6, $7, $8, $9, TO_DATE($10), TO_DATE($11), $12, $13, $14, $15, $16, $17, $18, $19, TO_NUMBER($20), TO_NUMBER($21), TO_NUMBER($22), TO_NUMBER($23), $24, TO_NUMBER($25), $26,$27, $28, $29,$30, $31, $32,$33, $34, $35,$36, $37, $38, $39, TO_NUMBER($40), $41, $42, $43, $44, $45, $46, $47)
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
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
c35de5a948	select invoice1_.DocumentNo as col_0_0_, invoice1_.C_BPartner_ID as col_1_0_, ad_column_identifier($13, coalesce(invoice1_.C_BPartner_ID, $14), $1) as col_2_0_, businesspa6_.Name2 as col_3_0_, businesspa6_.TaxID as col_4_0_, coalesce(obmtr30_getcountryname(invoice1_.C_BPartner_Location_ID, $2), $15) as col_5_0_, region5_.Name as col_6_0_, invoice1_.DateInvoiced as col_7_0_, invoice1_.DateAcct as col_8_0_, financialm8_.Name as col_9_0_, financialm8_.Rate as col_10_0_, case documentty10_.DocBaseType when $3 then coalesce(invoicetax0_.TaxAmt$16, $17) else invoicetax0_.TaxAmt end as col_11_0_, invoice1_.C_Currency_ID as col_12_0_, currency11_.CurSymbol as col_13_0_, invoice1_.C_DocType_ID as col_14_0_, case documentty10_.DocBaseType when $4 then coalesce(invoicetax0_.TaxBaseAmt$18, $19) else invoicetax0_.TaxBaseAmt end as col_15_0_, case documentty10_.DocBaseType when $5 then coalesce(invoice1_.GrandTotal*$20+coalesce(invoice1_.Withholdingamount, $21), $22) else coalesce(invoice1_.GrandTotal-coalesce(invoice1_.Withholdingamount, $23), $24) end as col_16_0_, invoicetax0_.C_Tax_ID as col_17_0_, coalesce(financialm8_.C_TaxCategory_ID, $25) as col_18_0_, financialm16_.Name as col_19_0_, $26 as col_20_0_, $27 as col_21_0_, $28 as col_22_0_, currencyco2_.Rate as col_23_0_ from C_InvoiceTax invoicetax0_ left outer join C_Invoice invoice1_ on invoicetax0_.C_Invoice_ID=invoice1_.C_Invoice_ID left outer join C_Conversion_Rate_Document currencyco2_ on invoice1_.C_Invoice_ID=currencyco2_.C_Invoice_ID left outer join C_BPartner_Location businesspa3_ on invoice1_.C_BPartner_Location_ID=businesspa3_.C_BPartner_Location_ID left outer join C_Location location4_ on businesspa3_.C_Location_ID=location4_.C_Location_ID left outer join C_Region region5_ on location4_.C_Region_ID=region5_.C_Region_ID cross join C_BPartner businesspa6_ cross join C_DocType documentty10_ cross join C_Currency currency11_ cross join C_Tax financialm8_ cross join C_TaxCategory financialm16_ where invoice1_.C_BPartner_ID=businesspa6_.C_BPartner_ID and invoice1_.C_DocType_ID=documentty10_.C_DocType_ID and invoice1_.C_Currency_ID=currency11_.C_Currency_ID and invoicetax0_.C_Tax_ID=financialm8_.C_Tax_ID and financialm8_.C_TaxCategory_ID=financialm16_.C_TaxCategory_ID and invoice1_.IsSOTrx=$6 and invoice1_.DateAcct<$7 and invoice1_.DateAcct>=$8 and invoicetax0_.TaxBaseAmt<>$29 and invoice1_.IsActive=$30 and invoice1_.Processed=$31 and invoice1_.Posted=$32 and coalesce(currencyco2_.C_Currency_ID, invoice1_.C_Currency_ID)=invoice1_.C_Currency_ID and (coalesce(currencyco2_.C_Currency_Id_To, $9)=$10 or invoice1_.C_Currency_ID=$11) and financialm8_.IsWithholdingTax=$33 and (invoice1_.AD_Org_ID in ($12))
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
1af62bac16	select documentno, dateacct, substr(ad_column_identifier(tablename, id, $1) \|\|(CASE WHEN description IS NULL THEN $60 ELSE $61 \|\| DESCRIPTION \|\| $62 END),$63,$64) as description, GRANDTOTAL as amount, document as doctype, id as id, tab_id, docbasetype, record_id from (select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct, $65 as tablename, C_bpartner_id as id, GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=c_invoice.c_doctype_id and ad_language=$2 and ad_client_id=$3)), $66) as document, $67 as tab_id, (select docbasetype from c_doctype where c_doctype_id=c_invoice.c_doctype_id) as docbasetype, c_invoice_id as record_id from c_invoice where processed = $68 and posted not in ($69, $70, $71) and issotrx = $72 and docstatus <> $73 and $74=(select max(isactive) from c_acctschema_table where ad_table_id=$75 and ad_client_id=$4) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct, $76 as tablename, m_inout_id as id, $77 as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=m_inout.c_doctype_id and ad_language=$5 and ad_client_id=$6)), $78) as document, $79 as tab_id, (select docbasetype from c_doctype where c_doctype_id=m_inout.c_doctype_id) as docbasetype, m_inout_id as record_id from m_inout where processed = $80 and posted not in ($81, $82, $83) and issotrx = $84 and $85=(select max(isactive) from c_acctschema_table where ad_table_id=$86 and ad_client_id=$7) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct, $87 as tablename, m_inout_id as id, $88 as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=m_inout.c_doctype_id and ad_language=$8 and ad_client_id=$9)), $89) as document, $90 as tab_id, (select docbasetype from c_doctype where c_doctype_id=m_inout.c_doctype_id) as docbasetype, m_inout_id as record_id from m_inout where processed = $91 and posted not in ($92, $93, $94) and issotrx = $95 and $96=(select max(isactive) from c_acctschema_table where ad_table_id=$97 and ad_client_id=$10) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct, $98 as tablename, C_bpartner_id as id, GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=c_invoice.c_doctype_id and ad_language=$11 and ad_client_id=$12)), $99) as document, $100 as tab_id, (select docbasetype from c_doctype where c_doctype_id=c_invoice.c_doctype_id) as docbasetype, c_invoice_id as record_id from c_invoice where processed = $101 and posted not in ($102, $103, $104) and issotrx = $105 and docstatus <> $106 and $107=(select max(isactive) from c_acctschema_table where ad_table_id=$108 and ad_client_id=$13) union all select ad_client_id, ad_org_id, TO_CHAR(name) AS DOCUMENTNO, dateacct, $109 as tablename, C_Cash_id as id, c_cash.STATEMENTDIFFERENCE, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$14 and docbasetype=$110) and ad_language=$15 and ad_client_id=$16)), $111) as document, $112 as tab_id, $113 as docbasetype, c_cash_id as record_id from C_Cash where processed = $114 and posted not in ($115, $116, $117) and $118=(select max(isactive) from c_acctschema_table where ad_table_id=$119 and ad_client_id=$17) union all select ad_client_id, ad_org_id, TO_CHAR(name) AS DOCUMENTNO, statementdate, $120 as tablename, C_bankstatement_id as id, STATEMENTDIFFERENCE, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$18 and docbasetype=$121) and ad_language=$19 and ad_client_id=$20)), $122) as document, $123 as tab_id, $124 as docbasetype, c_bankstatement_id as record_id from c_bankstatement where processed = $125 and posted not in ($126, $127, $128) and $129=(select max(isactive) from c_acctschema_table where ad_table_id=$130 and ad_client_id=$21) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct, $131 as tablename, C_Settlement_id as id, generatedamt, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=s.c_doctype_id and ad_language=$22 and ad_client_id=$23)), $132) as document, $133 as tab_id, $134 as docbasetype, c_Settlement_id as record_id from c_Settlement s where processed = $135 and posted not in ($136, $137, $138) and settlementtype = $139 and $140=(select max(isactive) from c_acctschema_table where ad_table_id=$141 and ad_client_id=$24) and exists (select $142 from c_debt_payment p where p.c_settlement_generate_id = s.c_settlement_id and p.isdirectposting=$143) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct, $144 as tablename, C_Settlement_id as id, generatedamt, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=c_Settlement.c_doctype_id and ad_language=$25 and ad_client_id=$26)), $145) as document, $146 as tab_id, $147 as docbasetype, c_Settlement_id as record_id from c_Settlement where processed = $148 and posted not in ($149, $150, $151) and settlementtype <> $152 and $153=(select max(isactive) from c_acctschema_table where ad_table_id=$154 and ad_client_id=$27) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct, $155 as tablename, GL_Journal_id as id, totaldr, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=GL_Journal.c_doctype_id and ad_language=$28 and ad_client_id=$29)), $156) as document, $157 as tab_id, (select docbasetype from c_doctype where c_doctype_id=GL_Journal.c_doctype_id) as docbasetype, GL_Journal_id as record_id from GL_Journal where processed = $158 and posted not in ($159, $160, $161) and $162=(select max(isactive) from c_acctschema_table where ad_table_id=$163 and ad_client_id=$30) union all select ad_client_id, ad_org_id, TO_CHAR(name) AS DOCUMENTNO, movementdate , $164 as tablename, m_inventory_id as id, $165 as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$31 and docbasetype=$166) and ad_language=$32 and ad_client_id=$33)), $167) as document, $168 as tab_id, $169 as docbasetype, m_inventory_id as record_id from m_inventory where processed = $170 and posted not in ($171, $172, $173) and $174=(select max(isactive) from c_acctschema_table where ad_table_id=$175 and ad_client_id=$34) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, paymentdate , $176 as tablename, c_bpartner_id as id, amount as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$35 and docbasetype=$177) and ad_language=$36 and ad_client_id=$37)), $178) as document, $179 as tab_id, $180 as docbasetype, fin_payment_id as record_id from fin_payment where processed = $181 and posted not in ($182, $183, $184) and isreceipt=$185 and status <> $186 and $187=(select max(isactive) from c_acctschema_table where ad_table_id=$188 and ad_client_id=$38) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, paymentdate , $189, c_bpartner_id as id, amount as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$39 and docbasetype=$190) and ad_language=$40 and ad_client_id=$41)), $191) as document, $192 as tab_id, $193 as docbasetype, fin_payment_id as record_id from fin_payment where processed = $194 and posted not in ($195, $196, $197) and isreceipt=$198 and status <> $199 and $200=(select max(isactive) from c_acctschema_table where ad_table_id=$201 and ad_client_id=$42) union all select ad_client_id, ad_org_id, $202 \|\| to_char(line) AS DOCUMENTNO, dateacct, $203 as tablename, fin_financial_account_id as id, depositamt-paymentamt as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$43 and docbasetype=$204) and ad_language=$44 and ad_client_id=$45)), $205) as document, $206 as tab_id, $207 as docbasetype, fin_finacc_transaction_id as record_id from fin_finacc_transaction where processed = $208 and posted not in ($209, $210, $211) and $212=(select max(isactive) from c_acctschema_table where ad_table_id=$213 and ad_client_id=$46) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, statementdate, $214 as talename, fin_financial_account_id as id, endingbalance - startingbalance as GRANDTOTAL, $215 as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$47 and docbasetype=$216) and ad_language=$48 and ad_client_id=$49)), $217) as document, $218 as tab_id, $219 as docbasetype, fin_reconciliation_id as record_id from fin_reconciliation where processed = $220 and posted not in ($221, $222, $223) and $224=(select max(isactive) from c_acctschema_table where ad_table_id=$225 and ad_client_id=$50) union all select ad_client_id, ad_org_id, TO_CHAR(name) AS DOCUMENTNO, movementdate , $226 as tablename, m_movement_id as id, $227 as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$51 and docbasetype=$228) and ad_language=$52 and ad_client_id=$53)), $229) as document, $230 as tab_id, $231 as docbasetype, m_movement_id as record_id from m_movement where processed = $232 and posted not in ($233, $234, $235) and $236=(select max(isactive) from c_acctschema_table where ad_table_id=$237 and ad_client_id=$54) union all select ad_client_id, ad_org_id, TO_CHAR(documentno) AS DOCUMENTNO, dateacct , $238 as tablename, c_dp_management_id as id, $239 as GRANDTOTAL, to_char(description) as description, coalesce(to_char((select printname from c_doctype_trl where c_doctype_id=(select min(c_doctype_id) from c_doctype where ad_client_id=$55 and docbasetype=$240) and ad_language=$56 and ad_client_id=$57)), $241) as document, $242 as tab_id, $243 as docbasetype, c_dp_management_id as record_id from c_dp_management where processed = $244 and posted not in ($245, $246, $247) and $248=(select max(isactive) from c_acctschema_table where ad_table_id=$249 and ad_client_id=$58) ) AAA where ad_client_id = $59 and ad_org_id in ($250,$251,$252,$253) and $254=$255 order by document, dateacct, description
f3d76f43df	SELECT TO_CHAR(COALESCE(TO_CHAR(T.DocumentNo),$1))\|\|$2\|\|TO_CHAR(COALESCE(TO_CHAR(T.MovementDate),$3))\|\|$4\|\|coalesce ((SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),$5)) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.C_BPartner_ID), $6) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=$7) L, M_InOut T WHERE M_InOut_ID=$8
b9bb8a4422	SELECT * FROM take_sample_subset(1,0)
3206d9f66d	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
61bc3cba28	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
73e3636bec	update C_Invoice set Updated=$1, LastCalculatedOnDate=$2 where C_Invoice_ID=$3
07181527b0	DELETE FROM last_stat_indexes WHERE server_id=sserver_id AND sample_id != s_id
032d1e73d2	SELECT C_INVOICE_POST(p_PInstance_ID, $2)

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_9	ad_context_info	365 GB	100942			100923		100922
etendo	pg_default	pg_temp_8	ad_context_info	285 GB	88637			88597		88596
etendo	pg_default	pg_temp_7	ad_context_info	62 GB	38192			38157		38156
etendo	pg_default	pg_temp_5	ad_context_info	31 GB	25347			25334		25333
etendo	pg_default	pg_temp_3	ad_context_info	31 GB	25283			25277		25276
etendo	pg_default	pg_temp_4	ad_context_info	31 GB	12601			12601		12601
etendo	pg_default	public	fact_acct	13 GB	50	604	1832156	42	13
etendo	pg_default	public	fact_acct(TOAST)
etendo	pg_default	public	psat_checklist_result	4223 MB	72	1094	1302	159	19		17
etendo	pg_default	public	psat_checklist_result(TOAST)
etendo	pg_default	pg_catalog	pg_class	4050 MB	6028	613425	600422	1874	6728	1874	1375
etendo	pg_default	public	advcrm_activity	3456 MB	215	1359	1302	8	77	1	58
etendo	pg_default	public	advcrm_activity(TOAST)
etendo	pg_default	profile	last_stat_database	2167 MB	101588			92		92
etendo	pg_default	public	c_invoice	1960 MB	86	328662	1733097	9	289970		62
etendo	pg_default	public	c_invoice(TOAST)
etendo	pg_default	public	m_inout	1943 MB	165	72586	76825	4	16		9
etendo	pg_default	public	m_inout(TOAST)
etendo	pg_default	public	ad_audit_trail	1525 MB	3	150	136	768
etendo	pg_default	public	ad_audit_trail(TOAST)
etendo	pg_default	public	m_product	663 MB	187	550282	666748		3
etendo	pg_default	public	m_product(TOAST)
etendo	pg_default	public	psat_request	570 MB	217	5014	17008		5		1
etendo	pg_default	public	psat_request(TOAST)
etendo	pg_default	profile	last_stat_tablespaces	568 MB	36330			46		46
etendo	pg_default	profile	last_stat_tablespaces(TOAST)
etendo	pg_default	public	advcrm_activity_log	459 MB	75	43	36	9	9		9
etendo	pg_default	public	advcrm_activity_log(TOAST)
etendo	pg_default	public	c_invoiceline	441 MB	8	2114	2037	22	53		48
etendo	pg_default	public	c_invoiceline(TOAST)
etendo	pg_default	public	c_bpartner	410 MB	324	232953	617968		31		18
etendo	pg_default	public	c_bpartner(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_9	ad_context_info	42472528	26.65
etendo	pg_default	pg_temp_8	ad_context_info	32608907	20.46
etendo	pg_default	public	c_invoice	3974043	2.49	7694211	4.83
etendo	pg_default	pg_temp_7	ad_context_info	6112701	3.84
etendo	pg_default	public	fin_payment_schedule	879948	0.55	2527332	1.59
etendo	pg_default	profile	last_stat_tables	3264681	2.05	105182	0.07
etendo	pg_default	pg_temp_4	ad_context_info	3352022	2.10
etendo	pg_default	pg_temp_5	ad_context_info	2720922	1.71
etendo	pg_default	pg_temp_3	ad_context_info	2714403	1.70
etendo	pg_default	public	fact_acct	2522168	1.58	15906	0.01
etendo	pg_default	public	psat_activity_materials	10945	0.01	2394835	1.50
etendo	pg_default	pg_catalog	pg_class	1109615	0.70	1282670	0.80
etendo	pg_default	public	m_product	692733	0.43	1114100	0.70
etendo	pg_default	public	ad_textinterfaces	1495686	0.94	244228	0.15
etendo	pg_default	public	c_debt_payment	469234	0.29	789910	0.50
etendo	pg_default	public	c_bpartner	660418	0.41	549039	0.34
etendo	pg_default	public	m_productprice	310752	0.20	886007	0.56
etendo	pg_default	public	c_elementvalue	411257	0.26	779894	0.49
etendo	pg_default	pg_catalog	pg_attribute	477515	0.30	700379	0.44
etendo	pg_default	public	ad_tab	658160	0.41	459428	0.29

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	130187	28.37	1025	0.22					43.70
etendo	pg_default	public	fact_acct	67283	14.66	1289	0.28					97.30
etendo	pg_default	public	ad_image	784	0.17	17	0.00	56367	12.28	885	0.19	65.93
etendo	pg_default	public	psat_checklist_result	15007	3.27	3503	0.76					96.98
etendo	pg_default	public	c_invoiceline	14108	3.07	587	0.13					80.27
etendo	pg_default	public	c_invoice	5831	1.27	6154	1.34					99.90
etendo	pg_default	public	c_invoicelinetax	8052	1.75	62	0.01					60.67
etendo	pg_default	pg_temp_7	ad_context_info	8044	1.75							0.25
etendo	pg_default	public	c_orderlinetax	7357	1.60	190	0.04					67.52
etendo	pg_default	public	ad_session_usage_audit	4646	1.01	762	0.17					87.63
etendo	pg_default	public	fin_payment_schedule	3800	0.83	502	0.11					99.87
etendo	pg_default	public	fin_payment	3161	0.69	191	0.04					80.62
etendo	pg_default	public	fin_payment_scheduledetail	2721	0.59	593	0.13					91.42
etendo	pg_default	public	m_inout	3011	0.66	279	0.06					99.52
etendo	pg_default	public	ad_process_run	2694	0.59	121	0.03	11	0.00	10	0.00	95.75
etendo	pg_default	public	c_invoicetax	2494	0.54	263	0.06					82.41
etendo	pg_default	public	fin_payment_detail	1906	0.42	238	0.05					61.77
etendo	pg_default	public	c_orderline	8	0.00	1914	0.42					99.69
etendo	pg_default	pg_catalog	pg_attribute	1431	0.31	486	0.11					99.84
etendo	pg_default	profile	sample_stat_tables	1779	0.39	108	0.02					96.09

Top DML tables

DB	Tablespace	Schema	Table	Ins	Upd	Del	Upd(HOT)	SeqScan	SeqFet	IxScan	IxFet
etendo	pg_default	public	c_invoice	9	289970		62	86	3942566	328662	1733097
etendo	pg_default	public	c_invoice(TOAST)
etendo	pg_default	pg_temp_9	ad_context_info	100923		100922		100942	100941
etendo	pg_default	pg_temp_8	ad_context_info	88597		88596		88637	88636
etendo	pg_default	profile	last_stat_indexes	54119	1330	54119	2	185	865904	34564	328397
etendo	pg_default	pg_temp_7	ad_context_info	38157		38156		38192	38191
etendo	pg_default	profile	last_stat_tables	32888	3302	32888	36	186	529068	7681	2870602
etendo	pg_default	pg_temp_5	ad_context_info	25334		25333		25347	25346
etendo	pg_default	pg_temp_3	ad_context_info	25277		25276		25283	25282
etendo	pg_default	pg_catalog	pg_attribute	24203		24203		92	94989	296407	1255014
etendo	pg_default	pg_temp_4	ad_context_info	12601		12601		12601	12601
etendo	pg_default	pg_catalog	pg_statistic		16333		13519	2	16746	99413	81586
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	2361		2366				13723	21207
etendo	pg_default	profile	last_stat_user_functions	8257	931	8257	42	383	241607
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_catalog	pg_class	1874	6728	1874	1375	6028	17631987	613425	600422
etendo	pg_default	pg_catalog	pg_depend	4585		4585		12	205809	44171	49902
etendo	pg_default	profile	sample_stat_tables	3302		3300		25	605922	144	3485
etendo	pg_default	pg_catalog	pg_type	2159		2159		12	30632	94666	87960
etendo	pg_default	profile	sample_statements	1446		1433		49	509603	113	1433
etendo	pg_default	profile	sample_statements(TOAST)
etendo	pg_default	profile	sample_stat_indexes	1279		1285		22	208644	151	1356
postgres	pg_default	pg_catalog	pg_attribute	1215		1215		37	8118	23025	51272
etendo	pg_default	public	ad_session_usage_audit	1786				5	380204	154	22543
etendo	pg_default	public	ad_session_usage_audit(TOAST)

Top tables by updated/deleted tuples

DB	Tablespace	Schema	Table	Upd	Upd(HOT)	Del	AutoVacuum	Analyze	AutoAnalyze
etendo	pg_default	public	c_invoice	289970	62		23	1	23
etendo	pg_default	public	c_invoice(TOAST)
etendo	pg_default	pg_temp_9	ad_context_info			100922
etendo	pg_default	pg_temp_8	ad_context_info			88596
etendo	pg_default	profile	last_stat_indexes	1330	2	54119	26	47	23
etendo	pg_default	pg_temp_7	ad_context_info			38156
etendo	pg_default	profile	last_stat_tables	3302	36	32888	26	47	23
etendo	pg_default	pg_temp_5	ad_context_info			25333
etendo	pg_default	pg_temp_3	ad_context_info			25276
etendo	pg_default	pg_catalog	pg_attribute			24203	1	1	1
etendo	pg_default	pg_catalog	pg_statistic	16333	13519		1
etendo	pg_default	pg_catalog	pg_statistic(TOAST)			2366	4
etendo	pg_default	pg_temp_4	ad_context_info			12601
etendo	pg_default	profile	last_stat_user_functions	931	42	8257	26	47	23
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_catalog	pg_class	6728	1375	1874	1	1	1
etendo	pg_default	pg_catalog	pg_depend			4585		1	1
etendo	pg_default	profile	sample_stat_tables			3300		1	2
etendo	pg_default	pg_catalog	pg_type			2159	1	1	1
etendo	pg_default	public	ad_session	1721	1687			1	14
etendo	pg_default	public	ad_session(TOAST)
etendo	pg_default	profile	sample_statements			1433		1	2
etendo	pg_default	profile	sample_statements(TOAST)
etendo	pg_default	profile	sample_stat_indexes			1285			2
postgres	pg_default	pg_catalog	pg_attribute			1215	1	1	1

Top growing tables

DB	Tablespace	Schema	Table	Size	Growth	Ins	Del
etendo	pg_default	pg_temp_9	ad_context_info	6720 kB	6720 kB	100923	100922
etendo	pg_default	pg_temp_8	ad_context_info	5888 kB	5888 kB	88597	88596
etendo	pg_default	pg_temp_7	ad_context_info	2544 kB	2544 kB	38157	38156
etendo	pg_default	profile	sample_stat_indexes	1432 kB	192 kB	1279	1285
etendo	pg_default	profile	sample_stat_user_functions	560 kB	88 kB	907	830
etendo	pg_default	profile	sample_stat_tables_total	336 kB	56 kB	160	184
etendo	pg_default	pg_catalog	pg_attribute	4408 kB	48 kB	24203	24203
etendo	pg_default	profile	sample_stat_database	232 kB	48 kB	68	68
etendo	pg_default	profile	sample_stat_cluster	56 kB	32 kB	12	14
etendo	pg_default	profile	sample_stat_indexes_total	96 kB	32 kB	64	64
etendo	pg_default	profile	sample_statements_total	136 kB	32 kB	36	39
etendo	pg_default	profile	sample_statements_total(TOAST)
etendo	pg_default	profile	sample_stat_user_func_total	56 kB	32 kB	24	28
etendo	pg_default	pg_temp_4	ad_context_info	8192 bytes	8192 bytes	103	102

Top indexes by blocks fetched

DB	Tablespace	Schema	Table	Index	Scans	Blks	%Total
etendo	pg_default	public	fin_payment_schedule	fin_paym_sch_inv_idx	835997	2515292	1.58
etendo	pg_default	public	psat_activity_materials	psat_activity_mater_produni	20131	2393627	1.50
etendo	pg_default	public	c_invoice	c_invoice_key	293304	1770325	1.11
etendo	pg_default	pg_catalog	pg_class	pg_class_oid_index	585427	1193200	0.75
etendo	pg_default	public	m_product	m_product_key	550231	1104960	0.69
etendo	pg_default	public	c_invoice	c_invoice_bpartner	33954	991214	0.62
etendo	pg_default	public	m_productprice	m_productprice_key	293281	882241	0.55
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc		881694	0.55
etendo	pg_default	public	c_elementvalue	c_elementvalue_key	389429	779099	0.49
etendo	pg_default	public	m_product_trl	m_product_trl_product_langu_un	711773	712069	0.45
etendo	pg_default	public	c_invoice	c_invoice_posted	1390	699691	0.44
etendo	pg_default	public	c_invoice	c_invoice_paid		692146	0.43
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	295723	650238	0.41
etendo	pg_default	public	c_invoice	c_invoice_salesrep		646032	0.41
etendo	pg_default	public	c_invoice	c_invoice_updated		595273	0.37
etendo	pg_default	public	c_invoice	c_invoice_docno	13	586359	0.37
etendo	pg_default	public	c_debt_payment	c_debt_payment_invoice_idx	276754	554834	0.35
etendo	pg_default	public	c_bpartner	c_bpartner_key	225097	452151	0.28
etendo	pg_default	public	ad_tab	ad_tab_window	223287	451173	0.28
etendo	pg_default	public	psat_checklist_result	psat_chcklist_res_result_uk	680	366286	0.23

DB	Tablespace	Schema	Table	Index	Scans	Blk Reads	%Total	Hits(%)
etendo	pg_default	public	psat_checklist_result	psat_chcklist_res_result_uk	680	3336	0.73	99.09
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc		1407	0.31	99.84
etendo	pg_default	public	c_invoice	c_invoice_paid		1173	0.26	99.83
etendo	pg_default	public	c_orderline	c_orderline_order2	104507	994	0.22	99.69
etendo	pg_default	public	ad_image(TOAST)	pg_toast_74472_index	13771	885	0.19	97.95
etendo	pg_default	public	c_invoice	c_invoice_posted	1390	881	0.19	99.87
etendo	pg_default	public	ad_audit_trail	ad_audit_trail_pk		873	0.19	71.65
etendo	pg_default	public	c_orderline	c_orderline_key	4416	815	0.18	93.89
etendo	pg_default	public	m_inoutline	m_inoutline_orderline	4705	792	0.17	94.41
etendo	pg_default	public	c_invoice	c_invoice_docno	13	714	0.16	99.88
etendo	pg_default	public	c_invoice	c_invoice_updated		559	0.12	99.91
etendo	pg_default	public	ad_session_usage_audit	ad_session_usage_audit_key		527	0.11	89.39
etendo	pg_default	public	fact_acct	fact_acct_dateacct	58	525	0.11	90.01
etendo	pg_default	public	fact_acct	fact_acct_account	179	520	0.11	84.27
etendo	pg_default	public	c_invoiceline	c_invoiceline_inoutline	595	381	0.08	78.70
etendo	pg_default	public	c_invoice	c_invoice_bpartner	33954	354	0.08	99.96
etendo	pg_default	public	advcrm_activity_related	advcrm_unique_project	3	346	0.08	66.70
etendo	pg_default	public	c_invoice	c_invoice_key	293304	344	0.07	99.98
etendo	pg_default	public	c_invoice	c_invoice_salesrep		319	0.07	99.95
etendo	pg_default	public	fin_payment_scheduledetail	fin_pay_scheduledetail_in	1361	307	0.07	92.52

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	888 kB	288 kB	1081		1064
etendo	pg_default	public	c_invoice	c_invoice_posted	2024 kB	88 kB	9	289908
etendo	pg_default	public	c_invoice	c_invoice_salesrep	1936 kB	64 kB	9	289908
etendo	pg_default	public	c_invoice	c_invoice_paid	2000 kB	32 kB	9	289908
etendo	pg_default	profile	sample_stat_user_functions	pk_sample_stat_user_functions	240 kB	32 kB	242		225
etendo	pg_default	public	c_invoice	c_invoice_updated	1624 kB	16 kB	9	289908
etendo	pg_default	profile	last_stat_tables	pk_last_stat_tables	240 kB	8192 bytes	32888	3266	32888
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	680 kB	8192 bytes	24203		24203
etendo	pg_default	pg_catalog	pg_type	pg_type_oid_index	80 kB	8192 bytes	2155		2157
postgres	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	120 kB	8192 bytes	1215		1215
etendo	pg_default	profile	sample_statements_total	pk_sample_statements_total	40 kB	8192 bytes	30		36
etendo	pg_default	public	fin_payment_schedule	fin_paym_sch_inv_idx	2048 kB	8192 bytes	17	19	4

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	3976 kB	-48 kB	9	289908
etendo	pg_default	public	c_invoice	c_invoice_paid	2000 kB	32 kB	9	289908
etendo	pg_default	public	c_invoice	c_invoice_updated	1624 kB	16 kB	9	289908
etendo	pg_default	public	c_invoice	c_invoice_ad_user	1576 kB	-32 kB	9	289908
etendo	pg_default	public	c_invoice	c_invoice_bp_extref_idx	8192 bytes		9	289908
etendo	pg_default	public	c_invoice	c_invoice_salesrep	1936 kB	64 kB	9	289908
etendo	pg_default	public	ad_process_run	ad_process_run_ould_be_killed	8192 bytes		266	266	315
postgres	pg_default	pg_catalog	pg_class	pg_class_tblspc_relfilenode_index	16 kB		107	259	107

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_column_identifier	81187	55.29	54.34	0.001	0.001
etendo	profile	take_sample	23	16.67	0.02	0.725	0.001
etendo	profile	take_sample_subset	23	16.66	0.06	0.724	0.003
etendo	profile	take_sample	23	16.60	1.68	0.722	0.073
etendo	public	ad_istriggerenabled	1162851	10.08	10.08	0.000	0.000
etendo	profile	collect_obj_stats	23	9.18	2.78	0.399	0.121
etendo	public	ad_org_isinnaturaltree	361000	8.25	2.08	0.000	0.000
etendo	profile	dblink	621	7.93	7.93	0.013	0.013
etendo	public	ad_isorgincluded	464663	6.33	6.33	0.000	0.000
etendo	profile	sample_dbobj_delta	23	3.52	3.52	0.153	0.153
etendo	public	to_char	2443638	2.00	2.00	0.000	0.000
etendo	public	c_invoice_post	16	1.32	0.34	0.082	0.021
etendo	public	obequals	1223189	1.29	1.29	0.000	0.000
etendo	public	c_invoice_post0	15	1.19	0.00	0.079	0.000
etendo	profile	collect_pg_stat_statements_stats	22	0.92	0.37	0.042	0.017
etendo	public	to_number	441866	0.81	0.81	0.000	0.000
etendo	public	aprm_ispaymentconfirmed	9989	0.81	0.81	0.000	0.000
etendo	public	to_char	252817	0.80	0.80	0.000	0.000
etendo	public	ad_extension_point_handler	38	0.75	0.02	0.020	0.001
etendo	public	prouti_qtyremainingorderline	4736	0.36	0.36	0.000	0.000

Top functions by executions

DB	Schema	Function	Executions	Time (s)
DB	Schema	Function	Executions	Total	Self	Mean	Mean self
etendo	public	to_char	2443638	2.00	2.00	0.000	0.000
etendo	public	obequals	1223189	1.29	1.29	0.000	0.000
etendo	public	ad_istriggerenabled	1162851	10.08	10.08	0.000	0.000
etendo	public	ad_isorgincluded	464663	6.33	6.33	0.000	0.000
etendo	public	to_number	441866	0.81	0.81	0.000	0.000
etendo	public	ad_org_isinnaturaltree	361000	8.25	2.08	0.000	0.000
etendo	public	to_char	252817	0.80	0.80	0.000	0.000
etendo	public	to_char	183377	0.28	0.28	0.000	0.000
etendo	public	ad_column_identifier	81187	55.29	54.34	0.001	0.001
etendo	public	round	39562	0.03	0.03	0.000	0.000
etendo	public	to_char	19232	0.06	0.06	0.000	0.000
etendo	public	substract_days	12783	0.01	0.01	0.000	0.000
etendo	public	add_days	11471	0.01	0.01	0.000	0.000
etendo	public	aprm_ispaymentconfirmed	9989	0.81	0.81	0.000	0.000
etendo	public	uuid_generate_v4	8892	0.10	0.10	0.000	0.000
etendo	public	to_date	4868	0.02	0.02	0.000	0.000
etendo	public	prouti_qtyremainingorderline	4736	0.36	0.36	0.000	0.000
etendo	public	lowerequaltimestamp	3695	0.02	0.01	0.000	0.000
etendo	public	get_uuid	2964	0.20	0.10	0.000	0.000
etendo	public	obmtr30_getcountryname	2579	0.15	0.15	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	289979	23.34	18.34	0.000	0.000
etendo	public	c_invoice_trg2	289979	6.60	4.56	0.000	0.000
etendo	public	einv_gene_chk_restrictions_trg	289970	4.48	2.74	0.000	0.000
etendo	public	pruti_inherit_invoice_contact	289979	3.94	2.69	0.000	0.000
etendo	public	au_advcrm_activity_trg	90	0.28	0.26	0.003	0.003
etendo	public	au_c_bpartner_trg	31	0.23	0.23	0.007	0.007
etendo	public	c_orderline_trg2	143	0.22	0.09	0.002	0.001
etendo	public	c_invoiceline_trg2	78	0.16	0.06	0.002	0.001
etendo	public	au_m_product_trg	5	0.11	0.11	0.022	0.021
etendo	public	ad_preference_mod_trg	272	0.09	0.08	0.000	0.000
etendo	public	au_psat_request_trg	15	0.07	0.07	0.005	0.004
etendo	public	c_orderlinetax_trg	54	0.07	0.04	0.001	0.001
etendo	public	ad_process_request_trg	315	0.06	0.04	0.000	0.000
etendo	public	c_invoicelinetax_trg	27	0.06	0.02	0.002	0.001
etendo	public	c_invoiceline_trg3	75	0.05	0.05	0.001	0.001
etendo	public	c_orderline_trg	143	0.05	0.05	0.000	0.000
etendo	public	cus_act_log_desc_ol_trg	18	0.05	0.02	0.003	0.001
etendo	public	m_inoutline_trg	24	0.05	0.02	0.002	0.001
etendo	public	c_orderline2_trg	136	0.03	0.03	0.000	0.000
etendo	public	advcrm_create_activity	78	0.03	0.01	0.000	0.000

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	32888	3302	32888	36
etendo	pg_default	profile	last_stat_indexes		26	54119	1330	54119	2
etendo	pg_default	profile	last_stat_user_functions		26	8257	931	8257	42
etendo	pg_default	public	c_invoice		23	9	289970		62
etendo	pg_default	public	ad_ep_instance_para		3	171		171
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		340
etendo	pg_default	pg_catalog	pg_type		1	2159		2159
etendo	pg_default	pg_catalog	pg_attribute		1	24203		24203
etendo	pg_default	pg_catalog	pg_class		1	1874	6728	1874	1375
etendo	pg_default	pg_catalog	pg_index		1	527		527
etendo	pg_default	pg_catalog	pg_statistic		1		16333		13519
etendo	pg_default	public	ad_pinstance	1		21	42	71	41
etendo	pg_default	public	ad_process_run	1		306	306	315
etendo	pg_default	public	m_stock_proposed	1				4
etendo	pg_default	profile	last_stat_database		1	92		92

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	32888	3302	32888	36
etendo	pg_default	profile	last_stat_indexes	47	23	54119	1330	54119	2
etendo	pg_default	profile	last_stat_user_functions	47	23	8257	931	8257	42
etendo	pg_default	public	c_invoice	1	23	9	289970		62
etendo	pg_default	profile	last_stat_tablespaces	24		46		46
etendo	pg_default	public	ad_session	1	14	34	1721		1687
etendo	pg_default	public	ad_process_request	1	5	1	314		309
etendo	pg_default	public	ad_ep_instance_para		4	171		171
etendo	pg_default	profile	last_stat_database	1	3	92		92
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_replication_origin	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	89 MB		23	3974 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_key	62 MB		23	2753 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_bpartner	57 MB		23	2541 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_docno	48 MB		23	2151 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_paid	43 MB		23	1933 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_salesrep	42 MB		23	1890 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_updated	36 MB		23	1592 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_ad_user	35 MB		23	1558 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_order	30 MB		23	1314 kB	23 MB
etendo	pg_default	profile	last_stat_indexes	pk_last_stat_indexes	10 MB		26	392 kB	1529 kB
etendo	pg_default	profile	last_stat_tables	pk_last_stat_tables	5920 kB		26	226 kB	1198 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	1040 kB		1	1040 kB	4408 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	680 kB		1	680 kB	4408 kB
etendo	pg_default	pg_catalog	pg_statistic	pg_statistic_relid_att_inh_index	376 kB		1	376 kB	4640 kB
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	pg_toast_2619_index	336 kB		4	85 kB	3752 kB
etendo	pg_default	public	ad_process_run	ad_process_run_ad_prequest_id	320 kB	1		320 kB	10 MB
etendo	pg_default	public	ad_process_run	ad_process_run_key	312 kB	1		312 kB	10 MB
etendo	pg_default	pg_catalog	pg_class	pg_class_relname_nsp_index	184 kB		1	184 kB	688 kB
etendo	pg_default	public	c_invoice	c_invoice_bp_extref_idx	184 kB		23	8192 bytes	23 MB

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	88596	99	5888 kB
etendo	pg_temp_9	ad_context_info	1	100922	99	6720 kB
etendo	profile	sample_stat_tables	24180	3140	11	7040 kB
etendo	public	ad_process_run	5131	533	9	11 MB
etendo	public	fin_payment_schedule	60598	23	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	88596	177193	199		5888 kB
etendo	pg_temp_9	ad_context_info	1	100922	201845	199		6720 kB
etendo	public	ad_process_run	5131	533	208	3	2026-07-14 19:14:39.949916+02	11 MB
etendo	profile	sample_stat_tables	24180	3140	1059	3	2026-07-14 23:00:44.427089+02	7040 kB
etendo	public	fin_payment_schedule	60598	23	41	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-13 05:00:04.159673+02
pg_conf_load_time	2026-07-14 05:00:04.191608+02			2026-07-14 06:00:01+02
pg_postmaster_start_time	2026-07-13 05:00:04.286006+02
pg_postmaster_start_time	2026-07-14 05:00:04.325131+02			2026-07-14 06:00:01+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