pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Dec 5 23:47:41 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 73,348,838 log entries in 2m40s
Log start from 2024-12-05 00:00:00 to 2024-12-05 22:45:01

Global Stats

24,378 Number of unique normalized queries
21,167,042 Number of queries
3d11h3m56s Total query duration
2024-12-05 00:00:00 First query
2024-12-05 22:45:01 Last query
6,354 queries/s at 2024-12-05 11:50:12 Query peak

3d11h3m56s Total query duration
1s95ms Prepare/parse total duration
44s881ms Bind total duration
3d11h3m10s Execute total duration

6,053 Number of events
25 Number of unique normalized events
2,206 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
21,167,042 Average queries per session
3d11h3m56s 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

6,354 queries/s Query Peak
2024-12-05 11:50:12 Date

SELECT Traffic

Key values

4,196 queries/s Query Peak
2024-12-05 11:50:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,787 queries/s Query Peak
2024-12-05 18:21:35 Date

Queries duration

Key values

3d11h3m56s 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)
Dec 05	00	354,364	0ms	4s159ms	15ms	2m56s	3m36s	4m11s
	01	348,437	0ms	1s57ms	16ms	3m	3m41s	4m
	02	268,900	0ms	1s674ms	14ms	2m21s	2m37s	3m17s
	03	230,449	0ms	1s336ms	12ms	1m51s	2m56s	3m57s
	04	284,243	0ms	691ms	17ms	2m54s	3m54s	4m46s
	05	280,192	0ms	1s59ms	16ms	2m25s	2m33s	2m50s
	06	372,131	0ms	4s323ms	15ms	3m	3m22s	3m37s
	07	317,521	0ms	4s303ms	13ms	2m5s	3m28s	3m45s
	08	537,835	0ms	3s413ms	6ms	2m3s	2m18s	3m7s
	09	1,235,807	0ms	4s695ms	9ms	5m28s	6m21s	8m37s
	10	1,602,091	0ms	5s293ms	11ms	7m21s	9m	14m27s
	11	1,867,238	0ms	11m1s	19ms	28m53s	49m32s	1h36m28s
	12	1,862,623	0ms	15m3s	26ms	23m5s	1h28m42s	3h16m31s
	13	1,821,489	0ms	1m32s	13ms	15m50s	19m11s	28m50s
	14	1,418,855	0ms	2m15s	9ms	5m51s	6m40s	8m10s
	15	1,766,021	0ms	5s324ms	7ms	6m35s	7m32s	8m34s
	16	1,478,657	0ms	4s867ms	9ms	5m7s	6m16s	6m30s
	17	1,197,113	0ms	4s464ms	11ms	5m43s	6m22s	8m56s
	18	1,036,757	0ms	10s459ms	13ms	5m47s	6m16s	8m29s
	19	1,206,516	0ms	32s240ms	21ms	11m7s	12m9s	13m43s
	20	775,158	0ms	23s559ms	15ms	6m20s	7m10s	8m51s
	21	578,037	0ms	37s517ms	15ms	3m30s	4m46s	5m3s
	22	326,608	0ms	16s417ms	13ms	2m58s	2m59s	4m2s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 05	00	212,096	26ms	2m26s	2m55s	3m57s
	01	208,374	27ms	2m30s	3m	3m46s
	02	161,684	23ms	1m37s	2m21s	2m39s
	03	137,862	20ms	1m10s	1m50s	3m5s
	04	170,189	29ms	2m7s	2m53s	4m14s
	05	166,121	27ms	1m59s	2m25s	2m43s
	06	222,433	26ms	2m29s	2m59s	3m34s
	07	190,660	22ms	1m43s	2m5s	3m32s
	08	328,795	9ms	1m20s	2m2s	2m37s
	09	719,839	15ms	4m35s	5m27s	6m32s
	10	912,021	19ms	5m53s	7m20s	14m6s
	11	1,151,934	14ms	5m39s	6m50s	8m42s
	12	1,141,497	12ms	5m	6m5s	7m51s
	13	1,126,773	19ms	10m34s	14m42s	19m11s
	14	816,281	15ms	4m55s	5m50s	7m19s
	15	1,034,252	13ms	5m15s	6m34s	7m40s
	16	899,765	15ms	4m52s	5m6s	6m16s
	17	717,823	18ms	4m38s	5m42s	6m23s
	18	601,445	22ms	4m41s	5m46s	6m40s
	19	774,312	32ms	10m15s	11m5s	13m5s
	20	479,639	25ms	5m	6m19s	7m35s
	21	347,324	25ms	3m3s	3m29s	4m55s
	22	193,220	22ms	2m28s	2m57s	4m1s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 05	00	29,505	5,404	85	0	0ms	144ms	214ms	385ms
	01	26,812	4,750	95	0	0ms	172ms	200ms	303ms
	02	19,174	3,557	81	0	0ms	114ms	157ms	212ms
	03	11,514	3,113	69	0	0ms	71ms	104ms	247ms
	04	22,472	4,849	75	0	0ms	130ms	188ms	321ms
	05	19,039	4,088	74	0	0ms	121ms	151ms	200ms
	06	26,480	5,612	92	0	0ms	149ms	201ms	326ms
	07	15,658	4,660	80	0	0ms	106ms	131ms	201ms
	08	16,930	4,705	252	0	0ms	101ms	118ms	228ms
	09	55,898	12,570	726	0	0ms	330ms	419ms	589ms
	10	84,915	19,095	1,073	0	0ms	457ms	537ms	881ms
	11	77,960	28,254	889	0	188ms	622ms	1s18ms	49m20s
	12	74,998	24,801	838	0	346ms	481ms	607ms	1h25m55s
	13	69,305	33,045	903	0	16ms	458ms	798ms	29s731ms
	14	65,008	15,272	625	1	2ms	336ms	422ms	502ms
	15	77,068	17,889	506	10	0ms	376ms	467ms	782ms
	16	71,991	18,650	601	0	0ms	349ms	434ms	545ms
	17	65,090	15,986	835	1	0ms	455ms	550ms	836ms
	18	68,588	16,316	644	0	0ms	380ms	449ms	1s16ms
	19	90,153	24,972	651	0	0ms	563ms	703ms	1s131ms
	20	54,570	11,596	479	0	0ms	324ms	404ms	498ms
	21	44,857	9,134	365	0	1ms	244ms	290ms	498ms
	22	22,318	4,522	166	0	0ms	177ms	213ms	319ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 05	00	118	61,227	518.87	0.04%
	01	118	61,228	518.88	0.04%
	02	118	61,228	518.88	0.05%
	03	118	61,228	518.88	0.06%
	04	118	61,228	518.88	0.05%
	05	118	61,228	518.88	0.05%
	06	118	61,228	518.88	0.04%
	07	118	61,228	518.88	0.04%
	08	118	61,228	518.88	0.03%
	09	118	61,228	518.88	0.01%
	10	118	61,228	518.88	0.01%
	11	118	61,228	518.88	0.01%
	12	118	61,228	518.88	0.01%
	13	118	61,228	518.88	0.01%
	14	118	61,228	518.88	0.01%
	15	118	61,228	518.88	0.01%
	16	118	61,228	518.88	0.01%
	17	121	59,310	490.17	0.01%
	18	118	61,228	518.88	0.01%
	19	118	61,228	518.88	0.01%
	20	118	61,228	518.88	0.02%
	21	118	61,228	518.88	0.02%
	22	97	45,954	473.75	0.03%

Day	Hour	Average / Second
Dec 05	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
Dec 05	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

248,937 buffers Checkpoint Peak
2024-12-05 12:36:22 Date
270.048 seconds Highest write time
0.018 seconds Sync time

Checkpoints Wal files

Key values

108 files Wal files usage Peak
2024-12-05 12:36:22 Date

Checkpoints distance

Key values

3,469.19 Mo Distance Peak
2024-12-05 12:36:22 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 05	00	130,127	2,969.437s	0.045s	2,969.532s
	01	143,177	3,234.06s	0.033s	3,234.139s
	02	127,556	3,239.061s	0.03s	3,239.134s
	03	77,791	2,699.579s	0.033s	2,699.646s
	04	160,030	3,239.556s	0.037s	3,239.639s
	05	154,953	3,239.633s	0.029s	3,239.707s
	06	180,721	3,239.529s	0.03s	3,239.614s
	07	143,740	3,239.509s	0.036s	3,239.591s
	08	133,488	3,239.592s	0.044s	3,239.673s
	09	385,753	3,239.58s	0.054s	3,239.7s
	10	559,776	3,239.552s	0.061s	3,239.71s
	11	602,773	3,239.442s	0.064s	3,239.608s
	12	785,300	3,239.448s	0.055s	3,239.62s
	13	566,542	3,239.514s	0.058s	3,239.675s
	14	548,174	3,239.501s	0.043s	3,239.625s
	15	510,771	3,239.538s	0.048s	3,239.669s
	16	474,934	3,239.525s	0.052s	3,239.657s
	17	406,851	2,888.827s	0.074s	2,888.979s
	18	363,206	3,239.568s	0.049s	3,239.686s
	19	348,792	3,239.517s	0.054s	3,239.649s
	20	371,885	3,239.53s	0.057s	3,239.648s
	21	169,417	3,239.541s	0.043s	3,239.644s
	22	134,413	2,429.643s	0.029s	2,429.709s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 05	00	0	56	2,920	0.016s	0.011s
	01	0	66	2,667	0.002s	0.012s
	02	0	58	2,606	0.002s	0.012s
	03	0	35	1,902	0.012s	0.01s
	04	0	75	2,350	0.008s	0.012s
	05	0	73	2,441	0.002s	0.012s
	06	0	84	2,584	0.002s	0.012s
	07	0	64	2,305	0.005s	0.012s
	08	0	54	3,494	0.013s	0.012s
	09	0	167	4,628	0.002s	0.012s
	10	0	246	5,042	0.002s	0.012s
	11	0	273	5,142	0.003s	0.012s
	12	2	335	5,240	0.003s	0.012s
	13	4	214	5,132	0.002s	0.012s
	14	0	218	5,147	0.002s	0.012s
	15	0	206	5,584	0.002s	0.012s
	16	0	194	5,568	0.002s	0.012s
	17	0	164	5,147	0.007s	0.012s
	18	0	145	5,229	0.006s	0.012s
	19	0	148	5,548	0.003s	0.012s
	20	0	124	4,790	0.017s	0.012s
	21	0	71	4,694	0.002s	0.012s
	22	0	56	3,319	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 05	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
Dec 05	00	83,466.27 kB	132,001.27 kB
	01	91,181.92 kB	123,687.00 kB
	02	78,176.92 kB	106,864.67 kB
	03	58,223.30 kB	83,858.60 kB
	04	104,869.18 kB	140,253.91 kB
	05	98,999.17 kB	139,584.58 kB
	06	115,151.83 kB	148,783.42 kB
	07	87,398.67 kB	125,541.58 kB
	08	74,732.45 kB	102,621.36 kB
	09	225,090.64 kB	262,357.27 kB
	10	335,916.42 kB	381,445.00 kB
	11	372,914.17 kB	528,792.17 kB
	12	473,367.18 kB	936,055.18 kB
	13	294,133.73 kB	823,413.00 kB
	14	280,618.55 kB	466,559.73 kB
	15	277,813.00 kB	354,193.30 kB
	16	265,067.67 kB	336,252.83 kB
	17	218,765.30 kB	267,327.10 kB
	18	202,469.90 kB	267,361.50 kB
	19	202,413.92 kB	233,914.25 kB
	20	168,049.83 kB	229,144.25 kB
	21	97,774.50 kB	150,082.08 kB
	22	101,101.22 kB	134,647.78 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (269) Main checkpoint cause
270 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	269
shutdown immediate	1
Total	270

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
Dec 05	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
Dec 05	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

12,714,339 Total read queries
5,721,146 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	12,714,339	60.07%
INSERT	1,110,303	5.25%
UPDATE	292,840	1.38%
DELETE	10,204	0.05%
COPY FROM	12	0.00%
COPY TO	0	0.00%
CTE	107,619	0.51%
DDL	1,727	0.01%
TCL	4,198,441	19.83%
CURSOR	0	0.00%
OTHERS	2,731,557	12.90%

Queries by database

Key values

unknown Main database
21,167,042 Requests
3d11h3m10s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	21,167,042	3d11h3m10s
	copy from	12	9ms
	cte	107,619	1m
	ddl	1,727	1m5s
	delete	10,204	24s949ms
	insert	1,110,303	8m47s
	others	2,731,554	2m21s
	select	12,714,339	2d18h58m27s
	tcl	4,198,441	2m42s
	update	292,840	15h48m20s

Queries by user

Key values

unknown Main user
21,167,042 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	21,167,042	3d11h3m10s
	copy from	12	9ms
	cte	107,619	1m
	ddl	1,727	1m5s
	delete	10,204	24s949ms
	insert	1,110,303	8m47s
	others	2,731,554	2m21s
	select	12,714,339	2d18h58m27s
	tcl	4,198,441	2m42s
	update	292,840	15h48m20s

Duration by user

Key values

3d11h3m10s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	21,167,042	3d11h3m10s
	copy from	12	9ms
	cte	107,619	1m
	ddl	1,727	1m5s
	delete	10,204	24s949ms
	insert	1,110,303	8m47s
	others	2,731,554	2m21s
	select	12,714,339	2d18h58m27s
	tcl	4,198,441	2m42s
	update	292,840	15h48m20s

Queries by host

Key values

unknown Main host
21,167,042 Requests
3d11h3m10s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	21,167,042	3d11h3m10s
	copy from	12	9ms
	cte	107,619	1m
	ddl	1,727	1m5s
	delete	10,204	24s949ms
	insert	1,110,303	8m47s
	others	2,731,554	2m21s
	select	12,714,339	2d18h58m27s
	tcl	4,198,441	2m42s
	update	292,840	15h48m20s

Queries by application

Key values

unknown Main application
21,167,042 Requests
3d11h3m10s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	21,167,042	3d11h3m10s
	copy from	12	9ms
	cte	107,619	1m
	ddl	1,727	1m5s
	delete	10,204	24s949ms
	insert	1,110,303	8m47s
	others	2,731,554	2m21s
	select	12,714,339	2d18h58m27s
	tcl	4,198,441	2m42s
	update	292,840	15h48m20s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-05 12:49:41 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

19,638,651 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	19,638,651	92.78%
1-5ms	456,335	2.16%
5-10ms	20,890	0.10%
10-25ms	61,081	0.29%
25-50ms	274,260	1.30%
50-100ms	64,826	0.31%
100-500ms	625,961	2.96%
500-1000ms	17,813	0.08%
1000-10000ms	6,147	0.03%
> 10000ms	1,078	0.01%

Slowest individual queries

Rank	Duration	Query
1	15m3s	update res_users set sid = '0dd2c2e8feeb61175c84afe659fd80653d1e107f', last_update = '2024-12-05 10:54:16.489649', exp_date = '2024-12-05 11:39:16.489651', logged_in = 'TRUE' where id = 917; [ Date: 2024-12-05 12:09:20 ]
2	15m2s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 10:54:17.516409', exp_date = '2024-12-05 11:39:17.516412', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:09:20 ]
3	14m34s	update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:46.216862', exp_date = '2024-12-05 11:39:46.216866', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:09:20 ]
4	14m31s	update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:49.258445', exp_date = '2024-12-05 11:39:49.258447', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:09:20 ]
5	14m27s	update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:53.282546', exp_date = '2024-12-05 11:39:53.282549', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:09:20 ]
6	14m23s	update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:56.768828', exp_date = '2024-12-05 11:39:56.768831', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:09:20 ]
7	14m23s	update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:56.775322', exp_date = '2024-12-05 11:39:56.775325', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:09:20 ]
8	14m23s	update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:56.779817', exp_date = '2024-12-05 11:39:56.779820', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:09:20 ]
9	13m54s	update res_users set sid = '3aa994c0dbc2095916e3f91dac883ab850acaad3', last_update = '2024-12-05 11:31:26.494158', exp_date = '2024-12-05 12:16:26.494161', logged_in = 'TRUE' where id = 1030; [ Date: 2024-12-05 12:45:20 ]
10	13m54s	update res_users set sid = '3aa994c0dbc2095916e3f91dac883ab850acaad3', last_update = '2024-12-05 11:31:26.493731', exp_date = '2024-12-05 12:16:26.493734', logged_in = 'TRUE' where id = 1030; [ Date: 2024-12-05 12:45:20 ]
11	13m39s	update res_users set sid = '0dd2c2e8feeb61175c84afe659fd80653d1e107f', last_update = '2024-12-05 10:55:41.252085', exp_date = '2024-12-05 11:40:41.252089', logged_in = 'TRUE' where id = 917; [ Date: 2024-12-05 12:09:20 ]
12	13m39s	update res_users set sid = '0dd2c2e8feeb61175c84afe659fd80653d1e107f', last_update = '2024-12-05 10:55:41.280769', exp_date = '2024-12-05 11:40:41.280773', logged_in = 'TRUE' where id = 917; [ Date: 2024-12-05 12:09:20 ]
13	13m38s	update res_users set sid = '0dd2c2e8feeb61175c84afe659fd80653d1e107f', last_update = '2024-12-05 10:55:41.383127', exp_date = '2024-12-05 11:40:41.383130', logged_in = 'TRUE' where id = 917; [ Date: 2024-12-05 12:09:20 ]
14	13m38s	update res_users set sid = '0dd2c2e8feeb61175c84afe659fd80653d1e107f', last_update = '2024-12-05 10:55:41.647330', exp_date = '2024-12-05 11:40:41.647334', logged_in = 'TRUE' where id = 917; [ Date: 2024-12-05 12:09:20 ]
15	11m38s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 11:33:42.240436', exp_date = '2024-12-05 12:18:42.240440', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:45:20 ]
16	11m38s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 11:33:42.240392', exp_date = '2024-12-05 12:18:42.240395', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 12:45:20 ]
17	11m1s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 10:34:18.724790', exp_date = '2024-12-05 11:19:18.724793', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 11:45:20 ]
18	11m1s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 10:34:18.725105', exp_date = '2024-12-05 11:19:18.725108', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 11:45:20 ]
19	10m49s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 10:34:31.044011', exp_date = '2024-12-05 11:19:31.044014', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 11:45:20 ]
20	10m39s	update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 10:34:40.856389', exp_date = '2024-12-05 11:19:40.856392', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-05 11:45:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

1d5h28m51s

273,060

Details

322ms

2s107ms

388ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	7,736	47m6s	365ms
	01	8,742	52m37s	361ms
	02	6,644	39m23s	355ms
	03	5,063	29m33s	350ms
	04	8,940	53m1s	355ms
	05	8,860	51m44s	350ms
	06	10,070	59m44s	355ms
	07	6,760	39m30s	350ms
	08	3,341	19m29s	350ms
	09	13,316	1h22m47s	373ms
	10	20,392	2h17m15s	403ms
	11	18,257	1h58m32s	389ms
	12	16,823	1h47m43s	384ms
	13	13,957	1h28m56s	382ms
	14	13,253	1h23m43s	379ms
	15	13,826	1h29m14s	387ms
	16	13,940	1h29m15s	384ms
	17	14,448	1h36m45s	401ms
	18	14,016	1h36m	410ms
	19	23,833	2h59m19s	451ms
	20	15,811	1h47m37s	408ms
	21	9,705	1h4m46s	400ms
	22	5,327	34m43s	391ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3230117)) AND (("shipping_track"."id" not in (26369369, 26374663, 26422347, 26422454, 26422546, 26482271, 26482794, 26483117, 26504542, 26799466, 26799466)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:27 Duration: 2s107ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3230022)) AND (("shipping_track"."id" not in (26368827, 26374801, 26442751, 26442816, 26442867, 26464754, 26464831, 26464935, 26795688, 26796119, 26799444, 26799444)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:23 Duration: 2s
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3220572)) AND (("shipping_track"."id" not in (26315837, 26316464, 26316730, 26377497, 26458746, 26502494, 26797495, 26797495)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:53:04 Duration: 1s990ms

2

15h37m28s

19,431

Details

0ms

15m3s

2s894ms

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
Dec 05	11	9,029	5h31m13s	2s201ms
	12	9,449	9h40m40s	3s687ms
	13	953	25m35s	1s610ms

update res_users set sid = '0dd2c2e8feeb61175c84afe659fd80653d1e107f', last_update = '2024-12-05 10:54:16.489649', exp_date = '2024-12-05 11:39:16.489651', logged_in = 'TRUE' where id = 917;

Date: 2024-12-05 12:09:20 Duration: 15m3s
update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 10:54:17.516409', exp_date = '2024-12-05 11:39:17.516412', logged_in = 'TRUE' where id = 843;

Date: 2024-12-05 12:09:20 Duration: 15m2s
update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:46.216862', exp_date = '2024-12-05 11:39:46.216866', logged_in = 'TRUE' where id = 843;

Date: 2024-12-05 12:09:20 Duration: 14m34s

3

8h14m28s

132,088

Details

177ms

1s95ms

224ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1,041	3m25s	196ms
	01	1,319	4m21s	198ms
	02	944	3m5s	196ms
	03	1,757	5m48s	198ms
	04	2,241	7m22s	197ms
	05	2,220	7m18s	197ms
	06	2,880	9m33s	199ms
	07	3,428	11m23s	199ms
	08	3,822	12m39s	198ms
	09	8,487	30m6s	212ms
	10	12,185	45m50s	225ms
	11	10,358	38m10s	221ms
	12	8,445	30m53s	219ms
	13	11,514	42m33s	221ms
	14	7,517	27m5s	216ms
	15	10,079	36m15s	215ms
	16	8,977	31m39s	211ms
	17	6,742	25m12s	224ms
	18	4,144	15m49s	229ms
	19	19,244	1h26m44s	270ms
	20	3,580	14m54s	249ms
	21	476	1m43s	216ms
	22	688	2m31s	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" = '9005818')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-05 10:55:24 Duration: 1s95ms
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" = '8510195')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-05 10:55:18 Duration: 1s69ms
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" = '8775279')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-05 10:55:21 Duration: 715ms

4

5h11m20s

46,812

Details

323ms

3s102ms

399ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 05	00	280	1m43s	369ms
	01	286	1m49s	382ms
	02	111	45s897ms	413ms
	03	111	46s319ms	417ms
	04	141	58s627ms	415ms
	05	150	1m	402ms
	06	308	2m	391ms
	07	305	1m57s	384ms
	08	582	3m33s	366ms
	09	3,541	22m41s	384ms
	10	5,029	34m17s	409ms
	11	4,072	27m23s	403ms
	12	4,015	26m32s	396ms
	13	3,786	25m2s	396ms
	14	4,602	29m28s	384ms
	15	2,606	17m18s	398ms
	16	3,188	20m20s	382ms
	17	3,502	23m27s	401ms
	18	2,796	18m52s	405ms
	19	2,944	21m59s	448ms
	20	2,192	14m50s	406ms
	21	1,364	8m44s	384ms
	22	901	5m46s	384ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3254714, 3255840, 3255768, 3257955, 3265068, 3260988, 3261930, 3262182, 3261069, 3265225, 3265597, 3266157, 3267432, 3269331, 3270094, 3272084, 3281290, 3256301, 3245626, 3278522, 3252682, 3252683, 3254704, 3273528, 3256241, 3245660, 3272310, 3272188, 3265245, 3275827, 3274600, 3276673, 3277212, 3277626, 3255852, 3277553, 3279360, 3280314, 3281316, 3280406, 3282537, 3283110, 3283173, 3284561, 3284576, 3275816, 3269626, 3257102)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:53:00 Duration: 3s102ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3230117)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:25 Duration: 2s437ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3248320)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:53:15 Duration: 1s966ms

5

3h48m26s

58,340

Details

92ms

886ms

234ms

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
Dec 05	00	4,253	15m11s	214ms
	01	3,280	12m42s	232ms
	02	1,888	6m10s	196ms
	03	628	2m27s	234ms
	04	1,908	7m59s	251ms
	05	1,037	4m5s	236ms
	06	2,163	7m47s	216ms
	07	732	2m40s	219ms
	08	292	1m3s	216ms
	09	172	47s88ms	273ms
	10	422	1m37s	230ms
	11	96	24s763ms	257ms
	12	302	1m15s	248ms
	13	118	31s726ms	268ms
	14	1,262	5m42s	271ms
	15	1,798	7m14s	241ms
	16	4,722	18m43s	237ms
	17	3,546	14m14s	240ms
	18	5,794	22m14s	230ms
	19	9,179	41m10s	269ms
	20	5,756	22m17s	232ms
	21	6,516	23m27s	215ms
	22	2,476	8m37s	208ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حمدي')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-05 14:22:46 Duration: 886ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'بدون')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-05 14:22:46 Duration: 885ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبدالرحمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-05 19:40:24 Duration: 885ms

6

3h19m5s

11,908

Details

252ms

1s496ms

1s3ms

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
Dec 05	00	651	10m21s	954ms
	01	566	9m7s	966ms
	02	345	5m31s	962ms
	06	1	931ms	931ms
	08	52	49s648ms	954ms
	09	20	18s892ms	944ms
	10	31	33s622ms	1s84ms
	11	24	26s174ms	1s90ms
	12	138	2m24s	1s48ms
	13	1	1s9ms	1s9ms
	14	420	7m12s	1s28ms
	15	594	10m42s	1s82ms
	16	910	15m27s	1s19ms
	17	743	12m52s	1s39ms
	18	1,773	30m2s	1s16ms
	19	2,178	38m5s	1s49ms
	20	1,102	17m55s	975ms
	21	1,844	28m58s	942ms
	22	515	8m13s	957ms

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

Date: 2024-12-05 19:51:19 Duration: 1s496ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9223352')) 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 (22))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-05 19:07:34 Duration: 1s467ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '8498984')) 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 (60))))))) 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 (60)))))) 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 (60)))))) 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 (60))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-05 19:51:28 Duration: 1s452ms

7

3h5m26s

41,607

Details

190ms

633ms

267ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	07	491	1m57s	240ms
	08	1,606	6m26s	240ms
	09	3,459	15m3s	261ms
	10	6,565	30m	274ms
	11	4,258	18m57s	267ms
	12	2,915	12m54s	265ms
	13	4,209	19m	271ms
	14	3,940	17m24s	265ms
	15	4,321	19m7s	265ms
	16	2,972	12m43s	256ms
	17	2,747	12m24s	271ms
	18	1,970	8m50s	269ms
	19	2,154	10m34s	294ms

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

Date: 2024-12-05 10:55:30 Duration: 633ms
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" = '8937307')))) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:30 Duration: 596ms
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" = '8942292')))) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:32 Duration: 579ms

8

1h41m22s

168,480

Details

27ms

169ms

36ms

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
Dec 05	00	3,872	2m7s	33ms
	01	3,126	1m43s	33ms
	02	2,474	1m22s	33ms
	03	1,321	43s559ms	32ms
	04	3,024	1m40s	33ms
	05	2,080	1m8s	33ms
	06	2,782	1m33s	33ms
	07	1,634	55s187ms	33ms
	08	2,247	1m14s	33ms
	09	9,925	5m52s	35ms
	10	14,952	9m31s	38ms
	11	14,669	9m1s	36ms
	12	14,030	8m30s	36ms
	13	11,720	7m4s	36ms
	14	11,055	6m33s	35ms
	15	12,214	7m20s	36ms
	16	10,250	6m1s	35ms
	17	9,337	5m41s	36ms
	18	9,860	5m59s	36ms
	19	11,272	7m29s	39ms
	20	7,801	4m40s	36ms
	21	5,917	3m25s	34ms
	22	2,918	1m40s	34ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3223356)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:55:24 Duration: 169ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3189390)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:53:22 Duration: 159ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3213948)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:55:26 Duration: 157ms

9

1h32m22s

17,721

Details

226ms

622ms

312ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1,496	7m9s	287ms
	01	1,087	5m9s	284ms
	02	606	2m51s	282ms
	03	319	1m30s	282ms
	04	962	4m36s	287ms
	05	524	2m27s	280ms
	06	1,092	5m10s	284ms
	07	370	1m44s	281ms
	08	102	28s845ms	282ms
	09	76	24s537ms	322ms
	10	188	55s820ms	296ms
	11	27	8s129ms	301ms
	12	14	4s451ms	317ms
	13	59	17s841ms	302ms
	14	226	1m16s	336ms
	15	330	1m44s	315ms
	16	1,484	7m40s	310ms
	17	1,049	5m51s	334ms
	18	1,144	6m20s	332ms
	19	2,495	15m17s	367ms
	20	1,843	9m53s	322ms
	21	1,484	7m39s	309ms
	22	744	3m39s	295ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '465013')) 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: 2024-12-05 19:51:17 Duration: 622ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9240558')) 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: 2024-12-05 19:10:43 Duration: 603ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9240633')) 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: 2024-12-05 19:10:47 Duration: 572ms

10

1h13m37s

121,174

Details

0ms

15s

36ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 05	00	518	78ms	0ms
	01	472	75ms	0ms
	02	200	32ms	0ms
	03	80	13ms	0ms
	04	177	30ms	0ms
	05	180	30ms	0ms
	06	461	77ms	0ms
	07	383	63ms	0ms
	08	2,399	375ms	0ms
	09	3,573	604ms	0ms
	10	3,549	642ms	0ms
	11	16,880	3m11s	11ms
	12	14,730	1s478ms	0ms
	13	20,947	1h10m11s	201ms
	14	3,764	640ms	0ms
	15	7,800	1s356ms	0ms
	16	12,208	2s145ms	0ms
	17	7,403	1s381ms	0ms
	18	3,370	580ms	0ms
	19	15,176	2s919ms	0ms
	20	5,151	916ms	0ms
	21	1,315	220ms	0ms
	22	438	74ms	0ms

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

Date: 2024-12-05 13:01:58 Duration: 15s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1029;

Date: 2024-12-05 13:07:16 Duration: 15s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1081;

Date: 2024-12-05 13:09:19 Duration: 15s

11

53m41s

70,592

Details

32ms

222ms

45ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1	38ms	38ms
	03	25	982ms	39ms
	06	9	397ms	44ms
	07	19	818ms	43ms
	08	1,389	58s504ms	42ms
	09	5,925	4m27s	45ms
	10	8,459	6m55s	49ms
	11	6,140	4m44s	46ms
	12	6,531	5m3s	46ms
	13	6,631	5m6s	46ms
	14	5,946	4m33s	46ms
	15	9,809	7m34s	46ms
	16	4,942	3m45s	45ms
	17	5,801	4m8s	42ms
	18	4,064	2m45s	40ms
	19	4,009	2m57s	44ms
	20	473	19s687ms	41ms
	21	345	13s662ms	39ms
	22	74	2s944ms	39ms

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

Date: 2024-12-05 10:55:20 Duration: 222ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2311282) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:20 Duration: 216ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2588915) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:53:32 Duration: 175ms

12

46m31s

284,795

Details

0ms

14s999ms

9ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 05	00	3,569	232ms	0ms
	01	3,374	238ms	0ms
	02	2,309	157ms	0ms
	03	1,806	118ms	0ms
	04	2,416	170ms	0ms
	05	2,575	175ms	0ms
	06	4,323	300ms	0ms
	07	3,747	242ms	0ms
	08	10,212	604ms	0ms
	09	25,396	1s835ms	0ms
	10	31,836	2s572ms	0ms
	11	4,387	11m52s	162ms
	13	28,118	34m19s	73ms
	14	28,090	1s975ms	0ms
	15	36,186	2s842ms	0ms
	16	24,742	1s744ms	0ms
	17	20,189	1s471ms	0ms
	18	16,441	1s173ms	0ms
	19	13,749	1s131ms	0ms
	20	10,070	711ms	0ms
	21	7,451	504ms	0ms
	22	3,809	270ms	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"."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 (835);

Date: 2024-12-05 13:01:58 Duration: 14s999ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (982, 988);

Date: 2024-12-05 13:09:19 Duration: 14s998ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1);

Date: 2024-12-05 13:04:14 Duration: 14s997ms

13

42m20s

174,794

Details

0ms

14s997ms

14ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	11	76,220	11s290ms	0ms
	12	91,186	13s39ms	0ms
	13	7,388	41m56s	340ms

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 (881);

Date: 2024-12-05 13:15:44 Duration: 14s997ms
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 (995);

Date: 2024-12-05 13:12:40 Duration: 14s996ms
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 (1029);

Date: 2024-12-05 13:14:11 Duration: 14s995ms

14

39m3s

11,098

Details

179ms

452ms

211ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) 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
Dec 05	00	43	8s568ms	199ms
	01	263	52s331ms	198ms
	03	210	41s777ms	198ms
	04	208	41s321ms	198ms
	05	370	1m13s	197ms
	06	1,056	3m31s	199ms
	07	1,042	3m26s	198ms
	08	484	1m36s	198ms
	09	1,687	5m52s	208ms
	10	746	2m47s	224ms
	11	911	3m18s	218ms
	12	1,143	4m11s	219ms
	13	583	2m8s	220ms
	14	515	1m53s	219ms
	15	611	2m10s	212ms
	16	800	2m50s	212ms
	17	95	21s498ms	226ms
	18	18	4s139ms	229ms
	19	78	22s1ms	282ms
	21	123	27s115ms	220ms
	22	112	25s421ms	226ms

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 (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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-05 10:55:26 Duration: 452ms
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" = '9235004')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-05 10:55:22 Duration: 335ms
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" = '9075587')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-05 10:55:24 Duration: 334ms

15

36m33s

11,037

Details

179ms

288ms

198ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."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
Dec 05	00	724	2m22s	196ms
	01	1,032	3m24s	198ms
	02	938	3m4s	196ms
	03	1,517	5m	197ms
	04	2,033	6m41s	197ms
	05	1,702	5m35s	197ms
	06	1,273	4m11s	197ms
	07	1,058	3m30s	198ms
	08	155	30s399ms	196ms
	21	29	6s281ms	216ms
	22	576	2m5s	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" = '9271461')) 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: 2024-12-05 22:02:13 Duration: 288ms
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" = '9145886')) 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: 2024-12-05 22:02:14 Duration: 288ms
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" = '9272316')) 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: 2024-12-05 22:02:16 Duration: 281ms

16

33m55s

23,224

Details

70ms

467ms

87ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	3	252ms	84ms
	08	228	18s570ms	81ms
	09	1,877	2m36s	83ms
	10	2,064	3m8s	91ms
	11	2,435	3m36s	88ms
	12	2,206	3m13s	87ms
	13	2,540	3m44s	88ms
	14	2,562	3m38s	85ms
	15	2,446	3m37s	89ms
	16	1,856	2m39s	85ms
	17	1,924	2m45s	86ms
	18	1,329	1m57s	88ms
	19	858	1m21s	95ms
	20	359	32s157ms	89ms
	21	327	27s187ms	83ms
	22	210	17s166ms	81ms

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

Date: 2024-12-05 10:53:16 Duration: 467ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7761651)) AND (("cash_track"."id" not in (5302394, 5306815, 5307628, 5326359, 5326359)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-05 10:53:16 Duration: 416ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7760863)) AND (("cash_track"."id" not in (5293809, 5304817, 5307979, 5326362, 5326362)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-05 10:53:16 Duration: 267ms

17

21m15s

31,058

Details

28ms

74ms

41ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 05	07	2	80ms	40ms
	08	630	24s280ms	38ms
	09	2,768	1m55s	41ms
	10	4,131	2m54s	42ms
	11	3,349	2m20s	41ms
	12	2,339	1m37s	41ms
	13	2,429	1m42s	42ms
	14	3,247	2m14s	41ms
	15	3,610	2m30s	41ms
	16	2,454	1m41s	41ms
	17	2,291	1m28s	38ms
	18	1,887	1m8s	36ms
	19	1,832	1m12s	39ms
	20	89	3s571ms	40ms

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

Date: 2024-12-05 10:53:31 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3114259) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:16 Duration: 73ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3088655) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:17 Duration: 72ms

18

16m7s

304

Details

477ms

4s604ms

3s182ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	08	9	29s364ms	3s262ms
	09	13	41s138ms	3s164ms
	10	10	31s311ms	3s131ms
	11	10	36s222ms	3s622ms
	12	11	18s836ms	1s712ms
	13	25	1m29s	3s596ms
	14	22	1m16s	3s482ms
	15	34	1m42s	3s7ms
	16	40	2m9s	3s248ms
	17	34	2m2s	3s612ms
	18	27	1m19s	2s959ms
	19	19	43s645ms	2s297ms
	20	36	1m59s	3s331ms
	21	7	22s826ms	3s260ms
	22	7	22s710ms	3s244ms

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

Date: 2024-12-05 09:47:45 Duration: 4s604ms
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 (62))))))) 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 (62)))))) 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 (62)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) 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 (62))))))))) 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 (62)))))))) AND ("policy_number"."name"::text ilike '%916817%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-05 09:47:46 Duration: 4s461ms
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 (62))))))) 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 (62)))))) 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 (62)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) 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 (62))))))))) 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 (62)))))))) AND ("policy_number"."name"::text ilike '%91%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-05 09:47:45 Duration: 4s370ms

19

15m

6,114

Details

120ms

795ms

147ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	01	30	3s926ms	130ms
	02	7	898ms	128ms
	03	5	654ms	130ms
	08	79	10s320ms	130ms
	09	447	1m3s	143ms
	10	816	2m7s	156ms
	11	1,097	2m45s	151ms
	12	1,294	3m10s	146ms
	13	653	1m36s	148ms
	14	551	1m19s	143ms
	15	443	1m4s	144ms
	16	180	25s652ms	142ms
	17	148	21s323ms	144ms
	18	119	16s984ms	142ms
	19	80	11s979ms	149ms
	20	61	8s353ms	136ms
	21	46	6s141ms	133ms
	22	58	7s613ms	131ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 4)) 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: 2024-12-05 10:53:02 Duration: 795ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) 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: 2024-12-05 10:55:23 Duration: 768ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 123)) 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: 2024-12-05 10:55:28 Duration: 538ms

20

11m13s

3,044

Details

16ms

1s977ms

221ms

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
Dec 05	00	2	39ms	19ms
	01	3	374ms	124ms
	06	13	2s868ms	220ms
	07	10	1s876ms	187ms
	08	71	10s940ms	154ms
	09	130	23s593ms	181ms
	10	284	58s928ms	207ms
	11	306	1m12s	236ms
	12	378	1m27s	230ms
	13	472	1m36s	204ms
	14	392	1m29s	228ms
	15	329	1m12s	219ms
	16	265	54s168ms	204ms
	17	158	41s659ms	263ms
	18	78	17s526ms	224ms
	19	54	17s258ms	319ms
	20	49	15s17ms	306ms
	21	38	10s109ms	266ms
	22	12	1s801ms	150ms

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 (123)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) 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: 2024-12-05 15:44:46 Duration: 1s977ms
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: 2024-12-05 11:09:34 Duration: 799ms
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: 2024-12-05 11:09:34 Duration: 728ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,730,379

Details

2m21s

0ms

2ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 05	00	43,925	1s885ms	0ms
	01	44,026	2s17ms	0ms
	02	34,736	1s529ms	0ms
	03	32,329	1s371ms	0ms
	04	35,002	1s618ms	0ms
	05	36,896	1s756ms	0ms
	06	46,322	2s297ms	0ms
	07	42,867	2s39ms	0ms
	08	72,392	3s263ms	0ms
	09	169,626	9s276ms	0ms
	10	222,634	13s66ms	0ms
	11	227,619	11s646ms	0ms
	12	233,035	11s224ms	0ms
	13	227,810	10s105ms	0ms
	14	205,694	10s476ms	0ms
	15	243,280	13s34ms	0ms
	16	192,006	10s480ms	0ms
	17	155,668	8s9ms	0ms
	18	138,305	7s737ms	0ms
	19	123,419	7s404ms	0ms
	20	89,715	5s84ms	0ms
	21	70,017	3s849ms	0ms
	22	43,056	2s282ms	0ms

DISCARD ALL;

Date: 2024-12-05 16:09:37 Duration: 2ms
DISCARD ALL;

Date: 2024-12-05 19:36:01 Duration: 2ms
DISCARD ALL;

Date: 2024-12-05 14:13:01 Duration: 1ms

2

2,099,530

Details

32s680ms

0ms

15ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 05	00	29,831	447ms	0ms
	01	30,324	474ms	0ms
	02	23,006	347ms	0ms
	03	20,979	304ms	0ms
	04	24,015	377ms	0ms
	05	25,179	398ms	0ms
	06	33,771	539ms	0ms
	07	29,964	456ms	0ms
	08	55,460	769ms	0ms
	09	136,629	2s137ms	0ms
	10	179,238	3s16ms	0ms
	11	185,980	2s956ms	0ms
	12	189,729	2s881ms	0ms
	13	177,358	2s531ms	0ms
	14	155,879	2s378ms	0ms
	15	193,892	2s930ms	0ms
	16	144,660	2s284ms	0ms
	17	118,162	1s776ms	0ms
	18	103,627	1s662ms	0ms
	19	93,255	1s662ms	0ms
	20	67,170	1s88ms	0ms
	21	51,172	803ms	0ms
	22	30,250	454ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-05 11:09:34 Duration: 15ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-05 19:05:07 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-05 20:29:55 Duration: 1ms

3

1,382,562

Details

14s393ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 05	00	22,244	212ms	0ms
	01	22,364	216ms	0ms
	02	17,607	160ms	0ms
	03	16,364	142ms	0ms
	04	17,733	167ms	0ms
	05	18,659	174ms	0ms
	06	23,515	230ms	0ms
	07	21,679	203ms	0ms
	08	36,715	330ms	0ms
	09	85,462	894ms	0ms
	10	111,995	1s262ms	0ms
	11	117,660	1s278ms	0ms
	12	120,799	1s246ms	0ms
	13	115,051	1s189ms	0ms
	14	103,304	1s54ms	0ms
	15	122,339	1s255ms	0ms
	16	96,493	998ms	0ms
	17	78,210	823ms	0ms
	18	69,585	722ms	0ms
	19	62,257	745ms	0ms
	20	45,355	494ms	0ms
	21	35,427	374ms	0ms
	22	21,745	215ms	0ms

ROLLBACK;

Date: 2024-12-05 16:55:33 Duration: 0ms
ROLLBACK;

Date: 2024-12-05 00:59:02 Duration: 0ms
ROLLBACK;

Date: 2024-12-05 12:09:41 Duration: 0ms

4

1,367,514

Details

4m13s

0ms

15ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 05	00	21,815	4s37ms	0ms
	01	21,842	4s29ms	0ms
	02	17,193	2s979ms	0ms
	03	15,931	2s551ms	0ms
	04	17,257	3s226ms	0ms
	05	18,198	3s481ms	0ms
	06	22,932	4s409ms	0ms
	07	21,191	3s811ms	0ms
	08	36,097	5s676ms	0ms
	09	85,355	15s982ms	0ms
	10	112,245	22s200ms	0ms
	11	113,774	20s957ms	0ms
	12	116,209	20s476ms	0ms
	13	114,241	20s732ms	0ms
	14	103,504	18s439ms	0ms
	15	122,380	20s932ms	0ms
	16	96,591	17s353ms	0ms
	17	78,229	15s37ms	0ms
	18	69,262	13s631ms	0ms
	19	61,812	13s706ms	0ms
	20	44,902	9s1ms	0ms
	21	35,005	6s765ms	0ms
	22	21,549	3s783ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'dec5bce6cf64d4e8a9b6384d0f6e32f3cb8638e2';

Date: 2024-12-05 11:37:54 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '2390aae55e4ce364fe0073454872bd47ae5f9a35';

Date: 2024-12-05 10:41:47 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '47a208260f0b5d7ca6113fd085410bfd78742f12';

Date: 2024-12-05 10:55:16 Duration: 14ms

5

1,360,817

Details

2m4s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 05	00	21,893	1s891ms	0ms
	01	21,937	1s939ms	0ms
	02	17,292	1s461ms	0ms
	03	16,104	1s304ms	0ms
	04	17,434	1s515ms	0ms
	05	18,381	1s611ms	0ms
	06	23,068	2s82ms	0ms
	07	21,359	1s842ms	0ms
	08	36,047	2s920ms	0ms
	09	84,632	7s687ms	0ms
	10	111,122	10s614ms	0ms
	11	113,013	10s397ms	0ms
	12	115,591	10s255ms	0ms
	13	113,531	10s459ms	0ms
	14	102,701	9s283ms	0ms
	15	121,473	10s885ms	0ms
	16	95,843	8s740ms	0ms
	17	77,692	7s359ms	0ms
	18	69,001	6s637ms	0ms
	19	61,564	6s392ms	0ms
	20	44,743	4s254ms	0ms
	21	34,919	3s204ms	0ms
	22	21,477	1s895ms	0ms

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

Date: 2024-12-05 11:26:22 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-05 09:44:00 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-05 18:39:40 Duration: 1ms

6

716,221

Details

1m55s

0ms

40ms

0ms

commit;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 05	00	7,589	1s229ms	0ms
	01	7,958	1s423ms	0ms
	02	5,400	1s33ms	0ms
	03	4,616	914ms	0ms
	04	6,282	1s417ms	0ms
	05	6,517	1s329ms	0ms
	06	10,258	1s840ms	0ms
	07	8,287	1s589ms	0ms
	08	18,744	2s333ms	0ms
	09	51,168	6s927ms	0ms
	10	67,238	10s865ms	0ms
	11	68,077	12s305ms	0ms
	12	68,667	12s584ms	0ms
	13	62,065	9s352ms	0ms
	14	52,577	8s103ms	0ms
	15	71,551	9s708ms	0ms
	16	48,167	7s256ms	0ms
	17	39,950	6s427ms	0ms
	18	34,042	5s187ms	0ms
	19	30,996	5s585ms	0ms
	20	21,821	3s863ms	0ms
	21	15,745	2s453ms	0ms
	22	8,506	1s480ms	0ms

COMMIT;

Date: 2024-12-05 01:12:29 Duration: 40ms
COMMIT;

Date: 2024-12-05 10:07:36 Duration: 33ms
COMMIT;

Date: 2024-12-05 15:45:11 Duration: 33ms

7

621,938

Details

1m33s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	9,315	1s513ms	0ms
	01	8,901	1s204ms	0ms
	02	5,629	724ms	0ms
	03	4,539	577ms	0ms
	04	6,496	980ms	0ms
	05	6,450	960ms	0ms
	06	9,084	1s276ms	0ms
	07	5,652	761ms	0ms
	08	14,872	2s45ms	0ms
	09	46,637	6s929ms	0ms
	10	59,522	9s841ms	0ms
	11	52,654	7s983ms	0ms
	12	53,340	7s620ms	0ms
	13	47,340	7s271ms	0ms
	14	46,429	6s919ms	0ms
	15	66,359	12s73ms	0ms
	16	41,053	5s727ms	0ms
	17	35,917	5s520ms	0ms
	18	30,294	4s285ms	0ms
	19	28,244	3s976ms	0ms
	20	20,197	2s532ms	0ms
	21	15,223	1s813ms	0ms
	22	7,791	948ms	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 (5100111, 5100352, 5099009, 5106006, 5103548, 5100181, 5100935, 5100950, 5153077, 5099277, 5412585, 5154940, 5099187, 5099333, 5099359, 5099007, 5108449, 5101107, 5103750, 5099590, 5154383, 5099767, 5127704, 5103672, 5113242, 5100132, 5274983, 5266815, 5102152, 5104058, 5101816, 5394763, 5100451);

Date: 2024-12-05 17:21:54 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 (5100111, 5100352, 5099009, 5106006, 5103548, 5100181, 5100935, 5153077, 5099277, 5412585, 5154940, 5099187, 5099333, 5099359, 5099007, 5108449, 5101107, 5103750, 5099590, 5154383, 5099767, 5127704, 5103672, 5113242, 5100132, 5274983, 5266815, 5102152, 5104058, 5101816, 5394763, 5100451);

Date: 2024-12-05 17:21:54 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 (5347379, 5413460, 5194648, 5413348, 5413331, 5377784, 5413125, 5375073, 5413022, 5138720, 5335127, 5412980, 5324888, 5311366, 5247651, 5412494, 5160495, 5412490, 5200709, 5412365, 5160972, 5177456, 5192918, 5296910, 5196281, 5202880, 5179973, 5410885, 5167775, 5144659, 5187188, 5381394, 5372305, 5153788, 5410417, 5410399, 5154726, 5149084, 5138412, 5176544, 5165055, 5151999, 5409413, 5340182, 5409160, 5409044, 5408496, 5174404, 5408250, 5168874, 5408038, 5407946, 5407597, 5259957, 5407720, 5407713, 5228908, 5304480, 5261299, 5161666, 5397461, 5171642, 5213975, 5406991, 5406848, 5134271, 5406776, 5255458, 5136885, 5251795, 5180947, 5227017, 5406380, 5163375, 5188877, 5405818, 5145101, 5362423, 5287348, 5184495, 5157509, 5149605, 5405196, 5405110, 5273776, 5239173, 5404687, 5404682, 5195612, 5235275, 5404284, 5184600, 5232304, 5169853, 5149751, 5403842, 5181208, 5345758, 5160196, 5140584, 5175303, 5253412, 5142608, 5137317, 5402756, 5402742, 5402625, 5185104, 5184571, 5170910, 5402432, 5173776, 5176353, 5182494, 5147297, 5348670, 5313925, 5221817, 5401550, 5344026, 5293512, 5296543, 5149822, 5400783, 5400637, 5400621, 5400622, 5400618, 5146845, 5320907, 5399922, 5399816, 5399606, 5399565, 5275885, 5399138, 5399139, 5180912, 5364894, 5398444, 5205910, 5194301, 5176609, 5168861, 5397655, 5173787, 5372774, 5221812, 5257647, 5219784, 5180370, 5224286, 5170542, 5227094, 5136787, 5218140, 5161183, 5163339, 5395970, 5178603, 5167505, 5290943, 5388095, 5394938, 5161534, 5394864, 5191762, 5360804, 5164695, 5394562, 5250834, 5196509, 5154756, 5394236, 5394199, 5394200, 5382651, 5382134, 5164166, 5200857, 5393807, 5140544, 5183366, 5393415, 5245054, 5393262, 5393237, 5297852, 5392816, 5139053, 5392679, 5392670, 5224564, 5392252, 5190976, 5381600, 5392083, 5180040, 5391987, 5160473, 5391892, 5177866, 5353909, 5391712, 5391650, 5391620, 5391565, 5283224, 5209535, 5158064, 5390315, 5390187, 5166944, 5148736, 5250779, 5389894, 5389692, 5171657, 5164167, 5166182, 5203371, 5389010, 5340876, 5388562, 5168674, 5170479, 5388103, 5278559, 5164808, 5148534, 5200800, 5239086, 5135509, 5189438, 5168817, 5387481, 5153185, 5145116, 5386989, 5261445, 5386590, 5157415, 5172032, 5386579, 5349260, 5247554, 5385653, 5385638, 5150882, 5147315, 5141018, 5227092, 5180627, 5384262, 5192573, 5161654, 5323085, 5382757, 5382650, 5313530, 5382432, 5151993, 5169353, 5382276, 5382149, 5382087, 5381910, 5137147, 5361076, 5381457, 5190794, 5381275, 5381267, 5197509, 5149762, 5380798, 5144305, 5380558, 5168998, 5380460, 5380411, 5380319, 5380320, 5380213, 5257087, 5379318, 5238068, 5353722, 5145970, 5192251, 5257146, 5379077, 5193920, 5149759, 5220484, 5378878, 5153011, 5152256, 5137579, 5377007, 5178974, 5183389, 5290712, 5147187, 5182350, 5375772, 5375713, 5375549, 5375513, 5375445, 5375043, 5170278, 5199064, 5134628, 5374682, 5167761, 5359280, 5374313, 5373470, 5373466, 5373253, 5341068, 5238710, 5192099, 5372553, 5372554, 5372362, 5372355, 5372325, 5372301, 5361453, 5372017, 5372001, 5371856, 5303530, 5371448, 5371335, 5237217, 5332901, 5369531, 5369395, 5369175, 5368861, 5368832, 5357326, 5222724, 5135700, 5368064, 5165469, 5367447, 5349530, 5366838, 5326951, 5366662, 5366082, 5366040, 5231407, 5365880, 5201808, 5169191, 5291464, 5365363, 5361130, 5365318, 5263938, 5364761, 5364606, 5364454, 5262255, 5363654, 5363653, 5166987, 5190356, 5177794, 5203921, 5363267, 5142721, 5186366, 5362671, 5270186, 5330332, 5152500, 5361718, 5361686, 5361682, 5340842, 5221167, 5136297, 5295127, 5361031, 5360545, 5167943, 5150516, 5360389, 5182964, 5360347, 5360340, 5147208, 5157745, 5257067, 5136333, 5359655, 5235259, 5359267, 5359210, 5239629, 5198278, 5359127, 5359017, 5157841, 5358392, 5358123, 5358115, 5357509, 5357346, 5220871, 5356672, 5356446, 5330263, 5163734, 5190098, 5355619, 5355606, 5355557, 5355381, 5195103, 5347265, 5139368, 5265190, 5312831, 5176258, 5353179, 5353106, 5353102, 5278837, 5353095, 5234101, 5168531, 5249519, 5340446, 5282361, 5352866, 5352540, 5341063, 5150575, 5225471, 5188054, 5351540, 5308344, 5150883, 5351140, 5342580, 5349751, 5349628, 5216232, 5333034, 5156447, 5348790, 5260267, 5139237, 5332080, 5249213, 5182421, 5348089, 5348067, 5145643, 5347733, 5347728, 5191782, 5257408, 5347316, 5156833, 5228654, 5346809, 5194053, 5163412, 5346417, 5155696, 5140611, 5345692, 5345513, 5344886, 5231701, 5177706, 5318949, 5344304, 5344305, 5344233, 5173565, 5264353, 5343736, 5149286, 5343594, 5180711, 5337325, 5343281, 5272969, 5235969, 5199386, 5213095, 5178874, 5171569, 5226956, 5342197, 5341848, 5224186, 5155516, 5341388, 5341357, 5179198, 5341215, 5144661, 5181773, 5340923, 5200005, 5337496, 5168875, 5340255, 5265536, 5243090, 5276579, 5338353, 5210565, 5149765, 5337752, 5337737, 5250356, 5336797, 5336798, 5173828, 5336222, 5220713, 5334956, 5334789, 5194273, 5334607, 5334609, 5334608, 5334393, 5334345, 5334329, 5192543, 5334047, 5211789, 5211791, 5196336, 5333849, 5264575, 5153250, 5333341, 5262056, 5327434, 5333165, 5261779, 5332314, 5332214, 5308338, 5331926, 5216115, 5331578, 5151450, 5227865, 5331410, 5331402, 5142090, 5212914, 5331283, 5331282, 5331073, 5331053, 5330998, 5212059, 5330029, 5136328, 5226078, 5216447, 5329849, 5207030, 5209916, 5329382, 5309696, 5329005, 5328758, 5200367, 5327792, 5231227, 5327355, 5327156, 5326910, 5218540, 5326430, 5326280, 5164069, 5216803, 5137891, 5325024, 5324664, 5324636, 5323625, 5291569, 5249465, 5323617, 5323582, 5323578, 5323575, 5323506, 5294436, 5323218, 5323034, 5322840, 5140543, 5188268, 5184042, 5302147, 5322607, 5273256, 5305183, 5172891, 5284434, 5321878, 5321390, 5153834, 5321370, 5154383, 5321183, 5240528, 5136653, 5185729, 5320553, 5320252, 5234495, 5159869, 5319383, 5180582, 5196087, 5177012, 5261950, 5307162, 5282843, 5295353, 5283088, 5153785, 5190113, 5159276, 5317001, 5316890, 5136317, 5316731, 5316730, 5316629, 5316236, 5316245, 5137949, 5316094, 5175853, 5315847, 5315707, 5228084, 5182862, 5315424, 5315266, 5233376, 5163123, 5314271, 5313632, 5167865, 5312849, 5312751, 5199474, 5161300, 5273831, 5185794, 5266591, 5312042, 5269832, 5185424, 5311664, 5160483, 5186838, 5138429, 5169536, 5182331, 5310764, 5310756, 5173612, 5211573, 5310403, 5310352, 5310276, 5310126, 5293632, 5309057, 5308957, 5146696, 5308814, 5308815, 5308655, 5308591, 5265024, 5286516, 5148513, 5307239, 5305919, 5230125, 5305560, 5256303, 5199058, 5238428, 5304973, 5181148, 5304300, 5243906, 5236173, 5304000, 5303969, 5303970, 5303838, 5160496, 5303193, 5262327, 5225281, 5302894, 5302893, 5244077, 5155980, 5302194, 5186822, 5236876, 5301431, 5301410, 5229998, 5300601, 5177437, 5300511, 5300460, 5300317, 5299905, 5260558, 5299984, 5157032, 5298242, 5175972, 5176465, 5207390, 5297142, 5296501, 5192498, 5275071, 5278152, 5295676, 5295647, 5138435, 5295431, 5295382, 5255812, 5206940, 5295079, 5215900, 5247330, 5162401, 5293910, 5283981, 5159755, 5151834, 5288634, 5291805, 5291804, 5291721, 5282841, 5290893, 5290894, 5248454, 5290761, 5231156, 5289990, 5208722, 5289909, 5211480, 5289652, 5288985, 5288714, 5194441, 5288104, 5287736, 5196619, 5228404, 5287146, 5238317, 5286963, 5176512, 5285220, 5285172, 5211781, 5174750, 5284325, 5263292, 5219944, 5283988, 5195529, 5283273, 5162958, 5282990, 5272510, 5282948, 5282696, 5210498, 5282664, 5168851, 5282243, 5281943, 5260270, 5281613, 5280975, 5280974, 5158117, 5280822, 5280823, 5280011, 5220119, 5279841, 5279582, 5150214, 5279557, 5250684, 5278974, 5154691, 5278648, 5278537, 5278529, 5277871, 5277650, 5208973, 5276894, 5257215, 5276852, 5175146, 5276674, 5275894, 5144861, 5275765, 5275721, 5260792, 5274981, 5274974, 5187794, 5173880, 5274561, 5274562, 5149085, 5153368, 5273755, 5273362, 5273328, 5273003, 5191684, 5220853, 5271969, 5271970, 5149613, 5271788, 5145568, 5146124, 5270178, 5269990, 5269991, 5208594, 5269849, 5269632, 5269468, 5268447, 5268951, 5194957, 5252956, 5268579, 5268484, 5268178, 5139545, 5267848, 5267239, 5266683, 5266684, 5246662, 5215284, 5266512, 5266490, 5266447, 5266231, 5197814, 5265414, 5160120, 5265693, 5265569, 5173144, 5170358, 5265445, 5177788, 5264850, 5264635, 5167760, 5264008, 5210370, 5263398, 5204069, 5163477, 5168935, 5261080, 5262849, 5262837, 5262741, 5151771, 5206371, 5200352, 5261979, 5211986, 5261887, 5169326, 5261862, 5186027, 5261777, 5135540, 5261453, 5219237, 5261319, 5219434, 5249839, 5174442, 5208759, 5192853, 5176162, 5150538, 5206421, 5258160, 5230046, 5257684, 5257353, 5195701, 5256155, 5255563, 5177840, 5240435, 5255417, 5255378, 5255368, 5255302, 5255144, 5255145, 5141678, 5254873, 5149081, 5253806, 5253746, 5239253, 5253589, 5251655, 5195456, 5250656, 5250657, 5250315, 5183440, 5250270, 5250020, 5149743, 5174047, 5244551, 5212599, 5237684, 5249617, 5144953, 5249485, 5249424, 5208811, 5248795, 5248709, 5247826, 5247562, 5247508, 5246819, 5246684, 5185921, 5246575, 5232294, 5185484, 5197238, 5245313, 5195430, 5245229, 5179753, 5245123, 5244784, 5244695, 5167519, 5244626, 5175501, 5244410, 5244243, 5210593, 5242891, 5203837, 5242752, 5242545);

Date: 2024-12-05 11:07:14 Duration: 3ms

8

591,533

Details

37s296ms

0ms

16ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 05	00	6,625	400ms	0ms
	01	6,520	357ms	0ms
	02	4,371	235ms	0ms
	03	3,445	174ms	0ms
	04	4,382	231ms	0ms
	05	4,825	246ms	0ms
	06	8,017	430ms	0ms
	07	6,631	373ms	0ms
	08	14,358	777ms	0ms
	09	42,776	2s555ms	0ms
	10	55,349	3s737ms	0ms
	11	51,179	3s314ms	0ms
	12	52,710	3s261ms	0ms
	13	48,783	3s176ms	0ms
	14	46,256	2s678ms	0ms
	15	59,764	4s19ms	0ms
	16	41,093	2s594ms	0ms
	17	34,406	2s168ms	0ms
	18	29,679	1s816ms	0ms
	19	28,080	2s157ms	0ms
	20	20,679	1s313ms	0ms
	21	14,120	837ms	0ms
	22	7,485	437ms	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 (26);

Date: 2024-12-05 10:18:08 Duration: 16ms
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 (52, 27, 110);

Date: 2024-12-05 10:22:13 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 (64, 73, 119, 22, 113, 41);

Date: 2024-12-05 15:19:33 Duration: 1ms

9

413,612

Details

1m17s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	3,873	675ms	0ms
	01	3,948	727ms	0ms
	02	2,559	454ms	0ms
	03	1,930	358ms	0ms
	04	2,646	510ms	0ms
	05	2,985	539ms	0ms
	06	5,921	967ms	0ms
	07	4,571	770ms	0ms
	08	12,939	1s928ms	0ms
	09	32,583	5s760ms	0ms
	10	38,531	7s700ms	0ms
	11	36,904	7s292ms	0ms
	12	38,633	7s271ms	0ms
	13	37,121	7s80ms	0ms
	14	33,805	6s26ms	0ms
	15	41,403	7s919ms	0ms
	16	29,006	5s329ms	0ms
	17	23,791	4s407ms	0ms
	18	19,570	3s541ms	0ms
	19	16,080	3s390ms	0ms
	20	11,703	2s178ms	0ms
	21	8,744	1s550ms	0ms
	22	4,366	793ms	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 (8004725);

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

Date: 2024-12-05 17:21:54 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 (8004685, 8007364);

Date: 2024-12-05 17:21:54 Duration: 4ms

10

350,958

Details

2m

0ms

4ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 05	00	2,499	803ms	0ms
	01	2,333	774ms	0ms
	02	1,358	444ms	0ms
	03	714	260ms	0ms
	04	1,082	385ms	0ms
	05	985	340ms	0ms
	06	2,243	779ms	0ms
	07	2,107	712ms	0ms
	08	8,287	2s633ms	0ms
	09	15,539	5s536ms	0ms
	10	16,295	6s203ms	0ms
	11	41,484	13s866ms	0ms
	12	38,795	12s673ms	0ms
	13	45,006	15s214ms	0ms
	14	18,460	6s573ms	0ms
	15	25,612	9s8ms	0ms
	16	34,481	11s589ms	0ms
	17	22,942	7s929ms	0ms
	18	14,078	4s926ms	0ms
	19	30,437	10s966ms	0ms
	20	15,383	5s240ms	0ms
	21	7,668	2s520ms	0ms
	22	3,170	1s46ms	0ms

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

Date: 2024-12-05 17:21:54 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' 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 = 856) OR r.global) ORDER BY r.id;

Date: 2024-12-05 17:21:54 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.customer' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 830) OR r.global) ORDER BY r.id;

Date: 2024-12-05 11:28:22 Duration: 2ms

11

284,795

Details

46m31s

0ms

14s999ms

9ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 05	00	3,569	232ms	0ms
	01	3,374	238ms	0ms
	02	2,309	157ms	0ms
	03	1,806	118ms	0ms
	04	2,416	170ms	0ms
	05	2,575	175ms	0ms
	06	4,323	300ms	0ms
	07	3,747	242ms	0ms
	08	10,212	604ms	0ms
	09	25,396	1s835ms	0ms
	10	31,836	2s572ms	0ms
	11	4,387	11m52s	162ms
	13	28,118	34m19s	73ms
	14	28,090	1s975ms	0ms
	15	36,186	2s842ms	0ms
	16	24,742	1s744ms	0ms
	17	20,189	1s471ms	0ms
	18	16,441	1s173ms	0ms
	19	13,749	1s131ms	0ms
	20	10,070	711ms	0ms
	21	7,451	504ms	0ms
	22	3,809	270ms	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"."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 (835);

Date: 2024-12-05 13:01:58 Duration: 14s999ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (982, 988);

Date: 2024-12-05 13:09:19 Duration: 14s998ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1);

Date: 2024-12-05 13:04:14 Duration: 14s997ms

12

280,162

Details

1m11s

0ms

15ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	4,625	1s316ms	0ms
	01	4,275	1s97ms	0ms
	02	2,654	623ms	0ms
	03	1,795	426ms	0ms
	04	2,874	817ms	0ms
	05	2,586	755ms	0ms
	06	3,961	1s91ms	0ms
	07	2,440	611ms	0ms
	08	5,941	1s409ms	0ms
	09	18,334	4s713ms	0ms
	10	24,327	6s625ms	0ms
	11	22,190	6s229ms	0ms
	12	22,818	5s903ms	0ms
	13	21,514	5s241ms	0ms
	14	21,979	5s22ms	0ms
	15	29,300	7s979ms	0ms
	16	20,020	4s277ms	0ms
	17	17,133	4s377ms	0ms
	18	15,487	3s722ms	0ms
	19	14,125	3s874ms	0ms
	20	9,793	2s338ms	0ms
	21	8,016	1s827ms	0ms
	22	3,975	893ms	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 (41170574, 41349752, 41291084, 41101348, 41356430, 41304557, 41305361, 41192950, 41319718, 41244534, 41343317, 41345803, 41215475, 41290795, 41410165, 41319126, 41323267, 40236058, 40869971, 41316585, 41337262, 41335555, 41183530, 41332957, 41316534, 41316540, 41229919, 41208525, 41152331, 41152175, 41128544, 41042499, 41272352, 41071775, 41071776, 41098918, 41127959, 41221245, 41165754, 41239569, 41176156, 41017011, 40772504, 41060063, 40794154, 40772451, 40772350, 40828608, 39918460, 39918553, 39542554);

Date: 2024-12-05 14:58:22 Duration: 15ms
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 (41209640, 41320548, 41428609, 41427678, 41312888, 41214823, 41111601, 41413382, 40648130, 41199217, 41239076, 41334275, 41335541, 41420851, 41419323, 41417164, 40927252, 40927028, 41193057, 41391237, 41381907, 41436835, 41335280, 41304394, 41162448, 41366101, 41254216, 40617980, 41390988, 41228962, 41361248, 41196214, 41120736, 40201770, 41134139, 41254516, 40912676, 41196416, 41376457);

Date: 2024-12-05 17:21:54 Duration: 10ms
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 (41209640, 41320548, 41428609, 41427678, 41312888, 41214823, 41111601, 41413382, 41199217, 41239076, 41334275, 41335541, 41420851, 41419323, 41417164, 40927252, 40927028, 41193057, 41391237, 41381907, 41436835, 41335280, 41304394, 41162448, 41366101, 41254216, 40617980, 41390988, 41228962, 41361248, 41196214, 41120736, 40201770, 41134139, 41254516, 40912676, 41196416, 41376457);

Date: 2024-12-05 17:21:54 Duration: 10ms

13

273,060

Details

1d5h28m51s

322ms

2s107ms

388ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 05	00	7,736	47m6s	365ms
	01	8,742	52m37s	361ms
	02	6,644	39m23s	355ms
	03	5,063	29m33s	350ms
	04	8,940	53m1s	355ms
	05	8,860	51m44s	350ms
	06	10,070	59m44s	355ms
	07	6,760	39m30s	350ms
	08	3,341	19m29s	350ms
	09	13,316	1h22m47s	373ms
	10	20,392	2h17m15s	403ms
	11	18,257	1h58m32s	389ms
	12	16,823	1h47m43s	384ms
	13	13,957	1h28m56s	382ms
	14	13,253	1h23m43s	379ms
	15	13,826	1h29m14s	387ms
	16	13,940	1h29m15s	384ms
	17	14,448	1h36m45s	401ms
	18	14,016	1h36m	410ms
	19	23,833	2h59m19s	451ms
	20	15,811	1h47m37s	408ms
	21	9,705	1h4m46s	400ms
	22	5,327	34m43s	391ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3230117)) AND (("shipping_track"."id" not in (26369369, 26374663, 26422347, 26422454, 26422546, 26482271, 26482794, 26483117, 26504542, 26799466, 26799466)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:27 Duration: 2s107ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3230022)) AND (("shipping_track"."id" not in (26368827, 26374801, 26442751, 26442816, 26442867, 26464754, 26464831, 26464935, 26795688, 26796119, 26799444, 26799444)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:23 Duration: 2s
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3220572)) AND (("shipping_track"."id" not in (26315837, 26316464, 26316730, 26377497, 26458746, 26502494, 26797495, 26797495)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:53:04 Duration: 1s990ms

14

250,399

Details

45s180ms

0ms

3ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1,972	286ms	0ms
	01	2,298	326ms	0ms
	02	1,508	191ms	0ms
	03	526	73ms	0ms
	04	1,318	174ms	0ms
	05	1,267	159ms	0ms
	06	2,460	339ms	0ms
	07	2,062	298ms	0ms
	08	8,218	1s199ms	0ms
	09	11,965	1s954ms	0ms
	10	11,406	2s97ms	0ms
	11	29,824	5s583ms	0ms
	12	28,276	5s123ms	0ms
	13	33,116	6s281ms	0ms
	14	11,455	1s999ms	0ms
	15	16,668	3s48ms	0ms
	16	22,269	4s54ms	0ms
	17	16,073	2s929ms	0ms
	18	9,313	1s566ms	0ms
	19	20,422	4s404ms	0ms
	20	10,270	1s886ms	0ms
	21	5,425	860ms	0ms
	22	2,288	341ms	0ms

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

Date: 2024-12-05 11:46:33 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 889 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_cash_policy' AND name = 'group_change_flag_date' AND model = 'res.groups');

Date: 2024-12-05 10:51:54 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-05 12:46:24 Duration: 1ms

15

211,984

Details

16s515ms

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
Dec 05	00	2,418	187ms	0ms
	01	2,597	194ms	0ms
	02	1,684	124ms	0ms
	03	1,474	109ms	0ms
	04	1,906	148ms	0ms
	05	2,043	160ms	0ms
	06	2,782	219ms	0ms
	07	1,947	155ms	0ms
	08	5,156	393ms	0ms
	09	16,433	1s421ms	0ms
	10	20,859	1s774ms	0ms
	11	18,718	1s343ms	0ms
	12	19,333	1s369ms	0ms
	13	17,101	1s393ms	0ms
	14	17,097	1s287ms	0ms
	15	23,461	1s780ms	0ms
	16	13,877	1s41ms	0ms
	17	12,322	883ms	0ms
	18	9,804	701ms	0ms
	19	8,252	867ms	0ms
	20	6,206	563ms	0ms
	21	4,187	252ms	0ms
	22	2,327	143ms	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: 2024-12-05 20:03:36 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: 2024-12-05 13:56:04 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: 2024-12-05 16:39:24 Duration: 0ms

16

174,794

Details

42m20s

0ms

14s997ms

14ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	11	76,220	11s290ms	0ms
	12	91,186	13s39ms	0ms
	13	7,388	41m56s	340ms

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 (881);

Date: 2024-12-05 13:15:44 Duration: 14s997ms
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 (995);

Date: 2024-12-05 13:12:40 Duration: 14s996ms
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 (1029);

Date: 2024-12-05 13:14:11 Duration: 14s995ms

17

168,480

Details

1h41m22s

27ms

169ms

36ms

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	3,872	2m7s	33ms
	01	3,126	1m43s	33ms
	02	2,474	1m22s	33ms
	03	1,321	43s559ms	32ms
	04	3,024	1m40s	33ms
	05	2,080	1m8s	33ms
	06	2,782	1m33s	33ms
	07	1,634	55s187ms	33ms
	08	2,247	1m14s	33ms
	09	9,925	5m52s	35ms
	10	14,952	9m31s	38ms
	11	14,669	9m1s	36ms
	12	14,030	8m30s	36ms
	13	11,720	7m4s	36ms
	14	11,055	6m33s	35ms
	15	12,214	7m20s	36ms
	16	10,250	6m1s	35ms
	17	9,337	5m41s	36ms
	18	9,860	5m59s	36ms
	19	11,272	7m29s	39ms
	20	7,801	4m40s	36ms
	21	5,917	3m25s	34ms
	22	2,918	1m40s	34ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3223356)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:55:24 Duration: 169ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3189390)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:53:22 Duration: 159ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3213948)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:55:26 Duration: 157ms

18

166,971

Details

1m38s

0ms

19ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 05	00	773	838ms	1ms
	01	318	181ms	0ms
	02	140	87ms	0ms
	03	126	77ms	0ms
	04	156	116ms	0ms
	05	184	112ms	0ms
	06	685	310ms	0ms
	07	1,430	644ms	0ms
	08	4,096	2s78ms	0ms
	09	9,884	5s455ms	0ms
	10	15,278	9s546ms	0ms
	11	13,658	8s544ms	0ms
	12	13,190	8s120ms	0ms
	13	15,451	9s371ms	0ms
	14	13,971	8s854ms	0ms
	15	14,504	9s471ms	0ms
	16	12,574	7s190ms	0ms
	17	10,942	7s195ms	0ms
	18	6,558	4s63ms	0ms
	19	22,707	10s989ms	0ms
	20	7,948	4s118ms	0ms
	21	1,710	922ms	0ms
	22	688	358ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (2889582, 2541331, 2596301, 2639708, 2730091, 2937496, 2961009, 2904474, 2387651, 2464062, 2650986, 97980, 283474, 707327, 753352, 926529, 1140370, 1284391, 1819379, 2283628, 2341287, 1891675, 1677752, 2054950, 1779713, 1898643, 2137716, 2086346, 2101974, 2996293, 3029508, 2439675, 2648969, 2645832, 2686390, 2245739, 3064772, 2683577, 2493116, 3101828, 2420574, 2591839, 2729530, 2779730, 2460915, 2321438, 2644905, 2597291, 2686098, 2963775, 3034469, 3147771, 2927532, 2982734, 3093248, 3121320, 3121310, 3121313, 3139439, 2549489, 2589502, 2589481, 2615858, 2966797, 2955761, 2977626, 3113208, 3110051, 2826444, 2648630, 2649662, 2649302, 2829354, 3069828, 3069649, 3015051, 3015061, 3113919, 3114186, 3141607, 3141609, 3113921, 3114256, 3129378, 3129374, 3129347, 3160953, 3160955, 3160945, 3160951, 3160949, 2766270, 2832203, 2832204, 2752444, 2935653, 3099897, 2780991, 3064444, 2826139, 2826141, 2826144, 2826156, 2827577, 2826154, 2887843, 2887839, 2903893, 2903687, 2903674, 2903693, 2903427, 2952778, 2952771, 2977706, 2977708, 3067305, 3069562, 3145900, 3136604, 3089566, 3099020, 3100272, 3099205, 3068531, 3066506, 3112566, 3144933, 3175539, 3173780, 3066105, 2963780, 2964407, 2961065, 2964403, 2996257, 3145523, 3190743, 3145754, 3175163, 3175426, 3172721, 3172720, 3172241, 3099910, 3098596, 3101438, 3113749, 3145123, 2903680, 2903681, 2903676, 2931745, 2931741, 2931714, 2931721, 2931725, 2931709, 2993912, 3024715, 2994103, 2994079, 2994092, 2994067, 2994077, 2994075, 2994091, 2994081, 3024701, 3024626, 2994071, 2994101, 2993911, 2994089, 2994099, 2994100, 3092235, 3092236, 3092239, 3114360, 3092219, 3092249, 3092199, 3092241, 2994083, 2994088, 2994087, 2994084, 2994090, 2994068, 2994074, 3024635, 3024673, 3024640, 3024668, 3024706, 3025343, 3025345, 3024696, 3024688, 3024644, 3024649, 3024660, 3024622, 3025393, 3025340, 3024613, 3024616, 3024678, 3024691, 3146557, 3064768, 3065287, 3065271, 3065266, 3064446, 3064481, 3064441, 3064771, 3065273, 3064483, 3064482, 3065268, 3064442, 3064759, 3064440, 3064439, 3065282, 3064773, 3114370, 3131649, 2957367, 2965028, 3060381, 3065514, 3068194, 3060317, 3065556, 3139264, 3139440, 2932549, 2919019, 3018497, 3067202, 3067201, 3100127, 3098559, 3096427, 3098557, 3099948, 3100331, 3100465, 3094919, 3098556, 3100129, 3089642, 3170835, 3140563, 3140558, 3140559, 3174160, 3147236, 3140562, 3140572, 3006608, 3006627, 3006623, 3006618, 3044954, 3080257, 3080269, 3080265, 3124667, 2982692, 2982694, 2982696, 3021474, 3083717, 3058680, 3042942, 3042945, 3023905, 3146194, 2997304, 2964322, 3077464, 3077434, 3077480, 3091337, 3023925, 3092257, 3092254, 3092252, 3092247, 3092209, 3092228, 3092242, 3092244, 3092207, 3092246, 3092232, 3092233, 3114364, 3114213, 3114184, 3114067, 3114149, 3114121, 3136863, 3114049, 3114136, 3146288, 3148086, 3148096, 3146168, 3146544, 3148194, 3146312, 3148183, 3176415, 3146287, 3146304, 3140619, 3080246, 3080242, 3080231, 3122180, 3122190, 3122194, 3122199, 3164606, 3134756, 3107953, 3129275, 3121145, 3145956, 3140601, 3110639, 3113715, 3173799, 3146169, 3149290, 3172239, 3170834, 3170838, 3174494, 3174134, 3181047, 3174395, 3175520, 3174325, 3171480, 3174127, 3170641, 3170662, 3170650, 3209621);

Date: 2024-12-05 17:38:02 Duration: 19ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3198460, 3165265, 3165363, 3165342, 3134160, 3198084, 3134170, 3059066, 3198166, 3134186, 3028304, 3147110, 3134177, 3147108, 3165367, 3165382, 3059069, 3179211, 3165256, 3059188, 3134320, 3134179, 3165375, 3165365, 3165339, 2738056, 2679118, 3134182, 3134183, 3165349, 3167095, 3167135, 3165346, 3165262, 3165266, 3090879, 3165213, 3165255, 2976415, 3090707, 3028369, 3128170, 3165264, 3059091, 3134159, 2738024, 3034494, 3028396, 3134181, 3090885, 3059145, 2923533, 3134161, 3134180, 3134174, 3134184, 3134169, 3059138, 3134172, 3059081, 3108420, 3134188, 3134158, 3134171, 3134313, 3134194, 3090932, 3134168, 3134163, 3134156, 3134154, 3134173, 3059119, 3059095, 3134166, 3134178, 2965373, 3091002, 3108415, 3134165);

Date: 2024-12-05 17:21:54 Duration: 19ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3198460, 3165265, 3165363, 3165342, 3134160, 3198084, 3134170, 3059066, 3198166, 3134186, 3028304, 3147110, 3134177, 3147108, 3165367, 3165382, 3059069, 3179211, 3165256, 3059188, 3134320, 3134179, 3165375, 3165365, 3165339, 2738056, 2679118, 3134182, 3134183, 3165349, 3167095, 3167135, 3165346, 3165262, 3165266, 3090879, 3165213, 3165255, 2976415, 3090707, 3028369, 3128170, 3165264, 3059091, 3134159, 2738024, 3034494, 3028396, 3134181, 3090885, 3059145, 2923533, 3134161, 3134180, 3134174, 3134184, 3134169, 3059138, 3134172, 3059081, 3108420, 3134188, 3134158, 3134171, 3134313, 3134194, 3090932, 3134168, 3134163, 3134156, 3134154, 3134173, 3059119, 3059095, 3134166, 3134178, 2965373, 3091002, 3108415, 3134165);

Date: 2024-12-05 17:21:54 Duration: 19ms

19

152,672

Details

9s143ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1,010	52ms	0ms
	01	985	51ms	0ms
	02	594	28ms	0ms
	03	258	13ms	0ms
	04	445	23ms	0ms
	05	383	19ms	0ms
	06	955	51ms	0ms
	07	886	47ms	0ms
	08	3,903	206ms	0ms
	09	6,440	375ms	0ms
	10	6,745	429ms	0ms
	11	17,798	1s75ms	0ms
	12	17,112	1s11ms	0ms
	13	20,937	1s275ms	0ms
	14	7,651	450ms	0ms
	15	10,857	650ms	0ms
	16	15,216	883ms	0ms
	17	10,221	616ms	0ms
	18	6,113	350ms	0ms
	19	12,876	883ms	0ms
	20	6,716	403ms	0ms
	21	3,284	175ms	0ms
	22	1,287	67ms	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 (97);

Date: 2024-12-05 14:24:34 Duration: 2ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2024-12-05 16:41:08 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2024-12-05 10:51:26 Duration: 0ms

20

147,618

Details

10s743ms

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
Dec 05	00	2,348	116ms	0ms
	01	3,103	134ms	0ms
	02	2,077	83ms	0ms
	03	1,909	78ms	0ms
	04	2,405	99ms	0ms
	05	2,446	98ms	0ms
	06	3,169	150ms	0ms
	07	1,849	97ms	0ms
	08	3,182	193ms	0ms
	09	10,327	612ms	0ms
	10	11,805	802ms	0ms
	11	12,985	1s127ms	0ms
	12	13,174	1s72ms	0ms
	13	11,522	1s40ms	0ms
	14	8,685	569ms	0ms
	15	15,962	1s66ms	0ms
	16	9,360	785ms	0ms
	17	7,514	620ms	0ms
	18	6,054	401ms	0ms
	19	7,790	877ms	0ms
	20	5,383	454ms	0ms
	21	2,694	164ms	0ms
	22	1,875	95ms	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 (47, 40, 81, 18, 89, 106, 42, 105, 84, 95, 90, 48, 83, 71, 15, 64, 56, 28, 54, 101, 80, 11, 66, 67, 73, 61, 69, 49, 108, 41, 79, 53, 16, 34, 98, 14, 68);

Date: 2024-12-05 15:47:28 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 (73);

Date: 2024-12-05 16:43:52 Duration: 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 (14, 18, 61);

Date: 2024-12-05 11:26:46 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

477ms

4s604ms

3s182ms

304

Details

16m7s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 05	08	9	29s364ms	3s262ms
	09	13	41s138ms	3s164ms
	10	10	31s311ms	3s131ms
	11	10	36s222ms	3s622ms
	12	11	18s836ms	1s712ms
	13	25	1m29s	3s596ms
	14	22	1m16s	3s482ms
	15	34	1m42s	3s7ms
	16	40	2m9s	3s248ms
	17	34	2m2s	3s612ms
	18	27	1m19s	2s959ms
	19	19	43s645ms	2s297ms
	20	36	1m59s	3s331ms
	21	7	22s826ms	3s260ms
	22	7	22s710ms	3s244ms

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

Date: 2024-12-05 09:47:45 Duration: 4s604ms
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 (62))))))) 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 (62)))))) 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 (62)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) 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 (62))))))))) 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 (62)))))))) AND ("policy_number"."name"::text ilike '%916817%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-05 09:47:46 Duration: 4s461ms
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 (62))))))) 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 (62)))))) 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 (62)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) 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 (62))))))))) 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 (62)))))))) AND ("policy_number"."name"::text ilike '%91%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-05 09:47:45 Duration: 4s370ms

2

0ms

15m3s

2s894ms

19,431

Details

15h37m28s

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
Dec 05	11	9,029	5h31m13s	2s201ms
	12	9,449	9h40m40s	3s687ms
	13	953	25m35s	1s610ms

update res_users set sid = '0dd2c2e8feeb61175c84afe659fd80653d1e107f', last_update = '2024-12-05 10:54:16.489649', exp_date = '2024-12-05 11:39:16.489651', logged_in = 'TRUE' where id = 917;

Date: 2024-12-05 12:09:20 Duration: 15m3s
update res_users set sid = '202cb5f31c996c00b49bfb386150f0a6e336c705', last_update = '2024-12-05 10:54:17.516409', exp_date = '2024-12-05 11:39:17.516412', logged_in = 'TRUE' where id = 843;

Date: 2024-12-05 12:09:20 Duration: 15m2s
update res_users set sid = '94bbec47944bfea6d4a1878773225b098718a9f8', last_update = '2024-12-05 10:54:46.216862', exp_date = '2024-12-05 11:39:46.216866', logged_in = 'TRUE' where id = 843;

Date: 2024-12-05 12:09:20 Duration: 14m34s

3

252ms

1s496ms

1s3ms

11,908

Details

3h19m5s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	651	10m21s	954ms
	01	566	9m7s	966ms
	02	345	5m31s	962ms
	06	1	931ms	931ms
	08	52	49s648ms	954ms
	09	20	18s892ms	944ms
	10	31	33s622ms	1s84ms
	11	24	26s174ms	1s90ms
	12	138	2m24s	1s48ms
	13	1	1s9ms	1s9ms
	14	420	7m12s	1s28ms
	15	594	10m42s	1s82ms
	16	910	15m27s	1s19ms
	17	743	12m52s	1s39ms
	18	1,773	30m2s	1s16ms
	19	2,178	38m5s	1s49ms
	20	1,102	17m55s	975ms
	21	1,844	28m58s	942ms
	22	515	8m13s	957ms

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

Date: 2024-12-05 19:51:19 Duration: 1s496ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9223352')) 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 (22))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-05 19:07:34 Duration: 1s467ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '8498984')) 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 (60))))))) 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 (60)))))) 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 (60)))))) 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 (60))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-05 19:51:28 Duration: 1s452ms

4

323ms

3s102ms

399ms

46,812

Details

5h11m20s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 05	00	280	1m43s	369ms
	01	286	1m49s	382ms
	02	111	45s897ms	413ms
	03	111	46s319ms	417ms
	04	141	58s627ms	415ms
	05	150	1m	402ms
	06	308	2m	391ms
	07	305	1m57s	384ms
	08	582	3m33s	366ms
	09	3,541	22m41s	384ms
	10	5,029	34m17s	409ms
	11	4,072	27m23s	403ms
	12	4,015	26m32s	396ms
	13	3,786	25m2s	396ms
	14	4,602	29m28s	384ms
	15	2,606	17m18s	398ms
	16	3,188	20m20s	382ms
	17	3,502	23m27s	401ms
	18	2,796	18m52s	405ms
	19	2,944	21m59s	448ms
	20	2,192	14m50s	406ms
	21	1,364	8m44s	384ms
	22	901	5m46s	384ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3254714, 3255840, 3255768, 3257955, 3265068, 3260988, 3261930, 3262182, 3261069, 3265225, 3265597, 3266157, 3267432, 3269331, 3270094, 3272084, 3281290, 3256301, 3245626, 3278522, 3252682, 3252683, 3254704, 3273528, 3256241, 3245660, 3272310, 3272188, 3265245, 3275827, 3274600, 3276673, 3277212, 3277626, 3255852, 3277553, 3279360, 3280314, 3281316, 3280406, 3282537, 3283110, 3283173, 3284561, 3284576, 3275816, 3269626, 3257102)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:53:00 Duration: 3s102ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3230117)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:25 Duration: 2s437ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3248320)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:53:15 Duration: 1s966ms

5

322ms

2s107ms

388ms

273,060

Details

1d5h28m51s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	7,736	47m6s	365ms
	01	8,742	52m37s	361ms
	02	6,644	39m23s	355ms
	03	5,063	29m33s	350ms
	04	8,940	53m1s	355ms
	05	8,860	51m44s	350ms
	06	10,070	59m44s	355ms
	07	6,760	39m30s	350ms
	08	3,341	19m29s	350ms
	09	13,316	1h22m47s	373ms
	10	20,392	2h17m15s	403ms
	11	18,257	1h58m32s	389ms
	12	16,823	1h47m43s	384ms
	13	13,957	1h28m56s	382ms
	14	13,253	1h23m43s	379ms
	15	13,826	1h29m14s	387ms
	16	13,940	1h29m15s	384ms
	17	14,448	1h36m45s	401ms
	18	14,016	1h36m	410ms
	19	23,833	2h59m19s	451ms
	20	15,811	1h47m37s	408ms
	21	9,705	1h4m46s	400ms
	22	5,327	34m43s	391ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3230117)) AND (("shipping_track"."id" not in (26369369, 26374663, 26422347, 26422454, 26422546, 26482271, 26482794, 26483117, 26504542, 26799466, 26799466)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:27 Duration: 2s107ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3230022)) AND (("shipping_track"."id" not in (26368827, 26374801, 26442751, 26442816, 26442867, 26464754, 26464831, 26464935, 26795688, 26796119, 26799444, 26799444)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:55:23 Duration: 2s
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3220572)) AND (("shipping_track"."id" not in (26315837, 26316464, 26316730, 26377497, 26458746, 26502494, 26797495, 26797495)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-05 10:53:04 Duration: 1s990ms

6

226ms

622ms

312ms

17,721

Details

1h32m22s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1,496	7m9s	287ms
	01	1,087	5m9s	284ms
	02	606	2m51s	282ms
	03	319	1m30s	282ms
	04	962	4m36s	287ms
	05	524	2m27s	280ms
	06	1,092	5m10s	284ms
	07	370	1m44s	281ms
	08	102	28s845ms	282ms
	09	76	24s537ms	322ms
	10	188	55s820ms	296ms
	11	27	8s129ms	301ms
	12	14	4s451ms	317ms
	13	59	17s841ms	302ms
	14	226	1m16s	336ms
	15	330	1m44s	315ms
	16	1,484	7m40s	310ms
	17	1,049	5m51s	334ms
	18	1,144	6m20s	332ms
	19	2,495	15m17s	367ms
	20	1,843	9m53s	322ms
	21	1,484	7m39s	309ms
	22	744	3m39s	295ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '465013')) 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: 2024-12-05 19:51:17 Duration: 622ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9240558')) 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: 2024-12-05 19:10:43 Duration: 603ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9240633')) 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: 2024-12-05 19:10:47 Duration: 572ms

7

190ms

633ms

267ms

41,607

Details

3h5m26s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	07	491	1m57s	240ms
	08	1,606	6m26s	240ms
	09	3,459	15m3s	261ms
	10	6,565	30m	274ms
	11	4,258	18m57s	267ms
	12	2,915	12m54s	265ms
	13	4,209	19m	271ms
	14	3,940	17m24s	265ms
	15	4,321	19m7s	265ms
	16	2,972	12m43s	256ms
	17	2,747	12m24s	271ms
	18	1,970	8m50s	269ms
	19	2,154	10m34s	294ms

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

Date: 2024-12-05 10:55:30 Duration: 633ms
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" = '8937307')))) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:30 Duration: 596ms
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" = '8942292')))) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:32 Duration: 579ms

8

92ms

886ms

234ms

58,340

Details

3h48m26s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	4,253	15m11s	214ms
	01	3,280	12m42s	232ms
	02	1,888	6m10s	196ms
	03	628	2m27s	234ms
	04	1,908	7m59s	251ms
	05	1,037	4m5s	236ms
	06	2,163	7m47s	216ms
	07	732	2m40s	219ms
	08	292	1m3s	216ms
	09	172	47s88ms	273ms
	10	422	1m37s	230ms
	11	96	24s763ms	257ms
	12	302	1m15s	248ms
	13	118	31s726ms	268ms
	14	1,262	5m42s	271ms
	15	1,798	7m14s	241ms
	16	4,722	18m43s	237ms
	17	3,546	14m14s	240ms
	18	5,794	22m14s	230ms
	19	9,179	41m10s	269ms
	20	5,756	22m17s	232ms
	21	6,516	23m27s	215ms
	22	2,476	8m37s	208ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حمدي')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-05 14:22:46 Duration: 886ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'بدون')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-05 14:22:46 Duration: 885ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبدالرحمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-05 19:40:24 Duration: 885ms

9

177ms

1s95ms

224ms

132,088

Details

8h14m28s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1,041	3m25s	196ms
	01	1,319	4m21s	198ms
	02	944	3m5s	196ms
	03	1,757	5m48s	198ms
	04	2,241	7m22s	197ms
	05	2,220	7m18s	197ms
	06	2,880	9m33s	199ms
	07	3,428	11m23s	199ms
	08	3,822	12m39s	198ms
	09	8,487	30m6s	212ms
	10	12,185	45m50s	225ms
	11	10,358	38m10s	221ms
	12	8,445	30m53s	219ms
	13	11,514	42m33s	221ms
	14	7,517	27m5s	216ms
	15	10,079	36m15s	215ms
	16	8,977	31m39s	211ms
	17	6,742	25m12s	224ms
	18	4,144	15m49s	229ms
	19	19,244	1h26m44s	270ms
	20	3,580	14m54s	249ms
	21	476	1m43s	216ms
	22	688	2m31s	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" = '9005818')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-05 10:55:24 Duration: 1s95ms
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" = '8510195')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-05 10:55:18 Duration: 1s69ms
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" = '8775279')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-05 10:55:21 Duration: 715ms

10

16ms

1s977ms

221ms

3,044

Details

11m13s

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
Dec 05	00	2	39ms	19ms
	01	3	374ms	124ms
	06	13	2s868ms	220ms
	07	10	1s876ms	187ms
	08	71	10s940ms	154ms
	09	130	23s593ms	181ms
	10	284	58s928ms	207ms
	11	306	1m12s	236ms
	12	378	1m27s	230ms
	13	472	1m36s	204ms
	14	392	1m29s	228ms
	15	329	1m12s	219ms
	16	265	54s168ms	204ms
	17	158	41s659ms	263ms
	18	78	17s526ms	224ms
	19	54	17s258ms	319ms
	20	49	15s17ms	306ms
	21	38	10s109ms	266ms
	22	12	1s801ms	150ms

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 (123)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) 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: 2024-12-05 15:44:46 Duration: 1s977ms
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: 2024-12-05 11:09:34 Duration: 799ms
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: 2024-12-05 11:09:34 Duration: 728ms

11

179ms

452ms

211ms

11,098

Details

39m3s

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
Dec 05	00	43	8s568ms	199ms
	01	263	52s331ms	198ms
	03	210	41s777ms	198ms
	04	208	41s321ms	198ms
	05	370	1m13s	197ms
	06	1,056	3m31s	199ms
	07	1,042	3m26s	198ms
	08	484	1m36s	198ms
	09	1,687	5m52s	208ms
	10	746	2m47s	224ms
	11	911	3m18s	218ms
	12	1,143	4m11s	219ms
	13	583	2m8s	220ms
	14	515	1m53s	219ms
	15	611	2m10s	212ms
	16	800	2m50s	212ms
	17	95	21s498ms	226ms
	18	18	4s139ms	229ms
	19	78	22s1ms	282ms
	21	123	27s115ms	220ms
	22	112	25s421ms	226ms

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 (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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-05 10:55:26 Duration: 452ms
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" = '9235004')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-05 10:55:22 Duration: 335ms
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" = '9075587')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-05 10:55:24 Duration: 334ms

12

179ms

288ms

198ms

11,037

Details

36m33s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	724	2m22s	196ms
	01	1,032	3m24s	198ms
	02	938	3m4s	196ms
	03	1,517	5m	197ms
	04	2,033	6m41s	197ms
	05	1,702	5m35s	197ms
	06	1,273	4m11s	197ms
	07	1,058	3m30s	198ms
	08	155	30s399ms	196ms
	21	29	6s281ms	216ms
	22	576	2m5s	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" = '9271461')) 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: 2024-12-05 22:02:13 Duration: 288ms
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" = '9145886')) 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: 2024-12-05 22:02:14 Duration: 288ms
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" = '9272316')) 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: 2024-12-05 22:02:16 Duration: 281ms

13

120ms

795ms

147ms

6,114

Details

15m

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

Day	Hour	Count	Duration	Avg duration
Dec 05	01	30	3s926ms	130ms
	02	7	898ms	128ms
	03	5	654ms	130ms
	08	79	10s320ms	130ms
	09	447	1m3s	143ms
	10	816	2m7s	156ms
	11	1,097	2m45s	151ms
	12	1,294	3m10s	146ms
	13	653	1m36s	148ms
	14	551	1m19s	143ms
	15	443	1m4s	144ms
	16	180	25s652ms	142ms
	17	148	21s323ms	144ms
	18	119	16s984ms	142ms
	19	80	11s979ms	149ms
	20	61	8s353ms	136ms
	21	46	6s141ms	133ms
	22	58	7s613ms	131ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 4)) 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: 2024-12-05 10:53:02 Duration: 795ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) 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: 2024-12-05 10:55:23 Duration: 768ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 123)) 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: 2024-12-05 10:55:28 Duration: 538ms

14

70ms

467ms

87ms

23,224

Details

33m55s

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
Dec 05	00	3	252ms	84ms
	08	228	18s570ms	81ms
	09	1,877	2m36s	83ms
	10	2,064	3m8s	91ms
	11	2,435	3m36s	88ms
	12	2,206	3m13s	87ms
	13	2,540	3m44s	88ms
	14	2,562	3m38s	85ms
	15	2,446	3m37s	89ms
	16	1,856	2m39s	85ms
	17	1,924	2m45s	86ms
	18	1,329	1m57s	88ms
	19	858	1m21s	95ms
	20	359	32s157ms	89ms
	21	327	27s187ms	83ms
	22	210	17s166ms	81ms

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

Date: 2024-12-05 10:53:16 Duration: 467ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7761651)) AND (("cash_track"."id" not in (5302394, 5306815, 5307628, 5326359, 5326359)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-05 10:53:16 Duration: 416ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7760863)) AND (("cash_track"."id" not in (5293809, 5304817, 5307979, 5326362, 5326362)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-05 10:53:16 Duration: 267ms

15

32ms

222ms

45ms

70,592

Details

53m41s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 05	00	1	38ms	38ms
	03	25	982ms	39ms
	06	9	397ms	44ms
	07	19	818ms	43ms
	08	1,389	58s504ms	42ms
	09	5,925	4m27s	45ms
	10	8,459	6m55s	49ms
	11	6,140	4m44s	46ms
	12	6,531	5m3s	46ms
	13	6,631	5m6s	46ms
	14	5,946	4m33s	46ms
	15	9,809	7m34s	46ms
	16	4,942	3m45s	45ms
	17	5,801	4m8s	42ms
	18	4,064	2m45s	40ms
	19	4,009	2m57s	44ms
	20	473	19s687ms	41ms
	21	345	13s662ms	39ms
	22	74	2s944ms	39ms

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

Date: 2024-12-05 10:55:20 Duration: 222ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2311282) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:20 Duration: 216ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2588915) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:53:32 Duration: 175ms

16

28ms

74ms

41ms

31,058

Details

21m15s

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
Dec 05	07	2	80ms	40ms
	08	630	24s280ms	38ms
	09	2,768	1m55s	41ms
	10	4,131	2m54s	42ms
	11	3,349	2m20s	41ms
	12	2,339	1m37s	41ms
	13	2,429	1m42s	42ms
	14	3,247	2m14s	41ms
	15	3,610	2m30s	41ms
	16	2,454	1m41s	41ms
	17	2,291	1m28s	38ms
	18	1,887	1m8s	36ms
	19	1,832	1m12s	39ms
	20	89	3s571ms	40ms

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

Date: 2024-12-05 10:53:31 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3114259) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:16 Duration: 73ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3088655) ORDER BY "collection_policy"."id";

Date: 2024-12-05 10:55:17 Duration: 72ms

17

0ms

15s

36ms

121,174

Details

1h13m37s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 05	00	518	78ms	0ms
	01	472	75ms	0ms
	02	200	32ms	0ms
	03	80	13ms	0ms
	04	177	30ms	0ms
	05	180	30ms	0ms
	06	461	77ms	0ms
	07	383	63ms	0ms
	08	2,399	375ms	0ms
	09	3,573	604ms	0ms
	10	3,549	642ms	0ms
	11	16,880	3m11s	11ms
	12	14,730	1s478ms	0ms
	13	20,947	1h10m11s	201ms
	14	3,764	640ms	0ms
	15	7,800	1s356ms	0ms
	16	12,208	2s145ms	0ms
	17	7,403	1s381ms	0ms
	18	3,370	580ms	0ms
	19	15,176	2s919ms	0ms
	20	5,151	916ms	0ms
	21	1,315	220ms	0ms
	22	438	74ms	0ms

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

Date: 2024-12-05 13:01:58 Duration: 15s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1029;

Date: 2024-12-05 13:07:16 Duration: 15s
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1081;

Date: 2024-12-05 13:09:19 Duration: 15s

18

27ms

169ms

36ms

168,480

Details

1h41m22s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	00	3,872	2m7s	33ms
	01	3,126	1m43s	33ms
	02	2,474	1m22s	33ms
	03	1,321	43s559ms	32ms
	04	3,024	1m40s	33ms
	05	2,080	1m8s	33ms
	06	2,782	1m33s	33ms
	07	1,634	55s187ms	33ms
	08	2,247	1m14s	33ms
	09	9,925	5m52s	35ms
	10	14,952	9m31s	38ms
	11	14,669	9m1s	36ms
	12	14,030	8m30s	36ms
	13	11,720	7m4s	36ms
	14	11,055	6m33s	35ms
	15	12,214	7m20s	36ms
	16	10,250	6m1s	35ms
	17	9,337	5m41s	36ms
	18	9,860	5m59s	36ms
	19	11,272	7m29s	39ms
	20	7,801	4m40s	36ms
	21	5,917	3m25s	34ms
	22	2,918	1m40s	34ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3223356)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:55:24 Duration: 169ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3189390)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:53:22 Duration: 159ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3213948)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-05 10:55:26 Duration: 157ms

19

0ms

14s997ms

14ms

174,794

Details

42m20s

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

Day	Hour	Count	Duration	Avg duration
Dec 05	11	76,220	11s290ms	0ms
	12	91,186	13s39ms	0ms
	13	7,388	41m56s	340ms

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 (881);

Date: 2024-12-05 13:15:44 Duration: 14s997ms
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 (995);

Date: 2024-12-05 13:12:40 Duration: 14s996ms
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 (1029);

Date: 2024-12-05 13:14:11 Duration: 14s995ms

20

0ms

14s999ms

9ms

284,795

Details

46m31s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 05	00	3,569	232ms	0ms
	01	3,374	238ms	0ms
	02	2,309	157ms	0ms
	03	1,806	118ms	0ms
	04	2,416	170ms	0ms
	05	2,575	175ms	0ms
	06	4,323	300ms	0ms
	07	3,747	242ms	0ms
	08	10,212	604ms	0ms
	09	25,396	1s835ms	0ms
	10	31,836	2s572ms	0ms
	11	4,387	11m52s	162ms
	13	28,118	34m19s	73ms
	14	28,090	1s975ms	0ms
	15	36,186	2s842ms	0ms
	16	24,742	1s744ms	0ms
	17	20,189	1s471ms	0ms
	18	16,441	1s173ms	0ms
	19	13,749	1s131ms	0ms
	20	10,070	711ms	0ms
	21	7,451	504ms	0ms
	22	3,809	270ms	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"."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 (835);

Date: 2024-12-05 13:01:58 Duration: 14s999ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (982, 988);

Date: 2024-12-05 13:09:19 Duration: 14s998ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1);

Date: 2024-12-05 13:04:14 Duration: 14s997ms

Time consuming prepare


Date: 2024-12-05 10:53:58
Duration: 3ms
Database: postgres
Date: 2024-12-05 10:53:38
Duration: 1ms
Database: postgres
Date: 2024-12-05 17:21:55
Duration: 1ms
Database: postgres
Date: 2024-12-05 15:22:19
Duration: 0ms
Database: postgres
Date: 2024-12-05 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-05 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-05 17:21:55
Duration: 0ms
Database: postgres

Time consuming bind


Date: 2024-12-05 10:53:58
Duration: 6ms
Database: postgres
Date: 2024-12-05 10:53:38
Duration: 0ms
Database: postgres
Date: 2024-12-05 19:01:58
Duration: 0ms
Database: postgres
Date: 2024-12-05 08:52:13
Duration: 0ms
Database: postgres
Date: 2024-12-05 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-05 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-05 17:21:55
Duration: 0ms
Database: postgres

Log levels

Key values

22,572,368 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	10	0.00%
DETAIL	34	0.00%
ERROR	5,212	0.02%
FATAL	807	0.00%
HINT	141	0.00%
LOG	22,561,574	99.95%
STATEMENT	4,590	0.02%

Events distribution

Key values

0 PANIC entries
807 FATAL entries
5246 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

2,206 Max number of times the same event was reported
6,053 Total events found

Rank

Times reported

Error

1

2,206

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 05	01	1
	02	1
	03	2
	06	2
	07	2
	08	1
	09	13
	10	11
	11	930
	12	848
	13	327
	14	6
	15	6
	16	6
	17	5
	18	3
	19	33
	20	9

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

2,169

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 05	11	912
	12	832
	13	425

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

587

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 05	11	194
	12	214
	13	179

4

587

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 05	11	194
	12	214
	13	179

5

134

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 05	13	134

ERROR: column res_users.sid does not exist at character 464
ERROR: column res_users.sid does not exist at character 464
ERROR: column res_users.sid does not exist at character 464

6

113

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 05	17	113

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

7

86

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 05	02	1
	11	12
	12	21
	13	52

8

42

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 05	11	8
	12	16
	13	5
	14	1
	15	1
	16	2
	17	1
	20	2
	21	6

9

27

Details

ERROR: canceling statement due to lock timeout

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 05	11	2
	13	25

ERROR: canceling statement due to lock timeout
ERROR: canceling statement due to lock timeout
ERROR: canceling statement due to lock timeout

10

20

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 05	17	20

11

16

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 05	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

12

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 05	01	3
	06	6
	09	3

FATAL: password authentication failed for user "postgres"

13

10

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 05	02	2
	03	1
	11	4
	14	2
	21	1

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

14

10

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 05	10	1
	11	1
	12	1
	15	5
	17	1
	18	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_car" violates not-null constraint

15

7

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 05	09	1
	11	4
	14	1
	19	1

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

16

5

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 05	19	3
	20	2

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

17

5

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 05	02	3
	07	1
	16	1

18

3

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 05	17	3

19

3

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 05	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

20

3

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 05	02	1
	07	1
	16	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
Dec 05	02	1
	13	1

22

2

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 05	07	1
	16	1

23

2

Details

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

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 05	04	1
	14	1

24

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 05	12	1

ERROR: could not serialize access due to concurrent delete

25

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Dec 05	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