pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jan 23 23:47:38 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 44,755,927 log entries in 2m37s
Log start from 2025-01-23 00:00:00 to 2025-01-23 22:45:01

Global Stats

19,761 Number of unique normalized queries
19,177,225 Number of queries
7d22h36m21s Total query duration
2025-01-23 00:00:00 First query
2025-01-23 22:45:01 Last query
8,074 queries/s at 2025-01-23 14:14:13 Query peak

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

5,702 Number of events
23 Number of unique normalized events
2,007 Max number of times the same event was reported
0 Number of cancellation

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

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

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

8,074 queries/s Query Peak
2025-01-23 14:14:13 Date

SELECT Traffic

Key values

5,549 queries/s Query Peak
2025-01-23 14:14:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,728 queries/s Query Peak
2025-01-23 14:14:13 Date

Queries duration

Key values

7d22h36m21s 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 23	00	329,653	0ms	34m15s	85ms	3m47s	4m44s	5h46m12s
	01	266,558	0ms	3m7s	29ms	3m31s	4m17s	6m36s
	02	302,814	0ms	4s415ms	30ms	4m10s	4m56s	6m38s
	03	313,054	0ms	54s70ms	30ms	4m28s	5m23s	5m44s
	04	239,413	0ms	2s780ms	29ms	3m25s	3m51s	4m49s
	05	123,884	0ms	25s329ms	14ms	1m9s	1m18s	1m33s
	06	189,589	0ms	1h	78ms	2m34s	6m2s	2h59m22s
	07	177,496	0ms	4s167ms	17ms	1m56s	2m33s	2m55s
	08	479,871	0ms	1s149ms	9ms	2m13s	2m37s	3m16s
	09	1,238,991	0ms	37m46s	46ms	8m38s	48m35s	10h4m24s
	10	1,546,915	0ms	25m22s	40ms	11m5s	1h19m28s	5h8m24s
	11	1,662,856	0ms	21m54s	25ms	9m42s	10m37s	5h5m58s
	12	1,672,209	0ms	37m42s	36ms	9m31s	1h25m5s	7h16m43s
	13	1,656,349	0ms	7m53s	19ms	9m11s	31m46s	1h44m42s
	14	1,438,980	0ms	2m19s	14ms	8m54s	9m57s	11m36s
	15	1,389,853	0ms	41m17s	30ms	10m23s	57m16s	2h38m8s
	16	1,448,489	0ms	21m25s	27ms	9m1s	10m55s	4h22m48s
	17	1,186,757	0ms	23m44s	26ms	16m21s	19m33s	2h35m49s
	18	1,089,847	0ms	45m52s	58ms	9m59s	11m59s	11h5m1s
	19	934,766	0ms	40m14s	46ms	8m37s	11m40s	7h16m59s
	20	706,671	0ms	4s237ms	16ms	5m7s	5m47s	6m16s
	21	470,610	0ms	59m59s	134ms	5m48s	1h37m42s	11h1m51s
	22	311,600	0ms	37m18s	86ms	3m56s	4m3s	5h52m59s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 23	00	186,397	39ms	3m11s	3m47s	4m43s
	01	146,790	48ms	2m52s	3m14s	3m35s
	02	162,574	56ms	3m42s	4m9s	5m15s
	03	165,668	56ms	3m37s	4m28s	5m26s
	04	118,167	59ms	2m50s	3m25s	4m25s
	05	59,775	30ms	52s943ms	1m9s	1m18s
	06	104,858	39ms	1m34s	2m10s	6m1s
	07	94,511	32ms	1m28s	1m56s	2m44s
	08	280,030	16ms	1m53s	2m13s	3m14s
	09	753,073	17ms	4m56s	6m22s	8m36s
	10	934,589	22ms	7m30s	9m52s	11m3s
	11	982,370	24ms	8m41s	9m22s	9m51s
	12	1,017,742	19ms	6m55s	8m12s	9m54s
	13	1,013,584	20ms	6m49s	8m26s	9m10s
	14	826,376	24ms	7m42s	8m38s	9m55s
	15	807,228	27ms	7m54s	9m18s	10m22s
	16	880,203	19ms	6m45s	8m3s	9m
	17	724,269	25ms	7m25s	15m8s	18m4s
	18	647,502	36ms	8m26s	9m12s	10m30s
	19	563,095	30ms	6m20s	8m12s	11m38s
	20	417,098	27ms	4m13s	5m7s	5m51s
	21	277,213	35ms	4m2s	5m2s	6m11s
	22	187,601	31ms	2m55s	3m27s	4m35s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 23	00	31,858	6,513	166	0	537ms	195ms	269ms	389ms
	01	24,235	4,824	144	0	25ms	149ms	190ms	3m
	02	31,930	7,919	161	0	0ms	179ms	222ms	306ms
	03	31,657	7,769	141	0	1ms	185ms	230ms	356ms
	04	22,020	6,531	147	0	0ms	137ms	168ms	233ms
	05	5,950	2,151	165	0	3ms	35ms	49ms	64ms
	06	14,021	3,102	139	0	622ms	92ms	128ms	328ms
	07	8,123	2,993	141	0	0ms	53ms	109ms	184ms
	08	16,336	6,135	301	0	0ms	99ms	132ms	187ms
	09	50,264	16,532	670	0	664ms	325ms	495ms	44m59s
	10	70,577	23,263	1,019	0	446ms	513ms	603ms	1h14m47s
	11	86,056	24,858	839	0	162ms	552ms	679ms	6s739ms
	12	74,014	21,615	657	1	422ms	456ms	579ms	1h20m49s
	13	68,277	22,460	592	0	139ms	440ms	584ms	25m16s
	14	69,335	24,530	695	0	4ms	443ms	571ms	1m3s
	15	64,242	23,354	776	1	225ms	472ms	3s942ms	52m36s
	16	67,779	21,151	627	0	258ms	399ms	668ms	3m40s
	17	56,602	23,384	801	0	153ms	587ms	1s18ms	2m44s
	18	74,690	22,278	624	1	410ms	511ms	643ms	2m37s
	19	67,074	17,361	870	4	306ms	397ms	533ms	812ms
	20	49,875	13,562	442	1	0ms	297ms	361ms	520ms
	21	43,047	8,972	252	0	1s26ms	286ms	379ms	1h31m30s
	22	24,254	5,704	230	3	697ms	194ms	240ms	317ms

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

128,759 buffers Checkpoint Peak
2025-01-23 16:21:22 Date
270.055 seconds Highest write time
0.019 seconds Sync time

Checkpoints Wal files

Key values

52 files Wal files usage Peak
2025-01-23 16:21:22 Date

Checkpoints distance

Key values

1,652.38 Mo Distance Peak
2025-01-23 16:21:22 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 23	00	146,639	3,239.569s	0.031s	3,239.645s
	01	133,733	3,239.563s	0.032s	3,239.64s
	02	141,222	3,239.56s	0.035s	3,239.637s
	03	191,180	3,239.564s	0.033s	3,239.653s
	04	155,852	3,239.493s	0.032s	3,239.579s
	05	78,629	3,076.539s	0.026s	3,076.602s
	06	77,475	3,079.563s	0.027s	3,079.621s
	07	83,282	2,876.416s	0.024s	2,876.468s
	08	118,141	3,208.516s	0.03s	3,208.581s
	09	338,000	3,239.578s	0.048s	3,239.702s
	10	517,178	3,239.549s	0.051s	3,239.676s
	11	558,866	3,239.47s	0.052s	3,239.618s
	12	540,030	3,239.477s	0.049s	3,239.631s
	13	457,788	3,239.549s	0.056s	3,239.681s
	14	461,388	3,239.473s	0.048s	3,239.604s
	15	461,666	3,239.478s	0.064s	3,239.623s
	16	482,954	3,239.514s	0.05s	3,239.641s
	17	270,058	2,889.079s	0.083s	2,889.23s
	18	365,660	3,239.558s	0.054s	3,239.686s
	19	343,332	3,239.492s	0.053s	3,239.609s
	20	234,751	3,239.537s	0.06s	3,239.647s
	21	198,797	3,239.592s	0.052s	3,239.693s
	22	81,869	2,429.617s	0.033s	2,429.682s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 23	00	65	3,893	0.002s	0.012s
	01	54	2,935	0.002s	0.012s
	02	60	3,001	0.002s	0.012s
	03	85	3,024	0.002s	0.012s
	04	70	2,586	0.004s	0.012s
	05	34	2,263	0.002s	0.012s
	06	32	2,568	0.002s	0.012s
	07	35	2,259	0.002s	0.012s
	08	47	3,666	0.003s	0.012s
	09	138	5,110	0.003s	0.012s
	10	213	5,199	0.003s	0.012s
	11	240	5,260	0.003s	0.012s
	12	234	5,394	0.003s	0.012s
	13	193	5,492	0.003s	0.012s
	14	195	5,513	0.002s	0.012s
	15	197	5,661	0.016s	0.012s
	16	197	5,679	0.003s	0.012s
	17	109	5,372	0.014s	0.012s
	18	155	5,453	0.003s	0.012s
	19	145	5,500	0.003s	0.012s
	20	96	5,357	0.005s	0.012s
	21	88	4,712	0.003s	0.012s
	22	33	3,755	0.002s	0.009s

Day	Hour	Avg time (sec)
Jan 23	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 23	00	88,213.67 kB	124,215.17 kB
	01	74,539.67 kB	98,780.25 kB
	02	80,877.17 kB	97,039.83 kB
	03	116,447.75 kB	149,066.25 kB
	04	95,111.42 kB	117,255.83 kB
	05	47,479.08 kB	94,235.83 kB
	06	42,624.08 kB	66,797.50 kB
	07	48,998.83 kB	111,511.67 kB
	08	63,743.17 kB	90,958.25 kB
	09	183,672.00 kB	225,197.64 kB
	10	290,845.83 kB	318,017.00 kB
	11	327,796.50 kB	358,888.17 kB
	12	319,035.25 kB	368,449.33 kB
	13	268,516.18 kB	349,848.82 kB
	14	266,194.50 kB	345,199.75 kB
	15	269,473.67 kB	336,209.92 kB
	16	289,179.89 kB	594,358.00 kB
	17	148,978.25 kB	299,955.50 kB
	18	211,649.83 kB	242,449.75 kB
	19	194,083.00 kB	275,128.18 kB
	20	131,250.92 kB	186,425.00 kB
	21	119,815.42 kB	163,969.33 kB
	22	61,495.89 kB	104,470.89 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

11,350,713 Total read queries
5,332,527 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,350,713	59.19%
INSERT	1,052,216	5.49%
UPDATE	316,961	1.65%
DELETE	10,599	0.06%
COPY FROM	11	0.00%
COPY TO	0	0.00%
CTE	27,483	0.14%
DDL	2,005	0.01%
TCL	3,923,252	20.46%
CURSOR	0	0.00%
OTHERS	2,493,985	13.00%

Queries by database

Key values

unknown Main database
19,177,225 Requests
7d22h36m21s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	19,177,225	7d22h36m21s
	copy from	11	21ms
	cte	27,483	6s230ms
	ddl	2,005	277ms
	delete	10,599	14s173ms
	insert	1,052,216	5m43s
	others	2,493,985	1m59s
	select	11,350,713	3d10h46m23s
	tcl	3,923,252	2m44s
	update	316,961	4d11h39m10s

Queries by user

Key values

unknown Main user
19,177,225 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	19,177,225	7d22h36m21s
	copy from	11	21ms
	cte	27,483	6s230ms
	ddl	2,005	277ms
	delete	10,599	14s173ms
	insert	1,052,216	5m43s
	others	2,493,985	1m59s
	select	11,350,713	3d10h46m23s
	tcl	3,923,252	2m44s
	update	316,961	4d11h39m10s

Duration by user

Key values

7d22h36m21s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	19,177,225	7d22h36m21s
	copy from	11	21ms
	cte	27,483	6s230ms
	ddl	2,005	277ms
	delete	10,599	14s173ms
	insert	1,052,216	5m43s
	others	2,493,985	1m59s
	select	11,350,713	3d10h46m23s
	tcl	3,923,252	2m44s
	update	316,961	4d11h39m10s

Queries by host

Key values

unknown Main host
19,177,225 Requests
7d22h36m21s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	19,177,225	7d22h36m21s
	copy from	11	21ms
	cte	27,483	6s230ms
	ddl	2,005	277ms
	delete	10,599	14s173ms
	insert	1,052,216	5m43s
	others	2,493,985	1m59s
	select	11,350,713	3d10h46m23s
	tcl	3,923,252	2m44s
	update	316,961	4d11h39m10s

Queries by application

Key values

unknown Main application
19,177,225 Requests
7d22h36m21s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	19,177,225	7d22h36m21s
	copy from	11	21ms
	cte	27,483	6s230ms
	ddl	2,005	277ms
	delete	10,599	14s173ms
	insert	1,052,216	5m43s
	others	2,493,985	1m59s
	select	11,350,713	3d10h46m23s
	tcl	3,923,252	2m44s
	update	316,961	4d11h39m10s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-23 19:45:45 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,866,436 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,866,436	93.16%
1-5ms	328,398	1.71%
5-10ms	15,361	0.08%
10-25ms	52,730	0.27%
25-50ms	64,113	0.33%
50-100ms	189,334	0.99%
100-500ms	336,851	1.76%
500-1000ms	319,531	1.67%
1000-10000ms	3,748	0.02%
> 10000ms	723	0.00%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = '77bf55c1780e3e22dd6e5ce3e8c78170e36ff245', last_update = '2025-01-23 04:45:58.212096', exp_date = '2025-01-23 05:30:58.212099', logged_in = 'TRUE' where id = 939; [ Date: 2025-01-23 06:45:58 ]
2	1h	update res_users set sid = '77bf55c1780e3e22dd6e5ce3e8c78170e36ff245', last_update = '2025-01-23 04:45:58.212096', exp_date = '2025-01-23 05:30:58.212099', logged_in = 'TRUE' where id = 939; [ Date: 2025-01-23 06:45:58 ]
3	59m59s	update res_users set sid = '94af8fef6dd74907628214fadb5eaa06b16e46be', last_update = '2025-01-23 19:05:24.270440', exp_date = '2025-01-23 19:50:24.270443', logged_in = 'TRUE' where id = 1026; [ Date: 2025-01-23 21:05:24 ]
4	58m54s	update res_users set sid = '77bf55c1780e3e22dd6e5ce3e8c78170e36ff245', last_update = '2025-01-23 04:47:03.881468', exp_date = '2025-01-23 05:32:03.881471', logged_in = 'TRUE' where id = 939; [ Date: 2025-01-23 06:45:58 ]
5	45m52s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:08:27.981131', exp_date = '2025-01-23 17:53:27.981135', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
6	45m52s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:08:27.980839', exp_date = '2025-01-23 17:53:27.980843', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
7	45m31s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:08:49.506176', exp_date = '2025-01-23 17:53:49.506180', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
8	44m40s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:09:40.558018', exp_date = '2025-01-23 17:54:40.558022', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
9	44m34s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:09:46.297041', exp_date = '2025-01-23 17:54:46.297044', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
10	44m31s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:09:49.283021', exp_date = '2025-01-23 17:54:49.283028', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
11	44m28s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:09:52.062742', exp_date = '2025-01-23 17:54:52.062745', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
12	44m25s	update res_users set sid = '5f3498196ed06115b53bb6e61b0630767bd5ee0f', last_update = '2025-01-23 17:09:55.365363', exp_date = '2025-01-23 17:54:55.365367', logged_in = 'TRUE' where id = 882; [ Date: 2025-01-23 18:54:20 ]
13	41m17s	UPDATE "res_users" SET "exp_date" = '2025-01-23 14:23:28.958397', "last_update" = '2025-01-23 13:38:28.958425', "sid" = 'b684321702faa2de0d0756775339c7971d975193', "write_date" = '2025-01-23 13:38:28.528207', "write_uid" = 1 WHERE id IN (932); [ Date: 2025-01-23 15:19:46 ]
14	40m14s	update res_users set sid = '60bee9492be350273b243b7f1fa14a62e7d016e1', last_update = '2025-01-23 17:57:06.384644', exp_date = '2025-01-23 18:42:06.384647', logged_in = 'TRUE' where id = 1096; [ Date: 2025-01-23 19:37:20 ]
15	40m14s	update res_users set sid = '60bee9492be350273b243b7f1fa14a62e7d016e1', last_update = '2025-01-23 17:57:06.384601', exp_date = '2025-01-23 18:42:06.384605', logged_in = 'TRUE' where id = 1096; [ Date: 2025-01-23 19:37:20 ]
16	39m51s	update res_users set sid = '139fcb7c88e4d68024553fc67ef90ebc35d89521', last_update = '2025-01-23 17:14:29.251908', exp_date = '2025-01-23 17:59:29.251911', logged_in = 'TRUE' where id = 889; [ Date: 2025-01-23 18:54:20 ]
17	39m51s	update res_users set sid = '139fcb7c88e4d68024553fc67ef90ebc35d89521', last_update = '2025-01-23 17:14:29.251246', exp_date = '2025-01-23 17:59:29.251248', logged_in = 'TRUE' where id = 889; [ Date: 2025-01-23 18:54:20 ]
18	39m27s	update res_users set sid = '60bee9492be350273b243b7f1fa14a62e7d016e1', last_update = '2025-01-23 17:57:52.926697', exp_date = '2025-01-23 18:42:52.926700', logged_in = 'TRUE' where id = 1096; [ Date: 2025-01-23 19:37:20 ]
19	37m46s	UPDATE "res_users" SET "exp_date" = '2025-01-23 08:15:33.965171', "last_update" = '2025-01-23 07:30:33.965194', "write_date" = '2025-01-23 07:30:33.547330', "write_uid" = 1 WHERE id IN (1081); [ Date: 2025-01-23 09:08:20 ]
20	37m46s	update res_users set sid = '556565417d84a2870be4ed8bf6790dfce9501691', last_update = '2025-01-23 07:30:34.069933', exp_date = '2025-01-23 08:15:34.069936', logged_in = 'TRUE' where id = 1081; [ Date: 2025-01-23 09:08:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d22h5m33s

68,216

Details

0ms

1h

4s965ms

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 23	00	937	5h45m16s	22s109ms
	01	815	12m7s	893ms
	02	1,074	242ms	0ms
	03	1,140	254ms	0ms
	04	1,010	220ms	0ms
	05	434	25s420ms	58ms
	06	552	2h58m55s	19s448ms
	07	504	106ms	0ms
	08	1,674	342ms	0ms
	09	4,724	11h11m49s	8s532ms
	10	6,474	10h29m22s	5s832ms
	11	6,968	4h43m20s	2s439ms
	12	6,521	8h11m7s	4s518ms
	13	6,034	3h1m13s	1s802ms
	14	5,215	6m13s	71ms
	15	5,058	4h47m19s	3s408ms
	16	4,722	6h25m28s	4s898ms
	17	3,975	3h22m48s	3s61ms
	18	3,274	11h4m29s	12s177ms
	19	2,903	7h1m33s	8s712ms
	20	2,157	530ms	0ms
	21	1,345	13h29m45s	36s123ms
	22	706	1h14m12s	6s306ms

update res_users set sid = '77bf55c1780e3e22dd6e5ce3e8c78170e36ff245', last_update = '2025-01-23 04:45:58.212096', exp_date = '2025-01-23 05:30:58.212099', logged_in = 'TRUE' where id = 939;

Date: 2025-01-23 06:45:58 Duration: 1h
update res_users set sid = '77bf55c1780e3e22dd6e5ce3e8c78170e36ff245', last_update = '2025-01-23 04:45:58.212096', exp_date = '2025-01-23 05:30:58.212099', logged_in = 'TRUE' where id = 939;

Date: 2025-01-23 06:45:58 Duration: 1h
update res_users set sid = '94af8fef6dd74907628214fadb5eaa06b16e46be', last_update = '2025-01-23 19:05:24.270440', exp_date = '2025-01-23 19:50:24.270443', logged_in = 'TRUE' where id = 1026;

Date: 2025-01-23 21:05:24 Duration: 59m59s

2

1d21h21m49s

261,530

Details

491ms

4s959ms

624ms

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 23	00	8,079	1h19m56s	593ms
	01	7,549	1h13m57s	587ms
	02	9,355	1h33m	596ms
	03	11,628	1h53m41s	586ms
	04	8,717	1h23m19s	573ms
	05	2,107	19m44s	562ms
	06	4,275	43m7s	605ms
	07	3,869	36m20s	563ms
	08	4,279	40m14s	564ms
	09	11,195	1h53m20s	607ms
	10	17,548	3h13m37s	662ms
	11	20,398	3h47m50s	670ms
	12	16,693	3h30s	648ms
	13	14,541	2h36m7s	644ms
	14	15,828	2h52m6s	652ms
	15	17,319	3h10m1s	658ms
	16	13,754	2h25m53s	636ms
	17	10,902	1h59m56s	660ms
	18	21,502	3h43m38s	624ms
	19	17,043	2h54m42s	615ms
	20	10,831	1h44m55s	581ms
	21	8,957	1h26m16s	577ms
	22	5,161	49m27s	574ms

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

Date: 2025-01-23 17:55:48 Duration: 4s959ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4722893)) AND (("shipping_track"."id" not in (39106685, 39106685)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:55:25 Duration: 4s888ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4723127)) AND (("shipping_track"."id" not in (39107471, 39107471)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:57:55 Duration: 4s302ms

3

11h58m38s

328

Details

0ms

41m17s

2m11s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 23	00	7	2ms	0ms
	01	3	3ms	1ms
	02	8	9ms	1ms
	03	5	3ms	0ms
	04	5	3ms	0ms
	05	2	1ms	0ms
	06	3	0ms	0ms
	07	1	0ms	0ms
	08	16	5ms	0ms
	09	36	33m13s	55s361ms
	10	29	1h14m5s	2m33s
	11	19	18m32s	58s569ms
	12	26	2h28m35s	5m42s
	13	31	28m31s	55s216ms
	14	15	15ms	1ms
	15	23	41m17s	1m47s
	16	10	15ms	1ms
	17	14	20ms	1ms
	18	11	11ms	1ms
	19	21	13m54s	39s720ms
	20	1	0ms	0ms
	21	20	1h23m56s	4m11s
	22	22	4h36m32s	12m34s

UPDATE "res_users" SET "exp_date" = '2025-01-23 14:23:28.958397', "last_update" = '2025-01-23 13:38:28.958425', "sid" = 'b684321702faa2de0d0756775339c7971d975193', "write_date" = '2025-01-23 13:38:28.528207', "write_uid" = 1 WHERE id IN (932);

Date: 2025-01-23 15:19:46 Duration: 41m17s
UPDATE "res_users" SET "exp_date" = '2025-01-23 21:43:18.633145', "last_update" = '2025-01-23 20:58:18.633196', "sid" = 'c4ed6411df171ac14feba7a13aa58920f56d1fe4', "write_date" = '2025-01-23 20:58:18.292713', "write_uid" = 1387 WHERE id IN (1387);

Date: 2025-01-23 22:30:03 Duration: 31m45s
UPDATE "res_users" SET "exp_date" = '2025-01-23 21:43:18.803486', "last_update" = '2025-01-23 20:58:18.803519', "sid" = 'c4ed6411df171ac14feba7a13aa58920f56d1fe4', "write_date" = '2025-01-23 20:58:18.472115', "write_uid" = 1387 WHERE id IN (1387);

Date: 2025-01-23 22:30:03 Duration: 31m45s

4

8h19m34s

46,329

Details

496ms

4s550ms

646ms

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 23	00	202	2m6s	628ms
	01	191	2m1s	636ms
	02	160	1m47s	673ms
	03	222	2m30s	677ms
	04	179	1m57s	654ms
	05	140	1m22s	592ms
	06	192	1m55s	600ms
	07	223	2m12s	595ms
	08	992	9m33s	578ms
	09	2,912	30m33s	629ms
	10	4,826	54m43s	680ms
	11	4,399	51m9s	697ms
	12	3,764	42m28s	677ms
	13	4,357	47m32s	654ms
	14	3,383	37m56s	673ms
	15	3,963	43m45s	662ms
	16	3,216	34m10s	637ms
	17	3,792	40m25s	639ms
	18	3,323	34m25s	621ms
	19	2,492	24m51s	598ms
	20	2,022	19m1s	564ms
	21	914	8m42s	572ms
	22	465	4m17s	554ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4716167, 4716166, 4716118, 4716116, 4713470, 4713450, 4711703, 4708416, 4707008, 4705688, 4704972, 4703938, 4701100, 4696867, 4696790, 4696112, 4694745, 4692535, 4691355, 4690779, 4689236, 4686169, 4665092, 4638966, 4638579, 4436842, 2858979)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:55:04 Duration: 4s550ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4717161, 4717127)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:59:03 Duration: 4s14ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4677471)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:56:00 Duration: 3s741ms

5

7h27m21s

126,842

Details

152ms

1s463ms

211ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 23	00	715	2m3s	173ms
	01	917	2m39s	173ms
	02	2,880	8m30s	177ms
	03	2,389	7m5s	178ms
	04	2,986	8m42s	175ms
	05	1,137	3m15s	172ms
	06	1,074	3m6s	173ms
	07	1,586	4m34s	173ms
	08	3,109	9m7s	176ms
	09	5,421	17m2s	188ms
	10	8,544	29m21s	206ms
	11	10,380	35m49s	207ms
	12	8,347	28m26s	204ms
	13	10,744	36m54s	206ms
	14	16,125	54m45s	203ms
	15	16,199	54m34s	202ms
	16	5,871	19m43s	201ms
	17	15,793	1h12m43s	276ms
	18	9,958	39m25s	237ms
	19	1,429	5m11s	217ms
	20	379	1m19s	208ms
	21	645	2m14s	207ms
	22	214	43s989ms	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" = '35452')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-23 17:55:23 Duration: 1s463ms
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" = '35451')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-23 17:55:25 Duration: 1s459ms
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" = '58531')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-23 17:58:12 Duration: 1s441ms

6

4h5m30s

59,631

Details

98ms

943ms

247ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 23	00	4,506	15m51s	211ms
	01	3,459	14m7s	244ms
	02	4,419	17m50s	242ms
	03	3,332	13m24s	241ms
	04	1,466	5m43s	234ms
	05	108	34s332ms	317ms
	06	1,990	8m23s	253ms
	07	146	34s708ms	237ms
	08	88	17s378ms	197ms
	09	100	22s200ms	222ms
	10	68	16s893ms	248ms
	11	192	49s836ms	259ms
	12	194	50s171ms	258ms
	13	912	3m49s	252ms
	14	866	3m55s	271ms
	15	1,944	8m50s	272ms
	16	2,966	12m22s	250ms
	17	4,757	22m59s	289ms
	18	6,329	29m13s	277ms
	19	6,371	26m11s	246ms
	20	5,787	23m33s	244ms
	21	5,721	21m20s	223ms
	22	3,910	14m6s	216ms

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-23 16:16:35 Duration: 943ms
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-23 16:16:35 Duration: 942ms
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-23 18:02:36 Duration: 886ms

7

3h5m32s

11,923

Details

31ms

1s907ms

933ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 23	00	629	9m25s	899ms
	01	978	14m23s	882ms
	02	489	7m8s	875ms
	04	5	4s674ms	934ms
	06	48	41s804ms	870ms
	08	20	17s323ms	866ms
	09	15	12s937ms	862ms
	10	1	1s99ms	1s99ms
	11	16	18s999ms	1s187ms
	12	28	28s132ms	1s4ms
	13	229	3m38s	955ms
	14	102	1m41s	999ms
	15	547	9m17s	1s19ms
	16	861	14m5s	981ms
	17	593	10m50s	1s97ms
	18	1,714	28m14s	988ms
	19	1,623	25m21s	937ms
	20	859	12m14s	855ms
	21	1,832	27m34s	903ms
	22	1,334	19m31s	878ms

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

Date: 2025-01-23 17:58:02 Duration: 1s907ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '81428')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-23 17:57:46 Duration: 1s810ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '97142')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-23 17:55:00 Duration: 1s800ms

8

2h28m58s

31,161

Details

169ms

2s175ms

286ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 23	07	73	24s124ms	330ms
	08	868	3m46s	261ms
	09	3,582	15m22s	257ms
	10	3,294	15m19s	279ms
	11	3,611	17m19s	287ms
	12	3,448	16m45s	291ms
	13	5,608	26m48s	286ms
	14	3,581	17m28s	292ms
	15	4,170	20m23s	293ms
	16	2,419	11m52s	294ms
	17	468	3m11s	409ms
	18	39	15s876ms	407ms

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

Date: 2025-01-23 17:55:16 Duration: 2s175ms
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" = '19445')))) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:55:27 Duration: 1s356ms
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" = '9643698')))) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:55:20 Duration: 1s50ms

9

2h21m20s

152,799

Details

37ms

338ms

55ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 23	00	3,706	3m15s	52ms
	01	2,525	2m12s	52ms
	02	2,906	2m34s	53ms
	03	4,033	3m34s	53ms
	04	2,566	2m15s	52ms
	05	865	45s449ms	52ms
	06	1,232	1m5s	53ms
	07	1,068	56s435ms	52ms
	08	2,850	2m29s	52ms
	09	8,509	7m58s	56ms
	10	12,627	12m47s	60ms
	11	15,468	15m44s	61ms
	12	14,529	14m24s	59ms
	13	12,265	11m59s	58ms
	14	11,053	10m52s	59ms
	15	8,695	8m35s	59ms
	16	8,499	8m4s	56ms
	17	7,340	6m35s	53ms
	18	7,848	6m31s	49ms
	19	8,821	7m	47ms
	20	7,147	5m27s	45ms
	21	5,396	4m3s	45ms
	22	2,851	2m6s	44ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4678716, 4664560, 4597630)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:57:53 Duration: 338ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4698780, 4697665, 4695111, 4695038, 4691774, 4691357, 4691107, 4691101, 4689523, 4688842, 4661228, 4661036, 4640064, 4637230, 4612794, 4599388, 4584549)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:55:21 Duration: 285ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4708234, 4502517)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:59:09 Duration: 284ms

10

1h20m29s

18,260

Details

199ms

1s820ms

264ms

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 23	00	1,641	6m44s	246ms
	01	771	3m4s	239ms
	02	1,740	6m54s	238ms
	03	1,699	6m52s	242ms
	04	744	2m59s	240ms
	05	54	12s131ms	224ms
	06	966	3m48s	236ms
	07	73	16s755ms	229ms
	08	25	5s923ms	236ms
	09	39	9s981ms	255ms
	10	36	9s548ms	265ms
	11	81	22s835ms	281ms
	12	74	20s256ms	273ms
	13	240	1m5s	271ms
	14	339	1m33s	276ms
	15	440	1m59s	272ms
	16	637	2m47s	263ms
	17	1,816	9m20s	308ms
	18	1,493	7m21s	295ms
	19	1,597	7m24s	278ms
	20	2,066	9m19s	270ms
	21	1,056	4m49s	274ms
	22	633	2m46s	262ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9969150')) 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-23 17:58:04 Duration: 1s820ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '23219')) 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-23 17:58:44 Duration: 1s694ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '69732')) 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-23 17:55:27 Duration: 1s676ms

11

1h15m28s

35

Details

0ms

37m46s

2m9s

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 23	02	4	3ms	0ms
	08	2	1ms	0ms
	09	4	37m46s	9m26s
	10	4	8ms	2ms
	11	4	7ms	1ms
	12	3	37m42s	12m34s
	13	1	2ms	2ms
	14	5	3ms	0ms
	15	1	1ms	1ms
	18	2	3ms	1ms
	19	1	2ms	2ms
	21	3	4ms	1ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-23 08:15:33.965171', "last_update" = '2025-01-23 07:30:33.965194', "write_date" = '2025-01-23 07:30:33.547330', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-23 09:08:20 Duration: 37m46s
UPDATE "res_users" SET "exp_date" = '2025-01-23 11:24:39.185670', "last_update" = '2025-01-23 10:39:39.185694', "write_date" = '2025-01-23 10:39:38.812664', "write_uid" = 1 WHERE id IN (959);

Date: 2025-01-23 12:17:21 Duration: 37m42s
UPDATE "res_users" SET "exp_date" = '2025-01-23 10:40:45.925133', "last_update" = '2025-01-23 09:55:45.925165', "write_date" = '2025-01-23 09:55:45.505277', "write_uid" = 1 WHERE id IN (1407);

Date: 2025-01-23 10:55:45 Duration: 3ms

12

43m22s

44,714

Details

43ms

336ms

58ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 23	06	1	52ms	52ms
	07	13	698ms	53ms
	08	1,534	1m20s	52ms
	09	2,789	2m35s	55ms
	10	4,255	4m16s	60ms
	11	4,290	4m18s	60ms
	12	7,089	6m44s	57ms
	13	6,901	6m40s	57ms
	14	8,395	8m13s	58ms
	15	4,118	3m59s	58ms
	16	4,077	3m49s	56ms
	17	744	48s544ms	65ms
	18	324	22s989ms	70ms
	19	80	5s521ms	69ms
	20	55	3s619ms	65ms
	21	5	309ms	61ms
	22	44	2s877ms	65ms

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

Date: 2025-01-23 17:54:36 Duration: 336ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4694875) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:54:26 Duration: 325ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4686342) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:54:36 Duration: 323ms

13

43m13s

13,195

Details

153ms

352ms

196ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 23	00	5	879ms	175ms
	01	5	871ms	174ms
	04	13	2s143ms	164ms
	05	112	19s500ms	174ms
	06	612	1m45s	173ms
	07	1,488	4m18s	173ms
	08	868	2m32s	175ms
	09	672	2m9s	193ms
	10	1,748	5m39s	194ms
	11	2,074	7m7s	206ms
	12	1,213	4m4s	201ms
	13	711	2m18s	195ms
	14	1,275	4m17s	202ms
	15	554	1m51s	202ms
	16	139	26s394ms	189ms
	17	315	1m7s	214ms
	18	532	2m7s	239ms
	19	237	53s358ms	225ms
	20	262	54s345ms	207ms
	21	169	35s856ms	212ms
	22	191	39s190ms	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" = '9977416')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-23 18:35:41 Duration: 301ms

14

39m49s

19,408

Details

95ms

776ms

123ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 23	00	13	1s492ms	114ms
	05	18	2s78ms	115ms
	08	180	20s373ms	113ms
	09	1,971	3m49s	116ms
	10	1,590	3m25s	128ms
	11	1,992	4m20s	131ms
	12	2,000	4m9s	124ms
	13	2,252	4m37s	123ms
	14	1,795	3m41s	123ms
	15	1,533	3m17s	128ms
	16	2,094	4m9s	119ms
	17	907	1m53s	125ms
	18	1,021	2m3s	120ms
	19	1,077	2m8s	119ms
	20	704	1m19s	113ms
	21	103	12s67ms	117ms
	22	158	17s884ms	113ms

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

Date: 2025-01-23 17:55:56 Duration: 776ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8028267)) AND (("cash_track"."id" not in (7296162)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-23 17:55:48 Duration: 604ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8020546)) AND (("cash_track"."id" not in (7231603, 7251326, 7253806, 7296113, 7296113)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-23 17:55:02 Duration: 460ms

15

32m9s

10,328

Details

154ms

257ms

186ms

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 23	00	710	2m6s	178ms
	01	912	2m47s	184ms
	02	2,678	8m17s	185ms
	03	2,371	7m33s	191ms
	04	2,805	8m49s	188ms
	05	852	2m33s	180ms

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

Date: 2025-01-23 03:04:49 Duration: 255ms
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" = '9757832')) 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, 43, 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-23 02:39:22 Duration: 251ms

16

18m19s

20,513

Details

39ms

117ms

53ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 23	07	37	1s765ms	47ms
	08	721	34s332ms	47ms
	09	1,020	51s239ms	50ms
	10	1,805	1m39s	55ms
	11	2,019	1m48s	53ms
	12	3,741	3m20s	53ms
	13	3,371	3m4s	54ms
	14	3,604	3m16s	54ms
	15	1,701	1m27s	51ms
	16	2,017	1m44s	51ms
	17	385	23s377ms	60ms
	18	42	2s872ms	68ms
	19	50	3s636ms	72ms

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

Date: 2025-01-23 13:48:58 Duration: 117ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4629720) ORDER BY "collection_policy"."id";

Date: 2025-01-23 14:17:58 Duration: 97ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4610829) ORDER BY "collection_policy"."id";

Date: 2025-01-23 10:59:17 Duration: 97ms

17

17m52s

2,166

Details

355ms

775ms

494ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 23	09	587	4m26s	453ms
	10	370	3m9s	511ms
	11	439	3m52s	529ms
	12	437	3m38s	500ms
	13	189	1m35s	506ms
	15	69	31s780ms	460ms
	16	6	2s711ms	451ms
	19	69	35s239ms	510ms

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

Date: 2025-01-23 11:57:39 Duration: 775ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9750576')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-23 11:57:41 Duration: 722ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '478083')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-23 10:51:34 Duration: 716ms

18

16m39s

6,406

Details

121ms

1s77ms

155ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 23	00	28	3s652ms	130ms
	01	36	4s709ms	130ms
	02	219	32s903ms	150ms
	06	19	2s512ms	132ms
	07	5	638ms	127ms
	08	70	9s247ms	132ms
	09	427	1m2s	145ms
	10	836	2m13s	160ms
	11	1,218	3m14s	159ms
	12	1,134	2m56s	155ms
	13	632	1m37s	153ms
	14	496	1m15s	153ms
	15	322	49s901ms	154ms
	16	176	26s898ms	152ms
	17	157	29s299ms	186ms
	18	194	32s255ms	166ms
	19	87	14s554ms	167ms
	20	132	20s6ms	151ms
	21	54	8s55ms	149ms
	22	164	23s929ms	145ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) 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-23 17:55:25 Duration: 1s77ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 28)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-23 17:58:22 Duration: 766ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) 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-23 17:54:27 Duration: 742ms

19

14m22s

4,350

Details

158ms

321ms

198ms

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

Day	Hour	Count	Duration	Avg duration
Jan 23	06	445	1m17s	174ms
	07	18	3s92ms	171ms
	08	185	32s405ms	175ms
	09	1,188	3m42s	187ms
	10	1,613	5m35s	208ms
	11	262	58s521ms	223ms
	13	69	12s762ms	184ms
	15	8	1s717ms	214ms
	16	7	1s416ms	202ms
	17	51	10s641ms	208ms
	18	51	11s825ms	231ms
	19	3	759ms	253ms
	21	450	1m33s	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" = '87026')) 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-23 10:59:16 Duration: 321ms
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" = '9902739')) 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-23 10:59:17 Duration: 318ms
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" = '9300796')) 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-23 10:59:21 Duration: 317ms

20

12m34s

2,726

Details

201ms

1s132ms

276ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 23	00	120	32s841ms	273ms
	01	120	32s412ms	270ms
	02	120	33s197ms	276ms
	03	120	33s145ms	276ms
	04	120	32s683ms	272ms
	05	120	32s411ms	270ms
	06	120	32s614ms	271ms
	07	120	32s351ms	269ms
	08	120	32s385ms	269ms
	09	120	34s452ms	287ms
	10	120	36s801ms	306ms
	11	120	38s142ms	317ms
	12	120	36s522ms	304ms
	13	120	37s35ms	308ms
	14	120	36s136ms	301ms
	15	120	36s735ms	306ms
	16	120	35s212ms	293ms
	17	116	32s827ms	282ms
	18	120	30s905ms	257ms
	19	120	29s427ms	245ms
	20	120	28s74ms	233ms
	21	120	27s580ms	229ms
	22	90	20s374ms	226ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-23 17:55:02 Duration: 1s132ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-23 17:59:03 Duration: 1s64ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-23 15:35:02 Duration: 441ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,492,739

Details

1m59s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 23	00	42,453	1s917ms	0ms
	01	36,736	1s508ms	0ms
	02	39,658	1s788ms	0ms
	03	41,863	1s942ms	0ms
	04	36,594	1s667ms	0ms
	05	22,962	860ms	0ms
	06	26,437	1s137ms	0ms
	07	28,179	1s204ms	0ms
	08	67,685	3s29ms	0ms
	09	157,036	7s288ms	0ms
	10	195,482	9s91ms	0ms
	11	215,980	11s224ms	0ms
	12	213,189	10s370ms	0ms
	13	212,330	9s775ms	0ms
	14	202,994	10s69ms	0ms
	15	193,768	9s998ms	0ms
	16	186,496	8s226ms	0ms
	17	147,198	6s893ms	0ms
	18	133,521	7s122ms	0ms
	19	111,625	5s515ms	0ms
	20	88,060	4s449ms	0ms
	21	55,509	2s657ms	0ms
	22	36,984	1s649ms	0ms

DISCARD ALL;

Date: 2025-01-23 15:15:00 Duration: 1ms
DISCARD ALL;

Date: 2025-01-23 19:11:38 Duration: 1ms
DISCARD ALL;

Date: 2025-01-23 19:23:29 Duration: 1ms

2

1,962,095

Details

28s695ms

0ms

14ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 23	00	30,871	452ms	0ms
	01	26,803	370ms	0ms
	02	30,248	455ms	0ms
	03	32,961	503ms	0ms
	04	27,961	426ms	0ms
	05	16,424	243ms	0ms
	06	20,488	310ms	0ms
	07	21,724	318ms	0ms
	08	54,472	734ms	0ms
	09	129,442	1s774ms	0ms
	10	159,547	2s233ms	0ms
	11	175,350	2s607ms	0ms
	12	170,995	2s416ms	0ms
	13	167,788	2s335ms	0ms
	14	157,084	2s268ms	0ms
	15	149,541	2s239ms	0ms
	16	144,659	1s897ms	0ms
	17	115,992	1s754ms	0ms
	18	104,822	1s772ms	0ms
	19	86,466	1s384ms	0ms
	20	68,252	1s83ms	0ms
	21	42,305	675ms	0ms
	22	27,900	436ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-23 13:23:42 Duration: 14ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-23 13:48:19 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-23 15:39:58 Duration: 1ms

3

1,268,453

Details

12s985ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 23	00	21,977	202ms	0ms
	01	19,040	178ms	0ms
	02	20,550	198ms	0ms
	03	21,620	209ms	0ms
	04	18,944	174ms	0ms
	05	12,081	98ms	0ms
	06	13,882	125ms	0ms
	07	14,731	128ms	0ms
	08	34,811	304ms	0ms
	09	79,827	766ms	0ms
	10	98,925	1s43ms	0ms
	11	109,421	1s170ms	0ms
	12	107,720	1s134ms	0ms
	13	107,553	1s106ms	0ms
	14	102,728	1s32ms	0ms
	15	98,110	1s35ms	0ms
	16	94,245	931ms	0ms
	17	74,599	810ms	0ms
	18	68,114	786ms	0ms
	19	56,805	616ms	0ms
	20	44,938	457ms	0ms
	21	28,629	283ms	0ms
	22	19,203	190ms	0ms

ROLLBACK;

Date: 2025-01-23 03:05:12 Duration: 0ms
ROLLBACK;

Date: 2025-01-23 11:19:43 Duration: 0ms
ROLLBACK;

Date: 2025-01-23 12:22:43 Duration: 0ms

4

1,256,196

Details

3m44s

0ms

21ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 23	00	21,225	3s566ms	0ms
	01	18,414	3s66ms	0ms
	02	19,853	3s442ms	0ms
	03	20,913	3s680ms	0ms
	04	18,274	3s74ms	0ms
	05	11,448	1s511ms	0ms
	06	13,223	1s989ms	0ms
	07	14,074	2s96ms	0ms
	08	34,167	4s993ms	0ms
	09	79,266	13s638ms	0ms
	10	98,840	17s955ms	0ms
	11	109,280	19s182ms	0ms
	12	107,597	18s988ms	0ms
	13	107,315	18s680ms	0ms
	14	102,602	17s189ms	0ms
	15	97,456	16s896ms	0ms
	16	93,875	15s645ms	0ms
	17	73,937	14s463ms	0ms
	18	67,342	14s453ms	0ms
	19	56,114	11s856ms	0ms
	20	44,469	8s917ms	0ms
	21	27,932	5s646ms	0ms
	22	18,580	3s729ms	0ms

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

Date: 2025-01-23 14:22:48 Duration: 21ms
SELECT payload FROM http_sessions WHERE sid = '5a196dc0574579b87a9826b753ebd56b53c971e1';

Date: 2025-01-23 16:11:23 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '5e4f957e4e3e766e7d5f923a487227349529573f';

Date: 2025-01-23 15:01:49 Duration: 15ms

5

1,246,362

Details

1m53s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 23	00	21,261	1s803ms	0ms
	01	18,447	1s581ms	0ms
	02	19,884	1s757ms	0ms
	03	21,004	1s839ms	0ms
	04	18,359	1s563ms	0ms
	05	11,554	872ms	0ms
	06	13,284	1s79ms	0ms
	07	14,161	1s142ms	0ms
	08	33,840	2s670ms	0ms
	09	78,425	6s927ms	0ms
	10	97,668	9s99ms	0ms
	11	107,958	9s951ms	0ms
	12	106,538	9s877ms	0ms
	13	106,069	9s675ms	0ms
	14	101,497	8s962ms	0ms
	15	96,815	8s871ms	0ms
	16	93,248	8s282ms	0ms
	17	73,526	7s100ms	0ms
	18	66,700	6s585ms	0ms
	19	55,803	5s349ms	0ms
	20	44,089	4s18ms	0ms
	21	27,735	2s485ms	0ms
	22	18,497	1s681ms	0ms

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

Date: 2025-01-23 17:55:03 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-23 17:57:49 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-23 02:42:19 Duration: 1ms

6

897,697

Details

2m15s

0ms

12ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 23	00	11,743	1s817ms	0ms
	01	9,772	1s462ms	0ms
	02	11,742	1s916ms	0ms
	03	13,778	2s275ms	0ms
	04	10,291	1s793ms	0ms
	05	5,116	907ms	0ms
	06	8,255	1s367ms	0ms
	07	8,172	1s338ms	0ms
	08	25,662	3s400ms	0ms
	09	65,227	8s970ms	0ms
	10	79,309	11s608ms	0ms
	11	86,691	14s165ms	0ms
	12	82,283	12s756ms	0ms
	13	77,794	11s234ms	0ms
	14	71,707	10s886ms	0ms
	15	69,180	11s64ms	0ms
	16	66,807	8s841ms	0ms
	17	53,010	7s943ms	0ms
	18	46,765	7s477ms	0ms
	19	37,475	5s920ms	0ms
	20	29,651	4s518ms	0ms
	21	16,818	2s560ms	0ms
	22	10,449	1s586ms	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 (989, 988);

Date: 2025-01-23 15:35:28 Duration: 12ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (844);

Date: 2025-01-23 15:20:24 Duration: 11ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (870);

Date: 2025-01-23 09:35:25 Duration: 10ms

7

692,642

Details

2m2s

0ms

50ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 23	00	8,864	1s673ms	0ms
	01	7,760	1s510ms	0ms
	02	9,699	1s752ms	0ms
	03	11,340	2s123ms	0ms
	04	9,020	1s915ms	0ms
	05	4,339	782ms	0ms
	06	6,606	994ms	0ms
	07	6,993	988ms	0ms
	08	19,634	2s752ms	0ms
	09	49,486	7s535ms	0ms
	10	60,474	10s743ms	0ms
	11	65,902	12s105ms	0ms
	12	63,178	11s308ms	0ms
	13	60,088	10s291ms	0ms
	14	54,361	9s523ms	0ms
	15	51,344	9s169ms	0ms
	16	50,361	8s502ms	0ms
	17	41,302	7s285ms	0ms
	18	36,688	7s348ms	0ms
	19	29,633	5s655ms	0ms
	20	23,294	4s651ms	0ms
	21	13,611	2s567ms	0ms
	22	8,665	1s525ms	0ms

COMMIT;

Date: 2025-01-23 16:12:28 Duration: 50ms
COMMIT;

Date: 2025-01-23 10:44:45 Duration: 35ms
COMMIT;

Date: 2025-01-23 10:49:46 Duration: 35ms

8

545,205

Details

37s820ms

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

Day	Hour	Count	Duration	Avg duration
Jan 23	00	7,009	438ms	0ms
	01	5,298	320ms	0ms
	02	5,343	366ms	0ms
	03	5,917	394ms	0ms
	04	3,348	216ms	0ms
	05	2,394	128ms	0ms
	06	5,145	278ms	0ms
	07	4,682	268ms	0ms
	08	13,988	754ms	0ms
	09	37,716	2s543ms	0ms
	10	49,084	3s765ms	0ms
	11	53,239	4s88ms	0ms
	12	49,873	3s716ms	0ms
	13	47,425	3s450ms	0ms
	14	42,534	3s38ms	0ms
	15	40,803	2s840ms	0ms
	16	42,243	2s766ms	0ms
	17	34,147	2s362ms	0ms
	18	31,214	2s143ms	0ms
	19	25,522	1s728ms	0ms
	20	20,291	1s156ms	0ms
	21	11,455	667ms	0ms
	22	6,535	386ms	0ms

SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 13, 115, 75, 28, 123, 27, 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, 128, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);

Date: 2025-01-23 10:43:44 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 (49);

Date: 2025-01-23 13:53:52 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68);

Date: 2025-01-23 10:49:15 Duration: 1ms

9

539,991

Details

1m13s

0ms

8ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 23	00	9,509	1s64ms	0ms
	01	7,575	863ms	0ms
	02	8,157	913ms	0ms
	03	9,237	1s122ms	0ms
	04	4,955	689ms	0ms
	05	2,657	311ms	0ms
	06	6,066	770ms	0ms
	07	3,312	425ms	0ms
	08	13,341	1s521ms	0ms
	09	37,938	5s247ms	0ms
	10	47,440	7s156ms	0ms
	11	53,063	7s807ms	0ms
	12	47,223	7s142ms	0ms
	13	43,129	5s965ms	0ms
	14	40,793	6s4ms	0ms
	15	40,851	6s103ms	0ms
	16	39,967	5s72ms	0ms
	17	32,173	4s489ms	0ms
	18	30,147	3s949ms	0ms
	19	24,386	3s128ms	0ms
	20	19,711	2s152ms	0ms
	21	11,798	1s242ms	0ms
	22	6,563	716ms	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 (5099329, 5099144, 5099009, 5102148, 5127765, 5108493, 5099712, 5484559, 5099401, 5099130, 5100232, 5099131, 5154923, 5103766, 5121625, 5100443, 5100877, 5110416, 5104276, 5099102, 5101468, 5099333, 5099296, 5476512, 5120039, 5099489, 5099138, 5111065, 5483382, 5099006, 5100319, 5102075, 5101461, 5099941, 5099609, 5099848, 5101022, 5099200, 5099334, 5099223, 5248426, 5101702, 5128745, 5099415, 5481749, 5104081, 5100252, 5103947, 5099422, 5106556, 5099013, 5100202, 5100067, 5102352, 5101644, 5100218, 5099095, 5099590, 5484757, 5099243, 5100246, 5099540, 5385534, 5470749, 5107836, 5101206, 5416402, 5099045, 5483291, 5101295, 5134416, 5100800, 5099028, 5328572, 5099105, 5099206, 5099224, 5099393, 5099117, 5099135, 5099007, 5102658, 5099427, 5103352, 5116743, 5099128, 5099159, 5100726, 5100607, 5102186, 5446692, 5099481, 5100822, 5101164, 5100204, 5102323, 5099167, 5099236, 5100074, 5114680, 5228115, 5099499, 5126144, 5099523, 5099035, 5100952, 5101279, 5099306, 5102665, 5099491, 5102770, 5100189, 5193500, 5439145, 5099014, 5099119, 5118312, 5107508, 5099961, 5099867, 5112308, 5100791, 5484761, 5099202, 5106226, 5101020, 5100150, 5099309, 5100628, 5099170, 5099914, 5100762, 5098994, 5107206, 5100540, 5245825, 5100181, 5099445, 5100233, 5099010, 5480121, 5100514, 5267828, 5427239, 5099921, 5113765, 5327308, 5121494, 5461907, 5154379, 5100729, 5106454, 5262409);

Date: 2025-01-23 17:21:55 Duration: 8ms
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 (5483501, 5468414, 5099008, 5118651, 5099348, 5119793, 5106960, 5124557, 5116789, 5112160, 5163847, 5207113, 5159386, 5103598, 5101538, 5110784, 5482305, 5260946, 5104762, 5119979, 5169191, 5109066, 5475108, 5100919, 5331793, 5100740, 5320313, 5111876, 5105117, 5102988, 5446690, 5099644, 5446691, 5099678, 5127194, 5114481, 5117003, 5440772, 5111521, 5478499, 5099181, 5101684, 5099169, 5099671, 5105152, 5484549, 5170833, 5350861, 5127908, 5130730, 5108463, 5261751, 5281400, 5203921, 5485732, 5101027, 5099140, 5215005, 5108326, 5101884, 5099290, 5100869, 5105196, 5116650, 5102376, 5108912, 5099149, 5103658, 5105057, 5099141, 5409940, 5267316, 5246596, 5121073, 5170213, 5474104, 5114450, 5484548, 5099522);

Date: 2025-01-23 17:21:55 Duration: 7ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099008, 5282724, 5105834, 5099604, 5485824, 5114338, 5471716, 5101084, 5099007, 5140185, 5105731, 5104938, 5099174, 5104885, 5099264, 5100700, 5103947, 5099252, 5478997, 5485952, 5112921, 5101642, 5099141, 5099009, 5100707, 5099103, 5191759, 5102612, 5099263, 5104278, 5118073, 5102186, 5099445, 5101444, 5098996, 5101322, 5099243, 5192643, 5124564, 5313962, 5105115, 5480260, 5103821, 5099204, 5099129, 5099014, 5105977, 5099446, 5099636, 5099190, 5099181, 5149623, 5099035, 5099248, 5099967, 5099200, 5099585, 5155564, 5099690, 5099285, 5099272, 5099138, 5099319, 5099331, 5099111, 5101213, 5099002, 5099382, 5100202, 5123598, 5099177, 5102774, 5101592, 5100917, 5099010, 5099650, 5100511, 5101653, 5101617, 5103989, 5099013, 5100762, 5115048, 5099244, 5101271, 5119250, 5101415, 5102190, 5099413, 5486007, 5099885, 5136122, 5101483, 5099540, 5181311, 5208811, 5099590, 5286295, 5124491, 5439450, 5099602, 5099250, 5099357, 5132309, 5100824, 5099006, 5101362, 5099045, 5153217, 5230031, 5099693, 5099130, 5100729, 5153273, 5099642, 5484801, 5099300, 5483990, 5180087, 5484585, 5115068, 5099254, 5099144);

Date: 2025-01-23 17:21:55 Duration: 7ms

10

392,046

Details

2m9s

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 23	00	3,963	1s142ms	0ms
	01	2,891	840ms	0ms
	02	2,323	727ms	0ms
	03	2,055	659ms	0ms
	04	1,003	326ms	0ms
	05	721	213ms	0ms
	06	1,516	434ms	0ms
	07	1,855	550ms	0ms
	08	8,651	2s466ms	0ms
	09	28,722	9s96ms	0ms
	10	35,506	12s350ms	0ms
	11	34,815	12s253ms	0ms
	12	42,958	14s585ms	0ms
	13	41,950	14s10ms	0ms
	14	24,505	8s362ms	0ms
	15	23,642	8s154ms	0ms
	16	37,922	12s141ms	0ms
	17	29,166	10s117ms	0ms
	18	20,921	7s41ms	0ms
	19	20,222	6s575ms	0ms
	20	13,383	3s981ms	0ms
	21	7,561	2s114ms	0ms
	22	5,795	1s635ms	0ms

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

Date: 2025-01-23 11:52:13 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.partner' 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 = 939) OR r.global) ORDER BY r.id;

Date: 2025-01-23 15:37: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 = 1220) OR r.global) ORDER BY r.id;

Date: 2025-01-23 16:29:00 Duration: 2ms

11

374,708

Details

1m12s

0ms

2ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 23	00	4,813	807ms	0ms
	01	3,217	578ms	0ms
	02	3,244	633ms	0ms
	03	3,819	758ms	0ms
	04	2,304	468ms	0ms
	05	1,775	257ms	0ms
	06	3,043	492ms	0ms
	07	3,078	490ms	0ms
	08	11,830	1s732ms	0ms
	09	27,986	5s78ms	0ms
	10	32,275	6s745ms	0ms
	11	35,433	7s442ms	0ms
	12	35,135	7s125ms	0ms
	13	34,475	6s847ms	0ms
	14	31,052	5s982ms	0ms
	15	30,709	6s30ms	0ms
	16	29,733	5s522ms	0ms
	17	22,760	4s542ms	0ms
	18	19,023	3s941ms	0ms
	19	15,961	3s109ms	0ms
	20	11,807	2s100ms	0ms
	21	7,059	1s240ms	0ms
	22	4,177	724ms	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 (8004724, 8004658, 8004676, 8004662, 8006320, 8006396, 8007763, 8004653, 8004697, 8004665, 8004664, 8004688, 8004716, 8006393, 8007174, 8004708, 8006397, 8004646, 2, 8007456);

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

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

Date: 2025-01-23 15:21:22 Duration: 2ms

12

291,272

Details

56s22ms

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 23	00	3,271	522ms	0ms
	01	2,337	350ms	0ms
	02	2,121	321ms	0ms
	03	2,120	308ms	0ms
	04	1,550	203ms	0ms
	05	1,019	140ms	0ms
	06	1,351	192ms	0ms
	07	1,990	287ms	0ms
	08	8,784	1s291ms	0ms
	09	23,672	4s241ms	0ms
	10	26,611	5s539ms	0ms
	11	23,762	5s5ms	0ms
	12	30,158	6s203ms	0ms
	13	29,690	6s24ms	0ms
	14	17,489	3s306ms	0ms
	15	18,429	3s543ms	0ms
	16	25,795	5s3ms	0ms
	17	20,722	4s362ms	0ms
	18	14,918	2s940ms	0ms
	19	14,698	2s850ms	0ms
	20	9,573	1s625ms	0ms
	21	6,404	988ms	0ms
	22	4,808	767ms	0ms

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

Date: 2025-01-23 11:52:13 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-23 17:56:21 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 826 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-23 13:05:46 Duration: 2ms

13

261,530

Details

1d21h21m49s

491ms

4s959ms

624ms

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 23	00	8,079	1h19m56s	593ms
	01	7,549	1h13m57s	587ms
	02	9,355	1h33m	596ms
	03	11,628	1h53m41s	586ms
	04	8,717	1h23m19s	573ms
	05	2,107	19m44s	562ms
	06	4,275	43m7s	605ms
	07	3,869	36m20s	563ms
	08	4,279	40m14s	564ms
	09	11,195	1h53m20s	607ms
	10	17,548	3h13m37s	662ms
	11	20,398	3h47m50s	670ms
	12	16,693	3h30s	648ms
	13	14,541	2h36m7s	644ms
	14	15,828	2h52m6s	652ms
	15	17,319	3h10m1s	658ms
	16	13,754	2h25m53s	636ms
	17	10,902	1h59m56s	660ms
	18	21,502	3h43m38s	624ms
	19	17,043	2h54m42s	615ms
	20	10,831	1h44m55s	581ms
	21	8,957	1h26m16s	577ms
	22	5,161	49m27s	574ms

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

Date: 2025-01-23 17:55:48 Duration: 4s959ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4722893)) AND (("shipping_track"."id" not in (39106685, 39106685)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:55:25 Duration: 4s888ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4723127)) AND (("shipping_track"."id" not in (39107471, 39107471)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:57:55 Duration: 4s302ms

14

251,010

Details

1m5s

0ms

34ms

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 23	00	4,856	1s193ms	0ms
	01	3,819	948ms	0ms
	02	4,460	1s65ms	0ms
	03	4,251	1s109ms	0ms
	04	2,173	916ms	0ms
	05	967	251ms	0ms
	06	2,921	844ms	0ms
	07	1,444	399ms	0ms
	08	5,503	1s243ms	0ms
	09	15,462	4s230ms	0ms
	10	19,532	5s654ms	0ms
	11	22,436	6s295ms	0ms
	12	20,984	5s746ms	0ms
	13	21,359	5s27ms	0ms
	14	19,840	4s999ms	0ms
	15	18,130	4s968ms	0ms
	16	19,555	4s332ms	0ms
	17	15,073	4s214ms	0ms
	18	15,196	3s847ms	0ms
	19	12,662	3s240ms	0ms
	20	10,064	2s336ms	0ms
	21	6,360	1s600ms	0ms
	22	3,963	979ms	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 (32669034, 42087070, 32217863, 42097051, 42147629, 42151617, 42161135, 41893392, 41539678, 41778010, 42123822, 32661529, 42149932, 32235518, 32235364, 42113398, 41932426, 32267783, 32268192, 32213265, 42101461, 42104793, 41298323, 32204531, 42048987, 42177038, 41544739, 32194539, 41856080, 40504309, 42131986, 42096883, 32201842, 42147588, 32202644, 41777991, 42102928, 42036043, 42134700, 42145043, 42146105, 42146112, 32219633, 41819888, 32218061, 41693471, 32667389, 42085449, 32246543, 42127393, 42147437, 42103351, 32213131, 42137624, 32194541, 42145993, 42053937, 42172894, 41545109, 42020950, 42061472, 41861992, 42096391, 32663086, 32185630, 32194237, 42150422, 32194341, 42150231, 42124468, 41862009, 32663350, 42171839, 42171841, 42086810, 32666568, 32219363, 42140505, 32662008, 42171880, 42113745, 42146152, 42071066, 32654646, 42146133, 41251024, 42166939, 41905586, 32204510, 42127586, 41777648, 42133696, 42147449, 42124635, 32208261, 32213237, 42171650, 42171825, 32218778, 32219169, 32219166, 32661566, 42033046, 32204840, 41901184, 32246500, 32246218, 32246216, 41883421, 42138406, 32219557, 32219544, 42145187, 42145219, 42144480, 32259694, 42138390, 32259687, 32214497, 32197886, 32222268, 42105124, 42103454, 42103455, 32235369, 41473163, 42096288, 32661947, 41800563, 32196666, 32259295, 42036884, 32219511, 42023690, 32199155, 32196688, 42054373, 32200891, 41961739, 32205513, 42151548, 32200697, 42053939, 32245846, 42037587, 42150110, 42150109, 32203384, 42166837, 32245735, 32203316, 42103419, 42103469, 41545117, 42124603, 42151351, 32204874, 42024566, 32203374, 42100524, 42173102, 32194551, 42145302, 42049539, 32203241, 32202656, 42096891, 42049958, 42146103, 42173123, 41693473, 41944723, 32203139, 42177049, 42149929);

Date: 2025-01-23 17:21:55 Duration: 34ms
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 (32185419, 41690841, 32178658, 42056988, 42056886, 41421225, 42086797, 32202970, 32193999, 41776727, 42172721, 42167201, 42172324, 42131459, 42123050, 41800007, 42091628, 42098488, 42088686, 41909244, 42136132, 41993657, 42097735, 42139570, 41993346, 42101750, 32192530, 42132531, 42008171, 42099385, 42132507, 42023573, 42144984, 42126942, 41994179, 41934203, 42007505, 41687535, 41993329, 42052142, 42008334, 41735640, 41836749, 41954946, 41777574, 41543230);

Date: 2025-01-23 17:21:55 Duration: 13ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (42170631, 42031883, 42158347, 42088892, 32245230, 41830288, 42103048, 42159390, 32204900, 32204898, 42158336, 32255039, 32179163, 41940639, 42168851, 41778021, 42105350, 32266297, 41976559, 42037285, 32214065, 41929009, 32245101, 32278043, 41752037, 42062739, 32222607, 42074496, 40698280, 32269226, 32207448, 32654842, 42079009, 42178555, 32655093, 32179156, 41972069, 32654785, 41838626, 32204656, 32213274, 32202749, 42082429, 32231002, 32657501, 32661528, 41994422, 32187863, 32182312, 32184045, 32231543, 42158419, 41277939, 32203675, 41884766, 32245202, 42104901, 42156656, 32269306, 41771528, 42155901, 42158303, 32200046, 41545071, 32245294, 32245446, 32245250, 42081353, 42165194, 42164759, 40330734, 42142704, 42030983, 32277688, 42175983, 42168899, 41929007);

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

15

185,366

Details

15s642ms

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 23	00	2,519	144ms	0ms
	01	2,065	116ms	0ms
	02	2,211	136ms	0ms
	03	2,557	161ms	0ms
	04	1,331	81ms	0ms
	05	900	47ms	0ms
	06	1,817	96ms	0ms
	07	1,235	65ms	0ms
	08	4,847	251ms	0ms
	09	13,511	862ms	0ms
	10	16,956	1s382ms	0ms
	11	19,077	1s658ms	0ms
	12	17,428	1s587ms	0ms
	13	16,112	1s490ms	0ms
	14	14,746	1s522ms	0ms
	15	14,441	1s372ms	0ms
	16	14,357	991ms	0ms
	17	10,886	917ms	0ms
	18	9,783	920ms	0ms
	19	7,616	754ms	0ms
	20	6,147	763ms	0ms
	21	3,142	200ms	0ms
	22	1,682	118ms	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-23 22:03:38 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-23 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-23 14:47:32 Duration: 1ms

16

169,699

Details

10s308ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 23	00	1,794	91ms	0ms
	01	1,188	59ms	0ms
	02	960	49ms	0ms
	03	773	41ms	0ms
	04	374	18ms	0ms
	05	328	16ms	0ms
	06	598	30ms	0ms
	07	796	40ms	0ms
	08	3,770	185ms	0ms
	09	12,827	742ms	0ms
	10	15,544	1s15ms	0ms
	11	14,413	951ms	0ms
	12	18,312	1s169ms	0ms
	13	17,974	1s115ms	0ms
	14	9,804	601ms	0ms
	15	10,068	629ms	0ms
	16	16,455	971ms	0ms
	17	13,050	843ms	0ms
	18	9,211	563ms	0ms
	19	9,172	546ms	0ms
	20	5,957	315ms	0ms
	21	3,564	172ms	0ms
	22	2,767	138ms	0ms

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

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

Date: 2025-01-23 15:05:22 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2025-01-23 15:21:36 Duration: 0ms

17

161,846

Details

21s223ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 23	00	1,656	180ms	0ms
	01	1,074	116ms	0ms
	02	917	102ms	0ms
	03	757	88ms	0ms
	04	354	37ms	0ms
	05	307	32ms	0ms
	06	583	62ms	0ms
	07	792	84ms	0ms
	08	3,667	386ms	0ms
	09	12,461	1s543ms	0ms
	10	15,113	2s147ms	0ms
	11	13,969	2s9ms	0ms
	12	17,637	2s431ms	0ms
	13	16,946	2s254ms	0ms
	14	9,282	1s228ms	0ms
	15	9,490	1s283ms	0ms
	16	15,459	1s971ms	0ms
	17	12,330	1s741ms	0ms
	18	8,848	1s166ms	0ms
	19	8,630	1s108ms	0ms
	20	5,644	639ms	0ms
	21	3,460	351ms	0ms
	22	2,470	255ms	0ms

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

Date: 2025-01-23 15:21:36 Duration: 2ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (33) 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-23 09:57:16 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 (21) 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-23 10:38:14 Duration: 1ms

18

155,653

Details

1m30s

0ms

54ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 23	00	709	422ms	0ms
	01	204	118ms	0ms
	02	181	115ms	0ms
	03	248	153ms	0ms
	04	191	122ms	0ms
	05	109	56ms	0ms
	06	469	176ms	0ms
	07	691	267ms	0ms
	08	3,406	1s652ms	0ms
	09	6,599	3s962ms	0ms
	10	9,327	6s	0ms
	11	12,452	7s886ms	0ms
	12	12,571	8s7ms	0ms
	13	14,036	8s258ms	0ms
	14	17,763	10s521ms	0ms
	15	21,800	12s741ms	0ms
	16	12,367	6s810ms	0ms
	17	12,319	7s129ms	0ms
	18	18,262	9s706ms	0ms
	19	8,113	4s529ms	0ms
	20	2,186	1s281ms	0ms
	21	920	575ms	0ms
	22	730	474ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4068542, 4311848, 1455078, 1237786, 1749481, 3504139, 1159165, 2030341, 510469, 2070212, 2324746, 1328233, 4424128, 2505234, 1109113, 2353707, 4311707, 3440475, 1412491, 4012361, 4088920, 2154706, 1412089, 2093766, 1920450, 3426923, 4512944, 1414154, 3169210, 2522105, 3230092, 1552532, 2089022, 2980023, 3280444, 1941199, 1839266, 1436168, 1289446, 3799363, 4651689, 4566496, 4596919, 2050201, 2197223, 4277008, 2180754, 1525056, 4578088, 3366524, 2919796, 2170353, 4009507, 3917264, 2176274, 2328440, 4276875, 4338543, 1475023, 3726081, 4651456, 2053236, 4647561, 3072653, 4304539, 3075095, 3398853, 4143344, 2479243, 1105994, 3564379, 3920855, 2551734, 2052395, 1593033, 3624446, 1877581, 3767504, 1694323, 1782300, 3454645, 2735879, 976160, 1249202, 3727278, 3145507, 3849903, 3597385, 4602061, 3329935, 3667075, 3858799, 4027498, 3918686, 1347129, 1909194, 4472356, 1083395, 4114690, 3706057, 1313035, 3173135, 3241755, 1779890, 2015383, 1547053, 1942194, 3348634, 1313428, 3174677, 2888767, 4612200, 1558737, 3592161, 1553963, 1830646, 4244718, 3946025, 4568526, 1922454, 2975393, 3063874, 1552060, 999633, 4032399, 2677606, 1018624, 2824775, 2384337, 2477458, 3923819, 4487432, 1819096, 1900682, 3883309, 4524303, 3247260, 2352665, 2092771, 1399440, 2142174, 3513121, 1804502, 1713315, 3684333, 1902874, 3696789, 2335181, 2992427, 4032046, 2489828, 1455501, 3552435, 1323562, 3981015, 4169383, 1408332, 4028459, 4279508, 2753752, 4414416, 4414284, 4333913, 1619692, 2053568, 4370685, 3119604, 2006036, 1485163, 4419113, 1933785, 2711345, 4019412, 1684149, 3215148, 983546, 1585210, 1527386, 4403663, 1040447, 2938051, 1279861, 4169402, 2680984, 3850564, 1707417, 1364736, 1790973, 4191270, 3592141, 1458653, 3171480, 4142111, 3144753, 978947, 3849004, 1993454, 3591201, 1781967);

Date: 2025-01-23 17:21:56 Duration: 54ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4697046, 4706031, 4704008, 4688706, 4644174, 4656433, 4664142, 4660195, 4610618, 4662337, 4639520, 4666368, 4561386, 4657238, 4675210, 4682077, 4394321, 4590527, 4477954, 4678091, 4705594, 4648615, 4683554, 4582266, 4648579, 4631183, 4618843, 4619434, 4647122, 4600358, 4288062, 4648577, 4633519, 4657723, 4540336, 4671007, 4627252, 4650001, 4604625, 4584987, 4632337, 4603734, 4626907, 4667895, 4674123, 4626956, 4626835, 4656065, 4124997, 4290212, 4337011, 4368343, 4406071, 4418678, 4435120, 4442758, 4456393, 4458599, 4461718, 4469676, 4504921, 4505075, 4509536, 4510137, 4523047, 4523501, 4529283, 4530844, 4540426, 4540456, 4543136, 4544999, 4551834, 4478884, 4699227, 4692160, 4687114, 4659712, 4654741, 4682081, 4651152, 4391951, 4399139, 4432028, 4487478, 4506744, 4509560, 4510520, 4515041, 4517111, 4523502, 4531164, 4531986, 4532002, 4533140, 4533285, 4538368, 4547009, 4547238, 4548291, 4548310, 4549178, 4550031, 4553138, 4553169, 4668780, 4674146, 4662426, 4675590, 4673624, 4672949, 4656862, 4625790, 4670482, 4674109, 4659649, 4104702, 4125658, 4287002, 4410963, 4433670, 4489213, 4500698, 4501111, 4501958, 4508687, 4509725, 4510840, 4511975, 4515079, 4516821, 4522721, 4523498, 4527500, 4534946, 4536000, 4539196, 4543052, 4544764, 4547552, 4567823, 4558413, 4576799, 4673396, 4646670, 4603875, 4604133, 4411991, 4589271, 4637692, 4615451, 4637887, 4654311, 4517519, 4435587, 4457518, 4466273, 4426671, 4430544, 4541147, 4251288, 4409286, 4579024, 4426417, 4550385, 4447581, 4556004, 4453349, 4340127, 4457305, 4405964, 4539355, 4587881, 4426622, 4570754, 4595012, 4407189, 4281326, 4209816, 4314528, 4430562, 4444272, 4450575, 4496761, 4504433, 4514570, 4516791, 4516824);

Date: 2025-01-23 17:21:55 Duration: 39ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4603219, 4281139, 4527510, 4426147, 4655766, 3518745, 4119095, 4624983, 2739596, 2739592, 4600412, 2785166, 4609180, 4568211, 4176440, 4599042, 4574000, 4574001, 4628384, 4454332, 4497279, 4655842, 4655844, 4628308, 4624950, 4454338, 4454339, 4600401, 4497280, 4531791, 4600404, 4574007, 4624948, 4599040, 4145412, 4628370, 4279936, 4496510, 4624952, 4496552, 4573990, 4655771, 4655770, 4568562, 4662346, 4655845, 4568254, 4568206, 4456365, 4250015, 4568223, 4568221, 4603216, 4659052, 4599055, 4426213, 4628325, 4599062, 4527389, 4628320, 4599058, 4628317, 4628322, 4599054, 4628315, 4527402, 4527391, 4527411, 4624975, 4628353, 4599059, 4628346, 4599064, 4599057, 4599063, 4599066, 4624976, 4531792, 4527417, 4599048, 4456366, 4192578, 4454313, 4527426, 4528090, 4278905, 4455661, 4497272, 4527433, 4377504, 4528093, 4432411, 4455662, 4569773, 4527424, 4278903, 4628376, 4684349, 3856427, 3856429, 3856424, 3856425, 3856423, 3856422, 3856426, 4196422, 3856428, 4568709, 4631520, 4600407, 4248433, 4628383, 4196393, 4527484, 4527448, 4343145, 4306197, 4196399, 4382582, 4659040, 4196412, 4379873, 4343138, 4628381, 4628290, 4309318, 4568226, 4529008, 4659027, 4569774, 4600396, 4655781, 3287719, 4655778, 4632907, 4655776, 4655775, 4632896, 4632912, 3582560, 4624954, 4624957, 4624958, 3706057, 4062331, 4607326, 4581149, 4624961, 4496542, 4454289, 4454296, 4454292, 3670311, 4568218, 4384207, 4655769, 4628394, 4624946, 3567704, 4503582, 4496532, 4655270, 4503574, 4496550, 4531816, 1005997, 4628298, 4599082, 4600413, 4529683, 4196433, 4628292, 4600417, 4568255, 4426187, 4625272, 4529019, 4455658, 4529013, 4527415, 4531788, 4248326, 4527499, 4599045, 4279927, 4405222, 4145409, 4145415, 4145413, 4119092, 4145416, 4145414, 4145411, 4145418, 4119090, 4498245, 4498244, 4624945, 4119093);

Date: 2025-01-23 17:21:55 Duration: 31ms

19

152,799

Details

2h21m20s

37ms

338ms

55ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 23	00	3,706	3m15s	52ms
	01	2,525	2m12s	52ms
	02	2,906	2m34s	53ms
	03	4,033	3m34s	53ms
	04	2,566	2m15s	52ms
	05	865	45s449ms	52ms
	06	1,232	1m5s	53ms
	07	1,068	56s435ms	52ms
	08	2,850	2m29s	52ms
	09	8,509	7m58s	56ms
	10	12,627	12m47s	60ms
	11	15,468	15m44s	61ms
	12	14,529	14m24s	59ms
	13	12,265	11m59s	58ms
	14	11,053	10m52s	59ms
	15	8,695	8m35s	59ms
	16	8,499	8m4s	56ms
	17	7,340	6m35s	53ms
	18	7,848	6m31s	49ms
	19	8,821	7m	47ms
	20	7,147	5m27s	45ms
	21	5,396	4m3s	45ms
	22	2,851	2m6s	44ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4678716, 4664560, 4597630)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:57:53 Duration: 338ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4698780, 4697665, 4695111, 4695038, 4691774, 4691357, 4691107, 4691101, 4689523, 4688842, 4661228, 4661036, 4640064, 4637230, 4612794, 4599388, 4584549)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:55:21 Duration: 285ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4708234, 4502517)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:59:09 Duration: 284ms

20

141,179

Details

46s616ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 23	00	10,076	2s980ms	0ms
	01	8,561	2s606ms	0ms
	02	10,978	3s392ms	0ms
	03	9,681	3s252ms	0ms
	04	5,680	2s85ms	0ms
	05	767	307ms	0ms
	06	5,057	1s583ms	0ms
	07	1,733	732ms	0ms
	08	874	368ms	0ms
	09	916	430ms	0ms
	10	1,543	881ms	0ms
	11	2,111	1s130ms	0ms
	12	1,068	521ms	0ms
	13	2,548	1s9ms	0ms
	14	2,340	933ms	0ms
	15	4,272	1s505ms	0ms
	16	6,553	2s226ms	0ms
	17	9,668	3s610ms	0ms
	18	12,746	4s260ms	0ms
	19	12,935	4s69ms	0ms
	20	11,634	3s350ms	0ms
	21	11,606	3s258ms	0ms
	22	7,832	2s117ms	0ms

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

Date: 2025-01-23 06:06:07 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 19) AND ("price_list"."to_office_id" = 8)) ORDER BY "price_list"."id";

Date: 2025-01-23 18:51:04 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 26) AND ("price_list"."to_office_id" = 24)) ORDER BY "price_list"."id";

Date: 2025-01-23 02:42:49 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

41m17s

2m11s

328

Details

11h58m38s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 23	00	7	2ms	0ms
	01	3	3ms	1ms
	02	8	9ms	1ms
	03	5	3ms	0ms
	04	5	3ms	0ms
	05	2	1ms	0ms
	06	3	0ms	0ms
	07	1	0ms	0ms
	08	16	5ms	0ms
	09	36	33m13s	55s361ms
	10	29	1h14m5s	2m33s
	11	19	18m32s	58s569ms
	12	26	2h28m35s	5m42s
	13	31	28m31s	55s216ms
	14	15	15ms	1ms
	15	23	41m17s	1m47s
	16	10	15ms	1ms
	17	14	20ms	1ms
	18	11	11ms	1ms
	19	21	13m54s	39s720ms
	20	1	0ms	0ms
	21	20	1h23m56s	4m11s
	22	22	4h36m32s	12m34s

UPDATE "res_users" SET "exp_date" = '2025-01-23 14:23:28.958397', "last_update" = '2025-01-23 13:38:28.958425', "sid" = 'b684321702faa2de0d0756775339c7971d975193', "write_date" = '2025-01-23 13:38:28.528207', "write_uid" = 1 WHERE id IN (932);

Date: 2025-01-23 15:19:46 Duration: 41m17s
UPDATE "res_users" SET "exp_date" = '2025-01-23 21:43:18.633145', "last_update" = '2025-01-23 20:58:18.633196', "sid" = 'c4ed6411df171ac14feba7a13aa58920f56d1fe4', "write_date" = '2025-01-23 20:58:18.292713', "write_uid" = 1387 WHERE id IN (1387);

Date: 2025-01-23 22:30:03 Duration: 31m45s
UPDATE "res_users" SET "exp_date" = '2025-01-23 21:43:18.803486', "last_update" = '2025-01-23 20:58:18.803519', "sid" = 'c4ed6411df171ac14feba7a13aa58920f56d1fe4', "write_date" = '2025-01-23 20:58:18.472115', "write_uid" = 1387 WHERE id IN (1387);

Date: 2025-01-23 22:30:03 Duration: 31m45s

2

0ms

37m46s

2m9s

35

Details

1h15m28s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 23	02	4	3ms	0ms
	08	2	1ms	0ms
	09	4	37m46s	9m26s
	10	4	8ms	2ms
	11	4	7ms	1ms
	12	3	37m42s	12m34s
	13	1	2ms	2ms
	14	5	3ms	0ms
	15	1	1ms	1ms
	18	2	3ms	1ms
	19	1	2ms	2ms
	21	3	4ms	1ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-23 08:15:33.965171', "last_update" = '2025-01-23 07:30:33.965194', "write_date" = '2025-01-23 07:30:33.547330', "write_uid" = 1 WHERE id IN (1081);

Date: 2025-01-23 09:08:20 Duration: 37m46s
UPDATE "res_users" SET "exp_date" = '2025-01-23 11:24:39.185670', "last_update" = '2025-01-23 10:39:39.185694', "write_date" = '2025-01-23 10:39:38.812664', "write_uid" = 1 WHERE id IN (959);

Date: 2025-01-23 12:17:21 Duration: 37m42s
UPDATE "res_users" SET "exp_date" = '2025-01-23 10:40:45.925133', "last_update" = '2025-01-23 09:55:45.925165', "write_date" = '2025-01-23 09:55:45.505277', "write_uid" = 1 WHERE id IN (1407);

Date: 2025-01-23 10:55:45 Duration: 3ms

3

0ms

1h

4s965ms

68,216

Details

3d22h5m33s

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 23	00	937	5h45m16s	22s109ms
	01	815	12m7s	893ms
	02	1,074	242ms	0ms
	03	1,140	254ms	0ms
	04	1,010	220ms	0ms
	05	434	25s420ms	58ms
	06	552	2h58m55s	19s448ms
	07	504	106ms	0ms
	08	1,674	342ms	0ms
	09	4,724	11h11m49s	8s532ms
	10	6,474	10h29m22s	5s832ms
	11	6,968	4h43m20s	2s439ms
	12	6,521	8h11m7s	4s518ms
	13	6,034	3h1m13s	1s802ms
	14	5,215	6m13s	71ms
	15	5,058	4h47m19s	3s408ms
	16	4,722	6h25m28s	4s898ms
	17	3,975	3h22m48s	3s61ms
	18	3,274	11h4m29s	12s177ms
	19	2,903	7h1m33s	8s712ms
	20	2,157	530ms	0ms
	21	1,345	13h29m45s	36s123ms
	22	706	1h14m12s	6s306ms

update res_users set sid = '77bf55c1780e3e22dd6e5ce3e8c78170e36ff245', last_update = '2025-01-23 04:45:58.212096', exp_date = '2025-01-23 05:30:58.212099', logged_in = 'TRUE' where id = 939;

Date: 2025-01-23 06:45:58 Duration: 1h
update res_users set sid = '77bf55c1780e3e22dd6e5ce3e8c78170e36ff245', last_update = '2025-01-23 04:45:58.212096', exp_date = '2025-01-23 05:30:58.212099', logged_in = 'TRUE' where id = 939;

Date: 2025-01-23 06:45:58 Duration: 1h
update res_users set sid = '94af8fef6dd74907628214fadb5eaa06b16e46be', last_update = '2025-01-23 19:05:24.270440', exp_date = '2025-01-23 19:50:24.270443', logged_in = 'TRUE' where id = 1026;

Date: 2025-01-23 21:05:24 Duration: 59m59s

4

31ms

1s907ms

933ms

11,923

Details

3h5m32s

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

Day	Hour	Count	Duration	Avg duration
Jan 23	00	629	9m25s	899ms
	01	978	14m23s	882ms
	02	489	7m8s	875ms
	04	5	4s674ms	934ms
	06	48	41s804ms	870ms
	08	20	17s323ms	866ms
	09	15	12s937ms	862ms
	10	1	1s99ms	1s99ms
	11	16	18s999ms	1s187ms
	12	28	28s132ms	1s4ms
	13	229	3m38s	955ms
	14	102	1m41s	999ms
	15	547	9m17s	1s19ms
	16	861	14m5s	981ms
	17	593	10m50s	1s97ms
	18	1,714	28m14s	988ms
	19	1,623	25m21s	937ms
	20	859	12m14s	855ms
	21	1,832	27m34s	903ms
	22	1,334	19m31s	878ms

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

Date: 2025-01-23 17:58:02 Duration: 1s907ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '81428')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-23 17:57:46 Duration: 1s810ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '97142')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-23 17:55:00 Duration: 1s800ms

5

496ms

4s550ms

646ms

46,329

Details

8h19m34s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 23	00	202	2m6s	628ms
	01	191	2m1s	636ms
	02	160	1m47s	673ms
	03	222	2m30s	677ms
	04	179	1m57s	654ms
	05	140	1m22s	592ms
	06	192	1m55s	600ms
	07	223	2m12s	595ms
	08	992	9m33s	578ms
	09	2,912	30m33s	629ms
	10	4,826	54m43s	680ms
	11	4,399	51m9s	697ms
	12	3,764	42m28s	677ms
	13	4,357	47m32s	654ms
	14	3,383	37m56s	673ms
	15	3,963	43m45s	662ms
	16	3,216	34m10s	637ms
	17	3,792	40m25s	639ms
	18	3,323	34m25s	621ms
	19	2,492	24m51s	598ms
	20	2,022	19m1s	564ms
	21	914	8m42s	572ms
	22	465	4m17s	554ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4716167, 4716166, 4716118, 4716116, 4713470, 4713450, 4711703, 4708416, 4707008, 4705688, 4704972, 4703938, 4701100, 4696867, 4696790, 4696112, 4694745, 4692535, 4691355, 4690779, 4689236, 4686169, 4665092, 4638966, 4638579, 4436842, 2858979)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:55:04 Duration: 4s550ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4717161, 4717127)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:59:03 Duration: 4s14ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4677471)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:56:00 Duration: 3s741ms

6

491ms

4s959ms

624ms

261,530

Details

1d21h21m49s

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

Day	Hour	Count	Duration	Avg duration
Jan 23	00	8,079	1h19m56s	593ms
	01	7,549	1h13m57s	587ms
	02	9,355	1h33m	596ms
	03	11,628	1h53m41s	586ms
	04	8,717	1h23m19s	573ms
	05	2,107	19m44s	562ms
	06	4,275	43m7s	605ms
	07	3,869	36m20s	563ms
	08	4,279	40m14s	564ms
	09	11,195	1h53m20s	607ms
	10	17,548	3h13m37s	662ms
	11	20,398	3h47m50s	670ms
	12	16,693	3h30s	648ms
	13	14,541	2h36m7s	644ms
	14	15,828	2h52m6s	652ms
	15	17,319	3h10m1s	658ms
	16	13,754	2h25m53s	636ms
	17	10,902	1h59m56s	660ms
	18	21,502	3h43m38s	624ms
	19	17,043	2h54m42s	615ms
	20	10,831	1h44m55s	581ms
	21	8,957	1h26m16s	577ms
	22	5,161	49m27s	574ms

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

Date: 2025-01-23 17:55:48 Duration: 4s959ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4722893)) AND (("shipping_track"."id" not in (39106685, 39106685)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:55:25 Duration: 4s888ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4723127)) AND (("shipping_track"."id" not in (39107471, 39107471)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-23 17:57:55 Duration: 4s302ms

7

355ms

775ms

494ms

2,166

Details

17m52s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 23	09	587	4m26s	453ms
	10	370	3m9s	511ms
	11	439	3m52s	529ms
	12	437	3m38s	500ms
	13	189	1m35s	506ms
	15	69	31s780ms	460ms
	16	6	2s711ms	451ms
	19	69	35s239ms	510ms

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

Date: 2025-01-23 11:57:39 Duration: 775ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9750576')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-23 11:57:41 Duration: 722ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '478083')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-23 10:51:34 Duration: 716ms

8

169ms

2s175ms

286ms

31,161

Details

2h28m58s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 23	07	73	24s124ms	330ms
	08	868	3m46s	261ms
	09	3,582	15m22s	257ms
	10	3,294	15m19s	279ms
	11	3,611	17m19s	287ms
	12	3,448	16m45s	291ms
	13	5,608	26m48s	286ms
	14	3,581	17m28s	292ms
	15	4,170	20m23s	293ms
	16	2,419	11m52s	294ms
	17	468	3m11s	409ms
	18	39	15s876ms	407ms

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

Date: 2025-01-23 17:55:16 Duration: 2s175ms
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" = '19445')))) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:55:27 Duration: 1s356ms
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" = '9643698')))) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:55:20 Duration: 1s50ms

9

201ms

1s132ms

276ms

2,726

Details

12m34s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 23	00	120	32s841ms	273ms
	01	120	32s412ms	270ms
	02	120	33s197ms	276ms
	03	120	33s145ms	276ms
	04	120	32s683ms	272ms
	05	120	32s411ms	270ms
	06	120	32s614ms	271ms
	07	120	32s351ms	269ms
	08	120	32s385ms	269ms
	09	120	34s452ms	287ms
	10	120	36s801ms	306ms
	11	120	38s142ms	317ms
	12	120	36s522ms	304ms
	13	120	37s35ms	308ms
	14	120	36s136ms	301ms
	15	120	36s735ms	306ms
	16	120	35s212ms	293ms
	17	116	32s827ms	282ms
	18	120	30s905ms	257ms
	19	120	29s427ms	245ms
	20	120	28s74ms	233ms
	21	120	27s580ms	229ms
	22	90	20s374ms	226ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-23 17:55:02 Duration: 1s132ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-23 17:59:03 Duration: 1s64ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-23 15:35:02 Duration: 441ms

10

199ms

1s820ms

264ms

18,260

Details

1h20m29s

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 23	00	1,641	6m44s	246ms
	01	771	3m4s	239ms
	02	1,740	6m54s	238ms
	03	1,699	6m52s	242ms
	04	744	2m59s	240ms
	05	54	12s131ms	224ms
	06	966	3m48s	236ms
	07	73	16s755ms	229ms
	08	25	5s923ms	236ms
	09	39	9s981ms	255ms
	10	36	9s548ms	265ms
	11	81	22s835ms	281ms
	12	74	20s256ms	273ms
	13	240	1m5s	271ms
	14	339	1m33s	276ms
	15	440	1m59s	272ms
	16	637	2m47s	263ms
	17	1,816	9m20s	308ms
	18	1,493	7m21s	295ms
	19	1,597	7m24s	278ms
	20	2,066	9m19s	270ms
	21	1,056	4m49s	274ms
	22	633	2m46s	262ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9969150')) 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-23 17:58:04 Duration: 1s820ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '23219')) 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-23 17:58:44 Duration: 1s694ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '69732')) 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-23 17:55:27 Duration: 1s676ms

11

98ms

943ms

247ms

59,631

Details

4h5m30s

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 23	00	4,506	15m51s	211ms
	01	3,459	14m7s	244ms
	02	4,419	17m50s	242ms
	03	3,332	13m24s	241ms
	04	1,466	5m43s	234ms
	05	108	34s332ms	317ms
	06	1,990	8m23s	253ms
	07	146	34s708ms	237ms
	08	88	17s378ms	197ms
	09	100	22s200ms	222ms
	10	68	16s893ms	248ms
	11	192	49s836ms	259ms
	12	194	50s171ms	258ms
	13	912	3m49s	252ms
	14	866	3m55s	271ms
	15	1,944	8m50s	272ms
	16	2,966	12m22s	250ms
	17	4,757	22m59s	289ms
	18	6,329	29m13s	277ms
	19	6,371	26m11s	246ms
	20	5,787	23m33s	244ms
	21	5,721	21m20s	223ms
	22	3,910	14m6s	216ms

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-23 16:16:35 Duration: 943ms
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-23 16:16:35 Duration: 942ms
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-23 18:02:36 Duration: 886ms

12

152ms

1s463ms

211ms

126,842

Details

7h27m21s

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 23	00	715	2m3s	173ms
	01	917	2m39s	173ms
	02	2,880	8m30s	177ms
	03	2,389	7m5s	178ms
	04	2,986	8m42s	175ms
	05	1,137	3m15s	172ms
	06	1,074	3m6s	173ms
	07	1,586	4m34s	173ms
	08	3,109	9m7s	176ms
	09	5,421	17m2s	188ms
	10	8,544	29m21s	206ms
	11	10,380	35m49s	207ms
	12	8,347	28m26s	204ms
	13	10,744	36m54s	206ms
	14	16,125	54m45s	203ms
	15	16,199	54m34s	202ms
	16	5,871	19m43s	201ms
	17	15,793	1h12m43s	276ms
	18	9,958	39m25s	237ms
	19	1,429	5m11s	217ms
	20	379	1m19s	208ms
	21	645	2m14s	207ms
	22	214	43s989ms	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" = '35452')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-23 17:55:23 Duration: 1s463ms
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" = '35451')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-23 17:55:25 Duration: 1s459ms
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" = '58531')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-23 17:58:12 Duration: 1s441ms

13

158ms

321ms

198ms

4,350

Details

14m22s

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 23	06	445	1m17s	174ms
	07	18	3s92ms	171ms
	08	185	32s405ms	175ms
	09	1,188	3m42s	187ms
	10	1,613	5m35s	208ms
	11	262	58s521ms	223ms
	13	69	12s762ms	184ms
	15	8	1s717ms	214ms
	16	7	1s416ms	202ms
	17	51	10s641ms	208ms
	18	51	11s825ms	231ms
	19	3	759ms	253ms
	21	450	1m33s	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" = '87026')) 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-23 10:59:16 Duration: 321ms
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" = '9902739')) 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-23 10:59:17 Duration: 318ms
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" = '9300796')) 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-23 10:59:21 Duration: 317ms

14

153ms

352ms

196ms

13,195

Details

43m13s

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 23	00	5	879ms	175ms
	01	5	871ms	174ms
	04	13	2s143ms	164ms
	05	112	19s500ms	174ms
	06	612	1m45s	173ms
	07	1,488	4m18s	173ms
	08	868	2m32s	175ms
	09	672	2m9s	193ms
	10	1,748	5m39s	194ms
	11	2,074	7m7s	206ms
	12	1,213	4m4s	201ms
	13	711	2m18s	195ms
	14	1,275	4m17s	202ms
	15	554	1m51s	202ms
	16	139	26s394ms	189ms
	17	315	1m7s	214ms
	18	532	2m7s	239ms
	19	237	53s358ms	225ms
	20	262	54s345ms	207ms
	21	169	35s856ms	212ms
	22	191	39s190ms	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" = '9977416')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-23 18:35:41 Duration: 301ms

15

154ms

257ms

186ms

10,328

Details

32m9s

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 23	00	710	2m6s	178ms
	01	912	2m47s	184ms
	02	2,678	8m17s	185ms
	03	2,371	7m33s	191ms
	04	2,805	8m49s	188ms
	05	852	2m33s	180ms

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

Date: 2025-01-23 03:04:49 Duration: 255ms
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" = '9757832')) 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, 43, 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-23 02:39:22 Duration: 251ms

16

121ms

1s77ms

155ms

6,406

Details

16m39s

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 23	00	28	3s652ms	130ms
	01	36	4s709ms	130ms
	02	219	32s903ms	150ms
	06	19	2s512ms	132ms
	07	5	638ms	127ms
	08	70	9s247ms	132ms
	09	427	1m2s	145ms
	10	836	2m13s	160ms
	11	1,218	3m14s	159ms
	12	1,134	2m56s	155ms
	13	632	1m37s	153ms
	14	496	1m15s	153ms
	15	322	49s901ms	154ms
	16	176	26s898ms	152ms
	17	157	29s299ms	186ms
	18	194	32s255ms	166ms
	19	87	14s554ms	167ms
	20	132	20s6ms	151ms
	21	54	8s55ms	149ms
	22	164	23s929ms	145ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) 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-23 17:55:25 Duration: 1s77ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 28)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-23 17:58:22 Duration: 766ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) 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-23 17:54:27 Duration: 742ms

17

95ms

776ms

123ms

19,408

Details

39m49s

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 23	00	13	1s492ms	114ms
	05	18	2s78ms	115ms
	08	180	20s373ms	113ms
	09	1,971	3m49s	116ms
	10	1,590	3m25s	128ms
	11	1,992	4m20s	131ms
	12	2,000	4m9s	124ms
	13	2,252	4m37s	123ms
	14	1,795	3m41s	123ms
	15	1,533	3m17s	128ms
	16	2,094	4m9s	119ms
	17	907	1m53s	125ms
	18	1,021	2m3s	120ms
	19	1,077	2m8s	119ms
	20	704	1m19s	113ms
	21	103	12s67ms	117ms
	22	158	17s884ms	113ms

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

Date: 2025-01-23 17:55:56 Duration: 776ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8028267)) AND (("cash_track"."id" not in (7296162)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-23 17:55:48 Duration: 604ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8020546)) AND (("cash_track"."id" not in (7231603, 7251326, 7253806, 7296113, 7296113)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-23 17:55:02 Duration: 460ms

18

43ms

336ms

58ms

44,714

Details

43m22s

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 23	06	1	52ms	52ms
	07	13	698ms	53ms
	08	1,534	1m20s	52ms
	09	2,789	2m35s	55ms
	10	4,255	4m16s	60ms
	11	4,290	4m18s	60ms
	12	7,089	6m44s	57ms
	13	6,901	6m40s	57ms
	14	8,395	8m13s	58ms
	15	4,118	3m59s	58ms
	16	4,077	3m49s	56ms
	17	744	48s544ms	65ms
	18	324	22s989ms	70ms
	19	80	5s521ms	69ms
	20	55	3s619ms	65ms
	21	5	309ms	61ms
	22	44	2s877ms	65ms

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

Date: 2025-01-23 17:54:36 Duration: 336ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4694875) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:54:26 Duration: 325ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4686342) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-23 17:54:36 Duration: 323ms

19

37ms

338ms

55ms

152,799

Details

2h21m20s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 23	00	3,706	3m15s	52ms
	01	2,525	2m12s	52ms
	02	2,906	2m34s	53ms
	03	4,033	3m34s	53ms
	04	2,566	2m15s	52ms
	05	865	45s449ms	52ms
	06	1,232	1m5s	53ms
	07	1,068	56s435ms	52ms
	08	2,850	2m29s	52ms
	09	8,509	7m58s	56ms
	10	12,627	12m47s	60ms
	11	15,468	15m44s	61ms
	12	14,529	14m24s	59ms
	13	12,265	11m59s	58ms
	14	11,053	10m52s	59ms
	15	8,695	8m35s	59ms
	16	8,499	8m4s	56ms
	17	7,340	6m35s	53ms
	18	7,848	6m31s	49ms
	19	8,821	7m	47ms
	20	7,147	5m27s	45ms
	21	5,396	4m3s	45ms
	22	2,851	2m6s	44ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4678716, 4664560, 4597630)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:57:53 Duration: 338ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4698780, 4697665, 4695111, 4695038, 4691774, 4691357, 4691107, 4691101, 4689523, 4688842, 4661228, 4661036, 4640064, 4637230, 4612794, 4599388, 4584549)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:55:21 Duration: 285ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4708234, 4502517)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-23 17:59:09 Duration: 284ms

20

39ms

117ms

53ms

20,513

Details

18m19s

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 23	07	37	1s765ms	47ms
	08	721	34s332ms	47ms
	09	1,020	51s239ms	50ms
	10	1,805	1m39s	55ms
	11	2,019	1m48s	53ms
	12	3,741	3m20s	53ms
	13	3,371	3m4s	54ms
	14	3,604	3m16s	54ms
	15	1,701	1m27s	51ms
	16	2,017	1m44s	51ms
	17	385	23s377ms	60ms
	18	42	2s872ms	68ms
	19	50	3s636ms	72ms

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

Date: 2025-01-23 13:48:58 Duration: 117ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4629720) ORDER BY "collection_policy"."id";

Date: 2025-01-23 14:17:58 Duration: 97ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4610829) ORDER BY "collection_policy"."id";

Date: 2025-01-23 10:59:17 Duration: 97ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

19,187,313 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	8	0.00%
DETAIL	21	0.00%
ERROR	3,754	0.02%
EVENTLOG	1,115	0.01%
FATAL	833	0.00%
HINT	5	0.00%
LOG	19,177,804	99.95%
STATEMENT	3,773	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
833 FATAL entries
3754 ERROR entries
0 WARNING entries
1115 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,007 Max number of times the same event was reported
5,702 Total events found

Rank

Times reported

Error

1

2,007

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 23	00	9
	01	31
	02	20
	03	16
	04	7
	05	2
	06	15
	07	18
	08	32
	09	146
	10	141
	11	287
	12	135
	13	169
	14	215
	15	202
	16	127
	17	164
	18	125
	19	60
	20	17
	21	44
	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

1,712

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 23	00	8
	01	30
	02	15
	03	12
	04	4
	06	13
	07	18
	08	30
	09	131
	10	129
	11	265
	12	126
	13	151
	14	179
	15	149
	16	106
	17	128
	18	90
	19	44
	20	17
	21	42
	22	25

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

685

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 23	00	30
	06	2
	09	92
	10	93
	11	21
	12	73
	13	83
	15	65
	16	46
	17	60
	18	25
	19	29
	21	50
	22	16

LOG: could not send data to client: Broken pipe

4

685

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 23	00	30
	06	2
	09	92
	10	93
	11	21
	12	73
	13	83
	15	65
	16	46
	17	60
	18	25
	19	29
	21	50
	22	16

5

303

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 23	00	2
	06	1
	09	46
	10	45
	11	12
	12	29
	13	54
	15	34
	16	17
	17	4
	18	7
	19	8
	21	24
	22	20

6

126

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 23	00	1
	09	19
	10	18
	11	4
	12	14
	13	26
	15	20
	16	10
	17	2
	18	4
	21	7
	22	1

7

77

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 23	17	77

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

8

23

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 23	17	23

9

16

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 23	17	16

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

14

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 23	08	2
	10	3
	13	2
	14	5
	15	1
	16	1

ERROR: syntax error at or near ")" at character 164
ERROR: syntax error at or near ")" at character 163
ERROR: syntax error at or near ")" at character 157

11

10

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 23	11	2
	13	6
	14	1
	15	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: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 23	02	1
	03	2
	06	1
	16	1
	17	1
	22	1

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 23	02	1
	03	2
	06	1
	16	1
	17	1

14

6

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 23	02	1
	03	2
	06	1
	16	1
	17	1

15

6

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 23	15	3
	22	3

FATAL: password authentication failed for user "postgres"

16

5

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 23	11	1
	13	2
	14	1
	18	1

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

17

3

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 23	17	3

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

3

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 23	17	3

19

3

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 23	12	1
	17	1
	18	1

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

20

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 23	12	2

21

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 23	17	1

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