pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Dec 8 23:47:45 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 72,996,717 log entries in 2m44s
Log start from 2024-12-08 00:00:00 to 2024-12-08 22:45:01

Global Stats

24,515 Number of unique normalized queries
21,287,339 Number of queries
6d4h58m21s Total query duration
2024-12-08 00:00:00 First query
2024-12-08 22:45:01 Last query
5,609 queries/s at 2024-12-08 12:57:23 Query peak

6d4h58m21s Total query duration
1s81ms Prepare/parse total duration
45s655ms Bind total duration
6d4h57m34s Execute total duration

10,245 Number of events
24 Number of unique normalized events
4,110 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,287,339 Average queries per session
6d4h58m21s 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

5,609 queries/s Query Peak
2024-12-08 12:57:23 Date

SELECT Traffic

Key values

3,946 queries/s Query Peak
2024-12-08 12:57:23 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,497 queries/s Query Peak
2024-12-08 12:44:45 Date

Queries duration

Key values

6d4h58m21s 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 08	00	461,595	0ms	4s174ms	20ms	4m27s	5m4s	5m7s
	01	401,256	0ms	4s304ms	14ms	2m53s	3m9s	4m3s
	02	343,227	0ms	3s945ms	18ms	3m7s	3m41s	4m18s
	03	284,631	0ms	1s716ms	14ms	2m2s	2m24s	2m54s
	04	283,147	0ms	1h	48ms	3m8s	4m	2h13m26s
	05	327,961	0ms	4s344ms	20ms	3m18s	4m11s	4m56s
	06	358,790	0ms	4s441ms	16ms	2m52s	3m22s	3m49s
	07	332,408	0ms	768ms	15ms	3m5s	3m35s	4m26s
	08	463,048	0ms	4s417ms	4ms	1m14s	1m35s	1m46s
	09	1,056,484	0ms	42m51s	38ms	2m36s	3m31s	9h36m57s
	10	1,356,215	0ms	36m43s	27ms	4m48s	53m55s	5h57m2s
	11	1,439,141	0ms	4s626ms	7ms	5m13s	5m52s	6m26s
	12	1,663,523	0ms	59m59s	28ms	50m21s	1h6m58s	2h58m41s
	13	1,723,206	0ms	25m11s	30ms	6m43s	7m14s	6h22m32s
	14	1,729,043	0ms	10m58s	22ms	8m23s	1h38m53s	2h13m32s
	15	1,809,798	0ms	13m41s	20ms	42m56s	51m10s	1h14m50s
	16	1,516,114	0ms	31m32s	25ms	8m	13m28s	4h54m12s
	17	1,447,006	0ms	15m58s	28ms	8m	1h43m54s	3h22m48s
	18	1,248,595	0ms	35m	32ms	6m48s	7m41s	6h30m19s
	19	1,159,510	0ms	5m51s	24ms	13m51s	14m22s	17m41s
	20	989,425	0ms	26m38s	48ms	9m19s	11m15s	4h17m29s
	21	546,465	0ms	44s650ms	14ms	4m14s	5m18s	5m39s
	22	346,751	0ms	4s726ms	21ms	7m35s	8m58s	10m41s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 08	00	301,528	31ms	3m45s	4m26s	5m5s
	01	251,570	23ms	2m25s	2m53s	3m8s
	02	213,313	29ms	2m36s	3m6s	3m55s
	03	175,402	22ms	1m42s	2m2s	2m31s
	04	177,160	32ms	2m21s	3m7s	3m59s
	05	201,443	32ms	2m41s	3m18s	4m20s
	06	224,506	26ms	2m28s	2m52s	3m24s
	07	206,569	24ms	2m20s	3m4s	4m2s
	08	294,663	7ms	1m	1m14s	1m37s
	09	669,022	8ms	2m15s	2m31s	3m31s
	10	864,701	9ms	2m57s	3m32s	5m11s
	11	857,617	13ms	4m18s	5m12s	6m14s
	12	1,065,256	11ms	4m48s	5m38s	6m52s
	13	1,099,411	14ms	5m23s	6m26s	6m58s
	14	1,130,825	12ms	5m5s	6m15s	7m1s
	15	1,184,314	15ms	7m30s	8m25s	10m7s
	16	973,640	14ms	5m25s	7m45s	8m14s
	17	944,926	14ms	5m21s	6m10s	8m19s
	18	810,931	17ms	5m18s	6m5s	7m39s
	19	731,635	37ms	10m58s	12m43s	14m21s
	20	621,873	29ms	7m15s	9m	10m9s
	21	344,380	22ms	3m41s	4m13s	5m20s
	22	215,964	34ms	3m37s	7m34s	10m40s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 08	00	44,263	8,301	166	0	0ms	246ms	304ms	438ms
	01	28,528	6,338	138	0	0ms	156ms	195ms	314ms
	02	27,406	6,285	128	0	0ms	148ms	194ms	275ms
	03	18,098	4,320	129	0	0ms	114ms	143ms	196ms
	04	25,645	6,803	136	0	241ms	150ms	222ms	23s995ms
	05	26,455	6,979	149	0	0ms	150ms	203ms	293ms
	06	23,992	6,535	150	0	0ms	135ms	204ms	255ms
	07	20,994	6,214	152	0	0ms	118ms	186ms	272ms
	08	12,085	4,690	339	0	0ms	71ms	107ms	207ms
	09	33,309	12,044	563	0	753ms	184ms	207ms	308ms
	10	47,616	14,575	925	0	462ms	256ms	364ms	53m19s
	11	69,080	17,193	933	0	0ms	371ms	421ms	501ms
	12	61,722	25,714	931	0	388ms	416ms	722ms	1h5m12s
	13	72,550	24,051	757	0	381ms	425ms	516ms	3m24s
	14	64,688	23,330	985	0	278ms	408ms	536ms	1h36m50s
	15	76,627	23,265	821	0	178ms	524ms	609ms	48m
	16	65,646	21,520	1,213	0	265ms	409ms	494ms	28s976ms
	17	78,209	22,230	839	0	273ms	607ms	779ms	1h41m15s
	18	68,059	19,633	796	2	298ms	420ms	603ms	25s376ms
	19	96,601	33,596	736	0	7ms	724ms	856ms	2m
	20	80,960	22,020	863	0	285ms	496ms	720ms	1m36s
	21	40,223	7,463	318	0	1ms	234ms	326ms	511ms
	22	27,100	9,842	142	0	0ms	217ms	285ms	419ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 08	00	118	61,228	518.88	0.03%
	01	118	61,228	518.88	0.03%
	02	118	61,228	518.88	0.04%
	03	118	61,228	518.88	0.05%
	04	118	61,228	518.88	0.05%
	05	118	61,228	518.88	0.04%
	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,177	518.45	0.01%
	15	118	61,228	518.88	0.01%
	16	118	61,228	518.88	0.01%
	17	121	59,191	489.18	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.01%
	21	118	61,228	518.88	0.02%
	22	97	45,954	473.75	0.03%

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

233,377 buffers Checkpoint Peak
2024-12-08 18:41:31 Date
270.050 seconds Highest write time
0.039 seconds Sync time

Checkpoints Wal files

Key values

78 files Wal files usage Peak
2024-12-08 18:41:31 Date

Checkpoints distance

Key values

2,490.64 Mo Distance Peak
2024-12-08 18:41:31 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 08	00	137,653	3,239.563s	0.038s	3,239.697s
	01	173,774	3,239.445s	0.035s	3,239.592s
	02	130,788	3,239.58s	0.033s	3,239.715s
	03	105,847	3,239.537s	0.029s	3,239.639s
	04	94,418	3,239.548s	0.028s	3,239.639s
	05	117,795	3,239.597s	0.033s	3,239.693s
	06	164,258	3,239.524s	0.037s	3,239.603s
	07	149,905	3,239.567s	0.031s	3,239.644s
	08	86,512	3,106.528s	0.033s	3,106.593s
	09	244,722	3,239.533s	0.051s	3,239.637s
	10	352,067	3,239.472s	0.061s	3,239.607s
	11	503,567	3,239.527s	0.048s	3,239.655s
	12	494,376	3,239.474s	0.069s	3,239.622s
	13	523,906	3,239.598s	0.052s	3,239.737s
	14	466,635	3,032.311s	0.122s	3,032.529s
	15	566,412	3,239.456s	0.059s	3,239.636s
	16	471,558	3,239.521s	0.055s	3,239.638s
	17	399,889	2,813.572s	0.106s	2,813.754s
	18	519,769	3,239.526s	0.05s	3,239.657s
	19	361,932	3,239.541s	0.063s	3,239.683s
	20	416,392	3,239.465s	0.061s	3,239.608s
	21	209,768	3,189.507s	0.039s	3,189.598s
	22	105,438	2,429.659s	0.029s	2,429.725s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 08	00	60	0	3,559	0.002s	0.012s
	01	73	0	3,248	0.002s	0.012s
	02	58	0	2,936	0.002s	0.012s
	03	46	0	2,718	0.002s	0.012s
	04	42	0	2,873	0.002s	0.012s
	05	40	12	2,780	0.002s	0.012s
	06	0	70	2,732	0.002s	0.012s
	07	0	67	3,080	0.002s	0.012s
	08	0	34	3,444	0.002s	0.012s
	09	0	103	4,621	0.009s	0.012s
	10	0	147	5,198	0.007s	0.012s
	11	0	226	5,169	0.003s	0.012s
	12	0	217	5,338	0.003s	0.012s
	13	0	229	5,584	0.003s	0.012s
	14	0	201	5,972	0.024s	0.013s
	15	0	252	5,962	0.002s	0.012s
	16	0	183	5,858	0.002s	0.012s
	17	0	167	5,761	0.023s	0.012s
	18	0	201	5,613	0.003s	0.012s
	19	0	161	5,236	0.003s	0.012s
	20	0	177	5,153	0.002s	0.012s
	21	0	88	4,760	0.002s	0.012s
	22	0	46	3,122	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 08	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 08	00	82,117.33 kB	554,443.58 kB
	01	99,587.83 kB	226,539.33 kB
	02	80,245.25 kB	129,135.25 kB
	03	62,828.00 kB	87,838.42 kB
	04	56,275.00 kB	80,697.08 kB
	05	71,018.75 kB	85,321.17 kB
	06	95,712.58 kB	128,569.00 kB
	07	91,183.42 kB	128,960.83 kB
	08	46,962.33 kB	86,929.17 kB
	09	141,293.27 kB	163,657.00 kB
	10	200,552.50 kB	245,713.33 kB
	11	305,663.45 kB	343,598.73 kB
	12	296,100.75 kB	353,865.17 kB
	13	313,449.50 kB	384,048.58 kB
	14	253,415.46 kB	331,451.46 kB
	15	343,549.00 kB	584,865.67 kB
	16	250,119.75 kB	370,317.00 kB
	17	226,219.64 kB	282,424.00 kB
	18	275,070.92 kB	559,294.42 kB
	19	222,300.73 kB	591,874.27 kB
	20	241,323.83 kB	353,935.50 kB
	21	120,353.42 kB	211,579.08 kB
	22	83,252.33 kB	150,896.33 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
274 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	2
Total	274

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

13,560,649 Total read queries
5,379,463 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	13,560,649	63.70%
INSERT	1,109,856	5.21%
UPDATE	332,941	1.56%
DELETE	12,309	0.06%
COPY FROM	2	0.00%
COPY TO	0	0.00%
CTE	129,930	0.61%
DDL	2,250	0.01%
TCL	3,792,175	17.81%
CURSOR	0	0.00%
OTHERS	2,347,227	11.03%

Queries by database

Key values

unknown Main database
21,287,339 Requests
6d4h57m34s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	21,287,339	6d4h57m34s
	copy from	2	7ms
	cte	129,930	1m5s
	ddl	2,250	319ms
	delete	12,309	56s64ms
	insert	1,109,856	11m18s
	others	2,347,226	1m59s
	select	13,560,649	2d19h7m15s
	tcl	3,792,175	2m45s
	update	332,941	3d9h32m14s

Queries by user

Key values

unknown Main user
21,287,339 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	21,287,339	6d4h57m34s
	copy from	2	7ms
	cte	129,930	1m5s
	ddl	2,250	319ms
	delete	12,309	56s64ms
	insert	1,109,856	11m18s
	others	2,347,226	1m59s
	select	13,560,649	2d19h7m15s
	tcl	3,792,175	2m45s
	update	332,941	3d9h32m14s

Duration by user

Key values

6d4h57m34s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	21,287,339	6d4h57m34s
	copy from	2	7ms
	cte	129,930	1m5s
	ddl	2,250	319ms
	delete	12,309	56s64ms
	insert	1,109,856	11m18s
	others	2,347,226	1m59s
	select	13,560,649	2d19h7m15s
	tcl	3,792,175	2m45s
	update	332,941	3d9h32m14s

Queries by host

Key values

unknown Main host
21,287,339 Requests
6d4h57m34s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	21,287,339	6d4h57m34s
	copy from	2	7ms
	cte	129,930	1m5s
	ddl	2,250	319ms
	delete	12,309	56s64ms
	insert	1,109,856	11m18s
	others	2,347,226	1m59s
	select	13,560,649	2d19h7m15s
	tcl	3,792,175	2m45s
	update	332,941	3d9h32m14s

Queries by application

Key values

unknown Main application
21,287,339 Requests
6d4h57m34s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	21,287,339	6d4h57m34s
	copy from	2	7ms
	cte	129,930	1m5s
	ddl	2,250	319ms
	delete	12,309	56s64ms
	insert	1,109,856	11m18s
	others	2,347,226	1m59s
	select	13,560,649	2d19h7m15s
	tcl	3,792,175	2m45s
	update	332,941	3d9h32m14s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-08 07:14:49 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

19,815,250 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	19,815,250	93.08%
1-5ms	389,850	1.83%
5-10ms	91,372	0.43%
10-25ms	63,266	0.30%
25-50ms	215,191	1.01%
50-100ms	65,718	0.31%
100-500ms	612,113	2.88%
500-1000ms	26,935	0.13%
1000-10000ms	6,701	0.03%
> 10000ms	943	0.00%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = '59d0b234ce053ef84522aca4f144b3ddd2f342a9', last_update = '2024-12-08 02:16:55.815260', exp_date = '2024-12-08 03:01:55.815263', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-08 04:16:56 ]
2	1h	update res_users set sid = '59d0b234ce053ef84522aca4f144b3ddd2f342a9', last_update = '2024-12-08 02:16:55.815972', exp_date = '2024-12-08 03:01:55.815976', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-08 04:16:56 ]
3	59m59s	update res_users set sid = 'efe4a31005d8b521e0e5d96824fe121f17bca57c', last_update = '2024-12-08 10:15:24.745701', exp_date = '2024-12-08 11:00:24.745703', logged_in = 'TRUE' where id = 1292; [ Date: 2024-12-08 12:15:24 ]
4	42m51s	update res_users set sid = '331a9e889323f74210459bb8af1b3d5c84d407e8', last_update = '2024-12-08 07:27:28.981460', exp_date = '2024-12-08 08:12:28.981463', logged_in = 'TRUE' where id = 940; [ Date: 2024-12-08 09:10:20 ]
5	42m51s	update res_users set sid = '331a9e889323f74210459bb8af1b3d5c84d407e8', last_update = '2024-12-08 07:27:28.980738', exp_date = '2024-12-08 08:12:28.980740', logged_in = 'TRUE' where id = 940; [ Date: 2024-12-08 09:10:20 ]
6	39m48s	update res_users set sid = '331a9e889323f74210459bb8af1b3d5c84d407e8', last_update = '2024-12-08 07:30:32.336817', exp_date = '2024-12-08 08:15:32.336819', logged_in = 'TRUE' where id = 940; [ Date: 2024-12-08 09:10:20 ]
7	39m46s	update res_users set sid = '331a9e889323f74210459bb8af1b3d5c84d407e8', last_update = '2024-12-08 07:30:34.383711', exp_date = '2024-12-08 08:15:34.383713', logged_in = 'TRUE' where id = 940; [ Date: 2024-12-08 09:10:20 ]
8	39m44s	update res_users set sid = '331a9e889323f74210459bb8af1b3d5c84d407e8', last_update = '2024-12-08 07:30:36.275850', exp_date = '2024-12-08 08:15:36.275854', logged_in = 'TRUE' where id = 940; [ Date: 2024-12-08 09:10:20 ]
9	39m43s	update res_users set sid = '331a9e889323f74210459bb8af1b3d5c84d407e8', last_update = '2024-12-08 07:30:37.840362', exp_date = '2024-12-08 08:15:37.840365', logged_in = 'TRUE' where id = 940; [ Date: 2024-12-08 09:10:20 ]
10	39m40s	update res_users set sid = '331a9e889323f74210459bb8af1b3d5c84d407e8', last_update = '2024-12-08 07:30:40.223535', exp_date = '2024-12-08 08:15:40.223536', logged_in = 'TRUE' where id = 940; [ Date: 2024-12-08 09:10:20 ]
11	36m43s	update res_users set sid = '5b10dc55e274b32d6d3017d77b2be30fedca62a5', last_update = '2024-12-08 08:44:36.449988', exp_date = '2024-12-08 09:29:36.449991', logged_in = 'TRUE' where id = 838; [ Date: 2024-12-08 10:21:20 ]
12	36m43s	update res_users set sid = '5b10dc55e274b32d6d3017d77b2be30fedca62a5', last_update = '2024-12-08 08:44:36.449802', exp_date = '2024-12-08 09:29:36.449805', logged_in = 'TRUE' where id = 838; [ Date: 2024-12-08 10:21:20 ]
13	36m16s	update res_users set sid = '5b10dc55e274b32d6d3017d77b2be30fedca62a5', last_update = '2024-12-08 08:45:03.843215', exp_date = '2024-12-08 09:30:03.843217', logged_in = 'TRUE' where id = 838; [ Date: 2024-12-08 10:21:20 ]
14	35m	update res_users set sid = '972edb001177fe12ccd3f29e9eea1310c82ce2aa', last_update = '2024-12-08 17:11:20.072234', exp_date = '2024-12-08 17:56:20.072238', logged_in = 'TRUE' where id = 848; [ Date: 2024-12-08 18:46:20 ]
15	35m	update res_users set sid = '972edb001177fe12ccd3f29e9eea1310c82ce2aa', last_update = '2024-12-08 17:11:20.072139', exp_date = '2024-12-08 17:56:20.072141', logged_in = 'TRUE' where id = 848; [ Date: 2024-12-08 18:46:20 ]
16	34m49s	update res_users set sid = '972edb001177fe12ccd3f29e9eea1310c82ce2aa', last_update = '2024-12-08 17:11:31.212233', exp_date = '2024-12-08 17:56:31.212236', logged_in = 'TRUE' where id = 848; [ Date: 2024-12-08 18:46:20 ]
17	34m43s	update res_users set sid = '972edb001177fe12ccd3f29e9eea1310c82ce2aa', last_update = '2024-12-08 17:11:37.193583', exp_date = '2024-12-08 17:56:37.193586', logged_in = 'TRUE' where id = 848; [ Date: 2024-12-08 18:46:20 ]
18	32m25s	update res_users set sid = '5b10dc55e274b32d6d3017d77b2be30fedca62a5', last_update = '2024-12-08 08:48:54.251200', exp_date = '2024-12-08 09:33:54.251203', logged_in = 'TRUE' where id = 838; [ Date: 2024-12-08 10:21:20 ]
19	32m17s	update res_users set sid = '5b10dc55e274b32d6d3017d77b2be30fedca62a5', last_update = '2024-12-08 08:49:02.276364', exp_date = '2024-12-08 09:34:02.276367', logged_in = 'TRUE' where id = 838; [ Date: 2024-12-08 10:21:20 ]
20	32m	update res_users set sid = '5b10dc55e274b32d6d3017d77b2be30fedca62a5', last_update = '2024-12-08 08:49:19.674912', exp_date = '2024-12-08 09:34:19.674914', logged_in = 'TRUE' where id = 838; [ Date: 2024-12-08 10:21:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d7h31m5s

76,026

Details

0ms

1h

3s765ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 08	00	905	212ms	0ms
	01	1,068	238ms	0ms
	02	904	196ms	0ms
	03	747	166ms	0ms
	04	583	2h10m2s	13s383ms
	05	872	195ms	0ms
	06	917	202ms	0ms
	07	794	172ms	0ms
	08	1,780	376ms	0ms
	09	4,680	9h36m3s	7s385ms
	10	5,435	8h6m10s	5s367ms
	11	6,401	1s646ms	0ms
	12	6,966	9h25m54s	4s874ms
	13	6,795	10h17m12s	5s450ms
	14	6,578	6h51m24s	3s752ms
	15	7,382	4h44m22s	2s311ms
	16	5,814	6h28m32s	4s9ms
	17	5,331	7h27m44s	5s39ms
	18	4,020	6h3m24s	5s423ms
	19	3,403	13m40s	241ms
	20	2,638	8h5m44s	11s47ms
	21	1,290	44s934ms	34ms
	22	723	161ms	0ms

update res_users set sid = '59d0b234ce053ef84522aca4f144b3ddd2f342a9', last_update = '2024-12-08 02:16:55.815260', exp_date = '2024-12-08 03:01:55.815263', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-08 04:16:56 Duration: 1h
update res_users set sid = '59d0b234ce053ef84522aca4f144b3ddd2f342a9', last_update = '2024-12-08 02:16:55.815972', exp_date = '2024-12-08 03:01:55.815976', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-08 04:16:56 Duration: 1h
update res_users set sid = 'efe4a31005d8b521e0e5d96824fe121f17bca57c', last_update = '2024-12-08 10:15:24.745701', exp_date = '2024-12-08 11:00:24.745703', logged_in = 'TRUE' where id = 1292;

Date: 2024-12-08 12:15:24 Duration: 59m59s

2

1d7h20m43s

272,274

Details

334ms

2s490ms

414ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 08	00	12,183	1h21m32s	401ms
	01	8,184	53m46s	394ms
	02	8,642	56m51s	394ms
	03	6,232	40m13s	387ms
	04	6,972	46m34s	400ms
	05	8,850	58m9s	394ms
	06	7,990	51m48s	389ms
	07	7,836	51m4s	391ms
	08	2,608	16m36s	382ms
	09	7,941	51m9s	386ms
	10	11,453	1h15m44s	396ms
	11	17,027	1h55m26s	406ms
	12	13,946	1h35m41s	411ms
	13	15,662	1h49m43s	420ms
	14	13,797	1h38m45s	429ms
	15	17,686	2h20m10s	475ms
	16	13,836	1h45m56s	459ms
	17	14,238	1h39m37s	419ms
	18	14,810	1h38m9s	397ms
	19	23,741	2h55m41s	444ms
	20	22,353	2h33m37s	412ms
	21	9,216	59m36s	388ms
	22	7,071	44m43s	379ms

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

Date: 2024-12-08 19:42:32 Duration: 2s490ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3288997)) AND (("shipping_track"."id" not in (26878029, 26881222, 26953427, 27183218, 27183414, 27289785, 27290440, 27595575, 27596655, 27596655)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 16:29:30 Duration: 2s328ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3387186)) AND (("shipping_track"."id" not in (27648640, 27648640)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 19:43:09 Duration: 1s298ms

3

7h50m58s

122,790

Details

170ms

1s377ms

230ms

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 08	00	657	2m7s	193ms
	01	1,486	4m45s	192ms
	02	1,736	5m35s	193ms
	03	1,318	4m13s	192ms
	04	2,765	8m52s	192ms
	05	2,702	8m44s	193ms
	06	3,575	11m32s	193ms
	07	2,652	8m37s	195ms
	08	721	2m18s	191ms
	09	2,392	7m55s	198ms
	10	608	2m1s	199ms
	11	1,047	3m33s	203ms
	12	4,537	15m45s	208ms
	13	11,211	39m36s	211ms
	14	8,662	31m11s	216ms
	15	8,474	34m28s	244ms
	16	5,372	21m53s	244ms
	17	5,901	22m29s	228ms
	18	4,808	17m13s	215ms
	19	29,482	2h7m15s	259ms
	20	10,987	43m26s	237ms
	21	14	2s945ms	210ms
	22	11,683	47m19s	243ms

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

Date: 2024-12-08 19:43:05 Duration: 1s377ms
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" = '9244127')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-08 19:42:33 Duration: 1s288ms
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" = '9257001')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-08 16:29:38 Duration: 689ms

4

5h45m5s

48,612

Details

333ms

2s980ms

425ms

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 08	00	368	2m33s	417ms
	01	258	1m47s	418ms
	02	204	1m27s	428ms
	03	168	1m11s	427ms
	04	102	45s190ms	443ms
	05	213	1m30s	424ms
	06	286	1m55s	404ms
	07	341	2m20s	412ms
	08	971	6m14s	385ms
	09	2,383	15m46s	397ms
	10	3,672	24m44s	404ms
	11	4,751	33m	416ms
	12	4,567	32m14s	423ms
	13	3,551	25m30s	431ms
	14	4,275	31m42s	445ms
	15	3,675	29m49s	486ms
	16	4,583	35m22s	463ms
	17	3,502	24m22s	417ms
	18	3,306	21m20s	387ms
	19	3,044	22m5s	435ms
	20	2,921	20m3s	412ms
	21	921	5m44s	373ms
	22	550	3m28s	379ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3372573, 3370939, 3370937, 3370913, 3370907, 3359934, 3359930, 3358893, 3357969, 3355279, 3352823, 3351954, 3351950, 3351279, 3350781, 3350581, 3349300, 3348352, 3347936, 3347707, 3347513, 3346405, 3346153, 3345665, 3344431, 3342869, 3342175, 3341229, 3340930, 3340929, 3340910, 3337575, 3337477, 3336712, 3336665, 3336605, 3331766, 3323538, 3321639, 3320505, 3297093)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 19:43:06 Duration: 2s980ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3303784)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 16:29:43 Duration: 1s920ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3364292)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 19:44:51 Duration: 1s210ms

5

4h55m14s

72,204

Details

97ms

847ms

245ms

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 08	00	7,054	26m57s	229ms
	01	3,564	12m43s	214ms
	02	4,006	16m7s	241ms
	03	2,158	8m13s	228ms
	04	4,106	16m13s	237ms
	05	3,398	15m10s	267ms
	06	2,672	10m12s	229ms
	07	1,818	6m8s	202ms
	08	368	1m18s	212ms
	09	88	22s758ms	258ms
	10	494	1m43s	210ms
	11	112	23s500ms	209ms
	12	220	53s430ms	242ms
	13	262	1m6s	251ms
	14	560	2m13s	238ms
	15	2,122	8m14s	233ms
	16	2,384	10m6s	254ms
	17	3,752	16m12s	259ms
	18	7,125	29m23s	247ms
	19	10,451	49m28s	284ms
	20	6,988	29m13s	250ms
	21	5,704	22m7s	232ms
	22	2,798	10m39s	228ms

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-08 19:41:33 Duration: 847ms
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-08 19:45:32 Duration: 835ms
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-08 19:45:33 Duration: 833ms

6

3h8m15s

11,241

Details

244ms

1s913ms

1s4ms

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 08	00	1,470	23m20s	952ms
	01	484	7m38s	947ms
	02	16	15s300ms	956ms
	03	82	1m18s	956ms
	04	222	3m31s	951ms
	05	398	6m19s	954ms
	06	3	2s859ms	953ms
	09	28	27s528ms	983ms
	10	62	59s533ms	960ms
	11	7	7s332ms	1s47ms
	12	1	1s102ms	1s102ms
	13	3	3s319ms	1s106ms
	14	1	961ms	961ms
	15	830	15m5s	1s90ms
	16	606	10m18s	1s20ms
	17	672	11m29s	1s26ms
	18	1,456	23m40s	975ms
	19	2,059	36m22s	1s60ms
	20	1,247	21m57s	1s56ms
	21	1,261	19m46s	940ms
	22	333	5m28s	985ms

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

Date: 2024-12-08 19:45:10 Duration: 1s913ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9152879')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-08 19:43:34 Duration: 1s895ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9196150')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-08 19:44:53 Duration: 1s893ms

7

2h9m10s

25,491

Details

220ms

596ms

304ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 08	00	2,120	9m56s	281ms
	01	1,350	6m9s	273ms
	02	2,033	9m26s	278ms
	03	1,031	4m45s	277ms
	04	1,881	8m52s	283ms
	05	1,361	6m24s	282ms
	06	1,352	6m23s	283ms
	07	922	4m21s	283ms
	08	189	52s866ms	279ms
	09	18	5s77ms	282ms
	10	191	58s556ms	306ms
	11	50	15s680ms	313ms
	12	113	34s600ms	306ms
	13	128	42s959ms	335ms
	14	281	1m26s	309ms
	15	249	1m29s	359ms
	16	599	3m30s	351ms
	17	1,231	6m43s	327ms
	18	2,151	11m19s	315ms
	19	3,225	18m59s	353ms
	20	2,290	12m18s	322ms
	21	1,636	8m3s	295ms
	22	1,090	5m28s	301ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9292496')) 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-08 19:44:51 Duration: 596ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9225354')) 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-08 16:29:32 Duration: 591ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9292318')) 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-08 19:36:34 Duration: 588ms

8

1h45m2s

23,094

Details

173ms

439ms

272ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 08	08	427	1m42s	239ms
	09	353	1m27s	249ms
	10	15	3s921ms	261ms
	12	2,178	9m27s	260ms
	13	5,282	23m18s	264ms
	14	3,491	15m53s	273ms
	15	4,259	20m33s	289ms
	16	1,567	7m37s	292ms
	17	2,794	12m42s	273ms
	18	2,171	9m27s	261ms
	19	427	2m10s	304ms
	20	130	36s784ms	282ms

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

Date: 2024-12-08 16:29:27 Duration: 439ms
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" = '9148451')))) ORDER BY "collection_policy"."id";

Date: 2024-12-08 16:29:28 Duration: 432ms
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" = '9238567')))) ORDER BY "collection_policy"."id";

Date: 2024-12-08 16:29:26 Duration: 427ms

9

1h39m46s

155,687

Details

27ms

166ms

38ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 08	00	5,979	3m25s	34ms
	01	3,230	1m50s	34ms
	02	2,450	1m24s	34ms
	03	1,935	1m6s	34ms
	04	2,088	1m12s	34ms
	05	2,486	1m25s	34ms
	06	1,797	1m2s	34ms
	07	2,109	1m13s	35ms
	08	1,942	1m6s	34ms
	09	5,780	3m23s	35ms
	10	8,340	5m	36ms
	11	12,535	7m38s	36ms
	12	11,129	6m53s	37ms
	13	13,795	8m39s	37ms
	14	10,875	7m3s	38ms
	15	12,612	9m3s	43ms
	16	10,121	7m	41ms
	17	10,659	7m9s	40ms
	18	9,805	6m19s	38ms
	19	10,328	7m28s	43ms
	20	8,724	5m53s	40ms
	21	4,401	2m46s	37ms
	22	2,567	1m38s	38ms

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

Date: 2024-12-08 19:43:00 Duration: 166ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3347911)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-08 19:43:02 Duration: 164ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3376736)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-08 16:29:40 Duration: 134ms

10

1h30m35s

222

Details

0ms

30m50s

24s484ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 08	10	1	0ms	0ms
	12	2	2ms	1ms
	14	1	1m42s	1m42s
	15	49	5m35s	6s840ms
	16	46	1m36s	2s93ms
	17	34	43ms	1ms
	18	24	1h16m1s	3m10s
	19	28	23ms	0ms
	20	23	5m40s	14s786ms
	21	10	5ms	0ms
	22	4	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-08 18:00:30.204794', "last_update" = '2024-12-08 17:15:30.204825', "sid" = 'af95b564a87a50209d634382310ade2045f56f20', "write_date" = '2024-12-08 17:15:29.836531', "write_uid" = 1 WHERE id IN (848);

Date: 2024-12-08 18:46:20 Duration: 30m50s
UPDATE "res_users" SET "exp_date" = '2024-12-08 18:09:04.589587', "last_update" = '2024-12-08 17:24:04.589604', "sid" = 'af95b564a87a50209d634382310ade2045f56f20', "write_date" = '2024-12-08 17:24:04.244644', "write_uid" = 1 WHERE id IN (848);

Date: 2024-12-08 18:46:20 Duration: 22m15s
UPDATE "res_users" SET "exp_date" = '2024-12-08 18:13:47.322882', "last_update" = '2024-12-08 17:28:47.322900', "sid" = 'af95b564a87a50209d634382310ade2045f56f20', "write_date" = '2024-12-08 17:28:46.967426', "write_uid" = 1 WHERE id IN (848);

Date: 2024-12-08 18:46:20 Duration: 17m33s

11

43m20s

12,612

Details

172ms

340ms

206ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) 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 08	01	420	1m20s	192ms
	02	461	1m28s	192ms
	03	184	35s614ms	193ms
	04	1,140	3m40s	193ms
	05	924	2m58s	193ms
	06	1,394	4m28s	192ms
	07	804	2m37s	195ms
	08	187	35s570ms	190ms
	09	652	2m7s	195ms
	10	502	1m40s	200ms
	11	1,047	3m33s	204ms
	12	959	3m16s	205ms
	13	952	3m24s	214ms
	14	1,110	4m5s	220ms
	15	739	3m2s	247ms
	16	136	30s995ms	227ms
	17	265	1m2s	235ms
	18	346	1m12s	208ms
	19	273	1m11s	260ms
	20	103	23s558ms	228ms
	21	14	2s961ms	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" = '9192461')) 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-08 15:15:19 Duration: 340ms
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" = '9050032')) 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 (35)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (35))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (35))))) 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-08 19:37:16 Duration: 326ms
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" = '9296752')) 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 (14, 74, 70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-08 19:41:16 Duration: 323ms

12

42m28s

52,435

Details

33ms

178ms

48ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 08	00	51	2s352ms	46ms
	01	7	317ms	45ms
	02	6	277ms	46ms
	03	3	136ms	45ms
	05	2	92ms	46ms
	06	17	787ms	46ms
	07	46	2s94ms	45ms
	08	551	24s687ms	44ms
	09	918	41s940ms	45ms
	10	831	39s552ms	47ms
	11	604	29s606ms	49ms
	12	2,113	1m44s	49ms
	13	13,041	10m35s	48ms
	14	9,336	7m40s	49ms
	15	6,929	6m4s	52ms
	16	4,431	3m47s	51ms
	17	6,889	5m17s	46ms
	18	4,525	3m16s	43ms
	19	1,247	1m	48ms
	20	675	31s532ms	46ms
	21	130	5s311ms	40ms
	22	83	3s425ms	41ms

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

Date: 2024-12-08 19:43:02 Duration: 178ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3298479) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-08 17:22:02 Duration: 109ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3250153) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-08 14:43:10 Duration: 106ms

13

39m55s

638

Details

2s375ms

6s307ms

3s755ms

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."v_10_id" = ?)) order by "res_partner"."display_name" asc, "res_partner"."id" desc limit ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 08	10	14	51s33ms	3s645ms
	11	57	3m31s	3s716ms
	12	51	3m11s	3s750ms
	13	51	3m24s	4s8ms
	14	54	3m23s	3s771ms
	15	53	3m29s	3s944ms
	16	52	3m12s	3s698ms
	17	51	3m11s	3s747ms
	18	57	3m30s	3s700ms
	19	51	3m33s	4s191ms
	20	52	3m17s	3s802ms
	21	54	2m59s	3s328ms
	22	41	2m18s	3s385ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-08 19:45:12 Duration: 6s307ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-08 19:32:05 Duration: 5s323ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-08 19:41:36 Duration: 5s294ms

14

32m49s

10,181

Details

171ms

245ms

193ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) 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 #14

Day	Hour	Count	Duration	Avg duration
Dec 08	00	657	2m7s	193ms
	01	1,066	3m24s	192ms
	02	1,275	4m6s	193ms
	03	1,134	3m37s	192ms
	04	1,557	4m59s	192ms
	05	1,777	5m45s	194ms
	06	1,394	4m29s	193ms
	07	1,224	3m58s	194ms
	22	97	19s772ms	203ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9210048')) 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-08 01:14:00 Duration: 245ms
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" = '9250730')) 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-08 01:14:00 Duration: 243ms
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" = '9246985')) 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-08 01:14:00 Duration: 242ms

15

29m21s

18,987

Details

71ms

447ms

92ms

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

Day	Hour	Count	Duration	Avg duration
Dec 08	00	4	327ms	81ms
	07	57	4s721ms	82ms
	08	229	19s337ms	84ms
	09	924	1m17s	84ms
	10	1,414	2m4s	88ms
	11	1,577	2m21s	89ms
	12	1,733	2m37s	90ms
	13	2,369	3m34s	90ms
	14	1,945	3m6s	95ms
	15	1,639	2m51s	104ms
	16	2,070	3m33s	102ms
	17	1,872	2m48s	90ms
	18	688	59s948ms	87ms
	19	872	1m19s	90ms
	20	1,351	2m1s	90ms
	21	206	16s936ms	82ms
	22	37	3s180ms	85ms

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

Date: 2024-12-08 16:29:32 Duration: 447ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7783501)) AND (("cash_track"."id" not in (5459189)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-08 16:29:28 Duration: 215ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7783502)) AND (("cash_track"."id" not in (5459190)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-08 16:29:28 Duration: 187ms

16

28m

481

Details

918ms

4s643ms

3s494ms

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

Day	Hour	Count	Duration	Avg duration
Dec 08	01	17	54s701ms	3s217ms
	02	117	6m13s	3s192ms
	09	7	23s962ms	3s423ms
	10	17	1m	3s562ms
	11	18	1m	3s384ms
	12	7	22s731ms	3s247ms
	13	7	28s4ms	4s
	14	8	27s678ms	3s459ms
	15	78	4m54s	3s772ms
	16	101	6m6s	3s627ms
	17	30	1m46s	3s565ms
	18	27	1m39s	3s686ms
	19	5	16s502ms	3s300ms
	20	23	1m22s	3s599ms
	21	16	52s845ms	3s302ms
	22	3	9s465ms	3s155ms

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

Date: 2024-12-08 16:29:51 Duration: 4s643ms
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 (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) AND ("policy_number"."name"::text ilike '%9136580%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-08 15:41:22 Duration: 4s537ms
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 (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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) 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"."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)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-08 10:48:32 Duration: 4s532ms

17

22m6s

25

Details

0ms

12m49s

53s40ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 08	12	1	1ms	1ms
	15	5	9m16s	1m51s
	16	10	12ms	1ms
	17	3	12m49s	4m16s
	20	4	6ms	1ms
	21	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-08 16:32:22.849391', "last_update" = '2024-12-08 15:47:22.849413', "write_date" = '2024-12-08 15:47:22.523415', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-08 17:00:11 Duration: 12m49s
UPDATE "res_users" SET "exp_date" = '2024-12-08 14:45:46.474026', "last_update" = '2024-12-08 14:00:46.474045', "write_date" = '2024-12-08 14:00:46.137590', "write_uid" = 821 WHERE id IN (821);

Date: 2024-12-08 15:10:03 Duration: 9m16s
UPDATE "res_users" SET "exp_date" = '2024-12-08 20:10:45.535596', "last_update" = '2024-12-08 19:25:45.535645', "write_date" = '2024-12-08 19:25:45.084331', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-08 20:25:45 Duration: 3ms

18

15m42s

21,464

Details

31ms

67ms

43ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 08	08	193	7s860ms	40ms
	09	413	17s57ms	41ms
	10	55	2s260ms	41ms
	12	939	42s138ms	44ms
	13	4,101	2m58s	43ms
	14	4,818	3m34s	44ms
	15	3,418	2m40s	46ms
	16	1,959	1m30s	46ms
	17	3,127	2m11s	41ms
	18	1,944	1m15s	38ms
	19	408	17s742ms	43ms
	20	89	3s843ms	43ms

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

Date: 2024-12-08 12:47:06 Duration: 67ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3172211) ORDER BY "collection_policy"."id";

Date: 2024-12-08 12:47:06 Duration: 65ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3135616) ORDER BY "collection_policy"."id";

Date: 2024-12-08 12:47:08 Duration: 64ms

19

13m54s

5,754

Details

119ms

236ms

145ms

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 08	06	5	657ms	131ms
	07	10	1s335ms	133ms
	08	57	7s406ms	129ms
	09	312	41s843ms	134ms
	10	585	1m20s	138ms
	11	1,120	2m37s	140ms
	12	1,091	2m34s	141ms
	13	722	1m46s	147ms
	14	429	1m3s	147ms
	15	600	1m37s	162ms
	16	182	28s52ms	154ms
	17	262	39s635ms	151ms
	18	128	18s82ms	141ms
	19	81	12s847ms	158ms
	20	90	13s256ms	147ms
	21	64	8s683ms	135ms
	22	16	2s174ms	135ms

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-08 15:15:11 Duration: 236ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) 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-08 15:15:05 Duration: 219ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) 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-08 15:23:39 Duration: 213ms

20

11m10s

3,245

Details

175ms

316ms

206ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 08	04	68	13s76ms	192ms
	05	2	396ms	198ms
	06	786	2m33s	195ms
	07	590	1m54s	194ms
	08	72	13s809ms	191ms
	09	177	34s600ms	195ms
	10	71	13s817ms	194ms
	12	58	12s164ms	209ms
	13	482	1m42s	213ms
	14	674	2m27s	218ms
	15	71	18s89ms	254ms
	16	161	37s596ms	233ms
	17	33	8s128ms	246ms

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

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

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

Date: 2024-12-08 15:41:21 Duration: 304ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,345,686

Details

1m59s

0ms

17ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 08	00	40,511	2s237ms	0ms
	01	42,825	2s359ms	0ms
	02	36,379	2s15ms	0ms
	03	33,020	1s756ms	0ms
	04	28,210	1s518ms	0ms
	05	34,100	1s889ms	0ms
	06	37,399	2s135ms	0ms
	07	35,912	2s14ms	0ms
	08	55,927	2s894ms	0ms
	09	123,976	6s359ms	0ms
	10	157,019	7s700ms	0ms
	11	182,391	10s4ms	0ms
	12	188,210	9s141ms	0ms
	13	196,128	10s429ms	0ms
	14	188,413	9s148ms	0ms
	15	195,318	9s368ms	0ms
	16	174,016	8s468ms	0ms
	17	151,379	6s993ms	0ms
	18	131,674	6s841ms	0ms
	19	114,436	6s674ms	0ms
	20	101,118	4s851ms	0ms
	21	60,691	2s796ms	0ms
	22	36,634	1s798ms	0ms

DISCARD ALL;

Date: 2024-12-08 14:15:39 Duration: 17ms
DISCARD ALL;

Date: 2024-12-08 19:50:41 Duration: 2ms
DISCARD ALL;

Date: 2024-12-08 04:25:56 Duration: 1ms

2

1,896,607

Details

29s156ms

0ms

14ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 08	00	31,248	553ms	0ms
	01	33,932	563ms	0ms
	02	28,000	472ms	0ms
	03	24,997	408ms	0ms
	04	20,768	363ms	0ms
	05	27,587	468ms	0ms
	06	31,286	532ms	0ms
	07	29,436	476ms	0ms
	08	45,452	641ms	0ms
	09	105,580	1s575ms	0ms
	10	131,853	1s942ms	0ms
	11	153,639	2s387ms	0ms
	12	156,707	2s288ms	0ms
	13	160,918	2s527ms	0ms
	14	155,395	2s339ms	0ms
	15	160,008	2s426ms	0ms
	16	136,051	2s6ms	0ms
	17	120,481	1s720ms	0ms
	18	105,143	1s591ms	0ms
	19	88,299	1s553ms	0ms
	20	78,411	1s216ms	0ms
	21	44,355	670ms	0ms
	22	27,061	430ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-08 15:26:02 Duration: 14ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-08 08:55:16 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-08 20:40:11 Duration: 1ms

3

1,209,824

Details

12s807ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 08	00	21,248	236ms	0ms
	01	22,342	241ms	0ms
	02	18,836	202ms	0ms
	03	17,247	174ms	0ms
	04	14,890	160ms	0ms
	05	17,998	199ms	0ms
	06	19,622	213ms	0ms
	07	18,654	194ms	0ms
	08	29,443	280ms	0ms
	09	64,918	658ms	0ms
	10	81,467	822ms	0ms
	11	94,296	1s48ms	0ms
	12	97,106	1s19ms	0ms
	13	101,305	1s75ms	0ms
	14	97,158	1s16ms	0ms
	15	99,938	1s102ms	0ms
	16	88,660	906ms	0ms
	17	77,039	802ms	0ms
	18	67,144	688ms	0ms
	19	58,406	691ms	0ms
	20	51,760	561ms	0ms
	21	31,367	309ms	0ms
	22	18,980	198ms	0ms

ROLLBACK;

Date: 2024-12-08 17:00:41 Duration: 1ms
ROLLBACK;

Date: 2024-12-08 10:21:22 Duration: 0ms
ROLLBACK;

Date: 2024-12-08 14:29:18 Duration: 0ms

4

1,181,368

Details

3m38s

0ms

17ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 08	00	20,321	4s288ms	0ms
	01	21,415	4s247ms	0ms
	02	18,210	3s642ms	0ms
	03	16,508	2s986ms	0ms
	04	14,134	2s804ms	0ms
	05	17,040	3s462ms	0ms
	06	18,694	3s851ms	0ms
	07	17,910	3s492ms	0ms
	08	28,131	4s295ms	0ms
	09	62,690	10s658ms	0ms
	10	79,105	13s866ms	0ms
	11	92,373	17s259ms	0ms
	12	94,719	17s83ms	0ms
	13	98,761	18s545ms	0ms
	14	94,618	17s289ms	0ms
	15	98,286	19s143ms	0ms
	16	87,890	16s227ms	0ms
	17	76,289	13s861ms	0ms
	18	66,347	11s935ms	0ms
	19	57,666	11s649ms	0ms
	20	51,088	9s717ms	0ms
	21	30,745	4s883ms	0ms
	22	18,428	3s206ms	0ms

SELECT payload FROM http_sessions WHERE sid = '6a01ce47b1f9fa51cdbac0c98801981e00315fce';

Date: 2024-12-08 12:54:40 Duration: 17ms
SELECT payload FROM http_sessions WHERE sid = 'a03d5d7825338032869c0e21477c84357156e6f7';

Date: 2024-12-08 09:00:34 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '962454b6d7d0254dcb7cb6f0381c6255d271be03';

Date: 2024-12-08 12:18:11 Duration: 14ms

5

1,168,644

Details

1m46s

0ms

2ms

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 08	00	20,259	1s976ms	0ms
	01	21,399	2s31ms	0ms
	02	18,255	1s752ms	0ms
	03	16,556	1s502ms	0ms
	04	14,145	1s340ms	0ms
	05	17,039	1s620ms	0ms
	06	18,669	1s792ms	0ms
	07	17,990	1s684ms	0ms
	08	27,746	2s286ms	0ms
	09	61,359	5s374ms	0ms
	10	77,886	6s738ms	0ms
	11	90,561	8s192ms	0ms
	12	93,576	8s229ms	0ms
	13	97,515	9s66ms	0ms
	14	93,668	8s360ms	0ms
	15	97,406	9s340ms	0ms
	16	86,881	7s892ms	0ms
	17	75,541	6s943ms	0ms
	18	65,719	5s864ms	0ms
	19	57,159	5s699ms	0ms
	20	50,555	4s753ms	0ms
	21	30,382	2s567ms	0ms
	22	18,378	1s612ms	0ms

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

Date: 2024-12-08 11:42:10 Duration: 2ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-08 09:49:37 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-08 11:38:55 Duration: 1ms

6

892,825

Details

2m15s

0ms

10ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 08	00	13,248	2s56ms	0ms
	01	15,265	2s218ms	0ms
	02	11,453	1s790ms	0ms
	03	9,527	1s620ms	0ms
	04	6,839	1s339ms	0ms
	05	11,244	1s820ms	0ms
	06	14,252	2s197ms	0ms
	07	12,866	2s26ms	0ms
	08	20,451	2s840ms	0ms
	09	52,787	7s379ms	0ms
	10	66,554	9s742ms	0ms
	11	79,544	12s818ms	0ms
	12	80,771	12s149ms	0ms
	13	78,399	11s711ms	0ms
	14	75,450	10s826ms	0ms
	15	79,587	11s822ms	0ms
	16	62,245	9s460ms	0ms
	17	55,059	7s875ms	0ms
	18	48,271	7s375ms	0ms
	19	38,616	7s236ms	0ms
	20	33,889	5s124ms	0ms
	21	16,385	2s435ms	0ms
	22	10,123	1s564ms	0ms

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

Date: 2024-12-08 17:22:01 Duration: 10ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (901);

Date: 2024-12-08 17:22:01 Duration: 10ms
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 (853);

Date: 2024-12-08 17:22:01 Duration: 10ms

7

685,733

Details

2m3s

0ms

36ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 08	00	10,005	1s996ms	0ms
	01	11,590	2s101ms	0ms
	02	9,164	1s890ms	0ms
	03	7,747	1s432ms	0ms
	04	5,878	1s180ms	0ms
	05	9,587	1s719ms	0ms
	06	11,663	2s11ms	0ms
	07	10,785	1s972ms	0ms
	08	15,986	2s383ms	0ms
	09	40,636	6s166ms	0ms
	10	50,305	8s103ms	0ms
	11	59,337	9s981ms	0ms
	12	59,415	10s160ms	0ms
	13	59,522	10s952ms	0ms
	14	58,085	10s385ms	0ms
	15	59,887	11s295ms	0ms
	16	47,298	8s541ms	0ms
	17	43,364	8s206ms	0ms
	18	37,925	6s772ms	0ms
	19	29,868	6s390ms	0ms
	20	26,617	5s607ms	0ms
	21	12,986	2s582ms	0ms
	22	8,083	1s406ms	0ms

COMMIT;

Date: 2024-12-08 17:11:53 Duration: 36ms
COMMIT;

Date: 2024-12-08 13:44:02 Duration: 34ms
COMMIT;

Date: 2024-12-08 13:47:54 Duration: 31ms

8

557,721

Details

1m17s

0ms

7ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 08	00	11,095	1s704ms	0ms
	01	11,143	1s700ms	0ms
	02	8,738	925ms	0ms
	03	6,621	790ms	0ms
	04	5,438	562ms	0ms
	05	6,679	804ms	0ms
	06	9,662	1s202ms	0ms
	07	6,677	753ms	0ms
	08	12,136	1s383ms	0ms
	09	33,559	4s377ms	0ms
	10	42,846	5s762ms	0ms
	11	53,331	7s664ms	0ms
	12	48,823	7s737ms	0ms
	13	44,194	6s425ms	0ms
	14	41,490	5s904ms	0ms
	15	45,327	7s167ms	0ms
	16	36,950	5s199ms	0ms
	17	32,071	4s465ms	0ms
	18	30,706	3s700ms	0ms
	19	28,135	3s889ms	0ms
	20	23,611	3s303ms	0ms
	21	12,054	1s341ms	0ms
	22	6,435	693ms	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 (5101116, 5168827, 5099138, 5099007, 5099009, 5099525, 5415775, 5104284, 5100181, 5099014, 5099090, 5099422, 5099028, 5099521, 5099111, 5176347, 5106249, 5175279, 5099408, 5100232, 5100729, 5100939, 5099904, 5099765, 5099921, 5149605, 5099010, 5419481, 5100411, 5099310, 5101584, 5099802, 5099582, 5099035, 5109105, 5099321, 5099236, 5099130, 5099206, 5099804, 5100725, 5099263, 5100070, 5267230, 5113366, 5101707, 5099254, 5175816, 5103905, 5102120, 5107032, 5134772, 5139613, 5419470, 5103635, 5137147, 5098972, 5099119, 5099202);

Date: 2024-12-08 17:22:01 Duration: 7ms
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 (5100054, 5101638, 5099737, 5099248, 5099009, 5113941, 5278685, 5101470, 5099650, 5415109, 5108765, 5102793, 5110277, 5108372, 5108969, 5102509, 5106366, 5109728, 5099137, 5103051, 5099130, 5114485, 5099403);

Date: 2024-12-08 17:22:01 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 (5099009, 5101594, 5103909, 5099540, 5101635, 5099272, 5254237, 5202381, 5208842, 5100540, 5109508, 5104274, 5230470, 5099010, 5208757, 5212773, 5099015, 5099190, 5099651, 5100916, 5099403, 5099111, 5100218, 5340907, 5099187, 5105968, 5100386, 5198740, 5099503, 5104342, 5099007, 5391186, 5099008, 5262478, 5108458, 5100864, 5274284, 5145111, 5161869, 5099590, 5099206, 5099102, 5100259, 5100181, 5264555, 5099013, 5099798, 5134271, 5099310, 5099331, 5116531, 5361260, 5233524, 5099014, 5100274, 5219306, 5099236, 5335857, 5145109, 5333534, 5099243, 5103684, 5100232);

Date: 2024-12-08 17:22:02 Duration: 4ms

9

536,304

Details

34s435ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 08	00	7,852	512ms	0ms
	01	8,649	490ms	0ms
	02	6,101	322ms	0ms
	03	4,755	243ms	0ms
	04	2,892	168ms	0ms
	05	4,907	276ms	0ms
	06	8,085	411ms	0ms
	07	7,144	384ms	0ms
	08	11,241	553ms	0ms
	09	31,043	1s650ms	0ms
	10	40,082	2s246ms	0ms
	11	48,761	2s960ms	0ms
	12	47,196	3s42ms	0ms
	13	47,145	3s64ms	0ms
	14	44,360	2s968ms	0ms
	15	45,455	3s473ms	0ms
	16	37,775	2s466ms	0ms
	17	34,590	2s287ms	0ms
	18	31,483	2s30ms	0ms
	19	26,192	2s114ms	0ms
	20	22,631	1s649ms	0ms
	21	11,274	711ms	0ms
	22	6,691	405ms	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 (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);

Date: 2024-12-08 15:18:09 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 (30, 51, 49, 55, 66);

Date: 2024-12-08 19:16:35 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (17, 70, 14, 79, 68, 29, 41, 16);

Date: 2024-12-08 01:54:49 Duration: 1ms

10

467,530

Details

2m28s

0ms

18ms

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 08	00	7,259	2s156ms	0ms
	01	4,040	1s252ms	0ms
	02	2,526	769ms	0ms
	03	1,754	537ms	0ms
	04	1,430	431ms	0ms
	05	1,953	647ms	0ms
	06	2,333	762ms	0ms
	07	1,665	552ms	0ms
	08	7,285	2s66ms	0ms
	09	22,126	6s779ms	0ms
	10	31,990	9s680ms	0ms
	11	19,623	6s505ms	0ms
	12	41,271	13s216ms	0ms
	13	44,028	14s207ms	0ms
	14	49,470	15s448ms	0ms
	15	55,906	18s642ms	0ms
	16	43,936	13s685ms	0ms
	17	42,445	13s265ms	0ms
	18	32,913	10s197ms	0ms
	19	22,507	7s958ms	0ms
	20	18,420	6s165ms	0ms
	21	8,760	2s565ms	0ms
	22	3,890	1s195ms	0ms

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

Date: 2024-12-08 15:35:43 Duration: 18ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'ir.attachment' 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 = 891) OR r.global) ORDER BY r.id;

Date: 2024-12-08 12:18:11 Duration: 16ms
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 = 1077) OR r.global) ORDER BY r.id;

Date: 2024-12-08 17:22:01 Duration: 3ms

11

369,443

Details

9m38s

0ms

14s994ms

1ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 08	00	5,983	958ms	0ms
	01	5,427	937ms	0ms
	02	3,530	654ms	0ms
	03	2,729	505ms	0ms
	04	1,807	355ms	0ms
	05	3,166	595ms	0ms
	06	4,944	904ms	0ms
	07	4,607	806ms	0ms
	08	8,894	1s336ms	0ms
	09	22,913	3s787ms	0ms
	10	28,324	4s887ms	0ms
	11	33,146	6s113ms	0ms
	12	35,448	8m36s	14ms
	13	31,969	6s101ms	0ms
	14	31,284	5s891ms	0ms
	15	34,416	6s754ms	0ms
	16	26,310	4s769ms	0ms
	17	23,281	4s469ms	0ms
	18	20,334	3s803ms	0ms
	19	15,598	3s409ms	0ms
	20	13,968	2s900ms	0ms
	21	6,920	1s216ms	0ms
	22	4,445	811ms	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 (8004724);

Date: 2024-12-08 12:47:24 Duration: 14s994ms
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 (8004680);

Date: 2024-12-08 12:45:00 Duration: 14s938ms
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 (8004707);

Date: 2024-12-08 12:45:00 Duration: 14s926ms

12

332,915

Details

1m

0ms

1ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 08	00	5,159	859ms	0ms
	01	3,653	518ms	0ms
	02	1,975	271ms	0ms
	03	1,519	201ms	0ms
	04	1,512	194ms	0ms
	05	2,239	312ms	0ms
	06	1,826	258ms	0ms
	07	2,169	294ms	0ms
	08	7,006	971ms	0ms
	09	17,655	2s828ms	0ms
	10	22,973	3s841ms	0ms
	11	13,192	2s270ms	0ms
	12	28,769	5s338ms	0ms
	13	30,516	5s763ms	0ms
	14	34,914	6s582ms	0ms
	15	38,062	7s733ms	0ms
	16	28,254	5s384ms	0ms
	17	29,881	5s617ms	0ms
	18	22,567	4s133ms	0ms
	19	15,953	3s340ms	0ms
	20	14,033	2s682ms	0ms
	21	6,360	1s3ms	0ms
	22	2,728	417ms	0ms

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-08 17:26:25 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-08 16:30:12 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-08 15:18:31 Duration: 1ms

13

272,274

Details

1d7h20m43s

334ms

2s490ms

414ms

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 08	00	12,183	1h21m32s	401ms
	01	8,184	53m46s	394ms
	02	8,642	56m51s	394ms
	03	6,232	40m13s	387ms
	04	6,972	46m34s	400ms
	05	8,850	58m9s	394ms
	06	7,990	51m48s	389ms
	07	7,836	51m4s	391ms
	08	2,608	16m36s	382ms
	09	7,941	51m9s	386ms
	10	11,453	1h15m44s	396ms
	11	17,027	1h55m26s	406ms
	12	13,946	1h35m41s	411ms
	13	15,662	1h49m43s	420ms
	14	13,797	1h38m45s	429ms
	15	17,686	2h20m10s	475ms
	16	13,836	1h45m56s	459ms
	17	14,238	1h39m37s	419ms
	18	14,810	1h38m9s	397ms
	19	23,741	2h55m41s	444ms
	20	22,353	2h33m37s	412ms
	21	9,216	59m36s	388ms
	22	7,071	44m43s	379ms

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

Date: 2024-12-08 19:42:32 Duration: 2s490ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3288997)) AND (("shipping_track"."id" not in (26878029, 26881222, 26953427, 27183218, 27183414, 27289785, 27290440, 27595575, 27596655, 27596655)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 16:29:30 Duration: 2s328ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3387186)) AND (("shipping_track"."id" not in (27648640, 27648640)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 19:43:09 Duration: 1s298ms

14

254,250

Details

1m6s

0ms

25ms

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

Day	Hour	Count	Duration	Avg duration
Dec 08	00	6,202	1s665ms	0ms
	01	5,113	1s491ms	0ms
	02	4,526	1s108ms	0ms
	03	3,000	778ms	0ms
	04	3,216	831ms	0ms
	05	3,637	952ms	0ms
	06	4,397	1s248ms	0ms
	07	3,178	810ms	0ms
	08	4,914	1s75ms	0ms
	09	13,245	3s487ms	0ms
	10	17,189	4s629ms	0ms
	11	21,282	5s490ms	0ms
	12	20,263	5s924ms	0ms
	13	19,726	4s965ms	0ms
	14	18,441	4s755ms	0ms
	15	20,069	5s945ms	0ms
	16	16,691	4s76ms	0ms
	17	16,442	4s78ms	0ms
	18	15,097	3s592ms	0ms
	19	14,816	4s3ms	0ms
	20	12,687	3s329ms	0ms
	21	6,661	1s553ms	0ms
	22	3,458	787ms	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 (41103752, 41282453, 40825659, 41195100, 41192945, 41301531, 41291519, 41209028, 41293059, 41382079, 41456305, 41398953, 40969625, 41363473, 41233075, 41452509, 41235667, 41135301, 41370317, 39687891, 40864039, 41346067, 41409290, 41488960, 41130207, 41503693, 41357307, 40864340, 41447977, 41427294, 41378915, 41479466, 41357260, 41367560, 40701331, 41208923, 41300137, 41384625, 41365454, 41280524, 41253817, 41363638, 40864001, 41394670, 41367018, 41334324, 41378544, 41275696, 41284420, 41353783, 41466202, 41356795, 41090070, 41443032, 41013330, 41504151, 41357462, 41357326, 41256060, 41346020, 40744376, 41235288, 41251750, 32649895, 41401722, 40865281, 41437279, 41470146, 41365172, 41370375, 41406980, 41280773, 41452591, 41432578, 41314745, 40775367, 40398990, 41105218, 41256045, 40851229, 41319680, 41447992, 41008084, 41290757, 41342994, 40972246, 41334169, 41375758, 41351582, 40864681, 41391274, 40896423, 41353032, 41119415, 41315790, 41277243, 41223283, 41284425, 41420283, 41316064, 41379189, 41379188, 41378977, 41408651, 41089744, 41252146, 41479065, 41368060, 41353537, 41346568, 41315018, 41252113, 41379397, 41408772, 41353526, 41427603, 41098817, 41488842, 41220221, 41171234, 41448046, 41078779, 41378974, 41357219, 41426886, 41324453, 32649721, 40926823, 41444700, 41402122, 41055226, 40718640, 40402477, 41352317, 40778868, 40588760, 40765083, 40265466, 41235700, 41504298, 41399410, 41372299, 41251776, 41256072, 41240206, 41467543, 40864084, 41463444, 41130227, 41060214, 41459396, 41199043, 41425601, 41187234, 41368212, 41479629, 41315867, 41368099, 41250564, 41503963, 41326890, 41370846, 41433690, 41334338, 41371648, 41452590, 41406611, 41274210, 41432659, 41482632, 41276283, 40654983, 41119039, 41170736, 41385694, 41412388, 40968168, 41352222, 41379403, 41448564, 39494431, 41356794, 40832700, 41426906, 41409469, 40599312, 41008479, 40487982, 41252334, 41488654, 41378965, 41000538, 41171457, 41427364, 41353188, 41488869, 41427366, 41506542, 41239429, 41479114);

Date: 2024-12-08 20:08:12 Duration: 25ms
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 (39380928, 39708446, 39791219, 32614001, 39934686, 40227663, 40259522, 32595888, 40085619, 40730747, 32595766, 39750167, 39935189, 41164754, 39935086, 32595460, 41345029, 39657633, 39957785, 40255019, 40356167, 39423184, 40061429, 40355645, 40435362, 39939633, 40287241, 40699558, 40665437, 39828630, 40565958, 40000850, 39622891, 40035266, 40442056, 40352543, 40164103, 40970393, 40757438, 40011637, 40252318, 40440500, 32605406, 40289014, 39777673, 40246274, 40060277, 39896309, 40682908, 40727165, 40346210, 39895391, 40236839, 40904185, 41123487, 40272507, 40524012, 39971889, 40453113, 40122062, 40760301, 41093698, 40621346, 40004895, 39791280, 40800190, 40323000, 40322833, 40861792, 40735243, 40552081, 39871287, 39664367, 40296538, 39663665, 41043024, 39898563, 39711042, 40646137, 32625997, 32589166, 41161945, 32571908, 32590141, 38977619, 32590660, 39695410, 40180566, 32590676, 40180575, 40180581, 39695091, 40179730, 32627799, 32609243, 40732564, 39708163, 40454677, 40294160, 39931878);

Date: 2024-12-08 17:22:02 Duration: 24ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (40984508, 40984520, 41278850, 41208184, 40984535, 41366700, 41319957, 41384233, 40958342, 41079531, 41351942, 41288659, 41200452, 41200463, 41200467, 41352276, 41351944, 41084090, 41178960, 41226552, 41208238, 41384231, 41278860, 41351943, 41130917, 41084314, 41131369, 41369477, 41176914, 41351945, 41379055, 41367723, 41131365, 41200464, 41084312, 32615695, 41278858, 41131293, 41289077, 41130918, 41279498, 41255210, 41098852, 41098686, 41098691, 41319954, 32620345, 40328874, 41098945, 41208237, 41278855, 41366701, 41315484, 41098856, 41098851, 41098854, 41351831, 41208239, 41179565, 41072482, 41022509, 41098849, 41223980, 41131367, 41098848, 41351829, 41131292, 41278857, 41224585, 41351822, 41208171, 41098855, 41099393, 41099396, 41098858, 40831879, 41224586, 41098844, 41206303, 41353132, 41208241, 41255213, 41319953, 41098688, 38892733, 40478972, 41278851, 41099626, 41351830, 41098847, 32615704, 41098658, 41203474, 41208172, 41131196, 41207870, 41099394, 41353133, 40832259, 41131197, 41098664, 41203260, 41351825, 41179585, 41278847, 41351835, 41322368, 41202702, 41279499, 41279245, 41207873, 40328891, 41208168, 41098677, 41072481, 41207810, 41052109, 41079513, 41223683, 41179583, 41079540, 41008458, 41278644, 32615705, 41248480, 41008454, 41079529, 41203258, 41208392, 41083771, 41223681, 41255433, 40535066, 40720806, 41205813, 41008459, 41206362, 41239815, 41179264, 41179458, 41179582, 41079512, 41079532, 40463165, 41079520, 41179261, 41273216, 41207809, 41205812, 41207876, 41079528, 41086947, 41255211, 41008539, 32621344, 41079521, 41070372, 41240455, 41079511, 41206360, 41207805, 41178888, 41079514, 41079523, 41022507, 41206363, 41207877, 41207803, 32620347, 41315628, 41205763, 41079522, 41278655, 41288645, 41070112, 41171494, 40599638, 41022574, 41273218, 32620314, 41278645, 40328883, 41273223, 40599639, 41273221, 40720802, 41086949, 41130904, 32615693, 41207213, 32616040, 41206624, 40888637, 40888636, 32616041, 32615696, 41022573, 40599640, 41099154, 41022575, 40599636, 32615697, 32616039, 40579175, 40957980, 40832169, 41130896, 32619342, 41086944, 40958049, 40958047, 32616099, 40675637, 32616417, 40779257, 32620969, 40675634, 40779255, 32621342, 40698275, 40957977, 40675625, 40957981, 40698274, 40779263, 40957983, 40743750);

Date: 2024-12-08 16:18:23 Duration: 17ms

15

208,591

Details

12s16ms

0ms

1ms

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

Day	Hour	Count	Duration	Avg duration
Dec 08	00	3,068	160ms	0ms
	01	1,740	89ms	0ms
	02	1,011	50ms	0ms
	03	693	34ms	0ms
	04	525	25ms	0ms
	05	778	40ms	0ms
	06	915	49ms	0ms
	07	723	37ms	0ms
	08	3,137	151ms	0ms
	09	9,885	532ms	0ms
	10	14,527	782ms	0ms
	11	8,450	486ms	0ms
	12	19,121	1s109ms	0ms
	13	19,961	1s154ms	0ms
	14	22,593	1s301ms	0ms
	15	25,704	1s592ms	0ms
	16	19,802	1s132ms	0ms
	17	18,821	1s84ms	0ms
	18	14,053	800ms	0ms
	19	9,599	625ms	0ms
	20	8,157	500ms	0ms
	21	3,824	196ms	0ms
	22	1,504	79ms	0ms

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

Date: 2024-12-08 12:18:11 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-08 12:57:31 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 (2, 10);

Date: 2024-12-08 13:02:04 Duration: 1ms

16

196,480

Details

24s918ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 08	00	2,924	339ms	0ms
	01	1,668	188ms	0ms
	02	901	98ms	0ms
	03	639	68ms	0ms
	04	506	54ms	0ms
	05	715	82ms	0ms
	06	864	99ms	0ms
	07	694	77ms	0ms
	08	2,909	305ms	0ms
	09	9,316	1s92ms	0ms
	10	13,697	1s597ms	0ms
	11	7,889	1s	0ms
	12	17,995	2s277ms	0ms
	13	18,585	2s336ms	0ms
	14	21,623	2s745ms	0ms
	15	24,173	3s325ms	0ms
	16	18,800	2s391ms	0ms
	17	17,869	2s261ms	0ms
	18	13,003	1s629ms	0ms
	19	9,097	1s347ms	0ms
	20	7,659	1s35ms	0ms
	21	3,525	396ms	0ms
	22	1,429	167ms	0ms

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

Date: 2024-12-08 16:27:40 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-08 15:34:49 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-08 19:23:48 Duration: 0ms

17

188,495

Details

19s125ms

0ms

1ms

0ms

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 08	00	2,769	280ms	0ms
	01	638	70ms	0ms
	02	276	34ms	0ms
	03	127	16ms	0ms
	04	259	29ms	0ms
	05	314	38ms	0ms
	06	378	45ms	0ms
	07	344	39ms	0ms
	08	2,366	217ms	0ms
	09	7,648	735ms	0ms
	10	12,450	1s202ms	0ms
	11	4,484	528ms	0ms
	12	16,255	1s632ms	0ms
	13	17,431	1s768ms	0ms
	14	23,534	2s329ms	0ms
	15	27,131	2s822ms	0ms
	16	20,762	2s116ms	0ms
	17	20,347	1s993ms	0ms
	18	13,744	1s360ms	0ms
	19	8,560	972ms	0ms
	20	5,608	594ms	0ms
	21	2,419	227ms	0ms
	22	651	69ms	0ms

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

Date: 2024-12-08 17:22:01 Duration: 1ms
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1198;

Date: 2024-12-08 17:22:01 Duration: 1ms
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 856;

Date: 2024-12-08 17:22:01 Duration: 1ms

18

185,518

Details

14s122ms

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

Day	Hour	Count	Duration	Avg duration
Dec 08	00	2,560	239ms	0ms
	01	3,234	201ms	0ms
	02	2,331	136ms	0ms
	03	1,880	112ms	0ms
	04	1,073	65ms	0ms
	05	1,866	114ms	0ms
	06	2,916	170ms	0ms
	07	2,039	118ms	0ms
	08	4,265	230ms	0ms
	09	11,758	691ms	0ms
	10	15,030	926ms	0ms
	11	18,793	1s290ms	0ms
	12	17,488	1s313ms	0ms
	13	15,948	1s244ms	0ms
	14	14,748	1s192ms	0ms
	15	16,004	1s379ms	0ms
	16	12,559	827ms	0ms
	17	10,750	754ms	0ms
	18	9,736	740ms	0ms
	19	8,298	949ms	0ms
	20	6,989	905ms	0ms
	21	3,385	398ms	0ms
	22	1,868	119ms	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-08 14:40:12 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-08 16:29:28 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-08 17:22:01 Duration: 1ms

19

166,937

Details

52s875ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 08	00	15,438	4s413ms	0ms
	01	8,746	2s638ms	0ms
	02	10,177	3s106ms	0ms
	03	5,946	1s890ms	0ms
	04	9,632	2s813ms	0ms
	05	9,206	2s962ms	0ms
	06	7,888	2s661ms	0ms
	07	6,201	2s237ms	0ms
	08	799	218ms	0ms
	09	934	421ms	0ms
	10	1,809	694ms	0ms
	11	1,531	733ms	0ms
	12	955	409ms	0ms
	13	1,033	446ms	0ms
	14	1,448	523ms	0ms
	15	5,961	2s404ms	0ms
	16	5,008	1s659ms	0ms
	17	7,606	2s339ms	0ms
	18	14,368	4s245ms	0ms
	19	21,081	7s111ms	0ms
	20	14,067	4s295ms	0ms
	21	11,485	3s112ms	0ms
	22	5,618	1s535ms	0ms

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

Date: 2024-12-08 16:29:33 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 22) AND ("price_list"."to_office_id" = 78)) ORDER BY "price_list"."id";

Date: 2024-12-08 17:22:12 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 51) AND ("price_list"."to_office_id" = 44)) ORDER BY "price_list"."id";

Date: 2024-12-08 19:44:54 Duration: 1ms

20

166,349

Details

33s411ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 08	00	2,319	435ms	0ms
	01	1,376	255ms	0ms
	02	777	143ms	0ms
	03	582	104ms	0ms
	04	445	81ms	0ms
	05	659	125ms	0ms
	06	782	148ms	0ms
	07	765	145ms	0ms
	08	2,751	471ms	0ms
	09	8,314	1s570ms	0ms
	10	12,111	2s272ms	0ms
	11	7,539	1s553ms	0ms
	12	15,101	3s36ms	0ms
	13	15,940	3s208ms	0ms
	14	18,335	3s669ms	0ms
	15	19,390	4s119ms	0ms
	16	15,039	3s14ms	0ms
	17	14,646	2s964ms	0ms
	18	10,970	2s173ms	0ms
	19	7,861	1s739ms	0ms
	20	6,546	1s403ms	0ms
	21	2,920	545ms	0ms
	22	1,181	229ms	0ms

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

Date: 2024-12-08 17:22:01 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1198) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-08 17:22:01 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (862) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-08 12:05:10 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

12m49s

53s40ms

25

Details

22m6s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 08	12	1	1ms	1ms
	15	5	9m16s	1m51s
	16	10	12ms	1ms
	17	3	12m49s	4m16s
	20	4	6ms	1ms
	21	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-08 16:32:22.849391', "last_update" = '2024-12-08 15:47:22.849413', "write_date" = '2024-12-08 15:47:22.523415', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-08 17:00:11 Duration: 12m49s
UPDATE "res_users" SET "exp_date" = '2024-12-08 14:45:46.474026', "last_update" = '2024-12-08 14:00:46.474045', "write_date" = '2024-12-08 14:00:46.137590', "write_uid" = 821 WHERE id IN (821);

Date: 2024-12-08 15:10:03 Duration: 9m16s
UPDATE "res_users" SET "exp_date" = '2024-12-08 20:10:45.535596', "last_update" = '2024-12-08 19:25:45.535645', "write_date" = '2024-12-08 19:25:45.084331', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-08 20:25:45 Duration: 3ms

2

0ms

30m50s

24s484ms

222

Details

1h30m35s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 08	10	1	0ms	0ms
	12	2	2ms	1ms
	14	1	1m42s	1m42s
	15	49	5m35s	6s840ms
	16	46	1m36s	2s93ms
	17	34	43ms	1ms
	18	24	1h16m1s	3m10s
	19	28	23ms	0ms
	20	23	5m40s	14s786ms
	21	10	5ms	0ms
	22	4	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2024-12-08 18:00:30.204794', "last_update" = '2024-12-08 17:15:30.204825', "sid" = 'af95b564a87a50209d634382310ade2045f56f20', "write_date" = '2024-12-08 17:15:29.836531', "write_uid" = 1 WHERE id IN (848);

Date: 2024-12-08 18:46:20 Duration: 30m50s
UPDATE "res_users" SET "exp_date" = '2024-12-08 18:09:04.589587', "last_update" = '2024-12-08 17:24:04.589604', "sid" = 'af95b564a87a50209d634382310ade2045f56f20', "write_date" = '2024-12-08 17:24:04.244644', "write_uid" = 1 WHERE id IN (848);

Date: 2024-12-08 18:46:20 Duration: 22m15s
UPDATE "res_users" SET "exp_date" = '2024-12-08 18:13:47.322882', "last_update" = '2024-12-08 17:28:47.322900', "sid" = 'af95b564a87a50209d634382310ade2045f56f20', "write_date" = '2024-12-08 17:28:46.967426', "write_uid" = 1 WHERE id IN (848);

Date: 2024-12-08 18:46:20 Duration: 17m33s

3

0ms

1h

3s765ms

76,026

Details

3d7h31m5s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 08	00	905	212ms	0ms
	01	1,068	238ms	0ms
	02	904	196ms	0ms
	03	747	166ms	0ms
	04	583	2h10m2s	13s383ms
	05	872	195ms	0ms
	06	917	202ms	0ms
	07	794	172ms	0ms
	08	1,780	376ms	0ms
	09	4,680	9h36m3s	7s385ms
	10	5,435	8h6m10s	5s367ms
	11	6,401	1s646ms	0ms
	12	6,966	9h25m54s	4s874ms
	13	6,795	10h17m12s	5s450ms
	14	6,578	6h51m24s	3s752ms
	15	7,382	4h44m22s	2s311ms
	16	5,814	6h28m32s	4s9ms
	17	5,331	7h27m44s	5s39ms
	18	4,020	6h3m24s	5s423ms
	19	3,403	13m40s	241ms
	20	2,638	8h5m44s	11s47ms
	21	1,290	44s934ms	34ms
	22	723	161ms	0ms

update res_users set sid = '59d0b234ce053ef84522aca4f144b3ddd2f342a9', last_update = '2024-12-08 02:16:55.815260', exp_date = '2024-12-08 03:01:55.815263', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-08 04:16:56 Duration: 1h
update res_users set sid = '59d0b234ce053ef84522aca4f144b3ddd2f342a9', last_update = '2024-12-08 02:16:55.815972', exp_date = '2024-12-08 03:01:55.815976', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-08 04:16:56 Duration: 1h
update res_users set sid = 'efe4a31005d8b521e0e5d96824fe121f17bca57c', last_update = '2024-12-08 10:15:24.745701', exp_date = '2024-12-08 11:00:24.745703', logged_in = 'TRUE' where id = 1292;

Date: 2024-12-08 12:15:24 Duration: 59m59s

4

2s375ms

6s307ms

3s755ms

638

Details

39m55s

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."v_10_id" = ?)) order by "res_partner"."display_name" asc, "res_partner"."id" desc limit ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 08	10	14	51s33ms	3s645ms
	11	57	3m31s	3s716ms
	12	51	3m11s	3s750ms
	13	51	3m24s	4s8ms
	14	54	3m23s	3s771ms
	15	53	3m29s	3s944ms
	16	52	3m12s	3s698ms
	17	51	3m11s	3s747ms
	18	57	3m30s	3s700ms
	19	51	3m33s	4s191ms
	20	52	3m17s	3s802ms
	21	54	2m59s	3s328ms
	22	41	2m18s	3s385ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-08 19:45:12 Duration: 6s307ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-08 19:32:05 Duration: 5s323ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."v_10_id" = 1537)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC LIMIT 1;

Date: 2024-12-08 19:41:36 Duration: 5s294ms

5

918ms

4s643ms

3s494ms

481

Details

28m

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

Day	Hour	Count	Duration	Avg duration
Dec 08	01	17	54s701ms	3s217ms
	02	117	6m13s	3s192ms
	09	7	23s962ms	3s423ms
	10	17	1m	3s562ms
	11	18	1m	3s384ms
	12	7	22s731ms	3s247ms
	13	7	28s4ms	4s
	14	8	27s678ms	3s459ms
	15	78	4m54s	3s772ms
	16	101	6m6s	3s627ms
	17	30	1m46s	3s565ms
	18	27	1m39s	3s686ms
	19	5	16s502ms	3s300ms
	20	23	1m22s	3s599ms
	21	16	52s845ms	3s302ms
	22	3	9s465ms	3s155ms

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

Date: 2024-12-08 16:29:51 Duration: 4s643ms
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 (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) AND ("policy_number"."name"::text ilike '%9136580%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-08 15:41:22 Duration: 4s537ms
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 (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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) 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"."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)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-08 10:48:32 Duration: 4s532ms

6

244ms

1s913ms

1s4ms

11,241

Details

3h8m15s

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 08	00	1,470	23m20s	952ms
	01	484	7m38s	947ms
	02	16	15s300ms	956ms
	03	82	1m18s	956ms
	04	222	3m31s	951ms
	05	398	6m19s	954ms
	06	3	2s859ms	953ms
	09	28	27s528ms	983ms
	10	62	59s533ms	960ms
	11	7	7s332ms	1s47ms
	12	1	1s102ms	1s102ms
	13	3	3s319ms	1s106ms
	14	1	961ms	961ms
	15	830	15m5s	1s90ms
	16	606	10m18s	1s20ms
	17	672	11m29s	1s26ms
	18	1,456	23m40s	975ms
	19	2,059	36m22s	1s60ms
	20	1,247	21m57s	1s56ms
	21	1,261	19m46s	940ms
	22	333	5m28s	985ms

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

Date: 2024-12-08 19:45:10 Duration: 1s913ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9152879')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-08 19:43:34 Duration: 1s895ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9196150')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-08 19:44:53 Duration: 1s893ms

7

333ms

2s980ms

425ms

48,612

Details

5h45m5s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 08	00	368	2m33s	417ms
	01	258	1m47s	418ms
	02	204	1m27s	428ms
	03	168	1m11s	427ms
	04	102	45s190ms	443ms
	05	213	1m30s	424ms
	06	286	1m55s	404ms
	07	341	2m20s	412ms
	08	971	6m14s	385ms
	09	2,383	15m46s	397ms
	10	3,672	24m44s	404ms
	11	4,751	33m	416ms
	12	4,567	32m14s	423ms
	13	3,551	25m30s	431ms
	14	4,275	31m42s	445ms
	15	3,675	29m49s	486ms
	16	4,583	35m22s	463ms
	17	3,502	24m22s	417ms
	18	3,306	21m20s	387ms
	19	3,044	22m5s	435ms
	20	2,921	20m3s	412ms
	21	921	5m44s	373ms
	22	550	3m28s	379ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3372573, 3370939, 3370937, 3370913, 3370907, 3359934, 3359930, 3358893, 3357969, 3355279, 3352823, 3351954, 3351950, 3351279, 3350781, 3350581, 3349300, 3348352, 3347936, 3347707, 3347513, 3346405, 3346153, 3345665, 3344431, 3342869, 3342175, 3341229, 3340930, 3340929, 3340910, 3337575, 3337477, 3336712, 3336665, 3336605, 3331766, 3323538, 3321639, 3320505, 3297093)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 19:43:06 Duration: 2s980ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3303784)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 16:29:43 Duration: 1s920ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3364292)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 19:44:51 Duration: 1s210ms

8

334ms

2s490ms

414ms

272,274

Details

1d7h20m43s

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

Day	Hour	Count	Duration	Avg duration
Dec 08	00	12,183	1h21m32s	401ms
	01	8,184	53m46s	394ms
	02	8,642	56m51s	394ms
	03	6,232	40m13s	387ms
	04	6,972	46m34s	400ms
	05	8,850	58m9s	394ms
	06	7,990	51m48s	389ms
	07	7,836	51m4s	391ms
	08	2,608	16m36s	382ms
	09	7,941	51m9s	386ms
	10	11,453	1h15m44s	396ms
	11	17,027	1h55m26s	406ms
	12	13,946	1h35m41s	411ms
	13	15,662	1h49m43s	420ms
	14	13,797	1h38m45s	429ms
	15	17,686	2h20m10s	475ms
	16	13,836	1h45m56s	459ms
	17	14,238	1h39m37s	419ms
	18	14,810	1h38m9s	397ms
	19	23,741	2h55m41s	444ms
	20	22,353	2h33m37s	412ms
	21	9,216	59m36s	388ms
	22	7,071	44m43s	379ms

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

Date: 2024-12-08 19:42:32 Duration: 2s490ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3288997)) AND (("shipping_track"."id" not in (26878029, 26881222, 26953427, 27183218, 27183414, 27289785, 27290440, 27595575, 27596655, 27596655)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 16:29:30 Duration: 2s328ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3387186)) AND (("shipping_track"."id" not in (27648640, 27648640)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-08 19:43:09 Duration: 1s298ms

9

220ms

596ms

304ms

25,491

Details

2h9m10s

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 08	00	2,120	9m56s	281ms
	01	1,350	6m9s	273ms
	02	2,033	9m26s	278ms
	03	1,031	4m45s	277ms
	04	1,881	8m52s	283ms
	05	1,361	6m24s	282ms
	06	1,352	6m23s	283ms
	07	922	4m21s	283ms
	08	189	52s866ms	279ms
	09	18	5s77ms	282ms
	10	191	58s556ms	306ms
	11	50	15s680ms	313ms
	12	113	34s600ms	306ms
	13	128	42s959ms	335ms
	14	281	1m26s	309ms
	15	249	1m29s	359ms
	16	599	3m30s	351ms
	17	1,231	6m43s	327ms
	18	2,151	11m19s	315ms
	19	3,225	18m59s	353ms
	20	2,290	12m18s	322ms
	21	1,636	8m3s	295ms
	22	1,090	5m28s	301ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9292496')) 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-08 19:44:51 Duration: 596ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9225354')) 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-08 16:29:32 Duration: 591ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9292318')) 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-08 19:36:34 Duration: 588ms

10

173ms

439ms

272ms

23,094

Details

1h45m2s

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

Day	Hour	Count	Duration	Avg duration
Dec 08	08	427	1m42s	239ms
	09	353	1m27s	249ms
	10	15	3s921ms	261ms
	12	2,178	9m27s	260ms
	13	5,282	23m18s	264ms
	14	3,491	15m53s	273ms
	15	4,259	20m33s	289ms
	16	1,567	7m37s	292ms
	17	2,794	12m42s	273ms
	18	2,171	9m27s	261ms
	19	427	2m10s	304ms
	20	130	36s784ms	282ms

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

Date: 2024-12-08 16:29:27 Duration: 439ms
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" = '9148451')))) ORDER BY "collection_policy"."id";

Date: 2024-12-08 16:29:28 Duration: 432ms
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" = '9238567')))) ORDER BY "collection_policy"."id";

Date: 2024-12-08 16:29:26 Duration: 427ms

11

97ms

847ms

245ms

72,204

Details

4h55m14s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 08	00	7,054	26m57s	229ms
	01	3,564	12m43s	214ms
	02	4,006	16m7s	241ms
	03	2,158	8m13s	228ms
	04	4,106	16m13s	237ms
	05	3,398	15m10s	267ms
	06	2,672	10m12s	229ms
	07	1,818	6m8s	202ms
	08	368	1m18s	212ms
	09	88	22s758ms	258ms
	10	494	1m43s	210ms
	11	112	23s500ms	209ms
	12	220	53s430ms	242ms
	13	262	1m6s	251ms
	14	560	2m13s	238ms
	15	2,122	8m14s	233ms
	16	2,384	10m6s	254ms
	17	3,752	16m12s	259ms
	18	7,125	29m23s	247ms
	19	10,451	49m28s	284ms
	20	6,988	29m13s	250ms
	21	5,704	22m7s	232ms
	22	2,798	10m39s	228ms

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-08 19:41:33 Duration: 847ms
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-08 19:45:32 Duration: 835ms
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-08 19:45:33 Duration: 833ms

12

170ms

1s377ms

230ms

122,790

Details

7h50m58s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 08	00	657	2m7s	193ms
	01	1,486	4m45s	192ms
	02	1,736	5m35s	193ms
	03	1,318	4m13s	192ms
	04	2,765	8m52s	192ms
	05	2,702	8m44s	193ms
	06	3,575	11m32s	193ms
	07	2,652	8m37s	195ms
	08	721	2m18s	191ms
	09	2,392	7m55s	198ms
	10	608	2m1s	199ms
	11	1,047	3m33s	203ms
	12	4,537	15m45s	208ms
	13	11,211	39m36s	211ms
	14	8,662	31m11s	216ms
	15	8,474	34m28s	244ms
	16	5,372	21m53s	244ms
	17	5,901	22m29s	228ms
	18	4,808	17m13s	215ms
	19	29,482	2h7m15s	259ms
	20	10,987	43m26s	237ms
	21	14	2s945ms	210ms
	22	11,683	47m19s	243ms

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

Date: 2024-12-08 19:43:05 Duration: 1s377ms
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" = '9244127')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-08 19:42:33 Duration: 1s288ms
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" = '9257001')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-08 16:29:38 Duration: 689ms

13

175ms

316ms

206ms

3,245

Details

11m10s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 08	04	68	13s76ms	192ms
	05	2	396ms	198ms
	06	786	2m33s	195ms
	07	590	1m54s	194ms
	08	72	13s809ms	191ms
	09	177	34s600ms	195ms
	10	71	13s817ms	194ms
	12	58	12s164ms	209ms
	13	482	1m42s	213ms
	14	674	2m27s	218ms
	15	71	18s89ms	254ms
	16	161	37s596ms	233ms
	17	33	8s128ms	246ms

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

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

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

Date: 2024-12-08 15:41:21 Duration: 304ms

14

172ms

340ms

206ms

12,612

Details

43m20s

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 08	01	420	1m20s	192ms
	02	461	1m28s	192ms
	03	184	35s614ms	193ms
	04	1,140	3m40s	193ms
	05	924	2m58s	193ms
	06	1,394	4m28s	192ms
	07	804	2m37s	195ms
	08	187	35s570ms	190ms
	09	652	2m7s	195ms
	10	502	1m40s	200ms
	11	1,047	3m33s	204ms
	12	959	3m16s	205ms
	13	952	3m24s	214ms
	14	1,110	4m5s	220ms
	15	739	3m2s	247ms
	16	136	30s995ms	227ms
	17	265	1m2s	235ms
	18	346	1m12s	208ms
	19	273	1m11s	260ms
	20	103	23s558ms	228ms
	21	14	2s961ms	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" = '9192461')) 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-08 15:15:19 Duration: 340ms
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" = '9050032')) 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 (35)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (35))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (35))))) 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-08 19:37:16 Duration: 326ms
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" = '9296752')) 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 (14, 74, 70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-08 19:41:16 Duration: 323ms

15

171ms

245ms

193ms

10,181

Details

32m49s

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 08	00	657	2m7s	193ms
	01	1,066	3m24s	192ms
	02	1,275	4m6s	193ms
	03	1,134	3m37s	192ms
	04	1,557	4m59s	192ms
	05	1,777	5m45s	194ms
	06	1,394	4m29s	193ms
	07	1,224	3m58s	194ms
	22	97	19s772ms	203ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9210048')) 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-08 01:14:00 Duration: 245ms
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" = '9250730')) 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-08 01:14:00 Duration: 243ms
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" = '9246985')) 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-08 01:14:00 Duration: 242ms

16

119ms

236ms

145ms

5,754

Details

13m54s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 08	06	5	657ms	131ms
	07	10	1s335ms	133ms
	08	57	7s406ms	129ms
	09	312	41s843ms	134ms
	10	585	1m20s	138ms
	11	1,120	2m37s	140ms
	12	1,091	2m34s	141ms
	13	722	1m46s	147ms
	14	429	1m3s	147ms
	15	600	1m37s	162ms
	16	182	28s52ms	154ms
	17	262	39s635ms	151ms
	18	128	18s82ms	141ms
	19	81	12s847ms	158ms
	20	90	13s256ms	147ms
	21	64	8s683ms	135ms
	22	16	2s174ms	135ms

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-08 15:15:11 Duration: 236ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) 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-08 15:15:05 Duration: 219ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) 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-08 15:23:39 Duration: 213ms

17

71ms

447ms

92ms

18,987

Details

29m21s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 08	00	4	327ms	81ms
	07	57	4s721ms	82ms
	08	229	19s337ms	84ms
	09	924	1m17s	84ms
	10	1,414	2m4s	88ms
	11	1,577	2m21s	89ms
	12	1,733	2m37s	90ms
	13	2,369	3m34s	90ms
	14	1,945	3m6s	95ms
	15	1,639	2m51s	104ms
	16	2,070	3m33s	102ms
	17	1,872	2m48s	90ms
	18	688	59s948ms	87ms
	19	872	1m19s	90ms
	20	1,351	2m1s	90ms
	21	206	16s936ms	82ms
	22	37	3s180ms	85ms

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

Date: 2024-12-08 16:29:32 Duration: 447ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7783501)) AND (("cash_track"."id" not in (5459189)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-08 16:29:28 Duration: 215ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7783502)) AND (("cash_track"."id" not in (5459190)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-08 16:29:28 Duration: 187ms

18

33ms

178ms

48ms

52,435

Details

42m28s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 08	00	51	2s352ms	46ms
	01	7	317ms	45ms
	02	6	277ms	46ms
	03	3	136ms	45ms
	05	2	92ms	46ms
	06	17	787ms	46ms
	07	46	2s94ms	45ms
	08	551	24s687ms	44ms
	09	918	41s940ms	45ms
	10	831	39s552ms	47ms
	11	604	29s606ms	49ms
	12	2,113	1m44s	49ms
	13	13,041	10m35s	48ms
	14	9,336	7m40s	49ms
	15	6,929	6m4s	52ms
	16	4,431	3m47s	51ms
	17	6,889	5m17s	46ms
	18	4,525	3m16s	43ms
	19	1,247	1m	48ms
	20	675	31s532ms	46ms
	21	130	5s311ms	40ms
	22	83	3s425ms	41ms

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

Date: 2024-12-08 19:43:02 Duration: 178ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3298479) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-08 17:22:02 Duration: 109ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3250153) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-08 14:43:10 Duration: 106ms

19

31ms

67ms

43ms

21,464

Details

15m42s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 08	08	193	7s860ms	40ms
	09	413	17s57ms	41ms
	10	55	2s260ms	41ms
	12	939	42s138ms	44ms
	13	4,101	2m58s	43ms
	14	4,818	3m34s	44ms
	15	3,418	2m40s	46ms
	16	1,959	1m30s	46ms
	17	3,127	2m11s	41ms
	18	1,944	1m15s	38ms
	19	408	17s742ms	43ms
	20	89	3s843ms	43ms

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

Date: 2024-12-08 12:47:06 Duration: 67ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3172211) ORDER BY "collection_policy"."id";

Date: 2024-12-08 12:47:06 Duration: 65ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3135616) ORDER BY "collection_policy"."id";

Date: 2024-12-08 12:47:08 Duration: 64ms

20

27ms

166ms

38ms

155,687

Details

1h39m46s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 08	00	5,979	3m25s	34ms
	01	3,230	1m50s	34ms
	02	2,450	1m24s	34ms
	03	1,935	1m6s	34ms
	04	2,088	1m12s	34ms
	05	2,486	1m25s	34ms
	06	1,797	1m2s	34ms
	07	2,109	1m13s	35ms
	08	1,942	1m6s	34ms
	09	5,780	3m23s	35ms
	10	8,340	5m	36ms
	11	12,535	7m38s	36ms
	12	11,129	6m53s	37ms
	13	13,795	8m39s	37ms
	14	10,875	7m3s	38ms
	15	12,612	9m3s	43ms
	16	10,121	7m	41ms
	17	10,659	7m9s	40ms
	18	9,805	6m19s	38ms
	19	10,328	7m28s	43ms
	20	8,724	5m53s	40ms
	21	4,401	2m46s	37ms
	22	2,567	1m38s	38ms

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

Date: 2024-12-08 19:43:00 Duration: 166ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3347911)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-08 19:43:02 Duration: 164ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3376736)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-08 16:29:40 Duration: 134ms

Time consuming prepare


Date: 2024-12-08 19:42:18
Duration: 3ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 1ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 0ms
Database: postgres
Date: 2024-12-08 07:52:12
Duration: 0ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 1ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 0ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 0ms
Database: postgres

Time consuming bind


Date: 2024-12-08 19:22:17
Duration: 6ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 1ms
Database: postgres
Date: 2024-12-08 04:28:09
Duration: 0ms
Database: postgres
Date: 2024-12-08 13:52:20
Duration: 0ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 0ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 0ms
Database: postgres
Date: 2024-12-08 17:22:02
Duration: 0ms
Database: postgres

Log levels

Key values

22,700,179 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	15	0.00%
DETAIL	25	0.00%
ERROR	8,927	0.04%
FATAL	1,285	0.01%
HINT	8	0.00%
LOG	22,681,826	99.92%
STATEMENT	8,093	0.04%

Events distribution

Key values

0 PANIC entries
1285 FATAL entries
8960 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

4,110 Max number of times the same event was reported
10,245 Total events found

Rank

Times reported

Error

1

4,110

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 08	00	17
	01	16
	02	26
	03	6
	04	10
	05	13
	06	6
	07	12
	08	78
	09	188
	10	397
	11	315
	12	531
	13	357
	14	393
	15	705
	16	329
	17	264
	18	91
	19	196
	20	79
	21	54
	22	27

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

2

3,892

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 08	00	13
	01	13
	02	23
	03	5
	04	9
	05	11
	06	1
	07	9
	08	77
	09	185
	10	394
	11	310
	12	524
	13	342
	14	364
	15	666
	16	316
	17	258
	18	84
	19	152
	20	57
	21	53
	22	26

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

774

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 08	04	2
	09	28
	10	76
	12	146
	13	59
	14	103
	15	135
	16	53
	17	70
	18	53
	20	49

4

774

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 08	04	2
	09	28
	10	76
	12	146
	13	59
	14	103
	15	135
	16	53
	17	70
	18	53
	20	49

5

250

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 08	14	140
	17	110

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

6

198

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 08	14	182
	17	16

7

124

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 08	09	2
	10	9
	12	26
	13	2
	14	29
	15	21
	16	6
	17	15
	18	4
	20	10

8

25

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 08	01	1
	10	4
	11	1
	12	3
	14	4
	15	3
	16	1
	19	1
	20	6
	22	1

9

24

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 08	14	12
	17	12

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

10

21

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 08	01	4
	05	4
	08	1
	09	1
	12	4
	15	2
	18	1
	19	4

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

11

9

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 08	13	7
	16	2

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

12

8

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 08	13	2
	14	4
	16	1
	18	1

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

13

7

Details

ERROR: canceling statement due to lock timeout

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 08	12	7

ERROR: canceling statement due to lock timeout

14

5

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 08	09	1
	11	1
	14	1
	15	2

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

15

5

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 08	14	3
	17	2

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

16

3

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 08	12	3

FATAL: password authentication failed for user "postgres"

17

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 08	00	1
	08	1
	19	1

18

3

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 08	00	1
	08	1
	19	1

19

3

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 08	00	1
	08	1
	19	1

20

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 08	17	1
	19	1

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

21

2

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 08	14	1
	17	1

22

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 08	17	1

23

1

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 08	17	1

24

1

Details

ERROR: could not obtain lock on row in relation "..."

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 08	12	1

ERROR: could not obtain lock on row in relation "ir_cron"

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