pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Dec 9 23:48:01 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 73,950,662 log entries in 3m
Log start from 2024-12-09 00:00:00 to 2024-12-09 22:45:01

Global Stats

22,007 Number of unique normalized queries
21,603,632 Number of queries
6d18h25m8s Total query duration
2024-12-09 00:00:00 First query
2024-12-09 22:45:01 Last query
7,494 queries/s at 2024-12-09 10:15:12 Query peak

6d18h25m8s Total query duration
1s65ms Prepare/parse total duration
44s665ms Bind total duration
6d18h24m22s Execute total duration

32,651 Number of events
28 Number of unique normalized events
20,024 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
21,603,632 Average queries per session
6d18h25m8s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

7,494 queries/s Query Peak
2024-12-09 10:15:12 Date

SELECT Traffic

Key values

5,331 queries/s Query Peak
2024-12-09 10:15:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,841 queries/s Query Peak
2024-12-09 10:40:23 Date

Queries duration

Key values

6d18h25m8s 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)
Dec 09	00	381,611	0ms	19m11s	14ms	2m20s	2m42s	20m12s
	01	340,323	0ms	59m23s	19ms	2m4s	2m18s	59m42s
	02	295,554	0ms	59m59s	26ms	2m29s	3m6s	1h52s
	03	279,624	0ms	1m31s	16ms	2m40s	2m44s	3m22s
	04	270,580	0ms	30s508ms	15ms	2m31s	3m13s	3m50s
	05	247,812	0ms	4s132ms	11ms	1m47s	2m3s	2m28s
	06	358,702	0ms	4s280ms	11ms	1m57s	2m2s	2m50s
	07	325,666	0ms	4s400ms	11ms	2m2s	2m28s	3m13s
	08	608,493	0ms	28s752ms	7ms	2m18s	2m36s	2m53s
	09	1,246,192	0ms	25m2s	28ms	4m54s	5m18s	4h42m35s
	10	1,661,544	0ms	16m20s	19ms	6m35s	7m44s	3h59m43s
	11	1,991,862	0ms	26m45s	26ms	8m22s	1h20m37s	6h10m28s
	12	1,777,540	0ms	28m48s	33ms	7m13s	3h39m50s	5h43m41s
	13	1,700,823	0ms	32m8s	24ms	6m8s	6m59s	7h44m39s
	14	1,588,378	0ms	20m19s	23ms	22m46s	46m55s	2h59m2s
	15	1,536,310	0ms	43m56s	33ms	6m19s	49m21s	7h51m25s
	16	1,416,209	0ms	3m8s	11ms	6m29s	7m37s	10m2s
	17	1,341,318	0ms	12m41s	29ms	44m40s	51m55s	2h5m37s
	18	1,192,803	0ms	17m21s	30ms	10m39s	50m43s	1h41m51s
	19	982,920	0ms	6m7s	23ms	9m52s	14m45s	25m59s
	20	984,522	0ms	27m29s	44ms	11m2s	13m3s	4h58m24s
	21	665,353	0ms	24m17s	49ms	11m44s	20m53s	4h11m12s
	22	409,493	0ms	36m16s	84ms	5m59s	6m17s	7h14m8s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 09	00	231,269	18ms	1m51s	2m14s	2m41s
	01	204,559	14ms	1m1s	1m34s	2m18s
	02	177,167	23ms	1m50s	2m15s	3m6s
	03	168,948	26ms	1m41s	2m23s	2m44s
	04	164,820	25ms	1m48s	2m30s	3m21s
	05	150,327	19ms	1m17s	1m47s	2m19s
	06	230,318	17ms	1m38s	1m57s	2m49s
	07	212,275	17ms	1m34s	2m1s	2m50s
	08	379,948	12ms	1m57s	2m17s	2m35s
	09	776,298	11ms	3m17s	3m40s	5m17s
	10	1,031,690	12ms	4m37s	6m	7m26s
	11	1,246,370	10ms	5m11s	5m39s	7m18s
	12	1,081,035	12ms	4m43s	5m36s	7m14s
	13	1,026,307	13ms	4m53s	5m33s	6m14s
	14	971,921	12ms	4m29s	5m13s	6m18s
	15	929,813	13ms	4m53s	5m37s	6m18s
	16	846,153	18ms	5m47s	6m26s	7m7s
	17	851,671	19ms	6m38s	7m37s	8m50s
	18	745,028	29ms	8m12s	9m5s	10m37s
	19	610,586	34ms	6m43s	7m53s	14m44s
	20	606,198	40ms	8m34s	10m21s	11m14s
	21	414,761	43ms	7m14s	11m30s	18m22s
	22	259,668	33ms	4m32s	5m34s	8m16s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 09	00	23,641	5,827	137	0	39ms	141ms	188ms	340ms
	01	12,994	3,804	144	2	210ms	76ms	104ms	318ms
	02	16,393	4,715	136	0	169ms	111ms	141ms	228ms
	03	18,738	5,456	131	0	4ms	107ms	142ms	225ms
	04	17,019	4,268	123	0	1ms	93ms	142ms	237ms
	05	9,703	3,224	151	0	0ms	72ms	93ms	134ms
	06	17,200	4,047	145	0	0ms	103ms	125ms	172ms
	07	16,939	4,588	222	0	0ms	102ms	145ms	214ms
	08	18,984	7,175	361	0	1ms	116ms	148ms	180ms
	09	43,797	16,176	631	0	437ms	278ms	330ms	18s4ms
	10	72,016	21,885	885	0	197ms	386ms	504ms	822ms
	11	76,947	23,722	896	0	385ms	451ms	592ms	1h18m33s
	12	72,299	24,114	893	0	481ms	412ms	498ms	3h37m32s
	13	67,081	24,316	885	0	304ms	368ms	426ms	1m50s
	14	57,306	21,979	704	0	323ms	360ms	520ms	45m15s
	15	72,426	25,065	738	0	401ms	378ms	544ms	46m19s
	16	74,190	25,384	855	0	4ms	418ms	487ms	25s333ms
	17	67,366	22,841	759	0	260ms	563ms	829ms	50m1s
	18	78,677	22,441	663	0	146ms	656ms	7s143ms	47m5s
	19	72,687	26,259	890	0	21ms	492ms	613ms	4m47s
	20	97,815	24,117	632	0	161ms	673ms	1s43ms	2m12s
	21	55,445	20,065	301	0	201ms	366ms	529ms	43s839ms
	22	33,507	7,444	198	0	634ms	276ms	354ms	1m22s

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 09	00	118	61,228	518.88	0.04%
	01	118	61,228	518.88	0.04%
	02	118	61,228	518.88	0.05%
	03	118	61,228	518.88	0.05%
	04	118	61,228	518.88	0.05%
	05	118	61,228	518.88	0.05%
	06	118	61,228	518.88	0.04%
	07	118	61,228	518.88	0.04%
	08	118	61,228	518.88	0.02%
	09	118	61,228	518.88	0.01%
	10	118	61,228	518.88	0.01%
	11	118	61,228	518.88	0.01%
	12	118	61,228	518.88	0.01%
	13	118	61,228	518.88	0.01%
	14	118	61,228	518.88	0.01%
	15	118	61,228	518.88	0.01%
	16	118	61,228	518.88	0.01%
	17	121	59,242	489.60	0.01%
	18	118	61,228	518.88	0.01%
	19	118	61,228	518.88	0.01%
	20	118	61,228	518.88	0.01%
	21	118	61,228	518.88	0.02%
	22	97	45,954	473.75	0.03%

Day	Hour	Average / Second
Dec 09	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
Dec 09	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

226,192 buffers Checkpoint Peak
2024-12-09 07:46:31 Date
270.056 seconds Highest write time
0.014 seconds Sync time

Checkpoints Wal files

Key values

98 files Wal files usage Peak
2024-12-09 07:46:31 Date

Checkpoints distance

Key values

3,107.51 Mo Distance Peak
2024-12-09 07:46:31 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 09	00	147,095	3,125.514s	0.036s	3,125.599s
	01	115,060	3,239.529s	0.032s	3,239.601s
	02	113,120	3,239.572s	0.034s	3,239.643s
	03	86,908	3,239.57s	0.033s	3,239.64s
	04	94,839	3,239.642s	0.032s	3,239.716s
	05	104,055	3,239.579s	0.03s	3,239.644s
	06	78,739	3,080.533s	0.027s	3,080.598s
	07	323,838	3,239.58s	0.041s	3,239.679s
	08	132,793	3,239.612s	0.036s	3,239.686s
	09	305,699	3,239.518s	0.043s	3,239.626s
	10	498,144	3,239.598s	0.062s	3,239.736s
	11	524,443	3,239.493s	0.049s	3,239.617s
	12	576,668	3,239.57s	0.059s	3,239.722s
	13	509,059	3,239.479s	0.052s	3,239.609s
	14	420,988	3,239.589s	0.048s	3,239.709s
	15	439,729	3,239.496s	0.048s	3,239.621s
	16	460,453	3,239.553s	0.053s	3,239.682s
	17	339,315	2,880.469s	0.067s	2,880.608s
	18	372,034	3,239.493s	0.049s	3,239.62s
	19	278,623	3,239.576s	0.048s	3,239.682s
	20	316,386	3,239.601s	0.071s	3,239.737s
	21	232,800	3,239.56s	0.043s	3,239.661s
	22	161,307	2,429.617s	0.027s	2,429.696s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Dec 09	00	61	4,087	0.002s	0.012s
	01	49	3,639	0.002s	0.012s
	02	51	3,595	0.002s	0.012s
	03	39	3,320	0.002s	0.012s
	04	43	3,440	0.002s	0.012s
	05	46	3,467	0.002s	0.012s
	06	35	3,441	0.002s	0.012s
	07	136	3,602	0.002s	0.012s
	08	44	4,169	0.002s	0.012s
	09	110	5,011	0.002s	0.012s
	10	186	5,320	0.002s	0.012s
	11	195	5,422	0.003s	0.012s
	12	225	5,368	0.003s	0.012s
	13	197	5,494	0.003s	0.012s
	14	168	5,380	0.003s	0.012s
	15	171	5,549	0.002s	0.012s
	16	190	5,738	0.003s	0.012s
	17	137	5,507	0.010s	0.012s
	18	157	5,529	0.002s	0.012s
	19	116	5,282	0.002s	0.012s
	20	137	5,380	0.003s	0.012s
	21	101	4,834	0.002s	0.012s
	22	68	3,361	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 09	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
Dec 09	00	84,224.42 kB	118,286.25 kB
	01	66,895.50 kB	124,250.75 kB
	02	68,821.75 kB	120,080.08 kB
	03	53,505.67 kB	81,910.42 kB
	04	58,309.58 kB	81,389.33 kB
	05	64,490.09 kB	95,232.27 kB
	06	48,095.25 kB	75,844.08 kB
	07	185,708.08 kB	421,689.50 kB
	08	60,332.75 kB	724,155.17 kB
	09	146,256.80 kB	297,442.00 kB
	10	253,981.25 kB	295,558.92 kB
	11	266,531.17 kB	346,686.25 kB
	12	307,825.75 kB	352,298.08 kB
	13	268,253.67 kB	313,272.08 kB
	14	228,916.67 kB	295,465.33 kB
	15	234,078.25 kB	281,905.33 kB
	16	259,518.42 kB	322,522.50 kB
	17	187,566.67 kB	227,766.33 kB
	18	213,602.00 kB	276,463.42 kB
	19	158,210.58 kB	213,074.25 kB
	20	187,422.58 kB	226,943.83 kB
	21	137,598.42 kB	194,334.83 kB
	22	123,834.44 kB	178,630.56 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

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
Dec 09	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
Dec 09	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

13,317,130 Total read queries
5,676,267 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	13,317,130	61.64%
INSERT	1,093,170	5.06%
UPDATE	348,912	1.62%
DELETE	11,480	0.05%
COPY FROM	2	0.00%
COPY TO	0	0.00%
CTE	115,116	0.53%
DDL	2,720	0.01%
TCL	4,104,867	19.00%
CURSOR	0	0.00%
OTHERS	2,610,235	12.08%

Queries by database

Key values

unknown Main database
21,603,632 Requests
6d18h24m22s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	21,603,632	6d18h24m22s
	copy from	2	9ms
	cte	115,116	1m3s
	ddl	2,720	5s22ms
	delete	11,480	7m43s
	insert	1,093,170	5m32s
	others	2,610,233	2m2s
	select	13,317,130	2d21h8m49s
	tcl	4,104,867	2m45s
	update	348,912	3d20h56m20s

Queries by user

Key values

unknown Main user
21,603,632 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	21,603,632	6d18h24m22s
	copy from	2	9ms
	cte	115,116	1m3s
	ddl	2,720	5s22ms
	delete	11,480	7m43s
	insert	1,093,170	5m32s
	others	2,610,233	2m2s
	select	13,317,130	2d21h8m49s
	tcl	4,104,867	2m45s
	update	348,912	3d20h56m20s

Duration by user

Key values

6d18h24m22s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	21,603,632	6d18h24m22s
	copy from	2	9ms
	cte	115,116	1m3s
	ddl	2,720	5s22ms
	delete	11,480	7m43s
	insert	1,093,170	5m32s
	others	2,610,233	2m2s
	select	13,317,130	2d21h8m49s
	tcl	4,104,867	2m45s
	update	348,912	3d20h56m20s

Queries by host

Key values

unknown Main host
21,603,632 Requests
6d18h24m22s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	21,603,632	6d18h24m22s
	copy from	2	9ms
	cte	115,116	1m3s
	ddl	2,720	5s22ms
	delete	11,480	7m43s
	insert	1,093,170	5m32s
	others	2,610,233	2m2s
	select	13,317,130	2d21h8m49s
	tcl	4,104,867	2m45s
	update	348,912	3d20h56m20s

Queries by application

Key values

unknown Main application
21,603,632 Requests
6d18h24m22s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	21,603,632	6d18h24m22s
	copy from	2	9ms
	cte	115,116	1m3s
	ddl	2,720	5s22ms
	delete	11,480	7m43s
	insert	1,093,170	5m32s
	others	2,610,233	2m2s
	select	13,317,130	2d21h8m49s
	tcl	4,104,867	2m45s
	update	348,912	3d20h56m20s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-09 22:38:50 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

20,105,422 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	20,105,422	93.07%
1-5ms	373,459	1.73%
5-10ms	88,030	0.41%
10-25ms	67,962	0.31%
25-50ms	248,751	1.15%
50-100ms	76,737	0.36%
100-500ms	589,137	2.73%
500-1000ms	43,292	0.20%
1000-10000ms	9,677	0.04%
> 10000ms	1,165	0.01%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '01dc60f876dd9ad3502857db5435af0d4c09feb1', last_update = '2024-12-09 00:31:01.844167', exp_date = '2024-12-09 01:16:01.844170', logged_in = 'TRUE' where id = 847; [ Date: 2024-12-09 02:31:01 ]
2	59m23s	update res_users set sid = '05ccb87c8a7256133a24a33c19ee11c3dffd30c4', last_update = '2024-12-08 23:09:30.694749', exp_date = '2024-12-08 23:54:30.694752', logged_in = 'TRUE' where id = 1096; [ Date: 2024-12-09 01:08:53 ]
3	43m56s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:47:23.837875', exp_date = '2024-12-09 14:32:23.837877', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
4	43m56s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:47:23.842833', exp_date = '2024-12-09 14:32:23.842835', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
5	43m56s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:47:23.842716', exp_date = '2024-12-09 14:32:23.842718', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
6	43m8s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:48:12.536310', exp_date = '2024-12-09 14:33:12.536314', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
7	42m7s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:49:12.913074', exp_date = '2024-12-09 14:34:12.913077', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
8	41m7s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:50:13.281685', exp_date = '2024-12-09 14:35:13.281688', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
9	40m7s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:51:13.641145', exp_date = '2024-12-09 14:36:13.641147', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
10	39m6s	update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:52:14.001509', exp_date = '2024-12-09 14:37:14.001512', logged_in = 'TRUE' where id = 849; [ Date: 2024-12-09 15:31:20 ]
11	36m16s	update res_users set sid = 'd98560c81bd6259b2e90f3672d3dc5405850a66b', last_update = '2024-12-09 20:51:03.608315', exp_date = '2024-12-09 21:36:03.608317', logged_in = 'TRUE' where id = 857; [ Date: 2024-12-09 22:27:20 ]
12	36m16s	update res_users set sid = 'd98560c81bd6259b2e90f3672d3dc5405850a66b', last_update = '2024-12-09 20:51:03.608181', exp_date = '2024-12-09 21:36:03.608186', logged_in = 'TRUE' where id = 857; [ Date: 2024-12-09 22:27:20 ]
13	35m42s	update res_users set sid = 'd98560c81bd6259b2e90f3672d3dc5405850a66b', last_update = '2024-12-09 20:51:38.305021', exp_date = '2024-12-09 21:36:38.305023', logged_in = 'TRUE' where id = 857; [ Date: 2024-12-09 22:27:20 ]
14	35m26s	update res_users set sid = 'd98560c81bd6259b2e90f3672d3dc5405850a66b', last_update = '2024-12-09 20:51:53.736123', exp_date = '2024-12-09 21:36:53.736127', logged_in = 'TRUE' where id = 857; [ Date: 2024-12-09 22:27:20 ]
15	32m15s	update res_users set sid = 'd98560c81bd6259b2e90f3672d3dc5405850a66b', last_update = '2024-12-09 20:55:05.156369', exp_date = '2024-12-09 21:40:05.156372', logged_in = 'TRUE' where id = 857; [ Date: 2024-12-09 22:27:20 ]
16	32m9s	update res_users set sid = 'd98560c81bd6259b2e90f3672d3dc5405850a66b', last_update = '2024-12-09 20:55:11.114277', exp_date = '2024-12-09 21:40:11.114280', logged_in = 'TRUE' where id = 857; [ Date: 2024-12-09 22:27:20 ]
17	32m8s	update res_users set sid = '77810d16e3078e210035bbedda2ad5bed4af505e', last_update = '2024-12-09 12:09:05.953354', exp_date = '2024-12-09 12:54:05.953356', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-09 13:41:14 ]
18	32m8s	update res_users set sid = '77810d16e3078e210035bbedda2ad5bed4af505e', last_update = '2024-12-09 12:09:05.953348', exp_date = '2024-12-09 12:54:05.953351', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-09 13:41:14 ]
19	31m33s	update res_users set sid = '77810d16e3078e210035bbedda2ad5bed4af505e', last_update = '2024-12-09 12:09:41.025057', exp_date = '2024-12-09 12:54:41.025062', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-09 13:41:14 ]
20	31m30s	update res_users set sid = 'e27956a715376fc659ac71f9ba005ff0ad84cc41', last_update = '2024-12-09 12:09:44.615958', exp_date = '2024-12-09 12:54:44.615961', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-09 13:41:14 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d17h31m29s

84,969

Details

0ms

59m59s

3s793ms

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
Dec 09	00	1,001	229ms	0ms
	01	892	59m23s	3s994ms
	02	786	59m59s	4s579ms
	03	693	146ms	0ms
	04	711	30s661ms	43ms
	05	621	133ms	0ms
	06	572	119ms	0ms
	07	599	127ms	0ms
	08	1,896	880ms	0ms
	09	5,149	6h35m30s	4s608ms
	10	7,124	5h2m4s	2s544ms
	11	8,603	10h51m19s	4s542ms
	12	8,622	12h59m50s	5s426ms
	13	7,710	7h42m	3s595ms
	14	8,321	7h5m9s	3s65ms
	15	7,783	10h39m38s	4s931ms
	16	6,161	3m21s	32ms
	17	5,631	6h10m9s	3s944ms
	18	4,079	4h1m11s	3s547ms
	19	2,876	21m41s	452ms
	20	2,724	5h4m5s	6s698ms
	21	1,481	3h40m44s	8s942ms
	22	934	7h14m47s	27s931ms

update res_users set sid = '01dc60f876dd9ad3502857db5435af0d4c09feb1', last_update = '2024-12-09 00:31:01.844167', exp_date = '2024-12-09 01:16:01.844170', logged_in = 'TRUE' where id = 847;

Date: 2024-12-09 02:31:01 Duration: 59m59s
update res_users set sid = '05ccb87c8a7256133a24a33c19ee11c3dffd30c4', last_update = '2024-12-08 23:09:30.694749', exp_date = '2024-12-08 23:54:30.694752', logged_in = 'TRUE' where id = 1096;

Date: 2024-12-09 01:08:53 Duration: 59m23s
update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:47:23.837875', exp_date = '2024-12-09 14:32:23.837877', logged_in = 'TRUE' where id = 849;

Date: 2024-12-09 15:31:20 Duration: 43m56s

2

1d7h8m13s

264,072

Details

335ms

3s809ms

424ms

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
Dec 09	00	5,975	36m51s	370ms
	01	4,257	25m56s	365ms
	02	6,249	38m17s	367ms
	03	5,285	33m3s	375ms
	04	6,613	40m20s	366ms
	05	4,737	28m23s	359ms
	06	4,420	27m48s	377ms
	07	4,563	28m43s	377ms
	08	5,954	36m11s	364ms
	09	11,119	1h9m42s	376ms
	10	15,361	1h41m33s	396ms
	11	17,060	1h54m5s	401ms
	12	16,450	1h50m	401ms
	13	15,144	1h39m45s	395ms
	14	11,679	1h16m55s	395ms
	15	11,992	1h19m20s	396ms
	16	15,900	1h48m28s	409ms
	17	13,972	1h46m39s	458ms
	18	21,541	2h57m8s	493ms
	19	18,057	2h23m20s	476ms
	20	23,145	3h10m18s	493ms
	21	13,727	1h53m13s	494ms
	22	10,872	1h22m5s	453ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429788)) AND (("shipping_track"."id" not in (27952691, 27952691)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:34 Duration: 3s809ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429739)) AND (("shipping_track"."id" not in (27952551, 27952551)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:04 Duration: 3s583ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429796)) AND (("shipping_track"."id" not in (27952709, 27952709)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:37 Duration: 3s456ms

3

8h25m33s

126,788

Details

182ms

1s651ms

239ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	1,265	4m19s	205ms
	01	1,564	5m17s	202ms
	02	2,101	7m8s	203ms
	03	2,374	8m1s	202ms
	04	1,732	5m54s	204ms
	05	1,678	5m43s	204ms
	06	2,144	7m21s	206ms
	07	1,314	4m30s	205ms
	08	2,900	9m56s	205ms
	09	5,779	20m22s	211ms
	10	5,120	19m1s	222ms
	11	5,029	18m47s	224ms
	12	6,077	23m3s	227ms
	13	7,966	29m13s	220ms
	14	5,771	21m12s	220ms
	15	8,363	30m31s	219ms
	16	7,575	28m4s	222ms
	17	9,179	36m46s	240ms
	18	10,333	43m9s	250ms
	19	7,299	30m10s	248ms
	20	6,939	30m28s	263ms
	21	22,041	1h47m21s	292ms
	22	2,245	9m6s	243ms

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" = '9104177')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-09 21:34:33 Duration: 1s651ms
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" = '8956421')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-09 21:34:45 Duration: 1s572ms
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" = '9265162')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-09 21:35:31 Duration: 1s407ms

4

5h34m52s

47,688

Details

339ms

2s451ms

421ms

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
Dec 09	00	309	1m57s	381ms
	01	227	1m29s	396ms
	02	383	2m26s	382ms
	03	118	49s217ms	417ms
	04	185	1m15s	408ms
	05	291	1m51s	382ms
	06	394	2m27s	374ms
	07	602	3m41s	368ms
	08	1,007	6m16s	374ms
	09	2,588	16m40s	386ms
	10	3,781	25m43s	408ms
	11	4,341	29m50s	412ms
	12	4,177	28m46s	413ms
	13	5,419	36m13s	401ms
	14	3,788	25m13s	399ms
	15	3,274	22m4s	404ms
	16	3,828	26m8s	409ms
	17	3,255	24m49s	457ms
	18	2,518	20m25s	486ms
	19	2,992	22m57s	460ms
	20	2,184	17m40s	485ms
	21	1,089	8m56s	492ms
	22	938	7m7s	455ms

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

Date: 2024-12-09 21:34:11 Duration: 2s451ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3349795)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:22 Duration: 2s209ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2897829)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 17:22:01 Duration: 2s184ms

5

4h52m20s

68,620

Details

97ms

1s155ms

255ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	1,966	7m30s	229ms
	01	622	2m27s	236ms
	02	1,198	5m17s	265ms
	03	2,574	11m22s	265ms
	04	1,258	5m44s	274ms
	06	2,295	8m43s	227ms
	07	2,401	9m18s	232ms
	08	548	2m1s	221ms
	09	228	59s941ms	262ms
	10	1,378	6m8s	267ms
	11	589	2m21s	239ms
	12	103	25s256ms	245ms
	13	548	2m22s	259ms
	14	1,844	8m35s	279ms
	15	1,454	6m11s	255ms
	16	3,346	13m48s	247ms
	17	5,413	24m23s	270ms
	18	7,812	34m11s	262ms
	19	9,934	42m25s	256ms
	20	13,033	57m14s	263ms
	21	5,220	21m57s	252ms
	22	4,856	18m49s	232ms

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

Date: 2024-12-09 17:22:01 Duration: 1s155ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مروه')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-09 19:14:45 Duration: 943ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مريم')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-09 19:14:45 Duration: 943ms

6

3h20m47s

11,642

Details

269ms

2s113ms

1s34ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	130	2m4s	955ms
	01	47	45s271ms	963ms
	02	2	2s48ms	1s24ms
	09	5	4s684ms	936ms
	10	1	1s93ms	1s93ms
	12	3	3s114ms	1s38ms
	13	47	47s498ms	1s10ms
	14	78	1m21s	1s50ms
	15	181	3m	998ms
	16	307	5m23s	1s54ms
	17	1,062	18m44s	1s58ms
	18	1,593	28m58s	1s91ms
	19	2,253	37m8s	988ms
	20	3,814	1h7m34s	1s63ms
	21	1,471	24m18s	991ms
	22	648	10m29s	970ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9194257')) 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 (26))))))) 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 (26)))))) 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 (26)))))) 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 (26))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-09 21:33:53 Duration: 2s113ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9266827')) 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 (30))))))) 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 (30)))))) 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 (30)))))) 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 (30))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-09 21:35:35 Duration: 2s77ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9297903')) 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 (14, 74, 70))))))) 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 (14, 74, 70)))))) 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 (14, 74, 70)))))) 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 (14, 74, 70))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-09 21:33:56 Duration: 2s40ms

7

2h20m54s

401

Details

0ms

19m11s

21s82ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 09	00	7	19m11s	2m44s
	01	8	2ms	0ms
	03	1	0ms	0ms
	05	5	2ms	0ms
	06	1	0ms	0ms
	07	9	1ms	0ms
	08	24	4ms	0ms
	09	40	45m44s	1m8s
	10	38	9m37s	15s203ms
	11	40	42ms	1ms
	12	29	39ms	1ms
	13	27	29ms	1ms
	14	28	1m31s	3s283ms
	15	28	1m26s	3s85ms
	16	28	19ms	0ms
	17	19	9m58s	31s481ms
	18	11	17ms	1ms
	19	21	25ms	1ms
	20	26	21m1s	48s521ms
	21	8	32m21s	4m2s
	22	3	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-08 23:56:56.575266', "last_update" = '2024-12-08 23:11:56.575285', "sid" = '9167d8a563060eacc6ab128cd109faf9a9b6d4c7', "write_date" = '2024-12-08 23:11:56.247100', "write_uid" = 1 WHERE id IN (1295);

Date: 2024-12-09 00:31:08 Duration: 19m11s
UPDATE "res_users" SET "exp_date" = '2024-12-09 08:54:08.194209', "last_update" = '2024-12-09 08:09:08.194233', "sid" = 'f02d3833e8b9b4863d43e1f3a764a8aa6b52b23c', "write_date" = '2024-12-09 08:09:07.858900', "write_uid" = 988 WHERE id IN (988);

Date: 2024-12-09 09:23:20 Duration: 14m12s
UPDATE "res_users" SET "exp_date" = '2024-12-09 20:53:59.948335', "last_update" = '2024-12-09 20:08:59.948354', "sid" = '31a1316d66ea9239b87f60e158ffd9ab3bfd8861', "write_date" = '2024-12-09 20:08:59.627045', "write_uid" = 870 WHERE id IN (870);

Date: 2024-12-09 21:21:20 Duration: 12m20s

8

2h9m49s

23,237

Details

227ms

2s159ms

335ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	889	4m20s	292ms
	01	290	1m24s	289ms
	02	601	2m54s	290ms
	03	1,307	6m19s	290ms
	04	639	3m5s	289ms
	06	1,151	5m38s	294ms
	07	1,209	5m52s	291ms
	08	282	1m23s	296ms
	09	113	33s809ms	299ms
	10	725	3m56s	326ms
	11	305	1m38s	321ms
	12	52	16s810ms	323ms
	13	240	1m17s	321ms
	14	870	4m32s	313ms
	15	559	2m58s	318ms
	16	1,380	7m22s	320ms
	17	1,674	9m53s	354ms
	18	2,370	14m43s	372ms
	19	2,794	16m27s	353ms
	20	2,782	16m49s	363ms
	21	1,202	8m8s	406ms
	22	1,803	10m11s	338ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9359922')) 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: 2024-12-09 21:35:37 Duration: 2s159ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9215497')) 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: 2024-12-09 21:34:34 Duration: 2s112ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9217885')) 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: 2024-12-09 21:33:35 Duration: 1s996ms

9

1h50m38s

155,950

Details

29ms

409ms

42ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	2,493	1m32s	37ms
	01	1,189	44s892ms	37ms
	02	1,903	1m12s	38ms
	03	1,546	58s60ms	37ms
	04	2,057	1m17s	37ms
	05	1,178	44s566ms	37ms
	06	1,782	1m7s	37ms
	07	1,522	57s777ms	37ms
	08	2,876	1m49s	37ms
	09	7,221	4m43s	39ms
	10	11,398	7m42s	40ms
	11	13,086	8m58s	41ms
	12	13,168	9m1s	41ms
	13	12,262	8m16s	40ms
	14	9,078	6m3s	40ms
	15	10,018	6m43s	40ms
	16	12,378	8m27s	41ms
	17	8,838	6m42s	45ms
	18	11,503	9m23s	48ms
	19	10,609	8m19s	47ms
	20	11,760	9m29s	48ms
	21	5,169	4m8s	48ms
	22	2,916	2m13s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3399089)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 17:21:59 Duration: 409ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3323129)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 21:34:11 Duration: 169ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3392704)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 21:34:20 Duration: 137ms

10

1h48m32s

24,283

Details

188ms

472ms

268ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	07	111	27s436ms	247ms
	08	828	3m24s	247ms
	09	1,228	5m12s	254ms
	10	2,188	9m47s	268ms
	11	1,566	7m9s	274ms
	12	2,199	9m52s	269ms
	13	2,983	13m18s	267ms
	14	2,297	10m2s	262ms
	15	4,008	17m32s	262ms
	16	3,092	13m54s	269ms
	17	2,926	13m50s	283ms
	18	857	4m	280ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9249901')))) ORDER BY "collection_policy"."id";

Date: 2024-12-09 17:48:29 Duration: 472ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9249955')))) ORDER BY "collection_policy"."id";

Date: 2024-12-09 17:48:29 Duration: 443ms
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" = '9132680')))) ORDER BY "collection_policy"."id";

Date: 2024-12-09 18:30:55 Duration: 409ms

11

57m58s

1,015

Details

2s311ms

4s973ms

3s427ms

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."v_10_id" = ?)) order by "res_partner"."display_name" asc, "res_partner"."id" desc limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 09	00	56	2m51s	3s67ms
	01	56	2m44s	2s935ms
	02	57	2m52s	3s20ms
	03	56	2m55s	3s134ms
	04	56	2m51s	3s55ms
	05	57	2m53s	3s36ms
	06	56	2m57s	3s163ms
	07	56	2m48s	3s9ms
	08	54	2m51s	3s183ms
	09	55	3m14s	3s538ms
	10	53	3m20s	3s775ms
	11	53	3m21s	3s802ms
	12	55	3m28s	3s794ms
	13	53	3m25s	3s886ms
	14	46	2m50s	3s706ms
	15	51	3m10s	3s733ms
	16	58	3m41s	3s824ms
	17	49	3m6s	3s811ms
	18	38	2m32s	4s10ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-09 11:55:09 Duration: 4s973ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-09 16:14:55 Duration: 4s848ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-09 12:02:52 Duration: 4s823ms

12

53m8s

75,384

Details

32ms

212ms

42ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	141	5s647ms	40ms
	01	18	712ms	39ms
	02	9	387ms	43ms
	04	13	536ms	41ms
	05	5	216ms	43ms
	06	12	476ms	39ms
	07	178	6s949ms	39ms
	08	762	29s874ms	39ms
	09	3,164	2m8s	40ms
	10	5,242	3m41s	42ms
	11	4,612	3m15s	42ms
	12	5,004	3m34s	42ms
	13	6,569	4m37s	42ms
	14	5,169	3m36s	41ms
	15	8,167	5m38s	41ms
	16	12,788	9m11s	43ms
	17	5,783	4m5s	42ms
	18	10,505	7m31s	42ms
	19	6,499	4m30s	41ms
	20	492	22s84ms	44ms
	21	139	6s661ms	47ms
	22	113	4s772ms	42ms

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

Date: 2024-12-09 21:33:42 Duration: 212ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2939157) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-09 21:35:20 Duration: 185ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3358802) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-09 21:35:30 Duration: 120ms

13

38m19s

10,677

Details

183ms

816ms

215ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	252	51s753ms	205ms
	01	129	25s379ms	196ms
	02	206	41s560ms	201ms
	03	92	18s559ms	201ms
	04	483	1m39s	205ms
	05	527	1m48s	205ms
	06	660	2m15s	206ms
	07	515	1m45s	204ms
	08	857	2m54s	203ms
	09	1,396	4m56s	212ms
	10	742	2m43s	220ms
	11	314	1m9s	222ms
	12	789	2m51s	217ms
	13	850	3m5s	218ms
	14	275	59s772ms	217ms
	15	1,242	4m33s	220ms
	16	473	1m41s	214ms
	17	6	1s486ms	247ms
	18	272	1m11s	262ms
	19	26	6s246ms	240ms
	20	287	1m13s	255ms
	21	269	1m2s	231ms
	22	15	3s707ms	247ms

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" = '8920946')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) 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: 2024-12-09 21:35:37 Duration: 816ms
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" = '9167572')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) 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: 2024-12-09 21:35:38 Duration: 380ms
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" = '8843950')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) 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: 2024-12-09 21:35:36 Duration: 346ms

14

37m36s

25,580

Details

71ms

230ms

88ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	517	40s931ms	79ms
	05	21	1s818ms	86ms
	06	13	1s68ms	82ms
	07	72	6s173ms	85ms
	08	203	17s60ms	84ms
	09	960	1m21s	84ms
	10	3,078	4m22s	85ms
	11	3,149	4m32s	86ms
	12	2,243	3m17s	88ms
	13	2,370	3m29s	88ms
	14	2,015	2m55s	87ms
	15	2,866	4m9s	86ms
	16	3,207	4m44s	88ms
	17	1,648	2m30s	91ms
	18	852	1m22s	96ms
	19	724	1m8s	94ms
	20	1,084	1m43s	95ms
	21	489	44s645ms	91ms
	22	69	6s585ms	95ms

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

Date: 2024-12-09 17:23:22 Duration: 230ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7792559)) AND (("cash_track"."id" not in (5520353, 5523236, 5524158, 5524740, 5524740)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-09 21:35:08 Duration: 173ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7761240)) AND (("cash_track"."id" not in (5295809, 5336219, 5368680, 5524758, 5524758)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-09 21:35:11 Duration: 172ms

15

36m25s

10,673

Details

182ms

244ms

204ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	912	3m6s	204ms
	01	986	3m21s	204ms
	02	1,855	6m18s	204ms
	03	2,256	7m37s	202ms
	04	1,235	4m12s	204ms
	05	1,085	3m41s	204ms
	06	850	2m56s	207ms
	07	271	56s398ms	208ms
	08	972	3m20s	206ms
	09	251	54s127ms	215ms

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" = '9225106')) 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: 2024-12-09 09:03:01 Duration: 244ms
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" = '9266315')) 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: 2024-12-09 09:03:22 Duration: 243ms
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" = '9306798')) 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: 2024-12-09 09:02:57 Duration: 243ms

16

35m57s

942,110

Details

0ms

14s976ms

2ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	14,674	2s237ms	0ms
	01	14,296	1s911ms	0ms
	02	9,462	1s534ms	0ms
	03	7,418	1s171ms	0ms
	04	8,186	1s300ms	0ms
	05	8,712	1s339ms	0ms
	06	13,440	1s972ms	0ms
	07	10,940	1s647ms	0ms
	08	26,699	3s709ms	0ms
	09	61,761	8s436ms	0ms
	10	82,267	11s546ms	0ms
	11	107,890	14s196ms	0ms
	12	88,156	13s304ms	0ms
	13	84,226	12s106ms	0ms
	14	75,786	10s344ms	0ms
	15	69,933	12s96ms	0ms
	16	62,834	12s128ms	0ms
	17	54,855	7s958ms	0ms
	18	46,312	7s49ms	0ms
	19	32,080	33m41s	63ms
	20	31,950	4s872ms	0ms
	21	18,672	2s781ms	0ms
	22	11,561	1s764ms	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 (1075);

Date: 2024-12-09 19:04:47 Duration: 14s976ms
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 (1295);

Date: 2024-12-09 19:02:16 Duration: 14s903ms
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 (852);

Date: 2024-12-09 19:02:16 Duration: 14s899ms

17

29m10s

39

Details

0ms

15m15s

44s872ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 09	00	1	1ms	1ms
	08	7	1ms	0ms
	09	2	0ms	0ms
	10	3	3ms	1ms
	11	2	3ms	1ms
	12	5	5ms	1ms
	13	1	1ms	1ms
	14	4	1m13s	18s266ms
	15	3	15m15s	5m5s
	16	2	0ms	0ms
	17	4	12m41s	3m10s
	18	2	5ms	2ms
	19	1	1ms	1ms
	21	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-09 15:01:05.356245', "last_update" = '2024-12-09 14:16:05.356270', "write_date" = '2024-12-09 14:16:04.979791', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-09 15:31:20 Duration: 15m15s
UPDATE "res_users" SET "exp_date" = '2024-12-09 17:08:39.189009', "last_update" = '2024-12-09 16:23:39.189035', "write_date" = '2024-12-09 16:23:38.837794', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-09 17:36:20 Duration: 12m41s
UPDATE "res_users" SET "exp_date" = '2024-12-09 13:48:07.383257', "last_update" = '2024-12-09 13:03:07.383301', "write_date" = '2024-12-09 13:03:07.045503', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-09 14:04:20 Duration: 1m13s

18

19m40s

5,405

Details

188ms

300ms

218ms

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

Day	Hour	Count	Duration	Avg duration
Dec 09	06	621	2m7s	205ms
	07	287	59s69ms	205ms
	08	253	52s81ms	205ms
	09	212	44s455ms	209ms
	10	580	2m8s	221ms
	11	835	3m3s	219ms
	12	262	57s895ms	220ms
	13	622	2m16s	218ms
	14	794	2m51s	215ms
	15	137	31s126ms	227ms
	16	424	1m38s	232ms
	17	82	19s881ms	242ms
	19	152	35s636ms	234ms
	20	144	34s931ms	242ms

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" = '8737467')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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: 2024-12-09 17:54:58 Duration: 300ms
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" = '8839890')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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: 2024-12-09 16:01:04 Duration: 299ms
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" = '8759365')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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: 2024-12-09 10:18:22 Duration: 287ms

19

19m38s

4,477

Details

195ms

341ms

263ms

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" = ?) and ((((("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 "collection_policy"."id";

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 09	09	130	33s218ms	255ms
	10	629	2m42s	257ms
	11	1,285	5m36s	262ms
	12	261	1m8s	263ms
	13	712	3m5s	260ms
	14	819	3m33s	260ms
	15	217	59s449ms	273ms
	16	424	1m58s	280ms

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" = '471036') AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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 "collection_policy"."id";

Date: 2024-12-09 14:36:15 Duration: 341ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '8998308') AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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 "collection_policy"."id";

Date: 2024-12-09 16:00:44 Duration: 336ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9164797') AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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 "collection_policy"."id";

Date: 2024-12-09 11:14:19 Duration: 331ms

20

18m46s

1,084

Details

0ms

4m43s

1s38ms

update "shipping_policy" set "archive_date" = ?, "state" = ?, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 09	07	8	15ms	1ms
	08	32	52ms	1ms
	09	89	293ms	3ms
	10	109	445ms	4ms
	11	103	459ms	4ms
	12	107	439ms	4ms
	13	137	508ms	3ms
	14	132	331ms	2ms
	15	75	348ms	4ms
	16	105	3m9s	1s806ms
	17	102	569ms	5ms
	18	65	6m58s	6s436ms
	19	20	8m34s	25s727ms

UPDATE "shipping_policy" SET "archive_date" = '2024-12-09', "state" = 'archive', "write_date" = '2024-12-09 18:15:16.101222', "write_uid" = 1102 WHERE id IN (3111133, 3134576, 3171481, 3184274, 3188121, 3188283, 3204357, 3214454, 3224307, 3233077, 3243926, 3255864, 3257680, 3259156, 3259278, 3260913, 3260978, 3261797);

Date: 2024-12-09 19:20:27 Duration: 4m43s
UPDATE "shipping_policy" SET "archive_date" = '2024-12-09', "state" = 'archive', "write_date" = '2024-12-09 15:11:08.163653', "write_uid" = 1102 WHERE id IN (2820757, 2895066, 2937660, 3046723, 3074998, 3106561, 3117975, 3131769, 3133328, 3135352, 3155500, 3163620, 3173724, 3176655, 3178641, 3182724, 3182849, 3182859, 3184091, 3184310, 3188696, 3191764, 3194121, 3194991, 3195010, 3197096, 3199054, 3200797, 3202656, 3205741, 3205942, 3208730, 3212265, 3212428, 3212811, 3213432, 3213437, 3213497, 3213675, 3214169, 3214212, 3214926, 3215031, 3215287, 3216122, 3216208, 3216424, 3216979, 3217546, 3217743, 3218289, 3218545, 3218584, 3219661, 3219772, 3219958, 3220222, 3220322, 3220446, 3221135, 3221389, 3221498, 3221638, 3221702, 3221712, 3221717, 3221725, 3222188, 3222500, 3222559, 3222617, 3223095, 3223302, 3224442, 3224585, 3224790, 3225179, 3225212, 3225333, 3225335, 3226093, 3227950, 3228470, 3228557, 3228573, 3228575, 3229847, 3229928, 3229997, 3230051, 3231135, 3231234, 3231276, 3231575, 3231595, 3231611, 3231637, 3232016, 3233924, 3234732, 3234965, 3234982, 3235510, 3235570, 3236367, 3236383, 3236398, 3236404, 3236442, 3240100, 3240170, 3240194, 3240235, 3240269, 3240983, 3241128, 3241141, 3241192, 3241341, 3241358, 3241363, 3241751, 3241915, 3241930, 3241987, 3242059, 3242060, 3242067, 3242071, 3242088, 3242111, 3242621, 3242750, 3243378, 3243401, 3243410, 3243486, 3243526, 3243529, 3243536, 3243758, 3243768, 3243813, 3243980, 3244003, 3244014, 3244019, 3244026, 3244035, 3244049, 3244066, 3244067, 3244075, 3244099, 3244100, 3244137, 3244163, 3244165, 3245302, 3245341, 3247733, 3247740, 3247789, 3247881, 3249095, 3250790, 3250803, 3250828, 3251289, 3251459, 3251467, 3251470, 3251473, 3251479, 3251757, 3251922, 3251936, 3251959, 3251970, 3251992, 3252116, 3252216, 3252276, 3252520, 3252552, 3252561, 3252603, 3252716, 3252874, 3252946, 3252948, 3252957, 3252961, 3252964, 3253055, 3253147, 3253157, 3253186, 3253209, 3253232, 3253235, 3253279, 3253354, 3253359, 3253428, 3253429, 3253518, 3253840, 3253919, 3253936, 3253997, 3254035, 3254132, 3254134, 3254136, 3254139, 3254514, 3254713, 3254776, 3254808, 3254809, 3254819, 3254868, 3254955, 3255027, 3255098, 3255578, 3255605, 3255706, 3255710, 3255715, 3255728, 3255753, 3255855, 3255857, 3255860, 3255870, 3256015, 3256031, 3256369, 3256523, 3256619, 3256782, 3256828, 3257068, 3257191, 3257229, 3257241, 3257265, 3257269, 3257295, 3257457, 3257461, 3257581, 3257611, 3257620, 3257637, 3257683, 3257819, 3257840, 3257939, 3257943, 3258255, 3258263, 3258306, 3258479, 3258485, 3258490, 3258572, 3258678, 3258685, 3258690, 3258791, 3258876, 3258901, 3258903, 3258988, 3259076, 3259134, 3259179, 3259847, 3259861, 3259878, 3260010, 3260231, 3260235, 3260318, 3260391, 3260432, 3260664, 3260665, 3260674, 3260676, 3260693, 3260891, 3260904, 3260951, 3261130, 3261167, 3261265, 3261278, 3261317, 3261441, 3261449, 3261453, 3261461, 3261479, 3261526, 3261539, 3261590, 3261600, 3261649, 3261666, 3261667, 3261669, 3261670, 3261703, 3261711, 3261871, 3261876, 3261951, 3262149, 3262238, 3262242, 3262249, 3262268, 3262281, 3262297, 3262329, 3262336, 3262374, 3262391, 3262396, 3262483, 3262626, 3262629, 3262685, 3262686, 3262691, 3262701, 3262723, 3262725, 3262757, 3262930, 3263012, 3263120, 3263135, 3263194, 3263228, 3263243, 3263260, 3263734, 3263750, 3263778, 3263860, 3263923, 3263956, 3263975, 3263980, 3264025, 3264102, 3264119, 3264136, 3264157, 3264176, 3264339);

Date: 2024-12-09 16:18:06 Duration: 3m8s
UPDATE "shipping_policy" SET "archive_date" = '2024-12-09', "state" = 'archive', "write_date" = '2024-12-09 17:49:57.199949', "write_uid" = 1102 WHERE id IN (3111133, 3134576, 3171481, 3184274, 3188121, 3188283, 3204357, 3214454, 3224307, 3233077, 3243926, 3255864, 3257680, 3259156, 3259278, 3260913, 3260978, 3261797);

Date: 2024-12-09 18:53:05 Duration: 2m41s

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,608,615

Details

2m2s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 09	00	46,449	1s977ms	0ms
	01	46,424	1s960ms	0ms
	02	38,311	1s618ms	0ms
	03	34,509	1s507ms	0ms
	04	32,741	1s413ms	0ms
	05	32,444	1s444ms	0ms
	06	39,097	1s886ms	0ms
	07	33,847	1s636ms	0ms
	08	76,470	3s614ms	0ms
	09	153,024	7s159ms	0ms
	10	200,119	9s893ms	0ms
	11	239,504	11s238ms	0ms
	12	227,407	10s984ms	0ms
	13	222,817	10s420ms	0ms
	14	205,893	9s243ms	0ms
	15	196,752	9s528ms	0ms
	16	181,991	9s588ms	0ms
	17	151,404	6s665ms	0ms
	18	132,405	6s95ms	0ms
	19	107,065	5s195ms	0ms
	20	98,411	4s773ms	0ms
	21	68,893	3s4ms	0ms
	22	42,638	1s841ms	0ms

DISCARD ALL;

Date: 2024-12-09 17:06:10 Duration: 1ms
DISCARD ALL;

Date: 2024-12-09 16:42:03 Duration: 1ms
DISCARD ALL;

Date: 2024-12-09 16:42:01 Duration: 1ms

2

2,053,064

Details

28s945ms

0ms

14ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 09	00	35,217	494ms	0ms
	01	34,330	478ms	0ms
	02	27,585	402ms	0ms
	03	24,099	368ms	0ms
	04	23,991	366ms	0ms
	05	24,161	360ms	0ms
	06	32,116	482ms	0ms
	07	26,913	415ms	0ms
	08	60,517	850ms	0ms
	09	125,036	1s709ms	0ms
	10	163,875	2s280ms	0ms
	11	198,422	2s668ms	0ms
	12	182,562	2s539ms	0ms
	13	176,719	2s407ms	0ms
	14	161,764	2s195ms	0ms
	15	152,607	2s121ms	0ms
	16	141,303	2s134ms	0ms
	17	119,984	1s624ms	0ms
	18	103,745	1s457ms	0ms
	19	79,978	1s204ms	0ms
	20	76,232	1s165ms	0ms
	21	50,565	764ms	0ms
	22	31,343	452ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-09 14:44:30 Duration: 14ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-09 09:17:22 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-09 12:32:54 Duration: 0ms

3

1,332,889

Details

13s362ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 09	00	24,163	222ms	0ms
	01	23,989	216ms	0ms
	02	19,818	180ms	0ms
	03	17,894	171ms	0ms
	04	17,113	164ms	0ms
	05	16,880	157ms	0ms
	06	20,255	200ms	0ms
	07	17,697	176ms	0ms
	08	39,499	378ms	0ms
	09	78,165	750ms	0ms
	10	101,716	1s33ms	0ms
	11	121,471	1s204ms	0ms
	12	115,443	1s157ms	0ms
	13	112,860	1s136ms	0ms
	14	105,020	1s36ms	0ms
	15	100,097	1s	0ms
	16	92,800	968ms	0ms
	17	77,213	799ms	0ms
	18	67,418	718ms	0ms
	19	54,816	563ms	0ms
	20	50,856	536ms	0ms
	21	35,669	374ms	0ms
	22	22,037	209ms	0ms

ROLLBACK;

Date: 2024-12-09 11:10:04 Duration: 0ms
ROLLBACK;

Date: 2024-12-09 10:36:17 Duration: 0ms
ROLLBACK;

Date: 2024-12-09 13:56:00 Duration: 0ms

4

1,313,767

Details

3m41s

0ms

15ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 09	00	23,348	3s533ms	0ms
	01	23,198	3s321ms	0ms
	02	19,137	3s1ms	0ms
	03	17,193	2s810ms	0ms
	04	16,386	2s655ms	0ms
	05	16,208	2s474ms	0ms
	06	19,540	3s115ms	0ms
	07	16,949	2s769ms	0ms
	08	38,378	5s838ms	0ms
	09	77,142	12s647ms	0ms
	10	101,097	17s125ms	0ms
	11	120,685	20s246ms	0ms
	12	114,782	19s323ms	0ms
	13	112,271	19s266ms	0ms
	14	103,773	17s348ms	0ms
	15	98,878	16s460ms	0ms
	16	91,688	15s826ms	0ms
	17	75,993	13s180ms	0ms
	18	66,604	12s119ms	0ms
	19	53,903	9s637ms	0ms
	20	50,023	8s813ms	0ms
	21	34,973	6s189ms	0ms
	22	21,618	3s635ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'dab4ff81c85c277b18a15bb26a70edae33b9b4e4';

Date: 2024-12-09 11:46:49 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '15c8a986b43615f9d8f8725692c506649dc594ce';

Date: 2024-12-09 10:54:50 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '83ebf66a5124b93a4bb9b3037d076834778979ea';

Date: 2024-12-09 12:30:54 Duration: 15ms

5

1,303,070

Details

1m53s

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
Dec 09	00	23,265	1s836ms	0ms
	01	23,235	1s856ms	0ms
	02	19,237	1s559ms	0ms
	03	17,304	1s445ms	0ms
	04	16,418	1s357ms	0ms
	05	16,267	1s338ms	0ms
	06	19,589	1s678ms	0ms
	07	16,937	1s438ms	0ms
	08	38,079	3s90ms	0ms
	09	76,302	6s332ms	0ms
	10	99,883	8s628ms	0ms
	11	119,579	10s369ms	0ms
	12	113,591	9s964ms	0ms
	13	111,339	9s745ms	0ms
	14	102,791	8s990ms	0ms
	15	98,273	8s678ms	0ms
	16	90,870	8s50ms	0ms
	17	75,533	6s807ms	0ms
	18	66,114	6s201ms	0ms
	19	53,476	4s953ms	0ms
	20	49,171	4s495ms	0ms
	21	34,472	3s174ms	0ms
	22	21,345	1s859ms	0ms

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

Date: 2024-12-09 16:30:05 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-09 16:38:26 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-09 17:21:59 Duration: 1ms

6

942,110

Details

35m57s

0ms

14s976ms

2ms

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
Dec 09	00	14,674	2s237ms	0ms
	01	14,296	1s911ms	0ms
	02	9,462	1s534ms	0ms
	03	7,418	1s171ms	0ms
	04	8,186	1s300ms	0ms
	05	8,712	1s339ms	0ms
	06	13,440	1s972ms	0ms
	07	10,940	1s647ms	0ms
	08	26,699	3s709ms	0ms
	09	61,761	8s436ms	0ms
	10	82,267	11s546ms	0ms
	11	107,890	14s196ms	0ms
	12	88,156	13s304ms	0ms
	13	84,226	12s106ms	0ms
	14	75,786	10s344ms	0ms
	15	69,933	12s96ms	0ms
	16	62,834	12s128ms	0ms
	17	54,855	7s958ms	0ms
	18	46,312	7s49ms	0ms
	19	32,080	33m41s	63ms
	20	31,950	4s872ms	0ms
	21	18,672	2s781ms	0ms
	22	11,561	1s764ms	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 (1075);

Date: 2024-12-09 19:04:47 Duration: 14s976ms
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 (1295);

Date: 2024-12-09 19:02:16 Duration: 14s903ms
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 (852);

Date: 2024-12-09 19:02:16 Duration: 14s899ms

7

718,900

Details

2m3s

0ms

34ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 09	00	11,034	1s990ms	0ms
	01	10,349	1s643ms	0ms
	02	7,785	1s500ms	0ms
	03	6,206	1s280ms	0ms
	04	6,878	1s382ms	0ms
	05	7,281	1s363ms	0ms
	06	11,858	1s559ms	0ms
	07	9,219	1s357ms	0ms
	08	21,011	3s47ms	0ms
	09	46,788	7s216ms	0ms
	10	62,101	10s375ms	0ms
	11	76,779	12s39ms	0ms
	12	67,041	11s838ms	0ms
	13	63,802	10s790ms	0ms
	14	56,566	9s596ms	0ms
	15	52,384	9s150ms	0ms
	16	48,476	8s471ms	0ms
	17	42,563	7s609ms	0ms
	18	36,225	6s612ms	0ms
	19	25,112	4s617ms	0ms
	20	25,299	4s916ms	0ms
	21	14,869	3s155ms	0ms
	22	9,274	1s795ms	0ms

COMMIT;

Date: 2024-12-09 18:31:40 Duration: 34ms
COMMIT;

Date: 2024-12-09 11:41:52 Duration: 33ms
COMMIT;

Date: 2024-12-09 15:09:47 Duration: 30ms

8

579,331

Details

36s345ms

0ms

2ms

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
Dec 09	00	7,806	410ms	0ms
	01	6,625	383ms	0ms
	02	4,428	258ms	0ms
	03	3,093	193ms	0ms
	04	3,903	221ms	0ms
	05	3,957	228ms	0ms
	06	13,049	589ms	0ms
	07	6,767	371ms	0ms
	08	14,371	803ms	0ms
	09	35,204	2s122ms	0ms
	10	48,726	3s218ms	0ms
	11	73,861	4s254ms	0ms
	12	53,669	3s561ms	0ms
	13	49,848	3s199ms	0ms
	14	43,181	2s707ms	0ms
	15	42,610	2s529ms	0ms
	16	38,065	2s321ms	0ms
	17	33,811	2s215ms	0ms
	18	30,324	2s74ms	0ms
	19	22,450	1s530ms	0ms
	20	23,400	1s711ms	0ms
	21	12,525	922ms	0ms
	22	7,658	514ms	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 (28, 119, 49, 64, 17, 35, 66);

Date: 2024-12-09 16:54:42 Duration: 2ms
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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 16, 17, 19, 22, 24, 26, 27, 28, 29, 30, 32, 35, 36, 38, 39, 40, 41, 42, 44, 46, 48, 49, 51, 52, 53, 55, 60, 61, 62, 64, 65, 66, 67, 68, 70, 71, 73, 74, 75, 76, 77, 78, 79, 80, 85, 95, 102, 110, 111, 113, 114, 115, 119, 121, 123, 126, 127);

Date: 2024-12-09 15:00:30 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, 24, 110, 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, 26, 62, 51, 55, 30, 66, 79, 68);

Date: 2024-12-09 09:55:40 Duration: 1ms

9

575,530

Details

1m13s

0ms

6ms

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
Dec 09	00	9,708	1s127ms	0ms
	01	8,960	1s785ms	0ms
	02	5,255	633ms	0ms
	03	4,776	522ms	0ms
	04	4,512	589ms	0ms
	05	4,366	569ms	0ms
	06	12,419	907ms	0ms
	07	6,285	688ms	0ms
	08	14,540	1s665ms	0ms
	09	37,097	4s554ms	0ms
	10	49,952	6s728ms	0ms
	11	62,797	7s655ms	0ms
	12	50,846	6s615ms	0ms
	13	48,507	6s673ms	0ms
	14	43,407	5s649ms	0ms
	15	42,507	5s568ms	0ms
	16	35,834	4s375ms	0ms
	17	33,185	4s541ms	0ms
	18	31,316	4s177ms	0ms
	19	23,983	2s856ms	0ms
	20	24,093	2s976ms	0ms
	21	12,805	1s626ms	0ms
	22	8,380	967ms	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 (5099333, 5099045, 5099140, 5099264, 5099724, 5099095, 5099009, 5099382, 5099540, 5099644, 5107482, 5099089, 5099014, 5114910, 5183366, 5118603, 5099138, 5407772, 5099573, 5107911, 5100874, 5099035, 5340881, 5131580, 5099427, 5108742, 5100004, 5099446, 5099321, 5107065, 5180779, 5100824, 5105187, 5100352, 5099202, 5206501, 5107010, 5100857, 5111794, 5110718, 5101092, 5099420, 5099243, 5099007, 5359542, 5101973, 5123956, 5110357, 5102094, 5111923, 5099590, 5118125, 5099129, 5099401, 5099102, 5101662);

Date: 2024-12-09 17:21:58 Duration: 6ms
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 (5099296, 5099202, 5111965, 5099236, 5099170, 5107665, 5099006, 5105812, 5099046, 5099855, 5099420, 5120848, 5099206, 5099137, 5417994, 5099035, 5099007, 5099010, 5099321, 5183505, 5128316, 5099654, 5277639, 5103188, 5101952, 5099798, 5125904, 5099013, 5413282, 5099639, 5099119, 5099180, 5099609, 5099009, 5100159, 5101122, 5100699, 5099251, 5099264, 5112528, 5102584, 5099139, 5099904, 5099103, 5101081, 5103255, 5099720, 5104278, 5247337, 5099027, 5100101, 5100443, 5099818, 5339716, 5413557, 5112605, 5099002, 5099102, 5212341, 5102606, 5104623, 5099280, 5100421, 5099590, 5100252, 5100205, 5099144, 5099128, 5099167, 5101319, 5387387, 5101994, 5108562, 5099090, 5100471, 5099446, 5102909, 5099254, 5128741, 5099224, 5099028, 5101540, 5101864, 5101313, 5099727, 5103731, 5099333, 5099037, 5099873, 5215313, 5102760, 5099415, 5125221, 5099360, 5099678, 5099547, 5099718, 5100070, 5099263, 5418493, 5168727, 5416386, 5099540, 5419489, 5099430, 5100832, 5125956, 5101967, 5113209, 5100302, 5102843, 5181714, 5100992, 5103633, 5100218, 5101850);

Date: 2024-12-09 17:21:59 Duration: 6ms
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 (5389672, 5099404, 5101297, 5100786, 5099403, 5413688, 5101185, 5099277, 5113194, 5100872, 5105921, 5099355, 5099130, 5117172, 5099684, 5220737, 5122425, 5116464, 5099995, 5269277, 5100667, 5105620, 5099097, 5413605, 5104194, 5100110, 5099116, 5099541, 5104237, 5099138, 5099885, 5099141, 5100684, 5099918, 5417916, 5103709, 5099852, 5099382, 5099843, 5107075, 5099848, 5231551, 5311487, 5107768, 5099788, 5123010, 5099281, 5417722, 5099246, 5099618, 5100957, 5099359, 5099104, 5099599, 5099560, 5105101, 5099920, 5100352, 5100016, 5098996, 5346178, 5099445, 5101852, 5104336, 5099014, 5103200, 5101009, 5101169, 5101969, 5099108, 5416042, 5099181, 5100476, 5404027, 5099008, 5099335, 5254378, 5112620, 5099564, 5099815, 5101324, 5101913, 5109665, 5112417, 5272852, 5099630, 5100484, 5103579, 5100431, 5103960, 5100001, 5416385, 5107504, 5099358, 5101184, 5112924, 5411726, 5099247, 5099442, 5099572, 5109980, 5405698, 5130100);

Date: 2024-12-09 17:21:59 Duration: 5ms

10

392,125

Details

2m5s

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
Dec 09	00	2,988	828ms	0ms
	01	2,627	760ms	0ms
	02	1,905	566ms	0ms
	03	1,260	392ms	0ms
	04	1,571	490ms	0ms
	05	992	331ms	0ms
	06	2,081	653ms	0ms
	07	3,829	1s167ms	0ms
	08	10,144	2s993ms	0ms
	09	26,125	7s866ms	0ms
	10	36,909	11s669ms	0ms
	11	41,936	13s394ms	0ms
	12	37,683	12s261ms	0ms
	13	33,201	10s792ms	0ms
	14	34,278	10s913ms	0ms
	15	29,877	9s673ms	0ms
	16	24,298	8s27ms	0ms
	17	31,842	10s403ms	0ms
	18	22,497	7s574ms	0ms
	19	16,386	5s455ms	0ms
	20	13,776	4s604ms	0ms
	21	10,201	3s346ms	0ms
	22	5,719	1s714ms	0ms

SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'change.amount.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 = 892) OR r.global) ORDER BY r.id;

Date: 2024-12-09 13:13:44 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.users' 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 = 860) OR r.global) ORDER BY r.id;

Date: 2024-12-09 21:33:43 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'cash.policy' 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 = 881) OR r.global) ORDER BY r.id;

Date: 2024-12-09 12:59:47 Duration: 2ms

11

391,429

Details

1m12s

0ms

5ms

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
Dec 09	00	5,248	834ms	0ms
	01	5,323	835ms	0ms
	02	2,934	518ms	0ms
	03	2,064	384ms	0ms
	04	2,627	484ms	0ms
	05	2,466	464ms	0ms
	06	7,169	1s163ms	0ms
	07	4,599	739ms	0ms
	08	12,093	1s897ms	0ms
	09	27,104	4s611ms	0ms
	10	33,769	6s202ms	0ms
	11	45,868	8s578ms	0ms
	12	35,849	6s834ms	0ms
	13	34,905	6s390ms	0ms
	14	32,446	5s862ms	0ms
	15	29,447	5s508ms	0ms
	16	26,367	4s950ms	0ms
	17	23,244	4s586ms	0ms
	18	18,767	3s855ms	0ms
	19	13,352	2s656ms	0ms
	20	12,857	2s626ms	0ms
	21	7,819	1s530ms	0ms
	22	5,112	917ms	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 (8004656);

Date: 2024-12-09 17:21:58 Duration: 5ms
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 (8006287);

Date: 2024-12-09 17:21:58 Duration: 5ms
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 (8006401);

Date: 2024-12-09 17:21:58 Duration: 5ms

12

293,126

Details

51s196ms

0ms

5ms

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
Dec 09	00	2,749	346ms	0ms
	01	2,254	291ms	0ms
	02	1,600	202ms	0ms
	03	1,459	192ms	0ms
	04	1,472	195ms	0ms
	05	1,150	153ms	0ms
	06	1,346	187ms	0ms
	07	3,303	470ms	0ms
	08	10,582	1s519ms	0ms
	09	21,231	3s389ms	0ms
	10	26,709	4s721ms	0ms
	11	29,081	5s280ms	0ms
	12	25,574	4s703ms	0ms
	13	23,833	4s180ms	0ms
	14	25,286	4s445ms	0ms
	15	20,813	3s739ms	0ms
	16	17,583	3s71ms	0ms
	17	24,924	4s627ms	0ms
	18	16,871	3s171ms	0ms
	19	11,979	2s251ms	0ms
	20	10,714	1s915ms	0ms
	21	7,800	1s401ms	0ms
	22	4,813	738ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 884 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_cash_policy' AND name = 'group_change_flag_date' AND model = 'res.groups');

Date: 2024-12-09 14:29:08 Duration: 5ms
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: 2024-12-09 17:49:37 Duration: 2ms
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: 2024-12-09 18:42:12 Duration: 1ms

13

275,932

Details

1m7s

0ms

15ms

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
Dec 09	00	4,813	1s76ms	0ms
	01	3,376	1s186ms	0ms
	02	2,434	696ms	0ms
	03	2,613	646ms	0ms
	04	2,083	636ms	0ms
	05	1,588	492ms	0ms
	06	6,354	1s89ms	0ms
	07	3,367	824ms	0ms
	08	5,886	1s453ms	0ms
	09	14,833	3s845ms	0ms
	10	20,850	5s290ms	0ms
	11	33,209	7s424ms	0ms
	12	22,023	5s436ms	0ms
	13	21,634	5s413ms	0ms
	14	20,101	4s630ms	0ms
	15	21,066	4s857ms	0ms
	16	18,771	4s58ms	0ms
	17	16,406	4s277ms	0ms
	18	15,329	4s127ms	0ms
	19	12,635	3s206ms	0ms
	20	14,827	3s642ms	0ms
	21	6,920	1s731ms	0ms
	22	4,814	1s161ms	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 (41334601, 41089493, 40951543, 41298801, 40826884, 41284976, 40870076, 41164482, 41428746, 41076923, 41417088, 41349097, 41040230, 41370057, 41355167, 41470918, 41295121, 40992926, 40980381, 41415005, 41283400, 41293594, 41286355, 41278548, 41280786, 41334142, 40420785, 41321995, 41050741, 41470913, 32644681, 41309604, 41292233, 41162327, 41299785, 41422601, 41454580, 41456236, 32650037, 41363252, 41234338, 41321940, 32648442, 41310927, 40619463, 41305715, 41194053, 40116419, 40377672, 41444096, 41429803, 41422541, 41499460, 41317304, 41473824, 41343915, 41193845);

Date: 2024-12-09 17:21:58 Duration: 15ms
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 (41372624, 41438477, 41372566, 41372330, 41283594, 41135888, 41475595, 41369982, 41480028, 41369772, 41375795, 41457008, 41331437, 41465758, 40872118, 41427791, 41134759, 41456574, 41407296, 41428405, 41283097, 41451850, 41452539, 41450406, 41451578, 41422981, 41376635, 41445271, 41429614, 41381976, 41420374, 41464633, 41479196, 41538643, 41485427, 41225523, 41408000, 41404395, 32650164, 41420402);

Date: 2024-12-09 17:21:58 Duration: 12ms
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 (41215385, 41455339, 41471804, 41521490, 41470846, 41476995, 41284275, 41372479, 41515761, 41413237, 32642423, 41262845, 41162414, 41403166, 41473860, 41512402, 32646856, 41430205, 41376325, 41481859, 41444724, 41366243, 41352433, 41045831);

Date: 2024-12-09 17:21:58 Duration: 12ms

14

264,072

Details

1d7h8m13s

335ms

3s809ms

424ms

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
Dec 09	00	5,975	36m51s	370ms
	01	4,257	25m56s	365ms
	02	6,249	38m17s	367ms
	03	5,285	33m3s	375ms
	04	6,613	40m20s	366ms
	05	4,737	28m23s	359ms
	06	4,420	27m48s	377ms
	07	4,563	28m43s	377ms
	08	5,954	36m11s	364ms
	09	11,119	1h9m42s	376ms
	10	15,361	1h41m33s	396ms
	11	17,060	1h54m5s	401ms
	12	16,450	1h50m	401ms
	13	15,144	1h39m45s	395ms
	14	11,679	1h16m55s	395ms
	15	11,992	1h19m20s	396ms
	16	15,900	1h48m28s	409ms
	17	13,972	1h46m39s	458ms
	18	21,541	2h57m8s	493ms
	19	18,057	2h23m20s	476ms
	20	23,145	3h10m18s	493ms
	21	13,727	1h53m13s	494ms
	22	10,872	1h22m5s	453ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429788)) AND (("shipping_track"."id" not in (27952691, 27952691)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:34 Duration: 3s809ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429739)) AND (("shipping_track"."id" not in (27952551, 27952551)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:04 Duration: 3s583ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429796)) AND (("shipping_track"."id" not in (27952709, 27952709)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:37 Duration: 3s456ms

15

203,161

Details

15s236ms

0ms

1ms

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
Dec 09	00	3,035	185ms	0ms
	01	2,997	189ms	0ms
	02	1,712	107ms	0ms
	03	1,308	99ms	0ms
	04	1,379	95ms	0ms
	05	1,525	101ms	0ms
	06	5,020	285ms	0ms
	07	1,882	123ms	0ms
	08	5,056	298ms	0ms
	09	13,075	832ms	0ms
	10	17,433	1s291ms	0ms
	11	29,094	2s53ms	0ms
	12	18,491	1s465ms	0ms
	13	17,331	1s100ms	0ms
	14	15,815	1s88ms	0ms
	15	15,562	1s20ms	0ms
	16	12,550	909ms	0ms
	17	11,270	971ms	0ms
	18	9,937	874ms	0ms
	19	6,625	549ms	0ms
	20	6,425	734ms	0ms
	21	3,505	544ms	0ms
	22	2,134	316ms	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: 2024-12-09 10:17:09 Duration: 1ms
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: 2024-12-09 17:21:58 Duration: 1ms
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: 2024-12-09 17:21:58 Duration: 1ms

16

169,548

Details

9s687ms

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
Dec 09	00	1,279	56ms	0ms
	01	1,056	50ms	0ms
	02	721	34ms	0ms
	03	545	26ms	0ms
	04	613	31ms	0ms
	05	372	19ms	0ms
	06	806	42ms	0ms
	07	1,609	82ms	0ms
	08	4,467	225ms	0ms
	09	11,254	592ms	0ms
	10	15,858	901ms	0ms
	11	18,142	1s43ms	0ms
	12	16,172	948ms	0ms
	13	14,173	809ms	0ms
	14	15,124	849ms	0ms
	15	12,950	742ms	0ms
	16	10,417	598ms	0ms
	17	14,295	855ms	0ms
	18	9,550	585ms	0ms
	19	7,116	429ms	0ms
	20	6,041	363ms	0ms
	21	4,484	264ms	0ms
	22	2,504	133ms	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: 2024-12-09 12:10:23 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 (98, 99);

Date: 2024-12-09 17:51:51 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 (13);

Date: 2024-12-09 11:18:48 Duration: 0ms

17

162,429

Details

20s269ms

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
Dec 09	00	1,246	118ms	0ms
	01	975	99ms	0ms
	02	721	75ms	0ms
	03	527	56ms	0ms
	04	613	68ms	0ms
	05	358	40ms	0ms
	06	796	90ms	0ms
	07	1,566	177ms	0ms
	08	4,286	475ms	0ms
	09	11,051	1s270ms	0ms
	10	15,406	1s922ms	0ms
	11	17,718	2s215ms	0ms
	12	15,600	1s993ms	0ms
	13	13,533	1s676ms	0ms
	14	14,273	1s736ms	0ms
	15	12,421	1s537ms	0ms
	16	9,905	1s250ms	0ms
	17	13,529	1s771ms	0ms
	18	8,972	1s213ms	0ms
	19	6,676	894ms	0ms
	20	5,633	753ms	0ms
	21	4,231	552ms	0ms
	22	2,393	278ms	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: 2024-12-09 12:10:23 Duration: 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: 2024-12-09 10:37:09 Duration: 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: 2024-12-09 15:36:36 Duration: 0ms

18

159,546

Details

1m26s

0ms

43ms

0ms

select "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" from "shipping_policy" where "shipping_policy".id in (...);

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 09	00	1,375	1s226ms	0ms
	01	1,477	2s136ms	1ms
	02	342	167ms	0ms
	03	141	78ms	0ms
	04	356	154ms	0ms
	05	340	154ms	0ms
	06	950	328ms	0ms
	07	1,133	432ms	0ms
	08	2,008	948ms	0ms
	09	6,039	3s56ms	0ms
	10	9,146	5s477ms	0ms
	11	9,492	5s487ms	0ms
	12	10,831	6s247ms	0ms
	13	13,306	8s308ms	0ms
	14	10,819	6s572ms	0ms
	15	10,889	6s424ms	0ms
	16	9,309	4s998ms	0ms
	17	10,513	5s672ms	0ms
	18	14,278	7s103ms	0ms
	19	6,218	3s144ms	0ms
	20	11,903	5s234ms	0ms
	21	20,979	9s595ms	0ms
	22	7,702	3s555ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3374601, 3372505, 3363033, 3312110, 3144148, 3406311, 3147731, 3285610, 3285631, 3314497, 3320110, 3367970, 3331655, 3333259, 3307082, 3363230, 3369638, 3319146, 3402705, 2730415, 3065286, 3069692, 3147723, 3307967, 3313625, 3316622, 3333276, 2962067, 3370911, 3389620, 3399537, 3402707, 3402692, 3284103, 3284068, 3319580, 3367985, 3332381, 3361586, 3368055, 2459291, 3283436, 3357627, 2835329, 3344813, 3375903, 3336302, 3302388, 3370711, 3334649, 3348579, 3367989, 3361583, 3284126, 3331709, 3247272, 3366422, 3335471, 3367304, 3348648, 3314205, 3314237, 3316253, 3331749, 3335200, 3357728, 3367974, 3368022, 3372443, 3366387, 3319532, 2772629, 3174164, 3275903, 3370763, 3370723, 3357918, 3366354, 3283124, 3389720, 3405442, 3349699, 3405451, 3399165, 2994121, 3352865, 3405452, 3399590, 3332507, 3367292, 3348606, 3370702, 3331681, 3100319, 3210770, 3370690, 3131393, 3068148, 3113218, 3191246, 3285545, 3285633, 3333173, 3325978, 3384246, 3381903, 3345598, 3337304, 3288521, 3326239, 3114047, 3245089, 3316285, 3316294, 3353076, 3366369, 3395473, 3174140, 3361520, 3328071, 3328091, 3285164, 3319150, 3319244, 3369594, 3285126, 3210372, 3369602, 3335208, 3319148, 3329312, 3111705, 3369565, 3349674, 2920600, 3329266, 3332498, 3226153, 3268985, 3307073, 3329508, 3335729, 3370720, 2344285, 3173700, 3277668, 3332408, 3317469, 2938884, 3285639, 3313567, 3316304, 3248570, 3367447, 3248586, 3284496, 3349730, 3248605, 3367495, 3367427, 3318045, 3375246, 3370712, 3285001, 3374194, 3391210, 3112556, 3335473, 3273708, 3377908, 3067934, 3335186, 3112555, 3138279, 3189187, 3242415, 3309990, 3148129, 3332837, 3369978, 3314245, 3249937, 3131915, 3375216, 3285019, 3337217, 3316948, 3147059, 3334218, 3164595, 3348585, 3328470, 3320222, 3332802, 3394799, 3406302, 3277715, 3348671);

Date: 2024-12-09 17:21:59 Duration: 43ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (2188030, 120638, 404752, 1165721, 1291132, 531851, 1165719, 1367564, 1480300, 948349, 1303233, 1165720, 823710, 2942703, 1679144, 376349, 999614, 1141464, 1141455, 990915, 2304665, 2229277, 321996, 612342, 320534, 716021, 2631395, 3162492, 1196902, 180857, 3040728, 2100900, 1241012, 771627, 771637, 303419, 793309, 771625, 771630, 1233026, 1233031, 838045, 1473475, 2357420, 2502990, 534019, 1117893, 2267840, 1872369, 3123654, 2869650, 2409655, 2481152, 2717679, 2034894, 2034897, 1828554, 1730841, 1960516, 1704228, 1872374, 1828543, 1769929, 2158065, 1836458, 3187458, 355192, 553645, 2965955, 2480637, 715564, 1316758, 3010194, 1788670, 1263780, 1430419, 2433399, 1310544, 168731, 898794, 981461, 981458, 3074670, 1018624, 898791, 948441, 898782, 859124, 948437, 1018621, 1018630, 948443, 981468, 2660958, 1018627, 1123744, 6620, 1123771, 1123750, 981452, 898788, 892169, 1732954, 2098382, 2184465, 1824928, 3221489, 1022858, 1022857, 408850, 1730854, 741572, 2030932, 2363268, 3160293, 1369398, 2113982, 2113912, 947490, 1559181, 1844096, 2106810, 2593889, 1543786, 1679418, 1939509, 2248140, 2500311, 2567524, 1992471, 1398502, 1256020, 361977, 519918, 1722978, 1722979, 3058847, 2710694, 913120, 763337, 416977, 1805533, 2369530, 2342910, 2442800, 763338, 1143690, 2629410, 3053768, 1861398, 1732959, 1338585, 1439044, 1612350, 211532, 1130765, 1820048, 1992288, 1992290, 926373, 1373754, 849790, 1549413, 486149, 617989, 617991, 215440, 2574482, 1638574, 2057537, 772687, 3188598, 2573523, 366960, 1670413, 2694892, 1011248, 685511, 572556, 365364, 508297, 572554, 2301427, 955734, 1110341, 1110310, 1027266, 170523, 1008186, 242014, 242020, 737953, 857559, 727743, 727746, 656485);

Date: 2024-12-09 17:21:59 Duration: 25ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (1626361, 1846971, 1170998, 2834807, 1478720, 1414154, 1412253, 1895882, 1130123, 1539097, 3190790, 3022897, 2269576, 1339464, 730099, 2082791, 1297824, 1171023, 2880658, 2880591, 2447121, 653554, 127757, 953358, 617070, 172255, 385737, 1696880, 978472, 157591, 1707417, 776726, 1676537, 2764210, 748731, 130682, 3354798, 2988415, 1130797, 1622271, 614274, 2760160, 2112837, 1628592, 1130450, 2280751, 347392, 1412695, 1974319, 1665195, 580462, 1845619, 1628580, 3218327, 2880783, 172259, 1052851, 2823126, 2291039, 1588906, 1370583, 2234005, 1317557, 2764639, 917192, 2764631, 2880997, 2442483, 226665, 278781, 2231346, 2442481, 1676915, 182088, 1810390, 2439785, 1025344, 501476, 518693, 1091646, 1895877, 2568544, 1813511, 262524, 2817326, 766928, 1317092, 171582, 841780, 127758, 2880533, 1879978, 919944, 2928654, 2764446, 1478790, 766934, 1591255, 958079, 1923724, 459793, 1317464, 3220398, 305233, 2112879, 3265080, 452767, 2764518, 2415584, 1475969, 993442, 2161735, 1170903, 870124, 226070, 1667440, 2960055, 420559, 3098614, 1660981, 182087, 2925731, 575804, 303402, 2169981, 2863546, 692169, 1448154, 3186425, 1672141, 2003435, 2535444, 1127967, 1445403, 26686, 1707567, 2669320, 1172577, 1407175, 3091371, 962321, 454954, 2197747, 142646, 1448157, 3131774, 958103, 518837, 3222591, 1279687, 1170857, 3263279, 305261, 1676615, 805089, 1279671, 1192432, 275242, 2764634, 172261, 1688212, 1172250, 1192431, 1181810, 1684837, 2125785, 1590263, 404514, 1591252, 1172748, 2943463, 1764745, 2760455, 1734447, 383969, 3056149, 26685, 1661181, 366304, 1052849, 447211, 2707168, 1707423, 919918, 409745, 1317088, 2414268, 2534376, 178106, 1243516, 3091356, 1707442);

Date: 2024-12-09 17:22:46 Duration: 14ms

19

157,336

Details

50s665ms

0ms

1ms

0ms

select "price_list".id from "price_list" where (("price_list"."from_office_id" = ?) and ("price_list"."to_office_id" = ?)) order by "price_list"."id";

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 09	00	5,148	1s598ms	0ms
	01	2,731	1s32ms	0ms
	02	4,315	1s529ms	0ms
	03	6,381	1s866ms	0ms
	04	4,571	1s609ms	0ms
	05	1,799	840ms	0ms
	06	5,552	1s604ms	0ms
	07	5,776	1s670ms	0ms
	08	2,641	1s31ms	0ms
	09	1,853	812ms	0ms
	10	3,640	1s309ms	0ms
	11	2,335	972ms	0ms
	12	1,309	645ms	0ms
	13	1,908	748ms	0ms
	14	3,990	1s255ms	0ms
	15	3,284	1s75ms	0ms
	16	7,000	2s188ms	0ms
	17	10,945	3s412ms	0ms
	18	15,737	5s112ms	0ms
	19	19,992	6s72ms	0ms
	20	26,163	8s150ms	0ms
	21	10,561	3s432ms	0ms
	22	9,705	2s692ms	0ms

SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 64) AND ("price_list"."to_office_id" = 60)) ORDER BY "price_list"."id";

Date: 2024-12-09 17:22:02 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 64) AND ("price_list"."to_office_id" = 36)) ORDER BY "price_list"."id";

Date: 2024-12-09 12:01:53 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 60) AND ("price_list"."to_office_id" = 36)) ORDER BY "price_list"."id";

Date: 2024-12-09 11:45:58 Duration: 1ms

20

155,950

Details

1h50m38s

29ms

409ms

42ms

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
Dec 09	00	2,493	1m32s	37ms
	01	1,189	44s892ms	37ms
	02	1,903	1m12s	38ms
	03	1,546	58s60ms	37ms
	04	2,057	1m17s	37ms
	05	1,178	44s566ms	37ms
	06	1,782	1m7s	37ms
	07	1,522	57s777ms	37ms
	08	2,876	1m49s	37ms
	09	7,221	4m43s	39ms
	10	11,398	7m42s	40ms
	11	13,086	8m58s	41ms
	12	13,168	9m1s	41ms
	13	12,262	8m16s	40ms
	14	9,078	6m3s	40ms
	15	10,018	6m43s	40ms
	16	12,378	8m27s	41ms
	17	8,838	6m42s	45ms
	18	11,503	9m23s	48ms
	19	10,609	8m19s	47ms
	20	11,760	9m29s	48ms
	21	5,169	4m8s	48ms
	22	2,916	2m13s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3399089)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 17:21:59 Duration: 409ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3323129)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 21:34:11 Duration: 169ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3392704)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 21:34:20 Duration: 137ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

15m15s

44s872ms

39

Details

29m10s

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
Dec 09	00	1	1ms	1ms
	08	7	1ms	0ms
	09	2	0ms	0ms
	10	3	3ms	1ms
	11	2	3ms	1ms
	12	5	5ms	1ms
	13	1	1ms	1ms
	14	4	1m13s	18s266ms
	15	3	15m15s	5m5s
	16	2	0ms	0ms
	17	4	12m41s	3m10s
	18	2	5ms	2ms
	19	1	1ms	1ms
	21	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-09 15:01:05.356245', "last_update" = '2024-12-09 14:16:05.356270', "write_date" = '2024-12-09 14:16:04.979791', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-09 15:31:20 Duration: 15m15s
UPDATE "res_users" SET "exp_date" = '2024-12-09 17:08:39.189009', "last_update" = '2024-12-09 16:23:39.189035', "write_date" = '2024-12-09 16:23:38.837794', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-09 17:36:20 Duration: 12m41s
UPDATE "res_users" SET "exp_date" = '2024-12-09 13:48:07.383257', "last_update" = '2024-12-09 13:03:07.383301', "write_date" = '2024-12-09 13:03:07.045503', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-09 14:04:20 Duration: 1m13s

2

0ms

19m11s

21s82ms

401

Details

2h20m54s

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
Dec 09	00	7	19m11s	2m44s
	01	8	2ms	0ms
	03	1	0ms	0ms
	05	5	2ms	0ms
	06	1	0ms	0ms
	07	9	1ms	0ms
	08	24	4ms	0ms
	09	40	45m44s	1m8s
	10	38	9m37s	15s203ms
	11	40	42ms	1ms
	12	29	39ms	1ms
	13	27	29ms	1ms
	14	28	1m31s	3s283ms
	15	28	1m26s	3s85ms
	16	28	19ms	0ms
	17	19	9m58s	31s481ms
	18	11	17ms	1ms
	19	21	25ms	1ms
	20	26	21m1s	48s521ms
	21	8	32m21s	4m2s
	22	3	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-08 23:56:56.575266', "last_update" = '2024-12-08 23:11:56.575285', "sid" = '9167d8a563060eacc6ab128cd109faf9a9b6d4c7', "write_date" = '2024-12-08 23:11:56.247100', "write_uid" = 1 WHERE id IN (1295);

Date: 2024-12-09 00:31:08 Duration: 19m11s
UPDATE "res_users" SET "exp_date" = '2024-12-09 08:54:08.194209', "last_update" = '2024-12-09 08:09:08.194233', "sid" = 'f02d3833e8b9b4863d43e1f3a764a8aa6b52b23c', "write_date" = '2024-12-09 08:09:07.858900', "write_uid" = 988 WHERE id IN (988);

Date: 2024-12-09 09:23:20 Duration: 14m12s
UPDATE "res_users" SET "exp_date" = '2024-12-09 20:53:59.948335', "last_update" = '2024-12-09 20:08:59.948354', "sid" = '31a1316d66ea9239b87f60e158ffd9ab3bfd8861', "write_date" = '2024-12-09 20:08:59.627045', "write_uid" = 870 WHERE id IN (870);

Date: 2024-12-09 21:21:20 Duration: 12m20s

3

0ms

59m59s

3s793ms

84,969

Details

3d17h31m29s

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
Dec 09	00	1,001	229ms	0ms
	01	892	59m23s	3s994ms
	02	786	59m59s	4s579ms
	03	693	146ms	0ms
	04	711	30s661ms	43ms
	05	621	133ms	0ms
	06	572	119ms	0ms
	07	599	127ms	0ms
	08	1,896	880ms	0ms
	09	5,149	6h35m30s	4s608ms
	10	7,124	5h2m4s	2s544ms
	11	8,603	10h51m19s	4s542ms
	12	8,622	12h59m50s	5s426ms
	13	7,710	7h42m	3s595ms
	14	8,321	7h5m9s	3s65ms
	15	7,783	10h39m38s	4s931ms
	16	6,161	3m21s	32ms
	17	5,631	6h10m9s	3s944ms
	18	4,079	4h1m11s	3s547ms
	19	2,876	21m41s	452ms
	20	2,724	5h4m5s	6s698ms
	21	1,481	3h40m44s	8s942ms
	22	934	7h14m47s	27s931ms

update res_users set sid = '01dc60f876dd9ad3502857db5435af0d4c09feb1', last_update = '2024-12-09 00:31:01.844167', exp_date = '2024-12-09 01:16:01.844170', logged_in = 'TRUE' where id = 847;

Date: 2024-12-09 02:31:01 Duration: 59m59s
update res_users set sid = '05ccb87c8a7256133a24a33c19ee11c3dffd30c4', last_update = '2024-12-08 23:09:30.694749', exp_date = '2024-12-08 23:54:30.694752', logged_in = 'TRUE' where id = 1096;

Date: 2024-12-09 01:08:53 Duration: 59m23s
update res_users set sid = '166d828c31706b579900b652d7de37a79982c7be', last_update = '2024-12-09 13:47:23.837875', exp_date = '2024-12-09 14:32:23.837877', logged_in = 'TRUE' where id = 849;

Date: 2024-12-09 15:31:20 Duration: 43m56s

4

2s311ms

4s973ms

3s427ms

1,015

Details

57m58s

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."v_10_id" = ?)) order by "res_partner"."display_name" asc, "res_partner"."id" desc limit ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 09	00	56	2m51s	3s67ms
	01	56	2m44s	2s935ms
	02	57	2m52s	3s20ms
	03	56	2m55s	3s134ms
	04	56	2m51s	3s55ms
	05	57	2m53s	3s36ms
	06	56	2m57s	3s163ms
	07	56	2m48s	3s9ms
	08	54	2m51s	3s183ms
	09	55	3m14s	3s538ms
	10	53	3m20s	3s775ms
	11	53	3m21s	3s802ms
	12	55	3m28s	3s794ms
	13	53	3m25s	3s886ms
	14	46	2m50s	3s706ms
	15	51	3m10s	3s733ms
	16	58	3m41s	3s824ms
	17	49	3m6s	3s811ms
	18	38	2m32s	4s10ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-09 11:55:09 Duration: 4s973ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-09 16:14:55 Duration: 4s848ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-09 12:02:52 Duration: 4s823ms

5

0ms

4m43s

1s38ms

1,084

Details

18m46s

update "shipping_policy" set "archive_date" = ?, "state" = ?, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 09	07	8	15ms	1ms
	08	32	52ms	1ms
	09	89	293ms	3ms
	10	109	445ms	4ms
	11	103	459ms	4ms
	12	107	439ms	4ms
	13	137	508ms	3ms
	14	132	331ms	2ms
	15	75	348ms	4ms
	16	105	3m9s	1s806ms
	17	102	569ms	5ms
	18	65	6m58s	6s436ms
	19	20	8m34s	25s727ms

UPDATE "shipping_policy" SET "archive_date" = '2024-12-09', "state" = 'archive', "write_date" = '2024-12-09 18:15:16.101222', "write_uid" = 1102 WHERE id IN (3111133, 3134576, 3171481, 3184274, 3188121, 3188283, 3204357, 3214454, 3224307, 3233077, 3243926, 3255864, 3257680, 3259156, 3259278, 3260913, 3260978, 3261797);

Date: 2024-12-09 19:20:27 Duration: 4m43s
UPDATE "shipping_policy" SET "archive_date" = '2024-12-09', "state" = 'archive', "write_date" = '2024-12-09 15:11:08.163653', "write_uid" = 1102 WHERE id IN (2820757, 2895066, 2937660, 3046723, 3074998, 3106561, 3117975, 3131769, 3133328, 3135352, 3155500, 3163620, 3173724, 3176655, 3178641, 3182724, 3182849, 3182859, 3184091, 3184310, 3188696, 3191764, 3194121, 3194991, 3195010, 3197096, 3199054, 3200797, 3202656, 3205741, 3205942, 3208730, 3212265, 3212428, 3212811, 3213432, 3213437, 3213497, 3213675, 3214169, 3214212, 3214926, 3215031, 3215287, 3216122, 3216208, 3216424, 3216979, 3217546, 3217743, 3218289, 3218545, 3218584, 3219661, 3219772, 3219958, 3220222, 3220322, 3220446, 3221135, 3221389, 3221498, 3221638, 3221702, 3221712, 3221717, 3221725, 3222188, 3222500, 3222559, 3222617, 3223095, 3223302, 3224442, 3224585, 3224790, 3225179, 3225212, 3225333, 3225335, 3226093, 3227950, 3228470, 3228557, 3228573, 3228575, 3229847, 3229928, 3229997, 3230051, 3231135, 3231234, 3231276, 3231575, 3231595, 3231611, 3231637, 3232016, 3233924, 3234732, 3234965, 3234982, 3235510, 3235570, 3236367, 3236383, 3236398, 3236404, 3236442, 3240100, 3240170, 3240194, 3240235, 3240269, 3240983, 3241128, 3241141, 3241192, 3241341, 3241358, 3241363, 3241751, 3241915, 3241930, 3241987, 3242059, 3242060, 3242067, 3242071, 3242088, 3242111, 3242621, 3242750, 3243378, 3243401, 3243410, 3243486, 3243526, 3243529, 3243536, 3243758, 3243768, 3243813, 3243980, 3244003, 3244014, 3244019, 3244026, 3244035, 3244049, 3244066, 3244067, 3244075, 3244099, 3244100, 3244137, 3244163, 3244165, 3245302, 3245341, 3247733, 3247740, 3247789, 3247881, 3249095, 3250790, 3250803, 3250828, 3251289, 3251459, 3251467, 3251470, 3251473, 3251479, 3251757, 3251922, 3251936, 3251959, 3251970, 3251992, 3252116, 3252216, 3252276, 3252520, 3252552, 3252561, 3252603, 3252716, 3252874, 3252946, 3252948, 3252957, 3252961, 3252964, 3253055, 3253147, 3253157, 3253186, 3253209, 3253232, 3253235, 3253279, 3253354, 3253359, 3253428, 3253429, 3253518, 3253840, 3253919, 3253936, 3253997, 3254035, 3254132, 3254134, 3254136, 3254139, 3254514, 3254713, 3254776, 3254808, 3254809, 3254819, 3254868, 3254955, 3255027, 3255098, 3255578, 3255605, 3255706, 3255710, 3255715, 3255728, 3255753, 3255855, 3255857, 3255860, 3255870, 3256015, 3256031, 3256369, 3256523, 3256619, 3256782, 3256828, 3257068, 3257191, 3257229, 3257241, 3257265, 3257269, 3257295, 3257457, 3257461, 3257581, 3257611, 3257620, 3257637, 3257683, 3257819, 3257840, 3257939, 3257943, 3258255, 3258263, 3258306, 3258479, 3258485, 3258490, 3258572, 3258678, 3258685, 3258690, 3258791, 3258876, 3258901, 3258903, 3258988, 3259076, 3259134, 3259179, 3259847, 3259861, 3259878, 3260010, 3260231, 3260235, 3260318, 3260391, 3260432, 3260664, 3260665, 3260674, 3260676, 3260693, 3260891, 3260904, 3260951, 3261130, 3261167, 3261265, 3261278, 3261317, 3261441, 3261449, 3261453, 3261461, 3261479, 3261526, 3261539, 3261590, 3261600, 3261649, 3261666, 3261667, 3261669, 3261670, 3261703, 3261711, 3261871, 3261876, 3261951, 3262149, 3262238, 3262242, 3262249, 3262268, 3262281, 3262297, 3262329, 3262336, 3262374, 3262391, 3262396, 3262483, 3262626, 3262629, 3262685, 3262686, 3262691, 3262701, 3262723, 3262725, 3262757, 3262930, 3263012, 3263120, 3263135, 3263194, 3263228, 3263243, 3263260, 3263734, 3263750, 3263778, 3263860, 3263923, 3263956, 3263975, 3263980, 3264025, 3264102, 3264119, 3264136, 3264157, 3264176, 3264339);

Date: 2024-12-09 16:18:06 Duration: 3m8s
UPDATE "shipping_policy" SET "archive_date" = '2024-12-09', "state" = 'archive', "write_date" = '2024-12-09 17:49:57.199949', "write_uid" = 1102 WHERE id IN (3111133, 3134576, 3171481, 3184274, 3188121, 3188283, 3204357, 3214454, 3224307, 3233077, 3243926, 3255864, 3257680, 3259156, 3259278, 3260913, 3260978, 3261797);

Date: 2024-12-09 18:53:05 Duration: 2m41s

6

269ms

2s113ms

1s34ms

11,642

Details

3h20m47s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	130	2m4s	955ms
	01	47	45s271ms	963ms
	02	2	2s48ms	1s24ms
	09	5	4s684ms	936ms
	10	1	1s93ms	1s93ms
	12	3	3s114ms	1s38ms
	13	47	47s498ms	1s10ms
	14	78	1m21s	1s50ms
	15	181	3m	998ms
	16	307	5m23s	1s54ms
	17	1,062	18m44s	1s58ms
	18	1,593	28m58s	1s91ms
	19	2,253	37m8s	988ms
	20	3,814	1h7m34s	1s63ms
	21	1,471	24m18s	991ms
	22	648	10m29s	970ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9194257')) 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 (26))))))) 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 (26)))))) 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 (26)))))) 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 (26))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-09 21:33:53 Duration: 2s113ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9266827')) 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 (30))))))) 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 (30)))))) 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 (30)))))) 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 (30))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-09 21:35:35 Duration: 2s77ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9297903')) 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 (14, 74, 70))))))) 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 (14, 74, 70)))))) 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 (14, 74, 70)))))) 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 (14, 74, 70))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-09 21:33:56 Duration: 2s40ms

7

335ms

3s809ms

424ms

264,072

Details

1d7h8m13s

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
Dec 09	00	5,975	36m51s	370ms
	01	4,257	25m56s	365ms
	02	6,249	38m17s	367ms
	03	5,285	33m3s	375ms
	04	6,613	40m20s	366ms
	05	4,737	28m23s	359ms
	06	4,420	27m48s	377ms
	07	4,563	28m43s	377ms
	08	5,954	36m11s	364ms
	09	11,119	1h9m42s	376ms
	10	15,361	1h41m33s	396ms
	11	17,060	1h54m5s	401ms
	12	16,450	1h50m	401ms
	13	15,144	1h39m45s	395ms
	14	11,679	1h16m55s	395ms
	15	11,992	1h19m20s	396ms
	16	15,900	1h48m28s	409ms
	17	13,972	1h46m39s	458ms
	18	21,541	2h57m8s	493ms
	19	18,057	2h23m20s	476ms
	20	23,145	3h10m18s	493ms
	21	13,727	1h53m13s	494ms
	22	10,872	1h22m5s	453ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429788)) AND (("shipping_track"."id" not in (27952691, 27952691)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:34 Duration: 3s809ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429739)) AND (("shipping_track"."id" not in (27952551, 27952551)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:04 Duration: 3s583ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3429796)) AND (("shipping_track"."id" not in (27952709, 27952709)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:37 Duration: 3s456ms

8

339ms

2s451ms

421ms

47,688

Details

5h34m52s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 09	00	309	1m57s	381ms
	01	227	1m29s	396ms
	02	383	2m26s	382ms
	03	118	49s217ms	417ms
	04	185	1m15s	408ms
	05	291	1m51s	382ms
	06	394	2m27s	374ms
	07	602	3m41s	368ms
	08	1,007	6m16s	374ms
	09	2,588	16m40s	386ms
	10	3,781	25m43s	408ms
	11	4,341	29m50s	412ms
	12	4,177	28m46s	413ms
	13	5,419	36m13s	401ms
	14	3,788	25m13s	399ms
	15	3,274	22m4s	404ms
	16	3,828	26m8s	409ms
	17	3,255	24m49s	457ms
	18	2,518	20m25s	486ms
	19	2,992	22m57s	460ms
	20	2,184	17m40s	485ms
	21	1,089	8m56s	492ms
	22	938	7m7s	455ms

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

Date: 2024-12-09 21:34:11 Duration: 2s451ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3349795)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 21:34:22 Duration: 2s209ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2897829)) ORDER BY "shipping_track"."id";

Date: 2024-12-09 17:22:01 Duration: 2s184ms

9

227ms

2s159ms

335ms

23,237

Details

2h9m49s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	889	4m20s	292ms
	01	290	1m24s	289ms
	02	601	2m54s	290ms
	03	1,307	6m19s	290ms
	04	639	3m5s	289ms
	06	1,151	5m38s	294ms
	07	1,209	5m52s	291ms
	08	282	1m23s	296ms
	09	113	33s809ms	299ms
	10	725	3m56s	326ms
	11	305	1m38s	321ms
	12	52	16s810ms	323ms
	13	240	1m17s	321ms
	14	870	4m32s	313ms
	15	559	2m58s	318ms
	16	1,380	7m22s	320ms
	17	1,674	9m53s	354ms
	18	2,370	14m43s	372ms
	19	2,794	16m27s	353ms
	20	2,782	16m49s	363ms
	21	1,202	8m8s	406ms
	22	1,803	10m11s	338ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9359922')) 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: 2024-12-09 21:35:37 Duration: 2s159ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9215497')) 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: 2024-12-09 21:34:34 Duration: 2s112ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9217885')) 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: 2024-12-09 21:33:35 Duration: 1s996ms

10

188ms

472ms

268ms

24,283

Details

1h48m32s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	07	111	27s436ms	247ms
	08	828	3m24s	247ms
	09	1,228	5m12s	254ms
	10	2,188	9m47s	268ms
	11	1,566	7m9s	274ms
	12	2,199	9m52s	269ms
	13	2,983	13m18s	267ms
	14	2,297	10m2s	262ms
	15	4,008	17m32s	262ms
	16	3,092	13m54s	269ms
	17	2,926	13m50s	283ms
	18	857	4m	280ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9249901')))) ORDER BY "collection_policy"."id";

Date: 2024-12-09 17:48:29 Duration: 472ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9249955')))) ORDER BY "collection_policy"."id";

Date: 2024-12-09 17:48:29 Duration: 443ms
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" = '9132680')))) ORDER BY "collection_policy"."id";

Date: 2024-12-09 18:30:55 Duration: 409ms

11

195ms

341ms

263ms

4,477

Details

19m38s

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" = ?) and ((((("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 "collection_policy"."id";

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 09	09	130	33s218ms	255ms
	10	629	2m42s	257ms
	11	1,285	5m36s	262ms
	12	261	1m8s	263ms
	13	712	3m5s	260ms
	14	819	3m33s	260ms
	15	217	59s449ms	273ms
	16	424	1m58s	280ms

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" = '471036') AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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 "collection_policy"."id";

Date: 2024-12-09 14:36:15 Duration: 341ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '8998308') AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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 "collection_policy"."id";

Date: 2024-12-09 16:00:44 Duration: 336ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9164797') AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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 "collection_policy"."id";

Date: 2024-12-09 11:14:19 Duration: 331ms

12

97ms

1s155ms

255ms

68,620

Details

4h52m20s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	1,966	7m30s	229ms
	01	622	2m27s	236ms
	02	1,198	5m17s	265ms
	03	2,574	11m22s	265ms
	04	1,258	5m44s	274ms
	06	2,295	8m43s	227ms
	07	2,401	9m18s	232ms
	08	548	2m1s	221ms
	09	228	59s941ms	262ms
	10	1,378	6m8s	267ms
	11	589	2m21s	239ms
	12	103	25s256ms	245ms
	13	548	2m22s	259ms
	14	1,844	8m35s	279ms
	15	1,454	6m11s	255ms
	16	3,346	13m48s	247ms
	17	5,413	24m23s	270ms
	18	7,812	34m11s	262ms
	19	9,934	42m25s	256ms
	20	13,033	57m14s	263ms
	21	5,220	21m57s	252ms
	22	4,856	18m49s	232ms

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

Date: 2024-12-09 17:22:01 Duration: 1s155ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مروه')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-09 19:14:45 Duration: 943ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مريم')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-09 19:14:45 Duration: 943ms

13

182ms

1s651ms

239ms

126,788

Details

8h25m33s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	1,265	4m19s	205ms
	01	1,564	5m17s	202ms
	02	2,101	7m8s	203ms
	03	2,374	8m1s	202ms
	04	1,732	5m54s	204ms
	05	1,678	5m43s	204ms
	06	2,144	7m21s	206ms
	07	1,314	4m30s	205ms
	08	2,900	9m56s	205ms
	09	5,779	20m22s	211ms
	10	5,120	19m1s	222ms
	11	5,029	18m47s	224ms
	12	6,077	23m3s	227ms
	13	7,966	29m13s	220ms
	14	5,771	21m12s	220ms
	15	8,363	30m31s	219ms
	16	7,575	28m4s	222ms
	17	9,179	36m46s	240ms
	18	10,333	43m9s	250ms
	19	7,299	30m10s	248ms
	20	6,939	30m28s	263ms
	21	22,041	1h47m21s	292ms
	22	2,245	9m6s	243ms

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" = '9104177')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-09 21:34:33 Duration: 1s651ms
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" = '8956421')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-09 21:34:45 Duration: 1s572ms
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" = '9265162')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-09 21:35:31 Duration: 1s407ms

14

188ms

300ms

218ms

5,405

Details

19m40s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	06	621	2m7s	205ms
	07	287	59s69ms	205ms
	08	253	52s81ms	205ms
	09	212	44s455ms	209ms
	10	580	2m8s	221ms
	11	835	3m3s	219ms
	12	262	57s895ms	220ms
	13	622	2m16s	218ms
	14	794	2m51s	215ms
	15	137	31s126ms	227ms
	16	424	1m38s	232ms
	17	82	19s881ms	242ms
	19	152	35s636ms	234ms
	20	144	34s931ms	242ms

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" = '8737467')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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: 2024-12-09 17:54:58 Duration: 300ms
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" = '8839890')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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: 2024-12-09 16:01:04 Duration: 299ms
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" = '8759365')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".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, 95, 128, 83, 112))))) 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: 2024-12-09 10:18:22 Duration: 287ms

15

183ms

816ms

215ms

10,677

Details

38m19s

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
Dec 09	00	252	51s753ms	205ms
	01	129	25s379ms	196ms
	02	206	41s560ms	201ms
	03	92	18s559ms	201ms
	04	483	1m39s	205ms
	05	527	1m48s	205ms
	06	660	2m15s	206ms
	07	515	1m45s	204ms
	08	857	2m54s	203ms
	09	1,396	4m56s	212ms
	10	742	2m43s	220ms
	11	314	1m9s	222ms
	12	789	2m51s	217ms
	13	850	3m5s	218ms
	14	275	59s772ms	217ms
	15	1,242	4m33s	220ms
	16	473	1m41s	214ms
	17	6	1s486ms	247ms
	18	272	1m11s	262ms
	19	26	6s246ms	240ms
	20	287	1m13s	255ms
	21	269	1m2s	231ms
	22	15	3s707ms	247ms

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" = '8920946')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) 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: 2024-12-09 21:35:37 Duration: 816ms
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" = '9167572')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) 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: 2024-12-09 21:35:38 Duration: 380ms
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" = '8843950')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) 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: 2024-12-09 21:35:36 Duration: 346ms

16

182ms

244ms

204ms

10,673

Details

36m25s

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
Dec 09	00	912	3m6s	204ms
	01	986	3m21s	204ms
	02	1,855	6m18s	204ms
	03	2,256	7m37s	202ms
	04	1,235	4m12s	204ms
	05	1,085	3m41s	204ms
	06	850	2m56s	207ms
	07	271	56s398ms	208ms
	08	972	3m20s	206ms
	09	251	54s127ms	215ms

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" = '9225106')) 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: 2024-12-09 09:03:01 Duration: 244ms
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" = '9266315')) 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: 2024-12-09 09:03:22 Duration: 243ms
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" = '9306798')) 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: 2024-12-09 09:02:57 Duration: 243ms

17

71ms

230ms

88ms

25,580

Details

37m36s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	517	40s931ms	79ms
	05	21	1s818ms	86ms
	06	13	1s68ms	82ms
	07	72	6s173ms	85ms
	08	203	17s60ms	84ms
	09	960	1m21s	84ms
	10	3,078	4m22s	85ms
	11	3,149	4m32s	86ms
	12	2,243	3m17s	88ms
	13	2,370	3m29s	88ms
	14	2,015	2m55s	87ms
	15	2,866	4m9s	86ms
	16	3,207	4m44s	88ms
	17	1,648	2m30s	91ms
	18	852	1m22s	96ms
	19	724	1m8s	94ms
	20	1,084	1m43s	95ms
	21	489	44s645ms	91ms
	22	69	6s585ms	95ms

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

Date: 2024-12-09 17:23:22 Duration: 230ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7792559)) AND (("cash_track"."id" not in (5520353, 5523236, 5524158, 5524740, 5524740)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-09 21:35:08 Duration: 173ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7761240)) AND (("cash_track"."id" not in (5295809, 5336219, 5368680, 5524758, 5524758)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-09 21:35:11 Duration: 172ms

18

29ms

409ms

42ms

155,950

Details

1h50m38s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	2,493	1m32s	37ms
	01	1,189	44s892ms	37ms
	02	1,903	1m12s	38ms
	03	1,546	58s60ms	37ms
	04	2,057	1m17s	37ms
	05	1,178	44s566ms	37ms
	06	1,782	1m7s	37ms
	07	1,522	57s777ms	37ms
	08	2,876	1m49s	37ms
	09	7,221	4m43s	39ms
	10	11,398	7m42s	40ms
	11	13,086	8m58s	41ms
	12	13,168	9m1s	41ms
	13	12,262	8m16s	40ms
	14	9,078	6m3s	40ms
	15	10,018	6m43s	40ms
	16	12,378	8m27s	41ms
	17	8,838	6m42s	45ms
	18	11,503	9m23s	48ms
	19	10,609	8m19s	47ms
	20	11,760	9m29s	48ms
	21	5,169	4m8s	48ms
	22	2,916	2m13s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3399089)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 17:21:59 Duration: 409ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3323129)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 21:34:11 Duration: 169ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3392704)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-09 21:34:20 Duration: 137ms

19

32ms

212ms

42ms

75,384

Details

53m8s

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
Dec 09	00	141	5s647ms	40ms
	01	18	712ms	39ms
	02	9	387ms	43ms
	04	13	536ms	41ms
	05	5	216ms	43ms
	06	12	476ms	39ms
	07	178	6s949ms	39ms
	08	762	29s874ms	39ms
	09	3,164	2m8s	40ms
	10	5,242	3m41s	42ms
	11	4,612	3m15s	42ms
	12	5,004	3m34s	42ms
	13	6,569	4m37s	42ms
	14	5,169	3m36s	41ms
	15	8,167	5m38s	41ms
	16	12,788	9m11s	43ms
	17	5,783	4m5s	42ms
	18	10,505	7m31s	42ms
	19	6,499	4m30s	41ms
	20	492	22s84ms	44ms
	21	139	6s661ms	47ms
	22	113	4s772ms	42ms

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

Date: 2024-12-09 21:33:42 Duration: 212ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2939157) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-09 21:35:20 Duration: 185ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3358802) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-09 21:35:30 Duration: 120ms

20

0ms

14s976ms

2ms

942,110

Details

35m57s

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

Day	Hour	Count	Duration	Avg duration
Dec 09	00	14,674	2s237ms	0ms
	01	14,296	1s911ms	0ms
	02	9,462	1s534ms	0ms
	03	7,418	1s171ms	0ms
	04	8,186	1s300ms	0ms
	05	8,712	1s339ms	0ms
	06	13,440	1s972ms	0ms
	07	10,940	1s647ms	0ms
	08	26,699	3s709ms	0ms
	09	61,761	8s436ms	0ms
	10	82,267	11s546ms	0ms
	11	107,890	14s196ms	0ms
	12	88,156	13s304ms	0ms
	13	84,226	12s106ms	0ms
	14	75,786	10s344ms	0ms
	15	69,933	12s96ms	0ms
	16	62,834	12s128ms	0ms
	17	54,855	7s958ms	0ms
	18	46,312	7s49ms	0ms
	19	32,080	33m41s	63ms
	20	31,950	4s872ms	0ms
	21	18,672	2s781ms	0ms
	22	11,561	1s764ms	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 (1075);

Date: 2024-12-09 19:04:47 Duration: 14s976ms
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 (1295);

Date: 2024-12-09 19:02:16 Duration: 14s903ms
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 (852);

Date: 2024-12-09 19:02:16 Duration: 14s899ms

Time consuming prepare


Date: 2024-12-09 17:21:59
Duration: 3ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 3ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 0ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 0ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 2ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 0ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 0ms
Database: postgres

Time consuming bind


Date: 2024-12-09 18:42:11
Duration: 6ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 3ms
Database: postgres
Date: 2024-12-09 22:12:45
Duration: 0ms
Database: postgres
Date: 2024-12-09 19:52:02
Duration: 0ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 0ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 0ms
Database: postgres
Date: 2024-12-09 17:21:59
Duration: 0ms
Database: postgres

Log levels

Key values

23,061,333 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	16	0.00%
DETAIL	20,046	0.09%
ERROR	11,445	0.05%
FATAL	21,166	0.09%
HINT	11	0.00%
LOG	22,998,242	99.73%
STATEMENT	10,407	0.05%

Events distribution

Key values

0 PANIC entries
21166 FATAL entries
11485 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

20,024 Max number of times the same event was reported
32,651 Total events found

Rank

Times reported

Error

1

20,024

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 09	03	3
	04	1,436
	05	3,234
	06	4,239
	07	4,983
	08	3,067
	09	3,062

FATAL: password authentication failed for user "postgres"

2

5,341

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 09	00	23
	01	37
	02	30
	03	8
	04	14
	05	3
	06	13
	07	8
	08	195
	09	143
	10	259
	11	376
	12	678
	13	425
	14	876
	15	743
	16	405
	17	494
	18	150
	19	179
	20	129
	21	117
	22	36

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

4,962

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 09	00	15
	01	35
	02	27
	03	3
	04	10
	05	1
	06	10
	07	8
	08	179
	09	126
	10	247
	11	350
	12	642
	13	408
	14	827
	15	715
	16	371
	17	473
	18	129
	19	159
	20	96
	21	99
	22	32

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

961

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 09	00	1
	01	1
	09	51
	10	51
	11	113
	12	70
	13	25
	14	146
	15	88
	17	191
	18	84
	19	31
	20	57
	21	23
	22	29

ERROR: could not send data to client: Broken pipe
ERROR: could not send data to client: Broken pipe

5

961

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 09	00	1
	01	1
	09	51
	10	51
	11	113
	12	70
	13	25
	14	146
	15	88
	17	191
	18	84
	19	31
	20	57
	21	23
	22	29

6

145

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 09	09	8
	10	8
	11	23
	12	18
	13	4
	14	21
	15	23
	17	19
	18	8
	19	5
	20	5
	21	2
	22	1

7

89

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 09	17	89

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

8

36

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 09	17	36

9

24

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 09	17	24

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

10

22

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 09	22	22

ERROR: column change_password_user.is_session does not exist at character 461
ERROR: column change_password_user.is_session does not exist at character 461
ERROR: column change_password_user.is_session does not exist at character 461

11

15

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 09	00	1
	10	7
	11	1
	14	3
	17	1
	20	2

ERROR: syntax error at or near ")" at character 163
ERROR: syntax error at or near ")" at character 159
ERROR: syntax error at or near ")" at character 300

12

11

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 09	09	1
	12	1
	13	5
	14	2
	15	1
	16	1

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

13

10

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 09	01	3
	11	1
	13	2
	16	3
	20	1

14

7

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 09	11	1
	12	1
	13	2
	15	1
	16	1
	17	1

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

15

7

Details

ERROR: canceling statement due to lock timeout

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 09	19	7

ERROR: canceling statement due to lock timeout
ERROR: canceling statement due to lock timeout

16

5

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 09	00	1
	02	1
	12	1
	16	1
	21	1

17

5

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 09	00	1
	02	1
	12	1
	16	1
	21	1

18

5

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 09	00	1
	02	1
	12	1
	16	1
	21	1

19

5

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 09	17	5

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

20

4

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 09	00	2
	01	2

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

21

3

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 09	14	3

ERROR: invalid input syntax for type integer: "s" at character 4571

22

2

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 09	04	1
	06	1

23

2

Details

FATAL: canceling authentication due to timeout

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 09	07	1
	08	1

24

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 09	17	1

25

1

Details

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

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Dec 09	05	1

26

1

Details

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

Times Reported Most Frequent Error / Event #26

Day	Hour	Count
Dec 09	04	1

27

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #27

Day	Hour	Count
Dec 09	17	1

28

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #28

Day	Hour	Count
Dec 09	19	1

ERROR: could not serialize access due to concurrent delete

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