pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Dec 10 23:47:41 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 72,942,605 log entries in 2m40s
Log start from 2024-12-10 00:00:00 to 2024-12-10 22:45:01

Global Stats

18,439 Number of unique normalized queries
21,237,601 Number of queries
8d4h26m4s Total query duration
2024-12-10 00:00:00 First query
2024-12-10 22:45:01 Last query
6,586 queries/s at 2024-12-10 11:34:12 Query peak

8d4h26m4s Total query duration
1s125ms Prepare/parse total duration
44s197ms Bind total duration
8d4h25m18s Execute total duration

16,253 Number of events
24 Number of unique normalized events
5,852 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
21,237,601 Average queries per session
8d4h26m4s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

6,586 queries/s Query Peak
2024-12-10 11:34:12 Date

SELECT Traffic

Key values

4,234 queries/s Query Peak
2024-12-10 11:34:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

2,066 queries/s Query Peak
2024-12-10 09:47:53 Date

Queries duration

Key values

8d4h26m4s 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 10	00	314,410	0ms	1h	49ms	3m36s	4m32s	3h2m3s
	01	303,021	0ms	4s113ms	19ms	3m9s	3m45s	5m20s
	02	303,701	0ms	1s109ms	18ms	3m5s	4m9s	4m41s
	03	306,633	0ms	1s105ms	20ms	3m10s	3m39s	3m46s
	04	296,748	0ms	4s515ms	19ms	2m43s	3m29s	3m55s
	05	325,462	0ms	1s837ms	17ms	2m56s	3m47s	4m53s
	06	293,611	0ms	29m57s	95ms	2m36s	3m32s	5h30m15s
	07	266,414	0ms	4s307ms	14ms	2m8s	2m51s	3m35s
	08	517,115	0ms	1s169ms	6ms	2m11s	2m35s	2m43s
	09	1,180,875	0ms	7m10s	18ms	5m6s	58m57s	1h32m10s
	10	1,336,145	0ms	19m	19ms	4m11s	4m57s	4h48m
	11	1,611,020	0ms	23m8s	38ms	43m7s	55m52s	5h15m57s
	12	1,875,500	0ms	28m54s	30ms	20m11s	32m23s	7h11m5s
	13	1,722,296	0ms	12m36s	21ms	20m23s	48m59s	3h1m8s
	14	1,575,504	0ms	33m59s	38ms	29m18s	44m23s	5h16m2s
	15	1,588,788	0ms	14m10s	20ms	7m15s	26m11s	3h7m42s
	16	1,664,087	0ms	29m32s	33ms	42m34s	1h20m45s	4h31m46s
	17	1,347,392	0ms	10m20s	37ms	41m40s	1h3m45s	2h15m25s
	18	1,252,675	0ms	20m56s	38ms	34m9s	47m27s	4h8m16s
	19	1,220,111	0ms	27m43s	44ms	13m35s	16m2s	4h29m17s
	20	790,150	0ms	18m21s	56ms	5m51s	2h8m45s	4h26s
	21	717,551	0ms	21m56s	57ms	8m28s	1h41m57s	3h18m22s
	22	428,392	0ms	42m43s	79ms	4m12s	4m38s	7h46m7s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 10	00	192,540	25ms	2m18s	2m47s	4m31s
	01	183,789	31ms	2m18s	3m8s	4m9s
	02	182,511	30ms	2m18s	3m4s	4m21s
	03	186,546	33ms	2m21s	3m9s	3m40s
	04	181,460	31ms	2m25s	2m43s	3m42s
	05	202,161	27ms	2m11s	2m56s	4m23s
	06	190,120	21ms	1m59s	2m29s	2m46s
	07	176,476	21ms	1m39s	2m8s	2m57s
	08	334,337	10ms	1m34s	2m11s	2m39s
	09	725,883	11ms	3m46s	4m40s	6m
	10	815,517	10ms	3m11s	3m38s	4m56s
	11	1,007,477	12ms	5m15s	5m41s	6m17s
	12	1,162,029	15ms	6m22s	7m14s	10m15s
	13	1,066,067	14ms	5m35s	6m31s	7m24s
	14	974,105	14ms	5m37s	6m25s	7m34s
	15	965,250	16ms	6m3s	6m50s	7m15s
	16	1,042,580	15ms	6m30s	7m20s	9m31s
	17	861,339	18ms	5m55s	8m5s	8m20s
	18	780,078	21ms	6m15s	6m44s	8m8s
	19	758,384	31ms	9m36s	11m36s	14m6s
	20	493,514	18ms	3m26s	4m4s	5m50s
	21	455,769	31ms	5m55s	7m8s	8m28s
	22	263,180	23ms	3m4s	3m36s	4m40s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 10	00	23,208	4,788	139	0	384ms	139ms	180ms	347ms
	01	24,617	5,233	139	0	0ms	129ms	183ms	251ms
	02	19,603	5,832	139	0	0ms	109ms	151ms	252ms
	03	23,307	6,493	135	0	0ms	134ms	163ms	252ms
	04	23,085	5,780	128	0	0ms	133ms	180ms	245ms
	05	19,795	5,537	156	0	0ms	123ms	147ms	207ms
	06	16,854	3,832	154	0	1s151ms	93ms	153ms	243ms
	07	14,240	4,312	159	0	0ms	96ms	111ms	180ms
	08	15,348	5,769	357	0	0ms	116ms	138ms	175ms
	09	43,942	14,447	711	0	213ms	274ms	394ms	57m22s
	10	50,797	15,673	822	0	255ms	276ms	318ms	469ms
	11	63,806	20,148	692	0	577ms	429ms	544ms	54m12s
	12	75,976	24,844	788	0	386ms	490ms	658ms	29m36s
	13	70,115	24,053	910	0	229ms	462ms	555ms	46m58s
	14	55,281	24,276	658	0	580ms	414ms	10s415ms	42m15s
	15	69,578	25,798	822	0	175ms	454ms	511ms	21m30s
	16	69,125	25,968	817	1	411ms	472ms	703ms	1h17m25s
	17	62,809	20,930	794	0	413ms	660ms	6m2s	1h2m45s
	18	75,880	22,968	728	0	321ms	592ms	31s393ms	44m47s
	19	100,600	28,565	733	0	235ms	853ms	1s403ms	3m58s
	20	51,864	14,366	485	0	533ms	299ms	409ms	2h5m42s
	21	61,954	12,947	425	0	355ms	396ms	552ms	1h41m25s
	22	32,604	8,087	199	0	682ms	250ms	303ms	587ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 10	00	118	61,228	518.88	0.04%
	01	118	61,228	518.88	0.04%
	02	118	61,228	518.88	0.04%
	03	118	61,228	518.88	0.04%
	04	118	61,228	518.88	0.04%
	05	141	61,148	433.67	0.05%
	06	119	61,228	514.52	0.05%
	07	118	61,228	518.88	0.05%
	08	118	61,228	518.88	0.03%
	09	118	61,228	518.88	0.01%
	10	118	61,228	518.88	0.01%
	11	118	61,228	518.88	0.01%
	12	118	61,228	518.88	0.01%
	13	118	61,228	518.88	0.01%
	14	118	61,228	518.88	0.01%
	15	118	61,228	518.88	0.01%
	16	118	61,228	518.88	0.01%
	17	121	59,106	488.48	0.01%
	18	118	61,228	518.88	0.01%
	19	118	61,228	518.88	0.01%
	20	118	61,228	518.88	0.02%
	21	118	61,228	518.88	0.02%
	22	97	45,954	473.75	0.03%

Day	Hour	Average / Second
Dec 10	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 10	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

64,122 buffers Checkpoint Peak
2024-12-10 17:20:02 Date
270.058 seconds Highest write time
2.615 seconds Sync time

Checkpoints Wal files

Key values

29 files Wal files usage Peak
2024-12-10 17:20:02 Date

Checkpoints distance

Key values

919.20 Mo Distance Peak
2024-12-10 17:20:02 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 10	00	89,845	3,108.496s	0.039s	3,108.572s
	01	108,142	3,090.573s	0.029s	3,090.641s
	02	128,733	3,239.518s	0.034s	3,239.601s
	03	148,202	3,239.604s	0.029s	3,239.676s
	04	125,187	3,239.527s	0.027s	3,239.603s
	05	150,066	3,239.596s	0.03s	3,239.67s
	06	125,590	3,107.579s	0.042s	3,107.662s
	07	106,967	3,239.64s	0.026s	3,239.7s
	08	136,375	3,239.481s	0.064s	3,239.586s
	09	302,209	3,239.528s	0.051s	3,239.643s
	10	410,622	3,238.998s	2.657s	3,241.726s
	11	481,088	3,239.491s	0.053s	3,239.617s
	12	561,026	3,239.566s	0.057s	3,239.718s
	13	513,546	3,239.477s	0.051s	3,239.639s
	14	395,571	3,239.509s	0.051s	3,239.625s
	15	458,374	3,239.526s	0.057s	3,239.659s
	16	442,412	3,239.487s	0.058s	3,239.652s
	17	307,308	2,882.245s	0.072s	2,882.381s
	18	336,663	3,239.541s	0.047s	3,239.659s
	19	384,984	3,239.556s	0.057s	3,239.693s
	20	275,234	3,239.501s	0.043s	3,239.62s
	21	256,620	3,239.555s	0.062s	3,239.673s
	22	137,071	2,429.678s	0.029s	2,429.747s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Dec 10	00	38	3,319	0.002s	0.012s
	01	47	2,831	0.002s	0.012s
	02	56	2,538	0.003s	0.012s
	03	64	2,727	0.002s	0.012s
	04	57	2,595	0.002s	0.012s
	05	65	2,601	0.002s	0.012s
	06	56	2,899	0.017s	0.012s
	07	45	2,746	0.002s	0.012s
	08	56	3,700	0.017s	0.012s
	09	128	4,697	0.002s	0.012s
	10	173	5,158	1.132s	0.017s
	11	210	5,052	0.003s	0.012s
	12	249	5,295	0.003s	0.012s
	13	226	5,372	0.003s	0.012s
	14	171	5,217	0.002s	0.012s
	15	204	5,475	0.003s	0.012s
	16	192	5,864	0.003s	0.012s
	17	131	5,344	0.009s	0.012s
	18	148	5,283	0.003s	0.012s
	19	176	5,112	0.003s	0.012s
	20	124	5,065	0.002s	0.012s
	21	113	4,954	0.002s	0.012s
	22	61	3,553	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 10	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 10	00	51,856.25 kB	90,216.83 kB
	01	63,728.75 kB	89,694.33 kB
	02	76,859.50 kB	113,172.83 kB
	03	87,804.75 kB	114,180.17 kB
	04	77,341.67 kB	100,994.17 kB
	05	89,039.50 kB	119,025.92 kB
	06	76,243.58 kB	114,895.83 kB
	07	61,541.17 kB	87,412.83 kB
	08	76,086.25 kB	116,393.33 kB
	09	173,598.82 kB	200,567.18 kB
	10	236,973.08 kB	283,980.17 kB
	11	286,625.58 kB	342,114.00 kB
	12	339,674.33 kB	380,681.42 kB
	13	308,562.33 kB	378,918.17 kB
	14	236,670.55 kB	311,410.00 kB
	15	278,371.42 kB	342,906.33 kB
	16	261,823.67 kB	318,444.75 kB
	17	179,000.75 kB	248,304.17 kB
	18	202,311.67 kB	236,811.58 kB
	19	239,919.50 kB	300,055.42 kB
	20	169,297.92 kB	278,047.17 kB
	21	154,362.75 kB	195,860.08 kB
	22	111,595.89 kB	192,842.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 10	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 10	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

13,201,112 Total read queries
5,524,907 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	13,201,112	62.16%
INSERT	1,064,388	5.01%
UPDATE	330,646	1.56%
DELETE	11,090	0.05%
COPY FROM	1	0.00%
COPY TO	0	0.00%
CTE	119,831	0.56%
DDL	5,035	0.02%
TCL	3,993,916	18.81%
CURSOR	0	0.00%
OTHERS	2,511,582	11.83%

Queries by database

Key values

unknown Main database
21,237,601 Requests
8d4h25m18s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	21,237,601	8d4h25m18s
	copy from	1	1ms
	cte	119,831	1m4s
	ddl	5,035	707ms
	delete	11,090	1s492ms
	insert	1,064,388	5m29s
	others	2,511,580	1m51s
	select	13,201,112	2d19h1m53s
	tcl	3,993,916	2m41s
	update	330,646	5d9h12m16s

Queries by user

Key values

unknown Main user
21,237,601 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	21,237,601	8d4h25m18s
	copy from	1	1ms
	cte	119,831	1m4s
	ddl	5,035	707ms
	delete	11,090	1s492ms
	insert	1,064,388	5m29s
	others	2,511,580	1m51s
	select	13,201,112	2d19h1m53s
	tcl	3,993,916	2m41s
	update	330,646	5d9h12m16s

Duration by user

Key values

8d4h25m18s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	21,237,601	8d4h25m18s
	copy from	1	1ms
	cte	119,831	1m4s
	ddl	5,035	707ms
	delete	11,090	1s492ms
	insert	1,064,388	5m29s
	others	2,511,580	1m51s
	select	13,201,112	2d19h1m53s
	tcl	3,993,916	2m41s
	update	330,646	5d9h12m16s

Queries by host

Key values

unknown Main host
21,237,601 Requests
8d4h25m18s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	21,237,601	8d4h25m18s
	copy from	1	1ms
	cte	119,831	1m4s
	ddl	5,035	707ms
	delete	11,090	1s492ms
	insert	1,064,388	5m29s
	others	2,511,580	1m51s
	select	13,201,112	2d19h1m53s
	tcl	3,993,916	2m41s
	update	330,646	5d9h12m16s

Queries by application

Key values

unknown Main application
21,237,601 Requests
8d4h25m18s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	21,237,601	8d4h25m18s
	copy from	1	1ms
	cte	119,831	1m4s
	ddl	5,035	707ms
	delete	11,090	1s492ms
	insert	1,064,388	5m29s
	others	2,511,580	1m51s
	select	13,201,112	2d19h1m53s
	tcl	3,993,916	2m41s
	update	330,646	5d9h12m16s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-10 20:00:31 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

19,806,364 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	19,806,364	93.26%
1-5ms	389,105	1.83%
5-10ms	91,386	0.43%
10-25ms	61,539	0.29%
25-50ms	203,125	0.96%
50-100ms	72,496	0.34%
100-500ms	541,683	2.55%
500-1000ms	63,942	0.30%
1000-10000ms	5,833	0.03%
> 10000ms	2,128	0.01%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:21.866390', exp_date = '2024-12-09 22:59:21.866392', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-10 00:14:22 ]
2	1h	update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:21.866235', exp_date = '2024-12-09 22:59:21.866237', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-10 00:14:22 ]
3	59m55s	update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:26.435793', exp_date = '2024-12-09 22:59:26.435795', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-10 00:14:22 ]
4	42m43s	UPDATE "res_users" SET "exp_date" = '2024-12-10 21:35:36.798818', "last_update" = '2024-12-10 20:50:36.798840', "sid" = 'aaaba5359d1c9dda154478ce7b04b0f8c63f73a8', "write_date" = '2024-12-10 20:50:36.469553', "write_uid" = 1 WHERE id IN (875); [ Date: 2024-12-10 22:33:20 ]
5	42m9s	update res_users set sid = '77810d16e3078e210035bbedda2ad5bed4af505e', last_update = '2024-12-10 20:51:10.882354', exp_date = '2024-12-10 21:36:10.882358', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-10 22:33:20 ]
6	41m43s	update res_users set sid = 'aaaba5359d1c9dda154478ce7b04b0f8c63f73a8', last_update = '2024-12-10 20:51:37.042894', exp_date = '2024-12-10 21:36:37.042898', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-10 22:33:20 ]
7	39m33s	update res_users set sid = '77810d16e3078e210035bbedda2ad5bed4af505e', last_update = '2024-12-10 20:53:47.219303', exp_date = '2024-12-10 21:38:47.219305', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-10 22:33:20 ]
8	34m48s	UPDATE "res_users" SET "exp_date" = '2024-12-10 21:43:31.926592', "last_update" = '2024-12-10 20:58:31.926616', "sid" = 'cc56f8ecdd6122a5fbf51a046877a4ccf6a8c93b', "write_date" = '2024-12-10 20:58:31.599311', "write_uid" = 1 WHERE id IN (875); [ Date: 2024-12-10 22:33:20 ]
9	34m41s	UPDATE "res_users" SET "exp_date" = '2024-12-10 21:43:38.758492', "last_update" = '2024-12-10 20:58:38.758544', "sid" = 'cc56f8ecdd6122a5fbf51a046877a4ccf6a8c93b', "write_date" = '2024-12-10 20:58:38.423409', "write_uid" = 1 WHERE id IN (875); [ Date: 2024-12-10 22:33:20 ]
10	33m59s	update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-10 12:33:20.986893', exp_date = '2024-12-10 13:18:20.986896', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-10 14:07:20 ]
11	33m59s	update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-10 12:33:20.986925', exp_date = '2024-12-10 13:18:20.986928', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-10 14:07:20 ]
12	32m3s	UPDATE "res_users" SET "exp_date" = '2024-12-10 21:46:17.264044', "last_update" = '2024-12-10 21:01:17.264070', "sid" = 'cc56f8ecdd6122a5fbf51a046877a4ccf6a8c93b', "write_date" = '2024-12-10 21:01:16.933962', "write_uid" = 1 WHERE id IN (875); [ Date: 2024-12-10 22:33:20 ]
13	30m26s	UPDATE "res_users" SET "exp_date" = '2024-12-10 21:47:53.794531', "last_update" = '2024-12-10 21:02:53.794552', "sid" = '92c3a817141d39da104a257067f7ec3ed4bb3e7e', "write_date" = '2024-12-10 21:02:53.380156', "write_uid" = 1 WHERE id IN (875); [ Date: 2024-12-10 22:33:20 ]
14	29m57s	update res_users set sid = '0cb7e6c5186cbce9270b9f0665a576bc66eb1983', last_update = '2024-12-10 05:18:23.637524', exp_date = '2024-12-10 06:03:23.637526', logged_in = 'TRUE' where id = 1001; [ Date: 2024-12-10 06:48:21 ]
15	29m32s	update res_users set sid = '68e752ef68f67f67f9f1392adc0ec404cba82d16', last_update = '2024-12-10 14:41:47.385083', exp_date = '2024-12-10 15:26:47.385088', logged_in = 'TRUE' where id = 905; [ Date: 2024-12-10 16:11:20 ]
16	29m32s	update res_users set sid = '68e752ef68f67f67f9f1392adc0ec404cba82d16', last_update = '2024-12-10 14:41:47.384991', exp_date = '2024-12-10 15:26:47.384995', logged_in = 'TRUE' where id = 905; [ Date: 2024-12-10 16:11:20 ]
17	28m54s	update res_users set sid = 'f4b5a95eaf027fda268807f2a6c87af392ee860f', last_update = '2024-12-10 10:57:25.873340', exp_date = '2024-12-10 11:42:25.873343', logged_in = 'TRUE' where id = 895; [ Date: 2024-12-10 12:26:20 ]
18	28m48s	update res_users set sid = 'f4b5a95eaf027fda268807f2a6c87af392ee860f', last_update = '2024-12-10 10:57:32.041477', exp_date = '2024-12-10 11:42:32.041481', logged_in = 'TRUE' where id = 895; [ Date: 2024-12-10 12:26:20 ]
19	28m44s	update res_users set sid = 'f4b5a95eaf027fda268807f2a6c87af392ee860f', last_update = '2024-12-10 10:57:36.723053', exp_date = '2024-12-10 11:42:36.723056', logged_in = 'TRUE' where id = 895; [ Date: 2024-12-10 12:26:20 ]
20	28m42s	update res_users set sid = 'f4b5a95eaf027fda268807f2a6c87af392ee860f', last_update = '2024-12-10 10:57:38.797322', exp_date = '2024-12-10 11:42:38.797326', logged_in = 'TRUE' where id = 895; [ Date: 2024-12-10 12:26:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

5d27m

87,861

Details

0ms

1h

4s935ms

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 10	00	647	2h59m56s	16s686ms
	01	698	146ms	0ms
	02	872	180ms	0ms
	03	802	175ms	0ms
	04	705	147ms	0ms
	05	811	170ms	0ms
	06	646	6h34m23s	36s630ms
	07	508	108ms	0ms
	08	1,787	384ms	0ms
	09	5,546	3h25m49s	2s226ms
	10	5,248	4h46m25s	3s274ms
	11	8,394	13h30m44s	5s795ms
	12	9,357	10h28m24s	4s29ms
	13	7,669	5h56m26s	2s788ms
	14	8,904	12h35m56s	5s93ms
	15	7,654	4h27m53s	2s100ms
	16	7,550	10h56m26s	5s216ms
	17	5,702	8h48m8s	5s557ms
	18	5,025	8h26m20s	6s45ms
	19	4,191	8h22m8s	7s188ms
	20	2,315	9h28m55s	14s745ms
	21	1,810	7h5m51s	14s116ms
	22	1,020	2h33m6s	9s6ms

update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:21.866390', exp_date = '2024-12-09 22:59:21.866392', logged_in = 'TRUE' where id = 932;

Date: 2024-12-10 00:14:22 Duration: 1h
update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:21.866235', exp_date = '2024-12-09 22:59:21.866237', logged_in = 'TRUE' where id = 932;

Date: 2024-12-10 00:14:22 Duration: 1h
update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:26.435793', exp_date = '2024-12-09 22:59:26.435795', logged_in = 'TRUE' where id = 932;

Date: 2024-12-10 00:14:22 Duration: 59m55s

2

1d8h42m18s

257,961

Details

366ms

2s846ms

456ms

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 10	00	5,682	42m1s	443ms
	01	7,389	53m46s	436ms
	02	7,622	54m27s	428ms
	03	8,383	1h30s	433ms
	04	7,696	55m58s	436ms
	05	8,236	59m6s	430ms
	06	5,953	42m36s	429ms
	07	4,356	31m6s	428ms
	08	4,823	34m8s	424ms
	09	10,356	1h16m49s	445ms
	10	11,148	1h22m18s	443ms
	11	15,538	2h31s	465ms
	12	19,214	2h35m30s	485ms
	13	14,773	1h56m35s	473ms
	14	11,512	1h30m29s	471ms
	15	13,691	1h49m17s	478ms
	16	12,495	1h42m7s	490ms
	17	15,114	1h57m19s	465ms
	18	18,828	2h20m9s	446ms
	19	20,772	2h48m28s	486ms
	20	9,800	1h9m54s	428ms
	21	18,036	2h12m56s	442ms
	22	6,544	46m4s	422ms

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

Date: 2024-12-10 19:39:48 Duration: 2s846ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3458027)) AND (("shipping_track"."id" not in (28195751, 28195751)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:50 Duration: 2s758ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3458040)) AND (("shipping_track"."id" not in (28195838, 28195838)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:55 Duration: 2s651ms

3

8h2m11s

422

Details

0ms

42m43s

1m8s

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 10	00	2	1ms	0ms
	01	5	6ms	1ms
	02	3	1ms	0ms
	03	2	2ms	1ms
	05	1	1ms	1ms
	06	5	5m25s	1m5s
	07	1	1ms	1ms
	08	12	9ms	0ms
	09	30	4m33s	9s126ms
	10	32	24ms	0ms
	11	29	3m8s	6s484ms
	12	50	25m30s	30s611ms
	13	34	4m41s	8s290ms
	14	36	19m15s	32s84ms
	15	25	11m46s	28s243ms
	16	22	1m24s	3s824ms
	17	30	25m51s	51s717ms
	18	27	24m29s	54s442ms
	19	18	25ms	1ms
	20	21	23m30s	1m7s
	21	10	20m27s	2m2s
	22	27	5h12m6s	11m33s

UPDATE "res_users" SET "exp_date" = '2024-12-10 21:35:36.798818', "last_update" = '2024-12-10 20:50:36.798840', "sid" = 'aaaba5359d1c9dda154478ce7b04b0f8c63f73a8', "write_date" = '2024-12-10 20:50:36.469553', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-10 22:33:20 Duration: 42m43s
UPDATE "res_users" SET "exp_date" = '2024-12-10 21:43:31.926592', "last_update" = '2024-12-10 20:58:31.926616', "sid" = 'cc56f8ecdd6122a5fbf51a046877a4ccf6a8c93b', "write_date" = '2024-12-10 20:58:31.599311', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-10 22:33:20 Duration: 34m48s
UPDATE "res_users" SET "exp_date" = '2024-12-10 21:43:38.758492', "last_update" = '2024-12-10 20:58:38.758544', "sid" = 'cc56f8ecdd6122a5fbf51a046877a4ccf6a8c93b', "write_date" = '2024-12-10 20:58:38.423409', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-10 22:33:20 Duration: 34m41s

4

6h48m49s

105,107

Details

163ms

1s734ms

233ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 10	00	574	2m8s	224ms
	01	1,547	5m49s	226ms
	02	2,436	9m13s	227ms
	03	2,758	10m22s	225ms
	04	2,047	7m42s	225ms
	05	2,611	9m54s	227ms
	06	1,606	6m2s	225ms
	07	2,577	9m51s	229ms
	08	1,445	5m26s	225ms
	09	2,971	11m59s	242ms
	10	2,308	9m1s	234ms
	11	4,103	16m54s	247ms
	12	7,753	34m31s	267ms
	13	6,791	28m24s	251ms
	14	9,492	39m1s	246ms
	15	12,371	51m20s	248ms
	16	9,542	40m6s	252ms
	17	6,564	23m23s	213ms
	18	7,731	25m11s	195ms
	19	11,860	43m54s	222ms
	20	4,486	13m44s	183ms
	21	1,006	3m6s	184ms
	22	528	1m35s	181ms

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

Date: 2024-12-10 12:30:49 Duration: 1s734ms
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" = '8813820')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-10 12:30:56 Duration: 1s552ms
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" = '8783679')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-10 12:30:50 Duration: 1s470ms

5

5h55m11s

45,355

Details

356ms

3s843ms

469ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 10	00	149	1m9s	468ms
	01	124	1m1s	493ms
	02	147	1m12s	490ms
	03	196	1m33s	478ms
	04	157	1m15s	482ms
	05	365	2m46s	455ms
	06	301	2m14s	447ms
	07	303	2m13s	441ms
	08	872	6m18s	433ms
	09	2,858	21m41s	455ms
	10	3,285	24m50s	453ms
	11	3,488	28m11s	484ms
	12	4,387	36m40s	501ms
	13	4,670	37m34s	482ms
	14	3,091	25m2s	485ms
	15	3,321	26m59s	487ms
	16	3,905	31m57s	491ms
	17	3,502	27m5s	464ms
	18	3,255	24m8s	444ms
	19	2,932	22m43s	465ms
	20	2,040	14m14s	419ms
	21	1,170	8m30s	436ms
	22	837	5m46s	413ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3406539, 3408038, 3408610, 3408739, 3408764, 3408779, 3411563, 3414664, 3415080, 3420455, 3422085, 3423650, 3423752, 3423755, 3423757, 3424046, 3425030, 3425170, 3425204, 3425220, 3425514, 3425970, 3426040, 3426252, 3426321, 3426570, 3426754, 3427116, 3427270, 3427548, 3427984, 3428104, 3428555, 3428594, 3428863, 3434099, 3434993, 3436868, 3436921, 3436940, 3436981, 3436983, 3436990, 3437195, 3437624, 3437774, 3437848, 3438119, 3438190, 3442205, 3442209, 3442210)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 12:30:51 Duration: 3s843ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3416068, 3416063, 3416024, 3408058, 3408052)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 12:30:48 Duration: 3s576ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3442580, 3441180, 3441146, 3438788, 3438718, 3438207, 3437116, 3434601, 3434594, 3432682, 3428394, 3428017, 3425560, 3422989, 3422960, 3422221, 3421967, 3419891, 3417671, 3415100, 3412980, 3409868, 3408419, 3408071, 3403315, 3402959, 3378954)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:47 Duration: 3s540ms

6

4h37m48s

68,132

Details

98ms

959ms

244ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 10	00	3,246	12m38s	233ms
	01	2,516	8m42s	207ms
	02	1,592	5m32s	209ms
	03	2,280	8m46s	230ms
	04	2,872	11m32s	241ms
	05	1,210	5m5s	252ms
	06	1,264	5m10s	245ms
	07	994	3m45s	227ms
	08	280	58s387ms	208ms
	09	94	25s646ms	272ms
	10	100	21s673ms	216ms
	11	354	1m19s	223ms
	12	610	2m41s	265ms
	13	670	3m4s	275ms
	14	1,006	4m6s	244ms
	15	1,205	5m17s	263ms
	16	3,736	16m7s	259ms
	17	5,355	22m23s	250ms
	18	7,161	28m	234ms
	19	14,154	1h4m11s	272ms
	20	5,126	19m38s	229ms
	21	8,297	32m38s	236ms
	22	4,010	15m18s	229ms

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-10 19:43:29 Duration: 959ms
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-10 19:43:29 Duration: 954ms
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-10 19:43:16 Duration: 894ms

7

3h17m48s

11,917

Details

223ms

1s885ms

995ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 10	00	621	10m10s	982ms
	01	694	11m23s	984ms
	02	540	8m50s	982ms
	03	103	1m41s	987ms
	04	64	1m2s	979ms
	07	19	18s330ms	964ms
	08	126	2m1s	961ms
	09	24	27s724ms	1s155ms
	10	14	14s835ms	1s59ms
	11	26	28s989ms	1s114ms
	12	29	34s194ms	1s179ms
	13	19	24s52ms	1s265ms
	14	81	1m25s	1s53ms
	15	321	5m48s	1s84ms
	16	576	10m33s	1s98ms
	17	827	14m12s	1s31ms
	18	1,217	20m16s	999ms
	19	2,597	45m5s	1s41ms
	20	749	10m31s	843ms
	21	2,010	32m34s	972ms
	22	1,260	19m43s	939ms

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

Date: 2024-12-10 19:39:56 Duration: 1s885ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9386009')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-10 19:43:04 Duration: 1s820ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9386022')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-10 19:40:03 Duration: 1s743ms

8

1h58m21s

22,675

Details

215ms

1s754ms

313ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 10	00	1,018	5m28s	323ms
	01	586	3m7s	320ms
	02	260	1m23s	322ms
	03	1,057	5m33s	315ms
	04	1,408	7m25s	316ms
	05	610	3m11s	314ms
	06	636	3m20s	314ms
	07	483	2m31s	314ms
	08	24	7s634ms	318ms
	09	23	7s368ms	320ms
	10	37	12s574ms	339ms
	11	158	54s853ms	347ms
	12	285	1m43s	361ms
	13	324	2m	371ms
	14	430	2m27s	342ms
	15	294	1m44s	356ms
	16	1,328	7m53s	356ms
	17	1,920	9m58s	311ms
	18	2,408	12m5s	301ms
	19	4,562	24m10s	317ms
	20	1,845	8m44s	284ms
	21	2,198	10m29s	286ms
	22	781	3m36s	277ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9329865')) 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-10 19:39:47 Duration: 1s754ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9319758')) 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-10 19:39:50 Duration: 1s632ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9319757')) 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-10 19:39:54 Duration: 666ms

9

1h57m23s

155,009

Details

28ms

233ms

45ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 10	00	2,760	2m2s	44ms
	01	3,117	2m19s	44ms
	02	2,618	1m57s	44ms
	03	2,916	2m10s	44ms
	04	2,420	1m48s	44ms
	05	2,340	1m45s	44ms
	06	1,703	1m16s	45ms
	07	1,709	1m16s	44ms
	08	1,773	1m19s	45ms
	09	7,266	5m41s	47ms
	10	8,920	6m56s	46ms
	11	11,123	9m1s	48ms
	12	14,831	12m30s	50ms
	13	12,176	9m58s	49ms
	14	9,011	7m20s	48ms
	15	11,103	9m9s	49ms
	16	9,404	7m50s	49ms
	17	10,779	7m52s	43ms
	18	9,749	6m16s	38ms
	19	12,132	8m11s	40ms
	20	6,336	3m53s	36ms
	21	6,822	4m18s	37ms
	22	4,001	2m25s	36ms

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

Date: 2024-12-10 12:30:55 Duration: 233ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3393326, 3392538)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-10 12:30:47 Duration: 217ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3406539)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-10 12:30:47 Duration: 191ms

10

1h48m55s

22,387

Details

173ms

842ms

291ms

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 10	09	659	3m8s	286ms
	10	869	4m2s	278ms
	11	1,896	9m21s	296ms
	12	3,317	17m	307ms
	13	2,460	12m6s	295ms
	14	3,945	19m18s	293ms
	15	3,414	16m50s	296ms
	16	3,137	15m41s	300ms
	17	1,272	5m30s	259ms
	18	1,241	5m14s	253ms
	19	177	40s526ms	228ms

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

Date: 2024-12-10 12:30:45 Duration: 842ms
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" = '8840083')))) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:30:45 Duration: 670ms
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" = '9146790')))) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:31:11 Duration: 531ms

11

48m59s

12,968

Details

171ms

271ms

226ms

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

Day	Hour	Count	Duration	Avg duration
Dec 10	00	574	2m8s	224ms
	01	1,500	5m39s	226ms
	02	2,240	8m28s	227ms
	03	2,629	9m52s	225ms
	04	1,719	6m28s	226ms
	05	1,727	6m33s	227ms
	06	686	2m34s	225ms
	07	1,237	4m46s	231ms
	08	542	2m2s	226ms
	09	60	13s765ms	229ms
	22	54	9s798ms	181ms

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

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

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

Date: 2024-12-10 02:03:36 Duration: 269ms

12

45m9s

11,486

Details

168ms

377ms

235ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 10	01	41	9s396ms	229ms
	02	178	41s381ms	232ms
	03	130	29s807ms	229ms
	04	195	43s412ms	222ms
	05	561	2m6s	226ms
	06	900	3m23s	226ms
	07	416	1m33s	225ms
	08	896	3m22s	225ms
	09	1,592	6m20s	238ms
	10	588	2m19s	238ms
	11	605	2m32s	252ms
	12	736	3m7s	255ms
	13	352	1m29s	253ms
	14	651	2m40s	245ms
	15	614	2m33s	250ms
	16	1,269	5m26s	257ms
	17	495	2m6s	254ms
	18	237	46s699ms	197ms
	19	309	1m2s	203ms
	20	240	44s166ms	184ms
	21	216	41s118ms	190ms
	22	265	48s169ms	181ms

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" = '9253058')) 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-10 12:42:55 Duration: 377ms
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" = '9269865')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (14, 15, 16, 17, 18)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17, 14, 74, 70, 11, 62)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17, 14, 74, 70, 11, 62))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17, 14, 74, 70, 11, 62))))) 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-10 19:43:08 Duration: 345ms
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" = '9193594')) 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 (9)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) 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-10 17:15:45 Duration: 343ms

13

37m6s

51,915

Details

31ms

213ms

42ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 10	05	51	2s31ms	39ms
	06	7	301ms	43ms
	07	16	670ms	41ms
	08	128	5s229ms	40ms
	09	573	24s80ms	42ms
	10	1,511	1m2s	41ms
	11	3,174	2m15s	42ms
	12	6,811	5m	44ms
	13	5,977	4m17s	43ms
	14	6,298	4m26s	42ms
	15	8,516	6m6s	43ms
	16	4,350	3m10s	43ms
	17	9,099	6m26s	42ms
	18	2,533	1m46s	41ms
	19	1,733	1m16s	43ms
	20	812	33s849ms	41ms
	21	179	7s641ms	42ms
	22	147	5s932ms	40ms

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

Date: 2024-12-10 12:30:44 Duration: 213ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3335449) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:30:52 Duration: 201ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3357449) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:30:44 Duration: 171ms

14

32m13s

19,824

Details

75ms

541ms

97ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 10	01	65	5s324ms	81ms
	05	17	1s553ms	91ms
	06	20	1s830ms	91ms
	07	20	1s764ms	88ms
	08	202	18s37ms	89ms
	09	917	1m24s	92ms
	10	1,668	2m28s	88ms
	11	1,558	2m26s	94ms
	12	1,707	2m49s	99ms
	13	2,596	4m5s	94ms
	14	2,420	3m46s	93ms
	15	2,374	3m44s	94ms
	16	1,314	2m7s	97ms
	17	992	1m44s	105ms
	18	1,076	1m58s	109ms
	19	865	1m41s	117ms
	20	658	1m7s	103ms
	21	731	1m17s	106ms
	22	624	1m1s	98ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7769225)) AND (("cash_track"."id" not in (5365620, 5376701, 5382338, 5539134, 5539134)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-10 12:30:48 Duration: 541ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7783078)) AND (("cash_track"."id" not in (5457419, 5470554, 5474215, 5539131, 5539131)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-10 12:30:47 Duration: 525ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7789401)) AND (("cash_track"."id" not in (5495242, 5506439, 5514095, 5539130, 5539130)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-10 12:30:46 Duration: 479ms

15

21m43s

371

Details

0ms

6s878ms

3s513ms

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

Day	Hour	Count	Duration	Avg duration
Dec 10	01	12	37s951ms	3s162ms
	06	4	12s973ms	3s243ms
	09	5	14s615ms	2s923ms
	10	7	24s217ms	3s459ms
	11	16	59s898ms	3s743ms
	12	15	1m7s	4s486ms
	13	24	1m26s	3s621ms
	14	40	2m29s	3s748ms
	15	36	2m10s	3s629ms
	16	22	1m16s	3s483ms
	17	36	2m6s	3s520ms
	18	21	1m17s	3s687ms
	19	13	49s256ms	3s788ms
	20	59	3m9s	3s206ms
	21	53	2m54s	3s283ms
	22	8	25s667ms	3s208ms

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

Date: 2024-12-10 12:30:59 Duration: 6s878ms
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 (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) AND ("policy_number"."name"::text ilike '%91%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-10 12:30:57 Duration: 5s617ms
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 (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) AND ("policy_number"."name"::text ilike '%9136%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-10 12:30:59 Duration: 5s488ms

16

20m40s

52

Details

0ms

9m10s

23s861ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 10	01	2	1ms	0ms
	02	1	0ms	0ms
	03	1	1ms	1ms
	08	5	0ms	0ms
	09	2	1ms	0ms
	10	6	2ms	0ms
	11	2	3ms	1ms
	12	9	9ms	1ms
	13	2	3ms	1ms
	14	3	5ms	1ms
	15	1	1ms	1ms
	17	8	18m50s	2m21s
	18	2	1ms	0ms
	19	7	1m50s	15s717ms
	22	1	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-10 17:08:04.923853', "last_update" = '2024-12-10 16:23:04.923874', "write_date" = '2024-12-10 16:23:04.596114', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-10 17:32:15 Duration: 9m10s
UPDATE "res_users" SET "exp_date" = '2024-12-10 17:08:43.574331', "last_update" = '2024-12-10 16:23:43.574353', "write_date" = '2024-12-10 16:23:43.236396', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-10 17:32:15 Duration: 8m31s
UPDATE "res_users" SET "exp_date" = '2024-12-10 18:44:31.138182', "last_update" = '2024-12-10 17:59:31.138204', "write_date" = '2024-12-10 17:59:30.793485', "write_uid" = 1 WHERE id IN (970);

Date: 2024-12-10 19:01:21 Duration: 1m50s

17

15m2s

6,116

Details

120ms

972ms

147ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 10	00	36	4s752ms	132ms
	08	72	9s611ms	133ms
	09	608	1m26s	142ms
	10	754	1m44s	139ms
	11	1,076	2m38s	147ms
	12	839	2m11s	156ms
	13	818	2m	147ms
	14	375	54s813ms	146ms
	15	437	1m5s	149ms
	16	416	1m3s	152ms
	17	202	30s735ms	152ms
	18	99	14s360ms	145ms
	19	220	34s817ms	158ms
	20	127	17s406ms	137ms
	21	33	4s622ms	140ms
	22	4	545ms	136ms

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

Date: 2024-12-10 12:30:59 Duration: 972ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 60)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

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

Date: 2024-12-10 12:31:07 Duration: 284ms

18

13m26s

2,927

Details

15ms

1s76ms

275ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 10	00	2	855ms	427ms
	01	4	394ms	98ms
	02	2	776ms	388ms
	04	2	818ms	409ms
	05	2	876ms	438ms
	06	5	1s437ms	287ms
	07	7	1s853ms	264ms
	08	53	6s50ms	114ms
	09	136	33s245ms	244ms
	10	192	48s639ms	253ms
	11	292	1m25s	291ms
	12	434	2m33s	352ms
	13	374	1m46s	283ms
	14	366	1m31s	249ms
	15	307	1m29s	292ms
	16	170	53s307ms	313ms
	17	155	45s135ms	291ms
	18	117	31s164ms	266ms
	19	59	16s920ms	286ms
	20	55	16s223ms	294ms
	21	144	18s259ms	126ms
	22	49	5s470ms	111ms

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

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

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

Date: 2024-12-10 12:56:13 Duration: 986ms

19

13m24s

3,408

Details

169ms

376ms

236ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 10	04	101	22s601ms	223ms
	05	312	1m12s	231ms
	06	21	4s658ms	221ms
	07	923	3m30s	228ms
	08	7	1s607ms	229ms
	09	3	742ms	247ms
	11	105	25s301ms	240ms
	12	152	38s895ms	255ms
	13	207	52s635ms	254ms
	14	236	57s417ms	243ms
	15	506	2m7s	252ms
	16	404	1m43s	255ms
	17	37	7s645ms	206ms
	18	28	5s841ms	208ms
	19	189	41s630ms	220ms
	22	177	32s270ms	182ms

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" = '8946327')) 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-10 15:08:37 Duration: 376ms
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" = '8962960')) 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-10 13:38:22 Duration: 329ms
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" = '9175569')) 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-10 12:01:59 Duration: 325ms

20

13m5s

20,194

Details

29ms

151ms

38ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 10	10	468	16s957ms	36ms
	11	1,452	56s248ms	38ms
	12	3,263	2m9s	39ms
	13	2,459	1m35s	38ms
	14	3,441	2m12s	38ms
	15	3,617	2m22s	39ms
	16	2,152	1m24s	39ms
	17	1,904	1m13s	38ms
	18	1,153	43s181ms	37ms
	19	285	11s439ms	40ms

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

Date: 2024-12-10 12:30:44 Duration: 151ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 2637781) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:51:40 Duration: 73ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 2620793) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:51:41 Duration: 65ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,508,702

Details

1m51s

0ms

17ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 10	00	37,154	1s442ms	0ms
	01	35,116	1s617ms	0ms
	02	36,973	1s756ms	0ms
	03	34,092	1s652ms	0ms
	04	32,877	1s590ms	0ms
	05	36,452	1s748ms	0ms
	06	30,109	1s125ms	0ms
	07	25,564	931ms	0ms
	08	59,735	2s503ms	0ms
	09	138,527	6s468ms	0ms
	10	169,109	8s264ms	0ms
	11	195,126	8s42ms	0ms
	12	228,131	10s917ms	0ms
	13	213,589	9s579ms	0ms
	14	200,031	8s227ms	0ms
	15	203,259	9s470ms	0ms
	16	201,355	8s563ms	0ms
	17	153,497	6s425ms	0ms
	18	142,798	6s151ms	0ms
	19	126,883	6s74ms	0ms
	20	88,971	3s577ms	0ms
	21	71,525	3s183ms	0ms
	22	47,829	2s202ms	0ms

DISCARD ALL;

Date: 2024-12-10 18:07:16 Duration: 17ms
DISCARD ALL;

Date: 2024-12-10 08:41:59 Duration: 1ms
DISCARD ALL;

Date: 2024-12-10 06:13:24 Duration: 1ms

2

1,998,197

Details

27s415ms

0ms

16ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 10	00	26,394	368ms	0ms
	01	25,223	392ms	0ms
	02	27,473	420ms	0ms
	03	26,205	406ms	0ms
	04	24,907	388ms	0ms
	05	28,724	434ms	0ms
	06	24,272	327ms	0ms
	07	20,891	276ms	0ms
	08	48,555	648ms	0ms
	09	125,800	2s243ms	0ms
	10	139,394	1s859ms	0ms
	11	157,990	2s	0ms
	12	188,233	2s565ms	0ms
	13	170,026	2s234ms	0ms
	14	156,775	2s4ms	0ms
	15	158,870	2s142ms	0ms
	16	158,054	2s57ms	0ms
	17	119,964	1s606ms	0ms
	18	111,748	1s477ms	0ms
	19	99,723	1s415ms	0ms
	20	67,638	861ms	0ms
	21	54,785	779ms	0ms
	22	36,553	503ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-10 10:41:47 Duration: 16ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-10 12:45:01 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-10 09:46:48 Duration: 0ms

3

1,293,245

Details

12s797ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 10	00	19,463	171ms	0ms
	01	18,386	168ms	0ms
	02	19,169	177ms	0ms
	03	17,678	165ms	0ms
	04	17,053	164ms	0ms
	05	18,873	174ms	0ms
	06	15,697	139ms	0ms
	07	13,392	125ms	0ms
	08	30,852	281ms	0ms
	09	82,513	916ms	0ms
	10	85,819	803ms	0ms
	11	99,345	975ms	0ms
	12	116,175	1s199ms	0ms
	13	108,529	1s75ms	0ms
	14	102,054	989ms	0ms
	15	103,178	1s40ms	0ms
	16	102,229	1s28ms	0ms
	17	78,338	780ms	0ms
	18	72,659	716ms	0ms
	19	64,552	699ms	0ms
	20	45,419	412ms	0ms
	21	37,074	365ms	0ms
	22	24,798	225ms	0ms

ROLLBACK;

Date: 2024-12-10 11:37:33 Duration: 1ms
ROLLBACK;

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

Date: 2024-12-10 13:31:24 Duration: 1ms

4

1,260,808

Details

3m26s

0ms

18ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 10	00	18,784	2s742ms	0ms
	01	17,715	2s813ms	0ms
	02	18,563	3s48ms	0ms
	03	17,010	2s843ms	0ms
	04	16,407	2s713ms	0ms
	05	18,255	3s31ms	0ms
	06	14,973	2s336ms	0ms
	07	12,763	2s90ms	0ms
	08	30,121	4s433ms	0ms
	09	68,096	10s935ms	0ms
	10	85,588	13s267ms	0ms
	11	98,229	16s62ms	0ms
	12	115,353	18s980ms	0ms
	13	107,869	17s406ms	0ms
	14	100,583	16s165ms	0ms
	15	102,504	17s39ms	0ms
	16	101,319	16s656ms	0ms
	17	76,738	13s121ms	0ms
	18	71,612	12s265ms	0ms
	19	63,832	11s521ms	0ms
	20	44,742	7s176ms	0ms
	21	35,791	6s222ms	0ms
	22	23,961	3s871ms	0ms

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

Date: 2024-12-10 15:34:02 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = '47e49d13a800175e1fcee9811a2768d49d179e48';

Date: 2024-12-10 14:59:50 Duration: 13ms
SELECT payload FROM http_sessions WHERE sid = '449352cceadd6f1a84fb61908def18f70d9765db';

Date: 2024-12-10 16:33:24 Duration: 13ms

5

1,251,670

Details

1m50s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 10	00	18,646	1s503ms	0ms
	01	17,639	1s534ms	0ms
	02	18,559	1s652ms	0ms
	03	17,118	1s534ms	0ms
	04	16,529	1s480ms	0ms
	05	18,297	1s597ms	0ms
	06	15,088	1s229ms	0ms
	07	12,861	1s142ms	0ms
	08	29,867	2s481ms	0ms
	09	67,673	5s823ms	0ms
	10	84,478	7s156ms	0ms
	11	97,397	8s455ms	0ms
	12	113,849	10s200ms	0ms
	13	106,654	9s502ms	0ms
	14	99,824	8s602ms	0ms
	15	101,564	9s309ms	0ms
	16	100,524	8s915ms	0ms
	17	76,484	6s896ms	0ms
	18	71,230	6s390ms	0ms
	19	63,434	6s26ms	0ms
	20	44,435	3s746ms	0ms
	21	35,648	3s204ms	0ms
	22	23,872	1s999ms	0ms

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

Date: 2024-12-10 02:52:19 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-10 11:34:47 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-10 16:24:14 Duration: 1ms

6

915,502

Details

2m7s

0ms

25ms

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 10	00	8,588	1s241ms	0ms
	01	8,329	1s318ms	0ms
	02	9,869	1s500ms	0ms
	03	10,229	1s618ms	0ms
	04	9,516	1s472ms	0ms
	05	11,496	1s775ms	0ms
	06	10,459	1s408ms	0ms
	07	9,829	1s203ms	0ms
	08	23,926	2s992ms	0ms
	09	58,724	7s631ms	0ms
	10	71,474	9s280ms	0ms
	11	77,325	10s376ms	0ms
	12	95,781	13s981ms	0ms
	13	80,250	11s97ms	0ms
	14	71,428	10s226ms	0ms
	15	73,725	10s343ms	0ms
	16	72,997	10s163ms	0ms
	17	52,564	7s305ms	0ms
	18	49,550	6s757ms	0ms
	19	45,925	6s907ms	0ms
	20	27,671	3s587ms	0ms
	21	21,565	3s79ms	0ms
	22	14,282	2s21ms	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 (932);

Date: 2024-12-10 13:15:26 Duration: 25ms
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 (863);

Date: 2024-12-10 18:07:16 Duration: 16ms
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 (901);

Date: 2024-12-10 17:22:05 Duration: 10ms

7

702,469

Details

2m1s

0ms

39ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 10	00	6,918	1s141ms	0ms
	01	6,864	1s333ms	0ms
	02	8,303	1s520ms	0ms
	03	8,526	1s778ms	0ms
	04	7,854	1s424ms	0ms
	05	9,853	1s744ms	0ms
	06	8,508	1s446ms	0ms
	07	7,498	1s457ms	0ms
	08	17,702	2s785ms	0ms
	09	43,190	6s960ms	0ms
	10	53,518	7s791ms	0ms
	11	58,401	10s111ms	0ms
	12	71,848	12s513ms	0ms
	13	61,314	10s278ms	0ms
	14	54,422	9s347ms	0ms
	15	55,602	9s676ms	0ms
	16	55,582	9s286ms	0ms
	17	41,243	7s77ms	0ms
	18	38,779	6s809ms	0ms
	19	35,132	7s40ms	0ms
	20	22,090	4s43ms	0ms
	21	17,601	3s601ms	0ms
	22	11,721	2s69ms	0ms

COMMIT;

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

Date: 2024-12-10 12:11:42 Duration: 38ms
COMMIT;

Date: 2024-12-10 18:34:06 Duration: 35ms

8

561,450

Details

1m15s

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 10	00	6,476	669ms	0ms
	01	5,922	684ms	0ms
	02	5,582	661ms	0ms
	03	6,311	814ms	0ms
	04	6,822	707ms	0ms
	05	5,961	730ms	0ms
	06	7,074	923ms	0ms
	07	5,634	648ms	0ms
	08	13,786	1s546ms	0ms
	09	37,705	4s907ms	0ms
	10	46,222	5s923ms	0ms
	11	46,020	6s730ms	0ms
	12	57,497	9s314ms	0ms
	13	45,159	6s166ms	0ms
	14	38,961	5s433ms	0ms
	15	42,592	5s857ms	0ms
	16	42,720	6s191ms	0ms
	17	30,624	4s47ms	0ms
	18	32,469	4s84ms	0ms
	19	35,776	4s338ms	0ms
	20	18,107	2s39ms	0ms
	21	15,073	1s828ms	0ms
	22	8,957	947ms	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 (5099007, 5124094, 5105921, 5100354, 5099009, 5099761, 5102234, 5099730, 5103019, 5099104, 5099097, 5217025, 5099013, 5103008, 5099010, 5101971, 5099141, 5126277, 5102139, 5103548, 5113616, 5100520, 5415680, 5425158, 5100202, 5099045, 5100183, 5151783, 5117838, 5103520, 5107364, 5099014, 5124451, 5099515, 5248511, 5122024, 5099263, 5113565, 5099542, 5099170, 5215999, 5099765, 5099349, 5099181, 5099130, 5108814, 5099095, 5100768, 5104991, 5099119, 5099243, 5278160, 5146124, 5100181, 5100600, 5099650, 5151482, 5153162, 5116518, 5099224, 5101193, 5103909, 5100821, 5099540, 5099047, 5121271, 5125093, 5116609, 5099837, 5099309, 5100824, 5134303, 5099137, 5108432, 5099389, 5107837, 5102339, 5107439);

Date: 2024-12-10 17:22:06 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 (5099010, 5099204, 5110694, 5099090, 5111857, 5099006, 5099138, 5425454, 5170827, 5258336, 5099009, 5099224, 5102245, 5425433, 5099103, 5425412, 5425396, 5129927, 5342580, 5099427, 5099095, 5100111, 5099403, 5099198, 5425322, 5174814, 5099254, 5099007, 5099855, 5225025, 5099632, 5099141, 5100232, 5116973, 5099008, 5104379, 5274877, 5100564, 5110324, 5099415, 5124563, 5099263, 5103117, 5099243, 5099169, 5117728, 5099995, 5100726, 5099503, 5151738, 5099873, 5099967, 5100401, 5100935, 5116572, 5165104, 5099521, 5134025, 5206495, 5100062, 5099102, 5101615, 5107768, 5099190, 5099688, 5112032, 5099985, 5288214, 5099445, 5425082, 5100181, 5101050, 5104072, 5099540, 5099144, 5099499, 5112323, 5255847, 5151600, 5101424, 5367173, 5099104, 5099788, 5100001, 5099528, 5099181, 5100045, 5125400, 5101328, 5125025, 5113242, 5114285, 5100857, 5099013, 5101089, 5100801, 5099165, 5101831, 5099111, 5104758, 5104872, 5099920, 5109665, 5234503, 5123699, 5099042, 5102207, 5129746, 5103750, 5099135, 5103179, 5424750, 5099746, 5424735, 5099186, 5099236, 5100118, 5099563, 5106028, 5099646, 5126138, 5100110, 5101243, 5108734, 5115445, 5121812, 5359226, 5099131, 5100124, 5101525, 5099123, 5099360, 5099296, 5099187, 5101722, 5125206, 5137116, 5099206, 5099321, 5099092, 5120009, 5099896, 5102186, 5099585, 5113955, 5104512, 5100148, 5132065, 5109192, 5424491, 5099119, 5101059, 5109783, 5099401, 5099162, 5100929, 5099045, 5099174, 5100204, 5099947, 5100700, 5101741, 5100939, 5103451, 5100723, 5112001, 5099277, 5165469, 5101225, 5350306, 5102148, 5424420, 5102416, 5099639, 5099389, 5122500, 5101185, 5099264, 5099795, 5099331, 5099614, 5099014, 5134516, 5104802, 5099202, 5103051, 5099170, 5424272, 5099523, 5099306, 5100144, 5099434, 5099590, 5100295, 5099577, 5099167, 5099725, 5099630, 5099047, 5103797, 5105025, 5183459, 5099188, 5120944, 5106284, 5100762, 5104565, 5344410, 5099930, 5104623, 5114378, 5099334, 5099677, 5099636, 5105218, 5102015, 5424074, 5098996, 5099319, 5101379, 5164166, 5100883, 5099128, 5139194, 5099349, 5104783, 5176235, 5099446, 5099867, 5141382, 5100937, 5099244, 5112091, 5160738, 5100070, 5223404, 5137147, 5100800, 5271917, 5109890, 5100509, 5099643, 5099642, 5107560, 5154959, 5278694, 5146913, 5099570, 5108950, 5107837, 5099231, 5135590, 5410038, 5188419, 5099088, 5099727, 5423711, 5106892, 5099028, 5100796, 5423650, 5099129, 5101388, 5099662, 5099248, 5099275, 5099830, 5231888, 5198278, 5114910, 5100540, 5099280, 5109767, 5129496, 5101478, 5104277, 5116074, 5104174, 5401058, 5146096, 5147874, 5111245, 5099272, 5102128);

Date: 2024-12-10 15:25:33 Duration: 3ms
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 (5099010, 5099204, 5110694, 5099090, 5111857, 5099006, 5099138, 5425454, 5170827, 5258336, 5099009, 5099224, 5102245, 5425433, 5099103, 5425412, 5425396, 5129927, 5342580, 5099427, 5099095, 5100111, 5099403, 5099198, 5425322, 5174814, 5099254, 5099007, 5099855, 5225025, 5099632, 5099141, 5100232, 5116973, 5099008, 5104379, 5274877, 5100564, 5110324, 5099415, 5124563, 5099263, 5103117, 5099243, 5099169, 5117728, 5099995, 5100726, 5099503, 5151738, 5099873, 5099967, 5100401, 5100935, 5116572, 5165104, 5099521, 5134025, 5206495, 5100062, 5099102, 5101615, 5107768, 5099190, 5099688, 5112032, 5099985, 5288214, 5099445, 5425082, 5100181, 5101050, 5104072, 5099540, 5099144, 5099499, 5112323, 5255847, 5151600, 5101424, 5367173, 5099104, 5099788, 5100001, 5099528, 5099181, 5100045, 5125400, 5101328, 5125025, 5113242, 5114285, 5100857, 5099013, 5101089, 5100801, 5099165, 5101831, 5099111, 5104758, 5104872, 5099920, 5109665, 5234503, 5123699, 5099042, 5102207, 5129746, 5103750, 5099135, 5103179, 5424750, 5099746, 5424735, 5099186, 5099236, 5100118, 5099563, 5106028, 5099646, 5126138, 5100110, 5101243, 5108734, 5115445, 5121812, 5359226, 5099131, 5100124, 5101525, 5099123, 5099360, 5099296, 5099187, 5101722, 5125206, 5137116, 5099206, 5099321, 5099092, 5120009, 5099896, 5102186, 5099585, 5113955, 5104512, 5100148, 5132065, 5109192, 5424491, 5099119, 5101059, 5109783, 5099401, 5099162, 5100929, 5099045, 5099174, 5100204, 5099947, 5100700, 5101741, 5100939, 5103451, 5100723, 5112001, 5099277, 5165469, 5101225, 5350306, 5102148, 5424420, 5102416, 5099639, 5099389, 5122500, 5101185, 5099264, 5099795, 5099331, 5099614, 5099014, 5134516, 5104802, 5099202, 5103051, 5099170, 5424272, 5099523, 5099306, 5100144, 5099434, 5099590, 5100295, 5099577, 5099167, 5099725, 5099630, 5099047, 5103797, 5105025, 5183459, 5099188, 5120944, 5106284, 5100762, 5104565, 5344410, 5099930, 5104623, 5114378, 5099334, 5099677, 5099636, 5105218, 5102015, 5424074, 5098996, 5099319, 5101379, 5164166, 5100883, 5099128, 5139194, 5099349, 5104783, 5176235, 5099446, 5099867, 5141382, 5100937, 5099244, 5112091, 5160738, 5100070, 5223404, 5137147, 5100800, 5271917, 5109890, 5100509, 5099643, 5099642, 5107560, 5154959, 5278694, 5146913, 5099570, 5108950, 5107837, 5099231, 5135590, 5410038, 5188419, 5099088, 5099727, 5423711, 5106892, 5099028, 5100796, 5423650, 5099129, 5101388, 5099662, 5099248, 5099275, 5099830, 5231888, 5198278, 5114910, 5100540, 5099280, 5109767, 5129496, 5101478, 5104277, 5116074, 5104174, 5401058, 5146096, 5147874, 5111245, 5099272, 5102128, 5099158, 5113437, 5100802, 5100457, 5104141, 5105225, 5290215, 5101815, 5100331, 5100506, 5108223, 5230645, 5100636, 5099356, 5141671, 5422232, 5099133, 5099406, 5422150, 5101145, 5100507, 5422149, 5099134, 5104276, 5104600, 5422141, 5117911, 5100529, 5113472, 5113265, 5103557, 5099901, 5108613, 5099246, 5101476, 5100917, 5103195, 5101219, 5100266, 5100202, 5100129, 5099582, 5100112, 5100431, 5101016, 5100738, 5099195, 5101685, 5108318, 5099730, 5150882, 5099758, 5099749, 5111337, 5099284, 5099581, 5102013, 5101816, 5123141, 5099309, 5099404, 5110792, 5099845, 5099442, 5100108, 5139411, 5099177, 5100421, 5122129, 5106524, 5099355, 5099359, 5101137, 5100327, 5127516, 5100827, 5099895, 5099282, 5099194, 5100607, 5101808, 5103145, 5099568, 5100223, 5139616, 5363408, 5134406, 5114310, 5375545, 5420649, 5099130, 5100386, 5144885, 5107213, 5101315, 5120631, 5139190, 5100822, 5099864, 5300790, 5111607, 5108833, 5099958, 5099137, 5128604, 5099105, 5107507, 5099037, 5104738, 5100155, 5113765, 5103199, 5101018, 5100415, 5277503, 5104045, 5099413, 5114904, 5195057, 5099660, 5099802, 5104401, 5102572, 5101449, 5099719, 5099765, 5274180, 5109010, 5115585, 5114481, 5412446, 5150538, 5160119, 5116968, 5300776, 5122425, 5103223, 5099815, 5100561, 5099647, 5100132, 5100218, 5261372, 5103020, 5138377, 5106354, 5244360, 5160196, 5419744, 5161820, 5115983, 5103835, 5154383, 5099694, 5111794, 5105109, 5419600, 5419560, 5122776, 5099929, 5127704, 5102792, 5102265, 5099348, 5100004, 5099550, 5168827, 5180243, 5099515, 5114720, 5100659, 5419430, 5107228, 5104624, 5299851, 5099698, 5098989, 5100021, 5101778, 5104822, 5100150, 5345016, 5104994, 5174954, 5104259, 5099533, 5099631, 5110408, 5099285, 5143953, 5102557, 5396469, 5202945, 5418750, 5100628, 5100221, 5124497, 5124101, 5418543, 5102332, 5099311, 5172638, 5110320, 5118046, 5106040, 5363421, 5102054, 5401079, 5150351, 5110662, 5158017, 5237715, 5099761, 5099922, 5103607);

Date: 2024-12-10 15:25:44 Duration: 3ms

9

548,202

Details

37s423ms

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 10	00	5,022	294ms	0ms
	01	4,393	277ms	0ms
	02	4,443	296ms	0ms
	03	4,614	324ms	0ms
	04	4,489	295ms	0ms
	05	5,753	361ms	0ms
	06	6,758	371ms	0ms
	07	5,981	325ms	0ms
	08	13,468	741ms	0ms
	09	35,017	2s149ms	0ms
	10	43,495	2s702ms	0ms
	11	44,729	3s229ms	0ms
	12	56,784	4s525ms	0ms
	13	47,120	3s571ms	0ms
	14	40,816	2s998ms	0ms
	15	43,595	3s216ms	0ms
	16	43,361	2s858ms	0ms
	17	32,529	2s69ms	0ms
	18	31,771	1s999ms	0ms
	19	31,844	2s314ms	0ms
	20	18,521	1s64ms	0ms
	21	14,646	955ms	0ms
	22	9,053	481ms	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 (10, 9);

Date: 2024-12-10 03:47:11 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (4, 39, 2, 127, 123, 35, 26, 28, 32, 42, 16, 7, 5, 8, 70, 1, 46, 78, 27, 61, 60, 102, 13, 22, 30, 19, 64, 24, 126, 75, 65, 41, 110, 76, 11, 114, 38, 48, 9, 73, 44, 119, 115, 10, 113, 3, 67, 77, 29, 52, 80, 111, 121, 49, 36, 71, 79, 6);

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

Date: 2024-12-10 10:07:18 Duration: 1ms

10

414,316

Details

2m13s

0ms

3ms

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 10	00	2,418	671ms	0ms
	01	2,059	618ms	0ms
	02	1,966	616ms	0ms
	03	1,689	535ms	0ms
	04	1,523	451ms	0ms
	05	3,522	1s118ms	0ms
	06	2,866	870ms	0ms
	07	1,756	524ms	0ms
	08	8,946	2s622ms	0ms
	09	22,842	7s115ms	0ms
	10	24,521	7s654ms	0ms
	11	38,400	12s330ms	0ms
	12	40,408	13s765ms	0ms
	13	40,333	13s317ms	0ms
	14	34,692	11s314ms	0ms
	15	33,834	11s425ms	0ms
	16	40,878	13s466ms	0ms
	17	32,676	10s516ms	0ms
	18	25,378	8s96ms	0ms
	19	20,992	7s160ms	0ms
	20	14,443	4s293ms	0ms
	21	12,595	3s896ms	0ms
	22	5,579	1s601ms	0ms

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

Date: 2024-12-10 11:56:34 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 901) OR r.global) ORDER BY r.id;

Date: 2024-12-10 17:22:05 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 872) OR r.global) ORDER BY r.id;

Date: 2024-12-10 17:22:05 Duration: 1ms

11

382,364

Details

1m11s

0ms

16ms

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 10	00	3,159	517ms	0ms
	01	2,767	472ms	0ms
	02	2,664	482ms	0ms
	03	2,925	524ms	0ms
	04	2,689	480ms	0ms
	05	3,501	609ms	0ms
	06	3,913	691ms	0ms
	07	4,254	651ms	0ms
	08	11,470	1s669ms	0ms
	09	25,333	4s350ms	0ms
	10	30,111	5s197ms	0ms
	11	32,373	6s146ms	0ms
	12	39,767	7s830ms	0ms
	13	33,963	6s425ms	0ms
	14	30,280	5s832ms	0ms
	15	31,237	5s885ms	0ms
	16	32,191	6s188ms	0ms
	17	23,812	4s712ms	0ms
	18	21,377	4s136ms	0ms
	19	18,580	3s907ms	0ms
	20	11,366	2s24ms	0ms
	21	8,951	1s722ms	0ms
	22	5,681	980ms	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-10 16:22:50 Duration: 16ms
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 (8006319);

Date: 2024-12-10 17:22:05 Duration: 13ms
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-10 17:22:05 Duration: 13ms

12

316,311

Details

56s196ms

0ms

1ms

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 10	00	2,023	275ms	0ms
	01	1,864	255ms	0ms
	02	2,310	313ms	0ms
	03	2,344	302ms	0ms
	04	1,261	163ms	0ms
	05	2,619	391ms	0ms
	06	2,093	308ms	0ms
	07	1,779	241ms	0ms
	08	9,333	1s309ms	0ms
	09	17,476	2s913ms	0ms
	10	18,271	3s	0ms
	11	28,340	5s161ms	0ms
	12	28,931	5s614ms	0ms
	13	29,647	5s550ms	0ms
	14	28,250	5s59ms	0ms
	15	24,024	4s526ms	0ms
	16	29,399	5s588ms	0ms
	17	25,723	4s718ms	0ms
	18	20,174	3s540ms	0ms
	19	14,801	2s807ms	0ms
	20	11,313	1s814ms	0ms
	21	9,774	1s653ms	0ms
	22	4,562	685ms	0ms

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

Date: 2024-12-10 16:36:29 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-10 12:52:23 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-10 15:28:22 Duration: 1ms

13

258,758

Details

1m7s

0ms

30ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 10	00	3,472	753ms	0ms
	01	2,916	672ms	0ms
	02	2,484	602ms	0ms
	03	2,976	814ms	0ms
	04	3,287	789ms	0ms
	05	2,580	687ms	0ms
	06	3,050	956ms	0ms
	07	2,677	635ms	0ms
	08	5,360	1s175ms	0ms
	09	14,698	3s842ms	0ms
	10	18,627	4s604ms	0ms
	11	19,361	6s722ms	0ms
	12	24,021	7s32ms	0ms
	13	20,583	4s913ms	0ms
	14	19,003	4s630ms	0ms
	15	19,969	4s704ms	0ms
	16	19,674	5s410ms	0ms
	17	15,008	3s928ms	0ms
	18	15,763	3s970ms	0ms
	19	18,837	4s690ms	0ms
	20	9,488	2s197ms	0ms
	21	9,034	2s145ms	0ms
	22	5,890	1s161ms	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 (41347641, 41475729, 41484902, 41457725, 41437660, 41365525, 40662685, 41134002, 32635368, 41277261, 41012933, 40953317, 40953318, 41374812, 41367281, 41120262, 41437293, 41218643, 41371953, 41364384, 41482146, 41326236, 41478268, 41365050, 41471516, 41344922, 41371785, 41436452, 41331491, 41400186, 41498758, 41452380, 41471517, 41039933, 41355597, 41419189, 41186767, 41407729, 41470785, 40652629, 41464928, 41473729, 41452624, 40629035, 41463279, 41430925, 41452345, 32635389, 41048786, 41328119, 41410482, 41372619, 41464693, 41427388, 41436992, 41372031, 41437456, 41466053, 41445686, 41331189, 41494856, 41391446, 41471537, 41179927, 41372193, 41471507, 41335894, 41517148, 41128776, 41471221, 41476094, 41455891, 41438522, 40881370, 41364328, 41335893, 41192513, 41450355, 41353838, 41335903, 41506048, 40834379, 41497187, 32643857, 41475525, 32635653, 41433958, 41393785, 41374808, 41499898, 41162318, 41476580, 41407574, 41437710, 41410061, 41375778, 41451694, 41135290, 41372357);

Date: 2024-12-10 17:22:06 Duration: 30ms
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 (41378159, 41377929, 41312709, 41378314, 41380447, 41377260, 41312667, 41025119, 41109255, 41379677, 41378352, 41380453, 41378351, 41377919, 41377770, 41377951, 41258962, 41313250, 41313290, 41378409, 41377109, 41377128, 41109274, 41376673, 41380283, 41377930, 41380464, 41377117, 41380458, 41380462, 41172481, 41377984, 41378318, 41377238, 41377445, 41313148, 41377234, 41311788, 41025111, 41376660, 41400341, 41379739, 41380198, 41380236, 41380454, 41380250, 41313391, 41380199, 41380089, 41377507, 41379696, 41241131, 41377436, 41376791, 41313000, 41377050, 41240983, 41313154, 41377113, 41311730, 41380443, 41250760, 41379802, 41377230, 41380278, 41313382, 41312018, 41380517, 41171861, 41379711, 41240896, 41380286, 41380167, 41377086, 41380285, 41377446, 41312666, 41377232, 41311731, 41377135, 41325421, 41241278, 41109000, 41380270, 41380159, 41400633, 41311726, 41311718, 41376661, 41313271, 41377239, 41377043, 41377044, 41377233, 41380446, 41313238, 41313298, 41313302, 41311723, 41380197, 41377097, 41380163, 41172447, 41313384, 41379644, 41379645, 41108984, 41380221, 41312998, 41313388, 41377424, 41250763, 41380281, 41380444, 41380380, 41380182, 41380164, 41379787, 41025574, 41313261, 41313262, 41380449, 41109286, 41379712, 41380271, 41379876, 41380442, 41380287, 40963359, 40955143, 41258966, 41377426, 41380280, 41380289, 41380217, 41380222, 41380005, 41379875, 41379764, 41379715, 41313260, 41380305, 41242635, 41379720, 41377425, 41380162, 41172491, 41379807, 40963039, 41311696, 41313170, 41380200, 41313263, 41380279, 41311712, 41379713, 41380044, 41241624, 41312959, 41025518, 41313171, 41171715, 41336721, 41173401, 41242088, 41312741, 41108997, 41108173, 41380343, 41313478, 41240892, 41312200, 41241279, 41312306, 41240898, 41311703, 41240921, 41313100, 41380025, 41312721, 41311697, 41313303, 41380079, 41380344, 41313179, 41311930, 41312201, 41312740, 41380023, 41312714, 41241408, 41380022, 41380026, 41311702, 41173393, 41242612, 41312931, 41313378, 41242179, 41242116, 41023739, 41240718, 41312182, 41260173, 41312537, 41313301, 41313471, 41172307, 41313314, 41025520, 41312202, 41241280, 41172855, 41312525, 41241161, 41312199, 41108876, 41241411, 41173331, 41108773, 41241336, 41171656, 41172853, 41241357, 41241481, 41242603, 41242072, 41108174, 41242449, 41024736, 40911783, 41242450, 41108828, 41171654, 41241941, 41242463, 41242456, 41173340, 41173303, 41171655, 41108985, 41108829, 41172869, 41109094, 41108130, 41109219, 40963081, 41024743, 40912534);

Date: 2024-12-10 12:36:45 Duration: 18ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (41499549, 41499452, 41435288, 41198929, 41436019, 41481023, 41367798, 41203029, 41353625, 41288889, 41416563, 40458904, 41381110, 41521623, 41538944, 41369170, 41464413, 41538842, 41205724, 32634998, 41415559, 40958118, 41499779, 40138771, 41453913, 40959694, 41455312, 41453780, 41477919, 41434618, 41434607, 41198880, 41081390, 41290870, 41407191, 41255636, 41419411, 41419413, 41418339, 41476077, 41406930, 41476080, 41499523, 41469944, 41425337, 41332621, 41406855, 41205166, 41433234, 41476084, 32643804, 41429964, 41495603, 41495629, 41407720, 41179923, 32650382, 41498827, 41382219, 41418661, 41331468, 41388409, 41470831, 41333187, 41471004, 41470995, 41470770, 41477782, 41497155, 41477943, 32650878, 41394632, 41469480, 39355910, 41437520, 32650173, 41437575, 41437552, 41355267, 41419714, 41516157, 41515758, 41405408, 41405350, 41432082, 41424686, 41288566, 41490811, 41095289, 41407867, 41358220, 41358228, 41358919, 41401739, 41309632, 41366151, 41423022, 41419800, 41288535, 41288500, 41452338, 41403603, 41395227, 41162079, 41343968, 40878265, 41366269, 41253172, 41197554, 41403114, 40973666, 41443784, 41465747, 41263732, 41458048, 41235936, 41419463, 32647497, 41362528, 41362532, 41428360, 41512024, 41435900, 41428489, 41311387, 41311475, 41348595, 41275319, 41135052, 41282796, 41282191, 41328622, 41354430, 41438350, 41438342, 32647608, 41409976, 41375159, 41375168, 41371672, 41372244, 41299418, 32648857, 41371391, 41438286, 41404988, 41371084, 41282460, 41483601, 32647145, 40885985, 41450975, 41359051, 41195928, 41191094, 40973671);

Date: 2024-12-10 12:46:23 Duration: 15ms

14

257,961

Details

1d8h42m18s

366ms

2s846ms

456ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 10	00	5,682	42m1s	443ms
	01	7,389	53m46s	436ms
	02	7,622	54m27s	428ms
	03	8,383	1h30s	433ms
	04	7,696	55m58s	436ms
	05	8,236	59m6s	430ms
	06	5,953	42m36s	429ms
	07	4,356	31m6s	428ms
	08	4,823	34m8s	424ms
	09	10,356	1h16m49s	445ms
	10	11,148	1h22m18s	443ms
	11	15,538	2h31s	465ms
	12	19,214	2h35m30s	485ms
	13	14,773	1h56m35s	473ms
	14	11,512	1h30m29s	471ms
	15	13,691	1h49m17s	478ms
	16	12,495	1h42m7s	490ms
	17	15,114	1h57m19s	465ms
	18	18,828	2h20m9s	446ms
	19	20,772	2h48m28s	486ms
	20	9,800	1h9m54s	428ms
	21	18,036	2h12m56s	442ms
	22	6,544	46m4s	422ms

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

Date: 2024-12-10 19:39:48 Duration: 2s846ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3458027)) AND (("shipping_track"."id" not in (28195751, 28195751)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:50 Duration: 2s758ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3458040)) AND (("shipping_track"."id" not in (28195838, 28195838)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:55 Duration: 2s651ms

15

189,682

Details

15s745ms

0ms

17ms

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 10	00	1,788	138ms	0ms
	01	1,594	95ms	0ms
	02	1,659	101ms	0ms
	03	1,806	113ms	0ms
	04	1,804	109ms	0ms
	05	1,883	114ms	0ms
	06	2,278	131ms	0ms
	07	1,999	110ms	0ms
	08	4,785	265ms	0ms
	09	13,333	847ms	0ms
	10	16,312	1s250ms	0ms
	11	16,267	1s458ms	0ms
	12	20,730	2s126ms	0ms
	13	16,174	1s723ms	0ms
	14	14,199	1s345ms	0ms
	15	15,329	1s117ms	0ms
	16	14,798	1s103ms	0ms
	17	10,464	850ms	0ms
	18	10,299	905ms	0ms
	19	10,129	1s42ms	0ms
	20	5,517	334ms	0ms
	21	3,938	288ms	0ms
	22	2,597	172ms	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-10 15:34:02 Duration: 17ms
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-10 17:22:05 Duration: 2ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2024-12-10 15:32:47 Duration: 1ms

16

180,630

Details

10s546ms

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 10	00	976	46ms	0ms
	01	862	43ms	0ms
	02	831	41ms	0ms
	03	678	34ms	0ms
	04	530	26ms	0ms
	05	1,428	75ms	0ms
	06	1,200	62ms	0ms
	07	747	36ms	0ms
	08	4,177	211ms	0ms
	09	10,416	576ms	0ms
	10	10,817	596ms	0ms
	11	16,635	979ms	0ms
	12	17,375	1s80ms	0ms
	13	17,542	1s55ms	0ms
	14	15,106	891ms	0ms
	15	14,897	899ms	0ms
	16	17,530	1s72ms	0ms
	17	14,498	860ms	0ms
	18	11,028	633ms	0ms
	19	8,790	546ms	0ms
	20	6,503	345ms	0ms
	21	5,576	305ms	0ms
	22	2,488	122ms	0ms

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

Date: 2024-12-10 18:53:56 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

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

Date: 2024-12-10 11:26:29 Duration: 0ms

17

173,554

Details

22s304ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 10	00	960	100ms	0ms
	01	850	95ms	0ms
	02	811	90ms	0ms
	03	667	73ms	0ms
	04	530	57ms	0ms
	05	1,407	165ms	0ms
	06	1,177	129ms	0ms
	07	738	78ms	0ms
	08	4,067	449ms	0ms
	09	10,262	1s243ms	0ms
	10	10,498	1s268ms	0ms
	11	16,225	2s94ms	0ms
	12	16,647	2s309ms	0ms
	13	16,687	2s226ms	0ms
	14	14,713	1s908ms	0ms
	15	14,187	1s888ms	0ms
	16	16,890	2s278ms	0ms
	17	13,563	1s765ms	0ms
	18	10,479	1s313ms	0ms
	19	8,344	1s165ms	0ms
	20	6,153	711ms	0ms
	21	5,295	635ms	0ms
	22	2,404	253ms	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 (17) 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-10 12:56:13 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-10 18:21:38 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-10 16:07:06 Duration: 0ms

18

158,848

Details

50s667ms

0ms

1ms

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 10	00	7,168	1s987ms	0ms
	01	6,550	2s14ms	0ms
	02	5,377	1s863ms	0ms
	03	6,754	2s189ms	0ms
	04	7,742	2s389ms	0ms
	05	5,123	1s853ms	0ms
	06	4,554	1s581ms	0ms
	07	3,138	1s56ms	0ms
	08	1,913	786ms	0ms
	09	1,175	545ms	0ms
	10	712	327ms	0ms
	11	2,134	955ms	0ms
	12	2,426	1s32ms	0ms
	13	1,878	725ms	0ms
	14	2,708	976ms	0ms
	15	3,035	1s97ms	0ms
	16	7,671	2s455ms	0ms
	17	10,754	3s275ms	0ms
	18	14,619	4s463ms	0ms
	19	28,433	9s325ms	0ms
	20	10,289	2s880ms	0ms
	21	16,603	4s737ms	0ms
	22	8,092	2s149ms	0ms

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

Date: 2024-12-10 17:22:28 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 6) AND ("price_list"."to_office_id" = 7)) ORDER BY "price_list"."id";

Date: 2024-12-10 19:24:46 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 78) AND ("price_list"."to_office_id" = 32)) ORDER BY "price_list"."id";

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

19

155,009

Details

1h57m23s

28ms

233ms

45ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 10	00	2,760	2m2s	44ms
	01	3,117	2m19s	44ms
	02	2,618	1m57s	44ms
	03	2,916	2m10s	44ms
	04	2,420	1m48s	44ms
	05	2,340	1m45s	44ms
	06	1,703	1m16s	45ms
	07	1,709	1m16s	44ms
	08	1,773	1m19s	45ms
	09	7,266	5m41s	47ms
	10	8,920	6m56s	46ms
	11	11,123	9m1s	48ms
	12	14,831	12m30s	50ms
	13	12,176	9m58s	49ms
	14	9,011	7m20s	48ms
	15	11,103	9m9s	49ms
	16	9,404	7m50s	49ms
	17	10,779	7m52s	43ms
	18	9,749	6m16s	38ms
	19	12,132	8m11s	40ms
	20	6,336	3m53s	36ms
	21	6,822	4m18s	37ms
	22	4,001	2m25s	36ms

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

Date: 2024-12-10 12:30:55 Duration: 233ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3393326, 3392538)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-10 12:30:47 Duration: 217ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3406539)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-10 12:30:47 Duration: 191ms

20

152,032

Details

30s692ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 10	00	811	139ms	0ms
	01	740	134ms	0ms
	02	742	134ms	0ms
	03	633	113ms	0ms
	04	491	89ms	0ms
	05	1,238	230ms	0ms
	06	1,029	190ms	0ms
	07	677	119ms	0ms
	08	3,579	637ms	0ms
	09	9,172	1s752ms	0ms
	10	9,561	1s835ms	0ms
	11	14,601	2s904ms	0ms
	12	14,872	3s157ms	0ms
	13	14,845	3s69ms	0ms
	14	12,802	2s615ms	0ms
	15	12,282	2s572ms	0ms
	16	14,305	2s987ms	0ms
	17	11,680	2s402ms	0ms
	18	9,173	1s840ms	0ms
	19	7,091	1s529ms	0ms
	20	5,294	1s	0ms
	21	4,277	848ms	0ms
	22	2,137	386ms	0ms

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

Date: 2024-12-10 17:22:05 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1295) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-10 17:22:05 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (870) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-10 17:22:05 Duration: 2ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

42m43s

1m8s

422

Details

8h2m11s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 10	00	2	1ms	0ms
	01	5	6ms	1ms
	02	3	1ms	0ms
	03	2	2ms	1ms
	05	1	1ms	1ms
	06	5	5m25s	1m5s
	07	1	1ms	1ms
	08	12	9ms	0ms
	09	30	4m33s	9s126ms
	10	32	24ms	0ms
	11	29	3m8s	6s484ms
	12	50	25m30s	30s611ms
	13	34	4m41s	8s290ms
	14	36	19m15s	32s84ms
	15	25	11m46s	28s243ms
	16	22	1m24s	3s824ms
	17	30	25m51s	51s717ms
	18	27	24m29s	54s442ms
	19	18	25ms	1ms
	20	21	23m30s	1m7s
	21	10	20m27s	2m2s
	22	27	5h12m6s	11m33s

UPDATE "res_users" SET "exp_date" = '2024-12-10 21:35:36.798818', "last_update" = '2024-12-10 20:50:36.798840', "sid" = 'aaaba5359d1c9dda154478ce7b04b0f8c63f73a8', "write_date" = '2024-12-10 20:50:36.469553', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-10 22:33:20 Duration: 42m43s
UPDATE "res_users" SET "exp_date" = '2024-12-10 21:43:31.926592', "last_update" = '2024-12-10 20:58:31.926616', "sid" = 'cc56f8ecdd6122a5fbf51a046877a4ccf6a8c93b', "write_date" = '2024-12-10 20:58:31.599311', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-10 22:33:20 Duration: 34m48s
UPDATE "res_users" SET "exp_date" = '2024-12-10 21:43:38.758492', "last_update" = '2024-12-10 20:58:38.758544', "sid" = 'cc56f8ecdd6122a5fbf51a046877a4ccf6a8c93b', "write_date" = '2024-12-10 20:58:38.423409', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-10 22:33:20 Duration: 34m41s

2

0ms

9m10s

23s861ms

52

Details

20m40s

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 10	01	2	1ms	0ms
	02	1	0ms	0ms
	03	1	1ms	1ms
	08	5	0ms	0ms
	09	2	1ms	0ms
	10	6	2ms	0ms
	11	2	3ms	1ms
	12	9	9ms	1ms
	13	2	3ms	1ms
	14	3	5ms	1ms
	15	1	1ms	1ms
	17	8	18m50s	2m21s
	18	2	1ms	0ms
	19	7	1m50s	15s717ms
	22	1	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-10 17:08:04.923853', "last_update" = '2024-12-10 16:23:04.923874', "write_date" = '2024-12-10 16:23:04.596114', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-10 17:32:15 Duration: 9m10s
UPDATE "res_users" SET "exp_date" = '2024-12-10 17:08:43.574331', "last_update" = '2024-12-10 16:23:43.574353', "write_date" = '2024-12-10 16:23:43.236396', "write_uid" = 1 WHERE id IN (1357);

Date: 2024-12-10 17:32:15 Duration: 8m31s
UPDATE "res_users" SET "exp_date" = '2024-12-10 18:44:31.138182', "last_update" = '2024-12-10 17:59:31.138204', "write_date" = '2024-12-10 17:59:30.793485', "write_uid" = 1 WHERE id IN (970);

Date: 2024-12-10 19:01:21 Duration: 1m50s

3

0ms

1h

4s935ms

87,861

Details

5d27m

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 10	00	647	2h59m56s	16s686ms
	01	698	146ms	0ms
	02	872	180ms	0ms
	03	802	175ms	0ms
	04	705	147ms	0ms
	05	811	170ms	0ms
	06	646	6h34m23s	36s630ms
	07	508	108ms	0ms
	08	1,787	384ms	0ms
	09	5,546	3h25m49s	2s226ms
	10	5,248	4h46m25s	3s274ms
	11	8,394	13h30m44s	5s795ms
	12	9,357	10h28m24s	4s29ms
	13	7,669	5h56m26s	2s788ms
	14	8,904	12h35m56s	5s93ms
	15	7,654	4h27m53s	2s100ms
	16	7,550	10h56m26s	5s216ms
	17	5,702	8h48m8s	5s557ms
	18	5,025	8h26m20s	6s45ms
	19	4,191	8h22m8s	7s188ms
	20	2,315	9h28m55s	14s745ms
	21	1,810	7h5m51s	14s116ms
	22	1,020	2h33m6s	9s6ms

update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:21.866390', exp_date = '2024-12-09 22:59:21.866392', logged_in = 'TRUE' where id = 932;

Date: 2024-12-10 00:14:22 Duration: 1h
update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:21.866235', exp_date = '2024-12-09 22:59:21.866237', logged_in = 'TRUE' where id = 932;

Date: 2024-12-10 00:14:22 Duration: 1h
update res_users set sid = '1ce8eeb08a8b0d3571ae79a21c833f32cd216420', last_update = '2024-12-09 22:14:26.435793', exp_date = '2024-12-09 22:59:26.435795', logged_in = 'TRUE' where id = 932;

Date: 2024-12-10 00:14:22 Duration: 59m55s

4

0ms

6s878ms

3s513ms

371

Details

21m43s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 10	01	12	37s951ms	3s162ms
	06	4	12s973ms	3s243ms
	09	5	14s615ms	2s923ms
	10	7	24s217ms	3s459ms
	11	16	59s898ms	3s743ms
	12	15	1m7s	4s486ms
	13	24	1m26s	3s621ms
	14	40	2m29s	3s748ms
	15	36	2m10s	3s629ms
	16	22	1m16s	3s483ms
	17	36	2m6s	3s520ms
	18	21	1m17s	3s687ms
	19	13	49s256ms	3s788ms
	20	59	3m9s	3s206ms
	21	53	2m54s	3s283ms
	22	8	25s667ms	3s208ms

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

Date: 2024-12-10 12:30:59 Duration: 6s878ms
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 (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) AND ("policy_number"."name"::text ilike '%91%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-10 12:30:57 Duration: 5s617ms
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 (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) AND ("policy_number"."name"::text ilike '%9136%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-10 12:30:59 Duration: 5s488ms

5

223ms

1s885ms

995ms

11,917

Details

3h17m48s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 10	00	621	10m10s	982ms
	01	694	11m23s	984ms
	02	540	8m50s	982ms
	03	103	1m41s	987ms
	04	64	1m2s	979ms
	07	19	18s330ms	964ms
	08	126	2m1s	961ms
	09	24	27s724ms	1s155ms
	10	14	14s835ms	1s59ms
	11	26	28s989ms	1s114ms
	12	29	34s194ms	1s179ms
	13	19	24s52ms	1s265ms
	14	81	1m25s	1s53ms
	15	321	5m48s	1s84ms
	16	576	10m33s	1s98ms
	17	827	14m12s	1s31ms
	18	1,217	20m16s	999ms
	19	2,597	45m5s	1s41ms
	20	749	10m31s	843ms
	21	2,010	32m34s	972ms
	22	1,260	19m43s	939ms

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

Date: 2024-12-10 19:39:56 Duration: 1s885ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9386009')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-10 19:43:04 Duration: 1s820ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9386022')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-10 19:40:03 Duration: 1s743ms

6

356ms

3s843ms

469ms

45,355

Details

5h55m11s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 10	00	149	1m9s	468ms
	01	124	1m1s	493ms
	02	147	1m12s	490ms
	03	196	1m33s	478ms
	04	157	1m15s	482ms
	05	365	2m46s	455ms
	06	301	2m14s	447ms
	07	303	2m13s	441ms
	08	872	6m18s	433ms
	09	2,858	21m41s	455ms
	10	3,285	24m50s	453ms
	11	3,488	28m11s	484ms
	12	4,387	36m40s	501ms
	13	4,670	37m34s	482ms
	14	3,091	25m2s	485ms
	15	3,321	26m59s	487ms
	16	3,905	31m57s	491ms
	17	3,502	27m5s	464ms
	18	3,255	24m8s	444ms
	19	2,932	22m43s	465ms
	20	2,040	14m14s	419ms
	21	1,170	8m30s	436ms
	22	837	5m46s	413ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3406539, 3408038, 3408610, 3408739, 3408764, 3408779, 3411563, 3414664, 3415080, 3420455, 3422085, 3423650, 3423752, 3423755, 3423757, 3424046, 3425030, 3425170, 3425204, 3425220, 3425514, 3425970, 3426040, 3426252, 3426321, 3426570, 3426754, 3427116, 3427270, 3427548, 3427984, 3428104, 3428555, 3428594, 3428863, 3434099, 3434993, 3436868, 3436921, 3436940, 3436981, 3436983, 3436990, 3437195, 3437624, 3437774, 3437848, 3438119, 3438190, 3442205, 3442209, 3442210)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 12:30:51 Duration: 3s843ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3416068, 3416063, 3416024, 3408058, 3408052)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 12:30:48 Duration: 3s576ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3442580, 3441180, 3441146, 3438788, 3438718, 3438207, 3437116, 3434601, 3434594, 3432682, 3428394, 3428017, 3425560, 3422989, 3422960, 3422221, 3421967, 3419891, 3417671, 3415100, 3412980, 3409868, 3408419, 3408071, 3403315, 3402959, 3378954)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:47 Duration: 3s540ms

7

366ms

2s846ms

456ms

257,961

Details

1d8h42m18s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 10	00	5,682	42m1s	443ms
	01	7,389	53m46s	436ms
	02	7,622	54m27s	428ms
	03	8,383	1h30s	433ms
	04	7,696	55m58s	436ms
	05	8,236	59m6s	430ms
	06	5,953	42m36s	429ms
	07	4,356	31m6s	428ms
	08	4,823	34m8s	424ms
	09	10,356	1h16m49s	445ms
	10	11,148	1h22m18s	443ms
	11	15,538	2h31s	465ms
	12	19,214	2h35m30s	485ms
	13	14,773	1h56m35s	473ms
	14	11,512	1h30m29s	471ms
	15	13,691	1h49m17s	478ms
	16	12,495	1h42m7s	490ms
	17	15,114	1h57m19s	465ms
	18	18,828	2h20m9s	446ms
	19	20,772	2h48m28s	486ms
	20	9,800	1h9m54s	428ms
	21	18,036	2h12m56s	442ms
	22	6,544	46m4s	422ms

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

Date: 2024-12-10 19:39:48 Duration: 2s846ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3458027)) AND (("shipping_track"."id" not in (28195751, 28195751)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:50 Duration: 2s758ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3458040)) AND (("shipping_track"."id" not in (28195838, 28195838)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-10 19:39:55 Duration: 2s651ms

8

215ms

1s754ms

313ms

22,675

Details

1h58m21s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 10	00	1,018	5m28s	323ms
	01	586	3m7s	320ms
	02	260	1m23s	322ms
	03	1,057	5m33s	315ms
	04	1,408	7m25s	316ms
	05	610	3m11s	314ms
	06	636	3m20s	314ms
	07	483	2m31s	314ms
	08	24	7s634ms	318ms
	09	23	7s368ms	320ms
	10	37	12s574ms	339ms
	11	158	54s853ms	347ms
	12	285	1m43s	361ms
	13	324	2m	371ms
	14	430	2m27s	342ms
	15	294	1m44s	356ms
	16	1,328	7m53s	356ms
	17	1,920	9m58s	311ms
	18	2,408	12m5s	301ms
	19	4,562	24m10s	317ms
	20	1,845	8m44s	284ms
	21	2,198	10m29s	286ms
	22	781	3m36s	277ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9329865')) 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-10 19:39:47 Duration: 1s754ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9319758')) 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-10 19:39:50 Duration: 1s632ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9319757')) 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-10 19:39:54 Duration: 666ms

9

173ms

842ms

291ms

22,387

Details

1h48m55s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 10	09	659	3m8s	286ms
	10	869	4m2s	278ms
	11	1,896	9m21s	296ms
	12	3,317	17m	307ms
	13	2,460	12m6s	295ms
	14	3,945	19m18s	293ms
	15	3,414	16m50s	296ms
	16	3,137	15m41s	300ms
	17	1,272	5m30s	259ms
	18	1,241	5m14s	253ms
	19	177	40s526ms	228ms

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

Date: 2024-12-10 12:30:45 Duration: 842ms
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" = '8840083')))) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:30:45 Duration: 670ms
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" = '9146790')))) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:31:11 Duration: 531ms

10

15ms

1s76ms

275ms

2,927

Details

13m26s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 10	00	2	855ms	427ms
	01	4	394ms	98ms
	02	2	776ms	388ms
	04	2	818ms	409ms
	05	2	876ms	438ms
	06	5	1s437ms	287ms
	07	7	1s853ms	264ms
	08	53	6s50ms	114ms
	09	136	33s245ms	244ms
	10	192	48s639ms	253ms
	11	292	1m25s	291ms
	12	434	2m33s	352ms
	13	374	1m46s	283ms
	14	366	1m31s	249ms
	15	307	1m29s	292ms
	16	170	53s307ms	313ms
	17	155	45s135ms	291ms
	18	117	31s164ms	266ms
	19	59	16s920ms	286ms
	20	55	16s223ms	294ms
	21	144	18s259ms	126ms
	22	49	5s470ms	111ms

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

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

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

Date: 2024-12-10 12:56:13 Duration: 986ms

11

98ms

959ms

244ms

68,132

Details

4h37m48s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 10	00	3,246	12m38s	233ms
	01	2,516	8m42s	207ms
	02	1,592	5m32s	209ms
	03	2,280	8m46s	230ms
	04	2,872	11m32s	241ms
	05	1,210	5m5s	252ms
	06	1,264	5m10s	245ms
	07	994	3m45s	227ms
	08	280	58s387ms	208ms
	09	94	25s646ms	272ms
	10	100	21s673ms	216ms
	11	354	1m19s	223ms
	12	610	2m41s	265ms
	13	670	3m4s	275ms
	14	1,006	4m6s	244ms
	15	1,205	5m17s	263ms
	16	3,736	16m7s	259ms
	17	5,355	22m23s	250ms
	18	7,161	28m	234ms
	19	14,154	1h4m11s	272ms
	20	5,126	19m38s	229ms
	21	8,297	32m38s	236ms
	22	4,010	15m18s	229ms

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-10 19:43:29 Duration: 959ms
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-10 19:43:29 Duration: 954ms
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-10 19:43:16 Duration: 894ms

12

169ms

376ms

236ms

3,408

Details

13m24s

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

Day	Hour	Count	Duration	Avg duration
Dec 10	04	101	22s601ms	223ms
	05	312	1m12s	231ms
	06	21	4s658ms	221ms
	07	923	3m30s	228ms
	08	7	1s607ms	229ms
	09	3	742ms	247ms
	11	105	25s301ms	240ms
	12	152	38s895ms	255ms
	13	207	52s635ms	254ms
	14	236	57s417ms	243ms
	15	506	2m7s	252ms
	16	404	1m43s	255ms
	17	37	7s645ms	206ms
	18	28	5s841ms	208ms
	19	189	41s630ms	220ms
	22	177	32s270ms	182ms

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" = '8946327')) 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-10 15:08:37 Duration: 376ms
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" = '8962960')) 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-10 13:38:22 Duration: 329ms
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" = '9175569')) 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-10 12:01:59 Duration: 325ms

13

168ms

377ms

235ms

11,486

Details

45m9s

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 10	01	41	9s396ms	229ms
	02	178	41s381ms	232ms
	03	130	29s807ms	229ms
	04	195	43s412ms	222ms
	05	561	2m6s	226ms
	06	900	3m23s	226ms
	07	416	1m33s	225ms
	08	896	3m22s	225ms
	09	1,592	6m20s	238ms
	10	588	2m19s	238ms
	11	605	2m32s	252ms
	12	736	3m7s	255ms
	13	352	1m29s	253ms
	14	651	2m40s	245ms
	15	614	2m33s	250ms
	16	1,269	5m26s	257ms
	17	495	2m6s	254ms
	18	237	46s699ms	197ms
	19	309	1m2s	203ms
	20	240	44s166ms	184ms
	21	216	41s118ms	190ms
	22	265	48s169ms	181ms

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" = '9253058')) 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-10 12:42:55 Duration: 377ms
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" = '9269865')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (14, 15, 16, 17, 18)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17, 14, 74, 70, 11, 62)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17, 14, 74, 70, 11, 62))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17, 14, 74, 70, 11, 62))))) 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-10 19:43:08 Duration: 345ms
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" = '9193594')) 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 (9)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) 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-10 17:15:45 Duration: 343ms

14

163ms

1s734ms

233ms

105,107

Details

6h48m49s

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

Day	Hour	Count	Duration	Avg duration
Dec 10	00	574	2m8s	224ms
	01	1,547	5m49s	226ms
	02	2,436	9m13s	227ms
	03	2,758	10m22s	225ms
	04	2,047	7m42s	225ms
	05	2,611	9m54s	227ms
	06	1,606	6m2s	225ms
	07	2,577	9m51s	229ms
	08	1,445	5m26s	225ms
	09	2,971	11m59s	242ms
	10	2,308	9m1s	234ms
	11	4,103	16m54s	247ms
	12	7,753	34m31s	267ms
	13	6,791	28m24s	251ms
	14	9,492	39m1s	246ms
	15	12,371	51m20s	248ms
	16	9,542	40m6s	252ms
	17	6,564	23m23s	213ms
	18	7,731	25m11s	195ms
	19	11,860	43m54s	222ms
	20	4,486	13m44s	183ms
	21	1,006	3m6s	184ms
	22	528	1m35s	181ms

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

Date: 2024-12-10 12:30:49 Duration: 1s734ms
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" = '8813820')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-10 12:30:56 Duration: 1s552ms
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" = '8783679')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-10 12:30:50 Duration: 1s470ms

15

171ms

271ms

226ms

12,968

Details

48m59s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 10	00	574	2m8s	224ms
	01	1,500	5m39s	226ms
	02	2,240	8m28s	227ms
	03	2,629	9m52s	225ms
	04	1,719	6m28s	226ms
	05	1,727	6m33s	227ms
	06	686	2m34s	225ms
	07	1,237	4m46s	231ms
	08	542	2m2s	226ms
	09	60	13s765ms	229ms
	22	54	9s798ms	181ms

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

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

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

Date: 2024-12-10 02:03:36 Duration: 269ms

16

120ms

972ms

147ms

6,116

Details

15m2s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 10	00	36	4s752ms	132ms
	08	72	9s611ms	133ms
	09	608	1m26s	142ms
	10	754	1m44s	139ms
	11	1,076	2m38s	147ms
	12	839	2m11s	156ms
	13	818	2m	147ms
	14	375	54s813ms	146ms
	15	437	1m5s	149ms
	16	416	1m3s	152ms
	17	202	30s735ms	152ms
	18	99	14s360ms	145ms
	19	220	34s817ms	158ms
	20	127	17s406ms	137ms
	21	33	4s622ms	140ms
	22	4	545ms	136ms

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

Date: 2024-12-10 12:30:59 Duration: 972ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 60)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

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

Date: 2024-12-10 12:31:07 Duration: 284ms

17

75ms

541ms

97ms

19,824

Details

32m13s

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 10	01	65	5s324ms	81ms
	05	17	1s553ms	91ms
	06	20	1s830ms	91ms
	07	20	1s764ms	88ms
	08	202	18s37ms	89ms
	09	917	1m24s	92ms
	10	1,668	2m28s	88ms
	11	1,558	2m26s	94ms
	12	1,707	2m49s	99ms
	13	2,596	4m5s	94ms
	14	2,420	3m46s	93ms
	15	2,374	3m44s	94ms
	16	1,314	2m7s	97ms
	17	992	1m44s	105ms
	18	1,076	1m58s	109ms
	19	865	1m41s	117ms
	20	658	1m7s	103ms
	21	731	1m17s	106ms
	22	624	1m1s	98ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7769225)) AND (("cash_track"."id" not in (5365620, 5376701, 5382338, 5539134, 5539134)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-10 12:30:48 Duration: 541ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7783078)) AND (("cash_track"."id" not in (5457419, 5470554, 5474215, 5539131, 5539131)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-10 12:30:47 Duration: 525ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7789401)) AND (("cash_track"."id" not in (5495242, 5506439, 5514095, 5539130, 5539130)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-10 12:30:46 Duration: 479ms

18

28ms

233ms

45ms

155,009

Details

1h57m23s

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

Day	Hour	Count	Duration	Avg duration
Dec 10	00	2,760	2m2s	44ms
	01	3,117	2m19s	44ms
	02	2,618	1m57s	44ms
	03	2,916	2m10s	44ms
	04	2,420	1m48s	44ms
	05	2,340	1m45s	44ms
	06	1,703	1m16s	45ms
	07	1,709	1m16s	44ms
	08	1,773	1m19s	45ms
	09	7,266	5m41s	47ms
	10	8,920	6m56s	46ms
	11	11,123	9m1s	48ms
	12	14,831	12m30s	50ms
	13	12,176	9m58s	49ms
	14	9,011	7m20s	48ms
	15	11,103	9m9s	49ms
	16	9,404	7m50s	49ms
	17	10,779	7m52s	43ms
	18	9,749	6m16s	38ms
	19	12,132	8m11s	40ms
	20	6,336	3m53s	36ms
	21	6,822	4m18s	37ms
	22	4,001	2m25s	36ms

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

Date: 2024-12-10 12:30:55 Duration: 233ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3393326, 3392538)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-10 12:30:47 Duration: 217ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3406539)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-10 12:30:47 Duration: 191ms

19

31ms

213ms

42ms

51,915

Details

37m6s

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

Day	Hour	Count	Duration	Avg duration
Dec 10	05	51	2s31ms	39ms
	06	7	301ms	43ms
	07	16	670ms	41ms
	08	128	5s229ms	40ms
	09	573	24s80ms	42ms
	10	1,511	1m2s	41ms
	11	3,174	2m15s	42ms
	12	6,811	5m	44ms
	13	5,977	4m17s	43ms
	14	6,298	4m26s	42ms
	15	8,516	6m6s	43ms
	16	4,350	3m10s	43ms
	17	9,099	6m26s	42ms
	18	2,533	1m46s	41ms
	19	1,733	1m16s	43ms
	20	812	33s849ms	41ms
	21	179	7s641ms	42ms
	22	147	5s932ms	40ms

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

Date: 2024-12-10 12:30:44 Duration: 213ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3335449) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:30:52 Duration: 201ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3357449) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:30:44 Duration: 171ms

20

29ms

151ms

38ms

20,194

Details

13m5s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 10	10	468	16s957ms	36ms
	11	1,452	56s248ms	38ms
	12	3,263	2m9s	39ms
	13	2,459	1m35s	38ms
	14	3,441	2m12s	38ms
	15	3,617	2m22s	39ms
	16	2,152	1m24s	39ms
	17	1,904	1m13s	38ms
	18	1,153	43s181ms	37ms
	19	285	11s439ms	40ms

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

Date: 2024-12-10 12:30:44 Duration: 151ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 2637781) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:51:40 Duration: 73ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 2620793) ORDER BY "collection_policy"."id";

Date: 2024-12-10 12:51:41 Duration: 65ms

Time consuming prepare


Date: 2024-12-10 19:32:22
Duration: 3ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 1ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 1ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 0ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 1ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 0ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 0ms
Database: postgres

Time consuming bind


Date: 2024-12-10 14:58:02
Duration: 1ms
Database: postgres
Date: 2024-12-10 11:57:47
Duration: 0ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 1ms
Database: postgres
Date: 2024-12-10 18:08:20
Duration: 0ms
Database: postgres
Date: 2024-12-10 17:22:07
Duration: 0ms
Database: postgres
Date: 2024-12-10 11:57:47
Duration: 0ms
Database: postgres
Date: 2024-12-10 18:14:48
Duration: 0ms
Database: postgres
Date: 2024-12-10 00:03:33
Duration: 0ms
Database: postgres
Date: 2024-12-10 14:58:03
Duration: 0ms
Database: postgres
Date: 2024-12-10 00:42:19
Duration: 0ms
Database: postgres
Date: 2024-12-10 05:37:10
Duration: 0ms
Database: postgres
Date: 2024-12-10 13:20:40
Duration: 0ms
Database: postgres
Date: 2024-12-10 05:37:10
Duration: 0ms
Database: postgres
Date: 2024-12-10 02:03:19
Duration: 0ms
Database: postgres
Date: 2024-12-10 05:26:28
Duration: 0ms
Database: postgres
Date: 2024-12-10 12:44:33
Duration: 0ms
Database: postgres
Date: 2024-12-10 15:58:25
Duration: 6ms
Database: postgres
Date: 2024-12-10 12:43:25
Duration: 0ms
Database: postgres
Date: 2024-12-10 05:57:11
Duration: 1ms
Database: postgres
Date: 2024-12-10 10:27:16
Duration: 0ms
Database: postgres

Log levels

Key values

22,659,405 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	9	0.00%
DETAIL	42	0.00%
ERROR	11,412	0.05%
EVENTLOG	2,717	0.01%
FATAL	2,124	0.01%
HINT	6	0.00%
LOG	22,631,664	99.88%
STATEMENT	11,431	0.05%

Events distribution (except queries)

Key values

0 PANIC entries
2124 FATAL entries
11412 ERROR entries
0 WARNING entries
2717 EVENTLOG entries

Most Frequent Errors/Events

Key values

5,852 Max number of times the same event was reported
16,253 Total events found

Rank

Times reported

Error

1

5,852

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 10	00	24
	01	43
	02	6
	03	12
	04	9
	05	13
	06	15
	07	10
	08	69
	09	215
	10	131
	11	700
	12	610
	13	616
	14	1,029
	15	536
	16	607
	17	567
	18	304
	19	161
	20	73
	21	80
	22	22

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

5,516

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 10	00	20
	01	30
	02	5
	03	6
	04	7
	05	9
	06	14
	07	10
	08	67
	09	207
	10	125
	11	678
	12	561
	13	581
	14	960
	15	508
	16	586
	17	547
	18	289
	19	137
	20	71
	21	78
	22	20

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,956

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 10	00	1
	06	57
	09	81
	10	26
	11	204
	12	157
	13	148
	14	241
	15	75
	16	215
	17	275
	18	239
	19	43
	20	99
	21	71
	22	24

4

1,956

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 10	00	1
	06	57
	09	81
	10	26
	11	204
	12	157
	13	148
	14	241
	15	75
	16	215
	17	275
	18	239
	19	43
	20	99
	21	71
	22	24

5

536

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 10	00	2
	06	9
	09	17
	10	6
	11	53
	12	42
	13	45
	14	49
	15	25
	16	41
	17	88
	18	53
	19	22
	20	32
	21	26
	22	26

6

224

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 10	00	1
	06	2
	09	5
	10	3
	11	26
	12	13
	13	23
	14	20
	15	10
	16	21
	17	37
	18	19
	19	10
	20	17
	21	15
	22	2

7

100

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 10	17	100

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

8

19

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 10	13	16
	14	3

FATAL: password authentication failed for user "postgres"

9

17

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 10	09	2
	11	6
	12	1
	13	1
	14	3
	15	1
	16	1
	17	2

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

10

16

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 10	17	16

11

15

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 10	17	15

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

12

14

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 10	00	2
	11	4
	12	1
	13	2
	14	1
	16	3
	22	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 300

13

8

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 10	10	1
	15	1
	16	1
	17	2
	19	1
	21	1
	22	1

14

6

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 10	14	2
	15	1
	16	1
	18	2

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

15

3

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 10	17	3

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

16

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 10	02	1
	15	1
	19	1

17

2

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 10	20	2

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

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 10	02	1
	19	1

19

2

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 10	17	2

20

2

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 10	02	1
	19	1

21

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 10	19	1

ERROR: could not serialize access due to concurrent delete

22

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 10	17	1

23

1

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 10	20	1

ERROR: column change_password_user.is_session does not exist at character 461

24

1

Details

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

Times Reported Most Frequent Error / Event #24

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