pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Feb 5 23:47:33 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 44,485,073 log entries in 2m31s
Log start from 2025-02-05 00:00:00 to 2025-02-05 22:45:01

Global Stats

17,927 Number of unique normalized queries
19,042,582 Number of queries
7d11h50m19s Total query duration
2025-02-05 00:00:00 First query
2025-02-05 22:45:01 Last query
4,180 queries/s at 2025-02-05 11:44:13 Query peak

7d11h50m19s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
7d11h50m19s Execute total duration

5,522 Number of events
25 Number of unique normalized events
1,973 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
19,042,582 Average queries per session
7d11h50m19s 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

4,180 queries/s Query Peak
2025-02-05 11:44:13 Date

SELECT Traffic

Key values

2,836 queries/s Query Peak
2025-02-05 11:44:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,090 queries/s Query Peak
2025-02-05 19:19:43 Date

Queries duration

Key values

7d11h50m19s 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)
Feb 05	00	302,090	0ms	1m23s	23ms	3m24s	3m46s	4m18s
	01	305,416	0ms	5s422ms	26ms	3m41s	4m12s	4m41s
	02	273,437	0ms	1m22s	26ms	3m25s	4m29s	5m8s
	03	277,337	0ms	59m59s	55ms	4m46s	5m8s	1h56m10s
	04	277,004	0ms	1s367ms	34ms	4m19s	5m12s	6m1s
	05	220,651	0ms	2s850ms	28ms	2m51s	3m26s	4m45s
	06	234,096	0ms	888ms	22ms	2m53s	3m7s	3m53s
	07	164,180	0ms	754ms	13ms	1m33s	2m	2m28s
	08	436,759	0ms	2s737ms	11ms	3m8s	3m44s	6m
	09	1,177,524	0ms	13m50s	31ms	9m36s	13m29s	3h14m1s
	10	1,516,112	0ms	25m18s	19ms	7m8s	7m57s	3h40m16s
	11	1,872,194	0ms	22m20s	31ms	18m28s	23m24s	3h7m41s
	12	1,859,518	0ms	21m13s	26ms	11m28s	54m23s	2h58m39s
	13	1,552,391	0ms	26m42s	36ms	9m16s	56m43s	5h19m3s
	14	1,411,025	0ms	22m18s	38ms	9m12s	2h26m53s	5h26m35s
	15	1,291,447	0ms	28m41s	36ms	5m44s	8m21s	7h18m15s
	16	1,212,404	0ms	38m57s	37ms	6m33s	8m9s	8h48m4s
	17	1,106,409	0ms	34m54s	48ms	8m34s	12m24s	7h3m14s
	18	987,387	0ms	17m57s	30ms	8m39s	10m16s	3h2m45s
	19	926,778	0ms	29m31s	65ms	14m44s	16m47s	5h46m12s
	20	797,277	0ms	2m56s	35ms	15m50s	19m30s	35m49s
	21	594,031	0ms	17m17s	41ms	7m27s	8m9s	2h47m40s
	22	247,115	0ms	4s473ms	22ms	3m27s	3m44s	4m7s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 05	00	162,022	43ms	2m46s	3m14s	3m46s
	01	163,803	50ms	3m19s	3m40s	4m18s
	02	140,300	50ms	2m56s	3m19s	5m2s
	03	140,509	60ms	3m18s	4m15s	5m7s
	04	146,339	65ms	3m55s	4m18s	5m42s
	05	114,962	55ms	2m20s	2m51s	4m13s
	06	128,425	40ms	2m10s	2m53s	3m9s
	07	86,406	26ms	1m10s	1m32s	2m27s
	08	251,556	19ms	2m13s	3m7s	5m15s
	09	706,073	26ms	7m20s	8m9s	11m39s
	10	898,784	18ms	5m39s	6m57s	7m56s
	11	1,124,056	32ms	12m54s	15m53s	22m51s
	12	1,129,858	22ms	9m	10m16s	11m26s
	13	927,858	19ms	7m20s	8m30s	9m25s
	14	857,988	19ms	6m15s	7m50s	9m21s
	15	770,275	15ms	4m22s	5m38s	6m20s
	16	705,995	19ms	5m9s	6m30s	8m8s
	17	668,525	27ms	7m15s	7m44s	10m3s
	18	592,797	32ms	7m35s	8m34s	10m14s
	19	556,507	51ms	10m47s	12m35s	15m20s
	20	480,131	52ms	10m30s	15m20s	17m23s
	21	342,088	42ms	5m45s	7m25s	8m9s
	22	138,934	40ms	2m54s	3m27s	4m7s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 05	00	27,135	5,851	152	0	2ms	169ms	198ms	285ms
	01	29,704	7,410	140	0	0ms	181ms	230ms	317ms
	02	21,650	6,759	141	0	4ms	147ms	202ms	370ms
	03	25,505	8,035	144	0	204ms	155ms	216ms	288ms
	04	31,444	9,023	140	0	0ms	191ms	253ms	370ms
	05	19,903	6,126	193	0	0ms	129ms	156ms	214ms
	06	17,485	3,851	143	0	0ms	114ms	147ms	195ms
	07	7,045	2,135	151	0	0ms	50ms	72ms	112ms
	08	16,199	6,375	291	0	0ms	105ms	131ms	284ms
	09	60,751	19,080	845	0	220ms	395ms	467ms	1m54s
	10	64,625	19,785	914	0	153ms	391ms	443ms	616ms
	11	105,490	29,321	1,083	0	158ms	944ms	1s180ms	2m9s
	12	92,167	26,220	1,115	3	201ms	681ms	813ms	49m17s
	13	68,410	21,290	654	0	418ms	450ms	531ms	52m56s
	14	54,472	20,046	590	2	509ms	344ms	425ms	2h24m13s
	15	54,835	19,101	779	1	470ms	275ms	340ms	1s448ms
	16	56,151	17,681	802	0	423ms	346ms	411ms	694ms
	17	72,563	22,727	599	0	363ms	545ms	638ms	49s754ms
	18	63,724	22,260	558	0	126ms	437ms	522ms	18s727ms
	19	81,901	23,010	526	0	301ms	585ms	758ms	4m21s
	20	71,075	23,264	639	0	35ms	637ms	867ms	3m10s
	21	44,065	9,045	241	0	186ms	282ms	343ms	421ms
	22	22,779	4,310	127	0	0ms	151ms	213ms	285ms

Day	Hour	Percentage of prepare
Feb 05	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
Feb 05	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
Feb 05	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

72,064 buffers Checkpoint Peak
2025-02-05 11:46:25 Date
270.045 seconds Highest write time
0.021 seconds Sync time

Checkpoints Wal files

Key values

31 files Wal files usage Peak
2025-02-05 12:06:25 Date

Checkpoints distance

Key values

975.37 Mo Distance Peak
2025-02-05 12:06:25 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 05	00	157,210	3,239.546s	0.034s	3,239.629s
	01	163,453	3,239.522s	0.04s	3,239.618s
	02	172,336	3,239.582s	0.037s	3,239.673s
	03	184,323	3,239.604s	0.031s	3,239.685s
	04	164,184	3,239.5s	0.035s	3,239.578s
	05	125,972	3,239.647s	0.027s	3,239.722s
	06	121,348	3,232.55s	0.032s	3,232.628s
	07	108,705	3,210.623s	0.026s	3,210.706s
	08	98,259	2,788.323s	0.026s	2,788.388s
	09	432,562	3,239.489s	0.044s	3,239.614s
	10	480,795	3,239.492s	0.059s	3,239.634s
	11	633,012	3,239.515s	0.077s	3,239.706s
	12	651,176	3,239.4s	0.057s	3,239.566s
	13	551,420	3,239.502s	0.044s	3,239.645s
	14	346,994	3,239.547s	0.066s	3,239.708s
	15	325,583	3,239.519s	0.06s	3,239.639s
	16	374,356	3,239.46s	0.051s	3,239.585s
	17	306,196	2,885.91s	0.086s	2,886.062s
	18	252,351	3,239.555s	0.057s	3,239.67s
	19	344,993	3,239.42s	0.06s	3,239.55s
	20	290,582	3,239.553s	0.053s	3,239.682s
	21	197,857	3,239.528s	0.047s	3,239.627s
	22	90,364	2,429.638s	0.038s	2,429.71s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Feb 05	00	63	3,546	0.002s	0.012s
	01	66	3,452	0.006s	0.012s
	02	72	3,156	0.003s	0.012s
	03	80	2,651	0.002s	0.012s
	04	70	2,882	0.002s	0.012s
	05	55	2,840	0.002s	0.012s
	06	52	2,682	0.002s	0.012s
	07	41	2,481	0.002s	0.013s
	08	39	2,944	0.002s	0.011s
	09	172	4,992	0.002s	0.012s
	10	194	5,143	0.003s	0.012s
	11	267	5,354	0.003s	0.012s
	12	283	5,444	0.003s	0.012s
	13	228	5,372	0.002s	0.012s
	14	142	5,238	0.020s	0.012s
	15	134	5,595	0.011s	0.012s
	16	153	6,275	0.002s	0.012s
	17	128	5,564	0.013s	0.012s
	18	110	5,399	0.002s	0.012s
	19	147	5,232	0.003s	0.012s
	20	129	5,187	0.003s	0.012s
	21	84	4,437	0.002s	0.012s
	22	38	3,144	0.002s	0.009s

Day	Hour	Avg time (sec)
Feb 05	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
Feb 05	00	86,006.50 kB	114,066.25 kB
	01	90,631.42 kB	106,173.33 kB
	02	98,011.00 kB	129,097.08 kB
	03	108,944.58 kB	137,226.75 kB
	04	96,015.42 kB	135,899.00 kB
	05	74,463.00 kB	102,626.33 kB
	06	70,962.25 kB	92,559.75 kB
	07	52,095.77 kB	108,718.69 kB
	08	57,550.09 kB	81,183.09 kB
	09	235,398.58 kB	252,815.33 kB
	10	264,882.42 kB	315,990.92 kB
	11	364,277.42 kB	406,195.50 kB
	12	380,198.36 kB	455,494.55 kB
	13	312,207.83 kB	378,287.08 kB
	14	195,717.50 kB	276,571.40 kB
	15	183,023.64 kB	227,622.82 kB
	16	208,870.50 kB	298,568.08 kB
	17	175,806.50 kB	237,427.42 kB
	18	149,237.92 kB	200,102.33 kB
	19	201,698.75 kB	242,393.33 kB
	20	175,601.91 kB	224,507.18 kB
	21	114,647.58 kB	162,890.00 kB
	22	69,061.67 kB	110,673.00 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
Feb 05	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
Feb 05	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

11,234,191 Total read queries
5,351,026 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,234,191	59.00%
INSERT	1,109,078	5.82%
UPDATE	332,705	1.75%
DELETE	10,967	0.06%
COPY FROM	6	0.00%
COPY TO	0	0.00%
CTE	25,897	0.14%
DDL	1,795	0.01%
TCL	3,870,578	20.33%
CURSOR	0	0.00%
OTHERS	2,457,365	12.90%

Queries by database

Key values

unknown Main database
19,042,582 Requests
7d11h50m19s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	19,042,582	7d11h50m19s
	copy from	6	6ms
	cte	25,897	6s57ms
	ddl	1,795	249ms
	delete	10,967	1s515ms
	insert	1,109,078	6m16s
	others	2,457,365	2m2s
	select	11,234,191	3d19h36m53s
	tcl	3,870,578	2m52s
	update	332,705	3d16h2m6s

Queries by user

Key values

unknown Main user
19,042,582 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	19,042,582	7d11h50m19s
	copy from	6	6ms
	cte	25,897	6s57ms
	ddl	1,795	249ms
	delete	10,967	1s515ms
	insert	1,109,078	6m16s
	others	2,457,365	2m2s
	select	11,234,191	3d19h36m53s
	tcl	3,870,578	2m52s
	update	332,705	3d16h2m6s

Duration by user

Key values

7d11h50m19s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	19,042,582	7d11h50m19s
	copy from	6	6ms
	cte	25,897	6s57ms
	ddl	1,795	249ms
	delete	10,967	1s515ms
	insert	1,109,078	6m16s
	others	2,457,365	2m2s
	select	11,234,191	3d19h36m53s
	tcl	3,870,578	2m52s
	update	332,705	3d16h2m6s

Queries by host

Key values

unknown Main host
19,042,582 Requests
7d11h50m19s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	19,042,582	7d11h50m19s
	copy from	6	6ms
	cte	25,897	6s57ms
	ddl	1,795	249ms
	delete	10,967	1s515ms
	insert	1,109,078	6m16s
	others	2,457,365	2m2s
	select	11,234,191	3d19h36m53s
	tcl	3,870,578	2m52s
	update	332,705	3d16h2m6s

Queries by application

Key values

unknown Main application
19,042,582 Requests
7d11h50m19s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	19,042,582	7d11h50m19s
	copy from	6	6ms
	cte	25,897	6s57ms
	ddl	1,795	249ms
	delete	10,967	1s515ms
	insert	1,109,078	6m16s
	others	2,457,365	2m2s
	select	11,234,191	3d19h36m53s
	tcl	3,870,578	2m52s
	update	332,705	3d16h2m6s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-02-05 05:26:51 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,647,176 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,647,176	92.67%
1-5ms	363,736	1.91%
5-10ms	21,720	0.11%
10-25ms	52,744	0.28%
25-50ms	94,016	0.49%
50-100ms	167,563	0.88%
100-500ms	361,495	1.90%
500-1000ms	324,807	1.71%
1000-10000ms	8,621	0.05%
> 10000ms	704	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	UPDATE "res_users" SET "exp_date" = '2025-02-05 02:01:31.632263', "last_update" = '2025-02-05 01:16:31.632286', "write_date" = '2025-02-05 01:16:31.224617', "write_uid" = 1 WHERE id IN (1208); [ Date: 2025-02-05 03:16:31 ]
2	54m23s	UPDATE "res_users" SET "exp_date" = '2025-02-05 02:07:07.305608', "last_update" = '2025-02-05 01:22:07.305633', "sid" = 'c935130f5f26f8da16ed37566f2e173c37d7448a', "write_date" = '2025-02-05 01:22:06.987893', "write_uid" = 1 WHERE id IN (1208); [ Date: 2025-02-05 03:16:31 ]
3	38m57s	update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:54:23.969504', exp_date = '2025-02-05 15:39:23.969507', logged_in = 'TRUE' where id = 832; [ Date: 2025-02-05 16:33:20 ]
4	38m54s	update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:26.056573', exp_date = '2025-02-05 15:39:26.056576', logged_in = 'TRUE' where id = 1402; [ Date: 2025-02-05 16:33:20 ]
5	38m54s	update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:26.111125', exp_date = '2025-02-05 15:39:26.111129', logged_in = 'TRUE' where id = 1402; [ Date: 2025-02-05 16:33:20 ]
6	38m52s	update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:28.858602', exp_date = '2025-02-05 15:39:28.858605', logged_in = 'TRUE' where id = 1402; [ Date: 2025-02-05 16:33:20 ]
7	38m49s	update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:54:31.813353', exp_date = '2025-02-05 15:39:31.813356', logged_in = 'TRUE' where id = 832; [ Date: 2025-02-05 16:33:20 ]
8	38m48s	update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:32.062801', exp_date = '2025-02-05 15:39:32.062806', logged_in = 'TRUE' where id = 1402; [ Date: 2025-02-05 16:33:20 ]
9	38m46s	update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:54:34.068574', exp_date = '2025-02-05 15:39:34.068577', logged_in = 'TRUE' where id = 832; [ Date: 2025-02-05 16:33:20 ]
10	38m46s	update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:34.895026', exp_date = '2025-02-05 15:39:34.895030', logged_in = 'TRUE' where id = 1402; [ Date: 2025-02-05 16:33:21 ]
11	38m44s	update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:54:36.449171', exp_date = '2025-02-05 15:39:36.449173', logged_in = 'TRUE' where id = 832; [ Date: 2025-02-05 16:33:20 ]
12	38m42s	update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:54:38.952075', exp_date = '2025-02-05 15:39:38.952077', logged_in = 'TRUE' where id = 832; [ Date: 2025-02-05 16:33:21 ]
13	35m44s	update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:57:36.683117', exp_date = '2025-02-05 15:42:36.683121', logged_in = 'TRUE' where id = 832; [ Date: 2025-02-05 16:33:21 ]
14	34m54s	update res_users set sid = '4d2d63cc2a1e8b6e791a5d5b5f9013180b300110', last_update = '2025-02-05 15:33:26.440941', exp_date = '2025-02-05 16:18:26.440943', logged_in = 'TRUE' where id = 869; [ Date: 2025-02-05 17:08:21 ]
15	30m17s	update res_users set sid = '4d2d63cc2a1e8b6e791a5d5b5f9013180b300110', last_update = '2025-02-05 15:38:03.808877', exp_date = '2025-02-05 16:23:03.808881', logged_in = 'TRUE' where id = 869; [ Date: 2025-02-05 17:08:21 ]
16	30m17s	update res_users set sid = '4d2d63cc2a1e8b6e791a5d5b5f9013180b300110', last_update = '2025-02-05 15:38:03.984967', exp_date = '2025-02-05 16:23:03.984972', logged_in = 'TRUE' where id = 869; [ Date: 2025-02-05 17:08:21 ]
17	30m17s	update res_users set sid = '4d2d63cc2a1e8b6e791a5d5b5f9013180b300110', last_update = '2025-02-05 15:38:04.143315', exp_date = '2025-02-05 16:23:04.143321', logged_in = 'TRUE' where id = 869; [ Date: 2025-02-05 17:08:21 ]
18	29m38s	update res_users set sid = '4d2d63cc2a1e8b6e791a5d5b5f9013180b300110', last_update = '2025-02-05 15:38:42.628079', exp_date = '2025-02-05 16:23:42.628084', logged_in = 'TRUE' where id = 869; [ Date: 2025-02-05 17:08:21 ]
19	29m31s	update res_users set sid = '2a2d08311fd6ef431d7fe4080fc519c0c651d144', last_update = '2025-02-05 17:41:40.739788', exp_date = '2025-02-05 18:26:40.739791', logged_in = 'TRUE' where id = 1031; [ Date: 2025-02-05 19:11:12 ]
20	29m31s	update res_users set sid = '2a2d08311fd6ef431d7fe4080fc519c0c651d144', last_update = '2025-02-05 17:41:40.739363', exp_date = '2025-02-05 18:26:40.739366', logged_in = 'TRUE' where id = 1031; [ Date: 2025-02-05 19:11:12 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d7h58m20s

66,511

Details

0ms

38m57s

4s328ms

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
Feb 05	00	1,058	241ms	0ms
	01	946	218ms	0ms
	02	1,016	1m22s	81ms
	03	989	228ms	0ms
	04	977	229ms	0ms
	05	746	166ms	0ms
	06	619	147ms	0ms
	07	431	93ms	0ms
	08	1,623	351ms	0ms
	09	4,315	4h27m23s	3s718ms
	10	5,698	3h13m5s	2s33ms
	11	6,808	5h2m10s	2s663ms
	12	7,443	6h13m49s	3s13ms
	13	6,082	10h27m22s	6s189ms
	14	5,311	9h28m46s	6s425ms
	15	4,836	8h52s	5s966ms
	16	4,249	8h46m34s	7s435ms
	17	3,517	9h13m5s	9s435ms
	18	3,235	3h1m15s	3s361ms
	19	2,636	8h25m	11s494ms
	20	2,155	52m11s	1s453ms
	21	1,206	2h45m19s	8s224ms
	22	615	131ms	0ms

update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:54:23.969504', exp_date = '2025-02-05 15:39:23.969507', logged_in = 'TRUE' where id = 832;

Date: 2025-02-05 16:33:20 Duration: 38m57s
update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:26.056573', exp_date = '2025-02-05 15:39:26.056576', logged_in = 'TRUE' where id = 1402;

Date: 2025-02-05 16:33:20 Duration: 38m54s
update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:26.111125', exp_date = '2025-02-05 15:39:26.111129', logged_in = 'TRUE' where id = 1402;

Date: 2025-02-05 16:33:20 Duration: 38m54s

2

2d3h13m6s

274,022

Details

361ms

5s921ms

672ms

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
Feb 05	00	8,084	1h19m4s	586ms
	01	8,618	1h25m28s	595ms
	02	7,705	1h14m45s	582ms
	03	9,745	1h35m34s	588ms
	04	9,920	1h39m28s	601ms
	05	6,833	1h7m3s	588ms
	06	6,379	1h1m29s	578ms
	07	2,829	26m48s	568ms
	08	4,293	41m13s	576ms
	09	15,271	2h46m10s	652ms
	10	13,977	2h26m37s	629ms
	11	26,342	5h48m54s	794ms
	12	20,456	3h55m59s	692ms
	13	14,816	2h41m7s	652ms
	14	11,193	2h	643ms
	15	8,974	1h31m59s	615ms
	16	10,633	1h51m	626ms
	17	12,592	2h23m39s	684ms
	18	14,011	2h44m49s	705ms
	19	23,542	5h1m29s	768ms
	20	17,775	3h45m32s	761ms
	21	15,153	2h51m19s	678ms
	22	4,881	53m29s	657ms

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

Date: 2025-02-05 19:07:49 Duration: 5s921ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5096836)) AND (("shipping_track"."id" not in (42293252, 42293252)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 20:08:54 Duration: 5s260ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5097034)) AND (("shipping_track"."id" not in (42294329, 42294329)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 20:11:33 Duration: 5s251ms

3

9h11m33s

147,219

Details

160ms

1s580ms

224ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 05	00	1,558	5m10s	199ms
	01	2,592	8m39s	200ms
	02	3,308	10m57s	198ms
	03	4,260	14m15s	200ms
	04	4,293	14m33s	203ms
	05	2,755	9m10s	199ms
	06	1,609	5m19s	198ms
	07	947	3m7s	198ms
	08	4,316	14m47s	205ms
	09	9,841	37m15s	227ms
	10	5,547	20m9s	218ms
	11	12,308	58m32s	285ms
	12	7,649	30m8s	236ms
	13	9,128	34m38s	227ms
	14	9,450	35m3s	222ms
	15	4,888	17m21s	212ms
	16	4,476	16m10s	216ms
	17	10,386	37m55s	219ms
	18	14,809	49m55s	202ms
	19	12,914	45m30s	211ms
	20	17,357	1h13m18s	253ms
	21	2,797	9m25s	202ms
	22	31	5s442ms	175ms

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

Date: 2025-02-05 20:08:43 Duration: 1s580ms
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" = '166954')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-05 11:16:38 Duration: 1s580ms
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" = '227331')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-05 11:15:43 Duration: 1s568ms

4

8h53m57s

46,161

Details

360ms

6s217ms

694ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 05	00	225	2m24s	643ms
	01	159	1m46s	667ms
	02	174	1m55s	666ms
	03	201	2m16s	680ms
	04	182	2m5s	688ms
	05	393	4m2s	618ms
	06	260	2m40s	618ms
	07	251	2m29s	595ms
	08	873	8m41s	596ms
	09	3,743	41m14s	661ms
	10	4,543	48m43s	643ms
	11	5,762	1h22m52s	862ms
	12	5,359	1h4m6s	717ms
	13	3,343	37m35s	674ms
	14	3,431	36m56s	646ms
	15	2,644	27m15s	618ms
	16	3,314	34m33s	625ms
	17	2,774	30m36s	661ms
	18	2,387	27m35s	693ms
	19	2,321	29m10s	754ms
	20	2,202	27m2s	736ms
	21	1,232	13m44s	668ms
	22	388	4m6s	635ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5076284, 5069646, 5067337, 5062966, 5058849, 5051959, 5049753, 5037791, 5034651, 5025759, 4902648)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 11:16:27 Duration: 6s217ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5080866, 5080769, 5080758, 5080744, 5079924, 5078056, 5077623, 5074840, 5074694, 5074479, 5074324, 5074303, 5074299, 5074297, 5074251, 5074249, 5074245, 5073837, 5070874, 5070631, 5069752, 5068545, 5067194, 5065169, 5064734, 5062636, 5062497, 5062487, 5062472, 5062436, 5062350, 5061693, 5060639, 5060613, 5059349, 5058572, 5058477, 5057948, 5057932, 5057868, 5057293, 5056325, 5055536, 5055441, 5055394, 5054804, 5054720, 5054641, 5054634, 5053825, 5053708, 5053055, 5052924, 5052892, 5052711, 5052702, 5051090, 5050230, 5049214, 5047516, 5047493, 5042851, 5037921, 5026667)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 11:16:06 Duration: 5s990ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5081153, 5006228)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 11:15:25 Duration: 5s861ms

5

6h15m43s

347

Details

0ms

54m23s

1m4s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 05	00	4	2ms	0ms
	01	4	0ms	0ms
	02	5	1ms	0ms
	03	5	54m23s	10m52s
	04	2	0ms	0ms
	05	3	0ms	0ms
	06	4	0ms	0ms
	07	1	0ms	0ms
	08	20	5ms	0ms
	09	35	22m4s	37s842ms
	10	24	25m18s	1m3s
	11	33	49m30s	1m30s
	12	35	24m11s	41s464ms
	13	27	2m6s	4s689ms
	14	40	1h7m10s	1m40s
	15	28	1h45m10s	3m45s
	16	29	35ms	1ms
	17	16	25m47s	1m36s
	18	12	17ms	1ms
	19	10	14ms	1ms
	20	3	9ms	3ms
	21	5	7ms	1ms
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-05 02:07:07.305608', "last_update" = '2025-02-05 01:22:07.305633', "sid" = 'c935130f5f26f8da16ed37566f2e173c37d7448a', "write_date" = '2025-02-05 01:22:06.987893', "write_uid" = 1 WHERE id IN (1208);

Date: 2025-02-05 03:16:31 Duration: 54m23s
UPDATE "res_users" SET "exp_date" = '2025-02-05 16:27:33.594121', "last_update" = '2025-02-05 15:42:33.594144', "sid" = '1e1afbf9d84bda2f0fa779b3e203c1339360d370', "write_date" = '2025-02-05 15:42:33.266411', "write_uid" = 869 WHERE id IN (869);

Date: 2025-02-05 17:08:21 Duration: 25m47s
UPDATE "res_users" SET "exp_date" = '2025-02-05 09:45:02.235293', "last_update" = '2025-02-05 09:00:02.235317', "sid" = '31b094dc23807a980eec5ab9c0bf977741fe8c6f', "write_date" = '2025-02-05 09:00:01.849688', "write_uid" = 1 WHERE id IN (959);

Date: 2025-02-05 10:25:21 Duration: 25m18s

6

4h14m59s

61,900

Details

99ms

926ms

247ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 05	00	2,984	11m32s	231ms
	01	4,054	14m45s	218ms
	02	1,632	5m52s	215ms
	03	1,692	6m26s	228ms
	04	4,240	16m	226ms
	05	2,208	8m26s	229ms
	06	1,126	4m17s	228ms
	07	2	259ms	129ms
	08	10	2s169ms	216ms
	09	230	55s325ms	240ms
	10	74	18s977ms	256ms
	11	404	2m	299ms
	12	536	2m19s	260ms
	13	412	1m49s	265ms
	14	1,596	6m35s	247ms
	15	1,724	7m7s	247ms
	16	3,018	11m53s	236ms
	17	6,570	28m23s	259ms
	18	5,914	25m11s	255ms
	19	8,055	38m19s	285ms
	20	7,055	31m37s	268ms
	21	4,478	16m43s	224ms
	22	3,886	14m20s	221ms

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-02-05 19:59:50 Duration: 926ms
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-02-05 19:59:50 Duration: 926ms
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-02-05 20:11:44 Duration: 874ms

7

2h41m38s

11,943

Details

216ms

1s990ms

812ms

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
Feb 05	00	233	3m33s	914ms
	01	228	3m30s	922ms
	02	483	7m23s	918ms
	03	589	2m36s	265ms
	04	302	1m18s	260ms
	09	9	8s86ms	898ms
	10	9	2s752ms	305ms
	11	84	1m32s	1s101ms
	12	128	2m24s	1s129ms
	13	142	1m34s	668ms
	14	486	5m52s	725ms
	15	453	4m34s	606ms
	16	685	9m39s	846ms
	17	1,073	15m44s	880ms
	18	1,362	18m37s	820ms
	19	1,406	24m23s	1s40ms
	20	2,362	34m11s	868ms
	21	907	12m24s	820ms
	22	1,002	12m5s	724ms

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

Date: 2025-02-05 11:20:37 Duration: 1s990ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '107870')) 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 (110))))))) 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 (110)))))) 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 (110)))))) 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 (110))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-05 19:07:55 Duration: 1s935ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '201011')) 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 (67))))))) 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 (67)))))) 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 (67)))))) 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 (67))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-05 20:06:06 Duration: 1s881ms

8

2h31m44s

27,581

Details

195ms

1s550ms

330ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 05	08	824	3m47s	275ms
	09	3,736	19m8s	307ms
	10	2,330	11m26s	294ms
	11	3,595	21m9s	353ms
	12	2,910	15m50s	326ms
	13	3,109	17m8s	330ms
	14	4,051	23m43s	351ms
	15	3,097	18m12s	352ms
	16	2,066	12m22s	359ms
	17	1,561	7m25s	285ms
	18	302	1m29s	295ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '306572')))) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:42 Duration: 1s550ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '305074')))) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:43 Duration: 1s513ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '225865')))) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:15:38 Duration: 1s468ms

9

2h18m5s

158,758

Details

36ms

407ms

52ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 05	00	3,644	2m47s	45ms
	01	3,141	2m25s	46ms
	02	2,145	1m40s	46ms
	03	3,787	2m58s	47ms
	04	3,163	2m28s	46ms
	05	1,859	1m26s	46ms
	06	2,433	1m53s	46ms
	07	1,267	58s310ms	46ms
	08	2,885	2m15s	46ms
	09	11,672	10m17s	52ms
	10	11,584	9m48s	50ms
	11	18,286	19m17s	63ms
	12	16,266	15m1s	55ms
	13	12,233	10m41s	52ms
	14	9,248	7m50s	50ms
	15	7,203	5m49s	48ms
	16	7,369	6m4s	49ms
	17	8,369	6m58s	50ms
	18	8,703	7m15s	50ms
	19	7,879	7m11s	54ms
	20	7,239	6m14s	51ms
	21	5,560	4m30s	48ms
	22	2,823	2m8s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5081975, 5081974, 5081973, 5081972, 5003083)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:19:07 Duration: 407ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5057960, 5040461, 5037043, 4972629)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:24:13 Duration: 398ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5044970, 5043743, 5041348, 5041327, 5041321, 5031657, 5031656, 5028973, 5026452)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:16:43 Duration: 363ms

10

1h37m42s

19,420

Details

203ms

1s635ms

301ms

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
Feb 05	00	1,293	6m9s	285ms
	01	1,820	8m41s	286ms
	02	346	1m39s	288ms
	03	262	1m18s	301ms
	04	1,848	8m50s	287ms
	05	1,135	5m17s	279ms
	06	576	2m45s	287ms
	07	1	292ms	292ms
	08	7	2s20ms	288ms
	09	111	35s80ms	316ms
	10	33	11s102ms	336ms
	11	123	48s356ms	393ms
	12	151	50s133ms	332ms
	13	68	24s177ms	355ms
	14	326	1m44s	319ms
	15	423	2m10s	309ms
	16	849	4m19s	305ms
	17	2,254	11m25s	304ms
	18	1,632	8m10s	300ms
	19	2,655	14m45s	333ms
	20	1,197	6m48s	341ms
	21	1,350	6m26s	285ms
	22	960	4m16s	267ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '253030')) 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-02-05 20:09:04 Duration: 1s635ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9900241')) 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-02-05 11:50:24 Duration: 1s565ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '186778')) 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-02-05 19:49:10 Duration: 1s490ms

11

1h28m27s

51

Details

0ms

59m59s

1m44s

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
Feb 05	00	1	0ms	0ms
	02	2	0ms	0ms
	03	3	59m59s	19m59s
	04	2	0ms	0ms
	08	5	1ms	0ms
	09	4	5m50s	1m27s
	10	2	3ms	1ms
	11	2	4ms	2ms
	12	9	2m49s	18s818ms
	13	7	8ms	1ms
	14	6	8ms	1ms
	16	3	3ms	1ms
	17	3	3ms	1ms
	19	2	19m48s	9m54s

UPDATE "res_users" SET "exp_date" = '2025-02-05 02:01:31.632263', "last_update" = '2025-02-05 01:16:31.632286', "write_date" = '2025-02-05 01:16:31.224617', "write_uid" = 1 WHERE id IN (1208);

Date: 2025-02-05 03:16:31 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-05 18:36:24.420578', "last_update" = '2025-02-05 17:51:24.420608', "write_date" = '2025-02-05 17:51:24.010583', "write_uid" = 1 WHERE id IN (1044);

Date: 2025-02-05 19:11:12 Duration: 19m48s
UPDATE "res_users" SET "exp_date" = '2025-02-05 09:28:30.663607', "last_update" = '2025-02-05 08:43:30.663635', "write_date" = '2025-02-05 08:43:30.270428', "write_uid" = 959 WHERE id IN (959);

Date: 2025-02-05 09:49:21 Duration: 5m50s

12

56m8s

14,778

Details

164ms

1s543ms

227ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 05	00	181	35s955ms	198ms
	01	16	3s198ms	199ms
	02	204	40s674ms	199ms
	03	24	5s565ms	231ms
	04	633	2m7s	200ms
	05	432	1m26s	200ms
	06	917	3m2s	199ms
	07	947	3m8s	198ms
	08	1,158	3m53s	201ms
	09	1,885	6m58s	221ms
	10	729	2m45s	226ms
	11	2,748	13m13s	288ms
	12	977	4m6s	252ms
	13	877	3m19s	227ms
	14	657	2m23s	219ms
	15	578	2m1s	210ms
	16	320	1m7s	210ms
	17	323	1m5s	201ms
	18	647	2m10s	201ms
	19	260	55s991ms	215ms
	20	184	40s404ms	219ms
	21	50	9s246ms	184ms
	22	31	5s479ms	176ms

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" = '303388')) 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-02-05 11:14:32 Duration: 1s543ms
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" = '256428')) 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-02-05 11:15:03 Duration: 1s460ms
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" = '247612')) 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-02-05 11:14:55 Duration: 1s420ms

13

52m51s

15,799

Details

178ms

267ms

200ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 05	00	1,377	4m35s	199ms
	01	2,553	8m31s	200ms
	02	3,069	10m10s	198ms
	03	3,737	12m30s	200ms
	04	3,381	11m27s	203ms
	05	1,631	5m25s	199ms
	06	51	10s187ms	199ms

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

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

Date: 2025-02-05 02:44:17 Duration: 250ms
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" = '154067')) 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-02-05 02:44:17 Duration: 249ms

14

50m3s

45,714

Details

48ms

377ms

65ms

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

Day	Hour	Count	Duration	Avg duration
Feb 05	08	1,304	1m17s	59ms
	09	5,268	5m53s	67ms
	10	5,215	5m32s	63ms
	11	4,679	6m11s	79ms
	12	4,930	5m33s	67ms
	13	6,302	6m59s	66ms
	14	4,317	4m40s	65ms
	15	3,677	3m45s	61ms
	16	3,843	3m57s	61ms
	17	2,999	2m59s	59ms
	18	3,066	3m3s	59ms
	19	69	4s682ms	67ms
	20	30	2s360ms	78ms
	21	14	871ms	62ms
	22	1	62ms	62ms

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

Date: 2025-02-05 11:15:34 Duration: 377ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4974836) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:54 Duration: 377ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4944956) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:52 Duration: 366ms

15

44m1s

20,484

Details

98ms

851ms

128ms

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
Feb 05	02	71	7s639ms	107ms
	05	48	5s584ms	116ms
	07	23	2s715ms	118ms
	08	199	23s532ms	118ms
	09	1,283	2m45s	129ms
	10	2,169	4m28s	123ms
	11	2,118	5m34s	157ms
	12	2,660	5m57s	134ms
	13	2,032	4m8s	122ms
	14	1,525	3m5s	121ms
	15	2,347	4m41s	119ms
	16	1,166	2m20s	120ms
	17	1,964	4m9s	126ms
	18	703	1m31s	130ms
	19	1,037	2m12s	127ms
	20	1,008	2m9s	128ms
	21	59	7s685ms	130ms
	22	72	8s423ms	116ms

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

Date: 2025-02-05 11:14:30 Duration: 851ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8091400)) AND (("cash_track"."id" not in (7733957)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-05 11:20:31 Duration: 814ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8090942)) AND (("cash_track"."id" not in (7731259, 7737234, 7755831, 7765732, 7765732)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-05 20:08:52 Duration: 787ms

16

19m3s

19,109

Details

43ms

283ms

59ms

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
Feb 05	08	690	37s801ms	54ms
	09	2,569	2m35s	60ms
	10	2,302	2m10s	56ms
	11	2,233	2m40s	71ms
	12	1,855	1m55s	62ms
	13	2,503	2m31s	60ms
	14	2,444	2m20s	57ms
	15	1,438	1m20s	56ms
	16	1,901	1m47s	56ms
	17	872	47s894ms	54ms
	18	302	15s920ms	52ms

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

Date: 2025-02-05 11:19:30 Duration: 283ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4954551) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:15:00 Duration: 281ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5041255) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:19:29 Duration: 280ms

17

17m12s

6,006

Details

121ms

1s233ms

171ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 05	00	20	2s651ms	132ms
	01	5	668ms	133ms
	04	11	1s505ms	136ms
	06	6	806ms	134ms
	08	133	17s863ms	134ms
	09	451	1m14s	164ms
	10	644	1m37s	151ms
	11	1,508	5m25s	215ms
	12	1,258	3m39s	174ms
	13	613	1m33s	151ms
	14	249	37s66ms	148ms
	15	248	34s961ms	140ms
	16	175	24s685ms	141ms
	17	129	18s987ms	147ms
	18	133	19s594ms	147ms
	19	289	42s733ms	147ms
	20	85	14s533ms	170ms
	21	47	6s968ms	148ms
	22	2	267ms	133ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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-02-05 12:01:50 Duration: 1s233ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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-02-05 12:01:40 Duration: 1s226ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 19)) 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-02-05 09:35:41 Duration: 1s224ms

18

14m23s

3,340

Details

180ms

1s547ms

258ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 05	02	13	2s612ms	200ms
	06	489	1m37s	198ms
	09	124	28s930ms	233ms
	10	14	3s3ms	214ms
	11	2,502	11m23s	273ms
	12	144	36s455ms	253ms
	20	54	11s172ms	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" = '253254')) 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-02-05 11:12:31 Duration: 1s547ms
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" = '219090')) 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-02-05 11:54:04 Duration: 1s498ms
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" = '327060')) 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-02-05 11:54:04 Duration: 1s328ms

19

12m27s

236

Details

338ms

6s393ms

3s168ms

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
Feb 05	10	9	24s389ms	2s709ms
	11	19	1m12s	3s840ms
	12	15	45s428ms	3s28ms
	13	24	1m7s	2s826ms
	14	32	1m41s	3s180ms
	15	13	37s842ms	2s910ms
	16	14	47s75ms	3s362ms
	17	28	1m26s	3s74ms
	18	15	48s596ms	3s239ms
	19	25	1m13s	2s928ms
	20	32	1m52s	3s508ms
	21	7	21s510ms	3s72ms
	22	3	8s742ms	2s914ms

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

Date: 2025-02-05 20:09:11 Duration: 6s393ms
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 (123))))))) 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 (123)))))) 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 (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) 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 (123))))))))) 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 (123)))))))) AND ("policy_number"."name"::text ilike '%224%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-05 20:09:13 Duration: 5s67ms
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 (123))))))) 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 (123)))))) 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 (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) 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 (123))))))))) 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 (123)))))))) AND ("policy_number"."name"::text ilike '%22410%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-05 20:09:16 Duration: 5s67ms

20

12m25s

2,515

Details

16ms

3s994ms

296ms

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
Feb 05	00	1	291ms	291ms
	01	3	1s123ms	374ms
	02	1	18ms	18ms
	05	2	139ms	69ms
	06	1	202ms	202ms
	07	5	1s377ms	275ms
	08	49	4s844ms	98ms
	09	136	29s789ms	219ms
	10	229	59s360ms	259ms
	11	333	2m1s	364ms
	12	296	1m35s	322ms
	13	298	1m24s	282ms
	14	297	1m23s	280ms
	15	272	1m12s	265ms
	16	188	48s832ms	259ms
	17	124	46s238ms	372ms
	18	100	31s997ms	319ms
	19	74	30s285ms	409ms
	20	70	27s71ms	386ms
	21	29	5s953ms	205ms
	22	7	1s214ms	173ms

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 (40)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (40))))) 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-02-05 11:20:37 Duration: 3s994ms
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-02-05 11:15:16 Duration: 3s737ms
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 (113)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (113))))) 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-02-05 12:02:04 Duration: 3s301ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,456,251

Details

2m2s

0ms

16ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 05	00	43,308	2s186ms	0ms
	01	41,874	2s144ms	0ms
	02	41,452	2s58ms	0ms
	03	40,389	2s152ms	0ms
	04	35,230	1s926ms	0ms
	05	31,443	1s638ms	0ms
	06	32,347	1s675ms	0ms
	07	27,118	1s235ms	0ms
	08	62,507	3s71ms	0ms
	09	147,343	7s867ms	0ms
	10	201,392	10s285ms	0ms
	11	229,802	12s853ms	0ms
	12	231,074	12s404ms	0ms
	13	206,043	10s174ms	0ms
	14	185,421	8s391ms	0ms
	15	174,843	8s226ms	0ms
	16	170,756	8s289ms	0ms
	17	132,916	6s189ms	0ms
	18	120,190	5s721ms	0ms
	19	104,553	5s44ms	0ms
	20	87,366	4s38ms	0ms
	21	75,954	3s168ms	0ms
	22	32,930	1s360ms	0ms

DISCARD ALL;

Date: 2025-02-05 12:54:26 Duration: 16ms
DISCARD ALL;

Date: 2025-02-05 09:22:13 Duration: 1ms
DISCARD ALL;

Date: 2025-02-05 03:21:16 Duration: 1ms

2

1,935,727

Details

30s362ms

0ms

16ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 05	00	31,766	547ms	0ms
	01	31,222	537ms	0ms
	02	31,562	523ms	0ms
	03	31,344	544ms	0ms
	04	27,402	495ms	0ms
	05	24,006	422ms	0ms
	06	25,907	431ms	0ms
	07	20,660	318ms	0ms
	08	49,840	738ms	0ms
	09	120,922	1s968ms	0ms
	10	164,421	2s511ms	0ms
	11	189,991	3s568ms	0ms
	12	187,918	3s79ms	0ms
	13	162,720	2s477ms	0ms
	14	144,601	2s112ms	0ms
	15	134,551	1s942ms	0ms
	16	129,703	1s920ms	0ms
	17	103,475	1s510ms	0ms
	18	93,068	1s340ms	0ms
	19	79,309	1s234ms	0ms
	20	66,582	990ms	0ms
	21	60,841	802ms	0ms
	22	23,916	343ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-05 10:23:16 Duration: 16ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-05 09:14:11 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-05 00:05:13 Duration: 1ms

3

1,249,976

Details

13s647ms

0ms

17ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 05	00	22,344	230ms	0ms
	01	21,621	220ms	0ms
	02	21,487	212ms	0ms
	03	20,898	220ms	0ms
	04	18,278	201ms	0ms
	05	16,332	173ms	0ms
	06	16,813	170ms	0ms
	07	14,150	130ms	0ms
	08	32,400	310ms	0ms
	09	74,995	867ms	0ms
	10	101,832	1s94ms	0ms
	11	116,367	1s599ms	0ms
	12	116,829	1s380ms	0ms
	13	104,167	1s112ms	0ms
	14	94,048	971ms	0ms
	15	88,780	881ms	0ms
	16	86,759	879ms	0ms
	17	67,514	706ms	0ms
	18	61,020	633ms	0ms
	19	53,107	608ms	0ms
	20	44,507	506ms	0ms
	21	38,707	379ms	0ms
	22	17,021	158ms	0ms

ROLLBACK;

Date: 2025-02-05 16:42:19 Duration: 17ms
ROLLBACK;

Date: 2025-02-05 12:27:49 Duration: 1ms
ROLLBACK;

Date: 2025-02-05 15:46:21 Duration: 0ms

4

1,238,358

Details

4m5s

0ms

19ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 05	00	21,692	4s289ms	0ms
	01	20,963	4s272ms	0ms
	02	20,768	4s18ms	0ms
	03	20,250	4s259ms	0ms
	04	17,613	3s820ms	0ms
	05	15,698	3s196ms	0ms
	06	16,164	3s103ms	0ms
	07	13,546	2s98ms	0ms
	08	31,480	5s332ms	0ms
	09	74,583	15s930ms	0ms
	10	101,979	20s777ms	0ms
	11	116,158	27s334ms	0ms
	12	116,667	24s416ms	0ms
	13	103,914	20s221ms	0ms
	14	93,700	18s40ms	0ms
	15	88,281	16s127ms	0ms
	16	86,241	16s264ms	0ms
	17	66,989	12s575ms	0ms
	18	60,531	10s931ms	0ms
	19	52,564	10s166ms	0ms
	20	43,865	8s597ms	0ms
	21	38,162	6s607ms	0ms
	22	16,550	2s687ms	0ms

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

Date: 2025-02-05 12:01:48 Duration: 19ms
SELECT payload FROM http_sessions WHERE sid = 'cb90eb31f5be452c4caf989f4644d7ade4d43357';

Date: 2025-02-05 11:48:17 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = 'bb92e1d5c6d2a9eaf175e2ac1559a219a2ba97e6';

Date: 2025-02-05 12:54:26 Duration: 16ms

5

1,228,088

Details

1m57s

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
Feb 05	00	21,719	1s987ms	0ms
	01	21,012	1s939ms	0ms
	02	20,774	1s855ms	0ms
	03	20,244	1s910ms	0ms
	04	17,679	1s721ms	0ms
	05	15,792	1s474ms	0ms
	06	16,240	1s461ms	0ms
	07	13,641	1s128ms	0ms
	08	31,193	2s598ms	0ms
	09	73,583	7s271ms	0ms
	10	100,672	9s669ms	0ms
	11	114,857	12s951ms	0ms
	12	115,429	11s496ms	0ms
	13	102,919	9s761ms	0ms
	14	92,607	8s589ms	0ms
	15	87,340	7s797ms	0ms
	16	85,333	7s654ms	0ms
	17	66,420	6s174ms	0ms
	18	60,093	5s647ms	0ms
	19	52,282	5s232ms	0ms
	20	43,711	4s369ms	0ms
	21	38,028	3s338ms	0ms
	22	16,520	1s376ms	0ms

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

Date: 2025-02-05 09:22:00 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-05 15:41:12 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-05 09:13:26 Duration: 1ms

6

880,363

Details

2m21s

0ms

19ms

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
Feb 05	00	11,994	2s19ms	0ms
	01	12,608	2s48ms	0ms
	02	12,008	2s12ms	0ms
	03	12,143	2s146ms	0ms
	04	10,443	1s935ms	0ms
	05	8,912	1s607ms	0ms
	06	11,406	1s841ms	0ms
	07	8,059	1s282ms	0ms
	08	22,085	3s108ms	0ms
	09	61,527	9s390ms	0ms
	10	82,598	12s502ms	0ms
	11	96,711	19s144ms	0ms
	12	92,831	17s385ms	0ms
	13	76,244	11s692ms	0ms
	14	65,781	9s408ms	0ms
	15	58,640	8s326ms	0ms
	16	55,261	8s258ms	0ms
	17	45,400	6s925ms	0ms
	18	40,674	6s65ms	0ms
	19	32,820	5s350ms	0ms
	20	27,981	4s414ms	0ms
	21	25,340	3s581ms	0ms
	22	8,897	1s329ms	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 (977, 1219, 932, 1062, 995, 1220, 1116, 1390, 1064, 979, 1029, 956, 985, 838, 878, 843, 939, 1057, 874, 847, 981, 940, 991, 1027, 959, 1031, 1451, 1295, 1387, 936, 835, 1231, 840, 1030, 1344, 988, 849, 1096, 852, 925, 856, 857, 846, 861, 860, 859, 962);

Date: 2025-02-05 13:38:34 Duration: 19ms
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 (846);

Date: 2025-02-05 17:21:55 Duration: 10ms
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 (1299);

Date: 2025-02-05 17:21:55 Duration: 9ms

7

684,847

Details

2m8s

0ms

43ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 05	00	9,421	1s857ms	0ms
	01	9,603	1s979ms	0ms
	02	10,055	2s23ms	0ms
	03	10,463	2s190ms	0ms
	04	9,124	2s45ms	0ms
	05	7,674	1s677ms	0ms
	06	9,094	1s549ms	0ms
	07	6,504	1s89ms	0ms
	08	17,445	2s610ms	0ms
	09	45,854	8s726ms	0ms
	10	62,524	10s691ms	0ms
	11	73,572	16s887ms	0ms
	12	70,959	14s577ms	0ms
	13	58,447	10s716ms	0ms
	14	50,462	8s760ms	0ms
	15	45,683	7s735ms	0ms
	16	42,900	6s919ms	0ms
	17	35,907	6s173ms	0ms
	18	32,000	5s853ms	0ms
	19	26,134	5s950ms	0ms
	20	22,033	4s702ms	0ms
	21	22,105	2s917ms	0ms
	22	6,884	1s335ms	0ms

COMMIT;

Date: 2025-02-05 11:19:41 Duration: 43ms
COMMIT;

Date: 2025-02-05 13:37:44 Duration: 39ms
COMMIT;

Date: 2025-02-05 16:50:34 Duration: 39ms

8

526,589

Details

38s466ms

0ms

18ms

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
Feb 05	00	6,028	390ms	0ms
	01	5,418	348ms	0ms
	02	4,450	279ms	0ms
	03	4,570	308ms	0ms
	04	3,717	254ms	0ms
	05	3,760	222ms	0ms
	06	7,222	411ms	0ms
	07	5,057	278ms	0ms
	08	11,103	648ms	0ms
	09	34,601	2s711ms	0ms
	10	48,987	3s446ms	0ms
	11	57,494	6s32ms	0ms
	12	57,361	4s350ms	0ms
	13	46,143	3s88ms	0ms
	14	39,147	2s637ms	0ms
	15	35,282	2s217ms	0ms
	16	33,841	2s110ms	0ms
	17	29,934	2s75ms	0ms
	18	27,119	1s883ms	0ms
	19	22,085	1s832ms	0ms
	20	18,334	1s440ms	0ms
	21	19,352	1s150ms	0ms
	22	5,584	347ms	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 (8, 41, 19, 68, 123, 22, 70, 14, 26, 64, 52, 39, 30, 60, 66, 51, 55, 17, 119, 77);

Date: 2025-02-05 11:22:51 Duration: 18ms
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 (39, 13, 115, 75, 28, 123, 27, 78, 102, 16, 48, 73, 65, 22, 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, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 62, 51, 55, 30, 67, 66, 79, 68);

Date: 2025-02-05 12:30:07 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (26, 28, 9, 110, 70, 77, 46, 53, 27, 78, 22, 128, 19, 17, 51, 6, 55, 52, 41, 64, 80, 24);

Date: 2025-02-05 11:44:13 Duration: 1ms

9

524,028

Details

1m15s

0ms

29ms

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
Feb 05	00	7,905	894ms	0ms
	01	8,612	1s4ms	0ms
	02	5,639	712ms	0ms
	03	5,966	826ms	0ms
	04	6,696	774ms	0ms
	05	5,363	651ms	0ms
	06	7,191	972ms	0ms
	07	4,437	557ms	0ms
	08	11,228	1s413ms	0ms
	09	37,063	5s680ms	0ms
	10	50,625	7s260ms	0ms
	11	56,593	11s501ms	0ms
	12	55,597	8s707ms	0ms
	13	44,317	6s266ms	0ms
	14	37,301	5s120ms	0ms
	15	33,150	4s238ms	0ms
	16	31,398	3s807ms	0ms
	17	29,451	3s905ms	0ms
	18	25,986	3s421ms	0ms
	19	21,616	3s122ms	0ms
	20	19,434	2s733ms	0ms
	21	11,151	1s334ms	0ms
	22	7,309	698ms	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 (5099009, 5146124);

Date: 2025-02-05 12:01:48 Duration: 29ms
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 (5099958);

Date: 2025-02-05 11:10:15 Duration: 16ms
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 (5102867, 5099310, 5100150, 5099540, 5099035, 5101886, 5099930, 5099007, 5099013, 5099009, 5417409, 5101119, 5158979, 5099349, 5101315, 5106068, 5099014, 5103223, 5099690, 5099382, 5099687, 5099010, 5100477, 5414457, 5178974, 5100431, 5102630, 5100144, 5104173, 5100254, 5099356, 5114905, 5397436, 5102416, 5101468, 5100202, 5099873, 5100781, 5109813, 5099815, 5099046, 5099204, 5099144, 5099006, 5099765, 5099574, 5123891, 5099174, 5115681, 5099206, 5099507, 5099254, 5113818, 5350876, 5099162, 5404234, 5099521, 5100846, 5100362, 5104336, 5107065, 5106166, 5362738, 5114382, 5099111, 5099404, 5100204, 5099639, 5099169, 5403993, 5099194, 5099045, 5106083, 5099025, 5411855, 5099662, 5101846, 5099102, 5099037, 5099027, 5102094, 5099248, 5102119, 5101568, 5101207, 5414998, 5099190, 5101294, 5332717, 5099119, 5132233, 5276675, 5100181, 5099746, 5099130, 5099103, 5120122, 5101020, 5099092, 5100714, 5101850, 5100554, 5184887, 5099764, 5197968, 5099360, 5100810, 5099309, 5117367, 5099128, 5121988, 5099244, 5109522, 5099272, 5136188);

Date: 2025-02-05 15:47:06 Duration: 7ms

10

385,232

Details

2m12s

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

Day	Hour	Count	Duration	Avg duration
Feb 05	00	2,932	929ms	0ms
	01	2,145	700ms	0ms
	02	1,993	611ms	0ms
	03	1,403	468ms	0ms
	04	1,143	381ms	0ms
	05	1,245	390ms	0ms
	06	2,070	646ms	0ms
	07	1,082	322ms	0ms
	08	7,890	2s316ms	0ms
	09	24,072	8s507ms	0ms
	10	31,653	10s907ms	0ms
	11	40,929	17s207ms	0ms
	12	44,181	15s977ms	0ms
	13	36,540	12s286ms	0ms
	14	36,309	11s853ms	0ms
	15	31,545	9s830ms	0ms
	16	25,318	7s910ms	0ms
	17	26,153	8s651ms	0ms
	18	21,190	6s980ms	0ms
	19	18,106	6s482ms	0ms
	20	15,270	5s335ms	0ms
	21	9,139	2s923ms	0ms
	22	2,924	859ms	0ms

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

Date: 2025-02-05 12:15:07 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 = 1286) OR r.global) ORDER BY r.id;

Date: 2025-02-05 18:18:22 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'policy.number' 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 = 1299) OR r.global) ORDER BY r.id;

Date: 2025-02-05 17:33:52 Duration: 3ms

11

359,810

Details

1m13s

0ms

4ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 05	00	4,390	780ms	0ms
	01	4,216	729ms	0ms
	02	3,167	579ms	0ms
	03	2,837	583ms	0ms
	04	2,498	507ms	0ms
	05	2,427	456ms	0ms
	06	4,517	735ms	0ms
	07	3,208	514ms	0ms
	08	10,195	1s575ms	0ms
	09	26,902	5s278ms	0ms
	10	34,577	6s753ms	0ms
	11	39,439	10s342ms	0ms
	12	39,169	8s543ms	0ms
	13	31,826	6s376ms	0ms
	14	28,016	5s390ms	0ms
	15	26,238	4s682ms	0ms
	16	24,306	4s385ms	0ms
	17	19,474	3s877ms	0ms
	18	17,125	3s407ms	0ms
	19	13,911	3s92ms	0ms
	20	11,331	2s538ms	0ms
	21	6,718	1s358ms	0ms
	22	3,323	591ms	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 (8006472, 8007364, 8006346, 8006462, 8006459, 8006456, 8006460, 8006454, 3, 8006455, 8006279, 8007032, 8006458, 8006534, 8006457, 8006461, 8006317, 8006645, 8006428, 8006297, 8004658, 8004683, 8004680, 8007174, 8006453, 8006396);

Date: 2025-02-05 11:44:13 Duration: 4ms
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-02-05 20:29:22 Duration: 4ms
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 (8006472);

Date: 2025-02-05 20:29:22 Duration: 2ms

12

296,379

Details

55s497ms

0ms

16ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 05	00	2,630	364ms	0ms
	01	2,365	324ms	0ms
	02	2,610	311ms	0ms
	03	2,084	261ms	0ms
	04	1,775	228ms	0ms
	05	1,385	178ms	0ms
	06	1,907	262ms	0ms
	07	1,382	181ms	0ms
	08	8,880	1s204ms	0ms
	09	21,107	3s956ms	0ms
	10	23,771	4s419ms	0ms
	11	29,019	6s984ms	0ms
	12	31,058	6s495ms	0ms
	13	26,109	4s940ms	0ms
	14	27,147	5s63ms	0ms
	15	23,409	4s4ms	0ms
	16	18,976	3s90ms	0ms
	17	18,101	3s400ms	0ms
	18	15,701	2s813ms	0ms
	19	15,245	3s18ms	0ms
	20	11,992	2s395ms	0ms
	21	7,221	1s235ms	0ms
	22	2,505	361ms	0ms

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

Date: 2025-02-05 10:23:16 Duration: 16ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1286 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_user' AND model = 'res.groups');

Date: 2025-02-05 18:18:22 Duration: 4ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1424 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_user' AND model = 'res.groups');

Date: 2025-02-05 10:41:05 Duration: 2ms

13

274,022

Details

2d3h13m6s

361ms

5s921ms

672ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 05	00	8,084	1h19m4s	586ms
	01	8,618	1h25m28s	595ms
	02	7,705	1h14m45s	582ms
	03	9,745	1h35m34s	588ms
	04	9,920	1h39m28s	601ms
	05	6,833	1h7m3s	588ms
	06	6,379	1h1m29s	578ms
	07	2,829	26m48s	568ms
	08	4,293	41m13s	576ms
	09	15,271	2h46m10s	652ms
	10	13,977	2h26m37s	629ms
	11	26,342	5h48m54s	794ms
	12	20,456	3h55m59s	692ms
	13	14,816	2h41m7s	652ms
	14	11,193	2h	643ms
	15	8,974	1h31m59s	615ms
	16	10,633	1h51m	626ms
	17	12,592	2h23m39s	684ms
	18	14,011	2h44m49s	705ms
	19	23,542	5h1m29s	768ms
	20	17,775	3h45m32s	761ms
	21	15,153	2h51m19s	678ms
	22	4,881	53m29s	657ms

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

Date: 2025-02-05 19:07:49 Duration: 5s921ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5096836)) AND (("shipping_track"."id" not in (42293252, 42293252)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 20:08:54 Duration: 5s260ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5097034)) AND (("shipping_track"."id" not in (42294329, 42294329)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 20:11:33 Duration: 5s251ms

14

242,730

Details

1m6s

0ms

20ms

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
Feb 05	00	3,756	952ms	0ms
	01	4,391	1s102ms	0ms
	02	2,543	696ms	0ms
	03	2,641	805ms	0ms
	04	3,570	1s12ms	0ms
	05	2,510	731ms	0ms
	06	2,996	899ms	0ms
	07	1,792	503ms	0ms
	08	4,654	1s195ms	0ms
	09	14,776	4s521ms	0ms
	10	20,974	5s779ms	0ms
	11	23,342	8s943ms	0ms
	12	24,180	6s901ms	0ms
	13	19,811	4s951ms	0ms
	14	18,424	4s704ms	0ms
	15	16,658	3s574ms	0ms
	16	14,840	3s765ms	0ms
	17	15,663	3s983ms	0ms
	18	12,621	3s269ms	0ms
	19	12,488	3s388ms	0ms
	20	10,568	2s821ms	0ms
	21	5,581	1s421ms	0ms
	22	3,951	817ms	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 (42071660, 32339809, 32399850, 32426520, 32483841, 32482187, 32406987, 32413760, 32412166, 32503116, 32413262, 32412119, 32459896, 42162878, 42163065, 42163530, 32398703, 32398715, 32436394, 32435944, 32403858, 41989190, 32436079, 32389953, 32456779, 32463753, 32463759, 32464172, 32464039, 32432139, 32368449, 32367885, 32401189, 41939740, 32462560, 32463742, 32440775, 32406720, 32447349, 32236932, 32484512, 32430240, 32445654, 32445647, 32334819, 32341369, 32437242, 32413250, 32437545, 32481749, 32383858, 32383079, 32271111, 32451557, 32469736, 32323430, 42125292, 32342459, 32342431, 32481745, 32355346, 32237896, 32359748, 32373472, 32334290, 32349058, 32270967, 42162868, 32451437, 42162849, 32442714, 32442706, 32386230, 32446339, 32391889, 32391873, 42154771, 32368034, 32367641, 41526863, 41525732, 32320132, 42107574, 32322498, 32258131, 32664034, 32258480, 32386821, 32398457, 32329010, 32398219, 32405592, 32333966, 32242321, 32242025, 32358306, 32332996, 32332998, 32439579, 32327717);

Date: 2025-02-05 17:21:56 Duration: 20ms
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 (42071660, 32339809, 32399850, 32426520, 32483841, 32482187, 32406987, 32413760, 32412166, 32503116, 32413262, 32412119, 32459896, 42162878, 42163065, 42163530, 32398703, 32398715, 32436394, 32435944, 32403858, 41989190, 32436079, 32389953, 32456779, 32463753, 32463759, 32464172, 32464039, 32432139, 32368449, 32367885, 32401189, 41939740, 32462560, 32463742, 32440775, 32406720, 32447349, 32236932, 32484512, 32430240, 32445654, 32445647, 32334819, 32341369, 32437242, 32413250, 32437545, 32481749, 32383858, 32383079, 32271111, 32451557, 32469736, 32323430, 42125292, 32342459, 32342431, 32481745, 32355346, 32237896, 32359748, 32373472, 32334290, 32349058, 32270967, 42162868, 32451437, 42162849, 32442714, 32442706, 32386230, 32446339, 32391889, 32391873, 42154771, 32368034, 32367641, 41526863, 41525732, 32320132, 42107574, 32322498, 32258131, 32664034, 32258480, 32386821, 32398457, 32329010, 32398219, 32405592, 32333966, 32242321, 32242025, 32358306, 32332996, 32332998, 32439579, 32327717);

Date: 2025-02-05 17:21:56 Duration: 20ms
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 (42071660, 32339809, 32399850, 32426520, 32483841, 32482187, 32406987, 32413760, 32412166, 32503116, 32413262, 32412119, 32459896, 42162878, 42163065, 42163530, 32398703, 32398715, 32436394, 32435944, 32403858, 41989190, 32436079, 32389953, 32456779, 32463753, 32463759, 32464172, 32464039, 32432139, 32368449, 32367885, 32401189, 41939740, 32462560, 32463742, 32440775, 32406720, 32447349, 32236932, 32484512, 32430240, 32445654, 32445647, 32334819, 32341369, 32437242, 32413250, 32437545, 32481749, 32383858, 32383079, 32271111, 32451557, 32469736, 32323430, 42125292, 32342459, 32342431, 32481745, 32355346, 32237896, 32359748, 32373472, 32334290, 32349058, 32270967, 42162868, 32451437, 42162849, 32442714, 32442706, 32386230, 32446339, 32391889, 32391873, 42154771, 32368034, 32367641, 41526863, 41525732, 32320132, 42107574, 32322498, 32258131, 32664034, 32258480, 32386821, 32398457, 32329010, 32398219, 32405592, 32333966, 32242321, 32242025, 32358306, 32332996, 32332998, 32439579, 32327717);

Date: 2025-02-05 17:21:56 Duration: 20ms

15

176,800

Details

17s193ms

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
Feb 05	00	2,186	178ms	0ms
	01	2,315	196ms	0ms
	02	1,686	137ms	0ms
	03	1,787	167ms	0ms
	04	1,423	147ms	0ms
	05	1,322	114ms	0ms
	06	2,341	186ms	0ms
	07	1,645	120ms	0ms
	08	4,087	322ms	0ms
	09	12,872	1s449ms	0ms
	10	17,992	1s854ms	0ms
	11	20,016	2s457ms	0ms
	12	19,946	1s823ms	0ms
	13	16,236	1s432ms	0ms
	14	13,379	1s191ms	0ms
	15	11,915	1s4ms	0ms
	16	10,838	931ms	0ms
	17	9,519	810ms	0ms
	18	8,403	714ms	0ms
	19	6,349	698ms	0ms
	20	5,567	710ms	0ms
	21	3,091	346ms	0ms
	22	1,885	194ms	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-02-05 15:47:06 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-02-05 17:21:55 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-02-05 11:05:35 Duration: 1ms

16

169,907

Details

1m40s

0ms

52ms

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"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" from "shipping_policy" where "shipping_policy".id in (...);

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 05	00	637	444ms	0ms
	01	956	666ms	0ms
	02	485	331ms	0ms
	03	220	151ms	0ms
	04	302	174ms	0ms
	05	428	225ms	0ms
	06	622	273ms	0ms
	07	693	299ms	0ms
	08	3,377	1s599ms	0ms
	09	9,448	6s211ms	0ms
	10	10,351	6s595ms	0ms
	11	13,368	10s903ms	0ms
	12	13,176	8s936ms	0ms
	13	13,579	8s452ms	0ms
	14	12,783	7s203ms	0ms
	15	8,245	4s869ms	0ms
	16	7,674	4s530ms	0ms
	17	9,168	4s969ms	0ms
	18	12,340	6s204ms	0ms
	19	21,636	10s910ms	0ms
	20	18,725	10s440ms	0ms
	21	10,770	5s88ms	0ms
	22	924	533ms	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"."is_change_cash_price" AS "is_change_cash_price", "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 (3350397, 3338890, 3341029, 3273706, 3293555, 3304523, 3325994, 2916795, 3034226, 3211234, 3215148, 3243416, 3265239, 3293571, 3307910, 3326001, 3261007, 3287645, 3321425, 3306058, 3325098, 2983677, 3275832, 3335654, 3286818, 3302629, 3318728, 3312313, 3294317, 3297246, 3094913, 3330697, 3278574, 3312168, 3293031, 3292518, 3271167, 3304227, 3301259, 3353644, 2690998, 3281895, 2967071, 3007633, 3280760, 3090124, 3239429, 3263123, 3192656, 3224686, 3180132, 3256565, 3241316, 3242709, 2685594, 3170483, 3193946, 3197455, 3205760, 3228063, 3261609, 3261651, 3264125, 3269418, 3271268, 2962203, 2988209, 3057312, 3122066, 3203896, 3313069, 2964435, 2964447, 3153700, 3212225, 3222592, 3224757, 3226719, 3245850, 3251800, 3262873, 3268378, 3278463, 3292772, 3326008, 3226926, 3206715, 3115244, 3307269, 2884689, 3048282, 3101387, 3114052, 3122296, 3132383, 3148192, 3152639, 3182798, 3197524, 3201244, 3213123, 3225903, 3000170, 3227873, 3002754, 3229210, 3111333, 3229888, 3179265, 3231369, 3184659, 3237838, 3203891, 3250260, 3224512, 3253184, 3251528, 3254234, 3256247, 3255809, 3272733, 3281898, 3275944, 3282311, 3278804, 3279410, 3282047, 3288038, 3291044, 3294106, 3297015, 3297847, 3299023, 3299189, 3301559, 3309957, 3323013, 3324632, 3327140, 3327734, 3327748, 3330738, 3332646, 3332686, 3337320, 3339275, 3193304, 3266799, 3226090, 3207141, 3190292, 3215895, 3267731, 3216440, 3207136, 3197462, 3188842, 3198225, 3192616, 3182893, 3233341, 3178158, 3226801, 3249881, 3233344, 3226927, 3207115, 3293071, 3294048, 3233148, 3221497, 3201221, 3273974, 3315757, 3215473, 3297683, 3305682, 3225376, 3315778, 3315746, 3329334, 3330656, 3320298, 3315782, 3329780, 3295357, 3216428, 3324722, 3231058, 3303689, 3330042, 3228340);

Date: 2025-02-05 15:47:07 Duration: 52ms
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"."is_change_cash_price" AS "is_change_cash_price", "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 (4940059, 4979890, 5020017, 5030168, 4980480, 4620287, 4731517, 4791024, 4860528, 4863131, 4900285, 4934359, 4952136, 4971457, 4993499, 4995959, 5003305, 5005694, 5010921, 5011870, 4992756, 5036961, 5023534, 4996526, 5016812, 4990811, 5058093, 5022407, 5051349, 5046232, 5062844, 5030310, 5025244, 4963490, 4973670, 4937884, 4986229, 5005625, 4930528, 5007130, 5034328, 5029617, 5001299, 4998956, 5029134, 5035238, 5033229, 5033244, 5023878, 4977383, 4626046, 4727143, 4732347, 4830677, 4831165, 4887717, 4890616, 4952355, 4957014, 4959883, 4959895, 4963485, 4971781, 4974342, 4975411, 4975555, 4989854, 4990294, 5001017, 5001520, 4949162, 4952417, 4976446, 4991314, 4991707, 4198498, 5000917, 4293548, 5003975, 4950165, 5004183, 4951838, 5005399, 4952885, 5005423, 4964104, 5010087, 4983944, 5016199, 4984296, 5025243, 4991852, 5030051, 4992334, 5037728, 4995284, 5000048, 5000304, 5001454, 5001586, 5003738, 5003743, 5008913, 5011862, 5011876, 5011980, 5012228, 5015468, 5022718, 5022721, 4980029, 5034156, 5029569, 4980933, 5005973, 4996896, 5006041, 4896594, 4981376, 5005406, 5022514, 4598215, 4702187, 5017797, 5017864, 5024323, 5024996, 5033100, 5033378, 5038024, 5038036, 5040910, 3661347, 4862067, 5046432, 5036154, 5028069, 5021622, 5017217, 5019457, 5002549, 5029582, 5023574, 5021761, 4993836, 5040911, 5021133, 5046728, 5038269, 5033636, 4993396, 4440519, 4904999, 4631130, 5025177, 4925477, 5042584, 5029247, 5028386, 5019490, 4928856, 5027641, 5043955, 4928802, 4989297, 4980773, 5021765, 5040782, 5007122, 4992926, 4875135, 5016291, 5021542, 4972738, 5001034, 4868373, 5024279, 5037960, 5037984, 4834151, 5009937, 5034698, 4868377, 4999598, 5028513, 4904758);

Date: 2025-02-05 17:21:55 Duration: 37ms
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"."is_change_cash_price" AS "is_change_cash_price", "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 (4813795, 4743673, 4743666, 4823290, 4823297, 4823302, 4813923, 4813797, 4823295, 4813940, 4813951, 4813947, 4743684, 4813809, 4814094, 4813943, 4813953, 4813937, 4705772, 4813942, 4813810, 4813808, 4743683, 4818038, 4814095, 4813949, 4814066, 4813963, 4813796, 4814065, 4813803, 4743682, 4743678, 4705701, 4618539, 4746306, 4705736, 4743686, 4705717, 4743694, 4743669, 4743665, 4705732, 4743699, 4743662, 4705709, 4743667, 4743697, 4705753, 4743671, 4705702, 4654793, 4743679, 4705713, 4743672, 4705712, 4743689, 4705756, 4746305, 4743663, 4743685, 4743692, 4743696, 4743690, 4705776, 4654786, 4743668, 4705708, 4743693, 4743659, 4705721, 4743687, 4654924, 4705738, 4705785, 4705764, 4705728, 4705705, 4654923, 4705748, 4705743, 4743691, 4743695, 4705706, 4743681, 4743688, 4705715, 4705761, 4705724, 4705740, 4705714, 4705789, 4654202, 4618543, 4705719, 4654947, 4618549, 4705750, 4705722, 4705716, 4705703, 4705780, 4705698, 4654939, 4654940, 4705734, 4705745, 4654191, 4618541, 4654200, 4654198, 4618534, 4654741, 4547552, 4654801, 4654759, 4654787, 4654815, 4654785, 4618552, 4618536, 4654196, 4654193, 4654189, 4618551, 4618544, 4618542, 4654844, 4300972, 4547556, 4618530, 4654800, 4654784, 4618532, 4654859, 4618540, 4618546, 4654941, 4654090, 4654925, 4654181, 4618545, 4654183, 4421436, 4618527, 4618524, 4618535, 4618526, 4618548, 4618531, 4618533, 4618529, 4618538, 4618525, 4618550, 4618537, 4618528, 4525927, 4526034, 4421443, 4525998, 4526022, 4371335, 3949739, 4421440, 4525923, 4421437, 4421442, 4371345, 4526040, 4526002, 4526001, 4526006, 4526036, 4525944, 4525947);

Date: 2025-02-05 10:23:16 Duration: 17ms

17

166,796

Details

10s603ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 05	00	1,290	68ms	0ms
	01	944	49ms	0ms
	02	809	39ms	0ms
	03	494	26ms	0ms
	04	430	22ms	0ms
	05	462	24ms	0ms
	06	884	46ms	0ms
	07	448	22ms	0ms
	08	3,414	172ms	0ms
	09	10,302	679ms	0ms
	10	13,320	835ms	0ms
	11	17,457	1s416ms	0ms
	12	19,260	1s326ms	0ms
	13	15,925	993ms	0ms
	14	15,722	945ms	0ms
	15	13,892	778ms	0ms
	16	10,665	584ms	0ms
	17	11,403	702ms	0ms
	18	9,470	567ms	0ms
	19	7,876	533ms	0ms
	20	6,950	461ms	0ms
	21	4,150	243ms	0ms
	22	1,229	63ms	0ms

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

Date: 2025-02-05 10:25:23 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);

Date: 2025-02-05 14:51:22 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);

Date: 2025-02-05 13:20:44 Duration: 0ms

18

161,032

Details

21s899ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 05	00	1,210	135ms	0ms
	01	923	103ms	0ms
	02	781	79ms	0ms
	03	475	52ms	0ms
	04	405	44ms	0ms
	05	441	48ms	0ms
	06	863	95ms	0ms
	07	445	46ms	0ms
	08	3,289	349ms	0ms
	09	10,113	1s432ms	0ms
	10	13,057	1s732ms	0ms
	11	16,957	3s41ms	0ms
	12	18,679	2s763ms	0ms
	13	15,417	2s24ms	0ms
	14	15,037	1s923ms	0ms
	15	13,311	1s564ms	0ms
	16	10,320	1s187ms	0ms
	17	10,927	1s429ms	0ms
	18	9,075	1s163ms	0ms
	19	7,584	1s116ms	0ms
	20	6,690	952ms	0ms
	21	3,824	481ms	0ms
	22	1,209	131ms	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-02-05 21:17:44 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-05 11:34:14 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (99, 100) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-05 14:53:04 Duration: 1ms

19

158,758

Details

2h18m5s

36ms

407ms

52ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 05	00	3,644	2m47s	45ms
	01	3,141	2m25s	46ms
	02	2,145	1m40s	46ms
	03	3,787	2m58s	47ms
	04	3,163	2m28s	46ms
	05	1,859	1m26s	46ms
	06	2,433	1m53s	46ms
	07	1,267	58s310ms	46ms
	08	2,885	2m15s	46ms
	09	11,672	10m17s	52ms
	10	11,584	9m48s	50ms
	11	18,286	19m17s	63ms
	12	16,266	15m1s	55ms
	13	12,233	10m41s	52ms
	14	9,248	7m50s	50ms
	15	7,203	5m49s	48ms
	16	7,369	6m4s	49ms
	17	8,369	6m58s	50ms
	18	8,703	7m15s	50ms
	19	7,879	7m11s	54ms
	20	7,239	6m14s	51ms
	21	5,560	4m30s	48ms
	22	2,823	2m8s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5081975, 5081974, 5081973, 5081972, 5003083)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:19:07 Duration: 407ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5057960, 5040461, 5037043, 4972629)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:24:13 Duration: 398ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5044970, 5043743, 5041348, 5041327, 5041321, 5031657, 5031656, 5028973, 5026452)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:16:43 Duration: 363ms

20

147,399

Details

51s534ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 05	00	7,463	2s349ms	0ms
	01	9,862	3s72ms	0ms
	02	5,688	2s116ms	0ms
	03	5,972	2s246ms	0ms
	04	10,877	3s507ms	0ms
	05	6,270	2s91ms	0ms
	06	4,160	1s599ms	0ms
	07	915	453ms	0ms
	08	756	376ms	0ms
	09	1,198	576ms	0ms
	10	468	235ms	0ms
	11	3,805	2s445ms	0ms
	12	2,262	1s101ms	0ms
	13	1,808	831ms	0ms
	14	3,453	1s212ms	0ms
	15	3,625	1s147ms	0ms
	16	6,344	2s23ms	0ms
	17	13,298	4s277ms	0ms
	18	11,968	3s871ms	0ms
	19	16,289	6s58ms	0ms
	20	14,144	5s134ms	0ms
	21	9,010	2s686ms	0ms
	22	7,764	2s118ms	0ms

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

Date: 2025-02-05 20:16:50 Duration: 3ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 49) AND ("price_list"."to_office_id" = 113)) ORDER BY "price_list"."id";

Date: 2025-02-05 11:16:13 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 39) AND ("price_list"."to_office_id" = 39)) ORDER BY "price_list"."id";

Date: 2025-02-05 16:51:23 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m59s

1m44s

51

Details

1h28m27s

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
Feb 05	00	1	0ms	0ms
	02	2	0ms	0ms
	03	3	59m59s	19m59s
	04	2	0ms	0ms
	08	5	1ms	0ms
	09	4	5m50s	1m27s
	10	2	3ms	1ms
	11	2	4ms	2ms
	12	9	2m49s	18s818ms
	13	7	8ms	1ms
	14	6	8ms	1ms
	16	3	3ms	1ms
	17	3	3ms	1ms
	19	2	19m48s	9m54s

UPDATE "res_users" SET "exp_date" = '2025-02-05 02:01:31.632263', "last_update" = '2025-02-05 01:16:31.632286', "write_date" = '2025-02-05 01:16:31.224617', "write_uid" = 1 WHERE id IN (1208);

Date: 2025-02-05 03:16:31 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-05 18:36:24.420578', "last_update" = '2025-02-05 17:51:24.420608', "write_date" = '2025-02-05 17:51:24.010583', "write_uid" = 1 WHERE id IN (1044);

Date: 2025-02-05 19:11:12 Duration: 19m48s
UPDATE "res_users" SET "exp_date" = '2025-02-05 09:28:30.663607', "last_update" = '2025-02-05 08:43:30.663635', "write_date" = '2025-02-05 08:43:30.270428', "write_uid" = 959 WHERE id IN (959);

Date: 2025-02-05 09:49:21 Duration: 5m50s

2

0ms

54m23s

1m4s

347

Details

6h15m43s

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
Feb 05	00	4	2ms	0ms
	01	4	0ms	0ms
	02	5	1ms	0ms
	03	5	54m23s	10m52s
	04	2	0ms	0ms
	05	3	0ms	0ms
	06	4	0ms	0ms
	07	1	0ms	0ms
	08	20	5ms	0ms
	09	35	22m4s	37s842ms
	10	24	25m18s	1m3s
	11	33	49m30s	1m30s
	12	35	24m11s	41s464ms
	13	27	2m6s	4s689ms
	14	40	1h7m10s	1m40s
	15	28	1h45m10s	3m45s
	16	29	35ms	1ms
	17	16	25m47s	1m36s
	18	12	17ms	1ms
	19	10	14ms	1ms
	20	3	9ms	3ms
	21	5	7ms	1ms
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-05 02:07:07.305608', "last_update" = '2025-02-05 01:22:07.305633', "sid" = 'c935130f5f26f8da16ed37566f2e173c37d7448a', "write_date" = '2025-02-05 01:22:06.987893', "write_uid" = 1 WHERE id IN (1208);

Date: 2025-02-05 03:16:31 Duration: 54m23s
UPDATE "res_users" SET "exp_date" = '2025-02-05 16:27:33.594121', "last_update" = '2025-02-05 15:42:33.594144', "sid" = '1e1afbf9d84bda2f0fa779b3e203c1339360d370', "write_date" = '2025-02-05 15:42:33.266411', "write_uid" = 869 WHERE id IN (869);

Date: 2025-02-05 17:08:21 Duration: 25m47s
UPDATE "res_users" SET "exp_date" = '2025-02-05 09:45:02.235293', "last_update" = '2025-02-05 09:00:02.235317', "sid" = '31b094dc23807a980eec5ab9c0bf977741fe8c6f', "write_date" = '2025-02-05 09:00:01.849688', "write_uid" = 1 WHERE id IN (959);

Date: 2025-02-05 10:25:21 Duration: 25m18s

3

0ms

38m57s

4s328ms

66,511

Details

3d7h58m20s

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
Feb 05	00	1,058	241ms	0ms
	01	946	218ms	0ms
	02	1,016	1m22s	81ms
	03	989	228ms	0ms
	04	977	229ms	0ms
	05	746	166ms	0ms
	06	619	147ms	0ms
	07	431	93ms	0ms
	08	1,623	351ms	0ms
	09	4,315	4h27m23s	3s718ms
	10	5,698	3h13m5s	2s33ms
	11	6,808	5h2m10s	2s663ms
	12	7,443	6h13m49s	3s13ms
	13	6,082	10h27m22s	6s189ms
	14	5,311	9h28m46s	6s425ms
	15	4,836	8h52s	5s966ms
	16	4,249	8h46m34s	7s435ms
	17	3,517	9h13m5s	9s435ms
	18	3,235	3h1m15s	3s361ms
	19	2,636	8h25m	11s494ms
	20	2,155	52m11s	1s453ms
	21	1,206	2h45m19s	8s224ms
	22	615	131ms	0ms

update res_users set sid = 'ddf5a60dc206137bb5025328c18fa482af6633b6', last_update = '2025-02-05 14:54:23.969504', exp_date = '2025-02-05 15:39:23.969507', logged_in = 'TRUE' where id = 832;

Date: 2025-02-05 16:33:20 Duration: 38m57s
update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:26.056573', exp_date = '2025-02-05 15:39:26.056576', logged_in = 'TRUE' where id = 1402;

Date: 2025-02-05 16:33:20 Duration: 38m54s
update res_users set sid = 'b972765ebd2c5121c4074b5001561edd57ccdc7e', last_update = '2025-02-05 14:54:26.111125', exp_date = '2025-02-05 15:39:26.111129', logged_in = 'TRUE' where id = 1402;

Date: 2025-02-05 16:33:20 Duration: 38m54s

4

338ms

6s393ms

3s168ms

236

Details

12m27s

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
Feb 05	10	9	24s389ms	2s709ms
	11	19	1m12s	3s840ms
	12	15	45s428ms	3s28ms
	13	24	1m7s	2s826ms
	14	32	1m41s	3s180ms
	15	13	37s842ms	2s910ms
	16	14	47s75ms	3s362ms
	17	28	1m26s	3s74ms
	18	15	48s596ms	3s239ms
	19	25	1m13s	2s928ms
	20	32	1m52s	3s508ms
	21	7	21s510ms	3s72ms
	22	3	8s742ms	2s914ms

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

Date: 2025-02-05 20:09:11 Duration: 6s393ms
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 (123))))))) 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 (123)))))) 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 (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) 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 (123))))))))) 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 (123)))))))) AND ("policy_number"."name"::text ilike '%224%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-05 20:09:13 Duration: 5s67ms
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 (123))))))) 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 (123)))))) 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 (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) 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 (123))))))))) 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 (123)))))))) AND ("policy_number"."name"::text ilike '%22410%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-05 20:09:16 Duration: 5s67ms

5

216ms

1s990ms

812ms

11,943

Details

2h41m38s

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
Feb 05	00	233	3m33s	914ms
	01	228	3m30s	922ms
	02	483	7m23s	918ms
	03	589	2m36s	265ms
	04	302	1m18s	260ms
	09	9	8s86ms	898ms
	10	9	2s752ms	305ms
	11	84	1m32s	1s101ms
	12	128	2m24s	1s129ms
	13	142	1m34s	668ms
	14	486	5m52s	725ms
	15	453	4m34s	606ms
	16	685	9m39s	846ms
	17	1,073	15m44s	880ms
	18	1,362	18m37s	820ms
	19	1,406	24m23s	1s40ms
	20	2,362	34m11s	868ms
	21	907	12m24s	820ms
	22	1,002	12m5s	724ms

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

Date: 2025-02-05 11:20:37 Duration: 1s990ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '107870')) 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 (110))))))) 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 (110)))))) 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 (110)))))) 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 (110))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-05 19:07:55 Duration: 1s935ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '201011')) 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 (67))))))) 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 (67)))))) 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 (67)))))) 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 (67))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-05 20:06:06 Duration: 1s881ms

6

360ms

6s217ms

694ms

46,161

Details

8h53m57s

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
Feb 05	00	225	2m24s	643ms
	01	159	1m46s	667ms
	02	174	1m55s	666ms
	03	201	2m16s	680ms
	04	182	2m5s	688ms
	05	393	4m2s	618ms
	06	260	2m40s	618ms
	07	251	2m29s	595ms
	08	873	8m41s	596ms
	09	3,743	41m14s	661ms
	10	4,543	48m43s	643ms
	11	5,762	1h22m52s	862ms
	12	5,359	1h4m6s	717ms
	13	3,343	37m35s	674ms
	14	3,431	36m56s	646ms
	15	2,644	27m15s	618ms
	16	3,314	34m33s	625ms
	17	2,774	30m36s	661ms
	18	2,387	27m35s	693ms
	19	2,321	29m10s	754ms
	20	2,202	27m2s	736ms
	21	1,232	13m44s	668ms
	22	388	4m6s	635ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5076284, 5069646, 5067337, 5062966, 5058849, 5051959, 5049753, 5037791, 5034651, 5025759, 4902648)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 11:16:27 Duration: 6s217ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5080866, 5080769, 5080758, 5080744, 5079924, 5078056, 5077623, 5074840, 5074694, 5074479, 5074324, 5074303, 5074299, 5074297, 5074251, 5074249, 5074245, 5073837, 5070874, 5070631, 5069752, 5068545, 5067194, 5065169, 5064734, 5062636, 5062497, 5062487, 5062472, 5062436, 5062350, 5061693, 5060639, 5060613, 5059349, 5058572, 5058477, 5057948, 5057932, 5057868, 5057293, 5056325, 5055536, 5055441, 5055394, 5054804, 5054720, 5054641, 5054634, 5053825, 5053708, 5053055, 5052924, 5052892, 5052711, 5052702, 5051090, 5050230, 5049214, 5047516, 5047493, 5042851, 5037921, 5026667)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 11:16:06 Duration: 5s990ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5081153, 5006228)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 11:15:25 Duration: 5s861ms

7

361ms

5s921ms

672ms

274,022

Details

2d3h13m6s

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
Feb 05	00	8,084	1h19m4s	586ms
	01	8,618	1h25m28s	595ms
	02	7,705	1h14m45s	582ms
	03	9,745	1h35m34s	588ms
	04	9,920	1h39m28s	601ms
	05	6,833	1h7m3s	588ms
	06	6,379	1h1m29s	578ms
	07	2,829	26m48s	568ms
	08	4,293	41m13s	576ms
	09	15,271	2h46m10s	652ms
	10	13,977	2h26m37s	629ms
	11	26,342	5h48m54s	794ms
	12	20,456	3h55m59s	692ms
	13	14,816	2h41m7s	652ms
	14	11,193	2h	643ms
	15	8,974	1h31m59s	615ms
	16	10,633	1h51m	626ms
	17	12,592	2h23m39s	684ms
	18	14,011	2h44m49s	705ms
	19	23,542	5h1m29s	768ms
	20	17,775	3h45m32s	761ms
	21	15,153	2h51m19s	678ms
	22	4,881	53m29s	657ms

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

Date: 2025-02-05 19:07:49 Duration: 5s921ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5096836)) AND (("shipping_track"."id" not in (42293252, 42293252)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 20:08:54 Duration: 5s260ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5097034)) AND (("shipping_track"."id" not in (42294329, 42294329)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-05 20:11:33 Duration: 5s251ms

8

195ms

1s550ms

330ms

27,581

Details

2h31m44s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 05	08	824	3m47s	275ms
	09	3,736	19m8s	307ms
	10	2,330	11m26s	294ms
	11	3,595	21m9s	353ms
	12	2,910	15m50s	326ms
	13	3,109	17m8s	330ms
	14	4,051	23m43s	351ms
	15	3,097	18m12s	352ms
	16	2,066	12m22s	359ms
	17	1,561	7m25s	285ms
	18	302	1m29s	295ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '306572')))) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:42 Duration: 1s550ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '305074')))) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:43 Duration: 1s513ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '225865')))) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:15:38 Duration: 1s468ms

9

203ms

1s635ms

301ms

19,420

Details

1h37m42s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 05	00	1,293	6m9s	285ms
	01	1,820	8m41s	286ms
	02	346	1m39s	288ms
	03	262	1m18s	301ms
	04	1,848	8m50s	287ms
	05	1,135	5m17s	279ms
	06	576	2m45s	287ms
	07	1	292ms	292ms
	08	7	2s20ms	288ms
	09	111	35s80ms	316ms
	10	33	11s102ms	336ms
	11	123	48s356ms	393ms
	12	151	50s133ms	332ms
	13	68	24s177ms	355ms
	14	326	1m44s	319ms
	15	423	2m10s	309ms
	16	849	4m19s	305ms
	17	2,254	11m25s	304ms
	18	1,632	8m10s	300ms
	19	2,655	14m45s	333ms
	20	1,197	6m48s	341ms
	21	1,350	6m26s	285ms
	22	960	4m16s	267ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '253030')) 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-02-05 20:09:04 Duration: 1s635ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9900241')) 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-02-05 11:50:24 Duration: 1s565ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '186778')) 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-02-05 19:49:10 Duration: 1s490ms

10

16ms

3s994ms

296ms

2,515

Details

12m25s

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
Feb 05	00	1	291ms	291ms
	01	3	1s123ms	374ms
	02	1	18ms	18ms
	05	2	139ms	69ms
	06	1	202ms	202ms
	07	5	1s377ms	275ms
	08	49	4s844ms	98ms
	09	136	29s789ms	219ms
	10	229	59s360ms	259ms
	11	333	2m1s	364ms
	12	296	1m35s	322ms
	13	298	1m24s	282ms
	14	297	1m23s	280ms
	15	272	1m12s	265ms
	16	188	48s832ms	259ms
	17	124	46s238ms	372ms
	18	100	31s997ms	319ms
	19	74	30s285ms	409ms
	20	70	27s71ms	386ms
	21	29	5s953ms	205ms
	22	7	1s214ms	173ms

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 (40)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (40))))) 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-02-05 11:20:37 Duration: 3s994ms
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-02-05 11:15:16 Duration: 3s737ms
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 (113)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (113))))) 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-02-05 12:02:04 Duration: 3s301ms

11

180ms

1s547ms

258ms

3,340

Details

14m23s

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

Day	Hour	Count	Duration	Avg duration
Feb 05	02	13	2s612ms	200ms
	06	489	1m37s	198ms
	09	124	28s930ms	233ms
	10	14	3s3ms	214ms
	11	2,502	11m23s	273ms
	12	144	36s455ms	253ms
	20	54	11s172ms	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" = '253254')) 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-02-05 11:12:31 Duration: 1s547ms
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" = '219090')) 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-02-05 11:54:04 Duration: 1s498ms
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" = '327060')) 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-02-05 11:54:04 Duration: 1s328ms

12

99ms

926ms

247ms

61,900

Details

4h14m59s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 05	00	2,984	11m32s	231ms
	01	4,054	14m45s	218ms
	02	1,632	5m52s	215ms
	03	1,692	6m26s	228ms
	04	4,240	16m	226ms
	05	2,208	8m26s	229ms
	06	1,126	4m17s	228ms
	07	2	259ms	129ms
	08	10	2s169ms	216ms
	09	230	55s325ms	240ms
	10	74	18s977ms	256ms
	11	404	2m	299ms
	12	536	2m19s	260ms
	13	412	1m49s	265ms
	14	1,596	6m35s	247ms
	15	1,724	7m7s	247ms
	16	3,018	11m53s	236ms
	17	6,570	28m23s	259ms
	18	5,914	25m11s	255ms
	19	8,055	38m19s	285ms
	20	7,055	31m37s	268ms
	21	4,478	16m43s	224ms
	22	3,886	14m20s	221ms

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-02-05 19:59:50 Duration: 926ms
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-02-05 19:59:50 Duration: 926ms
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-02-05 20:11:44 Duration: 874ms

13

164ms

1s543ms

227ms

14,778

Details

56m8s

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
Feb 05	00	181	35s955ms	198ms
	01	16	3s198ms	199ms
	02	204	40s674ms	199ms
	03	24	5s565ms	231ms
	04	633	2m7s	200ms
	05	432	1m26s	200ms
	06	917	3m2s	199ms
	07	947	3m8s	198ms
	08	1,158	3m53s	201ms
	09	1,885	6m58s	221ms
	10	729	2m45s	226ms
	11	2,748	13m13s	288ms
	12	977	4m6s	252ms
	13	877	3m19s	227ms
	14	657	2m23s	219ms
	15	578	2m1s	210ms
	16	320	1m7s	210ms
	17	323	1m5s	201ms
	18	647	2m10s	201ms
	19	260	55s991ms	215ms
	20	184	40s404ms	219ms
	21	50	9s246ms	184ms
	22	31	5s479ms	176ms

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" = '303388')) 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-02-05 11:14:32 Duration: 1s543ms
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" = '256428')) 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-02-05 11:15:03 Duration: 1s460ms
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" = '247612')) 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-02-05 11:14:55 Duration: 1s420ms

14

160ms

1s580ms

224ms

147,219

Details

9h11m33s

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
Feb 05	00	1,558	5m10s	199ms
	01	2,592	8m39s	200ms
	02	3,308	10m57s	198ms
	03	4,260	14m15s	200ms
	04	4,293	14m33s	203ms
	05	2,755	9m10s	199ms
	06	1,609	5m19s	198ms
	07	947	3m7s	198ms
	08	4,316	14m47s	205ms
	09	9,841	37m15s	227ms
	10	5,547	20m9s	218ms
	11	12,308	58m32s	285ms
	12	7,649	30m8s	236ms
	13	9,128	34m38s	227ms
	14	9,450	35m3s	222ms
	15	4,888	17m21s	212ms
	16	4,476	16m10s	216ms
	17	10,386	37m55s	219ms
	18	14,809	49m55s	202ms
	19	12,914	45m30s	211ms
	20	17,357	1h13m18s	253ms
	21	2,797	9m25s	202ms
	22	31	5s442ms	175ms

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

Date: 2025-02-05 20:08:43 Duration: 1s580ms
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" = '166954')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-05 11:16:38 Duration: 1s580ms
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" = '227331')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-05 11:15:43 Duration: 1s568ms

15

178ms

267ms

200ms

15,799

Details

52m51s

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
Feb 05	00	1,377	4m35s	199ms
	01	2,553	8m31s	200ms
	02	3,069	10m10s	198ms
	03	3,737	12m30s	200ms
	04	3,381	11m27s	203ms
	05	1,631	5m25s	199ms
	06	51	10s187ms	199ms

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

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

Date: 2025-02-05 02:44:17 Duration: 250ms
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" = '154067')) 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-02-05 02:44:17 Duration: 249ms

16

121ms

1s233ms

171ms

6,006

Details

17m12s

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
Feb 05	00	20	2s651ms	132ms
	01	5	668ms	133ms
	04	11	1s505ms	136ms
	06	6	806ms	134ms
	08	133	17s863ms	134ms
	09	451	1m14s	164ms
	10	644	1m37s	151ms
	11	1,508	5m25s	215ms
	12	1,258	3m39s	174ms
	13	613	1m33s	151ms
	14	249	37s66ms	148ms
	15	248	34s961ms	140ms
	16	175	24s685ms	141ms
	17	129	18s987ms	147ms
	18	133	19s594ms	147ms
	19	289	42s733ms	147ms
	20	85	14s533ms	170ms
	21	47	6s968ms	148ms
	22	2	267ms	133ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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-02-05 12:01:50 Duration: 1s233ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) 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-02-05 12:01:40 Duration: 1s226ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 19)) 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-02-05 09:35:41 Duration: 1s224ms

17

98ms

851ms

128ms

20,484

Details

44m1s

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
Feb 05	02	71	7s639ms	107ms
	05	48	5s584ms	116ms
	07	23	2s715ms	118ms
	08	199	23s532ms	118ms
	09	1,283	2m45s	129ms
	10	2,169	4m28s	123ms
	11	2,118	5m34s	157ms
	12	2,660	5m57s	134ms
	13	2,032	4m8s	122ms
	14	1,525	3m5s	121ms
	15	2,347	4m41s	119ms
	16	1,166	2m20s	120ms
	17	1,964	4m9s	126ms
	18	703	1m31s	130ms
	19	1,037	2m12s	127ms
	20	1,008	2m9s	128ms
	21	59	7s685ms	130ms
	22	72	8s423ms	116ms

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

Date: 2025-02-05 11:14:30 Duration: 851ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8091400)) AND (("cash_track"."id" not in (7733957)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-05 11:20:31 Duration: 814ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8090942)) AND (("cash_track"."id" not in (7731259, 7737234, 7755831, 7765732, 7765732)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-05 20:08:52 Duration: 787ms

18

48ms

377ms

65ms

45,714

Details

50m3s

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
Feb 05	08	1,304	1m17s	59ms
	09	5,268	5m53s	67ms
	10	5,215	5m32s	63ms
	11	4,679	6m11s	79ms
	12	4,930	5m33s	67ms
	13	6,302	6m59s	66ms
	14	4,317	4m40s	65ms
	15	3,677	3m45s	61ms
	16	3,843	3m57s	61ms
	17	2,999	2m59s	59ms
	18	3,066	3m3s	59ms
	19	69	4s682ms	67ms
	20	30	2s360ms	78ms
	21	14	871ms	62ms
	22	1	62ms	62ms

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

Date: 2025-02-05 11:15:34 Duration: 377ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4974836) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:54 Duration: 377ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4944956) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:16:52 Duration: 366ms

19

43ms

283ms

59ms

19,109

Details

19m3s

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
Feb 05	08	690	37s801ms	54ms
	09	2,569	2m35s	60ms
	10	2,302	2m10s	56ms
	11	2,233	2m40s	71ms
	12	1,855	1m55s	62ms
	13	2,503	2m31s	60ms
	14	2,444	2m20s	57ms
	15	1,438	1m20s	56ms
	16	1,901	1m47s	56ms
	17	872	47s894ms	54ms
	18	302	15s920ms	52ms

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

Date: 2025-02-05 11:19:30 Duration: 283ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4954551) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:15:00 Duration: 281ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5041255) ORDER BY "collection_policy"."id";

Date: 2025-02-05 11:19:29 Duration: 280ms

20

36ms

407ms

52ms

158,758

Details

2h18m5s

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
Feb 05	00	3,644	2m47s	45ms
	01	3,141	2m25s	46ms
	02	2,145	1m40s	46ms
	03	3,787	2m58s	47ms
	04	3,163	2m28s	46ms
	05	1,859	1m26s	46ms
	06	2,433	1m53s	46ms
	07	1,267	58s310ms	46ms
	08	2,885	2m15s	46ms
	09	11,672	10m17s	52ms
	10	11,584	9m48s	50ms
	11	18,286	19m17s	63ms
	12	16,266	15m1s	55ms
	13	12,233	10m41s	52ms
	14	9,248	7m50s	50ms
	15	7,203	5m49s	48ms
	16	7,369	6m4s	49ms
	17	8,369	6m58s	50ms
	18	8,703	7m15s	50ms
	19	7,879	7m11s	54ms
	20	7,239	6m14s	51ms
	21	5,560	4m30s	48ms
	22	2,823	2m8s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5081975, 5081974, 5081973, 5081972, 5003083)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:19:07 Duration: 407ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5057960, 5040461, 5037043, 4972629)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:24:13 Duration: 398ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5044970, 5043743, 5041348, 5041327, 5041321, 5031657, 5031656, 5028973, 5026452)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-05 11:16:43 Duration: 363ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

19,052,504 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	10	0.00%
DETAIL	33	0.00%
ERROR	3,719	0.02%
EVENTLOG	1,002	0.01%
FATAL	801	0.00%
HINT	3	0.00%
LOG	19,043,181	99.95%
STATEMENT	3,755	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
801 FATAL entries
3719 ERROR entries
0 WARNING entries
1002 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,973 Max number of times the same event was reported
5,522 Total events found

Rank

Times reported

Error

1

1,973

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 05	00	15
	01	16
	02	25
	03	29
	04	9
	05	7
	06	10
	07	5
	08	110
	09	108
	10	128
	11	276
	12	212
	13	108
	14	166
	15	140
	16	91
	17	111
	18	89
	19	75
	20	174
	21	50
	22	19

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

2

1,706

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 05	00	13
	01	14
	02	19
	03	21
	04	3
	05	2
	06	9
	07	5
	08	89
	09	97
	10	118
	11	222
	12	198
	13	100
	14	153
	15	132
	16	82
	17	103
	18	71
	19	55
	20	143
	21	38
	22	19

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

634

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 05	03	1
	09	49
	10	22
	11	47
	12	81
	13	69
	14	74
	15	48
	16	25
	17	51
	18	27
	19	52
	20	58
	21	30

FATAL: connection to client lost

4

634

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 05	03	1
	09	49
	10	22
	11	47
	12	81
	13	69
	14	74
	15	48
	16	25
	17	51
	18	27
	19	52
	20	58
	21	30

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

5

251

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 05	03	1
	09	24
	10	11
	11	29
	12	52
	13	27
	14	33
	15	26
	16	7
	17	15
	18	5
	19	13
	20	6
	21	2

6

116

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 05	09	10
	10	8
	11	11
	12	27
	13	12
	14	15
	15	9
	16	3
	17	5
	18	4
	19	8
	20	3
	21	1

7

83

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 05	17	83

FATAL: terminating connection due to administrator command

8

32

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 05	17	32

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

13

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Feb 05	09	1
	10	2
	11	1
	12	1
	13	3
	14	4
	20	1

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

10

11

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Feb 05	17	11

11

10

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Feb 05	02	3
	04	3
	12	3
	22	1

FATAL: password authentication failed for user "postgres"

12

8

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Feb 05	14	1
	18	5
	20	1
	21	1

13

8

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Feb 05	02	1
	08	1
	12	1
	14	1
	15	2
	16	2

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

14

7

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Feb 05	17	7

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

15

7

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Feb 05	13	3
	14	3
	18	1

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

16

6

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Feb 05	14	1
	18	3
	20	1
	21	1

17

5

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Feb 05	14	1
	18	2
	20	1
	21	1

18

4

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Feb 05	17	4

19

4

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Feb 05	13	1
	18	3

20

3

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Feb 05	11	2
	17	1

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

21

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Feb 05	12	2

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

22

2

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Feb 05	08	1
	18	1

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Feb 05	17	1

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Feb 05	21	1

25

1

Details

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

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Feb 05	01	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