pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jan 2 23:47:33 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 43,298,582 log entries in 2m31s
Log start from 2025-01-02 00:00:00 to 2025-01-02 22:45:02

Global Stats

20,165 Number of unique normalized queries
18,529,079 Number of queries
5d2h53m14s Total query duration
2025-01-02 00:00:00 First query
2025-01-02 22:45:02 Last query
8,398 queries/s at 2025-01-02 11:10:12 Query peak

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

7,691 Number of events
23 Number of unique normalized events
3,316 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
18,529,079 Average queries per session
5d2h53m14s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

8,398 queries/s Query Peak
2025-01-02 11:10:12 Date

SELECT Traffic

Key values

5,754 queries/s Query Peak
2025-01-02 11:10:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

2,017 queries/s Query Peak
2025-01-02 15:37:12 Date

Queries duration

Key values

5d2h53m14s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 02	00	281,834	0ms	1s14ms	16ms	2m11s	2m27s	3m26s
	01	264,356	0ms	1s564ms	19ms	2m35s	3m14s	3m52s
	02	235,381	0ms	4m5s	46ms	2m58s	4m38s	1h6m49s
	03	204,343	0ms	664ms	23ms	2m9s	2m59s	4m4s
	04	226,516	0ms	808ms	26ms	3m	3m30s	3m33s
	05	182,864	0ms	594ms	16ms	1m35s	1m42s	2m13s
	06	195,533	0ms	4s551ms	21ms	2m16s	2m43s	3m24s
	07	162,976	0ms	963ms	8ms	1m9s	1m21s	1m54s
	08	417,865	0ms	1s287ms	10ms	2m54s	3m22s	4m8s
	09	1,155,015	0ms	15m40s	31ms	4m53s	5m30s	5h8m50s
	10	1,442,112	0ms	12m47s	14ms	4m34s	6m	2h44m54s
	11	1,844,951	0ms	24m57s	21ms	12m20s	1h19s	3h27m45s
	12	1,655,396	0ms	10m56s	21ms	7m43s	9m18s	2h51m19s
	13	1,712,274	0ms	9m34s	16ms	8m9s	10m2s	1h45m18s
	14	1,405,680	0ms	34m5s	23ms	6m59s	7m31s	4h52m13s
	15	1,361,375	0ms	36m58s	23ms	7m15s	8m43s	4h37m56s
	16	1,243,516	0ms	40m24s	29ms	4m14s	4m56s	7h30m44s
	17	1,170,946	0ms	13m4s	21ms	6m38s	6m53s	3h20m57s
	18	927,258	0ms	2m42s	16ms	7m17s	7m53s	10m45s
	19	885,664	0ms	23m3s	40ms	6m37s	9m23s	5h57m28s
	20	684,255	0ms	59m59s	25ms	6m22s	11m54s	1h12m33s
	21	520,656	0ms	21m20s	65ms	6m57s	11m49s	5h56m7s
	22	348,313	0ms	4s941ms	20ms	4m35s	4m45s	5m10s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 02	00	150,133	30ms	1m57s	2m10s	2m39s
	01	133,866	38ms	1m59s	2m34s	3m47s
	02	121,064	41ms	2m1s	2m24s	3m22s
	03	100,915	46ms	1m52s	2m9s	3m14s
	04	115,671	51ms	2m43s	2m59s	3m30s
	05	88,361	34ms	1m22s	1m35s	2m7s
	06	104,192	40ms	1m52s	2m16s	3m9s
	07	85,130	16ms	33s690ms	1m9s	1m50s
	08	238,845	18ms	1m51s	2m53s	3m37s
	09	687,838	16ms	4m3s	4m44s	5m18s
	10	848,715	13ms	4m15s	4m32s	5m59s
	11	1,112,521	18ms	8m32s	10m8s	12m29s
	12	983,560	17ms	6m25s	7m7s	8m9s
	13	1,013,274	18ms	6m31s	6m56s	8m7s
	14	830,135	19ms	5m58s	6m57s	7m30s
	15	794,463	19ms	6m9s	6m52s	8m41s
	16	719,520	14ms	3m27s	4m11s	4m55s
	17	704,625	18ms	5m5s	6m12s	6m51s
	18	528,763	27ms	5m37s	7m5s	7m51s
	19	517,660	27ms	5m10s	5m41s	7m30s
	20	413,788	32ms	4m13s	6m21s	12m5s
	21	305,033	41ms	4m16s	6m54s	11m48s
	22	198,795	36ms	3m42s	4m35s	5m9s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 02	00	20,125	4,977	190	0	0ms	114ms	143ms	199ms
	01	20,232	6,124	198	0	0ms	122ms	167ms	206ms
	02	18,295	5,386	130	0	245ms	129ms	166ms	357ms
	03	15,489	4,619	125	0	0ms	97ms	123ms	204ms
	04	22,436	6,129	129	0	0ms	142ms	207ms	258ms
	05	9,072	3,754	129	0	0ms	62ms	77ms	107ms
	06	14,888	4,450	190	0	0ms	105ms	131ms	173ms
	07	5,645	2,263	165	0	0ms	34ms	52ms	103ms
	08	15,602	6,490	303	0	0ms	99ms	128ms	179ms
	09	50,648	16,163	609	0	378ms	328ms	392ms	28s813ms
	10	59,877	18,639	823	0	122ms	347ms	399ms	470ms
	11	90,378	25,835	685	0	168ms	611ms	788ms	58m38s
	12	73,643	24,992	1,007	1	181ms	456ms	525ms	44s498ms
	13	80,419	26,750	1,142	1	79ms	524ms	634ms	4m23s
	14	69,001	21,128	454	0	192ms	374ms	488ms	808ms
	15	62,789	21,598	693	0	195ms	389ms	561ms	35s439ms
	16	44,804	17,247	519	1	431ms	235ms	289ms	652ms
	17	57,747	18,863	815	0	153ms	444ms	585ms	1s662ms
	18	67,149	17,281	797	2	3ms	438ms	543ms	875ms
	19	74,574	18,886	567	0	230ms	458ms	566ms	45s546ms
	20	54,779	15,831	480	0	51ms	327ms	428ms	611ms
	21	49,220	13,068	274	0	339ms	324ms	418ms	569ms
	22	33,113	6,893	197	0	0ms	233ms	293ms	520ms

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

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

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

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

135,765 buffers Checkpoint Peak
2025-01-02 12:01:26 Date
270.055 seconds Highest write time
0.015 seconds Sync time

Checkpoints Wal files

Key values

56 files Wal files usage Peak
2025-01-02 12:01:26 Date

Checkpoints distance

Key values

1,802.38 Mo Distance Peak
2025-01-02 12:01:26 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 02	00	127,978	3,239.471s	0.036s	3,239.56s
	01	124,564	3,239.635s	0.034s	3,239.712s
	02	141,556	3,239.526s	0.032s	3,239.605s
	03	134,881	3,239.605s	0.035s	3,239.684s
	04	133,874	3,239.6s	0.033s	3,239.674s
	05	110,575	3,239.526s	0.029s	3,239.601s
	06	105,530	3,239.63s	0.028s	3,239.703s
	07	51,466	3,010.922s	0.027s	3,010.982s
	08	107,243	3,186.969s	0.032s	3,187.044s
	09	346,679	3,239.546s	0.052s	3,239.674s
	10	438,277	3,239.459s	0.06s	3,239.594s
	11	588,054	3,239.492s	0.058s	3,239.643s
	12	615,380	3,239.474s	0.05s	3,239.615s
	13	600,751	3,239.572s	0.055s	3,239.716s
	14	441,338	3,239.459s	0.053s	3,239.59s
	15	419,134	3,239.567s	0.062s	3,239.706s
	16	333,285	3,239.5s	0.046s	3,239.607s
	17	293,902	2,884.979s	0.066s	2,885.117s
	18	281,066	3,239.524s	0.049s	3,239.639s
	19	266,791	3,239.534s	0.051s	3,239.651s
	20	206,760	3,239.545s	0.046s	3,239.648s
	21	196,418	3,239.563s	0.037s	3,239.653s
	22	161,712	2,429.682s	0.034s	2,429.757s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 02	00	55	3,459	0.002s	0.012s
	01	52	3,411	0.002s	0.012s
	02	59	2,526	0.002s	0.012s
	03	56	2,166	0.003s	0.012s
	04	56	2,491	0.002s	0.012s
	05	46	2,065	0.002s	0.012s
	06	44	2,718	0.002s	0.012s
	07	22	2,696	0.002s	0.012s
	08	41	3,521	0.002s	0.012s
	09	142	4,834	0.003s	0.012s
	10	178	5,249	0.007s	0.012s
	11	247	5,253	0.003s	0.012s
	12	247	5,324	0.003s	0.012s
	13	235	5,303	0.003s	0.012s
	14	173	5,280	0.002s	0.012s
	15	166	5,482	0.011s	0.012s
	16	132	5,538	0.002s	0.012s
	17	116	5,505	0.009s	0.012s
	18	119	5,145	0.002s	0.012s
	19	109	5,044	0.003s	0.012s
	20	87	5,009	0.002s	0.012s
	21	84	4,560	0.002s	0.012s
	22	66	3,358	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Jan 02	00	73,839.92 kB	181,113.83 kB
	01	70,413.36 kB	104,756.00 kB
	02	81,032.92 kB	116,749.58 kB
	03	76,279.58 kB	109,542.50 kB
	04	77,148.50 kB	97,173.42 kB
	05	62,396.83 kB	85,576.75 kB
	06	60,545.17 kB	83,051.67 kB
	07	29,157.42 kB	69,437.42 kB
	08	56,548.67 kB	67,515.17 kB
	09	200,629.64 kB	274,633.91 kB
	10	243,475.25 kB	326,469.92 kB
	11	339,053.73 kB	404,180.09 kB
	12	337,250.08 kB	665,589.92 kB
	13	320,568.00 kB	410,896.67 kB
	14	236,302.75 kB	314,553.17 kB
	15	226,499.17 kB	281,442.67 kB
	16	180,447.58 kB	260,444.42 kB
	17	158,174.64 kB	200,736.27 kB
	18	161,988.92 kB	212,933.42 kB
	19	149,561.17 kB	220,147.92 kB
	20	118,377.50 kB	179,407.75 kB
	21	109,275.55 kB	152,506.64 kB
	22	120,395.00 kB	193,647.89 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

10,796,867 Total read queries
5,244,612 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,796,867	58.27%
INSERT	1,009,925	5.45%
UPDATE	307,366	1.66%
DELETE	10,621	0.06%
COPY FROM	5	0.00%
COPY TO	0	0.00%
CTE	22,424	0.12%
DDL	1,269	0.01%
TCL	3,893,002	21.01%
CURSOR	0	0.00%
OTHERS	2,487,600	13.43%

Queries by database

Key values

unknown Main database
18,529,079 Requests
5d2h53m14s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	18,529,079	5d2h53m14s
	copy from	5	8ms
	cte	22,424	4s902ms
	ddl	1,269	179ms
	delete	10,621	1s417ms
	insert	1,009,925	5m15s
	others	2,487,600	1m58s
	select	10,796,867	2d17h11m14s
	tcl	3,893,002	2m37s
	update	307,366	2d9h32m

Queries by user

Key values

unknown Main user
18,529,079 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	18,529,079	5d2h53m14s
	copy from	5	8ms
	cte	22,424	4s902ms
	ddl	1,269	179ms
	delete	10,621	1s417ms
	insert	1,009,925	5m15s
	others	2,487,600	1m58s
	select	10,796,867	2d17h11m14s
	tcl	3,893,002	2m37s
	update	307,366	2d9h32m

Duration by user

Key values

5d2h53m14s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	18,529,079	5d2h53m14s
	copy from	5	8ms
	cte	22,424	4s902ms
	ddl	1,269	179ms
	delete	10,621	1s417ms
	insert	1,009,925	5m15s
	others	2,487,600	1m58s
	select	10,796,867	2d17h11m14s
	tcl	3,893,002	2m37s
	update	307,366	2d9h32m

Queries by host

Key values

unknown Main host
18,529,079 Requests
5d2h53m14s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,529,079	5d2h53m14s
	copy from	5	8ms
	cte	22,424	4s902ms
	ddl	1,269	179ms
	delete	10,621	1s417ms
	insert	1,009,925	5m15s
	others	2,487,600	1m58s
	select	10,796,867	2d17h11m14s
	tcl	3,893,002	2m37s
	update	307,366	2d9h32m

Queries by application

Key values

unknown Main application
18,529,079 Requests
5d2h53m14s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	18,529,079	5d2h53m14s
	copy from	5	8ms
	cte	22,424	4s902ms
	ddl	1,269	179ms
	delete	10,621	1s417ms
	insert	1,009,925	5m15s
	others	2,487,600	1m58s
	select	10,796,867	2d17h11m14s
	tcl	3,893,002	2m37s
	update	307,366	2d9h32m

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-02 21:51:43 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,318,323 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,318,323	93.47%
1-5ms	284,300	1.53%
5-10ms	13,990	0.08%
10-25ms	56,055	0.30%
25-50ms	213,800	1.15%
50-100ms	61,645	0.33%
100-500ms	458,325	2.47%
500-1000ms	116,221	0.63%
1000-10000ms	5,919	0.03%
> 10000ms	501	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = 'b1ce038250a025118d54c63d336323f3773bde9e', last_update = '2025-01-02 18:57:47.965885', exp_date = '2025-01-02 19:42:47.965889', logged_in = 'TRUE' where id = 861; [ Date: 2025-01-02 20:57:47 ]
2	40m24s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:08:56.279248', exp_date = '2025-01-02 15:53:56.279252', logged_in = 'TRUE' where id = 833; [ Date: 2025-01-02 16:49:21 ]
3	40m24s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:08:56.279045', exp_date = '2025-01-02 15:53:56.279049', logged_in = 'TRUE' where id = 833; [ Date: 2025-01-02 16:49:21 ]
4	36m58s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:39:22.786170', exp_date = '2025-01-02 14:24:22.786174', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 15:16:21 ]
5	36m58s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:39:23.183592', exp_date = '2025-01-02 14:24:23.183595', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 15:16:21 ]
6	36m56s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:39:24.719205', exp_date = '2025-01-02 14:24:24.719207', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 15:16:21 ]
7	34m5s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:05:15.951144', exp_date = '2025-01-02 13:50:15.951148', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 14:39:21 ]
8	34m5s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:05:15.951655', exp_date = '2025-01-02 13:50:15.951659', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 14:39:21 ]
9	30m39s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:08:41.361108', exp_date = '2025-01-02 13:53:41.361112', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 14:39:21 ]
10	29m51s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:09:30.046466', exp_date = '2025-01-02 13:54:30.046469', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 14:39:21 ]
11	26m47s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:22:33.749542', exp_date = '2025-01-02 16:07:33.749545', logged_in = 'TRUE' where id = 833; [ Date: 2025-01-02 16:49:21 ]
12	26m17s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:23:03.426258', exp_date = '2025-01-02 16:08:03.426261', logged_in = 'TRUE' where id = 833; [ Date: 2025-01-02 16:49:21 ]
13	26m17s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:23:03.486182', exp_date = '2025-01-02 16:08:03.486186', logged_in = 'TRUE' where id = 833; [ Date: 2025-01-02 16:49:21 ]
14	26m16s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:23:04.917940', exp_date = '2025-01-02 16:08:04.917943', logged_in = 'TRUE' where id = 833; [ Date: 2025-01-02 16:49:21 ]
15	25m	update res_users set sid = '0da4689aa0c378ac657514db6802d659e81af59f', last_update = '2025-01-02 15:24:20.807145', exp_date = '2025-01-02 16:09:20.807149', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-02 16:49:21 ]
16	25m	update res_users set sid = '0da4689aa0c378ac657514db6802d659e81af59f', last_update = '2025-01-02 15:24:20.806794', exp_date = '2025-01-02 16:09:20.806797', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-02 16:49:21 ]
17	24m57s	update res_users set sid = '39f785813e1609c3f64372b80ebc11e135bbb58e', last_update = '2025-01-02 10:13:23.584996', exp_date = '2025-01-02 10:58:23.584998', logged_in = 'TRUE' where id = 829; [ Date: 2025-01-02 11:38:20 ]
18	24m3s	update res_users set sid = '39f785813e1609c3f64372b80ebc11e135bbb58e', last_update = '2025-01-02 10:14:17.086685', exp_date = '2025-01-02 10:59:17.086688', logged_in = 'TRUE' where id = 829; [ Date: 2025-01-02 11:38:20 ]
19	23m57s	update res_users set sid = '0285d0d4dfc32908a15cf351bbee5b291a9b752d', last_update = '2025-01-02 15:25:23.810677', exp_date = '2025-01-02 16:10:23.810681', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-02 16:49:21 ]
20	23m30s	update res_users set sid = 'db088c12bc97eb19b34fa58b0c95f6dcefcb5bc5', last_update = '2025-01-02 13:15:51.003827', exp_date = '2025-01-02 14:00:51.003832', logged_in = 'TRUE' where id = 909; [ Date: 2025-01-02 14:39:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d7h6m28s

76,447

Details

0ms

59m59s

2s595ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 02	00	955	204ms	0ms
	01	1,001	214ms	0ms
	02	730	1h33m19s	7s670ms
	03	616	132ms	0ms
	04	698	148ms	0ms
	05	675	139ms	0ms
	06	448	99ms	0ms
	07	426	90ms	0ms
	08	1,784	379ms	0ms
	09	5,351	6h37m36s	4s458ms
	10	6,298	2h42m9s	1s544ms
	11	8,319	5h20m14s	2s309ms
	12	7,468	4h59m51s	2s409ms
	13	7,840	2h21m1s	1s79ms
	14	6,295	4h49m16s	2s757ms
	15	6,364	4h34m47s	2s590ms
	16	5,472	7h29m16s	4s926ms
	17	4,481	3h17m55s	2s650ms
	18	3,768	5m3s	80ms
	19	3,035	5h20m3s	6s327ms
	20	1,958	59m59s	1s838ms
	21	1,587	4h55m49s	11s184ms
	22	878	207ms	0ms

update res_users set sid = 'b1ce038250a025118d54c63d336323f3773bde9e', last_update = '2025-01-02 18:57:47.965885', exp_date = '2025-01-02 19:42:47.965889', logged_in = 'TRUE' where id = 861;

Date: 2025-01-02 20:57:47 Duration: 59m59s
update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:08:56.279248', exp_date = '2025-01-02 15:53:56.279252', logged_in = 'TRUE' where id = 833;

Date: 2025-01-02 16:49:21 Duration: 40m24s
update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:08:56.279045', exp_date = '2025-01-02 15:53:56.279049', logged_in = 'TRUE' where id = 833;

Date: 2025-01-02 16:49:21 Duration: 40m24s

2

1d9h17m6s

241,818

Details

410ms

3s341ms

495ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 02	00	6,525	49m39s	456ms
	01	6,656	51m2s	460ms
	02	6,652	51m2s	460ms
	03	7,096	53m36s	453ms
	04	8,259	1h3m28s	461ms
	05	4,441	33m4s	446ms
	06	4,858	37m36s	464ms
	07	1,797	13m26s	449ms
	08	4,025	30m17s	451ms
	09	12,539	1h38m40s	472ms
	10	12,951	1h43m44s	480ms
	11	21,447	3h13m50s	542ms
	12	16,934	2h23m19s	507ms
	13	18,507	2h38m55s	515ms
	14	13,571	1h57m11s	518ms
	15	13,206	1h52m25s	510ms
	16	8,386	1h7m7s	480ms
	17	11,819	1h39m30s	505ms
	18	14,136	1h58m56s	504ms
	19	14,262	2h1m24s	510ms
	20	11,470	1h37m12s	508ms
	21	13,953	1h54m1s	490ms
	22	8,328	1h7m30s	486ms

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

Date: 2025-01-02 11:18:13 Duration: 3s341ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4139734)) AND (("shipping_track"."id" not in (33898524, 33898695, 33898813, 33919812, 33920043, 33983334, 33983754, 33983754)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:24:13 Duration: 2s602ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4143152)) AND (("shipping_track"."id" not in (33926270, 33927534, 33928486, 33982666, 33982666)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:22:59 Duration: 1s480ms

3

6h26m49s

45,776

Details

412ms

2s968ms

507ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 02	00	439	3m27s	473ms
	01	463	3m38s	472ms
	02	161	1m22s	512ms
	03	122	1m5s	534ms
	04	147	1m17s	527ms
	05	117	59s521ms	508ms
	06	328	2m30s	457ms
	07	348	2m41s	463ms
	08	880	6m52s	468ms
	09	2,920	23m37s	485ms
	10	3,939	32m18s	492ms
	11	3,624	34m27s	570ms
	12	5,126	44m39s	522ms
	13	4,889	43m21s	532ms
	14	3,133	26m55s	515ms
	15	3,273	28m20s	519ms
	16	2,866	22m57s	480ms
	17	3,401	28m	494ms
	18	3,749	30m9s	482ms
	19	2,493	20m32s	494ms
	20	1,805	14m40s	487ms
	21	960	8m5s	506ms
	22	593	4m47s	485ms

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

Date: 2025-01-02 11:24:13 Duration: 2s968ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4109416)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:22:32 Duration: 2s585ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4084405)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:44:07 Duration: 2s584ms

4

5h43m54s

93,978

Details

174ms

414ms

219ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,180	3m53s	197ms
	01	2,163	7m11s	199ms
	02	2,348	7m51s	200ms
	03	2,415	8m5s	200ms
	04	2,578	8m34s	199ms
	05	2,166	7m14s	200ms
	06	2,309	7m42s	200ms
	07	527	1m45s	199ms
	08	4,568	15m23s	202ms
	09	4,699	16m19s	208ms
	10	3,566	12m38s	212ms
	11	8,736	33m54s	232ms
	12	8,000	30m7s	225ms
	13	7,942	29m56s	226ms
	14	7,891	28m56s	220ms
	15	7,584	27m59s	221ms
	16	4,775	16m28s	206ms
	17	2,971	10m12s	206ms
	18	140	28s502ms	203ms
	19	217	42s426ms	195ms
	20	6,996	28m58s	248ms
	21	9,895	38m28s	233ms
	22	312	1m	193ms

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

Date: 2025-01-02 11:44:02 Duration: 414ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '8086783')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-02 13:59:14 Duration: 366ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9640296')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-02 11:44:04 Duration: 365ms

5

3h49m30s

57,467

Details

89ms

915ms

239ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,434	4m36s	193ms
	01	1,734	5m25s	187ms
	02	1,934	6m55s	214ms
	03	846	3m13s	228ms
	04	2,402	9m4s	226ms
	05	158	37s247ms	235ms
	06	2,008	7m27s	222ms
	07	218	43s926ms	201ms
	08	12	1s651ms	137ms
	09	180	42s248ms	234ms
	10	586	1m49s	187ms
	11	348	1m19s	228ms
	12	350	1m25s	243ms
	13	480	1m41s	210ms
	14	3,684	21m54s	356ms
	15	2,124	11m5s	313ms
	16	1,934	7m30s	232ms
	17	5,478	22m5s	241ms
	18	7,464	27m10s	218ms
	19	8,007	31m32s	236ms
	20	7,206	27m43s	230ms
	21	4,692	19m31s	249ms
	22	4,188	15m51s	227ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'لاغى')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-02 14:41:36 Duration: 915ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'لاغى')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-02 14:41:36 Duration: 915ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-02 18:39:33 Duration: 913ms

6

2h53m47s

10,494

Details

31ms

1s602ms

993ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 02	00	182	2m53s	955ms
	01	227	3m36s	954ms
	02	41	39s548ms	964ms
	07	23	21s804ms	948ms
	08	4	3s732ms	933ms
	09	32	32s854ms	1s26ms
	10	5	5s176ms	1s35ms
	11	44	47s853ms	1s87ms
	12	51	53s977ms	1s58ms
	13	80	1m25s	1s66ms
	14	350	6m12s	1s64ms
	15	369	6m25s	1s45ms
	16	640	10m24s	975ms
	17	768	13m11s	1s31ms
	18	2,445	40m59s	1s5ms
	19	1,595	24m35s	925ms
	20	1,925	32m8s	1s1ms
	21	706	11m54s	1s12ms
	22	1,007	16m34s	987ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9711169')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))))) 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 (11)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-02 11:18:09 Duration: 1s602ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9674567')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))) 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 (68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) 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 (68))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-02 20:56:20 Duration: 1s568ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9753301')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (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"."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))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-02 21:03:09 Duration: 1s534ms

7

2h7m34s

347

Details

0ms

11m24s

22s58ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 02	00	4	4ms	1ms
	01	2	1ms	0ms
	02	1	0ms	0ms
	05	1	1ms	1ms
	06	4	5ms	1ms
	07	1	1ms	1ms
	08	11	5ms	0ms
	09	42	26m38s	38s51ms
	10	23	24ms	1ms
	11	30	42ms	1ms
	12	27	27ms	1ms
	13	34	1m58s	3s490ms
	14	25	38s964ms	1s558ms
	15	27	1m55s	4s271ms
	16	22	10ms	0ms
	17	15	17ms	1ms
	18	13	6ms	0ms
	19	26	39m36s	1m31s
	20	13	7ms	0ms
	21	24	56m46s	2m21s
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-02 20:56:56.320598', "last_update" = '2025-01-02 20:11:56.320619', "sid" = 'a9a49de17d4e554a993059ab72aa5c189c6d14fc', "write_date" = '2025-01-02 20:11:55.961069', "write_uid" = 1116 WHERE id IN (1116);

Date: 2025-01-02 21:23:20 Duration: 11m24s
UPDATE "res_users" SET "exp_date" = '2025-01-02 20:57:23.594225', "last_update" = '2025-01-02 20:12:23.594250', "sid" = 'a9a49de17d4e554a993059ab72aa5c189c6d14fc', "write_date" = '2025-01-02 20:12:23.274968', "write_uid" = 1116 WHERE id IN (1116);

Date: 2025-01-02 21:23:20 Duration: 10m57s
UPDATE "res_users" SET "exp_date" = '2025-01-02 18:57:19.271906', "last_update" = '2025-01-02 18:12:19.271927', "sid" = '69dd48aeee501c256157ae59e020988f54211777', "write_date" = '2025-01-02 18:12:18.865346', "write_uid" = 1 WHERE id IN (1116);

Date: 2025-01-02 19:22:20 Duration: 10m1s

8

1h45m53s

151,880

Details

31ms

265ms

41ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 02	00	3,152	2m2s	38ms
	01	3,073	2m	39ms
	02	2,225	1m26s	38ms
	03	1,787	1m10s	39ms
	04	2,038	1m19s	39ms
	05	956	37s939ms	39ms
	06	742	29s198ms	39ms
	07	967	38s85ms	39ms
	08	2,803	1m49s	39ms
	09	9,611	6m29s	40ms
	10	9,459	6m28s	41ms
	11	17,055	13m1s	45ms
	12	12,667	9m8s	43ms
	13	14,787	10m43s	43ms
	14	10,231	7m18s	42ms
	15	10,445	7m24s	42ms
	16	6,642	4m27s	40ms
	17	7,811	5m21s	41ms
	18	8,764	5m54s	40ms
	19	9,756	6m40s	41ms
	20	6,760	4m36s	40ms
	21	6,028	4m2s	40ms
	22	4,121	2m42s	39ms

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

Date: 2025-01-02 11:22:31 Duration: 265ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4139826)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-02 11:24:09 Duration: 206ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4131464)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-02 11:22:36 Duration: 206ms

9

1h43m45s

22,485

Details

182ms

598ms

276ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 02	08	1,882	7m48s	248ms
	09	1,102	4m52s	265ms
	10	1,781	7m59s	269ms
	11	3,001	14m38s	292ms
	12	2,334	11m17s	290ms
	13	3,590	17m6s	285ms
	14	3,352	15m25s	276ms
	15	2,682	12m30s	279ms
	16	1,766	7m47s	264ms
	17	995	4m18s	260ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9595823')))) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:23:33 Duration: 598ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9641813')))) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:18:07 Duration: 575ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9616667')))) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:18:06 Duration: 555ms

10

1h34m35s

18,592

Details

213ms

496ms

305ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 02	00	543	2m40s	295ms
	01	649	3m15s	300ms
	02	932	4m38s	298ms
	03	426	2m7s	299ms
	04	1,213	6m8s	303ms
	05	81	23s493ms	290ms
	06	1,009	5m	297ms
	07	86	25s330ms	294ms
	08	2	629ms	314ms
	09	63	20s709ms	328ms
	10	292	1m35s	326ms
	11	139	47s176ms	339ms
	12	131	44s459ms	339ms
	13	167	57s130ms	342ms
	14	1,514	7m1s	278ms
	15	713	3m32s	297ms
	16	336	1m42s	306ms
	17	2,011	10m37s	317ms
	18	1,340	7m3s	316ms
	19	2,456	12m49s	313ms
	20	1,718	8m42s	304ms
	21	1,658	8m29s	307ms
	22	1,113	5m33s	299ms

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

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

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

Date: 2025-01-02 20:56:57 Duration: 454ms

11

48m26s

13,663

Details

177ms

433ms

212ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 02	00	125	24s854ms	198ms
	01	416	1m23s	199ms
	02	118	23s114ms	195ms
	03	135	27s249ms	201ms
	04	199	39s485ms	198ms
	05	218	43s848ms	201ms
	06	1,376	4m34s	199ms
	07	498	1m39s	200ms
	08	876	2m56s	201ms
	09	1,778	6m13s	210ms
	10	537	1m53s	210ms
	11	1,127	4m22s	233ms
	12	1,366	5m3s	221ms
	13	801	2m59s	224ms
	14	254	55s351ms	217ms
	15	1,455	5m24s	223ms
	16	372	1m16s	204ms
	17	208	44s423ms	213ms
	18	140	28s587ms	204ms
	19	217	42s491ms	195ms
	20	921	3m28s	226ms
	21	242	47s239ms	195ms
	22	284	55s341ms	194ms

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

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

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

Date: 2025-01-02 11:26:07 Duration: 346ms

12

46m29s

57,429

Details

36ms

257ms

48ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 02	00	69	3s246ms	47ms
	01	89	4s86ms	45ms
	02	11	510ms	46ms
	05	26	1s187ms	45ms
	06	57	2s669ms	46ms
	07	27	1s233ms	45ms
	08	1,605	1m11s	44ms
	09	6,274	4m48s	46ms
	10	2,650	2m4s	46ms
	11	6,560	5m43s	52ms
	12	4,290	3m30s	49ms
	13	13,342	10m57s	49ms
	14	6,338	5m9s	48ms
	15	6,764	5m27s	48ms
	16	3,678	2m48s	45ms
	17	4,101	3m18s	48ms
	18	516	25s393ms	49ms
	19	408	20s191ms	49ms
	20	290	14s167ms	48ms
	21	234	11s597ms	49ms
	22	100	4s793ms	47ms

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

Date: 2025-01-02 11:24:14 Duration: 257ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4105922) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:24:17 Duration: 246ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4096259) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:24:09 Duration: 236ms

13

39m10s

11,730

Details

177ms

248ms

200ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,055	3m28s	197ms
	01	1,741	5m47s	199ms
	02	2,194	7m21s	201ms
	03	2,281	7m38s	200ms
	04	2,330	7m45s	199ms
	05	1,644	5m30s	200ms
	06	485	1m38s	203ms

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

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

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

Date: 2025-01-02 02:06:02 Duration: 246ms

14

36m28s

21,000

Details

81ms

238ms

104ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 02	00	46	4s674ms	101ms
	01	52	5s261ms	101ms
	06	49	4s918ms	100ms
	07	40	3s874ms	96ms
	08	167	16s639ms	99ms
	09	1,312	2m11s	100ms
	10	1,868	3m9s	101ms
	11	2,316	4m15s	110ms
	12	2,048	3m40s	107ms
	13	3,104	5m39s	109ms
	14	2,045	3m31s	103ms
	15	1,969	3m24s	103ms
	16	1,441	2m22s	98ms
	17	1,050	1m50s	104ms
	18	891	1m32s	103ms
	19	1,650	2m41s	98ms
	20	439	44s315ms	100ms
	21	149	16s97ms	108ms
	22	364	34s867ms	95ms

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

Date: 2025-01-02 17:22:47 Duration: 238ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7923378)) AND (("cash_track"."id" not in (6504647)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-02 11:15:11 Duration: 231ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7921663)) AND (("cash_track"."id" not in (6492346, 6493390, 6493710, 6505149, 6505151, 6505151)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-02 11:24:38 Duration: 218ms

15

20m57s

5,746

Details

182ms

415ms

218ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 02	05	126	24s792ms	196ms
	06	448	1m29s	200ms
	07	30	5s893ms	196ms
	08	215	43s555ms	202ms
	09	375	1m16s	205ms
	10	128	27s103ms	211ms
	11	1,548	5m55s	229ms
	12	661	2m27s	222ms
	13	253	59s889ms	236ms
	14	264	57s403ms	217ms
	15	1,324	4m51s	220ms
	16	374	1m16s	205ms

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

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

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

Date: 2025-01-02 11:15:18 Duration: 340ms

16

16m10s

22,223

Details

33ms

84ms

43ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 02	08	774	31s644ms	40ms
	09	2,301	1m35s	41ms
	10	1,683	1m11s	42ms
	11	2,904	2m11s	45ms
	12	1,991	1m29s	44ms
	13	4,089	3m4s	45ms
	14	2,490	1m49s	44ms
	15	2,936	2m7s	43ms
	16	1,729	1m12s	42ms
	17	1,326	57s458ms	43ms

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

Date: 2025-01-02 15:17:24 Duration: 84ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4040703) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:26:04 Duration: 83ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4030765) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:26:03 Duration: 81ms

17

15m40s

3,453

Details

192ms

389ms

272ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 02	09	222	56s884ms	256ms
	10	53	13s220ms	249ms
	11	369	1m45s	286ms
	12	554	2m32s	275ms
	13	234	1m8s	292ms
	14	264	1m12s	273ms
	15	1,414	6m24s	272ms
	16	343	1m26s	253ms

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

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

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

Date: 2025-01-02 15:14:03 Duration: 364ms

18

14m10s

5,659

Details

121ms

1s77ms

150ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 02	00	27	3s564ms	132ms
	01	10	1s294ms	129ms
	02	19	2s494ms	131ms
	08	46	6s236ms	135ms
	09	405	56s763ms	140ms
	10	722	1m42s	141ms
	11	1,288	3m34s	166ms
	12	827	2m4s	150ms
	13	685	1m44s	152ms
	14	400	59s975ms	149ms
	15	437	1m3s	146ms
	16	235	32s157ms	136ms
	17	177	25s190ms	142ms
	18	129	18s220ms	141ms
	19	96	13s382ms	139ms
	20	79	11s439ms	144ms
	21	42	5s867ms	139ms
	22	35	4s693ms	134ms

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

Date: 2025-01-02 11:15:12 Duration: 1s77ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 60)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

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

Date: 2025-01-02 11:22:30 Duration: 806ms

19

13m9s

305

Details

27ms

4s433ms

2s589ms

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

Day	Hour	Count	Duration	Avg duration
Jan 02	09	32	1m20s	2s515ms
	10	6	20s813ms	3s468ms
	11	5	7s600ms	1s520ms
	12	10	21s889ms	2s188ms
	13	31	59s342ms	1s914ms
	14	25	51s560ms	2s62ms
	15	24	1m5s	2s748ms
	16	37	1m13s	1s993ms
	17	31	1m21s	2s614ms
	18	17	57s831ms	3s401ms
	19	51	2m47s	3s277ms
	20	25	1m10s	2s812ms
	21	10	28s914ms	2s891ms
	22	1	3s163ms	3s163ms

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

Date: 2025-01-02 20:58:36 Duration: 4s433ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79))))))) 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 (79)))))) 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 ("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 ("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"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))))) AND ("policy_number"."name"::text ilike '%97766%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-02 20:58:36 Duration: 4s356ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79))))))) 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 (79)))))) 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 ("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 ("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"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))))) AND ("policy_number"."name"::text ilike '%977%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-02 20:58:34 Duration: 4s356ms

20

12m44s

2,919

Details

16ms

1s378ms

261ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 02	00	3	459ms	153ms
	04	2	286ms	143ms
	06	2	315ms	157ms
	07	8	2s48ms	256ms
	08	53	7s569ms	142ms
	09	154	32s409ms	210ms
	10	240	53s99ms	221ms
	11	320	1m33s	291ms
	12	401	1m42s	255ms
	13	411	1m52s	274ms
	14	359	1m44s	290ms
	15	269	1m16s	283ms
	16	196	48s772ms	248ms
	17	143	39s285ms	274ms
	18	122	23s961ms	196ms
	19	105	29s613ms	282ms
	20	60	15s953ms	265ms
	21	49	12s138ms	247ms
	22	22	9s457ms	429ms

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

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

Date: 2025-01-02 11:24:04 Duration: 959ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (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)))))) LIMIT 10001) t;

Date: 2025-01-02 11:10:13 Duration: 897ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,486,819

Details

1m58s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 02	00	43,000	1s815ms	0ms
	01	42,284	1s809ms	0ms
	02	37,321	1s409ms	0ms
	03	34,223	1s290ms	0ms
	04	33,143	1s300ms	0ms
	05	33,121	1s210ms	0ms
	06	29,513	1s113ms	0ms
	07	28,105	937ms	0ms
	08	60,632	2s682ms	0ms
	09	150,904	6s671ms	0ms
	10	194,704	9s325ms	0ms
	11	231,687	10s895ms	0ms
	12	218,031	10s472ms	0ms
	13	226,080	11s119ms	0ms
	14	190,646	9s552ms	0ms
	15	188,461	9s630ms	0ms
	16	181,177	9s52ms	0ms
	17	150,760	7s375ms	0ms
	18	123,209	6s753ms	0ms
	19	107,383	5s328ms	0ms
	20	78,335	4s93ms	0ms
	21	60,597	2s893ms	0ms
	22	43,503	2s108ms	0ms

DISCARD ALL;

Date: 2025-01-02 20:51:26 Duration: 1ms
DISCARD ALL;

Date: 2025-01-02 19:45:28 Duration: 1ms
DISCARD ALL;

Date: 2025-01-02 20:54:48 Duration: 1ms

2

1,946,803

Details

27s499ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 02	00	31,646	448ms	0ms
	01	30,807	443ms	0ms
	02	26,419	362ms	0ms
	03	24,434	329ms	0ms
	04	24,485	332ms	0ms
	05	24,183	315ms	0ms
	06	21,099	299ms	0ms
	07	20,784	269ms	0ms
	08	47,751	665ms	0ms
	09	123,502	1s592ms	0ms
	10	158,948	2s86ms	0ms
	11	190,481	2s622ms	0ms
	12	175,985	2s391ms	0ms
	13	181,229	2s522ms	0ms
	14	146,061	2s81ms	0ms
	15	145,811	2s82ms	0ms
	16	139,329	1s836ms	0ms
	17	118,005	1s699ms	0ms
	18	94,734	1s538ms	0ms
	19	82,736	1s276ms	0ms
	20	59,830	1s6ms	0ms
	21	45,745	758ms	0ms
	22	32,799	537ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

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

Date: 2025-01-02 10:10:33 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-02 11:29:21 Duration: 0ms

3

1,266,507

Details

12s481ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 02	00	22,125	189ms	0ms
	01	21,766	187ms	0ms
	02	19,215	166ms	0ms
	03	17,687	157ms	0ms
	04	17,156	158ms	0ms
	05	17,148	147ms	0ms
	06	15,403	131ms	0ms
	07	14,639	114ms	0ms
	08	31,255	277ms	0ms
	09	76,805	722ms	0ms
	10	98,578	955ms	0ms
	11	117,575	1s248ms	0ms
	12	110,533	1s98ms	0ms
	13	114,640	1s183ms	0ms
	14	96,590	970ms	0ms
	15	95,821	959ms	0ms
	16	91,840	855ms	0ms
	17	76,371	759ms	0ms
	18	62,746	647ms	0ms
	19	54,655	562ms	0ms
	20	40,277	432ms	0ms
	21	31,411	326ms	0ms
	22	22,271	228ms	0ms

ROLLBACK;

Date: 2025-01-02 13:04:24 Duration: 0ms
ROLLBACK;

Date: 2025-01-02 20:26:12 Duration: 0ms
ROLLBACK;

Date: 2025-01-02 17:42:37 Duration: 0ms

4

1,253,692

Details

3m34s

0ms

19ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 02	00	21,480	3s185ms	0ms
	01	21,138	3s222ms	0ms
	02	18,554	2s997ms	0ms
	03	17,086	2s779ms	0ms
	04	16,535	2s797ms	0ms
	05	16,538	2s472ms	0ms
	06	14,768	2s325ms	0ms
	07	14,057	1s815ms	0ms
	08	30,644	4s754ms	0ms
	09	76,310	12s452ms	0ms
	10	98,655	15s627ms	0ms
	11	117,030	20s358ms	0ms
	12	110,288	18s425ms	0ms
	13	114,212	19s508ms	0ms
	14	96,077	16s462ms	0ms
	15	95,094	15s758ms	0ms
	16	91,321	13s612ms	0ms
	17	75,886	13s877ms	0ms
	18	62,136	12s489ms	0ms
	19	54,055	10s846ms	0ms
	20	39,429	8s135ms	0ms
	21	30,580	6s432ms	0ms
	22	21,819	4s457ms	0ms

SELECT payload FROM http_sessions WHERE sid = '2eaae94ff68f8fd67d66a0615ef2a93d974cfa66';

Date: 2025-01-02 20:58:12 Duration: 19ms
SELECT payload FROM http_sessions WHERE sid = '56c5644937b6f31e4eb9f349a63010971a190030';

Date: 2025-01-02 11:16:28 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = '56c5644937b6f31e4eb9f349a63010971a190030';

Date: 2025-01-02 11:16:28 Duration: 16ms

5

1,243,379

Details

1m50s

0ms

17ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 02	00	21,572	1s746ms	0ms
	01	21,234	1s722ms	0ms
	02	18,700	1s533ms	0ms
	03	17,191	1s456ms	0ms
	04	16,657	1s450ms	0ms
	05	16,636	1s337ms	0ms
	06	14,812	1s191ms	0ms
	07	14,127	1s8ms	0ms
	08	30,312	2s454ms	0ms
	09	75,339	6s380ms	0ms
	10	97,303	8s378ms	0ms
	11	115,746	10s702ms	0ms
	12	108,942	9s556ms	0ms
	13	112,919	9s996ms	0ms
	14	95,304	8s696ms	0ms
	15	94,166	8s512ms	0ms
	16	90,536	7s556ms	0ms
	17	75,339	6s988ms	0ms
	18	61,620	5s880ms	0ms
	19	53,689	5s43ms	0ms
	20	39,169	3s662ms	0ms
	21	30,279	2s854ms	0ms
	22	21,787	2s50ms	0ms

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

Date: 2025-01-02 12:01:48 Duration: 17ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-02 16:15:21 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-02 10:39:13 Duration: 1ms

6

883,636

Details

2m16s

0ms

11ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 02	00	12,348	1s848ms	0ms
	01	10,812	1s766ms	0ms
	02	8,078	1s313ms	0ms
	03	7,741	1s118ms	0ms
	04	8,387	1s247ms	0ms
	05	8,112	1s183ms	0ms
	06	6,599	1s53ms	0ms
	07	7,337	1s110ms	0ms
	08	22,183	3s99ms	0ms
	09	62,185	9s163ms	0ms
	10	79,299	12s215ms	0ms
	11	97,637	14s772ms	0ms
	12	87,221	13s550ms	0ms
	13	88,379	14s700ms	0ms
	14	65,658	10s599ms	0ms
	15	64,969	10s229ms	0ms
	16	61,328	8s955ms	0ms
	17	53,758	7s837ms	0ms
	18	40,884	6s243ms	0ms
	19	35,286	5s287ms	0ms
	20	24,665	4s201ms	0ms
	21	17,588	2s861ms	0ms
	22	13,182	2s64ms	0ms

SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (901);

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

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

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

7

679,677

Details

1m57s

0ms

36ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 02	00	9,522	1s784ms	0ms
	01	9,040	1s790ms	0ms
	02	7,142	1s384ms	0ms
	03	6,745	1s433ms	0ms
	04	7,328	1s563ms	0ms
	05	7,036	1s330ms	0ms
	06	5,696	1s79ms	0ms
	07	6,146	950ms	0ms
	08	16,487	2s526ms	0ms
	09	46,634	7s256ms	0ms
	10	60,335	9s247ms	0ms
	11	72,803	13s514ms	0ms
	12	65,378	11s47ms	0ms
	13	66,532	11s699ms	0ms
	14	49,436	8s618ms	0ms
	15	49,961	8s384ms	0ms
	16	47,441	7s92ms	0ms
	17	41,588	7s157ms	0ms
	18	32,001	5s923ms	0ms
	19	28,049	5s279ms	0ms
	20	19,550	3s749ms	0ms
	21	14,298	3s79ms	0ms
	22	10,529	2s60ms	0ms

COMMIT;

Date: 2025-01-02 12:07:59 Duration: 36ms
COMMIT;

Date: 2025-01-02 14:37:23 Duration: 36ms
COMMIT;

Date: 2025-01-02 17:28:53 Duration: 34ms

8

534,157

Details

1m10s

0ms

4ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 02	00	7,898	942ms	0ms
	01	6,279	729ms	0ms
	02	4,436	549ms	0ms
	03	3,746	486ms	0ms
	04	4,683	574ms	0ms
	05	3,234	450ms	0ms
	06	3,841	453ms	0ms
	07	2,977	332ms	0ms
	08	12,016	1s626ms	0ms
	09	38,355	5s559ms	0ms
	10	48,153	6s105ms	0ms
	11	56,357	8s879ms	0ms
	12	51,118	7s217ms	0ms
	13	51,652	7s85ms	0ms
	14	38,019	5s16ms	0ms
	15	37,023	4s729ms	0ms
	16	36,329	4s517ms	0ms
	17	35,362	4s386ms	0ms
	18	28,951	3s295ms	0ms
	19	24,582	2s904ms	0ms
	20	17,964	1s990ms	0ms
	21	11,735	1s526ms	0ms
	22	9,447	1s50ms	0ms

SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099013, 5099528, 5099196, 5100421, 5099139, 5100181, 5117141, 5100821, 5099693, 5099867, 5099045, 5099246, 5099032, 5099009, 5101388, 5099251, 5100854, 5099007, 5105186, 5107065, 5113138, 5098989, 5102865, 5099008, 5099244, 5099037, 5099129, 5099014, 5099128, 5102367, 5099006, 5121048);

Date: 2025-01-02 17:21:55 Duration: 4ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5265192, 5263333, 5173494, 5153011, 5437025, 5155782, 5448359, 5460177, 5460483, 5312271, 5454870, 5409988, 5230170, 5436682, 5296305, 5155214, 5452943, 5452942, 5454456, 5449265, 5230685, 5259724, 5191759, 5440258, 5190356, 5200633, 5175952, 5453324, 5453031, 5193784, 5455542, 5341068, 5444314, 5160880, 5138906, 5313129, 5454265, 5366214, 5454245, 5219977, 5412770, 5218341, 5196238, 5449798, 5304869, 5359241, 5164867, 5444266, 5162414, 5449064, 5447661, 5412934, 5442892, 5442891, 5444730, 5450227, 5449736, 5365370, 5447421, 5244336, 5444348, 5399431, 5443442, 5147874, 5148661, 5424014, 5202873, 5331154, 5273957, 5258863, 5440310, 5412758, 5207221, 5441749, 5445868, 5444895, 5445182, 5373470, 5441426, 5436661, 5430085, 5441816, 5441815, 5441841, 5416484, 5152220, 5272620, 5443185, 5262056, 5437060, 5162321, 5443040, 5188422, 5440843, 5278729, 5441710, 5153237, 5440423, 5290667, 5287740, 5438501, 5438985, 5194644, 5285393, 5188112, 5197692, 5178213, 5411013, 5169424, 5434463, 5315251, 5198445, 5390084, 5205015, 5436386, 5436352, 5277500, 5434282, 5155737, 5436772, 5303793, 5327867, 5270953, 5435367, 5153187, 5201830, 5432159, 5265113, 5284236, 5434112, 5236459, 5432108, 5434654, 5224286, 5391935, 5210060, 5135498, 5241003, 5155645, 5431445, 5285863, 5322589, 5430368, 5299296, 5431318, 5382179, 5430520, 5201007, 5189375, 5429761, 5192779, 5428430, 5205884, 5344112, 5427358, 5154027, 5281234, 5428987, 5207020, 5427394, 5204740, 5224536, 5197499, 5427548, 5147293, 5401668, 5149437, 5425883, 5189185, 5418357, 5172409, 5316776, 5349146, 5409598, 5141671, 5226739, 5415680, 5323671, 5300251, 5348344, 5425081, 5416863, 5135521, 5414470, 5417033, 5379077, 5392112, 5416910, 5416981, 5418749, 5419490, 5382202, 5409562, 5416982, 5418226, 5136355, 5410488, 5410487, 5413771, 5412014, 5169853, 5322757, 5169071, 5411269, 5415120, 5155386, 5237632, 5210842, 5416277, 5411026, 5331509, 5285570, 5211638, 5179403, 5371477, 5278495, 5197627, 5406791, 5394763, 5412585, 5274983, 5159924, 5183366, 5412326, 5406111, 5413210, 5411071, 5410053, 5410051, 5288087, 5407185, 5407682, 5411166, 5362772, 5198482, 5139373, 5406220, 5209686, 5278694, 5236942, 5267316, 5137263, 5157305, 5193587, 5394158, 5399985, 5390083, 5168367, 5261283, 5403735, 5177712, 5406341, 5176168, 5407059, 5405051, 5178480, 5146420, 5148331, 5335698, 5185631, 5172193, 5165465, 5399849, 5167731, 5258619, 5357050, 5399189, 5357833, 5402326, 5398740, 5402199, 5400444, 5401338, 5401612, 5379583, 5403208, 5146928, 5389326, 5401903, 5402932, 5149607, 5250597, 5201013, 5201437, 5173236, 5206373, 5223223, 5374437, 5397983, 5263438, 5398336, 5393962, 5164802, 5362251, 5391847, 5388700, 5134271, 5369299, 5176356, 5217130, 5200752, 5167230, 5305794, 5393010, 5201514, 5389731, 5386974, 5387540, 5393938, 5394606, 5389959, 5175313, 5308571, 5393992, 5165781, 5329276, 5206392, 5206465, 5356856, 5392313, 5201609, 5383437, 5388793, 5253584, 5385589, 5383714, 5153919, 5367120, 5372872, 5230823, 5271898, 5375574, 5387841, 5192220, 5287690, 5383565, 5282372, 5139876, 5365587, 5187560, 5382321, 5237422, 5367929, 5321152, 5172965, 5377009, 5377699, 5232598, 5354212, 5353994, 5378823, 5378821, 5381598, 5188684, 5247982, 5149252, 5198278, 5138436, 5160799, 5193304, 5203998, 5153453, 5378641, 5173591, 5374580, 5260514, 5220686, 5367092, 5371887, 5182314, 5324064, 5375829, 5235815, 5372151, 5375308, 5373932, 5368234, 5258351, 5363558, 5364029, 5335045, 5352998, 5371879, 5369612, 5348097, 5368932, 5322866, 5370539, 5161568, 5369477, 5268226, 5359081, 5362736, 5152801, 5348758, 5263571, 5371620, 5364774, 5179625, 5350340, 5313959, 5281954, 5146322, 5363696, 5144163, 5361401, 5259062, 5288130, 5203921, 5368510, 5364297, 5331425, 5351606, 5363556, 5358893, 5358685, 5357480, 5246491, 5138986, 5349644, 5362629, 5168871, 5273175, 5195057, 5232794, 5319346, 5279592, 5343687, 5316710, 5251269, 5359908, 5230125, 5321157, 5355938, 5355937, 5357156, 5359581, 5160241, 5352135, 5346221, 5354043, 5350374, 5211480, 5357323, 5161763, 5250294, 5355220, 5143019, 5348915, 5323140, 5354288, 5153348, 5238780, 5352707, 5351617, 5265190, 5138720, 5275328, 5339192, 5273802, 5351660, 5249701, 5355878, 5285022, 5355266, 5351747, 5178766, 5343312, 5343311, 5182476, 5348653, 5354669, 5350939, 5167760, 5164587, 5256455, 5345461, 5347995, 5350617, 5180627, 5190012, 5348195, 5138499, 5140039, 5349173, 5248412, 5349892, 5349100, 5349099, 5339432, 5200726, 5245230, 5160129, 5248963, 5341713, 5347219, 5346713, 5252512, 5345988, 5193390, 5339542, 5337259, 5343960, 5346219, 5346578, 5346577, 5305396, 5282319, 5343761, 5322972, 5343878, 5193472, 5231271, 5337759, 5223893, 5138540, 5341539, 5324511, 5210549, 5300869, 5254762, 5218544, 5339108, 5333723, 5338304, 5336012, 5257146, 5333516, 5333515, 5326690, 5333730, 5335183, 5305036, 5335301, 5333805, 5225313, 5200120, 5162676, 5332072, 5218463, 5331429, 5334713, 5268009, 5319538, 5329371, 5334089, 5334515, 5331554, 5332032, 5266449, 5331730, 5216674, 5153696, 5206309, 5213470, 5140317, 5328908, 5168787, 5203671, 5326496, 5326807, 5244767, 5150219, 5180299, 5327641, 5183009, 5154940, 5327309, 5250356, 5273738, 5329903, 5261780, 5163477, 5330447, 5153758, 5153009, 5173439, 5326697, 5170221, 5328871, 5328870, 5319547, 5253962, 5140728, 5327866, 5321193, 5323676, 5286961, 5268246, 5184922, 5261965, 5297571, 5320705, 5322767, 5137154, 5325079, 5304150, 5313051, 5314356, 5185748, 5304443, 5321546, 5227433, 5325648, 5320523, 5169933, 5136862, 5163936, 5319349, 5321523, 5206272, 5187602, 5284857, 5284856, 5168817, 5198044, 5165467, 5166203, 5318864, 5301608, 5247330, 5312209, 5312202, 5213868, 5318337, 5315189, 5317491, 5220039, 5310740, 5206134, 5170240, 5314441, 5313173, 5313045, 5245405, 5316143, 5209709, 5222811, 5271201, 5247980, 5220797, 5228594, 5306985, 5147290, 5303203, 5303202, 5311318, 5148390, 5226348, 5218600, 5292034, 5288217, 5311142, 5311112, 5313617, 5268236, 5149762, 5234126, 5284864, 5304640, 5304639, 5220786, 5298166, 5311332, 5278207, 5288250, 5314128, 5258400, 5310973, 5269622, 5308104, 5257634, 5180620, 5305034, 5309682, 5303518, 5306768, 5303503, 5308619, 5304629, 5203512, 5220285, 5221817, 5245387, 5306562, 5189101, 5152517, 5302135, 5285770, 5305613, 5300036, 5302549, 5303457, 5304647, 5234167, 5237624, 5155521, 5307356, 5302447, 5299781, 5262385, 5300205, 5176867, 5300384, 5301505, 5301598, 5301507, 5290731, 5303813, 5251988, 5296033, 5297485, 5158822, 5302223, 5282843, 5294826, 5301506, 5294846, 5155763, 5184571, 5290748, 5273262, 5287070, 5224853, 5243821, 5266830, 5227199, 5264219, 5280790, 5189906, 5287424, 5198569, 5188461, 5273886, 5268569, 5283772, 5250104, 5278770, 5181179, 5259230, 5287577, 5284966, 5284218, 5149375, 5279164, 5278110, 5278109, 5159476, 5273609, 5221842, 5245214, 5260816, 5261897, 5270613, 5217345, 5174030, 5267796, 5276023, 5146685, 5210805, 5277487, 5279924, 5206485, 5280891, 5278507, 5185044, 5244772, 5271044, 5271043, 5174080, 5207899, 5263970, 5172778, 5137888, 5208314, 5268542, 5139482, 5251146, 5271944, 5267814, 5171199, 5265615, 5268591, 5197387, 5272485, 5167761, 5265889, 5175390, 5265085, 5265614, 5242866, 5265103, 5260547, 5231154, 5259169, 5177701, 5179852, 5265812, 5263014, 5264929, 5254686, 5258658, 5258657, 5135520, 5260805, 5205363, 5263058, 5263359, 5250044, 5256831, 5260995, 5261271, 5157440, 5253733, 5247334, 5236948, 5202335, 5257667, 5153080, 5167654, 5243200, 5257471, 5251083, 5136656, 5168474, 5136298, 5178561, 5259396, 5232580, 5196551, 5251681, 5211913, 5220611, 5247698, 5247705, 5167506, 5238410, 5238409, 5241418, 5249220, 5190030, 5209386, 5224990, 5235457, 5156238, 5205361, 5191581, 5251195, 5250139, 5251190, 5244540, 5246237, 5246256, 5246512, 5173926, 5247034, 5196223, 5241581, 5244308, 5244510, 5237244, 5239948, 5237602, 5239045, 5231684, 5235645, 5233273, 5244859, 5239965, 5196406, 5241157, 5217134, 5171444, 5185364, 5186267, 5174628, 5188862, 5236878, 5233227, 5230935, 5205176, 5168958, 5236327, 5230027, 5230015, 5193782, 5232799, 5200046, 5230556, 5233348, 5231665, 5231679, 5159396, 5194175, 5196739, 5221137, 5229096, 5183552, 5227543, 5188445, 5227772, 5228362, 5225321, 5203470, 5220630, 5219849, 5221659, 5220720, 5217131, 5219314, 5212558, 5215925, 5217043, 5184891, 5223950, 5167229, 5204153, 5163375, 5220771, 5214102, 5217625, 5215329, 5210354, 5203381, 5187748, 5220508, 5208710, 5179816, 5209715, 5210596, 5204793, 5206978, 5171696, 5194678, 5210116, 5181404, 5193891, 5171075, 5209767, 5206837, 5203330, 5147042, 5195314, 5176245, 5202018, 5200785, 5203993, 5194302, 5203907, 5190459, 5189496, 5201596, 5194307, 5153379, 5173783, 5184872, 5198517, 5184972, 5187579, 5197147, 5198524, 5198523, 5188606, 5181705, 5199140, 5191025, 5194439, 5154951, 5197901, 5198387, 5188963, 5194303, 5194304, 5162331, 5184331, 5186531, 5188307, 5187698, 5191044, 5183305, 5178413, 5184505, 5186107, 5180602, 5185166, 5180244, 5184371, 5175911, 5181996, 5182312, 5175693, 5180482, 5178503, 5155384, 5172437, 5181454, 5152501, 5138683, 5161529, 5160248);

Date: 2025-01-02 14:57:30 Duration: 4ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5148570, 5148571, 5154648, 5155496, 5161758, 5171988, 5168720, 5158823, 5169365, 5134271, 5174560, 5174848, 5174849, 5166592, 5179738, 5180641, 5182534, 5172428, 5198583, 5198585, 5173485, 5204447, 5205320, 5251404, 5152012, 5277913, 5324789, 5327105, 5338133, 5141949, 5378510, 5380275, 5244767, 5432263, 5224909, 5352738, 5228264, 5312516, 5419841, 5179483, 5173606, 5236320, 5146027, 5356683, 5303366, 5346044, 5346046, 5193472, 5184434, 5168817, 5184224, 5203201, 5396586, 5181049, 5299244, 5164232, 5385361, 5228304, 5174077, 5143812, 5207119, 5281232, 5311129, 5370705, 5212263, 5454048, 5441215, 5190116, 5189216, 5382106, 5414617, 5247251, 5382750, 5318063, 5218140, 5331425, 5179910, 5219616, 5173120, 5399423, 5409959, 5236457, 5262495, 5243204, 5248978, 5220942, 5315905, 5235252, 5243853, 5258619, 5211359, 5144861, 5231253, 5412896, 5347370, 5179549, 5279592, 5189375, 5288507, 5314448, 5410538, 5311361, 5297602, 5164691, 5224295, 5446056, 5392157, 5170470, 5417167, 5209712, 5209372, 5144150, 5146686, 5166312, 5165168, 5318225, 5150988, 5247404, 5150270, 5305191, 5323337, 5380712, 5263994, 5239916, 5176168, 5231714, 5137037, 5223400, 5371556, 5237703, 5239810, 5138424, 5393931, 5339487, 5451546, 5138820, 5202545, 5244509, 5431492, 5219311, 5240797, 5240798, 5253385, 5263101, 5153009, 5146420, 5279243, 5296355, 5265113, 5314789, 5439084, 5191982, 5461098, 5368910, 5396537, 5144659, 5208995, 5139923, 5369217, 5441156, 5348599, 5304158, 5148982, 5358295, 5220962, 5347736, 5216454, 5344972, 5277824, 5217385, 5148490, 5392443, 5197792, 5429389, 5381914, 5321824, 5214143, 5426690, 5193542, 5384493, 5140185, 5240777, 5434072, 5255375, 5137953, 5226852, 5310770, 5153250, 5329075, 5245231, 5385614, 5396884, 5159641, 5173436, 5173437, 5259254, 5148737, 5228888, 5158564, 5355518, 5154691, 5278865, 5278866, 5182726, 5347191, 5236173, 5442625, 5399901, 5320497, 5319307, 5253386, 5250557, 5337416, 5449532, 5224356, 5431127, 5219836, 5238603, 5255563, 5334037, 5262063, 5185748, 5304480, 5142319, 5171653, 5387659, 5339796, 5266064, 5257937, 5262877, 5187222, 5433992, 5205955, 5456177, 5194375, 5307367, 5180655, 5172174, 5398107, 5408191, 5319734, 5277085, 5290180, 5272742, 5172602, 5352952, 5168477, 5211911, 5296138, 5357993, 5330011, 5419300, 5338242, 5191318, 5164006, 5364692, 5137947, 5134553, 5138415, 5144106, 5137860, 5143810, 5148568, 5148630, 5155722, 5154744, 5148525, 5154763, 5152166, 5153371, 5153257, 5152233, 5155630, 5162249, 5165141, 5165171, 5161460, 5161146, 5170034, 5170901, 5162407, 5166273, 5172758, 5174481, 5177745, 5185834, 5185835, 5185483, 5185797, 5184101, 5184004, 5183269, 5179799, 5190211, 5187792, 5187025, 5189315, 5189317, 5187035, 5189983, 5191528, 5192321, 5164695, 5193264, 5197707, 5196446, 5189232, 5198686, 5200736, 5142608, 5202926, 5185197, 5201646, 5158006, 5204690, 5202278, 5180575, 5205985, 5189913, 5178645, 5205120, 5206706, 5149134, 5209218, 5209496, 5209678, 5209821, 5209822, 5209836, 5156164, 5177512, 5206495, 5217388, 5215620, 5216615, 5136889, 5219447, 5183214, 5219446, 5224697, 5225536, 5227331, 5183039, 5233829, 5233830, 5232565, 5237434, 5237057, 5238546, 5236529, 5239861, 5239014, 5150271, 5241168, 5150585, 5240853, 5242757, 5245541, 5227633, 5245680, 5230814, 5148958, 5247733, 5201695, 5135810, 5157115, 5247517, 5246447, 5246802, 5143732, 5247565, 5250785, 5208821, 5253000, 5251793, 5170996, 5252752, 5252753, 5252912, 5148195, 5188270, 5251709, 5253749, 5176253, 5198233, 5256664, 5221940, 5255888, 5254987, 5162162, 5236344, 5255321, 5257643, 5257644, 5259977, 5138922, 5262103, 5262443, 5262444, 5230445, 5262488, 5262792, 5265547, 5176436, 5265480, 5265352, 5264335, 5264099, 5266917, 5269196, 5267347, 5146580, 5271914, 5185735, 5272465, 5272006, 5171395, 5165088, 5272312, 5275527, 5194246, 5274399, 5160091, 5204428, 5273704, 5177554, 5271212, 5276105, 5278502, 5272179, 5276646, 5178543, 5281777, 5185651, 5281569, 5283277, 5283688, 5260452, 5284345, 5287699, 5286804, 5286771, 5286772, 5153695, 5288151, 5288152, 5291412, 5167761, 5291986, 5291864, 5160257, 5177455, 5295168, 5295372, 5151737, 5293085, 5293086, 5171665, 5296494, 5145416, 5221887, 5301179, 5299395, 5304138, 5302754, 5302755, 5301991, 5304784, 5304781, 5306841, 5305611, 5305554, 5251265, 5194629, 5217500, 5311336, 5252360, 5177174, 5310002, 5221168, 5313529, 5275452, 5161736, 5312073, 5313666, 5250798, 5171679, 5162900, 5220113, 5245496, 5163581, 5292965, 5316325, 5214233, 5318236, 5255278, 5272297, 5158108, 5321267, 5173930, 5212951, 5320241, 5320242, 5147288, 5320489, 5320712, 5320953, 5155743, 5322990, 5323202, 5323663, 5323664, 5324533, 5324633, 5163337, 5197929, 5323553, 5323554, 5323636, 5232334, 5202335, 5329498, 5205043, 5135885, 5211847, 5294703, 5331497, 5331942, 5253737, 5197589, 5204417, 5231361, 5333754, 5137579, 5336278, 5337300, 5336484, 5338356, 5336836, 5209123, 5338942, 5282919, 5339318, 5338872, 5341245, 5171270, 5328364, 5183041, 5340875, 5341182, 5340817, 5340400, 5342589, 5342590, 5343969, 5327502, 5150731, 5164617, 5342461, 5345775, 5346563, 5346564, 5346025, 5315316, 5345161, 5346951, 5324632, 5348892, 5348439, 5165138, 5198423, 5349581, 5296876, 5208999, 5340881, 5350968, 5262283, 5353305, 5225547, 5353014, 5155771, 5162579, 5350788, 5353992, 5355121, 5355103, 5357368, 5253818, 5357140, 5215863, 5356648, 5356649, 5278064, 5229506, 5360162, 5191272, 5222019, 5364226, 5363899, 5158043, 5363996, 5363122, 5267311, 5331304, 5256433, 5170968, 5263094, 5365320, 5136861, 5193643, 5234914, 5368833, 5368834, 5368209, 5181036, 5168333, 5199747, 5370593, 5161879, 5149519, 5372606, 5308599, 5140574, 5375157, 5150538, 5193389, 5377993, 5381918, 5382169, 5351500, 5322365, 5381704, 5165111, 5189198, 5198123, 5382766, 5384095, 5384096, 5211054, 5388453, 5386977, 5389128, 5387184, 5386465, 5390051, 5189895, 5392279, 5390768, 5160910, 5230754, 5391654, 5211169, 5390457, 5158209, 5184494, 5230170, 5139547, 5393464, 5395608, 5233412, 5272031, 5169027, 5190195, 5395465, 5396876, 5397029, 5397671, 5399274, 5399275, 5228980, 5146959, 5160880, 5400122, 5401528, 5181789, 5292545, 5199937, 5403450, 5193514, 5404286, 5405219, 5405208, 5405312, 5407196, 5182674, 5408227, 5407966, 5147552, 5206940, 5407675, 5146557, 5249970, 5410111, 5139617, 5412833, 5361198, 5183219, 5414230, 5414231, 5414661, 5159746, 5414756, 5414351, 5230851, 5415856, 5417536, 5334586, 5183144, 5424660, 5262255, 5198491, 5423555, 5176089, 5425778, 5425419, 5150064, 5425112, 5427248, 5194445, 5172128, 5176444, 5427349, 5427464, 5160898, 5260514, 5429151, 5202737, 5430395, 5249045, 5430800, 5432924, 5431949, 5273023, 5433836, 5165676, 5198651, 5158961, 5212235, 5326687, 5150730, 5157641, 5438593, 5438004, 5359177, 5308796, 5412493, 5198036, 5440764, 5440765, 5214263, 5442347, 5228372, 5442128, 5230731, 5444466, 5376815, 5148440, 5444632, 5445076, 5445569, 5439547, 5189880, 5183211, 5446926, 5446924, 5446925, 5349006, 5439680, 5253164, 5278102, 5264586, 5449833, 5448614, 5449407, 5142284, 5449232, 5307338, 5351270, 5335999, 5208791, 5449002, 5449638, 5451637, 5424795, 5220558, 5450256, 5189257, 5220807, 5208440, 5178969, 5334724, 5452185, 5156228, 5173116, 5452181, 5452842, 5332403, 5454023, 5155647, 5454808, 5309185, 5455311, 5456921, 5456980, 5418562, 5324217, 5173592, 5304523, 5401305, 5198488, 5458509, 5432744, 5459787, 5459921, 5205329, 5459391, 5459571, 5459572, 5200797);

Date: 2025-01-02 21:53:49 Duration: 3ms

9

530,396

Details

34s289ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 02	00	7,093	389ms	0ms
	01	5,339	297ms	0ms
	02	3,129	180ms	0ms
	03	2,843	166ms	0ms
	04	2,946	164ms	0ms
	05	2,751	153ms	0ms
	06	3,525	194ms	0ms
	07	4,328	233ms	0ms
	08	9,980	578ms	0ms
	09	35,637	2s231ms	0ms
	10	48,402	2s941ms	0ms
	11	56,845	4s310ms	0ms
	12	53,273	3s605ms	0ms
	13	53,112	3s711ms	0ms
	14	40,095	2s808ms	0ms
	15	38,213	2s586ms	0ms
	16	36,446	2s6ms	0ms
	17	35,607	2s207ms	0ms
	18	27,539	1s641ms	0ms
	19	25,011	1s486ms	0ms
	20	17,358	1s83ms	0ms
	21	11,840	751ms	0ms
	22	9,084	560ms	0ms

SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (60);

Date: 2025-01-02 14:38:19 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (17, 30, 66, 41, 64, 27, 11, 19, 24, 73);

Date: 2025-01-02 11:44:07 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (46, 27, 39, 64, 60, 17, 102, 4, 126, 19, 52, 119, 16, 61, 28, 26, 68);

Date: 2025-01-02 13:05:32 Duration: 1ms

10

366,072

Details

1m7s

0ms

10ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 02	00	4,412	742ms	0ms
	01	3,103	544ms	0ms
	02	1,995	384ms	0ms
	03	1,731	326ms	0ms
	04	1,911	364ms	0ms
	05	2,174	352ms	0ms
	06	2,112	374ms	0ms
	07	2,957	453ms	0ms
	08	9,696	1s425ms	0ms
	09	27,094	4s688ms	0ms
	10	33,597	5s975ms	0ms
	11	39,801	8s250ms	0ms
	12	36,290	6s962ms	0ms
	13	37,080	7s227ms	0ms
	14	28,478	5s401ms	0ms
	15	27,849	5s217ms	0ms
	16	26,079	4s448ms	0ms
	17	23,016	4s326ms	0ms
	18	17,610	3s217ms	0ms
	19	15,585	2s841ms	0ms
	20	10,534	1s912ms	0ms
	21	7,457	1s392ms	0ms
	22	5,511	984ms	0ms

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

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

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

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

11

342,974

Details

1m53s

0ms

2ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 02	00	3,061	909ms	0ms
	01	1,947	601ms	0ms
	02	2,061	651ms	0ms
	03	1,470	484ms	0ms
	04	1,534	487ms	0ms
	05	1,110	345ms	0ms
	06	1,588	487ms	0ms
	07	1,652	481ms	0ms
	08	6,515	1s943ms	0ms
	09	22,837	7s289ms	0ms
	10	27,382	8s900ms	0ms
	11	41,024	14s735ms	0ms
	12	35,007	11s968ms	0ms
	13	31,893	11s93ms	0ms
	14	30,375	10s327ms	0ms
	15	27,854	9s450ms	0ms
	16	24,160	7s327ms	0ms
	17	26,098	8s535ms	0ms
	18	13,368	4s423ms	0ms
	19	15,139	4s795ms	0ms
	20	13,870	4s324ms	0ms
	21	8,210	2s558ms	0ms
	22	4,819	1s523ms	0ms

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

Date: 2025-01-02 12:21:31 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'ir.ui.menu' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 838) OR r.global) ORDER BY r.id;

Date: 2025-01-02 09:07:31 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'delivery.method' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 889) OR r.global) ORDER BY r.id;

Date: 2025-01-02 11:15:24 Duration: 2ms

12

251,318

Details

44s62ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 02	00	2,455	339ms	0ms
	01	1,866	241ms	0ms
	02	1,986	272ms	0ms
	03	1,702	228ms	0ms
	04	1,848	229ms	0ms
	05	1,607	201ms	0ms
	06	1,464	200ms	0ms
	07	1,668	225ms	0ms
	08	7,283	1s22ms	0ms
	09	17,701	2s943ms	0ms
	10	19,004	3s270ms	0ms
	11	29,486	5s771ms	0ms
	12	23,808	4s452ms	0ms
	13	23,776	4s464ms	0ms
	14	21,175	3s951ms	0ms
	15	20,342	3s738ms	0ms
	16	16,692	2s658ms	0ms
	17	17,180	3s125ms	0ms
	18	9,544	1s593ms	0ms
	19	10,495	1s759ms	0ms
	20	9,476	1s643ms	0ms
	21	7,040	1s152ms	0ms
	22	3,720	579ms	0ms

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

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

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

Date: 2025-01-02 12:21:31 Duration: 2ms

13

247,789

Details

1m1s

0ms

17ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 02	00	3,286	809ms	0ms
	01	2,814	688ms	0ms
	02	2,200	630ms	0ms
	03	1,570	478ms	0ms
	04	2,381	702ms	0ms
	05	1,196	366ms	0ms
	06	2,147	580ms	0ms
	07	1,431	335ms	0ms
	08	4,688	1s189ms	0ms
	09	15,809	4s523ms	0ms
	10	20,287	5s521ms	0ms
	11	23,957	7s14ms	0ms
	12	22,286	5s572ms	0ms
	13	23,638	5s581ms	0ms
	14	20,112	4s658ms	0ms
	15	17,243	4s66ms	0ms
	16	16,413	3s697ms	0ms
	17	16,809	4s45ms	0ms
	18	14,122	3s243ms	0ms
	19	14,531	3s185ms	0ms
	20	9,508	2s216ms	0ms
	21	6,111	1s637ms	0ms
	22	5,250	1s172ms	0ms

SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (41659149, 40017600, 41440824, 41659148, 41659143, 41657921, 41657932, 41657933, 41700197, 41659151, 41761498, 40318398, 41566687, 41568981, 41761448, 41192974, 40318397, 41196541, 41658405, 41570554, 41570265, 41759783, 41568976, 41659147, 41656767, 41657935, 41760423, 41570260, 41737638, 41570508, 41700462, 41761476, 41661268, 41657116, 41570527, 41761156, 41760057, 41760486, 41656307, 41759862, 41658415, 41656527, 41658730, 41759928, 41657467, 41700020, 41760792, 41700195, 41570509, 41656317, 41760047, 41570505, 41658410, 41759848, 41440825, 41440731, 41761157, 41700196, 41656557, 41567696, 41657004, 41761155, 41569746, 41658731, 41657002, 41657527, 41658403, 41655783, 41657931, 41736716, 41439349, 41760007, 41759749, 41570262, 41372951, 41760018, 41442102, 41568984, 41737524, 41372970, 41657287, 41700192, 41372977, 41442283, 41371552, 41655787, 41658395, 41658406, 41656543, 41760064, 41760425, 41570259, 41760046, 41736707, 41570502, 41760016, 41633491, 41760420, 41737406, 41760146, 41569749, 41737528, 41759849, 41656997, 41193440, 41736708, 41657117, 41657448, 41656430, 41570264, 41760485, 41570266, 41570098, 41760354, 41656558, 41570553, 41659453, 41760014, 41570496, 41737637, 41656559, 41657156, 41657157, 41657922, 41658728, 41440814, 41737530, 41656236, 41440811, 41570494, 41657088, 41570501, 41570503, 41737522, 41760353, 41657929, 41372964, 41759786, 41440818, 41657854, 41657928, 41656917, 41657926, 41656839, 41760065, 41570099, 41440815, 41569311, 41657925, 41658715, 41440810, 41759752, 41659377, 41743043, 41657920, 41656724, 41440812, 41372984, 39385187, 41759753, 41656786, 41569310, 41440803, 41657390, 41759952, 41657387, 41657391, 41440808, 41657386, 32641525, 41736669, 41440806, 41659451, 41440801, 41656326, 41656787, 41657385, 41568107, 41657240, 41569582, 41372982, 41372983, 41657525, 41656978, 40317789, 41657389, 41656844, 41569295, 41657352, 41568539, 41656879, 41569274, 41569296, 41440798, 41442260, 41656273, 41440802, 41658593, 41283019, 41656799, 41440805, 41442261, 41283039, 41283036, 41442257, 41568954, 41655850, 41568958, 41568111, 41568956, 41568957, 41441635, 41283041, 41442253, 41440794, 41655796, 41568109, 41568955, 41655799, 41442258, 41020187, 41440793, 41441853, 41283013, 41568251, 41283012, 41442254, 41567593, 41283037, 41440792, 41567745, 41283033, 41441852, 41567746, 41440795, 41442252, 41439036, 41660179, 41567511, 41193521, 41442256, 41567253, 41567520, 41283393, 41566822, 41193522, 41371846, 41372755, 41374083, 41442255, 41440635, 41439732, 41372753, 41438807, 41438721, 41371120, 41282402, 41085798, 40824503, 40715355, 40430108, 39645124);

Date: 2025-01-02 13:23:58 Duration: 17ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (41941185, 41941183, 41941099, 41832362, 41940765, 41906851, 41821599, 41821601, 41786879, 41900737, 41962663, 41948382, 41859138, 41820471, 41585663, 41864072, 41747484, 41821176, 41863936, 41674282, 41841733, 41508754, 41509342, 41508749, 41744436, 41821148, 41715063, 41675053, 41675049, 41810039, 41673386, 41756406, 41756486, 41675185, 41746438, 41802648, 41762852, 41743397, 41925775, 41722132, 41722090, 41801616, 41890342, 41743394, 41890372, 41723383, 41890459, 41860892, 41859931, 41861564, 41941161, 41841700, 41941182, 41813027, 41887240, 41887213, 41895762, 41895757, 41850118, 41875463, 41467035, 41659116, 41762873, 41762145, 41659276, 41880322, 41902676, 41869916, 41815076, 41797779, 41804919, 41879046, 41878963, 41825131, 41625939, 41879072, 41754391, 41896116, 41897562, 41915279, 41915265, 41915243, 41770708, 41771651, 41577300, 41576149, 41576142, 41576626, 41913918, 41979680, 41914079, 41979655, 41675103, 41847317, 41913830, 41886439, 41841181, 41942958, 41892413, 41732121);

Date: 2025-01-02 17:22:00 Duration: 11ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (41372934, 41847052, 41502728, 41872472, 41878218, 41954661, 41756379, 41297821, 41868441, 41940751, 41298221, 41726569, 41611015, 41958845, 41076329, 41710375, 41577293, 41853063, 41936528, 41907286, 41940692, 41858876, 41852105, 41830298, 41837423, 41861500, 41837468, 41948401, 41843816, 41851758, 41869406, 41958774, 41888409, 41830480, 41891218, 41298491, 41772048, 41915260, 41385987, 41649537, 41675158, 41756288, 41812452, 41862255, 41848654, 41820076, 41858877, 41891135, 41853017, 41759217, 41928537, 41797954, 41674224, 41687515, 41885364, 41916849, 41418383, 41790675, 41089640, 41888017);

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

14

241,818

Details

1d9h17m6s

410ms

3s341ms

495ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 02	00	6,525	49m39s	456ms
	01	6,656	51m2s	460ms
	02	6,652	51m2s	460ms
	03	7,096	53m36s	453ms
	04	8,259	1h3m28s	461ms
	05	4,441	33m4s	446ms
	06	4,858	37m36s	464ms
	07	1,797	13m26s	449ms
	08	4,025	30m17s	451ms
	09	12,539	1h38m40s	472ms
	10	12,951	1h43m44s	480ms
	11	21,447	3h13m50s	542ms
	12	16,934	2h23m19s	507ms
	13	18,507	2h38m55s	515ms
	14	13,571	1h57m11s	518ms
	15	13,206	1h52m25s	510ms
	16	8,386	1h7m7s	480ms
	17	11,819	1h39m30s	505ms
	18	14,136	1h58m56s	504ms
	19	14,262	2h1m24s	510ms
	20	11,470	1h37m12s	508ms
	21	13,953	1h54m1s	490ms
	22	8,328	1h7m30s	486ms

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

Date: 2025-01-02 11:18:13 Duration: 3s341ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4139734)) AND (("shipping_track"."id" not in (33898524, 33898695, 33898813, 33919812, 33920043, 33983334, 33983754, 33983754)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:24:13 Duration: 2s602ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4143152)) AND (("shipping_track"."id" not in (33926270, 33927534, 33928486, 33982666, 33982666)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:22:59 Duration: 1s480ms

15

183,435

Details

15s831ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 02	00	2,460	199ms	0ms
	01	1,848	163ms	0ms
	02	1,208	121ms	0ms
	03	1,133	103ms	0ms
	04	1,157	108ms	0ms
	05	1,111	91ms	0ms
	06	1,018	91ms	0ms
	07	1,128	82ms	0ms
	08	4,199	350ms	0ms
	09	13,723	1s223ms	0ms
	10	17,043	1s467ms	0ms
	11	20,278	2s322ms	0ms
	12	18,541	1s907ms	0ms
	13	18,728	1s250ms	0ms
	14	14,153	1s59ms	0ms
	15	13,437	1s128ms	0ms
	16	12,953	955ms	0ms
	17	11,871	1s27ms	0ms
	18	8,858	752ms	0ms
	19	7,440	535ms	0ms
	20	5,144	389ms	0ms
	21	3,392	292ms	0ms
	22	2,612	208ms	0ms

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

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

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

Date: 2025-01-02 11:46:02 Duration: 1ms

16

151,880

Details

1h45m53s

31ms

265ms

41ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 02	00	3,152	2m2s	38ms
	01	3,073	2m	39ms
	02	2,225	1m26s	38ms
	03	1,787	1m10s	39ms
	04	2,038	1m19s	39ms
	05	956	37s939ms	39ms
	06	742	29s198ms	39ms
	07	967	38s85ms	39ms
	08	2,803	1m49s	39ms
	09	9,611	6m29s	40ms
	10	9,459	6m28s	41ms
	11	17,055	13m1s	45ms
	12	12,667	9m8s	43ms
	13	14,787	10m43s	43ms
	14	10,231	7m18s	42ms
	15	10,445	7m24s	42ms
	16	6,642	4m27s	40ms
	17	7,811	5m21s	41ms
	18	8,764	5m54s	40ms
	19	9,756	6m40s	41ms
	20	6,760	4m36s	40ms
	21	6,028	4m2s	40ms
	22	4,121	2m42s	39ms

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

Date: 2025-01-02 11:22:31 Duration: 265ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4139826)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-02 11:24:09 Duration: 206ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4131464)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-02 11:22:36 Duration: 206ms

17

147,001

Details

8s588ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,297	63ms	0ms
	01	727	36ms	0ms
	02	845	44ms	0ms
	03	596	30ms	0ms
	04	603	30ms	0ms
	05	443	21ms	0ms
	06	660	33ms	0ms
	07	771	37ms	0ms
	08	2,715	135ms	0ms
	09	9,486	532ms	0ms
	10	11,557	664ms	0ms
	11	18,029	1s178ms	0ms
	12	14,855	904ms	0ms
	13	13,693	854ms	0ms
	14	13,147	794ms	0ms
	15	12,009	722ms	0ms
	16	10,355	534ms	0ms
	17	11,251	647ms	0ms
	18	5,618	315ms	0ms
	19	6,607	361ms	0ms
	20	6,112	339ms	0ms
	21	3,679	200ms	0ms
	22	1,946	103ms	0ms

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

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

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

Date: 2025-01-02 14:37:16 Duration: 0ms

18

141,831

Details

17s667ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,268	132ms	0ms
	01	720	76ms	0ms
	02	828	87ms	0ms
	03	596	64ms	0ms
	04	582	61ms	0ms
	05	434	44ms	0ms
	06	636	67ms	0ms
	07	762	76ms	0ms
	08	2,652	280ms	0ms
	09	9,329	1s114ms	0ms
	10	11,239	1s380ms	0ms
	11	17,381	2s462ms	0ms
	12	14,468	1s889ms	0ms
	13	13,094	1s750ms	0ms
	14	12,546	1s610ms	0ms
	15	11,474	1s478ms	0ms
	16	9,996	1s87ms	0ms
	17	10,749	1s311ms	0ms
	18	5,431	648ms	0ms
	19	6,310	724ms	0ms
	20	5,810	687ms	0ms
	21	3,593	411ms	0ms
	22	1,933	218ms	0ms

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

Date: 2025-01-02 11:56:03 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

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

Date: 2025-01-02 17:47:08 Duration: 0ms

19

135,796

Details

44s552ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 02	00	4,195	1s423ms	0ms
	01	4,737	1s537ms	0ms
	02	5,651	1s895ms	0ms
	03	4,188	1s675ms	0ms
	04	7,324	2s517ms	0ms
	05	2,067	942ms	0ms
	06	5,628	1s868ms	0ms
	07	821	305ms	0ms
	08	414	198ms	0ms
	09	1,258	578ms	0ms
	10	2,173	883ms	0ms
	11	2,867	1s528ms	0ms
	12	1,727	795ms	0ms
	13	1,754	758ms	0ms
	14	7,948	2s671ms	0ms
	15	4,664	1s609ms	0ms
	16	3,923	1s145ms	0ms
	17	11,151	3s503ms	0ms
	18	14,977	4s532ms	0ms
	19	16,018	4s821ms	0ms
	20	14,484	4s228ms	0ms
	21	9,370	2s743ms	0ms
	22	8,457	2s388ms	0ms

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

Date: 2025-01-02 10:33:30 Duration: 3ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 51) AND ("price_list"."to_office_id" = 29)) ORDER BY "price_list"."id";

Date: 2025-01-02 17:22:03 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 62) AND ("price_list"."to_office_id" = 39)) ORDER BY "price_list"."id";

Date: 2025-01-02 17:37:48 Duration: 1ms

20

126,742

Details

9s419ms

0ms

1ms

0ms

select "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" from "urgent_warehouse" where "urgent_warehouse".id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 02	00	2,347	108ms	0ms
	01	2,157	100ms	0ms
	02	1,724	97ms	0ms
	03	1,758	89ms	0ms
	04	1,723	80ms	0ms
	05	1,413	61ms	0ms
	06	769	49ms	0ms
	07	766	48ms	0ms
	08	2,285	130ms	0ms
	09	8,596	613ms	0ms
	10	11,352	771ms	0ms
	11	13,828	1s244ms	0ms
	12	12,252	983ms	0ms
	13	11,356	908ms	0ms
	14	9,450	775ms	0ms
	15	8,752	730ms	0ms
	16	8,274	544ms	0ms
	17	8,380	674ms	0ms
	18	5,645	368ms	0ms
	19	5,246	382ms	0ms
	20	4,206	347ms	0ms
	21	2,640	193ms	0ms
	22	1,823	118ms	0ms

SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (36);

Date: 2025-01-02 05:09:29 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (37, 34, 11, 69, 70, 40, 36, 18, 28, 41, 46, 62, 100, 72, 64, 97, 74, 81, 105, 42, 15, 73, 102, 60, 16);

Date: 2025-01-02 10:55:51 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" 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);

Date: 2025-01-02 15:22:30 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

11m24s

22s58ms

347

Details

2h7m34s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 02	00	4	4ms	1ms
	01	2	1ms	0ms
	02	1	0ms	0ms
	05	1	1ms	1ms
	06	4	5ms	1ms
	07	1	1ms	1ms
	08	11	5ms	0ms
	09	42	26m38s	38s51ms
	10	23	24ms	1ms
	11	30	42ms	1ms
	12	27	27ms	1ms
	13	34	1m58s	3s490ms
	14	25	38s964ms	1s558ms
	15	27	1m55s	4s271ms
	16	22	10ms	0ms
	17	15	17ms	1ms
	18	13	6ms	0ms
	19	26	39m36s	1m31s
	20	13	7ms	0ms
	21	24	56m46s	2m21s
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-02 20:56:56.320598', "last_update" = '2025-01-02 20:11:56.320619', "sid" = 'a9a49de17d4e554a993059ab72aa5c189c6d14fc', "write_date" = '2025-01-02 20:11:55.961069', "write_uid" = 1116 WHERE id IN (1116);

Date: 2025-01-02 21:23:20 Duration: 11m24s
UPDATE "res_users" SET "exp_date" = '2025-01-02 20:57:23.594225', "last_update" = '2025-01-02 20:12:23.594250', "sid" = 'a9a49de17d4e554a993059ab72aa5c189c6d14fc', "write_date" = '2025-01-02 20:12:23.274968', "write_uid" = 1116 WHERE id IN (1116);

Date: 2025-01-02 21:23:20 Duration: 10m57s
UPDATE "res_users" SET "exp_date" = '2025-01-02 18:57:19.271906', "last_update" = '2025-01-02 18:12:19.271927', "sid" = '69dd48aeee501c256157ae59e020988f54211777', "write_date" = '2025-01-02 18:12:18.865346', "write_uid" = 1 WHERE id IN (1116);

Date: 2025-01-02 19:22:20 Duration: 10m1s

2

0ms

59m59s

2s595ms

76,447

Details

2d7h6m28s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 02	00	955	204ms	0ms
	01	1,001	214ms	0ms
	02	730	1h33m19s	7s670ms
	03	616	132ms	0ms
	04	698	148ms	0ms
	05	675	139ms	0ms
	06	448	99ms	0ms
	07	426	90ms	0ms
	08	1,784	379ms	0ms
	09	5,351	6h37m36s	4s458ms
	10	6,298	2h42m9s	1s544ms
	11	8,319	5h20m14s	2s309ms
	12	7,468	4h59m51s	2s409ms
	13	7,840	2h21m1s	1s79ms
	14	6,295	4h49m16s	2s757ms
	15	6,364	4h34m47s	2s590ms
	16	5,472	7h29m16s	4s926ms
	17	4,481	3h17m55s	2s650ms
	18	3,768	5m3s	80ms
	19	3,035	5h20m3s	6s327ms
	20	1,958	59m59s	1s838ms
	21	1,587	4h55m49s	11s184ms
	22	878	207ms	0ms

update res_users set sid = 'b1ce038250a025118d54c63d336323f3773bde9e', last_update = '2025-01-02 18:57:47.965885', exp_date = '2025-01-02 19:42:47.965889', logged_in = 'TRUE' where id = 861;

Date: 2025-01-02 20:57:47 Duration: 59m59s
update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:08:56.279248', exp_date = '2025-01-02 15:53:56.279252', logged_in = 'TRUE' where id = 833;

Date: 2025-01-02 16:49:21 Duration: 40m24s
update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2025-01-02 15:08:56.279045', exp_date = '2025-01-02 15:53:56.279049', logged_in = 'TRUE' where id = 833;

Date: 2025-01-02 16:49:21 Duration: 40m24s

3

27ms

4s433ms

2s589ms

305

Details

13m9s

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
Jan 02	09	32	1m20s	2s515ms
	10	6	20s813ms	3s468ms
	11	5	7s600ms	1s520ms
	12	10	21s889ms	2s188ms
	13	31	59s342ms	1s914ms
	14	25	51s560ms	2s62ms
	15	24	1m5s	2s748ms
	16	37	1m13s	1s993ms
	17	31	1m21s	2s614ms
	18	17	57s831ms	3s401ms
	19	51	2m47s	3s277ms
	20	25	1m10s	2s812ms
	21	10	28s914ms	2s891ms
	22	1	3s163ms	3s163ms

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

Date: 2025-01-02 20:58:36 Duration: 4s433ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79))))))) 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 (79)))))) 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 ("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 ("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"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))))) AND ("policy_number"."name"::text ilike '%97766%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-02 20:58:36 Duration: 4s356ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79))))))) 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 (79)))))) 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 ("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 ("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"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (79)))))))) AND ("policy_number"."name"::text ilike '%977%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-02 20:58:34 Duration: 4s356ms

4

31ms

1s602ms

993ms

10,494

Details

2h53m47s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 02	00	182	2m53s	955ms
	01	227	3m36s	954ms
	02	41	39s548ms	964ms
	07	23	21s804ms	948ms
	08	4	3s732ms	933ms
	09	32	32s854ms	1s26ms
	10	5	5s176ms	1s35ms
	11	44	47s853ms	1s87ms
	12	51	53s977ms	1s58ms
	13	80	1m25s	1s66ms
	14	350	6m12s	1s64ms
	15	369	6m25s	1s45ms
	16	640	10m24s	975ms
	17	768	13m11s	1s31ms
	18	2,445	40m59s	1s5ms
	19	1,595	24m35s	925ms
	20	1,925	32m8s	1s1ms
	21	706	11m54s	1s12ms
	22	1,007	16m34s	987ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9711169')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))))) 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 (11)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-02 11:18:09 Duration: 1s602ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9674567')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))) 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 (68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) 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 (68))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-02 20:56:20 Duration: 1s568ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9753301')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (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"."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))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-02 21:03:09 Duration: 1s534ms

5

412ms

2s968ms

507ms

45,776

Details

6h26m49s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 02	00	439	3m27s	473ms
	01	463	3m38s	472ms
	02	161	1m22s	512ms
	03	122	1m5s	534ms
	04	147	1m17s	527ms
	05	117	59s521ms	508ms
	06	328	2m30s	457ms
	07	348	2m41s	463ms
	08	880	6m52s	468ms
	09	2,920	23m37s	485ms
	10	3,939	32m18s	492ms
	11	3,624	34m27s	570ms
	12	5,126	44m39s	522ms
	13	4,889	43m21s	532ms
	14	3,133	26m55s	515ms
	15	3,273	28m20s	519ms
	16	2,866	22m57s	480ms
	17	3,401	28m	494ms
	18	3,749	30m9s	482ms
	19	2,493	20m32s	494ms
	20	1,805	14m40s	487ms
	21	960	8m5s	506ms
	22	593	4m47s	485ms

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

Date: 2025-01-02 11:24:13 Duration: 2s968ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4109416)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:22:32 Duration: 2s585ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4084405)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:44:07 Duration: 2s584ms

6

410ms

3s341ms

495ms

241,818

Details

1d9h17m6s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 02	00	6,525	49m39s	456ms
	01	6,656	51m2s	460ms
	02	6,652	51m2s	460ms
	03	7,096	53m36s	453ms
	04	8,259	1h3m28s	461ms
	05	4,441	33m4s	446ms
	06	4,858	37m36s	464ms
	07	1,797	13m26s	449ms
	08	4,025	30m17s	451ms
	09	12,539	1h38m40s	472ms
	10	12,951	1h43m44s	480ms
	11	21,447	3h13m50s	542ms
	12	16,934	2h23m19s	507ms
	13	18,507	2h38m55s	515ms
	14	13,571	1h57m11s	518ms
	15	13,206	1h52m25s	510ms
	16	8,386	1h7m7s	480ms
	17	11,819	1h39m30s	505ms
	18	14,136	1h58m56s	504ms
	19	14,262	2h1m24s	510ms
	20	11,470	1h37m12s	508ms
	21	13,953	1h54m1s	490ms
	22	8,328	1h7m30s	486ms

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

Date: 2025-01-02 11:18:13 Duration: 3s341ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4139734)) AND (("shipping_track"."id" not in (33898524, 33898695, 33898813, 33919812, 33920043, 33983334, 33983754, 33983754)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:24:13 Duration: 2s602ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4143152)) AND (("shipping_track"."id" not in (33926270, 33927534, 33928486, 33982666, 33982666)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-02 11:22:59 Duration: 1s480ms

7

213ms

496ms

305ms

18,592

Details

1h34m35s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 02	00	543	2m40s	295ms
	01	649	3m15s	300ms
	02	932	4m38s	298ms
	03	426	2m7s	299ms
	04	1,213	6m8s	303ms
	05	81	23s493ms	290ms
	06	1,009	5m	297ms
	07	86	25s330ms	294ms
	08	2	629ms	314ms
	09	63	20s709ms	328ms
	10	292	1m35s	326ms
	11	139	47s176ms	339ms
	12	131	44s459ms	339ms
	13	167	57s130ms	342ms
	14	1,514	7m1s	278ms
	15	713	3m32s	297ms
	16	336	1m42s	306ms
	17	2,011	10m37s	317ms
	18	1,340	7m3s	316ms
	19	2,456	12m49s	313ms
	20	1,718	8m42s	304ms
	21	1,658	8m29s	307ms
	22	1,113	5m33s	299ms

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

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

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

Date: 2025-01-02 20:56:57 Duration: 454ms

8

182ms

598ms

276ms

22,485

Details

1h43m45s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 02	08	1,882	7m48s	248ms
	09	1,102	4m52s	265ms
	10	1,781	7m59s	269ms
	11	3,001	14m38s	292ms
	12	2,334	11m17s	290ms
	13	3,590	17m6s	285ms
	14	3,352	15m25s	276ms
	15	2,682	12m30s	279ms
	16	1,766	7m47s	264ms
	17	995	4m18s	260ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9595823')))) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:23:33 Duration: 598ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9641813')))) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:18:07 Duration: 575ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9616667')))) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:18:06 Duration: 555ms

9

192ms

389ms

272ms

3,453

Details

15m40s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 02	09	222	56s884ms	256ms
	10	53	13s220ms	249ms
	11	369	1m45s	286ms
	12	554	2m32s	275ms
	13	234	1m8s	292ms
	14	264	1m12s	273ms
	15	1,414	6m24s	272ms
	16	343	1m26s	253ms

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

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

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

Date: 2025-01-02 15:14:03 Duration: 364ms

10

16ms

1s378ms

261ms

2,919

Details

12m44s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 02	00	3	459ms	153ms
	04	2	286ms	143ms
	06	2	315ms	157ms
	07	8	2s48ms	256ms
	08	53	7s569ms	142ms
	09	154	32s409ms	210ms
	10	240	53s99ms	221ms
	11	320	1m33s	291ms
	12	401	1m42s	255ms
	13	411	1m52s	274ms
	14	359	1m44s	290ms
	15	269	1m16s	283ms
	16	196	48s772ms	248ms
	17	143	39s285ms	274ms
	18	122	23s961ms	196ms
	19	105	29s613ms	282ms
	20	60	15s953ms	265ms
	21	49	12s138ms	247ms
	22	22	9s457ms	429ms

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

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

Date: 2025-01-02 11:24:04 Duration: 959ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (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)))))) LIMIT 10001) t;

Date: 2025-01-02 11:10:13 Duration: 897ms

11

89ms

915ms

239ms

57,467

Details

3h49m30s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,434	4m36s	193ms
	01	1,734	5m25s	187ms
	02	1,934	6m55s	214ms
	03	846	3m13s	228ms
	04	2,402	9m4s	226ms
	05	158	37s247ms	235ms
	06	2,008	7m27s	222ms
	07	218	43s926ms	201ms
	08	12	1s651ms	137ms
	09	180	42s248ms	234ms
	10	586	1m49s	187ms
	11	348	1m19s	228ms
	12	350	1m25s	243ms
	13	480	1m41s	210ms
	14	3,684	21m54s	356ms
	15	2,124	11m5s	313ms
	16	1,934	7m30s	232ms
	17	5,478	22m5s	241ms
	18	7,464	27m10s	218ms
	19	8,007	31m32s	236ms
	20	7,206	27m43s	230ms
	21	4,692	19m31s	249ms
	22	4,188	15m51s	227ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'لاغى')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-02 14:41:36 Duration: 915ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'لاغى')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-02 14:41:36 Duration: 915ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-02 18:39:33 Duration: 913ms

12

174ms

414ms

219ms

93,978

Details

5h43m54s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,180	3m53s	197ms
	01	2,163	7m11s	199ms
	02	2,348	7m51s	200ms
	03	2,415	8m5s	200ms
	04	2,578	8m34s	199ms
	05	2,166	7m14s	200ms
	06	2,309	7m42s	200ms
	07	527	1m45s	199ms
	08	4,568	15m23s	202ms
	09	4,699	16m19s	208ms
	10	3,566	12m38s	212ms
	11	8,736	33m54s	232ms
	12	8,000	30m7s	225ms
	13	7,942	29m56s	226ms
	14	7,891	28m56s	220ms
	15	7,584	27m59s	221ms
	16	4,775	16m28s	206ms
	17	2,971	10m12s	206ms
	18	140	28s502ms	203ms
	19	217	42s426ms	195ms
	20	6,996	28m58s	248ms
	21	9,895	38m28s	233ms
	22	312	1m	193ms

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

Date: 2025-01-02 11:44:02 Duration: 414ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '8086783')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-02 13:59:14 Duration: 366ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9640296')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-02 11:44:04 Duration: 365ms

13

182ms

415ms

218ms

5,746

Details

20m57s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 02	05	126	24s792ms	196ms
	06	448	1m29s	200ms
	07	30	5s893ms	196ms
	08	215	43s555ms	202ms
	09	375	1m16s	205ms
	10	128	27s103ms	211ms
	11	1,548	5m55s	229ms
	12	661	2m27s	222ms
	13	253	59s889ms	236ms
	14	264	57s403ms	217ms
	15	1,324	4m51s	220ms
	16	374	1m16s	205ms

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

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

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

Date: 2025-01-02 11:15:18 Duration: 340ms

14

177ms

433ms

212ms

13,663

Details

48m26s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 02	00	125	24s854ms	198ms
	01	416	1m23s	199ms
	02	118	23s114ms	195ms
	03	135	27s249ms	201ms
	04	199	39s485ms	198ms
	05	218	43s848ms	201ms
	06	1,376	4m34s	199ms
	07	498	1m39s	200ms
	08	876	2m56s	201ms
	09	1,778	6m13s	210ms
	10	537	1m53s	210ms
	11	1,127	4m22s	233ms
	12	1,366	5m3s	221ms
	13	801	2m59s	224ms
	14	254	55s351ms	217ms
	15	1,455	5m24s	223ms
	16	372	1m16s	204ms
	17	208	44s423ms	213ms
	18	140	28s587ms	204ms
	19	217	42s491ms	195ms
	20	921	3m28s	226ms
	21	242	47s239ms	195ms
	22	284	55s341ms	194ms

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

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

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

Date: 2025-01-02 11:26:07 Duration: 346ms

15

177ms

248ms

200ms

11,730

Details

39m10s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 02	00	1,055	3m28s	197ms
	01	1,741	5m47s	199ms
	02	2,194	7m21s	201ms
	03	2,281	7m38s	200ms
	04	2,330	7m45s	199ms
	05	1,644	5m30s	200ms
	06	485	1m38s	203ms

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

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

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

Date: 2025-01-02 02:06:02 Duration: 246ms

16

121ms

1s77ms

150ms

5,659

Details

14m10s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 02	00	27	3s564ms	132ms
	01	10	1s294ms	129ms
	02	19	2s494ms	131ms
	08	46	6s236ms	135ms
	09	405	56s763ms	140ms
	10	722	1m42s	141ms
	11	1,288	3m34s	166ms
	12	827	2m4s	150ms
	13	685	1m44s	152ms
	14	400	59s975ms	149ms
	15	437	1m3s	146ms
	16	235	32s157ms	136ms
	17	177	25s190ms	142ms
	18	129	18s220ms	141ms
	19	96	13s382ms	139ms
	20	79	11s439ms	144ms
	21	42	5s867ms	139ms
	22	35	4s693ms	134ms

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

Date: 2025-01-02 11:15:12 Duration: 1s77ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 60)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

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

Date: 2025-01-02 11:22:30 Duration: 806ms

17

81ms

238ms

104ms

21,000

Details

36m28s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 02	00	46	4s674ms	101ms
	01	52	5s261ms	101ms
	06	49	4s918ms	100ms
	07	40	3s874ms	96ms
	08	167	16s639ms	99ms
	09	1,312	2m11s	100ms
	10	1,868	3m9s	101ms
	11	2,316	4m15s	110ms
	12	2,048	3m40s	107ms
	13	3,104	5m39s	109ms
	14	2,045	3m31s	103ms
	15	1,969	3m24s	103ms
	16	1,441	2m22s	98ms
	17	1,050	1m50s	104ms
	18	891	1m32s	103ms
	19	1,650	2m41s	98ms
	20	439	44s315ms	100ms
	21	149	16s97ms	108ms
	22	364	34s867ms	95ms

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

Date: 2025-01-02 17:22:47 Duration: 238ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7923378)) AND (("cash_track"."id" not in (6504647)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-02 11:15:11 Duration: 231ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7921663)) AND (("cash_track"."id" not in (6492346, 6493390, 6493710, 6505149, 6505151, 6505151)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-02 11:24:38 Duration: 218ms

18

36ms

257ms

48ms

57,429

Details

46m29s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 02	00	69	3s246ms	47ms
	01	89	4s86ms	45ms
	02	11	510ms	46ms
	05	26	1s187ms	45ms
	06	57	2s669ms	46ms
	07	27	1s233ms	45ms
	08	1,605	1m11s	44ms
	09	6,274	4m48s	46ms
	10	2,650	2m4s	46ms
	11	6,560	5m43s	52ms
	12	4,290	3m30s	49ms
	13	13,342	10m57s	49ms
	14	6,338	5m9s	48ms
	15	6,764	5m27s	48ms
	16	3,678	2m48s	45ms
	17	4,101	3m18s	48ms
	18	516	25s393ms	49ms
	19	408	20s191ms	49ms
	20	290	14s167ms	48ms
	21	234	11s597ms	49ms
	22	100	4s793ms	47ms

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

Date: 2025-01-02 11:24:14 Duration: 257ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4105922) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:24:17 Duration: 246ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4096259) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:24:09 Duration: 236ms

19

33ms

84ms

43ms

22,223

Details

16m10s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 02	08	774	31s644ms	40ms
	09	2,301	1m35s	41ms
	10	1,683	1m11s	42ms
	11	2,904	2m11s	45ms
	12	1,991	1m29s	44ms
	13	4,089	3m4s	45ms
	14	2,490	1m49s	44ms
	15	2,936	2m7s	43ms
	16	1,729	1m12s	42ms
	17	1,326	57s458ms	43ms

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

Date: 2025-01-02 15:17:24 Duration: 84ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4040703) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:26:04 Duration: 83ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4030765) ORDER BY "collection_policy"."id";

Date: 2025-01-02 11:26:03 Duration: 81ms

20

31ms

265ms

41ms

151,880

Details

1h45m53s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 02	00	3,152	2m2s	38ms
	01	3,073	2m	39ms
	02	2,225	1m26s	38ms
	03	1,787	1m10s	39ms
	04	2,038	1m19s	39ms
	05	956	37s939ms	39ms
	06	742	29s198ms	39ms
	07	967	38s85ms	39ms
	08	2,803	1m49s	39ms
	09	9,611	6m29s	40ms
	10	9,459	6m28s	41ms
	11	17,055	13m1s	45ms
	12	12,667	9m8s	43ms
	13	14,787	10m43s	43ms
	14	10,231	7m18s	42ms
	15	10,445	7m24s	42ms
	16	6,642	4m27s	40ms
	17	7,811	5m21s	41ms
	18	8,764	5m54s	40ms
	19	9,756	6m40s	41ms
	20	6,760	4m36s	40ms
	21	6,028	4m2s	40ms
	22	4,121	2m42s	39ms

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

Date: 2025-01-02 11:22:31 Duration: 265ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4139826)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-02 11:24:09 Duration: 206ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4131464)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-02 11:22:36 Duration: 206ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

18,543,799 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	6	0.00%
DETAIL	29	0.00%
ERROR	6,383	0.03%
EVENTLOG	668	0.00%
FATAL	640	0.00%
HINT	2	0.00%
LOG	18,529,664	99.92%
STATEMENT	6,407	0.03%

Events distribution (except queries)

Key values

0 PANIC entries
640 FATAL entries
6383 ERROR entries
0 WARNING entries
668 EVENTLOG entries

Most Frequent Errors/Events

Key values

3,316 Max number of times the same event was reported
7,691 Total events found

Rank

Times reported

Error

1

3,316

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 02	00	15
	01	4
	02	8
	03	7
	04	9
	05	6
	06	6
	07	6
	08	52
	09	197
	10	217
	11	495
	12	378
	13	469
	14	324
	15	310
	16	193
	17	180
	18	244
	19	75
	20	54
	21	48
	22	19

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

2

3,034

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 02	00	15
	01	3
	02	7
	03	5
	04	6
	05	5
	06	6
	07	5
	08	49
	09	170
	10	212
	11	451
	12	363
	13	378
	14	310
	15	291
	16	177
	17	178
	18	227
	19	69
	20	46
	21	43
	22	18

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

3

475

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 02	02	57
	09	57
	10	31
	11	75
	12	41
	13	57
	14	25
	15	23
	16	22
	17	27
	19	30
	21	30

4

475

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 02	02	57
	09	57
	10	31
	11	75
	12	41
	13	57
	14	25
	15	23
	16	22
	17	27
	19	30
	21	30

5

134

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 02	02	7
	09	12
	10	5
	11	22
	12	22
	13	12
	14	8
	15	10
	16	10
	17	5
	19	10
	20	1
	21	10

6

95

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 02	17	95

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

7

58

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 02	02	2
	09	3
	11	11
	12	14
	13	5
	14	4
	15	5
	16	7
	17	4
	19	1
	21	1
	22	1

8

18

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 02	17	18

9

16

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 02	17	16

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

10

15

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 02	04	3
	13	3
	16	3
	20	3
	21	3

FATAL: password authentication failed for user "postgres"

11

12

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 02	09	1
	10	2
	11	1
	15	3
	16	2
	17	2
	19	1

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

12

9

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 02	10	9

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

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 02	09	1
	11	1
	21	1
	22	3

14

4

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 02	09	1
	11	1
	21	1
	22	1

15

4

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 02	12	2
	16	2

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

16

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 02	09	1
	10	1
	11	1
	21	1

17

3

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 02	17	3

18

3

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 02	17	3

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

19

3

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 02	13	1
	20	2

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

20

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 02	14	1
	20	1

21

2

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 02	04	1
	22	1

22

2

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 02	11	1
	12	1

ERROR: deadlock detected
ERROR: deadlock detected

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 02	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables