pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Mar 13 23:50:26 2023
Log file: /var/log/postgresql/postgresql-14-main.log
Parsed 14,876 log entries in 25s
Log start from 2023-03-12 00:02:48 to 2023-03-12 23:58:40

Global Stats

176 Number of unique normalized queries
1,935 Number of queries
17m31s Total query duration
2023-03-12 00:03:17 First query
2023-03-12 23:58:40 Last query
7 queries/s at 2023-03-12 12:59:55 Query peak

17m31s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
17m31s Execute total duration

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

0 Total number of automatic vacuums
0 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
1,935 Average queries per session
17m31s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

7 queries/s Query Peak
2023-03-12 12:59:55 Date

SELECT Traffic

Key values

7 queries/s Query Peak
2023-03-12 13:42:50 Date

INSERT/UPDATE/DELETE Traffic

Key values

6 queries/s Query Peak
2023-03-12 12:49:37 Date

Queries duration

Key values

17m31s 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)
Mar 12	00	35	0ms	148ms	127ms	243ms	263ms	650ms
	01	24	0ms	142ms	127ms	141ms	248ms	391ms
	02	39	0ms	322ms	135ms	256ms	399ms	617ms
	03	159	0ms	5s143ms	353ms	2s450ms	6s430ms	13s77ms
	04	123	0ms	3s276ms	242ms	1s109ms	2s663ms	6s88ms
	05	35	0ms	506ms	139ms	261ms	507ms	637ms
	06	20	0ms	147ms	130ms	140ms	251ms	281ms
	07	24	0ms	167ms	130ms	245ms	262ms	383ms
	08	41	0ms	2s311ms	235ms	267ms	275ms	5s241ms
	09	83	0ms	38s863ms	2s643ms	134ms	48s861ms	1m11s
	10	290	0ms	11s129ms	511ms	248ms	12s92ms	59s936ms
	11	23	0ms	159ms	127ms	142ms	246ms	254ms
	12	199	0ms	18s462ms	883ms	6s755ms	40s962ms	56s541ms
	13	124	0ms	3s287ms	376ms	2s210ms	5s698ms	11s450ms
	14	42	0ms	684ms	303ms	820ms	1s707ms	2s308ms
	15	214	0ms	8s387ms	483ms	3s563ms	14s	37s211ms
	16	196	0ms	13s316ms	743ms	5s314ms	27s905ms	45s640ms
	17	73	0ms	1s937ms	399ms	936ms	3s196ms	9s340ms
	18	37	0ms	1s66ms	249ms	250ms	380ms	4s22ms
	19	29	0ms	149ms	129ms	255ms	295ms	394ms
	20	24	0ms	146ms	126ms	246ms	250ms	372ms
	21	23	0ms	142ms	126ms	258ms	268ms	391ms
	22	53	0ms	1s155ms	492ms	259ms	277ms	22s188ms
	23	25	0ms	147ms	129ms	257ms	268ms	383ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 12	00	35	0	127ms	129ms	243ms	650ms
	01	24	0	127ms	128ms	141ms	391ms
	02	39	0	135ms	145ms	256ms	549ms
	03	159	0	353ms	902ms	2s450ms	8s828ms
	04	123	0	242ms	529ms	1s109ms	3s748ms
	05	35	0	139ms	129ms	261ms	548ms
	06	20	0	130ms	125ms	140ms	281ms
	07	24	0	130ms	125ms	245ms	383ms
	08	39	0	230ms	250ms	267ms	383ms
	09	22	61	2s643ms	128ms	319ms	1m11s
	10	286	0	443ms	126ms	161ms	57s315ms
	11	23	0	127ms	125ms	142ms	254ms
	12	92	0	162ms	414ms	1s38ms	2s276ms
	13	83	0	191ms	291ms	1s84ms	2s210ms
	14	42	0	303ms	166ms	820ms	2s308ms
	15	178	0	210ms	696ms	2s235ms	5s72ms
	16	133	0	232ms	376ms	1s348ms	6s626ms
	17	56	0	213ms	161ms	510ms	2s196ms
	18	37	0	249ms	130ms	250ms	4s22ms
	19	29	0	129ms	130ms	255ms	394ms
	20	24	0	126ms	129ms	246ms	372ms
	21	23	0	126ms	125ms	258ms	391ms
	22	53	0	492ms	135ms	259ms	22s188ms
	23	25	0	129ms	125ms	257ms	383ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 12	00	0	0	0	0ms	0ms	0ms	0ms
	01	0	0	0	0ms	0ms	0ms	0ms
	02	0	0	0	0ms	0ms	0ms	0ms
	03	0	0	0	0ms	0ms	0ms	0ms
	04	0	0	0	0ms	0ms	0ms	0ms
	05	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	0	0ms	0ms	0ms	0ms
	07	0	0	0	0ms	0ms	0ms	0ms
	08	0	2	0	336ms	0ms	0ms	0ms
	09	0	0	0	0ms	0ms	0ms	0ms
	10	0	0	4	5s381ms	0ms	0ms	0ms
	11	0	0	0	0ms	0ms	0ms	0ms
	12	11	94	0	1s529ms	0ms	0ms	40s707ms
	13	1	39	0	765ms	0ms	0ms	4s279ms
	14	0	0	0	0ms	0ms	0ms	0ms
	15	6	25	0	2s105ms	0ms	0ms	8s166ms
	16	18	43	0	1s878ms	0ms	0ms	20s904ms
	17	4	13	0	1s10ms	0ms	0ms	3s579ms
	18	0	0	0	0ms	0ms	0ms	0ms
	19	0	0	0	0ms	0ms	0ms	0ms
	20	0	0	0	0ms	0ms	0ms	0ms
	21	0	0	0	0ms	0ms	0ms	0ms
	22	0	0	0	0ms	0ms	0ms	0ms
	23	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Percentage of prepare
Mar 12	00	0.00%
	01	0.00%
	02	0.00%
	03	0.00%
	04	0.00%
	05	0.00%
	06	0.00%
	07	0.00%
	08	0.00%
	09	0.00%
	10	0.00%
	11	0.00%
	12	0.00%
	13	0.00%
	14	0.00%
	15	0.00%
	16	0.00%
	17	0.00%
	18	0.00%
	19	0.00%
	20	0.00%
	21	0.00%
	22	0.00%
	23	0.00%

Day	Hour	Average / Second
Mar 12	00	0.00/s
	01	0.00/s
	02	0.00/s
	03	0.00/s
	04	0.00/s
	05	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	09	0.00/s
	10	0.00/s
	11	0.00/s
	12	0.00/s
	13	0.00/s
	14	0.00/s
	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s
	22	0.00/s
	23	0.00/s

Day	Hour	Average Duration	Average idle time
Mar 12	00	0ms	0ms
	01	0ms	0ms
	02	0ms	0ms
	03	0ms	0ms
	04	0ms	0ms
	05	0ms	0ms
	06	0ms	0ms
	07	0ms	0ms
	08	0ms	0ms
	09	0ms	0ms
	10	0ms	0ms
	11	0ms	0ms
	12	0ms	0ms
	13	0ms	0ms
	14	0ms	0ms
	15	0ms	0ms
	16	0ms	0ms
	17	0ms	0ms
	18	0ms	0ms
	19	0ms	0ms
	20	0ms	0ms
	21	0ms	0ms
	22	0ms	0ms
	23	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

0 buffers Checkpoint Peak
Date
seconds Highest write time
seconds Sync time

Checkpoint write buffers (5 minutes period)

Checkpoints Wal files

Key values

0 files Wal files usage Peak
Date

Checkpoint Wal files usage (5 minutes period)

Checkpoints distance

Key values

0 Mo Distance Peak
Date

Checkpoints Activity

Day	Hour	Write time	Sync time	Total time
Mar 12	00	0s	0s	0s
	01	0s	0s	0s
	02	0s	0s	0s
	03	0s	0s	0s
	04	0s	0s	0s
	05	0s	0s	0s
	06	0s	0s	0s
	07	0s	0s	0s
	08	0s	0s	0s
	09	0s	0s	0s
	10	0s	0s	0s
	11	0s	0s	0s
	12	0s	0s	0s
	13	0s	0s	0s
	14	0s	0s	0s
	15	0s	0s	0s
	16	0s	0s	0s
	17	0s	0s	0s
	18	0s	0s	0s
	19	0s	0s	0s
	20	0s	0s	0s
	21	0s	0s	0s
	22	0s	0s	0s
	23	0s	0s	0s

Day	Hour	Longest sync	Average sync
Mar 12	00	0s	0s
	01	0s	0s
	02	0s	0s
	03	0s	0s
	04	0s	0s
	05	0s	0s
	06	0s	0s
	07	0s	0s
	08	0s	0s
	09	0s	0s
	10	0s	0s
	11	0s	0s
	12	0s	0s
	13	0s	0s
	14	0s	0s
	15	0s	0s
	16	0s	0s
	17	0s	0s
	18	0s	0s
	19	0s	0s
	20	0s	0s
	21	0s	0s
	22	0s	0s
	23	0s	0s

Day	Hour	Avg time (sec)
Mar 12	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	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
	23	0s

Day	Hour	Mean distance	Mean estimate
Mar 12	00	0.00 kB	0.00 kB
	01	0.00 kB	0.00 kB
	02	0.00 kB	0.00 kB
	03	0.00 kB	0.00 kB
	04	0.00 kB	0.00 kB
	05	0.00 kB	0.00 kB
	06	0.00 kB	0.00 kB
	07	0.00 kB	0.00 kB
	08	0.00 kB	0.00 kB
	09	0.00 kB	0.00 kB
	10	0.00 kB	0.00 kB
	11	0.00 kB	0.00 kB
	12	0.00 kB	0.00 kB
	13	0.00 kB	0.00 kB
	14	0.00 kB	0.00 kB
	15	0.00 kB	0.00 kB
	16	0.00 kB	0.00 kB
	17	0.00 kB	0.00 kB
	18	0.00 kB	0.00 kB
	19	0.00 kB	0.00 kB
	20	0.00 kB	0.00 kB
	21	0.00 kB	0.00 kB
	22	0.00 kB	0.00 kB
	23	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

unknown (0) Main checkpoint cause
0 checkpoints Total

Chart
Table

Checkpoint causes

Cause	Number of checkpoints
NO DATASET

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Mar 12	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Autovacuum actions (5 minutes period)

Analyzes per table

Key values

unknown (0) Main table analyzed (database )
0 analyzes Total

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

unknown (0) Main table vacuumed on database
0 vacuums Total

Chart
Table

Vacuums per tables

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
NO DATASET

Tuples removed per table

Key values

unknown (0) Main table with removed tuples on database
0 tuples Total removed

Chart
Table

Tuples removed per tables

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
NO DATASET

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
NO DATASET

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Mar 12	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0
	23	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
642 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		23	31s169ms	1s355ms
	tuple	23	31s169ms	1s355ms
ShareLock		619	16m17s	1s579ms
	transaction	619	16m17s	1s579ms
	Total	642	16m49s	1s571ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	642	16m49s	1s426ms	2s372ms	1s571ms	delete from ir_attachment where id in (...); DELETE FROM ir_attachment WHERE id IN (1233238); Date: 2023-03-12 23:53:12

Queries that waited the most

Rank	Wait time	Query
1	2s372ms	DELETE FROM ir_attachment WHERE id IN (1198052); [ Date: 2023-03-12 00:09:20 ]
2	2s338ms	DELETE FROM ir_attachment WHERE id IN (1230838); [ Date: 2023-03-12 22:11:38 ]
3	2s323ms	DELETE FROM ir_attachment WHERE id IN (1231934); [ Date: 2023-03-12 22:57:33 ]
4	2s323ms	DELETE FROM ir_attachment WHERE id IN (1202602); [ Date: 2023-03-12 03:09:06 ]
5	2s318ms	DELETE FROM ir_attachment WHERE id IN (1198832); [ Date: 2023-03-12 00:43:17 ]
6	2s313ms	DELETE FROM ir_attachment WHERE id IN (1226476); [ Date: 2023-03-12 19:13:53 ]
7	2s304ms	DELETE FROM ir_attachment WHERE id IN (1227271); [ Date: 2023-03-12 19:44:24 ]
8	2s304ms	DELETE FROM ir_attachment WHERE id IN (1223671); [ Date: 2023-03-12 17:18:18 ]
9	2s299ms	DELETE FROM ir_attachment WHERE id IN (1207274); [ Date: 2023-03-12 05:55:26 ]
10	2s294ms	DELETE FROM ir_attachment WHERE id IN (1224383); [ Date: 2023-03-12 17:47:19 ]
11	2s290ms	DELETE FROM ir_attachment WHERE id IN (1198802); [ Date: 2023-03-12 00:42:21 ]
12	2s251ms	DELETE FROM ir_attachment WHERE id IN (1200146); [ Date: 2023-03-12 01:37:02 ]
13	2s249ms	DELETE FROM ir_attachment WHERE id IN (1216442); [ Date: 2023-03-12 12:18:12 ]
14	2s246ms	DELETE FROM ir_attachment WHERE id IN (1227011); [ Date: 2023-03-12 19:35:31 ]
15	2s244ms	DELETE FROM ir_attachment WHERE id IN (1211040); [ Date: 2023-03-12 08:33:32 ]
16	2s244ms	DELETE FROM ir_attachment WHERE id IN (1202400); [ Date: 2023-03-12 03:01:57 ]
17	2s242ms	DELETE FROM ir_attachment WHERE id IN (1229765); [ Date: 2023-03-12 21:25:59 ]
18	2s225ms	DELETE FROM ir_attachment WHERE id IN (1224740); [ Date: 2023-03-12 18:01:50 ]
19	2s224ms	DELETE FROM ir_attachment WHERE id IN (1221317); [ Date: 2023-03-12 15:40:14 ]
20	2s210ms	DELETE FROM ir_attachment WHERE id IN (1203051); [ Date: 2023-03-12 03:28:06 ]

Queries by type

Key values

1,604 Total read queries
331 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	1,604	82.89%
INSERT	40	2.07%
UPDATE	216	11.16%
DELETE	4	0.21%
COPY FROM	0	0.00%
COPY TO	61	3.15%
CTE	10	0.52%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

unknown Main database
1,935 Requests
17m31s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	1,935	17m31s
	copy to	61	3m36s
	cte	10	1s259ms
	delete	4	21s525ms
	insert	40	59s722ms
	select	1,604	7m3s
	update	216	5m29s

Queries by user

Key values

unknown Main user
1,935 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	1,935	17m31s
	copy to	61	3m36s
	cte	10	1s259ms
	delete	4	21s525ms
	insert	40	59s722ms
	select	1,604	7m3s
	update	216	5m29s

Duration by user

Key values

17m31s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	1,935	17m31s
	copy to	61	3m36s
	cte	10	1s259ms
	delete	4	21s525ms
	insert	40	59s722ms
	select	1,604	7m3s
	update	216	5m29s

Queries by host

Key values

unknown Main host
1,935 Requests
17m31s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	1,935	17m31s
	copy to	61	3m36s
	cte	10	1s259ms
	delete	4	21s525ms
	insert	40	59s722ms
	select	1,604	7m3s
	update	216	5m29s

Queries by application

Key values

unknown Main application
1,935 Requests
17m31s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	1,935	17m31s
	copy to	61	3m36s
	cte	10	1s259ms
	delete	4	21s525ms
	insert	40	59s722ms
	select	1,604	7m3s
	update	216	5m29s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2023-03-12 14:52:46 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

1,350 100-500ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	1,350	69.77%
500-1000ms	382	19.74%
1000-10000ms	189	9.77%
> 10000ms	14	0.72%

Slowest individual queries

Rank	Duration	Query
1	38s863ms	COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout; [ Date: 2023-03-12 09:01:40 ]
2	26s776ms	COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) TO stdout; [ Date: 2023-03-12 09:00:53 ]
3	20s164ms	COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout; [ Date: 2023-03-12 09:03:14 ]
4	19s441ms	COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout; [ Date: 2023-03-12 09:02:01 ]
5	19s296ms	COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout; [ Date: 2023-03-12 09:02:20 ]
6	18s462ms	UPDATE "stock_move" SET "date" = '2023-03-12 12:56:59', "state" = 'done', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (305600, 305601, 310752, 310757, 305672, 311016, 305679, 306103, 306104, 311001, 311004); [ Date: 2023-03-12 12:57:19 ]
7	16s492ms	UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312821, 312822, 312823, 312824, 312825); [ Date: 2023-03-12 12:49:09 ]
8	16s393ms	UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312821, 312822, 312823, 312824, 312825); [ Date: 2023-03-12 12:49:35 ]
9	13s316ms	UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "is_done" = true, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312834, 312835, 312836, 312837, 312838, 312839, 312840, 312841); [ Date: 2023-03-12 16:02:29 ]
10	13s264ms	UPDATE "stock_move" SET "date" = '2023-03-12 16:01:59', "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312834, 312835, 312836, 312837, 312838, 312839, 312840, 312841); [ Date: 2023-03-12 16:02:13 ]
11	11s584ms	UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'incoming', "product_qty" = 12.0, "reference" = '13-T/IN/04179', "unit_factor" = 1.0, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312835, 312836, 312837, 312838, 312839, 312840, 312841); [ Date: 2023-03-12 16:01:39 ]
12	11s240ms	COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout; [ Date: 2023-03-12 09:03:43 ]
13	11s129ms	DELETE FROM account_move_line WHERE id IN (1801323, 1801324, 1801325, 1801326, 1801327, 1801328, 1801329, 1801330, 1801331, 1801332, 1801333, 1801334, 1801335, 1801336, 1801337, 1801338, 1801339, 1801340, 1801341, 1801342, 1801343, 1801344, 1801345, 1801346, 1801347, 1801348, 1801349, 1801350, 1801351, 1801352, 1801353, 1801354); [ Date: 2023-03-12 10:17:28 ]
14	10s10ms	UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312824); [ Date: 2023-03-12 12:49:49 ]
15	8s387ms	UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (217056, 217057, 217058, 217059, 217055); [ Date: 2023-03-12 15:36:24 ]
16	8s295ms	UPDATE "stock_move" SET "date" = '2023-03-12 15:35:57', "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312832, 312833, 312828, 312830, 312831); [ Date: 2023-03-12 15:36:06 ]
17	8s245ms	UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (217056, 217057, 217058, 217059, 217055); [ Date: 2023-03-12 15:36:35 ]
18	8s213ms	COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, apply_discount, discount_total, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id) TO stdout; [ Date: 2023-03-12 09:00:15 ]
19	8s197ms	UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312821, 312822, 312823, 312825, 312826); [ Date: 2023-03-12 12:49:18 ]
20	8s65ms	COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout; [ Date: 2023-03-12 09:00:24 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

1m58s

224

Details

519ms

587ms

530ms

select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 12	10	224	1m58s	530ms

select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 603 and ill.method not in (8, 7);

Date: 2023-03-12 10:35:15 Duration: 587ms
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 2583 and ill.method not in (8, 7);

Date: 2023-03-12 10:36:56 Duration: 581ms
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 2409 and ill.method not in (8, 7);

Date: 2023-03-12 10:35:03 Duration: 581ms

2

1m30s

703

Details

120ms

167ms

129ms

select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Mar 12	00	35	4s465ms	127ms
	01	24	3s62ms	127ms
	02	31	3s988ms	128ms
	03	26	3s368ms	129ms
	04	49	6s504ms	132ms
	05	34	4s385ms	128ms
	06	20	2s601ms	130ms
	07	24	3s122ms	130ms
	08	37	4s810ms	130ms
	09	21	2s703ms	128ms
	10	21	2s712ms	129ms
	11	23	2s932ms	127ms
	12	44	5s723ms	130ms
	13	28	3s601ms	128ms
	14	21	2s740ms	130ms
	15	43	5s605ms	130ms
	16	39	4s964ms	127ms
	17	26	3s340ms	128ms
	18	25	3s163ms	126ms
	19	29	3s755ms	129ms
	20	24	3s40ms	126ms
	21	23	2s916ms	126ms
	22	31	4s36ms	130ms
	23	25	3s242ms	129ms

SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-03-12 07:01:56 Duration: 167ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-03-12 14:57:47 Duration: 166ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_frontend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-eedcf2a/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-03-12 15:55:43 Duration: 165ms

3

51s769ms

9

Details

1s614ms

16s492ms

5s752ms

update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Mar 12	12	3	34s699ms	11s566ms
	13	3	5s87ms	1s695ms
	15	1	8s387ms	8s387ms
	17	2	3s594ms	1s797ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312821, 312822, 312823, 312824, 312825);

Date: 2023-03-12 12:49:09 Duration: 16s492ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312824);

Date: 2023-03-12 12:49:49 Duration: 10s10ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (217056, 217057, 217058, 217059, 217055);

Date: 2023-03-12 15:36:24 Duration: 8s387ms

4

43s766ms

12

Details

1s637ms

13s316ms

3s647ms

update "stock_move" set "current_warehouse_qty" = ?.?, "is_done" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Mar 12	12	7	18s537ms	2s648ms
	13	2	3s549ms	1s774ms
	15	2	8s364ms	4s182ms
	16	1	13s316ms	13s316ms

UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "is_done" = true, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312834, 312835, 312836, 312837, 312838, 312839, 312840, 312841);

Date: 2023-03-12 16:02:29 Duration: 13s316ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (310752, 310757, 305679);

Date: 2023-03-12 12:57:34 Duration: 5s246ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312832, 312833, 312828);

Date: 2023-03-12 15:36:11 Duration: 5s36ms

5

43s610ms

5

Details

1s686ms

18s462ms

8s722ms

update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 12	12	1	18s462ms	18s462ms
	13	2	3s588ms	1s794ms
	15	1	8s295ms	8s295ms
	16	1	13s264ms	13s264ms

UPDATE "stock_move" SET "date" = '2023-03-12 12:56:59', "state" = 'done', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (305600, 305601, 310752, 310757, 305672, 311016, 305679, 306103, 306104, 311001, 311004);

Date: 2023-03-12 12:57:19 Duration: 18s462ms
UPDATE "stock_move" SET "date" = '2023-03-12 16:01:59', "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312834, 312835, 312836, 312837, 312838, 312839, 312840, 312841);

Date: 2023-03-12 16:02:13 Duration: 13s264ms
UPDATE "stock_move" SET "date" = '2023-03-12 15:35:57', "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312832, 312833, 312828, 312830, 312831);

Date: 2023-03-12 15:36:06 Duration: 8s295ms

6

38s863ms

1

Details

38s863ms

copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	38s863ms	38s863ms

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

Date: 2023-03-12 09:01:40 Duration: 38s863ms

7

27s993ms

18

Details

1s434ms

1s678ms

1s555ms

insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, ?.?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 12	15	6	9s781ms	1s630ms
	16	12	18s211ms	1s517ms

INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 990, (now() at time zone 'UTC'), 990, (now() at time zone 'UTC'), false, NULL, 48, 1, '2023-01-20 17:00:00', '2023-01-20 17:00:00', '[308A-096-1103] 8X96 BH ST CHR', 66138, 461, 4, 'new_product', '[308A-096-1103] 8X96 BH ST CHR', 'T-01186', NULL, 91200, 353, 665.0, '0', 'make_to_stock', 245259, 1, '1.00', true, 45243, 10, 'draft', 45) RETURNING id;

Date: 2023-03-12 15:33:49 Duration: 1s678ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-10 20:21:41', '2023-03-10 20:21:41', '[334-2120] Plate', 66141, 437, 4, 'new_product', '[334-2120] Plate', 'I-01187', NULL, 91203, 329, 47.71, '0', 'make_to_stock', 217300, 1, '2.00', true, 45256, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 16:14:33 Duration: 1s676ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 990, (now() at time zone 'UTC'), 990, (now() at time zone 'UTC'), false, NULL, 48, 1, '2023-01-20 17:00:00', '2023-01-20 17:00:00', '[50-00083] 50-00083', 66138, 461, 4, 'new_product', '[50-00083] 50-00083', 'T-01186', NULL, 91200, 353, 105.0, '0', 'make_to_stock', 245262, 1, '2.00', true, 45246, 10, 'draft', 45) RETURNING id;

Date: 2023-03-12 15:34:49 Duration: 1s671ms

8

26s776ms

1

Details

26s776ms

copy public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) to stdout;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	26s776ms	26s776ms

COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) TO stdout;

Date: 2023-03-12 09:00:53 Duration: 26s776ms

9

24s639ms

2

Details

8s245ms

16s393ms

12s319ms

update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Mar 12	12	1	16s393ms	16s393ms
	15	1	8s245ms	8s245ms

UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312821, 312822, 312823, 312824, 312825);

Date: 2023-03-12 12:49:35 Duration: 16s393ms
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (217056, 217057, 217058, 217059, 217055);

Date: 2023-03-12 15:36:35 Duration: 8s245ms

10

22s119ms

13

Details

1s636ms

1s976ms

1s701ms

update "stock_move" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Mar 12	12	11	18s534ms	1s684ms
	13	2	3s584ms	1s792ms

UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (310757);

Date: 2023-03-12 12:54:20 Duration: 1s976ms
UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (306096);

Date: 2023-03-12 13:17:08 Duration: 1s913ms
UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312827);

Date: 2023-03-12 13:21:24 Duration: 1s671ms

11

20s164ms

1

Details

20s164ms

copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) to stdout;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	20s164ms	20s164ms

COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;

Date: 2023-03-12 09:03:14 Duration: 20s164ms

12

19s441ms

1

Details

19s441ms

copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	19s441ms	19s441ms

COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;

Date: 2023-03-12 09:02:01 Duration: 19s441ms

13

19s296ms

1

Details

19s296ms

copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	19s296ms	19s296ms

COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;

Date: 2023-03-12 09:02:20 Duration: 19s296ms

14

19s178ms

2

Details

8s49ms

11s129ms

9s589ms

delete from account_move_line where id in (...);

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Mar 12	10	2	19s178ms	9s589ms

DELETE FROM account_move_line WHERE id IN (1801323, 1801324, 1801325, 1801326, 1801327, 1801328, 1801329, 1801330, 1801331, 1801332, 1801333, 1801334, 1801335, 1801336, 1801337, 1801338, 1801339, 1801340, 1801341, 1801342, 1801343, 1801344, 1801345, 1801346, 1801347, 1801348, 1801349, 1801350, 1801351, 1801352, 1801353, 1801354);

Date: 2023-03-12 10:17:28 Duration: 11s129ms
DELETE FROM account_move_line WHERE id IN (1762369, 1762370, 1762371, 1762372, 1762373, 1762374, 1762375, 1762376, 1762377, 1762378, 1762379, 1762380, 1762381, 1762382, 1762383, 1762384, 1762385, 1762386, 1762387, 1762388, 1798025, 1798026, 1798027);

Date: 2023-03-12 10:29:13 Duration: 8s49ms

15

18s881ms

35

Details

530ms

557ms

539ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 12	03	17	9s160ms	538ms
	04	10	5s394ms	539ms
	12	2	1s67ms	533ms
	13	1	532ms	532ms
	16	5	2s726ms	545ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%KW08E14764RB1103%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%KW08-E14764RB-1103%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%KW08-E14764RB-1103%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:03:55 Duration: 557ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5003083%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-03083%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-03083%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:10:30 Duration: 548ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4715Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4715Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4715Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 03:32:06 Duration: 547ms

16

18s504ms

34

Details

529ms

566ms

544ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 12	13	5	2s708ms	541ms
	15	5	2s715ms	543ms
	16	16	8s705ms	544ms
	17	8	4s375ms	546ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%3381%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3381%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3381%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:01:29 Duration: 566ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%338193%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%338193%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%338193%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:01:31 Duration: 564ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%3342120%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%334-2120%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%334-2120%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:59:30 Duration: 559ms

17

18s30ms

11

Details

1s508ms

1s682ms

1s639ms

insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 12	12	11	18s30ms	1s639ms

INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-12 12:48:50', NULL, 5, 437, 'new_product', 'I-R00463', 'I-R00463', 43109, 91198, 330, '0', 'make_to_stock', 191078, 1, '1.00', true, 19158, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 12:48:52 Duration: 1s682ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-12 12:48:35', NULL, 5, 437, 'new_product', 'I-R00463', 'I-R00463', 43109, 91198, 330, '0', 'make_to_stock', 191092, 1, '3.00', true, 18886, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 12:48:37 Duration: 1s681ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-12 12:48:46', NULL, 5, 437, 'new_product', 'I-R00463', 'I-R00463', 43109, 91198, 330, '0', 'make_to_stock', 191096, 1, '2.00', true, 19157, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 12:48:48 Duration: 1s668ms

18

17s707ms

33

Details

515ms

555ms

536ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."is_core" is null or "product_product__product_tmpl_id"."is_core" = false)) and ("product_product__product_tmpl_id"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_ok" != false)) and (("product_product__product_tmpl_id"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 12	15	26	13s938ms	536ms
	16	7	3s769ms	538ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%500308%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-0308%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-0308%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:35:10 Duration: 555ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%7291%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7291%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7291%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:00:07 Duration: 544ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5003083%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-03083%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-03083%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:35:11 Duration: 544ms

19

16s353ms

10

Details

1s534ms

1s704ms

1s635ms

update "stock_move" set "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 12	12	10	16s353ms	1s635ms

UPDATE "stock_move" SET "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 1.0, "reference" = '10-I/OUT/05517', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312821);

Date: 2023-03-12 12:48:35 Duration: 1s704ms
UPDATE "stock_move" SET "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 2.0, "reference" = '10-I/OUT/05517', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312825);

Date: 2023-03-12 12:48:50 Duration: 1s688ms
UPDATE "stock_move" SET "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 1.0, "reference" = '10-I/OUT/05517', "scrapped" = false, "unit_factor" = 1.0, "weight" = '12.42', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312819);

Date: 2023-03-12 12:48:27 Duration: 1s659ms

20

15s77ms

9

Details

1s642ms

1s698ms

1s675ms

update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Mar 12	13	1	1s642ms	1s642ms
	16	7	11s774ms	1s682ms
	17	1	1s659ms	1s659ms

UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'incoming', "product_qty" = 2.0, "reference" = '10-I/IN/03335', "unit_factor" = 1.0, "weight" = '3.60', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312848);

Date: 2023-03-12 16:14:48 Duration: 1s698ms
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'incoming', "product_qty" = 2.0, "reference" = '10-I/IN/03335', "unit_factor" = 1.0, "weight" = '1.34', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312847);

Date: 2023-03-12 16:14:52 Duration: 1s696ms
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'incoming', "product_qty" = 2.0, "reference" = '10-I/IN/03335', "unit_factor" = 1.0, "weight" = '6.16', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312849);

Date: 2023-03-12 16:14:50 Duration: 1s682ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

703

Details

1m30s

120ms

167ms

129ms

select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 12	00	35	4s465ms	127ms
	01	24	3s62ms	127ms
	02	31	3s988ms	128ms
	03	26	3s368ms	129ms
	04	49	6s504ms	132ms
	05	34	4s385ms	128ms
	06	20	2s601ms	130ms
	07	24	3s122ms	130ms
	08	37	4s810ms	130ms
	09	21	2s703ms	128ms
	10	21	2s712ms	129ms
	11	23	2s932ms	127ms
	12	44	5s723ms	130ms
	13	28	3s601ms	128ms
	14	21	2s740ms	130ms
	15	43	5s605ms	130ms
	16	39	4s964ms	127ms
	17	26	3s340ms	128ms
	18	25	3s163ms	126ms
	19	29	3s755ms	129ms
	20	24	3s40ms	126ms
	21	23	2s916ms	126ms
	22	31	4s36ms	130ms
	23	25	3s242ms	129ms

SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-03-12 07:01:56 Duration: 167ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-03-12 14:57:47 Duration: 166ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/1/web.assets_frontend.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-eedcf2a/1/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-03-12 15:55:43 Duration: 165ms

2

224

Details

1m58s

519ms

587ms

530ms

select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Mar 12	10	224	1m58s	530ms

select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 603 and ill.method not in (8, 7);

Date: 2023-03-12 10:35:15 Duration: 587ms
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 2583 and ill.method not in (8, 7);

Date: 2023-03-12 10:36:56 Duration: 581ms
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 2409 and ill.method not in (8, 7);

Date: 2023-03-12 10:35:03 Duration: 581ms

3

96

Details

12s656ms

123ms

143ms

131ms

select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_tmpl_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Mar 12	12	10	1s339ms	133ms
	13	10	1s311ms	131ms
	14	6	801ms	133ms
	15	56	7s344ms	131ms
	16	12	1s597ms	133ms
	17	2	261ms	130ms

SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (248038)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-03-12 15:55:17 Duration: 143ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (185987, 185988, 185484, 183538, 187884, 188249, 188250, 195811, 190798, 214093, 214086, 215759)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-03-12 12:59:52 Duration: 141ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (217713)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-03-12 14:14:37 Duration: 140ms

4

93

Details

12s108ms

122ms

205ms

130ms

select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Mar 12	10	41	5s341ms	130ms
	12	2	258ms	129ms
	13	6	791ms	131ms
	15	32	4s123ms	128ms
	16	8	1s47ms	130ms
	17	4	546ms	136ms

SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (199667, 199700)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-03-12 10:37:02 Duration: 205ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (189319)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-03-12 17:20:41 Duration: 142ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (183416, 183419, 183424, 183427, 183437)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-03-12 10:37:06 Duration: 139ms

5

87

Details

11s195ms

120ms

148ms

128ms

select "account_move_line".id from "account_move_line" where ("account_move_line"."bal_core_bank_id" in (...)) and ("account_move_line"."company_id" is null or ("account_move_line"."company_id" in (...))) order by "account_move_line"."date" desc, "account_move_line"."move_name" desc, "account_move_line"."id";

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 12	02	5	654ms	130ms
	03	55	7s89ms	128ms
	04	27	3s450ms	127ms

SELECT "account_move_line".id FROM "account_move_line" WHERE ("account_move_line"."bal_core_bank_id" in (91437)) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id";

Date: 2023-03-12 02:43:53 Duration: 148ms
SELECT "account_move_line".id FROM "account_move_line" WHERE ("account_move_line"."bal_core_bank_id" in (53439)) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id";

Date: 2023-03-12 03:10:36 Duration: 144ms
SELECT "account_move_line".id FROM "account_move_line" WHERE ("account_move_line"."bal_core_bank_id" in (95164)) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id";

Date: 2023-03-12 03:25:57 Duration: 140ms

6

45

Details

5s671ms

120ms

132ms

126ms

select id from product_warehouse_inventory where product_id = ? and warehouse_id = ? and company_id = ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Mar 12	12	15	1s877ms	125ms
	13	1	127ms	127ms
	15	8	1s23ms	127ms
	16	18	2s266ms	125ms
	17	3	375ms	125ms

select id from product_warehouse_inventory where product_id = 217657 and warehouse_id = 42 and company_id = 1;

Date: 2023-03-12 16:14:38 Duration: 132ms
select id from product_warehouse_inventory where product_id = 197891 and warehouse_id = 42 and company_id = 1;

Date: 2023-03-12 12:47:56 Duration: 131ms
select id from product_warehouse_inventory where product_id = 217657 and warehouse_id = 42 and company_id = 1;

Date: 2023-03-12 16:13:51 Duration: 130ms

7

39

Details

6s437ms

161ms

194ms

165ms

select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 12	02	1	164ms	164ms
	03	4	659ms	164ms
	04	6	994ms	165ms
	12	6	972ms	162ms
	13	7	1s137ms	162ms
	15	5	821ms	164ms
	16	4	653ms	163ms
	17	6	1s33ms	172ms

SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%661%') OR unaccent (res_partner.display_name) ilike unaccent ('%661%') OR unaccent (res_partner.ref) ilike unaccent ('%661%') OR unaccent (res_partner.vat) ilike unaccent ('661')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%661%') desc, unaccent (res_partner.display_name);

Date: 2023-03-12 17:03:45 Duration: 194ms
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%661%') OR unaccent (res_partner.display_name) ilike unaccent ('%661%') OR unaccent (res_partner.ref) ilike unaccent ('%661%') OR unaccent (res_partner.vat) ilike unaccent ('661')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%661%') desc, unaccent (res_partner.display_name);

Date: 2023-03-12 17:03:59 Duration: 185ms
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%HIGH BAR%') OR unaccent (res_partner.display_name) ilike unaccent ('%HIGH BAR%') OR unaccent (res_partner.ref) ilike unaccent ('%HIGH BAR%') OR unaccent (res_partner.vat) ilike unaccent ('HIGHBAR')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%HIGH BAR%') desc, unaccent (res_partner.display_name);

Date: 2023-03-12 15:37:08 Duration: 167ms

8

35

Details

18s881ms

530ms

557ms

539ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 12	03	17	9s160ms	538ms
	04	10	5s394ms	539ms
	12	2	1s67ms	533ms
	13	1	532ms	532ms
	16	5	2s726ms	545ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%KW08E14764RB1103%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%KW08-E14764RB-1103%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%KW08-E14764RB-1103%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:03:55 Duration: 557ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5003083%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-03083%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-03083%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:10:30 Duration: 548ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4715Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4715Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4715Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 03:32:06 Duration: 547ms

9

34

Details

18s504ms

529ms

566ms

544ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Mar 12	13	5	2s708ms	541ms
	15	5	2s715ms	543ms
	16	16	8s705ms	544ms
	17	8	4s375ms	546ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%3381%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3381%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3381%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:01:29 Duration: 566ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%338193%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%338193%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%338193%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:01:31 Duration: 564ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%3342120%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%334-2120%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%334-2120%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:59:30 Duration: 559ms

10

33

Details

17s707ms

515ms

555ms

536ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."is_core" is null or "product_product__product_tmpl_id"."is_core" = false)) and ("product_product__product_tmpl_id"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_ok" != false)) and (("product_product__product_tmpl_id"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Mar 12	15	26	13s938ms	536ms
	16	7	3s769ms	538ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%500308%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-0308%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-0308%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:35:10 Duration: 555ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%7291%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7291%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7291%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:00:07 Duration: 544ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5003083%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-03083%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-03083%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:35:11 Duration: 544ms

11

23

Details

2s966ms

120ms

144ms

128ms

select "account_move_line".id from "account_move_line" where ("account_move_line"."bal_core_bank_id" in (...)) order by "account_move_line"."date" desc, "account_move_line"."move_name" desc, "account_move_line"."id";

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 12	03	13	1s659ms	127ms
	04	10	1s307ms	130ms

SELECT "account_move_line".id FROM "account_move_line" WHERE ("account_move_line"."bal_core_bank_id" in (95256)) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id";

Date: 2023-03-12 03:33:10 Duration: 144ms
SELECT "account_move_line".id FROM "account_move_line" WHERE ("account_move_line"."bal_core_bank_id" in (95130)) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id";

Date: 2023-03-12 04:04:57 Duration: 139ms
SELECT "account_move_line".id FROM "account_move_line" WHERE ("account_move_line"."bal_core_bank_id" in (95256)) ORDER BY "account_move_line"."date" DESC, "account_move_line"."move_name" DESC, "account_move_line"."id";

Date: 2023-03-12 03:31:06 Duration: 133ms

12

22

Details

3s673ms

164ms

193ms

166ms

select res_partner.id from "res_partner" where (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Mar 12	02	1	164ms	164ms
	03	14	2s347ms	167ms
	04	7	1s161ms	165ms

SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%B-INV-02418%') OR unaccent (res_partner.display_name) ilike unaccent ('%B-INV-02418%') OR unaccent (res_partner.ref) ilike unaccent ('%B-INV-02418%') OR unaccent (res_partner.vat) ilike unaccent ('B-INV-02418')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%B-INV-02418%') desc, unaccent (res_partner.display_name);

Date: 2023-03-12 03:14:35 Duration: 193ms
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%C-INV-02856 - 8%') OR unaccent (res_partner.display_name) ilike unaccent ('%C-INV-02856 - 8%') OR unaccent (res_partner.ref) ilike unaccent ('%C-INV-02856 - 8%') OR unaccent (res_partner.vat) ilike unaccent ('C-INV-02856-8')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%C-INV-02856 - 8%') desc, unaccent (res_partner.display_name);

Date: 2023-03-12 04:15:36 Duration: 168ms
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%C-INV-02874%') OR unaccent (res_partner.display_name) ilike unaccent ('%C-INV-02874%') OR unaccent (res_partner.ref) ilike unaccent ('%C-INV-02874%') OR unaccent (res_partner.vat) ilike unaccent ('C-INV-02874')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%C-INV-02874%') desc, unaccent (res_partner.display_name);

Date: 2023-03-12 03:49:43 Duration: 166ms

13

19

Details

12s950ms

672ms

700ms

681ms

select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Mar 12	13	3	2s53ms	684ms
	14	12	8s147ms	678ms
	15	2	1s351ms	675ms
	16	2	1s398ms	699ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%308A-096-1103%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%308A-096-1103%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%308A-096-1103%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%308A-096-1103%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-03-12 16:09:19 Duration: 700ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%308A-096-1103%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%308A-096-1103%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%308A-096-1103%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%308A-096-1103%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-03-12 16:05:40 Duration: 698ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%al919338%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%al919338%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%al919338%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%al919338%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-03-12 13:47:15 Duration: 687ms

14

18

Details

27s993ms

1s434ms

1s678ms

1s555ms

insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, ?.?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Mar 12	15	6	9s781ms	1s630ms
	16	12	18s211ms	1s517ms

INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 990, (now() at time zone 'UTC'), 990, (now() at time zone 'UTC'), false, NULL, 48, 1, '2023-01-20 17:00:00', '2023-01-20 17:00:00', '[308A-096-1103] 8X96 BH ST CHR', 66138, 461, 4, 'new_product', '[308A-096-1103] 8X96 BH ST CHR', 'T-01186', NULL, 91200, 353, 665.0, '0', 'make_to_stock', 245259, 1, '1.00', true, 45243, 10, 'draft', 45) RETURNING id;

Date: 2023-03-12 15:33:49 Duration: 1s678ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-10 20:21:41', '2023-03-10 20:21:41', '[334-2120] Plate', 66141, 437, 4, 'new_product', '[334-2120] Plate', 'I-01187', NULL, 91203, 329, 47.71, '0', 'make_to_stock', 217300, 1, '2.00', true, 45256, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 16:14:33 Duration: 1s676ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 990, (now() at time zone 'UTC'), 990, (now() at time zone 'UTC'), false, NULL, 48, 1, '2023-01-20 17:00:00', '2023-01-20 17:00:00', '[50-00083] 50-00083', 66138, 461, 4, 'new_product', '[50-00083] 50-00083', 'T-01186', NULL, 91200, 353, 105.0, '0', 'make_to_stock', 245262, 1, '2.00', true, 45246, 10, 'draft', 45) RETURNING id;

Date: 2023-03-12 15:34:49 Duration: 1s671ms

15

17

Details

2s210ms

127ms

133ms

130ms

select "product_warehouse_inventory".id from "product_warehouse_inventory" where (("product_warehouse_inventory"."warehouse_id" = ?) and ("product_warehouse_inventory"."product_id" = ?)) order by "product_warehouse_inventory"."warehouse_name" limit ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 12	13	17	2s210ms	130ms

SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 35) AND ("product_warehouse_inventory"."product_id" = 182530)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;

Date: 2023-03-12 13:42:50 Duration: 133ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 35) AND ("product_warehouse_inventory"."product_id" = 195429)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;

Date: 2023-03-12 13:42:49 Duration: 132ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 35) AND ("product_warehouse_inventory"."product_id" = 209326)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;

Date: 2023-03-12 13:42:50 Duration: 131ms

16

Details

4s302ms

200ms

1s24ms

268ms

update "sale_order_line" set "invoice_status" = ?, "open_qty_fil" = ?.?, "qty_delivered" = ?, "qty_to_invoice" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 12	12	10	2s260ms	226ms
	13	5	1s18ms	203ms
	15	1	1s24ms	1s24ms

UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (57480, 57481, 57483, 57484, 57485);

Date: 2023-03-12 15:36:26 Duration: 1s24ms
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '1.00', "qty_to_invoice" = '1.00', "untaxed_amount_to_invoice" = '51.75', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (101507, 101508);

Date: 2023-03-12 12:57:21 Duration: 408ms
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 0.0, "qty_delivered" = '2.00', "qty_to_invoice" = '2.00', "untaxed_amount_to_invoice" = '291.86', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (101695);

Date: 2023-03-12 12:57:22 Duration: 208ms

17

15

Details

1s991ms

130ms

136ms

132ms

update "stock_quant" set "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 12	12	6	793ms	132ms
	13	2	269ms	134ms
	15	5	661ms	132ms
	17	2	267ms	133ms

UPDATE "stock_quant" SET "reserved_quantity" = 3.0, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (224227);

Date: 2023-03-12 17:24:45 Duration: 136ms
UPDATE "stock_quant" SET "reserved_quantity" = 8.0, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (239789);

Date: 2023-03-12 13:16:34 Duration: 135ms
UPDATE "stock_quant" SET "reserved_quantity" = 2.0, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (191154);

Date: 2023-03-12 13:19:39 Duration: 133ms

18

14

Details

3s88ms

203ms

415ms

220ms

update "sale_order_line" set "invoice_status" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 12	12	11	2s476ms	225ms
	13	3	612ms	204ms

UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '51.75', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (101507, 101508);

Date: 2023-03-12 12:59:54 Duration: 415ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '148.74', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (101696);

Date: 2023-03-12 12:59:56 Duration: 206ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '85.80', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (101539);

Date: 2023-03-12 12:59:56 Duration: 206ms

19

14

Details

2s855ms

200ms

207ms

203ms

update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 12	13	5	1s20ms	204ms
	16	8	1s629ms	203ms
	17	1	205ms	205ms

UPDATE "sale_order_line" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (104952);

Date: 2023-03-12 16:13:30 Duration: 207ms
UPDATE "sale_order_line" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (104953);

Date: 2023-03-12 16:13:30 Duration: 206ms
UPDATE "sale_order_line" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (104956);

Date: 2023-03-12 17:24:39 Duration: 205ms

20

13

Details

22s119ms

1s636ms

1s976ms

1s701ms

update "stock_move" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Mar 12	12	11	18s534ms	1s684ms
	13	2	3s584ms	1s792ms

UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (310757);

Date: 2023-03-12 12:54:20 Duration: 1s976ms
UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (306096);

Date: 2023-03-12 13:17:08 Duration: 1s913ms
UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312827);

Date: 2023-03-12 13:21:24 Duration: 1s671ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

38s863ms

1

Details

38s863ms

copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	38s863ms	38s863ms

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

Date: 2023-03-12 09:01:40 Duration: 38s863ms

2

26s776ms

1

Details

26s776ms

copy public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) to stdout;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	26s776ms	26s776ms

COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty, notes) TO stdout;

Date: 2023-03-12 09:00:53 Duration: 26s776ms

3

20s164ms

1

Details

20s164ms

copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) to stdout;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	20s164ms	20s164ms

COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;

Date: 2023-03-12 09:03:14 Duration: 20s164ms

4

19s441ms

1

Details

19s441ms

copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	19s441ms	19s441ms

COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;

Date: 2023-03-12 09:02:01 Duration: 19s441ms

5

19s296ms

1

Details

19s296ms

copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 12	09	1	19s296ms	19s296ms

COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;

Date: 2023-03-12 09:02:20 Duration: 19s296ms

6

8s245ms

16s393ms

12s319ms

2

Details

24s639ms

update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Mar 12	12	1	16s393ms	16s393ms
	15	1	8s245ms	8s245ms

UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312821, 312822, 312823, 312824, 312825);

Date: 2023-03-12 12:49:35 Duration: 16s393ms
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (217056, 217057, 217058, 217059, 217055);

Date: 2023-03-12 15:36:35 Duration: 8s245ms

7

8s49ms

11s129ms

9s589ms

2

Details

19s178ms

delete from account_move_line where id in (...);

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 12	10	2	19s178ms	9s589ms

DELETE FROM account_move_line WHERE id IN (1801323, 1801324, 1801325, 1801326, 1801327, 1801328, 1801329, 1801330, 1801331, 1801332, 1801333, 1801334, 1801335, 1801336, 1801337, 1801338, 1801339, 1801340, 1801341, 1801342, 1801343, 1801344, 1801345, 1801346, 1801347, 1801348, 1801349, 1801350, 1801351, 1801352, 1801353, 1801354);

Date: 2023-03-12 10:17:28 Duration: 11s129ms
DELETE FROM account_move_line WHERE id IN (1762369, 1762370, 1762371, 1762372, 1762373, 1762374, 1762375, 1762376, 1762377, 1762378, 1762379, 1762380, 1762381, 1762382, 1762383, 1762384, 1762385, 1762386, 1762387, 1762388, 1798025, 1798026, 1798027);

Date: 2023-03-12 10:29:13 Duration: 8s49ms

8

1s686ms

18s462ms

8s722ms

5

Details

43s610ms

update "stock_move" set "date" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 12	12	1	18s462ms	18s462ms
	13	2	3s588ms	1s794ms
	15	1	8s295ms	8s295ms
	16	1	13s264ms	13s264ms

UPDATE "stock_move" SET "date" = '2023-03-12 12:56:59', "state" = 'done', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (305600, 305601, 310752, 310757, 305672, 311016, 305679, 306103, 306104, 311001, 311004);

Date: 2023-03-12 12:57:19 Duration: 18s462ms
UPDATE "stock_move" SET "date" = '2023-03-12 16:01:59', "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312834, 312835, 312836, 312837, 312838, 312839, 312840, 312841);

Date: 2023-03-12 16:02:13 Duration: 13s264ms
UPDATE "stock_move" SET "date" = '2023-03-12 15:35:57', "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312832, 312833, 312828, 312830, 312831);

Date: 2023-03-12 15:36:06 Duration: 8s295ms

9

1s614ms

16s492ms

5s752ms

9

Details

51s769ms

update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Mar 12	12	3	34s699ms	11s566ms
	13	3	5s87ms	1s695ms
	15	1	8s387ms	8s387ms
	17	2	3s594ms	1s797ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312821, 312822, 312823, 312824, 312825);

Date: 2023-03-12 12:49:09 Duration: 16s492ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312816, 312817, 312818, 312819, 312820, 312824);

Date: 2023-03-12 12:49:49 Duration: 10s10ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (217056, 217057, 217058, 217059, 217055);

Date: 2023-03-12 15:36:24 Duration: 8s387ms

10

1s637ms

13s316ms

3s647ms

12

Details

43s766ms

update "stock_move" set "current_warehouse_qty" = ?.?, "is_done" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Mar 12	12	7	18s537ms	2s648ms
	13	2	3s549ms	1s774ms
	15	2	8s364ms	4s182ms
	16	1	13s316ms	13s316ms

UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "is_done" = true, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312834, 312835, 312836, 312837, 312838, 312839, 312840, 312841);

Date: 2023-03-12 16:02:29 Duration: 13s316ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (310752, 310757, 305679);

Date: 2023-03-12 12:57:34 Duration: 5s246ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "is_done" = true, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (312832, 312833, 312828);

Date: 2023-03-12 15:36:11 Duration: 5s36ms

11

1s636ms

1s976ms

1s701ms

13

Details

22s119ms

update "stock_move" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 12	12	11	18s534ms	1s684ms
	13	2	3s584ms	1s792ms

UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (310757);

Date: 2023-03-12 12:54:20 Duration: 1s976ms
UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (306096);

Date: 2023-03-12 13:17:08 Duration: 1s913ms
UPDATE "stock_move" SET "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312827);

Date: 2023-03-12 13:21:24 Duration: 1s671ms

12

1s642ms

1s698ms

1s675ms

9

Details

15s77ms

update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Mar 12	13	1	1s642ms	1s642ms
	16	7	11s774ms	1s682ms
	17	1	1s659ms	1s659ms

UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'incoming', "product_qty" = 2.0, "reference" = '10-I/IN/03335', "unit_factor" = 1.0, "weight" = '3.60', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312848);

Date: 2023-03-12 16:14:48 Duration: 1s698ms
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'incoming', "product_qty" = 2.0, "reference" = '10-I/IN/03335', "unit_factor" = 1.0, "weight" = '1.34', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312847);

Date: 2023-03-12 16:14:52 Duration: 1s696ms
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'incoming', "product_qty" = 2.0, "reference" = '10-I/IN/03335', "unit_factor" = 1.0, "weight" = '6.16', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312849);

Date: 2023-03-12 16:14:50 Duration: 1s682ms

13

1s508ms

1s682ms

1s639ms

11

Details

18s30ms

insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Mar 12	12	11	18s30ms	1s639ms

INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-12 12:48:50', NULL, 5, 437, 'new_product', 'I-R00463', 'I-R00463', 43109, 91198, 330, '0', 'make_to_stock', 191078, 1, '1.00', true, 19158, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 12:48:52 Duration: 1s682ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-12 12:48:35', NULL, 5, 437, 'new_product', 'I-R00463', 'I-R00463', 43109, 91198, 330, '0', 'make_to_stock', 191092, 1, '3.00', true, 18886, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 12:48:37 Duration: 1s681ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "repair_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-12 12:48:46', NULL, 5, 437, 'new_product', 'I-R00463', 'I-R00463', 43109, 91198, 330, '0', 'make_to_stock', 191096, 1, '2.00', true, 19157, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 12:48:48 Duration: 1s668ms

14

1s534ms

1s704ms

1s635ms

10

Details

16s353ms

update "stock_move" set "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Mar 12	12	10	16s353ms	1s635ms

UPDATE "stock_move" SET "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 1.0, "reference" = '10-I/OUT/05517', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312821);

Date: 2023-03-12 12:48:35 Duration: 1s704ms
UPDATE "stock_move" SET "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 2.0, "reference" = '10-I/OUT/05517', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312825);

Date: 2023-03-12 12:48:50 Duration: 1s688ms
UPDATE "stock_move" SET "is_done" = false, "picking_code" = 'outgoing', "product_qty" = 1.0, "reference" = '10-I/OUT/05517', "scrapped" = false, "unit_factor" = 1.0, "weight" = '12.42', "write_uid" = 1004, "write_date" = (now() at time zone 'UTC') WHERE id IN (312819);

Date: 2023-03-12 12:48:27 Duration: 1s659ms

15

1s434ms

1s678ms

1s555ms

18

Details

27s993ms

insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, null, ?, ?, ?.?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 12	15	6	9s781ms	1s630ms
	16	12	18s211ms	1s517ms

INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 990, (now() at time zone 'UTC'), 990, (now() at time zone 'UTC'), false, NULL, 48, 1, '2023-01-20 17:00:00', '2023-01-20 17:00:00', '[308A-096-1103] 8X96 BH ST CHR', 66138, 461, 4, 'new_product', '[308A-096-1103] 8X96 BH ST CHR', 'T-01186', NULL, 91200, 353, 665.0, '0', 'make_to_stock', 245259, 1, '1.00', true, 45243, 10, 'draft', 45) RETURNING id;

Date: 2023-03-12 15:33:49 Duration: 1s678ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1004, (now() at time zone 'UTC'), 1004, (now() at time zone 'UTC'), false, NULL, 45, 1, '2023-03-10 20:21:41', '2023-03-10 20:21:41', '[334-2120] Plate', 66141, 437, 4, 'new_product', '[334-2120] Plate', 'I-01187', NULL, 91203, 329, 47.71, '0', 'make_to_stock', 217300, 1, '2.00', true, 45256, 10, 'draft', 42) RETURNING id;

Date: 2023-03-12 16:14:33 Duration: 1s676ms
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "date_deadline", "description_picking", "group_id", "location_dest_id", "location_id", "move_options", "name", "origin", "partner_id", "picking_id", "picking_type_id", "price_unit", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "purchase_line_id", "sequence", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 990, (now() at time zone 'UTC'), 990, (now() at time zone 'UTC'), false, NULL, 48, 1, '2023-01-20 17:00:00', '2023-01-20 17:00:00', '[50-00083] 50-00083', 66138, 461, 4, 'new_product', '[50-00083] 50-00083', 'T-01186', NULL, 91200, 353, 105.0, '0', 'make_to_stock', 245262, 1, '2.00', true, 45246, 10, 'draft', 45) RETURNING id;

Date: 2023-03-12 15:34:49 Duration: 1s671ms

16

672ms

700ms

681ms

19

Details

12s950ms

select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 12	13	3	2s53ms	684ms
	14	12	8s147ms	678ms
	15	2	1s351ms	675ms
	16	2	1s398ms	699ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%308A-096-1103%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%308A-096-1103%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%308A-096-1103%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%308A-096-1103%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-03-12 16:09:19 Duration: 700ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%308A-096-1103%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%308A-096-1103%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%308A-096-1103%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%308A-096-1103%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-03-12 16:05:40 Duration: 698ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%al919338%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%al919338%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%al919338%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%al919338%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-03-12 13:47:15 Duration: 687ms

17

529ms

566ms

544ms

34

Details

18s504ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 12	13	5	2s708ms	541ms
	15	5	2s715ms	543ms
	16	16	8s705ms	544ms
	17	8	4s375ms	546ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%3381%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3381%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%3381%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:01:29 Duration: 566ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%338193%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%338193%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%338193%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:01:31 Duration: 564ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%3342120%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%334-2120%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%334-2120%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:59:30 Duration: 559ms

18

530ms

557ms

539ms

35

Details

18s881ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 12	03	17	9s160ms	538ms
	04	10	5s394ms	539ms
	12	2	1s67ms	533ms
	13	1	532ms	532ms
	16	5	2s726ms	545ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%KW08E14764RB1103%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%KW08-E14764RB-1103%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%KW08-E14764RB-1103%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:03:55 Duration: 557ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5003083%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-03083%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-03083%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:10:30 Duration: 548ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4715Q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4715Q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%4715Q%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 03:32:06 Duration: 547ms

19

515ms

555ms

536ms

33

Details

17s707ms

select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."is_core" is null or "product_product__product_tmpl_id"."is_core" = false)) and ("product_product__product_tmpl_id"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_ok" != false)) and (("product_product__product_tmpl_id"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 12	15	26	13s938ms	536ms
	16	7	3s769ms	538ms

SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%500308%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-0308%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-0308%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:35:10 Duration: 555ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%7291%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%7291%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%7291%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 16:00:07 Duration: 544ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%5003083%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%50-03083%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%50-03083%'))) AND ("product_product__product_tmpl_id"."is_core" IS NULL or "product_product__product_tmpl_id"."is_core" = false)) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-03-12 15:35:11 Duration: 544ms

20

519ms

587ms

530ms

224

Details

1m58s

select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Mar 12	10	224	1m58s	530ms

select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 603 and ill.method not in (8, 7);

Date: 2023-03-12 10:35:15 Duration: 587ms
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 2583 and ill.method not in (8, 7);

Date: 2023-03-12 10:36:56 Duration: 581ms
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 2409 and ill.method not in (8, 7);

Date: 2023-03-12 10:35:03 Duration: 581ms

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
NO DATASET

Log levels

Key values

10,437 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	1,238	11.86%
DETAIL	642	6.15%
ERROR	2,669	25.57%
LOG	2,577	24.69%
STATEMENT	3,311	31.72%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
2669 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

1,674

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Mar 12	00	66
	01	62
	02	91
	03	76
	04	111
	05	85
	06	62
	07	64
	08	66
	09	54
	10	69
	11	74
	12	65
	13	71
	14	72
	15	59
	16	66
	17	69
	18	70
	19	73
	20	63
	21	70
	22	59
	23	57

ERROR: could not serialize access due to concurrent delete

2

619

Details

LOG: process ... still waiting for ShareLock on transaction ... after ... ms

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Mar 12	00	25
	01	26
	02	38
	03	25
	04	44
	05	29
	06	27
	07	18
	08	24
	09	26
	10	24
	11	27
	12	26
	13	27
	14	26
	15	21
	16	27
	17	26
	18	21
	19	28
	20	23
	21	28
	22	15
	23	18

ERROR: process 985563 still waiting for ShareLock on transaction 100047869 after 1000.038 ms
ERROR: process 985571 still waiting for ShareLock on transaction 100047899 after 1000.059 ms
ERROR: process 986878 still waiting for ShareLock on transaction 100047994 after 1000.041 ms

3

185

Details

ERROR: could not obtain lock on row in relation "..."

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Mar 12	00	6
	01	7
	02	6
	03	4
	04	8
	05	1
	06	8
	07	35
	08	7
	09	4
	10	26
	11	4
	12	3
	13	7
	14	6
	15	7
	16	6
	17	7
	18	6
	19	5
	20	8
	21	3
	22	7
	23	4

ERROR: could not obtain lock on row in relation "ir_cron"

4

120

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Mar 12	00	1
	01	1
	03	5
	04	2
	05	21
	07	1
	08	14
	09	8
	10	34
	11	11
	12	1
	13	4
	14	1
	15	1
	18	1
	21	1
	22	3
	23	10

ERROR: could not serialize access due to concurrent update

5

47

Details

ERROR: current transaction is aborted, commands ignored until end of transaction block

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Mar 12	00	1
	01	1
	03	3
	04	5
	05	5
	07	1
	08	2
	11	1
	12	2
	13	3
	14	8
	15	2
	16	2
	17	1
	18	1
	19	3
	20	2
	21	1
	22	1
	23	2

ERROR: current transaction is aborted, commands ignored until end of transaction block

6

23

Details

LOG: process ... still waiting for AccessExclusiveLock on tuple (...) of relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Mar 12	00	1
	01	3
	02	4
	03	2
	04	2
	05	1
	08	1
	09	1
	11	1
	12	1
	13	1
	14	2
	17	1
	18	1
	19	1

ERROR: process 1365573 still waiting for AccessExclusiveLock on tuple (3082,10) of relation 43604 of database 65946 after 1000.044 ms
ERROR: process 985562 still waiting for AccessExclusiveLock on tuple (3103,10) of relation 43604 of database 65946 after 1000.042 ms
ERROR: process 985961 still waiting for AccessExclusiveLock on tuple (3252,12) of relation 43604 of database 65946 after 1000.050 ms

7

1

Details

ERROR: syntax error at or near "..."

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Mar 12	17	1

ERROR: syntax error at or near "N" at character 140

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 database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoint write buffers (5 minutes period)

Checkpoints Wal files

Key values

Checkpoint Wal files usage (5 minutes period)

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Checkpoint causes

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables