pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Feb 4 23:47:33 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 43,108,745 log entries in 2m31s
Log start from 2025-02-04 00:00:00 to 2025-02-04 22:45:01

Global Stats

16,945 Number of unique normalized queries
18,428,409 Number of queries
6d15h19m12s Total query duration
2025-02-04 00:00:00 First query
2025-02-04 22:45:01 Last query
5,311 queries/s at 2025-02-04 10:20:13 Query peak

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

5,639 Number of events
23 Number of unique normalized events
2,175 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
18,428,409 Average queries per session
6d15h19m12s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

5,311 queries/s Query Peak
2025-02-04 10:20:13 Date

SELECT Traffic

Key values

3,334 queries/s Query Peak
2025-02-04 10:20:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,435 queries/s Query Peak
2025-02-04 11:11:13 Date

Queries duration

Key values

6d15h19m12s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 04	00	284,091	0ms	2s244ms	25ms	3m36s	4m16s	4m50s
	01	260,612	0ms	59m59s	51ms	3m8s	3m47s	2h1m52s
	02	279,024	0ms	1m33s	31ms	4m11s	4m21s	4m44s
	03	278,654	0ms	4m33s	32ms	4m46s	7m4s	7m44s
	04	260,431	0ms	45m52s	39ms	4m21s	5m1s	46m59s
	05	150,100	0ms	907ms	20ms	2m5s	2m11s	2m48s
	06	239,470	0ms	827ms	24ms	3m	3m41s	4m21s
	07	153,100	0ms	4s515ms	14ms	1m34s	3m5s	3m52s
	08	504,651	0ms	19m56s	50ms	3m55s	5m1s	5h17m41s
	09	1,070,659	0ms	5s283ms	15ms	8m7s	8m45s	10m58s
	10	1,475,581	0ms	23m51s	21ms	8m34s	10m3s	1h44m14s
	11	1,691,139	0ms	14m35s	33ms	19m57s	1h13m18s	2h25m56s
	12	1,658,011	0ms	24m48s	28ms	9m9s	10m40s	4h59m43s
	13	1,505,643	0ms	19m18s	17ms	8m2s	8m51s	3h8m14s
	14	1,311,100	0ms	14m26s	22ms	9m30s	11m48s	3h32m1s
	15	1,405,625	0ms	18m56s	43ms	11m58s	2h34m2s	5h46m6s
	16	1,231,217	0ms	1m3s	13ms	7m22s	8m3s	12m47s
	17	1,153,968	0ms	16m35s	23ms	10m23s	12m48s	2h8m49s
	18	1,068,239	0ms	33m40s	57ms	17m52s	21m34s	6h53s
	19	933,917	0ms	9m30s	42ms	14m11s	15m43s	1h32m26s
	20	710,673	0ms	56m	78ms	6m10s	6m24s	11h49m17s
	21	519,255	0ms	3s896ms	18ms	4m29s	4m52s	5m16s
	22	283,249	0ms	13s877ms	23ms	3m57s	4m15s	4m34s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 04	00	154,093	46ms	2m44s	3m36s	4m48s
	01	133,899	47ms	2m27s	3m8s	3m46s
	02	145,558	58ms	3m36s	4m11s	4m24s
	03	146,217	56ms	3m12s	3m42s	4m49s
	04	133,087	56ms	2m59s	3m56s	5m
	05	71,714	42ms	1m21s	2m5s	2m17s
	06	130,010	44ms	2m39s	3m	3m49s
	07	80,410	27ms	1m	1m34s	3m9s
	08	298,832	22ms	2m28s	2m57s	5m1s
	09	616,764	27ms	6m22s	8m7s	9m46s
	10	865,884	23ms	7m12s	7m51s	9m31s
	11	1,021,978	28ms	9m38s	11m52s	17m41s
	12	983,283	22ms	8m7s	9m6s	9m22s
	13	898,886	17ms	6m30s	7m18s	8m49s
	14	778,198	21ms	6m21s	8m45s	10m46s
	15	835,502	23ms	7m28s	10m37s	12m12s
	16	714,639	23ms	5m52s	7m21s	9m37s
	17	692,529	27ms	7m17s	8m44s	12m45s
	18	640,815	55ms	15m15s	16m48s	18m21s
	19	557,088	58ms	11m39s	13m24s	14m52s
	20	425,374	31ms	5m14s	5m51s	6m23s
	21	302,132	31ms	4m1s	4m28s	4m57s
	22	162,879	40ms	3m4s	3m57s	4m33s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 04	00	26,398	5,675	132	0	0ms	141ms	185ms	276ms
	01	20,129	6,217	139	0	268ms	128ms	153ms	252ms
	02	29,371	7,278	145	0	3ms	187ms	240ms	315ms
	03	25,051	6,646	146	0	23ms	161ms	231ms	2m42s
	04	23,133	6,804	134	0	91ms	147ms	203ms	348ms
	05	8,615	3,029	215	0	0ms	64ms	80ms	121ms
	06	18,946	5,058	154	0	0ms	129ms	164ms	209ms
	07	6,410	2,298	132	0	0ms	46ms	69ms	131ms
	08	21,122	7,860	341	0	646ms	140ms	179ms	281ms
	09	57,433	18,348	931	0	0ms	364ms	442ms	586ms
	10	66,586	22,033	543	0	123ms	454ms	589ms	1m36s
	11	91,414	26,577	906	0	231ms	695ms	2s437ms	1h7m9s
	12	79,271	22,743	930	0	245ms	506ms	595ms	49s615ms
	13	64,473	22,210	836	0	128ms	358ms	446ms	672ms
	14	56,719	18,346	698	0	168ms	349ms	485ms	4s956ms
	15	67,434	22,993	938	0	462ms	465ms	625ms	2h30m30s
	16	58,695	20,338	478	0	2ms	344ms	428ms	666ms
	17	65,569	24,780	510	1	88ms	521ms	742ms	1m5s
	18	82,576	28,124	803	0	230ms	767ms	865ms	5m41s
	19	83,017	17,860	715	0	68ms	700ms	978ms	4m51s
	20	52,908	12,109	431	0	650ms	356ms	411ms	17s602ms
	21	46,154	10,178	268	0	0ms	275ms	349ms	499ms
	22	29,597	5,826	148	0	0ms	215ms	260ms	587ms

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

Day	Hour	Average / Second
Feb 04	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
Feb 04	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

164,364 buffers Checkpoint Peak
2025-02-04 08:51:26 Date
270.052 seconds Highest write time
0.015 seconds Sync time

Checkpoints Wal files

Key values

72 files Wal files usage Peak
2025-02-04 08:51:26 Date

Checkpoints distance

Key values

2,302.62 Mo Distance Peak
2025-02-04 08:51:26 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 04	00	140,983	3,238.962s	0.037s	3,239.039s
	01	136,148	3,239.598s	0.031s	3,239.67s
	02	143,615	3,239.585s	0.035s	3,239.667s
	03	137,460	3,239.588s	0.03s	3,239.66s
	04	136,324	3,239.556s	0.033s	3,239.632s
	05	75,278	2,989.519s	0.027s	2,989.581s
	06	110,982	3,239.591s	0.032s	3,239.667s
	07	68,594	2,110.732s	0.028s	2,110.8s
	08	277,072	2,962.98s	0.042s	2,963.074s
	09	382,439	3,239.447s	0.055s	3,239.578s
	10	458,929	3,239.522s	0.056s	3,239.66s
	11	556,479	3,239.449s	0.067s	3,239.608s
	12	520,508	3,239.524s	0.06s	3,239.662s
	13	437,875	3,239.543s	0.066s	3,239.679s
	14	401,265	3,239.499s	0.054s	3,239.625s
	15	400,769	3,239.481s	0.056s	3,239.603s
	16	333,806	3,239.51s	0.059s	3,239.631s
	17	292,960	2,886.025s	0.071s	2,886.166s
	18	355,382	3,239.43s	0.06s	3,239.575s
	19	330,693	3,239.52s	0.063s	3,239.657s
	20	244,573	3,239.517s	0.041s	3,239.622s
	21	202,808	3,239.602s	0.049s	3,239.701s
	22	105,617	2,429.599s	0.031s	2,429.662s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Feb 04	00	60	3,127	0.002s	0.012s
	01	63	3,007	0.002s	0.012s
	02	66	3,108	0.002s	0.012s
	03	62	2,808	0.002s	0.012s
	04	66	2,646	0.002s	0.012s
	05	34	2,110	0.002s	0.012s
	06	50	2,834	0.002s	0.012s
	07	30	2,086	0.002s	0.013s
	08	121	3,614	0.004s	0.011s
	09	130	4,927	0.003s	0.012s
	10	164	5,183	0.002s	0.012s
	11	206	5,258	0.003s	0.012s
	12	193	5,279	0.003s	0.012s
	13	170	5,306	0.002s	0.012s
	14	153	5,378	0.002s	0.012s
	15	157	5,504	0.005s	0.012s
	16	133	5,577	0.012s	0.012s
	17	119	5,443	0.009s	0.012s
	18	159	5,297	0.003s	0.012s
	19	136	5,173	0.004s	0.012s
	20	97	5,108	0.002s	0.012s
	21	79	4,884	0.002s	0.012s
	22	42	3,333	0.002s	0.009s

Day	Hour	Avg time (sec)
Feb 04	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
Feb 04	00	82,249.67 kB	144,159.92 kB
	01	85,361.58 kB	111,902.33 kB
	02	90,302.25 kB	127,411.67 kB
	03	85,479.83 kB	108,370.25 kB
	04	88,935.75 kB	108,699.17 kB
	05	47,297.42 kB	80,271.00 kB
	06	67,617.58 kB	98,731.00 kB
	07	38,552.38 kB	96,821.15 kB
	08	179,195.45 kB	285,451.09 kB
	09	170,174.90 kB	675,983.10 kB
	10	224,017.50 kB	337,953.67 kB
	11	280,412.00 kB	344,688.00 kB
	12	257,832.45 kB	310,825.73 kB
	13	231,633.58 kB	274,709.08 kB
	14	210,108.17 kB	267,763.25 kB
	15	213,929.50 kB	273,922.58 kB
	16	184,839.00 kB	291,718.27 kB
	17	162,361.00 kB	198,138.50 kB
	18	217,700.08 kB	521,683.25 kB
	19	185,697.75 kB	284,296.58 kB
	20	132,112.00 kB	191,549.08 kB
	21	107,594.83 kB	136,212.00 kB
	22	76,948.11 kB	139,115.22 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
Feb 04	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
Feb 04	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

10,789,771 Total read queries
5,209,604 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,789,771	58.55%
INSERT	1,081,021	5.87%
UPDATE	323,330	1.75%
DELETE	10,673	0.06%
COPY FROM	1	0.00%
COPY TO	0	0.00%
CTE	23,188	0.13%
DDL	1,430	0.01%
TCL	3,769,961	20.46%
CURSOR	0	0.00%
OTHERS	2,429,034	13.18%

Queries by database

Key values

unknown Main database
18,428,409 Requests
6d15h19m12s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	18,428,409	6d15h19m12s
	copy from	1	1ms
	cte	23,188	5s622ms
	ddl	1,430	198ms
	delete	10,673	10s743ms
	insert	1,081,021	6m5s
	others	2,429,034	2m
	select	10,789,771	3d19h37m20s
	tcl	3,769,961	2m44s
	update	323,330	2d19h30m45s

Queries by user

Key values

unknown Main user
18,428,409 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	18,428,409	6d15h19m12s
	copy from	1	1ms
	cte	23,188	5s622ms
	ddl	1,430	198ms
	delete	10,673	10s743ms
	insert	1,081,021	6m5s
	others	2,429,034	2m
	select	10,789,771	3d19h37m20s
	tcl	3,769,961	2m44s
	update	323,330	2d19h30m45s

Duration by user

Key values

6d15h19m12s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	18,428,409	6d15h19m12s
	copy from	1	1ms
	cte	23,188	5s622ms
	ddl	1,430	198ms
	delete	10,673	10s743ms
	insert	1,081,021	6m5s
	others	2,429,034	2m
	select	10,789,771	3d19h37m20s
	tcl	3,769,961	2m44s
	update	323,330	2d19h30m45s

Queries by host

Key values

unknown Main host
18,428,409 Requests
6d15h19m12s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,428,409	6d15h19m12s
	copy from	1	1ms
	cte	23,188	5s622ms
	ddl	1,430	198ms
	delete	10,673	10s743ms
	insert	1,081,021	6m5s
	others	2,429,034	2m
	select	10,789,771	3d19h37m20s
	tcl	3,769,961	2m44s
	update	323,330	2d19h30m45s

Queries by application

Key values

unknown Main application
18,428,409 Requests
6d15h19m12s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	18,428,409	6d15h19m12s
	copy from	1	1ms
	cte	23,188	5s622ms
	ddl	1,430	198ms
	delete	10,673	10s743ms
	insert	1,081,021	6m5s
	others	2,429,034	2m
	select	10,789,771	3d19h37m20s
	tcl	3,769,961	2m44s
	update	323,330	2d19h30m45s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-02-04 03:19:34 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,062,726 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,062,726	92.59%
1-5ms	331,277	1.80%
5-10ms	18,489	0.10%
10-25ms	49,556	0.27%
25-50ms	101,295	0.55%
50-100ms	169,627	0.92%
100-500ms	354,381	1.92%
500-1000ms	332,361	1.80%
1000-10000ms	8,149	0.04%
> 10000ms	548	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	UPDATE "res_users" SET "exp_date" = '2025-02-04 00:35:34.583426', "last_update" = '2025-02-03 23:50:34.583448', "write_date" = '2025-02-03 23:50:34.257785', "write_uid" = 1 WHERE id IN (829); [ Date: 2025-02-04 01:50:34 ]
2	58m26s	update res_users set sid = '641f11522769234e0b840ba6ce48be9e22a9018a', last_update = '2025-02-03 23:52:07.548097', exp_date = '2025-02-04 00:37:07.548099', logged_in = 'TRUE' where id = 829; [ Date: 2025-02-04 01:50:34 ]
3	56m	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:47:20.639136', exp_date = '2025-02-04 19:32:20.639138', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
4	56m	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:47:20.638921', exp_date = '2025-02-04 19:32:20.638924', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
5	55m28s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:47:52.360201', exp_date = '2025-02-04 19:32:52.360204', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
6	53m37s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:49:43.259005', exp_date = '2025-02-04 19:34:43.259009', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
7	53m28s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:49:52.641728', exp_date = '2025-02-04 19:34:52.641732', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
8	53m26s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:49:54.801267', exp_date = '2025-02-04 19:34:54.801273', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
9	50m57s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:52:23.843642', exp_date = '2025-02-04 19:37:23.843646', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
10	45m52s	UPDATE "res_users" SET "exp_date" = '2025-02-04 03:24:14.610264', "last_update" = '2025-02-04 02:39:14.610287', "sid" = 'c0934bc962f8caf3edac2851f1d2d9b82e78385b', "write_date" = '2025-02-04 02:39:14.276785', "write_uid" = 1 WHERE id IN (1053); [ Date: 2025-02-04 04:25:07 ]
11	39m13s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 19:04:07.552957', exp_date = '2025-02-04 19:49:07.552960', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
12	38m56s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 19:04:24.969153', exp_date = '2025-02-04 19:49:24.969159', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
13	38m42s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 19:04:38.815244', exp_date = '2025-02-04 19:49:38.815250', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
14	38m5s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 19:05:15.494634', exp_date = '2025-02-04 19:50:15.494639', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]
15	33m40s	update res_users set sid = '816849046f28b1fe0814e38c0a001b21b4b8556a', last_update = '2025-02-04 16:51:39.746636', exp_date = '2025-02-04 17:36:39.746640', logged_in = 'TRUE' where id = 956; [ Date: 2025-02-04 18:25:20 ]
16	33m40s	update res_users set sid = '816849046f28b1fe0814e38c0a001b21b4b8556a', last_update = '2025-02-04 16:51:39.746472', exp_date = '2025-02-04 17:36:39.746476', logged_in = 'TRUE' where id = 956; [ Date: 2025-02-04 18:25:20 ]
17	31m45s	update res_users set sid = '816849046f28b1fe0814e38c0a001b21b4b8556a', last_update = '2025-02-04 16:53:34.785327', exp_date = '2025-02-04 17:38:34.785333', logged_in = 'TRUE' where id = 956; [ Date: 2025-02-04 18:25:20 ]
18	31m40s	update res_users set sid = '816849046f28b1fe0814e38c0a001b21b4b8556a', last_update = '2025-02-04 16:53:40.126005', exp_date = '2025-02-04 17:38:40.126009', logged_in = 'TRUE' where id = 956; [ Date: 2025-02-04 18:25:20 ]
19	27m29s	update res_users set sid = '816849046f28b1fe0814e38c0a001b21b4b8556a', last_update = '2025-02-04 16:57:50.561307', exp_date = '2025-02-04 17:42:50.561309', logged_in = 'TRUE' where id = 956; [ Date: 2025-02-04 18:25:20 ]
20	26m56s	update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 19:16:24.106873', exp_date = '2025-02-04 20:01:24.106876', logged_in = 'TRUE' where id = 1390; [ Date: 2025-02-04 20:43:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d12h55m33s

65,239

Details

0ms

58m26s

3s361ms

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
Feb 04	00	808	186ms	0ms
	01	988	58m26s	3s549ms
	02	899	205ms	0ms
	03	1,071	10m46s	603ms
	04	1,007	234ms	0ms
	05	408	88ms	0ms
	06	674	149ms	0ms
	07	407	88ms	0ms
	08	1,691	2h25m10s	5s151ms
	09	3,963	1s86ms	0ms
	10	5,973	2h37m57s	1s586ms
	11	6,885	6h42m20s	3s506ms
	12	6,924	7h21s	3s642ms
	13	5,838	3h6m43s	1s919ms
	14	4,942	3h32m8s	2s575ms
	15	4,960	11h27m50s	8s320ms
	16	4,249	1m39s	23ms
	17	3,690	2h8m49s	2s94ms
	18	2,970	6h58m37s	8s457ms
	19	2,672	1h55m4s	2s583ms
	20	1,997	11h49m20s	21s312ms
	21	1,546	372ms	0ms
	22	677	14s29ms	20ms

update res_users set sid = '641f11522769234e0b840ba6ce48be9e22a9018a', last_update = '2025-02-03 23:52:07.548097', exp_date = '2025-02-04 00:37:07.548099', logged_in = 'TRUE' where id = 829;

Date: 2025-02-04 01:50:34 Duration: 58m26s
update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:47:20.639136', exp_date = '2025-02-04 19:32:20.639138', logged_in = 'TRUE' where id = 1390;

Date: 2025-02-04 20:43:20 Duration: 56m
update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:47:20.638921', exp_date = '2025-02-04 19:32:20.638924', logged_in = 'TRUE' where id = 1390;

Date: 2025-02-04 20:43:20 Duration: 56m

2

2d4h57m31s

281,385

Details

524ms

5s126ms

677ms

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
Feb 04	00	8,538	1h27m31s	615ms
	01	7,359	1h14m18s	605ms
	02	9,477	1h37m19s	616ms
	03	9,890	1h40m46s	611ms
	04	9,131	1h33m13s	612ms
	05	3,717	36m34s	590ms
	06	6,692	1h7m42s	607ms
	07	2,602	25m55s	597ms
	08	5,999	1h40s	606ms
	09	13,794	2h34m11s	670ms
	10	16,643	3h7m12s	674ms
	11	22,460	4h42m56s	755ms
	12	19,646	3h47m40s	695ms
	13	11,725	2h9m28s	662ms
	14	13,117	2h28m13s	678ms
	15	12,721	2h26m42s	691ms
	16	12,092	2h14m33s	667ms
	17	12,224	2h15m8s	663ms
	18	26,150	5h36m19s	771ms
	19	31,344	6h23m9s	733ms
	20	12,156	2h4m32s	614ms
	21	8,763	1h29m54s	615ms
	22	5,145	53m24s	622ms

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

Date: 2025-02-04 18:04:48 Duration: 5s126ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5058159)) AND (("shipping_track"."id" not in (41995988, 41995988)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 19:17:23 Duration: 5s51ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5053457)) AND (("shipping_track"."id" not in (41960894, 41960894)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 18:05:09 Duration: 5s35ms

3

8h28m51s

43,662

Details

526ms

6s160ms

699ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 04	00	176	2m	681ms
	01	162	1m52s	692ms
	02	562	5m59s	640ms
	03	196	2m17s	703ms
	04	202	2m20s	697ms
	05	357	3m38s	611ms
	06	254	2m44s	647ms
	07	168	1m45s	626ms
	08	1,237	12m57s	628ms
	09	3,858	44m12s	687ms
	10	2,763	32m34s	707ms
	11	4,488	59m20s	793ms
	12	4,991	1h20s	725ms
	13	3,426	38m53s	681ms
	14	3,811	42m58s	676ms
	15	3,595	41m57s	700ms
	16	2,566	28m50s	674ms
	17	1,928	21m37s	673ms
	18	2,811	35m11s	751ms
	19	2,732	33m37s	738ms
	20	1,825	18m16s	600ms
	21	1,206	11m54s	592ms
	22	348	3m26s	594ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5042986, 5040485, 5039371, 5034661, 5029086, 5024279, 5016291, 4992926)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 11:18:33 Duration: 6s160ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5011445, 5011190, 4997696, 4995447, 4993847)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 11:19:13 Duration: 4s958ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5047156, 5047155, 5047127, 5047126, 5047125, 5046733, 5028374, 5027432, 5027429, 5027425, 5027418, 5027415, 5027407, 5027404, 5027402, 5027398, 5027395, 5027391, 5027388, 5027385, 5027382, 5027379, 5027376)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 11:18:23 Duration: 4s876ms

4

8h18m6s

146,370

Details

140ms

1s529ms

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" = ?)) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 04	00	1,459	3m48s	156ms
	01	2,696	6m58s	155ms
	02	2,761	7m13s	156ms
	03	2,377	6m11s	156ms
	04	2,691	7m	156ms
	05	1,609	4m8s	154ms
	06	2,664	6m55s	155ms
	07	1,286	3m19s	155ms
	08	4,899	13m	159ms
	09	8,747	25m17s	173ms
	10	12,290	37m2s	180ms
	11	12,773	41m33s	195ms
	12	5,416	16m33s	183ms
	13	7,499	22m19s	178ms
	14	6,919	20m14s	175ms
	15	9,219	27m6s	176ms
	16	11,754	34m26s	175ms
	17	21,308	1h22m6s	231ms
	18	24,913	2h1m14s	291ms
	19	1,449	6m5s	251ms
	20	1,115	3m44s	201ms
	21	206	41s287ms	200ms
	22	320	1m3s	199ms

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

Date: 2025-02-04 18:09:27 Duration: 1s529ms
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" = '291649')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 18:05:17 Duration: 1s520ms
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" = '230012')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:19:44 Duration: 1s506ms

5

4h41m20s

295

Details

0ms

45m52s

57s223ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 04	00	2	1ms	0ms
	01	3	0ms	0ms
	02	2	0ms	0ms
	03	4	0ms	0ms
	04	1	45m52s	45m52s
	05	4	0ms	0ms
	06	4	2ms	0ms
	07	1	0ms	0ms
	08	37	2h50m37s	4m36s
	09	21	14ms	0ms
	10	24	41s984ms	1s749ms
	11	31	39m2s	1m15s
	12	23	32ms	1ms
	13	19	23ms	1ms
	14	19	17ms	0ms
	15	21	15m50s	45s250ms
	16	21	20ms	0ms
	17	11	14ms	1ms
	18	11	9m14s	50s450ms
	19	14	21ms	1ms
	20	12	16ms	1ms
	21	4	3ms	0ms
	22	6	5ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-04 03:24:14.610264', "last_update" = '2025-02-04 02:39:14.610287', "sid" = 'c0934bc962f8caf3edac2851f1d2d9b82e78385b', "write_date" = '2025-02-04 02:39:14.276785', "write_uid" = 1 WHERE id IN (1053);

Date: 2025-02-04 04:25:07 Duration: 45m52s
UPDATE "res_users" SET "exp_date" = '2025-02-04 14:31:30.995189', "last_update" = '2025-02-04 13:46:30.995211', "sid" = '32b51d69bbd7e9dac9b6c0e7484206f3b23e6eda', "write_date" = '2025-02-04 13:46:30.670008', "write_uid" = 959 WHERE id IN (959);

Date: 2025-02-04 15:02:21 Duration: 15m50s
UPDATE "res_users" SET "exp_date" = '2025-02-04 07:38:07.889911', "last_update" = '2025-02-04 06:53:07.889929', "sid" = 'd2a5116ed7a7ce67cb7df279ce273c386d0b3a68', "write_date" = '2025-02-04 06:53:07.570484', "write_uid" = 1 WHERE id IN (825);

Date: 2025-02-04 08:08:21 Duration: 15m13s

6

4h9m12s

59,664

Details

93ms

953ms

250ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 04	00	2,838	9m59s	211ms
	01	1,728	6m22s	221ms
	02	3,016	11m19s	225ms
	03	2,652	9m6s	206ms
	04	2,180	8m7s	223ms
	05	8	2s680ms	335ms
	06	1,438	5m10s	215ms
	07	82	15s826ms	193ms
	08	48	9s8ms	187ms
	09	408	1m27s	214ms
	10	152	35s769ms	235ms
	11	30	9s996ms	333ms
	12	420	1m51s	265ms
	13	852	3m33s	250ms
	14	1,270	5m20s	252ms
	15	2,021	9m24s	279ms
	16	3,441	15m16s	266ms
	17	4,130	17m48s	258ms
	18	7,252	35m47s	296ms
	19	8,619	39m52s	277ms
	20	5,902	22m28s	228ms
	21	6,187	24m38s	238ms
	22	4,990	20m22s	245ms

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

Date: 2025-02-04 17:46:31 Duration: 953ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ياسر')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-04 17:46:31 Duration: 952ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-04 19:56:56 Duration: 900ms

7

2h50m12s

12,039

Details

188ms

2s24ms

848ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 04	00	364	2m41s	444ms
	01	348	3m8s	542ms
	02	228	1m56s	509ms
	03	415	5m4s	734ms
	05	4	3s563ms	890ms
	08	17	15s348ms	902ms
	09	5	3s998ms	799ms
	10	44	39s467ms	896ms
	11	5	4s783ms	956ms
	12	29	32s45ms	1s105ms
	13	305	3m1s	596ms
	14	538	6m59s	779ms
	15	700	9m47s	839ms
	16	523	5m45s	659ms
	17	754	10m	796ms
	18	1,675	27m57s	1s1ms
	19	2,333	38m12s	982ms
	20	1,867	27m48s	893ms
	21	585	7m46s	797ms
	22	1,300	18m21s	847ms

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

Date: 2025-02-04 18:56:55 Duration: 2s24ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '159653')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 19:17:08 Duration: 1s958ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '318968')) 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 (60))))))) 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 (60)))))) 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 (60)))))) 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 (60))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 18:57:05 Duration: 1s954ms

8

2h23m6s

31,358

Details

150ms

2s511ms

273ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	08	1,668	7m3s	253ms
	09	2,817	12m34s	267ms
	10	3,722	16m21s	263ms
	11	3,785	18m42s	296ms
	12	1,973	8m57s	272ms
	13	3,216	13m49s	257ms
	14	3,111	14m35s	281ms
	15	4,436	19m32s	264ms
	16	3,844	17m26s	272ms
	17	2,760	13m49s	300ms
	18	26	15s51ms	578ms

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" = '211060')))) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:02:22 Duration: 2s511ms
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" = '211059')))) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:02:19 Duration: 2s432ms
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" = '9947347')))) ORDER BY "collection_policy"."id";

Date: 2025-02-04 14:00:18 Duration: 742ms

9

2h11m47s

155,038

Details

37ms

344ms

51ms

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
Feb 04	00	3,305	2m29s	45ms
	01	2,398	1m47s	45ms
	02	4,442	3m21s	45ms
	03	2,759	2m5s	45ms
	04	2,553	1m56s	45ms
	05	887	39s497ms	44ms
	06	2,366	1m46s	45ms
	07	868	39s406ms	45ms
	08	3,776	2m54s	46ms
	09	10,262	8m37s	50ms
	10	11,739	9m58s	50ms
	11	16,352	15m21s	56ms
	12	15,626	13m36s	52ms
	13	9,878	8m6s	49ms
	14	10,284	8m40s	50ms
	15	9,511	8m5s	51ms
	16	8,303	6m45s	48ms
	17	6,954	5m53s	50ms
	18	6,418	6m30s	60ms
	19	10,220	9m47s	57ms
	20	8,062	6m25s	47ms
	21	5,415	4m13s	46ms
	22	2,660	2m2s	46ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5020530, 5001550)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 18:08:22 Duration: 344ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5041299, 5027363)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 18:05:54 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4999986, 4975441)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 11:18:39 Duration: 308ms

10

1h36m20s

46

Details

0ms

59m59s

2m5s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 04	01	1	59m59s	59m59s
	04	1	0ms	0ms
	06	3	0ms	0ms
	07	1	0ms	0ms
	08	4	3ms	0ms
	09	3	0ms	0ms
	10	3	23m51s	7m57s
	11	3	12m28s	4m9s
	12	2	1ms	0ms
	14	8	10ms	1ms
	15	6	11ms	1ms
	17	2	1ms	0ms
	18	2	0ms	0ms
	20	6	5ms	0ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-02-04 00:35:34.583426', "last_update" = '2025-02-03 23:50:34.583448', "write_date" = '2025-02-03 23:50:34.257785', "write_uid" = 1 WHERE id IN (829);

Date: 2025-02-04 01:50:34 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-04 10:09:29.023278', "last_update" = '2025-02-04 09:24:29.023302', "write_date" = '2025-02-04 09:24:28.639524', "write_uid" = 965 WHERE id IN (965);

Date: 2025-02-04 10:48:20 Duration: 23m51s
UPDATE "res_users" SET "exp_date" = '2025-02-04 10:43:52.275971', "last_update" = '2025-02-04 09:58:52.275994', "write_date" = '2025-02-04 09:58:51.917252', "write_uid" = 1 WHERE id IN (965);

Date: 2025-02-04 11:11:21 Duration: 12m28s

11

1h29m9s

18,152

Details

187ms

1s805ms

294ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	1,066	4m26s	249ms
	01	522	2m9s	247ms
	02	1,291	5m16s	244ms
	03	938	3m52s	247ms
	04	1,105	4m34s	248ms
	06	722	2m59s	248ms
	07	44	9s979ms	226ms
	08	7	1s741ms	248ms
	09	211	55s49ms	260ms
	10	36	10s317ms	286ms
	11	10	3s288ms	328ms
	12	191	54s682ms	286ms
	13	131	36s938ms	281ms
	14	110	31s943ms	290ms
	15	323	1m31s	284ms
	16	1,213	5m46s	285ms
	17	1,332	6m52s	309ms
	18	1,976	12m28s	378ms
	19	2,010	11m57s	356ms
	20	1,123	5m36s	299ms
	21	2,570	12m32s	292ms
	22	1,221	5m42s	280ms

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

Date: 2025-02-04 18:04:56 Duration: 1s805ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '186736')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 18:07:32 Duration: 1s714ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '185498')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 18:05:03 Duration: 1s655ms

12

56m14s

53,765

Details

46ms

350ms

62ms

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
Feb 04	00	14	814ms	58ms
	06	127	7s42ms	55ms
	08	2,413	2m18s	57ms
	09	3,862	4m1s	62ms
	10	7,468	7m38s	61ms
	11	6,583	7m34s	69ms
	12	5,332	5m40s	63ms
	13	4,939	5m3s	61ms
	14	6,768	6m54s	61ms
	15	6,632	6m51s	61ms
	16	5,403	5m21s	59ms
	17	3,798	4m6s	64ms
	18	308	26s926ms	87ms
	19	52	4s298ms	82ms
	20	21	1s314ms	62ms
	21	21	1s272ms	60ms
	22	24	1s389ms	57ms

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

Date: 2025-02-04 11:18:47 Duration: 350ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5002562) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:18:38 Duration: 342ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4884509) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-04 18:10:06 Duration: 338ms

13

46m7s

15,691

Details

141ms

1s180ms

176ms

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
Feb 04	00	163	25s587ms	156ms
	02	20	3s127ms	156ms
	04	13	2s396ms	184ms
	06	1,179	3m4s	156ms
	07	1,226	3m10s	155ms
	08	1,529	4m	157ms
	09	1,877	5m22s	171ms
	10	2,739	8m15s	180ms
	11	1,317	4m17s	195ms
	12	990	3m1s	183ms
	13	899	2m34s	172ms
	14	803	2m16s	169ms
	15	1,049	2m59s	171ms
	16	386	1m6s	173ms
	17	262	54s483ms	207ms
	18	139	36s463ms	262ms
	19	343	1m23s	243ms
	20	313	1m3s	203ms
	21	206	41s420ms	201ms
	22	238	47s478ms	199ms

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

Date: 2025-02-04 11:19:38 Duration: 1s180ms
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" = '262101')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:19:25 Duration: 486ms
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" = '125551')) 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, 115)))) 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: 2025-02-04 18:48:18 Duration: 386ms

14

42m6s

19,723

Details

96ms

845ms

128ms

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
Feb 04	05	73	8s692ms	119ms
	06	12	1s415ms	117ms
	08	270	31s809ms	117ms
	09	1,260	2m42s	129ms
	10	1,126	2m27s	130ms
	11	2,917	6m25s	132ms
	12	2,061	4m33s	132ms
	13	2,948	6m1s	122ms
	14	1,668	3m25s	123ms
	15	2,334	5m3s	130ms
	16	1,442	2m53s	120ms
	17	988	2m3s	124ms
	18	871	2m4s	142ms
	19	871	2m3s	141ms
	20	423	49s609ms	117ms
	21	427	48s18ms	112ms
	22	32	3s680ms	115ms

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

Date: 2025-02-04 19:17:04 Duration: 845ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8085311)) AND (("cash_track"."id" not in (7689032)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-04 11:19:40 Duration: 844ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8088382)) AND (("cash_track"."id" not in (7711736)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-04 18:09:49 Duration: 681ms

15

34m16s

13,176

Details

142ms

213ms

156ms

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
Feb 04	00	1,296	3m22s	156ms
	01	2,586	6m41s	155ms
	02	2,729	7m8s	156ms
	03	1,939	5m2s	155ms
	04	2,664	6m55s	155ms
	05	1,443	3m42s	154ms
	06	437	1m7s	154ms
	22	82	16s422ms	200ms

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

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

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

Date: 2025-02-04 22:29:11 Duration: 211ms

16

29m57s

3,309

Details

16ms

6s262ms

543ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 04	00	8	988ms	123ms
	01	1	222ms	222ms
	02	1	22ms	22ms
	05	1	98ms	98ms
	06	2	122ms	61ms
	07	3	474ms	158ms
	08	65	11s142ms	171ms
	09	121	26s105ms	215ms
	10	259	1m6s	256ms
	11	328	1m32s	283ms
	12	315	1m34s	299ms
	13	459	1m49s	238ms
	14	254	1m13s	289ms
	15	877	18m27s	1s263ms
	16	163	47s345ms	290ms
	17	208	54s711ms	263ms
	18	66	30s495ms	462ms
	19	79	48s481ms	613ms
	20	61	23s853ms	391ms
	21	26	6s839ms	263ms
	22	12	1s732ms	144ms

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

Date: 2025-02-04 15:30:18 Duration: 6s262ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-04 15:30:28 Duration: 5s973ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-04 18:05:41 Duration: 2s613ms

17

23m5s

24,276

Details

42ms

287ms

57ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 04	08	1,259	1m5s	52ms
	09	2,495	2m17s	54ms
	10	3,214	3m2s	56ms
	11	2,498	2m36s	62ms
	12	2,344	2m17s	58ms
	13	2,574	2m24s	56ms
	14	2,490	2m20s	56ms
	15	3,129	2m55s	55ms
	16	1,993	1m48s	54ms
	17	2,251	2m14s	59ms
	18	29	2s153ms	74ms

SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4952045) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:18:39 Duration: 287ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4947301) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:18:39 Duration: 266ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4913510) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:17:07 Duration: 262ms

18

16m39s

313

Details

387ms

5s856ms

3s193ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 04	10	34	1m55s	3s404ms
	11	10	32s732ms	3s273ms
	12	5	10s229ms	2s45ms
	13	40	2m7s	3s191ms
	14	18	1m	3s372ms
	15	56	2m56s	3s146ms
	16	30	1m35s	3s177ms
	17	49	2m23s	2s928ms
	18	20	1m18s	3s921ms
	19	11	38s128ms	3s466ms
	20	31	1m34s	3s47ms
	21	9	26s522ms	2s946ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))) 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 (127)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))))) 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 (127)))))))) AND ("policy_number"."name"::text ilike '%65528%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-04 18:03:43 Duration: 5s856ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))) 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 (127)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))))) 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 (127)))))))) AND ("policy_number"."name"::text ilike '%65528%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-04 18:03:55 Duration: 5s407ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))) 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 (127)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))))) 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 (127)))))))) AND ("policy_number"."name"::text ilike '%6552%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-04 18:03:41 Duration: 4s647ms

19

16m20s

5,320

Details

144ms

1s85ms

184ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	01	38	5s963ms	156ms
	04	15	2s708ms	180ms
	06	665	1m43s	156ms
	07	59	9s326ms	158ms
	09	112	18s804ms	167ms
	10	683	2m5s	184ms
	11	3,748	11m53s	190ms

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" = '9726102')) 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)))) 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))))) 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))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:28:08 Duration: 1s85ms
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" = '283959')) 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)))) 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))))) 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))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:18:26 Duration: 1s64ms
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" = '115943')) 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)))) 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))))) 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))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:18:35 Duration: 504ms

20

15m55s

6,009

Details

121ms

1s178ms

158ms

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 04	00	30	3s945ms	131ms
	02	41	5s483ms	133ms
	08	142	19s100ms	134ms
	09	493	1m14s	150ms
	10	808	2m3s	153ms
	11	1,236	3m48s	184ms
	12	1,176	3m5s	157ms
	13	678	1m38s	144ms
	14	347	50s932ms	146ms
	15	296	46s182ms	156ms
	16	214	31s51ms	145ms
	17	147	23s856ms	162ms
	18	78	17s698ms	226ms
	19	77	13s7ms	168ms
	20	81	11s337ms	139ms
	21	67	9s178ms	136ms
	22	98	13s31ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 19)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-04 11:19:10 Duration: 1s178ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-04 11:18:35 Duration: 1s156ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 70)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-04 11:28:04 Duration: 1s118ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,428,195

Details

2m

0ms

18ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 04	00	40,169	2s40ms	0ms
	01	40,912	2s79ms	0ms
	02	39,069	2s42ms	0ms
	03	39,931	2s179ms	0ms
	04	38,340	2s56ms	0ms
	05	27,510	1s231ms	0ms
	06	32,805	1s768ms	0ms
	07	25,400	1s146ms	0ms
	08	67,576	3s46ms	0ms
	09	143,643	7s965ms	0ms
	10	197,550	10s307ms	0ms
	11	210,785	9s934ms	0ms
	12	219,425	10s480ms	0ms
	13	200,929	9s646ms	0ms
	14	180,849	8s819ms	0ms
	15	188,264	8s550ms	0ms
	16	173,795	8s580ms	0ms
	17	144,720	7s543ms	0ms
	18	123,938	7s3ms	0ms
	19	108,320	5s784ms	0ms
	20	86,491	4s84ms	0ms
	21	63,520	2s895ms	0ms
	22	34,254	1s619ms	0ms

DISCARD ALL;

Date: 2025-02-04 11:37:38 Duration: 18ms
DISCARD ALL;

Date: 2025-02-04 01:30:11 Duration: 1ms
DISCARD ALL;

Date: 2025-02-04 08:56:04 Duration: 1ms

2

1,885,341

Details

29s996ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 04	00	28,635	492ms	0ms
	01	29,597	499ms	0ms
	02	28,754	501ms	0ms
	03	30,308	527ms	0ms
	04	29,451	502ms	0ms
	05	19,475	312ms	0ms
	06	26,218	447ms	0ms
	07	19,211	298ms	0ms
	08	54,003	803ms	0ms
	09	116,493	1s931ms	0ms
	10	160,724	2s454ms	0ms
	11	167,891	2s713ms	0ms
	12	175,071	2s612ms	0ms
	13	158,042	2s281ms	0ms
	14	137,077	2s66ms	0ms
	15	144,004	2s121ms	0ms
	16	131,034	2s49ms	0ms
	17	112,055	1s789ms	0ms
	18	95,161	1s860ms	0ms
	19	82,831	1s567ms	0ms
	20	65,939	1s22ms	0ms
	21	48,188	729ms	0ms
	22	25,179	410ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-04 19:33:25 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-04 11:06:12 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-04 02:34:17 Duration: 1ms

3

1,234,279

Details

13s618ms

0ms

17ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 04	00	20,717	204ms	0ms
	01	21,094	207ms	0ms
	02	20,143	206ms	0ms
	03	20,609	215ms	0ms
	04	19,750	204ms	0ms
	05	14,325	129ms	0ms
	06	17,004	173ms	0ms
	07	13,370	120ms	0ms
	08	34,789	330ms	0ms
	09	72,820	806ms	0ms
	10	100,268	1s105ms	0ms
	11	106,783	1s309ms	0ms
	12	110,868	1s271ms	0ms
	13	101,443	1s76ms	0ms
	14	91,388	972ms	0ms
	15	95,153	1s37ms	0ms
	16	88,095	934ms	0ms
	17	73,309	811ms	0ms
	18	62,885	820ms	0ms
	19	55,220	706ms	0ms
	20	44,140	451ms	0ms
	21	32,440	341ms	0ms
	22	17,666	182ms	0ms

ROLLBACK;

Date: 2025-02-04 15:31:54 Duration: 17ms
ROLLBACK;

Date: 2025-02-04 09:48:00 Duration: 1ms
ROLLBACK;

Date: 2025-02-04 15:31:06 Duration: 0ms

4

1,223,772

Details

4m11s

0ms

20ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 04	00	20,084	4s67ms	0ms
	01	20,457	4s43ms	0ms
	02	19,494	4s76ms	0ms
	03	19,924	4s243ms	0ms
	04	19,121	3s997ms	0ms
	05	13,739	2s297ms	0ms
	06	16,392	3s355ms	0ms
	07	12,695	1s879ms	0ms
	08	34,321	6s609ms	0ms
	09	72,483	15s376ms	0ms
	10	100,011	19s732ms	0ms
	11	106,360	23s72ms	0ms
	12	110,889	22s966ms	0ms
	13	101,394	19s664ms	0ms
	14	91,571	18s73ms	0ms
	15	94,945	18s454ms	0ms
	16	87,689	17s169ms	0ms
	17	72,790	15s112ms	0ms
	18	62,340	15s313ms	0ms
	19	54,527	13s274ms	0ms
	20	43,440	8s799ms	0ms
	21	31,940	6s363ms	0ms
	22	17,166	3s394ms	0ms

SELECT payload FROM http_sessions WHERE sid = '35a1134527fe59bf4ae5a9f2634a3b87e6858fbe';

Date: 2025-02-04 18:38:47 Duration: 20ms
SELECT payload FROM http_sessions WHERE sid = 'a1c69094a448641f85f3812db8f78f9604699dec';

Date: 2025-02-04 18:02:58 Duration: 17ms
SELECT payload FROM http_sessions WHERE sid = 'd277dc565dd63dabb08eea2cc583b669896849f0';

Date: 2025-02-04 10:48:22 Duration: 14ms

5

1,214,349

Details

1m57s

0ms

16ms

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
Feb 04	00	20,144	1s836ms	0ms
	01	20,514	1s867ms	0ms
	02	19,599	1s834ms	0ms
	03	20,026	1s894ms	0ms
	04	19,242	1s807ms	0ms
	05	13,812	1s144ms	0ms
	06	16,457	1s530ms	0ms
	07	12,760	1s42ms	0ms
	08	33,731	2s971ms	0ms
	09	71,803	6s967ms	0ms
	10	98,706	9s112ms	0ms
	11	105,290	10s945ms	0ms
	12	109,691	10s826ms	0ms
	13	100,478	9s413ms	0ms
	14	90,378	8s503ms	0ms
	15	94,088	8s918ms	0ms
	16	86,910	8s236ms	0ms
	17	72,340	7s310ms	0ms
	18	61,945	7s132ms	0ms
	19	54,180	5s984ms	0ms
	20	43,234	3s966ms	0ms
	21	31,839	2s964ms	0ms
	22	17,182	1s597ms	0ms

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

Date: 2025-02-04 12:28:34 Duration: 16ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-04 10:58:37 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-04 10:17:13 Duration: 1ms

6

843,367

Details

2m16s

0ms

12ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 04	00	9,684	1s694ms	0ms
	01	10,258	1s919ms	0ms
	02	10,022	1s832ms	0ms
	03	11,735	2s127ms	0ms
	04	11,472	2s115ms	0ms
	05	5,802	1s56ms	0ms
	06	11,459	1s944ms	0ms
	07	7,044	1s151ms	0ms
	08	24,897	3s648ms	0ms
	09	57,370	9s994ms	0ms
	10	79,402	14s50ms	0ms
	11	79,437	12s957ms	0ms
	12	84,077	12s689ms	0ms
	13	73,583	10s660ms	0ms
	14	59,588	9s311ms	0ms
	15	65,422	9s515ms	0ms
	16	55,641	8s536ms	0ms
	17	50,682	8s3ms	0ms
	18	41,734	7s906ms	0ms
	19	35,335	6s641ms	0ms
	20	27,982	4s179ms	0ms
	21	20,453	2s925ms	0ms
	22	10,288	1s505ms	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 (1027);

Date: 2025-02-04 17:21:56 Duration: 12ms
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 (1027);

Date: 2025-02-04 17:21:56 Duration: 11ms
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 (877);

Date: 2025-02-04 17:21:56 Duration: 11ms

7

650,335

Details

2m

0ms

43ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 04	00	7,917	1s644ms	0ms
	01	8,503	1s765ms	0ms
	02	8,611	2s35ms	0ms
	03	9,690	1s841ms	0ms
	04	9,706	2s10ms	0ms
	05	5,151	957ms	0ms
	06	9,215	1s594ms	0ms
	07	5,815	814ms	0ms
	08	19,177	3s38ms	0ms
	09	43,660	7s672ms	0ms
	10	60,382	9s919ms	0ms
	11	60,948	12s111ms	0ms
	12	64,135	11s871ms	0ms
	13	56,568	9s948ms	0ms
	14	45,644	8s77ms	0ms
	15	48,769	8s747ms	0ms
	16	42,936	7s463ms	0ms
	17	38,684	6s974ms	0ms
	18	32,209	7s356ms	0ms
	19	27,573	6s162ms	0ms
	20	21,781	4s175ms	0ms
	21	15,750	3s126ms	0ms
	22	7,511	1s451ms	0ms

COMMIT;

Date: 2025-02-04 12:06:42 Duration: 43ms
COMMIT;

Date: 2025-02-04 11:16:34 Duration: 35ms
COMMIT;

Date: 2025-02-04 15:08:44 Duration: 35ms

8

508,283

Details

1m11s

0ms

7ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	6,875	764ms	0ms
	01	6,043	753ms	0ms
	02	5,949	672ms	0ms
	03	7,697	949ms	0ms
	04	6,644	825ms	0ms
	05	2,357	329ms	0ms
	06	7,458	1s25ms	0ms
	07	3,730	427ms	0ms
	08	12,964	1s657ms	0ms
	09	34,712	4s878ms	0ms
	10	47,171	6s732ms	0ms
	11	45,572	7s883ms	0ms
	12	49,042	7s15ms	0ms
	13	42,582	5s876ms	0ms
	14	34,229	4s833ms	0ms
	15	37,763	5s803ms	0ms
	16	33,605	4s328ms	0ms
	17	30,887	4s259ms	0ms
	18	26,790	4s456ms	0ms
	19	25,478	3s930ms	0ms
	20	18,450	2s103ms	0ms
	21	14,762	1s570ms	0ms
	22	7,523	788ms	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 (5103289, 5099788, 5102053, 5099137, 5099503, 5099007, 5134271, 5100471, 5103493, 5099568, 5099102, 5496648, 5501184, 5243032, 5177609, 5501085, 5501501, 5099009, 5391607, 5102990, 5220077, 5099010, 5495067, 5099714, 5425639, 5501186, 5501312, 5102168, 5099949, 5499341, 5265771, 5101164, 5324575, 5106335, 5248997, 5500134, 5109974, 5482222, 5099206, 5183561, 5482538, 5252852, 5140292, 5100579, 5107242, 5501188, 5501187, 5501576, 5099169, 5101514, 5119778, 5099243, 5467557, 5105319, 5276675, 5099008, 5099654, 5100207, 5107553, 5153206, 5099446, 5338883, 5130299, 5099644, 5103766, 5105263, 5501185, 5137866, 5498778, 5101316, 5497160, 5113012, 5149282, 5131131, 5171854, 5237245, 5117663, 5131378, 5099427, 5108133, 5274038, 5105570, 5099013, 5099119, 5099248, 5446922, 5110315, 5426589, 5101077, 5099217, 5500132, 5249087, 5439096, 5103477, 5099014, 5123284, 5101308, 5162725, 5217081, 5130105, 5500354, 5239058, 5125373, 5500348, 5099333, 5099224, 5125118, 5312897, 5101468, 5131148, 5124761, 5110530, 5430280, 5316380, 5107359, 5107143, 5225649, 5107140, 5114896, 5143980, 5106838, 5115285, 5099144, 5100499, 5500359, 5108177, 5495757, 5099006, 5100204, 5477204, 5290135, 5494144, 5116789, 5122119, 5102276, 5499376, 5103258, 5099140, 5099515, 5102287, 5118354, 5135489, 5099028, 5180114, 5100755, 5099111, 5498564, 5104641, 5099309, 5497157, 5247676, 5495745, 5355279, 5291721, 5099194, 5103661, 5498868, 5099445, 5101206, 5400052, 5131941, 5101020, 5244888, 5412469, 5498558, 5104276, 5100477, 5099264, 5124842, 5268599, 5101214, 5498865);

Date: 2025-02-04 17:21:59 Duration: 7ms
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 (5107075, 5101685, 5148736, 5102795, 5139545, 5099187, 5102870, 5103853, 5099333, 5128986, 5099456, 5099305, 5100163, 5099544, 5103784, 5100181, 5099499, 5099103, 5452760, 5108734, 5110301, 5099089, 5106893, 5102105, 5100729, 5136873, 5099895, 5099141, 5100804, 5100386, 5100724, 5189375, 5099387, 5099529, 5100913, 5327320, 5099401, 5109578, 5101250, 5099195, 5111246, 5099782, 5192459, 5153011, 5100538, 5172985, 5304722, 5100404, 5099446, 5099441, 5101615, 5099355, 5100110, 5099082, 5118073, 5122256, 5201808, 5099755, 5099245, 5099313, 5173783, 5109066, 5099919, 5210353, 5099191, 5113720, 5502791, 5102233, 5105759, 5102494, 5099984, 5100383, 5100499, 5101304, 5104087, 5410521, 5099767, 5152299, 5100166, 5103305, 5119724, 5099406, 5099887, 5324893, 5100070, 5099117, 5107751, 5489583, 5103295, 5099929, 5100786, 5117060, 5107714, 5099039, 5099761, 5477408, 5100148, 5105829, 5108663, 5280876, 5099170, 5113392, 5100192, 5099027, 5099513, 5100638, 5118683, 5100207, 5105588, 5102811, 5107494, 5182686, 5099008, 5103145, 5099134, 5102171, 5120433, 5099764, 5099249, 5099382);

Date: 2025-02-04 17:21:56 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 (5102790, 5099521, 5099182, 5099007, 5110452, 5116613, 5103632, 5101092, 5099010, 5342766, 5340343, 5099009, 5099119, 5099754, 5099296, 5101152, 5107065, 5115661, 5101607, 5099206, 5105592, 5099013, 5099873, 5165733, 5099264, 5099130, 5100252, 5106415, 5122510, 5144049, 5101355, 5099523, 5208055, 5100204, 5099525, 5099120, 5099254, 5101237, 5173671, 5101782, 5100202, 5099102, 5501631, 5099236, 5099815, 5099135, 5100902, 5099095, 5102364, 5132233, 5100274, 5100233, 5111228, 5099003, 5101313, 5099111, 5099194, 5099002, 5099415, 5099909, 5099705, 5099137, 5101165, 5111122, 5100527, 5099967, 5099248, 5100431, 5099006, 5099677, 5099144, 5103289, 5100227, 5099515, 5099204, 5099309, 5099590, 5104383, 5099224, 5111688, 5103046, 5503113, 5501838, 5099263, 5099035, 5100801, 5099359, 5099636, 5099644, 5099138, 5099662, 5099506, 5099287, 5116095, 5099403, 5099046, 5101684, 5099727, 5117141, 5099275, 5100883, 5099726, 5179558, 5099162, 5099092, 5100506, 5120497, 5099693, 5101209, 5109524, 5099788, 5115841, 5099356, 5194997, 5099129, 5100637, 5109465, 5151880, 5099574, 5122907);

Date: 2025-02-04 17:21:56 Duration: 6ms

9

502,386

Details

36s802ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 04	00	5,104	324ms	0ms
	01	4,758	300ms	0ms
	02	4,419	282ms	0ms
	03	5,246	322ms	0ms
	04	4,481	274ms	0ms
	05	2,070	112ms	0ms
	06	6,681	385ms	0ms
	07	4,459	227ms	0ms
	08	12,958	746ms	0ms
	09	33,333	2s325ms	0ms
	10	45,296	3s230ms	0ms
	11	47,795	4s196ms	0ms
	12	51,545	3s868ms	0ms
	13	44,509	3s142ms	0ms
	14	35,988	2s553ms	0ms
	15	38,798	2s881ms	0ms
	16	34,387	2s408ms	0ms
	17	30,841	2s227ms	0ms
	18	26,046	2s519ms	0ms
	19	24,545	2s120ms	0ms
	20	19,231	1s140ms	0ms
	21	13,808	834ms	0ms
	22	6,088	375ms	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 (61, 5, 17, 14, 52, 4, 24, 22, 29, 8, 119, 26, 16, 60, 9, 73);

Date: 2025-02-04 11:28:12 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 (55, 70, 52, 17, 6, 113, 78, 64, 41, 11, 22, 102, 16, 48, 75, 27);

Date: 2025-02-04 11:02: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, 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);

Date: 2025-02-04 18:47:18 Duration: 0ms

10

363,128

Details

2m6s

0ms

4ms

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
Feb 04	00	3,380	1s36ms	0ms
	01	2,117	683ms	0ms
	02	2,367	769ms	0ms
	03	1,746	559ms	0ms
	04	1,136	358ms	0ms
	05	916	277ms	0ms
	06	2,043	654ms	0ms
	07	1,056	305ms	0ms
	08	9,987	2s969ms	0ms
	09	17,359	6s44ms	0ms
	10	25,533	8s768ms	0ms
	11	42,437	16s219ms	0ms
	12	36,802	13s211ms	0ms
	13	36,602	12s314ms	0ms
	14	32,254	10s969ms	0ms
	15	31,973	10s979ms	0ms
	16	26,049	8s857ms	0ms
	17	25,890	8s821ms	0ms
	18	20,367	8s380ms	0ms
	19	16,749	6s603ms	0ms
	20	15,181	4s453ms	0ms
	21	7,917	2s405ms	0ms
	22	3,267	977ms	0ms

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

Date: 2025-02-04 11:25:32 Duration: 4ms
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 = 1299) OR r.global) ORDER BY r.id;

Date: 2025-02-04 09:26:11 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 = 884) OR r.global) ORDER BY r.id;

Date: 2025-02-04 15:30:40 Duration: 2ms

11

350,243

Details

1m11s

0ms

3ms

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
Feb 04	00	3,075	590ms	0ms
	01	2,947	570ms	0ms
	02	2,799	557ms	0ms
	03	3,329	668ms	0ms
	04	2,747	570ms	0ms
	05	1,830	300ms	0ms
	06	3,829	696ms	0ms
	07	2,812	451ms	0ms
	08	11,125	1s816ms	0ms
	09	24,506	4s715ms	0ms
	10	32,425	6s661ms	0ms
	11	32,244	7s696ms	0ms
	12	34,735	7s339ms	0ms
	13	30,515	5s950ms	0ms
	14	26,773	5s242ms	0ms
	15	29,185	5s911ms	0ms
	16	24,722	4s783ms	0ms
	17	22,774	4s557ms	0ms
	18	17,412	4s400ms	0ms
	19	15,227	3s741ms	0ms
	20	11,580	2s68ms	0ms
	21	8,708	1s537ms	0ms
	22	4,944	811ms	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 (8006361);

Date: 2025-02-04 17:21:56 Duration: 3ms
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 (8006411);

Date: 2025-02-04 17:21:56 Duration: 3ms
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 (8006458);

Date: 2025-02-04 17:21:56 Duration: 3ms

12

281,385

Details

2d4h57m31s

524ms

5s126ms

677ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	8,538	1h27m31s	615ms
	01	7,359	1h14m18s	605ms
	02	9,477	1h37m19s	616ms
	03	9,890	1h40m46s	611ms
	04	9,131	1h33m13s	612ms
	05	3,717	36m34s	590ms
	06	6,692	1h7m42s	607ms
	07	2,602	25m55s	597ms
	08	5,999	1h40s	606ms
	09	13,794	2h34m11s	670ms
	10	16,643	3h7m12s	674ms
	11	22,460	4h42m56s	755ms
	12	19,646	3h47m40s	695ms
	13	11,725	2h9m28s	662ms
	14	13,117	2h28m13s	678ms
	15	12,721	2h26m42s	691ms
	16	12,092	2h14m33s	667ms
	17	12,224	2h15m8s	663ms
	18	26,150	5h36m19s	771ms
	19	31,344	6h23m9s	733ms
	20	12,156	2h4m32s	614ms
	21	8,763	1h29m54s	615ms
	22	5,145	53m24s	622ms

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

Date: 2025-02-04 18:04:48 Duration: 5s126ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5058159)) AND (("shipping_track"."id" not in (41995988, 41995988)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 19:17:23 Duration: 5s51ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5053457)) AND (("shipping_track"."id" not in (41960894, 41960894)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 18:05:09 Duration: 5s35ms

13

274,736

Details

52s190ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 04	00	2,913	425ms	0ms
	01	2,124	284ms	0ms
	02	2,497	340ms	0ms
	03	2,058	269ms	0ms
	04	1,663	201ms	0ms
	05	1,290	171ms	0ms
	06	1,806	256ms	0ms
	07	1,489	185ms	0ms
	08	11,269	1s604ms	0ms
	09	14,828	2s583ms	0ms
	10	21,035	3s871ms	0ms
	11	30,253	6s856ms	0ms
	12	24,431	4s994ms	0ms
	13	24,566	4s695ms	0ms
	14	22,757	4s300ms	0ms
	15	23,481	4s586ms	0ms
	16	18,792	3s394ms	0ms
	17	19,762	3s602ms	0ms
	18	16,055	3s691ms	0ms
	19	12,858	2s831ms	0ms
	20	10,186	1s728ms	0ms
	21	5,682	889ms	0ms
	22	2,941	427ms	0ms

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

Date: 2025-02-04 11:27:52 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-02-04 17:23:00 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 994 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_multi_company' AND model = 'res.groups');

Date: 2025-02-04 11:27:52 Duration: 1ms

14

237,458

Details

1m5s

0ms

31ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	3,307	814ms	0ms
	01	2,719	700ms	0ms
	02	3,084	811ms	0ms
	03	3,492	950ms	0ms
	04	2,961	848ms	0ms
	05	860	270ms	0ms
	06	3,173	956ms	0ms
	07	1,516	401ms	0ms
	08	5,293	1s417ms	0ms
	09	14,149	3s988ms	0ms
	10	19,536	5s464ms	0ms
	11	19,176	6s415ms	0ms
	12	21,927	5s907ms	0ms
	13	19,696	4s642ms	0ms
	14	17,033	4s336ms	0ms
	15	19,572	6s217ms	0ms
	16	16,157	3s849ms	0ms
	17	14,779	3s848ms	0ms
	18	13,604	4s383ms	0ms
	19	13,079	4s74ms	0ms
	20	9,439	2s257ms	0ms
	21	8,280	1s824ms	0ms
	22	4,626	1s309ms	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 (32409540, 32408892, 32408895);

Date: 2025-02-04 18:38:47 Duration: 31ms
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 (42167714, 32213903, 32333856, 32409326, 32378446, 32341294, 32376531, 32370744, 32348982, 42001917, 32321411, 32371094, 32474454, 32409328, 32241823, 32201281, 32327216, 32204089, 32379023, 42135150, 32286778, 32440396, 32280542, 42071922, 41837717, 32326814, 32405347, 32316224, 42152236, 32262223, 32293542, 32322716, 32658379, 32301147, 32356750, 32321893, 32380371, 32348924, 41994756, 41996353, 41525697, 32381735, 32346690, 32348292, 32288711, 32242479, 32289984, 32420449, 32285374, 32307457, 32348627, 42154181, 32296444, 32435917, 32270746, 32258144, 41526990, 32389346, 32290327, 32413611, 32225270, 32328398, 32389872, 42168813, 32320136, 32203624, 32303940, 32415421, 32361757, 32361758, 32414798, 32361100, 32258126, 41903110, 32387867, 32327357, 41800663, 32333793, 32329142, 32285379, 32319146, 41752580, 32408649, 32335917, 32283022, 41526740, 32373542, 42129258, 32314602, 32321479, 32346948, 32374313, 41835388, 32364609, 42085386, 32293716, 32219136, 32410863, 32367632, 32334034, 42104361, 32329969, 32439184, 42079954, 42129484, 41970468, 32445842, 42135154, 32365279, 32297016, 32203615, 32208428, 32336362, 32336154, 42137741, 42114383, 32318977, 32364554, 41526609, 32247434, 41710839, 32412364, 42169157, 32456879, 41773899, 32429858, 32346027, 32275106, 32250144, 32303493, 42001915, 32213525, 32273411, 32367851, 41835395, 32234512, 32349749, 32278979, 41835391, 42162589, 42101822, 42162578, 32196133, 32281181, 32252619, 32411763, 41985604, 32235137, 32321478, 32439959, 32359845, 32386822, 32366208, 32366455, 32339216, 32376304, 32196023, 32404654, 41526498, 42162524, 32258371, 32412008, 32349001, 42070564, 42070559, 32367157, 32227395, 32381739, 32367555, 32306913, 32193026, 42176370, 32319044, 32296874, 32275385, 32357578, 32362251, 32307237, 32287477, 32440853, 32413237, 32292862, 32343624, 32447559, 32385715, 32254788, 32304427, 32183630, 32225261, 32288694, 32429620, 42055791, 32343633, 32370684, 32336363, 32208736, 32439947, 32296782, 32227370, 32348598, 32413248, 32474484, 41526501, 42171006, 32388530, 32296034, 32312630, 32300344, 32356754, 32248989, 32365062, 32365963, 32336377, 32336065, 32400885, 32439944, 32330781, 32412858, 32441208, 32208780, 32389993, 42132230, 32326792, 32285376, 32362073, 42134776, 42008947, 32285375, 32290247, 32412937, 42134884, 32288710, 32280693, 32235115, 32375126, 32258369, 32363973, 32218489, 42130176, 32299562, 32319446, 32340651, 32263030, 32270739, 32380874, 42080293, 32258629, 32437400, 32328025, 32403901, 32440150, 32290902, 41526314, 32277274, 32198498, 32340606, 32198497, 32353413, 32294904, 32376629, 32258405, 42154168, 32326223, 32257872, 32339229, 32320782, 32429593, 42125415, 32331253, 41774290, 32200012, 42069533, 32363664, 32312791, 42081987, 32368302, 42000129, 32390892, 32412934, 32287360, 32372659, 41601055, 42176379, 32275422, 42135193, 32270745, 32440212, 42166619, 32273489, 32358857, 32426174, 32327562, 32373493, 32285735, 32350928, 32333995, 42172588, 42152415, 32274051, 32380641, 42104001, 32429605, 41469548, 32357451, 32203626, 42153783, 41997614, 41835406, 32377686, 32370746, 32449157, 32327252, 32439773, 32361106, 32374542, 32341248, 32427196, 32339217, 32342443, 32252600, 32359746, 32362475, 32412504, 41967091, 32388834, 41526734, 32358928, 32302769, 32413615, 42135013, 32435900, 32354046, 32344960, 32373089, 32378193, 32304156, 42059162, 42168987, 32336054, 32196132, 32318812, 32403963, 32430270, 32321922, 32221642, 32234867, 32293982, 32284792, 32326988, 32430249, 32265151, 32292880, 32375853, 32287357, 32290639, 32202463, 32399153, 42137733, 42125098, 32370968, 32446652, 32318824, 32442452, 41526613, 32397659, 32381734, 32368442, 32398527, 32247238, 32271320, 32426217, 32389662, 32430248, 32403982, 32290456, 42077942, 32209110, 32324792, 32339232, 42032407, 41526607, 42107537, 32236767, 32413184, 32333974, 32388675, 32320123, 32357310, 32304380, 32189183, 32256923, 32256918, 32342367, 32290875, 42145433, 32360499, 32364524);

Date: 2025-02-04 15:30:10 Duration: 10ms
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 (42154143, 32446597, 42169562, 32304866, 42063271, 41526713, 32211318, 32213524, 32385910, 32347222, 42107203, 32296597, 42039767, 42134954, 42119302, 32290549, 32209794, 32248914, 32214713);

Date: 2025-02-04 17:21:56 Duration: 9ms

15

172,977

Details

1m40s

0ms

41ms

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"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "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"."is_change_cash_price" AS "is_change_cash_price", "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 #15

Day	Hour	Count	Duration	Avg duration
Feb 04	00	345	254ms	0ms
	01	255	174ms	0ms
	02	261	164ms	0ms
	03	223	134ms	0ms
	04	225	138ms	0ms
	05	122	72ms	0ms
	06	431	195ms	0ms
	07	545	204ms	0ms
	08	3,815	2s3ms	0ms
	09	8,123	4s670ms	0ms
	10	10,730	6s299ms	0ms
	11	10,999	7s445ms	0ms
	12	10,935	6s964ms	0ms
	13	10,911	6s691ms	0ms
	14	10,417	6s169ms	0ms
	15	12,369	8s403ms	0ms
	16	12,561	6s388ms	0ms
	17	18,120	9s646ms	0ms
	18	31,137	18s736ms	0ms
	19	24,127	12s677ms	0ms
	20	3,151	1s700ms	0ms
	21	1,963	1s101ms	0ms
	22	1,212	727ms	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"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "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"."is_change_cash_price" AS "is_change_cash_price", "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 (4787008, 4997240, 5003038, 5007659, 5021972, 5026550, 5030419, 4997024, 4997452, 4989598, 4929631, 4963254, 4812906, 4970917, 4891114, 4960128, 4963071, 4852302, 4970322, 5005898, 4950380, 5006652, 4988716, 4965243, 4994884, 4962026, 4963422, 4989836, 5008088, 5009190, 5032340, 4997929, 5003034, 4920777, 4974974, 4983684, 4982069, 5000391, 4926882, 5013361, 4963046, 4952110, 4969224, 4931163, 4978768, 5003689, 4980670, 5010184, 4994202, 5001753, 4844195, 5026887, 5001666, 4961194, 5022421, 4837731, 4857960, 5001598, 5034726, 4993229, 5046035, 5031188, 4962751, 5027179, 5045823, 5013398, 5012063, 4995366, 4986833, 5003954, 4970327, 4987265, 4978982, 4986760, 5003395, 4992909, 5017845, 5019127, 5020496, 5021974, 2751449, 4920432, 4961825, 4852578, 4888278, 4946768, 4989786, 5018711, 5023396, 5023528, 5030055, 5030329, 5031234, 5034787, 5035971, 5038301, 5038995, 5039060, 5039520, 5039963, 5002269, 5023965, 5040086, 4905990, 4991659, 5019914, 5037974, 4971354, 4857481, 5006639, 5036852, 4995775, 5041473, 5007931, 5040111, 5038899, 4961202, 5035247, 5022894, 5026483, 4584883, 5019685, 4633310, 5041455, 5029519, 5009176, 5003401, 4998360, 5019167, 4741234, 4880264, 4950383, 4952022, 4963032, 4963188, 4976319, 4998190, 5001956, 5013386, 5023884, 4946739, 5002145, 4944444, 5013360, 5005569, 4894897, 5032434, 4825875, 5042421, 5041627, 5010274, 4875565, 5031474, 4916637, 4587135, 5038436, 5001462, 4988453, 5013371, 5043729, 4706437, 4582076, 4706237, 5018880, 4986752, 5043739, 5012972, 5032377, 5040106, 5026412, 4742900, 4846458, 4930932, 4998171, 4999576, 5014385, 5021938, 5038442, 4983945, 4967593, 5011888, 4995176, 4960186, 5015450, 4949803, 4985799, 4951482, 4980484);

Date: 2025-02-04 17:21:56 Duration: 41ms
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"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "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"."is_change_cash_price" AS "is_change_cash_price", "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 (4170617, 3685770, 2030935, 3127501, 2342906, 1992315, 2842777, 1643980, 2315051, 4431949, 4788510, 4689521, 4689514, 4629712, 4703014, 1159262, 1591576, 1454224, 948341, 3475515, 2145094, 1618519, 3378141, 4163275, 4369907, 3680516, 2728628, 2728627, 1853398, 1853065, 1722989, 2546378, 1619715, 2291594, 2292257, 1682297, 1683292, 1284201, 1323229, 3144964, 2346993, 2252992, 1666955, 1846978, 1100098, 3145180, 3317308, 1901071, 3031641, 3148425, 3173773, 3147699, 3173774, 3203947, 3175281, 3033010, 2935119, 3367968, 3247163, 3515270, 3173489, 2645905, 3368129, 3367090, 3319550, 3516275, 3550244, 3369565, 3317321, 3516292, 3319126, 1308903, 3250128, 3251203, 4567517, 3369154, 3911954, 3440751, 3174036, 3316629, 4117643, 4566777, 3246999, 3469197, 1287686, 4451754, 3704062, 4565463, 3432793, 3515839, 4452417, 4561341, 4332797, 3599267, 1135392, 3767805, 4567463, 3599184, 3662094, 3667651, 4567466, 3823305, 3432863, 4444275, 4449169, 4033656, 3886543, 976677, 1286532, 4649991, 4651094, 4444272, 1245634, 1132880, 1041097, 1286669, 1135513, 1322900, 3767541, 1181459, 3666714, 1473371, 3703645, 1179719, 1107654, 1040287, 972380, 922799, 1033702, 4812442, 3783437, 4002106, 4034533, 4034388, 3820113, 3918704, 4029366, 4029683, 4001338, 4059251, 3886663, 4244780, 4277004, 3819909, 4059767, 4142097, 4277053, 2052162, 2331618, 2546692, 2541415, 1902413, 1933768, 2258701, 2326352, 4029361, 2427812, 2141358, 4001939, 2142597, 2466053, 2176668, 2332468, 2143454, 2289766, 2178280, 2288258, 2139346, 2332037, 2726311, 2252991, 2292258, 2253425, 2212511, 2174992, 2286364, 2531911, 4333297, 2465235, 2653181, 2541498, 2547334, 2420792, 4302355, 2648747, 2730222, 2777561, 2774850, 2936518, 2654240, 2938193, 2649453, 2778246, 2778245, 2726232, 3965616, 2893965, 4060900, 2938509, 2997419, 2997740, 4031875, 3033011, 2935639, 2938871, 4303632, 4059682, 4244579, 4332281, 4304437, 4277354, 4300220, 1159558, 1196947, 1542209, 2806937, 1217161, 1018668, 1849256, 1900214, 4050920, 2627365, 3303947, 4068085, 4345392, 2762509, 948336, 3996217, 3557639, 1201708, 1271930, 4407983, 948334, 1201716, 1271933, 2237300, 2357346, 2357350);

Date: 2025-02-04 17:26:32 Duration: 20ms
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"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "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"."is_change_cash_price" AS "is_change_cash_price", "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 (5018711, 5026412, 5026434, 4962081, 4963252, 4968637, 4974829, 4989605, 4990096, 4994909, 5002569, 5006112, 5038830, 4879993, 4990420, 4964771, 4605040, 4989211, 4996898, 4960592, 4989193, 4879595, 4969692, 4960596, 4855798, 4989208, 5000045, 4990422, 4991724, 4897493, 4945693, 4945688, 4969758, 4861845, 4989240, 4989218, 4969719, 4991726, 4964786, 4989198, 4990410, 5000058, 4991700, 4990426, 5000043, 4989237, 4996812, 4990408, 4990417, 4990425, 4990423, 5000053, 4921845, 5000040, 4960578, 4991705, 4945692, 4890981, 5000049, 4695029, 4940736, 4960289, 4963359, 4996905, 4990419, 4989235, 4655895, 4969792, 4870261, 4572254, 5000037, 4969768, 4990421, 4969774, 4926978, 5000060, 4889015, 4889021, 4946572, 4969747, 4989222, 4879997, 4665235, 4950778, 4959539, 5000054, 4888922, 4960613, 4848774, 4848776, 4969711, 4815408, 4964845, 4916886, 4963721, 4975431, 5006340, 5014400, 4969673, 4861822, 4889019, 4921760, 4926990, 4964783, 4964788, 4558412, 4921915, 4964834, 4964797, 4969730, 4261075, 4928445, 4964791, 4960616, 4496686, 4969701, 4969771, 4969708, 4964831, 4969728, 4960608, 4921754, 4928394, 4926968, 4913568, 4969822, 4888941, 4928435, 4969733, 4959543, 4969755, 4959533, 4964777, 4969676, 4969738, 4969725, 4928443, 4969721, 4969665, 4630520, 4853730, 4948077, 4961199, 4965898, 4966508, 4973042, 4969797, 4946566, 4862060, 4959544, 4862035, 4468082, 4969766, 4921838, 4964816, 4926966, 4861965, 4949338, 4946556, 4905056, 4867689, 4879514, 4925229, 4861856, 4879992, 4946549, 4884751, 4921806, 4921973, 4913583, 4921905, 4946554, 4926973, 4888994, 4926980, 4861900, 4815434, 4888908, 4927004, 4850991, 4928391, 4928457, 4913582, 4946557, 4862023, 4884739, 4891024, 4926971, 4889035, 4921824, 4928449, 4913566, 4928453, 4936289, 4889028, 4889011, 4913550, 4928441);

Date: 2025-02-04 17:21:59 Duration: 19ms

16

172,277

Details

16s840ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	1,851	159ms	0ms
	01	1,810	163ms	0ms
	02	1,549	150ms	0ms
	03	2,130	191ms	0ms
	04	1,848	170ms	0ms
	05	779	63ms	0ms
	06	2,367	209ms	0ms
	07	1,379	107ms	0ms
	08	4,578	408ms	0ms
	09	12,094	1s300ms	0ms
	10	17,133	1s977ms	0ms
	11	16,430	1s579ms	0ms
	12	17,542	1s547ms	0ms
	13	15,338	1s383ms	0ms
	14	12,231	1s220ms	0ms
	15	13,328	1s415ms	0ms
	16	11,810	877ms	0ms
	17	10,529	962ms	0ms
	18	8,325	1s77ms	0ms
	19	7,513	1s32ms	0ms
	20	5,697	404ms	0ms
	21	4,165	297ms	0ms
	22	1,851	139ms	0ms

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

Date: 2025-02-04 15:43:12 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: 2025-02-04 17:21:56 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: 2025-02-04 17:21:56 Duration: 1ms

17

155,119

Details

10s5ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	1,561	80ms	0ms
	01	886	45ms	0ms
	02	918	49ms	0ms
	03	743	38ms	0ms
	04	429	21ms	0ms
	05	390	19ms	0ms
	06	884	48ms	0ms
	07	466	22ms	0ms
	08	4,227	218ms	0ms
	09	7,265	453ms	0ms
	10	10,714	681ms	0ms
	11	17,979	1s341ms	0ms
	12	15,264	1s25ms	0ms
	13	15,880	981ms	0ms
	14	13,765	850ms	0ms
	15	13,645	870ms	0ms
	16	10,918	664ms	0ms
	17	11,326	707ms	0ms
	18	8,711	692ms	0ms
	19	7,270	550ms	0ms
	20	6,850	372ms	0ms
	21	3,545	193ms	0ms
	22	1,483	77ms	0ms

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

Date: 2025-02-04 18:59:11 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (21);

Date: 2025-02-04 15:29:32 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: 2025-02-04 13:28:36 Duration: 0ms

18

155,038

Details

2h11m47s

37ms

344ms

51ms

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
Feb 04	00	3,305	2m29s	45ms
	01	2,398	1m47s	45ms
	02	4,442	3m21s	45ms
	03	2,759	2m5s	45ms
	04	2,553	1m56s	45ms
	05	887	39s497ms	44ms
	06	2,366	1m46s	45ms
	07	868	39s406ms	45ms
	08	3,776	2m54s	46ms
	09	10,262	8m37s	50ms
	10	11,739	9m58s	50ms
	11	16,352	15m21s	56ms
	12	15,626	13m36s	52ms
	13	9,878	8m6s	49ms
	14	10,284	8m40s	50ms
	15	9,511	8m5s	51ms
	16	8,303	6m45s	48ms
	17	6,954	5m53s	50ms
	18	6,418	6m30s	60ms
	19	10,220	9m47s	57ms
	20	8,062	6m25s	47ms
	21	5,415	4m13s	46ms
	22	2,660	2m2s	46ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5020530, 5001550)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 18:08:22 Duration: 344ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5041299, 5027363)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 18:05:54 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4999986, 4975441)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 11:18:39 Duration: 308ms

19

149,039

Details

20s628ms

0ms

2ms

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	1,537	167ms	0ms
	01	867	95ms	0ms
	02	898	102ms	0ms
	03	711	77ms	0ms
	04	420	44ms	0ms
	05	365	38ms	0ms
	06	857	98ms	0ms
	07	437	44ms	0ms
	08	4,108	442ms	0ms
	09	7,103	946ms	0ms
	10	10,306	1s402ms	0ms
	11	17,248	2s820ms	0ms
	12	14,514	2s82ms	0ms
	13	15,163	1s990ms	0ms
	14	13,267	1s747ms	0ms
	15	13,210	1s813ms	0ms
	16	10,460	1s362ms	0ms
	17	11,023	1s463ms	0ms
	18	8,267	1s459ms	0ms
	19	6,887	1s135ms	0ms
	20	6,542	745ms	0ms
	21	3,391	388ms	0ms
	22	1,458	159ms	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 (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-04 18:57:11 Duration: 2ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-04 11:08:13 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-04 12:28:44 Duration: 1ms

20

146,370

Details

8h18m6s

140ms

1s529ms

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" = ?)) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 04	00	1,459	3m48s	156ms
	01	2,696	6m58s	155ms
	02	2,761	7m13s	156ms
	03	2,377	6m11s	156ms
	04	2,691	7m	156ms
	05	1,609	4m8s	154ms
	06	2,664	6m55s	155ms
	07	1,286	3m19s	155ms
	08	4,899	13m	159ms
	09	8,747	25m17s	173ms
	10	12,290	37m2s	180ms
	11	12,773	41m33s	195ms
	12	5,416	16m33s	183ms
	13	7,499	22m19s	178ms
	14	6,919	20m14s	175ms
	15	9,219	27m6s	176ms
	16	11,754	34m26s	175ms
	17	21,308	1h22m6s	231ms
	18	24,913	2h1m14s	291ms
	19	1,449	6m5s	251ms
	20	1,115	3m44s	201ms
	21	206	41s287ms	200ms
	22	320	1m3s	199ms

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

Date: 2025-02-04 18:09:27 Duration: 1s529ms
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" = '291649')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 18:05:17 Duration: 1s520ms
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" = '230012')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:19:44 Duration: 1s506ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m59s

2m5s

46

Details

1h36m20s

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
Feb 04	01	1	59m59s	59m59s
	04	1	0ms	0ms
	06	3	0ms	0ms
	07	1	0ms	0ms
	08	4	3ms	0ms
	09	3	0ms	0ms
	10	3	23m51s	7m57s
	11	3	12m28s	4m9s
	12	2	1ms	0ms
	14	8	10ms	1ms
	15	6	11ms	1ms
	17	2	1ms	0ms
	18	2	0ms	0ms
	20	6	5ms	0ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-02-04 00:35:34.583426', "last_update" = '2025-02-03 23:50:34.583448', "write_date" = '2025-02-03 23:50:34.257785', "write_uid" = 1 WHERE id IN (829);

Date: 2025-02-04 01:50:34 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-04 10:09:29.023278', "last_update" = '2025-02-04 09:24:29.023302', "write_date" = '2025-02-04 09:24:28.639524', "write_uid" = 965 WHERE id IN (965);

Date: 2025-02-04 10:48:20 Duration: 23m51s
UPDATE "res_users" SET "exp_date" = '2025-02-04 10:43:52.275971', "last_update" = '2025-02-04 09:58:52.275994', "write_date" = '2025-02-04 09:58:51.917252', "write_uid" = 1 WHERE id IN (965);

Date: 2025-02-04 11:11:21 Duration: 12m28s

2

0ms

45m52s

57s223ms

295

Details

4h41m20s

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
Feb 04	00	2	1ms	0ms
	01	3	0ms	0ms
	02	2	0ms	0ms
	03	4	0ms	0ms
	04	1	45m52s	45m52s
	05	4	0ms	0ms
	06	4	2ms	0ms
	07	1	0ms	0ms
	08	37	2h50m37s	4m36s
	09	21	14ms	0ms
	10	24	41s984ms	1s749ms
	11	31	39m2s	1m15s
	12	23	32ms	1ms
	13	19	23ms	1ms
	14	19	17ms	0ms
	15	21	15m50s	45s250ms
	16	21	20ms	0ms
	17	11	14ms	1ms
	18	11	9m14s	50s450ms
	19	14	21ms	1ms
	20	12	16ms	1ms
	21	4	3ms	0ms
	22	6	5ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-04 03:24:14.610264', "last_update" = '2025-02-04 02:39:14.610287', "sid" = 'c0934bc962f8caf3edac2851f1d2d9b82e78385b', "write_date" = '2025-02-04 02:39:14.276785', "write_uid" = 1 WHERE id IN (1053);

Date: 2025-02-04 04:25:07 Duration: 45m52s
UPDATE "res_users" SET "exp_date" = '2025-02-04 14:31:30.995189', "last_update" = '2025-02-04 13:46:30.995211', "sid" = '32b51d69bbd7e9dac9b6c0e7484206f3b23e6eda', "write_date" = '2025-02-04 13:46:30.670008', "write_uid" = 959 WHERE id IN (959);

Date: 2025-02-04 15:02:21 Duration: 15m50s
UPDATE "res_users" SET "exp_date" = '2025-02-04 07:38:07.889911', "last_update" = '2025-02-04 06:53:07.889929', "sid" = 'd2a5116ed7a7ce67cb7df279ce273c386d0b3a68', "write_date" = '2025-02-04 06:53:07.570484', "write_uid" = 1 WHERE id IN (825);

Date: 2025-02-04 08:08:21 Duration: 15m13s

3

0ms

58m26s

3s361ms

65,239

Details

2d12h55m33s

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
Feb 04	00	808	186ms	0ms
	01	988	58m26s	3s549ms
	02	899	205ms	0ms
	03	1,071	10m46s	603ms
	04	1,007	234ms	0ms
	05	408	88ms	0ms
	06	674	149ms	0ms
	07	407	88ms	0ms
	08	1,691	2h25m10s	5s151ms
	09	3,963	1s86ms	0ms
	10	5,973	2h37m57s	1s586ms
	11	6,885	6h42m20s	3s506ms
	12	6,924	7h21s	3s642ms
	13	5,838	3h6m43s	1s919ms
	14	4,942	3h32m8s	2s575ms
	15	4,960	11h27m50s	8s320ms
	16	4,249	1m39s	23ms
	17	3,690	2h8m49s	2s94ms
	18	2,970	6h58m37s	8s457ms
	19	2,672	1h55m4s	2s583ms
	20	1,997	11h49m20s	21s312ms
	21	1,546	372ms	0ms
	22	677	14s29ms	20ms

update res_users set sid = '641f11522769234e0b840ba6ce48be9e22a9018a', last_update = '2025-02-03 23:52:07.548097', exp_date = '2025-02-04 00:37:07.548099', logged_in = 'TRUE' where id = 829;

Date: 2025-02-04 01:50:34 Duration: 58m26s
update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:47:20.639136', exp_date = '2025-02-04 19:32:20.639138', logged_in = 'TRUE' where id = 1390;

Date: 2025-02-04 20:43:20 Duration: 56m
update res_users set sid = 'ff8374658889388ae539705db73440fdc737e9f1', last_update = '2025-02-04 18:47:20.638921', exp_date = '2025-02-04 19:32:20.638924', logged_in = 'TRUE' where id = 1390;

Date: 2025-02-04 20:43:20 Duration: 56m

4

387ms

5s856ms

3s193ms

313

Details

16m39s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 04	10	34	1m55s	3s404ms
	11	10	32s732ms	3s273ms
	12	5	10s229ms	2s45ms
	13	40	2m7s	3s191ms
	14	18	1m	3s372ms
	15	56	2m56s	3s146ms
	16	30	1m35s	3s177ms
	17	49	2m23s	2s928ms
	18	20	1m18s	3s921ms
	19	11	38s128ms	3s466ms
	20	31	1m34s	3s47ms
	21	9	26s522ms	2s946ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))) 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 (127)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))))) 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 (127)))))))) AND ("policy_number"."name"::text ilike '%65528%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-04 18:03:43 Duration: 5s856ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))) 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 (127)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))))) 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 (127)))))))) AND ("policy_number"."name"::text ilike '%65528%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-04 18:03:55 Duration: 5s407ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))) 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 (127)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))))))) 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 (127)))))))) AND ("policy_number"."name"::text ilike '%6552%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-04 18:03:41 Duration: 4s647ms

5

188ms

2s24ms

848ms

12,039

Details

2h50m12s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 04	00	364	2m41s	444ms
	01	348	3m8s	542ms
	02	228	1m56s	509ms
	03	415	5m4s	734ms
	05	4	3s563ms	890ms
	08	17	15s348ms	902ms
	09	5	3s998ms	799ms
	10	44	39s467ms	896ms
	11	5	4s783ms	956ms
	12	29	32s45ms	1s105ms
	13	305	3m1s	596ms
	14	538	6m59s	779ms
	15	700	9m47s	839ms
	16	523	5m45s	659ms
	17	754	10m	796ms
	18	1,675	27m57s	1s1ms
	19	2,333	38m12s	982ms
	20	1,867	27m48s	893ms
	21	585	7m46s	797ms
	22	1,300	18m21s	847ms

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

Date: 2025-02-04 18:56:55 Duration: 2s24ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '159653')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 19:17:08 Duration: 1s958ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '318968')) 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 (60))))))) 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 (60)))))) 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 (60)))))) 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 (60))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 18:57:05 Duration: 1s954ms

6

526ms

6s160ms

699ms

43,662

Details

8h28m51s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 04	00	176	2m	681ms
	01	162	1m52s	692ms
	02	562	5m59s	640ms
	03	196	2m17s	703ms
	04	202	2m20s	697ms
	05	357	3m38s	611ms
	06	254	2m44s	647ms
	07	168	1m45s	626ms
	08	1,237	12m57s	628ms
	09	3,858	44m12s	687ms
	10	2,763	32m34s	707ms
	11	4,488	59m20s	793ms
	12	4,991	1h20s	725ms
	13	3,426	38m53s	681ms
	14	3,811	42m58s	676ms
	15	3,595	41m57s	700ms
	16	2,566	28m50s	674ms
	17	1,928	21m37s	673ms
	18	2,811	35m11s	751ms
	19	2,732	33m37s	738ms
	20	1,825	18m16s	600ms
	21	1,206	11m54s	592ms
	22	348	3m26s	594ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5042986, 5040485, 5039371, 5034661, 5029086, 5024279, 5016291, 4992926)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 11:18:33 Duration: 6s160ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5011445, 5011190, 4997696, 4995447, 4993847)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 11:19:13 Duration: 4s958ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5047156, 5047155, 5047127, 5047126, 5047125, 5046733, 5028374, 5027432, 5027429, 5027425, 5027418, 5027415, 5027407, 5027404, 5027402, 5027398, 5027395, 5027391, 5027388, 5027385, 5027382, 5027379, 5027376)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 11:18:23 Duration: 4s876ms

7

524ms

5s126ms

677ms

281,385

Details

2d4h57m31s

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
Feb 04	00	8,538	1h27m31s	615ms
	01	7,359	1h14m18s	605ms
	02	9,477	1h37m19s	616ms
	03	9,890	1h40m46s	611ms
	04	9,131	1h33m13s	612ms
	05	3,717	36m34s	590ms
	06	6,692	1h7m42s	607ms
	07	2,602	25m55s	597ms
	08	5,999	1h40s	606ms
	09	13,794	2h34m11s	670ms
	10	16,643	3h7m12s	674ms
	11	22,460	4h42m56s	755ms
	12	19,646	3h47m40s	695ms
	13	11,725	2h9m28s	662ms
	14	13,117	2h28m13s	678ms
	15	12,721	2h26m42s	691ms
	16	12,092	2h14m33s	667ms
	17	12,224	2h15m8s	663ms
	18	26,150	5h36m19s	771ms
	19	31,344	6h23m9s	733ms
	20	12,156	2h4m32s	614ms
	21	8,763	1h29m54s	615ms
	22	5,145	53m24s	622ms

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

Date: 2025-02-04 18:04:48 Duration: 5s126ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5058159)) AND (("shipping_track"."id" not in (41995988, 41995988)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 19:17:23 Duration: 5s51ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5053457)) AND (("shipping_track"."id" not in (41960894, 41960894)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-04 18:05:09 Duration: 5s35ms

8

16ms

6s262ms

543ms

3,309

Details

29m57s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 04	00	8	988ms	123ms
	01	1	222ms	222ms
	02	1	22ms	22ms
	05	1	98ms	98ms
	06	2	122ms	61ms
	07	3	474ms	158ms
	08	65	11s142ms	171ms
	09	121	26s105ms	215ms
	10	259	1m6s	256ms
	11	328	1m32s	283ms
	12	315	1m34s	299ms
	13	459	1m49s	238ms
	14	254	1m13s	289ms
	15	877	18m27s	1s263ms
	16	163	47s345ms	290ms
	17	208	54s711ms	263ms
	18	66	30s495ms	462ms
	19	79	48s481ms	613ms
	20	61	23s853ms	391ms
	21	26	6s839ms	263ms
	22	12	1s732ms	144ms

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

Date: 2025-02-04 15:30:18 Duration: 6s262ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-04 15:30:28 Duration: 5s973ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-04 18:05:41 Duration: 2s613ms

9

187ms

1s805ms

294ms

18,152

Details

1h29m9s

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
Feb 04	00	1,066	4m26s	249ms
	01	522	2m9s	247ms
	02	1,291	5m16s	244ms
	03	938	3m52s	247ms
	04	1,105	4m34s	248ms
	06	722	2m59s	248ms
	07	44	9s979ms	226ms
	08	7	1s741ms	248ms
	09	211	55s49ms	260ms
	10	36	10s317ms	286ms
	11	10	3s288ms	328ms
	12	191	54s682ms	286ms
	13	131	36s938ms	281ms
	14	110	31s943ms	290ms
	15	323	1m31s	284ms
	16	1,213	5m46s	285ms
	17	1,332	6m52s	309ms
	18	1,976	12m28s	378ms
	19	2,010	11m57s	356ms
	20	1,123	5m36s	299ms
	21	2,570	12m32s	292ms
	22	1,221	5m42s	280ms

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

Date: 2025-02-04 18:04:56 Duration: 1s805ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '186736')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 18:07:32 Duration: 1s714ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '185498')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-04 18:05:03 Duration: 1s655ms

10

150ms

2s511ms

273ms

31,358

Details

2h23m6s

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
Feb 04	08	1,668	7m3s	253ms
	09	2,817	12m34s	267ms
	10	3,722	16m21s	263ms
	11	3,785	18m42s	296ms
	12	1,973	8m57s	272ms
	13	3,216	13m49s	257ms
	14	3,111	14m35s	281ms
	15	4,436	19m32s	264ms
	16	3,844	17m26s	272ms
	17	2,760	13m49s	300ms
	18	26	15s51ms	578ms

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" = '211060')))) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:02:22 Duration: 2s511ms
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" = '211059')))) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:02:19 Duration: 2s432ms
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" = '9947347')))) ORDER BY "collection_policy"."id";

Date: 2025-02-04 14:00:18 Duration: 742ms

11

93ms

953ms

250ms

59,664

Details

4h9m12s

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	2,838	9m59s	211ms
	01	1,728	6m22s	221ms
	02	3,016	11m19s	225ms
	03	2,652	9m6s	206ms
	04	2,180	8m7s	223ms
	05	8	2s680ms	335ms
	06	1,438	5m10s	215ms
	07	82	15s826ms	193ms
	08	48	9s8ms	187ms
	09	408	1m27s	214ms
	10	152	35s769ms	235ms
	11	30	9s996ms	333ms
	12	420	1m51s	265ms
	13	852	3m33s	250ms
	14	1,270	5m20s	252ms
	15	2,021	9m24s	279ms
	16	3,441	15m16s	266ms
	17	4,130	17m48s	258ms
	18	7,252	35m47s	296ms
	19	8,619	39m52s	277ms
	20	5,902	22m28s	228ms
	21	6,187	24m38s	238ms
	22	4,990	20m22s	245ms

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

Date: 2025-02-04 17:46:31 Duration: 953ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ياسر')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-04 17:46:31 Duration: 952ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-04 19:56:56 Duration: 900ms

12

140ms

1s529ms

204ms

146,370

Details

8h18m6s

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	1,459	3m48s	156ms
	01	2,696	6m58s	155ms
	02	2,761	7m13s	156ms
	03	2,377	6m11s	156ms
	04	2,691	7m	156ms
	05	1,609	4m8s	154ms
	06	2,664	6m55s	155ms
	07	1,286	3m19s	155ms
	08	4,899	13m	159ms
	09	8,747	25m17s	173ms
	10	12,290	37m2s	180ms
	11	12,773	41m33s	195ms
	12	5,416	16m33s	183ms
	13	7,499	22m19s	178ms
	14	6,919	20m14s	175ms
	15	9,219	27m6s	176ms
	16	11,754	34m26s	175ms
	17	21,308	1h22m6s	231ms
	18	24,913	2h1m14s	291ms
	19	1,449	6m5s	251ms
	20	1,115	3m44s	201ms
	21	206	41s287ms	200ms
	22	320	1m3s	199ms

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

Date: 2025-02-04 18:09:27 Duration: 1s529ms
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" = '291649')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 18:05:17 Duration: 1s520ms
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" = '230012')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:19:44 Duration: 1s506ms

13

144ms

1s85ms

184ms

5,320

Details

16m20s

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

Day	Hour	Count	Duration	Avg duration
Feb 04	01	38	5s963ms	156ms
	04	15	2s708ms	180ms
	06	665	1m43s	156ms
	07	59	9s326ms	158ms
	09	112	18s804ms	167ms
	10	683	2m5s	184ms
	11	3,748	11m53s	190ms

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" = '9726102')) 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)))) 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))))) 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))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:28:08 Duration: 1s85ms
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" = '283959')) 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)))) 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))))) 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))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:18:26 Duration: 1s64ms
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" = '115943')) 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)))) 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))))) 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))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:18:35 Duration: 504ms

14

141ms

1s180ms

176ms

15,691

Details

46m7s

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	163	25s587ms	156ms
	02	20	3s127ms	156ms
	04	13	2s396ms	184ms
	06	1,179	3m4s	156ms
	07	1,226	3m10s	155ms
	08	1,529	4m	157ms
	09	1,877	5m22s	171ms
	10	2,739	8m15s	180ms
	11	1,317	4m17s	195ms
	12	990	3m1s	183ms
	13	899	2m34s	172ms
	14	803	2m16s	169ms
	15	1,049	2m59s	171ms
	16	386	1m6s	173ms
	17	262	54s483ms	207ms
	18	139	36s463ms	262ms
	19	343	1m23s	243ms
	20	313	1m3s	203ms
	21	206	41s420ms	201ms
	22	238	47s478ms	199ms

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

Date: 2025-02-04 11:19:38 Duration: 1s180ms
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" = '262101')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-04 11:19:25 Duration: 486ms
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" = '125551')) 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, 115)))) 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: 2025-02-04 18:48:18 Duration: 386ms

15

121ms

1s178ms

158ms

6,009

Details

15m55s

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 04	00	30	3s945ms	131ms
	02	41	5s483ms	133ms
	08	142	19s100ms	134ms
	09	493	1m14s	150ms
	10	808	2m3s	153ms
	11	1,236	3m48s	184ms
	12	1,176	3m5s	157ms
	13	678	1m38s	144ms
	14	347	50s932ms	146ms
	15	296	46s182ms	156ms
	16	214	31s51ms	145ms
	17	147	23s856ms	162ms
	18	78	17s698ms	226ms
	19	77	13s7ms	168ms
	20	81	11s337ms	139ms
	21	67	9s178ms	136ms
	22	98	13s31ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 19)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-04 11:19:10 Duration: 1s178ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-04 11:18:35 Duration: 1s156ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 70)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-04 11:28:04 Duration: 1s118ms

16

142ms

213ms

156ms

13,176

Details

34m16s

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
Feb 04	00	1,296	3m22s	156ms
	01	2,586	6m41s	155ms
	02	2,729	7m8s	156ms
	03	1,939	5m2s	155ms
	04	2,664	6m55s	155ms
	05	1,443	3m42s	154ms
	06	437	1m7s	154ms
	22	82	16s422ms	200ms

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

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

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

Date: 2025-02-04 22:29:11 Duration: 211ms

17

96ms

845ms

128ms

19,723

Details

42m6s

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
Feb 04	05	73	8s692ms	119ms
	06	12	1s415ms	117ms
	08	270	31s809ms	117ms
	09	1,260	2m42s	129ms
	10	1,126	2m27s	130ms
	11	2,917	6m25s	132ms
	12	2,061	4m33s	132ms
	13	2,948	6m1s	122ms
	14	1,668	3m25s	123ms
	15	2,334	5m3s	130ms
	16	1,442	2m53s	120ms
	17	988	2m3s	124ms
	18	871	2m4s	142ms
	19	871	2m3s	141ms
	20	423	49s609ms	117ms
	21	427	48s18ms	112ms
	22	32	3s680ms	115ms

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

Date: 2025-02-04 19:17:04 Duration: 845ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8085311)) AND (("cash_track"."id" not in (7689032)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-04 11:19:40 Duration: 844ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8088382)) AND (("cash_track"."id" not in (7711736)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-04 18:09:49 Duration: 681ms

18

46ms

350ms

62ms

53,765

Details

56m14s

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

Day	Hour	Count	Duration	Avg duration
Feb 04	00	14	814ms	58ms
	06	127	7s42ms	55ms
	08	2,413	2m18s	57ms
	09	3,862	4m1s	62ms
	10	7,468	7m38s	61ms
	11	6,583	7m34s	69ms
	12	5,332	5m40s	63ms
	13	4,939	5m3s	61ms
	14	6,768	6m54s	61ms
	15	6,632	6m51s	61ms
	16	5,403	5m21s	59ms
	17	3,798	4m6s	64ms
	18	308	26s926ms	87ms
	19	52	4s298ms	82ms
	20	21	1s314ms	62ms
	21	21	1s272ms	60ms
	22	24	1s389ms	57ms

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

Date: 2025-02-04 11:18:47 Duration: 350ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5002562) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:18:38 Duration: 342ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4884509) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-04 18:10:06 Duration: 338ms

19

42ms

287ms

57ms

24,276

Details

23m5s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 04	08	1,259	1m5s	52ms
	09	2,495	2m17s	54ms
	10	3,214	3m2s	56ms
	11	2,498	2m36s	62ms
	12	2,344	2m17s	58ms
	13	2,574	2m24s	56ms
	14	2,490	2m20s	56ms
	15	3,129	2m55s	55ms
	16	1,993	1m48s	54ms
	17	2,251	2m14s	59ms
	18	29	2s153ms	74ms

SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4952045) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:18:39 Duration: 287ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4947301) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:18:39 Duration: 266ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4913510) ORDER BY "collection_policy"."id";

Date: 2025-02-04 11:17:07 Duration: 262ms

20

37ms

344ms

51ms

155,038

Details

2h11m47s

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
Feb 04	00	3,305	2m29s	45ms
	01	2,398	1m47s	45ms
	02	4,442	3m21s	45ms
	03	2,759	2m5s	45ms
	04	2,553	1m56s	45ms
	05	887	39s497ms	44ms
	06	2,366	1m46s	45ms
	07	868	39s406ms	45ms
	08	3,776	2m54s	46ms
	09	10,262	8m37s	50ms
	10	11,739	9m58s	50ms
	11	16,352	15m21s	56ms
	12	15,626	13m36s	52ms
	13	9,878	8m6s	49ms
	14	10,284	8m40s	50ms
	15	9,511	8m5s	51ms
	16	8,303	6m45s	48ms
	17	6,954	5m53s	50ms
	18	6,418	6m30s	60ms
	19	10,220	9m47s	57ms
	20	8,062	6m25s	47ms
	21	5,415	4m13s	46ms
	22	2,660	2m2s	46ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5020530, 5001550)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 18:08:22 Duration: 344ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5041299, 5027363)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 18:05:54 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4999986, 4975441)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-04 11:18:39 Duration: 308ms

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Log levels

Key values

18,438,775 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	14	0.00%
DETAIL	35	0.00%
ERROR	4,063	0.02%
EVENTLOG	785	0.00%
FATAL	791	0.00%
HINT	8	0.00%
LOG	18,428,979	99.95%
STATEMENT	4,100	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
791 FATAL entries
4063 ERROR entries
0 WARNING entries
785 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,175 Max number of times the same event was reported
5,639 Total events found

Rank

Times reported

Error

1

2,175

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 04	00	5
	01	12
	02	6
	03	27
	04	14
	05	4
	06	4
	07	8
	08	104
	09	61
	10	311
	11	288
	12	141
	13	124
	14	99
	15	193
	16	187
	17	190
	18	128
	19	177
	20	51
	21	21
	22	20

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

2

1,854

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 04	00	2
	01	8
	02	3
	03	20
	04	12
	05	3
	06	4
	07	8
	08	93
	09	50
	10	263
	11	242
	12	130
	13	120
	14	89
	15	186
	16	160
	17	156
	18	93
	19	131
	20	41
	21	20
	22	20

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

3

484

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 04	01	1
	04	1
	08	30
	10	51
	11	107
	12	48
	13	18
	14	26
	15	73
	17	27
	18	51
	19	27
	20	24

LOG: could not send data to client: Broken pipe

4

484

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 04	01	1
	04	1
	08	30
	10	51
	11	107
	12	48
	13	18
	14	26
	15	73
	17	27
	18	51
	19	27
	20	24

5

210

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 04	01	1
	04	1
	08	24
	09	9
	10	17
	11	63
	12	16
	13	14
	14	6
	15	26
	17	5
	18	15
	19	5
	20	8

6

200

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 04	17	200

7

90

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 04	08	1
	10	6
	11	30
	12	9
	13	8
	14	4
	15	14
	17	3
	18	6
	19	4
	20	5

8

76

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 04	17	76

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

9

14

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Feb 04	09	1
	10	2
	11	3
	12	1
	13	1
	15	1
	22	5

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

10

12

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Feb 04	00	3
	04	3
	07	3
	13	3

FATAL: password authentication failed for user "postgres"

11

8

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Feb 04	17	8

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

12

8

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Feb 04	10	4
	11	2
	14	1
	17	1

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

13

7

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Feb 04	00	3
	03	1
	08	2
	15	1

ERROR: syntax error at or near ")" at character 162
ERROR: syntax error at or near ")" at character 372
ERROR: syntax error at or near ")" at character 162

14

3

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Feb 04	11	1
	12	1
	20	1

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

15

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Feb 04	09	1
	14	1
	20	1

16

2

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Feb 04	17	2

17

2

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Feb 04	09	1
	20	1

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Feb 04	09	1
	20	1

19

1

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Feb 04	06	1

20

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Feb 04	17	1

21

1

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Feb 04	16	1

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Feb 04	22	1

ERROR: duplicate key value violates unique constraint "res_currency_unique_name"

23

1

Details

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

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Feb 04	17	1

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

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