pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Jan 25 23:47:20 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 38,721,297 log entries in 2m18s
Log start from 2025-01-25 00:00:00 to 2025-01-25 22:45:02

Global Stats

14,977 Number of unique normalized queries
16,670,665 Number of queries
6d5h59m4s Total query duration
2025-01-25 00:00:00 First query
2025-01-25 22:45:02 Last query
5,192 queries/s at 2025-01-25 16:01:12 Query peak

6d5h59m4s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
6d5h59m4s Execute total duration

24,921 Number of events
25 Number of unique normalized events
20,326 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
16,670,665 Average queries per session
6d5h59m4s 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

5,192 queries/s Query Peak
2025-01-25 16:01:12 Date

SELECT Traffic

Key values

3,953 queries/s Query Peak
2025-01-25 16:01:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

968 queries/s Query Peak
2025-01-25 15:22:05 Date

Queries duration

Key values

6d5h59m4s 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)
Jan 25	00	205,378	0ms	3s88ms	23ms	2m52s	3m7s	4m1s
	01	281,020	0ms	1s47ms	27ms	3m46s	4m5s	5m15s
	02	162,540	0ms	2s531ms	15ms	1m26s	1m45s	2m1s
	03	111,054	0ms	689ms	18ms	1m16s	1m32s	1m59s
	04	49,106	0ms	645ms	3ms	7s450ms	20s410ms	31s630ms
	05	97,725	0ms	4s421ms	25ms	1m42s	2m17s	2m23s
	06	139,748	0ms	689ms	15ms	1m9s	1m20s	1m31s
	07	91,288	0ms	668ms	11ms	1m8s	1m45s	1m54s
	08	352,591	0ms	30s532ms	8ms	2m11s	2m36s	3m31s
	09	983,551	0ms	42m33s	59ms	6m17s	6m47s	12h23m59s
	10	1,493,985	0ms	12m18s	41ms	11m56s	2h24m30s	3h55m7s
	11	1,524,487	0ms	7m52s	22ms	6m56s	1h8m	1h42m49s
	12	1,557,859	0ms	46m33s	42ms	8m55s	2h34m15s	5h48m59s
	13	1,289,159	0ms	23m	41ms	6m40s	54m54s	6h2m39s
	14	1,458,518	0ms	21m12s	35ms	4m37s	2h12m51s	3h56m47s
	15	1,736,338	0ms	11m53s	22ms	8m34s	9m42s	4h23m29s
	16	1,171,646	0ms	18m50s	28ms	5m46s	8m21s	3h23m43s
	17	1,075,516	0ms	14m22s	26ms	6m14s	6m32s	3h51m48s
	18	806,265	0ms	59m30s	21ms	5m51s	6m41s	1h1m45s
	19	821,930	0ms	51m56s	39ms	6m41s	9m22s	4h39m59s
	20	647,629	0ms	10s726ms	25ms	9m21s	11m54s	12m36s
	21	397,360	0ms	59m59s	40ms	6m26s	6m47s	1h1m33s
	22	215,972	0ms	3s382ms	16ms	2m48s	3m14s	3m51s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 25	00	105,017	46ms	1m59s	2m52s	3m42s
	01	151,231	51ms	3m12s	3m46s	4m28s
	02	82,971	29ms	1m4s	1m26s	1m55s
	03	52,670	37ms	1m	1m16s	1m32s
	04	20,101	7ms	1s138ms	7s426ms	30s454ms
	05	51,002	49ms	1m14s	1m42s	2m21s
	06	73,269	29ms	1m2s	1m9s	1m25s
	07	45,533	23ms	46s945ms	1m8s	1m50s
	08	204,077	14ms	1m29s	2m11s	3m21s
	09	573,131	24ms	5m29s	6m13s	6m46s
	10	903,513	20ms	7m14s	9m6s	10m36s
	11	914,263	17ms	5m51s	6m16s	6m55s
	12	960,742	14ms	5m7s	5m39s	8m15s
	13	769,295	15ms	4m47s	5m7s	6m38s
	14	904,681	9ms	3m31s	3m42s	4m29s
	15	1,075,357	15ms	6m56s	7m57s	9m5s
	16	700,894	16ms	4m33s	5m10s	7m
	17	656,608	17ms	4m24s	5m23s	6m29s
	18	473,735	28ms	5m16s	5m45s	6m40s
	19	492,316	32ms	5m38s	6m30s	9m20s
	20	373,864	43ms	6m57s	9m13s	12m2s
	21	226,818	54ms	4m40s	6m9s	6m45s
	22	118,748	29ms	1m43s	2m48s	3m50s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 25	00	18,063	4,188	143	0	0ms	107ms	144ms	209ms
	01	29,906	7,217	223	0	0ms	181ms	241ms	359ms
	02	7,990	2,533	165	0	0ms	49ms	76ms	124ms
	03	6,090	1,945	129	0	0ms	37ms	53ms	87ms
	04	501	346	129	0	0ms	0ms	3ms	32ms
	05	9,452	2,448	133	0	0ms	61ms	91ms	145ms
	06	7,861	2,032	133	0	0ms	47ms	58ms	174ms
	07	2,281	1,316	131	0	0ms	16ms	39ms	71ms
	08	9,853	4,319	261	0	3ms	78ms	112ms	211ms
	09	49,468	17,022	770	0	662ms	310ms	370ms	757ms
	10	69,176	20,563	789	0	488ms	516ms	683ms	2h21m56s
	11	66,818	19,592	747	0	205ms	409ms	504ms	1h3m17s
	12	60,229	18,497	783	2	664ms	395ms	566ms	2h32m4s
	13	51,408	16,621	524	1	602ms	306ms	394ms	53m20s
	14	36,625	14,992	600	1	820ms	224ms	296ms	2h11m47s
	15	58,408	22,066	823	0	272ms	370ms	620ms	1m34s
	16	49,858	18,279	573	0	322ms	301ms	431ms	55s687ms
	17	52,014	15,327	507	0	255ms	428ms	540ms	43s167ms
	18	50,894	14,110	509	0	54ms	351ms	444ms	899ms
	19	58,395	16,298	629	0	222ms	337ms	473ms	750ms
	20	60,613	20,111	394	0	0ms	371ms	523ms	792ms
	21	42,249	7,771	214	0	72ms	260ms	328ms	588ms
	22	16,454	3,921	126	0	0ms	119ms	154ms	249ms

Day	Hour	Percentage of prepare
Jan 25	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%

Day	Hour	Average / Second
Jan 25	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

Day	Hour	Average Duration	Average idle time
Jan 25	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

↑ 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 Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

63,330 buffers Checkpoint Peak
2025-01-25 13:21:26 Date
270.064 seconds Highest write time
0.025 seconds Sync time

Checkpoints Wal files

Key values

27 files Wal files usage Peak
2025-01-25 13:21:26 Date

Checkpoints distance

Key values

849.93 Mo Distance Peak
2025-01-25 13:21:26 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 25	00	87,720	3,180.492s	0.031s	3,180.568s
	01	127,449	3,239.555s	0.036s	3,239.633s
	02	76,134	3,189.767s	0.025s	3,189.835s
	03	48,623	2,932.292s	0.023s	2,932.35s
	04	9,045	655.171s	0.028s	655.23s
	05	25,764	1,923.902s	0.024s	1,923.956s
	06	77,946	2,835.193s	0.028s	2,835.254s
	07	38,592	1,892.167s	0.023s	1,892.218s
	08	69,293	2,015.405s	0.03s	2,015.469s
	09	330,320	3,239.508s	0.041s	3,239.625s
	10	480,909	3,239.504s	0.063s	3,239.661s
	11	500,803	3,239.497s	0.048s	3,239.639s
	12	472,850	3,239.472s	0.06s	3,239.624s
	13	376,622	2,969.531s	0.041s	2,969.641s
	14	271,266	3,239.498s	0.066s	3,239.618s
	15	364,877	3,239.485s	0.046s	3,239.603s
	16	299,124	3,239.549s	0.048s	3,239.655s
	17	218,347	2,884.952s	0.069s	2,885.077s
	18	202,506	3,239.516s	0.048s	3,239.62s
	19	229,095	3,239.527s	0.039s	3,239.632s
	20	212,884	3,239.587s	0.052s	3,239.7s
	21	245,617	3,239.568s	0.041s	3,239.664s
	22	77,065	2,429.587s	0.028s	2,429.645s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 25	00	40	3,009	0.002s	0.012s
	01	60	3,650	0.002s	0.012s
	02	35	2,636	0.002s	0.012s
	03	23	1,782	0.002s	0.012s
	04	4	617	0.010s	0.012s
	05	11	1,975	0.002s	0.012s
	06	34	2,090	0.002s	0.011s
	07	17	1,594	0.002s	0.013s
	08	30	2,524	0.002s	0.011s
	09	146	4,791	0.004s	0.012s
	10	218	5,193	0.003s	0.012s
	11	235	5,285	0.003s	0.012s
	12	217	5,607	0.005s	0.012s
	13	168	5,134	0.002s	0.011s
	14	119	5,138	0.023s	0.012s
	15	161	5,516	0.002s	0.012s
	16	133	5,848	0.003s	0.012s
	17	97	5,627	0.010s	0.012s
	18	91	5,518	0.003s	0.012s
	19	101	5,364	0.002s	0.012s
	20	95	5,420	0.002s	0.012s
	21	109	4,621	0.002s	0.012s
	22	33	3,346	0.002s	0.009s

Day	Hour	Avg time (sec)
Jan 25	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

Day	Hour	Mean distance	Mean estimate
Jan 25	00	54,200.75 kB	95,325.83 kB
	01	81,916.83 kB	97,846.25 kB
	02	48,409.83 kB	94,068.25 kB
	03	30,718.83 kB	49,026.25 kB
	04	5,541.67 kB	26,299.83 kB
	05	15,003.25 kB	34,312.50 kB
	06	50,952.27 kB	80,856.73 kB
	07	21,378.54 kB	67,227.77 kB
	08	43,567.80 kB	66,527.50 kB
	09	200,311.00 kB	233,348.17 kB
	10	303,051.82 kB	334,298.55 kB
	11	320,783.42 kB	387,673.42 kB
	12	295,401.08 kB	335,422.75 kB
	13	251,489.64 kB	362,864.27 kB
	14	161,643.33 kB	250,637.92 kB
	15	224,349.55 kB	251,987.64 kB
	16	187,466.80 kB	228,273.80 kB
	17	137,802.18 kB	212,057.45 kB
	18	124,651.33 kB	201,707.25 kB
	19	135,173.45 kB	170,131.91 kB
	20	129,157.83 kB	165,958.25 kB
	21	149,340.83 kB	228,289.42 kB
	22	59,753.11 kB	179,188.11 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (270) Main checkpoint cause
271 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	270
shutdown immediate	1
Total	271

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
Jan 25	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

↑ 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)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

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
Jan 25	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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

9,929,836 Total read queries
4,546,607 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	9,929,836	59.56%
INSERT	814,606	4.89%
UPDATE	251,514	1.51%
DELETE	9,435	0.06%
COPY FROM	4	0.00%
COPY TO	0	0.00%
CTE	25,028	0.15%
DDL	2,040	0.01%
TCL	3,443,980	20.66%
CURSOR	0	0.00%
OTHERS	2,194,222	13.16%

Queries by database

Key values

unknown Main database
16,670,665 Requests
6d5h59m4s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	16,670,665	6d5h59m4s
	copy from	4	3ms
	cte	25,028	5s303ms
	ddl	2,040	289ms
	delete	9,435	40s303ms
	insert	814,606	4m18s
	others	2,194,222	1m38s
	select	9,929,836	2d10h23m55s
	tcl	3,443,980	2m12s
	update	251,514	3d19h26m13s

Queries by user

Key values

unknown Main user
16,670,665 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	16,670,665	6d5h59m4s
	copy from	4	3ms
	cte	25,028	5s303ms
	ddl	2,040	289ms
	delete	9,435	40s303ms
	insert	814,606	4m18s
	others	2,194,222	1m38s
	select	9,929,836	2d10h23m55s
	tcl	3,443,980	2m12s
	update	251,514	3d19h26m13s

Duration by user

Key values

6d5h59m4s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	16,670,665	6d5h59m4s
	copy from	4	3ms
	cte	25,028	5s303ms
	ddl	2,040	289ms
	delete	9,435	40s303ms
	insert	814,606	4m18s
	others	2,194,222	1m38s
	select	9,929,836	2d10h23m55s
	tcl	3,443,980	2m12s
	update	251,514	3d19h26m13s

Queries by host

Key values

unknown Main host
16,670,665 Requests
6d5h59m4s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	16,670,665	6d5h59m4s
	copy from	4	3ms
	cte	25,028	5s303ms
	ddl	2,040	289ms
	delete	9,435	40s303ms
	insert	814,606	4m18s
	others	2,194,222	1m38s
	select	9,929,836	2d10h23m55s
	tcl	3,443,980	2m12s
	update	251,514	3d19h26m13s

Queries by application

Key values

unknown Main application
16,670,665 Requests
6d5h59m4s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	16,670,665	6d5h59m4s
	copy from	4	3ms
	cte	25,028	5s303ms
	ddl	2,040	289ms
	delete	9,435	40s303ms
	insert	814,606	4m18s
	others	2,194,222	1m38s
	select	9,929,836	2d10h23m55s
	tcl	3,443,980	2m12s
	update	251,514	3d19h26m13s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-25 14:44:49 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

15,699,081 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	15,699,081	94.17%
1-5ms	252,391	1.51%
5-10ms	11,012	0.07%
10-25ms	45,177	0.27%
25-50ms	107,179	0.64%
50-100ms	72,322	0.43%
100-500ms	241,331	1.45%
500-1000ms	239,595	1.44%
1000-10000ms	1,748	0.01%
> 10000ms	829	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-25 19:49:04.407158', exp_date = '2025-01-25 20:34:04.407160', logged_in = 'TRUE' where id = 870; [ Date: 2025-01-25 21:49:03 ]
2	59m30s	update res_users set sid = '7c3e3c874e7d4fa7a8ab32372ccdbca4af2224f6', last_update = '2025-01-25 16:50:52.137009', exp_date = '2025-01-25 17:35:52.137013', logged_in = 'TRUE' where id = 1229; [ Date: 2025-01-25 18:50:22 ]
3	51m56s	update res_users set sid = 'e338a6487a430bdd925e43904d215aa63f4bf3bd', last_update = '2025-01-25 17:30:24.372809', exp_date = '2025-01-25 18:15:24.372811', logged_in = 'TRUE' where id = 823; [ Date: 2025-01-25 19:22:21 ]
4	51m56s	update res_users set sid = 'e338a6487a430bdd925e43904d215aa63f4bf3bd', last_update = '2025-01-25 17:30:24.372676', exp_date = '2025-01-25 18:15:24.372680', logged_in = 'TRUE' where id = 823; [ Date: 2025-01-25 19:22:21 ]
5	46m33s	update res_users set sid = 'fd4d93b918c78ad6920cfb145702e3d7374daf3a', last_update = '2025-01-25 10:20:47.154652', exp_date = '2025-01-25 11:05:47.154655', logged_in = 'TRUE' where id = 1401; [ Date: 2025-01-25 12:07:20 ]
6	46m33s	update res_users set sid = 'fd4d93b918c78ad6920cfb145702e3d7374daf3a', last_update = '2025-01-25 10:20:47.154622', exp_date = '2025-01-25 11:05:47.154626', logged_in = 'TRUE' where id = 1401; [ Date: 2025-01-25 12:07:20 ]
7	45m12s	update res_users set sid = 'fd4d93b918c78ad6920cfb145702e3d7374daf3a', last_update = '2025-01-25 10:22:08.116642', exp_date = '2025-01-25 11:07:08.116646', logged_in = 'TRUE' where id = 1401; [ Date: 2025-01-25 12:07:20 ]
8	42m33s	UPDATE "res_users" SET "exp_date" = '2025-01-25 08:52:46.485077', "last_update" = '2025-01-25 08:07:46.485103', "write_date" = '2025-01-25 08:07:46.090828', "write_uid" = 1 WHERE id IN (1081); [ Date: 2025-01-25 09:50:20 ]
9	41m48s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:08:32.282279', exp_date = '2025-01-25 08:53:32.282285', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
10	40m52s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:09:27.932009', exp_date = '2025-01-25 08:54:27.932014', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
11	40m16s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:10:03.545325', exp_date = '2025-01-25 08:55:03.545330', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
12	39m	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:11:20.206898', exp_date = '2025-01-25 08:56:20.206903', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
13	38m51s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:11:29.450533', exp_date = '2025-01-25 08:56:29.450536', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
14	38m50s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:11:30.519463', exp_date = '2025-01-25 08:56:30.519466', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
15	38m49s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:11:31.128775', exp_date = '2025-01-25 08:56:31.128779', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
16	38m48s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:11:31.925788', exp_date = '2025-01-25 08:56:31.925792', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
17	38m46s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:11:34.287244', exp_date = '2025-01-25 08:56:34.287248', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
18	37m48s	update res_users set sid = '7721b8dfa835d876703b5ba43998d567f5e7c585', last_update = '2025-01-25 08:12:31.985946', exp_date = '2025-01-25 08:57:31.985947', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-25 09:50:20 ]
19	36m56s	update res_users set sid = 'e338a6487a430bdd925e43904d215aa63f4bf3bd', last_update = '2025-01-25 17:45:24.745382', exp_date = '2025-01-25 18:30:24.745387', logged_in = 'TRUE' where id = 823; [ Date: 2025-01-25 19:22:21 ]
20	34m3s	UPDATE "res_users" SET "exp_date" = '2025-01-25 09:01:16.862215', "last_update" = '2025-01-25 08:16:16.862238', "sid" = 'd3224b87962030c58f0d1d2816363c040e44a24b', "write_date" = '2025-01-25 08:16:16.527892', "write_uid" = 1 WHERE id IN (1081); [ Date: 2025-01-25 09:50:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d9h4m30s

58,394

Details

0ms

59m59s

4s998ms

update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 25	00	579	126ms	0ms
	01	970	214ms	0ms
	02	611	128ms	0ms
	03	414	88ms	0ms
	04	71	15ms	0ms
	05	169	35ms	0ms
	06	376	83ms	0ms
	07	212	46ms	0ms
	08	1,149	46s822ms	40ms
	09	3,627	6h34m3s	6s518ms
	10	6,108	10h57m2s	6s454ms
	11	6,494	4h46m35s	2s647ms
	12	6,612	14h2m13s	7s642ms
	13	5,432	10h42m50s	7s100ms
	14	4,882	11h38m29s	8s584ms
	15	4,773	5h55m44s	4s471ms
	16	3,879	5h59m26s	5s559ms
	17	3,491	3h49m43s	3s948ms
	18	2,465	59m33s	1s449ms
	19	2,486	4h38m	6s709ms
	20	1,761	439ms	0ms
	21	1,063	59m59s	3s386ms
	22	770	180ms	0ms

update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-25 19:49:04.407158', exp_date = '2025-01-25 20:34:04.407160', logged_in = 'TRUE' where id = 870;

Date: 2025-01-25 21:49:03 Duration: 59m59s
update res_users set sid = '7c3e3c874e7d4fa7a8ab32372ccdbca4af2224f6', last_update = '2025-01-25 16:50:52.137009', exp_date = '2025-01-25 17:35:52.137013', logged_in = 'TRUE' where id = 1229;

Date: 2025-01-25 18:50:22 Duration: 59m30s
update res_users set sid = 'e338a6487a430bdd925e43904d215aa63f4bf3bd', last_update = '2025-01-25 17:30:24.372809', exp_date = '2025-01-25 18:15:24.372811', logged_in = 'TRUE' where id = 823;

Date: 2025-01-25 19:22:21 Duration: 51m56s

2

1d7h15m52s

192,596

Details

455ms

1s912ms

584ms

select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 25	00	6,265	56m1s	536ms
	01	8,829	1h20m58s	550ms
	02	3,334	29m23s	528ms
	03	2,821	24m29s	520ms
	04	142	1m14s	527ms
	05	2,373	22m7s	559ms
	06	2,864	24m53s	521ms
	07	1,205	10m23s	517ms
	08	3,369	29m24s	523ms
	09	12,835	2h43s	564ms
	10	16,721	2h48m24s	604ms
	11	15,918	2h32m54s	576ms
	12	13,935	2h12m33s	570ms
	13	10,572	1h38m46s	560ms
	14	7,081	1h4m46s	548ms
	15	13,845	2h17m19s	595ms
	16	8,722	1h22m48s	569ms
	17	9,114	1h32m14s	607ms
	18	11,002	1h52m49s	615ms
	19	12,851	2h14m4s	625ms
	20	10,630	1h54m44s	647ms
	21	14,589	2h29m49s	616ms
	22	3,579	34m57s	586ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4742127)) AND (("shipping_track"."id" not in (39188825, 39189042, 39189137, 39387824, 39387824)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 10:57:30 Duration: 1s912ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4775502)) AND (("shipping_track"."id" not in (39498145, 39498145)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 20:35:29 Duration: 1s160ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4775645)) AND (("shipping_track"."id" not in (39499032, 39499032)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 20:38:22 Duration: 1s109ms

3

8h56m46s

341

Details

0ms

34m3s

1m34s

update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 25	00	3	0ms	0ms
	01	2	1ms	0ms
	02	1	0ms	0ms
	03	2	0ms	0ms
	05	1	0ms	0ms
	06	1	0ms	0ms
	07	2	0ms	0ms
	08	14	5ms	0ms
	09	51	5h5m35s	5m59s
	10	50	1h19m10s	1m35s
	11	29	11m57s	24s748ms
	12	19	4m39s	14s705ms
	13	24	45m27s	1m53s
	14	26	9m58s	23s37ms
	15	12	12m48s	1m4s
	16	25	8m36s	20s664ms
	17	32	58m30s	1m49s
	18	16	6ms	0ms
	19	13	19ms	1ms
	20	6	3ms	0ms
	21	8	2ms	0ms
	22	4	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-25 09:01:16.862215', "last_update" = '2025-01-25 08:16:16.862238', "sid" = 'd3224b87962030c58f0d1d2816363c040e44a24b', "write_date" = '2025-01-25 08:16:16.527892', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 34m3s
UPDATE "res_users" SET "exp_date" = '2025-01-25 09:03:18.594091', "last_update" = '2025-01-25 08:18:18.594113', "sid" = 'd3224b87962030c58f0d1d2816363c040e44a24b', "write_date" = '2025-01-25 08:18:18.273980', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 32m1s
UPDATE "res_users" SET "exp_date" = '2025-01-25 09:03:26.809548', "last_update" = '2025-01-25 08:18:26.809570', "sid" = 'd3224b87962030c58f0d1d2816363c040e44a24b', "write_date" = '2025-01-25 08:18:26.490517', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 31m53s

4

6h29m26s

39,765

Details

457ms

2s986ms

587ms

select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 25	00	125	1m16s	608ms
	01	752	6m56s	554ms
	02	203	1m58s	583ms
	03	94	55s851ms	594ms
	04	9	5s334ms	592ms
	05	26	15s541ms	597ms
	06	144	1m22s	574ms
	07	128	1m6s	522ms
	08	701	6m15s	535ms
	09	3,540	33m54s	574ms
	10	4,002	40m47s	611ms
	11	4,325	42m47s	593ms
	12	4,229	41m18s	585ms
	13	3,512	33m27s	571ms
	14	2,930	27m4s	554ms
	15	3,172	31m23s	593ms
	16	2,439	22m55s	563ms
	17	2,231	21m45s	585ms
	18	2,080	20m46s	599ms
	19	2,502	25m36s	614ms
	20	1,752	18m23s	629ms
	21	700	7m21s	630ms
	22	169	1m41s	600ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4669388)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 10:57:27 Duration: 2s986ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4718058)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 10:57:30 Duration: 1s933ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4711976)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 17:21:56 Duration: 1s751ms

5

5h11m20s

84,083

Details

173ms

400ms

222ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,053	3m26s	196ms
	01	1,373	4m33s	199ms
	02	539	1m46s	197ms
	03	940	3m5s	196ms
	04	90	17s878ms	198ms
	05	1,103	3m36s	196ms
	06	902	2m57s	197ms
	07	803	2m39s	198ms
	08	1,760	5m52s	200ms
	09	9,987	35m20s	212ms
	10	7,096	26m33s	224ms
	11	4,247	15m34s	219ms
	12	2,474	8m51s	214ms
	13	3,310	11m34s	209ms
	14	3,285	11m16s	205ms
	15	14,133	53m17s	226ms
	16	6,317	22m27s	213ms
	17	1,963	6m36s	202ms
	18	1,999	7m8s	214ms
	19	4,555	16m47s	221ms
	20	15,228	1h4m34s	254ms
	21	602	1m59s	198ms
	22	324	1m2s	192ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9982578')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 15:11:36 Duration: 400ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '110009')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 20:37:56 Duration: 377ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9626747')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 20:35:21 Duration: 370ms

6

3h14m11s

48,971

Details

91ms

916ms

237ms

select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,909	5m53s	185ms
	01	4,246	15m33s	219ms
	02	614	2m7s	207ms
	05	1,822	7m5s	233ms
	06	122	29s402ms	241ms
	08	44	5s439ms	123ms
	09	140	27s203ms	194ms
	10	324	1m20s	249ms
	11	234	1m1s	263ms
	12	260	56s704ms	218ms
	13	664	2m21s	213ms
	14	910	3m55s	259ms
	15	1,881	8m27s	269ms
	16	3,187	12m43s	239ms
	17	5,571	22m5s	237ms
	18	6,692	27m31s	246ms
	19	6,821	28m21s	249ms
	20	6,620	27m20s	247ms
	21	5,104	20m6s	236ms
	22	1,806	6m17s	208ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-25 19:38:01 Duration: 916ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسين')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-25 19:38:01 Duration: 847ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محل')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-25 16:04:46 Duration: 847ms

7

2h3m5s

8,419

Details

227ms

1s409ms

877ms

select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 25	00	317	4m41s	887ms
	01	249	3m48s	918ms
	08	3	2s558ms	852ms
	09	1	868ms	868ms
	10	2	2s352ms	1s176ms
	11	11	9s962ms	905ms
	13	242	3m50s	954ms
	14	111	1m46s	962ms
	15	501	8m12s	983ms
	16	645	10m1s	933ms
	17	1,242	19m15s	929ms
	18	956	14m29s	909ms
	19	1,656	24m34s	890ms
	20	1,399	16m55s	725ms
	21	700	9m49s	842ms
	22	384	5m22s	838ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9991061')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:35:50 Duration: 1s409ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '58845')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:35:15 Duration: 1s387ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '58849')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:35:18 Duration: 1s369ms

8

1h33m45s

118,623

Details

36ms

323ms

47ms

select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 25	00	2,832	2m4s	44ms
	01	3,072	2m16s	44ms
	02	1,251	55s715ms	44ms
	03	820	36s784ms	44ms
	04	103	4s567ms	44ms
	05	582	25s714ms	44ms
	06	1,236	54s692ms	44ms
	07	171	7s658ms	44ms
	08	1,620	1m11s	44ms
	09	9,145	7m14s	47ms
	10	13,367	11m19s	50ms
	11	12,406	10m2s	48ms
	12	11,393	9m9s	48ms
	13	9,479	7m26s	47ms
	14	5,699	4m21s	45ms
	15	6,265	5m9s	49ms
	16	5,337	4m8s	46ms
	17	6,231	4m46s	45ms
	18	7,137	5m26s	45ms
	19	6,977	5m26s	46ms
	20	6,356	5m10s	48ms
	21	4,793	3m43s	46ms
	22	2,351	1m43s	44ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4688972, 4664561, 4656632)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 10:57:28 Duration: 323ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4742845)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 10:57:50 Duration: 208ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4723896, 4710473, 4701288, 4688846, 4688369, 4662936, 4662711)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 12:42:30 Duration: 106ms

9

1h20m40s

48

Details

0ms

42m33s

1m40s

update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 25	01	2	0ms	0ms
	02	2	1ms	0ms
	04	1	1ms	1ms
	08	4	2ms	0ms
	09	5	42m33s	8m30s
	10	1	2ms	2ms
	11	8	10ms	1ms
	12	8	32m55s	4m6s
	13	2	1ms	0ms
	14	4	5m11s	1m17s
	15	1	0ms	0ms
	16	1	0ms	0ms
	17	1	1ms	1ms
	18	1	0ms	0ms
	20	3	3ms	1ms
	21	4	2ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-25 08:52:46.485077', "last_update" = '2025-01-25 08:07:46.485103', "write_date" = '2025-01-25 08:07:46.090828', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 42m33s
UPDATE "res_users" SET "exp_date" = '2025-01-25 11:24:50.759170', "last_update" = '2025-01-25 10:39:50.759192', "write_date" = '2025-01-25 10:39:50.440580', "write_uid" = 1 WHERE id IN (959);

Date: 2025-01-25 12:07:20 Duration: 27m30s
UPDATE "res_users" SET "exp_date" = '2025-01-25 14:32:09.404985', "last_update" = '2025-01-25 13:47:09.405007', "write_date" = '2025-01-25 13:47:09.070541', "write_uid" = 959 WHERE id IN (959);

Date: 2025-01-25 14:52:20 Duration: 5m11s

10

1h13m58s

16,385

Details

221ms

479ms

270ms

select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 25	00	650	2m55s	269ms
	01	1,900	8m23s	265ms
	02	315	1m22s	261ms
	05	919	3m53s	253ms
	06	72	18s389ms	255ms
	08	31	7s553ms	243ms
	09	77	20s606ms	267ms
	10	169	52s792ms	312ms
	11	107	31s13ms	289ms
	12	133	38s493ms	289ms
	13	98	27s916ms	284ms
	14	357	1m36s	271ms
	15	456	2m17s	300ms
	16	977	4m27s	273ms
	17	1,569	7m3s	269ms
	18	2,421	10m45s	266ms
	19	1,791	8m9s	273ms
	20	1,940	9m	278ms
	21	1,882	8m33s	273ms
	22	521	2m13s	256ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9855950')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:36:36 Duration: 479ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9354192')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:38:22 Duration: 461ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9842452')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:37:56 Duration: 460ms

11

57m52s

12,253

Details

193ms

581ms

283ms

select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 25	08	125	34s910ms	279ms
	09	1,667	7m41s	276ms
	10	1,619	7m39s	283ms
	11	987	5m4s	308ms
	12	321	1m30s	283ms
	13	1,081	5m14s	290ms
	14	1,574	7m4s	269ms
	15	1,464	7m11s	294ms
	16	1,614	7m24s	275ms
	17	847	3m45s	265ms
	18	335	1m47s	320ms
	19	619	2m54s	281ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9248780')))) ORDER BY "collection_policy"."id";

Date: 2025-01-25 11:16:48 Duration: 581ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '473501')))) ORDER BY "collection_policy"."id";

Date: 2025-01-25 11:16:40 Duration: 563ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9190418')))) ORDER BY "collection_policy"."id";

Date: 2025-01-25 11:16:47 Duration: 562ms

12

51m7s

14,555

Details

173ms

360ms

210ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 25	00	23	4s446ms	193ms
	02	10	1s965ms	196ms
	03	53	10s435ms	196ms
	04	90	17s854ms	198ms
	05	747	2m26s	196ms
	06	902	2m58s	197ms
	07	803	2m39s	198ms
	08	1,026	3m24s	199ms
	09	2,243	7m51s	210ms
	10	1,869	7m5s	227ms
	11	1,166	4m16s	220ms
	12	1,152	4m8s	215ms
	13	802	2m47s	209ms
	14	448	1m32s	206ms
	15	311	1m9s	222ms
	16	341	1m11s	210ms
	17	233	48s701ms	209ms
	18	1,025	3m38s	212ms
	19	507	1m47s	212ms
	20	356	1m17s	218ms
	21	232	47s775ms	205ms
	22	216	41s661ms	192ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9926632')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 10:57:20 Duration: 360ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9963921')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 10:47:29 Duration: 355ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '14567')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 10:57:49 Duration: 351ms

13

32m43s

16,622

Details

94ms

307ms

118ms

select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 25	00	8	892ms	111ms
	01	79	9s107ms	115ms
	02	12	1s391ms	115ms
	07	3	328ms	109ms
	08	153	17s282ms	112ms
	09	819	1m40s	122ms
	10	1,536	3m9s	123ms
	11	1,526	3m	118ms
	12	1,800	3m30s	116ms
	13	1,652	3m8s	114ms
	14	1,361	2m33s	112ms
	15	3,180	6m21s	120ms
	16	1,719	3m14s	113ms
	17	715	1m23s	116ms
	18	490	58s139ms	118ms
	19	607	1m14s	122ms
	20	796	1m40s	126ms
	21	137	15s966ms	116ms
	22	29	3s269ms	112ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8036183)) AND (("cash_track"."id" not in (7342053)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-25 17:23:04 Duration: 307ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8033875)) AND (("cash_track"."id" not in (7327321)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-25 10:57:33 Duration: 234ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8033868)) AND (("cash_track"."id" not in (7327314)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-25 10:57:20 Duration: 208ms

14

19m45s

2,552

Details

347ms

749ms

464ms

select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) order by "cash_policy"."id" desc;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 25	09	390	3m11s	490ms
	10	349	2m49s	484ms
	11	233	1m48s	465ms
	12	419	3m21s	481ms
	13	815	5m58s	439ms
	14	319	2m23s	449ms
	15	10	4s432ms	443ms
	16	17	8s162ms	480ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9916610')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-25 10:34:10 Duration: 749ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '239')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-25 10:34:13 Duration: 715ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '477454')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-25 10:33:52 Duration: 702ms

15

17m53s

18,783

Details

44ms

98ms

57ms

select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1	54ms	54ms
	07	3	164ms	54ms
	08	159	8s407ms	52ms
	09	1,864	1m43s	55ms
	10	2,927	2m59s	61ms
	11	1,365	1m18s	57ms
	12	668	37s604ms	56ms
	13	1,782	1m38s	55ms
	14	2,002	1m48s	54ms
	15	3,093	3m4s	59ms
	16	1,604	1m28s	55ms
	17	847	46s99ms	54ms
	18	1,114	1m1s	54ms
	19	1,299	1m14s	57ms
	20	52	3s173ms	61ms
	21	3	173ms	57ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4649299) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-25 10:57:31 Duration: 98ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4576141) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-25 10:33:52 Duration: 95ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2254771) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-25 20:35:50 Duration: 95ms

16

15m55s

6,622

Details

120ms

308ms

144ms

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) 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)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 25	00	10	1s313ms	131ms
	01	40	5s337ms	133ms
	06	5	657ms	131ms
	08	10	1s323ms	132ms
	09	604	1m27s	144ms
	10	1,082	2m43s	150ms
	11	1,284	3m8s	146ms
	12	1,240	2m58s	144ms
	13	1,069	2m27s	138ms
	14	268	37s32ms	138ms
	15	338	49s176ms	145ms
	16	131	18s337ms	139ms
	17	186	25s766ms	138ms
	18	100	13s860ms	138ms
	19	41	5s938ms	144ms
	20	74	11s233ms	151ms
	21	73	10s278ms	140ms
	22	67	8s908ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-25 10:57:25 Duration: 308ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-25 10:57:50 Duration: 277ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) 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)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-25 20:35:02 Duration: 274ms

17

12m28s

3,802

Details

159ms

233ms

196ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,030	3m22s	196ms
	01	1,374	4m32s	198ms
	02	503	1m38s	195ms
	03	869	2m50s	196ms
	22	26	5s80ms	195ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9967589')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 01:29:39 Duration: 233ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9558641')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 01:35:01 Duration: 227ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9795070')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 01:30:51 Duration: 227ms

18

10m56s

2,726

Details

200ms

408ms

240ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 25	00	120	26s578ms	221ms
	01	120	27s135ms	226ms
	02	120	26s612ms	221ms
	03	120	26s563ms	221ms
	04	120	26s576ms	221ms
	05	120	26s478ms	220ms
	06	120	26s488ms	220ms
	07	120	26s495ms	220ms
	08	120	26s484ms	220ms
	09	120	28s359ms	236ms
	10	120	29s882ms	249ms
	11	120	29s543ms	246ms
	12	120	28s481ms	237ms
	13	120	28s237ms	235ms
	14	120	27s546ms	229ms
	15	120	29s158ms	242ms
	16	120	27s843ms	232ms
	17	116	30s95ms	259ms
	18	120	32s771ms	273ms
	19	120	33s699ms	280ms
	20	120	34s208ms	285ms
	21	120	33s450ms	278ms
	22	90	23s367ms	259ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-25 20:51:01 Duration: 408ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-25 20:37:02 Duration: 407ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-25 20:35:02 Duration: 397ms

19

9m46s

212

Details

28ms

4s213ms

2s767ms

select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 25	00	5	14s846ms	2s969ms
	09	5	16s247ms	3s249ms
	10	4	13s389ms	3s347ms
	11	7	12s666ms	1s809ms
	12	6	23s796ms	3s966ms
	13	16	19s998ms	1s249ms
	14	12	27s748ms	2s312ms
	15	9	29s107ms	3s234ms
	16	45	2m5s	2s791ms
	17	13	40s438ms	3s110ms
	18	16	49s17ms	3s63ms
	19	11	36s841ms	3s349ms
	20	44	2m2s	2s777ms
	21	1	3s530ms	3s530ms
	22	18	51s346ms	2s852ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))))))) AND ("policy_number"."name"::text ilike '%9911030%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-25 12:42:37 Duration: 4s213ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))))) AND ("policy_number"."name"::text ilike '%486433%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-25 12:30:38 Duration: 4s136ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))))) AND ("policy_number"."name"::text ilike '%6%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-25 14:59:52 Duration: 4s12ms

20

9m46s

2,302

Details

14ms

892ms

254ms

select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 25	00	3	965ms	321ms
	01	4	960ms	240ms
	06	1	165ms	165ms
	07	4	227ms	56ms
	08	38	5s714ms	150ms
	09	136	29s980ms	220ms
	10	165	43s994ms	266ms
	11	233	56s864ms	244ms
	12	341	1m19s	232ms
	13	303	1m26s	286ms
	14	251	1m6s	264ms
	15	264	1m7s	253ms
	16	197	43s303ms	219ms
	17	127	34s510ms	271ms
	18	95	30s893ms	325ms
	19	52	14s964ms	287ms
	20	55	18s788ms	341ms
	21	18	2s657ms	147ms
	22	15	3s539ms	235ms

SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-25 13:05:57 Duration: 892ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-25 13:05:57 Duration: 875ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-25 13:05:57 Duration: 872ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,192,864

Details

1m38s

0ms

13ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 25	00	32,660	1s321ms	0ms
	01	36,961	1s767ms	0ms
	02	27,625	1s196ms	0ms
	03	20,115	831ms	0ms
	04	12,332	399ms	0ms
	05	14,509	596ms	0ms
	06	22,154	1s4ms	0ms
	07	17,460	664ms	0ms
	08	52,366	2s394ms	0ms
	09	130,111	6s750ms	0ms
	10	189,216	8s260ms	0ms
	11	199,274	9s267ms	0ms
	12	196,766	8s331ms	0ms
	13	174,947	7s407ms	0ms
	14	192,339	7s370ms	0ms
	15	218,480	10s254ms	0ms
	16	159,574	6s900ms	0ms
	17	136,242	6s70ms	0ms
	18	105,707	5s356ms	0ms
	19	99,240	4s614ms	0ms
	20	75,822	3s759ms	0ms
	21	48,275	2s408ms	0ms
	22	30,689	1s494ms	0ms

DISCARD ALL;

Date: 2025-01-25 13:07:03 Duration: 13ms
DISCARD ALL;

Date: 2025-01-25 09:43:03 Duration: 1ms
DISCARD ALL;

Date: 2025-01-25 09:15:15 Duration: 1ms

2

1,722,500

Details

23s467ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 25	00	22,605	333ms	0ms
	01	27,724	429ms	0ms
	02	20,611	307ms	0ms
	03	15,034	231ms	0ms
	04	7,842	125ms	0ms
	05	10,088	171ms	0ms
	06	17,142	265ms	0ms
	07	12,280	187ms	0ms
	08	40,761	576ms	0ms
	09	106,087	1s504ms	0ms
	10	153,740	2s93ms	0ms
	11	160,582	2s151ms	0ms
	12	158,481	2s16ms	0ms
	13	137,041	1s735ms	0ms
	14	152,971	1s839ms	0ms
	15	179,345	2s455ms	0ms
	16	120,021	1s574ms	0ms
	17	106,141	1s401ms	0ms
	18	80,168	1s148ms	0ms
	19	76,797	1s91ms	0ms
	20	58,144	900ms	0ms
	21	35,916	577ms	0ms
	22	22,979	349ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-25 20:54:38 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-25 16:19:24 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-25 12:13:22 Duration: 0ms

3

1,116,972

Details

10s599ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 25	00	16,966	142ms	0ms
	01	19,104	179ms	0ms
	02	14,424	125ms	0ms
	03	10,686	90ms	0ms
	04	6,719	52ms	0ms
	05	7,830	69ms	0ms
	06	11,670	104ms	0ms
	07	9,325	75ms	0ms
	08	27,061	244ms	0ms
	09	66,280	650ms	0ms
	10	96,200	948ms	0ms
	11	100,701	989ms	0ms
	12	99,548	954ms	0ms
	13	88,728	815ms	0ms
	14	97,242	849ms	0ms
	15	110,316	1s106ms	0ms
	16	80,912	744ms	0ms
	17	69,193	648ms	0ms
	18	53,904	502ms	0ms
	19	50,527	507ms	0ms
	20	38,696	396ms	0ms
	21	25,013	252ms	0ms
	22	15,927	149ms	0ms

ROLLBACK;

Date: 2025-01-25 11:16:15 Duration: 1ms
ROLLBACK;

Date: 2025-01-25 09:04:45 Duration: 0ms
ROLLBACK;

Date: 2025-01-25 12:38:01 Duration: 0ms

4

1,104,632

Details

2m57s

0ms

12ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 25	00	16,308	2s443ms	0ms
	01	18,502	3s80ms	0ms
	02	13,793	1s930ms	0ms
	03	10,026	1s352ms	0ms
	04	6,112	642ms	0ms
	05	7,218	996ms	0ms
	06	11,050	1s586ms	0ms
	07	8,736	1s47ms	0ms
	08	26,424	3s758ms	0ms
	09	65,672	10s702ms	0ms
	10	95,510	16s249ms	0ms
	11	100,411	16s667ms	0ms
	12	99,230	16s392ms	0ms
	13	88,383	13s612ms	0ms
	14	96,875	14s556ms	0ms
	15	109,890	18s720ms	0ms
	16	80,474	12s672ms	0ms
	17	68,750	11s45ms	0ms
	18	53,238	8s407ms	0ms
	19	49,999	8s549ms	0ms
	20	38,231	6s782ms	0ms
	21	24,352	4s279ms	0ms
	22	15,448	2s495ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'a6231a342a54c5b6d4ffa101f67d905c8e06b987';

Date: 2025-01-25 11:25:32 Duration: 12ms
SELECT payload FROM http_sessions WHERE sid = '0a706d86cecfc8ae2320d287b5f33dff96d336b6';

Date: 2025-01-25 10:09:43 Duration: 10ms
SELECT payload FROM http_sessions WHERE sid = 'bf4f2782db6fe59128d3d4c056bdc68bcc08c140';

Date: 2025-01-25 12:07:22 Duration: 8ms

5

1,096,263

Details

1m34s

0ms

1ms

0ms

select base_registry_signaling.last_value, base_cache_signaling.last_value from base_registry_signaling, base_cache_signaling;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 25	00	16,390	1s285ms	0ms
	01	18,551	1s601ms	0ms
	02	13,872	1s118ms	0ms
	03	10,125	800ms	0ms
	04	6,239	451ms	0ms
	05	7,326	606ms	0ms
	06	11,149	926ms	0ms
	07	8,810	671ms	0ms
	08	26,169	2s105ms	0ms
	09	64,934	5s548ms	0ms
	10	94,403	8s232ms	0ms
	11	99,558	8s800ms	0ms
	12	98,293	8s469ms	0ms
	13	87,376	7s329ms	0ms
	14	96,065	7s734ms	0ms
	15	109,228	9s989ms	0ms
	16	79,745	6s791ms	0ms
	17	68,041	5s991ms	0ms
	18	52,848	4s455ms	0ms
	19	49,628	4s427ms	0ms
	20	37,960	3s455ms	0ms
	21	24,170	2s145ms	0ms
	22	15,383	1s283ms	0ms

SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-25 01:52:44 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-25 19:43:56 Duration: 0ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-25 13:13:48 Duration: 0ms

6

796,175

Details

1m53s

0ms

19ms

0ms

select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" from "res_users" where "res_users".id in (...);

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 25	00	6,567	1s155ms	0ms
	01	10,238	1s730ms	0ms
	02	7,545	1s211ms	0ms
	03	4,907	876ms	0ms
	04	1,172	350ms	0ms
	05	2,457	550ms	0ms
	06	6,743	1s130ms	0ms
	07	3,273	646ms	0ms
	08	17,079	2s466ms	0ms
	09	51,196	7s330ms	0ms
	10	73,539	10s62ms	0ms
	11	77,262	11s308ms	0ms
	12	75,804	10s423ms	0ms
	13	62,662	8s101ms	0ms
	14	80,529	9s175ms	0ms
	15	104,227	13s360ms	0ms
	16	49,983	6s751ms	0ms
	17	47,489	6s442ms	0ms
	18	33,368	5s114ms	0ms
	19	33,374	5s264ms	0ms
	20	24,473	4s638ms	0ms
	21	13,455	3s177ms	0ms
	22	8,833	2s151ms	0ms

SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1113, 1225, 1010);

Date: 2025-01-25 15:13:30 Duration: 19ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (989);

Date: 2025-01-25 12:07:22 Duration: 13ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (949);

Date: 2025-01-25 17:21:54 Duration: 12ms

7

604,491

Details

1m38s

0ms

34ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 25	00	5,642	1s189ms	0ms
	01	8,616	1s881ms	0ms
	02	6,191	1s180ms	0ms
	03	4,346	811ms	0ms
	04	1,125	144ms	0ms
	05	2,257	395ms	0ms
	06	5,473	812ms	0ms
	07	2,955	355ms	0ms
	08	13,696	1s892ms	0ms
	09	39,749	6s369ms	0ms
	10	57,343	9s726ms	0ms
	11	59,766	9s915ms	0ms
	12	58,782	10s118ms	0ms
	13	48,208	7s955ms	0ms
	14	55,568	7s408ms	0ms
	15	68,935	9s559ms	0ms
	16	39,064	6s356ms	0ms
	17	36,866	5s754ms	0ms
	18	26,267	4s464ms	0ms
	19	26,240	4s534ms	0ms
	20	19,440	3s559ms	0ms
	21	10,909	2s561ms	0ms
	22	7,053	1s272ms	0ms

COMMIT;

Date: 2025-01-25 10:47:20 Duration: 34ms
COMMIT;

Date: 2025-01-25 09:52:25 Duration: 33ms
COMMIT;

Date: 2025-01-25 12:06:11 Duration: 31ms

8

516,234

Details

30s740ms

0ms

1ms

0ms

select "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" from "urgent_office" where "urgent_office".id in (...);

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 25	00	3,083	186ms	0ms
	01	4,939	282ms	0ms
	02	3,443	182ms	0ms
	03	1,772	95ms	0ms
	04	563	27ms	0ms
	05	1,070	64ms	0ms
	06	4,496	235ms	0ms
	07	1,868	91ms	0ms
	08	9,360	503ms	0ms
	09	30,397	1s791ms	0ms
	10	43,928	2s869ms	0ms
	11	47,117	3s22ms	0ms
	12	49,198	2s978ms	0ms
	13	38,738	2s245ms	0ms
	14	58,904	2s916ms	0ms
	15	80,474	4s878ms	0ms
	16	31,149	1s836ms	0ms
	17	30,585	1s798ms	0ms
	18	22,060	1s282ms	0ms
	19	22,375	1s469ms	0ms
	20	16,287	1s105ms	0ms
	21	9,043	573ms	0ms
	22	5,385	302ms	0ms

SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (26, 123, 38, 73, 27, 24, 64, 9, 17, 115, 127, 126, 128, 39, 28, 121, 29, 61, 5, 41, 10, 19, 102, 119, 76, 3, 8, 11, 7, 44, 1, 46, 113, 114, 4, 78, 110, 2, 6, 36, 65, 66, 70, 35, 30, 80, 60, 67, 79, 52, 16, 77);

Date: 2025-01-25 09:05:04 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);

Date: 2025-01-25 10:44:41 Duration: 0ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (74);

Date: 2025-01-25 17:18:37 Duration: 0ms

9

509,138

Details

1m1s

0ms

9ms

0ms

select "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" from "urgent_customer" where "urgent_customer".id in (...);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 25	00	4,058	491ms	0ms
	01	7,414	717ms	0ms
	02	4,520	468ms	0ms
	03	2,057	245ms	0ms
	04	706	109ms	0ms
	05	1,872	201ms	0ms
	06	3,921	452ms	0ms
	07	1,189	146ms	0ms
	08	8,304	1s76ms	0ms
	09	30,030	3s996ms	0ms
	10	42,834	6s197ms	0ms
	11	44,816	6s161ms	0ms
	12	45,672	5s972ms	0ms
	13	36,597	4s503ms	0ms
	14	57,576	5s89ms	0ms
	15	81,611	9s34ms	0ms
	16	29,572	3s469ms	0ms
	17	30,151	3s657ms	0ms
	18	22,139	2s518ms	0ms
	19	22,521	2s722ms	0ms
	20	16,764	2s208ms	0ms
	21	9,285	1s77ms	0ms
	22	5,529	668ms	0ms

SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5347742, 5099901, 5107010, 5099277, 5099135, 5114533, 5100457, 5099009, 5099144, 5099761, 5099445, 5099333, 5112390, 5099102, 5100514, 5099281, 5193566, 5099138, 5098978, 5490257, 5102523, 5101185, 5101977, 5117821, 5100217, 5099630, 5100872, 5099013, 5100935, 5099920, 5490164, 5108671, 5288093, 5101843, 5309169, 5129038, 5100506, 5146908, 5099092, 5099684, 5490106, 5109251, 5099037, 5099590, 5223791, 5102056, 5099035, 5100431, 5114931, 5111804, 5099008, 5101449, 5099095, 5115877, 5134575, 5174041, 5099260, 5490002, 5266689, 5099636, 5099165, 5099206, 5100070, 5101949, 5099119, 5099441, 5100529, 5111905, 5114896, 5103230, 5099027, 5100202, 5099646, 5099007, 5101531, 5099585, 5099403, 5099177, 5099727, 5100110, 5123876, 5100801, 5099577, 5102152, 5099111);

Date: 2025-01-25 17:21:54 Duration: 9ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099009, 5220316, 5099540, 5130100, 5099913, 5099929, 5099119, 5100638, 5099007, 5181404, 5099254, 5100890, 5100005, 5099263, 5099014, 5099404, 5101065, 5099008, 5269225, 5099867, 5201833, 5100025, 5127488, 5100421, 5099237, 5101878, 5099585, 5120138, 5187688, 5121740, 5099006, 5103784, 5098996, 5157765, 5099503, 5099916, 5099727, 5099162, 5099558, 5113906, 5369847, 5099630, 5099573, 5099138, 5108058, 5101294, 5099141, 5107714, 5099010, 5111111, 5101445, 5099159, 5101563, 5099102, 5116714, 5100259, 5101107, 5175724, 5109279, 5100233, 5356666, 5100772, 5099170, 5100796, 5105492, 5099422, 5105338, 5099111, 5104194, 5107470, 5100062, 5099296, 5100564, 5099169, 5100952, 5100346, 5128723, 5099349, 5395978, 5101638, 5099252, 5099013, 5099333);

Date: 2025-01-25 17:21:55 Duration: 5ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5490381, 5170213, 5490380, 5447058, 5490379, 5490378, 5161161, 5490377, 5187811, 5206269, 5156477, 5136861, 5154028, 5427034, 5490376, 5490375, 5209902, 5258232, 5154593, 5165113, 5490374, 5341599, 5247711, 5490373, 5490372, 5490371, 5188601, 5149605, 5197416, 5296198, 5315545, 5490370, 5339752, 5490369, 5285904, 5490366, 5490368, 5490367, 5490365, 5453880, 5182845, 5252567, 5479781, 5373635, 5226067, 5490364, 5308385, 5262811, 5490363, 5292883, 5204134, 5484364, 5352015, 5486179, 5251741, 5168534, 5368783, 5219730, 5490362, 5490361, 5490360, 5227350, 5490359, 5490358, 5204417, 5167252, 5490353, 5481250, 5490352, 5238410, 5138909, 5490349, 5219130, 5490348, 5161190, 5490331, 5475108, 5490330, 5303805, 5150808, 5490329, 5490328, 5194258, 5228458, 5482811, 5212821, 5181714, 5217973, 5490325, 5230645, 5156891, 5156883, 5490324, 5437406, 5490323, 5350715, 5248721, 5490322, 5182964, 5208301, 5140381, 5155491, 5376161, 5355242, 5352899, 5224929, 5186814, 5277083, 5442000, 5402810, 5271161, 5449664, 5173612, 5221044, 5205981, 5435155, 5409940, 5490301, 5256034, 5488435, 5490300, 5169191, 5490299, 5407739, 5196342, 5166211, 5176061, 5490288, 5191762, 5329845, 5172508, 5490287, 5174814, 5343466, 5206290, 5172998, 5142368, 5152660, 5452132, 5182131, 5195588, 5154345, 5490240, 5191447, 5218738, 5302914, 5156239, 5490228, 5164143, 5165029, 5192251, 5158064, 5490196, 5179595, 5257324, 5205548, 5319766, 5179550, 5490160, 5390518, 5490133, 5146908, 5490130, 5296367, 5473946, 5453274, 5202086, 5170060, 5151834, 5347494, 5400834, 5274344, 5490126, 5216912, 5230306, 5236993, 5217079, 5490123, 5150268, 5134271, 5150807, 5418559, 5471805, 5490118, 5490117, 5490116, 5245335, 5314152, 5256671, 5306498, 5207030, 5160248, 5171626, 5152220, 5490094, 5163339, 5490076, 5151285, 5479590, 5490069, 5177825, 5177721, 5169327, 5140292, 5231312, 5149078, 5490051, 5490050, 5490049, 5490048, 5300382, 5490047, 5274054, 5473284, 5281234, 5397212, 5307725, 5490032, 5490046, 5448722, 5490045, 5490044, 5490043, 5490042, 5490040, 5330811, 5164878, 5465670, 5448353, 5490039, 5260543, 5439377, 5490037, 5218846, 5490036, 5230217, 5490035, 5490034, 5346288, 5490033, 5222739, 5490030, 5490031, 5490029, 5416910, 5151999, 5245866, 5172765, 5162752, 5490016, 5150721, 5151716, 5277622, 5207027, 5194563, 5169937, 5177112, 5165055, 5490011, 5193514, 5173825, 5334658, 5414488, 5490005, 5146518, 5150730, 5489988, 5150725, 5226776, 5226956, 5263136, 5210225, 5142608, 5142947, 5178167, 5381817, 5489982, 5412023, 5188268, 5160705, 5180588, 5336998, 5170366, 5173084, 5233046, 5142823, 5211784, 5146514, 5248001, 5489967, 5344112, 5174381, 5489963, 5137317, 5180684, 5383001, 5180711, 5466702, 5262899, 5212748, 5216280, 5281119, 5228420, 5426842, 5225989, 5489947, 5185308, 5458759, 5346775, 5398679, 5444156, 5200800, 5138921, 5284831, 5425977, 5203378, 5247332, 5144097, 5489939, 5179987, 5174004, 5287957, 5220340, 5329410, 5489938, 5435847, 5192604, 5336938, 5489929, 5142611, 5489928, 5489927, 5414018, 5141667, 5211381, 5159746, 5234359, 5489922, 5327021, 5138424, 5159932, 5207585, 5471180, 5489916, 5462222, 5468492, 5204092, 5160763, 5206454, 5252993, 5161500, 5489911, 5184543, 5392877, 5489905, 5489902, 5356989, 5144162, 5489896, 5457849, 5489895, 5155401, 5489892, 5489893, 5489887, 5489883, 5161370, 5165687, 5146323, 5489880, 5143946, 5455679, 5489878, 5345066, 5352128, 5155671, 5489876, 5268568, 5187582, 5150257, 5189896, 5489868, 5206710, 5183114, 5174091, 5442575, 5489865, 5154514, 5194627, 5489854, 5489849, 5362261, 5162958, 5164381, 5489844, 5489837, 5240656, 5489823, 5317970, 5263472, 5489822, 5489813, 5323581, 5489812, 5155856, 5489809, 5489761, 5479936, 5489759, 5244579, 5324024, 5184278, 5489749, 5397798, 5489744, 5139619, 5139592, 5347265, 5346821, 5489685, 5322121, 5489653, 5489651, 5489650, 5456094, 5157260, 5194121, 5309259, 5263333, 5174374, 5489633, 5489631, 5149075, 5140015, 5297414, 5245294, 5489626, 5489625, 5489617, 5489618, 5489614, 5467044, 5165017, 5489602, 5278123, 5489502, 5489495, 5358463, 5236732, 5160405, 5489462, 5489460, 5134839, 5280642, 5467736, 5312719, 5489372, 5185873, 5309135, 5489338, 5155515, 5489329, 5220780, 5489323, 5178160, 5489308, 5468944, 5284752, 5489180, 5143008, 5489145, 5258570, 5284201, 5138550, 5311508, 5489115, 5164983, 5162836, 5474650, 5489099, 5199117, 5164006, 5489069, 5296305, 5489063, 5489059, 5489060, 5182404, 5489055, 5489054, 5244549, 5291420, 5317821, 5207700, 5489025, 5189379, 5150643, 5176609, 5463624, 5488970, 5148136, 5170497, 5488961, 5177110, 5202919, 5488957, 5488955, 5172127, 5164453, 5173610, 5302011, 5207748, 5393013, 5358828, 5488924, 5164617, 5432204, 5425782, 5488921, 5488908, 5488884, 5150214, 5488880, 5197814, 5488866, 5310334, 5273699, 5351749, 5488828, 5488807, 5175965, 5196626, 5258400, 5488764, 5292977, 5244360, 5344961, 5206885, 5197552, 5155734, 5488694, 5155514, 5184172, 5488681, 5488679, 5184843, 5488657, 5455190, 5488653, 5488647, 5488646, 5157093, 5488643, 5488638, 5488637, 5154561, 5154986, 5361335, 5329168, 5165138, 5152218, 5488581, 5240893, 5251889, 5488569, 5180710, 5300753, 5311290, 5273849, 5239968, 5488550, 5488548, 5209732, 5301488, 5195430, 5488537, 5488535, 5467177, 5475248, 5211260, 5488519, 5219434, 5235965, 5184678, 5435923, 5392211, 5194530, 5198121, 5488491, 5144871, 5488489, 5488487, 5310982, 5161467, 5148755, 5239261, 5326434, 5158031, 5217237, 5258305, 5488392, 5422143, 5139411, 5268199, 5155807, 5269865, 5420113, 5185688, 5159289, 5190753, 5284245, 5477592, 5487941, 5487939, 5282790, 5210894, 5487912, 5487891, 5174461, 5149286, 5487860, 5170536, 5487677, 5417068, 5486563, 5477408, 5167180, 5193332, 5139408, 5246751, 5215768, 5322601, 5487557, 5457534, 5391935, 5487491, 5151738, 5193599, 5456965, 5230931, 5149749, 5188711, 5487349, 5370660, 5487344, 5266154, 5435146, 5487319, 5300757, 5487304, 5227865, 5215955, 5354838, 5272852, 5250520, 5278976, 5273814, 5198052, 5487115, 5215493, 5314631, 5175416, 5136905, 5401179, 5227107, 5174855, 5193566, 5388868, 5470246, 5357242, 5136195, 5139593, 5371669, 5199149, 5486755, 5486676, 5185114, 5311451, 5486511, 5486497, 5485235, 5486432, 5139190, 5150075, 5316036, 5486380, 5155354, 5486264, 5335859, 5467162, 5464774, 5142276, 5323028, 5443619, 5486013, 5485993, 5175279, 5183366, 5302460, 5485933, 5149613, 5193604, 5151239, 5350853, 5229811, 5261685, 5142242, 5485037, 5150805, 5185286, 5160896, 5286790, 5409988, 5484815, 5484781, 5236928, 5155487, 5250724, 5358017, 5484352, 5484008, 5209680, 5365587, 5263108, 5209163, 5239911, 5220874, 5227017, 5324582, 5228259, 5229060, 5482897, 5482850, 5324893, 5482375, 5482343, 5139371, 5481522, 5481473, 5176733, 5257507, 5461018, 5481243, 5458552, 5155158, 5416439, 5305089, 5375925, 5139691, 5202741, 5154977, 5160454, 5137903, 5227763, 5195583, 5161476, 5139008, 5332413, 5174416, 5476723, 5476584, 5322881, 5137872, 5466008, 5476339, 5324934, 5475925, 5475472, 5448366, 5474934, 5321896, 5474717, 5249829, 5306185, 5146521, 5158247, 5255881, 5186116, 5231602, 5155877, 5137579, 5395086, 5283689, 5451607, 5470098, 5469961, 5469866, 5254294, 5402469, 5398778, 5333287, 5140577, 5146096, 5468391, 5468150, 5173607, 5265874, 5467473, 5156212, 5407848, 5190398, 5466641, 5466642, 5325733, 5465997, 5143019, 5464115, 5138414, 5136884, 5462076, 5348097, 5354567, 5193835, 5417772, 5460688, 5460676, 5460483, 5460008, 5313207, 5459305, 5458795, 5285857, 5457774, 5457625, 5206417, 5270010, 5412934, 5207689, 5435306, 5454001, 5453873, 5171684, 5171892, 5182703, 5451037, 5321381, 5394151, 5263088, 5243404, 5449849, 5208141, 5263022, 5436698, 5448656, 5210089, 5145116, 5447468, 5147042, 5220611, 5446309, 5446310, 5364205, 5445787, 5198278, 5445240, 5444719, 5278694, 5262662, 5443891, 5160071, 5285395, 5442979, 5164802, 5366214, 5441786, 5228983, 5343800, 5440478, 5218544, 5438451, 5434217, 5314092, 5255670, 5188117, 5427349, 5435634, 5434024, 5433977, 5433708, 5282324, 5245742, 5431908, 5431398, 5430863, 5189324, 5430394, 5430311, 5235863, 5430176, 5258863, 5316128, 5428091, 5210197, 5427366, 5160734, 5172655, 5425660, 5339799, 5388403, 5175644, 5224940, 5238679, 5213295, 5414171, 5235969, 5414022, 5410015, 5255415, 5178703, 5220942, 5408466, 5173929, 5408159, 5407539, 5406572, 5406573, 5406198, 5216186, 5230996, 5162407, 5199422, 5260183, 5214178, 5402095, 5248454, 5400498, 5397605, 5256127, 5219944, 5167761, 5397238, 5183043, 5397235, 5165465, 5191749, 5361076, 5394578, 5165406, 5281303, 5392313, 5171392, 5388642, 5321594, 5138442, 5168817, 5296497, 5386749, 5386399, 5380446, 5380383, 5182946, 5220278, 5375456, 5375434, 5372851, 5207158, 5327092, 5369805, 5272911, 5369678, 5246334, 5365215, 5364555, 5364559, 5362489, 5191320, 5361416, 5305331, 5169151, 5156071, 5354545, 5169742, 5353577, 5183187, 5265322, 5350847, 5350598, 5348836, 5347952, 5335853, 5232332, 5346633, 5232198, 5346006, 5345393, 5345392, 5235464, 5146027, 5158217, 5341111, 5192230, 5307255, 5158470, 5334714, 5141262, 5148195, 5331156, 5147315, 5172985, 5202334);

Date: 2025-01-25 15:11:45 Duration: 5ms

10

350,373

Details

1m48s

0ms

3ms

0ms

select r.id from ir_rule r join ir_model m on (r.model_id = m.id) where m.model = ? and r.active and r.perm_read and (r.id in ( select rule_group_id from rule_group_rel rg join res_groups_users_rel gu on (rg.group_id = gu.gid) where gu.uid = ?) or r.global) order by r.id;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 25	00	2,050	619ms	0ms
	01	2,390	743ms	0ms
	02	1,217	367ms	0ms
	03	623	197ms	0ms
	04	110	33ms	0ms
	05	506	146ms	0ms
	06	1,113	328ms	0ms
	07	744	215ms	0ms
	08	7,377	2s160ms	0ms
	09	16,700	5s272ms	0ms
	10	35,715	11s536ms	0ms
	11	36,649	11s864ms	0ms
	12	42,767	13s118ms	0ms
	13	31,234	9s502ms	0ms
	14	32,993	9s507ms	0ms
	15	30,487	9s958ms	0ms
	16	30,021	8s996ms	0ms
	17	27,329	8s185ms	0ms
	18	15,607	4s564ms	0ms
	19	17,421	5s451ms	0ms
	20	9,898	3s195ms	0ms
	21	4,521	1s378ms	0ms
	22	2,901	852ms	0ms

SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'add.delivery.info.shipping.policies.wizard' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1387) OR r.global) ORDER BY r.id;

Date: 2025-01-25 11:20:37 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1423) OR r.global) ORDER BY r.id;

Date: 2025-01-25 17:21:54 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 835) OR r.global) ORDER BY r.id;

Date: 2025-01-25 17:21:54 Duration: 2ms

11

341,784

Details

1m1s

0ms

10ms

0ms

select "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" from "res_partner" where "res_partner".id in (...);

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,936	332ms	0ms
	01	2,950	537ms	0ms
	02	2,371	412ms	0ms
	03	1,200	216ms	0ms
	04	308	49ms	0ms
	05	928	121ms	0ms
	06	2,905	443ms	0ms
	07	1,452	216ms	0ms
	08	7,974	1s194ms	0ms
	09	21,950	3s808ms	0ms
	10	31,180	5s992ms	0ms
	11	33,000	6s201ms	0ms
	12	31,993	5s923ms	0ms
	13	27,693	4s806ms	0ms
	14	37,408	6s338ms	0ms
	15	46,309	9s191ms	0ms
	16	22,216	3s896ms	0ms
	17	20,953	3s727ms	0ms
	18	13,769	2s360ms	0ms
	19	13,907	2s561ms	0ms
	20	9,854	1s855ms	0ms
	21	5,668	1s55ms	0ms
	22	3,860	614ms	0ms

SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8006461);

Date: 2025-01-25 17:21:54 Duration: 10ms
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (1);

Date: 2025-01-25 21:28:30 Duration: 8ms
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8004716, 8004667, 8006338, 8006396, 8004666, 8004805, 8004808, 8007763, 8006341, 8007305, 8004701, 8006534, 8006432, 8006302, 8004661, 8004679, 8004655, 8006333, 8004676, 8006288, 8004671, 8007032, 8006459, 8006273, 8006320, 8006353, 8004660, 8006456, 8007174, 8007563, 8007571, 8007226, 8006457, 8006410, 8006411, 8004698, 8007486, 8006324, 8006460, 8004680, 8006354, 8004664, 8004685, 8004683, 8007691, 8006327, 8006282, 8007456, 8006343, 8006326, 8004651, 8006839, 8007461, 8006316, 8006278, 8006330, 8006481, 8004675, 8004681, 8006461, 8004684, 8006351, 8004697, 8004714, 8006434, 8007462, 8004672, 8006332, 8006291, 8006346, 8007491, 8007640, 8006458, 8004658);

Date: 2025-01-25 19:22:27 Duration: 7ms

12

266,478

Details

45s766ms

0ms

2ms

0ms

select ? from res_groups_users_rel where uid = ? and gid in ( select res_id from ir_model_data where module = ? and name = ? and model = ?);

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 25	00	2,177	291ms	0ms
	01	2,156	298ms	0ms
	02	1,443	186ms	0ms
	03	892	108ms	0ms
	04	137	18ms	0ms
	05	609	75ms	0ms
	06	987	138ms	0ms
	07	809	113ms	0ms
	08	8,364	1s215ms	0ms
	09	14,770	2s398ms	0ms
	10	27,846	5s96ms	0ms
	11	25,313	4s695ms	0ms
	12	28,391	5s286ms	0ms
	13	22,583	3s810ms	0ms
	14	25,876	4s207ms	0ms
	15	24,042	4s413ms	0ms
	16	21,960	3s744ms	0ms
	17	19,640	3s324ms	0ms
	18	11,735	1s863ms	0ms
	19	13,820	2s382ms	0ms
	20	6,670	1s146ms	0ms
	21	4,132	636ms	0ms
	22	2,126	316ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 900 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_system' AND model = 'res.groups');

Date: 2025-01-25 21:41:03 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-25 17:22:56 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-25 15:11:42 Duration: 1ms

13

236,419

Details

54s846ms

0ms

27ms

0ms

select "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" from "policy_number" where "policy_number".id in (...);

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 25	00	2,025	504ms	0ms
	01	3,930	903ms	0ms
	02	1,800	416ms	0ms
	03	733	198ms	0ms
	04	247	98ms	0ms
	05	1,275	317ms	0ms
	06	1,541	379ms	0ms
	07	548	143ms	0ms
	08	3,536	1s173ms	0ms
	09	12,074	3s147ms	0ms
	10	17,587	4s942ms	0ms
	11	18,934	5s5ms	0ms
	12	19,487	4s953ms	0ms
	13	16,874	3s806ms	0ms
	14	27,400	4s529ms	0ms
	15	38,558	8s50ms	0ms
	16	14,980	3s162ms	0ms
	17	14,594	3s512ms	0ms
	18	11,199	2s573ms	0ms
	19	11,254	2s768ms	0ms
	20	9,696	2s354ms	0ms
	21	5,441	1s306ms	0ms
	22	2,706	596ms	0ms

SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (42163830, 42100875, 42163683, 41252068, 42163732, 42086814, 41994019, 42056011, 39567944, 42171459, 41982296, 42101805, 41460745, 42107507, 41798787, 42086830, 41949136, 42095741, 32269680, 32222309, 32255489, 42087084, 41927971, 42086653, 42086646, 32222247, 32666948, 39514016, 32657217, 32186660, 42036057, 42086667, 42086871, 41905353, 42095726, 42086727, 32231911, 42076586, 42080863, 32207344, 39774946, 32247251, 42087208, 42132025, 32222628, 41027255, 40875601, 41854112, 40253829, 32592065, 40175475, 38831300, 32660911, 40392394, 39542474, 40497042, 40105516, 42122729, 41434483, 41252399, 40380344, 39541904, 39661983, 40394440, 42171909, 40063510, 41835776, 39503524, 41928634, 39932350, 38958434, 40935821, 39766801, 40533557, 42176429, 41376103, 40756202, 39915672, 40287196, 40034786, 32579586, 42059632, 42088718, 41569416, 40759839, 40193697, 39497201, 40552924, 40382137, 39714340, 42149890, 40293824, 41119180, 41199961, 41689814, 41477280, 41378555, 42014243, 41361062, 32213286);

Date: 2025-01-25 17:21:55 Duration: 27ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (32265112, 40959639, 41527212, 41527309, 41527534, 40958681, 41527539, 40959133, 41526894, 42175301, 32653768, 32653735, 32287804, 32277548, 32277556, 42071262, 32268861, 41920178, 41978965, 32300167, 41251181, 41837752, 42079626, 32287816, 41837744, 32277261, 32290496, 32229705, 32191463, 41976572, 42160399, 42160365, 42160398, 32266974, 32230411, 32266943, 32298088, 32298116, 32298103, 32298097, 41624991, 32269718, 41523238, 42160520, 32314345, 32313678, 42080167, 32233229, 32232878, 32233159, 32233167, 32233164, 32233168, 32233200, 32232554, 32233057, 32232914, 32233123, 32233095, 32232944, 32232399, 32232614, 32298467, 32298420, 32228397, 32228321, 32228281, 32232500, 32278430, 32278434, 32232263, 42074322, 32238106, 42070359, 41480534, 32319659, 32300686, 32300679, 42131737, 41882841, 32201808, 32205536, 41934697, 41709635, 32209762, 32212585, 32212546, 42041658, 42041665, 42081594, 32256246, 32276550, 42134104, 42158437, 32261353, 32261321, 32237946, 32201498, 32201501, 42102836);

Date: 2025-01-25 17:21:54 Duration: 26ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (32647641, 41399253, 41042075, 32647636, 41421455, 41407902, 32649839, 32648325, 41457245, 41403783, 41363895, 41128725, 41403711, 41403707, 40967576, 41363847, 41403672, 41403661, 41428934, 41482916, 41483316, 40825670, 41191935, 41479059, 41408715, 41418502, 41425293, 41458111, 41345049, 40590246, 41395156, 41399487, 41424960, 41366216, 41390815, 41437328, 41437449, 41365926, 32572030, 41422700, 41399197, 41112587, 41371555, 41081014, 40974066, 32645242, 41228992, 41365285, 41305802, 41280884, 41078706, 41428217, 41464592, 40968185, 41311572, 41310507, 41310515, 41254068, 41378458, 41310208, 41193265, 41281855, 32646246, 41137227, 41183418, 41214879, 41251966, 41136132, 40929438, 41396486, 40974083, 41431451, 40972314, 40972090, 41431325, 41334773, 41342473, 41342472, 40729273, 41271419, 41474663, 41268928, 41466403, 41422553, 41265140, 41433493, 41457412, 41457465, 41457472, 41354277, 41420151, 41457407, 41389457, 41389235, 41420199, 41309161, 40974074, 40973652, 40973899, 32644667);

Date: 2025-01-25 11:54:50 Duration: 19ms

14

192,596

Details

1d7h15m52s

455ms

1s912ms

584ms

select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 25	00	6,265	56m1s	536ms
	01	8,829	1h20m58s	550ms
	02	3,334	29m23s	528ms
	03	2,821	24m29s	520ms
	04	142	1m14s	527ms
	05	2,373	22m7s	559ms
	06	2,864	24m53s	521ms
	07	1,205	10m23s	517ms
	08	3,369	29m24s	523ms
	09	12,835	2h43s	564ms
	10	16,721	2h48m24s	604ms
	11	15,918	2h32m54s	576ms
	12	13,935	2h12m33s	570ms
	13	10,572	1h38m46s	560ms
	14	7,081	1h4m46s	548ms
	15	13,845	2h17m19s	595ms
	16	8,722	1h22m48s	569ms
	17	9,114	1h32m14s	607ms
	18	11,002	1h52m49s	615ms
	19	12,851	2h14m4s	625ms
	20	10,630	1h54m44s	647ms
	21	14,589	2h29m49s	616ms
	22	3,579	34m57s	586ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4742127)) AND (("shipping_track"."id" not in (39188825, 39189042, 39189137, 39387824, 39387824)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 10:57:30 Duration: 1s912ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4775502)) AND (("shipping_track"."id" not in (39498145, 39498145)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 20:35:29 Duration: 1s160ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4775645)) AND (("shipping_track"."id" not in (39499032, 39499032)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 20:38:22 Duration: 1s109ms

15

184,571

Details

13s281ms

0ms

select "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" from "notebook_package" where "notebook_package".id in (...);

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,044	66ms	0ms
	01	1,687	117ms	0ms
	02	1,462	93ms	0ms
	03	734	47ms	0ms
	04	237	13ms	0ms
	05	360	23ms	0ms
	06	1,401	88ms	0ms
	07	475	30ms	0ms
	08	2,950	183ms	0ms
	09	10,627	747ms	0ms
	10	15,381	1s240ms	0ms
	11	16,329	1s161ms	0ms
	12	16,708	1s120ms	0ms
	13	13,608	926ms	0ms
	14	24,093	1s469ms	0ms
	15	34,384	2s568ms	0ms
	16	10,386	843ms	0ms
	17	10,124	666ms	0ms
	18	6,771	461ms	0ms
	19	6,775	535ms	0ms
	20	4,826	474ms	0ms
	21	2,538	253ms	0ms
	22	1,671	146ms	0ms

SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-01-25 16:19:36 Duration: 0ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-01-25 18:19:25 Duration: 0ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-01-25 15:56:21 Duration: 0ms

16

152,719

Details

8s664ms

0ms

1ms

0ms

select "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" from "ir_rule" where "ir_rule".id in (...);

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 25	00	880	44ms	0ms
	01	919	47ms	0ms
	02	506	24ms	0ms
	03	231	11ms	0ms
	04	49	2ms	0ms
	05	200	9ms	0ms
	06	467	24ms	0ms
	07	324	16ms	0ms
	08	3,330	171ms	0ms
	09	7,201	413ms	0ms
	10	15,601	950ms	0ms
	11	15,135	916ms	0ms
	12	18,645	1s90ms	0ms
	13	13,392	742ms	0ms
	14	14,497	766ms	0ms
	15	13,469	809ms	0ms
	16	13,404	723ms	0ms
	17	12,253	664ms	0ms
	18	6,949	365ms	0ms
	19	7,697	442ms	0ms
	20	4,317	252ms	0ms
	21	1,915	105ms	0ms
	22	1,338	68ms	0ms

SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2025-01-25 12:07:50 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (21);

Date: 2025-01-25 20:54:38 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);

Date: 2025-01-25 19:50:46 Duration: 0ms

17

147,626

Details

17s636ms

0ms

1ms

0ms

select rule_group_rel.rule_group_id, rule_group_rel.group_id from rule_group_rel, "res_groups" where ? = ? and rule_group_rel.rule_group_id in (...) and rule_group_rel.group_id = res_groups.id order by coalesce("res_groups"."name" ->> ?, "res_groups"."name" ->> ?);

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 25	00	859	91ms	0ms
	01	907	99ms	0ms
	02	478	49ms	0ms
	03	225	23ms	0ms
	04	48	5ms	0ms
	05	191	20ms	0ms
	06	454	50ms	0ms
	07	315	34ms	0ms
	08	3,254	356ms	0ms
	09	6,995	853ms	0ms
	10	15,169	1s959ms	0ms
	11	14,612	1s860ms	0ms
	12	17,977	2s196ms	0ms
	13	13,032	1s500ms	0ms
	14	14,058	1s537ms	0ms
	15	12,952	1s658ms	0ms
	16	12,984	1s479ms	0ms
	17	11,857	1s346ms	0ms
	18	6,632	735ms	0ms
	19	7,457	918ms	0ms
	20	4,033	502ms	0ms
	21	1,827	213ms	0ms
	22	1,310	143ms	0ms

SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-25 15:36:29 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-25 15:48:40 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-25 11:06:56 Duration: 0ms

18

125,947

Details

24s368ms

0ms

2ms

0ms

select res_groups_users_rel.uid, res_groups_users_rel.gid from res_groups_users_rel, "res_groups" where ? = ? and res_groups_users_rel.uid in (...) and res_groups_users_rel.gid = res_groups.id order by coalesce("res_groups"."name" ->> ?, "res_groups"."name" ->> ?);

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 25	00	751	133ms	0ms
	01	897	167ms	0ms
	02	490	86ms	0ms
	03	279	49ms	0ms
	04	42	7ms	0ms
	05	165	29ms	0ms
	06	440	81ms	0ms
	07	247	43ms	0ms
	08	2,658	483ms	0ms
	09	6,516	1s276ms	0ms
	10	13,342	2s694ms	0ms
	11	12,732	2s566ms	0ms
	12	15,460	3s4ms	0ms
	13	11,119	2s111ms	0ms
	14	11,848	2s145ms	0ms
	15	10,887	2s210ms	0ms
	16	10,567	2s5ms	0ms
	17	9,721	1s831ms	0ms
	18	5,611	1s12ms	0ms
	19	6,120	1s196ms	0ms
	20	3,405	707ms	0ms
	21	1,575	310ms	0ms
	22	1,075	212ms	0ms

SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1082) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-25 17:21:54 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (876) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-25 22:08:36 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (950) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-25 11:12:23 Duration: 1ms

19

118,623

Details

1h33m45s

36ms

323ms

47ms

select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 25	00	2,832	2m4s	44ms
	01	3,072	2m16s	44ms
	02	1,251	55s715ms	44ms
	03	820	36s784ms	44ms
	04	103	4s567ms	44ms
	05	582	25s714ms	44ms
	06	1,236	54s692ms	44ms
	07	171	7s658ms	44ms
	08	1,620	1m11s	44ms
	09	9,145	7m14s	47ms
	10	13,367	11m19s	50ms
	11	12,406	10m2s	48ms
	12	11,393	9m9s	48ms
	13	9,479	7m26s	47ms
	14	5,699	4m21s	45ms
	15	6,265	5m9s	49ms
	16	5,337	4m8s	46ms
	17	6,231	4m46s	45ms
	18	7,137	5m26s	45ms
	19	6,977	5m26s	46ms
	20	6,356	5m10s	48ms
	21	4,793	3m43s	46ms
	22	2,351	1m43s	44ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4688972, 4664561, 4656632)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 10:57:28 Duration: 323ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4742845)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 10:57:50 Duration: 208ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4723896, 4710473, 4701288, 4688846, 4688369, 4662936, 4662711)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 12:42:30 Duration: 106ms

20

117,456

Details

9s148ms

0ms

1ms

0ms

select "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" from "urgent_warehouse" where "urgent_warehouse".id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,506	83ms	0ms
	01	2,363	116ms	0ms
	02	2,006	81ms	0ms
	03	1,024	41ms	0ms
	04	261	7ms	0ms
	05	412	16ms	0ms
	06	1,377	67ms	0ms
	07	352	22ms	0ms
	08	2,446	159ms	0ms
	09	7,716	516ms	0ms
	10	12,178	1s42ms	0ms
	11	12,213	966ms	0ms
	12	13,771	1s193ms	0ms
	13	8,998	691ms	0ms
	14	9,109	715ms	0ms
	15	11,326	1s36ms	0ms
	16	7,281	595ms	0ms
	17	6,898	567ms	0ms
	18	4,494	342ms	0ms
	19	4,780	414ms	0ms
	20	3,664	268ms	0ms
	21	2,169	141ms	0ms
	22	1,112	57ms	0ms

SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107);

Date: 2025-01-25 11:12:23 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (73);

Date: 2025-01-25 10:26:23 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (18, 61, 16, 42, 14, 46, 64, 28);

Date: 2025-01-25 13:13:33 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

42m33s

1m40s

48

Details

1h20m40s

update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 25	01	2	0ms	0ms
	02	2	1ms	0ms
	04	1	1ms	1ms
	08	4	2ms	0ms
	09	5	42m33s	8m30s
	10	1	2ms	2ms
	11	8	10ms	1ms
	12	8	32m55s	4m6s
	13	2	1ms	0ms
	14	4	5m11s	1m17s
	15	1	0ms	0ms
	16	1	0ms	0ms
	17	1	1ms	1ms
	18	1	0ms	0ms
	20	3	3ms	1ms
	21	4	2ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-25 08:52:46.485077', "last_update" = '2025-01-25 08:07:46.485103', "write_date" = '2025-01-25 08:07:46.090828', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 42m33s
UPDATE "res_users" SET "exp_date" = '2025-01-25 11:24:50.759170', "last_update" = '2025-01-25 10:39:50.759192', "write_date" = '2025-01-25 10:39:50.440580', "write_uid" = 1 WHERE id IN (959);

Date: 2025-01-25 12:07:20 Duration: 27m30s
UPDATE "res_users" SET "exp_date" = '2025-01-25 14:32:09.404985', "last_update" = '2025-01-25 13:47:09.405007', "write_date" = '2025-01-25 13:47:09.070541', "write_uid" = 959 WHERE id IN (959);

Date: 2025-01-25 14:52:20 Duration: 5m11s

2

0ms

34m3s

1m34s

341

Details

8h56m46s

update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 25	00	3	0ms	0ms
	01	2	1ms	0ms
	02	1	0ms	0ms
	03	2	0ms	0ms
	05	1	0ms	0ms
	06	1	0ms	0ms
	07	2	0ms	0ms
	08	14	5ms	0ms
	09	51	5h5m35s	5m59s
	10	50	1h19m10s	1m35s
	11	29	11m57s	24s748ms
	12	19	4m39s	14s705ms
	13	24	45m27s	1m53s
	14	26	9m58s	23s37ms
	15	12	12m48s	1m4s
	16	25	8m36s	20s664ms
	17	32	58m30s	1m49s
	18	16	6ms	0ms
	19	13	19ms	1ms
	20	6	3ms	0ms
	21	8	2ms	0ms
	22	4	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-25 09:01:16.862215', "last_update" = '2025-01-25 08:16:16.862238', "sid" = 'd3224b87962030c58f0d1d2816363c040e44a24b', "write_date" = '2025-01-25 08:16:16.527892', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 34m3s
UPDATE "res_users" SET "exp_date" = '2025-01-25 09:03:18.594091', "last_update" = '2025-01-25 08:18:18.594113', "sid" = 'd3224b87962030c58f0d1d2816363c040e44a24b', "write_date" = '2025-01-25 08:18:18.273980', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 32m1s
UPDATE "res_users" SET "exp_date" = '2025-01-25 09:03:26.809548', "last_update" = '2025-01-25 08:18:26.809570', "sid" = 'd3224b87962030c58f0d1d2816363c040e44a24b', "write_date" = '2025-01-25 08:18:26.490517', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-25 09:50:20 Duration: 31m53s

3

0ms

59m59s

4s998ms

58,394

Details

3d9h4m30s

update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 25	00	579	126ms	0ms
	01	970	214ms	0ms
	02	611	128ms	0ms
	03	414	88ms	0ms
	04	71	15ms	0ms
	05	169	35ms	0ms
	06	376	83ms	0ms
	07	212	46ms	0ms
	08	1,149	46s822ms	40ms
	09	3,627	6h34m3s	6s518ms
	10	6,108	10h57m2s	6s454ms
	11	6,494	4h46m35s	2s647ms
	12	6,612	14h2m13s	7s642ms
	13	5,432	10h42m50s	7s100ms
	14	4,882	11h38m29s	8s584ms
	15	4,773	5h55m44s	4s471ms
	16	3,879	5h59m26s	5s559ms
	17	3,491	3h49m43s	3s948ms
	18	2,465	59m33s	1s449ms
	19	2,486	4h38m	6s709ms
	20	1,761	439ms	0ms
	21	1,063	59m59s	3s386ms
	22	770	180ms	0ms

update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-25 19:49:04.407158', exp_date = '2025-01-25 20:34:04.407160', logged_in = 'TRUE' where id = 870;

Date: 2025-01-25 21:49:03 Duration: 59m59s
update res_users set sid = '7c3e3c874e7d4fa7a8ab32372ccdbca4af2224f6', last_update = '2025-01-25 16:50:52.137009', exp_date = '2025-01-25 17:35:52.137013', logged_in = 'TRUE' where id = 1229;

Date: 2025-01-25 18:50:22 Duration: 59m30s
update res_users set sid = 'e338a6487a430bdd925e43904d215aa63f4bf3bd', last_update = '2025-01-25 17:30:24.372809', exp_date = '2025-01-25 18:15:24.372811', logged_in = 'TRUE' where id = 823;

Date: 2025-01-25 19:22:21 Duration: 51m56s

4

28ms

4s213ms

2s767ms

212

Details

9m46s

select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 25	00	5	14s846ms	2s969ms
	09	5	16s247ms	3s249ms
	10	4	13s389ms	3s347ms
	11	7	12s666ms	1s809ms
	12	6	23s796ms	3s966ms
	13	16	19s998ms	1s249ms
	14	12	27s748ms	2s312ms
	15	9	29s107ms	3s234ms
	16	45	2m5s	2s791ms
	17	13	40s438ms	3s110ms
	18	16	49s17ms	3s63ms
	19	11	36s841ms	3s349ms
	20	44	2m2s	2s777ms
	21	1	3s530ms	3s530ms
	22	18	51s346ms	2s852ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))))))) AND ("policy_number"."name"::text ilike '%9911030%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-25 12:42:37 Duration: 4s213ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))))) AND ("policy_number"."name"::text ilike '%486433%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-25 12:30:38 Duration: 4s136ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))))) AND ("policy_number"."name"::text ilike '%6%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-25 14:59:52 Duration: 4s12ms

5

227ms

1s409ms

877ms

8,419

Details

2h3m5s

select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 25	00	317	4m41s	887ms
	01	249	3m48s	918ms
	08	3	2s558ms	852ms
	09	1	868ms	868ms
	10	2	2s352ms	1s176ms
	11	11	9s962ms	905ms
	13	242	3m50s	954ms
	14	111	1m46s	962ms
	15	501	8m12s	983ms
	16	645	10m1s	933ms
	17	1,242	19m15s	929ms
	18	956	14m29s	909ms
	19	1,656	24m34s	890ms
	20	1,399	16m55s	725ms
	21	700	9m49s	842ms
	22	384	5m22s	838ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9991061')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:35:50 Duration: 1s409ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '58845')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:35:15 Duration: 1s387ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '58849')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:35:18 Duration: 1s369ms

6

457ms

2s986ms

587ms

39,765

Details

6h29m26s

select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 25	00	125	1m16s	608ms
	01	752	6m56s	554ms
	02	203	1m58s	583ms
	03	94	55s851ms	594ms
	04	9	5s334ms	592ms
	05	26	15s541ms	597ms
	06	144	1m22s	574ms
	07	128	1m6s	522ms
	08	701	6m15s	535ms
	09	3,540	33m54s	574ms
	10	4,002	40m47s	611ms
	11	4,325	42m47s	593ms
	12	4,229	41m18s	585ms
	13	3,512	33m27s	571ms
	14	2,930	27m4s	554ms
	15	3,172	31m23s	593ms
	16	2,439	22m55s	563ms
	17	2,231	21m45s	585ms
	18	2,080	20m46s	599ms
	19	2,502	25m36s	614ms
	20	1,752	18m23s	629ms
	21	700	7m21s	630ms
	22	169	1m41s	600ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4669388)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 10:57:27 Duration: 2s986ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4718058)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 10:57:30 Duration: 1s933ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4711976)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 17:21:56 Duration: 1s751ms

7

455ms

1s912ms

584ms

192,596

Details

1d7h15m52s

select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 25	00	6,265	56m1s	536ms
	01	8,829	1h20m58s	550ms
	02	3,334	29m23s	528ms
	03	2,821	24m29s	520ms
	04	142	1m14s	527ms
	05	2,373	22m7s	559ms
	06	2,864	24m53s	521ms
	07	1,205	10m23s	517ms
	08	3,369	29m24s	523ms
	09	12,835	2h43s	564ms
	10	16,721	2h48m24s	604ms
	11	15,918	2h32m54s	576ms
	12	13,935	2h12m33s	570ms
	13	10,572	1h38m46s	560ms
	14	7,081	1h4m46s	548ms
	15	13,845	2h17m19s	595ms
	16	8,722	1h22m48s	569ms
	17	9,114	1h32m14s	607ms
	18	11,002	1h52m49s	615ms
	19	12,851	2h14m4s	625ms
	20	10,630	1h54m44s	647ms
	21	14,589	2h29m49s	616ms
	22	3,579	34m57s	586ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4742127)) AND (("shipping_track"."id" not in (39188825, 39189042, 39189137, 39387824, 39387824)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 10:57:30 Duration: 1s912ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4775502)) AND (("shipping_track"."id" not in (39498145, 39498145)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 20:35:29 Duration: 1s160ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4775645)) AND (("shipping_track"."id" not in (39499032, 39499032)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-25 20:38:22 Duration: 1s109ms

8

347ms

749ms

464ms

2,552

Details

19m45s

select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) order by "cash_policy"."id" desc;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 25	09	390	3m11s	490ms
	10	349	2m49s	484ms
	11	233	1m48s	465ms
	12	419	3m21s	481ms
	13	815	5m58s	439ms
	14	319	2m23s	449ms
	15	10	4s432ms	443ms
	16	17	8s162ms	480ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9916610')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-25 10:34:10 Duration: 749ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '239')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-25 10:34:13 Duration: 715ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '477454')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-25 10:33:52 Duration: 702ms

9

193ms

581ms

283ms

12,253

Details

57m52s

select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 25	08	125	34s910ms	279ms
	09	1,667	7m41s	276ms
	10	1,619	7m39s	283ms
	11	987	5m4s	308ms
	12	321	1m30s	283ms
	13	1,081	5m14s	290ms
	14	1,574	7m4s	269ms
	15	1,464	7m11s	294ms
	16	1,614	7m24s	275ms
	17	847	3m45s	265ms
	18	335	1m47s	320ms
	19	619	2m54s	281ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9248780')))) ORDER BY "collection_policy"."id";

Date: 2025-01-25 11:16:48 Duration: 581ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '473501')))) ORDER BY "collection_policy"."id";

Date: 2025-01-25 11:16:40 Duration: 563ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9190418')))) ORDER BY "collection_policy"."id";

Date: 2025-01-25 11:16:47 Duration: 562ms

10

221ms

479ms

270ms

16,385

Details

1h13m58s

select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 25	00	650	2m55s	269ms
	01	1,900	8m23s	265ms
	02	315	1m22s	261ms
	05	919	3m53s	253ms
	06	72	18s389ms	255ms
	08	31	7s553ms	243ms
	09	77	20s606ms	267ms
	10	169	52s792ms	312ms
	11	107	31s13ms	289ms
	12	133	38s493ms	289ms
	13	98	27s916ms	284ms
	14	357	1m36s	271ms
	15	456	2m17s	300ms
	16	977	4m27s	273ms
	17	1,569	7m3s	269ms
	18	2,421	10m45s	266ms
	19	1,791	8m9s	273ms
	20	1,940	9m	278ms
	21	1,882	8m33s	273ms
	22	521	2m13s	256ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9855950')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:36:36 Duration: 479ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9354192')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:38:22 Duration: 461ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9842452')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-25 20:37:56 Duration: 460ms

11

14ms

892ms

254ms

2,302

Details

9m46s

select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 25	00	3	965ms	321ms
	01	4	960ms	240ms
	06	1	165ms	165ms
	07	4	227ms	56ms
	08	38	5s714ms	150ms
	09	136	29s980ms	220ms
	10	165	43s994ms	266ms
	11	233	56s864ms	244ms
	12	341	1m19s	232ms
	13	303	1m26s	286ms
	14	251	1m6s	264ms
	15	264	1m7s	253ms
	16	197	43s303ms	219ms
	17	127	34s510ms	271ms
	18	95	30s893ms	325ms
	19	52	14s964ms	287ms
	20	55	18s788ms	341ms
	21	18	2s657ms	147ms
	22	15	3s539ms	235ms

SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-25 13:05:57 Duration: 892ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-25 13:05:57 Duration: 875ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-25 13:05:57 Duration: 872ms

12

200ms

408ms

240ms

2,726

Details

10m56s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 25	00	120	26s578ms	221ms
	01	120	27s135ms	226ms
	02	120	26s612ms	221ms
	03	120	26s563ms	221ms
	04	120	26s576ms	221ms
	05	120	26s478ms	220ms
	06	120	26s488ms	220ms
	07	120	26s495ms	220ms
	08	120	26s484ms	220ms
	09	120	28s359ms	236ms
	10	120	29s882ms	249ms
	11	120	29s543ms	246ms
	12	120	28s481ms	237ms
	13	120	28s237ms	235ms
	14	120	27s546ms	229ms
	15	120	29s158ms	242ms
	16	120	27s843ms	232ms
	17	116	30s95ms	259ms
	18	120	32s771ms	273ms
	19	120	33s699ms	280ms
	20	120	34s208ms	285ms
	21	120	33s450ms	278ms
	22	90	23s367ms	259ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-25 20:51:01 Duration: 408ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-25 20:37:02 Duration: 407ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-25 20:35:02 Duration: 397ms

13

91ms

916ms

237ms

48,971

Details

3h14m11s

select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,909	5m53s	185ms
	01	4,246	15m33s	219ms
	02	614	2m7s	207ms
	05	1,822	7m5s	233ms
	06	122	29s402ms	241ms
	08	44	5s439ms	123ms
	09	140	27s203ms	194ms
	10	324	1m20s	249ms
	11	234	1m1s	263ms
	12	260	56s704ms	218ms
	13	664	2m21s	213ms
	14	910	3m55s	259ms
	15	1,881	8m27s	269ms
	16	3,187	12m43s	239ms
	17	5,571	22m5s	237ms
	18	6,692	27m31s	246ms
	19	6,821	28m21s	249ms
	20	6,620	27m20s	247ms
	21	5,104	20m6s	236ms
	22	1,806	6m17s	208ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-25 19:38:01 Duration: 916ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسين')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-25 19:38:01 Duration: 847ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محل')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-25 16:04:46 Duration: 847ms

14

173ms

400ms

222ms

84,083

Details

5h11m20s

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,053	3m26s	196ms
	01	1,373	4m33s	199ms
	02	539	1m46s	197ms
	03	940	3m5s	196ms
	04	90	17s878ms	198ms
	05	1,103	3m36s	196ms
	06	902	2m57s	197ms
	07	803	2m39s	198ms
	08	1,760	5m52s	200ms
	09	9,987	35m20s	212ms
	10	7,096	26m33s	224ms
	11	4,247	15m34s	219ms
	12	2,474	8m51s	214ms
	13	3,310	11m34s	209ms
	14	3,285	11m16s	205ms
	15	14,133	53m17s	226ms
	16	6,317	22m27s	213ms
	17	1,963	6m36s	202ms
	18	1,999	7m8s	214ms
	19	4,555	16m47s	221ms
	20	15,228	1h4m34s	254ms
	21	602	1m59s	198ms
	22	324	1m2s	192ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9982578')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 15:11:36 Duration: 400ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '110009')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 20:37:56 Duration: 377ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9626747')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 20:35:21 Duration: 370ms

15

173ms

360ms

210ms

14,555

Details

51m7s

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 25	00	23	4s446ms	193ms
	02	10	1s965ms	196ms
	03	53	10s435ms	196ms
	04	90	17s854ms	198ms
	05	747	2m26s	196ms
	06	902	2m58s	197ms
	07	803	2m39s	198ms
	08	1,026	3m24s	199ms
	09	2,243	7m51s	210ms
	10	1,869	7m5s	227ms
	11	1,166	4m16s	220ms
	12	1,152	4m8s	215ms
	13	802	2m47s	209ms
	14	448	1m32s	206ms
	15	311	1m9s	222ms
	16	341	1m11s	210ms
	17	233	48s701ms	209ms
	18	1,025	3m38s	212ms
	19	507	1m47s	212ms
	20	356	1m17s	218ms
	21	232	47s775ms	205ms
	22	216	41s661ms	192ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9926632')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 10:57:20 Duration: 360ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9963921')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 10:47:29 Duration: 355ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '14567')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 10:57:49 Duration: 351ms

16

159ms

233ms

196ms

3,802

Details

12m28s

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1,030	3m22s	196ms
	01	1,374	4m32s	198ms
	02	503	1m38s	195ms
	03	869	2m50s	196ms
	22	26	5s80ms	195ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9967589')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 01:29:39 Duration: 233ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9558641')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 01:35:01 Duration: 227ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9795070')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-25 01:30:51 Duration: 227ms

17

120ms

308ms

144ms

6,622

Details

15m55s

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) 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)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 25	00	10	1s313ms	131ms
	01	40	5s337ms	133ms
	06	5	657ms	131ms
	08	10	1s323ms	132ms
	09	604	1m27s	144ms
	10	1,082	2m43s	150ms
	11	1,284	3m8s	146ms
	12	1,240	2m58s	144ms
	13	1,069	2m27s	138ms
	14	268	37s32ms	138ms
	15	338	49s176ms	145ms
	16	131	18s337ms	139ms
	17	186	25s766ms	138ms
	18	100	13s860ms	138ms
	19	41	5s938ms	144ms
	20	74	11s233ms	151ms
	21	73	10s278ms	140ms
	22	67	8s908ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-25 10:57:25 Duration: 308ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-25 10:57:50 Duration: 277ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) 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)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-25 20:35:02 Duration: 274ms

18

94ms

307ms

118ms

16,622

Details

32m43s

select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 25	00	8	892ms	111ms
	01	79	9s107ms	115ms
	02	12	1s391ms	115ms
	07	3	328ms	109ms
	08	153	17s282ms	112ms
	09	819	1m40s	122ms
	10	1,536	3m9s	123ms
	11	1,526	3m	118ms
	12	1,800	3m30s	116ms
	13	1,652	3m8s	114ms
	14	1,361	2m33s	112ms
	15	3,180	6m21s	120ms
	16	1,719	3m14s	113ms
	17	715	1m23s	116ms
	18	490	58s139ms	118ms
	19	607	1m14s	122ms
	20	796	1m40s	126ms
	21	137	15s966ms	116ms
	22	29	3s269ms	112ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8036183)) AND (("cash_track"."id" not in (7342053)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-25 17:23:04 Duration: 307ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8033875)) AND (("cash_track"."id" not in (7327321)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-25 10:57:33 Duration: 234ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8033868)) AND (("cash_track"."id" not in (7327314)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-25 10:57:20 Duration: 208ms

19

44ms

98ms

57ms

18,783

Details

17m53s

select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 25	00	1	54ms	54ms
	07	3	164ms	54ms
	08	159	8s407ms	52ms
	09	1,864	1m43s	55ms
	10	2,927	2m59s	61ms
	11	1,365	1m18s	57ms
	12	668	37s604ms	56ms
	13	1,782	1m38s	55ms
	14	2,002	1m48s	54ms
	15	3,093	3m4s	59ms
	16	1,604	1m28s	55ms
	17	847	46s99ms	54ms
	18	1,114	1m1s	54ms
	19	1,299	1m14s	57ms
	20	52	3s173ms	61ms
	21	3	173ms	57ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4649299) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-25 10:57:31 Duration: 98ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4576141) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-25 10:33:52 Duration: 95ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2254771) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-25 20:35:50 Duration: 95ms

20

36ms

323ms

47ms

118,623

Details

1h33m45s

select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 25	00	2,832	2m4s	44ms
	01	3,072	2m16s	44ms
	02	1,251	55s715ms	44ms
	03	820	36s784ms	44ms
	04	103	4s567ms	44ms
	05	582	25s714ms	44ms
	06	1,236	54s692ms	44ms
	07	171	7s658ms	44ms
	08	1,620	1m11s	44ms
	09	9,145	7m14s	47ms
	10	13,367	11m19s	50ms
	11	12,406	10m2s	48ms
	12	11,393	9m9s	48ms
	13	9,479	7m26s	47ms
	14	5,699	4m21s	45ms
	15	6,265	5m9s	49ms
	16	5,337	4m8s	46ms
	17	6,231	4m46s	45ms
	18	7,137	5m26s	45ms
	19	6,977	5m26s	46ms
	20	6,356	5m10s	48ms
	21	4,793	3m43s	46ms
	22	2,351	1m43s	44ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4688972, 4664561, 4656632)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 10:57:28 Duration: 323ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4742845)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 10:57:50 Duration: 208ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4723896, 4710473, 4701288, 4688846, 4688369, 4662936, 4662711)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-25 12:42:30 Duration: 106ms

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

16,719,124 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	9	0.00%
DETAIL	20,339	0.12%
ERROR	2,582	0.02%
EVENTLOG	1,154	0.01%
FATAL	21,185	0.13%
HINT	4	0.00%
LOG	16,671,243	99.71%
STATEMENT	2,608	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
21185 FATAL entries
2582 ERROR entries
0 WARNING entries
1154 EVENTLOG entries

Most Frequent Errors/Events

Key values

20,326 Max number of times the same event was reported
24,921 Total events found

Rank

Times reported

Error

1

20,326

Details

FATAL: password authentication failed for user "..."

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 25	01	305
	02	1,340
	03	1,591
	04	1,735
	05	1,960
	06	3,073
	07	2,854
	08	1,675
	09	1,943
	10	1,990
	11	1,857
	15	3

FATAL: password authentication failed for user "postgres"

2

1,343

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 25	00	12
	01	4
	02	5
	03	1
	05	2
	06	3
	07	5
	08	31
	09	93
	10	137
	11	120
	12	130
	13	111
	14	93
	15	165
	16	131
	17	72
	18	85
	19	50
	20	51
	21	31
	22	11

ERROR: could not serialize access due to concurrent update
ERROR: could not serialize access due to concurrent update
ERROR: could not serialize access due to concurrent update

3

1,207

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 25	00	11
	01	3
	02	4
	05	2
	06	3
	07	5
	08	26
	09	76
	10	126
	11	112
	12	125
	13	107
	14	90
	15	131
	16	117
	17	69
	18	73
	19	47
	20	40
	21	29
	22	11

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

4

719

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 25	09	31
	10	123
	11	92
	12	112
	13	80
	14	98
	15	54
	16	47
	17	53
	19	29

5

719

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 25	09	31
	10	123
	11	92
	12	112
	13	80
	14	98
	15	54
	16	47
	17	53
	19	29

6

304

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 25	09	23
	10	49
	11	37
	12	53
	13	22
	14	67
	15	12
	16	10
	17	22
	18	3
	19	5
	21	1

7

130

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 25	09	1
	10	19
	11	20
	12	27
	13	8
	14	39
	15	4
	16	4
	17	6
	19	2

8

85

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 25	17	85

FATAL: terminating connection due to administrator command
FATAL: terminating connection due to administrator command
FATAL: terminating connection due to administrator command

9

17

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 25	17	17

10

16

Details

FATAL: terminating background worker "..." due to administrator command

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 25	17	16

FATAL: terminating background worker "parallel worker" due to administrator command
FATAL: terminating background worker "parallel worker" due to administrator command
FATAL: terminating background worker "parallel worker" due to administrator command

11

15

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 25	09	1
	10	3
	11	6
	15	1
	16	4

ERROR: syntax error at or near ")" at character 162
ERROR: syntax error at or near ")" at character 163
ERROR: syntax error at or near ")" at character 161

12

8

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 25	11	1
	15	5
	16	2

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

13

4

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 25	15	1
	19	2
	20	1

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

14

4

Details

FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 25	02	1
	15	2
	21	1

15

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 25	02	1
	15	2
	21	1

16

4

Details

FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 25	02	1
	15	2
	21	1

17

3

Details

ERROR: terminating background worker "..." due to administrator command

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 25	17	3

ERROR: terminating background worker "parallel worker" due to administrator command
ERROR: terminating background worker "parallel worker" due to administrator command
ERROR: terminating background worker "parallel worker" due to administrator command

18

3

Details

FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 25	14	1
	16	1
	19	1

19

3

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 25	08	3

20

2

Details

FATAL: unsupported frontend protocol 1234.5632: server supports 3.0 to 3.0

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 25	01	1
	06	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 25	16	1

ERROR: duplicate key value violates unique constraint "res_country_state_name_code_uniq"

22

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 25	17	1

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 25	17	1

24

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Jan 25	13	1

ERROR: could not serialize access due to concurrent delete

25

1

Details

FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Jan 25	03	1

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

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

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)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

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