pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Dec 17 23:47:42 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 46,570,532 log entries in 2m40s
Log start from 2024-12-17 00:00:00 to 2024-12-17 22:45:01

Global Stats

22,274 Number of unique normalized queries
19,946,079 Number of queries
6d18h30m8s Total query duration
2024-12-17 00:00:00 First query
2024-12-17 22:45:01 Last query
5,697 queries/s at 2024-12-17 11:31:23 Query peak

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

13,979 Number of events
22 Number of unique normalized events
5,159 Max number of times the same event was reported
0 Number of cancellation

0 Total number of automatic vacuums
0 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
19,946,079 Average queries per session
6d18h30m8s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

5,697 queries/s Query Peak
2024-12-17 11:31:23 Date

SELECT Traffic

Key values

4,133 queries/s Query Peak
2024-12-17 11:31:23 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,411 queries/s Query Peak
2024-12-17 14:02:36 Date

Queries duration

Key values

6d18h30m8s 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 17	00	303,843	0ms	2s48ms	21ms	3m21s	3m55s	4m18s
	01	245,441	0ms	1s36ms	24ms	3m	3m25s	4m7s
	02	252,248	0ms	1s122ms	21ms	3m6s	3m8s	3m28s
	03	248,919	0ms	1s387ms	21ms	2m49s	3m3s	3m20s
	04	203,715	0ms	1s2ms	25ms	2m58s	3m6s	3m17s
	05	199,690	0ms	949ms	19ms	1m57s	2m27s	2m38s
	06	242,393	0ms	19s868ms	17ms	2m15s	2m35s	2m52s
	07	201,512	0ms	4s209ms	11ms	1m39s	2m56s	4m46s
	08	531,341	0ms	3s352ms	10ms	2m45s	2m59s	3m37s
	09	1,140,943	0ms	21m31s	31ms	4m56s	38m42s	5h28m31s
	10	1,593,797	0ms	13m39s	20ms	7m50s	8m18s	4h3m
	11	1,469,849	0ms	24m57s	30ms	28m29s	1h4m12s	4h20m23s
	12	1,775,992	0ms	13m5s	25ms	8m59s	1h53m18s	2h44m43s
	13	1,626,141	0ms	21m16s	34ms	10m25s	1h48m	4h25m4s
	14	1,474,296	0ms	19m55s	29ms	6m47s	1h37m30s	3h20m43s
	15	1,527,963	0ms	15m7s	25ms	6m11s	1h6m53s	3h54s
	16	1,543,235	0ms	18m22s	38ms	34m39s	43m44s	3h38m59s
	17	1,422,029	0ms	18m13s	22ms	9m19s	57m33s	1h54m42s
	18	1,198,177	0ms	22m57s	31ms	8m50s	1h33m49s	1h56m9s
	19	977,424	0ms	53m55s	39ms	7m1s	7m42s	3h14m47s
	20	844,276	0ms	1m41s	25ms	12m20s	16m16s	22m43s
	21	571,570	0ms	44m38s	89ms	5m39s	6m3s	11h17m13s
	22	351,285	0ms	3m12s	16ms	3m44s	4m26s	7m11s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 17	00	167,302	38ms	3m3s	3m21s	4m13s
	01	130,041	45ms	2m19s	3m	3m35s
	02	135,123	40ms	2m14s	3m5s	3m21s
	03	129,206	40ms	2m16s	2m49s	3m7s
	04	103,463	49ms	2m24s	2m58s	3m11s
	05	106,479	35ms	1m39s	1m56s	2m27s
	06	135,881	30ms	1m50s	2m15s	2m39s
	07	110,218	21ms	44s895ms	1m39s	3m47s
	08	313,168	17ms	2m27s	2m44s	3m3s
	09	684,071	12ms	3m11s	4m21s	5m17s
	10	929,191	19ms	6m40s	7m33s	8m16s
	11	876,788	13ms	4m56s	5m16s	5m49s
	12	1,073,708	14ms	5m48s	6m46s	8m43s
	13	978,352	15ms	5m31s	5m56s	7m37s
	14	875,106	14ms	4m47s	5m5s	6m21s
	15	909,645	15ms	4m56s	5m32s	6m10s
	16	948,219	19ms	6m9s	8m11s	13m24s
	17	874,817	19ms	6m16s	8m32s	10m16s
	18	728,038	25ms	6m52s	7m21s	8m49s
	19	577,280	33ms	6m5s	6m33s	7m40s
	20	495,568	41ms	8m	12m19s	17m9s
	21	333,041	31ms	4m22s	5m9s	6m2s
	22	200,006	27ms	3m8s	3m35s	4m25s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 17	00	31,089	6,296	143	0	0ms	189ms	239ms	324ms
	01	26,572	5,900	144	0	0ms	153ms	210ms	271ms
	02	20,468	6,389	130	0	0ms	134ms	177ms	258ms
	03	19,758	5,905	133	0	0ms	129ms	166ms	235ms
	04	20,825	4,565	148	0	0ms	123ms	164ms	239ms
	05	12,262	4,501	138	0	0ms	84ms	107ms	135ms
	06	20,505	4,713	133	0	1ms	120ms	182ms	262ms
	07	9,100	3,240	384	0	0ms	55ms	92ms	176ms
	08	18,868	8,628	370	0	0ms	137ms	165ms	201ms
	09	44,846	16,097	772	0	435ms	285ms	364ms	37m41s
	10	85,698	23,259	840	0	131ms	509ms	613ms	773ms
	11	61,494	19,439	801	0	403ms	404ms	553ms	1h1m58s
	12	72,669	23,902	766	0	304ms	472ms	562ms	1h51m12s
	13	69,382	24,072	677	11	435ms	462ms	594ms	1h45m33s
	14	56,455	23,025	738	8	381ms	351ms	467ms	1h35m41s
	15	64,296	22,110	810	1	276ms	383ms	458ms	1h4m50s
	16	70,335	27,897	657	0	417ms	1s357ms	19m52s	39m21s
	17	76,488	24,417	793	0	140ms	632ms	846ms	52m2s
	18	71,859	24,141	742	1	196ms	517ms	620ms	1h31m10s
	19	70,397	18,833	687	0	211ms	495ms	829ms	3m26s
	20	77,929	23,646	664	0	3ms	553ms	781ms	1m15s
	21	45,374	11,126	267	0	714ms	272ms	360ms	54s108ms
	22	31,365	8,954	207	0	9ms	237ms	328ms	1m46s

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

133,622 buffers Checkpoint Peak
2024-12-17 15:31:21 Date
270.056 seconds Highest write time
0.188 seconds Sync time

Checkpoints Wal files

Key values

45 files Wal files usage Peak
2024-12-17 15:31:21 Date

Checkpoints distance

Key values

1,464.54 Mo Distance Peak
2024-12-17 15:31:21 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 17	00	130,888	3,239.582s	0.041s	3,239.671s
	01	116,491	3,239.558s	0.03s	3,239.649s
	02	132,511	3,239.514s	0.045s	3,239.603s
	03	160,542	3,239.529s	0.037s	3,239.612s
	04	134,213	3,239.576s	0.039s	3,239.66s
	05	120,702	3,239.572s	0.033s	3,239.651s
	06	122,820	3,239.615s	0.03s	3,239.699s
	07	76,086	2,828.48s	0.027s	2,828.543s
	08	168,304	3,239.604s	0.036s	3,239.685s
	09	339,805	3,239.513s	0.047s	3,239.62s
	10	554,787	3,239.525s	0.056s	3,239.673s
	11	519,060	3,239.475s	0.043s	3,239.6s
	12	528,349	3,239.523s	0.048s	3,239.66s
	13	535,824	3,239.484s	0.058s	3,239.629s
	14	456,357	3,239.532s	0.058s	3,239.667s
	15	512,678	3,239.345s	0.25s	3,239.688s
	16	360,323	3,239.525s	0.05s	3,239.645s
	17	411,969	2,889.88s	0.076s	2,890.038s
	18	311,261	3,239.515s	0.054s	3,239.637s
	19	322,941	3,239.555s	0.048s	3,239.666s
	20	333,498	3,239.504s	0.053s	3,239.63s
	21	277,271	3,239.553s	0.045s	3,239.666s
	22	136,147	2,429.688s	0.029s	2,429.752s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Dec 17	00	54	3,341	0.003s	0.012s
	01	51	2,920	0.002s	0.012s
	02	57	2,689	0.002s	0.012s
	03	67	2,533	0.002s	0.012s
	04	56	2,462	0.012s	0.012s
	05	50	2,470	0.006s	0.012s
	06	51	2,650	0.002s	0.012s
	07	27	2,714	0.002s	0.012s
	08	66	3,718	0.002s	0.012s
	09	134	4,987	0.002s	0.012s
	10	226	5,179	0.003s	0.012s
	11	217	5,059	0.003s	0.012s
	12	219	5,195	0.003s	0.012s
	13	224	5,350	0.003s	0.012s
	14	191	5,420	0.003s	0.012s
	15	207	5,617	0.066s	0.012s
	16	153	5,739	0.004s	0.012s
	17	175	5,589	0.011s	0.012s
	18	131	5,493	0.002s	0.012s
	19	143	5,222	0.003s	0.012s
	20	151	5,251	0.003s	0.012s
	21	125	4,878	0.003s	0.012s
	22	59	3,476	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 17	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 17	00	73,084.33 kB	145,146.33 kB
	01	69,922.42 kB	96,728.75 kB
	02	77,969.67 kB	90,944.17 kB
	03	92,484.55 kB	114,124.45 kB
	04	75,902.75 kB	108,070.33 kB
	05	68,772.25 kB	94,131.50 kB
	06	68,957.42 kB	83,571.25 kB
	07	37,789.33 kB	69,639.25 kB
	08	89,824.33 kB	119,887.08 kB
	09	182,871.33 kB	203,717.42 kB
	10	309,021.50 kB	332,484.58 kB
	11	298,246.18 kB	363,189.18 kB
	12	298,280.92 kB	337,279.75 kB
	13	305,110.36 kB	357,101.82 kB
	14	260,689.08 kB	350,831.25 kB
	15	282,307.83 kB	464,774.42 kB
	16	209,199.75 kB	393,446.42 kB
	17	234,725.27 kB	293,336.73 kB
	18	178,955.58 kB	236,812.42 kB
	19	195,278.83 kB	226,805.42 kB
	20	205,706.50 kB	276,160.17 kB
	21	170,469.92 kB	260,552.08 kB
	22	107,486.44 kB	187,378.89 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 17	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 17	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

11,814,711 Total read queries
5,529,556 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,814,711	59.23%
INSERT	1,078,034	5.40%
UPDATE	341,055	1.71%
DELETE	11,144	0.06%
COPY FROM	21	0.00%
COPY TO	0	0.00%
CTE	34,102	0.17%
DDL	4,018	0.02%
TCL	4,061,182	20.36%
CURSOR	0	0.00%
OTHERS	2,601,812	13.04%

Queries by database

Key values

unknown Main database
19,946,079 Requests
6d18h30m8s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	19,946,079	6d18h30m8s
	copy from	21	54ms
	cte	34,102	7s415ms
	ddl	4,018	568ms
	delete	11,144	1s457ms
	insert	1,078,034	5m40s
	others	2,601,812	2m
	select	11,814,711	2d21h28m3s
	tcl	4,061,182	2m47s
	update	341,055	3d20h51m27s

Queries by user

Key values

unknown Main user
19,946,079 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	19,946,079	6d18h30m8s
	copy from	21	54ms
	cte	34,102	7s415ms
	ddl	4,018	568ms
	delete	11,144	1s457ms
	insert	1,078,034	5m40s
	others	2,601,812	2m
	select	11,814,711	2d21h28m3s
	tcl	4,061,182	2m47s
	update	341,055	3d20h51m27s

Duration by user

Key values

6d18h30m8s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	19,946,079	6d18h30m8s
	copy from	21	54ms
	cte	34,102	7s415ms
	ddl	4,018	568ms
	delete	11,144	1s457ms
	insert	1,078,034	5m40s
	others	2,601,812	2m
	select	11,814,711	2d21h28m3s
	tcl	4,061,182	2m47s
	update	341,055	3d20h51m27s

Queries by host

Key values

unknown Main host
19,946,079 Requests
6d18h30m8s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	19,946,079	6d18h30m8s
	copy from	21	54ms
	cte	34,102	7s415ms
	ddl	4,018	568ms
	delete	11,144	1s457ms
	insert	1,078,034	5m40s
	others	2,601,812	2m
	select	11,814,711	2d21h28m3s
	tcl	4,061,182	2m47s
	update	341,055	3d20h51m27s

Queries by application

Key values

unknown Main application
19,946,079 Requests
6d18h30m8s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	19,946,079	6d18h30m8s
	copy from	21	54ms
	cte	34,102	7s415ms
	ddl	4,018	568ms
	delete	11,144	1s457ms
	insert	1,078,034	5m40s
	others	2,601,812	2m
	select	11,814,711	2d21h28m3s
	tcl	4,061,182	2m47s
	update	341,055	3d20h51m27s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-17 14:06:07 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

18,630,315 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	18,630,315	93.40%
1-5ms	303,268	1.52%
5-10ms	14,201	0.07%
10-25ms	56,017	0.28%
25-50ms	208,598	1.05%
50-100ms	77,053	0.39%
100-500ms	602,180	3.02%
500-1000ms	47,472	0.24%
1000-10000ms	5,360	0.03%
> 10000ms	1,615	0.01%

Slowest individual queries

Rank	Duration	Query
1	53m55s	SELECT COUNT() FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE ("policy_number"."name" = '9352251'))) OR (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."name" != '9352300') OR "policy_number"."name" IS NULL))) OR "shipping_policy"."policy_id" IS NULL)))) 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))))) LIMIT 10001) t; [ Date:* 2024-12-17 19:35:07 ]
2	51m13s	update res_users set sid = '4607f119b0c69cc749c5435c8d55863916a584ec', last_update = '2024-12-17 17:43:54.569113', exp_date = '2024-12-17 18:28:54.569118', logged_in = 'TRUE' where id = 1031; [ Date: 2024-12-17 19:35:07 ]
3	44m38s	update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-17 19:31:43.164574', exp_date = '2024-12-17 20:16:43.164581', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-17 21:16:21 ]
4	44m38s	update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-17 19:31:43.165241', exp_date = '2024-12-17 20:16:43.165249', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-17 21:16:21 ]
5	42m10s	update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-17 19:34:10.464850', exp_date = '2024-12-17 20:19:10.464853', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-17 21:16:21 ]
6	41m5s	UPDATE "res_users" SET "exp_date" = '2024-12-17 18:39:01.944070', "last_update" = '2024-12-17 17:54:01.944101', "sid" = '748a4a4e3163386d764d1b7de64173333ac5e63d', "write_date" = '2024-12-17 17:54:01.495832', "write_uid" = 1 WHERE id IN (1031); [ Date: 2024-12-17 19:35:07 ]
7	38m47s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:37:33.964745', exp_date = '2024-12-17 20:22:33.964748', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
8	38m47s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:37:33.964716', exp_date = '2024-12-17 20:22:33.964721', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
9	36m9s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:40:12.202078', exp_date = '2024-12-17 20:25:12.202083', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
10	33m55s	UPDATE "res_users" SET "exp_date" = '2024-12-17 18:46:12.033792', "last_update" = '2024-12-17 18:01:12.033818', "sid" = '748a4a4e3163386d764d1b7de64173333ac5e63d', "write_date" = '2024-12-17 18:01:11.636276', "write_uid" = 1031 WHERE id IN (1031); [ Date: 2024-12-17 19:35:07 ]
11	33m46s	update res_users set sid = '95962b12596c4262bc78839e2d33aef9f009d599', last_update = '2024-12-17 19:42:34.875647', exp_date = '2024-12-17 20:27:34.875652', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-17 21:16:21 ]
12	32m52s	update res_users set sid = 'd34db42af80e129904796a97b2c1348d6609f319', last_update = '2024-12-17 19:43:28.699318', exp_date = '2024-12-17 20:28:28.699323', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-17 21:16:21 ]
13	31m33s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:44:48.167266', exp_date = '2024-12-17 20:29:48.167271', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
14	27m39s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:48:41.477548', exp_date = '2024-12-17 20:33:41.477552', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
15	27m25s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:48:55.968869', exp_date = '2024-12-17 20:33:55.968874', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
16	27m4s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:49:16.490550', exp_date = '2024-12-17 20:34:16.490555', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
17	26m50s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:49:30.925001', exp_date = '2024-12-17 20:34:30.925005', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
18	26m22s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:49:58.602573', exp_date = '2024-12-17 20:34:58.602578', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
19	25m52s	update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-17 19:50:28.380581', exp_date = '2024-12-17 20:35:28.380585', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-17 21:16:21 ]
20	25m37s	update res_users set sid = 'd34db42af80e129904796a97b2c1348d6609f319', last_update = '2024-12-17 19:50:43.961043', exp_date = '2024-12-17 20:35:43.961045', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-17 21:16:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d17h5m26s

83,054

Details

0ms

51m13s

3s861ms

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 17	00	749	174ms	0ms
	01	725	162ms	0ms
	02	915	202ms	0ms
	03	987	222ms	0ms
	04	653	145ms	0ms
	05	643	138ms	0ms
	06	556	19s989ms	35ms
	07	546	118ms	0ms
	08	2,055	448ms	0ms
	09	5,195	7h27m56s	5s173ms
	10	7,287	3h46m9s	1s862ms
	11	7,029	8h59m59s	4s609ms
	12	8,138	7h39m54s	3s390ms
	13	7,289	11h9m45s	5s513ms
	14	7,653	8h17m48s	3s902ms
	15	6,956	6h37m58s	3s432ms
	16	7,594	11h9m5s	5s286ms
	17	5,686	3h41m39s	2s339ms
	18	4,321	5h9m32s	4s298ms
	19	3,224	3h50m50s	4s296ms
	20	2,155	4m53s	136ms
	21	1,688	11h6m17s	23s683ms
	22	1,010	3m13s	191ms

update res_users set sid = '4607f119b0c69cc749c5435c8d55863916a584ec', last_update = '2024-12-17 17:43:54.569113', exp_date = '2024-12-17 18:28:54.569118', logged_in = 'TRUE' where id = 1031;

Date: 2024-12-17 19:35:07 Duration: 51m13s
update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-17 19:31:43.164574', exp_date = '2024-12-17 20:16:43.164581', logged_in = 'TRUE' where id = 875;

Date: 2024-12-17 21:16:21 Duration: 44m38s
update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-17 19:31:43.165241', exp_date = '2024-12-17 20:16:43.165249', logged_in = 'TRUE' where id = 875;

Date: 2024-12-17 21:16:21 Duration: 44m38s

2

1d8h19m21s

261,583

Details

368ms

3s617ms

444ms

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 17	00	8,114	58m47s	434ms
	01	7,825	56m6s	430ms
	02	7,478	52m16s	419ms
	03	7,767	54m18s	419ms
	04	8,013	56m	419ms
	05	5,238	35m57s	411ms
	06	5,605	39m38s	424ms
	07	2,757	18m58s	413ms
	08	6,404	44m5s	413ms
	09	10,262	1h12m44s	425ms
	10	22,213	2h52m36s	466ms
	11	13,876	1h42m24s	442ms
	12	16,793	2h7m52s	456ms
	13	14,878	1h51m41s	450ms
	14	12,019	1h28m22s	441ms
	15	12,290	1h31m32s	446ms
	16	11,909	1h36m42s	487ms
	17	15,316	1h57m42s	461ms
	18	17,431	2h10m26s	448ms
	19	16,425	1h59m57s	438ms
	20	19,561	2h35m15s	476ms
	21	14,433	1h40m25s	417ms
	22	4,976	35m27s	427ms

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

Date: 2024-12-17 20:32:11 Duration: 3s617ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3690061)) AND (("shipping_track"."id" not in (30067526, 30067526)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:23 Duration: 3s508ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3690067)) AND (("shipping_track"."id" not in (30067588, 30067588)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:29 Duration: 3s388ms

3

8h1m46s

126,298

Details

186ms

1s627ms

228ms

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 17	00	1,295	4m29s	208ms
	01	1,531	5m17s	207ms
	02	2,609	8m59s	206ms
	03	2,731	9m28s	208ms
	04	1,757	6m3s	207ms
	05	3,177	10m58s	207ms
	06	1,157	3m59s	207ms
	07	1,201	4m10s	208ms
	08	4,504	15m40s	208ms
	09	3,409	12m11s	214ms
	10	6,317	24m32s	233ms
	11	5,698	21m9s	222ms
	12	7,951	30m36s	230ms
	13	9,957	37m51s	228ms
	14	6,414	23m53s	223ms
	15	7,376	27m16s	221ms
	16	13,538	52m20s	232ms
	17	8,460	32m14s	228ms
	18	11,552	43m28s	225ms
	19	4,008	14m28s	216ms
	20	17,315	1h17m4s	267ms
	21	3,964	14m13s	215ms
	22	377	1m16s	204ms

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

Date: 2024-12-17 20:32:02 Duration: 1s627ms
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" = '9314255')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-17 20:31:29 Duration: 1s606ms
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" = '9311742')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-17 20:32:58 Duration: 1s597ms

4

5h57m46s

47,009

Details

370ms

3s704ms

456ms

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 17	00	262	1m56s	442ms
	01	201	1m29s	447ms
	02	177	1m25s	482ms
	03	245	1m52s	457ms
	04	186	1m25s	457ms
	05	143	1m6s	462ms
	06	214	1m37s	454ms
	07	1,173	8m12s	420ms
	08	992	7m1s	424ms
	09	2,927	21m19s	437ms
	10	4,712	37m52s	482ms
	11	3,904	29m35s	454ms
	12	3,774	30m	477ms
	13	3,476	26m52s	463ms
	14	4,210	31m20s	446ms
	15	2,977	22m31s	454ms
	16	2,626	21m22s	488ms
	17	3,717	28m18s	457ms
	18	3,367	24m58s	445ms
	19	2,722	19m32s	430ms
	20	2,929	23m42s	485ms
	21	1,399	9m40s	414ms
	22	676	4m32s	402ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3622520, 3609589, 3608158, 3605718, 3604688, 3603154, 3600984, 3568264, 3550035, 3534751, 3534748, 3516209, 3131539, 3126119, 2631604)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:47 Duration: 3s704ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3690064, 3690060, 3690054, 3690050, 3690046, 3690041, 3690037, 3690034, 3690027, 3690024, 3690020, 3690017, 3690013, 3690011, 3690008, 3690005, 3690002, 3690000, 3689998, 3689995, 3689994, 3689991, 3689989, 3689987, 3689985, 3689982, 3689980, 3689978, 3689975, 3689973, 3689970, 3689966, 3689963, 3689961, 3689957, 3689953, 3689952, 3689948, 3689944, 3689942, 3689939, 3689935, 3689933, 3689929, 3689927, 3689924, 3689920, 3689917, 3689914, 3689910, 3689906, 3689902, 3689897, 3689893, 3689889, 3689885, 3689880, 3689875, 3689873, 3689869, 3689865, 3689861, 3689856, 3689851, 3689847, 3689843, 3689838, 3689833, 3689829, 3689824, 3689821, 3689817, 3689812, 3689807, 3689802, 3689797, 3689791, 3689785, 3689782, 3689776, 3689769, 3689764, 3689759, 3689754, 3689749, 3689743, 3689738, 3689733, 3689728, 3689722, 3689716, 3689712, 3689707, 3689700, 3689696, 3689689, 3689683, 3689678, 3689673, 3689667)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:49 Duration: 3s382ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3662108)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:15 Duration: 3s302ms

5

4h37m2s

69,164

Details

90ms

930ms

240ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 17	00	4,972	17m9s	207ms
	01	3,808	12m23s	195ms
	02	1,894	7m40s	243ms
	03	1,432	5m49s	243ms
	04	1,952	8m11s	251ms
	05	416	1m37s	234ms
	06	2,480	9m17s	224ms
	07	4	947ms	236ms
	08	10	2s571ms	257ms
	09	170	29s878ms	175ms
	10	208	44s548ms	214ms
	11	550	1m57s	214ms
	12	332	1m19s	239ms
	13	324	1m20s	248ms
	14	970	3m46s	233ms
	15	3,111	13m19s	257ms
	16	5,900	27m36s	280ms
	17	6,827	29m35s	260ms
	18	7,600	30m52s	243ms
	19	9,125	36m12s	238ms
	20	7,815	34m17s	263ms
	21	4,876	18m29s	227ms
	22	4,388	14m46s	202ms

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-17 17:06:12 Duration: 930ms
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-17 17:06:12 Duration: 928ms
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-17 16:51:40 Duration: 911ms

6

3h11m53s

11,559

Details

254ms

2s138ms

996ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 17	00	465	7m28s	964ms
	01	580	9m18s	962ms
	02	237	3m48s	965ms
	04	1	1s2ms	1s2ms
	05	1	949ms	949ms
	08	5	4s782ms	956ms
	09	10	10s234ms	1s23ms
	10	3	3s440ms	1s146ms
	11	5	5s773ms	1s154ms
	12	11	10s999ms	999ms
	13	21	21s673ms	1s32ms
	14	115	2m1s	1s60ms
	15	658	11m9s	1s17ms
	16	841	15m34s	1s111ms
	17	1,345	23m20s	1s41ms
	18	1,846	29m46s	967ms
	19	1,883	30m17s	964ms
	20	1,091	20m23s	1s121ms
	21	956	14m11s	890ms
	22	1,485	23m34s	952ms

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

Date: 2024-12-17 20:31:48 Duration: 2s138ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9451728')) 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 (55))))))) 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 (55)))))) 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 (55)))))) 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 (55))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-17 20:32:32 Duration: 2s113ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9267860')) 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 (68))))))) 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 (68)))))) 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 (68)))))) 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 (68))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-17 20:33:16 Duration: 2s106ms

7

3h8m54s

398

Details

0ms

41m5s

28s478ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 17	00	2	0ms	0ms
	01	4	0ms	0ms
	02	3	3ms	1ms
	03	2	0ms	0ms
	05	2	0ms	0ms
	06	3	0ms	0ms
	07	3	0ms	0ms
	08	16	3ms	0ms
	09	24	13ms	0ms
	10	34	13m1s	22s991ms
	11	35	8m12s	14s75ms
	12	36	34m5s	56s813ms
	13	20	13m4s	39s242ms
	14	34	11m31s	20s327ms
	15	31	3m34s	6s918ms
	16	41	11m55s	17s447ms
	17	32	5m3s	9s494ms
	18	33	3m46s	6s853ms
	19	20	1h24m39s	4m13s
	20	14	7ms	0ms
	21	5	6ms	1ms
	22	4	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-17 18:39:01.944070', "last_update" = '2024-12-17 17:54:01.944101', "sid" = '748a4a4e3163386d764d1b7de64173333ac5e63d', "write_date" = '2024-12-17 17:54:01.495832', "write_uid" = 1 WHERE id IN (1031);

Date: 2024-12-17 19:35:07 Duration: 41m5s
UPDATE "res_users" SET "exp_date" = '2024-12-17 18:46:12.033792', "last_update" = '2024-12-17 18:01:12.033818', "sid" = '748a4a4e3163386d764d1b7de64173333ac5e63d', "write_date" = '2024-12-17 18:01:11.636276', "write_uid" = 1031 WHERE id IN (1031);

Date: 2024-12-17 19:35:07 Duration: 33m55s
UPDATE "res_users" SET "exp_date" = '2024-12-17 11:44:14.896861', "last_update" = '2024-12-17 10:59:14.896883', "sid" = 'c8c171bf43805943bd81f6c9160d57eb6e4038ad', "write_date" = '2024-12-17 10:59:14.537877', "write_uid" = 847 WHERE id IN (847);

Date: 2024-12-17 12:12:20 Duration: 13m5s

8

2h31m28s

31,836

Details

191ms

1s873ms

285ms

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 17	07	703	3m2s	260ms
	08	713	3m3s	256ms
	09	1,567	7m13s	276ms
	10	3,301	16m2s	291ms
	11	1,539	7m11s	280ms
	12	2,618	12m59s	297ms
	13	4,419	20m53s	283ms
	14	2,595	12m8s	280ms
	15	4,311	19m43s	274ms
	16	5,508	27m29s	299ms
	17	1,993	9m56s	299ms
	18	1,633	7m31s	276ms
	19	936	4m13s	270ms

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

Date: 2024-12-17 16:55:18 Duration: 1s873ms
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" = '9210996')))) ORDER BY "collection_policy"."id";

Date: 2024-12-17 16:55:20 Duration: 1s603ms
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" = '9459208')))) ORDER BY "collection_policy"."id";

Date: 2024-12-17 16:55:30 Duration: 1s556ms

9

2h4m

23,472

Details

227ms

2s156ms

316ms

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 17	00	2,065	10m7s	294ms
	01	1,345	6m39s	296ms
	02	726	3m36s	298ms
	03	729	3m36s	296ms
	04	993	4m52s	294ms
	05	215	1m3s	294ms
	06	1,243	6m8s	296ms
	07	2	587ms	293ms
	09	79	23s870ms	302ms
	10	106	35s775ms	337ms
	11	277	1m27s	317ms
	12	159	55s252ms	347ms
	13	144	47s357ms	328ms
	14	389	2m6s	324ms
	15	933	4m57s	318ms
	16	2,147	12m20s	345ms
	17	2,114	11m49s	335ms
	18	2,004	10m55s	326ms
	19	2,734	14m24s	316ms
	20	2,844	15m53s	335ms
	21	1,500	7m40s	306ms
	22	724	3m38s	301ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9488159')) 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-17 20:31:49 Duration: 2s156ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9488162')) 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-17 20:32:25 Duration: 2s74ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9498841')) 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-17 20:32:03 Duration: 1s982ms

10

1h46m13s

155,002

Details

30ms

212ms

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

Day	Hour	Count	Duration	Avg duration
Dec 17	00	2,721	1m44s	38ms
	01	3,123	2m	38ms
	02	2,469	1m35s	38ms
	03	2,368	1m31s	38ms
	04	2,463	1m34s	38ms
	05	1,240	47s513ms	38ms
	06	2,580	1m38s	38ms
	07	1,557	1m	39ms
	08	2,511	1m38s	39ms
	09	7,401	4m56s	40ms
	10	16,202	11m42s	43ms
	11	11,651	7m59s	41ms
	12	13,478	9m32s	42ms
	13	12,734	8m55s	42ms
	14	9,375	6m23s	40ms
	15	9,689	6m35s	40ms
	16	7,721	5m35s	43ms
	17	10,330	7m6s	41ms
	18	10,001	6m44s	40ms
	19	8,576	5m36s	39ms
	20	9,731	7m4s	43ms
	21	4,900	3m6s	38ms
	22	2,181	1m21s	37ms

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

Date: 2024-12-17 20:32:32 Duration: 212ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3679213)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-17 20:33:00 Duration: 199ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3679215)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-17 20:32:56 Duration: 192ms

11

53m55s

1

Details

53m55s

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and (("shipping_policy"."policy_id" in ( select "policy_number".id from "policy_number" where ("policy_number"."name" = ?))) or (("shipping_policy"."policy_id" in ( select "policy_number".id from "policy_number" where (("policy_number"."name" != ?) or "policy_number"."name" is null))) or "shipping_policy"."policy_id" is null)))) 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))))) limit ?) t;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 17	19	1	53m55s	53m55s

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE ("policy_number"."name" = '9352251'))) OR (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."name" != '9352300') OR "policy_number"."name" IS NULL))) OR "shipping_policy"."policy_id" IS NULL)))) 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))))) LIMIT 10001) t;

Date: 2024-12-17 19:35:07 Duration: 53m55s

12

50m22s

60,305

Details

33ms

247ms

50ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 17	00	2	97ms	48ms
	01	2	95ms	47ms
	02	2	99ms	49ms
	03	124	5s769ms	46ms
	06	5	237ms	47ms
	07	25	1s230ms	49ms
	08	390	19s17ms	48ms
	09	2,580	2m7s	49ms
	10	6,988	6m8s	52ms
	11	4,906	4m9s	50ms
	12	5,079	4m24s	52ms
	13	8,502	7m14s	51ms
	14	5,713	4m47s	50ms
	15	6,070	5m1s	49ms
	16	7,041	6m13s	53ms
	17	6,003	4m51s	48ms
	18	4,052	2m55s	43ms
	19	1,913	1m21s	42ms
	20	563	24s949ms	44ms
	21	242	10s328ms	42ms
	22	103	4s181ms	40ms

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

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

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

Date: 2024-12-17 16:55:19 Duration: 242ms

13

47m43s

13,107

Details

186ms

322ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 17	00	72	14s927ms	207ms
	01	7	1s447ms	206ms
	02	172	35s935ms	208ms
	03	377	1m18s	207ms
	05	541	1m51s	206ms
	06	484	1m39s	205ms
	07	219	45s289ms	206ms
	08	2,382	8m18s	209ms
	09	1,206	4m16s	212ms
	10	650	2m29s	229ms
	11	728	2m41s	222ms
	12	1,362	5m8s	226ms
	13	1,077	4m5s	227ms
	14	570	2m8s	224ms
	15	852	3m9s	222ms
	16	694	2m35s	223ms
	17	529	2m2s	231ms
	18	493	1m47s	218ms
	19	188	42s857ms	227ms
	20	259	58s972ms	227ms
	21	228	47s571ms	208ms
	22	17	3s550ms	208ms

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

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

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

Date: 2024-12-17 13:22:01 Duration: 311ms

14

42m15s

12,221

Details

187ms

246ms

207ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 17	00	1,213	4m12s	207ms
	01	1,296	4m30s	208ms
	02	2,437	8m23s	206ms
	03	2,354	8m10s	208ms
	04	1,758	6m3s	206ms
	05	2,240	7m45s	207ms
	06	563	1m57s	208ms
	22	360	1m13s	203ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9323328')) 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-17 05:34:47 Duration: 246ms
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" = '9440179')) 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-17 00:33:02 Duration: 246ms
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" = '9368637')) 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-17 22:34:01 Duration: 240ms

15

32m16s

20,100

Details

75ms

644ms

96ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 17	07	248	22s986ms	92ms
	08	403	36s141ms	89ms
	09	1,355	2m3s	91ms
	10	1,475	2m27s	100ms
	11	1,504	2m22s	94ms
	12	1,994	3m14s	97ms
	13	2,510	4m2s	96ms
	14	1,958	3m3s	93ms
	15	1,702	2m36s	92ms
	16	1,843	2m48s	91ms
	17	1,471	2m25s	99ms
	18	755	1m19s	105ms
	19	875	1m28s	100ms
	20	852	1m34s	110ms
	21	244	23s857ms	97ms
	22	911	1m25s	94ms

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

Date: 2024-12-17 20:32:12 Duration: 644ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7838950)) AND (("cash_track"."id" not in (5864433)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-17 20:32:45 Duration: 616ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7838934)) AND (("cash_track"."id" not in (5864417)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-17 20:32:14 Duration: 607ms

16

20m23s

5,439

Details

189ms

311ms

224ms

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 17	05	383	1m19s	206ms
	06	110	22s913ms	208ms
	07	17	3s527ms	207ms
	08	255	53s884ms	211ms
	09	1,063	3m50s	216ms
	10	1,328	5m9s	233ms
	11	87	19s991ms	229ms
	12	219	49s783ms	227ms
	13	28	6s525ms	233ms
	14	720	2m41s	224ms
	15	344	1m16s	222ms
	16	798	3m6s	233ms
	17	77	19s870ms	258ms
	20	10	2s626ms	262ms

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

Date: 2024-12-17 10:39:35 Duration: 311ms
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" = '9290163')) 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-17 14:32:00 Duration: 309ms
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" = '9293364')) 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-17 17:06:46 Duration: 308ms

17

18m12s

23,797

Details

31ms

102ms

45ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 17	08	51	2s299ms	45ms
	09	929	41s758ms	44ms
	10	3,697	2m59s	48ms
	11	1,915	1m28s	46ms
	12	2,406	1m53s	47ms
	13	2,703	2m8s	47ms
	14	2,840	2m9s	45ms
	15	2,857	2m10s	45ms
	16	2,350	1m50s	47ms
	17	1,817	1m21s	45ms
	18	1,504	57s872ms	38ms
	19	728	27s377ms	37ms

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

Date: 2024-12-17 13:22:00 Duration: 102ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3438649) ORDER BY "collection_policy"."id";

Date: 2024-12-17 12:47:37 Duration: 88ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3511369) ORDER BY "collection_policy"."id";

Date: 2024-12-17 12:47:36 Duration: 88ms

18

17m9s

36

Details

0ms

8m1s

28s593ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 17	07	1	0ms	0ms
	09	5	5ms	1ms
	10	2	3ms	1ms
	11	4	32s245ms	8s61ms
	12	3	5ms	1ms
	13	1	1ms	1ms
	15	2	2ms	1ms
	16	6	6m24s	1m4s
	17	4	10m12s	2m33s
	18	3	4ms	1ms
	20	1	1ms	1ms
	22	4	5ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-17 17:13:19.322299', "last_update" = '2024-12-17 16:28:19.322328', "write_date" = '2024-12-17 16:28:18.975436', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-17 17:36:20 Duration: 8m1s
UPDATE "res_users" SET "exp_date" = '2024-12-17 16:39:57.669241', "last_update" = '2024-12-17 15:54:57.669272', "write_date" = '2024-12-17 15:54:57.120133', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-17 16:58:21 Duration: 3m23s
UPDATE "res_users" SET "exp_date" = '2024-12-17 16:47:09.238496', "last_update" = '2024-12-17 16:02:09.238527', "write_date" = '2024-12-17 16:02:08.871549', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-17 17:04:20 Duration: 2m11s

19

16m39s

286

Details

927ms

4s675ms

3s495ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 17	07	1	927ms	927ms
	08	5	16s238ms	3s247ms
	09	11	35s51ms	3s186ms
	10	11	40s437ms	3s676ms
	11	12	40s754ms	3s396ms
	12	41	2m30s	3s661ms
	13	21	1m15s	3s599ms
	14	14	50s139ms	3s581ms
	15	31	1m46s	3s436ms
	16	36	2m9s	3s609ms
	17	23	1m20s	3s504ms
	18	14	45s450ms	3s246ms
	19	22	1m16s	3s495ms
	20	14	51s695ms	3s692ms
	21	15	51s550ms	3s436ms
	22	15	47s896ms	3s193ms

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

Date: 2024-12-17 12:47:29 Duration: 4s675ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-17 12:47:27 Duration: 4s639ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19)))))))) AND ("policy_number"."name"::text ilike '%91%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-17 12:47:28 Duration: 4s634ms

20

14m30s

3,108

Details

202ms

386ms

280ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 17	09	651	2m54s	268ms
	10	352	1m39s	282ms
	11	57	16s556ms	290ms
	12	178	49s674ms	279ms
	13	62	18s452ms	297ms
	14	697	3m14s	279ms
	15	360	1m38s	274ms
	16	683	3m16s	287ms
	17	68	21s743ms	319ms

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

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

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

Date: 2024-12-17 16:36:52 Duration: 371ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,597,907

Details

2m

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 17	00	40,624	1s969ms	0ms
	01	34,128	1s676ms	0ms
	02	35,566	1s814ms	0ms
	03	36,754	1s881ms	0ms
	04	30,068	1s494ms	0ms
	05	30,160	1s502ms	0ms
	06	31,524	1s584ms	0ms
	07	30,639	1s412ms	0ms
	08	72,401	3s910ms	0ms
	09	149,910	7s291ms	0ms
	10	209,867	11s108ms	0ms
	11	196,356	8s706ms	0ms
	12	231,010	10s395ms	0ms
	13	213,016	9s502ms	0ms
	14	201,600	8s754ms	0ms
	15	207,141	9s31ms	0ms
	16	194,822	7s996ms	0ms
	17	171,298	7s817ms	0ms
	18	144,417	6s554ms	0ms
	19	121,948	5s641ms	0ms
	20	97,265	5s74ms	0ms
	21	72,636	3s318ms	0ms
	22	44,757	2s1ms	0ms

DISCARD ALL;

Date: 2024-12-17 21:10:26 Duration: 1ms
DISCARD ALL;

Date: 2024-12-17 08:49:05 Duration: 1ms
DISCARD ALL;

Date: 2024-12-17 21:01:27 Duration: 1ms

2

2,030,706

Details

29s128ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 17	00	29,113	490ms	0ms
	01	24,252	422ms	0ms
	02	27,193	460ms	0ms
	03	28,520	480ms	0ms
	04	22,297	384ms	0ms
	05	22,924	376ms	0ms
	06	24,727	401ms	0ms
	07	23,831	363ms	0ms
	08	58,569	909ms	0ms
	09	121,523	1s711ms	0ms
	10	171,640	2s619ms	0ms
	11	155,844	2s159ms	0ms
	12	185,127	2s593ms	0ms
	13	168,649	2s304ms	0ms
	14	155,561	2s150ms	0ms
	15	160,477	2s188ms	0ms
	16	147,818	2s109ms	0ms
	17	135,322	1s900ms	0ms
	18	113,081	1s529ms	0ms
	19	93,270	1s240ms	0ms
	20	74,060	1s136ms	0ms
	21	54,065	736ms	0ms
	22	32,843	457ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-17 10:40:16 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-17 10:38:12 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-17 12:15:10 Duration: 1ms

3

1,325,412

Details

13s354ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 17	00	21,056	217ms	0ms
	01	17,753	180ms	0ms
	02	18,521	186ms	0ms
	03	19,145	197ms	0ms
	04	15,733	162ms	0ms
	05	15,666	156ms	0ms
	06	16,356	164ms	0ms
	07	15,977	150ms	0ms
	08	37,098	378ms	0ms
	09	76,349	762ms	0ms
	10	106,482	1s161ms	0ms
	11	99,850	990ms	0ms
	12	117,293	1s207ms	0ms
	13	107,783	1s101ms	0ms
	14	102,672	1s8ms	0ms
	15	105,363	1s49ms	0ms
	16	99,309	1s24ms	0ms
	17	87,168	894ms	0ms
	18	73,785	724ms	0ms
	19	62,060	585ms	0ms
	20	49,651	502ms	0ms
	21	37,239	343ms	0ms
	22	23,103	203ms	0ms

ROLLBACK;

Date: 2024-12-17 17:09:19 Duration: 1ms
ROLLBACK;

Date: 2024-12-17 10:38:12 Duration: 1ms
ROLLBACK;

Date: 2024-12-17 11:41:47 Duration: 0ms

4

1,307,459

Details

3m56s

0ms

16ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 17	00	20,347	3s841ms	0ms
	01	17,055	3s350ms	0ms
	02	17,807	3s513ms	0ms
	03	18,365	3s599ms	0ms
	04	14,981	2s916ms	0ms
	05	15,033	2s759ms	0ms
	06	15,731	2s869ms	0ms
	07	15,383	2s356ms	0ms
	08	36,452	6s610ms	0ms
	09	75,497	13s717ms	0ms
	10	106,104	20s700ms	0ms
	11	99,038	17s618ms	0ms
	12	116,504	21s311ms	0ms
	13	107,366	19s991ms	0ms
	14	101,762	18s90ms	0ms
	15	104,416	18s720ms	0ms
	16	97,214	18s266ms	0ms
	17	86,083	15s495ms	0ms
	18	72,773	12s194ms	0ms
	19	61,302	10s280ms	0ms
	20	48,981	8s492ms	0ms
	21	36,628	6s27ms	0ms
	22	22,637	3s454ms	0ms

SELECT payload FROM http_sessions WHERE sid = '4ca503d8a911d35cd663df7cb989a4602f6c61d2';

Date: 2024-12-17 09:48:36 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = 'baba8a47b89f3fee0e5fa0ecbef4328f00779778';

Date: 2024-12-17 12:52:43 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = '0509fd853e2eb0d2e71a1b44840aed3380eb48e1';

Date: 2024-12-17 13:48:57 Duration: 16ms

5

1,298,147

Details

1m56s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 17	00	20,381	1s821ms	0ms
	01	17,133	1s559ms	0ms
	02	17,853	1s611ms	0ms
	03	18,432	1s665ms	0ms
	04	15,106	1s368ms	0ms
	05	15,156	1s334ms	0ms
	06	15,833	1s391ms	0ms
	07	15,381	1s267ms	0ms
	08	36,194	3s206ms	0ms
	09	74,839	6s568ms	0ms
	10	104,890	9s970ms	0ms
	11	98,001	8s546ms	0ms
	12	115,388	10s566ms	0ms
	13	106,431	9s644ms	0ms
	14	100,633	8s761ms	0ms
	15	103,495	9s206ms	0ms
	16	97,050	8s872ms	0ms
	17	85,530	7s928ms	0ms
	18	72,099	6s480ms	0ms
	19	60,941	5s318ms	0ms
	20	48,643	4s429ms	0ms
	21	36,357	3s177ms	0ms
	22	22,381	1s845ms	0ms

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

Date: 2024-12-17 11:14:04 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-17 20:31:10 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-17 09:30:14 Duration: 1ms

6

909,472

Details

2m10s

0ms

24ms

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 17	00	10,205	1s626ms	0ms
	01	7,650	1s307ms	0ms
	02	10,245	1s679ms	0ms
	03	11,307	1s800ms	0ms
	04	7,838	1s304ms	0ms
	05	8,279	1s368ms	0ms
	06	10,623	1s607ms	0ms
	07	9,652	1s431ms	0ms
	08	27,106	3s913ms	0ms
	09	59,798	7s944ms	0ms
	10	85,246	12s423ms	0ms
	11	73,811	10s189ms	0ms
	12	89,604	11s982ms	0ms
	13	80,078	10s648ms	0ms
	14	69,246	9s726ms	0ms
	15	71,796	10s84ms	0ms
	16	62,054	8s920ms	0ms
	17	62,568	8s795ms	0ms
	18	49,637	6s819ms	0ms
	19	39,134	6s29ms	0ms
	20	30,684	5s683ms	0ms
	21	20,871	3s98ms	0ms
	22	12,040	1s715ms	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 (1294);

Date: 2024-12-17 16:11:59 Duration: 24ms
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 (917);

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

Date: 2024-12-17 17:21:53 Duration: 9ms

7

703,320

Details

2m4s

0ms

39ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 17	00	8,060	1s517ms	0ms
	01	6,499	1s303ms	0ms
	02	8,674	1s709ms	0ms
	03	9,374	1s758ms	0ms
	04	6,562	1s407ms	0ms
	05	7,261	1s456ms	0ms
	06	8,371	1s546ms	0ms
	07	7,852	1s186ms	0ms
	08	21,471	3s315ms	0ms
	09	45,072	7s504ms	0ms
	10	65,114	12s90ms	0ms
	11	55,771	9s415ms	0ms
	12	67,669	12s221ms	0ms
	13	60,707	10s901ms	0ms
	14	52,695	9s142ms	0ms
	15	54,998	9s222ms	0ms
	16	47,824	8s305ms	0ms
	17	48,058	8s541ms	0ms
	18	39,181	6s679ms	0ms
	19	31,163	5s439ms	0ms
	20	24,384	5s133ms	0ms
	21	16,823	3s361ms	0ms
	22	9,737	1s710ms	0ms

COMMIT;

Date: 2024-12-17 10:50:26 Duration: 39ms
COMMIT;

Date: 2024-12-17 15:54:16 Duration: 31ms
COMMIT;

Date: 2024-12-17 06:58:16 Duration: 31ms

8

548,911

Details

1m14s

0ms

9ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 17	00	8,621	1s48ms	0ms
	01	6,155	704ms	0ms
	02	5,751	666ms	0ms
	03	6,850	867ms	0ms
	04	5,164	645ms	0ms
	05	3,341	409ms	0ms
	06	7,649	920ms	0ms
	07	5,274	645ms	0ms
	08	14,061	1s822ms	0ms
	09	37,386	4s707ms	0ms
	10	51,710	7s571ms	0ms
	11	44,658	6s247ms	0ms
	12	53,029	8s110ms	0ms
	13	46,111	6s493ms	0ms
	14	38,179	4s777ms	0ms
	15	43,738	5s804ms	0ms
	16	34,095	6s519ms	0ms
	17	37,059	4s931ms	0ms
	18	29,627	3s644ms	0ms
	19	26,798	3s48ms	0ms
	20	21,337	2s754ms	0ms
	21	13,586	1s537ms	0ms
	22	8,732	848ms	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 (5107075, 5099082, 5200292, 5208767, 5099080, 5207158, 5103012, 5100684, 5099309, 5189375, 5130442, 5104573, 5101085, 5139307, 5102295, 5107053, 5100908, 5117428, 5152517, 5129546, 5395341, 5099135, 5099403, 5099263, 5106435, 5101969, 5099684, 5104872, 5099141, 5099528, 5103249, 5102025, 5099116, 5100396, 5099206, 5099570, 5101018, 5099929, 5108378, 5099155, 5106284, 5104758, 5149540, 5106464, 5113973, 5099445, 5114794, 5406006, 5106365, 5412015, 5394360, 5109226, 5389514, 5101708, 5099111, 5265190, 5116810, 5099216, 5111690, 5099131, 5103712, 5104250, 5130645, 5099108, 5106543, 5099767, 5100937, 5099121, 5099405, 5104810, 5179852, 5106886, 5099746, 5434577, 5099967, 5341773, 5099474, 5106893, 5099848, 5107911, 5104045, 5100794, 5100018, 5295741, 5109777, 5099317, 5098996, 5102926, 5100981, 5108739, 5102148, 5424748, 5430311, 5099102, 5099249, 5100091, 5099133, 5326687, 5099911, 5434446, 5105101, 5099282, 5107216, 5099348, 5100431, 5105115, 5099144, 5100062, 5115971, 5103217, 5099299, 5100913, 5099243, 5105866, 5244336, 5278694, 5100699, 5420697, 5099331, 5104797, 5101328, 5099264, 5100765, 5099573);

Date: 2024-12-17 17:21:53 Duration: 9ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5102790, 5100450, 5101692, 5099228, 5208765, 5101819, 5100285, 5099001, 5099010, 5099654, 5433692, 5099013, 5099009, 5196219, 5099167, 5099202, 5099008, 5099499, 5099387, 5099095, 5099130, 5099815, 5100786, 5099181, 5099224, 5099585, 5417078, 5127563, 5099236, 5133059, 5099523, 5099006, 5109056, 5100726, 5099542, 5099002, 5099035, 5098974, 5110394, 5099007, 5099140, 5399116, 5099547, 5099415, 5099310, 5102344, 5099277, 5119945, 5110245, 5100354, 5109694, 5109567, 5100540, 5099119, 5099401, 5099045, 5102909, 5099873, 5112187, 5099138, 5101852, 5099976, 5099590, 5104601, 5099901, 5285441, 5099546, 5099169, 5104863, 5430080, 5100800, 5099644, 5099037, 5099254, 5100774, 5250328, 5099662, 5100320, 5099129, 5108251, 5101912, 5428000, 5099885, 5424853, 5099275, 5099598, 5104938, 5134271, 5099248, 5327277, 5099090, 5325579, 5099190, 5100144, 5099200, 5099489, 5099112, 5432920, 5130132, 5099137, 5105990, 5100181, 5099802, 5100902, 5099360, 5099540, 5099515, 5170466, 5099272, 5100005, 5128529, 5099179, 5099250, 5099287, 5100901, 5099737, 5109168, 5106194, 5100232, 5100714, 5105330, 5103980);

Date: 2024-12-17 17:21:53 Duration: 9ms
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 (5104875, 5127194, 5099264, 5099103, 5111561, 5108142, 5099577, 5099678, 5103175, 5100564, 5282841, 5154919, 5104762, 5099007, 5244031, 5184426, 5105117, 5113819, 5103658, 5100827, 5260946, 5437568, 5099128, 5099206, 5261751, 5099277, 5100004, 5099791, 5099102, 5110784, 5333341, 5437435, 5160882, 5350861, 5099013, 5099898, 5437569, 5099117, 5100740, 5437445, 5437456, 5437388, 5103166, 5103256, 5111923, 5099194, 5206974, 5395986, 5100935, 5103598, 5101027, 5099192, 5099309, 5437390, 5099540, 5122359, 5106960, 5368716, 5175152, 5121221, 5124557, 5099873, 5108463, 5099251, 5099144, 5244858, 5099139, 5320446, 5175163, 5099009, 5172193, 5100628, 5116789, 5099334, 5404134, 5109752, 5106682, 5105152);

Date: 2024-12-17 17:21:53 Duration: 7ms

9

545,851

Details

35s667ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 17	00	6,077	370ms	0ms
	01	4,125	257ms	0ms
	02	4,435	260ms	0ms
	03	5,175	299ms	0ms
	04	3,343	200ms	0ms
	05	2,947	180ms	0ms
	06	6,550	359ms	0ms
	07	6,041	301ms	0ms
	08	14,716	866ms	0ms
	09	36,759	2s151ms	0ms
	10	51,569	3s538ms	0ms
	11	43,888	2s747ms	0ms
	12	53,122	3s650ms	0ms
	13	47,750	3s242ms	0ms
	14	41,174	2s738ms	0ms
	15	41,313	2s702ms	0ms
	16	35,405	2s734ms	0ms
	17	38,425	2s687ms	0ms
	18	30,818	1s951ms	0ms
	19	26,778	1s658ms	0ms
	20	22,182	1s480ms	0ms
	21	15,181	847ms	0ms
	22	8,078	438ms	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 (1, 28, 126, 32, 79, 39, 4, 73, 17, 113, 35, 65, 9, 127, 36, 78, 8, 102, 27, 48, 16, 24, 60, 26, 44, 80, 2);

Date: 2024-12-17 21:43:05 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 (76);

Date: 2024-12-17 17:21:53 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 (60);

Date: 2024-12-17 17:21:53 Duration: 1ms

10

399,980

Details

2m9s

0ms

15ms

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 17	00	3,027	909ms	0ms
	01	1,823	560ms	0ms
	02	2,840	908ms	0ms
	03	1,759	579ms	0ms
	04	963	310ms	0ms
	05	2,238	708ms	0ms
	06	2,296	740ms	0ms
	07	1,954	584ms	0ms
	08	11,025	3s426ms	0ms
	09	23,966	7s543ms	0ms
	10	28,372	9s733ms	0ms
	11	30,224	9s646ms	0ms
	12	44,447	14s907ms	0ms
	13	36,465	11s874ms	0ms
	14	32,911	10s509ms	0ms
	15	32,794	10s437ms	0ms
	16	36,185	12s75ms	0ms
	17	35,167	11s712ms	0ms
	18	26,463	8s444ms	0ms
	19	18,251	5s729ms	0ms
	20	13,125	4s319ms	0ms
	21	8,489	2s531ms	0ms
	22	5,196	1s536ms	0ms

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

Date: 2024-12-17 15:26:02 Duration: 15ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.company' 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 = 1319) OR r.global) ORDER BY r.id;

Date: 2024-12-17 08:45:42 Duration: 3ms
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 = 884) OR r.global) ORDER BY r.id;

Date: 2024-12-17 10:49:53 Duration: 2ms

11

378,412

Details

1m10s

0ms

10ms

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 17	00	3,555	654ms	0ms
	01	2,197	418ms	0ms
	02	2,846	515ms	0ms
	03	3,012	571ms	0ms
	04	2,112	393ms	0ms
	05	2,093	361ms	0ms
	06	3,980	677ms	0ms
	07	4,241	638ms	0ms
	08	11,437	1s834ms	0ms
	09	25,048	4s438ms	0ms
	10	34,251	6s844ms	0ms
	11	31,215	5s791ms	0ms
	12	37,294	7s229ms	0ms
	13	32,066	6s192ms	0ms
	14	31,032	5s580ms	0ms
	15	31,922	5s847ms	0ms
	16	27,928	5s731ms	0ms
	17	27,234	5s201ms	0ms
	18	22,199	4s56ms	0ms
	19	15,544	2s879ms	0ms
	20	13,208	2s524ms	0ms
	21	9,170	1s596ms	0ms
	22	4,828	830ms	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 (8007486);

Date: 2024-12-17 17:21:53 Duration: 10ms
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 (8006645);

Date: 2024-12-17 17:21:53 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 (8006335);

Date: 2024-12-17 17:21:53 Duration: 8ms

12

305,283

Details

53s885ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 17	00	2,516	361ms	0ms
	01	1,697	234ms	0ms
	02	2,684	372ms	0ms
	03	1,788	233ms	0ms
	04	1,081	141ms	0ms
	05	2,600	348ms	0ms
	06	2,067	296ms	0ms
	07	2,002	294ms	0ms
	08	10,112	1s533ms	0ms
	09	18,935	3s147ms	0ms
	10	20,762	3s759ms	0ms
	11	23,384	4s120ms	0ms
	12	30,295	5s763ms	0ms
	13	25,633	4s779ms	0ms
	14	24,834	4s321ms	0ms
	15	24,943	4s376ms	0ms
	16	31,119	5s853ms	0ms
	17	26,038	4s915ms	0ms
	18	20,302	3s601ms	0ms
	19	12,754	2s192ms	0ms
	20	9,262	1s654ms	0ms
	21	6,495	1s1ms	0ms
	22	3,980	583ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 988 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-17 10:23:51 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1241 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_allow_export' AND model = 'res.groups');

Date: 2024-12-17 20:54:33 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1220 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-17 15:06:15 Duration: 1ms

13

261,583

Details

1d8h19m21s

368ms

3s617ms

444ms

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 17	00	8,114	58m47s	434ms
	01	7,825	56m6s	430ms
	02	7,478	52m16s	419ms
	03	7,767	54m18s	419ms
	04	8,013	56m	419ms
	05	5,238	35m57s	411ms
	06	5,605	39m38s	424ms
	07	2,757	18m58s	413ms
	08	6,404	44m5s	413ms
	09	10,262	1h12m44s	425ms
	10	22,213	2h52m36s	466ms
	11	13,876	1h42m24s	442ms
	12	16,793	2h7m52s	456ms
	13	14,878	1h51m41s	450ms
	14	12,019	1h28m22s	441ms
	15	12,290	1h31m32s	446ms
	16	11,909	1h36m42s	487ms
	17	15,316	1h57m42s	461ms
	18	17,431	2h10m26s	448ms
	19	16,425	1h59m57s	438ms
	20	19,561	2h35m15s	476ms
	21	14,433	1h40m25s	417ms
	22	4,976	35m27s	427ms

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

Date: 2024-12-17 20:32:11 Duration: 3s617ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3690061)) AND (("shipping_track"."id" not in (30067526, 30067526)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:23 Duration: 3s508ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3690067)) AND (("shipping_track"."id" not in (30067588, 30067588)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:29 Duration: 3s388ms

14

255,841

Details

1m5s

0ms

8ms

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 17	00	4,698	1s186ms	0ms
	01	3,310	837ms	0ms
	02	2,654	685ms	0ms
	03	2,853	814ms	0ms
	04	2,410	679ms	0ms
	05	1,324	398ms	0ms
	06	3,629	1s5ms	0ms
	07	2,253	571ms	0ms
	08	5,641	1s435ms	0ms
	09	15,649	3s897ms	0ms
	10	21,234	6s172ms	0ms
	11	18,870	4s878ms	0ms
	12	22,671	5s981ms	0ms
	13	20,886	5s104ms	0ms
	14	18,496	4s91ms	0ms
	15	19,866	4s581ms	0ms
	16	17,380	5s879ms	0ms
	17	18,534	4s566ms	0ms
	18	14,794	3s759ms	0ms
	19	13,898	3s252ms	0ms
	20	11,269	2s862ms	0ms
	21	7,122	1s662ms	0ms
	22	6,400	1s81ms	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 (41560767, 41463477, 32637504, 41623542, 41511578, 41608270, 39875771, 41548154, 41547109, 41547300, 41230484, 41546484, 41583284, 41636653, 41582788, 41582786, 41510498, 41510468, 41566715, 41663074, 41421668, 41516613, 41516604, 41571545, 41287847, 40615683, 41663028, 41493293, 41638543, 41590646, 41565397, 41441090, 32645893, 41440457, 41427622, 41513513);

Date: 2024-12-17 17:21:53 Duration: 8ms
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 (41582179, 41183639, 41537377, 41469569, 41565285, 41571226, 40919346, 41537436, 41579340, 41440458, 41612442, 41467777, 41608001, 32637624, 41495253, 41588594, 41352775, 41444864, 41618329, 41251902, 41489687, 41516135, 41636883, 41518878, 41426293, 41358540, 41562642, 41105237, 41385716, 41511837);

Date: 2024-12-17 17:21:53 Duration: 8ms
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 (41408285, 41638579, 41610391, 41548386, 41490233, 41553559, 41335932, 41638628, 41345291, 41577803, 41523939, 41139935, 41593745, 41492479, 41593750, 41202239, 41418000, 41534231, 41571792, 41593753, 41619721, 41546485, 41636952, 41564258, 41637092, 41542828, 41263611, 41593123, 41636827, 41617210, 41603619);

Date: 2024-12-17 17:21:53 Duration: 7ms

15

186,168

Details

15s191ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 17	00	2,168	130ms	0ms
	01	1,377	83ms	0ms
	02	1,680	104ms	0ms
	03	2,105	141ms	0ms
	04	1,418	99ms	0ms
	05	1,111	73ms	0ms
	06	2,311	134ms	0ms
	07	1,816	104ms	0ms
	08	4,984	311ms	0ms
	09	13,598	892ms	0ms
	10	18,384	1s526ms	0ms
	11	16,079	1s236ms	0ms
	12	19,058	1s742ms	0ms
	13	16,735	1s583ms	0ms
	14	14,060	1s343ms	0ms
	15	15,312	1s27ms	0ms
	16	11,617	1s84ms	0ms
	17	12,387	1s78ms	0ms
	18	9,304	876ms	0ms
	19	8,041	533ms	0ms
	20	6,139	550ms	0ms
	21	4,167	341ms	0ms
	22	2,317	188ms	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-17 17:21:53 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2024-12-17 11:22:05 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-17 17:11:26 Duration: 0ms

16

171,433

Details

10s8ms

0ms

16ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 17	00	1,298	65ms	0ms
	01	717	36ms	0ms
	02	1,219	62ms	0ms
	03	654	34ms	0ms
	04	366	19ms	0ms
	05	960	47ms	0ms
	06	999	52ms	0ms
	07	831	43ms	0ms
	08	4,860	259ms	0ms
	09	10,332	581ms	0ms
	10	11,587	704ms	0ms
	11	13,030	751ms	0ms
	12	18,544	1s138ms	0ms
	13	15,650	926ms	0ms
	14	13,906	787ms	0ms
	15	14,251	805ms	0ms
	16	16,361	1s15ms	0ms
	17	15,247	945ms	0ms
	18	11,304	652ms	0ms
	19	7,662	434ms	0ms
	20	5,708	334ms	0ms
	21	3,622	190ms	0ms
	22	2,325	117ms	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-17 17:09:37 Duration: 16ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (21);

Date: 2024-12-17 22:27:29 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2024-12-17 11:27:49 Duration: 0ms

17

165,691

Details

21s141ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 17	00	1,168	128ms	0ms
	01	699	76ms	0ms
	02	1,210	133ms	0ms
	03	653	73ms	0ms
	04	366	41ms	0ms
	05	948	104ms	0ms
	06	987	112ms	0ms
	07	815	93ms	0ms
	08	4,750	558ms	0ms
	09	10,173	1s245ms	0ms
	10	11,274	1s509ms	0ms
	11	12,758	1s598ms	0ms
	12	18,050	2s417ms	0ms
	13	15,176	1s961ms	0ms
	14	13,397	1s654ms	0ms
	15	13,774	1s696ms	0ms
	16	15,712	2s138ms	0ms
	17	14,633	1s974ms	0ms
	18	10,739	1s366ms	0ms
	19	7,322	908ms	0ms
	20	5,439	708ms	0ms
	21	3,387	386ms	0ms
	22	2,261	252ms	0ms

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

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

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

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

18

160,857

Details

51s266ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 17	00	11,458	3s311ms	0ms
	01	9,006	2s619ms	0ms
	02	5,862	1s982ms	0ms
	03	5,338	1s929ms	0ms
	04	6,188	2s113ms	0ms
	05	2,761	1s159ms	0ms
	06	5,929	1s731ms	0ms
	07	265	130ms	0ms
	08	1,951	952ms	0ms
	09	1,152	507ms	0ms
	10	2,476	1s237ms	0ms
	11	1,511	544ms	0ms
	12	1,847	843ms	0ms
	13	1,451	621ms	0ms
	14	2,448	853ms	0ms
	15	6,729	2s95ms	0ms
	16	12,152	4s32ms	0ms
	17	13,856	4s365ms	0ms
	18	15,410	4s647ms	0ms
	19	18,487	5s434ms	0ms
	20	15,688	4s995ms	0ms
	21	9,885	2s734ms	0ms
	22	9,007	2s419ms	0ms

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

Date: 2024-12-17 17:22:13 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 55) AND ("price_list"."to_office_id" = 36)) ORDER BY "price_list"."id";

Date: 2024-12-17 20:31:04 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 61) AND ("price_list"."to_office_id" = 7)) ORDER BY "price_list"."id";

Date: 2024-12-17 15:51:18 Duration: 1ms

19

155,002

Details

1h46m13s

30ms

212ms

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

Day	Hour	Count	Duration	Avg duration
Dec 17	00	2,721	1m44s	38ms
	01	3,123	2m	38ms
	02	2,469	1m35s	38ms
	03	2,368	1m31s	38ms
	04	2,463	1m34s	38ms
	05	1,240	47s513ms	38ms
	06	2,580	1m38s	38ms
	07	1,557	1m	39ms
	08	2,511	1m38s	39ms
	09	7,401	4m56s	40ms
	10	16,202	11m42s	43ms
	11	11,651	7m59s	41ms
	12	13,478	9m32s	42ms
	13	12,734	8m55s	42ms
	14	9,375	6m23s	40ms
	15	9,689	6m35s	40ms
	16	7,721	5m35s	43ms
	17	10,330	7m6s	41ms
	18	10,001	6m44s	40ms
	19	8,576	5m36s	39ms
	20	9,731	7m4s	43ms
	21	4,900	3m6s	38ms
	22	2,181	1m21s	37ms

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

Date: 2024-12-17 20:32:32 Duration: 212ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3679213)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-17 20:33:00 Duration: 199ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3679215)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-17 20:32:56 Duration: 192ms

20

145,383

Details

1m24s

0ms

44ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 17	00	553	356ms	0ms
	01	204	124ms	0ms
	02	189	120ms	0ms
	03	229	148ms	0ms
	04	219	139ms	0ms
	05	166	99ms	0ms
	06	491	199ms	0ms
	07	1,276	492ms	0ms
	08	2,571	1s295ms	0ms
	09	4,269	2s424ms	0ms
	10	8,923	5s797ms	0ms
	11	9,575	6s152ms	0ms
	12	13,093	8s580ms	0ms
	13	13,181	8s74ms	0ms
	14	10,540	6s30ms	0ms
	15	10,482	6s441ms	0ms
	16	12,167	9s464ms	0ms
	17	10,168	5s893ms	0ms
	18	11,990	5s728ms	0ms
	19	7,048	3s367ms	0ms
	20	16,597	8s502ms	0ms
	21	10,427	4s860ms	0ms
	22	1,025	605ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3623881, 3529305, 3601466, 3419184, 3595310, 3626160, 3590973, 3605133, 3590393, 3572825, 3626168, 3577065, 3626166, 3577415, 3577785, 3602814, 3537588, 3603652, 2978020, 3537077, 3595818, 3623907, 3347302, 2969514, 3325806, 3431166, 3559066, 3629699, 3615691, 3594743, 3595466, 3623891, 3489702, 3623932, 3629701, 3621157, 3623871, 3358683, 3521452, 3616268, 3670529, 3505231, 3549688, 3564305, 3548573, 3569650, 3378147, 3608017, 3515208, 3602751, 3623883, 3587240, 3626161, 3518644, 3499843, 3618365, 3224667, 3607299, 3591425, 3612461, 3497048, 3606034, 3527991, 3567632, 3607730, 3497311, 3582563, 3574828, 3616274, 3572166, 3526740, 3609384, 3595847, 3594391, 3253522, 3386074, 3525877, 3626096, 2887751, 3172205, 3541579, 3623855, 3332489, 3462327, 3618973, 3597040, 3591817, 3555234, 3582833, 3547772, 3601494, 3534483, 3591515, 3415644, 3456152, 3504447, 3525250, 3625404, 3590728, 3594467, 3619429, 3577920, 3616407, 3578308, 3581458, 3617480, 3164248, 3616858, 3512201, 3594707, 3578933, 3496625, 3500595, 3621134, 3604733, 3433994, 3608939, 3608177, 3543700, 3624074, 3345975, 3592127, 3619708, 3553440, 3609024, 3618778, 3487361, 3528643, 3536708, 3596564, 3529859, 3432230, 3548102, 3537527, 3536681, 3596797, 3573074, 3573693, 3627341, 3448098, 3527239, 3603254, 3613354, 3531069, 3597559, 2988081, 3624539, 3615115, 3597178, 3625053, 3624980, 3531468, 3594900, 3624989, 3624548, 3508063, 3222414, 3229023, 3351708, 3528277, 3456568, 3548026, 3444131, 3499503, 3404608, 3541248, 3507464, 3329828, 3517630, 3449051, 3551016, 3670483, 3481511, 3491386, 3519561, 3393480, 3573400, 3530996, 3587126, 3608154, 3609263, 3577284, 3618679, 3626167, 3629661, 3571270, 3570754, 3582515, 3622434, 3606013);

Date: 2024-12-17 17:21:53 Duration: 44ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3655816, 3584883, 3141342, 3184722, 3531465, 3541940, 3549982, 3552121, 3552350, 3554722, 3557589, 3560101, 3562489, 3569675, 3569879, 3570516, 3570556, 3574006, 3574487, 3579339, 3584476, 3584828, 3585360, 3587058, 3587356, 3596412, 3598714, 3600718, 3600979, 3535993, 3655818, 3616171, 3587718, 3617705, 3533934, 3584881, 3619760, 3618935, 3496751, 3562563, 3565257, 3566385, 3567199, 3574474, 3576137, 3577853, 3582561, 3587119, 3598699, 3598707, 3598745, 3619749, 2415494, 3272708, 3333226, 3353819, 3384344, 3435507, 3454282, 3480491, 3489682, 3491712, 3492128, 3500333, 3516205, 3520193, 3535637, 3536650, 3542731, 3549988, 3559032, 3559114, 3563346, 3565286, 3566380, 3566387, 3499340, 3193027, 3443610, 3469299, 3508210, 3509307, 3520688, 3573108, 3574223, 3574278, 3575610, 3587230, 3592104, 3598737, 3600988, 3618937, 3314193, 3412091, 3412906, 3419877, 3421695, 3442447, 3458357, 3461693, 3479261, 3584435, 3585616, 3596852, 3598715, 3598749, 3055701, 3529066, 3619381, 3619348, 3619376, 3616274, 3619429, 3619708, 3617710, 3619740, 3586018, 3574632, 3193047, 3619341, 3620132, 3619334, 3586637, 3580955, 3534014, 3586032, 3619346, 3616269, 3619639, 3535582, 3535128, 3578656, 3586663, 3603852, 3574630, 3586021, 3603858, 3603854, 3620137, 3619662, 3619784, 3619743, 3574652, 3584878, 3586030, 3574651, 3498491, 3620141, 3581676, 3619755, 3580996, 3181851, 3444432, 3499021, 3502511, 3527373, 3549983, 3550020, 3550902, 3559299, 3563552, 2564314, 3052003, 3438836, 3440158, 3444771, 3504934, 3505254, 3516218, 3521366, 3531157, 3531999, 3565258, 3598513, 2997735, 3391432, 3411969, 3421808, 3489740, 3491305, 3497462, 3503986, 3507347, 3516215, 3516229, 3516295, 3523483, 3541831, 3552048, 3556503, 3631975, 3389227, 3444102, 3444454, 3455577, 3478776, 3487847, 3531994, 3542065);

Date: 2024-12-17 17:21:57 Duration: 20ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3613354, 3456568, 3614260, 3614246, 3611823, 3495966, 3576839, 3576905, 3614249, 3614256, 3582927, 3529207, 3581559, 3580391, 3580284, 3530372, 3614216, 3529008, 3583186, 3460544, 3529243, 3580325, 3583188, 3575622, 3491340, 3579868, 3581463, 3576923, 3580330, 3575632, 3575674, 3580356, 3581708, 3576917, 3582971, 3582959, 3580387, 3578531, 3611754, 3610579, 3532094, 3495125, 3580047, 3575557, 3614200, 3419521, 2800686, 3580328, 3580281, 3529348, 3625492, 3575642, 3586199, 3240254, 3596288, 3549145, 3569670, 3558859, 3578780, 3584494, 3590152, 3601649, 3495002, 3582956, 3506588, 3585648, 3100475, 3549141, 3581407, 3581398, 3575551, 3454372, 3581577, 3248672, 3451828, 3462279, 3462281, 3590513, 3598834, 3456497, 3492339, 3579638, 3578502, 3529219, 3583149, 3579578, 3577805, 3411183, 3508166, 3516153, 3559466, 3566312, 3566998, 3568079, 3580242, 3580590, 3589854, 3594314, 3594976, 3598794, 3601294, 3579932, 3081768, 3456760, 3575586, 3570591, 3560501, 3587636, 3544635, 3571779, 3590097, 3486068, 3484937, 3594395, 3591769, 3584301, 3575833, 3596999, 3595346, 3586719, 3551157, 3587052, 3532054, 3495702, 3490959, 3299734, 3439538, 3493310, 3453486, 3475386, 3476371, 3487470, 3487826, 3489005, 3490313, 3526594, 3554500, 3595332, 3495629, 3580407, 3575670, 3575647, 3580135, 3453194, 3469040, 3492926, 3563290, 3604458, 3490942, 3578452, 3549152, 3578121, 3580287, 3585308, 3586188, 3589891, 3591668, 3598774, 3598799, 3598801, 3598815, 3579669, 3581713, 3367472, 3585607, 3598777, 3598782, 3598795, 3579661, 3572008, 3585297, 3594511, 3596233, 3578479, 3096159, 3517749, 3522367, 3573336, 3576627, 3582599, 3590455, 3595336, 3598852, 3495921, 3580319, 3581711, 3579735, 3466841, 3539479, 3566747, 3580159, 3582614, 3583622, 3591087, 3598787, 3598840, 3598847, 3578483);

Date: 2024-12-17 17:21:57 Duration: 18ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

53m55s

1

Details

53m55s

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and (("shipping_policy"."policy_id" in ( select "policy_number".id from "policy_number" where ("policy_number"."name" = ?))) or (("shipping_policy"."policy_id" in ( select "policy_number".id from "policy_number" where (("policy_number"."name" != ?) or "policy_number"."name" is null))) or "shipping_policy"."policy_id" is null)))) 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))))) limit ?) t;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 17	19	1	53m55s	53m55s

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE ("policy_number"."name" = '9352251'))) OR (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."name" != '9352300') OR "policy_number"."name" IS NULL))) OR "shipping_policy"."policy_id" IS NULL)))) 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))))) LIMIT 10001) t;

Date: 2024-12-17 19:35:07 Duration: 53m55s

2

0ms

8m1s

28s593ms

36

Details

17m9s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 17	07	1	0ms	0ms
	09	5	5ms	1ms
	10	2	3ms	1ms
	11	4	32s245ms	8s61ms
	12	3	5ms	1ms
	13	1	1ms	1ms
	15	2	2ms	1ms
	16	6	6m24s	1m4s
	17	4	10m12s	2m33s
	18	3	4ms	1ms
	20	1	1ms	1ms
	22	4	5ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-17 17:13:19.322299', "last_update" = '2024-12-17 16:28:19.322328', "write_date" = '2024-12-17 16:28:18.975436', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-17 17:36:20 Duration: 8m1s
UPDATE "res_users" SET "exp_date" = '2024-12-17 16:39:57.669241', "last_update" = '2024-12-17 15:54:57.669272', "write_date" = '2024-12-17 15:54:57.120133', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-17 16:58:21 Duration: 3m23s
UPDATE "res_users" SET "exp_date" = '2024-12-17 16:47:09.238496', "last_update" = '2024-12-17 16:02:09.238527', "write_date" = '2024-12-17 16:02:08.871549', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-17 17:04:20 Duration: 2m11s

3

0ms

41m5s

28s478ms

398

Details

3h8m54s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 17	00	2	0ms	0ms
	01	4	0ms	0ms
	02	3	3ms	1ms
	03	2	0ms	0ms
	05	2	0ms	0ms
	06	3	0ms	0ms
	07	3	0ms	0ms
	08	16	3ms	0ms
	09	24	13ms	0ms
	10	34	13m1s	22s991ms
	11	35	8m12s	14s75ms
	12	36	34m5s	56s813ms
	13	20	13m4s	39s242ms
	14	34	11m31s	20s327ms
	15	31	3m34s	6s918ms
	16	41	11m55s	17s447ms
	17	32	5m3s	9s494ms
	18	33	3m46s	6s853ms
	19	20	1h24m39s	4m13s
	20	14	7ms	0ms
	21	5	6ms	1ms
	22	4	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-17 18:39:01.944070', "last_update" = '2024-12-17 17:54:01.944101', "sid" = '748a4a4e3163386d764d1b7de64173333ac5e63d', "write_date" = '2024-12-17 17:54:01.495832', "write_uid" = 1 WHERE id IN (1031);

Date: 2024-12-17 19:35:07 Duration: 41m5s
UPDATE "res_users" SET "exp_date" = '2024-12-17 18:46:12.033792', "last_update" = '2024-12-17 18:01:12.033818', "sid" = '748a4a4e3163386d764d1b7de64173333ac5e63d', "write_date" = '2024-12-17 18:01:11.636276', "write_uid" = 1031 WHERE id IN (1031);

Date: 2024-12-17 19:35:07 Duration: 33m55s
UPDATE "res_users" SET "exp_date" = '2024-12-17 11:44:14.896861', "last_update" = '2024-12-17 10:59:14.896883', "sid" = 'c8c171bf43805943bd81f6c9160d57eb6e4038ad', "write_date" = '2024-12-17 10:59:14.537877', "write_uid" = 847 WHERE id IN (847);

Date: 2024-12-17 12:12:20 Duration: 13m5s

4

0ms

51m13s

3s861ms

83,054

Details

3d17h5m26s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 17	00	749	174ms	0ms
	01	725	162ms	0ms
	02	915	202ms	0ms
	03	987	222ms	0ms
	04	653	145ms	0ms
	05	643	138ms	0ms
	06	556	19s989ms	35ms
	07	546	118ms	0ms
	08	2,055	448ms	0ms
	09	5,195	7h27m56s	5s173ms
	10	7,287	3h46m9s	1s862ms
	11	7,029	8h59m59s	4s609ms
	12	8,138	7h39m54s	3s390ms
	13	7,289	11h9m45s	5s513ms
	14	7,653	8h17m48s	3s902ms
	15	6,956	6h37m58s	3s432ms
	16	7,594	11h9m5s	5s286ms
	17	5,686	3h41m39s	2s339ms
	18	4,321	5h9m32s	4s298ms
	19	3,224	3h50m50s	4s296ms
	20	2,155	4m53s	136ms
	21	1,688	11h6m17s	23s683ms
	22	1,010	3m13s	191ms

update res_users set sid = '4607f119b0c69cc749c5435c8d55863916a584ec', last_update = '2024-12-17 17:43:54.569113', exp_date = '2024-12-17 18:28:54.569118', logged_in = 'TRUE' where id = 1031;

Date: 2024-12-17 19:35:07 Duration: 51m13s
update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-17 19:31:43.164574', exp_date = '2024-12-17 20:16:43.164581', logged_in = 'TRUE' where id = 875;

Date: 2024-12-17 21:16:21 Duration: 44m38s
update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-17 19:31:43.165241', exp_date = '2024-12-17 20:16:43.165249', logged_in = 'TRUE' where id = 875;

Date: 2024-12-17 21:16:21 Duration: 44m38s

5

927ms

4s675ms

3s495ms

286

Details

16m39s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 17	07	1	927ms	927ms
	08	5	16s238ms	3s247ms
	09	11	35s51ms	3s186ms
	10	11	40s437ms	3s676ms
	11	12	40s754ms	3s396ms
	12	41	2m30s	3s661ms
	13	21	1m15s	3s599ms
	14	14	50s139ms	3s581ms
	15	31	1m46s	3s436ms
	16	36	2m9s	3s609ms
	17	23	1m20s	3s504ms
	18	14	45s450ms	3s246ms
	19	22	1m16s	3s495ms
	20	14	51s695ms	3s692ms
	21	15	51s550ms	3s436ms
	22	15	47s896ms	3s193ms

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

Date: 2024-12-17 12:47:29 Duration: 4s675ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-17 12:47:27 Duration: 4s639ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19)))))))) AND ("policy_number"."name"::text ilike '%91%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-17 12:47:28 Duration: 4s634ms

6

254ms

2s138ms

996ms

11,559

Details

3h11m53s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 17	00	465	7m28s	964ms
	01	580	9m18s	962ms
	02	237	3m48s	965ms
	04	1	1s2ms	1s2ms
	05	1	949ms	949ms
	08	5	4s782ms	956ms
	09	10	10s234ms	1s23ms
	10	3	3s440ms	1s146ms
	11	5	5s773ms	1s154ms
	12	11	10s999ms	999ms
	13	21	21s673ms	1s32ms
	14	115	2m1s	1s60ms
	15	658	11m9s	1s17ms
	16	841	15m34s	1s111ms
	17	1,345	23m20s	1s41ms
	18	1,846	29m46s	967ms
	19	1,883	30m17s	964ms
	20	1,091	20m23s	1s121ms
	21	956	14m11s	890ms
	22	1,485	23m34s	952ms

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

Date: 2024-12-17 20:31:48 Duration: 2s138ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9451728')) 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 (55))))))) 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 (55)))))) 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 (55)))))) 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 (55))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-17 20:32:32 Duration: 2s113ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9267860')) 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 (68))))))) 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 (68)))))) 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 (68)))))) 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 (68))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-17 20:33:16 Duration: 2s106ms

7

370ms

3s704ms

456ms

47,009

Details

5h57m46s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 17	00	262	1m56s	442ms
	01	201	1m29s	447ms
	02	177	1m25s	482ms
	03	245	1m52s	457ms
	04	186	1m25s	457ms
	05	143	1m6s	462ms
	06	214	1m37s	454ms
	07	1,173	8m12s	420ms
	08	992	7m1s	424ms
	09	2,927	21m19s	437ms
	10	4,712	37m52s	482ms
	11	3,904	29m35s	454ms
	12	3,774	30m	477ms
	13	3,476	26m52s	463ms
	14	4,210	31m20s	446ms
	15	2,977	22m31s	454ms
	16	2,626	21m22s	488ms
	17	3,717	28m18s	457ms
	18	3,367	24m58s	445ms
	19	2,722	19m32s	430ms
	20	2,929	23m42s	485ms
	21	1,399	9m40s	414ms
	22	676	4m32s	402ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3622520, 3609589, 3608158, 3605718, 3604688, 3603154, 3600984, 3568264, 3550035, 3534751, 3534748, 3516209, 3131539, 3126119, 2631604)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:47 Duration: 3s704ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3690064, 3690060, 3690054, 3690050, 3690046, 3690041, 3690037, 3690034, 3690027, 3690024, 3690020, 3690017, 3690013, 3690011, 3690008, 3690005, 3690002, 3690000, 3689998, 3689995, 3689994, 3689991, 3689989, 3689987, 3689985, 3689982, 3689980, 3689978, 3689975, 3689973, 3689970, 3689966, 3689963, 3689961, 3689957, 3689953, 3689952, 3689948, 3689944, 3689942, 3689939, 3689935, 3689933, 3689929, 3689927, 3689924, 3689920, 3689917, 3689914, 3689910, 3689906, 3689902, 3689897, 3689893, 3689889, 3689885, 3689880, 3689875, 3689873, 3689869, 3689865, 3689861, 3689856, 3689851, 3689847, 3689843, 3689838, 3689833, 3689829, 3689824, 3689821, 3689817, 3689812, 3689807, 3689802, 3689797, 3689791, 3689785, 3689782, 3689776, 3689769, 3689764, 3689759, 3689754, 3689749, 3689743, 3689738, 3689733, 3689728, 3689722, 3689716, 3689712, 3689707, 3689700, 3689696, 3689689, 3689683, 3689678, 3689673, 3689667)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:49 Duration: 3s382ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3662108)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:15 Duration: 3s302ms

8

368ms

3s617ms

444ms

261,583

Details

1d8h19m21s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 17	00	8,114	58m47s	434ms
	01	7,825	56m6s	430ms
	02	7,478	52m16s	419ms
	03	7,767	54m18s	419ms
	04	8,013	56m	419ms
	05	5,238	35m57s	411ms
	06	5,605	39m38s	424ms
	07	2,757	18m58s	413ms
	08	6,404	44m5s	413ms
	09	10,262	1h12m44s	425ms
	10	22,213	2h52m36s	466ms
	11	13,876	1h42m24s	442ms
	12	16,793	2h7m52s	456ms
	13	14,878	1h51m41s	450ms
	14	12,019	1h28m22s	441ms
	15	12,290	1h31m32s	446ms
	16	11,909	1h36m42s	487ms
	17	15,316	1h57m42s	461ms
	18	17,431	2h10m26s	448ms
	19	16,425	1h59m57s	438ms
	20	19,561	2h35m15s	476ms
	21	14,433	1h40m25s	417ms
	22	4,976	35m27s	427ms

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

Date: 2024-12-17 20:32:11 Duration: 3s617ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3690061)) AND (("shipping_track"."id" not in (30067526, 30067526)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:23 Duration: 3s508ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3690067)) AND (("shipping_track"."id" not in (30067588, 30067588)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-17 20:32:29 Duration: 3s388ms

9

227ms

2s156ms

316ms

23,472

Details

2h4m

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 17	00	2,065	10m7s	294ms
	01	1,345	6m39s	296ms
	02	726	3m36s	298ms
	03	729	3m36s	296ms
	04	993	4m52s	294ms
	05	215	1m3s	294ms
	06	1,243	6m8s	296ms
	07	2	587ms	293ms
	09	79	23s870ms	302ms
	10	106	35s775ms	337ms
	11	277	1m27s	317ms
	12	159	55s252ms	347ms
	13	144	47s357ms	328ms
	14	389	2m6s	324ms
	15	933	4m57s	318ms
	16	2,147	12m20s	345ms
	17	2,114	11m49s	335ms
	18	2,004	10m55s	326ms
	19	2,734	14m24s	316ms
	20	2,844	15m53s	335ms
	21	1,500	7m40s	306ms
	22	724	3m38s	301ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9488159')) 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-17 20:31:49 Duration: 2s156ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9488162')) 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-17 20:32:25 Duration: 2s74ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9498841')) 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-17 20:32:03 Duration: 1s982ms

10

191ms

1s873ms

285ms

31,836

Details

2h31m28s

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 17	07	703	3m2s	260ms
	08	713	3m3s	256ms
	09	1,567	7m13s	276ms
	10	3,301	16m2s	291ms
	11	1,539	7m11s	280ms
	12	2,618	12m59s	297ms
	13	4,419	20m53s	283ms
	14	2,595	12m8s	280ms
	15	4,311	19m43s	274ms
	16	5,508	27m29s	299ms
	17	1,993	9m56s	299ms
	18	1,633	7m31s	276ms
	19	936	4m13s	270ms

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

Date: 2024-12-17 16:55:18 Duration: 1s873ms
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" = '9210996')))) ORDER BY "collection_policy"."id";

Date: 2024-12-17 16:55:20 Duration: 1s603ms
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" = '9459208')))) ORDER BY "collection_policy"."id";

Date: 2024-12-17 16:55:30 Duration: 1s556ms

11

202ms

386ms

280ms

3,108

Details

14m30s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 17	09	651	2m54s	268ms
	10	352	1m39s	282ms
	11	57	16s556ms	290ms
	12	178	49s674ms	279ms
	13	62	18s452ms	297ms
	14	697	3m14s	279ms
	15	360	1m38s	274ms
	16	683	3m16s	287ms
	17	68	21s743ms	319ms

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

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

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

Date: 2024-12-17 16:36:52 Duration: 371ms

12

90ms

930ms

240ms

69,164

Details

4h37m2s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 17	00	4,972	17m9s	207ms
	01	3,808	12m23s	195ms
	02	1,894	7m40s	243ms
	03	1,432	5m49s	243ms
	04	1,952	8m11s	251ms
	05	416	1m37s	234ms
	06	2,480	9m17s	224ms
	07	4	947ms	236ms
	08	10	2s571ms	257ms
	09	170	29s878ms	175ms
	10	208	44s548ms	214ms
	11	550	1m57s	214ms
	12	332	1m19s	239ms
	13	324	1m20s	248ms
	14	970	3m46s	233ms
	15	3,111	13m19s	257ms
	16	5,900	27m36s	280ms
	17	6,827	29m35s	260ms
	18	7,600	30m52s	243ms
	19	9,125	36m12s	238ms
	20	7,815	34m17s	263ms
	21	4,876	18m29s	227ms
	22	4,388	14m46s	202ms

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-17 17:06:12 Duration: 930ms
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-17 17:06:12 Duration: 928ms
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-17 16:51:40 Duration: 911ms

13

186ms

1s627ms

228ms

126,298

Details

8h1m46s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 17	00	1,295	4m29s	208ms
	01	1,531	5m17s	207ms
	02	2,609	8m59s	206ms
	03	2,731	9m28s	208ms
	04	1,757	6m3s	207ms
	05	3,177	10m58s	207ms
	06	1,157	3m59s	207ms
	07	1,201	4m10s	208ms
	08	4,504	15m40s	208ms
	09	3,409	12m11s	214ms
	10	6,317	24m32s	233ms
	11	5,698	21m9s	222ms
	12	7,951	30m36s	230ms
	13	9,957	37m51s	228ms
	14	6,414	23m53s	223ms
	15	7,376	27m16s	221ms
	16	13,538	52m20s	232ms
	17	8,460	32m14s	228ms
	18	11,552	43m28s	225ms
	19	4,008	14m28s	216ms
	20	17,315	1h17m4s	267ms
	21	3,964	14m13s	215ms
	22	377	1m16s	204ms

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

Date: 2024-12-17 20:32:02 Duration: 1s627ms
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" = '9314255')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-17 20:31:29 Duration: 1s606ms
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" = '9311742')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-17 20:32:58 Duration: 1s597ms

14

189ms

311ms

224ms

5,439

Details

20m23s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 17	05	383	1m19s	206ms
	06	110	22s913ms	208ms
	07	17	3s527ms	207ms
	08	255	53s884ms	211ms
	09	1,063	3m50s	216ms
	10	1,328	5m9s	233ms
	11	87	19s991ms	229ms
	12	219	49s783ms	227ms
	13	28	6s525ms	233ms
	14	720	2m41s	224ms
	15	344	1m16s	222ms
	16	798	3m6s	233ms
	17	77	19s870ms	258ms
	20	10	2s626ms	262ms

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

Date: 2024-12-17 10:39:35 Duration: 311ms
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" = '9290163')) 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-17 14:32:00 Duration: 309ms
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" = '9293364')) 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-17 17:06:46 Duration: 308ms

15

186ms

322ms

218ms

13,107

Details

47m43s

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 17	00	72	14s927ms	207ms
	01	7	1s447ms	206ms
	02	172	35s935ms	208ms
	03	377	1m18s	207ms
	05	541	1m51s	206ms
	06	484	1m39s	205ms
	07	219	45s289ms	206ms
	08	2,382	8m18s	209ms
	09	1,206	4m16s	212ms
	10	650	2m29s	229ms
	11	728	2m41s	222ms
	12	1,362	5m8s	226ms
	13	1,077	4m5s	227ms
	14	570	2m8s	224ms
	15	852	3m9s	222ms
	16	694	2m35s	223ms
	17	529	2m2s	231ms
	18	493	1m47s	218ms
	19	188	42s857ms	227ms
	20	259	58s972ms	227ms
	21	228	47s571ms	208ms
	22	17	3s550ms	208ms

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

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

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

Date: 2024-12-17 13:22:01 Duration: 311ms

16

187ms

246ms

207ms

12,221

Details

42m15s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 17	00	1,213	4m12s	207ms
	01	1,296	4m30s	208ms
	02	2,437	8m23s	206ms
	03	2,354	8m10s	208ms
	04	1,758	6m3s	206ms
	05	2,240	7m45s	207ms
	06	563	1m57s	208ms
	22	360	1m13s	203ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9323328')) 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-17 05:34:47 Duration: 246ms
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" = '9440179')) 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-17 00:33:02 Duration: 246ms
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" = '9368637')) 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-17 22:34:01 Duration: 240ms

17

75ms

644ms

96ms

20,100

Details

32m16s

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 17	07	248	22s986ms	92ms
	08	403	36s141ms	89ms
	09	1,355	2m3s	91ms
	10	1,475	2m27s	100ms
	11	1,504	2m22s	94ms
	12	1,994	3m14s	97ms
	13	2,510	4m2s	96ms
	14	1,958	3m3s	93ms
	15	1,702	2m36s	92ms
	16	1,843	2m48s	91ms
	17	1,471	2m25s	99ms
	18	755	1m19s	105ms
	19	875	1m28s	100ms
	20	852	1m34s	110ms
	21	244	23s857ms	97ms
	22	911	1m25s	94ms

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

Date: 2024-12-17 20:32:12 Duration: 644ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7838950)) AND (("cash_track"."id" not in (5864433)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-17 20:32:45 Duration: 616ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7838934)) AND (("cash_track"."id" not in (5864417)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-17 20:32:14 Duration: 607ms

18

33ms

247ms

50ms

60,305

Details

50m22s

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 17	00	2	97ms	48ms
	01	2	95ms	47ms
	02	2	99ms	49ms
	03	124	5s769ms	46ms
	06	5	237ms	47ms
	07	25	1s230ms	49ms
	08	390	19s17ms	48ms
	09	2,580	2m7s	49ms
	10	6,988	6m8s	52ms
	11	4,906	4m9s	50ms
	12	5,079	4m24s	52ms
	13	8,502	7m14s	51ms
	14	5,713	4m47s	50ms
	15	6,070	5m1s	49ms
	16	7,041	6m13s	53ms
	17	6,003	4m51s	48ms
	18	4,052	2m55s	43ms
	19	1,913	1m21s	42ms
	20	563	24s949ms	44ms
	21	242	10s328ms	42ms
	22	103	4s181ms	40ms

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

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

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

Date: 2024-12-17 16:55:19 Duration: 242ms

19

31ms

102ms

45ms

23,797

Details

18m12s

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 17	08	51	2s299ms	45ms
	09	929	41s758ms	44ms
	10	3,697	2m59s	48ms
	11	1,915	1m28s	46ms
	12	2,406	1m53s	47ms
	13	2,703	2m8s	47ms
	14	2,840	2m9s	45ms
	15	2,857	2m10s	45ms
	16	2,350	1m50s	47ms
	17	1,817	1m21s	45ms
	18	1,504	57s872ms	38ms
	19	728	27s377ms	37ms

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

Date: 2024-12-17 13:22:00 Duration: 102ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3438649) ORDER BY "collection_policy"."id";

Date: 2024-12-17 12:47:37 Duration: 88ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3511369) ORDER BY "collection_policy"."id";

Date: 2024-12-17 12:47:36 Duration: 88ms

20

30ms

212ms

41ms

155,002

Details

1h46m13s

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 17	00	2,721	1m44s	38ms
	01	3,123	2m	38ms
	02	2,469	1m35s	38ms
	03	2,368	1m31s	38ms
	04	2,463	1m34s	38ms
	05	1,240	47s513ms	38ms
	06	2,580	1m38s	38ms
	07	1,557	1m	39ms
	08	2,511	1m38s	39ms
	09	7,401	4m56s	40ms
	10	16,202	11m42s	43ms
	11	11,651	7m59s	41ms
	12	13,478	9m32s	42ms
	13	12,734	8m55s	42ms
	14	9,375	6m23s	40ms
	15	9,689	6m35s	40ms
	16	7,721	5m35s	43ms
	17	10,330	7m6s	41ms
	18	10,001	6m44s	40ms
	19	8,576	5m36s	39ms
	20	9,731	7m4s	43ms
	21	4,900	3m6s	38ms
	22	2,181	1m21s	37ms

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

Date: 2024-12-17 20:32:32 Duration: 212ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3679213)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-17 20:33:00 Duration: 199ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3679215)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-17 20:32:56 Duration: 192ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

19,970,767 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	9	0.00%
DETAIL	13	0.00%
ERROR	10,056	0.05%
EVENTLOG	2,179	0.01%
FATAL	1,744	0.01%
HINT	5	0.00%
LOG	19,946,663	99.88%
STATEMENT	10,098	0.05%

Events distribution (except queries)

Key values

0 PANIC entries
1744 FATAL entries
10056 ERROR entries
0 WARNING entries
2179 EVENTLOG entries

Most Frequent Errors/Events

Key values

5,159 Max number of times the same event was reported
13,979 Total events found

Rank

Times reported

Error

1

5,159

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 17	00	8
	01	8
	02	4
	03	14
	04	2
	05	8
	06	5
	07	10
	08	55
	09	270
	10	336
	11	514
	12	529
	13	364
	14	573
	15	638
	16	1,026
	17	360
	18	199
	19	95
	20	78
	21	32
	22	31

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

2

4,864

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 17	00	7
	01	7
	02	1
	03	12
	05	6
	06	3
	07	10
	08	52
	09	258
	10	307
	11	497
	12	509
	13	346
	14	538
	15	607
	16	1,007
	17	334
	18	184
	19	66
	20	54
	21	28
	22	31

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

3

1,543

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 17	09	77
	10	27
	11	198
	12	126
	13	104
	14	131
	15	106
	16	552
	17	72
	18	71
	19	53
	21	26

4

1,543

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 17	09	77
	10	27
	11	198
	12	126
	13	104
	14	131
	15	106
	16	552
	17	72
	18	71
	19	53
	21	26

LOG: could not send data to client: Broken pipe
LOG: could not send data to client: Broken pipe
LOG: could not send data to client: Broken pipe

5

425

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 17	09	20
	10	6
	11	32
	12	39
	13	59
	14	37
	15	24
	16	130
	17	27
	18	27
	19	13
	20	5
	21	6

6

210

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 17	09	10
	10	4
	11	13
	12	20
	13	32
	14	14
	15	15
	16	63
	17	16
	18	12
	19	6
	20	1
	21	4

7

102

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 17	17	102

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

8

46

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 17	17	46

9

20

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 17	17	20

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

10

19

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 17	01	1
	09	2
	10	2
	11	3
	13	3
	15	2
	16	2
	18	2
	20	1
	21	1

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

11

10

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 17	02	1
	11	2
	13	1
	15	1
	18	1
	19	1
	20	3

12

6

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 17	04	1
	09	2
	20	3

13

5

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 17	17	5

14

5

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 17	13	1
	14	1
	15	1
	16	1
	20	1

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

15

5

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 17	10	1
	13	1
	17	1
	19	2

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

16

4

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 17	17	4

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

17

4

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 17	04	1
	09	2
	20	1

18

3

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 17	15	3

FATAL: password authentication failed for user "postgres"

19

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 17	04	1
	09	2

20

1

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 17	20	1

21

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 17	17	1

22

1

Details

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

Times Reported Most Frequent Error / Event #22

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