Postgres profile report (StartID: 594, EndID: 617)

pg_profile version 0.3.6

Server name: local

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

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

Report sections

Server statistics

Database statistics
Statement statistics by database
Cluster statistics
Tablespace statistics

SQL query statistics

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

Schema object statistics

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

User function statistics

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

Vacuum-related statistics

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

Cluster settings during the report interval

Server statistics

Database statistics

Database	Transactions			Block statistics			Tuples					Temp files		Size	Growth
Database	Commits	Rollbacks	Deadlocks	Hit(%)	Read	Hit	Ret	Fet	Ins	Upd	Del	Size	Files	Size	Growth
etendo	188059	4		74.17	65581406	188352189	151081480	26038407	663613	319160	443022			2865 MB	848 kB
postgres	11867			99.84	1159	703484	1985184	365429	2012	866	1772			6359 kB
Total	199926	4		74.24	65582565	189055673	153066664	26403836	665625	320026	444794			2871 MB	848 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	9633497	938.92			45.80	94076636	173231966	197455	19124			65094886	18181	11146
postgres	5619	12.85				127535		228						349
template1	6350	9.04				47724		232						278
Total	9645466	960.81			45.80	94251895	173231966	197915	19124			65094886	18181	11773

Cluster statistics

Metric	Value
Scheduled checkpoints	275
Requested checkpoints	1
Checkpoint write time (s)	8830.98
Checkpoint sync time (s)	2.30
Checkpoints buffers written	111382
Background buffers written
Backend buffers written	142643
Backend fsync count
Bgwriter interrupts (too many buffers)
Number of buffers allocated	496394
WAL generated	3671 MB
WAL segments archived
WAL segments archive failed

Tablespace statistics

Tablespace	Path	Size	Growth
pg_default		2885 MB	840 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
8bc1a23ef7 [bff561c]	etendo	305.59	31.81	176305	1.733	0.003	21.815	2.169	176306
4108c96b3f [ca2988bd]	etendo	177.60	18.48	2716	901.512	804.355	1177.333	52.213	197
adb1c31f79 [948be82f]	etendo	128.35	13.36		128352.975	128352.975	128352.975		1
73e3636bec [f410d7e7]	etendo	77.95	8.11	288185	0.270	0.132	8.558	0.087	288185
228d74fbf5 [cd9c0fd2]	etendo	33.67	3.50	13499	33666.597	33666.597	33666.597		1
7410f735c6 [dcb3768d]	etendo	27.51	2.86	88157	0.312	0.008	4.531	0.154	88158
c9e2eb425b [de5cc8a]	etendo	17.23	1.79	4482810	0.003	0.002	2.896	0.002	6722450
0c133f89fa [47df1ade]	etendo	16.98	1.77	23	738.257	656.585	1142.906	107.673	23
b9bb8a4422 [eb812a48]	etendo	16.98	1.77		738.054	656.309	1142.693	107.676	23
1d911b5cd9 [1c4d8fed]	etendo	11.87	1.23	2762	4.296	1.720	13.918	1.609	2762
671fe12038 [66c83919]	etendo	8.43	0.88	1903559	8433.039	8433.039	8433.039		1
2b98e8b0ee [3e7c63ef]	etendo	7.23	0.75	12596	0.574	0.186	2.039	0.193	12596
503324b603 [d34207c3]	etendo	6.14	0.64	253552	0.021	0.005	0.703	0.010	289220
0b651ca53d [7318d810]	etendo	5.17	0.54	674482	5169.026	5169.026	5169.026		1
9d620ef0cc [f45d97ac]	etendo	4.85	0.50	10	692.580	678.097	731.372	17.329	7
7c49e0fca3 [37eecc4]	etendo	4.82	0.50		8.729	7.210	18.010	1.231	552
785a907bc3 [92946197]	etendo	4.73	0.49	878	205.504	192.450	225.709	9.042	23
c2b6cfc2bf [ad3afc69]	etendo	4.26	0.44	1009731	1.535	0.778	9.092	0.734	2774
fdd1193fad [3b0e4e8a]	etendo	3.76	0.39	54119	81.809	18.972	373.808	68.127	46
513a2c0405 [2ee49a6b]	etendo	3.75	0.39	5796	0.647	0.445	2.904	0.250	5796

Top SQL by executions

Query ID	Database	Executions	%Total	Rows	Mean(ms)	Min(ms)	Max(ms)	StdErr(ms)	Elapsed(s)
c9e2eb425b [de5cc8a]	etendo	6722450	69.70	4482810	0.003	0.002	2.896	0.002	17.2
9625146448 [b7edb1a4]	etendo	289528	3.00	289528	0.010	0.007	1.183	0.005	2.9
503324b603 [d34207c3]	etendo	289220	3.00	253552	0.021	0.005	0.703	0.010	6.1
0c13a0abe2 [4ed26d58]	etendo	289220	3.00	31151	0.010	0.006	0.679	0.005	3.0
73e3636bec [f410d7e7]	etendo	288185	2.99	288185	0.270	0.132	8.558	0.087	77.9
9ea37f4950 [39cec726]	etendo	256404	2.66	256404	0.009	0.007	1.009	0.005	2.3
8bc1a23ef7 [bff561c]	etendo	176306	1.83	176305	1.733	0.003	21.815	2.169	305.6
d41328baef [24874c22]	etendo	176238	1.83	176238	0.005	0.003	0.412	0.005	0.9
df99961951 [9cb9259b]	etendo	162886	1.69	162886	0.018	0.012	1.959	0.009	2.9
891e82e5c1 [5a0bb3c]	etendo	100606	1.04	100606	0.003	0.002	0.201	0.001	0.3
7410f735c6 [dcb3768d]	etendo	88158	0.91	88157	0.312	0.008	4.531	0.154	27.5
441fbe3af8 [4a5ca56d]	etendo	88158	0.91	88158	0.005	0.003	0.257	0.004	0.4
5c208ba241 [381eb299]	etendo	53352	0.55	53352	0.014	0.010	0.252	0.004	0.7
fa1b74d06f [c1b84187]	etendo	49312	0.51	359375	0.040	0.014	0.640	0.037	2.0
ebd66f2e50 [2f2197e3]	etendo	49312	0.51	30751	0.013	0.006	0.398	0.008	0.7
1b3d7b3f6d [a00bdbff]	etendo	49182	0.51		0.007	0.004	0.483	0.003	0.3
ffadc5ac47 [25ee072c]	etendo	39566	0.41	39564	0.020	0.009	1.212	0.010	0.8
d7389ab8e1 [af192082]	etendo	34695	0.36	34695	0.003	0.002	0.063	0.001	0.1
9425961593 [7e6ec72b]	etendo	29309	0.30	38659	0.019	0.013	0.982	0.009	0.6
22f6515cc6 [75d947f3]	etendo	19160	0.20	75124	0.018	0.013	0.083	0.005	0.3

Top SQL by shared blocks fetched

Query ID	Database	blks fetched	%Total	Hits(%)	Elapsed(s)	Rows	Executions
4108c96b3f [ca2988bd]	etendo	41387874	43.91	100.00	177.6	2716	197
73e3636bec [f410d7e7]	etendo	9546325	10.13	99.97	77.9	288185	288185
c9e2eb425b [de5cc8a]	etendo	6722450	7.13	100.00	17.2	4482810	6722450
0c133f89fa [47df1ade]	etendo	4973300	5.28	99.98	17.0	23	23
b9bb8a4422 [eb812a48]	etendo	4973162	5.28	99.98	17.0		23
adb1c31f79 [948be82f]	etendo	3044187	3.23	84.21	128.4		1
58d3d7b94c [303fdc1e]	etendo	2467108	2.62	100.00	1.3	2408	23
9d620ef0cc [f45d97ac]	etendo	2055172	2.18	100.00	4.8	10	7
785a907bc3 [92946197]	etendo	1637565	1.74	99.97	4.7	878	23
5fa24dc926 [22217272]	etendo	1618119	1.72	100.00	2.3	51037	23
c2b6cfc2bf [ad3afc69]	etendo	1116095	1.18	100.00	4.3	1009731	2774
9625146448 [b7edb1a4]	etendo	907872	0.96	100.00	2.9	289528	289528
0c13a0abe2 [4ed26d58]	etendo	906272	0.96	100.00	3.0	31151	289220
503324b603 [d34207c3]	etendo	831049	0.88	100.00	6.1	253552	289220
7c49e0fca3 [37eecc4]	etendo	830784	0.88	100.00	4.8		552
9ea37f4950 [39cec726]	etendo	776434	0.82	100.00	2.3	256404	256404
0f194ad1e6 [6d193752]	etendo	733809	0.78	100.00	2.2	29513	22
df99961951 [9cb9259b]	etendo	489670	0.52	100.00	2.9	162886	162886
d83dccf995 [2166520c]	etendo	379812	0.40	100.00	0.3	6557	5797
1d911b5cd9 [1c4d8fed]	etendo	339826	0.36	100.00	11.9	2762	2762

Query ID	Database	Reads	%Total	Hits(%)	Elapsed(s)	Rows	Executions
adb1c31f79 [948be82f]	etendo	480568	96.07	84.21	128.4		1
73e3636bec [f410d7e7]	etendo	2466	0.49	99.97	77.9	288185	288185
50b8978166 [b54ea3e2]	etendo	1916	0.38	97.68	0.6		13
12a81791af [7eea2aca]	etendo	1731	0.35	96.42	0.2	5245	5245
11b3a7981f [61e12bc8]	etendo	996	0.20	99.66	0.7	47	1
0c247acdf0 [948be82f]	template1	970	0.19	97.61	2.8		1
2e0b729b87 [948be82f]	postgres	945	0.19	97.67	2.9		1
0c133f89fa [47df1ade]	etendo	891	0.18	99.98	17.0	23	23
b9bb8a4422 [eb812a48]	etendo	891	0.18	99.98	17.0		23
785a907bc3 [92946197]	etendo	497	0.10	99.97	4.7	878	23
b8b9950890 [532de794]	etendo	372	0.07	97.22	0.2	474	474
9425961593 [7e6ec72b]	etendo	303	0.06	99.75	0.6	38659	29309
4108c96b3f [ca2988bd]	etendo	282	0.06	100.00	177.6	2716	197
cb9c289625 [15eb0b0]	etendo	244	0.05	97.45	0.1	1353	1353
2be957f8e4 [96b90f61]	etendo	243	0.05	98.08	0.0	3157	3157
3db6ec29e3 [262cee45]	etendo	207	0.04	99.31	0.4	3	3
ce6a86d8e2 [61de0adf]	etendo	207	0.04	99.31	0.4	3	3
b1ad12ea83 [da3ad8a5]	etendo	205	0.04	96.39	0.1	41	41
140f3eb685 [59d1e156]	etendo	195	0.04	99.53	0.9	23	23
82158f9391 [39efea14]	etendo	165	0.03	98.83	0.0	12848	97

Top SQL by shared blocks dirtied

Query ID	Database	Dirtied	%Total	Hits(%)	Elapsed(s)	Rows	Executions
73e3636bec [f410d7e7]	etendo	72527	36.65	99.97	77.9	288185	288185
adb1c31f79 [948be82f]	etendo	62615	31.64	84.21	128.4		1
0c133f89fa [47df1ade]	etendo	15791	7.98	99.98	17.0	23	23
b9bb8a4422 [eb812a48]	etendo	15791	7.98	99.98	17.0		23
fdd1193fad [3b0e4e8a]	etendo	4032	2.04	99.96	3.8	54119	46
d0b36135c7 [a0544a5f]	etendo	3189	1.61	99.97	3.7	32879	46
140f3eb685 [59d1e156]	etendo	1796	0.91	99.53	0.9	23	23
c525c04235 [d2f1c69a]	etendo	1624	0.82	99.30	0.1	305	305
9b16673e73 [423e83ff]	etendo	1491	0.75	99.19	0.1		2
f68dd8a1a9 [d422fd3a]	etendo	911	0.46	100.00	0.6		44
4813705ddb [6f2d0383]	etendo	804	0.41	100.00	0.3	1337	1337
07181527b0 [f6f43f8d]	etendo	658	0.33	100.00	0.0	44707	19
167f11efcd [76ede534]	etendo	636	0.32	97.62	0.1		2
b8b9950890 [532de794]	etendo	602	0.30	97.22	0.2	474	474
bda4372001 [a3318de1]	etendo	553	0.28	99.88	0.2	3246	22
65758f3c61 [2616291e]	etendo	499	0.25	99.95	0.4	7539	42
1251dece16 [7e502be6]	etendo	446	0.23	99.99	0.5		42
c4007ad529 [524b433d]	etendo	391	0.20	98.86	0.0	97	1
82158f9391 [39efea14]	etendo	387	0.20	98.83	0.0	12848	97
65d1e4d453 [fd0ba0d1]	etendo	333	0.17	99.91	0.1	20	15

Top SQL by shared blocks written

Query ID	Database	Written	%Total	%BackendW	Hits(%)	Elapsed(s)	Executions
adb1c31f79 [948be82f]	etendo	58453	23.01	40.98	84.21	128.4	1
0c247acdf0 [948be82f]	template1	55	0.02	0.04	97.61	2.8	1
2e0b729b87 [948be82f]	postgres	55	0.02	0.04	97.67	2.9	1

Query ID

Database

Written

%Total

%BackendW

Hits(%)

Elapsed(s)

Rows

Executions

adb1c31f79

[948be82f]

etendo

58453

23.01

40.98

84.21

128.4

0c247acdf0

[948be82f]

template1

0.02

0.04

97.61

2.8

2e0b729b87

[948be82f]

postgres

0.02

0.04

97.67

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
8bc1a23ef7 [bff561c]	etendo	128768715	49.46	18177	99.98	65077051	99.97					305.6	176305	176306
d41328baef [24874c22]	etendo	180609	98.71	4	0.02	2330	0.00					0.9	176238	176238
24a71b82fd [cbb8c03]	etendo	2395	13.15			2080	0.00					0.4	12	12
5a01956e14 [2424fc9a]	etendo	2395	13.15			2080	0.00					0.3	3	3
3db6ec29e3 [262cee45]	etendo	2395	13.15			2080	0.00					0.4	3	3
d49f9b6dc1 [597b73e5]	etendo	2082	0.10			2080	0.00					0.0	2	2
ce6a86d8e2 [61de0adf]	etendo	2395	13.15			2080	0.00					0.4	3	3
aeda2b38c9 [b2aaa0b2]	etendo	2395	13.15			2080	0.00					0.1	3	3
2f8789e4ba [e4b84551]	etendo	2395	13.15			2080	0.00					0.1	3	3
441fbe3af8 [4a5ca56d]	etendo	90345	99.19			732	0.00					0.4	88158	88158
da3f1249fd [4f5e6942]	etendo	12921	99.17			107	0.00					0.1	12609	12609
8c36a5bf11 [f560cf4b]	etendo	12908	99.19			104	0.00					0.1	12596	12596
14c3fe3bcf [37bec49c]	etendo	1				1	0.00					0.0	1	1
6757558638 [ce05bc80]	etendo	10	90.00			1	0.00					0.0	10	10

Complete list of SQL texts

QueryID	Query Text
cb9c289625	SELECT APRM_ISPAYMENTCONFIRMED($1,$2) AS RESULT FROM DUAL
7c49e0fca3	select 1 as id from dual where exists ( select 1 from ( SELECT a.DateAcct as dateacct FROM M_InOut a WHERE a.ad_client_id = $1 AND a.ad_org_id in ('0', '1000003', 'E5C644C994CA4E6DB384AF0325704F1E', '1000002') AND a.posted = 'N' AND a.processed = 'Y' AND (a.processing = 'N' OR a.processing IS NULL) AND EXISTS ( SELECT 1 FROM c_period p WHERE a.DateAcct >= p.StartDate AND a.DateAcct < p.EndDate + 1 AND EXISTS ( SELECT 1 FROM c_periodcontrol pc WHERE pc.c_period_id = p.c_period_id AND ad_org_getperiodcontrolallow(a.ad_org_id) = pc.ad_org_id AND pc.docbasetype = $2 AND pc.periodstatus = 'O' ) )) b where 1=1 )
891e82e5c1	SELECT $4 FROM ONLY "profile"."last_stat_database" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "sample_id" OPERATOR(pg_catalog.=) $2 AND "datid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
8bc1a23ef7	delete from ad_context_info
24a71b82fd	SELECT AD_EXTENSION_POINT_HANDLER(v_ep_instance, v_extension_point_id)
c9e2eb425b	SELECT LEVELNO FROM AD_ORG_TREE WHERE AD_ORG_ID = p_orgid AND AD_PARENT_ORG_ID = p_parentorgid AND AD_CLIENT_ID = p_clientid
1d911b5cd9	select adsystem0_.AD_System_ID as AD_Syste1_115_0_, adsystem0_.AD_Client_ID as AD_Clien2_115_0_, adsystem0_.AD_Org_ID as AD_Org_I3_115_0_, adsystem0_.IsActive as IsActive4_115_0_, adsystem0_.Created as Created5_115_0_, adsystem0_.CreatedBy as CreatedB6_115_0_, adsystem0_.Updated as Updated7_115_0_, adsystem0_.UpdatedBy as UpdatedB8_115_0_, adsystem0_.Name as Name9_115_0_, adsystem0_.Info as Info10_115_0_, adsystem0_.Version as Version11_115_0_, adsystem0_.ReleaseNo as Release12_115_0_, adsystem0_.TAD_Recordrange as TAD_Rec13_115_0_, adsystem0_.TAD_Recordrange_Info as TAD_Rec14_115_0_, adsystem0_.TAD_Transactionalrange as TAD_Tra15_115_0_, adsystem0_.TAD_Theme as TAD_The16_115_0_, adsystem0_.Instance_Key as Instanc17_115_0_, adsystem0_.Activation_Key as Activat18_115_0_ from AD_System adsystem0_ where adsystem0_.AD_System_ID=$1
d83dccf995	select distinct docbasetype as name from c_doctype where ad_table_id = $1 and ad_client_id = $2
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)
5a01956e14	SELECT C_INVOICE_POST($3, p_Invoice_ID)
d41328baef	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
ffadc5ac47	SELECT coalesce(t.MSGTEXT, m.MSGTEXT) AS MSGTEXT FROM AD_MESSAGE m left join AD_MESSAGE_TRL t on m.AD_MESSAGE_ID = t.AD_MESSAGE_ID and t.AD_LANGUAGE = $1 WHERE m.VALUE=$2
65758f3c61	INSERT INTO last_stat_user_functions( server_id, sample_id, datid, funcid, schemaname, funcname, funcargs, calls, total_time, self_time, trg_fn ) SELECT sserver_id, s_id, qres.datid, funcid, schemaname, funcname, funcargs, dbl.calls AS calls, dbl.total_time AS total_time, dbl.self_time AS self_time, dbl.trg_fn FROM dblink($18, t_query) AS dbl ( funcid oid, schemaname name, funcname name, funcargs text, calls bigint, total_time double precision, self_time double precision, trg_fn boolean )
3db6ec29e3	SELECT * FROM C_Invoice_Create0($1)
513a2c0405	SELECT (case when ad_table.po_window_id is null then '' else ad_column_identifier('AD_Window',TO_CHAR(ad_table.po_window_id),$1) end)\|\| (case when ad_table.po_window_id is null then '' else ' - ' end)\|\| ad_column_identifier('AD_Window',TO_CHAR(ad_table.ad_window_id),$2) FROM AD_TABLE WHERE AD_TABLE_ID = $3
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)
14c3fe3bcf	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
5c208ba241	SELECT AD_CLIENT_ID,AD_ORG_ID, ISACTIVE, UPDATED,UPDATEDBY,ALIAS, COMBINATION, DESCRIPTION, ISFULLYQUALIFIED, C_ACCTSCHEMA_ID, ACCOUNT_ID, M_PRODUCT_ID, C_BPARTNER_ID,AD_ORGTRX_ID, C_LOCFROM_ID, C_LOCTO_ID, C_SALESREGION_ID, C_PROJECT_ID, C_CAMPAIGN_ID, C_ACTIVITY_ID, USER1_ID,USER2_ID, '' as UseSuspenseBalancing, '' as SuspenseBalancing_Acct, '' as UseSuspenseError, '' as SuspenseError_Acct, '' as UseCurrencyBalancing, '' as CurrencyBalancing_Acct, '' as RetainedEarning_Acct, '' as IncomeSummary_Acct, '' as InterCompanyDueTo_Acct, '' as InterCompanyDueFrom_Acct FROM C_ValidCombination WHERE C_ValidCombination_ID=$1
9ea37f4950	select max(this_.Lastpayment) as y0_ from FIN_Payment_Sched_Inv_V this_ where this_.C_Invoice_ID=$1 and this_.Isactive=$2 limit $3
82158f9391	DELETE FROM ONLY "public"."ad_session_usage_audit" WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "ad_session_id"::pg_catalog.text
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 )
2b98e8b0ee	delete from ad_context_info
9b16673e73	vacuum analyze AD_Process_Run
0c133f89fa	SELECT profile.take_sample()
441fbe3af8	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
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
da3f1249fd	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
c4007ad529	delete from AD_Session where Created<now()-$1
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))
d49f9b6dc1	SELECT AD_USER_ID, PROCESSTYPE, PROCESSID FROM AD_CONTEXT_INFO
140f3eb685	SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)
ce6a86d8e2	SELECT * FROM C_Invoice_Create(p_PInstance_ID, $2)
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
0f194ad1e6	SELECT st.relid,st.schemaname,st.relname,st.seq_scan,st.seq_tup_read,st.idx_scan,st.idx_tup_fetch,st.n_tup_ins,st.n_tup_upd,st.n_tup_del,st.n_tup_hot_upd,st.n_live_tup,st.n_dead_tup,st.n_mod_since_analyze,$1 as n_ins_since_vacuum,st.last_vacuum,st.last_autovacuum,st.last_analyze,st.last_autoanalyze,st.vacuum_count,st.autovacuum_count,st.analyze_count,st.autoanalyze_count,stio.heap_blks_read,stio.heap_blks_hit,stio.idx_blks_read,stio.idx_blks_hit,stio.toast_blks_read,stio.toast_blks_hit,stio.tidx_blks_read,stio.tidx_blks_hit,CASE locked.objid WHEN st.relid THEN $2 ELSE pg_catalog.pg_table_size(st.relid) - coalesce(pg_catalog.pg_relation_size(class.reltoastrelid),$3) END relsize,$4 relsize_diff,class.reltablespace AS tablespaceid,class.reltoastrelid,class.relkind,class.relpages::bigint * current_setting($5)::bigint AS relpages_bytes,$6 AS relpages_bytes_diff FROM pg_catalog.pg_stat_all_tables st JOIN pg_catalog.pg_statio_all_tables stio USING (relid, schemaname, relname) JOIN pg_catalog.pg_class class ON (st.relid = class.oid) LEFT OUTER JOIN LATERAL (WITH RECURSIVE deps (objid) AS (SELECT relation FROM pg_catalog.pg_locks WHERE granted AND locktype = $7 AND mode=$8 UNION SELECT refobjid FROM pg_catalog.pg_depend d JOIN deps dd ON (d.objid = dd.objid)) SELECT objid FROM deps) AS locked ON (st.relid = locked.objid)
4813705ddb	update C_Invoice set Updated=$1, DaysTillDue=$2, LastCalculatedOnDate=$3 where C_Invoice_ID=$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
22f6515cc6	SELECT C_AcctSchema_Element_ID,SeqNo,Name,ElementType,C_Element_ID,IsMandatory,IsBalanced, Org_ID,C_ElementValue_ID,C_BPartner_ID,M_Product_ID,C_Activity_ID,C_Location_ID, C_Campaign_ID,C_Project_ID,C_SalesRegion_ID FROM C_AcctSchema_Element WHERE C_AcctSchema_ID=$1 AND IsActive='Y' ORDER BY SeqNo
167f11efcd	vacuum analyze prsync_entry
1251dece16	ANALYZE last_stat_indexes
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)
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)
2be957f8e4	select isinvoicepaid, fin_payment_schedule_order, fin_payment_schedule_invoice from fin_payment_scheduledetail where fin_payment_scheduledetail_id=v_p_fin_psd_id
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)
c2b6cfc2bf	select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, texttrl.ad_language as trlLang, texttrl.text as trlText, texttrl.istranslated as isTranslated, 1 as orderSeq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = '/org/openbravo/erpCommon/security/Login.html' and text.isused = 'Y' and texttrl.ad_language = 'en_US' UNION select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, texttrl.ad_language as trlLang, texttrl.text as trlText, texttrl.istranslated as isTranslated, 3 as orderSeq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename is null and text.isused = 'Y' and texttrl.ad_language = 'en_US' UNION select text.filename as filename, text.text as text, text.isused as isUsed, text.ad_module_id as moduleId, 'en_US' as trlLang, text.text as trlText, 'N' as isTranslated, 2 as orderSeq from ad_textinterfaces text where text.ad_textinterfaces_id NOT IN (SELECT t.ad_textinterfaces_id FROM ad_textInterfaces t, ad_textinterfaces_trl trl WHERE t.ad_textinterfaces_id = trl.ad_textinterfaces_id and trl.ad_language = 'en_US') and (text.filename is null OR text.filename = '/org/openbravo/erpCommon/security/Login.html' ) and text.isused = 'Y' order by orderSeq
d7389ab8e1	SELECT $4 FROM ONLY "profile"."last_stat_tablespaces" x WHERE "server_id" OPERATOR(pg_catalog.=) $1 AND "sample_id" OPERATOR(pg_catalog.=) $2 AND "tablespaceid" OPERATOR(pg_catalog.=) $3 FOR KEY SHARE OF x
aeda2b38c9	UPDATE C_BPARTNER SET SO_CREDITUSED = COALESCE(SO_CREDITUSED,$24) + v_ConvertedAmount, UPDATED = TO_DATE(NOW()) WHERE C_BPARTNER_ID = v_BPartner_ID
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)
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
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
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
6757558638	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
c525c04235	INSERT INTO AD_Process_Run (AD_Org_ID, AD_Client_ID, Isactive, Created, Createdby, Updated, UpdatedBy, AD_Process_Run_ID, Status, Start_Time, Runtime, Log, AD_Process_Request_ID, Scheduler_Instance) VALUES ($1, $2, 'Y', NOW(), $3, NOW(), $4, $5, $6, NOW(), $7, $8, $9, $10)
503324b603	select financialm0_.C_Invoice_ID as C_Invoi13_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_1_, financialm0_.C_Debt_Payment_ID as C_Debt_P1_218_0_, financialm0_.AD_Client_ID as AD_Clien2_218_0_, financialm0_.AD_Org_ID as AD_Org_I3_218_0_, financialm0_.IsActive as IsActive4_218_0_, financialm0_.Created as Created5_218_0_, financialm0_.CreatedBy as CreatedB6_218_0_, financialm0_.Updated as Updated7_218_0_, financialm0_.UpdatedBy as UpdatedB8_218_0_, financialm0_.IsReceipt as IsReceip9_218_0_, financialm0_.C_Settlement_Cancel_ID as C_Settl10_218_0_, financialm0_.C_Settlement_Generate_ID as C_Settl11_218_0_, financialm0_.Description as Descrip12_218_0_, financialm0_.C_Invoice_ID as C_Invoi13_218_0_, financialm0_.C_BPartner_ID as C_BPart14_218_0_, financialm0_.C_Currency_ID as C_Curre15_218_0_, financialm0_.C_CashLine_ID as C_CashL16_218_0_, financialm0_.C_BankAccount_ID as C_BankA17_218_0_, financialm0_.C_CashBook_ID as C_CashB18_218_0_, financialm0_.PaymentRule as Payment19_218_0_, financialm0_.IsPaid as IsPaid20_218_0_, financialm0_.Amount as Amount21_218_0_, financialm0_.WriteOffAmt as WriteOf22_218_0_, financialm0_.Dateplanned as Datepla23_218_0_, financialm0_.IsManual as IsManua24_218_0_, financialm0_.IsValid as IsValid25_218_0_, financialm0_.C_BankStatementLine_ID as C_BankS26_218_0_, financialm0_.Changesettlementcancel as Changes27_218_0_, financialm0_.Cancel_Processed as Cancel_28_218_0_, financialm0_.Generate_Processed as Generat29_218_0_, financialm0_.GLItemAmt as GLItemA30_218_0_, financialm0_.Isdirectposting as Isdirec31_218_0_, financialm0_.C_Glitem_ID as C_Glite32_218_0_, financialm0_.C_Order_ID as C_Order33_218_0_, financialm0_.C_Project_ID as C_Proje34_218_0_, financialm0_.IsAutomaticGenerated as IsAutom35_218_0_, financialm0_.Status as Status36_218_0_, financialm0_.Status_Initial as Status_37_218_0_, financialm0_.C_Withholding_ID as C_Withh38_218_0_, financialm0_.Withholdingamount as Withhol39_218_0_ from C_Debt_Payment financialm0_ where financialm0_.C_Invoice_ID=$1
f68dd8a1a9	ANALYZE last_stat_tables
b1ad12ea83	SELECT C_ORDERLINETAX_INSERT(new.AD_Org_ID, new.C_Order_ID, new.C_OrderLine_ID, new.UpdatedBy, new.C_Tax_ID, new.C_Tax_ID, v_newLineNetAmt, v_newLineAlternate, v_Prec)
7410f735c6	delete from ad_context_info
2f8789e4ba	SELECT aprm_gen_paymentschedule_inv($1) FROM DUAL
b9bb8a4422	SELECT * FROM take_sample_subset(1,0)
73e3636bec	update C_Invoice set Updated=$1, LastCalculatedOnDate=$2 where C_Invoice_ID=$3
9d620ef0cc	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 invoicecan0_.Dateordered, invoicecan0_.C_Invoice_Candidate_V_ID limit $4
8c36a5bf11	insert into ad_context_info (ad_user_id, ad_session_id, processType, processId) values ($1, $2, $3, $4)
07181527b0	DELETE FROM last_stat_indexes WHERE server_id=sserver_id AND sample_id != s_id
65d1e4d453	DELETE FROM samples s USING servers n WHERE n.server_id = s.server_id AND s.server_id = sserver_id AND s.sample_time < now() - (COALESCE(n.max_sample_age,ret) \|\| $7)::interval AND (s.server_id,s.sample_id) NOT IN (SELECT server_id,sample_id FROM bl_samples WHERE server_id = sserver_id)

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_3	ad_context_info	1055 GB	176308			176306		176305
etendo	pg_default	pg_temp_4	ad_context_info	283 GB	88223			88222		88221
etendo	pg_default	pg_temp_8	ad_context_info	90 GB	12596			12596		12596
etendo	pg_default	pg_temp_5	ad_context_info	10 GB	12667			12667		12666
etendo	pg_default	pg_catalog	pg_class	4000 MB	5951	601889	591086	1869	6728	1869	1376
etendo	pg_default	public	fact_acct	3417 MB	13	5	4	9
etendo	pg_default	public	fact_acct(TOAST)
etendo	pg_default	profile	last_stat_database	2172 MB	101367			92		92
etendo	pg_default	public	ad_audit_trail	1530 MB	3
etendo	pg_default	public	ad_audit_trail(TOAST)
etendo	pg_default	public	m_inout	847 MB	72	2562	2561
etendo	pg_default	public	m_inout(TOAST)
etendo	pg_default	public	ad_org_tree	796 MB	101932
etendo	pg_default	public	c_orderline	699 MB	12	262703	1182039	39	200	7	148
etendo	pg_default	public	c_orderline(TOAST)
etendo	pg_default	public	m_productprice	661 MB	198	3940332	3940332
etendo	pg_default	public	m_productprice(TOAST)
etendo	pg_default	profile	last_stat_tablespaces	544 MB	34845			44		44
etendo	pg_default	profile	last_stat_tablespaces(TOAST)
etendo	pg_default	public	c_invoice	478 MB	21	291578	1347602	3	289573		24
etendo	pg_default	public	c_invoice(TOAST)
postgres	pg_default	pg_catalog	pg_class	349 MB	3438	30424	30182	107	388	107	129
etendo	pg_default	public	c_order	344 MB	23	27131	58801	4	140	1	116
etendo	pg_default	public	c_order(TOAST)
etendo	pg_default	pg_catalog	pg_attribute	294 MB	70	271996	1193006	24153		24153
etendo	pg_default	profile	last_stat_indexes	275 MB	185	34487	328329	54119	1262	54119
etendo	pg_default	public	m_inoutline	271 MB	8	5813	2619
etendo	pg_default	public	m_inoutline(TOAST)
etendo	pg_default	pg_catalog	pg_proc	229 MB	125	8442	14522
etendo	pg_default	pg_catalog	pg_proc(TOAST)			677	1746

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_3	ad_context_info	128951474	50.70
etendo	pg_default	pg_temp_4	ad_context_info	32398077	12.74
etendo	pg_default	public	m_productprice	4023974	1.58	11859538	4.66
etendo	pg_default	public	m_product	4220408	1.66	8481951	3.33
etendo	pg_default	pg_temp_8	ad_context_info	11172548	4.39
etendo	pg_default	public	c_invoice	3484026	1.37	7573741	2.98
etendo	pg_default	public	m_product_trl			4049795	1.59
etendo	pg_default	profile	last_stat_tables	3465221	1.36	107239	0.04
etendo	pg_default	public	fin_payment_schedule	877081	0.34	2541996	1.00
etendo	pg_default	pg_catalog	pg_class	1100149	0.43	1259398	0.50
etendo	pg_default	public	c_orderline	754178	0.30	805113	0.32
etendo	pg_default	public	c_debt_payment	487898	0.19	820505	0.32
etendo	pg_default	pg_catalog	pg_attribute	445922	0.18	651219	0.26
etendo	pg_default	public	ad_textinterfaces	339902	0.13	565464	0.22
etendo	pg_default	profile	last_stat_indexes	567428	0.22	203305	0.08
etendo	pg_default	public	c_bpartner	248943	0.10	448322	0.18
etendo	pg_default	pg_temp_5	ad_context_info	693303	0.27
etendo	pg_default	pg_catalog	pg_index	168381	0.07	322378	0.13
etendo	pg_default	public	c_settlement	158761	0.06	322743	0.13
etendo	pg_default	public	fact_acct	467624	0.18	345	0.00

DB	Tablespace	Schema	Table	Heap	Ix	TOAST	TOAST-Ix	Hit(%)
Blks	%Total	Blks	%Total	Blks	%Total	Blks	%Total
etendo	pg_default	pg_temp_3	ad_context_info	65081461	99.33							49.53
etendo	pg_default	public	ad_audit_trail	130590	0.20							42.19
etendo	pg_default	public	fact_acct	67293	0.10	37	0.00					85.61
etendo	pg_default	public	ad_image	790	0.00			56470	0.09	886	0.00	65.41
etendo	pg_default	public	c_orderline	14913	0.02	1860	0.00					98.92
etendo	pg_default	public	psat_checklist_result	15077	0.02	2	0.00					50.08
etendo	pg_default	public	c_invoice	5830	0.01	6478	0.01					99.89
etendo	pg_default	public	m_inoutline	8654	0.01	808	0.00					84.00
etendo	pg_default	public	c_orderlinetax	7367	0.01	195	0.00					67.45
etendo	pg_default	public	ad_session_usage_audit	5140	0.01	522	0.00					84.54
etendo	pg_default	public	fin_payment_schedule	3796	0.01	449	0.00					99.88
etendo	pg_default	public	fin_payment	3163	0.00	188	0.00					76.56
etendo	pg_default	public	fin_payment_scheduledetail	2721	0.00	581	0.00					92.71
etendo	pg_default	public	ad_process_run	2689	0.00	127	0.00	11	0.00	10	0.00	96.09
etendo	pg_default	public	fin_payment_detail	1909	0.00	251	0.00					62.11
etendo	pg_default	public	prsync_entry	1051	0.00	92	0.00	825	0.00	16	0.00	79.94
etendo	pg_default	pg_catalog	pg_attribute	1439	0.00	487	0.00					99.82
etendo	pg_default	profile	sample_stat_tables	1784	0.00	108	0.00					96.14
etendo	pg_default	pg_catalog	pg_statistic	1173	0.00	69	0.00	624	0.00	20	0.00	99.38
etendo	pg_default	profile	last_stat_indexes	960	0.00	111	0.00					99.86

Top DML tables

DB	Tablespace	Schema	Table	Ins	Upd	Del	Upd(HOT)	SeqScan	SeqFet	IxScan	IxFet
etendo	pg_default	pg_temp_3	ad_context_info	176306		176305		176308	176307
etendo	pg_default	public	c_invoice	3	289573		24	21	962943	291578	1347602
etendo	pg_default	public	c_invoice(TOAST)
etendo	pg_default	pg_temp_4	ad_context_info	88222		88221		88223	88222
etendo	pg_default	profile	last_stat_indexes	54119	1262	54119		185	865904	34487	328329
etendo	pg_default	profile	last_stat_tables	32879	3411	32879	49	186	528924	7930	3054632
etendo	pg_default	pg_catalog	pg_attribute	24153		24153		70	93962	271996	1193006
etendo	pg_default	pg_temp_5	ad_context_info	12667		12666		12667	12666
etendo	pg_default	pg_temp_8	ad_context_info	12596		12596		12596	12596
etendo	pg_default	pg_catalog	pg_statistic		16188		13216	2	16977	76930	62479
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	2311		2312				11222	16486
etendo	pg_default	profile	last_stat_user_functions	8257	678	8257	30	389	245915
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	public	ad_session_usage_audit	474		12848		4	334276	97	12848
etendo	pg_default	public	ad_session_usage_audit(TOAST)
etendo	pg_default	pg_catalog	pg_class	1869	6728	1869	1376	5951	17663837	601889	591086
etendo	pg_default	pg_catalog	pg_depend	4579		4582		9	205889	44124	49867
etendo	pg_default	profile	sample_stat_tables	3411		3253		25	609497	146	3448
etendo	pg_default	pg_catalog	pg_type	2157		2157		12	30597	150450	142109
etendo	pg_default	profile	sample_statements	1383		1402		49	509778	101	1402
etendo	pg_default	profile	sample_statements(TOAST)
etendo	pg_default	profile	sample_stat_indexes	1262		1216		25	237850	150	1294
postgres	pg_default	pg_catalog	pg_attribute	1215		1215		37	8088	29607	64945
postgres	pg_global	pg_catalog	pg_shdepend	709		709		9	15678	5507	1662
etendo	pg_global	pg_catalog	pg_shdepend	709		709		9	15678	5507	1662

Top tables by updated/deleted tuples

DB	Tablespace	Schema	Table	Upd	Upd(HOT)	Del	Vacuum	AutoVacuum	Analyze	AutoAnalyze
etendo	pg_default	public	c_invoice	289573	24			23	1	23
etendo	pg_default	public	c_invoice(TOAST)
etendo	pg_default	pg_temp_3	ad_context_info			176305
etendo	pg_default	pg_temp_4	ad_context_info			88221
etendo	pg_default	profile	last_stat_indexes	1262		54119		25	47	23
etendo	pg_default	profile	last_stat_tables	3411	49	32879		25	47	23
etendo	pg_default	pg_catalog	pg_attribute			24153		1	1	1
etendo	pg_default	pg_catalog	pg_statistic	16188	13216			1
etendo	pg_default	pg_catalog	pg_statistic(TOAST)			2312		4
etendo	pg_default	public	ad_session_usage_audit			12848			1	1
etendo	pg_default	public	ad_session_usage_audit(TOAST)
etendo	pg_default	pg_temp_5	ad_context_info			12666
etendo	pg_default	pg_temp_8	ad_context_info			12596
etendo	pg_default	profile	last_stat_user_functions	678	30	8257		25	47	23
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_catalog	pg_class	6728	1376	1869		1	1	1
etendo	pg_default	pg_catalog	pg_depend			4582			1	1
etendo	pg_default	profile	sample_stat_tables			3253			1	2
etendo	pg_default	pg_catalog	pg_type			2157		1	1	1
etendo	pg_default	profile	sample_statements			1402			1	2
etendo	pg_default	profile	sample_statements(TOAST)
etendo	pg_default	profile	sample_stat_indexes			1216			1	2
postgres	pg_default	pg_catalog	pg_attribute			1215		1	1	1
etendo	pg_default	public	prsync_entry	6	6	800	2		3
etendo	pg_default	public	prsync_entry(TOAST)			270	2	1
etendo	pg_default	public	ad_process_run	305		650	2		3
etendo	pg_default	public	ad_process_run(TOAST)			5	2

Top growing tables

DB	Tablespace	Schema	Table	Size	Growth	Ins	Upd	Del	Upd(HOT)
etendo	pg_default	pg_temp_3	ad_context_info	11 MB	11 MB	176306		176305
etendo	pg_default	pg_temp_4	ad_context_info	5864 kB	5864 kB	88222		88221
etendo	pg_default	pg_temp_5	ad_context_info	864 kB	864 kB	12667		12666
etendo	pg_default	pg_catalog	pg_statistic	4872 kB	48 kB		16188		13216
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	4424 kB	24 kB	2311		2312
etendo	pg_default	public	m_stock_proposed	48 kB	32 kB			12
etendo	pg_default	public	m_stock_proposed(TOAST)
etendo	pg_default	profile	sample_statements_total	136 kB	32 kB	57		60
etendo	pg_default	profile	sample_statements_total(TOAST)
etendo	pg_default	public	ad_ep_instance_para	32 kB	24 kB	69		69
etendo	pg_default	public	ad_ep_instance_para(TOAST)
etendo	pg_default	public	ad_process_request	64 kB	8192 bytes		313	4	305
etendo	pg_default	public	ad_process_request(TOAST)
etendo	pg_default	profile	last_stat_user_functions	240 kB	8192 bytes	8257	678	8257	30
etendo	pg_default	profile	last_stat_user_functions(TOAST)
etendo	pg_default	pg_temp_6	ad_context_info	8192 bytes	8192 bytes	113		112
etendo	pg_default	pg_temp_7	ad_context_info	8192 bytes	8192 bytes	59		58

Top indexes by blocks fetched

DB	Tablespace	Schema	Table	Index	Scans	Blks	%Total
etendo	pg_default	public	m_productprice	m_productprice_key	3939960	11858784	4.66
etendo	pg_default	public	m_product	m_product_key	4221211	8471325	3.33
etendo	pg_default	public	m_product_trl	m_product_trl_product_langu_un	4049405	4049600	1.59
etendo	pg_default	public	fin_payment_schedule	fin_paym_sch_inv_idx	835219	2534007	1.00
etendo	pg_default	public	c_invoice	c_invoice_key	290143	1759669	0.69
etendo	pg_default	pg_catalog	pg_class	pg_class_oid_index	577258	1176706	0.46
etendo	pg_default	public	c_invoice	c_invoice_bpartner	38	886556	0.35
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc		880627	0.35
etendo	pg_default	public	c_orderline	c_orderline_order2	250865	762194	0.30
etendo	pg_default	public	c_invoice	c_invoice_paid		698802	0.27
etendo	pg_default	public	c_invoice	c_invoice_posted	1386	692428	0.27
etendo	pg_default	public	c_invoice	c_invoice_salesrep		647948	0.25
etendo	pg_default	public	c_invoice	c_invoice_updated		594483	0.23
etendo	pg_default	public	c_invoice	c_invoice_docno	3	585541	0.23
etendo	pg_default	public	c_debt_payment	c_debt_payment_invoice_idx	289226	579836	0.23
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	259820	577668	0.23
etendo	pg_default	public	ad_textinterfaces	ad_textinterfaces_key	269481	544295	0.21
etendo	pg_default	public	c_bpartner	c_bpartner_key	222749	445785	0.18
etendo	pg_default	public	c_settlement	c_settlement_key	160360	321781	0.13
etendo	pg_default	public	c_invoice	c_invoice_order	8	321672	0.13

DB	Tablespace	Schema	Table	Index	Scans	Blk Reads	Hits(%)
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc		1433	99.84
etendo	pg_default	public	c_invoice	c_invoice_paid		1209	99.83
etendo	pg_default	public	c_orderline	c_orderline_order2	250865	997	99.87
etendo	pg_default	public	c_invoice	c_invoice_posted	1386	954	99.86
etendo	pg_default	public	ad_image(TOAST)	pg_toast_74472_index	13814	886	97.95
etendo	pg_default	public	c_orderline	c_orderline_key	6397	801	95.91
etendo	pg_default	public	m_inoutline	m_inoutline_orderline	5468	774	95.29
etendo	pg_default	public	c_invoice	c_invoice_docno	3	728	99.88
etendo	pg_default	public	c_invoice	c_invoice_bpartner	38	551	99.94
etendo	pg_default	public	c_invoice	c_invoice_updated		548	99.91
etendo	pg_default	public	c_invoice	c_invoice_key	290143	344	99.98
etendo	pg_default	public	ad_session_usage_audit	ad_session_usage_audit_key		338	76.31
etendo	pg_default	public	c_invoice	c_invoice_salesrep		312	99.95
etendo	pg_default	public	fin_payment_scheduledetail	fin_pay_scheduledetail_in	2708	308	96.23
etendo	pg_default	public	fin_payment_schedule	fin_paym_sch_inv_idx	835219	256	99.99
etendo	pg_default	public	fin_payment_detail	fin_payment_detail_key	464	245	82.54
etendo	pg_default	public	fin_payment_scheduledetail	fin_payment_scheduledetail_key	451	244	82.02
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	259820	236	99.96
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	2	231	99.53
etendo	pg_default	public	c_invoice	c_invoice_ad_user		223	99.90

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	912 kB	312 kB	1154		959
etendo	pg_default	profile	sample_statements	pk_sample_statements_n	480 kB	48 kB	731		908
etendo	pg_default	public	c_invoice	c_invoice_bpartner	2584 kB	16 kB	3	289549
etendo	pg_default	profile	sample_stat_user_functions	pk_sample_stat_user_functions	232 kB	16 kB	148		124
etendo	pg_default	public	c_invoice	c_invoice_order	1312 kB	8192 bytes	3	289549
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	752 kB	8192 bytes	24153		24153
etendo	pg_default	profile	sample_statements_total	pk_sample_statements_total	40 kB	8192 bytes	36		45

Unused indexes

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

DB	Tablespaces	Schema	Table	Index	Index		Table
DB	Tablespaces	Schema	Table	Index	Size	Growth	Ins	Upd	Del
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc	3992 kB		3	289549
etendo	pg_default	public	c_invoice	c_invoice_paid	1984 kB	-24 kB	3	289549
etendo	pg_default	public	c_invoice	c_invoice_updated	1584 kB	-24 kB	3	289549
etendo	pg_default	public	c_invoice	c_invoice_ad_user	1576 kB	-8192 bytes	3	289549
etendo	pg_default	public	c_invoice	c_invoice_bp_extref_idx	8192 bytes		3	289549
etendo	pg_default	public	c_invoice	c_invoice_salesrep	1912 kB	-8192 bytes	3	289549
etendo	pg_default	public	ad_process_run	ad_process_run_ould_be_killed	8192 bytes		279	279	650
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_org_isinnaturaltree	4481136	111.39	27.49	0.000	0.000
etendo	public	ad_isorgincluded	6723029	83.98	83.98	0.000	0.000
etendo	profile	take_sample	23	16.98	0.02	0.738	0.001
etendo	profile	take_sample_subset	23	16.96	0.06	0.737	0.003
etendo	profile	take_sample	23	16.90	1.69	0.735	0.073
etendo	public	ad_istriggerenabled	1160581	16.38	16.38	0.000	0.000
etendo	profile	collect_obj_stats	23	9.45	2.89	0.411	0.126
etendo	profile	dblink	621	7.94	7.94	0.013	0.013
etendo	public	to_char	8110635	5.90	5.90	0.000	0.000
etendo	public	ad_column_identifier	7728	3.94	3.90	0.001	0.001
etendo	profile	sample_dbobj_delta	23	3.67	3.67	0.159	0.159
etendo	public	obequals	2552774	2.75	2.75	0.000	0.000
etendo	public	aprm_ispaymentconfirmed	10373	0.82	0.82	0.000	0.000
etendo	profile	collect_pg_stat_statements_stats	21	0.79	0.37	0.038	0.018
etendo	public	c_order_post	9	0.61	0.00	0.068	0.000
etendo	public	c_order_post1	9	0.61	0.00	0.068	0.000
etendo	public	c_order_post1	9	0.61	0.21	0.068	0.023
etendo	public	to_number	225506	0.47	0.47	0.000	0.000
etendo	public	prouti_qtyremainingorderline	5245	0.44	0.44	0.000	0.000
etendo	public	c_invoice_create0	3	0.44	0.00	0.145	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	8110635	5.90	5.90	0.000	0.000
etendo	public	ad_isorgincluded	6723029	83.98	83.98	0.000	0.000
etendo	public	ad_org_isinnaturaltree	4481136	111.39	27.49	0.000	0.000
etendo	public	obequals	2552774	2.75	2.75	0.000	0.000
etendo	public	ad_istriggerenabled	1160581	16.38	16.38	0.000	0.000
etendo	public	to_number	225506	0.47	0.47	0.000	0.000
etendo	public	round	106146	0.09	0.09	0.000	0.000
etendo	public	to_char	32519	0.05	0.05	0.000	0.000
etendo	public	to_char	32518	0.07	0.07	0.000	0.000
etendo	public	substract_days	27604	0.03	0.03	0.000	0.000
etendo	public	to_char	16007	0.05	0.05	0.000	0.000
etendo	public	aprm_ispaymentconfirmed	10373	0.82	0.82	0.000	0.000
etendo	public	ad_column_identifier	7728	3.94	3.90	0.001	0.001
etendo	public	to_date	5731	0.02	0.02	0.000	0.000
etendo	public	lowerequaltimestamp	5577	0.04	0.02	0.000	0.000
etendo	public	prouti_qtyremainingorderline	5245	0.44	0.44	0.000	0.000
etendo	public	add_days	1981	0.00	0.00	0.000	0.000
etendo	public	uuid_generate_v4	1974	0.02	0.02	0.000	0.000
etendo	public	prouti_delavailablewithoutres	1224	0.28	0.28	0.000	0.000
etendo	public	prouti_deliveryavailable	1224	0.26	0.26	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	289576	25.97	18.46	0.000	0.000
etendo	public	c_invoice_trg2	289576	8.04	4.61	0.000	0.000
etendo	public	einv_gene_chk_restrictions_trg	289573	5.89	2.83	0.000	0.000
etendo	public	pruti_inherit_invoice_contact	289576	5.11	2.80	0.000	0.000
etendo	public	c_orderline_trg2	246	0.20	0.08	0.001	0.000
etendo	public	au_c_bpartner_trg	3	0.06	0.06	0.021	0.021
etendo	public	c_invoiceline_trg2	24	0.06	0.03	0.003	0.001
etendo	public	c_orderline_trg	246	0.06	0.05	0.000	0.000
etendo	public	c_orderlinetax_trg	54	0.06	0.04	0.001	0.001
etendo	public	ad_process_request_trg	304	0.06	0.04	0.000	0.000
etendo	public	c_orderline2_trg	246	0.05	0.04	0.000	0.000
etendo	public	cus_delete_ol	7	0.04	0.04	0.005	0.005
etendo	public	c_ordline_chk_restrictions_trg	246	0.04	0.03	0.000	0.000
etendo	public	c_invoicelinetax_trg	12	0.02	0.01	0.002	0.001
etendo	public	ad_preference_mod_trg	44	0.02	0.02	0.000	0.000
etendo	public	c_ordertax_trg	52	0.02	0.02	0.000	0.000
etendo	public	c_order_chk_restrinctions_trg	145	0.02	0.01	0.000	0.000
etendo	public	c_order_trg2	144	0.01	0.01	0.000	0.000
etendo	public	c_invoiceline_before_trg	24	0.01	0.01	0.000	0.000
etendo	public	c_order_trg	140	0.01	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		25	32879	3411	32879	49
etendo	pg_default	profile	last_stat_indexes		25	54119	1262	54119
etendo	pg_default	profile	last_stat_user_functions		25	8257	678	8257	30
etendo	pg_default	public	c_invoice		23	3	289573		24
etendo	pg_default	public	ad_pinstance	2		12	24	82	24
etendo	pg_default	public	ad_process_run	2		305	305	650
etendo	pg_default	public	prsync_entry	2		3	6	800	6
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		323
etendo	pg_default	pg_catalog	pg_type		1	2157		2157
etendo	pg_default	pg_catalog	pg_attribute		1	24153		24153
etendo	pg_default	pg_catalog	pg_class		1	1869	6728	1869	1376
etendo	pg_default	pg_catalog	pg_index		1	527		527
etendo	pg_default	pg_catalog	pg_statistic		1		16188		13216
etendo	pg_default	public	ad_ep_instance_para		1	69		69
etendo	pg_default	public	ad_process_request	1			313	4	305
etendo	pg_default	public	ad_session	1		1	142	97	140
etendo	pg_default	public	m_stock_proposed	1				12

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	32879	3411	32879	49
etendo	pg_default	profile	last_stat_indexes	47	23	54119	1262	54119
etendo	pg_default	profile	last_stat_user_functions	47	23	8257	678	8257	30
etendo	pg_default	public	c_invoice	1	23	3	289573		24
etendo	pg_default	profile	last_stat_tablespaces	22		44		44
etendo	pg_default	public	ad_process_request	2	5		313	4	305
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		709		709
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_shdescription	3
postgres	pg_global	pg_catalog	pg_shseclabel	3
postgres	pg_global	pg_catalog	pg_replication_origin	3
postgres	pg_global	pg_catalog	pg_subscription	3
etendo	pg_global	pg_catalog	pg_pltemplate	3
etendo	pg_global	pg_catalog	pg_tablespace	3
etendo	pg_global	pg_catalog	pg_shdepend	3		709		709

Top indexes by estimated vacuum load

DB	Tablespace	Schema	Table	Index	~Vacuum bytes	Vacuum cnt	Autovacuum cnt	IX size	Relsize
etendo	pg_default	public	c_invoice	c_invoice_client_org_date_doc	90 MB		23	3992 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_key	62 MB		23	2752 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_bpartner	57 MB		23	2544 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_docno	48 MB		23	2144 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_posted	43 MB		23	1931 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_paid	43 MB		23	1922 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_salesrep	42 MB		23	1873 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_updated	35 MB		23	1569 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_ad_user	35 MB		23	1552 kB	23 MB
etendo	pg_default	public	c_invoice	c_invoice_order	29 MB		23	1307 kB	23 MB
etendo	pg_default	profile	last_stat_indexes	pk_last_stat_indexes	9864 kB		25	393 kB	1531 kB
etendo	pg_default	profile	last_stat_tables	pk_last_stat_tables	5552 kB		25	221 kB	1219 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnam_index	1144 kB		1	1144 kB	4304 kB
etendo	pg_default	public	prsync_entry	prsync_entry_key	992 kB	2		496 kB	4256 kB
etendo	pg_default	pg_catalog	pg_attribute	pg_attribute_relid_attnum_index	752 kB		1	752 kB	4304 kB
etendo	pg_default	public	ad_process_run	ad_process_run_key	704 kB	2		352 kB	10 MB
etendo	pg_default	public	ad_process_run	ad_process_run_ad_prequest_id	680 kB	2		340 kB	10 MB
etendo	pg_default	pg_catalog	pg_statistic	pg_statistic_relid_att_inh_index	376 kB		1	376 kB	4792 kB
etendo	pg_default	pg_catalog	pg_statistic(TOAST)	pg_toast_2619_index	368 kB		4	93 kB	4424 kB
etendo	pg_default	public	prsync_entry(TOAST)	pg_toast_137611_index	360 kB	2	1	120 kB	6600 kB

Top tables by dead tuples ratio

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

DB	Schema	Table	Live	Dead	%Dead	Size
etendo	pg_temp_3	ad_context_info	1	176305	99	11 MB
etendo	pg_temp_4	ad_context_info	1	88221	99	5864 kB
etendo	profile	sample_stat_tables	24362	2980	10	7048 kB
etendo	public	ad_process_run	4808	28	0	10 MB
etendo	public	fin_payment_schedule	60629	1	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_3	ad_context_info	1	176305	352611	199		11 MB
etendo	pg_temp_4	ad_context_info	1	88221	176443	199		5864 kB
etendo	profile	sample_stat_tables	24362	2980	940	3	2026-07-18 23:01:03.828263+02	7048 kB
etendo	public	ad_process_run	4808	28	55	1	2026-07-17 19:29:38.788053+02	10 MB
etendo	public	fin_payment_schedule	60629	1	12	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-17 05:00:03.984525+02
pg_conf_load_time	2026-07-18 05:00:04.324135+02			2026-07-18 06:00:01+02
pg_postmaster_start_time	2026-07-17 05:00:04.118924+02
pg_postmaster_start_time	2026-07-18 05:00:04.449179+02			2026-07-18 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