pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Aug 28 23:45:03 2026
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 13,251 log entries in 2s
Log start from 2026-08-28 02:00:10 to 2026-08-29 01:44:44

Global Stats

116 Number of unique normalized queries
693 Number of queries
1h37m38s Total query duration
2026-08-28 02:01:46 First query
2026-08-29 01:37:41 Last query
3 queries/s at 2026-08-28 22:17:55 Query peak

1h37m38s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
1h37m38s Execute total duration

2,756 Number of events
12 Number of unique normalized events
2,559 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
693 Average queries per session
1h37m38s 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

3 queries/s Query Peak
2026-08-28 22:17:55 Date

SELECT Traffic

Key values

3 queries/s Query Peak
2026-08-28 22:17:55 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-08-28 08:44:44 Date

Queries duration

Key values

1h37m38s 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)
Aug 28	02	6	0ms	9s674ms	5s932ms	0ms	3s310ms	17s949ms
	03	1	0ms	3s636ms	3s636ms	0ms	0ms	3s636ms
	04	1	0ms	5s862ms	5s862ms	0ms	0ms	5s862ms
	05	0	0ms	0ms	0ms	0ms	0ms	0ms
	06	0	0ms	0ms	0ms	0ms	0ms	0ms
	07	2	0ms	6s348ms	6s26ms	0ms	0ms	12s52ms
	08	35	0ms	13m16s	1m11s	1m33s	5m15s	13m19s
	09	67	0ms	8s35ms	6s722ms	55s567ms	58s414ms	1m7s
	10	78	0ms	14s643ms	6s513ms	56s369ms	1m3s	1m7s
	11	24	0ms	10s679ms	3s823ms	6s997ms	10s399ms	13s166ms
	12	10	0ms	4s734ms	3s598ms	0ms	3s801ms	18s399ms
	13	81	0ms	10s723ms	3s546ms	18s847ms	21s920ms	29s854ms
	14	31	0ms	12s217ms	6s510ms	11s934ms	16s122ms	28s405ms
	15	33	0ms	13s172ms	4s767ms	6s845ms	17s242ms	26s137ms
	16	26	0ms	9s911ms	4s585ms	6s94ms	17s594ms	49s268ms
	17	39	0ms	9s804ms	4s661ms	11s628ms	19s476ms	40s217ms
	18	52	0ms	9s622ms	3s714ms	9s186ms	15s460ms	34s706ms
	19	59	0ms	9s520ms	3s719ms	14s333ms	25s784ms	28s660ms
	20	46	0ms	9s954ms	5s34ms	7s327ms	12s579ms	1m47s
	21	34	0ms	9s526ms	5s72ms	12s570ms	12s879ms	21s249ms
	22	22	0ms	13s309ms	6s71ms	6s210ms	11s985ms	47s915ms
	23	24	0ms	31s410ms	10s377ms	19s486ms	34s569ms	1m10s
Aug 29	00	8	0ms	5s519ms	3s544ms	3s143ms	3s482ms	5s519ms
	01	14	0ms	3s837ms	3s474ms	3s662ms	3s706ms	14s495ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 28	02	6	0	5s932ms	0ms	0ms	14s337ms
	03	1	0	3s636ms	0ms	0ms	0ms
	04	1	0	5s862ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	2	0	6s26ms	0ms	0ms	0ms
	08	4	31	1m11s	49s39ms	1m33s	6m12s
	09	67	0	6s722ms	3s365ms	55s567ms	1m
	10	78	0	6s513ms	8s463ms	56s369ms	1m3s
	11	24	0	3s823ms	3s601ms	6s997ms	10s679ms
	12	10	0	3s598ms	0ms	0ms	10s384ms
	13	81	0	3s546ms	12s980ms	18s847ms	22s208ms
	14	31	0	6s510ms	7s130ms	11s934ms	22s845ms
	15	33	0	4s767ms	4s481ms	6s845ms	19s625ms
	16	26	0	4s585ms	0ms	6s94ms	18s775ms
	17	34	0	4s469ms	3s421ms	9s435ms	20s329ms
	18	52	0	3s714ms	6s236ms	9s186ms	21s735ms
	19	59	0	3s719ms	6s175ms	14s333ms	26s125ms
	20	45	0	4s983ms	4s548ms	6s970ms	22s719ms
	21	34	0	5s72ms	6s548ms	12s570ms	15s578ms
	22	22	0	6s71ms	0ms	6s210ms	38s598ms
	23	16	0	5s54ms	0ms	3s369ms	19s486ms
Aug 29	00	8	0	3s544ms	0ms	3s143ms	3s740ms
	01	14	0	3s474ms	3s29ms	3s662ms	14s495ms

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 28	02	0	0	0	0ms	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	0	0	0ms	0ms	0ms	0ms
	09	0	0	0	0ms	0ms	0ms	0ms
	10	0	0	0	0ms	0ms	0ms	0ms
	11	0	0	0	0ms	0ms	0ms	0ms
	12	0	0	0	0ms	0ms	0ms	0ms
	13	0	0	0	0ms	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	5	5s965ms	0ms	0ms	0ms
	18	0	0	0	0ms	0ms	0ms	0ms
	19	0	0	0	0ms	0ms	0ms	0ms
	20	0	1	0	7s327ms	0ms	0ms	0ms
	21	0	0	0	0ms	0ms	0ms	0ms
	22	0	0	0	0ms	0ms	0ms	0ms
	23	8	0	0	21s22ms	0ms	0ms	26s828ms
Aug 29	00	0	0	0	0ms	0ms	0ms	0ms
	01	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Percentage of prepare
Aug 28	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%
Aug 29	00	0.00%
	01	0.00%

Day	Hour	Average / Second
Aug 28	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
Aug 29	00	0.00/s
	01	0.00/s

Day	Hour	Average Duration	Average idle time
Aug 28	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
Aug 29	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

28,749 buffers Checkpoint Peak
2026-08-28 10:44:39 Date
270.062 seconds Highest write time
0.021 seconds Sync time

Checkpoints Wal files

Key values

10 files Wal files usage Peak
2026-08-28 02:24:41 Date

Checkpoints distance

Key values

306.87 Mo Distance Peak
2026-08-28 23:54:41 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Aug 28	02	76,719	2,870.58s	0.023s	2,870.646s
	03	80,296	3,234.52s	0.031s	3,234.605s
	04	66,360	3,139.507s	0.035s	3,139.581s
	05	78,984	2,969.648s	0.033s	2,969.721s
	06	34,046	2,821.665s	0.025s	2,821.723s
	07	18,438	1,242.176s	0.031s	1,242.24s
	08	57,152	2,507.45s	0.047s	2,507.545s
	09	104,202	3,239.474s	0.034s	3,239.554s
	10	144,275	3,239.638s	0.04s	3,239.723s
	11	120,568	2,969.329s	0.043s	2,969.412s
	12	88,763	3,226.551s	0.028s	3,226.614s
	13	108,287	3,239.548s	0.029s	3,239.616s
	14	104,071	2,970.016s	0.046s	2,970.106s
	15	114,174	3,239.613s	0.039s	3,239.695s
	16	99,721	3,239.566s	0.036s	3,239.64s
	17	116,160	2,969.292s	0.051s	2,969.384s
	18	165,588	3,239.536s	0.047s	3,239.63s
	19	154,792	3,239.531s	0.034s	3,239.617s
	20	119,782	2,969.818s	0.054s	2,969.914s
	21	109,928	3,239.544s	0.032s	3,239.622s
	22	95,445	3,223.569s	0.036s	3,223.646s
	23	88,182	2,842.519s	0.046s	2,842.603s
Aug 29	00	47,712	2,961.567s	0.03s	2,961.641s
	01	42,001	2,183.492s	0.025s	2,183.547s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Aug 28	02	33	2,378	0.002s	0.011s
	03	35	2,759	0.002s	0.012s
	04	22	2,532	0.008s	0.012s
	05	36	2,221	0.005s	0.012s
	06	14	1,827	0.001s	0.012s
	07	8	1,458	0.003s	0.011s
	08	21	2,629	0.005s	0.013s
	09	46	3,229	0.002s	0.012s
	10	53	3,608	0.002s	0.012s
	11	53	3,264	0.011s	0.012s
	12	40	3,118	0.002s	0.012s
	13	39	3,789	0.002s	0.012s
	14	35	3,569	0.013s	0.012s
	15	48	3,961	0.002s	0.012s
	16	42	4,061	0.002s	0.012s
	17	46	4,116	0.014s	0.012s
	18	65	4,419	0.003s	0.012s
	19	67	4,449	0.002s	0.012s
	20	52	3,968	0.007s	0.012s
	21	47	3,805	0.002s	0.012s
	22	40	3,500	0.002s	0.012s
	23	38	3,480	0.009s	0.012s
Aug 29	00	20	2,962	0.002s	0.012s
	01	17	2,497	0.003s	0.009s

Day	Hour	Avg time (sec)
Aug 28	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
Aug 29	00	0s
	01	0s

Day	Hour	Mean distance	Mean estimate
Aug 28	02	49,211.55 kB	103,391.36 kB
	03	47,373.42 kB	81,792.42 kB
	04	30,726.00 kB	59,177.83 kB
	05	48,668.50 kB	66,045.92 kB
	06	19,895.75 kB	41,900.08 kB
	07	10,877.73 kB	25,683.91 kB
	08	26,668.77 kB	42,214.54 kB
	09	62,455.67 kB	79,900.33 kB
	10	73,528.25 kB	87,121.92 kB
	11	72,107.42 kB	86,650.50 kB
	12	54,767.50 kB	73,534.92 kB
	13	52,421.83 kB	72,404.00 kB
	14	47,527.75 kB	64,178.33 kB
	15	66,095.25 kB	86,777.42 kB
	16	56,680.08 kB	78,180.33 kB
	17	63,823.75 kB	93,859.58 kB
	18	88,284.42 kB	110,275.50 kB
	19	91,712.92 kB	126,130.08 kB
	20	70,205.00 kB	85,777.75 kB
	21	64,162.92 kB	95,504.50 kB
	22	55,490.00 kB	78,104.83 kB
	23	51,601.42 kB	94,935.67 kB
Aug 29	00	27,423.50 kB	92,126.58 kB
	01	31,032.44 kB	67,166.33 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (276) Main checkpoint cause
284 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	276
shutdown immediate	8
Total	284

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
Aug 28	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
Aug 29	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
Aug 28	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
Aug 29	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

648 Total read queries
45 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	648	93.51%
INSERT	8	1.15%
UPDATE	1	0.14%
DELETE	5	0.72%
COPY FROM	0	0.00%
COPY TO	31	4.47%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

unknown Main database
693 Requests
1h37m38s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	693	1h37m38s
	copy to	31	41m8s
	delete	5	29s827ms
	insert	8	2m48s
	select	648	53m4s
	update	1	7s327ms

Queries by user

Key values

unknown Main user
693 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	693	1h37m38s
	copy to	31	41m8s
	delete	5	29s827ms
	insert	8	2m48s
	select	648	53m4s
	update	1	7s327ms

Duration by user

Key values

1h37m38s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	693	1h37m38s
	copy to	31	41m8s
	delete	5	29s827ms
	insert	8	2m48s
	select	648	53m4s
	update	1	7s327ms

Queries by host

Key values

unknown Main host
693 Requests
1h37m38s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	693	1h37m38s
	copy to	31	41m8s
	delete	5	29s827ms
	insert	8	2m48s
	select	648	53m4s
	update	1	7s327ms

Queries by application

Key values

unknown Main application
693 Requests
1h37m38s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	693	1h37m38s
	copy to	31	41m8s
	delete	5	29s827ms
	insert	8	2m48s
	select	648	53m4s
	update	1	7s327ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-08-29 00:29:41 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

649 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	649	93.65%
> 10000ms	44	6.35%

Slowest individual queries

Rank	Duration	Query
1	13m16s	COPY public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) TO stdout; [ Date: 2026-08-28 08:25:29 ]
2	6m12s	COPY public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) TO stdout; [ Date: 2026-08-28 08:31:45 ]
3	5m15s	COPY public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) TO stdout; [ Date: 2026-08-28 08:43:39 ]
4	4m2s	COPY public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) TO stdout; [ Date: 2026-08-28 08:37:32 ]
5	3m9s	COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout; [ Date: 2026-08-28 08:06:17 ]
6	1m5s	COPY public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) TO stdout; [ Date: 2026-08-28 08:09:23 ]
7	1m2s	COPY public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) TO stdout; [ Date: 2026-08-28 08:07:20 ]
8	50s571ms	COPY public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) TO stdout; [ Date: 2026-08-28 08:08:17 ]
9	49s936ms	COPY public.policy_number (id, notebook_id, office_id, delegate_id, package_id, create_uid, write_uid, name, reason, damaged, done, active, create_date, write_date, reason_date, from_poilcy, deliver_date, note, message_main_attachment_id) TO stdout; [ Date: 2026-08-28 08:32:38 ]
10	44s285ms	COPY public.shipping_policy_items (id, product_id, shipping_policy_id, amount, create_uid, write_uid, desc_name, change_reason, paid, create_date, write_date, shipping_cost, shipping_cost_basic, total_shipping_cost) TO stdout; [ Date: 2026-08-28 08:38:18 ]
11	39s83ms	COPY public.mail_followers (id, res_id, partner_id, res_model) TO stdout; [ Date: 2026-08-28 08:11:29 ]
12	35s585ms	COPY public.urgent_customer (id, message_main_attachment_id, create_uid, write_uid, name, phone, code, address, active, create_date, write_date, v_10_id, receive_man_id_no, is_company, user_id) TO stdout; [ Date: 2026-08-28 08:44:15 ]
13	35s520ms	COPY public.collection_policy (id, office_id, user_id, shipping_id, customer_id, create_uid, write_uid, type, state, action_date, confirm_date, create_date, write_date, amount, sale_model, active, differance_cash, is_sale, sale_model_policy, is_sale_policy) TO stdout; [ Date: 2026-08-28 08:10:28 ]
14	31s410ms	INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING; [ Date: 2026-08-28 23:45:02 ]
15	29s633ms	COPY public.policy_search (id, create_uid, write_uid, name, model, model_char, search_domain, missing_data, create_date, write_date, type, count_search, filter_name, active_p, is_inventory) TO stdout; [ Date: 2026-08-28 08:33:10 ]
16	29s353ms	COPY public.mail_mail (id, mail_message_id, fetchmail_server_id, create_uid, write_uid, email_cc, state, failure_type, body_html, "references", headers, email_to, failure_reason, is_notification, auto_delete, to_delete, scheduled_date, create_date, write_date) TO stdout; [ Date: 2026-08-28 08:12:12 ]
17	26s900ms	INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING; [ Date: 2026-08-28 23:46:44 ]
18	26s828ms	INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING; [ Date: 2026-08-28 23:48:26 ]
19	26s394ms	INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING; [ Date: 2026-08-28 23:45:52 ]
20	26s367ms	INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING; [ Date: 2026-08-28 23:47:36 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

14m10s

120

Details

6s724ms

8s630ms

7s91ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	09	59	6m59s	7s110ms
	10	61	7m11s	7s71ms

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 (23299512, 23248822, 23461788, 23531046, 23222972, 23361488, 23492234, 23495804, 23519791, 23558587, 23532168, 23456099, 23557928, 23554985, 23404832, 23525970, 23528604, 23519686, 23468619, 22756755, 23553390, 22968680, 23557994, 23521471, 23556264, 23485455, 23105353, 23414589, 23494190, 23488669, 23441116, 23435326, 23346772, 23427452, 23467781, 23510874, 23523384, 23518922, 23060670, 23568563, 23568843, 23568987, 23451498, 23192985, 23172586, 23299228, 23522347, 23501287, 23103965, 23518912, 23553708, 23494728, 23537565, 23519605, 23488235, 23524782, 23496441, 23416704, 23464257, 23333925, 23536435, 23197718, 23516748, 23535809, 23050109, 23500606, 23440318, 23283849, 23576394, 23536498, 23429978, 23524589, 23271928, 23333004, 23442121, 23490564, 23046669, 23071766, 23418428, 23469229);

Date: 2026-08-28 10:36:08 Duration: 8s630ms
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 (23511376, 23548145, 23489104, 23529734, 23550065, 23511372, 23551086, 23530399, 23522555, 23422294, 23468191, 23434681, 23488614, 23532814, 23523649, 23414798, 23548186, 23115517, 23545180, 23341969, 23520657, 23518230);

Date: 2026-08-28 09:52:28 Duration: 8s35ms
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 (23489148, 23520999, 23519417, 23520983, 23258763, 23526485, 23488440, 23085864, 23515577, 23467024, 23473254, 23518280);

Date: 2026-08-28 09:58:06 Duration: 7s840ms

2

13m16s

1

Details

13m16s

copy public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) to stdout;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	13m16s	13m16s

COPY public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) TO stdout;

Date: 2026-08-28 08:25:29 Duration: 13m16s

3

7m16s

136

Details

3s2ms

5s96ms

3s208ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	10	6	19s843ms	3s307ms
	11	3	9s801ms	3s267ms
	13	3	9s295ms	3s98ms
	14	1	3s66ms	3s66ms
	15	3	9s578ms	3s192ms
	16	12	37s990ms	3s165ms
	17	6	20s615ms	3s435ms
	18	26	1m20s	3s101ms
	19	34	1m50s	3s252ms
	20	21	1m7s	3s194ms
	21	6	18s718ms	3s119ms
	22	7	22s811ms	3s258ms
	23	7	23s156ms	3s308ms
Aug 29	00	1	3s187ms	3s187ms

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

Date: 2026-08-28 19:04:18 Duration: 5s96ms
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 (55))))))) 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 (55)))))) 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 (55)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (55)))))) 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 (55))))))))) 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 (55)))))))) AND ("policy_number"."name"::text ilike '%0%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 17:50:25 Duration: 4s978ms
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 (7))))))) 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 (7)))))) 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)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) 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 (7))))))))) 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 (7)))))))) AND ("policy_number"."name"::text ilike '%1445823%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 10:35:49 Duration: 3s688ms

4

6m12s

1

Details

6m12s

copy public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) to stdout;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	6m12s	6m12s

COPY public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) TO stdout;

Date: 2026-08-28 08:31:45 Duration: 6m12s

5

5m41s

42

Details

4s912ms

10s679ms

8s119ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	11	1	10s679ms	10s679ms
	16	8	55s924ms	6s990ms
	17	9	1m1s	6s807ms
	19	3	18s922ms	6s307ms
	20	11	1m42s	9s317ms
	21	9	1m22s	9s178ms
	22	1	9s130ms	9s130ms

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

Date: 2026-08-28 11:06:07 Duration: 10s679ms
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 (79)))))) 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 '%1387%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 20:10:11 Duration: 9s954ms
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 '%1406241%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 16:21:01 Duration: 9s911ms

6

5m15s

1

Details

5m15s

copy public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) to stdout;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	5m15s	5m15s

COPY public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) TO stdout;

Date: 2026-08-28 08:43:39 Duration: 5m15s

7

4m2s

1

Details

4m2s

copy public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) to stdout;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	4m2s	4m2s

COPY public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) TO stdout;

Date: 2026-08-28 08:37:32 Duration: 4m2s

8

3m26s

28

Details

4s939ms

9s907ms

7s378ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	02	3	23s501ms	7s833ms
	15	2	15s900ms	7s950ms
	18	5	38s961ms	7s792ms
	19	1	9s254ms	9s254ms
	21	2	14s691ms	7s345ms
	22	8	53s837ms	6s729ms
	23	7	50s446ms	7s206ms

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

Date: 2026-08-28 15:42:27 Duration: 9s907ms
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 (8)))))) 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 '%1358996%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 23:06:04 Duration: 9s759ms
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 (8)))))) 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 '%13589%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 23:06:03 Duration: 9s727ms

9

3m9s

1

Details

3m9s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	3m9s	3m9s

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

Date: 2026-08-28 08:06:17 Duration: 3m9s

10

2m40s

47

Details

3s

5s389ms

3s409ms

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
Aug 28	11	4	13s632ms	3s408ms
	12	3	11s504ms	3s834ms
	13	38	2m8s	3s390ms
	20	2	6s277ms	3s138ms

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

Date: 2026-08-28 13:15:28 Duration: 5s389ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) AND ("policy_number"."name"::text ilike '%5%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 13:24:36 Duration: 4s962ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) AND ("policy_number"."name"::text ilike '%5%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 13:18:41 Duration: 4s786ms

11

2m25s

13

Details

3s713ms

14s643ms

11s205ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" not in (...)) 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))))) order by "shipping_policy"."policy_id" limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Aug 28	10	1	14s643ms	14s643ms
	14	10	1m55s	11s532ms
	22	2	15s698ms	7s849ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (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, 144, 145, 146, 147)))) 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))))) ORDER BY "shipping_policy"."policy_id" LIMIT 100;

Date: 2026-08-28 10:31:05 Duration: 14s643ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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"."policy_id" LIMIT 100;

Date: 2026-08-28 14:42:24 Duration: 12s217ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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"."policy_id" LIMIT 100;

Date: 2026-08-28 14:55:17 Duration: 12s118ms

12

2m17s

5

Details

26s367ms

31s410ms

27s580ms

insert into policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) values (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) on conflict do nothing;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Aug 28	23	5	2m17s	27s580ms

INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:45:02 Duration: 31s410ms
INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:46:44 Duration: 26s900ms
INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:48:26 Duration: 26s828ms

13

1m31s

23

Details

3s143ms

6s917ms

3s978ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	11	1	5s43ms	5s43ms
	16	3	10s938ms	3s646ms
	17	3	11s266ms	3s755ms
	19	1	3s429ms	3s429ms
	20	6	30s297ms	5s49ms
	21	8	27s195ms	3s399ms
	22	1	3s335ms	3s335ms

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 (79)))))) 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-08-28 20:10:05 Duration: 6s917ms
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 (79)))))) 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-08-28 20:10:23 Duration: 5s598ms
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 (79)))))) 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-08-28 20:10:20 Duration: 5s342ms

14

1m5s

1

Details

1m5s

copy public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) to stdout;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	1m5s	1m5s

COPY public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) TO stdout;

Date: 2026-08-28 08:09:23 Duration: 1m5s

15

1m3s

19

Details

3s93ms

3s763ms

3s325ms

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 (...))))))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Aug 28	11	2	7s365ms	3s682ms
	12	1	3s263ms	3s263ms
	13	16	52s552ms	3s284ms

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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 11:49:05 Duration: 3s763ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 13:24:34 Duration: 3s738ms
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))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 11:47:56 Duration: 3s601ms

16

1m2s

1

Details

1m2s

copy public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) to stdout;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	1m2s	1m2s

COPY public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) TO stdout;

Date: 2026-08-28 08:07:20 Duration: 1m2s

17

1m

16

Details

3s85ms

5s522ms

3s779ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	09	1	5s522ms	5s522ms
	11	2	7s530ms	3s765ms
	14	1	4s159ms	4s159ms
	15	1	4s523ms	4s523ms
	16	1	3s950ms	3s950ms
	19	1	3s773ms	3s773ms
	21	4	12s629ms	3s157ms
Aug 29	01	5	18s374ms	3s674ms

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 (27)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-08-28 09:29:10 Duration: 5s522ms
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-08-28 15:45:28 Duration: 4s523ms
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 (19)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-08-28 11:39:36 Duration: 4s165ms

18

53s266ms

15

Details

3s57ms

4s993ms

3s551ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Aug 28	10	1	4s993ms	4s993ms
	11	2	6s261ms	3s130ms
	13	9	30s432ms	3s381ms
	14	2	8s77ms	4s38ms
	20	1	3s501ms	3s501ms

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

Date: 2026-08-28 10:37:55 Duration: 4s993ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id" LIMIT 200;

Date: 2026-08-28 14:07:40 Duration: 4s171ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id" LIMIT 200;

Date: 2026-08-28 14:42:03 Duration: 3s905ms

19

51s526ms

13

Details

3s17ms

6s348ms

3s963ms

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
Aug 28	07	2	12s52ms	6s26ms
	08	1	6s60ms	6s60ms
Aug 29	00	5	17s947ms	3s589ms
	01	5	15s466ms	3s93ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '8487765') AND ("bus_bus"."channel" in ('["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",19802]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",19692]', '["urg16","mail.channel",19518]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",19460]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19600]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",19868]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",20243]', '["urg16","broadcast"]', '["urg16","mail.channel",20240]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",20069]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","res.partner",8007532]', '["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",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",17377]'))) ORDER BY "bus_bus"."id";

Date: 2026-08-28 07:22:23 Duration: 6s348ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '8487765') AND ("bus_bus"."channel" in ('["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",19802]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19692]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",19460]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19518]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",19600]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",18413]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",19868]', '["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",20240]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",20243]', '["urg16","mail.channel",20069]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19416]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","broadcast"]', '["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",15199]', '["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-08-28 08:00:29 Duration: 6s60ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '22791761') AND ("bus_bus"."channel" in ('["urg16","mail.channel",16959]', '["urg16","mail.channel",18582]', '["urg16","mail.channel",20095]', '["urg16","mail.channel",18847]', '["urg16","mail.channel",16223]', '["urg16","mail.channel",273]', '["urg16","mail.channel",15658]', '["urg16","mail.channel",13388]', '["urg16","mail.channel",17418]', '["urg16","mail.channel",19523]', '["urg16","mail.channel",13052]', '["urg16","mail.channel",20252]', '["urg16","mail.channel",15996]', '["urg16","mail.channel",16179]', '["urg16","mail.channel",15523]', '["urg16","mail.channel",14986]', '["urg16","mail.channel",13317]', '["urg16","mail.channel",14403]', '["urg16","mail.channel",15907]', '["urg16","mail.channel",19690]', '["urg16","mail.channel",13637]', '["urg16","mail.channel",20019]', '["urg16","mail.channel",17029]', '["urg16","mail.channel",19918]', '["urg16","mail.channel",15189]', '["urg16","mail.channel",16995]', '["urg16","mail.channel",15927]', '["urg16","mail.channel",13541]', '["urg16","mail.channel",20094]', '["urg16","broadcast"]', '["urg16","mail.channel",15813]', '["urg16","mail.channel",16862]', '["urg16","mail.channel",18192]', '["urg16","mail.channel",19824]', '["urg16","mail.channel",20327]', '["urg16","mail.channel",18002]', '["urg16","mail.channel",14887]', '["urg16","mail.channel",14231]', '["urg16","mail.channel",18322]', '["urg16","mail.channel",16226]', '["urg16","mail.channel",18642]', '["urg16","mail.channel",16674]', '["urg16","mail.channel",18953]', '["urg16","mail.channel",14459]', '["urg16","mail.channel",16018]', '["urg16","mail.channel",17586]', '["urg16","mail.channel",16875]', '["urg16","mail.channel",16820]', '["urg16","mail.channel",19227]', '["urg16","mail.channel",20304]', '["urg16","mail.channel",19657]', '["urg16","mail.channel",18217]', '["urg16","mail.channel",20322]', '["urg16","mail.channel",14745]', '["urg16","mail.channel",17634]', '["urg16","mail.channel",18994]', '["urg16","mail.channel",15940]', '["urg16","mail.channel",20324]', '["urg16","mail.channel",17990]', '["urg16","mail.channel",15302]', '["urg16","mail.channel",19915]', '["urg16","mail.channel",19140]', '["urg16","mail.channel",16315]', '["urg16","mail.channel",14283]', '["urg16","mail.channel",17108]', '["urg16","mail.channel",13453]', '["urg16","mail.channel",20244]', '["urg16","mail.channel",17910]', '["urg16","mail.channel",19478]', '["urg16","mail.channel",19069]', '["urg16","mail.channel",16973]', '["urg16","mail.channel",15652]', '["urg16","mail.channel",19807]', '["urg16","mail.channel",19325]', '["urg16","res.partner",8006343]', '["urg16","mail.channel",14413]', '["urg16","mail.channel",19709]', '["urg16","mail.channel",20255]', '["urg16","mail.channel",18397]', '["urg16","mail.channel",13421]', '["urg16","mail.channel",16966]', '["urg16","mail.channel",18525]', '["urg16","mail.channel",15663]', '["urg16","mail.channel",19501]', '["urg16","mail.channel",15617]', '["urg16","mail.channel",16703]', '["urg16","mail.channel",15336]'))) ORDER BY "bus_bus"."id";

Date: 2026-08-28 07:22:22 Duration: 5s703ms

20

50s571ms

1

Details

50s571ms

copy public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) to stdout;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	50s571ms	50s571ms

COPY public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) TO stdout;

Date: 2026-08-28 08:08:17 Duration: 50s571ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

136

Details

7m16s

3s2ms

5s96ms

3s208ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	10	6	19s843ms	3s307ms
	11	3	9s801ms	3s267ms
	13	3	9s295ms	3s98ms
	14	1	3s66ms	3s66ms
	15	3	9s578ms	3s192ms
	16	12	37s990ms	3s165ms
	17	6	20s615ms	3s435ms
	18	26	1m20s	3s101ms
	19	34	1m50s	3s252ms
	20	21	1m7s	3s194ms
	21	6	18s718ms	3s119ms
	22	7	22s811ms	3s258ms
	23	7	23s156ms	3s308ms
Aug 29	00	1	3s187ms	3s187ms

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

Date: 2026-08-28 19:04:18 Duration: 5s96ms
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 (55))))))) 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 (55)))))) 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 (55)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (55)))))) 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 (55))))))))) 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 (55)))))))) AND ("policy_number"."name"::text ilike '%0%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 17:50:25 Duration: 4s978ms
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 (7))))))) 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 (7)))))) 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)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) 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 (7))))))))) 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 (7)))))))) AND ("policy_number"."name"::text ilike '%1445823%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 10:35:49 Duration: 3s688ms

2

120

Details

14m10s

6s724ms

8s630ms

7s91ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	09	59	6m59s	7s110ms
	10	61	7m11s	7s71ms

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 (23299512, 23248822, 23461788, 23531046, 23222972, 23361488, 23492234, 23495804, 23519791, 23558587, 23532168, 23456099, 23557928, 23554985, 23404832, 23525970, 23528604, 23519686, 23468619, 22756755, 23553390, 22968680, 23557994, 23521471, 23556264, 23485455, 23105353, 23414589, 23494190, 23488669, 23441116, 23435326, 23346772, 23427452, 23467781, 23510874, 23523384, 23518922, 23060670, 23568563, 23568843, 23568987, 23451498, 23192985, 23172586, 23299228, 23522347, 23501287, 23103965, 23518912, 23553708, 23494728, 23537565, 23519605, 23488235, 23524782, 23496441, 23416704, 23464257, 23333925, 23536435, 23197718, 23516748, 23535809, 23050109, 23500606, 23440318, 23283849, 23576394, 23536498, 23429978, 23524589, 23271928, 23333004, 23442121, 23490564, 23046669, 23071766, 23418428, 23469229);

Date: 2026-08-28 10:36:08 Duration: 8s630ms
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 (23511376, 23548145, 23489104, 23529734, 23550065, 23511372, 23551086, 23530399, 23522555, 23422294, 23468191, 23434681, 23488614, 23532814, 23523649, 23414798, 23548186, 23115517, 23545180, 23341969, 23520657, 23518230);

Date: 2026-08-28 09:52:28 Duration: 8s35ms
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 (23489148, 23520999, 23519417, 23520983, 23258763, 23526485, 23488440, 23085864, 23515577, 23467024, 23473254, 23518280);

Date: 2026-08-28 09:58:06 Duration: 7s840ms

3

47

Details

2m40s

3s

5s389ms

3s409ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	11	4	13s632ms	3s408ms
	12	3	11s504ms	3s834ms
	13	38	2m8s	3s390ms
	20	2	6s277ms	3s138ms

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

Date: 2026-08-28 13:15:28 Duration: 5s389ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) AND ("policy_number"."name"::text ilike '%5%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 13:24:36 Duration: 4s962ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) AND ("policy_number"."name"::text ilike '%5%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 13:18:41 Duration: 4s786ms

4

42

Details

5m41s

4s912ms

10s679ms

8s119ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	11	1	10s679ms	10s679ms
	16	8	55s924ms	6s990ms
	17	9	1m1s	6s807ms
	19	3	18s922ms	6s307ms
	20	11	1m42s	9s317ms
	21	9	1m22s	9s178ms
	22	1	9s130ms	9s130ms

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

Date: 2026-08-28 11:06:07 Duration: 10s679ms
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 (79)))))) 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 '%1387%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 20:10:11 Duration: 9s954ms
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 '%1406241%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 16:21:01 Duration: 9s911ms

5

28

Details

3m26s

4s939ms

9s907ms

7s378ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	02	3	23s501ms	7s833ms
	15	2	15s900ms	7s950ms
	18	5	38s961ms	7s792ms
	19	1	9s254ms	9s254ms
	21	2	14s691ms	7s345ms
	22	8	53s837ms	6s729ms
	23	7	50s446ms	7s206ms

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

Date: 2026-08-28 15:42:27 Duration: 9s907ms
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 (8)))))) 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 '%1358996%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 23:06:04 Duration: 9s759ms
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 (8)))))) 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 '%13589%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 23:06:03 Duration: 9s727ms

6

23

Details

1m31s

3s143ms

6s917ms

3s978ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	11	1	5s43ms	5s43ms
	16	3	10s938ms	3s646ms
	17	3	11s266ms	3s755ms
	19	1	3s429ms	3s429ms
	20	6	30s297ms	5s49ms
	21	8	27s195ms	3s399ms
	22	1	3s335ms	3s335ms

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 (79)))))) 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-08-28 20:10:05 Duration: 6s917ms
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 (79)))))) 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-08-28 20:10:23 Duration: 5s598ms
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 (79)))))) 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-08-28 20:10:20 Duration: 5s342ms

7

19

Details

1m3s

3s93ms

3s763ms

3s325ms

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 (...))))))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Aug 28	11	2	7s365ms	3s682ms
	12	1	3s263ms	3s263ms
	13	16	52s552ms	3s284ms

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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 11:49:05 Duration: 3s763ms
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 (19))))))) 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 (19)))))) 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 (19)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) 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 (19))))))))) 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 (19))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 13:24:34 Duration: 3s738ms
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))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 11:47:56 Duration: 3s601ms

8

16

Details

1m

3s85ms

5s522ms

3s779ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	09	1	5s522ms	5s522ms
	11	2	7s530ms	3s765ms
	14	1	4s159ms	4s159ms
	15	1	4s523ms	4s523ms
	16	1	3s950ms	3s950ms
	19	1	3s773ms	3s773ms
	21	4	12s629ms	3s157ms
Aug 29	01	5	18s374ms	3s674ms

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 (27)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-08-28 09:29:10 Duration: 5s522ms
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-08-28 15:45:28 Duration: 4s523ms
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 (19)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-08-28 11:39:36 Duration: 4s165ms

9

15

Details

53s266ms

3s57ms

4s993ms

3s551ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Aug 28	10	1	4s993ms	4s993ms
	11	2	6s261ms	3s130ms
	13	9	30s432ms	3s381ms
	14	2	8s77ms	4s38ms
	20	1	3s501ms	3s501ms

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

Date: 2026-08-28 10:37:55 Duration: 4s993ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id" LIMIT 200;

Date: 2026-08-28 14:07:40 Duration: 4s171ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id" LIMIT 200;

Date: 2026-08-28 14:42:03 Duration: 3s905ms

10

14

Details

49s918ms

3s115ms

4s14ms

3s565ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) 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 #10

Day	Hour	Count	Duration	Avg duration
Aug 28	10	1	3s469ms	3s469ms
	11	3	10s866ms	3s622ms
	14	6	21s396ms	3s566ms
	15	1	3s406ms	3s406ms
	17	3	10s779ms	3s593ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (99)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) 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-08-28 14:44:53 Duration: 4s14ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (99)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) 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-08-28 14:33:27 Duration: 3s773ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) 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-08-28 11:08:26 Duration: 3s770ms

11

13

Details

2m25s

3s713ms

14s643ms

11s205ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" not in (...)) 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))))) order by "shipping_policy"."policy_id" limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Aug 28	10	1	14s643ms	14s643ms
	14	10	1m55s	11s532ms
	22	2	15s698ms	7s849ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (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, 144, 145, 146, 147)))) 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))))) ORDER BY "shipping_policy"."policy_id" LIMIT 100;

Date: 2026-08-28 10:31:05 Duration: 14s643ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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"."policy_id" LIMIT 100;

Date: 2026-08-28 14:42:24 Duration: 12s217ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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"."policy_id" LIMIT 100;

Date: 2026-08-28 14:55:17 Duration: 12s118ms

12

13

Details

51s526ms

3s17ms

6s348ms

3s963ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	07	2	12s52ms	6s26ms
	08	1	6s60ms	6s60ms
Aug 29	00	5	17s947ms	3s589ms
	01	5	15s466ms	3s93ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '8487765') AND ("bus_bus"."channel" in ('["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",19802]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",19692]', '["urg16","mail.channel",19518]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",19460]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19600]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",19868]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",20243]', '["urg16","broadcast"]', '["urg16","mail.channel",20240]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",20069]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","res.partner",8007532]', '["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",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",17377]'))) ORDER BY "bus_bus"."id";

Date: 2026-08-28 07:22:23 Duration: 6s348ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '8487765') AND ("bus_bus"."channel" in ('["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",19802]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19692]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",19460]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19518]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",19600]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",18413]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",19868]', '["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",20240]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",20243]', '["urg16","mail.channel",20069]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19416]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","broadcast"]', '["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",15199]', '["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-08-28 08:00:29 Duration: 6s60ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '22791761') AND ("bus_bus"."channel" in ('["urg16","mail.channel",16959]', '["urg16","mail.channel",18582]', '["urg16","mail.channel",20095]', '["urg16","mail.channel",18847]', '["urg16","mail.channel",16223]', '["urg16","mail.channel",273]', '["urg16","mail.channel",15658]', '["urg16","mail.channel",13388]', '["urg16","mail.channel",17418]', '["urg16","mail.channel",19523]', '["urg16","mail.channel",13052]', '["urg16","mail.channel",20252]', '["urg16","mail.channel",15996]', '["urg16","mail.channel",16179]', '["urg16","mail.channel",15523]', '["urg16","mail.channel",14986]', '["urg16","mail.channel",13317]', '["urg16","mail.channel",14403]', '["urg16","mail.channel",15907]', '["urg16","mail.channel",19690]', '["urg16","mail.channel",13637]', '["urg16","mail.channel",20019]', '["urg16","mail.channel",17029]', '["urg16","mail.channel",19918]', '["urg16","mail.channel",15189]', '["urg16","mail.channel",16995]', '["urg16","mail.channel",15927]', '["urg16","mail.channel",13541]', '["urg16","mail.channel",20094]', '["urg16","broadcast"]', '["urg16","mail.channel",15813]', '["urg16","mail.channel",16862]', '["urg16","mail.channel",18192]', '["urg16","mail.channel",19824]', '["urg16","mail.channel",20327]', '["urg16","mail.channel",18002]', '["urg16","mail.channel",14887]', '["urg16","mail.channel",14231]', '["urg16","mail.channel",18322]', '["urg16","mail.channel",16226]', '["urg16","mail.channel",18642]', '["urg16","mail.channel",16674]', '["urg16","mail.channel",18953]', '["urg16","mail.channel",14459]', '["urg16","mail.channel",16018]', '["urg16","mail.channel",17586]', '["urg16","mail.channel",16875]', '["urg16","mail.channel",16820]', '["urg16","mail.channel",19227]', '["urg16","mail.channel",20304]', '["urg16","mail.channel",19657]', '["urg16","mail.channel",18217]', '["urg16","mail.channel",20322]', '["urg16","mail.channel",14745]', '["urg16","mail.channel",17634]', '["urg16","mail.channel",18994]', '["urg16","mail.channel",15940]', '["urg16","mail.channel",20324]', '["urg16","mail.channel",17990]', '["urg16","mail.channel",15302]', '["urg16","mail.channel",19915]', '["urg16","mail.channel",19140]', '["urg16","mail.channel",16315]', '["urg16","mail.channel",14283]', '["urg16","mail.channel",17108]', '["urg16","mail.channel",13453]', '["urg16","mail.channel",20244]', '["urg16","mail.channel",17910]', '["urg16","mail.channel",19478]', '["urg16","mail.channel",19069]', '["urg16","mail.channel",16973]', '["urg16","mail.channel",15652]', '["urg16","mail.channel",19807]', '["urg16","mail.channel",19325]', '["urg16","res.partner",8006343]', '["urg16","mail.channel",14413]', '["urg16","mail.channel",19709]', '["urg16","mail.channel",20255]', '["urg16","mail.channel",18397]', '["urg16","mail.channel",13421]', '["urg16","mail.channel",16966]', '["urg16","mail.channel",18525]', '["urg16","mail.channel",15663]', '["urg16","mail.channel",19501]', '["urg16","mail.channel",15617]', '["urg16","mail.channel",16703]', '["urg16","mail.channel",15336]'))) ORDER BY "bus_bus"."id";

Date: 2026-08-28 07:22:22 Duration: 5s703ms

13

Details

46s78ms

3s

4s748ms

3s544ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."out_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))))) order by "shipping_policy"."id" desc limit ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Aug 28	15	6	18s772ms	3s128ms
	17	1	3s421ms	3s421ms
	18	4	15s714ms	3s928ms
	19	1	3s621ms	3s621ms
	20	1	4s548ms	4s548ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."out_date" = '2026-08-28'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (67, 68)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3))))) 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-08-28 18:55:46 Duration: 4s748ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."out_date" = '2026-08-28'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (67, 68)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3))))) 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-08-28 20:31:17 Duration: 4s548ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."out_date" = '2026-08-28'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (67, 68)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (3))))) 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-08-28 18:45:18 Duration: 3s718ms

14

11

Details

39s936ms

3s156ms

4s662ms

3s630ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	02	2	8s785ms	4s392ms
	15	1	3s402ms	3s402ms
	18	2	7s171ms	3s585ms
	19	1	3s225ms	3s225ms
	21	2	6s558ms	3s279ms
	22	1	3s526ms	3s526ms
	23	2	7s267ms	3s633ms

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 (8)))))) 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-08-28 02:01:46 Duration: 4s662ms
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 (8)))))) 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-08-28 02:16:21 Duration: 4s123ms
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 (41)))))) 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-08-28 18:53:20 Duration: 3s660ms

15

11

Details

39s255ms

3s129ms

3s905ms

3s568ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Aug 28	15	1	3s697ms	3s697ms
	18	2	7s356ms	3s678ms
	19	8	28s200ms	3s525ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id", "cash_policy"."x_total_amount_cash_lines_at_receive" ASC, "cash_policy"."state" ASC LIMIT 200;

Date: 2026-08-28 19:17:55 Duration: 3s905ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id", "cash_policy"."x_total_amount_cash_lines_at_receive" ASC, "cash_policy"."state" ASC LIMIT 200;

Date: 2026-08-28 19:04:50 Duration: 3s811ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id", "cash_policy"."x_total_amount_cash_lines_at_receive" ASC, "cash_policy"."state" ASC LIMIT 200;

Date: 2026-08-28 18:57:48 Duration: 3s730ms

16

9

Details

31s855ms

3s278ms

4s61ms

3s539ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) 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 #16

Day	Hour	Count	Duration	Avg duration
Aug 28	09	1	3s423ms	3s423ms
	13	1	3s278ms	3s278ms
	14	4	14s621ms	3s655ms
	15	2	7s9ms	3s504ms
	18	1	3s521ms	3s521ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (99)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) 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-08-28 14:49:05 Duration: 4s61ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) 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-08-28 15:42:04 Duration: 3s725ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (99)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) 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 150;

Date: 2026-08-28 14:50:34 Duration: 3s695ms

17

6

Details

20s509ms

3s107ms

4s127ms

3s418ms

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 (...)))))))) order by "policy_number"."id" limit ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Aug 28	10	1	4s127ms	4s127ms
	17	2	6s572ms	3s286ms
	18	1	3s525ms	3s525ms
	19	1	3s177ms	3s177ms
	21	1	3s107ms	3s107ms

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 (22))))))) 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 (22)))))) 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 (22)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) 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 (22))))))))) 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 (22)))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 10:42:20 Duration: 4s127ms
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 (6))))))) 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 (6)))))) 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 (6)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6)))))) 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 (6))))))))) 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 (6)))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 18:32:31 Duration: 3s525ms
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 (55))))))) 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 (55)))))) 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 (55)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (55)))))) 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 (55))))))))) 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 (55)))))))) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 17:50:22 Duration: 3s323ms

18

5

Details

2m17s

26s367ms

31s410ms

27s580ms

insert into policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) values (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) on conflict do nothing;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Aug 28	23	5	2m17s	27s580ms

INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:45:02 Duration: 31s410ms
INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:46:44 Duration: 26s900ms
INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:48:26 Duration: 26s828ms

19

5

Details

29s827ms

5s763ms

6s580ms

5s965ms

delete from "ir_attachment" where id in (...);

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Aug 28	17	5	29s827ms	5s965ms

DELETE FROM "ir_attachment" WHERE id IN (984303);

Date: 2026-08-28 17:39:44 Duration: 6s580ms
DELETE FROM "ir_attachment" WHERE id IN (984307);

Date: 2026-08-28 17:39:50 Duration: 5s854ms
DELETE FROM "ir_attachment" WHERE id IN (984304);

Date: 2026-08-28 17:40:07 Duration: 5s852ms

20

5

Details

19s388ms

3s378ms

5s9ms

3s877ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."state" = ?))) 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 #20

Day	Hour	Count	Duration	Avg duration
Aug 28	09	1	5s9ms	5s9ms
	13	2	7s115ms	3s557ms
	17	1	3s798ms	3s798ms
	19	1	3s465ms	3s465ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (88)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) 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-08-28 09:15:53 Duration: 5s9ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) 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-08-28 17:21:36 Duration: 3s798ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) 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-08-28 13:29:25 Duration: 3s737ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

13m16s

1

Details

13m16s

copy public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) to stdout;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	13m16s	13m16s

COPY public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) TO stdout;

Date: 2026-08-28 08:25:29 Duration: 13m16s

2

6m12s

1

Details

6m12s

copy public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) to stdout;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	6m12s	6m12s

COPY public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) TO stdout;

Date: 2026-08-28 08:31:45 Duration: 6m12s

3

5m15s

1

Details

5m15s

copy public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) to stdout;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	5m15s	5m15s

COPY public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) TO stdout;

Date: 2026-08-28 08:43:39 Duration: 5m15s

4

4m2s

1

Details

4m2s

copy public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) to stdout;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	4m2s	4m2s

COPY public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) TO stdout;

Date: 2026-08-28 08:37:32 Duration: 4m2s

5

3m9s

1

Details

3m9s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	3m9s	3m9s

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

Date: 2026-08-28 08:06:17 Duration: 3m9s

6

1m5s

1

Details

1m5s

copy public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) to stdout;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	1m5s	1m5s

COPY public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) TO stdout;

Date: 2026-08-28 08:09:23 Duration: 1m5s

7

1m2s

1

Details

1m2s

copy public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) to stdout;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	1m2s	1m2s

COPY public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) TO stdout;

Date: 2026-08-28 08:07:20 Duration: 1m2s

8

50s571ms

1

Details

50s571ms

copy public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) to stdout;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Aug 28	08	1	50s571ms	50s571ms

COPY public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) TO stdout;

Date: 2026-08-28 08:08:17 Duration: 50s571ms

9

26s367ms

31s410ms

27s580ms

5

Details

2m17s

insert into policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) values (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) on conflict do nothing;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Aug 28	23	5	2m17s	27s580ms

INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:45:02 Duration: 31s410ms
INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:46:44 Duration: 26s900ms
INSERT INTO policy_number_policy_tracking_missing_rel (policy_tracking_missing_id, policy_number_id) VALUES (23916, 55695624), (23916, 55695638), (23916, 55695640), (23916, 55695641), (23916, 55695642), (23916, 55695643) ON CONFLICT DO NOTHING;

Date: 2026-08-28 23:48:26 Duration: 26s828ms

10

3s713ms

14s643ms

11s205ms

13

Details

2m25s

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" not in (...)) 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))))) order by "shipping_policy"."policy_id" limit ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Aug 28	10	1	14s643ms	14s643ms
	14	10	1m55s	11s532ms
	22	2	15s698ms	7s849ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (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, 144, 145, 146, 147)))) 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))))) ORDER BY "shipping_policy"."policy_id" LIMIT 100;

Date: 2026-08-28 10:31:05 Duration: 14s643ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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"."policy_id" LIMIT 100;

Date: 2026-08-28 14:42:24 Duration: 12s217ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) 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 (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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"."policy_id" LIMIT 100;

Date: 2026-08-28 14:55:17 Duration: 12s118ms

11

4s912ms

10s679ms

8s119ms

42

Details

5m41s

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
Aug 28	11	1	10s679ms	10s679ms
	16	8	55s924ms	6s990ms
	17	9	1m1s	6s807ms
	19	3	18s922ms	6s307ms
	20	11	1m42s	9s317ms
	21	9	1m22s	9s178ms
	22	1	9s130ms	9s130ms

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

Date: 2026-08-28 11:06:07 Duration: 10s679ms
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 (79)))))) 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 '%1387%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 20:10:11 Duration: 9s954ms
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 '%1406241%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 16:21:01 Duration: 9s911ms

12

4s939ms

9s907ms

7s378ms

28

Details

3m26s

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
Aug 28	02	3	23s501ms	7s833ms
	15	2	15s900ms	7s950ms
	18	5	38s961ms	7s792ms
	19	1	9s254ms	9s254ms
	21	2	14s691ms	7s345ms
	22	8	53s837ms	6s729ms
	23	7	50s446ms	7s206ms

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

Date: 2026-08-28 15:42:27 Duration: 9s907ms
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 (8)))))) 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 '%1358996%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 23:06:04 Duration: 9s759ms
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 (8)))))) 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 '%13589%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2026-08-28 23:06:03 Duration: 9s727ms

13

6s724ms

8s630ms

7s91ms

120

Details

14m10s

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

Day	Hour	Count	Duration	Avg duration
Aug 28	09	59	6m59s	7s110ms
	10	61	7m11s	7s71ms

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 (23299512, 23248822, 23461788, 23531046, 23222972, 23361488, 23492234, 23495804, 23519791, 23558587, 23532168, 23456099, 23557928, 23554985, 23404832, 23525970, 23528604, 23519686, 23468619, 22756755, 23553390, 22968680, 23557994, 23521471, 23556264, 23485455, 23105353, 23414589, 23494190, 23488669, 23441116, 23435326, 23346772, 23427452, 23467781, 23510874, 23523384, 23518922, 23060670, 23568563, 23568843, 23568987, 23451498, 23192985, 23172586, 23299228, 23522347, 23501287, 23103965, 23518912, 23553708, 23494728, 23537565, 23519605, 23488235, 23524782, 23496441, 23416704, 23464257, 23333925, 23536435, 23197718, 23516748, 23535809, 23050109, 23500606, 23440318, 23283849, 23576394, 23536498, 23429978, 23524589, 23271928, 23333004, 23442121, 23490564, 23046669, 23071766, 23418428, 23469229);

Date: 2026-08-28 10:36:08 Duration: 8s630ms
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 (23511376, 23548145, 23489104, 23529734, 23550065, 23511372, 23551086, 23530399, 23522555, 23422294, 23468191, 23434681, 23488614, 23532814, 23523649, 23414798, 23548186, 23115517, 23545180, 23341969, 23520657, 23518230);

Date: 2026-08-28 09:52:28 Duration: 8s35ms
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 (23489148, 23520999, 23519417, 23520983, 23258763, 23526485, 23488440, 23085864, 23515577, 23467024, 23473254, 23518280);

Date: 2026-08-28 09:58:06 Duration: 7s840ms

14

5s763ms

6s580ms

5s965ms

5

Details

29s827ms

delete from "ir_attachment" where id in (...);

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Aug 28	17	5	29s827ms	5s965ms

DELETE FROM "ir_attachment" WHERE id IN (984303);

Date: 2026-08-28 17:39:44 Duration: 6s580ms
DELETE FROM "ir_attachment" WHERE id IN (984307);

Date: 2026-08-28 17:39:50 Duration: 5s854ms
DELETE FROM "ir_attachment" WHERE id IN (984304);

Date: 2026-08-28 17:40:07 Duration: 5s852ms

15

3s143ms

6s917ms

3s978ms

23

Details

1m31s

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

Day	Hour	Count	Duration	Avg duration
Aug 28	11	1	5s43ms	5s43ms
	16	3	10s938ms	3s646ms
	17	3	11s266ms	3s755ms
	19	1	3s429ms	3s429ms
	20	6	30s297ms	5s49ms
	21	8	27s195ms	3s399ms
	22	1	3s335ms	3s335ms

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 (79)))))) 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-08-28 20:10:05 Duration: 6s917ms
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 (79)))))) 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-08-28 20:10:23 Duration: 5s598ms
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 (79)))))) 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-08-28 20:10:20 Duration: 5s342ms

16

3s17ms

6s348ms

3s963ms

13

Details

51s526ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	07	2	12s52ms	6s26ms
	08	1	6s60ms	6s60ms
Aug 29	00	5	17s947ms	3s589ms
	01	5	15s466ms	3s93ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '8487765') AND ("bus_bus"."channel" in ('["urg16","mail.channel",16724]', '["urg16","mail.channel",14753]', '["urg16","mail.channel",19366]', '["urg16","mail.channel",18118]', '["urg16","mail.channel",19802]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",14759]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",19692]', '["urg16","mail.channel",19518]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",19460]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",19600]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",18413]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",17226]', '["urg16","mail.channel",14950]', '["urg16","mail.channel",19868]', '["urg16","mail.channel",18074]', '["urg16","mail.channel",17833]', '["urg16","mail.channel",14773]', '["urg16","mail.channel",19337]', '["urg16","mail.channel",20243]', '["urg16","broadcast"]', '["urg16","mail.channel",20240]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",20069]', '["urg16","mail.channel",19416]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","mail.channel",17155]', '["urg16","mail.channel",16230]', '["urg16","mail.channel",19409]', '["urg16","res.partner",8007532]', '["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",17719]', '["urg16","mail.channel",15199]', '["urg16","mail.channel",18262]', '["urg16","mail.channel",15028]', '["urg16","mail.channel",17377]'))) ORDER BY "bus_bus"."id";

Date: 2026-08-28 07:22:23 Duration: 6s348ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '8487765') AND ("bus_bus"."channel" in ('["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",19802]', '["urg16","mail.channel",18722]', '["urg16","mail.channel",17407]', '["urg16","mail.channel",19692]', '["urg16","mail.channel",19265]', '["urg16","mail.channel",17532]', '["urg16","mail.channel",17416]', '["urg16","mail.channel",18249]', '["urg16","mail.channel",19454]', '["urg16","mail.channel",19460]', '["urg16","mail.channel",17895]', '["urg16","mail.channel",19518]', '["urg16","mail.channel",19164]', '["urg16","mail.channel",15027]', '["urg16","mail.channel",16586]', '["urg16","mail.channel",17605]', '["urg16","mail.channel",18029]', '["urg16","mail.channel",19600]', '["urg16","mail.channel",13065]', '["urg16","mail.channel",18224]', '["urg16","mail.channel",19423]', '["urg16","mail.channel",17803]', '["urg16","mail.channel",19368]', '["urg16","mail.channel",17141]', '["urg16","mail.channel",18413]', '["urg16","mail.channel",14758]', '["urg16","mail.channel",19868]', '["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",20240]', '["urg16","mail.channel",17845]', '["urg16","mail.channel",20243]', '["urg16","mail.channel",20069]', '["urg16","mail.channel",17314]', '["urg16","mail.channel",18992]', '["urg16","mail.channel",17491]', '["urg16","mail.channel",14617]', '["urg16","mail.channel",19416]', '["urg16","res.partner",8007532]', '["urg16","mail.channel",17500]', '["urg16","mail.channel",18339]', '["urg16","mail.channel",19010]', '["urg16","mail.channel",17329]', '["urg16","broadcast"]', '["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",15199]', '["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-08-28 08:00:29 Duration: 6s60ms
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."id" > '22791761') AND ("bus_bus"."channel" in ('["urg16","mail.channel",16959]', '["urg16","mail.channel",18582]', '["urg16","mail.channel",20095]', '["urg16","mail.channel",18847]', '["urg16","mail.channel",16223]', '["urg16","mail.channel",273]', '["urg16","mail.channel",15658]', '["urg16","mail.channel",13388]', '["urg16","mail.channel",17418]', '["urg16","mail.channel",19523]', '["urg16","mail.channel",13052]', '["urg16","mail.channel",20252]', '["urg16","mail.channel",15996]', '["urg16","mail.channel",16179]', '["urg16","mail.channel",15523]', '["urg16","mail.channel",14986]', '["urg16","mail.channel",13317]', '["urg16","mail.channel",14403]', '["urg16","mail.channel",15907]', '["urg16","mail.channel",19690]', '["urg16","mail.channel",13637]', '["urg16","mail.channel",20019]', '["urg16","mail.channel",17029]', '["urg16","mail.channel",19918]', '["urg16","mail.channel",15189]', '["urg16","mail.channel",16995]', '["urg16","mail.channel",15927]', '["urg16","mail.channel",13541]', '["urg16","mail.channel",20094]', '["urg16","broadcast"]', '["urg16","mail.channel",15813]', '["urg16","mail.channel",16862]', '["urg16","mail.channel",18192]', '["urg16","mail.channel",19824]', '["urg16","mail.channel",20327]', '["urg16","mail.channel",18002]', '["urg16","mail.channel",14887]', '["urg16","mail.channel",14231]', '["urg16","mail.channel",18322]', '["urg16","mail.channel",16226]', '["urg16","mail.channel",18642]', '["urg16","mail.channel",16674]', '["urg16","mail.channel",18953]', '["urg16","mail.channel",14459]', '["urg16","mail.channel",16018]', '["urg16","mail.channel",17586]', '["urg16","mail.channel",16875]', '["urg16","mail.channel",16820]', '["urg16","mail.channel",19227]', '["urg16","mail.channel",20304]', '["urg16","mail.channel",19657]', '["urg16","mail.channel",18217]', '["urg16","mail.channel",20322]', '["urg16","mail.channel",14745]', '["urg16","mail.channel",17634]', '["urg16","mail.channel",18994]', '["urg16","mail.channel",15940]', '["urg16","mail.channel",20324]', '["urg16","mail.channel",17990]', '["urg16","mail.channel",15302]', '["urg16","mail.channel",19915]', '["urg16","mail.channel",19140]', '["urg16","mail.channel",16315]', '["urg16","mail.channel",14283]', '["urg16","mail.channel",17108]', '["urg16","mail.channel",13453]', '["urg16","mail.channel",20244]', '["urg16","mail.channel",17910]', '["urg16","mail.channel",19478]', '["urg16","mail.channel",19069]', '["urg16","mail.channel",16973]', '["urg16","mail.channel",15652]', '["urg16","mail.channel",19807]', '["urg16","mail.channel",19325]', '["urg16","res.partner",8006343]', '["urg16","mail.channel",14413]', '["urg16","mail.channel",19709]', '["urg16","mail.channel",20255]', '["urg16","mail.channel",18397]', '["urg16","mail.channel",13421]', '["urg16","mail.channel",16966]', '["urg16","mail.channel",18525]', '["urg16","mail.channel",15663]', '["urg16","mail.channel",19501]', '["urg16","mail.channel",15617]', '["urg16","mail.channel",16703]', '["urg16","mail.channel",15336]'))) ORDER BY "bus_bus"."id";

Date: 2026-08-28 07:22:22 Duration: 5s703ms

17

3s378ms

5s9ms

3s877ms

5

Details

19s388ms

select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."state" = ?))) 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 #17

Day	Hour	Count	Duration	Avg duration
Aug 28	09	1	5s9ms	5s9ms
	13	2	7s115ms	3s557ms
	17	1	3s798ms	3s798ms
	19	1	3s465ms	3s465ms

SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (88)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) 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-08-28 09:15:53 Duration: 5s9ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) 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-08-28 17:21:36 Duration: 3s798ms
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) 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-08-28 13:29:25 Duration: 3s737ms

18

3s85ms

5s522ms

3s779ms

16

Details

1m

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
Aug 28	09	1	5s522ms	5s522ms
	11	2	7s530ms	3s765ms
	14	1	4s159ms	4s159ms
	15	1	4s523ms	4s523ms
	16	1	3s950ms	3s950ms
	19	1	3s773ms	3s773ms
	21	4	12s629ms	3s157ms
Aug 29	01	5	18s374ms	3s674ms

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 (27)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-08-28 09:29:10 Duration: 5s522ms
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-08-28 15:45:28 Duration: 4s523ms
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 (19)))) ORDER BY "policy_number"."id" LIMIT 80;

Date: 2026-08-28 11:39:36 Duration: 4s165ms

19

3s156ms

4s662ms

3s630ms

11

Details

39s936ms

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

Day	Hour	Count	Duration	Avg duration
Aug 28	02	2	8s785ms	4s392ms
	15	1	3s402ms	3s402ms
	18	2	7s171ms	3s585ms
	19	1	3s225ms	3s225ms
	21	2	6s558ms	3s279ms
	22	1	3s526ms	3s526ms
	23	2	7s267ms	3s633ms

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 (8)))))) 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-08-28 02:01:46 Duration: 4s662ms
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 (8)))))) 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-08-28 02:16:21 Duration: 4s123ms
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 (41)))))) 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-08-28 18:53:20 Duration: 3s660ms

20

3s129ms

3s905ms

3s568ms

11

Details

39s255ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Aug 28	15	1	3s697ms	3s697ms
	18	2	7s356ms	3s678ms
	19	8	28s200ms	3s525ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id", "cash_policy"."x_total_amount_cash_lines_at_receive" ASC, "cash_policy"."state" ASC LIMIT 200;

Date: 2026-08-28 19:17:55 Duration: 3s905ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id", "cash_policy"."x_total_amount_cash_lines_at_receive" ASC, "cash_policy"."state" ASC LIMIT 200;

Date: 2026-08-28 19:04:50 Duration: 3s811ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."policy_id", "cash_policy"."x_total_amount_cash_lines_at_receive" ASC, "cash_policy"."state" ASC LIMIT 200;

Date: 2026-08-28 18:57:48 Duration: 3s730ms

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

6,826 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	20	0.29%
DETAIL	25	0.37%
ERROR	2,649	38.81%
EVENTLOG	10	0.15%
FATAL	97	1.42%
HINT	19	0.28%
LOG	1,350	19.78%
STATEMENT	2,656	38.91%

Events distribution (except queries)

Key values

0 PANIC entries
97 FATAL entries
2649 ERROR entries
0 WARNING entries
10 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,559 Max number of times the same event was reported
2,756 Total events found

Rank

Times reported

Error

1

2,559

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Aug 28	02	110
	03	109
	04	110
	05	107
	06	106
	07	105
	08	108
	09	108
	10	108
	11	108
	12	108
	13	108
	14	107
	15	108
	16	108
	17	107
	18	109
	19	109
	20	107
	21	109
	22	107
	23	106
Aug 29	00	107
	01	80

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

78

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Aug 28	05	10
	07	1
	08	8
	11	20
	14	12
	17	10
	20	10
	23	7

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

3

47

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Aug 28	04	1
	05	1
	07	1
	09	2
	10	6
	11	7
	12	5
	13	1
	14	3
	15	6
	16	3
	19	1
	20	1
	21	5
	22	2
	23	1
Aug 29	00	1

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

4

19

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Aug 28	02	3
	18	3
	20	1
	23	12

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

5

18

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Aug 28	02	2
	03	1
	07	1
	08	4
	15	1
	18	2
	19	1
	20	2
	21	2
	22	1
	23	1

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

14

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Aug 28	05	2
	08	2
	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

7

9

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Aug 28	02	1
	05	1
	07	1
	08	1
	11	1
	14	1
	17	1
	20	1
	23	1

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

8

5

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Aug 28	07	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

9

4

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Aug 29	01	4

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

10

1

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Aug 28	19	1

ERROR: duplicate key value violates unique constraint "ir_filters_name_model_uid_unique"

11

1

Details

ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Aug 28	19	1

ERROR: update or delete on table "urgent_customer" violates foreign key constraint "collection_policy_customer_id_fkey" on table "collection_policy"

12

1

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Aug 28	07	1

LOG: could not send data to client: Broken pipe

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