pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Jan 6 23:47:35 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 44,917,634 log entries in 2m34s
Log start from 2025-01-06 00:00:00 to 2025-01-06 22:45:01

Global Stats

21,504 Number of unique normalized queries
19,182,386 Number of queries
6d16h40m1s Total query duration
2025-01-06 00:00:00 First query
2025-01-06 22:45:01 Last query
6,478 queries/s at 2025-01-06 11:14:13 Query peak

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

21,302 Number of events
24 Number of unique normalized events
10,186 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
19,182,386 Average queries per session
6d16h40m1s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

6,478 queries/s Query Peak
2025-01-06 11:14:13 Date

SELECT Traffic

Key values

4,499 queries/s Query Peak
2025-01-06 09:59:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,524 queries/s Query Peak
2025-01-06 11:14:13 Date

Queries duration

Key values

6d16h40m1s 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 06	00	265,265	0ms	11s61ms	14ms	2m9s	2m19s	3m13s
	01	302,765	0ms	3s194ms	14ms	2m10s	2m45s	3m6s
	02	274,349	0ms	1s69ms	24ms	3m34s	3m58s	4m22s
	03	200,784	0ms	1s661ms	25ms	2m50s	3m59s	5m24s
	04	160,887	0ms	3s947ms	19ms	1m59s	2m28s	3m51s
	05	144,241	0ms	2m15s	29ms	2m41s	3m15s	3m25s
	06	215,666	0ms	961ms	18ms	2m33s	2m45s	3m16s
	07	130,238	0ms	4s579ms	10ms	1m30s	1m40s	2m17s
	08	440,710	0ms	4m12s	17ms	2m24s	3m27s	1h18m27s
	09	1,083,201	0ms	19m57s	27ms	4m45s	1h24m38s	2h48m43s
	10	1,926,778	0ms	12m30s	26ms	42m10s	1h43m10s	2h37m41s
	11	1,534,047	0ms	5s445ms	10ms	6m12s	7m26s	9m10s
	12	1,730,947	0ms	55m39s	56ms	50m14s	1h44m54s	12h47m40s
	13	1,831,986	0ms	8m54s	28ms	39m24s	1h36m4s	2h22m23s
	14	1,453,777	0ms	9m1s	14ms	5m43s	7m59s	1h37m28s
	15	1,412,373	0ms	20m49s	27ms	9m27s	11m7s	5h9m2s
	16	1,381,526	0ms	3m29s	20ms	11m36s	16m44s	55m51s
	17	1,199,303	0ms	4m53s	18ms	9m51s	13m	56m40s
	18	1,074,155	0ms	30m33s	41ms	10m6s	11m50s	3h54m23s
	19	926,269	0ms	32m57s	54ms	8m44s	14m17s	4h9m26s
	20	639,197	0ms	33m31s	54ms	6m36s	7m41s	5h45m15s
	21	485,569	0ms	40m33s	67ms	3m55s	4m42s	6h39m41s
	22	368,353	0ms	19m40s	51ms	4m10s	4m17s	3h29m34s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 06	00	139,236	26ms	1m46s	2m9s	2m25s
	01	163,017	27ms	1m54s	2m10s	2m52s
	02	135,532	49ms	3m	3m33s	4m
	03	97,710	53ms	1m57s	2m50s	4m8s
	04	78,086	40ms	1m23s	1m58s	2m49s
	05	71,780	57ms	2m7s	2m16s	3m15s
	06	117,013	33ms	1m59s	2m33s	2m51s
	07	66,874	20ms	41s535ms	1m30s	1m47s
	08	261,426	11ms	1m23s	2m7s	3m26s
	09	660,717	13ms	3m17s	4m6s	5m16s
	10	1,172,314	12ms	5m36s	5m59s	7m3s
	11	883,500	17ms	5m5s	6m11s	8m26s
	12	1,059,546	19ms	7m28s	8m23s	10m22s
	13	1,165,884	14ms	6m19s	6m51s	7m46s
	14	842,401	17ms	5m23s	5m36s	7m57s
	15	823,330	23ms	7m48s	9m26s	10m41s
	16	833,197	25ms	8m34s	10m48s	13m35s
	17	729,466	25ms	7m12s	9m23s	12m58s
	18	647,737	31ms	7m47s	9m27s	10m5s
	19	553,750	41ms	7m32s	8m16s	13m10s
	20	370,731	37ms	5m4s	6m35s	7m40s
	21	284,391	30ms	3m12s	3m51s	4m41s
	22	215,800	30ms	3m28s	3m59s	4m28s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 06	00	24,296	3,989	154	0	0ms	102ms	165ms	597ms
	01	15,875	4,712	141	0	0ms	88ms	114ms	168ms
	02	22,319	6,158	129	0	0ms	135ms	172ms	237ms
	03	16,393	5,153	135	0	0ms	91ms	135ms	285ms
	04	8,614	3,249	132	0	0ms	58ms	82ms	118ms
	05	13,554	3,768	134	0	8ms	83ms	115ms	216ms
	06	15,737	3,767	132	0	0ms	83ms	128ms	203ms
	07	4,053	1,508	133	0	0ms	24ms	46ms	88ms
	08	11,553	4,480	303	0	286ms	73ms	117ms	239ms
	09	39,338	12,855	665	0	387ms	239ms	297ms	1h23m12s
	10	74,171	21,537	784	0	377ms	489ms	727ms	1h40m37s
	11	65,786	21,431	760	0	0ms	390ms	456ms	622ms
	12	77,367	24,862	908	0	757ms	583ms	858ms	1h40m20s
	13	59,812	24,305	648	0	424ms	421ms	35s400ms	1h33m56s
	14	61,971	21,052	528	2	68ms	390ms	463ms	747ms
	15	64,325	26,118	827	0	204ms	445ms	638ms	1m28s
	16	65,876	21,363	958	0	71ms	535ms	11s361ms	2m23s
	17	72,487	24,538	455	6	35ms	572ms	864ms	36s471ms
	18	76,194	24,566	783	8	236ms	565ms	799ms	4m21s
	19	74,301	21,677	675	0	281ms	500ms	634ms	2m1s
	20	53,673	14,996	239	0	298ms	326ms	441ms	880ms
	21	40,844	9,235	301	0	475ms	252ms	292ms	387ms
	22	30,343	6,730	240	0	334ms	231ms	288ms	474ms

Day	Hour	Percentage of prepare
Jan 06	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 06	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 06	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

374,029 buffers Checkpoint Peak
2025-01-06 19:26:27 Date
270.046 seconds Highest write time
0.421 seconds Sync time

Checkpoints Wal files

Key values

177 files Wal files usage Peak
2025-01-06 19:26:27 Date

Checkpoints distance

Key values

5,638.03 Mo Distance Peak
2025-01-06 19:26:27 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 06	00	154,131	3,122.52s	0.033s	3,122.597s
	01	134,452	3,239.55s	0.033s	3,239.636s
	02	143,107	3,239.639s	0.029s	3,239.711s
	03	93,306	3,193.505s	0.029s	3,193.579s
	04	82,184	3,239.523s	0.03s	3,239.591s
	05	100,080	3,239.615s	0.028s	3,239.697s
	06	86,535	3,199.537s	0.032s	3,199.616s
	07	38,936	1,841.962s	0.026s	1,842.023s
	08	61,367	2,442.435s	0.029s	2,442.497s
	09	316,779	3,239.523s	0.051s	3,239.645s
	10	737,801	3,238.934s	0.482s	3,239.588s
	11	481,177	3,239.57s	0.05s	3,239.688s
	12	577,832	3,239.439s	0.063s	3,239.586s
	13	441,405	3,239.579s	0.049s	3,239.701s
	14	482,996	3,239.439s	0.056s	3,239.584s
	15	369,503	3,239.571s	0.05s	3,239.693s
	16	433,997	3,239.463s	0.047s	3,239.592s
	17	300,958	2,882.454s	0.066s	2,882.588s
	18	373,463	3,239.435s	0.055s	3,239.565s
	19	717,108	3,239.532s	0.046s	3,239.691s
	20	310,030	3,239.492s	0.052s	3,239.68s
	21	170,024	3,239.554s	0.044s	3,239.643s
	22	295,585	2,429.617s	0.031s	2,429.694s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 06	00	0	66	3,336	0.002s	0.012s
	01	0	60	3,112	0.002s	0.012s
	02	0	65	2,726	0.002s	0.012s
	03	0	44	2,426	0.005s	0.012s
	04	0	37	2,430	0.002s	0.012s
	05	0	45	2,184	0.003s	0.012s
	06	0	38	2,442	0.002s	0.012s
	07	0	16	1,692	0.002s	0.013s
	08	0	25	3,104	0.002s	0.011s
	09	0	138	4,737	0.002s	0.012s
	10	27	293	5,367	0.033s	0.013s
	11	0	179	5,320	0.003s	0.012s
	12	0	219	5,357	0.003s	0.012s
	13	0	166	5,282	0.003s	0.012s
	14	0	190	5,635	0.003s	0.012s
	15	0	144	5,473	0.003s	0.012s
	16	0	173	5,869	0.002s	0.012s
	17	0	120	5,361	0.017s	0.012s
	18	0	155	5,403	0.003s	0.012s
	19	14	308	5,356	0.002s	0.012s
	20	63	67	5,110	0.002s	0.012s
	21	0	73	4,654	0.002s	0.012s
	22	0	98	3,404	0.002s	0.009s

Day	Hour	Avg time (sec)
Jan 06	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 06	00	90,032.17 kB	128,293.75 kB
	01	81,383.00 kB	150,822.83 kB
	02	88,833.17 kB	125,415.17 kB
	03	60,713.25 kB	104,979.42 kB
	04	51,096.58 kB	78,242.42 kB
	05	61,141.00 kB	88,021.00 kB
	06	51,365.17 kB	78,781.67 kB
	07	20,757.46 kB	67,134.15 kB
	08	36,664.36 kB	53,831.27 kB
	09	189,048.33 kB	227,447.75 kB
	10	439,143.18 kB	834,096.82 kB
	11	245,246.17 kB	523,533.67 kB
	12	299,161.00 kB	357,499.42 kB
	13	226,370.00 kB	314,033.17 kB
	14	259,603.92 kB	320,680.25 kB
	15	196,576.00 kB	254,503.08 kB
	16	235,362.33 kB	318,302.67 kB
	17	164,094.25 kB	231,288.00 kB
	18	211,562.67 kB	283,196.92 kB
	19	465,990.91 kB	1,502,071.45 kB
	20	177,603.92 kB	964,935.00 kB
	21	100,453.83 kB	361,980.50 kB
	22	176,910.22 kB	322,608.22 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 06	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 06	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

11,373,438 Total read queries
5,290,191 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,373,438	59.29%
INSERT	988,882	5.16%
UPDATE	312,049	1.63%
DELETE	10,164	0.05%
COPY FROM	16	0.00%
COPY TO	0	0.00%
CTE	30,999	0.16%
DDL	2,859	0.01%
TCL	3,945,222	20.57%
CURSOR	0	0.00%
OTHERS	2,518,757	13.13%

Queries by database

Key values

unknown Main database
19,182,386 Requests
6d16h40m1s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	19,182,386	6d16h40m1s
	copy from	16	21ms
	cte	30,999	6s853ms
	ddl	2,859	388ms
	delete	10,164	6s976ms
	insert	988,882	5m13s
	others	2,518,757	1m57s
	select	11,373,438	3d8m14s
	tcl	3,945,222	2m39s
	update	312,049	3d16h21m41s

Queries by user

Key values

unknown Main user
19,182,386 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	19,182,386	6d16h40m1s
	copy from	16	21ms
	cte	30,999	6s853ms
	ddl	2,859	388ms
	delete	10,164	6s976ms
	insert	988,882	5m13s
	others	2,518,757	1m57s
	select	11,373,438	3d8m14s
	tcl	3,945,222	2m39s
	update	312,049	3d16h21m41s

Duration by user

Key values

6d16h40m1s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	19,182,386	6d16h40m1s
	copy from	16	21ms
	cte	30,999	6s853ms
	ddl	2,859	388ms
	delete	10,164	6s976ms
	insert	988,882	5m13s
	others	2,518,757	1m57s
	select	11,373,438	3d8m14s
	tcl	3,945,222	2m39s
	update	312,049	3d16h21m41s

Queries by host

Key values

unknown Main host
19,182,386 Requests
6d16h40m1s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	19,182,386	6d16h40m1s
	copy from	16	21ms
	cte	30,999	6s853ms
	ddl	2,859	388ms
	delete	10,164	6s976ms
	insert	988,882	5m13s
	others	2,518,757	1m57s
	select	11,373,438	3d8m14s
	tcl	3,945,222	2m39s
	update	312,049	3d16h21m41s

Queries by application

Key values

unknown Main application
19,182,386 Requests
6d16h40m1s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	19,182,386	6d16h40m1s
	copy from	16	21ms
	cte	30,999	6s853ms
	ddl	2,859	388ms
	delete	10,164	6s976ms
	insert	988,882	5m13s
	others	2,518,757	1m57s
	select	11,373,438	3d8m14s
	tcl	3,945,222	2m39s
	update	312,049	3d16h21m41s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-06 16:22:30 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,950,887 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,950,887	93.58%
1-5ms	294,331	1.53%
5-10ms	14,600	0.08%
10-25ms	55,987	0.29%
25-50ms	109,873	0.57%
50-100ms	141,889	0.74%
100-500ms	415,970	2.17%
500-1000ms	191,801	1.00%
1000-10000ms	5,892	0.03%
> 10000ms	1,156	0.01%

Slowest individual queries

Rank	Duration	Query
1	55m39s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:16:41.576460', exp_date = '2025-01-06 11:01:41.576463', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
2	55m39s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:16:41.575841', exp_date = '2025-01-06 11:01:41.575845', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
3	54m36s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:17:44.423003', exp_date = '2025-01-06 11:02:44.423005', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
4	51m32s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:20:48.333316', exp_date = '2025-01-06 11:05:48.333319', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
5	51m26s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:20:55.276999', exp_date = '2025-01-06 11:05:55.277000', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
6	51m24s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:20:56.644197', exp_date = '2025-01-06 11:05:56.644201', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
7	51m19s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:21:01.409647', exp_date = '2025-01-06 11:06:01.409652', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
8	48m49s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:23:32.016108', exp_date = '2025-01-06 11:08:32.016112', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
9	48m49s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:23:32.205837', exp_date = '2025-01-06 11:08:32.205841', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
10	48m31s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:23:49.660552', exp_date = '2025-01-06 11:08:49.660555', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
11	45m3s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:27:17.379605', exp_date = '2025-01-06 11:12:17.379609', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
12	42m17s	update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:30:03.423944', exp_date = '2025-01-06 11:15:03.423948', logged_in = 'TRUE' where id = 1219; [ Date: 2025-01-06 12:12:21 ]
13	40m33s	update res_users set sid = '098fc2163f41da637f7a84b256dd537bb997e771', last_update = '2025-01-06 19:22:47.616579', exp_date = '2025-01-06 20:07:47.616584', logged_in = 'TRUE' where id = 931; [ Date: 2025-01-06 21:03:20 ]
14	40m33s	update res_users set sid = '098fc2163f41da637f7a84b256dd537bb997e771', last_update = '2025-01-06 19:22:47.615755', exp_date = '2025-01-06 20:07:47.615759', logged_in = 'TRUE' where id = 931; [ Date: 2025-01-06 21:03:20 ]
15	39m30s	update res_users set sid = '9c8ee29bbaeedbb4eb551f7c1009c9cc5faf1ca4', last_update = '2025-01-06 19:23:50.260496', exp_date = '2025-01-06 20:08:50.260499', logged_in = 'TRUE' where id = 1294; [ Date: 2025-01-06 21:03:20 ]
16	39m30s	update res_users set sid = '9c8ee29bbaeedbb4eb551f7c1009c9cc5faf1ca4', last_update = '2025-01-06 19:23:50.259940', exp_date = '2025-01-06 20:08:50.259943', logged_in = 'TRUE' where id = 1294; [ Date: 2025-01-06 21:03:20 ]
17	38m58s	update res_users set sid = '9c8ee29bbaeedbb4eb551f7c1009c9cc5faf1ca4', last_update = '2025-01-06 19:24:22.698473', exp_date = '2025-01-06 20:09:22.698476', logged_in = 'TRUE' where id = 1294; [ Date: 2025-01-06 21:03:20 ]
18	37m20s	update res_users set sid = '9c8ee29bbaeedbb4eb551f7c1009c9cc5faf1ca4', last_update = '2025-01-06 19:26:00.537868', exp_date = '2025-01-06 20:11:00.537872', logged_in = 'TRUE' where id = 1294; [ Date: 2025-01-06 21:03:20 ]
19	35m59s	update res_users set sid = '9c8ee29bbaeedbb4eb551f7c1009c9cc5faf1ca4', last_update = '2025-01-06 19:27:21.687508', exp_date = '2025-01-06 20:12:21.687512', logged_in = 'TRUE' where id = 1294; [ Date: 2025-01-06 21:03:20 ]
20	33m31s	update res_users set sid = 'f762882a9de886a2301b8e7a19cdb461af17d6f6', last_update = '2025-01-06 18:48:49.709578', exp_date = '2025-01-06 19:33:49.709582', logged_in = 'TRUE' where id = 876; [ Date: 2025-01-06 20:22:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d14h3m47s

75,808

Details

0ms

55m39s

4s87ms

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 06	00	768	11s221ms	14ms
	01	929	191ms	0ms
	02	1,018	217ms	0ms
	03	919	192ms	0ms
	04	528	110ms	0ms
	05	360	74ms	0ms
	06	659	137ms	0ms
	07	308	64ms	0ms
	08	1,568	1h17m51s	2s979ms
	09	4,723	5h9m11s	3s927ms
	10	7,111	9h54m	5s12ms
	11	7,028	1s783ms	0ms
	12	8,164	21h34m48s	9s516ms
	13	8,936	9h55m14s	3s996ms
	14	6,670	1h25m46s	771ms
	15	5,897	5h8m8s	3s135ms
	16	5,153	1h41m19s	1s179ms
	17	3,933	52m52s	806ms
	18	3,449	6h38m24s	6s930ms
	19	2,954	6h59m51s	8s527ms
	20	1,812	5h22m54s	10s692ms
	21	1,769	6h38m42s	13s523ms
	22	1,152	3h24m28s	10s649ms

update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:16:41.576460', exp_date = '2025-01-06 11:01:41.576463', logged_in = 'TRUE' where id = 1219;

Date: 2025-01-06 12:12:21 Duration: 55m39s
update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:16:41.575841', exp_date = '2025-01-06 11:01:41.575845', logged_in = 'TRUE' where id = 1219;

Date: 2025-01-06 12:12:21 Duration: 55m39s
update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:17:44.423003', exp_date = '2025-01-06 11:02:44.423005', logged_in = 'TRUE' where id = 1219;

Date: 2025-01-06 12:12:21 Duration: 54m36s

2

1d12h39m15s

245,730

Details

429ms

4s68ms

536ms

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 06	00	4,375	35m55s	492ms
	01	5,376	44m9s	492ms
	02	8,841	1h12m46s	493ms
	03	6,090	50m31s	497ms
	04	3,986	32m21s	487ms
	05	4,734	39m29s	500ms
	06	4,864	40m17s	497ms
	07	1,734	13m57s	483ms
	08	3,125	25m28s	489ms
	09	10,311	1h26m2s	500ms
	10	14,998	2h14m2s	536ms
	11	14,081	2h5m33s	534ms
	12	19,130	3h1m54s	570ms
	13	13,127	1h59m28s	546ms
	14	12,522	1h50m59s	531ms
	15	13,895	2h10m34s	563ms
	16	18,541	3h2m50s	591ms
	17	12,969	2h2m25s	566ms
	18	18,887	2h53m35s	551ms
	19	24,318	3h42m27s	548ms
	20	13,663	1h57m34s	516ms
	21	9,249	1h18m29s	509ms
	22	6,914	58m22s	506ms

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

Date: 2025-01-06 19:16:05 Duration: 4s68ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4251193)) AND (("shipping_track"."id" not in (35004312, 35004312)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 16:13:44 Duration: 3s760ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4253559)) AND (("shipping_track"."id" not in (35023500, 35023500)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 17:32:27 Duration: 3s743ms

3

9h13m

135,582

Details

176ms

1s121ms

244ms

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 06	00	1,448	5m26s	225ms
	01	1,680	6m20s	226ms
	02	2,914	11m3s	227ms
	03	3,101	11m48s	228ms
	04	1,713	6m28s	226ms
	05	1,896	7m9s	226ms
	06	1,357	5m5s	225ms
	07	714	2m40s	225ms
	08	1,825	6m59s	229ms
	09	3,362	13m8s	234ms
	10	4,283	17m54s	250ms
	11	8,346	35m2s	251ms
	12	8,200	35m10s	257ms
	13	9,035	37m59s	252ms
	14	7,537	31m10s	248ms
	15	18,371	1h21m15s	265ms
	16	7,586	34m51s	275ms
	17	15,360	1h4m22s	251ms
	18	14,136	54m13s	230ms
	19	14,198	54m4s	228ms
	20	8,008	29m	217ms
	21	229	46s945ms	205ms
	22	283	56s968ms	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" = '9630779')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-06 16:14:51 Duration: 1s121ms
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" = '8974470')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-06 16:13:04 Duration: 529ms
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" = '9562789')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-06 16:13:31 Duration: 472ms

4

6h33m

42,593

Details

439ms

4s380ms

553ms

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 06	00	229	1m57s	512ms
	01	572	4m49s	505ms
	02	299	2m40s	537ms
	03	123	1m10s	574ms
	04	148	1m18s	531ms
	05	81	45s650ms	563ms
	06	203	1m48s	534ms
	07	139	1m10s	503ms
	08	831	6m56s	500ms
	09	2,623	22m35s	516ms
	10	3,691	33m50s	550ms
	11	3,574	32m51s	551ms
	12	4,644	45m17s	585ms
	13	3,554	33m15s	561ms
	14	3,374	30m47s	547ms
	15	3,144	30m9s	575ms
	16	4,093	40m12s	589ms
	17	2,864	26m13s	549ms
	18	3,159	29m1s	551ms
	19	2,435	22m30s	554ms
	20	1,076	9m14s	515ms
	21	940	7m49s	499ms
	22	797	6m33s	494ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4175576, 4161688, 4161684, 4161680, 4161677, 4161673, 4161669, 4161666, 4161664, 4161662, 4161661, 4161658, 4161657, 4161655, 4161654, 4161652, 4161651, 4161649, 4161648, 4161646, 4161644, 4161643, 4161642, 4161640, 4161639, 4161637, 4161636, 4161634, 4161632, 4161631, 4161629, 4161628, 4161626, 4161625, 4161623, 4161622, 4161620, 4161619, 4161617, 4161616, 4161614, 4161613, 4161611, 4161609, 4161606, 4161603, 4161600, 4161597, 4161594, 4161591, 4161588, 4161587, 4161585, 4161584, 4161582, 4161581, 4161579, 4161578, 4161577, 4161575, 4161574, 4161571, 4161570, 4161568, 4161567, 4161565, 4161564, 4161562, 4161561, 4161559, 4161558, 4161556, 4161555, 4161553, 4161552, 4161551, 4161549, 4161547, 4161546, 4161544, 4161543, 4161541, 4161540, 4161538, 4161536, 4161534, 4161532, 4161530, 4161528, 4161526, 4161524, 4161522, 4161521, 4161464, 4161461, 4161459, 4161456, 4161454, 4161453, 4161452, 4161451, 4161450, 4161449, 4161448, 4161447, 4161446, 4161445, 4161443, 4161441, 4161439, 4161438, 4161436, 4161434, 4161432, 4161430, 4161429, 4161427, 4161425, 4161423, 4161421, 4161419, 4161417, 4161413, 4161410, 4161406, 4161403, 4161399, 4161397, 4161396, 4161393, 4161392, 4161390, 4161388, 4161386, 4161385, 4161383, 4161381, 4161380, 4161379, 4161377, 4161375, 4161374, 4161372, 4161370, 4161368, 4161367, 4161364, 4161363, 4161361, 4161360, 4161357, 4161356, 4161354, 4161352, 4161350, 4161349, 4161345, 4161341, 4161338, 4161335, 4161334, 4161332, 4161330, 4161326, 4161325, 4161322, 4161320, 4161317, 4161315, 4161311, 4161308, 4161307, 4161302, 4161300, 4161296, 4161295, 4161290, 4161288, 4161284, 4161283, 4161277, 4161276, 4161270, 4161268, 4161263, 4161262, 4161258, 4161257, 4161252, 4161248, 4161243, 4161239, 4161234, 4161230, 4161226, 4161223, 4161219, 4161216, 4161213, 4161211)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 16:13:35 Duration: 4s380ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4166549)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 19:16:05 Duration: 3s603ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3896289, 3896285, 3896242, 3896215, 3896213, 3896211, 3896209, 3896207, 3896205, 3896202, 3896200)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 12:41:14 Duration: 3s356ms

5

3h33m24s

51,110

Details

96ms

825ms

250ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 06	00	972	4m10s	258ms
	01	1,078	4m4s	227ms
	02	1,130	4m42s	249ms
	03	1,208	5m2s	250ms
	04	304	1m36s	316ms
	05	1,768	7m44s	262ms
	06	1,428	5m48s	243ms
	07	16	4s10ms	250ms
	08	6	736ms	122ms
	09	102	25s225ms	247ms
	10	750	2m43s	217ms
	11	178	39s210ms	220ms
	12	670	3m3s	274ms
	13	1,106	5m3s	274ms
	14	1,010	4m16s	254ms
	15	1,448	6m4s	251ms
	16	2,658	12m14s	276ms
	17	7,900	35m4s	266ms
	18	5,006	21m37s	259ms
	19	5,646	24m6s	256ms
	20	6,420	26m10s	244ms
	21	6,055	22m35s	223ms
	22	4,251	16m6s	227ms

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

Date: 2025-01-06 16:13:35 Duration: 825ms
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-06 19:25:08 Duration: 809ms
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-06 19:25:08 Duration: 806ms

6

2h44m11s

9,695

Details

25ms

1s888ms

1s16ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 06	00	148	2m24s	976ms
	01	117	1m52s	964ms
	02	114	1m50s	972ms
	04	108	1m42s	952ms
	06	8	7s591ms	948ms
	07	1	926ms	926ms
	10	14	15s221ms	1s87ms
	11	36	35s765ms	993ms
	12	83	1m33s	1s131ms
	13	258	4m42s	1s96ms
	14	252	4m35s	1s94ms
	15	416	7m44s	1s115ms
	16	818	15m28s	1s135ms
	17	912	16m9s	1s62ms
	18	1,263	22m50s	1s84ms
	19	1,600	25m58s	974ms
	20	1,902	29m57s	945ms
	21	936	15m15s	977ms
	22	709	11m3s	936ms

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

Date: 2025-01-06 16:13:38 Duration: 1s888ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9840152')) 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 (52))))))) 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 (52)))))) 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 (52)))))) 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 (52))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-06 16:13:37 Duration: 1s802ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9836122')) 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 (53))))))) 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 (53)))))) 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 (53)))))) 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 (53))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-06 16:13:34 Duration: 1s726ms

7

2h14m3s

25,347

Details

208ms

692ms

317ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 06	08	775	3m34s	276ms
	09	597	2m56s	296ms
	10	1,361	6m45s	298ms
	11	3,036	15m27s	305ms
	12	3,138	16m52s	322ms
	13	3,892	20m52s	321ms
	14	2,669	14m19s	322ms
	15	3,498	18m58s	325ms
	16	4,686	25m18s	324ms
	17	202	1m13s	364ms
	18	873	4m19s	297ms
	19	620	3m23s	328ms

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

Date: 2025-01-06 16:32:18 Duration: 692ms
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" = '9773399')))) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:32:17 Duration: 642ms
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" = '9773383')))) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:32:17 Duration: 609ms

8

1h53m14s

138,770

Details

31ms

283ms

48ms

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

Day	Hour	Count	Duration	Avg duration
Jan 06	00	2,006	1m34s	47ms
	01	2,336	1m49s	47ms
	02	3,144	2m27s	47ms
	03	2,120	1m40s	47ms
	04	950	45s139ms	47ms
	05	1,068	49s858ms	46ms
	06	2,239	1m45s	46ms
	07	740	35s108ms	47ms
	08	2,287	1m49s	47ms
	09	6,895	5m33s	48ms
	10	11,064	9m24s	51ms
	11	11,632	9m51s	50ms
	12	14,591	13m6s	53ms
	13	10,831	9m20s	51ms
	14	10,314	8m37s	50ms
	15	8,990	7m53s	52ms
	16	9,025	8m16s	55ms
	17	8,297	6m22s	46ms
	18	8,894	6m30s	43ms
	19	7,211	5m21s	44ms
	20	4,769	3m17s	41ms
	21	4,827	3m15s	40ms
	22	4,540	3m3s	40ms

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

Date: 2025-01-06 19:15:55 Duration: 283ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4219507, 4216999, 4216670, 4214253, 4211883, 4205327, 4202896, 4201738, 4193889, 4192960, 4182460, 4170512, 4088826, 4011696)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-06 16:15:04 Duration: 266ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4221232)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-06 16:15:03 Duration: 211ms

9

1h42m55s

349

Details

0ms

16m33s

17s696ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 06	00	6	1ms	0ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	04	2	1ms	0ms
	05	1	1ms	1ms
	06	2	0ms	0ms
	07	1	0ms	0ms
	08	10	1ms	0ms
	09	42	30m54s	44s159ms
	10	36	4m54s	8s191ms
	11	33	12ms	0ms
	12	32	4m39s	8s738ms
	13	36	2m35s	4s332ms
	14	24	17ms	0ms
	15	21	26ms	1ms
	16	29	2m53s	5s993ms
	17	8	2m43s	20s487ms
	18	14	14ms	1ms
	19	20	31m25s	1m34s
	20	14	19m27s	1m23s
	21	9	9ms	1ms
	22	7	3m19s	28s522ms

UPDATE "res_users" SET "exp_date" = '2025-01-06 19:09:47.446781', "last_update" = '2025-01-06 18:24:47.446812', "sid" = 'fcf8fa229590f2116b8c2096ba29e7a769fe6b12', "write_date" = '2025-01-06 18:24:47.025131', "write_uid" = 1 WHERE id IN (878);

Date: 2025-01-06 19:41:21 Duration: 16m33s
UPDATE "res_users" SET "exp_date" = '2025-01-06 19:17:24.869794', "last_update" = '2025-01-06 18:32:24.869817', "sid" = '0fb6b294b98e8259954c330b089ee3e8602be2b8', "write_date" = '2025-01-06 18:32:24.508899', "write_uid" = 1 WHERE id IN (878);

Date: 2025-01-06 19:41:21 Duration: 8m56s
UPDATE "res_users" SET "exp_date" = '2025-01-06 08:48:22.869205', "last_update" = '2025-01-06 08:03:22.869228', "sid" = '88a81e27d9fc0bcf1e6d0341bbead9f08f7ee688', "write_date" = '2025-01-06 08:03:22.537732', "write_uid" = 1 WHERE id IN (822);

Date: 2025-01-06 09:11:21 Duration: 7m58s

10

1h30m47s

16,242

Details

230ms

748ms

335ms

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 06	00	344	1m50s	319ms
	01	434	2m17s	317ms
	02	460	2m28s	322ms
	03	612	3m17s	322ms
	04	52	16s541ms	318ms
	05	892	4m43s	317ms
	06	712	3m48s	321ms
	07	7	2s235ms	319ms
	08	5	1s590ms	318ms
	09	51	16s349ms	320ms
	10	376	2m17s	365ms
	11	61	20s748ms	340ms
	12	268	1m46s	397ms
	13	310	1m56s	377ms
	14	261	1m34s	360ms
	15	317	1m59s	375ms
	16	525	3m25s	391ms
	17	3,080	17m55s	349ms
	18	1,286	7m22s	344ms
	19	1,265	7m22s	349ms
	20	1,349	7m14s	322ms
	21	2,144	11m3s	309ms
	22	1,431	7m25s	311ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9567978')) 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-06 16:13:37 Duration: 748ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9787980')) 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-06 16:15:03 Duration: 742ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9768513')) 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-06 16:13:39 Duration: 714ms

11

51m13s

53,027

Details

43ms

307ms

57ms

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 06	00	10	538ms	53ms
	02	1	56ms	56ms
	04	3	168ms	56ms
	06	3	161ms	53ms
	07	8	426ms	53ms
	08	1,046	55s390ms	52ms
	09	1,506	1m22s	54ms
	10	2,970	2m46s	56ms
	11	5,021	4m41s	56ms
	12	8,051	8m7s	60ms
	13	8,601	8m12s	57ms
	14	5,472	5m3s	55ms
	15	7,033	6m53s	58ms
	16	5,967	6m10s	62ms
	17	2,745	2m33s	55ms
	18	2,108	2m1s	57ms
	19	1,769	1m44s	58ms
	20	347	19s319ms	55ms
	21	201	11s136ms	55ms
	22	165	9s291ms	56ms

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

Date: 2025-01-06 16:14:51 Duration: 307ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4196757) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:13:37 Duration: 298ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4210893) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:15:02 Duration: 295ms

12

45m12s

11,310

Details

180ms

474ms

239ms

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 06	00	6	1s358ms	226ms
	01	144	32s503ms	225ms
	02	69	15s615ms	226ms
	03	884	3m23s	230ms
	04	289	1m5s	226ms
	05	896	3m23s	226ms
	06	853	3m12s	225ms
	07	625	2m21s	225ms
	08	229	52s286ms	228ms
	09	745	2m54s	234ms
	10	792	3m20s	253ms
	11	893	3m41s	247ms
	12	1,087	4m47s	264ms
	13	644	2m42s	252ms
	14	1,414	5m45s	243ms
	15	329	1m19s	241ms
	16	446	2m3s	277ms
	17	77	19s778ms	256ms
	18	120	24s694ms	205ms
	19	111	26s296ms	236ms
	20	222	49s868ms	224ms
	21	203	41s718ms	205ms
	22	232	47s146ms	203ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9833103')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) 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-06 16:13:32 Duration: 474ms
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" = '9769738')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) 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-06 16:14:44 Duration: 416ms
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" = '9758814')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) 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-06 16:13:37 Duration: 413ms

13

38m30s

10,192

Details

182ms

271ms

226ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1,436	5m23s	225ms
	01	1,536	5m47s	226ms
	02	2,809	10m39s	227ms
	03	2,203	8m21s	227ms
	04	1,402	5m17s	226ms
	05	664	2m29s	225ms
	06	95	21s402ms	225ms
	22	47	9s175ms	195ms

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

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

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

Date: 2025-01-06 04:56:12 Duration: 265ms

14

37m49s

20,357

Details

86ms

629ms

111ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 06	00	78	7s654ms	98ms
	01	19	1s882ms	99ms
	04	4	390ms	97ms
	08	141	15s35ms	106ms
	09	947	1m39s	104ms
	10	2,727	5m1s	110ms
	11	1,790	3m16s	109ms
	12	2,271	4m22s	115ms
	13	1,789	3m17s	110ms
	14	2,050	3m42s	108ms
	15	2,244	4m10s	111ms
	16	1,966	3m53s	118ms
	17	1,003	1m55s	115ms
	18	1,626	2m57s	109ms
	19	919	1m45s	115ms
	20	496	51s582ms	103ms
	21	164	16s819ms	102ms
	22	123	12s858ms	104ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7938179)) AND (("cash_track"."id" not in (6612922, 6630507, 6643395, 6672525, 6672637, 6672637)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-06 17:27:40 Duration: 629ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7919475)) AND (("cash_track"."id" not in (6477359, 6492602, 6494836, 6672628, 6672641, 6672641)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-06 17:27:41 Duration: 377ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7944859)) AND (("cash_track"."id" not in (6669134)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-06 16:13:38 Duration: 275ms

15

19m41s

46

Details

0ms

9m1s

25s683ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 06	03	1	1ms	1ms
	08	2	0ms	0ms
	09	3	1m19s	26s502ms
	10	7	7m56s	1m8s
	11	5	2ms	0ms
	12	3	1m23s	27s737ms
	13	2	1ms	0ms
	14	4	9m1s	2m15s
	17	4	4ms	1ms
	18	4	2ms	0ms
	20	2	3ms	1ms
	21	7	5ms	0ms
	22	2	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-06 14:33:19.258401', "last_update" = '2025-01-06 13:48:19.258425', "write_date" = '2025-01-06 13:48:18.895724', "write_uid" = 1 WHERE id IN (889);

Date: 2025-01-06 14:57:20 Duration: 9m1s
UPDATE "res_users" SET "exp_date" = '2025-01-06 09:38:45.484641', "last_update" = '2025-01-06 08:53:45.484672', "write_date" = '2025-01-06 08:53:45.116178', "write_uid" = 1 WHERE id IN (1390);

Date: 2025-01-06 10:01:11 Duration: 7m26s
UPDATE "res_users" SET "exp_date" = '2025-01-06 12:15:57.985523', "last_update" = '2025-01-06 11:30:57.985555', "write_date" = '2025-01-06 11:30:57.537146', "write_uid" = 869 WHERE id IN (869);

Date: 2025-01-06 12:32:21 Duration: 1m23s

16

19m7s

4,668

Details

200ms

429ms

245ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 06	00	6	1s328ms	221ms
	05	312	1m11s	228ms
	06	409	1m32s	226ms
	07	89	19s943ms	224ms
	08	186	42s448ms	228ms
	09	617	2m24s	234ms
	10	1,215	4m58s	245ms
	11	146	37s924ms	259ms
	12	75	19s164ms	255ms
	13	681	2m54s	256ms
	14	321	1m17s	242ms
	15	137	37s624ms	274ms
	16	239	1m10s	296ms
	17	123	29s486ms	239ms
	18	112	28s920ms	258ms

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

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

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

Date: 2025-01-06 16:13:07 Duration: 423ms

17

17m55s

20,644

Details

38ms

105ms

52ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 06	08	393	18s843ms	47ms
	09	638	31s560ms	49ms
	10	1,312	1m6s	50ms
	11	2,726	2m20s	51ms
	12	2,594	2m17s	52ms
	13	2,968	2m31s	51ms
	14	2,946	2m28s	50ms
	15	3,107	2m42s	52ms
	16	1,770	1m42s	57ms
	17	760	39s203ms	51ms
	18	930	47s766ms	51ms
	19	500	28s129ms	56ms

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

Date: 2025-01-06 11:23:56 Duration: 105ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4163410) ORDER BY "collection_policy"."id";

Date: 2025-01-06 11:23:56 Duration: 101ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3646128) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:13:35 Duration: 100ms

18

14m57s

6,123

Details

120ms

376ms

146ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 06	02	35	4s647ms	132ms
	08	131	17s393ms	132ms
	09	422	58s416ms	138ms
	10	1,087	2m40s	147ms
	11	1,104	2m39s	144ms
	12	817	2m8s	156ms
	13	883	2m8s	145ms
	14	542	1m17s	143ms
	15	272	41s388ms	152ms
	16	129	20s382ms	158ms
	17	107	15s859ms	148ms
	18	127	19s108ms	150ms
	19	297	42s762ms	143ms
	20	76	10s428ms	137ms
	21	50	6s749ms	134ms
	22	44	5s782ms	131ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 119)) 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-06 11:23:57 Duration: 376ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 22)) 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-06 16:13:45 Duration: 342ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 65)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-06 16:15:00 Duration: 309ms

19

14m25s

2,764

Details

16ms

984ms

313ms

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

Day	Hour	Count	Duration	Avg duration
Jan 06	00	8	171ms	21ms
	01	7	1s249ms	178ms
	04	3	849ms	283ms
	07	4	866ms	216ms
	08	68	13s482ms	198ms
	09	151	43s688ms	289ms
	10	236	1m4s	273ms
	11	279	1m24s	303ms
	12	330	1m48s	328ms
	13	382	2m9s	338ms
	14	354	2m1s	342ms
	15	262	1m32s	353ms
	16	269	1m12s	268ms
	17	104	34s848ms	335ms
	18	115	39s922ms	347ms
	19	101	28s862ms	285ms
	20	57	21s42ms	369ms
	21	23	5s765ms	250ms
	22	11	1s605ms	145ms

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 (41)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) 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-06 12:40:59 Duration: 984ms
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 (119)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (119))))) 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-06 16:32:17 Duration: 923ms
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-06 16:29:32 Duration: 828ms

20

11m52s

367

Details

12ms

4s325ms

1s940ms

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

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1	3s125ms	3s125ms
	01	3	9s362ms	3s120ms
	04	2	6s98ms	3s49ms
	08	5	157ms	31ms
	09	68	16s355ms	240ms
	10	57	18s52ms	316ms
	11	13	11s334ms	871ms
	13	27	1m6s	2s471ms
	14	29	1m14s	2s558ms
	15	24	1m21s	3s405ms
	16	34	1m36s	2s833ms
	17	16	46s933ms	2s933ms
	18	28	1m35s	3s401ms
	19	18	1m1s	3s417ms
	20	30	1m39s	3s305ms
	21	7	13s357ms	1s908ms
	22	5	12s600ms	2s520ms

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

Date: 2025-01-06 16:36:28 Duration: 4s325ms
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 (44))))))) 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 (44)))))) 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 (44)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) 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 (44))))))))) 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 (44)))))))) AND ("policy_number"."name"::text ilike '%9442608%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-06 17:50:56 Duration: 4s246ms
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 (22))))))) 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 (22)))))) 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 (22)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) 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 (22))))))))) 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 (22)))))))) AND ("policy_number"."name"::text ilike '%9566014%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-06 16:11:47 Duration: 4s201ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,516,936

Details

1m57s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 06	00	39,098	1s865ms	0ms
	01	46,449	2s275ms	0ms
	02	43,546	2s201ms	0ms
	03	33,222	1s517ms	0ms
	04	28,614	1s323ms	0ms
	05	22,799	1s1ms	0ms
	06	30,206	1s506ms	0ms
	07	23,518	977ms	0ms
	08	63,623	2s708ms	0ms
	09	139,412	5s581ms	0ms
	10	242,294	10s726ms	0ms
	11	215,336	11s619ms	0ms
	12	216,345	9s474ms	0ms
	13	221,705	9s123ms	0ms
	14	207,396	10s293ms	0ms
	15	196,284	9s517ms	0ms
	16	179,947	8s530ms	0ms
	17	144,423	6s815ms	0ms
	18	126,710	6s454ms	0ms
	19	109,769	5s215ms	0ms
	20	80,604	4s10ms	0ms
	21	60,470	2s865ms	0ms
	22	45,166	2s32ms	0ms

DISCARD ALL;

Date: 2025-01-06 14:18:03 Duration: 1ms
DISCARD ALL;

Date: 2025-01-06 12:28:17 Duration: 1ms
DISCARD ALL;

Date: 2025-01-06 11:37:45 Duration: 1ms

2

1,973,288

Details

27s778ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 06	00	29,194	429ms	0ms
	01	36,244	517ms	0ms
	02	33,314	502ms	0ms
	03	24,068	362ms	0ms
	04	21,085	319ms	0ms
	05	16,099	253ms	0ms
	06	24,397	365ms	0ms
	07	17,070	249ms	0ms
	08	49,233	634ms	0ms
	09	113,851	1s414ms	0ms
	10	205,818	2s590ms	0ms
	11	173,086	2s464ms	0ms
	12	173,806	2s310ms	0ms
	13	176,718	2s268ms	0ms
	14	159,532	2s176ms	0ms
	15	149,908	2s123ms	0ms
	16	138,763	2s44ms	0ms
	17	112,718	1s636ms	0ms
	18	98,001	1s584ms	0ms
	19	82,023	1s339ms	0ms
	20	58,963	952ms	0ms
	21	44,675	709ms	0ms
	22	34,722	528ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-06 10:14:23 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-06 11:01:13 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-06 12:59:23 Duration: 1ms

3

1,283,302

Details

12s930ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 06	00	20,286	185ms	0ms
	01	23,937	220ms	0ms
	02	22,487	212ms	0ms
	03	17,256	155ms	0ms
	04	14,988	137ms	0ms
	05	12,054	109ms	0ms
	06	15,812	149ms	0ms
	07	12,416	105ms	0ms
	08	32,772	290ms	0ms
	09	71,229	663ms	0ms
	10	122,837	1s176ms	0ms
	11	109,356	1s97ms	0ms
	12	109,727	1s158ms	0ms
	13	113,278	1s149ms	0ms
	14	105,279	1s22ms	0ms
	15	99,558	1s30ms	0ms
	16	91,248	972ms	0ms
	17	73,332	795ms	0ms
	18	64,342	705ms	0ms
	19	55,912	631ms	0ms
	20	41,084	424ms	0ms
	21	30,961	308ms	0ms
	22	23,151	228ms	0ms

ROLLBACK;

Date: 2025-01-06 11:32:06 Duration: 0ms
ROLLBACK;

Date: 2025-01-06 17:42:40 Duration: 0ms
ROLLBACK;

Date: 2025-01-06 12:41:11 Duration: 0ms

4

1,267,309

Details

3m39s

0ms

23ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 06	00	19,534	2s972ms	0ms
	01	23,190	3s606ms	0ms
	02	21,804	3s680ms	0ms
	03	16,576	2s661ms	0ms
	04	14,304	2s102ms	0ms
	05	11,391	1s730ms	0ms
	06	15,118	2s377ms	0ms
	07	11,734	1s526ms	0ms
	08	32,076	4s592ms	0ms
	09	70,425	11s647ms	0ms
	10	122,018	19s386ms	0ms
	11	109,020	17s389ms	0ms
	12	108,730	18s989ms	0ms
	13	111,599	18s897ms	0ms
	14	104,799	16s937ms	0ms
	15	98,998	17s33ms	0ms
	16	90,559	15s988ms	0ms
	17	72,737	13s879ms	0ms
	18	63,727	13s260ms	0ms
	19	55,297	11s905ms	0ms
	20	40,560	8s355ms	0ms
	21	30,374	5s902ms	0ms
	22	22,739	4s447ms	0ms

SELECT payload FROM http_sessions WHERE sid = '5906cadd3f1297a482b86a4b96162ef298ce8829';

Date: 2025-01-06 12:22:24 Duration: 23ms
SELECT payload FROM http_sessions WHERE sid = '83ebf66a5124b93a4bb9b3037d076834778979ea';

Date: 2025-01-06 17:21:57 Duration: 11ms
SELECT payload FROM http_sessions WHERE sid = 'dfbe287014a4a43571d4cd1ad9e22a86d6e7c575';

Date: 2025-01-06 17:21:57 Duration: 11ms

5

1,258,011

Details

1m51s

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 06	00	19,584	1s613ms	0ms
	01	23,290	1s923ms	0ms
	02	21,852	1s874ms	0ms
	03	16,691	1s351ms	0ms
	04	14,387	1s174ms	0ms
	05	11,477	924ms	0ms
	06	15,170	1s256ms	0ms
	07	11,841	888ms	0ms
	08	31,796	2s450ms	0ms
	09	69,588	5s815ms	0ms
	10	120,939	10s140ms	0ms
	11	107,593	9s133ms	0ms
	12	107,993	9s815ms	0ms
	13	110,602	9s805ms	0ms
	14	103,612	8s766ms	0ms
	15	98,112	8s869ms	0ms
	16	89,901	8s382ms	0ms
	17	72,209	7s70ms	0ms
	18	63,339	6s191ms	0ms
	19	54,858	5s405ms	0ms
	20	40,337	3s818ms	0ms
	21	30,252	2s779ms	0ms
	22	22,588	2s42ms	0ms

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

Date: 2025-01-06 12:20:49 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-06 16:12:47 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-06 16:21:30 Duration: 1ms

6

897,364

Details

2m14s

0ms

23ms

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 06	00	12,224	1s783ms	0ms
	01	16,738	2s449ms	0ms
	02	12,342	2s82ms	0ms
	03	7,682	1s393ms	0ms
	04	6,955	1s198ms	0ms
	05	4,266	850ms	0ms
	06	10,912	1s685ms	0ms
	07	5,575	955ms	0ms
	08	21,387	2s841ms	0ms
	09	57,420	7s195ms	0ms
	10	111,901	14s548ms	0ms
	11	84,139	13s740ms	0ms
	12	84,126	12s420ms	0ms
	13	82,920	11s463ms	0ms
	14	71,681	12s719ms	0ms
	15	64,753	9s696ms	0ms
	16	61,233	9s851ms	0ms
	17	50,789	7s543ms	0ms
	18	43,268	6s723ms	0ms
	19	33,028	5s217ms	0ms
	20	22,472	3s515ms	0ms
	21	17,028	2s898ms	0ms
	22	14,525	2s129ms	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 (1204);

Date: 2025-01-06 14:57:23 Duration: 23ms
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 (1204);

Date: 2025-01-06 14:57:23 Duration: 18ms
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 (1078);

Date: 2025-01-06 10:18:51 Duration: 17ms

7

688,556

Details

1m58s

0ms

54ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 06	00	8,906	1s511ms	0ms
	01	12,307	2s59ms	0ms
	02	10,829	2s22ms	0ms
	03	6,812	1s464ms	0ms
	04	6,096	1s244ms	0ms
	05	4,044	866ms	0ms
	06	8,586	1s426ms	0ms
	07	4,655	649ms	0ms
	08	16,417	2s347ms	0ms
	09	42,495	6s458ms	0ms
	10	82,744	11s164ms	0ms
	11	63,746	10s453ms	0ms
	12	63,752	11s482ms	0ms
	13	63,143	10s661ms	0ms
	14	54,215	9s196ms	0ms
	15	50,300	8s912ms	0ms
	16	47,467	8s549ms	0ms
	17	39,333	6s757ms	0ms
	18	33,580	6s586ms	0ms
	19	26,059	6s734ms	0ms
	20	17,827	3s562ms	0ms
	21	13,705	2s730ms	0ms
	22	11,538	2s35ms	0ms

COMMIT;

Date: 2025-01-06 10:14:16 Duration: 54ms
COMMIT;

Date: 2025-01-06 19:22:19 Duration: 39ms
COMMIT;

Date: 2025-01-06 19:20:11 Duration: 36ms

8

544,351

Details

1m11s

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 06	00	7,982	1s203ms	0ms
	01	12,495	2s212ms	0ms
	02	4,879	573ms	0ms
	03	3,527	381ms	0ms
	04	2,695	330ms	0ms
	05	1,547	136ms	0ms
	06	7,149	810ms	0ms
	07	2,792	351ms	0ms
	08	12,159	1s509ms	0ms
	09	35,263	4s745ms	0ms
	10	79,463	8s62ms	0ms
	11	51,274	7s326ms	0ms
	12	48,670	7s493ms	0ms
	13	43,677	6s647ms	0ms
	14	39,525	5s119ms	0ms
	15	35,908	4s723ms	0ms
	16	36,119	4s850ms	0ms
	17	32,672	4s219ms	0ms
	18	27,488	3s590ms	0ms
	19	21,796	3s36ms	0ms
	20	14,927	1s785ms	0ms
	21	12,359	1s328ms	0ms
	22	9,985	1s158ms	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 (5099885, 5102022, 5099382, 5099009, 5099263, 5135510, 5305353, 5100499, 5099415, 5099090, 5099413, 5466349, 5099162, 5099010, 5102203, 5105474, 5100477, 5100246, 5100004, 5103859, 5098981, 5100327, 5099006, 5100936, 5099158, 5100628, 5099272, 5099008, 5099873, 5099007, 5460531, 5099111, 5099244, 5099046, 5147051, 5099013, 5099581, 5099718, 5099243, 5100511, 5101238, 5113265, 5099737, 5100110, 5099914, 5099297, 5100196, 5100027, 5099182, 5100726, 5099644, 5116182, 5099037, 5099724, 5099356, 5099574, 5101283, 5099250, 5099287, 5125221, 5099815, 5099445, 5099174, 5122670, 5099095, 5107105, 5099540, 5108556, 5373963, 5105161, 5106118, 5114124, 5131606, 5127941, 5099102, 5109622, 5099254, 5101362, 5100774, 5103367, 5100273, 5105261, 5109858, 5099533, 5099855, 5099224, 5099264, 5099506, 5099333, 5103462, 5109326, 5099202, 5099119, 5099309, 5100431, 5099904, 5099275, 5386482, 5099500, 5099137, 5099144, 5099285, 5100714, 5113053, 5140302, 5099765, 5099296, 5101367, 5447551, 5099043, 5315205, 5099523, 5099035, 5100482, 5101243, 5099120, 5099818, 5100204, 5105078, 5463185, 5099014, 5100207, 5099026, 5130915, 5103109, 5099924, 5100578, 5099800, 5099577, 5100419, 5121195, 5100218, 5122374, 5102898, 5125639, 5101240, 5108495, 5101745, 5103477, 5099573, 5461833, 5235609, 5099693, 5099590, 5100111, 5099170, 5099134, 5099901, 5119981, 5099181, 5099788, 5126079, 5133072, 5099712, 5102186, 5455294, 5099403, 5099609, 5100610, 5100680, 5099169, 5382798, 5129649, 5099349, 5303507, 5100421, 5099669, 5099003, 5108202, 5099400, 5099039, 5099631, 5102372, 5099311, 5145640, 5153493, 5101540, 5463348, 5099138, 5099831, 5102413, 5099206, 5463422, 5101474, 5102955, 5099321, 5100762, 5119643, 5099759, 5110307, 5387659, 5127243);

Date: 2025-01-06 18:08:25 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 (5107437, 5099420, 5099007, 5106907, 5100700, 5099049, 5100111, 5182686, 5116739, 5099009, 5099382, 5109899, 5099404, 5099045, 5100506, 5103363, 5103802, 5101708, 5144724, 5099010, 5100630, 5112487, 5099441, 5099296, 5099646, 5099138, 5099349, 5099547, 5125313, 5099403, 5114663, 5099006, 5220821, 5224343, 5216990, 5099515);

Date: 2025-01-06 09:51:46 Duration: 15ms
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 (4332553, 4058833, 883014, 2663671, 2321019, 333733, 2662944, 2206546, 2337352, 2206568, 2663014, 2497731, 3975990, 1614775, 2341513, 15219, 1047859, 1352279, 113470, 1352053, 2321428, 2321023, 1352060, 2321623, 1368, 5017033, 2460213, 2497637, 2321948, 2497426, 2321445, 320921, 39588, 2321873, 2321286, 4671187, 1614794, 2321270, 463386, 2329850, 963452, 4798298, 5101077, 5099007, 5100738, 5099010, 5099719, 5099585, 5103284, 5100443, 5099169, 5099243, 5129857, 5099995, 5099409, 5100564, 5101209, 5099887, 5099646, 5099158, 5099045, 5099130, 5099009, 5099499, 5099309, 5107065, 5100658, 5181572, 5111309, 5099644, 5100832, 5099500, 5099144, 5112840, 5099138, 5100091, 5099550, 5099102, 5107748, 5099709, 5101631, 5099264, 5099248, 5103411, 5099200, 5099111, 5099013, 5099187, 5099515, 5100756, 5100004, 5100027, 5104205, 5099014, 5100935, 5099445, 5099275, 5103478, 5104276, 5099119, 5099333, 5099885, 5099181, 5099224, 5100511, 5099712, 5101149, 5100540, 5150519, 5111900, 5099920, 5103909, 5099760, 5100799, 5103287, 5100101, 5104173, 5104799, 5104297, 5174824, 5117459, 5099046, 5099112, 5123899, 5099028, 5178640, 5101122, 5099008, 5099577, 5100070, 5177886, 5100936, 5099174, 5177636, 5100901, 5099727);

Date: 2025-01-06 17:22:02 Duration: 10ms

9

538,920

Details

34s946ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 06	00	6,209	337ms	0ms
	01	9,573	525ms	0ms
	02	4,334	239ms	0ms
	03	2,571	144ms	0ms
	04	2,740	148ms	0ms
	05	1,337	84ms	0ms
	06	6,983	368ms	0ms
	07	3,529	165ms	0ms
	08	11,316	611ms	0ms
	09	33,921	1s970ms	0ms
	10	69,347	3s969ms	0ms
	11	51,310	3s170ms	0ms
	12	49,799	3s512ms	0ms
	13	47,654	3s305ms	0ms
	14	41,092	2s633ms	0ms
	15	39,569	2s761ms	0ms
	16	38,333	2s861ms	0ms
	17	32,237	2s257ms	0ms
	18	28,818	2s73ms	0ms
	19	22,033	1s555ms	0ms
	20	14,979	945ms	0ms
	21	11,409	688ms	0ms
	22	9,827	612ms	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 (128, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 16, 17, 19, 22, 24, 26, 27, 28, 30, 32, 35, 36, 38, 39, 40, 41, 42, 44, 46, 48, 49, 51, 53, 55, 60, 61, 62, 64, 65, 66, 67, 68, 70, 71, 73, 74, 75, 76, 77, 78, 79, 102, 110, 111, 113, 114, 115, 119, 121, 123, 127);

Date: 2025-01-06 21:11:04 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 (127);

Date: 2025-01-06 12:41:48 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 (27, 49, 32, 52, 95, 28, 61, 7, 128, 10, 71, 19, 110, 39, 113, 102, 16, 5, 11, 1, 17, 3, 2, 80, 36, 123, 8, 9, 42, 35, 44, 85, 78, 22, 30, 48, 70, 24, 38, 119, 64, 73, 65, 60, 126, 4, 127, 66, 67, 46, 6, 121, 115, 76, 68);

Date: 2025-01-06 11:52:36 Duration: 1ms

10

388,675

Details

2m5s

0ms

8ms

0ms

select r.id from ir_rule r join ir_model m on (r.model_id = m.id) where m.model = ? and r.active and r.perm_read and (r.id in ( select rule_group_id from rule_group_rel rg join res_groups_users_rel gu on (rg.group_id = gu.gid) where gu.uid = ?) or r.global) order by r.id;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1,934	586ms	0ms
	01	1,942	593ms	0ms
	02	2,148	684ms	0ms
	03	1,035	333ms	0ms
	04	1,034	314ms	0ms
	05	747	224ms	0ms
	06	1,358	409ms	0ms
	07	721	209ms	0ms
	08	9,184	2s628ms	0ms
	09	23,994	7s105ms	0ms
	10	38,674	12s50ms	0ms
	11	24,710	7s923ms	0ms
	12	42,556	14s45ms	0ms
	13	53,875	16s838ms	0ms
	14	28,185	9s188ms	0ms
	15	29,908	10s122ms	0ms
	16	34,130	11s997ms	0ms
	17	27,039	8s966ms	0ms
	18	23,264	7s734ms	0ms
	19	17,538	5s877ms	0ms
	20	10,427	3s173ms	0ms
	21	8,200	2s429ms	0ms
	22	6,072	1s816ms	0ms

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

Date: 2025-01-06 13:27:27 Duration: 8ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.users' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 898) OR r.global) ORDER BY r.id;

Date: 2025-01-06 16:23:28 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.company' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1296) OR r.global) ORDER BY r.id;

Date: 2025-01-06 19:16:18 Duration: 2ms

11

375,269

Details

1m10s

0ms

10ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 06	00	4,625	721ms	0ms
	01	5,675	967ms	0ms
	02	3,104	557ms	0ms
	03	1,816	343ms	0ms
	04	1,836	318ms	0ms
	05	1,040	166ms	0ms
	06	4,177	664ms	0ms
	07	2,693	385ms	0ms
	08	10,629	1s559ms	0ms
	09	26,738	4s432ms	0ms
	10	43,319	7s971ms	0ms
	11	34,531	6s357ms	0ms
	12	35,961	7s244ms	0ms
	13	36,366	6s973ms	0ms
	14	32,176	5s785ms	0ms
	15	28,049	5s470ms	0ms
	16	26,311	5s402ms	0ms
	17	21,714	4s391ms	0ms
	18	18,223	3s704ms	0ms
	19	13,389	2s788ms	0ms
	20	9,248	1s752ms	0ms
	21	7,246	1s291ms	0ms
	22	6,403	1s111ms	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 (8007442);

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

Date: 2025-01-06 17:34:12 Duration: 8ms
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 (8006455);

Date: 2025-01-06 10:37:22 Duration: 2ms

12

288,145

Details

52s329ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1,842	260ms	0ms
	01	1,644	223ms	0ms
	02	2,024	270ms	0ms
	03	1,424	180ms	0ms
	04	1,012	129ms	0ms
	05	967	122ms	0ms
	06	1,283	170ms	0ms
	07	1,331	166ms	0ms
	08	8,903	1s306ms	0ms
	09	19,096	3s70ms	0ms
	10	29,805	5s311ms	0ms
	11	17,632	3s14ms	0ms
	12	30,460	5s990ms	0ms
	13	39,085	7s468ms	0ms
	14	20,017	3s522ms	0ms
	15	20,265	3s842ms	0ms
	16	23,291	4s800ms	0ms
	17	18,501	3s549ms	0ms
	18	17,459	3s281ms	0ms
	19	13,563	2s619ms	0ms
	20	7,421	1s261ms	0ms
	21	6,765	1s65ms	0ms
	22	4,355	701ms	0ms

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

Date: 2025-01-06 16:23:28 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1083 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_shipping_policy' AND name = 'group_add_cash_policy' AND model = 'res.groups');

Date: 2025-01-06 18:38:03 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-06 16:27:25 Duration: 1ms

13

249,650

Details

1m7s

0ms

17ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 06	00	3,183	938ms	0ms
	01	5,034	2s338ms	0ms
	02	2,200	587ms	0ms
	03	1,643	417ms	0ms
	04	1,185	334ms	0ms
	05	1,227	293ms	0ms
	06	3,175	868ms	0ms
	07	1,174	317ms	0ms
	08	4,819	1s264ms	0ms
	09	14,380	4s109ms	0ms
	10	32,404	9s137ms	0ms
	11	21,380	5s688ms	0ms
	12	21,524	6s252ms	0ms
	13	19,974	5s837ms	0ms
	14	18,379	4s232ms	0ms
	15	17,419	4s57ms	0ms
	16	16,994	4s254ms	0ms
	17	16,745	4s292ms	0ms
	18	14,526	3s421ms	0ms
	19	11,055	2s967ms	0ms
	20	8,655	1s990ms	0ms
	21	6,807	1s658ms	0ms
	22	5,768	2s573ms	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 (41697852, 41698363, 41887166, 41790769, 41840347, 41552514, 41840352, 41886769, 41661932, 41839939, 41552513, 41839927, 41840009, 41839940, 41426257, 41791159, 41840350, 41661907, 41426083, 41661934, 41537680, 41426253, 41840004, 41552493, 41661939, 41698380, 41839917, 41839997, 41552522, 41426258, 41839926, 41839913, 41485283, 41790762, 41615455, 41839924, 41886758, 41756128, 41314843, 41380721, 41698383, 41615458, 41251732, 41426071, 41791160, 41698382, 41755644, 41755648, 41533014, 41120335, 41756063, 41426247, 41552512, 41533015, 41485517, 41533016, 41615482, 41615491, 41757594, 41897293, 41574789, 41615537, 41532999, 41615484, 41886757, 41756267, 41774126, 41839934, 41839925, 41874343, 41886767, 41661931, 41840000, 41757563, 41755649, 41839894, 41840080, 41552492, 41756119, 41724907, 41839660, 41757373, 41874347, 41755912, 41840342, 41839995, 41873769, 41791038, 41886765, 41873816, 41755960, 41839659, 41873950, 41757566, 41596334, 41757595, 41697899, 41596378, 41839936, 41756246, 41552494, 41755795, 41757552, 41702855, 41756127, 41873693, 41892198, 41757550, 41873768, 41552503, 41886766, 41886763, 41661940, 41065822, 41886764, 41873898, 41886768, 41755975, 41756092, 41925722, 41756122, 41757596, 41757481, 41757197, 41790988, 41756003, 41839668, 41816942, 41755714, 41816732, 41775304, 41816993, 41816771, 41755824, 41755743, 41816770, 41816780, 41757221, 41816919, 41816781, 41841268, 41755789, 41448389, 41816885, 41868305, 41633484, 41873734, 41816822, 41633479, 41873746, 41729103, 41314440, 41873694, 41755744, 41816870, 41816871, 41757477, 41841276, 41841277, 41841282, 41873725, 41757476, 41841275, 41841281, 41841279, 41757533, 41755731, 41596325, 41755736, 41724777, 41813306, 41724771, 41841269, 41633472, 40324541, 41753361, 41596385, 41596389, 41845563, 41633594, 41804558, 41633581, 41841265, 41841272, 41873688, 41729107, 41596386, 41633549, 41596382, 41841263, 41596379, 41681404, 41757300, 41841259, 41632995, 41753386, 41753385, 41841260, 41725042, 41596384, 41753374, 41596383, 41596375, 41753387, 41757016, 41753353, 41753379, 41632830, 41753372, 41728159, 41729104, 41596310, 41753381, 41753356, 41633463, 41632884, 41724902, 41596380, 41596315, 41725009, 41753369, 41633345, 41757095, 41633290, 41753375, 41753355, 41725051, 41753368, 41753367, 41596381, 41753378, 41753366, 41753360, 41753358, 41725005, 41757017, 41753373, 41753370, 41753346, 41681426, 41753347, 41596363, 41753363, 41753362, 41753352, 41535118, 41753354, 41596377, 41753351, 41596303, 41791424, 41596297, 41681412, 41139557, 41757119, 41596294, 41756688, 41596373, 41596376, 41596372, 41536119, 41536114, 41596187, 41536118, 41536121, 41536116, 41535736, 41412543, 41412562, 41197381, 40880652, 41535117, 41484783, 41534808, 41534809, 41197380, 41196973, 41066515, 41066516, 40847302, 40384636);

Date: 2025-01-06 09:51:46 Duration: 17ms
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 (41861280, 41963799, 41993604, 41951227, 41948522, 41927312, 41853955, 41943123, 41762723, 41872982, 41981960, 41938019, 41931732, 41873054, 41934145, 41870248, 42014721, 41860924, 41974396, 41917314, 41826188, 41959403, 41959669, 41771633, 41833021, 32661674, 41864458, 42003933, 41836213, 41697446, 41946741, 41898671, 41942506, 41906389, 41800170, 41952901, 41722140, 41491133, 41998362, 41970023, 41951119, 41951417, 32661728, 41745706, 41864028);

Date: 2025-01-06 17:21:58 Duration: 13ms
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 (39613497, 39769815, 39423184, 39931878, 39641987, 39668685, 40246284, 39956369, 39878822, 38557925, 41504196, 32589166, 39417115, 39956348, 39750167, 40012072, 38977619, 39684974, 39741853, 39853805, 39742445, 40246250, 39684886, 39918468, 39379175, 39932363, 39856944, 41504197, 39791280, 39641907, 40144841, 37644384, 41025964, 32595766, 39570092, 39684909, 40861792, 39665142, 39742084, 38937732, 39475572, 39804003, 32583155, 32579485, 40149113, 39714299, 40043232, 39609713, 40020929, 39533613, 39609725, 39533122, 39641662, 39511332, 39651015, 39651010, 39651016, 39651012, 39651019, 39650987, 39747247, 39747253, 39650983, 39747076, 39651052, 39747078, 39746946, 39746944, 39747080, 39747077, 39651071, 39927423, 39650973, 39650966, 39651091, 39208991, 39791498, 39747264, 38945533, 39774217, 39571798, 39571785, 39571782, 40661921, 39571786, 39571791, 39571801, 39541885, 39571797, 39202877, 39756342, 38921522, 39899538, 38921521, 39710417, 38921524, 38921533, 39710342, 39710346, 38921518);

Date: 2025-01-06 17:22:02 Duration: 11ms

14

245,730

Details

1d12h39m15s

429ms

4s68ms

536ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 06	00	4,375	35m55s	492ms
	01	5,376	44m9s	492ms
	02	8,841	1h12m46s	493ms
	03	6,090	50m31s	497ms
	04	3,986	32m21s	487ms
	05	4,734	39m29s	500ms
	06	4,864	40m17s	497ms
	07	1,734	13m57s	483ms
	08	3,125	25m28s	489ms
	09	10,311	1h26m2s	500ms
	10	14,998	2h14m2s	536ms
	11	14,081	2h5m33s	534ms
	12	19,130	3h1m54s	570ms
	13	13,127	1h59m28s	546ms
	14	12,522	1h50m59s	531ms
	15	13,895	2h10m34s	563ms
	16	18,541	3h2m50s	591ms
	17	12,969	2h2m25s	566ms
	18	18,887	2h53m35s	551ms
	19	24,318	3h42m27s	548ms
	20	13,663	1h57m34s	516ms
	21	9,249	1h18m29s	509ms
	22	6,914	58m22s	506ms

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

Date: 2025-01-06 19:16:05 Duration: 4s68ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4251193)) AND (("shipping_track"."id" not in (35004312, 35004312)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 16:13:44 Duration: 3s760ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4253559)) AND (("shipping_track"."id" not in (35023500, 35023500)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 17:32:27 Duration: 3s743ms

15

188,450

Details

16s263ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 06	00	2,620	183ms	0ms
	01	4,197	286ms	0ms
	02	1,581	128ms	0ms
	03	1,028	83ms	0ms
	04	982	73ms	0ms
	05	344	27ms	0ms
	06	2,386	174ms	0ms
	07	1,073	71ms	0ms
	08	4,381	306ms	0ms
	09	12,921	959ms	0ms
	10	27,540	2s143ms	0ms
	11	18,496	1s752ms	0ms
	12	17,610	1s858ms	0ms
	13	15,917	1s227ms	0ms
	14	14,597	1s92ms	0ms
	15	13,104	1s171ms	0ms
	16	12,618	1s166ms	0ms
	17	10,608	869ms	0ms
	18	9,040	853ms	0ms
	19	6,656	800ms	0ms
	20	4,425	447ms	0ms
	21	3,451	349ms	0ms
	22	2,875	234ms	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-06 17:21:58 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-06 17:21:58 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-06 15:32:00 Duration: 0ms

16

175,496

Details

1m43s

0ms

42ms

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

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1,184	1s244ms	1ms
	01	630	368ms	0ms
	02	320	164ms	0ms
	03	136	83ms	0ms
	04	232	111ms	0ms
	05	94	57ms	0ms
	06	490	200ms	0ms
	07	474	158ms	0ms
	08	2,187	1s125ms	0ms
	09	5,340	4s388ms	0ms
	10	7,599	9s250ms	1ms
	11	11,845	7s504ms	0ms
	12	12,688	9s46ms	0ms
	13	12,904	9s161ms	0ms
	14	11,686	7s17ms	0ms
	15	19,552	9s971ms	0ms
	16	15,982	8s773ms	0ms
	17	11,942	6s38ms	0ms
	18	19,073	9s118ms	0ms
	19	27,047	12s968ms	0ms
	20	10,892	5s430ms	0ms
	21	2,312	1s244ms	0ms
	22	887	497ms	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 (4121333, 4125749, 4211731, 4226658, 4238279, 4199643, 4218385, 4196619, 4125839, 4121097, 4158919, 4219545, 4152132, 3520948, 4212227, 4214303, 4206497, 3427866, 4209811, 4114604, 4191807, 4222375, 4249928, 4249927, 4207187, 4217863, 4196932, 3908666, 4217970, 4192203, 4217883, 3874894, 4154087, 4164805, 4197409, 4217999, 4217973, 4207186, 4197434, 3953095, 4210057, 4209580, 4209901, 4197918, 4129186, 3936500, 3881254, 4118470, 4179983, 4154057, 4202200, 4215732, 4204405, 4203344, 4191590, 4215976, 4200091, 4137886, 4145970, 4217995, 4154324, 4188516, 4200108, 4200085, 4175889, 4169418, 4168522, 3083285, 3940141, 3835317, 4176392, 4209425, 4214338, 4202924, 4167094, 4180371, 4198633, 4176399, 4205738, 4211734, 4201416, 4217921, 4205781, 4183932, 4207171, 4206391, 4202625, 4218369, 4215878, 4198527, 4186915, 4205243, 4203402, 4206165, 4208806, 4156328, 4217720, 4203734, 4108154, 4020904, 4097327, 4023144, 4199057, 4217906, 4202930, 4200425, 4198259, 4200227, 4140123, 4172160, 4142388, 4156069, 4191346, 4156095, 4169945, 4217926, 4151020, 4195913, 4201058, 4152198, 4208837, 4217997, 4194753, 4186592, 4211809, 4165395, 4207910, 4216395, 4203917, 4128854, 4209420, 4178962, 3935015, 4185873, 4172993, 4087576, 4050518, 3728179, 4105597, 3873510, 4176942, 4087698, 4095733, 4110723, 4151911, 4194623, 4190329, 4196443, 4185725, 4130025, 4062286, 3895913, 4099074, 4131264, 4099689, 4065109, 4102249, 4031191, 4195981, 4203832, 4201403, 4214979, 4198151, 4182441, 4100591, 4206102, 4170580, 4193934, 4051364, 4206430, 4205207, 4197534, 4179907, 4204580, 4079997, 4145531, 4218935, 4212380, 4219382, 4203134, 4199619, 4212299, 4190649, 4163362, 4182221, 4123831);

Date: 2025-01-06 17:21:58 Duration: 42ms
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 (4251829);

Date: 2025-01-06 17:21:58 Duration: 19ms
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 (4134932, 4136592, 4159315, 4186808, 4197716, 4202131, 4203367, 4203871, 4207756, 4209953, 4215942, 4161160, 4228522, 4208988, 4231857, 4209224, 4238109, 4218474, 4238638, 4228056, 4241788, 4238878, 4241811, 4243127, 4247996, 4248234, 4207839, 4216166, 4174144, 4222474, 4222686, 4203248, 4222022, 4218377, 4205603, 4218384, 4204184, 4206745, 4206034, 4198201, 4244341, 4225932, 4199184, 4158985, 4225811, 4220253, 4084557, 4219140, 4011965, 4202386, 4212393, 4241667, 4227648, 4236403, 4234652, 4238686, 4233345, 4243996, 4245061, 4234582, 4237892, 4228331, 4170543, 4238942, 4203851, 4245353, 4236097, 4244003, 4224461, 4168209, 4239677, 4237176, 4235043, 4234991, 4160667, 4244314, 4207062, 4210768, 4211824, 4215630, 4223273, 4223572, 4224511, 4226537, 4234948, 4235278, 4238636, 4242778, 4247968, 4098388, 4158669, 4198664, 4107099, 4212003, 4149632, 4229875, 4169764, 4236739, 4203428, 4207784, 4230318, 4232152, 4241665, 4216402, 4198452, 4193108, 4196130, 4199008, 4193938, 3952821, 4102856, 4104665, 4114101, 4154658, 4165075, 4176658, 4190294, 4195363, 4205613, 4206287, 4206573, 4207654, 4210463, 4215195, 4218140, 4241325, 4241727, 4247980, 4223423, 4237377, 4228096, 4218242, 4185898, 4133069, 4199574, 4226477, 4226635, 4228602, 4215874, 4229058, 4215332, 4229186, 4181807, 4232275, 4053100, 4239361, 4231563, 4106181, 4175874, 4226507, 4123182, 4138746, 4161831, 4185701, 4185718, 4186401, 4191582, 4191831, 4192519, 4193931, 4194862, 4196889, 4197817, 4198127, 4199579, 4200223, 4202382, 4204027, 4205537, 4205548, 4205614, 4206440, 4208314, 4208350, 4209406, 4209657, 4214862, 4215107, 4215129, 4217194, 4217207, 4217208, 4218129, 4218133, 4218145, 4218153, 4222477, 4222544, 4222578, 4222579, 4219728, 4204769, 4193887);

Date: 2025-01-06 17:22:01 Duration: 18ms

17

167,665

Details

10s27ms

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 06	00	820	40ms	0ms
	01	814	41ms	0ms
	02	839	44ms	0ms
	03	419	21ms	0ms
	04	371	18ms	0ms
	05	278	14ms	0ms
	06	529	27ms	0ms
	07	316	15ms	0ms
	08	4,013	203ms	0ms
	09	10,756	577ms	0ms
	10	17,092	994ms	0ms
	11	10,089	577ms	0ms
	12	18,009	1s142ms	0ms
	13	24,351	1s463ms	0ms
	14	11,937	701ms	0ms
	15	12,692	791ms	0ms
	16	14,733	974ms	0ms
	17	11,371	700ms	0ms
	18	10,042	616ms	0ms
	19	7,585	486ms	0ms
	20	4,510	249ms	0ms
	21	3,423	181ms	0ms
	22	2,676	142ms	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 (21);

Date: 2025-01-06 14:28:36 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 (2, 10);

Date: 2025-01-06 12:41:22 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 (94);

Date: 2025-01-06 16:11:47 Duration: 0ms

18

161,947

Details

20s623ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 06	00	803	85ms	0ms
	01	801	86ms	0ms
	02	836	93ms	0ms
	03	413	44ms	0ms
	04	369	39ms	0ms
	05	269	28ms	0ms
	06	513	56ms	0ms
	07	312	32ms	0ms
	08	3,921	417ms	0ms
	09	10,576	1s187ms	0ms
	10	16,583	2s50ms	0ms
	11	9,712	1s187ms	0ms
	12	17,666	2s381ms	0ms
	13	23,275	2s972ms	0ms
	14	11,453	1s436ms	0ms
	15	12,329	1s648ms	0ms
	16	14,409	2s76ms	0ms
	17	10,914	1s432ms	0ms
	18	9,546	1s249ms	0ms
	19	7,254	985ms	0ms
	20	4,300	495ms	0ms
	21	3,068	340ms	0ms
	22	2,625	292ms	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-06 16:27:17 Duration: 2ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-06 12:42:00 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 (94) 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-06 16:11:47 Duration: 1ms

19

143,839

Details

10s855ms

0ms

2ms

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

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1,932	90ms	0ms
	01	3,915	174ms	0ms
	02	2,180	110ms	0ms
	03	1,465	67ms	0ms
	04	1,391	61ms	0ms
	05	607	31ms	0ms
	06	2,573	105ms	0ms
	07	909	44ms	0ms
	08	3,661	222ms	0ms
	09	8,123	583ms	0ms
	10	24,407	1s432ms	0ms
	11	11,090	722ms	0ms
	12	12,199	1s135ms	0ms
	13	13,013	1s264ms	0ms
	14	8,828	680ms	0ms
	15	8,671	754ms	0ms
	16	9,043	885ms	0ms
	17	8,668	722ms	0ms
	18	7,139	636ms	0ms
	19	5,266	515ms	0ms
	20	3,332	243ms	0ms
	21	2,758	188ms	0ms
	22	2,669	181ms	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-06 16:27:17 Duration: 2ms
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-06 16:22:30 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 (117, 118, 77, 81, 67, 52, 46, 36, 115);

Date: 2025-01-06 12:02:03 Duration: 1ms

20

139,954

Details

29s688ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 06	00	733	138ms	0ms
	01	776	146ms	0ms
	02	781	152ms	0ms
	03	441	83ms	0ms
	04	397	77ms	0ms
	05	284	52ms	0ms
	06	561	107ms	0ms
	07	327	58ms	0ms
	08	3,466	636ms	0ms
	09	9,141	1s757ms	0ms
	10	14,685	2s990ms	0ms
	11	9,168	1s908ms	0ms
	12	15,442	3s378ms	0ms
	13	19,388	4s91ms	0ms
	14	9,943	2s114ms	0ms
	15	10,585	2s334ms	0ms
	16	12,019	2s808ms	0ms
	17	9,022	1s973ms	0ms
	18	8,033	1s751ms	0ms
	19	6,280	1s420ms	0ms
	20	3,576	738ms	0ms
	21	2,627	521ms	0ms
	22	2,279	444ms	0ms

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

Date: 2025-01-06 16:11:47 Duration: 3ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1290) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-06 13:27:21 Duration: 1ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1055) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-06 11:45:48 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

9m1s

25s683ms

46

Details

19m41s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 06	03	1	1ms	1ms
	08	2	0ms	0ms
	09	3	1m19s	26s502ms
	10	7	7m56s	1m8s
	11	5	2ms	0ms
	12	3	1m23s	27s737ms
	13	2	1ms	0ms
	14	4	9m1s	2m15s
	17	4	4ms	1ms
	18	4	2ms	0ms
	20	2	3ms	1ms
	21	7	5ms	0ms
	22	2	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-06 14:33:19.258401', "last_update" = '2025-01-06 13:48:19.258425', "write_date" = '2025-01-06 13:48:18.895724', "write_uid" = 1 WHERE id IN (889);

Date: 2025-01-06 14:57:20 Duration: 9m1s
UPDATE "res_users" SET "exp_date" = '2025-01-06 09:38:45.484641', "last_update" = '2025-01-06 08:53:45.484672', "write_date" = '2025-01-06 08:53:45.116178', "write_uid" = 1 WHERE id IN (1390);

Date: 2025-01-06 10:01:11 Duration: 7m26s
UPDATE "res_users" SET "exp_date" = '2025-01-06 12:15:57.985523', "last_update" = '2025-01-06 11:30:57.985555', "write_date" = '2025-01-06 11:30:57.537146', "write_uid" = 869 WHERE id IN (869);

Date: 2025-01-06 12:32:21 Duration: 1m23s

2

0ms

16m33s

17s696ms

349

Details

1h42m55s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 06	00	6	1ms	0ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	04	2	1ms	0ms
	05	1	1ms	1ms
	06	2	0ms	0ms
	07	1	0ms	0ms
	08	10	1ms	0ms
	09	42	30m54s	44s159ms
	10	36	4m54s	8s191ms
	11	33	12ms	0ms
	12	32	4m39s	8s738ms
	13	36	2m35s	4s332ms
	14	24	17ms	0ms
	15	21	26ms	1ms
	16	29	2m53s	5s993ms
	17	8	2m43s	20s487ms
	18	14	14ms	1ms
	19	20	31m25s	1m34s
	20	14	19m27s	1m23s
	21	9	9ms	1ms
	22	7	3m19s	28s522ms

UPDATE "res_users" SET "exp_date" = '2025-01-06 19:09:47.446781', "last_update" = '2025-01-06 18:24:47.446812', "sid" = 'fcf8fa229590f2116b8c2096ba29e7a769fe6b12', "write_date" = '2025-01-06 18:24:47.025131', "write_uid" = 1 WHERE id IN (878);

Date: 2025-01-06 19:41:21 Duration: 16m33s
UPDATE "res_users" SET "exp_date" = '2025-01-06 19:17:24.869794', "last_update" = '2025-01-06 18:32:24.869817', "sid" = '0fb6b294b98e8259954c330b089ee3e8602be2b8', "write_date" = '2025-01-06 18:32:24.508899', "write_uid" = 1 WHERE id IN (878);

Date: 2025-01-06 19:41:21 Duration: 8m56s
UPDATE "res_users" SET "exp_date" = '2025-01-06 08:48:22.869205', "last_update" = '2025-01-06 08:03:22.869228', "sid" = '88a81e27d9fc0bcf1e6d0341bbead9f08f7ee688', "write_date" = '2025-01-06 08:03:22.537732', "write_uid" = 1 WHERE id IN (822);

Date: 2025-01-06 09:11:21 Duration: 7m58s

3

0ms

55m39s

4s87ms

75,808

Details

3d14h3m47s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 06	00	768	11s221ms	14ms
	01	929	191ms	0ms
	02	1,018	217ms	0ms
	03	919	192ms	0ms
	04	528	110ms	0ms
	05	360	74ms	0ms
	06	659	137ms	0ms
	07	308	64ms	0ms
	08	1,568	1h17m51s	2s979ms
	09	4,723	5h9m11s	3s927ms
	10	7,111	9h54m	5s12ms
	11	7,028	1s783ms	0ms
	12	8,164	21h34m48s	9s516ms
	13	8,936	9h55m14s	3s996ms
	14	6,670	1h25m46s	771ms
	15	5,897	5h8m8s	3s135ms
	16	5,153	1h41m19s	1s179ms
	17	3,933	52m52s	806ms
	18	3,449	6h38m24s	6s930ms
	19	2,954	6h59m51s	8s527ms
	20	1,812	5h22m54s	10s692ms
	21	1,769	6h38m42s	13s523ms
	22	1,152	3h24m28s	10s649ms

update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:16:41.576460', exp_date = '2025-01-06 11:01:41.576463', logged_in = 'TRUE' where id = 1219;

Date: 2025-01-06 12:12:21 Duration: 55m39s
update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:16:41.575841', exp_date = '2025-01-06 11:01:41.575845', logged_in = 'TRUE' where id = 1219;

Date: 2025-01-06 12:12:21 Duration: 55m39s
update res_users set sid = 'e9e2fb277537b1cca3f2658460c6c4baa6f3b14d', last_update = '2025-01-06 10:17:44.423003', exp_date = '2025-01-06 11:02:44.423005', logged_in = 'TRUE' where id = 1219;

Date: 2025-01-06 12:12:21 Duration: 54m36s

4

12ms

4s325ms

1s940ms

367

Details

11m52s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1	3s125ms	3s125ms
	01	3	9s362ms	3s120ms
	04	2	6s98ms	3s49ms
	08	5	157ms	31ms
	09	68	16s355ms	240ms
	10	57	18s52ms	316ms
	11	13	11s334ms	871ms
	13	27	1m6s	2s471ms
	14	29	1m14s	2s558ms
	15	24	1m21s	3s405ms
	16	34	1m36s	2s833ms
	17	16	46s933ms	2s933ms
	18	28	1m35s	3s401ms
	19	18	1m1s	3s417ms
	20	30	1m39s	3s305ms
	21	7	13s357ms	1s908ms
	22	5	12s600ms	2s520ms

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

Date: 2025-01-06 16:36:28 Duration: 4s325ms
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 (44))))))) 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 (44)))))) 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 (44)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) 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 (44))))))))) 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 (44)))))))) AND ("policy_number"."name"::text ilike '%9442608%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-06 17:50:56 Duration: 4s246ms
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 (22))))))) 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 (22)))))) 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 (22)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) 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 (22))))))))) 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 (22)))))))) AND ("policy_number"."name"::text ilike '%9566014%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-06 16:11:47 Duration: 4s201ms

5

25ms

1s888ms

1s16ms

9,695

Details

2h44m11s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 06	00	148	2m24s	976ms
	01	117	1m52s	964ms
	02	114	1m50s	972ms
	04	108	1m42s	952ms
	06	8	7s591ms	948ms
	07	1	926ms	926ms
	10	14	15s221ms	1s87ms
	11	36	35s765ms	993ms
	12	83	1m33s	1s131ms
	13	258	4m42s	1s96ms
	14	252	4m35s	1s94ms
	15	416	7m44s	1s115ms
	16	818	15m28s	1s135ms
	17	912	16m9s	1s62ms
	18	1,263	22m50s	1s84ms
	19	1,600	25m58s	974ms
	20	1,902	29m57s	945ms
	21	936	15m15s	977ms
	22	709	11m3s	936ms

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

Date: 2025-01-06 16:13:38 Duration: 1s888ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9840152')) 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 (52))))))) 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 (52)))))) 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 (52)))))) 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 (52))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-06 16:13:37 Duration: 1s802ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9836122')) 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 (53))))))) 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 (53)))))) 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 (53)))))) 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 (53))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-06 16:13:34 Duration: 1s726ms

6

439ms

4s380ms

553ms

42,593

Details

6h33m

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 06	00	229	1m57s	512ms
	01	572	4m49s	505ms
	02	299	2m40s	537ms
	03	123	1m10s	574ms
	04	148	1m18s	531ms
	05	81	45s650ms	563ms
	06	203	1m48s	534ms
	07	139	1m10s	503ms
	08	831	6m56s	500ms
	09	2,623	22m35s	516ms
	10	3,691	33m50s	550ms
	11	3,574	32m51s	551ms
	12	4,644	45m17s	585ms
	13	3,554	33m15s	561ms
	14	3,374	30m47s	547ms
	15	3,144	30m9s	575ms
	16	4,093	40m12s	589ms
	17	2,864	26m13s	549ms
	18	3,159	29m1s	551ms
	19	2,435	22m30s	554ms
	20	1,076	9m14s	515ms
	21	940	7m49s	499ms
	22	797	6m33s	494ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4175576, 4161688, 4161684, 4161680, 4161677, 4161673, 4161669, 4161666, 4161664, 4161662, 4161661, 4161658, 4161657, 4161655, 4161654, 4161652, 4161651, 4161649, 4161648, 4161646, 4161644, 4161643, 4161642, 4161640, 4161639, 4161637, 4161636, 4161634, 4161632, 4161631, 4161629, 4161628, 4161626, 4161625, 4161623, 4161622, 4161620, 4161619, 4161617, 4161616, 4161614, 4161613, 4161611, 4161609, 4161606, 4161603, 4161600, 4161597, 4161594, 4161591, 4161588, 4161587, 4161585, 4161584, 4161582, 4161581, 4161579, 4161578, 4161577, 4161575, 4161574, 4161571, 4161570, 4161568, 4161567, 4161565, 4161564, 4161562, 4161561, 4161559, 4161558, 4161556, 4161555, 4161553, 4161552, 4161551, 4161549, 4161547, 4161546, 4161544, 4161543, 4161541, 4161540, 4161538, 4161536, 4161534, 4161532, 4161530, 4161528, 4161526, 4161524, 4161522, 4161521, 4161464, 4161461, 4161459, 4161456, 4161454, 4161453, 4161452, 4161451, 4161450, 4161449, 4161448, 4161447, 4161446, 4161445, 4161443, 4161441, 4161439, 4161438, 4161436, 4161434, 4161432, 4161430, 4161429, 4161427, 4161425, 4161423, 4161421, 4161419, 4161417, 4161413, 4161410, 4161406, 4161403, 4161399, 4161397, 4161396, 4161393, 4161392, 4161390, 4161388, 4161386, 4161385, 4161383, 4161381, 4161380, 4161379, 4161377, 4161375, 4161374, 4161372, 4161370, 4161368, 4161367, 4161364, 4161363, 4161361, 4161360, 4161357, 4161356, 4161354, 4161352, 4161350, 4161349, 4161345, 4161341, 4161338, 4161335, 4161334, 4161332, 4161330, 4161326, 4161325, 4161322, 4161320, 4161317, 4161315, 4161311, 4161308, 4161307, 4161302, 4161300, 4161296, 4161295, 4161290, 4161288, 4161284, 4161283, 4161277, 4161276, 4161270, 4161268, 4161263, 4161262, 4161258, 4161257, 4161252, 4161248, 4161243, 4161239, 4161234, 4161230, 4161226, 4161223, 4161219, 4161216, 4161213, 4161211)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 16:13:35 Duration: 4s380ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4166549)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 19:16:05 Duration: 3s603ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3896289, 3896285, 3896242, 3896215, 3896213, 3896211, 3896209, 3896207, 3896205, 3896202, 3896200)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 12:41:14 Duration: 3s356ms

7

429ms

4s68ms

536ms

245,730

Details

1d12h39m15s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 06	00	4,375	35m55s	492ms
	01	5,376	44m9s	492ms
	02	8,841	1h12m46s	493ms
	03	6,090	50m31s	497ms
	04	3,986	32m21s	487ms
	05	4,734	39m29s	500ms
	06	4,864	40m17s	497ms
	07	1,734	13m57s	483ms
	08	3,125	25m28s	489ms
	09	10,311	1h26m2s	500ms
	10	14,998	2h14m2s	536ms
	11	14,081	2h5m33s	534ms
	12	19,130	3h1m54s	570ms
	13	13,127	1h59m28s	546ms
	14	12,522	1h50m59s	531ms
	15	13,895	2h10m34s	563ms
	16	18,541	3h2m50s	591ms
	17	12,969	2h2m25s	566ms
	18	18,887	2h53m35s	551ms
	19	24,318	3h42m27s	548ms
	20	13,663	1h57m34s	516ms
	21	9,249	1h18m29s	509ms
	22	6,914	58m22s	506ms

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

Date: 2025-01-06 19:16:05 Duration: 4s68ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4251193)) AND (("shipping_track"."id" not in (35004312, 35004312)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 16:13:44 Duration: 3s760ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4253559)) AND (("shipping_track"."id" not in (35023500, 35023500)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-06 17:32:27 Duration: 3s743ms

8

230ms

748ms

335ms

16,242

Details

1h30m47s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 06	00	344	1m50s	319ms
	01	434	2m17s	317ms
	02	460	2m28s	322ms
	03	612	3m17s	322ms
	04	52	16s541ms	318ms
	05	892	4m43s	317ms
	06	712	3m48s	321ms
	07	7	2s235ms	319ms
	08	5	1s590ms	318ms
	09	51	16s349ms	320ms
	10	376	2m17s	365ms
	11	61	20s748ms	340ms
	12	268	1m46s	397ms
	13	310	1m56s	377ms
	14	261	1m34s	360ms
	15	317	1m59s	375ms
	16	525	3m25s	391ms
	17	3,080	17m55s	349ms
	18	1,286	7m22s	344ms
	19	1,265	7m22s	349ms
	20	1,349	7m14s	322ms
	21	2,144	11m3s	309ms
	22	1,431	7m25s	311ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9567978')) 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-06 16:13:37 Duration: 748ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9787980')) 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-06 16:15:03 Duration: 742ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9768513')) 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-06 16:13:39 Duration: 714ms

9

208ms

692ms

317ms

25,347

Details

2h14m3s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 06	08	775	3m34s	276ms
	09	597	2m56s	296ms
	10	1,361	6m45s	298ms
	11	3,036	15m27s	305ms
	12	3,138	16m52s	322ms
	13	3,892	20m52s	321ms
	14	2,669	14m19s	322ms
	15	3,498	18m58s	325ms
	16	4,686	25m18s	324ms
	17	202	1m13s	364ms
	18	873	4m19s	297ms
	19	620	3m23s	328ms

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

Date: 2025-01-06 16:32:18 Duration: 692ms
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" = '9773399')))) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:32:17 Duration: 642ms
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" = '9773383')))) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:32:17 Duration: 609ms

10

16ms

984ms

313ms

2,764

Details

14m25s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 06	00	8	171ms	21ms
	01	7	1s249ms	178ms
	04	3	849ms	283ms
	07	4	866ms	216ms
	08	68	13s482ms	198ms
	09	151	43s688ms	289ms
	10	236	1m4s	273ms
	11	279	1m24s	303ms
	12	330	1m48s	328ms
	13	382	2m9s	338ms
	14	354	2m1s	342ms
	15	262	1m32s	353ms
	16	269	1m12s	268ms
	17	104	34s848ms	335ms
	18	115	39s922ms	347ms
	19	101	28s862ms	285ms
	20	57	21s42ms	369ms
	21	23	5s765ms	250ms
	22	11	1s605ms	145ms

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 (41)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) 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-06 12:40:59 Duration: 984ms
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 (119)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (119))))) 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-06 16:32:17 Duration: 923ms
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-06 16:29:32 Duration: 828ms

11

96ms

825ms

250ms

51,110

Details

3h33m24s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 06	00	972	4m10s	258ms
	01	1,078	4m4s	227ms
	02	1,130	4m42s	249ms
	03	1,208	5m2s	250ms
	04	304	1m36s	316ms
	05	1,768	7m44s	262ms
	06	1,428	5m48s	243ms
	07	16	4s10ms	250ms
	08	6	736ms	122ms
	09	102	25s225ms	247ms
	10	750	2m43s	217ms
	11	178	39s210ms	220ms
	12	670	3m3s	274ms
	13	1,106	5m3s	274ms
	14	1,010	4m16s	254ms
	15	1,448	6m4s	251ms
	16	2,658	12m14s	276ms
	17	7,900	35m4s	266ms
	18	5,006	21m37s	259ms
	19	5,646	24m6s	256ms
	20	6,420	26m10s	244ms
	21	6,055	22m35s	223ms
	22	4,251	16m6s	227ms

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

Date: 2025-01-06 16:13:35 Duration: 825ms
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-06 19:25:08 Duration: 809ms
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-06 19:25:08 Duration: 806ms

12

200ms

429ms

245ms

4,668

Details

19m7s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 06	00	6	1s328ms	221ms
	05	312	1m11s	228ms
	06	409	1m32s	226ms
	07	89	19s943ms	224ms
	08	186	42s448ms	228ms
	09	617	2m24s	234ms
	10	1,215	4m58s	245ms
	11	146	37s924ms	259ms
	12	75	19s164ms	255ms
	13	681	2m54s	256ms
	14	321	1m17s	242ms
	15	137	37s624ms	274ms
	16	239	1m10s	296ms
	17	123	29s486ms	239ms
	18	112	28s920ms	258ms

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

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

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

Date: 2025-01-06 16:13:07 Duration: 423ms

13

176ms

1s121ms

244ms

135,582

Details

9h13m

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 06	00	1,448	5m26s	225ms
	01	1,680	6m20s	226ms
	02	2,914	11m3s	227ms
	03	3,101	11m48s	228ms
	04	1,713	6m28s	226ms
	05	1,896	7m9s	226ms
	06	1,357	5m5s	225ms
	07	714	2m40s	225ms
	08	1,825	6m59s	229ms
	09	3,362	13m8s	234ms
	10	4,283	17m54s	250ms
	11	8,346	35m2s	251ms
	12	8,200	35m10s	257ms
	13	9,035	37m59s	252ms
	14	7,537	31m10s	248ms
	15	18,371	1h21m15s	265ms
	16	7,586	34m51s	275ms
	17	15,360	1h4m22s	251ms
	18	14,136	54m13s	230ms
	19	14,198	54m4s	228ms
	20	8,008	29m	217ms
	21	229	46s945ms	205ms
	22	283	56s968ms	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" = '9630779')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-06 16:14:51 Duration: 1s121ms
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" = '8974470')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-06 16:13:04 Duration: 529ms
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" = '9562789')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-06 16:13:31 Duration: 472ms

14

180ms

474ms

239ms

11,310

Details

45m12s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 06	00	6	1s358ms	226ms
	01	144	32s503ms	225ms
	02	69	15s615ms	226ms
	03	884	3m23s	230ms
	04	289	1m5s	226ms
	05	896	3m23s	226ms
	06	853	3m12s	225ms
	07	625	2m21s	225ms
	08	229	52s286ms	228ms
	09	745	2m54s	234ms
	10	792	3m20s	253ms
	11	893	3m41s	247ms
	12	1,087	4m47s	264ms
	13	644	2m42s	252ms
	14	1,414	5m45s	243ms
	15	329	1m19s	241ms
	16	446	2m3s	277ms
	17	77	19s778ms	256ms
	18	120	24s694ms	205ms
	19	111	26s296ms	236ms
	20	222	49s868ms	224ms
	21	203	41s718ms	205ms
	22	232	47s146ms	203ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9833103')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) 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-06 16:13:32 Duration: 474ms
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" = '9769738')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) 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-06 16:14:44 Duration: 416ms
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" = '9758814')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) 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-06 16:13:37 Duration: 413ms

15

182ms

271ms

226ms

10,192

Details

38m30s

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 06	00	1,436	5m23s	225ms
	01	1,536	5m47s	226ms
	02	2,809	10m39s	227ms
	03	2,203	8m21s	227ms
	04	1,402	5m17s	226ms
	05	664	2m29s	225ms
	06	95	21s402ms	225ms
	22	47	9s175ms	195ms

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

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

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

Date: 2025-01-06 04:56:12 Duration: 265ms

16

120ms

376ms

146ms

6,123

Details

14m57s

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 06	02	35	4s647ms	132ms
	08	131	17s393ms	132ms
	09	422	58s416ms	138ms
	10	1,087	2m40s	147ms
	11	1,104	2m39s	144ms
	12	817	2m8s	156ms
	13	883	2m8s	145ms
	14	542	1m17s	143ms
	15	272	41s388ms	152ms
	16	129	20s382ms	158ms
	17	107	15s859ms	148ms
	18	127	19s108ms	150ms
	19	297	42s762ms	143ms
	20	76	10s428ms	137ms
	21	50	6s749ms	134ms
	22	44	5s782ms	131ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 119)) 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-06 11:23:57 Duration: 376ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 22)) 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-06 16:13:45 Duration: 342ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 65)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-06 16:15:00 Duration: 309ms

17

86ms

629ms

111ms

20,357

Details

37m49s

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 06	00	78	7s654ms	98ms
	01	19	1s882ms	99ms
	04	4	390ms	97ms
	08	141	15s35ms	106ms
	09	947	1m39s	104ms
	10	2,727	5m1s	110ms
	11	1,790	3m16s	109ms
	12	2,271	4m22s	115ms
	13	1,789	3m17s	110ms
	14	2,050	3m42s	108ms
	15	2,244	4m10s	111ms
	16	1,966	3m53s	118ms
	17	1,003	1m55s	115ms
	18	1,626	2m57s	109ms
	19	919	1m45s	115ms
	20	496	51s582ms	103ms
	21	164	16s819ms	102ms
	22	123	12s858ms	104ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7938179)) AND (("cash_track"."id" not in (6612922, 6630507, 6643395, 6672525, 6672637, 6672637)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-06 17:27:40 Duration: 629ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7919475)) AND (("cash_track"."id" not in (6477359, 6492602, 6494836, 6672628, 6672641, 6672641)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-06 17:27:41 Duration: 377ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7944859)) AND (("cash_track"."id" not in (6669134)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-06 16:13:38 Duration: 275ms

18

43ms

307ms

57ms

53,027

Details

51m13s

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 06	00	10	538ms	53ms
	02	1	56ms	56ms
	04	3	168ms	56ms
	06	3	161ms	53ms
	07	8	426ms	53ms
	08	1,046	55s390ms	52ms
	09	1,506	1m22s	54ms
	10	2,970	2m46s	56ms
	11	5,021	4m41s	56ms
	12	8,051	8m7s	60ms
	13	8,601	8m12s	57ms
	14	5,472	5m3s	55ms
	15	7,033	6m53s	58ms
	16	5,967	6m10s	62ms
	17	2,745	2m33s	55ms
	18	2,108	2m1s	57ms
	19	1,769	1m44s	58ms
	20	347	19s319ms	55ms
	21	201	11s136ms	55ms
	22	165	9s291ms	56ms

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

Date: 2025-01-06 16:14:51 Duration: 307ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4196757) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:13:37 Duration: 298ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4210893) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:15:02 Duration: 295ms

19

38ms

105ms

52ms

20,644

Details

17m55s

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 06	08	393	18s843ms	47ms
	09	638	31s560ms	49ms
	10	1,312	1m6s	50ms
	11	2,726	2m20s	51ms
	12	2,594	2m17s	52ms
	13	2,968	2m31s	51ms
	14	2,946	2m28s	50ms
	15	3,107	2m42s	52ms
	16	1,770	1m42s	57ms
	17	760	39s203ms	51ms
	18	930	47s766ms	51ms
	19	500	28s129ms	56ms

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

Date: 2025-01-06 11:23:56 Duration: 105ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4163410) ORDER BY "collection_policy"."id";

Date: 2025-01-06 11:23:56 Duration: 101ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3646128) ORDER BY "collection_policy"."id";

Date: 2025-01-06 16:13:35 Duration: 100ms

20

31ms

283ms

48ms

138,770

Details

1h53m14s

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 06	00	2,006	1m34s	47ms
	01	2,336	1m49s	47ms
	02	3,144	2m27s	47ms
	03	2,120	1m40s	47ms
	04	950	45s139ms	47ms
	05	1,068	49s858ms	46ms
	06	2,239	1m45s	46ms
	07	740	35s108ms	47ms
	08	2,287	1m49s	47ms
	09	6,895	5m33s	48ms
	10	11,064	9m24s	51ms
	11	11,632	9m51s	50ms
	12	14,591	13m6s	53ms
	13	10,831	9m20s	51ms
	14	10,314	8m37s	50ms
	15	8,990	7m53s	52ms
	16	9,025	8m16s	55ms
	17	8,297	6m22s	46ms
	18	8,894	6m30s	43ms
	19	7,211	5m21s	44ms
	20	4,769	3m17s	41ms
	21	4,827	3m15s	40ms
	22	4,540	3m3s	40ms

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

Date: 2025-01-06 19:15:55 Duration: 283ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4219507, 4216999, 4216670, 4214253, 4211883, 4205327, 4202896, 4201738, 4193889, 4192960, 4182460, 4170512, 4088826, 4011696)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-06 16:15:04 Duration: 266ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4221232)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-06 16:15:03 Duration: 211ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

19,222,856 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	10	0.00%
DETAIL	10,199	0.05%
ERROR	8,369	0.04%
EVENTLOG	1,604	0.01%
FATAL	11,329	0.06%
HINT	8	0.00%
LOG	19,182,952	99.79%
STATEMENT	8,385	0.04%

Events distribution (except queries)

Key values

0 PANIC entries
11329 FATAL entries
8369 ERROR entries
0 WARNING entries
1604 EVENTLOG entries

Most Frequent Errors/Events

Key values

10,186 Max number of times the same event was reported
21,302 Total events found

Rank

Times reported

Error

1

10,186

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 06	00	3
	02	563
	03	1,779
	04	1,907
	05	2,030
	06	1,853
	07	1,856
	08	38
	19	154
	20	3

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

2

4,342

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 06	00	12
	01	40
	02	14
	03	6
	04	2
	05	1
	06	4
	07	3
	08	60
	09	347
	10	338
	11	404
	12	563
	13	1,016
	14	447
	15	292
	16	247
	17	195
	18	143
	19	123
	20	44
	21	20
	22	21

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

3

4,002

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 06	00	12
	01	36
	02	12
	03	5
	04	2
	05	1
	06	4
	07	2
	08	58
	09	333
	10	324
	11	367
	12	549
	13	972
	14	411
	15	240
	16	200
	17	181
	18	116
	19	97
	20	40
	21	19
	22	21

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

4

1,027

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 06	08	28
	09	77
	10	148
	12	231
	13	232
	14	30
	15	31
	16	54
	17	29
	18	46
	19	48
	20	27
	21	19
	22	27

5

1,027

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 06	08	28
	09	77
	10	148
	12	231
	13	232
	14	30
	15	31
	16	54
	17	29
	18	46
	19	48
	20	27
	21	19
	22	27

6

393

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 06	08	4
	09	29
	10	81
	12	95
	13	88
	14	7
	15	1
	16	14
	17	4
	18	17
	19	21
	20	10
	21	13
	22	9

7

183

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 06	08	3
	09	10
	10	43
	12	40
	13	46
	14	1
	16	4
	17	2
	18	12
	19	6
	20	3
	21	10
	22	3

8

80

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 06	17	80

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

9

8

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 06	17	8

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

10

8

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 06	17	8

11

8

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 06	13	1
	15	5
	16	1
	18	1

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

12

7

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 06	11	1
	13	4
	17	2

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

13

5

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 06	09	1
	12	1
	13	1
	15	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 "name" of relation "urgent_customer" violates not-null constraint

14

4

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 06	00	1
	09	1
	19	1
	20	1

15

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 06	00	1
	09	1
	19	1
	20	1

16

4

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 06	00	1
	09	1
	19	1
	20	1

17

4

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 06	09	4

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 06	11	2

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

19

2

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 06	17	2

20

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 06	16	1
	17	1

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

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 06	17	1

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

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 06	02	1

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 06	17	1

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Jan 06	14	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