pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Jan 7 23:47:16 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 40,447,852 log entries in 2m15s
Log start from 2025-01-07 00:00:00 to 2025-01-07 22:45:01

Global Stats

18,543 Number of unique normalized queries
17,348,843 Number of queries
5d17h51m5s Total query duration
2025-01-07 00:00:00 First query
2025-01-07 22:45:01 Last query
5,301 queries/s at 2025-01-07 14:18:12 Query peak

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

7,158 Number of events
23 Number of unique normalized events
2,867 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
17,348,843 Average queries per session
5d17h51m5s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

5,301 queries/s Query Peak
2025-01-07 14:18:12 Date

SELECT Traffic

Key values

3,560 queries/s Query Peak
2025-01-07 14:18:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,191 queries/s Query Peak
2025-01-07 11:06:13 Date

Queries duration

Key values

5d17h51m5s 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 07	00	285,000	0ms	1s41ms	22ms	3m36s	4m22s	5m47s
	01	271,215	0ms	1s892ms	21ms	2m45s	3m3s	3m57s
	02	277,272	0ms	59m59s	64ms	3m29s	4m16s	2h56m40s
	03	293,194	0ms	3m27s	34ms	4m1s	4m29s	43m39s
	04	262,192	0ms	59m56s	35ms	3m11s	3m25s	1h2m12s
	05	129,338	0ms	649ms	15ms	1m19s	1m43s	2m11s
	06	239,828	0ms	1s907ms	16ms	1m58s	2m51s	3m26s
	07	174,194	0ms	4s281ms	16ms	1m52s	1m56s	2m20s
	08	481,462	0ms	4s269ms	8ms	2m20s	2m45s	3m43s
	09	1,137,240	0ms	59m59s	34ms	6m23s	1h53m26s	2h33m20s
	10	1,465,292	0ms	4m56s	22ms	8m52s	1h1m35s	1h24m24s
	11	1,505,527	0ms	8s39ms	9ms	6m12s	7m42s	8m27s
	12	1,542,947	0ms	21m7s	18ms	7m47s	9m32s	3h45m15s
	13	1,463,897	0ms	43m24s	27ms	7m15s	9m19s	7h6m9s
	14	1,241,198	0ms	27m21s	28ms	6m57s	9m17s	5h50m54s
	15	1,239,358	0ms	52m9s	48ms	5m8s	6m13s	7h36m13s
	16	1,113,965	0ms	32m44s	55ms	4m20s	6m20s	7h34m17s
	17	1,142,091	0ms	15m59s	24ms	7m31s	24m50s	2h24m18s
	18	831,063	0ms	41s805ms	18ms	7m51s	9m23s	10m49s
	19	769,714	0ms	59m59s	55ms	9m46s	1h5m28s	3h41m55s
	20	782,858	0ms	6m58s	33ms	8m36s	10m50s	1h44m8s
	21	446,218	0ms	4s378ms	13ms	3m9s	3m30s	4m22s
	22	253,780	0ms	2s991ms	13ms	2m20s	2m24s	3m11s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 07	00	148,709	42ms	2m28s	3m36s	4m48s
	01	137,878	41ms	2m29s	2m44s	3m41s
	02	143,551	51ms	2m53s	3m22s	4m16s
	03	154,468	46ms	3m2s	3m44s	4m29s
	04	140,351	40ms	2m17s	2m51s	3m24s
	05	62,276	32ms	52s677ms	1m19s	1m55s
	06	131,799	30ms	1m35s	1m58s	2m53s
	07	90,839	31ms	1m7s	1m51s	2m19s
	08	279,109	15ms	2m3s	2m19s	2m45s
	09	681,399	19ms	5m2s	5m30s	6m21s
	10	875,589	19ms	6m25s	7m36s	8m50s
	11	855,623	17ms	4m56s	6m11s	8m6s
	12	908,131	16ms	6m9s	7m5s	9m30s
	13	870,316	16ms	4m52s	6m44s	8m32s
	14	718,504	17ms	4m31s	5m45s	9m14s
	15	738,893	14ms	4m23s	4m50s	6m4s
	16	649,324	15ms	4m	4m10s	5m31s
	17	707,219	22ms	6m10s	6m55s	8m1s
	18	476,104	31ms	5m48s	7m50s	9m30s
	19	455,911	33ms	5m28s	7m17s	9m44s
	20	467,801	42ms	6m50s	8m27s	10m49s
	21	249,256	23ms	2m16s	3m7s	3m41s
	22	138,227	24ms	1m59s	2m20s	3m10s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 07	00	24,297	5,521	174	0	0ms	159ms	211ms	295ms
	01	20,757	6,098	160	0	0ms	139ms	165ms	226ms
	02	28,268	7,172	139	0	296ms	165ms	220ms	312ms
	03	23,761	6,832	143	0	89ms	160ms	239ms	55s769ms
	04	19,493	5,546	151	0	143ms	139ms	176ms	302ms
	05	6,957	2,047	133	0	0ms	53ms	69ms	111ms
	06	18,224	4,417	139	0	0ms	101ms	135ms	273ms
	07	8,911	3,527	180	0	0ms	64ms	86ms	135ms
	08	15,383	5,817	327	0	0ms	117ms	143ms	210ms
	09	54,052	17,821	905	0	359ms	356ms	413ms	1h49m25s
	10	71,129	21,139	962	0	169ms	529ms	581ms	1h50s
	11	68,395	20,915	799	0	0ms	441ms	491ms	701ms
	12	64,095	21,384	672	3	157ms	431ms	542ms	8s905ms
	13	57,587	21,334	609	0	320ms	348ms	452ms	14s964ms
	14	52,312	19,007	603	0	307ms	311ms	473ms	1m18s
	15	43,173	17,243	646	0	809ms	268ms	323ms	542ms
	16	45,024	16,835	558	0	823ms	255ms	350ms	578ms
	17	61,377	18,031	643	2	156ms	505ms	666ms	20m51s
	18	56,247	20,466	574	0	0ms	384ms	466ms	712ms
	19	58,585	16,448	648	0	358ms	388ms	592ms	59m59s
	20	73,140	18,560	504	0	69ms	453ms	615ms	1m21s
	21	33,102	7,272	337	0	0ms	168ms	218ms	276ms
	22	15,934	4,139	168	0	0ms	97ms	132ms	211ms

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

150,919 buffers Checkpoint Peak
2025-01-07 12:01:27 Date
270.052 seconds Highest write time
0.394 seconds Sync time

Checkpoints Wal files

Key values

63 files Wal files usage Peak
2025-01-07 12:01:27 Date

Checkpoints distance

Key values

2,019.25 Mo Distance Peak
2025-01-07 12:01:27 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 07	00	111,618	3,239.562s	0.033s	3,239.641s
	01	158,598	3,239.602s	0.026s	3,239.686s
	02	143,887	3,239.586s	0.034s	3,239.658s
	03	178,221	3,239.56s	0.036s	3,239.647s
	04	153,273	3,239.566s	0.032s	3,239.647s
	05	84,675	3,094.516s	0.026s	3,094.582s
	06	106,533	3,239.598s	0.026s	3,239.668s
	07	92,461	3,239.493s	0.027s	3,239.563s
	08	132,661	3,100.576s	0.029s	3,100.646s
	09	394,633	3,239.547s	0.042s	3,239.656s
	10	511,567	3,239.403s	0.052s	3,239.56s
	11	505,353	3,239.574s	0.441s	3,240.1s
	12	632,410	3,239.109s	0.054s	3,239.253s
	13	441,325	3,239.478s	0.048s	3,239.603s
	14	406,733	3,239.557s	0.045s	3,239.682s
	15	334,286	3,239.448s	0.052s	3,239.571s
	16	315,982	3,239.588s	0.046s	3,239.709s
	17	265,903	2,884.114s	0.069s	2,884.241s
	18	247,117	3,239.519s	0.051s	3,239.63s
	19	272,959	3,239.465s	0.05s	3,239.579s
	20	315,478	3,239.527s	0.054s	3,239.648s
	21	201,721	3,239.579s	0.046s	3,239.68s
	22	90,510	2,429.636s	0.04s	2,429.711s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 07	00	50	3,317	0.002s	0.012s
	01	71	3,096	0.002s	0.012s
	02	65	3,398	0.002s	0.012s
	03	81	2,711	0.004s	0.012s
	04	67	3,165	0.002s	0.012s
	05	39	2,245	0.002s	0.012s
	06	47	2,590	0.002s	0.012s
	07	39	2,605	0.002s	0.012s
	08	54	3,290	0.002s	0.012s
	09	164	4,977	0.003s	0.012s
	10	221	5,092	0.003s	0.012s
	11	217	5,304	0.019s	0.012s
	12	262	5,408	0.003s	0.012s
	13	178	5,336	0.003s	0.012s
	14	162	5,321	0.002s	0.012s
	15	135	5,550	0.002s	0.012s
	16	127	5,504	0.003s	0.012s
	17	108	5,329	0.010s	0.012s
	18	106	5,139	0.002s	0.012s
	19	118	4,887	0.003s	0.012s
	20	139	4,955	0.003s	0.012s
	21	85	4,729	0.003s	0.012s
	22	39	3,305	0.002s	0.009s

Day	Hour	Avg time (sec)
Jan 07	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 07	00	68,130.83 kB	147,819.42 kB
	01	96,758.17 kB	139,790.50 kB
	02	88,839.00 kB	122,818.92 kB
	03	109,962.00 kB	137,344.75 kB
	04	91,957.83 kB	144,080.00 kB
	05	52,413.25 kB	101,772.67 kB
	06	64,652.92 kB	91,933.08 kB
	07	53,268.33 kB	74,764.08 kB
	08	73,996.83 kB	113,089.42 kB
	09	220,348.36 kB	240,186.36 kB
	10	300,708.67 kB	352,508.08 kB
	11	295,253.64 kB	367,393.27 kB
	12	358,119.08 kB	741,689.42 kB
	13	244,750.55 kB	388,155.82 kB
	14	220,996.58 kB	285,230.33 kB
	15	184,241.50 kB	249,112.42 kB
	16	170,489.91 kB	217,310.00 kB
	17	146,843.17 kB	196,653.67 kB
	18	145,186.33 kB	199,065.92 kB
	19	160,405.67 kB	205,744.92 kB
	20	190,596.75 kB	216,488.92 kB
	21	116,304.92 kB	204,947.17 kB
	22	69,551.78 kB	118,219.89 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 07	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 07	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

10,081,277 Total read queries
4,911,647 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,081,277	58.11%
INSERT	920,203	5.30%
UPDATE	287,571	1.66%
DELETE	10,174	0.06%
COPY FROM	5	0.00%
COPY TO	0	0.00%
CTE	21,406	0.12%
DDL	1,700	0.01%
TCL	3,670,588	21.16%
CURSOR	0	0.00%
OTHERS	2,355,919	13.58%

Queries by database

Key values

unknown Main database
17,348,843 Requests
5d17h51m5s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	17,348,843	5d17h51m5s
	copy from	5	3ms
	cte	21,406	4s669ms
	ddl	1,700	246ms
	delete	10,174	6s134ms
	insert	920,203	4m51s
	others	2,355,918	1m50s
	select	10,081,277	2d15h33m26s
	tcl	3,670,588	2m30s
	update	287,571	3d2h8m15s

Queries by user

Key values

unknown Main user
17,348,843 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	17,348,843	5d17h51m5s
	copy from	5	3ms
	cte	21,406	4s669ms
	ddl	1,700	246ms
	delete	10,174	6s134ms
	insert	920,203	4m51s
	others	2,355,918	1m50s
	select	10,081,277	2d15h33m26s
	tcl	3,670,588	2m30s
	update	287,571	3d2h8m15s

Duration by user

Key values

5d17h51m5s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	17,348,843	5d17h51m5s
	copy from	5	3ms
	cte	21,406	4s669ms
	ddl	1,700	246ms
	delete	10,174	6s134ms
	insert	920,203	4m51s
	others	2,355,918	1m50s
	select	10,081,277	2d15h33m26s
	tcl	3,670,588	2m30s
	update	287,571	3d2h8m15s

Queries by host

Key values

unknown Main host
17,348,843 Requests
5d17h51m5s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	17,348,843	5d17h51m5s
	copy from	5	3ms
	cte	21,406	4s669ms
	ddl	1,700	246ms
	delete	10,174	6s134ms
	insert	920,203	4m51s
	others	2,355,918	1m50s
	select	10,081,277	2d15h33m26s
	tcl	3,670,588	2m30s
	update	287,571	3d2h8m15s

Queries by application

Key values

unknown Main application
17,348,843 Requests
5d17h51m5s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	17,348,843	5d17h51m5s
	copy from	5	3ms
	cte	21,406	4s669ms
	ddl	1,700	246ms
	delete	10,174	6s134ms
	insert	920,203	4m51s
	others	2,355,918	1m50s
	select	10,081,277	2d15h33m26s
	tcl	3,670,588	2m30s
	update	287,571	3d2h8m15s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-07 20:26:20 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

16,225,752 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	16,225,752	93.53%
1-5ms	266,678	1.54%
5-10ms	15,072	0.09%
10-25ms	48,232	0.28%
25-50ms	150,940	0.87%
50-100ms	80,215	0.46%
100-500ms	411,528	2.37%
500-1000ms	147,525	0.85%
1000-10000ms	2,243	0.01%
> 10000ms	658	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '5b5191fdac0bf0b1436ef14f64d65baa3c54f34d', last_update = '2025-01-07 00:56:08.807803', exp_date = '2025-01-07 01:41:08.807805', logged_in = 'TRUE' where id = 1372; [ Date: 2025-01-07 02:56:08 ]
2	59m59s	update res_users set sid = '5b5191fdac0bf0b1436ef14f64d65baa3c54f34d', last_update = '2025-01-07 00:56:08.807797', exp_date = '2025-01-07 01:41:08.807800', logged_in = 'TRUE' where id = 1372; [ Date: 2025-01-07 02:56:08 ]
3	59m59s	update res_users set sid = '2fa23b723cee9ff223c52a72b0acb54f3dbd00d6', last_update = '2025-01-07 17:12:09.014711', exp_date = '2025-01-07 17:57:09.014714', logged_in = 'TRUE' where id = 1049; [ Date: 2025-01-07 19:12:08 ]
4	59m59s	UPDATE "res_users" SET "exp_date" = '2025-01-07 07:56:15.602814', "last_update" = '2025-01-07 07:11:15.602830', "write_date" = '2025-01-07 07:11:15.282912', "write_uid" = 1 WHERE id IN (951); [ Date: 2025-01-07 09:11:15 ]
5	59m56s	update res_users set sid = '780f3b756aa880f39da350eaf548a31e47d93900', last_update = '2025-01-07 02:54:26.586805', exp_date = '2025-01-07 03:39:26.586807', logged_in = 'TRUE' where id = 1004; [ Date: 2025-01-07 04:54:23 ]
6	58m40s	update res_users set sid = '00f03c77f2790cdf3cdb81e465939e2fae559a57', last_update = '2025-01-07 07:12:34.925168', exp_date = '2025-01-07 07:57:34.925171', logged_in = 'TRUE' where id = 951; [ Date: 2025-01-07 09:11:15 ]
7	55m31s	update res_users set sid = '5b5191fdac0bf0b1436ef14f64d65baa3c54f34d', last_update = '2025-01-07 01:00:37.324507', exp_date = '2025-01-07 01:45:37.324509', logged_in = 'TRUE' where id = 1372; [ Date: 2025-01-07 02:56:08 ]
8	52m9s	update res_users set sid = '7996410666a32a5bf93f9d33f96d68bdbcbbec4a', last_update = '2025-01-07 13:17:11.602267', exp_date = '2025-01-07 14:02:11.602271', logged_in = 'TRUE' where id = 1274; [ Date: 2025-01-07 15:09:20 ]
9	51m5s	update res_users set sid = '7996410666a32a5bf93f9d33f96d68bdbcbbec4a', last_update = '2025-01-07 13:18:15.218268', exp_date = '2025-01-07 14:03:15.218270', logged_in = 'TRUE' where id = 1274; [ Date: 2025-01-07 15:09:20 ]
10	43m24s	update res_users set sid = '6ea8e88c58e9cfbb77dd83cb0dd8e836d2b4040c', last_update = '2025-01-07 11:56:55.775593', exp_date = '2025-01-07 12:41:55.775596', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-07 13:40:20 ]
11	43m24s	update res_users set sid = '6ea8e88c58e9cfbb77dd83cb0dd8e836d2b4040c', last_update = '2025-01-07 11:56:55.775482', exp_date = '2025-01-07 12:41:55.775486', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-07 13:40:20 ]
12	40m55s	update res_users set sid = '6ea8e88c58e9cfbb77dd83cb0dd8e836d2b4040c', last_update = '2025-01-07 11:59:25.469521', exp_date = '2025-01-07 12:44:25.469524', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-07 13:40:20 ]
13	37m37s	update res_users set sid = '7996410666a32a5bf93f9d33f96d68bdbcbbec4a', last_update = '2025-01-07 13:31:43.765849', exp_date = '2025-01-07 14:16:43.765853', logged_in = 'TRUE' where id = 1274; [ Date: 2025-01-07 15:09:20 ]
14	36m18s	update res_users set sid = '6ea8e88c58e9cfbb77dd83cb0dd8e836d2b4040c', last_update = '2025-01-07 12:04:02.146504', exp_date = '2025-01-07 12:49:02.146508', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-07 13:40:20 ]
15	32m44s	update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-07 14:49:35.829351', exp_date = '2025-01-07 15:34:35.829354', logged_in = 'TRUE' where id = 862; [ Date: 2025-01-07 16:22:20 ]
16	32m44s	update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-07 14:49:35.829122', exp_date = '2025-01-07 15:34:35.829126', logged_in = 'TRUE' where id = 862; [ Date: 2025-01-07 16:22:20 ]
17	32m17s	update res_users set sid = '7996410666a32a5bf93f9d33f96d68bdbcbbec4a', last_update = '2025-01-07 13:37:03.256896', exp_date = '2025-01-07 14:22:03.256901', logged_in = 'TRUE' where id = 1274; [ Date: 2025-01-07 15:09:20 ]
18	31m57s	update res_users set sid = '6ea8e88c58e9cfbb77dd83cb0dd8e836d2b4040c', last_update = '2025-01-07 12:08:23.386535', exp_date = '2025-01-07 12:53:23.386537', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-07 13:40:20 ]
19	31m45s	update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-07 14:50:35.030228', exp_date = '2025-01-07 15:35:35.030230', logged_in = 'TRUE' where id = 862; [ Date: 2025-01-07 16:22:20 ]
20	31m43s	update res_users set sid = '7996410666a32a5bf93f9d33f96d68bdbcbbec4a', last_update = '2025-01-07 13:37:37.045373', exp_date = '2025-01-07 14:22:37.045377', logged_in = 'TRUE' where id = 1274; [ Date: 2025-01-07 15:09:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d21h35m17s

69,280

Details

0ms

59m59s

3s616ms

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 07	00	778	177ms	0ms
	01	1,104	246ms	0ms
	02	916	2h55m30s	11s496ms
	03	1,490	45m27s	1s830ms
	04	1,089	59m56s	3s302ms
	05	429	107ms	0ms
	06	714	165ms	0ms
	07	513	114ms	0ms
	08	1,937	443ms	0ms
	09	4,230	6h9m12s	5s237ms
	10	6,124	4h9m46s	2s447ms
	11	6,764	1s896ms	0ms
	12	7,106	3h46m7s	1s909ms
	13	6,460	6h14m5s	3s474ms
	14	5,357	5h32m51s	3s728ms
	15	5,807	12h25m27s	7s702ms
	16	4,486	14h1m30s	11s255ms
	17	4,168	3h28m25s	3s
	18	2,737	42s445ms	15ms
	19	2,527	7h20m51s	10s467ms
	20	2,283	1h45m16s	2s766ms
	21	1,444	304ms	0ms
	22	817	168ms	0ms

update res_users set sid = '5b5191fdac0bf0b1436ef14f64d65baa3c54f34d', last_update = '2025-01-07 00:56:08.807803', exp_date = '2025-01-07 01:41:08.807805', logged_in = 'TRUE' where id = 1372;

Date: 2025-01-07 02:56:08 Duration: 59m59s
update res_users set sid = '5b5191fdac0bf0b1436ef14f64d65baa3c54f34d', last_update = '2025-01-07 00:56:08.807797', exp_date = '2025-01-07 01:41:08.807800', logged_in = 'TRUE' where id = 1372;

Date: 2025-01-07 02:56:08 Duration: 59m59s
update res_users set sid = '2fa23b723cee9ff223c52a72b0acb54f3dbd00d6', last_update = '2025-01-07 17:12:09.014711', exp_date = '2025-01-07 17:57:09.014714', logged_in = 'TRUE' where id = 1049;

Date: 2025-01-07 19:12:08 Duration: 59m59s

2

1d9h56m25s

236,254

Details

436ms

1s64ms

517ms

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 07	00	8,120	1h7m5s	495ms
	01	7,674	1h2m27s	488ms
	02	9,328	1h17m2s	495ms
	03	10,536	1h25m56s	489ms
	04	8,141	1h5m50s	485ms
	05	2,857	22m49s	479ms
	06	4,697	39m7s	499ms
	07	3,403	27m10s	479ms
	08	4,271	34m20s	482ms
	09	13,235	1h51m57s	507ms
	10	18,529	2h45m55s	537ms
	11	15,629	2h15m16s	519ms
	12	14,337	2h7m5s	531ms
	13	12,521	1h48m20s	519ms
	14	12,078	1h43m43s	515ms
	15	9,711	1h21m48s	505ms
	16	8,087	1h8m7s	505ms
	17	14,505	2h10m53s	541ms
	18	12,479	1h51m16s	534ms
	19	15,809	2h20m55s	534ms
	20	20,652	3h7m39s	545ms
	21	6,288	53m5s	506ms
	22	3,367	28m28s	507ms

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

Date: 2025-01-07 19:41:24 Duration: 1s64ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4285749)) AND (("shipping_track"."id" not in (35294317, 35294317)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 18:16:01 Duration: 1s53ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4285748)) AND (("shipping_track"."id" not in (35294316, 35294316)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 18:16:01 Duration: 966ms

3

6h11m27s

42,101

Details

441ms

1s298ms

529ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 07	00	494	4m11s	509ms
	01	300	2m38s	527ms
	02	163	1m31s	564ms
	03	204	1m57s	576ms
	04	277	2m27s	532ms
	05	85	45s857ms	539ms
	06	190	1m40s	526ms
	07	327	2m41s	493ms
	08	945	7m44s	492ms
	09	3,587	31m16s	523ms
	10	3,834	35m28s	555ms
	11	4,175	37m23s	537ms
	12	3,377	30m51s	548ms
	13	3,311	29m19s	531ms
	14	3,208	27m48s	520ms
	15	2,724	23m25s	515ms
	16	2,387	20m13s	508ms
	17	2,926	25m35s	524ms
	18	2,661	23m23s	527ms
	19	2,852	25m2s	526ms
	20	2,374	21m54s	553ms
	21	1,082	8m59s	498ms
	22	618	5m5s	494ms

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

Date: 2025-01-07 17:22:02 Duration: 1s298ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2730868)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 14:33:30 Duration: 1s45ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4278783, 4278276, 4278179, 4277326, 4277321, 4277318, 4277310, 4277255, 4271777, 4269908, 4268791, 4267878, 4267615, 4266915, 4265393, 4264206, 4262804, 4261055, 4260681, 4259846, 4259387, 4258614, 4258606, 4258148, 4257602, 4257216, 4257168, 4255470, 4255134, 4254645, 4254104, 4253781, 4253577, 4253483, 4253193, 4251937, 4251476, 4251315, 4250392, 4223754, 4220431, 3902414, 2371769)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 14:33:30 Duration: 891ms

4

6h6m53s

109,239

Details

148ms

349ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 07	00	1,274	4m10s	196ms
	01	2,185	7m7s	195ms
	02	2,153	7m1s	195ms
	03	2,739	8m59s	196ms
	04	2,197	7m8s	195ms
	05	1,135	3m41s	194ms
	06	1,274	4m7s	194ms
	07	2,118	6m51s	194ms
	08	2,142	6m58s	195ms
	09	7,706	26m44s	208ms
	10	6,584	23m59s	218ms
	11	6,586	23m30s	214ms
	12	7,403	26m55s	218ms
	13	10,050	36m5s	215ms
	14	8,413	29m3s	207ms
	15	5,855	19m51s	203ms
	16	6,384	21m19s	200ms
	17	2,448	7m24s	181ms
	18	14,706	46m34s	190ms
	19	5,638	16m56s	180ms
	20	10,164	32m7s	189ms
	21	56	9s246ms	165ms
	22	29	4s851ms	167ms

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

Date: 2025-01-07 11:09:03 Duration: 349ms
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" = '9724189')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-07 12:22:06 Duration: 337ms
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" = '9389064')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-07 11:58:16 Duration: 325ms

5

3h27m24s

50,403

Details

95ms

842ms

246ms

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 07	00	2,299	9m8s	238ms
	01	1,571	5m44s	219ms
	02	3,497	13m7s	225ms
	03	1,534	6m40s	261ms
	04	1,132	4m52s	258ms
	05	132	32s545ms	246ms
	06	2,202	8m43s	237ms
	07	126	27s573ms	218ms
	08	158	37s194ms	235ms
	09	74	20s631ms	278ms
	10	364	1m26s	237ms
	11	104	24s671ms	237ms
	12	220	52s369ms	238ms
	13	588	2m29s	253ms
	14	758	3m2s	240ms
	15	944	3m35s	228ms
	16	1,736	7m18s	252ms
	17	7,835	32m59s	252ms
	18	5,134	21m48s	254ms
	19	6,608	27m24s	248ms
	20	8,469	37m3s	262ms
	21	3,004	11m35s	231ms
	22	1,914	7m8s	223ms

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-07 20:07:35 Duration: 842ms
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-07 20:07:35 Duration: 836ms
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-07 20:06:06 Duration: 835ms

6

3h16m43s

353

Details

0ms

30m56s

33s437ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 07	00	2	0ms	0ms
	01	3	4ms	1ms
	02	5	3ms	0ms
	03	3	3ms	1ms
	04	2	3ms	1ms
	05	2	2ms	1ms
	06	3	3ms	1ms
	07	1	0ms	0ms
	08	15	9ms	0ms
	09	34	6m34s	11s595ms
	10	41	12m54s	18s898ms
	11	25	11ms	0ms
	12	41	32ms	0ms
	13	32	48m42s	1m31s
	14	25	26m52s	1m4s
	15	38	1h18m26s	2m3s
	16	23	14m36s	38s94ms
	17	26	37ms	1ms
	18	12	11ms	0ms
	19	9	8m36s	57s347ms
	20	4	6ms	1ms
	21	5	2ms	0ms
	22	2	2ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-07 14:23:24.660076', "last_update" = '2025-01-07 13:38:24.660102', "sid" = '7a9a75f14d9f4e49804b6f9ab37347fafd3ddd2b', "write_date" = '2025-01-07 13:38:24.323312', "write_uid" = 1 WHERE id IN (1274);

Date: 2025-01-07 15:09:20 Duration: 30m56s
UPDATE "res_users" SET "exp_date" = '2025-01-07 13:00:44.352254', "last_update" = '2025-01-07 12:15:44.352282', "sid" = '62123b27defdeb2336cc9047725b11aae0b71a64', "write_date" = '2025-01-07 12:15:43.974109', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-07 13:40:20 Duration: 24m36s
UPDATE "res_users" SET "exp_date" = '2025-01-07 13:05:58.721573', "last_update" = '2025-01-07 12:20:58.721597', "sid" = '62123b27defdeb2336cc9047725b11aae0b71a64', "write_date" = '2025-01-07 12:20:58.389356', "write_uid" = 905 WHERE id IN (905);

Date: 2025-01-07 13:40:20 Duration: 19m21s

7

2h32m13s

10,033

Details

202ms

1s747ms

910ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 07	00	615	9m20s	911ms
	01	285	4m19s	911ms
	02	526	7m54s	902ms
	03	5	4s597ms	919ms
	08	12	10s554ms	879ms
	09	15	14s217ms	947ms
	10	1	1s180ms	1s180ms
	11	20	18s143ms	907ms
	12	78	1m19s	1s24ms
	13	199	3m12s	969ms
	14	113	1m52s	994ms
	15	276	4m23s	953ms
	16	245	3m48s	931ms
	17	1,452	22m57s	948ms
	18	1,431	22m16s	934ms
	19	1,607	21m44s	811ms
	20	1,675	26m22s	944ms
	21	778	11m25s	880ms
	22	700	10m27s	895ms

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

Date: 2025-01-07 17:22:10 Duration: 1s747ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9781782')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-07 19:40:59 Duration: 1s539ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9610744')) 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 (70))))))) 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 (70)))))) 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 (70)))))) 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 (70))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-07 19:41:22 Duration: 1s493ms

8

1h40m55s

139,075

Details

33ms

119ms

43ms

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 07	00	4,215	2m51s	40ms
	01	2,773	1m53s	40ms
	02	3,209	2m9s	40ms
	03	3,302	2m15s	40ms
	04	2,614	1m46s	40ms
	05	880	35s799ms	40ms
	06	1,919	1m18s	40ms
	07	1,284	52s781ms	41ms
	08	2,472	1m40s	40ms
	09	9,119	6m32s	42ms
	10	12,657	9m31s	45ms
	11	12,820	9m20s	43ms
	12	12,437	9m14s	44ms
	13	11,134	8m2s	43ms
	14	7,170	5m9s	43ms
	15	7,728	5m27s	42ms
	16	6,832	4m45s	41ms
	17	8,530	6m24s	45ms
	18	7,808	5m53s	45ms
	19	7,343	5m32s	45ms
	20	6,717	5m13s	46ms
	21	3,895	2m48s	43ms
	22	2,217	1m35s	43ms

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

Date: 2025-01-07 11:58:16 Duration: 119ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4250172)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-07 11:39:15 Duration: 113ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4170675)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-07 12:22:06 Duration: 101ms

9

1h32m

20,244

Details

181ms

512ms

272ms

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 07	08	590	2m30s	254ms
	09	2,522	11m32s	274ms
	10	2,398	11m21s	284ms
	11	1,225	5m39s	277ms
	12	3,040	14m1s	276ms
	13	2,880	13m9s	274ms
	14	1,591	7m27s	281ms
	15	2,131	9m35s	270ms
	16	2,575	11m23s	265ms
	17	519	2m9s	250ms
	18	756	3m4s	243ms
	19	17	6s300ms	370ms

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

Date: 2025-01-07 12:21:50 Duration: 512ms
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" = '9470749')))) ORDER BY "collection_policy"."id";

Date: 2025-01-07 12:21:51 Duration: 477ms
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" = '9328668')))) ORDER BY "collection_policy"."id";

Date: 2025-01-07 12:21:51 Duration: 469ms

10

1h15m46s

15,559

Details

191ms

471ms

292ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 07	00	546	2m42s	297ms
	01	521	2m31s	290ms
	02	1,260	6m12s	295ms
	03	777	3m50s	297ms
	04	585	2m52s	294ms
	05	72	20s911ms	290ms
	06	1,105	5m22s	291ms
	07	64	18s831ms	294ms
	08	72	20s563ms	285ms
	09	32	9s937ms	310ms
	10	194	1m5s	337ms
	11	40	12s622ms	315ms
	12	37	12s733ms	344ms
	13	100	34s680ms	346ms
	14	283	1m25s	301ms
	15	212	1m2s	295ms
	16	636	3m13s	304ms
	17	2,501	12m22s	296ms
	18	1,169	5m27s	279ms
	19	1,729	8m19s	289ms
	20	2,607	12m40s	291ms
	21	753	3m20s	266ms
	22	264	1m6s	250ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9688860')) 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-07 19:41:31 Duration: 471ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '485660')) 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-07 19:41:24 Duration: 454ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9511899')) 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-07 18:16:07 Duration: 449ms

11

59m59s

36

Details

0ms

59m59s

1m39s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 07	00	1	1ms	1ms
	03	3	4ms	1ms
	04	1	1ms	1ms
	08	2	0ms	0ms
	09	3	59m59s	19m59s
	10	3	3ms	1ms
	11	4	2ms	0ms
	12	5	2ms	0ms
	13	1	0ms	0ms
	14	1	1ms	1ms
	15	2	2ms	1ms
	16	2	2ms	1ms
	17	1	2ms	2ms
	19	1	3ms	3ms
	20	6	11ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-07 07:56:15.602814', "last_update" = '2025-01-07 07:11:15.602830', "write_date" = '2025-01-07 07:11:15.282912', "write_uid" = 1 WHERE id IN (951);

Date: 2025-01-07 09:11:15 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-01-07 19:46:31.595206', "last_update" = '2025-01-07 19:01:31.595270', "write_date" = '2025-01-07 19:01:31.162449', "write_uid" = 1 WHERE id IN (1116);

Date: 2025-01-07 20:01:31 Duration: 3ms
UPDATE "res_users" SET "exp_date" = '2025-01-07 19:25:44.033053', "last_update" = '2025-01-07 18:40:44.033087', "write_date" = '2025-01-07 18:40:43.599489', "write_uid" = 1 WHERE id IN (901);

Date: 2025-01-07 19:40:44 Duration: 3ms

12

41m22s

44,237

Details

40ms

103ms

56ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 07	00	27	1s493ms	55ms
	01	25	1s395ms	55ms
	03	11	658ms	59ms
	04	18	1s63ms	59ms
	06	12	667ms	55ms
	07	4	237ms	59ms
	08	913	48s822ms	53ms
	09	5,653	5m15s	55ms
	10	4,526	4m29s	59ms
	11	2,762	2m38s	57ms
	12	7,103	6m52s	58ms
	13	6,120	5m41s	55ms
	14	3,281	3m6s	56ms
	15	5,665	5m12s	55ms
	16	3,973	3m36s	54ms
	17	1,468	1m18s	53ms
	18	1,530	1m18s	51ms
	19	460	23s852ms	51ms
	20	338	18s321ms	54ms
	21	183	8s879ms	48ms
	22	165	7s893ms	47ms

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

Date: 2025-01-07 12:22:06 Duration: 103ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4210637) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-07 17:22:05 Duration: 100ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4278228) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-07 20:07:46 Duration: 93ms

13

38m51s

11,369

Details

155ms

338ms

205ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 07	01	104	20s518ms	197ms
	02	11	2s175ms	197ms
	05	120	23s457ms	195ms
	06	470	1m31s	195ms
	07	2,032	6m35s	194ms
	08	836	2m43s	195ms
	09	1,214	4m16s	211ms
	10	1,297	4m45s	219ms
	11	1,267	4m35s	217ms
	12	659	2m19s	211ms
	13	716	2m28s	207ms
	14	818	2m48s	206ms
	15	879	3m	205ms
	16	356	1m12s	203ms
	17	418	1m16s	182ms
	19	44	7s823ms	177ms
	20	70	13s869ms	198ms
	21	29	4s849ms	167ms
	22	29	4s869ms	167ms

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

Date: 2025-01-07 11:58:16 Duration: 338ms
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" = '9719011')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) 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-07 12:22:06 Duration: 297ms
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" = '9354920')) 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-07 14:32:54 Duration: 290ms

14

36m6s

11,051

Details

165ms

242ms

196ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 07	00	1,274	4m10s	196ms
	01	2,045	6m39s	195ms
	02	2,135	6m58s	196ms
	03	2,298	7m32s	197ms
	04	1,871	6m5s	195ms
	05	1,015	3m17s	194ms
	06	327	1m3s	194ms
	07	86	16s865ms	196ms

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" = '9741901')) 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-07 03:13:27 Duration: 242ms
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" = '9689605')) 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-07 00:54:28 Duration: 241ms
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" = '8749942')) 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-07 03:20:15 Duration: 236ms

15

25m43s

14,327

Details

88ms

240ms

107ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 07	00	17	1s765ms	103ms
	01	16	1s728ms	108ms
	02	61	6s68ms	99ms
	03	5	546ms	109ms
	04	81	8s93ms	99ms
	07	44	4s591ms	104ms
	08	167	17s717ms	106ms
	09	1,087	1m58s	108ms
	10	1,096	2m6s	115ms
	11	1,586	2m53s	109ms
	12	1,718	3m7s	109ms
	13	1,764	3m8s	107ms
	14	1,615	2m50s	105ms
	15	1,044	1m49s	104ms
	16	1,475	2m32s	103ms
	17	466	51s622ms	110ms
	18	553	1m1s	110ms
	19	536	58s131ms	108ms
	20	415	46s887ms	112ms
	21	402	40s436ms	100ms
	22	179	18s64ms	100ms

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

Date: 2025-01-07 17:22:05 Duration: 240ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7943318)) AND (("cash_track"."id" not in (6655327, 6666325, 6674020, 6699536, 6708006, 6708006)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-07 18:15:52 Duration: 179ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7949730)) AND (("cash_track"."id" not in (6700118)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-07 14:32:56 Duration: 163ms

16

15m21s

17,964

Details

37ms

87ms

51ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 07	08	575	27s617ms	48ms
	09	2,247	1m54s	50ms
	10	1,891	1m41s	53ms
	11	1,470	1m16s	51ms
	12	2,603	2m19s	53ms
	13	2,426	2m7s	52ms
	14	1,759	1m28s	50ms
	15	2,429	2m2s	50ms
	16	1,580	1m17s	49ms
	17	580	27s156ms	46ms
	18	387	18s166ms	46ms
	19	17	760ms	44ms

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

Date: 2025-01-07 09:42:11 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4207502) ORDER BY "collection_policy"."id";

Date: 2025-01-07 10:25:42 Duration: 85ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3916874) ORDER BY "collection_policy"."id";

Date: 2025-01-07 12:22:02 Duration: 77ms

17

14m7s

4,105

Details

158ms

286ms

206ms

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

Day	Hour	Count	Duration	Avg duration
Jan 07	06	364	1m10s	193ms
	08	314	1m1s	196ms
	09	928	3m9s	204ms
	10	1,097	3m53s	212ms
	11	588	2m5s	212ms
	12	43	9s476ms	220ms
	13	132	28s658ms	217ms
	14	556	1m52s	201ms
	15	56	11s538ms	206ms
	21	27	4s453ms	164ms

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

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

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

Date: 2025-01-07 10:20:11 Duration: 278ms

18

13m55s

5,779

Details

119ms

271ms

144ms

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 07	00	17	2s206ms	129ms
	01	30	3s906ms	130ms
	04	2	255ms	127ms
	08	111	14s669ms	132ms
	09	439	1m3s	144ms
	10	1,067	2m39s	149ms
	11	1,137	2m42s	143ms
	12	1,000	2m26s	146ms
	13	609	1m25s	140ms
	14	331	46s646ms	140ms
	15	335	45s902ms	137ms
	16	242	33s5ms	136ms
	17	158	24s262ms	153ms
	18	97	15s166ms	156ms
	19	31	4s741ms	152ms
	20	95	15s400ms	162ms
	21	39	5s716ms	146ms
	22	39	5s661ms	145ms

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-07 11:09:03 Duration: 271ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 70)) 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-07 17:22:01 Duration: 244ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 28)) 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-07 12:22:06 Duration: 229ms

19

12m3s

254

Details

12ms

4s351ms

2s849ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 07	02	4	12s161ms	3s40ms
	04	2	59ms	29ms
	08	1	28ms	28ms
	09	3	11s113ms	3s704ms
	10	19	1m9s	3s682ms
	11	8	15s742ms	1s967ms
	12	19	49s555ms	2s608ms
	13	21	1m3s	3s19ms
	14	28	43s995ms	1s571ms
	15	30	1m25s	2s859ms
	16	70	3m32s	3s35ms
	17	17	56s673ms	3s333ms
	18	9	29s846ms	3s316ms
	19	4	12s763ms	3s190ms
	20	12	41s768ms	3s480ms
	21	5	15s421ms	3s84ms
	22	2	3s22ms	1s511ms

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

Date: 2025-01-07 18:16:14 Duration: 4s351ms
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 (75))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))))) AND ("policy_number"."name"::text ilike '%9725971%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-07 20:02:09 Duration: 4s223ms
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 (42))))))) 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 (42)))))) 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 (42)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (42)))))) 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 (42))))))))) 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 (42)))))))) AND ("policy_number"."name"::text ilike '%961%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-07 18:16:13 Duration: 4s212ms

20

9m49s

2,225

Details

15ms

733ms

264ms

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

Day	Hour	Count	Duration	Avg duration
Jan 07	00	2	471ms	235ms
	01	1	19ms	19ms
	02	4	1s216ms	304ms
	04	7	1s10ms	144ms
	07	1	18ms	18ms
	08	64	8s719ms	136ms
	09	124	26s322ms	212ms
	10	147	39s94ms	265ms
	11	240	1m6s	275ms
	12	302	1m21s	270ms
	13	297	1m24s	282ms
	14	255	1m2s	245ms
	15	238	1m10s	296ms
	16	158	42s18ms	265ms
	17	115	35s520ms	308ms
	18	73	21s728ms	297ms
	19	45	17s718ms	393ms
	20	51	16s716ms	327ms
	21	86	11s651ms	135ms
	22	15	2s84ms	138ms

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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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-07 13:23:47 Duration: 733ms
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-07 18:15:52 Duration: 717ms
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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-07 13:23:48 Duration: 708ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,354,872

Details

1m50s

0ms

14ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 07	00	43,599	2s70ms	0ms
	01	42,987	2s73ms	0ms
	02	39,664	1s920ms	0ms
	03	42,502	2s41ms	0ms
	04	37,538	1s458ms	0ms
	05	23,858	868ms	0ms
	06	32,888	1s361ms	0ms
	07	28,008	1s117ms	0ms
	08	70,100	2s908ms	0ms
	09	144,594	6s938ms	0ms
	10	188,515	9s38ms	0ms
	11	214,524	11s576ms	0ms
	12	210,424	10s503ms	0ms
	13	200,069	10s38ms	0ms
	14	178,150	8s492ms	0ms
	15	172,049	7s590ms	0ms
	16	158,917	7s192ms	0ms
	17	137,101	5s982ms	0ms
	18	109,201	5s60ms	0ms
	19	93,487	4s80ms	0ms
	20	86,622	3s894ms	0ms
	21	61,676	2s748ms	0ms
	22	38,399	1s684ms	0ms

DISCARD ALL;

Date: 2025-01-07 15:37:25 Duration: 14ms
DISCARD ALL;

Date: 2025-01-07 20:03:11 Duration: 1ms
DISCARD ALL;

Date: 2025-01-07 00:54:30 Duration: 1ms

2

1,835,695

Details

27s29ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 07	00	31,299	518ms	0ms
	01	31,645	520ms	0ms
	02	29,207	490ms	0ms
	03	32,636	538ms	0ms
	04	29,412	423ms	0ms
	05	16,950	251ms	0ms
	06	26,100	402ms	0ms
	07	21,328	339ms	0ms
	08	55,195	790ms	0ms
	09	118,276	1s777ms	0ms
	10	152,609	2s312ms	0ms
	11	172,307	2s542ms	0ms
	12	168,190	2s539ms	0ms
	13	155,787	2s364ms	0ms
	14	135,522	1s985ms	0ms
	15	132,531	1s847ms	0ms
	16	120,771	1s692ms	0ms
	17	107,350	1s487ms	0ms
	18	83,921	1s171ms	0ms
	19	71,625	984ms	0ms
	20	67,485	982ms	0ms
	21	47,150	661ms	0ms
	22	28,399	404ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

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

Date: 2025-01-07 16:24:50 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-07 09:49:53 Duration: 1ms

3

1,200,639

Details

12s15ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 07	00	22,492	217ms	0ms
	01	22,131	219ms	0ms
	02	20,526	203ms	0ms
	03	21,883	221ms	0ms
	04	19,383	185ms	0ms
	05	12,546	109ms	0ms
	06	17,132	160ms	0ms
	07	14,780	135ms	0ms
	08	36,028	327ms	0ms
	09	73,533	778ms	0ms
	10	95,921	1s36ms	0ms
	11	108,766	1s123ms	0ms
	12	107,321	1s132ms	0ms
	13	101,404	1s46ms	0ms
	14	90,361	888ms	0ms
	15	87,449	847ms	0ms
	16	80,617	771ms	0ms
	17	69,759	709ms	0ms
	18	55,590	523ms	0ms
	19	47,547	454ms	0ms
	20	44,146	462ms	0ms
	21	31,611	287ms	0ms
	22	19,713	171ms	0ms

ROLLBACK;

Date: 2025-01-07 13:10:55 Duration: 0ms
ROLLBACK;

Date: 2025-01-07 11:22:38 Duration: 0ms
ROLLBACK;

Date: 2025-01-07 14:32:51 Duration: 0ms

4

1,186,888

Details

3m36s

0ms

16ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 07	00	21,832	4s194ms	0ms
	01	21,488	4s197ms	0ms
	02	19,848	4s61ms	0ms
	03	21,239	4s368ms	0ms
	04	18,807	3s527ms	0ms
	05	11,978	1s857ms	0ms
	06	16,536	2s947ms	0ms
	07	14,075	2s370ms	0ms
	08	35,319	5s892ms	0ms
	09	73,153	14s397ms	0ms
	10	95,148	18s833ms	0ms
	11	108,571	19s903ms	0ms
	12	106,415	19s880ms	0ms
	13	100,897	18s815ms	0ms
	14	89,697	16s89ms	0ms
	15	86,908	15s193ms	0ms
	16	80,136	13s966ms	0ms
	17	68,869	12s618ms	0ms
	18	55,041	9s81ms	0ms
	19	46,967	8s326ms	0ms
	20	43,636	8s45ms	0ms
	21	31,010	4s665ms	0ms
	22	19,318	2s817ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'a51b1bbda1cf2e451f63b6763b57f1b3a2f53ae8';

Date: 2025-01-07 13:41:01 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = 'dfbe287014a4a43571d4cd1ad9e22a86d6e7c575';

Date: 2025-01-07 17:21:56 Duration: 10ms
SELECT payload FROM http_sessions WHERE sid = 'dfbe287014a4a43571d4cd1ad9e22a86d6e7c575';

Date: 2025-01-07 17:21:56 Duration: 10ms

5

1,177,371

Details

1m44s

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 07	00	21,871	1s931ms	0ms
	01	21,567	1s912ms	0ms
	02	19,899	1s764ms	0ms
	03	21,307	1s933ms	0ms
	04	18,851	1s622ms	0ms
	05	12,007	927ms	0ms
	06	16,506	1s389ms	0ms
	07	14,079	1s137ms	0ms
	08	35,058	2s759ms	0ms
	09	72,187	6s653ms	0ms
	10	94,124	8s868ms	0ms
	11	107,199	9s280ms	0ms
	12	105,024	9s360ms	0ms
	13	99,970	9s170ms	0ms
	14	89,047	7s910ms	0ms
	15	85,958	7s561ms	0ms
	16	79,417	6s843ms	0ms
	17	68,438	6s339ms	0ms
	18	54,633	4s601ms	0ms
	19	46,739	4s32ms	0ms
	20	43,349	3s959ms	0ms
	21	30,893	2s556ms	0ms
	22	19,248	1s552ms	0ms

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

Date: 2025-01-07 16:35:07 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-07 11:10:23 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-07 12:12:12 Duration: 1ms

6

820,489

Details

2m9s

0ms

12ms

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 07	00	10,845	1s792ms	0ms
	01	11,548	1s900ms	0ms
	02	10,178	1s769ms	0ms
	03	13,249	2s178ms	0ms
	04	12,343	1s953ms	0ms
	05	5,039	1s77ms	0ms
	06	11,314	1s825ms	0ms
	07	7,794	1s240ms	0ms
	08	26,057	3s779ms	0ms
	09	59,425	8s585ms	0ms
	10	74,289	11s441ms	0ms
	11	85,045	16s641ms	0ms
	12	79,412	12s118ms	0ms
	13	70,935	11s816ms	0ms
	14	58,996	9s553ms	0ms
	15	57,699	8s389ms	0ms
	16	51,071	7s312ms	0ms
	17	48,197	6s907ms	0ms
	18	36,539	5s346ms	0ms
	19	30,445	4s460ms	0ms
	20	29,594	4s611ms	0ms
	21	19,760	2s839ms	0ms
	22	10,715	1s614ms	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 (998, 959, 1379, 980, 1300, 849, 996);

Date: 2025-01-07 11:55:34 Duration: 12ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (901);

Date: 2025-01-07 17:21:57 Duration: 11ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (974);

Date: 2025-01-07 17:21:57 Duration: 10ms

7

634,228

Details

1m51s

0ms

33ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 07	00	8,809	1s598ms	0ms
	01	9,509	1s997ms	0ms
	02	8,682	1s820ms	0ms
	03	10,712	2s249ms	0ms
	04	10,032	2s29ms	0ms
	05	4,403	813ms	0ms
	06	8,966	1s497ms	0ms
	07	6,547	980ms	0ms
	08	19,157	2s993ms	0ms
	09	44,649	7s736ms	0ms
	10	56,533	10s180ms	0ms
	11	63,526	10s825ms	0ms
	12	60,833	10s635ms	0ms
	13	54,328	9s486ms	0ms
	14	45,087	7s596ms	0ms
	15	45,034	7s305ms	0ms
	16	40,096	6s254ms	0ms
	17	37,479	6s346ms	0ms
	18	28,312	5s68ms	0ms
	19	23,970	4s613ms	0ms
	20	23,336	4s755ms	0ms
	21	15,541	2s868ms	0ms
	22	8,687	1s600ms	0ms

COMMIT;

Date: 2025-01-07 13:50:34 Duration: 33ms
COMMIT;

Date: 2025-01-07 09:10:13 Duration: 33ms
COMMIT;

Date: 2025-01-07 10:43:02 Duration: 32ms

8

500,200

Details

30s360ms

0ms

15ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 07	00	6,753	368ms	0ms
	01	5,496	301ms	0ms
	02	4,507	244ms	0ms
	03	6,259	342ms	0ms
	04	5,928	295ms	0ms
	05	1,988	101ms	0ms
	06	6,963	351ms	0ms
	07	4,424	236ms	0ms
	08	14,238	787ms	0ms
	09	35,188	2s182ms	0ms
	10	43,807	2s961ms	0ms
	11	52,556	3s43ms	0ms
	12	47,724	3s53ms	0ms
	13	44,180	2s742ms	0ms
	14	37,971	2s271ms	0ms
	15	34,687	2s79ms	0ms
	16	30,961	1s738ms	0ms
	17	31,245	2s	0ms
	18	24,123	1s395ms	0ms
	19	20,628	1s256ms	0ms
	20	20,294	1s425ms	0ms
	21	12,879	774ms	0ms
	22	7,401	404ms	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, 29, 30, 32, 35, 36, 38, 39, 42, 44, 46, 49, 51, 52, 55, 60, 61, 62, 64, 65, 66, 67, 70, 71, 73, 76, 77, 78, 79, 80, 85, 102, 110, 111, 113, 119, 121, 123, 126, 127);

Date: 2025-01-07 21:50:24 Duration: 15ms
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 (123, 27, 26, 55, 17, 40, 49, 52, 74, 19, 11, 70, 61, 44, 6, 77, 64, 79, 60, 110, 39, 48, 66, 22, 73, 51);

Date: 2025-01-07 11:39:43 Duration: 13ms
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 (65, 61, 85, 22, 24, 62, 29, 126);

Date: 2025-01-07 14:31:10 Duration: 1ms

9

493,936

Details

1m3s

0ms

3ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 07	00	7,024	780ms	0ms
	01	6,734	821ms	0ms
	02	6,429	705ms	0ms
	03	8,266	1s56ms	0ms
	04	7,507	903ms	0ms
	05	2,337	272ms	0ms
	06	7,874	905ms	0ms
	07	3,667	444ms	0ms
	08	15,426	2s212ms	0ms
	09	35,587	5s21ms	0ms
	10	43,381	6s234ms	0ms
	11	53,648	6s785ms	0ms
	12	44,716	6s77ms	0ms
	13	41,453	6s288ms	0ms
	14	34,487	4s64ms	0ms
	15	30,419	3s825ms	0ms
	16	28,100	3s304ms	0ms
	17	29,952	3s792ms	0ms
	18	24,053	2s676ms	0ms
	19	21,660	2s437ms	0ms
	20	21,159	2s802ms	0ms
	21	12,533	1s329ms	0ms
	22	7,524	794ms	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 (5109249, 5099296, 5099867, 5101209, 5105083, 5099007, 5099500, 5101092, 5099009, 5099904, 5100659, 5099788, 5099727, 5122395, 5099404, 5456965, 5100259, 5099045, 5101379, 5100232, 5099248, 5099246, 5370578, 5099013, 5099392, 5107848, 5100801, 5150538, 5468431);

Date: 2025-01-07 17:21:57 Duration: 3ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5151578, 5134271, 5149883, 5168817, 5262200, 5407102, 5154728, 5150574, 5144659, 5460074, 5163138, 5140185, 5316280, 5459795, 5221849, 5294634, 5175055, 5300038, 5377877, 5460393, 5188421, 5459903, 5161879, 5312843, 5140166, 5418169, 5460102, 5254281, 5459640, 5135539, 5156833, 5310613, 5460396, 5277718, 5460023, 5137326, 5361613, 5193654, 5151834, 5204069, 5358166, 5358280, 5357065, 5227094, 5357727, 5155305, 5358358, 5238888, 5354926, 5357744, 5357500, 5358738, 5356363, 5357514, 5211335, 5157719, 5357371, 5356431, 5299621, 5158006, 5139411, 5200886, 5203944, 5316435, 5276965, 5358447, 5149286, 5423224, 5157501, 5424039, 5165465, 5419372, 5139524, 5229482, 5168784, 5168960, 5384402, 5424285, 5278354, 5163672, 5198044, 5416979, 5416980, 5324217, 5225891, 5187650, 5234717, 5249098, 5290696, 5213687, 5154353, 5181390, 5142947, 5420040, 5246862, 5194633, 5316835, 5208531, 5400079, 5250478, 5258891, 5140290, 5148737, 5424474, 5420235, 5168332, 5412376, 5174477, 5154325, 5424448, 5150805, 5424837, 5216835, 5190901, 5330530, 5211751, 5165034, 5174814, 5262661, 5424608, 5424475, 5175956, 5245496, 5253160, 5423584, 5308455, 5247066, 5329869, 5140543, 5214789, 5285095, 5198278, 5426602, 5208599, 5158008, 5265185, 5257161, 5164695, 5176882, 5194162, 5142608, 5265190, 5426208, 5424699, 5426921, 5330219, 5271579, 5233673, 5165055, 5426789, 5189952, 5426473, 5209329, 5424104, 5242536, 5154345, 5412770, 5426970, 5156633, 5426624, 5425938, 5361528, 5364028, 5329404, 5364930, 5226776, 5332387, 5363716, 5137579, 5286979, 5183299, 5193920, 5364054, 5157430, 5364926, 5267511, 5363545, 5154383, 5177437);

Date: 2025-01-07 14:31:10 Duration: 2ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099102, 5099182, 5099289, 5101408, 5105219, 5105135, 5099007, 5100207, 5104938, 5099013, 5101355, 5099010, 5107502, 5106217, 5099236, 5099321, 5101313, 5099138, 5099169, 5099356, 5100175, 5099644, 5099119, 5099885, 5120890, 5099254, 5140277, 5099598, 5099008, 5461241, 5100637, 5099662, 5099404, 5099144, 5099798, 5099446, 5099187, 5122349, 5101685, 5100539, 5099179, 5103750, 5103784, 5099130, 5099248, 5099406, 5099009, 5457814, 5100204, 5099802, 5261729, 5099646, 5099503, 5100651, 5099818, 5459468, 5099929, 5122915, 5099573, 5099359, 5105753, 5099120, 5099342, 5101592, 5100004, 5099892, 5099671, 5101662, 5099137, 5099533, 5099129, 5099296, 5133079, 5099006, 5099687, 5099003, 5187961, 5103431, 5103188, 5099540, 5099028, 5099045, 5099264, 5100718, 5099111, 5100202, 5113765, 5099128, 5099642, 5099206, 5099122, 5318025, 5099194, 5274347, 5099095, 5103630, 5099639, 5101152, 5100850, 5267242, 5099525, 5100677);

Date: 2025-01-07 17:21:57 Duration: 2ms

10

341,995

Details

1m3s

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

Day	Hour	Count	Duration	Avg duration
Jan 07	00	4,039	735ms	0ms
	01	3,298	611ms	0ms
	02	2,633	500ms	0ms
	03	3,919	768ms	0ms
	04	3,621	671ms	0ms
	05	1,392	260ms	0ms
	06	4,035	694ms	0ms
	07	2,743	454ms	0ms
	08	12,283	1s847ms	0ms
	09	24,802	4s557ms	0ms
	10	30,572	6s136ms	0ms
	11	35,323	6s548ms	0ms
	12	34,897	6s653ms	0ms
	13	30,393	5s807ms	0ms
	14	25,847	4s653ms	0ms
	15	25,641	4s549ms	0ms
	16	22,711	3s968ms	0ms
	17	21,991	4s132ms	0ms
	18	15,179	2s742ms	0ms
	19	12,529	2s323ms	0ms
	20	11,601	2s396ms	0ms
	21	7,976	1s321ms	0ms
	22	4,570	735ms	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 (2);

Date: 2025-01-07 17:21:57 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 (8006778);

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

Date: 2025-01-07 17:21:57 Duration: 8ms

11

307,382

Details

1m37s

0ms

4ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 07	00	1,988	633ms	0ms
	01	1,946	603ms	0ms
	02	1,628	472ms	0ms
	03	1,979	622ms	0ms
	04	2,568	760ms	0ms
	05	794	230ms	0ms
	06	1,835	546ms	0ms
	07	1,237	378ms	0ms
	08	7,844	2s348ms	0ms
	09	22,259	7s108ms	0ms
	10	30,579	10s254ms	0ms
	11	19,020	5s958ms	0ms
	12	29,796	9s825ms	0ms
	13	32,492	10s459ms	0ms
	14	24,438	7s588ms	0ms
	15	29,416	9s31ms	0ms
	16	23,312	7s37ms	0ms
	17	28,190	8s924ms	0ms
	18	12,327	3s869ms	0ms
	19	12,600	3s870ms	0ms
	20	12,812	4s330ms	0ms
	21	5,739	1s699ms	0ms
	22	2,583	769ms	0ms

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

Date: 2025-01-07 14:31:32 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1064) OR r.global) ORDER BY r.id;

Date: 2025-01-07 17:21:57 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.customer' 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 = 1008) OR r.global) ORDER BY r.id;

Date: 2025-01-07 04:56:29 Duration: 2ms

12

236,254

Details

1d9h56m25s

436ms

1s64ms

517ms

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

Day	Hour	Count	Duration	Avg duration
Jan 07	00	8,120	1h7m5s	495ms
	01	7,674	1h2m27s	488ms
	02	9,328	1h17m2s	495ms
	03	10,536	1h25m56s	489ms
	04	8,141	1h5m50s	485ms
	05	2,857	22m49s	479ms
	06	4,697	39m7s	499ms
	07	3,403	27m10s	479ms
	08	4,271	34m20s	482ms
	09	13,235	1h51m57s	507ms
	10	18,529	2h45m55s	537ms
	11	15,629	2h15m16s	519ms
	12	14,337	2h7m5s	531ms
	13	12,521	1h48m20s	519ms
	14	12,078	1h43m43s	515ms
	15	9,711	1h21m48s	505ms
	16	8,087	1h8m7s	505ms
	17	14,505	2h10m53s	541ms
	18	12,479	1h51m16s	534ms
	19	15,809	2h20m55s	534ms
	20	20,652	3h7m39s	545ms
	21	6,288	53m5s	506ms
	22	3,367	28m28s	507ms

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

Date: 2025-01-07 19:41:24 Duration: 1s64ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4285749)) AND (("shipping_track"."id" not in (35294317, 35294317)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 18:16:01 Duration: 1s53ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4285748)) AND (("shipping_track"."id" not in (35294316, 35294316)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 18:16:01 Duration: 966ms

13

227,187

Details

39s318ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 07	00	1,855	265ms	0ms
	01	2,053	271ms	0ms
	02	1,921	232ms	0ms
	03	2,058	290ms	0ms
	04	2,348	313ms	0ms
	05	985	128ms	0ms
	06	1,510	218ms	0ms
	07	1,554	217ms	0ms
	08	7,978	1s161ms	0ms
	09	17,699	3s132ms	0ms
	10	23,701	4s405ms	0ms
	11	13,962	2s290ms	0ms
	12	20,558	3s803ms	0ms
	13	22,100	4s79ms	0ms
	14	16,637	2s832ms	0ms
	15	20,745	3s591ms	0ms
	16	15,750	2s657ms	0ms
	17	20,388	3s693ms	0ms
	18	8,477	1s408ms	0ms
	19	9,386	1s602ms	0ms
	20	9,505	1s817ms	0ms
	21	4,030	621ms	0ms
	22	1,987	283ms	0ms

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

Date: 2025-01-07 17:21:57 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1195 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-07 15:46:27 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 891 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-07 17:09:40 Duration: 1ms

14

225,242

Details

57s567ms

0ms

6ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 07	00	3,396	828ms	0ms
	01	2,951	716ms	0ms
	02	3,413	828ms	0ms
	03	3,447	943ms	0ms
	04	3,065	797ms	0ms
	05	886	228ms	0ms
	06	3,661	939ms	0ms
	07	1,545	375ms	0ms
	08	6,046	1s700ms	0ms
	09	14,286	3s880ms	0ms
	10	18,954	8s694ms	0ms
	11	22,136	5s110ms	0ms
	12	19,955	4s613ms	0ms
	13	18,745	4s652ms	0ms
	14	16,755	3s428ms	0ms
	15	14,150	3s141ms	0ms
	16	13,689	2s941ms	0ms
	17	14,986	3s738ms	0ms
	18	11,424	2s554ms	0ms
	19	10,729	2s523ms	0ms
	20	11,285	2s953ms	0ms
	21	6,119	1s228ms	0ms
	22	3,619	744ms	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 (41719612, 41834065, 41586891, 41600029, 32640464, 41690780, 32637872, 41493055);

Date: 2025-01-07 17:21:57 Duration: 6ms
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 (41549740);

Date: 2025-01-07 17:21:57 Duration: 6ms
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 (39855176, 40217755, 41758403, 41716495, 41757952, 41230309, 39758388, 39117626, 40116145, 41166050, 39855381, 39709736, 40403008, 40646022, 40325606, 41230248, 40555128, 41114075, 41114556, 40353232, 40838476, 40217779, 39953671, 41082563, 41471339, 41678042, 41811097, 41811139, 40117726, 39711307, 40932331, 41042926, 41715868, 41757949, 41496402, 40645811, 40451103, 41165917, 41471135, 41497170, 41230822, 40353970, 40161868, 40452228, 40932079, 40404566, 39758535, 40118145, 39117604, 39624811, 41230292, 40353975, 40161708, 40594051, 41864911, 41880831, 41677058, 40161715, 40216656, 40491309, 40646317, 40805002, 39710507, 41114120, 40489845, 41166759, 41962238, 41083616, 41113898, 39757345, 41546122, 40162255, 41333279, 39625112, 41043699, 41471119, 41082637, 41497425, 40404380, 40645108, 40403975, 40837383, 40116125, 39954615, 40354305, 39624934, 39898490, 41880827, 41230927, 41546366, 41716383, 41451541, 41880950, 40490393, 40452406, 32626507, 40786571, 40404301, 41113750, 39757850);

Date: 2025-01-07 17:22:06 Duration: 5ms

15

171,119

Details

12s589ms

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 07	00	2,132	136ms	0ms
	01	2,099	135ms	0ms
	02	1,587	100ms	0ms
	03	2,636	182ms	0ms
	04	2,433	146ms	0ms
	05	803	49ms	0ms
	06	2,478	148ms	0ms
	07	1,333	83ms	0ms
	08	5,532	347ms	0ms
	09	12,416	894ms	0ms
	10	15,352	1s209ms	0ms
	11	19,637	1s453ms	0ms
	12	16,550	1s350ms	0ms
	13	15,345	1s257ms	0ms
	14	12,910	1s18ms	0ms
	15	11,296	699ms	0ms
	16	10,094	602ms	0ms
	17	9,628	654ms	0ms
	18	7,861	541ms	0ms
	19	6,427	474ms	0ms
	20	6,270	566ms	0ms
	21	3,962	323ms	0ms
	22	2,338	212ms	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-07 17:21:57 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-07 20:50:34 Duration: 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-07 11:29:00 Duration: 0ms

16

139,075

Details

1h40m55s

33ms

119ms

43ms

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

Day	Hour	Count	Duration	Avg duration
Jan 07	00	4,215	2m51s	40ms
	01	2,773	1m53s	40ms
	02	3,209	2m9s	40ms
	03	3,302	2m15s	40ms
	04	2,614	1m46s	40ms
	05	880	35s799ms	40ms
	06	1,919	1m18s	40ms
	07	1,284	52s781ms	41ms
	08	2,472	1m40s	40ms
	09	9,119	6m32s	42ms
	10	12,657	9m31s	45ms
	11	12,820	9m20s	43ms
	12	12,437	9m14s	44ms
	13	11,134	8m2s	43ms
	14	7,170	5m9s	43ms
	15	7,728	5m27s	42ms
	16	6,832	4m45s	41ms
	17	8,530	6m24s	45ms
	18	7,808	5m53s	45ms
	19	7,343	5m32s	45ms
	20	6,717	5m13s	46ms
	21	3,895	2m48s	43ms
	22	2,217	1m35s	43ms

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

Date: 2025-01-07 11:58:16 Duration: 119ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4250172)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-07 11:39:15 Duration: 113ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4170675)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-07 12:22:06 Duration: 101ms

17

138,142

Details

1m13s

0ms

24ms

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

Day	Hour	Count	Duration	Avg duration
Jan 07	00	758	327ms	0ms
	01	318	177ms	0ms
	02	260	165ms	0ms
	03	238	166ms	0ms
	04	263	166ms	0ms
	05	93	55ms	0ms
	06	455	191ms	0ms
	07	783	375ms	0ms
	08	2,916	2s486ms	0ms
	09	7,313	4s772ms	0ms
	10	7,358	4s751ms	0ms
	11	10,292	6s281ms	0ms
	12	11,258	6s472ms	0ms
	13	11,814	7s176ms	0ms
	14	13,769	6s761ms	0ms
	15	8,953	4s567ms	0ms
	16	7,818	3s726ms	0ms
	17	7,693	4s92ms	0ms
	18	11,471	5s352ms	0ms
	19	11,964	5s191ms	0ms
	20	19,170	8s911ms	0ms
	21	2,267	1s256ms	0ms
	22	918	409ms	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 (4095158, 4154793, 4151647, 4129727, 4149843, 4163811, 4066117, 4094675, 4123506, 4150198, 4038148, 4126844, 4051542, 3902094, 4126767, 4123660, 4095203, 4126835, 4133508, 4095159, 4104011, 4121905, 4094265, 4163807, 4126825, 4129989, 4095960, 4104496, 4150339, 4124205, 4152067, 4149786, 4126726, 3900419, 3407893, 4132688, 4039073, 4151659, 4151645, 3959250, 4038155, 4121839, 4162137, 4095077, 3529308, 4008338, 4038995, 4132698, 4038157, 4040771, 4095199, 4095176, 4132695, 4097474, 4095155, 3895683, 4095196, 4132513, 4126418, 4095188, 4051536, 4066167, 4133510, 4132686, 4063463, 4097033, 4095127, 4038162, 4095967, 4008348, 4122485, 4073569, 4094313, 3963373, 3959956, 4095078, 4095178, 4066195, 4095959, 4105890, 3791338, 4095120, 4094302, 3968285, 4095162, 4098567, 4095166, 3789876, 3606138, 4095170, 4103934, 4095148, 4095204, 4095151, 4095190, 3865754, 4040767, 4095152, 4104034, 4041591, 4051534, 4097495, 4041507, 4066162, 4051545, 4043668, 4104387, 4070381, 4094724, 4073501, 4036091, 3790456, 4042632, 4051553, 4012295, 4012285, 4068164, 4040766, 4063478, 4070268, 4008454, 4040769, 3959308, 4043692, 4040337, 4066269, 4066266, 4012055, 3862260, 4041624, 3844658, 4038027, 3964231, 4051551, 4041611, 3960476, 3960495, 4012296, 3959304, 4012281, 3968163, 4016232, 4012287, 3968235, 3960498, 3963363, 3971177, 3971235, 3896786, 3960478, 3835793, 3862266, 3902347, 3737036, 3857479, 3828708, 3844659, 3871048, 3806651, 3756851, 3806658, 3714631, 3641517, 3739789, 3458006, 3458010);

Date: 2025-01-07 17:21:57 Duration: 24ms
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 (4182480, 4182457, 4140142, 4172073, 4172077, 4152269, 4172066, 4172211, 4152272, 4170199, 4140762, 4135356, 4172097, 4059993, 4116397, 3762072, 4162460, 3475671, 3842687, 4059156, 4162536, 4121173, 3994970, 4138647, 4169340, 4064289, 3996539, 4046239, 4028402, 4069871, 3994833, 3710608, 4069745, 4129929, 4152270, 4101596, 4138143, 4140796, 4058759, 4083994, 3490325, 4085788, 4121169, 4129055, 3623763, 4051154, 4138584, 4114755, 3852519, 4058708, 4098850, 4093191, 4129043, 3548042, 3397429, 4048733, 4021720, 4082277, 4085328, 3789629, 4116673, 3972928, 4046243, 4114756, 4027287, 4046331, 4051156, 4098852, 4060431, 3766835, 4059077, 4093159, 4098851, 4069915, 3673386, 4084000, 4049577, 4048191, 4059420, 4056356, 4069882, 4079403, 3889652, 4055899, 4047921, 3990602, 3944514, 4046234, 4048734, 4056113, 3904628, 4075062, 3919351, 4089021, 4030468, 3472849, 4056115, 3940619, 4030194, 3908363, 4056038, 4046334, 4020248, 3990603, 4012502, 4024798, 3979570, 3944516, 3960177, 3990046, 3974777, 3994832, 3984642, 3919375, 3908257, 3756224, 3842693, 3327074, 3881240, 3886172, 3902462, 3916556, 3886213, 3886181, 3873175, 3707752, 3816824, 3623980, 3842690, 3850801, 3703860, 3477148, 3780249, 3756221, 3736775, 3623981, 3651634, 3670786, 3742694, 3475387, 3704140, 3651636, 3670785, 3210025, 3624014, 3603170, 3623979, 3624900, 3624012, 3477982, 3477189, 3209520, 3244761, 3472920, 3100283, 3245214, 3249363, 3210196, 3173437, 3171444, 2887101, 2489200, 2106510, 2137259, 1771384);

Date: 2025-01-07 13:41:01 Duration: 18ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4217479, 4217611, 4195813, 4237252, 4196943, 4210669, 4209143, 4237325, 4243600, 3460344, 4237596, 4241592, 4239947, 3996803, 4096526, 4119730, 4145478, 4210054, 4240256, 4240061, 4172436, 4217538, 4228048, 3856795, 4222861, 4230124, 4154386, 4217595, 4216397, 4240251, 4240510, 4236185, 4242444, 4242440, 4215698, 4230254, 4208679, 3967006, 4256772, 4225037, 4197225, 4218595, 4237136, 4242231, 4234347, 4229213, 4186646, 4176111, 4180604, 4186973, 4190087, 3600335, 4100222, 4078759, 4186648, 4186610, 4172307, 4123134, 4214262, 4186629, 4248219, 4186338, 4186637, 4248220, 4184758, 4171053, 4067030, 4008503, 4038237, 3916983, 4200902, 4245039, 4203101, 4223646, 4059487, 4245333, 4163349, 4193289, 4173035, 4157462, 4129171, 4199921, 4214809, 4168974, 4238750, 4230172, 4236736, 4197214, 4225783, 4181134, 4200925, 4208909, 4238670, 4228027, 4170344, 4234354, 4238413, 3956616, 4007917, 4211755, 4227583, 4073781, 4075643, 4115598, 4199644, 4200677, 4223885, 4228576, 4233230, 4233421, 4233474, 4242063, 4244957, 4217565, 4242540, 4135847, 4107367, 4204908, 4086127, 4217558, 4202156, 4240500, 4179597, 4215719, 4193147, 4149834, 4084171, 4151423, 4200666, 4203047, 4178485, 4200252, 4184892, 4197425, 4214629, 4222088, 4234378, 4238689, 4240517, 4242554, 4138650, 4164953, 4172210, 4177767, 4179062, 4198474, 4204609, 4206393, 4209240, 4228538, 4223210, 4227241, 4230352, 4231099, 4238226, 4239097, 4239381, 4242278, 4243555, 4159680, 4217600, 4218464, 4237740, 4238327, 4242781, 4179068, 4226188, 4228039, 4230091, 4234532, 4240237, 4197590, 4199567, 4223183, 4238577, 4194548, 4197756, 4207124, 4235223, 4125436, 4202712, 4245081, 3905955, 4071450);

Date: 2025-01-07 17:22:13 Duration: 10ms

18

130,635

Details

7s524ms

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

Day	Hour	Count	Duration	Avg duration
Jan 07	00	793	42ms	0ms
	01	735	37ms	0ms
	02	671	31ms	0ms
	03	798	42ms	0ms
	04	1,005	48ms	0ms
	05	307	14ms	0ms
	06	772	40ms	0ms
	07	528	28ms	0ms
	08	3,430	179ms	0ms
	09	9,682	574ms	0ms
	10	13,053	821ms	0ms
	11	7,512	415ms	0ms
	12	12,390	744ms	0ms
	13	14,023	821ms	0ms
	14	10,434	573ms	0ms
	15	12,893	720ms	0ms
	16	9,833	533ms	0ms
	17	12,312	726ms	0ms
	18	5,138	289ms	0ms
	19	5,311	306ms	0ms
	20	5,495	349ms	0ms
	21	2,454	126ms	0ms
	22	1,066	55ms	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 (97);

Date: 2025-01-07 17:28:30 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 (2, 10);

Date: 2025-01-07 14:19:00 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 (17);

Date: 2025-01-07 15:36:35 Duration: 0ms

19

125,851

Details

15s232ms

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

Day	Hour	Count	Duration	Avg duration
Jan 07	00	786	87ms	0ms
	01	721	76ms	0ms
	02	654	62ms	0ms
	03	777	84ms	0ms
	04	996	100ms	0ms
	05	295	29ms	0ms
	06	754	82ms	0ms
	07	519	57ms	0ms
	08	3,352	369ms	0ms
	09	9,537	1s195ms	0ms
	10	12,727	1s702ms	0ms
	11	7,259	835ms	0ms
	12	11,995	1s521ms	0ms
	13	13,426	1s642ms	0ms
	14	9,970	1s139ms	0ms
	15	12,401	1s457ms	0ms
	16	9,510	1s77ms	0ms
	17	11,768	1s461ms	0ms
	18	4,872	573ms	0ms
	19	5,018	605ms	0ms
	20	5,123	695ms	0ms
	21	2,346	257ms	0ms
	22	1,045	114ms	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 (96) 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-07 19:16:20 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (105) 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-07 15:23:14 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (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-07 17:19:25 Duration: 0ms

20

124,278

Details

8s724ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 07	00	2,314	115ms	0ms
	01	2,544	114ms	0ms
	02	2,033	83ms	0ms
	03	3,322	156ms	0ms
	04	3,017	135ms	0ms
	05	1,080	47ms	0ms
	06	2,691	117ms	0ms
	07	882	50ms	0ms
	08	3,399	200ms	0ms
	09	8,585	667ms	0ms
	10	11,108	932ms	0ms
	11	11,223	642ms	0ms
	12	10,803	810ms	0ms
	13	10,582	839ms	0ms
	14	7,866	550ms	0ms
	15	7,961	632ms	0ms
	16	6,940	503ms	0ms
	17	8,262	728ms	0ms
	18	5,597	366ms	0ms
	19	4,834	383ms	0ms
	20	4,936	425ms	0ms
	21	2,501	134ms	0ms
	22	1,798	85ms	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-07 12:42:09 Duration: 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-07 13:46:01 Duration: 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 (18);

Date: 2025-01-07 16:45:10 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m59s

1m39s

36

Details

59m59s

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 07	00	1	1ms	1ms
	03	3	4ms	1ms
	04	1	1ms	1ms
	08	2	0ms	0ms
	09	3	59m59s	19m59s
	10	3	3ms	1ms
	11	4	2ms	0ms
	12	5	2ms	0ms
	13	1	0ms	0ms
	14	1	1ms	1ms
	15	2	2ms	1ms
	16	2	2ms	1ms
	17	1	2ms	2ms
	19	1	3ms	3ms
	20	6	11ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-07 07:56:15.602814', "last_update" = '2025-01-07 07:11:15.602830', "write_date" = '2025-01-07 07:11:15.282912', "write_uid" = 1 WHERE id IN (951);

Date: 2025-01-07 09:11:15 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-01-07 19:46:31.595206', "last_update" = '2025-01-07 19:01:31.595270', "write_date" = '2025-01-07 19:01:31.162449', "write_uid" = 1 WHERE id IN (1116);

Date: 2025-01-07 20:01:31 Duration: 3ms
UPDATE "res_users" SET "exp_date" = '2025-01-07 19:25:44.033053', "last_update" = '2025-01-07 18:40:44.033087', "write_date" = '2025-01-07 18:40:43.599489', "write_uid" = 1 WHERE id IN (901);

Date: 2025-01-07 19:40:44 Duration: 3ms

2

0ms

30m56s

33s437ms

353

Details

3h16m43s

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 07	00	2	0ms	0ms
	01	3	4ms	1ms
	02	5	3ms	0ms
	03	3	3ms	1ms
	04	2	3ms	1ms
	05	2	2ms	1ms
	06	3	3ms	1ms
	07	1	0ms	0ms
	08	15	9ms	0ms
	09	34	6m34s	11s595ms
	10	41	12m54s	18s898ms
	11	25	11ms	0ms
	12	41	32ms	0ms
	13	32	48m42s	1m31s
	14	25	26m52s	1m4s
	15	38	1h18m26s	2m3s
	16	23	14m36s	38s94ms
	17	26	37ms	1ms
	18	12	11ms	0ms
	19	9	8m36s	57s347ms
	20	4	6ms	1ms
	21	5	2ms	0ms
	22	2	2ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-07 14:23:24.660076', "last_update" = '2025-01-07 13:38:24.660102', "sid" = '7a9a75f14d9f4e49804b6f9ab37347fafd3ddd2b', "write_date" = '2025-01-07 13:38:24.323312', "write_uid" = 1 WHERE id IN (1274);

Date: 2025-01-07 15:09:20 Duration: 30m56s
UPDATE "res_users" SET "exp_date" = '2025-01-07 13:00:44.352254', "last_update" = '2025-01-07 12:15:44.352282', "sid" = '62123b27defdeb2336cc9047725b11aae0b71a64', "write_date" = '2025-01-07 12:15:43.974109', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-07 13:40:20 Duration: 24m36s
UPDATE "res_users" SET "exp_date" = '2025-01-07 13:05:58.721573', "last_update" = '2025-01-07 12:20:58.721597', "sid" = '62123b27defdeb2336cc9047725b11aae0b71a64', "write_date" = '2025-01-07 12:20:58.389356', "write_uid" = 905 WHERE id IN (905);

Date: 2025-01-07 13:40:20 Duration: 19m21s

3

0ms

59m59s

3s616ms

69,280

Details

2d21h35m17s

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 07	00	778	177ms	0ms
	01	1,104	246ms	0ms
	02	916	2h55m30s	11s496ms
	03	1,490	45m27s	1s830ms
	04	1,089	59m56s	3s302ms
	05	429	107ms	0ms
	06	714	165ms	0ms
	07	513	114ms	0ms
	08	1,937	443ms	0ms
	09	4,230	6h9m12s	5s237ms
	10	6,124	4h9m46s	2s447ms
	11	6,764	1s896ms	0ms
	12	7,106	3h46m7s	1s909ms
	13	6,460	6h14m5s	3s474ms
	14	5,357	5h32m51s	3s728ms
	15	5,807	12h25m27s	7s702ms
	16	4,486	14h1m30s	11s255ms
	17	4,168	3h28m25s	3s
	18	2,737	42s445ms	15ms
	19	2,527	7h20m51s	10s467ms
	20	2,283	1h45m16s	2s766ms
	21	1,444	304ms	0ms
	22	817	168ms	0ms

update res_users set sid = '5b5191fdac0bf0b1436ef14f64d65baa3c54f34d', last_update = '2025-01-07 00:56:08.807803', exp_date = '2025-01-07 01:41:08.807805', logged_in = 'TRUE' where id = 1372;

Date: 2025-01-07 02:56:08 Duration: 59m59s
update res_users set sid = '5b5191fdac0bf0b1436ef14f64d65baa3c54f34d', last_update = '2025-01-07 00:56:08.807797', exp_date = '2025-01-07 01:41:08.807800', logged_in = 'TRUE' where id = 1372;

Date: 2025-01-07 02:56:08 Duration: 59m59s
update res_users set sid = '2fa23b723cee9ff223c52a72b0acb54f3dbd00d6', last_update = '2025-01-07 17:12:09.014711', exp_date = '2025-01-07 17:57:09.014714', logged_in = 'TRUE' where id = 1049;

Date: 2025-01-07 19:12:08 Duration: 59m59s

4

12ms

4s351ms

2s849ms

254

Details

12m3s

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 07	02	4	12s161ms	3s40ms
	04	2	59ms	29ms
	08	1	28ms	28ms
	09	3	11s113ms	3s704ms
	10	19	1m9s	3s682ms
	11	8	15s742ms	1s967ms
	12	19	49s555ms	2s608ms
	13	21	1m3s	3s19ms
	14	28	43s995ms	1s571ms
	15	30	1m25s	2s859ms
	16	70	3m32s	3s35ms
	17	17	56s673ms	3s333ms
	18	9	29s846ms	3s316ms
	19	4	12s763ms	3s190ms
	20	12	41s768ms	3s480ms
	21	5	15s421ms	3s84ms
	22	2	3s22ms	1s511ms

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

Date: 2025-01-07 18:16:14 Duration: 4s351ms
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 (75))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))))) AND ("policy_number"."name"::text ilike '%9725971%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-07 20:02:09 Duration: 4s223ms
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 (42))))))) 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 (42)))))) 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 (42)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (42)))))) 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 (42))))))))) 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 (42)))))))) AND ("policy_number"."name"::text ilike '%961%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-07 18:16:13 Duration: 4s212ms

5

202ms

1s747ms

910ms

10,033

Details

2h32m13s

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 07	00	615	9m20s	911ms
	01	285	4m19s	911ms
	02	526	7m54s	902ms
	03	5	4s597ms	919ms
	08	12	10s554ms	879ms
	09	15	14s217ms	947ms
	10	1	1s180ms	1s180ms
	11	20	18s143ms	907ms
	12	78	1m19s	1s24ms
	13	199	3m12s	969ms
	14	113	1m52s	994ms
	15	276	4m23s	953ms
	16	245	3m48s	931ms
	17	1,452	22m57s	948ms
	18	1,431	22m16s	934ms
	19	1,607	21m44s	811ms
	20	1,675	26m22s	944ms
	21	778	11m25s	880ms
	22	700	10m27s	895ms

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

Date: 2025-01-07 17:22:10 Duration: 1s747ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9781782')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-07 19:40:59 Duration: 1s539ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9610744')) 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 (70))))))) 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 (70)))))) 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 (70)))))) 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 (70))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-07 19:41:22 Duration: 1s493ms

6

441ms

1s298ms

529ms

42,101

Details

6h11m27s

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 07	00	494	4m11s	509ms
	01	300	2m38s	527ms
	02	163	1m31s	564ms
	03	204	1m57s	576ms
	04	277	2m27s	532ms
	05	85	45s857ms	539ms
	06	190	1m40s	526ms
	07	327	2m41s	493ms
	08	945	7m44s	492ms
	09	3,587	31m16s	523ms
	10	3,834	35m28s	555ms
	11	4,175	37m23s	537ms
	12	3,377	30m51s	548ms
	13	3,311	29m19s	531ms
	14	3,208	27m48s	520ms
	15	2,724	23m25s	515ms
	16	2,387	20m13s	508ms
	17	2,926	25m35s	524ms
	18	2,661	23m23s	527ms
	19	2,852	25m2s	526ms
	20	2,374	21m54s	553ms
	21	1,082	8m59s	498ms
	22	618	5m5s	494ms

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

Date: 2025-01-07 17:22:02 Duration: 1s298ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2730868)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 14:33:30 Duration: 1s45ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4278783, 4278276, 4278179, 4277326, 4277321, 4277318, 4277310, 4277255, 4271777, 4269908, 4268791, 4267878, 4267615, 4266915, 4265393, 4264206, 4262804, 4261055, 4260681, 4259846, 4259387, 4258614, 4258606, 4258148, 4257602, 4257216, 4257168, 4255470, 4255134, 4254645, 4254104, 4253781, 4253577, 4253483, 4253193, 4251937, 4251476, 4251315, 4250392, 4223754, 4220431, 3902414, 2371769)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 14:33:30 Duration: 891ms

7

436ms

1s64ms

517ms

236,254

Details

1d9h56m25s

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 07	00	8,120	1h7m5s	495ms
	01	7,674	1h2m27s	488ms
	02	9,328	1h17m2s	495ms
	03	10,536	1h25m56s	489ms
	04	8,141	1h5m50s	485ms
	05	2,857	22m49s	479ms
	06	4,697	39m7s	499ms
	07	3,403	27m10s	479ms
	08	4,271	34m20s	482ms
	09	13,235	1h51m57s	507ms
	10	18,529	2h45m55s	537ms
	11	15,629	2h15m16s	519ms
	12	14,337	2h7m5s	531ms
	13	12,521	1h48m20s	519ms
	14	12,078	1h43m43s	515ms
	15	9,711	1h21m48s	505ms
	16	8,087	1h8m7s	505ms
	17	14,505	2h10m53s	541ms
	18	12,479	1h51m16s	534ms
	19	15,809	2h20m55s	534ms
	20	20,652	3h7m39s	545ms
	21	6,288	53m5s	506ms
	22	3,367	28m28s	507ms

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

Date: 2025-01-07 19:41:24 Duration: 1s64ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4285749)) AND (("shipping_track"."id" not in (35294317, 35294317)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 18:16:01 Duration: 1s53ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4285748)) AND (("shipping_track"."id" not in (35294316, 35294316)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-07 18:16:01 Duration: 966ms

8

191ms

471ms

292ms

15,559

Details

1h15m46s

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 07	00	546	2m42s	297ms
	01	521	2m31s	290ms
	02	1,260	6m12s	295ms
	03	777	3m50s	297ms
	04	585	2m52s	294ms
	05	72	20s911ms	290ms
	06	1,105	5m22s	291ms
	07	64	18s831ms	294ms
	08	72	20s563ms	285ms
	09	32	9s937ms	310ms
	10	194	1m5s	337ms
	11	40	12s622ms	315ms
	12	37	12s733ms	344ms
	13	100	34s680ms	346ms
	14	283	1m25s	301ms
	15	212	1m2s	295ms
	16	636	3m13s	304ms
	17	2,501	12m22s	296ms
	18	1,169	5m27s	279ms
	19	1,729	8m19s	289ms
	20	2,607	12m40s	291ms
	21	753	3m20s	266ms
	22	264	1m6s	250ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9688860')) 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-07 19:41:31 Duration: 471ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '485660')) 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-07 19:41:24 Duration: 454ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9511899')) 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-07 18:16:07 Duration: 449ms

9

181ms

512ms

272ms

20,244

Details

1h32m

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 07	08	590	2m30s	254ms
	09	2,522	11m32s	274ms
	10	2,398	11m21s	284ms
	11	1,225	5m39s	277ms
	12	3,040	14m1s	276ms
	13	2,880	13m9s	274ms
	14	1,591	7m27s	281ms
	15	2,131	9m35s	270ms
	16	2,575	11m23s	265ms
	17	519	2m9s	250ms
	18	756	3m4s	243ms
	19	17	6s300ms	370ms

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

Date: 2025-01-07 12:21:50 Duration: 512ms
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" = '9470749')))) ORDER BY "collection_policy"."id";

Date: 2025-01-07 12:21:51 Duration: 477ms
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" = '9328668')))) ORDER BY "collection_policy"."id";

Date: 2025-01-07 12:21:51 Duration: 469ms

10

15ms

733ms

264ms

2,225

Details

9m49s

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 07	00	2	471ms	235ms
	01	1	19ms	19ms
	02	4	1s216ms	304ms
	04	7	1s10ms	144ms
	07	1	18ms	18ms
	08	64	8s719ms	136ms
	09	124	26s322ms	212ms
	10	147	39s94ms	265ms
	11	240	1m6s	275ms
	12	302	1m21s	270ms
	13	297	1m24s	282ms
	14	255	1m2s	245ms
	15	238	1m10s	296ms
	16	158	42s18ms	265ms
	17	115	35s520ms	308ms
	18	73	21s728ms	297ms
	19	45	17s718ms	393ms
	20	51	16s716ms	327ms
	21	86	11s651ms	135ms
	22	15	2s84ms	138ms

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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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-07 13:23:47 Duration: 733ms
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-07 18:15:52 Duration: 717ms
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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-07 13:23:48 Duration: 708ms

11

95ms

842ms

246ms

50,403

Details

3h27m24s

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 07	00	2,299	9m8s	238ms
	01	1,571	5m44s	219ms
	02	3,497	13m7s	225ms
	03	1,534	6m40s	261ms
	04	1,132	4m52s	258ms
	05	132	32s545ms	246ms
	06	2,202	8m43s	237ms
	07	126	27s573ms	218ms
	08	158	37s194ms	235ms
	09	74	20s631ms	278ms
	10	364	1m26s	237ms
	11	104	24s671ms	237ms
	12	220	52s369ms	238ms
	13	588	2m29s	253ms
	14	758	3m2s	240ms
	15	944	3m35s	228ms
	16	1,736	7m18s	252ms
	17	7,835	32m59s	252ms
	18	5,134	21m48s	254ms
	19	6,608	27m24s	248ms
	20	8,469	37m3s	262ms
	21	3,004	11m35s	231ms
	22	1,914	7m8s	223ms

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-07 20:07:35 Duration: 842ms
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-07 20:07:35 Duration: 836ms
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-07 20:06:06 Duration: 835ms

12

158ms

286ms

206ms

4,105

Details

14m7s

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 07	06	364	1m10s	193ms
	08	314	1m1s	196ms
	09	928	3m9s	204ms
	10	1,097	3m53s	212ms
	11	588	2m5s	212ms
	12	43	9s476ms	220ms
	13	132	28s658ms	217ms
	14	556	1m52s	201ms
	15	56	11s538ms	206ms
	21	27	4s453ms	164ms

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

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

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

Date: 2025-01-07 10:20:11 Duration: 278ms

13

155ms

338ms

205ms

11,369

Details

38m51s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 07	01	104	20s518ms	197ms
	02	11	2s175ms	197ms
	05	120	23s457ms	195ms
	06	470	1m31s	195ms
	07	2,032	6m35s	194ms
	08	836	2m43s	195ms
	09	1,214	4m16s	211ms
	10	1,297	4m45s	219ms
	11	1,267	4m35s	217ms
	12	659	2m19s	211ms
	13	716	2m28s	207ms
	14	818	2m48s	206ms
	15	879	3m	205ms
	16	356	1m12s	203ms
	17	418	1m16s	182ms
	19	44	7s823ms	177ms
	20	70	13s869ms	198ms
	21	29	4s849ms	167ms
	22	29	4s869ms	167ms

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

Date: 2025-01-07 11:58:16 Duration: 338ms
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" = '9719011')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) 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-07 12:22:06 Duration: 297ms
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" = '9354920')) 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-07 14:32:54 Duration: 290ms

14

148ms

349ms

201ms

109,239

Details

6h6m53s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 07	00	1,274	4m10s	196ms
	01	2,185	7m7s	195ms
	02	2,153	7m1s	195ms
	03	2,739	8m59s	196ms
	04	2,197	7m8s	195ms
	05	1,135	3m41s	194ms
	06	1,274	4m7s	194ms
	07	2,118	6m51s	194ms
	08	2,142	6m58s	195ms
	09	7,706	26m44s	208ms
	10	6,584	23m59s	218ms
	11	6,586	23m30s	214ms
	12	7,403	26m55s	218ms
	13	10,050	36m5s	215ms
	14	8,413	29m3s	207ms
	15	5,855	19m51s	203ms
	16	6,384	21m19s	200ms
	17	2,448	7m24s	181ms
	18	14,706	46m34s	190ms
	19	5,638	16m56s	180ms
	20	10,164	32m7s	189ms
	21	56	9s246ms	165ms
	22	29	4s851ms	167ms

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

Date: 2025-01-07 11:09:03 Duration: 349ms
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" = '9724189')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-07 12:22:06 Duration: 337ms
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" = '9389064')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-07 11:58:16 Duration: 325ms

15

165ms

242ms

196ms

11,051

Details

36m6s

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 07	00	1,274	4m10s	196ms
	01	2,045	6m39s	195ms
	02	2,135	6m58s	196ms
	03	2,298	7m32s	197ms
	04	1,871	6m5s	195ms
	05	1,015	3m17s	194ms
	06	327	1m3s	194ms
	07	86	16s865ms	196ms

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" = '9741901')) 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-07 03:13:27 Duration: 242ms
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" = '9689605')) 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-07 00:54:28 Duration: 241ms
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" = '8749942')) 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-07 03:20:15 Duration: 236ms

16

119ms

271ms

144ms

5,779

Details

13m55s

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 07	00	17	2s206ms	129ms
	01	30	3s906ms	130ms
	04	2	255ms	127ms
	08	111	14s669ms	132ms
	09	439	1m3s	144ms
	10	1,067	2m39s	149ms
	11	1,137	2m42s	143ms
	12	1,000	2m26s	146ms
	13	609	1m25s	140ms
	14	331	46s646ms	140ms
	15	335	45s902ms	137ms
	16	242	33s5ms	136ms
	17	158	24s262ms	153ms
	18	97	15s166ms	156ms
	19	31	4s741ms	152ms
	20	95	15s400ms	162ms
	21	39	5s716ms	146ms
	22	39	5s661ms	145ms

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-07 11:09:03 Duration: 271ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 70)) 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-07 17:22:01 Duration: 244ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 28)) 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-07 12:22:06 Duration: 229ms

17

88ms

240ms

107ms

14,327

Details

25m43s

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 07	00	17	1s765ms	103ms
	01	16	1s728ms	108ms
	02	61	6s68ms	99ms
	03	5	546ms	109ms
	04	81	8s93ms	99ms
	07	44	4s591ms	104ms
	08	167	17s717ms	106ms
	09	1,087	1m58s	108ms
	10	1,096	2m6s	115ms
	11	1,586	2m53s	109ms
	12	1,718	3m7s	109ms
	13	1,764	3m8s	107ms
	14	1,615	2m50s	105ms
	15	1,044	1m49s	104ms
	16	1,475	2m32s	103ms
	17	466	51s622ms	110ms
	18	553	1m1s	110ms
	19	536	58s131ms	108ms
	20	415	46s887ms	112ms
	21	402	40s436ms	100ms
	22	179	18s64ms	100ms

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

Date: 2025-01-07 17:22:05 Duration: 240ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7943318)) AND (("cash_track"."id" not in (6655327, 6666325, 6674020, 6699536, 6708006, 6708006)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-07 18:15:52 Duration: 179ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7949730)) AND (("cash_track"."id" not in (6700118)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-07 14:32:56 Duration: 163ms

18

40ms

103ms

56ms

44,237

Details

41m22s

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 07	00	27	1s493ms	55ms
	01	25	1s395ms	55ms
	03	11	658ms	59ms
	04	18	1s63ms	59ms
	06	12	667ms	55ms
	07	4	237ms	59ms
	08	913	48s822ms	53ms
	09	5,653	5m15s	55ms
	10	4,526	4m29s	59ms
	11	2,762	2m38s	57ms
	12	7,103	6m52s	58ms
	13	6,120	5m41s	55ms
	14	3,281	3m6s	56ms
	15	5,665	5m12s	55ms
	16	3,973	3m36s	54ms
	17	1,468	1m18s	53ms
	18	1,530	1m18s	51ms
	19	460	23s852ms	51ms
	20	338	18s321ms	54ms
	21	183	8s879ms	48ms
	22	165	7s893ms	47ms

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

Date: 2025-01-07 12:22:06 Duration: 103ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4210637) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-07 17:22:05 Duration: 100ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4278228) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-07 20:07:46 Duration: 93ms

19

37ms

87ms

51ms

17,964

Details

15m21s

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 07	08	575	27s617ms	48ms
	09	2,247	1m54s	50ms
	10	1,891	1m41s	53ms
	11	1,470	1m16s	51ms
	12	2,603	2m19s	53ms
	13	2,426	2m7s	52ms
	14	1,759	1m28s	50ms
	15	2,429	2m2s	50ms
	16	1,580	1m17s	49ms
	17	580	27s156ms	46ms
	18	387	18s166ms	46ms
	19	17	760ms	44ms

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

Date: 2025-01-07 09:42:11 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4207502) ORDER BY "collection_policy"."id";

Date: 2025-01-07 10:25:42 Duration: 85ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3916874) ORDER BY "collection_policy"."id";

Date: 2025-01-07 12:22:02 Duration: 77ms

20

33ms

119ms

43ms

139,075

Details

1h40m55s

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 07	00	4,215	2m51s	40ms
	01	2,773	1m53s	40ms
	02	3,209	2m9s	40ms
	03	3,302	2m15s	40ms
	04	2,614	1m46s	40ms
	05	880	35s799ms	40ms
	06	1,919	1m18s	40ms
	07	1,284	52s781ms	41ms
	08	2,472	1m40s	40ms
	09	9,119	6m32s	42ms
	10	12,657	9m31s	45ms
	11	12,820	9m20s	43ms
	12	12,437	9m14s	44ms
	13	11,134	8m2s	43ms
	14	7,170	5m9s	43ms
	15	7,728	5m27s	42ms
	16	6,832	4m45s	41ms
	17	8,530	6m24s	45ms
	18	7,808	5m53s	45ms
	19	7,343	5m32s	45ms
	20	6,717	5m13s	46ms
	21	3,895	2m48s	43ms
	22	2,217	1m35s	43ms

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

Date: 2025-01-07 11:58:16 Duration: 119ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4250172)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-07 11:39:15 Duration: 113ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4170675)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-07 12:22:06 Duration: 101ms

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

17,362,121 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	11	0.00%
DETAIL	25	0.00%
ERROR	5,457	0.03%
EVENTLOG	909	0.01%
FATAL	792	0.00%
HINT	4	0.00%
LOG	17,349,433	99.93%
STATEMENT	5,490	0.03%

Events distribution (except queries)

Key values

0 PANIC entries
792 FATAL entries
5457 ERROR entries
0 WARNING entries
909 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,867 Max number of times the same event was reported
7,158 Total events found

Rank

Times reported

Error

1

2,867

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 07	00	12
	01	5
	02	27
	03	39
	04	17
	05	5
	06	11
	07	7
	08	70
	09	86
	10	288
	11	305
	12	518
	13	267
	14	332
	15	196
	16	138
	17	258
	18	109
	19	83
	20	58
	21	20
	22	16

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

2

2,568

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 07	00	8
	01	5
	02	23
	03	29
	04	15
	05	5
	06	11
	07	6
	08	63
	09	78
	10	279
	11	264
	12	436
	13	236
	14	312
	15	186
	16	128
	17	240
	18	100
	19	68
	20	41
	21	19
	22	16

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

3

626

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 07	02	2
	03	31
	09	67
	10	108
	12	47
	13	23
	14	60
	15	51
	16	56
	17	76
	19	81
	20	24

4

626

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 07	02	2
	03	31
	09	67
	10	108
	12	47
	13	23
	14	60
	15	51
	16	56
	17	76
	19	81
	20	24

5

191

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 07	02	1
	03	1
	04	4
	05	1
	06	2
	07	2
	09	38
	10	23
	11	6
	12	14
	13	12
	14	9
	15	22
	16	10
	17	20
	19	18
	20	8

6

107

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 07	17	107

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

7

91

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 07	07	1
	09	18
	10	13
	12	11
	13	5
	14	3
	15	5
	16	5
	17	14
	19	12
	20	4

8

28

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 07	17	28

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

9

15

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 07	05	3
	08	3
	12	3
	13	3
	19	3

FATAL: password authentication failed for user "postgres"

10

6

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 07	17	6

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

11

5

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 07	12	2
	14	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 "code" of relation "res_country_state" violates not-null constraint

12

5

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 07	07	4
	13	1

13

5

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 07	09	1
	16	3
	19	1

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

14

4

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 07	11	1
	12	3

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

15

3

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 07	07	2
	13	1

16

2

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 07	07	1
	13	1

17

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 07	10	2

18

2

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 07	17	2

19

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 07	17	1

20

1

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 07	07	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 07	14	1

ERROR: duplicate key value violates unique constraint "res_country_state_name_code_uniq"

22

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 07	12	1

ERROR: could not serialize access due to concurrent delete

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 07	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables