pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Jan 22 23:47:36 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 44,523,575 log entries in 2m34s
Log start from 2025-01-22 00:00:00 to 2025-01-22 22:45:02

Global Stats

19,969 Number of unique normalized queries
19,052,899 Number of queries
7d16h36m10s Total query duration
2025-01-22 00:00:00 First query
2025-01-22 22:45:02 Last query
6,285 queries/s at 2025-01-22 10:21:13 Query peak

7d16h36m10s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
7d16h36m10s Execute total duration

6,681 Number of events
23 Number of unique normalized events
2,441 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
19,052,899 Average queries per session
7d16h36m10s 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

6,285 queries/s Query Peak
2025-01-22 10:21:13 Date

SELECT Traffic

Key values

3,973 queries/s Query Peak
2025-01-22 10:21:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,575 queries/s Query Peak
2025-01-22 10:21:13 Date

Queries duration

Key values

7d16h36m10s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 22	00	287,286	0ms	3s34ms	22ms	3m9s	3m27s	5m40s
	01	344,998	0ms	3s399ms	22ms	3m30s	4m21s	4m30s
	02	255,656	0ms	4s65ms	25ms	3m40s	3m42s	4m2s
	03	276,100	0ms	1m6s	29ms	4m30s	4m55s	5m54s
	04	185,154	0ms	54m56s	43ms	2m37s	2m55s	55m44s
	05	184,562	0ms	719ms	26ms	2m19s	2m34s	2m43s
	06	163,705	0ms	5s695ms	21ms	2m12s	2m21s	2m50s
	07	172,471	0ms	1m55s	15ms	1m35s	1m51s	3m4s
	08	434,327	0ms	7s533ms	13ms	3m28s	3m36s	4m45s
	09	1,167,919	0ms	51m6s	50ms	7m2s	7m49s	12h2m27s
	10	1,483,781	0ms	26m45s	24ms	8m40s	13m49s	3h25m33s
	11	1,743,091	0ms	14m57s	36ms	53m48s	2h17m50s	3h51m14s
	12	1,795,968	0ms	26m8s	29ms	8m44s	2h18m2s	4h10m47s
	13	1,642,401	0ms	12m56s	16ms	7m28s	9m9s	2h6m20s
	14	1,448,438	0ms	48m54s	49ms	14m6s	20m17s	12h20m4s
	15	1,531,613	0ms	31m1s	39ms	21m5s	1h11s	3h5m28s
	16	1,343,802	0ms	49m44s	55ms	10m24s	15m58s	11h14m4s
	17	1,052,509	0ms	24m42s	29ms	6m47s	7m19s	5h36m57s
	18	1,089,706	0ms	10m32s	20ms	6m51s	7m40s	1h38m47s
	19	894,112	0ms	45m44s	54ms	7m13s	8m13s	9h8m43s
	20	733,273	0ms	38m8s	63ms	7m31s	9m10s	7h59m3s
	21	518,947	0ms	1m16s	20ms	4m54s	6m32s	7m27s
	22	303,080	0ms	13s86ms	14ms	2m51s	3m20s	4m16s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 22	00	156,712	40ms	2m20s	3m8s	3m34s
	01	189,293	41ms	3m14s	3m29s	4m29s
	02	136,493	47ms	2m56s	3m40s	3m49s
	03	143,197	55ms	3m14s	4m29s	5m6s
	04	94,017	50ms	2m13s	2m35s	2m54s
	05	95,378	50ms	1m57s	2m19s	2m34s
	06	87,613	40ms	1m46s	2m11s	2m28s
	07	93,553	27ms	1m12s	1m33s	1m51s
	08	253,670	23ms	2m36s	3m28s	3m50s
	09	699,174	22ms	5m29s	6m48s	7m48s
	10	874,553	22ms	7m35s	8m20s	10m50s
	11	1,080,600	17ms	7m9s	9m34s	10m37s
	12	1,100,505	17ms	7m11s	7m55s	8m43s
	13	988,912	15ms	5m36s	6m34s	9m3s
	14	858,334	31ms	11m12s	13m24s	19m22s
	15	944,858	38ms	12m53s	14m38s	15m40s
	16	787,332	32ms	8m55s	10m11s	13m11s
	17	632,869	16ms	3m53s	6m1s	7m18s
	18	662,541	24ms	5m34s	6m42s	7m38s
	19	546,871	28ms	5m37s	6m43s	7m39s
	20	446,263	39ms	6m30s	7m18s	8m58s
	21	308,490	34ms	4m21s	4m54s	6m31s
	22	183,799	23ms	2m28s	2m50s	4m16s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 22	00	24,641	6,025	210	0	0ms	138ms	184ms	226ms
	01	31,226	6,836	166	0	0ms	161ms	230ms	292ms
	02	22,619	6,027	131	0	0ms	138ms	186ms	248ms
	03	27,029	6,670	135	0	2ms	156ms	229ms	396ms
	04	15,453	4,154	134	0	167ms	102ms	145ms	197ms
	05	15,312	5,781	187	0	0ms	91ms	126ms	162ms
	06	11,344	3,525	194	0	0ms	72ms	102ms	158ms
	07	8,461	2,628	144	0	11ms	54ms	82ms	184ms
	08	17,487	6,478	257	0	0ms	96ms	144ms	214ms
	09	54,475	17,012	820	0	599ms	334ms	372ms	555ms
	10	74,980	21,231	843	0	178ms	495ms	602ms	1s19ms
	11	69,522	21,132	621	0	481ms	474ms	770ms	2h14m3s
	12	78,690	24,794	909	0	334ms	509ms	693ms	2h15m40s
	13	64,777	22,116	708	0	139ms	401ms	476ms	903ms
	14	69,656	33,252	519	6	441ms	649ms	53s662ms	2m48s
	15	76,426	26,915	677	0	224ms	761ms	1m22s	57m16s
	16	73,934	21,492	717	0	510ms	476ms	764ms	3m7s
	17	44,636	13,792	515	0	343ms	341ms	498ms	23s536ms
	18	67,929	19,292	730	1	65ms	415ms	523ms	803ms
	19	57,112	15,300	633	0	450ms	363ms	474ms	32s697ms
	20	69,662	15,666	399	0	336ms	450ms	523ms	1m29s
	21	49,429	10,570	344	0	2ms	290ms	361ms	9s827ms
	22	17,340	4,788	313	1	0ms	143ms	179ms	255ms

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

Day	Hour	Average / Second
Jan 22	00	0.00/s
	01	0.00/s
	02	0.00/s
	03	0.00/s
	04	0.00/s
	05	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	09	0.00/s
	10	0.00/s
	11	0.00/s
	12	0.00/s
	13	0.00/s
	14	0.00/s
	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s
	22	0.00/s

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

396,391 buffers Checkpoint Peak
2025-01-22 20:21:22 Date
270.054 seconds Highest write time
0.060 seconds Sync time

Checkpoints Wal files

Key values

184 files Wal files usage Peak
2025-01-22 20:21:22 Date

Checkpoints distance

Key values

5,903.45 Mo Distance Peak
2025-01-22 20:21:22 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 22	00	130,193	3,239.543s	0.044s	3,239.636s
	01	184,237	3,239.479s	0.037s	3,239.569s
	02	142,078	3,239.625s	0.036s	3,239.714s
	03	141,070	3,239.536s	0.038s	3,239.628s
	04	105,333	3,239.535s	0.036s	3,239.618s
	05	94,197	3,239.554s	0.032s	3,239.635s
	06	90,122	2,962.437s	0.03s	2,962.509s
	07	52,706	2,556.29s	0.026s	2,556.347s
	08	107,640	3,239.52s	0.037s	3,239.614s
	09	387,704	3,239.408s	0.108s	3,239.601s
	10	444,527	3,239.582s	0.045s	3,239.716s
	11	462,686	3,239.455s	0.054s	3,239.593s
	12	495,871	3,239.472s	0.048s	3,239.614s
	13	465,460	3,239.596s	0.061s	3,239.735s
	14	429,184	3,239.458s	0.055s	3,239.61s
	15	572,249	3,239.493s	0.066s	3,239.667s
	16	428,740	3,239.515s	0.052s	3,239.633s
	17	301,228	2,887.948s	0.069s	2,888.081s
	18	283,692	3,239.52s	0.047s	3,239.621s
	19	325,627	3,239.506s	0.054s	3,239.624s
	20	598,388	3,239.563s	0.05s	3,239.708s
	21	196,408	3,239.528s	0.042s	3,239.677s
	22	124,358	2,429.617s	0.034s	2,429.679s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 22	00	0	59	3,556	0.012s	0.012s
	01	0	80	3,799	0.002s	0.012s
	02	0	64	3,420	0.002s	0.012s
	03	0	66	2,885	0.004s	0.012s
	04	0	49	2,567	0.003s	0.012s
	05	0	42	2,763	0.002s	0.012s
	06	0	39	2,398	0.002s	0.012s
	07	0	23	2,211	0.002s	0.012s
	08	0	45	3,244	0.010s	0.012s
	09	0	167	5,077	0.027s	0.012s
	10	0	203	5,329	0.002s	0.012s
	11	0	212	5,341	0.004s	0.012s
	12	0	228	5,417	0.002s	0.012s
	13	0	213	5,375	0.002s	0.012s
	14	0	192	5,546	0.003s	0.012s
	15	0	236	5,654	0.003s	0.012s
	16	0	151	5,670	0.002s	0.012s
	17	0	110	5,442	0.015s	0.012s
	18	0	103	5,482	0.002s	0.012s
	19	0	107	5,469	0.004s	0.012s
	20	8	257	5,153	0.002s	0.012s
	21	64	14	4,780	0.002s	0.012s
	22	0	49	3,617	0.003s	0.009s

Day	Hour	Avg time (sec)
Jan 22	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s

Day	Hour	Mean distance	Mean estimate
Jan 22	00	80,742.42 kB	114,401.42 kB
	01	102,644.73 kB	137,116.36 kB
	02	88,049.00 kB	140,288.50 kB
	03	90,497.08 kB	117,351.33 kB
	04	66,353.08 kB	110,117.83 kB
	05	57,511.50 kB	88,127.92 kB
	06	53,550.50 kB	94,418.50 kB
	07	30,569.17 kB	71,625.83 kB
	08	62,046.75 kB	86,155.17 kB
	09	227,667.00 kB	245,748.18 kB
	10	274,841.73 kB	371,921.64 kB
	11	289,284.08 kB	335,795.92 kB
	12	313,358.18 kB	348,276.82 kB
	13	291,157.64 kB	376,924.27 kB
	14	261,562.17 kB	376,435.50 kB
	15	333,814.82 kB	823,596.45 kB
	16	207,398.00 kB	587,718.82 kB
	17	150,993.33 kB	245,821.83 kB
	18	139,883.17 kB	179,975.83 kB
	19	146,025.42 kB	198,753.50 kB
	20	362,510.08 kB	1,511,173.42 kB
	21	105,872.50 kB	863,878.83 kB
	22	89,977.22 kB	341,605.11 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
Jan 22	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

unknown (0) Main table analyzed (database )
0 analyzes Total

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

unknown (0) Main table vacuumed on database
0 vacuums Total

Chart
Table

Vacuums per tables

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
NO DATASET

Tuples removed per table

Key values

unknown (0) Main table with removed tuples on database
0 tuples Total removed

Chart
Table

Tuples removed per tables

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
NO DATASET

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
NO DATASET

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 22	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

11,365,027 Total read queries
5,252,984 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,365,027	59.65%
INSERT	1,042,140	5.47%
UPDATE	315,476	1.66%
DELETE	10,306	0.05%
COPY FROM	8	0.00%
COPY TO	0	0.00%
CTE	28,509	0.15%
DDL	1,865	0.01%
TCL	3,854,680	20.23%
CURSOR	0	0.00%
OTHERS	2,434,888	12.78%

Queries by database

Key values

unknown Main database
19,052,899 Requests
7d16h36m10s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	19,052,899	7d16h36m10s
	copy from	8	19ms
	cte	28,509	6s531ms
	ddl	1,865	264ms
	delete	10,306	2m16s
	insert	1,042,140	5m37s
	others	2,434,888	1m58s
	select	11,365,027	3d12h7m52s
	tcl	3,854,680	2m42s
	update	315,476	4d4h15m37s

Queries by user

Key values

unknown Main user
19,052,899 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	19,052,899	7d16h36m10s
	copy from	8	19ms
	cte	28,509	6s531ms
	ddl	1,865	264ms
	delete	10,306	2m16s
	insert	1,042,140	5m37s
	others	2,434,888	1m58s
	select	11,365,027	3d12h7m52s
	tcl	3,854,680	2m42s
	update	315,476	4d4h15m37s

Duration by user

Key values

7d16h36m10s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	19,052,899	7d16h36m10s
	copy from	8	19ms
	cte	28,509	6s531ms
	ddl	1,865	264ms
	delete	10,306	2m16s
	insert	1,042,140	5m37s
	others	2,434,888	1m58s
	select	11,365,027	3d12h7m52s
	tcl	3,854,680	2m42s
	update	315,476	4d4h15m37s

Queries by host

Key values

unknown Main host
19,052,899 Requests
7d16h36m10s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	19,052,899	7d16h36m10s
	copy from	8	19ms
	cte	28,509	6s531ms
	ddl	1,865	264ms
	delete	10,306	2m16s
	insert	1,042,140	5m37s
	others	2,434,888	1m58s
	select	11,365,027	3d12h7m52s
	tcl	3,854,680	2m42s
	update	315,476	4d4h15m37s

Queries by application

Key values

unknown Main application
19,052,899 Requests
7d16h36m10s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	19,052,899	7d16h36m10s
	copy from	8	19ms
	cte	28,509	6s531ms
	ddl	1,865	264ms
	delete	10,306	2m16s
	insert	1,042,140	5m37s
	others	2,434,888	1m58s
	select	11,365,027	3d12h7m52s
	tcl	3,854,680	2m42s
	update	315,476	4d4h15m37s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-22 07:08:39 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,744,627 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,744,627	93.13%
1-5ms	328,379	1.72%
5-10ms	18,641	0.10%
10-25ms	55,267	0.29%
25-50ms	42,006	0.22%
50-100ms	208,836	1.10%
100-500ms	324,850	1.70%
500-1000ms	326,117	1.71%
1000-10000ms	3,498	0.02%
> 10000ms	678	0.00%

Slowest individual queries

Rank	Duration	Query
1	54m56s	UPDATE "res_users" SET "exp_date" = '2025-01-22 03:08:02.210960', "last_update" = '2025-01-22 02:23:02.210979', "sid" = '431a094766f3919e1a2f0caa91be4e24c47e7ae2', "write_date" = '2025-01-22 02:23:01.881444', "write_uid" = 1 WHERE id IN (1244); [ Date: 2025-01-22 04:17:58 ]
2	51m6s	update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:39:14.807479', exp_date = '2025-01-22 08:24:14.807481', logged_in = 'TRUE' where id = 977; [ Date: 2025-01-22 09:30:21 ]
3	51m6s	update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:39:14.807416', exp_date = '2025-01-22 08:24:14.807421', logged_in = 'TRUE' where id = 977; [ Date: 2025-01-22 09:30:21 ]
4	50m34s	update res_users set sid = 'faddbe0c45ccd264febe79dc78ce270ca9f72374', last_update = '2025-01-22 07:39:46.136393', exp_date = '2025-01-22 08:24:46.136395', logged_in = 'TRUE' where id = 977; [ Date: 2025-01-22 09:30:21 ]
5	50m13s	update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:40:07.277591', exp_date = '2025-01-22 08:25:07.277594', logged_in = 'TRUE' where id = 977; [ Date: 2025-01-22 09:30:21 ]
6	49m44s	update res_users set sid = '48aaf453393c928ab8257f8ff3a5ee770731854d', last_update = '2025-01-22 14:57:36.658501', exp_date = '2025-01-22 15:42:36.658508', logged_in = 'TRUE' where id = 1319; [ Date: 2025-01-22 16:47:21 ]
7	49m44s	update res_users set sid = '48aaf453393c928ab8257f8ff3a5ee770731854d', last_update = '2025-01-22 14:57:36.658501', exp_date = '2025-01-22 15:42:36.658507', logged_in = 'TRUE' where id = 1319; [ Date: 2025-01-22 16:47:21 ]
8	49m37s	update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:40:43.727123', exp_date = '2025-01-22 08:25:43.727126', logged_in = 'TRUE' where id = 977; [ Date: 2025-01-22 09:30:21 ]
9	48m54s	update res_users set sid = '51517e5599b11a14d4399ef525bda44661d0c9bd', last_update = '2025-01-22 12:13:26.600427', exp_date = '2025-01-22 12:58:26.600430', logged_in = 'TRUE' where id = 1296; [ Date: 2025-01-22 14:02:21 ]
10	48m54s	update res_users set sid = '51517e5599b11a14d4399ef525bda44661d0c9bd', last_update = '2025-01-22 12:13:26.599327', exp_date = '2025-01-22 12:58:26.599330', logged_in = 'TRUE' where id = 1296; [ Date: 2025-01-22 14:02:21 ]
11	48m49s	update res_users set sid = '48aaf453393c928ab8257f8ff3a5ee770731854d', last_update = '2025-01-22 14:58:31.933489', exp_date = '2025-01-22 15:43:31.933494', logged_in = 'TRUE' where id = 1319; [ Date: 2025-01-22 16:47:21 ]
12	48m41s	update res_users set sid = '48aaf453393c928ab8257f8ff3a5ee770731854d', last_update = '2025-01-22 14:58:40.181097', exp_date = '2025-01-22 15:43:40.181103', logged_in = 'TRUE' where id = 1319; [ Date: 2025-01-22 16:47:21 ]
13	48m39s	update res_users set sid = '48aaf453393c928ab8257f8ff3a5ee770731854d', last_update = '2025-01-22 14:58:41.567645', exp_date = '2025-01-22 15:43:41.567648', logged_in = 'TRUE' where id = 1319; [ Date: 2025-01-22 16:47:21 ]
14	48m39s	update res_users set sid = '48aaf453393c928ab8257f8ff3a5ee770731854d', last_update = '2025-01-22 14:58:41.570830', exp_date = '2025-01-22 15:43:41.570832', logged_in = 'TRUE' where id = 1319; [ Date: 2025-01-22 16:47:21 ]
15	48m39s	update res_users set sid = '48aaf453393c928ab8257f8ff3a5ee770731854d', last_update = '2025-01-22 14:58:42.010149', exp_date = '2025-01-22 15:43:42.010154', logged_in = 'TRUE' where id = 1319; [ Date: 2025-01-22 16:47:21 ]
16	47m37s	update res_users set sid = '51517e5599b11a14d4399ef525bda44661d0c9bd', last_update = '2025-01-22 12:14:43.858365', exp_date = '2025-01-22 12:59:43.858367', logged_in = 'TRUE' where id = 1296; [ Date: 2025-01-22 14:02:21 ]
17	47m32s	update res_users set sid = '51517e5599b11a14d4399ef525bda44661d0c9bd', last_update = '2025-01-22 12:14:48.423735', exp_date = '2025-01-22 12:59:48.423741', logged_in = 'TRUE' where id = 1296; [ Date: 2025-01-22 14:02:21 ]
18	46m7s	update res_users set sid = '51517e5599b11a14d4399ef525bda44661d0c9bd', last_update = '2025-01-22 12:16:13.465400', exp_date = '2025-01-22 13:01:13.465403', logged_in = 'TRUE' where id = 1296; [ Date: 2025-01-22 14:02:21 ]
19	45m44s	UPDATE "res_users" SET "exp_date" = '2025-01-22 18:20:36.590831', "last_update" = '2025-01-22 17:35:36.590858', "write_date" = '2025-01-22 17:35:36.148043', "write_uid" = 974 WHERE id IN (974); [ Date: 2025-01-22 19:21:20 ]
20	45m4s	update res_users set sid = '51517e5599b11a14d4399ef525bda44661d0c9bd', last_update = '2025-01-22 12:17:16.801715', exp_date = '2025-01-22 13:02:16.801723', logged_in = 'TRUE' where id = 1296; [ Date: 2025-01-22 14:02:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d15h19m26s

67,999

Details

0ms

51m6s

4s623ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 22	00	988	214ms	0ms
	01	1,213	261ms	0ms
	02	1,048	225ms	0ms
	03	1,320	1m6s	50ms
	04	739	165ms	0ms
	05	734	154ms	0ms
	06	581	122ms	0ms
	07	459	1m55s	251ms
	08	1,541	325ms	0ms
	09	4,396	8h56m21s	7s320ms
	10	5,846	3h22m27s	2s77ms
	11	7,087	12h11m37s	6s194ms
	12	6,978	8h6m20s	4s181ms
	13	6,097	3h23m22s	2s1ms
	14	5,241	10h33m59s	7s257ms
	15	5,174	6h26m37s	4s483ms
	16	4,806	11h9s	8s241ms
	17	3,659	5h36m33s	5s518ms
	18	3,359	1h35m51s	1s712ms
	19	2,571	8h4m40s	11s310ms
	20	1,892	7h58m8s	15s162ms
	21	1,415	325ms	0ms
	22	855	13s266ms	15ms

update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:39:14.807479', exp_date = '2025-01-22 08:24:14.807481', logged_in = 'TRUE' where id = 977;

Date: 2025-01-22 09:30:21 Duration: 51m6s
update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:39:14.807416', exp_date = '2025-01-22 08:24:14.807421', logged_in = 'TRUE' where id = 977;

Date: 2025-01-22 09:30:21 Duration: 51m6s
update res_users set sid = 'faddbe0c45ccd264febe79dc78ce270ca9f72374', last_update = '2025-01-22 07:39:46.136393', exp_date = '2025-01-22 08:24:46.136395', logged_in = 'TRUE' where id = 977;

Date: 2025-01-22 09:30:21 Duration: 50m34s

2

1d22h58m43s

269,801

Details

493ms

5s288ms

626ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 22	00	7,208	1h7m3s	558ms
	01	9,306	1h26m35s	558ms
	02	7,842	1h12m49s	557ms
	03	10,449	1h37m36s	560ms
	04	5,833	53m22s	549ms
	05	4,907	45m20s	554ms
	06	4,273	38m36s	542ms
	07	2,794	25m17s	542ms
	08	5,959	53m59s	543ms
	09	13,622	2h15m	594ms
	10	18,171	3h11m48s	633ms
	11	16,298	2h52m26s	634ms
	12	16,443	2h50m18s	621ms
	13	11,814	1h57m19s	595ms
	14	14,878	2h51m10s	690ms
	15	29,420	6h1m58s	738ms
	16	24,412	4h30m40s	665ms
	17	9,616	1h37m13s	606ms
	18	13,355	2h21m32s	635ms
	19	14,446	2h31m23s	628ms
	20	15,470	2h44m25s	637ms
	21	9,695	1h37m24s	602ms
	22	3,590	35m19s	590ms

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

Date: 2025-01-22 15:53:19 Duration: 5s288ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4685050)) AND (("shipping_track"."id" not in (38771477, 38771477)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:28:32 Duration: 5s59ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4685019)) AND (("shipping_track"."id" not in (38771218, 38771218)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:27:16 Duration: 4s716ms

3

10h38m55s

298

Details

0ms

54m56s

2m8s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 22	00	2	0ms	0ms
	01	4	0ms	0ms
	02	1	0ms	0ms
	03	2	0ms	0ms
	04	2	54m56s	27m28s
	05	5	3ms	0ms
	06	5	2ms	0ms
	07	3	0ms	0ms
	08	10	2ms	0ms
	09	36	3h5m42s	5m9s
	10	30	1h26m11s	2m52s
	11	24	42ms	1ms
	12	42	1h2m47s	1m29s
	13	24	26ms	1ms
	14	23	1h56m50s	5m4s
	15	16	39ms	2ms
	16	16	1h57m10s	7m19s
	17	10	14ms	1ms
	18	12	14ms	1ms
	19	15	15m17s	1m1s
	20	5	4ms	0ms
	21	7	2ms	0ms
	22	4	3ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-22 03:08:02.210960', "last_update" = '2025-01-22 02:23:02.210979', "sid" = '431a094766f3919e1a2f0caa91be4e24c47e7ae2', "write_date" = '2025-01-22 02:23:01.881444', "write_uid" = 1 WHERE id IN (1244);

Date: 2025-01-22 04:17:58 Duration: 54m56s
UPDATE "res_users" SET "exp_date" = '2025-01-22 15:49:31.479501', "last_update" = '2025-01-22 15:04:31.479522', "sid" = '9f960da499966874f86d448954e7cc1d51da218e', "write_date" = '2025-01-22 15:04:31.144148', "write_uid" = 1319 WHERE id IN (1319);

Date: 2025-01-22 16:47:21 Duration: 42m49s
UPDATE "res_users" SET "exp_date" = '2025-01-22 15:52:32.243596', "last_update" = '2025-01-22 15:07:32.243622', "sid" = '9f960da499966874f86d448954e7cc1d51da218e', "write_date" = '2025-01-22 15:07:31.805102', "write_uid" = 1319 WHERE id IN (1319);

Date: 2025-01-22 16:47:21 Duration: 39m49s

4

8h28m40s

134,317

Details

154ms

1s598ms

227ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 22	00	1,252	3m56s	188ms
	01	1,665	5m14s	188ms
	02	1,618	5m7s	190ms
	03	2,122	6m45s	191ms
	04	2,097	6m35s	188ms
	05	3,120	9m45s	187ms
	06	2,327	7m14s	186ms
	07	1,465	4m36s	188ms
	08	4,293	13m40s	191ms
	09	8,735	30m8s	207ms
	10	7,131	25m52s	217ms
	11	8,031	29m50s	222ms
	12	7,444	26m29s	213ms
	13	7,125	25m33s	215ms
	14	33,405	2h19m13s	250ms
	15	24,851	1h46m52s	258ms
	16	9,612	36m7s	225ms
	17	502	1m34s	188ms
	18	1,183	3m43s	188ms
	19	4,417	14m14s	193ms
	20	1,389	4m28s	193ms
	21	228	40s440ms	177ms
	22	305	53s745ms	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" = '9599368')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:28:23 Duration: 1s598ms
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" = '9893927')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:29:01 Duration: 1s596ms
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" = '9877746')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:26:58 Duration: 1s538ms

5

8h14m44s

45,999

Details

499ms

4s424ms

645ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 22	00	628	5m54s	564ms
	01	437	4m11s	576ms
	02	227	2m16s	601ms
	03	214	2m17s	643ms
	04	140	1m27s	627ms
	05	308	2m57s	575ms
	06	330	3m4s	560ms
	07	251	2m20s	560ms
	08	751	7m7s	569ms
	09	3,705	37m41s	610ms
	10	3,941	42m36s	648ms
	11	3,885	42m27s	655ms
	12	4,292	45m47s	640ms
	13	4,091	41m53s	614ms
	14	3,650	43m42s	718ms
	15	3,683	47m43s	777ms
	16	3,780	42m20s	672ms
	17	2,433	24m21s	600ms
	18	3,400	35m2s	618ms
	19	2,665	27m36s	621ms
	20	1,378	14m16s	621ms
	21	1,235	12m5s	587ms
	22	575	5m28s	570ms

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

Date: 2025-01-22 14:27:10 Duration: 4s424ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4603686)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:28:46 Duration: 4s356ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4686290, 4686286)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 16:00:29 Duration: 4s333ms

6

3h53m31s

57,639

Details

95ms

881ms

243ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 22	00	2,578	8m49s	205ms
	01	2,858	10m29s	220ms
	02	2,512	10m10s	243ms
	03	2,330	9m15s	238ms
	04	1,192	4m31s	228ms
	05	1,794	6m34s	219ms
	06	512	1m53s	222ms
	07	538	1m55s	215ms
	09	114	19s818ms	173ms
	10	328	1m15s	230ms
	11	324	1m40s	308ms
	12	428	1m58s	277ms
	13	314	1m15s	240ms
	14	735	3m47s	310ms
	15	1,903	9m7s	287ms
	16	3,249	14m30s	267ms
	17	3,194	12m46s	239ms
	18	7,244	30m7s	249ms
	19	5,619	22m54s	244ms
	20	11,471	46m6s	241ms
	21	6,240	25m33s	245ms
	22	2,162	8m27s	234ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'هانى')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-22 15:50:12 Duration: 881ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-22 15:50:12 Duration: 878ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ايمان')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-22 19:01:30 Duration: 841ms

7

2h45m18s

10,835

Details

203ms

1s991ms

915ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 22	00	492	7m17s	888ms
	01	642	9m23s	878ms
	02	159	2m21s	890ms
	03	73	1m5s	893ms
	04	16	14s18ms	876ms
	09	3	3s185ms	1s61ms
	10	19	14s595ms	768ms
	11	59	1m7s	1s144ms
	12	70	1m15s	1s83ms
	13	86	1m23s	973ms
	14	221	4m12s	1s144ms
	15	302	5m56s	1s179ms
	16	478	8m9s	1s23ms
	17	636	9m53s	933ms
	18	1,552	23m3s	891ms
	19	1,080	16m10s	898ms
	20	2,291	35m5s	918ms
	21	1,729	25m5s	870ms
	22	927	13m13s	856ms

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

Date: 2025-01-22 15:52:58 Duration: 1s991ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '80836')) 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 (48))))))) 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 (48)))))) 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 (48)))))) 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 (48))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-22 15:53:21 Duration: 1s888ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9924326')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-22 15:57:45 Duration: 1s793ms

8

2h18m47s

148,524

Details

41ms

372ms

56ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 22	00	3,897	3m15s	50ms
	01	4,342	3m38s	50ms
	02	2,643	2m13s	50ms
	03	3,131	2m39s	50ms
	04	2,001	1m40s	50ms
	05	1,158	58s415ms	50ms
	06	1,346	1m7s	50ms
	07	1,454	1m13s	50ms
	08	3,131	2m39s	50ms
	09	10,506	9m31s	54ms
	10	12,996	12m31s	57ms
	11	14,504	13m56s	57ms
	12	12,107	11m27s	56ms
	13	9,793	8m55s	54ms
	14	9,896	10m1s	60ms
	15	8,438	9m32s	67ms
	16	9,000	9m2s	60ms
	17	6,170	5m29s	53ms
	18	8,632	7m51s	54ms
	19	7,704	7m4s	55ms
	20	7,979	7m13s	54ms
	21	5,853	5m8s	52ms
	22	1,843	1m36s	52ms

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

Date: 2025-01-22 17:21:54 Duration: 372ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4638056, 4613446, 4581152, 4573045, 4527567)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-22 14:26:00 Duration: 364ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4663703, 4632468, 4625641, 4611664, 4530398)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-22 14:26:25 Duration: 340ms

9

2h10m34s

24,676

Details

176ms

2s309ms

317ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 22	07	273	1m12s	264ms
	08	1,539	6m46s	264ms
	09	3,100	16m11s	313ms
	10	1,878	9m41s	309ms
	11	2,984	15m8s	304ms
	12	2,493	12m18s	296ms
	13	2,352	12m12s	311ms
	14	3,971	22m10s	334ms
	15	3,756	21m52s	349ms
	16	2,296	12m47s	334ms
	17	34	12s323ms	362ms

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

Date: 2025-01-22 15:53:00 Duration: 2s309ms
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" = '9972473')))) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:52:52 Duration: 2s94ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9723338')))) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:59:00 Duration: 1s963ms

10

1h56m29s

52

Details

0ms

45m44s

2m14s

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
Jan 22	02	1	0ms	0ms
	03	2	1ms	0ms
	08	3	0ms	0ms
	09	5	4ms	0ms
	10	4	6ms	1ms
	11	3	5ms	1ms
	12	7	32m50s	4m41s
	13	5	3ms	0ms
	14	3	9ms	3ms
	15	2	5ms	2ms
	16	5	37m54s	7m34s
	17	2	2ms	1ms
	19	4	45m44s	11m26s
	20	2	0ms	0ms
	21	1	1ms	1ms
	22	3	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-22 18:20:36.590831', "last_update" = '2025-01-22 17:35:36.590858', "write_date" = '2025-01-22 17:35:36.148043', "write_uid" = 974 WHERE id IN (974);

Date: 2025-01-22 19:21:20 Duration: 45m44s
UPDATE "res_users" SET "exp_date" = '2025-01-22 15:57:35.100759', "last_update" = '2025-01-22 15:12:35.100781', "write_date" = '2025-01-22 15:12:34.769122', "write_uid" = 1 WHERE id IN (992);

Date: 2025-01-22 16:47:21 Duration: 34m46s
UPDATE "res_users" SET "exp_date" = '2025-01-22 11:39:49.627881', "last_update" = '2025-01-22 10:54:49.627905', "write_date" = '2025-01-22 10:54:49.242912', "write_uid" = 867 WHERE id IN (867);

Date: 2025-01-22 12:20:20 Duration: 25m31s

11

1h19m21s

18,342

Details

200ms

1s888ms

259ms

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
Jan 22	00	805	3m23s	252ms
	01	801	3m23s	253ms
	02	1,104	4m42s	255ms
	03	1,106	4m44s	256ms
	04	588	2m29s	254ms
	05	906	3m44s	248ms
	06	262	1m4s	245ms
	07	273	1m6s	244ms
	09	55	14s640ms	266ms
	10	152	44s822ms	294ms
	11	110	32s626ms	296ms
	12	150	43s231ms	288ms
	13	79	22s681ms	287ms
	14	159	57s926ms	364ms
	15	673	3m31s	313ms
	16	1,180	5m50s	296ms
	17	973	4m5s	252ms
	18	2,101	8m48s	251ms
	19	1,777	7m29s	253ms
	20	3,495	14m51s	255ms
	21	1,432	5m50s	244ms
	22	161	39s745ms	246ms

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

Date: 2025-01-22 14:26:46 Duration: 1s888ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '42354')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

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

Date: 2025-01-22 14:27:17 Duration: 844ms

12

51m22s

44,553

Details

45ms

330ms

69ms

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
Jan 22	00	28	1s732ms	61ms
	01	21	1s315ms	62ms
	07	431	26s514ms	61ms
	08	1,848	1m53s	61ms
	09	5,379	5m42s	63ms
	10	3,255	3m49s	70ms
	11	6,331	7m12s	68ms
	12	2,813	3m8s	66ms
	13	3,707	3m57s	64ms
	14	7,312	8m41s	71ms
	15	5,966	7m57s	79ms
	16	5,151	6m4s	70ms
	17	1,920	2m4s	64ms
	18	179	9s938ms	55ms
	19	109	6s150ms	56ms
	20	58	3s427ms	59ms
	21	41	2s150ms	52ms
	22	4	211ms	52ms

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

Date: 2025-01-22 15:22:06 Duration: 330ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4634640) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:59:40 Duration: 319ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2908459) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:22:47 Duration: 302ms

13

43m41s

12,622

Details

156ms

1s431ms

207ms

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
Jan 22	00	295	56s496ms	191ms
	01	107	21s31ms	196ms
	03	269	51s276ms	190ms
	04	6	1s121ms	186ms
	05	480	1m30s	189ms
	06	786	2m27s	187ms
	07	839	2m38s	188ms
	08	1,457	4m33s	187ms
	09	661	2m15s	205ms
	10	1,471	5m15s	214ms
	11	829	3m1s	219ms
	12	976	3m25s	210ms
	13	1,262	4m29s	213ms
	14	1,429	5m38s	236ms
	15	562	2m17s	244ms
	16	393	1m32s	235ms
	17	144	26s32ms	180ms
	18	126	22s700ms	180ms
	19	57	10s96ms	177ms
	20	73	15s993ms	219ms
	21	228	40s498ms	177ms
	22	172	30s625ms	178ms

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" = '24088')) 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-01-22 16:01:40 Duration: 1s431ms
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" = '47297')) 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 (67, 79, 128)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67, 79, 128))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67, 79, 128))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:28:31 Duration: 1s363ms
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" = '9781906')) 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 (39, 115)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 15:58:38 Duration: 1s106ms

14

39m51s

19,212

Details

94ms

729ms

124ms

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
Jan 22	00	67	7s829ms	116ms
	01	13	1s457ms	112ms
	02	55	6s8ms	109ms
	05	42	4s826ms	114ms
	06	39	4s576ms	117ms
	08	174	19s802ms	113ms
	09	1,171	2m20s	120ms
	10	1,508	3m15s	129ms
	11	1,640	3m26s	125ms
	12	3,078	6m26s	125ms
	13	2,607	5m12s	119ms
	14	1,666	3m34s	128ms
	15	1,586	3m53s	147ms
	16	1,536	3m16s	128ms
	17	1,145	2m8s	112ms
	18	1,259	2m24s	115ms
	19	715	1m24s	117ms
	20	296	34s947ms	118ms
	21	429	47s365ms	110ms
	22	186	20s980ms	112ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7965395)) AND (("cash_track"."id" not in (6820805, 6821299, 6821470, 7241408, 7241408)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-22 14:26:31 Duration: 729ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8011707)) AND (("cash_track"."id" not in (7167362, 7176925, 7179113, 7241446, 7241456, 7241456)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-22 14:29:05 Duration: 712ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7757093)) AND (("cash_track"."id" not in (5259821, 5260126, 5260775, 7243100, 7243133, 7243133)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-22 15:13:03 Duration: 628ms

15

30m2s

9,496

Details

156ms

249ms

189ms

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
Jan 22	00	958	3m	188ms
	01	1,557	4m54s	188ms
	02	1,618	5m10s	191ms
	03	1,709	5m30s	193ms
	04	1,377	4m20s	188ms
	05	1,888	5m55s	188ms
	06	327	1m	183ms
	22	62	10s595ms	170ms

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

Date: 2025-01-22 03:41:02 Duration: 249ms
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" = '40351')) 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)))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-22 03:37:43 Duration: 230ms

16

20m16s

19,324

Details

45ms

259ms

62ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 22	07	237	13s503ms	56ms
	08	917	51s648ms	56ms
	09	2,617	2m39s	60ms
	10	1,505	1m37s	64ms
	11	2,514	2m37s	62ms
	12	1,710	1m44s	61ms
	13	1,889	1m53s	60ms
	14	4,145	4m25s	64ms
	15	2,278	2m39s	69ms
	16	1,479	1m32s	62ms
	17	33	1s956ms	59ms

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

Date: 2025-01-22 15:58:27 Duration: 259ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4546159) ORDER BY "collection_policy"."id";

Date: 2025-01-22 14:27:10 Duration: 248ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4604074) ORDER BY "collection_policy"."id";

Date: 2025-01-22 14:26:32 Duration: 227ms

17

16m26s

6,372

Details

119ms

1s174ms

154ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 22	00	59	7s690ms	130ms
	01	15	1s968ms	131ms
	02	1	133ms	133ms
	05	14	1s821ms	130ms
	06	5	653ms	130ms
	08	30	4s82ms	136ms
	09	425	1m2s	146ms
	10	981	2m34s	157ms
	11	1,213	3m8s	155ms
	12	915	2m19s	152ms
	13	659	1m38s	149ms
	14	405	1m11s	175ms
	15	488	1m32s	189ms
	16	188	30s460ms	162ms
	17	133	18s650ms	140ms
	18	127	17s910ms	141ms
	19	77	11s365ms	147ms
	20	72	10s242ms	142ms
	21	44	5s988ms	136ms
	22	521	1m8s	131ms

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

Date: 2025-01-22 14:27:10 Duration: 1s174ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-22 14:28:39 Duration: 1s145ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-22 14:28:47 Duration: 958ms

18

13m8s

267

Details

27ms

4s629ms

2s954ms

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
Jan 22	00	9	26s478ms	2s942ms
	01	9	27s935ms	3s103ms
	02	3	8s758ms	2s919ms
	08	2	6s306ms	3s153ms
	10	3	10s339ms	3s446ms
	11	14	12s764ms	911ms
	12	22	1m3s	2s884ms
	13	35	1m36s	2s742ms
	14	19	54s731ms	2s880ms
	15	23	1m34s	4s121ms
	16	26	1m34s	3s651ms
	17	24	1m2s	2s606ms
	18	19	1m	3s176ms
	19	15	47s289ms	3s152ms
	20	25	1m10s	2s832ms
	21	11	33s651ms	3s59ms
	22	8	17s788ms	2s223ms

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 (79))))))) 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 (79)))))) 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 (79)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))) 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 (79))))))))) 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 (79)))))))) AND ("policy_number"."name"::text ilike '%3315%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-22 15:23:35 Duration: 4s629ms
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 (79))))))) 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 (79)))))) 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 (79)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))) 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 (79))))))))) 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 (79)))))))) AND ("policy_number"."name"::text ilike '%33150%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-22 15:23:35 Duration: 4s609ms
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 (123))))))) 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 (123)))))) 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 (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) 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 (123))))))))) 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 (123)))))))) AND ("policy_number"."name"::text ilike '%84%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-22 15:32:31 Duration: 4s452ms

19

12m19s

2,524

Details

15ms

3s287ms

293ms

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

Day	Hour	Count	Duration	Avg duration
Jan 22	00	6	1s569ms	261ms
	02	3	854ms	284ms
	05	1	130ms	130ms
	06	1	394ms	394ms
	07	1	98ms	98ms
	08	39	6s360ms	163ms
	09	118	23s543ms	199ms
	10	182	48s498ms	266ms
	11	260	1m15s	291ms
	12	339	1m34s	277ms
	13	367	1m34s	256ms
	14	309	1m49s	354ms
	15	244	1m33s	384ms
	16	199	1m6s	335ms
	17	145	37s366ms	257ms
	18	68	21s883ms	321ms
	19	91	30s7ms	329ms
	20	58	18s996ms	327ms
	21	68	12s222ms	179ms
	22	25	3s728ms	149ms

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 (68)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-22 15:09:51 Duration: 3s287ms
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 (113)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (113))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-22 14:28:19 Duration: 3s86ms
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 (127)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-22 14:26:54 Duration: 3s8ms

20

11m47s

3,479

Details

162ms

291ms

203ms

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

Day	Hour	Count	Duration	Avg duration
Jan 22	04	435	1m22s	189ms
	05	519	1m37s	188ms
	06	153	28s685ms	187ms
	07	18	3s446ms	191ms
	09	316	1m8s	216ms
	10	1,285	4m32s	212ms
	11	26	6s317ms	242ms
	12	304	1m8s	226ms
	16	3	663ms	221ms
	18	243	45s500ms	187ms
	19	106	19s697ms	185ms
	22	71	12s660ms	178ms

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" = '9480631')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 12:12:47 Duration: 291ms
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" = '9586844')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 12:13:03 Duration: 290ms
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" = '9574318')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 12:13:02 Duration: 289ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,433,710

Details

1m58s

0ms

3ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 22	00	39,608	1s859ms	0ms
	01	45,251	2s321ms	0ms
	02	35,396	1s798ms	0ms
	03	37,803	1s929ms	0ms
	04	28,123	1s336ms	0ms
	05	26,529	1s312ms	0ms
	06	23,774	1s150ms	0ms
	07	26,312	1s238ms	0ms
	08	59,142	2s979ms	0ms
	09	147,794	7s819ms	0ms
	10	193,279	9s661ms	0ms
	11	216,369	8s966ms	0ms
	12	223,697	10s838ms	0ms
	13	216,119	10s177ms	0ms
	14	190,932	10s368ms	0ms
	15	187,879	9s392ms	0ms
	16	181,174	9s157ms	0ms
	17	140,517	5s907ms	0ms
	18	130,319	6s209ms	0ms
	19	107,448	5s242ms	0ms
	20	79,360	3s935ms	0ms
	21	59,276	2s855ms	0ms
	22	37,609	1s767ms	0ms

DISCARD ALL;

Date: 2025-01-22 15:57:45 Duration: 3ms
DISCARD ALL;

Date: 2025-01-22 14:27:57 Duration: 2ms
DISCARD ALL;

Date: 2025-01-22 22:23:34 Duration: 2ms

2

1,927,778

Details

27s971ms

0ms

17ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 22	00	29,977	447ms	0ms
	01	36,064	546ms	0ms
	02	27,473	427ms	0ms
	03	30,632	469ms	0ms
	04	21,621	334ms	0ms
	05	20,677	326ms	0ms
	06	18,612	292ms	0ms
	07	20,671	311ms	0ms
	08	48,550	707ms	0ms
	09	123,692	1s772ms	0ms
	10	158,574	2s260ms	0ms
	11	175,417	2s265ms	0ms
	12	181,903	2s547ms	0ms
	13	173,519	2s307ms	0ms
	14	146,996	2s377ms	0ms
	15	145,645	2s493ms	0ms
	16	138,790	2s102ms	0ms
	17	109,008	1s368ms	0ms
	18	103,479	1s431ms	0ms
	19	82,254	1s208ms	0ms
	20	60,013	911ms	0ms
	21	44,982	649ms	0ms
	22	29,229	412ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-22 11:20:18 Duration: 17ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-22 12:29:17 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-22 09:26:10 Duration: 1ms

3

1,238,887

Details

12s597ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 22	00	20,421	183ms	0ms
	01	23,263	218ms	0ms
	02	18,315	170ms	0ms
	03	19,577	183ms	0ms
	04	14,649	131ms	0ms
	05	13,869	126ms	0ms
	06	12,487	113ms	0ms
	07	13,806	123ms	0ms
	08	30,544	287ms	0ms
	09	75,187	766ms	0ms
	10	98,069	994ms	0ms
	11	109,558	1s112ms	0ms
	12	113,329	1s131ms	0ms
	13	109,443	1s33ms	0ms
	14	96,727	1s89ms	0ms
	15	95,148	1s209ms	0ms
	16	91,704	989ms	0ms
	17	71,154	662ms	0ms
	18	66,198	661ms	0ms
	19	54,854	538ms	0ms
	20	40,764	413ms	0ms
	21	30,472	284ms	0ms
	22	19,349	170ms	0ms

ROLLBACK;

Date: 2025-01-22 16:35:04 Duration: 0ms
ROLLBACK;

Date: 2025-01-22 14:27:56 Duration: 0ms
ROLLBACK;

Date: 2025-01-22 13:18:35 Duration: 0ms

4

1,226,144

Details

3m34s

0ms

13ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 22	00	19,836	3s353ms	0ms
	01	22,660	4s45ms	0ms
	02	17,672	3s71ms	0ms
	03	18,882	3s326ms	0ms
	04	14,014	2s292ms	0ms
	05	13,255	2s229ms	0ms
	06	11,877	1s849ms	0ms
	07	13,186	1s974ms	0ms
	08	29,900	4s903ms	0ms
	09	74,828	13s165ms	0ms
	10	97,576	17s85ms	0ms
	11	109,059	18s294ms	0ms
	12	112,651	19s173ms	0ms
	13	108,893	17s383ms	0ms
	14	96,534	18s66ms	0ms
	15	94,525	19s911ms	0ms
	16	91,517	16s790ms	0ms
	17	70,778	11s326ms	0ms
	18	65,689	11s443ms	0ms
	19	54,165	9s298ms	0ms
	20	39,861	7s80ms	0ms
	21	29,870	5s15ms	0ms
	22	18,916	2s963ms	0ms

SELECT payload FROM http_sessions WHERE sid = '790f7a41f16ab50a60e5b07615eb3b2952581df7';

Date: 2025-01-22 01:28:51 Duration: 13ms
SELECT payload FROM http_sessions WHERE sid = '8019a3cef3f9bee1150a671c5cfb40c7f8229fd8';

Date: 2025-01-22 17:01:54 Duration: 11ms
SELECT payload FROM http_sessions WHERE sid = '9eaad8c43c41c82d29698a566e165bcfdcf46db7';

Date: 2025-01-22 12:02:35 Duration: 10ms

5

1,216,826

Details

1m50s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 22	00	19,881	1s671ms	0ms
	01	22,692	1s979ms	0ms
	02	17,761	1s544ms	0ms
	03	18,938	1s627ms	0ms
	04	14,140	1s182ms	0ms
	05	13,334	1s138ms	0ms
	06	11,947	1s13ms	0ms
	07	13,223	1s76ms	0ms
	08	29,559	2s471ms	0ms
	09	73,836	6s645ms	0ms
	10	96,561	8s630ms	0ms
	11	108,061	9s605ms	0ms
	12	111,729	9s986ms	0ms
	13	107,978	9s198ms	0ms
	14	95,456	9s486ms	0ms
	15	93,863	10s172ms	0ms
	16	90,582	8s485ms	0ms
	17	70,233	6s45ms	0ms
	18	65,170	5s905ms	0ms
	19	53,711	4s806ms	0ms
	20	39,654	3s606ms	0ms
	21	29,684	2s529ms	0ms
	22	18,833	1s562ms	0ms

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

Date: 2025-01-22 09:28:11 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-22 16:00:58 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-22 10:15:14 Duration: 1ms

6

898,355

Details

2m16s

0ms

10ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 22	00	12,127	1s953ms	0ms
	01	18,071	2s636ms	0ms
	02	11,749	1s932ms	0ms
	03	13,342	2s365ms	0ms
	04	8,335	1s541ms	0ms
	05	7,464	1s367ms	0ms
	06	7,386	1s253ms	0ms
	07	8,328	1s359ms	0ms
	08	22,757	3s347ms	0ms
	09	63,603	9s512ms	0ms
	10	79,208	12s304ms	0ms
	11	86,073	11s350ms	0ms
	12	91,172	13s292ms	0ms
	13	85,079	12s196ms	0ms
	14	64,943	11s65ms	0ms
	15	67,775	11s950ms	0ms
	16	62,280	10s356ms	0ms
	17	50,114	6s567ms	0ms
	18	47,966	6s752ms	0ms
	19	35,103	5s286ms	0ms
	20	24,104	3s791ms	0ms
	21	18,113	2s787ms	0ms
	22	13,263	1s841ms	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 (960);

Date: 2025-01-22 17:21:53 Duration: 10ms
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 (916);

Date: 2025-01-22 17:21:53 Duration: 9ms
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 (861);

Date: 2025-01-22 17:21:53 Duration: 9ms

7

687,962

Details

2m1s

0ms

40ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 22	00	9,557	1s749ms	0ms
	01	12,801	2s545ms	0ms
	02	9,160	1s838ms	0ms
	03	11,034	2s211ms	0ms
	04	6,990	1s366ms	0ms
	05	6,809	1s319ms	0ms
	06	6,122	1s169ms	0ms
	07	6,866	921ms	0ms
	08	17,991	2s619ms	0ms
	09	48,473	8s73ms	0ms
	10	60,416	10s529ms	0ms
	11	65,683	11s318ms	0ms
	12	68,414	11s978ms	0ms
	13	64,008	10s119ms	0ms
	14	50,245	9s867ms	0ms
	15	50,334	10s770ms	0ms
	16	47,030	8s276ms	0ms
	17	37,803	5s784ms	0ms
	18	37,240	6s115ms	0ms
	19	27,356	4s740ms	0ms
	20	19,237	4s284ms	0ms
	21	14,494	2s624ms	0ms
	22	9,899	1s465ms	0ms

COMMIT;

Date: 2025-01-22 15:58:16 Duration: 40ms
COMMIT;

Date: 2025-01-22 14:57:21 Duration: 39ms
COMMIT;

Date: 2025-01-22 20:15:21 Duration: 37ms

8

542,899

Details

1m16s

0ms

15ms

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
Jan 22	00	8,921	975ms	0ms
	01	12,901	1s710ms	0ms
	02	8,084	908ms	0ms
	03	8,265	975ms	0ms
	04	5,007	623ms	0ms
	05	2,952	333ms	0ms
	06	4,191	523ms	0ms
	07	4,378	582ms	0ms
	08	11,543	1s470ms	0ms
	09	38,318	5s188ms	0ms
	10	48,033	6s942ms	0ms
	11	49,061	6s862ms	0ms
	12	54,615	8s397ms	0ms
	13	48,877	7s540ms	0ms
	14	33,198	5s392ms	0ms
	15	39,371	7s700ms	0ms
	16	38,063	5s440ms	0ms
	17	32,165	3s897ms	0ms
	18	31,751	3s680ms	0ms
	19	23,046	2s783ms	0ms
	20	18,955	2s131ms	0ms
	21	12,630	1s275ms	0ms
	22	8,574	941ms	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 (5099386, 5116714, 5099170, 5101184, 5109007, 5466842, 5127086, 5099006, 5099167, 5099007, 5116779, 5101617, 5110603, 5278694, 5099013, 5099590, 5099528, 5099296, 5101722, 5099037, 5334816, 5099009, 5099793, 5098996, 5099349, 5099263, 5099202, 5099014, 5249754, 5134271, 5101222, 5098994, 5099941, 5480008, 5111339, 5105152, 5101649, 5099633, 5099403, 5100606, 5101202, 5099540, 5101294, 5099111, 5099472, 5099446, 5158551, 5099091, 5100223, 5102147, 5099360, 5099838, 5099181, 5099930, 5099206, 5099102, 5103298, 5099190, 5102684, 5103712, 5099092, 5104237, 5099027, 5213263, 5431364, 5099165, 5481486, 5099186, 5110873, 5171626, 5123240, 5108224, 5114820, 5100872, 5111665, 5099117, 5303805, 5100424, 5161190, 5101122, 5100181, 5099272, 5099129, 5099694, 5099236, 5099035, 5100540, 5119368, 5249556, 5173679, 5241773, 5100726, 5482207, 5111817, 5150538, 5109628, 5099791, 5103378, 5112263, 5164808, 5103258, 5099504, 5099144, 5100397, 5365876, 5100749, 5099264, 5104971, 5166331, 5099028, 5100603, 5099194, 5099737, 5100506, 5435151, 5107560, 5099200, 5099582, 5109260, 5100913, 5105856, 5482397, 5099141, 5182550, 5106472, 5099008, 5103004, 5136883, 5101787, 5125624, 5482441, 5099356, 5116064, 5101152, 5125185, 5099244, 5099254, 5120460, 5244336, 5111070, 5117566, 5100192, 5099677, 5099502, 5104415, 5106719, 5101022, 5181036, 5102890, 5114378, 5099224, 5114905, 5100747, 5102056, 5482594, 5101609, 5099169, 5099489, 5099045, 5101379, 5104569, 5099632, 5099315, 5100718, 5106687, 5099243, 5104461, 5104615, 5102188, 5103046, 5250512, 5160988, 5099119, 5222892, 5099774, 5099042, 5100185, 5101568, 5101808, 5099415, 5109642, 5105271, 5109665, 5206203, 5099134, 5100204, 5101701, 5163115, 5099095, 5099309, 5474942, 5157424, 5099427, 5099125, 5321901, 5117535, 5100610, 5142947, 5122129, 5287348, 5100232, 5113681, 5109538, 5099761, 5099630, 5108594, 5104513, 5104101, 5101461, 5117911, 5118479, 5104963, 5107079, 5483098, 5121990, 5103117, 5102969, 5403324, 5100936, 5106438, 5103976, 5099105, 5099662, 5099010, 5099857, 5099727, 5099130);

Date: 2025-01-22 09:59:31 Duration: 15ms
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 (5428305, 5219224, 5316128, 5454854, 5305630, 5387586, 5136665, 5472955, 5334206, 5248901, 5180304, 5440815, 5144110, 5144111, 5382475, 5273175, 5180103, 5145582, 5342880, 5152253);

Date: 2025-01-22 16:30:21 Duration: 15ms
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 (5101367, 5099007, 5251466, 5103075, 5143808, 5099254, 5099272, 5099334, 5114357, 5099190, 5099187, 5099585, 5099009, 5482433, 5172603, 5249620, 5424854, 5099006, 5099639, 5102824, 5099003, 5099275, 5102257, 5111266, 5099296, 5099144, 5110969, 5099306, 5468887, 5256026, 5225037, 5099654, 5100677, 5099013, 5100132, 5121329, 5484315, 5099415, 5099244, 5113203, 5103412, 5099045, 5111264, 5099360, 5484980, 5099727, 5099137, 5099170, 5389829, 5099120, 5245655, 5099815, 5264438, 5099092, 5102003, 5100022, 5099297, 5099540, 5134113, 5099662, 5128778, 5113099, 5101298, 5099641, 5099248, 5484995, 5099146, 5482898, 5099528, 5405100, 5101408, 5372854, 5099169, 5099745, 5226049, 5103735, 5099102, 5427545, 5100637, 5099008, 5122020, 5099103, 5482892, 5125431, 5484859, 5483721, 5102062, 5149198, 5485309, 5426446, 5484982, 5121244, 5484340, 5099677, 5478954, 5100421, 5280787, 5204164, 5371919, 5099277, 5099224, 5485306, 5099206, 5101424, 5156407, 5161762, 5138995, 5482276, 5099130, 5099348, 5316010, 5099568, 5412629, 5181178, 5099135, 5186924, 5099300, 5156832, 5099726, 5259179, 5099179, 5099236, 5099162, 5100554, 5209311);

Date: 2025-01-22 17:21:57 Duration: 6ms

9

542,094

Details

37s447ms

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
Jan 22	00	7,197	413ms	0ms
	01	9,569	559ms	0ms
	02	5,856	335ms	0ms
	03	5,594	321ms	0ms
	04	3,514	197ms	0ms
	05	2,213	140ms	0ms
	06	4,174	221ms	0ms
	07	4,870	253ms	0ms
	08	11,793	677ms	0ms
	09	37,590	2s447ms	0ms
	10	47,713	3s320ms	0ms
	11	52,612	3s611ms	0ms
	12	54,859	3s929ms	0ms
	13	51,850	3s522ms	0ms
	14	37,017	3s32ms	0ms
	15	38,469	3s802ms	0ms
	16	38,608	2s810ms	0ms
	17	32,387	1s880ms	0ms
	18	33,183	2s59ms	0ms
	19	24,172	1s556ms	0ms
	20	17,788	1s137ms	0ms
	21	13,338	775ms	0ms
	22	7,728	440ms	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 (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 57, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112, 12);

Date: 2025-01-22 12:15: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 (71, 1, 9, 30, 19, 39, 123, 4, 17, 26, 65, 8, 5, 38, 16, 77, 35, 32, 127, 102, 36, 24, 28, 60, 44, 128, 7, 76, 78, 11, 70, 61, 27, 66, 42, 80, 10, 49, 126, 64, 2, 114, 119, 73);

Date: 2025-01-22 15:14:11 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 (27, 32, 1, 17, 11);

Date: 2025-01-22 13:18:19 Duration: 1ms

10

401,736

Details

2m13s

0ms

17ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 22	00	2,767	834ms	0ms
	01	2,296	715ms	0ms
	02	1,616	493ms	0ms
	03	1,245	382ms	0ms
	04	849	258ms	0ms
	05	1,160	352ms	0ms
	06	1,486	447ms	0ms
	07	1,204	351ms	0ms
	08	8,153	2s419ms	0ms
	09	21,748	7s126ms	0ms
	10	30,084	10s226ms	0ms
	11	47,309	15s552ms	0ms
	12	46,301	15s245ms	0ms
	13	38,264	12s312ms	0ms
	14	31,675	11s647ms	0ms
	15	37,763	15s326ms	0ms
	16	26,212	9s264ms	0ms
	17	25,844	7s804ms	0ms
	18	25,588	8s52ms	0ms
	19	20,802	6s362ms	0ms
	20	13,712	4s214ms	0ms
	21	9,353	2s608ms	0ms
	22	6,305	1s744ms	0ms

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

Date: 2025-01-22 13:02:09 Duration: 17ms
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 = 1372) OR r.global) ORDER BY r.id;

Date: 2025-01-22 15:31:17 Duration: 3ms
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 = 920) OR r.global) ORDER BY r.id;

Date: 2025-01-22 09:07:29 Duration: 3ms

11

376,688

Details

1m13s

0ms

11ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 22	00	5,064	796ms	0ms
	01	6,849	1s101ms	0ms
	02	3,833	679ms	0ms
	03	3,593	712ms	0ms
	04	2,242	434ms	0ms
	05	1,882	309ms	0ms
	06	2,516	402ms	0ms
	07	3,374	544ms	0ms
	08	9,898	1s564ms	0ms
	09	28,311	5s230ms	0ms
	10	32,154	6s449ms	0ms
	11	36,845	7s376ms	0ms
	12	39,477	7s583ms	0ms
	13	36,118	6s780ms	0ms
	14	28,721	6s244ms	0ms
	15	29,390	7s312ms	0ms
	16	26,949	5s637ms	0ms
	17	21,610	3s844ms	0ms
	18	20,578	3s815ms	0ms
	19	14,726	2s775ms	0ms
	20	9,751	1s894ms	0ms
	21	7,724	1s288ms	0ms
	22	5,083	755ms	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 (2);

Date: 2025-01-22 17:21:53 Duration: 11ms
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 (8007746);

Date: 2025-01-22 17:21:53 Duration: 4ms
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 (8007449);

Date: 2025-01-22 17:21:53 Duration: 4ms

12

297,233

Details

58s424ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 22	00	2,666	378ms	0ms
	01	2,191	318ms	0ms
	02	1,650	228ms	0ms
	03	1,227	161ms	0ms
	04	1,029	132ms	0ms
	05	1,635	223ms	0ms
	06	1,361	202ms	0ms
	07	1,740	240ms	0ms
	08	8,330	1s263ms	0ms
	09	19,392	3s451ms	0ms
	10	22,368	4s400ms	0ms
	11	33,504	6s762ms	0ms
	12	32,544	6s539ms	0ms
	13	27,342	5s185ms	0ms
	14	22,468	4s894ms	0ms
	15	29,653	7s550ms	0ms
	16	18,015	3s777ms	0ms
	17	17,317	3s108ms	0ms
	18	16,460	3s135ms	0ms
	19	15,290	2s817ms	0ms
	20	10,434	1s906ms	0ms
	21	6,430	1s53ms	0ms
	22	4,187	691ms	0ms

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

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

Date: 2025-01-22 15:08:25 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_system' AND model = 'res.groups');

Date: 2025-01-22 15:22:08 Duration: 1ms

13

269,801

Details

1d22h58m43s

493ms

5s288ms

626ms

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

Day	Hour	Count	Duration	Avg duration
Jan 22	00	7,208	1h7m3s	558ms
	01	9,306	1h26m35s	558ms
	02	7,842	1h12m49s	557ms
	03	10,449	1h37m36s	560ms
	04	5,833	53m22s	549ms
	05	4,907	45m20s	554ms
	06	4,273	38m36s	542ms
	07	2,794	25m17s	542ms
	08	5,959	53m59s	543ms
	09	13,622	2h15m	594ms
	10	18,171	3h11m48s	633ms
	11	16,298	2h52m26s	634ms
	12	16,443	2h50m18s	621ms
	13	11,814	1h57m19s	595ms
	14	14,878	2h51m10s	690ms
	15	29,420	6h1m58s	738ms
	16	24,412	4h30m40s	665ms
	17	9,616	1h37m13s	606ms
	18	13,355	2h21m32s	635ms
	19	14,446	2h31m23s	628ms
	20	15,470	2h44m25s	637ms
	21	9,695	1h37m24s	602ms
	22	3,590	35m19s	590ms

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

Date: 2025-01-22 15:53:19 Duration: 5s288ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4685050)) AND (("shipping_track"."id" not in (38771477, 38771477)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:28:32 Duration: 5s59ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4685019)) AND (("shipping_track"."id" not in (38771218, 38771218)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:27:16 Duration: 4s716ms

14

249,000

Details

1m10s

0ms

20ms

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
Jan 22	00	3,967	955ms	0ms
	01	5,434	1s346ms	0ms
	02	3,825	929ms	0ms
	03	3,612	985ms	0ms
	04	2,106	601ms	0ms
	05	1,640	429ms	0ms
	06	1,725	474ms	0ms
	07	1,942	571ms	0ms
	08	4,636	1s219ms	0ms
	09	15,330	4s257ms	0ms
	10	19,688	5s522ms	0ms
	11	21,040	5s683ms	0ms
	12	24,299	10s323ms	0ms
	13	22,643	6s233ms	0ms
	14	16,174	4s642ms	0ms
	15	17,909	6s917ms	0ms
	16	17,704	4s701ms	0ms
	17	15,009	3s391ms	0ms
	18	16,223	3s664ms	0ms
	19	11,369	2s747ms	0ms
	20	11,163	2s709ms	0ms
	21	7,575	1s625ms	0ms
	22	3,987	867ms	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 (42058257, 41662641, 42058467, 42119211, 42119160, 42119221, 42118924, 42058262, 42118902, 42118928, 41697642, 42002821, 42119204, 42119152, 42118900, 42058270, 42051499, 42002841, 41958179, 42147002, 42118957, 42118922, 41997788, 41976247, 41696212, 42117728, 42118958, 42118915, 41836196, 42104330, 41230248, 42135799, 42110565, 42058103, 42142069, 42058161, 41664994, 41991591, 42128846, 42110566, 41840268, 41991292, 41575542, 42147007, 32213093, 41862537, 41991583, 41981997, 41976248, 41936446, 41988691, 40504332, 42058053, 42058069, 41904605, 32651750, 42136304, 42044297, 40001324, 42060892, 42002787, 42119214, 42111361, 41873299, 41891195, 42062012, 42058546, 42075397, 42058576, 42130196, 41188924, 41900982, 42119225, 42058208, 42021250, 41960698, 42054654, 42073178, 41987513, 42119213, 42119219, 42118910, 32178642, 42077028, 41991210, 42089975, 42057698, 41723254, 41798515, 41574883, 42057741, 42058142, 42092051, 42058222, 41202972, 42034490, 41792573, 42014796, 42111200, 42119230);

Date: 2025-01-22 17:21:54 Duration: 20ms
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 (41831833, 42014239, 42089653, 42089654, 42089655, 42089656, 42089657, 42089658, 42089659, 42089660, 42089661, 42089662, 42089663, 42089664, 42089665, 42089666, 42089667, 42089668, 42089669, 42089670, 42089671, 42089672, 42089673, 42089674, 42089675, 42089676, 42089677, 42089678, 42089679, 42089680, 42089681, 42089682, 42089683, 42089684, 42089685, 42089686, 42089687, 42089688, 42089689, 42089690, 42089691, 42090312, 42172683, 42172684, 42172685, 42172686, 42172687, 42172688, 42172689, 42172690, 42172691, 42172788, 42172789, 42172790, 42172791, 42172846, 42172847, 42172848, 42172849, 42172850, 42172851, 42172852, 42172853, 42172854, 42172855, 42172856, 42172857, 42172858, 42172859, 42172860, 42172861, 42172862, 42172863, 42172864, 42172865, 42172866, 42172867, 42172868, 42172869, 42172870, 42172871, 42172872, 42172873, 42172874, 42172875, 42172876, 42172877, 42172878, 42172879, 42172880, 42172881, 42172882, 42172883, 42172884, 42172885, 42172886, 42172887, 42172888, 42172889, 42172890, 42172891, 42172912, 42172913, 42172914, 42172915, 42172916, 42172917, 42172918, 42172919, 42172920, 42172921, 42172922, 42172923, 42172924, 42172925, 42172926, 42172927, 42172928, 42172929, 42172930, 42172931, 42172932, 42172933, 42172934, 42172935, 42172936, 42172937, 42172938, 42172939, 42172940, 42172941, 42172942, 42172943, 42172944, 42172945, 42172946, 42172947, 42172948, 42172949, 42172950, 42172951, 42172961, 42172962, 42172963, 42172964, 42172965, 42172966, 42172967, 42172968, 42172969, 42172970, 42172971, 42172972, 42172973, 42172974, 42172975, 42172976, 42172977, 42172978, 42172979, 42172980, 42172981, 42172982, 42172983, 42172984, 42172985, 42172986, 42172987, 42172988, 42172989, 42172990, 42172991, 42173038, 42173039, 42173040, 42173041, 42173083, 42173084, 42173085, 42173086, 42173087, 42173088, 42173089, 42173090, 42173091, 42173142, 42173143, 42173144, 42173145, 42173146, 42173147, 42173148, 42173149, 42173150, 42173151, 42173152, 42173153, 42173154, 42173155, 42173156, 42173157, 42173158, 42173159, 42173160, 42173161, 42173162, 42173163, 42173164, 42173165, 42173166, 42173167, 42173168, 42173169, 42173170, 42173171, 42173172, 42173173, 42173174, 42173175, 42173176, 42173177, 42173178, 42173179, 42173180, 42173181, 42173182, 42173183, 42173184, 42173185, 42173186, 42173187, 42173188, 42173189, 42173190, 42173191, 42173217, 42173218, 42173219, 42173220, 42173221, 42173222, 42173223, 42173224, 42173225, 42173226, 42173227, 42173228, 42173229, 42173230, 42173231, 42173232, 42173233, 42173234, 42173235, 42173236, 42173237, 42173238, 42173239, 42173240, 42173241, 42173242, 42173243, 42173244, 42173245, 42173246, 42173247, 42173248, 42173249, 42173250, 42173251, 42173252, 42173253, 42173254, 42173255, 42173256, 42173257, 42173258, 42173259, 42173260, 42173261, 42173262, 42173263, 42173264, 42173265, 42173266, 42173267, 42173268, 42173269, 42173270, 42173271, 42173272, 42173273, 42173274, 42173275, 42173276, 42173277, 42173278, 42173279, 42173280, 42173281, 42173282, 42173283, 42173284, 42173285, 42173286, 42173287, 42173288, 42173289, 42173290, 42173291, 42173292, 42173293, 42173294, 42173295, 42173296, 42173297, 42173298, 42173299, 42173300, 42173301, 42173302, 42173303, 42173304, 42173305, 42173306, 42173307, 42173308, 42173309, 42173310, 42173311, 42173312, 42173313, 42173314, 42173315, 42173316, 42173317, 42173318, 42173319, 42173320, 42173321, 42173322, 42173323, 42173324, 42173325, 42173326, 42173327, 42173328, 42173329, 42173330, 42173331, 42173332, 42173333, 42173334, 42173335, 42173336, 42173337, 42173338, 42173339, 42173340, 42173341, 42173342, 42173343, 42173344, 42173345, 42173346, 42173347, 42173348, 42173349, 42173350, 42173351, 42173352, 42173353, 42173354, 42173355, 42173356, 42173357, 42173358, 42173359, 42173360, 42173361, 42173362, 42173363, 42173364, 42173365, 42173366, 42173367, 42173368, 42173369, 42173370, 42173371, 42173372, 42173373, 42173374, 42173375, 42173376, 42173377, 42173378, 42173379, 42173380, 42173381, 42173382, 42173383, 42173384, 42173385, 42173386, 42173387, 42173388, 42173389, 42173390, 42173391, 42173392, 42173393, 42173394, 42173395, 42173396, 42173397, 42173398, 42173399, 42173400, 42173401, 42173402, 42173403, 42173404, 42173405, 42173406, 42173407, 42173408, 42173409, 42173410, 42173411, 42173412, 42173413, 42173414, 42173415, 42173416, 42173417, 42173418, 42173419, 42173420, 42173421, 42173422, 42173423, 42173424, 42173425, 42173426, 42173427, 42173428, 42173429, 42173430, 42173431, 42173432, 42173433, 42173434, 42173435, 42173436, 42173437, 42173438, 42173439, 42173440, 42173441, 42173442, 42173443, 42173444, 42173445, 42173446, 42173447, 42173448, 42173449, 42173450, 42173451, 42173452, 42173453, 42173454, 42173455, 42173456, 42173457, 42173458, 42173459, 42173460, 42173461, 42173462, 42173463, 42173464, 42173465, 42173466, 42173467, 42173468, 42173469, 42173470, 42173471, 42173472, 42173473, 42173474, 42173475, 42173476, 42173477, 42173478, 42173479, 42173480, 42173481, 42173482, 42173483, 42173484, 42173485, 42173486, 42173487, 42173488, 42173489, 42173490, 42173491, 42173492, 42173493, 42173494, 42173495, 42173496, 42173497, 42173498, 42173499, 42173500, 42173501, 42173502, 42173503, 42173504, 42173505, 42173506, 42173507, 42173508, 42173509, 42173510, 42173511, 42173512, 42173513, 42173514, 42173515, 42173516, 42173517, 42173518, 42173519, 42173520, 42173521, 42173522, 42173523, 42173524, 42173525, 42173526, 42173527, 42173528, 42173529, 42173530, 42173531, 42173532, 42173533, 42173534, 42173535, 42173536, 42173537, 42173538, 42173539, 42173540, 42173541, 42173542, 42173543, 42173544, 42173545, 42173546, 42173547, 42173548, 42173549, 42173550, 42173551, 42173552, 42173553, 42173554, 42173555, 42173556, 42173557, 42173558, 42173559, 42173560, 42173561, 42173562, 42173563, 42173564, 42173565, 42173566, 42173567, 42173568, 42173569, 42173570, 42173571, 42173572, 42173573, 42173574, 42173575, 42173576, 42173577, 42173578, 42173579, 42173580, 42173581, 42173582, 42173583, 42173584, 42173585, 42173586, 42173587, 42173588, 42173589, 42173590, 42173591, 42173592, 42173593, 42173594, 42173595, 42173596, 42173597, 42173598, 42173599, 42173600, 42173601, 42173602, 42173603, 42173604, 42173605, 42173606, 42173607, 42173608, 42173609, 42173610, 42173611, 42173612, 42173613, 42173614, 42173615, 42173616, 42173617, 42173618, 42173619, 42173620, 42173621, 42173622, 42173623, 42173624, 42173625, 42173626, 42173627, 42173628, 42173629, 42173630, 42173631, 42173632, 42173633, 42173634, 42173635, 42173636, 42173637, 42173638, 42173639, 42173640, 42173641);

Date: 2025-01-22 16:30:21 Duration: 17ms
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 (42129475, 42049273, 32205568, 42159202, 32189431, 41935278, 32230932, 32229337, 32229607, 42080637, 41967029, 42159807, 32240124, 32228807, 32190889, 42074296, 32203523, 32198666, 42099291, 32198058, 32259383, 32230674, 32268463, 42037146, 42036865, 42156692);

Date: 2025-01-22 17:21:53 Duration: 12ms

15

185,921

Details

18s904ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 22	00	2,554	326ms	0ms
	01	3,934	535ms	0ms
	02	2,500	357ms	0ms
	03	2,422	342ms	0ms
	04	1,502	210ms	0ms
	05	687	100ms	0ms
	06	1,366	192ms	0ms
	07	1,517	212ms	0ms
	08	4,159	594ms	0ms
	09	13,451	1s616ms	0ms
	10	16,973	1s243ms	0ms
	11	18,043	1s461ms	0ms
	12	19,215	1s706ms	0ms
	13	18,036	1s616ms	0ms
	14	12,285	1s629ms	0ms
	15	14,079	2s213ms	0ms
	16	13,252	1s67ms	0ms
	17	11,406	758ms	0ms
	18	10,397	812ms	0ms
	19	7,238	642ms	0ms
	20	4,850	539ms	0ms
	21	3,472	421ms	0ms
	22	2,583	304ms	0ms

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

Date: 2025-01-22 15:13:06 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-01-22 17:21:53 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-01-22 12:20:23 Duration: 1ms

16

185,311

Details

1m50s

0ms

28ms

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

Day	Hour	Count	Duration	Avg duration
Jan 22	00	435	247ms	0ms
	01	1,682	1s285ms	0ms
	02	454	276ms	0ms
	03	270	162ms	0ms
	04	158	89ms	0ms
	05	298	149ms	0ms
	06	762	317ms	0ms
	07	1,096	413ms	0ms
	08	3,578	1s911ms	0ms
	09	9,788	5s487ms	0ms
	10	9,120	5s885ms	0ms
	11	12,232	7s709ms	0ms
	12	12,675	9s249ms	0ms
	13	11,736	7s393ms	0ms
	14	28,743	16s467ms	0ms
	15	40,532	25s249ms	0ms
	16	26,072	13s798ms	0ms
	17	6,161	3s549ms	0ms
	18	5,230	2s764ms	0ms
	19	8,095	4s59ms	0ms
	20	3,435	1s948ms	0ms
	21	1,405	750ms	0ms
	22	1,354	910ms	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 (4680032, 4675873, 4672861, 4671908, 4669638, 4664930, 4662967, 4662767, 4662579, 4660986, 4658278, 4657409, 4656786, 4644883, 4637632, 4630488, 4630108, 4607943, 4599298, 4574622, 4573675, 4558461);

Date: 2025-01-22 17:21:53 Duration: 28ms
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 (3709630, 1170998, 3225895, 3799363, 2193231, 2056342, 1305602, 2328440, 4304539, 3499021, 1694928, 3291492, 2974686, 4261397, 1212132, 1198462, 4227708, 1010326, 1360234, 4123821, 1769608, 3670015, 2003290, 1300657, 1305571, 2982225, 1188495, 3825953, 2151948, 3804027, 3193434, 3214070, 2597417, 2935307, 1876446, 1250368, 1839000, 2994944, 2784892, 3352693, 3239773, 3485787, 1014843, 1605057, 4051560, 2262017, 2923258, 3275820, 1703445, 1367613, 3978856, 2719375, 2519493, 3049167, 1112678, 3180179, 3308147, 4151624, 1088470, 1725121, 2193312, 1876156, 2561873, 1703441, 2719438, 2087827, 2183862, 2024942, 3133807, 1846106, 3220398, 3998264, 3288033, 3646994, 3646997, 4202829, 981470, 4235472, 2854063, 1120977, 3461464, 4161156, 3826556, 2004466, 3340703, 4409908, 2051286, 1577676, 1990990, 2976818, 2895228, 3108668, 2740114, 2441310, 3646188, 2873420, 954659, 1653220, 3441487, 1799158, 2184796, 1397834, 2066502, 3759037, 4249977, 1338773, 994147, 1764294, 1669324, 2949556, 3515446, 2559042, 3493648, 3872595, 1162241, 4253951, 3670522, 1885494, 1400948, 2189187, 2877398, 1441795, 4249976, 2269859, 1249411, 1113483, 3871095, 4460787, 3159143, 2223568, 3891868, 3607273, 1661895, 4249934, 1690782, 4211804, 1669356, 1570880, 3615553, 2478402, 2837548, 4127163, 3537085, 2028121, 1054144, 1279671, 2309422, 3163689, 1269863, 3217932, 1473962, 1923545, 799292, 3258440, 2068046, 1832879, 1078659, 1561164, 4483292, 2220488, 3387856, 1470997, 3682905, 1211975, 1985890, 1767395, 2298596, 1529254, 3756084, 3281525, 1323648, 1565051, 1788953, 3323310, 3739789, 1014193, 3552404, 3844697, 2635937, 1129599, 3670521, 3693834, 2063250, 3381484, 2494083, 2438887, 3033184, 2033898, 4336130, 1874170, 3300911, 4460769, 2658431, 4202939, 1832928, 4051545, 4071265, 4339601, 1763525);

Date: 2025-01-22 17:22:00 Duration: 24ms
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 (4381324, 4530829, 4538249, 4499192, 4538292, 4228033, 4381280, 4235286, 4381281, 4341639, 4381278, 4407343, 4530639, 4307085, 4336858, 4381423, 4407344, 4501134, 4258638, 4150722, 4407340, 4432695, 4575720, 4344056, 4538250, 4381496, 4575721, 4427571, 4410288, 4381319, 3959529, 3892173, 2512788, 4458124, 4464563, 4499044, 4458119, 4458067, 4458069, 4427577, 4499221, 4530632, 4530826, 4530633, 4538253, 4344058, 4506063, 4122277, 4283991, 4458064, 4381285, 4530566, 4043244, 4043191, 4464690, 4499179, 4530565, 4070160, 4427544, 4043194, 4043202, 4043231, 4235264, 3679759, 4043186, 4235281, 4432694, 4465210, 4432705, 4404305, 4432568, 4404290, 4465218, 4464835, 4458079, 4499339, 4458074, 4458312, 4526866, 4465775, 4464570, 4499158, 4530839, 4530694, 4530664, 4530838, 4465771, 4427567, 4457539, 4235256, 4465179, 4406751, 4457534, 4465768, 4455760, 4455848, 4432693, 4465208, 4457537, 4458409, 4427621, 4502092, 4458081, 4404327, 4427616, 4506122, 4464778, 4432624, 4499185, 4499303, 3864166, 4499181, 4501257, 4464741, 4538437, 4455945, 4279044, 4458076, 4465778, 3930065, 4406737, 4499209, 4506106, 4538374, 4499046, 4516697, 4410300, 4501130, 4455834, 4568265, 4119584, 4256813, 4043178, 4043234, 4043174, 3923528, 4043217, 3864140, 4043239, 4043213, 4043224, 4284046, 4070170, 4043220, 4043166, 4235259, 4235261, 4235283, 4228130, 4308729, 2154507, 4308733);

Date: 2025-01-22 13:30:10 Duration: 18ms

17

174,513

Details

10s739ms

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
Jan 22	00	1,195	61ms	0ms
	01	903	46ms	0ms
	02	643	31ms	0ms
	03	448	21ms	0ms
	04	314	15ms	0ms
	05	473	23ms	0ms
	06	675	35ms	0ms
	07	485	23ms	0ms
	08	3,537	183ms	0ms
	09	9,389	551ms	0ms
	10	12,581	792ms	0ms
	11	20,374	1s266ms	0ms
	12	20,494	1s254ms	0ms
	13	16,558	970ms	0ms
	14	13,476	918ms	0ms
	15	16,284	1s291ms	0ms
	16	10,678	701ms	0ms
	17	11,221	613ms	0ms
	18	11,437	661ms	0ms
	19	9,587	542ms	0ms
	20	6,306	358ms	0ms
	21	4,368	219ms	0ms
	22	3,087	155ms	0ms

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

Date: 2025-01-22 15:59:58 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 (99);

Date: 2025-01-22 12:40:29 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 (88, 89);

Date: 2025-01-22 11:41:49 Duration: 0ms

18

167,192

Details

22s230ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 22	00	1,176	127ms	0ms
	01	882	97ms	0ms
	02	637	67ms	0ms
	03	427	43ms	0ms
	04	308	32ms	0ms
	05	445	48ms	0ms
	06	643	72ms	0ms
	07	473	49ms	0ms
	08	3,451	383ms	0ms
	09	8,974	1s135ms	0ms
	10	12,138	1s652ms	0ms
	11	19,651	2s629ms	0ms
	12	19,474	2s559ms	0ms
	13	15,636	1s970ms	0ms
	14	12,990	1s918ms	0ms
	15	15,714	2s772ms	0ms
	16	10,366	1s475ms	0ms
	17	10,768	1s244ms	0ms
	18	10,958	1s364ms	0ms
	19	9,122	1s109ms	0ms
	20	5,971	726ms	0ms
	21	3,983	424ms	0ms
	22	3,005	324ms	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 (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

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

Date: 2025-01-22 16:20:17 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-22 10:42:09 Duration: 0ms

19

148,524

Details

2h18m47s

41ms

372ms

56ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 22	00	3,897	3m15s	50ms
	01	4,342	3m38s	50ms
	02	2,643	2m13s	50ms
	03	3,131	2m39s	50ms
	04	2,001	1m40s	50ms
	05	1,158	58s415ms	50ms
	06	1,346	1m7s	50ms
	07	1,454	1m13s	50ms
	08	3,131	2m39s	50ms
	09	10,506	9m31s	54ms
	10	12,996	12m31s	57ms
	11	14,504	13m56s	57ms
	12	12,107	11m27s	56ms
	13	9,793	8m55s	54ms
	14	9,896	10m1s	60ms
	15	8,438	9m32s	67ms
	16	9,000	9m2s	60ms
	17	6,170	5m29s	53ms
	18	8,632	7m51s	54ms
	19	7,704	7m4s	55ms
	20	7,979	7m13s	54ms
	21	5,853	5m8s	52ms
	22	1,843	1m36s	52ms

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

Date: 2025-01-22 17:21:54 Duration: 372ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4638056, 4613446, 4581152, 4573045, 4527567)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-22 14:26:00 Duration: 364ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4663703, 4632468, 4625641, 4611664, 4530398)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-22 14:26:25 Duration: 340ms

20

141,532

Details

30s835ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 22	00	1,093	210ms	0ms
	01	838	164ms	0ms
	02	606	116ms	0ms
	03	503	92ms	0ms
	04	378	69ms	0ms
	05	480	91ms	0ms
	06	555	105ms	0ms
	07	435	79ms	0ms
	08	2,944	565ms	0ms
	09	8,058	1s695ms	0ms
	10	10,849	2s382ms	0ms
	11	16,592	3s563ms	0ms
	12	16,468	3s534ms	0ms
	13	13,170	2s760ms	0ms
	14	10,901	2s612ms	0ms
	15	13,196	3s491ms	0ms
	16	8,887	2s63ms	0ms
	17	8,875	1s767ms	0ms
	18	8,814	1s851ms	0ms
	19	7,504	1s536ms	0ms
	20	4,856	1s11ms	0ms
	21	3,191	610ms	0ms
	22	2,339	458ms	0ms

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

Date: 2025-01-22 05:35:23 Duration: 1ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (859) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-22 20:21:40 Duration: 1ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (875) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-22 15:06:07 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

45m44s

2m14s

52

Details

1h56m29s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 22	02	1	0ms	0ms
	03	2	1ms	0ms
	08	3	0ms	0ms
	09	5	4ms	0ms
	10	4	6ms	1ms
	11	3	5ms	1ms
	12	7	32m50s	4m41s
	13	5	3ms	0ms
	14	3	9ms	3ms
	15	2	5ms	2ms
	16	5	37m54s	7m34s
	17	2	2ms	1ms
	19	4	45m44s	11m26s
	20	2	0ms	0ms
	21	1	1ms	1ms
	22	3	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-22 18:20:36.590831', "last_update" = '2025-01-22 17:35:36.590858', "write_date" = '2025-01-22 17:35:36.148043', "write_uid" = 974 WHERE id IN (974);

Date: 2025-01-22 19:21:20 Duration: 45m44s
UPDATE "res_users" SET "exp_date" = '2025-01-22 15:57:35.100759', "last_update" = '2025-01-22 15:12:35.100781', "write_date" = '2025-01-22 15:12:34.769122', "write_uid" = 1 WHERE id IN (992);

Date: 2025-01-22 16:47:21 Duration: 34m46s
UPDATE "res_users" SET "exp_date" = '2025-01-22 11:39:49.627881', "last_update" = '2025-01-22 10:54:49.627905', "write_date" = '2025-01-22 10:54:49.242912', "write_uid" = 867 WHERE id IN (867);

Date: 2025-01-22 12:20:20 Duration: 25m31s

2

0ms

54m56s

2m8s

298

Details

10h38m55s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 22	00	2	0ms	0ms
	01	4	0ms	0ms
	02	1	0ms	0ms
	03	2	0ms	0ms
	04	2	54m56s	27m28s
	05	5	3ms	0ms
	06	5	2ms	0ms
	07	3	0ms	0ms
	08	10	2ms	0ms
	09	36	3h5m42s	5m9s
	10	30	1h26m11s	2m52s
	11	24	42ms	1ms
	12	42	1h2m47s	1m29s
	13	24	26ms	1ms
	14	23	1h56m50s	5m4s
	15	16	39ms	2ms
	16	16	1h57m10s	7m19s
	17	10	14ms	1ms
	18	12	14ms	1ms
	19	15	15m17s	1m1s
	20	5	4ms	0ms
	21	7	2ms	0ms
	22	4	3ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-22 03:08:02.210960', "last_update" = '2025-01-22 02:23:02.210979', "sid" = '431a094766f3919e1a2f0caa91be4e24c47e7ae2', "write_date" = '2025-01-22 02:23:01.881444', "write_uid" = 1 WHERE id IN (1244);

Date: 2025-01-22 04:17:58 Duration: 54m56s
UPDATE "res_users" SET "exp_date" = '2025-01-22 15:49:31.479501', "last_update" = '2025-01-22 15:04:31.479522', "sid" = '9f960da499966874f86d448954e7cc1d51da218e', "write_date" = '2025-01-22 15:04:31.144148', "write_uid" = 1319 WHERE id IN (1319);

Date: 2025-01-22 16:47:21 Duration: 42m49s
UPDATE "res_users" SET "exp_date" = '2025-01-22 15:52:32.243596', "last_update" = '2025-01-22 15:07:32.243622', "sid" = '9f960da499966874f86d448954e7cc1d51da218e', "write_date" = '2025-01-22 15:07:31.805102', "write_uid" = 1319 WHERE id IN (1319);

Date: 2025-01-22 16:47:21 Duration: 39m49s

3

0ms

51m6s

4s623ms

67,999

Details

3d15h19m26s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 22	00	988	214ms	0ms
	01	1,213	261ms	0ms
	02	1,048	225ms	0ms
	03	1,320	1m6s	50ms
	04	739	165ms	0ms
	05	734	154ms	0ms
	06	581	122ms	0ms
	07	459	1m55s	251ms
	08	1,541	325ms	0ms
	09	4,396	8h56m21s	7s320ms
	10	5,846	3h22m27s	2s77ms
	11	7,087	12h11m37s	6s194ms
	12	6,978	8h6m20s	4s181ms
	13	6,097	3h23m22s	2s1ms
	14	5,241	10h33m59s	7s257ms
	15	5,174	6h26m37s	4s483ms
	16	4,806	11h9s	8s241ms
	17	3,659	5h36m33s	5s518ms
	18	3,359	1h35m51s	1s712ms
	19	2,571	8h4m40s	11s310ms
	20	1,892	7h58m8s	15s162ms
	21	1,415	325ms	0ms
	22	855	13s266ms	15ms

update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:39:14.807479', exp_date = '2025-01-22 08:24:14.807481', logged_in = 'TRUE' where id = 977;

Date: 2025-01-22 09:30:21 Duration: 51m6s
update res_users set sid = 'beaec615154df506787beba4c9bf98b5ad3246a0', last_update = '2025-01-22 07:39:14.807416', exp_date = '2025-01-22 08:24:14.807421', logged_in = 'TRUE' where id = 977;

Date: 2025-01-22 09:30:21 Duration: 51m6s
update res_users set sid = 'faddbe0c45ccd264febe79dc78ce270ca9f72374', last_update = '2025-01-22 07:39:46.136393', exp_date = '2025-01-22 08:24:46.136395', logged_in = 'TRUE' where id = 977;

Date: 2025-01-22 09:30:21 Duration: 50m34s

4

27ms

4s629ms

2s954ms

267

Details

13m8s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 22	00	9	26s478ms	2s942ms
	01	9	27s935ms	3s103ms
	02	3	8s758ms	2s919ms
	08	2	6s306ms	3s153ms
	10	3	10s339ms	3s446ms
	11	14	12s764ms	911ms
	12	22	1m3s	2s884ms
	13	35	1m36s	2s742ms
	14	19	54s731ms	2s880ms
	15	23	1m34s	4s121ms
	16	26	1m34s	3s651ms
	17	24	1m2s	2s606ms
	18	19	1m	3s176ms
	19	15	47s289ms	3s152ms
	20	25	1m10s	2s832ms
	21	11	33s651ms	3s59ms
	22	8	17s788ms	2s223ms

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 (79))))))) 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 (79)))))) 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 (79)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))) 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 (79))))))))) 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 (79)))))))) AND ("policy_number"."name"::text ilike '%3315%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-22 15:23:35 Duration: 4s629ms
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 (79))))))) 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 (79)))))) 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 (79)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))) 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 (79))))))))) 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 (79)))))))) AND ("policy_number"."name"::text ilike '%33150%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-22 15:23:35 Duration: 4s609ms
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 (123))))))) 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 (123)))))) 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 (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) 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 (123))))))))) 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 (123)))))))) AND ("policy_number"."name"::text ilike '%84%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-22 15:32:31 Duration: 4s452ms

5

203ms

1s991ms

915ms

10,835

Details

2h45m18s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 22	00	492	7m17s	888ms
	01	642	9m23s	878ms
	02	159	2m21s	890ms
	03	73	1m5s	893ms
	04	16	14s18ms	876ms
	09	3	3s185ms	1s61ms
	10	19	14s595ms	768ms
	11	59	1m7s	1s144ms
	12	70	1m15s	1s83ms
	13	86	1m23s	973ms
	14	221	4m12s	1s144ms
	15	302	5m56s	1s179ms
	16	478	8m9s	1s23ms
	17	636	9m53s	933ms
	18	1,552	23m3s	891ms
	19	1,080	16m10s	898ms
	20	2,291	35m5s	918ms
	21	1,729	25m5s	870ms
	22	927	13m13s	856ms

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

Date: 2025-01-22 15:52:58 Duration: 1s991ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '80836')) 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 (48))))))) 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 (48)))))) 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 (48)))))) 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 (48))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-22 15:53:21 Duration: 1s888ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9924326')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-22 15:57:45 Duration: 1s793ms

6

499ms

4s424ms

645ms

45,999

Details

8h14m44s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 22	00	628	5m54s	564ms
	01	437	4m11s	576ms
	02	227	2m16s	601ms
	03	214	2m17s	643ms
	04	140	1m27s	627ms
	05	308	2m57s	575ms
	06	330	3m4s	560ms
	07	251	2m20s	560ms
	08	751	7m7s	569ms
	09	3,705	37m41s	610ms
	10	3,941	42m36s	648ms
	11	3,885	42m27s	655ms
	12	4,292	45m47s	640ms
	13	4,091	41m53s	614ms
	14	3,650	43m42s	718ms
	15	3,683	47m43s	777ms
	16	3,780	42m20s	672ms
	17	2,433	24m21s	600ms
	18	3,400	35m2s	618ms
	19	2,665	27m36s	621ms
	20	1,378	14m16s	621ms
	21	1,235	12m5s	587ms
	22	575	5m28s	570ms

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

Date: 2025-01-22 14:27:10 Duration: 4s424ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4603686)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:28:46 Duration: 4s356ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4686290, 4686286)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 16:00:29 Duration: 4s333ms

7

493ms

5s288ms

626ms

269,801

Details

1d22h58m43s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 22	00	7,208	1h7m3s	558ms
	01	9,306	1h26m35s	558ms
	02	7,842	1h12m49s	557ms
	03	10,449	1h37m36s	560ms
	04	5,833	53m22s	549ms
	05	4,907	45m20s	554ms
	06	4,273	38m36s	542ms
	07	2,794	25m17s	542ms
	08	5,959	53m59s	543ms
	09	13,622	2h15m	594ms
	10	18,171	3h11m48s	633ms
	11	16,298	2h52m26s	634ms
	12	16,443	2h50m18s	621ms
	13	11,814	1h57m19s	595ms
	14	14,878	2h51m10s	690ms
	15	29,420	6h1m58s	738ms
	16	24,412	4h30m40s	665ms
	17	9,616	1h37m13s	606ms
	18	13,355	2h21m32s	635ms
	19	14,446	2h31m23s	628ms
	20	15,470	2h44m25s	637ms
	21	9,695	1h37m24s	602ms
	22	3,590	35m19s	590ms

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

Date: 2025-01-22 15:53:19 Duration: 5s288ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4685050)) AND (("shipping_track"."id" not in (38771477, 38771477)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:28:32 Duration: 5s59ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4685019)) AND (("shipping_track"."id" not in (38771218, 38771218)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-22 14:27:16 Duration: 4s716ms

8

176ms

2s309ms

317ms

24,676

Details

2h10m34s

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
Jan 22	07	273	1m12s	264ms
	08	1,539	6m46s	264ms
	09	3,100	16m11s	313ms
	10	1,878	9m41s	309ms
	11	2,984	15m8s	304ms
	12	2,493	12m18s	296ms
	13	2,352	12m12s	311ms
	14	3,971	22m10s	334ms
	15	3,756	21m52s	349ms
	16	2,296	12m47s	334ms
	17	34	12s323ms	362ms

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

Date: 2025-01-22 15:53:00 Duration: 2s309ms
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" = '9972473')))) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:52:52 Duration: 2s94ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9723338')))) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:59:00 Duration: 1s963ms

9

15ms

3s287ms

293ms

2,524

Details

12m19s

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

Day	Hour	Count	Duration	Avg duration
Jan 22	00	6	1s569ms	261ms
	02	3	854ms	284ms
	05	1	130ms	130ms
	06	1	394ms	394ms
	07	1	98ms	98ms
	08	39	6s360ms	163ms
	09	118	23s543ms	199ms
	10	182	48s498ms	266ms
	11	260	1m15s	291ms
	12	339	1m34s	277ms
	13	367	1m34s	256ms
	14	309	1m49s	354ms
	15	244	1m33s	384ms
	16	199	1m6s	335ms
	17	145	37s366ms	257ms
	18	68	21s883ms	321ms
	19	91	30s7ms	329ms
	20	58	18s996ms	327ms
	21	68	12s222ms	179ms
	22	25	3s728ms	149ms

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 (68)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-22 15:09:51 Duration: 3s287ms
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 (113)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (113))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-22 14:28:19 Duration: 3s86ms
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 (127)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (127))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-01-22 14:26:54 Duration: 3s8ms

10

200ms

1s888ms

259ms

18,342

Details

1h19m21s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 22	00	805	3m23s	252ms
	01	801	3m23s	253ms
	02	1,104	4m42s	255ms
	03	1,106	4m44s	256ms
	04	588	2m29s	254ms
	05	906	3m44s	248ms
	06	262	1m4s	245ms
	07	273	1m6s	244ms
	09	55	14s640ms	266ms
	10	152	44s822ms	294ms
	11	110	32s626ms	296ms
	12	150	43s231ms	288ms
	13	79	22s681ms	287ms
	14	159	57s926ms	364ms
	15	673	3m31s	313ms
	16	1,180	5m50s	296ms
	17	973	4m5s	252ms
	18	2,101	8m48s	251ms
	19	1,777	7m29s	253ms
	20	3,495	14m51s	255ms
	21	1,432	5m50s	244ms
	22	161	39s745ms	246ms

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

Date: 2025-01-22 14:26:46 Duration: 1s888ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '42354')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

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

Date: 2025-01-22 14:27:17 Duration: 844ms

11

95ms

881ms

243ms

57,639

Details

3h53m31s

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
Jan 22	00	2,578	8m49s	205ms
	01	2,858	10m29s	220ms
	02	2,512	10m10s	243ms
	03	2,330	9m15s	238ms
	04	1,192	4m31s	228ms
	05	1,794	6m34s	219ms
	06	512	1m53s	222ms
	07	538	1m55s	215ms
	09	114	19s818ms	173ms
	10	328	1m15s	230ms
	11	324	1m40s	308ms
	12	428	1m58s	277ms
	13	314	1m15s	240ms
	14	735	3m47s	310ms
	15	1,903	9m7s	287ms
	16	3,249	14m30s	267ms
	17	3,194	12m46s	239ms
	18	7,244	30m7s	249ms
	19	5,619	22m54s	244ms
	20	11,471	46m6s	241ms
	21	6,240	25m33s	245ms
	22	2,162	8m27s	234ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'هانى')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-22 15:50:12 Duration: 881ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-22 15:50:12 Duration: 878ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ايمان')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-22 19:01:30 Duration: 841ms

12

154ms

1s598ms

227ms

134,317

Details

8h28m40s

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
Jan 22	00	1,252	3m56s	188ms
	01	1,665	5m14s	188ms
	02	1,618	5m7s	190ms
	03	2,122	6m45s	191ms
	04	2,097	6m35s	188ms
	05	3,120	9m45s	187ms
	06	2,327	7m14s	186ms
	07	1,465	4m36s	188ms
	08	4,293	13m40s	191ms
	09	8,735	30m8s	207ms
	10	7,131	25m52s	217ms
	11	8,031	29m50s	222ms
	12	7,444	26m29s	213ms
	13	7,125	25m33s	215ms
	14	33,405	2h19m13s	250ms
	15	24,851	1h46m52s	258ms
	16	9,612	36m7s	225ms
	17	502	1m34s	188ms
	18	1,183	3m43s	188ms
	19	4,417	14m14s	193ms
	20	1,389	4m28s	193ms
	21	228	40s440ms	177ms
	22	305	53s745ms	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" = '9599368')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:28:23 Duration: 1s598ms
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" = '9893927')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:29:01 Duration: 1s596ms
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" = '9877746')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:26:58 Duration: 1s538ms

13

156ms

1s431ms

207ms

12,622

Details

43m41s

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
Jan 22	00	295	56s496ms	191ms
	01	107	21s31ms	196ms
	03	269	51s276ms	190ms
	04	6	1s121ms	186ms
	05	480	1m30s	189ms
	06	786	2m27s	187ms
	07	839	2m38s	188ms
	08	1,457	4m33s	187ms
	09	661	2m15s	205ms
	10	1,471	5m15s	214ms
	11	829	3m1s	219ms
	12	976	3m25s	210ms
	13	1,262	4m29s	213ms
	14	1,429	5m38s	236ms
	15	562	2m17s	244ms
	16	393	1m32s	235ms
	17	144	26s32ms	180ms
	18	126	22s700ms	180ms
	19	57	10s96ms	177ms
	20	73	15s993ms	219ms
	21	228	40s498ms	177ms
	22	172	30s625ms	178ms

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" = '24088')) 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-01-22 16:01:40 Duration: 1s431ms
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" = '47297')) 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 (67, 79, 128)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67, 79, 128))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67, 79, 128))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 14:28:31 Duration: 1s363ms
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" = '9781906')) 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 (39, 115)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 15:58:38 Duration: 1s106ms

14

162ms

291ms

203ms

3,479

Details

11m47s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 22	04	435	1m22s	189ms
	05	519	1m37s	188ms
	06	153	28s685ms	187ms
	07	18	3s446ms	191ms
	09	316	1m8s	216ms
	10	1,285	4m32s	212ms
	11	26	6s317ms	242ms
	12	304	1m8s	226ms
	16	3	663ms	221ms
	18	243	45s500ms	187ms
	19	106	19s697ms	185ms
	22	71	12s660ms	178ms

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" = '9480631')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 12:12:47 Duration: 291ms
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" = '9586844')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 12:13:03 Duration: 290ms
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" = '9574318')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-22 12:13:02 Duration: 289ms

15

156ms

249ms

189ms

9,496

Details

30m2s

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
Jan 22	00	958	3m	188ms
	01	1,557	4m54s	188ms
	02	1,618	5m10s	191ms
	03	1,709	5m30s	193ms
	04	1,377	4m20s	188ms
	05	1,888	5m55s	188ms
	06	327	1m	183ms
	22	62	10s595ms	170ms

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

Date: 2025-01-22 03:41:02 Duration: 249ms
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" = '40351')) 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)))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-22 03:37:43 Duration: 230ms

16

119ms

1s174ms

154ms

6,372

Details

16m26s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 22	00	59	7s690ms	130ms
	01	15	1s968ms	131ms
	02	1	133ms	133ms
	05	14	1s821ms	130ms
	06	5	653ms	130ms
	08	30	4s82ms	136ms
	09	425	1m2s	146ms
	10	981	2m34s	157ms
	11	1,213	3m8s	155ms
	12	915	2m19s	152ms
	13	659	1m38s	149ms
	14	405	1m11s	175ms
	15	488	1m32s	189ms
	16	188	30s460ms	162ms
	17	133	18s650ms	140ms
	18	127	17s910ms	141ms
	19	77	11s365ms	147ms
	20	72	10s242ms	142ms
	21	44	5s988ms	136ms
	22	521	1m8s	131ms

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

Date: 2025-01-22 14:27:10 Duration: 1s174ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-22 14:28:39 Duration: 1s145ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-22 14:28:47 Duration: 958ms

17

94ms

729ms

124ms

19,212

Details

39m51s

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
Jan 22	00	67	7s829ms	116ms
	01	13	1s457ms	112ms
	02	55	6s8ms	109ms
	05	42	4s826ms	114ms
	06	39	4s576ms	117ms
	08	174	19s802ms	113ms
	09	1,171	2m20s	120ms
	10	1,508	3m15s	129ms
	11	1,640	3m26s	125ms
	12	3,078	6m26s	125ms
	13	2,607	5m12s	119ms
	14	1,666	3m34s	128ms
	15	1,586	3m53s	147ms
	16	1,536	3m16s	128ms
	17	1,145	2m8s	112ms
	18	1,259	2m24s	115ms
	19	715	1m24s	117ms
	20	296	34s947ms	118ms
	21	429	47s365ms	110ms
	22	186	20s980ms	112ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7965395)) AND (("cash_track"."id" not in (6820805, 6821299, 6821470, 7241408, 7241408)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-22 14:26:31 Duration: 729ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8011707)) AND (("cash_track"."id" not in (7167362, 7176925, 7179113, 7241446, 7241456, 7241456)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-22 14:29:05 Duration: 712ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7757093)) AND (("cash_track"."id" not in (5259821, 5260126, 5260775, 7243100, 7243133, 7243133)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-22 15:13:03 Duration: 628ms

18

45ms

330ms

69ms

44,553

Details

51m22s

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
Jan 22	00	28	1s732ms	61ms
	01	21	1s315ms	62ms
	07	431	26s514ms	61ms
	08	1,848	1m53s	61ms
	09	5,379	5m42s	63ms
	10	3,255	3m49s	70ms
	11	6,331	7m12s	68ms
	12	2,813	3m8s	66ms
	13	3,707	3m57s	64ms
	14	7,312	8m41s	71ms
	15	5,966	7m57s	79ms
	16	5,151	6m4s	70ms
	17	1,920	2m4s	64ms
	18	179	9s938ms	55ms
	19	109	6s150ms	56ms
	20	58	3s427ms	59ms
	21	41	2s150ms	52ms
	22	4	211ms	52ms

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

Date: 2025-01-22 15:22:06 Duration: 330ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4634640) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:59:40 Duration: 319ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2908459) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-22 15:22:47 Duration: 302ms

19

45ms

259ms

62ms

19,324

Details

20m16s

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
Jan 22	07	237	13s503ms	56ms
	08	917	51s648ms	56ms
	09	2,617	2m39s	60ms
	10	1,505	1m37s	64ms
	11	2,514	2m37s	62ms
	12	1,710	1m44s	61ms
	13	1,889	1m53s	60ms
	14	4,145	4m25s	64ms
	15	2,278	2m39s	69ms
	16	1,479	1m32s	62ms
	17	33	1s956ms	59ms

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

Date: 2025-01-22 15:58:27 Duration: 259ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4546159) ORDER BY "collection_policy"."id";

Date: 2025-01-22 14:27:10 Duration: 248ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4604074) ORDER BY "collection_policy"."id";

Date: 2025-01-22 14:26:32 Duration: 227ms

20

41ms

372ms

56ms

148,524

Details

2h18m47s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 22	00	3,897	3m15s	50ms
	01	4,342	3m38s	50ms
	02	2,643	2m13s	50ms
	03	3,131	2m39s	50ms
	04	2,001	1m40s	50ms
	05	1,158	58s415ms	50ms
	06	1,346	1m7s	50ms
	07	1,454	1m13s	50ms
	08	3,131	2m39s	50ms
	09	10,506	9m31s	54ms
	10	12,996	12m31s	57ms
	11	14,504	13m56s	57ms
	12	12,107	11m27s	56ms
	13	9,793	8m55s	54ms
	14	9,896	10m1s	60ms
	15	8,438	9m32s	67ms
	16	9,000	9m2s	60ms
	17	6,170	5m29s	53ms
	18	8,632	7m51s	54ms
	19	7,704	7m4s	55ms
	20	7,979	7m13s	54ms
	21	5,853	5m8s	52ms
	22	1,843	1m36s	52ms

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

Date: 2025-01-22 17:21:54 Duration: 372ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4638056, 4613446, 4581152, 4573045, 4527567)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-22 14:26:00 Duration: 364ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4663703, 4632468, 4625641, 4611664, 4530398)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-22 14:26:25 Duration: 340ms

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

19,065,100 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	10	0.00%
DETAIL	333	0.00%
ERROR	4,568	0.02%
EVENTLOG	1,044	0.01%
FATAL	1,069	0.01%
HINT	6	0.00%
LOG	19,053,471	99.94%
STATEMENT	4,599	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
1069 FATAL entries
4568 ERROR entries
0 WARNING entries
1044 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,441 Max number of times the same event was reported
6,681 Total events found

Rank

Times reported

Error

1

2,441

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 22	00	19
	01	15
	02	7
	03	10
	04	16
	05	5
	06	10
	07	13
	08	53
	09	141
	10	249
	11	303
	12	216
	13	166
	14	276
	15	305
	16	151
	17	94
	18	53
	19	179
	20	55
	21	47
	22	58

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

2,087

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 22	00	17
	01	10
	02	5
	03	8
	04	17
	05	4
	06	8
	07	11
	08	48
	09	128
	10	209
	11	292
	12	206
	13	157
	14	199
	15	213
	16	97
	17	86
	18	53
	19	164
	20	52
	21	46
	22	57

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

612

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 22	04	1
	09	29
	10	51
	11	110
	12	88
	13	42
	14	26
	15	116
	16	45
	17	22
	18	28
	19	28
	20	26

LOG: could not send data to client: Broken pipe

4

612

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 22	04	1
	09	29
	10	51
	11	110
	12	88
	13	42
	14	26
	15	116
	16	45
	17	22
	18	28
	19	28
	20	26

5

311

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 22	00	154
	12	3
	14	154

FATAL: password authentication failed for user "postgres"
FATAL: password authentication failed for user "root"
FATAL: password authentication failed for user "admin"

6

297

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 22	04	1
	09	10
	10	18
	11	82
	12	54
	13	21
	14	12
	15	47
	16	24
	17	10
	18	4
	19	8
	20	6

7

134

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 22	09	1
	10	6
	11	42
	12	20
	13	13
	14	4
	15	23
	16	10
	17	7
	18	3
	19	2
	20	3

8

93

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 22	17	93

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

9

26

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 22	17	26

10

12

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 22	17	12

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

11

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 22	09	2
	10	2
	13	4
	14	2
	17	1

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

12

10

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 22	03	1
	05	1
	11	1
	18	1
	20	6

ERROR: syntax error at or near ")" at character 724
ERROR: syntax error at or near ")" at character 161
ERROR: syntax error at or near ")" at character 300

13

6

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 22	14	5
	15	1

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

14

5

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 22	12	1
	14	1
	18	2
	19	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

4

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 22	07	1
	10	1
	19	1
	20	1

16

4

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 22	07	1
	10	1
	19	1
	20	1

17

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 22	07	1
	10	1
	19	1
	20	1

18

3

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 22	17	3

19

3

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 22	13	2
	14	1

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

20

2

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 22	14	2

ERROR: could not create unique index "bank_deposit_deposite_2_name"

21

2

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 22	17	2

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

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 22	12	1

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

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 22	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables