pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Jan 19 23:47:34 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 45,205,173 log entries in 2m32s
Log start from 2025-01-19 00:00:00 to 2025-01-19 22:45:01

Global Stats

21,293 Number of unique normalized queries
19,396,117 Number of queries
7d17h20m10s Total query duration
2025-01-19 00:00:00 First query
2025-01-19 22:45:01 Last query
6,842 queries/s at 2025-01-19 11:53:12 Query peak

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

6,897 Number of events
23 Number of unique normalized events
2,244 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,396,117 Average queries per session
7d17h20m10s 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,842 queries/s Query Peak
2025-01-19 11:53:12 Date

SELECT Traffic

Key values

4,502 queries/s Query Peak
2025-01-19 11:53:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,608 queries/s Query Peak
2025-01-19 11:53:12 Date

Queries duration

Key values

7d17h20m10s 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 19	00	305,087	0ms	59m57s	31ms	3m17s	4m2s	1h1m34s
	01	336,462	0ms	1h	53ms	3m41s	4m37s	3h46s
	02	238,119	0ms	55m43s	37ms	3m2s	3m55s	56m44s
	03	303,621	0ms	10m5s	61ms	5m19s	6m24s	2h16m32s
	04	252,030	0ms	4s542ms	26ms	3m41s	4m32s	5m9s
	05	161,611	0ms	1s678ms	22ms	2m6s	2m23s	2m52s
	06	164,105	0ms	683ms	21ms	2m40s	2m52s	3m3s
	07	191,847	0ms	892ms	12ms	1m21s	1m32s	1m44s
	08	425,544	0ms	14m16s	44ms	2m39s	2m58s	3h34m22s
	09	1,181,453	0ms	29m57s	52ms	6m41s	1h4m53s	8h57m16s
	10	1,773,052	0ms	18m56s	30ms	9m59s	1h46m14s	4h1m50s
	11	1,876,885	0ms	9m57s	24ms	10m51s	1h28m23s	2h13m21s
	12	1,777,002	0ms	11m57s	30ms	1h15m4s	1h29m14s	2h47m17s
	13	1,666,717	0ms	20m27s	22ms	10m41s	11m52s	3h5m3s
	14	1,354,661	0ms	18m3s	35ms	6m18s	1h17m49s	4h26m50s
	15	1,467,638	0ms	8m59s	24ms	8m59s	33m31s	2h56m36s
	16	1,343,334	0ms	24m21s	25ms	9m55s	12m52s	2h38m38s
	17	1,173,114	0ms	28m29s	57ms	9m37s	2h37m53s	5h40m31s
	18	1,107,632	0ms	23m56s	36ms	9m5s	10m26s	4h17m23s
	19	776,928	0ms	3m31s	20ms	7m29s	9m26s	10m46s
	20	799,611	0ms	2m50s	43ms	16m42s	19m3s	25m27s
	21	511,081	0ms	39m	82ms	8m7s	10m27s	6h54m48s
	22	208,583	0ms	4s374ms	17ms	2m47s	2m59s	4m28s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 19	00	170,186	34ms	2m32s	3m6s	4m2s
	01	186,103	38ms	2m59s	3m31s	4m37s
	02	122,622	45ms	2m16s	2m55s	3m55s
	03	164,740	59ms	3m49s	4m43s	5m18s
	04	131,696	51ms	2m43s	3m41s	4m42s
	05	77,473	47ms	1m35s	2m6s	2m43s
	06	86,592	39ms	1m54s	2m39s	2m58s
	07	103,820	23ms	1m9s	1m21s	1m44s
	08	252,092	16ms	1m49s	2m31s	2m56s
	09	708,914	16ms	5m10s	5m58s	6m40s
	10	1,084,397	18ms	7m38s	8m12s	9m57s
	11	1,151,840	16ms	6m58s	8m15s	9m43s
	12	1,096,662	16ms	6m33s	7m29s	8m38s
	13	1,027,937	20ms	7m39s	9m14s	11m6s
	14	832,048	15ms	4m48s	5m19s	6m17s
	15	888,264	17ms	6m21s	8m2s	9m5s
	16	796,665	25ms	7m34s	8m58s	10m49s
	17	720,540	22ms	6m12s	7m17s	8m29s
	18	700,483	24ms	6m	7m12s	9m37s
	19	474,368	33ms	5m55s	6m43s	9m7s
	20	482,098	68ms	13m14s	15m44s	18m40s
	21	301,599	56ms	7m20s	7m48s	10m27s
	22	118,732	30ms	2m10s	2m46s	4m27s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 19	00	24,305	5,531	233	0	120ms	148ms	206ms	327ms
	01	27,650	6,990	175	0	309ms	178ms	215ms	307ms
	02	20,154	5,242	144	0	131ms	125ms	169ms	246ms
	03	34,946	8,036	134	0	204ms	227ms	292ms	3m7s
	04	24,051	5,427	133	0	0ms	151ms	209ms	277ms
	05	9,880	3,781	141	0	0ms	74ms	99ms	128ms
	06	12,756	3,870	141	0	0ms	88ms	143ms	236ms
	07	7,916	2,772	176	0	0ms	54ms	68ms	99ms
	08	13,644	5,819	364	0	749ms	95ms	135ms	217ms
	09	48,852	16,279	650	0	751ms	355ms	413ms	1h3m20s
	10	78,211	23,407	1,073	0	323ms	512ms	659ms	1h44m57s
	11	74,664	25,421	706	0	264ms	552ms	686ms	1h24m21s
	12	78,092	22,448	742	0	356ms	518ms	663ms	1h24m34s
	13	73,328	23,972	831	0	165ms	478ms	552ms	23s720ms
	14	49,386	17,193	551	1	526ms	313ms	410ms	1h16m25s
	15	54,023	22,346	671	1	261ms	363ms	452ms	31m14s
	16	71,092	26,918	626	0	148ms	481ms	633ms	2m9s
	17	71,145	19,995	807	0	566ms	595ms	964ms	2h33m28s
	18	68,579	17,577	627	0	272ms	461ms	547ms	3m52s
	19	50,872	16,360	727	0	6ms	324ms	465ms	608ms
	20	78,519	30,844	355	0	16ms	680ms	918ms	3m19s
	21	54,113	10,264	287	0	386ms	343ms	397ms	748ms
	22	14,292	3,486	174	0	0ms	113ms	152ms	236ms

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

196,040 buffers Checkpoint Peak
2025-01-19 16:11:22 Date
270.077 seconds Highest write time
0.023 seconds Sync time

Checkpoints Wal files

Key values

77 files Wal files usage Peak
2025-01-19 16:11:22 Date

Checkpoints distance

Key values

2,471.12 Mo Distance Peak
2025-01-19 16:11:22 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 19	00	107,148	3,239.654s	0.039s	3,239.733s
	01	176,191	3,239.561s	0.036s	3,239.645s
	02	104,307	3,239.558s	0.033s	3,239.634s
	03	135,982	3,239.506s	0.037s	3,239.583s
	04	120,490	3,239.629s	0.029s	3,239.705s
	05	88,856	3,025.493s	0.027s	3,025.564s
	06	75,180	3,085.453s	0.026s	3,085.517s
	07	53,531	3,095.502s	0.024s	3,095.558s
	08	94,236	3,122.479s	0.039s	3,122.567s
	09	298,215	3,239.506s	0.045s	3,239.623s
	10	494,837	3,239.505s	0.057s	3,239.651s
	11	477,824	3,239.551s	0.059s	3,239.712s
	12	567,429	3,239.465s	0.052s	3,239.609s
	13	494,706	3,239.521s	0.057s	3,239.668s
	14	392,042	3,239.424s	0.068s	3,239.567s
	15	356,257	3,239.572s	0.049s	3,239.694s
	16	627,420	3,239.433s	0.063s	3,239.594s
	17	338,665	2,889.006s	0.078s	2,889.151s
	18	259,904	3,239.523s	0.044s	3,239.627s
	19	235,088	3,239.586s	0.05s	3,239.691s
	20	240,102	3,239.505s	0.048s	3,239.62s
	21	259,095	3,239.492s	0.043s	3,239.595s
	22	85,388	2,429.645s	0.026s	2,429.701s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 19	00	45	4,136	0.002s	0.012s
	01	72	4,308	0.002s	0.012s
	02	49	3,031	0.002s	0.012s
	03	63	3,165	0.002s	0.012s
	04	58	2,909	0.002s	0.012s
	05	41	1,925	0.002s	0.012s
	06	34	2,282	0.002s	0.012s
	07	21	2,957	0.002s	0.012s
	08	38	3,688	0.006s	0.012s
	09	122	5,053	0.003s	0.012s
	10	216	5,255	0.003s	0.012s
	11	206	5,222	0.003s	0.012s
	12	221	5,438	0.003s	0.012s
	13	210	5,428	0.003s	0.012s
	14	161	5,590	0.019s	0.012s
	15	149	5,783	0.004s	0.012s
	16	233	5,912	0.003s	0.012s
	17	120	5,717	0.018s	0.012s
	18	94	5,599	0.003s	0.012s
	19	83	5,162	0.003s	0.012s
	20	90	4,895	0.003s	0.012s
	21	102	4,750	0.002s	0.012s
	22	30	3,055	0.002s	0.009s

Day	Hour	Avg time (sec)
Jan 19	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 19	00	61,463.25 kB	89,163.67 kB
	01	97,433.75 kB	124,442.58 kB
	02	66,588.58 kB	102,152.25 kB
	03	86,349.17 kB	105,288.33 kB
	04	79,660.67 kB	108,686.33 kB
	05	55,487.50 kB	78,958.00 kB
	06	46,130.33 kB	73,003.25 kB
	07	29,750.08 kB	53,045.42 kB
	08	51,297.42 kB	79,072.08 kB
	09	168,102.27 kB	202,353.64 kB
	10	294,665.58 kB	330,492.50 kB
	11	280,141.27 kB	330,873.73 kB
	12	300,847.60 kB	354,705.90 kB
	13	286,293.75 kB	383,824.00 kB
	14	227,046.09 kB	310,676.36 kB
	15	203,241.92 kB	247,060.67 kB
	16	317,742.08 kB	814,790.42 kB
	17	164,339.08 kB	320,103.33 kB
	18	127,541.83 kB	185,832.42 kB
	19	113,202.33 kB	149,366.33 kB
	20	123,444.67 kB	152,162.00 kB
	21	139,073.00 kB	190,425.42 kB
	22	55,459.67 kB	137,202.67 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 19	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 19	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,679,871 Total read queries
5,267,219 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,679,871	60.22%
INSERT	1,040,470	5.36%
UPDATE	323,978	1.67%
DELETE	10,468	0.05%
COPY FROM	2	0.00%
COPY TO	0	0.00%
CTE	35,612	0.18%
DDL	2,745	0.01%
TCL	3,853,944	19.87%
CURSOR	0	0.00%
OTHERS	2,449,027	12.63%

Queries by database

Key values

unknown Main database
19,396,117 Requests
7d17h20m10s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	19,396,117	7d17h20m10s
	copy from	2	0ms
	cte	35,612	8s118ms
	ddl	2,745	416ms
	delete	10,468	7s536ms
	insert	1,040,470	48m1s
	others	2,449,027	1m53s
	select	11,679,871	3d8h46m
	tcl	3,853,944	2m42s
	update	323,978	4d7h41m15s

Queries by user

Key values

unknown Main user
19,396,117 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	19,396,117	7d17h20m10s
	copy from	2	0ms
	cte	35,612	8s118ms
	ddl	2,745	416ms
	delete	10,468	7s536ms
	insert	1,040,470	48m1s
	others	2,449,027	1m53s
	select	11,679,871	3d8h46m
	tcl	3,853,944	2m42s
	update	323,978	4d7h41m15s

Duration by user

Key values

7d17h20m10s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	19,396,117	7d17h20m10s
	copy from	2	0ms
	cte	35,612	8s118ms
	ddl	2,745	416ms
	delete	10,468	7s536ms
	insert	1,040,470	48m1s
	others	2,449,027	1m53s
	select	11,679,871	3d8h46m
	tcl	3,853,944	2m42s
	update	323,978	4d7h41m15s

Queries by host

Key values

unknown Main host
19,396,117 Requests
7d17h20m10s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	19,396,117	7d17h20m10s
	copy from	2	0ms
	cte	35,612	8s118ms
	ddl	2,745	416ms
	delete	10,468	7s536ms
	insert	1,040,470	48m1s
	others	2,449,027	1m53s
	select	11,679,871	3d8h46m
	tcl	3,853,944	2m42s
	update	323,978	4d7h41m15s

Queries by application

Key values

unknown Main application
19,396,117 Requests
7d17h20m10s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	19,396,117	7d17h20m10s
	copy from	2	0ms
	cte	35,612	8s118ms
	ddl	2,745	416ms
	delete	10,468	7s536ms
	insert	1,040,470	48m1s
	others	2,449,027	1m53s
	select	11,679,871	3d8h46m
	tcl	3,853,944	2m42s
	update	323,978	4d7h41m15s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-19 20:16:05 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

18,057,240 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	18,057,240	93.10%
1-5ms	335,030	1.73%
5-10ms	16,253	0.08%
10-25ms	51,839	0.27%
25-50ms	144,251	0.74%
50-100ms	117,010	0.60%
100-500ms	362,021	1.87%
500-1000ms	307,543	1.59%
1000-10000ms	3,822	0.02%
> 10000ms	1,108	0.01%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:28:47.956262', exp_date = '2025-01-19 00:13:47.956266', logged_in = 'TRUE' where id = 847; [ Date: 2025-01-19 01:28:48 ]
2	1h	update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:28:47.956098', exp_date = '2025-01-19 00:13:47.956102', logged_in = 'TRUE' where id = 847; [ Date: 2025-01-19 01:28:48 ]
3	59m57s	UPDATE "res_users" SET "exp_date" = '2025-01-18 23:31:16.135004', "last_update" = '2025-01-18 22:46:16.135027', "write_date" = '2025-01-18 22:46:15.742928', "write_uid" = 1434 WHERE id IN (1434); [ Date: 2025-01-19 00:46:13 ]
4	59m15s	update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:29:32.685918', exp_date = '2025-01-19 00:14:32.685922', logged_in = 'TRUE' where id = 847; [ Date: 2025-01-19 01:28:48 ]
5	55m43s	UPDATE "res_users" SET "exp_date" = '2025-01-19 01:17:21.697922', "last_update" = '2025-01-19 00:32:21.697944', "sid" = '8a084105fd7e5cebd952c1fea51a284e3fd68f33', "write_date" = '2025-01-19 00:32:21.373363', "write_uid" = 1434 WHERE id IN (1434); [ Date: 2025-01-19 02:28:05 ]
6	39m	update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-19 20:11:19.775257', exp_date = '2025-01-19 20:56:19.775262', logged_in = 'TRUE' where id = 870; [ Date: 2025-01-19 21:50:20 ]
7	39m	update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-19 20:11:19.774460', exp_date = '2025-01-19 20:56:19.774463', logged_in = 'TRUE' where id = 870; [ Date: 2025-01-19 21:50:20 ]
8	38m39s	update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-19 20:11:40.852567', exp_date = '2025-01-19 20:56:40.852571', logged_in = 'TRUE' where id = 870; [ Date: 2025-01-19 21:50:20 ]
9	29m57s	update res_users set sid = 'c7aedccc751e269bab3594e5aa6af72c002a8a84', last_update = '2025-01-19 08:00:23.973297', exp_date = '2025-01-19 08:45:23.973300', logged_in = 'TRUE' where id = 1080; [ Date: 2025-01-19 09:30:21 ]
10	29m56s	update res_users set sid = '640dfb3f6ab737acd154e42c901c187e26b17032', last_update = '2025-01-19 08:00:24.203510', exp_date = '2025-01-19 08:45:24.203511', logged_in = 'TRUE' where id = 1251; [ Date: 2025-01-19 09:30:21 ]
11	29m56s	update res_users set sid = 'c7aedccc751e269bab3594e5aa6af72c002a8a84', last_update = '2025-01-19 08:00:24.377607', exp_date = '2025-01-19 08:45:24.377609', logged_in = 'TRUE' where id = 1080; [ Date: 2025-01-19 09:30:21 ]
12	29m56s	update res_users set sid = 'c7aedccc751e269bab3594e5aa6af72c002a8a84', last_update = '2025-01-19 08:00:24.387301', exp_date = '2025-01-19 08:45:24.387304', logged_in = 'TRUE' where id = 1080; [ Date: 2025-01-19 09:30:21 ]
13	29m56s	update res_users set sid = 'c7aedccc751e269bab3594e5aa6af72c002a8a84', last_update = '2025-01-19 08:00:24.979315', exp_date = '2025-01-19 08:45:24.979317', logged_in = 'TRUE' where id = 1080; [ Date: 2025-01-19 09:30:21 ]
14	29m56s	update res_users set sid = 'c7aedccc751e269bab3594e5aa6af72c002a8a84', last_update = '2025-01-19 08:00:24.981837', exp_date = '2025-01-19 08:45:24.981839', logged_in = 'TRUE' where id = 1080; [ Date: 2025-01-19 09:30:21 ]
15	29m51s	update res_users set sid = '183695f2692c36b830dd56a867a1a89c5087bb2a', last_update = '2025-01-19 08:00:29.403095', exp_date = '2025-01-19 08:45:29.403098', logged_in = 'TRUE' where id = 1251; [ Date: 2025-01-19 09:30:21 ]
16	29m51s	update res_users set sid = '640dfb3f6ab737acd154e42c901c187e26b17032', last_update = '2025-01-19 08:00:29.859752', exp_date = '2025-01-19 08:45:29.859754', logged_in = 'TRUE' where id = 1251; [ Date: 2025-01-19 09:30:21 ]
17	29m50s	update res_users set sid = '640dfb3f6ab737acd154e42c901c187e26b17032', last_update = '2025-01-19 08:00:30.279469', exp_date = '2025-01-19 08:45:30.279470', logged_in = 'TRUE' where id = 1251; [ Date: 2025-01-19 09:30:21 ]
18	29m45s	update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-19 20:20:34.961833', exp_date = '2025-01-19 21:05:34.961839', logged_in = 'TRUE' where id = 870; [ Date: 2025-01-19 21:50:20 ]
19	29m36s	update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-19 20:20:43.969296', exp_date = '2025-01-19 21:05:43.969302', logged_in = 'TRUE' where id = 870; [ Date: 2025-01-19 21:50:20 ]
20	29m29s	update res_users set sid = '183695f2692c36b830dd56a867a1a89c5087bb2a', last_update = '2025-01-19 08:00:51.432500', exp_date = '2025-01-19 08:45:51.432502', logged_in = 'TRUE' where id = 1251; [ Date: 2025-01-19 09:30:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d2h25m56s

69,270

Details

0ms

1h

5s115ms

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 19	00	872	208ms	0ms
	01	1,232	2h59m15s	8s730ms
	02	952	217ms	0ms
	03	1,257	2h5m59s	6s13ms
	04	1,019	254ms	0ms
	05	543	119ms	0ms
	06	358	84ms	0ms
	07	537	119ms	0ms
	08	1,413	4h7m25s	10s506ms
	09	4,718	13h43m38s	10s474ms
	10	7,367	9h13m29s	4s507ms
	11	7,477	7h10m45s	3s456ms
	12	6,794	9h42m54s	5s147ms
	13	6,525	4h28m11s	2s466ms
	14	5,057	9h27m18s	6s731ms
	15	5,946	5h19m3s	3s219ms
	16	4,457	4h2m38s	3s266ms
	17	3,769	12h59m59s	12s416ms
	18	3,169	6h16m34s	7s129ms
	19	2,047	6m51s	200ms
	20	1,853	22m38s	733ms
	21	1,327	6h19m9s	17s143ms
	22	581	133ms	0ms

update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:28:47.956262', exp_date = '2025-01-19 00:13:47.956266', logged_in = 'TRUE' where id = 847;

Date: 2025-01-19 01:28:48 Duration: 1h
update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:28:47.956098', exp_date = '2025-01-19 00:13:47.956102', logged_in = 'TRUE' where id = 847;

Date: 2025-01-19 01:28:48 Duration: 1h
update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:29:32.685918', exp_date = '2025-01-19 00:14:32.685922', logged_in = 'TRUE' where id = 847;

Date: 2025-01-19 01:28:48 Duration: 59m15s

2

1d18h56m12s

264,730

Details

380ms

5s441ms

583ms

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 19	00	7,124	1h2m58s	530ms
	01	9,218	1h21m22s	529ms
	02	6,595	58m5s	528ms
	03	11,294	1h41m23s	538ms
	04	9,206	1h20m51s	527ms
	05	5,082	43m5s	508ms
	06	3,646	32m38s	537ms
	07	2,982	25m18s	509ms
	08	3,776	32m11s	511ms
	09	10,536	1h36m50s	551ms
	10	20,465	3h21m26s	590ms
	11	16,337	2h41m3s	591ms
	12	17,566	2h50m11s	581ms
	13	16,734	2h46m53s	598ms
	14	9,084	1h23m47s	553ms
	15	11,897	1h55m22s	581ms
	16	16,378	2h43m55s	600ms
	17	14,833	2h25m36s	588ms
	18	14,552	2h27m47s	609ms
	19	13,237	2h9m31s	587ms
	20	20,247	3h55m57s	699ms
	21	20,301	3h25m40s	607ms
	22	3,640	34m8s	562ms

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

Date: 2025-01-19 20:16:14 Duration: 5s441ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4612542)) AND (("shipping_track"."id" not in (38089162, 38089162)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:15:39 Duration: 5s34ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4612554)) AND (("shipping_track"."id" not in (38089268, 38089268)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:15:57 Duration: 5s18ms

3

9h54m27s

153,782

Details

160ms

1s576ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,065	3m17s	185ms
	01	2,164	6m41s	185ms
	02	2,335	7m14s	186ms
	03	2,774	8m39s	187ms
	04	2,009	6m13s	186ms
	05	2,695	8m15s	184ms
	06	1,756	5m22s	183ms
	07	1,180	3m39s	185ms
	08	3,318	10m20s	187ms
	09	7,248	24m15s	200ms
	10	6,030	21m41s	215ms
	11	10,803	38m37s	214ms
	12	6,528	22m55s	210ms
	13	10,942	40m36s	222ms
	14	6,223	20m44s	199ms
	15	13,741	48m30s	211ms
	16	16,161	57m37s	213ms
	17	4,165	15m17s	220ms
	18	637	2m26s	230ms
	19	9,828	37m35s	229ms
	20	38,535	3h10m17s	296ms
	21	3,293	12m53s	234ms
	22	352	1m15s	215ms

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

Date: 2025-01-19 20:22:50 Duration: 1s576ms
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" = '9852863')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-19 20:23:02 Duration: 1s555ms
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" = '9900966')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-19 20:15:47 Duration: 1s528ms

4

7h17m56s

43,801

Details

482ms

4s904ms

599ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 19	00	314	2m52s	548ms
	01	293	2m44s	561ms
	02	164	1m34s	579ms
	03	161	1m41s	632ms
	04	140	1m25s	607ms
	05	101	59s875ms	592ms
	06	103	56s620ms	549ms
	07	384	3m24s	533ms
	08	1,134	9m50s	520ms
	09	2,607	24m31s	564ms
	10	5,484	55m47s	610ms
	11	3,718	37m58s	612ms
	12	4,043	40m41s	603ms
	13	5,013	51m44s	619ms
	14	2,810	26m24s	563ms
	15	3,062	29m43s	582ms
	16	2,883	29m31s	614ms
	17	3,187	31m9s	586ms
	18	2,893	28m20s	587ms
	19	2,435	23m46s	585ms
	20	1,582	20m4s	761ms
	21	766	7m55s	621ms
	22	524	4m47s	549ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4566811, 4561796, 4558758, 4543715, 4543179, 4519822, 4506903)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:22:43 Duration: 4s904ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4612127, 4612122, 4612116, 4612110, 4612105, 4612099, 4612093, 4612085, 4612080, 4612073, 4612068, 4612062, 4612056, 4612050, 4612043, 4612037, 4612031, 4612025, 4612020, 4612015, 4612009, 4612003, 4611997, 4611990, 4611985, 4611979, 4611973, 4611967, 4611961, 4611955, 4611949, 4611943, 4611937, 4611931, 4611925, 4611919, 4611913, 4611907, 4611902, 4611896, 4611890, 4611884, 4611878, 4611872, 4611866, 4611861, 4611856, 4611852, 4611849, 4611846)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:33:25 Duration: 4s347ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4611087, 4609033)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:18:16 Duration: 4s143ms

5

3h49m57s

56,335

Details

97ms

926ms

244ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 19	00	2,676	10m18s	231ms
	01	2,788	10m5s	217ms
	02	2,144	7m17s	204ms
	03	4,252	16m55s	238ms
	04	2,064	8m1s	233ms
	06	2,012	7m27s	222ms
	07	148	34s410ms	232ms
	08	46	10s826ms	235ms
	09	702	2m34s	220ms
	10	58	15s63ms	259ms
	11	358	1m21s	228ms
	12	316	1m28s	278ms
	13	566	2m21s	249ms
	14	1,074	4m13s	235ms
	15	1,160	5m11s	268ms
	16	3,476	15m16s	263ms
	17	4,469	19m13s	258ms
	18	9,499	37m32s	237ms
	19	4,150	16m34s	239ms
	20	6,989	32m3s	275ms
	21	5,588	23m25s	251ms
	22	1,800	7m34s	252ms

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-19 20:25:20 Duration: 926ms
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-19 17:35:12 Duration: 918ms
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-19 17:35:12 Duration: 917ms

6

2h37m22s

281

Details

0ms

55m43s

33s604ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 19	00	2	0ms	0ms
	01	3	1ms	0ms
	02	3	55m43s	18m34s
	03	2	3ms	1ms
	05	1	1ms	1ms
	06	3	3ms	1ms
	07	3	0ms	0ms
	08	12	6ms	0ms
	09	32	42ms	1ms
	10	28	44ms	1ms
	11	23	2m56s	7s672ms
	12	33	18m36s	33s832ms
	13	20	1m41s	5s56ms
	14	23	20m43s	54s76ms
	15	19	16m17s	51s454ms
	16	15	24ms	1ms
	17	15	6m23s	25s555ms
	18	15	13ms	0ms
	19	9	9ms	1ms
	20	9	16ms	1ms
	21	8	34m59s	4m22s
	22	3	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-19 01:17:21.697922', "last_update" = '2025-01-19 00:32:21.697944', "sid" = '8a084105fd7e5cebd952c1fea51a284e3fd68f33', "write_date" = '2025-01-19 00:32:21.373363', "write_uid" = 1434 WHERE id IN (1434);

Date: 2025-01-19 02:28:05 Duration: 55m43s
UPDATE "res_users" SET "exp_date" = '2025-01-19 13:29:17.944299', "last_update" = '2025-01-19 12:44:17.944322', "sid" = 'b56b838c615f9373281c5949b3568e1dbb77ff0e', "write_date" = '2025-01-19 12:44:17.599000', "write_uid" = 841 WHERE id IN (841);

Date: 2025-01-19 14:02:21 Duration: 18m3s
UPDATE "res_users" SET "exp_date" = '2025-01-19 21:17:57.896834', "last_update" = '2025-01-19 20:32:57.896855', "sid" = 'fcc1ffcb54e70e61216377dbc1cf3818dc229f13', "write_date" = '2025-01-19 20:32:57.577207', "write_uid" = 1 WHERE id IN (870);

Date: 2025-01-19 21:50:20 Duration: 17m22s

7

2h35m22s

10,037

Details

36ms

1s965ms

928ms

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 19	00	465	6m47s	876ms
	01	230	3m22s	882ms
	02	509	7m26s	877ms
	03	1,032	15m7s	879ms
	07	4	3s538ms	884ms
	08	5	3s862ms	772ms
	09	60	55s915ms	931ms
	11	6	6s401ms	1s66ms
	12	81	1m24s	1s45ms
	13	16	15s897ms	993ms
	14	371	5m41s	920ms
	15	210	3m24s	972ms
	16	466	7m37s	982ms
	17	540	8m4s	897ms
	18	1,919	30m	938ms
	19	1,114	16m21s	881ms
	20	1,777	30m37s	1s33ms
	21	883	12m37s	858ms
	22	349	5m22s	923ms

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

Date: 2025-01-19 20:16:18 Duration: 1s965ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9847449')) 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 (11))))))) 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 (11)))))) 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 (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-19 20:34:00 Duration: 1s957ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9910101')) 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 (11))))))) 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 (11)))))) 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 (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-19 20:16:01 Duration: 1s925ms

8

1h52m41s

22,546

Details

184ms

677ms

299ms

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 19	07	125	31s149ms	249ms
	08	838	3m39s	262ms
	09	2,100	9m37s	275ms
	10	973	5m17s	325ms
	11	3,751	18m23s	294ms
	12	1,792	9m6s	304ms
	13	3,763	19m40s	313ms
	14	2,548	11m47s	277ms
	15	2,667	13m32s	304ms
	16	1,838	9m55s	324ms
	17	817	4m7s	303ms
	18	182	54s663ms	300ms
	19	927	4m47s	310ms
	20	225	1m17s	344ms

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

Date: 2025-01-19 10:11:59 Duration: 677ms
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" = '488930')))) ORDER BY "collection_policy"."id";

Date: 2025-01-19 10:24:23 Duration: 673ms
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" = '9701449')))) ORDER BY "collection_policy"."id";

Date: 2025-01-19 10:24:23 Duration: 635ms

9

1h50m46s

147,520

Details

33ms

292ms

45ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 19	00	3,084	2m14s	43ms
	01	2,845	2m5s	44ms
	02	2,366	1m44s	44ms
	03	4,120	3m3s	44ms
	04	3,261	2m24s	44ms
	05	817	35s924ms	43ms
	06	694	27s858ms	40ms
	07	1,487	59s582ms	40ms
	08	2,160	1m26s	40ms
	09	7,678	5m25s	42ms
	10	13,339	10m7s	45ms
	11	13,565	10m16s	45ms
	12	14,361	10m39s	44ms
	13	14,445	11m	45ms
	14	7,653	5m23s	42ms
	15	7,696	5m37s	43ms
	16	7,144	5m27s	45ms
	17	8,329	6m6s	44ms
	18	8,517	6m18s	44ms
	19	7,531	5m34s	44ms
	20	9,497	8m36s	54ms
	21	4,918	3m44s	45ms
	22	2,013	1m24s	42ms

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

Date: 2025-01-19 20:17:48 Duration: 292ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4587747)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-19 20:33:47 Duration: 266ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4534038)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-19 20:13:04 Duration: 262ms

10

1h27m25s

18,475

Details

208ms

2s60ms

283ms

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 19	00	888	3m47s	255ms
	01	1,182	5m6s	259ms
	02	578	2m23s	248ms
	03	1,109	4m42s	254ms
	04	1,043	4m27s	256ms
	06	1,010	4m14s	252ms
	07	71	17s475ms	246ms
	08	20	5s63ms	253ms
	09	303	1m13s	242ms
	10	31	9s704ms	313ms
	11	181	52s169ms	288ms
	12	80	25s479ms	318ms
	13	268	1m12s	271ms
	14	183	50s50ms	273ms
	15	389	1m49s	280ms
	16	1,305	6m4s	279ms
	17	1,715	8m9s	285ms
	18	2,871	13m48s	288ms
	19	977	4m49s	296ms
	20	1,757	10m41s	364ms
	21	1,949	9m36s	295ms
	22	565	2m39s	281ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9953684')) 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-19 20:15:41 Duration: 2s60ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9955328')) 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-19 20:17:50 Duration: 2s56ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9945295')) 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-19 20:19:09 Duration: 2s6ms

11

1h18m57s

34

Details

0ms

59m57s

2m19s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1	59m57s	59m57s
	02	1	0ms	0ms
	03	1	10m5s	10m5s
	08	2	0ms	0ms
	09	5	6ms	1ms
	10	2	3ms	1ms
	11	6	8m54s	1m29s
	12	2	3ms	1ms
	13	1	1ms	1ms
	14	5	6ms	1ms
	16	2	3ms	1ms
	18	1	1ms	1ms
	19	1	0ms	0ms
	20	3	5ms	1ms
	21	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-18 23:31:16.135004', "last_update" = '2025-01-18 22:46:16.135027', "write_date" = '2025-01-18 22:46:15.742928', "write_uid" = 1434 WHERE id IN (1434);

Date: 2025-01-19 00:46:13 Duration: 59m57s
UPDATE "res_users" SET "exp_date" = '2025-01-19 03:07:15.254945', "last_update" = '2025-01-19 02:22:15.254968', "write_date" = '2025-01-19 02:22:14.930995', "write_uid" = 1 WHERE id IN (847);

Date: 2025-01-19 03:32:20 Duration: 10m5s
UPDATE "res_users" SET "exp_date" = '2025-01-19 11:03:26.344005', "last_update" = '2025-01-19 10:18:26.344034', "write_date" = '2025-01-19 10:18:25.914984', "write_uid" = 959 WHERE id IN (959);

Date: 2025-01-19 11:27:21 Duration: 8m54s

12

1h5m43s

59,587

Details

41ms

320ms

66ms

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 19	00	42	2s624ms	62ms
	01	115	7s150ms	62ms
	02	28	1s787ms	63ms
	06	3	190ms	63ms
	07	338	20s824ms	61ms
	08	1,061	1m5s	61ms
	09	4,308	4m35s	63ms
	10	3,274	3m47s	69ms
	11	4,310	5m3s	70ms
	12	5,684	6m23s	67ms
	13	12,391	14m4s	68ms
	14	5,387	5m47s	64ms
	15	4,839	5m25s	67ms
	16	5,000	5m57s	71ms
	17	4,069	3m59s	58ms
	18	1,108	1m1s	55ms
	19	2,724	2m21s	52ms
	20	4,877	5m36s	69ms
	21	28	1s615ms	57ms
	22	1	51ms	51ms

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

Date: 2025-01-19 20:23:44 Duration: 320ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4554155) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-19 20:33:31 Duration: 319ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4556974) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-19 20:23:44 Duration: 309ms

13

44m29s

13,219

Details

166ms

342ms

201ms

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 19	00	32	6s84ms	190ms
	01	183	33s812ms	184ms
	02	122	22s399ms	183ms
	03	260	48s397ms	186ms
	04	101	18s773ms	185ms
	05	470	1m27s	185ms
	06	793	2m26s	185ms
	07	813	2m31s	185ms
	08	980	3m1s	184ms
	09	2,213	7m25s	201ms
	10	1,027	3m45s	219ms
	11	2,096	7m21s	210ms
	12	1,062	3m38s	205ms
	13	969	3m29s	215ms
	14	816	2m41s	197ms
	15	464	1m32s	200ms
	16	421	1m28s	210ms
	17	165	38s163ms	231ms
	19	95	20s840ms	219ms
	20	2	462ms	231ms
	21	39	9s773ms	250ms
	22	96	21s69ms	219ms

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" = '9791121')) 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-19 11:08:45 Duration: 342ms
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" = '9813296')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) 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-19 16:09:08 Duration: 335ms
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" = '9943155')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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-19 10:03:23 Duration: 335ms

14

42m20s

114

Details

0ms

19m15s

22s282ms

insert into res_groups_users_rel (uid, gid) values (?, ?) on conflict do nothing;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 19	13	13	4ms	0ms
	14	7	2ms	0ms
	16	1	0ms	0ms
	17	7	42m20s	6m2s
	18	68	17ms	0ms
	19	18	5ms	0ms

INSERT INTO res_groups_users_rel (uid, gid) VALUES (1219, 325) ON CONFLICT DO NOTHING;

Date: 2025-01-19 17:05:20 Duration: 19m15s
INSERT INTO res_groups_users_rel (uid, gid) VALUES (1219, 325) ON CONFLICT DO NOTHING;

Date: 2025-01-19 17:05:20 Duration: 18m40s
INSERT INTO res_groups_users_rel (uid, gid) VALUES (1219, 325) ON CONFLICT DO NOTHING;

Date: 2025-01-19 17:05:20 Duration: 4m24s

15

39m36s

120

Details

0ms

20m32s

19s803ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 19	13	18	4ms	0ms
	14	9	6ms	0ms
	16	1	0ms	0ms
	17	6	22m27s	3m44s
	18	67	17m9s	15s363ms
	19	19	5ms	0ms

UPDATE "res_users" SET "write_date" = '2025-01-19 15:44:47.935605', "write_uid" = 2 WHERE id IN (1219);

Date: 2025-01-19 17:05:20 Duration: 20m32s
UPDATE "res_users" SET "write_date" = '2025-01-19 17:40:11.118770', "write_uid" = 2 WHERE id IN (855);

Date: 2025-01-19 18:57:20 Duration: 17m9s
UPDATE "res_users" SET "write_date" = '2025-01-19 16:03:26.231085', "write_uid" = 2 WHERE id IN (1219);

Date: 2025-01-19 17:05:20 Duration: 1m54s

16

36m46s

18,330

Details

93ms

571ms

120ms

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

Day	Hour	Count	Duration	Avg duration
Jan 19	00	94	10s992ms	116ms
	01	38	4s457ms	117ms
	03	30	3s188ms	106ms
	04	3	310ms	103ms
	07	38	4s396ms	115ms
	08	258	29s91ms	112ms
	09	1,304	2m30s	115ms
	10	1,852	3m51s	124ms
	11	1,425	2m57s	124ms
	12	2,637	5m18s	120ms
	13	2,065	4m16s	124ms
	14	1,590	3m2s	115ms
	15	1,360	2m40s	117ms
	16	2,110	4m18s	122ms
	17	1,744	3m19s	114ms
	18	594	1m10s	119ms
	19	626	1m15s	120ms
	20	219	34s87ms	155ms
	21	277	31s969ms	115ms
	22	66	7s492ms	113ms

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

Date: 2025-01-19 20:21:08 Duration: 571ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8007934)) AND (("cash_track"."id" not in (7139391)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-19 20:15:54 Duration: 337ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8008014)) AND (("cash_track"."id" not in (7139532)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-19 20:22:57 Duration: 295ms

17

34m7s

10,907

Details

152ms

233ms

187ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,009	3m4s	183ms
	01	1,965	6m7s	186ms
	02	1,796	5m36s	187ms
	03	2,405	7m40s	191ms
	04	1,616	5m9s	191ms
	05	1,709	5m14s	184ms
	06	396	1m13s	184ms
	22	11	1s931ms	175ms

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" = '9480912')) 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-19 04:18:02 Duration: 233ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9723973')) 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, 36, 37, 40, 41, 42, 43, 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-19 03:44:25 Duration: 232ms
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 (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-19 03:42:27 Duration: 231ms

18

22m17s

22,213

Details

37ms

130ms

60ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 19	07	126	7s116ms	56ms
	08	428	23s997ms	56ms
	09	1,872	1m50s	59ms
	10	1,060	1m7s	63ms
	11	2,039	2m9s	63ms
	12	2,158	2m14s	62ms
	13	4,308	4m27s	62ms
	14	2,540	2m30s	59ms
	15	2,837	2m52s	60ms
	16	2,043	2m11s	64ms
	17	1,496	1m19s	52ms
	18	341	16s882ms	49ms
	19	741	34s454ms	46ms
	20	224	11s541ms	51ms

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

Date: 2025-01-19 16:10:31 Duration: 130ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4456977) ORDER BY "collection_policy"."id";

Date: 2025-01-19 16:18:43 Duration: 125ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4316588) ORDER BY "collection_policy"."id";

Date: 2025-01-19 16:18:43 Duration: 112ms

19

21m4s

5,962

Details

163ms

330ms

212ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 19	06	348	1m4s	183ms
	07	117	21s948ms	187ms
	09	490	1m42s	208ms
	10	1,632	5m54s	216ms
	11	634	2m13s	210ms
	12	283	59s821ms	211ms
	13	278	1m2s	223ms
	14	143	28s434ms	198ms
	15	189	37s856ms	200ms
	16	647	2m18s	214ms
	17	758	2m39s	210ms
	18	221	51s662ms	233ms
	19	27	6s492ms	240ms
	21	124	28s423ms	229ms
	22	71	15s139ms	213ms

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

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

Date: 2025-01-19 10:57:33 Duration: 312ms
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" = '9851819')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) 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-19 21:20:53 Duration: 305ms

20

16m45s

3,560

Details

176ms

427ms

282ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 19	09	112	30s352ms	271ms
	10	98	28s165ms	287ms
	11	233	1m6s	286ms
	12	299	1m26s	290ms
	13	753	3m35s	286ms
	14	150	38s580ms	257ms
	15	267	1m10s	264ms
	16	846	4m2s	286ms
	17	539	2m31s	280ms
	18	247	1m10s	286ms
	19	16	4s300ms	268ms

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

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

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

Date: 2025-01-19 13:38:56 Duration: 377ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,447,230

Details

1m53s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 19	00	42,153	1s940ms	0ms
	01	45,057	2s196ms	0ms
	02	36,651	1s694ms	0ms
	03	37,873	1s748ms	0ms
	04	36,130	1s542ms	0ms
	05	28,159	1s155ms	0ms
	06	24,674	1s25ms	0ms
	07	30,029	1s305ms	0ms
	08	59,432	2s583ms	0ms
	09	153,881	7s133ms	0ms
	10	219,935	10s679ms	0ms
	11	235,237	10s585ms	0ms
	12	219,892	9s670ms	0ms
	13	206,881	10s370ms	0ms
	14	176,989	7s633ms	0ms
	15	194,327	9s17ms	0ms
	16	175,401	8s386ms	0ms
	17	139,576	6s54ms	0ms
	18	123,976	5s979ms	0ms
	19	93,118	4s723ms	0ms
	20	81,294	4s480ms	0ms
	21	57,266	2s801ms	0ms
	22	29,299	1s176ms	0ms

DISCARD ALL;

Date: 2025-01-19 15:43:19 Duration: 1ms
DISCARD ALL;

Date: 2025-01-19 20:24:49 Duration: 1ms
DISCARD ALL;

Date: 2025-01-19 21:07:56 Duration: 1ms

2

1,927,633

Details

28s848ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 19	00	31,140	491ms	0ms
	01	35,074	549ms	0ms
	02	26,591	428ms	0ms
	03	28,780	455ms	0ms
	04	27,245	407ms	0ms
	05	21,054	322ms	0ms
	06	18,006	288ms	0ms
	07	23,513	363ms	0ms
	08	46,641	669ms	0ms
	09	125,257	1s776ms	0ms
	10	181,121	2s678ms	0ms
	11	192,498	2s734ms	0ms
	12	177,588	2s472ms	0ms
	13	165,232	2s544ms	0ms
	14	137,547	1s881ms	0ms
	15	152,512	2s189ms	0ms
	16	135,155	2s122ms	0ms
	17	108,847	1s526ms	0ms
	18	96,801	1s486ms	0ms
	19	69,881	1s202ms	0ms
	20	62,638	1s221ms	0ms
	21	43,441	736ms	0ms
	22	21,071	298ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

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

Date: 2025-01-19 11:53:25 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-19 11:50:36 Duration: 0ms

3

1,244,769

Details

13s217ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 19	00	21,826	208ms	0ms
	01	23,182	227ms	0ms
	02	18,929	181ms	0ms
	03	19,543	201ms	0ms
	04	18,666	190ms	0ms
	05	14,702	137ms	0ms
	06	12,985	118ms	0ms
	07	15,696	145ms	0ms
	08	30,594	279ms	0ms
	09	78,126	789ms	0ms
	10	111,351	1s250ms	0ms
	11	119,216	1s277ms	0ms
	12	111,196	1s186ms	0ms
	13	104,661	1s168ms	0ms
	14	89,577	903ms	0ms
	15	98,220	1s30ms	0ms
	16	88,821	982ms	0ms
	17	70,778	741ms	0ms
	18	63,006	659ms	0ms
	19	47,380	506ms	0ms
	20	41,602	561ms	0ms
	21	29,556	330ms	0ms
	22	15,156	136ms	0ms

ROLLBACK;

Date: 2025-01-19 13:28:30 Duration: 0ms
ROLLBACK;

Date: 2025-01-19 16:08:50 Duration: 0ms
ROLLBACK;

Date: 2025-01-19 11:21:40 Duration: 0ms

4

1,231,227

Details

4m4s

0ms

18ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 19	00	21,156	4s77ms	0ms
	01	22,531	4s472ms	0ms
	02	18,280	3s501ms	0ms
	03	18,872	4s43ms	0ms
	04	18,026	3s679ms	0ms
	05	14,067	2s528ms	0ms
	06	12,338	2s65ms	0ms
	07	15,059	2s506ms	0ms
	08	29,863	5s91ms	0ms
	09	77,531	14s835ms	0ms
	10	110,865	22s790ms	0ms
	11	118,388	22s612ms	0ms
	12	110,580	21s465ms	0ms
	13	104,432	21s212ms	0ms
	14	89,131	16s622ms	0ms
	15	97,770	18s750ms	0ms
	16	88,300	17s988ms	0ms
	17	70,192	13s970ms	0ms
	18	62,310	12s345ms	0ms
	19	46,836	10s25ms	0ms
	20	41,038	10s523ms	0ms
	21	28,840	6s541ms	0ms
	22	14,822	2s590ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'f96e945ce68ad098216d182c099af0f75ea90001';

Date: 2025-01-19 12:55:39 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = '1e87669cea73abf8e23e3fc1a2503290dbdc76d7';

Date: 2025-01-19 13:39:23 Duration: 14ms
SELECT payload FROM http_sessions WHERE sid = 'bf0d786dfb7f26e25e238545bfa235379822c00a';

Date: 2025-01-19 12:03:26 Duration: 13ms

5

1,223,493

Details

1m55s

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 19	00	21,127	1s838ms	0ms
	01	22,581	2s1ms	0ms
	02	18,397	1s604ms	0ms
	03	19,000	1s801ms	0ms
	04	18,146	1s718ms	0ms
	05	14,146	1s253ms	0ms
	06	12,429	1s68ms	0ms
	07	15,108	1s319ms	0ms
	08	29,690	2s500ms	0ms
	09	76,849	6s943ms	0ms
	10	109,860	10s779ms	0ms
	11	117,484	10s889ms	0ms
	12	109,826	10s340ms	0ms
	13	103,385	10s67ms	0ms
	14	88,410	8s147ms	0ms
	15	97,135	9s183ms	0ms
	16	87,659	8s496ms	0ms
	17	69,703	6s590ms	0ms
	18	61,923	5s773ms	0ms
	19	46,584	4s496ms	0ms
	20	40,677	4s677ms	0ms
	21	28,668	2s830ms	0ms
	22	14,706	1s218ms	0ms

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

Date: 2025-01-19 00:12:10 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-19 16:44:04 Duration: 0ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-19 15:00:27 Duration: 0ms

6

882,655

Details

2m11s

0ms

23ms

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 19	00	12,606	1s987ms	0ms
	01	16,148	2s668ms	0ms
	02	9,313	1s724ms	0ms
	03	10,953	1s885ms	0ms
	04	10,545	1s612ms	0ms
	05	6,941	1s142ms	0ms
	06	5,816	1s23ms	0ms
	07	9,608	1s494ms	0ms
	08	19,785	2s864ms	0ms
	09	61,070	8s382ms	0ms
	10	92,634	13s801ms	0ms
	11	95,985	13s508ms	0ms
	12	87,052	12s218ms	0ms
	13	79,283	12s353ms	0ms
	14	62,830	8s420ms	0ms
	15	72,613	10s101ms	0ms
	16	59,959	9s433ms	0ms
	17	47,917	6s621ms	0ms
	18	42,558	6s387ms	0ms
	19	28,421	4s679ms	0ms
	20	26,022	4s871ms	0ms
	21	17,116	2s935ms	0ms
	22	7,480	1s97ms	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 (830);

Date: 2025-01-19 13:39:23 Duration: 23ms
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 (1340);

Date: 2025-01-19 17:21:53 Duration: 11ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (967);

Date: 2025-01-19 17:21:53 Duration: 10ms

7

681,503

Details

2m

0ms

45ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 19	00	9,295	1s693ms	0ms
	01	11,890	2s281ms	0ms
	02	7,674	1s485ms	0ms
	03	9,205	2s16ms	0ms
	04	8,583	1s795ms	0ms
	05	6,351	1s279ms	0ms
	06	5,021	862ms	0ms
	07	7,817	1s190ms	0ms
	08	15,950	2s299ms	0ms
	09	47,004	7s599ms	0ms
	10	69,645	12s379ms	0ms
	11	73,120	12s153ms	0ms
	12	66,208	11s593ms	0ms
	13	60,491	11s350ms	0ms
	14	47,866	8s64ms	0ms
	15	54,184	9s368ms	0ms
	16	46,249	8s189ms	0ms
	17	37,954	6s276ms	0ms
	18	33,735	5s739ms	0ms
	19	22,497	4s210ms	0ms
	20	21,004	4s764ms	0ms
	21	13,853	3s118ms	0ms
	22	5,907	1s85ms	0ms

COMMIT;

Date: 2025-01-19 16:58:03 Duration: 45ms
COMMIT;

Date: 2025-01-19 11:53:25 Duration: 41ms
COMMIT;

Date: 2025-01-19 11:46:56 Duration: 38ms

8

531,228

Details

1m15s

0ms

6ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 19	00	9,263	1s135ms	0ms
	01	11,000	1s307ms	0ms
	02	6,166	753ms	0ms
	03	7,530	960ms	0ms
	04	7,434	1s1ms	0ms
	05	2,229	306ms	0ms
	06	3,556	377ms	0ms
	07	4,982	599ms	0ms
	08	10,231	1s378ms	0ms
	09	36,600	5s385ms	0ms
	10	56,557	9s1ms	0ms
	11	58,381	8s639ms	0ms
	12	53,468	8s320ms	0ms
	13	45,268	6s941ms	0ms
	14	33,689	4s700ms	0ms
	15	42,104	5s655ms	0ms
	16	35,745	5s152ms	0ms
	17	28,092	3s735ms	0ms
	18	27,360	3s342ms	0ms
	19	17,433	2s290ms	0ms
	20	17,487	2s665ms	0ms
	21	11,878	1s592ms	0ms
	22	4,775	507ms	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 (5311642, 5113931, 5321548, 5099013, 5234120, 5182321, 5099005, 5291817, 5193920, 5112860, 5316776, 5359668, 5234790, 5210147, 5106122, 5099007, 5099533, 5417508, 5337614, 5099009, 5115849, 5099392, 5266065, 5417503, 5417504, 5099024, 5118711, 5099102, 5253395, 5149370, 5171438, 5106822, 5099712, 5103217, 5120051, 5203701, 5176426, 5101982, 5099254, 5106396);

Date: 2025-01-19 18:44:13 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5483265, 5483264, 5186638, 5483263, 5483262, 5242541, 5184778, 5184269, 5483261, 5483260, 5177760, 5483259, 5324582, 5153077, 5483258, 5409893, 5483257, 5195873, 5220214, 5211429, 5483256, 5483255, 5483254, 5173788, 5237598, 5191922, 5222517, 5483253, 5393272, 5325903, 5227107, 5303910, 5232452, 5483250, 5483249, 5166327, 5483248, 5483247, 5200755, 5168389, 5142158, 5242723, 5304643, 5163734, 5483246, 5145970, 5178404, 5431018, 5241419, 5148192, 5483245, 5270609, 5190304, 5308288, 5328358, 5401085, 5228259, 5483243, 5347076, 5365248, 5228063, 5483242, 5251097, 5149885, 5223801, 5483241, 5318557, 5191584, 5175074, 5483235, 5167654, 5483231, 5203005, 5274877, 5199117, 5278697, 5483229, 5483228, 5189238, 5265412, 5180026, 5183320, 5483226, 5198278, 5483225, 5460782, 5227645, 5483223, 5147315, 5137264, 5483220, 5176969, 5245417, 5240567, 5178614, 5382976, 5483217, 5158064, 5179683, 5155690, 5258341, 5139547, 5142446, 5187688, 5483216, 5483215, 5483214, 5163051, 5178603, 5405366, 5403324, 5425209, 5148440, 5195584, 5483212, 5245458, 5445540, 5173085, 5483211, 5334092, 5162068, 5187610, 5433598, 5349867, 5272989, 5314861, 5172355, 5148798, 5483210, 5330574, 5371902, 5188300, 5257264, 5167875, 5228239, 5164695, 5317080, 5483208, 5417772, 5483207, 5483206, 5181575, 5224098, 5181208, 5169078, 5306220, 5483205, 5153919, 5483204, 5307596, 5170914, 5483203, 5483202, 5197529, 5483201, 5214586, 5161514, 5290088, 5454388, 5182545, 5181996, 5483197, 5483196, 5483194, 5371817, 5483193, 5168991, 5205127, 5414338, 5483179, 5205000, 5175669, 5250389, 5154345, 5210788, 5254351, 5160323, 5245908, 5347201, 5151455, 5179550, 5263454, 5269277, 5483178, 5286979, 5344776, 5179802, 5343748, 5404309, 5483177, 5135489, 5186116, 5300945, 5160919, 5483173, 5176440, 5139592, 5246274, 5254206, 5145643, 5204731, 5235127, 5259734, 5483172, 5193566, 5249909, 5209181, 5354624, 5483169, 5151834, 5160855, 5157763, 5325908, 5255666, 5159699, 5211761, 5193708, 5483168, 5146547, 5150706, 5253642, 5206526, 5483165, 5260946, 5483163, 5149892, 5146908, 5483146, 5483145, 5240361, 5483144, 5483143, 5275369, 5400821, 5483142, 5392479, 5364969, 5483141, 5483140, 5471880, 5483139, 5483138, 5483137, 5322444, 5483136, 5250461, 5453274, 5201301, 5346635, 5362481, 5165163, 5268362, 5426953, 5237786, 5152076, 5151771, 5277639, 5172032, 5134271, 5267469, 5361331, 5171950, 5483099, 5150807, 5256724, 5284616, 5245866, 5341664, 5151607, 5339729, 5221208, 5483098, 5217969, 5483088, 5137260, 5178131, 5268639, 5426705, 5483087, 5148331, 5254013, 5166261, 5338430, 5483086, 5178394, 5453015, 5205136, 5392666, 5483085, 5234536, 5162401, 5345402, 5151290, 5438898, 5483084, 5233399, 5158824, 5483083, 5389395, 5165146, 5483060, 5174261, 5308987, 5483058, 5245789, 5159476, 5159731, 5171954, 5174514, 5483057, 5364963, 5151606, 5144118, 5483050, 5286218, 5213166, 5411581, 5300457, 5138716, 5146305, 5146321, 5483042, 5483041, 5174427, 5221812, 5172576, 5167380, 5483039, 5260482, 5411655, 5151601, 5483036, 5155857, 5203505, 5275340, 5271752, 5165055, 5483034, 5276851, 5152660, 5195712, 5238706, 5282210, 5172206, 5172768, 5176801, 5196292, 5172514, 5358784, 5220610, 5483027, 5483025, 5483023, 5483022, 5483021, 5198498, 5483020, 5483019, 5483018, 5209355, 5165096, 5292892, 5174382, 5142947, 5161667, 5151881, 5148579, 5483007, 5149061, 5429763, 5483005, 5139923, 5463684, 5321834, 5483004, 5465479, 5383488, 5197141, 5483001, 5483000, 5482999, 5150577, 5482998, 5338048, 5176513, 5205948, 5274962, 5174814, 5313492, 5482997, 5371630, 5482996, 5482995, 5139394, 5135594, 5482992, 5245781, 5482991, 5249260, 5411501, 5482990, 5174404, 5482989, 5296937, 5157640, 5174004, 5148948, 5202561, 5220260, 5414948, 5165058, 5222183, 5150268, 5140611, 5250834, 5162472, 5137037, 5148194, 5180094, 5194627, 5482988, 5142195, 5482986, 5151595, 5482984, 5482983, 5200831, 5158470, 5268381, 5357844, 5354493, 5185286, 5482963, 5273271, 5482962, 5252552, 5482961, 5482960, 5482959, 5245387, 5482957, 5170543, 5306253, 5225783, 5246932, 5154609, 5482955, 5482953, 5202945, 5482952, 5203984, 5142209, 5482951, 5482950, 5482949, 5152274, 5482948, 5217858, 5413057, 5382364, 5341293, 5184894, 5144929, 5482947, 5137338, 5482941, 5482942, 5330493, 5287348, 5137584, 5361548, 5366723, 5229060, 5136325, 5482935, 5482932, 5278748, 5479708, 5185465, 5482842, 5482929, 5302004, 5482927, 5156833, 5482926, 5482924, 5482922, 5482921, 5367224, 5482917, 5372971, 5428853, 5482915, 5341529, 5220799, 5244767, 5482827, 5482912, 5217085, 5159612, 5152233, 5406004, 5146521, 5343867, 5170651, 5175509, 5175051, 5236621, 5364515, 5175433, 5174085, 5151999, 5204757, 5355605, 5200666, 5177923, 5139619, 5398819, 5203156, 5156834, 5438989, 5134728, 5158043, 5412787, 5482906, 5260601, 5160705, 5482904, 5150721, 5150725, 5468947, 5321901, 5482900, 5482899, 5482898, 5246645, 5149257, 5450650, 5392273, 5181484, 5178526, 5252812, 5482897, 5161762, 5301075, 5225984, 5482895, 5330846, 5336854, 5482894, 5157221, 5482893, 5482891, 5482890, 5482889, 5193920, 5482888, 5474048, 5166211, 5201502, 5482887, 5144947, 5420085, 5482886, 5238243, 5232868, 5161536, 5143723, 5482885, 5140705, 5482884, 5151269, 5482872, 5171626, 5482883, 5420911, 5164891, 5354661, 5230823, 5284891, 5482882, 5200849, 5482881, 5367169, 5482880, 5243183, 5419080, 5207030, 5482876, 5482873, 5184195, 5482871, 5157424, 5149613, 5289713, 5177784, 5197846, 5482859, 5156829, 5203147, 5137317, 5482855, 5474942, 5231659, 5158041, 5177517, 5374684, 5199555, 5482854, 5240868, 5228954, 5430210, 5265771, 5158687, 5482852, 5165201, 5367258, 5482851, 5482850, 5227017, 5482846, 5482845, 5179942, 5144660, 5482844, 5168951, 5482843, 5467736, 5357078, 5430314, 5470585, 5150726, 5220780, 5482840, 5211003, 5241928, 5163115, 5158063, 5185197, 5482839, 5482838, 5226100, 5153742, 5467791, 5482837, 5252979, 5151767, 5136328, 5183536, 5329908, 5482836, 5482834, 5206203, 5302556, 5268737, 5230821, 5482825, 5237995, 5482823, 5482824, 5162611, 5482816, 5465191, 5140290, 5482820, 5482818, 5163941, 5153273, 5482817, 5453806, 5482814, 5482813, 5473518, 5176360, 5482795, 5482812, 5245405, 5482811, 5389350, 5231453, 5286790, 5166674, 5482810, 5146518, 5179092, 5142608, 5250684, 5226776, 5324862, 5146912, 5150603, 5164266, 5482809, 5411144, 5178164, 5150728, 5263098, 5195757, 5292881, 5275747, 5150599, 5158006, 5150730, 5178167, 5436682, 5474650, 5257507, 5477510, 5482807, 5154917, 5151449, 5475530, 5482805, 5167505, 5174148, 5180357, 5424284, 5482800, 5335539, 5177456, 5407812, 5135700, 5482794, 5186074, 5482793, 5482791, 5171441, 5482789, 5208051, 5475531, 5482788, 5188897, 5482787, 5482784, 5356133, 5459655, 5250512, 5482781, 5482780, 5149623, 5443890, 5253377, 5469341, 5150068, 5482774, 5329625, 5156196, 5201992, 5263092, 5278354, 5177542, 5318300, 5222892, 5144053, 5286403, 5268591, 5482770, 5174111, 5482769, 5213753, 5265018, 5162733, 5482766, 5482767, 5150805, 5137897, 5174033, 5482765, 5482764, 5482763, 5306754, 5447608, 5482761, 5170124, 5482760, 5157104, 5157105, 5482759, 5482758, 5482757, 5254148, 5164706, 5301009, 5482756, 5482754, 5482752, 5482753, 5163648, 5482751, 5323832, 5176884, 5148494, 5156195, 5482750, 5482749, 5331888, 5157100, 5137154, 5324893, 5301503, 5275090, 5482747, 5482746, 5296305, 5449413, 5197168, 5482743, 5160988, 5324856, 5137263, 5482741, 5482639, 5174855, 5386056, 5234974, 5261788, 5219924, 5482727, 5275941, 5316364, 5426450, 5482724, 5216095, 5169047, 5169327, 5414665, 5245742, 5275802, 5482712, 5394531, 5189325, 5215278, 5307454, 5482719, 5482718, 5166845, 5158114, 5482717, 5151738, 5414260, 5187031, 5478893, 5482714, 5482713, 5204383, 5173854, 5456942, 5136333, 5176168, 5482711, 5147599, 5199421, 5482709, 5227094, 5479464, 5481845, 5255943, 5166180, 5482705, 5482703, 5482700, 5160745, 5209185, 5482692, 5146606, 5482691, 5482690, 5482689, 5482686, 5324786, 5185308, 5482675, 5462974, 5376001, 5195374, 5344845, 5161925, 5482673, 5207056, 5211924, 5370437, 5151996, 5482665, 5148966, 5255670, 5184037, 5168827, 5279840, 5399603, 5206693, 5244549, 5400053, 5156225, 5363434, 5213142, 5262405, 5170537, 5482662, 5141953, 5482661, 5482660, 5175279, 5216634, 5482659, 5482658, 5136890, 5329410, 5165065, 5303760, 5334701, 5476616, 5482657, 5482656, 5482655, 5148612, 5155145, 5482654, 5275223, 5162394, 5202921, 5304035, 5329218, 5157999, 5482653, 5342979, 5325054, 5195057, 5156078, 5427907, 5363408, 5482652, 5330323, 5275339, 5178973, 5237682, 5482649, 5207324, 5474603, 5222017, 5220004, 5265319, 5160248, 5482647, 5170821, 5482644, 5159446, 5482641, 5265114, 5157093, 5203650, 5323518, 5157997, 5432725, 5185297, 5424270, 5190009, 5237100, 5482638, 5482637, 5156236, 5482636, 5407070, 5157330, 5447105, 5256331, 5257899, 5190920, 5374894, 5482631, 5482630, 5482629, 5179938, 5482627, 5482626, 5438716, 5482619, 5482618, 5361030, 5482616, 5323274, 5177984, 5482615, 5482614, 5482613, 5482612, 5181293, 5482611, 5322866, 5482609, 5363125, 5250779, 5142368, 5196916, 5154047, 5482605, 5482604, 5283495, 5482603, 5147606, 5482600);

Date: 2025-01-19 09:53:54 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099130, 5102054, 5099007, 5104336, 5113990, 5115499, 5099568, 5099013, 5483515, 5099177, 5104278, 5099102, 5483513, 5112647, 5432264, 5099009, 5469559, 5099181, 5099236, 5099117, 5100232, 5483511, 5336780, 5099445, 5330919, 5310158, 5483510, 5397349, 5112036, 5099045, 5099119, 5387191, 5099206, 5336800, 5220874, 5102977, 5112730, 5099190, 5136665, 5099299, 5099028, 5154967, 5099500, 5123553, 5184019, 5099198, 5180923, 5099671, 5118875, 5121121, 5099285);

Date: 2025-01-19 17:21:55 Duration: 5ms

9

525,125

Details

36s404ms

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 19	00	6,811	373ms	0ms
	01	8,085	444ms	0ms
	02	4,262	237ms	0ms
	03	4,953	306ms	0ms
	04	5,381	314ms	0ms
	05	1,987	112ms	0ms
	06	3,141	158ms	0ms
	07	5,988	306ms	0ms
	08	10,865	588ms	0ms
	09	34,590	2s187ms	0ms
	10	55,282	4s182ms	0ms
	11	57,756	4s159ms	0ms
	12	54,058	3s800ms	0ms
	13	47,486	3s602ms	0ms
	14	35,605	2s335ms	0ms
	15	42,706	2s871ms	0ms
	16	37,266	2s711ms	0ms
	17	29,827	1s983ms	0ms
	18	27,401	1s804ms	0ms
	19	18,203	1s226ms	0ms
	20	17,547	1s617ms	0ms
	21	11,089	813ms	0ms
	22	4,836	267ms	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 (51, 26, 49, 17, 70, 39, 55, 30, 19, 6);

Date: 2025-01-19 10:07:10 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 (4);

Date: 2025-01-19 13:17: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 (24, 110);

Date: 2025-01-19 12:54:10 Duration: 1ms

10

441,683

Details

2m24s

0ms

4ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 19	00	3,581	1s25ms	0ms
	01	2,716	773ms	0ms
	02	1,672	498ms	0ms
	03	2,503	798ms	0ms
	04	1,741	546ms	0ms
	05	993	306ms	0ms
	06	1,216	365ms	0ms
	07	1,722	496ms	0ms
	08	9,204	2s585ms	0ms
	09	24,829	7s744ms	0ms
	10	44,098	15s252ms	0ms
	11	46,818	15s751ms	0ms
	12	48,687	16s89ms	0ms
	13	44,188	15s248ms	0ms
	14	38,083	11s888ms	0ms
	15	36,674	11s828ms	0ms
	16	29,407	10s227ms	0ms
	17	29,775	9s336ms	0ms
	18	30,649	9s319ms	0ms
	19	19,201	6s128ms	0ms
	20	13,387	5s284ms	0ms
	21	7,440	2s354ms	0ms
	22	3,099	866ms	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 = 961) OR r.global) ORDER BY r.id;

Date: 2025-01-19 17:07:16 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'collection.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 = 1080) OR r.global) ORDER BY r.id;

Date: 2025-01-19 10:08:12 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'mail.channel.member' 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 = 886) OR r.global) ORDER BY r.id;

Date: 2025-01-19 12:26:45 Duration: 3ms

11

373,062

Details

1m13s

0ms

22ms

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 19	00	4,877	803ms	0ms
	01	5,531	924ms	0ms
	02	2,593	499ms	0ms
	03	3,136	670ms	0ms
	04	3,271	674ms	0ms
	05	1,569	267ms	0ms
	06	1,725	305ms	0ms
	07	4,027	645ms	0ms
	08	8,741	1s459ms	0ms
	09	28,031	4s916ms	0ms
	10	38,952	8s117ms	0ms
	11	41,311	8s366ms	0ms
	12	37,363	7s601ms	0ms
	13	34,279	7s146ms	0ms
	14	28,335	5s125ms	0ms
	15	31,362	5s886ms	0ms
	16	24,958	5s165ms	0ms
	17	20,891	4s44ms	0ms
	18	17,694	3s318ms	0ms
	19	12,108	2s285ms	0ms
	20	11,413	2s861ms	0ms
	21	7,517	1s532ms	0ms
	22	3,378	557ms	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 (8004670, 8006359, 8006345, 8006302, 8006341, 8007028, 8006374, 8006346, 8006408, 8007486, 8006405, 8007200, 8006435, 8006299, 8006398, 8006472, 8007704, 8007693, 8004666, 8006288, 8006294, 8006324, 8006333, 8006347, 8004676, 8004681, 8006313, 8004708, 8006353, 8007174, 8006459, 8006458, 8004657, 8004673, 8004671, 8006291, 8006397, 8004700, 8004679, 8007456, 8006297, 8006277, 8007763, 8006350, 8004699, 8006311, 8004658, 8004664, 8006303, 8006461, 8004684, 8006331, 8006326, 8006320, 8006354, 8004667, 8004656, 8006602, 8006457, 8006343, 8007691, 8006282, 8006645, 8004661, 8006317, 8007331, 8004697, 8006340, 8007305, 8006416, 8006456, 8006330, 8006689, 8006411, 8007563);

Date: 2025-01-19 20:24:20 Duration: 22ms
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 (8004713, 8004709, 8004702, 8004666, 8006864, 8004704, 8004711, 8004718, 8004716, 8004719, 8004722, 8004698, 8004695, 8004688, 8004707, 8004660, 8004661, 8004684, 8004703, 8004653, 8004663, 8004652, 8004673, 8004687, 8004901, 8004674, 8004676, 8004690, 8004691, 8004714, 8004664, 8004697, 8004696, 8004671, 8004701, 8004662, 8004706, 8004689, 8004705, 8004686, 8004655, 8004692, 8004700, 8004657, 8004909, 8004670, 8004715, 8004658, 8004721, 8004665, 8004708, 8004654, 8004680);

Date: 2025-01-19 12:03:26 Duration: 14ms
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 (8004651);

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

12

329,429

Details

1m3s

0ms

18ms

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 19	00	3,322	483ms	0ms
	01	3,015	403ms	0ms
	02	1,849	240ms	0ms
	03	2,484	374ms	0ms
	04	1,715	233ms	0ms
	05	1,742	223ms	0ms
	06	1,121	163ms	0ms
	07	1,854	253ms	0ms
	08	9,560	1s385ms	0ms
	09	21,562	3s682ms	0ms
	10	32,638	6s747ms	0ms
	11	34,108	6s945ms	0ms
	12	32,803	6s720ms	0ms
	13	30,105	6s462ms	0ms
	14	27,828	5s186ms	0ms
	15	27,133	5s92ms	0ms
	16	20,462	4s211ms	0ms
	17	22,891	4s272ms	0ms
	18	20,382	3s874ms	0ms
	19	13,973	2s708ms	0ms
	20	9,892	2s386ms	0ms
	21	5,989	1s59ms	0ms
	22	3,001	437ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 1214 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-19 11:03:30 Duration: 18ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-19 15:27:27 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1416 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_user' AND model = 'res.groups');

Date: 2025-01-19 16:18:29 Duration: 1ms

13

264,730

Details

1d18h56m12s

380ms

5s441ms

583ms

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 19	00	7,124	1h2m58s	530ms
	01	9,218	1h21m22s	529ms
	02	6,595	58m5s	528ms
	03	11,294	1h41m23s	538ms
	04	9,206	1h20m51s	527ms
	05	5,082	43m5s	508ms
	06	3,646	32m38s	537ms
	07	2,982	25m18s	509ms
	08	3,776	32m11s	511ms
	09	10,536	1h36m50s	551ms
	10	20,465	3h21m26s	590ms
	11	16,337	2h41m3s	591ms
	12	17,566	2h50m11s	581ms
	13	16,734	2h46m53s	598ms
	14	9,084	1h23m47s	553ms
	15	11,897	1h55m22s	581ms
	16	16,378	2h43m55s	600ms
	17	14,833	2h25m36s	588ms
	18	14,552	2h27m47s	609ms
	19	13,237	2h9m31s	587ms
	20	20,247	3h55m57s	699ms
	21	20,301	3h25m40s	607ms
	22	3,640	34m8s	562ms

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

Date: 2025-01-19 20:16:14 Duration: 5s441ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4612542)) AND (("shipping_track"."id" not in (38089162, 38089162)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:15:39 Duration: 5s34ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4612554)) AND (("shipping_track"."id" not in (38089268, 38089268)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:15:57 Duration: 5s18ms

14

241,813

Details

1m6s

0ms

17ms

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 19	00	4,187	1s32ms	0ms
	01	4,744	1s146ms	0ms
	02	2,848	767ms	0ms
	03	4,076	1s145ms	0ms
	04	3,198	973ms	0ms
	05	771	252ms	0ms
	06	2,009	513ms	0ms
	07	2,077	541ms	0ms
	08	4,349	1s262ms	0ms
	09	14,811	4s278ms	0ms
	10	23,163	7s193ms	0ms
	11	23,776	7s31ms	0ms
	12	22,828	6s679ms	0ms
	13	20,311	5s465ms	0ms
	14	16,299	4s53ms	0ms
	15	18,657	4s462ms	0ms
	16	17,383	4s602ms	0ms
	17	15,316	3s809ms	0ms
	18	14,147	3s656ms	0ms
	19	8,604	2s237ms	0ms
	20	9,224	2s818ms	0ms
	21	6,554	1s807ms	0ms
	22	2,481	586ms	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 (32647641, 41399253, 41042075, 32647636, 41421455, 41407902, 32649839, 32648325, 41457245, 41403783, 41363895, 41128725, 41403711, 41403707, 40967576, 41363847, 41403672, 41403661, 41428934, 41482916, 41483316, 40825670, 41191935, 41479059, 41408715, 41418502, 41425293, 41458111, 41345049, 40590246, 41395156, 41399487, 41424960, 41366216, 41390815, 41437328, 41437449, 41365926, 32572030, 41422700, 41399197, 41112587, 41371555, 41081014, 40974066, 32645242, 41228992, 41365285, 41305802, 41280884, 41078706, 41428217, 41464592, 40968185, 41311572, 41310507, 41310515, 41254068, 41378458, 41310208, 41193265, 41281855, 32646246, 41137227, 41183418, 41214879, 41251966, 41136132, 40929438, 41396486, 40974083, 41431451, 40972314, 40972090, 41431325, 41334773, 41342473, 41342472, 40729273, 41271419, 41474663, 41268928, 41466403, 41422553, 41265140, 41433493, 41457412, 41457465, 41457472, 41354277, 41420151, 41457407, 41389457, 41389235, 41420199, 41309161, 40974074, 40973652, 40973899, 32644667);

Date: 2025-01-19 18:44:51 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 (41288772, 41288862, 40948531, 41060150, 41368753, 40779233, 40601609, 40930636, 41208512, 40304949, 41183794, 41263943, 41680462, 41316241, 39734930, 41220055, 40799509, 41207953, 40306633, 41964841, 41516796, 32618815, 32601827, 40897322, 41288740, 40600669, 41466668, 41379594, 32617429, 32621763, 39951037, 32600437, 42083650, 41107135, 40897736, 40898152, 32600097, 41223477, 41974671, 32618813, 40832920, 32618329, 41505301, 32617880, 41106961, 41816112, 40246823, 41278952, 32188002, 40979650, 41732544, 32596728, 40701345, 40246803, 42021250, 40126884, 41178755, 41107284, 42063406, 32617501, 41464206, 41971233, 42153500, 40903350, 42054654, 32659510, 32655993, 42034490, 41759095, 41703470, 41773691, 41063343, 40641636, 41946913, 42078871, 41703442, 40832726, 42060892, 32178642, 42057741, 32659527, 41939945, 41090565, 32658794, 41622984, 42084122, 32653481, 41792573, 32623193, 41207203, 42001629, 40552034, 32633974, 41974979, 41975302, 41751816, 32188024, 41416298, 40965476, 41152494);

Date: 2025-01-19 17:22:08 Duration: 11ms
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 (40050532, 39479368, 40062872, 39989726, 39902247, 40016529, 39902244, 39918505, 40173621, 40172823, 40132364, 40023975, 40122737, 40122733, 40131361, 40207746, 40087111, 40087102, 40086885, 40203594, 40098791, 40034165, 39923287, 40143686, 40143658, 40168948, 39541453, 39475502, 40150502, 40119298, 40086463, 40123929, 40087499, 40087502, 39617479, 40024838, 40087497, 40191939, 40195632, 40219134, 40124485, 40127931, 40068780, 40181990, 39689092, 40123460, 40178551, 39942086, 39961585, 39961502, 40179235, 39174963, 40041544, 40041545, 40041614, 39936228, 40039885, 39755231, 39519702, 40064344, 40091604, 39778993, 39703562, 40190656, 40070167, 40066187, 40137833, 40158767, 40158837, 40079084, 40190876, 40160475, 40205002, 39787184, 40137707, 40067675, 40054157, 39768296, 40017227, 39945841, 39884680, 39866088, 40063510, 40151402, 40172988, 40159878, 40160073, 40121796, 40086831, 40170950, 40188853, 40150855, 40135085, 39768295, 39410625, 40150318, 40068927, 40181920, 40114391, 39257704);

Date: 2025-01-19 17:22:19 Duration: 9ms

15

192,248

Details

11s763ms

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

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,581	76ms	0ms
	01	1,199	56ms	0ms
	02	695	33ms	0ms
	03	1,055	56ms	0ms
	04	649	32ms	0ms
	05	423	20ms	0ms
	06	532	27ms	0ms
	07	713	34ms	0ms
	08	3,853	190ms	0ms
	09	10,688	598ms	0ms
	10	19,231	1s252ms	0ms
	11	20,535	1s311ms	0ms
	12	21,332	1s350ms	0ms
	13	18,711	1s222ms	0ms
	14	16,535	959ms	0ms
	15	15,830	932ms	0ms
	16	12,518	803ms	0ms
	17	13,006	761ms	0ms
	18	13,759	810ms	0ms
	19	8,762	525ms	0ms
	20	5,901	447ms	0ms
	21	3,279	186ms	0ms
	22	1,461	71ms	0ms

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

Date: 2025-01-19 13:34:30 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

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

Date: 2025-01-19 19:40:37 Duration: 0ms

16

182,826

Details

24s28ms

0ms

16ms

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

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,557	160ms	0ms
	01	1,170	118ms	0ms
	02	680	69ms	0ms
	03	1,043	117ms	0ms
	04	646	69ms	0ms
	05	396	39ms	0ms
	06	513	55ms	0ms
	07	704	70ms	0ms
	08	3,784	389ms	0ms
	09	10,477	1s246ms	0ms
	10	18,697	2s649ms	0ms
	11	19,459	2s689ms	0ms
	12	20,203	2s747ms	0ms
	13	17,721	2s531ms	0ms
	14	15,646	1s922ms	0ms
	15	15,087	1s887ms	0ms
	16	11,861	1s644ms	0ms
	17	12,383	1s540ms	0ms
	18	12,628	1s589ms	0ms
	19	8,154	1s41ms	0ms
	20	5,523	931ms	0ms
	21	3,066	368ms	0ms
	22	1,428	146ms	0ms

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

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

Date: 2025-01-19 13:05:52 Duration: 14ms
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-19 13:34:43 Duration: 1ms

17

180,794

Details

16s785ms

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

Day	Hour	Count	Duration	Avg duration
Jan 19	00	2,689	207ms	0ms
	01	3,254	256ms	0ms
	02	1,761	141ms	0ms
	03	1,929	187ms	0ms
	04	2,158	196ms	0ms
	05	768	66ms	0ms
	06	954	81ms	0ms
	07	1,818	148ms	0ms
	08	3,645	310ms	0ms
	09	12,849	1s261ms	0ms
	10	20,027	2s86ms	0ms
	11	21,142	1s584ms	0ms
	12	18,992	1s550ms	0ms
	13	16,295	1s567ms	0ms
	14	12,133	1s58ms	0ms
	15	15,276	1s460ms	0ms
	16	12,396	1s223ms	0ms
	17	9,388	646ms	0ms
	18	8,049	643ms	0ms
	19	5,376	535ms	0ms
	20	5,153	854ms	0ms
	21	3,298	514ms	0ms
	22	1,444	200ms	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-19 18:44:13 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-19 15:07:15 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-19 14:20:56 Duration: 1ms

18

179,981

Details

1m46s

0ms

19ms

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

Day	Hour	Count	Duration	Avg duration
Jan 19	00	933	640ms	0ms
	01	1,215	856ms	0ms
	02	294	151ms	0ms
	03	250	211ms	0ms
	04	308	168ms	0ms
	05	233	118ms	0ms
	06	392	155ms	0ms
	07	881	319ms	0ms
	08	2,698	1s166ms	0ms
	09	7,257	4s566ms	0ms
	10	10,404	7s947ms	0ms
	11	12,569	8s999ms	0ms
	12	11,121	8s31ms	0ms
	13	14,149	9s324ms	0ms
	14	9,825	6s313ms	0ms
	15	18,516	10s966ms	0ms
	16	20,316	11s35ms	0ms
	17	8,771	4s972ms	0ms
	18	3,196	1s686ms	0ms
	19	9,155	4s359ms	0ms
	20	28,922	15s524ms	0ms
	21	17,740	8s503ms	0ms
	22	836	419ms	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 (4400242, 4485890, 4420592, 4462568, 4462562, 4450175, 4451590, 4452353, 3590157, 4402195, 4438410, 4420879, 3735883, 4462580, 4485871, 4486500, 4462551, 4464717, 4451912, 4491820, 4491855, 4452378, 4462571, 4422013, 4484397, 4399287, 4402139, 4393195, 4446297, 4443514, 4351118, 4364817, 4398943, 4443511, 4190092, 4446335, 4443495, 4329451, 4443516, 4420808, 4399190, 4386448, 4399974, 4420597, 4434608, 4423548, 4372854, 4450466, 4450458, 4424384, 4443504, 4443500, 4446105, 4446699, 4434614, 4452009, 4446696, 4420605, 4205209, 4451697, 4422925, 4423316, 4402546, 4402870, 4451743, 4110787, 4420417, 4422490, 4446333, 4173308, 4457451, 4452683, 4398723, 4291938, 4035725, 4214745, 4422019, 4402081, 4399141, 4396813, 4360332, 4446698, 4373717, 4396666, 4396719, 4420809, 4396706, 4352020, 4424451, 4396691, 3764883, 4276357, 4333367, 4424157, 4420795, 4401979, 4272922, 4023687, 4324658, 4402868, 4402826, 4402865, 4422624, 4396344, 4422593, 4401984, 4396699, 4422604, 4397637, 4396690, 4402845, 4422112, 4333899, 4396687, 4399871, 4362764, 4422128, 4422923, 4143633, 4143529, 4420947, 4367722, 4402044, 4400840, 4386443, 4402827, 4397163, 4360275, 4423328, 4402445, 4375369, 4173642, 4423329, 4420877, 4423123, 4402194, 4422598, 4400411, 4329625, 4327557, 4302372, 4357825, 4373743, 3667040, 4422020, 4329596, 4217554, 4422009, 4400445, 4400460, 4363181, 4363553, 4400258, 4396704, 4190837, 4423696, 4400272, 4401073, 4400068, 4357503, 4218219, 4275271, 4392640, 4359557, 4278338, 4374502, 4332362, 4375435, 4399868, 4402443, 4396701, 4332653, 4398850, 4396711, 4398846, 4374928, 4397162, 4397598, 4401954, 4399856, 4396697, 4363911, 4400047, 4333916, 4400304, 4321482, 4396802, 4372790, 4402021, 4400684, 4400844, 4366335, 4373076, 4400874, 4370181, 4274769, 4400843, 4396800, 4400915, 4400856, 4361792, 4333895, 4402040, 4399964, 4276599, 4374055, 4255136, 4288046, 4364856, 4364850, 4396820, 4400080, 4373336, 4321477, 3886358, 4400089, 4400159, 4406895, 4396672, 4396824, 4355560, 4402217, 4132922, 4119894, 4173532, 4371248, 4352022, 4190698, 4168423, 4375860, 4243452, 4361933, 4373053, 4374927, 4189793, 4352026, 4376038, 4362585, 4355562, 4373338, 4366057, 4364215, 4359555, 4078379, 4362624, 4333979, 4375385, 4346507, 4375957, 4352018, 4361799, 4372788, 4352004, 4357496, 4360227, 4346506, 4373723, 3398086, 4295661, 4107740, 4352029, 4245838, 4213683, 4357827, 4331047, 4359290, 4321459, 4352027, 4243457, 4317917, 4321454, 4304234, 4321466, 4327498, 4114046, 4276700, 4333558, 4333005, 4321470, 4246141, 4321463, 4362334, 4304487, 4357826, 4298993, 4288016, 4117177, 4331045, 4359554, 4174699, 4321342, 4321485, 4312106, 4327520, 4321474, 3917044, 4059636, 4297849, 4303012, 4332533, 4332511, 4116882, 4243455, 4333471, 4260164, 4273183, 4303009, 2714932, 3981023, 4302925, 4275234, 4188045, 4273188, 4276942, 4274924, 4276680, 4272923, 4293868, 4295821, 4297568, 4274917, 4245400, 3529935, 4133351, 4303006, 4293865, 4293867, 4297581, 4300982, 4274918, 4297580, 4304493, 4271646, 4274597, 3762189, 4274360, 4276606, 4185847, 4213681, 4210624, 4246147, 4213687, 4221920, 4213677, 4026749, 4215653, 4001034, 4213686, 4213685, 4213688, 4210626, 2384428, 4213680, 4076177, 4213684, 4213678, 4213675, 4056816, 4142363, 4133353, 4188043, 4143532, 3983929, 3842418, 4116877, 4143886, 3914780, 4076179, 4072567, 4076332, 4076336, 4096131, 4076334, 3722888, 3825186, 3880805, 3506567, 4029446, 4034298, 3880807, 3618952, 3943304, 3901158, 3901159, 3942056, 3880804, 3886709, 3880806, 3887965, 2923640, 3582551, 3823835, 3887364, 3649423, 3506571, 3348641, 3842419, 3822771, 3804126, 3804123, 3432879, 3366578, 3316294, 2211328);

Date: 2025-01-19 10:56:36 Duration: 19ms
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 (4532837, 4526180, 4525504, 4523107, 4520204, 4520046, 4519364, 4518214, 4512670, 4512198, 4512119, 4508902, 4507853, 4507801, 4507231, 4506402, 4506248, 4506130, 4504846, 4501545, 4500640, 4497317, 4491043, 4483745, 4483689, 4470816, 4469518, 4467104, 4466542, 4460601, 4450806, 4346730, 4525508, 4523057, 4516095, 4512709, 4512600, 4512003, 4506889, 4504511, 4503515, 4503387, 4503350, 4502347, 4502018, 4500685, 4498546, 4496602, 4491917, 4472207, 4469865, 4468352, 4460368, 4456927, 4434286, 4431623, 4430374, 4408412, 4378913, 4276987, 4528182, 4556032, 4538256, 4531412, 4530945, 4528016, 4525459, 4525448, 4525430, 4512899, 4507316, 4503278, 4497381, 4464185, 4461474, 4449944, 4444915, 4435408, 4263089, 4525447, 4507808, 4503542, 4501626, 4496592, 4491932, 4491921, 4491910, 4491899, 4491885, 4489023, 4489007, 4478477, 4478476, 4470957, 4465479, 4461867, 4450208, 4448073, 4443745, 4429265, 4410003, 4519682, 4519226, 4518319, 4518116, 4512896, 4502955, 4501616, 4500476, 4497750, 4491894, 4489025, 4483822, 4483747, 4481855, 4473102, 4471622, 4467214, 4464943, 4464090, 4461311, 4460630, 4456571, 4455511, 4432575, 4432503, 4432068, 4432006, 4429351, 4427222, 4424062, 4413081, 4390956, 4519759, 4519350, 4518512, 4518453, 4518314, 4515240, 4512026, 4508423, 4507162, 4506325, 4497931, 4497725, 4497208, 4496832, 4491916, 4491913, 4490627, 4488997, 4479145, 4467499, 4456729, 4441494, 4543951, 4543868, 4543175, 4539130, 4536670, 4535829, 4534938, 4534890, 4531908, 4528744, 4520524, 4519788, 4505897, 4491891, 4482052, 4461512, 4430942, 4099756, 4558364);

Date: 2025-01-19 17:57:57 Duration: 17ms
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 (4527662, 4563844, 4440571, 4466501, 4470578, 4506365, 4561060, 4563228, 4549340, 4541333, 4549373, 4563227, 4517522, 4466494, 4546744, 4554644, 4448049, 4541502, 4447972, 4345597, 4361686, 4465251, 4489113, 4446337, 4541504, 4466368, 4541341, 4476907, 4506364, 4421288, 4447974, 4539461, 4482089, 4466374, 4517643, 4523108, 4482129, 4504126, 4539432, 4538084, 4493173, 4414887, 4368870, 4361689, 4219380, 4470133, 4474006, 3623775, 4474009, 4482188, 4466250, 4470576, 4474017, 4481930, 4499644, 4517603, 4529476, 4546684, 4523092, 4482181, 4282627, 4481927, 4397719, 4449042, 4510026, 4529470, 4343423, 4361714, 4361726, 4527676, 4315135, 4329406, 4517490, 4428444, 4448073, 4481950, 4473966, 4472908, 4481952, 4449045, 4517554, 4481928, 4518816, 4494276, 4361687, 4508222, 4491016, 4476942, 4398696, 4444241, 4141353, 4448059, 4510271, 3771480, 4517631, 4421090, 4419911, 4441141, 4517365, 4481925, 4487334, 4486529, 4448087, 4449049, 4448056, 4446484, 4517355, 4517353, 4441115, 4487356, 4476827, 4482172, 4466488, 4517524, 4491903, 4379205, 4473965, 4444151, 4412154, 4439211, 4441110, 4371048, 4474013, 4428482, 4098803, 4482126, 4263593, 4151888, 4446504, 4447949, 4441134, 4441126, 4417107, 4465220, 4448080, 4494278, 4444203, 4444246, 4441131, 4443366, 4441128, 4457069, 4428419, 3777011, 4446520, 4449038, 4288682, 4493996, 4330817, 4417029, 4442074, 4421838, 4470157, 4470121, 4439210, 4465242, 4470162, 4471098, 4449047, 4482127, 4470168, 4457057, 4487093, 4421054, 4361206, 4428418, 4441137, 4441122, 4442079, 4441105, 4476862, 4056032, 4471097, 4476843, 4273969, 4465166, 4424520, 4359031, 4444238, 4476857, 4449036, 4446821, 4370976, 4470623, 4421834, 4482122, 4454048, 4439214, 4476846, 4184307, 4441164, 4446849, 4428442, 4421890, 4427506, 4414886, 4441213, 4216740, 4430173, 4320174, 4359714, 4446424, 4430200, 4357336, 4424528, 4441108, 4439212, 4439215, 4428417, 4388326, 4450189, 4428433, 4442071, 4439213, 4402776, 4441231, 3946514, 4448089, 4446466, 4439209, 4441493, 4446474, 4398792, 4446446, 4446442, 4446443, 4359036, 4441211, 4329397, 4441473, 4320208, 4359726, 4419907, 4430206, 4443362, 4421839, 4214707, 4328068, 4421087, 4320392, 4446860, 4421258, 4446837, 4446857, 4421085, 4430204, 4258777, 4444176, 4397716, 4358644, 4446816, 4084014, 4442222, 4421845, 4424544, 4408811, 4406053, 4361718, 4346453, 4219391, 4300296, 4390814, 4417049, 4417106, 4398700, 4421283, 4421198, 4424548, 4359707, 4421275, 4315237, 3916093, 4169204, 4330778, 4397747, 4395947, 4343414, 4368851, 3996904, 4370975, 4421084, 4368850, 4359035, 4300278, 4329409, 4397730, 4393407, 4315823, 4327890, 4370980, 4342893, 4079373, 4370191, 4345524, 4258771, 4376052, 4371356, 4329414, 4315827, 4345514, 4329380, 4361693, 4320391, 4361639, 4357347, 4361708, 4359725, 4345651, 4329403, 4371087, 4329751, 4377655, 4315830, 4315978, 4358648, 4370981, 4172827, 4370978, 4358646, 4370977, 4361638, 3916051, 4243901, 4345528, 4320393, 4315973, 4361677, 4315196, 4320164, 4271095, 4320156, 4325413, 4315727, 4343455, 4194426, 4324811, 4320159, 4320161, 2887804, 4327894, 4327886, 4287989, 4273861, 4194415, 4320390, 4325411, 4111260, 4328023, 4240456, 3915556, 3883761, 4120719, 4273870, 4266892, 4243921, 4263591, 4287426, 4274893, 4266740, 4299312, 4273864, 4273866, 4293212, 4238956, 3851752, 4273104, 4001508, 4270717, 4169661, 4273074, 4240452, 4240539, 4273896, 4271906, 4185906, 4223937, 4182194, 4266881, 4204136, 4230766, 4230813, 4230786, 4244858, 3985727, 4244860, 4243784, 4243786, 4122918, 4191427, 4244016, 4111291, 4111295, 4182195, 4058755, 4138682, 3881254, 4230811, 4182196, 4182193, 4140123, 4157077, 4111257, 4172146, 4184788, 4184834, 4184369, 4182191, 4108697, 4150542, 4150550, 4150553, 3813972, 4227445, 4182259, 4150547, 3902477, 3953969, 4162546, 4135350, 4111299, 4060434, 4184371, 4058680, 4114699, 4140208, 3952553, 4172828, 4184325, 3853423, 4169582, 3732670, 3675263, 4098898, 4098907, 4129051, 4122936, 4098905, 4157008, 4098880, 3993483, 4016475, 4016485, 4051177, 4122937, 4098904, 4098893, 4098890, 4098886, 4138596, 4122935, 4098883, 4114717, 4055935, 4116650, 3994841, 4111253, 3853433, 3766830, 4092369, 3548117, 3475675, 4048756, 4060419, 4060427, 3993472, 4058739, 3993475, 3993473, 4060426, 3801783, 4048712, 4016464, 3863631, 4051169, 4051183, 4055931, 4051172, 4016512, 3863642, 4051167, 4051179, 4016513, 3764477, 3915555, 3990616, 3960205, 3863569, 3801842, 3863694, 3993468, 3993474, 4016511, 4016515, 3993471, 3994839, 4016472, 3902449, 3960206, 3717448, 3960207, 3881256, 3996886, 3814917, 3951548, 3960208, 3559566, 3976419, 3971288, 3917927, 3853424, 3996887, 3884225, 3916049, 3984741, 3950987, 3953825, 3884224, 3826458, 3884223, 3953941, 3951217, 3884220, 3870343, 3870341, 3870323, 3913487, 3766825, 3881253, 3852617, 3884193, 3916050, 3881251, 3884202, 3884221, 3881255, 3870348, 3852571, 3884205, 3813950, 3916048, 3881252, 3870344, 3813979, 3853421, 3870364, 3881250, 3814067, 3886191, 3870349, 3870351, 3777270, 3746522, 3681954, 3746526, 3884194, 3884222, 3813948, 3816842, 3439424, 3852602, 3852584, 3813953, 3849430, 3813824, 3764511, 3853684, 3474396, 3701987, 3766868, 3773861, 3813974, 3746531, 3764544, 3777013, 3813955, 3786117, 3764503, 3764532, 3746542, 3746553, 3776790, 3777015, 3764514, 3760259, 3760262, 3760264, 3777021, 3765456, 3777005, 3777024, 3746688, 3764570, 3765431, 3762073, 3764597, 3773862, 3766864, 3762074, 3762096, 3766867, 3766833, 3746538);

Date: 2025-01-19 17:26:53 Duration: 14ms

19

156,067

Details

33s282ms

0ms

16ms

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

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,339	243ms	0ms
	01	1,025	181ms	0ms
	02	590	106ms	0ms
	03	959	187ms	0ms
	04	602	109ms	0ms
	05	407	71ms	0ms
	06	442	83ms	0ms
	07	690	123ms	0ms
	08	3,192	575ms	0ms
	09	9,360	1s852ms	0ms
	10	16,395	3s615ms	0ms
	11	17,010	3s684ms	0ms
	12	17,198	3s670ms	0ms
	13	15,067	3s370ms	0ms
	14	13,082	2s688ms	0ms
	15	12,755	2s667ms	0ms
	16	10,250	2s316ms	0ms
	17	10,239	2s127ms	0ms
	18	10,545	2s198ms	0ms
	19	6,611	1s426ms	0ms
	20	4,567	1s205ms	0ms
	21	2,590	559ms	0ms
	22	1,152	215ms	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 (1056) 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-19 13:26:27 Duration: 16ms
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 (1295) 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-19 17:21:53 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 (884) 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-19 17:21:53 Duration: 1ms

20

153,782

Details

9h54m27s

160ms

1s576ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,065	3m17s	185ms
	01	2,164	6m41s	185ms
	02	2,335	7m14s	186ms
	03	2,774	8m39s	187ms
	04	2,009	6m13s	186ms
	05	2,695	8m15s	184ms
	06	1,756	5m22s	183ms
	07	1,180	3m39s	185ms
	08	3,318	10m20s	187ms
	09	7,248	24m15s	200ms
	10	6,030	21m41s	215ms
	11	10,803	38m37s	214ms
	12	6,528	22m55s	210ms
	13	10,942	40m36s	222ms
	14	6,223	20m44s	199ms
	15	13,741	48m30s	211ms
	16	16,161	57m37s	213ms
	17	4,165	15m17s	220ms
	18	637	2m26s	230ms
	19	9,828	37m35s	229ms
	20	38,535	3h10m17s	296ms
	21	3,293	12m53s	234ms
	22	352	1m15s	215ms

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

Date: 2025-01-19 20:22:50 Duration: 1s576ms
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" = '9852863')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-19 20:23:02 Duration: 1s555ms
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" = '9900966')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-19 20:15:47 Duration: 1s528ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m57s

2m19s

34

Details

1h18m57s

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 19	00	1	59m57s	59m57s
	02	1	0ms	0ms
	03	1	10m5s	10m5s
	08	2	0ms	0ms
	09	5	6ms	1ms
	10	2	3ms	1ms
	11	6	8m54s	1m29s
	12	2	3ms	1ms
	13	1	1ms	1ms
	14	5	6ms	1ms
	16	2	3ms	1ms
	18	1	1ms	1ms
	19	1	0ms	0ms
	20	3	5ms	1ms
	21	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-18 23:31:16.135004', "last_update" = '2025-01-18 22:46:16.135027', "write_date" = '2025-01-18 22:46:15.742928', "write_uid" = 1434 WHERE id IN (1434);

Date: 2025-01-19 00:46:13 Duration: 59m57s
UPDATE "res_users" SET "exp_date" = '2025-01-19 03:07:15.254945', "last_update" = '2025-01-19 02:22:15.254968', "write_date" = '2025-01-19 02:22:14.930995', "write_uid" = 1 WHERE id IN (847);

Date: 2025-01-19 03:32:20 Duration: 10m5s
UPDATE "res_users" SET "exp_date" = '2025-01-19 11:03:26.344005', "last_update" = '2025-01-19 10:18:26.344034', "write_date" = '2025-01-19 10:18:25.914984', "write_uid" = 959 WHERE id IN (959);

Date: 2025-01-19 11:27:21 Duration: 8m54s

2

0ms

55m43s

33s604ms

281

Details

2h37m22s

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 19	00	2	0ms	0ms
	01	3	1ms	0ms
	02	3	55m43s	18m34s
	03	2	3ms	1ms
	05	1	1ms	1ms
	06	3	3ms	1ms
	07	3	0ms	0ms
	08	12	6ms	0ms
	09	32	42ms	1ms
	10	28	44ms	1ms
	11	23	2m56s	7s672ms
	12	33	18m36s	33s832ms
	13	20	1m41s	5s56ms
	14	23	20m43s	54s76ms
	15	19	16m17s	51s454ms
	16	15	24ms	1ms
	17	15	6m23s	25s555ms
	18	15	13ms	0ms
	19	9	9ms	1ms
	20	9	16ms	1ms
	21	8	34m59s	4m22s
	22	3	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-19 01:17:21.697922', "last_update" = '2025-01-19 00:32:21.697944', "sid" = '8a084105fd7e5cebd952c1fea51a284e3fd68f33', "write_date" = '2025-01-19 00:32:21.373363', "write_uid" = 1434 WHERE id IN (1434);

Date: 2025-01-19 02:28:05 Duration: 55m43s
UPDATE "res_users" SET "exp_date" = '2025-01-19 13:29:17.944299', "last_update" = '2025-01-19 12:44:17.944322', "sid" = 'b56b838c615f9373281c5949b3568e1dbb77ff0e', "write_date" = '2025-01-19 12:44:17.599000', "write_uid" = 841 WHERE id IN (841);

Date: 2025-01-19 14:02:21 Duration: 18m3s
UPDATE "res_users" SET "exp_date" = '2025-01-19 21:17:57.896834', "last_update" = '2025-01-19 20:32:57.896855', "sid" = 'fcc1ffcb54e70e61216377dbc1cf3818dc229f13', "write_date" = '2025-01-19 20:32:57.577207', "write_uid" = 1 WHERE id IN (870);

Date: 2025-01-19 21:50:20 Duration: 17m22s

3

0ms

19m15s

22s282ms

114

Details

42m20s

insert into res_groups_users_rel (uid, gid) values (?, ?) on conflict do nothing;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 19	13	13	4ms	0ms
	14	7	2ms	0ms
	16	1	0ms	0ms
	17	7	42m20s	6m2s
	18	68	17ms	0ms
	19	18	5ms	0ms

INSERT INTO res_groups_users_rel (uid, gid) VALUES (1219, 325) ON CONFLICT DO NOTHING;

Date: 2025-01-19 17:05:20 Duration: 19m15s
INSERT INTO res_groups_users_rel (uid, gid) VALUES (1219, 325) ON CONFLICT DO NOTHING;

Date: 2025-01-19 17:05:20 Duration: 18m40s
INSERT INTO res_groups_users_rel (uid, gid) VALUES (1219, 325) ON CONFLICT DO NOTHING;

Date: 2025-01-19 17:05:20 Duration: 4m24s

4

0ms

20m32s

19s803ms

120

Details

39m36s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 19	13	18	4ms	0ms
	14	9	6ms	0ms
	16	1	0ms	0ms
	17	6	22m27s	3m44s
	18	67	17m9s	15s363ms
	19	19	5ms	0ms

UPDATE "res_users" SET "write_date" = '2025-01-19 15:44:47.935605', "write_uid" = 2 WHERE id IN (1219);

Date: 2025-01-19 17:05:20 Duration: 20m32s
UPDATE "res_users" SET "write_date" = '2025-01-19 17:40:11.118770', "write_uid" = 2 WHERE id IN (855);

Date: 2025-01-19 18:57:20 Duration: 17m9s
UPDATE "res_users" SET "write_date" = '2025-01-19 16:03:26.231085', "write_uid" = 2 WHERE id IN (1219);

Date: 2025-01-19 17:05:20 Duration: 1m54s

5

0ms

1h

5s115ms

69,270

Details

4d2h25m56s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 19	00	872	208ms	0ms
	01	1,232	2h59m15s	8s730ms
	02	952	217ms	0ms
	03	1,257	2h5m59s	6s13ms
	04	1,019	254ms	0ms
	05	543	119ms	0ms
	06	358	84ms	0ms
	07	537	119ms	0ms
	08	1,413	4h7m25s	10s506ms
	09	4,718	13h43m38s	10s474ms
	10	7,367	9h13m29s	4s507ms
	11	7,477	7h10m45s	3s456ms
	12	6,794	9h42m54s	5s147ms
	13	6,525	4h28m11s	2s466ms
	14	5,057	9h27m18s	6s731ms
	15	5,946	5h19m3s	3s219ms
	16	4,457	4h2m38s	3s266ms
	17	3,769	12h59m59s	12s416ms
	18	3,169	6h16m34s	7s129ms
	19	2,047	6m51s	200ms
	20	1,853	22m38s	733ms
	21	1,327	6h19m9s	17s143ms
	22	581	133ms	0ms

update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:28:47.956262', exp_date = '2025-01-19 00:13:47.956266', logged_in = 'TRUE' where id = 847;

Date: 2025-01-19 01:28:48 Duration: 1h
update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:28:47.956098', exp_date = '2025-01-19 00:13:47.956102', logged_in = 'TRUE' where id = 847;

Date: 2025-01-19 01:28:48 Duration: 1h
update res_users set sid = 'e8e6164bb91f3276232812779bfd839f578fc2a0', last_update = '2025-01-18 23:29:32.685918', exp_date = '2025-01-19 00:14:32.685922', logged_in = 'TRUE' where id = 847;

Date: 2025-01-19 01:28:48 Duration: 59m15s

6

36ms

1s965ms

928ms

10,037

Details

2h35m22s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 19	00	465	6m47s	876ms
	01	230	3m22s	882ms
	02	509	7m26s	877ms
	03	1,032	15m7s	879ms
	07	4	3s538ms	884ms
	08	5	3s862ms	772ms
	09	60	55s915ms	931ms
	11	6	6s401ms	1s66ms
	12	81	1m24s	1s45ms
	13	16	15s897ms	993ms
	14	371	5m41s	920ms
	15	210	3m24s	972ms
	16	466	7m37s	982ms
	17	540	8m4s	897ms
	18	1,919	30m	938ms
	19	1,114	16m21s	881ms
	20	1,777	30m37s	1s33ms
	21	883	12m37s	858ms
	22	349	5m22s	923ms

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

Date: 2025-01-19 20:16:18 Duration: 1s965ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9847449')) 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 (11))))))) 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 (11)))))) 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 (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-19 20:34:00 Duration: 1s957ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9910101')) 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 (11))))))) 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 (11)))))) 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 (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-19 20:16:01 Duration: 1s925ms

7

482ms

4s904ms

599ms

43,801

Details

7h17m56s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 19	00	314	2m52s	548ms
	01	293	2m44s	561ms
	02	164	1m34s	579ms
	03	161	1m41s	632ms
	04	140	1m25s	607ms
	05	101	59s875ms	592ms
	06	103	56s620ms	549ms
	07	384	3m24s	533ms
	08	1,134	9m50s	520ms
	09	2,607	24m31s	564ms
	10	5,484	55m47s	610ms
	11	3,718	37m58s	612ms
	12	4,043	40m41s	603ms
	13	5,013	51m44s	619ms
	14	2,810	26m24s	563ms
	15	3,062	29m43s	582ms
	16	2,883	29m31s	614ms
	17	3,187	31m9s	586ms
	18	2,893	28m20s	587ms
	19	2,435	23m46s	585ms
	20	1,582	20m4s	761ms
	21	766	7m55s	621ms
	22	524	4m47s	549ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4566811, 4561796, 4558758, 4543715, 4543179, 4519822, 4506903)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:22:43 Duration: 4s904ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4612127, 4612122, 4612116, 4612110, 4612105, 4612099, 4612093, 4612085, 4612080, 4612073, 4612068, 4612062, 4612056, 4612050, 4612043, 4612037, 4612031, 4612025, 4612020, 4612015, 4612009, 4612003, 4611997, 4611990, 4611985, 4611979, 4611973, 4611967, 4611961, 4611955, 4611949, 4611943, 4611937, 4611931, 4611925, 4611919, 4611913, 4611907, 4611902, 4611896, 4611890, 4611884, 4611878, 4611872, 4611866, 4611861, 4611856, 4611852, 4611849, 4611846)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:33:25 Duration: 4s347ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4611087, 4609033)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:18:16 Duration: 4s143ms

8

380ms

5s441ms

583ms

264,730

Details

1d18h56m12s

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

Day	Hour	Count	Duration	Avg duration
Jan 19	00	7,124	1h2m58s	530ms
	01	9,218	1h21m22s	529ms
	02	6,595	58m5s	528ms
	03	11,294	1h41m23s	538ms
	04	9,206	1h20m51s	527ms
	05	5,082	43m5s	508ms
	06	3,646	32m38s	537ms
	07	2,982	25m18s	509ms
	08	3,776	32m11s	511ms
	09	10,536	1h36m50s	551ms
	10	20,465	3h21m26s	590ms
	11	16,337	2h41m3s	591ms
	12	17,566	2h50m11s	581ms
	13	16,734	2h46m53s	598ms
	14	9,084	1h23m47s	553ms
	15	11,897	1h55m22s	581ms
	16	16,378	2h43m55s	600ms
	17	14,833	2h25m36s	588ms
	18	14,552	2h27m47s	609ms
	19	13,237	2h9m31s	587ms
	20	20,247	3h55m57s	699ms
	21	20,301	3h25m40s	607ms
	22	3,640	34m8s	562ms

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

Date: 2025-01-19 20:16:14 Duration: 5s441ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4612542)) AND (("shipping_track"."id" not in (38089162, 38089162)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:15:39 Duration: 5s34ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4612554)) AND (("shipping_track"."id" not in (38089268, 38089268)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-19 20:15:57 Duration: 5s18ms

9

184ms

677ms

299ms

22,546

Details

1h52m41s

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 19	07	125	31s149ms	249ms
	08	838	3m39s	262ms
	09	2,100	9m37s	275ms
	10	973	5m17s	325ms
	11	3,751	18m23s	294ms
	12	1,792	9m6s	304ms
	13	3,763	19m40s	313ms
	14	2,548	11m47s	277ms
	15	2,667	13m32s	304ms
	16	1,838	9m55s	324ms
	17	817	4m7s	303ms
	18	182	54s663ms	300ms
	19	927	4m47s	310ms
	20	225	1m17s	344ms

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

Date: 2025-01-19 10:11:59 Duration: 677ms
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" = '488930')))) ORDER BY "collection_policy"."id";

Date: 2025-01-19 10:24:23 Duration: 673ms
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" = '9701449')))) ORDER BY "collection_policy"."id";

Date: 2025-01-19 10:24:23 Duration: 635ms

10

208ms

2s60ms

283ms

18,475

Details

1h27m25s

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 19	00	888	3m47s	255ms
	01	1,182	5m6s	259ms
	02	578	2m23s	248ms
	03	1,109	4m42s	254ms
	04	1,043	4m27s	256ms
	06	1,010	4m14s	252ms
	07	71	17s475ms	246ms
	08	20	5s63ms	253ms
	09	303	1m13s	242ms
	10	31	9s704ms	313ms
	11	181	52s169ms	288ms
	12	80	25s479ms	318ms
	13	268	1m12s	271ms
	14	183	50s50ms	273ms
	15	389	1m49s	280ms
	16	1,305	6m4s	279ms
	17	1,715	8m9s	285ms
	18	2,871	13m48s	288ms
	19	977	4m49s	296ms
	20	1,757	10m41s	364ms
	21	1,949	9m36s	295ms
	22	565	2m39s	281ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9953684')) 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-19 20:15:41 Duration: 2s60ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9955328')) 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-19 20:17:50 Duration: 2s56ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9945295')) 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-19 20:19:09 Duration: 2s6ms

11

176ms

427ms

282ms

3,560

Details

16m45s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 19	09	112	30s352ms	271ms
	10	98	28s165ms	287ms
	11	233	1m6s	286ms
	12	299	1m26s	290ms
	13	753	3m35s	286ms
	14	150	38s580ms	257ms
	15	267	1m10s	264ms
	16	846	4m2s	286ms
	17	539	2m31s	280ms
	18	247	1m10s	286ms
	19	16	4s300ms	268ms

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

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

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

Date: 2025-01-19 13:38:56 Duration: 377ms

12

97ms

926ms

244ms

56,335

Details

3h49m57s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 19	00	2,676	10m18s	231ms
	01	2,788	10m5s	217ms
	02	2,144	7m17s	204ms
	03	4,252	16m55s	238ms
	04	2,064	8m1s	233ms
	06	2,012	7m27s	222ms
	07	148	34s410ms	232ms
	08	46	10s826ms	235ms
	09	702	2m34s	220ms
	10	58	15s63ms	259ms
	11	358	1m21s	228ms
	12	316	1m28s	278ms
	13	566	2m21s	249ms
	14	1,074	4m13s	235ms
	15	1,160	5m11s	268ms
	16	3,476	15m16s	263ms
	17	4,469	19m13s	258ms
	18	9,499	37m32s	237ms
	19	4,150	16m34s	239ms
	20	6,989	32m3s	275ms
	21	5,588	23m25s	251ms
	22	1,800	7m34s	252ms

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-19 20:25:20 Duration: 926ms
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-19 17:35:12 Duration: 918ms
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-19 17:35:12 Duration: 917ms

13

160ms

1s576ms

231ms

153,782

Details

9h54m27s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,065	3m17s	185ms
	01	2,164	6m41s	185ms
	02	2,335	7m14s	186ms
	03	2,774	8m39s	187ms
	04	2,009	6m13s	186ms
	05	2,695	8m15s	184ms
	06	1,756	5m22s	183ms
	07	1,180	3m39s	185ms
	08	3,318	10m20s	187ms
	09	7,248	24m15s	200ms
	10	6,030	21m41s	215ms
	11	10,803	38m37s	214ms
	12	6,528	22m55s	210ms
	13	10,942	40m36s	222ms
	14	6,223	20m44s	199ms
	15	13,741	48m30s	211ms
	16	16,161	57m37s	213ms
	17	4,165	15m17s	220ms
	18	637	2m26s	230ms
	19	9,828	37m35s	229ms
	20	38,535	3h10m17s	296ms
	21	3,293	12m53s	234ms
	22	352	1m15s	215ms

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

Date: 2025-01-19 20:22:50 Duration: 1s576ms
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" = '9852863')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-19 20:23:02 Duration: 1s555ms
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" = '9900966')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-19 20:15:47 Duration: 1s528ms

14

163ms

330ms

212ms

5,962

Details

21m4s

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 19	06	348	1m4s	183ms
	07	117	21s948ms	187ms
	09	490	1m42s	208ms
	10	1,632	5m54s	216ms
	11	634	2m13s	210ms
	12	283	59s821ms	211ms
	13	278	1m2s	223ms
	14	143	28s434ms	198ms
	15	189	37s856ms	200ms
	16	647	2m18s	214ms
	17	758	2m39s	210ms
	18	221	51s662ms	233ms
	19	27	6s492ms	240ms
	21	124	28s423ms	229ms
	22	71	15s139ms	213ms

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

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

Date: 2025-01-19 10:57:33 Duration: 312ms
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" = '9851819')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) 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-19 21:20:53 Duration: 305ms

15

166ms

342ms

201ms

13,219

Details

44m29s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 19	00	32	6s84ms	190ms
	01	183	33s812ms	184ms
	02	122	22s399ms	183ms
	03	260	48s397ms	186ms
	04	101	18s773ms	185ms
	05	470	1m27s	185ms
	06	793	2m26s	185ms
	07	813	2m31s	185ms
	08	980	3m1s	184ms
	09	2,213	7m25s	201ms
	10	1,027	3m45s	219ms
	11	2,096	7m21s	210ms
	12	1,062	3m38s	205ms
	13	969	3m29s	215ms
	14	816	2m41s	197ms
	15	464	1m32s	200ms
	16	421	1m28s	210ms
	17	165	38s163ms	231ms
	19	95	20s840ms	219ms
	20	2	462ms	231ms
	21	39	9s773ms	250ms
	22	96	21s69ms	219ms

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" = '9791121')) 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-19 11:08:45 Duration: 342ms
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" = '9813296')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) 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-19 16:09:08 Duration: 335ms
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" = '9943155')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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-19 10:03:23 Duration: 335ms

16

152ms

233ms

187ms

10,907

Details

34m7s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 19	00	1,009	3m4s	183ms
	01	1,965	6m7s	186ms
	02	1,796	5m36s	187ms
	03	2,405	7m40s	191ms
	04	1,616	5m9s	191ms
	05	1,709	5m14s	184ms
	06	396	1m13s	184ms
	22	11	1s931ms	175ms

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" = '9480912')) 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-19 04:18:02 Duration: 233ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9723973')) 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, 36, 37, 40, 41, 42, 43, 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-19 03:44:25 Duration: 232ms
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 (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-19 03:42:27 Duration: 231ms

17

93ms

571ms

120ms

18,330

Details

36m46s

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 19	00	94	10s992ms	116ms
	01	38	4s457ms	117ms
	03	30	3s188ms	106ms
	04	3	310ms	103ms
	07	38	4s396ms	115ms
	08	258	29s91ms	112ms
	09	1,304	2m30s	115ms
	10	1,852	3m51s	124ms
	11	1,425	2m57s	124ms
	12	2,637	5m18s	120ms
	13	2,065	4m16s	124ms
	14	1,590	3m2s	115ms
	15	1,360	2m40s	117ms
	16	2,110	4m18s	122ms
	17	1,744	3m19s	114ms
	18	594	1m10s	119ms
	19	626	1m15s	120ms
	20	219	34s87ms	155ms
	21	277	31s969ms	115ms
	22	66	7s492ms	113ms

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

Date: 2025-01-19 20:21:08 Duration: 571ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8007934)) AND (("cash_track"."id" not in (7139391)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-19 20:15:54 Duration: 337ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8008014)) AND (("cash_track"."id" not in (7139532)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-19 20:22:57 Duration: 295ms

18

41ms

320ms

66ms

59,587

Details

1h5m43s

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 19	00	42	2s624ms	62ms
	01	115	7s150ms	62ms
	02	28	1s787ms	63ms
	06	3	190ms	63ms
	07	338	20s824ms	61ms
	08	1,061	1m5s	61ms
	09	4,308	4m35s	63ms
	10	3,274	3m47s	69ms
	11	4,310	5m3s	70ms
	12	5,684	6m23s	67ms
	13	12,391	14m4s	68ms
	14	5,387	5m47s	64ms
	15	4,839	5m25s	67ms
	16	5,000	5m57s	71ms
	17	4,069	3m59s	58ms
	18	1,108	1m1s	55ms
	19	2,724	2m21s	52ms
	20	4,877	5m36s	69ms
	21	28	1s615ms	57ms
	22	1	51ms	51ms

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

Date: 2025-01-19 20:23:44 Duration: 320ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4554155) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-19 20:33:31 Duration: 319ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4556974) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-19 20:23:44 Duration: 309ms

19

37ms

130ms

60ms

22,213

Details

22m17s

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 19	07	126	7s116ms	56ms
	08	428	23s997ms	56ms
	09	1,872	1m50s	59ms
	10	1,060	1m7s	63ms
	11	2,039	2m9s	63ms
	12	2,158	2m14s	62ms
	13	4,308	4m27s	62ms
	14	2,540	2m30s	59ms
	15	2,837	2m52s	60ms
	16	2,043	2m11s	64ms
	17	1,496	1m19s	52ms
	18	341	16s882ms	49ms
	19	741	34s454ms	46ms
	20	224	11s541ms	51ms

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

Date: 2025-01-19 16:10:31 Duration: 130ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4456977) ORDER BY "collection_policy"."id";

Date: 2025-01-19 16:18:43 Duration: 125ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4316588) ORDER BY "collection_policy"."id";

Date: 2025-01-19 16:18:43 Duration: 112ms

20

33ms

292ms

45ms

147,520

Details

1h50m46s

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 19	00	3,084	2m14s	43ms
	01	2,845	2m5s	44ms
	02	2,366	1m44s	44ms
	03	4,120	3m3s	44ms
	04	3,261	2m24s	44ms
	05	817	35s924ms	43ms
	06	694	27s858ms	40ms
	07	1,487	59s582ms	40ms
	08	2,160	1m26s	40ms
	09	7,678	5m25s	42ms
	10	13,339	10m7s	45ms
	11	13,565	10m16s	45ms
	12	14,361	10m39s	44ms
	13	14,445	11m	45ms
	14	7,653	5m23s	42ms
	15	7,696	5m37s	43ms
	16	7,144	5m27s	45ms
	17	8,329	6m6s	44ms
	18	8,517	6m18s	44ms
	19	7,531	5m34s	44ms
	20	9,497	8m36s	54ms
	21	4,918	3m44s	45ms
	22	2,013	1m24s	42ms

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

Date: 2025-01-19 20:17:48 Duration: 292ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4587747)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-19 20:33:47 Duration: 266ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4534038)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-19 20:13:04 Duration: 262ms

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,407,914 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	6	0.00%
DETAIL	16	0.00%
ERROR	4,282	0.02%
EVENTLOG	1,508	0.01%
FATAL	1,107	0.01%
HINT	5	0.00%
LOG	19,396,688	99.94%
STATEMENT	4,302	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
1107 FATAL entries
4282 ERROR entries
0 WARNING entries
1508 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,244 Max number of times the same event was reported
6,897 Total events found

Rank

Times reported

Error

1

2,244

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 19	00	16
	01	29
	02	21
	03	9
	04	8
	06	4
	07	12
	08	38
	09	118
	10	202
	11	420
	12	197
	13	208
	14	163
	15	135
	16	136
	17	149
	18	89
	19	61
	20	178
	21	40
	22	11

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

2

2,003

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 19	00	15
	01	27
	02	16
	03	4
	04	4
	06	4
	07	12
	08	37
	09	110
	10	193
	11	391
	12	189
	13	181
	14	157
	15	111
	16	109
	17	137
	18	83
	19	56
	20	122
	21	34
	22	11

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

3

990

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 19	00	1
	01	2
	02	1
	03	31
	08	53
	09	86
	10	96
	11	112
	12	138
	13	43
	14	99
	15	68
	16	51
	17	102
	18	48
	20	31
	21	28

LOG: could not send data to client: Broken pipe

4

990

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 19	00	1
	01	2
	02	1
	03	31
	08	53
	09	86
	10	96
	11	112
	12	138
	13	43
	14	99
	15	68
	16	51
	17	102
	18	48
	20	31
	21	28

5

353

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 19	00	1
	01	1
	02	1
	03	2
	08	13
	09	41
	10	33
	11	48
	12	59
	13	23
	14	33
	15	34
	16	12
	17	28
	18	16
	20	1
	21	7

6

164

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 19	03	1
	08	1
	09	23
	10	18
	11	29
	12	27
	13	9
	14	15
	15	15
	16	5
	17	15
	18	3
	20	1
	21	2

7

80

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 19	17	80

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

8

15

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 19	17	15

9

14

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 19	10	3
	11	2
	12	1
	13	1
	14	1
	17	6

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

10

12

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 19	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

6

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 19	10	1
	11	1
	14	3
	16	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

4

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 19	11	2
	16	2

ERROR: could not create unique index "bank_deposit_deposite_2_name"

13

3

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 19	11	3

ERROR: column sales_model.archive_date does not exist at character 378

14

3

Details

ERROR: function sum(...) does not exist

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 19	10	1
	11	2

ERROR: function sum(character varying) does not exist at character 97

15

3

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 19	11	3

FATAL: password authentication failed for user "postgres"

16

2

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 19	06	1
	18	1

17

2

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 19	06	1
	18	1

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 19	17	2

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

19

2

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 19	16	2

ERROR: deadlock detected
ERROR: deadlock detected

20

2

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 19	06	1
	18	1

21

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 19	17	1

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 19	14	1

ERROR: duplicate key value violates unique constraint "urgent_office_pkey"

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 19	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