pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Feb 17 00:50:17 2024
Log file: /var/log/postgresql/postgresql-14-main.log
Parsed 296,585 log entries in 16s
Log start from 2024-02-16 00:00:00 to 2024-02-16 23:59:26

Global Stats

1,212 Number of unique normalized queries
100,484 Number of queries
9h48m29s Total query duration
2024-02-16 00:00:00 First query
2024-02-16 23:59:26 Last query
62 queries/s at 2024-02-16 15:19:04 Query peak

9h48m29s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
9h48m29s Execute total duration

1,448 Number of events
13 Number of unique normalized events
669 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
100,484 Average queries per session
9h48m29s 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

62 queries/s Query Peak
2024-02-16 15:19:04 Date

SELECT Traffic

Key values

62 queries/s Query Peak
2024-02-16 15:19:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

12 queries/s Query Peak
2024-02-16 20:00:26 Date

Queries duration

Key values

9h48m29s 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)
Feb 16	00	837	120ms	891ms	238ms	8s723ms	18s674ms	23s827ms
	01	662	120ms	6s572ms	282ms	10s466ms	15s549ms	20s981ms
	02	652	120ms	800ms	208ms	4s675ms	10s243ms	13s578ms
	03	463	120ms	1s7ms	160ms	2s34ms	3s91ms	12s445ms
	04	565	120ms	1s405ms	260ms	6s878ms	11s771ms	29s54ms
	05	760	0ms	1s228ms	158ms	3s177ms	4s696ms	14s408ms
	06	765	120ms	13s228ms	283ms	12s144ms	28s132ms	35s2ms
	07	617	120ms	1s930ms	196ms	2s887ms	13s191ms	21s53ms
	08	366	120ms	726ms	250ms	7s94ms	9s984ms	14s420ms
	09	1,138	120ms	3m51s	840ms	1m3s	1m37s	3m52s
	10	786	120ms	1s583ms	212ms	5s318ms	8s810ms	23s213ms
	11	788	0ms	2s697ms	229ms	6s992ms	8s792ms	24s954ms
	12	4,963	120ms	5s976ms	313ms	1m3s	1m14s	2m27s
	13	13,047	120ms	3m23s	414ms	2m22s	3m4s	5m
	14	12,439	120ms	19s271ms	354ms	1m53s	2m15s	3m9s
	15	11,218	120ms	1m17s	353ms	2m8s	2m23s	3m7s
	16	13,003	120ms	19s281ms	361ms	2m25s	2m55s	3m51s
	17	9,449	120ms	39s595ms	367ms	1m53s	2m14s	3m
	18	8,995	120ms	2m26s	344ms	1m30s	1m35s	3m22s
	19	8,342	120ms	14s941ms	302ms	1m7s	2m16s	2m49s
	20	6,871	120ms	19s278ms	337ms	1m6s	1m36s	2m19s
	21	2,546	120ms	18s132ms	335ms	33s786ms	42s594ms	1m2s
	22	555	120ms	1s131ms	236ms	9s282ms	10s767ms	16s909ms
	23	657	120ms	23s429ms	401ms	11s783ms	28s181ms	35s38ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 16	00	837	0	238ms	3s699ms	8s723ms	20s849ms
	01	621	0	265ms	2s985ms	9s585ms	13s782ms
	02	633	0	206ms	2s241ms	4s675ms	13s546ms
	03	463	0	160ms	1s612ms	2s34ms	3s219ms
	04	563	0	259ms	2s682ms	6s878ms	13s316ms
	05	760	0	158ms	2s748ms	3s177ms	10s369ms
	06	745	0	166ms	1s639ms	9s104ms	12s355ms
	07	615	0	195ms	1s708ms	2s887ms	14s842ms
	08	366	0	250ms	1s261ms	7s94ms	13s603ms
	09	1,035	98	842ms	9s910ms	1m	1m49s
	10	732	0	194ms	2s521ms	4s528ms	10s808ms
	11	788	0	229ms	4s238ms	6s992ms	11s128ms
	12	4,286	0	297ms	34s495ms	49s529ms	1m6s
	13	10,975	0	376ms	1m33s	1m48s	2m40s
	14	10,035	0	321ms	1m22s	1m32s	1m57s
	15	9,391	0	301ms	1m5s	1m45s	2m5s
	16	10,694	0	325ms	1m37s	2m1s	2m29s
	17	7,865	0	336ms	1m3s	1m28s	2m7s
	18	7,673	0	279ms	52s566ms	1m11s	1m21s
	19	7,050	0	261ms	40s834ms	51s292ms	2m7s
	20	5,703	0	307ms	48s974ms	58s146ms	1m38s
	21	2,187	0	307ms	18s33ms	28s952ms	41s412ms
	22	542	0	234ms	2s506ms	9s282ms	14s952ms
	23	638	0	227ms	3s197ms	8s101ms	11s783ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 16	00	0	0	0	0ms	0ms	0ms	0ms
	01	6	35	0	543ms	0ms	0ms	1s3ms
	02	0	19	0	259ms	0ms	0ms	1s92ms
	03	0	0	0	0ms	0ms	0ms	0ms
	04	0	2	0	328ms	0ms	0ms	0ms
	05	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	20	4s620ms	0ms	0ms	17s636ms
	07	0	2	0	328ms	0ms	0ms	0ms
	08	0	0	0	0ms	0ms	0ms	0ms
	09	0	5	0	472ms	0ms	0ms	0ms
	10	0	52	1	469ms	0ms	0ms	3s409ms
	11	0	0	0	0ms	0ms	0ms	0ms
	12	31	633	12	413ms	4s682ms	7s495ms	15s861ms
	13	109	1,893	61	621ms	16s185ms	23s597ms	54s279ms
	14	103	2,246	51	494ms	16s603ms	30s601ms	44s632ms
	15	103	1,686	32	625ms	15s783ms	22s763ms	1m3s
	16	57	2,211	38	530ms	17s660ms	27s798ms	55s114ms
	17	32	1,511	36	521ms	9s399ms	24s10ms	46s176ms
	18	30	1,247	42	722ms	14s793ms	21s747ms	46s386ms
	19	40	1,210	38	525ms	9s535ms	14s941ms	35s472ms
	20	20	1,130	16	480ms	8s197ms	14s707ms	38s580ms
	21	3	349	6	507ms	2s884ms	5s124ms	11s561ms
	22	0	12	1	351ms	0ms	0ms	825ms
	23	0	0	19	6s275ms	0ms	0ms	25s222ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Feb 16	00	0	0.00	0.00%
	01	0	0.00	0.00%
	02	0	0.00	0.00%
	03	0	0.00	0.00%
	04	0	0.00	0.00%
	05	4	4.00	0.00%
	06	0	0.00	0.00%
	07	0	0.00	0.00%
	08	0	0.00	0.00%
	09	0	0.00	0.00%
	10	0	0.00	0.00%
	11	0	0.00	0.00%
	12	0	0.00	0.00%
	13	0	0.00	0.00%
	14	0	0.00	0.00%
	15	0	0.00	0.00%
	16	0	0.00	0.00%
	17	0	0.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	0	0.00	0.00%
	21	0	0.00	0.00%
	22	0	0.00	0.00%
	23	0	0.00	0.00%

Day	Hour	Average / Second
Feb 16	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
Feb 16	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
Feb 16	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
Feb 16	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)
Feb 16	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
Feb 16	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
Feb 16	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
Feb 16	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
55 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		4	10s749ms	2s687ms
	tuple	4	10s749ms	2s687ms
ShareLock		51	5m50s	6s869ms
	transaction	51	5m50s	6s869ms
	Total	55	6m1s	6s565ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	25	2m54s	1s277ms	1m44s	6s994ms	update account_move set write_date = write_date where id = ( select id from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) and id != ? and sequence_prefix = ( select sequence_prefix from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) and id != ? order by id desc limit ?) order by sequence_number desc limit ?) returning name; UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1210602 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1210602 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; Date: 2024-02-16 13:55:46
2	1	52s232ms	52s232ms	52s232ms	52s232ms	update "account_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "account_move" SET "state" = 'draft', "write_uid" = 1046, "write_date" = (now() at time zone 'UTC') WHERE id IN (1209675); Date: 2024-02-16 13:52:43
3	8	27s978ms	1s352ms	6s51ms	3s497ms	update "account_move" set "message_main_attachment_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "account_move" SET "message_main_attachment_id" = 5077642, "write_uid" = 961, "write_date" = (now() at time zone 'UTC') WHERE id IN (1210666); Date: 2024-02-16 14:05:32
4	1	25s181ms	25s181ms	25s181ms	25s181ms	update "bus_presence" set "last_poll" = ?, "last_presence" = ? where id in (...); UPDATE "bus_presence" SET "last_poll" = '2024-02-16 16:35:41', "last_presence" = '2024-02-16 16:35:27.369786' WHERE id IN (42); Date: 2024-02-16 16:36:06
5	5	20s919ms	2s883ms	5s600ms	4s183ms	update "sale_order" set "carrier_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order" SET "carrier_id" = NULL, "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:12:06 UPDATE "sale_order" SET "carrier_id" = NULL, "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:11:33
6	4	13s676ms	2s854ms	4s103ms	3s419ms	update "sale_order_line" set "price_tax" = ?.?, "price_total" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order_line" SET "price_tax" = 0.0, "price_total" = '158.16', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (341454); Date: 2024-02-16 18:11:53 UPDATE "sale_order_line" SET "price_tax" = 0.0, "price_total" = '32.44', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (331020); Date: 2024-02-16 18:11:40 UPDATE "sale_order_line" SET "price_tax" = 0.0, "price_total" = '158.16', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (341454); Date: 2024-02-16 18:11:59
7	1	10s789ms	10s789ms	10s789ms	10s789ms	insert into "sale_advance_payment_inv" ("id", "create_uid", "create_date", "write_uid", "write_date", "advance_payment_method", "amount", "amount_taken", "count", "currency_id", "deduct_down_payments", "deposit_account_id", "due_amount", "fixed_amount", "has_down_payments", "is_cash_sale_order", "is_immediate_payment", "is_self_used", "journal_id", "partner_id", "payment_details", "payment_method_id", "payment_term_id", "product_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), ?, ?, ?, ?, ?, true, ?, ?, ?, false, false, false, false, null, ?, null, null, ?, ?) returning id; INSERT INTO "sale_advance_payment_inv" ("id", "create_uid", "create_date", "write_uid", "write_date", "advance_payment_method", "amount", "amount_taken", "count", "currency_id", "deduct_down_payments", "deposit_account_id", "due_amount", "fixed_amount", "has_down_payments", "is_cash_sale_order", "is_immediate_payment", "is_self_used", "journal_id", "partner_id", "payment_details", "payment_method_id", "payment_term_id", "product_id") VALUES (nextval('sale_advance_payment_inv_id_seq'), 1015, (now() at time zone 'UTC'), 1015, (now() at time zone 'UTC'), 'delivered', '0.00', '0.00', 1, 2, true, 1417, '145.10', '0.00', false, false, false, false, NULL, 42334, NULL, NULL, 94, 171436) RETURNING id; Date: 2024-02-16 15:47:35
8	2	10s244ms	5s82ms	5s162ms	5s122ms	update "sale_order" set "amount_tax" = ?, "amount_total" = ?, "margin" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order" SET "amount_tax" = '9.49', "amount_total" = '183.87', "margin" = '46.80', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:11:59 UPDATE "sale_order" SET "amount_tax" = '0.00', "amount_total" = '190.60', "margin" = '52.48', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:11:47
9	2	8s53ms	1s271ms	6s781ms	4s26ms	update "sale_order" set "margin" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order" SET "margin" = '41.12', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:12:06
10	1	4s278ms	4s278ms	4s278ms	4s278ms	update "sale_order" set "amount_tax" = ?, "amount_total" = ?, "amount_untaxed" = ?, "carrier_id" = ?, "margin" = ?, "margin_percent" = ?.?, "unpaid_amount_total" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order" SET "amount_tax" = '10.46', "amount_total" = '184.84', "amount_untaxed" = '174.38', "carrier_id" = 1, "margin" = '46.80', "margin_percent" = 0.26837940130748944, "unpaid_amount_total" = '184.84', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:11:53 UPDATE "sale_order" SET "amount_tax" = '10.46', "amount_total" = '184.84', "amount_untaxed" = '174.38', "carrier_id" = 1, "margin" = '46.80', "margin_percent" = 0.26837940130748944, "unpaid_amount_total" = '184.84', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:11:53
11	1	4s166ms	4s166ms	4s166ms	4s166ms	update "sale_order" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order" SET "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); Date: 2024-02-16 18:11:47
12	1	3s161ms	3s161ms	3s161ms	3s161ms	update "sale_order_line" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order_line" SET "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (341461); Date: 2024-02-16 18:12:21 UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (340682, 340683, 340684, 340690, 340691, 340692, 340695, 340696, 340699, 340701); Date: 2024-02-16 12:58:12 UPDATE "sale_order_line" SET "write_uid" = 1149, "write_date" = (now() at time zone 'UTC') WHERE id IN (340836, 340912, 340849, 341137, 341170, 340856); Date: 2024-02-16 18:44:59
13	1	2s792ms	2s792ms	2s792ms	2s792ms	insert into "account_move_line" ("id", "create_uid", "create_date", "write_uid", "write_date", "account_id", "amount_currency", "blocked", "branch_id", "company_currency_id", "company_id", "credit", "currency_id", "debit", "discount", "display_type", "is_carry_forward", "is_discount", "is_extra_line", "is_sale_tax", "is_visible_in_report", "is_writeoff", "move_id", "move_options", "name", "partner_id", "product_id", "product_uom_id", "quantity", "ref", "sequence", "sign_product_qty", "tax_exigible") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), ?, ?, false, ?, ?, ?, ?, ?, ?, ?, null, false, false, false, false, true, false, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?.?, true) returning id; INSERT INTO "account_move_line" ("id", "create_uid", "create_date", "write_uid", "write_date", "account_id", "amount_currency", "blocked", "branch_id", "company_currency_id", "company_id", "credit", "currency_id", "debit", "discount", "display_type", "is_carry_forward", "is_discount", "is_extra_line", "is_sale_tax", "is_visible_in_report", "is_writeoff", "move_id", "move_options", "name", "partner_id", "product_id", "product_uom_id", "quantity", "ref", "sequence", "sign_product_qty", "tax_exigible") VALUES (nextval('account_move_line_id_seq'), 968, (now() at time zone 'UTC'), 968, (now() at time zone 'UTC'), 1334, '-167.80', false, 39, 2, 1, '167.80', 2, '0.00', '0.00', NULL, false, false, false, false, true, false, 1211611, 'new_product', '04-V/OUT/10312 - [N28-30-22-72] Drive Shaft Tubing HD', 34084, 172436, 1, '-4.00', '04-V/OUT/10312 - [N28-30-22-72] Drive Shaft Tubing HD', 10, 1.0, true) RETURNING id; Date: 2024-02-16 16:11:22
14	1	1s650ms	1s650ms	1s650ms	1s650ms	insert into "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "branch_id", "currency_id", "date", "discount_amount_applied", "edi_billed", "edi_split_lock", "extract_remote_id", "extract_state", "invoice_incoterm_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "move_type", "open_invoice", "partner_id", "ref", "state", "stock_move_id", "team_id", "to_check", "to_check_negative") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, ?, ?, ?, ?.?, false, false, ?, ?, null, ?.?, ?, false, false, ?, ?, false, ?, ?, ?, ?, ?, false, false) returning id; INSERT INTO "account_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "auto_post", "branch_id", "currency_id", "date", "discount_amount_applied", "edi_billed", "edi_split_lock", "extract_remote_id", "extract_state", "invoice_incoterm_id", "invoice_product_qty", "invoice_user_id", "is_edi_bill", "is_move_sent", "journal_id", "move_type", "open_invoice", "partner_id", "ref", "state", "stock_move_id", "team_id", "to_check", "to_check_negative") VALUES (nextval('account_move_id_seq'), 1047, (now() at time zone 'UTC'), 1047, (now() at time zone 'UTC'), false, 56, 2, '2024-02-16', 0.0, false, false, - 1, 'no_extract_requested', NULL, 1.0, 1047, false, false, 6, 'entry', false, 37979, '14-D/OUT/03394 - [LF14000NN] Oil Filter Old#LF9080', 'draft', 816960, 1, false, false) RETURNING id; Date: 2024-02-16 14:05:32
15	1	1s126ms	1s126ms	1s126ms	1s126ms	update "account_move" set "access_token" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "account_move" SET "access_token" = '7b2c0563-3119-456d-a1f2-e43f9f3d541e', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (1210931); Date: 2024-02-16 14:44:35

Queries that waited the most

Rank	Wait time	Query
1	1m44s	UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1212679 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 2 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1212679 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2024-02-16 18:56:36 ]
2	52s232ms	UPDATE "account_move" SET "state" = 'draft', "write_uid" = 1046, "write_date" = (now() at time zone 'UTC') WHERE id IN (1209675); [ Date: 2024-02-16 13:52:43 ]
3	25s181ms	UPDATE "bus_presence" SET "last_poll" = '2024-02-16 16:35:41', "last_presence" = '2024-02-16 16:35:27.369786' WHERE id IN (42); [ Date: 2024-02-16 16:36:06 ]
4	10s789ms	INSERT INTO "sale_advance_payment_inv" ("id", "create_uid", "create_date", "write_uid", "write_date", "advance_payment_method", "amount", "amount_taken", "count", "currency_id", "deduct_down_payments", "deposit_account_id", "due_amount", "fixed_amount", "has_down_payments", "is_cash_sale_order", "is_immediate_payment", "is_self_used", "journal_id", "partner_id", "payment_details", "payment_method_id", "payment_term_id", "product_id") VALUES (nextval('sale_advance_payment_inv_id_seq'), 1015, (now() at time zone 'UTC'), 1015, (now() at time zone 'UTC'), 'delivered', '0.00', '0.00', 1, 2, true, 1417, '145.10', '0.00', false, false, false, false, NULL, 42334, NULL, NULL, 94, 171436) RETURNING id; [ Date: 2024-02-16 15:47:35 ]
5	8s710ms	UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1212917 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1212917 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2024-02-16 19:52:22 ]
6	7s936ms	UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1210924 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1210924 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2024-02-16 14:44:22 ]
7	6s781ms	UPDATE "sale_order" SET "margin" = '41.12', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:12:12 ]
8	6s51ms	UPDATE "account_move" SET "message_main_attachment_id" = 5077642, "write_uid" = 961, "write_date" = (now() at time zone 'UTC') WHERE id IN (1210666); [ Date: 2024-02-16 14:05:32 ]
9	5s600ms	UPDATE "sale_order" SET "carrier_id" = NULL, "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:12:12 ]
10	5s411ms	UPDATE "account_move" SET "message_main_attachment_id" = 5078707, "write_uid" = 983, "write_date" = (now() at time zone 'UTC') WHERE id IN (1211703); [ Date: 2024-02-16 16:25:22 ]
11	5s162ms	UPDATE "sale_order" SET "amount_tax" = '9.49', "amount_total" = '183.87', "margin" = '46.80', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:11:59 ]
12	5s82ms	UPDATE "sale_order" SET "amount_tax" = '0.00', "amount_total" = '190.60', "margin" = '52.48', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:11:47 ]
13	4s577ms	UPDATE "account_move" SET "message_main_attachment_id" = 5078520, "write_uid" = 1266, "write_date" = (now() at time zone 'UTC') WHERE id IN (1211512); [ Date: 2024-02-16 16:06:25 ]
14	4s461ms	UPDATE "sale_order" SET "carrier_id" = NULL, "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:13:05 ]
15	4s381ms	UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1211339 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1211339 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2024-02-16 15:41:48 ]
16	4s278ms	UPDATE "sale_order" SET "amount_tax" = '10.46', "amount_total" = '184.84', "amount_untaxed" = '174.38', "carrier_id" = 1, "margin" = '46.80', "margin_percent" = 0.26837940130748944, "unpaid_amount_total" = '184.84', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:11:53 ]
17	4s206ms	UPDATE "sale_order" SET "carrier_id" = NULL, "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:11:59 ]
18	4s166ms	UPDATE "sale_order" SET "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (114007); [ Date: 2024-02-16 18:11:47 ]
19	4s148ms	UPDATE account_move SET write_date = write_date WHERE id = ( SELECT id FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1211000 AND sequence_prefix = ( SELECT sequence_prefix FROM account_move WHERE journal_id = 1 AND name != '/' AND sequence_prefix !~ '^(?:.?)(?:((?<=\D)\|(?<=^))((19\|20\|21)?\d{2}))(?:\D+?)$' AND move_type NOT IN ('out_refund', 'in_refund') AND id != 1211000 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2024-02-16 15:01:06 ]
20	4s103ms	UPDATE "sale_order_line" SET "price_tax" = 0.0, "price_total" = '158.16', "write_uid" = 1151, "write_date" = (now() at time zone 'UTC') WHERE id IN (341454); [ Date: 2024-02-16 18:11:53 ]

Queries by type

Key values

85,197 Total read queries
15,287 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	85,197	84.79%
INSERT	534	0.53%
UPDATE	14,243	14.17%
DELETE	373	0.37%
COPY FROM	0	0.00%
COPY TO	98	0.10%
CTE	39	0.04%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

unknown Main database
100,484 Requests
9h48m29s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	100,484	9h48m29s
	copy to	98	12m47s
	cte	39	6s631ms
	delete	373	23m19s
	insert	534	2m15s
	select	85,197	7h12m34s
	update	14,243	1h57m24s

Queries by user

Key values

unknown Main user
100,555 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	100,555	9h48m39s
	copy to	98	12m47s
	cte	39	6s631ms
	delete	373	23m19s
	insert	534	2m15s
	select	85,267	7h12m44s
	update	14,244	1h57m25s

Duration by user

Key values

9h48m39s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	100,555	9h48m39s
	copy to	98	12m47s
	cte	39	6s631ms
	delete	373	23m19s
	insert	534	2m15s
	select	85,267	7h12m44s
	update	14,244	1h57m25s

Queries by host

Key values

unknown Main host
100,555 Requests
9h48m39s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	100,555	9h48m39s
	copy to	98	12m47s
	cte	39	6s631ms
	delete	373	23m19s
	insert	534	2m15s
	select	85,267	7h12m44s
	update	14,244	1h57m25s

Queries by application

Key values

unknown Main application
100,484 Requests
9h48m29s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	100,484	9h48m29s
	copy to	98	12m47s
	cte	39	6s631ms
	delete	373	23m19s
	insert	534	2m15s
	select	85,197	7h12m34s
	update	14,243	1h57m24s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-02-16 06:54:22 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

82,566 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	82,566	82.17%
500-1000ms	13,072	13.01%
1000-10000ms	4,769	4.75%
> 10000ms	77	0.08%

Slowest individual queries

Rank	Duration	Query
1	3m51s	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: 2024-02-16 09:08:51 ]
2	3m23s	DELETE FROM account_move_line WHERE id IN (4216192, 4216193, 4216194, 4216195, 4216196, 4216197, 4216198, 4216199, 4216200, 4216201, 4216202, 4216203, 4216204, 4216205, 4216206, 4216207, 4216208, 4216209, 4216210, 4216211, 4216212, 4216213, 4216214, 4216215, 4216216, 4216217, 4216218, 4216219, 4216220, 4216221, 4216222, 4216223, 4216224, 4216225, 4216226, 4216227, 4216228, 4216229, 4216230, 4216231, 4216232, 4216233, 4216234, 4216235, 4216236, 4216237, 4216238, 4216239, 4216240, 4216241, 4216242, 4216243, 4216244, 4216245, 4216246, 4216247, 4216248, 4216249, 4216250, 4216251, 4216252, 4216253, 4216254, 4216255, 4216256, 4216257, 4216258, 4216259, 4216260, 4216261, 4216262, 4216263, 4216264, 4216265, 4216266, 4216267, 4216268, 4216269, 4216270, 4216271, 4216272, 4216273, 4216274, 4216275, 4216276, 4216277, 4216278, 4216279, 4216280, 4216281, 4216282, 4216283, 4216284, 4216285, 4216286, 4216287, 4216288, 4216289, 4216290, 4216291, 4216292, 4216293, 4216294, 4216295, 4216296, 4216297, 4216298, 4216299, 4216300, 4216301, 4216302, 4216303, 4216304, 4216305, 4216306, 4216307, 4216308, 4216309, 4216310, 4216311, 4216312, 4216313, 4216314, 4216315, 4216316, 4216317, 4216318, 4216319, 4216320, 4216321); [ Date: 2024-02-16 13:52:40 ]
3	2m26s	DELETE FROM account_move_line WHERE id IN (4223496, 4223497, 4223498, 4223499, 4223500, 4223501, 4223502, 4223503, 4223504, 4223505, 4223506, 4223507, 4223508, 4223509, 4223510, 4223511, 4223512, 4223513, 4223514, 4223515, 4223516, 4223517, 4223518, 4223519, 4223520, 4223521, 4223522, 4223523, 4223524, 4223525, 4223526, 4223527, 4223528, 4223529, 4223530, 4223531, 4223532, 4223533, 4223534, 4223535, 4223536, 4223537, 4223538, 4223539, 4223540, 4223541, 4223542, 4223543, 4223544, 4223545, 4223546, 4223547, 4223548, 4223549, 4223550, 4223551, 4223552, 4223553, 4223554, 4223555, 4223556, 4223557, 4223558, 4223559, 4223560, 4223561, 4223562, 4223563, 4223564, 4223565, 4223566, 4223567, 4223568, 4223569, 4223570, 4223571, 4223572, 4223573, 4223574, 4223575, 4223576, 4223577, 4223578, 4223579, 4223580, 4223581, 4223582, 4223583, 4223584, 4223585, 4223586, 4223587, 4223588, 4223589, 4223590, 4223591, 4223592); [ Date: 2024-02-16 18:56:34 ]
4	1m41s	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: 2024-02-16 09:03:17 ]
5	1m34s	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: 2024-02-16 09:04:59 ]
6	1m17s	DELETE FROM account_move_line WHERE id IN (4216365, 4216368, 4216369, 4216370, 4216372, 4216373, 4216374, 4216375, 4216376, 4216378, 4216380, 4216382, 4216383, 4216387, 4216388, 4216389, 4216390, 4216394, 4216395, 4216396, 4216400, 4216401, 4216410, 4216417, 4216418, 4216425, 4216426, 4216428, 4216430, 4216435, 4216437, 4216444, 4216447, 4216449, 4216451, 4216452, 4216456, 4216458, 4216459, 4216462, 4216463, 4216465, 4216467, 4216468, 4216470, 4216475, 4216476, 4216477, 4216489, 4216490); [ Date: 2024-02-16 15:27:14 ]
7	1m15s	DELETE FROM account_move_line WHERE id IN (4216365, 4216368, 4216369, 4216370, 4216372, 4216373, 4216374, 4216375, 4216376, 4216378, 4216380, 4216382, 4216383, 4216387, 4216388, 4216389, 4216390, 4216394, 4216395, 4216396, 4216400, 4216401, 4216410, 4216417, 4216418, 4216425, 4216426, 4216428, 4216430, 4216435, 4216437, 4216444, 4216447, 4216449, 4216451, 4216452, 4216456, 4216458, 4216459, 4216462, 4216463, 4216465, 4216467, 4216468, 4216470, 4216475, 4216476, 4216477, 4216489, 4216490); [ Date: 2024-02-16 15:09:37 ]
8	1m13s	DELETE FROM account_move_line WHERE id IN (4213590, 4213593, 4213594, 4213595, 4213597, 4213598, 4213599, 4213600, 4213601, 4213603, 4213605, 4213607, 4213608, 4213612, 4213613, 4213614, 4213615, 4213619, 4213620, 4213621, 4213625, 4213626, 4213635, 4213637, 4213642, 4213643, 4213650, 4213651, 4213653, 4213655, 4213662, 4213669, 4213674, 4213676, 4213677, 4213681, 4213683, 4213684, 4213687, 4213688, 4213690, 4213692, 4213693, 4213700, 4213701, 4213702, 4213714, 4213715); [ Date: 2024-02-16 13:25:43 ]
9	1m12s	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: 2024-02-16 09:12:56 ]
10	56s610ms	UPDATE "stock_move" SET "date" = '2024-02-16 18:45:00', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (809472, 809473, 809474, 809475, 809476, 809477, 809478, 809479, 809480, 809481, 809482, 809483, 809484, 809485, 809486, 809487, 809488, 809489, 809490, 809491, 809492, 809493, 809494, 809495, 809496, 809497, 809498, 809499, 809500, 809501, 809502, 809503, 809505, 809507, 809508, 809509, 809510, 809512, 809513, 809514, 809515, 809516, 809517, 809518, 809519, 809520, 809521, 809522, 809523, 809447, 809448, 809449, 809450, 809451, 809452, 809453, 809454, 809455, 809456, 809457, 809458, 809459, 809460, 809461, 809462, 809463, 809464, 809465, 809466, 809467, 809469, 809470, 809471); [ Date: 2024-02-16 18:45:56 ]
11	45s802ms	COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout; [ Date: 2024-02-16 09:11:44 ]
12	39s595ms	SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" < '2025-01-01')) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%ken k%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month"; [ Date: 2024-02-16 17:31:50 ]
13	38s308ms	SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE (((("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false) AND ("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false)) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%Ed Robinson%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) AND (("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" <= '2024-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80; [ Date: 2024-02-16 13:18:08 ]
14	27s254ms	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, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) TO stdout; [ Date: 2024-02-16 09:00:45 ]
15	23s429ms	DELETE FROM account_move_line WHERE id IN (4213833, 4213834, 4213835, 4213836, 4213837, 4213838, 4223960, 4223961, 4223962, 4223963, 4223964, 4223965, 4223966, 4223967, 4223968, 4223969); [ Date: 2024-02-16 23:42:56 ]
16	21s337ms	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, technician_id, inventory_vendor_id, product_type) TO stdout; [ Date: 2024-02-16 09:10:23 ]
17	20s477ms	DELETE FROM sale_order_line WHERE id IN (341154, 341155, 341156, 341157); [ Date: 2024-02-16 15:43:23 ]
18	20s100ms	SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE (("sale_history_line"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Labor%')))) AND (("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" <= '2024-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80; [ Date: 2024-02-16 18:04:20 ]
19	19s781ms	SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE (("sale_history_line"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Labor%')))) AND (("sale_history_line"."invoice_date" >= '2024-01-01') AND ("sale_history_line"."invoice_date" <= '2024-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80; [ Date: 2024-02-16 18:02:11 ]
20	19s673ms	UPDATE "stock_move" SET "date" = '2024-02-16 15:46:19', "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (817300, 817301, 817303, 817304, 817305, 817306, 817307, 817308, 817309, 817310, 817311, 817312, 817313, 817314, 817315, 817316, 817317, 817318, 817319, 817320, 817321); [ Date: 2024-02-16 15:46:39 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3h28m6s

54,785

Details

120ms

2s264ms

227ms

select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 16	00	712	2m47s	234ms
	01	530	1m50s	208ms
	02	579	1m52s	193ms
	03	420	1m5s	156ms
	04	485	2m8s	264ms
	05	740	1m53s	153ms
	06	505	1m30s	178ms
	07	567	1m51s	196ms
	08	360	1m30s	251ms
	09	832	2m6s	151ms
	10	587	1m43s	175ms
	11	673	2m7s	189ms
	12	2,259	7m32s	200ms
	13	5,982	22m11s	222ms
	14	6,102	23m9s	227ms
	15	5,852	22m36s	231ms
	16	6,722	28m48s	257ms
	17	4,893	21m25s	262ms
	18	5,181	19m54s	230ms
	19	4,832	16m40s	207ms
	20	3,828	15m56s	249ms
	21	1,364	4m33s	200ms
	22	386	1m13s	191ms
	23	394	1m37s	246ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-16 20:49:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_952"', '["pointspring_master","calendar.alarm",19490]', '["pointspring_master","mail.channel",68]', '["pointspring_master","mail.channel",70]', '["pointspring_master","mail.channel",522]', '["pointspring_master","res.partner",19490]', '["pointspring_master","ir.needaction",19490]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-16 20:50:10 Duration: 2s264ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-16 20:49:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1035"', '["pointspring_master","calendar.alarm",19573]', '["pointspring_master","mail.channel",66]', '["pointspring_master","mail.channel",432]', '["pointspring_master","mail.channel",476]', '["pointspring_master","mail.channel",570]', '["pointspring_master","res.partner",19573]', '["pointspring_master","ir.needaction",19573]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-16 20:50:10 Duration: 2s230ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-16 20:49:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_969"', '["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","mail.channel",594]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-16 20:50:10 Duration: 2s229ms

2

43m13s

3,657

Details

604ms

2s793ms

709ms

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 #2

Day	Hour	Count	Duration	Avg duration
Feb 16	01	64	41s356ms	646ms
	02	7	4s450ms	635ms
	10	5	3s402ms	680ms
	11	4	2s572ms	643ms
	12	278	3m14s	698ms
	13	717	8m42s	729ms
	14	519	6m14s	720ms
	15	406	4m44s	701ms
	16	385	4m53s	762ms
	17	374	4m19s	693ms
	18	229	2m38s	691ms
	19	330	3m46s	685ms
	20	245	2m47s	684ms
	21	90	58s927ms	654ms
	22	4	2s572ms	643ms

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 ('%%s344446%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%s-344446-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%s-344446-%'))) 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: 2024-02-16 16:06:09 Duration: 2s793ms
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 ('%%krw7%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%krw7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%krw7%'))) 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: 2024-02-16 13:29:16 Duration: 2s640ms
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 ('%%krw71%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%krw71%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%krw71%'))) 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: 2024-02-16 13:29:17 Duration: 2s414ms

3

19m13s

3,085

Details

340ms

1s421ms

373ms

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 #3

Day	Hour	Count	Duration	Avg duration
Feb 16	00	7	2s426ms	346ms
	01	6	2s92ms	348ms
	02	9	3s126ms	347ms
	05	3	1s26ms	342ms
	09	26	9s553ms	367ms
	10	29	10s300ms	355ms
	11	37	12s926ms	349ms
	12	250	1m30s	361ms
	13	472	3m4s	390ms
	14	399	2m31s	380ms
	15	296	1m51s	377ms
	16	399	2m34s	386ms
	17	164	1m	370ms
	18	278	1m42s	367ms
	19	357	2m10s	365ms
	20	223	1m20s	360ms
	21	113	39s921ms	353ms
	22	17	5s867ms	345ms

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

Date: 2024-02-16 13:43:35 Duration: 1s421ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-16 16:24:32 Duration: 1s321ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-df4ccbc/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-16 12:44:26 Duration: 1s276ms

4

15m28s

75

Details

1s449ms

3m23s

12s386ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 16	06	12	1m9s	5s762ms
	13	4	4m49s	1m12s
	14	1	3s163ms	3s163ms
	15	14	3m27s	14s821ms
	16	6	22s494ms	3s749ms
	17	10	28s623ms	2s862ms
	18	7	2m50s	24s420ms
	19	6	24s235ms	4s39ms
	20	1	4s467ms	4s467ms
	21	2	10s227ms	5s113ms
	23	12	1m38s	8s230ms

DELETE FROM account_move_line WHERE id IN (4216192, 4216193, 4216194, 4216195, 4216196, 4216197, 4216198, 4216199, 4216200, 4216201, 4216202, 4216203, 4216204, 4216205, 4216206, 4216207, 4216208, 4216209, 4216210, 4216211, 4216212, 4216213, 4216214, 4216215, 4216216, 4216217, 4216218, 4216219, 4216220, 4216221, 4216222, 4216223, 4216224, 4216225, 4216226, 4216227, 4216228, 4216229, 4216230, 4216231, 4216232, 4216233, 4216234, 4216235, 4216236, 4216237, 4216238, 4216239, 4216240, 4216241, 4216242, 4216243, 4216244, 4216245, 4216246, 4216247, 4216248, 4216249, 4216250, 4216251, 4216252, 4216253, 4216254, 4216255, 4216256, 4216257, 4216258, 4216259, 4216260, 4216261, 4216262, 4216263, 4216264, 4216265, 4216266, 4216267, 4216268, 4216269, 4216270, 4216271, 4216272, 4216273, 4216274, 4216275, 4216276, 4216277, 4216278, 4216279, 4216280, 4216281, 4216282, 4216283, 4216284, 4216285, 4216286, 4216287, 4216288, 4216289, 4216290, 4216291, 4216292, 4216293, 4216294, 4216295, 4216296, 4216297, 4216298, 4216299, 4216300, 4216301, 4216302, 4216303, 4216304, 4216305, 4216306, 4216307, 4216308, 4216309, 4216310, 4216311, 4216312, 4216313, 4216314, 4216315, 4216316, 4216317, 4216318, 4216319, 4216320, 4216321);

Date: 2024-02-16 13:52:40 Duration: 3m23s
DELETE FROM account_move_line WHERE id IN (4223496, 4223497, 4223498, 4223499, 4223500, 4223501, 4223502, 4223503, 4223504, 4223505, 4223506, 4223507, 4223508, 4223509, 4223510, 4223511, 4223512, 4223513, 4223514, 4223515, 4223516, 4223517, 4223518, 4223519, 4223520, 4223521, 4223522, 4223523, 4223524, 4223525, 4223526, 4223527, 4223528, 4223529, 4223530, 4223531, 4223532, 4223533, 4223534, 4223535, 4223536, 4223537, 4223538, 4223539, 4223540, 4223541, 4223542, 4223543, 4223544, 4223545, 4223546, 4223547, 4223548, 4223549, 4223550, 4223551, 4223552, 4223553, 4223554, 4223555, 4223556, 4223557, 4223558, 4223559, 4223560, 4223561, 4223562, 4223563, 4223564, 4223565, 4223566, 4223567, 4223568, 4223569, 4223570, 4223571, 4223572, 4223573, 4223574, 4223575, 4223576, 4223577, 4223578, 4223579, 4223580, 4223581, 4223582, 4223583, 4223584, 4223585, 4223586, 4223587, 4223588, 4223589, 4223590, 4223591, 4223592);

Date: 2024-02-16 18:56:34 Duration: 2m26s
DELETE FROM account_move_line WHERE id IN (4216365, 4216368, 4216369, 4216370, 4216372, 4216373, 4216374, 4216375, 4216376, 4216378, 4216380, 4216382, 4216383, 4216387, 4216388, 4216389, 4216390, 4216394, 4216395, 4216396, 4216400, 4216401, 4216410, 4216417, 4216418, 4216425, 4216426, 4216428, 4216430, 4216435, 4216437, 4216444, 4216447, 4216449, 4216451, 4216452, 4216456, 4216458, 4216459, 4216462, 4216463, 4216465, 4216467, 4216468, 4216470, 4216475, 4216476, 4216477, 4216489, 4216490);

Date: 2024-02-16 15:27:14 Duration: 1m17s

5

11m49s

818

Details

792ms

2s638ms

867ms

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 #5

Day	Hour	Count	Duration	Avg duration
Feb 16	00	1	820ms	820ms
	11	1	824ms	824ms
	12	52	44s696ms	859ms
	13	125	1m49s	875ms
	14	75	1m5s	867ms
	15	136	1m57s	865ms
	16	103	1m31s	886ms
	17	67	56s781ms	847ms
	18	101	1m26s	859ms
	19	98	1m26s	881ms
	20	49	41s857ms	854ms
	21	9	7s374ms	819ms
	22	1	836ms	836ms

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 ('%tci-a-sda4515%')) 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 ('%tci-a-sda4515%'))) 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 ('%tci-a-sda4515%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%tci-a-sda4515%')))))) 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: 2024-02-16 19:27:03 Duration: 2s638ms
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 ('%489x%')) 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 ('%489x%'))) 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 ('%489x%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%489x%')))))) 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: 2024-02-16 16:42:01 Duration: 2s462ms
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 ('%e-6028l%')) 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 ('%e-6028l%'))) 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 ('%e-6028l%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%e-6028l%')))))) 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: 2024-02-16 12:57:10 Duration: 2s108ms

6

9m46s

151

Details

151ms

56s610ms

3s886ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 16	10	1	754ms	754ms
	12	2	1s572ms	786ms
	13	14	34s874ms	2s491ms
	14	24	56s669ms	2s361ms
	15	17	51s805ms	3s47ms
	16	22	1m49s	4s995ms
	17	25	2m41s	6s467ms
	18	18	1m33s	5s210ms
	19	10	37s996ms	3s799ms
	20	15	33s88ms	2s205ms
	21	3	4s665ms	1s555ms

UPDATE "stock_move" SET "date" = '2024-02-16 18:45:00', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (809472, 809473, 809474, 809475, 809476, 809477, 809478, 809479, 809480, 809481, 809482, 809483, 809484, 809485, 809486, 809487, 809488, 809489, 809490, 809491, 809492, 809493, 809494, 809495, 809496, 809497, 809498, 809499, 809500, 809501, 809502, 809503, 809505, 809507, 809508, 809509, 809510, 809512, 809513, 809514, 809515, 809516, 809517, 809518, 809519, 809520, 809521, 809522, 809523, 809447, 809448, 809449, 809450, 809451, 809452, 809453, 809454, 809455, 809456, 809457, 809458, 809459, 809460, 809461, 809462, 809463, 809464, 809465, 809466, 809467, 809469, 809470, 809471);

Date: 2024-02-16 18:45:56 Duration: 56s610ms
UPDATE "stock_move" SET "date" = '2024-02-16 15:46:19', "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (817300, 817301, 817303, 817304, 817305, 817306, 817307, 817308, 817309, 817310, 817311, 817312, 817313, 817314, 817315, 817316, 817317, 817318, 817319, 817320, 817321);

Date: 2024-02-16 15:46:39 Duration: 19s673ms
UPDATE "stock_move" SET "date" = '2024-02-16 16:08:15', "state" = 'done', "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (814048, 814049, 814050, 814051, 814052, 814053, 814054, 814055, 814056, 814057, 814058, 814059, 814060, 814061, 814062, 814063, 814064, 814065, 814066, 814067, 814068, 814069, 814070);

Date: 2024-02-16 16:08:34 Duration: 18s990ms

7

9m

763

Details

622ms

1s607ms

708ms

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"."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 #7

Day	Hour	Count	Duration	Avg duration
Feb 16	12	42	28s246ms	672ms
	13	85	59s21ms	694ms
	14	121	1m24s	700ms
	15	168	2m1s	721ms
	16	174	2m5s	722ms
	17	29	20s204ms	696ms
	18	68	48s453ms	712ms
	19	31	23s78ms	744ms
	20	33	22s282ms	675ms
	21	12	7s752ms	646ms

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 ('%%GAFF%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%GAFF%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%GAFF%'))) 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: 2024-02-16 15:15:35 Duration: 1s607ms
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 ('%%65418911%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-1891-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6.5-4-1891-1%'))) 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: 2024-02-16 16:36:07 Duration: 1s381ms
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 ('%%373%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%373%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%373%'))) 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: 2024-02-16 18:34:46 Duration: 1s141ms

8

8m43s

569

Details

306ms

3s542ms

919ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	757ms	757ms
	10	5	3s983ms	796ms
	12	14	12s529ms	894ms
	13	69	1m4s	939ms
	14	143	2m7s	894ms
	15	68	1m6s	983ms
	16	79	1m15s	961ms
	17	41	36s514ms	890ms
	18	47	42s572ms	905ms
	19	44	38s714ms	879ms
	20	31	23s990ms	773ms
	21	27	28s685ms	1s62ms

UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-02-16 15:34:32', "is_done" = true, "state" = 'done', "write_uid" = 964, "write_date" = (now() at time zone 'UTC') WHERE id IN (807984, 807986, 807994);

Date: 2024-02-16 15:34:42 Duration: 3s542ms
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-16 16:05:16', "is_done" = true, "state" = 'done', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (817393, 817394, 817395, 817382);

Date: 2024-02-16 16:05:50 Duration: 2s921ms
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2024-02-16 14:38:17', "is_done" = true, "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (808027, 808028);

Date: 2024-02-16 14:38:36 Duration: 2s770ms

9

7m45s

762

Details

149ms

3s564ms

611ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	437ms	437ms
	10	5	2s682ms	536ms
	12	23	12s694ms	551ms
	13	141	1m23s	595ms
	14	178	1m42s	577ms
	15	84	1m1s	727ms
	16	87	57s694ms	663ms
	17	56	33s520ms	598ms
	18	48	29s232ms	609ms
	19	65	40s41ms	616ms
	20	54	30s513ms	565ms
	21	19	10s877ms	572ms
	22	1	449ms	449ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (434464, 434471, 433800, 436008, 42291, 434461, 434462, 434463);

Date: 2024-02-16 16:11:47 Duration: 3s564ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 980, "write_date" = (now() at time zone 'UTC') WHERE id IN (217634, 431909, 423287, 423288, 244153);

Date: 2024-02-16 17:01:48 Duration: 3s476ms
UPDATE "stock_quant" SET "quantity" = 1.0, "reserved_quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (434600, 225381, 209246, 304999);

Date: 2024-02-16 15:46:13 Duration: 3s152ms

10

6m54s

390

Details

971ms

3s302ms

1s63ms

select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 16	03	3	2s969ms	989ms
	09	3	2s979ms	993ms
	11	9	8s984ms	998ms
	12	39	40s405ms	1s36ms
	13	54	1m	1s111ms
	14	12	13s312ms	1s109ms
	15	36	41s377ms	1s149ms
	16	36	38s824ms	1s78ms
	17	66	1m11s	1s81ms
	18	27	28s142ms	1s42ms
	19	9	9s385ms	1s42ms
	20	39	39s561ms	1s14ms
	21	48	48s394ms	1s8ms
	22	6	5s913ms	985ms
	23	3	2s936ms	978ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%20-74-91%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%20-74-91%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%20-74-91%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%20-74-91%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%20-74-91%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%20-74-91%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2024-02-16 13:29:17 Duration: 3s302ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4519D%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4519D%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4519D%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4519D%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2024-02-16 17:56:43 Duration: 3s97ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4x.134%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4x.134%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4x.134%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4x.134%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2024-02-16 15:34:52 Duration: 2s436ms

11

6m35s

557

Details

600ms

3s120ms

710ms

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"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_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 #11

Day	Hour	Count	Duration	Avg duration
Feb 16	12	40	29s712ms	742ms
	13	47	33s916ms	721ms
	14	93	1m4s	693ms
	15	36	23s952ms	665ms
	16	38	32s308ms	850ms
	17	209	2m29s	714ms
	18	40	26s157ms	653ms
	19	20	13s471ms	673ms
	20	34	22s697ms	667ms

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 ('%%1842337C%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1842337C%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1842337C%'))) 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"."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: 2024-02-16 16:06:10 Duration: 3s120ms
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 ('%%1842337C9%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1842337C9%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1842337C9%'))) 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"."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: 2024-02-16 16:06:10 Duration: 2s542ms
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 ('%%1842337%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1842337%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1842337%'))) 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"."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: 2024-02-16 16:06:08 Duration: 1s457ms

12

5m57s

705

Details

140ms

4s90ms

507ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 16	10	3	1s58ms	352ms
	12	7	1s968ms	281ms
	13	80	30s643ms	383ms
	14	120	39s673ms	330ms
	15	84	42s144ms	501ms
	16	118	1m12s	615ms
	17	121	56s661ms	468ms
	18	65	53s355ms	820ms
	19	49	28s682ms	585ms
	20	38	18s20ms	474ms
	21	20	12s966ms	648ms

UPDATE "stock_quant" SET "quantity" = 3.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (434528, 432230, 1256, 185065, 356937, 354990, 2000, 818, 258388);

Date: 2024-02-16 18:46:25 Duration: 4s90ms
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (434530, 434532, 309712, 224690, 351414, 172598, 303318, 302170);

Date: 2024-02-16 18:46:39 Duration: 3s592ms
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (185059, 432229, 277384, 366602, 330474, 364123, 1980);

Date: 2024-02-16 18:46:29 Duration: 3s205ms

13

5m55s

292

Details

145ms

15s100ms

1s218ms

update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 16	01	1	6s572ms	6s572ms
	02	3	1s348ms	449ms
	10	1	171ms	171ms
	12	20	30s129ms	1s506ms
	13	52	1m2s	1s203ms
	14	49	1m12s	1s478ms
	15	29	51s172ms	1s764ms
	16	28	20s744ms	740ms
	17	26	23s866ms	917ms
	18	23	19s929ms	866ms
	19	30	34s586ms	1s152ms
	20	21	22s606ms	1s76ms
	21	8	9s206ms	1s150ms
	22	1	478ms	478ms

UPDATE "stock_move" SET "branch_id" = 40, "picking_id" = 345752, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (817313, 817315, 817317, 817318, 817319, 817320, 817321, 817300, 817302, 817303, 817304, 817305, 817306, 817307, 817308, 817311);

Date: 2024-02-16 15:43:02 Duration: 15s100ms
UPDATE "stock_move" SET "branch_id" = 40, "picking_id" = 346156, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (817971, 817972, 817973, 817974, 817975, 817976, 817977, 817978, 817979, 817980, 817981, 817982);

Date: 2024-02-16 19:59:52 Duration: 9s967ms
UPDATE "stock_move" SET "branch_id" = 45, "picking_id" = 345531, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (816941, 816942, 816943, 816944, 816945, 816946, 816947, 816948, 816949, 816950, 816951, 816952, 816953);

Date: 2024-02-16 14:03:22 Duration: 7s955ms

14

5m27s

615

Details

140ms

10s64ms

532ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 16	01	1	1s499ms	1s499ms
	02	2	302ms	151ms
	12	28	11s516ms	411ms
	13	106	1m	568ms
	14	100	57s137ms	571ms
	15	64	31s287ms	488ms
	16	76	48s793ms	642ms
	17	55	17s539ms	318ms
	18	51	26s597ms	521ms
	19	69	33s347ms	483ms
	20	48	33s554ms	699ms
	21	14	5s392ms	385ms
	22	1	147ms	147ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (817992, 817994, 817995, 817996, 817997, 817998, 817999, 818000, 818001, 818003, 818005, 818006, 818007, 818008, 818009, 818012, 818013, 818014, 818016);

Date: 2024-02-16 20:04:40 Duration: 10s64ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (801024, 801025, 801026, 793097, 261392, 801040, 801041, 801043, 802576, 811155, 802584, 811161, 811163, 802591, 814879, 802594, 793000, 793130, 802604, 793005, 799278, 793006, 802615, 793015, 802619, 811072, 802628, 801787, 802633, 785099, 802635, 811086, 785104, 811091, 802644, 802646, 811096, 811097, 811100, 800996, 800997, 800998, 800999, 790504, 801000, 801001, 811109, 767596, 801004, 811114, 261364, 801019);

Date: 2024-02-16 18:47:18 Duration: 9s801ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (817379, 817380, 817382, 817384, 817385, 817386, 817387, 817388, 817389, 817390, 817392, 817393, 817394, 817395, 817396, 817397, 817398);

Date: 2024-02-16 16:04:39 Duration: 8s560ms

15

5m13s

52

Details

4s559ms

20s477ms

6s22ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 16	12	3	14s371ms	4s790ms
	13	9	45s791ms	5s87ms
	14	8	49s745ms	6s218ms
	15	3	35s12ms	11s670ms
	16	4	24s556ms	6s139ms
	17	5	28s650ms	5s730ms
	18	12	58s688ms	4s890ms
	19	6	37s778ms	6s296ms
	20	1	14s33ms	14s33ms
	21	1	4s562ms	4s562ms

DELETE FROM sale_order_line WHERE id IN (341154, 341155, 341156, 341157);

Date: 2024-02-16 15:43:23 Duration: 20s477ms
DELETE FROM sale_order_line WHERE id IN (325698, 325699, 325700);

Date: 2024-02-16 20:33:14 Duration: 14s33ms
DELETE FROM sale_order_line WHERE id IN (337561, 337565);

Date: 2024-02-16 14:14:55 Duration: 10s148ms

16

5m7s

1,526

Details

175ms

1s69ms

201ms

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 #16

Day	Hour	Count	Duration	Avg duration
Feb 16	00	2	359ms	179ms
	09	1	182ms	182ms
	10	7	1s274ms	182ms
	11	14	2s633ms	188ms
	12	89	17s208ms	193ms
	13	225	48s113ms	213ms
	14	187	38s444ms	205ms
	15	158	32s319ms	204ms
	16	310	1m2s	202ms
	17	212	41s960ms	197ms
	18	168	33s67ms	196ms
	19	80	15s523ms	194ms
	20	42	7s933ms	188ms
	21	31	5s742ms	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 ('%STUTZ%') OR unaccent (res_partner.display_name) ilike unaccent ('%STUTZ%') OR unaccent (res_partner.ref) ilike unaccent ('%STUTZ%') OR unaccent (res_partner.vat) ilike unaccent ('STUTZ')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%STUTZ%') desc, unaccent (res_partner.display_name);

Date: 2024-02-16 15:34:52 Duration: 1s69ms
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 ('%T-05764%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-05764%') OR unaccent (res_partner.ref) ilike unaccent ('%T-05764%') OR unaccent (res_partner.vat) ilike unaccent ('T-05764')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-05764%') desc, unaccent (res_partner.display_name);

Date: 2024-02-16 13:03:59 Duration: 997ms
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 ('%keane fr%') OR unaccent (res_partner.display_name) ilike unaccent ('%keane fr%') OR unaccent (res_partner.ref) ilike unaccent ('%keane fr%') OR unaccent (res_partner.vat) ilike unaccent ('keanefr')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%keane fr%') desc, unaccent (res_partner.display_name);

Date: 2024-02-16 13:29:15 Duration: 937ms

17

4m34s

234

Details

149ms

8s669ms

1s172ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 16	10	1	746ms	746ms
	12	11	11s949ms	1s86ms
	13	47	50s321ms	1s70ms
	14	38	36s325ms	955ms
	15	18	25s123ms	1s395ms
	16	28	41s434ms	1s479ms
	17	20	21s699ms	1s84ms
	18	19	26s779ms	1s409ms
	19	30	38s644ms	1s288ms
	20	16	13s876ms	867ms
	21	5	6s768ms	1s353ms
	22	1	731ms	731ms

UPDATE "stock_move" SET "date" = '2024-02-16 16:11:29', "is_done" = true, "state" = 'done', "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (807368, 807370, 807373, 807376, 807377, 807378, 807379, 807380, 807381, 807382, 807414);

Date: 2024-02-16 16:11:41 Duration: 8s669ms
UPDATE "stock_move" SET "date" = '2024-02-16 18:42:33', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (815904, 815898, 815900, 815902, 815903);

Date: 2024-02-16 18:42:48 Duration: 3s884ms
UPDATE "stock_move" SET "date" = '2024-02-16 15:25:45', "is_done" = true, "state" = 'done', "write_uid" = 952, "write_date" = (now() at time zone 'UTC') WHERE id IN (817248, 817250, 817251, 817247);

Date: 2024-02-16 15:25:56 Duration: 3s625ms

18

4m31s

1,642

Details

123ms

741ms

165ms

select min("account_move".id) as id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" AS "debit_origin_id" from "account_move" left join "account_move" AS "account_move__debit_origin_id" on ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") where ("account_move"."debit_origin_id" in (...)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) group by "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" order by "account_move__debit_origin_id"."invoice_date_due";

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 16	00	1	170ms	170ms
	02	1	231ms	231ms
	05	1	147ms	147ms
	09	2	254ms	127ms
	10	15	2s112ms	140ms
	11	1	131ms	131ms
	12	64	10s20ms	156ms
	13	225	38s881ms	172ms
	14	266	43s782ms	164ms
	15	195	31s607ms	162ms
	16	251	43s653ms	173ms
	17	243	39s994ms	164ms
	18	192	30s848ms	160ms
	19	89	14s352ms	161ms
	20	67	10s962ms	163ms
	21	25	3s797ms	151ms
	22	4	583ms	145ms

SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1210318)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";

Date: 2024-02-16 13:12:33 Duration: 741ms
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1211973)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";

Date: 2024-02-16 17:01:00 Duration: 670ms
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1210469)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";

Date: 2024-02-16 13:33:12 Duration: 661ms

19

4m19s

241

Details

977ms

2s951ms

1s75ms

select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 16	11	2	1s995ms	997ms
	12	20	21s615ms	1s80ms
	13	35	36s971ms	1s56ms
	14	21	23s636ms	1s125ms
	15	16	19s732ms	1s233ms
	16	20	21s554ms	1s77ms
	17	43	47s964ms	1s115ms
	18	14	14s532ms	1s38ms
	19	1	1s51ms	1s51ms
	20	43	44s194ms	1s27ms
	21	21	20s966ms	998ms
	22	1	993ms	993ms
	23	4	3s930ms	982ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4519D%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4519D%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4519D%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4519D%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2024-02-16 17:56:43 Duration: 2s951ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4x.134%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4x.134%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4x.134%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4x.134%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2024-02-16 15:34:53 Duration: 2s771ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4519%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4519%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4519%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4519%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4519%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4519%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2024-02-16 17:56:40 Duration: 1s609ms

20

4m17s

305

Details

273ms

6s915ms

845ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 16	10	1	440ms	440ms
	12	4	2s507ms	626ms
	13	45	39s284ms	872ms
	14	28	22s871ms	816ms
	15	51	49s809ms	976ms
	16	77	1m9s	906ms
	17	13	7s582ms	583ms
	18	25	16s889ms	675ms
	19	20	15s352ms	767ms
	20	36	32s	888ms
	21	5	1s451ms	290ms

UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-16 15:33:24', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (809122, 809191, 809132, 809166, 809134, 809137, 809142, 817273, 809148);

Date: 2024-02-16 15:33:44 Duration: 6s915ms
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-16 19:17:21', "state" = 'done', "write_uid" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (802924, 802925, 802926, 802927, 802929);

Date: 2024-02-16 19:17:30 Duration: 4s181ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2024-02-16 20:47:03', "state" = 'done', "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (813755, 813756, 813757);

Date: 2024-02-16 20:47:08 Duration: 3s462ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

54,785

Details

3h28m6s

120ms

2s264ms

227ms

select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 16	00	712	2m47s	234ms
	01	530	1m50s	208ms
	02	579	1m52s	193ms
	03	420	1m5s	156ms
	04	485	2m8s	264ms
	05	740	1m53s	153ms
	06	505	1m30s	178ms
	07	567	1m51s	196ms
	08	360	1m30s	251ms
	09	832	2m6s	151ms
	10	587	1m43s	175ms
	11	673	2m7s	189ms
	12	2,259	7m32s	200ms
	13	5,982	22m11s	222ms
	14	6,102	23m9s	227ms
	15	5,852	22m36s	231ms
	16	6,722	28m48s	257ms
	17	4,893	21m25s	262ms
	18	5,181	19m54s	230ms
	19	4,832	16m40s	207ms
	20	3,828	15m56s	249ms
	21	1,364	4m33s	200ms
	22	386	1m13s	191ms
	23	394	1m37s	246ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-16 20:49:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_952"', '["pointspring_master","calendar.alarm",19490]', '["pointspring_master","mail.channel",68]', '["pointspring_master","mail.channel",70]', '["pointspring_master","mail.channel",522]', '["pointspring_master","res.partner",19490]', '["pointspring_master","ir.needaction",19490]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-16 20:50:10 Duration: 2s264ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-16 20:49:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1035"', '["pointspring_master","calendar.alarm",19573]', '["pointspring_master","mail.channel",66]', '["pointspring_master","mail.channel",432]', '["pointspring_master","mail.channel",476]', '["pointspring_master","mail.channel",570]', '["pointspring_master","res.partner",19573]', '["pointspring_master","ir.needaction",19573]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-16 20:50:10 Duration: 2s230ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-16 20:49:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_969"', '["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","mail.channel",594]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-16 20:50:10 Duration: 2s229ms

2

3,657

Details

43m13s

604ms

2s793ms

709ms

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 #2

Day	Hour	Count	Duration	Avg duration
Feb 16	01	64	41s356ms	646ms
	02	7	4s450ms	635ms
	10	5	3s402ms	680ms
	11	4	2s572ms	643ms
	12	278	3m14s	698ms
	13	717	8m42s	729ms
	14	519	6m14s	720ms
	15	406	4m44s	701ms
	16	385	4m53s	762ms
	17	374	4m19s	693ms
	18	229	2m38s	691ms
	19	330	3m46s	685ms
	20	245	2m47s	684ms
	21	90	58s927ms	654ms
	22	4	2s572ms	643ms

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 ('%%s344446%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%s-344446-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%s-344446-%'))) 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: 2024-02-16 16:06:09 Duration: 2s793ms
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 ('%%krw7%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%krw7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%krw7%'))) 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: 2024-02-16 13:29:16 Duration: 2s640ms
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 ('%%krw71%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%krw71%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%krw71%'))) 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: 2024-02-16 13:29:17 Duration: 2s414ms

3

3,085

Details

19m13s

340ms

1s421ms

373ms

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 #3

Day	Hour	Count	Duration	Avg duration
Feb 16	00	7	2s426ms	346ms
	01	6	2s92ms	348ms
	02	9	3s126ms	347ms
	05	3	1s26ms	342ms
	09	26	9s553ms	367ms
	10	29	10s300ms	355ms
	11	37	12s926ms	349ms
	12	250	1m30s	361ms
	13	472	3m4s	390ms
	14	399	2m31s	380ms
	15	296	1m51s	377ms
	16	399	2m34s	386ms
	17	164	1m	370ms
	18	278	1m42s	367ms
	19	357	2m10s	365ms
	20	223	1m20s	360ms
	21	113	39s921ms	353ms
	22	17	5s867ms	345ms

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

Date: 2024-02-16 13:43:35 Duration: 1s421ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-16 16:24:32 Duration: 1s321ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-df4ccbc/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-16 12:44:26 Duration: 1s276ms

4

1,642

Details

4m31s

123ms

741ms

165ms

select min("account_move".id) as id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" AS "debit_origin_id" from "account_move" left join "account_move" AS "account_move__debit_origin_id" on ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") where ("account_move"."debit_origin_id" in (...)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) group by "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" order by "account_move__debit_origin_id"."invoice_date_due";

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 16	00	1	170ms	170ms
	02	1	231ms	231ms
	05	1	147ms	147ms
	09	2	254ms	127ms
	10	15	2s112ms	140ms
	11	1	131ms	131ms
	12	64	10s20ms	156ms
	13	225	38s881ms	172ms
	14	266	43s782ms	164ms
	15	195	31s607ms	162ms
	16	251	43s653ms	173ms
	17	243	39s994ms	164ms
	18	192	30s848ms	160ms
	19	89	14s352ms	161ms
	20	67	10s962ms	163ms
	21	25	3s797ms	151ms
	22	4	583ms	145ms

SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1210318)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";

Date: 2024-02-16 13:12:33 Duration: 741ms
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1211973)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";

Date: 2024-02-16 17:01:00 Duration: 670ms
SELECT min("account_move".id) AS id, count("account_move".id) AS "debit_origin_id_count", "account_move"."debit_origin_id" as "debit_origin_id" FROM "account_move" LEFT JOIN "account_move" AS "account_move__debit_origin_id" ON ("account_move"."debit_origin_id" = "account_move__debit_origin_id"."id") WHERE ("account_move"."debit_origin_id" in (1210469)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) GROUP BY "account_move"."debit_origin_id", "account_move__debit_origin_id"."invoice_date_due" ORDER BY "account_move__debit_origin_id"."invoice_date_due";

Date: 2024-02-16 13:33:12 Duration: 661ms

5

1,526

Details

5m7s

175ms

1s69ms

201ms

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 #5

Day	Hour	Count	Duration	Avg duration
Feb 16	00	2	359ms	179ms
	09	1	182ms	182ms
	10	7	1s274ms	182ms
	11	14	2s633ms	188ms
	12	89	17s208ms	193ms
	13	225	48s113ms	213ms
	14	187	38s444ms	205ms
	15	158	32s319ms	204ms
	16	310	1m2s	202ms
	17	212	41s960ms	197ms
	18	168	33s67ms	196ms
	19	80	15s523ms	194ms
	20	42	7s933ms	188ms
	21	31	5s742ms	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 ('%STUTZ%') OR unaccent (res_partner.display_name) ilike unaccent ('%STUTZ%') OR unaccent (res_partner.ref) ilike unaccent ('%STUTZ%') OR unaccent (res_partner.vat) ilike unaccent ('STUTZ')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%STUTZ%') desc, unaccent (res_partner.display_name);

Date: 2024-02-16 15:34:52 Duration: 1s69ms
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 ('%T-05764%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-05764%') OR unaccent (res_partner.ref) ilike unaccent ('%T-05764%') OR unaccent (res_partner.vat) ilike unaccent ('T-05764')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-05764%') desc, unaccent (res_partner.display_name);

Date: 2024-02-16 13:03:59 Duration: 997ms
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 ('%keane fr%') OR unaccent (res_partner.display_name) ilike unaccent ('%keane fr%') OR unaccent (res_partner.ref) ilike unaccent ('%keane fr%') OR unaccent (res_partner.vat) ilike unaccent ('keanefr')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%keane fr%') desc, unaccent (res_partner.display_name);

Date: 2024-02-16 13:29:15 Duration: 937ms

6

1,501

Details

3m25s

120ms

535ms

136ms

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 #6

Day	Hour	Count	Duration	Avg duration
Feb 16	12	137	17s934ms	130ms
	13	383	52s843ms	137ms
	14	208	29s280ms	140ms
	15	167	22s288ms	133ms
	16	145	20s564ms	141ms
	17	93	12s433ms	133ms
	18	72	9s677ms	134ms
	19	161	22s509ms	139ms
	20	129	16s863ms	130ms
	21	6	758ms	126ms

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

Date: 2024-02-16 19:27:01 Duration: 535ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 35) AND ("product_warehouse_inventory"."product_id" = 180739)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;

Date: 2024-02-16 14:28:40 Duration: 502ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."warehouse_id" = 35) AND ("product_warehouse_inventory"."product_id" = 203986)) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 1;

Date: 2024-02-16 19:27:01 Duration: 448ms

7

1,147

Details

3m

134ms

597ms

157ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 16	01	11	1s604ms	145ms
	02	3	436ms	145ms
	12	61	9s729ms	159ms
	13	146	22s978ms	157ms
	14	176	27s957ms	158ms
	15	110	18s591ms	169ms
	16	161	25s430ms	157ms
	17	176	27s607ms	156ms
	18	110	17s131ms	155ms
	19	86	12s820ms	149ms
	20	85	12s636ms	148ms
	21	21	3s47ms	145ms
	22	1	139ms	139ms

UPDATE "stock_quant" SET "reserved_quantity" = 2.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (434528, 233545, 344093, 224695);

Date: 2024-02-16 15:33:04 Duration: 597ms
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 1022, "write_date" = (now() at time zone 'UTC') WHERE id IN (429104, 323226, 363259, 431487);

Date: 2024-02-16 12:52:25 Duration: 587ms
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (435792, 435800, 266084, 435791);

Date: 2024-02-16 17:20:24 Duration: 579ms

8

1,123

Details

3m51s

171ms

1s277ms

205ms

select min("sale_report".id) as id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" AS "product_id" from "sale_report" left join "product_product" AS "sale_report__product_id" on ("sale_report"."product_id" = "sale_report__product_id"."id") left join "product_template" AS "sale_report__product_id__product_tmpl_id" on ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") left join "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" on ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" and "sale_report__product_id__product_tmpl_id__name"."type" = ? and "sale_report__product_id__product_tmpl_id__name"."name" = ? and "sale_report__product_id__product_tmpl_id__name"."lang" = ? and "sale_report__product_id__product_tmpl_id__name"."value" != ?) where ((("sale_report"."state" in (...)) and ("sale_report"."product_id" in (...))) and ("sale_report"."date" >= ?)) and ("sale_report"."company_id" is null or ("sale_report"."company_id" in (...))) group by "sale_report"."product_id", "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" order by "sale_report__product_id"."default_code", coalesce("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 16	00	4	713ms	178ms
	01	3	523ms	174ms
	02	3	698ms	232ms
	12	69	13s599ms	197ms
	13	198	43s695ms	220ms
	14	130	26s896ms	206ms
	15	151	31s371ms	207ms
	16	143	30s825ms	215ms
	17	87	16s912ms	194ms
	18	123	25s99ms	204ms
	19	120	23s391ms	194ms
	20	72	13s822ms	191ms
	21	19	3s470ms	182ms
	22	1	177ms	177ms

SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (178969))) AND ("sale_report"."date" >= '2023-02-16 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";

Date: 2024-02-16 13:19:53 Duration: 1s277ms
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (178969))) AND ("sale_report"."date" >= '2023-02-16 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";

Date: 2024-02-16 13:22:58 Duration: 893ms
SELECT min("sale_report".id) AS id, count("sale_report".id) AS "product_id_count", sum("sale_report"."product_uom_qty") AS "product_uom_qty", "sale_report"."product_id" as "product_id" FROM "sale_report" LEFT JOIN "product_product" AS "sale_report__product_id" ON ("sale_report"."product_id" = "sale_report__product_id"."id") LEFT JOIN "product_template" AS "sale_report__product_id__product_tmpl_id" ON ("sale_report__product_id"."product_tmpl_id" = "sale_report__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "sale_report__product_id__product_tmpl_id__name" ON ("sale_report__product_id__product_tmpl_id"."id" = "sale_report__product_id__product_tmpl_id__name"."res_id" AND "sale_report__product_id__product_tmpl_id__name"."type" = 'model' AND "sale_report__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "sale_report__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "sale_report__product_id__product_tmpl_id__name"."value" != '') WHERE ((("sale_report"."state" in ('sale', 'done', 'paid')) AND ("sale_report"."product_id" in (208564))) AND ("sale_report"."date" >= '2023-02-16 00:00:00')) AND ("sale_report"."company_id" IS NULL OR ("sale_report"."company_id" in (1))) GROUP BY "sale_report"."product_id", "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id" ORDER BY "sale_report__product_id"."default_code", COALESCE("sale_report__product_id__product_tmpl_id__name"."value", "sale_report__product_id__product_tmpl_id"."name"), "sale_report__product_id"."id";

Date: 2024-02-16 16:08:53 Duration: 869ms

9

1,067

Details

2m57s

133ms

2s697ms

166ms

select count(?) from mail_tracking_value v left join mail_message m on (v.mail_message_id = m.id) join purchase_order po on (po.id = m.res_id) where m.create_date >= ? and m.model = ? and m.message_type = ? and v.old_value_char = ? and v.new_value_char = ? and po.company_id = ?;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 16	11	2	2s915ms	1s457ms
	12	35	6s633ms	189ms
	13	107	18s118ms	169ms
	14	46	8s884ms	193ms
	15	112	17s217ms	153ms
	16	262	46s350ms	176ms
	17	212	32s896ms	155ms
	18	162	24s848ms	153ms
	19	68	10s79ms	148ms
	20	43	6s946ms	161ms
	21	18	2s748ms	152ms

SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-09 11:58:28' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;

Date: 2024-02-16 11:58:31 Duration: 2s697ms
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-09 16:38:38' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;

Date: 2024-02-16 16:38:39 Duration: 932ms
SELECT COUNT(1) FROM mail_tracking_value v LEFT JOIN mail_message m ON (v.mail_message_id = m.id) JOIN purchase_order po ON (po.id = m.res_id) WHERE m.create_date >= '2024-02-09 16:53:23' AND m.model = 'purchase.order' AND m.message_type = 'notification' AND v.old_value_char = 'RFQ' AND v.new_value_char = 'RFQ Sent' AND po.company_id = 1;

Date: 2024-02-16 16:53:24 Duration: 764ms

10

888

Details

4m16s

244ms

1s117ms

288ms

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 #10

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	579ms	579ms
	10	10	3s92ms	309ms
	12	28	8s439ms	301ms
	13	120	34s923ms	291ms
	14	190	54s638ms	287ms
	15	147	42s25ms	285ms
	16	103	30s289ms	294ms
	17	80	23s643ms	295ms
	18	66	18s255ms	276ms
	19	69	19s769ms	286ms
	20	46	13s424ms	291ms
	21	27	6s953ms	257ms
	22	1	261ms	261ms

UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 100.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (340185, 340187, 340181, 340182);

Date: 2024-02-16 17:04:53 Duration: 1s117ms
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" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (329463, 329475, 329462, 329467);

Date: 2024-02-16 19:17:40 Duration: 1s98ms
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 4.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (337937, 337962, 337963, 337940);

Date: 2024-02-16 20:41:43 Duration: 1s54ms

11

887

Details

3m38s

218ms

914ms

246ms

select "sale_line_report".id from "sale_line_report" where ("sale_line_report"."real_line_id" in (...)) order by "sale_line_report"."id";

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 16	02	3	688ms	229ms
	12	136	32s586ms	239ms
	13	148	37s97ms	250ms
	14	103	26s346ms	255ms
	15	70	17s430ms	249ms
	16	52	13s564ms	260ms
	17	65	15s658ms	240ms
	18	144	36s135ms	250ms
	19	70	16s499ms	235ms
	20	46	10s793ms	234ms
	21	49	11s261ms	229ms
	22	1	228ms	228ms

SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (341000)) ORDER BY "sale_line_report"."id";

Date: 2024-02-16 14:18:53 Duration: 914ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (341321)) ORDER BY "sale_line_report"."id";

Date: 2024-02-16 16:36:07 Duration: 840ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (341310)) ORDER BY "sale_line_report"."id";

Date: 2024-02-16 16:27:10 Duration: 447ms

12

863

Details

4m5s

245ms

1s439ms

284ms

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 #12

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	326ms	326ms
	10	10	2s992ms	299ms
	12	24	7s90ms	295ms
	13	112	31s251ms	279ms
	14	200	58s530ms	292ms
	15	140	40s277ms	287ms
	16	111	33s326ms	300ms
	17	74	20s206ms	273ms
	18	58	15s608ms	269ms
	19	62	16s544ms	266ms
	20	45	12s263ms	272ms
	21	25	6s596ms	263ms
	22	1	266ms	266ms

UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '356.60', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (341135);

Date: 2024-02-16 15:15:35 Duration: 1s439ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '4.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '3.40', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (341021);

Date: 2024-02-16 14:28:41 Duration: 1s6ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '10.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '11.10', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (340678);

Date: 2024-02-16 14:50:02 Duration: 982ms

13

818

Details

11m49s

792ms

2s638ms

867ms

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
Feb 16	00	1	820ms	820ms
	11	1	824ms	824ms
	12	52	44s696ms	859ms
	13	125	1m49s	875ms
	14	75	1m5s	867ms
	15	136	1m57s	865ms
	16	103	1m31s	886ms
	17	67	56s781ms	847ms
	18	101	1m26s	859ms
	19	98	1m26s	881ms
	20	49	41s857ms	854ms
	21	9	7s374ms	819ms
	22	1	836ms	836ms

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 ('%tci-a-sda4515%')) 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 ('%tci-a-sda4515%'))) 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 ('%tci-a-sda4515%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%tci-a-sda4515%')))))) 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: 2024-02-16 19:27:03 Duration: 2s638ms
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 ('%489x%')) 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 ('%489x%'))) 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 ('%489x%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%489x%')))))) 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: 2024-02-16 16:42:01 Duration: 2s462ms
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 ('%e-6028l%')) 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 ('%e-6028l%'))) 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 ('%e-6028l%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%e-6028l%')))))) 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: 2024-02-16 12:57:10 Duration: 2s108ms

14

763

Details

9m

622ms

1s607ms

708ms

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"."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 #14

Day	Hour	Count	Duration	Avg duration
Feb 16	12	42	28s246ms	672ms
	13	85	59s21ms	694ms
	14	121	1m24s	700ms
	15	168	2m1s	721ms
	16	174	2m5s	722ms
	17	29	20s204ms	696ms
	18	68	48s453ms	712ms
	19	31	23s78ms	744ms
	20	33	22s282ms	675ms
	21	12	7s752ms	646ms

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 ('%%GAFF%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%GAFF%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%GAFF%'))) 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: 2024-02-16 15:15:35 Duration: 1s607ms
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 ('%%65418911%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-1891-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6.5-4-1891-1%'))) 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: 2024-02-16 16:36:07 Duration: 1s381ms
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 ('%%373%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%373%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%373%'))) 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: 2024-02-16 18:34:46 Duration: 1s141ms

15

762

Details

7m45s

149ms

3s564ms

611ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	437ms	437ms
	10	5	2s682ms	536ms
	12	23	12s694ms	551ms
	13	141	1m23s	595ms
	14	178	1m42s	577ms
	15	84	1m1s	727ms
	16	87	57s694ms	663ms
	17	56	33s520ms	598ms
	18	48	29s232ms	609ms
	19	65	40s41ms	616ms
	20	54	30s513ms	565ms
	21	19	10s877ms	572ms
	22	1	449ms	449ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (434464, 434471, 433800, 436008, 42291, 434461, 434462, 434463);

Date: 2024-02-16 16:11:47 Duration: 3s564ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 980, "write_date" = (now() at time zone 'UTC') WHERE id IN (217634, 431909, 423287, 423288, 244153);

Date: 2024-02-16 17:01:48 Duration: 3s476ms
UPDATE "stock_quant" SET "quantity" = 1.0, "reserved_quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (434600, 225381, 209246, 304999);

Date: 2024-02-16 15:46:13 Duration: 3s152ms

16

705

Details

5m57s

140ms

4s90ms

507ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 16	10	3	1s58ms	352ms
	12	7	1s968ms	281ms
	13	80	30s643ms	383ms
	14	120	39s673ms	330ms
	15	84	42s144ms	501ms
	16	118	1m12s	615ms
	17	121	56s661ms	468ms
	18	65	53s355ms	820ms
	19	49	28s682ms	585ms
	20	38	18s20ms	474ms
	21	20	12s966ms	648ms

UPDATE "stock_quant" SET "quantity" = 3.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (434528, 432230, 1256, 185065, 356937, 354990, 2000, 818, 258388);

Date: 2024-02-16 18:46:25 Duration: 4s90ms
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (434530, 434532, 309712, 224690, 351414, 172598, 303318, 302170);

Date: 2024-02-16 18:46:39 Duration: 3s592ms
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (185059, 432229, 277384, 366602, 330474, 364123, 1980);

Date: 2024-02-16 18:46:29 Duration: 3s205ms

17

663

Details

1m44s

134ms

487ms

157ms

update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 16	13	3	563ms	187ms
	15	49	7s448ms	152ms
	16	302	49s270ms	163ms
	17	142	22s718ms	159ms
	19	28	4s111ms	146ms
	20	139	20s417ms	146ms

update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (215340) and warehouse_id = (42));

Date: 2024-02-16 16:17:49 Duration: 487ms
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (215417) and warehouse_id = (42));

Date: 2024-02-16 16:17:50 Duration: 439ms
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (214174) and warehouse_id = (38));

Date: 2024-02-16 17:13:59 Duration: 258ms

18

615

Details

5m27s

140ms

10s64ms

532ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 16	01	1	1s499ms	1s499ms
	02	2	302ms	151ms
	12	28	11s516ms	411ms
	13	106	1m	568ms
	14	100	57s137ms	571ms
	15	64	31s287ms	488ms
	16	76	48s793ms	642ms
	17	55	17s539ms	318ms
	18	51	26s597ms	521ms
	19	69	33s347ms	483ms
	20	48	33s554ms	699ms
	21	14	5s392ms	385ms
	22	1	147ms	147ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (817992, 817994, 817995, 817996, 817997, 817998, 817999, 818000, 818001, 818003, 818005, 818006, 818007, 818008, 818009, 818012, 818013, 818014, 818016);

Date: 2024-02-16 20:04:40 Duration: 10s64ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (801024, 801025, 801026, 793097, 261392, 801040, 801041, 801043, 802576, 811155, 802584, 811161, 811163, 802591, 814879, 802594, 793000, 793130, 802604, 793005, 799278, 793006, 802615, 793015, 802619, 811072, 802628, 801787, 802633, 785099, 802635, 811086, 785104, 811091, 802644, 802646, 811096, 811097, 811100, 800996, 800997, 800998, 800999, 790504, 801000, 801001, 811109, 767596, 801004, 811114, 261364, 801019);

Date: 2024-02-16 18:47:18 Duration: 9s801ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (817379, 817380, 817382, 817384, 817385, 817386, 817387, 817388, 817389, 817390, 817392, 817393, 817394, 817395, 817396, 817397, 817398);

Date: 2024-02-16 16:04:39 Duration: 8s560ms

19

600

Details

1m21s

120ms

370ms

135ms

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 #19

Day	Hour	Count	Duration	Avg duration
Feb 16	12	25	3s276ms	131ms
	13	106	14s868ms	140ms
	14	88	12s11ms	136ms
	15	117	15s903ms	135ms
	16	94	12s726ms	135ms
	17	38	4s994ms	131ms
	18	60	8s147ms	135ms
	19	43	5s627ms	130ms
	20	24	3s273ms	136ms
	21	5	645ms	129ms

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

Date: 2024-02-16 13:00:18 Duration: 370ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (199723)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2024-02-16 15:36:17 Duration: 274ms
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_tmpl_id" in (210879)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2024-02-16 13:37:50 Duration: 256ms

20

569

Details

8m43s

306ms

3s542ms

919ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	757ms	757ms
	10	5	3s983ms	796ms
	12	14	12s529ms	894ms
	13	69	1m4s	939ms
	14	143	2m7s	894ms
	15	68	1m6s	983ms
	16	79	1m15s	961ms
	17	41	36s514ms	890ms
	18	47	42s572ms	905ms
	19	44	38s714ms	879ms
	20	31	23s990ms	773ms
	21	27	28s685ms	1s62ms

UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-02-16 15:34:32', "is_done" = true, "state" = 'done', "write_uid" = 964, "write_date" = (now() at time zone 'UTC') WHERE id IN (807984, 807986, 807994);

Date: 2024-02-16 15:34:42 Duration: 3s542ms
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-16 16:05:16', "is_done" = true, "state" = 'done', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (817393, 817394, 817395, 817382);

Date: 2024-02-16 16:05:50 Duration: 2s921ms
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2024-02-16 14:38:17', "is_done" = true, "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (808027, 808028);

Date: 2024-02-16 14:38:36 Duration: 2s770ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

1s449ms

3m23s

12s386ms

75

Details

15m28s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 16	06	12	1m9s	5s762ms
	13	4	4m49s	1m12s
	14	1	3s163ms	3s163ms
	15	14	3m27s	14s821ms
	16	6	22s494ms	3s749ms
	17	10	28s623ms	2s862ms
	18	7	2m50s	24s420ms
	19	6	24s235ms	4s39ms
	20	1	4s467ms	4s467ms
	21	2	10s227ms	5s113ms
	23	12	1m38s	8s230ms

DELETE FROM account_move_line WHERE id IN (4216192, 4216193, 4216194, 4216195, 4216196, 4216197, 4216198, 4216199, 4216200, 4216201, 4216202, 4216203, 4216204, 4216205, 4216206, 4216207, 4216208, 4216209, 4216210, 4216211, 4216212, 4216213, 4216214, 4216215, 4216216, 4216217, 4216218, 4216219, 4216220, 4216221, 4216222, 4216223, 4216224, 4216225, 4216226, 4216227, 4216228, 4216229, 4216230, 4216231, 4216232, 4216233, 4216234, 4216235, 4216236, 4216237, 4216238, 4216239, 4216240, 4216241, 4216242, 4216243, 4216244, 4216245, 4216246, 4216247, 4216248, 4216249, 4216250, 4216251, 4216252, 4216253, 4216254, 4216255, 4216256, 4216257, 4216258, 4216259, 4216260, 4216261, 4216262, 4216263, 4216264, 4216265, 4216266, 4216267, 4216268, 4216269, 4216270, 4216271, 4216272, 4216273, 4216274, 4216275, 4216276, 4216277, 4216278, 4216279, 4216280, 4216281, 4216282, 4216283, 4216284, 4216285, 4216286, 4216287, 4216288, 4216289, 4216290, 4216291, 4216292, 4216293, 4216294, 4216295, 4216296, 4216297, 4216298, 4216299, 4216300, 4216301, 4216302, 4216303, 4216304, 4216305, 4216306, 4216307, 4216308, 4216309, 4216310, 4216311, 4216312, 4216313, 4216314, 4216315, 4216316, 4216317, 4216318, 4216319, 4216320, 4216321);

Date: 2024-02-16 13:52:40 Duration: 3m23s
DELETE FROM account_move_line WHERE id IN (4223496, 4223497, 4223498, 4223499, 4223500, 4223501, 4223502, 4223503, 4223504, 4223505, 4223506, 4223507, 4223508, 4223509, 4223510, 4223511, 4223512, 4223513, 4223514, 4223515, 4223516, 4223517, 4223518, 4223519, 4223520, 4223521, 4223522, 4223523, 4223524, 4223525, 4223526, 4223527, 4223528, 4223529, 4223530, 4223531, 4223532, 4223533, 4223534, 4223535, 4223536, 4223537, 4223538, 4223539, 4223540, 4223541, 4223542, 4223543, 4223544, 4223545, 4223546, 4223547, 4223548, 4223549, 4223550, 4223551, 4223552, 4223553, 4223554, 4223555, 4223556, 4223557, 4223558, 4223559, 4223560, 4223561, 4223562, 4223563, 4223564, 4223565, 4223566, 4223567, 4223568, 4223569, 4223570, 4223571, 4223572, 4223573, 4223574, 4223575, 4223576, 4223577, 4223578, 4223579, 4223580, 4223581, 4223582, 4223583, 4223584, 4223585, 4223586, 4223587, 4223588, 4223589, 4223590, 4223591, 4223592);

Date: 2024-02-16 18:56:34 Duration: 2m26s
DELETE FROM account_move_line WHERE id IN (4216365, 4216368, 4216369, 4216370, 4216372, 4216373, 4216374, 4216375, 4216376, 4216378, 4216380, 4216382, 4216383, 4216387, 4216388, 4216389, 4216390, 4216394, 4216395, 4216396, 4216400, 4216401, 4216410, 4216417, 4216418, 4216425, 4216426, 4216428, 4216430, 4216435, 4216437, 4216444, 4216447, 4216449, 4216451, 4216452, 4216456, 4216458, 4216459, 4216462, 4216463, 4216465, 4216467, 4216468, 4216470, 4216475, 4216476, 4216477, 4216489, 4216490);

Date: 2024-02-16 15:27:14 Duration: 1m17s

2

4s559ms

20s477ms

6s22ms

52

Details

5m13s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 16	12	3	14s371ms	4s790ms
	13	9	45s791ms	5s87ms
	14	8	49s745ms	6s218ms
	15	3	35s12ms	11s670ms
	16	4	24s556ms	6s139ms
	17	5	28s650ms	5s730ms
	18	12	58s688ms	4s890ms
	19	6	37s778ms	6s296ms
	20	1	14s33ms	14s33ms
	21	1	4s562ms	4s562ms

DELETE FROM sale_order_line WHERE id IN (341154, 341155, 341156, 341157);

Date: 2024-02-16 15:43:23 Duration: 20s477ms
DELETE FROM sale_order_line WHERE id IN (325698, 325699, 325700);

Date: 2024-02-16 20:33:14 Duration: 14s33ms
DELETE FROM sale_order_line WHERE id IN (337561, 337565);

Date: 2024-02-16 14:14:55 Duration: 10s148ms

3

151ms

56s610ms

3s886ms

151

Details

9m46s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 16	10	1	754ms	754ms
	12	2	1s572ms	786ms
	13	14	34s874ms	2s491ms
	14	24	56s669ms	2s361ms
	15	17	51s805ms	3s47ms
	16	22	1m49s	4s995ms
	17	25	2m41s	6s467ms
	18	18	1m33s	5s210ms
	19	10	37s996ms	3s799ms
	20	15	33s88ms	2s205ms
	21	3	4s665ms	1s555ms

UPDATE "stock_move" SET "date" = '2024-02-16 18:45:00', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (809472, 809473, 809474, 809475, 809476, 809477, 809478, 809479, 809480, 809481, 809482, 809483, 809484, 809485, 809486, 809487, 809488, 809489, 809490, 809491, 809492, 809493, 809494, 809495, 809496, 809497, 809498, 809499, 809500, 809501, 809502, 809503, 809505, 809507, 809508, 809509, 809510, 809512, 809513, 809514, 809515, 809516, 809517, 809518, 809519, 809520, 809521, 809522, 809523, 809447, 809448, 809449, 809450, 809451, 809452, 809453, 809454, 809455, 809456, 809457, 809458, 809459, 809460, 809461, 809462, 809463, 809464, 809465, 809466, 809467, 809469, 809470, 809471);

Date: 2024-02-16 18:45:56 Duration: 56s610ms
UPDATE "stock_move" SET "date" = '2024-02-16 15:46:19', "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (817300, 817301, 817303, 817304, 817305, 817306, 817307, 817308, 817309, 817310, 817311, 817312, 817313, 817314, 817315, 817316, 817317, 817318, 817319, 817320, 817321);

Date: 2024-02-16 15:46:39 Duration: 19s673ms
UPDATE "stock_move" SET "date" = '2024-02-16 16:08:15', "state" = 'done', "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (814048, 814049, 814050, 814051, 814052, 814053, 814054, 814055, 814056, 814057, 814058, 814059, 814060, 814061, 814062, 814063, 814064, 814065, 814066, 814067, 814068, 814069, 814070);

Date: 2024-02-16 16:08:34 Duration: 18s990ms

4

145ms

15s100ms

1s218ms

292

Details

5m55s

update "stock_move" set "branch_id" = ?, "picking_id" = ?, "related_core_purchase_line_id" = ?, "related_core_repair_line_id" = ?, "related_core_sale_line_id" = ?, "scrapped" = false, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 16	01	1	6s572ms	6s572ms
	02	3	1s348ms	449ms
	10	1	171ms	171ms
	12	20	30s129ms	1s506ms
	13	52	1m2s	1s203ms
	14	49	1m12s	1s478ms
	15	29	51s172ms	1s764ms
	16	28	20s744ms	740ms
	17	26	23s866ms	917ms
	18	23	19s929ms	866ms
	19	30	34s586ms	1s152ms
	20	21	22s606ms	1s76ms
	21	8	9s206ms	1s150ms
	22	1	478ms	478ms

UPDATE "stock_move" SET "branch_id" = 40, "picking_id" = 345752, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (817313, 817315, 817317, 817318, 817319, 817320, 817321, 817300, 817302, 817303, 817304, 817305, 817306, 817307, 817308, 817311);

Date: 2024-02-16 15:43:02 Duration: 15s100ms
UPDATE "stock_move" SET "branch_id" = 40, "picking_id" = 346156, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (817971, 817972, 817973, 817974, 817975, 817976, 817977, 817978, 817979, 817980, 817981, 817982);

Date: 2024-02-16 19:59:52 Duration: 9s967ms
UPDATE "stock_move" SET "branch_id" = 45, "picking_id" = 345531, "related_core_purchase_line_id" = NULL, "related_core_repair_line_id" = NULL, "related_core_sale_line_id" = NULL, "scrapped" = false, "state" = 'confirmed', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (816941, 816942, 816943, 816944, 816945, 816946, 816947, 816948, 816949, 816950, 816951, 816952, 816953);

Date: 2024-02-16 14:03:22 Duration: 7s955ms

5

149ms

8s669ms

1s172ms

234

Details

4m34s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 16	10	1	746ms	746ms
	12	11	11s949ms	1s86ms
	13	47	50s321ms	1s70ms
	14	38	36s325ms	955ms
	15	18	25s123ms	1s395ms
	16	28	41s434ms	1s479ms
	17	20	21s699ms	1s84ms
	18	19	26s779ms	1s409ms
	19	30	38s644ms	1s288ms
	20	16	13s876ms	867ms
	21	5	6s768ms	1s353ms
	22	1	731ms	731ms

UPDATE "stock_move" SET "date" = '2024-02-16 16:11:29', "is_done" = true, "state" = 'done', "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (807368, 807370, 807373, 807376, 807377, 807378, 807379, 807380, 807381, 807382, 807414);

Date: 2024-02-16 16:11:41 Duration: 8s669ms
UPDATE "stock_move" SET "date" = '2024-02-16 18:42:33', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (815904, 815898, 815900, 815902, 815903);

Date: 2024-02-16 18:42:48 Duration: 3s884ms
UPDATE "stock_move" SET "date" = '2024-02-16 15:25:45', "is_done" = true, "state" = 'done', "write_uid" = 952, "write_date" = (now() at time zone 'UTC') WHERE id IN (817248, 817250, 817251, 817247);

Date: 2024-02-16 15:25:56 Duration: 3s625ms

6

977ms

2s951ms

1s75ms

241

Details

4m19s

select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 16	11	2	1s995ms	997ms
	12	20	21s615ms	1s80ms
	13	35	36s971ms	1s56ms
	14	21	23s636ms	1s125ms
	15	16	19s732ms	1s233ms
	16	20	21s554ms	1s77ms
	17	43	47s964ms	1s115ms
	18	14	14s532ms	1s38ms
	19	1	1s51ms	1s51ms
	20	43	44s194ms	1s27ms
	21	21	20s966ms	998ms
	22	1	993ms	993ms
	23	4	3s930ms	982ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4519D%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4519D%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4519D%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4519D%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2024-02-16 17:56:43 Duration: 2s951ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4x.134%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4x.134%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4x.134%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4x.134%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2024-02-16 15:34:53 Duration: 2s771ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4519%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4519%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4519%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4519%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4519%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4519%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2024-02-16 17:56:40 Duration: 1s609ms

7

971ms

3s302ms

1s63ms

390

Details

6m54s

select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) 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"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 16	03	3	2s969ms	989ms
	09	3	2s979ms	993ms
	11	9	8s984ms	998ms
	12	39	40s405ms	1s36ms
	13	54	1m	1s111ms
	14	12	13s312ms	1s109ms
	15	36	41s377ms	1s149ms
	16	36	38s824ms	1s78ms
	17	66	1m11s	1s81ms
	18	27	28s142ms	1s42ms
	19	9	9s385ms	1s42ms
	20	39	39s561ms	1s14ms
	21	48	48s394ms	1s8ms
	22	6	5s913ms	985ms
	23	3	2s936ms	978ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%20-74-91%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%20-74-91%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%20-74-91%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%20-74-91%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%20-74-91%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%20-74-91%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2024-02-16 13:29:17 Duration: 3s302ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4519D%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4519D%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4519D%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4519D%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4519D%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2024-02-16 17:56:43 Duration: 3s97ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') 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"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%4x.134%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%4x.134%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%4x.134%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%4x.134%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%4x.134%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2024-02-16 15:34:52 Duration: 2s436ms

8

306ms

3s542ms

919ms

569

Details

8m43s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	757ms	757ms
	10	5	3s983ms	796ms
	12	14	12s529ms	894ms
	13	69	1m4s	939ms
	14	143	2m7s	894ms
	15	68	1m6s	983ms
	16	79	1m15s	961ms
	17	41	36s514ms	890ms
	18	47	42s572ms	905ms
	19	44	38s714ms	879ms
	20	31	23s990ms	773ms
	21	27	28s685ms	1s62ms

UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-02-16 15:34:32', "is_done" = true, "state" = 'done', "write_uid" = 964, "write_date" = (now() at time zone 'UTC') WHERE id IN (807984, 807986, 807994);

Date: 2024-02-16 15:34:42 Duration: 3s542ms
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-16 16:05:16', "is_done" = true, "state" = 'done', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (817393, 817394, 817395, 817382);

Date: 2024-02-16 16:05:50 Duration: 2s921ms
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2024-02-16 14:38:17', "is_done" = true, "state" = 'done', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (808027, 808028);

Date: 2024-02-16 14:38:36 Duration: 2s770ms

9

792ms

2s638ms

867ms

818

Details

11m49s

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 #9

Day	Hour	Count	Duration	Avg duration
Feb 16	00	1	820ms	820ms
	11	1	824ms	824ms
	12	52	44s696ms	859ms
	13	125	1m49s	875ms
	14	75	1m5s	867ms
	15	136	1m57s	865ms
	16	103	1m31s	886ms
	17	67	56s781ms	847ms
	18	101	1m26s	859ms
	19	98	1m26s	881ms
	20	49	41s857ms	854ms
	21	9	7s374ms	819ms
	22	1	836ms	836ms

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 ('%tci-a-sda4515%')) 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 ('%tci-a-sda4515%'))) 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 ('%tci-a-sda4515%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%tci-a-sda4515%')))))) 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: 2024-02-16 19:27:03 Duration: 2s638ms
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 ('%489x%')) 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 ('%489x%'))) 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 ('%489x%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%489x%')))))) 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: 2024-02-16 16:42:01 Duration: 2s462ms
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 ('%e-6028l%')) 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 ('%e-6028l%'))) 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 ('%e-6028l%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%e-6028l%')))))) 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: 2024-02-16 12:57:10 Duration: 2s108ms

10

273ms

6s915ms

845ms

305

Details

4m17s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 16	10	1	440ms	440ms
	12	4	2s507ms	626ms
	13	45	39s284ms	872ms
	14	28	22s871ms	816ms
	15	51	49s809ms	976ms
	16	77	1m9s	906ms
	17	13	7s582ms	583ms
	18	25	16s889ms	675ms
	19	20	15s352ms	767ms
	20	36	32s	888ms
	21	5	1s451ms	290ms

UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-16 15:33:24', "state" = 'done', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (809122, 809191, 809132, 809166, 809134, 809137, 809142, 817273, 809148);

Date: 2024-02-16 15:33:44 Duration: 6s915ms
UPDATE "stock_move" SET "current_warehouse_qty" = 1.0, "date" = '2024-02-16 19:17:21', "state" = 'done', "write_uid" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (802924, 802925, 802926, 802927, 802929);

Date: 2024-02-16 19:17:30 Duration: 4s181ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2024-02-16 20:47:03', "state" = 'done', "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (813755, 813756, 813757);

Date: 2024-02-16 20:47:08 Duration: 3s462ms

11

600ms

3s120ms

710ms

557

Details

6m35s

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"."purchase_ok" is not null and "product_product__product_tmpl_id"."purchase_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 #11

Day	Hour	Count	Duration	Avg duration
Feb 16	12	40	29s712ms	742ms
	13	47	33s916ms	721ms
	14	93	1m4s	693ms
	15	36	23s952ms	665ms
	16	38	32s308ms	850ms
	17	209	2m29s	714ms
	18	40	26s157ms	653ms
	19	20	13s471ms	673ms
	20	34	22s697ms	667ms

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 ('%%1842337C%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1842337C%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1842337C%'))) 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"."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: 2024-02-16 16:06:10 Duration: 3s120ms
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 ('%%1842337C9%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1842337C9%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1842337C9%'))) 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"."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: 2024-02-16 16:06:10 Duration: 2s542ms
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 ('%%1842337%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1842337%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%1842337%'))) 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"."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: 2024-02-16 16:06:08 Duration: 1s457ms

12

604ms

2s793ms

709ms

3,657

Details

43m13s

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 #12

Day	Hour	Count	Duration	Avg duration
Feb 16	01	64	41s356ms	646ms
	02	7	4s450ms	635ms
	10	5	3s402ms	680ms
	11	4	2s572ms	643ms
	12	278	3m14s	698ms
	13	717	8m42s	729ms
	14	519	6m14s	720ms
	15	406	4m44s	701ms
	16	385	4m53s	762ms
	17	374	4m19s	693ms
	18	229	2m38s	691ms
	19	330	3m46s	685ms
	20	245	2m47s	684ms
	21	90	58s927ms	654ms
	22	4	2s572ms	643ms

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 ('%%s344446%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%s-344446-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%s-344446-%'))) 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: 2024-02-16 16:06:09 Duration: 2s793ms
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 ('%%krw7%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%krw7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%krw7%'))) 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: 2024-02-16 13:29:16 Duration: 2s640ms
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 ('%%krw71%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%krw71%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%krw71%'))) 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: 2024-02-16 13:29:17 Duration: 2s414ms

13

622ms

1s607ms

708ms

763

Details

9m

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"."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 #13

Day	Hour	Count	Duration	Avg duration
Feb 16	12	42	28s246ms	672ms
	13	85	59s21ms	694ms
	14	121	1m24s	700ms
	15	168	2m1s	721ms
	16	174	2m5s	722ms
	17	29	20s204ms	696ms
	18	68	48s453ms	712ms
	19	31	23s78ms	744ms
	20	33	22s282ms	675ms
	21	12	7s752ms	646ms

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 ('%%GAFF%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%GAFF%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%GAFF%'))) 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: 2024-02-16 15:15:35 Duration: 1s607ms
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 ('%%65418911%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6.5-4-1891-1%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6.5-4-1891-1%'))) 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: 2024-02-16 16:36:07 Duration: 1s381ms
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 ('%%373%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%373%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%373%'))) 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: 2024-02-16 18:34:46 Duration: 1s141ms

14

149ms

3s564ms

611ms

762

Details

7m45s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	437ms	437ms
	10	5	2s682ms	536ms
	12	23	12s694ms	551ms
	13	141	1m23s	595ms
	14	178	1m42s	577ms
	15	84	1m1s	727ms
	16	87	57s694ms	663ms
	17	56	33s520ms	598ms
	18	48	29s232ms	609ms
	19	65	40s41ms	616ms
	20	54	30s513ms	565ms
	21	19	10s877ms	572ms
	22	1	449ms	449ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 968, "write_date" = (now() at time zone 'UTC') WHERE id IN (434464, 434471, 433800, 436008, 42291, 434461, 434462, 434463);

Date: 2024-02-16 16:11:47 Duration: 3s564ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 980, "write_date" = (now() at time zone 'UTC') WHERE id IN (217634, 431909, 423287, 423288, 244153);

Date: 2024-02-16 17:01:48 Duration: 3s476ms
UPDATE "stock_quant" SET "quantity" = 1.0, "reserved_quantity" = 0.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (434600, 225381, 209246, 304999);

Date: 2024-02-16 15:46:13 Duration: 3s152ms

15

140ms

10s64ms

532ms

615

Details

5m27s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 16	01	1	1s499ms	1s499ms
	02	2	302ms	151ms
	12	28	11s516ms	411ms
	13	106	1m	568ms
	14	100	57s137ms	571ms
	15	64	31s287ms	488ms
	16	76	48s793ms	642ms
	17	55	17s539ms	318ms
	18	51	26s597ms	521ms
	19	69	33s347ms	483ms
	20	48	33s554ms	699ms
	21	14	5s392ms	385ms
	22	1	147ms	147ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (817992, 817994, 817995, 817996, 817997, 817998, 817999, 818000, 818001, 818003, 818005, 818006, 818007, 818008, 818009, 818012, 818013, 818014, 818016);

Date: 2024-02-16 20:04:40 Duration: 10s64ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (801024, 801025, 801026, 793097, 261392, 801040, 801041, 801043, 802576, 811155, 802584, 811161, 811163, 802591, 814879, 802594, 793000, 793130, 802604, 793005, 799278, 793006, 802615, 793015, 802619, 811072, 802628, 801787, 802633, 785099, 802635, 811086, 785104, 811091, 802644, 802646, 811096, 811097, 811100, 800996, 800997, 800998, 800999, 790504, 801000, 801001, 811109, 767596, 801004, 811114, 261364, 801019);

Date: 2024-02-16 18:47:18 Duration: 9s801ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (817379, 817380, 817382, 817384, 817385, 817386, 817387, 817388, 817389, 817390, 817392, 817393, 817394, 817395, 817396, 817397, 817398);

Date: 2024-02-16 16:04:39 Duration: 8s560ms

16

140ms

4s90ms

507ms

705

Details

5m57s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 16	10	3	1s58ms	352ms
	12	7	1s968ms	281ms
	13	80	30s643ms	383ms
	14	120	39s673ms	330ms
	15	84	42s144ms	501ms
	16	118	1m12s	615ms
	17	121	56s661ms	468ms
	18	65	53s355ms	820ms
	19	49	28s682ms	585ms
	20	38	18s20ms	474ms
	21	20	12s966ms	648ms

UPDATE "stock_quant" SET "quantity" = 3.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (434528, 432230, 1256, 185065, 356937, 354990, 2000, 818, 258388);

Date: 2024-02-16 18:46:25 Duration: 4s90ms
UPDATE "stock_quant" SET "quantity" = 2.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (434530, 434532, 309712, 224690, 351414, 172598, 303318, 302170);

Date: 2024-02-16 18:46:39 Duration: 3s592ms
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 1003, "write_date" = (now() at time zone 'UTC') WHERE id IN (185059, 432229, 277384, 366602, 330474, 364123, 1980);

Date: 2024-02-16 18:46:29 Duration: 3s205ms

17

340ms

1s421ms

373ms

3,085

Details

19m13s

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 #17

Day	Hour	Count	Duration	Avg duration
Feb 16	00	7	2s426ms	346ms
	01	6	2s92ms	348ms
	02	9	3s126ms	347ms
	05	3	1s26ms	342ms
	09	26	9s553ms	367ms
	10	29	10s300ms	355ms
	11	37	12s926ms	349ms
	12	250	1m30s	361ms
	13	472	3m4s	390ms
	14	399	2m31s	380ms
	15	296	1m51s	377ms
	16	399	2m34s	386ms
	17	164	1m	370ms
	18	278	1m42s	367ms
	19	357	2m10s	365ms
	20	223	1m20s	360ms
	21	113	39s921ms	353ms
	22	17	5s867ms	345ms

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

Date: 2024-02-16 13:43:35 Duration: 1s421ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-16 16:24:32 Duration: 1s321ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-df4ccbc/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-16 12:44:26 Duration: 1s276ms

18

244ms

1s117ms

288ms

888

Details

4m16s

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 #18

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	579ms	579ms
	10	10	3s92ms	309ms
	12	28	8s439ms	301ms
	13	120	34s923ms	291ms
	14	190	54s638ms	287ms
	15	147	42s25ms	285ms
	16	103	30s289ms	294ms
	17	80	23s643ms	295ms
	18	66	18s255ms	276ms
	19	69	19s769ms	286ms
	20	46	13s424ms	291ms
	21	27	6s953ms	257ms
	22	1	261ms	261ms

UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 100.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (340185, 340187, 340181, 340182);

Date: 2024-02-16 17:04:53 Duration: 1s117ms
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" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (329463, 329475, 329462, 329467);

Date: 2024-02-16 19:17:40 Duration: 1s98ms
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 4.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1280, "write_date" = (now() at time zone 'UTC') WHERE id IN (337937, 337962, 337963, 337940);

Date: 2024-02-16 20:41:43 Duration: 1s54ms

19

245ms

1s439ms

284ms

863

Details

4m5s

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 #19

Day	Hour	Count	Duration	Avg duration
Feb 16	09	1	326ms	326ms
	10	10	2s992ms	299ms
	12	24	7s90ms	295ms
	13	112	31s251ms	279ms
	14	200	58s530ms	292ms
	15	140	40s277ms	287ms
	16	111	33s326ms	300ms
	17	74	20s206ms	273ms
	18	58	15s608ms	269ms
	19	62	16s544ms	266ms
	20	45	12s263ms	272ms
	21	25	6s596ms	263ms
	22	1	266ms	266ms

UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '356.60', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1037, "write_date" = (now() at time zone 'UTC') WHERE id IN (341135);

Date: 2024-02-16 15:15:35 Duration: 1s439ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '4.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '3.40', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (341021);

Date: 2024-02-16 14:28:41 Duration: 1s6ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '10.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '11.10', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1267, "write_date" = (now() at time zone 'UTC') WHERE id IN (340678);

Date: 2024-02-16 14:50:02 Duration: 982ms

20

218ms

914ms

246ms

887

Details

3m38s

select "sale_line_report".id from "sale_line_report" where ("sale_line_report"."real_line_id" in (...)) order by "sale_line_report"."id";

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 16	02	3	688ms	229ms
	12	136	32s586ms	239ms
	13	148	37s97ms	250ms
	14	103	26s346ms	255ms
	15	70	17s430ms	249ms
	16	52	13s564ms	260ms
	17	65	15s658ms	240ms
	18	144	36s135ms	250ms
	19	70	16s499ms	235ms
	20	46	10s793ms	234ms
	21	49	11s261ms	229ms
	22	1	228ms	228ms

SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (341000)) ORDER BY "sale_line_report"."id";

Date: 2024-02-16 14:18:53 Duration: 914ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (341321)) ORDER BY "sale_line_report"."id";

Date: 2024-02-16 16:36:07 Duration: 840ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (341310)) ORDER BY "sale_line_report"."id";

Date: 2024-02-16 16:27:10 Duration: 447ms

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

103,717 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	122	0.12%
DETAIL	87	0.08%
ERROR	1,428	1.38%
FATAL	20	0.02%
HINT	6	0.01%
LOG	100,547	96.94%
STATEMENT	1,507	1.45%

Events distribution

Key values

0 PANIC entries
20 FATAL entries
1428 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

669

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 16	00	40
	01	45
	02	56
	03	27
	04	20
	05	21
	06	45
	07	21
	08	23
	09	32
	10	23
	11	24
	12	22
	13	26
	14	22
	15	24
	16	23
	17	17
	18	24
	19	19
	20	23
	21	22
	22	20
	23	50

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

2

648

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 16	00	2
	01	2
	02	5
	04	1
	05	1
	09	6
	10	1
	11	10
	12	59
	13	109
	14	98
	15	63
	16	80
	17	68
	18	52
	19	39
	20	21
	21	25
	22	4
	23	2

ERROR: could not serialize access due to concurrent update

3

52

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 16	13	3
	14	12
	15	7
	16	7
	17	3
	18	17
	19	2
	21	1

ERROR: process 344850 still waiting for ShareLock on transaction 240357554 after 1000.042 ms
ERROR: process 283601 still waiting for ShareLock on transaction 240358205 after 1000.045 ms
ERROR: process 341300 still waiting for ShareLock on transaction 240363480 after 1000.049 ms

4

20

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 16	05	16
	07	3
	08	1

FATAL: connection to client lost

5

16

Details

LOG: could not send data to client: Connection reset by peer

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 16	05	16

ERROR: could not send data to client: Connection reset by peer

6

8

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 16	09	8

ERROR: process 3987505 still waiting for AccessExclusiveLock on relation 45666 of database 65946 after 1000.043 ms
ERROR: process 3987505 still waiting for AccessExclusiveLock on relation 3669985 of database 65946 after 1000.042 ms
ERROR: process 3987505 still waiting for AccessExclusiveLock on relation 45666 of database 65946 after 1000.045 ms

7

8

Details

ERROR: canceling statement due to lock timeout

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 16	09	8

ERROR: canceling statement due to lock timeout

8

7

Details

ERROR: null value in column "..." of relation "..." violates not-null constraint

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 16	12	4
	15	1
	16	2

ERROR: null value in column "model_id" of relation "fleet_vehicle" violates not-null constraint
ERROR: null value in column "name" of relation "sale_order_line" violates not-null constraint

9

6

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Feb 16	18	6

ERROR: deadlock detected
ERROR: deadlock detected
ERROR: deadlock detected

10

4

Details

LOG: could not send data to client: Connection timed out

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Feb 16	07	3
	08	1

ERROR: could not send data to client: Connection timed out

11

4

Details

ERROR: could not create unique index "..."

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Feb 16	09	2
	11	2

ERROR: could not create unique index "vendor_account_master_unique_acc_no"

12

4

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Feb 16	13	1
	14	1
	18	2

ERROR: process 335375 still waiting for ExclusiveLock on tuple (546,10) of relation 44820 of database 65946 after 1000.050 ms
ERROR: process 362461 still waiting for ExclusiveLock on tuple (546,10) of relation 44820 of database 65946 after 1000.044 ms
ERROR: process 3987408 still waiting for ExclusiveLock on tuple (3914,7) of relation 42418 of database 65946 after 1000.064 ms

13

2

Details

LOG: could not receive data from client: Connection reset by peer

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Feb 16	05	1
	09	1

ERROR: could not receive data from client: Connection reset by peer

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