pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Jan 1 23:47:30 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 42,416,035 log entries in 2m29s
Log start from 2025-01-01 00:00:00 to 2025-01-01 22:45:01

Global Stats

19,462 Number of unique normalized queries
18,233,542 Number of queries
6d6h43m54s Total query duration
2025-01-01 00:00:00 First query
2025-01-01 22:45:01 Last query
5,707 queries/s at 2025-01-01 13:36:23 Query peak

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

9,967 Number of events
23 Number of unique normalized events
3,662 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
18,233,542 Average queries per session
6d6h43m54s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

5,707 queries/s Query Peak
2025-01-01 13:36:23 Date

SELECT Traffic

Key values

4,063 queries/s Query Peak
2025-01-01 13:36:23 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,497 queries/s Query Peak
2025-01-01 09:25:24 Date

Queries duration

Key values

6d6h43m54s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 01	00	256,133	0ms	19s811ms	19ms	3m16s	4m8s	4m22s
	01	262,159	0ms	1s79ms	19ms	2m37s	3m3s	4m25s
	02	222,209	0ms	1s6ms	20ms	2m34s	3m1s	3m39s
	03	185,489	0ms	618ms	18ms	1m58s	2m10s	2m54s
	04	170,811	0ms	598ms	23ms	2m35s	2m43s	3m28s
	05	183,979	0ms	644ms	19ms	2m9s	2m47s	4m
	06	243,392	0ms	4s134ms	23ms	2m45s	3m40s	4m13s
	07	190,126	0ms	4s336ms	11ms	1m12s	1m16s	1m56s
	08	427,077	0ms	17m26s	61ms	2m33s	2m46s	6h8m25s
	09	960,284	0ms	1m57s	11ms	4m10s	6m31s	29m7s
	10	1,347,487	0ms	16m18s	25ms	8m3s	9m18s	2h48m4s
	11	1,593,411	0ms	18m40s	25ms	6m28s	1h23m43s	3h29m49s
	12	1,528,611	0ms	7m58s	12ms	5m13s	7m7s	1h13m25s
	13	1,660,145	0ms	28m9s	23ms	6m16s	1h32m40s	2h49m49s
	14	1,519,915	0ms	14m13s	32ms	45m	57m14s	2h37m35s
	15	1,527,757	0ms	11m17s	26ms	40m45s	1h51m59s	2h44s
	16	1,409,153	0ms	20m13s	36ms	7m21s	2h4m32s	3h54m29s
	17	1,043,842	0ms	12m28s	32ms	5m50s	49m1s	2h35m29s
	18	948,094	0ms	48s174ms	12ms	4m57s	5m57s	11m14s
	19	967,035	0ms	25m29s	44ms	14m18s	15m44s	3h55m51s
	20	760,151	0ms	28m52s	65ms	8m	9m59s	4h35m49s
	21	536,859	0ms	18m54s	64ms	5m40s	11m3s	4h14m26s
	22	289,423	0ms	59m57s	83ms	5m19s	6m54s	3h26m54s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 01	00	136,569	35ms	1m59s	3m16s	4m12s
	01	136,745	38ms	2m2s	2m37s	4m11s
	02	112,260	40ms	2m18s	2m34s	3m6s
	03	89,243	37ms	1m35s	1m58s	2m10s
	04	83,387	48ms	1m56s	2m35s	3m5s
	05	87,841	40ms	1m35s	2m9s	3m29s
	06	127,483	43ms	2m16s	2m45s	3m48s
	07	101,696	20ms	1m1s	1m12s	1m39s
	08	247,535	17ms	1m48s	2m28s	2m45s
	09	566,890	17ms	3m22s	4m3s	6m30s
	10	792,589	20ms	5m59s	6m54s	8m32s
	11	974,775	12ms	4m55s	5m18s	6m44s
	12	927,438	13ms	4m28s	4m56s	6m53s
	13	999,946	13ms	4m37s	5m18s	6m31s
	14	938,164	13ms	5m15s	5m47s	7m6s
	15	928,344	11ms	3m50s	4m20s	5m7s
	16	846,654	19ms	6m16s	7m10s	7m32s
	17	633,132	17ms	4m10s	4m52s	5m49s
	18	555,516	21ms	4m23s	4m57s	7m20s
	19	577,087	47ms	10m57s	13m5s	15m5s
	20	455,160	36ms	6m3s	7m32s	9m48s
	21	322,353	35ms	4m32s	5m30s	8m38s
	22	168,399	47ms	3m59s	4m34s	5m32s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 01	00	20,315	4,272	145	0	1ms	110ms	182ms	311ms
	01	20,580	4,896	133	0	0ms	126ms	153ms	263ms
	02	15,715	4,433	155	0	0ms	110ms	145ms	214ms
	03	11,594	3,433	130	0	0ms	77ms	106ms	137ms
	04	16,817	3,805	132	0	0ms	100ms	130ms	226ms
	05	10,360	3,892	131	0	0ms	67ms	88ms	155ms
	06	17,950	5,216	142	0	0ms	100ms	120ms	178ms
	07	9,361	3,102	178	0	0ms	53ms	95ms	107ms
	08	16,800	6,191	517	0	937ms	108ms	137ms	218ms
	09	42,813	13,726	480	0	30ms	233ms	260ms	529ms
	10	71,878	18,919	709	0	199ms	442ms	489ms	8s126ms
	11	62,267	19,385	728	0	344ms	413ms	500ms	1h21m15s
	12	62,577	18,637	721	0	77ms	358ms	438ms	737ms
	13	65,367	22,989	850	2	285ms	396ms	508ms	1h30m24s
	14	56,933	21,838	615	1	450ms	446ms	56s630ms	55m24s
	15	50,590	19,931	719	0	422ms	338ms	437ms	1h50m13s
	16	65,155	22,107	1,010	0	396ms	424ms	508ms	2h1m18s
	17	51,819	17,963	578	0	327ms	380ms	658ms	46m59s
	18	63,175	16,677	701	0	1ms	352ms	475ms	16s863ms
	19	82,456	30,549	610	1	138ms	628ms	840ms	1m28s
	20	65,234	15,584	567	0	404ms	367ms	494ms	1m38s
	21	43,642	13,029	219	0	404ms	291ms	370ms	757ms
	22	27,440	8,094	146	0	450ms	215ms	285ms	59m57s

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

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

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

286,299 buffers Checkpoint Peak
2025-01-01 05:11:24 Date
270.061 seconds Highest write time
0.355 seconds Sync time

Checkpoints Wal files

Key values

123 files Wal files usage Peak
2025-01-01 05:11:24 Date

Checkpoints distance

Key values

3,940.77 Mo Distance Peak
2025-01-01 05:11:24 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 01	00	117,396	3,239.491s	0.031s	3,239.567s
	01	113,663	3,239.578s	0.036s	3,239.657s
	02	123,891	3,218.443s	0.039s	3,218.524s
	03	96,107	3,046.628s	0.027s	3,046.697s
	04	81,635	2,855.366s	0.026s	2,855.431s
	05	370,648	3,239.391s	0.135s	3,239.591s
	06	134,913	3,239.608s	0.029s	3,239.685s
	07	63,048	3,141.552s	0.026s	3,141.61s
	08	133,028	3,239.53s	0.035s	3,239.604s
	09	309,054	3,239.503s	0.036s	3,239.597s
	10	460,268	3,239.599s	0.054s	3,239.722s
	11	488,046	3,239.457s	0.048s	3,239.587s
	12	435,515	3,239.528s	0.052s	3,239.665s
	13	472,711	2,969.488s	0.043s	2,969.61s
	14	407,672	3,239.527s	0.058s	3,239.657s
	15	324,973	2,969.446s	0.039s	2,969.546s
	16	402,417	3,239.527s	0.05s	3,239.649s
	17	272,382	2,886.717s	0.097s	2,886.879s
	18	302,040	3,239.523s	0.058s	3,239.665s
	19	363,209	3,239.506s	0.049s	3,239.644s
	20	301,283	3,239.111s	0.407s	3,239.585s
	21	208,745	3,239.587s	0.042s	3,239.689s
	22	126,208	2,429.682s	0.028s	2,429.751s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 01	00	50	3,021	0.002s	0.012s
	01	51	2,612	0.010s	0.012s
	02	54	2,611	0.002s	0.012s
	03	43	2,266	0.002s	0.012s
	04	36	2,348	0.002s	0.012s
	05	150	1,918	0.012s	0.012s
	06	44	2,517	0.002s	0.012s
	07	21	2,428	0.002s	0.012s
	08	47	3,672	0.003s	0.012s
	09	114	4,727	0.002s	0.012s
	10	168	5,054	0.003s	0.012s
	11	181	5,299	0.002s	0.012s
	12	164	5,127	0.002s	0.012s
	13	183	4,946	0.003s	0.011s
	14	160	5,341	0.003s	0.012s
	15	127	5,149	0.002s	0.011s
	16	154	5,800	0.003s	0.012s
	17	108	5,328	0.037s	0.012s
	18	122	5,440	0.014s	0.012s
	19	150	5,150	0.002s	0.012s
	20	123	5,142	0.215s	0.012s
	21	86	4,582	0.003s	0.012s
	22	54	2,963	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Jan 01	00	68,346.42 kB	136,835.92 kB
	01	70,689.83 kB	102,174.58 kB
	02	73,283.83 kB	94,545.33 kB
	03	58,159.75 kB	87,069.33 kB
	04	49,774.75 kB	71,124.42 kB
	05	205,181.33 kB	1,116,892.67 kB
	06	59,243.50 kB	460,298.75 kB
	07	29,150.58 kB	160,288.67 kB
	08	63,470.33 kB	88,253.75 kB
	09	155,630.92 kB	189,316.00 kB
	10	229,763.08 kB	272,940.17 kB
	11	247,546.75 kB	290,305.83 kB
	12	223,266.08 kB	288,604.58 kB
	13	273,485.64 kB	328,070.18 kB
	14	219,258.90 kB	275,809.50 kB
	15	186,669.70 kB	255,254.00 kB
	16	211,056.92 kB	243,384.00 kB
	17	146,975.08 kB	236,742.17 kB
	18	167,051.25 kB	250,607.33 kB
	19	203,664.08 kB	222,033.83 kB
	20	168,935.58 kB	243,038.33 kB
	21	116,379.67 kB	197,261.58 kB
	22	98,485.11 kB	132,294.67 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (270) Main checkpoint cause
271 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	270
shutdown immediate	1
Total	271

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

10,809,206 Total read queries
5,022,609 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,809,206	59.28%
INSERT	950,838	5.21%
UPDATE	298,668	1.64%
DELETE	10,316	0.06%
COPY FROM	4	0.00%
COPY TO	0	0.00%
CTE	31,915	0.18%
DDL	2,975	0.02%
TCL	3,727,893	20.45%
CURSOR	0	0.00%
OTHERS	2,401,727	13.17%

Queries by database

Key values

unknown Main database
18,233,542 Requests
6d6h43m54s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	18,233,542	6d6h43m54s
	copy from	4	4ms
	cte	31,915	6s804ms
	ddl	2,975	406ms
	delete	10,316	1s359ms
	insert	950,838	4m56s
	others	2,401,727	1m49s
	select	10,809,206	2d15h25m52s
	tcl	3,727,893	2m31s
	update	298,668	3d15h8m36s

Queries by user

Key values

unknown Main user
18,233,542 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	18,233,542	6d6h43m54s
	copy from	4	4ms
	cte	31,915	6s804ms
	ddl	2,975	406ms
	delete	10,316	1s359ms
	insert	950,838	4m56s
	others	2,401,727	1m49s
	select	10,809,206	2d15h25m52s
	tcl	3,727,893	2m31s
	update	298,668	3d15h8m36s

Duration by user

Key values

6d6h43m54s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	18,233,542	6d6h43m54s
	copy from	4	4ms
	cte	31,915	6s804ms
	ddl	2,975	406ms
	delete	10,316	1s359ms
	insert	950,838	4m56s
	others	2,401,727	1m49s
	select	10,809,206	2d15h25m52s
	tcl	3,727,893	2m31s
	update	298,668	3d15h8m36s

Queries by host

Key values

unknown Main host
18,233,542 Requests
6d6h43m54s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,233,542	6d6h43m54s
	copy from	4	4ms
	cte	31,915	6s804ms
	ddl	2,975	406ms
	delete	10,316	1s359ms
	insert	950,838	4m56s
	others	2,401,727	1m49s
	select	10,809,206	2d15h25m52s
	tcl	3,727,893	2m31s
	update	298,668	3d15h8m36s

Queries by application

Key values

unknown Main application
18,233,542 Requests
6d6h43m54s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	18,233,542	6d6h43m54s
	copy from	4	4ms
	cte	31,915	6s804ms
	ddl	2,975	406ms
	delete	10,316	1s359ms
	insert	950,838	4m56s
	others	2,401,727	1m49s
	select	10,809,206	2d15h25m52s
	tcl	3,727,893	2m31s
	update	298,668	3d15h8m36s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-01 13:22:21 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,077,455 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,077,455	93.66%
1-5ms	276,937	1.52%
5-10ms	13,682	0.08%
10-25ms	49,417	0.27%
25-50ms	191,704	1.05%
50-100ms	46,077	0.25%
100-500ms	471,867	2.59%
500-1000ms	101,277	0.56%
1000-10000ms	3,905	0.02%
> 10000ms	1,221	0.01%

Slowest individual queries

Rank	Duration	Query
1	59m57s	update res_users set sid = '55bbf12ac39503148606de1763ed10f44e7f0e34', last_update = '2025-01-01 20:27:53.372449', exp_date = '2025-01-01 21:12:53.372453', logged_in = 'TRUE' where id = 956; [ Date: 2025-01-01 22:27:50 ]
2	28m52s	UPDATE "res_users" SET "exp_date" = '2025-01-01 20:06:28.111742', "last_update" = '2025-01-01 19:21:28.111764', "sid" = '0e772e83c1d88a5e715d34199b70492f1a92f0f4', "write_date" = '2025-01-01 19:21:27.785938', "write_uid" = 1 WHERE id IN (857); [ Date: 2025-01-01 20:50:20 ]
3	28m25s	update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:21:54.342244', exp_date = '2025-01-01 20:06:54.342248', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-01 20:50:20 ]
4	28m9s	UPDATE "res_users" SET "exp_date" = '2025-01-01 12:39:11.363002', "last_update" = '2025-01-01 11:54:11.363026', "write_date" = '2025-01-01 11:54:11.026151', "write_uid" = 1 WHERE id IN (886); [ Date: 2025-01-01 13:22:21 ]
5	28m1s	update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:22:18.516468', exp_date = '2025-01-01 20:07:18.516474', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-01 20:50:20 ]
6	27m58s	update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:22:22.307023', exp_date = '2025-01-01 20:07:22.307027', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-01 20:50:20 ]
7	27m55s	update res_users set sid = 'eb67f6b77efb78a566de1c93967cbaff298abdb5', last_update = '2025-01-01 11:54:26.001931', exp_date = '2025-01-01 12:39:26.001935', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-01 13:22:21 ]
8	25m29s	update res_users set sid = 'edbcdafe3a34a51a85d23a5bb177fb4389494164', last_update = '2025-01-01 18:11:51.442631', exp_date = '2025-01-01 18:56:51.442634', logged_in = 'TRUE' where id = 1387; [ Date: 2025-01-01 19:37:20 ]
9	25m29s	update res_users set sid = 'edbcdafe3a34a51a85d23a5bb177fb4389494164', last_update = '2025-01-01 18:11:51.441816', exp_date = '2025-01-01 18:56:51.441819', logged_in = 'TRUE' where id = 1387; [ Date: 2025-01-01 19:37:20 ]
10	22m20s	update res_users set sid = 'edbcdafe3a34a51a85d23a5bb177fb4389494164', last_update = '2025-01-01 18:14:59.711803', exp_date = '2025-01-01 18:59:59.711805', logged_in = 'TRUE' where id = 1387; [ Date: 2025-01-01 19:37:20 ]
11	22m16s	update res_users set sid = 'edbcdafe3a34a51a85d23a5bb177fb4389494164', last_update = '2025-01-01 18:15:04.510763', exp_date = '2025-01-01 19:00:04.510769', logged_in = 'TRUE' where id = 1387; [ Date: 2025-01-01 19:37:20 ]
12	22m8s	update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:28:11.309812', exp_date = '2025-01-01 20:13:11.309814', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-01 20:50:20 ]
13	20m26s	update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:00:54.963110', exp_date = '2025-01-01 19:45:54.963115', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-01 20:21:21 ]
14	20m26s	update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:00:54.963115', exp_date = '2025-01-01 19:45:54.963118', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-01 20:21:21 ]
15	20m13s	update res_users set sid = '1565f0ea9a7f561125db1b7fe5800e07786d6338', last_update = '2025-01-01 15:09:06.897840', exp_date = '2025-01-01 15:54:06.897842', logged_in = 'TRUE' where id = 878; [ Date: 2025-01-01 16:29:20 ]
16	20m13s	update res_users set sid = '1565f0ea9a7f561125db1b7fe5800e07786d6338', last_update = '2025-01-01 15:09:06.897639', exp_date = '2025-01-01 15:54:06.897643', logged_in = 'TRUE' where id = 878; [ Date: 2025-01-01 16:29:20 ]
17	20m10s	update res_users set sid = 'aa9c1c8d918773544160ecb915fcd28af45e1d0e', last_update = '2025-01-01 15:31:10.197780', exp_date = '2025-01-01 16:16:10.197784', logged_in = 'TRUE' where id = 884; [ Date: 2025-01-01 16:51:20 ]
18	20m10s	update res_users set sid = 'aa9c1c8d918773544160ecb915fcd28af45e1d0e', last_update = '2025-01-01 15:31:10.197627', exp_date = '2025-01-01 16:16:10.197630', logged_in = 'TRUE' where id = 884; [ Date: 2025-01-01 16:51:20 ]
19	19m43s	update res_users set sid = '1565f0ea9a7f561125db1b7fe5800e07786d6338', last_update = '2025-01-01 15:09:37.252070', exp_date = '2025-01-01 15:54:37.252076', logged_in = 'TRUE' where id = 878; [ Date: 2025-01-01 16:29:20 ]
20	19m32s	update res_users set sid = 'edbcdafe3a34a51a85d23a5bb177fb4389494164', last_update = '2025-01-01 18:17:47.999634', exp_date = '2025-01-01 19:02:47.999639', logged_in = 'TRUE' where id = 1387; [ Date: 2025-01-01 19:37:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d12h34m32s

72,222

Details

0ms

59m57s

4s215ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 01	00	684	153ms	0ms
	01	766	171ms	0ms
	02	625	135ms	0ms
	03	602	134ms	0ms
	04	430	93ms	0ms
	05	648	142ms	0ms
	06	738	167ms	0ms
	07	479	105ms	0ms
	08	1,626	6h7m19s	13s554ms
	09	3,874	28m29s	441ms
	10	5,726	4h53m32s	3s75ms
	11	7,110	7h46m8s	3s933ms
	12	7,030	1h45m37s	901ms
	13	7,895	6h31m47s	2s977ms
	14	7,007	9h46m34s	5s22ms
	15	6,827	8h16m41s	4s365ms
	16	5,605	9h16m26s	5s956ms
	17	4,142	6h21m20s	5s524ms
	18	3,107	1m19s	25ms
	19	2,945	4h9m21s	5s80ms
	20	2,137	8h32m23s	14s386ms
	21	1,510	6h23m18s	15s231ms
	22	709	4h14m9s	21s507ms

update res_users set sid = '55bbf12ac39503148606de1763ed10f44e7f0e34', last_update = '2025-01-01 20:27:53.372449', exp_date = '2025-01-01 21:12:53.372453', logged_in = 'TRUE' where id = 956;

Date: 2025-01-01 22:27:50 Duration: 59m57s
update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:21:54.342244', exp_date = '2025-01-01 20:06:54.342248', logged_in = 'TRUE' where id = 857;

Date: 2025-01-01 20:50:20 Duration: 28m25s
update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:22:18.516468', exp_date = '2025-01-01 20:07:18.516474', logged_in = 'TRUE' where id = 857;

Date: 2025-01-01 20:50:20 Duration: 28m1s

2

1d8h29m56s

238,274

Details

415ms

3s858ms

491ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 01	00	6,834	53m16s	467ms
	01	7,351	57m	465ms
	02	6,393	49m6s	460ms
	03	5,164	39m25s	458ms
	04	5,560	43m30s	469ms
	05	5,181	39m18s	455ms
	06	6,924	53m11s	460ms
	07	2,625	20m21s	465ms
	08	5,699	43m22s	456ms
	09	8,654	1h7m57s	471ms
	10	19,013	2h41m15s	508ms
	11	14,128	1h55m55s	492ms
	12	14,141	1h54m32s	485ms
	13	12,611	1h43m47s	493ms
	14	10,322	1h26m9s	500ms
	15	9,698	1h18m1s	482ms
	16	13,844	1h57m40s	509ms
	17	9,647	1h18m11s	486ms
	18	11,697	1h34m58s	487ms
	19	23,311	3h33m46s	550ms
	20	18,884	2h34m41s	491ms
	21	11,646	1h34m21s	486ms
	22	8,947	1h10m6s	470ms

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

Date: 2025-01-01 19:45:36 Duration: 3s858ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4127264)) AND (("shipping_track"."id" not in (33827484, 33827484)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:16 Duration: 3s285ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4127005)) AND (("shipping_track"."id" not in (33826113, 33827524, 33827524)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:20 Duration: 2s844ms

3

7h40m47s

124,027

Details

176ms

1s83ms

222ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,318	4m17s	195ms
	01	1,556	5m6s	197ms
	02	1,918	6m22s	199ms
	03	1,577	5m9s	196ms
	04	1,239	4m1s	195ms
	05	2,683	8m51s	198ms
	06	4,550	15m6s	199ms
	07	611	2m	196ms
	08	1,411	4m38s	197ms
	09	7,857	26m57s	205ms
	10	7,164	25m57s	217ms
	11	3,786	13m29s	213ms
	12	3,302	11m35s	210ms
	13	6,211	21m56s	211ms
	14	8,086	28m49s	213ms
	15	4,697	16m3s	205ms
	16	5,771	21m9s	220ms
	17	5,020	17m3s	203ms
	18	2,166	8m38s	239ms
	19	31,715	2h18m19s	261ms
	20	4,821	17m30s	217ms
	21	9,302	32m52s	212ms
	22	7,266	24m50s	205ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9611754')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-01 19:01:02 Duration: 1s83ms
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" = '9611755')) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-01 19:01:15 Duration: 558ms

4

5h57m25s

42,624

Details

421ms

2s810ms

503ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 01	00	194	1m37s	503ms
	01	228	1m55s	504ms
	02	324	2m38s	487ms
	03	179	1m31s	509ms
	04	95	50s624ms	532ms
	05	98	52s47ms	531ms
	06	234	1m55s	494ms
	07	405	3m10s	470ms
	08	1,727	13m18s	462ms
	09	2,001	16m18s	488ms
	10	3,007	26m28s	528ms
	11	3,705	31m26s	509ms
	12	3,760	31m27s	501ms
	13	3,400	28m54s	510ms
	14	2,645	22m39s	513ms
	15	3,277	26m52s	492ms
	16	4,984	42m16s	508ms
	17	2,840	22m42s	479ms
	18	2,672	21m15s	477ms
	19	3,393	31m40s	560ms
	20	1,992	15m57s	480ms
	21	1,000	7m56s	476ms
	22	464	3m40s	474ms

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

Date: 2025-01-01 19:01:20 Duration: 2s810ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4087168)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:27 Duration: 2s782ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4087152)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:14 Duration: 2s618ms

5

3h5m2s

46,212

Details

93ms

838ms

240ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,940	6m54s	213ms
	01	1,758	6m7s	209ms
	02	958	4m10s	261ms
	03	310	1m25s	275ms
	04	1,904	7m37s	240ms
	06	728	2m56s	242ms
	07	792	2m39s	201ms
	08	146	32s800ms	224ms
	09	320	1m28s	276ms
	10	430	1m47s	249ms
	11	96	24s278ms	252ms
	12	292	1m8s	234ms
	13	848	3m33s	251ms
	14	1,481	5m28s	221ms
	15	988	3m33s	215ms
	16	3,143	13m20s	254ms
	17	3,259	12m29s	229ms
	18	5,897	22m59s	233ms
	19	5,967	26m29s	266ms
	20	6,995	28m45s	246ms
	21	4,882	19m32s	240ms
	22	3,078	11m36s	226ms

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

Date: 2025-01-01 20:12:14 Duration: 838ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-01 20:12:14 Duration: 837ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ايمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-01 18:58:04 Duration: 822ms

6

2h41m50s

9,916

Details

245ms

2s32ms

979ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 01	00	275	4m25s	964ms
	01	340	5m28s	966ms
	02	136	2m11s	967ms
	09	3	3s62ms	1s20ms
	10	35	36s862ms	1s53ms
	12	39	42s812ms	1s97ms
	13	231	4m3s	1s53ms
	14	366	6m6s	1s1ms
	15	315	5m12s	992ms
	16	756	12m59s	1s31ms
	17	562	9m31s	1s17ms
	18	1,796	27m45s	927ms
	19	1,024	17m15s	1s11ms
	20	1,889	31m32s	1s1ms
	21	1,000	15m55s	955ms
	22	1,149	17m59s	939ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9735515')) 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-01-01 19:33:43 Duration: 2s32ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9605490')) 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 (62))))))) 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 (62)))))) 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 (62)))))) 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 (62))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-01 19:46:22 Duration: 1s685ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9734918')) 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-01-01 19:33:49 Duration: 1s673ms

7

1h44m26s

306

Details

0ms

28m52s

20s479ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 01	00	4	2ms	0ms
	01	1	0ms	0ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	05	1	0ms	0ms
	06	1	1ms	1ms
	07	2	0ms	0ms
	08	15	6ms	0ms
	09	34	31ms	0ms
	10	24	9m45s	24s391ms
	11	18	5m55s	19s736ms
	12	22	32ms	1ms
	13	37	3m21s	5s436ms
	14	45	8m22s	11s157ms
	15	18	4m30s	15s33ms
	16	23	12m43s	33s180ms
	17	18	2m25s	8s72ms
	18	8	5ms	0ms
	19	12	10m2s	50s196ms
	20	13	35m44s	2m44s
	21	5	4ms	0ms
	22	3	11m37s	3m52s

UPDATE "res_users" SET "exp_date" = '2025-01-01 20:06:28.111742', "last_update" = '2025-01-01 19:21:28.111764', "sid" = '0e772e83c1d88a5e715d34199b70492f1a92f0f4', "write_date" = '2025-01-01 19:21:27.785938', "write_uid" = 1 WHERE id IN (857);

Date: 2025-01-01 20:50:20 Duration: 28m52s
UPDATE "res_users" SET "exp_date" = '2025-01-01 22:08:43.480564', "last_update" = '2025-01-01 21:23:43.480587', "sid" = 'bde618a98efdc49286bb388970c156b3d0fbae99', "write_date" = '2025-01-01 21:23:43.157182', "write_uid" = 901 WHERE id IN (901);

Date: 2025-01-01 22:35:20 Duration: 11m37s
UPDATE "res_users" SET "exp_date" = '2025-01-01 19:12:18.231175', "last_update" = '2025-01-01 18:27:18.231198', "sid" = '6bafd022851d9a9228b3a567b090774a41f28af8', "write_date" = '2025-01-01 18:27:17.899842', "write_uid" = 1 WHERE id IN (1387);

Date: 2025-01-01 19:37:20 Duration: 10m2s

8

1h33m21s

137,490

Details

30ms

150ms

40ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 01	00	3,234	2m5s	38ms
	01	3,186	2m1s	38ms
	02	2,332	1m30s	38ms
	03	1,808	1m9s	38ms
	04	1,855	1m11s	38ms
	05	1,119	42s945ms	38ms
	06	1,759	1m7s	38ms
	07	1,422	55s603ms	39ms
	08	2,439	1m34s	38ms
	09	6,539	4m17s	39ms
	10	14,106	9m56s	42ms
	11	10,658	7m18s	41ms
	12	11,733	7m54s	40ms
	13	10,341	7m2s	40ms
	14	8,741	5m59s	41ms
	15	7,975	5m19s	40ms
	16	10,108	7m1s	41ms
	17	7,181	4m45s	39ms
	18	7,260	4m47s	39ms
	19	9,088	6m57s	45ms
	20	6,913	4m37s	40ms
	21	5,145	3m25s	39ms
	22	2,548	1m39s	38ms

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

Date: 2025-01-01 19:01:14 Duration: 150ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4027856)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-01 19:51:25 Duration: 136ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4097242)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-01 19:00:24 Duration: 126ms

9

1h30m31s

19,785

Details

182ms

495ms

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
Jan 01	08	366	1m28s	242ms
	09	3,478	15m7s	261ms
	10	2,420	11m43s	290ms
	11	1,466	6m48s	278ms
	12	1,788	8m12s	275ms
	13	1,940	8m55s	276ms
	14	2,625	12m23s	283ms
	15	2,007	9m9s	273ms
	16	2,778	12m43s	274ms
	17	855	3m39s	256ms
	18	62	17s663ms	284ms

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

Date: 2025-01-01 10:26:03 Duration: 495ms
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" = '9544245')))) ORDER BY "collection_policy"."id";

Date: 2025-01-01 10:26:06 Duration: 488ms
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" = '9544196')))) ORDER BY "collection_policy"."id";

Date: 2025-01-01 10:26:07 Duration: 479ms

10

1h11m56s

13,497

Details

224ms

1s518ms

319ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 01	00	710	3m30s	296ms
	01	544	2m41s	297ms
	02	347	1m42s	295ms
	03	157	46s213ms	294ms
	04	961	4m41s	292ms
	06	366	1m47s	293ms
	07	400	1m54s	286ms
	08	75	21s967ms	292ms
	09	160	51s89ms	319ms
	10	187	1m5s	350ms
	11	49	16s875ms	344ms
	12	110	35s515ms	322ms
	13	204	1m8s	337ms
	14	422	2m17s	325ms
	15	186	1m	322ms
	16	833	4m34s	329ms
	17	1,085	5m41s	315ms
	18	1,179	6m11s	315ms
	19	1,983	11m57s	361ms
	20	1,650	8m51s	322ms
	21	1,476	7m51s	319ms
	22	413	2m6s	307ms

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

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

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

Date: 2025-01-01 19:00:30 Duration: 674ms

11

41m18s

24

Details

0ms

28m9s

1m43s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 01	08	1	0ms	0ms
	10	1	0ms	0ms
	12	1	0ms	0ms
	13	3	28m9s	9m23s
	14	6	5ms	0ms
	15	2	0ms	0ms
	16	6	13m9s	2m11s
	17	1	1ms	1ms
	18	1	0ms	0ms
	19	2	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-01 12:39:11.363002', "last_update" = '2025-01-01 11:54:11.363026', "write_date" = '2025-01-01 11:54:11.026151', "write_uid" = 1 WHERE id IN (886);

Date: 2025-01-01 13:22:21 Duration: 28m9s
UPDATE "res_users" SET "exp_date" = '2025-01-01 16:23:11.345554', "last_update" = '2025-01-01 15:38:11.345577', "write_date" = '2025-01-01 15:38:10.989479', "write_uid" = 1 WHERE id IN (1229);

Date: 2025-01-01 16:51:20 Duration: 13m9s
UPDATE "res_users" SET "exp_date" = '2025-01-01 13:19:39.470312', "last_update" = '2025-01-01 12:34:39.470339', "write_date" = '2025-01-01 12:34:39.117571', "write_uid" = 1 WHERE id IN (886);

Date: 2025-01-01 13:34:39 Duration: 1ms

12

37m42s

11,454

Details

178ms

238ms

197ms

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
Jan 01	00	930	3m2s	195ms
	01	1,273	4m10s	196ms
	02	1,892	6m16s	198ms
	03	1,506	4m55s	195ms
	04	1,174	3m49s	195ms
	05	2,148	7m5s	198ms
	06	2,419	8m2s	199ms
	07	84	16s414ms	195ms
	08	28	5s471ms	195ms

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

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

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

Date: 2025-01-01 02:44:35 Duration: 233ms

13

36m18s

45,346

Details

37ms

105ms

48ms

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

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1	51ms	51ms
	01	1	47ms	47ms
	02	28	1s318ms	47ms
	03	10	461ms	46ms
	05	50	2s311ms	46ms
	06	46	2s146ms	46ms
	07	46	2s161ms	46ms
	08	317	14s500ms	45ms
	09	5,257	4m2s	46ms
	10	5,636	4m36s	48ms
	11	3,337	2m42s	48ms
	12	2,636	2m5s	47ms
	13	5,202	4m8s	47ms
	14	7,811	6m14s	47ms
	15	4,363	3m26s	47ms
	16	5,787	4m49s	50ms
	17	1,893	1m27s	46ms
	18	1,367	1m2s	45ms
	19	770	41s742ms	54ms
	20	458	22s193ms	48ms
	21	259	12s741ms	49ms
	22	71	3s316ms	46ms

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

Date: 2025-01-01 19:02:13 Duration: 105ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4094401) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-01 19:47:03 Duration: 104ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3892899) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-01 19:01:00 Duration: 96ms

14

35m43s

10,350

Details

180ms

488ms

207ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 01	00	116	22s935ms	197ms
	01	155	30s614ms	197ms
	03	26	5s97ms	196ms
	04	65	12s692ms	195ms
	05	503	1m38s	196ms
	06	1,237	4m5s	198ms
	07	484	1m35s	197ms
	08	795	2m37s	198ms
	09	1,178	3m58s	202ms
	10	910	3m17s	217ms
	11	666	2m20s	211ms
	12	373	1m17s	209ms
	13	903	3m9s	210ms
	14	986	3m28s	211ms
	15	544	1m50s	203ms
	16	602	2m11s	218ms
	17	322	1m6s	206ms
	18	118	24s351ms	206ms
	19	163	46s505ms	285ms
	20	109	22s437ms	205ms
	21	95	19s919ms	209ms

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

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

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

Date: 2025-01-01 19:45:45 Duration: 382ms

15

33m8s

19,192

Details

83ms

233ms

103ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 01	01	2	223ms	111ms
	06	6	613ms	102ms
	07	41	4s238ms	103ms
	08	395	40s268ms	101ms
	09	1,554	2m35s	100ms
	10	846	1m31s	107ms
	11	2,258	3m54s	103ms
	12	1,785	3m4s	103ms
	13	2,496	4m19s	104ms
	14	2,456	4m11s	102ms
	15	1,645	2m47s	101ms
	16	1,720	3m4s	107ms
	17	1,593	2m39s	100ms
	18	892	1m27s	98ms
	19	807	1m34s	116ms
	20	535	56s156ms	104ms
	21	102	10s216ms	100ms
	22	59	5s868ms	99ms

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

Date: 2025-01-01 17:22:17 Duration: 233ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7921297)) AND (("cash_track"."id" not in (6489364)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-01 19:33:52 Duration: 210ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7919929)) AND (("cash_track"."id" not in (6479683)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-01 16:18:16 Duration: 198ms

16

18m51s

5,365

Details

182ms

292ms

210ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 01	02	7	1s408ms	201ms
	06	894	2m58s	200ms
	07	33	6s545ms	198ms
	08	223	44s35ms	197ms
	09	496	1m40s	202ms
	10	1,214	4m23s	216ms
	11	120	25s525ms	212ms
	12	170	36s889ms	216ms
	13	241	50s734ms	210ms
	14	505	1m51s	220ms
	15	31	6s614ms	213ms
	16	466	1m43s	222ms
	17	847	2m57s	209ms
	18	118	24s340ms	206ms

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

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

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

Date: 2025-01-01 10:03:24 Duration: 284ms

17

13m23s

3,023

Details

193ms

376ms

265ms

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" = ?) and ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))))) order by "collection_policy"."id";

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 01	09	282	1m11s	254ms
	10	231	59s849ms	259ms
	11	120	31s447ms	262ms
	12	170	45s636ms	268ms
	13	160	41s228ms	257ms
	14	484	2m14s	278ms
	15	5	1s277ms	255ms
	16	456	2m9s	284ms
	17	1,054	4m32s	258ms
	18	61	15s754ms	258ms

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

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

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

Date: 2025-01-01 16:19:35 Duration: 364ms

18

13m19s

293

Details

27ms

5s263ms

2s727ms

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
Jan 01	09	13	40s899ms	3s146ms
	10	2	8s218ms	4s109ms
	11	9	18s99ms	2s11ms
	12	22	49s107ms	2s232ms
	13	10	19s369ms	1s936ms
	14	31	40s616ms	1s310ms
	15	31	1m12s	2s342ms
	16	61	2m53s	2s837ms
	17	19	59s551ms	3s134ms
	18	22	1m10s	3s210ms
	19	21	1m28s	4s210ms
	20	26	1m29s	3s446ms
	21	18	55s992ms	3s110ms
	22	8	13s17ms	1s627ms

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

Date: 2025-01-01 19:00:38 Duration: 5s263ms
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 (66))))))) 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 (66)))))) 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 (66)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66)))))) 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 (66))))))))) 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 (66)))))))) AND ("policy_number"."name"::text ilike '%9624300%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-01 19:00:38 Duration: 5s157ms
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 (66))))))) 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 (66)))))) 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 (66)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66)))))) 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 (66))))))))) 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 (66)))))))) AND ("policy_number"."name"::text ilike '%962%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-01 19:00:36 Duration: 5s144ms

19

13m5s

5,474

Details

121ms

305ms

143ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 01	00	25	3s259ms	130ms
	01	31	4s79ms	131ms
	06	5	661ms	132ms
	08	32	4s178ms	130ms
	09	270	37s375ms	138ms
	10	1,122	2m45s	147ms
	11	881	2m4s	141ms
	12	994	2m20s	141ms
	13	698	1m40s	144ms
	14	337	49s587ms	147ms
	15	191	26s774ms	140ms
	16	224	32s803ms	146ms
	17	238	33s421ms	140ms
	18	142	19s490ms	137ms
	19	107	17s509ms	163ms
	20	132	18s653ms	141ms
	21	31	4s294ms	138ms
	22	14	1s883ms	134ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-01 10:34:09 Duration: 305ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-01 10:34:07 Duration: 303ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-01 19:51:32 Duration: 296ms

20

12m57s

17,654

Details

34ms

75ms

44ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 01	08	179	7s615ms	42ms
	09	2,098	1m28s	42ms
	10	2,384	1m46s	44ms
	11	1,449	1m4s	44ms
	12	1,228	53s548ms	43ms
	13	2,326	1m42s	44ms
	14	2,939	2m9s	43ms
	15	1,408	1m1s	43ms
	16	2,706	2m4s	45ms
	17	814	34s803ms	42ms
	18	123	5s149ms	41ms

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

Date: 2025-01-01 16:12:44 Duration: 75ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3937437) ORDER BY "collection_policy"."id";

Date: 2025-01-01 16:12:45 Duration: 65ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3937427) ORDER BY "collection_policy"."id";

Date: 2025-01-01 16:12:45 Duration: 65ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,400,011

Details

1m49s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 01	00	39,348	1s821ms	0ms
	01	40,748	1s944ms	0ms
	02	36,486	1s719ms	0ms
	03	33,439	1s459ms	0ms
	04	27,890	1s266ms	0ms
	05	33,222	1s525ms	0ms
	06	36,401	1s889ms	0ms
	07	29,974	1s346ms	0ms
	08	60,413	2s902ms	0ms
	09	128,672	6s3ms	0ms
	10	176,117	9s15ms	0ms
	11	203,308	9s27ms	0ms
	12	199,953	9s90ms	0ms
	13	218,659	10s599ms	0ms
	14	195,055	8s40ms	0ms
	15	204,122	8s139ms	0ms
	16	184,970	8s719ms	0ms
	17	133,512	5s434ms	0ms
	18	123,331	5s756ms	0ms
	19	108,822	5s352ms	0ms
	20	87,876	4s46ms	0ms
	21	62,890	2s591ms	0ms
	22	34,803	1s418ms	0ms

DISCARD ALL;

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

Date: 2025-01-01 18:58:53 Duration: 1ms
DISCARD ALL;

Date: 2025-01-01 13:32:50 Duration: 1ms

2

1,864,657

Details

26s838ms

0ms

16ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 01	00	27,575	449ms	0ms
	01	29,429	484ms	0ms
	02	26,519	433ms	0ms
	03	23,815	380ms	0ms
	04	19,382	325ms	0ms
	05	24,251	389ms	0ms
	06	28,073	483ms	0ms
	07	22,843	354ms	0ms
	08	47,637	720ms	0ms
	09	102,952	1s542ms	0ms
	10	142,743	2s191ms	0ms
	11	164,755	2s228ms	0ms
	12	158,192	2s217ms	0ms
	13	174,638	2s597ms	0ms
	14	151,211	2s110ms	0ms
	15	160,197	2s38ms	0ms
	16	143,228	2s122ms	0ms
	17	101,921	1s310ms	0ms
	18	93,638	1s259ms	0ms
	19	82,883	1s298ms	0ms
	20	67,092	923ms	0ms
	21	46,666	623ms	0ms
	22	25,017	352ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-01 13:58:00 Duration: 16ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-01 02:38:12 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-01 13:41:09 Duration: 1ms

3

1,222,711

Details

12s342ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 01	00	20,347	194ms	0ms
	01	20,964	197ms	0ms
	02	18,823	177ms	0ms
	03	17,322	157ms	0ms
	04	14,514	137ms	0ms
	05	17,210	158ms	0ms
	06	18,826	189ms	0ms
	07	15,607	143ms	0ms
	08	31,126	292ms	0ms
	09	65,579	659ms	0ms
	10	89,349	972ms	0ms
	11	102,916	1s63ms	0ms
	12	101,343	1s71ms	0ms
	13	111,231	1s136ms	0ms
	14	99,534	1s22ms	0ms
	15	103,502	1s18ms	0ms
	16	93,962	995ms	0ms
	17	67,711	640ms	0ms
	18	62,494	579ms	0ms
	19	55,421	633ms	0ms
	20	44,797	427ms	0ms
	21	32,210	309ms	0ms
	22	17,923	165ms	0ms

ROLLBACK;

Date: 2025-01-01 10:54:38 Duration: 0ms
ROLLBACK;

Date: 2025-01-01 08:57:36 Duration: 0ms
ROLLBACK;

Date: 2025-01-01 19:52:10 Duration: 0ms

4

1,208,275

Details

3m40s

0ms

15ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 01	00	19,692	3s640ms	0ms
	01	20,394	3s864ms	0ms
	02	18,231	3s328ms	0ms
	03	16,735	2s912ms	0ms
	04	13,903	2s496ms	0ms
	05	16,590	2s936ms	0ms
	06	18,233	3s647ms	0ms
	07	15,055	2s349ms	0ms
	08	30,575	5s355ms	0ms
	09	64,964	12s219ms	0ms
	10	88,914	17s613ms	0ms
	11	102,645	18s739ms	0ms
	12	100,866	19s35ms	0ms
	13	110,272	19s995ms	0ms
	14	97,804	17s976ms	0ms
	15	102,496	18s28ms	0ms
	16	93,444	18s200ms	0ms
	17	67,164	11s565ms	0ms
	18	62,179	9s979ms	0ms
	19	54,837	10s815ms	0ms
	20	44,252	7s804ms	0ms
	21	31,606	5s396ms	0ms
	22	17,424	2s919ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'f96e945ce68ad098216d182c099af0f75ea90001';

Date: 2025-01-01 11:49:07 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '3d933342648b9bfc8058595e82da57cdb58a0518';

Date: 2025-01-01 13:40:23 Duration: 14ms
SELECT payload FROM http_sessions WHERE sid = '4ca503d8a911d35cd663df7cb989a4602f6c61d2';

Date: 2025-01-01 11:36:55 Duration: 14ms

5

1,199,897

Details

1m48s

0ms

3ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 01	00	19,720	1s735ms	0ms
	01	20,448	1s812ms	0ms
	02	18,328	1s630ms	0ms
	03	16,807	1s419ms	0ms
	04	14,030	1s218ms	0ms
	05	16,683	1s430ms	0ms
	06	18,273	1s716ms	0ms
	07	15,070	1s263ms	0ms
	08	30,206	2s551ms	0ms
	09	64,273	5s708ms	0ms
	10	88,021	8s536ms	0ms
	11	101,619	9s291ms	0ms
	12	99,949	9s331ms	0ms
	13	109,220	9s792ms	0ms
	14	97,265	8s777ms	0ms
	15	101,951	8s934ms	0ms
	16	92,376	8s729ms	0ms
	17	66,687	5s808ms	0ms
	18	61,714	5s269ms	0ms
	19	54,399	5s491ms	0ms
	20	43,951	3s840ms	0ms
	21	31,469	2s806ms	0ms
	22	17,438	1s514ms	0ms

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

Date: 2025-01-01 19:00:02 Duration: 3ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

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

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

6

832,142

Details

2m

0ms

10ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 01	00	8,750	1s457ms	0ms
	01	10,445	1s707ms	0ms
	02	9,234	1s515ms	0ms
	03	7,753	1s323ms	0ms
	04	5,566	1s27ms	0ms
	05	8,092	1s359ms	0ms
	06	11,075	1s842ms	0ms
	07	8,739	1s401ms	0ms
	08	21,077	2s993ms	0ms
	09	48,775	6s983ms	0ms
	10	70,772	10s382ms	0ms
	11	82,411	11s208ms	0ms
	12	77,156	10s365ms	0ms
	13	85,189	13s397ms	0ms
	14	66,301	9s546ms	0ms
	15	73,931	9s441ms	0ms
	16	63,275	9s262ms	0ms
	17	43,491	5s973ms	0ms
	18	40,566	5s725ms	0ms
	19	35,034	5s774ms	0ms
	20	28,167	4s81ms	0ms
	21	17,684	2s559ms	0ms
	22	8,659	1s416ms	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 (996);

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

Date: 2025-01-01 17:21:55 Duration: 9ms
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 (1026);

Date: 2025-01-01 17:21:55 Duration: 9ms

7

640,513

Details

1m51s

0ms

36ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 01	00	7,226	1s438ms	0ms
	01	8,469	1s692ms	0ms
	02	7,695	1s425ms	0ms
	03	6,494	1s276ms	0ms
	04	4,869	988ms	0ms
	05	7,039	1s133ms	0ms
	06	9,246	1s584ms	0ms
	07	7,239	1s130ms	0ms
	08	16,463	2s631ms	0ms
	09	37,347	5s863ms	0ms
	10	53,313	9s377ms	0ms
	11	61,761	10s267ms	0ms
	12	56,779	9s930ms	0ms
	13	63,300	10s677ms	0ms
	14	51,309	8s876ms	0ms
	15	56,479	9s25ms	0ms
	16	49,181	8s520ms	0ms
	17	34,081	6s6ms	0ms
	18	31,129	5s512ms	0ms
	19	27,409	5s903ms	0ms
	20	22,214	4s104ms	0ms
	21	14,403	2s937ms	0ms
	22	7,068	1s585ms	0ms

COMMIT;

Date: 2025-01-01 19:47:35 Duration: 36ms
COMMIT;

Date: 2025-01-01 20:10:35 Duration: 34ms
COMMIT;

Date: 2025-01-01 13:43:02 Duration: 32ms

8

504,270

Details

1m6s

0ms

16ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 01	00	5,796	679ms	0ms
	01	7,138	875ms	0ms
	02	4,975	599ms	0ms
	03	4,244	515ms	0ms
	04	3,418	407ms	0ms
	05	3,197	467ms	0ms
	06	5,710	735ms	0ms
	07	4,391	514ms	0ms
	08	11,792	1s428ms	0ms
	09	29,541	3s980ms	0ms
	10	42,320	6s89ms	0ms
	11	51,208	6s976ms	0ms
	12	47,457	7s22ms	0ms
	13	51,873	7s86ms	0ms
	14	35,706	5s162ms	0ms
	15	43,050	5s353ms	0ms
	16	38,256	4s812ms	0ms
	17	25,947	3s221ms	0ms
	18	27,367	3s85ms	0ms
	19	23,712	3s468ms	0ms
	20	19,554	2s444ms	0ms
	21	11,836	1s373ms	0ms
	22	5,782	656ms	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 (5099010, 5099006, 5099009, 5101461, 5110180, 5122457, 5099119);

Date: 2025-01-01 12:13:32 Duration: 16ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5100018, 5099009, 5136898, 5158101, 5108013, 5117249, 5099028, 5099403, 5099813, 5099006, 5460381, 5099045, 5099007, 5098989, 5099540, 5105614, 5099013, 5099387, 5459890, 5103068, 5099873, 5101298, 5100431, 5099309, 5099141, 5099254, 5099202, 5203505, 5099111, 5459618, 5099206, 5114720, 5127932, 5099885, 5099192, 5099600, 5112160, 5162009, 5167669, 5125401, 5103648, 5099035, 5099727, 5099577, 5099169, 5098996, 5099138);

Date: 2025-01-01 17:21:55 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5311642, 5113931, 5321548, 5099013, 5234120, 5182321, 5099005, 5291817, 5193920, 5112860, 5316776, 5359668, 5234790, 5210147, 5106122, 5099007, 5099533, 5417508, 5337614, 5099009, 5115849, 5099392, 5266065, 5417503, 5417504, 5099024, 5118711, 5099102, 5253395, 5149370, 5171438, 5106822, 5099712, 5103217, 5120051, 5203701, 5176426, 5101982, 5099254, 5106396);

Date: 2025-01-01 13:36:55 Duration: 6ms

9

503,957

Details

32s937ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 01	00	4,660	273ms	0ms
	01	5,491	321ms	0ms
	02	4,203	241ms	0ms
	03	3,490	204ms	0ms
	04	2,036	121ms	0ms
	05	2,851	165ms	0ms
	06	5,963	335ms	0ms
	07	5,541	317ms	0ms
	08	12,829	701ms	0ms
	09	27,193	1s711ms	0ms
	10	40,078	2s925ms	0ms
	11	50,233	3s348ms	0ms
	12	46,588	3s231ms	0ms
	13	50,023	3s460ms	0ms
	14	38,672	2s811ms	0ms
	15	46,102	2s709ms	0ms
	16	41,755	2s616ms	0ms
	17	27,688	1s642ms	0ms
	18	26,875	1s618ms	0ms
	19	24,365	1s925ms	0ms
	20	19,188	1s149ms	0ms
	21	12,494	771ms	0ms
	22	5,639	331ms	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 (28, 78, 102, 16, 65, 126, 19, 119, 6, 35, 5, 8, 7, 1, 36, 71, 17, 111);

Date: 2025-01-01 16:18:16 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 (74, 11, 61, 26, 119, 60, 14, 17, 68, 41, 62);

Date: 2025-01-01 01:09:09 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 (123);

Date: 2025-01-01 16:18:16 Duration: 1ms

10

377,891

Details

2m3s

0ms

3ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 01	00	2,875	894ms	0ms
	01	2,266	719ms	0ms
	02	1,447	466ms	0ms
	03	978	318ms	0ms
	04	801	262ms	0ms
	05	961	322ms	0ms
	06	1,694	573ms	0ms
	07	1,421	425ms	0ms
	08	6,734	2s25ms	0ms
	09	18,894	6s62ms	0ms
	10	24,704	8s560ms	0ms
	11	39,970	12s952ms	0ms
	12	36,785	12s265ms	0ms
	13	37,960	12s619ms	0ms
	14	40,200	13s171ms	0ms
	15	37,773	11s859ms	0ms
	16	31,943	10s672ms	0ms
	17	25,940	8s118ms	0ms
	18	18,931	5s935ms	0ms
	19	17,590	6s491ms	0ms
	20	13,057	4s13ms	0ms
	21	10,656	3s164ms	0ms
	22	4,311	1s308ms	0ms

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 = 959) OR r.global) ORDER BY r.id;

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

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

Date: 2025-01-01 19:33:02 Duration: 1ms

11

347,507

Details

1m4s

0ms

12ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 01	00	3,030	539ms	0ms
	01	3,393	606ms	0ms
	02	3,051	519ms	0ms
	03	2,079	388ms	0ms
	04	1,302	251ms	0ms
	05	2,122	362ms	0ms
	06	3,314	598ms	0ms
	07	3,386	575ms	0ms
	08	9,945	1s533ms	0ms
	09	19,689	3s423ms	0ms
	10	31,661	5s886ms	0ms
	11	34,524	6s438ms	0ms
	12	33,320	6s52ms	0ms
	13	36,576	6s817ms	0ms
	14	28,431	5s589ms	0ms
	15	32,190	5s827ms	0ms
	16	27,230	5s211ms	0ms
	17	18,645	3s493ms	0ms
	18	16,502	2s920ms	0ms
	19	14,389	3s251ms	0ms
	20	12,132	2s250ms	0ms
	21	7,093	1s343ms	0ms
	22	3,503	665ms	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 (8006335);

Date: 2025-01-01 17:21:55 Duration: 12ms
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 (8006288);

Date: 2025-01-01 17:21:55 Duration: 12ms
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 (8004725);

Date: 2025-01-01 17:21:55 Duration: 12ms

12

285,684

Details

50s271ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 01	00	2,490	366ms	0ms
	01	2,212	305ms	0ms
	02	1,708	227ms	0ms
	03	1,432	184ms	0ms
	04	928	118ms	0ms
	05	1,445	189ms	0ms
	06	1,710	239ms	0ms
	07	1,254	170ms	0ms
	08	6,841	982ms	0ms
	09	15,513	2s555ms	0ms
	10	20,634	3s675ms	0ms
	11	27,373	4s979ms	0ms
	12	25,137	4s691ms	0ms
	13	27,343	4s953ms	0ms
	14	32,886	5s979ms	0ms
	15	27,352	4s728ms	0ms
	16	23,304	4s295ms	0ms
	17	19,107	3s293ms	0ms
	18	13,150	2s201ms	0ms
	19	12,482	2s643ms	0ms
	20	10,014	1s662ms	0ms
	21	8,032	1s305ms	0ms
	22	3,337	522ms	0ms

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

Date: 2025-01-01 10:16:31 Duration: 2ms
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-01-01 14:20:26 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-01-01 14:36:21 Duration: 1ms

13

238,274

Details

1d8h29m56s

415ms

3s858ms

491ms

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
Jan 01	00	6,834	53m16s	467ms
	01	7,351	57m	465ms
	02	6,393	49m6s	460ms
	03	5,164	39m25s	458ms
	04	5,560	43m30s	469ms
	05	5,181	39m18s	455ms
	06	6,924	53m11s	460ms
	07	2,625	20m21s	465ms
	08	5,699	43m22s	456ms
	09	8,654	1h7m57s	471ms
	10	19,013	2h41m15s	508ms
	11	14,128	1h55m55s	492ms
	12	14,141	1h54m32s	485ms
	13	12,611	1h43m47s	493ms
	14	10,322	1h26m9s	500ms
	15	9,698	1h18m1s	482ms
	16	13,844	1h57m40s	509ms
	17	9,647	1h18m11s	486ms
	18	11,697	1h34m58s	487ms
	19	23,311	3h33m46s	550ms
	20	18,884	2h34m41s	491ms
	21	11,646	1h34m21s	486ms
	22	8,947	1h10m6s	470ms

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

Date: 2025-01-01 19:45:36 Duration: 3s858ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4127264)) AND (("shipping_track"."id" not in (33827484, 33827484)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:16 Duration: 3s285ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4127005)) AND (("shipping_track"."id" not in (33826113, 33827524, 33827524)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:20 Duration: 2s844ms

14

228,087

Details

57s270ms

0ms

25ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 01	00	2,684	685ms	0ms
	01	3,059	812ms	0ms
	02	2,136	564ms	0ms
	03	1,623	457ms	0ms
	04	1,804	496ms	0ms
	05	1,151	403ms	0ms
	06	2,411	684ms	0ms
	07	2,035	525ms	0ms
	08	4,744	1s202ms	0ms
	09	11,754	3s252ms	0ms
	10	17,034	4s668ms	0ms
	11	21,480	5s499ms	0ms
	12	20,254	5s262ms	0ms
	13	23,208	5s640ms	0ms
	14	17,292	4s242ms	0ms
	15	19,608	4s408ms	0ms
	16	18,080	4s234ms	0ms
	17	12,980	2s940ms	0ms
	18	13,265	2s916ms	0ms
	19	11,791	3s414ms	0ms
	20	10,279	2s633ms	0ms
	21	6,164	1s532ms	0ms
	22	3,251	793ms	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 (39380928, 39708446, 39791219, 40165473, 40124470, 39408273, 39610037, 39685198, 40236035, 39804666, 40160073, 40012069, 32564497, 40411500, 39872192, 39934337, 40368211, 38557939, 41549902, 39828630, 40096971, 40162308, 40047367, 39750173, 41846502, 39486029, 40375101, 40024838, 40495409, 41885101, 40888130, 40262080, 39956386, 32606003, 39671340, 39858610, 41611605, 41936345, 39810747, 39514016, 41481291, 40012091, 40122836, 40274484, 41806405, 40014887, 39637884, 41790205, 39892167, 32610792, 40020587, 40446504, 41804788, 41622458, 41887184, 40272802, 39541453, 40087497, 40343934, 40063510, 40062872, 41582359, 41925841, 40383016, 40046949, 39485584, 39410625, 41764938, 39847214, 32590249, 40012057, 40040885, 41817125, 40137227, 39748243, 40423542, 40426117, 40113058, 40228254, 39941590, 39480895, 40427949, 40673596, 39379180, 39878822, 40240231, 41612588, 40278407, 41805851, 40888014, 39878823, 41913633, 41856798, 41815231, 39499768, 41815201, 40035266, 40419605, 39687781, 40358996);

Date: 2025-01-01 19:37:24 Duration: 25ms
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 (41575832, 41770459, 41770472, 41770185, 41576195, 41576198, 41576201, 41770182, 41576231, 41576215, 41770179, 41576208, 41576217, 41576221, 41576225, 41576233, 41576199, 41576196, 41576203, 41770187, 41576207, 41770191, 41770190, 41770180, 41770184, 41576204, 41576192, 41576214, 41576219, 41576232, 41576216, 41576205, 41576206, 41576220, 41576230, 41576224, 41576209, 41575786, 41575785, 41770525, 41769866, 41575839, 41770620, 41455582, 41455591, 41770464, 41576676, 41524829, 41770531, 41575800, 41575831, 41524179, 41576051, 41524828, 41770175, 41576546, 41524410, 41770633, 41770634, 41770631, 41454471, 41454478, 41770619, 41770635, 41770623, 41524186, 41576244, 41524181, 41576019, 41576701, 41455584, 41455576, 41576017, 41455574, 41575918, 41770458, 41770468, 40757525, 41575915, 41524827, 41770451, 41770489, 41575644, 41575803, 41575834, 41575788, 41575837, 41575646, 41577659, 41770482, 41770450, 41770452, 41578345, 41770473, 41770480, 41770487, 41770485, 41770477, 41770484, 41770488, 41770474, 41770449, 41770529, 41770239, 41770235, 41576050, 41575856, 41575858, 41577567, 41576044, 41576421, 41576678, 41770457, 41576677, 41455583, 41576694, 41576699, 41455581, 41576018, 41455587, 41576020, 41576702, 41455586, 41576013, 41455568, 41455588, 41576696, 41576014, 41576698, 41455573, 41575921, 41770632, 41216351, 41524188, 41524184, 41770626, 41770624, 41770639, 41770629, 41524190, 41770625, 41524191, 41770630, 41524180, 41770636, 41576246, 41770628, 41576242, 41577096, 41577063, 41577061, 41575833, 41454474, 41454473, 41770532, 41576542, 41576545, 41769859, 41769862, 41769858, 41576466, 41576046, 41575823, 41575796, 41575829, 41575813, 41575647, 41577664, 41577657, 41770479, 41770475, 41770483, 41770470, 41575784, 41575789, 41575828, 41575801, 41575795, 41575645, 41575783, 41577661, 41577660, 41578344, 41770490, 41770460, 41770481, 41770486, 41770476, 41770471, 41216090, 41575804, 41770042, 41524409, 41576467, 41575825, 41575840, 41577060, 41575812, 41454470, 41454469, 41576544, 41576543, 41769854, 41769856, 41769860, 41575806, 41576465, 41769861, 41576700, 38379839, 39033761, 41770448, 41770240, 41575919, 40757524, 41575916, 41576049, 41576418, 41576419, 41575866, 41575863, 41575861, 41575857, 41575853, 41575860, 41770236, 41770446, 41455590, 41455569, 41455579, 41576692, 41576022, 41576695, 41455572, 41576021, 41454477, 41770640, 41770638, 41576243, 41524182, 41524189, 41524185, 41576045, 41575797, 41524811, 41524810, 41575852, 41575864, 41575914, 41577564, 41576417, 41575917, 41576679, 41770466, 41575920, 41454622, 41770169, 41770616, 41770621, 41524183, 41770641, 41576015, 41455578, 41576693, 41576016, 40961120, 41576011, 41770637, 41576247, 41576012, 41576675, 41576697, 41215172, 41455575, 41576010, 41576009, 41455571, 41577566, 41576680, 41576422, 41576048, 41576047, 41770167, 41577565, 41575865, 41575854, 41575862, 41770241, 41770238, 41575913, 41770237, 41770462, 41770627, 41454472, 41575835, 41575808, 41575827, 41575814, 41577059, 41577062, 41577097, 41769869, 41769864, 41769865, 41769857, 41575802, 41770527, 41770528, 41770530, 41770524, 41575809, 41770526, 41576548, 41576549, 41576547, 41770442, 41770478, 41770392, 41770491, 41575830, 41575807, 41575822, 41575643, 41575642, 41577662, 41577665, 41577658, 41577663, 41577656, 41577655, 41769863, 41769867, 41769868, 41769855, 41575841, 41575826, 41577095, 41575811, 41575838, 41576245, 41524187, 41770617, 41770618, 41454476, 41770622, 41455577, 41455589, 41455585, 41455580, 41455570, 41770461, 41770467, 41576423, 41576043, 41575859, 41575851, 41575848, 41575869, 41575868, 41770443, 41770168, 41524686);

Date: 2025-01-01 20:57:40 Duration: 19ms
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 (41955792, 41913105, 41803058, 41700093, 41846560, 41657795, 41854961, 41932924, 41917949, 40887502, 41575725, 41298483, 41761769, 41761775, 41761778, 41891068, 41732718, 41907347, 41599551, 41766790, 41786141, 41871854, 41736449, 41837346, 41891355, 41783989, 41889679, 41890743, 41873993, 41777806, 41724324, 32644924, 41820916, 41820927, 41785531, 41778475, 41746281, 41819538, 41834128, 41863850, 41786871, 41742663, 41831972, 41822144, 41822017, 41676109, 41839285, 41675156, 41938808, 41516737, 41709908, 41713178, 41778460, 41604255, 41905393, 41621408, 41776765);

Date: 2025-01-01 17:21:55 Duration: 14ms

15

174,365

Details

13s646ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,661	133ms	0ms
	01	2,141	183ms	0ms
	02	1,618	139ms	0ms
	03	1,449	123ms	0ms
	04	840	78ms	0ms
	05	1,146	100ms	0ms
	06	1,959	184ms	0ms
	07	1,475	113ms	0ms
	08	3,985	290ms	0ms
	09	10,463	959ms	0ms
	10	15,075	1s302ms	0ms
	11	18,407	1s107ms	0ms
	12	17,329	1s119ms	0ms
	13	19,151	1s362ms	0ms
	14	12,848	1s90ms	0ms
	15	15,780	1s176ms	0ms
	16	13,329	1s169ms	0ms
	17	8,868	785ms	0ms
	18	8,713	574ms	0ms
	19	7,485	749ms	0ms
	20	5,743	471ms	0ms
	21	3,346	296ms	0ms
	22	1,554	134ms	0ms

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

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

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

Date: 2025-01-01 17:21:55 Duration: 1ms

16

165,780

Details

9s581ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,244	63ms	0ms
	01	935	48ms	0ms
	02	553	27ms	0ms
	03	389	19ms	0ms
	04	293	14ms	0ms
	05	406	21ms	0ms
	06	651	36ms	0ms
	07	596	30ms	0ms
	08	3,056	156ms	0ms
	09	8,173	449ms	0ms
	10	10,377	635ms	0ms
	11	17,342	1s2ms	0ms
	12	16,075	961ms	0ms
	13	16,412	959ms	0ms
	14	18,062	1s70ms	0ms
	15	16,952	942ms	0ms
	16	14,197	845ms	0ms
	17	11,682	649ms	0ms
	18	8,417	459ms	0ms
	19	7,672	525ms	0ms
	20	5,620	306ms	0ms
	21	4,743	253ms	0ms
	22	1,933	102ms	0ms

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

Date: 2025-01-01 13:14:43 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (99);

Date: 2025-01-01 19:06:36 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (89);

Date: 2025-01-01 16:57:56 Duration: 0ms

17

160,677

Details

19s557ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,226	132ms	0ms
	01	932	100ms	0ms
	02	549	58ms	0ms
	03	388	41ms	0ms
	04	293	30ms	0ms
	05	393	43ms	0ms
	06	642	73ms	0ms
	07	592	63ms	0ms
	08	2,978	319ms	0ms
	09	8,026	922ms	0ms
	10	10,149	1s317ms	0ms
	11	16,949	2s60ms	0ms
	12	15,742	1s985ms	0ms
	13	15,979	1s967ms	0ms
	14	17,447	2s170ms	0ms
	15	16,482	1s906ms	0ms
	16	13,665	1s715ms	0ms
	17	11,199	1s302ms	0ms
	18	8,032	931ms	0ms
	19	7,403	1s100ms	0ms
	20	5,244	603ms	0ms
	21	4,446	496ms	0ms
	22	1,921	213ms	0ms

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

Date: 2025-01-01 20:53:40 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-01 19:06:36 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-01 12:02:36 Duration: 0ms

18

151,679

Details

1m26s

0ms

18ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 01	00	422	222ms	0ms
	01	291	164ms	0ms
	02	384	189ms	0ms
	03	168	93ms	0ms
	04	106	68ms	0ms
	05	131	82ms	0ms
	06	522	221ms	0ms
	07	603	213ms	0ms
	08	1,556	780ms	0ms
	09	6,623	3s866ms	0ms
	10	8,965	6s48ms	0ms
	11	9,625	5s815ms	0ms
	12	10,519	7s925ms	0ms
	13	11,807	8s131ms	0ms
	14	10,185	6s327ms	0ms
	15	9,435	5s338ms	0ms
	16	8,920	4s832ms	0ms
	17	6,067	3s307ms	0ms
	18	4,485	2s497ms	0ms
	19	28,944	15s231ms	0ms
	20	13,648	6s297ms	0ms
	21	9,595	4s507ms	0ms
	22	8,678	3s915ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3864678, 4023742, 3978967, 4007356, 4023594, 3869800, 4023754, 3995258, 3901641, 3965942, 4023751, 3994725, 3933812, 3978957, 3965926, 4023760, 4024879, 3721386, 3946394, 3994722, 3978820, 3994757, 3978669, 3978816, 4006297, 3995256, 3965920, 3978659, 3759013, 3980605, 3696846, 3869803, 3848082, 3978865, 3978841, 3854714, 3965928, 3965932, 3970740, 3970747, 3864756, 3946320, 3911586, 3970765, 3908753, 3978881, 3908673, 3965930, 3936231, 3978842, 3978963, 3978953, 3911886, 3965916, 3978849, 3970811, 3978813, 3978763, 3978981, 3970816, 3901368, 4006225, 3965910, 3994721, 3946395, 3864771, 3901289, 1676950, 3901628, 3979001, 3970733, 3908766, 3746610, 3908646, 3978746, 3934246, 3965940, 3759004, 3908832, 3901147, 3970760, 3590420, 3793771, 3721310, 3759023, 3848255, 3848243, 3590415, 3848008, 3869712, 3596286, 3935150, 3864687, 3867534, 3933905, 3901923, 3901891, 3848013, 3877663, 3869797, 3908664, 3848001, 3908677, 3908651, 3869721, 3869784, 3901647, 3362504, 3060875, 3908669, 3908830, 3760839, 3908681, 3908833, 3848084, 3908828, 3908659, 3908761, 3848030, 3848044, 3848303, 3869709, 3869719, 3908656, 3901781, 3657847, 3901320, 3696831, 3812910, 3721359, 3869792, 3879984, 3848033, 3812925, 3848034, 3848150, 3812958, 3848262, 3848041, 3721367, 3869716, 3864758, 3864782, 3848238, 3812930, 3362506, 3696858, 3812956, 3729456, 3812942, 3812960, 3812944, 3812919, 3848009, 3590426, 3696855, 3812912, 3812937, 3812934, 3848086, 3812939, 3848258, 3848248, 3848011, 3696856, 3848046, 3848240, 3848245, 3812920, 3848260, 3848250, 3848010, 3848036, 3793837, 3848157, 3746617, 3848038, 3760845, 3848265, 3059111, 3793841, 3799199, 3793826, 3700906, 3755224, 3793823, 3760842, 3793839, 3755216, 3760836, 3760844, 3760838, 3760843, 3760846, 3760837, 3759082, 3093872, 3760841, 3759079, 3625335, 3700903, 3760847, 3760835, 3700897, 3700904, 3625332, 3700901, 3700905, 3505442, 3700898, 3700899, 3700900, 3505439, 3625324, 3541721, 3492063, 3625315, 3625347, 3625337, 3625340, 3625350, 3399641, 3399633, 3625345, 3625342, 3625326, 3625318, 3625329, 3541730, 3505438, 3541733, 3505440, 3399610, 3431908, 3431905, 3431903, 3505437, 3541727, 3431910, 3399646, 3505441, 3399652, 3431920, 3399644, 3431915, 3431912, 3399613, 3399624, 3431923, 3399615, 3399649, 3403368, 3431918, 3399638, 3399657, 3399628, 3399654, 3399631, 3399622, 3399618, 3399635, 3399655, 3200902, 3200904);

Date: 2025-01-01 12:56:08 Duration: 18ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (945178, 3328722, 3695837, 4093265, 2203920, 298367, 824631, 1394026, 3572258, 2433950, 1161289, 1915901, 1938553, 2105369, 2386287, 3407674, 3407676, 50761, 636026, 1164971, 1779036, 345198, 479789, 3851237, 3661344, 3915384, 3975497, 4003415, 2711753, 2310355, 259487, 2055956, 1098560, 1737085, 1850100, 2087621, 1063816, 2106785, 1453757, 1865165, 2279012, 2174453, 1737203, 2528143, 1714691, 1714680, 1714695, 1714681, 1714692, 1714686, 1714689, 1714693, 1714684, 1714696, 1714694, 1714698, 1714687, 1714682, 1714697, 1714683, 1714690, 1714685, 1714688, 1735938, 64813, 2192240, 1844382, 3976916, 741476, 2947961, 3394691, 650750, 1167075, 1571498, 2626827, 2915163, 542890, 131698, 68335, 1339122, 651361, 1686394, 1686393, 1686388, 1468448, 1468565, 1468543, 1468538, 1468512, 1468476, 1468532, 1468590, 1468550, 1466868, 1686384, 1468575, 1468587, 1468482, 1468583, 1468559, 1468455, 1468592, 1468522, 1468557, 1686387, 1466873, 1686386, 1468570, 1466864, 1686385, 1686389, 3211732, 1468518, 1686395, 3826941, 1468470, 3826944, 3856407, 1468497, 1686382, 2468965, 2468967, 1468527, 1686383, 2468963, 1686392, 2468968, 1468487, 1468462, 2468964, 4035994, 3267712, 1385239, 1262331, 1272462, 4014238);

Date: 2025-01-01 09:44:17 Duration: 17ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3989740, 3957451, 3786979, 3854047, 3665728, 3477559, 3989601, 3320279, 3666463, 3704107, 3820116, 4001909, 3735933, 3704180, 2903074, 3880905, 3988802, 3782549, 3776657, 3886554, 3874883, 3565032, 3699589, 3887069, 3987686, 3477997, 3854797, 3703754, 3703466, 3780252, 3922483, 3988955, 3886516, 3667472, 3918726, 2903064, 3919669, 3918626, 4000679, 3818948, 3764893, 3946118, 3886884, 4026233, 4001341, 3920554, 3981978, 4027566, 3665680, 4001324, 3517525, 3517546, 3666315, 3922182, 3738270, 3952217, 3855484, 3854851, 3952216, 3785453, 3952215, 3922160, 3957150, 3886696, 4035482, 3771103, 4034597, 4034594, 4002907, 3767008, 4052571, 3918659, 4029429, 4003372, 3852051, 4031787, 3285144, 4033284, 3918389, 4035670, 3669270, 3372532, 3734027, 3945950, 3919765, 4030979, 4051064, 4001442, 3901903, 4057302, 4057301, 3595863, 3982608, 3784453, 3883466, 3783526, 4032468, 3564680, 3767327, 3916532, 3667244, 3735810, 4002064, 3987713, 3735849, 3854698, 3985502, 4002838, 3754502, 3988984, 3825195, 3730470, 3728744, 3703859, 3734765, 3697618, 3810477, 3782643, 3760886, 3783559, 3767291, 3768327, 3737164, 3777947, 3735319, 3735325, 3768830, 3767491, 3781532, 3820969, 3767903, 3884936, 3886941, 3885226, 3669326, 3874881, 3855469, 3921912, 3921910, 3921917, 3921909, 3854778, 3874878, 3952211, 3921905, 3921789, 3874882, 3946089, 3957148, 3985697, 3952212, 3989718, 3988954, 3402186, 3989038, 4002071, 3989064, 3985544, 3986418, 3957404, 4002805, 3957499, 3957415, 3951969, 3854841, 3769896, 3952207, 3559035, 4001345, 3986656, 3988537, 3984900, 4000999, 3980997, 3920870, 3854191, 3954553, 3980693, 3441189, 3999704, 3989737, 3952208, 3818433, 4030790, 3988935, 3922485, 4030832, 4027588, 3988959, 3920552, 3988953, 3954397, 3916995, 3874893, 4033766, 3819866, 3885221, 3887981, 4002883, 4002181, 3821356, 3957414, 4002841, 4035452, 3785240, 3854896, 3785229, 3887945, 3949994, 3776667, 3776664, 3953694, 3953685, 3953742, 3953799, 3830684, 3648443, 3736449, 3987511, 3825944, 3919774, 3922503, 3957417, 3844925, 3951965, 3601422, 3919349, 3735761, 3966035, 3871248, 3985545, 3765107, 3854288, 3667943, 4059694, 3987890, 4000727, 3919775, 3822745, 3985535, 3517547, 4057299, 3986808, 3914810, 4033940, 3988310, 4001925, 3668232, 4035471, 3989862, 3988339, 4065187, 3516200, 3551009, 3567167, 3986424, 4001648, 4025421, 3548875, 3989632, 3550184, 3953240, 3363367, 3702677, 3955361, 3702778, 2963080, 3592808, 3566090, 3697612, 3805984, 3782916, 3821306, 4074609, 3984888, 3955103, 3986845, 3889272, 4029490, 3985547, 3981954, 3888037, 3667296, 3883510, 3825893, 3548371, 3850820, 3887612, 3821016, 3874905, 2392170, 3986453, 3920482, 3853897, 3852085, 3919969, 3769871, 3986747, 4016337, 3773954, 3986054, 3868081, 3899308, 3920043, 3471131, 3736934, 3995134, 3899305, 3918306, 3919589, 4000730, 4001785, 3783450, 3986423, 4026255, 4027421, 3989595, 3987501, 3989173, 3822590, 4032578, 4032742, 3669234, 3661741, 3664264, 3854078, 3598405, 3887362, 3985527, 3730545, 3957145, 4031997, 3987762, 3957412, 4014182, 3971779, 3874899, 3826813, 4031999, 4001653, 3735179, 3986669, 3874903, 4002772, 3988987, 3989893, 3820111, 3887974, 3490467, 3971657, 3819378, 3843583, 3813110, 3843577, 3986496, 3910960, 3989081, 3391886, 4027377, 4059254, 3551541, 3704767, 3850805, 3372535, 3565960, 3984625, 3952220, 3551011, 3955492, 3919593, 3911160, 3769986, 3766702, 3370952, 3732417, 3730458, 3112293, 3666602, 3951924, 3953253, 3767816, 4029662, 3882001, 3886449, 3886945, 3849573, 3600308, 3667634, 3778927, 3911769, 4035445, 3517571, 3883756, 3566024, 3986863, 3920226, 3918608, 3474258, 4002022, 3515813, 3815058, 3951939, 3853628, 3854302, 3954488, 4032165, 3990111, 3734603, 3952447, 3625997, 3735928, 4001005, 3987757, 3883578, 3521550, 3703607, 3919740, 3769980, 3764892, 3402401, 3853074, 4035654, 3669833, 3952219, 3921156, 3613987, 3854798, 3854807);

Date: 2025-01-01 12:20:57 Duration: 16ms

19

140,416

Details

28s760ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,078	201ms	0ms
	01	837	157ms	0ms
	02	560	105ms	0ms
	03	396	73ms	0ms
	04	293	55ms	0ms
	05	423	80ms	0ms
	06	640	127ms	0ms
	07	568	107ms	0ms
	08	2,660	496ms	0ms
	09	7,304	1s430ms	0ms
	10	9,541	2s48ms	0ms
	11	14,763	2s975ms	0ms
	12	13,712	2s850ms	0ms
	13	13,815	2s870ms	0ms
	14	15,021	3s124ms	0ms
	15	14,486	2s875ms	0ms
	16	11,780	2s483ms	0ms
	17	9,585	1s917ms	0ms
	18	6,754	1s355ms	0ms
	19	6,484	1s536ms	0ms
	20	4,474	887ms	0ms
	21	3,666	696ms	0ms
	22	1,576	302ms	0ms

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

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

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

Date: 2025-01-01 17:21:55 Duration: 2ms

20

137,490

Details

1h33m21s

30ms

150ms

40ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 01	00	3,234	2m5s	38ms
	01	3,186	2m1s	38ms
	02	2,332	1m30s	38ms
	03	1,808	1m9s	38ms
	04	1,855	1m11s	38ms
	05	1,119	42s945ms	38ms
	06	1,759	1m7s	38ms
	07	1,422	55s603ms	39ms
	08	2,439	1m34s	38ms
	09	6,539	4m17s	39ms
	10	14,106	9m56s	42ms
	11	10,658	7m18s	41ms
	12	11,733	7m54s	40ms
	13	10,341	7m2s	40ms
	14	8,741	5m59s	41ms
	15	7,975	5m19s	40ms
	16	10,108	7m1s	41ms
	17	7,181	4m45s	39ms
	18	7,260	4m47s	39ms
	19	9,088	6m57s	45ms
	20	6,913	4m37s	40ms
	21	5,145	3m25s	39ms
	22	2,548	1m39s	38ms

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

Date: 2025-01-01 19:01:14 Duration: 150ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4027856)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-01 19:51:25 Duration: 136ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4097242)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-01 19:00:24 Duration: 126ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

28m9s

1m43s

24

Details

41m18s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 01	08	1	0ms	0ms
	10	1	0ms	0ms
	12	1	0ms	0ms
	13	3	28m9s	9m23s
	14	6	5ms	0ms
	15	2	0ms	0ms
	16	6	13m9s	2m11s
	17	1	1ms	1ms
	18	1	0ms	0ms
	19	2	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-01 12:39:11.363002', "last_update" = '2025-01-01 11:54:11.363026', "write_date" = '2025-01-01 11:54:11.026151', "write_uid" = 1 WHERE id IN (886);

Date: 2025-01-01 13:22:21 Duration: 28m9s
UPDATE "res_users" SET "exp_date" = '2025-01-01 16:23:11.345554', "last_update" = '2025-01-01 15:38:11.345577', "write_date" = '2025-01-01 15:38:10.989479', "write_uid" = 1 WHERE id IN (1229);

Date: 2025-01-01 16:51:20 Duration: 13m9s
UPDATE "res_users" SET "exp_date" = '2025-01-01 13:19:39.470312', "last_update" = '2025-01-01 12:34:39.470339', "write_date" = '2025-01-01 12:34:39.117571', "write_uid" = 1 WHERE id IN (886);

Date: 2025-01-01 13:34:39 Duration: 1ms

2

0ms

28m52s

20s479ms

306

Details

1h44m26s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 01	00	4	2ms	0ms
	01	1	0ms	0ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	05	1	0ms	0ms
	06	1	1ms	1ms
	07	2	0ms	0ms
	08	15	6ms	0ms
	09	34	31ms	0ms
	10	24	9m45s	24s391ms
	11	18	5m55s	19s736ms
	12	22	32ms	1ms
	13	37	3m21s	5s436ms
	14	45	8m22s	11s157ms
	15	18	4m30s	15s33ms
	16	23	12m43s	33s180ms
	17	18	2m25s	8s72ms
	18	8	5ms	0ms
	19	12	10m2s	50s196ms
	20	13	35m44s	2m44s
	21	5	4ms	0ms
	22	3	11m37s	3m52s

UPDATE "res_users" SET "exp_date" = '2025-01-01 20:06:28.111742', "last_update" = '2025-01-01 19:21:28.111764', "sid" = '0e772e83c1d88a5e715d34199b70492f1a92f0f4', "write_date" = '2025-01-01 19:21:27.785938', "write_uid" = 1 WHERE id IN (857);

Date: 2025-01-01 20:50:20 Duration: 28m52s
UPDATE "res_users" SET "exp_date" = '2025-01-01 22:08:43.480564', "last_update" = '2025-01-01 21:23:43.480587', "sid" = 'bde618a98efdc49286bb388970c156b3d0fbae99', "write_date" = '2025-01-01 21:23:43.157182', "write_uid" = 901 WHERE id IN (901);

Date: 2025-01-01 22:35:20 Duration: 11m37s
UPDATE "res_users" SET "exp_date" = '2025-01-01 19:12:18.231175', "last_update" = '2025-01-01 18:27:18.231198', "sid" = '6bafd022851d9a9228b3a567b090774a41f28af8', "write_date" = '2025-01-01 18:27:17.899842', "write_uid" = 1 WHERE id IN (1387);

Date: 2025-01-01 19:37:20 Duration: 10m2s

3

0ms

59m57s

4s215ms

72,222

Details

3d12h34m32s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 01	00	684	153ms	0ms
	01	766	171ms	0ms
	02	625	135ms	0ms
	03	602	134ms	0ms
	04	430	93ms	0ms
	05	648	142ms	0ms
	06	738	167ms	0ms
	07	479	105ms	0ms
	08	1,626	6h7m19s	13s554ms
	09	3,874	28m29s	441ms
	10	5,726	4h53m32s	3s75ms
	11	7,110	7h46m8s	3s933ms
	12	7,030	1h45m37s	901ms
	13	7,895	6h31m47s	2s977ms
	14	7,007	9h46m34s	5s22ms
	15	6,827	8h16m41s	4s365ms
	16	5,605	9h16m26s	5s956ms
	17	4,142	6h21m20s	5s524ms
	18	3,107	1m19s	25ms
	19	2,945	4h9m21s	5s80ms
	20	2,137	8h32m23s	14s386ms
	21	1,510	6h23m18s	15s231ms
	22	709	4h14m9s	21s507ms

update res_users set sid = '55bbf12ac39503148606de1763ed10f44e7f0e34', last_update = '2025-01-01 20:27:53.372449', exp_date = '2025-01-01 21:12:53.372453', logged_in = 'TRUE' where id = 956;

Date: 2025-01-01 22:27:50 Duration: 59m57s
update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:21:54.342244', exp_date = '2025-01-01 20:06:54.342248', logged_in = 'TRUE' where id = 857;

Date: 2025-01-01 20:50:20 Duration: 28m25s
update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-01 19:22:18.516468', exp_date = '2025-01-01 20:07:18.516474', logged_in = 'TRUE' where id = 857;

Date: 2025-01-01 20:50:20 Duration: 28m1s

4

27ms

5s263ms

2s727ms

293

Details

13m19s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 01	09	13	40s899ms	3s146ms
	10	2	8s218ms	4s109ms
	11	9	18s99ms	2s11ms
	12	22	49s107ms	2s232ms
	13	10	19s369ms	1s936ms
	14	31	40s616ms	1s310ms
	15	31	1m12s	2s342ms
	16	61	2m53s	2s837ms
	17	19	59s551ms	3s134ms
	18	22	1m10s	3s210ms
	19	21	1m28s	4s210ms
	20	26	1m29s	3s446ms
	21	18	55s992ms	3s110ms
	22	8	13s17ms	1s627ms

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

Date: 2025-01-01 19:00:38 Duration: 5s263ms
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 (66))))))) 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 (66)))))) 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 (66)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66)))))) 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 (66))))))))) 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 (66)))))))) AND ("policy_number"."name"::text ilike '%9624300%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-01 19:00:38 Duration: 5s157ms
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 (66))))))) 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 (66)))))) 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 (66)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66)))))) 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 (66))))))))) 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 (66)))))))) AND ("policy_number"."name"::text ilike '%962%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-01 19:00:36 Duration: 5s144ms

5

245ms

2s32ms

979ms

9,916

Details

2h41m50s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 01	00	275	4m25s	964ms
	01	340	5m28s	966ms
	02	136	2m11s	967ms
	09	3	3s62ms	1s20ms
	10	35	36s862ms	1s53ms
	12	39	42s812ms	1s97ms
	13	231	4m3s	1s53ms
	14	366	6m6s	1s1ms
	15	315	5m12s	992ms
	16	756	12m59s	1s31ms
	17	562	9m31s	1s17ms
	18	1,796	27m45s	927ms
	19	1,024	17m15s	1s11ms
	20	1,889	31m32s	1s1ms
	21	1,000	15m55s	955ms
	22	1,149	17m59s	939ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9735515')) 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-01-01 19:33:43 Duration: 2s32ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9605490')) 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 (62))))))) 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 (62)))))) 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 (62)))))) 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 (62))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-01 19:46:22 Duration: 1s685ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9734918')) 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-01-01 19:33:49 Duration: 1s673ms

6

421ms

2s810ms

503ms

42,624

Details

5h57m25s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 01	00	194	1m37s	503ms
	01	228	1m55s	504ms
	02	324	2m38s	487ms
	03	179	1m31s	509ms
	04	95	50s624ms	532ms
	05	98	52s47ms	531ms
	06	234	1m55s	494ms
	07	405	3m10s	470ms
	08	1,727	13m18s	462ms
	09	2,001	16m18s	488ms
	10	3,007	26m28s	528ms
	11	3,705	31m26s	509ms
	12	3,760	31m27s	501ms
	13	3,400	28m54s	510ms
	14	2,645	22m39s	513ms
	15	3,277	26m52s	492ms
	16	4,984	42m16s	508ms
	17	2,840	22m42s	479ms
	18	2,672	21m15s	477ms
	19	3,393	31m40s	560ms
	20	1,992	15m57s	480ms
	21	1,000	7m56s	476ms
	22	464	3m40s	474ms

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

Date: 2025-01-01 19:01:20 Duration: 2s810ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4087168)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:27 Duration: 2s782ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4087152)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:14 Duration: 2s618ms

7

415ms

3s858ms

491ms

238,274

Details

1d8h29m56s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 01	00	6,834	53m16s	467ms
	01	7,351	57m	465ms
	02	6,393	49m6s	460ms
	03	5,164	39m25s	458ms
	04	5,560	43m30s	469ms
	05	5,181	39m18s	455ms
	06	6,924	53m11s	460ms
	07	2,625	20m21s	465ms
	08	5,699	43m22s	456ms
	09	8,654	1h7m57s	471ms
	10	19,013	2h41m15s	508ms
	11	14,128	1h55m55s	492ms
	12	14,141	1h54m32s	485ms
	13	12,611	1h43m47s	493ms
	14	10,322	1h26m9s	500ms
	15	9,698	1h18m1s	482ms
	16	13,844	1h57m40s	509ms
	17	9,647	1h18m11s	486ms
	18	11,697	1h34m58s	487ms
	19	23,311	3h33m46s	550ms
	20	18,884	2h34m41s	491ms
	21	11,646	1h34m21s	486ms
	22	8,947	1h10m6s	470ms

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

Date: 2025-01-01 19:45:36 Duration: 3s858ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4127264)) AND (("shipping_track"."id" not in (33827484, 33827484)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:16 Duration: 3s285ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4127005)) AND (("shipping_track"."id" not in (33826113, 33827524, 33827524)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-01 19:01:20 Duration: 2s844ms

8

224ms

1s518ms

319ms

13,497

Details

1h11m56s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 01	00	710	3m30s	296ms
	01	544	2m41s	297ms
	02	347	1m42s	295ms
	03	157	46s213ms	294ms
	04	961	4m41s	292ms
	06	366	1m47s	293ms
	07	400	1m54s	286ms
	08	75	21s967ms	292ms
	09	160	51s89ms	319ms
	10	187	1m5s	350ms
	11	49	16s875ms	344ms
	12	110	35s515ms	322ms
	13	204	1m8s	337ms
	14	422	2m17s	325ms
	15	186	1m	322ms
	16	833	4m34s	329ms
	17	1,085	5m41s	315ms
	18	1,179	6m11s	315ms
	19	1,983	11m57s	361ms
	20	1,650	8m51s	322ms
	21	1,476	7m51s	319ms
	22	413	2m6s	307ms

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

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

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

Date: 2025-01-01 19:00:30 Duration: 674ms

9

182ms

495ms

274ms

19,785

Details

1h30m31s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 01	08	366	1m28s	242ms
	09	3,478	15m7s	261ms
	10	2,420	11m43s	290ms
	11	1,466	6m48s	278ms
	12	1,788	8m12s	275ms
	13	1,940	8m55s	276ms
	14	2,625	12m23s	283ms
	15	2,007	9m9s	273ms
	16	2,778	12m43s	274ms
	17	855	3m39s	256ms
	18	62	17s663ms	284ms

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

Date: 2025-01-01 10:26:03 Duration: 495ms
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" = '9544245')))) ORDER BY "collection_policy"."id";

Date: 2025-01-01 10:26:06 Duration: 488ms
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" = '9544196')))) ORDER BY "collection_policy"."id";

Date: 2025-01-01 10:26:07 Duration: 479ms

10

193ms

376ms

265ms

3,023

Details

13m23s

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" = ?) and ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))))) order by "collection_policy"."id";

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 01	09	282	1m11s	254ms
	10	231	59s849ms	259ms
	11	120	31s447ms	262ms
	12	170	45s636ms	268ms
	13	160	41s228ms	257ms
	14	484	2m14s	278ms
	15	5	1s277ms	255ms
	16	456	2m9s	284ms
	17	1,054	4m32s	258ms
	18	61	15s754ms	258ms

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

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

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

Date: 2025-01-01 16:19:35 Duration: 364ms

11

93ms

838ms

240ms

46,212

Details

3h5m2s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,940	6m54s	213ms
	01	1,758	6m7s	209ms
	02	958	4m10s	261ms
	03	310	1m25s	275ms
	04	1,904	7m37s	240ms
	06	728	2m56s	242ms
	07	792	2m39s	201ms
	08	146	32s800ms	224ms
	09	320	1m28s	276ms
	10	430	1m47s	249ms
	11	96	24s278ms	252ms
	12	292	1m8s	234ms
	13	848	3m33s	251ms
	14	1,481	5m28s	221ms
	15	988	3m33s	215ms
	16	3,143	13m20s	254ms
	17	3,259	12m29s	229ms
	18	5,897	22m59s	233ms
	19	5,967	26m29s	266ms
	20	6,995	28m45s	246ms
	21	4,882	19m32s	240ms
	22	3,078	11m36s	226ms

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

Date: 2025-01-01 20:12:14 Duration: 838ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-01 20:12:14 Duration: 837ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ايمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-01 18:58:04 Duration: 822ms

12

176ms

1s83ms

222ms

124,027

Details

7h40m47s

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

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1,318	4m17s	195ms
	01	1,556	5m6s	197ms
	02	1,918	6m22s	199ms
	03	1,577	5m9s	196ms
	04	1,239	4m1s	195ms
	05	2,683	8m51s	198ms
	06	4,550	15m6s	199ms
	07	611	2m	196ms
	08	1,411	4m38s	197ms
	09	7,857	26m57s	205ms
	10	7,164	25m57s	217ms
	11	3,786	13m29s	213ms
	12	3,302	11m35s	210ms
	13	6,211	21m56s	211ms
	14	8,086	28m49s	213ms
	15	4,697	16m3s	205ms
	16	5,771	21m9s	220ms
	17	5,020	17m3s	203ms
	18	2,166	8m38s	239ms
	19	31,715	2h18m19s	261ms
	20	4,821	17m30s	217ms
	21	9,302	32m52s	212ms
	22	7,266	24m50s	205ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9611754')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-01 19:01:02 Duration: 1s83ms
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" = '9611755')) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-01 19:01:15 Duration: 558ms

13

182ms

292ms

210ms

5,365

Details

18m51s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 01	02	7	1s408ms	201ms
	06	894	2m58s	200ms
	07	33	6s545ms	198ms
	08	223	44s35ms	197ms
	09	496	1m40s	202ms
	10	1,214	4m23s	216ms
	11	120	25s525ms	212ms
	12	170	36s889ms	216ms
	13	241	50s734ms	210ms
	14	505	1m51s	220ms
	15	31	6s614ms	213ms
	16	466	1m43s	222ms
	17	847	2m57s	209ms
	18	118	24s340ms	206ms

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

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

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

Date: 2025-01-01 10:03:24 Duration: 284ms

14

180ms

488ms

207ms

10,350

Details

35m43s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 01	00	116	22s935ms	197ms
	01	155	30s614ms	197ms
	03	26	5s97ms	196ms
	04	65	12s692ms	195ms
	05	503	1m38s	196ms
	06	1,237	4m5s	198ms
	07	484	1m35s	197ms
	08	795	2m37s	198ms
	09	1,178	3m58s	202ms
	10	910	3m17s	217ms
	11	666	2m20s	211ms
	12	373	1m17s	209ms
	13	903	3m9s	210ms
	14	986	3m28s	211ms
	15	544	1m50s	203ms
	16	602	2m11s	218ms
	17	322	1m6s	206ms
	18	118	24s351ms	206ms
	19	163	46s505ms	285ms
	20	109	22s437ms	205ms
	21	95	19s919ms	209ms

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

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

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

Date: 2025-01-01 19:45:45 Duration: 382ms

15

178ms

238ms

197ms

11,454

Details

37m42s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 01	00	930	3m2s	195ms
	01	1,273	4m10s	196ms
	02	1,892	6m16s	198ms
	03	1,506	4m55s	195ms
	04	1,174	3m49s	195ms
	05	2,148	7m5s	198ms
	06	2,419	8m2s	199ms
	07	84	16s414ms	195ms
	08	28	5s471ms	195ms

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

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

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

Date: 2025-01-01 02:44:35 Duration: 233ms

16

121ms

305ms

143ms

5,474

Details

13m5s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 01	00	25	3s259ms	130ms
	01	31	4s79ms	131ms
	06	5	661ms	132ms
	08	32	4s178ms	130ms
	09	270	37s375ms	138ms
	10	1,122	2m45s	147ms
	11	881	2m4s	141ms
	12	994	2m20s	141ms
	13	698	1m40s	144ms
	14	337	49s587ms	147ms
	15	191	26s774ms	140ms
	16	224	32s803ms	146ms
	17	238	33s421ms	140ms
	18	142	19s490ms	137ms
	19	107	17s509ms	163ms
	20	132	18s653ms	141ms
	21	31	4s294ms	138ms
	22	14	1s883ms	134ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-01 10:34:09 Duration: 305ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-01 10:34:07 Duration: 303ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-01 19:51:32 Duration: 296ms

17

83ms

233ms

103ms

19,192

Details

33m8s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 01	01	2	223ms	111ms
	06	6	613ms	102ms
	07	41	4s238ms	103ms
	08	395	40s268ms	101ms
	09	1,554	2m35s	100ms
	10	846	1m31s	107ms
	11	2,258	3m54s	103ms
	12	1,785	3m4s	103ms
	13	2,496	4m19s	104ms
	14	2,456	4m11s	102ms
	15	1,645	2m47s	101ms
	16	1,720	3m4s	107ms
	17	1,593	2m39s	100ms
	18	892	1m27s	98ms
	19	807	1m34s	116ms
	20	535	56s156ms	104ms
	21	102	10s216ms	100ms
	22	59	5s868ms	99ms

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

Date: 2025-01-01 17:22:17 Duration: 233ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7921297)) AND (("cash_track"."id" not in (6489364)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-01 19:33:52 Duration: 210ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7919929)) AND (("cash_track"."id" not in (6479683)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-01 16:18:16 Duration: 198ms

18

37ms

105ms

48ms

45,346

Details

36m18s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 01	00	1	51ms	51ms
	01	1	47ms	47ms
	02	28	1s318ms	47ms
	03	10	461ms	46ms
	05	50	2s311ms	46ms
	06	46	2s146ms	46ms
	07	46	2s161ms	46ms
	08	317	14s500ms	45ms
	09	5,257	4m2s	46ms
	10	5,636	4m36s	48ms
	11	3,337	2m42s	48ms
	12	2,636	2m5s	47ms
	13	5,202	4m8s	47ms
	14	7,811	6m14s	47ms
	15	4,363	3m26s	47ms
	16	5,787	4m49s	50ms
	17	1,893	1m27s	46ms
	18	1,367	1m2s	45ms
	19	770	41s742ms	54ms
	20	458	22s193ms	48ms
	21	259	12s741ms	49ms
	22	71	3s316ms	46ms

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

Date: 2025-01-01 19:02:13 Duration: 105ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4094401) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-01 19:47:03 Duration: 104ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3892899) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-01 19:01:00 Duration: 96ms

19

34ms

75ms

44ms

17,654

Details

12m57s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 01	08	179	7s615ms	42ms
	09	2,098	1m28s	42ms
	10	2,384	1m46s	44ms
	11	1,449	1m4s	44ms
	12	1,228	53s548ms	43ms
	13	2,326	1m42s	44ms
	14	2,939	2m9s	43ms
	15	1,408	1m1s	43ms
	16	2,706	2m4s	45ms
	17	814	34s803ms	42ms
	18	123	5s149ms	41ms

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

Date: 2025-01-01 16:12:44 Duration: 75ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3937437) ORDER BY "collection_policy"."id";

Date: 2025-01-01 16:12:45 Duration: 65ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3937427) ORDER BY "collection_policy"."id";

Date: 2025-01-01 16:12:45 Duration: 65ms

20

30ms

150ms

40ms

137,490

Details

1h33m21s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 01	00	3,234	2m5s	38ms
	01	3,186	2m1s	38ms
	02	2,332	1m30s	38ms
	03	1,808	1m9s	38ms
	04	1,855	1m11s	38ms
	05	1,119	42s945ms	38ms
	06	1,759	1m7s	38ms
	07	1,422	55s603ms	39ms
	08	2,439	1m34s	38ms
	09	6,539	4m17s	39ms
	10	14,106	9m56s	42ms
	11	10,658	7m18s	41ms
	12	11,733	7m54s	40ms
	13	10,341	7m2s	40ms
	14	8,741	5m59s	41ms
	15	7,975	5m19s	40ms
	16	10,108	7m1s	41ms
	17	7,181	4m45s	39ms
	18	7,260	4m47s	39ms
	19	9,088	6m57s	45ms
	20	6,913	4m37s	40ms
	21	5,145	3m25s	39ms
	22	2,548	1m39s	38ms

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

Date: 2025-01-01 19:01:14 Duration: 150ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4027856)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-01 19:51:25 Duration: 136ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4097242)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-01 19:00:24 Duration: 126ms

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

18,251,256 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	9	0.00%
DETAIL	25	0.00%
ERROR	7,107	0.04%
EVENTLOG	1,577	0.01%
FATAL	1,283	0.01%
HINT	5	0.00%
LOG	18,234,119	99.91%
STATEMENT	7,131	0.04%

Events distribution (except queries)

Key values

0 PANIC entries
1283 FATAL entries
7107 ERROR entries
0 WARNING entries
1577 EVENTLOG entries

Most Frequent Errors/Events

Key values

3,662 Max number of times the same event was reported
9,967 Total events found

Rank

Times reported

Error

1

3,662

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 01	00	15
	01	12
	02	6
	03	6
	04	2
	05	3
	06	6
	07	16
	08	60
	09	81
	10	180
	11	298
	12	288
	13	627
	14	878
	15	434
	16	231
	17	180
	18	59
	19	162
	20	64
	21	29
	22	25

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

3,419

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 01	00	13
	01	10
	02	4
	03	5
	05	2
	06	4
	07	16
	08	52
	09	77
	10	169
	11	285
	12	282
	13	608
	14	827
	15	414
	16	219
	17	171
	18	56
	19	104
	20	55
	21	24
	22	22

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

1,129

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 01	08	29
	09	20
	10	48
	11	74
	12	55
	13	76
	14	286
	15	171
	16	76
	17	110
	19	56
	20	43
	21	53
	22	32

4

1,129

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 01	08	29
	09	20
	10	48
	11	74
	12	55
	13	76
	14	286
	15	171
	16	76
	17	110
	19	56
	20	43
	21	53
	22	32

5

301

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 01	08	3
	09	12
	10	19
	11	24
	12	9
	13	21
	14	72
	15	54
	16	23
	17	18
	19	9
	20	24
	21	11
	22	2

6

146

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 01	01	1
	08	2
	09	6
	10	11
	11	10
	12	5
	13	11
	14	34
	15	25
	16	13
	17	8
	19	6
	20	10
	21	4

7

71

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 01	17	71

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

8

30

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 01	17	30

9

21

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 01	17	21

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

10

12

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 01	04	3
	11	3
	21	3
	22	3

FATAL: password authentication failed for user "postgres"

11

8

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 01	10	1
	12	1
	13	1
	15	1
	17	2
	18	1
	19	1

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

12

7

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 01	04	1
	10	1
	14	3
	19	1
	22	1

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 01	09	1
	15	2
	18	2
	21	1

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

14

5

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 01	04	1
	10	1
	14	1
	19	1
	22	1

15

5

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 01	00	1
	11	2
	14	1
	16	1

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

16

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 01	04	1
	10	1
	19	1
	22	1

17

4

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 01	17	4

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

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 01	15	2

ERROR: invalid input syntax for type date: "False" at character 37

19

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 01	13	1
	14	1

20

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 01	17	1

21

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 01	21	1

ERROR: could not serialize access due to concurrent delete

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 01	21	1

23

1

Details

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

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 01	14	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables