pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jul 17 23:06:19 2026
Log file: /var/log/postgresql/postgresql-16-main.log
Parsed 2,101,547 log entries in 6m18s
Log start from 2026-07-17 07:00:01 to 2026-07-17 22:00:00

Global Stats

1,276 Number of unique normalized queries
989,929 Number of queries
3m13s Total query duration
2026-07-17 07:00:01 First query
2026-07-17 22:00:00 Last query
4,514 queries/s at 2026-07-17 12:30:28 Query peak

3m13s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
3m13s Execute total duration

2 Number of events
2 Number of unique normalized events
1 Max number of times the same event was reported
0 Number of cancellation

90 Total number of automatic vacuums
138 Total number of automatic analyzes

15 Number temporary file
90.81 MiB Max size of temporary file
24.98 MiB Average size of temporary file

5,415 Total number of sessions
0 sessions at Session peak
2m Total duration of sessions
22ms Average duration of sessions
182 Average queries per session
35ms Average queries duration per session
0ms Average idle time per session

5,418 Total number of connections
5 connections/s at 2026-07-17 14:00:01 Connection peak
3 Total number of databases

SQL Traffic

Key values

4,514 queries/s Query Peak
2026-07-17 12:30:28 Date

SELECT Traffic

Key values

1,423 queries/s Query Peak
2026-07-17 12:30:28 Date

INSERT/UPDATE/DELETE Traffic

Key values

77 queries/s Query Peak
2026-07-17 12:00:00 Date

Queries duration

Key values

3m13s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 17	07	9,604	0ms	674ms	0ms	75ms	80ms	899ms
	08	106,837	0ms	1s586ms	0ms	591ms	1s197ms	2s564ms
	09	119,125	0ms	1s471ms	0ms	622ms	1s559ms	1s868ms
	10	85,114	0ms	924ms	0ms	357ms	585ms	2s805ms
	11	281,838	0ms	973ms	0ms	1s181ms	1s569ms	2s426ms
	12	147,709	0ms	867ms	0ms	509ms	1s266ms	2s401ms
	13	153,359	0ms	895ms	0ms	726ms	1s102ms	1s342ms
	14	13,252	0ms	881ms	0ms	71ms	76ms	1s480ms
	15	10,886	0ms	13s546ms	3ms	70ms	79ms	36s54ms
	16	10,180	0ms	698ms	0ms	68ms	76ms	968ms
	17	10,180	0ms	680ms	0ms	68ms	72ms	934ms
	18	10,183	0ms	715ms	0ms	67ms	71ms	983ms
	19	10,177	0ms	652ms	0ms	68ms	76ms	921ms
	20	10,150	0ms	706ms	0ms	67ms	78ms	971ms
	21	10,683	0ms	12s718ms	3ms	71ms	78ms	31s636ms
	22	652	0ms	10ms	0ms	55ms	55ms	55ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 17	07	2,738	0ms	0ms	0ms	0ms
	08	32,126	0ms	0ms	0ms	0ms
	09	35,489	0ms	0ms	0ms	0ms
	10	24,794	0ms	0ms	0ms	0ms
	11	86,581	0ms	0ms	0ms	0ms
	12	44,413	0ms	0ms	0ms	0ms
	13	46,786	0ms	0ms	0ms	0ms
	14	3,435	0ms	0ms	0ms	0ms
	15	3,026	0ms	0ms	0ms	0ms
	16	2,921	0ms	0ms	0ms	0ms
	17	2,921	0ms	0ms	0ms	0ms
	18	2,921	0ms	0ms	0ms	0ms
	19	2,921	0ms	0ms	0ms	0ms
	20	2,921	0ms	0ms	0ms	0ms
	21	2,985	0ms	0ms	0ms	0ms
	22	203	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 17	07	0	0	0	0ms	0ms	0ms	0ms
	08	168	140	8	0ms	0ms	0ms	0ms
	09	216	296	16	0ms	0ms	0ms	0ms
	10	189	344	9	0ms	0ms	0ms	0ms
	11	577	413	7	0ms	0ms	0ms	0ms
	12	300	348	10	0ms	0ms	0ms	0ms
	13	331	287	3	0ms	0ms	0ms	0ms
	14	9	82	4	0ms	0ms	0ms	0ms
	15	5	67	0	0ms	0ms	0ms	0ms
	16	1	1	0	0ms	0ms	0ms	0ms
	17	1	2	0	0ms	0ms	0ms	0ms
	18	1	3	0	0ms	0ms	0ms	0ms
	19	1	2	0	0ms	0ms	0ms	0ms
	20	1	1	0	0ms	0ms	0ms	0ms
	21	2	68	0	0ms	0ms	0ms	0ms
	22	2	1	0	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Jul 17	07	2,805	2,805.00	0.00%
	08	33,843	33,843.00	0.00%
	09	38,106	38,106.00	0.00%
	10	27,372	27,372.00	0.00%
	11	91,562	91,562.00	0.00%
	12	47,738	47,738.00	0.00%
	13	49,902	49,902.00	0.00%
	14	3,945	3,945.00	0.00%
	15	3,173	3,173.00	0.00%
	16	2,992	2,992.00	0.00%
	17	2,993	2,993.00	0.00%
	18	2,994	2,994.00	0.00%
	19	2,993	2,993.00	0.00%
	20	2,992	2,992.00	0.00%
	21	3,122	3,122.00	0.00%
	22	213	213.00	0.00%

Day	Hour	Count	Average / Second
Jul 17	07	361	0.10/s
	08	363	0.10/s
	09	361	0.10/s
	10	361	0.10/s
	11	362	0.10/s
	12	361	0.10/s
	13	361	0.10/s
	14	361	0.10/s
	15	361	0.10/s
	16	361	0.10/s
	17	361	0.10/s
	18	361	0.10/s
	19	361	0.10/s
	20	361	0.10/s
	21	361	0.10/s
	22	0	0.00/s

Day	Hour	Count	Average Duration	Average idle time
Jul 17	07	361	21ms	11ms
	08	361	22ms	0ms
	09	361	23ms	0ms
	10	361	22ms	0ms
	11	361	22ms	0ms
	12	361	23ms	0ms
	13	361	22ms	0ms
	14	361	22ms	11ms
	15	361	22ms	0ms
	16	361	21ms	12ms
	17	361	21ms	11ms
	18	361	21ms	11ms
	19	361	21ms	11ms
	20	361	22ms	12ms
	21	361	22ms	0ms
	22	0	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

5 connections Connection Peak
2026-07-17 14:00:01 Date

Connections per database

Key values

etendo Main Database
5,418 connections Total

Chart
Table

Database	User	Count
etendo		3,243
	postgres	60
	tad	3,183
postgres		15
	postgres	15
template1		2,160
	postgres	2,160

Connections per user

Key values

tad Main User
5,418 connections Total

Chart
Table

User	Count
postgres	2,235
tad	3,183

Connections per host

Key values

127.0.0.1 Main host with 3183 connections
5,418 Total connections

Chart
Table

Host	Count
127.0.0.1	3,183
[local]	2,235

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

5,398 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	5,398	99.69%
500ms-1s	16	0.30%
1s-30s	1	0.02%
30s-1m	0	0.00%
1m-10m	0	0.00%
10m-30m	0	0.00%
30m-1h	0	0.00%
1h-8h	0	0.00%
> 8h	0	0.00%

Sessions per database

Key values

etendo Main Database
5,415 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
etendo	3,240	1m44s	32ms
postgres	15	648ms	43ms
template1	2,160	15s147ms	7ms

Sessions per user

Key values

tad Main User
5,415 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	2,235	36s429ms	16ms
tad	3,180	1m24s	26ms

Sessions per host

Key values

127.0.0.1 Main Host
5,415 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	3,180	1m24s	26ms
[local]	2,235	36s429ms	16ms

Sessions per application

Key values

psql Main Application
5,415 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	2,160	15s147ms	7ms
pg_profile	45	9s268ms	205ms
psql	3,210	1m36s	29ms

Checkpoints Buffers

Key values

1,640 buffers Checkpoint Peak
2026-07-17 12:04:39 Date
163.975 seconds Highest write time
0.006 seconds Sync time

Checkpoints Wal files

Key values

0 files Wal files usage Peak
2026-07-17 12:21:57 Date

Checkpoints distance

Key values

24.47 Mo Distance Peak
2026-07-17 12:04:39 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 17	07	971	96.929s	0.002s	96.945s
	08	1,776	175.264s	0.026s	175.364s
	09	2,730	271.469s	0.027s	271.569s
	10	2,059	204.126s	0.028s	204.203s
	11	3,342	331.291s	0.036s	331.372s
	12	2,702	267.802s	0.028s	267.883s
	13	2,373	235.22s	0.036s	235.304s
	14	1,434	142.398s	0.025s	142.471s
	15	1,242	123.969s	0.005s	123.982s
	16	1,306	130.482s	0.003s	130.489s
	17	1,000	99.694s	0.002s	99.699s
	18	1,202	120.143s	0.003s	120.152s
	19	945	94.277s	0.002s	94.283s
	20	1,310	130.683s	0.002s	130.689s
	21	1,293	129.261s	0.003s	129.268s
	22	0	0s	0s	0s

Day	Hour	Removed	Synced files	Longest sync	Average sync
Jul 17	07	1	123	0.002s	0.001s
	08	1	456	0.002s	0.012s
	09	1	637	0.002s	0.012s
	10	1	461	0.003s	0.012s
	11	1	1,071	0.002s	0.012s
	12	2	700	0.002s	0.012s
	13	1	635	0.003s	0.012s
	14	0	211	0.002s	0.012s
	15	1	160	0.002s	0.002s
	16	1	131	0.001s	0.001s
	17	0	129	0.002s	0.001s
	18	1	125	0.002s	0.001s
	19	0	122	0.002s	0.001s
	20	1	124	0.001s	0.001s
	21	0	126	0.001s	0.001s
	22	0	0	0s	0s

Day	Hour	Avg time (sec)
Jul 17	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s

Day	Hour	Mean distance	Mean estimate
Jul 17	07	9,274.00 kB	1,050,541.00 kB
	08	1,092.50 kB	566,041.50 kB
	09	1,673.42 kB	161,022.25 kB
	10	1,289.67 kB	46,481.75 kB
	11	1,978.42 kB	14,369.33 kB
	12	1,610.33 kB	7,775.92 kB
	13	1,490.75 kB	7,178.00 kB
	14	964.33 kB	6,839.92 kB
	15	5,113.50 kB	9,542.00 kB
	16	9,798.00 kB	9,798.00 kB
	17	9,522.00 kB	9,771.00 kB
	18	9,544.00 kB	9,748.00 kB
	19	9,059.00 kB	9,679.00 kB
	20	9,571.00 kB	9,668.00 kB
	21	9,866.00 kB	9,866.00 kB
	22	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (93) Main checkpoint cause
93 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	93
Total	93

Size of temporary files

Key values

90.81 MiB Temp Files size Peak
2026-07-17 15:30:06 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2026-07-17 21:00:30 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 17	07	0	0	0
	08	0	0	0
	09	1	13.50 MiB	13.50 MiB
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	7	180.59 MiB	25.80 MiB
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	7	180.59 MiB	25.80 MiB
	22	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	4	355.77 MiB	87.07 MiB	90.81 MiB	88.94 MiB	? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, c_invoice.ad_org_id as ad_org_id, c_invoice.ad_client_id as ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, c_invoice_id, ?) as record_id from c_invoice, c_doctype, fact_acct f1, fact_acct f2 where c_invoice.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype in (...) and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id group by c_invoice_id, posted, c_invoice.ad_client_id, c_invoice.ad_org_id, f1.ad_table_id, f1.record_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id); '0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-17 15:30:06 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
2	4	3.97 MiB	736.00 KiB	1.27 MiB	1016.00 KiB	? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id); '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-17 15:30:07 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
3	2	1.44 MiB	736.00 KiB	736.00 KiB	736.00 KiB	update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select record_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, record_id, ?) as record_id from fact_acct where ad_table_id = ? and docbasetype in (...) group by fact_acct_group_id, record_id, ad_client_id, ad_org_id having sum(amtacctcr - amtacctdr) <> ?) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id); UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); Date: 2026-07-17 15:30:33 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo
4	1	13.50 MiB	13.50 MiB	13.50 MiB	13.50 MiB	select sum(order0_.totallines) as col_0_0_, sum( cost) as col_1_0_, sum(margen) as col_2_0_, sum(pmargen) / count() as col_3_0_ from c_order order0_ left outer join c_invoice invoicelis1_ on order0_.c_order_id = invoicelis1_.c_order_id cross join c_orderline orderline2_ where orderline2_.c_order_id = order0_.c_order_id and order0_.issotrx = ? and order0_.docstatus = ? and ? = ? limit ?; select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count() as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1; Date: 2026-07-17 09:30:20 Duration: 0ms Database: etendo User: tad Remote: 127.0.0.1 Application: openbravo

Queries generating the largest temporary files


[ Date: 2026-07-17 15:30:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 21:00:02 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:30:35 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 21:00:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 09:30:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:30:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 21:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:30:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 15:30:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 21:00:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
[ Date: 2026-07-17 21:00:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Rank	Size	Query
1	90.81 MiB	'0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 15:30:06 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
2	90.81 MiB	'0' as ad_role_id, null as ad_user_id, 'SALES INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('ARI', 'ARC', 'ARF') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 21:00:02 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
3	87.07 MiB	'0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 15:30:35 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
4	87.07 MiB	'0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 21:00:30 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
5	13.50 MiB	select sum(order0_.TotalLines) as col_0_0_, sum( Cost) as col_1_0_, sum(Margen) as col_2_0_, sum(PMargen) / count() as col_3_0_ from C_Order order0_ left outer join C_Invoice invoicelis1_ on order0_.C_Order_ID = invoicelis1_.C_Order_ID cross join C_OrderLine orderline2_ where orderline2_.C_Order_ID = order0_.C_Order_ID and order0_.IsSOTrx = 'Y' and order0_.DocStatus = 'CO' and 1 = 1 limit $1; [ Date:* 2026-07-17 09:30:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
6	1.27 MiB	'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 15:30:07 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
7	1.27 MiB	'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED SALES INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('ARI', 'ARC', 'ARF') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 21:00:03 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
8	736.00 KiB	'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 15:30:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
9	736.00 KiB	UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 15:30:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
10	736.00 KiB	'0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 21:00:15 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]
11	736.00 KiB	UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select record_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'NOT BALANCED PURCHASE INVOICE' as description, 'Y' as isActive, ad_org_id, ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_Invoice', record_id, 'es_ES') AS RECORD_ID FROM fact_acct WHERE ad_table_id = '318' and docbasetype in ('API', 'APC') GROUP BY fact_acct_group_id, record_id, ad_client_id, ad_org_id HAVING SUM(amtacctcr - amtacctdr) <> 0) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID); [ Date: 2026-07-17 21:00:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

Vacuums / Analyzes Distribution

Key values

0.03 sec Highest CPU-cost vacuum
Table pg_toast.pg_toast_2619
Database etendo
2026-07-17 16:00:28 Date
0 sec Highest CPU-cost analyze
Table
Database etendo
Date

Average Autovacuum Duration

Key values

0.03 sec Highest CPU-cost vacuum
Table pg_toast.pg_toast_2619
Database etendo
2026-07-17 16:00:28 Date

Analyzes per table

Key values

profile.last_stat_tables_srv1 (15) Main table analyzed (database etendo)
138 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.profile.last_stat_tables_srv1	15
etendo.profile.last_stat_user_functions_srv1	15
etendo.profile.last_stat_statements_srv1	15
etendo.profile.last_stat_indexes_srv1	15
etendo.public.ad_session	13
etendo.profile.tables_list	10
etendo.public.ad_ep_instance_para	8
etendo.profile.last_stat_io	8
etendo.profile.stmt_list	5
etendo.profile.last_extension_versions	4
etendo.profile.funcs_list	4
etendo.profile.indexes_list	4
etendo.profile.last_stat_activity_count_srv1	4
etendo.profile.last_stat_slru	3
etendo.profile.sample_stat_tables	2
etendo.profile.sample_statements	2
etendo.profile.sample_stat_user_functions	2
etendo.profile.sample_stat_indexes	2
etendo.profile.sample_stat_slru	1
etendo.profile.sample_stat_tables_total	1
etendo.profile.sample_stat_database	1
etendo.profile.sample_statements_total	1
etendo.profile.sample_stat_io	1
etendo.profile.sample_stat_indexes_total	1
etendo.public.ad_preference	1
Total	138

Vacuums per table

Key values

profile.last_stat_user_functions_srv1 (15) Main table vacuumed on database etendo
90 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage			Frozen
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes	pages	tuples
etendo.profile.last_stat_user_functions_srv1	15	15	2,140	0	42	0	0	1,126	34	239,131	0	0
etendo.profile.last_stat_indexes_srv1	15	15	15,562	0	274	0	0	11,279	286	1,793,302	0	0
etendo.profile.last_stat_tables_srv1	15	15	12,074	0	169	0	0	8,915	172	1,248,290	0	0
etendo.profile.last_stat_statements_srv1	15	15	6,628	0	100	0	0	4,208	106	695,953	0	0
etendo.profile.tables_list	7	7	1,025	0	21	0	0	562	16	171,048	0	0
etendo.public.ad_ep_instance_para	4	4	236	0	20	0	0	28	10	67,442	0	0
etendo.profile.stmt_list	4	4	1,118	0	74	0	0	720	60	402,539	17	42
etendo.profile.last_stat_io	3	3	242	0	17	0	0	26	8	51,344	0	0
etendo.profile.funcs_list	3	3	268	0	11	0	0	80	5	45,412	0	0
etendo.profile.last_extension_versions	2	2	120	0	10	0	0	10	4	33,532	0	0
etendo.profile.last_stat_activity_count_srv1	2	0	42	0	10	0	0	12	4	19,888	0	0
etendo.profile.indexes_list	2	2	257	0	9	0	0	73	5	46,619	0	0
etendo.pg_toast.pg_toast_2619	1	1	739	0	112	0	0	348	103	254,563	26	67
etendo.profile.last_stat_database_srv1	1	1	48	0	5	0	0	6	2	11,734	0	0
etendo.profile.last_stat_slru	1	1	68	0	5	0	0	5	2	16,784	0	0
Total	90	88	40,567	0	879	0	0	27,398	817	5,097,581	43	109

Vacuum throughput per table

Key values

profile.last_stat_indexes_srv1 (0.18) Max CPU elapsed for vacuum on database etendo
unknown (0 ms) Max I/O read time for vacuum on database etendo
unknown (0 ms) Max I/O write time for vacuum on database etendo

Chart
Table

	I/O timing (ms)		CPU (s)
Table	read	write	elapsed
etendo.profile.last_stat_user_functions_srv1	0	0	0
etendo.profile.last_stat_indexes_srv1	0	0	0.18
etendo.profile.last_stat_tables_srv1	0	0	0.15
etendo.profile.last_stat_statements_srv1	0	0	0.05
etendo.profile.tables_list	0	0	0
etendo.public.ad_ep_instance_para	0	0	0
etendo.profile.stmt_list	0	0	0.01
etendo.profile.last_stat_io	0	0	0.01
etendo.profile.funcs_list	0	0	0
etendo.profile.last_extension_versions	0	0	0
etendo.profile.last_stat_activity_count_srv1	0	0	0
etendo.profile.indexes_list	0	0	0
etendo.pg_toast.pg_toast_2619	0	0	0.03
etendo.profile.last_stat_database_srv1	0	0	0
etendo.profile.last_stat_slru	0	0	0
Total	0	0	0.43

Tuples removed per table

Key values

profile.last_stat_indexes_srv1 (70686) Main table with removed tuples on database etendo
136125 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
etendo.profile.last_stat_indexes_srv1	15	15	70,686	34,935	0	284	4,017
etendo.profile.last_stat_tables_srv1	15	15	44,689	20,880	0	219	3,213
etendo.profile.last_stat_statements_srv1	15	15	13,037	11,026	0	220	1,155
etendo.profile.last_stat_user_functions_srv1	15	15	5,306	4,605	0	6	330
etendo.profile.tables_list	7	7	1,111	5,612	0	0	168
etendo.profile.stmt_list	4	4	324	2,812	0	0	286
etendo.pg_toast.pg_toast_2619	1	1	259	1,405	0	0	454
etendo.profile.last_stat_io	3	3	143	39	0	1	5
etendo.profile.funcs_list	3	3	142	515	0	0	24
etendo.profile.indexes_list	2	2	127	660	0	0	20
etendo.profile.last_extension_versions	2	2	112	16	0	0	2
etendo.public.ad_ep_instance_para	4	4	82	0	0	4	0
etendo.profile.last_stat_slru	1	1	55	5	0	0	1
etendo.profile.last_stat_activity_count_srv1	2	0	48	0	0	2	0
etendo.profile.last_stat_database_srv1	1	1	4	4	0	0	1
Total	90	88	136,125	82,514	0	736	9,676

Pages removed per table

Key values

profile.last_stat_indexes_srv1 (284) Main table with removed pages on database etendo
736 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.profile.last_stat_indexes_srv1	15	15	70686	284
etendo.profile.last_stat_statements_srv1	15	15	13037	220
etendo.profile.last_stat_tables_srv1	15	15	44689	219
etendo.profile.last_stat_user_functions_srv1	15	15	5306	6
etendo.public.ad_ep_instance_para	4	4	82	4
etendo.profile.last_stat_activity_count_srv1	2	0	48	2
etendo.profile.last_stat_io	3	3	143	1
etendo.profile.funcs_list	3	3	142	0
etendo.profile.last_extension_versions	2	2	112	0
etendo.pg_toast.pg_toast_2619	1	1	259	0
etendo.profile.tables_list	7	7	1111	0
etendo.profile.last_stat_database_srv1	1	1	4	0
etendo.profile.stmt_list	4	4	324	0
etendo.profile.indexes_list	2	2	127	0
etendo.profile.last_stat_slru	1	1	55	0
Total	90	88	136,125	736

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 17	07	6	9
	08	5	5
	09	6	11
	10	7	10
	11	8	17
	12	5	11
	13	8	11
	14	5	7
	15	7	11
	16	7	6
	17	7	7
	18	5	7
	19	4	9
	20	5	7
	21	5	10
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

297,181 Total read queries
24,253 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	297,181	30.02%
INSERT	1,804	0.18%
UPDATE	2,055	0.21%
DELETE	57	0.01%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	20,337	2.05%
CURSOR	0	0.00%
OTHERS	668,495	67.53%

Queries by database

Key values

etendo Main database
981,349 Requests
3m9s (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	981,349	3m9s
	delete	57	0ms
	insert	1,804	0ms
	others	576	0ms
	select	295,666	0ms
	tcl	20,307	0ms
	update	2,055	0ms
postgres	Total	300	422ms
	others	45	0ms
	select	75	0ms
	tcl	30	0ms
template1	Total	8,280	3s882ms
	others	2,700	0ms
	select	1,440	0ms

Queries by user

Key values

tad Main user
980,269 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	9,660	18s796ms
	others	2,835	0ms
	select	1,905	0ms
	tcl	90	0ms
tad	Total	980,269	2m54s
	delete	57	0ms
	insert	1,804	0ms
	others	486	0ms
	select	295,276	0ms
	tcl	20,247	0ms
	update	2,055	0ms

Duration by user

Key values

2m54s (tad) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	9,660	18s796ms
	others	2,835	0ms
	select	1,905	0ms
	tcl	90	0ms
tad	Total	980,269	2m54s
	delete	57	0ms
	insert	1,804	0ms
	others	486	0ms
	select	295,276	0ms
	tcl	20,247	0ms
	update	2,055	0ms

Queries by host

Key values

127.0.0.1 Main host
980,269 Requests
2m54s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	980,269	2m54s
	delete	57	0ms
	insert	1,804	0ms
	others	486	0ms
	select	295,276	0ms
	tcl	20,247	0ms
	update	2,055	0ms
[local]	Total	9,660	18s796ms
	others	2,835	0ms
	select	1,905	0ms
	tcl	90	0ms

Queries by application

Key values

openbravo Main application
973,888 Requests
2m39s (openbravo)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
[unknown]	Total	8,436	3s895ms
	others	2,751	0ms
	select	1,440	0ms
	tcl	45	0ms
openbravo	Total	973,888	2m39s
	delete	57	0ms
	insert	1,804	0ms
	select	292,576	0ms
	tcl	20,247	0ms
	update	2,055	0ms
pg_profile	Total	1,185	3s52ms
	others	90	0ms
	select	435	0ms
	tcl	45	0ms
psql	Total	6,420	27s423ms
	others	480	0ms
	select	2,730	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-17 16:23:17 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

652,572 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	652,572	98.11%
1-5ms	8,519	1.28%
5-10ms	2,882	0.43%
10-25ms	834	0.13%
25-50ms	205	0.03%
50-100ms	88	0.01%
100-500ms	41	0.01%
500-1000ms	21	0.00%
1000-10000ms	8	0.00%
> 10000ms	4	0.00%

Slowest individual queries

Rank	Duration	Query
NO DATASET

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

0ms

10

Details

0ms

select td0.c_bpartner_id as id, (coalesce(to_char(coalesce(to_char(td0.name), ?)), ?)) as name, ? as description from c_bpartner td0 where td0.ad_client_id in (...) and td0.ad_org_id in (...) and td0.c_bpartner_id in ( select bp.c_bpartner_id from c_bpartner bp, c_bp_group g where g.c_bp_group_id = bp.c_bp_group_id and g.value = ?) and (td0.isactive = ? or td0.c_bpartner_id = (null)) and td0.c_bpartner_id = (?) order by ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms
	10	1	0ms	0ms
	11	4	0ms	0ms
	12	2	0ms	0ms
	13	2	0ms	0ms

2

0ms

750

Details

0ms

select pricingpri0_.m_pricelist_id as m_pricel1_432_0_, pricingpri0_.ad_client_id as ad_clien2_432_0_, pricingpri0_.ad_org_id as ad_org_i3_432_0_, pricingpri0_.isactive as isactive4_432_0_, pricingpri0_.created as created5_432_0_, pricingpri0_.createdby as createdb6_432_0_, pricingpri0_.updated as updated7_432_0_, pricingpri0_.updatedby as updatedb8_432_0_, pricingpri0_.name as name9_432_0_, pricingpri0_.description as descrip10_432_0_, pricingpri0_.basepricelist_id as basepri11_432_0_, pricingpri0_.istaxincluded as istaxin12_432_0_, pricingpri0_.issopricelist as issopri13_432_0_, pricingpri0_.isdefault as isdefau14_432_0_, pricingpri0_.c_currency_id as c_curre15_432_0_, pricingpri0_.enforcepricelimit as enforce16_432_0_, pricingpri0_.costbased as costbas17_432_0_ from m_pricelist pricingpri0_ where pricingpri0_.m_pricelist_id = ?;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 17	08	113	0ms	0ms
	09	131	0ms	0ms
	10	55	0ms	0ms
	11	213	0ms	0ms
	12	138	0ms	0ms
	13	100	0ms	0ms

3

0ms

1

Details

0ms

insert into c_invoiceline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, line, description, financial_invoice_line, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, chargeamt, c_uom_id, c_tax_id, isdescription, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, grosspricestd, grosspricelist, isdeferred, explode, match_lccosts, cancelpricead, c_invoiceline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? n ? ? f9f95d307464074a2dc899b2d3c3ac4 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? a0e9eb5c5ebb462b9155106a3d441525 ? n ? ? ? n ? n ? ? ? ? ? ? ? f501892a499d4bbbb0b02aea1eb29d93 ? ? ? ? ? n ? n ? n ? n ? ? e2a31da2ad54c96a0226a24a0313c0e ');

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 17	11	1	0ms	0ms

4

0ms

1

Details

0ms

update fin_payment set updated = ?, processed = ?, description = ? re ? ? efa04906d5a40aaa57020858d2ef44b ';

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jul 17	09	1	0ms	0ms

5

0ms

8

Details

0ms

insert into fact_acct (fact_acct_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_acctschema_id, account_id, acctvalue, acctdescription, datetrx, dateacct, c_period_id, ad_table_id, record_id, line_id, gl_category_id, c_tax_id, postingtype, c_currency_id, amtsourcedr, amtsourcecr, amtacctdr, amtacctcr, c_uom_id, qty, m_locator_id, m_product_id, c_bpartner_id, ad_orgtrx_id, c_locfrom_id, c_locto_id, c_salesregion_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, description, fact_acct_group_id, seqno, docbasetype, record_id2, a_asset_id, c_withholding_id, c_doctype_id, c_costcenter_id, factaccttype) values (?, ?, ?, ?, now(), ?, now(), ?, ?, ?, ?, ?, to_date(?), to_date(?), ?, ?, ?, null, ?, ?, ?, ?, to_number(?), to_number(?), to_number(?), to_number(?), null, to_number(null), null, null, ?, null, ?, ?, null, null, null, null, null, null, ?, ?, to_number(?), ?, null, null, null, ?, null, ?);

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jul 17	10	1	0ms	0ms
	11	4	0ms	0ms
	13	1	0ms	0ms
	14	2	0ms	0ms

6

0ms

26

Details

0ms

select users.default_ad_org_id from ad_user users inner join ad_org org on users.default_ad_org_id = org.ad_org_id where users.ad_user_id = ? and not users.default_ad_org_id is null and org.isactive = ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jul 17	08	6	0ms	0ms
	09	8	0ms	0ms
	10	3	0ms	0ms
	11	3	0ms	0ms
	12	6	0ms	0ms

7

0ms

1

Details

0ms

update c_bpartner set updated = ?, updatedby = ?, taxid = ? where c_bpartner_id = ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms

8

0ms

33

Details

0ms

select obuiapppar0_.obuiapp_parameter_id as obuiapp_9_617_1_, obuiapppar0_.obuiapp_parameter_trl_id as obuiapp_1_617_1_, obuiapppar0_.obuiapp_parameter_trl_id as obuiapp_1_617_0_, obuiapppar0_.ad_client_id as ad_clien2_617_0_, obuiapppar0_.ad_org_id as ad_org_i3_617_0_, obuiapppar0_.isactive as isactive4_617_0_, obuiapppar0_.created as created5_617_0_, obuiapppar0_.createdby as createdb6_617_0_, obuiapppar0_.updated as updated7_617_0_, obuiapppar0_.updatedby as updatedb8_617_0_, obuiapppar0_.obuiapp_parameter_id as obuiapp_9_617_0_, obuiapppar0_.name as name10_617_0_, obuiapppar0_.description as descrip11_617_0_, obuiapppar0_.help as help12_617_0_, obuiapppar0_.istranslated as istrans13_617_0_, obuiapppar0_.ad_language as ad_lang14_617_0_ from obuiapp_parameter_trl obuiapppar0_ where obuiapppar0_.obuiapp_parameter_id in (...);

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jul 17	08	14	0ms	0ms
	09	16	0ms	0ms
	12	3	0ms	0ms

9

0ms

2

Details

0ms

update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select gl_journal_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, gl_journal_id, ?) as record_id, posted from gl_journal where gl_journal.posted in (...) or gl_journal.posted in (...) or gl_journal.posted in (...) group by gl_journal_id, posted, ad_client_id, ad_org_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jul 17	15	1	0ms	0ms
	21	1	0ms	0ms

10

0ms

20

Details

0ms

select max(ad_user_id) as id from ad_user, c_bpartner where ad_user.c_bpartner_id = c_bpartner.c_bpartner_id and c_bpartner.issalesrep = ? and ad_user.isactive = ? and ad_user.c_bpartner_id = ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jul 17	08	2	0ms	0ms
	09	2	0ms	0ms
	10	2	0ms	0ms
	11	7	0ms	0ms
	12	5	0ms	0ms
	13	2	0ms	0ms

11

0ms

22

Details

0ms

select ad_val_rule_id from ad_val_rule where upper(name) = upper(?);

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jul 17	08	3	0ms	0ms
	09	2	0ms	0ms
	10	2	0ms	0ms
	11	7	0ms	0ms
	12	6	0ms	0ms
	13	2	0ms	0ms

12

0ms

1

Details

0ms

select c_invoice.c_invoice_id as document_id, c_invoice.docstatus as docstatus, c_invoice.documentno as ourreference, c_invoice.poreference as yourreference, c_invoice.salesrep_id as salesrep_user_id, salesrep.email as salesrep_email, salesrep.name as salesrep_name, c_invoice.c_bpartner_id as bpartner_id, c_bpartner.name as bpartner_name, c_invoice.ad_user_id as contact_user_id, customercontact.email as contact_email, customercontact.name as contact_name from c_invoice left join ad_user customercontact on c_invoice.ad_user_id = customercontact.ad_user_id left join ad_user salesrep on c_invoice.salesrep_id = salesrep.ad_user_id left join c_bpartner on c_invoice.c_bpartner_id = c_bpartner.c_bpartner_id where ? = ? and c_invoice.c_invoice_id in (...);

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jul 17	12	1	0ms	0ms

13

0ms

45

Details

0ms

set search_path = ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jul 17	07	3	0ms	0ms
	08	3	0ms	0ms
	09	3	0ms	0ms
	10	3	0ms	0ms
	11	3	0ms	0ms
	12	3	0ms	0ms
	13	3	0ms	0ms
	14	3	0ms	0ms
	15	3	0ms	0ms
	16	3	0ms	0ms
	17	3	0ms	0ms
	18	3	0ms	0ms
	19	3	0ms	0ms
	20	3	0ms	0ms
	21	3	0ms	0ms

14

0ms

2,414

Details

0ms

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, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = ? and text.isused = ? and texttrl.ad_language = ? 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, ? 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 = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, ? as trllang, text.text as trltext, ? as istranslated, ? 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 = ?) and (text.filename is null or text.filename = ?) and text.isused = ? order by orderseq;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	151	0ms	0ms
	09	162	0ms	0ms
	10	166	0ms	0ms
	11	394	0ms	0ms
	12	210	0ms	0ms
	13	248	0ms	0ms
	14	121	0ms	0ms
	15	122	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

15

0ms

1

Details

0ms

insert into c_orderline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, chargeamt, c_tax_id, isdescription, pricestd, cancelpricead, iseditlinenetamt, taxbaseamt, gross_unit_price, line_gross_amount, grosspricestd, manage_reservation, manage_prereservation, explode, em_opxmp_purchase_bpartner_id, em_opxmp_costprice, print_description, em_opxmp_m_pl_version_id, em_opxmp_margen, relate_orderline, c_orderline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ? f9f95d307464074a2dc899b2d3c3ac4 ? cd0854c3d1394b6299bd7ebed08e0968 ? n ? ? ? ? ? ? ? ? ? ? ? ? ? ?.? ? ?.? ? ? ? ?.? ? ? ? ? ? ? ? a0e9eb5c5ebb462b9155106a3d441525 ? n ? ?.? ? n ? n ? ?.? ? ? ? ? ? ? ? n ? n ? n ? ? fdc0464ff4ea2afdd93b3df60ff9a ? ? ? n ? b7431208a39040e7b4b5d0198d0606e8 ? ? ? n ? ? e28840b94c81b5de5737e2dbaf55 ');

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jul 17	10	1	0ms	0ms

16

0ms

60

Details

0ms

select this_.fin_finacc_paymentmethod_id as fin_fina1_329_0_, this_.ad_client_id as ad_clien2_329_0_, this_.ad_org_id as ad_org_i3_329_0_, this_.created as created4_329_0_, this_.createdby as createdb5_329_0_, this_.updated as updated6_329_0_, this_.updatedby as updatedb7_329_0_, this_.isactive as isactive8_329_0_, this_.fin_paymentmethod_id as fin_paym9_329_0_, this_.fin_financial_account_id as fin_fin10_329_0_, this_.automatic_receipt as automat11_329_0_, this_.automatic_payment as automat12_329_0_, this_.automatic_deposit as automat13_329_0_, this_.automatic_withdrawn as automat14_329_0_, this_.payin_allow as payin_a15_329_0_, this_.payout_allow as payout_16_329_0_, this_.payin_execution_type as payin_e17_329_0_, this_.payout_execution_type as payout_18_329_0_, this_.payin_execution_process_id as payin_e19_329_0_, this_.payout_execution_process_id as payout_20_329_0_, this_.payin_deferred as payin_d21_329_0_, this_.payout_deferred as payout_22_329_0_, this_.uponreceiptuse as uponrec23_329_0_, this_.upondeposituse as upondep24_329_0_, this_.inuponclearinguse as inuponc25_329_0_, this_.uponpaymentuse as uponpay26_329_0_, this_.uponwithdrawaluse as uponwit27_329_0_, this_.outuponclearinguse as outupon28_329_0_, this_.payin_ismulticurrency as payin_i29_329_0_, this_.payout_ismulticurrency as payout_30_329_0_, this_.isdefault as isdefau31_329_0_, this_.payin_invoicepaidstatus as payin_i32_329_0_, this_.payout_invoicepaidstatus as payout_33_329_0_ from fin_finacc_paymentmethod this_ where this_.fin_financial_account_id = ? and this_.fin_paymentmethod_id = ? and this_.isactive = ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jul 17	09	8	0ms	0ms
	10	16	0ms	0ms
	11	10	0ms	0ms
	12	20	0ms	0ms
	13	2	0ms	0ms
	14	4	0ms	0ms

17

0ms

4

Details

0ms

insert into c_order (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, posted, ad_user_id, copyfrom, isselfservice, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, rm_addorphanline, calculate_promotions, convertquotation, create_polines, iscashvat, em_opxmp_buttonpo, rm_pickfromreceipt, cancelandreplace, em_aprm_addpayment, em_opxmp_envdirecto, em_opxmp_disenador_id, em_opxmp_estado, em_opxmp_buttonpv, em_opxmp_buttonmail, em_mp_infpvint, confirmcancelandreplace, iscancelled, c_order_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms
	11	1	0ms	0ms
	12	1	0ms	0ms
	13	1	0ms	0ms

18

0ms

2

Details

0ms

select aduser0_.ad_user_id as ad_user_1_129_1_, aduser0_.ad_client_id as ad_clien2_129_1_, aduser0_.ad_org_id as ad_org_i3_129_1_, aduser0_.isactive as isactive4_129_1_, aduser0_.created as created5_129_1_, aduser0_.createdby as createdb6_129_1_, aduser0_.updated as updated7_129_1_, aduser0_.updatedby as updatedb8_129_1_, aduser0_.name as name9_129_1_, aduser0_.description as descrip10_129_1_, aduser0_.password as passwor11_129_1_, aduser0_.email as email12_129_1_, aduser0_.supervisor_id as supervi13_129_1_, aduser0_.c_bpartner_id as c_bpart14_129_1_, aduser0_.processing as process15_129_1_, aduser0_.emailuser as emailus16_129_1_, aduser0_.emailuserpw as emailus17_129_1_, aduser0_.c_bpartner_location_id as c_bpart18_129_1_, aduser0_.c_greeting_id as c_greet19_129_1_, aduser0_.title as title20_129_1_, aduser0_.comments as comment21_129_1_, aduser0_.phone as phone22_129_1_, aduser0_.phone2 as phone23_129_1_, aduser0_.fax as fax24_129_1_, aduser0_.lastcontact as lastcon25_129_1_, aduser0_.lastresult as lastres26_129_1_, aduser0_.birthday as birthda27_129_1_, aduser0_.ad_orgtrx_id as ad_orgt28_129_1_, aduser0_.firstname as firstna29_129_1_, aduser0_.lastname as lastnam30_129_1_, aduser0_.username as usernam31_129_1_, aduser0_.default_ad_client_id as default32_129_1_, aduser0_.default_ad_language as default33_129_1_, aduser0_.default_ad_org_id as default34_129_1_, aduser0_.default_ad_role_id as default35_129_1_, aduser0_.default_m_warehouse_id as default36_129_1_, aduser0_.islocked as islocke37_129_1_, aduser0_.ad_image_id as ad_imag38_129_1_, aduser0_.grant_portal_access as grant_p39_129_1_, aduser0_.lastpasswordupdate as lastpas40_129_1_, aduser0_.isexpiredpassword as isexpir41_129_1_, aduser0_.commercialauth as commerc42_129_1_, aduser0_.viasms as viasms43_129_1_, aduser0_.viaemail as viaemai44_129_1_, aduser0_.em_smfsws_default_ws_role_id as em_smfs45_129_1_, aduserrole1_.ad_user_id as ad_user_2_130_3_, aduserrole1_.ad_user_roles_id as ad_user_1_130_3_, aduserrole1_.ad_user_roles_id as ad_user_1_130_0_, aduserrole1_.ad_user_id as ad_user_2_130_0_, aduserrole1_.ad_role_id as ad_role_3_130_0_, aduserrole1_.ad_client_id as ad_clien4_130_0_, aduserrole1_.ad_org_id as ad_org_i5_130_0_, aduserrole1_.isactive as isactive6_130_0_, aduserrole1_.created as created7_130_0_, aduserrole1_.createdby as createdb8_130_0_, aduserrole1_.updated as updated9_130_0_, aduserrole1_.updatedby as updated10_130_0_, aduserrole1_.is_role_admin as is_role11_130_0_ from ad_user aduser0_ left outer join ad_user_roles aduserrole1_ on aduser0_.ad_user_id = aduserrole1_.ad_user_id where aduser0_.ad_user_id = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jul 17	09	2	0ms	0ms

19

0ms

180

Details

0ms

select usename, count(*) from pg_stat_activity where pid != pg_backend_pid() and usename is not null group by usename order by ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jul 17	07	12	0ms	0ms
	08	12	0ms	0ms
	09	12	0ms	0ms
	10	12	0ms	0ms
	11	12	0ms	0ms
	12	12	0ms	0ms
	13	12	0ms	0ms
	14	12	0ms	0ms
	15	12	0ms	0ms
	16	12	0ms	0ms
	17	12	0ms	0ms
	18	12	0ms	0ms
	19	12	0ms	0ms
	20	12	0ms	0ms
	21	12	0ms	0ms

20

0ms

3

Details

0ms

select td0.fin_financial_account_id as id, (coalesce(to_char(coalesce(to_char(td0.name), ?)), ?)) as name, ? as description from fin_financial_account td0 where td0.ad_client_id in (...) and td0.ad_org_id in (...) and (fin_financial_account_id in ( select fin_financial_account_id from fin_finacc_paymentmethod where fin_paymentmethod_id = ?)) and (td0.isactive = ? or td0.fin_financial_account_id = (?)) and td0.fin_financial_account_id = (?) order by ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms
	12	2	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

145,371

Details

0ms

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 = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 17	08	14,862	0ms	0ms
	09	17,179	0ms	0ms
	10	12,291	0ms	0ms
	11	50,954	0ms	0ms
	12	22,971	0ms	0ms
	13	27,114	0ms	0ms

2

22,259

Details

0ms

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 = ? where m.value = ?;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 17	07	1,440	0ms	0ms
	08	1,489	0ms	0ms
	09	1,513	0ms	0ms
	10	1,495	0ms	0ms
	11	1,634	0ms	0ms
	12	1,530	0ms	0ms
	13	1,520	0ms	0ms
	14	1,462	0ms	0ms
	15	1,473	0ms	0ms
	16	1,449	0ms	0ms
	17	1,449	0ms	0ms
	18	1,449	0ms	0ms
	19	1,449	0ms	0ms
	20	1,449	0ms	0ms
	21	1,449	0ms	0ms
	22	9	0ms	0ms

3

10,466

Details

0ms

select distinct addimensio0_.documentlevel as col_0_0_ from ad_dimension_mapping addimensio0_ where addimensio0_.ad_table_id = ? and addimensio0_.dimension = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1,118	0ms	0ms
	09	1,370	0ms	0ms
	10	808	0ms	0ms
	11	3,740	0ms	0ms
	12	1,526	0ms	0ms
	13	1,904	0ms	0ms

4

10,130

Details

0ms

commit;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jul 17	07	190	0ms	0ms
	08	852	0ms	0ms
	09	1,200	0ms	0ms
	10	1,169	0ms	0ms
	11	2,137	0ms	0ms
	12	1,482	0ms	0ms
	13	1,394	0ms	0ms
	14	364	0ms	0ms
	15	194	0ms	0ms
	16	191	0ms	0ms
	17	191	0ms	0ms
	18	191	0ms	0ms
	19	191	0ms	0ms
	20	191	0ms	0ms
	21	190	0ms	0ms
	22	3	0ms	0ms

5

10,124

Details

0ms

begin;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jul 17	07	187	0ms	0ms
	08	852	0ms	0ms
	09	1,198	0ms	0ms
	10	1,172	0ms	0ms
	11	2,144	0ms	0ms
	12	1,487	0ms	0ms
	13	1,401	0ms	0ms
	14	361	0ms	0ms
	15	191	0ms	0ms
	16	188	0ms	0ms
	17	188	0ms	0ms
	18	188	0ms	0ms
	19	188	0ms	0ms
	20	188	0ms	0ms
	21	187	0ms	0ms
	22	4	0ms	0ms

6

5,233

Details

0ms

select distinct addimensio0_.docbasetype as col_0_0_ from ad_dimension_mapping addimensio0_ where addimensio0_.ad_table_id = ? and addimensio0_.dimension = ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jul 17	08	559	0ms	0ms
	09	685	0ms	0ms
	10	404	0ms	0ms
	11	1,870	0ms	0ms
	12	763	0ms	0ms
	13	952	0ms	0ms

7

4,966

Details

0ms

select count(*) as total from ad_session where ad_session_id = ? and session_active = ? and isactive = ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jul 17	08	461	0ms	0ms
	09	696	0ms	0ms
	10	575	0ms	0ms
	11	1,458	0ms	0ms
	12	857	0ms	0ms
	13	853	0ms	0ms
	14	66	0ms	0ms

8

4,727

Details

0ms

select adlanguage0_.ad_language_id as ad_langu1_52_0_, adlanguage0_.ad_language as ad_langu2_52_0_, adlanguage0_.ad_client_id as ad_clien3_52_0_, adlanguage0_.ad_org_id as ad_org_i4_52_0_, adlanguage0_.isactive as isactive5_52_0_, adlanguage0_.created as created6_52_0_, adlanguage0_.createdby as createdb7_52_0_, adlanguage0_.updated as updated8_52_0_, adlanguage0_.updatedby as updatedb9_52_0_, adlanguage0_.name as name10_52_0_, adlanguage0_.languageiso as languag11_52_0_, adlanguage0_.countrycode as country12_52_0_, adlanguage0_.isbaselanguage as isbasel13_52_0_, adlanguage0_.issystemlanguage as issyste14_52_0_, adlanguage0_.processing as process15_52_0_, adlanguage0_.pixelsize as pixelsi16_52_0_, adlanguage0_.translatedby as transla17_52_0_, adlanguage0_.isrtl as isrtl18_52_0_ from ad_language adlanguage0_ where adlanguage0_.ad_language = ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	435	0ms	0ms
	09	591	0ms	0ms
	10	358	0ms	0ms
	11	1,065	0ms	0ms
	12	598	0ms	0ms
	13	577	0ms	0ms
	14	123	0ms	0ms
	15	124	0ms	0ms
	16	122	0ms	0ms
	17	122	0ms	0ms
	18	122	0ms	0ms
	19	122	0ms	0ms
	20	122	0ms	0ms
	21	122	0ms	0ms
	22	4	0ms	0ms

9

3,395

Details

0ms

select sum(total) as total from ( select count(*) as total from ad_process_access where ad_role_id = ? and (to_char(?) = ? or to_char(?) = ?) and ad_process_id = ? and isactive = ? union select count(*) as total from ad_form_access where ad_role_id = ? and to_char(?) = ? and ad_form_id = ? and isactive = ? union select count(*) as total from dual where (to_char(?) = ? or to_char(?) = ?) and to_char(?) <> to_char(?) union select count(*) as total from ad_window_access where ad_role_id = ? and to_char(?) = ? and ad_window_id = ( select ad_window_id from ad_tab where ad_tab_id = ?) and isactive = ? union select count(*) as total from ad_table_access t, ad_tab tb where t.ad_table_id = tb.ad_table_id and t.ad_role_id = ? and to_char(?) = ? and tb.ad_tab_id = ? and t.isactive = ? and t.isexclude = ? union select count(*) as total from ad_process_access a, ad_process p where ad_role_id = ? and to_char(?) = to_char(?) and a.ad_process_id = ? and p.ad_process_id = a.ad_process_id and a.isactive = ? and p.isexternalservice = ? union select ? as total from ad_process where to_char(?) = to_char(?) and ad_process_id = ? and isactive = ? and isexternalservice != ?) total;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jul 17	08	315	0ms	0ms
	09	508	0ms	0ms
	10	295	0ms	0ms
	11	1,106	0ms	0ms
	12	566	0ms	0ms
	13	605	0ms	0ms

10

2,731

Details

0ms

select adclient0_.ad_client_id as ad_clien1_18_0_, adclient0_.ad_org_id as ad_org_i2_18_0_, adclient0_.isactive as isactive3_18_0_, adclient0_.created as created4_18_0_, adclient0_.createdby as createdb5_18_0_, adclient0_.updated as updated6_18_0_, adclient0_.updatedby as updatedb7_18_0_, adclient0_.value as value8_18_0_, adclient0_.name as name9_18_0_, adclient0_.description as descrip10_18_0_, adclient0_.smtphost as smtphos11_18_0_, adclient0_.requestemail as request12_18_0_, adclient0_.requestuser as request13_18_0_, adclient0_.requestuserpw as request14_18_0_, adclient0_.requestfolder as request15_18_0_, adclient0_.ad_language as ad_lang16_18_0_, adclient0_.ismultilingualdocument as ismulti17_18_0_, adclient0_.issmtpauthorization as issmtpa18_18_0_, adclient0_.c_currency_id as c_curre19_18_0_, adclient0_.acctdim_centrally_maintained as acctdim20_18_0_, adclient0_.project_acctdim_isenable as project21_18_0_, adclient0_.project_acctdim_header as project22_18_0_, adclient0_.project_acctdim_lines as project23_18_0_, adclient0_.project_acctdim_breakdown as project24_18_0_, adclient0_.bpartner_acctdim_isenable as bpartne25_18_0_, adclient0_.bpartner_acctdim_header as bpartne26_18_0_, adclient0_.bpartner_acctdim_lines as bpartne27_18_0_, adclient0_.bpartner_acctdim_breakdown as bpartne28_18_0_, adclient0_.product_acctdim_isenable as product29_18_0_, adclient0_.product_acctdim_header as product30_18_0_, adclient0_.product_acctdim_lines as product31_18_0_, adclient0_.product_acctdim_breakdown as product32_18_0_, adclient0_.costcenter_acctdim_header as costcen33_18_0_, adclient0_.costcenter_acctdim_lines as costcen34_18_0_, adclient0_.costcenter_acctdim_breakdown as costcen35_18_0_, adclient0_.user1_acctdim_isenable as user36_18_0_, adclient0_.user1_acctdim_header as user37_18_0_, adclient0_.user1_acctdim_lines as user38_18_0_, adclient0_.user1_acctdim_breakdown as user39_18_0_, adclient0_.user2_acctdim_isenable as user40_18_0_, adclient0_.user2_acctdim_header as user41_18_0_, adclient0_.user2_acctdim_lines as user42_18_0_, adclient0_.user2_acctdim_breakdown as user43_18_0_, adclient0_.costcenter_acctdim_isenable as costcen44_18_0_, adclient0_.org_acctdim_isenable as org_acc45_18_0_, adclient0_.org_acctdim_header as org_acc46_18_0_, adclient0_.org_acctdim_lines as org_acc47_18_0_, adclient0_.org_acctdim_breakdown as org_acc48_18_0_, adclient0_.daystopasswordexpiration as daystop49_18_0_ from ad_client adclient0_ where adclient0_.ad_client_id = ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	215	0ms	0ms
	09	249	0ms	0ms
	10	211	0ms	0ms
	11	436	0ms	0ms
	12	254	0ms	0ms
	13	282	0ms	0ms
	14	121	0ms	0ms
	15	123	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

11

2,414

Details

0ms

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, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = ? and text.isused = ? and texttrl.ad_language = ? 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, ? 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 = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, ? as trllang, text.text as trltext, ? as istranslated, ? 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 = ?) and (text.filename is null or text.filename = ?) and text.isused = ? order by orderseq;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	151	0ms	0ms
	09	162	0ms	0ms
	10	166	0ms	0ms
	11	394	0ms	0ms
	12	210	0ms	0ms
	13	248	0ms	0ms
	14	121	0ms	0ms
	15	122	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

12

2,239

Details

0ms

select this_.c_invoice_id as c_invoic1_230_0_, this_.ad_client_id as ad_clien2_230_0_, this_.ad_org_id as ad_org_i3_230_0_, this_.isactive as isactive4_230_0_, this_.created as created5_230_0_, this_.createdby as createdb6_230_0_, this_.updated as updated7_230_0_, this_.updatedby as updatedb8_230_0_, this_.issotrx as issotrx9_230_0_, this_.documentno as documen10_230_0_, this_.docstatus as docstat11_230_0_, this_.docaction as docacti12_230_0_, this_.processing as process13_230_0_, this_.processed as process14_230_0_, this_.posted as posted15_230_0_, this_.c_doctype_id as c_docty16_230_0_, this_.c_doctypetarget_id as c_docty17_230_0_, this_.c_order_id as c_order18_230_0_, this_.description as descrip19_230_0_, this_.isprinted as isprint20_230_0_, this_.salesrep_id as salesre21_230_0_, this_.dateinvoiced as dateinv22_230_0_, this_.dateprinted as datepri23_230_0_, this_.dateacct as dateacc24_230_0_, this_.c_bpartner_id as c_bpart25_230_0_, this_.c_bpartner_location_id as c_bpart26_230_0_, this_.poreference as porefer27_230_0_, this_.isdiscountprinted as isdisco28_230_0_, this_.dateordered as dateord29_230_0_, this_.c_currency_id as c_curre30_230_0_, this_.c_paymentterm_id as c_payme31_230_0_, this_.c_charge_id as c_charg32_230_0_, this_.chargeamt as chargea33_230_0_, this_.totallines as totalli34_230_0_, this_.grandtotal as grandto35_230_0_, this_.m_pricelist_id as m_price36_230_0_, this_.istaxincluded as istaxin37_230_0_, this_.c_campaign_id as c_campa38_230_0_, this_.c_project_id as c_proje39_230_0_, this_.c_activity_id as c_activ40_230_0_, this_.createfrom as createf41_230_0_, this_.generateto as generat42_230_0_, this_.ad_user_id as ad_user43_230_0_, this_.copyfrom as copyfro44_230_0_, this_.isselfservice as isselfs45_230_0_, this_.ad_orgtrx_id as ad_orgt46_230_0_, this_.user1_id as user47_230_0_, this_.user2_id as user48_230_0_, this_.withholdingamount as withhol49_230_0_, this_.taxdate as taxdate50_230_0_, this_.c_withholding_id as c_withh51_230_0_, this_.ispaid as ispaid52_230_0_, this_.em_einv_generated as em_einv53_230_0_, this_.totalpaid as totalpa54_230_0_, this_.em_einv_sent as em_einv55_230_0_, this_.outstandingamt as outstan56_230_0_, this_.daystilldue as daystil57_230_0_, this_.dueamt as dueamt58_230_0_, this_.lastcalculatedondate as lastcal59_230_0_, this_.fin_paymentmethod_id as fin_pay60_230_0_, this_.fin_payment_priority_id as fin_pay61_230_0_, this_.finalsettlement as finalse62_230_0_, this_.daysoutstanding as daysout63_230_0_, this_.percentageoverdue as percent64_230_0_, this_.c_costcenter_id as c_costc65_230_0_, this_.calculate_promotions as calcula66_230_0_, this_.a_asset_id as a_asset67_230_0_, this_.em_aprm_addpayment as em_aprm68_230_0_, this_.iscashvat as iscashv69_230_0_, this_.em_aprm_processinvoice as em_aprm70_230_0_, this_.prepaymentamt as prepaym71_230_0_, this_.createfromorders as createf72_230_0_, this_.createfrominouts as createf73_230_0_, this_.paidamtatinvoicing as paidamt74_230_0_, this_.bpartner_extref as bpartne75_230_0_, this_.em_opxcld_createlines as em_opxc76_230_0_ from c_invoice this_ where this_.issotrx = ? and this_.ad_org_id = ? and this_.ad_org_id in (...) and this_.ad_client_id in (...) and this_.isactive = ? order by this_.documentno desc;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jul 17	11	1,210	0ms	0ms
	12	343	0ms	0ms
	13	686	0ms	0ms

13

2,124

Details

0ms

select ? from dual;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	153	0ms	0ms
	09	160	0ms	0ms
	10	164	0ms	0ms
	11	210	0ms	0ms
	12	175	0ms	0ms
	13	168	0ms	0ms
	14	131	0ms	0ms
	15	120	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	121	0ms	0ms
	22	2	0ms	0ms

14

1,980

Details

0ms

show server_version;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jul 17	07	132	0ms	0ms
	08	132	0ms	0ms
	09	132	0ms	0ms
	10	132	0ms	0ms
	11	132	0ms	0ms
	12	132	0ms	0ms
	13	132	0ms	0ms
	14	132	0ms	0ms
	15	132	0ms	0ms
	16	132	0ms	0ms
	17	132	0ms	0ms
	18	132	0ms	0ms
	19	132	0ms	0ms
	20	132	0ms	0ms
	21	132	0ms	0ms

15

1,851

Details

0ms

select adsystemin0_.ad_system_info_id as ad_syste1_116_0_, adsystemin0_.ad_client_id as ad_clien2_116_0_, adsystemin0_.ad_org_id as ad_org_i3_116_0_, adsystemin0_.isactive as isactive4_116_0_, adsystemin0_.created as created5_116_0_, adsystemin0_.createdby as createdb6_116_0_, adsystemin0_.updated as updated7_116_0_, adsystemin0_.updatedby as updatedb8_116_0_, adsystemin0_.system_identifier as system_i9_116_0_, adsystemin0_.isheartbeatactive as isheart10_116_0_, adsystemin0_.postpone_date as postpon11_116_0_, adsystemin0_.isproxyrequired as isproxy12_116_0_, adsystemin0_.proxy_server as proxy_s13_116_0_, adsystemin0_.proxy_port as proxy_p14_116_0_, adsystemin0_.testproxy as testpro15_116_0_, adsystemin0_.ant_version as ant_ver16_116_0_, adsystemin0_.ob_version as ob_vers17_116_0_, adsystemin0_.ob_installmode as ob_inst18_116_0_, adsystemin0_.webserver as webserv19_116_0_, adsystemin0_.webserver_version as webserv20_116_0_, adsystemin0_.customization_allowed as customi21_116_0_, adsystemin0_.last_build as last_bu22_116_0_, adsystemin0_.last_dbupdate as last_db23_116_0_, adsystemin0_.db_checksum as db_chec24_116_0_, adsystemin0_.your_company_login_image as your_co25_116_0_, adsystemin0_.your_it_service_login_image as your_it26_116_0_, adsystemin0_.your_company_menu_image as your_co27_116_0_, adsystemin0_.your_company_big_image as your_co28_116_0_, adsystemin0_.your_company_document_image as your_co29_116_0_, adsystemin0_.support_contact as support30_116_0_, adsystemin0_.system_status as system_31_116_0_, adsystemin0_.maturity_update as maturit32_116_0_, adsystemin0_.maturity_search as maturit33_116_0_, adsystemin0_.isproxy_authenticated as isproxy34_116_0_, adsystemin0_.proxy_user as proxy_u35_116_0_, adsystemin0_.proxy_password as proxy_p36_116_0_, adsystemin0_.instance_purpose as instanc37_116_0_, adsystemin0_.isusageauditenabled as isusage38_116_0_, adsystemin0_.change_instance_purpose as change_39_116_0_, adsystemin0_.show_community_branding as show_co40_116_0_, adsystemin0_.production_banner_image_id as product41_116_0_, adsystemin0_.em_prbck_company_test_image as em_prbc42_116_0_, adsystemin0_.yourcompanyurl as yourcom43_116_0_ from ad_system_info adsystemin0_ where adsystemin0_.ad_system_info_id = ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	129	0ms	0ms
	09	135	0ms	0ms
	10	126	0ms	0ms
	11	127	0ms	0ms
	12	130	0ms	0ms
	13	121	0ms	0ms
	14	121	0ms	0ms
	15	122	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

16

1,823

Details

0ms

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 = ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	123	0ms	0ms
	09	125	0ms	0ms
	10	123	0ms	0ms
	11	124	0ms	0ms
	12	124	0ms	0ms
	13	121	0ms	0ms
	14	121	0ms	0ms
	15	122	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

17

1,814

Details

0ms

select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where (adpreferen0_.value like ?) and adpreferen0_.property = ? and (adpreferen0_.visibleat_client_id is null or adpreferen0_.visibleat_client_id = ?);

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	121	0ms	0ms
	09	122	0ms	0ms
	10	122	0ms	0ms
	11	123	0ms	0ms
	12	122	0ms	0ms
	13	121	0ms	0ms
	14	121	0ms	0ms
	15	122	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

18

1,814

Details

0ms

select adpreferen0_.ad_preference_id as ad_prefe1_83_, adpreferen0_.ad_client_id as ad_clien2_83_, adpreferen0_.ad_org_id as ad_org_i3_83_, adpreferen0_.isactive as isactive4_83_, adpreferen0_.created as created5_83_, adpreferen0_.createdby as createdb6_83_, adpreferen0_.updated as updated7_83_, adpreferen0_.updatedby as updatedb8_83_, adpreferen0_.ad_window_id as ad_windo9_83_, adpreferen0_.ad_user_id as ad_user10_83_, adpreferen0_.attribute as attribu11_83_, adpreferen0_.value as value12_83_, adpreferen0_.property as propert13_83_, adpreferen0_.ispropertylist as isprope14_83_, adpreferen0_.visibleat_client_id as visible15_83_, adpreferen0_.visibleat_org_id as visible16_83_, adpreferen0_.visibleat_role_id as visible17_83_, adpreferen0_.selected as selecte18_83_, adpreferen0_.ad_module_id as ad_modu19_83_, adpreferen0_.inherited_from as inherit20_83_ from ad_preference adpreferen0_ where coalesce(adpreferen0_.visibleat_client_id, ?) = ? and (adpreferen0_.visibleat_role_id is null) and (coalesce(adpreferen0_.visibleat_org_id, ?) in (...)) and (adpreferen0_.ad_user_id is null) and (adpreferen0_.ad_window_id is null) and adpreferen0_.ispropertylist = ? and adpreferen0_.property = ? and (adpreferen0_.ad_org_id in (...)) and (adpreferen0_.ad_client_id in (...)) and adpreferen0_.isactive = ? order by adpreferen0_.ad_preference_id;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	121	0ms	0ms
	09	122	0ms	0ms
	10	122	0ms	0ms
	11	123	0ms	0ms
	12	122	0ms	0ms
	13	121	0ms	0ms
	14	121	0ms	0ms
	15	122	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

19

1,751

Details

0ms

select accesslevel from ad_form where to_char(?) = ? and ad_form_id = ? union select accesslevel from ad_process where (to_char(?) = ? or to_char(?) = ?) and ad_process_id = ? union select t.accesslevel from ad_table t, ad_tab tb where t.ad_table_id = tb.ad_table_id and to_char(?) = ? and tb.ad_tab_id = ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jul 17	08	162	0ms	0ms
	09	255	0ms	0ms
	10	150	0ms	0ms
	11	574	0ms	0ms
	12	297	0ms	0ms
	13	313	0ms	0ms

20

1,749

Details

0ms

select currency0_.c_currency_id as c_curren1_197_0_, currency0_.ad_client_id as ad_clien2_197_0_, currency0_.ad_org_id as ad_org_i3_197_0_, currency0_.isactive as isactive4_197_0_, currency0_.created as created5_197_0_, currency0_.createdby as createdb6_197_0_, currency0_.updated as updated7_197_0_, currency0_.updatedby as updatedb8_197_0_, currency0_.iso_code as iso_code9_197_0_, currency0_.cursymbol as cursymb10_197_0_, currency0_.description as descrip11_197_0_, currency0_.stdprecision as stdprec12_197_0_, currency0_.costingprecision as costing13_197_0_, currency0_.priceprecision as pricepr14_197_0_, currency0_.issymbolrightside as issymbo15_197_0_ from c_currency currency0_ where currency0_.c_currency_id = ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jul 17	08	175	0ms	0ms
	09	260	0ms	0ms
	10	160	0ms	0ms
	11	584	0ms	0ms
	12	270	0ms	0ms
	13	297	0ms	0ms
	14	3	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

10

Details

0ms

select td0.c_bpartner_id as id, (coalesce(to_char(coalesce(to_char(td0.name), ?)), ?)) as name, ? as description from c_bpartner td0 where td0.ad_client_id in (...) and td0.ad_org_id in (...) and td0.c_bpartner_id in ( select bp.c_bpartner_id from c_bpartner bp, c_bp_group g where g.c_bp_group_id = bp.c_bp_group_id and g.value = ?) and (td0.isactive = ? or td0.c_bpartner_id = (null)) and td0.c_bpartner_id = (?) order by ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms
	10	1	0ms	0ms
	11	4	0ms	0ms
	12	2	0ms	0ms
	13	2	0ms	0ms

2

0ms

750

Details

0ms

select pricingpri0_.m_pricelist_id as m_pricel1_432_0_, pricingpri0_.ad_client_id as ad_clien2_432_0_, pricingpri0_.ad_org_id as ad_org_i3_432_0_, pricingpri0_.isactive as isactive4_432_0_, pricingpri0_.created as created5_432_0_, pricingpri0_.createdby as createdb6_432_0_, pricingpri0_.updated as updated7_432_0_, pricingpri0_.updatedby as updatedb8_432_0_, pricingpri0_.name as name9_432_0_, pricingpri0_.description as descrip10_432_0_, pricingpri0_.basepricelist_id as basepri11_432_0_, pricingpri0_.istaxincluded as istaxin12_432_0_, pricingpri0_.issopricelist as issopri13_432_0_, pricingpri0_.isdefault as isdefau14_432_0_, pricingpri0_.c_currency_id as c_curre15_432_0_, pricingpri0_.enforcepricelimit as enforce16_432_0_, pricingpri0_.costbased as costbas17_432_0_ from m_pricelist pricingpri0_ where pricingpri0_.m_pricelist_id = ?;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 17	08	113	0ms	0ms
	09	131	0ms	0ms
	10	55	0ms	0ms
	11	213	0ms	0ms
	12	138	0ms	0ms
	13	100	0ms	0ms

3

0ms

1

Details

0ms

insert into c_invoiceline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_invoice_id, c_orderline_id, line, description, financial_invoice_line, m_product_id, qtyinvoiced, pricelist, priceactual, pricelimit, linenetamt, chargeamt, c_uom_id, c_tax_id, isdescription, pricestd, excludeforwithholding, iseditlinenetamt, taxbaseamt, line_gross_amount, gross_unit_price, c_bpartner_id, grosspricestd, grosspricelist, isdeferred, explode, match_lccosts, cancelpricead, c_invoiceline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? n ? ? f9f95d307464074a2dc899b2d3c3ac4 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? a0e9eb5c5ebb462b9155106a3d441525 ? n ? ? ? n ? n ? ? ? ? ? ? ? f501892a499d4bbbb0b02aea1eb29d93 ? ? ? ? ? n ? n ? n ? n ? ? e2a31da2ad54c96a0226a24a0313c0e ');

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 17	11	1	0ms	0ms

4

0ms

1

Details

0ms

update fin_payment set updated = ?, processed = ?, description = ? re ? ? efa04906d5a40aaa57020858d2ef44b ';

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jul 17	09	1	0ms	0ms

5

0ms

8

Details

0ms

insert into fact_acct (fact_acct_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_acctschema_id, account_id, acctvalue, acctdescription, datetrx, dateacct, c_period_id, ad_table_id, record_id, line_id, gl_category_id, c_tax_id, postingtype, c_currency_id, amtsourcedr, amtsourcecr, amtacctdr, amtacctcr, c_uom_id, qty, m_locator_id, m_product_id, c_bpartner_id, ad_orgtrx_id, c_locfrom_id, c_locto_id, c_salesregion_id, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id, description, fact_acct_group_id, seqno, docbasetype, record_id2, a_asset_id, c_withholding_id, c_doctype_id, c_costcenter_id, factaccttype) values (?, ?, ?, ?, now(), ?, now(), ?, ?, ?, ?, ?, to_date(?), to_date(?), ?, ?, ?, null, ?, ?, ?, ?, to_number(?), to_number(?), to_number(?), to_number(?), null, to_number(null), null, null, ?, null, ?, ?, null, null, null, null, null, null, ?, ?, to_number(?), ?, null, null, null, ?, null, ?);

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jul 17	10	1	0ms	0ms
	11	4	0ms	0ms
	13	1	0ms	0ms
	14	2	0ms	0ms

6

0ms

26

Details

0ms

select users.default_ad_org_id from ad_user users inner join ad_org org on users.default_ad_org_id = org.ad_org_id where users.ad_user_id = ? and not users.default_ad_org_id is null and org.isactive = ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jul 17	08	6	0ms	0ms
	09	8	0ms	0ms
	10	3	0ms	0ms
	11	3	0ms	0ms
	12	6	0ms	0ms

7

0ms

1

Details

0ms

update c_bpartner set updated = ?, updatedby = ?, taxid = ? where c_bpartner_id = ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms

8

0ms

33

Details

0ms

select obuiapppar0_.obuiapp_parameter_id as obuiapp_9_617_1_, obuiapppar0_.obuiapp_parameter_trl_id as obuiapp_1_617_1_, obuiapppar0_.obuiapp_parameter_trl_id as obuiapp_1_617_0_, obuiapppar0_.ad_client_id as ad_clien2_617_0_, obuiapppar0_.ad_org_id as ad_org_i3_617_0_, obuiapppar0_.isactive as isactive4_617_0_, obuiapppar0_.created as created5_617_0_, obuiapppar0_.createdby as createdb6_617_0_, obuiapppar0_.updated as updated7_617_0_, obuiapppar0_.updatedby as updatedb8_617_0_, obuiapppar0_.obuiapp_parameter_id as obuiapp_9_617_0_, obuiapppar0_.name as name10_617_0_, obuiapppar0_.description as descrip11_617_0_, obuiapppar0_.help as help12_617_0_, obuiapppar0_.istranslated as istrans13_617_0_, obuiapppar0_.ad_language as ad_lang14_617_0_ from obuiapp_parameter_trl obuiapppar0_ where obuiapppar0_.obuiapp_parameter_id in (...);

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jul 17	08	14	0ms	0ms
	09	16	0ms	0ms
	12	3	0ms	0ms

9

0ms

2

Details

0ms

update ad_alert set status = ?, updated = now(), updatedby = ? where ad_alertrule_id = ? and coalesce(status, ?) != ? and not exists ( select ? from ( select gl_journal_id as referencekey_id, ? as ad_role_id, null as ad_user_id, ? as description, ? as isactive, ad_org_id, ad_client_id, now() as created, ? as createdby, now() as updated, ? as updatedby, ad_column_identifier (?, gl_journal_id, ?) as record_id, posted from gl_journal where gl_journal.posted in (...) or gl_journal.posted in (...) or gl_journal.posted in (...) group by gl_journal_id, posted, ad_client_id, ad_org_id) a where ? = ? and a.referencekey_id = ad_alert.referencekey_id);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jul 17	15	1	0ms	0ms
	21	1	0ms	0ms

10

0ms

20

Details

0ms

select max(ad_user_id) as id from ad_user, c_bpartner where ad_user.c_bpartner_id = c_bpartner.c_bpartner_id and c_bpartner.issalesrep = ? and ad_user.isactive = ? and ad_user.c_bpartner_id = ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jul 17	08	2	0ms	0ms
	09	2	0ms	0ms
	10	2	0ms	0ms
	11	7	0ms	0ms
	12	5	0ms	0ms
	13	2	0ms	0ms

11

0ms

22

Details

0ms

select ad_val_rule_id from ad_val_rule where upper(name) = upper(?);

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jul 17	08	3	0ms	0ms
	09	2	0ms	0ms
	10	2	0ms	0ms
	11	7	0ms	0ms
	12	6	0ms	0ms
	13	2	0ms	0ms

12

0ms

1

Details

0ms

select c_invoice.c_invoice_id as document_id, c_invoice.docstatus as docstatus, c_invoice.documentno as ourreference, c_invoice.poreference as yourreference, c_invoice.salesrep_id as salesrep_user_id, salesrep.email as salesrep_email, salesrep.name as salesrep_name, c_invoice.c_bpartner_id as bpartner_id, c_bpartner.name as bpartner_name, c_invoice.ad_user_id as contact_user_id, customercontact.email as contact_email, customercontact.name as contact_name from c_invoice left join ad_user customercontact on c_invoice.ad_user_id = customercontact.ad_user_id left join ad_user salesrep on c_invoice.salesrep_id = salesrep.ad_user_id left join c_bpartner on c_invoice.c_bpartner_id = c_bpartner.c_bpartner_id where ? = ? and c_invoice.c_invoice_id in (...);

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jul 17	12	1	0ms	0ms

13

0ms

45

Details

0ms

set search_path = ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jul 17	07	3	0ms	0ms
	08	3	0ms	0ms
	09	3	0ms	0ms
	10	3	0ms	0ms
	11	3	0ms	0ms
	12	3	0ms	0ms
	13	3	0ms	0ms
	14	3	0ms	0ms
	15	3	0ms	0ms
	16	3	0ms	0ms
	17	3	0ms	0ms
	18	3	0ms	0ms
	19	3	0ms	0ms
	20	3	0ms	0ms
	21	3	0ms	0ms

14

0ms

2,414

Details

0ms

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, ? as orderseq from ad_textinterfaces text, ad_textinterfaces_trl texttrl where text.ad_textinterfaces_id = texttrl.ad_textinterfaces_id and text.filename = ? and text.isused = ? and texttrl.ad_language = ? 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, ? 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 = ? and texttrl.ad_language = ? union select text.filename as filename, text.text as text, text.isused as isused, text.ad_module_id as moduleid, ? as trllang, text.text as trltext, ? as istranslated, ? 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 = ?) and (text.filename is null or text.filename = ?) and text.isused = ? order by orderseq;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jul 17	07	120	0ms	0ms
	08	151	0ms	0ms
	09	162	0ms	0ms
	10	166	0ms	0ms
	11	394	0ms	0ms
	12	210	0ms	0ms
	13	248	0ms	0ms
	14	121	0ms	0ms
	15	122	0ms	0ms
	16	120	0ms	0ms
	17	120	0ms	0ms
	18	120	0ms	0ms
	19	120	0ms	0ms
	20	120	0ms	0ms
	21	120	0ms	0ms

15

0ms

1

Details

0ms

insert into c_orderline (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_order_id, line, c_bpartner_id, c_bpartner_location_id, dateordered, datepromised, description, m_product_id, m_warehouse_id, directship, c_uom_id, qtyordered, qtyreserved, qtydelivered, qtyinvoiced, c_currency_id, pricelist, priceactual, pricelimit, linenetamt, discount, freightamt, chargeamt, c_tax_id, isdescription, pricestd, cancelpricead, iseditlinenetamt, taxbaseamt, gross_unit_price, line_gross_amount, grosspricestd, manage_reservation, manage_prereservation, explode, em_opxmp_purchase_bpartner_id, em_opxmp_costprice, print_description, em_opxmp_m_pl_version_id, em_opxmp_margen, relate_orderline, c_orderline_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ? f9f95d307464074a2dc899b2d3c3ac4 ? cd0854c3d1394b6299bd7ebed08e0968 ? n ? ? ? ? ? ? ? ? ? ? ? ? ? ?.? ? ?.? ? ? ? ?.? ? ? ? ? ? ? ? a0e9eb5c5ebb462b9155106a3d441525 ? n ? ?.? ? n ? n ? ?.? ? ? ? ? ? ? ? n ? n ? n ? ? fdc0464ff4ea2afdd93b3df60ff9a ? ? ? n ? b7431208a39040e7b4b5d0198d0606e8 ? ? ? n ? ? e28840b94c81b5de5737e2dbaf55 ');

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jul 17	10	1	0ms	0ms

16

0ms

60

Details

0ms

select this_.fin_finacc_paymentmethod_id as fin_fina1_329_0_, this_.ad_client_id as ad_clien2_329_0_, this_.ad_org_id as ad_org_i3_329_0_, this_.created as created4_329_0_, this_.createdby as createdb5_329_0_, this_.updated as updated6_329_0_, this_.updatedby as updatedb7_329_0_, this_.isactive as isactive8_329_0_, this_.fin_paymentmethod_id as fin_paym9_329_0_, this_.fin_financial_account_id as fin_fin10_329_0_, this_.automatic_receipt as automat11_329_0_, this_.automatic_payment as automat12_329_0_, this_.automatic_deposit as automat13_329_0_, this_.automatic_withdrawn as automat14_329_0_, this_.payin_allow as payin_a15_329_0_, this_.payout_allow as payout_16_329_0_, this_.payin_execution_type as payin_e17_329_0_, this_.payout_execution_type as payout_18_329_0_, this_.payin_execution_process_id as payin_e19_329_0_, this_.payout_execution_process_id as payout_20_329_0_, this_.payin_deferred as payin_d21_329_0_, this_.payout_deferred as payout_22_329_0_, this_.uponreceiptuse as uponrec23_329_0_, this_.upondeposituse as upondep24_329_0_, this_.inuponclearinguse as inuponc25_329_0_, this_.uponpaymentuse as uponpay26_329_0_, this_.uponwithdrawaluse as uponwit27_329_0_, this_.outuponclearinguse as outupon28_329_0_, this_.payin_ismulticurrency as payin_i29_329_0_, this_.payout_ismulticurrency as payout_30_329_0_, this_.isdefault as isdefau31_329_0_, this_.payin_invoicepaidstatus as payin_i32_329_0_, this_.payout_invoicepaidstatus as payout_33_329_0_ from fin_finacc_paymentmethod this_ where this_.fin_financial_account_id = ? and this_.fin_paymentmethod_id = ? and this_.isactive = ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jul 17	09	8	0ms	0ms
	10	16	0ms	0ms
	11	10	0ms	0ms
	12	20	0ms	0ms
	13	2	0ms	0ms
	14	4	0ms	0ms

17

0ms

4

Details

0ms

insert into c_order (ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, issotrx, documentno, docstatus, docaction, processing, processed, c_doctype_id, c_doctypetarget_id, isdelivered, isinvoiced, isprinted, isselected, salesrep_id, dateordered, datepromised, dateacct, c_bpartner_id, billto_id, c_bpartner_location_id, isdiscountprinted, c_currency_id, paymentrule, c_paymentterm_id, invoicerule, deliveryrule, freightcostrule, freightamt, deliveryviarule, chargeamt, priorityrule, totallines, grandtotal, m_warehouse_id, m_pricelist_id, istaxincluded, posted, ad_user_id, copyfrom, isselfservice, generatetemplate, delivery_location_id, copyfrompo, fin_paymentmethod_id, rm_pickfromshipment, rm_receivematerials, rm_createinvoice, rm_addorphanline, calculate_promotions, convertquotation, create_polines, iscashvat, em_opxmp_buttonpo, rm_pickfromreceipt, cancelandreplace, em_aprm_addpayment, em_opxmp_envdirecto, em_opxmp_disenador_id, em_opxmp_estado, em_opxmp_buttonpv, em_opxmp_buttonmail, em_mp_infpvint, confirmcancelandreplace, iscancelled, c_order_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms
	11	1	0ms	0ms
	12	1	0ms	0ms
	13	1	0ms	0ms

18

0ms

2

Details

0ms

select aduser0_.ad_user_id as ad_user_1_129_1_, aduser0_.ad_client_id as ad_clien2_129_1_, aduser0_.ad_org_id as ad_org_i3_129_1_, aduser0_.isactive as isactive4_129_1_, aduser0_.created as created5_129_1_, aduser0_.createdby as createdb6_129_1_, aduser0_.updated as updated7_129_1_, aduser0_.updatedby as updatedb8_129_1_, aduser0_.name as name9_129_1_, aduser0_.description as descrip10_129_1_, aduser0_.password as passwor11_129_1_, aduser0_.email as email12_129_1_, aduser0_.supervisor_id as supervi13_129_1_, aduser0_.c_bpartner_id as c_bpart14_129_1_, aduser0_.processing as process15_129_1_, aduser0_.emailuser as emailus16_129_1_, aduser0_.emailuserpw as emailus17_129_1_, aduser0_.c_bpartner_location_id as c_bpart18_129_1_, aduser0_.c_greeting_id as c_greet19_129_1_, aduser0_.title as title20_129_1_, aduser0_.comments as comment21_129_1_, aduser0_.phone as phone22_129_1_, aduser0_.phone2 as phone23_129_1_, aduser0_.fax as fax24_129_1_, aduser0_.lastcontact as lastcon25_129_1_, aduser0_.lastresult as lastres26_129_1_, aduser0_.birthday as birthda27_129_1_, aduser0_.ad_orgtrx_id as ad_orgt28_129_1_, aduser0_.firstname as firstna29_129_1_, aduser0_.lastname as lastnam30_129_1_, aduser0_.username as usernam31_129_1_, aduser0_.default_ad_client_id as default32_129_1_, aduser0_.default_ad_language as default33_129_1_, aduser0_.default_ad_org_id as default34_129_1_, aduser0_.default_ad_role_id as default35_129_1_, aduser0_.default_m_warehouse_id as default36_129_1_, aduser0_.islocked as islocke37_129_1_, aduser0_.ad_image_id as ad_imag38_129_1_, aduser0_.grant_portal_access as grant_p39_129_1_, aduser0_.lastpasswordupdate as lastpas40_129_1_, aduser0_.isexpiredpassword as isexpir41_129_1_, aduser0_.commercialauth as commerc42_129_1_, aduser0_.viasms as viasms43_129_1_, aduser0_.viaemail as viaemai44_129_1_, aduser0_.em_smfsws_default_ws_role_id as em_smfs45_129_1_, aduserrole1_.ad_user_id as ad_user_2_130_3_, aduserrole1_.ad_user_roles_id as ad_user_1_130_3_, aduserrole1_.ad_user_roles_id as ad_user_1_130_0_, aduserrole1_.ad_user_id as ad_user_2_130_0_, aduserrole1_.ad_role_id as ad_role_3_130_0_, aduserrole1_.ad_client_id as ad_clien4_130_0_, aduserrole1_.ad_org_id as ad_org_i5_130_0_, aduserrole1_.isactive as isactive6_130_0_, aduserrole1_.created as created7_130_0_, aduserrole1_.createdby as createdb8_130_0_, aduserrole1_.updated as updated9_130_0_, aduserrole1_.updatedby as updated10_130_0_, aduserrole1_.is_role_admin as is_role11_130_0_ from ad_user aduser0_ left outer join ad_user_roles aduserrole1_ on aduser0_.ad_user_id = aduserrole1_.ad_user_id where aduser0_.ad_user_id = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jul 17	09	2	0ms	0ms

19

0ms

180

Details

0ms

select usename, count(*) from pg_stat_activity where pid != pg_backend_pid() and usename is not null group by usename order by ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jul 17	07	12	0ms	0ms
	08	12	0ms	0ms
	09	12	0ms	0ms
	10	12	0ms	0ms
	11	12	0ms	0ms
	12	12	0ms	0ms
	13	12	0ms	0ms
	14	12	0ms	0ms
	15	12	0ms	0ms
	16	12	0ms	0ms
	17	12	0ms	0ms
	18	12	0ms	0ms
	19	12	0ms	0ms
	20	12	0ms	0ms
	21	12	0ms	0ms

20

0ms

3

Details

0ms

select td0.fin_financial_account_id as id, (coalesce(to_char(coalesce(to_char(td0.name), ?)), ?)) as name, ? as description from fin_financial_account td0 where td0.ad_client_id in (...) and td0.ad_org_id in (...) and (fin_financial_account_id in ( select fin_financial_account_id from fin_finacc_paymentmethod where fin_paymentmethod_id = ?)) and (td0.isactive = ? or td0.fin_financial_account_id = (?)) and td0.fin_financial_account_id = (?) order by ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jul 17	08	1	0ms	0ms
	12	2	0ms	0ms

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

0ms

189

Details

0ms

;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Jul 17	08	25	0ms	0ms
	09	20	0ms	0ms
	10	44	0ms	0ms
	11	23	0ms	0ms
	12	53	0ms	0ms
	13	10	0ms	0ms
	14	4	0ms	0ms
	15	2	0ms	0ms
	16	1	0ms	0ms
	17	1	0ms	0ms
	18	1	0ms	0ms
	19	1	0ms	0ms
	20	1	0ms	0ms
	21	2	0ms	0ms
	22	1	0ms	0ms

;

Date: Duration: 0ms Database: postgres User: etendo Remote: tad Application: 127.0.0.1 Queryid: openbravo

Log levels

Key values

1,303,386 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	291,353	22.35%
ERROR	2	0.00%
LOG	1,012,027	77.65%
STATEMENT	4	0.00%

Events distribution (except queries)

Key values

0 PANIC entries
0 FATAL entries
2 ERROR entries
0 WARNING entries
0 EVENTLOG entries

Most Frequent Errors/Events

Key values

1 Max number of times the same event was reported
2 Total events found

Rank

Times reported

Error

1

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jul 17	09	1

ERROR: column "cost" does not exist at character 49

2

1

Details

ERROR: new row for relation "..." violates check constraint "..."

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jul 17	13	1

ERROR: new row for relation "fin_finacc_transaction" violates check constraint "fin_trans_amounts_chk"

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Average Autovacuum Duration

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Vacuum throughput per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database