pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed May 3 23:50:34 2023
Log file: /var/log/postgresql/postgresql-14-main.log
Parsed 143,081 log entries in 33s
Log start from 2023-05-02 00:00:07 to 2023-05-02 23:59:28

Global Stats

1,125 Number of unique normalized queries
51,722 Number of queries
5h43m35s Total query duration
2023-05-02 00:00:07 First query
2023-05-02 23:59:28 Last query
85 queries/s at 2023-05-02 13:17:13 Query peak

5h43m35s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
5h43m35s Execute total duration

1,612 Number of events
9 Number of unique normalized events
828 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
51,722 Average queries per session
5h43m35s 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

85 queries/s Query Peak
2023-05-02 13:17:13 Date

SELECT Traffic

Key values

85 queries/s Query Peak
2023-05-02 13:17:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

12 queries/s Query Peak
2023-05-02 14:17:31 Date

Queries duration

Key values

5h43m35s 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)
May 02	00	311	0ms	9s16ms	252ms	9s778ms	10s799ms	10s799ms
	01	209	0ms	276ms	156ms	7s214ms	7s786ms	7s786ms
	02	197	0ms	1s491ms	206ms	7s926ms	11s368ms	11s368ms
	03	210	0ms	266ms	154ms	10s476ms	10s476ms	10s476ms
	04	230	0ms	1s626ms	385ms	1m6s	1m6s	1m6s
	05	174	0ms	341ms	151ms	5s734ms	5s762ms	5s762ms
	06	458	0ms	3s609ms	448ms	12s73ms	18s190ms	22s400ms
	07	370	0ms	1s956ms	249ms	9s744ms	9s763ms	11s486ms
	08	364	0ms	6s833ms	349ms	9s232ms	13s861ms	22s382ms
	09	595	0ms	56s111ms	701ms	50s93ms	1m7s	1m26s
	10	406	0ms	1s932ms	593ms	11s354ms	37s64ms	44s620ms
	11	3,215	120ms	3s213ms	363ms	43s630ms	53s277ms	1m2s
	12	4,987	120ms	20s13ms	383ms	50s300ms	1m11s	1m36s
	13	6,346	120ms	13s690ms	380ms	1m3s	1m9s	1m50s
	14	6,005	120ms	12s1ms	379ms	57s965ms	1m11s	1m15s
	15	4,510	120ms	6s567ms	357ms	42s500ms	53s388ms	57s48ms
	16	3,548	120ms	9s193ms	396ms	45s289ms	46s475ms	1m12s
	17	4,605	120ms	10s149ms	434ms	56s502ms	1m11s	1m59s
	18	6,662	120ms	11s226ms	424ms	1m23s	1m38s	1m45s
	19	4,367	120ms	18s203ms	445ms	57s763ms	59s978ms	1m18s
	20	2,846	120ms	8s334ms	443ms	41s145ms	44s199ms	55s493ms
	21	491	120ms	5s139ms	456ms	11s342ms	11s849ms	17s831ms
	22	418	0ms	3s83ms	319ms	8s491ms	9s67ms	9s954ms
	23	198	0ms	13s407ms	229ms	10s382ms	15s187ms	15s187ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 02	00	270	0	185ms	5s869ms	8s95ms	9s778ms
	01	209	0	156ms	6s295ms	7s214ms	7s786ms
	02	197	0	206ms	6s44ms	7s926ms	11s368ms
	03	210	0	154ms	7s171ms	10s476ms	10s476ms
	04	230	0	385ms	7s209ms	1m6s	1m6s
	05	174	0	151ms	5s407ms	5s734ms	5s762ms
	06	440	4	449ms	8s280ms	12s73ms	22s400ms
	07	366	0	247ms	6s832ms	9s744ms	11s486ms
	08	354	0	292ms	4s961ms	6s176ms	14s224ms
	09	438	67	751ms	8s912ms	37s781ms	1m17s
	10	406	0	593ms	5s385ms	11s354ms	44s620ms
	11	2,029	0	385ms	23s270ms	29s506ms	33s522ms
	12	3,295	0	375ms	31s429ms	38s743ms	55s166ms
	13	4,020	0	389ms	39s718ms	44s132ms	1m11s
	14	3,877	0	368ms	33s703ms	36s410ms	48s189ms
	15	2,754	0	345ms	23s315ms	31s58ms	41s746ms
	16	2,046	0	358ms	17s759ms	22s309ms	37s771ms
	17	2,798	0	444ms	25s274ms	39s938ms	58s275ms
	18	3,773	0	400ms	32s830ms	48s930ms	1m
	19	2,162	0	409ms	20s69ms	25s198ms	36s62ms
	20	1,598	0	415ms	18s53ms	21s12ms	25s427ms
	21	335	0	468ms	6s958ms	7s572ms	11s342ms
	22	290	0	299ms	5s576ms	6s299ms	9s810ms
	23	196	0	154ms	4s227ms	4s837ms	10s382ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 02	00	0	29	11	702ms	924ms	2s344ms	10s799ms
	01	0	0	0	0ms	0ms	0ms	0ms
	02	0	0	0	0ms	0ms	0ms	0ms
	03	0	0	0	0ms	0ms	0ms	0ms
	04	0	0	0	0ms	0ms	0ms	0ms
	05	0	0	0	0ms	0ms	0ms	0ms
	06	0	14	0	422ms	0ms	0ms	1s462ms
	07	0	4	0	453ms	0ms	0ms	590ms
	08	0	3	2	975ms	0ms	0ms	1s324ms
	09	0	78	0	454ms	0ms	1s286ms	5s330ms
	10	0	0	0	0ms	0ms	0ms	0ms
	11	49	1,058	7	334ms	5s44ms	10s109ms	20s258ms
	12	92	1,465	27	414ms	9s72ms	15s908ms	27s787ms
	13	85	2,015	17	383ms	14s480ms	17s408ms	23s115ms
	14	119	1,787	16	415ms	12s207ms	18s952ms	29s706ms
	15	47	1,439	28	409ms	9s894ms	12s815ms	20s300ms
	16	31	1,282	34	480ms	8s247ms	15s109ms	33s847ms
	17	81	1,549	39	438ms	11s837ms	17s40ms	26s581ms
	18	133	2,550	44	474ms	20s233ms	30s511ms	54s902ms
	19	139	1,885	39	501ms	14s631ms	30s663ms	47s861ms
	20	23	1,057	28	517ms	8s288ms	16s334ms	33s20ms
	21	0	137	11	445ms	831ms	2s234ms	11s683ms
	22	14	113	1	365ms	790ms	2s196ms	7s331ms
	23	0	0	2	7s593ms	0ms	0ms	15s187ms

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

Day	Hour	Average / Second
May 02	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
May 02	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
May 02	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
May 02	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)
May 02	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
May 02	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
May 02	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
May 02	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
42 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		4	14s947ms	3s736ms
	tuple	4	14s947ms	3s736ms
ShareLock		38	1m39s	2s627ms
	transaction	38	1m39s	2s627ms
	Total	42	1m54s	2s733ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	32	1m22s	1s50ms	6s514ms	2s574ms	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 != 607101 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 != 607101 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; Date: 2023-05-02 11:55:55
2	6	18s302ms	1s234ms	5s742ms	3s50ms	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" = 2458448, "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (607285); Date: 2023-05-02 12:45:26
3	2	7s680ms	3s132ms	4s548ms	3s840ms	update "account_move" set "email_send_eod" = false, "email_sent" = true, "message_main_attachment_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "account_move" SET "email_send_eod" = false, "email_sent" = true, "message_main_attachment_id" = 2459338, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (607725); Date: 2023-05-02 14:05:01
4	1	4s288ms	4s288ms	4s288ms	4s288ms	update "stock_move_line" set "qty_done" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "stock_move_line" SET "qty_done" = '8.00', "write_uid" = 951, "write_date" = (now() at time zone 'UTC') WHERE id IN (389885); Date: 2023-05-02 19:29:04
5	1	2s150ms	2s150ms	2s150ms	2s150ms	update "account_move" set "access_token" = ?, "is_move_sent" = true, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "account_move" SET "access_token" = '54003e86-902c-439a-9801-652bcf116f1b', "is_move_sent" = true, "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (607720); Date: 2023-05-02 14:04:52

Queries that waited the most

Rank	Wait time	Query
1	6s514ms	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 != 607720 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 != 607720 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 14:05:01 ]
2	6s252ms	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 != 607716 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 != 607716 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 14:05:01 ]
3	5s742ms	UPDATE "account_move" SET "message_main_attachment_id" = 2458448, "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (607285); [ Date: 2023-05-02 12:45:26 ]
4	5s267ms	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 != 287674 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 != 287674 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 20:30:35 ]
5	4s548ms	UPDATE "account_move" SET "email_send_eod" = false, "email_sent" = true, "message_main_attachment_id" = 2459338, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (607725); [ Date: 2023-05-02 14:05:01 ]
6	4s288ms	UPDATE "stock_move_line" SET "qty_done" = '8.00', "write_uid" = 951, "write_date" = (now() at time zone 'UTC') WHERE id IN (389885); [ Date: 2023-05-02 19:29:04 ]
7	3s461ms	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 != 418451 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 != 418451 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 13:49:43 ]
8	3s405ms	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 != 607717 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 != 607717 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 14:04:30 ]
9	3s306ms	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 != 608936 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 != 608936 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 17:40:15 ]
10	3s300ms	UPDATE "account_move" SET "message_main_attachment_id" = 2459268, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (607695); [ Date: 2023-05-02 13:58:55 ]
11	3s236ms	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 != 607101 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 != 607101 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 11:55:55 ]
12	3s132ms	UPDATE "account_move" SET "email_send_eod" = false, "email_sent" = true, "message_main_attachment_id" = 2459751, "write_uid" = 981, "write_date" = (now() at time zone 'UTC') WHERE id IN (607984); [ Date: 2023-05-02 14:46:52 ]
13	3s74ms	UPDATE "account_move" SET "message_main_attachment_id" = 2460711, "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (608710); [ Date: 2023-05-02 17:05:19 ]
14	2s934ms	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 != 454511 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 != 454511 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 18:38:24 ]
15	2s787ms	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 != 609431 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 != 609431 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 19:04:23 ]
16	2s748ms	UPDATE "account_move" SET "message_main_attachment_id" = 2461281, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (609216); [ Date: 2023-05-02 18:30:07 ]
17	2s744ms	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 != 288073 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 != 288073 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 15:26:41 ]
18	2s737ms	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 != 446505 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 != 446505 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 18:16:28 ]
19	2s663ms	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 != 609876 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 != 609876 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 20:07:58 ]
20	2s600ms	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 != 607960 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 != 607960 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-05-02 14:43:42 ]

Queries by type

Key values

32,467 Total read queries
19,255 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	32,467	62.77%
INSERT	813	1.57%
UPDATE	16,465	31.83%
DELETE	306	0.59%
COPY FROM	0	0.00%
COPY TO	71	0.14%
CTE	1,600	3.09%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

unknown Main database
51,722 Requests
5h43m35s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	51,722	5h43m35s
	copy to	71	4m12s
	cte	1,600	5m14s
	delete	306	6m1s
	insert	813	4m19s
	select	32,467	3h25m4s
	update	16,465	1h58m43s

Queries by user

Key values

unknown Main user
51,734 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	51,734	5h43m39s
	copy to	71	4m12s
	cte	1,600	5m14s
	delete	306	6m1s
	insert	813	4m19s
	select	32,477	3h25m8s
	update	16,467	1h58m43s

Duration by user

Key values

5h43m39s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	51,734	5h43m39s
	copy to	71	4m12s
	cte	1,600	5m14s
	delete	306	6m1s
	insert	813	4m19s
	select	32,477	3h25m8s
	update	16,467	1h58m43s

Queries by host

Key values

unknown Main host
51,734 Requests
5h43m39s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	51,734	5h43m39s
	copy to	71	4m12s
	cte	1,600	5m14s
	delete	306	6m1s
	insert	813	4m19s
	select	32,477	3h25m8s
	update	16,467	1h58m43s

Queries by application

Key values

unknown Main application
51,722 Requests
5h43m35s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	51,722	5h43m35s
	copy to	71	4m12s
	cte	1,600	5m14s
	delete	306	6m1s
	insert	813	4m19s
	select	32,467	3h25m4s
	update	16,465	1h58m43s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2023-05-02 14:46:13 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

36,450 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	36,450	70.47%
500-1000ms	13,498	26.10%
1000-10000ms	1,746	3.38%
> 10000ms	28	0.05%

Slowest individual queries

Rank	Duration	Query
1	56s111ms	COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout; [ Date: 2023-05-02 09:01:39 ]
2	28s108ms	COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout; [ Date: 2023-05-02 09:02:10 ]
3	28s107ms	COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout; [ Date: 2023-05-02 09:02:38 ]
4	20s622ms	COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout; [ Date: 2023-05-02 09:03:32 ]
5	20s13ms	SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."invoice_date" >= '2023-04-01') AND ("sale_history_line"."invoice_date" < '2023-05-01')) AND (((("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 ('%Ciongoli%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))) ORDER BY "sale_history_line"."invoice_date" DESC LIMIT 80; [ Date: 2023-05-02 12:27:40 ]
6	19s803ms	SELECT count(1) FROM "sale_history_line" WHERE ((("sale_history_line"."invoice_date" >= '2023-04-01') AND ("sale_history_line"."invoice_date" < '2023-05-01')) AND (((("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 ('%Ciongoli%')) 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" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')))); [ Date: 2023-05-02 12:28:00 ]
7	18s675ms	COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout; [ Date: 2023-05-02 09:04:17 ]
8	18s203ms	UPDATE "stock_move" SET "date" = '2023-05-02 19:31:10', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868); [ Date: 2023-05-02 19:31:28 ]
9	18s102ms	UPDATE "stock_move" SET "date" = '2023-05-02 19:32:01', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868); [ Date: 2023-05-02 19:32:19 ]
10	18s38ms	UPDATE "stock_move" SET "date" = '2023-05-02 19:30:20', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868); [ Date: 2023-05-02 19:30:38 ]
11	18s1ms	UPDATE "stock_move" SET "date" = '2023-05-02 19:32:51', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868); [ Date: 2023-05-02 19:33:09 ]
12	13s690ms	SELECT partner.id as partner_id, ful.id as followup_level, CASE WHEN partner.balance <= 0 THEN 'no_action_needed' WHEN in_need_of_action_aml.id IS NOT NULL AND (prop_date.value_datetime IS NULL OR prop_date.value_datetime::date <= '2023-05-02'::date) THEN 'in_need_of_action' WHEN exceeded_unreconciled_aml.id IS NOT NULL THEN 'with_overdue_invoices' ELSE 'no_action_needed' END as followup_status FROM ( SELECT partner.id, max(current_followup_level.delay) as followup_delay, SUM(aml.balance) as balance FROM res_partner partner JOIN account_move_line aml ON aml.partner_id = partner.id JOIN account_account account ON account.id = aml.account_id JOIN account_move move ON move.id = aml.move_id -- Get the followup level LEFT JOIN LATERAL ( SELECT COALESCE(next_ful.id, ful.id) as id, COALESCE(next_ful.delay, ful.delay) as delay FROM account_move_line line LEFT OUTER JOIN account_followup_followup_line ful ON ful.id = aml.followup_line_id LEFT OUTER JOIN account_followup_followup_line next_ful ON next_ful.id = ( SELECT next_ful.id FROM account_followup_followup_line next_ful WHERE next_ful.delay > COALESCE(ful.delay, - 999) AND COALESCE(aml.date_maturity, aml.date) + next_ful.delay <= '2023-05-02'::date AND next_ful.company_id = 1 ORDER BY next_ful.delay ASC LIMIT 1) WHERE line.id = aml.id AND aml.partner_id = partner.id AND aml.balance > 0) current_followup_level ON true WHERE account.deprecated IS NOT TRUE AND account.internal_type = 'receivable' AND move.state = 'posted' AND aml.reconciled IS NOT TRUE AND aml.blocked IS FALSE AND aml.company_id = 1 GROUP BY partner.id) partner LEFT JOIN account_followup_followup_line ful ON ful.delay = partner.followup_delay AND ful.company_id = 1 -- Get the followup status data LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id LEFT JOIN account_followup_followup_line ful ON ful.id = line.followup_line_id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(ful.delay, - 999) < partner.followup_delay AND COALESCE(line.date_maturity, line.date) + COALESCE(ful.delay, - 999) <= '2023-05-02'::date LIMIT 1) in_need_of_action_aml ON true LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(line.date_maturity, line.date) <= '2023-05-02'::date LIMIT 1) exceeded_unreconciled_aml ON true LEFT OUTER JOIN ir_property prop_date ON prop_date.res_id = CONCAT('res.partner,', partner.id) AND prop_date.name = 'payment_next_action_date' AND prop_date.company_id = 1; [ Date: 2023-05-02 13:34:33 ]
13	13s473ms	SELECT partner.id as partner_id, ful.id as followup_level, CASE WHEN partner.balance <= 0 THEN 'no_action_needed' WHEN in_need_of_action_aml.id IS NOT NULL AND (prop_date.value_datetime IS NULL OR prop_date.value_datetime::date <= '2023-05-02'::date) THEN 'in_need_of_action' WHEN exceeded_unreconciled_aml.id IS NOT NULL THEN 'with_overdue_invoices' ELSE 'no_action_needed' END as followup_status FROM ( SELECT partner.id, max(current_followup_level.delay) as followup_delay, SUM(aml.balance) as balance FROM res_partner partner JOIN account_move_line aml ON aml.partner_id = partner.id JOIN account_account account ON account.id = aml.account_id JOIN account_move move ON move.id = aml.move_id -- Get the followup level LEFT JOIN LATERAL ( SELECT COALESCE(next_ful.id, ful.id) as id, COALESCE(next_ful.delay, ful.delay) as delay FROM account_move_line line LEFT OUTER JOIN account_followup_followup_line ful ON ful.id = aml.followup_line_id LEFT OUTER JOIN account_followup_followup_line next_ful ON next_ful.id = ( SELECT next_ful.id FROM account_followup_followup_line next_ful WHERE next_ful.delay > COALESCE(ful.delay, - 999) AND COALESCE(aml.date_maturity, aml.date) + next_ful.delay <= '2023-05-02'::date AND next_ful.company_id = 1 ORDER BY next_ful.delay ASC LIMIT 1) WHERE line.id = aml.id AND aml.partner_id = partner.id AND aml.balance > 0) current_followup_level ON true WHERE account.deprecated IS NOT TRUE AND account.internal_type = 'receivable' AND move.state = 'posted' AND aml.reconciled IS NOT TRUE AND aml.blocked IS FALSE AND aml.company_id = 1 GROUP BY partner.id) partner LEFT JOIN account_followup_followup_line ful ON ful.delay = partner.followup_delay AND ful.company_id = 1 -- Get the followup status data LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id LEFT JOIN account_followup_followup_line ful ON ful.id = line.followup_line_id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(ful.delay, - 999) < partner.followup_delay AND COALESCE(line.date_maturity, line.date) + COALESCE(ful.delay, - 999) <= '2023-05-02'::date LIMIT 1) in_need_of_action_aml ON true LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(line.date_maturity, line.date) <= '2023-05-02'::date LIMIT 1) exceeded_unreconciled_aml ON true LEFT OUTER JOIN ir_property prop_date ON prop_date.res_id = CONCAT('res.partner,', partner.id) AND prop_date.name = 'payment_next_action_date' AND prop_date.company_id = 1; [ Date: 2023-05-02 13:33:39 ]
14	13s407ms	DELETE FROM account_move_line WHERE id IN (1930424, 1930425, 1930426, 1930427, 1930428, 1930429, 1930430, 1930431, 1930432, 1930433, 1930434, 1930435, 1930436, 1930437, 1930438, 1930439, 1930440, 1930441, 1930442, 1930443, 1930444, 1930445, 1930446, 1930447, 1930448, 1930449, 1930450, 2225989, 2225990); [ Date: 2023-05-02 23:59:26 ]
15	13s298ms	SELECT partner.id as partner_id, ful.id as followup_level, CASE WHEN partner.balance <= 0 THEN 'no_action_needed' WHEN in_need_of_action_aml.id IS NOT NULL AND (prop_date.value_datetime IS NULL OR prop_date.value_datetime::date <= '2023-05-02'::date) THEN 'in_need_of_action' WHEN exceeded_unreconciled_aml.id IS NOT NULL THEN 'with_overdue_invoices' ELSE 'no_action_needed' END as followup_status FROM ( SELECT partner.id, max(current_followup_level.delay) as followup_delay, SUM(aml.balance) as balance FROM res_partner partner JOIN account_move_line aml ON aml.partner_id = partner.id JOIN account_account account ON account.id = aml.account_id JOIN account_move move ON move.id = aml.move_id -- Get the followup level LEFT JOIN LATERAL ( SELECT COALESCE(next_ful.id, ful.id) as id, COALESCE(next_ful.delay, ful.delay) as delay FROM account_move_line line LEFT OUTER JOIN account_followup_followup_line ful ON ful.id = aml.followup_line_id LEFT OUTER JOIN account_followup_followup_line next_ful ON next_ful.id = ( SELECT next_ful.id FROM account_followup_followup_line next_ful WHERE next_ful.delay > COALESCE(ful.delay, - 999) AND COALESCE(aml.date_maturity, aml.date) + next_ful.delay <= '2023-05-02'::date AND next_ful.company_id = 1 ORDER BY next_ful.delay ASC LIMIT 1) WHERE line.id = aml.id AND aml.partner_id = partner.id AND aml.balance > 0) current_followup_level ON true WHERE account.deprecated IS NOT TRUE AND account.internal_type = 'receivable' AND move.state = 'posted' AND aml.reconciled IS NOT TRUE AND aml.blocked IS FALSE AND aml.company_id = 1 GROUP BY partner.id) partner LEFT JOIN account_followup_followup_line ful ON ful.delay = partner.followup_delay AND ful.company_id = 1 -- Get the followup status data LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id LEFT JOIN account_followup_followup_line ful ON ful.id = line.followup_line_id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(ful.delay, - 999) < partner.followup_delay AND COALESCE(line.date_maturity, line.date) + COALESCE(ful.delay, - 999) <= '2023-05-02'::date LIMIT 1) in_need_of_action_aml ON true LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(line.date_maturity, line.date) <= '2023-05-02'::date LIMIT 1) exceeded_unreconciled_aml ON true LEFT OUTER JOIN ir_property prop_date ON prop_date.res_id = CONCAT('res.partner,', partner.id) AND prop_date.name = 'payment_next_action_date' AND prop_date.company_id = 1; [ Date: 2023-05-02 13:33:25 ]
16	13s279ms	SELECT partner.id as partner_id, ful.id as followup_level, CASE WHEN partner.balance <= 0 THEN 'no_action_needed' WHEN in_need_of_action_aml.id IS NOT NULL AND (prop_date.value_datetime IS NULL OR prop_date.value_datetime::date <= '2023-05-02'::date) THEN 'in_need_of_action' WHEN exceeded_unreconciled_aml.id IS NOT NULL THEN 'with_overdue_invoices' ELSE 'no_action_needed' END as followup_status FROM ( SELECT partner.id, max(current_followup_level.delay) as followup_delay, SUM(aml.balance) as balance FROM res_partner partner JOIN account_move_line aml ON aml.partner_id = partner.id JOIN account_account account ON account.id = aml.account_id JOIN account_move move ON move.id = aml.move_id -- Get the followup level LEFT JOIN LATERAL ( SELECT COALESCE(next_ful.id, ful.id) as id, COALESCE(next_ful.delay, ful.delay) as delay FROM account_move_line line LEFT OUTER JOIN account_followup_followup_line ful ON ful.id = aml.followup_line_id LEFT OUTER JOIN account_followup_followup_line next_ful ON next_ful.id = ( SELECT next_ful.id FROM account_followup_followup_line next_ful WHERE next_ful.delay > COALESCE(ful.delay, - 999) AND COALESCE(aml.date_maturity, aml.date) + next_ful.delay <= '2023-05-02'::date AND next_ful.company_id = 1 ORDER BY next_ful.delay ASC LIMIT 1) WHERE line.id = aml.id AND aml.partner_id = partner.id AND aml.balance > 0) current_followup_level ON true WHERE account.deprecated IS NOT TRUE AND account.internal_type = 'receivable' AND move.state = 'posted' AND aml.reconciled IS NOT TRUE AND aml.blocked IS FALSE AND aml.company_id = 1 GROUP BY partner.id) partner LEFT JOIN account_followup_followup_line ful ON ful.delay = partner.followup_delay AND ful.company_id = 1 -- Get the followup status data LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id LEFT JOIN account_followup_followup_line ful ON ful.id = line.followup_line_id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(ful.delay, - 999) < partner.followup_delay AND COALESCE(line.date_maturity, line.date) + COALESCE(ful.delay, - 999) <= '2023-05-02'::date LIMIT 1) in_need_of_action_aml ON true LEFT OUTER JOIN LATERAL ( SELECT line.id FROM account_move_line line JOIN account_account account ON line.account_id = account.id JOIN account_move move ON line.move_id = move.id WHERE line.partner_id = partner.id AND account.internal_type = 'receivable' AND account.deprecated IS NOT TRUE AND move.state = 'posted' AND line.reconciled IS NOT TRUE AND line.balance > 0 AND line.blocked IS FALSE AND line.company_id = 1 AND COALESCE(line.date_maturity, line.date) <= '2023-05-02'::date LIMIT 1) exceeded_unreconciled_aml ON true LEFT OUTER JOIN ir_property prop_date ON prop_date.res_id = CONCAT('res.partner,', partner.id) AND prop_date.name = 'payment_next_action_date' AND prop_date.company_id = 1; [ Date: 2023-05-02 13:34:16 ]
17	12s525ms	UPDATE "stock_move" SET "date" = '2023-05-02 19:30:16', "state" = 'done', "write_uid" = 1041, "write_date" = (now() at time zone 'UTC') WHERE id IN (397281, 397282, 397283, 397284, 397285, 397289, 397290, 397291, 397293, 397294, 397295, 397296, 397297, 397299); [ Date: 2023-05-02 19:30:30 ]
18	12s1ms	UPDATE "stock_move" SET "date" = '2023-05-02 14:23:43', "state" = 'done', "write_uid" = 981, "write_date" = (now() at time zone 'UTC') WHERE id IN (385447, 385448, 385449, 385451, 385452, 385453, 385454, 385455, 385456, 385457, 385458, 385459, 385461, 385462, 385463, 385464, 385465, 385466, 385467, 385468, 385469); [ Date: 2023-05-02 14:23:55 ]
19	11s319ms	COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout; [ Date: 2023-05-02 09:03:59 ]
20	11s226ms	UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (396831, 396832, 396833, 396834, 396835, 396837, 396838, 396839, 396840, 396841, 396842, 396843, 396844, 396845, 396846, 396847, 396848, 396849, 396850, 396851, 396852, 396853, 396854, 396855, 396856, 396857, 396858); [ Date: 2023-05-02 18:12:08 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

41m53s

4,334

Details

526ms

1s190ms

579ms

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

Day	Hour	Count	Duration	Avg duration
May 02	00	13	7s276ms	559ms
	11	354	3m24s	578ms
	12	553	5m24s	587ms
	13	693	6m49s	591ms
	14	607	5m55s	585ms
	15	351	3m24s	583ms
	16	230	2m12s	577ms
	17	333	3m12s	578ms
	18	368	3m32s	576ms
	19	394	3m43s	567ms
	20	294	2m44s	560ms
	21	105	58s772ms	559ms
	22	39	21s716ms	556ms

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 ('%%68%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6-8%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6-8%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 18:44:49 Duration: 1s190ms
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 ('%%201031e%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%20-1031e%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%20-1031e%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 14:03:50 Duration: 965ms
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 ('%%441030910%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%441 030 910%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%441 030 910%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:15:48 Duration: 896ms

2

19m12s

4,577

Details

120ms

781ms

251ms

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

Day	Hour	Count	Duration	Avg duration
May 02	10	8	1s61ms	132ms
	11	43	6s427ms	149ms
	12	640	3m1s	284ms
	13	594	3m2s	307ms
	14	675	3m3s	272ms
	15	488	1m55s	237ms
	16	481	1m44s	217ms
	17	487	1m52s	230ms
	18	695	3m1s	261ms
	19	211	39s851ms	188ms
	20	186	31s919ms	171ms
	21	62	9s715ms	156ms
	23	7	934ms	133ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 12:39:46') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_949"', '["pointspring_master","calendar.alarm",19487]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",342]', '["pointspring_master","mail.channel",343]', '["pointspring_master","mail.channel",344]', '["pointspring_master","mail.channel",359]', '["pointspring_master","res.partner",19487]', '["pointspring_master","ir.needaction",19487]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 12:40:37 Duration: 781ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 13:16:22') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_977"', '["pointspring_master","calendar.alarm",19515]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",192]', '["pointspring_master","mail.channel",193]', '["pointspring_master","mail.channel",449]', '["pointspring_master","mail.channel",454]', '["pointspring_master","mail.channel",461]', '["pointspring_master","mail.channel",484]', '["pointspring_master","res.partner",19515]', '["pointspring_master","ir.needaction",19515]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 13:17:13 Duration: 755ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 18:43:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1022"', '["pointspring_master","calendar.alarm",19560]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",105]', '["pointspring_master","mail.channel",106]', '["pointspring_master","mail.channel",107]', '["pointspring_master","mail.channel",108]', '["pointspring_master","mail.channel",109]', '["pointspring_master","mail.channel",110]', '["pointspring_master","mail.channel",341]', '["pointspring_master","mail.channel",437]', '["pointspring_master","mail.channel",440]', '["pointspring_master","res.partner",19560]', '["pointspring_master","ir.needaction",19560]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 18:44:49 Duration: 751ms

3

16m48s

1,747

Details

533ms

1s30ms

577ms

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

Day	Hour	Count	Duration	Avg duration
May 02	06	1	551ms	551ms
	07	2	1s110ms	555ms
	08	1	559ms	559ms
	09	15	8s623ms	574ms
	10	33	18s733ms	567ms
	11	34	19s638ms	577ms
	12	106	1m2s	589ms
	13	73	42s930ms	588ms
	14	100	57s562ms	575ms
	15	156	1m31s	585ms
	16	164	1m34s	577ms
	17	115	1m6s	580ms
	18	466	4m30s	580ms
	19	225	2m8s	573ms
	20	232	2m10s	561ms
	21	24	13s406ms	558ms

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 ('%%pl13688c%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%pl1368-8c%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%pl1368-8c%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 18:26:25 Duration: 1s30ms
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 ('%%16M%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%16M%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%16M%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 12:40:38 Duration: 928ms
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 ('%%20355%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-0355%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%2-0355%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:24:38 Duration: 901ms

4

13m38s

1,129

Details

684ms

1s79ms

724ms

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

Day	Hour	Count	Duration	Avg duration
May 02	10	5	3s517ms	703ms
	11	74	53s929ms	728ms
	12	162	1m58s	734ms
	13	158	1m54s	727ms
	14	121	1m28s	730ms
	15	81	58s604ms	723ms
	16	80	57s700ms	721ms
	17	95	1m9s	727ms
	18	166	1m59s	722ms
	19	127	1m30s	711ms
	20	53	37s918ms	715ms
	21	5	3s550ms	710ms
	22	2	1s416ms	708ms

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 ('%cw%')) 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 ('%cw%'))) 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 ('%cw%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%cw%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 20:02:17 Duration: 1s79ms
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 ('%3/4x28%')) 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 ('%3/4x28%'))) 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 ('%3/4x28%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3/4x28%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 12:34:53 Duration: 1s44ms
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 ('%b101%')) 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 ('%b101%'))) 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 ('%b101%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%b101%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 13:21:31 Duration: 1s38ms

5

9m26s

3,571

Details

147ms

376ms

158ms

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

Day	Hour	Count	Duration	Avg duration
May 02	00	3	479ms	159ms
	06	12	1s818ms	151ms
	07	12	1s929ms	160ms
	08	28	4s364ms	155ms
	09	8	1s232ms	154ms
	10	14	2s210ms	157ms
	11	224	34s735ms	155ms
	12	466	1m14s	159ms
	13	575	1m32s	160ms
	14	477	1m16s	160ms
	15	457	1m11s	157ms
	16	225	35s198ms	156ms
	17	309	49s52ms	158ms
	18	384	1m1s	160ms
	19	215	33s866ms	157ms
	20	149	22s998ms	154ms
	21	13	1s980ms	152ms

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/%-cea65be/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-05-02 13:24:38 Duration: 376ms
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.assets_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-1e4bb01/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-05-02 18:45:40 Duration: 362ms
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_editor.assets_wysiwyg.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-ba98edb/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-05-02 13:07:46 Duration: 342ms

6

9m8s

591

Details

197ms

4s277ms

927ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
May 02	12	29	16s824ms	580ms
	13	9	4s985ms	553ms
	14	4	2s431ms	607ms
	15	9	3s917ms	435ms
	16	15	14s600ms	973ms
	17	11	2s767ms	251ms
	18	275	3m54s	852ms
	19	108	2m9s	1s195ms
	20	126	2m15s	1s74ms
	21	5	3s718ms	743ms

UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 19:02:17 Duration: 4s277ms
UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 18:58:52 Duration: 3s995ms
UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 29320, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 19:00:29 Duration: 3s945ms

7

7m54s

180

Details

299ms

18s203ms

2s638ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
May 02	09	2	7s630ms	3s815ms
	11	2	3s995ms	1s997ms
	12	6	16s442ms	2s740ms
	13	19	22s763ms	1s198ms
	14	22	1m4s	2s941ms
	15	33	48s582ms	1s472ms
	16	20	1m27s	4s363ms
	17	25	1m1s	2s475ms
	18	18	17s345ms	963ms
	19	21	2m7s	6s49ms
	20	12	17s261ms	1s438ms

UPDATE "stock_move" SET "date" = '2023-05-02 19:31:10', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868);

Date: 2023-05-02 19:31:28 Duration: 18s203ms
UPDATE "stock_move" SET "date" = '2023-05-02 19:32:01', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868);

Date: 2023-05-02 19:32:19 Duration: 18s102ms
UPDATE "stock_move" SET "date" = '2023-05-02 19:30:20', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868);

Date: 2023-05-02 19:30:38 Duration: 18s38ms

8

7m44s

563

Details

295ms

2s269ms

825ms

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
May 02	06	1	295ms	295ms
	09	3	2s629ms	876ms
	11	34	30s297ms	891ms
	12	67	54s308ms	810ms
	13	88	1m11s	813ms
	14	63	53s817ms	854ms
	15	49	37s913ms	773ms
	16	30	23s449ms	781ms
	17	58	48s901ms	843ms
	18	84	1m7s	807ms
	19	43	37s601ms	874ms
	20	40	32s902ms	822ms
	21	3	3s148ms	1s49ms

UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-05-02 19:18:57', "is_done" = true, "state" = 'done', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (367272, 367274, 367270);

Date: 2023-05-02 19:19:10 Duration: 2s269ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-05-02 18:39:27', "is_done" = true, "state" = 'done', "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (396985, 396981);

Date: 2023-05-02 18:39:32 Duration: 2s214ms
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2023-05-02 11:11:17', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (395306, 395299, 394796);

Date: 2023-05-02 11:11:20 Duration: 2s183ms

9

7m5s

786

Details

142ms

1s694ms

540ms

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
May 02	09	11	6s85ms	553ms
	11	36	20s319ms	564ms
	12	86	45s711ms	531ms
	13	135	1m16s	569ms
	14	100	55s225ms	552ms
	15	81	40s287ms	497ms
	16	48	24s855ms	517ms
	17	49	24s719ms	504ms
	18	123	1m4s	528ms
	19	76	42s677ms	561ms
	20	37	20s624ms	557ms
	21	4	2s703ms	675ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 959, "write_date" = (now() at time zone 'UTC') WHERE id IN (288801, 288796);

Date: 2023-05-02 12:36:51 Duration: 1s694ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (283912, 283917, 283909, 283910);

Date: 2023-05-02 19:19:04 Duration: 1s680ms
UPDATE "stock_quant" SET "quantity" = 2.0, "reserved_quantity" = 0.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (266616, 284349);

Date: 2023-05-02 18:39:38 Duration: 1s671ms

10

6m24s

2,483

Details

120ms

341ms

154ms

select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
May 02	00	239	37s211ms	155ms
	01	208	32s511ms	156ms
	02	186	28s959ms	155ms
	03	209	32s314ms	154ms
	04	182	27s281ms	149ms
	05	173	26s259ms	151ms
	06	262	41s240ms	157ms
	07	282	43s728ms	155ms
	08	181	28s504ms	157ms
	09	204	31s490ms	154ms
	22	169	25s624ms	151ms
	23	188	29s101ms	154ms

select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-02T05:30:00.917847'::timestamp and so.date_order <= '2023-05-02T05:30:00.917847'::timestamp and sol.product_id = 238646 and so.state in ('done', 'sale') and so.warehouse_id = 44;

Date: 2023-05-02 05:34:36 Duration: 341ms
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-02T23:30:19.597234'::timestamp and so.date_order <= '2023-05-02T23:30:19.597234'::timestamp and sol.product_id = 226589 and so.state in ('done', 'sale') and so.warehouse_id = 44;

Date: 2023-05-02 23:33:14 Duration: 288ms
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-02T09:30:09.402281'::timestamp and so.date_order <= '2023-05-02T09:30:09.402281'::timestamp and sol.product_id = 189083 and so.state in ('done', 'sale') and so.warehouse_id = 36;

Date: 2023-05-02 09:31:05 Duration: 288ms

11

5m24s

336

Details

144ms

11s167ms

965ms

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

Day	Hour	Count	Duration	Avg duration
May 02	00	1	1s198ms	1s198ms
	11	26	27s200ms	1s46ms
	12	37	40s963ms	1s107ms
	13	50	50s417ms	1s8ms
	14	41	46s363ms	1s130ms
	15	35	27s981ms	799ms
	16	29	19s211ms	662ms
	17	32	23s988ms	749ms
	18	38	34s889ms	918ms
	19	34	41s400ms	1s217ms
	20	11	7s105ms	645ms
	21	1	699ms	699ms
	22	1	3s83ms	3s83ms

UPDATE "stock_move" SET "branch_id" = 48, "picking_id" = 134410, "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 (397280, 397281, 397282, 397283, 397284, 397285, 397286, 397287, 397288, 397289, 397290, 397291, 397292, 397293, 397294, 397295, 397296, 397297, 397298, 397299);

Date: 2023-05-02 19:29:46 Duration: 11s167ms
UPDATE "stock_move" SET "branch_id" = 46, "picking_id" = 133783, "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 (396143, 396144, 396145, 396146, 396147, 396148, 396149, 396150, 396151, 396152, 396153, 396154, 396155);

Date: 2023-05-02 14:57:00 Duration: 6s884ms
UPDATE "stock_move" SET "branch_id" = 46, "picking_id" = 133354, "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 (395520, 395521, 395522, 395523, 395524, 395525, 395526, 395527, 395528, 395529, 395517, 395518, 395519);

Date: 2023-05-02 12:34:59 Duration: 6s417ms

12

5m20s

630

Details

139ms

1s718ms

508ms

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
May 02	06	1	408ms	408ms
	09	4	1s690ms	422ms
	11	25	13s489ms	539ms
	12	41	20s501ms	500ms
	13	66	31s834ms	482ms
	14	41	19s953ms	486ms
	15	63	32s476ms	515ms
	16	76	33s485ms	440ms
	17	103	52s960ms	514ms
	18	72	33s527ms	465ms
	19	91	53s50ms	582ms
	20	42	24s522ms	583ms
	21	5	2s731ms	546ms

UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91730, 281307, 91263, 87191);

Date: 2023-05-02 19:30:44 Duration: 1s718ms
UPDATE "stock_quant" SET "quantity" = 1.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (276784, 276785, 288654, 288655);

Date: 2023-05-02 11:50:16 Duration: 1s716ms
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91730, 281307, 91263, 87191);

Date: 2023-05-02 19:31:34 Duration: 1s653ms

13

5m10s

1,849

Details

156ms

318ms

167ms

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

Day	Hour	Count	Duration	Avg duration
May 02	07	11	1s822ms	165ms
	08	13	2s121ms	163ms
	09	28	4s600ms	164ms
	10	37	6s100ms	164ms
	11	113	18s622ms	164ms
	12	150	25s126ms	167ms
	13	186	31s352ms	168ms
	14	226	38s129ms	168ms
	15	174	29s274ms	168ms
	16	163	27s488ms	168ms
	17	203	34s235ms	168ms
	18	273	46s331ms	169ms
	19	155	25s697ms	165ms
	20	117	19s266ms	164ms

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 ('%s-00312%') OR unaccent (res_partner.display_name) ilike unaccent ('%s-00312%') OR unaccent (res_partner.ref) ilike unaccent ('%s-00312%') OR unaccent (res_partner.vat) ilike unaccent ('s-00312')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%s-00312%') desc, unaccent (res_partner.display_name);

Date: 2023-05-02 14:45:09 Duration: 318ms
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 ('%46003%') OR unaccent (res_partner.display_name) ilike unaccent ('%46003%') OR unaccent (res_partner.ref) ilike unaccent ('%46003%') OR unaccent (res_partner.vat) ilike unaccent ('46003')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%46003%') desc, unaccent (res_partner.display_name);

Date: 2023-05-02 15:39:54 Duration: 277ms
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 ('%G-00223%') OR unaccent (res_partner.display_name) ilike unaccent ('%G-00223%') OR unaccent (res_partner.ref) ilike unaccent ('%G-00223%') OR unaccent (res_partner.vat) ilike unaccent ('G-00223')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%G-00223%') desc, unaccent (res_partner.display_name);

Date: 2023-05-02 19:06:21 Duration: 266ms

14

4m52s

508

Details

533ms

843ms

576ms

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"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
May 02	12	28	15s943ms	569ms
	13	58	33s833ms	583ms
	14	115	1m7s	584ms
	15	76	43s932ms	578ms
	16	54	31s14ms	574ms
	17	26	15s271ms	587ms
	18	56	32s235ms	575ms
	19	22	12s296ms	558ms
	20	50	28s148ms	562ms
	22	23	12s830ms	557ms

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

Date: 2023-05-02 13:22:22 Duration: 843ms
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 ('%%ab1dk23l%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ab1dk23l-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ab1dk23l-%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 14:01:43 Duration: 755ms
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 ('%%iuj%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%iuj%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%iuj%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:21:30 Duration: 752ms

15

4m50s

349

Details

526ms

3s631ms

831ms

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

Day	Hour	Count	Duration	Avg duration
May 02	09	1	710ms	710ms
	11	12	9s74ms	756ms
	12	47	37s967ms	807ms
	13	55	51s669ms	939ms
	14	30	25s162ms	838ms
	15	37	26s962ms	728ms
	16	26	23s647ms	909ms
	17	28	21s716ms	775ms
	18	58	46s550ms	802ms
	19	38	29s913ms	787ms
	20	16	15s315ms	957ms
	21	1	1s430ms	1s430ms

UPDATE "stock_move" SET "date" = '2023-05-02 13:52:53', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (383607, 383608, 383609, 383610, 383611);

Date: 2023-05-02 13:53:03 Duration: 3s631ms
UPDATE "stock_move" SET "date" = '2023-05-02 19:18:57', "is_done" = true, "state" = 'done', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (367265, 367266, 367268, 367262);

Date: 2023-05-02 19:19:07 Duration: 3s60ms
UPDATE "stock_move" SET "date" = '2023-05-02 16:20:34', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (368049, 396362, 368051, 368055);

Date: 2023-05-02 16:20:37 Duration: 2s669ms

16

4m27s

290

Details

290ms

7s300ms

923ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
May 02	11	6	2s936ms	489ms
	12	25	16s455ms	658ms
	13	22	12s799ms	581ms
	14	35	36s793ms	1s51ms
	15	43	32s983ms	767ms
	16	37	51s660ms	1s396ms
	17	41	34s256ms	835ms
	18	34	21s535ms	633ms
	19	31	49s859ms	1s608ms
	20	14	7s746ms	553ms
	21	2	831ms	415ms

UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 2924, "warehouse_id" = 43, "write_uid" = 1006, "write_date" = (now() at time zone 'UTC') WHERE id IN (288992, 288994, 288996, 288974, 288975, 288976, 288977, 288978, 288979, 288980, 288981, 288983, 288985, 288986, 288988, 288990, 288991);

Date: 2023-05-02 14:17:29 Duration: 7s300ms
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3026, "warehouse_id" = 45, "write_uid" = 981, "write_date" = (now() at time zone 'UTC') WHERE id IN (289004, 289005, 289006, 289007, 289008, 289009, 289010, 289011, 289012, 289013, 289014, 289016, 289017, 289018, 289020, 289021, 289023);

Date: 2023-05-02 14:24:07 Duration: 7s66ms
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 2952, "warehouse_id" = 35, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (289700, 289701, 289702, 289703, 289704, 289705, 289706, 289707, 289708, 289710, 289711, 289713, 289714);

Date: 2023-05-02 19:31:50 Duration: 5s546ms

17

4m26s

461

Details

535ms

903ms

578ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
May 02	06	2	1s122ms	561ms
	10	3	1s691ms	563ms
	11	4	2s340ms	585ms
	12	13	7s482ms	575ms
	13	112	1m4s	579ms
	14	110	1m4s	583ms
	15	79	45s893ms	580ms
	16	41	23s352ms	569ms
	17	41	23s604ms	575ms
	18	28	16s189ms	578ms
	19	21	12s54ms	574ms
	20	7	3s922ms	560ms

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

Date: 2023-05-02 14:44:31 Duration: 903ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%464257%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%464.257%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%464.257%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 19:19:07 Duration: 734ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%572%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%572%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%572%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 14:47:19 Duration: 724ms

18

4m17s

484

Details

137ms

11s226ms

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
May 02	11	3	1s612ms	537ms
	12	44	14s877ms	338ms
	13	44	18s247ms	414ms
	14	50	24s138ms	482ms
	15	26	16s738ms	643ms
	16	18	8s812ms	489ms
	17	63	33s885ms	537ms
	18	129	1m16s	590ms
	19	68	33s462ms	492ms
	20	28	26s321ms	940ms
	21	4	1s830ms	457ms
	22	7	1s737ms	248ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (396831, 396832, 396833, 396834, 396835, 396837, 396838, 396839, 396840, 396841, 396842, 396843, 396844, 396845, 396846, 396847, 396848, 396849, 396850, 396851, 396852, 396853, 396854, 396855, 396856, 396857, 396858);

Date: 2023-05-02 18:12:08 Duration: 11s226ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (397509, 397510, 397490, 397491, 397492, 397493, 397494, 397495, 397497, 397498, 397499, 397500, 397501);

Date: 2023-05-02 20:55:55 Duration: 6s262ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (396980, 396981, 396982, 396983, 396984, 396985, 396986);

Date: 2023-05-02 18:39:18 Duration: 5s41ms

19

4m10s

1,425

Details

121ms

472ms

175ms

with currency_rate as ( select r.currency_id, coalesce(r.company_id, c.id) as company_id, r.rate, r.name as date_start, ( select name from res_currency_rate r2 where r2.name > r.name and r2.currency_id = r.currency_id and (r2.company_id is null or r2.company_id = c.id) order by r2.name asc limit ?) as date_end from res_currency_rate r join res_company c on (r.company_id is null or r.company_id = c.id)) select l.product_id as product_id, sum(l.price_unit / ( case coalesce(cr.rate, ?) when ? then ?.? else cr.rate end) * l.quantity * ( case when i.move_type in (...) then ? else ? end) * ((? - l.discount) * ?.?)) / nullif (sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)), ?) as avg_unit_price, sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)) as num_qty, sum(abs(l.balance) * ( case when i.move_type in (...) then ? else ? end)) as total, sum(l.quantity * pt.list_price * ( case when i.move_type in (...) then ? else ? end)) as sale_expected from account_move_line l left join account_move i on (l.move_id = i.id) left join product_product product on (product.id = l.product_id) left join product_template pt on (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= coalesce(i.invoice_date, now()) and (cr.date_end is null or cr.date_end > coalesce(i.invoice_date, now()))) where l.product_id in (...) and i.state in (...) and i.payment_state in (...) and i.move_type in (...) and i.invoice_date between ? and ? and i.company_id = ? and l.display_type is null and l.exclude_from_invoice_tab = false group by l.product_id;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
May 02	08	2	324ms	162ms
	09	12	2s88ms	174ms
	11	72	12s611ms	175ms
	12	97	17s619ms	181ms
	13	203	35s486ms	174ms
	14	196	34s461ms	175ms
	15	237	41s667ms	175ms
	16	152	26s783ms	176ms
	17	109	19s349ms	177ms
	18	160	28s115ms	175ms
	19	103	18s51ms	175ms
	20	74	12s729ms	172ms
	21	8	1s363ms	170ms

WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (193113) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;

Date: 2023-05-02 12:49:57 Duration: 472ms
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (197936, 198760, 197308, 197893, 197898) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;

Date: 2023-05-02 18:49:38 Duration: 378ms
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (197864) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;

Date: 2023-05-02 12:24:07 Duration: 353ms

20

3m56s

1,082

Details

196ms

1s638ms

218ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
May 02	00	3	601ms	200ms
	11	191	42s796ms	224ms
	12	126	27s623ms	219ms
	13	157	34s109ms	217ms
	14	130	27s917ms	214ms
	15	94	20s98ms	213ms
	16	64	13s727ms	214ms
	17	83	19s270ms	232ms
	18	99	21s815ms	220ms
	19	112	24s23ms	214ms
	20	15	3s277ms	218ms
	21	1	200ms	200ms
	22	7	1s486ms	212ms

UPDATE "sale_order_line" SET "write_uid" = 1144, "write_date" = (now() at time zone 'UTC') WHERE id IN (144877, 144879, 144881, 144882, 144883, 144884, 144886, 144887);

Date: 2023-05-02 17:03:01 Duration: 1s638ms
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (144160, 144161, 144162, 144163, 144144, 144151, 144152, 144153, 144159);

Date: 2023-05-02 11:49:44 Duration: 1s477ms
UPDATE "sale_order_line" SET "write_uid" = 1224, "write_date" = (now() at time zone 'UTC') WHERE id IN (144137, 144138, 144139);

Date: 2023-05-02 11:32:27 Duration: 635ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

4,577

Details

19m12s

120ms

781ms

251ms

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
May 02	10	8	1s61ms	132ms
	11	43	6s427ms	149ms
	12	640	3m1s	284ms
	13	594	3m2s	307ms
	14	675	3m3s	272ms
	15	488	1m55s	237ms
	16	481	1m44s	217ms
	17	487	1m52s	230ms
	18	695	3m1s	261ms
	19	211	39s851ms	188ms
	20	186	31s919ms	171ms
	21	62	9s715ms	156ms
	23	7	934ms	133ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 12:39:46') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_949"', '["pointspring_master","calendar.alarm",19487]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",342]', '["pointspring_master","mail.channel",343]', '["pointspring_master","mail.channel",344]', '["pointspring_master","mail.channel",359]', '["pointspring_master","res.partner",19487]', '["pointspring_master","ir.needaction",19487]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 12:40:37 Duration: 781ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 13:16:22') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_977"', '["pointspring_master","calendar.alarm",19515]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",192]', '["pointspring_master","mail.channel",193]', '["pointspring_master","mail.channel",449]', '["pointspring_master","mail.channel",454]', '["pointspring_master","mail.channel",461]', '["pointspring_master","mail.channel",484]', '["pointspring_master","res.partner",19515]', '["pointspring_master","ir.needaction",19515]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 13:17:13 Duration: 755ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 18:43:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1022"', '["pointspring_master","calendar.alarm",19560]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",105]', '["pointspring_master","mail.channel",106]', '["pointspring_master","mail.channel",107]', '["pointspring_master","mail.channel",108]', '["pointspring_master","mail.channel",109]', '["pointspring_master","mail.channel",110]', '["pointspring_master","mail.channel",341]', '["pointspring_master","mail.channel",437]', '["pointspring_master","mail.channel",440]', '["pointspring_master","res.partner",19560]', '["pointspring_master","ir.needaction",19560]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 18:44:49 Duration: 751ms

2

4,334

Details

41m53s

526ms

1s190ms

579ms

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
May 02	00	13	7s276ms	559ms
	11	354	3m24s	578ms
	12	553	5m24s	587ms
	13	693	6m49s	591ms
	14	607	5m55s	585ms
	15	351	3m24s	583ms
	16	230	2m12s	577ms
	17	333	3m12s	578ms
	18	368	3m32s	576ms
	19	394	3m43s	567ms
	20	294	2m44s	560ms
	21	105	58s772ms	559ms
	22	39	21s716ms	556ms

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 ('%%68%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6-8%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6-8%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 18:44:49 Duration: 1s190ms
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 ('%%201031e%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%20-1031e%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%20-1031e%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 14:03:50 Duration: 965ms
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 ('%%441030910%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%441 030 910%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%441 030 910%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:15:48 Duration: 896ms

3

3,571

Details

9m26s

147ms

376ms

158ms

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
May 02	00	3	479ms	159ms
	06	12	1s818ms	151ms
	07	12	1s929ms	160ms
	08	28	4s364ms	155ms
	09	8	1s232ms	154ms
	10	14	2s210ms	157ms
	11	224	34s735ms	155ms
	12	466	1m14s	159ms
	13	575	1m32s	160ms
	14	477	1m16s	160ms
	15	457	1m11s	157ms
	16	225	35s198ms	156ms
	17	309	49s52ms	158ms
	18	384	1m1s	160ms
	19	215	33s866ms	157ms
	20	149	22s998ms	154ms
	21	13	1s980ms	152ms

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/%-cea65be/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-05-02 13:24:38 Duration: 376ms
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.assets_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-1e4bb01/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-05-02 18:45:40 Duration: 362ms
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_editor.assets_wysiwyg.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-ba98edb/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-05-02 13:07:46 Duration: 342ms

4

2,483

Details

6m24s

120ms

341ms

154ms

select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
May 02	00	239	37s211ms	155ms
	01	208	32s511ms	156ms
	02	186	28s959ms	155ms
	03	209	32s314ms	154ms
	04	182	27s281ms	149ms
	05	173	26s259ms	151ms
	06	262	41s240ms	157ms
	07	282	43s728ms	155ms
	08	181	28s504ms	157ms
	09	204	31s490ms	154ms
	22	169	25s624ms	151ms
	23	188	29s101ms	154ms

select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-02T05:30:00.917847'::timestamp and so.date_order <= '2023-05-02T05:30:00.917847'::timestamp and sol.product_id = 238646 and so.state in ('done', 'sale') and so.warehouse_id = 44;

Date: 2023-05-02 05:34:36 Duration: 341ms
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-02T23:30:19.597234'::timestamp and so.date_order <= '2023-05-02T23:30:19.597234'::timestamp and sol.product_id = 226589 and so.state in ('done', 'sale') and so.warehouse_id = 44;

Date: 2023-05-02 23:33:14 Duration: 288ms
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-11-02T09:30:09.402281'::timestamp and so.date_order <= '2023-05-02T09:30:09.402281'::timestamp and sol.product_id = 189083 and so.state in ('done', 'sale') and so.warehouse_id = 36;

Date: 2023-05-02 09:31:05 Duration: 288ms

5

1,849

Details

5m10s

156ms

318ms

167ms

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
May 02	07	11	1s822ms	165ms
	08	13	2s121ms	163ms
	09	28	4s600ms	164ms
	10	37	6s100ms	164ms
	11	113	18s622ms	164ms
	12	150	25s126ms	167ms
	13	186	31s352ms	168ms
	14	226	38s129ms	168ms
	15	174	29s274ms	168ms
	16	163	27s488ms	168ms
	17	203	34s235ms	168ms
	18	273	46s331ms	169ms
	19	155	25s697ms	165ms
	20	117	19s266ms	164ms

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 ('%s-00312%') OR unaccent (res_partner.display_name) ilike unaccent ('%s-00312%') OR unaccent (res_partner.ref) ilike unaccent ('%s-00312%') OR unaccent (res_partner.vat) ilike unaccent ('s-00312')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%s-00312%') desc, unaccent (res_partner.display_name);

Date: 2023-05-02 14:45:09 Duration: 318ms
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 ('%46003%') OR unaccent (res_partner.display_name) ilike unaccent ('%46003%') OR unaccent (res_partner.ref) ilike unaccent ('%46003%') OR unaccent (res_partner.vat) ilike unaccent ('46003')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%46003%') desc, unaccent (res_partner.display_name);

Date: 2023-05-02 15:39:54 Duration: 277ms
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 ('%G-00223%') OR unaccent (res_partner.display_name) ilike unaccent ('%G-00223%') OR unaccent (res_partner.ref) ilike unaccent ('%G-00223%') OR unaccent (res_partner.vat) ilike unaccent ('G-00223')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%G-00223%') desc, unaccent (res_partner.display_name);

Date: 2023-05-02 19:06:21 Duration: 266ms

6

1,747

Details

16m48s

533ms

1s30ms

577ms

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

Day	Hour	Count	Duration	Avg duration
May 02	06	1	551ms	551ms
	07	2	1s110ms	555ms
	08	1	559ms	559ms
	09	15	8s623ms	574ms
	10	33	18s733ms	567ms
	11	34	19s638ms	577ms
	12	106	1m2s	589ms
	13	73	42s930ms	588ms
	14	100	57s562ms	575ms
	15	156	1m31s	585ms
	16	164	1m34s	577ms
	17	115	1m6s	580ms
	18	466	4m30s	580ms
	19	225	2m8s	573ms
	20	232	2m10s	561ms
	21	24	13s406ms	558ms

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 ('%%pl13688c%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%pl1368-8c%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%pl1368-8c%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 18:26:25 Duration: 1s30ms
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 ('%%16M%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%16M%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%16M%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 12:40:38 Duration: 928ms
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 ('%%20355%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-0355%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%2-0355%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:24:38 Duration: 901ms

7

1,425

Details

4m10s

121ms

472ms

175ms

with currency_rate as ( select r.currency_id, coalesce(r.company_id, c.id) as company_id, r.rate, r.name as date_start, ( select name from res_currency_rate r2 where r2.name > r.name and r2.currency_id = r.currency_id and (r2.company_id is null or r2.company_id = c.id) order by r2.name asc limit ?) as date_end from res_currency_rate r join res_company c on (r.company_id is null or r.company_id = c.id)) select l.product_id as product_id, sum(l.price_unit / ( case coalesce(cr.rate, ?) when ? then ?.? else cr.rate end) * l.quantity * ( case when i.move_type in (...) then ? else ? end) * ((? - l.discount) * ?.?)) / nullif (sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)), ?) as avg_unit_price, sum(l.quantity * ( case when i.move_type in (...) then ? else ? end)) as num_qty, sum(abs(l.balance) * ( case when i.move_type in (...) then ? else ? end)) as total, sum(l.quantity * pt.list_price * ( case when i.move_type in (...) then ? else ? end)) as sale_expected from account_move_line l left join account_move i on (l.move_id = i.id) left join product_product product on (product.id = l.product_id) left join product_template pt on (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= coalesce(i.invoice_date, now()) and (cr.date_end is null or cr.date_end > coalesce(i.invoice_date, now()))) where l.product_id in (...) and i.state in (...) and i.payment_state in (...) and i.move_type in (...) and i.invoice_date between ? and ? and i.company_id = ? and l.display_type is null and l.exclude_from_invoice_tab = false group by l.product_id;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
May 02	08	2	324ms	162ms
	09	12	2s88ms	174ms
	11	72	12s611ms	175ms
	12	97	17s619ms	181ms
	13	203	35s486ms	174ms
	14	196	34s461ms	175ms
	15	237	41s667ms	175ms
	16	152	26s783ms	176ms
	17	109	19s349ms	177ms
	18	160	28s115ms	175ms
	19	103	18s51ms	175ms
	20	74	12s729ms	172ms
	21	8	1s363ms	170ms

WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (193113) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;

Date: 2023-05-02 12:49:57 Duration: 472ms
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (197936, 198760, 197308, 197893, 197898) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;

Date: 2023-05-02 18:49:38 Duration: 378ms
WITH currency_rate AS ( SELECT r.currency_id, COALESCE(r.company_id, c.id) as company_id, r.rate, r.name AS date_start, ( SELECT name FROM res_currency_rate r2 WHERE r2.name > r.name AND r2.currency_id = r.currency_id AND (r2.company_id is null or r2.company_id = c.id) ORDER BY r2.name ASC LIMIT 1) AS date_end FROM res_currency_rate r JOIN res_company c ON (r.company_id is null or r.company_id = c.id)) SELECT l.product_id as product_id, SUM(l.price_unit / ( CASE COALESCE(cr.rate, 0) WHEN 0 THEN 1.0 ELSE cr.rate END) * l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END) * ((100 - l.discount) * 0.01)) / NULLIF (SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)), 0) AS avg_unit_price, SUM(l.quantity * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS num_qty, SUM(ABS(l.balance) * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS total, SUM(l.quantity * pt.list_price * ( CASE WHEN i.move_type IN ('out_invoice', 'in_invoice') THEN 1 ELSE - 1 END)) AS sale_expected FROM account_move_line l LEFT JOIN account_move i ON (l.move_id = i.id) LEFT JOIN product_product product ON (product.id = l.product_id) LEFT JOIN product_template pt ON (pt.id = product.product_tmpl_id) left join currency_rate cr on (cr.currency_id = i.currency_id and cr.company_id = i.company_id and cr.date_start <= COALESCE(i.invoice_date, NOW()) and (cr.date_end IS NULL OR cr.date_end > COALESCE(i.invoice_date, NOW()))) WHERE l.product_id IN (197864) AND i.state IN ('posted') AND i.payment_state IN ('not_paid', 'in_payment', 'paid') AND i.move_type IN ('out_invoice', 'out_refund') AND i.invoice_date BETWEEN '2023-01-01' AND '2023-12-31' AND i.company_id = 1 AND l.display_type IS NULL AND l.exclude_from_invoice_tab = false GROUP BY l.product_id;

Date: 2023-05-02 12:24:07 Duration: 353ms

8

1,390

Details

3m31s

138ms

2s167ms

151ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
May 02	00	5	701ms	140ms
	09	2	297ms	148ms
	11	64	9s342ms	145ms
	12	121	18s736ms	154ms
	13	133	19s948ms	149ms
	14	169	25s417ms	150ms
	15	93	13s749ms	147ms
	16	216	31s916ms	147ms
	17	104	17s842ms	171ms
	18	205	32s308ms	157ms
	19	203	29s980ms	147ms
	20	56	8s174ms	145ms
	21	5	711ms	142ms
	22	14	1s997ms	142ms

UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (170176, 40167, 185770, 284751, 284752, 39855, 284754, 284755, 262293, 267191, 281275, 282012, 281277, 42654, 281279);

Date: 2023-05-02 17:45:29 Duration: 2s167ms
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (141965, 146637, 146643, 146644, 146622);

Date: 2023-05-02 18:33:15 Duration: 729ms
UPDATE "stock_quant" SET "reserved_quantity" = 0.0, "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (90016, 86351, 85777, 86323, 278644);

Date: 2023-05-02 14:11:43 Duration: 724ms

9

1,129

Details

13m38s

684ms

1s79ms

724ms

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
May 02	10	5	3s517ms	703ms
	11	74	53s929ms	728ms
	12	162	1m58s	734ms
	13	158	1m54s	727ms
	14	121	1m28s	730ms
	15	81	58s604ms	723ms
	16	80	57s700ms	721ms
	17	95	1m9s	727ms
	18	166	1m59s	722ms
	19	127	1m30s	711ms
	20	53	37s918ms	715ms
	21	5	3s550ms	710ms
	22	2	1s416ms	708ms

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 ('%cw%')) 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 ('%cw%'))) 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 ('%cw%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%cw%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 20:02:17 Duration: 1s79ms
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 ('%3/4x28%')) 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 ('%3/4x28%'))) 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 ('%3/4x28%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3/4x28%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 12:34:53 Duration: 1s44ms
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 ('%b101%')) 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 ('%b101%'))) 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 ('%b101%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%b101%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 13:21:31 Duration: 1s38ms

10

1,082

Details

3m56s

196ms

1s638ms

218ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
May 02	00	3	601ms	200ms
	11	191	42s796ms	224ms
	12	126	27s623ms	219ms
	13	157	34s109ms	217ms
	14	130	27s917ms	214ms
	15	94	20s98ms	213ms
	16	64	13s727ms	214ms
	17	83	19s270ms	232ms
	18	99	21s815ms	220ms
	19	112	24s23ms	214ms
	20	15	3s277ms	218ms
	21	1	200ms	200ms
	22	7	1s486ms	212ms

UPDATE "sale_order_line" SET "write_uid" = 1144, "write_date" = (now() at time zone 'UTC') WHERE id IN (144877, 144879, 144881, 144882, 144883, 144884, 144886, 144887);

Date: 2023-05-02 17:03:01 Duration: 1s638ms
UPDATE "sale_order_line" SET "write_uid" = 1140, "write_date" = (now() at time zone 'UTC') WHERE id IN (144160, 144161, 144162, 144163, 144144, 144151, 144152, 144153, 144159);

Date: 2023-05-02 11:49:44 Duration: 1s477ms
UPDATE "sale_order_line" SET "write_uid" = 1224, "write_date" = (now() at time zone 'UTC') WHERE id IN (144137, 144138, 144139);

Date: 2023-05-02 11:32:27 Duration: 635ms

11

1,008

Details

3m47s

199ms

371ms

225ms

select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
May 02	00	5	1s67ms	213ms
	11	91	20s146ms	221ms
	12	143	32s676ms	228ms
	13	175	39s337ms	224ms
	14	120	27s32ms	225ms
	15	99	22s175ms	223ms
	16	61	14s42ms	230ms
	17	79	17s707ms	224ms
	18	104	23s928ms	230ms
	19	98	21s793ms	222ms
	20	22	4s888ms	222ms
	21	4	850ms	212ms
	22	7	1s476ms	210ms

SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (145029)) ORDER BY "sale_history_line"."id";

Date: 2023-05-02 18:29:26 Duration: 371ms
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (144009)) ORDER BY "sale_history_line"."id";

Date: 2023-05-02 13:38:22 Duration: 367ms
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (144307)) ORDER BY "sale_history_line"."id";

Date: 2023-05-02 12:34:47 Duration: 359ms

12

888

Details

3m26s

216ms

421ms

232ms

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

Day	Hour	Count	Duration	Avg duration
May 02	00	5	1s113ms	222ms
	11	251	57s782ms	230ms
	12	68	16s122ms	237ms
	13	79	18s432ms	233ms
	14	58	13s534ms	233ms
	15	50	11s733ms	234ms
	16	49	11s236ms	229ms
	17	111	25s663ms	231ms
	18	79	18s796ms	237ms
	19	83	19s94ms	230ms
	20	51	11s547ms	226ms
	21	4	1s1ms	250ms

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

Date: 2023-05-02 11:50:25 Duration: 421ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (144937)) ORDER BY "sale_line_report"."id";

Date: 2023-05-02 17:21:32 Duration: 328ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (145277)) ORDER BY "sale_line_report"."id";

Date: 2023-05-02 21:42:34 Duration: 320ms

13

826

Details

3m6s

198ms

1s908ms

226ms

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

Day	Hour	Count	Duration	Avg duration
May 02	09	15	3s221ms	214ms
	11	52	11s333ms	217ms
	12	81	17s759ms	219ms
	13	154	34s202ms	222ms
	14	140	30s540ms	218ms
	15	105	23s174ms	220ms
	16	63	16s33ms	254ms
	17	48	10s927ms	227ms
	18	61	13s734ms	225ms
	19	65	16s515ms	254ms
	20	41	9s187ms	224ms
	21	1	217ms	217ms

UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 10.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 967, "write_date" = (now() at time zone 'UTC') WHERE id IN (129219, 134020, 129220, 129221, 122599, 134021, 57072, 131441, 131455);

Date: 2023-05-02 16:08:19 Duration: 1s908ms
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" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (139650, 141111, 117712, 139667, 138999);

Date: 2023-05-02 19:33:37 Duration: 1s121ms
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 0.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (117265, 116682, 116755, 116701);

Date: 2023-05-02 19:19:07 Duration: 1s34ms

14

801

Details

2m56s

199ms

327ms

220ms

update "sale_order_line" set "branch_id" = ?, "currency_id" = ?, "cus_date_order" = ?, "cus_part_route" = ?, "cus_user_id" = ?, "inventory_vendor_id" = ?, "is_service" = false, "margin" = ?, "margin_percent" = ?.?, "order_partner_id" = ?, "price_reduce" = ?, "price_reduce_taxexcl" = ?, "price_reduce_taxinc" = ?, "price_subtotal" = ?, "price_tax" = ?.?, "price_total" = ?, "purchase_price" = ?, "qty_delivered_method" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "salesman_id" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
May 02	00	4	843ms	210ms
	11	76	16s715ms	219ms
	12	103	23s925ms	232ms
	13	114	25s146ms	220ms
	14	84	18s331ms	218ms
	15	60	13s282ms	221ms
	16	43	9s427ms	219ms
	17	79	17s492ms	221ms
	18	78	17s329ms	222ms
	19	70	15s162ms	216ms
	20	54	11s661ms	215ms
	21	27	5s707ms	211ms
	22	9	1s932ms	214ms

UPDATE "sale_order_line" SET "branch_id" = 44, "currency_id" = 2, "cus_date_order" = '2023-05-02 12:32:58', "cus_part_route" = NULL, "cus_user_id" = 986, "inventory_vendor_id" = 3085, "is_service" = false, "margin" = '8.96', "margin_percent" = 0.10993865030674847, "order_partner_id" = 43543, "price_reduce" = '40.75', "price_reduce_taxexcl" = '40.75', "price_reduce_taxinc" = '40.75', "price_subtotal" = '81.50', "price_tax" = 0.0, "price_total" = '81.50', "purchase_price" = '36.27', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 986, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 41, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (144295);

Date: 2023-05-02 12:33:55 Duration: 327ms
UPDATE "sale_order_line" SET "branch_id" = 45, "currency_id" = 2, "cus_date_order" = '2023-05-02 18:51:30', "cus_part_route" = NULL, "cus_user_id" = 985, "inventory_vendor_id" = 3012, "is_service" = false, "margin" = '26.00', "margin_percent" = 0.4, "order_partner_id" = 34093, "price_reduce" = '65.00', "price_reduce_taxexcl" = '65.00', "price_reduce_taxinc" = '69.55', "price_subtotal" = '65.00', "price_tax" = 4.55, "price_total" = '69.55', "purchase_price" = '39.00', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 985, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 42, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (145084);

Date: 2023-05-02 18:52:15 Duration: 317ms
UPDATE "sale_order_line" SET "branch_id" = 46, "currency_id" = 2, "cus_date_order" = '2023-05-02 14:46:33', "cus_part_route" = NULL, "cus_user_id" = 1009, "inventory_vendor_id" = 2983, "is_service" = false, "margin" = '99.67', "margin_percent" = 0.460008307564499, "order_partner_id" = 50154, "price_reduce" = '216.67', "price_reduce_taxexcl" = '216.67', "price_reduce_taxinc" = '231.30', "price_subtotal" = '216.67', "price_tax" = 14.63, "price_total" = '231.30', "purchase_price" = '117.00', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1009, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 43, "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (144692);

Date: 2023-05-02 14:47:05 Duration: 308ms

15

786

Details

7m5s

142ms

1s694ms

540ms

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
May 02	09	11	6s85ms	553ms
	11	36	20s319ms	564ms
	12	86	45s711ms	531ms
	13	135	1m16s	569ms
	14	100	55s225ms	552ms
	15	81	40s287ms	497ms
	16	48	24s855ms	517ms
	17	49	24s719ms	504ms
	18	123	1m4s	528ms
	19	76	42s677ms	561ms
	20	37	20s624ms	557ms
	21	4	2s703ms	675ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 959, "write_date" = (now() at time zone 'UTC') WHERE id IN (288801, 288796);

Date: 2023-05-02 12:36:51 Duration: 1s694ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (283912, 283917, 283909, 283910);

Date: 2023-05-02 19:19:04 Duration: 1s680ms
UPDATE "stock_quant" SET "quantity" = 2.0, "reserved_quantity" = 0.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (266616, 284349);

Date: 2023-05-02 18:39:38 Duration: 1s671ms

16

735

Details

2m40s

198ms

506ms

218ms

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

Day	Hour	Count	Duration	Avg duration
May 02	09	15	3s120ms	208ms
	11	45	9s761ms	216ms
	12	78	17s90ms	219ms
	13	137	29s540ms	215ms
	14	120	26s505ms	220ms
	15	94	20s417ms	217ms
	16	36	7s770ms	215ms
	17	44	9s813ms	223ms
	18	84	18s700ms	222ms
	19	49	10s590ms	216ms
	20	32	7s197ms	224ms
	21	1	206ms	206ms

UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '47.28', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (144683, 144684);

Date: 2023-05-02 18:13:17 Duration: 506ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '8.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '912.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 951, "write_date" = (now() at time zone 'UTC') WHERE id IN (144411);

Date: 2023-05-02 15:07:39 Duration: 485ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '9.95', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1043, "write_date" = (now() at time zone 'UTC') WHERE id IN (144665, 144619);

Date: 2023-05-02 14:29:24 Duration: 484ms

17

656

Details

3m33s

282ms

582ms

325ms

select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
May 02	11	82	25s755ms	314ms
	12	144	47s682ms	331ms
	13	184	1m2s	338ms
	14	115	35s690ms	310ms
	15	131	42s301ms	322ms

select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Date: 2023-05-02 13:16:21 Duration: 582ms
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Date: 2023-05-02 13:28:53 Duration: 518ms
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Date: 2023-05-02 13:28:53 Duration: 514ms

18

630

Details

5m20s

139ms

1s718ms

508ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
May 02	06	1	408ms	408ms
	09	4	1s690ms	422ms
	11	25	13s489ms	539ms
	12	41	20s501ms	500ms
	13	66	31s834ms	482ms
	14	41	19s953ms	486ms
	15	63	32s476ms	515ms
	16	76	33s485ms	440ms
	17	103	52s960ms	514ms
	18	72	33s527ms	465ms
	19	91	53s50ms	582ms
	20	42	24s522ms	583ms
	21	5	2s731ms	546ms

UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91730, 281307, 91263, 87191);

Date: 2023-05-02 19:30:44 Duration: 1s718ms
UPDATE "stock_quant" SET "quantity" = 1.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (276784, 276785, 288654, 288655);

Date: 2023-05-02 11:50:16 Duration: 1s716ms
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91730, 281307, 91263, 87191);

Date: 2023-05-02 19:31:34 Duration: 1s653ms

19

591

Details

9m8s

197ms

4s277ms

927ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
May 02	12	29	16s824ms	580ms
	13	9	4s985ms	553ms
	14	4	2s431ms	607ms
	15	9	3s917ms	435ms
	16	15	14s600ms	973ms
	17	11	2s767ms	251ms
	18	275	3m54s	852ms
	19	108	2m9s	1s195ms
	20	126	2m15s	1s74ms
	21	5	3s718ms	743ms

UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 19:02:17 Duration: 4s277ms
UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 18:58:52 Duration: 3s995ms
UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 29320, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 19:00:29 Duration: 3s945ms

20

563

Details

7m44s

295ms

2s269ms

825ms

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
May 02	06	1	295ms	295ms
	09	3	2s629ms	876ms
	11	34	30s297ms	891ms
	12	67	54s308ms	810ms
	13	88	1m11s	813ms
	14	63	53s817ms	854ms
	15	49	37s913ms	773ms
	16	30	23s449ms	781ms
	17	58	48s901ms	843ms
	18	84	1m7s	807ms
	19	43	37s601ms	874ms
	20	40	32s902ms	822ms
	21	3	3s148ms	1s49ms

UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-05-02 19:18:57', "is_done" = true, "state" = 'done', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (367272, 367274, 367270);

Date: 2023-05-02 19:19:10 Duration: 2s269ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-05-02 18:39:27', "is_done" = true, "state" = 'done', "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (396985, 396981);

Date: 2023-05-02 18:39:32 Duration: 2s214ms
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2023-05-02 11:11:17', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (395306, 395299, 394796);

Date: 2023-05-02 11:11:20 Duration: 2s183ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

299ms

18s203ms

2s638ms

180

Details

7m54s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
May 02	09	2	7s630ms	3s815ms
	11	2	3s995ms	1s997ms
	12	6	16s442ms	2s740ms
	13	19	22s763ms	1s198ms
	14	22	1m4s	2s941ms
	15	33	48s582ms	1s472ms
	16	20	1m27s	4s363ms
	17	25	1m1s	2s475ms
	18	18	17s345ms	963ms
	19	21	2m7s	6s49ms
	20	12	17s261ms	1s438ms

UPDATE "stock_move" SET "date" = '2023-05-02 19:31:10', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868);

Date: 2023-05-02 19:31:28 Duration: 18s203ms
UPDATE "stock_move" SET "date" = '2023-05-02 19:32:01', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868);

Date: 2023-05-02 19:32:19 Duration: 18s102ms
UPDATE "stock_move" SET "date" = '2023-05-02 19:30:20', "state" = 'done', "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (390837, 390838, 390839, 390840, 390841, 390842, 390843, 390844, 390845, 390846, 390847, 390848, 390849, 390850, 390851, 390852, 390853, 390854, 390855, 390856, 390857, 390858, 390859, 390860, 390861, 390862, 390863, 390864, 390865, 390866, 390867, 390868);

Date: 2023-05-02 19:30:38 Duration: 18s38ms

2

144ms

11s167ms

965ms

336

Details

5m24s

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

Day	Hour	Count	Duration	Avg duration
May 02	00	1	1s198ms	1s198ms
	11	26	27s200ms	1s46ms
	12	37	40s963ms	1s107ms
	13	50	50s417ms	1s8ms
	14	41	46s363ms	1s130ms
	15	35	27s981ms	799ms
	16	29	19s211ms	662ms
	17	32	23s988ms	749ms
	18	38	34s889ms	918ms
	19	34	41s400ms	1s217ms
	20	11	7s105ms	645ms
	21	1	699ms	699ms
	22	1	3s83ms	3s83ms

UPDATE "stock_move" SET "branch_id" = 48, "picking_id" = 134410, "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 (397280, 397281, 397282, 397283, 397284, 397285, 397286, 397287, 397288, 397289, 397290, 397291, 397292, 397293, 397294, 397295, 397296, 397297, 397298, 397299);

Date: 2023-05-02 19:29:46 Duration: 11s167ms
UPDATE "stock_move" SET "branch_id" = 46, "picking_id" = 133783, "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 (396143, 396144, 396145, 396146, 396147, 396148, 396149, 396150, 396151, 396152, 396153, 396154, 396155);

Date: 2023-05-02 14:57:00 Duration: 6s884ms
UPDATE "stock_move" SET "branch_id" = 46, "picking_id" = 133354, "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 (395520, 395521, 395522, 395523, 395524, 395525, 395526, 395527, 395528, 395529, 395517, 395518, 395519);

Date: 2023-05-02 12:34:59 Duration: 6s417ms

3

197ms

4s277ms

927ms

591

Details

9m8s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
May 02	12	29	16s824ms	580ms
	13	9	4s985ms	553ms
	14	4	2s431ms	607ms
	15	9	3s917ms	435ms
	16	15	14s600ms	973ms
	17	11	2s767ms	251ms
	18	275	3m54s	852ms
	19	108	2m9s	1s195ms
	20	126	2m15s	1s74ms
	21	5	3s718ms	743ms

UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 19:02:17 Duration: 4s277ms
UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 18:58:52 Duration: 3s995ms
UPDATE "repair_line" SET "open_qty_fil" = 1.0, "qty_delivered" = '0.00', "write_uid" = 1031, "write_date" = (now() at time zone 'UTC') WHERE id IN (29312, 29313, 29314, 27331, 28065, 28064, 29318, 27809, 29320, 27810, 27811, 27812, 27813, 27816, 27817, 28068, 28073, 29309, 28063);

Date: 2023-05-02 19:00:29 Duration: 3s945ms

4

290ms

7s300ms

923ms

290

Details

4m27s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
May 02	11	6	2s936ms	489ms
	12	25	16s455ms	658ms
	13	22	12s799ms	581ms
	14	35	36s793ms	1s51ms
	15	43	32s983ms	767ms
	16	37	51s660ms	1s396ms
	17	41	34s256ms	835ms
	18	34	21s535ms	633ms
	19	31	49s859ms	1s608ms
	20	14	7s746ms	553ms
	21	2	831ms	415ms

UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 2924, "warehouse_id" = 43, "write_uid" = 1006, "write_date" = (now() at time zone 'UTC') WHERE id IN (288992, 288994, 288996, 288974, 288975, 288976, 288977, 288978, 288979, 288980, 288981, 288983, 288985, 288986, 288988, 288990, 288991);

Date: 2023-05-02 14:17:29 Duration: 7s300ms
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3026, "warehouse_id" = 45, "write_uid" = 981, "write_date" = (now() at time zone 'UTC') WHERE id IN (289004, 289005, 289006, 289007, 289008, 289009, 289010, 289011, 289012, 289013, 289014, 289016, 289017, 289018, 289020, 289021, 289023);

Date: 2023-05-02 14:24:07 Duration: 7s66ms
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 2952, "warehouse_id" = 35, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (289700, 289701, 289702, 289703, 289704, 289705, 289706, 289707, 289708, 289710, 289711, 289713, 289714);

Date: 2023-05-02 19:31:50 Duration: 5s546ms

5

526ms

3s631ms

831ms

349

Details

4m50s

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
May 02	09	1	710ms	710ms
	11	12	9s74ms	756ms
	12	47	37s967ms	807ms
	13	55	51s669ms	939ms
	14	30	25s162ms	838ms
	15	37	26s962ms	728ms
	16	26	23s647ms	909ms
	17	28	21s716ms	775ms
	18	58	46s550ms	802ms
	19	38	29s913ms	787ms
	20	16	15s315ms	957ms
	21	1	1s430ms	1s430ms

UPDATE "stock_move" SET "date" = '2023-05-02 13:52:53', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (383607, 383608, 383609, 383610, 383611);

Date: 2023-05-02 13:53:03 Duration: 3s631ms
UPDATE "stock_move" SET "date" = '2023-05-02 19:18:57', "is_done" = true, "state" = 'done', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (367265, 367266, 367268, 367262);

Date: 2023-05-02 19:19:07 Duration: 3s60ms
UPDATE "stock_move" SET "date" = '2023-05-02 16:20:34', "is_done" = true, "state" = 'done', "write_uid" = 1000, "write_date" = (now() at time zone 'UTC') WHERE id IN (368049, 396362, 368051, 368055);

Date: 2023-05-02 16:20:37 Duration: 2s669ms

6

295ms

2s269ms

825ms

563

Details

7m44s

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

Day	Hour	Count	Duration	Avg duration
May 02	06	1	295ms	295ms
	09	3	2s629ms	876ms
	11	34	30s297ms	891ms
	12	67	54s308ms	810ms
	13	88	1m11s	813ms
	14	63	53s817ms	854ms
	15	49	37s913ms	773ms
	16	30	23s449ms	781ms
	17	58	48s901ms	843ms
	18	84	1m7s	807ms
	19	43	37s601ms	874ms
	20	40	32s902ms	822ms
	21	3	3s148ms	1s49ms

UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-05-02 19:18:57', "is_done" = true, "state" = 'done', "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (367272, 367274, 367270);

Date: 2023-05-02 19:19:10 Duration: 2s269ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-05-02 18:39:27', "is_done" = true, "state" = 'done', "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (396985, 396981);

Date: 2023-05-02 18:39:32 Duration: 2s214ms
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2023-05-02 11:11:17', "is_done" = true, "state" = 'done', "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (395306, 395299, 394796);

Date: 2023-05-02 11:11:20 Duration: 2s183ms

7

684ms

1s79ms

724ms

1,129

Details

13m38s

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

Day	Hour	Count	Duration	Avg duration
May 02	10	5	3s517ms	703ms
	11	74	53s929ms	728ms
	12	162	1m58s	734ms
	13	158	1m54s	727ms
	14	121	1m28s	730ms
	15	81	58s604ms	723ms
	16	80	57s700ms	721ms
	17	95	1m9s	727ms
	18	166	1m59s	722ms
	19	127	1m30s	711ms
	20	53	37s918ms	715ms
	21	5	3s550ms	710ms
	22	2	1s416ms	708ms

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 ('%cw%')) 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 ('%cw%'))) 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 ('%cw%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%cw%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 20:02:17 Duration: 1s79ms
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 ('%3/4x28%')) 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 ('%3/4x28%'))) 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 ('%3/4x28%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3/4x28%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 12:34:53 Duration: 1s44ms
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 ('%b101%')) 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 ('%b101%'))) 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 ('%b101%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%b101%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;

Date: 2023-05-02 13:21:31 Duration: 1s38ms

8

526ms

1s190ms

579ms

4,334

Details

41m53s

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

Day	Hour	Count	Duration	Avg duration
May 02	00	13	7s276ms	559ms
	11	354	3m24s	578ms
	12	553	5m24s	587ms
	13	693	6m49s	591ms
	14	607	5m55s	585ms
	15	351	3m24s	583ms
	16	230	2m12s	577ms
	17	333	3m12s	578ms
	18	368	3m32s	576ms
	19	394	3m43s	567ms
	20	294	2m44s	560ms
	21	105	58s772ms	559ms
	22	39	21s716ms	556ms

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 ('%%68%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%6-8%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%6-8%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 18:44:49 Duration: 1s190ms
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 ('%%201031e%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%20-1031e%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%20-1031e%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 14:03:50 Duration: 965ms
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 ('%%441030910%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%441 030 910%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%441 030 910%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:15:48 Duration: 896ms

9

535ms

903ms

578ms

461

Details

4m26s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
May 02	06	2	1s122ms	561ms
	10	3	1s691ms	563ms
	11	4	2s340ms	585ms
	12	13	7s482ms	575ms
	13	112	1m4s	579ms
	14	110	1m4s	583ms
	15	79	45s893ms	580ms
	16	41	23s352ms	569ms
	17	41	23s604ms	575ms
	18	28	16s189ms	578ms
	19	21	12s54ms	574ms
	20	7	3s922ms	560ms

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

Date: 2023-05-02 14:44:31 Duration: 903ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%464257%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%464.257%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%464.257%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 19:19:07 Duration: 734ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%572%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%572%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%572%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 14:47:19 Duration: 724ms

10

533ms

1s30ms

577ms

1,747

Details

16m48s

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

Day	Hour	Count	Duration	Avg duration
May 02	06	1	551ms	551ms
	07	2	1s110ms	555ms
	08	1	559ms	559ms
	09	15	8s623ms	574ms
	10	33	18s733ms	567ms
	11	34	19s638ms	577ms
	12	106	1m2s	589ms
	13	73	42s930ms	588ms
	14	100	57s562ms	575ms
	15	156	1m31s	585ms
	16	164	1m34s	577ms
	17	115	1m6s	580ms
	18	466	4m30s	580ms
	19	225	2m8s	573ms
	20	232	2m10s	561ms
	21	24	13s406ms	558ms

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 ('%%pl13688c%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%pl1368-8c%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%pl1368-8c%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 18:26:25 Duration: 1s30ms
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 ('%%16M%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%16M%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%16M%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 12:40:38 Duration: 928ms
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 ('%%20355%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%2-0355%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%2-0355%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:24:38 Duration: 901ms

11

533ms

843ms

576ms

508

Details

4m52s

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"."type" != ?) or "product_product__product_tmpl_id"."type" is null)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
May 02	12	28	15s943ms	569ms
	13	58	33s833ms	583ms
	14	115	1m7s	584ms
	15	76	43s932ms	578ms
	16	54	31s14ms	574ms
	17	26	15s271ms	587ms
	18	56	32s235ms	575ms
	19	22	12s296ms	558ms
	20	50	28s148ms	562ms
	22	23	12s830ms	557ms

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

Date: 2023-05-02 13:22:22 Duration: 843ms
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 ('%%ab1dk23l%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ab1dk23l-%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ab1dk23l-%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 14:01:43 Duration: 755ms
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 ('%%iuj%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%iuj%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%iuj%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."type" != 'service') OR "product_product__product_tmpl_id"."type" IS NULL)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-05-02 13:21:30 Duration: 752ms

12

142ms

1s694ms

540ms

786

Details

7m5s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
May 02	09	11	6s85ms	553ms
	11	36	20s319ms	564ms
	12	86	45s711ms	531ms
	13	135	1m16s	569ms
	14	100	55s225ms	552ms
	15	81	40s287ms	497ms
	16	48	24s855ms	517ms
	17	49	24s719ms	504ms
	18	123	1m4s	528ms
	19	76	42s677ms	561ms
	20	37	20s624ms	557ms
	21	4	2s703ms	675ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 959, "write_date" = (now() at time zone 'UTC') WHERE id IN (288801, 288796);

Date: 2023-05-02 12:36:51 Duration: 1s694ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 953, "write_date" = (now() at time zone 'UTC') WHERE id IN (283912, 283917, 283909, 283910);

Date: 2023-05-02 19:19:04 Duration: 1s680ms
UPDATE "stock_quant" SET "quantity" = 2.0, "reserved_quantity" = 0.0, "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (266616, 284349);

Date: 2023-05-02 18:39:38 Duration: 1s671ms

13

137ms

11s226ms

532ms

484

Details

4m17s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
May 02	11	3	1s612ms	537ms
	12	44	14s877ms	338ms
	13	44	18s247ms	414ms
	14	50	24s138ms	482ms
	15	26	16s738ms	643ms
	16	18	8s812ms	489ms
	17	63	33s885ms	537ms
	18	129	1m16s	590ms
	19	68	33s462ms	492ms
	20	28	26s321ms	940ms
	21	4	1s830ms	457ms
	22	7	1s737ms	248ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (396831, 396832, 396833, 396834, 396835, 396837, 396838, 396839, 396840, 396841, 396842, 396843, 396844, 396845, 396846, 396847, 396848, 396849, 396850, 396851, 396852, 396853, 396854, 396855, 396856, 396857, 396858);

Date: 2023-05-02 18:12:08 Duration: 11s226ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (397509, 397510, 397490, 397491, 397492, 397493, 397494, 397495, 397497, 397498, 397499, 397500, 397501);

Date: 2023-05-02 20:55:55 Duration: 6s262ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 979, "write_date" = (now() at time zone 'UTC') WHERE id IN (396980, 396981, 396982, 396983, 396984, 396985, 396986);

Date: 2023-05-02 18:39:18 Duration: 5s41ms

14

139ms

1s718ms

508ms

630

Details

5m20s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
May 02	06	1	408ms	408ms
	09	4	1s690ms	422ms
	11	25	13s489ms	539ms
	12	41	20s501ms	500ms
	13	66	31s834ms	482ms
	14	41	19s953ms	486ms
	15	63	32s476ms	515ms
	16	76	33s485ms	440ms
	17	103	52s960ms	514ms
	18	72	33s527ms	465ms
	19	91	53s50ms	582ms
	20	42	24s522ms	583ms
	21	5	2s731ms	546ms

UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91730, 281307, 91263, 87191);

Date: 2023-05-02 19:30:44 Duration: 1s718ms
UPDATE "stock_quant" SET "quantity" = 1.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (276784, 276785, 288654, 288655);

Date: 2023-05-02 11:50:16 Duration: 1s716ms
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (91730, 281307, 91263, 87191);

Date: 2023-05-02 19:31:34 Duration: 1s653ms

15

282ms

582ms

325ms

656

Details

3m33s

select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
May 02	11	82	25s755ms	314ms
	12	144	47s682ms	331ms
	13	184	1m2s	338ms
	14	115	35s690ms	310ms
	15	131	42s301ms	322ms

select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Date: 2023-05-02 13:16:21 Duration: 582ms
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Date: 2023-05-02 13:28:53 Duration: 518ms
select id from product_warehouse_inventory where loc_check_qty < max_product_uom_qty;

Date: 2023-05-02 13:28:53 Duration: 514ms

16

120ms

781ms

251ms

4,577

Details

19m12s

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

Day	Hour	Count	Duration	Avg duration
May 02	10	8	1s61ms	132ms
	11	43	6s427ms	149ms
	12	640	3m1s	284ms
	13	594	3m2s	307ms
	14	675	3m3s	272ms
	15	488	1m55s	237ms
	16	481	1m44s	217ms
	17	487	1m52s	230ms
	18	695	3m1s	261ms
	19	211	39s851ms	188ms
	20	186	31s919ms	171ms
	21	62	9s715ms	156ms
	23	7	934ms	133ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 12:39:46') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_949"', '["pointspring_master","calendar.alarm",19487]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",342]', '["pointspring_master","mail.channel",343]', '["pointspring_master","mail.channel",344]', '["pointspring_master","mail.channel",359]', '["pointspring_master","res.partner",19487]', '["pointspring_master","ir.needaction",19487]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 12:40:37 Duration: 781ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 13:16:22') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_977"', '["pointspring_master","calendar.alarm",19515]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",192]', '["pointspring_master","mail.channel",193]', '["pointspring_master","mail.channel",449]', '["pointspring_master","mail.channel",454]', '["pointspring_master","mail.channel",461]', '["pointspring_master","mail.channel",484]', '["pointspring_master","res.partner",19515]', '["pointspring_master","ir.needaction",19515]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 13:17:13 Duration: 755ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-05-02 18:43:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1022"', '["pointspring_master","calendar.alarm",19560]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",105]', '["pointspring_master","mail.channel",106]', '["pointspring_master","mail.channel",107]', '["pointspring_master","mail.channel",108]', '["pointspring_master","mail.channel",109]', '["pointspring_master","mail.channel",110]', '["pointspring_master","mail.channel",341]', '["pointspring_master","mail.channel",437]', '["pointspring_master","mail.channel",440]', '["pointspring_master","res.partner",19560]', '["pointspring_master","ir.needaction",19560]'))) ORDER BY "bus_bus"."id";

Date: 2023-05-02 18:44:49 Duration: 751ms

17

216ms

421ms

232ms

888

Details

3m26s

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

Day	Hour	Count	Duration	Avg duration
May 02	00	5	1s113ms	222ms
	11	251	57s782ms	230ms
	12	68	16s122ms	237ms
	13	79	18s432ms	233ms
	14	58	13s534ms	233ms
	15	50	11s733ms	234ms
	16	49	11s236ms	229ms
	17	111	25s663ms	231ms
	18	79	18s796ms	237ms
	19	83	19s94ms	230ms
	20	51	11s547ms	226ms
	21	4	1s1ms	250ms

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

Date: 2023-05-02 11:50:25 Duration: 421ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (144937)) ORDER BY "sale_line_report"."id";

Date: 2023-05-02 17:21:32 Duration: 328ms
SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (145277)) ORDER BY "sale_line_report"."id";

Date: 2023-05-02 21:42:34 Duration: 320ms

18

198ms

1s908ms

226ms

826

Details

3m6s

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
May 02	09	15	3s221ms	214ms
	11	52	11s333ms	217ms
	12	81	17s759ms	219ms
	13	154	34s202ms	222ms
	14	140	30s540ms	218ms
	15	105	23s174ms	220ms
	16	63	16s33ms	254ms
	17	48	10s927ms	227ms
	18	61	13s734ms	225ms
	19	65	16s515ms	254ms
	20	41	9s187ms	224ms
	21	1	217ms	217ms

UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 10.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 967, "write_date" = (now() at time zone 'UTC') WHERE id IN (129219, 134020, 129220, 129221, 122599, 134021, 57072, 131441, 131455);

Date: 2023-05-02 16:08:19 Duration: 1s908ms
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" = 977, "write_date" = (now() at time zone 'UTC') WHERE id IN (139650, 141111, 117712, 139667, 138999);

Date: 2023-05-02 19:33:37 Duration: 1s121ms
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 0.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (117265, 116682, 116755, 116701);

Date: 2023-05-02 19:19:07 Duration: 1s34ms

19

199ms

371ms

225ms

1,008

Details

3m47s

select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."so_line_id" in (...)) order by "sale_history_line"."id";

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
May 02	00	5	1s67ms	213ms
	11	91	20s146ms	221ms
	12	143	32s676ms	228ms
	13	175	39s337ms	224ms
	14	120	27s32ms	225ms
	15	99	22s175ms	223ms
	16	61	14s42ms	230ms
	17	79	17s707ms	224ms
	18	104	23s928ms	230ms
	19	98	21s793ms	222ms
	20	22	4s888ms	222ms
	21	4	850ms	212ms
	22	7	1s476ms	210ms

SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (145029)) ORDER BY "sale_history_line"."id";

Date: 2023-05-02 18:29:26 Duration: 371ms
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (144009)) ORDER BY "sale_history_line"."id";

Date: 2023-05-02 13:38:22 Duration: 367ms
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."so_line_id" in (144307)) ORDER BY "sale_history_line"."id";

Date: 2023-05-02 12:34:47 Duration: 359ms

20

199ms

327ms

220ms

801

Details

2m56s

update "sale_order_line" set "branch_id" = ?, "currency_id" = ?, "cus_date_order" = ?, "cus_part_route" = ?, "cus_user_id" = ?, "inventory_vendor_id" = ?, "is_service" = false, "margin" = ?, "margin_percent" = ?.?, "order_partner_id" = ?, "price_reduce" = ?, "price_reduce_taxexcl" = ?, "price_reduce_taxinc" = ?, "price_subtotal" = ?, "price_tax" = ?.?, "price_total" = ?, "purchase_price" = ?, "qty_delivered_method" = ?, "qty_invoiced" = ?, "qty_to_invoice" = ?, "salesman_id" = ?, "untaxed_amount_invoiced" = ?, "untaxed_amount_to_invoice" = ?, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
May 02	00	4	843ms	210ms
	11	76	16s715ms	219ms
	12	103	23s925ms	232ms
	13	114	25s146ms	220ms
	14	84	18s331ms	218ms
	15	60	13s282ms	221ms
	16	43	9s427ms	219ms
	17	79	17s492ms	221ms
	18	78	17s329ms	222ms
	19	70	15s162ms	216ms
	20	54	11s661ms	215ms
	21	27	5s707ms	211ms
	22	9	1s932ms	214ms

UPDATE "sale_order_line" SET "branch_id" = 44, "currency_id" = 2, "cus_date_order" = '2023-05-02 12:32:58', "cus_part_route" = NULL, "cus_user_id" = 986, "inventory_vendor_id" = 3085, "is_service" = false, "margin" = '8.96', "margin_percent" = 0.10993865030674847, "order_partner_id" = 43543, "price_reduce" = '40.75', "price_reduce_taxexcl" = '40.75', "price_reduce_taxinc" = '40.75', "price_subtotal" = '81.50', "price_tax" = 0.0, "price_total" = '81.50', "purchase_price" = '36.27', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 986, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 41, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (144295);

Date: 2023-05-02 12:33:55 Duration: 327ms
UPDATE "sale_order_line" SET "branch_id" = 45, "currency_id" = 2, "cus_date_order" = '2023-05-02 18:51:30', "cus_part_route" = NULL, "cus_user_id" = 985, "inventory_vendor_id" = 3012, "is_service" = false, "margin" = '26.00', "margin_percent" = 0.4, "order_partner_id" = 34093, "price_reduce" = '65.00', "price_reduce_taxexcl" = '65.00', "price_reduce_taxinc" = '69.55', "price_subtotal" = '65.00', "price_tax" = 4.55, "price_total" = '69.55', "purchase_price" = '39.00', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 985, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 42, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (145084);

Date: 2023-05-02 18:52:15 Duration: 317ms
UPDATE "sale_order_line" SET "branch_id" = 46, "currency_id" = 2, "cus_date_order" = '2023-05-02 14:46:33', "cus_part_route" = NULL, "cus_user_id" = 1009, "inventory_vendor_id" = 2983, "is_service" = false, "margin" = '99.67', "margin_percent" = 0.460008307564499, "order_partner_id" = 50154, "price_reduce" = '216.67', "price_reduce_taxexcl" = '216.67', "price_reduce_taxinc" = '231.30', "price_subtotal" = '216.67', "price_tax" = 14.63, "price_total" = '231.30', "purchase_price" = '117.00', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1009, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 43, "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (144692);

Date: 2023-05-02 14:47:05 Duration: 308ms

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

55,156 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	79	0.14%
DETAIL	45	0.08%
ERROR	1,612	2.92%
LOG	51,766	93.85%
STATEMENT	1,654	3.00%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
1612 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

828 Max number of times the same event was reported
1,612 Total events found

Rank

Times reported

Error

1

828

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
May 02	00	61
	01	67
	02	64
	03	47
	04	42
	05	47
	06	47
	07	75
	08	49
	09	44
	10	43
	11	15
	12	27
	13	15
	14	12
	15	12
	16	15
	17	7
	18	11
	19	7
	20	8
	21	12
	22	49
	23	52

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

2

733

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
May 02	02	3
	04	1
	07	1
	08	7
	10	8
	11	40
	12	66
	13	143
	14	126
	15	91
	16	74
	17	63
	18	44
	19	45
	20	18
	21	2
	22	1

ERROR: could not serialize access due to concurrent update

3

38

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
May 02	11	1
	12	2
	13	9
	14	6
	15	6
	16	1
	17	2
	18	5
	19	4
	20	2

ERROR: process 2824438 still waiting for ShareLock on transaction 108895628 after 1000.045 ms
ERROR: process 2932397 still waiting for ShareLock on transaction 108903649 after 1000.080 ms
ERROR: process 2933066 still waiting for ShareLock on transaction 108905150 after 1000.043 ms

4

Details

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

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
May 02	06	1
	20	3

ERROR: syntax error at or near "product_warehouse_inventory" at character 625
ERROR: syntax error at or near "409" at character 104

5

4

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
May 02	14	4

ERROR: process 2932404 still waiting for ExclusiveLock on tuple (15467,20) of relation 42418 of database 65946 after 1000.042 ms
ERROR: process 2932399 still waiting for ExclusiveLock on tuple (16235,7) of relation 42418 of database 65946 after 1000.058 ms
ERROR: process 2932883 still waiting for ExclusiveLock on tuple (16235,7) of relation 42418 of database 65946 after 1000.077 ms

6

2

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
May 02	09	2

ERROR: could not create unique index "vendor_account_master_unique_acc_no"

7

1

Details

ERROR: invalid input syntax for type integer: ...

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
May 02	18	1

ERROR: invalid input syntax for type integer: "virtual_3558" at character 3473

8

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
May 02	18	1

ERROR: could not serialize access due to concurrent delete

9

1

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
May 02	13	1

ERROR: new row for relation "account_payment" violates check constraint "account_payment_check_amount_not_negative"

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