pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Sep 15 00:50:11 2023
Log file: /var/log/postgresql/postgresql-14-main.log
Parsed 105,718 log entries in 10s
Log start from 2023-09-14 00:00:05 to 2023-09-14 23:59:04

Global Stats

1,017 Number of unique normalized queries
37,519 Number of queries
4h14m6s Total query duration
2023-09-14 00:07:22 First query
2023-09-14 23:59:02 Last query
46 queries/s at 2023-09-14 12:15:08 Query peak

4h14m6s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
4h14m6s Execute total duration

1,094 Number of events
13 Number of unique normalized events
546 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
37,519 Average queries per session
4h14m6s 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

46 queries/s Query Peak
2023-09-14 12:15:08 Date

SELECT Traffic

Key values

46 queries/s Query Peak
2023-09-14 12:15:08 Date

INSERT/UPDATE/DELETE Traffic

Key values

13 queries/s Query Peak
2023-09-14 13:01:55 Date

Queries duration

Key values

4h14m6s 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)
Sep 14	00	39	0ms	752ms	324ms	1s479ms	3s544ms	3s544ms
	01	30	0ms	249ms	169ms	881ms	1s344ms	1s344ms
	02	32	0ms	218ms	172ms	1s185ms	1s986ms	1s986ms
	03	25	0ms	10s845ms	759ms	15s441ms	15s441ms	15s441ms
	04	32	0ms	4s498ms	580ms	14s814ms	14s814ms	14s814ms
	05	13	0ms	254ms	176ms	1s237ms	1s237ms	1s237ms
	06	37	0ms	21s620ms	1s660ms	16s458ms	26s157ms	26s157ms
	07	38	0ms	18s399ms	977ms	11s981ms	19s541ms	19s541ms
	08	89	0ms	11s686ms	1s494ms	32s385ms	38s410ms	38s410ms
	09	212	0ms	3m44s	3s141ms	1m1s	1m28s	4m5s
	10	244	0ms	3s820ms	489ms	7s380ms	7s695ms	10s186ms
	11	1,908	120ms	7s230ms	387ms	28s359ms	38s185ms	46s201ms
	12	4,579	120ms	20s710ms	390ms	1m3s	1m7s	1m25s
	13	5,390	120ms	7s599ms	381ms	56s318ms	1m2s	1m19s
	14	5,765	120ms	8s226ms	387ms	58s343ms	1m5s	1m22s
	15	4,424	120ms	7s717ms	406ms	53s459ms	1m6s	1m14s
	16	2,922	120ms	12s68ms	418ms	38s262ms	46s316ms	53s920ms
	17	4,261	120ms	11s245ms	334ms	46s698ms	50s221ms	51s739ms
	18	3,250	120ms	10s223ms	385ms	32s937ms	38s150ms	51s553ms
	19	2,617	120ms	11s459ms	373ms	28s138ms	42s16ms	50s972ms
	20	1,151	0ms	3s566ms	393ms	17s400ms	20s617ms	32s192ms
	21	306	0ms	3s7ms	453ms	9s417ms	13s7ms	20s285ms
	22	112	0ms	3s626ms	300ms	4s15ms	4s529ms	5s669ms
	23	43	0ms	13s29ms	1s51ms	1s156ms	15s532ms	17s652ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Sep 14	00	39	0	324ms	1s120ms	1s479ms	3s544ms
	01	30	0	169ms	865ms	881ms	1s344ms
	02	32	0	172ms	861ms	1s185ms	1s986ms
	03	21	0	168ms	995ms	1s19ms	1s19ms
	04	28	0	629ms	2s43ms	14s357ms	14s357ms
	05	13	0	176ms	656ms	1s237ms	1s237ms
	06	27	0	168ms	699ms	765ms	1s765ms
	07	34	0	164ms	673ms	741ms	1s505ms
	08	89	0	1s494ms	17s426ms	32s385ms	38s410ms
	09	85	83	3s854ms	36s605ms	56s598ms	4m5s
	10	195	0	516ms	5s400ms	6s479ms	8s204ms
	11	1,411	0	402ms	14s953ms	24s783ms	41s441ms
	12	3,331	0	401ms	37s541ms	49s679ms	1m2s
	13	3,957	0	389ms	34s542ms	40s316ms	52s70ms
	14	3,649	0	409ms	33s562ms	41s337ms	46s643ms
	15	2,762	0	440ms	31s596ms	44s157ms	51s390ms
	16	2,103	0	443ms	23s608ms	29s927ms	44s58ms
	17	2,791	0	315ms	23s4ms	32s201ms	36s236ms
	18	2,295	0	389ms	23s824ms	28s364ms	33s226ms
	19	1,954	0	382ms	17s824ms	25s743ms	40s162ms
	20	663	0	459ms	9s278ms	12s617ms	19s200ms
	21	205	0	473ms	2s975ms	6s789ms	15s774ms
	22	94	0	284ms	1s728ms	3s48ms	4s529ms
	23	29	0	211ms	679ms	824ms	880ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Sep 14	00	0	0	0	0ms	0ms	0ms	0ms
	01	0	0	0	0ms	0ms	0ms	0ms
	02	0	0	0	0ms	0ms	0ms	0ms
	03	0	0	4	3s860ms	0ms	0ms	15s441ms
	04	0	4	0	235ms	0ms	456ms	486ms
	05	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	10	5s689ms	0ms	14s275ms	26s157ms
	07	0	0	4	7s880ms	0ms	0ms	19s541ms
	08	0	0	0	0ms	0ms	0ms	0ms
	09	0	44	0	416ms	0ms	0ms	4s964ms
	10	1	47	1	384ms	0ms	0ms	3s820ms
	11	10	465	22	343ms	2s392ms	4s102ms	11s19ms
	12	16	1,177	44	361ms	6s322ms	10s993ms	25s686ms
	13	27	1,365	35	360ms	7s858ms	10s969ms	19s735ms
	14	34	2,050	30	350ms	12s768ms	17s104ms	31s484ms
	15	23	1,589	45	350ms	8s977ms	16s797ms	24s229ms
	16	24	769	23	355ms	4s69ms	6s880ms	16s826ms
	17	26	1,389	37	370ms	9s346ms	12s204ms	25s665ms
	18	26	856	20	356ms	5s655ms	7s611ms	14s825ms
	19	23	611	19	349ms	3s569ms	6s420ms	11s624ms
	20	22	435	29	305ms	3s96ms	5s49ms	7s937ms
	21	17	83	1	412ms	0ms	911ms	9s417ms
	22	0	17	1	380ms	0ms	178ms	967ms
	23	0	1	13	2s792ms	0ms	1s144ms	17s652ms

Day	Hour	Percentage of prepare
Sep 14	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
Sep 14	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
Sep 14	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
Sep 14	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
Sep 14	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)
Sep 14	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
Sep 14	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
Sep 14	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
Sep 14	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
15 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ShareLock		15	59s306ms	3s953ms
	transaction	15	59s306ms	3s953ms
	Total	15	59s306ms	3s953ms

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	3	22s685ms	16s52ms	16s52ms	7s561ms	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 != 889222 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 != 889222 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; Date: 2023-09-14 17:24:54
2	7	16s53ms	1s618ms	6s847ms	2s293ms	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" = 3265114, "write_uid" = 1027, "write_date" = (now() at time zone 'UTC') WHERE id IN (889274); Date: 2023-09-14 17:30:15
3	1	7s563ms	7s563ms	7s563ms	7s563ms	update "sale_order" set "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "sale_order" SET "write_uid" = 1143, "write_date" = (now() at time zone 'UTC') WHERE id IN (81218); Date: 2023-09-14 14:50:30
4	1	6s77ms	6s77ms	6s77ms	6s77ms	insert into "mail_followers" ("id", "channel_id", "partner_id", "res_id", "res_model") values (nextval(?), null, ?, ?, ?) returning id; INSERT INTO "mail_followers" ("id", "channel_id", "partner_id", "res_id", "res_model") VALUES (nextval('mail_followers_id_seq'), NULL, 44447, 81137, 'sale.order') RETURNING id; Date: 2023-09-14 15:20:59
5	1	3s163ms	3s163ms	3s163ms	3s163ms	update "account_move" set "access_token" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...); UPDATE "account_move" SET "access_token" = '389211b8-8535-47c2-8fe0-7b1fdf323b2b', "write_uid" = 1020, "write_date" = (now() at time zone 'UTC') WHERE id IN (888638); Date: 2023-09-14 15:19:52
6	1	1s894ms	1s894ms	1s894ms	1s894ms	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 (...); UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '2.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '989.32', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (236664, 232053); Date: 2023-09-14 12:50:17 UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '49.86', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (236712, 236713); Date: 2023-09-14 12:56:44 UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '3.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '83.97', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (235594, 235595); Date: 2023-09-14 14:35:32
7	1	1s869ms	1s869ms	1s869ms	1s869ms	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 sequence_prefix = ( select sequence_prefix from account_move where journal_id = ? and name != ? and sequence_prefix !~ ? and move_type not in (...) 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 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') ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; Date: 2023-09-14 13:30:40

Queries that waited the most

Rank	Wait time	Query
1	16s52ms	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 != 889222 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 != 889222 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-09-14 17:24:54 ]
2	7s563ms	UPDATE "sale_order" SET "write_uid" = 1143, "write_date" = (now() at time zone 'UTC') WHERE id IN (81218); [ Date: 2023-09-14 14:50:30 ]
3	6s847ms	UPDATE "account_move" SET "message_main_attachment_id" = 3264170, "write_uid" = 1028, "write_date" = (now() at time zone 'UTC') WHERE id IN (888450); [ Date: 2023-09-14 14:47:42 ]
4	6s77ms	INSERT INTO "mail_followers" ("id", "channel_id", "partner_id", "res_id", "res_model") VALUES (nextval('mail_followers_id_seq'), NULL, 44447, 81137, 'sale.order') RETURNING id; [ Date: 2023-09-14 15:20:59 ]
5	4s422ms	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 != 887730 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 != 887730 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-09-14 13:10:46 ]
6	3s163ms	UPDATE "account_move" SET "access_token" = '389211b8-8535-47c2-8fe0-7b1fdf323b2b', "write_uid" = 1020, "write_date" = (now() at time zone 'UTC') WHERE id IN (888638); [ Date: 2023-09-14 15:19:52 ]
7	2s210ms	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 != 887994 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 != 887994 ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-09-14 13:47:26 ]
8	2s136ms	UPDATE "account_move" SET "message_main_attachment_id" = 3263500, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (887899); [ Date: 2023-09-14 13:29:40 ]
9	1s894ms	UPDATE "sale_order_line" SET "invoice_status" = 'no', "qty_invoiced" = '3.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '4.59', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 983, "write_date" = (now() at time zone 'UTC') WHERE id IN (236658); [ Date: 2023-09-14 13:48:26 ]
10	1s869ms	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 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') ORDER BY id DESC LIMIT 1) ORDER BY sequence_number DESC LIMIT 1) RETURNING name; [ Date: 2023-09-14 13:30:40 ]
11	1s840ms	UPDATE "account_move" SET "message_main_attachment_id" = 3263211, "write_uid" = 965, "write_date" = (now() at time zone 'UTC') WHERE id IN (887696); [ Date: 2023-09-14 12:56:46 ]
12	1s618ms	UPDATE "account_move" SET "message_main_attachment_id" = 3265114, "write_uid" = 1027, "write_date" = (now() at time zone 'UTC') WHERE id IN (889274); [ Date: 2023-09-14 17:30:15 ]
13	1s440ms	UPDATE "account_move" SET "message_main_attachment_id" = 3262987, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (887541); [ Date: 2023-09-14 12:37:38 ]
14	1s119ms	UPDATE "account_move" SET "message_main_attachment_id" = 3265399, "write_uid" = 994, "write_date" = (now() at time zone 'UTC') WHERE id IN (889563); [ Date: 2023-09-14 18:26:56 ]
15	1s50ms	UPDATE "account_move" SET "message_main_attachment_id" = 3264073, "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (888385); [ Date: 2023-09-14 14:39:46 ]

Queries by type

Key values

25,837 Total read queries
11,682 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	25,837	68.86%
INSERT	249	0.66%
UPDATE	10,902	29.06%
DELETE	338	0.90%
COPY FROM	0	0.00%
COPY TO	83	0.22%
CTE	110	0.29%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

unknown Main database
37,519 Requests
4h14m6s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	37,519	4h14m6s
	copy to	83	10m4s
	cte	110	53s834ms
	delete	338	8m15s
	insert	249	54s264ms
	select	25,837	2h52m57s
	update	10,902	1h1m

Queries by user

Key values

unknown Main user
37,551 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	37,551	4h14m22s
	copy to	83	10m4s
	cte	110	53s834ms
	delete	338	8m15s
	insert	249	54s264ms
	select	25,860	2h53m8s
	update	10,911	1h1m6s

Duration by user

Key values

4h14m22s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	37,551	4h14m22s
	copy to	83	10m4s
	cte	110	53s834ms
	delete	338	8m15s
	insert	249	54s264ms
	select	25,860	2h53m8s
	update	10,911	1h1m6s

Queries by host

Key values

unknown Main host
37,551 Requests
4h14m22s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	37,551	4h14m22s
	copy to	83	10m4s
	cte	110	53s834ms
	delete	338	8m15s
	insert	249	54s264ms
	select	25,860	2h53m8s
	update	10,911	1h1m6s

Queries by application

Key values

unknown Main application
37,519 Requests
4h14m6s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	37,519	4h14m6s
	copy to	83	10m4s
	cte	110	53s834ms
	delete	338	8m15s
	insert	249	54s264ms
	select	25,837	2h52m57s
	update	10,902	1h1m

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2023-09-14 18:03:58 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

26,759 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	26,759	71.32%
500-1000ms	9,752	25.99%
1000-10000ms	969	2.58%
> 10000ms	39	0.10%

Slowest individual queries

Rank	Duration	Query
1	3m44s	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-09-14 09:07:38 ]
2	1m23s	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-09-14 09:02:30 ]
3	1m17s	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-09-14 09:03:52 ]
4	36s605ms	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-09-14 09:10:12 ]
5	23s244ms	COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout; [ Date: 2023-09-14 09:09:36 ]
6	21s777ms	COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout; [ Date: 2023-09-14 09:08:48 ]
7	21s620ms	DELETE FROM account_move_line WHERE id IN (3120582, 3120583, 3120584, 3120585, 3120586, 3120587, 3120588, 3120589, 3120590, 3120591, 3120592, 3120487, 3120488, 3120489, 3120490, 3120491, 3120492, 3171468, 3171469, 3171470); [ Date: 2023-09-14 06:07:00 ]
8	20s710ms	SELECT "sale_line_report".id FROM "sale_line_report" WHERE (("sale_line_report"."cus_part_route" = 2) AND (("sale_line_report"."id" > '0') AND (((((("sale_line_report"."branch_id" in (37)) AND "sale_line_report"."display_type" IS NULL) AND ((("sale_line_report"."open_qty_fil" > 0.0) AND (("sale_line_report"."state" not in ('draft', 'cancel')) OR "sale_line_report"."state" IS NULL)) AND ("sale_line_report"."move_options" = 'new_product'))) AND ("sale_line_report"."so_line_id" IS NULL AND (unaccent ("sale_line_report"."move_options"::text) ilike unaccent ('%new%')))) AND ("sale_line_report"."on_hand" > 0.0)) AND ("sale_line_report"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."thu_deli_day" = 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')))))))) ORDER BY "sale_line_report"."date" DESC, "sale_line_report"."id" ASC LIMIT 80; [ Date: 2023-09-14 12:37:07 ]
9	20s131ms	SELECT "sale_line_report".id FROM "sale_line_report" WHERE (("sale_line_report"."cus_part_route" = 3) AND (("sale_line_report"."id" > '0') AND (((((("sale_line_report"."branch_id" in (37)) AND "sale_line_report"."display_type" IS NULL) AND ((("sale_line_report"."open_qty_fil" > 0.0) AND (("sale_line_report"."state" not in ('draft', 'cancel')) OR "sale_line_report"."state" IS NULL)) AND ("sale_line_report"."move_options" = 'new_product'))) AND ("sale_line_report"."so_line_id" IS NULL AND (unaccent ("sale_line_report"."move_options"::text) ilike unaccent ('%new%')))) AND ("sale_line_report"."on_hand" > 0.0)) AND ("sale_line_report"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."thu_deli_day" = 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')))))))) ORDER BY "sale_line_report"."date" DESC, "sale_line_report"."id" ASC LIMIT 80; [ Date: 2023-09-14 12:31:51 ]
10	19s970ms	SELECT "sale_line_report".id FROM "sale_line_report" WHERE (("sale_line_report"."cus_part_route" = 2) AND (("sale_line_report"."id" > '0') AND (((((("sale_line_report"."branch_id" in (37)) AND "sale_line_report"."display_type" IS NULL) AND ((("sale_line_report"."open_qty_fil" > 0.0) AND (("sale_line_report"."state" not in ('draft', 'cancel')) OR "sale_line_report"."state" IS NULL)) AND ("sale_line_report"."move_options" = 'new_product'))) AND ("sale_line_report"."so_line_id" IS NULL AND (unaccent ("sale_line_report"."move_options"::text) ilike unaccent ('%new%')))) AND ("sale_line_report"."on_hand" > 0.0)) AND ("sale_line_report"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."thu_deli_day" = 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')))))))) ORDER BY "sale_line_report"."date" DESC, "sale_line_report"."id" ASC LIMIT 80; [ Date: 2023-09-14 12:36:34 ]
11	19s486ms	SELECT "sale_line_report".id FROM "sale_line_report" WHERE (("sale_line_report"."cus_part_route" = 3) AND (("sale_line_report"."id" > '0') AND (((((("sale_line_report"."branch_id" in (37)) AND "sale_line_report"."display_type" IS NULL) AND ((("sale_line_report"."open_qty_fil" > 0.0) AND (("sale_line_report"."state" not in ('draft', 'cancel')) OR "sale_line_report"."state" IS NULL)) AND ("sale_line_report"."move_options" = 'new_product'))) AND ("sale_line_report"."so_line_id" IS NULL AND (unaccent ("sale_line_report"."move_options"::text) ilike unaccent ('%new%')))) AND ("sale_line_report"."on_hand" > 0.0)) AND ("sale_line_report"."partner_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE ("res_partner"."thu_deli_day" = 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')))))))) ORDER BY "sale_line_report"."date" DESC, "sale_line_report"."id" ASC LIMIT 80; [ Date: 2023-09-14 12:30:39 ]
12	18s625ms	COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile) TO stdout; [ Date: 2023-09-14 09:00:31 ]
13	18s399ms	DELETE FROM account_move_line WHERE id IN (3180114, 3180115, 3180116, 3180117, 3180118, 3180119, 3180120, 3180121, 3180122, 3180123, 3180124, 3180125, 3180126, 3180127, 3180128, 3180129, 3180130); [ Date: 2023-09-14 07:12:54 ]
14	14s94ms	DELETE FROM account_move_line WHERE id IN (3075967, 3075968, 3075969, 3075970, 3075971, 3075972, 3075973, 3075974, 3075975, 3075976, 3170026, 3170027, 3170028); [ Date: 2023-09-14 06:13:13 ]
15	13s29ms	DELETE FROM account_move_line WHERE id IN (3117116, 3117117, 3117118, 3117119, 3117120, 3117121, 3117122, 3117123, 3117124, 3117125, 3180631, 3180632); [ Date: 2023-09-14 23:24:23 ]
16	12s68ms	SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "account_id_count", min("account_move_line"."date") AS "date", sum("account_move_line"."debit") AS "debit", sum("account_move_line"."credit") AS "credit", sum("account_move_line"."balance") AS "balance", sum("account_move_line"."amount_currency") AS "amount_currency", "account_move_line"."account_id" as "account_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id") LEFT JOIN "res_company" AS "account_move_line__account_id__company_id" ON ("account_move_line__account_id"."company_id" = "account_move_line__account_id__company_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" = 'posted') AND (((unaccent ("account_move_line__move_id"."name"::text) ilike unaccent ('%11-N/IN/01539%')) OR (unaccent ("account_move_line__move_id"."ref"::text) ilike unaccent ('%11-N/IN/01539%'))) OR FALSE))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."account_id", COALESCE("account_move_line__account_id"."is_off_balance", false), "account_move_line__account_id"."code", "account_move_line__account_id__company_id"."sequence", "account_move_line__account_id__company_id"."name" ORDER BY COALESCE("account_move_line__account_id"."is_off_balance", false), "account_move_line__account_id"."code", "account_move_line__account_id__company_id"."sequence", "account_move_line__account_id__company_id"."name" LIMIT 80; [ Date: 2023-09-14 16:23:11 ]
17	12s6ms	SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "account_id_count", min("account_move_line"."date") AS "date", sum("account_move_line"."debit") AS "debit", sum("account_move_line"."credit") AS "credit", sum("account_move_line"."balance") AS "balance", sum("account_move_line"."amount_currency") AS "amount_currency", "account_move_line"."account_id" as "account_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id") LEFT JOIN "res_company" AS "account_move_line__account_id__company_id" ON ("account_move_line__account_id"."company_id" = "account_move_line__account_id__company_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" = 'posted') AND (((unaccent ("account_move_line__move_id"."name"::text) ilike unaccent ('%STJ/2022/12/61696%')) OR (unaccent ("account_move_line__move_id"."ref"::text) ilike unaccent ('%STJ/2022/12/61696%'))) OR FALSE))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."account_id", COALESCE("account_move_line__account_id"."is_off_balance", false), "account_move_line__account_id"."code", "account_move_line__account_id__company_id"."sequence", "account_move_line__account_id__company_id"."name" ORDER BY COALESCE("account_move_line__account_id"."is_off_balance", false), "account_move_line__account_id"."code", "account_move_line__account_id__company_id"."sequence", "account_move_line__account_id__company_id"."name" LIMIT 80; [ Date: 2023-09-14 16:21:01 ]
18	11s809ms	SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "account_id_count", min("account_move_line"."date") AS "date", sum("account_move_line"."debit") AS "debit", sum("account_move_line"."credit") AS "credit", sum("account_move_line"."balance") AS "balance", sum("account_move_line"."amount_currency") AS "amount_currency", "account_move_line"."account_id" as "account_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id") LEFT JOIN "res_company" AS "account_move_line__account_id__company_id" ON ("account_move_line__account_id"."company_id" = "account_move_line__account_id__company_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" = 'posted') AND (((unaccent ("account_move_line__move_id"."name"::text) ilike unaccent ('%N-00451%')) OR (unaccent ("account_move_line__move_id"."ref"::text) ilike unaccent ('%N-00451%'))) OR FALSE))) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."account_id", COALESCE("account_move_line__account_id"."is_off_balance", false), "account_move_line__account_id"."code", "account_move_line__account_id__company_id"."sequence", "account_move_line__account_id__company_id"."name" ORDER BY COALESCE("account_move_line__account_id"."is_off_balance", false), "account_move_line__account_id"."code", "account_move_line__account_id__company_id"."sequence", "account_move_line__account_id__company_id"."name" LIMIT 80; [ Date: 2023-09-14 16:22:07 ]
19	11s779ms	SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "account_root_id_count", "account_move_line"."account_root_id" as "account_root_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN "account_root" AS "account_move_line__account_root_id" ON ("account_move_line"."account_root_id" = "account_move_line__account_root_id"."id") WHERE (((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" = 'posted') AND (((unaccent ("account_move_line__move_id"."name"::text) ilike unaccent ('%11-N/IN/01539%')) OR (unaccent ("account_move_line__move_id"."ref"::text) ilike unaccent ('%11-N/IN/01539%'))) OR FALSE))) AND "account_move_line"."account_root_id" IS NOT NULL) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."account_root_id", "account_move_line__account_root_id"."id" ORDER BY "account_move_line__account_root_id"."id"; [ Date: 2023-09-14 16:22:59 ]
20	11s725ms	SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "account_root_id_count", "account_move_line"."account_root_id" as "account_root_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") LEFT JOIN "account_root" AS "account_move_line__account_root_id" ON ("account_move_line"."account_root_id" = "account_move_line__account_root_id"."id") WHERE (((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND (("account_move_line"."parent_state" = 'posted') AND (((unaccent ("account_move_line__move_id"."name"::text) ilike unaccent ('%STJ/2022/12/61696%')) OR (unaccent ("account_move_line__move_id"."ref"::text) ilike unaccent ('%STJ/2022/12/61696%'))) OR FALSE))) AND "account_move_line"."account_root_id" IS NOT NULL) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."account_root_id", "account_move_line__account_root_id"."id" ORDER BY "account_move_line__account_root_id"."id"; [ Date: 2023-09-14 16:20:49 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

33m37s

3,296

Details

564ms

1s5ms

612ms

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
Sep 14	10	39	23s78ms	591ms
	11	263	2m38s	604ms
	12	322	3m19s	619ms
	13	518	5m18s	614ms
	14	449	4m40s	623ms
	15	390	4m	617ms
	16	337	3m23s	605ms
	17	340	3m27s	610ms
	18	275	2m46s	604ms
	19	221	2m14s	609ms
	20	54	32s98ms	594ms
	21	69	40s881ms	592ms
	22	19	11s191ms	589ms

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 ('%%lfp864%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lfp864%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lfp864%'))) 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-09-14 15:42:06 Duration: 1s5ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%gaff%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%gaff%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%gaff%'))) AND ("product_product__product_tmpl_id"."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-09-14 14:26:42 Duration: 973ms
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 ('%%OR102626X%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%OR102626X%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%OR102626X%'))) 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-09-14 14:05:22 Duration: 952ms

2

16m52s

4,096

Details

120ms

623ms

247ms

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
Sep 14	00	25	4s153ms	166ms
	01	29	4s836ms	166ms
	02	32	5s507ms	172ms
	03	21	3s548ms	168ms
	04	5	854ms	170ms
	05	11	1s894ms	172ms
	06	26	4s403ms	169ms
	07	31	5s56ms	163ms
	08	32	5s560ms	173ms
	09	29	4s987ms	171ms
	10	24	3s907ms	162ms
	11	187	52s151ms	278ms
	12	448	2m10s	290ms
	13	416	1m54s	275ms
	14	542	2m17s	253ms
	15	497	1m57s	237ms
	16	392	1m35s	243ms
	17	400	1m35s	237ms
	18	462	2m	260ms
	19	337	1m16s	227ms
	20	88	17s231ms	195ms
	21	15	2s512ms	167ms
	22	25	4s384ms	175ms
	23	22	3s659ms	166ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1035"', '["pointspring_master","calendar.alarm",19573]', '["pointspring_master","mail.channel",66]', '["pointspring_master","mail.channel",432]', '["pointspring_master","mail.channel",476]', '["pointspring_master","res.partner",19573]', '["pointspring_master","ir.needaction",19573]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 623ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19532]', '["pointspring_master","mail.channel",318]', '["pointspring_master","mail.channel",319]', '["pointspring_master","mail.channel",320]', '["pointspring_master","mail.channel",321]', '["pointspring_master","mail.channel",455]', '["pointspring_master","mail.channel",466]', '["pointspring_master","res.partner",19532]', '["pointspring_master","ir.needaction",19532]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 619ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 610ms

3

13m17s

1,291

Details

565ms

891ms

617ms

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
Sep 14	11	71	43s427ms	611ms
	12	174	1m48s	625ms
	13	145	1m30s	626ms
	14	316	3m17s	623ms
	15	106	1m5s	614ms
	16	144	1m28s	613ms
	17	96	58s989ms	614ms
	18	78	46s736ms	599ms
	19	83	51s373ms	618ms
	20	78	46s443ms	595ms

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 ('%%c207%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%c20-7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%c20-7%'))) 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-09-14 12:57:04 Duration: 891ms
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 ('%%n23800%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-3-800%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-3-800%'))) 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-09-14 12:41:04 Duration: 886ms
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 ('%%n238001%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-3-8001%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-3-8001%'))) 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-09-14 12:41:05 Duration: 876ms

4

12m5s

2,763

Details

245ms

604ms

262ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	00	2	499ms	249ms
	01	1	249ms	249ms
	05	1	254ms	254ms
	08	4	1s9ms	252ms
	09	3	782ms	260ms
	10	17	4s470ms	262ms
	11	211	54s901ms	260ms
	12	423	1m51s	263ms
	13	367	1m36s	263ms
	14	480	2m7s	265ms
	15	355	1m34s	265ms
	16	180	45s987ms	255ms
	17	322	1m24s	261ms
	18	122	31s769ms	260ms
	19	167	44s301ms	265ms
	20	91	23s258ms	255ms
	21	12	3s44ms	253ms
	22	3	743ms	247ms
	23	2	506ms	253ms

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_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 14:05:22 Duration: 604ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-df4ccbc/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 19:14:08 Duration: 534ms
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_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 11:57:22 Duration: 499ms

5

11m32s

900

Details

728ms

1s42ms

769ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Sep 14	00	8	5s928ms	741ms
	10	1	780ms	780ms
	11	39	29s747ms	762ms
	12	127	1m38s	777ms
	13	97	1m14s	771ms
	14	122	1m34s	775ms
	15	112	1m26s	772ms
	16	71	54s282ms	764ms
	17	79	1m	766ms
	18	123	1m34s	769ms
	19	94	1m11s	761ms
	20	19	14s427ms	759ms
	21	8	6s133ms	766ms

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 ('%15-326%')) 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 ('%15-326%'))) 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 ('%15-326%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%15-326%')))))) 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-09-14 12:44:27 Duration: 1s42ms
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 ('%AVM104%')) 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 ('%AVM104%'))) 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 ('%AVM104%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%AVM104%')))))) 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-09-14 14:36:58 Duration: 1s20ms
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 ('%pf4606%')) 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 ('%pf4606%'))) 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 ('%pf4606%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%pf4606%')))))) 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-09-14 15:05:52 Duration: 1s10ms

6

6m11s

614

Details

570ms

866ms

604ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Sep 14	11	35	21s100ms	602ms
	12	59	35s851ms	607ms
	13	50	30s684ms	613ms
	14	41	24s792ms	604ms
	15	78	47s752ms	612ms
	16	86	52s206ms	607ms
	17	60	36s587ms	609ms
	18	143	1m25s	598ms
	19	26	15s351ms	590ms
	20	36	21s279ms	591ms

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

Date: 2023-09-14 13:49:40 Duration: 866ms
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 ('%%laf94%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%laf94%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%laf94%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-09-14 13:49:40 Duration: 865ms
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 ('%%laf9%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%laf9%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%laf9%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-09-14 13:49:40 Duration: 830ms

7

5m14s

1,755

Details

167ms

468ms

179ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Sep 14	08	2	343ms	171ms
	09	6	1s65ms	177ms
	10	3	527ms	175ms
	11	89	15s827ms	177ms
	12	337	59s563ms	176ms
	13	271	49s45ms	180ms
	14	295	53s253ms	180ms
	15	117	21s76ms	180ms
	16	103	18s411ms	178ms
	17	200	36s341ms	181ms
	18	173	30s988ms	179ms
	19	131	23s219ms	177ms
	20	16	2s803ms	175ms
	21	3	524ms	174ms
	22	9	1s535ms	170ms

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

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

Date: 2023-09-14 17:18:54 Duration: 337ms
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-11242%') OR unaccent (res_partner.display_name) ilike unaccent ('%g-11242%') OR unaccent (res_partner.ref) ilike unaccent ('%g-11242%') OR unaccent (res_partner.vat) ilike unaccent ('g-11242')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%g-11242%') desc, unaccent (res_partner.display_name);

Date: 2023-09-14 13:23:18 Duration: 330ms

8

4m51s

870

Details

228ms

2s632ms

334ms

update "stock_quant" set "quantity" = ?.?, "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
Sep 14	09	4	1s485ms	371ms
	10	5	1s329ms	265ms
	11	16	5s337ms	333ms
	12	120	41s556ms	346ms
	13	116	42s434ms	365ms
	14	182	1m1s	337ms
	15	132	43s734ms	331ms
	16	50	15s766ms	315ms
	17	105	34s338ms	327ms
	18	48	15s814ms	329ms
	19	45	13s147ms	292ms
	20	41	12s575ms	306ms
	21	6	2s507ms	417ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (349505, 47075, 352869, 347116, 345103, 351162);

Date: 2023-09-14 13:26:13 Duration: 2s632ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (353331, 353332, 347387);

Date: 2023-09-14 12:00:24 Duration: 1s500ms
UPDATE "stock_quant" SET "quantity" = 4.0, "reserved_quantity" = 0.0, "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (321369, 294191, 320313);

Date: 2023-09-14 12:00:25 Duration: 1s423ms

9

4m33s

504

Details

300ms

2s9ms

543ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	09	3	1s491ms	497ms
	11	3	1s319ms	439ms
	12	56	32s154ms	574ms
	13	55	27s995ms	509ms
	14	105	56s704ms	540ms
	15	73	38s318ms	524ms
	16	25	13s3ms	520ms
	17	109	1m2s	574ms
	18	30	16s487ms	549ms
	19	33	17s545ms	531ms
	20	7	3s384ms	483ms
	21	5	2s977ms	595ms

UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-09-14 12:00:17', "is_done" = true, "state" = 'done', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (585001, 584995, 584999);

Date: 2023-09-14 12:00:32 Duration: 2s9ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-09-14 17:12:23', "is_done" = true, "state" = 'done', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (581842, 581843, 581844);

Date: 2023-09-14 17:12:27 Duration: 1s387ms
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2023-09-14 15:09:09', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (585584, 585579);

Date: 2023-09-14 15:09:11 Duration: 1s256ms

10

4m30s

288

Details

891ms

1s401ms

938ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Sep 14	09	12	10s830ms	902ms
	10	30	27s485ms	916ms
	11	30	28s490ms	949ms
	12	87	1m22s	953ms
	13	12	11s177ms	931ms
	14	48	44s828ms	933ms
	15	15	14s491ms	966ms
	16	6	5s516ms	919ms
	18	12	11s325ms	943ms
	20	36	33s203ms	922ms

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

Date: 2023-09-14 11:53:44 Duration: 1s401ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%1050A%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1050A%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%1050A%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%1050A%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%1050A%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%1050A%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2023-09-14 14:09:00 Duration: 1s238ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-740%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-740%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-740%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-740%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-740%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-740%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2023-09-14 12:49:28 Duration: 1s215ms

11

3m54s

58

Details

3s556ms

11s245ms

4s40ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Sep 14	10	1	3s820ms	3s820ms
	11	6	25s621ms	4s270ms
	12	5	18s423ms	3s684ms
	13	13	47s680ms	3s667ms
	14	7	25s803ms	3s686ms
	15	4	14s738ms	3s684ms
	16	5	21s946ms	4s389ms
	17	6	29s504ms	4s917ms
	18	6	28s830ms	4s805ms
	19	3	10s812ms	3s604ms
	20	1	3s566ms	3s566ms
	22	1	3s626ms	3s626ms

DELETE FROM sale_order_line WHERE id IN (237261, 237262, 237263);

Date: 2023-09-14 17:51:32 Duration: 11s245ms
DELETE FROM sale_order_line WHERE id IN (237138, 237139);

Date: 2023-09-14 18:46:14 Duration: 7s278ms
DELETE FROM sale_order_line WHERE id IN (236087, 236088);

Date: 2023-09-14 11:49:35 Duration: 7s230ms

12

3m46s

323

Details

205ms

3s960ms

702ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	09	2	1s307ms	653ms
	11	8	5s756ms	719ms
	12	47	44s675ms	950ms
	13	29	18s959ms	653ms
	14	51	34s187ms	670ms
	15	57	42s329ms	742ms
	16	12	8s693ms	724ms
	17	51	29s321ms	574ms
	18	16	13s645ms	852ms
	19	18	11s340ms	630ms
	20	31	16s105ms	519ms
	21	1	677ms	677ms

UPDATE "stock_move" SET "date" = '2023-09-14 12:38:33', "is_done" = true, "state" = 'done', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578528, 578529, 578530, 578531, 578532, 578533, 578534, 578535, 578536, 578537, 578538, 578527);

Date: 2023-09-14 12:38:37 Duration: 3s960ms
UPDATE "stock_move" SET "date" = '2023-09-14 12:44:38', "is_done" = true, "state" = 'done', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578349, 578350, 578351, 578352, 578353, 578354, 578355, 578356, 578359, 578360);

Date: 2023-09-14 12:44:42 Duration: 3s908ms
UPDATE "stock_move" SET "date" = '2023-09-14 15:40:52', "is_done" = true, "state" = 'done', "write_uid" = 978, "write_date" = (now() at time zone 'UTC') WHERE id IN (585674, 585675, 585676, 585678, 568283, 568285, 580670);

Date: 2023-09-14 15:41:02 Duration: 3s249ms

13

3m44s

1

Details

3m44s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Sep 14	09	1	3m44s	3m44s

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-09-14 09:07:38 Duration: 3m44s

14

3m41s

183

Details

1s106ms

1s621ms

1s209ms

select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Sep 14	12	4	4s963ms	1s240ms
	13	47	56s648ms	1s205ms
	14	90	1m50s	1s228ms
	15	11	12s908ms	1s173ms
	16	10	11s796ms	1s179ms
	17	4	4s626ms	1s156ms
	18	17	19s792ms	1s164ms

select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Date: 2023-09-14 14:34:28 Duration: 1s621ms
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Date: 2023-09-14 13:57:52 Duration: 1s592ms
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Date: 2023-09-14 14:34:28 Duration: 1s577ms

15

3m36s

1,233

Details

168ms

322ms

175ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Sep 14	08	12	2s94ms	174ms
	11	6	1s50ms	175ms
	12	3	535ms	178ms
	13	126	21s821ms	173ms
	14	6	1s55ms	175ms
	15	11	2s26ms	184ms
	16	125	21s912ms	175ms
	17	662	1m56s	175ms
	18	90	15s972ms	177ms
	19	192	33s398ms	173ms

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

Date: 2023-09-14 17:16:26 Duration: 322ms
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%26304%') OR unaccent (res_partner.display_name) ilike unaccent ('%26304%') OR unaccent (res_partner.ref) ilike unaccent ('%26304%') OR unaccent (res_partner.vat) ilike unaccent ('26304')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%26304%') desc, unaccent (res_partner.display_name);

Date: 2023-09-14 17:18:03 Duration: 309ms
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%a to z%') OR unaccent (res_partner.display_name) ilike unaccent ('%a to z%') OR unaccent (res_partner.ref) ilike unaccent ('%a to z%') OR unaccent (res_partner.vat) ilike unaccent ('atoz')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%a to z%') desc, unaccent (res_partner.display_name);

Date: 2023-09-14 15:13:16 Duration: 255ms

16

3m11s

204

Details

889ms

1s194ms

937ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Sep 14	09	16	14s442ms	902ms
	10	15	13s750ms	916ms
	11	11	10s370ms	942ms
	12	38	35s790ms	941ms
	13	21	19s548ms	930ms
	14	34	32s350ms	951ms
	15	32	30s968ms	967ms
	16	10	9s47ms	904ms
	18	3	2s822ms	940ms
	20	22	20s299ms	922ms
	21	2	1s825ms	912ms

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

Date: 2023-09-14 14:08:59 Duration: 1s194ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%SH8S0FH%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SH8S0FH%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%SH8S0FH%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%SH8S0FH%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%SH8S0FH%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%SH8S0FH%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2023-09-14 14:17:09 Duration: 1s173ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%1050%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1050%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%1050%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%1050%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%1050%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%1050%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2023-09-14 14:09:38 Duration: 1s120ms

17

3m

126

Details

191ms

8s226ms

1s433ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Sep 14	09	2	2s471ms	1s235ms
	10	1	2s221ms	2s221ms
	11	3	4s198ms	1s399ms
	12	10	8s281ms	828ms
	13	20	32s714ms	1s635ms
	14	28	44s618ms	1s593ms
	15	21	23s135ms	1s101ms
	16	8	12s90ms	1s511ms
	17	24	29s132ms	1s213ms
	18	8	20s398ms	2s549ms
	20	1	1s371ms	1s371ms

UPDATE "stock_move" SET "date" = '2023-09-14 14:46:26', "state" = 'done', "write_uid" = 980, "write_date" = (now() at time zone 'UTC') WHERE id IN (585216, 585217, 585218, 585219, 585220, 585222, 585223, 585224, 585225, 585226, 585227, 585228, 585229, 585231, 585232, 585214, 585215);

Date: 2023-09-14 14:46:36 Duration: 8s226ms
UPDATE "stock_move" SET "date" = '2023-09-14 13:25:57', "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (584931, 584933, 584902, 584934, 584907, 584908, 584910, 584916, 584918, 547352, 547353, 547354, 548124);

Date: 2023-09-14 13:26:06 Duration: 7s599ms
UPDATE "stock_move" SET "date" = '2023-09-14 18:01:58', "state" = 'done', "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (495936, 495937, 495938, 495939, 495940, 495941, 495945, 495946);

Date: 2023-09-14 18:02:03 Duration: 5s426ms

18

2m59s

422

Details

120ms

3s778ms

426ms

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
Sep 14	10	2	723ms	361ms
	11	26	10s236ms	393ms
	12	58	28s695ms	494ms
	13	47	24s801ms	527ms
	14	62	24s290ms	391ms
	15	51	19s994ms	392ms
	16	26	12s777ms	491ms
	17	49	18s283ms	373ms
	18	37	15s625ms	422ms
	19	28	8s841ms	315ms
	20	30	13s567ms	452ms
	21	6	2s77ms	346ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (584994, 584995, 584996, 584997, 584998, 584999, 585000, 585001);

Date: 2023-09-14 12:00:07 Duration: 3s778ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578511, 578512, 578513, 578514, 578515, 578516, 578517, 578518, 578519, 578520, 578521, 578522, 578523, 578524, 578525);

Date: 2023-09-14 12:34:26 Duration: 2s857ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (586048, 586042, 586043, 586044, 586045, 586046, 586047);

Date: 2023-09-14 17:30:04 Duration: 1s979ms

19

2m58s

39

Details

1s67ms

21s620ms

4s587ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Sep 14	03	2	13s62ms	6s531ms
	06	6	47s569ms	7s928ms
	07	2	29s239ms	14s619ms
	14	2	4s431ms	2s215ms
	15	1	7s717ms	7s717ms
	16	6	11s988ms	1s998ms
	17	5	17s619ms	3s523ms
	18	1	1s156ms	1s156ms
	19	4	11s992ms	2s998ms
	23	10	34s141ms	3s414ms

DELETE FROM account_move_line WHERE id IN (3120582, 3120583, 3120584, 3120585, 3120586, 3120587, 3120588, 3120589, 3120590, 3120591, 3120592, 3120487, 3120488, 3120489, 3120490, 3120491, 3120492, 3171468, 3171469, 3171470);

Date: 2023-09-14 06:07:00 Duration: 21s620ms
DELETE FROM account_move_line WHERE id IN (3180114, 3180115, 3180116, 3180117, 3180118, 3180119, 3180120, 3180121, 3180122, 3180123, 3180124, 3180125, 3180126, 3180127, 3180128, 3180129, 3180130);

Date: 2023-09-14 07:12:54 Duration: 18s399ms
DELETE FROM account_move_line WHERE id IN (3075967, 3075968, 3075969, 3075970, 3075971, 3075972, 3075973, 3075974, 3075975, 3075976, 3170026, 3170027, 3170028);

Date: 2023-09-14 06:13:13 Duration: 14s94ms

20

2m50s

1,295

Details

120ms

396ms

131ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Sep 14	09	1	124ms	124ms
	10	1	123ms	123ms
	11	65	8s454ms	130ms
	12	169	22s418ms	132ms
	13	184	24s226ms	131ms
	14	217	29s47ms	133ms
	15	134	17s793ms	132ms
	16	98	12s791ms	130ms
	17	95	12s498ms	131ms
	18	151	19s968ms	132ms
	19	123	16s84ms	130ms
	20	28	3s525ms	125ms
	21	20	2s530ms	126ms
	22	9	1s110ms	123ms

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

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

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

Date: 2023-09-14 18:36:58 Duration: 253ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

4,096

Details

16m52s

120ms

623ms

247ms

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
Sep 14	00	25	4s153ms	166ms
	01	29	4s836ms	166ms
	02	32	5s507ms	172ms
	03	21	3s548ms	168ms
	04	5	854ms	170ms
	05	11	1s894ms	172ms
	06	26	4s403ms	169ms
	07	31	5s56ms	163ms
	08	32	5s560ms	173ms
	09	29	4s987ms	171ms
	10	24	3s907ms	162ms
	11	187	52s151ms	278ms
	12	448	2m10s	290ms
	13	416	1m54s	275ms
	14	542	2m17s	253ms
	15	497	1m57s	237ms
	16	392	1m35s	243ms
	17	400	1m35s	237ms
	18	462	2m	260ms
	19	337	1m16s	227ms
	20	88	17s231ms	195ms
	21	15	2s512ms	167ms
	22	25	4s384ms	175ms
	23	22	3s659ms	166ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1035"', '["pointspring_master","calendar.alarm",19573]', '["pointspring_master","mail.channel",66]', '["pointspring_master","mail.channel",432]', '["pointspring_master","mail.channel",476]', '["pointspring_master","res.partner",19573]', '["pointspring_master","ir.needaction",19573]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 623ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19532]', '["pointspring_master","mail.channel",318]', '["pointspring_master","mail.channel",319]', '["pointspring_master","mail.channel",320]', '["pointspring_master","mail.channel",321]', '["pointspring_master","mail.channel",455]', '["pointspring_master","mail.channel",466]', '["pointspring_master","res.partner",19532]', '["pointspring_master","ir.needaction",19532]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 619ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 610ms

2

3,296

Details

33m37s

564ms

1s5ms

612ms

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
Sep 14	10	39	23s78ms	591ms
	11	263	2m38s	604ms
	12	322	3m19s	619ms
	13	518	5m18s	614ms
	14	449	4m40s	623ms
	15	390	4m	617ms
	16	337	3m23s	605ms
	17	340	3m27s	610ms
	18	275	2m46s	604ms
	19	221	2m14s	609ms
	20	54	32s98ms	594ms
	21	69	40s881ms	592ms
	22	19	11s191ms	589ms

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 ('%%lfp864%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lfp864%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lfp864%'))) 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-09-14 15:42:06 Duration: 1s5ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%gaff%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%gaff%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%gaff%'))) AND ("product_product__product_tmpl_id"."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-09-14 14:26:42 Duration: 973ms
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 ('%%OR102626X%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%OR102626X%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%OR102626X%'))) 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-09-14 14:05:22 Duration: 952ms

3

2,763

Details

12m5s

245ms

604ms

262ms

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
Sep 14	00	2	499ms	249ms
	01	1	249ms	249ms
	05	1	254ms	254ms
	08	4	1s9ms	252ms
	09	3	782ms	260ms
	10	17	4s470ms	262ms
	11	211	54s901ms	260ms
	12	423	1m51s	263ms
	13	367	1m36s	263ms
	14	480	2m7s	265ms
	15	355	1m34s	265ms
	16	180	45s987ms	255ms
	17	322	1m24s	261ms
	18	122	31s769ms	260ms
	19	167	44s301ms	265ms
	20	91	23s258ms	255ms
	21	12	3s44ms	253ms
	22	3	743ms	247ms
	23	2	506ms	253ms

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_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 14:05:22 Duration: 604ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-df4ccbc/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 19:14:08 Duration: 534ms
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_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 11:57:22 Duration: 499ms

4

1,755

Details

5m14s

167ms

468ms

179ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	08	2	343ms	171ms
	09	6	1s65ms	177ms
	10	3	527ms	175ms
	11	89	15s827ms	177ms
	12	337	59s563ms	176ms
	13	271	49s45ms	180ms
	14	295	53s253ms	180ms
	15	117	21s76ms	180ms
	16	103	18s411ms	178ms
	17	200	36s341ms	181ms
	18	173	30s988ms	179ms
	19	131	23s219ms	177ms
	20	16	2s803ms	175ms
	21	3	524ms	174ms
	22	9	1s535ms	170ms

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

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

Date: 2023-09-14 17:18:54 Duration: 337ms
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-11242%') OR unaccent (res_partner.display_name) ilike unaccent ('%g-11242%') OR unaccent (res_partner.ref) ilike unaccent ('%g-11242%') OR unaccent (res_partner.vat) ilike unaccent ('g-11242')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%g-11242%') desc, unaccent (res_partner.display_name);

Date: 2023-09-14 13:23:18 Duration: 330ms

5

1,295

Details

2m50s

120ms

396ms

131ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Sep 14	09	1	124ms	124ms
	10	1	123ms	123ms
	11	65	8s454ms	130ms
	12	169	22s418ms	132ms
	13	184	24s226ms	131ms
	14	217	29s47ms	133ms
	15	134	17s793ms	132ms
	16	98	12s791ms	130ms
	17	95	12s498ms	131ms
	18	151	19s968ms	132ms
	19	123	16s84ms	130ms
	20	28	3s525ms	125ms
	21	20	2s530ms	126ms
	22	9	1s110ms	123ms

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

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

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

Date: 2023-09-14 18:36:58 Duration: 253ms

6

1,291

Details

13m17s

565ms

891ms

617ms

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
Sep 14	11	71	43s427ms	611ms
	12	174	1m48s	625ms
	13	145	1m30s	626ms
	14	316	3m17s	623ms
	15	106	1m5s	614ms
	16	144	1m28s	613ms
	17	96	58s989ms	614ms
	18	78	46s736ms	599ms
	19	83	51s373ms	618ms
	20	78	46s443ms	595ms

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 ('%%c207%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%c20-7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%c20-7%'))) 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-09-14 12:57:04 Duration: 891ms
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 ('%%n23800%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-3-800%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-3-800%'))) 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-09-14 12:41:04 Duration: 886ms
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 ('%%n238001%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-3-8001%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-3-8001%'))) 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-09-14 12:41:05 Duration: 876ms

7

1,233

Details

3m36s

168ms

322ms

175ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Sep 14	08	12	2s94ms	174ms
	11	6	1s50ms	175ms
	12	3	535ms	178ms
	13	126	21s821ms	173ms
	14	6	1s55ms	175ms
	15	11	2s26ms	184ms
	16	125	21s912ms	175ms
	17	662	1m56s	175ms
	18	90	15s972ms	177ms
	19	192	33s398ms	173ms

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

Date: 2023-09-14 17:16:26 Duration: 322ms
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%26304%') OR unaccent (res_partner.display_name) ilike unaccent ('%26304%') OR unaccent (res_partner.ref) ilike unaccent ('%26304%') OR unaccent (res_partner.vat) ilike unaccent ('26304')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%26304%') desc, unaccent (res_partner.display_name);

Date: 2023-09-14 17:18:03 Duration: 309ms
SELECT res_partner.id FROM "res_partner" WHERE (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%a to z%') OR unaccent (res_partner.display_name) ilike unaccent ('%a to z%') OR unaccent (res_partner.ref) ilike unaccent ('%a to z%') OR unaccent (res_partner.vat) ilike unaccent ('atoz')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%a to z%') desc, unaccent (res_partner.display_name);

Date: 2023-09-14 15:13:16 Duration: 255ms

8

900

Details

11m32s

728ms

1s42ms

769ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	00	8	5s928ms	741ms
	10	1	780ms	780ms
	11	39	29s747ms	762ms
	12	127	1m38s	777ms
	13	97	1m14s	771ms
	14	122	1m34s	775ms
	15	112	1m26s	772ms
	16	71	54s282ms	764ms
	17	79	1m	766ms
	18	123	1m34s	769ms
	19	94	1m11s	761ms
	20	19	14s427ms	759ms
	21	8	6s133ms	766ms

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 ('%15-326%')) 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 ('%15-326%'))) 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 ('%15-326%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%15-326%')))))) 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-09-14 12:44:27 Duration: 1s42ms
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 ('%AVM104%')) 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 ('%AVM104%'))) 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 ('%AVM104%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%AVM104%')))))) 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-09-14 14:36:58 Duration: 1s20ms
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 ('%pf4606%')) 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 ('%pf4606%'))) 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 ('%pf4606%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%pf4606%')))))) 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-09-14 15:05:52 Duration: 1s10ms

9

870

Details

4m51s

228ms

2s632ms

334ms

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
Sep 14	09	4	1s485ms	371ms
	10	5	1s329ms	265ms
	11	16	5s337ms	333ms
	12	120	41s556ms	346ms
	13	116	42s434ms	365ms
	14	182	1m1s	337ms
	15	132	43s734ms	331ms
	16	50	15s766ms	315ms
	17	105	34s338ms	327ms
	18	48	15s814ms	329ms
	19	45	13s147ms	292ms
	20	41	12s575ms	306ms
	21	6	2s507ms	417ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (349505, 47075, 352869, 347116, 345103, 351162);

Date: 2023-09-14 13:26:13 Duration: 2s632ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (353331, 353332, 347387);

Date: 2023-09-14 12:00:24 Duration: 1s500ms
UPDATE "stock_quant" SET "quantity" = 4.0, "reserved_quantity" = 0.0, "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (321369, 294191, 320313);

Date: 2023-09-14 12:00:25 Duration: 1s423ms

10

832

Details

2m36s

159ms

709ms

188ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Sep 14	09	10	1s745ms	174ms
	10	5	923ms	184ms
	11	27	4s948ms	183ms
	12	84	16s94ms	191ms
	13	133	25s626ms	192ms
	14	200	37s615ms	188ms
	15	96	17s964ms	187ms
	16	74	14s261ms	192ms
	17	93	17s103ms	183ms
	18	46	8s958ms	194ms
	19	42	7s726ms	183ms
	20	14	2s508ms	179ms
	21	8	1s420ms	177ms

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 (233056, 230945, 230932, 230940);

Date: 2023-09-14 16:04:14 Duration: 709ms
UPDATE "sale_order_line" SET "invoice_status" = 'no', "open_qty_fil" = 50.0, "qty_delivered" = '0.00', "qty_to_invoice" = '0.00', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1001, "write_date" = (now() at time zone 'UTC') WHERE id IN (229456, 229451, 229453);

Date: 2023-09-14 12:51:45 Duration: 611ms
UPDATE "sale_order_line" SET "invoice_status" = 'to invoice', "open_qty_fil" = 2.0, "qty_delivered" = '2.00', "qty_to_invoice" = '2.00', "untaxed_amount_to_invoice" = '47.38', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (236606);

Date: 2023-09-14 13:26:20 Duration: 400ms

11

770

Details

2m22s

157ms

474ms

184ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	09	10	1s712ms	171ms
	11	24	4s401ms	183ms
	12	74	14s71ms	190ms
	13	134	25s129ms	187ms
	14	176	32s442ms	184ms
	15	88	16s6ms	181ms
	16	61	11s40ms	180ms
	17	90	16s834ms	187ms
	18	52	9s685ms	186ms
	19	40	7s178ms	179ms
	20	13	2s327ms	179ms
	21	8	1s423ms	177ms

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

Date: 2023-09-14 12:50:17 Duration: 474ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '1.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '49.86', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1010, "write_date" = (now() at time zone 'UTC') WHERE id IN (236712, 236713);

Date: 2023-09-14 12:56:44 Duration: 394ms
UPDATE "sale_order_line" SET "invoice_status" = 'invoiced', "qty_invoiced" = '3.00', "qty_to_invoice" = '0.00', "untaxed_amount_invoiced" = '83.97', "untaxed_amount_to_invoice" = '0.00', "write_uid" = 1005, "write_date" = (now() at time zone 'UTC') WHERE id IN (235594, 235595);

Date: 2023-09-14 14:35:32 Duration: 384ms

12

614

Details

6m11s

570ms

866ms

604ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Sep 14	11	35	21s100ms	602ms
	12	59	35s851ms	607ms
	13	50	30s684ms	613ms
	14	41	24s792ms	604ms
	15	78	47s752ms	612ms
	16	86	52s206ms	607ms
	17	60	36s587ms	609ms
	18	143	1m25s	598ms
	19	26	15s351ms	590ms
	20	36	21s279ms	591ms

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

Date: 2023-09-14 13:49:40 Duration: 866ms
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 ('%%laf94%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%laf94%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%laf94%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-09-14 13:49:40 Duration: 865ms
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 ('%%laf9%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%laf9%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%laf9%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-09-14 13:49:40 Duration: 830ms

13

526

Details

1m36s

160ms

390ms

183ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	10	7	1s247ms	178ms
	11	32	5s735ms	179ms
	12	40	7s659ms	191ms
	13	101	18s707ms	185ms
	14	60	11s355ms	189ms
	15	46	8s401ms	182ms
	16	63	11s481ms	182ms
	17	47	8s538ms	181ms
	18	49	8s911ms	181ms
	19	49	8s881ms	181ms
	20	13	2s313ms	177ms
	21	15	2s704ms	180ms
	22	4	696ms	174ms

UPDATE "sale_order_line" SET "branch_id" = 40, "currency_id" = 2, "cus_date_order" = '2023-09-14 12:43:48', "cus_part_route" = NULL, "cus_user_id" = 1039, "inventory_vendor_id" = 2952, "is_service" = false, "margin" = '18.34', "margin_percent" = 0.875, "order_partner_id" = 42818, "price_reduce" = '20.96', "price_reduce_taxexcl" = '20.96', "price_reduce_taxinc" = '20.96', "price_subtotal" = '20.96', "price_tax" = 0.0, "price_total" = '20.96', "purchase_price" = '2.62', "qty_delivered_method" = 'stock_move', "qty_invoiced" = '0.00', "qty_to_invoice" = '0.00', "salesman_id" = 1039, "untaxed_amount_invoiced" = '0.00', "untaxed_amount_to_invoice" = '0.00', "warehouse_id" = 38, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (236694);

Date: 2023-09-14 12:44:26 Duration: 390ms
UPDATE "sale_order_line" SET "branch_id" = 48, "currency_id" = 2, "cus_date_order" = '2023-09-14 16:30:03', "cus_part_route" = NULL, "cus_user_id" = 985, "inventory_vendor_id" = 2982, "is_service" = false, "margin" = '-7.74', "margin_percent" = 0.2979214780600462, "order_partner_id" = 38509, "price_reduce" = '12.99', "price_reduce_taxexcl" = '12.99', "price_reduce_taxinc" = '12.99', "price_subtotal" = '-25.98', "price_tax" = 0.0, "price_total" = '-25.98', "purchase_price" = '9.12', "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" = 45, "write_uid" = 990, "write_date" = (now() at time zone 'UTC') WHERE id IN (237159);

Date: 2023-09-14 16:30:29 Duration: 246ms
UPDATE "sale_order_line" SET "branch_id" = 45, "currency_id" = 2, "cus_date_order" = '2023-09-14 14:26:07', "cus_part_route" = NULL, "cus_user_id" = 985, "inventory_vendor_id" = 2952, "is_service" = false, "margin" = '38.88', "margin_percent" = 0.44021739130434784, "order_partner_id" = 37378, "price_reduce" = '11.04', "price_reduce_taxexcl" = '11.04', "price_reduce_taxinc" = '11.04', "price_subtotal" = '88.32', "price_tax" = 0.0, "price_total" = '88.32', "purchase_price" = '6.18', "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" = 1030, "write_date" = (now() at time zone 'UTC') WHERE id IN (236952);

Date: 2023-09-14 14:28:49 Duration: 240ms

14

504

Details

4m33s

300ms

2s9ms

543ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	09	3	1s491ms	497ms
	11	3	1s319ms	439ms
	12	56	32s154ms	574ms
	13	55	27s995ms	509ms
	14	105	56s704ms	540ms
	15	73	38s318ms	524ms
	16	25	13s3ms	520ms
	17	109	1m2s	574ms
	18	30	16s487ms	549ms
	19	33	17s545ms	531ms
	20	7	3s384ms	483ms
	21	5	2s977ms	595ms

UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-09-14 12:00:17', "is_done" = true, "state" = 'done', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (585001, 584995, 584999);

Date: 2023-09-14 12:00:32 Duration: 2s9ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-09-14 17:12:23', "is_done" = true, "state" = 'done', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (581842, 581843, 581844);

Date: 2023-09-14 17:12:27 Duration: 1s387ms
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2023-09-14 15:09:09', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (585584, 585579);

Date: 2023-09-14 15:09:11 Duration: 1s256ms

15

422

Details

2m59s

120ms

3s778ms

426ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Sep 14	10	2	723ms	361ms
	11	26	10s236ms	393ms
	12	58	28s695ms	494ms
	13	47	24s801ms	527ms
	14	62	24s290ms	391ms
	15	51	19s994ms	392ms
	16	26	12s777ms	491ms
	17	49	18s283ms	373ms
	18	37	15s625ms	422ms
	19	28	8s841ms	315ms
	20	30	13s567ms	452ms
	21	6	2s77ms	346ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (584994, 584995, 584996, 584997, 584998, 584999, 585000, 585001);

Date: 2023-09-14 12:00:07 Duration: 3s778ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578511, 578512, 578513, 578514, 578515, 578516, 578517, 578518, 578519, 578520, 578521, 578522, 578523, 578524, 578525);

Date: 2023-09-14 12:34:26 Duration: 2s857ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (586048, 586042, 586043, 586044, 586045, 586046, 586047);

Date: 2023-09-14 17:30:04 Duration: 1s979ms

16

363

Details

2m6s

336ms

540ms

349ms

select "account_move".id from "account_move" where ((("account_move"."move_type" in (...)) and (("account_move"."non_inventory_entry" = true) or ("account_move"."move_type" in (...)))) and (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Sep 14	12	113	39s367ms	348ms
	13	97	34s102ms	351ms
	14	139	48s484ms	348ms
	15	1	363ms	363ms
	16	7	2s510ms	358ms
	17	2	687ms	343ms
	18	4	1s371ms	342ms

SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%I-01827%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%I-01827%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%I-01827%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%I-01827%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;

Date: 2023-09-14 12:44:28 Duration: 540ms
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%I-02706%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%I-02706%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%I-02706%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%I-02706%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;

Date: 2023-09-14 13:23:54 Duration: 476ms
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%N34490%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%N34490%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%N34490%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%N34490%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;

Date: 2023-09-14 14:10:19 Duration: 476ms

17

357

Details

1m20s

172ms

414ms

225ms

select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Sep 14	11	23	4s170ms	181ms
	12	27	5s503ms	203ms
	13	305	1m10s	231ms
	20	2	355ms	177ms

select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);

Date: 2023-09-14 13:51:30 Duration: 414ms
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);

Date: 2023-09-14 13:51:30 Duration: 401ms
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);

Date: 2023-09-14 13:51:30 Duration: 393ms

18

325

Details

2m12s

160ms

2s233ms

407ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Sep 14	09	3	1s37ms	345ms
	11	10	5s831ms	583ms
	12	33	16s709ms	506ms
	13	60	20s206ms	336ms
	14	51	24s160ms	473ms
	15	41	18s731ms	456ms
	16	23	8s529ms	370ms
	17	40	12s280ms	307ms
	18	36	15s93ms	419ms
	19	20	6s615ms	330ms
	20	7	1s928ms	275ms
	21	1	1s395ms	1s395ms

UPDATE "sale_order_line" SET "qty_delivered_method" = 'stock_move', "state" = 'done', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (58156, 58158, 58159, 58160, 58162, 58164, 58165, 58166, 58167, 58168, 58169, 58171);

Date: 2023-09-14 18:54:22 Duration: 2s233ms
UPDATE "sale_order_line" SET "qty_delivered_method" = 'stock_move', "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (97088, 97089, 97092, 97093, 97095, 97096, 97099, 97100, 97086);

Date: 2023-09-14 12:16:00 Duration: 1s972ms
UPDATE "sale_order_line" SET "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (236291, 236292, 236324, 236295, 236296, 236297, 237109, 237110, 236311, 236314, 236315);

Date: 2023-09-14 15:53:09 Duration: 1s832ms

19

323

Details

3m46s

205ms

3s960ms

702ms

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

Day	Hour	Count	Duration	Avg duration
Sep 14	09	2	1s307ms	653ms
	11	8	5s756ms	719ms
	12	47	44s675ms	950ms
	13	29	18s959ms	653ms
	14	51	34s187ms	670ms
	15	57	42s329ms	742ms
	16	12	8s693ms	724ms
	17	51	29s321ms	574ms
	18	16	13s645ms	852ms
	19	18	11s340ms	630ms
	20	31	16s105ms	519ms
	21	1	677ms	677ms

UPDATE "stock_move" SET "date" = '2023-09-14 12:38:33', "is_done" = true, "state" = 'done', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578528, 578529, 578530, 578531, 578532, 578533, 578534, 578535, 578536, 578537, 578538, 578527);

Date: 2023-09-14 12:38:37 Duration: 3s960ms
UPDATE "stock_move" SET "date" = '2023-09-14 12:44:38', "is_done" = true, "state" = 'done', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578349, 578350, 578351, 578352, 578353, 578354, 578355, 578356, 578359, 578360);

Date: 2023-09-14 12:44:42 Duration: 3s908ms
UPDATE "stock_move" SET "date" = '2023-09-14 15:40:52', "is_done" = true, "state" = 'done', "write_uid" = 978, "write_date" = (now() at time zone 'UTC') WHERE id IN (585674, 585675, 585676, 585678, 568283, 568285, 580670);

Date: 2023-09-14 15:41:02 Duration: 3s249ms

20

322

Details

1m23s

158ms

1s302ms

260ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Sep 14	10	3	1s600ms	533ms
	11	16	4s689ms	293ms
	12	35	9s205ms	263ms
	13	56	14s750ms	263ms
	14	47	11s840ms	251ms
	15	33	9s152ms	277ms
	16	34	9s393ms	276ms
	17	25	5s280ms	211ms
	18	30	7s746ms	258ms
	19	25	5s769ms	230ms
	20	11	2s292ms	208ms
	21	4	1s577ms	394ms
	22	3	526ms	175ms

UPDATE "sale_order_line" SET "open_qty_fil" = 1.0, "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (236627, 236632, 236633, 236635, 236636, 236637, 236638);

Date: 2023-09-14 11:53:45 Duration: 1s302ms
UPDATE "sale_order_line" SET "open_qty_fil" = 4.0, "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 999, "write_date" = (now() at time zone 'UTC') WHERE id IN (237001, 237002, 237004, 237007, 237008, 237013);

Date: 2023-09-14 15:17:21 Duration: 1s168ms
UPDATE "sale_order_line" SET "open_qty_fil" = 1.0, "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (236963, 236966, 236969, 236971, 236972, 236973);

Date: 2023-09-14 14:37:37 Duration: 1s58ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

3m44s

1

Details

3m44s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Sep 14	09	1	3m44s	3m44s

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-09-14 09:07:38 Duration: 3m44s

2

1s67ms

21s620ms

4s587ms

39

Details

2m58s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Sep 14	03	2	13s62ms	6s531ms
	06	6	47s569ms	7s928ms
	07	2	29s239ms	14s619ms
	14	2	4s431ms	2s215ms
	15	1	7s717ms	7s717ms
	16	6	11s988ms	1s998ms
	17	5	17s619ms	3s523ms
	18	1	1s156ms	1s156ms
	19	4	11s992ms	2s998ms
	23	10	34s141ms	3s414ms

DELETE FROM account_move_line WHERE id IN (3120582, 3120583, 3120584, 3120585, 3120586, 3120587, 3120588, 3120589, 3120590, 3120591, 3120592, 3120487, 3120488, 3120489, 3120490, 3120491, 3120492, 3171468, 3171469, 3171470);

Date: 2023-09-14 06:07:00 Duration: 21s620ms
DELETE FROM account_move_line WHERE id IN (3180114, 3180115, 3180116, 3180117, 3180118, 3180119, 3180120, 3180121, 3180122, 3180123, 3180124, 3180125, 3180126, 3180127, 3180128, 3180129, 3180130);

Date: 2023-09-14 07:12:54 Duration: 18s399ms
DELETE FROM account_move_line WHERE id IN (3075967, 3075968, 3075969, 3075970, 3075971, 3075972, 3075973, 3075974, 3075975, 3075976, 3170026, 3170027, 3170028);

Date: 2023-09-14 06:13:13 Duration: 14s94ms

3

3s556ms

11s245ms

4s40ms

58

Details

3m54s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Sep 14	10	1	3s820ms	3s820ms
	11	6	25s621ms	4s270ms
	12	5	18s423ms	3s684ms
	13	13	47s680ms	3s667ms
	14	7	25s803ms	3s686ms
	15	4	14s738ms	3s684ms
	16	5	21s946ms	4s389ms
	17	6	29s504ms	4s917ms
	18	6	28s830ms	4s805ms
	19	3	10s812ms	3s604ms
	20	1	3s566ms	3s566ms
	22	1	3s626ms	3s626ms

DELETE FROM sale_order_line WHERE id IN (237261, 237262, 237263);

Date: 2023-09-14 17:51:32 Duration: 11s245ms
DELETE FROM sale_order_line WHERE id IN (237138, 237139);

Date: 2023-09-14 18:46:14 Duration: 7s278ms
DELETE FROM sale_order_line WHERE id IN (236087, 236088);

Date: 2023-09-14 11:49:35 Duration: 7s230ms

4

191ms

8s226ms

1s433ms

126

Details

3m

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Sep 14	09	2	2s471ms	1s235ms
	10	1	2s221ms	2s221ms
	11	3	4s198ms	1s399ms
	12	10	8s281ms	828ms
	13	20	32s714ms	1s635ms
	14	28	44s618ms	1s593ms
	15	21	23s135ms	1s101ms
	16	8	12s90ms	1s511ms
	17	24	29s132ms	1s213ms
	18	8	20s398ms	2s549ms
	20	1	1s371ms	1s371ms

UPDATE "stock_move" SET "date" = '2023-09-14 14:46:26', "state" = 'done', "write_uid" = 980, "write_date" = (now() at time zone 'UTC') WHERE id IN (585216, 585217, 585218, 585219, 585220, 585222, 585223, 585224, 585225, 585226, 585227, 585228, 585229, 585231, 585232, 585214, 585215);

Date: 2023-09-14 14:46:36 Duration: 8s226ms
UPDATE "stock_move" SET "date" = '2023-09-14 13:25:57', "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (584931, 584933, 584902, 584934, 584907, 584908, 584910, 584916, 584918, 547352, 547353, 547354, 548124);

Date: 2023-09-14 13:26:06 Duration: 7s599ms
UPDATE "stock_move" SET "date" = '2023-09-14 18:01:58', "state" = 'done', "write_uid" = 1019, "write_date" = (now() at time zone 'UTC') WHERE id IN (495936, 495937, 495938, 495939, 495940, 495941, 495945, 495946);

Date: 2023-09-14 18:02:03 Duration: 5s426ms

5

1s106ms

1s621ms

1s209ms

183

Details

3m41s

select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Sep 14	12	4	4s963ms	1s240ms
	13	47	56s648ms	1s205ms
	14	90	1m50s	1s228ms
	15	11	12s908ms	1s173ms
	16	10	11s796ms	1s179ms
	17	4	4s626ms	1s156ms
	18	17	19s792ms	1s164ms

select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Date: 2023-09-14 14:34:28 Duration: 1s621ms
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Date: 2023-09-14 13:57:52 Duration: 1s592ms
select max(id) from sale_history_line where product_name is not null group by product_name, inventory_short_vendor_name;

Date: 2023-09-14 14:34:28 Duration: 1s577ms

6

891ms

1s401ms

938ms

288

Details

4m30s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Sep 14	09	12	10s830ms	902ms
	10	30	27s485ms	916ms
	11	30	28s490ms	949ms
	12	87	1m22s	953ms
	13	12	11s177ms	931ms
	14	48	44s828ms	933ms
	15	15	14s491ms	966ms
	16	6	5s516ms	919ms
	18	12	11s325ms	943ms
	20	36	33s203ms	922ms

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

Date: 2023-09-14 11:53:44 Duration: 1s401ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%1050A%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1050A%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%1050A%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%1050A%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%1050A%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%1050A%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2023-09-14 14:09:00 Duration: 1s238ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%15-740%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%15-740%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%15-740%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%15-740%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%15-740%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%15-740%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;

Date: 2023-09-14 12:49:28 Duration: 1s215ms

7

889ms

1s194ms

937ms

204

Details

3m11s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Sep 14	09	16	14s442ms	902ms
	10	15	13s750ms	916ms
	11	11	10s370ms	942ms
	12	38	35s790ms	941ms
	13	21	19s548ms	930ms
	14	34	32s350ms	951ms
	15	32	30s968ms	967ms
	16	10	9s47ms	904ms
	18	3	2s822ms	940ms
	20	22	20s299ms	922ms
	21	2	1s825ms	912ms

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

Date: 2023-09-14 14:08:59 Duration: 1s194ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%SH8S0FH%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SH8S0FH%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%SH8S0FH%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%SH8S0FH%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%SH8S0FH%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%SH8S0FH%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2023-09-14 14:17:09 Duration: 1s173ms
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%1050%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1050%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%1050%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%1050%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%1050%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%1050%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;

Date: 2023-09-14 14:09:38 Duration: 1s120ms

8

728ms

1s42ms

769ms

900

Details

11m32s

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

Day	Hour	Count	Duration	Avg duration
Sep 14	00	8	5s928ms	741ms
	10	1	780ms	780ms
	11	39	29s747ms	762ms
	12	127	1m38s	777ms
	13	97	1m14s	771ms
	14	122	1m34s	775ms
	15	112	1m26s	772ms
	16	71	54s282ms	764ms
	17	79	1m	766ms
	18	123	1m34s	769ms
	19	94	1m11s	761ms
	20	19	14s427ms	759ms
	21	8	6s133ms	766ms

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 ('%15-326%')) 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 ('%15-326%'))) 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 ('%15-326%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%15-326%')))))) 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-09-14 12:44:27 Duration: 1s42ms
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 ('%AVM104%')) 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 ('%AVM104%'))) 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 ('%AVM104%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%AVM104%')))))) 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-09-14 14:36:58 Duration: 1s20ms
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 ('%pf4606%')) 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 ('%pf4606%'))) 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 ('%pf4606%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%pf4606%')))))) 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-09-14 15:05:52 Duration: 1s10ms

9

205ms

3s960ms

702ms

323

Details

3m46s

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

Day	Hour	Count	Duration	Avg duration
Sep 14	09	2	1s307ms	653ms
	11	8	5s756ms	719ms
	12	47	44s675ms	950ms
	13	29	18s959ms	653ms
	14	51	34s187ms	670ms
	15	57	42s329ms	742ms
	16	12	8s693ms	724ms
	17	51	29s321ms	574ms
	18	16	13s645ms	852ms
	19	18	11s340ms	630ms
	20	31	16s105ms	519ms
	21	1	677ms	677ms

UPDATE "stock_move" SET "date" = '2023-09-14 12:38:33', "is_done" = true, "state" = 'done', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578528, 578529, 578530, 578531, 578532, 578533, 578534, 578535, 578536, 578537, 578538, 578527);

Date: 2023-09-14 12:38:37 Duration: 3s960ms
UPDATE "stock_move" SET "date" = '2023-09-14 12:44:38', "is_done" = true, "state" = 'done', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578349, 578350, 578351, 578352, 578353, 578354, 578355, 578356, 578359, 578360);

Date: 2023-09-14 12:44:42 Duration: 3s908ms
UPDATE "stock_move" SET "date" = '2023-09-14 15:40:52', "is_done" = true, "state" = 'done', "write_uid" = 978, "write_date" = (now() at time zone 'UTC') WHERE id IN (585674, 585675, 585676, 585678, 568283, 568285, 580670);

Date: 2023-09-14 15:41:02 Duration: 3s249ms

10

565ms

891ms

617ms

1,291

Details

13m17s

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
Sep 14	11	71	43s427ms	611ms
	12	174	1m48s	625ms
	13	145	1m30s	626ms
	14	316	3m17s	623ms
	15	106	1m5s	614ms
	16	144	1m28s	613ms
	17	96	58s989ms	614ms
	18	78	46s736ms	599ms
	19	83	51s373ms	618ms
	20	78	46s443ms	595ms

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 ('%%c207%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%c20-7%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%c20-7%'))) 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-09-14 12:57:04 Duration: 891ms
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 ('%%n23800%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-3-800%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-3-800%'))) 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-09-14 12:41:04 Duration: 886ms
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 ('%%n238001%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%n2-3-8001%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%n2-3-8001%'))) 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-09-14 12:41:05 Duration: 876ms

11

564ms

1s5ms

612ms

3,296

Details

33m37s

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

Day	Hour	Count	Duration	Avg duration
Sep 14	10	39	23s78ms	591ms
	11	263	2m38s	604ms
	12	322	3m19s	619ms
	13	518	5m18s	614ms
	14	449	4m40s	623ms
	15	390	4m	617ms
	16	337	3m23s	605ms
	17	340	3m27s	610ms
	18	275	2m46s	604ms
	19	221	2m14s	609ms
	20	54	32s98ms	594ms
	21	69	40s881ms	592ms
	22	19	11s191ms	589ms

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 ('%%lfp864%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%lfp864%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%lfp864%'))) 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-09-14 15:42:06 Duration: 1s5ms
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%gaff%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%gaff%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%gaff%'))) AND ("product_product__product_tmpl_id"."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-09-14 14:26:42 Duration: 973ms
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 ('%%OR102626X%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%OR102626X%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%OR102626X%'))) 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-09-14 14:05:22 Duration: 952ms

12

570ms

866ms

604ms

614

Details

6m11s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Sep 14	11	35	21s100ms	602ms
	12	59	35s851ms	607ms
	13	50	30s684ms	613ms
	14	41	24s792ms	604ms
	15	78	47s752ms	612ms
	16	86	52s206ms	607ms
	17	60	36s587ms	609ms
	18	143	1m25s	598ms
	19	26	15s351ms	590ms
	20	36	21s279ms	591ms

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

Date: 2023-09-14 13:49:40 Duration: 866ms
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 ('%%laf94%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%laf94%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%laf94%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-09-14 13:49:40 Duration: 865ms
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 ('%%laf9%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%laf9%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%laf9%'))) AND ("product_product__product_tmpl_id"."purchase_ok" IS NOT NULL and "product_product__product_tmpl_id"."purchase_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;

Date: 2023-09-14 13:49:40 Duration: 830ms

13

300ms

2s9ms

543ms

504

Details

4m33s

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

Day	Hour	Count	Duration	Avg duration
Sep 14	09	3	1s491ms	497ms
	11	3	1s319ms	439ms
	12	56	32s154ms	574ms
	13	55	27s995ms	509ms
	14	105	56s704ms	540ms
	15	73	38s318ms	524ms
	16	25	13s3ms	520ms
	17	109	1m2s	574ms
	18	30	16s487ms	549ms
	19	33	17s545ms	531ms
	20	7	3s384ms	483ms
	21	5	2s977ms	595ms

UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2023-09-14 12:00:17', "is_done" = true, "state" = 'done', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (585001, 584995, 584999);

Date: 2023-09-14 12:00:32 Duration: 2s9ms
UPDATE "stock_move" SET "current_warehouse_qty" = 2.0, "date" = '2023-09-14 17:12:23', "is_done" = true, "state" = 'done', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (581842, 581843, 581844);

Date: 2023-09-14 17:12:27 Duration: 1s387ms
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2023-09-14 15:09:09', "is_done" = true, "state" = 'done', "write_uid" = 1025, "write_date" = (now() at time zone 'UTC') WHERE id IN (585584, 585579);

Date: 2023-09-14 15:09:11 Duration: 1s256ms

14

120ms

3s778ms

426ms

422

Details

2m59s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Sep 14	10	2	723ms	361ms
	11	26	10s236ms	393ms
	12	58	28s695ms	494ms
	13	47	24s801ms	527ms
	14	62	24s290ms	391ms
	15	51	19s994ms	392ms
	16	26	12s777ms	491ms
	17	49	18s283ms	373ms
	18	37	15s625ms	422ms
	19	28	8s841ms	315ms
	20	30	13s567ms	452ms
	21	6	2s77ms	346ms

UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (584994, 584995, 584996, 584997, 584998, 584999, 585000, 585001);

Date: 2023-09-14 12:00:07 Duration: 3s778ms
UPDATE "stock_move" SET "state" = 'assigned', "write_uid" = 982, "write_date" = (now() at time zone 'UTC') WHERE id IN (578511, 578512, 578513, 578514, 578515, 578516, 578517, 578518, 578519, 578520, 578521, 578522, 578523, 578524, 578525);

Date: 2023-09-14 12:34:26 Duration: 2s857ms
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 969, "write_date" = (now() at time zone 'UTC') WHERE id IN (586048, 586042, 586043, 586044, 586045, 586046, 586047);

Date: 2023-09-14 17:30:04 Duration: 1s979ms

15

160ms

2s233ms

407ms

325

Details

2m12s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Sep 14	09	3	1s37ms	345ms
	11	10	5s831ms	583ms
	12	33	16s709ms	506ms
	13	60	20s206ms	336ms
	14	51	24s160ms	473ms
	15	41	18s731ms	456ms
	16	23	8s529ms	370ms
	17	40	12s280ms	307ms
	18	36	15s93ms	419ms
	19	20	6s615ms	330ms
	20	7	1s928ms	275ms
	21	1	1s395ms	1s395ms

UPDATE "sale_order_line" SET "qty_delivered_method" = 'stock_move', "state" = 'done', "write_uid" = 958, "write_date" = (now() at time zone 'UTC') WHERE id IN (58156, 58158, 58159, 58160, 58162, 58164, 58165, 58166, 58167, 58168, 58169, 58171);

Date: 2023-09-14 18:54:22 Duration: 2s233ms
UPDATE "sale_order_line" SET "qty_delivered_method" = 'stock_move', "state" = 'done', "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (97088, 97089, 97092, 97093, 97095, 97096, 97099, 97100, 97086);

Date: 2023-09-14 12:16:00 Duration: 1s972ms
UPDATE "sale_order_line" SET "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (236291, 236292, 236324, 236295, 236296, 236297, 237109, 237110, 236311, 236314, 236315);

Date: 2023-09-14 15:53:09 Duration: 1s832ms

16

336ms

540ms

349ms

363

Details

2m6s

select "account_move".id from "account_move" where ((("account_move"."move_type" in (...)) and (("account_move"."non_inventory_entry" = true) or ("account_move"."move_type" in (...)))) and (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Sep 14	12	113	39s367ms	348ms
	13	97	34s102ms	351ms
	14	139	48s484ms	348ms
	15	1	363ms	363ms
	16	7	2s510ms	358ms
	17	2	687ms	343ms
	18	4	1s371ms	342ms

SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%I-01827%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%I-01827%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%I-01827%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%I-01827%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;

Date: 2023-09-14 12:44:28 Duration: 540ms
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%I-02706%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%I-02706%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%I-02706%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%I-02706%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;

Date: 2023-09-14 13:23:54 Duration: 476ms
SELECT "account_move".id FROM "account_move" WHERE ((("account_move"."move_type" in ('in_invoice', 'in_refund')) AND (("account_move"."non_inventory_entry" = true) OR ("account_move"."move_type" in ('in_invoice', 'in_refund')))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%N34490%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%N34490%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%N34490%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%N34490%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;

Date: 2023-09-14 14:10:19 Duration: 476ms

17

228ms

2s632ms

334ms

870

Details

4m51s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Sep 14	09	4	1s485ms	371ms
	10	5	1s329ms	265ms
	11	16	5s337ms	333ms
	12	120	41s556ms	346ms
	13	116	42s434ms	365ms
	14	182	1m1s	337ms
	15	132	43s734ms	331ms
	16	50	15s766ms	315ms
	17	105	34s338ms	327ms
	18	48	15s814ms	329ms
	19	45	13s147ms	292ms
	20	41	12s575ms	306ms
	21	6	2s507ms	417ms

UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1026, "write_date" = (now() at time zone 'UTC') WHERE id IN (349505, 47075, 352869, 347116, 345103, 351162);

Date: 2023-09-14 13:26:13 Duration: 2s632ms
UPDATE "stock_quant" SET "quantity" = 0.0, "reserved_quantity" = 0.0, "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (353331, 353332, 347387);

Date: 2023-09-14 12:00:24 Duration: 1s500ms
UPDATE "stock_quant" SET "quantity" = 4.0, "reserved_quantity" = 0.0, "write_uid" = 1023, "write_date" = (now() at time zone 'UTC') WHERE id IN (321369, 294191, 320313);

Date: 2023-09-14 12:00:25 Duration: 1s423ms

18

245ms

604ms

262ms

2,763

Details

12m5s

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

Day	Hour	Count	Duration	Avg duration
Sep 14	00	2	499ms	249ms
	01	1	249ms	249ms
	05	1	254ms	254ms
	08	4	1s9ms	252ms
	09	3	782ms	260ms
	10	17	4s470ms	262ms
	11	211	54s901ms	260ms
	12	423	1m51s	263ms
	13	367	1m36s	263ms
	14	480	2m7s	265ms
	15	355	1m34s	265ms
	16	180	45s987ms	255ms
	17	322	1m24s	261ms
	18	122	31s769ms	260ms
	19	167	44s301ms	265ms
	20	91	23s258ms	255ms
	21	12	3s44ms	253ms
	22	3	743ms	247ms
	23	2	506ms	253ms

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_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 14:05:22 Duration: 604ms
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-df4ccbc/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 19:14:08 Duration: 534ms
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_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2023-09-14 11:57:22 Duration: 499ms

19

158ms

1s302ms

260ms

322

Details

1m23s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Sep 14	10	3	1s600ms	533ms
	11	16	4s689ms	293ms
	12	35	9s205ms	263ms
	13	56	14s750ms	263ms
	14	47	11s840ms	251ms
	15	33	9s152ms	277ms
	16	34	9s393ms	276ms
	17	25	5s280ms	211ms
	18	30	7s746ms	258ms
	19	25	5s769ms	230ms
	20	11	2s292ms	208ms
	21	4	1s577ms	394ms
	22	3	526ms	175ms

UPDATE "sale_order_line" SET "open_qty_fil" = 1.0, "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 1018, "write_date" = (now() at time zone 'UTC') WHERE id IN (236627, 236632, 236633, 236635, 236636, 236637, 236638);

Date: 2023-09-14 11:53:45 Duration: 1s302ms
UPDATE "sale_order_line" SET "open_qty_fil" = 4.0, "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 999, "write_date" = (now() at time zone 'UTC') WHERE id IN (237001, 237002, 237004, 237007, 237008, 237013);

Date: 2023-09-14 15:17:21 Duration: 1s168ms
UPDATE "sale_order_line" SET "open_qty_fil" = 1.0, "qty_delivered_method" = 'stock_move', "state" = 'sale', "write_uid" = 1, "write_date" = (now() at time zone 'UTC') WHERE id IN (236963, 236966, 236969, 236971, 236972, 236973);

Date: 2023-09-14 14:37:37 Duration: 1s58ms

20

120ms

623ms

247ms

4,096

Details

16m52s

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

Day	Hour	Count	Duration	Avg duration
Sep 14	00	25	4s153ms	166ms
	01	29	4s836ms	166ms
	02	32	5s507ms	172ms
	03	21	3s548ms	168ms
	04	5	854ms	170ms
	05	11	1s894ms	172ms
	06	26	4s403ms	169ms
	07	31	5s56ms	163ms
	08	32	5s560ms	173ms
	09	29	4s987ms	171ms
	10	24	3s907ms	162ms
	11	187	52s151ms	278ms
	12	448	2m10s	290ms
	13	416	1m54s	275ms
	14	542	2m17s	253ms
	15	497	1m57s	237ms
	16	392	1m35s	243ms
	17	400	1m35s	237ms
	18	462	2m	260ms
	19	337	1m16s	227ms
	20	88	17s231ms	195ms
	21	15	2s512ms	167ms
	22	25	4s384ms	175ms
	23	22	3s659ms	166ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1035"', '["pointspring_master","calendar.alarm",19573]', '["pointspring_master","mail.channel",66]', '["pointspring_master","mail.channel",432]', '["pointspring_master","mail.channel",476]', '["pointspring_master","res.partner",19573]', '["pointspring_master","ir.needaction",19573]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 623ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19532]', '["pointspring_master","mail.channel",318]', '["pointspring_master","mail.channel",319]', '["pointspring_master","mail.channel",320]', '["pointspring_master","mail.channel",321]', '["pointspring_master","mail.channel",455]', '["pointspring_master","mail.channel",466]', '["pointspring_master","res.partner",19532]', '["pointspring_master","ir.needaction",19532]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 619ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-14 12:14:18') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";

Date: 2023-09-14 12:15:08 Duration: 610ms

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

39,841 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	31	0.08%
DETAIL	23	0.06%
ERROR	1,094	2.75%
HINT	45	0.11%
LOG	37,540	94.22%
STATEMENT	1,108	2.78%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
1094 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

546 Max number of times the same event was reported
1,094 Total events found

Rank

Times reported

Error

1

546

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Sep 14	00	35
	01	45
	02	31
	03	19
	04	13
	05	30
	06	26
	07	19
	08	16
	09	20
	10	46
	11	22
	12	20
	13	17
	14	19
	15	26
	16	22
	17	13
	18	21
	19	16
	20	14
	21	19
	22	16
	23	21

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

2

470

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Sep 14	00	1
	08	3
	09	3
	10	6
	11	46
	12	74
	13	68
	14	60
	15	45
	16	23
	17	41
	18	27
	19	47
	20	23
	23	3

ERROR: could not serialize access due to concurrent update

3

44

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Sep 14	09	44

ERROR: column product_template.max_product_uom_qty does not exist at character 6520

4

15

Details

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

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Sep 14	12	2
	13	5
	14	3
	15	2
	17	2
	18	1

ERROR: process 1394454 still waiting for ShareLock on transaction 205886021 after 1000.042 ms
ERROR: process 1680649 still waiting for ShareLock on transaction 205887866 after 1000.047 ms
ERROR: process 1395100 still waiting for ShareLock on transaction 205888536 after 1000.055 ms

5

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Sep 14	23	5

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

6

5

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Sep 14	23	5

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

7

2

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Sep 14	09	2

ERROR: could not create unique index "vendor_account_master_unique_acc_no"

8

2

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Sep 14	08	1
	14	1

ERROR: syntax error at or near "line" at character 70
ERROR: syntax error at or near "limit" at character 54

9

1

Details

ERROR: column "..." must appear in the GROUP BY clause or be used in an aggregate function

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Sep 14	14	1

ERROR: column "company_transfer.id" must appear in the GROUP BY clause or be used in an aggregate function at character 17

10

1

Details

ERROR: column reference "..." is ambiguous

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Sep 14	08	1

ERROR: column reference "id" is ambiguous at character 14

11

1

Details

ERROR: operator does not exist: character varying == unknown

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Sep 14	08	1

ERROR: operator does not exist: character varying == unknown at character 201

12

1

Details

ERROR: duplicate key value violates unique constraint "..."

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Sep 14	15	1

ERROR: duplicate key value violates unique constraint "mail_followers_mail_followers_res_partner_res_model_id_uniq"

13

1

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Sep 14	15	1

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

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoint write buffers (5 minutes period)

Checkpoints Wal files

Key values

Checkpoint Wal files usage (5 minutes period)

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Checkpoint causes

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables