pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Jul 8 23:45:51 2026
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 291,832 log entries in 49s
Log start from 2026-07-08 02:00:09 to 2026-07-09 01:44:51

Global Stats

224 Number of unique normalized queries
88,305 Number of queries
5d7h17m44s Total query duration
2026-07-08 02:00:27 First query
2026-07-09 01:38:28 Last query
495 queries/s at 2026-07-08 20:44:22 Query peak

5d7h17m44s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
5d7h17m44s Execute total duration

8,069 Number of events
15 Number of unique normalized events
2,578 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
88,305 Average queries per session
5d7h17m44s 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

495 queries/s Query Peak
2026-07-08 20:44:22 Date

SELECT Traffic

Key values

493 queries/s Query Peak
2026-07-08 20:44:22 Date

INSERT/UPDATE/DELETE Traffic

Key values

2 queries/s Query Peak
2026-07-08 20:44:22 Date

Queries duration

Key values

5d7h17m44s 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)
Jul 08	02	10,186	3s	10s181ms	4s99ms	15m25s	15m54s	17m56s
	03	9,548	0ms	8s822ms	4s158ms	14m24s	17m16s	18m
	04	9,789	3s	7s316ms	4s112ms	13m48s	14m11s	16m27s
	05	9,391	3s2ms	10s966ms	4s234ms	13m56s	14m32s	16m50s
	06	9,873	3s10ms	7s61ms	4s196ms	13m44s	15m34s	17m5s
	07	10,484	3s2ms	7s561ms	4s193ms	13m55s	16m33s	16m44s
	08	10,446	0ms	2m4s	4s322ms	17m27s	18m8s	34m14s
	09	17,415	0ms	17s887ms	6s891ms	1h12m38s	1h22m34s	1h25m32s
	10	75	0ms	12s856ms	6s681ms	55s774ms	1m3s	1m21s
	11	29	0ms	12s852ms	4s547ms	4s480ms	12s852ms	21s578ms
	12	57	0ms	11s870ms	5s480ms	16s181ms	22s899ms	1m21s
	13	54	0ms	12s862ms	5s247ms	11s151ms	16s446ms	38s373ms
	14	29	0ms	12s17ms	4s464ms	7s599ms	12s17ms	14s958ms
	15	27	0ms	10s836ms	4s584ms	7s210ms	19s473ms	26s527ms
	16	43	0ms	12s17ms	5s25ms	11s955ms	15s622ms	29s644ms
	17	74	0ms	13s963ms	4s970ms	19s323ms	24s712ms	1m11s
	18	67	0ms	11s113ms	4s222ms	17s213ms	30s701ms	38s652ms
	19	56	0ms	10s44ms	3s830ms	13s996ms	15s366ms	38s801ms
	20	541	0ms	2m29s	1m19s	18s841ms	25s189ms	11h54m59s
	21	30	0ms	11s550ms	4s265ms	7s486ms	18s7ms	24s362ms
	22	20	0ms	8s582ms	3s884ms	3s892ms	11s95ms	17s374ms
	23	29	0ms	9s936ms	4s582ms	3s708ms	18s551ms	47s488ms
Jul 09	00	34	0ms	8s544ms	4s33ms	11s300ms	18s624ms	35s518ms
	01	8	0ms	9s827ms	6s411ms	0ms	0ms	47s525ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 08	02	10,185	0	4s98ms	14m22s	15m25s	16m35s
	03	9,548	0	4s158ms	14m1s	14m24s	17m44s
	04	9,789	0	4s112ms	13m30s	13m48s	16m7s
	05	9,391	0	4s234ms	13m39s	13m56s	15m19s
	06	9,873	0	4s196ms	13m36s	13m44s	16m49s
	07	10,484	0	4s193ms	13m36s	13m55s	16m38s
	08	10,430	15	4s321ms	15m41s	17m27s	27m5s
	09	17,410	0	6s891ms	1h4m49s	1h12m38s	1h25m16s
	10	74	0	6s719ms	6s870ms	55s774ms	1m10s
	11	29	0	4s547ms	3s570ms	4s480ms	19s14ms
	12	57	0	5s480ms	7s251ms	16s181ms	47s588ms
	13	53	0	5s277ms	10s424ms	11s151ms	19s682ms
	14	29	0	4s464ms	3s877ms	7s599ms	14s639ms
	15	27	0	4s584ms	3s489ms	7s210ms	20s275ms
	16	43	0	5s25ms	6s808ms	11s955ms	23s600ms
	17	74	0	4s970ms	11s984ms	19s323ms	1m5s
	18	67	0	4s222ms	7s213ms	17s213ms	37s206ms
	19	56	0	3s830ms	6s996ms	13s996ms	20s708ms
	20	539	0	1m19s	4s180ms	18s841ms	36s876ms
	21	30	0	4s265ms	3s525ms	7s486ms	20s177ms
	22	19	0	3s879ms	0ms	3s571ms	13s743ms
	23	28	0	4s613ms	0ms	3s355ms	35s45ms
Jul 09	00	34	0	4s33ms	0ms	11s300ms	21s69ms
	01	8	0	6s411ms	0ms	0ms	47s525ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 08	02	0	1	0	10s181ms	0ms	0ms	0ms
	03	0	0	0	0ms	0ms	0ms	0ms
	04	0	0	0	0ms	0ms	0ms	0ms
	05	0	0	0	0ms	0ms	0ms	0ms
	06	0	0	0	0ms	0ms	0ms	0ms
	07	0	0	0	0ms	0ms	0ms	0ms
	08	0	1	0	15s896ms	0ms	0ms	0ms
	09	0	1	0	3s277ms	0ms	0ms	0ms
	10	0	0	1	3s895ms	0ms	0ms	0ms
	11	0	0	0	0ms	0ms	0ms	0ms
	12	0	0	0	0ms	0ms	0ms	0ms
	13	0	0	1	3s624ms	0ms	0ms	0ms
	14	0	0	0	0ms	0ms	0ms	0ms
	15	0	0	0	0ms	0ms	0ms	0ms
	16	0	0	0	0ms	0ms	0ms	0ms
	17	0	0	0	0ms	0ms	0ms	0ms
	18	0	0	0	0ms	0ms	0ms	0ms
	19	0	0	0	0ms	0ms	0ms	0ms
	20	1	0	0	1m51s	0ms	0ms	0ms
	21	0	0	0	0ms	0ms	0ms	0ms
	22	0	1	0	3s986ms	0ms	0ms	0ms
	23	0	1	0	3s708ms	0ms	0ms	0ms
Jul 09	00	0	0	0	0ms	0ms	0ms	0ms
	01	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Percentage of prepare
Jul 08	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%
	23	0.00%
Jul 09	00	0.00%
	01	0.00%

Day	Hour	Average / Second
Jul 08	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
	23	0.00/s
Jul 09	00	0.00/s
	01	0.00/s

Day	Hour	Average Duration	Average idle time
Jul 08	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
	23	0ms	0ms
Jul 09	00	0ms	0ms
	01	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

128,114 buffers Checkpoint Peak
2026-07-08 08:46:23 Date
270.052 seconds Highest write time
0.034 seconds Sync time

Checkpoints Wal files

Key values

52 files Wal files usage Peak
2026-07-08 08:46:23 Date

Checkpoints distance

Key values

1,673.86 Mo Distance Peak
2026-07-08 08:46:23 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 08	02	116,884	2,969.584s	0.043s	2,969.685s
	03	43,444	2,260.088s	0.041s	2,260.197s
	04	46,665	2,091.325s	0.03s	2,091.394s
	05	49,150	2,994.244s	0.056s	2,994.357s
	06	49,762	2,705.21s	0.042s	2,705.311s
	07	40,281	2,998.565s	0.049s	2,998.677s
	08	178,562	1,966.182s	0.081s	1,966.343s
	09	122,009	2,474.27s	0.077s	2,474.42s
	10	200,628	3,239.551s	0.043s	3,239.659s
	11	227,134	3,158.836s	0.071s	3,158.965s
	12	194,298	3,239.51s	0.057s	3,239.635s
	13	225,456	3,239.558s	0.055s	3,239.677s
	14	176,907	2,969.004s	0.059s	2,969.124s
	15	161,670	3,239.554s	0.048s	3,239.659s
	16	199,062	3,239.526s	0.048s	3,239.642s
	17	227,662	2,969.134s	0.052s	2,969.239s
	18	221,632	3,239.59s	0.039s	3,239.687s
	19	205,689	3,239.51s	0.039s	3,239.602s
	20	217,051	2,430.434s	0.057s	2,430.536s
	21	182,128	3,239.494s	0.047s	3,239.593s
	22	160,373	3,239.611s	0.045s	3,239.707s
	23	131,919	3,159.493s	0.065s	3,159.609s
Jul 09	00	140,592	3,239.531s	0.036s	3,239.618s
	01	101,771	1,889.794s	0.033s	1,889.864s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jul 08	02	49	2,563	0.004s	0.011s
	03	18	2,021	0.006s	0.012s
	04	19	1,624	0.004s	0.011s
	05	20	2,036	0.004s	0.013s
	06	22	1,731	0.006s	0.012s
	07	16	2,199	0.007s	0.012s
	08	80	2,347	0.032s	0.011s
	09	63	3,624	0.006s	0.014s
	10	102	4,360	0.003s	0.012s
	11	95	4,594	0.004s	0.013s
	12	78	4,415	0.005s	0.012s
	13	87	4,534	0.006s	0.012s
	14	69	4,482	0.006s	0.012s
	15	65	4,527	0.004s	0.012s
	16	78	4,609	0.003s	0.012s
	17	94	4,743	0.008s	0.012s
	18	95	4,665	0.002s	0.012s
	19	88	4,568	0.002s	0.012s
	20	75	4,580	0.006s	0.011s
	21	76	4,626	0.003s	0.012s
	22	68	4,319	0.003s	0.012s
	23	53	4,181	0.005s	0.013s
Jul 09	00	61	3,961	0.003s	0.012s
	01	43	2,515	0.005s	0.008s

Day	Hour	Avg time (sec)
Jul 08	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
	23	0s
Jul 09	00	0s
	01	0s

Day	Hour	Mean distance	Mean estimate
Jul 08	02	72,316.09 kB	209,676.45 kB
	03	20,814.18 kB	67,494.09 kB
	04	27,930.73 kB	42,701.55 kB
	05	25,954.38 kB	35,687.31 kB
	06	29,326.33 kB	65,276.42 kB
	07	22,881.10 kB	35,963.10 kB
	08	118,415.36 kB	178,507.55 kB
	09	75,139.77 kB	100,798.00 kB
	10	140,196.67 kB	346,898.25 kB
	11	118,862.31 kB	163,969.00 kB
	12	106,581.83 kB	133,934.17 kB
	13	118,838.67 kB	160,328.33 kB
	14	94,732.92 kB	126,947.92 kB
	15	88,418.92 kB	128,776.00 kB
	16	106,230.25 kB	132,165.92 kB
	17	128,462.58 kB	149,337.42 kB
	18	130,052.00 kB	156,467.83 kB
	19	116,798.73 kB	147,316.45 kB
	20	111,174.27 kB	147,549.64 kB
	21	103,500.92 kB	150,771.00 kB
	22	92,725.50 kB	130,167.25 kB
	23	67,096.69 kB	115,855.54 kB
Jul 09	00	82,981.08 kB	123,406.08 kB
	01	89,145.25 kB	109,062.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (271) Main checkpoint cause
286 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	271
shutdown immediate	15
Total	286

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
Jul 08	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
	23	0	0	0
Jul 09	00	0	0	0
	01	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			Frozen
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes	pages	tuples
NO DATASET

Vacuum throughput per table

Key values

unknown (0) Max CPU elapsed for vacuum on database
unknown (0 ms) Max I/O read time for vacuum on database
unknown (0 ms) Max I/O write time for vacuum on database

Chart
Table

CPU elapsed per tables

	I/O timing (ms)		CPU (s)
Table	read	write	elapsed
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
Jul 08	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
	23	0	0
Jul 09	00	0	0
	01	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

88,277 Total read queries
28 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	88,277	99.97%
INSERT	1	0.00%
UPDATE	5	0.01%
DELETE	2	0.00%
COPY FROM	0	0.00%
COPY TO	15	0.02%
CTE	0	0.00%
DDL	5	0.01%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

unknown Main database
88,305 Requests
5d7h17m44s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	88,305	5d7h17m44s
	copy to	15	8m14s
	ddl	5	3m6s
	delete	2	7s519ms
	insert	1	1m51s
	select	88,277	5d7h3m46s
	update	5	37s50ms

Queries by user

Key values

unknown Main user
88,305 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	88,305	5d7h17m44s
	copy to	15	8m14s
	ddl	5	3m6s
	delete	2	7s519ms
	insert	1	1m51s
	select	88,277	5d7h3m46s
	update	5	37s50ms

Duration by user

Key values

5d7h17m44s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	88,305	5d7h17m44s
	copy to	15	8m14s
	ddl	5	3m6s
	delete	2	7s519ms
	insert	1	1m51s
	select	88,277	5d7h3m46s
	update	5	37s50ms

Queries by host

Key values

unknown Main host
88,305 Requests
5d7h17m44s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	88,305	5d7h17m44s
	copy to	15	8m14s
	ddl	5	3m6s
	delete	2	7s519ms
	insert	1	1m51s
	select	88,277	5d7h3m46s
	update	5	37s50ms

Queries by application

Key values

unknown Main application
88,305 Requests
5d7h17m44s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	88,305	5d7h17m44s
	copy to	15	8m14s
	ddl	5	3m6s
	delete	2	7s519ms
	insert	1	1m51s
	select	88,277	5d7h3m46s
	update	5	37s50ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-08 02:05:00 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

87,633 1000-10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	87,633	99.24%
> 10000ms	672	0.76%

Slowest individual queries

Rank	Duration	Query
1	2m29s	ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key"; [ Date: 2026-07-08 20:44:22 ]
2	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1577); [ Date: 2026-07-08 20:44:22 ]
3	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1769); [ Date: 2026-07-08 20:44:22 ]
4	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1783); [ Date: 2026-07-08 20:44:22 ]
5	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1813); [ Date: 2026-07-08 20:44:22 ]
6	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1340, 821, 1939, 1753, 1370, 1872, 1442, 1342, 1385, 847, 986, 1943, 1610, 1959, 1895, 1953, 1878, 1831, 1873, 956, 879, 1928, 987, 848, 1862, 875, 949, 2014, 915, 1077, 853, 1078, 1378, 1685, 1235, 953, 898, 1949, 1278, 1294, 1472, 1565, 1745, 839, 909, 904, 1050, 1031, 1823, 852, 1906, 1305, 933, 838, 1995, 1992, 1991, 1855, 1994, 1096); [ Date: 2026-07-08 20:44:22 ]
7	2m28s	SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1963; [ Date: 2026-07-08 20:44:22 ]
8	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (840); [ Date: 2026-07-08 20:44:22 ]
9	2m28s	SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1342; [ Date: 2026-07-08 20:44:22 ]
10	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (2045); [ Date: 2026-07-08 20:44:22 ]
11	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (966); [ Date: 2026-07-08 20:44:22 ]
12	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1816); [ Date: 2026-07-08 20:44:22 ]
13	2m28s	SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 938; [ Date: 2026-07-08 20:44:22 ]
14	2m28s	SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1485; [ Date: 2026-07-08 20:44:22 ]
15	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1745); [ Date: 2026-07-08 20:44:22 ]
16	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1); [ Date: 2026-07-08 20:44:22 ]
17	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1404); [ Date: 2026-07-08 20:44:22 ]
18	2m28s	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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1583); [ Date: 2026-07-08 20:44:22 ]
19	2m28s	SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1032; [ Date: 2026-07-08 20:44:22 ]
20	2m28s	SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 848; [ Date: 2026-07-08 20:44:22 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d16h42m16s

85,957

Details

3s

12s938ms

4s720ms

select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 08	02	10,070	11h26m54s	4s92ms
	03	9,454	10h54m55s	4s156ms
	04	9,679	11h2m57s	4s109ms
	05	9,278	10h54m28s	4s232ms
	06	9,751	11h21m8s	4s191ms
	07	10,351	12h2m47s	4s189ms
	08	10,264	12h10m14s	4s268ms
	09	17,110	1d8h48m49s	6s904ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","broadcast"]', '["urg16","mail.channel",120]', '["urg16","res.partner",8009366]', '["urg16","mail.channel",16644]', '["urg16","mail.channel",18608]', '["urg16","mail.channel",16286]', '["urg16","mail.channel",13065]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s938ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","broadcast"]', '["urg16","mail.channel",91]', '["urg16","mail.channel",120]', '["urg16","mail.channel",18505]', '["urg16","res.partner",8004881]', '["urg16","mail.channel",13065]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s937ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","res.partner",8011616]', '["urg16","broadcast"]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s933ms

2

8h33m42s

386

Details

6s832ms

2m28s

1m19s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" where "res_users".id in (...);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 08	20	386	8h33m42s	1m19s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1577);

Date: 2026-07-08 20:44:22 Duration: 2m28s
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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1769);

Date: 2026-07-08 20:44:22 Duration: 2m28s
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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1783);

Date: 2026-07-08 20:44:22 Duration: 2m28s

3

2h50m1s

89

Details

7s594ms

2m28s

1m54s

select active, id, login, password, totp_secret, ( select value from ir_config_parameter where key = ?) from res_users where id = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 08	20	89	2h50m1s	1m54s

SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1963;

Date: 2026-07-08 20:44:22 Duration: 2m28s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1342;

Date: 2026-07-08 20:44:22 Duration: 2m28s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 938;

Date: 2026-07-08 20:44:22 Duration: 2m28s

4

58m31s

773

Details

3s2ms

12s889ms

4s542ms

select "bus_bus".id from "bus_bus" where (("bus_bus"."id" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jul 08	02	82	5m45s	4s215ms
	03	80	5m35s	4s194ms
	04	100	7m	4s206ms
	05	106	7m32s	4s268ms
	06	105	7m28s	4s272ms
	07	113	8m1s	4s262ms
	08	93	6m37s	4s272ms
	09	92	10m21s	6s755ms
	14	1	3s314ms	3s314ms
	20	1	4s571ms	4s571ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","broadcast"]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s889ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","res.partner",8007532]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18413]', '["urg16","broadcast"]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",15028]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:41:08 Duration: 9s728ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","mail.channel",14758]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","broadcast"]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:26:37 Duration: 9s502ms

5

24m6s

15

Details

1m30s

2m8s

1m36s

select u.partner_id as id, case when max(b.last_poll) is null then ? when age(now() at time zone ?, max(b.last_poll)) > interval ? then ? when age(now() at time zone ?, max(b.last_presence)) > interval ? then ? else ? end as status from bus_presence b right join res_users u on b.user_id = u.id where u.partner_id in (...) and u.active = ? group by u.partner_id;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jul 08	20	15	24m6s	1m36s

SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8010199, 8006435, 8011652, 8006376, 8011628, 8011724, 8006411, 8011296, 8006357) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 2m8s
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (8006461, 2, 8010649, 8010500, 8006408, 8007452, 8007485, 8004695, 8006469, 8008778, 8006376, 8004685, 8009117) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 1m52s
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8010199, 8006435, 8011652, 8011628, 8011724, 8006411) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 1m35s

6

11m10s

181

Details

3s166ms

8s231ms

3s704ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jul 08	02	6	36s623ms	6s103ms
	09	2	7s299ms	3s649ms
	10	2	7s37ms	3s518ms
	11	4	15s719ms	3s929ms
	12	3	11s130ms	3s710ms
	14	5	18s656ms	3s731ms
	16	4	15s486ms	3s871ms
	17	22	1m21s	3s696ms
	18	30	1m46s	3s535ms
	19	30	1m47s	3s577ms
	20	13	49s285ms	3s791ms
	21	15	52s910ms	3s527ms
	22	5	17s442ms	3s488ms
	23	14	53s501ms	3s821ms
Jul 09	00	25	1m27s	3s480ms
	01	1	3s770ms	3s770ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (32))))))) 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 (32)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%4307%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 02:06:05 Duration: 8s231ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (32))))))) 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 (32)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%430762%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 02:06:06 Duration: 8s216ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (32))))))) 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 (32)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%43%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 02:06:01 Duration: 5s516ms

7

6m42s

66

Details

3s8ms

15s175ms

6s98ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jul 08	02	9	52s832ms	5s870ms
	03	10	55s404ms	5s540ms
	04	5	26s245ms	5s249ms
	05	2	11s835ms	5s917ms
	06	5	30s222ms	6s44ms
	07	3	15s31ms	5s10ms
	08	9	49s618ms	5s513ms
	09	22	2m36s	7s127ms
	20	1	4s522ms	4s522ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:17:16 Duration: 15s175ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:43:14 Duration: 11s440ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:45:12 Duration: 10s736ms

8

6m41s

61

Details

3s35ms

14s20ms

6s585ms

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) or (("shipping_policy"."state" in (...)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) limit ?) t;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jul 08	02	1	7s676ms	7s676ms
	04	1	6s995ms	6s995ms
	05	3	23s323ms	7s774ms
	06	9	1m2s	6s941ms
	07	2	9s630ms	4s815ms
	08	13	1m23s	6s448ms
	09	31	3m24s	6s602ms
	14	1	3s114ms	3s114ms

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (62, 63, 113, 114)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))))) LIMIT 10001) t;

Date: 2026-07-08 09:26:43 Duration: 14s20ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (97)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))))) LIMIT 10001) t;

Date: 2026-07-08 09:44:54 Duration: 12s231ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (59, 60, 61)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126)))))) LIMIT 10001) t;

Date: 2026-07-08 09:44:31 Duration: 11s796ms

9

6m31s

55

Details

6s725ms

7s600ms

7s125ms

select "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" from "shipping_report_details" where "shipping_report_details".id in (...);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jul 08	10	55	6m31s	7s125ms

SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21772290, 22014914, 22089506, 21993215, 22081000, 22082077, 22098103, 21773357, 21648439, 21584326, 22144883);

Date: 2026-07-08 10:37:09 Duration: 7s600ms
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21214359, 22040037, 21570502, 21966656, 21570437, 21614465, 22053130, 22091648, 21729182, 22086725, 22069295, 21901397, 21289654, 21253772, 21886344);

Date: 2026-07-08 10:34:01 Duration: 7s558ms
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21970364, 21706626, 21852013, 21110502, 21737749);

Date: 2026-07-08 10:35:54 Duration: 7s537ms

10

5m13s

56

Details

3s110ms

10s528ms

5s597ms

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) limit ?) t;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jul 08	02	6	20s256ms	3s376ms
	03	3	14s283ms	4s761ms
	04	1	5s502ms	5s502ms
	06	2	13s444ms	6s722ms
	07	9	53s781ms	5s975ms
	08	12	1m16s	6s398ms
	09	23	2m9s	5s626ms

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (59, 60, 61)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:31:24 Duration: 10s528ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (94)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:27:01 Duration: 9s979ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (58)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:13:41 Duration: 8s945ms

11

4m11s

34

Details

4s840ms

12s127ms

7s391ms

select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jul 08	16	2	14s988ms	7s494ms
	18	5	33s687ms	6s737ms
	19	5	35s183ms	7s36ms
	20	6	53s182ms	8s863ms
	21	3	20s444ms	6s814ms
	22	2	13s743ms	6s871ms
Jul 09	00	5	36s511ms	7s302ms
	01	6	43s579ms	7s263ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%23691%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 20:33:02 Duration: 12s127ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%236911%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 20:33:02 Duration: 10s895ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%541601%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 19:23:46 Duration: 10s44ms

12

4m

31

Details

4s167ms

10s418ms

7s749ms

select "policy_number".id from "policy_number" where (((((((("policy_number"."active" = true) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jul 08	11	1	9s899ms	9s899ms
	12	11	1m29s	8s170ms
	13	3	23s960ms	7s986ms
	16	4	31s129ms	7s782ms
	17	5	34s40ms	6s808ms
	23	7	51s333ms	7s333ms

SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%517824%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:42:51 Duration: 10s418ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%209313%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:43:08 Duration: 10s339ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%517968%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:42:26 Duration: 9s964ms

13

3m29s

19

Details

9s542ms

12s852ms

11s27ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) or (("shipping_policy"."state" in (...)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) order by "shipping_policy"."policy_id", "shipping_policy"."state" asc, "shipping_policy"."x_total_amount_cash_lines" desc limit ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jul 08	11	2	24s227ms	12s113ms
	12	5	55s467ms	11s93ms
	13	4	43s78ms	10s769ms
	14	3	34s539ms	11s513ms
	15	4	41s940ms	10s485ms
	17	1	10s276ms	10s276ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 11:38:34 Duration: 12s852ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 14:30:04 Duration: 12s17ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 12:15:00 Duration: 11s870ms

14

2m29s

1

Details

2m29s

alter table "res_users" drop constraint "res_users_login_key";

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jul 08	20	1	2m29s	2m29s

ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";

Date: 2026-07-08 20:44:22 Duration: 2m29s

15

2m17s

36

Details

3s339ms

6s120ms

3s820ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jul 08	12	9	33s903ms	3s767ms
	13	3	14s693ms	4s897ms
	16	4	16s595ms	4s148ms
	18	9	32s338ms	3s593ms
	21	4	14s917ms	3s729ms
	22	7	25s84ms	3s583ms

SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."name"::text ilike '%3%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 13:07:50 Duration: 6s120ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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 (24, 110))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110))))))) AND ("policy_number"."name"::text ilike '%3%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 16:00:44 Duration: 5s294ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."name"::text ilike '%355804%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 13:07:49 Duration: 4s507ms

16

2m4s

1

Details

2m4s

copy public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) to stdout;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jul 08	08	1	2m4s	2m4s

COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;

Date: 2026-07-08 08:05:11 Duration: 2m4s

17

1m51s

1

Details

1m51s

insert into "change_amount_wizard" ("create_date", "create_uid", "is_increase", "price", "reason", "write_date", "write_uid") values (?, ?, true, ?, ?, ?, ?) returning "id";

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jul 08	20	1	1m51s	1m51s

INSERT INTO "change_amount_wizard" ("create_date", "create_uid", "is_increase", "price", "reason", "write_date", "write_uid") VALUES ('2026-07-08 16:42:30.808766', 1685, true, '160', '0', '2026-07-08 16:42:30.808766', 1685) RETURNING "id";

Date: 2026-07-08 20:44:22 Duration: 1m51s

18

1m47s

9

Details

11s7ms

12s862ms

11s892ms

select "notebook".id from "notebook" where (("notebook"."active" = true) and ("notebook"."id" in ( select "policy_number"."notebook_id" from "policy_number" where (("policy_number"."active" = true) and ("policy_number"."name"::text ilike ?)) and "policy_number"."notebook_id" is not null))) order by "notebook"."id" limit ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jul 08	10	2	23s476ms	11s738ms
	13	2	25s582ms	12s791ms
	16	4	46s856ms	11s714ms
	18	1	11s113ms	11s113ms

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%9894029%')) AND "policy_number"."notebook_id" IS NOT NULL))) ORDER BY "notebook"."id" LIMIT 80;

Date: 2026-07-08 13:22:14 Duration: 12s862ms
SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%6478630%')) AND "policy_number"."notebook_id" IS NOT NULL))) ORDER BY "notebook"."id" LIMIT 80;

Date: 2026-07-08 13:24:49 Duration: 12s720ms
SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%156979%')) AND "policy_number"."notebook_id" IS NOT NULL))) ORDER BY "notebook"."id" LIMIT 80;

Date: 2026-07-08 10:37:58 Duration: 12s468ms

19

1m35s

21

Details

3s104ms

11s265ms

4s542ms

select "policy_number".id from "policy_number" where (("policy_number"."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"."office_id" in (...)))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jul 08	08	4	28s560ms	7s140ms
	09	2	7s28ms	3s514ms
	11	10	40s362ms	4s36ms
	12	1	4s80ms	4s80ms
	13	1	3s332ms	3s332ms
	15	1	4s862ms	4s862ms
	16	1	3s725ms	3s725ms
	17	1	3s445ms	3s445ms

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (64)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 08:23:31 Duration: 11s265ms
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (29)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 08:02:58 Duration: 9s562ms
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (78)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 15:32:39 Duration: 4s862ms

20

1m33s

1

Details

1m33s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" left join "res_partner" AS "res_users__partner_id" on ("res_users"."partner_id" = "res_users__partner_id"."id") where (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? from "res_company_users_rel" AS "res_users__company_ids" where "res_users__company_ids"."user_id" = "res_users".id and "res_users__company_ids"."cid" in (...))) and ((("res_users__partner_id"."partner_share" is null or "res_users__partner_id"."partner_share" = false) or (("res_users__partner_id"."company_id" in (...)) or "res_users__partner_id"."company_id" is null)) and ((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null)) and "res_users".id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jul 08	20	1	1m33s	1m33s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND ((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR (("res_users__partner_id"."company_id" in (1)) OR "res_users__partner_id"."company_id" IS NULL)) AND ((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL)) AND "res_users".id IN (848);

Date: 2026-07-08 20:44:22 Duration: 1m33s

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

85,957

Details

4d16h42m16s

3s

12s938ms

4s720ms

select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 08	02	10,070	11h26m54s	4s92ms
	03	9,454	10h54m55s	4s156ms
	04	9,679	11h2m57s	4s109ms
	05	9,278	10h54m28s	4s232ms
	06	9,751	11h21m8s	4s191ms
	07	10,351	12h2m47s	4s189ms
	08	10,264	12h10m14s	4s268ms
	09	17,110	1d8h48m49s	6s904ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","broadcast"]', '["urg16","mail.channel",120]', '["urg16","res.partner",8009366]', '["urg16","mail.channel",16644]', '["urg16","mail.channel",18608]', '["urg16","mail.channel",16286]', '["urg16","mail.channel",13065]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s938ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","broadcast"]', '["urg16","mail.channel",91]', '["urg16","mail.channel",120]', '["urg16","mail.channel",18505]', '["urg16","res.partner",8004881]', '["urg16","mail.channel",13065]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s937ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","res.partner",8011616]', '["urg16","broadcast"]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s933ms

2

773

Details

58m31s

3s2ms

12s889ms

4s542ms

select "bus_bus".id from "bus_bus" where (("bus_bus"."id" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 08	02	82	5m45s	4s215ms
	03	80	5m35s	4s194ms
	04	100	7m	4s206ms
	05	106	7m32s	4s268ms
	06	105	7m28s	4s272ms
	07	113	8m1s	4s262ms
	08	93	6m37s	4s272ms
	09	92	10m21s	6s755ms
	14	1	3s314ms	3s314ms
	20	1	4s571ms	4s571ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","broadcast"]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s889ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","res.partner",8007532]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18413]', '["urg16","broadcast"]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",15028]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:41:08 Duration: 9s728ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","mail.channel",14758]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","broadcast"]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:26:37 Duration: 9s502ms

3

386

Details

8h33m42s

6s832ms

2m28s

1m19s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" where "res_users".id in (...);

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 08	20	386	8h33m42s	1m19s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1577);

Date: 2026-07-08 20:44:22 Duration: 2m28s
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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1769);

Date: 2026-07-08 20:44:22 Duration: 2m28s
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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1783);

Date: 2026-07-08 20:44:22 Duration: 2m28s

4

181

Details

11m10s

3s166ms

8s231ms

3s704ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jul 08	02	6	36s623ms	6s103ms
	09	2	7s299ms	3s649ms
	10	2	7s37ms	3s518ms
	11	4	15s719ms	3s929ms
	12	3	11s130ms	3s710ms
	14	5	18s656ms	3s731ms
	16	4	15s486ms	3s871ms
	17	22	1m21s	3s696ms
	18	30	1m46s	3s535ms
	19	30	1m47s	3s577ms
	20	13	49s285ms	3s791ms
	21	15	52s910ms	3s527ms
	22	5	17s442ms	3s488ms
	23	14	53s501ms	3s821ms
Jul 09	00	25	1m27s	3s480ms
	01	1	3s770ms	3s770ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (32))))))) 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 (32)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%4307%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 02:06:05 Duration: 8s231ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (32))))))) 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 (32)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%430762%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 02:06:06 Duration: 8s216ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (32))))))) 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 (32)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%43%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 02:06:01 Duration: 5s516ms

5

89

Details

2h50m1s

7s594ms

2m28s

1m54s

select active, id, login, password, totp_secret, ( select value from ir_config_parameter where key = ?) from res_users where id = ?;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jul 08	20	89	2h50m1s	1m54s

SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1963;

Date: 2026-07-08 20:44:22 Duration: 2m28s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1342;

Date: 2026-07-08 20:44:22 Duration: 2m28s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 938;

Date: 2026-07-08 20:44:22 Duration: 2m28s

6

66

Details

6m42s

3s8ms

15s175ms

6s98ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jul 08	02	9	52s832ms	5s870ms
	03	10	55s404ms	5s540ms
	04	5	26s245ms	5s249ms
	05	2	11s835ms	5s917ms
	06	5	30s222ms	6s44ms
	07	3	15s31ms	5s10ms
	08	9	49s618ms	5s513ms
	09	22	2m36s	7s127ms
	20	1	4s522ms	4s522ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:17:16 Duration: 15s175ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:43:14 Duration: 11s440ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:45:12 Duration: 10s736ms

7

61

Details

6m41s

3s35ms

14s20ms

6s585ms

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) or (("shipping_policy"."state" in (...)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) limit ?) t;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jul 08	02	1	7s676ms	7s676ms
	04	1	6s995ms	6s995ms
	05	3	23s323ms	7s774ms
	06	9	1m2s	6s941ms
	07	2	9s630ms	4s815ms
	08	13	1m23s	6s448ms
	09	31	3m24s	6s602ms
	14	1	3s114ms	3s114ms

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (62, 63, 113, 114)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))))) LIMIT 10001) t;

Date: 2026-07-08 09:26:43 Duration: 14s20ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (97)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))))) LIMIT 10001) t;

Date: 2026-07-08 09:44:54 Duration: 12s231ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (59, 60, 61)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126)))))) LIMIT 10001) t;

Date: 2026-07-08 09:44:31 Duration: 11s796ms

8

56

Details

5m13s

3s110ms

10s528ms

5s597ms

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) limit ?) t;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jul 08	02	6	20s256ms	3s376ms
	03	3	14s283ms	4s761ms
	04	1	5s502ms	5s502ms
	06	2	13s444ms	6s722ms
	07	9	53s781ms	5s975ms
	08	12	1m16s	6s398ms
	09	23	2m9s	5s626ms

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (59, 60, 61)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:31:24 Duration: 10s528ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (94)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:27:01 Duration: 9s979ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (58)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:13:41 Duration: 8s945ms

9

55

Details

6m31s

6s725ms

7s600ms

7s125ms

select "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" from "shipping_report_details" where "shipping_report_details".id in (...);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jul 08	10	55	6m31s	7s125ms

SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21772290, 22014914, 22089506, 21993215, 22081000, 22082077, 22098103, 21773357, 21648439, 21584326, 22144883);

Date: 2026-07-08 10:37:09 Duration: 7s600ms
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21214359, 22040037, 21570502, 21966656, 21570437, 21614465, 22053130, 22091648, 21729182, 22086725, 22069295, 21901397, 21289654, 21253772, 21886344);

Date: 2026-07-08 10:34:01 Duration: 7s558ms
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21970364, 21706626, 21852013, 21110502, 21737749);

Date: 2026-07-08 10:35:54 Duration: 7s537ms

10

36

Details

2m17s

3s339ms

6s120ms

3s820ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jul 08	12	9	33s903ms	3s767ms
	13	3	14s693ms	4s897ms
	16	4	16s595ms	4s148ms
	18	9	32s338ms	3s593ms
	21	4	14s917ms	3s729ms
	22	7	25s84ms	3s583ms

SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."name"::text ilike '%3%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 13:07:50 Duration: 6s120ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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 (24, 110))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110))))))) AND ("policy_number"."name"::text ilike '%3%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 16:00:44 Duration: 5s294ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))) AND ("policy_number"."name"::text ilike '%355804%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 13:07:49 Duration: 4s507ms

11

34

Details

4m11s

4s840ms

12s127ms

7s391ms

select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jul 08	16	2	14s988ms	7s494ms
	18	5	33s687ms	6s737ms
	19	5	35s183ms	7s36ms
	20	6	53s182ms	8s863ms
	21	3	20s444ms	6s814ms
	22	2	13s743ms	6s871ms
Jul 09	00	5	36s511ms	7s302ms
	01	6	43s579ms	7s263ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%23691%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 20:33:02 Duration: 12s127ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%236911%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 20:33:02 Duration: 10s895ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%541601%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 19:23:46 Duration: 10s44ms

12

31

Details

4m

4s167ms

10s418ms

7s749ms

select "policy_number".id from "policy_number" where (((((((("policy_number"."active" = true) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jul 08	11	1	9s899ms	9s899ms
	12	11	1m29s	8s170ms
	13	3	23s960ms	7s986ms
	16	4	31s129ms	7s782ms
	17	5	34s40ms	6s808ms
	23	7	51s333ms	7s333ms

SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%517824%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:42:51 Duration: 10s418ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%209313%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:43:08 Duration: 10s339ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%517968%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:42:26 Duration: 9s964ms

13

21

Details

1m35s

3s104ms

11s265ms

4s542ms

select "policy_number".id from "policy_number" where (("policy_number"."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"."office_id" in (...)))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jul 08	08	4	28s560ms	7s140ms
	09	2	7s28ms	3s514ms
	11	10	40s362ms	4s36ms
	12	1	4s80ms	4s80ms
	13	1	3s332ms	3s332ms
	15	1	4s862ms	4s862ms
	16	1	3s725ms	3s725ms
	17	1	3s445ms	3s445ms

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (64)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 08:23:31 Duration: 11s265ms
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (29)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 08:02:58 Duration: 9s562ms
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (78)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 15:32:39 Duration: 4s862ms

14

19

Details

3m29s

9s542ms

12s852ms

11s27ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) or (("shipping_policy"."state" in (...)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) order by "shipping_policy"."policy_id", "shipping_policy"."state" asc, "shipping_policy"."x_total_amount_cash_lines" desc limit ?;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jul 08	11	2	24s227ms	12s113ms
	12	5	55s467ms	11s93ms
	13	4	43s78ms	10s769ms
	14	3	34s539ms	11s513ms
	15	4	41s940ms	10s485ms
	17	1	10s276ms	10s276ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 11:38:34 Duration: 12s852ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 14:30:04 Duration: 12s17ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 12:15:00 Duration: 11s870ms

15

17

Details

1m

3s71ms

3s974ms

3s580ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."name"::text ilike ?))))) 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 limit ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jul 08	08	1	3s71ms	3s71ms
	10	1	3s974ms	3s974ms
	11	3	10s665ms	3s555ms
	12	2	7s138ms	3s569ms
	14	3	10s798ms	3s599ms
	15	2	7s180ms	3s590ms
	16	2	7s124ms	3s562ms
	17	2	7s454ms	3s727ms
	18	1	3s460ms	3s460ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%منص%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (59, 60, 61)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) 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 LIMIT 100;

Date: 2026-07-08 10:30:17 Duration: 3s974ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%معاد%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (93)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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 LIMIT 100;

Date: 2026-07-08 17:29:59 Duration: 3s953ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%ارض اللواء%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (106)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) 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 LIMIT 100;

Date: 2026-07-08 14:16:54 Duration: 3s718ms

16

Details

57s653ms

3s314ms

3s848ms

3s603ms

select "shipping_policy".id from "shipping_policy" left join "urgent_office" AS "shipping_policy__to_office" on ("shipping_policy"."to_office" = "shipping_policy__to_office"."id") where (("shipping_policy"."active" = true) and (("shipping_policy"."state" = ?) and (((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and (("shipping_policy"."review_state" = ?) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."create_date" < ?)))))) and true order by "shipping_policy"."policy_id", "shipping_policy__to_office"."new_code" asc, "shipping_policy"."x_collection_amount_sender" desc limit ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jul 08	13	9	32s164ms	3s573ms
	14	6	22s27ms	3s671ms
	17	1	3s460ms	3s460ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "urgent_office" AS "shipping_policy__to_office" ON ("shipping_policy"."to_office" = "shipping_policy__to_office"."id") WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" = 'archive') AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND (("shipping_policy"."review_state" = 'not_review') AND ((("shipping_policy"."state" != 'hold') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."create_date" < '2026-06-28')))))) AND TRUE ORDER BY "shipping_policy"."policy_id", "shipping_policy__to_office"."new_code" ASC, "shipping_policy"."x_collection_amount_sender" DESC LIMIT 100;

Date: 2026-07-08 14:06:22 Duration: 3s848ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "urgent_office" AS "shipping_policy__to_office" ON ("shipping_policy"."to_office" = "shipping_policy__to_office"."id") WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" = 'archive') AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND (("shipping_policy"."review_state" = 'not_review') AND ((("shipping_policy"."state" != 'hold') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."create_date" < '2026-06-28')))))) AND TRUE ORDER BY "shipping_policy"."policy_id", "shipping_policy__to_office"."new_code" ASC, "shipping_policy"."x_collection_amount_sender" DESC LIMIT 100;

Date: 2026-07-08 13:55:48 Duration: 3s793ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "urgent_office" AS "shipping_policy__to_office" ON ("shipping_policy"."to_office" = "shipping_policy__to_office"."id") WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" = 'archive') AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND (("shipping_policy"."review_state" = 'not_review') AND ((("shipping_policy"."state" != 'hold') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."create_date" < '2026-06-28')))))) AND TRUE ORDER BY "shipping_policy"."policy_id", "shipping_policy__to_office"."new_code" ASC, "shipping_policy"."x_collection_amount_sender" DESC LIMIT 100;

Date: 2026-07-08 13:21:05 Duration: 3s782ms

17

15

Details

24m6s

1m30s

2m8s

1m36s

select u.partner_id as id, case when max(b.last_poll) is null then ? when age(now() at time zone ?, max(b.last_poll)) > interval ? then ? when age(now() at time zone ?, max(b.last_presence)) > interval ? then ? else ? end as status from bus_presence b right join res_users u on b.user_id = u.id where u.partner_id in (...) and u.active = ? group by u.partner_id;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jul 08	20	15	24m6s	1m36s

SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8010199, 8006435, 8011652, 8006376, 8011628, 8011724, 8006411, 8011296, 8006357) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 2m8s
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (8006461, 2, 8010649, 8010500, 8006408, 8007452, 8007485, 8004695, 8006469, 8008778, 8006376, 8004685, 8009117) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 1m52s
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8010199, 8006435, 8011652, 8011628, 8011724, 8006411) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 1m35s

18

13

Details

50s974ms

3s387ms

4s534ms

3s921ms

select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jul 08	12	7	28s939ms	4s134ms
	16	1	3s713ms	3s713ms
	17	1	3s615ms	3s615ms
	23	4	14s706ms	3s676ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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" LIMIT 8;

Date: 2026-07-08 12:42:35 Duration: 4s534ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7, 38, 121)))))) AND ("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" LIMIT 8;

Date: 2026-07-08 12:42:31 Duration: 4s413ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" 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, 43, 70, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66)))))) AND ("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" LIMIT 8;

Date: 2026-07-08 23:04:27 Duration: 4s300ms

19

13

Details

46s753ms

3s358ms

3s875ms

3s596ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."name"::text ilike ?))))) 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 limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jul 08	10	3	10s745ms	3s581ms
	11	1	3s807ms	3s807ms
	12	1	3s358ms	3s358ms
	13	4	14s345ms	3s586ms
	15	3	11s18ms	3s672ms
	19	1	3s476ms	3s476ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%حلوان%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (95)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))) 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 LIMIT 100;

Date: 2026-07-08 10:49:07 Duration: 3s875ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%شمس%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (91)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) 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 LIMIT 100;

Date: 2026-07-08 11:44:04 Duration: 3s807ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%السويس%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (69)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4))))) 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 LIMIT 100;

Date: 2026-07-08 15:36:03 Duration: 3s758ms

20

12

Details

1m16s

3s564ms

10s721ms

6s351ms

select min("shipping_policy".id) as id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" AS "last_warehouse" from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."return_reason" is not null and ((("shipping_policy"."state" = ?) or (("shipping_policy"."state" = ?) or ("shipping_policy"."state" = ?))) and ((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where (("urgent_office"."name"::text not ilike ?) or "urgent_office"."name" is null))) or "shipping_policy"."to_office" is null) and ("shipping_policy"."return_date" < ?)))))) 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))))) group by "shipping_policy"."last_warehouse" order by "last_warehouse" limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jul 08	09	12	1m16s	6s351ms

SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" as "last_warehouse" FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."return_reason" IS NOT NULL AND ((("shipping_policy"."state" = 'in_office') OR (("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'wating'))) AND ((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE (("urgent_office"."name"::text not ilike '%التخزين%') OR "urgent_office"."name" IS NULL))) OR "shipping_policy"."to_office" IS NULL) AND ("shipping_policy"."return_date" < '2026-05-01')))))) 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, 115, 116, 117, 118, 123, 127, 128, 129, 133, 134, 135, 136, 137, 141, 142, 143)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) 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))))) GROUP BY "shipping_policy"."last_warehouse" ORDER BY "last_warehouse" LIMIT 80;

Date: 2026-07-08 09:20:10 Duration: 10s721ms
SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" as "last_warehouse" FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."return_reason" IS NOT NULL AND ((("shipping_policy"."state" = 'in_office') OR (("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'wating'))) AND ((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE (("urgent_office"."name"::text not ilike '%التخزين%') OR "urgent_office"."name" IS NULL))) OR "shipping_policy"."to_office" IS NULL) AND ("shipping_policy"."return_date" < '2026-05-01')))))) 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, 115, 116, 117, 118, 123, 127, 128, 129, 133, 134, 135, 136, 137, 141, 142, 143)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) 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))))) GROUP BY "shipping_policy"."last_warehouse" ORDER BY "last_warehouse" LIMIT 80;

Date: 2026-07-08 09:20:08 Duration: 9s520ms
SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" as "last_warehouse" FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."return_reason" IS NOT NULL AND ((("shipping_policy"."state" = 'in_office') OR (("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'wating'))) AND ((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE (("urgent_office"."name"::text not ilike '%التخزين%') OR "urgent_office"."name" IS NULL))) OR "shipping_policy"."to_office" IS NULL) AND ("shipping_policy"."return_date" < '2026-05-01')))))) 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, 115, 116, 117, 118, 123, 127, 128, 129, 133, 134, 135, 136, 137, 141, 142, 143)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) 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))))) GROUP BY "shipping_policy"."last_warehouse" ORDER BY "last_warehouse" LIMIT 80;

Date: 2026-07-08 09:20:08 Duration: 9s281ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

2m29s

1

Details

2m29s

alter table "res_users" drop constraint "res_users_login_key";

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 08	20	1	2m29s	2m29s

ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";

Date: 2026-07-08 20:44:22 Duration: 2m29s

2

2m4s

1

Details

2m4s

copy public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) to stdout;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jul 08	08	1	2m4s	2m4s

COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;

Date: 2026-07-08 08:05:11 Duration: 2m4s

3

7s594ms

2m28s

1m54s

89

Details

2h50m1s

select active, id, login, password, totp_secret, ( select value from ir_config_parameter where key = ?) from res_users where id = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jul 08	20	89	2h50m1s	1m54s

SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1963;

Date: 2026-07-08 20:44:22 Duration: 2m28s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1342;

Date: 2026-07-08 20:44:22 Duration: 2m28s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 938;

Date: 2026-07-08 20:44:22 Duration: 2m28s

4

1m51s

1

Details

1m51s

insert into "change_amount_wizard" ("create_date", "create_uid", "is_increase", "price", "reason", "write_date", "write_uid") values (?, ?, true, ?, ?, ?, ?) returning "id";

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jul 08	20	1	1m51s	1m51s

INSERT INTO "change_amount_wizard" ("create_date", "create_uid", "is_increase", "price", "reason", "write_date", "write_uid") VALUES ('2026-07-08 16:42:30.808766', 1685, true, '160', '0', '2026-07-08 16:42:30.808766', 1685) RETURNING "id";

Date: 2026-07-08 20:44:22 Duration: 1m51s

5

1m30s

2m8s

1m36s

15

Details

24m6s

select u.partner_id as id, case when max(b.last_poll) is null then ? when age(now() at time zone ?, max(b.last_poll)) > interval ? then ? when age(now() at time zone ?, max(b.last_presence)) > interval ? then ? else ? end as status from bus_presence b right join res_users u on b.user_id = u.id where u.partner_id in (...) and u.active = ? group by u.partner_id;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jul 08	20	15	24m6s	1m36s

SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8010199, 8006435, 8011652, 8006376, 8011628, 8011724, 8006411, 8011296, 8006357) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 2m8s
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (8006461, 2, 8010649, 8010500, 8006408, 8007452, 8007485, 8004695, 8006469, 8008778, 8006376, 8004685, 8009117) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 1m52s
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8010199, 8006435, 8011652, 8011628, 8011724, 8006411) AND U.active = 't' GROUP BY U.partner_id;

Date: 2026-07-08 20:44:22 Duration: 1m35s

6

1m33s

1

Details

1m33s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" left join "res_partner" AS "res_users__partner_id" on ("res_users"."partner_id" = "res_users__partner_id"."id") where (("res_users"."share" is null or "res_users"."share" = false) or exists ( select ? from "res_company_users_rel" AS "res_users__company_ids" where "res_users__company_ids"."user_id" = "res_users".id and "res_users__company_ids"."cid" in (...))) and ((("res_users__partner_id"."partner_share" is null or "res_users__partner_id"."partner_share" = false) or (("res_users__partner_id"."company_id" in (...)) or "res_users__partner_id"."company_id" is null)) and ((("res_users__partner_id"."type" != ?) or "res_users__partner_id"."type" is null) or "res_users__partner_id"."type" is null)) and "res_users".id in (...);

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jul 08	20	1	1m33s	1m33s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND ((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR (("res_users__partner_id"."company_id" in (1)) OR "res_users__partner_id"."company_id" IS NULL)) AND ((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL)) AND "res_users".id IN (848);

Date: 2026-07-08 20:44:22 Duration: 1m33s

7

6s832ms

2m28s

1m19s

386

Details

8h33m42s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" where "res_users".id in (...);

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jul 08	20	386	8h33m42s	1m19s

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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1577);

Date: 2026-07-08 20:44:22 Duration: 2m28s
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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1769);

Date: 2026-07-08 20:44:22 Duration: 2m28s
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"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (1783);

Date: 2026-07-08 20:44:22 Duration: 2m28s

8

11s7ms

12s862ms

11s892ms

9

Details

1m47s

select "notebook".id from "notebook" where (("notebook"."active" = true) and ("notebook"."id" in ( select "policy_number"."notebook_id" from "policy_number" where (("policy_number"."active" = true) and ("policy_number"."name"::text ilike ?)) and "policy_number"."notebook_id" is not null))) order by "notebook"."id" limit ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jul 08	10	2	23s476ms	11s738ms
	13	2	25s582ms	12s791ms
	16	4	46s856ms	11s714ms
	18	1	11s113ms	11s113ms

SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%9894029%')) AND "policy_number"."notebook_id" IS NOT NULL))) ORDER BY "notebook"."id" LIMIT 80;

Date: 2026-07-08 13:22:14 Duration: 12s862ms
SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%6478630%')) AND "policy_number"."notebook_id" IS NOT NULL))) ORDER BY "notebook"."id" LIMIT 80;

Date: 2026-07-08 13:24:49 Duration: 12s720ms
SELECT "notebook".id FROM "notebook" WHERE (("notebook"."active" = true) AND ("notebook"."id" IN ( SELECT "policy_number"."notebook_id" FROM "policy_number" WHERE (("policy_number"."active" = true) AND ("policy_number"."name"::text ilike '%156979%')) AND "policy_number"."notebook_id" IS NOT NULL))) ORDER BY "notebook"."id" LIMIT 80;

Date: 2026-07-08 10:37:58 Duration: 12s468ms

9

9s542ms

12s852ms

11s27ms

19

Details

3m29s

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) or (("shipping_policy"."state" in (...)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) order by "shipping_policy"."policy_id", "shipping_policy"."state" asc, "shipping_policy"."x_total_amount_cash_lines" desc limit ?;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jul 08	11	2	24s227ms	12s113ms
	12	5	55s467ms	11s93ms
	13	4	43s78ms	10s769ms
	14	3	34s539ms	11s513ms
	15	4	41s940ms	10s485ms
	17	1	10s276ms	10s276ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 11:38:34 Duration: 12s852ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 14:30:04 Duration: 12s17ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (42, 77, 78, 123)))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (9)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."state" ASC, "shipping_policy"."x_total_amount_cash_lines" DESC LIMIT 100;

Date: 2026-07-08 12:15:00 Duration: 11s870ms

10

4s167ms

10s418ms

7s749ms

31

Details

4m

select "policy_number".id from "policy_number" where (((((((("policy_number"."active" = true) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jul 08	11	1	9s899ms	9s899ms
	12	11	1m29s	8s170ms
	13	3	23s960ms	7s986ms
	16	4	31s129ms	7s782ms
	17	5	34s40ms	6s808ms
	23	7	51s333ms	7s333ms

SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%517824%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:42:51 Duration: 10s418ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%209313%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:43:08 Duration: 10s339ms
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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))) AND ("policy_number"."name"::text ilike '%517968%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 12:42:26 Duration: 9s964ms

11

4s840ms

12s127ms

7s391ms

34

Details

4m11s

select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jul 08	16	2	14s988ms	7s494ms
	18	5	33s687ms	6s737ms
	19	5	35s183ms	7s36ms
	20	6	53s182ms	8s863ms
	21	3	20s444ms	6s814ms
	22	2	13s743ms	6s871ms
Jul 09	00	5	36s511ms	7s302ms
	01	6	43s579ms	7s263ms

SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%23691%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 20:33:02 Duration: 12s127ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%236911%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 20:33:02 Duration: 10s895ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%541601%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-07-08 19:23:46 Duration: 10s44ms

12

6s725ms

7s600ms

7s125ms

55

Details

6m31s

select "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" from "shipping_report_details" where "shipping_report_details".id in (...);

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jul 08	10	55	6m31s	7s125ms

SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21772290, 22014914, 22089506, 21993215, 22081000, 22082077, 22098103, 21773357, 21648439, 21584326, 22144883);

Date: 2026-07-08 10:37:09 Duration: 7s600ms
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21214359, 22040037, 21570502, 21966656, 21570437, 21614465, 22053130, 22091648, 21729182, 22086725, 22069295, 21901397, 21289654, 21253772, 21886344);

Date: 2026-07-08 10:34:01 Duration: 7s558ms
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (21970364, 21706626, 21852013, 21110502, 21737749);

Date: 2026-07-08 10:35:54 Duration: 7s537ms

13

3s35ms

14s20ms

6s585ms

61

Details

6m41s

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) or (("shipping_policy"."state" in (...)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) limit ?) t;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jul 08	02	1	7s676ms	7s676ms
	04	1	6s995ms	6s995ms
	05	3	23s323ms	7s774ms
	06	9	1m2s	6s941ms
	07	2	9s630ms	4s815ms
	08	13	1m23s	6s448ms
	09	31	3m24s	6s602ms
	14	1	3s114ms	3s114ms

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (62, 63, 113, 114)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))))) LIMIT 10001) t;

Date: 2026-07-08 09:26:43 Duration: 14s20ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (97)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))))) LIMIT 10001) t;

Date: 2026-07-08 09:44:54 Duration: 12s231ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (59, 60, 61)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65, 22, 126)))))) LIMIT 10001) t;

Date: 2026-07-08 09:44:31 Duration: 11s796ms

14

3s564ms

10s721ms

6s351ms

12

Details

1m16s

select min("shipping_policy".id) as id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" AS "last_warehouse" from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."return_reason" is not null and ((("shipping_policy"."state" = ?) or (("shipping_policy"."state" = ?) or ("shipping_policy"."state" = ?))) and ((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where (("urgent_office"."name"::text not ilike ?) or "urgent_office"."name" is null))) or "shipping_policy"."to_office" is null) and ("shipping_policy"."return_date" < ?)))))) 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))))) group by "shipping_policy"."last_warehouse" order by "last_warehouse" limit ?;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jul 08	09	12	1m16s	6s351ms

SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" as "last_warehouse" FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."return_reason" IS NOT NULL AND ((("shipping_policy"."state" = 'in_office') OR (("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'wating'))) AND ((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE (("urgent_office"."name"::text not ilike '%التخزين%') OR "urgent_office"."name" IS NULL))) OR "shipping_policy"."to_office" IS NULL) AND ("shipping_policy"."return_date" < '2026-05-01')))))) 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, 115, 116, 117, 118, 123, 127, 128, 129, 133, 134, 135, 136, 137, 141, 142, 143)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) 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))))) GROUP BY "shipping_policy"."last_warehouse" ORDER BY "last_warehouse" LIMIT 80;

Date: 2026-07-08 09:20:10 Duration: 10s721ms
SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" as "last_warehouse" FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."return_reason" IS NOT NULL AND ((("shipping_policy"."state" = 'in_office') OR (("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'wating'))) AND ((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE (("urgent_office"."name"::text not ilike '%التخزين%') OR "urgent_office"."name" IS NULL))) OR "shipping_policy"."to_office" IS NULL) AND ("shipping_policy"."return_date" < '2026-05-01')))))) 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, 115, 116, 117, 118, 123, 127, 128, 129, 133, 134, 135, 136, 137, 141, 142, 143)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) 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))))) GROUP BY "shipping_policy"."last_warehouse" ORDER BY "last_warehouse" LIMIT 80;

Date: 2026-07-08 09:20:08 Duration: 9s520ms
SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "last_warehouse_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."last_warehouse" as "last_warehouse" FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."return_reason" IS NOT NULL AND ((("shipping_policy"."state" = 'in_office') OR (("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'wating'))) AND ((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE (("urgent_office"."name"::text not ilike '%التخزين%') OR "urgent_office"."name" IS NULL))) OR "shipping_policy"."to_office" IS NULL) AND ("shipping_policy"."return_date" < '2026-05-01')))))) 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, 115, 116, 117, 118, 123, 127, 128, 129, 133, 134, 135, 136, 137, 141, 142, 143)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66, 95, 63, 69, 86))))) 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))))) GROUP BY "shipping_policy"."last_warehouse" ORDER BY "last_warehouse" LIMIT 80;

Date: 2026-07-08 09:20:08 Duration: 9s281ms

15

3s8ms

15s175ms

6s98ms

66

Details

6m42s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jul 08	02	9	52s832ms	5s870ms
	03	10	55s404ms	5s540ms
	04	5	26s245ms	5s249ms
	05	2	11s835ms	5s917ms
	06	5	30s222ms	6s44ms
	07	3	15s31ms	5s10ms
	08	9	49s618ms	5s513ms
	09	22	2m36s	7s127ms
	20	1	4s522ms	4s522ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:17:16 Duration: 15s175ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:43:14 Duration: 11s440ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2026-07-08 09:45:12 Duration: 10s736ms

16

3s110ms

10s528ms

5s597ms

56

Details

5m13s

select count(*) from ( select from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" != ?) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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))))) limit ?) t;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jul 08	02	6	20s256ms	3s376ms
	03	3	14s283ms	4s761ms
	04	1	5s502ms	5s502ms
	06	2	13s444ms	6s722ms
	07	9	53s781ms	5s975ms
	08	12	1m16s	6s398ms
	09	23	2m9s	5s626ms

SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (59, 60, 61)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:31:24 Duration: 10s528ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (94)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:27:01 Duration: 9s979ms
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (58)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) 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))))) LIMIT 10001) t;

Date: 2026-07-08 09:13:41 Duration: 8s945ms

17

3s

12s938ms

4s720ms

85,957

Details

4d16h42m16s

select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jul 08	02	10,070	11h26m54s	4s92ms
	03	9,454	10h54m55s	4s156ms
	04	9,679	11h2m57s	4s109ms
	05	9,278	10h54m28s	4s232ms
	06	9,751	11h21m8s	4s191ms
	07	10,351	12h2m47s	4s189ms
	08	10,264	12h10m14s	4s268ms
	09	17,110	1d8h48m49s	6s904ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","broadcast"]', '["urg16","mail.channel",120]', '["urg16","res.partner",8009366]', '["urg16","mail.channel",16644]', '["urg16","mail.channel",18608]', '["urg16","mail.channel",16286]', '["urg16","mail.channel",13065]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s938ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","broadcast"]', '["urg16","mail.channel",91]', '["urg16","mail.channel",120]', '["urg16","mail.channel",18505]', '["urg16","res.partner",8004881]', '["urg16","mail.channel",13065]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s937ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2026-07-08 07:31:12') AND ("bus_bus"."channel" in ('["urg16","res.partner",8011616]', '["urg16","broadcast"]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s933ms

18

3s104ms

11s265ms

4s542ms

21

Details

1m35s

select "policy_number".id from "policy_number" where (("policy_number"."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"."office_id" in (...)))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jul 08	08	4	28s560ms	7s140ms
	09	2	7s28ms	3s514ms
	11	10	40s362ms	4s36ms
	12	1	4s80ms	4s80ms
	13	1	3s332ms	3s332ms
	15	1	4s862ms	4s862ms
	16	1	3s725ms	3s725ms
	17	1	3s445ms	3s445ms

SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (64)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 08:23:31 Duration: 11s265ms
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (29)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 08:02:58 Duration: 9s562ms
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (78)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-07-08 15:32:39 Duration: 4s862ms

19

3s2ms

12s889ms

4s542ms

773

Details

58m31s

select "bus_bus".id from "bus_bus" where (("bus_bus"."id" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jul 08	02	82	5m45s	4s215ms
	03	80	5m35s	4s194ms
	04	100	7m	4s206ms
	05	106	7m32s	4s268ms
	06	105	7m28s	4s272ms
	07	113	8m1s	4s262ms
	08	93	6m37s	4s272ms
	09	92	10m21s	6s755ms
	14	1	3s314ms	3s314ms
	20	1	4s571ms	4s571ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","broadcast"]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:32:15 Duration: 12s889ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","res.partner",8007532]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18413]', '["urg16","broadcast"]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",15028]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:41:08 Duration: 9s728ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '4940493') AND ("bus_bus"."channel" in ('["urg16","mail.channel",14758]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",19202]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",15843]', '["urg16","mail.channel",18793]', '["urg16","mail.channel",19333]', '["urg16","mail.channel",19391]', '["urg16","mail.channel",17771]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",17377]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",18118]', '["urg16","broadcast"]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]'))) ORDER BY "bus_bus"."id";

Date: 2026-07-08 09:26:37 Duration: 9s502ms

20

3s387ms

4s534ms

3s921ms

13

Details

50s974ms

select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("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"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jul 08	12	7	28s939ms	4s134ms
	16	1	3s713ms	3s713ms
	17	1	3s615ms	3s615ms
	23	4	14s706ms	3s676ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))))) AND ("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" LIMIT 8;

Date: 2026-07-08 12:42:35 Duration: 4s534ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7, 38, 121)))))) AND ("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" LIMIT 8;

Date: 2026-07-08 12:42:31 Duration: 4s413ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" 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, 43, 70, 61, 46, 11, 26, 23, 128, 77, 67, 62, 51, 55, 30, 68, 79, 66)))))) AND ("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" LIMIT 8;

Date: 2026-07-08 23:04:27 Duration: 4s300ms

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

100,951 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	25	0.02%
DETAIL	104	0.10%
ERROR	3,249	3.22%
EVENTLOG	1,913	1.89%
FATAL	2,907	2.88%
HINT	7	0.01%
LOG	89,138	88.30%
STATEMENT	3,608	3.57%

Events distribution (except queries)

Key values

0 PANIC entries
2907 FATAL entries
3249 ERROR entries
0 WARNING entries
1913 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,578 Max number of times the same event was reported
8,069 Total events found

Rank

Times reported

Error

1

2,578

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jul 08	02	109
	03	105
	04	112
	05	109
	06	109
	07	106
	08	105
	09	106
	10	110
	11	109
	12	111
	13	111
	14	111
	15	110
	16	110
	17	111
	18	110
	19	111
	20	101
	21	109
	22	108
	23	107
Jul 09	00	109
	01	79

ERROR: column res_partner.x_precentage_office does not exist at character 2190
ERROR: column res_partner.x_precentage_office does not exist at character 2190
ERROR: column res_partner.x_precentage_office does not exist at character 2190

2

1,897

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jul 08	02	389
	03	341
	04	144
	05	153
	06	143
	07	370
	08	140
	09	125
	20	86
	21	1
	22	1
	23	3
Jul 09	01	1

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

3

1,893

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jul 08	02	389
	03	340
	04	144
	05	153
	06	143
	07	370
	08	139
	09	125
	20	85
	21	1
	22	1
	23	3

FATAL: connection to client lost
FATAL: connection to client lost
FATAL: connection to client lost

4

893

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jul 08	03	4
	05	66
	08	267
	09	473
	11	15
	14	14
	17	23
	20	16
	23	9
Jul 09	01	6

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

5

449

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jul 08	02	20
	03	16
	04	15
	05	12
	06	24
	07	16
	08	7
	09	15
	10	14
	11	11
	12	15
	13	33
	14	27
	15	31
	16	4
	17	1
	18	2
	19	1
	20	151
	21	14
	22	6
	23	6
Jul 09	00	3
	01	5

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

6

103

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jul 08	03	5
	08	9
	09	72
	20	9
	23	3
Jul 09	01	5

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

7

99

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jul 08	05	2
	09	6
	10	23
	11	15
	12	5
	13	4
	14	2
	15	8
	16	5
	17	20
	18	1
	19	5
	20	2
	21	1

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

8

91

Details

ERROR: could not create unique index "..."

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jul 08	20	91

ERROR: could not create unique index "urgent_customer_customer_phone_name"
ERROR: could not create unique index "urgent_customer_customer_phone_name"
ERROR: could not create unique index "urgent_customer_customer_phone_name"

9

18

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jul 08	05	2
	08	3
	09	3
	11	2
	14	2
	17	2
	20	2
	23	2

FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down

10

16

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jul 08	02	1
	03	1
	05	1
	08	3
	09	3
	11	1
	14	1
	17	1
	20	2
	23	1
Jul 09	01	1

LOG: database system was shut down at 2026-07-08 02:00:07 CEST
LOG: database system was shut down at 2026-07-08 03:20:02 CEST
LOG: database system was shut down at 2026-07-08 05:00:07 CEST

11

15

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jul 08	08	1
	09	14

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

12

7

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jul 08	20	7

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

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jul 08	11	1
	14	1
	23	3
Jul 09	01	1

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

14

3

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jul 08	11	3

ERROR: invalid input syntax for type integer: "s" at character 6887
ERROR: invalid input syntax for type integer: "s" at character 6887
ERROR: invalid input syntax for type integer: "s" at character 6887

15

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jul 08	09	1

ERROR: relation "pg_stat_statements" does not exist at character 244

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

Vacuum throughput per table

Key values

CPU elapsed per tables

Tuples removed per table

Key values

Tuples removed per tables