pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Feb 1 23:47:15 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 37,519,586 log entries in 2m13s
Log start from 2025-02-01 00:00:00 to 2025-02-01 22:45:02

Global Stats

14,590 Number of unique normalized queries
16,187,084 Number of queries
6d7h25m20s Total query duration
2025-02-01 00:00:00 First query
2025-02-01 22:45:02 Last query
4,392 queries/s at 2025-02-01 13:45:12 Query peak

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

5,057 Number of events
22 Number of unique normalized events
1,602 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
16,187,084 Average queries per session
6d7h25m20s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

4,392 queries/s Query Peak
2025-02-01 13:45:12 Date

SELECT Traffic

Key values

2,803 queries/s Query Peak
2025-02-01 13:00:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,103 queries/s Query Peak
2025-02-01 13:45:12 Date

Queries duration

Key values

6d7h25m20s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 01	00	228,991	0ms	59m56s	51ms	3m8s	3m32s	1h46m13s
	01	223,673	0ms	925ms	25ms	2m40s	3m26s	4m8s
	02	183,127	0ms	774ms	24ms	2m57s	3m3s	3m57s
	03	102,724	0ms	728ms	18ms	1m10s	1m29s	1m42s
	04	35,772	0ms	690ms	2ms	547ms	11s526ms	31s59ms
	05	81,589	0ms	3s892ms	25ms	1m32s	1m58s	2m38s
	06	162,620	0ms	59m59s	65ms	2m4s	6m25s	1h55m41s
	07	110,297	0ms	715ms	20ms	1m7s	1m51s	4m20s
	08	403,037	0ms	1s735ms	9ms	2m17s	2m44s	2m59s
	09	886,995	0ms	53m32s	15ms	5m7s	7m51s	56m7s
	10	1,484,402	0ms	14m25s	33ms	11m30s	1h41m16s	3h17m40s
	11	1,422,724	0ms	26m50s	33ms	8m11s	8m52s	5h17m47s
	12	1,365,714	0ms	12m57s	17ms	6m51s	9m22s	2h17m38s
	13	1,408,367	0ms	8m59s	14ms	7m2s	16m1s	1h3m27s
	14	1,164,733	0ms	23m56s	24ms	9m20s	10m11s	3h28m52s
	15	1,354,098	0ms	32m17s	45ms	6m30s	1h39m36s	8h16m51s
	16	1,304,315	0ms	17m46s	39ms	51m23s	1h5m22s	2h26m12s
	17	1,091,021	0ms	31m46s	51ms	11m57s	1h15m44s	5h37m15s
	18	945,855	0ms	31m45s	35ms	6m12s	8m41s	4h1m52s
	19	814,719	0ms	58m22s	67ms	6m1s	6m22s	11h11m20s
	20	687,541	0ms	43m12s	45ms	5m54s	6m8s	5h19m12s
	21	464,369	0ms	59m59s	48ms	4m36s	5m52s	2h41m52s
	22	260,401	0ms	3s300ms	18ms	3m4s	3m33s	5m32s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 01	00	122,790	45ms	2m15s	2m59s	3m32s
	01	119,510	47ms	2m21s	2m40s	3m30s
	02	93,318	47ms	2m11s	2m56s	3m8s
	03	49,215	37ms	52s576ms	1m10s	1m32s
	04	13,026	6ms	502ms	536ms	16s880ms
	05	42,865	48ms	1m5s	1m32s	2m4s
	06	90,784	34ms	1m37s	1m53s	3m2s
	07	57,962	38ms	1m2s	1m7s	1m55s
	08	236,814	16ms	1m44s	2m17s	2m58s
	09	504,962	21ms	3m59s	4m39s	7m50s
	10	893,860	20ms	7m22s	8m10s	10m44s
	11	840,966	18ms	6m6s	6m53s	8m43s
	12	798,880	19ms	5m31s	6m33s	8m39s
	13	846,530	16ms	5m7s	5m42s	7m1s
	14	683,746	18ms	4m42s	5m25s	6m13s
	15	837,754	12ms	4m4s	4m35s	5m48s
	16	804,810	29ms	9m30s	11m43s	12m57s
	17	668,675	24ms	5m44s	7m35s	11m55s
	18	574,247	23ms	4m53s	5m39s	7m
	19	476,862	30ms	5m28s	5m57s	6m21s
	20	404,018	30ms	4m52s	5m53s	6m8s
	21	263,833	35ms	3m29s	4m14s	5m3s
	22	148,364	31ms	2m9s	3m4s	5m31s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 01	00	23,755	5,216	151	0	216ms	125ms	167ms	243ms
	01	19,646	5,683	141	0	0ms	109ms	162ms	218ms
	02	14,761	4,196	139	0	0ms	87ms	128ms	193ms
	03	5,596	1,673	130	0	0ms	32ms	47ms	67ms
	04	213	191	129	0	0ms	0ms	0ms	14ms
	05	6,603	1,515	130	0	0ms	41ms	71ms	129ms
	06	12,649	2,567	135	0	486ms	75ms	126ms	4m23s
	07	5,624	2,201	215	0	0ms	40ms	62ms	154ms
	08	13,721	5,462	442	0	0ms	81ms	104ms	147ms
	09	40,088	14,033	594	0	59ms	238ms	292ms	515ms
	10	70,146	19,189	581	0	351ms	446ms	523ms	1h39m26s
	11	61,938	19,316	743	0	398ms	368ms	477ms	2s192ms
	12	64,073	21,682	839	0	95ms	396ms	506ms	35s4ms
	13	59,046	17,356	621	0	88ms	368ms	482ms	14m38s
	14	48,175	14,389	489	0	242ms	323ms	1m20s	5m28s
	15	43,589	19,033	825	0	819ms	293ms	359ms	1h38m10s
	16	74,698	28,529	614	0	270ms	620ms	1s544ms	1h2m5s
	17	54,303	15,613	485	0	571ms	442ms	550ms	1h14m5s
	18	56,805	14,539	473	0	283ms	365ms	456ms	732ms
	19	62,250	16,449	520	0	506ms	389ms	482ms	551ms
	20	51,420	12,289	572	1	296ms	315ms	373ms	581ms
	21	45,022	9,948	240	0	236ms	264ms	328ms	524ms
	22	21,962	4,697	147	0	0ms	158ms	215ms	337ms

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

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

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

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

50,818 buffers Checkpoint Peak
2025-02-01 11:21:30 Date
270.056 seconds Highest write time
0.401 seconds Sync time

Checkpoints Wal files

Key values

20 files Wal files usage Peak
2025-02-01 11:21:30 Date

Checkpoints distance

Key values

620.52 Mo Distance Peak
2025-02-01 11:21:30 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 01	00	87,714	3,239.569s	0.033s	3,239.654s
	01	91,314	3,239.588s	0.029s	3,239.65s
	02	85,313	3,220.483s	0.025s	3,220.556s
	03	57,226	3,256.11s	0.036s	3,256.179s
	04	4,577	455.485s	0.017s	455.526s
	05	17,801	1,422.843s	0.023s	1,422.891s
	06	61,858	3,015.408s	0.027s	3,015.483s
	07	65,411	2,480.258s	0.023s	2,480.315s
	08	99,180	3,047.479s	0.037s	3,047.553s
	09	288,974	3,239.546s	0.039s	3,239.64s
	10	441,606	3,239.131s	0.445s	3,239.649s
	11	478,919	3,239.532s	0.064s	3,239.674s
	12	437,594	3,239.43s	0.053s	3,239.578s
	13	444,908	3,239.492s	0.051s	3,239.622s
	14	350,040	3,239.534s	0.045s	3,239.651s
	15	282,110	3,239.545s	0.046s	3,239.653s
	16	372,666	3,239.518s	0.063s	3,239.657s
	17	294,104	2,882.017s	0.07s	2,882.153s
	18	244,703	3,239.516s	0.055s	3,239.629s
	19	199,845	3,239.552s	0.044s	3,239.653s
	20	240,490	3,239.466s	0.047s	3,239.572s
	21	177,938	3,239.613s	0.045s	3,239.712s
	22	100,392	2,429.651s	0.036s	2,429.727s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Feb 01	00	30	2,941	0.002s	0.012s
	01	32	2,797	0.002s	0.012s
	02	31	2,434	0.002s	0.012s
	03	21	2,066	0.011s	0.013s
	04	2	348	0.001s	0.012s
	05	7	1,632	0.004s	0.012s
	06	21	2,503	0.002s	0.012s
	07	21	2,058	0.002s	0.012s
	08	32	3,308	0.002s	0.012s
	09	99	4,834	0.002s	0.012s
	10	158	5,167	0.386s	0.012s
	11	182	5,353	0.002s	0.012s
	12	172	5,291	0.003s	0.012s
	13	174	5,362	0.003s	0.012s
	14	140	5,369	0.003s	0.012s
	15	111	5,508	0.002s	0.012s
	16	152	5,482	0.003s	0.012s
	17	118	5,394	0.014s	0.012s
	18	100	5,270	0.002s	0.012s
	19	84	5,126	0.003s	0.012s
	20	102	5,103	0.003s	0.012s
	21	75	5,066	0.002s	0.012s
	22	41	3,327	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Feb 01	00	41,790.75 kB	56,731.33 kB
	01	42,814.17 kB	54,531.17 kB
	02	42,414.50 kB	62,349.42 kB
	03	27,405.15 kB	41,116.23 kB
	04	2,154.25 kB	18,272.17 kB
	05	9,739.45 kB	12,652.55 kB
	06	29,587.58 kB	45,900.75 kB
	07	28,746.25 kB	47,491.58 kB
	08	43,185.75 kB	82,856.75 kB
	09	137,828.00 kB	151,791.82 kB
	10	212,864.55 kB	245,431.73 kB
	11	249,325.50 kB	291,600.83 kB
	12	238,303.55 kB	266,118.45 kB
	13	237,582.75 kB	274,419.17 kB
	14	190,826.92 kB	254,753.17 kB
	15	152,453.45 kB	196,099.64 kB
	16	205,149.55 kB	238,685.27 kB
	17	168,126.09 kB	200,473.73 kB
	18	137,699.67 kB	175,879.33 kB
	19	114,213.25 kB	147,514.42 kB
	20	141,279.36 kB	163,365.55 kB
	21	101,963.42 kB	146,937.75 kB
	22	75,169.78 kB	105,763.44 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

9,573,791 Total read queries
4,477,470 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	9,573,791	59.14%
INSERT	856,083	5.29%
UPDATE	255,766	1.58%
DELETE	9,355	0.06%
COPY FROM	1	0.00%
COPY TO	0	0.00%
CTE	23,922	0.15%
DDL	2,124	0.01%
TCL	3,330,219	20.57%
CURSOR	0	0.00%
OTHERS	2,135,823	13.19%

Queries by database

Key values

unknown Main database
16,187,084 Requests
6d7h25m20s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	16,187,084	6d7h25m20s
	copy from	1	2ms
	cte	23,922	5s81ms
	ddl	2,124	291ms
	delete	9,355	9s501ms
	insert	856,083	4m31s
	others	2,135,822	1m39s
	select	9,573,791	2d13h11m24s
	tcl	3,330,219	2m10s
	update	255,766	3d18h5m20s

Queries by user

Key values

unknown Main user
16,187,084 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	16,187,084	6d7h25m20s
	copy from	1	2ms
	cte	23,922	5s81ms
	ddl	2,124	291ms
	delete	9,355	9s501ms
	insert	856,083	4m31s
	others	2,135,822	1m39s
	select	9,573,791	2d13h11m24s
	tcl	3,330,219	2m10s
	update	255,766	3d18h5m20s

Duration by user

Key values

6d7h25m20s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	16,187,084	6d7h25m20s
	copy from	1	2ms
	cte	23,922	5s81ms
	ddl	2,124	291ms
	delete	9,355	9s501ms
	insert	856,083	4m31s
	others	2,135,822	1m39s
	select	9,573,791	2d13h11m24s
	tcl	3,330,219	2m10s
	update	255,766	3d18h5m20s

Queries by host

Key values

unknown Main host
16,187,084 Requests
6d7h25m20s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	16,187,084	6d7h25m20s
	copy from	1	2ms
	cte	23,922	5s81ms
	ddl	2,124	291ms
	delete	9,355	9s501ms
	insert	856,083	4m31s
	others	2,135,822	1m39s
	select	9,573,791	2d13h11m24s
	tcl	3,330,219	2m10s
	update	255,766	3d18h5m20s

Queries by application

Key values

unknown Main application
16,187,084 Requests
6d7h25m20s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	16,187,084	6d7h25m20s
	copy from	1	2ms
	cte	23,922	5s81ms
	ddl	2,124	291ms
	delete	9,355	9s501ms
	insert	856,083	4m31s
	others	2,135,822	1m39s
	select	9,573,791	2d13h11m24s
	tcl	3,330,219	2m10s
	update	255,766	3d18h5m20s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-02-01 20:41:24 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

15,197,235 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	15,197,235	93.88%
1-5ms	258,451	1.60%
5-10ms	11,889	0.07%
10-25ms	49,055	0.30%
25-50ms	38,069	0.24%
50-100ms	143,783	0.89%
100-500ms	235,303	1.45%
500-1000ms	250,841	1.55%
1000-10000ms	1,638	0.01%
> 10000ms	820	0.01%

Slowest individual queries

Rank	Duration	Query
1	59m59s	UPDATE "res_users" SET "exp_date" = '2025-02-01 20:38:43.718933', "last_update" = '2025-02-01 19:53:43.718953', "write_date" = '2025-02-01 19:53:43.395434', "write_uid" = 1 WHERE id IN (1208); [ Date: 2025-02-01 21:53:43 ]
2	59m59s	update res_users set sid = '94af8fef6dd74907628214fadb5eaa06b16e46be', last_update = '2025-02-01 19:45:44.466222', exp_date = '2025-02-01 20:30:44.466228', logged_in = 'TRUE' where id = 1026; [ Date: 2025-02-01 21:45:44 ]
3	59m59s	UPDATE "res_users" SET "exp_date" = '2025-02-01 05:05:33.205398', "last_update" = '2025-02-01 04:20:33.205418', "write_date" = '2025-02-01 04:20:32.886923', "write_uid" = 1053 WHERE id IN (1053); [ Date: 2025-02-01 06:20:32 ]
4	59m57s	update res_users set sid = '5c395234c5d2d387989cda6d8f7050cf52e52fb0', last_update = '2025-02-01 19:53:45.755829', exp_date = '2025-02-01 20:38:45.755833', logged_in = 'TRUE' where id = 1208; [ Date: 2025-02-01 21:53:43 ]
5	59m56s	UPDATE "res_users" SET "exp_date" = '2025-01-31 23:06:56.639579', "last_update" = '2025-01-31 22:21:56.639595', "write_date" = '2025-01-31 22:21:56.318494', "write_uid" = 1053 WHERE id IN (1053); [ Date: 2025-02-01 00:21:53 ]
6	58m22s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:37:58.591052', exp_date = '2025-02-01 18:22:58.591055', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
7	58m22s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:37:58.591023', exp_date = '2025-02-01 18:22:58.591027', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
8	57m51s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:38:29.467063', exp_date = '2025-02-01 18:23:29.467067', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
9	57m18s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:39:02.447508', exp_date = '2025-02-01 18:24:02.447512', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
10	56m44s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:39:37.120739', exp_date = '2025-02-01 18:24:37.120743', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
11	53m49s	update res_users set sid = 'b38acda55f6675c0dbe45ac7f48ac800a44ba6d6', last_update = '2025-02-01 04:26:43.782082', exp_date = '2025-02-01 05:11:43.782086', logged_in = 'TRUE' where id = 1053; [ Date: 2025-02-01 06:20:32 ]
12	53m32s	update res_users set sid = 'c89ef0420470f95635e1b0f77138ab63183d9683', last_update = '2025-02-01 07:55:31.188468', exp_date = '2025-02-01 08:40:31.188470', logged_in = 'TRUE' where id = 965; [ Date: 2025-02-01 09:49:04 ]
13	45m6s	UPDATE "res_users" SET "exp_date" = '2025-01-31 23:21:47.000700', "last_update" = '2025-01-31 22:36:47.000722', "sid" = 'ed33e9c0f14252382cb7e352719e9bb206298906', "write_date" = '2025-01-31 22:36:46.676214', "write_uid" = 1 WHERE id IN (1053); [ Date: 2025-02-01 00:21:53 ]
14	44m21s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:52:00.142679', exp_date = '2025-02-01 18:37:00.142681', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
15	43m12s	update res_users set sid = '990405aa243929f275f729101fdcb167fa81863e', last_update = '2025-02-01 18:37:08.611149', exp_date = '2025-02-01 19:22:08.611152', logged_in = 'TRUE' where id = 967; [ Date: 2025-02-01 20:20:20 ]
16	43m12s	update res_users set sid = '990405aa243929f275f729101fdcb167fa81863e', last_update = '2025-02-01 18:37:08.611130', exp_date = '2025-02-01 19:22:08.611133', logged_in = 'TRUE' where id = 967; [ Date: 2025-02-01 20:20:20 ]
17	42m51s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:53:30.322490', exp_date = '2025-02-01 18:38:30.322493', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
18	42m17s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:54:03.774554', exp_date = '2025-02-01 18:39:03.774557', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
19	41m42s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:54:38.759473', exp_date = '2025-02-01 18:39:38.759477', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]
20	41m6s	update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:55:14.809453', exp_date = '2025-02-01 18:40:14.809455', logged_in = 'TRUE' where id = 1372; [ Date: 2025-02-01 19:36:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d10h32m6s

57,013

Details

0ms

59m59s

5s211ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 01	00	677	147ms	0ms
	01	709	153ms	0ms
	02	570	121ms	0ms
	03	295	61ms	0ms
	04	12	2ms	0ms
	05	279	61ms	0ms
	06	356	53m49s	9s70ms
	07	278	60ms	0ms
	08	1,384	290ms	0ms
	09	3,238	53m33s	992ms
	10	5,592	8h43m28s	5s616ms
	11	5,974	9h41s	5s430ms
	12	5,848	2h16m2s	1s395ms
	13	5,457	1h52m45s	1s239ms
	14	4,464	4h14m	3s414ms
	15	4,911	14h26m13s	10s583ms
	16	4,222	7h47m7s	6s638ms
	17	3,631	9h46m20s	9s688ms
	18	2,775	4h32m29s	5s891ms
	19	2,295	10h48m23s	16s951ms
	20	2,024	5h17m10s	9s402ms
	21	1,394	1h59m58s	5s163ms
	22	628	140ms	0ms

update res_users set sid = '94af8fef6dd74907628214fadb5eaa06b16e46be', last_update = '2025-02-01 19:45:44.466222', exp_date = '2025-02-01 20:30:44.466228', logged_in = 'TRUE' where id = 1026;

Date: 2025-02-01 21:45:44 Duration: 59m59s
update res_users set sid = '5c395234c5d2d387989cda6d8f7050cf52e52fb0', last_update = '2025-02-01 19:53:45.755829', exp_date = '2025-02-01 20:38:45.755833', logged_in = 'TRUE' where id = 1208;

Date: 2025-02-01 21:53:43 Duration: 59m57s
update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:37:58.591052', exp_date = '2025-02-01 18:22:58.591055', logged_in = 'TRUE' where id = 1372;

Date: 2025-02-01 19:36:21 Duration: 58m22s

2

1d10h37m21s

203,654

Details

516ms

4s463ms

612ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 01	00	6,140	59m50s	584ms
	01	6,470	1h2m2s	575ms
	02	5,699	54m13s	570ms
	03	2,499	22m57s	551ms
	04	78	42s865ms	549ms
	05	2,033	19m42s	581ms
	06	3,562	34m21s	578ms
	07	2,660	24m32s	553ms
	08	3,467	32m12s	557ms
	09	9,590	1h34m20s	590ms
	10	17,117	3h2m41s	640ms
	11	14,197	2h25m33s	615ms
	12	12,812	2h10m13s	609ms
	13	13,214	2h13m44s	607ms
	14	13,338	2h12m1s	593ms
	15	7,611	1h14m49s	589ms
	16	18,045	3h23m22s	676ms
	17	16,136	2h50m21s	633ms
	18	11,360	1h56m37s	615ms
	19	12,402	2h9m2s	624ms
	20	11,575	1h56m41s	604ms
	21	9,070	1h31m18s	603ms
	22	4,579	45m58s	602ms

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

Date: 2025-02-01 16:02:30 Duration: 4s463ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4959986)) AND (("shipping_track"."id" not in (41156983, 41156983)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:44 Duration: 4s343ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4959933)) AND (("shipping_track"."id" not in (41156263, 41156885, 41156885)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:25 Duration: 3s632ms

3

6h43m30s

39,088

Details

522ms

4s675ms

619ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 01	00	177	1m50s	624ms
	01	191	2m4s	652ms
	02	168	1m50s	659ms
	03	95	1m	633ms
	04	2	1s378ms	689ms
	05	26	17s14ms	654ms
	06	224	2m11s	588ms
	07	449	4m15s	569ms
	08	1,554	14m41s	567ms
	09	2,406	24m	598ms
	10	3,168	35m6s	664ms
	11	3,926	41m46s	638ms
	12	3,923	40m59s	626ms
	13	3,814	39m20s	618ms
	14	2,793	28m6s	603ms
	15	3,101	30m56s	598ms
	16	2,654	30m31s	690ms
	17	2,696	28m26s	633ms
	18	2,334	22m58s	590ms
	19	1,807	17m50s	592ms
	20	2,369	23m20s	591ms
	21	808	7m58s	591ms
	22	403	3m54s	580ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4945349, 4926332, 4926095, 4915190, 4915018, 4905981, 4899111, 4895848, 4855708, 4853960, 4785934)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:28 Duration: 4s675ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4945354, 4933015, 4932931, 4926608, 4921442, 4920583, 4916851, 4915890, 4914045, 4912663, 4905958, 4900417, 4896181, 4895016, 4887822, 4884823, 4839325, 4836026)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:36 Duration: 4s65ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4638114)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:42 Duration: 3s859ms

4

4h15m51s

74,051

Details

163ms

1s516ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,208	3m38s	180ms
	01	1,982	6m	181ms
	02	1,357	4m7s	182ms
	03	842	2m33s	182ms
	04	29	5s273ms	181ms
	05	1,069	3m14s	182ms
	06	396	1m12s	182ms
	07	1,089	3m17s	181ms
	08	1,793	5m29s	183ms
	09	6,505	20m56s	193ms
	10	5,721	19m39s	206ms
	11	4,477	15m9s	203ms
	12	8,283	29m32s	214ms
	13	2,671	8m57s	201ms
	14	3,246	10m36s	196ms
	15	7,652	24m45s	194ms
	16	21,620	1h22m19s	228ms
	17	2,702	9m47s	217ms
	18	127	24s813ms	195ms
	19	356	1m8s	192ms
	20	245	46s820ms	191ms
	21	333	1m2s	186ms
	22	348	1m5s	188ms

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

Date: 2025-02-01 16:02:27 Duration: 1s516ms
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" = '100976')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:28 Duration: 1s484ms
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" = '212452')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:27 Duration: 1s474ms

5

4h2m18s

55

Details

0ms

59m59s

4m24s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1	59m56s	59m56s
	01	5	1ms	0ms
	02	1	0ms	0ms
	06	2	1h6m7s	33m3s
	08	4	3ms	0ms
	09	4	0ms	0ms
	10	4	2ms	0ms
	11	8	8ms	1ms
	13	3	4ms	1ms
	14	1	0ms	0ms
	15	5	5ms	1ms
	16	4	7ms	1ms
	17	4	56m14s	14m3s
	18	1	1ms	1ms
	19	2	3ms	1ms
	21	3	59m59s	19m59s
	22	3	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-02-01 20:38:43.718933', "last_update" = '2025-02-01 19:53:43.718953', "write_date" = '2025-02-01 19:53:43.395434', "write_uid" = 1 WHERE id IN (1208);

Date: 2025-02-01 21:53:43 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-01 05:05:33.205398', "last_update" = '2025-02-01 04:20:33.205418', "write_date" = '2025-02-01 04:20:32.886923', "write_uid" = 1053 WHERE id IN (1053);

Date: 2025-02-01 06:20:32 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-01-31 23:06:56.639579', "last_update" = '2025-01-31 22:21:56.639595', "write_date" = '2025-01-31 22:21:56.318494', "write_uid" = 1053 WHERE id IN (1053);

Date: 2025-02-01 00:21:53 Duration: 59m56s

6

3h25m8s

53,311

Details

89ms

788ms

230ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 01	00	3,418	10m51s	190ms
	01	2,539	9m52s	233ms
	02	1,211	4m23s	217ms
	05	1,148	4m27s	233ms
	06	1,746	6m52s	236ms
	08	10	2s151ms	215ms
	09	254	56s960ms	224ms
	10	450	1m44s	231ms
	11	146	36s484ms	249ms
	12	276	1m1s	222ms
	13	540	2m23s	265ms
	14	386	1m38s	254ms
	15	634	2m34s	243ms
	16	4,134	19m17s	279ms
	17	4,124	16m50s	245ms
	18	7,418	30m37s	247ms
	19	9,917	36m14s	219ms
	20	5,370	20m43s	231ms
	21	6,208	22m12s	214ms
	22	3,382	11m48s	209ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عمرو')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-01 16:02:36 Duration: 788ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'كريم')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-01 16:02:35 Duration: 777ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمود')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-01 16:42:40 Duration: 765ms

7

3h22m10s

278

Details

0ms

45m6s

43s634ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 01	00	4	45m6s	11m16s
	01	2	0ms	0ms
	02	2	0ms	0ms
	06	2	0ms	0ms
	07	1	0ms	0ms
	08	14	4ms	0ms
	09	25	5ms	0ms
	10	25	2m10s	5s219ms
	11	19	3m49s	12s64ms
	12	19	17ms	0ms
	13	31	37ms	1ms
	14	19	16ms	0ms
	15	29	36ms	1ms
	16	12	20ms	1ms
	17	22	27m27s	1m14s
	18	16	1h6m11s	4m8s
	19	15	19m44s	1m18s
	20	9	11ms	1ms
	21	8	37m40s	4m42s
	22	4	2ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-31 23:21:47.000700', "last_update" = '2025-01-31 22:36:47.000722', "sid" = 'ed33e9c0f14252382cb7e352719e9bb206298906', "write_date" = '2025-01-31 22:36:46.676214', "write_uid" = 1 WHERE id IN (1053);

Date: 2025-02-01 00:21:53 Duration: 45m6s
UPDATE "res_users" SET "exp_date" = '2025-02-01 21:01:03.242809', "last_update" = '2025-02-01 20:16:03.242829', "sid" = 'e475191520da2dbb9dd3769bfea8a145320ba4c7', "write_date" = '2025-02-01 20:16:02.912476', "write_uid" = 1223 WHERE id IN (1223);

Date: 2025-02-01 21:53:43 Duration: 37m40s
UPDATE "res_users" SET "exp_date" = '2025-02-01 17:55:58.824789', "last_update" = '2025-02-01 17:10:58.824816', "sid" = 'c090b3fdea68ba830fddc4bac833e06d2d157f91', "write_date" = '2025-02-01 17:10:58.496634', "write_uid" = 1364 WHERE id IN (1364);

Date: 2025-02-01 18:28:21 Duration: 17m22s

8

2h4m29s

10,517

Details

214ms

1s848ms

710ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	00	381	2m48s	441ms
	01	116	59s31ms	508ms
	02	156	37s248ms	238ms
	06	13	3s92ms	237ms
	09	24	21s895ms	912ms
	10	101	27s249ms	269ms
	11	12	13s492ms	1s124ms
	12	23	7s75ms	307ms
	13	95	1m6s	698ms
	14	99	39s96ms	394ms
	15	205	2m58s	872ms
	16	1,030	15m18s	891ms
	17	967	12m35s	780ms
	18	1,501	18m55s	756ms
	19	2,997	31m44s	635ms
	20	1,346	19m7s	852ms
	21	1,141	12m28s	655ms
	22	310	3m58s	768ms

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

Date: 2025-02-01 16:02:34 Duration: 1s848ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '112197')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-01 16:03:29 Duration: 1s742ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '112185')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-01 16:02:20 Duration: 1s543ms

9

1h51m7s

120,671

Details

42ms

331ms

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
Feb 01	00	3,036	2m37s	51ms
	01	2,301	1m58s	51ms
	02	1,669	1m27s	52ms
	03	672	35s730ms	53ms
	04	27	1s445ms	53ms
	05	493	25s894ms	52ms
	06	1,307	1m8s	52ms
	07	628	32s489ms	51ms
	08	2,441	2m6s	51ms
	09	6,934	6m14s	54ms
	10	13,447	12m56s	57ms
	11	11,500	10m50s	56ms
	12	10,338	9m36s	55ms
	13	10,102	9m21s	55ms
	14	6,744	6m5s	54ms
	15	5,188	4m40s	54ms
	16	6,953	7m1s	60ms
	17	6,807	6m25s	56ms
	18	6,937	6m15s	54ms
	19	7,059	6m23s	54ms
	20	7,746	6m59s	54ms
	21	5,505	4m52s	53ms
	22	2,837	2m29s	52ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4948721, 4891125)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 16:02:50 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4905468)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 16:02:02 Duration: 236ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4913882, 4896196, 4895532, 4889347, 4829092)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 17:22:00 Duration: 229ms

10

1h17m31s

16,464

Details

211ms

508ms

282ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,339	5m46s	259ms
	01	1,171	5m9s	264ms
	02	458	2m1s	265ms
	05	587	2m32s	259ms
	06	866	3m46s	261ms
	08	6	1s547ms	257ms
	09	107	30s279ms	282ms
	10	135	38s659ms	286ms
	11	63	18s148ms	288ms
	12	118	33s547ms	284ms
	13	182	52s409ms	287ms
	14	96	26s735ms	278ms
	15	135	36s834ms	272ms
	16	1,069	5m46s	324ms
	17	1,120	5m32s	296ms
	18	2,244	11m9s	298ms
	19	2,005	9m45s	292ms
	20	1,356	6m30s	287ms
	21	1,998	9m10s	275ms
	22	1,409	6m20s	269ms

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

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

Date: 2025-02-01 16:03:29 Duration: 460ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9969428')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-01 16:24:21 Duration: 452ms

11

44m24s

9,432

Details

177ms

592ms

282ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	08	646	2m51s	264ms
	09	815	3m44s	275ms
	10	774	4m11s	324ms
	11	1,399	6m37s	284ms
	12	797	3m37s	272ms
	13	1,144	5m19s	278ms
	14	1,363	6m13s	274ms
	15	817	3m40s	269ms
	16	1,406	6m39s	283ms
	17	271	1m30s	334ms

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

Date: 2025-02-01 09:59:26 Duration: 592ms
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" = '9999048')))) ORDER BY "collection_policy"."id";

Date: 2025-02-01 10:03:54 Duration: 588ms
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" = '110940')))) ORDER BY "collection_policy"."id";

Date: 2025-02-01 10:04:41 Duration: 585ms

12

38m54s

18,987

Details

96ms

754ms

122ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	07	84	10s155ms	120ms
	08	321	37s965ms	118ms
	09	826	1m38s	119ms
	10	1,702	3m35s	126ms
	11	2,281	4m42s	123ms
	12	2,048	4m11s	122ms
	13	2,010	4m4s	121ms
	14	2,188	4m15s	116ms
	15	1,923	3m49s	119ms
	16	2,134	4m57s	139ms
	17	1,192	2m29s	125ms
	18	642	1m14s	116ms
	19	589	1m8s	116ms
	20	524	1m1s	117ms
	21	488	54s288ms	111ms
	22	35	4s119ms	117ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8052317)) AND (("cash_track"."id" not in (7460887, 7463425, 7465109, 7583786, 7594489, 7594489)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-01 16:02:13 Duration: 754ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8052454)) AND (("cash_track"."id" not in (7461181, 7464701, 7465044, 7582828, 7594488, 7594488)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-01 16:02:13 Duration: 747ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8060567)) AND (("cash_track"."id" not in (7521283, 7524267, 7546192, 7581690, 7594434, 7594434)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-01 16:01:59 Duration: 636ms

13

37m5s

11,339

Details

165ms

422ms

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
Feb 01	02	3	560ms	186ms
	05	133	24s261ms	182ms
	06	385	1m10s	182ms
	07	1,089	3m18s	182ms
	08	367	1m6s	182ms
	09	1,754	5m35s	191ms
	10	2,219	7m39s	207ms
	11	1,601	5m22s	201ms
	12	1,823	6m6s	201ms
	13	189	37s702ms	199ms
	14	262	50s551ms	192ms
	15	260	49s718ms	191ms
	16	88	20s865ms	237ms
	17	12	2s243ms	186ms
	18	76	14s902ms	196ms
	19	156	30s462ms	195ms
	20	241	46s70ms	191ms
	21	333	1m2s	187ms
	22	348	1m5s	188ms

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" = '181327')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:05 Duration: 422ms
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" = '104288')) 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 (9)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:01:37 Duration: 342ms
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" = '9724858')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:07 Duration: 340ms

14

18m7s

2,154

Details

365ms

731ms

504ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	08	160	1m13s	457ms
	09	359	2m48s	470ms
	10	325	3m1s	557ms
	11	466	4m4s	523ms
	12	556	4m36s	498ms
	13	270	2m13s	492ms
	14	4	2s152ms	538ms
	15	14	7s516ms	536ms

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

Date: 2025-02-01 10:05:22 Duration: 731ms
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" = '70328')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-01 10:09:14 Duration: 726ms
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" = '70287')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-01 10:09:09 Duration: 709ms

15

17m34s

18,353

Details

45ms

105ms

57ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 01	06	19	993ms	52ms
	08	915	48s531ms	53ms
	09	1,323	1m10s	53ms
	10	1,166	1m8s	58ms
	11	1,999	1m54s	57ms
	12	1,653	1m34s	57ms
	13	1,942	1m49s	56ms
	14	2,637	2m26s	55ms
	15	1,601	1m28s	55ms
	16	3,243	3m22s	62ms
	17	1,302	1m16s	58ms
	18	245	14s438ms	58ms
	19	159	9s464ms	59ms
	20	134	7s971ms	59ms
	21	10	593ms	59ms
	22	5	280ms	56ms

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

Date: 2025-02-01 12:10:16 Duration: 105ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4866592) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-01 16:10:48 Duration: 102ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4635534) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-01 17:21:59 Duration: 101ms

16

15m5s

4,972

Details

166ms

213ms

182ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,112	3m20s	180ms
	01	1,789	5m26s	182ms
	02	1,200	3m39s	182ms
	03	842	2m33s	182ms
	04	29	5s283ms	182ms

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

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

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

Date: 2025-02-01 00:06:21 Duration: 206ms

17

14m49s

6,149

Details

120ms

305ms

144ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 01	00	47	6s105ms	129ms
	06	11	1s428ms	129ms
	08	51	6s734ms	132ms
	09	422	58s207ms	137ms
	10	1,490	3m43s	150ms
	11	949	2m18s	145ms
	12	986	2m22s	145ms
	13	738	1m44s	141ms
	14	554	1m16s	137ms
	15	268	36s947ms	137ms
	16	253	41s75ms	162ms
	17	89	13s229ms	148ms
	18	110	15s487ms	140ms
	19	44	6s158ms	139ms
	20	63	8s878ms	140ms
	21	61	8s259ms	135ms
	22	13	1s726ms	132ms

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

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

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

Date: 2025-02-01 17:23:48 Duration: 281ms

18

12m33s

3,744

Details

167ms

303ms

201ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 01	05	936	2m51s	182ms
	06	11	2s44ms	185ms
	09	1,045	3m39s	210ms
	10	1,752	6m1s	206ms

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

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

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

Date: 2025-02-01 10:25:15 Duration: 273ms

19

10m58s

2,726

Details

203ms

1s353ms

241ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 01	00	120	27s368ms	228ms
	01	120	27s369ms	228ms
	02	120	27s282ms	227ms
	03	120	27s74ms	225ms
	04	120	27s196ms	226ms
	05	120	27s222ms	226ms
	06	120	27s230ms	226ms
	07	120	27s166ms	226ms
	08	120	27s331ms	227ms
	09	120	28s489ms	237ms
	10	120	30s957ms	257ms
	11	120	29s852ms	248ms
	12	120	30s44ms	250ms
	13	120	29s112ms	242ms
	14	120	29s240ms	243ms
	15	120	28s714ms	239ms
	16	120	33s358ms	277ms
	17	116	30s140ms	259ms
	18	120	30s214ms	251ms
	19	120	30s585ms	254ms
	20	120	30s221ms	251ms
	21	120	29s748ms	247ms
	22	90	22s83ms	245ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-01 16:02:04 Duration: 1s353ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-01 16:02:03 Duration: 1s252ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-01 12:10:02 Duration: 393ms

20

10m36s

2,395

Details

17ms

2s398ms

265ms

select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1	116ms	116ms
	04	1	408ms	408ms
	08	57	8s457ms	148ms
	09	87	18s909ms	217ms
	10	174	38s590ms	221ms
	11	285	1m11s	250ms
	12	312	1m17s	247ms
	13	312	1m23s	266ms
	14	268	1m6s	247ms
	15	272	1m11s	262ms
	16	234	1m6s	285ms
	17	122	48s813ms	400ms
	18	82	24s903ms	303ms
	19	63	21s930ms	348ms
	20	61	19s37ms	312ms
	21	50	15s192ms	303ms
	22	14	3s811ms	272ms

SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-01 17:14:29 Duration: 2s398ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-01 16:01:45 Duration: 1s929ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (40)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (40))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-01 17:14:28 Duration: 1s35ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,134,525

Details

1m39s

0ms

2ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 01	00	31,351	1s494ms	0ms
	01	31,092	1s540ms	0ms
	02	27,732	1s359ms	0ms
	03	18,604	794ms	0ms
	04	10,032	283ms	0ms
	05	12,482	527ms	0ms
	06	21,932	1s61ms	0ms
	07	17,625	807ms	0ms
	08	56,555	2s771ms	0ms
	09	125,518	6s803ms	0ms
	10	190,099	8s582ms	0ms
	11	191,507	8s970ms	0ms
	12	185,053	9s446ms	0ms
	13	185,990	8s598ms	0ms
	14	163,718	7s869ms	0ms
	15	174,757	7s317ms	0ms
	16	154,977	6s624ms	0ms
	17	136,249	6s93ms	0ms
	18	118,341	5s206ms	0ms
	19	102,556	4s695ms	0ms
	20	85,908	4s37ms	0ms
	21	58,025	2s730ms	0ms
	22	34,422	1s629ms	0ms

DISCARD ALL;

Date: 2025-02-01 09:45:10 Duration: 2ms
DISCARD ALL;

Date: 2025-02-01 00:25:54 Duration: 1ms
DISCARD ALL;

Date: 2025-02-01 16:00:13 Duration: 1ms

2

1,665,619

Details

22s774ms

0ms

15ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 01	00	22,837	352ms	0ms
	01	23,779	362ms	0ms
	02	21,488	328ms	0ms
	03	13,751	210ms	0ms
	04	6,090	101ms	0ms
	05	8,996	155ms	0ms
	06	17,266	265ms	0ms
	07	13,314	211ms	0ms
	08	44,930	625ms	0ms
	09	100,762	1s444ms	0ms
	10	153,796	2s26ms	0ms
	11	153,152	2s36ms	0ms
	12	146,831	2s28ms	0ms
	13	148,137	1s954ms	0ms
	14	126,208	1s699ms	0ms
	15	137,257	1s719ms	0ms
	16	118,553	1s676ms	0ms
	17	106,520	1s439ms	0ms
	18	89,629	1s173ms	0ms
	19	77,504	1s53ms	0ms
	20	66,067	930ms	0ms
	21	43,429	609ms	0ms
	22	25,323	370ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-01 09:57:26 Duration: 15ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-01 09:50:00 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-01 16:14:30 Duration: 1ms

3

1,087,413

Details

10s596ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 01	00	16,446	150ms	0ms
	01	16,152	154ms	0ms
	02	14,467	135ms	0ms
	03	9,893	84ms	0ms
	04	5,587	43ms	0ms
	05	6,854	63ms	0ms
	06	11,591	107ms	0ms
	07	9,408	85ms	0ms
	08	29,126	268ms	0ms
	09	63,876	630ms	0ms
	10	96,154	996ms	0ms
	11	96,901	950ms	0ms
	12	93,704	921ms	0ms
	13	94,490	924ms	0ms
	14	83,044	787ms	0ms
	15	88,609	819ms	0ms
	16	78,432	841ms	0ms
	17	69,073	694ms	0ms
	18	60,055	574ms	0ms
	19	52,093	493ms	0ms
	20	43,897	425ms	0ms
	21	29,813	276ms	0ms
	22	17,748	167ms	0ms

ROLLBACK;

Date: 2025-02-01 17:12:22 Duration: 1ms
ROLLBACK;

Date: 2025-02-01 18:41:04 Duration: 0ms
ROLLBACK;

Date: 2025-02-01 17:33:59 Duration: 0ms

4

1,075,487

Details

2m58s

0ms

22ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 01	00	15,719	2s460ms	0ms
	01	15,502	2s507ms	0ms
	02	13,832	2s145ms	0ms
	03	9,264	1s226ms	0ms
	04	4,977	490ms	0ms
	05	6,212	849ms	0ms
	06	10,949	1s613ms	0ms
	07	8,781	1s242ms	0ms
	08	28,571	4s202ms	0ms
	09	63,405	10s227ms	0ms
	10	95,903	16s562ms	0ms
	11	96,803	16s122ms	0ms
	12	93,557	15s638ms	0ms
	13	94,117	15s849ms	0ms
	14	82,624	13s459ms	0ms
	15	88,039	14s9ms	0ms
	16	77,674	14s577ms	0ms
	17	68,625	12s236ms	0ms
	18	59,498	9s800ms	0ms
	19	51,555	8s706ms	0ms
	20	43,248	7s487ms	0ms
	21	29,242	4s570ms	0ms
	22	17,390	2s702ms	0ms

SELECT payload FROM http_sessions WHERE sid = '08d3bda9b805e3dd6b29f7db6ab459016083ab96';

Date: 2025-02-01 16:09:32 Duration: 22ms
SELECT payload FROM http_sessions WHERE sid = '45124f51cfa1c79acdd7408813d271cc423acec4';

Date: 2025-02-01 19:50:23 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '14a300f2a4f3cf23ce93a60c4f2b7f9bd5253bca';

Date: 2025-02-01 16:09:32 Duration: 11ms

5

1,067,359

Details

1m33s

0ms

3ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 01	00	15,745	1s339ms	0ms
	01	15,616	1s351ms	0ms
	02	13,941	1s181ms	0ms
	03	9,387	735ms	0ms
	04	5,106	355ms	0ms
	05	6,318	523ms	0ms
	06	11,057	930ms	0ms
	07	8,878	741ms	0ms
	08	28,291	2s316ms	0ms
	09	62,731	5s348ms	0ms
	10	94,958	8s555ms	0ms
	11	95,715	8s413ms	0ms
	12	92,505	8s9ms	0ms
	13	92,922	8s124ms	0ms
	14	81,833	7s44ms	0ms
	15	87,261	7s435ms	0ms
	16	77,392	7s450ms	0ms
	17	68,043	6s213ms	0ms
	18	59,130	5s175ms	0ms
	19	51,294	4s425ms	0ms
	20	42,937	3s856ms	0ms
	21	29,038	2s352ms	0ms
	22	17,261	1s442ms	0ms

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

Date: 2025-02-01 10:23:47 Duration: 3ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-01 22:14:50 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-01 17:34:24 Duration: 1ms

6

740,001

Details

1m48s

0ms

16ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 01	00	7,759	1s333ms	0ms
	01	8,794	1s499ms	0ms
	02	8,295	1s354ms	0ms
	03	4,383	819ms	0ms
	04	297	244ms	0ms
	05	2,400	595ms	0ms
	06	7,194	1s217ms	0ms
	07	4,337	838ms	0ms
	08	20,052	2s885ms	0ms
	09	47,664	7s295ms	0ms
	10	75,032	10s350ms	0ms
	11	73,592	10s536ms	0ms
	12	69,711	11s339ms	0ms
	13	69,941	10s43ms	0ms
	14	55,243	7s809ms	0ms
	15	62,042	8s59ms	0ms
	16	50,462	7s379ms	0ms
	17	47,856	6s753ms	0ms
	18	38,184	5s126ms	0ms
	19	32,077	4s636ms	0ms
	20	28,084	4s6ms	0ms
	21	17,020	2s520ms	0ms
	22	9,582	1s534ms	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 (832);

Date: 2025-02-01 17:54:23 Duration: 16ms
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 (1049);

Date: 2025-02-01 17:54:23 Duration: 13ms
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 (1301);

Date: 2025-02-01 17:21:54 Duration: 10ms

7

577,184

Details

1m36s

0ms

39ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 01	00	6,408	1s88ms	0ms
	01	7,625	1s370ms	0ms
	02	7,023	1s270ms	0ms
	03	3,858	679ms	0ms
	04	503	64ms	0ms
	05	2,139	354ms	0ms
	06	5,674	874ms	0ms
	07	3,906	611ms	0ms
	08	15,796	2s251ms	0ms
	09	36,880	5s546ms	0ms
	10	57,484	9s250ms	0ms
	11	56,163	9s223ms	0ms
	12	53,093	8s889ms	0ms
	13	53,601	8s911ms	0ms
	14	43,113	7s49ms	0ms
	15	48,506	7s502ms	0ms
	16	39,891	7s693ms	0ms
	17	37,305	6s440ms	0ms
	18	29,499	4s875ms	0ms
	19	25,381	4s512ms	0ms
	20	22,128	4s201ms	0ms
	21	13,633	2s634ms	0ms
	22	7,575	1s434ms	0ms

COMMIT;

Date: 2025-02-01 16:02:35 Duration: 39ms
COMMIT;

Date: 2025-02-01 16:24:53 Duration: 36ms
COMMIT;

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

8

456,838

Details

28s426ms

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
Feb 01	00	4,468	239ms	0ms
	01	3,721	213ms	0ms
	02	3,560	197ms	0ms
	03	1,630	88ms	0ms
	04	22	1ms	0ms
	05	1,250	68ms	0ms
	06	4,785	239ms	0ms
	07	2,679	137ms	0ms
	08	11,421	617ms	0ms
	09	27,552	1s611ms	0ms
	10	45,754	3s72ms	0ms
	11	44,061	2s747ms	0ms
	12	42,725	2s635ms	0ms
	13	43,589	2s751ms	0ms
	14	32,810	2s1ms	0ms
	15	37,919	2s308ms	0ms
	16	32,212	2s383ms	0ms
	17	31,641	2s55ms	0ms
	18	25,628	1s526ms	0ms
	19	22,791	1s360ms	0ms
	20	18,652	1s155ms	0ms
	21	11,577	647ms	0ms
	22	6,391	364ms	0ms

SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (8, 17, 111, 77, 75, 51, 55, 27, 14, 6, 70, 3, 52, 9, 13, 39, 64, 61, 65, 66, 60, 32, 123);

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

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

Date: 2025-02-01 16:36:34 Duration: 1ms

9

446,228

Details

55s442ms

0ms

5ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 01	00	6,451	615ms	0ms
	01	5,050	499ms	0ms
	02	4,761	519ms	0ms
	03	1,961	210ms	0ms
	04	21	2ms	0ms
	05	2,016	252ms	0ms
	06	5,024	510ms	0ms
	07	1,661	193ms	0ms
	08	10,978	1s324ms	0ms
	09	27,824	3s337ms	0ms
	10	44,945	6s167ms	0ms
	11	44,364	5s950ms	0ms
	12	42,222	5s419ms	0ms
	13	39,549	4s970ms	0ms
	14	29,086	3s524ms	0ms
	15	32,869	3s954ms	0ms
	16	30,300	4s323ms	0ms
	17	30,404	3s850ms	0ms
	18	25,750	3s20ms	0ms
	19	23,760	2s638ms	0ms
	20	19,229	2s314ms	0ms
	21	11,441	1s137ms	0ms
	22	6,562	702ms	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 (5115296, 5099244, 5500058, 5099296, 5126345, 5472721, 5099028, 5099013, 5099144, 5101432, 5101413, 5116563, 5099179, 5103909, 5099045, 5099415, 5099009, 5100511, 5111804, 5500057, 5100660, 5184894, 5100824, 5110718, 5100352, 5099305, 5099698, 5099167, 5099848, 5183386, 5112839, 5099138, 5099540, 5099141, 5099403, 5472818, 5416730, 5099671, 5116074, 5099590, 5099007, 5119831, 5119665, 5099035, 5105930, 5099604, 5100116, 5099137, 5103284, 5099129, 5099761, 5099503, 5108653, 5099693, 5441468, 5100259, 5099136, 5099807, 5099331, 5099206, 5154728, 5100659);

Date: 2025-02-01 17:21:54 Duration: 5ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5107075, 5099082, 5101438, 5098989, 5099456, 5100913, 5100724, 5106266, 5099140, 5099503, 5099774, 5099134, 5108985, 5099111, 5099433, 5099521, 5230317, 5099108, 5100384, 5099216, 5118087, 5103377, 5099684, 5101969, 5104336, 5152496, 5099474, 5105206, 5100061, 5435155, 5099148, 5122388, 5178160, 5151482, 5101638, 5099155, 5099080, 5101160, 5497682, 5132509, 5224286, 5108796, 5100181, 5104400, 5412770, 5497294, 5099719, 5105188, 5100016, 5105626, 5099282, 5099707, 5099585, 5099121, 5101661, 5175055, 5124219, 5122384, 5099187, 5100838, 5123010, 5116714, 5100199, 5126878, 5208767, 5100615, 5099482, 5198278, 5107494, 5101185, 5099358, 5102921, 5108826, 5099722, 5099958, 5099130, 5099202, 5099504, 5365876, 5099348, 5108701, 5110315, 5102054, 5099103, 5100009, 5099632, 5105759, 5187688, 5100005, 5102816, 5100192, 5102217, 5099281, 5100826, 5099360, 5100512, 5105731, 5260871, 5107032, 5102117, 5286790, 5100427, 5099091, 5099916, 5112926, 5099859, 5099540, 5099464, 5109452, 5099092, 5098996, 5100144, 5162281, 5100185, 5106885, 5108640, 5101028, 5110726, 5109542, 5099403, 5104247, 5205707, 5100320, 5104226, 5099602, 5101754, 5129313, 5099322);

Date: 2025-02-01 17:21:55 Duration: 4ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099920, 5099028, 5099403, 5100111, 5099010, 5103193, 5099321, 5099258, 5099097, 5100525, 5099004, 5099599, 5104243, 5100953, 5244872, 5099659, 5101356, 5123786, 5106005, 5099006, 5128159, 5105335, 5099009, 5099167, 5110703, 5099007, 5497075, 5100091, 5099348, 5099382, 5102793, 5146927, 5107911, 5464195);

Date: 2025-02-01 17:21:54 Duration: 4ms

10

337,086

Details

1m45s

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
Feb 01	00	1,849	533ms	0ms
	01	2,212	678ms	0ms
	02	1,153	372ms	0ms
	03	658	204ms	0ms
	04	23	6ms	0ms
	05	400	107ms	0ms
	06	1,113	338ms	0ms
	07	909	263ms	0ms
	08	8,226	2s440ms	0ms
	09	14,069	4s456ms	0ms
	10	35,034	11s379ms	0ms
	11	29,853	9s549ms	0ms
	12	26,632	8s525ms	0ms
	13	33,449	10s659ms	0ms
	14	26,392	8s55ms	0ms
	15	38,400	11s346ms	0ms
	16	32,963	11s83ms	0ms
	17	26,686	8s459ms	0ms
	18	21,066	6s194ms	0ms
	19	13,792	4s111ms	0ms
	20	12,743	3s824ms	0ms
	21	6,097	1s657ms	0ms
	22	3,367	978ms	0ms

SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.customer' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1322) OR r.global) ORDER BY r.id;

Date: 2025-02-01 16:24:38 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-02-01 10:24:08 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 = 1001) OR r.global) ORDER BY r.id;

Date: 2025-02-01 20:23:33 Duration: 2ms

11

314,038

Details

57s238ms

0ms

10ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 01	00	2,483	422ms	0ms
	01	2,321	429ms	0ms
	02	2,161	399ms	0ms
	03	1,163	209ms	0ms
	04	65	7ms	0ms
	05	622	104ms	0ms
	06	3,142	487ms	0ms
	07	2,003	288ms	0ms
	08	10,015	1s490ms	0ms
	09	20,278	3s447ms	0ms
	10	31,093	6s147ms	0ms
	11	31,339	5s835ms	0ms
	12	29,680	5s385ms	0ms
	13	30,117	5s519ms	0ms
	14	23,041	4s36ms	0ms
	15	28,178	4s877ms	0ms
	16	22,923	4s792ms	0ms
	17	21,840	4s186ms	0ms
	18	16,080	2s870ms	0ms
	19	12,939	2s357ms	0ms
	20	11,739	2s107ms	0ms
	21	6,847	1s153ms	0ms
	22	3,969	680ms	0ms

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

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

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

Date: 2025-02-01 17:21:54 Duration: 3ms

12

259,942

Details

44s949ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,839	237ms	0ms
	01	2,565	331ms	0ms
	02	1,283	160ms	0ms
	03	980	114ms	0ms
	04	47	6ms	0ms
	05	481	59ms	0ms
	06	955	136ms	0ms
	07	980	138ms	0ms
	08	8,621	1s259ms	0ms
	09	12,840	1s989ms	0ms
	10	26,150	4s854ms	0ms
	11	21,591	3s839ms	0ms
	12	18,907	3s372ms	0ms
	13	25,449	4s593ms	0ms
	14	19,324	3s238ms	0ms
	15	29,481	4s902ms	0ms
	16	25,025	5s60ms	0ms
	17	20,447	3s673ms	0ms
	18	15,070	2s590ms	0ms
	19	9,620	1s578ms	0ms
	20	10,475	1s706ms	0ms
	21	4,815	669ms	0ms
	22	2,997	435ms	0ms

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

Date: 2025-02-01 17:13:22 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 830 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_system' AND model = 'res.groups');

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

Date: 2025-02-01 17:13:22 Duration: 1ms

13

210,770

Details

55s383ms

0ms

27ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	00	3,370	732ms	0ms
	01	2,584	599ms	0ms
	02	2,039	482ms	0ms
	03	700	169ms	0ms
	04	7	1ms	0ms
	05	1,027	275ms	0ms
	06	2,530	580ms	0ms
	07	782	184ms	0ms
	08	4,589	1s114ms	0ms
	09	11,142	2s694ms	0ms
	10	18,420	5s136ms	0ms
	11	18,765	5s205ms	0ms
	12	18,637	4s416ms	0ms
	13	18,742	6s5ms	0ms
	14	14,249	3s190ms	0ms
	15	15,536	3s427ms	0ms
	16	16,340	4s448ms	0ms
	17	14,942	3s755ms	0ms
	18	13,512	5s388ms	0ms
	19	12,766	2s985ms	0ms
	20	9,411	2s341ms	0ms
	21	6,987	1s458ms	0ms
	22	3,693	786ms	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 (40772223, 40974144, 41283200, 41737407, 41842224, 32214257, 32214394, 32214546, 32265724, 39733642, 39833299, 39885485, 40123233, 40326088, 40326332, 40713932, 40919098, 41132577, 41426250, 41661690, 41697979, 41722580, 41936637, 42058405, 42118949, 42119404, 32265674, 32266277, 32593200, 38977445, 39132381, 39192832, 39228086, 39304815, 39516078, 39516281, 39589227, 39590405, 39595437, 39613378, 39617479, 39629887, 39631052, 39644101, 39647696, 39667895, 39669116, 39705149, 39727983, 39728857, 39730888, 39737150, 39741729, 39749445, 39752062, 39760935, 39780900, 39781048, 39836550, 40357922, 40357924, 40422851, 40479492, 40607998, 40936283, 41026022, 41037630, 41131925, 41200554, 41238194, 41238205, 41723289, 41791181, 42145944, 41958422, 41460564, 39202824, 41200076, 32197671, 32640389, 39782081, 39946873, 40261778, 40268735, 40279837, 40309477, 40463013, 40526190, 40982456, 41573360, 41575406, 41575550, 41662308, 41698276, 41791022, 41791316, 42119580, 32571914, 32595839, 32602994);

Date: 2025-02-01 17:21:54 Duration: 27ms
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 (32196567, 32205178, 41580897, 32229020, 41810408, 41810218, 41519099, 41388142, 42081147, 32242975, 32229424, 32196581, 41746634, 42024323, 41535592, 32192037, 41882804, 41387219, 32226284, 32191064, 41634010, 32228874, 41253060, 42096295, 41595787, 42002117, 32297678, 32192622, 41383050, 41443591, 41519583, 41339668, 41233816, 40870189, 42117313, 42056714, 32191047, 41883036, 42129037, 32189096, 32192625, 41455968, 32228861, 32228858, 42002587, 42002293, 41633670, 41578346, 42058770, 42103651, 42103964, 41612943, 40835736, 42159044, 41259869, 40967549, 32284643, 41493971, 41543302, 41473212, 41486172, 42137396, 32226003, 42137764, 42043872, 32656764, 42157659, 32229011, 42112522, 42170660, 32234056, 42056222, 42110929, 41453349, 41529165, 42107381, 42110928, 41555024, 32657422, 32216740, 32216532, 42161752, 32191981, 41519201, 32191773, 41325701, 32192072, 41554969, 41771354, 41838372, 41439953, 41590441, 41446811, 42081090, 32277926, 41935138, 41675525, 41328218, 32192604, 42141468);

Date: 2025-02-01 17:21:55 Duration: 24ms
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 (40865047, 40729317, 40865470, 40865907, 40834723, 40835090, 40865369, 40513733, 40865956, 40812110, 40812117, 40865752, 40865751, 40590143, 40835286, 40835282, 40731060, 40865148, 40866351, 40835909, 40731285, 40834793, 40730639, 39958979, 40865135, 40731067, 40731048, 40731091, 40731054, 40731059, 40731085, 40731077, 40259527, 40945942, 40865009, 40834909, 40865212, 40834731, 40834725, 40834729, 40865010, 40812640, 40864995, 40865960, 40945697, 40834815, 40730550, 40865969, 40731038, 40865149, 40865386, 40866313, 40514240, 40514233, 40945696, 40731418, 40946674, 40866041, 40946654, 40946673, 40866040, 40946655, 40866039, 40866037, 40866033, 40835854, 40835852, 40835850, 40835857, 40835859, 40835853, 40835855, 40835851, 40836010, 40836423, 40648578, 40729885, 40731354, 32632466, 40730512, 40589975, 40022569, 40374876, 40260140, 40649221, 40648010, 40022100, 32632829, 32632947, 32632816, 32632958, 32632808, 32632479, 32632812, 39934235, 39934236, 32632467, 32632784, 32632469, 32632470, 32632468, 40517475, 40516694, 40517477, 40516835, 40834733, 40812555, 40866409, 40945700, 40812556, 40865033, 40865017, 40945865, 40945864, 40945868, 40865050, 40834685, 40945867, 40864769, 40811851, 40945643, 40865219, 40864776, 40812552, 40731529, 40812605, 40865332, 40834917, 40836270, 40835697, 40590434, 40514998, 40230962, 40374762, 40812063, 40836189, 40731617, 40731565, 40648717, 40649031, 40649352, 40647858, 40374855, 39713938, 40258690, 40084418, 40865988, 40945680, 40945665, 40945720, 40946194, 40946198, 40946199, 38981039, 39351803, 40945717, 40946195, 40864853, 40731135, 40731139, 32632592, 32633026, 32632560, 32633014, 32632547, 32632972, 32632554, 32632542, 32632993, 40836374, 40946344, 40945951, 40946509, 40866435, 40836627, 40866071, 40866060, 40945909, 40729294, 40945904, 40945903, 40866073, 40836281, 40866154, 40865776, 40865779, 40945878, 40945882, 40835862, 40835863, 40835868, 40835861, 40835867, 40835865, 40835856, 40835864, 40835869, 40835866, 40946249, 40946248, 40946254, 40946256, 40946596, 40946593, 40836641, 40865338, 40865337, 40945666, 40945913, 40866153, 40731132, 40947242, 40946273, 32632937, 32632916, 32632919, 32632927, 32632928, 32632579, 40946275, 32632585, 32632553, 40835871, 40835881, 40835880, 40647578, 40647577, 40835879, 40835882, 40647581, 40647580, 40647579, 40864993, 40515638, 39452938, 39835766, 32632460, 40864784, 40836148, 40589683, 40515846, 32613832, 40731621, 40648012, 40835598, 32614039, 40834773, 40946358, 40865785, 40811804, 40865788, 40865786, 40865790, 40865787, 40865789, 40420809, 40420808, 40946216, 40836034, 40834787, 40945925, 40946899, 40945935, 40866082, 40946846, 40945991, 40946457, 40945934, 40946354, 40946350, 40946347, 40946459, 40946458, 40945724, 40945730, 40945739, 40945723, 40946947, 40946945, 40945816, 40945933, 40946325, 40947376, 40947378, 40022876, 40947371, 32632617, 40022873, 32632610, 32632595, 32632594, 40947444, 40022860, 40836494, 40835889, 40835891, 40836492, 40835888, 40947253, 40947254, 40947265, 40948593, 40948596, 40948592, 40865016, 32633024, 39958985, 40946363, 40947393, 40947422, 40946362, 40946364, 40946366, 40946538, 40945936, 40947402, 40260240, 40260238, 40947424, 40947104, 40948394, 40948192, 40948174, 40946360, 40946372, 40946157, 40948395, 40946589, 40947013, 40866166, 40946861, 40946716, 40946733, 40946936, 40946931, 40864912, 40834789, 40946864, 40866169, 40866170, 40947447, 40811809, 40945890, 40992056, 40811442, 40947388, 32632634, 40992052, 40992048, 40947381, 40992047, 40992361, 40992386, 40992345, 40992359, 40948640, 40836507, 40836501, 40836505, 40836506, 40836503, 40836504, 40836500, 40834648, 40084791, 40946481, 40992392, 40946480, 40946485, 40948495, 40948266, 40948265, 40946160, 40947438, 40865255, 40946378, 40948500, 40948498, 40946376, 40946380, 40865054, 40811690, 40946339, 40991842, 40947436, 40865250, 40945896, 40946381, 40947114, 40947504, 40864922, 40946412, 40946600, 40864740, 40991692, 40947155, 40811822, 40947159, 40948051, 40947156, 40947592, 40947610, 40864730, 40947165, 40947166, 40947167, 40992293, 40947164, 40834686, 40812562, 40947502, 40947496, 40992597, 40992596, 40992606, 40992592, 40992571, 40992578, 40993418, 40992563, 40992562, 40993412, 40992588, 40992560, 40992166, 40836511, 40647583, 40647584, 40836510, 40647582, 40836512, 40992161, 40946917, 40947296, 40514125, 40993246, 40948373, 40948465, 40948464, 40948466, 40992523, 40948381, 40948378, 40993245, 40992000, 40948374, 40948458, 40948463, 40991998, 40991999, 40991997, 40948503, 40946749, 40946390, 40946391, 40946389, 40948315, 40946609, 40948285, 40948286, 40993142, 40866190, 40811852, 40646876, 40992322, 40992327, 40992326, 40992318, 40991944, 40948089, 40992324, 40991943, 40992321, 40992329, 40992313, 40992396, 40991899, 40729330, 40515813, 40945761, 40865055, 40947171, 40948284, 40992319, 40992323, 40992315, 40992316, 40992320, 40992328, 40992317, 40992325, 40992120, 40947428, 40729252, 40947297, 40992314, 40945764, 40948316, 40947045, 40811880, 40811878, 40836450, 40515635, 32632607, 40515150, 40515202, 40589971, 40375380, 40835914, 40865161, 40514105, 40646643, 40230651, 40647448, 40589737, 40259355, 40834797, 40229110, 40229335, 40729880, 40514059, 40515746, 32632983, 32632854, 40835477, 40729033, 40865993, 40835216, 40993556, 40993437, 40993436, 40993438, 40948517, 40948518, 40948468, 40865796, 40947177, 40947174, 40992127, 40992476, 40993209, 40993210, 40946439, 40993492, 40992658, 40992712, 40993493, 40993217, 40835221, 40992660, 40811831, 40948109, 40948496, 40948117, 40836518, 40836519, 40836525, 40836517, 40836526, 40836528, 40836520, 40836522, 40836523, 40836524, 40836527, 40836521, 41103222, 41103216, 41103217, 41103223, 41103224, 41103214, 41103202, 40993581, 40993561, 40993559, 41103528, 41103530, 41103529, 41103502, 41103504, 41103505, 40946725, 40835713, 40865158, 40589838, 38981018, 40420400, 40515789, 40420429, 40420428, 32613795, 40259403, 39933776, 40646974, 40515559, 40422060, 40945771, 40812569, 40812568, 40993360, 40993264, 40993258, 40993355, 41103568, 40991696, 40948472, 40947430, 40992134, 40991695, 40947431, 40947429, 40945902, 40812074, 40865804, 40993223, 40946115, 40993228, 40991643, 40992674, 40993498, 40946240, 40992331, 40991644, 40992678, 40992685, 40992686, 40992688, 40992687, 40992675, 40993151, 40991642, 40947179, 40947180, 40992677, 40992332, 40834783, 40947537, 40865533, 40992061, 40024290, 40947539, 40992020, 40947508, 40947527, 40947521, 41102870, 41103120, 40993585, 40993587, 41103096, 40993582, 40993586, 40993588, 41103092, 41103093, 41103103, 41102846, 41103104, 41102852, 41102842, 40993575, 41103480, 41103479, 41103482, 41103481, 41103455, 41103458, 40866366, 40836535, 40836530, 40836538, 40836529, 40836534, 40836532, 40836533, 40836536, 40836537, 41103239, 40946680, 40835431, 40836419, 40865540, 40948484, 40993368, 40993370, 40992035, 40992038, 40946633, 40948480, 40993365, 40948491, 40993376, 40866113, 41103552, 41103556, 41103554, 41103543, 41103343, 41102993, 40946241, 41102950, 40992876, 40947187, 41102655, 41102647, 41103351, 41102951, 41101744, 41101751, 40946129, 41101742, 41101743, 41101747, 40946137, 40946624, 40991700, 41101866, 40992478, 41103577, 40865531, 40948099, 41103296, 41101668, 41101670, 41101667, 40836540, 40836541, 41102468, 41102464, 41102443, 40993451, 41103131, 41102878, 41102881, 41103126, 41101661, 40946934, 40835520, 40835457, 40729034, 40729028, 40083985, 40083966, 40420216, 40866534, 40420486, 40514496, 40946384, 40420804, 40945798, 40835318, 40835462, 40836192, 40649043, 40865176, 40835460, 40729003, 40515716, 40947558, 40947572, 40947565, 40947559, 40947551, 40992491, 41102702, 41101192, 41101247, 41101250, 41101249, 41101243, 40993382, 40993381, 40993387, 40991649, 41102994, 41102999, 40991654, 41103544, 40991653, 41102797, 41102354, 41102359, 41102347, 41102348, 40946641, 41101879, 41103545, 41102350, 41102966, 40948332, 40811887, 41101246, 40835014, 40991655, 40991650, 41100942, 41100644, 41100643, 41100642, 41100645, 40991646, 40991648, 41103358, 40991657, 40991656, 40991647, 40991651, 41102998, 41101757, 41101703, 41102955, 40993478, 40993477, 41101612, 41101615, 39167720, 40993480, 41162652, 41101681, 41103486, 40647588, 40947895, 40647590, 40647589, 41100810, 40647587, 41100814, 40947894, 40947892, 40947893, 41100807, 41100792, 41103542, 40945746, 40731044, 40812093, 40812070, 40731395, 40647022, 40421682, 40260553, 40948446, 40946401, 39836939, 40230886, 40230786, 40260552, 41163627, 41101633, 41162658, 41162719, 41162656, 41162676, 41162675, 40647585, 40947899, 41163599, 40947898, 40947897, 40947896, 40947900, 40647586, 41163601, 41163600, 41103143, 40991964, 41101409, 41101253, 40993485, 41101412, 41101262, 41101272, 41101266, 41101275, 41101267, 41100957, 41100950, 41102088, 41102079, 41102111, 41100948, 40974583, 41102293, 41101197, 41162894, 41102975, 41101102, 41102053, 41101569, 41102205, 41102204, 41102192, 41102201, 41102200, 41102199, 41102203, 41102198, 41102202, 41100648, 41100651, 41100650, 41102165, 41103548, 41100649, 41102666, 40811746, 40811744, 41102818, 41102673, 41103150, 41101408, 40991968, 41101786, 41101767, 41101768, 41101421, 40812573, 41102492, 40812574, 40812576, 41101719, 41101713, 40836481, 40836469, 41100844, 41102806, 41101002, 41101217, 41101001, 41162860, 41103191, 41102265);

Date: 2025-02-01 16:50:00 Duration: 18ms

14

203,654

Details

1d10h37m21s

516ms

4s463ms

612ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	00	6,140	59m50s	584ms
	01	6,470	1h2m2s	575ms
	02	5,699	54m13s	570ms
	03	2,499	22m57s	551ms
	04	78	42s865ms	549ms
	05	2,033	19m42s	581ms
	06	3,562	34m21s	578ms
	07	2,660	24m32s	553ms
	08	3,467	32m12s	557ms
	09	9,590	1h34m20s	590ms
	10	17,117	3h2m41s	640ms
	11	14,197	2h25m33s	615ms
	12	12,812	2h10m13s	609ms
	13	13,214	2h13m44s	607ms
	14	13,338	2h12m1s	593ms
	15	7,611	1h14m49s	589ms
	16	18,045	3h23m22s	676ms
	17	16,136	2h50m21s	633ms
	18	11,360	1h56m37s	615ms
	19	12,402	2h9m2s	624ms
	20	11,575	1h56m41s	604ms
	21	9,070	1h31m18s	603ms
	22	4,579	45m58s	602ms

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

Date: 2025-02-01 16:02:30 Duration: 4s463ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4959986)) AND (("shipping_track"."id" not in (41156983, 41156983)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:44 Duration: 4s343ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4959933)) AND (("shipping_track"."id" not in (41156263, 41156885, 41156885)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:25 Duration: 3s632ms

15

152,758

Details

11s383ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,633	102ms	0ms
	01	1,282	91ms	0ms
	02	1,438	93ms	0ms
	03	703	43ms	0ms
	04	7	0ms	0ms
	05	453	29ms	0ms
	06	1,571	93ms	0ms
	07	598	33ms	0ms
	08	3,894	237ms	0ms
	09	9,941	710ms	0ms
	10	16,359	1s325ms	0ms
	11	15,952	1s177ms	0ms
	12	15,319	980ms	0ms
	13	14,777	1s56ms	0ms
	14	10,756	754ms	0ms
	15	11,973	876ms	0ms
	16	10,279	933ms	0ms
	17	10,560	788ms	0ms
	18	7,972	575ms	0ms
	19	6,538	579ms	0ms
	20	5,810	556ms	0ms
	21	3,115	228ms	0ms
	22	1,828	112ms	0ms

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

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

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

Date: 2025-02-01 17:21:54 Duration: 0ms

16

149,054

Details

8s501ms

0ms

2ms

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
Feb 01	00	752	36ms	0ms
	01	924	46ms	0ms
	02	437	22ms	0ms
	03	254	12ms	0ms
	04	11	0ms	0ms
	05	143	6ms	0ms
	06	448	23ms	0ms
	07	420	21ms	0ms
	08	3,591	185ms	0ms
	09	6,238	346ms	0ms
	10	15,136	924ms	0ms
	11	12,460	727ms	0ms
	12	11,152	655ms	0ms
	13	14,855	866ms	0ms
	14	11,483	630ms	0ms
	15	17,670	944ms	0ms
	16	15,050	960ms	0ms
	17	11,785	689ms	0ms
	18	9,949	542ms	0ms
	19	6,046	325ms	0ms
	20	5,945	323ms	0ms
	21	2,736	127ms	0ms
	22	1,569	80ms	0ms

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

Date: 2025-02-01 15:50:03 Duration: 2ms
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 (96);

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

Date: 2025-02-01 16:42:55 Duration: 0ms

17

144,091

Details

17s434ms

0ms

3ms

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
Feb 01	00	739	76ms	0ms
	01	892	97ms	0ms
	02	429	45ms	0ms
	03	251	25ms	0ms
	04	11	1ms	0ms
	05	134	13ms	0ms
	06	439	47ms	0ms
	07	414	45ms	0ms
	08	3,485	383ms	0ms
	09	6,103	728ms	0ms
	10	14,722	1s917ms	0ms
	11	12,103	1s487ms	0ms
	12	10,712	1s337ms	0ms
	13	14,368	1s777ms	0ms
	14	11,178	1s291ms	0ms
	15	17,121	1s930ms	0ms
	16	14,603	1s999ms	0ms
	17	11,434	1s423ms	0ms
	18	9,341	1s71ms	0ms
	19	5,825	664ms	0ms
	20	5,756	661ms	0ms
	21	2,566	248ms	0ms
	22	1,465	159ms	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-02-01 18:42:19 Duration: 3ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (96) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

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

Date: 2025-02-01 16:36:34 Duration: 0ms

18

123,609

Details

1m6s

0ms

18ms

0ms

select "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."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
Feb 01	00	337	172ms	0ms
	01	261	132ms	0ms
	02	235	120ms	0ms
	03	104	52ms	0ms
	04	4	3ms	0ms
	05	26	17ms	0ms
	06	552	206ms	0ms
	07	480	164ms	0ms
	08	2,472	1s240ms	0ms
	09	5,187	2s741ms	0ms
	10	6,728	4s69ms	0ms
	11	8,122	4s779ms	0ms
	12	10,411	5s790ms	0ms
	13	11,009	5s788ms	0ms
	14	14,365	7s29ms	0ms
	15	11,701	6s4ms	0ms
	16	24,802	14s37ms	0ms
	17	15,355	7s597ms	0ms
	18	3,349	1s887ms	0ms
	19	3,283	1s730ms	0ms
	20	2,456	1s425ms	0ms
	21	1,172	744ms	0ms
	22	1,198	672ms	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 (4111056, 4862587, 4870584, 4894308, 4897660, 4899248, 4945510, 4888261, 4931561, 4913512, 4779579, 4872322, 4920752, 4890778, 4938621, 4937901, 4908645, 4936217, 4908611, 4862034, 4918819, 4845927, 4908648, 4926419, 4928114, 4826504, 4114916, 4172357, 4386896, 4403820, 4435461, 4544481, 4724103, 4777811, 4814419, 4814444, 4822668, 4836717, 4860049, 4860912, 4860916, 4865456, 4924125, 4959415, 4958980, 4904895, 4911827, 4890975, 4857067, 4886438, 4861452, 4904760, 4906188, 4891450, 4891822, 4886990, 4903962, 4907424, 4907418, 4886357, 4905044, 4882534, 4923485, 4905055, 4895158, 4889940, 4868683, 4896012, 4910739, 4467687, 4810976, 4896009, 4889826, 4891237, 4890790, 4888730, 4584067, 4901444, 4921065, 4871389, 4917170, 4941408, 4855423, 4916729, 4920844, 4869787, 4872333, 4857933, 4879476, 4884573, 4868093, 4758297, 4889676, 4873471, 4870145, 4862186, 4852651, 4905080, 4899483, 4894869, 4884035, 4886369, 4885548, 4881674, 4853887, 4828158, 4725947, 4883978, 4884328, 4910413, 4856542, 4884699, 4889674, 4889750, 4881169, 4897216, 4893106, 4739043, 4891418, 4808283, 4740238, 4881311, 4881395, 4872835, 4883583, 4829587, 4888216, 4851837, 4910411, 4905071, 4889914, 4869312, 4872522, 4881381, 4731851, 4845392, 4604676, 4812336, 4684237, 4466404, 4904857, 4926019, 4853770, 4660532, 4860063, 4887846, 4928028, 4916371, 4887139, 4733974, 4885932, 4899390, 4899668, 4901302, 4906924, 4913917, 4916154, 4916253, 4916732, 4918180, 4918237, 4918567, 4918648, 4919360, 4920410, 4920541, 4920551, 4921530, 4921977, 4922444, 4922559, 4924427, 4924910, 4926047, 4926501, 4926569, 4927612, 4930484, 4935818, 4935973, 4936393, 4938404, 4938410, 4938422, 4938426, 4938509, 4941193, 4941195);

Date: 2025-02-01 17:21:55 Duration: 18ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."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 (4894910, 4818963, 4893243, 4907002, 4884914, 4941405, 4941446, 4886500, 4914624, 4924467, 4873802, 4891023, 4890232, 4919512, 4898889, 4894931, 4951088, 4882740, 4542933, 4850760, 4919711, 4958563, 4924450, 4944849, 4951450, 4870081, 4926744, 4955577, 4592800, 4806291, 4757722, 4621635, 4876268, 4576765, 4885771, 4829385, 4888106, 4786499, 4808500, 4779475, 4909148, 4858959, 4587143, 4890673, 4303563, 4932931, 4372969, 4916851, 4837966, 4836026, 4767498, 4900417, 4817623, 4811363, 4895016, 4866018, 4584864, 4881736, 4899568, 4883010, 4798090, 4864205, 4894877, 4885559, 4871869, 4882206, 4798508, 4889254, 4944846, 4930651, 4905136, 4886144, 4911634, 4891690, 4670464, 4914008, 4769247, 4896227, 4807351, 4882591, 4586402, 4757719, 4831654, 4891458, 4937697, 4937559, 4930953, 4807098, 4913955, 4885246, 4944836, 4907786, 4913975, 4925905, 4888734, 4789409, 4843643, 4784054, 4951097, 4920547, 4955424, 4930517, 4615249, 4939682, 4951044, 4898458, 4898437, 4881489, 4901310, 4904884, 4881575, 4881303, 4871703, 4896868, 4950017, 4918847, 4910760, 4939717, 4920090, 4935942, 4913090, 4940350, 4918547, 4958448, 4927441, 4886044, 4946715, 4890855, 4922645, 4918545, 4916203, 4936317, 4910767, 4956579, 4954781, 4868684, 4867920, 4864817, 4861229, 4726823, 4866163, 4749087, 4798961, 4798980, 4816335, 4818958, 4819151, 4824131, 4854134, 4854602, 4854609, 4862027, 4871959, 4873045, 4884636, 4888669, 4893346, 4894849, 4889558, 4918742, 4843070, 4942262, 4925009, 4620503, 4895848, 4925498, 4899111, 4905981, 4926332, 4926095, 4613715, 4855054, 4885961, 4886363, 4937059, 4891706, 4935806, 4857041, 4829515, 4904058, 4829517, 4860911, 4924439, 4847041, 4563163, 4909157, 4924430, 4745009, 4517528, 4927448, 4906047, 4914036, 4902600);

Date: 2025-02-01 16:50:00 Duration: 15ms
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 (3283668, 3283646, 3282664, 3279510, 3278893, 3278295, 3278099, 3277654, 3276733, 3276613, 3276173, 3275888, 3275537, 3274202, 3273106, 3270136, 3267758, 3265206, 3263131, 3261890, 3261520, 3254877, 3254873, 3254339, 3254174, 3248410, 3244005, 3243205, 3242319, 3234053, 3231967, 3228459, 3224724, 3223398, 3219185, 3201600, 3186447, 3182446, 3286285, 3283933, 3283925, 3283866, 3283839, 3283813, 3283782, 3283760, 3283755, 3280256, 3279517, 3279495, 3278183, 3277519, 3277509, 3276019, 3275390, 3274602, 3269985, 3269890, 3269124, 3268677, 3266709, 3264141, 3263770, 3262885, 3262689, 3262672, 3261111, 3260989, 3260977, 3260017, 3257600, 3257575, 3255216, 3253846, 3253641, 3253638, 3252518, 3251919, 3248322, 3248259, 3241285, 3230071, 3227155, 3224878, 3223973, 3221552, 3218181, 3214219, 3211450, 3211447, 3195715, 3161048, 2952833, 2628716, 2433176, 2348794, 3278419, 3287799, 3287794, 3286472, 3286286, 3283993, 3283991, 3283961, 3283899, 3283828, 3283767, 3283754, 3283670, 3283660, 3283640, 3280383, 3279689, 3278319, 3278204, 3277691, 3277563, 3277081, 3275866, 3274056, 3273962, 3269897, 3269895, 3269392, 3266524, 3266226, 3266027, 3263796, 3262661, 3262290, 3261864, 3260984, 3257821, 3256053, 3256029, 3254175, 3253629, 3252571, 3252078, 3243932, 3241293, 3240656, 3240644, 3222215, 3218689, 3154561, 3141527, 3076350, 2752325, 2713479, 2411470, 1890094, 3279707, 3274643, 3266129, 3262030, 3261575, 3257925, 3256749, 3252247, 3245480, 3245431, 3239483, 3239422, 3209319, 3193729, 2997526, 2871219, 3318375, 3318370, 3318369, 3316335, 3314540, 3314416, 3312528, 3311256, 3310837, 3310728, 3307763, 3303129, 3300919, 3300857, 3300624, 3300346, 3300022, 3296721, 3295492, 3294338, 3293275, 3292851, 3292241, 3291721, 3291661, 3291639, 3290745, 3289466, 3289056, 3289034, 3288667, 3288610, 3287455, 3283189, 3282417, 3282413, 3279944, 3275062, 3273790, 3261698, 3248358, 3248316, 3219168, 3132492, 2997473, 3318542, 3318510, 3318490, 3318445, 3318374, 3315290, 3314530, 3313910, 3310804, 3310731, 3310536, 3310169, 3306860, 3304047, 3303927, 3302807, 3300881, 3299598, 3299388, 3297798, 3297260, 3296349, 3295523, 3293463, 3288687, 3288562, 3287987, 3287480, 3286484, 3283788, 3283652, 3283639, 3281622, 3279609, 3279587, 3274053, 3251471, 3188909, 3065451, 3319819, 3318574, 3318521, 3318437, 3318384, 3318371, 3318349, 3314339, 3312670, 3311933, 3310817, 3310625, 3310426, 3309312, 3306833, 3306416, 3304420, 3303267, 3298612, 3297899, 3297347, 3297138, 3295373, 3295368, 3293188, 3292890, 3292529, 3291330, 3290682, 3289014, 3287619, 3286086, 3283817, 3281537, 3258679, 3257824, 3256795, 3255567, 3252834, 3239484, 3225440, 3202954, 3335099, 3333360, 3329085, 3329049, 3326585, 3325458, 3325126, 3325035, 3323258, 3321572, 3321466, 3320606, 3320458, 3310543, 3307109, 3307072, 3302180, 3294985, 3294565, 3292563, 3270530, 3254919, 3115292, 3329108, 3329103, 3327977, 3326792, 3324466, 3322406, 3322217, 3322145, 3321676, 3321597, 3321516, 3321512, 3320613, 3318404, 3318363, 3316448, 3313968, 3313949, 3312681, 3311989, 3309330, 3309304, 3307314, 3304053, 3303960, 3302615, 3302484, 3297961, 3296295, 3296146, 3295268, 3293236, 3293206, 3292613, 3286917, 3261555, 3196078, 3068321, 3068313, 2985909, 2399613, 2927872, 3334567, 3333341, 3333286, 3333273, 3333184, 3333153, 3333151, 3329240, 3329105, 3328648, 3328120, 3327784, 3327187, 3325810, 3325793, 3325731, 3324023, 3322992, 3321964, 3320773, 3318760, 3318564, 3318498, 3318427, 3296592, 3293799, 3292825, 3292651, 3291660, 3286476, 3274451, 3272673, 3266532, 3218530, 3333367, 3371561, 3371524, 3367629, 3365107, 3363656, 3363579, 3362115, 3361978, 3360716, 3356941, 3356114, 3355178, 3354209, 3354070, 3352959, 3352253, 3351822, 3351661, 3351530, 3351205, 3350663, 3347684, 3347516, 3346192, 3344575, 3344551, 3344528, 3344219, 3342369, 3340645, 3338552, 3336436, 3333096, 3331397, 3331072, 3330818, 3328824, 3328218, 3327979, 3326401, 3321226, 3318423, 3295182, 3276587, 3225622, 3204376, 3371767, 3371735, 3371605, 3371562, 3371448, 3361852, 3360907, 3357909, 3356901, 3355748, 3353974, 3353890, 3351929, 3351250, 3349036, 3348615, 3347366, 3342553, 3342227, 3337957, 3333108, 3330906, 3327828, 3325092, 3322652, 3314428, 3303274, 3294382, 3293721, 3292622, 3283731, 3281634, 3262834, 3262803, 3253529, 3219175, 3113531, 3051318, 3031422, 2564406, 3372618, 3371783, 3371737, 3371708, 3365109, 3363678, 3362282, 3361700, 3358732, 3355857, 3354840, 3353875, 3353816, 3352858, 3352000, 3351836, 3351615, 3351582, 3351580, 3350743, 3348306, 3347357, 3347335, 3346514, 3345343, 3341369, 3338098, 3337761, 3337062, 3331376, 3329106, 3327945, 3326767, 3321177, 3316512, 3314282, 3312828, 3297294, 3290251, 3282450, 3239109, 3221637, 3197434, 3407723, 3347500, 3403375, 3403240, 3403238, 3403222, 3399883, 3399874, 3397567, 3396244, 3395338, 3393472, 3389859, 3389595, 3389421, 3387936, 3387915, 3387181, 3385415, 3385260, 3384983, 3384612, 3384411, 3380461, 3380165, 3379490, 3378497, 3378311, 3378307, 3376067, 3372478, 3370255, 3364875, 3364362, 3363902, 3363191, 3355855, 3350530, 3350416, 3347232, 3343779, 3342770, 3339955, 3336017, 3325804, 3310507, 3294188, 3404643, 3403374, 3403373, 3403227, 3401073, 3399867, 3399541, 3399019, 3398989, 3398162, 3393766, 3392447, 3392408, 3391256, 3389323, 3388337, 3388177, 3387146, 3384751, 3384116, 3382709, 3382167, 3381371, 3380152, 3378308, 3377860, 3376970, 3376070, 3374384, 3372188, 3371435, 3367100, 3352206, 3347752, 3345131, 3344073, 3343801, 3343638, 3337258, 3335633, 3333129, 3305691, 3163581, 2987508, 2964175, 3442533, 3438096, 3431840, 3428084, 3426933, 3426259, 3420854, 3418985, 3418037, 3415969, 3412104, 3412012, 3410236, 3408793, 3408792, 3387274, 3380843, 3352487, 3405058, 3404649, 3401059, 3401054, 3398269, 3397545, 3397219, 3392794, 3390711, 3388934, 3388788, 3388641, 3387340, 3387183, 3384880, 3384453, 3383111, 3382395, 3382382, 3381806, 3380952, 3380283, 3378573, 3377182, 3376846, 3376723, 3376401, 3375510, 3374440, 3371834, 3371795, 3371778, 3371618, 3359774, 3358022, 3355132, 3353710, 3352888, 3350183, 3346839, 3346807, 3346326, 3345791, 3345734, 3344713, 3343674, 3339823, 3338067, 3329591, 3327672, 3292233, 3261559, 3140283, 3022224, 2985069, 2482930, 3436797, 3425992, 3425891, 3379703, 3346946, 3442516, 3437944, 3436539, 3436497, 3432612, 3427230, 3427218, 3427055, 3425620, 3425030, 3423755, 3423178, 3422770, 3421182, 3421144, 3417225, 3416938, 3416468, 3416180, 3415889, 3415238, 3412794, 3412571, 3411303, 3410853, 3409854, 3408897, 3408392, 3408045, 3407746, 3407734, 3406181, 3405055, 3397572, 3395088, 3392883, 3388639, 3386790, 3386717, 3382157, 3380057, 3378767, 3378628, 3377928, 3376089, 3352250, 3347460, 3341596, 3339850, 3338692, 3320502, 3319826, 3224018, 3414064, 3404520, 3439735, 3439712, 3439692, 3439308, 3439241, 3439239, 3438090, 3437977, 3437239, 3436588, 3435652, 3431472, 3430478, 3427419, 3427141, 3426254, 3426165, 3426053, 3422071, 3418030, 3417615, 3416151, 3416087, 3415638, 3415534, 3415400, 3415080, 3411935, 3411581, 3411181, 3410286, 3408289, 3407747, 3407731, 3407605, 3404523, 3399018, 3397845, 3389603, 3387269, 3371382, 3352667, 3342442, 2889461, 3287802, 3442190, 3439866, 3439865, 3436487, 3436320, 3436297, 3434109, 3432618, 3431826, 3431811, 3428548, 3423165, 3421052, 3420954, 3418652, 3418594, 3418573, 3416578, 3414815, 3414096, 3411737, 3411563, 3407603, 3397208, 3394970, 3393524, 3390534, 3389826, 3389532, 3387530, 3384609, 3380901, 3377632, 3376478, 3372186, 3371513, 3371486, 3351058, 3346847, 3345246, 3340004, 3336609, 3333328, 3331785, 3327435, 3277645, 3160665, 3072027, 3053704, 2445984, 3468322, 3468096, 3467372, 3466634, 3465141, 3463809, 3461588, 3461586, 3459401, 3459104, 3457731, 3457672, 3451297, 3447986, 3446598, 3444932, 3427374, 3472989, 3470865, 3470624, 3470566, 3467757, 3466836, 3466167, 3465989, 3465971, 3464394, 3464029, 3463074, 3456977, 3455333, 3454670, 3451706, 3448978, 3447825, 3444445, 3444113, 3442878, 3442687, 3442683, 3442673, 3442213, 3439837, 3439252, 3434747, 3428835, 3426104, 3422798, 3420922, 3420917, 3411614, 3410886, 3379563, 3354033, 3344378, 3477656, 3477604, 3475793, 3475770, 3472113, 3471741, 3471713, 3471677, 3470925, 3468435, 3467177, 3463618, 3462847, 3462486, 3461984, 3461067, 3461031, 3460853, 3459359, 3458555, 3458505, 3457857, 3453401, 3452623, 3447876, 3442678, 3439309, 3428488, 3427628, 3411321, 3409612, 3384806, 3326402, 3303047, 3299229, 3287335, 3479632, 3479072, 3475795, 3475762, 3474789, 3471817, 3468643, 3467184, 3464829, 3464577, 3462457, 3459277, 3458329, 3457095, 3455252, 3455075, 3454014, 3453557, 3451245, 3447051, 3447029, 3444827, 3444684, 3444284, 3442980, 3442676, 3439861, 3438987, 3438830, 3437304, 3437181, 3433462, 3433461, 3433376, 3427509, 3426437, 3425921, 3413949, 3413859, 3407018, 3403385, 3403242, 3389876, 3386326, 3362971, 3353888, 3295089, 3031813, 2982582, 2922374, 3455748, 3551344, 3515997, 3515986, 3515860, 3507426, 3506454, 3505530, 3505272, 3504964, 3504812, 3502118, 3494671, 3492779, 3492355);

Date: 2025-02-01 16:07:22 Duration: 13ms

19

123,468

Details

24s191ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 01	00	657	112ms	0ms
	01	832	146ms	0ms
	02	488	87ms	0ms
	03	281	47ms	0ms
	04	11	2ms	0ms
	05	116	19ms	0ms
	06	423	77ms	0ms
	07	337	61ms	0ms
	08	2,924	532ms	0ms
	09	5,624	1s85ms	0ms
	10	12,932	2s608ms	0ms
	11	10,882	2s136ms	0ms
	12	9,592	1s887ms	0ms
	13	12,503	2s488ms	0ms
	14	9,705	1s845ms	0ms
	15	14,041	2s620ms	0ms
	16	11,868	2s553ms	0ms
	17	9,317	1s891ms	0ms
	18	7,768	1s479ms	0ms
	19	4,935	956ms	0ms
	20	4,837	933ms	0ms
	21	2,236	394ms	0ms
	22	1,159	219ms	0ms

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

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

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

Date: 2025-02-01 16:25:40 Duration: 2ms

20

120,671

Details

1h51m7s

42ms

331ms

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

Day	Hour	Count	Duration	Avg duration
Feb 01	00	3,036	2m37s	51ms
	01	2,301	1m58s	51ms
	02	1,669	1m27s	52ms
	03	672	35s730ms	53ms
	04	27	1s445ms	53ms
	05	493	25s894ms	52ms
	06	1,307	1m8s	52ms
	07	628	32s489ms	51ms
	08	2,441	2m6s	51ms
	09	6,934	6m14s	54ms
	10	13,447	12m56s	57ms
	11	11,500	10m50s	56ms
	12	10,338	9m36s	55ms
	13	10,102	9m21s	55ms
	14	6,744	6m5s	54ms
	15	5,188	4m40s	54ms
	16	6,953	7m1s	60ms
	17	6,807	6m25s	56ms
	18	6,937	6m15s	54ms
	19	7,059	6m23s	54ms
	20	7,746	6m59s	54ms
	21	5,505	4m52s	53ms
	22	2,837	2m29s	52ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4948721, 4891125)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 16:02:50 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4905468)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 16:02:02 Duration: 236ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4913882, 4896196, 4895532, 4889347, 4829092)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 17:22:00 Duration: 229ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m59s

4m24s

55

Details

4h2m18s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1	59m56s	59m56s
	01	5	1ms	0ms
	02	1	0ms	0ms
	06	2	1h6m7s	33m3s
	08	4	3ms	0ms
	09	4	0ms	0ms
	10	4	2ms	0ms
	11	8	8ms	1ms
	13	3	4ms	1ms
	14	1	0ms	0ms
	15	5	5ms	1ms
	16	4	7ms	1ms
	17	4	56m14s	14m3s
	18	1	1ms	1ms
	19	2	3ms	1ms
	21	3	59m59s	19m59s
	22	3	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-02-01 20:38:43.718933', "last_update" = '2025-02-01 19:53:43.718953', "write_date" = '2025-02-01 19:53:43.395434', "write_uid" = 1 WHERE id IN (1208);

Date: 2025-02-01 21:53:43 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-02-01 05:05:33.205398', "last_update" = '2025-02-01 04:20:33.205418', "write_date" = '2025-02-01 04:20:32.886923', "write_uid" = 1053 WHERE id IN (1053);

Date: 2025-02-01 06:20:32 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-01-31 23:06:56.639579', "last_update" = '2025-01-31 22:21:56.639595', "write_date" = '2025-01-31 22:21:56.318494', "write_uid" = 1053 WHERE id IN (1053);

Date: 2025-02-01 00:21:53 Duration: 59m56s

2

0ms

45m6s

43s634ms

278

Details

3h22m10s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 01	00	4	45m6s	11m16s
	01	2	0ms	0ms
	02	2	0ms	0ms
	06	2	0ms	0ms
	07	1	0ms	0ms
	08	14	4ms	0ms
	09	25	5ms	0ms
	10	25	2m10s	5s219ms
	11	19	3m49s	12s64ms
	12	19	17ms	0ms
	13	31	37ms	1ms
	14	19	16ms	0ms
	15	29	36ms	1ms
	16	12	20ms	1ms
	17	22	27m27s	1m14s
	18	16	1h6m11s	4m8s
	19	15	19m44s	1m18s
	20	9	11ms	1ms
	21	8	37m40s	4m42s
	22	4	2ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-31 23:21:47.000700', "last_update" = '2025-01-31 22:36:47.000722', "sid" = 'ed33e9c0f14252382cb7e352719e9bb206298906', "write_date" = '2025-01-31 22:36:46.676214', "write_uid" = 1 WHERE id IN (1053);

Date: 2025-02-01 00:21:53 Duration: 45m6s
UPDATE "res_users" SET "exp_date" = '2025-02-01 21:01:03.242809', "last_update" = '2025-02-01 20:16:03.242829', "sid" = 'e475191520da2dbb9dd3769bfea8a145320ba4c7', "write_date" = '2025-02-01 20:16:02.912476', "write_uid" = 1223 WHERE id IN (1223);

Date: 2025-02-01 21:53:43 Duration: 37m40s
UPDATE "res_users" SET "exp_date" = '2025-02-01 17:55:58.824789', "last_update" = '2025-02-01 17:10:58.824816', "sid" = 'c090b3fdea68ba830fddc4bac833e06d2d157f91', "write_date" = '2025-02-01 17:10:58.496634', "write_uid" = 1364 WHERE id IN (1364);

Date: 2025-02-01 18:28:21 Duration: 17m22s

3

0ms

59m59s

5s211ms

57,013

Details

3d10h32m6s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 01	00	677	147ms	0ms
	01	709	153ms	0ms
	02	570	121ms	0ms
	03	295	61ms	0ms
	04	12	2ms	0ms
	05	279	61ms	0ms
	06	356	53m49s	9s70ms
	07	278	60ms	0ms
	08	1,384	290ms	0ms
	09	3,238	53m33s	992ms
	10	5,592	8h43m28s	5s616ms
	11	5,974	9h41s	5s430ms
	12	5,848	2h16m2s	1s395ms
	13	5,457	1h52m45s	1s239ms
	14	4,464	4h14m	3s414ms
	15	4,911	14h26m13s	10s583ms
	16	4,222	7h47m7s	6s638ms
	17	3,631	9h46m20s	9s688ms
	18	2,775	4h32m29s	5s891ms
	19	2,295	10h48m23s	16s951ms
	20	2,024	5h17m10s	9s402ms
	21	1,394	1h59m58s	5s163ms
	22	628	140ms	0ms

update res_users set sid = '94af8fef6dd74907628214fadb5eaa06b16e46be', last_update = '2025-02-01 19:45:44.466222', exp_date = '2025-02-01 20:30:44.466228', logged_in = 'TRUE' where id = 1026;

Date: 2025-02-01 21:45:44 Duration: 59m59s
update res_users set sid = '5c395234c5d2d387989cda6d8f7050cf52e52fb0', last_update = '2025-02-01 19:53:45.755829', exp_date = '2025-02-01 20:38:45.755833', logged_in = 'TRUE' where id = 1208;

Date: 2025-02-01 21:53:43 Duration: 59m57s
update res_users set sid = 'd6798dd54248300fb4053e612c90ecac098dff3e', last_update = '2025-02-01 17:37:58.591052', exp_date = '2025-02-01 18:22:58.591055', logged_in = 'TRUE' where id = 1372;

Date: 2025-02-01 19:36:21 Duration: 58m22s

4

214ms

1s848ms

710ms

10,517

Details

2h4m29s

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
Feb 01	00	381	2m48s	441ms
	01	116	59s31ms	508ms
	02	156	37s248ms	238ms
	06	13	3s92ms	237ms
	09	24	21s895ms	912ms
	10	101	27s249ms	269ms
	11	12	13s492ms	1s124ms
	12	23	7s75ms	307ms
	13	95	1m6s	698ms
	14	99	39s96ms	394ms
	15	205	2m58s	872ms
	16	1,030	15m18s	891ms
	17	967	12m35s	780ms
	18	1,501	18m55s	756ms
	19	2,997	31m44s	635ms
	20	1,346	19m7s	852ms
	21	1,141	12m28s	655ms
	22	310	3m58s	768ms

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

Date: 2025-02-01 16:02:34 Duration: 1s848ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '112197')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-01 16:03:29 Duration: 1s742ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '112185')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-01 16:02:20 Duration: 1s543ms

5

522ms

4s675ms

619ms

39,088

Details

6h43m30s

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
Feb 01	00	177	1m50s	624ms
	01	191	2m4s	652ms
	02	168	1m50s	659ms
	03	95	1m	633ms
	04	2	1s378ms	689ms
	05	26	17s14ms	654ms
	06	224	2m11s	588ms
	07	449	4m15s	569ms
	08	1,554	14m41s	567ms
	09	2,406	24m	598ms
	10	3,168	35m6s	664ms
	11	3,926	41m46s	638ms
	12	3,923	40m59s	626ms
	13	3,814	39m20s	618ms
	14	2,793	28m6s	603ms
	15	3,101	30m56s	598ms
	16	2,654	30m31s	690ms
	17	2,696	28m26s	633ms
	18	2,334	22m58s	590ms
	19	1,807	17m50s	592ms
	20	2,369	23m20s	591ms
	21	808	7m58s	591ms
	22	403	3m54s	580ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4945349, 4926332, 4926095, 4915190, 4915018, 4905981, 4899111, 4895848, 4855708, 4853960, 4785934)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:28 Duration: 4s675ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4945354, 4933015, 4932931, 4926608, 4921442, 4920583, 4916851, 4915890, 4914045, 4912663, 4905958, 4900417, 4896181, 4895016, 4887822, 4884823, 4839325, 4836026)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:36 Duration: 4s65ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4638114)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:42 Duration: 3s859ms

6

516ms

4s463ms

612ms

203,654

Details

1d10h37m21s

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
Feb 01	00	6,140	59m50s	584ms
	01	6,470	1h2m2s	575ms
	02	5,699	54m13s	570ms
	03	2,499	22m57s	551ms
	04	78	42s865ms	549ms
	05	2,033	19m42s	581ms
	06	3,562	34m21s	578ms
	07	2,660	24m32s	553ms
	08	3,467	32m12s	557ms
	09	9,590	1h34m20s	590ms
	10	17,117	3h2m41s	640ms
	11	14,197	2h25m33s	615ms
	12	12,812	2h10m13s	609ms
	13	13,214	2h13m44s	607ms
	14	13,338	2h12m1s	593ms
	15	7,611	1h14m49s	589ms
	16	18,045	3h23m22s	676ms
	17	16,136	2h50m21s	633ms
	18	11,360	1h56m37s	615ms
	19	12,402	2h9m2s	624ms
	20	11,575	1h56m41s	604ms
	21	9,070	1h31m18s	603ms
	22	4,579	45m58s	602ms

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

Date: 2025-02-01 16:02:30 Duration: 4s463ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4959986)) AND (("shipping_track"."id" not in (41156983, 41156983)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:44 Duration: 4s343ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4959933)) AND (("shipping_track"."id" not in (41156263, 41156885, 41156885)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-01 16:02:25 Duration: 3s632ms

7

365ms

731ms

504ms

2,154

Details

18m7s

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
Feb 01	08	160	1m13s	457ms
	09	359	2m48s	470ms
	10	325	3m1s	557ms
	11	466	4m4s	523ms
	12	556	4m36s	498ms
	13	270	2m13s	492ms
	14	4	2s152ms	538ms
	15	14	7s516ms	536ms

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

Date: 2025-02-01 10:05:22 Duration: 731ms
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" = '70328')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-01 10:09:14 Duration: 726ms
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" = '70287')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-01 10:09:09 Duration: 709ms

8

177ms

592ms

282ms

9,432

Details

44m24s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 01	08	646	2m51s	264ms
	09	815	3m44s	275ms
	10	774	4m11s	324ms
	11	1,399	6m37s	284ms
	12	797	3m37s	272ms
	13	1,144	5m19s	278ms
	14	1,363	6m13s	274ms
	15	817	3m40s	269ms
	16	1,406	6m39s	283ms
	17	271	1m30s	334ms

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

Date: 2025-02-01 09:59:26 Duration: 592ms
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" = '9999048')))) ORDER BY "collection_policy"."id";

Date: 2025-02-01 10:03:54 Duration: 588ms
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" = '110940')))) ORDER BY "collection_policy"."id";

Date: 2025-02-01 10:04:41 Duration: 585ms

9

211ms

508ms

282ms

16,464

Details

1h17m31s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,339	5m46s	259ms
	01	1,171	5m9s	264ms
	02	458	2m1s	265ms
	05	587	2m32s	259ms
	06	866	3m46s	261ms
	08	6	1s547ms	257ms
	09	107	30s279ms	282ms
	10	135	38s659ms	286ms
	11	63	18s148ms	288ms
	12	118	33s547ms	284ms
	13	182	52s409ms	287ms
	14	96	26s735ms	278ms
	15	135	36s834ms	272ms
	16	1,069	5m46s	324ms
	17	1,120	5m32s	296ms
	18	2,244	11m9s	298ms
	19	2,005	9m45s	292ms
	20	1,356	6m30s	287ms
	21	1,998	9m10s	275ms
	22	1,409	6m20s	269ms

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

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

Date: 2025-02-01 16:03:29 Duration: 460ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9969428')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-01 16:24:21 Duration: 452ms

10

17ms

2s398ms

265ms

2,395

Details

10m36s

select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1	116ms	116ms
	04	1	408ms	408ms
	08	57	8s457ms	148ms
	09	87	18s909ms	217ms
	10	174	38s590ms	221ms
	11	285	1m11s	250ms
	12	312	1m17s	247ms
	13	312	1m23s	266ms
	14	268	1m6s	247ms
	15	272	1m11s	262ms
	16	234	1m6s	285ms
	17	122	48s813ms	400ms
	18	82	24s903ms	303ms
	19	63	21s930ms	348ms
	20	61	19s37ms	312ms
	21	50	15s192ms	303ms
	22	14	3s811ms	272ms

SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-01 17:14:29 Duration: 2s398ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-01 16:01:45 Duration: 1s929ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (40)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (40))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-02-01 17:14:28 Duration: 1s35ms

11

203ms

1s353ms

241ms

2,726

Details

10m58s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 01	00	120	27s368ms	228ms
	01	120	27s369ms	228ms
	02	120	27s282ms	227ms
	03	120	27s74ms	225ms
	04	120	27s196ms	226ms
	05	120	27s222ms	226ms
	06	120	27s230ms	226ms
	07	120	27s166ms	226ms
	08	120	27s331ms	227ms
	09	120	28s489ms	237ms
	10	120	30s957ms	257ms
	11	120	29s852ms	248ms
	12	120	30s44ms	250ms
	13	120	29s112ms	242ms
	14	120	29s240ms	243ms
	15	120	28s714ms	239ms
	16	120	33s358ms	277ms
	17	116	30s140ms	259ms
	18	120	30s214ms	251ms
	19	120	30s585ms	254ms
	20	120	30s221ms	251ms
	21	120	29s748ms	247ms
	22	90	22s83ms	245ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-01 16:02:04 Duration: 1s353ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-01 16:02:03 Duration: 1s252ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-01 12:10:02 Duration: 393ms

12

89ms

788ms

230ms

53,311

Details

3h25m8s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 01	00	3,418	10m51s	190ms
	01	2,539	9m52s	233ms
	02	1,211	4m23s	217ms
	05	1,148	4m27s	233ms
	06	1,746	6m52s	236ms
	08	10	2s151ms	215ms
	09	254	56s960ms	224ms
	10	450	1m44s	231ms
	11	146	36s484ms	249ms
	12	276	1m1s	222ms
	13	540	2m23s	265ms
	14	386	1m38s	254ms
	15	634	2m34s	243ms
	16	4,134	19m17s	279ms
	17	4,124	16m50s	245ms
	18	7,418	30m37s	247ms
	19	9,917	36m14s	219ms
	20	5,370	20m43s	231ms
	21	6,208	22m12s	214ms
	22	3,382	11m48s	209ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عمرو')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-01 16:02:36 Duration: 788ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'كريم')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-01 16:02:35 Duration: 777ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمود')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-01 16:42:40 Duration: 765ms

13

163ms

1s516ms

207ms

74,051

Details

4h15m51s

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

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,208	3m38s	180ms
	01	1,982	6m	181ms
	02	1,357	4m7s	182ms
	03	842	2m33s	182ms
	04	29	5s273ms	181ms
	05	1,069	3m14s	182ms
	06	396	1m12s	182ms
	07	1,089	3m17s	181ms
	08	1,793	5m29s	183ms
	09	6,505	20m56s	193ms
	10	5,721	19m39s	206ms
	11	4,477	15m9s	203ms
	12	8,283	29m32s	214ms
	13	2,671	8m57s	201ms
	14	3,246	10m36s	196ms
	15	7,652	24m45s	194ms
	16	21,620	1h22m19s	228ms
	17	2,702	9m47s	217ms
	18	127	24s813ms	195ms
	19	356	1m8s	192ms
	20	245	46s820ms	191ms
	21	333	1m2s	186ms
	22	348	1m5s	188ms

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

Date: 2025-02-01 16:02:27 Duration: 1s516ms
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" = '100976')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:28 Duration: 1s484ms
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" = '212452')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:27 Duration: 1s474ms

14

167ms

303ms

201ms

3,744

Details

12m33s

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

Day	Hour	Count	Duration	Avg duration
Feb 01	05	936	2m51s	182ms
	06	11	2s44ms	185ms
	09	1,045	3m39s	210ms
	10	1,752	6m1s	206ms

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

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

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

Date: 2025-02-01 10:25:15 Duration: 273ms

15

165ms

422ms

196ms

11,339

Details

37m5s

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

Day	Hour	Count	Duration	Avg duration
Feb 01	02	3	560ms	186ms
	05	133	24s261ms	182ms
	06	385	1m10s	182ms
	07	1,089	3m18s	182ms
	08	367	1m6s	182ms
	09	1,754	5m35s	191ms
	10	2,219	7m39s	207ms
	11	1,601	5m22s	201ms
	12	1,823	6m6s	201ms
	13	189	37s702ms	199ms
	14	262	50s551ms	192ms
	15	260	49s718ms	191ms
	16	88	20s865ms	237ms
	17	12	2s243ms	186ms
	18	76	14s902ms	196ms
	19	156	30s462ms	195ms
	20	241	46s70ms	191ms
	21	333	1m2s	187ms
	22	348	1m5s	188ms

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" = '181327')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:05 Duration: 422ms
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" = '104288')) 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 (9)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:01:37 Duration: 342ms
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" = '9724858')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-01 16:02:07 Duration: 340ms

16

166ms

213ms

182ms

4,972

Details

15m5s

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

Day	Hour	Count	Duration	Avg duration
Feb 01	00	1,112	3m20s	180ms
	01	1,789	5m26s	182ms
	02	1,200	3m39s	182ms
	03	842	2m33s	182ms
	04	29	5s283ms	182ms

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

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

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

Date: 2025-02-01 00:06:21 Duration: 206ms

17

120ms

305ms

144ms

6,149

Details

14m49s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 01	00	47	6s105ms	129ms
	06	11	1s428ms	129ms
	08	51	6s734ms	132ms
	09	422	58s207ms	137ms
	10	1,490	3m43s	150ms
	11	949	2m18s	145ms
	12	986	2m22s	145ms
	13	738	1m44s	141ms
	14	554	1m16s	137ms
	15	268	36s947ms	137ms
	16	253	41s75ms	162ms
	17	89	13s229ms	148ms
	18	110	15s487ms	140ms
	19	44	6s158ms	139ms
	20	63	8s878ms	140ms
	21	61	8s259ms	135ms
	22	13	1s726ms	132ms

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

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

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

Date: 2025-02-01 17:23:48 Duration: 281ms

18

96ms

754ms

122ms

18,987

Details

38m54s

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

Day	Hour	Count	Duration	Avg duration
Feb 01	07	84	10s155ms	120ms
	08	321	37s965ms	118ms
	09	826	1m38s	119ms
	10	1,702	3m35s	126ms
	11	2,281	4m42s	123ms
	12	2,048	4m11s	122ms
	13	2,010	4m4s	121ms
	14	2,188	4m15s	116ms
	15	1,923	3m49s	119ms
	16	2,134	4m57s	139ms
	17	1,192	2m29s	125ms
	18	642	1m14s	116ms
	19	589	1m8s	116ms
	20	524	1m1s	117ms
	21	488	54s288ms	111ms
	22	35	4s119ms	117ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8052317)) AND (("cash_track"."id" not in (7460887, 7463425, 7465109, 7583786, 7594489, 7594489)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-01 16:02:13 Duration: 754ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8052454)) AND (("cash_track"."id" not in (7461181, 7464701, 7465044, 7582828, 7594488, 7594488)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-01 16:02:13 Duration: 747ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8060567)) AND (("cash_track"."id" not in (7521283, 7524267, 7546192, 7581690, 7594434, 7594434)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-01 16:01:59 Duration: 636ms

19

45ms

105ms

57ms

18,353

Details

17m34s

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

Day	Hour	Count	Duration	Avg duration
Feb 01	06	19	993ms	52ms
	08	915	48s531ms	53ms
	09	1,323	1m10s	53ms
	10	1,166	1m8s	58ms
	11	1,999	1m54s	57ms
	12	1,653	1m34s	57ms
	13	1,942	1m49s	56ms
	14	2,637	2m26s	55ms
	15	1,601	1m28s	55ms
	16	3,243	3m22s	62ms
	17	1,302	1m16s	58ms
	18	245	14s438ms	58ms
	19	159	9s464ms	59ms
	20	134	7s971ms	59ms
	21	10	593ms	59ms
	22	5	280ms	56ms

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

Date: 2025-02-01 12:10:16 Duration: 105ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4866592) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-01 16:10:48 Duration: 102ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4635534) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-01 17:21:59 Duration: 101ms

20

42ms

331ms

55ms

120,671

Details

1h51m7s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 01	00	3,036	2m37s	51ms
	01	2,301	1m58s	51ms
	02	1,669	1m27s	52ms
	03	672	35s730ms	53ms
	04	27	1s445ms	53ms
	05	493	25s894ms	52ms
	06	1,307	1m8s	52ms
	07	628	32s489ms	51ms
	08	2,441	2m6s	51ms
	09	6,934	6m14s	54ms
	10	13,447	12m56s	57ms
	11	11,500	10m50s	56ms
	12	10,338	9m36s	55ms
	13	10,102	9m21s	55ms
	14	6,744	6m5s	54ms
	15	5,188	4m40s	54ms
	16	6,953	7m1s	60ms
	17	6,807	6m25s	56ms
	18	6,937	6m15s	54ms
	19	7,059	6m23s	54ms
	20	7,746	6m59s	54ms
	21	5,505	4m52s	53ms
	22	2,837	2m29s	52ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4948721, 4891125)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 16:02:50 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4905468)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 16:02:02 Duration: 236ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4913882, 4896196, 4895532, 4889347, 4829092)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-01 17:22:00 Duration: 229ms

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

16,195,768 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	4	0.00%
DETAIL	19	0.00%
ERROR	3,012	0.02%
EVENTLOG	1,179	0.01%
FATAL	866	0.01%
HINT	2	0.00%
LOG	16,187,659	99.95%
STATEMENT	3,027	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
866 FATAL entries
3012 ERROR entries
0 WARNING entries
1179 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,602 Max number of times the same event was reported
5,057 Total events found

Rank

Times reported

Error

1

1,602

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 01	00	29
	01	7
	02	3
	03	2
	06	7
	07	7
	08	53
	09	82
	10	121
	11	144
	12	132
	13	262
	14	91
	15	148
	16	209
	17	130
	18	41
	19	19
	20	41
	21	52
	22	22

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,390

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 01	00	23
	01	5
	02	2
	03	1
	06	3
	07	7
	08	52
	09	65
	10	106
	11	133
	12	116
	13	237
	14	65
	15	140
	16	174
	17	122
	18	36
	19	17
	20	37
	21	28
	22	21

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

735

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 01	00	1
	06	2
	09	1
	10	122
	11	48
	12	20
	13	55
	14	25
	15	117
	16	161
	17	95
	18	42
	19	29
	20	16
	21	1

4

735

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 01	00	1
	06	2
	09	1
	10	122
	11	48
	12	20
	13	55
	14	25
	15	117
	16	161
	17	95
	18	42
	19	29
	20	16
	21	1

LOG: could not send data to client: Broken pipe

5

300

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 01	00	1
	06	2
	09	1
	10	39
	11	18
	12	11
	13	12
	14	7
	15	44
	16	62
	17	47
	18	29
	19	8
	20	16
	21	3

6

142

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 01	10	19
	11	8
	12	5
	13	4
	14	5
	15	20
	16	39
	17	20
	18	9
	19	1
	20	12

7

76

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 01	17	76

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

8

14

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 01	17	14

9

12

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Feb 01	17	12

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

10

11

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Feb 01	10	2
	11	2
	12	3
	13	2
	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

11

7

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Feb 01	00	1
	12	1
	14	3
	19	1
	20	1

12

6

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Feb 01	06	3
	16	3

FATAL: password authentication failed for user "postgres"

13

5

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Feb 01	00	1
	12	1
	13	1
	19	1
	20	1

14

5

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Feb 01	17	5

15

5

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Feb 01	00	1
	12	1
	14	1
	19	1
	20	1

16

3

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Feb 01	02	2
	14	1

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

17

2

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Feb 01	17	2

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

18

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Feb 01	12	1
	20	1

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

19

2

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Feb 01	09	1
	11	1

ERROR: deadlock detected
ERROR: deadlock detected

20

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Feb 01	17	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Feb 01	14	1

22

1

Details

ERROR: incomplete startup packet

Times Reported Most Frequent Error / Event #22

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