pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Jan 18 23:47:17 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 37,404,084 log entries in 2m15s
Log start from 2025-01-18 00:00:00 to 2025-01-18 22:45:02

Global Stats

15,310 Number of unique normalized queries
16,150,141 Number of queries
6d12h49m10s Total query duration
2025-01-18 00:00:00 First query
2025-01-18 22:45:02 Last query
6,898 queries/s at 2025-01-18 10:40:23 Query peak

6d12h49m10s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
6d12h49m10s Execute total duration

4,843 Number of events
24 Number of unique normalized events
1,524 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
16,150,141 Average queries per session
6d12h49m10s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

6,898 queries/s Query Peak
2025-01-18 10:40:23 Date

SELECT Traffic

Key values

4,933 queries/s Query Peak
2025-01-18 10:40:23 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,319 queries/s Query Peak
2025-01-18 10:40:23 Date

Queries duration

Key values

6d12h49m10s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 18	00	211,476	0ms	59m58s	42ms	2m48s	3m10s	1h30s
	01	238,663	0ms	22s238ms	18ms	2m23s	3m1s	3m20s
	02	160,196	0ms	31m23s	30ms	2m	2m24s	32m29s
	03	126,971	0ms	17s557ms	19ms	1m18s	1m57s	3m7s
	04	134,733	0ms	4s465ms	17ms	1m13s	1m31s	2m17s
	05	61,544	0ms	694ms	9ms	28s157ms	39s440ms	56s957ms
	06	112,074	0ms	704ms	17ms	1m15s	1m38s	2m21s
	07	129,317	0ms	2s263ms	7ms	52s220ms	1m1s	1m5s
	08	414,806	0ms	7m49s	23ms	3m1s	3m23s	1h26m32s
	09	1,074,387	0ms	56m56s	60ms	5m57s	1h6m2s	12h10m7s
	10	1,591,172	0ms	6m56s	27ms	11m48s	1h17m23s	1h53m39s
	11	1,429,626	0ms	23m6s	25ms	6m12s	41m34s	4h4m3s
	12	1,584,079	0ms	13m57s	29ms	6m59s	1h43m23s	2h59m48s
	13	1,240,026	0ms	14m40s	15ms	4m46s	5m27s	2h38m49s
	14	1,059,338	0ms	41m59s	47ms	2m58s	3m51s	12h11m58s
	15	1,183,429	0ms	14m56s	23ms	3m24s	1h4m27s	2h22m10s
	16	1,094,548	0ms	28m22s	37ms	4m27s	5m35s	8h37m42s
	17	1,076,040	0ms	15m53s	30ms	7m10s	7m42s	3h46m5s
	18	969,282	0ms	52m49s	46ms	6m39s	7m13s	8h23m31s
	19	824,188	0ms	33m55s	74ms	8m12s	9m51s	7h27m30s
	20	690,806	0ms	40m40s	50ms	4m59s	5m48s	6h32m46s
	21	464,032	0ms	4s291ms	20ms	4m52s	5m28s	6m26s
	22	279,408	0ms	1h	46ms	3m39s	5m1s	2h12m38s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 18	00	115,039	47ms	2m18s	2m46s	3m10s
	01	132,428	33ms	2m4s	2m23s	3m5s
	02	83,236	35ms	1m20s	1m39s	2m24s
	03	66,173	37ms	1m6s	1m18s	2m43s
	04	72,069	32ms	1m5s	1m13s	1m55s
	05	29,067	20ms	18s849ms	28s119ms	41s375ms
	06	57,227	33ms	1m	1m15s	2m
	07	71,807	13ms	29s101ms	52s128ms	1m4s
	08	252,774	17ms	2m5s	2m53s	3m22s
	09	652,600	15ms	3m57s	4m54s	6m9s
	10	962,514	24ms	8m37s	9m40s	11m27s
	11	861,251	15ms	4m32s	6m2s	7m42s
	12	964,085	14ms	4m39s	4m53s	5m43s
	13	723,733	14ms	3m32s	4m20s	5m26s
	14	621,153	10ms	2m28s	2m47s	3m46s
	15	706,883	10ms	2m43s	3m11s	3m55s
	16	634,807	15ms	3m42s	4m7s	5m34s
	17	649,416	20ms	4m52s	5m45s	7m13s
	18	568,466	26ms	5m10s	5m44s	7m12s
	19	489,563	27ms	4m37s	7m29s	8m39s
	20	416,686	26ms	3m56s	4m39s	5m47s
	21	277,238	34ms	3m46s	4m51s	5m30s
	22	162,073	29ms	2m40s	3m27s	5m

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 18	00	19,845	4,870	137	0	145ms	116ms	141ms	220ms
	01	15,317	4,712	147	0	1ms	105ms	134ms	173ms
	02	10,071	2,896	132	0	144ms	75ms	91ms	198ms
	03	7,845	2,748	160	0	1ms	48ms	67ms	142ms
	04	8,323	3,090	153	0	0ms	54ms	87ms	110ms
	05	2,144	1,191	157	0	0ms	15ms	22ms	46ms
	06	7,270	1,900	129	0	0ms	46ms	68ms	108ms
	07	2,353	1,419	136	0	0ms	19ms	28ms	40ms
	08	13,434	5,824	357	0	264ms	131ms	166ms	246ms
	09	38,937	12,639	739	0	1s62ms	260ms	360ms	1h2m10s
	10	83,629	22,548	807	0	189ms	558ms	782ms	1h13m57s
	11	55,874	17,412	632	0	322ms	336ms	435ms	39m4s
	12	64,146	20,242	861	0	387ms	384ms	470ms	1h41m8s
	13	47,601	15,878	505	0	147ms	272ms	333ms	452ms
	14	35,614	12,411	452	0	905ms	184ms	235ms	747ms
	15	35,129	13,408	546	0	417ms	208ms	261ms	1h3m40s
	16	44,668	15,187	626	0	511ms	257ms	335ms	30s533ms
	17	56,109	18,876	646	0	258ms	408ms	641ms	3m8s
	18	59,446	15,758	596	0	401ms	377ms	464ms	1m47s
	19	54,562	14,413	568	0	689ms	355ms	469ms	20s669ms
	20	49,516	12,134	338	1	379ms	306ms	378ms	535ms
	21	40,787	8,471	222	0	0ms	243ms	298ms	411ms
	22	25,216	5,949	157	1	266ms	204ms	276ms	8m59s

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

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

Day	Hour	Average Duration	Average idle time
Jan 18	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

63,015 buffers Checkpoint Peak
2025-01-18 18:06:21 Date
270.054 seconds Highest write time
0.032 seconds Sync time

Checkpoints Wal files

Key values

43 files Wal files usage Peak
2025-01-18 18:06:21 Date

Checkpoints distance

Key values

1,374.60 Mo Distance Peak
2025-01-18 18:06:21 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 18	00	85,327	3,239.527s	0.03s	3,239.598s
	01	86,087	3,187.555s	0.031s	3,187.622s
	02	65,569	3,216.478s	0.043s	3,216.554s
	03	55,786	3,167.55s	0.026s	3,167.609s
	04	51,885	3,057.451s	0.028s	3,057.51s
	05	22,071	2,081.761s	0.027s	2,081.818s
	06	50,520	2,013.536s	0.024s	2,013.588s
	07	32,449	2,019.947s	0.027s	2,019.999s
	08	95,320	2,544.38s	0.028s	2,544.445s
	09	286,225	3,239.587s	0.047s	3,239.685s
	10	503,633	3,239.444s	0.069s	3,239.604s
	11	426,870	3,239.522s	0.05s	3,239.643s
	12	425,272	3,239.463s	0.056s	3,239.611s
	13	356,656	3,239.602s	0.046s	3,239.721s
	14	270,926	3,239.455s	0.049s	3,239.566s
	15	242,558	3,239.579s	0.039s	3,239.668s
	16	283,245	3,239.514s	0.047s	3,239.627s
	17	252,509	2,888.678s	0.086s	2,888.84s
	18	345,437	3,239.457s	0.059s	3,239.606s
	19	215,866	3,239.552s	0.056s	3,239.668s
	20	211,607	3,239.44s	0.045s	3,239.544s
	21	131,170	3,239.567s	0.042s	3,239.654s
	22	85,994	2,429.752s	0.028s	2,429.808s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 18	00	39	3,290	0.002s	0.012s
	01	36	3,569	0.002s	0.012s
	02	29	2,444	0.019s	0.012s
	03	26	2,429	0.002s	0.012s
	04	21	2,995	0.002s	0.012s
	05	9	3,039	0.002s	0.013s
	06	23	1,724	0.002s	0.011s
	07	14	1,912	0.002s	0.012s
	08	40	2,744	0.003s	0.012s
	09	121	4,759	0.006s	0.012s
	10	216	5,237	0.003s	0.012s
	11	185	5,340	0.003s	0.012s
	12	187	5,396	0.002s	0.012s
	13	157	5,352	0.003s	0.012s
	14	116	5,310	0.003s	0.012s
	15	103	5,395	0.004s	0.012s
	16	119	5,978	0.003s	0.012s
	17	109	5,689	0.025s	0.012s
	18	163	5,851	0.003s	0.012s
	19	88	5,459	0.009s	0.012s
	20	87	5,381	0.002s	0.012s
	21	56	4,985	0.002s	0.012s
	22	35	3,376	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Jan 18	00	52,589.25 kB	68,032.50 kB
	01	50,171.83 kB	73,874.17 kB
	02	39,092.58 kB	66,819.58 kB
	03	35,357.42 kB	48,756.50 kB
	04	29,448.33 kB	46,786.25 kB
	05	10,646.54 kB	28,584.85 kB
	06	34,489.09 kB	45,082.27 kB
	07	18,641.33 kB	55,126.08 kB
	08	54,476.50 kB	76,938.50 kB
	09	165,633.00 kB	192,533.82 kB
	10	295,742.08 kB	361,466.17 kB
	11	257,520.36 kB	329,049.55 kB
	12	252,955.27 kB	283,663.73 kB
	13	213,636.55 kB	264,787.55 kB
	14	158,518.00 kB	222,038.08 kB
	15	139,765.25 kB	179,982.08 kB
	16	160,713.91 kB	192,751.55 kB
	17	147,782.82 kB	195,377.18 kB
	18	229,018.45 kB	479,067.73 kB
	19	120,701.33 kB	243,504.58 kB
	20	118,154.58 kB	161,196.50 kB
	21	76,150.25 kB	115,774.25 kB
	22	64,232.00 kB	103,020.56 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 18	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

9,570,288 Total read queries
4,416,938 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	9,570,288	59.26%
INSERT	777,836	4.82%
UPDATE	233,976	1.45%
DELETE	9,203	0.06%
COPY FROM	2	0.00%
COPY TO	0	0.00%
CTE	26,899	0.17%
DDL	1,892	0.01%
TCL	3,367,130	20.85%
CURSOR	0	0.00%
OTHERS	2,162,915	13.39%

Queries by database

Key values

unknown Main database
16,150,141 Requests
6d12h49m10s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	16,150,141	6d12h49m10s
	copy from	2	2ms
	cte	26,899	5s537ms
	ddl	1,892	264ms
	delete	9,203	1s770ms
	insert	777,836	4m6s
	others	2,162,915	1m36s
	select	9,570,288	2d3h46m11s
	tcl	3,367,130	2m8s
	update	233,976	4d8h54m58s

Queries by user

Key values

unknown Main user
16,150,141 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	16,150,141	6d12h49m10s
	copy from	2	2ms
	cte	26,899	5s537ms
	ddl	1,892	264ms
	delete	9,203	1s770ms
	insert	777,836	4m6s
	others	2,162,915	1m36s
	select	9,570,288	2d3h46m11s
	tcl	3,367,130	2m8s
	update	233,976	4d8h54m58s

Duration by user

Key values

6d12h49m10s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	16,150,141	6d12h49m10s
	copy from	2	2ms
	cte	26,899	5s537ms
	ddl	1,892	264ms
	delete	9,203	1s770ms
	insert	777,836	4m6s
	others	2,162,915	1m36s
	select	9,570,288	2d3h46m11s
	tcl	3,367,130	2m8s
	update	233,976	4d8h54m58s

Queries by host

Key values

unknown Main host
16,150,141 Requests
6d12h49m10s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	16,150,141	6d12h49m10s
	copy from	2	2ms
	cte	26,899	5s537ms
	ddl	1,892	264ms
	delete	9,203	1s770ms
	insert	777,836	4m6s
	others	2,162,915	1m36s
	select	9,570,288	2d3h46m11s
	tcl	3,367,130	2m8s
	update	233,976	4d8h54m58s

Queries by application

Key values

unknown Main application
16,150,141 Requests
6d12h49m10s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	16,150,141	6d12h49m10s
	copy from	2	2ms
	cte	26,899	5s537ms
	ddl	1,892	264ms
	delete	9,203	1s770ms
	insert	777,836	4m6s
	others	2,162,915	1m36s
	select	9,570,288	2d3h46m11s
	tcl	3,367,130	2m8s
	update	233,976	4d8h54m58s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-18 18:58:08 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

15,229,927 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	15,229,927	94.30%
1-5ms	249,917	1.55%
5-10ms	10,361	0.06%
10-25ms	50,120	0.31%
25-50ms	124,400	0.77%
50-100ms	65,940	0.41%
100-500ms	196,592	1.22%
500-1000ms	220,849	1.37%
1000-10000ms	1,257	0.01%
> 10000ms	778	0.00%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = 'b43e96e97487b034a0d6f14c632f38da20669e16', last_update = '2025-01-18 20:12:11.315921', exp_date = '2025-01-18 20:57:11.315925', logged_in = 'TRUE' where id = 1026; [ Date: 2025-01-18 22:12:11 ]
2	1h	update res_users set sid = 'b43e96e97487b034a0d6f14c632f38da20669e16', last_update = '2025-01-18 20:12:11.315799', exp_date = '2025-01-18 20:57:11.315803', logged_in = 'TRUE' where id = 1026; [ Date: 2025-01-18 22:12:11 ]
3	59m58s	update res_users set sid = '1276f4556365ef9e13826bed60fa691faf3dfbe7', last_update = '2025-01-17 22:52:37.837469', exp_date = '2025-01-17 23:37:37.837473', logged_in = 'TRUE' where id = 1390; [ Date: 2025-01-18 00:52:36 ]
4	56m56s	UPDATE "res_users" SET "exp_date" = '2025-01-18 08:19:25.035892', "last_update" = '2025-01-18 07:34:25.035915', "write_date" = '2025-01-18 07:34:24.712932', "write_uid" = 1 WHERE id IN (1423); [ Date: 2025-01-18 09:31:21 ]
5	56m20s	update res_users set sid = 'bbd7829faf33ce65cf41608d2464766d3f7d61fa', last_update = '2025-01-18 07:35:01.213167', exp_date = '2025-01-18 08:20:01.213170', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-18 09:31:21 ]
6	55m49s	update res_users set sid = 'bbd7829faf33ce65cf41608d2464766d3f7d61fa', last_update = '2025-01-18 07:35:32.089187', exp_date = '2025-01-18 08:20:32.089191', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-18 09:31:21 ]
7	55m2s	update res_users set sid = 'bbd7829faf33ce65cf41608d2464766d3f7d61fa', last_update = '2025-01-18 07:36:18.400148', exp_date = '2025-01-18 08:21:18.400150', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-18 09:31:21 ]
8	54m58s	update res_users set sid = 'bbd7829faf33ce65cf41608d2464766d3f7d61fa', last_update = '2025-01-18 07:36:22.689009', exp_date = '2025-01-18 08:21:22.689012', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-18 09:31:21 ]
9	54m28s	update res_users set sid = 'bbd7829faf33ce65cf41608d2464766d3f7d61fa', last_update = '2025-01-18 07:36:52.312557', exp_date = '2025-01-18 08:21:52.312560', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-18 09:31:21 ]
10	52m49s	update res_users set sid = '4083b2f226fe1cfb660f82b92e442c394332d393', last_update = '2025-01-18 16:45:31.697314', exp_date = '2025-01-18 17:30:31.697317', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-18 18:38:20 ]
11	52m49s	update res_users set sid = '4083b2f226fe1cfb660f82b92e442c394332d393', last_update = '2025-01-18 16:45:31.697086', exp_date = '2025-01-18 17:30:31.697089', logged_in = 'TRUE' where id = 905; [ Date: 2025-01-18 18:38:20 ]
12	51m38s	update res_users set sid = 'bbd7829faf33ce65cf41608d2464766d3f7d61fa', last_update = '2025-01-18 07:39:42.753603', exp_date = '2025-01-18 08:24:42.753605', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-18 09:31:21 ]
13	48m18s	UPDATE "res_users" SET "exp_date" = '2025-01-18 17:35:02.359714', "last_update" = '2025-01-18 16:50:02.359749', "sid" = '3de2e2ae47ecaeb5f5f66c991202678080d738af', "write_date" = '2025-01-18 16:50:01.974861', "write_uid" = 1 WHERE id IN (905); [ Date: 2025-01-18 18:38:20 ]
14	47m43s	update res_users set sid = 'bbd7829faf33ce65cf41608d2464766d3f7d61fa', last_update = '2025-01-18 07:43:37.865169', exp_date = '2025-01-18 08:28:37.865173', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-18 09:31:21 ]
15	45m52s	UPDATE "res_users" SET "exp_date" = '2025-01-18 17:37:28.111030', "last_update" = '2025-01-18 16:52:28.111051', "sid" = '3de2e2ae47ecaeb5f5f66c991202678080d738af', "write_date" = '2025-01-18 16:52:27.760109', "write_uid" = 1 WHERE id IN (905); [ Date: 2025-01-18 18:38:20 ]
16	41m59s	update res_users set sid = 'b383d702f7f311211a012bcc540f9b0c30eeacd3', last_update = '2025-01-18 12:50:21.315386', exp_date = '2025-01-18 13:35:21.315390', logged_in = 'TRUE' where id = 835; [ Date: 2025-01-18 14:32:20 ]
17	41m59s	update res_users set sid = 'b383d702f7f311211a012bcc540f9b0c30eeacd3', last_update = '2025-01-18 12:50:21.314379', exp_date = '2025-01-18 13:35:21.314382', logged_in = 'TRUE' where id = 835; [ Date: 2025-01-18 14:32:20 ]
18	41m51s	update res_users set sid = 'b383d702f7f311211a012bcc540f9b0c30eeacd3', last_update = '2025-01-18 12:50:29.542353', exp_date = '2025-01-18 13:35:29.542357', logged_in = 'TRUE' where id = 835; [ Date: 2025-01-18 14:32:20 ]
19	41m25s	update res_users set sid = '86d07bb14fa13de484ce93dfa0b7cfbe40627423', last_update = '2025-01-18 12:50:54.576602', exp_date = '2025-01-18 13:35:54.576606', logged_in = 'TRUE' where id = 835; [ Date: 2025-01-18 14:32:20 ]
20	41m24s	update res_users set sid = '86d07bb14fa13de484ce93dfa0b7cfbe40627423', last_update = '2025-01-18 12:50:55.849530', exp_date = '2025-01-18 13:35:55.849532', logged_in = 'TRUE' where id = 835; [ Date: 2025-01-18 14:32:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d22h56m42s

58,873

Details

0ms

1h

5s805ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 18	00	633	59m58s	5s684ms
	01	963	22s465ms	23ms
	02	760	165ms	0ms
	03	393	17s643ms	44ms
	04	783	158ms	0ms
	05	177	40ms	0ms
	06	378	82ms	0ms
	07	326	70ms	0ms
	08	1,284	1h18m32s	3s670ms
	09	3,926	12h37m53s	11s582ms
	10	6,858	5h36m7s	2s940ms
	11	6,321	6h36m29s	3s763ms
	12	6,365	9h9m37s	5s181ms
	13	4,906	2h36m16s	1s911ms
	14	3,898	12h11m18s	11s256ms
	15	4,734	5h29m47s	4s179ms
	16	3,792	8h35m20s	8s154ms
	17	3,510	5h21m43s	5s499ms
	18	2,851	6h34m51s	8s309ms
	19	2,386	9h20m14s	14s88ms
	20	1,848	6h17m47s	12s265ms
	21	1,081	280ms	0ms
	22	700	2h10m1s	11s145ms

update res_users set sid = 'b43e96e97487b034a0d6f14c632f38da20669e16', last_update = '2025-01-18 20:12:11.315921', exp_date = '2025-01-18 20:57:11.315925', logged_in = 'TRUE' where id = 1026;

Date: 2025-01-18 22:12:11 Duration: 1h
update res_users set sid = 'b43e96e97487b034a0d6f14c632f38da20669e16', last_update = '2025-01-18 20:12:11.315799', exp_date = '2025-01-18 20:57:11.315803', logged_in = 'TRUE' where id = 1026;

Date: 2025-01-18 22:12:11 Duration: 1h
update res_users set sid = '1276f4556365ef9e13826bed60fa691faf3dfbe7', last_update = '2025-01-17 22:52:37.837469', exp_date = '2025-01-17 23:37:37.837473', logged_in = 'TRUE' where id = 1390;

Date: 2025-01-18 00:52:36 Duration: 59m58s

2

1d4h25m48s

180,091

Details

353ms

3s44ms

568ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 18	00	6,716	1h1m6s	545ms
	01	5,202	47m31s	548ms
	02	4,088	36m36s	537ms
	03	3,024	26m52s	533ms
	04	2,607	23m48s	548ms
	05	466	4m7s	531ms
	06	2,499	21m59s	527ms
	07	815	7m11s	529ms
	08	4,946	44m9s	535ms
	09	10,245	1h35m41s	560ms
	10	22,830	4h2m25s	637ms
	11	13,173	2h7m23s	580ms
	12	13,808	2h11m50s	572ms
	13	9,380	1h27m49s	561ms
	14	5,208	47m54s	551ms
	15	5,911	55m8s	559ms
	16	8,084	1h16m31s	567ms
	17	10,563	1h39m59s	567ms
	18	13,870	2h8m43s	556ms
	19	11,731	1h50m6s	563ms
	20	10,593	1h38m19s	556ms
	21	9,414	1h26m13s	549ms
	22	4,918	44m17s	540ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4420374)) AND (("shipping_track"."id" not in (36484696, 36486419, 36487112, 36496474, 36496648, 36496813, 36521867, 36915615, 37727094, 37727094)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:19:14 Duration: 3s44ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4567983)) AND (("shipping_track"."id" not in (37697829, 37697971, 37730816, 37730816)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:29:03 Duration: 2s22ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4567433)) AND (("shipping_track"."id" not in (37693644, 37693910, 37693953, 37730751, 37730751)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:28:57 Duration: 1s993ms

3

8h31m33s

316

Details

0ms

48m18s

1m37s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2	2ms	1ms
	01	4	3ms	0ms
	02	3	31m23s	10m27s
	03	1	0ms	0ms
	04	2	0ms	0ms
	05	2	0ms	0ms
	06	1	0ms	0ms
	07	2	0ms	0ms
	08	17	18ms	1ms
	09	35	1h50m8s	3m8s
	10	23	32ms	1ms
	11	22	29ms	1ms
	12	32	40ms	1ms
	13	19	18ms	0ms
	14	19	12ms	0ms
	15	23	1m13s	3s195ms
	16	16	10ms	0ms
	17	19	23s614ms	1s242ms
	18	21	1h47m24s	5m6s
	19	28	3h58m19s	8m30s
	20	15	13m40s	54s724ms
	21	6	5ms	0ms
	22	4	8m59s	2m14s

UPDATE "res_users" SET "exp_date" = '2025-01-18 17:35:02.359714', "last_update" = '2025-01-18 16:50:02.359749', "sid" = '3de2e2ae47ecaeb5f5f66c991202678080d738af', "write_date" = '2025-01-18 16:50:01.974861', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-18 18:38:20 Duration: 48m18s
UPDATE "res_users" SET "exp_date" = '2025-01-18 17:37:28.111030', "last_update" = '2025-01-18 16:52:28.111051', "sid" = '3de2e2ae47ecaeb5f5f66c991202678080d738af', "write_date" = '2025-01-18 16:52:27.760109', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-18 18:38:20 Duration: 45m52s
UPDATE "res_users" SET "exp_date" = '2025-01-18 08:37:51.261085', "last_update" = '2025-01-18 07:52:51.261119', "sid" = '5890d01b70c81c797b80a52ec04c32b13ea6f992', "write_date" = '2025-01-18 07:52:50.933621', "write_uid" = 1 WHERE id IN (1423);

Date: 2025-01-18 09:31:21 Duration: 38m29s

4

6h10m37s

38,434

Details

367ms

5s154ms

578ms

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
Jan 18	00	189	1m52s	596ms
	01	154	1m35s	618ms
	02	118	1m12s	616ms
	03	206	1m57s	571ms
	04	300	2m47s	559ms
	05	160	1m26s	540ms
	06	71	42s304ms	595ms
	07	229	2m2s	536ms
	08	982	8m57s	546ms
	09	3,341	32m4s	575ms
	10	4,748	52m48s	667ms
	11	3,784	37m22s	592ms
	12	4,314	42m14s	587ms
	13	2,671	25m46s	579ms
	14	2,332	21m33s	554ms
	15	1,793	16m52s	564ms
	16	2,862	26m50s	562ms
	17	2,647	24m30s	555ms
	18	2,618	23m45s	544ms
	19	2,161	19m35s	544ms
	20	1,413	12m41s	539ms
	21	944	8m22s	532ms
	22	397	3m31s	533ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4557739, 4551907, 4551877, 4551874, 4551861, 4548992, 4544011, 4543736, 4541434, 4540621, 4538526, 4538522, 4538055, 4537996, 4536859, 4533696, 4533689, 4531338, 4529921, 4518660, 4517708, 4517415, 4504914, 4504894, 4504240, 4503885, 4503873)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:11:22 Duration: 5s154ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4559449, 4559446, 4559443, 4559442)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:00:21 Duration: 4s55ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4090983)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:00:21 Duration: 3s691ms

5

3h4m46s

47,696

Details

93ms

857ms

232ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,296	7m58s	208ms
	01	1,694	6m1s	213ms
	02	746	2m44s	220ms
	03	250	52s654ms	210ms
	04	1,102	4m13s	230ms
	05	60	16s820ms	280ms
	06	6	1s825ms	304ms
	07	44	11s687ms	265ms
	08	2	278ms	139ms
	09	270	54s744ms	202ms
	10	188	50s263ms	267ms
	11	394	1m45s	268ms
	12	102	26s34ms	255ms
	13	510	1m57s	230ms
	14	856	3m5s	216ms
	15	1,494	5m48s	233ms
	16	2,788	10m25s	224ms
	17	5,290	20m26s	231ms
	18	6,448	26m36s	247ms
	19	6,806	27m35s	243ms
	20	7,394	28m57s	234ms
	21	5,956	22m40s	228ms
	22	3,000	10m57s	219ms

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

Date: 2025-01-18 18:18:05 Duration: 857ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'اسلام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-18 18:18:05 Duration: 857ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبد الرحمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-18 17:22:36 Duration: 856ms

6

2h24m19s

43,402

Details

166ms

438ms

199ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,243	3m53s	187ms
	01	1,319	4m7s	187ms
	02	715	2m13s	186ms
	03	1,378	4m17s	186ms
	04	500	1m33s	186ms
	05	489	1m32s	188ms
	06	1,182	3m42s	188ms
	07	618	1m56s	188ms
	08	2,840	8m58s	189ms
	09	2,257	7m43s	205ms
	10	6,524	24m25s	224ms
	11	3,643	12m8s	200ms
	12	3,073	10m27s	204ms
	13	3,751	12m13s	195ms
	14	1,417	4m32s	192ms
	15	2,459	7m53s	192ms
	16	2,342	7m35s	194ms
	17	4,753	15m25s	194ms
	18	1,468	4m51s	198ms
	19	1,215	4m5s	202ms
	20	143	27s178ms	190ms
	21	19	3s578ms	188ms
	22	54	9s921ms	183ms

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

Date: 2025-01-18 10:11:16 Duration: 438ms
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" = '9974356')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:25 Duration: 404ms
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" = '9876897')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:18 Duration: 395ms

7

2h17m30s

9,358

Details

31ms

1s258ms

881ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	265	3m52s	878ms
	01	206	2m58s	868ms
	09	8	4s569ms	571ms
	10	23	22s751ms	989ms
	11	37	36s394ms	983ms
	12	18	15s447ms	858ms
	13	26	24s581ms	945ms
	14	142	2m7s	900ms
	15	306	4m34s	897ms
	16	500	7m35s	911ms
	17	919	13m59s	913ms
	18	1,806	25m33s	848ms
	19	1,369	19m45s	866ms
	20	1,394	20m51s	897ms
	21	1,755	25m50s	883ms
	22	584	8m35s	883ms

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

Date: 2025-01-18 19:47:31 Duration: 1s258ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9988145')) 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 (19))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-18 18:46:06 Duration: 1s233ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9939639')) 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 (41))))))) 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 (41)))))) 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 (41)))))) 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 (41))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-18 17:25:10 Duration: 1s228ms

8

1h30m15s

120,690

Details

34ms

250ms

44ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,859	2m	42ms
	01	1,826	1m17s	42ms
	02	1,312	55s338ms	42ms
	03	1,107	46s877ms	42ms
	04	820	34s974ms	42ms
	05	322	13s870ms	43ms
	06	1,003	42s441ms	42ms
	07	437	18s813ms	43ms
	08	1,534	1m5s	42ms
	09	7,907	5m50s	44ms
	10	15,951	13m14s	49ms
	11	11,174	8m25s	45ms
	12	11,227	8m23s	44ms
	13	7,948	5m49s	43ms
	14	4,386	3m8s	42ms
	15	4,933	3m33s	43ms
	16	5,923	4m15s	43ms
	17	7,092	5m17s	44ms
	18	9,446	7m3s	44ms
	19	7,394	5m31s	44ms
	20	6,285	4m37s	44ms
	21	6,527	4m47s	44ms
	22	3,277	2m21s	43ms

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

Date: 2025-01-18 10:11:17 Duration: 250ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4420374)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-18 10:19:11 Duration: 250ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4561723)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-18 11:45:46 Duration: 237ms

9

1h15m10s

34

Details

0ms

56m56s

2m12s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 18	01	2	1ms	0ms
	02	2	0ms	0ms
	08	4	7m49s	1m57s
	09	3	56m56s	18m58s
	10	4	5ms	1ms
	11	1	1ms	1ms
	12	2	1ms	0ms
	13	2	2ms	1ms
	14	3	2ms	0ms
	15	6	10m24s	1m44s
	16	2	0ms	0ms
	18	2	0ms	0ms
	20	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-18 08:19:25.035892', "last_update" = '2025-01-18 07:34:25.035915', "write_date" = '2025-01-18 07:34:24.712932', "write_uid" = 1 WHERE id IN (1423);

Date: 2025-01-18 09:31:21 Duration: 56m56s
UPDATE "res_users" SET "exp_date" = '2025-01-18 15:13:12.335528', "last_update" = '2025-01-18 14:28:12.335548', "write_date" = '2025-01-18 14:28:12.007202', "write_uid" = 1 WHERE id IN (1411);

Date: 2025-01-18 15:36:21 Duration: 8m8s
UPDATE "res_users" SET "exp_date" = '2025-01-18 08:08:31.244708', "last_update" = '2025-01-18 07:23:31.244725', "write_date" = '2025-01-18 07:23:30.926708', "write_uid" = 1423 WHERE id IN (1423);

Date: 2025-01-18 08:31:21 Duration: 7m49s

10

1h3m26s

14,816

Details

211ms

523ms

256ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 18	00	898	3m51s	257ms
	01	656	2m51s	261ms
	02	378	1m34s	250ms
	03	125	30s638ms	245ms
	04	554	2m17s	248ms
	05	30	7s512ms	250ms
	06	6	1s469ms	244ms
	07	22	5s570ms	253ms
	08	1	275ms	275ms
	09	134	35s172ms	262ms
	10	76	22s683ms	298ms
	11	165	45s892ms	278ms
	12	34	9s877ms	290ms
	13	240	1m4s	267ms
	14	304	1m13s	242ms
	15	460	1m56s	252ms
	16	920	3m59s	260ms
	17	1,761	7m56s	270ms
	18	1,450	6m12s	256ms
	19	2,068	8m48s	255ms
	20	2,343	9m59s	255ms
	21	1,254	5m14s	250ms
	22	937	3m46s	241ms

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

Date: 2025-01-18 17:21:55 Duration: 523ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9608066')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

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

Date: 2025-01-18 17:54:02 Duration: 403ms

11

40m54s

12,343

Details

168ms

413ms

198ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 18	00	81	15s339ms	189ms
	01	106	20s25ms	188ms
	02	2	372ms	186ms
	05	481	1m30s	189ms
	06	1,140	3m35s	189ms
	07	596	1m52s	189ms
	08	1,183	3m44s	189ms
	09	1,381	4m36s	200ms
	10	1,126	4m19s	230ms
	11	1,338	4m30s	202ms
	12	1,131	3m50s	203ms
	13	1,483	4m53s	198ms
	14	195	37s711ms	193ms
	15	485	1m33s	193ms
	16	288	56s828ms	197ms
	17	872	2m50s	195ms
	19	322	1m	186ms
	20	66	12s550ms	190ms
	21	19	3s605ms	189ms
	22	48	8s897ms	185ms

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" = '9877926')) 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 (39, 115)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:11:16 Duration: 413ms
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" = '9904546')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:25 Duration: 382ms
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" = '8974134')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:17 Duration: 375ms

12

35m42s

7,811

Details

191ms

624ms

274ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	08	236	59s467ms	251ms
	09	301	1m19s	264ms
	10	1,105	5m30s	298ms
	11	828	3m57s	286ms
	12	399	1m47s	269ms
	13	1,010	4m37s	274ms
	14	461	2m4s	269ms
	15	770	3m14s	252ms
	16	1,169	5m2s	258ms
	17	842	3m48s	270ms
	18	344	1m35s	277ms
	19	346	1m45s	306ms

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

Date: 2025-01-18 10:15:27 Duration: 624ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9821080')))) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:15:30 Duration: 597ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9821662')))) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:15:34 Duration: 586ms

13

31m33s

16,484

Details

95ms

782ms

114ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1	113ms	113ms
	01	325	34s947ms	107ms
	03	29	3s364ms	116ms
	04	22	2s525ms	114ms
	05	25	2s890ms	115ms
	06	1	117ms	117ms
	08	265	30s206ms	113ms
	09	832	1m38s	118ms
	10	1,516	3m20s	132ms
	11	1,137	2m14s	117ms
	12	2,201	4m16s	116ms
	13	2,172	4m2s	111ms
	14	1,628	2m58s	109ms
	15	1,575	2m53s	110ms
	16	1,259	2m22s	113ms
	17	1,077	2m3s	114ms
	18	759	1m25s	112ms
	19	668	1m16s	114ms
	20	329	36s748ms	111ms
	21	148	16s405ms	110ms
	22	515	54s817ms	106ms

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

Date: 2025-01-18 10:11:18 Duration: 782ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7988566)) AND (("cash_track"."id" not in (6996685, 7004182, 7006464, 7072359, 7072359)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-18 10:00:18 Duration: 453ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7999387)) AND (("cash_track"."id" not in (7073378)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-18 10:29:01 Duration: 227ms

14

30m12s

31,282

Details

38ms

327ms

57ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	10	530ms	53ms
	01	8	420ms	52ms
	03	28	1s512ms	54ms
	04	41	2s138ms	52ms
	05	42	2s285ms	54ms
	06	5	262ms	52ms
	07	14	742ms	53ms
	08	377	19s642ms	52ms
	09	1,484	1m21s	54ms
	10	4,582	4m34s	59ms
	11	2,247	2m	53ms
	12	1,891	1m45s	55ms
	13	1,912	1m43s	54ms
	14	1,768	1m32s	52ms
	15	1,991	1m45s	52ms
	16	2,461	2m9s	52ms
	17	4,164	4m11s	60ms
	18	6,142	6m26s	62ms
	19	1,573	1m40s	63ms
	20	306	19s569ms	63ms
	21	150	9s345ms	62ms
	22	86	5s348ms	62ms

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

Date: 2025-01-18 10:00:14 Duration: 327ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4436269) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:00:14 Duration: 301ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4307160) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:28:55 Duration: 205ms

15

22m46s

6,504

Details

167ms

422ms

210ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2	388ms	194ms
	04	291	54s620ms	187ms
	07	22	4s136ms	188ms
	08	315	1m	192ms
	09	228	50s711ms	222ms
	10	2,711	10m15s	226ms
	11	507	1m39s	196ms
	12	400	1m23s	209ms
	13	189	36s890ms	195ms
	14	173	33s584ms	194ms
	15	87	16s926ms	194ms
	16	180	35s241ms	195ms
	17	553	1m49s	198ms
	18	568	1m51s	195ms
	19	201	39s703ms	197ms
	20	77	14s653ms	190ms

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

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

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

Date: 2025-01-18 10:00:18 Duration: 356ms

16

13m52s

5,663

Details

120ms

713ms

147ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 18	00	35	4s547ms	129ms
	07	11	1s466ms	133ms
	08	56	7s596ms	135ms
	09	391	55s364ms	141ms
	10	1,198	3m15s	162ms
	11	1,281	3m4s	144ms
	12	1,058	2m31s	142ms
	13	645	1m29s	138ms
	14	150	20s188ms	134ms
	15	251	34s271ms	136ms
	16	146	19s867ms	136ms
	17	125	19s682ms	157ms
	18	76	12s221ms	160ms
	19	87	13s718ms	157ms
	20	102	15s612ms	153ms
	21	24	3s641ms	151ms
	22	27	4s38ms	149ms

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: 2025-01-18 10:28:57 Duration: 713ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 123)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-18 10:19:06 Duration: 332ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-18 10:29:04 Duration: 322ms

17

13m44s

4,354

Details

163ms

216ms

189ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,160	3m41s	190ms
	01	1,213	3m50s	190ms
	02	713	2m14s	188ms
	03	1,045	3m16s	188ms
	04	209	39s28ms	186ms
	05	8	1s467ms	183ms
	22	6	1s92ms	182ms

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" = '9851766')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 00:27:15 Duration: 216ms
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" = '9925203')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-18 01:24:26 Duration: 215ms

18

12m40s

2,907

Details

179ms

364ms

261ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 18	08	129	32s17ms	248ms
	09	24	6s446ms	268ms
	10	407	1m59s	293ms
	11	353	1m28s	251ms
	12	78	19s950ms	255ms
	13	133	33s776ms	253ms
	14	191	47s713ms	249ms
	15	93	23s38ms	247ms
	16	188	47s724ms	253ms
	17	544	2m21s	260ms
	18	566	2m27s	261ms
	19	201	52s495ms	261ms

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

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

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

Date: 2025-01-18 10:20:52 Duration: 353ms

19

11m26s

2,726

Details

202ms

515ms

251ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 18	00	120	29s540ms	246ms
	01	120	29s632ms	246ms
	02	120	29s452ms	245ms
	03	120	29s338ms	244ms
	04	120	29s262ms	243ms
	05	120	29s677ms	247ms
	06	120	29s517ms	245ms
	07	120	29s246ms	243ms
	08	120	29s610ms	246ms
	09	120	30s855ms	257ms
	10	120	35s255ms	293ms
	11	120	32s168ms	268ms
	12	120	31s886ms	265ms
	13	120	30s875ms	257ms
	14	120	29s988ms	249ms
	15	120	30s239ms	251ms
	16	120	30s682ms	255ms
	17	116	29s471ms	254ms
	18	120	30s456ms	253ms
	19	120	29s851ms	248ms
	20	120	29s103ms	242ms
	21	120	29s176ms	243ms
	22	90	21s548ms	239ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-18 10:29:02 Duration: 515ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-18 10:17:02 Duration: 441ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-18 10:29:02 Duration: 441ms

20

10m1s

224

Details

24ms

4s141ms

2s683ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	01	4	11s825ms	2s956ms
	08	1	939ms	939ms
	09	4	12s860ms	3s215ms
	10	2	7s824ms	3s912ms
	11	6	9s472ms	1s578ms
	12	10	20s593ms	2s59ms
	13	3	3s209ms	1s69ms
	14	25	49s196ms	1s967ms
	15	14	42s219ms	3s15ms
	16	27	1m11s	2s632ms
	17	26	1m9s	2s663ms
	18	54	2m34s	2s852ms
	19	12	41s404ms	3s450ms
	20	20	59s373ms	2s968ms
	21	12	35s974ms	2s997ms
	22	4	11s910ms	2s977ms

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 (53))))))) 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 (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%9836374%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-18 19:47:33 Duration: 4s141ms
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 (49))))))) 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 (49)))))) 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 (49)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) 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 (49))))))))) 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 (49)))))))) AND ("policy_number"."name"::text ilike '%9042298%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-18 19:52:15 Duration: 4s89ms
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 (53))))))) 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 (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%98363%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-18 19:47:33 Duration: 4s56ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,161,553

Details

1m36s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 18	00	28,268	1s215ms	0ms
	01	33,636	1s467ms	0ms
	02	25,531	1s33ms	0ms
	03	19,777	804ms	0ms
	04	19,638	848ms	0ms
	05	11,616	408ms	0ms
	06	17,783	741ms	0ms
	07	20,993	825ms	0ms
	08	54,877	2s286ms	0ms
	09	139,743	5s990ms	0ms
	10	196,514	9s622ms	0ms
	11	189,966	8s229ms	0ms
	12	204,892	8s594ms	0ms
	13	177,313	8s281ms	0ms
	14	154,675	6s377ms	0ms
	15	168,139	6s548ms	0ms
	16	158,773	7s147ms	0ms
	17	136,630	6s451ms	0ms
	18	126,453	6s671ms	0ms
	19	103,855	4s633ms	0ms
	20	82,803	4s36ms	0ms
	21	54,890	2s659ms	0ms
	22	34,788	1s671ms	0ms

DISCARD ALL;

Date: 2025-01-18 17:54:01 Duration: 1ms
DISCARD ALL;

Date: 2025-01-18 11:01:46 Duration: 1ms
DISCARD ALL;

Date: 2025-01-18 09:33:18 Duration: 1ms

2

1,684,041

Details

22s951ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 18	00	21,598	316ms	0ms
	01	26,058	375ms	0ms
	02	19,085	269ms	0ms
	03	15,057	229ms	0ms
	04	15,640	238ms	0ms
	05	8,651	137ms	0ms
	06	13,863	215ms	0ms
	07	16,250	235ms	0ms
	08	43,238	594ms	0ms
	09	113,792	1s459ms	0ms
	10	161,032	2s348ms	0ms
	11	150,981	1s923ms	0ms
	12	163,064	2s60ms	0ms
	13	136,678	1s858ms	0ms
	14	116,528	1s412ms	0ms
	15	128,409	1s509ms	0ms
	16	119,443	1s515ms	0ms
	17	106,104	1s501ms	0ms
	18	98,708	1s534ms	0ms
	19	79,900	1s182ms	0ms
	20	63,886	971ms	0ms
	21	40,737	650ms	0ms
	22	25,339	411ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-18 18:13:48 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-18 11:47:44 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-18 19:43:31 Duration: 0ms

3

1,103,601

Details

10s472ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 18	00	14,831	136ms	0ms
	01	17,507	155ms	0ms
	02	13,428	109ms	0ms
	03	10,543	90ms	0ms
	04	10,510	93ms	0ms
	05	6,466	54ms	0ms
	06	9,515	85ms	0ms
	07	11,178	95ms	0ms
	08	28,330	253ms	0ms
	09	71,230	673ms	0ms
	10	99,713	1s84ms	0ms
	11	96,412	935ms	0ms
	12	103,751	979ms	0ms
	13	89,901	839ms	0ms
	14	78,545	663ms	0ms
	15	85,407	731ms	0ms
	16	80,701	714ms	0ms
	17	69,424	691ms	0ms
	18	64,359	666ms	0ms
	19	53,042	530ms	0ms
	20	42,389	428ms	0ms
	21	28,323	279ms	0ms
	22	18,096	178ms	0ms

ROLLBACK;

Date: 2025-01-18 13:36:32 Duration: 1ms
ROLLBACK;

Date: 2025-01-18 09:25:06 Duration: 0ms
ROLLBACK;

Date: 2025-01-18 11:08:48 Duration: 0ms

4

1,090,259

Details

3m1s

0ms

17ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 18	00	14,182	2s381ms	0ms
	01	16,815	2s670ms	0ms
	02	12,798	1s837ms	0ms
	03	9,936	1s457ms	0ms
	04	9,829	1s455ms	0ms
	05	5,859	692ms	0ms
	06	8,925	1s270ms	0ms
	07	10,568	1s380ms	0ms
	08	27,694	4s397ms	0ms
	09	70,838	11s647ms	0ms
	10	99,314	18s80ms	0ms
	11	95,895	15s861ms	0ms
	12	103,217	16s917ms	0ms
	13	89,556	13s982ms	0ms
	14	78,232	10s854ms	0ms
	15	84,632	11s970ms	0ms
	16	79,942	11s757ms	0ms
	17	68,914	13s2ms	0ms
	18	63,741	12s515ms	0ms
	19	52,313	10s270ms	0ms
	20	41,801	8s232ms	0ms
	21	27,696	5s436ms	0ms
	22	17,562	3s272ms	0ms

SELECT payload FROM http_sessions WHERE sid = '8ef97d6df954869737e02f8cfe28232c7a61c186';

Date: 2025-01-18 19:46:26 Duration: 17ms
SELECT payload FROM http_sessions WHERE sid = '8f3ac894c9e8f6f6f52556d765440bdb4c5703b1';

Date: 2025-01-18 11:57:41 Duration: 14ms
SELECT payload FROM http_sessions WHERE sid = '3909c354e73d66343ea503e406041fb31861c5ac';

Date: 2025-01-18 10:52:59 Duration: 14ms

5

1,080,609

Details

1m32s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 18	00	14,202	1s194ms	0ms
	01	16,861	1s355ms	0ms
	02	12,834	952ms	0ms
	03	9,971	784ms	0ms
	04	9,882	793ms	0ms
	05	5,867	413ms	0ms
	06	8,967	702ms	0ms
	07	10,568	772ms	0ms
	08	27,412	2s226ms	0ms
	09	69,789	5s865ms	0ms
	10	98,158	9s234ms	0ms
	11	94,929	8s188ms	0ms
	12	102,299	8s672ms	0ms
	13	88,614	7s498ms	0ms
	14	77,294	5s839ms	0ms
	15	83,991	6s522ms	0ms
	16	79,308	6s88ms	0ms
	17	68,269	6s335ms	0ms
	18	63,190	5s976ms	0ms
	19	51,874	4s612ms	0ms
	20	41,419	3s907ms	0ms
	21	27,479	2s506ms	0ms
	22	17,432	1s562ms	0ms

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

Date: 2025-01-18 13:59:57 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-18 22:29:06 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-18 16:26:19 Duration: 0ms

6

742,919

Details

1m45s

0ms

9ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 18	00	8,072	1s390ms	0ms
	01	10,471	1s665ms	0ms
	02	6,929	1s218ms	0ms
	03	5,237	942ms	0ms
	04	5,849	1s39ms	0ms
	05	2,304	510ms	0ms
	06	5,391	942ms	0ms
	07	5,957	1s	0ms
	08	18,719	2s689ms	0ms
	09	55,491	7s410ms	0ms
	10	79,382	12s238ms	0ms
	11	71,166	9s778ms	0ms
	12	76,073	10s186ms	0ms
	13	60,719	8s572ms	0ms
	14	49,484	6s365ms	0ms
	15	55,489	6s890ms	0ms
	16	50,032	6s620ms	0ms
	17	46,965	6s585ms	0ms
	18	44,353	6s740ms	0ms
	19	33,947	4s749ms	0ms
	20	26,814	3s960ms	0ms
	21	15,168	2s419ms	0ms
	22	8,907	1s466ms	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 (876);

Date: 2025-01-18 17:21:52 Duration: 9ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."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 (866);

Date: 2025-01-18 17:21:52 Duration: 9ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."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 (823);

Date: 2025-01-18 17:21:52 Duration: 9ms

7

579,479

Details

1m35s

0ms

40ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 18	00	6,772	1s288ms	0ms
	01	8,531	1s538ms	0ms
	02	5,673	1s44ms	0ms
	03	4,515	949ms	0ms
	04	5,130	1s107ms	0ms
	05	2,185	365ms	0ms
	06	4,348	827ms	0ms
	07	5,072	567ms	0ms
	08	14,859	2s114ms	0ms
	09	42,465	6s305ms	0ms
	10	61,169	11s653ms	0ms
	11	54,471	8s898ms	0ms
	12	59,159	9s454ms	0ms
	13	46,761	7s612ms	0ms
	14	37,940	5s802ms	0ms
	15	42,913	6s207ms	0ms
	16	38,713	5s820ms	0ms
	17	36,602	6s333ms	0ms
	18	34,305	5s613ms	0ms
	19	26,786	4s641ms	0ms
	20	21,470	3s805ms	0ms
	21	12,388	2s116ms	0ms
	22	7,252	1s361ms	0ms

COMMIT;

Date: 2025-01-18 19:47:31 Duration: 40ms
COMMIT;

Date: 2025-01-18 10:17:06 Duration: 37ms
COMMIT;

Date: 2025-01-18 10:18:00 Duration: 31ms

8

460,694

Details

27s473ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	4,148	231ms	0ms
	01	5,149	269ms	0ms
	02	3,242	153ms	0ms
	03	2,245	115ms	0ms
	04	3,330	188ms	0ms
	05	1,082	53ms	0ms
	06	3,297	156ms	0ms
	07	3,572	164ms	0ms
	08	10,814	580ms	0ms
	09	33,605	1s909ms	0ms
	10	48,793	3s557ms	0ms
	11	44,217	2s692ms	0ms
	12	45,864	2s788ms	0ms
	13	36,856	2s138ms	0ms
	14	30,201	1s565ms	0ms
	15	33,235	1s794ms	0ms
	16	32,015	1s687ms	0ms
	17	31,390	1s942ms	0ms
	18	29,679	1s983ms	0ms
	19	22,544	1s385ms	0ms
	20	18,092	1s121ms	0ms
	21	11,089	633ms	0ms
	22	6,235	359ms	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 (27);

Date: 2025-01-18 11:16:22 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 (67, 11, 5, 8);

Date: 2025-01-18 16:09:20 Duration: 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 (11, 17, 51, 4, 8, 39, 75, 13, 35, 22, 78, 26, 7, 76, 28, 27, 5, 1, 111, 9, 64, 6, 73, 46, 113, 102, 19, 67, 38, 24, 85, 65, 48, 30, 77, 60, 128, 115, 41, 44, 49, 66, 3, 32, 42, 10, 71, 123, 2, 16, 14, 127, 79, 70, 61, 36);

Date: 2025-01-18 16:46:02 Duration: 0ms

9

450,319

Details

58s111ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	5,450	615ms	0ms
	01	6,608	647ms	0ms
	02	4,234	415ms	0ms
	03	2,546	279ms	0ms
	04	3,004	315ms	0ms
	05	805	73ms	0ms
	06	3,329	368ms	0ms
	07	2,495	295ms	0ms
	08	9,859	1s305ms	0ms
	09	33,878	4s345ms	0ms
	10	46,948	7s230ms	0ms
	11	41,469	5s360ms	0ms
	12	42,625	5s527ms	0ms
	13	34,934	4s210ms	0ms
	14	28,809	3s163ms	0ms
	15	32,983	3s999ms	0ms
	16	30,636	3s415ms	0ms
	17	30,354	3s849ms	0ms
	18	30,954	5s892ms	0ms
	19	23,396	2s836ms	0ms
	20	18,496	2s206ms	0ms
	21	10,405	1s126ms	0ms
	22	6,102	630ms	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 (5099788, 5100494, 5103563, 5099916, 5099224, 5099305, 5144767, 5099007, 5099009, 5118954, 5099718, 5100499, 5104698, 5482125, 5099243, 5153009, 5099236, 5099585, 5099254, 5099013, 5103878, 5099141, 5100202, 5100111, 5099103, 5100110, 5099170, 5099720, 5101317, 5118445, 5100839, 5099822, 5176646, 5117566, 5100104, 5099774, 5482111, 5100177, 5116074, 5103765, 5101311, 5111435, 5107005, 5121424, 5482108, 5482106, 5149074, 5121944);

Date: 2025-01-18 17:21:52 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 (5311642, 5113931, 5321548, 5099013, 5234120, 5182321, 5099005, 5291817, 5193920, 5112860, 5316776, 5359668, 5234790, 5210147, 5106122, 5099007, 5099533, 5417508, 5337614, 5099009, 5115849, 5099392, 5266065, 5417503, 5417504, 5099024, 5118711, 5099102, 5253395, 5149370, 5171438, 5106822, 5099712, 5103217, 5120051, 5203701, 5176426, 5101982, 5099254, 5106396);

Date: 2025-01-18 18:16:46 Duration: 6ms
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 (5134271, 5099737, 5100233, 5482167, 5099678, 5100935, 5099198, 5120982, 5099533, 5099348, 5200847, 5099500, 5099445, 5113802, 5119867, 5163288, 5099546, 5100354, 5099275, 5099119, 5099403, 5261158, 5110280, 5099035, 5099263, 5103082, 5099138, 5099045, 5099875, 5099540, 5099401, 5099206, 5099037, 5099296, 5099139, 5099144, 5108097, 5099873, 5112243, 5482115, 5099111, 5099644, 5103947, 5100144, 5447740, 5100729, 5482114, 5482113, 5339436, 5482112, 5119776, 5099162, 5099639, 5341579, 5100675, 5482110, 5103778, 5099187, 5099489, 5482109, 5101315, 5232991, 5107714, 5099015, 5100482, 5099169, 5099248, 5482107, 5099765, 5099904, 5099491, 5175760, 5103735);

Date: 2025-01-18 17:21:52 Duration: 4ms

10

350,505

Details

1m46s

0ms

2ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,429	707ms	0ms
	01	2,991	869ms	0ms
	02	1,324	376ms	0ms
	03	1,316	403ms	0ms
	04	1,024	308ms	0ms
	05	282	78ms	0ms
	06	811	241ms	0ms
	07	1,546	435ms	0ms
	08	9,395	2s689ms	0ms
	09	25,126	7s662ms	0ms
	10	37,332	13s28ms	0ms
	11	35,575	11s173ms	0ms
	12	41,778	12s749ms	0ms
	13	28,440	8s963ms	0ms
	14	25,216	7s1ms	0ms
	15	29,719	8s425ms	0ms
	16	21,963	6s242ms	0ms
	17	24,456	7s537ms	0ms
	18	15,658	4s850ms	0ms
	19	16,232	4s940ms	0ms
	20	14,048	4s171ms	0ms
	21	8,754	2s369ms	0ms
	22	5,090	1s445ms	0ms

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

Date: 2025-01-18 20:15:14 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.users' 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 = 855) OR r.global) ORDER BY r.id;

Date: 2025-01-18 17:59:14 Duration: 1ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.users' 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 = 1410) OR r.global) ORDER BY r.id;

Date: 2025-01-18 10:04:51 Duration: 1ms

11

320,134

Details

56s958ms

0ms

8ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,398	442ms	0ms
	01	3,191	579ms	0ms
	02	2,135	378ms	0ms
	03	1,442	260ms	0ms
	04	1,774	290ms	0ms
	05	692	98ms	0ms
	06	1,949	294ms	0ms
	07	3,029	441ms	0ms
	08	8,721	1s383ms	0ms
	09	25,734	4s362ms	0ms
	10	33,163	7s76ms	0ms
	11	31,424	5s708ms	0ms
	12	32,515	5s938ms	0ms
	13	26,221	4s584ms	0ms
	14	21,793	3s493ms	0ms
	15	24,942	4s52ms	0ms
	16	22,754	3s706ms	0ms
	17	21,038	3s794ms	0ms
	18	18,410	3s507ms	0ms
	19	14,874	2s678ms	0ms
	20	11,148	2s10ms	0ms
	21	6,830	1s192ms	0ms
	22	3,957	681ms	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 (1);

Date: 2025-01-18 18:16:29 Duration: 8ms
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 (8004672, 8007640, 8006429, 8004698, 8006493, 8007200, 8006295, 8007704, 8006689, 8004664, 8006432, 8004656, 8006394, 8007456, 8006320, 8006326, 8007763, 8006461);

Date: 2025-01-18 17:21:52 Duration: 3ms
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 (8006273, 8007331, 8007485, 8006936, 8004665, 8006323, 8006452, 8007496);

Date: 2025-01-18 17:21:52 Duration: 3ms

12

262,077

Details

44s564ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,151	299ms	0ms
	01	2,986	411ms	0ms
	02	1,307	166ms	0ms
	03	1,223	161ms	0ms
	04	1,057	135ms	0ms
	05	468	60ms	0ms
	06	983	133ms	0ms
	07	1,815	243ms	0ms
	08	9,991	1s500ms	0ms
	09	20,365	3s425ms	0ms
	10	25,936	5s361ms	0ms
	11	24,782	4s394ms	0ms
	12	30,373	5s437ms	0ms
	13	19,361	3s380ms	0ms
	14	17,991	2s825ms	0ms
	15	23,510	3s681ms	0ms
	16	16,451	2s560ms	0ms
	17	17,608	3s98ms	0ms
	18	11,227	1s896ms	0ms
	19	11,843	2s25ms	0ms
	20	10,684	1s768ms	0ms
	21	6,255	1s6ms	0ms
	22	3,710	588ms	0ms

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

Date: 2025-01-18 10:49:01 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1051 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_allow_export' AND model = 'res.groups');

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

Date: 2025-01-18 10:53:48 Duration: 1ms

13

207,841

Details

51s553ms

0ms

24ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,614	632ms	0ms
	01	2,989	596ms	0ms
	02	1,757	394ms	0ms
	03	1,018	234ms	0ms
	04	1,443	344ms	0ms
	05	334	70ms	0ms
	06	1,184	299ms	0ms
	07	1,138	289ms	0ms
	08	4,123	1s188ms	0ms
	09	13,550	3s766ms	0ms
	10	19,259	5s856ms	0ms
	11	17,313	4s434ms	0ms
	12	18,952	4s706ms	0ms
	13	16,228	3s473ms	0ms
	14	14,045	2s694ms	0ms
	15	15,168	3s299ms	0ms
	16	14,819	3s119ms	0ms
	17	15,142	3s747ms	0ms
	18	14,815	4s712ms	0ms
	19	11,836	3s6ms	0ms
	20	9,715	2s387ms	0ms
	21	6,151	1s462ms	0ms
	22	4,248	835ms	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 (41136873, 40956650, 41235702, 41109730, 41026943, 41027646, 41133499, 41628186, 41149444, 40885733, 41144225, 41146006, 41066078, 40994117, 32619212, 41118159, 40842901, 41089209, 41412548, 41109341, 41127130, 41132635, 41021183, 41156218, 41050064, 32617483, 41082874, 40632619, 41093349, 41164144, 41054924, 40829964, 40976763, 40891885, 41090322, 41177890, 41075868, 41153663, 41132039, 39417171, 41392522, 41391900, 41142022, 41010418, 41066583, 40050440, 41236155, 41122597, 41141323, 40627140, 41109115, 41095839, 41142213, 41144280, 40930346, 41068028, 41057241, 41158044, 41036144, 41138695, 40997732, 41041023, 41236189, 41143984, 40772307, 41049304, 40998617, 41125631, 41057655, 41092290, 41136285, 41087443, 41071900, 41144637, 41009059, 41021987, 41060474, 40857031, 40831199, 41392109, 40936270, 41626760, 41484818, 41391111, 41390882, 41626750, 40994936, 41093924, 41012442, 41007760, 40873274, 41155971, 41069636, 41156350, 41137641, 41012762, 40815684, 41015157, 41075464, 41130846);

Date: 2025-01-18 17:21:53 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 (40070111, 32608835, 40795046, 40786022, 41303687, 40083998, 40043542, 40747738, 41036707, 40043202, 40417847, 32612252, 40136968, 40651902, 41250463, 40365262, 40106824, 40357014, 40085293, 40605161, 40169727, 40851972, 40039812, 40257698, 40661820, 40153110, 41269843, 40470868, 41002779, 41007501, 40330832, 41206500, 40852447, 40260525, 40058338, 40892538, 40380880, 40668716, 39969093, 40624709, 40948495, 40650683, 40106342, 40483443, 41230815, 40760844, 41075308, 40471575, 40248292, 32605836, 39833468, 41120040, 41026443, 40774180, 39918630, 40138195, 40421918, 40054781, 40191191, 40312431, 32602977, 32612262, 40024000, 40242842, 40612970, 40841992, 40891849, 41123399, 40421305, 39742488, 32617663, 39746625, 40148728, 39443226, 40669739, 40996942, 40327811, 40034175, 40084612, 40259769, 40788445, 40969207, 41319868, 41419365, 40970166, 41305679, 40004430, 41165581, 40570592, 39946170, 39735908, 41236494, 40104688, 40064013, 39680585, 39645838, 39957170, 41103191, 40670932, 40965952);

Date: 2025-01-18 18:24:06 Duration: 22ms
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 (42083161, 42018235, 42040631, 42082470, 41986416, 41986255, 42017293, 41892990, 42114938, 42043298, 42043969, 42054775, 41466552, 41929905, 41921427, 42083798, 32658934, 42115762, 41989144, 42119855, 41984110, 32659193, 42005533, 41646339, 41992597, 42122727, 42023266, 42002734, 42028830, 42004929, 42084936, 42138872, 42054774, 42138797, 42089801, 42091986, 42059981, 41297830, 42059441, 41984097, 42005361, 42091019, 42119881, 42139912);

Date: 2025-01-18 17:21:52 Duration: 19ms

14

180,091

Details

1d4h25m48s

353ms

3s44ms

568ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 18	00	6,716	1h1m6s	545ms
	01	5,202	47m31s	548ms
	02	4,088	36m36s	537ms
	03	3,024	26m52s	533ms
	04	2,607	23m48s	548ms
	05	466	4m7s	531ms
	06	2,499	21m59s	527ms
	07	815	7m11s	529ms
	08	4,946	44m9s	535ms
	09	10,245	1h35m41s	560ms
	10	22,830	4h2m25s	637ms
	11	13,173	2h7m23s	580ms
	12	13,808	2h11m50s	572ms
	13	9,380	1h27m49s	561ms
	14	5,208	47m54s	551ms
	15	5,911	55m8s	559ms
	16	8,084	1h16m31s	567ms
	17	10,563	1h39m59s	567ms
	18	13,870	2h8m43s	556ms
	19	11,731	1h50m6s	563ms
	20	10,593	1h38m19s	556ms
	21	9,414	1h26m13s	549ms
	22	4,918	44m17s	540ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4420374)) AND (("shipping_track"."id" not in (36484696, 36486419, 36487112, 36496474, 36496648, 36496813, 36521867, 36915615, 37727094, 37727094)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:19:14 Duration: 3s44ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4567983)) AND (("shipping_track"."id" not in (37697829, 37697971, 37730816, 37730816)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:29:03 Duration: 2s22ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4567433)) AND (("shipping_track"."id" not in (37693644, 37693910, 37693953, 37730751, 37730751)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:28:57 Duration: 1s993ms

15

155,138

Details

10s948ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,436	95ms	0ms
	01	2,073	139ms	0ms
	02	1,375	80ms	0ms
	03	858	55ms	0ms
	04	856	53ms	0ms
	05	278	18ms	0ms
	06	1,176	72ms	0ms
	07	975	62ms	0ms
	08	3,530	235ms	0ms
	09	12,015	821ms	0ms
	10	16,844	1s603ms	0ms
	11	15,122	1s194ms	0ms
	12	15,396	962ms	0ms
	13	12,954	798ms	0ms
	14	10,537	592ms	0ms
	15	12,068	716ms	0ms
	16	10,796	685ms	0ms
	17	10,214	785ms	0ms
	18	9,871	833ms	0ms
	19	7,054	448ms	0ms
	20	5,250	354ms	0ms
	21	2,761	208ms	0ms
	22	1,699	131ms	0ms

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

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

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

Date: 2025-01-18 01:18:32 Duration: 0ms

16

151,590

Details

8s426ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,031	49ms	0ms
	01	1,373	66ms	0ms
	02	599	27ms	0ms
	03	570	28ms	0ms
	04	361	18ms	0ms
	05	119	5ms	0ms
	06	360	19ms	0ms
	07	678	33ms	0ms
	08	4,357	223ms	0ms
	09	11,187	629ms	0ms
	10	15,751	1s50ms	0ms
	11	15,047	879ms	0ms
	12	18,233	1s46ms	0ms
	13	11,773	674ms	0ms
	14	10,700	532ms	0ms
	15	12,951	659ms	0ms
	16	9,266	471ms	0ms
	17	10,574	592ms	0ms
	18	6,642	362ms	0ms
	19	7,184	394ms	0ms
	20	6,336	338ms	0ms
	21	4,180	204ms	0ms
	22	2,318	117ms	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 (96);

Date: 2025-01-18 16:40:47 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);

Date: 2025-01-18 09:49:15 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (17);

Date: 2025-01-18 16:23:33 Duration: 0ms

17

145,972

Details

17s260ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,001	101ms	0ms
	01	1,340	136ms	0ms
	02	581	57ms	0ms
	03	564	58ms	0ms
	04	352	37ms	0ms
	05	108	10ms	0ms
	06	354	39ms	0ms
	07	666	69ms	0ms
	08	4,243	459ms	0ms
	09	11,018	1s318ms	0ms
	10	15,317	2s222ms	0ms
	11	14,544	1s817ms	0ms
	12	17,563	2s131ms	0ms
	13	11,425	1s384ms	0ms
	14	10,332	1s85ms	0ms
	15	12,372	1s326ms	0ms
	16	8,808	948ms	0ms
	17	10,150	1s211ms	0ms
	18	6,354	733ms	0ms
	19	6,727	789ms	0ms
	20	6,095	689ms	0ms
	21	3,902	397ms	0ms
	22	2,156	233ms	0ms

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

Date: 2025-01-18 13:10:52 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: 2025-01-18 10:50:24 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 (97) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-18 17:55:38 Duration: 0ms

18

125,954

Details

24s571ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	884	156ms	0ms
	01	1,162	209ms	0ms
	02	556	94ms	0ms
	03	559	99ms	0ms
	04	463	84ms	0ms
	05	173	31ms	0ms
	06	363	64ms	0ms
	07	551	99ms	0ms
	08	3,541	640ms	0ms
	09	9,635	1s855ms	0ms
	10	13,673	3s30ms	0ms
	11	12,486	2s503ms	0ms
	12	15,333	3s24ms	0ms
	13	9,913	1s982ms	0ms
	14	8,862	1s569ms	0ms
	15	10,514	1s903ms	0ms
	16	7,590	1s396ms	0ms
	17	8,593	1s728ms	0ms
	18	5,656	1s120ms	0ms
	19	5,689	1s120ms	0ms
	20	5,005	982ms	0ms
	21	3,052	555ms	0ms
	22	1,701	318ms	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 (854) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-18 17:21:52 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 (1265) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-18 17:21:52 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 (823) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-18 16:40:47 Duration: 1ms

19

120,690

Details

1h30m15s

34ms

250ms

44ms

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,859	2m	42ms
	01	1,826	1m17s	42ms
	02	1,312	55s338ms	42ms
	03	1,107	46s877ms	42ms
	04	820	34s974ms	42ms
	05	322	13s870ms	43ms
	06	1,003	42s441ms	42ms
	07	437	18s813ms	43ms
	08	1,534	1m5s	42ms
	09	7,907	5m50s	44ms
	10	15,951	13m14s	49ms
	11	11,174	8m25s	45ms
	12	11,227	8m23s	44ms
	13	7,948	5m49s	43ms
	14	4,386	3m8s	42ms
	15	4,933	3m33s	43ms
	16	5,923	4m15s	43ms
	17	7,092	5m17s	44ms
	18	9,446	7m3s	44ms
	19	7,394	5m31s	44ms
	20	6,285	4m37s	44ms
	21	6,527	4m47s	44ms
	22	3,277	2m21s	43ms

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

Date: 2025-01-18 10:11:17 Duration: 250ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4420374)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-18 10:19:11 Duration: 250ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4561723)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-18 11:45:46 Duration: 237ms

20

114,729

Details

8s648ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,929	101ms	0ms
	01	2,108	107ms	0ms
	02	1,842	73ms	0ms
	03	1,201	63ms	0ms
	04	1,038	51ms	0ms
	05	113	5ms	0ms
	06	1,306	58ms	0ms
	07	704	40ms	0ms
	08	2,833	212ms	0ms
	09	9,011	680ms	0ms
	10	12,508	1s190ms	0ms
	11	11,848	924ms	0ms
	12	12,379	1s42ms	0ms
	13	8,785	650ms	0ms
	14	7,312	483ms	0ms
	15	8,142	595ms	0ms
	16	6,686	447ms	0ms
	17	7,043	560ms	0ms
	18	4,584	341ms	0ms
	19	4,775	383ms	0ms
	20	4,241	321ms	0ms
	21	2,752	192ms	0ms
	22	1,589	118ms	0ms

SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109);

Date: 2025-01-18 13:29:38 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (50);

Date: 2025-01-18 12:33:19 Duration: 0ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109);

Date: 2025-01-18 08:02:53 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

56m56s

2m12s

34

Details

1h15m10s

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
Jan 18	01	2	1ms	0ms
	02	2	0ms	0ms
	08	4	7m49s	1m57s
	09	3	56m56s	18m58s
	10	4	5ms	1ms
	11	1	1ms	1ms
	12	2	1ms	0ms
	13	2	2ms	1ms
	14	3	2ms	0ms
	15	6	10m24s	1m44s
	16	2	0ms	0ms
	18	2	0ms	0ms
	20	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-18 08:19:25.035892', "last_update" = '2025-01-18 07:34:25.035915', "write_date" = '2025-01-18 07:34:24.712932', "write_uid" = 1 WHERE id IN (1423);

Date: 2025-01-18 09:31:21 Duration: 56m56s
UPDATE "res_users" SET "exp_date" = '2025-01-18 15:13:12.335528', "last_update" = '2025-01-18 14:28:12.335548', "write_date" = '2025-01-18 14:28:12.007202', "write_uid" = 1 WHERE id IN (1411);

Date: 2025-01-18 15:36:21 Duration: 8m8s
UPDATE "res_users" SET "exp_date" = '2025-01-18 08:08:31.244708', "last_update" = '2025-01-18 07:23:31.244725', "write_date" = '2025-01-18 07:23:30.926708', "write_uid" = 1423 WHERE id IN (1423);

Date: 2025-01-18 08:31:21 Duration: 7m49s

2

0ms

48m18s

1m37s

316

Details

8h31m33s

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
Jan 18	00	2	2ms	1ms
	01	4	3ms	0ms
	02	3	31m23s	10m27s
	03	1	0ms	0ms
	04	2	0ms	0ms
	05	2	0ms	0ms
	06	1	0ms	0ms
	07	2	0ms	0ms
	08	17	18ms	1ms
	09	35	1h50m8s	3m8s
	10	23	32ms	1ms
	11	22	29ms	1ms
	12	32	40ms	1ms
	13	19	18ms	0ms
	14	19	12ms	0ms
	15	23	1m13s	3s195ms
	16	16	10ms	0ms
	17	19	23s614ms	1s242ms
	18	21	1h47m24s	5m6s
	19	28	3h58m19s	8m30s
	20	15	13m40s	54s724ms
	21	6	5ms	0ms
	22	4	8m59s	2m14s

UPDATE "res_users" SET "exp_date" = '2025-01-18 17:35:02.359714', "last_update" = '2025-01-18 16:50:02.359749', "sid" = '3de2e2ae47ecaeb5f5f66c991202678080d738af', "write_date" = '2025-01-18 16:50:01.974861', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-18 18:38:20 Duration: 48m18s
UPDATE "res_users" SET "exp_date" = '2025-01-18 17:37:28.111030', "last_update" = '2025-01-18 16:52:28.111051', "sid" = '3de2e2ae47ecaeb5f5f66c991202678080d738af', "write_date" = '2025-01-18 16:52:27.760109', "write_uid" = 1 WHERE id IN (905);

Date: 2025-01-18 18:38:20 Duration: 45m52s
UPDATE "res_users" SET "exp_date" = '2025-01-18 08:37:51.261085', "last_update" = '2025-01-18 07:52:51.261119', "sid" = '5890d01b70c81c797b80a52ec04c32b13ea6f992', "write_date" = '2025-01-18 07:52:50.933621', "write_uid" = 1 WHERE id IN (1423);

Date: 2025-01-18 09:31:21 Duration: 38m29s

3

0ms

1h

5s805ms

58,873

Details

3d22h56m42s

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
Jan 18	00	633	59m58s	5s684ms
	01	963	22s465ms	23ms
	02	760	165ms	0ms
	03	393	17s643ms	44ms
	04	783	158ms	0ms
	05	177	40ms	0ms
	06	378	82ms	0ms
	07	326	70ms	0ms
	08	1,284	1h18m32s	3s670ms
	09	3,926	12h37m53s	11s582ms
	10	6,858	5h36m7s	2s940ms
	11	6,321	6h36m29s	3s763ms
	12	6,365	9h9m37s	5s181ms
	13	4,906	2h36m16s	1s911ms
	14	3,898	12h11m18s	11s256ms
	15	4,734	5h29m47s	4s179ms
	16	3,792	8h35m20s	8s154ms
	17	3,510	5h21m43s	5s499ms
	18	2,851	6h34m51s	8s309ms
	19	2,386	9h20m14s	14s88ms
	20	1,848	6h17m47s	12s265ms
	21	1,081	280ms	0ms
	22	700	2h10m1s	11s145ms

update res_users set sid = 'b43e96e97487b034a0d6f14c632f38da20669e16', last_update = '2025-01-18 20:12:11.315921', exp_date = '2025-01-18 20:57:11.315925', logged_in = 'TRUE' where id = 1026;

Date: 2025-01-18 22:12:11 Duration: 1h
update res_users set sid = 'b43e96e97487b034a0d6f14c632f38da20669e16', last_update = '2025-01-18 20:12:11.315799', exp_date = '2025-01-18 20:57:11.315803', logged_in = 'TRUE' where id = 1026;

Date: 2025-01-18 22:12:11 Duration: 1h
update res_users set sid = '1276f4556365ef9e13826bed60fa691faf3dfbe7', last_update = '2025-01-17 22:52:37.837469', exp_date = '2025-01-17 23:37:37.837473', logged_in = 'TRUE' where id = 1390;

Date: 2025-01-18 00:52:36 Duration: 59m58s

4

24ms

4s141ms

2s683ms

224

Details

10m1s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 18	01	4	11s825ms	2s956ms
	08	1	939ms	939ms
	09	4	12s860ms	3s215ms
	10	2	7s824ms	3s912ms
	11	6	9s472ms	1s578ms
	12	10	20s593ms	2s59ms
	13	3	3s209ms	1s69ms
	14	25	49s196ms	1s967ms
	15	14	42s219ms	3s15ms
	16	27	1m11s	2s632ms
	17	26	1m9s	2s663ms
	18	54	2m34s	2s852ms
	19	12	41s404ms	3s450ms
	20	20	59s373ms	2s968ms
	21	12	35s974ms	2s997ms
	22	4	11s910ms	2s977ms

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 (53))))))) 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 (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%9836374%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-18 19:47:33 Duration: 4s141ms
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 (49))))))) 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 (49)))))) 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 (49)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) 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 (49))))))))) 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 (49)))))))) AND ("policy_number"."name"::text ilike '%9042298%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-18 19:52:15 Duration: 4s89ms
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 (53))))))) 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 (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%98363%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-18 19:47:33 Duration: 4s56ms

5

31ms

1s258ms

881ms

9,358

Details

2h17m30s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	265	3m52s	878ms
	01	206	2m58s	868ms
	09	8	4s569ms	571ms
	10	23	22s751ms	989ms
	11	37	36s394ms	983ms
	12	18	15s447ms	858ms
	13	26	24s581ms	945ms
	14	142	2m7s	900ms
	15	306	4m34s	897ms
	16	500	7m35s	911ms
	17	919	13m59s	913ms
	18	1,806	25m33s	848ms
	19	1,369	19m45s	866ms
	20	1,394	20m51s	897ms
	21	1,755	25m50s	883ms
	22	584	8m35s	883ms

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

Date: 2025-01-18 19:47:31 Duration: 1s258ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9988145')) 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 (19))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-18 18:46:06 Duration: 1s233ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9939639')) 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 (41))))))) 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 (41)))))) 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 (41)))))) 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 (41))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-18 17:25:10 Duration: 1s228ms

6

367ms

5s154ms

578ms

38,434

Details

6h10m37s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 18	00	189	1m52s	596ms
	01	154	1m35s	618ms
	02	118	1m12s	616ms
	03	206	1m57s	571ms
	04	300	2m47s	559ms
	05	160	1m26s	540ms
	06	71	42s304ms	595ms
	07	229	2m2s	536ms
	08	982	8m57s	546ms
	09	3,341	32m4s	575ms
	10	4,748	52m48s	667ms
	11	3,784	37m22s	592ms
	12	4,314	42m14s	587ms
	13	2,671	25m46s	579ms
	14	2,332	21m33s	554ms
	15	1,793	16m52s	564ms
	16	2,862	26m50s	562ms
	17	2,647	24m30s	555ms
	18	2,618	23m45s	544ms
	19	2,161	19m35s	544ms
	20	1,413	12m41s	539ms
	21	944	8m22s	532ms
	22	397	3m31s	533ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4557739, 4551907, 4551877, 4551874, 4551861, 4548992, 4544011, 4543736, 4541434, 4540621, 4538526, 4538522, 4538055, 4537996, 4536859, 4533696, 4533689, 4531338, 4529921, 4518660, 4517708, 4517415, 4504914, 4504894, 4504240, 4503885, 4503873)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:11:22 Duration: 5s154ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4559449, 4559446, 4559443, 4559442)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:00:21 Duration: 4s55ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4090983)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:00:21 Duration: 3s691ms

7

353ms

3s44ms

568ms

180,091

Details

1d4h25m48s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	6,716	1h1m6s	545ms
	01	5,202	47m31s	548ms
	02	4,088	36m36s	537ms
	03	3,024	26m52s	533ms
	04	2,607	23m48s	548ms
	05	466	4m7s	531ms
	06	2,499	21m59s	527ms
	07	815	7m11s	529ms
	08	4,946	44m9s	535ms
	09	10,245	1h35m41s	560ms
	10	22,830	4h2m25s	637ms
	11	13,173	2h7m23s	580ms
	12	13,808	2h11m50s	572ms
	13	9,380	1h27m49s	561ms
	14	5,208	47m54s	551ms
	15	5,911	55m8s	559ms
	16	8,084	1h16m31s	567ms
	17	10,563	1h39m59s	567ms
	18	13,870	2h8m43s	556ms
	19	11,731	1h50m6s	563ms
	20	10,593	1h38m19s	556ms
	21	9,414	1h26m13s	549ms
	22	4,918	44m17s	540ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4420374)) AND (("shipping_track"."id" not in (36484696, 36486419, 36487112, 36496474, 36496648, 36496813, 36521867, 36915615, 37727094, 37727094)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:19:14 Duration: 3s44ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4567983)) AND (("shipping_track"."id" not in (37697829, 37697971, 37730816, 37730816)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:29:03 Duration: 2s22ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4567433)) AND (("shipping_track"."id" not in (37693644, 37693910, 37693953, 37730751, 37730751)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-18 10:28:57 Duration: 1s993ms

8

191ms

624ms

274ms

7,811

Details

35m42s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 18	08	236	59s467ms	251ms
	09	301	1m19s	264ms
	10	1,105	5m30s	298ms
	11	828	3m57s	286ms
	12	399	1m47s	269ms
	13	1,010	4m37s	274ms
	14	461	2m4s	269ms
	15	770	3m14s	252ms
	16	1,169	5m2s	258ms
	17	842	3m48s	270ms
	18	344	1m35s	277ms
	19	346	1m45s	306ms

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

Date: 2025-01-18 10:15:27 Duration: 624ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9821080')))) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:15:30 Duration: 597ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9821662')))) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:15:34 Duration: 586ms

9

179ms

364ms

261ms

2,907

Details

12m40s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 18	08	129	32s17ms	248ms
	09	24	6s446ms	268ms
	10	407	1m59s	293ms
	11	353	1m28s	251ms
	12	78	19s950ms	255ms
	13	133	33s776ms	253ms
	14	191	47s713ms	249ms
	15	93	23s38ms	247ms
	16	188	47s724ms	253ms
	17	544	2m21s	260ms
	18	566	2m27s	261ms
	19	201	52s495ms	261ms

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

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

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

Date: 2025-01-18 10:20:52 Duration: 353ms

10

211ms

523ms

256ms

14,816

Details

1h3m26s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 18	00	898	3m51s	257ms
	01	656	2m51s	261ms
	02	378	1m34s	250ms
	03	125	30s638ms	245ms
	04	554	2m17s	248ms
	05	30	7s512ms	250ms
	06	6	1s469ms	244ms
	07	22	5s570ms	253ms
	08	1	275ms	275ms
	09	134	35s172ms	262ms
	10	76	22s683ms	298ms
	11	165	45s892ms	278ms
	12	34	9s877ms	290ms
	13	240	1m4s	267ms
	14	304	1m13s	242ms
	15	460	1m56s	252ms
	16	920	3m59s	260ms
	17	1,761	7m56s	270ms
	18	1,450	6m12s	256ms
	19	2,068	8m48s	255ms
	20	2,343	9m59s	255ms
	21	1,254	5m14s	250ms
	22	937	3m46s	241ms

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

Date: 2025-01-18 17:21:55 Duration: 523ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9608066')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

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

Date: 2025-01-18 17:54:02 Duration: 403ms

11

202ms

515ms

251ms

2,726

Details

11m26s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 18	00	120	29s540ms	246ms
	01	120	29s632ms	246ms
	02	120	29s452ms	245ms
	03	120	29s338ms	244ms
	04	120	29s262ms	243ms
	05	120	29s677ms	247ms
	06	120	29s517ms	245ms
	07	120	29s246ms	243ms
	08	120	29s610ms	246ms
	09	120	30s855ms	257ms
	10	120	35s255ms	293ms
	11	120	32s168ms	268ms
	12	120	31s886ms	265ms
	13	120	30s875ms	257ms
	14	120	29s988ms	249ms
	15	120	30s239ms	251ms
	16	120	30s682ms	255ms
	17	116	29s471ms	254ms
	18	120	30s456ms	253ms
	19	120	29s851ms	248ms
	20	120	29s103ms	242ms
	21	120	29s176ms	243ms
	22	90	21s548ms	239ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-18 10:29:02 Duration: 515ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-18 10:17:02 Duration: 441ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-18 10:29:02 Duration: 441ms

12

93ms

857ms

232ms

47,696

Details

3h4m46s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,296	7m58s	208ms
	01	1,694	6m1s	213ms
	02	746	2m44s	220ms
	03	250	52s654ms	210ms
	04	1,102	4m13s	230ms
	05	60	16s820ms	280ms
	06	6	1s825ms	304ms
	07	44	11s687ms	265ms
	08	2	278ms	139ms
	09	270	54s744ms	202ms
	10	188	50s263ms	267ms
	11	394	1m45s	268ms
	12	102	26s34ms	255ms
	13	510	1m57s	230ms
	14	856	3m5s	216ms
	15	1,494	5m48s	233ms
	16	2,788	10m25s	224ms
	17	5,290	20m26s	231ms
	18	6,448	26m36s	247ms
	19	6,806	27m35s	243ms
	20	7,394	28m57s	234ms
	21	5,956	22m40s	228ms
	22	3,000	10m57s	219ms

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

Date: 2025-01-18 18:18:05 Duration: 857ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'اسلام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-18 18:18:05 Duration: 857ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبد الرحمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-18 17:22:36 Duration: 856ms

13

167ms

422ms

210ms

6,504

Details

22m46s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2	388ms	194ms
	04	291	54s620ms	187ms
	07	22	4s136ms	188ms
	08	315	1m	192ms
	09	228	50s711ms	222ms
	10	2,711	10m15s	226ms
	11	507	1m39s	196ms
	12	400	1m23s	209ms
	13	189	36s890ms	195ms
	14	173	33s584ms	194ms
	15	87	16s926ms	194ms
	16	180	35s241ms	195ms
	17	553	1m49s	198ms
	18	568	1m51s	195ms
	19	201	39s703ms	197ms
	20	77	14s653ms	190ms

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

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

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

Date: 2025-01-18 10:00:18 Duration: 356ms

14

166ms

438ms

199ms

43,402

Details

2h24m19s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,243	3m53s	187ms
	01	1,319	4m7s	187ms
	02	715	2m13s	186ms
	03	1,378	4m17s	186ms
	04	500	1m33s	186ms
	05	489	1m32s	188ms
	06	1,182	3m42s	188ms
	07	618	1m56s	188ms
	08	2,840	8m58s	189ms
	09	2,257	7m43s	205ms
	10	6,524	24m25s	224ms
	11	3,643	12m8s	200ms
	12	3,073	10m27s	204ms
	13	3,751	12m13s	195ms
	14	1,417	4m32s	192ms
	15	2,459	7m53s	192ms
	16	2,342	7m35s	194ms
	17	4,753	15m25s	194ms
	18	1,468	4m51s	198ms
	19	1,215	4m5s	202ms
	20	143	27s178ms	190ms
	21	19	3s578ms	188ms
	22	54	9s921ms	183ms

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

Date: 2025-01-18 10:11:16 Duration: 438ms
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" = '9974356')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:25 Duration: 404ms
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" = '9876897')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:18 Duration: 395ms

15

168ms

413ms

198ms

12,343

Details

40m54s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	81	15s339ms	189ms
	01	106	20s25ms	188ms
	02	2	372ms	186ms
	05	481	1m30s	189ms
	06	1,140	3m35s	189ms
	07	596	1m52s	189ms
	08	1,183	3m44s	189ms
	09	1,381	4m36s	200ms
	10	1,126	4m19s	230ms
	11	1,338	4m30s	202ms
	12	1,131	3m50s	203ms
	13	1,483	4m53s	198ms
	14	195	37s711ms	193ms
	15	485	1m33s	193ms
	16	288	56s828ms	197ms
	17	872	2m50s	195ms
	19	322	1m	186ms
	20	66	12s550ms	190ms
	21	19	3s605ms	189ms
	22	48	8s897ms	185ms

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" = '9877926')) 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 (39, 115)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 115))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:11:16 Duration: 413ms
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" = '9904546')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:25 Duration: 382ms
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" = '8974134')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 10:00:17 Duration: 375ms

16

163ms

216ms

189ms

4,354

Details

13m44s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1,160	3m41s	190ms
	01	1,213	3m50s	190ms
	02	713	2m14s	188ms
	03	1,045	3m16s	188ms
	04	209	39s28ms	186ms
	05	8	1s467ms	183ms
	22	6	1s92ms	182ms

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" = '9851766')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-18 00:27:15 Duration: 216ms
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" = '9925203')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-18 01:24:26 Duration: 215ms

17

120ms

713ms

147ms

5,663

Details

13m52s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	35	4s547ms	129ms
	07	11	1s466ms	133ms
	08	56	7s596ms	135ms
	09	391	55s364ms	141ms
	10	1,198	3m15s	162ms
	11	1,281	3m4s	144ms
	12	1,058	2m31s	142ms
	13	645	1m29s	138ms
	14	150	20s188ms	134ms
	15	251	34s271ms	136ms
	16	146	19s867ms	136ms
	17	125	19s682ms	157ms
	18	76	12s221ms	160ms
	19	87	13s718ms	157ms
	20	102	15s612ms	153ms
	21	24	3s641ms	151ms
	22	27	4s38ms	149ms

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: 2025-01-18 10:28:57 Duration: 713ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 123)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-18 10:19:06 Duration: 332ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-18 10:29:04 Duration: 322ms

18

95ms

782ms

114ms

16,484

Details

31m33s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	1	113ms	113ms
	01	325	34s947ms	107ms
	03	29	3s364ms	116ms
	04	22	2s525ms	114ms
	05	25	2s890ms	115ms
	06	1	117ms	117ms
	08	265	30s206ms	113ms
	09	832	1m38s	118ms
	10	1,516	3m20s	132ms
	11	1,137	2m14s	117ms
	12	2,201	4m16s	116ms
	13	2,172	4m2s	111ms
	14	1,628	2m58s	109ms
	15	1,575	2m53s	110ms
	16	1,259	2m22s	113ms
	17	1,077	2m3s	114ms
	18	759	1m25s	112ms
	19	668	1m16s	114ms
	20	329	36s748ms	111ms
	21	148	16s405ms	110ms
	22	515	54s817ms	106ms

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

Date: 2025-01-18 10:11:18 Duration: 782ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7988566)) AND (("cash_track"."id" not in (6996685, 7004182, 7006464, 7072359, 7072359)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-18 10:00:18 Duration: 453ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7999387)) AND (("cash_track"."id" not in (7073378)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-18 10:29:01 Duration: 227ms

19

38ms

327ms

57ms

31,282

Details

30m12s

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

Day	Hour	Count	Duration	Avg duration
Jan 18	00	10	530ms	53ms
	01	8	420ms	52ms
	03	28	1s512ms	54ms
	04	41	2s138ms	52ms
	05	42	2s285ms	54ms
	06	5	262ms	52ms
	07	14	742ms	53ms
	08	377	19s642ms	52ms
	09	1,484	1m21s	54ms
	10	4,582	4m34s	59ms
	11	2,247	2m	53ms
	12	1,891	1m45s	55ms
	13	1,912	1m43s	54ms
	14	1,768	1m32s	52ms
	15	1,991	1m45s	52ms
	16	2,461	2m9s	52ms
	17	4,164	4m11s	60ms
	18	6,142	6m26s	62ms
	19	1,573	1m40s	63ms
	20	306	19s569ms	63ms
	21	150	9s345ms	62ms
	22	86	5s348ms	62ms

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

Date: 2025-01-18 10:00:14 Duration: 327ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4436269) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:00:14 Duration: 301ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4307160) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-18 10:28:55 Duration: 205ms

20

34ms

250ms

44ms

120,690

Details

1h30m15s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 18	00	2,859	2m	42ms
	01	1,826	1m17s	42ms
	02	1,312	55s338ms	42ms
	03	1,107	46s877ms	42ms
	04	820	34s974ms	42ms
	05	322	13s870ms	43ms
	06	1,003	42s441ms	42ms
	07	437	18s813ms	43ms
	08	1,534	1m5s	42ms
	09	7,907	5m50s	44ms
	10	15,951	13m14s	49ms
	11	11,174	8m25s	45ms
	12	11,227	8m23s	44ms
	13	7,948	5m49s	43ms
	14	4,386	3m8s	42ms
	15	4,933	3m33s	43ms
	16	5,923	4m15s	43ms
	17	7,092	5m17s	44ms
	18	9,446	7m3s	44ms
	19	7,394	5m31s	44ms
	20	6,285	4m37s	44ms
	21	6,527	4m47s	44ms
	22	3,277	2m21s	43ms

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

Date: 2025-01-18 10:11:17 Duration: 250ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4420374)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-18 10:19:11 Duration: 250ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4561723)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-18 11:45:46 Duration: 237ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

16,158,614 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	9	0.00%
DETAIL	56	0.00%
ERROR	2,948	0.02%
EVENTLOG	1,060	0.01%
FATAL	835	0.01%
HINT	4	0.00%
LOG	16,150,726	99.95%
STATEMENT	2,976	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
835 FATAL entries
2948 ERROR entries
0 WARNING entries
1060 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,524 Max number of times the same event was reported
4,843 Total events found

Rank

Times reported

Error

1

1,524

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 18	00	14
	01	15
	02	31
	03	10
	04	6
	06	5
	07	11
	08	39
	09	86
	10	232
	11	198
	12	103
	13	72
	14	57
	15	218
	16	129
	17	62
	18	54
	19	51
	20	61
	21	24
	22	46

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

1,389

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 18	00	11
	01	10
	02	25
	03	6
	04	6
	06	4
	07	10
	08	38
	09	81
	10	206
	11	193
	12	96
	13	67
	14	56
	15	208
	16	96
	17	55
	18	50
	19	50
	20	57
	21	24
	22	40

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

660

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 18	02	2
	08	32
	09	73
	10	94
	11	66
	12	102
	13	17
	14	30
	15	61
	16	29
	17	51
	18	26
	19	49
	20	26
	22	2

4

660

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 18	02	2
	08	32
	09	73
	10	94
	11	66
	12	102
	13	17
	14	30
	15	61
	16	29
	17	51
	18	26
	19	49
	20	26
	22	2

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

5

278

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 18	00	1
	02	1
	08	1
	09	30
	10	34
	11	32
	12	56
	13	14
	14	2
	15	38
	16	3
	17	14
	18	12
	19	31
	20	7
	22	2

6

121

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 18	09	15
	10	19
	11	15
	12	26
	13	9
	14	1
	15	21
	16	2
	17	4
	18	2
	19	3
	20	4

7

76

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 18	17	76

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

8

32

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 18	03	23
	14	3
	15	3
	19	3

FATAL: password authentication failed for user "postgres"

9

29

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 18	17	29

10

24

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 18	17	24

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

11

16

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 18	12	5
	13	4
	14	1
	15	4
	17	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

12

5

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 18	17	5

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

13

4

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 18	17	1
	21	3

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

14

4

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 18	06	1
	16	3

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

15

4

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 18	10	1
	17	1
	18	2

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

16

3

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 18	11	2
	15	1

17

3

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 18	13	1
	16	1
	21	1

18

3

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 18	13	1
	16	1
	21	1

19

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 18	13	1
	16	1
	21	1

20

1

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 18	17	1

ERROR: invalid input syntax for type date: "False" at character 37

21

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 18	17	1

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 18	19	1

23

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 18	19	1

ERROR: could not serialize access due to concurrent delete

24

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Jan 18	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables