pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Dec 24 23:47:40 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 47,553,341 log entries in 2m39s
Log start from 2024-12-24 00:00:00 to 2024-12-24 22:45:01

Global Stats

21,074 Number of unique normalized queries
20,350,954 Number of queries
7d5h55m51s Total query duration
2024-12-24 00:00:00 First query
2024-12-24 22:45:01 Last query
8,493 queries/s at 2024-12-24 11:25:13 Query peak

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

27,183 Number of events
29 Number of unique normalized events
10,912 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,350,954 Average queries per session
7d5h55m51s 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

8,493 queries/s Query Peak
2024-12-24 11:25:13 Date

SELECT Traffic

Key values

5,813 queries/s Query Peak
2024-12-24 11:25:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,818 queries/s Query Peak
2024-12-24 11:25:13 Date

Queries duration

Key values

7d5h55m51s 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 24	00	314,603	0ms	4s626ms	21ms	3m42s	4m20s	4m39s
	01	272,535	0ms	1s473ms	22ms	2m41s	3m34s	4m18s
	02	222,862	0ms	1s942ms	19ms	2m41s	2m59s	4m25s
	03	234,637	0ms	996ms	21ms	2m16s	2m36s	2m58s
	04	263,765	0ms	681ms	23ms	3m46s	3m59s	5m4s
	05	184,900	0ms	4s653ms	22ms	2m47s	3m24s	3m38s
	06	247,057	0ms	25s122ms	19ms	2m29s	3m32s	4m5s
	07	253,134	0ms	616ms	14ms	2m17s	2m40s	3m28s
	08	506,860	0ms	8m7s	16ms	2m33s	3m13s	1h12m6s
	09	1,259,292	0ms	13m47s	41ms	1h4m47s	1h21m34s	1h58m28s
	10	1,473,219	0ms	1m25s	12ms	7m15s	8m38s	31m27s
	11	1,764,813	0ms	12m57s	29ms	39m1s	1h9m32s	3h28m41s
	12	1,730,947	0ms	25m50s	27ms	19m16s	43m19s	7h4m21s
	13	1,619,656	0ms	18m58s	34ms	39m21s	1h50m18s	5h9m46s
	14	1,616,035	0ms	8m58s	28ms	44m46s	1h9m40s	1h55m17s
	15	1,687,228	0ms	15m17s	33ms	38m45s	1h40m34s	4h20m41s
	16	1,443,228	0ms	30m40s	33ms	6m36s	31m15s	5h42m50s
	17	1,339,588	0ms	1m22s	14ms	8m	10m58s	34m48s
	18	1,150,991	0ms	41m18s	37ms	6m26s	7m25s	7h56m51s
	19	1,000,444	0ms	23m56s	55ms	8m3s	1h20m47s	5h29m5s
	20	757,924	0ms	4s694ms	35ms	11m18s	12m51s	18m19s
	21	662,041	0ms	50m58s	64ms	5m25s	6m2s	8h18m5s
	22	345,195	0ms	59m58s	36ms	4m6s	5m	2h1m9s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 24	00	166,278	41ms	2m52s	3m42s	4m21s
	01	140,662	43ms	2m22s	2m40s	3m53s
	02	109,799	39ms	1m50s	2m40s	3m3s
	03	113,881	43ms	2m6s	2m16s	2m39s
	04	133,168	46ms	2m50s	3m45s	4m13s
	05	89,917	46ms	1m58s	2m46s	3m32s
	06	130,527	35ms	1m57s	2m29s	3m31s
	07	132,974	27ms	1m34s	2m17s	2m39s
	08	297,895	13ms	2m	2m26s	3m12s
	09	782,909	15ms	4m36s	5m25s	6m23s
	10	862,454	19ms	6m15s	7m9s	8m37s
	11	1,076,780	16ms	6m5s	6m50s	9m11s
	12	1,080,641	10ms	4m19s	5m28s	7m8s
	13	999,131	12ms	4m32s	5m8s	7m38s
	14	1,001,454	14ms	5m34s	6m8s	7m43s
	15	1,048,126	14ms	5m38s	6m46s	9m30s
	16	864,675	15ms	5m12s	5m32s	6m23s
	17	817,799	22ms	6m20s	7m58s	10m56s
	18	677,893	22ms	5m38s	6m6s	7m23s
	19	603,303	25ms	6m33s	7m1s	8m2s
	20	438,719	62ms	10m35s	11m16s	14m22s
	21	399,174	32ms	4m33s	5m14s	6m1s
	22	205,061	26ms	2m53s	3m56s	5m39s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 24	00	27,146	5,854	141	0	0ms	155ms	199ms	263ms
	01	26,684	5,986	157	0	0ms	134ms	186ms	244ms
	02	15,666	4,492	142	0	0ms	92ms	121ms	180ms
	03	15,937	5,481	151	0	0ms	100ms	128ms	170ms
	04	24,089	5,487	133	0	0ms	136ms	200ms	268ms
	05	14,577	3,497	137	0	0ms	87ms	121ms	234ms
	06	16,567	5,166	157	0	1ms	106ms	141ms	218ms
	07	13,349	4,550	180	0	0ms	76ms	118ms	175ms
	08	16,836	7,212	484	0	175ms	107ms	137ms	225ms
	09	47,997	17,617	689	0	606ms	348ms	478ms	1h20m14s
	10	68,425	20,377	796	0	18ms	397ms	454ms	664ms
	11	77,022	21,466	779	0	335ms	528ms	27s217ms	1h7m44s
	12	58,511	27,908	607	5	411ms	558ms	818ms	40m36s
	13	60,617	21,594	815	3	514ms	493ms	605ms	1h49m7s
	14	64,976	27,415	498	0	337ms	495ms	1m43s	1h5m47s
	15	68,072	31,670	815	2	410ms	508ms	1s262ms	1h37m14s
	16	58,142	21,154	782	0	438ms	388ms	498ms	28m56s
	17	69,188	23,198	930	0	21ms	572ms	717ms	13s481ms
	18	70,415	20,258	882	1	309ms	462ms	541ms	972ms
	19	65,838	20,211	563	1	465ms	454ms	585ms	1h18m16s
	20	80,453	26,791	444	0	0ms	501ms	665ms	837ms
	21	53,907	16,557	411	0	418ms	316ms	370ms	534ms
	22	27,326	7,337	298	0	206ms	204ms	308ms	495ms

Day	Hour	Percentage of prepare
Dec 24	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 24	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 24	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

224,768 buffers Checkpoint Peak
2024-12-24 21:01:21 Date
270.058 seconds Highest write time
0.107 seconds Sync time

Checkpoints Wal files

Key values

208 files Wal files usage Peak
2024-12-24 15:55:54 Date

Checkpoints distance

Key values

6,656.54 Mo Distance Peak
2024-12-24 15:55:54 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 24	00	88,934	3,239.63s	0.03s	3,239.71s
	01	124,256	3,239.56s	0.032s	3,239.638s
	02	105,983	3,239.584s	0.026s	3,239.66s
	03	140,377	3,165.449s	0.029s	3,165.545s
	04	138,282	3,174.551s	0.036s	3,174.634s
	05	89,901	3,089.501s	0.044s	3,089.588s
	06	110,827	3,239.666s	0.035s	3,239.746s
	07	143,505	3,239.576s	0.034s	3,239.65s
	08	126,547	3,239.556s	0.044s	3,239.64s
	09	322,216	3,239.463s	0.047s	3,239.585s
	10	467,917	3,239.542s	0.053s	3,239.692s
	11	558,960	3,239.481s	0.059s	3,239.637s
	12	434,113	2,861.849s	0.073s	2,862.003s
	13	509,539	3,239.585s	0.051s	3,239.72s
	14	406,442	3,239.448s	0.045s	3,239.577s
	15	724,859	3,239.3s	0.171s	3,239.731s
	16	443,326	3,239.387s	0.05s	3,239.615s
	17	362,456	2,916.883s	0.068s	2,917.127s
	18	402,913	3,239.59s	0.045s	3,239.712s
	19	254,706	3,239.507s	0.067s	3,239.637s
	20	365,474	3,239.444s	0.051s	3,239.586s
	21	473,773	3,239.493s	0.049s	3,239.636s
	22	137,753	2,429.698s	0.03s	2,429.764s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 24	00	0	0	41	2,926	0.002s	0.012s
	01	0	0	56	2,939	0.002s	0.012s
	02	0	0	48	2,792	0.002s	0.012s
	03	0	0	62	2,512	0.002s	0.012s
	04	0	0	63	2,416	0.006s	0.012s
	05	0	0	42	2,243	0.020s	0.012s
	06	0	0	48	2,364	0.006s	0.012s
	07	0	0	61	3,126	0.002s	0.012s
	08	0	0	49	3,783	0.012s	0.012s
	09	0	0	135	4,783	0.004s	0.012s
	10	0	0	203	5,211	0.003s	0.012s
	11	0	0	241	5,289	0.003s	0.012s
	12	0	0	185	5,212	0.012s	0.012s
	13	0	0	217	5,330	0.002s	0.012s
	14	0	0	173	5,470	0.002s	0.012s
	15	1	49	378	6,296	0.008s	0.012s
	16	0	88	121	5,521	0.002s	0.012s
	17	0	56	98	5,457	0.009s	0.012s
	18	0	0	169	5,541	0.002s	0.012s
	19	0	0	109	5,434	0.007s	0.012s
	20	0	11	151	5,104	0.003s	0.012s
	21	0	9	219	4,988	0.002s	0.012s
	22	0	0	55	3,555	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 24	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 24	00	55,345.00 kB	84,060.50 kB
	01	76,950.08 kB	108,324.92 kB
	02	65,505.58 kB	96,875.17 kB
	03	84,817.50 kB	119,329.33 kB
	04	85,846.25 kB	131,252.75 kB
	05	57,540.67 kB	106,239.25 kB
	06	65,962.50 kB	106,986.92 kB
	07	82,867.83 kB	114,367.75 kB
	08	64,463.91 kB	90,803.55 kB
	09	185,009.08 kB	215,858.75 kB
	10	276,174.50 kB	325,263.08 kB
	11	345,713.70 kB	384,908.70 kB
	12	260,098.64 kB	350,676.36 kB
	13	295,053.50 kB	331,544.83 kB
	14	236,658.83 kB	305,320.50 kB
	15	582,840.33 kB	628,645.58 kB
	16	285,240.17 kB	1,985,872.17 kB
	17	210,874.92 kB	553,955.50 kB
	18	229,828.67 kB	274,077.75 kB
	19	149,547.75 kB	252,566.75 kB
	20	221,042.83 kB	294,624.33 kB
	21	311,563.42 kB	1,279,424.33 kB
	22	99,613.67 kB	486,268.89 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (271) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	271
shutdown immediate	2
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 24	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 24	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,173,220 Total read queries
5,554,731 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	12,173,220	59.82%
INSERT	1,041,740	5.12%
UPDATE	351,278	1.73%
DELETE	10,991	0.05%
COPY FROM	12	0.00%
COPY TO	0	0.00%
CTE	37,847	0.19%
DDL	4,539	0.02%
TCL	4,108,324	20.19%
CURSOR	0	0.00%
OTHERS	2,623,003	12.89%

Queries by database

Key values

unknown Main database
20,350,954 Requests
7d5h55m51s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	20,350,954	7d5h55m51s
	copy from	12	16ms
	cte	37,847	8s127ms
	ddl	4,539	3s366ms
	delete	10,991	1m8s
	insert	1,041,740	5m30s
	others	2,623,003	1m58s
	select	12,173,220	2d22h7m17s
	tcl	4,108,324	2m49s
	update	351,278	4d7h36m53s

Queries by user

Key values

unknown Main user
20,350,954 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	20,350,954	7d5h55m51s
	copy from	12	16ms
	cte	37,847	8s127ms
	ddl	4,539	3s366ms
	delete	10,991	1m8s
	insert	1,041,740	5m30s
	others	2,623,003	1m58s
	select	12,173,220	2d22h7m17s
	tcl	4,108,324	2m49s
	update	351,278	4d7h36m53s

Duration by user

Key values

7d5h55m51s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	20,350,954	7d5h55m51s
	copy from	12	16ms
	cte	37,847	8s127ms
	ddl	4,539	3s366ms
	delete	10,991	1m8s
	insert	1,041,740	5m30s
	others	2,623,003	1m58s
	select	12,173,220	2d22h7m17s
	tcl	4,108,324	2m49s
	update	351,278	4d7h36m53s

Queries by host

Key values

unknown Main host
20,350,954 Requests
7d5h55m51s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	20,350,954	7d5h55m51s
	copy from	12	16ms
	cte	37,847	8s127ms
	ddl	4,539	3s366ms
	delete	10,991	1m8s
	insert	1,041,740	5m30s
	others	2,623,003	1m58s
	select	12,173,220	2d22h7m17s
	tcl	4,108,324	2m49s
	update	351,278	4d7h36m53s

Queries by application

Key values

unknown Main application
20,350,954 Requests
7d5h55m51s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	20,350,954	7d5h55m51s
	copy from	12	16ms
	cte	37,847	8s127ms
	ddl	4,539	3s366ms
	delete	10,991	1m8s
	insert	1,041,740	5m30s
	others	2,623,003	1m58s
	select	12,173,220	2d22h7m17s
	tcl	4,108,324	2m49s
	update	351,278	4d7h36m53s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-24 17:45:00 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

19,050,681 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	19,050,681	93.61%
1-5ms	308,792	1.52%
5-10ms	15,436	0.08%
10-25ms	52,920	0.26%
25-50ms	231,493	1.14%
50-100ms	52,634	0.26%
100-500ms	513,282	2.52%
500-1000ms	118,453	0.58%
1000-10000ms	5,501	0.03%
> 10000ms	1,762	0.01%

Slowest individual queries

Rank	Duration	Query
1	59m58s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-24 20:17:13.417430', exp_date = '2024-12-24 21:02:13.417433', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-24 22:17:11 ]
2	59m58s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-24 20:17:13.417428', exp_date = '2024-12-24 21:02:13.417431', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-24 22:17:11 ]
3	50m58s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:13:22.753261', exp_date = '2024-12-24 19:58:22.753265', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-24 21:04:21 ]
4	50m58s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:13:22.752731', exp_date = '2024-12-24 19:58:22.752735', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-24 21:04:21 ]
5	48m2s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:16:19.004153', exp_date = '2024-12-24 20:01:19.004157', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-24 21:04:21 ]
6	47m59s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:16:21.612978', exp_date = '2024-12-24 20:01:21.612983', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-24 21:04:21 ]
7	41m18s	update res_users set sid = 'e92d713ab0247d11e6b09cd64c03b5ad0baff7d7', last_update = '2024-12-24 17:01:53.576243', exp_date = '2024-12-24 17:46:53.576247', logged_in = 'TRUE' where id = 825; [ Date: 2024-12-24 18:43:11 ]
8	41m18s	update res_users set sid = 'e92d713ab0247d11e6b09cd64c03b5ad0baff7d7', last_update = '2024-12-24 17:01:53.576265', exp_date = '2024-12-24 17:46:53.576268', logged_in = 'TRUE' where id = 825; [ Date: 2024-12-24 18:43:11 ]
9	40m53s	update res_users set sid = 'e92d713ab0247d11e6b09cd64c03b5ad0baff7d7', last_update = '2024-12-24 17:02:18.134521', exp_date = '2024-12-24 17:47:18.134525', logged_in = 'TRUE' where id = 825; [ Date: 2024-12-24 18:43:11 ]
10	36m8s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:28:13.055343', exp_date = '2024-12-24 20:13:13.055347', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-24 21:04:21 ]
11	35m39s	update res_users set sid = 'e92d713ab0247d11e6b09cd64c03b5ad0baff7d7', last_update = '2024-12-24 17:07:32.508347', exp_date = '2024-12-24 17:52:32.508352', logged_in = 'TRUE' where id = 825; [ Date: 2024-12-24 18:43:11 ]
12	35m29s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:28:51.871594', exp_date = '2024-12-24 20:13:51.871599', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-24 21:04:21 ]
13	35m27s	update res_users set sid = 'e92d713ab0247d11e6b09cd64c03b5ad0baff7d7', last_update = '2024-12-24 17:07:44.327961', exp_date = '2024-12-24 17:52:44.327965', logged_in = 'TRUE' where id = 825; [ Date: 2024-12-24 18:43:11 ]
14	34m59s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:29:21.770613', exp_date = '2024-12-24 20:14:21.770617', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-24 21:04:21 ]
15	34m49s	UPDATE "res_users" SET "exp_date" = '2024-12-24 17:53:22.543533', "last_update" = '2024-12-24 17:08:22.543573', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:08:22.074267', "write_uid" = 825 WHERE id IN (825); [ Date: 2024-12-24 18:43:11 ]
16	32m16s	UPDATE "res_users" SET "exp_date" = '2024-12-24 17:55:55.629885', "last_update" = '2024-12-24 17:10:55.629918', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:10:55.248240', "write_uid" = 825 WHERE id IN (825); [ Date: 2024-12-24 18:43:11 ]
17	30m40s	update res_users set sid = 'e92d713ab0247d11e6b09cd64c03b5ad0baff7d7', last_update = '2024-12-24 15:02:39.814731', exp_date = '2024-12-24 15:47:39.814734', logged_in = 'TRUE' where id = 825; [ Date: 2024-12-24 16:33:20 ]
18	30m40s	update res_users set sid = 'e92d713ab0247d11e6b09cd64c03b5ad0baff7d7', last_update = '2024-12-24 15:02:39.814574', exp_date = '2024-12-24 15:47:39.814578', logged_in = 'TRUE' where id = 825; [ Date: 2024-12-24 16:33:20 ]
19	29m21s	UPDATE "res_users" SET "exp_date" = '2024-12-24 17:58:50.622006', "last_update" = '2024-12-24 17:13:50.622030', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:13:50.227923', "write_uid" = 825 WHERE id IN (825); [ Date: 2024-12-24 18:43:11 ]
20	27m25s	UPDATE "res_users" SET "exp_date" = '2024-12-24 18:00:46.772904', "last_update" = '2024-12-24 17:15:46.772926', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:15:46.432496', "write_uid" = 825 WHERE id IN (825); [ Date: 2024-12-24 18:43:11 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d51m46s

82,893

Details

0ms

59m58s

4s206ms

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 24	00	771	166ms	0ms
	01	779	165ms	0ms
	02	841	175ms	0ms
	03	857	178ms	0ms
	04	718	151ms	0ms
	05	451	94ms	0ms
	06	699	147ms	0ms
	07	776	158ms	0ms
	08	2,108	1h8m26s	1s948ms
	09	5,227	11h6m	7s645ms
	10	6,247	26m50s	257ms
	11	8,549	8h57m5s	3s769ms
	12	8,125	9h49m54s	4s356ms
	13	7,687	11h25m37s	5s351ms
	14	7,748	8h25m53s	3s917ms
	15	8,043	11h6m23s	4s971ms
	16	6,223	9h43m32s	5s626ms
	17	5,009	30m33s	366ms
	18	3,996	3h30m34s	3s161ms
	19	3,339	10h40m47s	11s514ms
	20	2,066	620ms	0ms
	21	1,812	8h7s	15s898ms
	22	822	1h59m57s	8s755ms

update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-24 20:17:13.417430', exp_date = '2024-12-24 21:02:13.417433', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-24 22:17:11 Duration: 59m58s
update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-24 20:17:13.417428', exp_date = '2024-12-24 21:02:13.417431', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-24 22:17:11 Duration: 59m58s
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:13:22.753261', exp_date = '2024-12-24 19:58:22.753265', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-24 21:04:21 Duration: 50m58s

2

1d11h5m42s

256,925

Details

369ms

3s709ms

491ms

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 24	00	8,862	1h9m51s	473ms
	01	7,231	56m58s	472ms
	02	6,098	46m48s	460ms
	03	7,095	53m49s	455ms
	04	9,073	1h10m23s	465ms
	05	5,910	45m8s	458ms
	06	5,518	42m23s	461ms
	07	4,820	36m30s	454ms
	08	4,316	32m45s	455ms
	09	12,667	1h43m14s	489ms
	10	16,200	2h17m24s	508ms
	11	20,203	2h53m44s	516ms
	12	11,460	1h34m11s	493ms
	13	12,705	1h41m39s	480ms
	14	10,617	1h26m43s	490ms
	15	11,512	1h36m6s	500ms
	16	13,537	1h50m26s	489ms
	17	16,866	2h21m33s	503ms
	18	13,364	1h48m40s	487ms
	19	13,403	1h50m20s	493ms
	20	24,879	3h43m5s	538ms
	21	15,057	2h8s	478ms
	22	5,532	43m42s	474ms

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

Date: 2024-12-24 20:00:52 Duration: 3s709ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3902287)) AND (("shipping_track"."id" not in (31831379, 31831379)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:02:02 Duration: 3s491ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3902279)) AND (("shipping_track"."id" not in (31831318, 31831318)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:01:52 Duration: 3s441ms

3

7h56m52s

128,798

Details

149ms

1s527ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 24	00	1,259	4m31s	216ms
	01	1,352	4m52s	215ms
	02	1,341	4m46s	213ms
	03	2,622	9m27s	216ms
	04	2,135	7m42s	216ms
	05	2,111	7m34s	215ms
	06	2,912	10m27s	215ms
	07	2,271	8m15s	218ms
	08	2,446	8m47s	215ms
	09	5,871	22m24s	229ms
	10	7,160	28m32s	239ms
	11	4,748	19m36s	247ms
	12	4,129	14m46s	214ms
	13	4,152	12m27s	179ms
	14	13,990	42m28s	182ms
	15	13,806	43m2s	187ms
	16	5,403	15m59s	177ms
	17	9,536	33m38s	211ms
	18	5,404	20m55s	232ms
	19	7,691	29m58s	233ms
	20	27,759	2h4m3s	268ms
	21	700	2m32s	218ms

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

Date: 2024-12-24 20:01:09 Duration: 1s527ms
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" = '9343574')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-24 20:01:54 Duration: 1s370ms
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" = '9420453')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-24 20:01:41 Duration: 1s345ms

4

6h36m58s

47,525

Details

384ms

3s96ms

501ms

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 24	00	281	2m18s	493ms
	01	249	2m2s	492ms
	02	213	1m44s	490ms
	03	228	1m54s	500ms
	04	185	1m37s	528ms
	05	106	55s256ms	521ms
	06	189	1m32s	488ms
	07	464	3m40s	474ms
	08	1,527	11m45s	461ms
	09	2,756	23m4s	502ms
	10	4,001	34m42s	520ms
	11	5,022	44m37s	533ms
	12	3,022	25m36s	508ms
	13	4,083	33m26s	491ms
	14	3,160	26m37s	505ms
	15	3,540	29m56s	507ms
	16	3,713	30m20s	490ms
	17	4,559	38m3s	500ms
	18	3,288	26m28s	483ms
	19	2,073	16m35s	480ms
	20	2,022	18m6s	537ms
	21	1,710	13m18s	466ms
	22	1,134	8m32s	452ms

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

Date: 2024-12-24 20:00:46 Duration: 3s96ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2660648)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:00:48 Duration: 2s848ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3878295)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:00:56 Duration: 2s421ms

5

5h42m40s

353

Details

0ms

34m49s

58s246ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 24	00	2	0ms	0ms
	01	3	3ms	1ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	05	3	0ms	0ms
	06	4	2ms	0ms
	07	1	0ms	0ms
	08	19	3m2s	9s589ms
	09	21	27ms	1ms
	10	27	21ms	0ms
	11	30	7m44s	15s490ms
	12	33	3m25s	6s234ms
	13	34	9m56s	17s546ms
	14	32	13m43s	25s743ms
	15	31	10m29s	20s312ms
	16	19	1m36s	5s91ms
	17	19	1m22s	4s368ms
	18	35	4h21m15s	7m27s
	19	19	15m46s	49s790ms
	20	6	3ms	0ms
	21	12	14m16s	1m11s
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-24 17:53:22.543533', "last_update" = '2024-12-24 17:08:22.543573', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:08:22.074267', "write_uid" = 825 WHERE id IN (825);

Date: 2024-12-24 18:43:11 Duration: 34m49s
UPDATE "res_users" SET "exp_date" = '2024-12-24 17:55:55.629885', "last_update" = '2024-12-24 17:10:55.629918', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:10:55.248240', "write_uid" = 825 WHERE id IN (825);

Date: 2024-12-24 18:43:11 Duration: 32m16s
UPDATE "res_users" SET "exp_date" = '2024-12-24 17:58:50.622006', "last_update" = '2024-12-24 17:13:50.622030', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:13:50.227923', "write_uid" = 825 WHERE id IN (825);

Date: 2024-12-24 18:43:11 Duration: 29m21s

6

3h45m21s

57,153

Details

88ms

881ms

236ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 24	00	3,578	12m40s	212ms
	01	3,878	12m4s	186ms
	02	1,280	4m18s	202ms
	03	800	3m7s	234ms
	04	2,008	7m27s	222ms
	05	988	3m42s	224ms
	06	1,476	5m43s	232ms
	07	326	1m12s	220ms
	08	6	1s509ms	251ms
	09	60	18s856ms	314ms
	10	814	2m54s	214ms
	11	332	1m23s	251ms
	12	426	1m37s	227ms
	13	434	1m41s	234ms
	14	716	2m58s	249ms
	15	1,755	6m29s	221ms
	16	3,286	13m24s	244ms
	17	4,658	19m50s	255ms
	18	5,414	22m47s	252ms
	19	8,483	34m20s	242ms
	20	5,619	25m56s	277ms
	21	6,896	26m25s	229ms
	22	3,920	14m53s	227ms

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-24 20:09:41 Duration: 881ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مينا')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-24 20:09:41 Duration: 878ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ابراهيم')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-24 20:39:21 Duration: 878ms

7

2h53m6s

10,356

Details

258ms

1s716ms

1s2ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 24	00	638	10m21s	973ms
	01	733	11m48s	966ms
	02	332	5m24s	976ms
	03	56	54s921ms	980ms
	09	16	18s153ms	1s134ms
	10	37	38s513ms	1s40ms
	11	13	14s828ms	1s140ms
	12	87	1m27s	1s1ms
	13	1	928ms	928ms
	14	136	2m19s	1s27ms
	15	278	4m51s	1s50ms
	16	706	12m4s	1s26ms
	17	879	15m31s	1s60ms
	18	890	14m57s	1s8ms
	19	1,812	28m51s	955ms
	20	1,346	24m11s	1s78ms
	21	1,824	30m1s	987ms
	22	572	9m7s	957ms

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

Date: 2024-12-24 20:10:40 Duration: 1s716ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9564151')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-24 20:13:22 Duration: 1s536ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9562013')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-24 20:10:37 Duration: 1s514ms

8

1h57m18s

27,324

Details

154ms

944ms

257ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 24	07	31	10s676ms	344ms
	08	739	3m12s	260ms
	09	1,304	6m7s	282ms
	10	2,543	12m40s	299ms
	11	1,754	8m52s	303ms
	12	1,228	5m45s	281ms
	13	1,904	7m12s	227ms
	14	6,638	25m27s	230ms
	15	4,723	18m19s	232ms
	16	1,900	7m19s	231ms
	17	2,165	10m13s	283ms
	18	1,596	7m41s	289ms
	19	578	2m41s	279ms
	20	221	1m30s	411ms

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

Date: 2024-12-24 20:00:56 Duration: 944ms
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" = '9302870')))) ORDER BY "collection_policy"."id";

Date: 2024-12-24 20:00:57 Duration: 659ms
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" = '9489304')))) ORDER BY "collection_policy"."id";

Date: 2024-12-24 17:01:22 Duration: 641ms

9

1h45m42s

152,969

Details

30ms

195ms

41ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 24	00	3,250	2m8s	39ms
	01	2,823	1m50s	39ms
	02	2,071	1m21s	39ms
	03	1,727	1m7s	39ms
	04	3,208	2m7s	39ms
	05	1,587	1m2s	39ms
	06	1,272	50s304ms	39ms
	07	1,544	1m1s	39ms
	08	3,076	2m1s	39ms
	09	8,154	5m41s	41ms
	10	12,042	8m39s	43ms
	11	16,862	12m18s	43ms
	12	9,733	6m48s	42ms
	13	10,746	7m21s	41ms
	14	9,539	6m37s	41ms
	15	9,694	6m50s	42ms
	16	10,168	6m55s	40ms
	17	10,055	7m1s	41ms
	18	9,164	6m8s	40ms
	19	7,694	5m6s	39ms
	20	8,993	6m33s	43ms
	21	6,482	4m9s	38ms
	22	3,085	1m57s	37ms

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

Date: 2024-12-24 17:02:22 Duration: 195ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3901697)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-24 20:00:58 Duration: 179ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3888384)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-24 20:00:55 Duration: 178ms

10

1h40m2s

18,619

Details

197ms

1s951ms

322ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 24	00	1,169	6m	308ms
	01	1,229	6m14s	304ms
	02	311	1m33s	300ms
	03	346	1m45s	304ms
	04	1,013	5m11s	307ms
	05	506	2m33s	302ms
	06	742	3m45s	303ms
	07	165	49s482ms	299ms
	08	3	911ms	303ms
	09	20	6s717ms	335ms
	10	391	2m10s	334ms
	11	160	53s562ms	334ms
	12	139	45s636ms	328ms
	13	221	1m3s	286ms
	14	239	1m7s	281ms
	15	612	2m53s	284ms
	16	954	4m33s	286ms
	17	1,483	8m20s	337ms
	18	1,856	10m19s	333ms
	19	2,492	13m40s	329ms
	20	1,481	9m42s	393ms
	21	1,676	9m5s	325ms
	22	1,411	7m26s	316ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '8280272')) 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-24 20:01:07 Duration: 1s951ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9467394')) 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-24 20:01:02 Duration: 1s624ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9569587')) 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-24 20:00:53 Duration: 1s598ms

11

45m54s

12,910

Details

153ms

1s293ms

213ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) 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 #11

Day	Hour	Count	Duration	Avg duration
Dec 24	00	8	1s714ms	214ms
	01	11	2s365ms	215ms
	04	381	1m22s	216ms
	05	673	2m24s	214ms
	06	1,003	3m36s	216ms
	07	756	2m45s	218ms
	08	740	2m39s	216ms
	09	1,479	5m34s	226ms
	10	1,298	5m11s	240ms
	11	364	1m27s	239ms
	12	799	2m48s	210ms
	13	411	1m12s	175ms
	14	829	2m30s	180ms
	15	1,272	3m56s	185ms
	16	729	2m8s	176ms
	17	544	1m58s	217ms
	18	683	2m36s	229ms
	19	349	1m19s	227ms
	20	195	54s131ms	277ms
	21	386	1m24s	219ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9508602')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-24 20:00:50 Duration: 1s293ms
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" = '9468900')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-24 20:00:46 Duration: 673ms
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" = '9508606')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-24 20:00:57 Duration: 427ms

12

45m51s

45

Details

0ms

12m40s

1m1s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 24	03	2	0ms	0ms
	08	1	0ms	0ms
	09	4	3m16s	49s144ms
	10	4	3ms	0ms
	11	4	5m36s	1m24s
	12	4	3m31s	52s897ms
	13	5	15m24s	3m4s
	14	4	6ms	1ms
	15	6	5m22s	53s717ms
	17	2	3ms	1ms
	18	2	2ms	1ms
	19	5	12m40s	2m32s
	20	1	0ms	0ms
	22	1	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-24 18:37:40.111834', "last_update" = '2024-12-24 17:52:40.111859', "write_date" = '2024-12-24 17:52:39.709034', "write_uid" = 1 WHERE id IN (1044);

Date: 2024-12-24 19:05:20 Duration: 12m40s
UPDATE "res_users" SET "exp_date" = '2024-12-24 13:11:20.009128', "last_update" = '2024-12-24 12:26:20.009155', "write_date" = '2024-12-24 12:26:19.575616', "write_uid" = 886 WHERE id IN (886);

Date: 2024-12-24 13:38:20 Duration: 12m
UPDATE "res_users" SET "exp_date" = '2024-12-24 11:10:43.988994', "last_update" = '2024-12-24 10:25:43.989019', "write_date" = '2024-12-24 10:25:43.659622', "write_uid" = 1 WHERE id IN (959);

Date: 2024-12-24 11:31:20 Duration: 5m36s

13

44m5s

59,175

Details

32ms

162ms

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

Day	Hour	Count	Duration	Avg duration
Dec 24	00	1	46ms	46ms
	01	1	40ms	40ms
	02	6	288ms	48ms
	03	32	1s423ms	44ms
	06	1	48ms	48ms
	07	79	3s543ms	44ms
	08	1,625	1m12s	44ms
	09	5,085	3m55s	46ms
	10	4,791	3m49s	47ms
	11	7,939	6m26s	48ms
	12	2,186	1m40s	45ms
	13	5,303	3m34s	40ms
	14	7,296	5m1s	41ms
	15	6,439	4m33s	42ms
	16	6,841	4m38s	40ms
	17	3,763	2m57s	47ms
	18	4,722	3m42s	47ms
	19	1,616	1m18s	48ms
	20	796	39s645ms	49ms
	21	475	22s527ms	47ms
	22	178	8s243ms	46ms

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

Date: 2024-12-24 17:02:19 Duration: 162ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3868369) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-24 17:22:00 Duration: 113ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3717012) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-24 14:45:30 Duration: 94ms

14

39m18s

10,916

Details

191ms

252ms

216ms

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 24	00	1,224	4m24s	216ms
	01	1,291	4m39s	216ms
	02	1,271	4m31s	213ms
	03	2,554	9m12s	216ms
	04	1,477	5m20s	216ms
	05	1,077	3m53s	216ms
	06	1,034	3m42s	215ms
	07	988	3m36s	218ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9559143')) 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-24 00:53:45 Duration: 252ms
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" = '9538358')) 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-24 04:48:22 Duration: 252ms
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" = '9538268')) 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-24 04:48:20 Duration: 252ms

15

32m23s

19,843

Details

78ms

263ms

97ms

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

Day	Hour	Count	Duration	Avg duration
Dec 24	01	16	1s569ms	98ms
	02	13	1s227ms	94ms
	03	17	1s579ms	92ms
	07	46	4s321ms	93ms
	08	384	36s257ms	94ms
	09	1,030	1m41s	98ms
	10	1,218	2m2s	100ms
	11	1,932	3m11s	99ms
	12	2,074	3m18s	95ms
	13	2,718	4m20s	95ms
	14	3,194	5m8s	96ms
	15	2,022	3m21s	99ms
	16	1,269	2m4s	98ms
	17	958	1m38s	102ms
	18	1,153	1m54s	99ms
	19	748	1m11s	95ms
	20	311	33s485ms	107ms
	21	583	54s211ms	92ms
	22	157	15s182ms	96ms

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

Date: 2024-12-24 17:22:08 Duration: 263ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7874203)) AND (("cash_track"."id" not in (6133683)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-24 12:47:46 Duration: 233ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7873125)) AND (("cash_track"."id" not in (6124295)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-24 10:04:15 Duration: 205ms

16

24m

6,565

Details

154ms

305ms

219ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) 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 #16

Day	Hour	Count	Duration	Avg duration
Dec 24	00	21	4s487ms	213ms
	04	59	13s37ms	220ms
	05	347	1m14s	215ms
	06	145	31s148ms	214ms
	07	257	55s244ms	214ms
	08	64	14s172ms	221ms
	09	2,481	9m29s	229ms
	10	545	2m11s	240ms
	11	306	1m14s	244ms
	12	299	1m10s	234ms
	13	167	29s495ms	176ms
	14	462	1m23s	181ms
	15	596	1m51s	187ms
	16	169	29s399ms	173ms
	17	79	17s67ms	216ms
	18	562	2m9s	230ms
	21	6	1s284ms	214ms

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" = '8329105')) 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-24 11:21:48 Duration: 305ms
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" = '8764661')) 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-24 10:03:32 Duration: 300ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '8558752')) 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-24 11:21:55 Duration: 298ms

17

23m14s

4,318

Details

18ms

897ms

322ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 24	00	4	1s546ms	386ms
	01	2	996ms	498ms
	02	1	467ms	467ms
	04	2	877ms	438ms
	06	3	888ms	296ms
	07	5	1s208ms	241ms
	08	56	10s871ms	194ms
	09	131	38s499ms	293ms
	10	1,652	11m8s	404ms
	11	286	1m21s	283ms
	12	392	1m53s	288ms
	13	391	1m32s	235ms
	14	395	1m35s	240ms
	15	291	1m21s	279ms
	16	182	56s264ms	309ms
	17	167	48s883ms	292ms
	18	187	42s400ms	226ms
	19	57	17s400ms	305ms
	20	57	23s730ms	416ms
	21	37	12s961ms	350ms
	22	20	5s555ms	277ms

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

Date: 2024-12-24 17:21:54 Duration: 897ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-24 10:38:20 Duration: 880ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-24 10:37:46 Duration: 773ms

18

15m2s

272

Details

29ms

4s694ms

3s319ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 24	09	4	13s182ms	3s295ms
	10	26	1m25s	3s301ms
	11	6	22s695ms	3s782ms
	12	19	1m3s	3s364ms
	13	13	43s40ms	3s310ms
	14	14	45s19ms	3s215ms
	15	47	2m14s	2s851ms
	16	35	2m1s	3s474ms
	17	30	1m46s	3s554ms
	18	15	51s275ms	3s418ms
	19	21	1m11s	3s424ms
	20	12	50s773ms	4s231ms
	21	13	41s905ms	3s223ms
	22	17	50s961ms	2s997ms

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

Date: 2024-12-24 20:42:58 Duration: 4s694ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))))) AND ("policy_number"."name"::text ilike '%900%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-24 20:42:57 Duration: 4s497ms
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-24 20:10:55 Duration: 4s451ms

19

14m46s

21,955

Details

29ms

74ms

40ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 24	07	24	874ms	36ms
	08	757	30s419ms	40ms
	09	821	35s271ms	42ms
	10	2,748	1m57s	42ms
	11	2,176	1m37s	44ms
	12	876	37s567ms	42ms
	13	1,695	1m2s	36ms
	14	3,436	2m8s	37ms
	15	2,995	1m55s	38ms
	16	2,439	1m29s	36ms
	17	1,460	1m	41ms
	18	1,926	1m23s	43ms
	19	382	17s15ms	44ms
	20	220	9s979ms	45ms

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

Date: 2024-12-24 12:04:26 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3408361) ORDER BY "collection_policy"."id";

Date: 2024-12-24 10:34:10 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3830703) ORDER BY "collection_policy"."id";

Date: 2024-12-24 20:10:41 Duration: 70ms

20

14m33s

5,975

Details

119ms

851ms

146ms

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 24	00	15	1s959ms	130ms
	01	1	130ms	130ms
	07	10	1s298ms	129ms
	08	87	11s648ms	133ms
	09	517	1m14s	144ms
	10	847	2m3s	146ms
	11	1,189	2m58s	150ms
	12	995	2m22s	143ms
	13	699	1m41s	145ms
	14	291	44s280ms	152ms
	15	308	45s480ms	147ms
	16	297	42s731ms	143ms
	17	161	24s372ms	151ms
	18	238	32s863ms	138ms
	19	66	9s416ms	142ms
	20	70	12s673ms	181ms
	21	82	11s60ms	134ms
	22	102	13s389ms	131ms

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

Date: 2024-12-24 20:00:51 Duration: 851ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-24 20:00:59 Duration: 812ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 65)) 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-24 11:02:06 Duration: 269ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,619,737

Details

1m58s

0ms

13ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 24	00	48,318	2s160ms	0ms
	01	41,418	1s902ms	0ms
	02	38,695	1s697ms	0ms
	03	40,492	1s829ms	0ms
	04	41,083	1s918ms	0ms
	05	32,093	1s422ms	0ms
	06	37,318	1s737ms	0ms
	07	39,699	1s872ms	0ms
	08	70,842	3s315ms	0ms
	09	154,363	6s14ms	0ms
	10	198,983	10s165ms	0ms
	11	224,373	9s566ms	0ms
	12	213,242	9s18ms	0ms
	13	203,642	8s896ms	0ms
	14	200,922	8s179ms	0ms
	15	206,335	9s83ms	0ms
	16	194,404	8s927ms	0ms
	17	164,663	7s888ms	0ms
	18	147,915	7s476ms	0ms
	19	120,829	5s211ms	0ms
	20	83,770	4s829ms	0ms
	21	74,989	3s616ms	0ms
	22	41,349	2s80ms	0ms

DISCARD ALL;

Date: 2024-12-24 11:32:33 Duration: 13ms
DISCARD ALL;

Date: 2024-12-24 19:23:57 Duration: 1ms
DISCARD ALL;

Date: 2024-12-24 10:53:33 Duration: 1ms

2

2,055,146

Details

28s913ms

0ms

19ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 24	00	33,354	496ms	0ms
	01	28,776	440ms	0ms
	02	27,019	402ms	0ms
	03	29,331	436ms	0ms
	04	29,892	454ms	0ms
	05	22,330	344ms	0ms
	06	28,635	426ms	0ms
	07	31,141	450ms	0ms
	08	56,504	771ms	0ms
	09	125,894	1s561ms	0ms
	10	160,197	2s228ms	0ms
	11	180,105	2s350ms	0ms
	12	172,383	2s202ms	0ms
	13	164,904	2s215ms	0ms
	14	157,804	2s95ms	0ms
	15	163,238	2s308ms	0ms
	16	150,443	2s103ms	0ms
	17	130,689	1s935ms	0ms
	18	115,977	1s755ms	0ms
	19	93,627	1s335ms	0ms
	20	63,587	1s220ms	0ms
	21	57,820	878ms	0ms
	22	31,496	497ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-24 13:48:33 Duration: 19ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-24 17:03:17 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-24 21:49:01 Duration: 0ms

3

1,335,686

Details

13s371ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 24	00	24,837	219ms	0ms
	01	21,339	193ms	0ms
	02	19,928	172ms	0ms
	03	20,815	182ms	0ms
	04	21,132	190ms	0ms
	05	16,665	146ms	0ms
	06	19,301	173ms	0ms
	07	20,446	184ms	0ms
	08	36,350	328ms	0ms
	09	78,295	763ms	0ms
	10	101,149	1s27ms	0ms
	11	114,137	1s155ms	0ms
	12	109,345	1s38ms	0ms
	13	103,363	1s29ms	0ms
	14	102,317	1s47ms	0ms
	15	105,198	1s86ms	0ms
	16	98,574	988ms	0ms
	17	83,473	923ms	0ms
	18	75,158	778ms	0ms
	19	61,460	610ms	0ms
	20	42,813	517ms	0ms
	21	38,370	400ms	0ms
	22	21,221	212ms	0ms

ROLLBACK;

Date: 2024-12-24 09:12:37 Duration: 1ms
ROLLBACK;

Date: 2024-12-24 15:22:52 Duration: 1ms
ROLLBACK;

Date: 2024-12-24 11:16:01 Duration: 0ms

4

1,316,611

Details

3m56s

0ms

21ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 24	00	24,167	3s889ms	0ms
	01	20,697	3s343ms	0ms
	02	19,324	2s948ms	0ms
	03	20,218	3s262ms	0ms
	04	20,518	3s372ms	0ms
	05	16,031	2s460ms	0ms
	06	18,624	2s955ms	0ms
	07	19,858	3s38ms	0ms
	08	35,788	5s319ms	0ms
	09	77,541	13s253ms	0ms
	10	100,505	16s521ms	0ms
	11	113,141	19s164ms	0ms
	12	107,110	17s46ms	0ms
	13	102,566	18s498ms	0ms
	14	100,761	18s767ms	0ms
	15	103,332	19s286ms	0ms
	16	97,725	18s67ms	0ms
	17	82,806	17s27ms	0ms
	18	74,401	14s298ms	0ms
	19	60,749	11s909ms	0ms
	20	42,210	9s833ms	0ms
	21	37,735	7s788ms	0ms
	22	20,804	3s952ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'a1e2787769e211390c1c11146b7629a2143713dd';

Date: 2024-12-24 15:22:31 Duration: 21ms
SELECT payload FROM http_sessions WHERE sid = 'ab21076c9ec72c5df79f6a714a66e96b72c3f696';

Date: 2024-12-24 11:20:01 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = 'a953c767255ec647ab3b1ef3657ae7b81fcb1e46';

Date: 2024-12-24 15:15:54 Duration: 15ms

5

1,308,858

Details

1m57s

0ms

2ms

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 24	00	24,237	1s993ms	0ms
	01	20,779	1s745ms	0ms
	02	19,427	1s583ms	0ms
	03	20,327	1s686ms	0ms
	04	20,627	1s744ms	0ms
	05	16,119	1s321ms	0ms
	06	18,703	1s547ms	0ms
	07	19,926	1s651ms	0ms
	08	35,419	2s849ms	0ms
	09	77,014	6s743ms	0ms
	10	99,392	8s623ms	0ms
	11	112,018	9s972ms	0ms
	12	106,380	9s14ms	0ms
	13	101,681	9s122ms	0ms
	14	100,261	9s219ms	0ms
	15	102,940	9s516ms	0ms
	16	97,117	8s739ms	0ms
	17	82,279	8s107ms	0ms
	18	73,792	6s661ms	0ms
	19	60,315	5s381ms	0ms
	20	41,892	4s470ms	0ms
	21	37,525	3s532ms	0ms
	22	20,688	1s838ms	0ms

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

Date: 2024-12-24 16:52:37 Duration: 2ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-24 20:28:11 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-24 12:20:06 Duration: 1ms

6

929,038

Details

2m11s

0ms

10ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 24	00	10,451	1s630ms	0ms
	01	8,842	1s448ms	0ms
	02	8,553	1s373ms	0ms
	03	9,973	1s570ms	0ms
	04	10,540	1s666ms	0ms
	05	6,591	1s114ms	0ms
	06	11,279	1s720ms	0ms
	07	13,009	1s893ms	0ms
	08	26,018	3s500ms	0ms
	09	62,414	7s637ms	0ms
	10	79,611	11s482ms	0ms
	11	87,906	11s370ms	0ms
	12	84,710	11s333ms	0ms
	13	79,954	10s580ms	0ms
	14	71,013	9s441ms	0ms
	15	75,334	10s394ms	0ms
	16	68,098	9s823ms	0ms
	17	59,911	8s908ms	0ms
	18	51,502	8s545ms	0ms
	19	40,450	5s604ms	0ms
	20	25,832	5s105ms	0ms
	21	24,160	3s540ms	0ms
	22	12,887	1s986ms	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 (892);

Date: 2024-12-24 12:46:25 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 (1363);

Date: 2024-12-24 12:46:25 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 (1308);

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

7

717,285

Details

2m7s

0ms

62ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 24	00	8,517	1s573ms	0ms
	01	7,434	1s420ms	0ms
	02	7,093	1s478ms	0ms
	03	8,517	1s806ms	0ms
	04	8,758	1s619ms	0ms
	05	5,667	1s27ms	0ms
	06	9,334	1s413ms	0ms
	07	10,695	1s771ms	0ms
	08	20,097	3s151ms	0ms
	09	47,292	7s465ms	0ms
	10	58,994	9s820ms	0ms
	11	65,723	11s467ms	0ms
	12	62,792	9s931ms	0ms
	13	61,327	10s551ms	0ms
	14	55,101	9s618ms	0ms
	15	57,768	12s825ms	0ms
	16	51,736	8s256ms	0ms
	17	47,168	8s863ms	0ms
	18	40,753	7s28ms	0ms
	19	32,053	5s418ms	0ms
	20	20,753	5s207ms	0ms
	21	19,421	3s838ms	0ms
	22	10,292	1s922ms	0ms

COMMIT;

Date: 2024-12-24 15:51:10 Duration: 62ms
COMMIT;

Date: 2024-12-24 15:51:32 Duration: 46ms
COMMIT;

Date: 2024-12-24 15:50:35 Duration: 43ms

8

550,424

Details

36s61ms

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 24	00	6,166	366ms	0ms
	01	4,655	281ms	0ms
	02	4,420	250ms	0ms
	03	3,987	231ms	0ms
	04	5,115	299ms	0ms
	05	2,838	159ms	0ms
	06	5,831	322ms	0ms
	07	7,058	389ms	0ms
	08	14,621	825ms	0ms
	09	35,808	2s354ms	0ms
	10	46,015	3s245ms	0ms
	11	52,232	3s553ms	0ms
	12	48,402	3s17ms	0ms
	13	47,379	2s997ms	0ms
	14	40,987	2s786ms	0ms
	15	41,216	2s857ms	0ms
	16	41,834	2s729ms	0ms
	17	39,314	2s727ms	0ms
	18	32,656	2s18ms	0ms
	19	26,159	1s630ms	0ms
	20	17,549	1s497ms	0ms
	21	17,494	1s32ms	0ms
	22	8,688	488ms	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 (26);

Date: 2024-12-24 11:25:13 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 57, 59, 97, 101, 108, 118, 120, 129);

Date: 2024-12-24 10:57:13 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 (126);

Date: 2024-12-24 11:25:13 Duration: 1ms

9

546,391

Details

1m15s

0ms

8ms

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 24	00	7,878	904ms	0ms
	01	7,029	787ms	0ms
	02	5,428	668ms	0ms
	03	5,076	659ms	0ms
	04	7,326	1s22ms	0ms
	05	3,828	503ms	0ms
	06	6,396	789ms	0ms
	07	6,513	796ms	0ms
	08	14,069	1s676ms	0ms
	09	35,796	5s133ms	0ms
	10	45,577	7s680ms	0ms
	11	53,171	7s774ms	0ms
	12	48,328	6s688ms	0ms
	13	44,643	6s109ms	0ms
	14	36,910	5s259ms	0ms
	15	40,493	6s164ms	0ms
	16	40,586	5s782ms	0ms
	17	35,113	4s764ms	0ms
	18	32,640	4s73ms	0ms
	19	27,573	3s411ms	0ms
	20	17,105	2s590ms	0ms
	21	16,094	1s775ms	0ms
	22	8,819	951ms	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 (5099533, 5107255, 5099415, 5099009, 5105958, 5099321, 5179928, 5116784, 5122024, 5099144, 5099300, 5099297, 5101060, 5099007, 5315251, 5099181, 5101652, 5330592, 5104279, 5099037, 5100091, 5099231, 5100457, 5107560, 5099570, 5099183, 5110408, 5099162, 5101085, 5104284, 5099206, 5103258, 5104276, 5099243, 5104379, 5100448, 5100193, 5099736, 5099236, 5099244, 5099254, 5107837, 5121531, 5448613, 5098974, 5385513, 5100465, 5099170, 5448068, 5099112, 5129583, 5100115, 5099102);

Date: 2024-12-24 12:46:25 Duration: 8ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5311642, 5113931, 5321548, 5099013, 5234120, 5182321, 5099005, 5291817, 5193920, 5112860, 5316776, 5359668, 5234790, 5210147, 5106122, 5099007, 5099533, 5417508, 5337614, 5099009, 5115849, 5099392, 5266065, 5417503, 5417504, 5099024, 5118711, 5099102, 5253395, 5149370, 5171438, 5106822, 5099712, 5103217, 5120051, 5203701, 5176426, 5101982, 5099254, 5106396);

Date: 2024-12-24 15:28:08 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5311642, 5113931, 5321548, 5099013, 5234120, 5182321, 5099005, 5291817, 5193920, 5112860, 5316776, 5359668, 5234790, 5210147, 5106122, 5099007, 5099533, 5417508, 5337614, 5099009, 5115849, 5099392, 5266065, 5417503, 5417504, 5099024, 5118711, 5099102, 5253395, 5149370, 5171438, 5106822, 5099712, 5103217, 5120051, 5203701, 5176426, 5101982, 5099254, 5106396);

Date: 2024-12-24 18:16:59 Duration: 6ms

10

433,588

Details

2m20s

0ms

2ms

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 24	00	3,256	1s32ms	0ms
	01	1,878	581ms	0ms
	02	1,176	373ms	0ms
	03	1,113	364ms	0ms
	04	1,167	363ms	0ms
	05	788	245ms	0ms
	06	1,769	549ms	0ms
	07	1,926	584ms	0ms
	08	9,250	2s755ms	0ms
	09	31,163	9s772ms	0ms
	10	26,207	8s705ms	0ms
	11	41,275	13s573ms	0ms
	12	44,052	13s598ms	0ms
	13	43,291	13s916ms	0ms
	14	44,105	14s383ms	0ms
	15	43,911	14s377ms	0ms
	16	33,202	10s803ms	0ms
	17	32,419	11s336ms	0ms
	18	22,320	7s196ms	0ms
	19	20,417	6s384ms	0ms
	20	10,917	4s167ms	0ms
	21	12,442	3s778ms	0ms
	22	5,544	1s640ms	0ms

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

Date: 2024-12-24 00:55:03 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.users' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 884) OR r.global) ORDER BY r.id;

Date: 2024-12-24 20:16:24 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 859) OR r.global) ORDER BY r.id;

Date: 2024-12-24 00:16:57 Duration: 2ms

11

395,288

Details

1m13s

0ms

15ms

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 24	00	3,540	633ms	0ms
	01	2,650	481ms	0ms
	02	2,871	473ms	0ms
	03	2,411	443ms	0ms
	04	2,952	547ms	0ms
	05	1,952	324ms	0ms
	06	3,810	628ms	0ms
	07	4,193	687ms	0ms
	08	12,256	1s902ms	0ms
	09	27,831	4s999ms	0ms
	10	33,621	6s270ms	0ms
	11	38,305	7s408ms	0ms
	12	39,526	6s940ms	0ms
	13	34,792	6s445ms	0ms
	14	31,492	6s83ms	0ms
	15	32,476	6s177ms	0ms
	16	29,046	5s472ms	0ms
	17	27,445	5s391ms	0ms
	18	21,426	4s20ms	0ms
	19	16,408	3s110ms	0ms
	20	10,277	2s398ms	0ms
	21	10,734	1s948ms	0ms
	22	5,274	887ms	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 (8006482);

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

Date: 2024-12-24 12:46:25 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 (1);

Date: 2024-12-24 13:36:49 Duration: 8ms

12

329,830

Details

58s444ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 24	00	2,733	381ms	0ms
	01	2,035	281ms	0ms
	02	1,143	157ms	0ms
	03	1,306	167ms	0ms
	04	1,709	216ms	0ms
	05	1,133	146ms	0ms
	06	1,975	269ms	0ms
	07	2,124	288ms	0ms
	08	8,011	1s194ms	0ms
	09	24,916	4s286ms	0ms
	10	20,639	3s621ms	0ms
	11	30,206	5s655ms	0ms
	12	36,266	6s88ms	0ms
	13	29,869	5s437ms	0ms
	14	33,835	6s241ms	0ms
	15	34,364	6s397ms	0ms
	16	23,636	4s236ms	0ms
	17	21,886	4s257ms	0ms
	18	16,227	2s793ms	0ms
	19	15,285	2s609ms	0ms
	20	8,702	1s725ms	0ms
	21	8,295	1s414ms	0ms
	22	3,535	578ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 1044 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-24 11:29:36 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 872 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-24 14:33:54 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-24 11:01:23 Duration: 1ms

13

256,925

Details

1d11h5m42s

369ms

3s709ms

491ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 24	00	8,862	1h9m51s	473ms
	01	7,231	56m58s	472ms
	02	6,098	46m48s	460ms
	03	7,095	53m49s	455ms
	04	9,073	1h10m23s	465ms
	05	5,910	45m8s	458ms
	06	5,518	42m23s	461ms
	07	4,820	36m30s	454ms
	08	4,316	32m45s	455ms
	09	12,667	1h43m14s	489ms
	10	16,200	2h17m24s	508ms
	11	20,203	2h53m44s	516ms
	12	11,460	1h34m11s	493ms
	13	12,705	1h41m39s	480ms
	14	10,617	1h26m43s	490ms
	15	11,512	1h36m6s	500ms
	16	13,537	1h50m26s	489ms
	17	16,866	2h21m33s	503ms
	18	13,364	1h48m40s	487ms
	19	13,403	1h50m20s	493ms
	20	24,879	3h43m5s	538ms
	21	15,057	2h8s	478ms
	22	5,532	43m42s	474ms

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

Date: 2024-12-24 20:00:52 Duration: 3s709ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3902287)) AND (("shipping_track"."id" not in (31831379, 31831379)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:02:02 Duration: 3s491ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3902279)) AND (("shipping_track"."id" not in (31831318, 31831318)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:01:52 Duration: 3s441ms

14

252,221

Details

1m6s

0ms

29ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 24	00	3,942	920ms	0ms
	01	3,640	866ms	0ms
	02	2,364	573ms	0ms
	03	2,070	555ms	0ms
	04	3,128	930ms	0ms
	05	1,635	482ms	0ms
	06	2,897	764ms	0ms
	07	2,651	633ms	0ms
	08	5,782	1s358ms	0ms
	09	14,281	4s289ms	0ms
	10	18,928	6s8ms	0ms
	11	22,524	6s143ms	0ms
	12	21,101	5s274ms	0ms
	13	20,474	5s33ms	0ms
	14	19,106	4s573ms	0ms
	15	19,138	4s865ms	0ms
	16	18,321	4s814ms	0ms
	17	17,599	4s369ms	0ms
	18	15,771	3s786ms	0ms
	19	14,421	4s299ms	0ms
	20	8,629	2s602ms	0ms
	21	9,093	2s202ms	0ms
	22	4,726	1s120ms	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 (41574549, 41436124, 41780043, 41798971, 41707857, 32640806, 32640122, 32640121, 32640544, 41773811, 32640039, 41346170, 41774442, 41346380, 41768302, 41768384, 41733206, 41657717, 41373804, 41658395, 41780058, 41706532, 41780100, 41783433, 41783400, 41779922, 41783539, 41791549, 41783594, 41577514, 41463850, 41723412, 41706419, 41706433, 41464321, 41788962, 41783449, 41487140, 41574578, 41574572, 41690123, 41344691, 41611833, 41344683, 41613183, 41723542, 41702219, 41632488, 41632007, 41728703, 41728677, 41689424, 41587077, 41657379, 41604524, 41511635, 41768457, 41719108, 41696540, 41726124, 41739257, 41572281, 41691519, 41677997, 41715992, 41677705, 41616342, 41718139, 41718642, 41718320, 41718728, 41628209, 41787782, 41628164, 41691389, 41748616, 41655404, 41602323, 41768264, 41657323, 41744714, 41744824, 41734991, 41599882, 41459340, 41587687, 41667272, 41667265, 41667258, 41735067, 41605587, 41671273, 41785721, 41671109, 41463363, 41657649, 41577615, 41169740, 41488635, 41652303);

Date: 2024-12-24 12:46:25 Duration: 29ms
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 (40574198, 40062914, 40322886, 40325732, 39844773, 40287968, 40100950, 40099253, 40933955, 39820480, 39836088, 40040175, 39837097, 40100949, 39866215, 40647930, 40262783, 39820474, 40395445, 40172606, 39820635, 39708461, 39820578, 39820577, 39820570, 39327829, 39820569, 39900239, 39820568, 39899676, 39820566, 39820565, 40193872, 39820564, 39820563, 39820562, 39820615, 39820614, 40147717, 39900399, 40698549, 40651086, 40188734, 40191362, 40438310, 40595657, 39866997, 40084862, 40351955, 39867242, 39867008, 39900404, 40171433, 40030410, 40547294, 41439953, 40564058, 40261298, 39936239, 40170744, 40135283, 40261371, 40361361, 40097440, 40325906, 40171441, 40492146, 40551697, 40314048, 40228923, 40521127, 40625447, 39871410, 40500047, 40536321, 40476384, 39647009, 39950772, 39882660, 39866739, 40564948, 40554192, 39647001, 40285108, 40388648, 40388647, 40551709, 39883428, 39882017, 39883163, 40495575, 39006591, 40534236, 39775218, 40444091, 39877778, 39877776, 39877817, 40911735, 39856824);

Date: 2024-12-24 12:46:26 Duration: 20ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (39777673, 40740842, 40590262, 39699786, 41051828, 40442056, 40581137, 38401328, 40848175, 40555838, 40150315, 41243893, 41323721, 40362672, 40111312, 40778675, 40423991, 40144654, 39947243, 39805488, 40189695, 40144841, 40485369, 40897728, 39309833, 40423542, 40127686, 41276932, 40063695, 41286191, 40531602, 40395873, 38557940, 40453113, 39971889, 40122062, 40973376, 40039351, 40164103, 40395850, 39939633, 32590141, 32595460, 40778651, 32593467, 32610802, 38585487, 39935189, 32595839, 40579096, 40579106, 40890112, 40682908, 39708163, 39664367, 40250023, 39474833, 39799280, 40107749, 40440500, 32584610, 39645837, 40012084, 40012087, 40289014, 39733331, 39932003, 40665437, 39733303, 39878822, 40255019, 40897734, 39895391, 39932622, 39657633, 40346210, 40672896, 39934686, 40244897, 40319211, 40504811, 40124470, 39641907, 38977619, 39711042, 39793045, 39853805, 39684974, 39423184, 39665142, 39684886, 39750167, 39742445, 39668685, 39769815, 39878833, 39497956, 39791280, 39684909, 39741853);

Date: 2024-12-24 12:46:29 Duration: 18ms

15

189,711

Details

11s74ms

0ms

19ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 24	00	1,353	70ms	0ms
	01	745	38ms	0ms
	02	473	24ms	0ms
	03	412	20ms	0ms
	04	469	23ms	0ms
	05	337	17ms	0ms
	06	756	39ms	0ms
	07	763	39ms	0ms
	08	4,169	214ms	0ms
	09	14,044	795ms	0ms
	10	10,879	644ms	0ms
	11	17,724	1s73ms	0ms
	12	20,158	1s116ms	0ms
	13	18,857	1s119ms	0ms
	14	19,585	1s160ms	0ms
	15	19,890	1s191ms	0ms
	16	14,343	835ms	0ms
	17	13,858	877ms	0ms
	18	9,639	541ms	0ms
	19	8,992	504ms	0ms
	20	4,602	314ms	0ms
	21	5,237	284ms	0ms
	22	2,426	126ms	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 (17);

Date: 2024-12-24 13:48:33 Duration: 19ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2024-12-24 18:36: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 (98, 99);

Date: 2024-12-24 09:39:31 Duration: 0ms

16

188,160

Details

15s895ms

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

Day	Hour	Count	Duration	Avg duration
Dec 24	00	2,071	120ms	0ms
	01	1,647	111ms	0ms
	02	1,663	107ms	0ms
	03	1,629	109ms	0ms
	04	2,107	145ms	0ms
	05	1,130	76ms	0ms
	06	2,029	131ms	0ms
	07	2,309	142ms	0ms
	08	4,920	293ms	0ms
	09	12,809	915ms	0ms
	10	16,395	1s345ms	0ms
	11	19,411	1s607ms	0ms
	12	17,745	1s447ms	0ms
	13	16,325	1s336ms	0ms
	14	13,842	1s414ms	0ms
	15	14,684	1s312ms	0ms
	16	14,071	977ms	0ms
	17	11,954	1s24ms	0ms
	18	10,613	917ms	0ms
	19	8,521	808ms	0ms
	20	5,141	801ms	0ms
	21	4,709	601ms	0ms
	22	2,435	144ms	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-24 18:16:59 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-24 15:28:08 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2024-12-24 10:54:36 Duration: 1ms

17

181,938

Details

22s621ms

0ms

18ms

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 24	00	1,343	154ms	0ms
	01	729	81ms	0ms
	02	472	53ms	0ms
	03	405	44ms	0ms
	04	463	50ms	0ms
	05	321	35ms	0ms
	06	723	83ms	0ms
	07	754	85ms	0ms
	08	4,081	464ms	0ms
	09	13,844	1s715ms	0ms
	10	10,627	1s390ms	0ms
	11	17,008	2s258ms	0ms
	12	19,416	2s301ms	0ms
	13	18,040	2s192ms	0ms
	14	18,592	2s300ms	0ms
	15	18,838	2s393ms	0ms
	16	13,537	1s661ms	0ms
	17	13,385	1s807ms	0ms
	18	9,069	1s66ms	0ms
	19	8,455	988ms	0ms
	20	4,405	657ms	0ms
	21	5,061	576ms	0ms
	22	2,370	259ms	0ms

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

Date: 2024-12-24 15:38:12 Duration: 18ms
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-24 11:16:55 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 (21) 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-24 19:37:20 Duration: 1ms

18

157,524

Details

32s225ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 24	00	1,108	206ms	0ms
	01	648	121ms	0ms
	02	454	85ms	0ms
	03	462	84ms	0ms
	04	495	90ms	0ms
	05	338	61ms	0ms
	06	657	123ms	0ms
	07	765	140ms	0ms
	08	3,549	658ms	0ms
	09	12,198	2s391ms	0ms
	10	9,861	2s32ms	0ms
	11	15,068	3s87ms	0ms
	12	16,961	3s302ms	0ms
	13	15,339	3s126ms	0ms
	14	15,766	3s276ms	0ms
	15	15,807	3s353ms	0ms
	16	11,520	2s387ms	0ms
	17	11,271	2s489ms	0ms
	18	7,786	1s595ms	0ms
	19	7,285	1s446ms	0ms
	20	3,814	918ms	0ms
	21	4,247	836ms	0ms
	22	2,125	407ms	0ms

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

Date: 2024-12-24 12:46:25 Duration: 1ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1201) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-24 12:46:25 Duration: 1ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (996) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-24 17:21:52 Duration: 1ms

19

153,083

Details

15s261ms

0ms

1ms

0ms

select active, id, login, password, totp_secret, ( select value from ir_config_parameter where key = ?) from res_users where id = ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 24	00	626	64ms	0ms
	01	327	36ms	0ms
	02	172	20ms	0ms
	03	151	18ms	0ms
	04	120	15ms	0ms
	05	186	21ms	0ms
	06	430	44ms	0ms
	07	335	36ms	0ms
	08	2,499	235ms	0ms
	09	11,898	1s112ms	0ms
	10	6,945	715ms	0ms
	11	14,737	1s446ms	0ms
	12	18,287	1s722ms	0ms
	13	16,037	1s571ms	0ms
	14	19,763	1s940ms	0ms
	15	19,703	2s2ms	0ms
	16	11,516	1s169ms	0ms
	17	10,333	1s118ms	0ms
	18	5,740	604ms	0ms
	19	6,858	675ms	0ms
	20	1,856	242ms	0ms
	21	3,211	312ms	0ms
	22	1,353	134ms	0ms

SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 893;

Date: 2024-12-24 18:15:00 Duration: 1ms
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1293;

Date: 2024-12-24 17:21:52 Duration: 1ms
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1025;

Date: 2024-12-24 17:21:52 Duration: 1ms

20

152,969

Details

1h45m42s

30ms

195ms

41ms

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 24	00	3,250	2m8s	39ms
	01	2,823	1m50s	39ms
	02	2,071	1m21s	39ms
	03	1,727	1m7s	39ms
	04	3,208	2m7s	39ms
	05	1,587	1m2s	39ms
	06	1,272	50s304ms	39ms
	07	1,544	1m1s	39ms
	08	3,076	2m1s	39ms
	09	8,154	5m41s	41ms
	10	12,042	8m39s	43ms
	11	16,862	12m18s	43ms
	12	9,733	6m48s	42ms
	13	10,746	7m21s	41ms
	14	9,539	6m37s	41ms
	15	9,694	6m50s	42ms
	16	10,168	6m55s	40ms
	17	10,055	7m1s	41ms
	18	9,164	6m8s	40ms
	19	7,694	5m6s	39ms
	20	8,993	6m33s	43ms
	21	6,482	4m9s	38ms
	22	3,085	1m57s	37ms

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

Date: 2024-12-24 17:02:22 Duration: 195ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3901697)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-24 20:00:58 Duration: 179ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3888384)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-24 20:00:55 Duration: 178ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

12m40s

1m1s

45

Details

45m51s

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 24	03	2	0ms	0ms
	08	1	0ms	0ms
	09	4	3m16s	49s144ms
	10	4	3ms	0ms
	11	4	5m36s	1m24s
	12	4	3m31s	52s897ms
	13	5	15m24s	3m4s
	14	4	6ms	1ms
	15	6	5m22s	53s717ms
	17	2	3ms	1ms
	18	2	2ms	1ms
	19	5	12m40s	2m32s
	20	1	0ms	0ms
	22	1	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-24 18:37:40.111834', "last_update" = '2024-12-24 17:52:40.111859', "write_date" = '2024-12-24 17:52:39.709034', "write_uid" = 1 WHERE id IN (1044);

Date: 2024-12-24 19:05:20 Duration: 12m40s
UPDATE "res_users" SET "exp_date" = '2024-12-24 13:11:20.009128', "last_update" = '2024-12-24 12:26:20.009155', "write_date" = '2024-12-24 12:26:19.575616', "write_uid" = 886 WHERE id IN (886);

Date: 2024-12-24 13:38:20 Duration: 12m
UPDATE "res_users" SET "exp_date" = '2024-12-24 11:10:43.988994', "last_update" = '2024-12-24 10:25:43.989019', "write_date" = '2024-12-24 10:25:43.659622', "write_uid" = 1 WHERE id IN (959);

Date: 2024-12-24 11:31:20 Duration: 5m36s

2

0ms

34m49s

58s246ms

353

Details

5h42m40s

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 24	00	2	0ms	0ms
	01	3	3ms	1ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	05	3	0ms	0ms
	06	4	2ms	0ms
	07	1	0ms	0ms
	08	19	3m2s	9s589ms
	09	21	27ms	1ms
	10	27	21ms	0ms
	11	30	7m44s	15s490ms
	12	33	3m25s	6s234ms
	13	34	9m56s	17s546ms
	14	32	13m43s	25s743ms
	15	31	10m29s	20s312ms
	16	19	1m36s	5s91ms
	17	19	1m22s	4s368ms
	18	35	4h21m15s	7m27s
	19	19	15m46s	49s790ms
	20	6	3ms	0ms
	21	12	14m16s	1m11s
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-24 17:53:22.543533', "last_update" = '2024-12-24 17:08:22.543573', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:08:22.074267', "write_uid" = 825 WHERE id IN (825);

Date: 2024-12-24 18:43:11 Duration: 34m49s
UPDATE "res_users" SET "exp_date" = '2024-12-24 17:55:55.629885', "last_update" = '2024-12-24 17:10:55.629918', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:10:55.248240', "write_uid" = 825 WHERE id IN (825);

Date: 2024-12-24 18:43:11 Duration: 32m16s
UPDATE "res_users" SET "exp_date" = '2024-12-24 17:58:50.622006', "last_update" = '2024-12-24 17:13:50.622030', "sid" = '07bf99f447e554d337d2baaa66f0a9d89c7e3d73', "write_date" = '2024-12-24 17:13:50.227923', "write_uid" = 825 WHERE id IN (825);

Date: 2024-12-24 18:43:11 Duration: 29m21s

3

0ms

59m58s

4s206ms

82,893

Details

4d51m46s

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 24	00	771	166ms	0ms
	01	779	165ms	0ms
	02	841	175ms	0ms
	03	857	178ms	0ms
	04	718	151ms	0ms
	05	451	94ms	0ms
	06	699	147ms	0ms
	07	776	158ms	0ms
	08	2,108	1h8m26s	1s948ms
	09	5,227	11h6m	7s645ms
	10	6,247	26m50s	257ms
	11	8,549	8h57m5s	3s769ms
	12	8,125	9h49m54s	4s356ms
	13	7,687	11h25m37s	5s351ms
	14	7,748	8h25m53s	3s917ms
	15	8,043	11h6m23s	4s971ms
	16	6,223	9h43m32s	5s626ms
	17	5,009	30m33s	366ms
	18	3,996	3h30m34s	3s161ms
	19	3,339	10h40m47s	11s514ms
	20	2,066	620ms	0ms
	21	1,812	8h7s	15s898ms
	22	822	1h59m57s	8s755ms

update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-24 20:17:13.417430', exp_date = '2024-12-24 21:02:13.417433', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-24 22:17:11 Duration: 59m58s
update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-24 20:17:13.417428', exp_date = '2024-12-24 21:02:13.417431', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-24 22:17:11 Duration: 59m58s
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-24 19:13:22.753261', exp_date = '2024-12-24 19:58:22.753265', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-24 21:04:21 Duration: 50m58s

4

29ms

4s694ms

3s319ms

272

Details

15m2s

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 24	09	4	13s182ms	3s295ms
	10	26	1m25s	3s301ms
	11	6	22s695ms	3s782ms
	12	19	1m3s	3s364ms
	13	13	43s40ms	3s310ms
	14	14	45s19ms	3s215ms
	15	47	2m14s	2s851ms
	16	35	2m1s	3s474ms
	17	30	1m46s	3s554ms
	18	15	51s275ms	3s418ms
	19	21	1m11s	3s424ms
	20	12	50s773ms	4s231ms
	21	13	41s905ms	3s223ms
	22	17	50s961ms	2s997ms

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

Date: 2024-12-24 20:42:58 Duration: 4s694ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))))) AND ("policy_number"."name"::text ilike '%900%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-24 20:42:57 Duration: 4s497ms
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-24 20:10:55 Duration: 4s451ms

5

258ms

1s716ms

1s2ms

10,356

Details

2h53m6s

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 24	00	638	10m21s	973ms
	01	733	11m48s	966ms
	02	332	5m24s	976ms
	03	56	54s921ms	980ms
	09	16	18s153ms	1s134ms
	10	37	38s513ms	1s40ms
	11	13	14s828ms	1s140ms
	12	87	1m27s	1s1ms
	13	1	928ms	928ms
	14	136	2m19s	1s27ms
	15	278	4m51s	1s50ms
	16	706	12m4s	1s26ms
	17	879	15m31s	1s60ms
	18	890	14m57s	1s8ms
	19	1,812	28m51s	955ms
	20	1,346	24m11s	1s78ms
	21	1,824	30m1s	987ms
	22	572	9m7s	957ms

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

Date: 2024-12-24 20:10:40 Duration: 1s716ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9564151')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-24 20:13:22 Duration: 1s536ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9562013')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-24 20:10:37 Duration: 1s514ms

6

384ms

3s96ms

501ms

47,525

Details

6h36m58s

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 24	00	281	2m18s	493ms
	01	249	2m2s	492ms
	02	213	1m44s	490ms
	03	228	1m54s	500ms
	04	185	1m37s	528ms
	05	106	55s256ms	521ms
	06	189	1m32s	488ms
	07	464	3m40s	474ms
	08	1,527	11m45s	461ms
	09	2,756	23m4s	502ms
	10	4,001	34m42s	520ms
	11	5,022	44m37s	533ms
	12	3,022	25m36s	508ms
	13	4,083	33m26s	491ms
	14	3,160	26m37s	505ms
	15	3,540	29m56s	507ms
	16	3,713	30m20s	490ms
	17	4,559	38m3s	500ms
	18	3,288	26m28s	483ms
	19	2,073	16m35s	480ms
	20	2,022	18m6s	537ms
	21	1,710	13m18s	466ms
	22	1,134	8m32s	452ms

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

Date: 2024-12-24 20:00:46 Duration: 3s96ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2660648)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:00:48 Duration: 2s848ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3878295)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:00:56 Duration: 2s421ms

7

369ms

3s709ms

491ms

256,925

Details

1d11h5m42s

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 24	00	8,862	1h9m51s	473ms
	01	7,231	56m58s	472ms
	02	6,098	46m48s	460ms
	03	7,095	53m49s	455ms
	04	9,073	1h10m23s	465ms
	05	5,910	45m8s	458ms
	06	5,518	42m23s	461ms
	07	4,820	36m30s	454ms
	08	4,316	32m45s	455ms
	09	12,667	1h43m14s	489ms
	10	16,200	2h17m24s	508ms
	11	20,203	2h53m44s	516ms
	12	11,460	1h34m11s	493ms
	13	12,705	1h41m39s	480ms
	14	10,617	1h26m43s	490ms
	15	11,512	1h36m6s	500ms
	16	13,537	1h50m26s	489ms
	17	16,866	2h21m33s	503ms
	18	13,364	1h48m40s	487ms
	19	13,403	1h50m20s	493ms
	20	24,879	3h43m5s	538ms
	21	15,057	2h8s	478ms
	22	5,532	43m42s	474ms

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

Date: 2024-12-24 20:00:52 Duration: 3s709ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3902287)) AND (("shipping_track"."id" not in (31831379, 31831379)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:02:02 Duration: 3s491ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3902279)) AND (("shipping_track"."id" not in (31831318, 31831318)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-24 20:01:52 Duration: 3s441ms

8

18ms

897ms

322ms

4,318

Details

23m14s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 24	00	4	1s546ms	386ms
	01	2	996ms	498ms
	02	1	467ms	467ms
	04	2	877ms	438ms
	06	3	888ms	296ms
	07	5	1s208ms	241ms
	08	56	10s871ms	194ms
	09	131	38s499ms	293ms
	10	1,652	11m8s	404ms
	11	286	1m21s	283ms
	12	392	1m53s	288ms
	13	391	1m32s	235ms
	14	395	1m35s	240ms
	15	291	1m21s	279ms
	16	182	56s264ms	309ms
	17	167	48s883ms	292ms
	18	187	42s400ms	226ms
	19	57	17s400ms	305ms
	20	57	23s730ms	416ms
	21	37	12s961ms	350ms
	22	20	5s555ms	277ms

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

Date: 2024-12-24 17:21:54 Duration: 897ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-24 10:38:20 Duration: 880ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-24 10:37:46 Duration: 773ms

9

197ms

1s951ms

322ms

18,619

Details

1h40m2s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 24	00	1,169	6m	308ms
	01	1,229	6m14s	304ms
	02	311	1m33s	300ms
	03	346	1m45s	304ms
	04	1,013	5m11s	307ms
	05	506	2m33s	302ms
	06	742	3m45s	303ms
	07	165	49s482ms	299ms
	08	3	911ms	303ms
	09	20	6s717ms	335ms
	10	391	2m10s	334ms
	11	160	53s562ms	334ms
	12	139	45s636ms	328ms
	13	221	1m3s	286ms
	14	239	1m7s	281ms
	15	612	2m53s	284ms
	16	954	4m33s	286ms
	17	1,483	8m20s	337ms
	18	1,856	10m19s	333ms
	19	2,492	13m40s	329ms
	20	1,481	9m42s	393ms
	21	1,676	9m5s	325ms
	22	1,411	7m26s	316ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '8280272')) 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-24 20:01:07 Duration: 1s951ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9467394')) 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-24 20:01:02 Duration: 1s624ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9569587')) 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-24 20:00:53 Duration: 1s598ms

10

154ms

944ms

257ms

27,324

Details

1h57m18s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 24	07	31	10s676ms	344ms
	08	739	3m12s	260ms
	09	1,304	6m7s	282ms
	10	2,543	12m40s	299ms
	11	1,754	8m52s	303ms
	12	1,228	5m45s	281ms
	13	1,904	7m12s	227ms
	14	6,638	25m27s	230ms
	15	4,723	18m19s	232ms
	16	1,900	7m19s	231ms
	17	2,165	10m13s	283ms
	18	1,596	7m41s	289ms
	19	578	2m41s	279ms
	20	221	1m30s	411ms

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

Date: 2024-12-24 20:00:56 Duration: 944ms
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" = '9302870')))) ORDER BY "collection_policy"."id";

Date: 2024-12-24 20:00:57 Duration: 659ms
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" = '9489304')))) ORDER BY "collection_policy"."id";

Date: 2024-12-24 17:01:22 Duration: 641ms

11

88ms

881ms

236ms

57,153

Details

3h45m21s

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 24	00	3,578	12m40s	212ms
	01	3,878	12m4s	186ms
	02	1,280	4m18s	202ms
	03	800	3m7s	234ms
	04	2,008	7m27s	222ms
	05	988	3m42s	224ms
	06	1,476	5m43s	232ms
	07	326	1m12s	220ms
	08	6	1s509ms	251ms
	09	60	18s856ms	314ms
	10	814	2m54s	214ms
	11	332	1m23s	251ms
	12	426	1m37s	227ms
	13	434	1m41s	234ms
	14	716	2m58s	249ms
	15	1,755	6m29s	221ms
	16	3,286	13m24s	244ms
	17	4,658	19m50s	255ms
	18	5,414	22m47s	252ms
	19	8,483	34m20s	242ms
	20	5,619	25m56s	277ms
	21	6,896	26m25s	229ms
	22	3,920	14m53s	227ms

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-24 20:09:41 Duration: 881ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مينا')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-24 20:09:41 Duration: 878ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ابراهيم')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-24 20:39:21 Duration: 878ms

12

149ms

1s527ms

222ms

128,798

Details

7h56m52s

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 24	00	1,259	4m31s	216ms
	01	1,352	4m52s	215ms
	02	1,341	4m46s	213ms
	03	2,622	9m27s	216ms
	04	2,135	7m42s	216ms
	05	2,111	7m34s	215ms
	06	2,912	10m27s	215ms
	07	2,271	8m15s	218ms
	08	2,446	8m47s	215ms
	09	5,871	22m24s	229ms
	10	7,160	28m32s	239ms
	11	4,748	19m36s	247ms
	12	4,129	14m46s	214ms
	13	4,152	12m27s	179ms
	14	13,990	42m28s	182ms
	15	13,806	43m2s	187ms
	16	5,403	15m59s	177ms
	17	9,536	33m38s	211ms
	18	5,404	20m55s	232ms
	19	7,691	29m58s	233ms
	20	27,759	2h4m3s	268ms
	21	700	2m32s	218ms

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

Date: 2024-12-24 20:01:09 Duration: 1s527ms
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" = '9343574')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-24 20:01:54 Duration: 1s370ms
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" = '9420453')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-24 20:01:41 Duration: 1s345ms

13

154ms

305ms

219ms

6,565

Details

24m

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 24	00	21	4s487ms	213ms
	04	59	13s37ms	220ms
	05	347	1m14s	215ms
	06	145	31s148ms	214ms
	07	257	55s244ms	214ms
	08	64	14s172ms	221ms
	09	2,481	9m29s	229ms
	10	545	2m11s	240ms
	11	306	1m14s	244ms
	12	299	1m10s	234ms
	13	167	29s495ms	176ms
	14	462	1m23s	181ms
	15	596	1m51s	187ms
	16	169	29s399ms	173ms
	17	79	17s67ms	216ms
	18	562	2m9s	230ms
	21	6	1s284ms	214ms

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" = '8329105')) 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-24 11:21:48 Duration: 305ms
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" = '8764661')) 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-24 10:03:32 Duration: 300ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '8558752')) 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-24 11:21:55 Duration: 298ms

14

191ms

252ms

216ms

10,916

Details

39m18s

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 24	00	1,224	4m24s	216ms
	01	1,291	4m39s	216ms
	02	1,271	4m31s	213ms
	03	2,554	9m12s	216ms
	04	1,477	5m20s	216ms
	05	1,077	3m53s	216ms
	06	1,034	3m42s	215ms
	07	988	3m36s	218ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9559143')) 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-24 00:53:45 Duration: 252ms
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" = '9538358')) 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-24 04:48:22 Duration: 252ms
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" = '9538268')) 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-24 04:48:20 Duration: 252ms

15

153ms

1s293ms

213ms

12,910

Details

45m54s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 24	00	8	1s714ms	214ms
	01	11	2s365ms	215ms
	04	381	1m22s	216ms
	05	673	2m24s	214ms
	06	1,003	3m36s	216ms
	07	756	2m45s	218ms
	08	740	2m39s	216ms
	09	1,479	5m34s	226ms
	10	1,298	5m11s	240ms
	11	364	1m27s	239ms
	12	799	2m48s	210ms
	13	411	1m12s	175ms
	14	829	2m30s	180ms
	15	1,272	3m56s	185ms
	16	729	2m8s	176ms
	17	544	1m58s	217ms
	18	683	2m36s	229ms
	19	349	1m19s	227ms
	20	195	54s131ms	277ms
	21	386	1m24s	219ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9508602')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-24 20:00:50 Duration: 1s293ms
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" = '9468900')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-24 20:00:46 Duration: 673ms
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" = '9508606')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-24 20:00:57 Duration: 427ms

16

119ms

851ms

146ms

5,975

Details

14m33s

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 24	00	15	1s959ms	130ms
	01	1	130ms	130ms
	07	10	1s298ms	129ms
	08	87	11s648ms	133ms
	09	517	1m14s	144ms
	10	847	2m3s	146ms
	11	1,189	2m58s	150ms
	12	995	2m22s	143ms
	13	699	1m41s	145ms
	14	291	44s280ms	152ms
	15	308	45s480ms	147ms
	16	297	42s731ms	143ms
	17	161	24s372ms	151ms
	18	238	32s863ms	138ms
	19	66	9s416ms	142ms
	20	70	12s673ms	181ms
	21	82	11s60ms	134ms
	22	102	13s389ms	131ms

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

Date: 2024-12-24 20:00:51 Duration: 851ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-24 20:00:59 Duration: 812ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 65)) 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-24 11:02:06 Duration: 269ms

17

78ms

263ms

97ms

19,843

Details

32m23s

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 24	01	16	1s569ms	98ms
	02	13	1s227ms	94ms
	03	17	1s579ms	92ms
	07	46	4s321ms	93ms
	08	384	36s257ms	94ms
	09	1,030	1m41s	98ms
	10	1,218	2m2s	100ms
	11	1,932	3m11s	99ms
	12	2,074	3m18s	95ms
	13	2,718	4m20s	95ms
	14	3,194	5m8s	96ms
	15	2,022	3m21s	99ms
	16	1,269	2m4s	98ms
	17	958	1m38s	102ms
	18	1,153	1m54s	99ms
	19	748	1m11s	95ms
	20	311	33s485ms	107ms
	21	583	54s211ms	92ms
	22	157	15s182ms	96ms

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

Date: 2024-12-24 17:22:08 Duration: 263ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7874203)) AND (("cash_track"."id" not in (6133683)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-24 12:47:46 Duration: 233ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7873125)) AND (("cash_track"."id" not in (6124295)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-24 10:04:15 Duration: 205ms

18

32ms

162ms

44ms

59,175

Details

44m5s

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 24	00	1	46ms	46ms
	01	1	40ms	40ms
	02	6	288ms	48ms
	03	32	1s423ms	44ms
	06	1	48ms	48ms
	07	79	3s543ms	44ms
	08	1,625	1m12s	44ms
	09	5,085	3m55s	46ms
	10	4,791	3m49s	47ms
	11	7,939	6m26s	48ms
	12	2,186	1m40s	45ms
	13	5,303	3m34s	40ms
	14	7,296	5m1s	41ms
	15	6,439	4m33s	42ms
	16	6,841	4m38s	40ms
	17	3,763	2m57s	47ms
	18	4,722	3m42s	47ms
	19	1,616	1m18s	48ms
	20	796	39s645ms	49ms
	21	475	22s527ms	47ms
	22	178	8s243ms	46ms

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

Date: 2024-12-24 17:02:19 Duration: 162ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3868369) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-24 17:22:00 Duration: 113ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3717012) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-24 14:45:30 Duration: 94ms

19

30ms

195ms

41ms

152,969

Details

1h45m42s

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 24	00	3,250	2m8s	39ms
	01	2,823	1m50s	39ms
	02	2,071	1m21s	39ms
	03	1,727	1m7s	39ms
	04	3,208	2m7s	39ms
	05	1,587	1m2s	39ms
	06	1,272	50s304ms	39ms
	07	1,544	1m1s	39ms
	08	3,076	2m1s	39ms
	09	8,154	5m41s	41ms
	10	12,042	8m39s	43ms
	11	16,862	12m18s	43ms
	12	9,733	6m48s	42ms
	13	10,746	7m21s	41ms
	14	9,539	6m37s	41ms
	15	9,694	6m50s	42ms
	16	10,168	6m55s	40ms
	17	10,055	7m1s	41ms
	18	9,164	6m8s	40ms
	19	7,694	5m6s	39ms
	20	8,993	6m33s	43ms
	21	6,482	4m9s	38ms
	22	3,085	1m57s	37ms

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

Date: 2024-12-24 17:02:22 Duration: 195ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3901697)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-24 20:00:58 Duration: 179ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3888384)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-24 20:00:55 Duration: 178ms

20

29ms

74ms

40ms

21,955

Details

14m46s

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 24	07	24	874ms	36ms
	08	757	30s419ms	40ms
	09	821	35s271ms	42ms
	10	2,748	1m57s	42ms
	11	2,176	1m37s	44ms
	12	876	37s567ms	42ms
	13	1,695	1m2s	36ms
	14	3,436	2m8s	37ms
	15	2,995	1m55s	38ms
	16	2,439	1m29s	36ms
	17	1,460	1m	41ms
	18	1,926	1m23s	43ms
	19	382	17s15ms	44ms
	20	220	9s979ms	45ms

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

Date: 2024-12-24 12:04:26 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3408361) ORDER BY "collection_policy"."id";

Date: 2024-12-24 10:34:10 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3830703) ORDER BY "collection_policy"."id";

Date: 2024-12-24 20:10:41 Duration: 70ms

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

Chart
Table

Type	Count	Percentage
CONTEXT	17	0.00%
DETAIL	10,955	0.05%
ERROR	11,698	0.06%
EVENTLOG	2,381	0.01%
FATAL	13,104	0.06%
HINT	10	0.00%
LOG	20,351,552	99.76%
STATEMENT	11,761	0.06%

Events distribution (except queries)

Key values

0 PANIC entries
13104 FATAL entries
11698 ERROR entries
0 WARNING entries
2381 EVENTLOG entries

Most Frequent Errors/Events

Key values

10,912 Max number of times the same event was reported
27,183 Total events found

Rank

Times reported

Error

1

10,912

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 24	00	949
	07	3
	11	2,180
	12	2,716
	13	2,655
	14	2,406
	19	3

FATAL: password authentication failed for user "postgres"

2

5,294

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 24	00	30
	01	7
	02	9
	03	1
	04	1
	05	6
	06	19
	07	8
	08	76
	09	251
	10	325
	11	726
	12	648
	13	516
	14	876
	15	770
	16	398
	17	256
	18	79
	19	126
	20	80
	21	52
	22	34

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

3

5,046

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 24	00	26
	01	7
	02	7
	03	1
	04	1
	05	2
	06	18
	07	7
	08	73
	09	242
	10	301
	11	703
	12	638
	13	504
	14	852
	15	724
	16	373
	17	234
	18	77
	19	112
	20	58
	21	52
	22	34

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

4

1,602

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 24	08	26
	09	246
	10	28
	11	169
	12	181
	13	175
	14	283
	15	201
	16	131
	17	29
	18	25
	19	78
	21	30

FATAL: connection to client lost

5

1,602

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 24	08	26
	09	246
	10	28
	11	169
	12	181
	13	175
	14	283
	15	201
	16	131
	17	29
	18	25
	19	78
	21	30

LOG: could not send data to client: Broken pipe

6

1,292

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 24	12	1,063
	15	229

ERROR: column shipping_policy.zero_date_change does not exist at character 424
ERROR: column shipping_policy.zero_date_change does not exist at character 424
ERROR: column shipping_policy.zero_date_change does not exist at character 424

7

526

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 24	08	8
	09	74
	10	4
	11	89
	12	23
	13	58
	14	79
	15	71
	16	30
	17	4
	18	25
	19	54
	21	5
	22	2

8

332

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 24	12	295
	17	37

9

251

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 24	08	4
	09	34
	10	3
	11	49
	12	8
	13	28
	14	42
	15	28
	16	15
	17	3
	18	4
	19	31
	21	1
	22	1

10

205

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 24	12	99
	17	106

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

11

28

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 24	12	4
	17	24

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

12

23

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 24	12	10
	14	2
	15	9
	22	2

ERROR: could not create unique index "bank_deposit_deposite_2_name"
ERROR: could not create unique index "urgent_phone_mobile_urgent_name"

13

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 24	02	1
	08	1
	09	4
	12	1
	13	2
	17	3
	21	1

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

14

10

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 24	06	1
	11	4
	12	4
	15	1

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

15

8

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 24	12	5
	17	3

16

7

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 24	09	1
	10	3
	16	2
	18	1

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

17

6

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 24	12	1
	17	5

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

18

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 24	08	1
	09	1
	13	1
	18	1

19

4

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 24	08	1
	09	1
	13	1
	18	1

20

4

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 24	08	1
	09	1
	13	1
	18	1

21

3

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 24	15	1
	16	1
	18	1

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

22

2

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 24	12	1
	17	1

23

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 24	16	2

24

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 24	11	1
	18	1

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

25

1

Details

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

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Dec 24	11	1

26

1

Details

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

Times Reported Most Frequent Error / Event #26

Day	Hour	Count
Dec 24	19	1

ERROR: invalid input syntax for type date: "False" at character 37

27

1

Details

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

Times Reported Most Frequent Error / Event #27

Day	Hour	Count
Dec 24	12	1

28

1

Details

ERROR: column "..." of relation "..." already exists

Times Reported Most Frequent Error / Event #28

Day	Hour	Count
Dec 24	15	1

ERROR: column "zero_date_change_user" of relation "shipping_policy" already exists

29

1

Details

FATAL: canceling authentication due to timeout

Times Reported Most Frequent Error / Event #29

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