pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Feb 7 23:46:39 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 25,346,131 log entries in 1m38s
Log start from 2025-02-07 00:00:00 to 2025-02-07 22:45:01

Global Stats

10,218 Number of unique normalized queries
11,082,656 Number of queries
4d23h12m45s Total query duration
2025-02-07 00:00:00 First query
2025-02-07 22:45:01 Last query
4,351 queries/s at 2025-02-07 15:31:13 Query peak

4d23h12m45s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
4d23h12m45s Execute total duration

3,170 Number of events
19 Number of unique normalized events
1,139 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
11,082,656 Average queries per session
4d23h12m45s 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,351 queries/s Query Peak
2025-02-07 15:31:13 Date

SELECT Traffic

Key values

2,998 queries/s Query Peak
2025-02-07 15:31:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

2,032 queries/s Query Peak
2025-02-07 17:56:31 Date

Queries duration

Key values

4d23h12m45s 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 07	00	284,316	0ms	2s903ms	23ms	3m1s	3m15s	3m46s
	01	286,181	0ms	1s949ms	31ms	4m22s	4m49s	6m43s
	02	250,511	0ms	1s974ms	28ms	3m16s	3m41s	4m54s
	03	240,053	0ms	864ms	27ms	3m24s	4m14s	5m10s
	04	245,397	0ms	6s57ms	27ms	2m56s	3m34s	5m10s
	05	157,917	0ms	728ms	25ms	2m10s	2m20s	3m30s
	06	96,994	0ms	745ms	14ms	1m	1m47s	2m52s
	07	87,233	0ms	742ms	13ms	53s245ms	59s311ms	1m27s
	08	226,325	0ms	1m17s	15ms	2m37s	3m31s	4m29s
	09	520,979	0ms	1m21s	14ms	3m23s	3m58s	6m2s
	10	675,047	0ms	48m18s	60ms	4m9s	5m32s	8h58m10s
	11	520,514	0ms	20m57s	97ms	3m54s	1h53m18s	5h21m35s
	12	653,933	0ms	48m11s	55ms	3m56s	4m20s	7h47m
	13	861,023	0ms	16m56s	57ms	4m20s	2h17m42s	3h43m59s
	14	892,337	0ms	23m33s	37ms	5m4s	6m50s	5h52m51s
	15	806,173	0ms	3s115ms	12ms	3m50s	4m46s	5m59s
	16	792,097	0ms	26m36s	85ms	4m51s	2h35m8s	8h18m59s
	17	1,523,747	0ms	7s902ms	5ms	4m23s	4m35s	5m15s
	18	559,287	0ms	59m59s	35ms	7m29s	9m45s	2h1m11s
	19	550,445	0ms	3m26s	33ms	10m45s	11m10s	12m46s
	20	384,011	0ms	59m59s	43ms	4m59s	5m49s	2h11m15s
	21	319,525	0ms	59m59s	52ms	2m54s	3m43s	3h13s
	22	148,611	0ms	59m59s	44ms	1m33s	1m46s	1h17m41s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 07	00	148,709	45ms	2m36s	3m	3m21s
	01	148,869	60ms	3m34s	4m21s	5m1s
	02	128,032	56ms	2m40s	3m16s	4m1s
	03	121,997	53ms	2m33s	3m24s	4m22s
	04	121,294	56ms	2m35s	2m55s	4m49s
	05	75,341	53ms	1m42s	2m10s	2m46s
	06	47,099	28ms	36s594ms	59s896ms	1m48s
	07	42,197	27ms	36s2ms	53s179ms	1m
	08	126,313	27ms	2m6s	2m30s	3m54s
	09	297,473	25ms	3m6s	3m22s	5m25s
	10	384,659	21ms	2m50s	4m4s	5m32s
	11	299,172	24ms	2m47s	3m48s	4m
	12	379,757	21ms	3m23s	3m47s	4m19s
	13	532,692	17ms	3m17s	3m36s	3m55s
	14	520,401	23ms	4m20s	5m	6m49s
	15	458,370	21ms	3m32s	3m49s	5m7s
	16	471,747	20ms	3m33s	4m17s	5m2s
	17	397,552	19ms	3m17s	3m49s	4m35s
	18	319,122	38ms	4m24s	5m29s	9m42s
	19	318,117	57ms	8m31s	9m49s	11m9s
	20	220,241	39ms	3m54s	4m34s	5m48s
	21	182,295	32ms	2m13s	2m51s	3m42s
	22	79,676	24ms	1m7s	1m32s	2m19s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 07	00	25,899	5,532	141	0	0ms	139ms	183ms	235ms
	01	33,620	8,170	154	0	0ms	186ms	253ms	354ms
	02	24,507	6,437	130	0	0ms	147ms	165ms	222ms
	03	22,340	6,591	131	0	0ms	128ms	167ms	267ms
	04	20,609	6,795	133	0	0ms	121ms	140ms	244ms
	05	12,683	3,198	138	0	0ms	69ms	94ms	151ms
	06	4,108	1,104	129	0	0ms	26ms	38ms	80ms
	07	4,474	1,384	129	0	0ms	28ms	36ms	60ms
	08	12,452	3,568	258	0	5ms	89ms	121ms	165ms
	09	28,975	7,979	447	0	2ms	172ms	225ms	422ms
	10	34,335	9,624	494	0	726ms	184ms	234ms	336ms
	11	24,849	7,824	412	0	1s308ms	150ms	196ms	1h52m22s
	12	31,254	8,528	455	0	695ms	195ms	222ms	347ms
	13	36,310	10,024	494	0	868ms	212ms	262ms	2h17m1s
	14	46,864	14,229	702	0	342ms	266ms	296ms	3s551ms
	15	43,511	12,719	757	0	0ms	220ms	254ms	428ms
	16	37,054	11,533	653	0	1s176ms	216ms	268ms	2h34m4s
	17	894,815	9,359	691	0	0ms	303ms	6s531ms	50s938ms
	18	35,324	13,194	543	2	158ms	233ms	291ms	3m34s
	19	43,450	13,970	418	0	9ms	290ms	373ms	2m20s
	20	24,027	5,418	252	0	266ms	152ms	193ms	22s537ms
	21	19,874	5,491	240	0	421ms	119ms	166ms	238ms
	22	6,748	1,781	138	0	536ms	56ms	87ms	145ms

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

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

Day	Hour	Average Duration	Average idle time
Feb 07	00	0ms	0ms
	01	0ms	0ms
	02	0ms	0ms
	03	0ms	0ms
	04	0ms	0ms
	05	0ms	0ms
	06	0ms	0ms
	07	0ms	0ms
	08	0ms	0ms
	09	0ms	0ms
	10	0ms	0ms
	11	0ms	0ms
	12	0ms	0ms
	13	0ms	0ms
	14	0ms	0ms
	15	0ms	0ms
	16	0ms	0ms
	17	0ms	0ms
	18	0ms	0ms
	19	0ms	0ms
	20	0ms	0ms
	21	0ms	0ms
	22	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

200,994 buffers Checkpoint Peak
2025-02-07 18:02:41 Date
270.054 seconds Highest write time
0.421 seconds Sync time

Checkpoints Wal files

Key values

269 files Wal files usage Peak
2025-02-07 17:55:21 Date

Checkpoints distance

Key values

8,622.89 Mo Distance Peak
2025-02-07 17:41:03 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 07	00	131,755	3,239.473s	0.032s	3,239.556s
	01	125,341	3,239.618s	0.039s	3,239.697s
	02	115,271	3,239.576s	0.032s	3,239.661s
	03	112,901	3,239.511s	0.041s	3,239.594s
	04	144,806	3,239.556s	0.03s	3,239.638s
	05	99,475	3,157.539s	0.036s	3,157.626s
	06	40,254	2,320.916s	0.024s	2,320.969s
	07	31,961	2,225.331s	0.023s	2,225.386s
	08	73,406	3,098.535s	0.03s	3,098.603s
	09	172,795	3,239.587s	0.041s	3,239.682s
	10	392,175	3,239.574s	0.044s	3,239.699s
	11	213,371	3,239.585s	0.037s	3,239.66s
	12	224,443	3,239.537s	0.039s	3,239.623s
	13	271,035	3,239.557s	0.052s	3,239.659s
	14	316,221	3,239.465s	0.047s	3,239.573s
	15	332,676	3,239.566s	0.049s	3,239.67s
	16	242,074	3,239.651s	0.04s	3,239.742s
	17	934,378	2,827.407s	1.181s	2,829.207s
	18	423,667	3,239.35s	0.045s	3,239.547s
	19	195,163	3,239.475s	0.04s	3,239.623s
	20	158,786	3,239.472s	0.035s	3,239.59s
	21	102,965	3,239.561s	0.034s	3,239.66s
	22	36,594	2,115.531s	0.022s	2,115.577s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Feb 07	00	0	0	59	3,604	0.002s	0.012s
	01	0	0	57	3,014	0.002s	0.012s
	02	0	0	55	2,856	0.002s	0.012s
	03	0	0	52	2,806	0.010s	0.012s
	04	0	0	69	2,477	0.002s	0.012s
	05	0	0	46	2,115	0.012s	0.012s
	06	0	0	18	1,834	0.002s	0.012s
	07	0	0	14	1,975	0.002s	0.012s
	08	0	0	30	3,294	0.002s	0.012s
	09	0	0	79	4,375	0.002s	0.012s
	10	0	0	153	4,721	0.009s	0.012s
	11	0	0	68	4,038	0.002s	0.012s
	12	0	0	74	4,489	0.002s	0.012s
	13	0	0	89	4,641	0.002s	0.012s
	14	0	0	108	4,803	0.002s	0.012s
	15	0	0	121	5,122	0.002s	0.012s
	16	0	0	84	5,157	0.002s	0.012s
	17	2	60	1,512	6,005	0.038s	0.016s
	18	0	55	299	4,875	0.002s	0.012s
	19	0	76	0	5,085	0.002s	0.012s
	20	0	61	0	4,524	0.002s	0.012s
	21	0	39	0	4,389	0.002s	0.012s
	22	0	13	0	2,705	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Feb 07	00	79,522.42 kB	102,936.67 kB
	01	78,545.42 kB	115,923.00 kB
	02	74,766.67 kB	99,583.67 kB
	03	71,117.58 kB	90,717.00 kB
	04	94,229.83 kB	116,750.42 kB
	05	63,483.92 kB	86,833.25 kB
	06	24,259.50 kB	61,880.92 kB
	07	18,312.67 kB	37,583.92 kB
	08	43,343.45 kB	62,018.91 kB
	09	107,128.08 kB	126,309.25 kB
	10	206,611.55 kB	683,424.09 kB
	11	93,260.36 kB	372,327.27 kB
	12	102,640.91 kB	178,285.64 kB
	13	121,163.42 kB	164,183.92 kB
	14	147,647.58 kB	166,060.67 kB
	15	164,771.17 kB	209,778.92 kB
	16	115,130.00 kB	161,491.42 kB
	17	1,303,745.08 kB	1,656,073.08 kB
	18	483,180.67 kB	2,698,192.50 kB
	19	103,541.92 kB	836,487.08 kB
	20	83,554.08 kB	302,472.33 kB
	21	53,614.17 kB	129,102.92 kB
	22	24,026.89 kB	64,001.44 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (270) Main checkpoint cause
276 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	270
wal	5
shutdown immediate	1
Total	276

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 07	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

5,821,125 Total read queries
3,848,011 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	5,821,125	52.52%
INSERT	1,468,082	13.25%
UPDATE	174,452	1.57%
DELETE	8,039	0.07%
COPY FROM	2	0.00%
COPY TO	0	0.00%
CTE	12,604	0.11%
DDL	999	0.01%
TCL	2,183,833	19.70%
CURSOR	0	0.00%
OTHERS	1,413,520	12.75%

Queries by database

Key values

unknown Main database
11,082,656 Requests
4d23h12m45s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	11,082,656	4d23h12m45s
	copy from	2	4ms
	cte	12,604	2s484ms
	ddl	999	143ms
	delete	8,039	38s480ms
	insert	1,468,082	11m1s
	others	1,413,520	1m5s
	select	5,821,125	2d6m42s
	tcl	2,183,833	1m31s
	update	174,452	2d22h51m42s

Queries by user

Key values

unknown Main user
11,082,656 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	11,082,656	4d23h12m45s
	copy from	2	4ms
	cte	12,604	2s484ms
	ddl	999	143ms
	delete	8,039	38s480ms
	insert	1,468,082	11m1s
	others	1,413,520	1m5s
	select	5,821,125	2d6m42s
	tcl	2,183,833	1m31s
	update	174,452	2d22h51m42s

Duration by user

Key values

4d23h12m45s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	11,082,656	4d23h12m45s
	copy from	2	4ms
	cte	12,604	2s484ms
	ddl	999	143ms
	delete	8,039	38s480ms
	insert	1,468,082	11m1s
	others	1,413,520	1m5s
	select	5,821,125	2d6m42s
	tcl	2,183,833	1m31s
	update	174,452	2d22h51m42s

Queries by host

Key values

unknown Main host
11,082,656 Requests
4d23h12m45s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	11,082,656	4d23h12m45s
	copy from	2	4ms
	cte	12,604	2s484ms
	ddl	999	143ms
	delete	8,039	38s480ms
	insert	1,468,082	11m1s
	others	1,413,520	1m5s
	select	5,821,125	2d6m42s
	tcl	2,183,833	1m31s
	update	174,452	2d22h51m42s

Queries by application

Key values

unknown Main application
11,082,656 Requests
4d23h12m45s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	11,082,656	4d23h12m45s
	copy from	2	4ms
	cte	12,604	2s484ms
	ddl	999	143ms
	delete	8,039	38s480ms
	insert	1,468,082	11m1s
	others	1,413,520	1m5s
	select	5,821,125	2d6m42s
	tcl	2,183,833	1m31s
	update	174,452	2d22h51m42s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-02-07 13:22:42 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

10,106,680 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	10,106,680	91.19%
1-5ms	411,182	3.71%
5-10ms	7,610	0.07%
10-25ms	26,882	0.24%
25-50ms	37,045	0.33%
50-100ms	113,749	1.03%
100-500ms	176,368	1.59%
500-1000ms	196,261	1.77%
1000-10000ms	6,472	0.06%
> 10000ms	407	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '0170094f2a79373a8eee180cfca4bc28c1904c05', last_update = '2025-02-07 16:26:45.288375', exp_date = '2025-02-07 17:11:45.288378', logged_in = 'TRUE' where id = 1096; [ Date: 2025-02-07 18:26:45 ]
2	59m59s	update res_users set sid = '0170094f2a79373a8eee180cfca4bc28c1904c05', last_update = '2025-02-07 16:26:45.288767', exp_date = '2025-02-07 17:11:45.288770', logged_in = 'TRUE' where id = 1096; [ Date: 2025-02-07 18:26:45 ]
3	59m59s	update res_users set sid = '686cfe776fa4f10cbe8e658eef986e2cbbaf843b', last_update = '2025-02-07 19:35:19.071105', exp_date = '2025-02-07 20:20:19.071107', logged_in = 'TRUE' where id = 1096; [ Date: 2025-02-07 21:35:18 ]
4	59m59s	update res_users set sid = '686cfe776fa4f10cbe8e658eef986e2cbbaf843b', last_update = '2025-02-07 19:35:19.071074', exp_date = '2025-02-07 20:20:19.071077', logged_in = 'TRUE' where id = 1096; [ Date: 2025-02-07 21:35:18 ]
5	59m59s	UPDATE "res_users" SET "exp_date" = '2025-02-07 21:14:13.728329', "last_update" = '2025-02-07 20:29:13.728347', "write_date" = '2025-02-07 20:29:13.402018', "write_uid" = 1 WHERE id IN (923); [ Date: 2025-02-07 22:29:13 ]
6	59m59s	update res_users set sid = '3c5b490995700dec667bf359a0d61a9aaf1748de', last_update = '2025-02-07 18:36:53.538065', exp_date = '2025-02-07 19:21:53.538068', logged_in = 'TRUE' where id = 1423; [ Date: 2025-02-07 20:36:53 ]
7	59m59s	update res_users set sid = '3c5b490995700dec667bf359a0d61a9aaf1748de', last_update = '2025-02-07 18:36:53.537848', exp_date = '2025-02-07 19:21:53.537852', logged_in = 'TRUE' where id = 1423; [ Date: 2025-02-07 20:36:53 ]
8	59m15s	update res_users set sid = '686cfe776fa4f10cbe8e658eef986e2cbbaf843b', last_update = '2025-02-07 19:36:03.397340', exp_date = '2025-02-07 20:21:03.397342', logged_in = 'TRUE' where id = 1096; [ Date: 2025-02-07 21:35:18 ]
9	48m18s	update res_users set sid = '8e40c0b4d863ae11635745f97cf86cf267ca21d7', last_update = '2025-02-07 09:02:01.739207', exp_date = '2025-02-07 09:47:01.739210', logged_in = 'TRUE' where id = 963; [ Date: 2025-02-07 10:50:20 ]
10	48m18s	update res_users set sid = '8e40c0b4d863ae11635745f97cf86cf267ca21d7', last_update = '2025-02-07 09:02:01.739014', exp_date = '2025-02-07 09:47:01.739018', logged_in = 'TRUE' where id = 963; [ Date: 2025-02-07 10:50:20 ]
11	48m11s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-07 11:01:09.127232', exp_date = '2025-02-07 11:46:09.127234', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-07 12:49:20 ]
12	48m11s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-07 11:01:09.127193', exp_date = '2025-02-07 11:46:09.127196', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-07 12:49:20 ]
13	47m58s	update res_users set sid = '8e40c0b4d863ae11635745f97cf86cf267ca21d7', last_update = '2025-02-07 09:02:22.176883', exp_date = '2025-02-07 09:47:22.176889', logged_in = 'TRUE' where id = 963; [ Date: 2025-02-07 10:50:20 ]
14	47m58s	update res_users set sid = '8e40c0b4d863ae11635745f97cf86cf267ca21d7', last_update = '2025-02-07 09:02:22.296081', exp_date = '2025-02-07 09:47:22.296085', logged_in = 'TRUE' where id = 963; [ Date: 2025-02-07 10:50:20 ]
15	45m43s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-07 11:03:37.167938', exp_date = '2025-02-07 11:48:37.167943', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-07 12:49:20 ]
16	45m37s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-07 11:03:42.675508', exp_date = '2025-02-07 11:48:42.675515', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-07 12:49:20 ]
17	44m33s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-07 11:04:46.789804', exp_date = '2025-02-07 11:49:46.789809', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-07 12:49:20 ]
18	40m7s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-07 11:09:12.518665', exp_date = '2025-02-07 11:54:12.518667', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-07 12:49:20 ]
19	38m58s	update res_users set sid = '8e40c0b4d863ae11635745f97cf86cf267ca21d7', last_update = '2025-02-07 09:11:22.176449', exp_date = '2025-02-07 09:56:22.176455', logged_in = 'TRUE' where id = 963; [ Date: 2025-02-07 10:50:20 ]
20	38m58s	update res_users set sid = '8e40c0b4d863ae11635745f97cf86cf267ca21d7', last_update = '2025-02-07 09:11:22.393087', exp_date = '2025-02-07 09:56:22.393093', logged_in = 'TRUE' where id = 963; [ Date: 2025-02-07 10:50:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d18h21m5s

34,802

Details

0ms

59m59s

6s863ms

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 07	00	976	210ms	0ms
	01	953	213ms	0ms
	02	1,092	238ms	0ms
	03	884	189ms	0ms
	04	939	201ms	0ms
	05	537	117ms	0ms
	06	233	50ms	0ms
	07	249	53ms	0ms
	08	700	1m17s	111ms
	09	1,684	7s854ms	4ms
	10	2,190	8h57m55s	14s737ms
	11	1,535	11h15m42s	26s411ms
	12	2,232	7h46m28s	12s539ms
	13	3,225	10h27m2s	11s665ms
	14	3,387	5h14m31s	5s571ms
	15	2,888	677ms	0ms
	16	2,716	15h11m6s	20s127ms
	17	2,346	659ms	0ms
	18	2,017	2h9m3s	3s838ms
	19	1,700	6m48s	240ms
	20	1,115	2h11m44s	7s89ms
	21	834	2h59m15s	12s895ms
	22	370	80ms	0ms

update res_users set sid = '0170094f2a79373a8eee180cfca4bc28c1904c05', last_update = '2025-02-07 16:26:45.288375', exp_date = '2025-02-07 17:11:45.288378', logged_in = 'TRUE' where id = 1096;

Date: 2025-02-07 18:26:45 Duration: 59m59s
update res_users set sid = '0170094f2a79373a8eee180cfca4bc28c1904c05', last_update = '2025-02-07 16:26:45.288767', exp_date = '2025-02-07 17:11:45.288770', logged_in = 'TRUE' where id = 1096;

Date: 2025-02-07 18:26:45 Duration: 59m59s
update res_users set sid = '686cfe776fa4f10cbe8e658eef986e2cbbaf843b', last_update = '2025-02-07 19:35:19.071105', exp_date = '2025-02-07 20:20:19.071107', logged_in = 'TRUE' where id = 1096;

Date: 2025-02-07 21:35:18 Duration: 59m59s

2

1d2h54m29s

165,877

Details

518ms

1s46ms

583ms

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 07	00	7,921	1h15m16s	570ms
	01	9,802	1h34m58s	581ms
	02	8,462	1h20m23s	570ms
	03	7,452	1h11m18s	574ms
	04	8,629	1h20m53s	562ms
	05	5,394	49m37s	551ms
	06	1,881	17m10s	547ms
	07	1,314	11m55s	544ms
	08	3,514	32m57s	562ms
	09	7,265	1h9m36s	574ms
	10	8,359	1h20m10s	575ms
	11	6,952	1h5m16s	563ms
	12	8,308	1h18m50s	569ms
	13	9,171	1h26m48s	567ms
	14	10,969	1h46m31s	582ms
	15	9,117	1h27m14s	574ms
	16	8,481	1h21m24s	575ms
	17	6,498	1h4m43s	597ms
	18	6,890	1h11m31s	622ms
	19	13,973	2h30m19s	645ms
	20	9,675	1h37m58s	607ms
	21	4,395	44m46s	611ms
	22	1,455	14m48s	610ms

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

Date: 2025-02-07 19:03:27 Duration: 1s46ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5153552)) AND (("shipping_track"."id" not in (42746303, 42746303)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:03:27 Duration: 998ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5153890)) AND (("shipping_track"."id" not in (42750538, 42750538)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:23:43 Duration: 990ms

3

4h35m25s

70,375

Details

158ms

534ms

234ms

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 07	00	1,497	4m27s	178ms
	01	2,880	8m41s	181ms
	02	2,339	7m	179ms
	03	2,716	8m7s	179ms
	04	3,507	10m31s	180ms
	05	2,134	6m20s	178ms
	06	583	1m43s	178ms
	07	827	2m26s	177ms
	08	1,429	4m17s	180ms
	09	3,236	9m46s	181ms
	10	2,946	9m3s	184ms
	11	4,359	13m16s	182ms
	12	3,487	10m52s	187ms
	13	2,877	8m52s	185ms
	14	6,510	20m23s	187ms
	15	3,382	10m29s	186ms
	16	4,550	13m56s	183ms
	17	954	3m2s	191ms
	18	6,739	39m50s	354ms
	19	12,115	1h15m17s	372ms
	20	971	5m6s	315ms
	21	297	1m34s	317ms
	22	40	12s489ms	312ms

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

Date: 2025-02-07 19:30:51 Duration: 534ms
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" = '9862248')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-07 19:30:52 Duration: 501ms
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" = '9862245')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-07 19:30:51 Duration: 489ms

4

4h32m48s

27,493

Details

523ms

1s525ms

595ms

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 07	00	152	1m38s	644ms
	01	220	2m18s	631ms
	02	165	1m48s	660ms
	03	174	1m55s	661ms
	04	201	2m10s	650ms
	05	112	1m13s	653ms
	06	70	42s882ms	612ms
	07	73	42s519ms	582ms
	08	763	7m14s	569ms
	09	1,506	14m33s	579ms
	10	1,998	19m40s	591ms
	11	1,721	16m41s	581ms
	12	1,831	17m59s	589ms
	13	2,321	22m40s	586ms
	14	3,102	30m51s	596ms
	15	3,100	30m6s	582ms
	16	2,441	23m47s	584ms
	17	2,276	22m32s	594ms
	18	1,869	18m55s	607ms
	19	1,481	15m53s	643ms
	20	1,030	10m28s	610ms
	21	657	6m33s	598ms
	22	230	2m17s	598ms

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

Date: 2025-02-07 17:21:57 Duration: 1s525ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5086208, 5086211, 5086214, 5086216, 5086219, 5086222, 5086224, 5086227, 5086231, 5086234, 5086236, 5086239, 5086242, 5086252, 5086255, 5086297, 5086300, 5086303, 5086306, 5086309, 5086312, 5086315, 5086318, 5086320, 5086327, 5086329, 5086332, 5086335, 5086340, 5086344, 5086347, 5086354, 5086356, 5086360, 5086364, 5086367, 5086370, 5086374, 5086377, 5086379, 5086382, 5086386, 5086390, 5086396, 5086399, 5086402, 5086405, 5086539, 5086545, 5086549, 5086553, 5086564, 5086567, 5086571, 5086576, 5086580, 5086584, 5096893, 5096895, 5096897, 5096900, 5096902, 5096904, 5096905, 5096912, 5096916, 5096921, 5096926, 5096932, 5096937, 5096943, 5096948, 5096952, 5096970, 5096974, 5097003, 5097011, 5097016, 5097023, 5097032, 5097035, 5097039, 5097043, 5097048, 5097053, 5097061, 5097066, 5097070, 5097076, 5097081, 5097087, 5097091, 5097098, 5097104, 5097112, 5097117, 5097132, 5097142, 5097148, 5097151, 5097155, 5097160, 5097165, 5097169, 5097176, 5097180, 5097184, 5097189, 5097192, 5097196, 5097202, 5097206, 5097210, 5097213, 5097218, 5097222, 5097225, 5097229, 5097237, 5097243, 5097246, 5097251, 5097256, 5097262, 5097270, 5097275, 5097281, 5097284, 5097294, 5097302, 5097306, 5097310, 5097315, 5097321, 5097325, 5097329, 5097336, 5097339, 5097343, 5097355, 5097358, 5097360, 5097362, 5097365, 5097367, 5097368, 5097372, 5097373, 5097375, 5097378, 5097381, 5097383, 5097386, 5097389, 5097394, 5097397, 5097402, 5097405, 5097413, 5097428, 5097435, 5097439, 5097442, 5097446, 5097450, 5097453, 5097457, 5097465, 5097468, 5097472, 5097476, 5097479, 5098099, 5098162, 5099622, 5099623, 5099624, 5100394, 5100395, 5100400, 5100401, 5100406, 5100407, 5100408, 5100409, 5100410, 5100411, 5100416, 5100417, 5100470, 5100474, 5100476, 5100480, 5100482, 5100485, 5100489, 5100605, 5100612, 5101297, 5101724, 5101725, 5101726, 5101727, 5101728, 5104174, 5104175, 5104176, 5104728, 5104730, 5105435, 5106203, 5106207, 5108934, 5108940, 5115713, 5115714, 5115869, 5115870, 5115871)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:28:45 Duration: 1s68ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5148055, 5145779, 5145736, 5145728, 5145695, 5145684, 5144321, 5144201, 5143941, 5143206, 5143171, 5143007, 5141257, 5141092, 5140945, 5137538, 5137512, 5134477, 5134459, 5134070, 5133991, 5133368, 5132949, 5132934, 5132919, 5131770, 5131711, 5131584, 5130968, 5129758, 5129088, 5129006, 5128968, 5128694, 5128618, 5128543, 5128180, 5127191, 5126585, 5126442, 5125617, 5125544, 5125169, 5124938, 5124817, 5124706, 5124381, 5124308, 5124289, 5124072, 5124006, 5123597, 5123487, 5123323, 5123004, 5122356, 5121605, 5121597, 5121588, 5121443, 5120826, 5119840, 5119800, 5116903, 5116378, 5113903, 5113894, 5113840, 5113836, 5113805, 5113787, 5113785, 5111045, 5110748, 5110725, 5110041, 5109988, 5109984, 5109794, 5109158, 5108383, 5108160, 5107858, 5107464, 5106699, 5106694, 5103399, 5101642, 5101572, 5100881, 5100729, 5099812, 5098759, 5098683, 5097907, 5097809, 5096557, 5095407, 5094735, 5094555)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:03:27 Duration: 1s46ms

5

3h20m30s

143

Details

0ms

19m31s

1m24s

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 07	00	3	0ms	0ms
	01	1	0ms	0ms
	05	1	0ms	0ms
	08	5	1ms	0ms
	09	14	3ms	0ms
	10	6	2ms	0ms
	11	9	45m27s	5m3s
	12	10	9ms	0ms
	13	19	46m41s	2m27s
	14	14	36m55s	2m38s
	15	9	8ms	0ms
	16	20	53m56s	2m41s
	17	8	7ms	0ms
	18	4	2ms	0ms
	19	7	8ms	1ms
	20	2	1ms	0ms
	21	5	2ms	0ms
	22	6	17m29s	2m54s

UPDATE "res_users" SET "exp_date" = '2025-02-07 14:13:48.616070', "last_update" = '2025-02-07 13:28:48.616090', "sid" = '682343f9736084e5b7f360a3411fc3af0292b2b5', "write_date" = '2025-02-07 13:28:48.289393', "write_uid" = 873 WHERE id IN (873);

Date: 2025-02-07 14:48:20 Duration: 19m31s
UPDATE "res_users" SET "exp_date" = '2025-02-07 21:56:43.810636', "last_update" = '2025-02-07 21:11:43.810652', "sid" = 'f06b66eea87e50cd16f6d25806330dc9643006d9', "write_date" = '2025-02-07 21:11:43.491358', "write_uid" = 1 WHERE id IN (923);

Date: 2025-02-07 22:29:13 Duration: 17m29s
UPDATE "res_users" SET "exp_date" = '2025-02-07 14:15:57.020709', "last_update" = '2025-02-07 13:30:57.020732', "sid" = '682343f9736084e5b7f360a3411fc3af0292b2b5', "write_date" = '2025-02-07 13:30:56.682088', "write_uid" = 873 WHERE id IN (873);

Date: 2025-02-07 14:48:20 Duration: 17m23s

6

2h4m47s

7,150

Details

220ms

2s50ms

1s47ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 07	00	414	6m11s	896ms
	01	1,079	11m22s	632ms
	02	434	6m26s	891ms
	03	6	5s84ms	847ms
	08	29	25s176ms	868ms
	09	18	16s333ms	907ms
	10	31	28s166ms	908ms
	11	4	3s459ms	864ms
	12	1	913ms	913ms
	13	11	10s322ms	938ms
	14	129	1m59s	929ms
	15	30	27s81ms	902ms
	16	215	3m18s	922ms
	17	513	8m18s	972ms
	18	1,337	26m58s	1s210ms
	19	1,084	22m51s	1s265ms
	20	571	11m12s	1s177ms
	21	993	19m21s	1s169ms
	22	251	4m50s	1s156ms

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

Date: 2025-02-07 18:57:42 Duration: 2s50ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '221317')) 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 (51))))))) 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 (51)))))) 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 (51)))))) 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 (51))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-07 18:57:42 Duration: 2s45ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '73469')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-07 21:31:29 Duration: 1s831ms

7

1h59m30s

31,834

Details

92ms

812ms

225ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	2,658	9m28s	213ms
	01	3,944	13m59s	212ms
	02	2,658	9m14s	208ms
	03	2,521	9m30s	226ms
	04	915	3m18s	216ms
	05	166	35s958ms	216ms
	06	2	241ms	120ms
	08	528	1m56s	219ms
	09	1,720	7m13s	251ms
	10	1,084	4m4s	225ms
	11	124	20s651ms	166ms
	12	94	22s621ms	240ms
	13	250	54s726ms	218ms
	14	560	2m1s	216ms
	15	602	2m33s	254ms
	16	907	3m27s	228ms
	17	1,826	7m11s	236ms
	18	3,255	11m42s	215ms
	19	2,926	12m50s	263ms
	20	1,644	5m52s	214ms
	21	2,596	9m37s	222ms
	22	854	3m15s	229ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'طارق')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-07 19:01:48 Duration: 812ms
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-07 03:57:07 Duration: 787ms
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-07 03:57:07 Duration: 787ms

8

1h22m23s

92,882

Details

38ms

116ms

53ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 07	00	3,751	3m20s	53ms
	01	4,331	3m53s	53ms
	02	2,519	2m15s	53ms
	03	2,330	2m6s	54ms
	04	2,477	2m14s	54ms
	05	2,102	1m54s	54ms
	06	581	31s642ms	54ms
	07	711	38s987ms	54ms
	08	1,974	1m46s	53ms
	09	4,613	4m11s	54ms
	10	6,406	5m53s	55ms
	11	5,214	4m44s	54ms
	12	6,220	5m42s	55ms
	13	7,315	6m39s	54ms
	14	8,613	8m	55ms
	15	7,030	6m27s	55ms
	16	6,558	5m59s	54ms
	17	4,589	3m45s	49ms
	18	4,270	3m19s	46ms
	19	4,533	3m43s	49ms
	20	3,042	2m21s	46ms
	21	2,744	2m6s	45ms
	22	959	44s450ms	46ms

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

Date: 2025-02-07 01:15:58 Duration: 116ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5140990)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-07 17:21:56 Duration: 113ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5130968)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-07 19:03:49 Duration: 94ms

9

1h11m45s

15,698

Details

168ms

599ms

274ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 07	08	334	1m21s	242ms
	09	1,337	6m23s	286ms
	10	1,272	6m22s	301ms
	11	1,858	8m23s	271ms
	12	1,663	7m14s	261ms
	13	1,519	7m6s	280ms
	14	2,856	12m21s	259ms
	15	2,185	9m30s	261ms
	16	1,886	8m6s	258ms
	17	347	1m50s	318ms
	18	441	3m4s	418ms

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

Date: 2025-02-07 18:48:03 Duration: 599ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '305353')))) ORDER BY "collection_policy"."id";

Date: 2025-02-07 18:48:01 Duration: 590ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '305273')))) ORDER BY "collection_policy"."id";

Date: 2025-02-07 18:48:10 Duration: 584ms

10

1h6m23s

9,012

Details

206ms

1s859ms

442ms

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 07	00	938	4m7s	263ms
	01	909	4m9s	274ms
	02	916	4m1s	263ms
	03	1,281	5m44s	268ms
	04	470	2m3s	263ms
	05	84	22s19ms	262ms
	06	1	257ms	257ms
	08	242	1m6s	275ms
	09	850	3m56s	278ms
	10	513	2m21s	275ms
	11	58	16s92ms	277ms
	12	48	12s750ms	265ms
	13	114	30s960ms	271ms
	14	159	42s132ms	264ms
	15	275	1m18s	285ms
	16	249	1m9s	278ms
	17	420	2m22s	338ms
	18	306	6m31s	1s280ms
	19	405	9m22s	1s388ms
	20	261	5m30s	1s267ms
	21	327	6m42s	1s232ms
	22	186	3m50s	1s236ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '154945')) 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-07 21:46:09 Duration: 1s859ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '242231')) 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-07 18:06:56 Duration: 1s817ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '233968')) 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-07 18:06:56 Duration: 1s815ms

11

1h3m54s

30

Details

0ms

59m59s

2m7s

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 07	00	1	0ms	0ms
	01	3	0ms	0ms
	02	2	0ms	0ms
	08	1	0ms	0ms
	09	3	0ms	0ms
	10	4	0ms	0ms
	13	6	3m55s	39s190ms
	16	2	3ms	1ms
	18	1	0ms	0ms
	20	1	1ms	1ms
	21	4	2ms	0ms
	22	2	59m59s	29m59s

UPDATE "res_users" SET "exp_date" = '2025-02-07 21:14:13.728329', "last_update" = '2025-02-07 20:29:13.728347', "write_date" = '2025-02-07 20:29:13.402018', "write_uid" = 1 WHERE id IN (923);

Date: 2025-02-07 22:29:13 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-07 13:15:25.490470', "last_update" = '2025-02-07 12:30:25.490494', "write_date" = '2025-02-07 12:30:25.162596', "write_uid" = 867 WHERE id IN (867);

Date: 2025-02-07 13:34:20 Duration: 3m55s
UPDATE "res_users" SET "exp_date" = '2025-02-07 13:00:32.123266', "last_update" = '2025-02-07 12:15:32.123295', "write_date" = '2025-02-07 12:15:31.755877', "write_uid" = 902 WHERE id IN (902);

Date: 2025-02-07 13:15:32 Duration: 1ms

12

42m50s

14,304

Details

156ms

270ms

179ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	1,209	3m36s	179ms
	01	2,477	7m26s	180ms
	02	2,326	6m58s	180ms
	03	2,528	7m33s	179ms
	04	3,401	10m13s	180ms
	05	1,877	5m35s	178ms
	06	476	1m24s	178ms
	22	10	1s858ms	185ms

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" = '361479')) 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-07 01:15:58 Duration: 270ms
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" = '317184')) 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-07 01:52:36 Duration: 228ms
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" = '9656773')) 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-07 04:00:33 Duration: 222ms

13

30m19s

8,610

Details

160ms

449ms

211ms

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 07	00	256	45s641ms	178ms
	01	235	41s978ms	178ms
	02	13	2s316ms	178ms
	03	8	1s416ms	177ms
	04	28	4s957ms	177ms
	06	71	12s521ms	176ms
	07	827	2m27s	177ms
	08	652	1m58s	181ms
	09	468	1m24s	180ms
	10	390	1m11s	182ms
	11	749	2m17s	183ms
	12	251	45s794ms	182ms
	13	319	58s807ms	184ms
	14	1,072	3m20s	186ms
	15	486	1m30s	185ms
	16	886	2m42s	183ms
	17	264	53s409ms	202ms
	18	987	5m20s	325ms
	19	445	2m35s	349ms
	20	145	46s146ms	318ms
	21	28	8s939ms	319ms
	22	30	9s327ms	310ms

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

Date: 2025-02-07 19:23:50 Duration: 440ms
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" = '156391')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) 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-07 19:02:55 Duration: 439ms

14

25m51s

27,006

Details

47ms

92ms

57ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 07	08	851	48s57ms	56ms
	09	1,852	1m44s	56ms
	10	1,601	1m31s	57ms
	11	2,430	2m19s	57ms
	12	3,147	3m	57ms
	13	2,126	1m59s	56ms
	14	4,461	4m21s	58ms
	15	3,291	3m8s	57ms
	16	4,166	4m1s	57ms
	17	2,322	2m12s	56ms
	18	670	39s451ms	58ms
	19	31	2s80ms	67ms
	20	18	1s22ms	56ms
	21	13	737ms	56ms
	22	27	1s597ms	59ms

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

Date: 2025-02-07 14:32:07 Duration: 92ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5056607) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-07 17:22:19 Duration: 92ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5074381) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-07 12:28:21 Duration: 84ms

15

13m51s

6,927

Details

100ms

230ms

120ms

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 07	08	132	15s803ms	119ms
	09	395	48s226ms	122ms
	10	408	48s755ms	119ms
	11	241	29s296ms	121ms
	12	427	51s761ms	121ms
	13	675	1m20s	118ms
	14	909	1m48s	119ms
	15	1,461	2m53s	118ms
	16	436	53s15ms	121ms
	17	576	1m9s	120ms
	18	681	1m20s	118ms
	19	350	43s717ms	124ms
	20	111	13s670ms	123ms
	21	103	12s74ms	117ms
	22	22	2s640ms	120ms

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

Date: 2025-02-07 19:30:44 Duration: 230ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8102713)) AND (("cash_track"."id" not in (7823790, 7825864, 7826987, 7827567, 7835811, 7835811)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-07 17:22:46 Duration: 185ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8078912)) AND (("cash_track"."id" not in (7646541, 7656572, 7662803, 7838195, 7838203, 7838203)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-07 19:30:45 Duration: 182ms

16

11m58s

13,786

Details

42ms

72ms

52ms

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 07	08	335	16s921ms	50ms
	09	973	50s266ms	51ms
	10	806	41s381ms	51ms
	11	1,316	1m8s	51ms
	12	1,583	1m22s	51ms
	13	1,233	1m4s	51ms
	14	2,220	1m58s	53ms
	15	1,609	1m25s	53ms
	16	2,218	1m53s	51ms
	17	1,114	57s107ms	51ms
	18	379	20s288ms	53ms

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

Date: 2025-02-07 14:24:02 Duration: 72ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5050187) ORDER BY "collection_policy"."id";

Date: 2025-02-07 14:24:03 Duration: 71ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5024995) ORDER BY "collection_policy"."id";

Date: 2025-02-07 14:24:02 Duration: 71ms

17

10m39s

2,726

Details

207ms

325ms

234ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 07	00	120	27s606ms	230ms
	01	120	27s823ms	231ms
	02	120	27s889ms	232ms
	03	120	27s814ms	231ms
	04	120	27s614ms	230ms
	05	120	27s382ms	228ms
	06	120	27s409ms	228ms
	07	120	27s359ms	227ms
	08	120	27s612ms	230ms
	09	120	27s966ms	233ms
	10	120	28s250ms	235ms
	11	120	28s41ms	233ms
	12	120	28s196ms	234ms
	13	120	28s445ms	237ms
	14	120	29s492ms	245ms
	15	120	28s401ms	236ms
	16	120	28s361ms	236ms
	17	116	27s561ms	237ms
	18	120	29s153ms	242ms
	19	120	30s249ms	252ms
	20	120	28s180ms	234ms
	21	120	27s669ms	230ms
	22	90	20s732ms	230ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-07 18:48:02 Duration: 325ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-07 19:32:01 Duration: 319ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-07 19:30:02 Duration: 311ms

18

7m48s

151

Details

656ms

4s40ms

3s104ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	2	5s775ms	2s887ms
	10	3	8s939ms	2s979ms
	11	11	34s421ms	3s129ms
	12	8	23s390ms	2s923ms
	13	8	23s847ms	2s980ms
	14	3	8s697ms	2s899ms
	15	8	19s214ms	2s401ms
	16	22	1m6s	3s24ms
	17	12	36s685ms	3s57ms
	18	30	1m37s	3s259ms
	19	19	1m3s	3s365ms
	20	17	53s899ms	3s170ms
	21	7	22s299ms	3s185ms
	22	1	3s304ms	3s304ms

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 '%22422%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-07 19:32:03 Duration: 4s40ms
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 (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))))) AND ("policy_number"."name"::text ilike '%158741%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-07 18:57:06 Duration: 3s930ms
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 (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))))) AND ("policy_number"."name"::text ilike '%15%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-07 18:57:05 Duration: 3s893ms

19

7m45s

431,680

Details

0ms

46ms

1ms

insert into policy_number (name, notebook_id, package_id, active, damaged) values (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false);

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 07	17	431,680	7m45s	1ms

INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (1454051, 379237, 2414, True, False), (1454052, 379237, 2414, True, False), (1454053, 379237, 2414, True, False), (1454054, 379237, 2414, True, False), (1454055, 379237, 2414, True, False), (1454056, 379237, 2414, True, False), (1454057, 379237, 2414, True, False), (1454058, 379237, 2414, True, False), (1454059, 379237, 2414, True, False), (1454060, 379237, 2414, True, False), (1454061, 379237, 2414, True, False), (1454062, 379237, 2414, True, False), (1454063, 379237, 2414, True, False), (1454064, 379237, 2414, True, False), (1454065, 379237, 2414, True, False), (1454066, 379237, 2414, True, False), (1454067, 379237, 2414, True, False), (1454068, 379237, 2414, True, False), (1454069, 379237, 2414, True, False), (1454070, 379237, 2414, True, False), (1454071, 379237, 2414, True, False), (1454072, 379237, 2414, True, False), (1454073, 379237, 2414, True, False), (1454074, 379237, 2414, True, False), (1454075, 379237, 2414, True, False), (1454076, 379237, 2414, True, False), (1454077, 379237, 2414, True, False), (1454078, 379237, 2414, True, False), (1454079, 379237, 2414, True, False), (1454080, 379237, 2414, True, False), (1454081, 379237, 2414, True, False), (1454082, 379237, 2414, True, False), (1454083, 379237, 2414, True, False), (1454084, 379237, 2414, True, False), (1454085, 379237, 2414, True, False), (1454086, 379237, 2414, True, False), (1454087, 379237, 2414, True, False), (1454088, 379237, 2414, True, False), (1454089, 379237, 2414, True, False), (1454090, 379237, 2414, True, False), (1454091, 379237, 2414, True, False), (1454092, 379237, 2414, True, False), (1454093, 379237, 2414, True, False), (1454094, 379237, 2414, True, False), (1454095, 379237, 2414, True, False), (1454096, 379237, 2414, True, False), (1454097, 379237, 2414, True, False), (1454098, 379237, 2414, True, False), (1454099, 379237, 2414, True, False), (1454100, 379237, 2414, True, False);

Date: 2025-02-07 17:53:16 Duration: 46ms
INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (677701, 406380, 2416, True, False), (677702, 406380, 2416, True, False), (677703, 406380, 2416, True, False), (677704, 406380, 2416, True, False), (677705, 406380, 2416, True, False), (677706, 406380, 2416, True, False), (677707, 406380, 2416, True, False), (677708, 406380, 2416, True, False), (677709, 406380, 2416, True, False), (677710, 406380, 2416, True, False), (677711, 406380, 2416, True, False), (677712, 406380, 2416, True, False), (677713, 406380, 2416, True, False), (677714, 406380, 2416, True, False), (677715, 406380, 2416, True, False), (677716, 406380, 2416, True, False), (677717, 406380, 2416, True, False), (677718, 406380, 2416, True, False), (677719, 406380, 2416, True, False), (677720, 406380, 2416, True, False), (677721, 406380, 2416, True, False), (677722, 406380, 2416, True, False), (677723, 406380, 2416, True, False), (677724, 406380, 2416, True, False), (677725, 406380, 2416, True, False), (677726, 406380, 2416, True, False), (677727, 406380, 2416, True, False), (677728, 406380, 2416, True, False), (677729, 406380, 2416, True, False), (677730, 406380, 2416, True, False), (677731, 406380, 2416, True, False), (677732, 406380, 2416, True, False), (677733, 406380, 2416, True, False), (677734, 406380, 2416, True, False), (677735, 406380, 2416, True, False), (677736, 406380, 2416, True, False), (677737, 406380, 2416, True, False), (677738, 406380, 2416, True, False), (677739, 406380, 2416, True, False), (677740, 406380, 2416, True, False), (677741, 406380, 2416, True, False), (677742, 406380, 2416, True, False), (677743, 406380, 2416, True, False), (677744, 406380, 2416, True, False), (677745, 406380, 2416, True, False), (677746, 406380, 2416, True, False), (677747, 406380, 2416, True, False), (677748, 406380, 2416, True, False), (677749, 406380, 2416, True, False), (677750, 406380, 2416, True, False);

Date: 2025-02-07 17:38:17 Duration: 45ms
INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (2247301, 437772, 2416, True, False), (2247302, 437772, 2416, True, False), (2247303, 437772, 2416, True, False), (2247304, 437772, 2416, True, False), (2247305, 437772, 2416, True, False), (2247306, 437772, 2416, True, False), (2247307, 437772, 2416, True, False), (2247308, 437772, 2416, True, False), (2247309, 437772, 2416, True, False), (2247310, 437772, 2416, True, False), (2247311, 437772, 2416, True, False), (2247312, 437772, 2416, True, False), (2247313, 437772, 2416, True, False), (2247314, 437772, 2416, True, False), (2247315, 437772, 2416, True, False), (2247316, 437772, 2416, True, False), (2247317, 437772, 2416, True, False), (2247318, 437772, 2416, True, False), (2247319, 437772, 2416, True, False), (2247320, 437772, 2416, True, False), (2247321, 437772, 2416, True, False), (2247322, 437772, 2416, True, False), (2247323, 437772, 2416, True, False), (2247324, 437772, 2416, True, False), (2247325, 437772, 2416, True, False), (2247326, 437772, 2416, True, False), (2247327, 437772, 2416, True, False), (2247328, 437772, 2416, True, False), (2247329, 437772, 2416, True, False), (2247330, 437772, 2416, True, False), (2247331, 437772, 2416, True, False), (2247332, 437772, 2416, True, False), (2247333, 437772, 2416, True, False), (2247334, 437772, 2416, True, False), (2247335, 437772, 2416, True, False), (2247336, 437772, 2416, True, False), (2247337, 437772, 2416, True, False), (2247338, 437772, 2416, True, False), (2247339, 437772, 2416, True, False), (2247340, 437772, 2416, True, False), (2247341, 437772, 2416, True, False), (2247342, 437772, 2416, True, False), (2247343, 437772, 2416, True, False), (2247344, 437772, 2416, True, False), (2247345, 437772, 2416, True, False), (2247346, 437772, 2416, True, False), (2247347, 437772, 2416, True, False), (2247348, 437772, 2416, True, False), (2247349, 437772, 2416, True, False), (2247350, 437772, 2416, True, False);

Date: 2025-02-07 17:38:58 Duration: 43ms

20

7m37s

826

Details

16ms

3s178ms

553ms

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 07	00	4	1s755ms	438ms
	02	1	179ms	179ms
	07	1	96ms	96ms
	08	14	2s920ms	208ms
	09	54	15s363ms	284ms
	10	24	7s372ms	307ms
	11	21	8s248ms	392ms
	12	60	13s187ms	219ms
	13	129	44s721ms	346ms
	14	108	28s28ms	259ms
	15	89	21s407ms	240ms
	16	63	22s321ms	354ms
	17	82	31s34ms	378ms
	18	48	1m8s	1s423ms
	19	49	1m28s	1s813ms
	20	34	53s707ms	1s579ms
	21	30	42s429ms	1s414ms
	22	15	7s153ms	476ms

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 (42)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (42))))) 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-07 17:55:25 Duration: 3s178ms
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 (67)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) 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-07 19:30:55 Duration: 3s46ms
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 (2)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2))))) 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-07 19:24:16 Duration: 2s862ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

1,412,880

Details

1m5s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 07	00	42,093	2s45ms	0ms
	01	38,892	1s976ms	0ms
	02	36,882	1s887ms	0ms
	03	35,505	1s772ms	0ms
	04	37,601	1s967ms	0ms
	05	26,563	1s295ms	0ms
	06	18,638	767ms	0ms
	07	16,107	666ms	0ms
	08	32,569	1s573ms	0ms
	09	70,837	3s833ms	0ms
	10	93,559	4s938ms	0ms
	11	74,064	2s872ms	0ms
	12	91,032	3s929ms	0ms
	13	107,699	4s246ms	0ms
	14	119,246	5s346ms	0ms
	15	113,202	5s449ms	0ms
	16	105,115	4s218ms	0ms
	17	85,932	3s588ms	0ms
	18	75,184	3s566ms	0ms
	19	69,586	3s549ms	0ms
	20	53,956	2s591ms	0ms
	21	43,872	2s80ms	0ms
	22	24,746	1s55ms	0ms

DISCARD ALL;

Date: 2025-02-07 15:31:13 Duration: 1ms
DISCARD ALL;

Date: 2025-02-07 09:48:40 Duration: 1ms
DISCARD ALL;

Date: 2025-02-07 16:34:07 Duration: 1ms

2

1,092,161

Details

15s295ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 07	00	30,934	473ms	0ms
	01	28,221	447ms	0ms
	02	27,254	434ms	0ms
	03	26,740	414ms	0ms
	04	29,476	458ms	0ms
	05	19,994	318ms	0ms
	06	12,956	201ms	0ms
	07	11,457	183ms	0ms
	08	25,538	382ms	0ms
	09	57,566	840ms	0ms
	10	75,945	1s47ms	0ms
	11	56,380	705ms	0ms
	12	70,904	966ms	0ms
	13	85,474	1s68ms	0ms
	14	94,876	1s266ms	0ms
	15	88,420	1s218ms	0ms
	16	81,998	1s51ms	0ms
	17	66,991	856ms	0ms
	18	57,700	806ms	0ms
	19	52,160	823ms	0ms
	20	39,762	587ms	0ms
	21	33,723	487ms	0ms
	22	17,692	252ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-07 12:30:44 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-07 15:11:22 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-07 12:39:36 Duration: 0ms

3

724,315

Details

6s742ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 07	00	21,773	203ms	0ms
	01	20,046	190ms	0ms
	02	19,083	181ms	0ms
	03	18,331	173ms	0ms
	04	19,391	184ms	0ms
	05	13,903	127ms	0ms
	06	9,880	83ms	0ms
	07	8,629	73ms	0ms
	08	16,995	156ms	0ms
	09	36,496	356ms	0ms
	10	47,495	459ms	0ms
	11	37,748	341ms	0ms
	12	46,556	424ms	0ms
	13	54,820	510ms	0ms
	14	60,576	565ms	0ms
	15	57,550	522ms	0ms
	16	53,540	484ms	0ms
	17	43,840	401ms	0ms
	18	38,446	362ms	0ms
	19	35,643	367ms	0ms
	20	27,775	255ms	0ms
	21	22,766	204ms	0ms
	22	13,033	113ms	0ms

ROLLBACK;

Date: 2025-02-07 11:05:59 Duration: 0ms
ROLLBACK;

Date: 2025-02-07 21:02:04 Duration: 0ms
ROLLBACK;

Date: 2025-02-07 19:28:52 Duration: 0ms

4

711,284

Details

1m56s

0ms

6ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 07	00	21,077	3s401ms	0ms
	01	19,402	3s322ms	0ms
	02	18,425	3s108ms	0ms
	03	17,709	2s913ms	0ms
	04	18,771	3s180ms	0ms
	05	13,254	2s85ms	0ms
	06	9,282	1s176ms	0ms
	07	8,046	998ms	0ms
	08	16,429	2s400ms	0ms
	09	35,660	5s696ms	0ms
	10	47,007	7s537ms	0ms
	11	37,216	6s131ms	0ms
	12	46,185	7s468ms	0ms
	13	54,374	9s361ms	0ms
	14	60,225	10s335ms	0ms
	15	57,171	9s213ms	0ms
	16	52,949	8s780ms	0ms
	17	43,300	6s949ms	0ms
	18	37,915	6s384ms	0ms
	19	35,066	6s384ms	0ms
	20	27,236	4s475ms	0ms
	21	22,118	3s455ms	0ms
	22	12,467	1s661ms	0ms

SELECT payload FROM http_sessions WHERE sid = '415d9a56f6f0234a155ccf82b4699a186f8472c2';

Date: 2025-02-07 17:21:54 Duration: 6ms
SELECT payload FROM http_sessions WHERE sid = 'e705472d3f617a2d6013e3d7b7245c3115aea7be';

Date: 2025-02-07 17:21:54 Duration: 3ms
SELECT payload FROM http_sessions WHERE sid = '30346d9f1be771291645c94a08ac1a446b3d3a69';

Date: 2025-02-07 13:04:34 Duration: 1ms

5

707,324

Details

1m

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 07	00	21,099	1s797ms	0ms
	01	19,505	1s719ms	0ms
	02	18,510	1s638ms	0ms
	03	17,834	1s544ms	0ms
	04	18,879	1s661ms	0ms
	05	13,359	1s141ms	0ms
	06	9,404	737ms	0ms
	07	8,132	642ms	0ms
	08	16,341	1s349ms	0ms
	09	35,386	3s9ms	0ms
	10	46,816	4s19ms	0ms
	11	37,038	3s131ms	0ms
	12	45,550	3s885ms	0ms
	13	53,789	4s638ms	0ms
	14	59,637	5s88ms	0ms
	15	56,636	4s801ms	0ms
	16	52,530	4s362ms	0ms
	17	42,960	3s580ms	0ms
	18	37,657	3s245ms	0ms
	19	34,839	3s157ms	0ms
	20	27,030	2s277ms	0ms
	21	21,983	1s778ms	0ms
	22	12,410	932ms	0ms

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

Date: 2025-02-07 01:59:19 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-07 12:28:09 Duration: 0ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-07 12:34:12 Duration: 0ms

6

465,027

Details

1m9s

0ms

8ms

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 07	00	11,323	1s882ms	0ms
	01	9,631	1s741ms	0ms
	02	9,579	1s762ms	0ms
	03	9,839	1s731ms	0ms
	04	11,605	2s11ms	0ms
	05	7,088	1s264ms	0ms
	06	3,764	723ms	0ms
	07	3,270	674ms	0ms
	08	10,969	1s731ms	0ms
	09	27,378	4s91ms	0ms
	10	36,950	5s259ms	0ms
	11	23,149	3s105ms	0ms
	12	31,656	4s443ms	0ms
	13	39,649	5s86ms	0ms
	14	44,671	6s139ms	0ms
	15	39,569	5s691ms	0ms
	16	36,395	4s799ms	0ms
	17	29,153	4s25ms	0ms
	18	24,198	3s658ms	0ms
	19	20,566	3s549ms	0ms
	20	15,176	2s499ms	0ms
	21	13,791	2s262ms	0ms
	22	5,658	882ms	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 (848);

Date: 2025-02-07 17:21:54 Duration: 8ms
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 (825);

Date: 2025-02-07 17:21:54 Duration: 7ms
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 (2);

Date: 2025-02-07 17:21:54 Duration: 7ms

7

431,691

Details

18s191ms

0ms

25ms

0ms

insert into "notebook" ("active", "create_date", "create_uid", "end", "name", "notebook_package_id", "start", "write_date", "write_uid") values (true, ?, ?, ?, ?, ?, ?, ?, ?) returning "id";

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 07	16	10	1ms	0ms
	17	431,681	18s189ms	0ms

INSERT INTO "notebook" ("active", "create_date", "create_uid", "end", "name", "notebook_package_id", "start", "write_date", "write_uid") VALUES (true, '2025-02-07 16:38:07.119854', 2, 3778650, 'E2/69573', 2416, 3778601, '2025-02-07 16:38:07.119854', 2) RETURNING "id";

Date: 2025-02-07 17:39:39 Duration: 25ms
INSERT INTO "notebook" ("active", "create_date", "create_uid", "end", "name", "notebook_package_id", "start", "write_date", "write_uid") VALUES (true, '2025-02-07 16:38:07.119854', 2, 638750, 'E2/6775', 2416, 638701, '2025-02-07 16:38:07.119854', 2) RETURNING "id";

Date: 2025-02-07 17:38:16 Duration: 17ms
INSERT INTO "notebook" ("active", "create_date", "create_uid", "end", "name", "notebook_package_id", "start", "write_date", "write_uid") VALUES (true, '2025-02-07 16:52:41.627012', 1204, 1814850, 'A1/30297', 2414, 1814801, '2025-02-07 16:52:41.627012', 1204) RETURNING "id";

Date: 2025-02-07 17:53:27 Duration: 16ms

8

431,680

Details

7m45s

0ms

46ms

1ms

insert into policy_number (name, notebook_id, package_id, active, damaged) values (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false);

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 07	17	431,680	7m45s	1ms

INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (1454051, 379237, 2414, True, False), (1454052, 379237, 2414, True, False), (1454053, 379237, 2414, True, False), (1454054, 379237, 2414, True, False), (1454055, 379237, 2414, True, False), (1454056, 379237, 2414, True, False), (1454057, 379237, 2414, True, False), (1454058, 379237, 2414, True, False), (1454059, 379237, 2414, True, False), (1454060, 379237, 2414, True, False), (1454061, 379237, 2414, True, False), (1454062, 379237, 2414, True, False), (1454063, 379237, 2414, True, False), (1454064, 379237, 2414, True, False), (1454065, 379237, 2414, True, False), (1454066, 379237, 2414, True, False), (1454067, 379237, 2414, True, False), (1454068, 379237, 2414, True, False), (1454069, 379237, 2414, True, False), (1454070, 379237, 2414, True, False), (1454071, 379237, 2414, True, False), (1454072, 379237, 2414, True, False), (1454073, 379237, 2414, True, False), (1454074, 379237, 2414, True, False), (1454075, 379237, 2414, True, False), (1454076, 379237, 2414, True, False), (1454077, 379237, 2414, True, False), (1454078, 379237, 2414, True, False), (1454079, 379237, 2414, True, False), (1454080, 379237, 2414, True, False), (1454081, 379237, 2414, True, False), (1454082, 379237, 2414, True, False), (1454083, 379237, 2414, True, False), (1454084, 379237, 2414, True, False), (1454085, 379237, 2414, True, False), (1454086, 379237, 2414, True, False), (1454087, 379237, 2414, True, False), (1454088, 379237, 2414, True, False), (1454089, 379237, 2414, True, False), (1454090, 379237, 2414, True, False), (1454091, 379237, 2414, True, False), (1454092, 379237, 2414, True, False), (1454093, 379237, 2414, True, False), (1454094, 379237, 2414, True, False), (1454095, 379237, 2414, True, False), (1454096, 379237, 2414, True, False), (1454097, 379237, 2414, True, False), (1454098, 379237, 2414, True, False), (1454099, 379237, 2414, True, False), (1454100, 379237, 2414, True, False);

Date: 2025-02-07 17:53:16 Duration: 46ms
INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (677701, 406380, 2416, True, False), (677702, 406380, 2416, True, False), (677703, 406380, 2416, True, False), (677704, 406380, 2416, True, False), (677705, 406380, 2416, True, False), (677706, 406380, 2416, True, False), (677707, 406380, 2416, True, False), (677708, 406380, 2416, True, False), (677709, 406380, 2416, True, False), (677710, 406380, 2416, True, False), (677711, 406380, 2416, True, False), (677712, 406380, 2416, True, False), (677713, 406380, 2416, True, False), (677714, 406380, 2416, True, False), (677715, 406380, 2416, True, False), (677716, 406380, 2416, True, False), (677717, 406380, 2416, True, False), (677718, 406380, 2416, True, False), (677719, 406380, 2416, True, False), (677720, 406380, 2416, True, False), (677721, 406380, 2416, True, False), (677722, 406380, 2416, True, False), (677723, 406380, 2416, True, False), (677724, 406380, 2416, True, False), (677725, 406380, 2416, True, False), (677726, 406380, 2416, True, False), (677727, 406380, 2416, True, False), (677728, 406380, 2416, True, False), (677729, 406380, 2416, True, False), (677730, 406380, 2416, True, False), (677731, 406380, 2416, True, False), (677732, 406380, 2416, True, False), (677733, 406380, 2416, True, False), (677734, 406380, 2416, True, False), (677735, 406380, 2416, True, False), (677736, 406380, 2416, True, False), (677737, 406380, 2416, True, False), (677738, 406380, 2416, True, False), (677739, 406380, 2416, True, False), (677740, 406380, 2416, True, False), (677741, 406380, 2416, True, False), (677742, 406380, 2416, True, False), (677743, 406380, 2416, True, False), (677744, 406380, 2416, True, False), (677745, 406380, 2416, True, False), (677746, 406380, 2416, True, False), (677747, 406380, 2416, True, False), (677748, 406380, 2416, True, False), (677749, 406380, 2416, True, False), (677750, 406380, 2416, True, False);

Date: 2025-02-07 17:38:17 Duration: 45ms
INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (2247301, 437772, 2416, True, False), (2247302, 437772, 2416, True, False), (2247303, 437772, 2416, True, False), (2247304, 437772, 2416, True, False), (2247305, 437772, 2416, True, False), (2247306, 437772, 2416, True, False), (2247307, 437772, 2416, True, False), (2247308, 437772, 2416, True, False), (2247309, 437772, 2416, True, False), (2247310, 437772, 2416, True, False), (2247311, 437772, 2416, True, False), (2247312, 437772, 2416, True, False), (2247313, 437772, 2416, True, False), (2247314, 437772, 2416, True, False), (2247315, 437772, 2416, True, False), (2247316, 437772, 2416, True, False), (2247317, 437772, 2416, True, False), (2247318, 437772, 2416, True, False), (2247319, 437772, 2416, True, False), (2247320, 437772, 2416, True, False), (2247321, 437772, 2416, True, False), (2247322, 437772, 2416, True, False), (2247323, 437772, 2416, True, False), (2247324, 437772, 2416, True, False), (2247325, 437772, 2416, True, False), (2247326, 437772, 2416, True, False), (2247327, 437772, 2416, True, False), (2247328, 437772, 2416, True, False), (2247329, 437772, 2416, True, False), (2247330, 437772, 2416, True, False), (2247331, 437772, 2416, True, False), (2247332, 437772, 2416, True, False), (2247333, 437772, 2416, True, False), (2247334, 437772, 2416, True, False), (2247335, 437772, 2416, True, False), (2247336, 437772, 2416, True, False), (2247337, 437772, 2416, True, False), (2247338, 437772, 2416, True, False), (2247339, 437772, 2416, True, False), (2247340, 437772, 2416, True, False), (2247341, 437772, 2416, True, False), (2247342, 437772, 2416, True, False), (2247343, 437772, 2416, True, False), (2247344, 437772, 2416, True, False), (2247345, 437772, 2416, True, False), (2247346, 437772, 2416, True, False), (2247347, 437772, 2416, True, False), (2247348, 437772, 2416, True, False), (2247349, 437772, 2416, True, False), (2247350, 437772, 2416, True, False);

Date: 2025-02-07 17:38:58 Duration: 43ms

9

367,354

Details

1m9s

0ms

55ms

0ms

commit;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 07	00	9,161	1s798ms	0ms
	01	8,175	1s761ms	0ms
	02	8,171	1s708ms	0ms
	03	8,405	1s671ms	0ms
	04	10,088	2s15ms	0ms
	05	6,093	1s130ms	0ms
	06	3,076	590ms	0ms
	07	2,827	487ms	0ms
	08	8,536	1s514ms	0ms
	09	21,073	3s318ms	0ms
	10	28,409	4s388ms	0ms
	11	18,542	2s895ms	0ms
	12	24,291	4s70ms	0ms
	13	30,502	4s881ms	0ms
	14	34,262	5s645ms	0ms
	15	30,854	5s247ms	0ms
	16	28,378	4s397ms	0ms
	17	23,115	10s814ms	0ms
	18	19,279	3s94ms	0ms
	19	16,513	3s161ms	0ms
	20	11,986	2s264ms	0ms
	21	10,941	1s710ms	0ms
	22	4,677	708ms	0ms

COMMIT;

Date: 2025-02-07 17:19:37 Duration: 55ms
COMMIT;

Date: 2025-02-07 17:38:57 Duration: 44ms
COMMIT;

Date: 2025-02-07 17:19:42 Duration: 42ms

10

275,108

Details

32s982ms

0ms

5ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	7,451	884ms	0ms
	01	6,419	764ms	0ms
	02	5,692	659ms	0ms
	03	5,896	631ms	0ms
	04	5,145	693ms	0ms
	05	3,394	485ms	0ms
	06	2,312	276ms	0ms
	07	1,542	183ms	0ms
	08	7,006	786ms	0ms
	09	18,041	2s176ms	0ms
	10	23,324	2s757ms	0ms
	11	12,673	1s711ms	0ms
	12	19,174	2s385ms	0ms
	13	22,454	2s924ms	0ms
	14	26,715	3s322ms	0ms
	15	23,076	2s691ms	0ms
	16	20,932	2s523ms	0ms
	17	16,932	1s874ms	0ms
	18	14,126	1s526ms	0ms
	19	12,528	1s587ms	0ms
	20	8,537	947ms	0ms
	21	8,864	872ms	0ms
	22	2,875	316ms	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 (5098972, 5098978, 5114435, 5099009, 5099194, 5138414, 5099254, 5099500, 5101173, 5099296, 5106936, 5099644, 5099515, 5099013, 5099389, 5220780, 5140724, 5367087, 5417545, 5150730, 5150721, 5105173, 5204091, 5197302, 5099590, 5099187, 5199747, 5101994, 5125904, 5099007, 5105187, 5417540, 5168287, 5102021, 5239692, 5142947);

Date: 2025-02-07 17:42:09 Duration: 5ms
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 (5099008, 5099007, 5099009, 5130100, 5099404, 5101901, 5100327, 5099182, 5099170, 5099415, 5101213, 5506489, 5101494, 5284752, 5099540, 5105815, 5099296, 5100127, 5099254, 5099181, 5100110, 5114697, 5099311, 5099403, 5103800);

Date: 2025-02-07 17:21:54 Duration: 4ms
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 (5326423, 5099007, 5099958, 5099141, 5504904, 5105186, 5099137, 5099009, 5099392, 5099686, 5099677, 5100765, 5151610, 5100443, 5102646, 5100257, 5099183, 5100977, 5099499, 5505384, 5130815, 5108803, 5099277, 5504637, 5103645, 5103866, 5099727, 5116227, 5146121, 5099010, 5099091, 5107837, 5099403, 5100302, 5117821, 5101539, 5101490, 5206955, 5107032, 5424609, 5099181, 5099401, 5102793, 5099190, 5099431, 5109066, 5109642, 5101297, 5099138, 5102261, 5099095, 5101235, 5099333);

Date: 2025-02-07 17:21:56 Duration: 3ms

11

271,107

Details

15s716ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 07	00	5,660	340ms	0ms
	01	4,489	284ms	0ms
	02	3,817	237ms	0ms
	03	3,928	245ms	0ms
	04	3,944	244ms	0ms
	05	2,601	149ms	0ms
	06	2,075	115ms	0ms
	07	1,584	89ms	0ms
	08	6,310	368ms	0ms
	09	15,905	928ms	0ms
	10	21,967	1s290ms	0ms
	11	13,182	774ms	0ms
	12	18,551	1s99ms	0ms
	13	23,793	1s432ms	0ms
	14	27,101	1s649ms	0ms
	15	24,659	1s371ms	0ms
	16	22,642	1s217ms	0ms
	17	18,810	1s	0ms
	18	14,942	834ms	0ms
	19	13,556	852ms	0ms
	20	9,673	559ms	0ms
	21	9,093	481ms	0ms
	22	2,825	148ms	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 (39, 13, 115, 75, 28, 123, 27, 102, 16, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112, 23);

Date: 2025-02-07 14:36:31 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 (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112, 23);

Date: 2025-02-07 17:21:54 Duration: 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 (32, 11);

Date: 2025-02-07 02:50:00 Duration: 0ms

12

185,046

Details

31s780ms

0ms

2ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	3,483	619ms	0ms
	01	2,607	498ms	0ms
	02	2,401	465ms	0ms
	03	2,364	457ms	0ms
	04	2,580	501ms	0ms
	05	1,766	327ms	0ms
	06	1,560	226ms	0ms
	07	1,089	163ms	0ms
	08	4,339	704ms	0ms
	09	11,019	1s800ms	0ms
	10	14,997	2s466ms	0ms
	11	8,986	1s531ms	0ms
	12	12,806	2s193ms	0ms
	13	18,623	3s128ms	0ms
	14	18,084	3s176ms	0ms
	15	16,298	2s748ms	0ms
	16	15,285	2s620ms	0ms
	17	13,799	2s254ms	0ms
	18	10,303	1s780ms	0ms
	19	8,571	1s695ms	0ms
	20	6,513	1s123ms	0ms
	21	5,298	901ms	0ms
	22	2,275	394ms	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 (8007200, 8006376, 8007226, 8006398, 8006377, 8007223, 8006453, 8006454, 8007364, 8006469);

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

Date: 2025-02-07 17:21:57 Duration: 1ms
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 (8007979);

Date: 2025-02-07 16:56:23 Duration: 1ms

13

165,877

Details

1d2h54m29s

518ms

1s46ms

583ms

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 07	00	7,921	1h15m16s	570ms
	01	9,802	1h34m58s	581ms
	02	8,462	1h20m23s	570ms
	03	7,452	1h11m18s	574ms
	04	8,629	1h20m53s	562ms
	05	5,394	49m37s	551ms
	06	1,881	17m10s	547ms
	07	1,314	11m55s	544ms
	08	3,514	32m57s	562ms
	09	7,265	1h9m36s	574ms
	10	8,359	1h20m10s	575ms
	11	6,952	1h5m16s	563ms
	12	8,308	1h18m50s	569ms
	13	9,171	1h26m48s	567ms
	14	10,969	1h46m31s	582ms
	15	9,117	1h27m14s	574ms
	16	8,481	1h21m24s	575ms
	17	6,498	1h4m43s	597ms
	18	6,890	1h11m31s	622ms
	19	13,973	2h30m19s	645ms
	20	9,675	1h37m58s	607ms
	21	4,395	44m46s	611ms
	22	1,455	14m48s	610ms

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

Date: 2025-02-07 19:03:27 Duration: 1s46ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5153552)) AND (("shipping_track"."id" not in (42746303, 42746303)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:03:27 Duration: 998ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5153890)) AND (("shipping_track"."id" not in (42750538, 42750538)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:23:43 Duration: 990ms

14

160,388

Details

48s68ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	2,372	729ms	0ms
	01	1,900	607ms	0ms
	02	1,541	487ms	0ms
	03	1,023	315ms	0ms
	04	1,132	374ms	0ms
	05	482	155ms	0ms
	06	590	184ms	0ms
	07	656	190ms	0ms
	08	3,216	958ms	0ms
	09	6,682	2s17ms	0ms
	10	8,555	2s587ms	0ms
	11	9,324	2s701ms	0ms
	12	11,740	3s465ms	0ms
	13	21,139	6s236ms	0ms
	14	15,522	4s805ms	0ms
	15	12,913	3s927ms	0ms
	16	15,701	4s636ms	0ms
	17	14,926	4s394ms	0ms
	18	8,977	2s684ms	0ms
	19	8,824	2s860ms	0ms
	20	6,439	1s941ms	0ms
	21	4,584	1s248ms	0ms
	22	2,150	557ms	0ms

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

Date: 2025-02-07 19:23:43 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 981) OR r.global) ORDER BY r.id;

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

Date: 2025-02-07 13:10:09 Duration: 2ms

15

132,275

Details

20s9ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 07	00	2,082	282ms	0ms
	01	1,830	237ms	0ms
	02	1,739	215ms	0ms
	03	1,082	133ms	0ms
	04	1,559	193ms	0ms
	05	926	109ms	0ms
	06	648	82ms	0ms
	07	768	103ms	0ms
	08	3,188	445ms	0ms
	09	6,643	928ms	0ms
	10	6,681	987ms	0ms
	11	7,194	1s79ms	0ms
	12	9,746	1s475ms	0ms
	13	17,892	2s804ms	0ms
	14	11,666	1s874ms	0ms
	15	9,872	1s509ms	0ms
	16	12,150	1s908ms	0ms
	17	11,663	1s825ms	0ms
	18	6,818	1s35ms	0ms
	19	7,079	1s200ms	0ms
	20	5,334	818ms	0ms
	21	3,515	480ms	0ms
	22	2,200	275ms	0ms

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

Date: 2025-02-07 19:23:43 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-02-07 15:05:25 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-02-07 17:22:54 Duration: 1ms

16

123,892

Details

30s465ms

0ms

18ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	3,517	846ms	0ms
	01	3,701	1s497ms	0ms
	02	2,823	711ms	0ms
	03	2,834	691ms	0ms
	04	2,070	603ms	0ms
	05	1,231	407ms	0ms
	06	822	223ms	0ms
	07	575	147ms	0ms
	08	2,876	677ms	0ms
	09	7,565	1s888ms	0ms
	10	9,310	2s253ms	0ms
	11	4,975	1s418ms	0ms
	12	7,755	1s853ms	0ms
	13	9,279	2s511ms	0ms
	14	11,219	2s762ms	0ms
	15	10,972	2s377ms	0ms
	16	11,423	2s757ms	0ms
	17	7,853	1s767ms	0ms
	18	7,138	1s522ms	0ms
	19	6,266	1s528ms	0ms
	20	4,037	847ms	0ms
	21	4,307	867ms	0ms
	22	1,344	303ms	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 (32409065, 32413589, 32419249, 32511997, 41906787, 32352096, 32391554, 32386570, 32521409, 32457593, 32405471, 32443161, 32443165, 32536911, 32274873, 32455682, 32450665, 32343241, 42041311, 32473592, 32274880, 32374461, 32407143, 32291997, 32457900, 32345501, 32318003, 32334181, 32214123, 32261501, 32181253, 32528704, 32476671, 40672401, 32498105, 42169267, 32397732, 32348511, 32312733, 32455911, 32521294, 32363739, 32457743, 32223773, 32519656, 32468918, 32431321, 32299089, 32299462, 32214120, 32213338, 32214121, 32266939, 32341503, 42026873, 32231358, 32343347, 32241916, 32213339, 32411387, 32264918, 32442471, 32336441, 32513265, 32352333, 32349032);

Date: 2025-02-07 17:21:56 Duration: 18ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (32504099, 32285434, 32510920, 32365507, 32419092, 32296567, 32180393, 32328475, 32286527, 32286522, 32407316, 32444333, 32340226, 32410466, 32444803, 32447369, 32364891, 32410440, 32425739, 32327691, 32421365, 32374427, 32374986, 41835598, 32304640, 32334547, 32383823, 41861895, 32252730, 41930129);

Date: 2025-02-07 17:21:54 Duration: 8ms
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 (41762416, 32208649, 41657807, 32209252, 41569884, 41569811, 41921423, 42154824, 32252343, 41967930, 32209550, 41763121, 42155126, 41658829, 42032540, 41968156, 42032527, 41659400, 32253328, 41570515, 42032499, 32209488, 42031959, 41134006);

Date: 2025-02-07 17:21:55 Duration: 7ms

17

92,882

Details

1h22m23s

38ms

116ms

53ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	3,751	3m20s	53ms
	01	4,331	3m53s	53ms
	02	2,519	2m15s	53ms
	03	2,330	2m6s	54ms
	04	2,477	2m14s	54ms
	05	2,102	1m54s	54ms
	06	581	31s642ms	54ms
	07	711	38s987ms	54ms
	08	1,974	1m46s	53ms
	09	4,613	4m11s	54ms
	10	6,406	5m53s	55ms
	11	5,214	4m44s	54ms
	12	6,220	5m42s	55ms
	13	7,315	6m39s	54ms
	14	8,613	8m	55ms
	15	7,030	6m27s	55ms
	16	6,558	5m59s	54ms
	17	4,589	3m45s	49ms
	18	4,270	3m19s	46ms
	19	4,533	3m43s	49ms
	20	3,042	2m21s	46ms
	21	2,744	2m6s	45ms
	22	959	44s450ms	46ms

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

Date: 2025-02-07 01:15:58 Duration: 116ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5140990)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-07 17:21:56 Duration: 113ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5130968)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-07 19:03:49 Duration: 94ms

18

91,551

Details

7s331ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	2,128	191ms	0ms
	01	1,505	154ms	0ms
	02	1,473	147ms	0ms
	03	1,565	164ms	0ms
	04	1,587	164ms	0ms
	05	1,151	96ms	0ms
	06	818	62ms	0ms
	07	549	42ms	0ms
	08	2,346	200ms	0ms
	09	5,916	525ms	0ms
	10	7,881	672ms	0ms
	11	4,240	395ms	0ms
	12	6,752	601ms	0ms
	13	7,895	727ms	0ms
	14	9,510	966ms	0ms
	15	8,078	494ms	0ms
	16	7,352	428ms	0ms
	17	5,759	327ms	0ms
	18	4,485	266ms	0ms
	19	4,055	289ms	0ms
	20	2,895	186ms	0ms
	21	2,772	170ms	0ms
	22	839	51ms	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-07 17:21:54 Duration: 0ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-02-07 11:26:35 Duration: 0ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-02-07 19:28:27 Duration: 0ms

19

80,793

Details

26s465ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 07	00	6,778	2s160ms	0ms
	01	9,666	3s52ms	0ms
	02	7,651	2s587ms	0ms
	03	7,058	2s356ms	0ms
	04	4,706	1s913ms	0ms
	05	1,929	879ms	0ms
	06	686	336ms	0ms
	07	366	177ms	0ms
	08	1,573	547ms	0ms
	09	4,037	1s245ms	0ms
	10	2,383	735ms	0ms
	11	749	335ms	0ms
	12	767	349ms	0ms
	13	769	293ms	0ms
	14	1,573	569ms	0ms
	15	1,435	484ms	0ms
	16	2,034	644ms	0ms
	17	3,702	1s105ms	0ms
	18	6,542	1s880ms	0ms
	19	5,960	1s898ms	0ms
	20	3,383	985ms	0ms
	21	5,326	1s472ms	0ms
	22	1,720	452ms	0ms

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

Date: 2025-02-07 18:43:12 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 52) AND ("price_list"."to_office_id" = 128)) ORDER BY "price_list"."id";

Date: 2025-02-07 17:22:09 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 30) AND ("price_list"."to_office_id" = 39)) ORDER BY "price_list"."id";

Date: 2025-02-07 01:15:58 Duration: 1ms

20

77,518

Details

38s182ms

0ms

7ms

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	669	425ms	0ms
	01	292	174ms	0ms
	02	189	116ms	0ms
	03	182	111ms	0ms
	04	233	141ms	0ms
	05	196	109ms	0ms
	06	107	57ms	0ms
	07	223	110ms	0ms
	08	1,109	575ms	0ms
	09	3,220	1s616ms	0ms
	10	4,133	2s87ms	0ms
	11	3,818	1s772ms	0ms
	12	4,220	2s220ms	0ms
	13	4,874	2s780ms	0ms
	14	7,549	4s124ms	0ms
	15	5,789	2s999ms	0ms
	16	7,535	3s668ms	0ms
	17	2,847	1s449ms	0ms
	18	4,708	2s213ms	0ms
	19	14,652	7s38ms	0ms
	20	9,454	3s663ms	0ms
	21	1,175	536ms	0ms
	22	344	189ms	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 (5089523, 5089518, 5090174, 5108384, 5070595, 5059666, 5115508, 4992137, 5115137, 5023473, 5001467, 5005378, 5018335, 4997939, 5061993, 5057443, 5083578, 5097634, 5096145, 5108177, 5093937, 5063014, 5095260, 5063989, 5108375, 5108186, 5098594, 5077004, 5092594, 5019033, 5082168, 5001192, 5046775, 4724985, 5056554, 5025434, 4905346, 4844140, 4919573, 5091048, 4991588, 5022872, 5061857, 4844159, 4789907, 4808260, 4997707, 5076739, 4905199, 4929629, 4985297, 5052089, 5050800, 5108188, 5062212, 5101292, 5043534, 5110839, 5061648, 5055544, 5076793, 5069749, 4842005, 5056426, 4796399, 5097702, 4980930, 5052352, 5059763, 5064284, 4916666, 5083609, 5015821, 5046139, 5068806, 5044924, 5086047, 5032714, 5089517, 5106622, 5019748, 5093965, 4961396, 4969176, 4975587, 4984989, 5005864, 5010485, 5016943, 5016986, 5017394, 5019138, 5020058, 5026062, 5029758, 5031461, 5035414, 5042083, 5052368, 5053135, 5055740, 5055823, 5059796, 5061111, 5061325, 5062486, 5063727, 5040286, 5093931, 5099751, 5091738, 5099308, 5077561, 5093557, 5008902, 5086764, 5104734, 5088332, 5083249, 5054291, 5084555, 5074258, 5077680, 5078087, 5083709, 5089722, 5089923, 5092327, 5095117, 5107107, 5106102, 5094559, 5082052, 5084606, 5065193, 5089119, 5115615, 5086487, 5050910, 5103142, 5091520, 5111707, 5097810, 5087537, 5051642, 4666013, 5072047, 5098036, 4881460, 5091166, 5098968, 5101072, 5105355, 5091046, 5070121, 5105370, 5107602, 5105368, 5095189, 5093833, 5101757, 5103126, 5109507, 5103026, 5086622, 5093468, 5064095, 5095666, 5114491, 5114542, 5055479, 5074409, 5088560, 5059758, 5100520, 5117662, 5054509, 5088306, 5081453, 5088747, 5039103, 5098992, 5013886, 5031142, 5083731, 5049167, 5083143, 5117084, 4975837, 4963021, 4972930, 4817461, 5053744, 5106015, 5114629, 4961471, 4801367, 5063830, 5110066, 5064810);

Date: 2025-02-07 13:04:30 Duration: 7ms
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 (4996097, 4996090, 4961678, 4996089, 4968253, 4961572, 4961566, 4996170, 4996187, 4996188, 4996087, 4968348, 4996189, 4961547, 4961546, 4968345, 4961671, 4968353, 4856992, 4961655, 4968380, 4964229, 4961674, 4884485, 4919591, 4884488);

Date: 2025-02-07 17:21:54 Duration: 7ms
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 (4969946, 5057782, 5086427, 5004431, 5057620, 5064165, 5086375, 5064050, 5065401, 5093137, 5086438, 4928881, 4916145, 5093417, 4992693, 5086732, 5093288, 5063936, 5064172, 5027894, 5021278, 5064179, 5049012, 5021140, 4579101, 5086716, 5093080, 5063989, 5086622, 5086502, 5064140, 5057630, 5057642, 5064103, 5027901, 4963487, 4745829, 5049057, 5033521, 4727289, 5101875, 5093153, 5112291, 5016595, 5101802, 5038821, 5083011, 5101868, 5095748, 5022251, 5107251, 5073823, 5089986, 5101309, 5063902, 5051254, 5069458, 5052152, 5107273, 5051183, 5098041, 4951636, 4807285, 5059408, 5107992, 5106474, 5112325, 5090177, 5106535, 5076330, 5083828, 5114920, 5102992, 5081745, 5101560, 5090181, 5106567, 5082812, 5107145, 5075683, 5100261, 5115643, 5082818, 5082590, 5083427, 5096696, 5084195, 5101819, 5107200, 5088268, 5069696, 5106414, 5075590, 5050561, 5096078, 5086943, 5050024, 5109258, 5109276, 5091324, 5101330, 4997967, 5096948, 5083809, 5085064, 5088398, 5115641, 5115645, 5092326, 5098508, 5101866, 5097314, 5091326, 5094316, 5072145, 5075592, 5067362, 5051336, 5048729, 5088304, 5048983, 5064000, 5086447, 5021233, 5064120, 5093236, 5049000, 5064178, 5093264, 4975905, 4992798, 5027882, 5064142, 5021073, 5086583, 5021154, 5057632, 4916034, 5064110, 4992754, 5021048, 5027921, 4963484, 4970010, 5027718, 5021047, 5063991, 4927230, 5027589, 5027873, 5027884, 5004524, 5057589, 4792193, 5021046, 5048955, 5001674, 5027712, 5021206, 5057789, 5004472, 5029477, 5064108, 4635897, 5064101, 5021255, 5049051, 5048985, 5031394, 5057650, 5062239, 5049068, 5057582, 5001747, 5021065, 5027897, 5021277, 5027679, 5049036, 5064056, 4970043, 5028323, 5049072, 5057633, 5041084, 5062159, 4998070, 5056504, 5064136, 5065896, 5045816, 5049954, 5054159, 5064556, 5045819, 5063462, 5062374);

Date: 2025-02-07 17:22:21 Duration: 6ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m59s

2m7s

30

Details

1h3m54s

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 07	00	1	0ms	0ms
	01	3	0ms	0ms
	02	2	0ms	0ms
	08	1	0ms	0ms
	09	3	0ms	0ms
	10	4	0ms	0ms
	13	6	3m55s	39s190ms
	16	2	3ms	1ms
	18	1	0ms	0ms
	20	1	1ms	1ms
	21	4	2ms	0ms
	22	2	59m59s	29m59s

UPDATE "res_users" SET "exp_date" = '2025-02-07 21:14:13.728329', "last_update" = '2025-02-07 20:29:13.728347', "write_date" = '2025-02-07 20:29:13.402018', "write_uid" = 1 WHERE id IN (923);

Date: 2025-02-07 22:29:13 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-07 13:15:25.490470', "last_update" = '2025-02-07 12:30:25.490494', "write_date" = '2025-02-07 12:30:25.162596', "write_uid" = 867 WHERE id IN (867);

Date: 2025-02-07 13:34:20 Duration: 3m55s
UPDATE "res_users" SET "exp_date" = '2025-02-07 13:00:32.123266', "last_update" = '2025-02-07 12:15:32.123295', "write_date" = '2025-02-07 12:15:31.755877', "write_uid" = 902 WHERE id IN (902);

Date: 2025-02-07 13:15:32 Duration: 1ms

2

0ms

19m31s

1m24s

143

Details

3h20m30s

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 07	00	3	0ms	0ms
	01	1	0ms	0ms
	05	1	0ms	0ms
	08	5	1ms	0ms
	09	14	3ms	0ms
	10	6	2ms	0ms
	11	9	45m27s	5m3s
	12	10	9ms	0ms
	13	19	46m41s	2m27s
	14	14	36m55s	2m38s
	15	9	8ms	0ms
	16	20	53m56s	2m41s
	17	8	7ms	0ms
	18	4	2ms	0ms
	19	7	8ms	1ms
	20	2	1ms	0ms
	21	5	2ms	0ms
	22	6	17m29s	2m54s

UPDATE "res_users" SET "exp_date" = '2025-02-07 14:13:48.616070', "last_update" = '2025-02-07 13:28:48.616090', "sid" = '682343f9736084e5b7f360a3411fc3af0292b2b5', "write_date" = '2025-02-07 13:28:48.289393', "write_uid" = 873 WHERE id IN (873);

Date: 2025-02-07 14:48:20 Duration: 19m31s
UPDATE "res_users" SET "exp_date" = '2025-02-07 21:56:43.810636', "last_update" = '2025-02-07 21:11:43.810652', "sid" = 'f06b66eea87e50cd16f6d25806330dc9643006d9', "write_date" = '2025-02-07 21:11:43.491358', "write_uid" = 1 WHERE id IN (923);

Date: 2025-02-07 22:29:13 Duration: 17m29s
UPDATE "res_users" SET "exp_date" = '2025-02-07 14:15:57.020709', "last_update" = '2025-02-07 13:30:57.020732', "sid" = '682343f9736084e5b7f360a3411fc3af0292b2b5', "write_date" = '2025-02-07 13:30:56.682088', "write_uid" = 873 WHERE id IN (873);

Date: 2025-02-07 14:48:20 Duration: 17m23s

3

0ms

59m59s

6s863ms

34,802

Details

2d18h21m5s

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 07	00	976	210ms	0ms
	01	953	213ms	0ms
	02	1,092	238ms	0ms
	03	884	189ms	0ms
	04	939	201ms	0ms
	05	537	117ms	0ms
	06	233	50ms	0ms
	07	249	53ms	0ms
	08	700	1m17s	111ms
	09	1,684	7s854ms	4ms
	10	2,190	8h57m55s	14s737ms
	11	1,535	11h15m42s	26s411ms
	12	2,232	7h46m28s	12s539ms
	13	3,225	10h27m2s	11s665ms
	14	3,387	5h14m31s	5s571ms
	15	2,888	677ms	0ms
	16	2,716	15h11m6s	20s127ms
	17	2,346	659ms	0ms
	18	2,017	2h9m3s	3s838ms
	19	1,700	6m48s	240ms
	20	1,115	2h11m44s	7s89ms
	21	834	2h59m15s	12s895ms
	22	370	80ms	0ms

update res_users set sid = '0170094f2a79373a8eee180cfca4bc28c1904c05', last_update = '2025-02-07 16:26:45.288375', exp_date = '2025-02-07 17:11:45.288378', logged_in = 'TRUE' where id = 1096;

Date: 2025-02-07 18:26:45 Duration: 59m59s
update res_users set sid = '0170094f2a79373a8eee180cfca4bc28c1904c05', last_update = '2025-02-07 16:26:45.288767', exp_date = '2025-02-07 17:11:45.288770', logged_in = 'TRUE' where id = 1096;

Date: 2025-02-07 18:26:45 Duration: 59m59s
update res_users set sid = '686cfe776fa4f10cbe8e658eef986e2cbbaf843b', last_update = '2025-02-07 19:35:19.071105', exp_date = '2025-02-07 20:20:19.071107', logged_in = 'TRUE' where id = 1096;

Date: 2025-02-07 21:35:18 Duration: 59m59s

4

656ms

4s40ms

3s104ms

151

Details

7m48s

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 07	00	2	5s775ms	2s887ms
	10	3	8s939ms	2s979ms
	11	11	34s421ms	3s129ms
	12	8	23s390ms	2s923ms
	13	8	23s847ms	2s980ms
	14	3	8s697ms	2s899ms
	15	8	19s214ms	2s401ms
	16	22	1m6s	3s24ms
	17	12	36s685ms	3s57ms
	18	30	1m37s	3s259ms
	19	19	1m3s	3s365ms
	20	17	53s899ms	3s170ms
	21	7	22s299ms	3s185ms
	22	1	3s304ms	3s304ms

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 '%22422%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-07 19:32:03 Duration: 4s40ms
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 (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))))) AND ("policy_number"."name"::text ilike '%158741%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-07 18:57:06 Duration: 3s930ms
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 (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))))) AND ("policy_number"."name"::text ilike '%15%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-07 18:57:05 Duration: 3s893ms

5

220ms

2s50ms

1s47ms

7,150

Details

2h4m47s

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 07	00	414	6m11s	896ms
	01	1,079	11m22s	632ms
	02	434	6m26s	891ms
	03	6	5s84ms	847ms
	08	29	25s176ms	868ms
	09	18	16s333ms	907ms
	10	31	28s166ms	908ms
	11	4	3s459ms	864ms
	12	1	913ms	913ms
	13	11	10s322ms	938ms
	14	129	1m59s	929ms
	15	30	27s81ms	902ms
	16	215	3m18s	922ms
	17	513	8m18s	972ms
	18	1,337	26m58s	1s210ms
	19	1,084	22m51s	1s265ms
	20	571	11m12s	1s177ms
	21	993	19m21s	1s169ms
	22	251	4m50s	1s156ms

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

Date: 2025-02-07 18:57:42 Duration: 2s50ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '221317')) 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 (51))))))) 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 (51)))))) 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 (51)))))) 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 (51))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-07 18:57:42 Duration: 2s45ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '73469')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-07 21:31:29 Duration: 1s831ms

6

523ms

1s525ms

595ms

27,493

Details

4h32m48s

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 07	00	152	1m38s	644ms
	01	220	2m18s	631ms
	02	165	1m48s	660ms
	03	174	1m55s	661ms
	04	201	2m10s	650ms
	05	112	1m13s	653ms
	06	70	42s882ms	612ms
	07	73	42s519ms	582ms
	08	763	7m14s	569ms
	09	1,506	14m33s	579ms
	10	1,998	19m40s	591ms
	11	1,721	16m41s	581ms
	12	1,831	17m59s	589ms
	13	2,321	22m40s	586ms
	14	3,102	30m51s	596ms
	15	3,100	30m6s	582ms
	16	2,441	23m47s	584ms
	17	2,276	22m32s	594ms
	18	1,869	18m55s	607ms
	19	1,481	15m53s	643ms
	20	1,030	10m28s	610ms
	21	657	6m33s	598ms
	22	230	2m17s	598ms

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

Date: 2025-02-07 17:21:57 Duration: 1s525ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5086208, 5086211, 5086214, 5086216, 5086219, 5086222, 5086224, 5086227, 5086231, 5086234, 5086236, 5086239, 5086242, 5086252, 5086255, 5086297, 5086300, 5086303, 5086306, 5086309, 5086312, 5086315, 5086318, 5086320, 5086327, 5086329, 5086332, 5086335, 5086340, 5086344, 5086347, 5086354, 5086356, 5086360, 5086364, 5086367, 5086370, 5086374, 5086377, 5086379, 5086382, 5086386, 5086390, 5086396, 5086399, 5086402, 5086405, 5086539, 5086545, 5086549, 5086553, 5086564, 5086567, 5086571, 5086576, 5086580, 5086584, 5096893, 5096895, 5096897, 5096900, 5096902, 5096904, 5096905, 5096912, 5096916, 5096921, 5096926, 5096932, 5096937, 5096943, 5096948, 5096952, 5096970, 5096974, 5097003, 5097011, 5097016, 5097023, 5097032, 5097035, 5097039, 5097043, 5097048, 5097053, 5097061, 5097066, 5097070, 5097076, 5097081, 5097087, 5097091, 5097098, 5097104, 5097112, 5097117, 5097132, 5097142, 5097148, 5097151, 5097155, 5097160, 5097165, 5097169, 5097176, 5097180, 5097184, 5097189, 5097192, 5097196, 5097202, 5097206, 5097210, 5097213, 5097218, 5097222, 5097225, 5097229, 5097237, 5097243, 5097246, 5097251, 5097256, 5097262, 5097270, 5097275, 5097281, 5097284, 5097294, 5097302, 5097306, 5097310, 5097315, 5097321, 5097325, 5097329, 5097336, 5097339, 5097343, 5097355, 5097358, 5097360, 5097362, 5097365, 5097367, 5097368, 5097372, 5097373, 5097375, 5097378, 5097381, 5097383, 5097386, 5097389, 5097394, 5097397, 5097402, 5097405, 5097413, 5097428, 5097435, 5097439, 5097442, 5097446, 5097450, 5097453, 5097457, 5097465, 5097468, 5097472, 5097476, 5097479, 5098099, 5098162, 5099622, 5099623, 5099624, 5100394, 5100395, 5100400, 5100401, 5100406, 5100407, 5100408, 5100409, 5100410, 5100411, 5100416, 5100417, 5100470, 5100474, 5100476, 5100480, 5100482, 5100485, 5100489, 5100605, 5100612, 5101297, 5101724, 5101725, 5101726, 5101727, 5101728, 5104174, 5104175, 5104176, 5104728, 5104730, 5105435, 5106203, 5106207, 5108934, 5108940, 5115713, 5115714, 5115869, 5115870, 5115871)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:28:45 Duration: 1s68ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5148055, 5145779, 5145736, 5145728, 5145695, 5145684, 5144321, 5144201, 5143941, 5143206, 5143171, 5143007, 5141257, 5141092, 5140945, 5137538, 5137512, 5134477, 5134459, 5134070, 5133991, 5133368, 5132949, 5132934, 5132919, 5131770, 5131711, 5131584, 5130968, 5129758, 5129088, 5129006, 5128968, 5128694, 5128618, 5128543, 5128180, 5127191, 5126585, 5126442, 5125617, 5125544, 5125169, 5124938, 5124817, 5124706, 5124381, 5124308, 5124289, 5124072, 5124006, 5123597, 5123487, 5123323, 5123004, 5122356, 5121605, 5121597, 5121588, 5121443, 5120826, 5119840, 5119800, 5116903, 5116378, 5113903, 5113894, 5113840, 5113836, 5113805, 5113787, 5113785, 5111045, 5110748, 5110725, 5110041, 5109988, 5109984, 5109794, 5109158, 5108383, 5108160, 5107858, 5107464, 5106699, 5106694, 5103399, 5101642, 5101572, 5100881, 5100729, 5099812, 5098759, 5098683, 5097907, 5097809, 5096557, 5095407, 5094735, 5094555)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:03:27 Duration: 1s46ms

7

518ms

1s46ms

583ms

165,877

Details

1d2h54m29s

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 07	00	7,921	1h15m16s	570ms
	01	9,802	1h34m58s	581ms
	02	8,462	1h20m23s	570ms
	03	7,452	1h11m18s	574ms
	04	8,629	1h20m53s	562ms
	05	5,394	49m37s	551ms
	06	1,881	17m10s	547ms
	07	1,314	11m55s	544ms
	08	3,514	32m57s	562ms
	09	7,265	1h9m36s	574ms
	10	8,359	1h20m10s	575ms
	11	6,952	1h5m16s	563ms
	12	8,308	1h18m50s	569ms
	13	9,171	1h26m48s	567ms
	14	10,969	1h46m31s	582ms
	15	9,117	1h27m14s	574ms
	16	8,481	1h21m24s	575ms
	17	6,498	1h4m43s	597ms
	18	6,890	1h11m31s	622ms
	19	13,973	2h30m19s	645ms
	20	9,675	1h37m58s	607ms
	21	4,395	44m46s	611ms
	22	1,455	14m48s	610ms

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

Date: 2025-02-07 19:03:27 Duration: 1s46ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5153552)) AND (("shipping_track"."id" not in (42746303, 42746303)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:03:27 Duration: 998ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5153890)) AND (("shipping_track"."id" not in (42750538, 42750538)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-07 19:23:43 Duration: 990ms

8

16ms

3s178ms

553ms

826

Details

7m37s

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	4	1s755ms	438ms
	02	1	179ms	179ms
	07	1	96ms	96ms
	08	14	2s920ms	208ms
	09	54	15s363ms	284ms
	10	24	7s372ms	307ms
	11	21	8s248ms	392ms
	12	60	13s187ms	219ms
	13	129	44s721ms	346ms
	14	108	28s28ms	259ms
	15	89	21s407ms	240ms
	16	63	22s321ms	354ms
	17	82	31s34ms	378ms
	18	48	1m8s	1s423ms
	19	49	1m28s	1s813ms
	20	34	53s707ms	1s579ms
	21	30	42s429ms	1s414ms
	22	15	7s153ms	476ms

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 (42)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (42))))) 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-07 17:55:25 Duration: 3s178ms
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 (67)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) 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-07 19:30:55 Duration: 3s46ms
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 (2)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2))))) 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-07 19:24:16 Duration: 2s862ms

9

206ms

1s859ms

442ms

9,012

Details

1h6m23s

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 07	00	938	4m7s	263ms
	01	909	4m9s	274ms
	02	916	4m1s	263ms
	03	1,281	5m44s	268ms
	04	470	2m3s	263ms
	05	84	22s19ms	262ms
	06	1	257ms	257ms
	08	242	1m6s	275ms
	09	850	3m56s	278ms
	10	513	2m21s	275ms
	11	58	16s92ms	277ms
	12	48	12s750ms	265ms
	13	114	30s960ms	271ms
	14	159	42s132ms	264ms
	15	275	1m18s	285ms
	16	249	1m9s	278ms
	17	420	2m22s	338ms
	18	306	6m31s	1s280ms
	19	405	9m22s	1s388ms
	20	261	5m30s	1s267ms
	21	327	6m42s	1s232ms
	22	186	3m50s	1s236ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '154945')) 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-07 21:46:09 Duration: 1s859ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '242231')) 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-07 18:06:56 Duration: 1s817ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '233968')) 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-07 18:06:56 Duration: 1s815ms

10

168ms

599ms

274ms

15,698

Details

1h11m45s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 07	08	334	1m21s	242ms
	09	1,337	6m23s	286ms
	10	1,272	6m22s	301ms
	11	1,858	8m23s	271ms
	12	1,663	7m14s	261ms
	13	1,519	7m6s	280ms
	14	2,856	12m21s	259ms
	15	2,185	9m30s	261ms
	16	1,886	8m6s	258ms
	17	347	1m50s	318ms
	18	441	3m4s	418ms

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

Date: 2025-02-07 18:48:03 Duration: 599ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '305353')))) ORDER BY "collection_policy"."id";

Date: 2025-02-07 18:48:01 Duration: 590ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '305273')))) ORDER BY "collection_policy"."id";

Date: 2025-02-07 18:48:10 Duration: 584ms

11

158ms

534ms

234ms

70,375

Details

4h35m25s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 07	00	1,497	4m27s	178ms
	01	2,880	8m41s	181ms
	02	2,339	7m	179ms
	03	2,716	8m7s	179ms
	04	3,507	10m31s	180ms
	05	2,134	6m20s	178ms
	06	583	1m43s	178ms
	07	827	2m26s	177ms
	08	1,429	4m17s	180ms
	09	3,236	9m46s	181ms
	10	2,946	9m3s	184ms
	11	4,359	13m16s	182ms
	12	3,487	10m52s	187ms
	13	2,877	8m52s	185ms
	14	6,510	20m23s	187ms
	15	3,382	10m29s	186ms
	16	4,550	13m56s	183ms
	17	954	3m2s	191ms
	18	6,739	39m50s	354ms
	19	12,115	1h15m17s	372ms
	20	971	5m6s	315ms
	21	297	1m34s	317ms
	22	40	12s489ms	312ms

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

Date: 2025-02-07 19:30:51 Duration: 534ms
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" = '9862248')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-07 19:30:52 Duration: 501ms
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" = '9862245')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-07 19:30:51 Duration: 489ms

12

207ms

325ms

234ms

2,726

Details

10m39s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 07	00	120	27s606ms	230ms
	01	120	27s823ms	231ms
	02	120	27s889ms	232ms
	03	120	27s814ms	231ms
	04	120	27s614ms	230ms
	05	120	27s382ms	228ms
	06	120	27s409ms	228ms
	07	120	27s359ms	227ms
	08	120	27s612ms	230ms
	09	120	27s966ms	233ms
	10	120	28s250ms	235ms
	11	120	28s41ms	233ms
	12	120	28s196ms	234ms
	13	120	28s445ms	237ms
	14	120	29s492ms	245ms
	15	120	28s401ms	236ms
	16	120	28s361ms	236ms
	17	116	27s561ms	237ms
	18	120	29s153ms	242ms
	19	120	30s249ms	252ms
	20	120	28s180ms	234ms
	21	120	27s669ms	230ms
	22	90	20s732ms	230ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-07 18:48:02 Duration: 325ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-07 19:32:01 Duration: 319ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-07 19:30:02 Duration: 311ms

13

92ms

812ms

225ms

31,834

Details

1h59m30s

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

Day	Hour	Count	Duration	Avg duration
Feb 07	00	2,658	9m28s	213ms
	01	3,944	13m59s	212ms
	02	2,658	9m14s	208ms
	03	2,521	9m30s	226ms
	04	915	3m18s	216ms
	05	166	35s958ms	216ms
	06	2	241ms	120ms
	08	528	1m56s	219ms
	09	1,720	7m13s	251ms
	10	1,084	4m4s	225ms
	11	124	20s651ms	166ms
	12	94	22s621ms	240ms
	13	250	54s726ms	218ms
	14	560	2m1s	216ms
	15	602	2m33s	254ms
	16	907	3m27s	228ms
	17	1,826	7m11s	236ms
	18	3,255	11m42s	215ms
	19	2,926	12m50s	263ms
	20	1,644	5m52s	214ms
	21	2,596	9m37s	222ms
	22	854	3m15s	229ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'طارق')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-07 19:01:48 Duration: 812ms
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-07 03:57:07 Duration: 787ms
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-07 03:57:07 Duration: 787ms

14

160ms

449ms

211ms

8,610

Details

30m19s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 07	00	256	45s641ms	178ms
	01	235	41s978ms	178ms
	02	13	2s316ms	178ms
	03	8	1s416ms	177ms
	04	28	4s957ms	177ms
	06	71	12s521ms	176ms
	07	827	2m27s	177ms
	08	652	1m58s	181ms
	09	468	1m24s	180ms
	10	390	1m11s	182ms
	11	749	2m17s	183ms
	12	251	45s794ms	182ms
	13	319	58s807ms	184ms
	14	1,072	3m20s	186ms
	15	486	1m30s	185ms
	16	886	2m42s	183ms
	17	264	53s409ms	202ms
	18	987	5m20s	325ms
	19	445	2m35s	349ms
	20	145	46s146ms	318ms
	21	28	8s939ms	319ms
	22	30	9s327ms	310ms

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

Date: 2025-02-07 19:23:50 Duration: 440ms
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" = '156391')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) 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-07 19:02:55 Duration: 439ms

15

156ms

270ms

179ms

14,304

Details

42m50s

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 07	00	1,209	3m36s	179ms
	01	2,477	7m26s	180ms
	02	2,326	6m58s	180ms
	03	2,528	7m33s	179ms
	04	3,401	10m13s	180ms
	05	1,877	5m35s	178ms
	06	476	1m24s	178ms
	22	10	1s858ms	185ms

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" = '361479')) 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-07 01:15:58 Duration: 270ms
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" = '317184')) 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-07 01:52:36 Duration: 228ms
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" = '9656773')) 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-07 04:00:33 Duration: 222ms

16

100ms

230ms

120ms

6,927

Details

13m51s

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

Day	Hour	Count	Duration	Avg duration
Feb 07	08	132	15s803ms	119ms
	09	395	48s226ms	122ms
	10	408	48s755ms	119ms
	11	241	29s296ms	121ms
	12	427	51s761ms	121ms
	13	675	1m20s	118ms
	14	909	1m48s	119ms
	15	1,461	2m53s	118ms
	16	436	53s15ms	121ms
	17	576	1m9s	120ms
	18	681	1m20s	118ms
	19	350	43s717ms	124ms
	20	111	13s670ms	123ms
	21	103	12s74ms	117ms
	22	22	2s640ms	120ms

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

Date: 2025-02-07 19:30:44 Duration: 230ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8102713)) AND (("cash_track"."id" not in (7823790, 7825864, 7826987, 7827567, 7835811, 7835811)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-07 17:22:46 Duration: 185ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8078912)) AND (("cash_track"."id" not in (7646541, 7656572, 7662803, 7838195, 7838203, 7838203)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-07 19:30:45 Duration: 182ms

17

47ms

92ms

57ms

27,006

Details

25m51s

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

Day	Hour	Count	Duration	Avg duration
Feb 07	08	851	48s57ms	56ms
	09	1,852	1m44s	56ms
	10	1,601	1m31s	57ms
	11	2,430	2m19s	57ms
	12	3,147	3m	57ms
	13	2,126	1m59s	56ms
	14	4,461	4m21s	58ms
	15	3,291	3m8s	57ms
	16	4,166	4m1s	57ms
	17	2,322	2m12s	56ms
	18	670	39s451ms	58ms
	19	31	2s80ms	67ms
	20	18	1s22ms	56ms
	21	13	737ms	56ms
	22	27	1s597ms	59ms

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

Date: 2025-02-07 14:32:07 Duration: 92ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5056607) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-07 17:22:19 Duration: 92ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5074381) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-07 12:28:21 Duration: 84ms

18

38ms

116ms

53ms

92,882

Details

1h22m23s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 07	00	3,751	3m20s	53ms
	01	4,331	3m53s	53ms
	02	2,519	2m15s	53ms
	03	2,330	2m6s	54ms
	04	2,477	2m14s	54ms
	05	2,102	1m54s	54ms
	06	581	31s642ms	54ms
	07	711	38s987ms	54ms
	08	1,974	1m46s	53ms
	09	4,613	4m11s	54ms
	10	6,406	5m53s	55ms
	11	5,214	4m44s	54ms
	12	6,220	5m42s	55ms
	13	7,315	6m39s	54ms
	14	8,613	8m	55ms
	15	7,030	6m27s	55ms
	16	6,558	5m59s	54ms
	17	4,589	3m45s	49ms
	18	4,270	3m19s	46ms
	19	4,533	3m43s	49ms
	20	3,042	2m21s	46ms
	21	2,744	2m6s	45ms
	22	959	44s450ms	46ms

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

Date: 2025-02-07 01:15:58 Duration: 116ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5140990)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-07 17:21:56 Duration: 113ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5130968)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-07 19:03:49 Duration: 94ms

19

42ms

72ms

52ms

13,786

Details

11m58s

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 07	08	335	16s921ms	50ms
	09	973	50s266ms	51ms
	10	806	41s381ms	51ms
	11	1,316	1m8s	51ms
	12	1,583	1m22s	51ms
	13	1,233	1m4s	51ms
	14	2,220	1m58s	53ms
	15	1,609	1m25s	53ms
	16	2,218	1m53s	51ms
	17	1,114	57s107ms	51ms
	18	379	20s288ms	53ms

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

Date: 2025-02-07 14:24:02 Duration: 72ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5050187) ORDER BY "collection_policy"."id";

Date: 2025-02-07 14:24:03 Duration: 71ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5024995) ORDER BY "collection_policy"."id";

Date: 2025-02-07 14:24:02 Duration: 71ms

20

0ms

46ms

1ms

431,680

Details

7m45s

insert into policy_number (name, notebook_id, package_id, active, damaged) values (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false), (?, ?, ?, true, false);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 07	17	431,680	7m45s	1ms

INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (1454051, 379237, 2414, True, False), (1454052, 379237, 2414, True, False), (1454053, 379237, 2414, True, False), (1454054, 379237, 2414, True, False), (1454055, 379237, 2414, True, False), (1454056, 379237, 2414, True, False), (1454057, 379237, 2414, True, False), (1454058, 379237, 2414, True, False), (1454059, 379237, 2414, True, False), (1454060, 379237, 2414, True, False), (1454061, 379237, 2414, True, False), (1454062, 379237, 2414, True, False), (1454063, 379237, 2414, True, False), (1454064, 379237, 2414, True, False), (1454065, 379237, 2414, True, False), (1454066, 379237, 2414, True, False), (1454067, 379237, 2414, True, False), (1454068, 379237, 2414, True, False), (1454069, 379237, 2414, True, False), (1454070, 379237, 2414, True, False), (1454071, 379237, 2414, True, False), (1454072, 379237, 2414, True, False), (1454073, 379237, 2414, True, False), (1454074, 379237, 2414, True, False), (1454075, 379237, 2414, True, False), (1454076, 379237, 2414, True, False), (1454077, 379237, 2414, True, False), (1454078, 379237, 2414, True, False), (1454079, 379237, 2414, True, False), (1454080, 379237, 2414, True, False), (1454081, 379237, 2414, True, False), (1454082, 379237, 2414, True, False), (1454083, 379237, 2414, True, False), (1454084, 379237, 2414, True, False), (1454085, 379237, 2414, True, False), (1454086, 379237, 2414, True, False), (1454087, 379237, 2414, True, False), (1454088, 379237, 2414, True, False), (1454089, 379237, 2414, True, False), (1454090, 379237, 2414, True, False), (1454091, 379237, 2414, True, False), (1454092, 379237, 2414, True, False), (1454093, 379237, 2414, True, False), (1454094, 379237, 2414, True, False), (1454095, 379237, 2414, True, False), (1454096, 379237, 2414, True, False), (1454097, 379237, 2414, True, False), (1454098, 379237, 2414, True, False), (1454099, 379237, 2414, True, False), (1454100, 379237, 2414, True, False);

Date: 2025-02-07 17:53:16 Duration: 46ms
INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (677701, 406380, 2416, True, False), (677702, 406380, 2416, True, False), (677703, 406380, 2416, True, False), (677704, 406380, 2416, True, False), (677705, 406380, 2416, True, False), (677706, 406380, 2416, True, False), (677707, 406380, 2416, True, False), (677708, 406380, 2416, True, False), (677709, 406380, 2416, True, False), (677710, 406380, 2416, True, False), (677711, 406380, 2416, True, False), (677712, 406380, 2416, True, False), (677713, 406380, 2416, True, False), (677714, 406380, 2416, True, False), (677715, 406380, 2416, True, False), (677716, 406380, 2416, True, False), (677717, 406380, 2416, True, False), (677718, 406380, 2416, True, False), (677719, 406380, 2416, True, False), (677720, 406380, 2416, True, False), (677721, 406380, 2416, True, False), (677722, 406380, 2416, True, False), (677723, 406380, 2416, True, False), (677724, 406380, 2416, True, False), (677725, 406380, 2416, True, False), (677726, 406380, 2416, True, False), (677727, 406380, 2416, True, False), (677728, 406380, 2416, True, False), (677729, 406380, 2416, True, False), (677730, 406380, 2416, True, False), (677731, 406380, 2416, True, False), (677732, 406380, 2416, True, False), (677733, 406380, 2416, True, False), (677734, 406380, 2416, True, False), (677735, 406380, 2416, True, False), (677736, 406380, 2416, True, False), (677737, 406380, 2416, True, False), (677738, 406380, 2416, True, False), (677739, 406380, 2416, True, False), (677740, 406380, 2416, True, False), (677741, 406380, 2416, True, False), (677742, 406380, 2416, True, False), (677743, 406380, 2416, True, False), (677744, 406380, 2416, True, False), (677745, 406380, 2416, True, False), (677746, 406380, 2416, True, False), (677747, 406380, 2416, True, False), (677748, 406380, 2416, True, False), (677749, 406380, 2416, True, False), (677750, 406380, 2416, True, False);

Date: 2025-02-07 17:38:17 Duration: 45ms
INSERT INTO policy_number (name, notebook_id, package_id, active, damaged) values (2247301, 437772, 2416, True, False), (2247302, 437772, 2416, True, False), (2247303, 437772, 2416, True, False), (2247304, 437772, 2416, True, False), (2247305, 437772, 2416, True, False), (2247306, 437772, 2416, True, False), (2247307, 437772, 2416, True, False), (2247308, 437772, 2416, True, False), (2247309, 437772, 2416, True, False), (2247310, 437772, 2416, True, False), (2247311, 437772, 2416, True, False), (2247312, 437772, 2416, True, False), (2247313, 437772, 2416, True, False), (2247314, 437772, 2416, True, False), (2247315, 437772, 2416, True, False), (2247316, 437772, 2416, True, False), (2247317, 437772, 2416, True, False), (2247318, 437772, 2416, True, False), (2247319, 437772, 2416, True, False), (2247320, 437772, 2416, True, False), (2247321, 437772, 2416, True, False), (2247322, 437772, 2416, True, False), (2247323, 437772, 2416, True, False), (2247324, 437772, 2416, True, False), (2247325, 437772, 2416, True, False), (2247326, 437772, 2416, True, False), (2247327, 437772, 2416, True, False), (2247328, 437772, 2416, True, False), (2247329, 437772, 2416, True, False), (2247330, 437772, 2416, True, False), (2247331, 437772, 2416, True, False), (2247332, 437772, 2416, True, False), (2247333, 437772, 2416, True, False), (2247334, 437772, 2416, True, False), (2247335, 437772, 2416, True, False), (2247336, 437772, 2416, True, False), (2247337, 437772, 2416, True, False), (2247338, 437772, 2416, True, False), (2247339, 437772, 2416, True, False), (2247340, 437772, 2416, True, False), (2247341, 437772, 2416, True, False), (2247342, 437772, 2416, True, False), (2247343, 437772, 2416, True, False), (2247344, 437772, 2416, True, False), (2247345, 437772, 2416, True, False), (2247346, 437772, 2416, True, False), (2247347, 437772, 2416, True, False), (2247348, 437772, 2416, True, False), (2247349, 437772, 2416, True, False), (2247350, 437772, 2416, True, False);

Date: 2025-02-07 17:38:58 Duration: 43ms

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

11,088,538 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	10	0.00%
DETAIL	25	0.00%
ERROR	2,077	0.02%
EVENTLOG	531	0.00%
FATAL	562	0.01%
HINT	6	0.00%
LOG	11,083,233	99.95%
STATEMENT	2,094	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
562 FATAL entries
2077 ERROR entries
0 WARNING entries
531 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,139 Max number of times the same event was reported
3,170 Total events found

Rank

Times reported

Error

1

1,139

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 07	00	13
	01	7
	02	12
	03	5
	04	6
	05	4
	06	7
	07	2
	08	14
	09	100
	10	56
	11	45
	12	57
	13	162
	14	140
	15	115
	16	43
	17	52
	18	123
	19	92
	20	32
	21	21
	22	31

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

926

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 07	00	11
	01	4
	02	12
	03	1
	04	2
	05	1
	06	3
	07	2
	08	14
	09	37
	10	48
	11	27
	12	55
	13	153
	14	129
	15	105
	16	35
	17	48
	18	106
	19	53
	20	24
	21	20
	22	36

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

356

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 07	10	25
	11	82
	12	30
	13	120
	14	25
	16	69
	18	1
	20	2
	21	1
	22	1

4

356

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 07	10	25
	11	82
	12	30
	13	120
	14	25
	16	69
	18	1
	20	2
	21	1
	22	1

5

130

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 07	10	7
	11	19
	12	2
	13	50
	14	9
	16	38
	18	1
	20	1
	21	2
	22	1

6

122

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 07	17	122

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

7

44

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 07	10	5
	11	7
	13	17
	14	2
	16	12
	21	1

8

21

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 07	12	4
	13	6
	14	5
	15	6

9

19

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Feb 07	10	16
	19	3

FATAL: password authentication failed for user "postgres"

10

18

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Feb 07	17	18

11

12

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Feb 07	17	12

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

12

6

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Feb 07	09	1
	11	1
	14	3
	16	1

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

13

5

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Feb 07	05	1
	07	1
	13	1
	17	1
	19	1

14

5

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Feb 07	05	1
	07	2
	13	1
	19	1

15

4

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Feb 07	05	1
	07	1
	13	1
	19	1

16

3

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Feb 07	02	2
	07	1

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

17

2

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Feb 07	17	2

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

18

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Feb 07	17	1

19

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Feb 07	13	1

ERROR: could not serialize access due to concurrent delete

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