pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Dec 16 23:47:42 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 47,594,375 log entries in 2m41s
Log start from 2024-12-16 00:00:00 to 2024-12-16 22:45:01

Global Stats

24,249 Number of unique normalized queries
20,344,332 Number of queries
7d12h32m15s Total query duration
2024-12-16 00:00:00 First query
2024-12-16 22:45:01 Last query
5,238 queries/s at 2024-12-16 11:51:23 Query peak

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

17,472 Number of events
25 Number of unique normalized events
6,609 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
20,344,332 Average queries per session
7d12h32m15s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

5,238 queries/s Query Peak
2024-12-16 11:51:23 Date

SELECT Traffic

Key values

3,650 queries/s Query Peak
2024-12-16 11:51:23 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,347 queries/s Query Peak
2024-12-16 09:24:11 Date

Queries duration

Key values

7d12h32m15s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 16	00	280,572	0ms	42m15s	183ms	2m37s	3m9s	13h12m57s
	01	293,808	0ms	1s54ms	15ms	2m37s	2m44s	3m8s
	02	191,769	0ms	980ms	16ms	1m39s	2m19s	2m32s
	03	232,514	0ms	1s19ms	19ms	2m7s	2m41s	3m56s
	04	218,403	0ms	1s821ms	21ms	2m17s	2m38s	3m15s
	05	195,946	0ms	1s329ms	21ms	2m19s	2m37s	3m2s
	06	250,325	0ms	3m38s	27ms	3m18s	4m	5m38s
	07	117,901	0ms	1s68ms	13ms	1m1s	1m45s	1m59s
	08	391,523	0ms	3s164ms	6ms	1m21s	1m26s	1m42s
	09	1,134,261	0ms	34m20s	27ms	5m58s	7m31s	4h28m47s
	10	1,618,963	0ms	9m58s	20ms	7m53s	18m25s	2h20m10s
	11	1,764,936	0ms	33m13s	27ms	38m28s	44m17s	4h55m56s
	12	1,749,449	0ms	18m19s	31ms	41m6s	1h56m17s	4h28m58s
	13	1,876,988	0ms	18m43s	32ms	37m31s	1h34m12s	5h10m54s
	14	1,683,271	0ms	8m39s	24ms	29m16s	37m47s	3h6m4s
	15	1,521,669	0ms	27m11s	24ms	5m50s	6m10s	4h13m14s
	16	1,538,361	0ms	19m50s	39ms	45m35s	1h29m4s	4h23m55s
	17	1,460,981	0ms	2m	21ms	28m21s	35m15s	45m38s
	18	1,209,960	0ms	30m43s	42ms	12m26s	1h11m19s	4h39m15s
	19	888,718	0ms	10m52s	23ms	6m52s	7m30s	1h42m31s
	20	678,242	0ms	1h	72ms	6m6s	7m6s	7h26m23s
	21	628,686	0ms	30m27s	43ms	8m49s	11m47s	3h29m36s
	22	417,086	0ms	59m34s	44ms	9m45s	9m57s	1h1m51s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 16	00	150,910	25ms	1m41s	2m26s	3m9s
	01	155,243	29ms	1m46s	2m36s	3m1s
	02	93,184	33ms	1m15s	1m39s	2m22s
	03	115,660	39ms	1m49s	2m7s	3m9s
	04	110,292	41ms	2m	2m17s	2m55s
	05	99,078	42ms	1m51s	2m19s	2m49s
	06	137,766	43ms	2m42s	3m2s	3m28s
	07	57,465	27ms	43s529ms	1m1s	1m49s
	08	224,467	10ms	1m9s	1m20s	1m39s
	09	666,522	17ms	4m33s	5m26s	7m22s
	10	968,600	16ms	5m48s	6m41s	7m54s
	11	1,085,742	12ms	5m	6m18s	7m47s
	12	1,060,762	12ms	5m7s	5m34s	7m32s
	13	1,138,947	14ms	6m2s	7m25s	8m11s
	14	1,013,466	13ms	4m57s	5m38s	6m46s
	15	887,536	14ms	4m49s	5m37s	5m53s
	16	929,879	14ms	4m41s	5m23s	6m29s
	17	894,350	19ms	6m34s	7m29s	7m53s
	18	725,827	35ms	9m2s	11m26s	12m56s
	19	526,466	27ms	5m21s	6m18s	7m17s
	20	397,097	30ms	4m27s	5m27s	7m5s
	21	375,609	39ms	5m37s	8m39s	11m46s
	22	245,306	61ms	8m8s	9m43s	10m41s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 16	00	16,800	4,069	142	0	2s263ms	108ms	155ms	235ms
	01	21,185	5,410	160	0	0ms	114ms	155ms	211ms
	02	11,165	3,777	145	0	0ms	72ms	101ms	173ms
	03	17,859	5,847	152	0	0ms	99ms	129ms	176ms
	04	19,788	4,996	142	0	0ms	110ms	145ms	201ms
	05	16,840	4,654	133	0	0ms	99ms	141ms	196ms
	06	26,219	7,613	142	0	23ms	189ms	267ms	1m51s
	07	5,505	1,895	166	0	0ms	40ms	57ms	94ms
	08	12,104	4,434	427	0	0ms	70ms	92ms	122ms
	09	55,118	18,167	648	0	268ms	316ms	447ms	791ms
	10	76,565	25,179	876	0	169ms	458ms	536ms	16m7s
	11	66,133	24,029	656	0	383ms	459ms	859ms	42m25s
	12	69,305	25,027	885	0	433ms	455ms	642ms	1h50m5s
	13	79,090	27,653	1,006	0	412ms	550ms	784ms	1h31m42s
	14	63,845	26,849	788	0	305ms	445ms	712ms	36m29s
	15	72,518	25,855	716	0	237ms	404ms	473ms	1s3ms
	16	61,763	22,929	633	0	565ms	440ms	6s442ms	1h27m27s
	17	73,981	25,242	886	2	145ms	837ms	1m7s	32m15s
	18	90,839	27,264	653	0	212ms	669ms	881ms	1h9m28s
	19	71,513	18,241	713	0	70ms	505ms	718ms	47s697ms
	20	58,435	13,439	638	1	514ms	351ms	457ms	38s327ms
	21	56,953	17,978	227	0	166ms	412ms	512ms	612ms
	22	48,926	17,574	118	0	54ms	384ms	567ms	851ms

Day	Hour	Percentage of prepare
Dec 16	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
Dec 16	00	0.00/s
	01	0.00/s
	02	0.00/s
	03	0.00/s
	04	0.00/s
	05	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	09	0.00/s
	10	0.00/s
	11	0.00/s
	12	0.00/s
	13	0.00/s
	14	0.00/s
	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s
	22	0.00/s

Day	Hour	Average Duration	Average idle time
Dec 16	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

178,929 buffers Checkpoint Peak
2024-12-16 18:16:21 Date
270.058 seconds Highest write time
0.016 seconds Sync time

Checkpoints Wal files

Key values

120 files Wal files usage Peak
2024-12-16 18:16:21 Date

Checkpoints distance

Key values

3,847.91 Mo Distance Peak
2024-12-16 18:16:21 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 16	00	133,315	3,239.526s	0.034s	3,239.602s
	01	141,800	3,225.604s	0.034s	3,225.679s
	02	128,234	3,239.554s	0.031s	3,239.628s
	03	124,978	3,220.614s	0.028s	3,220.689s
	04	128,052	3,239.508s	0.03s	3,239.584s
	05	117,288	3,239.57s	0.026s	3,239.639s
	06	122,741	3,239.578s	0.029s	3,239.65s
	07	77,085	2,784.012s	0.026s	2,784.073s
	08	92,071	3,050.893s	0.033s	3,050.96s
	09	368,339	3,239.565s	0.058s	3,239.692s
	10	512,508	3,239.433s	0.051s	3,239.575s
	11	493,114	3,239.492s	0.05s	3,239.618s
	12	538,158	3,239.553s	0.055s	3,239.691s
	13	535,257	3,239.442s	0.058s	3,239.6s
	14	493,060	3,239.531s	0.058s	3,239.668s
	15	462,072	3,239.512s	0.055s	3,239.641s
	16	397,645	3,239.503s	0.052s	3,239.636s
	17	426,632	2,889.921s	0.074s	2,890.079s
	18	562,160	3,239.384s	0.06s	3,239.579s
	19	274,836	3,239.579s	0.047s	3,239.695s
	20	273,424	3,239.476s	0.041s	3,239.591s
	21	176,238	3,239.6s	0.047s	3,239.698s
	22	204,759	2,429.649s	0.035s	2,429.725s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 16	00	0	57	3,227	0.002s	0.012s
	01	0	62	3,266	0.007s	0.012s
	02	0	57	2,533	0.002s	0.012s
	03	0	55	2,643	0.002s	0.012s
	04	0	59	2,584	0.002s	0.012s
	05	0	52	2,321	0.002s	0.012s
	06	0	57	2,605	0.002s	0.012s
	07	0	35	2,238	0.002s	0.012s
	08	0	37	3,362	0.002s	0.012s
	09	0	154	4,699	0.002s	0.012s
	10	0	218	5,169	0.003s	0.012s
	11	0	213	5,094	0.003s	0.012s
	12	0	231	5,399	0.003s	0.012s
	13	0	230	5,202	0.004s	0.012s
	14	0	211	5,339	0.003s	0.012s
	15	0	195	5,534	0.003s	0.012s
	16	0	171	5,491	0.002s	0.012s
	17	0	184	5,495	0.011s	0.012s
	18	12	271	5,478	0.003s	0.012s
	19	0	111	5,063	0.002s	0.012s
	20	0	110	5,139	0.002s	0.012s
	21	0	71	4,881	0.002s	0.012s
	22	0	84	3,562	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Dec 16	00	78,746.17 kB	122,851.42 kB
	01	84,147.58 kB	122,531.42 kB
	02	77,617.25 kB	111,087.50 kB
	03	75,758.25 kB	112,428.17 kB
	04	80,499.58 kB	112,833.58 kB
	05	70,631.75 kB	100,559.50 kB
	06	77,160.33 kB	95,584.50 kB
	07	48,737.92 kB	88,279.58 kB
	08	50,102.00 kB	71,247.08 kB
	09	209,781.00 kB	230,518.50 kB
	10	297,807.83 kB	349,822.08 kB
	11	286,183.45 kB	348,954.00 kB
	12	316,174.92 kB	403,874.00 kB
	13	307,960.09 kB	353,234.64 kB
	14	287,674.67 kB	361,180.42 kB
	15	264,751.00 kB	338,041.55 kB
	16	234,703.91 kB	324,739.36 kB
	17	240,694.36 kB	311,376.09 kB
	18	386,380.83 kB	1,148,674.92 kB
	19	154,325.91 kB	602,310.73 kB
	20	150,636.42 kB	277,285.75 kB
	21	96,614.33 kB	162,480.92 kB
	22	154,139.89 kB	172,361.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
Dec 16	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Dec 16	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

12,060,174 Total read queries
5,638,747 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	12,060,174	59.28%
INSERT	1,092,449	5.37%
UPDATE	358,121	1.76%
DELETE	11,052	0.05%
COPY FROM	3	0.00%
COPY TO	0	0.00%
CTE	32,695	0.16%
DDL	4,578	0.02%
TCL	4,139,849	20.35%
CURSOR	0	0.00%
OTHERS	2,645,411	13.00%

Queries by database

Key values

unknown Main database
20,344,332 Requests
7d12h32m15s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	20,344,332	7d12h32m15s
	copy from	3	3ms
	cte	32,695	6s983ms
	ddl	4,578	644ms
	delete	11,052	1s458ms
	insert	1,092,449	5m41s
	others	2,645,411	1m56s
	select	12,060,174	2d19h47m47s
	tcl	4,139,849	2m47s
	update	358,121	4d16h33m53s

Queries by user

Key values

unknown Main user
20,344,332 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	20,344,332	7d12h32m15s
	copy from	3	3ms
	cte	32,695	6s983ms
	ddl	4,578	644ms
	delete	11,052	1s458ms
	insert	1,092,449	5m41s
	others	2,645,411	1m56s
	select	12,060,174	2d19h47m47s
	tcl	4,139,849	2m47s
	update	358,121	4d16h33m53s

Duration by user

Key values

7d12h32m15s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	20,344,332	7d12h32m15s
	copy from	3	3ms
	cte	32,695	6s983ms
	ddl	4,578	644ms
	delete	11,052	1s458ms
	insert	1,092,449	5m41s
	others	2,645,411	1m56s
	select	12,060,174	2d19h47m47s
	tcl	4,139,849	2m47s
	update	358,121	4d16h33m53s

Queries by host

Key values

unknown Main host
20,344,332 Requests
7d12h32m15s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	20,344,332	7d12h32m15s
	copy from	3	3ms
	cte	32,695	6s983ms
	ddl	4,578	644ms
	delete	11,052	1s458ms
	insert	1,092,449	5m41s
	others	2,645,411	1m56s
	select	12,060,174	2d19h47m47s
	tcl	4,139,849	2m47s
	update	358,121	4d16h33m53s

Queries by application

Key values

unknown Main application
20,344,332 Requests
7d12h32m15s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	20,344,332	7d12h32m15s
	copy from	3	3ms
	cte	32,695	6s983ms
	ddl	4,578	644ms
	delete	11,052	1s458ms
	insert	1,092,449	5m41s
	others	2,645,411	1m56s
	select	12,060,174	2d19h47m47s
	tcl	4,139,849	2m47s
	update	358,121	4d16h33m53s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-16 12:51:13 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

18,995,705 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	18,995,705	93.37%
1-5ms	298,240	1.47%
5-10ms	14,477	0.07%
10-25ms	62,725	0.31%
25-50ms	246,055	1.21%
50-100ms	59,511	0.29%
100-500ms	618,367	3.04%
500-1000ms	40,525	0.20%
1000-10000ms	6,819	0.03%
> 10000ms	1,908	0.01%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = 'd0127ede5a1e628ccacef5912a0efb4a264f7642', last_update = '2024-12-16 18:14:09.996386', exp_date = '2024-12-16 18:59:09.996389', logged_in = 'TRUE' where id = 931; [ Date: 2024-12-16 20:14:10 ]
2	1h	update res_users set sid = 'd0127ede5a1e628ccacef5912a0efb4a264f7642', last_update = '2024-12-16 18:14:09.996382', exp_date = '2024-12-16 18:59:09.996386', logged_in = 'TRUE' where id = 931; [ Date: 2024-12-16 20:14:10 ]
3	59m34s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-16 20:18:48.322520', exp_date = '2024-12-16 21:03:48.322523', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-16 22:18:22 ]
4	58m25s	update res_users set sid = 'd0127ede5a1e628ccacef5912a0efb4a264f7642', last_update = '2024-12-16 18:15:44.466952', exp_date = '2024-12-16 19:00:44.466957', logged_in = 'TRUE' where id = 931; [ Date: 2024-12-16 20:14:10 ]
5	42m15s	update res_users set sid = '4367addc42a8e07aad9bc8f6725925974ca12db8', last_update = '2024-12-15 22:36:05.107288', exp_date = '2024-12-15 23:21:05.107291', logged_in = 'TRUE' where id = 999; [ Date: 2024-12-16 00:18:20 ]
6	42m15s	update res_users set sid = '4367addc42a8e07aad9bc8f6725925974ca12db8', last_update = '2024-12-15 22:36:05.107211', exp_date = '2024-12-15 23:21:05.107213', logged_in = 'TRUE' where id = 999; [ Date: 2024-12-16 00:18:20 ]
7	37m38s	update res_users set sid = '4367addc42a8e07aad9bc8f6725925974ca12db8', last_update = '2024-12-15 22:40:41.425233', exp_date = '2024-12-15 23:25:41.425238', logged_in = 'TRUE' where id = 999; [ Date: 2024-12-16 00:18:20 ]
8	36m14s	update res_users set sid = '4367addc42a8e07aad9bc8f6725925974ca12db8', last_update = '2024-12-15 22:42:05.229209', exp_date = '2024-12-15 23:27:05.229214', logged_in = 'TRUE' where id = 999; [ Date: 2024-12-16 00:18:20 ]
9	36m14s	update res_users set sid = '4367addc42a8e07aad9bc8f6725925974ca12db8', last_update = '2024-12-15 22:42:05.395343', exp_date = '2024-12-15 23:27:05.395346', logged_in = 'TRUE' where id = 999; [ Date: 2024-12-16 00:18:20 ]
10	34m56s	update res_users set sid = '18aad7e76d59b795a500e2de603bd604f2f99eb3', last_update = '2024-12-16 19:12:24.794669', exp_date = '2024-12-16 19:57:24.794672', logged_in = 'TRUE' where id = 847; [ Date: 2024-12-16 20:47:21 ]
11	34m56s	update res_users set sid = '18aad7e76d59b795a500e2de603bd604f2f99eb3', last_update = '2024-12-16 19:12:24.794074', exp_date = '2024-12-16 19:57:24.794078', logged_in = 'TRUE' where id = 847; [ Date: 2024-12-16 20:47:21 ]
12	34m34s	update res_users set sid = '4367addc42a8e07aad9bc8f6725925974ca12db8', last_update = '2024-12-15 22:43:45.736158', exp_date = '2024-12-15 23:28:45.736163', logged_in = 'TRUE' where id = 999; [ Date: 2024-12-16 00:18:20 ]
13	34m34s	update res_users set sid = '4367addc42a8e07aad9bc8f6725925974ca12db8', last_update = '2024-12-15 22:43:45.752941', exp_date = '2024-12-15 23:28:45.752945', logged_in = 'TRUE' where id = 999; [ Date: 2024-12-16 00:18:20 ]
14	34m20s	update res_users set sid = '2d25aad362a135a1522f10772d4dfc62dc2065d8', last_update = '2024-12-16 08:16:00.813435', exp_date = '2024-12-16 09:01:00.813438', logged_in = 'TRUE' where id = 1279; [ Date: 2024-12-16 09:50:20 ]
15	34m20s	update res_users set sid = '2d25aad362a135a1522f10772d4dfc62dc2065d8', last_update = '2024-12-16 08:16:00.813340', exp_date = '2024-12-16 09:01:00.813343', logged_in = 'TRUE' where id = 1279; [ Date: 2024-12-16 09:50:20 ]
16	34m16s	update res_users set sid = '18aad7e76d59b795a500e2de603bd604f2f99eb3', last_update = '2024-12-16 19:13:05.120448', exp_date = '2024-12-16 19:58:05.120453', logged_in = 'TRUE' where id = 847; [ Date: 2024-12-16 20:47:21 ]
17	33m13s	update res_users set sid = '785eb774bdfc5d76d424911054ab1dcc4c0a27f7', last_update = '2024-12-16 09:47:06.499347', exp_date = '2024-12-16 10:32:06.499350', logged_in = 'TRUE' where id = 947; [ Date: 2024-12-16 11:20:20 ]
18	33m13s	update res_users set sid = '785eb774bdfc5d76d424911054ab1dcc4c0a27f7', last_update = '2024-12-16 09:47:06.499914', exp_date = '2024-12-16 10:32:06.499918', logged_in = 'TRUE' where id = 947; [ Date: 2024-12-16 11:20:20 ]
19	32m59s	update res_users set sid = '785eb774bdfc5d76d424911054ab1dcc4c0a27f7', last_update = '2024-12-16 09:47:20.721789', exp_date = '2024-12-16 10:32:20.721793', logged_in = 'TRUE' where id = 947; [ Date: 2024-12-16 11:20:20 ]
20	32m44s	update res_users set sid = '4d43a77339e56d753208075aa1ca86e88ad479a9', last_update = '2024-12-16 09:47:35.868402', exp_date = '2024-12-16 10:32:35.868406', logged_in = 'TRUE' where id = 947; [ Date: 2024-12-16 11:20:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d14h14m54s

89,582

Details

0ms

1h

4s430ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 16	00	811	13h11m8s	58s531ms
	01	1,092	229ms	0ms
	02	643	132ms	0ms
	03	1,224	252ms	0ms
	04	674	141ms	0ms
	05	603	124ms	0ms
	06	577	4m8s	430ms
	07	271	57ms	0ms
	08	1,528	313ms	0ms
	09	5,198	5h30m50s	3s818ms
	10	7,935	4h43m44s	2s145ms
	11	9,207	9h30m6s	3s715ms
	12	8,958	10h50m43s	4s358ms
	13	9,494	11h52m40s	4s503ms
	14	9,311	7h36m23s	2s941ms
	15	7,517	6h32m14s	3s130ms
	16	6,606	13h19m31s	7s261ms
	17	5,864	3h53m16s	2s386ms
	18	4,089	6h39m34s	5s863ms
	19	2,896	1h41m38s	2s105ms
	20	2,200	10h21m6s	16s939ms
	21	1,639	3h28m10s	7s621ms
	22	1,245	59m34s	2s871ms

update res_users set sid = 'd0127ede5a1e628ccacef5912a0efb4a264f7642', last_update = '2024-12-16 18:14:09.996386', exp_date = '2024-12-16 18:59:09.996389', logged_in = 'TRUE' where id = 931;

Date: 2024-12-16 20:14:10 Duration: 1h
update res_users set sid = 'd0127ede5a1e628ccacef5912a0efb4a264f7642', last_update = '2024-12-16 18:14:09.996382', exp_date = '2024-12-16 18:59:09.996386', logged_in = 'TRUE' where id = 931;

Date: 2024-12-16 20:14:10 Duration: 1h
update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-16 20:18:48.322520', exp_date = '2024-12-16 21:03:48.322523', logged_in = 'TRUE' where id = 843;

Date: 2024-12-16 22:18:22 Duration: 59m34s

2

1d6h3m56s

252,006

Details

355ms

826ms

429ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 16	00	5,884	37m50s	385ms
	01	6,965	45m6s	388ms
	02	4,834	30m59s	384ms
	03	6,776	43m42s	387ms
	04	7,266	47m20s	390ms
	05	6,200	40m21s	390ms
	06	7,095	47m29s	401ms
	07	2,703	17m4s	379ms
	08	3,455	21m59s	381ms
	09	12,151	1h22m41s	408ms
	10	18,016	2h6m46s	422ms
	11	14,435	1h41m43s	422ms
	12	13,978	1h37m47s	419ms
	13	16,684	2h33s	433ms
	14	12,089	1h24m32s	419ms
	15	11,849	1h21m59s	415ms
	16	12,712	1h28m28s	417ms
	17	15,174	1h56m4s	458ms
	18	22,059	2h58m46s	486ms
	19	15,461	1h56m52s	453ms
	20	11,924	1h28m30s	445ms
	21	11,128	1h25m13s	459ms
	22	13,168	1h42m2s	464ms

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

Date: 2024-12-16 21:52:03 Duration: 826ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3641127)) AND (("shipping_track"."id" not in (29756362, 29756362)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 18:39:36 Duration: 826ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3641169)) AND (("shipping_track"."id" not in (29756527, 29756527)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 18:39:54 Duration: 824ms

3

9h7m52s

145,310

Details

177ms

374ms

226ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 16	00	1,900	6m22s	201ms
	01	1,856	6m14s	201ms
	02	2,054	6m51s	200ms
	03	2,441	8m12s	201ms
	04	1,904	6m24s	201ms
	05	2,469	8m18s	201ms
	06	3,684	12m19s	200ms
	07	940	3m7s	199ms
	08	432	1m26s	200ms
	09	9,886	35m36s	216ms
	10	9,423	35m20s	224ms
	11	6,634	24m19s	220ms
	12	8,123	29m39s	219ms
	13	8,811	33m7s	225ms
	14	10,777	39m19s	218ms
	15	9,834	35m3s	213ms
	16	6,554	23m40s	216ms
	17	7,184	26m56s	225ms
	18	15,454	1h3m32s	246ms
	19	255	55s339ms	217ms
	20	222	47s16ms	211ms
	21	14,198	1h38s	256ms
	22	20,275	1h19m36s	235ms

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

Date: 2024-12-16 21:52:06 Duration: 374ms
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" = '456893')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-16 21:51:38 Duration: 373ms
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" = '9324960')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-16 21:52:06 Duration: 371ms

4

5h47m55s

47,871

Details

356ms

1s399ms

436ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 16	00	211	1m29s	423ms
	01	460	3m5s	402ms
	02	243	1m38s	405ms
	03	385	2m36s	407ms
	04	261	1m49s	421ms
	05	155	1m8s	440ms
	06	189	1m20s	425ms
	07	204	1m19s	391ms
	08	1,480	9m35s	388ms
	09	2,703	19m4s	423ms
	10	4,025	29m18s	436ms
	11	3,453	25m25s	441ms
	12	4,176	29m56s	430ms
	13	5,148	38m	442ms
	14	3,686	26m20s	428ms
	15	2,886	20m20s	423ms
	16	3,659	25m41s	421ms
	17	4,091	31m2s	455ms
	18	3,149	25m22s	483ms
	19	2,994	21m38s	433ms
	20	2,471	17m35s	427ms
	21	1,216	9m3s	447ms
	22	626	5m	479ms

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

Date: 2024-12-16 17:21:54 Duration: 1s399ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3319563)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 17:21:54 Duration: 1s153ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3655564, 3655563, 3655560, 3655558, 3655557, 3655555, 3655553, 3655551, 3655549, 3655548, 3655546, 3655544, 3655542, 3655540, 3655538, 3655537, 3655535, 3655534, 3655532, 3655531, 3655529, 3655528, 3655526, 3655524, 3655523, 3655521, 3655518, 3655515, 3655511, 3655509, 3655506, 3655502, 3655499, 3655495, 3655491, 3655488, 3655484, 3655480, 3655478, 3655474, 3655470, 3655467, 3655461, 3655457, 3655452, 3655447, 3655443, 3655438, 3655433, 3655429, 3655425, 3655420, 3655416)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 21:51:53 Duration: 775ms

5

4h40m36s

68,959

Details

89ms

932ms

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
Dec 16	00	1,048	3m53s	223ms
	01	1,512	5m17s	209ms
	02	466	1m50s	237ms
	03	1,158	4m11s	217ms
	04	2,024	6m51s	203ms
	05	1,650	5m59s	217ms
	06	3,880	14m29s	224ms
	07	4	1s67ms	266ms
	08	18	2s952ms	164ms
	09	16	4s17ms	251ms
	10	566	2m11s	231ms
	11	86	18s854ms	219ms
	12	670	2m40s	238ms
	13	650	2m43s	251ms
	14	1,144	5m8s	269ms
	15	1,696	6m48s	240ms
	16	3,194	12m20s	231ms
	17	6,098	25m1s	246ms
	18	10,714	47m6s	263ms
	19	10,297	41m26s	241ms
	20	8,168	34m29s	253ms
	21	8,050	32m16s	240ms
	22	5,850	25m21s	260ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'طارق')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-16 22:24:21 Duration: 932ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-16 22:24:21 Duration: 932ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'اشرف')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-16 19:31:33 Duration: 914ms

6

3h59m24s

14,215

Details

254ms

2s50ms

1s10ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 16	00	320	5m4s	951ms
	01	243	3m51s	952ms
	02	49	46s582ms	950ms
	03	225	3m36s	960ms
	08	3	2s807ms	935ms
	09	8	7s839ms	979ms
	10	193	3m29s	1s86ms
	12	5	1s531ms	306ms
	13	148	2m40s	1s84ms
	15	271	4m35s	1s16ms
	16	737	12m21s	1s5ms
	17	1,447	25m5s	1s40ms
	18	3,293	59m55s	1s91ms
	19	1,317	20m21s	927ms
	20	2,267	36m39s	970ms
	21	2,344	37m36s	962ms
	22	1,345	23m8s	1s32ms

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

Date: 2024-12-16 18:23:57 Duration: 2s50ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '8863046')) 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 (16))))))) 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 (16)))))) 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 (16)))))) 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 (16))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 18:38:10 Duration: 1s699ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9213463')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 18:14:40 Duration: 1s505ms

7

2h14m54s

29,761

Details

188ms

467ms

271ms

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

Day	Hour	Count	Duration	Avg duration
Dec 16	08	133	32s248ms	242ms
	09	2,940	12m44s	259ms
	10	3,039	13m50s	273ms
	11	2,997	13m27s	269ms
	12	2,764	12m23s	269ms
	13	2,947	13m35s	276ms
	14	3,624	16m14s	269ms
	15	3,596	15m25s	257ms
	16	2,104	9m19s	266ms
	17	2,914	13m36s	280ms
	18	2,703	13m43s	304ms

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

Date: 2024-12-16 18:39:55 Duration: 467ms
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" = '9238576')))) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:39:54 Duration: 464ms
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" = '9239937')))) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:40:15 Duration: 439ms

8

1h48m39s

20,654

Details

227ms

640ms

315ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 16	00	216	1m3s	292ms
	01	522	2m31s	290ms
	02	188	55s152ms	293ms
	03	358	1m43s	289ms
	04	1,028	4m58s	290ms
	05	831	4m1s	290ms
	06	1,952	9m27s	290ms
	07	2	592ms	296ms
	08	7	2s143ms	306ms
	10	97	33s520ms	345ms
	11	44	14s313ms	325ms
	12	341	1m50s	323ms
	13	183	1m1s	335ms
	14	587	3m8s	321ms
	15	593	3m9s	318ms
	16	879	4m41s	320ms
	17	1,642	9m	329ms
	18	2,135	12m13s	343ms
	19	3,880	20m27s	316ms
	20	1,855	9m25s	305ms
	21	1,717	9m	314ms
	22	1,597	9m8s	343ms

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

Date: 2024-12-16 18:15:03 Duration: 640ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9402903')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 18:22:06 Duration: 509ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9415029')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 14:44:02 Duration: 500ms

9

1h44m30s

398

Details

0ms

18m19s

15s754ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 16	00	4	1m19s	19s928ms
	01	3	4ms	1ms
	02	1	0ms	0ms
	05	3	3ms	1ms
	06	1	1ms	1ms
	07	1	0ms	0ms
	08	6	3ms	0ms
	09	34	23ms	0ms
	10	35	5m42s	9s777ms
	11	39	9m8s	14s57ms
	12	43	37m17s	52s44ms
	13	35	7m34s	12s994ms
	14	57	8m19s	8s757ms
	15	25	26ms	1ms
	16	32	4m22s	8s190ms
	17	29	7m41s	15s913ms
	18	19	19m41s	1m2s
	19	11	3m22s	18s432ms
	20	10	7ms	0ms
	21	7	10ms	1ms
	22	3	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-16 12:10:01.825861', "last_update" = '2024-12-16 11:25:01.825886', "sid" = '84ac83dec3ae8a7aa3d23f0c66823bbf92833d6b', "write_date" = '2024-12-16 11:25:01.411142', "write_uid" = 875 WHERE id IN (875);

Date: 2024-12-16 12:43:20 Duration: 18m19s
UPDATE "res_users" SET "exp_date" = '2024-12-16 12:14:51.783492', "last_update" = '2024-12-16 11:29:51.783511', "sid" = '6a696d699a4e429a42ee904addcedcc82dcf02b4', "write_date" = '2024-12-16 11:29:51.427282', "write_uid" = 1 WHERE id IN (1034);

Date: 2024-12-16 12:43:20 Duration: 13m29s
UPDATE "res_users" SET "exp_date" = '2024-12-16 17:46:00.711361', "last_update" = '2024-12-16 17:01:00.711387', "sid" = 'c95eaba7a8ff411d7ec6ab9e1ba278af0e1e866d', "write_date" = '2024-12-16 17:01:00.318883', "write_uid" = 1 WHERE id IN (904);

Date: 2024-12-16 18:09:13 Duration: 8m12s

10

1h42m42s

154,780

Details

29ms

129ms

39ms

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

Day	Hour	Count	Duration	Avg duration
Dec 16	00	2,450	1m29s	36ms
	01	3,049	1m52s	36ms
	02	1,421	51s974ms	36ms
	03	2,686	1m38s	36ms
	04	2,339	1m26s	36ms
	05	1,756	1m4s	36ms
	06	1,497	55s519ms	37ms
	07	593	21s140ms	35ms
	08	2,189	1m20s	36ms
	09	9,680	6m16s	38ms
	10	13,306	8m53s	40ms
	11	11,527	7m44s	40ms
	12	11,765	7m47s	39ms
	13	13,732	9m22s	40ms
	14	9,883	6m31s	39ms
	15	10,455	6m46s	38ms
	16	9,708	6m17s	38ms
	17	10,049	6m58s	41ms
	18	10,496	7m37s	43ms
	19	8,889	5m53s	39ms
	20	6,630	4m18s	39ms
	21	6,835	4m35s	40ms
	22	3,845	2m39s	41ms

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

Date: 2024-12-16 17:21:54 Duration: 129ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3319563)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-16 17:21:54 Duration: 122ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3602801)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-16 12:01:38 Duration: 91ms

11

48m53s

66,215

Details

30ms

98ms

44ms

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

Day	Hour	Count	Duration	Avg duration
Dec 16	00	138	5s340ms	38ms
	01	12	501ms	41ms
	02	15	640ms	42ms
	03	11	468ms	42ms
	04	3	129ms	43ms
	07	11	464ms	42ms
	08	334	13s428ms	40ms
	09	7,087	4m54s	41ms
	10	6,055	4m21s	43ms
	11	3,496	2m29s	42ms
	12	4,899	3m29s	42ms
	13	7,802	5m41s	43ms
	14	7,731	5m27s	42ms
	15	9,559	6m40s	41ms
	16	5,842	4m4s	41ms
	17	5,803	4m52s	50ms
	18	6,229	5m31s	53ms
	19	608	30s478ms	50ms
	20	257	12s692ms	49ms
	21	181	9s185ms	50ms
	22	142	7s456ms	52ms

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

Date: 2024-12-16 10:44:03 Duration: 98ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3616752) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:13:17 Duration: 94ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3571335) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:14:41 Duration: 85ms

12

48m46s

13,775

Details

180ms

326ms

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"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 16	00	319	1m3s	199ms
	02	229	45s923ms	200ms
	03	352	1m11s	202ms
	04	239	48s129ms	201ms
	05	353	1m10s	200ms
	06	3,071	10m17s	201ms
	07	631	2m6s	200ms
	08	340	1m8s	200ms
	09	812	2m54s	215ms
	10	429	1m37s	226ms
	11	917	3m27s	226ms
	12	837	3m7s	224ms
	13	1,129	4m11s	222ms
	14	1,321	4m49s	219ms
	15	1,072	3m48s	213ms
	16	435	1m35s	218ms
	17	447	1m38s	221ms
	18	346	1m16s	220ms
	19	255	55s551ms	217ms
	20	222	47s144ms	212ms
	21	5	1s48ms	209ms
	22	14	3s876ms	276ms

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

Date: 2024-12-16 12:59:39 Duration: 326ms
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" = '9293692')) 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 (1)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2024-12-16 12:20:15 Duration: 295ms

13

37m43s

23,369

Details

77ms

221ms

96ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 16	00	2	204ms	102ms
	01	16	1s512ms	94ms
	02	16	1s473ms	92ms
	03	13	1s238ms	95ms
	04	11	1s12ms	92ms
	07	33	3s51ms	92ms
	08	281	26s403ms	93ms
	09	2,136	3m22s	94ms
	10	1,942	3m8s	97ms
	11	2,071	3m20s	97ms
	12	2,580	4m9s	96ms
	13	2,854	4m45s	99ms
	14	2,727	4m23s	96ms
	15	2,482	3m56s	95ms
	16	1,553	2m29s	96ms
	17	1,664	2m45s	99ms
	18	1,012	1m42s	100ms
	19	930	1m26s	92ms
	20	731	1m6s	91ms
	21	254	25s438ms	100ms
	22	61	5s680ms	93ms

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

Date: 2024-12-16 11:49:27 Duration: 221ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7828430)) AND (("cash_track"."id" not in (5786800)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-16 10:37:06 Duration: 192ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7829847)) AND (("cash_track"."id" not in (5797612)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-16 13:32:06 Duration: 164ms

14

36m33s

10,850

Details

180ms

286ms

202ms

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

Day	Hour	Count	Duration	Avg duration
Dec 16	00	965	3m14s	201ms
	01	1,604	5m23s	201ms
	02	1,810	6m2s	200ms
	03	2,088	7m1s	201ms
	04	1,627	5m28s	201ms
	05	1,586	5m18s	200ms
	06	537	1m48s	201ms
	07	309	1m1s	199ms
	22	324	1m15s	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" = '9331800')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

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

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

Date: 2024-12-16 22:25:04 Duration: 285ms

15

23m43s

6,540

Details

187ms

317ms

217ms

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

Day	Hour	Count	Duration	Avg duration
Dec 16	00	8	1s633ms	204ms
	05	530	1m49s	206ms
	06	76	15s140ms	199ms
	09	1,241	4m27s	215ms
	10	1,071	4m2s	225ms
	11	678	2m27s	217ms
	12	270	59s202ms	219ms
	13	574	2m10s	227ms
	14	583	2m9s	222ms
	15	454	1m39s	220ms
	16	983	3m25s	208ms
	17	22	4s813ms	218ms
	21	50	11s140ms	222ms

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

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

Date: 2024-12-16 14:43:56 Duration: 304ms

16

18m57s

4,290

Details

221ms

400ms

265ms

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

Day	Hour	Count	Duration	Avg duration
Dec 16	09	776	3m24s	263ms
	10	190	53s685ms	282ms
	11	739	3m12s	259ms
	12	335	1m28s	264ms
	13	538	2m26s	271ms
	14	544	2m27s	270ms
	15	599	2m37s	262ms
	16	544	2m21s	259ms
	18	25	6s627ms	265ms

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

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

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

Date: 2024-12-16 14:43:57 Duration: 364ms

17

18m43s

26

Details

0ms

18m43s

43s195ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 16	09	1	0ms	0ms
	10	5	2ms	0ms
	11	5	5ms	1ms
	12	4	3ms	0ms
	13	4	18m43s	4m40s
	15	1	1ms	1ms
	16	2	3ms	1ms
	17	1	1ms	1ms
	18	2	3ms	1ms
	20	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-16 13:23:30.111873', "last_update" = '2024-12-16 12:38:30.111927', "write_date" = '2024-12-16 12:38:29.753758', "write_uid" = 1 WHERE id IN (1267);

Date: 2024-12-16 13:57:13 Duration: 18m43s
UPDATE "res_users" SET "exp_date" = '2024-12-16 17:57:42.568932', "last_update" = '2024-12-16 17:12:42.568959', "write_date" = '2024-12-16 17:12:42.121146', "write_uid" = 1357 WHERE id IN (1357);

Date: 2024-12-16 18:12:42 Duration: 1ms
UPDATE "res_users" SET "exp_date" = '2024-12-16 18:16:37.914655', "last_update" = '2024-12-16 17:31:37.914685', "write_date" = '2024-12-16 17:31:37.528920', "write_uid" = 1229 WHERE id IN (1229);

Date: 2024-12-16 18:31:37 Duration: 1ms

18

18m39s

28,180

Details

28ms

81ms

39ms

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
Dec 16	08	133	4s781ms	35ms
	09	2,991	1m50s	36ms
	10	3,247	2m5s	38ms
	11	1,701	1m7s	39ms
	12	2,440	1m35s	39ms
	13	2,780	1m48s	39ms
	14	3,487	2m13s	38ms
	15	4,104	2m34s	37ms
	16	2,308	1m25s	37ms
	17	2,447	1m50s	45ms
	18	2,542	2m3s	48ms

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

Date: 2024-12-16 18:38:09 Duration: 81ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3443007) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:38:09 Duration: 77ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3442024) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:38:09 Duration: 75ms

19

15m30s

274

Details

418ms

4s641ms

3s395ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 16	07	3	2s459ms	819ms
	08	2	6s227ms	3s113ms
	09	27	1m27s	3s248ms
	10	13	35s451ms	2s727ms
	11	18	1m	3s367ms
	12	17	58s129ms	3s419ms
	13	17	1m1s	3s634ms
	14	23	1m20s	3s498ms
	15	23	1m21s	3s524ms
	16	41	2m21s	3s455ms
	17	10	33s984ms	3s398ms
	18	26	1m36s	3s703ms
	19	12	39s614ms	3s301ms
	20	18	58s155ms	3s230ms
	21	18	1m7s	3s760ms
	22	6	18s983ms	3s163ms

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

Date: 2024-12-16 21:58:45 Duration: 4s641ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))))) 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 (29)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))))))) 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 (29)))))))) AND ("policy_number"."name"::text ilike '%9109005%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-16 21:58:46 Duration: 4s506ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))))) 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 (41)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))))))) 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 (41)))))))) AND ("policy_number"."name"::text ilike '%9259566%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-16 18:14:34 Duration: 4s449ms

20

14m36s

6,028

Details

120ms

296ms

145ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 16	01	15	1s958ms	130ms
	07	5	667ms	133ms
	08	36	4s767ms	132ms
	09	551	1m16s	138ms
	10	1,002	2m25s	145ms
	11	1,106	2m42s	147ms
	12	793	1m54s	144ms
	13	594	1m30s	152ms
	14	472	1m7s	143ms
	15	356	50s454ms	141ms
	16	379	53s776ms	141ms
	17	286	41s822ms	146ms
	18	173	28s867ms	166ms
	19	59	8s69ms	136ms
	20	60	7s995ms	133ms
	21	76	10s164ms	133ms
	22	65	9s463ms	145ms

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

Date: 2024-12-16 18:38:09 Duration: 296ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 102)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-16 13:42:15 Duration: 236ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 78)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-16 13:45:45 Duration: 235ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,642,699

Details

1m56s

0ms

15ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 16	00	44,094	1s646ms	0ms
	01	44,986	1s780ms	0ms
	02	34,681	1s335ms	0ms
	03	37,572	1s548ms	0ms
	04	34,254	1s415ms	0ms
	05	30,637	1s275ms	0ms
	06	31,160	1s377ms	0ms
	07	22,166	838ms	0ms
	08	58,684	2s428ms	0ms
	09	148,453	7s286ms	0ms
	10	206,444	10s208ms	0ms
	11	222,479	9s706ms	0ms
	12	226,964	9s852ms	0ms
	13	242,024	10s594ms	0ms
	14	224,267	9s457ms	0ms
	15	209,036	9s393ms	0ms
	16	203,574	8s105ms	0ms
	17	178,591	7s735ms	0ms
	18	142,253	7s142ms	0ms
	19	106,647	4s669ms	0ms
	20	82,267	3s712ms	0ms
	21	69,984	3s47ms	0ms
	22	41,482	2s91ms	0ms

DISCARD ALL;

Date: 2024-12-16 15:37:55 Duration: 15ms
DISCARD ALL;

Date: 2024-12-16 18:37:23 Duration: 1ms
DISCARD ALL;

Date: 2024-12-16 09:22:02 Duration: 1ms

2

2,071,051

Details

28s101ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 16	00	32,033	415ms	0ms
	01	33,284	447ms	0ms
	02	24,391	333ms	0ms
	03	27,696	389ms	0ms
	04	24,455	354ms	0ms
	05	22,286	326ms	0ms
	06	23,692	359ms	0ms
	07	15,327	226ms	0ms
	08	45,559	602ms	0ms
	09	122,058	1s685ms	0ms
	10	169,379	2s386ms	0ms
	11	180,734	2s321ms	0ms
	12	181,270	2s301ms	0ms
	13	191,819	2s516ms	0ms
	14	174,995	2s254ms	0ms
	15	161,914	2s125ms	0ms
	16	157,752	1s939ms	0ms
	17	142,140	1s953ms	0ms
	18	110,632	1s753ms	0ms
	19	81,886	1s168ms	0ms
	20	62,631	924ms	0ms
	21	53,423	779ms	0ms
	22	31,695	536ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-16 12:24:22 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-16 19:31:21 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-16 22:31:59 Duration: 1ms

3

1,347,726

Details

13s150ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 16	00	22,703	194ms	0ms
	01	23,145	204ms	0ms
	02	17,910	150ms	0ms
	03	19,369	170ms	0ms
	04	17,718	158ms	0ms
	05	15,934	142ms	0ms
	06	16,285	152ms	0ms
	07	11,637	96ms	0ms
	08	30,270	263ms	0ms
	09	75,522	738ms	0ms
	10	104,978	1s28ms	0ms
	11	113,313	1s101ms	0ms
	12	115,390	1s117ms	0ms
	13	122,940	1s213ms	0ms
	14	114,437	1s70ms	0ms
	15	106,127	998ms	0ms
	16	103,102	945ms	0ms
	17	90,854	935ms	0ms
	18	72,408	838ms	0ms
	19	54,308	574ms	0ms
	20	42,183	429ms	0ms
	21	35,823	381ms	0ms
	22	21,370	244ms	0ms

ROLLBACK;

Date: 2024-12-16 16:18:11 Duration: 0ms
ROLLBACK;

Date: 2024-12-16 17:12:05 Duration: 0ms
ROLLBACK;

Date: 2024-12-16 04:49:37 Duration: 0ms

4

1,329,038

Details

3m43s

0ms

20ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 16	00	22,117	3s272ms	0ms
	01	22,574	3s529ms	0ms
	02	17,304	2s531ms	0ms
	03	18,774	2s958ms	0ms
	04	17,101	2s658ms	0ms
	05	15,322	2s403ms	0ms
	06	15,605	2s618ms	0ms
	07	11,051	1s445ms	0ms
	08	29,598	4s84ms	0ms
	09	74,912	12s526ms	0ms
	10	104,058	17s479ms	0ms
	11	112,071	18s244ms	0ms
	12	114,207	18s435ms	0ms
	13	121,580	19s730ms	0ms
	14	112,656	17s693ms	0ms
	15	105,410	16s290ms	0ms
	16	102,108	15s778ms	0ms
	17	89,580	16s266ms	0ms
	18	71,560	15s78ms	0ms
	19	53,676	10s627ms	0ms
	20	41,576	8s119ms	0ms
	21	35,312	7s297ms	0ms
	22	20,886	4s783ms	0ms

SELECT payload FROM http_sessions WHERE sid = '5af54b3ac66452fc6b2b3bf5a01e3560b2b86366';

Date: 2024-12-16 15:32:22 Duration: 20ms
SELECT payload FROM http_sessions WHERE sid = 'c1d93d3e35d36558faa6f3dba8ccfd7f5a3d51e7';

Date: 2024-12-16 15:32:22 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = '21735dfeeddc9f852e4466982cb697f6617fb925';

Date: 2024-12-16 15:20:14 Duration: 13ms

5

1,320,554

Details

1m54s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 16	00	22,099	1s725ms	0ms
	01	22,557	1s847ms	0ms
	02	17,420	1s359ms	0ms
	03	18,873	1s545ms	0ms
	04	17,217	1s424ms	0ms
	05	15,391	1s276ms	0ms
	06	15,644	1s338ms	0ms
	07	11,158	863ms	0ms
	08	29,351	2s266ms	0ms
	09	74,147	6s365ms	0ms
	10	103,085	9s168ms	0ms
	11	111,059	9s592ms	0ms
	12	113,281	9s791ms	0ms
	13	120,801	10s671ms	0ms
	14	111,873	9s361ms	0ms
	15	104,471	8s921ms	0ms
	16	101,615	8s340ms	0ms
	17	89,111	8s63ms	0ms
	18	71,090	7s137ms	0ms
	19	53,363	4s917ms	0ms
	20	41,156	3s609ms	0ms
	21	35,019	3s242ms	0ms
	22	20,773	2s73ms	0ms

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

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

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

Date: 2024-12-16 13:07:33 Duration: 1ms

6

931,857

Details

2m13s

0ms

26ms

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
Dec 16	00	11,700	1s541ms	0ms
	01	12,676	1s728ms	0ms
	02	7,398	1s145ms	0ms
	03	9,525	1s474ms	0ms
	04	7,895	1s233ms	0ms
	05	7,251	1s137ms	0ms
	06	8,983	1s396ms	0ms
	07	4,054	720ms	0ms
	08	20,086	2s620ms	0ms
	09	61,208	8s839ms	0ms
	10	85,110	11s993ms	0ms
	11	89,070	12s346ms	0ms
	12	87,075	11s840ms	0ms
	13	89,942	12s416ms	0ms
	14	79,225	11s129ms	0ms
	15	74,343	10s574ms	0ms
	16	69,500	9s140ms	0ms
	17	64,185	9s166ms	0ms
	18	47,635	7s385ms	0ms
	19	34,794	4s962ms	0ms
	20	25,553	4s222ms	0ms
	21	21,581	3s315ms	0ms
	22	13,068	2s669ms	0ms

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

Date: 2024-12-16 16:56:24 Duration: 26ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1027);

Date: 2024-12-16 17:21:52 Duration: 10ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (861);

Date: 2024-12-16 17:21:52 Duration: 10ms

7

721,063

Details

2m5s

0ms

38ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 16	00	9,321	1s542ms	0ms
	01	10,140	1s799ms	0ms
	02	6,480	1s193ms	0ms
	03	8,326	1s655ms	0ms
	04	6,737	1s409ms	0ms
	05	6,352	1s348ms	0ms
	06	7,409	1s348ms	0ms
	07	3,690	675ms	0ms
	08	15,288	2s128ms	0ms
	09	46,465	7s232ms	0ms
	10	64,294	11s131ms	0ms
	11	67,114	11s81ms	0ms
	12	65,622	11s204ms	0ms
	13	68,610	12s150ms	0ms
	14	60,219	10s560ms	0ms
	15	55,726	9s583ms	0ms
	16	54,287	8s627ms	0ms
	17	51,000	9s48ms	0ms
	18	38,122	7s718ms	0ms
	19	27,553	4s991ms	0ms
	20	20,417	3s776ms	0ms
	21	17,563	3s204ms	0ms
	22	10,328	2s498ms	0ms

COMMIT;

Date: 2024-12-16 13:42:25 Duration: 38ms
COMMIT;

Date: 2024-12-16 13:47:14 Duration: 34ms
COMMIT;

Date: 2024-12-16 15:08:58 Duration: 33ms

8

561,595

Details

35s868ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 16	00	6,561	362ms	0ms
	01	6,309	348ms	0ms
	02	3,126	163ms	0ms
	03	3,857	211ms	0ms
	04	3,536	191ms	0ms
	05	2,763	162ms	0ms
	06	4,528	265ms	0ms
	07	2,018	111ms	0ms
	08	11,398	611ms	0ms
	09	34,117	2s70ms	0ms
	10	52,343	3s307ms	0ms
	11	54,368	3s454ms	0ms
	12	53,326	3s433ms	0ms
	13	54,226	3s686ms	0ms
	14	45,153	2s995ms	0ms
	15	41,914	2s665ms	0ms
	16	42,984	2s646ms	0ms
	17	39,657	2s705ms	0ms
	18	31,113	2s265ms	0ms
	19	25,991	1s551ms	0ms
	20	18,347	1s40ms	0ms
	21	15,073	956ms	0ms
	22	8,887	659ms	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 (19, 13, 39);

Date: 2024-12-16 13:42:14 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 (36, 22, 39, 64, 61, 79, 17, 62, 76, 74, 38, 19, 11, 49, 66, 28, 70, 67);

Date: 2024-12-16 14:38:50 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 (28);

Date: 2024-12-16 15:26:25 Duration: 1ms

9

558,150

Details

1m12s

0ms

7ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 16	00	7,619	908ms	0ms
	01	8,324	1s	0ms
	02	3,133	380ms	0ms
	03	4,331	532ms	0ms
	04	4,770	533ms	0ms
	05	3,735	431ms	0ms
	06	5,939	619ms	0ms
	07	1,276	143ms	0ms
	08	11,393	1s221ms	0ms
	09	37,694	4s930ms	0ms
	10	50,850	6s499ms	0ms
	11	53,583	7s55ms	0ms
	12	51,294	6s862ms	0ms
	13	49,543	6s838ms	0ms
	14	42,618	5s689ms	0ms
	15	43,210	6s312ms	0ms
	16	39,092	4s815ms	0ms
	17	37,906	4s940ms	0ms
	18	32,396	4s444ms	0ms
	19	27,416	3s210ms	0ms
	20	18,111	1s979ms	0ms
	21	14,228	1s552ms	0ms
	22	9,689	1s188ms	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 (5101773, 5099007, 5099090, 5100443, 5103962, 5114808, 5099885, 5104872, 5099264, 5099258, 5099095, 5099137, 5099010, 5099009, 5099321, 5099984, 5106511, 5109886, 5104226, 5099111, 5100857, 5099296, 5100564, 5099028, 5099800, 5102177, 5099382, 5100610, 5103882, 5099102, 5158209, 5099359, 5414830, 5107652, 5099356, 5099248, 5099727, 5099693, 5111447, 5181033, 5321412, 5099144, 5101828, 5124402, 5278256, 5165106, 5102334, 5107051, 5099671, 5100246, 5423598, 5098989, 5100961, 5099128, 5099678, 5106953, 5099013, 5426487, 5104141, 5099639, 5099920, 5101662, 5099035, 5103816, 5122374, 5101051, 5099182, 5320809, 5130919, 5099254, 5099550, 5103630, 5101817, 5099092);

Date: 2024-12-16 17:21:53 Duration: 7ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5101387, 5100006, 5103854, 5265603, 5100467, 5123655, 5193748, 5100603, 5118216, 5099679, 5112804, 5113489, 5133599, 5099305, 5100838, 5254866, 5135742, 5099444, 5271212, 5110801, 5148170, 5385140, 5101515, 5099120, 5128133, 5109491, 5099080, 5108814, 5424477, 5099236, 5103780, 5129940, 5099027, 5101538, 5102189, 5102025, 5099299, 5300328, 5295741, 5424471, 5099119, 5104469, 5103591, 5103456, 5100074, 5106166, 5101327, 5126100, 5099129, 5100167, 5099867, 5128587, 5106863, 5424487, 5103431, 5204009, 5177202, 5101217, 5360577, 5112152, 5426871, 5424484, 5099082, 5219436, 5099523);

Date: 2024-12-16 17:21:54 Duration: 5ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5429962, 5099009, 5100181, 5099445, 5099248, 5099642, 5099321, 5099095, 5099258, 5099010, 5101784, 5099006, 5099297, 5105676, 5099014, 5099007, 5101883, 5099130, 5101901, 5099128, 5099264, 5200757, 5100854, 5099102, 5099727, 5100450, 5100666, 5101077, 5099590, 5101285, 5100004, 5099333, 5099037, 5099206, 5099144, 5099309, 5101786, 5104623, 5103061, 5125469, 5100232, 5099138, 5111141, 5100677, 5099028, 5099515, 5099186, 5101102, 5103944, 5099140, 5099254, 5099533, 5099430, 5100801, 5108089, 5101846, 5100132, 5099169, 5427743, 5100485, 5102451, 5101817, 5099329, 5106680, 5102416, 5100753, 5099334, 5192575, 5101592, 5099013, 5101092, 5100246, 5099525, 5099008, 5104440, 5099712, 5099243, 5100457, 5100477, 5099177, 5110212, 5099035, 5203986, 5099815, 5099420, 5100967, 5099251, 5099272, 5111228, 5100511, 5099285, 5099719, 5137372, 5099427, 5099282, 5117269, 5099500, 5119477, 5168233, 5101104, 5099158, 5424475, 5150380, 5110560, 5099187, 5099904);

Date: 2024-12-16 17:21:54 Duration: 4ms

10

408,906

Details

2m10s

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
Dec 16	00	3,026	874ms	0ms
	01	2,838	869ms	0ms
	02	1,251	387ms	0ms
	03	1,285	406ms	0ms
	04	1,111	337ms	0ms
	05	1,100	341ms	0ms
	06	1,525	471ms	0ms
	07	1,196	358ms	0ms
	08	6,677	1s952ms	0ms
	09	19,047	6s112ms	0ms
	10	33,980	11s203ms	0ms
	11	44,790	14s351ms	0ms
	12	41,799	13s382ms	0ms
	13	46,370	15s300ms	0ms
	14	39,892	12s358ms	0ms
	15	28,984	9s53ms	0ms
	16	35,512	10s837ms	0ms
	17	34,975	11s318ms	0ms
	18	22,812	7s999ms	0ms
	19	14,691	4s612ms	0ms
	20	10,693	3s199ms	0ms
	21	11,105	3s502ms	0ms
	22	4,247	1s438ms	0ms

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

Date: 2024-12-16 17:21:52 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'mail.followers' 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 = 828) OR r.global) ORDER BY r.id;

Date: 2024-12-16 09:37:52 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.partner' 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 = 928) OR r.global) ORDER BY r.id;

Date: 2024-12-16 09:38:40 Duration: 2ms

11

387,800

Details

1m11s

0ms

17ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 16	00	4,063	695ms	0ms
	01	4,203	720ms	0ms
	02	2,184	367ms	0ms
	03	2,692	478ms	0ms
	04	2,137	376ms	0ms
	05	1,917	331ms	0ms
	06	3,127	504ms	0ms
	07	1,298	198ms	0ms
	08	9,506	1s399ms	0ms
	09	26,227	4s588ms	0ms
	10	35,951	6s725ms	0ms
	11	37,435	7s48ms	0ms
	12	36,315	6s752ms	0ms
	13	37,403	7s249ms	0ms
	14	33,066	6s59ms	0ms
	15	31,577	5s455ms	0ms
	16	30,614	5s504ms	0ms
	17	27,739	5s447ms	0ms
	18	19,739	4s219ms	0ms
	19	15,345	2s882ms	0ms
	20	10,686	1s882ms	0ms
	21	9,569	1s785ms	0ms
	22	5,007	1s45ms	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 (8004708);

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

Date: 2024-12-16 09:34:47 Duration: 9ms
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 (8006300);

Date: 2024-12-16 17:21:52 Duration: 9ms

12

305,144

Details

53s276ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 16	00	2,729	391ms	0ms
	01	2,682	373ms	0ms
	02	1,385	181ms	0ms
	03	1,786	229ms	0ms
	04	1,313	162ms	0ms
	05	1,629	208ms	0ms
	06	2,149	293ms	0ms
	07	1,145	160ms	0ms
	08	6,565	951ms	0ms
	09	15,898	2s645ms	0ms
	10	24,584	4s332ms	0ms
	11	31,661	5s803ms	0ms
	12	29,624	5s339ms	0ms
	13	34,392	6s429ms	0ms
	14	28,843	5s43ms	0ms
	15	20,751	3s513ms	0ms
	16	26,816	4s564ms	0ms
	17	26,651	4s771ms	0ms
	18	16,701	3s216ms	0ms
	19	9,704	1s659ms	0ms
	20	7,441	1s176ms	0ms
	21	7,173	1s222ms	0ms
	22	3,522	604ms	0ms

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

Date: 2024-12-16 17:21:52 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 971 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_public' AND model = 'res.groups');

Date: 2024-12-16 14:25:56 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1242 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-16 17:26:38 Duration: 2ms

13

261,914

Details

1m5s

0ms

18ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 16	00	3,075	793ms	0ms
	01	3,487	854ms	0ms
	02	1,322	354ms	0ms
	03	1,993	531ms	0ms
	04	2,333	603ms	0ms
	05	1,853	496ms	0ms
	06	3,459	847ms	0ms
	07	543	137ms	0ms
	08	4,551	969ms	0ms
	09	15,088	4s85ms	0ms
	10	21,929	5s657ms	0ms
	11	22,987	5s616ms	0ms
	12	22,529	5s573ms	0ms
	13	22,811	5s564ms	0ms
	14	20,470	4s934ms	0ms
	15	20,908	5s649ms	0ms
	16	18,226	4s256ms	0ms
	17	18,881	4s590ms	0ms
	18	16,759	4s475ms	0ms
	19	14,521	3s515ms	0ms
	20	10,212	2s335ms	0ms
	21	8,297	1s966ms	0ms
	22	5,680	1s475ms	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 (41480709, 40818051, 41190614, 41511953, 41528728, 41409142, 41366952, 41479216, 41480716, 41349450, 41504275, 41463172, 41347690, 41347970, 41479397, 41349480, 41480713, 41349476, 41480722, 41349442, 41346091, 41480723, 41480694, 32635658, 41480701, 41349477, 41480721, 41349459, 41284926, 41347942, 41480702, 41349466, 41463129, 41480719, 41480704, 41480728, 41349485, 41480697, 41480699, 41349486, 41349488, 41349458, 41347943, 41480706, 41480726, 41480710, 41480708, 41284933, 41349481, 41347963, 41347671, 41349470, 41480698, 41349460, 41480727, 41480717, 41347991, 41480718, 41347964, 41347946, 41349478, 41347965, 41284919, 41284939, 41349479, 41349489, 41349447, 41480695, 41285596, 41284895, 41347978, 41349463, 41349471, 40819329, 41010903, 41347956, 41349490, 41480693, 41349487, 41349491, 41349464, 41349482, 41480705, 41349484, 41347962, 41480707, 41480696, 41349475, 41480712, 41347969, 41480715, 40952255, 41347986, 41480703, 41480692, 41349474, 41284907, 41349461, 41349446, 41349455, 41349473, 41284905, 41347688, 41011757, 41349468, 41347954, 41347975, 41349451, 41284913, 41347973, 41347981, 41347654, 41284925, 41284934, 41347972, 41349457, 41347951, 41347959, 41347958, 41347984, 41284940, 41347980, 41347990, 41347673, 41347967, 41347961, 41284917, 41349443, 41349472, 41349444, 40598890, 41347944, 41349467, 41349445, 41347953, 41284932, 41284927, 41284929, 41347684, 41347971, 41347974, 41347979, 41393164, 41347948, 41284937, 41347968, 41347949, 41347977, 41347952, 41347955, 41347950, 41222749, 41347987, 41347686, 41349448, 41284899, 41349452, 41349449, 41347989, 41285626, 41285629, 41190639, 41010897, 41284911, 41284910, 41284922, 41284902, 41284936, 41284904, 41347645, 41190269, 41284935, 41284896, 41285620, 41011785, 41284916, 41347685, 41285597, 41284908, 41284941, 41347678, 41284924, 41284898, 41284906, 41284909, 41284901, 41347687, 41347691, 41284892, 41347689);

Date: 2024-12-16 15:58:36 Duration: 18ms
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 (40484580, 41062915, 41252956, 41086352, 41312041, 41321346, 41304672, 41047922, 40537840, 41231870, 41230816, 41190283, 41193995, 41167420, 41134054, 41203342, 41158188, 41055000, 40297826);

Date: 2024-12-16 17:21:52 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 (41207251, 39937631);

Date: 2024-12-16 17:21:52 Duration: 10ms

14

252,006

Details

1d6h3m56s

355ms

826ms

429ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 16	00	5,884	37m50s	385ms
	01	6,965	45m6s	388ms
	02	4,834	30m59s	384ms
	03	6,776	43m42s	387ms
	04	7,266	47m20s	390ms
	05	6,200	40m21s	390ms
	06	7,095	47m29s	401ms
	07	2,703	17m4s	379ms
	08	3,455	21m59s	381ms
	09	12,151	1h22m41s	408ms
	10	18,016	2h6m46s	422ms
	11	14,435	1h41m43s	422ms
	12	13,978	1h37m47s	419ms
	13	16,684	2h33s	433ms
	14	12,089	1h24m32s	419ms
	15	11,849	1h21m59s	415ms
	16	12,712	1h28m28s	417ms
	17	15,174	1h56m4s	458ms
	18	22,059	2h58m46s	486ms
	19	15,461	1h56m52s	453ms
	20	11,924	1h28m30s	445ms
	21	11,128	1h25m13s	459ms
	22	13,168	1h42m2s	464ms

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

Date: 2024-12-16 21:52:03 Duration: 826ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3641127)) AND (("shipping_track"."id" not in (29756362, 29756362)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 18:39:36 Duration: 826ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3641169)) AND (("shipping_track"."id" not in (29756527, 29756527)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 18:39:54 Duration: 824ms

15

189,096

Details

15s543ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 16	00	2,473	162ms	0ms
	01	2,622	178ms	0ms
	02	1,010	71ms	0ms
	03	1,315	97ms	0ms
	04	1,262	96ms	0ms
	05	1,015	76ms	0ms
	06	1,499	117ms	0ms
	07	455	30ms	0ms
	08	3,962	242ms	0ms
	09	13,253	1s42ms	0ms
	10	18,456	1s592ms	0ms
	11	19,573	1s792ms	0ms
	12	18,565	1s405ms	0ms
	13	18,045	1s360ms	0ms
	14	15,607	1s196ms	0ms
	15	15,332	1s230ms	0ms
	16	13,728	1s112ms	0ms
	17	12,503	1s214ms	0ms
	18	9,486	766ms	0ms
	19	7,776	598ms	0ms
	20	4,970	392ms	0ms
	21	3,625	368ms	0ms
	22	2,564	394ms	0ms

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

Date: 2024-12-16 17:21:52 Duration: 2ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2024-12-16 17:21:52 Duration: 2ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2024-12-16 17:21:52 Duration: 2ms

16

176,913

Details

10s176ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 16	00	1,394	68ms	0ms
	01	1,144	59ms	0ms
	02	505	25ms	0ms
	03	522	26ms	0ms
	04	413	20ms	0ms
	05	416	21ms	0ms
	06	630	32ms	0ms
	07	546	27ms	0ms
	08	2,961	151ms	0ms
	09	8,111	463ms	0ms
	10	14,004	820ms	0ms
	11	19,577	1s154ms	0ms
	12	18,549	1s80ms	0ms
	13	20,500	1s237ms	0ms
	14	17,623	981ms	0ms
	15	12,324	674ms	0ms
	16	15,830	874ms	0ms
	17	15,116	887ms	0ms
	18	9,458	611ms	0ms
	19	6,181	346ms	0ms
	20	4,656	241ms	0ms
	21	4,697	263ms	0ms
	22	1,756	103ms	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: 2024-12-16 12:46:24 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (17);

Date: 2024-12-16 13:21:12 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (88, 89);

Date: 2024-12-16 11:42:36 Duration: 0ms

17

171,190

Details

21s490ms

0ms

23ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 16	00	1,373	146ms	0ms
	01	1,123	127ms	0ms
	02	502	54ms	0ms
	03	522	58ms	0ms
	04	413	44ms	0ms
	05	404	44ms	0ms
	06	620	71ms	0ms
	07	540	61ms	0ms
	08	2,908	328ms	0ms
	09	7,964	996ms	0ms
	10	13,677	1s754ms	0ms
	11	18,956	2s431ms	0ms
	12	17,981	2s274ms	0ms
	13	19,721	2s598ms	0ms
	14	17,184	2s82ms	0ms
	15	11,853	1s417ms	0ms
	16	15,356	1s845ms	0ms
	17	14,546	1s886ms	0ms
	18	9,088	1s290ms	0ms
	19	5,855	709ms	0ms
	20	4,404	491ms	0ms
	21	4,467	548ms	0ms
	22	1,733	223ms	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 (97) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-16 17:48:46 Duration: 23ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-16 14:25:56 Duration: 2ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (88, 89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-16 11:42:36 Duration: 1ms

18

159,504

Details

1m30s

0ms

27ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 16	00	758	431ms	0ms
	01	1,056	747ms	0ms
	02	405	156ms	0ms
	03	611	240ms	0ms
	04	300	144ms	0ms
	05	170	95ms	0ms
	06	238	129ms	0ms
	07	246	99ms	0ms
	08	1,559	860ms	0ms
	09	8,519	4s468ms	0ms
	10	12,663	6s752ms	0ms
	11	11,188	6s671ms	0ms
	12	12,557	7s610ms	0ms
	13	14,174	8s877ms	0ms
	14	13,683	8s818ms	0ms
	15	12,309	9s724ms	0ms
	16	9,089	4s946ms	0ms
	17	9,672	5s564ms	0ms
	18	17,488	9s279ms	0ms
	19	3,538	1s885ms	0ms
	20	1,995	1s88ms	0ms
	21	8,571	3s955ms	0ms
	22	18,715	8s30ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3532629, 3609552, 3532661, 3427341, 3532636, 3532950, 3555812, 3299734, 3345668, 3485101, 3555834, 3532905, 3579023, 3485176, 3578893, 3578906, 3579030, 3578889, 3578972, 3485227, 3532937, 3578929, 3555892, 3532616, 3578925, 3260872, 3490197, 3295191, 3532915, 3427445, 3532955, 3555820, 3485179, 3485189, 3579036, 3555797, 3557861, 3555830, 3578915, 3555832, 3427237, 3459373, 3578899, 3532871, 3427345, 3555828, 3555826, 3532837, 3532624, 3485149, 3532856, 3555880, 3259261, 3532627, 3532836, 3532643, 3459651, 3299717, 3459400, 3555822, 3532892, 3485099, 3532619, 3485192, 3532834, 2978481, 3485225, 3485106, 3555879, 3555836, 3485122, 3555824, 3490193, 3533004, 3555858, 3485121, 3459436, 3459509, 3532832, 3459494, 3485104, 3490200, 3490203, 3459483, 3459488, 3427143, 3485125, 3485147, 3427285, 3485204, 3459358, 3459581, 3532835, 3427465, 3490168, 3459473, 3485219, 3385770, 3378327, 3500146, 3268247, 3459365, 2480464, 3427217, 3222180, 3459485, 3459469, 3485157, 3222021, 3345905, 3385773, 3459556, 3459471, 3259072, 3485151, 3459502, 3485105, 3485182, 2966769, 3459516, 3385852, 3459478, 3321658, 3427223, 3485108, 3345912, 3490178, 3427299, 3459492, 3459354, 3427234, 3321692, 3427290, 3459465, 3485184, 3427576, 3345686, 3485167, 3459519, 3459356, 3427449, 3427338, 3459359, 3459371, 3459415, 2950395, 3427173, 3427357, 3427203, 3345872, 3459507, 3427167, 3459458, 3385739, 3459549, 3427294, 3459419, 3385775, 3459389, 3459353, 3472226, 3427270, 3459480, 3459357, 3427469, 3385780, 3427157, 2931552, 3459504, 3427189, 3459360, 3459585, 3427207, 3427107, 3427251, 3299550, 3345987, 3427254, 3427213, 3427142, 3427321, 3427230, 3345895, 3427169, 3427582, 3427227, 3289066, 3427534, 3427138, 3321690, 3345881, 3298624, 3385732, 3385856, 3427210, 3427140);

Date: 2024-12-16 17:21:54 Duration: 27ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3602782, 3527495, 2813005, 3518388, 3602816, 3518368, 3602762, 3448671, 3602818, 3071518, 3580495, 3413802, 3602776, 3449022, 3483127, 3448628, 3573677, 3448993, 3573655, 3518353, 3573667, 3379260, 3413970, 3413767, 3573651, 3574059, 3529367, 3452589, 3552738, 3406745, 3586539, 3078206, 3341336, 3433606, 3560600, 3562843, 3063707, 3428669, 3590738, 3374207, 3472904, 3519705, 3456407, 3288035, 3580489, 3539085, 3581566, 3566890, 3582569, 3567947, 3518775, 3481970, 3451378, 3573668, 3591512, 3537499, 3519731, 3523056, 3562391, 3523639, 3546556, 3585371, 3518828, 3506324, 3433248, 3563308, 3477186, 3465492, 3472241, 3531632, 3489818, 3553431, 3510686, 3572802, 3573673, 3573713, 3576480, 3558848, 3542000, 3456362, 3411620, 3483295, 3581704, 3567734, 3560683, 3567301, 3529351, 3499762, 3472367, 3553111, 3596518, 3549545, 3573985, 3529405, 3477286, 3416648, 3430334, 3540011, 3481099, 3573650, 3379293, 3523153, 3518358, 3574082, 3573695, 3519287, 3580481, 3530017, 3251911, 3483212, 3504317, 3523298, 3523134, 3580477, 3337299, 3483320, 3530010, 3574077, 3573656, 3574044, 3523054, 3444222, 3538101, 3527315, 3444481, 3538864, 3512382, 3472811, 3459373, 3212325, 3530029, 3457829, 3519239, 3519245, 3523138, 3523055, 3527480, 3523078, 3527498, 3518341, 3519265, 3518352, 3518387, 3504398, 3504488, 3512347, 3456822, 3536214, 3485258, 3504532, 3444509, 3527943, 3460457, 3472978, 3543918, 3512011, 3484214, 3560619, 3531809, 3389290, 3523333, 3520632, 3462400, 3546678, 3472785, 3477273, 3456720, 3455440, 3524411, 3433498, 3448753, 3477094, 3528589, 3522027, 3540849, 3479946, 3504444, 3523161, 3530008, 3413897, 3543177, 3533208, 3502685, 3531341, 3524420, 3525084, 3522536, 3465489, 3546676, 3463448, 3533632, 3483322, 3518356, 3379292, 3523057, 3483184, 3452335, 3530056);

Date: 2024-12-16 17:21:55 Duration: 25ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3356550, 3107243, 3476185, 3204716, 3475902, 3406456, 3461700, 3415070, 3107242, 3437934, 3374849, 3461689, 3380452, 3415009, 3435785, 3344286, 3380544, 3374848, 3356591, 3374845, 3451290, 3302133, 3402466, 3107220, 2619319, 3472401, 3374840, 3418260, 3389257, 3328991, 3472394, 3441987, 3148712, 3374841, 3389411, 3414312, 3442040, 3415249, 3235703, 3353505, 3281421, 3439789, 3369787, 3312880, 3315046, 3438347, 3092035, 3390560, 3397431, 3437909, 3380603, 3399018, 3414903, 3325781, 3439494, 3398964, 3441983, 3415061, 3344257, 3414893, 3230679, 3380471, 3414881, 3415143, 2654592, 3370016, 3276229, 3397371, 3437353, 3312573, 3312730, 3438357, 3427340, 3336435, 3415005, 3430089, 3398987, 3398975, 3374825, 3221527, 3328956, 3133282, 1874985, 3252600, 3432489, 3437358, 3437380, 3427762, 3384768, 3414342, 3261968, 3437378, 3325896, 3344312, 3380564, 3344255, 3389328, 3394537, 3199717, 3389260, 3130199, 3260542, 3031467, 3378376, 3336716, 3327738, 3143071, 3397419, 3351686, 3315043, 3380314, 3394505, 3380597, 3329024, 3399019, 3380540, 3363201, 3380305, 3344303, 3389368, 3389356, 3281916, 3344308, 3312779, 3344331, 3353500, 3344306, 3237840, 3312729, 3344333, 3390626, 3344315, 3380307, 3391287, 3302264, 3343112, 2542960, 3136180, 3298264, 3344310, 3281896, 3199051, 3353502, 3190714, 3344305, 3336713, 3312540, 3066631, 3276099, 3312890, 3300909, 3365164, 3327887, 3142920, 3312892, 3344313, 3359940, 3344362, 3266461, 3298292, 3360056, 3360077, 3312893, 3344354, 3360072, 3344364, 3359966, 3360034, 3328972, 3328989, 3271150, 3221629, 3314866, 3327896, 3221625, 3336694, 3297670, 2211146, 2933296, 3300910, 3315040, 3260546, 3271134, 3310025, 3278663, 3329108, 3329103, 3328994, 3327885, 3316256, 3312576, 3254773, 3312913, 3318063, 3315052, 3327747, 3312906, 3288859, 3327748, 3315738, 3326799, 3133239, 3327886, 3327889, 3107249, 3281666, 3107246, 3308107, 3298289, 3271131, 3271137, 2879285, 3313353, 3266357, 3237843, 3315075, 3288606, 3221234, 3194991, 3161412, 3266499, 3108433, 3171172, 3199400, 3240656, 3274325, 3190648, 3092008, 3221631, 3221237, 3275822, 3147764, 3171123, 3167762, 3023798, 3136197, 3242713, 2971590, 3184009, 3212433, 3133670, 3133667, 3133252, 3161432, 3133233, 3204718, 3167746, 3199055, 3194988, 3204715, 3161445, 3161425, 3161452, 3161420, 3130347, 3106892, 2963759, 3096032, 2905108, 3141960, 3133229, 3023797, 3106893, 2933299, 3021950, 3023796, 3023795, 2958888, 2902045, 2756799, 2756876, 2756851, 2756896, 2722679, 2675956, 2716085, 1338825, 206654);

Date: 2024-12-16 15:03:10 Duration: 21ms

19

158,746

Details

49s687ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 16	00	3,523	1s193ms	0ms
	01	4,622	1s487ms	0ms
	02	2,559	962ms	0ms
	03	4,125	1s395ms	0ms
	04	6,057	1s920ms	0ms
	05	5,150	1s666ms	0ms
	06	9,913	2s956ms	0ms
	07	1,084	474ms	0ms
	08	247	108ms	0ms
	09	1,172	564ms	0ms
	10	2,537	1s108ms	0ms
	11	1,474	721ms	0ms
	12	1,898	704ms	0ms
	13	2,034	814ms	0ms
	14	2,740	947ms	0ms
	15	3,570	1s102ms	0ms
	16	6,790	2s88ms	0ms
	17	12,519	3s889ms	0ms
	18	21,477	6s877ms	0ms
	19	20,693	5s917ms	0ms
	20	16,397	4s524ms	0ms
	21	16,211	4s552ms	0ms
	22	11,954	3s706ms	0ms

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

Date: 2024-12-16 06:03:02 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 39) AND ("price_list"."to_office_id" = 7)) ORDER BY "price_list"."id";

Date: 2024-12-16 19:51:59 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 51) AND ("price_list"."to_office_id" = 28)) ORDER BY "price_list"."id";

Date: 2024-12-16 17:22:04 Duration: 1ms

20

154,780

Details

1h42m42s

29ms

129ms

39ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 16	00	2,450	1m29s	36ms
	01	3,049	1m52s	36ms
	02	1,421	51s974ms	36ms
	03	2,686	1m38s	36ms
	04	2,339	1m26s	36ms
	05	1,756	1m4s	36ms
	06	1,497	55s519ms	37ms
	07	593	21s140ms	35ms
	08	2,189	1m20s	36ms
	09	9,680	6m16s	38ms
	10	13,306	8m53s	40ms
	11	11,527	7m44s	40ms
	12	11,765	7m47s	39ms
	13	13,732	9m22s	40ms
	14	9,883	6m31s	39ms
	15	10,455	6m46s	38ms
	16	9,708	6m17s	38ms
	17	10,049	6m58s	41ms
	18	10,496	7m37s	43ms
	19	8,889	5m53s	39ms
	20	6,630	4m18s	39ms
	21	6,835	4m35s	40ms
	22	3,845	2m39s	41ms

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

Date: 2024-12-16 17:21:54 Duration: 129ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3319563)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-16 17:21:54 Duration: 122ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3602801)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-16 12:01:38 Duration: 91ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

18m43s

43s195ms

26

Details

18m43s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 16	09	1	0ms	0ms
	10	5	2ms	0ms
	11	5	5ms	1ms
	12	4	3ms	0ms
	13	4	18m43s	4m40s
	15	1	1ms	1ms
	16	2	3ms	1ms
	17	1	1ms	1ms
	18	2	3ms	1ms
	20	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-16 13:23:30.111873', "last_update" = '2024-12-16 12:38:30.111927', "write_date" = '2024-12-16 12:38:29.753758', "write_uid" = 1 WHERE id IN (1267);

Date: 2024-12-16 13:57:13 Duration: 18m43s
UPDATE "res_users" SET "exp_date" = '2024-12-16 17:57:42.568932', "last_update" = '2024-12-16 17:12:42.568959', "write_date" = '2024-12-16 17:12:42.121146', "write_uid" = 1357 WHERE id IN (1357);

Date: 2024-12-16 18:12:42 Duration: 1ms
UPDATE "res_users" SET "exp_date" = '2024-12-16 18:16:37.914655', "last_update" = '2024-12-16 17:31:37.914685', "write_date" = '2024-12-16 17:31:37.528920', "write_uid" = 1229 WHERE id IN (1229);

Date: 2024-12-16 18:31:37 Duration: 1ms

2

0ms

18m19s

15s754ms

398

Details

1h44m30s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 16	00	4	1m19s	19s928ms
	01	3	4ms	1ms
	02	1	0ms	0ms
	05	3	3ms	1ms
	06	1	1ms	1ms
	07	1	0ms	0ms
	08	6	3ms	0ms
	09	34	23ms	0ms
	10	35	5m42s	9s777ms
	11	39	9m8s	14s57ms
	12	43	37m17s	52s44ms
	13	35	7m34s	12s994ms
	14	57	8m19s	8s757ms
	15	25	26ms	1ms
	16	32	4m22s	8s190ms
	17	29	7m41s	15s913ms
	18	19	19m41s	1m2s
	19	11	3m22s	18s432ms
	20	10	7ms	0ms
	21	7	10ms	1ms
	22	3	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-16 12:10:01.825861', "last_update" = '2024-12-16 11:25:01.825886', "sid" = '84ac83dec3ae8a7aa3d23f0c66823bbf92833d6b', "write_date" = '2024-12-16 11:25:01.411142', "write_uid" = 875 WHERE id IN (875);

Date: 2024-12-16 12:43:20 Duration: 18m19s
UPDATE "res_users" SET "exp_date" = '2024-12-16 12:14:51.783492', "last_update" = '2024-12-16 11:29:51.783511', "sid" = '6a696d699a4e429a42ee904addcedcc82dcf02b4', "write_date" = '2024-12-16 11:29:51.427282', "write_uid" = 1 WHERE id IN (1034);

Date: 2024-12-16 12:43:20 Duration: 13m29s
UPDATE "res_users" SET "exp_date" = '2024-12-16 17:46:00.711361', "last_update" = '2024-12-16 17:01:00.711387', "sid" = 'c95eaba7a8ff411d7ec6ab9e1ba278af0e1e866d', "write_date" = '2024-12-16 17:01:00.318883', "write_uid" = 1 WHERE id IN (904);

Date: 2024-12-16 18:09:13 Duration: 8m12s

3

0ms

1h

4s430ms

89,582

Details

4d14h14m54s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 16	00	811	13h11m8s	58s531ms
	01	1,092	229ms	0ms
	02	643	132ms	0ms
	03	1,224	252ms	0ms
	04	674	141ms	0ms
	05	603	124ms	0ms
	06	577	4m8s	430ms
	07	271	57ms	0ms
	08	1,528	313ms	0ms
	09	5,198	5h30m50s	3s818ms
	10	7,935	4h43m44s	2s145ms
	11	9,207	9h30m6s	3s715ms
	12	8,958	10h50m43s	4s358ms
	13	9,494	11h52m40s	4s503ms
	14	9,311	7h36m23s	2s941ms
	15	7,517	6h32m14s	3s130ms
	16	6,606	13h19m31s	7s261ms
	17	5,864	3h53m16s	2s386ms
	18	4,089	6h39m34s	5s863ms
	19	2,896	1h41m38s	2s105ms
	20	2,200	10h21m6s	16s939ms
	21	1,639	3h28m10s	7s621ms
	22	1,245	59m34s	2s871ms

update res_users set sid = 'd0127ede5a1e628ccacef5912a0efb4a264f7642', last_update = '2024-12-16 18:14:09.996386', exp_date = '2024-12-16 18:59:09.996389', logged_in = 'TRUE' where id = 931;

Date: 2024-12-16 20:14:10 Duration: 1h
update res_users set sid = 'd0127ede5a1e628ccacef5912a0efb4a264f7642', last_update = '2024-12-16 18:14:09.996382', exp_date = '2024-12-16 18:59:09.996386', logged_in = 'TRUE' where id = 931;

Date: 2024-12-16 20:14:10 Duration: 1h
update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-16 20:18:48.322520', exp_date = '2024-12-16 21:03:48.322523', logged_in = 'TRUE' where id = 843;

Date: 2024-12-16 22:18:22 Duration: 59m34s

4

418ms

4s641ms

3s395ms

274

Details

15m30s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 16	07	3	2s459ms	819ms
	08	2	6s227ms	3s113ms
	09	27	1m27s	3s248ms
	10	13	35s451ms	2s727ms
	11	18	1m	3s367ms
	12	17	58s129ms	3s419ms
	13	17	1m1s	3s634ms
	14	23	1m20s	3s498ms
	15	23	1m21s	3s524ms
	16	41	2m21s	3s455ms
	17	10	33s984ms	3s398ms
	18	26	1m36s	3s703ms
	19	12	39s614ms	3s301ms
	20	18	58s155ms	3s230ms
	21	18	1m7s	3s760ms
	22	6	18s983ms	3s163ms

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

Date: 2024-12-16 21:58:45 Duration: 4s641ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))))) 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 (29)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))))))) 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 (29)))))))) AND ("policy_number"."name"::text ilike '%9109005%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-16 21:58:46 Duration: 4s506ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))))) 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 (41)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))))))) 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 (41)))))))) AND ("policy_number"."name"::text ilike '%9259566%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-16 18:14:34 Duration: 4s449ms

5

254ms

2s50ms

1s10ms

14,215

Details

3h59m24s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 16	00	320	5m4s	951ms
	01	243	3m51s	952ms
	02	49	46s582ms	950ms
	03	225	3m36s	960ms
	08	3	2s807ms	935ms
	09	8	7s839ms	979ms
	10	193	3m29s	1s86ms
	12	5	1s531ms	306ms
	13	148	2m40s	1s84ms
	15	271	4m35s	1s16ms
	16	737	12m21s	1s5ms
	17	1,447	25m5s	1s40ms
	18	3,293	59m55s	1s91ms
	19	1,317	20m21s	927ms
	20	2,267	36m39s	970ms
	21	2,344	37m36s	962ms
	22	1,345	23m8s	1s32ms

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

Date: 2024-12-16 18:23:57 Duration: 2s50ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '8863046')) 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 (16))))))) 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 (16)))))) 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 (16)))))) 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 (16))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 18:38:10 Duration: 1s699ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9213463')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 18:14:40 Duration: 1s505ms

6

356ms

1s399ms

436ms

47,871

Details

5h47m55s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 16	00	211	1m29s	423ms
	01	460	3m5s	402ms
	02	243	1m38s	405ms
	03	385	2m36s	407ms
	04	261	1m49s	421ms
	05	155	1m8s	440ms
	06	189	1m20s	425ms
	07	204	1m19s	391ms
	08	1,480	9m35s	388ms
	09	2,703	19m4s	423ms
	10	4,025	29m18s	436ms
	11	3,453	25m25s	441ms
	12	4,176	29m56s	430ms
	13	5,148	38m	442ms
	14	3,686	26m20s	428ms
	15	2,886	20m20s	423ms
	16	3,659	25m41s	421ms
	17	4,091	31m2s	455ms
	18	3,149	25m22s	483ms
	19	2,994	21m38s	433ms
	20	2,471	17m35s	427ms
	21	1,216	9m3s	447ms
	22	626	5m	479ms

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

Date: 2024-12-16 17:21:54 Duration: 1s399ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3319563)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 17:21:54 Duration: 1s153ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3655564, 3655563, 3655560, 3655558, 3655557, 3655555, 3655553, 3655551, 3655549, 3655548, 3655546, 3655544, 3655542, 3655540, 3655538, 3655537, 3655535, 3655534, 3655532, 3655531, 3655529, 3655528, 3655526, 3655524, 3655523, 3655521, 3655518, 3655515, 3655511, 3655509, 3655506, 3655502, 3655499, 3655495, 3655491, 3655488, 3655484, 3655480, 3655478, 3655474, 3655470, 3655467, 3655461, 3655457, 3655452, 3655447, 3655443, 3655438, 3655433, 3655429, 3655425, 3655420, 3655416)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 21:51:53 Duration: 775ms

7

355ms

826ms

429ms

252,006

Details

1d6h3m56s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 16	00	5,884	37m50s	385ms
	01	6,965	45m6s	388ms
	02	4,834	30m59s	384ms
	03	6,776	43m42s	387ms
	04	7,266	47m20s	390ms
	05	6,200	40m21s	390ms
	06	7,095	47m29s	401ms
	07	2,703	17m4s	379ms
	08	3,455	21m59s	381ms
	09	12,151	1h22m41s	408ms
	10	18,016	2h6m46s	422ms
	11	14,435	1h41m43s	422ms
	12	13,978	1h37m47s	419ms
	13	16,684	2h33s	433ms
	14	12,089	1h24m32s	419ms
	15	11,849	1h21m59s	415ms
	16	12,712	1h28m28s	417ms
	17	15,174	1h56m4s	458ms
	18	22,059	2h58m46s	486ms
	19	15,461	1h56m52s	453ms
	20	11,924	1h28m30s	445ms
	21	11,128	1h25m13s	459ms
	22	13,168	1h42m2s	464ms

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

Date: 2024-12-16 21:52:03 Duration: 826ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3641127)) AND (("shipping_track"."id" not in (29756362, 29756362)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 18:39:36 Duration: 826ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3641169)) AND (("shipping_track"."id" not in (29756527, 29756527)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-16 18:39:54 Duration: 824ms

8

227ms

640ms

315ms

20,654

Details

1h48m39s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 16	00	216	1m3s	292ms
	01	522	2m31s	290ms
	02	188	55s152ms	293ms
	03	358	1m43s	289ms
	04	1,028	4m58s	290ms
	05	831	4m1s	290ms
	06	1,952	9m27s	290ms
	07	2	592ms	296ms
	08	7	2s143ms	306ms
	10	97	33s520ms	345ms
	11	44	14s313ms	325ms
	12	341	1m50s	323ms
	13	183	1m1s	335ms
	14	587	3m8s	321ms
	15	593	3m9s	318ms
	16	879	4m41s	320ms
	17	1,642	9m	329ms
	18	2,135	12m13s	343ms
	19	3,880	20m27s	316ms
	20	1,855	9m25s	305ms
	21	1,717	9m	314ms
	22	1,597	9m8s	343ms

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

Date: 2024-12-16 18:15:03 Duration: 640ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9402903')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 18:22:06 Duration: 509ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9415029')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-16 14:44:02 Duration: 500ms

9

188ms

467ms

271ms

29,761

Details

2h14m54s

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
Dec 16	08	133	32s248ms	242ms
	09	2,940	12m44s	259ms
	10	3,039	13m50s	273ms
	11	2,997	13m27s	269ms
	12	2,764	12m23s	269ms
	13	2,947	13m35s	276ms
	14	3,624	16m14s	269ms
	15	3,596	15m25s	257ms
	16	2,104	9m19s	266ms
	17	2,914	13m36s	280ms
	18	2,703	13m43s	304ms

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

Date: 2024-12-16 18:39:55 Duration: 467ms
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" = '9238576')))) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:39:54 Duration: 464ms
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" = '9239937')))) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:40:15 Duration: 439ms

10

221ms

400ms

265ms

4,290

Details

18m57s

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

Day	Hour	Count	Duration	Avg duration
Dec 16	09	776	3m24s	263ms
	10	190	53s685ms	282ms
	11	739	3m12s	259ms
	12	335	1m28s	264ms
	13	538	2m26s	271ms
	14	544	2m27s	270ms
	15	599	2m37s	262ms
	16	544	2m21s	259ms
	18	25	6s627ms	265ms

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

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

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

Date: 2024-12-16 14:43:57 Duration: 364ms

11

89ms

932ms

244ms

68,959

Details

4h40m36s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 16	00	1,048	3m53s	223ms
	01	1,512	5m17s	209ms
	02	466	1m50s	237ms
	03	1,158	4m11s	217ms
	04	2,024	6m51s	203ms
	05	1,650	5m59s	217ms
	06	3,880	14m29s	224ms
	07	4	1s67ms	266ms
	08	18	2s952ms	164ms
	09	16	4s17ms	251ms
	10	566	2m11s	231ms
	11	86	18s854ms	219ms
	12	670	2m40s	238ms
	13	650	2m43s	251ms
	14	1,144	5m8s	269ms
	15	1,696	6m48s	240ms
	16	3,194	12m20s	231ms
	17	6,098	25m1s	246ms
	18	10,714	47m6s	263ms
	19	10,297	41m26s	241ms
	20	8,168	34m29s	253ms
	21	8,050	32m16s	240ms
	22	5,850	25m21s	260ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'طارق')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-16 22:24:21 Duration: 932ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-16 22:24:21 Duration: 932ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'اشرف')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-16 19:31:33 Duration: 914ms

12

177ms

374ms

226ms

145,310

Details

9h7m52s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 16	00	1,900	6m22s	201ms
	01	1,856	6m14s	201ms
	02	2,054	6m51s	200ms
	03	2,441	8m12s	201ms
	04	1,904	6m24s	201ms
	05	2,469	8m18s	201ms
	06	3,684	12m19s	200ms
	07	940	3m7s	199ms
	08	432	1m26s	200ms
	09	9,886	35m36s	216ms
	10	9,423	35m20s	224ms
	11	6,634	24m19s	220ms
	12	8,123	29m39s	219ms
	13	8,811	33m7s	225ms
	14	10,777	39m19s	218ms
	15	9,834	35m3s	213ms
	16	6,554	23m40s	216ms
	17	7,184	26m56s	225ms
	18	15,454	1h3m32s	246ms
	19	255	55s339ms	217ms
	20	222	47s16ms	211ms
	21	14,198	1h38s	256ms
	22	20,275	1h19m36s	235ms

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

Date: 2024-12-16 21:52:06 Duration: 374ms
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" = '456893')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-16 21:51:38 Duration: 373ms
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" = '9324960')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-16 21:52:06 Duration: 371ms

13

187ms

317ms

217ms

6,540

Details

23m43s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 16	00	8	1s633ms	204ms
	05	530	1m49s	206ms
	06	76	15s140ms	199ms
	09	1,241	4m27s	215ms
	10	1,071	4m2s	225ms
	11	678	2m27s	217ms
	12	270	59s202ms	219ms
	13	574	2m10s	227ms
	14	583	2m9s	222ms
	15	454	1m39s	220ms
	16	983	3m25s	208ms
	17	22	4s813ms	218ms
	21	50	11s140ms	222ms

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

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

Date: 2024-12-16 14:43:56 Duration: 304ms

14

180ms

326ms

212ms

13,775

Details

48m46s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 16	00	319	1m3s	199ms
	02	229	45s923ms	200ms
	03	352	1m11s	202ms
	04	239	48s129ms	201ms
	05	353	1m10s	200ms
	06	3,071	10m17s	201ms
	07	631	2m6s	200ms
	08	340	1m8s	200ms
	09	812	2m54s	215ms
	10	429	1m37s	226ms
	11	917	3m27s	226ms
	12	837	3m7s	224ms
	13	1,129	4m11s	222ms
	14	1,321	4m49s	219ms
	15	1,072	3m48s	213ms
	16	435	1m35s	218ms
	17	447	1m38s	221ms
	18	346	1m16s	220ms
	19	255	55s551ms	217ms
	20	222	47s144ms	212ms
	21	5	1s48ms	209ms
	22	14	3s876ms	276ms

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

Date: 2024-12-16 12:59:39 Duration: 326ms
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" = '9293692')) 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 (1)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2024-12-16 12:20:15 Duration: 295ms

15

180ms

286ms

202ms

10,850

Details

36m33s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 16	00	965	3m14s	201ms
	01	1,604	5m23s	201ms
	02	1,810	6m2s	200ms
	03	2,088	7m1s	201ms
	04	1,627	5m28s	201ms
	05	1,586	5m18s	200ms
	06	537	1m48s	201ms
	07	309	1m1s	199ms
	22	324	1m15s	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" = '9331800')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

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

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

Date: 2024-12-16 22:25:04 Duration: 285ms

16

120ms

296ms

145ms

6,028

Details

14m36s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 16	01	15	1s958ms	130ms
	07	5	667ms	133ms
	08	36	4s767ms	132ms
	09	551	1m16s	138ms
	10	1,002	2m25s	145ms
	11	1,106	2m42s	147ms
	12	793	1m54s	144ms
	13	594	1m30s	152ms
	14	472	1m7s	143ms
	15	356	50s454ms	141ms
	16	379	53s776ms	141ms
	17	286	41s822ms	146ms
	18	173	28s867ms	166ms
	19	59	8s69ms	136ms
	20	60	7s995ms	133ms
	21	76	10s164ms	133ms
	22	65	9s463ms	145ms

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

Date: 2024-12-16 18:38:09 Duration: 296ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 102)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-16 13:42:15 Duration: 236ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 78)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-16 13:45:45 Duration: 235ms

17

77ms

221ms

96ms

23,369

Details

37m43s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 16	00	2	204ms	102ms
	01	16	1s512ms	94ms
	02	16	1s473ms	92ms
	03	13	1s238ms	95ms
	04	11	1s12ms	92ms
	07	33	3s51ms	92ms
	08	281	26s403ms	93ms
	09	2,136	3m22s	94ms
	10	1,942	3m8s	97ms
	11	2,071	3m20s	97ms
	12	2,580	4m9s	96ms
	13	2,854	4m45s	99ms
	14	2,727	4m23s	96ms
	15	2,482	3m56s	95ms
	16	1,553	2m29s	96ms
	17	1,664	2m45s	99ms
	18	1,012	1m42s	100ms
	19	930	1m26s	92ms
	20	731	1m6s	91ms
	21	254	25s438ms	100ms
	22	61	5s680ms	93ms

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

Date: 2024-12-16 11:49:27 Duration: 221ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7828430)) AND (("cash_track"."id" not in (5786800)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-16 10:37:06 Duration: 192ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7829847)) AND (("cash_track"."id" not in (5797612)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-16 13:32:06 Duration: 164ms

18

30ms

98ms

44ms

66,215

Details

48m53s

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
Dec 16	00	138	5s340ms	38ms
	01	12	501ms	41ms
	02	15	640ms	42ms
	03	11	468ms	42ms
	04	3	129ms	43ms
	07	11	464ms	42ms
	08	334	13s428ms	40ms
	09	7,087	4m54s	41ms
	10	6,055	4m21s	43ms
	11	3,496	2m29s	42ms
	12	4,899	3m29s	42ms
	13	7,802	5m41s	43ms
	14	7,731	5m27s	42ms
	15	9,559	6m40s	41ms
	16	5,842	4m4s	41ms
	17	5,803	4m52s	50ms
	18	6,229	5m31s	53ms
	19	608	30s478ms	50ms
	20	257	12s692ms	49ms
	21	181	9s185ms	50ms
	22	142	7s456ms	52ms

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

Date: 2024-12-16 10:44:03 Duration: 98ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3616752) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:13:17 Duration: 94ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3571335) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:14:41 Duration: 85ms

19

29ms

129ms

39ms

154,780

Details

1h42m42s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 16	00	2,450	1m29s	36ms
	01	3,049	1m52s	36ms
	02	1,421	51s974ms	36ms
	03	2,686	1m38s	36ms
	04	2,339	1m26s	36ms
	05	1,756	1m4s	36ms
	06	1,497	55s519ms	37ms
	07	593	21s140ms	35ms
	08	2,189	1m20s	36ms
	09	9,680	6m16s	38ms
	10	13,306	8m53s	40ms
	11	11,527	7m44s	40ms
	12	11,765	7m47s	39ms
	13	13,732	9m22s	40ms
	14	9,883	6m31s	39ms
	15	10,455	6m46s	38ms
	16	9,708	6m17s	38ms
	17	10,049	6m58s	41ms
	18	10,496	7m37s	43ms
	19	8,889	5m53s	39ms
	20	6,630	4m18s	39ms
	21	6,835	4m35s	40ms
	22	3,845	2m39s	41ms

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

Date: 2024-12-16 17:21:54 Duration: 129ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3319563)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-16 17:21:54 Duration: 122ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3602801)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-16 12:01:38 Duration: 91ms

20

28ms

81ms

39ms

28,180

Details

18m39s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 16	08	133	4s781ms	35ms
	09	2,991	1m50s	36ms
	10	3,247	2m5s	38ms
	11	1,701	1m7s	39ms
	12	2,440	1m35s	39ms
	13	2,780	1m48s	39ms
	14	3,487	2m13s	38ms
	15	4,104	2m34s	37ms
	16	2,308	1m25s	37ms
	17	2,447	1m50s	45ms
	18	2,542	2m3s	48ms

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

Date: 2024-12-16 18:38:09 Duration: 81ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3443007) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:38:09 Duration: 77ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3442024) ORDER BY "collection_policy"."id";

Date: 2024-12-16 18:38:09 Duration: 75ms

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

20,375,371 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	17	0.00%
DETAIL	22	0.00%
ERROR	12,907	0.06%
EVENTLOG	2,455	0.01%
FATAL	2,110	0.01%
HINT	11	0.00%
LOG	20,344,905	99.85%
STATEMENT	12,944	0.06%

Events distribution (except queries)

Key values

0 PANIC entries
2110 FATAL entries
12907 ERROR entries
0 WARNING entries
2455 EVENTLOG entries

Most Frequent Errors/Events

Key values

6,609 Max number of times the same event was reported
17,472 Total events found

Rank

Times reported

Error

1

6,609

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 16	00	10
	01	12
	02	11
	03	4
	04	9
	05	5
	06	15
	07	5
	08	80
	09	233
	10	491
	11	885
	12	865
	13	806
	14	1,229
	15	586
	16	481
	17	488
	18	131
	19	78
	20	45
	21	65
	22	75

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

6,248

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 16	00	8
	01	11
	02	8
	03	3
	04	3
	05	3
	06	11
	07	5
	08	76
	09	220
	10	467
	11	839
	12	827
	13	762
	14	1,154
	15	573
	16	467
	17	466
	18	108
	19	67
	20	44
	21	59
	22	67

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

1,756

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 16	00	29
	09	57
	10	78
	11	226
	12	210
	13	231
	14	255
	15	42
	16	254
	17	215
	18	82
	19	26
	20	30
	21	21

4

1,756

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 16	00	29
	09	57
	10	78
	11	226
	12	210
	13	231
	14	255
	15	42
	16	254
	17	215
	18	82
	19	26
	20	30
	21	21

5

487

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 16	00	4
	09	7
	10	22
	11	67
	12	48
	13	62
	14	66
	15	23
	16	103
	17	45
	18	17
	19	7
	20	5
	21	8
	22	3

6

223

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 16	17	223

7

211

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 16	00	2
	09	2
	10	8
	11	28
	12	19
	13	29
	14	28
	15	9
	16	52
	17	15
	18	9
	19	2
	20	3
	21	5

8

74

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 16	17	74

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

9

24

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 16	11	2
	13	2
	14	4
	16	5
	17	11

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

10

15

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 16	14	8
	15	7

11

12

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 16	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

12

11

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 16	11	2
	13	2
	16	3
	17	2
	18	2

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

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 16	12	2
	17	3
	19	1

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

14

6

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 16	04	3
	14	3

FATAL: password authentication failed for user "postgres"

15

6

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 16	17	6

16

6

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 16	01	1
	09	1
	11	1
	13	1
	14	1
	21	1

17

5

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 16	01	1
	11	1
	13	1
	14	1
	21	1

18

5

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 16	01	1
	11	1
	13	1
	14	1
	21	1

19

3

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 16	10	1
	11	1
	16	1

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

20

3

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 16	12	2
	17	1

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

21

2

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 16	17	2

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

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 16	14	1

ERROR: duplicate key value violates unique constraint "ir_filters_name_model_uid_unique_action_index"

23

1

Details

FATAL: received unencrypted data after SSL request

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 16	02	1

FATAL: received unencrypted data after SSL request

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 16	09	1

25

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Dec 16	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