pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Jan 12 23:47:38 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 48,185,337 log entries in 2m37s
Log start from 2025-01-12 00:00:00 to 2025-01-12 22:45:01

Global Stats

20,661 Number of unique normalized queries
20,528,411 Number of queries
5d14h11m36s Total query duration
2025-01-12 00:00:00 First query
2025-01-12 22:45:01 Last query
5,750 queries/s at 2025-01-12 10:58:12 Query peak

5d14h11m36s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
5d14h11m36s Execute total duration

5,231 Number of events
22 Number of unique normalized events
1,919 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
20,528,411 Average queries per session
5d14h11m36s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

5,750 queries/s Query Peak
2025-01-12 10:58:12 Date

SELECT Traffic

Key values

3,804 queries/s Query Peak
2025-01-12 10:58:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,331 queries/s Query Peak
2025-01-12 10:58:12 Date

Queries duration

Key values

5d14h11m36s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 12	00	258,784	0ms	59m59s	56ms	2m37s	3m17s	2h47m36s
	01	256,883	0ms	59m56s	41ms	3m47s	4m22s	1h47s
	02	218,876	0ms	980ms	23ms	2m35s	2m50s	4m36s
	03	223,210	0ms	45s768ms	25ms	3m5s	4m6s	4m15s
	04	235,598	0ms	3s880ms	25ms	2m55s	3m23s	3m37s
	05	164,976	0ms	692ms	26ms	2m22s	2m56s	3m33s
	06	211,226	0ms	2m21s	17ms	1m53s	1m56s	3m54s
	07	144,884	0ms	4s433ms	14ms	1m15s	1m31s	2m1s
	08	390,068	0ms	11s551ms	8ms	2m2s	3m6s	3m51s
	09	1,114,934	0ms	9m36s	19ms	5m52s	7m24s	1h52m1s
	10	1,492,696	0ms	22m53s	28ms	7m11s	7m54s	5h55m59s
	11	1,529,462	0ms	27s814ms	10ms	6m28s	8m9s	8m32s
	12	1,768,019	0ms	25m10s	33ms	7m13s	2h40m26s	6h19m34s
	13	1,609,328	0ms	16m56s	24ms	10m27s	1h16m33s	2h54m40s
	14	1,283,963	0ms	19m5s	22ms	5m3s	6m12s	3h57m1s
	15	1,385,138	0ms	57m50s	44ms	5m32s	1h9m36s	11h22m6s
	16	1,329,148	0ms	15m9s	29ms	6m12s	8m34s	3h34m27s
	17	2,320,860	0ms	17m48s	13ms	7m6s	8m10s	2h50m10s
	18	1,849,401	0ms	15m52s	17ms	9m30s	12m16s	3h7m56s
	19	1,531,167	0ms	1m46s	17ms	11m26s	12m14s	19m7s
	20	583,374	0ms	1m48s	29ms	10m6s	10m56s	12m18s
	21	422,451	0ms	4s578ms	27ms	4m58s	5m14s	6m8s
	22	203,965	0ms	27s460ms	12ms	2m15s	2m43s	3m1s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 12	00	140,966	32ms	1m56s	2m31s	3m16s
	01	132,783	52ms	2m47s	3m43s	4m21s
	02	109,921	46ms	2m4s	2m35s	4m
	03	113,977	49ms	2m21s	3m5s	4m5s
	04	123,277	49ms	2m39s	2m55s	3m25s
	05	82,275	53ms	1m43s	2m22s	2m58s
	06	114,561	31ms	1m33s	1m50s	1m56s
	07	78,427	27ms	1m2s	1m15s	1m31s
	08	233,748	13ms	1m22s	2m1s	3m45s
	09	679,625	16ms	4m8s	5m39s	6m19s
	10	905,114	17ms	5m34s	6m52s	7m36s
	11	921,083	16ms	5m25s	6m27s	8m25s
	12	1,123,673	15ms	6m18s	7m	7m23s
	13	997,235	19ms	7m41s	9m25s	10m27s
	14	759,224	14ms	4m2s	4m48s	5m29s
	15	854,079	12ms	4m14s	4m49s	5m31s
	16	791,628	17ms	4m49s	5m26s	7m20s
	17	1,381,875	9ms	5m46s	6m46s	8m
	18	1,107,917	19ms	7m46s	9m28s	12m14s
	19	906,407	29ms	10m11s	10m56s	16m47s
	20	335,471	50ms	7m30s	10m5s	10m55s
	21	243,278	47ms	4m26s	4m58s	5m39s
	22	110,710	22ms	1m45s	2m15s	3m

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 12	00	22,497	5,181	149	0	357ms	115ms	178ms	396ms
	01	26,210	5,793	137	0	112ms	164ms	212ms	345ms
	02	16,575	4,994	145	0	0ms	111ms	140ms	208ms
	03	18,717	5,795	180	0	2ms	134ms	180ms	272ms
	04	21,234	5,079	164	0	0ms	126ms	171ms	227ms
	05	13,174	3,476	141	0	0ms	93ms	117ms	156ms
	06	14,886	3,657	142	0	7ms	95ms	133ms	182ms
	07	6,706	1,967	149	0	0ms	49ms	71ms	94ms
	08	12,362	4,474	299	0	1ms	82ms	125ms	211ms
	09	46,024	15,322	854	0	158ms	285ms	380ms	542ms
	10	67,131	18,555	752	0	307ms	402ms	498ms	729ms
	11	64,584	19,788	832	0	0ms	368ms	459ms	5s573ms
	12	77,760	21,207	982	0	416ms	443ms	625ms	2h36m16s
	13	70,703	21,819	824	1	206ms	483ms	576ms	1h13m55s
	14	49,631	16,473	534	0	259ms	283ms	378ms	26s952ms
	15	47,750	17,922	686	6	753ms	292ms	404ms	1h5m26s
	16	58,291	20,315	761	3	317ms	354ms	447ms	1m43s
	17	53,454	16,582	824	1	239ms	457ms	594ms	2s803ms
	18	76,466	23,251	763	1	115ms	518ms	732ms	1m52s
	19	80,302	27,004	500	0	5ms	600ms	722ms	1m53s
	20	51,631	19,386	449	0	2ms	445ms	561ms	21s195ms
	21	34,651	7,804	245	0	0ms	199ms	245ms	277ms
	22	11,991	2,689	168	0	2ms	105ms	141ms	210ms

Day	Hour	Percentage of prepare
Jan 12	00	0.00%
	01	0.00%
	02	0.00%
	03	0.00%
	04	0.00%
	05	0.00%
	06	0.00%
	07	0.00%
	08	0.00%
	09	0.00%
	10	0.00%
	11	0.00%
	12	0.00%
	13	0.00%
	14	0.00%
	15	0.00%
	16	0.00%
	17	0.00%
	18	0.00%
	19	0.00%
	20	0.00%
	21	0.00%
	22	0.00%

Day	Hour	Average / Second
Jan 12	00	0.00/s
	01	0.00/s
	02	0.00/s
	03	0.00/s
	04	0.00/s
	05	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	09	0.00/s
	10	0.00/s
	11	0.00/s
	12	0.00/s
	13	0.00/s
	14	0.00/s
	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s
	22	0.00/s

Day	Hour	Average Duration	Average idle time
Jan 12	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

170,054 buffers Checkpoint Peak
2025-01-12 22:31:38 Date
270.056 seconds Highest write time
0.640 seconds Sync time

Checkpoints Wal files

Key values

124 files Wal files usage Peak
2025-01-12 22:31:38 Date

Checkpoints distance

Key values

3,944.60 Mo Distance Peak
2025-01-12 22:31:38 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 12	00	91,414	3,128.52s	0.032s	3,128.589s
	01	128,186	3,239.624s	0.034s	3,239.702s
	02	127,043	3,239.571s	0.027s	3,239.64s
	03	118,524	3,239.527s	0.029s	3,239.596s
	04	134,223	3,239.621s	0.028s	3,239.691s
	05	121,098	3,239.523s	0.027s	3,239.589s
	06	100,145	3,239.657s	0.026s	3,239.726s
	07	66,471	3,029.283s	0.029s	3,029.346s
	08	89,271	2,789.54s	0.029s	2,789.606s
	09	323,836	3,239.552s	0.039s	3,239.649s
	10	510,713	3,239.501s	0.065s	3,239.649s
	11	515,215	3,238.851s	0.686s	3,239.621s
	12	586,067	3,239.501s	0.054s	3,239.658s
	13	515,157	3,239.427s	0.062s	3,239.58s
	14	385,715	3,239.618s	0.044s	3,239.737s
	15	339,077	3,239.53s	0.043s	3,239.639s
	16	409,420	3,239.557s	0.051s	3,239.677s
	17	312,661	2,886.088s	0.218s	2,886.372s
	18	346,738	3,239.461s	0.05s	3,239.588s
	19	341,712	3,239.546s	0.054s	3,239.673s
	20	280,586	3,239.494s	0.042s	3,239.6s
	21	200,929	3,239.518s	0.038s	3,239.608s
	22	237,338	2,429.711s	0.023s	2,429.792s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 12	00	0	37	3,463	0.002s	0.012s
	01	0	54	3,007	0.002s	0.012s
	02	0	52	2,632	0.002s	0.012s
	03	0	49	2,962	0.002s	0.012s
	04	0	55	2,832	0.002s	0.012s
	05	0	49	2,284	0.002s	0.012s
	06	0	40	2,494	0.002s	0.012s
	07	0	27	2,205	0.005s	0.012s
	08	0	33	3,255	0.002s	0.012s
	09	0	123	4,974	0.004s	0.012s
	10	0	201	5,302	0.004s	0.012s
	11	0	185	5,316	0.309s	0.013s
	12	0	236	5,767	0.002s	0.012s
	13	0	210	5,454	0.003s	0.012s
	14	0	160	5,280	0.004s	0.012s
	15	0	134	5,419	0.002s	0.012s
	16	0	166	5,541	0.002s	0.012s
	17	0	153	5,463	0.017s	0.012s
	18	0	141	5,301	0.006s	0.012s
	19	0	148	5,233	0.003s	0.012s
	20	0	116	4,884	0.002s	0.012s
	21	0	85	4,192	0.002s	0.012s
	22	1	150	2,819	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Jan 12	00	51,350.67 kB	136,433.67 kB
	01	73,242.67 kB	92,921.83 kB
	02	71,356.25 kB	97,933.92 kB
	03	67,181.50 kB	87,625.17 kB
	04	74,812.83 kB	96,324.17 kB
	05	67,134.08 kB	88,661.92 kB
	06	54,653.25 kB	75,024.83 kB
	07	36,265.08 kB	64,464.75 kB
	08	45,278.73 kB	62,393.55 kB
	09	168,387.00 kB	181,292.08 kB
	10	276,210.91 kB	334,022.64 kB
	11	251,465.83 kB	302,772.33 kB
	12	322,720.42 kB	351,828.50 kB
	13	287,045.58 kB	364,541.92 kB
	14	217,615.92 kB	302,143.58 kB
	15	184,035.92 kB	220,268.67 kB
	16	226,482.25 kB	285,702.67 kB
	17	224,319.80 kB	288,534.80 kB
	18	192,720.83 kB	529,661.58 kB
	19	201,571.17 kB	288,053.17 kB
	20	157,978.42 kB	247,565.67 kB
	21	116,813.17 kB	184,447.33 kB
	22	273,774.78 kB	691,291.56 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 12	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 12	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

12,247,254 Total read queries
5,622,169 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	12,247,254	59.66%
INSERT	942,730	4.59%
UPDATE	288,533	1.41%
DELETE	10,680	0.05%
COPY FROM	12	0.00%
COPY TO	0	0.00%
CTE	33,103	0.16%
DDL	1,416	0.01%
TCL	4,345,695	21.17%
CURSOR	0	0.00%
OTHERS	2,658,988	12.95%

Queries by database

Key values

unknown Main database
20,528,411 Requests
5d14h11m36s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	20,528,411	5d14h11m36s
	copy from	12	14ms
	cte	33,103	7s318ms
	ddl	1,416	193ms
	delete	10,680	52s698ms
	insert	942,730	4m59s
	others	2,658,988	2m16s
	select	12,247,254	2d21h22m7s
	tcl	4,345,695	2m50s
	update	288,533	2d16h38m22s

Queries by user

Key values

unknown Main user
20,528,411 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	20,528,411	5d14h11m36s
	copy from	12	14ms
	cte	33,103	7s318ms
	ddl	1,416	193ms
	delete	10,680	52s698ms
	insert	942,730	4m59s
	others	2,658,988	2m16s
	select	12,247,254	2d21h22m7s
	tcl	4,345,695	2m50s
	update	288,533	2d16h38m22s

Duration by user

Key values

5d14h11m36s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	20,528,411	5d14h11m36s
	copy from	12	14ms
	cte	33,103	7s318ms
	ddl	1,416	193ms
	delete	10,680	52s698ms
	insert	942,730	4m59s
	others	2,658,988	2m16s
	select	12,247,254	2d21h22m7s
	tcl	4,345,695	2m50s
	update	288,533	2d16h38m22s

Queries by host

Key values

unknown Main host
20,528,411 Requests
5d14h11m36s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	20,528,411	5d14h11m36s
	copy from	12	14ms
	cte	33,103	7s318ms
	ddl	1,416	193ms
	delete	10,680	52s698ms
	insert	942,730	4m59s
	others	2,658,988	2m16s
	select	12,247,254	2d21h22m7s
	tcl	4,345,695	2m50s
	update	288,533	2d16h38m22s

Queries by application

Key values

unknown Main application
20,528,411 Requests
5d14h11m36s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	20,528,411	5d14h11m36s
	copy from	12	14ms
	cte	33,103	7s318ms
	ddl	1,416	193ms
	delete	10,680	52s698ms
	insert	942,730	4m59s
	others	2,658,988	2m16s
	select	12,247,254	2d21h22m7s
	tcl	4,345,695	2m50s
	update	288,533	2d16h38m22s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-12 02:57:10 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

19,328,066 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	19,328,066	94.15%
1-5ms	306,253	1.49%
5-10ms	15,079	0.07%
10-25ms	54,955	0.27%
25-50ms	144,595	0.70%
50-100ms	90,110	0.44%
100-500ms	313,381	1.53%
500-1000ms	271,812	1.32%
1000-10000ms	3,613	0.02%
> 10000ms	547	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 22:40:33.747596', exp_date = '2025-01-11 23:25:33.747600', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-12 00:40:33 ]
2	59m59s	update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 22:40:33.747990', exp_date = '2025-01-11 23:25:33.747993', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-12 00:40:33 ]
3	59m56s	update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 23:40:33.669364', exp_date = '2025-01-12 00:25:33.669368', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-12 01:40:30 ]
4	57m50s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:12:30.587598', exp_date = '2025-01-12 13:57:30.587602', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
5	57m50s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:12:30.587598', exp_date = '2025-01-12 13:57:30.587602', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
6	46m37s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:23:42.812785', exp_date = '2025-01-12 14:08:42.812789', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
7	45m51s	update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 22:54:41.550236', exp_date = '2025-01-11 23:39:41.550240', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-12 00:40:33 ]
8	45m20s	update res_users set sid = '87f7bba9ad9d2983c514c53de47783024d951cc0', last_update = '2025-01-12 13:25:00.139623', exp_date = '2025-01-12 14:10:00.139626', logged_in = 'TRUE' where id = 887; [ Date: 2025-01-12 15:10:20 ]
9	45m20s	update res_users set sid = '87f7bba9ad9d2983c514c53de47783024d951cc0', last_update = '2025-01-12 13:25:00.139386', exp_date = '2025-01-12 14:10:00.139390', logged_in = 'TRUE' where id = 887; [ Date: 2025-01-12 15:10:20 ]
10	41m16s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:29:04.109313', exp_date = '2025-01-12 14:14:04.109317', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
11	39m52s	UPDATE "res_users" SET "exp_date" = '2025-01-12 14:15:28.268937', "last_update" = '2025-01-12 13:30:28.268958', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:30:27.881303', "write_uid" = 905 WHERE id IN (905); [ Date: 2025-01-12 15:10:20 ]
12	38m29s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:31:50.763863', exp_date = '2025-01-12 14:16:50.763867', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
13	37m8s	UPDATE "res_users" SET "exp_date" = '2025-01-12 14:18:12.077309', "last_update" = '2025-01-12 13:33:12.077330', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:33:11.730394', "write_uid" = 1 WHERE id IN (905); [ Date: 2025-01-12 15:10:20 ]
14	35m56s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:34:24.339500', exp_date = '2025-01-12 14:19:24.339502', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
15	34m24s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:35:56.072033', exp_date = '2025-01-12 14:20:56.072038', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
16	34m14s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:36:06.354101', exp_date = '2025-01-12 14:21:06.354106', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
17	33m11s	update res_users set sid = '3e168fee29c6dcb7991ba264a3a90fba8820f82c', last_update = '2025-01-12 13:37:09.375713', exp_date = '2025-01-12 14:22:09.375716', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-12 15:10:20 ]
18	31m53s	UPDATE "res_users" SET "exp_date" = '2025-01-12 14:23:27.566958', "last_update" = '2025-01-12 13:38:27.566988', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:38:27.190561', "write_uid" = 905 WHERE id IN (905); [ Date: 2025-01-12 15:10:20 ]
19	25m10s	UPDATE "res_users" SET "exp_date" = '2025-01-12 11:34:02.820997', "last_update" = '2025-01-12 10:49:02.821023', "sid" = 'd97cfe9b0ce627b06e9f9cf1ec22f006967ea24d', "write_date" = '2025-01-12 10:49:02.419548', "write_uid" = 1 WHERE id IN (836); [ Date: 2025-01-12 12:14:13 ]
20	23m56s	update res_users set sid = '7745772a05cf2d7eb7b44bffe24d40235dcdd3b9', last_update = '2025-01-12 10:50:17.411002', exp_date = '2025-01-12 11:35:17.411006', logged_in = 'TRUE' where id = 836; [ Date: 2025-01-12 12:14:13 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d10h25m14s

60,484

Details

0ms

59m59s

3s477ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 12	00	648	2h45m51s	15s356ms
	01	797	59m56s	4s513ms
	02	737	166ms	0ms
	03	758	45s946ms	60ms
	04	687	153ms	0ms
	05	507	115ms	0ms
	06	582	128ms	0ms
	07	356	78ms	0ms
	08	1,241	11s816ms	9ms
	09	4,050	1h46m33s	1s578ms
	10	5,656	7h22m10s	4s690ms
	11	5,870	16s643ms	2ms
	12	6,252	11h7m39s	6s407ms
	13	5,554	4h25m8s	2s864ms
	14	4,720	3h16m18s	2s495ms
	15	4,701	11h59m36s	9s184ms
	16	4,689	6h35m41s	5s63ms
	17	3,784	4h42m26s	4s478ms
	18	2,822	3h12m4s	4s83ms
	19	2,640	8m20s	189ms
	20	1,632	2m9s	79ms
	21	1,119	268ms	0ms
	22	682	147ms	0ms

update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 22:40:33.747596', exp_date = '2025-01-11 23:25:33.747600', logged_in = 'TRUE' where id = 933;

Date: 2025-01-12 00:40:33 Duration: 59m59s
update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 22:40:33.747990', exp_date = '2025-01-11 23:25:33.747993', logged_in = 'TRUE' where id = 933;

Date: 2025-01-12 00:40:33 Duration: 59m59s
update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 23:40:33.669364', exp_date = '2025-01-12 00:25:33.669368', logged_in = 'TRUE' where id = 933;

Date: 2025-01-12 01:40:30 Duration: 59m56s

2

1d13h22m22s

237,608

Details

478ms

4s570ms

566ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 12	00	5,377	47m46s	533ms
	01	9,413	1h22m42s	527ms
	02	6,698	58m33s	524ms
	03	6,605	58m13s	528ms
	04	8,096	1h11m	526ms
	05	6,262	54m18s	520ms
	06	4,493	39m27s	526ms
	07	2,695	23m11s	516ms
	08	3,574	30m46s	516ms
	09	11,754	1h46m5s	541ms
	10	16,312	2h33m24s	564ms
	11	14,091	2h12m22s	563ms
	12	17,460	2h46m24s	571ms
	13	15,824	2h36m17s	592ms
	14	10,142	1h31m31s	541ms
	15	8,862	1h20m27s	544ms
	16	10,959	1h41m53s	557ms
	17	10,078	1h39m1s	589ms
	18	17,483	2h59m1s	614ms
	19	20,597	3h41m10s	644ms
	20	13,460	2h9m53s	578ms
	21	14,550	2h13m32s	550ms
	22	2,823	25m17s	537ms

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

Date: 2025-01-12 19:40:58 Duration: 4s570ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4414987)) AND (("shipping_track"."id" not in (36445341, 36445341)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:41:10 Duration: 4s509ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4415008)) AND (("shipping_track"."id" not in (36445505, 36445505)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:41:30 Duration: 4s405ms

3

7h49m51s

127,697

Details

163ms

1s360ms

220ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 12	00	543	1m41s	187ms
	01	2,217	6m55s	187ms
	02	2,112	6m37s	188ms
	03	2,277	7m6s	187ms
	04	1,628	5m5s	187ms
	05	1,665	5m14s	188ms
	06	956	2m58s	186ms
	07	868	2m41s	186ms
	08	1,564	4m53s	187ms
	09	5,086	16m55s	199ms
	10	7,161	24m25s	204ms
	11	6,892	23m34s	205ms
	12	3,909	13m43s	210ms
	13	10,419	37m36s	216ms
	14	4,725	15m22s	195ms
	15	5,962	19m31s	196ms
	16	7,088	23m49s	201ms
	17	3,463	12m45s	220ms
	18	10,483	40m29s	231ms
	19	24,069	1h41m8s	252ms
	20	21,368	1h26m14s	242ms
	21	3,091	10m30s	204ms
	22	151	30s165ms	199ms

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

Date: 2025-01-12 19:41:03 Duration: 1s360ms
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" = '485102')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 19:40:54 Duration: 1s293ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9740107')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 19:41:43 Duration: 1s157ms

4

6h51m54s

42,702

Details

479ms

4s54ms

578ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 12	00	157	1m29s	567ms
	01	152	1m32s	608ms
	02	187	1m49s	587ms
	03	169	1m37s	579ms
	04	336	3m3s	547ms
	05	120	1m10s	584ms
	06	213	1m59s	561ms
	07	341	2m58s	522ms
	08	767	6m44s	527ms
	09	3,542	32m38s	552ms
	10	3,701	35m35s	577ms
	11	3,583	34m34s	578ms
	12	4,731	46m25s	588ms
	13	3,945	40m5s	609ms
	14	2,623	24m12s	553ms
	15	2,618	24m11s	554ms
	16	3,797	35m34s	562ms
	17	3,251	31m10s	575ms
	18	3,097	30m58s	600ms
	19	2,064	22m29s	653ms
	20	2,003	19m31s	584ms
	21	843	7m51s	559ms
	22	462	4m8s	537ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4414949, 4414948, 4414947, 4414946, 4414945, 4414944, 4414943, 4414942, 4414941, 4414939, 4414936, 4414934, 4414931, 4414927, 4414924, 4414920, 4414917, 4414915, 4414912, 4414910, 4414908, 4414906, 4414904, 4414902, 4414900, 4414897, 4414895, 4414894, 4414893, 4414892, 4414891, 4414890, 4414889, 4414888, 4414887, 4414886, 4414885, 4414884, 4414883, 4414882, 4414881, 4414880, 4414879, 4414878, 4414877, 4414876, 4414875, 4414874, 4414873, 4414872, 4414871, 4414870, 4414869, 4414868, 4414867, 4414866, 4414865, 4414864, 4414863, 4414862, 4414861, 4414860, 4414859, 4414858)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:40:41 Duration: 4s54ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4414472, 4414560, 4414566, 4414569, 4414563, 4414512, 4414536, 4414546, 4414522, 4414389, 4414498, 4414502, 4414398, 4414422, 4414573, 4414416, 4414485, 4414475, 4414775, 4414395, 4414378, 4414391, 4414445, 4414555, 4414427, 4414532, 4414518, 4414492, 4414461, 4414439, 4414534, 4414510, 4414410, 4414552, 4414393, 4414384, 4414487, 4414401, 4414514, 4414382, 4414506, 4414516, 4414469, 4414489, 4414528, 4414482, 4414454, 4414412, 4414414, 4414371, 4414452, 4414376, 4414433, 4414524, 4414535, 4414537, 4414538, 4414540, 4414508, 4414542, 4414526, 4414544, 4414407, 4414430, 4414449, 4414458, 4414478, 4414435, 4414374, 4414495, 4414557, 4414380, 4414550, 4414548, 4414554, 4414520, 4414530, 4414571, 4414419, 4414504, 4414404, 4414467, 4414442, 4414387, 4414425)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:40:13 Duration: 3s857ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4404017, 4400194, 4398149, 4395938, 4389128, 4386798, 4386468, 4378364, 4353097, 4316573)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:40:34 Duration: 3s608ms

5

6h2m36s

325

Details

0ms

39m52s

1m6s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 12	00	6	1ms	0ms
	01	2	1ms	0ms
	02	1	0ms	0ms
	04	2	1ms	0ms
	05	2	0ms	0ms
	06	2	0ms	0ms
	08	7	1ms	0ms
	09	42	56m50s	1m21s
	10	31	27ms	0ms
	11	29	8ms	0ms
	12	23	25m10s	1m5s
	13	39	54m44s	1m24s
	14	33	1h31m5s	2m45s
	15	35	1h52m42s	3m13s
	16	24	22m1s	55s72ms
	17	9	15ms	1ms
	18	3	3ms	1ms
	19	17	20ms	1ms
	20	7	3ms	0ms
	21	7	1ms	0ms
	22	4	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-12 14:15:28.268937', "last_update" = '2025-01-12 13:30:28.268958', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:30:27.881303', "write_uid" = 905 WHERE id IN (905);

Date: 2025-01-12 15:10:20 Duration: 39m52s
UPDATE "res_users" SET "exp_date" = '2025-01-12 14:18:12.077309', "last_update" = '2025-01-12 13:33:12.077330', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:33:11.730394', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-12 15:10:20 Duration: 37m8s
UPDATE "res_users" SET "exp_date" = '2025-01-12 14:23:27.566958', "last_update" = '2025-01-12 13:38:27.566988', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:38:27.190561', "write_uid" = 905 WHERE id IN (905);

Date: 2025-01-12 15:10:20 Duration: 31m53s

6

3h2m16s

43,818

Details

92ms

834ms

249ms

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
Jan 12	00	2,570	8m54s	208ms
	01	2,184	7m59s	219ms
	02	1,198	4m33s	228ms
	03	1,972	7m5s	215ms
	04	1,732	6m6s	211ms
	05	693	2m47s	241ms
	06	1,637	5m59s	219ms
	07	304	1m10s	231ms
	08	120	19s506ms	162ms
	09	46	12s442ms	270ms
	10	254	54s667ms	215ms
	11	270	1m	225ms
	12	362	1m22s	227ms
	13	620	2m40s	259ms
	14	1,340	5m27s	244ms
	15	1,369	5m20s	234ms
	16	2,006	8m20s	249ms
	17	3,686	15m15s	248ms
	18	6,931	32m55s	284ms
	19	6,990	32m39s	280ms
	20	3,398	14m29s	255ms
	21	3,366	13m47s	245ms
	22	770	2m54s	226ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-12 18:39:12 Duration: 834ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عماد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-12 19:41:32 Duration: 822ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'شريف')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-12 19:41:36 Duration: 820ms

7

2h8m19s

8,052

Details

22ms

1s914ms

956ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 12	00	412	6m5s	887ms
	01	140	2m4s	891ms
	02	177	2m38s	897ms
	03	437	6m27s	887ms
	04	310	4m38s	899ms
	09	3	85ms	28ms
	10	59	56s816ms	962ms
	11	8	7s621ms	952ms
	12	65	1m	932ms
	13	239	3m49s	958ms
	14	205	3m11s	932ms
	15	210	3m14s	924ms
	16	283	4m26s	943ms
	17	1,006	17m34s	1s48ms
	18	1,615	26m54s	999ms
	19	1,596	26m26s	994ms
	20	345	5m47s	1s8ms
	21	699	9m8s	784ms
	22	243	3m44s	925ms

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

Date: 2025-01-12 19:41:53 Duration: 1s914ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9849968')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 19:41:49 Duration: 1s897ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9561569')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 18:39:08 Duration: 1s718ms

8

2h1m50s

26,309

Details

170ms

540ms

277ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 12	08	346	1m22s	237ms
	09	1,340	5m51s	261ms
	10	2,350	10m52s	277ms
	11	4,453	20m34s	277ms
	12	1,222	5m45s	282ms
	13	5,957	28m3s	282ms
	14	2,182	9m18s	256ms
	15	2,558	11m9s	261ms
	16	2,344	10m26s	267ms
	17	1,972	10m11s	309ms
	18	649	3m30s	324ms
	19	157	1m3s	402ms
	20	525	2m33s	291ms
	21	254	1m7s	267ms

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

Date: 2025-01-12 19:03:58 Duration: 540ms
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" = '9514998')))) ORDER BY "collection_policy"."id";

Date: 2025-01-12 18:43:34 Duration: 533ms
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" = '7862339')))) ORDER BY "collection_policy"."id";

Date: 2025-01-12 20:21:17 Duration: 532ms

9

1h45m47s

135,500

Details

33ms

294ms

46ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 12	00	2,605	1m47s	41ms
	01	3,331	2m18s	41ms
	02	2,061	1m26s	41ms
	03	2,277	1m34s	41ms
	04	2,742	1m54s	41ms
	05	1,499	1m2s	41ms
	06	1,734	1m12s	41ms
	07	1,049	43s938ms	41ms
	08	1,621	1m8s	42ms
	09	7,639	5m32s	43ms
	10	12,505	9m25s	45ms
	11	11,613	8m43s	45ms
	12	14,063	10m40s	45ms
	13	12,454	9m47s	47ms
	14	7,950	5m42s	43ms
	15	7,316	5m15s	43ms
	16	8,863	6m30s	44ms
	17	6,951	5m59s	51ms
	18	8,378	7m43s	55ms
	19	8,268	8m	58ms
	20	4,938	4m27s	54ms
	21	3,642	3m8s	51ms
	22	2,001	1m41s	50ms

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

Date: 2025-01-12 17:22:10 Duration: 294ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4405984)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-12 18:39:12 Duration: 240ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4353097)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-12 19:41:06 Duration: 237ms

10

1h8m51s

14,134

Details

213ms

2s46ms

292ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 12	00	885	3m45s	255ms
	01	964	4m13s	263ms
	02	428	1m50s	257ms
	03	561	2m27s	262ms
	04	568	2m26s	258ms
	05	356	1m34s	264ms
	06	822	3m32s	258ms
	07	159	41s184ms	259ms
	08	62	16s21ms	258ms
	09	25	6s858ms	274ms
	10	69	20s280ms	293ms
	11	132	37s175ms	281ms
	12	117	31s682ms	270ms
	13	79	23s275ms	294ms
	14	476	2m15s	284ms
	15	480	2m6s	263ms
	16	736	3m20s	271ms
	17	869	4m17s	296ms
	18	1,883	10m14s	326ms
	19	1,930	11m7s	345ms
	20	1,371	7m13s	316ms
	21	1,014	4m45s	281ms
	22	148	43s544ms	294ms

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

Date: 2025-01-12 19:41:32 Duration: 2s46ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9834980')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 18:39:14 Duration: 1s874ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9856339')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 19:41:02 Duration: 1s770ms

11

44m23s

49,877

Details

39ms

302ms

53ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 12	00	10	491ms	49ms
	02	20	989ms	49ms
	03	7	359ms	51ms
	04	31	1s483ms	47ms
	06	13	639ms	49ms
	07	5	250ms	50ms
	08	686	33s113ms	48ms
	09	2,553	2m7s	49ms
	10	4,070	3m32s	52ms
	11	4,005	3m29s	52ms
	12	4,911	4m22s	53ms
	13	7,529	6m45s	53ms
	14	4,907	4m2s	49ms
	15	6,914	5m42s	49ms
	16	5,927	5m1s	50ms
	17	3,062	3m8s	61ms
	18	2,700	2m56s	65ms
	19	638	44s673ms	70ms
	20	1,180	1m11s	60ms
	21	640	38s758ms	60ms
	22	69	4s66ms	58ms

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

Date: 2025-01-12 19:41:06 Duration: 302ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4358147) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-12 19:41:04 Duration: 299ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4379043) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-12 19:41:30 Duration: 298ms

12

43m44s

12,945

Details

168ms

334ms

202ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) 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
Jan 12	00	2	373ms	186ms
	01	6	1s97ms	182ms
	02	84	15s729ms	187ms
	03	320	59s295ms	185ms
	04	380	1m11s	187ms
	05	371	1m10s	190ms
	06	325	1m	186ms
	07	746	2m19s	186ms
	08	774	2m25s	187ms
	09	1,601	5m12s	195ms
	10	849	2m51s	202ms
	11	1,776	6m10s	208ms
	12	1,415	5m1s	213ms
	13	1,143	4m12s	221ms
	14	501	1m38s	196ms
	15	346	1m6s	191ms
	16	369	1m15s	204ms
	17	349	1m10s	202ms
	18	213	45s127ms	211ms
	19	336	1m17s	230ms
	20	323	1m9s	216ms
	21	565	1m57s	207ms
	22	151	30s208ms	200ms

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" = '9817386')) 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: 2025-01-12 20:23:10 Duration: 334ms
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" = '9817156')) 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: 2025-01-12 19:23:51 Duration: 327ms
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" = '9815961')) 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 (76)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 10:51:50 Duration: 325ms

13

38m44s

18,561

Details

92ms

716ms

125ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 12	00	220	25s437ms	115ms
	01	29	3s281ms	113ms
	02	10	1s292ms	129ms
	03	42	5s216ms	124ms
	04	23	2s901ms	126ms
	08	206	25s91ms	121ms
	09	1,176	2m28s	126ms
	10	1,153	2m30s	130ms
	11	2,047	4m21s	127ms
	12	2,667	5m48s	130ms
	13	2,138	4m50s	135ms
	14	1,463	2m59s	122ms
	15	1,781	3m40s	123ms
	16	1,433	2m59s	125ms
	17	1,143	2m16s	119ms
	18	1,553	2m53s	111ms
	19	730	1m27s	119ms
	20	586	1m7s	114ms
	21	92	10s123ms	110ms
	22	69	7s241ms	104ms

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

Date: 2025-01-12 19:41:26 Duration: 716ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7974948)) AND (("cash_track"."id" not in (6888364)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-12 19:41:32 Duration: 237ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7974693)) AND (("cash_track"."id" not in (6885817)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-12 18:39:16 Duration: 230ms

14

28m59s

9,262

Details

164ms

226ms

187ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 12	00	541	1m41s	187ms
	01	2,047	6m23s	187ms
	02	2,028	6m22s	188ms
	03	1,957	6m7s	187ms
	04	1,244	3m53s	187ms
	05	1,199	3m45s	188ms
	06	246	46s97ms	187ms

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

Date: 2025-01-12 03:16:16 Duration: 220ms

15

16m17s

20,558

Details

36ms

89ms

47ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 12	08	265	11s129ms	41ms
	09	916	41s509ms	45ms
	10	1,847	1m25s	46ms
	11	1,482	1m9s	47ms
	12	2,448	1m53s	46ms
	13	3,533	2m50s	48ms
	14	2,181	1m36s	44ms
	15	2,261	1m40s	44ms
	16	2,538	1m53s	44ms
	17	1,206	1m7s	56ms
	18	1,003	57s971ms	57ms
	19	139	8s356ms	60ms
	20	477	26s297ms	55ms
	21	261	14s884ms	57ms
	22	1	51ms	51ms

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

Date: 2025-01-12 11:40:57 Duration: 89ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4235138) ORDER BY "collection_policy"."id";

Date: 2025-01-12 09:40:01 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4356925) ORDER BY "collection_policy"."id";

Date: 2025-01-12 13:50:50 Duration: 81ms

16

14m3s

5,649

Details

120ms

628ms

149ms

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
Jan 12	00	3	381ms	127ms
	07	10	1s311ms	131ms
	08	69	9s259ms	134ms
	09	309	43s156ms	139ms
	10	888	2m11s	148ms
	11	928	2m15s	145ms
	12	1,157	2m50s	147ms
	13	870	2m15s	155ms
	14	440	1m1s	139ms
	15	150	20s719ms	138ms
	16	181	25s783ms	142ms
	17	131	21s708ms	165ms
	18	141	24s300ms	172ms
	19	210	36s247ms	172ms
	20	117	19s102ms	163ms
	21	16	2s588ms	161ms
	22	29	4s341ms	149ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 61)) 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: 2025-01-12 17:22:10 Duration: 628ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) 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: 2025-01-12 10:51:50 Duration: 329ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) 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: 2025-01-12 12:29:09 Duration: 287ms

17

11m23s

2,633

Details

17ms

1s672ms

259ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 12	00	7	558ms	79ms
	01	6	1s631ms	271ms
	07	6	1s553ms	258ms
	08	47	12s590ms	267ms
	09	125	32s151ms	257ms
	10	292	1m1s	211ms
	11	310	1m10s	227ms
	12	316	1m23s	262ms
	13	377	1m52s	298ms
	14	268	1m12s	269ms
	15	272	1m12s	266ms
	16	224	1m	269ms
	17	186	30s573ms	164ms
	18	81	28s759ms	355ms
	19	50	19s949ms	398ms
	20	48	18s779ms	391ms
	21	7	3s67ms	438ms
	22	11	731ms	66ms

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 (60)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))) 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: 2025-01-12 19:40:25 Duration: 1s672ms
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 (48)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (48))))) 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: 2025-01-12 13:45:10 Duration: 798ms
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 (77)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77))))) 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: 2025-01-12 13:06:54 Duration: 797ms

18

10m48s

3,219

Details

170ms

299ms

201ms

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

Day	Hour	Count	Duration	Avg duration
Jan 12	04	4	746ms	186ms
	05	95	17s899ms	188ms
	06	385	1m11s	186ms
	07	122	22s673ms	185ms
	09	685	2m20s	204ms
	10	642	2m16s	212ms
	11	168	35s446ms	210ms
	14	143	27s650ms	193ms
	15	482	1m37s	201ms
	16	475	1m33s	197ms
	20	18	4s720ms	262ms

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

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

Date: 2025-01-12 10:51:50 Duration: 287ms
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" = '9594318')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 20:14:40 Duration: 277ms

19

10m16s

223

Details

15ms

4s179ms

2s764ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 12	00	10	29s390ms	2s939ms
	01	3	8s946ms	2s982ms
	09	7	21s671ms	3s95ms
	10	4	12s525ms	3s131ms
	11	8	10s213ms	1s276ms
	12	16	36s577ms	2s286ms
	13	15	35s119ms	2s341ms
	14	12	28s156ms	2s346ms
	15	16	26s593ms	1s662ms
	16	54	2m24s	2s670ms
	17	22	1m17s	3s535ms
	18	16	56s34ms	3s502ms
	19	16	53s593ms	3s349ms
	20	19	1m6s	3s497ms
	21	3	9s93ms	3s31ms
	22	2	57ms	28ms

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

Date: 2025-01-12 20:13:31 Duration: 4s179ms
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 (80))))))) 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 (80)))))) 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 (80)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (80)))))) 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 (80))))))))) 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 (80)))))))) AND ("policy_number"."name"::text ilike '%9294909%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-12 17:45:30 Duration: 4s162ms
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 (76))))))) 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 (76)))))) 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 (76)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76)))))) 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 (76))))))))) 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 (76)))))))) AND ("policy_number"."name"::text ilike '%9908651%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-12 20:17:24 Duration: 4s120ms

20

8m49s

2,724

Details

163ms

800ms

194ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 12	00	120	21s804ms	181ms
	01	120	21s997ms	183ms
	02	120	22s46ms	183ms
	03	120	21s991ms	183ms
	04	120	21s880ms	182ms
	05	120	21s943ms	182ms
	06	120	21s845ms	182ms
	07	120	21s868ms	182ms
	08	120	21s755ms	181ms
	09	120	22s944ms	191ms
	10	120	24s516ms	204ms
	11	120	24s109ms	200ms
	12	120	25s37ms	208ms
	13	120	25s114ms	209ms
	14	120	23s300ms	194ms
	15	120	23s175ms	193ms
	16	120	23s842ms	198ms
	17	114	22s912ms	200ms
	18	120	25s200ms	210ms
	19	120	27s497ms	229ms
	20	120	24s930ms	207ms
	21	120	23s376ms	194ms
	22	90	16s813ms	186ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-12 19:41:03 Duration: 800ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-12 19:41:02 Duration: 547ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-12 19:40:02 Duration: 321ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,657,858

Details

2m16s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 12	00	36,829	1s654ms	0ms
	01	37,316	1s743ms	0ms
	02	35,523	1s612ms	0ms
	03	33,798	1s625ms	0ms
	04	33,671	1s696ms	0ms
	05	26,004	1s281ms	0ms
	06	29,793	1s487ms	0ms
	07	22,753	1s39ms	0ms
	08	52,550	2s563ms	0ms
	09	139,274	7s455ms	0ms
	10	187,868	10s425ms	0ms
	11	198,594	11s454ms	0ms
	12	206,916	10s427ms	0ms
	13	198,276	9s946ms	0ms
	14	179,812	8s775ms	0ms
	15	180,211	8s607ms	0ms
	16	178,401	9s89ms	0ms
	17	308,861	14s828ms	0ms
	18	229,590	12s284ms	0ms
	19	186,638	10s675ms	0ms
	20	69,790	3s913ms	0ms
	21	53,621	2s887ms	0ms
	22	31,769	1s411ms	0ms

DISCARD ALL;

Date: 2025-01-12 11:19:29 Duration: 1ms
DISCARD ALL;

Date: 2025-01-12 01:50:13 Duration: 1ms
DISCARD ALL;

Date: 2025-01-12 11:35:48 Duration: 1ms

2

2,173,166

Details

33s90ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 12	00	26,357	423ms	0ms
	01	27,261	451ms	0ms
	02	25,825	415ms	0ms
	03	25,324	422ms	0ms
	04	26,053	435ms	0ms
	05	19,945	340ms	0ms
	06	24,073	388ms	0ms
	07	17,399	279ms	0ms
	08	42,908	637ms	0ms
	09	115,551	1s844ms	0ms
	10	155,128	2s483ms	0ms
	11	161,183	2s504ms	0ms
	12	166,034	2s497ms	0ms
	13	158,040	2s512ms	0ms
	14	137,996	2s11ms	0ms
	15	140,282	2s22ms	0ms
	16	138,646	2s79ms	0ms
	17	278,576	3s659ms	0ms
	18	204,646	3s23ms	0ms
	19	164,368	2s663ms	0ms
	20	53,012	943ms	0ms
	21	41,295	705ms	0ms
	22	23,264	344ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-12 13:20:34 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-12 19:41:33 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-12 11:34:13 Duration: 0ms

3

1,356,057

Details

14s376ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 12	00	19,252	182ms	0ms
	01	19,337	191ms	0ms
	02	18,373	178ms	0ms
	03	17,669	178ms	0ms
	04	17,440	180ms	0ms
	05	13,659	139ms	0ms
	06	15,613	156ms	0ms
	07	12,135	116ms	0ms
	08	27,535	271ms	0ms
	09	71,987	775ms	0ms
	10	96,036	1s43ms	0ms
	11	100,875	1s97ms	0ms
	12	105,097	1s145ms	0ms
	13	101,167	1s122ms	0ms
	14	91,526	907ms	0ms
	15	91,680	921ms	0ms
	16	90,658	931ms	0ms
	17	155,527	1s587ms	0ms
	18	115,880	1s289ms	0ms
	19	94,656	1s95ms	0ms
	20	35,815	407ms	0ms
	21	27,719	305ms	0ms
	22	16,421	152ms	0ms

ROLLBACK;

Date: 2025-01-12 14:23:36 Duration: 1ms
ROLLBACK;

Date: 2025-01-12 10:05:42 Duration: 1ms
ROLLBACK;

Date: 2025-01-12 12:28:03 Duration: 0ms

4

1,338,550

Details

4m15s

0ms

21ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 12	00	18,399	3s214ms	0ms
	01	18,664	3s653ms	0ms
	02	17,737	3s309ms	0ms
	03	16,842	3s178ms	0ms
	04	16,800	3s277ms	0ms
	05	12,938	2s462ms	0ms
	06	14,892	2s710ms	0ms
	07	11,372	1s793ms	0ms
	08	26,485	4s316ms	0ms
	09	70,168	14s95ms	0ms
	10	94,856	19s295ms	0ms
	11	100,085	19s504ms	0ms
	12	104,493	20s454ms	0ms
	13	100,125	20s81ms	0ms
	14	90,765	16s385ms	0ms
	15	91,007	16s539ms	0ms
	16	90,181	16s914ms	0ms
	17	154,925	27s177ms	0ms
	18	115,390	22s213ms	0ms
	19	94,118	18s670ms	0ms
	20	35,397	7s824ms	0ms
	21	26,978	5s636ms	0ms
	22	15,933	2s553ms	0ms

SELECT payload FROM http_sessions WHERE sid = '08e064c611b0657755da1a30b45185d669e6390e';

Date: 2025-01-12 18:05:46 Duration: 21ms
SELECT payload FROM http_sessions WHERE sid = 'a24c623b643e782c5898da308b0174922038601d';

Date: 2025-01-12 12:00:23 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = 'a3e062ac8c84a0272d730b8dd5b9473a1fc14473';

Date: 2025-01-12 12:57:08 Duration: 11ms

5

1,327,481

Details

2m2s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 12	00	18,431	1s549ms	0ms
	01	18,723	1s637ms	0ms
	02	17,835	1s530ms	0ms
	03	16,939	1s516ms	0ms
	04	16,907	1s526ms	0ms
	05	13,058	1s164ms	0ms
	06	14,939	1s313ms	0ms
	07	11,427	948ms	0ms
	08	26,119	2s175ms	0ms
	09	69,204	6s482ms	0ms
	10	93,612	8s999ms	0ms
	11	99,111	9s98ms	0ms
	12	103,232	9s641ms	0ms
	13	98,884	9s492ms	0ms
	14	89,792	7s909ms	0ms
	15	89,969	7s897ms	0ms
	16	89,103	8s89ms	0ms
	17	154,375	13s797ms	0ms
	18	114,832	10s884ms	0ms
	19	93,291	9s62ms	0ms
	20	34,942	3s470ms	0ms
	21	26,836	2s535ms	0ms
	22	15,920	1s281ms	0ms

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

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

Date: 2025-01-12 03:08:36 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-12 20:52:29 Duration: 1ms

6

1,035,794

Details

2m37s

0ms

20ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 12	00	8,854	1s553ms	0ms
	01	9,512	1s709ms	0ms
	02	8,739	1s597ms	0ms
	03	8,925	1s596ms	0ms
	04	10,327	1s816ms	0ms
	05	7,280	1s322ms	0ms
	06	10,491	1s695ms	0ms
	07	6,360	1s88ms	0ms
	08	19,689	2s796ms	0ms
	09	57,106	8s510ms	0ms
	10	77,755	11s984ms	0ms
	11	79,355	12s153ms	0ms
	12	79,669	12s151ms	0ms
	13	74,475	11s414ms	0ms
	14	60,952	8s967ms	0ms
	15	63,518	9s170ms	0ms
	16	63,388	9s68ms	0ms
	17	165,358	21s206ms	0ms
	18	98,842	15s61ms	0ms
	19	77,457	13s987ms	0ms
	20	21,503	4s224ms	0ms
	21	17,517	2s934ms	0ms
	22	8,722	1s339ms	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 (1066);

Date: 2025-01-12 12:34:14 Duration: 20ms
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 (873);

Date: 2025-01-12 10:26:01 Duration: 17ms
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 (1290);

Date: 2025-01-12 17:22:09 Duration: 11ms

7

816,420

Details

2m2s

0ms

39ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 12	00	7,097	1s254ms	0ms
	01	7,935	1s524ms	0ms
	02	7,448	1s526ms	0ms
	03	7,658	1s416ms	0ms
	04	8,611	1s590ms	0ms
	05	6,286	1s202ms	0ms
	06	8,463	1s433ms	0ms
	07	5,264	883ms	0ms
	08	15,373	2s255ms	0ms
	09	43,464	6s917ms	0ms
	10	59,049	10s4ms	0ms
	11	60,298	10s138ms	0ms
	12	60,850	11s414ms	0ms
	13	56,744	10s499ms	0ms
	14	46,402	7s780ms	0ms
	15	48,524	7s896ms	0ms
	16	47,911	8s43ms	0ms
	17	122,984	11s295ms	0ms
	18	88,725	9s669ms	0ms
	19	69,718	8s751ms	0ms
	20	17,191	3s368ms	0ms
	21	13,579	2s715ms	0ms
	22	6,846	1s290ms	0ms

COMMIT;

Date: 2025-01-12 14:53:42 Duration: 39ms
COMMIT;

Date: 2025-01-12 12:31:15 Duration: 31ms
COMMIT;

Date: 2025-01-12 15:23:33 Duration: 30ms

8

774,183

Details

1m35s

0ms

17ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 12	00	6,432	772ms	0ms
	01	6,425	746ms	0ms
	02	4,790	553ms	0ms
	03	5,345	590ms	0ms
	04	6,387	802ms	0ms
	05	3,633	496ms	0ms
	06	6,878	798ms	0ms
	07	3,614	476ms	0ms
	08	11,529	1s499ms	0ms
	09	35,281	5s93ms	0ms
	10	48,214	6s808ms	0ms
	11	46,823	6s492ms	0ms
	12	48,304	6s629ms	0ms
	13	42,556	6s879ms	0ms
	14	34,428	4s366ms	0ms
	15	36,012	4s919ms	0ms
	16	36,884	5s200ms	0ms
	17	157,813	15s850ms	0ms
	18	115,141	12s139ms	0ms
	19	86,546	9s992ms	0ms
	20	12,776	1s608ms	0ms
	21	12,923	2s90ms	0ms
	22	5,449	826ms	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 (5099102, 5099297, 5309049, 5099103, 5099636, 5100762, 5100658, 5471258, 5099119, 5099264, 5099137, 5107470, 5100110, 5135671, 5099128, 5102546, 5099139, 5101057, 5099501, 5099174, 5102380, 5099910, 5099287, 5099848);

Date: 2025-01-12 14:35:13 Duration: 17ms
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 (5099138, 5099006, 5119200, 5100181, 5099144, 5099103, 5467562, 5099007, 5100775, 5112405, 5100218, 5099204, 5099800, 5099321, 5099013, 5303641, 5099009, 5101246, 5188112, 5099528, 5099577, 5114904, 5099002, 5146696, 5120703, 5099187, 5108640, 5128956, 5100749, 5100669, 5156297, 5113428, 5099190, 5099206, 5100118, 5126650, 5102547, 5099008, 5102966, 5099045, 5100738, 5102295, 5099170, 5099095, 5099174, 5100980, 5099326, 5099646, 5099759, 5099102, 5099137, 5099181, 5101987, 5474264, 5099035, 5099296);

Date: 2025-01-12 17:22:09 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5129945, 5272996, 5374857, 5101298, 5099158, 5474283, 5099089, 5106438, 5100507, 5099873, 5099581, 5099517, 5100637, 5100457, 5102557, 5474272, 5108399, 5099727, 5100832, 5144954, 5099224, 5111781, 5100694, 5099027, 5099128, 5099272, 5105641, 5099139, 5099568, 5099445, 5238647, 5100194, 5099420, 5099010, 5102798, 5099740, 5474271, 5099028, 5113518, 5099867, 5099333, 5099546, 5099831, 5100443, 5100471, 5099254, 5099921, 5101726, 5100202, 5101209, 5123204, 5108339, 5100677, 5099503, 5191283, 5099639, 5103128, 5099446, 5100747, 5116279, 5101130);

Date: 2025-01-12 17:22:09 Duration: 5ms

9

684,873

Details

43s974ms

0ms

16ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 12	00	5,199	299ms	0ms
	01	4,621	254ms	0ms
	02	3,817	218ms	0ms
	03	3,837	212ms	0ms
	04	5,433	292ms	0ms
	05	2,880	154ms	0ms
	06	6,693	340ms	0ms
	07	4,364	212ms	0ms
	08	11,731	608ms	0ms
	09	33,106	2s59ms	0ms
	10	47,007	3s98ms	0ms
	11	46,432	3s28ms	0ms
	12	51,436	3s439ms	0ms
	13	43,714	3s121ms	0ms
	14	38,045	2s394ms	0ms
	15	38,151	2s425ms	0ms
	16	38,188	2s405ms	0ms
	17	118,316	6s962ms	0ms
	18	85,975	5s524ms	0ms
	19	65,764	4s833ms	0ms
	20	13,259	894ms	0ms
	21	11,357	868ms	0ms
	22	5,548	327ms	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 (5, 28, 27, 19, 30, 8, 49, 111, 6, 2, 48, 22, 85, 1);

Date: 2025-01-12 16:50:11 Duration: 16ms
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 (17, 78, 51, 52, 27, 30, 64, 16, 73, 48, 22, 65);

Date: 2025-01-12 11:34:13 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (17);

Date: 2025-01-12 19:30:25 Duration: 1ms

10

440,034

Details

1m24s

0ms

6ms

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	3,272	592ms	0ms
	01	2,763	531ms	0ms
	02	2,252	433ms	0ms
	03	2,283	431ms	0ms
	04	3,240	601ms	0ms
	05	1,822	341ms	0ms
	06	3,918	652ms	0ms
	07	2,752	440ms	0ms
	08	9,043	1s399ms	0ms
	09	25,520	4s496ms	0ms
	10	32,691	6s350ms	0ms
	11	34,059	6s298ms	0ms
	12	33,854	6s559ms	0ms
	13	32,181	6s423ms	0ms
	14	27,090	4s676ms	0ms
	15	28,525	4s957ms	0ms
	16	28,556	4s982ms	0ms
	17	65,218	13s179ms	0ms
	18	46,264	9s787ms	0ms
	19	35,515	7s813ms	0ms
	20	8,584	1s678ms	0ms
	21	6,899	1s383ms	0ms
	22	3,733	645ms	0ms

SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8004708, 8007704, 8007691, 8006299, 8007565, 8006297, 8004714, 8006405, 8007305, 8007640, 8006282, 8007026, 8006300, 8004670, 8006301, 8007174, 8007491, 8006839, 8006277, 8007485, 8006359, 8006332, 8006401, 8006291, 8007200, 8007486, 8004684, 8004685, 8006346, 8006444, 8007029, 8006838, 8007226, 8006374, 8007322, 8004716, 8006403, 8006345, 8007563, 8006936, 8006273, 8006279, 8006313);

Date: 2025-01-12 17:22:09 Duration: 6ms
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 (8006272);

Date: 2025-01-12 17:22:09 Duration: 2ms
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 (8006428);

Date: 2025-01-12 20:23:19 Duration: 2ms

11

395,389

Details

2m7s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	3,128	897ms	0ms
	01	2,093	641ms	0ms
	02	1,548	491ms	0ms
	03	1,307	414ms	0ms
	04	1,286	405ms	0ms
	05	786	243ms	0ms
	06	1,438	444ms	0ms
	07	997	288ms	0ms
	08	7,438	2s189ms	0ms
	09	25,322	8s50ms	0ms
	10	34,909	11s689ms	0ms
	11	35,223	11s523ms	0ms
	12	54,612	17s259ms	0ms
	13	41,736	14s117ms	0ms
	14	29,110	8s865ms	0ms
	15	39,187	12s3ms	0ms
	16	30,808	9s775ms	0ms
	17	26,760	8s446ms	0ms
	18	22,560	7s551ms	0ms
	19	19,162	6s852ms	0ms
	20	8,833	2s972ms	0ms
	21	4,423	1s405ms	0ms
	22	2,723	817ms	0ms

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

Date: 2025-01-12 17:22:09 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 989) OR r.global) ORDER BY r.id;

Date: 2025-01-12 10:37:05 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.office' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 847) OR r.global) ORDER BY r.id;

Date: 2025-01-12 19:40:08 Duration: 3ms

12

319,899

Details

1m20s

0ms

42ms

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	3,175	821ms	0ms
	01	2,986	757ms	0ms
	02	2,087	518ms	0ms
	03	2,562	636ms	0ms
	04	2,896	788ms	0ms
	05	1,483	458ms	0ms
	06	3,100	827ms	0ms
	07	1,636	532ms	0ms
	08	5,238	2s572ms	0ms
	09	14,309	4s19ms	0ms
	10	19,311	5s418ms	0ms
	11	19,553	4s915ms	0ms
	12	21,333	5s203ms	0ms
	13	18,825	5s386ms	0ms
	14	16,272	3s811ms	0ms
	15	17,042	3s974ms	0ms
	16	17,282	4s239ms	0ms
	17	57,722	12s156ms	0ms
	18	44,868	10s99ms	0ms
	19	33,218	8s674ms	0ms
	20	6,636	1s667ms	0ms
	21	5,909	1s920ms	0ms
	22	2,456	779ms	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 (41983114, 42042407, 41831426, 41857842, 41923383, 42027395, 41873366, 41966355, 42016314, 41923093, 41960139, 41993624, 41871208, 41772302, 41791941, 41773490, 42042428, 41925167, 41954221, 41957802, 41947046, 41723037, 42020015, 42020030, 41923347, 41945618, 41942523, 41494302, 41946835, 41863602, 41832464, 41998253, 41900830, 41902095, 41853672, 41858421, 41899060, 41787962, 41812303, 41675060, 41611138, 41951216, 41081494, 41081634, 41989878, 32652957, 41991543, 42009117, 42009115, 41773622, 42012043, 42011773, 41958363, 41698825, 41020134, 32662467, 41464083, 41464077, 41772278, 32652938, 41991474, 42020349, 42010443, 41981136, 41753488, 42019148, 41766157, 41976832, 41954883, 41954838, 41981057, 41959967, 42018836, 41941661, 41917335, 41741716, 41963025, 41873118, 41777064, 41821541, 42008737, 41958389, 41898882, 32663050, 41863770, 41460910, 42018832, 32669108, 41509459, 41631684, 41754874, 41998341, 41784580, 41859869, 41917359, 42001614, 41836191, 41857071, 41275918, 41951434, 42024763, 41832582, 41923375, 41865989, 41866246, 42012546, 41966391, 42004520, 42001552, 41981443, 41959973, 41962289, 41947201, 41947203, 41947977, 41961890, 41885247, 41999137, 41959827, 41675329, 41723137, 41920372, 41979908, 41863552, 41949856, 42014836, 41736621, 42004798, 41916491, 41922511, 41989664, 42008760, 41841471, 42018937, 42018913, 41970440);

Date: 2025-01-12 17:22:10 Duration: 42ms
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 (32651744, 42017249, 41921502, 41986731, 41976102, 42081766, 42107455, 41966916, 42042172, 42008054, 42018178, 42082273, 42077454, 41959439, 42067319, 42091710, 42067791, 42107731, 42028333, 41991887, 42066947, 41817241, 42070671, 42067497, 42067500, 42068558, 42070676, 42006565, 42007493, 42007502, 32669607, 41924574, 41925062, 41773382, 42028276, 32669608, 42022278, 41920931, 42017985, 41925072, 41817867, 41971641, 42006486, 41974617, 42091061, 42006481, 42004377, 42052820, 42047187, 41931344, 41997083, 42059651, 41983807, 41133969, 42108681, 42107670, 42045486, 42026954, 41424017, 42045945, 42045358, 42108931, 41880550, 41894630, 42015897, 42046140, 41449062, 41798493, 32667293, 42015680, 41924513, 42005299, 42108680, 41964008, 42060477, 41110846, 41854598);

Date: 2025-01-12 17:22:09 Duration: 23ms
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 (39410349, 39787026, 39410428, 32588793, 39832858, 39787766, 39788057, 39709457, 39734159, 39648385, 39603636, 39844197, 39510449, 39787274, 32579962, 39587534, 39788263, 39864399, 40051111, 40328706, 40090823, 40238021, 40316019, 39716961, 39796322, 39692230, 39510450, 40450734, 39423096, 39423100, 39422651, 39509748, 39844208, 40459324, 40111285, 39688070, 39674085, 40117003, 39385673, 39048519, 38947064, 39745054, 40160825, 39510446, 40394546, 40436782, 39423334, 39423097, 40117956, 40334086, 40329980, 40011071, 39764135, 39680666, 39759232, 32581474, 39475195, 40373492, 38706768, 39754378, 40093728, 39640732, 39790983, 39989816, 39774177, 39798340, 39795211, 39188313, 40137775, 40281144, 39898598, 40332679, 37855478, 40066467, 39710841, 40461232, 40521546, 39855234, 39858643, 39748040, 39887992, 40383315, 39878822, 40165833, 39257867, 39983281, 40149113, 40304888, 40242162, 40263025, 37894920, 39781865, 40397334, 40127974, 40159865, 39679997, 40110334, 39805153, 40109372, 39642620);

Date: 2025-01-12 17:22:16 Duration: 20ms

13

289,433

Details

53s467ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 12	00	2,748	393ms	0ms
	01	2,001	270ms	0ms
	02	1,854	247ms	0ms
	03	1,510	196ms	0ms
	04	1,201	159ms	0ms
	05	1,081	141ms	0ms
	06	1,134	164ms	0ms
	07	1,007	134ms	0ms
	08	7,563	1s101ms	0ms
	09	21,415	3s647ms	0ms
	10	24,166	4s665ms	0ms
	11	25,356	4s784ms	0ms
	12	35,825	7s309ms	0ms
	13	31,270	6s345ms	0ms
	14	20,740	3s535ms	0ms
	15	27,044	4s913ms	0ms
	16	21,565	3s825ms	0ms
	17	18,752	3s370ms	0ms
	18	15,851	3s190ms	0ms
	19	14,563	3s	0ms
	20	6,639	1s145ms	0ms
	21	4,074	624ms	0ms
	22	2,074	299ms	0ms

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

Date: 2025-01-12 17:22:09 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 854 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-12 11:52:05 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 891 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_cash_policy' AND name = 'active_unactive_policy' AND model = 'res.groups');

Date: 2025-01-12 13:51:53 Duration: 2ms

14

265,109

Details

19s798ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 12	00	1,802	112ms	0ms
	01	1,856	119ms	0ms
	02	1,464	98ms	0ms
	03	1,511	100ms	0ms
	04	1,893	129ms	0ms
	05	1,136	76ms	0ms
	06	2,205	134ms	0ms
	07	1,298	79ms	0ms
	08	4,170	264ms	0ms
	09	12,481	931ms	0ms
	10	17,241	1s345ms	0ms
	11	16,883	1s173ms	0ms
	12	17,393	1s280ms	0ms
	13	15,292	1s291ms	0ms
	14	12,559	880ms	0ms
	15	13,053	912ms	0ms
	16	13,097	966ms	0ms
	17	53,415	3s993ms	0ms
	18	38,360	3s164ms	0ms
	19	28,186	2s36ms	0ms
	20	4,030	296ms	0ms
	21	4,014	295ms	0ms
	22	1,770	116ms	0ms

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

Date: 2025-01-12 17:22:09 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-01-12 15:43:25 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-01-12 16:25:09 Duration: 0ms

15

237,608

Details

1d13h22m22s

478ms

4s570ms

566ms

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	5,377	47m46s	533ms
	01	9,413	1h22m42s	527ms
	02	6,698	58m33s	524ms
	03	6,605	58m13s	528ms
	04	8,096	1h11m	526ms
	05	6,262	54m18s	520ms
	06	4,493	39m27s	526ms
	07	2,695	23m11s	516ms
	08	3,574	30m46s	516ms
	09	11,754	1h46m5s	541ms
	10	16,312	2h33m24s	564ms
	11	14,091	2h12m22s	563ms
	12	17,460	2h46m24s	571ms
	13	15,824	2h36m17s	592ms
	14	10,142	1h31m31s	541ms
	15	8,862	1h20m27s	544ms
	16	10,959	1h41m53s	557ms
	17	10,078	1h39m1s	589ms
	18	17,483	2h59m1s	614ms
	19	20,597	3h41m10s	644ms
	20	13,460	2h9m53s	578ms
	21	14,550	2h13m32s	550ms
	22	2,823	25m17s	537ms

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

Date: 2025-01-12 19:40:58 Duration: 4s570ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4414987)) AND (("shipping_track"."id" not in (36445341, 36445341)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:41:10 Duration: 4s509ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4415008)) AND (("shipping_track"."id" not in (36445505, 36445505)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:41:30 Duration: 4s405ms

16

186,935

Details

1m41s

0ms

23ms

0ms

select "shipping_policy"."id" AS "id", "shipping_policy"."name" AS "name", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."state" AS "state", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."notes" AS "notes", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date" from "shipping_policy" where (("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))))) and "shipping_policy".id in (...);

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 12	00	366	191ms	0ms
	01	519	254ms	0ms
	02	393	189ms	0ms
	03	577	284ms	0ms
	04	301	154ms	0ms
	05	541	329ms	0ms
	06	1,961	1s83ms	0ms
	07	1,083	550ms	0ms
	08	3,067	1s656ms	0ms
	09	7,880	4s511ms	0ms
	10	11,019	6s453ms	0ms
	11	9,873	5s854ms	0ms
	12	9,284	5s407ms	0ms
	13	7,321	4s482ms	0ms
	14	5,739	3s11ms	0ms
	15	4,646	2s499ms	0ms
	16	5,800	3s251ms	0ms
	17	49,124	24s162ms	0ms
	18	35,989	19s129ms	0ms
	19	25,810	15s90ms	0ms
	20	2,857	1s735ms	0ms
	21	1,568	777ms	0ms
	22	1,217	615ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."name" AS "name", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."state" AS "state", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."notes" AS "notes", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date" FROM "shipping_policy" WHERE (("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 (44, 10)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44, 10))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44, 10))))) 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))))) AND "shipping_policy".id IN (4399153, 4398340, 4396913, 4396875, 4393732, 4393669, 4393660, 4393625, 4393597, 4392475, 4391891, 4391675, 4391448, 4391444, 4390197, 4390113, 4389633, 4389522, 4389519, 4388728, 4387713, 4386180, 4386116, 4385521, 4384745, 4384044, 4384038, 4383995, 4383971, 4383756, 4383658, 4382044, 4382039, 4379614, 4379498, 4379109, 4379101, 4378737, 4378430, 4378423, 4377465, 4376320, 4372468, 4367180, 4346454);

Date: 2025-01-12 18:05:46 Duration: 23ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."name" AS "name", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."state" AS "state", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."notes" AS "notes", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date" FROM "shipping_policy" WHERE (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (14, 15, 16, 17, 18, 28)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) 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))))) AND "shipping_policy".id IN (4387737, 4380889, 4391830, 4392674, 4392552, 4397040, 4399493, 4390567, 4380345, 4379909, 4396317, 4396386, 4396425, 4396824, 4388858, 4381745, 4401677, 4401678, 4401692, 4382008, 4390846, 4402726, 4395042, 4396246, 4396629, 4391734, 4398949, 4388253, 4388274, 4392468, 4396431, 4377762, 4402681, 4399317, 4348153, 4160353, 4359165, 4359739, 4343339, 4386935, 4292494, 4306304, 4370210, 4376869, 4378231, 4378507, 4378778, 4380163, 4204776, 4404189);

Date: 2025-01-12 12:42:48 Duration: 16ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."name" AS "name", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."state" AS "state", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."notes" AS "notes", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date" FROM "shipping_policy" WHERE (("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, 113, 114)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) 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))))) AND "shipping_policy".id IN (4365505, 4340874, 4356567, 4358850, 4346333, 4370458, 4313031, 4375931, 4349135, 4316007, 4367148, 4367396, 4318287, 4352921);

Date: 2025-01-12 11:21:16 Duration: 15ms

17

171,813

Details

10s175ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 12	00	1,418	68ms	0ms
	01	875	43ms	0ms
	02	648	33ms	0ms
	03	528	27ms	0ms
	04	485	24ms	0ms
	05	334	17ms	0ms
	06	596	31ms	0ms
	07	396	19ms	0ms
	08	3,392	175ms	0ms
	09	11,072	631ms	0ms
	10	15,149	936ms	0ms
	11	15,089	916ms	0ms
	12	24,285	1s471ms	0ms
	13	18,516	1s173ms	0ms
	14	12,533	678ms	0ms
	15	17,224	957ms	0ms
	16	13,031	745ms	0ms
	17	11,423	656ms	0ms
	18	9,976	635ms	0ms
	19	8,316	562ms	0ms
	20	3,604	213ms	0ms
	21	1,753	96ms	0ms
	22	1,170	59ms	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: 2025-01-12 16:50:49 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2025-01-12 19:35:12 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 (88, 89);

Date: 2025-01-12 12:48:33 Duration: 0ms

18

164,751

Details

20s730ms

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	1,385	141ms	0ms
	01	863	89ms	0ms
	02	639	69ms	0ms
	03	519	56ms	0ms
	04	466	49ms	0ms
	05	319	33ms	0ms
	06	578	63ms	0ms
	07	383	38ms	0ms
	08	3,315	359ms	0ms
	09	10,633	1s276ms	0ms
	10	14,632	1s922ms	0ms
	11	14,563	1s903ms	0ms
	12	23,595	3s38ms	0ms
	13	17,442	2s360ms	0ms
	14	11,907	1s345ms	0ms
	15	16,396	1s921ms	0ms
	16	12,506	1s510ms	0ms
	17	10,996	1s334ms	0ms
	18	9,521	1s300ms	0ms
	19	8,022	1s185ms	0ms
	20	3,394	425ms	0ms
	21	1,577	186ms	0ms
	22	1,100	117ms	0ms

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

Date: 2025-01-12 12:38:49 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 (17) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-12 13:07:59 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 (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-12 16:28:49 Duration: 0ms

19

161,117

Details

1m34s

0ms

18ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 12	00	293	167ms	0ms
	01	270	174ms	0ms
	02	217	134ms	0ms
	03	185	106ms	0ms
	04	536	222ms	0ms
	05	131	85ms	0ms
	06	525	213ms	0ms
	07	791	295ms	0ms
	08	1,993	1s37ms	0ms
	09	6,121	4s513ms	0ms
	10	9,659	6s661ms	0ms
	11	10,170	6s47ms	0ms
	12	9,926	6s952ms	0ms
	13	13,673	10s202ms	0ms
	14	8,957	5s826ms	0ms
	15	10,424	6s897ms	0ms
	16	10,671	6s791ms	0ms
	17	6,499	3s533ms	0ms
	18	12,802	6s562ms	0ms
	19	22,413	11s833ms	0ms
	20	18,183	9s25ms	0ms
	21	15,941	6s198ms	0ms
	22	737	659ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (180358, 4068542, 515767, 1455078, 1237786, 1159165, 3504139, 553567, 263930, 1749481, 2030341, 510469, 740394, 768050, 2070212, 354786, 2324746, 1412491, 2353707, 1328233, 4311707, 2505234, 898076, 3440475, 1109113, 668522, 500504, 1414154, 1920450, 353666, 668524, 4088920, 4012361, 3426923, 1412089, 2154706, 2093766, 3230092, 2089022, 1552532, 3169210, 2522105, 3280444, 1941199, 619852, 394334, 4084298, 2980023, 1839266, 1436168, 164274, 1289446, 3799363, 2197223, 4277008, 3366524, 2050201, 929390, 2053236, 635472, 2328440, 3072653, 802694, 1525056, 2170353, 2180754, 3726081, 3075095, 2919796, 257738, 3917264, 1475023, 4338543, 2176274, 4304539, 3398853, 185747, 1105994, 2479243, 3564379, 4143344, 3920855, 524376, 860248, 1877581, 2551734, 2052395, 3597385, 334471, 1249202, 3454645, 3624446, 3767504, 3329935, 322443, 3727278, 1593033, 1782300, 1694323, 3145507, 2735879, 432932, 976160, 3849903, 3667075, 3918686, 3858799, 769147, 4027498, 1347129, 1909194, 288545, 1547053, 1942194, 3174677, 2888767, 648753, 1553963, 1313035, 1313428, 1083395, 3592161, 3706057, 1558737, 902414, 3173135, 771635, 3241755, 4114690, 1779890, 1830646, 2015383, 3348634, 4244718, 2477458, 1018624, 4032399, 2824775, 97343, 1552060, 3063874, 999633, 3946025, 3923819, 785679, 2677606, 2384337, 1922454, 2975393, 326539, 3684333, 233248, 1713315, 2992427, 3696789, 2142174, 4032046, 2092771, 3552435, 1323562, 303946, 269757, 1819096, 854125, 134085, 781949, 2489828, 1902874, 859117, 1399440, 3513121, 561164, 1408332, 612377, 1455501, 1900682, 1804502, 3247260, 930931, 712323, 4278315, 3883309, 735593, 2352665, 3981015, 4169383, 2335181, 4279508, 4028459, 3119604, 2006036);

Date: 2025-01-12 17:22:18 Duration: 18ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4398565, 4398559, 4398558, 4398546, 4398538, 4398532, 4398527, 4398521, 4398518, 4398502, 4398498, 4398480, 4398444, 4398419, 4398418, 4398413, 4398395, 4398392, 4398364, 4398354, 4398352, 4396962, 4396757, 4396735, 4396700, 4396689, 4396203, 4396198, 4395035, 4395030, 4395029, 4395022, 4395018, 4394332, 4394327, 4394300, 4394295, 4394282, 4394263, 4394234, 4394189, 4394143, 4394136, 4394102, 4394087, 4394085, 4393788, 4393523, 4393521, 4393510, 4393247, 4393240, 4393180, 4393179, 4393171, 4393166, 4393165, 4392851, 4392798, 4392766, 4392763, 4392721, 4392715, 4392659, 4392635, 4392625, 4392609, 4392601, 4392585, 4392208, 4392154, 4392130, 4391915, 4391895, 4391879, 4391850, 4391847, 4391845, 4391832, 4391819, 4391628, 4391609, 4391519, 4391499, 4391496, 4390364, 4390351, 4390349, 4390339, 4390214, 4389702, 4389680, 4389678, 4389676, 4389672, 4389329, 4388680, 4388625, 4388621, 4388218, 4387751, 4387738, 4387708, 4386766, 4386669, 4386604, 4386564, 4386384, 4386376, 4386215, 4385909, 4385461, 4385433, 4385403, 4385064, 4385035, 4385017, 4384963, 4384940, 4384929, 4384908, 4384852, 4384487, 4384468, 4384445, 4384127, 4384093, 4383377, 4383368, 4383314, 4383305, 4383304, 4383285, 4383283, 4381634, 4381631, 4381604, 4381600, 4380778, 4380606, 4380540, 4380529, 4380524, 4380519, 4380503, 4380497, 4380492, 4380486, 4380460, 4380432, 4379579, 4379576, 4355438);

Date: 2025-01-12 00:58:14 Duration: 15ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4315818, 4322374, 4369870, 3953786, 4371077, 4371081, 4371024, 4182471, 4297021, 4358675, 4350222, 4296761, 4349227, 4329445, 4371094, 4330709, 4300259, 4060014, 4116643, 4315991, 4334789, 4338435, 4357331, 4300281, 4330738, 4297949, 4297049, 3892926, 4334715, 4297047, 4361662, 4349326, 4273901, 4328423, 4301463, 4324813, 4315434, 4293349, 4300289, 4258619, 4305399, 4209850, 4247869, 4300212, 4315448, 4287596, 4247723, 4329733, 4300294, 4288676, 4315153, 4315250, 4296716, 4296763, 4315374, 4334759, 4276107, 4301396, 4172909, 4178433, 4274801, 4297934, 4258726, 4272002, 4334666, 4261736, 4297048, 4334699, 4209854, 4258622, 4219368, 4197462, 4093189, 4261730, 4297993, 4288688, 3673409, 4275775, 4271090, 4305320, 4140120, 4271084, 4288437, 4296714, 4305260, 4262213, 4275874, 4305438, 4288430, 4181203, 4275762, 4282703, 4296777, 4305251, 4296712, 4288419, 4293164, 4157226, 4261726, 4288657, 4273899, 4258631, 4151945, 4266749, 4299545, 3221027, 4275774, 4288639, 4182251, 4305275, 4238782, 4197468, 4204185, 4157122, 4258614, 4218562, 4209857, 4226520, 4238809, 3985866, 4258865, 4265566, 4258729, 4262211, 4048719, 4258633, 4258731, 4273083, 4218639, 4274867, 4258436, 4258782, 3997506, 4258641, 4273087, 4261745, 4258795, 4258810, 4245197, 4240514, 4273894, 4273903, 4209852, 4048928, 4265562, 4194355, 4258637, 4226396, 4182200, 4236137, 4098964, 4208015, 4218637, 4151912, 4243249, 4238787, 4219357, 4230784, 4236133, 4215064, 4243723, 4178759, 4192442, 4172751, 4114278, 4218478, 4209151, 4230831, 4204126, 4114674, 4106618, 4238952, 4236141, 4209840, 4244874, 4106630, 4130947, 4240510, 4192481, 4093167, 4178774, 4151921, 4243992, 4226660, 4219375, 4238034, 4194255, 4248234, 4074933, 4192482, 4160540, 4172753, 4139232, 4184797, 4219371, 4209845, 4172877, 4207644, 4162434, 4219406, 4194318, 4217089, 3979572, 4207634, 4184322, 4122953, 4133700, 4152236, 4182433, 4192441, 3096110, 4194251, 4171993, 4030484, 4172858, 4209847, 4130932, 4172870, 4160543, 4082057, 4169221, 4172961, 4109505, 4160569, 4109486, 4157125, 4157034, 4160547, 4151947, 4172874, 4169650, 3813951, 4003870, 4138117, 4151915, 4027290, 4151914, 4111155, 4185426, 4155144, 4151918, 4114735, 4172875, 4138638, 4160534, 4151948, 3892934, 4164583, 4169347, 4133719, 4172872, 4130942, 4093184, 4172183, 4162454, 4172218, 4130927, 4106636, 4139839, 4093182, 4116378, 4093173, 4093177, 4048911, 4139157, 4164580, 4130922, 4138641, 3995682, 4106621, 4111178, 4046313, 4077861, 4082048, 4048931, 4098925, 4082050, 3995684, 3995688, 3995695, 4088496, 4106637, 4106634, 4106641, 4106626, 4106624, 4106639, 4055998, 3985698, 4055883, 4055886, 4069732, 3985706, 4016302, 4055879, 4016313, 4016310, 3983006, 3983326, 3985704, 3904533, 3904529, 3940894, 3983235, 3904538, 3940865, 3847059, 3904536, 3950976, 3940874, 3940885, 3904531, 3777092, 3873203, 3873201, 3873197, 3873198, 3847053, 3847051, 3777147, 3873199, 3873207, 3873196, 3847057, 3847049, 3758806, 3777091, 3726647, 3777093, 3758811, 3726645, 3777094, 3777146, 3726646, 3710606, 3726644, 3577876, 3726648, 3647889, 3647886, 3694225, 3694231, 3694336, 3694233, 3616130, 3616138, 3648030, 3648034, 3647891, 3616129, 3577882, 3453835, 3586249, 3616133, 3557553, 3577879, 3557555, 3577885, 3557556, 3535747, 3535595, 3444441, 3453846, 3453851, 3557552, 3535589, 3389304, 3444437, 3481957, 3481954, 3481946, 3481952, 3486947, 3444443, 3486942, 3444438, 3453840, 3444439, 3444448, 3444446, 3344847, 3417767, 3376513, 3344816, 3344830, 3344802, 3376511, 3344845, 3344846);

Date: 2025-01-12 17:23:14 Duration: 10ms

20

142,406

Details

11s92ms

0ms

1ms

0ms

select "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" from "urgent_warehouse" where "urgent_warehouse".id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 12	00	2,235	110ms	0ms
	01	2,403	112ms	0ms
	02	1,954	95ms	0ms
	03	1,931	84ms	0ms
	04	2,306	95ms	0ms
	05	1,446	60ms	0ms
	06	2,185	98ms	0ms
	07	940	41ms	0ms
	08	3,007	198ms	0ms
	09	8,288	668ms	0ms
	10	11,988	1s12ms	0ms
	11	11,475	968ms	0ms
	12	14,553	1s429ms	0ms
	13	10,430	1s43ms	0ms
	14	8,063	608ms	0ms
	15	8,459	749ms	0ms
	16	7,938	653ms	0ms
	17	8,877	713ms	0ms
	18	21,206	1s312ms	0ms
	19	5,999	592ms	0ms
	20	2,264	172ms	0ms
	21	2,938	197ms	0ms
	22	1,521	72ms	0ms

SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" 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);

Date: 2025-01-12 19:43:12 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" 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);

Date: 2025-01-12 12:40:08 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" 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);

Date: 2025-01-12 19:35:12 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

39m52s

1m6s

325

Details

6h2m36s

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
Jan 12	00	6	1ms	0ms
	01	2	1ms	0ms
	02	1	0ms	0ms
	04	2	1ms	0ms
	05	2	0ms	0ms
	06	2	0ms	0ms
	08	7	1ms	0ms
	09	42	56m50s	1m21s
	10	31	27ms	0ms
	11	29	8ms	0ms
	12	23	25m10s	1m5s
	13	39	54m44s	1m24s
	14	33	1h31m5s	2m45s
	15	35	1h52m42s	3m13s
	16	24	22m1s	55s72ms
	17	9	15ms	1ms
	18	3	3ms	1ms
	19	17	20ms	1ms
	20	7	3ms	0ms
	21	7	1ms	0ms
	22	4	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-12 14:15:28.268937', "last_update" = '2025-01-12 13:30:28.268958', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:30:27.881303', "write_uid" = 905 WHERE id IN (905);

Date: 2025-01-12 15:10:20 Duration: 39m52s
UPDATE "res_users" SET "exp_date" = '2025-01-12 14:18:12.077309', "last_update" = '2025-01-12 13:33:12.077330', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:33:11.730394', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-12 15:10:20 Duration: 37m8s
UPDATE "res_users" SET "exp_date" = '2025-01-12 14:23:27.566958', "last_update" = '2025-01-12 13:38:27.566988', "sid" = '921a16fe63145c910d1d58c8b245e0960ddddd2b', "write_date" = '2025-01-12 13:38:27.190561', "write_uid" = 905 WHERE id IN (905);

Date: 2025-01-12 15:10:20 Duration: 31m53s

2

0ms

59m59s

3s477ms

60,484

Details

2d10h25m14s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 12	00	648	2h45m51s	15s356ms
	01	797	59m56s	4s513ms
	02	737	166ms	0ms
	03	758	45s946ms	60ms
	04	687	153ms	0ms
	05	507	115ms	0ms
	06	582	128ms	0ms
	07	356	78ms	0ms
	08	1,241	11s816ms	9ms
	09	4,050	1h46m33s	1s578ms
	10	5,656	7h22m10s	4s690ms
	11	5,870	16s643ms	2ms
	12	6,252	11h7m39s	6s407ms
	13	5,554	4h25m8s	2s864ms
	14	4,720	3h16m18s	2s495ms
	15	4,701	11h59m36s	9s184ms
	16	4,689	6h35m41s	5s63ms
	17	3,784	4h42m26s	4s478ms
	18	2,822	3h12m4s	4s83ms
	19	2,640	8m20s	189ms
	20	1,632	2m9s	79ms
	21	1,119	268ms	0ms
	22	682	147ms	0ms

update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 22:40:33.747596', exp_date = '2025-01-11 23:25:33.747600', logged_in = 'TRUE' where id = 933;

Date: 2025-01-12 00:40:33 Duration: 59m59s
update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 22:40:33.747990', exp_date = '2025-01-11 23:25:33.747993', logged_in = 'TRUE' where id = 933;

Date: 2025-01-12 00:40:33 Duration: 59m59s
update res_users set sid = 'd151dfc624c10afb83522a6b95b6383c6b6a4300', last_update = '2025-01-11 23:40:33.669364', exp_date = '2025-01-12 00:25:33.669368', logged_in = 'TRUE' where id = 933;

Date: 2025-01-12 01:40:30 Duration: 59m56s

3

15ms

4s179ms

2s764ms

223

Details

10m16s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	10	29s390ms	2s939ms
	01	3	8s946ms	2s982ms
	09	7	21s671ms	3s95ms
	10	4	12s525ms	3s131ms
	11	8	10s213ms	1s276ms
	12	16	36s577ms	2s286ms
	13	15	35s119ms	2s341ms
	14	12	28s156ms	2s346ms
	15	16	26s593ms	1s662ms
	16	54	2m24s	2s670ms
	17	22	1m17s	3s535ms
	18	16	56s34ms	3s502ms
	19	16	53s593ms	3s349ms
	20	19	1m6s	3s497ms
	21	3	9s93ms	3s31ms
	22	2	57ms	28ms

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

Date: 2025-01-12 20:13:31 Duration: 4s179ms
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 (80))))))) 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 (80)))))) 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 (80)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (80)))))) 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 (80))))))))) 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 (80)))))))) AND ("policy_number"."name"::text ilike '%9294909%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-12 17:45:30 Duration: 4s162ms
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 (76))))))) 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 (76)))))) 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 (76)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76)))))) 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 (76))))))))) 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 (76)))))))) AND ("policy_number"."name"::text ilike '%9908651%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-12 20:17:24 Duration: 4s120ms

4

22ms

1s914ms

956ms

8,052

Details

2h8m19s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	412	6m5s	887ms
	01	140	2m4s	891ms
	02	177	2m38s	897ms
	03	437	6m27s	887ms
	04	310	4m38s	899ms
	09	3	85ms	28ms
	10	59	56s816ms	962ms
	11	8	7s621ms	952ms
	12	65	1m	932ms
	13	239	3m49s	958ms
	14	205	3m11s	932ms
	15	210	3m14s	924ms
	16	283	4m26s	943ms
	17	1,006	17m34s	1s48ms
	18	1,615	26m54s	999ms
	19	1,596	26m26s	994ms
	20	345	5m47s	1s8ms
	21	699	9m8s	784ms
	22	243	3m44s	925ms

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

Date: 2025-01-12 19:41:53 Duration: 1s914ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9849968')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 19:41:49 Duration: 1s897ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9561569')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 18:39:08 Duration: 1s718ms

5

479ms

4s54ms

578ms

42,702

Details

6h51m54s

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
Jan 12	00	157	1m29s	567ms
	01	152	1m32s	608ms
	02	187	1m49s	587ms
	03	169	1m37s	579ms
	04	336	3m3s	547ms
	05	120	1m10s	584ms
	06	213	1m59s	561ms
	07	341	2m58s	522ms
	08	767	6m44s	527ms
	09	3,542	32m38s	552ms
	10	3,701	35m35s	577ms
	11	3,583	34m34s	578ms
	12	4,731	46m25s	588ms
	13	3,945	40m5s	609ms
	14	2,623	24m12s	553ms
	15	2,618	24m11s	554ms
	16	3,797	35m34s	562ms
	17	3,251	31m10s	575ms
	18	3,097	30m58s	600ms
	19	2,064	22m29s	653ms
	20	2,003	19m31s	584ms
	21	843	7m51s	559ms
	22	462	4m8s	537ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4414949, 4414948, 4414947, 4414946, 4414945, 4414944, 4414943, 4414942, 4414941, 4414939, 4414936, 4414934, 4414931, 4414927, 4414924, 4414920, 4414917, 4414915, 4414912, 4414910, 4414908, 4414906, 4414904, 4414902, 4414900, 4414897, 4414895, 4414894, 4414893, 4414892, 4414891, 4414890, 4414889, 4414888, 4414887, 4414886, 4414885, 4414884, 4414883, 4414882, 4414881, 4414880, 4414879, 4414878, 4414877, 4414876, 4414875, 4414874, 4414873, 4414872, 4414871, 4414870, 4414869, 4414868, 4414867, 4414866, 4414865, 4414864, 4414863, 4414862, 4414861, 4414860, 4414859, 4414858)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:40:41 Duration: 4s54ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4414472, 4414560, 4414566, 4414569, 4414563, 4414512, 4414536, 4414546, 4414522, 4414389, 4414498, 4414502, 4414398, 4414422, 4414573, 4414416, 4414485, 4414475, 4414775, 4414395, 4414378, 4414391, 4414445, 4414555, 4414427, 4414532, 4414518, 4414492, 4414461, 4414439, 4414534, 4414510, 4414410, 4414552, 4414393, 4414384, 4414487, 4414401, 4414514, 4414382, 4414506, 4414516, 4414469, 4414489, 4414528, 4414482, 4414454, 4414412, 4414414, 4414371, 4414452, 4414376, 4414433, 4414524, 4414535, 4414537, 4414538, 4414540, 4414508, 4414542, 4414526, 4414544, 4414407, 4414430, 4414449, 4414458, 4414478, 4414435, 4414374, 4414495, 4414557, 4414380, 4414550, 4414548, 4414554, 4414520, 4414530, 4414571, 4414419, 4414504, 4414404, 4414467, 4414442, 4414387, 4414425)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:40:13 Duration: 3s857ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4404017, 4400194, 4398149, 4395938, 4389128, 4386798, 4386468, 4378364, 4353097, 4316573)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:40:34 Duration: 3s608ms

6

478ms

4s570ms

566ms

237,608

Details

1d13h22m22s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	5,377	47m46s	533ms
	01	9,413	1h22m42s	527ms
	02	6,698	58m33s	524ms
	03	6,605	58m13s	528ms
	04	8,096	1h11m	526ms
	05	6,262	54m18s	520ms
	06	4,493	39m27s	526ms
	07	2,695	23m11s	516ms
	08	3,574	30m46s	516ms
	09	11,754	1h46m5s	541ms
	10	16,312	2h33m24s	564ms
	11	14,091	2h12m22s	563ms
	12	17,460	2h46m24s	571ms
	13	15,824	2h36m17s	592ms
	14	10,142	1h31m31s	541ms
	15	8,862	1h20m27s	544ms
	16	10,959	1h41m53s	557ms
	17	10,078	1h39m1s	589ms
	18	17,483	2h59m1s	614ms
	19	20,597	3h41m10s	644ms
	20	13,460	2h9m53s	578ms
	21	14,550	2h13m32s	550ms
	22	2,823	25m17s	537ms

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

Date: 2025-01-12 19:40:58 Duration: 4s570ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4414987)) AND (("shipping_track"."id" not in (36445341, 36445341)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:41:10 Duration: 4s509ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4415008)) AND (("shipping_track"."id" not in (36445505, 36445505)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-12 19:41:30 Duration: 4s405ms

7

213ms

2s46ms

292ms

14,134

Details

1h8m51s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	885	3m45s	255ms
	01	964	4m13s	263ms
	02	428	1m50s	257ms
	03	561	2m27s	262ms
	04	568	2m26s	258ms
	05	356	1m34s	264ms
	06	822	3m32s	258ms
	07	159	41s184ms	259ms
	08	62	16s21ms	258ms
	09	25	6s858ms	274ms
	10	69	20s280ms	293ms
	11	132	37s175ms	281ms
	12	117	31s682ms	270ms
	13	79	23s275ms	294ms
	14	476	2m15s	284ms
	15	480	2m6s	263ms
	16	736	3m20s	271ms
	17	869	4m17s	296ms
	18	1,883	10m14s	326ms
	19	1,930	11m7s	345ms
	20	1,371	7m13s	316ms
	21	1,014	4m45s	281ms
	22	148	43s544ms	294ms

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

Date: 2025-01-12 19:41:32 Duration: 2s46ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9834980')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 18:39:14 Duration: 1s874ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9856339')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-12 19:41:02 Duration: 1s770ms

8

170ms

540ms

277ms

26,309

Details

2h1m50s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 12	08	346	1m22s	237ms
	09	1,340	5m51s	261ms
	10	2,350	10m52s	277ms
	11	4,453	20m34s	277ms
	12	1,222	5m45s	282ms
	13	5,957	28m3s	282ms
	14	2,182	9m18s	256ms
	15	2,558	11m9s	261ms
	16	2,344	10m26s	267ms
	17	1,972	10m11s	309ms
	18	649	3m30s	324ms
	19	157	1m3s	402ms
	20	525	2m33s	291ms
	21	254	1m7s	267ms

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

Date: 2025-01-12 19:03:58 Duration: 540ms
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" = '9514998')))) ORDER BY "collection_policy"."id";

Date: 2025-01-12 18:43:34 Duration: 533ms
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" = '7862339')))) ORDER BY "collection_policy"."id";

Date: 2025-01-12 20:21:17 Duration: 532ms

9

17ms

1s672ms

259ms

2,633

Details

11m23s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	7	558ms	79ms
	01	6	1s631ms	271ms
	07	6	1s553ms	258ms
	08	47	12s590ms	267ms
	09	125	32s151ms	257ms
	10	292	1m1s	211ms
	11	310	1m10s	227ms
	12	316	1m23s	262ms
	13	377	1m52s	298ms
	14	268	1m12s	269ms
	15	272	1m12s	266ms
	16	224	1m	269ms
	17	186	30s573ms	164ms
	18	81	28s759ms	355ms
	19	50	19s949ms	398ms
	20	48	18s779ms	391ms
	21	7	3s67ms	438ms
	22	11	731ms	66ms

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 (60)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))) 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: 2025-01-12 19:40:25 Duration: 1s672ms
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 (48)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (48))))) 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: 2025-01-12 13:45:10 Duration: 798ms
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 (77)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77))))) 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: 2025-01-12 13:06:54 Duration: 797ms

10

92ms

834ms

249ms

43,818

Details

3h2m16s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	2,570	8m54s	208ms
	01	2,184	7m59s	219ms
	02	1,198	4m33s	228ms
	03	1,972	7m5s	215ms
	04	1,732	6m6s	211ms
	05	693	2m47s	241ms
	06	1,637	5m59s	219ms
	07	304	1m10s	231ms
	08	120	19s506ms	162ms
	09	46	12s442ms	270ms
	10	254	54s667ms	215ms
	11	270	1m	225ms
	12	362	1m22s	227ms
	13	620	2m40s	259ms
	14	1,340	5m27s	244ms
	15	1,369	5m20s	234ms
	16	2,006	8m20s	249ms
	17	3,686	15m15s	248ms
	18	6,931	32m55s	284ms
	19	6,990	32m39s	280ms
	20	3,398	14m29s	255ms
	21	3,366	13m47s	245ms
	22	770	2m54s	226ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-12 18:39:12 Duration: 834ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عماد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-12 19:41:32 Duration: 822ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'شريف')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-12 19:41:36 Duration: 820ms

11

163ms

1s360ms

220ms

127,697

Details

7h49m51s

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

Day	Hour	Count	Duration	Avg duration
Jan 12	00	543	1m41s	187ms
	01	2,217	6m55s	187ms
	02	2,112	6m37s	188ms
	03	2,277	7m6s	187ms
	04	1,628	5m5s	187ms
	05	1,665	5m14s	188ms
	06	956	2m58s	186ms
	07	868	2m41s	186ms
	08	1,564	4m53s	187ms
	09	5,086	16m55s	199ms
	10	7,161	24m25s	204ms
	11	6,892	23m34s	205ms
	12	3,909	13m43s	210ms
	13	10,419	37m36s	216ms
	14	4,725	15m22s	195ms
	15	5,962	19m31s	196ms
	16	7,088	23m49s	201ms
	17	3,463	12m45s	220ms
	18	10,483	40m29s	231ms
	19	24,069	1h41m8s	252ms
	20	21,368	1h26m14s	242ms
	21	3,091	10m30s	204ms
	22	151	30s165ms	199ms

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

Date: 2025-01-12 19:41:03 Duration: 1s360ms
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" = '485102')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 19:40:54 Duration: 1s293ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9740107')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 19:41:43 Duration: 1s157ms

12

168ms

334ms

202ms

12,945

Details

43m44s

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
Jan 12	00	2	373ms	186ms
	01	6	1s97ms	182ms
	02	84	15s729ms	187ms
	03	320	59s295ms	185ms
	04	380	1m11s	187ms
	05	371	1m10s	190ms
	06	325	1m	186ms
	07	746	2m19s	186ms
	08	774	2m25s	187ms
	09	1,601	5m12s	195ms
	10	849	2m51s	202ms
	11	1,776	6m10s	208ms
	12	1,415	5m1s	213ms
	13	1,143	4m12s	221ms
	14	501	1m38s	196ms
	15	346	1m6s	191ms
	16	369	1m15s	204ms
	17	349	1m10s	202ms
	18	213	45s127ms	211ms
	19	336	1m17s	230ms
	20	323	1m9s	216ms
	21	565	1m57s	207ms
	22	151	30s208ms	200ms

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" = '9817386')) 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: 2025-01-12 20:23:10 Duration: 334ms
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" = '9817156')) 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: 2025-01-12 19:23:51 Duration: 327ms
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" = '9815961')) 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 (76)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 10:51:50 Duration: 325ms

13

170ms

299ms

201ms

3,219

Details

10m48s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 12	04	4	746ms	186ms
	05	95	17s899ms	188ms
	06	385	1m11s	186ms
	07	122	22s673ms	185ms
	09	685	2m20s	204ms
	10	642	2m16s	212ms
	11	168	35s446ms	210ms
	14	143	27s650ms	193ms
	15	482	1m37s	201ms
	16	475	1m33s	197ms
	20	18	4s720ms	262ms

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

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

Date: 2025-01-12 10:51:50 Duration: 287ms
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" = '9594318')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-12 20:14:40 Duration: 277ms

14

163ms

800ms

194ms

2,724

Details

8m49s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 12	00	120	21s804ms	181ms
	01	120	21s997ms	183ms
	02	120	22s46ms	183ms
	03	120	21s991ms	183ms
	04	120	21s880ms	182ms
	05	120	21s943ms	182ms
	06	120	21s845ms	182ms
	07	120	21s868ms	182ms
	08	120	21s755ms	181ms
	09	120	22s944ms	191ms
	10	120	24s516ms	204ms
	11	120	24s109ms	200ms
	12	120	25s37ms	208ms
	13	120	25s114ms	209ms
	14	120	23s300ms	194ms
	15	120	23s175ms	193ms
	16	120	23s842ms	198ms
	17	114	22s912ms	200ms
	18	120	25s200ms	210ms
	19	120	27s497ms	229ms
	20	120	24s930ms	207ms
	21	120	23s376ms	194ms
	22	90	16s813ms	186ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-12 19:41:03 Duration: 800ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-12 19:41:02 Duration: 547ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-12 19:40:02 Duration: 321ms

15

164ms

226ms

187ms

9,262

Details

28m59s

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
Jan 12	00	541	1m41s	187ms
	01	2,047	6m23s	187ms
	02	2,028	6m22s	188ms
	03	1,957	6m7s	187ms
	04	1,244	3m53s	187ms
	05	1,199	3m45s	188ms
	06	246	46s97ms	187ms

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

Date: 2025-01-12 03:16:16 Duration: 220ms

16

120ms

628ms

149ms

5,649

Details

14m3s

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
Jan 12	00	3	381ms	127ms
	07	10	1s311ms	131ms
	08	69	9s259ms	134ms
	09	309	43s156ms	139ms
	10	888	2m11s	148ms
	11	928	2m15s	145ms
	12	1,157	2m50s	147ms
	13	870	2m15s	155ms
	14	440	1m1s	139ms
	15	150	20s719ms	138ms
	16	181	25s783ms	142ms
	17	131	21s708ms	165ms
	18	141	24s300ms	172ms
	19	210	36s247ms	172ms
	20	117	19s102ms	163ms
	21	16	2s588ms	161ms
	22	29	4s341ms	149ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 61)) 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: 2025-01-12 17:22:10 Duration: 628ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) 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: 2025-01-12 10:51:50 Duration: 329ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) 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: 2025-01-12 12:29:09 Duration: 287ms

17

92ms

716ms

125ms

18,561

Details

38m44s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 12	00	220	25s437ms	115ms
	01	29	3s281ms	113ms
	02	10	1s292ms	129ms
	03	42	5s216ms	124ms
	04	23	2s901ms	126ms
	08	206	25s91ms	121ms
	09	1,176	2m28s	126ms
	10	1,153	2m30s	130ms
	11	2,047	4m21s	127ms
	12	2,667	5m48s	130ms
	13	2,138	4m50s	135ms
	14	1,463	2m59s	122ms
	15	1,781	3m40s	123ms
	16	1,433	2m59s	125ms
	17	1,143	2m16s	119ms
	18	1,553	2m53s	111ms
	19	730	1m27s	119ms
	20	586	1m7s	114ms
	21	92	10s123ms	110ms
	22	69	7s241ms	104ms

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

Date: 2025-01-12 19:41:26 Duration: 716ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7974948)) AND (("cash_track"."id" not in (6888364)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-12 19:41:32 Duration: 237ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7974693)) AND (("cash_track"."id" not in (6885817)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-12 18:39:16 Duration: 230ms

18

39ms

302ms

53ms

49,877

Details

44m23s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 12	00	10	491ms	49ms
	02	20	989ms	49ms
	03	7	359ms	51ms
	04	31	1s483ms	47ms
	06	13	639ms	49ms
	07	5	250ms	50ms
	08	686	33s113ms	48ms
	09	2,553	2m7s	49ms
	10	4,070	3m32s	52ms
	11	4,005	3m29s	52ms
	12	4,911	4m22s	53ms
	13	7,529	6m45s	53ms
	14	4,907	4m2s	49ms
	15	6,914	5m42s	49ms
	16	5,927	5m1s	50ms
	17	3,062	3m8s	61ms
	18	2,700	2m56s	65ms
	19	638	44s673ms	70ms
	20	1,180	1m11s	60ms
	21	640	38s758ms	60ms
	22	69	4s66ms	58ms

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

Date: 2025-01-12 19:41:06 Duration: 302ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4358147) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-12 19:41:04 Duration: 299ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4379043) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-12 19:41:30 Duration: 298ms

19

36ms

89ms

47ms

20,558

Details

16m17s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 12	08	265	11s129ms	41ms
	09	916	41s509ms	45ms
	10	1,847	1m25s	46ms
	11	1,482	1m9s	47ms
	12	2,448	1m53s	46ms
	13	3,533	2m50s	48ms
	14	2,181	1m36s	44ms
	15	2,261	1m40s	44ms
	16	2,538	1m53s	44ms
	17	1,206	1m7s	56ms
	18	1,003	57s971ms	57ms
	19	139	8s356ms	60ms
	20	477	26s297ms	55ms
	21	261	14s884ms	57ms
	22	1	51ms	51ms

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

Date: 2025-01-12 11:40:57 Duration: 89ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4235138) ORDER BY "collection_policy"."id";

Date: 2025-01-12 09:40:01 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4356925) ORDER BY "collection_policy"."id";

Date: 2025-01-12 13:50:50 Duration: 81ms

20

33ms

294ms

46ms

135,500

Details

1h45m47s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 12	00	2,605	1m47s	41ms
	01	3,331	2m18s	41ms
	02	2,061	1m26s	41ms
	03	2,277	1m34s	41ms
	04	2,742	1m54s	41ms
	05	1,499	1m2s	41ms
	06	1,734	1m12s	41ms
	07	1,049	43s938ms	41ms
	08	1,621	1m8s	42ms
	09	7,639	5m32s	43ms
	10	12,505	9m25s	45ms
	11	11,613	8m43s	45ms
	12	14,063	10m40s	45ms
	13	12,454	9m47s	47ms
	14	7,950	5m42s	43ms
	15	7,316	5m15s	43ms
	16	8,863	6m30s	44ms
	17	6,951	5m59s	51ms
	18	8,378	7m43s	55ms
	19	8,268	8m	58ms
	20	4,938	4m27s	54ms
	21	3,642	3m8s	51ms
	22	2,001	1m41s	50ms

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

Date: 2025-01-12 17:22:10 Duration: 294ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4405984)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-12 18:39:12 Duration: 240ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4353097)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-12 19:41:06 Duration: 237ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

20,538,086 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	6	0.00%
DETAIL	178	0.00%
ERROR	3,663	0.02%
EVENTLOG	776	0.00%
FATAL	792	0.00%
HINT	3	0.00%
LOG	20,528,987	99.96%
STATEMENT	3,681	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
792 FATAL entries
3663 ERROR entries
0 WARNING entries
776 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,919 Max number of times the same event was reported
5,231 Total events found

Rank

Times reported

Error

1

1,919

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 12	00	17
	01	20
	02	5
	03	2
	04	10
	05	5
	06	8
	07	12
	08	19
	09	77
	10	195
	11	291
	12	152
	13	182
	14	114
	15	98
	16	109
	17	183
	18	144
	19	154
	20	83
	21	27
	22	12

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

1,710

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 12	00	17
	01	15
	02	3
	03	1
	04	9
	05	4
	06	7
	07	12
	08	17
	09	71
	10	175
	11	253
	12	149
	13	166
	14	110
	15	86
	16	99
	17	173
	18	125
	19	124
	20	63
	21	19
	22	12

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

478

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 12	00	2
	09	53
	10	53
	12	70
	13	71
	14	44
	15	59
	16	52
	17	46
	18	28

4

478

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 12	00	2
	09	53
	10	53
	12	70
	13	71
	14	44
	15	59
	16	52
	17	46
	18	28

5

211

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 12	00	1
	01	1
	09	24
	10	11
	12	25
	13	31
	14	30
	15	40
	16	19
	17	18
	18	4
	19	5
	20	2

6

160

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 12	00	3
	18	3
	20	154

FATAL: password authentication failed for user "postgres"
FATAL: password authentication failed for user "root"
FATAL: password authentication failed for user "admin"

7

86

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 12	09	7
	10	7
	12	15
	13	16
	14	6
	15	17
	16	4
	17	12
	18	2

8

72

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 12	17	72

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

9

32

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 12	09	4
	12	6
	13	20
	15	1
	16	1

10

24

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 12	17	24

11

16

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 12	17	16

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

13

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 12	15	1
	16	3
	17	6
	18	3

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

13

12

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 12	09	1
	16	9
	17	2

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

14

3

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 12	11	1
	16	1
	18	1

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
Jan 12	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: the database system is starting up

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 12	17	3

17

3

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 12	12	1
	13	1
	16	1

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

18

2

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 12	14	1
	20	1

19

2

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 12	14	1
	20	1

20

2

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 12	14	1
	20	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 12	17	1

22

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 12	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables