pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Jan 29 23:47:32 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 44,495,565 log entries in 2m31s
Log start from 2025-01-29 00:00:00 to 2025-01-29 22:45:01

Global Stats

18,148 Number of unique normalized queries
19,053,588 Number of queries
8d12h38m52s Total query duration
2025-01-29 00:00:00 First query
2025-01-29 22:45:01 Last query
6,008 queries/s at 2025-01-29 16:51:13 Query peak

8d12h38m52s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
8d12h38m52s Execute total duration

5,928 Number of events
23 Number of unique normalized events
2,061 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
19,053,588 Average queries per session
8d12h38m52s 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,008 queries/s Query Peak
2025-01-29 16:51:13 Date

SELECT Traffic

Key values

3,948 queries/s Query Peak
2025-01-29 16:51:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,523 queries/s Query Peak
2025-01-29 15:09:27 Date

Queries duration

Key values

8d12h38m52s 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 29	00	302,646	0ms	59m58s	36ms	4m1s	4m30s	1h3m30s
	01	263,858	0ms	962ms	22ms	2m34s	2m59s	3m35s
	02	319,221	0ms	972ms	24ms	3m34s	3m39s	4m52s
	03	297,618	0ms	818ms	21ms	3m11s	3m23s	4m26s
	04	227,617	0ms	37m20s	215ms	3m21s	4m5s	11h44m23s
	05	149,126	0ms	17m44s	115ms	2m28s	3m59s	3h33m30s
	06	282,724	0ms	51m58s	223ms	5m46s	10m17s	9h40m13s
	07	175,660	0ms	42s222ms	16ms	2m3s	2m17s	3m
	08	471,721	0ms	4s456ms	10ms	2m39s	3m5s	3m37s
	09	1,096,231	0ms	59m59s	39ms	8m30s	11m48s	7h11m12s
	10	1,719,773	0ms	12m16s	22ms	11m50s	40m17s	1h48m11s
	11	1,800,446	0ms	22m6s	30ms	12m7s	1h50m6s	4h9m8s
	12	1,653,600	0ms	26m19s	35ms	9m51s	2h23m39s	5h19m28s
	13	1,656,488	0ms	6m10s	11ms	8m9s	11m47s	13m52s
	14	1,438,431	0ms	52m17s	66ms	9m23s	1h33m53s	13h53m56s
	15	1,313,596	0ms	29m46s	29ms	14m9s	23m31s	4h23m16s
	16	1,407,815	0ms	12m6s	34ms	13m59s	1h13m58s	1h51m8s
	17	1,283,330	0ms	2m19s	24ms	13m12s	15m32s	21m14s
	18	927,283	0ms	2m57s	18ms	7m45s	8m20s	9m11s
	19	856,090	0ms	25m4s	60ms	7m1s	3h3m46s	4h29m5s
	20	642,299	0ms	19m26s	84ms	6m30s	2h11m17s	4h45m35s
	21	450,652	0ms	3s421ms	19ms	3m53s	4m24s	5m53s
	22	317,363	0ms	48s466ms	21ms	5m7s	6m3s	6m28s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 29	00	166,859	43ms	3m29s	4m	4m29s
	01	139,594	41ms	2m23s	2m34s	3m28s
	02	155,641	50ms	2m57s	3m34s	4m16s
	03	143,323	44ms	2m39s	3m11s	3m42s
	04	118,548	57ms	2m47s	3m19s	4m4s
	05	83,353	45ms	1m31s	2m8s	2m33s
	06	168,065	39ms	2m29s	3m14s	4m24s
	07	94,959	30ms	1m21s	2m2s	2m55s
	08	277,482	17ms	2m3s	2m39s	3m13s
	09	653,626	21ms	4m36s	7m23s	10m31s
	10	1,049,179	23ms	8m43s	10m6s	11m48s
	11	1,098,987	18ms	7m23s	8m18s	12m5s
	12	994,612	21ms	8m4s	8m53s	10m40s
	13	999,009	19ms	6m23s	7m50s	11m45s
	14	858,650	19ms	5m38s	6m33s	9m59s
	15	775,895	24ms	7m9s	11m24s	15m43s
	16	848,865	34ms	10m8s	12m3s	13m23s
	17	776,794	39ms	11m9s	13m10s	16m56s
	18	533,581	31ms	6m59s	7m44s	8m33s
	19	517,144	26ms	5m22s	6m14s	7m5s
	20	387,936	35ms	4m35s	5m55s	6m52s
	21	261,215	33ms	3m14s	3m52s	4m47s
	22	182,796	37ms	3m56s	5m6s	6m27s

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 29	00	28,935	5,936	144	103ms	155ms	212ms	374ms
	01	21,036	4,853	135	0ms	118ms	130ms	174ms
	02	27,412	6,409	143	0ms	149ms	176ms	232ms
	03	18,377	6,512	140	0ms	106ms	126ms	215ms
	04	20,020	6,198	132	1s601ms	122ms	190ms	314ms
	05	12,976	3,059	163	825ms	90ms	113ms	2m58s
	06	25,813	4,654	174	1s842ms	183ms	9s821ms	8m15s
	07	9,498	3,581	135	3ms	57ms	85ms	113ms
	08	17,513	6,494	385	0ms	106ms	127ms	157ms
	09	50,000	16,118	783	439ms	299ms	444ms	59s133ms
	10	83,417	27,330	936	119ms	570ms	675ms	35m51s
	11	78,306	23,007	972	343ms	537ms	787ms	1h47m9s
	12	75,774	24,327	883	367ms	505ms	609ms	2h20m39s
	13	70,564	23,159	791	5ms	470ms	621ms	29s147ms
	14	61,956	21,561	611	939ms	356ms	426ms	1h30m30s
	15	60,964	25,524	837	235ms	428ms	690ms	21m57s
	16	75,369	29,145	590	187ms	607ms	38s703ms	1h10m41s
	17	75,842	26,078	686	4ms	679ms	983ms	1m38s
	18	57,850	16,141	771	3ms	353ms	470ms	1s75ms
	19	54,756	14,193	444	553ms	359ms	440ms	3h2m13s
	20	53,847	12,249	373	605ms	335ms	390ms	2h9m6s
	21	36,127	8,082	224	0ms	221ms	277ms	345ms
	22	35,399	6,987	185	1ms	236ms	380ms	1s198ms

Day	Hour	Percentage of prepare
Jan 29	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 29	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 29	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

129,312 buffers Checkpoint Peak
2025-01-29 16:56:22 Date
270.054 seconds Highest write time
0.018 seconds Sync time

Checkpoints Wal files

Key values

53 files Wal files usage Peak
2025-01-29 16:56:22 Date

Checkpoints distance

Key values

1,696.14 Mo Distance Peak
2025-01-29 16:56:22 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 29	00	163,824	3,239.531s	0.04s	3,239.618s
	01	154,624	3,239.536s	0.031s	3,239.624s
	02	142,634	3,239.611s	0.03s	3,239.683s
	03	144,858	3,239.529s	0.028s	3,239.607s
	04	139,361	3,239.624s	0.025s	3,239.692s
	05	69,858	2,433.254s	0.022s	2,433.307s
	06	117,535	3,239.586s	0.035s	3,239.663s
	07	79,046	3,093.45s	0.033s	3,093.533s
	08	140,580	3,239.549s	0.034s	3,239.618s
	09	298,160	3,239.587s	0.045s	3,239.689s
	10	552,702	3,239.482s	0.057s	3,239.642s
	11	532,229	3,239.493s	0.058s	3,239.639s
	12	559,119	3,239.434s	0.064s	3,239.594s
	13	498,997	3,239.565s	0.057s	3,239.705s
	14	443,830	3,239.533s	0.057s	3,239.663s
	15	392,471	3,239.45s	0.054s	3,239.565s
	16	449,886	3,239.608s	0.062s	3,239.751s
	17	384,507	2,888.899s	0.077s	2,889.052s
	18	316,633	3,239.543s	0.047s	3,239.662s
	19	231,611	3,239.544s	0.043s	3,239.646s
	20	198,397	3,239.572s	0.041s	3,239.669s
	21	149,491	3,239.477s	0.044s	3,239.584s
	22	129,870	2,429.715s	0.03s	2,429.782s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 29	00	64	3,739	0.002s	0.012s
	01	64	3,332	0.002s	0.012s
	02	60	2,829	0.002s	0.012s
	03	58	2,495	0.002s	0.012s
	04	58	2,613	0.002s	0.012s
	05	29	2,157	0.002s	0.011s
	06	48	3,207	0.006s	0.012s
	07	31	2,155	0.009s	0.012s
	08	53	3,803	0.003s	0.012s
	09	116	4,909	0.003s	0.012s
	10	225	5,476	0.003s	0.012s
	11	218	5,447	0.004s	0.012s
	12	230	5,329	0.003s	0.012s
	13	208	5,646	0.003s	0.012s
	14	187	5,457	0.012s	0.012s
	15	165	5,721	0.003s	0.012s
	16	190	5,505	0.003s	0.012s
	17	154	5,672	0.009s	0.012s
	18	125	5,339	0.002s	0.012s
	19	93	5,194	0.003s	0.012s
	20	81	5,103	0.003s	0.012s
	21	64	4,532	0.008s	0.012s
	22	53	3,390	0.002s	0.009s

Day	Hour	Avg time (sec)
Jan 29	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 29	00	87,485.58 kB	127,730.33 kB
	01	87,464.92 kB	123,538.83 kB
	02	82,425.17 kB	98,501.75 kB
	03	78,517.33 kB	100,044.92 kB
	04	79,149.42 kB	101,229.67 kB
	05	43,884.91 kB	73,272.55 kB
	06	65,200.08 kB	79,712.67 kB
	07	42,452.67 kB	83,864.25 kB
	08	73,060.83 kB	99,039.67 kB
	09	157,109.67 kB	176,304.42 kB
	10	303,675.18 kB	358,908.18 kB
	11	298,933.91 kB	373,986.64 kB
	12	313,140.58 kB	367,880.67 kB
	13	288,543.18 kB	337,724.91 kB
	14	251,424.00 kB	309,064.45 kB
	15	227,611.50 kB	297,164.30 kB
	16	259,800.17 kB	293,515.50 kB
	17	210,218.00 kB	468,632.83 kB
	18	171,033.92 kB	237,965.58 kB
	19	127,130.00 kB	179,851.25 kB
	20	110,690.83 kB	141,063.92 kB
	21	86,850.58 kB	131,553.58 kB
	22	96,856.89 kB	170,268.78 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (271) Main checkpoint cause
272 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	271
shutdown immediate	1
Total	272

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

11,286,113 Total read queries
5,309,535 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,286,113	59.23%
INSERT	1,051,751	5.52%
UPDATE	321,597	1.69%
DELETE	10,637	0.06%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	26,546	0.14%
DDL	2,101	0.01%
TCL	3,896,903	20.45%
CURSOR	0	0.00%
OTHERS	2,457,940	12.90%

Queries by database

Key values

unknown Main database
19,053,588 Requests
8d12h38m52s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	19,053,588	8d12h38m52s
	cte	26,546	6s150ms
	ddl	2,101	288ms
	delete	10,637	6m20s
	insert	1,051,751	5m39s
	others	2,457,940	1m58s
	select	11,286,113	3d13h7m23s
	tcl	3,896,903	2m41s
	update	321,597	4d23h14m43s

Queries by user

Key values

unknown Main user
19,053,588 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	19,053,588	8d12h38m52s
	cte	26,546	6s150ms
	ddl	2,101	288ms
	delete	10,637	6m20s
	insert	1,051,751	5m39s
	others	2,457,940	1m58s
	select	11,286,113	3d13h7m23s
	tcl	3,896,903	2m41s
	update	321,597	4d23h14m43s

Duration by user

Key values

8d12h38m52s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	19,053,588	8d12h38m52s
	cte	26,546	6s150ms
	ddl	2,101	288ms
	delete	10,637	6m20s
	insert	1,051,751	5m39s
	others	2,457,940	1m58s
	select	11,286,113	3d13h7m23s
	tcl	3,896,903	2m41s
	update	321,597	4d23h14m43s

Queries by host

Key values

unknown Main host
19,053,588 Requests
8d12h38m52s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	19,053,588	8d12h38m52s
	cte	26,546	6s150ms
	ddl	2,101	288ms
	delete	10,637	6m20s
	insert	1,051,751	5m39s
	others	2,457,940	1m58s
	select	11,286,113	3d13h7m23s
	tcl	3,896,903	2m41s
	update	321,597	4d23h14m43s

Queries by application

Key values

unknown Main application
19,053,588 Requests
8d12h38m52s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	19,053,588	8d12h38m52s
	cte	26,546	6s150ms
	ddl	2,101	288ms
	delete	10,637	6m20s
	insert	1,051,751	5m39s
	others	2,457,940	1m58s
	select	11,286,113	3d13h7m23s
	tcl	3,896,903	2m41s
	update	321,597	4d23h14m43s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-29 20:58:24 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,702,988 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,702,988	92.91%
1-5ms	360,799	1.89%
5-10ms	16,589	0.09%
10-25ms	50,619	0.27%
25-50ms	126,086	0.66%
50-100ms	121,587	0.64%
100-500ms	345,351	1.81%
500-1000ms	324,184	1.70%
1000-10000ms	4,565	0.02%
> 10000ms	820	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '3ebf5ebeb746a4e25349326bf231c4e9986c992e', last_update = '2025-01-29 07:21:06.933263', exp_date = '2025-01-29 08:06:06.933265', logged_in = 'TRUE' where id = 1197; [ Date: 2025-01-29 09:21:06 ]
2	59m58s	update res_users set sid = '3ebf5ebeb746a4e25349326bf231c4e9986c992e', last_update = '2025-01-28 22:09:46.369494', exp_date = '2025-01-28 22:54:46.369499', logged_in = 'TRUE' where id = 1197; [ Date: 2025-01-29 00:09:45 ]
3	52m17s	UPDATE "res_users" SET "exp_date" = '2025-01-29 12:54:03.872327', "last_update" = '2025-01-29 12:09:03.872356', "write_date" = '2025-01-29 12:09:03.439750', "write_uid" = 886 WHERE id IN (886); [ Date: 2025-01-29 14:01:21 ]
4	51m58s	UPDATE "res_users" SET "exp_date" = '2025-01-29 04:55:22.122777', "last_update" = '2025-01-29 04:10:22.122811', "write_date" = '2025-01-29 04:10:21.795506', "write_uid" = 1123 WHERE id IN (1123); [ Date: 2025-01-29 06:02:20 ]
5	51m45s	update res_users set sid = '9dd472d2ed106a4c3634700384ee14881ab72f39', last_update = '2025-01-29 04:10:35.565819', exp_date = '2025-01-29 04:55:35.565822', logged_in = 'TRUE' where id = 1123; [ Date: 2025-01-29 06:02:20 ]
6	51m23s	update res_users set sid = '9dd472d2ed106a4c3634700384ee14881ab72f39', last_update = '2025-01-29 04:10:56.962854', exp_date = '2025-01-29 04:55:56.962855', logged_in = 'TRUE' where id = 1123; [ Date: 2025-01-29 06:02:20 ]
7	48m57s	update res_users set sid = '9dd472d2ed106a4c3634700384ee14881ab72f39', last_update = '2025-01-29 04:13:23.604239', exp_date = '2025-01-29 04:58:23.604243', logged_in = 'TRUE' where id = 1123; [ Date: 2025-01-29 06:02:20 ]
8	48m55s	update res_users set sid = '9dd472d2ed106a4c3634700384ee14881ab72f39', last_update = '2025-01-29 04:13:25.201256', exp_date = '2025-01-29 04:58:25.201261', logged_in = 'TRUE' where id = 1123; [ Date: 2025-01-29 06:02:20 ]
9	48m55s	update res_users set sid = '9dd472d2ed106a4c3634700384ee14881ab72f39', last_update = '2025-01-29 04:13:25.823752', exp_date = '2025-01-29 04:58:25.823756', logged_in = 'TRUE' where id = 1123; [ Date: 2025-01-29 06:02:20 ]
10	48m51s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:12:30.104002', exp_date = '2025-01-29 12:57:30.104005', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
11	48m24s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:12:56.931612', exp_date = '2025-01-29 12:57:56.931615', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
12	47m43s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:37.364552', exp_date = '2025-01-29 12:58:37.364557', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
13	47m43s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:37.575258', exp_date = '2025-01-29 12:58:37.575262', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
14	47m43s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:37.761805', exp_date = '2025-01-29 12:58:37.761809', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
15	47m43s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:37.961957', exp_date = '2025-01-29 12:58:37.961964', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
16	47m42s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:38.154340', exp_date = '2025-01-29 12:58:38.154346', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
17	47m42s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:38.352876', exp_date = '2025-01-29 12:58:38.352881', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
18	47m42s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:38.563290', exp_date = '2025-01-29 12:58:38.563295', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
19	47m42s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:38.785113', exp_date = '2025-01-29 12:58:38.785119', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]
20	47m30s	update res_users set sid = '791f1578f5242d7219292180e9e15f3a4fd4130e', last_update = '2025-01-29 12:13:50.292936', exp_date = '2025-01-29 12:58:50.292941', logged_in = 'TRUE' where id = 886; [ Date: 2025-01-29 14:01:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d15h8m12s

68,010

Details

0ms

59m59s

5s882ms

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 29	00	894	59m58s	4s25ms
	01	876	183ms	0ms
	02	989	209ms	0ms
	03	1,068	225ms	0ms
	04	752	9h57m34s	47s679ms
	05	339	3h15m25s	34s589ms
	06	698	14h32m37s	1m15s
	07	553	42s343ms	76ms
	08	1,750	376ms	0ms
	09	4,530	6h45m51s	5s375ms
	10	7,233	3h40m31s	1s829ms
	11	7,016	9h42m39s	4s982ms
	12	6,519	9h58m35s	5s509ms
	13	6,182	1m7s	10ms
	14	4,987	20h44m59s	14s978ms
	15	4,786	5h10m29s	3s892ms
	16	4,783	5h22m43s	4s48ms
	17	4,300	5m44s	80ms
	18	3,106	2m57s	57ms
	19	2,746	10h20m39s	13s561ms
	20	1,830	10h25m31s	20s509ms
	21	1,271	294ms	0ms
	22	802	183ms	0ms

update res_users set sid = '3ebf5ebeb746a4e25349326bf231c4e9986c992e', last_update = '2025-01-29 07:21:06.933263', exp_date = '2025-01-29 08:06:06.933265', logged_in = 'TRUE' where id = 1197;

Date: 2025-01-29 09:21:06 Duration: 59m59s
update res_users set sid = '3ebf5ebeb746a4e25349326bf231c4e9986c992e', last_update = '2025-01-28 22:09:46.369494', exp_date = '2025-01-28 22:54:46.369499', logged_in = 'TRUE' where id = 1197;

Date: 2025-01-29 00:09:45 Duration: 59m58s
update res_users set sid = '9dd472d2ed106a4c3634700384ee14881ab72f39', last_update = '2025-01-29 04:10:35.565819', exp_date = '2025-01-29 04:55:35.565822', logged_in = 'TRUE' where id = 1123;

Date: 2025-01-29 06:02:20 Duration: 51m45s

2

1d22h47m29s

267,625

Details

512ms

5s843ms

629ms

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 29	00	8,441	1h19m40s	566ms
	01	7,632	1h11m11s	559ms
	02	9,434	1h28m57s	565ms
	03	7,846	1h12m41s	555ms
	04	8,383	1h18m18s	560ms
	05	3,747	35m43s	571ms
	06	8,220	1h18m17s	571ms
	07	3,000	27m8s	542ms
	08	4,969	45m28s	549ms
	09	12,179	2h1m32s	598ms
	10	20,646	3h45m17s	654ms
	11	18,005	3h13m17s	644ms
	12	17,340	3h4m53s	639ms
	13	14,664	2h33m8s	626ms
	14	11,732	1h58m30s	606ms
	15	11,563	2h3m22s	640ms
	16	21,655	4h6m14s	682ms
	17	23,448	4h47m31s	735ms
	18	17,028	3h2m20s	642ms
	19	11,853	2h4m49s	631ms
	20	11,669	2h3m1s	632ms
	21	8,227	1h24m3s	613ms
	22	5,944	1h1m59s	625ms

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

Date: 2025-01-29 17:50:03 Duration: 5s843ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4885741)) AND (("shipping_track"."id" not in (40503074, 40503074)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:49:49 Duration: 5s466ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4885800)) AND (("shipping_track"."id" not in (40503327, 40503327)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:50:22 Duration: 5s181ms

3

9h6m4s

145,096

Details

170ms

1s550ms

225ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,755	5m44s	196ms
	01	1,600	5m11s	194ms
	02	1,965	6m23s	195ms
	03	3,427	11m9s	195ms
	04	2,755	8m55s	194ms
	05	1,836	5m55s	193ms
	06	663	2m10s	196ms
	07	2,505	8m7s	194ms
	08	2,214	7m12s	195ms
	09	5,677	19m44s	208ms
	10	11,666	45m21s	233ms
	11	4,414	16m41s	226ms
	12	11,895	45m4s	227ms
	13	7,596	28m2s	221ms
	14	14,712	52m14s	213ms
	15	22,471	1h29m56s	240ms
	16	25,551	1h41m2s	237ms
	17	17,102	1h9m41s	244ms
	18	4,128	13m37s	198ms
	19	515	1m41s	196ms
	20	242	46s588ms	192ms
	21	286	55s486ms	194ms
	22	121	23s643ms	195ms

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

Date: 2025-01-29 17:50:14 Duration: 1s550ms
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" = '18865')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-29 15:53:56 Duration: 1s474ms
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" = '78181')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-29 17:43:04 Duration: 1s470ms

4

8h14m57s

45,645

Details

517ms

4s921ms

650ms

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 29	00	206	2m7s	618ms
	01	140	1m30s	649ms
	02	197	2m7s	649ms
	03	206	2m14s	651ms
	04	163	1m44s	643ms
	05	137	1m20s	589ms
	06	393	3m49s	582ms
	07	176	1m42s	580ms
	08	1,165	10m50s	558ms
	09	3,506	35m51s	613ms
	10	4,520	51m27s	683ms
	11	5,039	55m15s	658ms
	12	4,700	52m3s	664ms
	13	4,871	52m17s	644ms
	14	3,090	31m42s	615ms
	15	3,162	33m54s	643ms
	16	3,164	36m56s	700ms
	17	3,324	40m56s	738ms
	18	2,606	27m25s	631ms
	19	2,145	22m3s	617ms
	20	1,397	14m10s	609ms
	21	867	8m42s	602ms
	22	471	4m41s	598ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4874821, 4873427, 4873330, 4870323, 4870180, 4867921, 4867864, 4867846, 4866709, 4865976, 4863768, 4863647, 4863521, 4862624, 4862143, 4862048, 4861015, 4859194, 4857660, 4856995, 4856673, 4855198, 4844038, 4841922, 4830444, 4797472)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 11:08:31 Duration: 4s921ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4828023, 4828019, 4823455, 4823035, 4810484, 4795776)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 15:53:32 Duration: 4s715ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4873840)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:50:17 Duration: 4s561ms

5

4h16m35s

285

Details

0ms

31m7s

54s19ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 29	00	3	0ms	0ms
	01	4	0ms	0ms
	02	6	1ms	0ms
	03	4	2ms	0ms
	04	4	1h8m3s	17m
	05	4	6m41s	1m40s
	06	5	7ms	1ms
	07	3	4ms	1ms
	08	11	9ms	0ms
	09	27	1h21m22s	3m
	10	28	40ms	1ms
	11	14	20ms	1ms
	12	26	13m42s	31s620ms
	13	22	18ms	0ms
	14	21	28ms	1ms
	15	27	29m46s	1m6s
	16	19	1m24s	4s452ms
	17	17	35ms	2ms
	18	11	5ms	0ms
	19	8	18m32s	2m19s
	20	12	37m3s	3m5s
	21	1	0ms	0ms
	22	8	5ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-29 04:02:13.413569', "last_update" = '2025-01-29 03:17:13.413597', "sid" = 'a9ac041633ec30e279f63703a222f7e49d31bafb', "write_date" = '2025-01-29 03:17:13.092496', "write_uid" = 1 WHERE id IN (1432);

Date: 2025-01-29 04:48:21 Duration: 31m7s
UPDATE "res_users" SET "exp_date" = '2025-01-29 14:50:34.477151', "last_update" = '2025-01-29 14:05:34.477184', "sid" = '791f1578f5242d7219292180e9e15f3a4fd4130e', "write_date" = '2025-01-29 14:05:34.044946', "write_uid" = 1 WHERE id IN (886);

Date: 2025-01-29 15:35:20 Duration: 29m46s
UPDATE "res_users" SET "exp_date" = '2025-01-29 04:05:08.410371', "last_update" = '2025-01-29 03:20:08.410393', "sid" = 'aafd0f0986575e3576a622788f5072aa311230ff', "write_date" = '2025-01-29 03:20:08.076806', "write_uid" = 1 WHERE id IN (1432);

Date: 2025-01-29 04:48:21 Duration: 28m12s

6

3h53m9s

56,980

Details

96ms

894ms

245ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 29	00	2,466	9m12s	223ms
	01	1,426	5m1s	211ms
	02	2,834	10m45s	227ms
	03	966	3m58s	247ms
	04	2,050	7m28s	218ms
	05	1,980	7m35s	230ms
	06	3,403	12m30s	220ms
	07	2	250ms	125ms
	08	100	21s619ms	216ms
	09	232	1m1s	266ms
	10	374	1m25s	229ms
	11	358	1m35s	267ms
	12	82	23s992ms	292ms
	13	934	3m35s	230ms
	14	880	3m6s	212ms
	15	1,079	4m31s	252ms
	16	3,851	18m16s	284ms
	17	5,936	29m14s	295ms
	18	3,964	16m34s	250ms
	19	6,331	25m23s	240ms
	20	8,017	31m26s	235ms
	21	5,000	19m17s	231ms
	22	4,715	20m18s	258ms

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-29 17:50:27 Duration: 894ms
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-29 17:50:28 Duration: 877ms
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-29 19:38:30 Duration: 877ms

7

3h9m52s

70

Details

0ms

52m17s

2m42s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 29	02	1	0ms	0ms
	04	3	37m20s	12m26s
	05	8	17m44s	2m13s
	06	1	51m58s	51m58s
	08	7	7ms	1ms
	09	5	1m17s	15s423ms
	10	4	7ms	1ms
	11	3	2m48s	56s292ms
	12	6	3ms	0ms
	13	9	4ms	0ms
	14	11	1h10m57s	6m27s
	15	3	10ms	3ms
	17	1	1ms	1ms
	18	1	0ms	0ms
	20	1	7m44s	7m44s
	21	3	3ms	1ms
	22	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-29 12:54:03.872327', "last_update" = '2025-01-29 12:09:03.872356', "write_date" = '2025-01-29 12:09:03.439750', "write_uid" = 886 WHERE id IN (886);

Date: 2025-01-29 14:01:21 Duration: 52m17s
UPDATE "res_users" SET "exp_date" = '2025-01-29 04:55:22.122777', "last_update" = '2025-01-29 04:10:22.122811', "write_date" = '2025-01-29 04:10:21.795506', "write_uid" = 1123 WHERE id IN (1123);

Date: 2025-01-29 06:02:20 Duration: 51m58s
UPDATE "res_users" SET "exp_date" = '2025-01-29 03:56:00.755084', "last_update" = '2025-01-29 03:11:00.755110', "write_date" = '2025-01-29 03:11:00.434630', "write_uid" = 1 WHERE id IN (1432);

Date: 2025-01-29 04:48:21 Duration: 37m20s

8

2h57m42s

11,436

Details

219ms

2s75ms

932ms

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	788	12m	913ms
	01	218	3m14s	890ms
	02	404	6m2s	898ms
	05	4	3s651ms	912ms
	08	23	20s749ms	902ms
	09	29	27s110ms	934ms
	10	36	38s450ms	1s68ms
	11	43	49s41ms	1s140ms
	12	1	1s1ms	1s1ms
	13	110	1m45s	956ms
	14	242	4m11s	1s41ms
	15	450	7m52s	1s49ms
	16	926	17m6s	1s108ms
	17	1,318	23m26s	1s67ms
	18	820	12m18s	900ms
	19	1,713	24m42s	865ms
	20	2,348	34m41s	886ms
	21	991	13m37s	824ms
	22	972	14m24s	888ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '114552')) 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 (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-29 17:50:28 Duration: 2s75ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '92551')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-29 17:50:32 Duration: 2s18ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '92202')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-29 17:50:27 Duration: 2s9ms

9

2h18m20s

25,054

Details

183ms

1s433ms

331ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 29	07	82	20s510ms	250ms
	08	175	44s10ms	251ms
	09	2,017	13m2s	388ms
	10	3,333	20m10s	363ms
	11	933	4m50s	311ms
	12	4,145	21m37s	313ms
	13	3,899	19m37s	302ms
	14	3,869	19m3s	295ms
	15	2,752	14m29s	315ms
	16	2,575	16m23s	381ms
	17	1,177	7m14s	369ms
	18	65	30s942ms	476ms
	19	32	14s820ms	463ms

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

Date: 2025-01-29 15:53:11 Duration: 1s433ms
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" = '9638738')))) ORDER BY "collection_policy"."id";

Date: 2025-01-29 15:52:39 Duration: 1s384ms
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" = '34639')))) ORDER BY "collection_policy"."id";

Date: 2025-01-29 13:11:52 Duration: 1s263ms

10

2h3m5s

152,507

Details

35ms

336ms

48ms

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	4,382	3m9s	43ms
	01	2,957	2m8s	43ms
	02	4,277	3m5s	43ms
	03	2,471	1m47s	43ms
	04	2,319	1m40s	43ms
	05	931	40s431ms	43ms
	06	2,705	1m58s	43ms
	07	1,541	1m6s	43ms
	08	2,951	2m7s	43ms
	09	9,476	7m25s	46ms
	10	14,120	12m3s	51ms
	11	14,645	12m15s	50ms
	12	14,529	12m6s	49ms
	13	11,543	9m20s	48ms
	14	9,027	7m1s	46ms
	15	7,788	6m17s	48ms
	16	8,143	7m8s	52ms
	17	8,642	8m1s	55ms
	18	5,944	4m53s	49ms
	19	8,209	6m31s	47ms
	20	7,177	5m36s	46ms
	21	5,395	4m6s	45ms
	22	3,335	2m33s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4848669, 4819887, 4791889)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 15:53:15 Duration: 336ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4870788, 4854671)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 15:54:14 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4705836)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 17:43:05 Duration: 281ms

11

1h22m45s

17,376

Details

220ms

1s805ms

285ms

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	455	2m1s	267ms
	01	496	2m14s	270ms
	02	1,024	4m30s	264ms
	03	488	2m9s	264ms
	04	1,036	4m34s	265ms
	05	992	4m16s	258ms
	06	1,717	7m33s	263ms
	07	3	796ms	265ms
	08	29	7s646ms	263ms
	09	92	27s913ms	303ms
	10	155	48s38ms	309ms
	11	139	43s234ms	311ms
	12	45	16s919ms	375ms
	13	377	1m51s	296ms
	14	221	1m2s	283ms
	15	103	34s99ms	331ms
	16	1,039	5m52s	339ms
	17	1,667	9m51s	354ms
	18	1,178	5m52s	299ms
	19	1,483	7m1s	284ms
	20	1,683	7m43s	275ms
	21	1,537	6m46s	264ms
	22	1,417	6m25s	271ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '178421')) 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-29 17:43:30 Duration: 1s805ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '44269')) 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-29 17:50:04 Duration: 1s788ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '176996')) 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-29 17:43:38 Duration: 1s630ms

12

1h4m44s

18,192

Details

174ms

1s66ms

213ms

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	154	29s790ms	193ms
	03	354	1m9s	196ms
	04	9	1s725ms	191ms
	05	441	1m25s	193ms
	06	663	2m10s	196ms
	07	2,395	7m46s	194ms
	08	1,810	5m54s	195ms
	09	1,701	6m3s	213ms
	10	3,405	12m50s	226ms
	11	1,857	7m5s	229ms
	12	846	3m7s	221ms
	13	1,215	4m29s	221ms
	14	806	2m51s	213ms
	15	66	15s660ms	237ms
	16	672	2m36s	233ms
	17	700	2m47s	239ms
	18	145	31s702ms	218ms
	19	335	1m5s	194ms
	20	211	40s896ms	193ms
	21	286	55s675ms	194ms
	22	121	23s649ms	195ms

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" = '9504291')) 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 (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) 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-29 10:45:24 Duration: 1s66ms
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" = '9348288')) 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 (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) 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-29 11:08:16 Duration: 551ms
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" = '118221')) 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 (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) 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-29 11:08:13 Duration: 536ms

13

41m15s

40,951

Details

44ms

332ms

60ms

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

Day	Hour	Count	Duration	Avg duration
Jan 29	07	52	2s768ms	53ms
	08	410	21s753ms	53ms
	09	3,125	3m2s	58ms
	10	3,173	3m22s	63ms
	11	3,325	3m18s	59ms
	12	6,888	6m58s	60ms
	13	4,201	4m10s	59ms
	14	6,030	5m42s	56ms
	15	5,675	5m36s	59ms
	16	5,152	5m25s	63ms
	17	2,515	2m48s	66ms
	18	167	9s886ms	59ms
	19	165	9s547ms	57ms
	20	53	3s19ms	56ms
	21	14	768ms	54ms
	22	6	315ms	52ms

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

Date: 2025-01-29 15:53:24 Duration: 332ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4855999) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-29 17:51:07 Duration: 331ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4768877) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-29 17:43:05 Duration: 323ms

14

37m47s

17,729

Details

94ms

794ms

127ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 29	05	21	2s433ms	115ms
	06	33	3s894ms	118ms
	08	272	31s336ms	115ms
	09	808	1m40s	124ms
	10	1,950	4m21s	133ms
	11	2,232	4m46s	128ms
	12	1,880	4m7s	131ms
	13	2,255	4m42s	125ms
	14	1,523	3m8s	123ms
	15	1,664	3m30s	126ms
	16	1,609	3m35s	133ms
	17	961	2m16s	142ms
	18	905	1m50s	122ms
	19	472	56s949ms	120ms
	20	437	51s514ms	117ms
	21	187	21s454ms	114ms
	22	520	59s956ms	115ms

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

Date: 2025-01-29 13:07:41 Duration: 794ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8054705)) AND (("cash_track"."id" not in (7477622)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-29 11:08:27 Duration: 787ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8056077)) AND (("cash_track"."id" not in (7484324)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-29 13:11:28 Duration: 646ms

15

33m38s

10,336

Details

173ms

253ms

195ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,494	4m53s	196ms
	01	1,600	5m11s	194ms
	02	1,599	5m11s	194ms
	03	2,263	7m23s	196ms
	04	2,734	8m52s	194ms
	05	646	2m5s	194ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9779792')) 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-29 00:13:30 Duration: 253ms
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" = '9703897')) 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-29 00:13:29 Duration: 243ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '72862')) 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-29 00:13:34 Duration: 240ms

16

22m39s

29,058

Details

0ms

5m44s

46ms

update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,232	245ms	0ms
	01	712	135ms	0ms
	02	1,416	269ms	0ms
	03	483	79ms	0ms
	04	1,025	227ms	0ms
	05	990	2m58s	180ms
	06	1,703	16m14s	572ms
	07	1	0ms	0ms
	08	70	21ms	0ms
	09	177	62ms	0ms
	10	252	94ms	0ms
	11	245	85ms	0ms
	12	96	46ms	0ms
	13	522	149ms	0ms
	14	477	124ms	0ms
	15	587	184ms	0ms
	16	1,951	2m31s	77ms
	17	3,007	992ms	0ms
	18	2,019	537ms	0ms
	19	3,194	812ms	0ms
	20	4,026	1s7ms	0ms
	21	2,510	551ms	0ms
	22	2,363	49s43ms	20ms

UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-29 05:09:36.649374', "write_uid" = 1088 WHERE id IN (32217550);

Date: 2025-01-29 06:15:22 Duration: 5m44s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-29 05:07:55.629266', "write_uid" = 1088 WHERE id IN (32217550);

Date: 2025-01-29 06:12:15 Duration: 4m18s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-29 04:38:20.213911', "write_uid" = 1088 WHERE id IN (32217550);

Date: 2025-01-29 05:41:20 Duration: 2m58s

17

17m53s

19,619

Details

40ms

277ms

54ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 29	07	26	1s249ms	48ms
	08	202	9s944ms	49ms
	09	1,514	1m16s	50ms
	10	1,537	1m25s	55ms
	11	1,401	1m20s	57ms
	12	4,181	4m2s	58ms
	13	2,923	2m34s	52ms
	14	2,814	2m23s	51ms
	15	2,356	2m12s	56ms
	16	1,635	1m29s	55ms
	17	915	51s612ms	56ms
	18	83	4s245ms	51ms
	19	32	1s530ms	47ms

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

Date: 2025-01-29 15:52:41 Duration: 277ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4797163) ORDER BY "collection_policy"."id";

Date: 2025-01-29 16:11:10 Duration: 266ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4831616) ORDER BY "collection_policy"."id";

Date: 2025-01-29 15:49:45 Duration: 261ms

18

16m27s

4,377

Details

174ms

459ms

225ms

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

Day	Hour	Count	Duration	Avg duration
Jan 29	05	749	2m24s	192ms
	09	826	2m56s	213ms
	10	2,473	9m43s	236ms
	11	121	30s156ms	249ms
	12	34	9s658ms	284ms
	13	105	28s438ms	270ms
	15	38	8s385ms	220ms
	20	31	5s920ms	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" = '9946855')) 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-29 10:51:49 Duration: 459ms
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" = '8888067')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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-29 12:48:47 Duration: 418ms
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" = '9605072')) 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, 12, 20)))) 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, 12, 20))))) 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, 12, 20))))) 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-29 13:11:49 Duration: 388ms

19

15m53s

6,100

Details

119ms

1s99ms

156ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 29	00	44	5s922ms	134ms
	06	5	685ms	137ms
	07	5	662ms	132ms
	08	79	10s599ms	134ms
	09	468	1m7s	143ms
	10	1,103	2m59s	162ms
	11	1,247	3m20s	160ms
	12	948	2m33s	162ms
	13	572	1m28s	155ms
	14	642	1m33s	145ms
	15	216	33s732ms	156ms
	16	140	24s236ms	173ms
	17	236	40s466ms	171ms
	18	103	14s820ms	143ms
	19	83	11s616ms	139ms
	20	54	7s601ms	140ms
	21	114	14s694ms	128ms
	22	41	5s428ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 11)) 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-29 12:49:19 Duration: 1s99ms
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-29 11:07:39 Duration: 956ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-29 15:55:17 Duration: 914ms

20

12m6s

2,584

Details

14ms

2s627ms

280ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 29	00	4	1s346ms	336ms
	01	1	426ms	426ms
	07	16	2s70ms	129ms
	08	51	7s780ms	152ms
	09	123	27s899ms	226ms
	10	203	53s117ms	261ms
	11	346	1m37s	281ms
	12	275	1m23s	302ms
	13	327	1m36s	294ms
	14	294	1m1s	209ms
	15	237	1m9s	294ms
	16	237	1m16s	324ms
	17	172	58s439ms	339ms
	18	115	34s775ms	302ms
	19	66	19s568ms	296ms
	20	63	21s106ms	335ms
	21	30	11s554ms	385ms
	22	24	2s601ms	108ms

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

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

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

Date: 2025-01-29 15:54:19 Duration: 1s791ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,456,716

Details

1m58s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 29	00	38,921	1s938ms	0ms
	01	38,991	1s864ms	0ms
	02	48,935	2s521ms	0ms
	03	48,739	2s440ms	0ms
	04	31,976	1s480ms	0ms
	05	19,907	756ms	0ms
	06	31,493	1s202ms	0ms
	07	26,224	950ms	0ms
	08	65,112	2s710ms	0ms
	09	141,446	6s833ms	0ms
	10	208,992	10s456ms	0ms
	11	225,389	10s537ms	0ms
	12	212,755	9s955ms	0ms
	13	216,095	11s331ms	0ms
	14	193,138	8s789ms	0ms
	15	177,047	8s310ms	0ms
	16	178,625	8s345ms	0ms
	17	155,713	8s566ms	0ms
	18	124,491	6s998ms	0ms
	19	104,947	4s723ms	0ms
	20	73,905	3s238ms	0ms
	21	57,301	2s510ms	0ms
	22	36,574	1s628ms	0ms

DISCARD ALL;

Date: 2025-01-29 09:19:59 Duration: 1ms
DISCARD ALL;

Date: 2025-01-29 11:01:58 Duration: 1ms
DISCARD ALL;

Date: 2025-01-29 10:51:37 Duration: 1ms

2

1,948,971

Details

28s567ms

0ms

18ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 29	00	30,822	465ms	0ms
	01	29,587	446ms	0ms
	02	40,323	608ms	0ms
	03	40,252	589ms	0ms
	04	25,289	375ms	0ms
	05	14,675	218ms	0ms
	06	25,956	341ms	0ms
	07	20,524	273ms	0ms
	08	52,090	686ms	0ms
	09	116,544	1s620ms	0ms
	10	173,489	2s537ms	0ms
	11	185,311	2s515ms	0ms
	12	171,348	2s361ms	0ms
	13	172,108	2s428ms	0ms
	14	149,930	2s79ms	0ms
	15	135,663	1s952ms	0ms
	16	136,236	2s76ms	0ms
	17	123,108	2s230ms	0ms
	18	96,991	1s677ms	0ms
	19	81,349	1s184ms	0ms
	20	56,150	826ms	0ms
	21	43,602	642ms	0ms
	22	27,624	427ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-29 14:47:06 Duration: 18ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-29 13:36:09 Duration: 16ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-29 18:17:14 Duration: 1ms

3

1,251,498

Details

12s848ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 29	00	20,138	184ms	0ms
	01	20,165	180ms	0ms
	02	25,124	240ms	0ms
	03	24,995	235ms	0ms
	04	16,646	151ms	0ms
	05	10,609	91ms	0ms
	06	16,382	149ms	0ms
	07	13,795	122ms	0ms
	08	33,464	290ms	0ms
	09	71,857	697ms	0ms
	10	105,879	1s149ms	0ms
	11	114,216	1s170ms	0ms
	12	107,795	1s123ms	0ms
	13	109,493	1s86ms	0ms
	14	97,947	947ms	0ms
	15	89,748	907ms	0ms
	16	90,885	1s7ms	0ms
	17	79,329	981ms	0ms
	18	63,459	694ms	0ms
	19	53,401	560ms	0ms
	20	37,849	384ms	0ms
	21	29,395	302ms	0ms
	22	18,927	189ms	0ms

ROLLBACK;

Date: 2025-01-29 10:33:29 Duration: 1ms
ROLLBACK;

Date: 2025-01-29 10:34:51 Duration: 0ms
ROLLBACK;

Date: 2025-01-29 16:56:12 Duration: 0ms

4

1,240,344

Details

3m42s

0ms

22ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 29	00	19,469	3s240ms	0ms
	01	19,496	3s202ms	0ms
	02	24,467	4s251ms	0ms
	03	24,372	4s76ms	0ms
	04	15,944	2s720ms	0ms
	05	9,915	1s602ms	0ms
	06	15,687	2s849ms	0ms
	07	13,131	1s952ms	0ms
	08	32,890	5s17ms	0ms
	09	71,528	12s158ms	0ms
	10	105,890	19s536ms	0ms
	11	114,057	19s797ms	0ms
	12	107,731	18s611ms	0ms
	13	109,428	17s861ms	0ms
	14	97,528	15s947ms	0ms
	15	89,357	15s68ms	0ms
	16	90,352	16s524ms	0ms
	17	78,886	17s206ms	0ms
	18	62,837	13s293ms	0ms
	19	52,827	10s712ms	0ms
	20	37,294	7s589ms	0ms
	21	28,873	5s791ms	0ms
	22	18,385	3s497ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'b126eda46e1ede9eac63d0479ce675940d43b67a';

Date: 2025-01-29 14:01:23 Duration: 22ms
SELECT payload FROM http_sessions WHERE sid = '00ca13b8bf727fec81794204806e1c327401e17b';

Date: 2025-01-29 16:17:07 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = 'b709e35b10dac2f1cadec33ff7b65e808d7edd3b';

Date: 2025-01-29 11:07:02 Duration: 17ms

5

1,228,282

Details

1m52s

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 29	00	19,526	1s696ms	0ms
	01	19,572	1s661ms	0ms
	02	24,522	2s192ms	0ms
	03	24,432	2s128ms	0ms
	04	16,028	1s366ms	0ms
	05	10,000	822ms	0ms
	06	15,777	1s380ms	0ms
	07	13,190	1s86ms	0ms
	08	32,564	2s598ms	0ms
	09	70,660	6s119ms	0ms
	10	104,422	10s84ms	0ms
	11	112,635	10s276ms	0ms
	12	106,319	9s807ms	0ms
	13	107,986	9s518ms	0ms
	14	96,481	8s522ms	0ms
	15	88,483	8s28ms	0ms
	16	89,243	8s583ms	0ms
	17	77,784	8s257ms	0ms
	18	62,228	5s954ms	0ms
	19	52,458	4s919ms	0ms
	20	36,937	3s440ms	0ms
	21	28,722	2s578ms	0ms
	22	18,313	1s556ms	0ms

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

Date: 2025-01-29 00:13:14 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

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

Date: 2025-01-29 16:47:27 Duration: 1ms

6

904,925

Details

2m17s

0ms

14ms

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 29	00	14,367	2s121ms	0ms
	01	12,678	1s909ms	0ms
	02	16,883	2s720ms	0ms
	03	17,206	2s682ms	0ms
	04	9,805	1s628ms	0ms
	05	4,547	836ms	0ms
	06	12,273	1s727ms	0ms
	07	8,119	1s176ms	0ms
	08	24,456	3s359ms	0ms
	09	59,432	8s718ms	0ms
	10	89,571	14s41ms	0ms
	11	93,530	13s556ms	0ms
	12	83,193	12s248ms	0ms
	13	82,201	12s621ms	0ms
	14	68,665	9s743ms	0ms
	15	61,156	9s169ms	0ms
	16	58,945	9s280ms	0ms
	17	57,208	10s215ms	0ms
	18	43,734	7s75ms	0ms
	19	35,620	4s812ms	0ms
	20	22,462	3s151ms	0ms
	21	17,700	2s559ms	0ms
	22	11,174	1s652ms	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 (882);

Date: 2025-01-29 12:57:37 Duration: 14ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (953);

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

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

7

696,434

Details

2m

0ms

45ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 29	00	10,709	1s857ms	0ms
	01	9,424	1s748ms	0ms
	02	15,198	1s768ms	0ms
	03	15,257	1s890ms	0ms
	04	8,590	1s520ms	0ms
	05	4,028	605ms	0ms
	06	9,531	1s510ms	0ms
	07	6,728	951ms	0ms
	08	18,619	2s642ms	0ms
	09	44,631	6s921ms	0ms
	10	67,514	12s433ms	0ms
	11	70,976	12s61ms	0ms
	12	63,466	11s378ms	0ms
	13	62,588	10s381ms	0ms
	14	51,912	8s243ms	0ms
	15	45,793	7s806ms	0ms
	16	45,232	8s319ms	0ms
	17	43,765	8s996ms	0ms
	18	33,516	6s203ms	0ms
	19	27,869	5s72ms	0ms
	20	18,200	3s525ms	0ms
	21	14,214	2s625ms	0ms
	22	8,674	1s597ms	0ms

COMMIT;

Date: 2025-01-29 10:34:49 Duration: 45ms
COMMIT;

Date: 2025-01-29 12:52:12 Duration: 39ms
COMMIT;

Date: 2025-01-29 17:47:30 Duration: 33ms

8

543,340

Details

1m14s

0ms

13ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 29	00	9,632	1s246ms	0ms
	01	8,430	1s54ms	0ms
	02	6,669	739ms	0ms
	03	6,322	759ms	0ms
	04	5,235	563ms	0ms
	05	2,784	318ms	0ms
	06	10,080	1s323ms	0ms
	07	3,584	469ms	0ms
	08	13,420	1s602ms	0ms
	09	36,295	4s804ms	0ms
	10	54,646	7s994ms	0ms
	11	56,238	8s16ms	0ms
	12	48,962	7s60ms	0ms
	13	48,082	6s570ms	0ms
	14	40,446	5s653ms	0ms
	15	35,487	4s953ms	0ms
	16	34,221	5s254ms	0ms
	17	35,907	5s691ms	0ms
	18	27,602	3s741ms	0ms
	19	23,308	2s722ms	0ms
	20	15,317	1s830ms	0ms
	21	11,674	1s249ms	0ms
	22	8,999	994ms	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 (5112107, 5099013, 5099224, 5099677, 5188356, 5100762, 5099867, 5098974, 5099289, 5099009, 5099642, 5099243, 5099103, 5104745, 5099006, 5099403, 5099590, 5099141, 5099727, 5099138, 5099035, 5496757, 5099007, 5116487, 5101741, 5101594, 5243969, 5208539, 5099858, 5100952, 5100004, 5099003, 5269048, 5106217, 5100431, 5099693, 5099254, 5099263, 5106336, 5099181, 5099008, 5103117, 5099540, 5099582, 5496756, 5099848, 5121781, 5099264, 5104970, 5226609, 5099725, 5103000, 5099028, 5099170, 5100005, 5100950, 5105829);

Date: 2025-01-29 15:39:24 Duration: 13ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099009, 5117545, 5099558, 5108472, 5099013, 5099590, 5099334, 5099007, 5099287, 5099947, 5102937, 5099028, 5099138, 5099194, 5109553, 5099206, 5099203, 5496909, 5099404, 5104782, 5107184, 5101447, 5099236, 5099807, 5102416, 5099529, 5101829, 5496907, 5099250, 5331208, 5099187, 5110873, 5108914, 5099198, 5114728, 5099403, 5099568, 5099035, 5252342, 5474482, 5099103, 5153699, 5099503, 5196342, 5099095);

Date: 2025-01-29 17:21:55 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 (5107475, 5103356, 5099158, 5099244, 5099643, 5099111, 5099174, 5102221, 5099356, 5099660, 5099169, 5100132, 5103944, 5099006, 5102063, 5099525, 5099144, 5099348, 5101701, 5178872, 5101120, 5100004, 5101298, 5496908, 5099129, 5099415, 5104127, 5099119, 5100123, 5099540, 5139515, 5099651, 5145869, 5099010, 5100070, 5196590, 5113778, 5496906, 5099027, 5100898, 5099248, 5100610, 5100723, 5109254, 5099873, 5099333, 5099445, 5099714, 5100897, 5100052, 5111111, 5122508, 5099921, 5106238, 5272518, 5118782, 5166211, 5232873, 5160762);

Date: 2025-01-29 17:21:55 Duration: 4ms

9

535,893

Details

37s307ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 29	00	7,251	420ms	0ms
	01	6,301	361ms	0ms
	02	4,587	279ms	0ms
	03	4,749	280ms	0ms
	04	3,479	202ms	0ms
	05	1,614	92ms	0ms
	06	8,014	434ms	0ms
	07	4,379	224ms	0ms
	08	13,388	718ms	0ms
	09	35,251	2s254ms	0ms
	10	54,235	4s232ms	0ms
	11	58,754	4s121ms	0ms
	12	50,363	3s646ms	0ms
	13	50,610	3s350ms	0ms
	14	40,356	2s741ms	0ms
	15	35,529	2s551ms	0ms
	16	35,358	2s909ms	0ms
	17	34,891	3s37ms	0ms
	18	27,593	1s848ms	0ms
	19	23,886	1s485ms	0ms
	20	15,439	938ms	0ms
	21	12,441	723ms	0ms
	22	7,425	450ms	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 (17);

Date: 2025-01-29 04:13:38 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 (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);

Date: 2025-01-29 11:06:21 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 (7, 61, 83, 48, 127, 13, 73, 22, 4);

Date: 2025-01-29 17:49:55 Duration: 1ms

10

385,595

Details

2m9s

0ms

3ms

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 29	00	2,794	850ms	0ms
	01	2,028	628ms	0ms
	02	1,818	564ms	0ms
	03	1,403	447ms	0ms
	04	1,131	349ms	0ms
	05	1,414	395ms	0ms
	06	2,850	841ms	0ms
	07	1,683	486ms	0ms
	08	8,463	2s443ms	0ms
	09	19,871	6s421ms	0ms
	10	39,213	14s62ms	0ms
	11	43,926	14s902ms	0ms
	12	37,405	13s77ms	0ms
	13	38,319	12s304ms	0ms
	14	33,952	10s938ms	0ms
	15	28,656	9s714ms	0ms
	16	32,628	11s870ms	0ms
	17	28,968	11s280ms	0ms
	18	15,301	5s183ms	0ms
	19	19,780	6s29ms	0ms
	20	12,993	3s769ms	0ms
	21	7,204	2s123ms	0ms
	22	3,795	1s90ms	0ms

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

Date: 2025-01-29 12:18:44 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.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 = 852) OR r.global) ORDER BY r.id;

Date: 2025-01-29 12:18:44 Duration: 3ms
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 = 843) OR r.global) ORDER BY r.id;

Date: 2025-01-29 10:06:58 Duration: 3ms

11

374,308

Details

1m13s

0ms

3ms

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 29	00	5,043	792ms	0ms
	01	4,245	699ms	0ms
	02	2,776	524ms	0ms
	03	3,021	555ms	0ms
	04	2,091	413ms	0ms
	05	1,757	287ms	0ms
	06	4,609	841ms	0ms
	07	2,971	466ms	0ms
	08	11,396	1s741ms	0ms
	09	25,861	4s609ms	0ms
	10	37,074	7s918ms	0ms
	11	39,219	7s919ms	0ms
	12	36,053	7s215ms	0ms
	13	35,054	6s556ms	0ms
	14	29,784	5s500ms	0ms
	15	27,299	5s283ms	0ms
	16	25,908	5s759ms	0ms
	17	24,818	5s745ms	0ms
	18	18,191	3s570ms	0ms
	19	15,260	2s861ms	0ms
	20	9,522	1s784ms	0ms
	21	7,606	1s399ms	0ms
	22	4,750	798ms	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 (8006468, 8007030, 8006752, 8006453, 8007423, 8006367, 8006302, 8006311, 8004671, 8006472, 8006455);

Date: 2025-01-29 17:21:55 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 (8007451);

Date: 2025-01-29 17:21:55 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 (8006356);

Date: 2025-01-29 17:21:55 Duration: 3ms

12

299,579

Details

56s459ms

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 29	00	2,999	427ms	0ms
	01	2,467	327ms	0ms
	02	2,125	292ms	0ms
	03	1,878	255ms	0ms
	04	1,387	184ms	0ms
	05	1,758	231ms	0ms
	06	2,620	383ms	0ms
	07	2,205	306ms	0ms
	08	9,422	1s344ms	0ms
	09	17,235	2s961ms	0ms
	10	28,927	6s13ms	0ms
	11	30,386	6s110ms	0ms
	12	26,873	5s453ms	0ms
	13	28,583	5s302ms	0ms
	14	25,582	4s647ms	0ms
	15	22,303	4s200ms	0ms
	16	25,787	5s511ms	0ms
	17	22,913	5s120ms	0ms
	18	10,660	1s901ms	0ms
	19	14,659	2s500ms	0ms
	20	9,729	1s610ms	0ms
	21	5,316	827ms	0ms
	22	3,765	544ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 1089 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_track_search' AND name = 'group_search_training_shipping' AND model = 'res.groups');

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

Date: 2025-01-29 13:16:13 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 856 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_cash_policy' AND name = 'receive_main_office' AND model = 'res.groups');

Date: 2025-01-29 17:41:06 Duration: 1ms

13

267,625

Details

1d22h47m29s

512ms

5s843ms

629ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 29	00	8,441	1h19m40s	566ms
	01	7,632	1h11m11s	559ms
	02	9,434	1h28m57s	565ms
	03	7,846	1h12m41s	555ms
	04	8,383	1h18m18s	560ms
	05	3,747	35m43s	571ms
	06	8,220	1h18m17s	571ms
	07	3,000	27m8s	542ms
	08	4,969	45m28s	549ms
	09	12,179	2h1m32s	598ms
	10	20,646	3h45m17s	654ms
	11	18,005	3h13m17s	644ms
	12	17,340	3h4m53s	639ms
	13	14,664	2h33m8s	626ms
	14	11,732	1h58m30s	606ms
	15	11,563	2h3m22s	640ms
	16	21,655	4h6m14s	682ms
	17	23,448	4h47m31s	735ms
	18	17,028	3h2m20s	642ms
	19	11,853	2h4m49s	631ms
	20	11,669	2h3m1s	632ms
	21	8,227	1h24m3s	613ms
	22	5,944	1h1m59s	625ms

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

Date: 2025-01-29 17:50:03 Duration: 5s843ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4885741)) AND (("shipping_track"."id" not in (40503074, 40503074)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:49:49 Duration: 5s466ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4885800)) AND (("shipping_track"."id" not in (40503327, 40503327)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:50:22 Duration: 5s181ms

14

247,132

Details

1m4s

0ms

30ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 29	00	4,175	1s16ms	0ms
	01	3,444	834ms	0ms
	02	3,244	788ms	0ms
	03	2,553	638ms	0ms
	04	2,423	632ms	0ms
	05	1,645	449ms	0ms
	06	4,679	1s457ms	0ms
	07	1,462	388ms	0ms
	08	5,387	1s254ms	0ms
	09	14,365	3s755ms	0ms
	10	22,162	6s183ms	0ms
	11	24,130	6s533ms	0ms
	12	21,156	5s676ms	0ms
	13	21,967	5s393ms	0ms
	14	18,314	4s403ms	0ms
	15	16,451	4s218ms	0ms
	16	16,849	4s459ms	0ms
	17	16,740	5s229ms	0ms
	18	13,127	3s422ms	0ms
	19	11,684	2s814ms	0ms
	20	8,960	2s252ms	0ms
	21	6,308	1s523ms	0ms
	22	5,907	1s238ms	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 (41637118, 41527351, 32247500, 41527348, 32274095, 32199433, 42162279, 42176122, 32264096, 41798371, 32262801, 32220723, 32247549, 42106469, 32311151, 42172983, 32273542, 32198834, 42052267, 42053232, 32199882, 42153185, 42119248, 41798523, 42040953, 40294403, 40294402, 41527337, 32306493, 42150221, 42105187, 32218766, 32218767, 32248269, 32198826, 42106299, 42105781, 42133803, 32199581, 32199578, 32197355, 32259313, 40885334, 32238248, 32218770, 32240491, 42001813, 42172979, 32250824, 32306641, 32239173, 32239956, 32343642, 32204780, 32294459, 32301722, 32315706, 42173813, 32238921, 32307550, 32258018, 32309769, 32309748, 32247882, 41838384, 41958630, 32284976, 32284239, 41526760, 32262951, 32276216, 41787327, 32256476, 32302042, 32663110, 32316285, 32264092, 42125818, 32238736, 41714129, 32256816, 32663516, 32306136, 32325645, 42152223, 32247909, 32263448, 32222413, 41958627, 32331702, 32663180, 32272111, 32238838, 32283855, 32283913, 42126726, 32223038, 41903627, 41539105, 42086305, 41120369, 32270402, 42125996, 42176130, 32263506, 32250077, 32305650, 32306110, 42060923, 32354868, 42141866, 42085524, 32325706, 32283592, 32284094, 32355923, 32223017, 32246597, 32238218, 32277595, 42009356, 41754267, 42174750, 42174152, 32308006, 42044638, 32299374, 32281328, 32359167, 42173824, 32256478, 32256477, 32275144, 41958628, 32202556, 32260523, 32354760, 32259572, 32355911, 32355900, 32355899, 42132384, 42085518, 41771171, 32233344, 41526912, 42153968, 42126808, 42140241, 32204059, 42096987, 42031354, 32234123, 42173815, 32322715, 32298916, 32206101, 32237438, 42074366, 41777681, 32307359, 32248187, 32248178, 32313026, 32313095, 32273594, 32273589, 42090724, 32219762, 32304714, 32222744, 32218177, 32262002, 32247822, 32247196, 32247198, 32291231, 32341754, 32201161, 32312932, 32312949, 32251495, 32356378, 41473450, 32272089, 42152047, 32210059, 32206018, 32277603, 32214577, 32247837, 32247639, 32203939, 32256818, 42125814, 32256805, 32188398, 32222864, 32201725, 32306121, 42149789, 32326297, 32291488, 42146492, 32326173, 42125451, 42021038, 42162974, 32324014, 32324015, 32246910, 32240476, 32198302, 32246681, 42130907, 32271981, 41527336, 32282111, 32271682, 42125899, 32276042, 32298910, 42088918, 42164603, 32237565, 32276017, 32275151, 32307107, 32663171, 41996130, 32291217, 32258680, 42097165, 32199414, 42078346, 42148387, 41911158, 32203928, 32236823, 32318302, 32244928, 42088903, 32286793, 32252987, 32317469, 32304693, 42173810, 32378796, 42042319, 32315784, 32262011, 32223503, 32310661, 32355961, 32309761, 42175632, 32275078, 42152253, 42173478, 32354788, 32330584, 32296156, 42031090, 32267224, 32356511, 32283614, 32330643, 32279212, 32223612, 32248474, 32310003, 32356606, 42141856, 32258683, 41665501, 32291457, 32282850, 41958487, 32200649, 41771113, 32275147, 32325923, 32354764, 41688162, 32291253, 32325955, 32291207, 32291485, 41527146, 32251295, 32264494, 32326457, 42148584, 32313508, 32313265, 32354988, 32220960, 42169727, 42044640, 32183362, 42175074, 42089038, 42088408, 32306943, 42168439, 32238734, 32344325, 32243421, 32355992, 32273512, 32293948, 42162222, 32275007, 32200107, 32202520, 42129291, 41911201, 32238238, 32203073, 32663178, 32283357, 32258671, 42103502, 32281483, 32341778, 32331941, 32276045, 32654238, 32354201, 42174748, 32262010, 32183361, 42176892, 32223052, 32352713, 32306320, 32291198, 32273582, 32325277, 32306729, 32284978, 32331689, 32356500, 32248211, 32282671, 42146337, 42036027, 42106434, 42106455, 32354150, 32352668, 32263208, 32330710, 32291540, 32273293, 32238267, 32260454, 32264861, 32359198, 32666625, 32358642, 42175201, 42155244, 32238741, 32297938, 32283348, 32265469, 42154126, 32198836, 32210331, 32183555, 32662883, 32274643, 32240512, 42147726, 42085985, 32247030, 42151418, 32663905, 32195158, 42125802, 42132372, 32665062, 41836256, 42128992, 32664807, 41690370, 41693557, 41853500, 32288698, 32299309, 32317604, 42071355, 41252081, 32298899, 32210848, 32210828, 32295211, 32356477, 32325099, 32257974, 32308729, 32264636, 32258721, 32310713, 42102388, 32198828, 32272772, 42146404, 42162037, 32313429, 32246598, 32239529, 32275097, 41861711, 32239132, 41932047, 42146321, 32281004, 32283130, 32298301, 42069220, 41928031, 32290661, 32288024, 32301706, 41967956, 32287099, 32279498, 32237560, 32283993, 42106579, 32306451, 32357742, 42139084, 32306254, 32291241, 32325300, 42125222, 41993517, 32236844, 32326736, 32220726, 41999984, 42089684, 32290670, 32323776, 42145413, 32257964, 32311392, 42174764, 42154804, 42032900, 32320145, 42015441, 32295003, 32359345, 32198217, 42078377, 32221497, 32354782, 40959335, 32283173, 32274157, 32240496, 42169734, 42106529, 42161630, 32316392, 32316574, 32301708, 41803828, 42146415, 32318320, 32266656, 32315718, 32315912, 42164388, 32210125, 32268688, 32263418, 32291440, 32316511, 32315772, 41730538, 32253900, 42032671, 32300815, 42163972, 32330082, 32284899, 32262091, 32373306, 32325329, 32324634, 32200616, 42050369, 32355655, 41995990, 32272421, 32276988, 41803711, 42151319, 42082053, 32353676, 42141870, 32221500, 32198837, 32298536, 32274410, 32304766, 42154468, 42141853, 32212069, 42174153, 32299325, 32281528, 42105207, 42105210, 32257979, 32210859, 32204740, 32274719, 32274106, 42084813, 32359151, 32305998, 32222416, 32199584, 32199586, 32199582, 41953789, 32247408, 41803829, 42063091, 32247160, 32222060, 32330654, 32222000, 42173139, 32355912, 32330653, 32355901, 32355914, 42173852, 32316244, 41932307, 42152353, 32301777, 32281580, 32252949, 32250407, 32322668, 32276007, 32262104, 41958428, 32356535, 32247830, 32354656, 32295191, 32313029, 32248532, 42152262, 32260503, 32272115, 42146421, 32324611, 42132383, 42133752, 32260296, 42176718, 41200587, 32266596, 32250978, 42135014, 42050416, 32352647, 42127527, 32256815, 32306123, 42105204, 41714130, 32274549, 32271775, 32220414, 32257695, 32247981, 41816368, 32276016, 41884770, 32301731, 32238966, 32247519, 42038297, 32262114, 42145887, 32271959, 32282107, 32667364, 32281120, 42105577, 32299582, 41771119, 32281594, 41954583, 32343673, 32310669, 32300721, 32299193, 32356288, 40507853, 41943298, 42176315, 32268891, 32233337, 32228505, 41799677, 32294352, 32273138, 42071346, 32256799, 32283078, 32318189, 32210376, 32267570, 32316180, 32284893, 32301774, 32315762, 32307559, 41159222, 32222745, 32222742, 42175628, 41885259, 32326078, 32210820, 32295227, 32273770, 42125456, 32201832, 32201175, 42097158, 32273606, 32221374, 42154444, 42133819, 42102856, 32312917, 32203182, 32331696, 42071343, 41327734, 32324635, 32295667, 32241435, 32260530, 32258016, 42134995, 32257707, 32221525, 32325291, 32316470, 32346846, 32281241, 32317606, 32237559, 32354151, 42088915, 32276023, 32241351, 32302305, 32264857, 32356541, 32309763, 32299307, 42106599, 32354980, 42170950, 32313538, 32248533, 32258731, 32273956, 41838571, 41967964, 32223599, 32262097, 32273843, 32283140, 32248188, 42161448, 42125463, 32291525, 41798363, 32219972, 42135141, 32339697, 32296602, 42176931, 32326448, 41960960, 42152245, 32290648, 41911227, 32316465, 32259466, 32325106, 32326050, 32247571, 41159224, 32359160, 32359161, 32283190, 42106522, 32355891, 32354642, 32197439, 32240148, 32324550, 32341679, 42152214, 32356253, 42148581, 42151968, 32274698, 42069622, 42134843, 42134844, 40757490, 40757489, 42103053, 32269146, 41960956, 32305857, 41851139, 32222528, 41911216, 32287125, 32316620, 42174755, 32304670, 32211143, 32300718, 32211063, 32658018, 32247826, 41527513, 32262873, 32263214, 32326361, 32306104, 32359398, 32274006, 42133715, 32325351, 32325350, 32220617, 32306000, 42103312, 41803830, 32238208, 42096407, 32262717, 32231734, 41960955, 32356290, 41973530, 32220792, 32330581, 42176172, 41417708, 32248222, 32314892, 32252683, 32302334, 32302304, 32339698, 41803831, 32227634, 41967961, 32320193, 32261857, 42078733, 32239222, 32274781, 32247197, 32201830, 32273537, 32284340, 41771160, 42093434, 32239017, 32273554, 42037686, 32223160, 42095938, 32326187, 42024437, 32294969, 32286843, 32183453, 32307349, 32313608, 32663002, 42061636, 32317467, 32326188, 32221446, 32227553, 32316580, 32316283, 32315929, 32317544, 32237437, 32228629, 42175038, 32323890, 41908639, 32243267, 32295152, 32325308, 32283571, 32354890, 32222027, 32306323, 32354749, 32221381, 32187234, 42069908, 32263446, 32306250, 32180653, 32356359, 41911238, 42162294, 42163460, 32197296, 32324071, 32238207, 32271973, 32220992, 41537726, 42125346, 32182161, 41982312, 32215938, 41992418, 41835935, 32273985, 42173857, 42078317, 32305670, 41934955, 32283187, 32223578, 42105384, 32306447, 32287134, 32234321, 32247925, 32273611, 32239987, 32301306, 32276132, 32247613, 42056905, 32259486, 42038155, 41806235, 32288065, 38745450, 32629938, 32294454, 32285142, 42175040, 41884192, 32325400, 32257710, 32306268, 32306255, 32247726, 41693488, 32260616, 32260614, 32326181, 32273954, 32305794, 32220326, 32237461, 42175197, 32273814, 32198823, 42085487, 42076555, 32294412, 32316011, 32315982, 32204074, 32273640, 32264860, 32260598, 32197312, 32275874, 32304116, 42164931, 42030164, 32330592, 32288063, 42063578, 42164302, 32225944, 32288283, 32299326, 32280988, 32300102, 32287133, 32286842, 32252720, 32220216, 32258960, 32313103, 32221378, 32359293, 32203804, 42178419, 42106390, 41885260, 32290682, 32220215, 32309758);

Date: 2025-01-29 17:22:22 Duration: 30ms
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 (42073113, 42131231, 32214651, 42151768, 42136304, 41934306, 32219795, 42136823, 42058161, 42151766, 41575542, 41230248, 42117728, 41996803, 42102928, 41696212, 41836196, 41991210, 41862537, 42085968, 41991591, 41981997, 42110565, 42044297, 42058069, 42135799, 42090091, 32651750, 42014796, 42075397, 42057698, 42089975, 42111361, 41991292, 42110566, 42128846, 42058103, 41723254, 42119225, 41202972, 41840268, 42061455, 41936446, 42119219, 42058576, 42077028, 42111200, 42058546, 42054654, 42021250, 41723280, 42130196, 42030506, 42058053, 41904605, 41873299, 42119214, 42034490, 32213093, 42129245, 42062012, 40504332, 41988691, 40001324, 32261033, 41960698, 42002787, 32271743, 42171666, 42088421, 41928229, 42162948, 42032102, 42051536, 41891195, 42118910, 42158125, 32178642, 32259906, 42058222, 42112815, 41798515, 42092051, 42129385, 42142069, 42060892, 41900982, 42058208, 42119213, 41574883, 42057741, 41664994, 41834547, 41188924, 41987513, 32241404, 42073178, 42058142, 41792573, 41908053);

Date: 2025-01-29 17:21:56 Duration: 23ms
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 (32275567, 32269951, 32306536, 32240162, 42054722, 32361178, 32361243, 32305774, 32238977, 42168372, 32306007, 41993369, 32298786, 32307569, 42125183, 42131526, 32258029, 42130929, 32258493, 42078397, 32275450, 32275178, 32275496, 32204034, 32307621, 32307021, 32306564, 42150588, 32264197, 42125676, 42162986, 32231367, 32237957, 42126741, 42126661, 41714842);

Date: 2025-01-29 17:21:55 Duration: 11ms

15

186,657

Details

16s516ms

0ms

2ms

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 29	00	2,891	179ms	0ms
	01	2,683	171ms	0ms
	02	1,812	120ms	0ms
	03	2,062	136ms	0ms
	04	1,391	93ms	0ms
	05	635	42ms	0ms
	06	2,862	167ms	0ms
	07	1,347	79ms	0ms
	08	4,699	266ms	0ms
	09	12,735	926ms	0ms
	10	19,430	1s890ms	0ms
	11	20,532	1s817ms	0ms
	12	17,922	1s909ms	0ms
	13	17,243	1s532ms	0ms
	14	14,543	1s115ms	0ms
	15	12,811	1s153ms	0ms
	16	12,067	1s377ms	0ms
	17	12,132	1s574ms	0ms
	18	9,354	637ms	0ms
	19	7,420	510ms	0ms
	20	4,198	336ms	0ms
	21	3,459	278ms	0ms
	22	2,429	197ms	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-29 17:21:55 Duration: 2ms
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-29 17:21:55 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-01-29 13:11:14 Duration: 1ms

16

175,578

Details

1m39s

0ms

29ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,328	874ms	0ms
	01	779	490ms	0ms
	02	197	123ms	0ms
	03	222	131ms	0ms
	04	174	110ms	0ms
	05	74	55ms	0ms
	06	528	242ms	0ms
	07	735	309ms	0ms
	08	2,064	1s9ms	0ms
	09	5,739	3s434ms	0ms
	10	10,664	6s801ms	0ms
	11	9,394	5s757ms	0ms
	12	14,196	8s636ms	0ms
	13	12,763	8s98ms	0ms
	14	16,303	9s275ms	0ms
	15	19,846	10s809ms	0ms
	16	29,719	16s44ms	0ms
	17	25,609	14s655ms	0ms
	18	17,818	8s293ms	0ms
	19	3,481	1s970ms	0ms
	20	1,521	975ms	0ms
	21	1,578	744ms	0ms
	22	846	572ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (2162208, 2147652, 2149970, 2295108, 4307953, 2635607, 2635609, 2484764, 2355883, 3270199, 4307961, 3857488, 2635612, 2484750, 3857487, 2635606, 2635610, 4600623, 3338587, 3338586, 3338588, 3338589, 3722029, 3484298, 3491861, 3484290, 3484300, 3150157, 3384662, 3384668, 4316554, 3606221, 4777065, 4509932, 3378380, 3568563, 1604079, 829954, 4660563, 1885494, 1344695, 2671331, 4048987, 3492766, 2711313, 1055074, 2258590, 1338955, 1433209, 4015983, 3418921, 1199584, 2117869, 2803484, 4132602, 1704644, 3346111, 1659123, 1044565, 1019368, 1999896, 3040187, 1472993, 3229868, 2711318, 1014180, 1522829, 2117872, 4105890, 3182303, 3336667, 4015991, 3530546, 2436033, 1882975, 2234352, 2982285, 2196389, 2436035, 3116962, 3755948, 4312584, 2982286, 4015994, 3084794, 2467416, 1273370, 2480796, 2795218, 1766167, 1757432, 4256015, 2436032, 2436026, 2761304, 2258532, 2436034, 2436030, 4569912, 2857249, 2857247, 2795260, 1259306, 2795275, 2436031, 2697054, 1529152, 2697064, 2697038, 3831837, 3722033, 3038464, 1330109, 2791006, 4457812, 4506428, 2576464, 4260054, 3592104, 2365550, 1427533, 4389482, 2438222, 544088, 2399740, 1659114, 3722036, 2922316, 2950057, 2922320, 4569911, 4015980, 2436029, 3722063, 954069, 2576308, 4132513, 2922327, 4242065, 1055077, 2373352, 2922339, 1085292, 1766165, 3152254, 2922343, 1124203, 2469462, 1522792, 1014138, 3253836, 2982234, 1225184, 2853051, 2149826, 1929392, 3871933, 1273368, 1015147, 4256013, 3337038, 2982283, 1993262, 2277003, 1088841, 3960510, 2277023, 2635880, 2803489, 4207105, 2436038, 950370, 954193, 4256014, 4337884, 3755977, 3937099, 2468092, 2234311, 2693125, 1601963, 4121810, 3344215, 2373286, 1993266, 1273365, 1993263, 3960508, 2436025, 3740557, 4017994, 678841, 3349250, 2234375, 986628, 2658417, 1659117, 4242063, 2866014, 2850907, 2436022, 1601962, 2795247, 1729034, 4389491, 4051522, 1344699, 3755974, 1964584, 1838345, 2857244, 1017761, 2950058, 2478534, 2924960, 3755981, 2922332, 4579023, 4159264, 4347592, 3614992, 2857241, 3687574, 4015988, 3182301, 1838346, 2467962, 3461530, 3844713, 2436028, 909641, 1088842, 1266888, 2397179, 4236405, 3896883, 2162231, 2305400, 2305413, 1273355, 4207104, 3078045, 4018015, 1120919, 3453138, 2922334, 3073323, 4637712, 1124153, 2515976, 1477873, 1929334, 2958273, 2982231, 3749358, 3973833, 3900593, 1574394, 1298254, 4456693, 1261617, 1298261, 3896880, 2032309, 1165395, 2162230, 4104508, 2966197, 1199645, 4827812, 4497594, 4407040, 4770434, 4727728, 4661944, 4697841, 4340669, 4719044, 4660525, 4287751, 4729386, 4821586, 4697845, 4340664, 4456694, 1694096, 1304688, 2448883, 4534797, 2566535, 1948916, 4096037, 4286554, 4791156, 1951279, 4255713, 3253808, 1873455, 2625161, 1658183, 2922305, 4073541, 4073542, 2359066, 3725050, 986934, 1950101, 3959965, 2235230, 1873464, 4528275, 2359069, 2625182, 3116950, 3253531, 3482775, 3870984, 3218916, 2922312, 1950095, 4601392, 4051549, 2922309, 3725053, 4288389, 4378442, 2359063, 4378444, 4123660, 3870982, 4040336, 4497620, 2761096, 3752941, 2258575, 2218509, 4601399, 2700960, 2359072, 2625164, 3448549, 2625162, 4123659, 2236262, 2474552, 3521791, 1836498, 1724884, 4601396, 4338546, 4719135, 4665334, 4426557, 1837559, 1837567, 1015226, 1830303, 1757212, 1702111, 1950139, 911319, 3289218, 2625170, 2563987, 1702143, 1124182, 2625174, 1229346, 2147626, 1757210, 1124076, 1702129, 2469492, 2862909, 2625172, 1195898, 1950140, 1229399, 3577233, 2147629, 1724821, 1702145, 2563984, 1088725, 1702127, 2469491, 2866045, 2866042, 2147624, 1613068, 2258579, 2914734, 1988081, 1702132, 2866050, 987434, 1724822, 2147637, 2184066, 1830301, 2625175, 2184063, 1702141, 1830316, 1960188, 2563991, 1054809, 1724816, 2862912, 912010, 2563985, 2955238, 1601868, 3963402, 1199874, 1838977, 3937062, 2300181, 3937061, 1960164, 911434, 2478934, 2407125, 3187639, 2235937, 2235876, 2235922, 4453654, 3016300, 3016297, 3016299, 2120268, 2194146, 2871260, 1199929, 2112514, 2184681, 1112648, 4338548, 3257604, 1112650, 932515, 957483, 1112647, 4500097, 3789754, 3379506, 1568206, 4455589, 3257603, 2114150, 3257602, 3959964, 2692355, 1568202, 2508932, 2353398, 1568200, 2625131, 2625129, 2184686, 1601941, 1116274, 3257606, 2508930, 3379503, 2625125, 4766298, 1757232, 3452779, 4460438, 3011770, 2184416, 4347660, 1054735, 4017723, 4260104, 4465880, 2742239, 1952514, 4407541, 3344149, 2188834, 2231154, 3188815, 2149843, 4308579, 2180748, 2469018, 2621234, 1875614, 4126844, 2112526, 2561041, 4379071, 4378439, 2056928, 1112682, 2297522, 3071082, 2225358, 1952550, 4720149, 2188577, 2568321, 2950113, 986782, 2950115, 2188579, 2405331, 2568318, 3959951, 4234374, 2949561, 2784827, 3041268, 4537439, 3749291, 4537435, 2627546, 4391522, 3264805, 3749295, 3392745, 2195370, 4132432, 1124174, 2478451, 2701383, 4316433, 3264808, 1124193, 3749278, 4048909, 3527291, 3084431, 3389215, 4349772, 2399686, 4610783, 3131279, 2359080, 3614850, 4452900, 4425802, 2469481, 3084440, 3131281, 4316429, 1724900, 2359108, 2627548, 2627559, 4425819, 2399694, 2399702, 2627556, 2862896, 3389214, 3527295, 2627560, 3527296, 1121006, 3389212, 4316428, 4316436, 987417, 2478482, 3084435, 3614844, 3614846, 4610786, 3392695, 2399690, 2627553, 3214009, 4344050, 4453822, 3494631, 3084471, 2308421, 2234233, 2359090, 2300106, 4048906, 2120257, 2300107, 2359091, 2234245, 2701424, 2236665, 4610787, 2359088, 2747488, 2359086, 2234152, 3131280, 1728836, 4349836, 2234140, 4048925, 3614853, 2627561, 2195397, 1164890, 3749302, 3749284, 4316431, 1724897, 4391530, 1724903, 3527294, 2300109, 4349751, 3084428, 3131290, 4316427, 2627554, 2359102, 2234132, 3131283, 3264804, 3605253, 3131288, 3389213, 4048920, 2399705, 3614834, 2399688);

Date: 2025-01-29 12:24:36 Duration: 29ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (1220751, 2826085, 1761967, 1668548, 1354786, 1792279, 1489772, 1742868, 2026377, 3075330, 1830622, 1830452, 1429622, 1830545, 3712854, 1752859, 1957944, 1273797, 1801305, 1789877, 1810835, 1725383, 1710159, 1829106, 1469772, 1882294, 1802115, 1788759, 1573235, 1762660, 2099540, 2267554, 1612649, 1707730, 1740521, 1708525, 1705697, 1259357, 1722984, 1690398, 712346, 1830430, 1881612, 1343545, 1723914, 1748420, 1765301, 1282201, 1728103, 1758715, 1697778, 2338526, 1713548, 1881778, 4381300, 1593075, 1583362, 1762690, 1792621, 1755048, 1762681, 1926124, 2031805, 1762689, 1830560, 1828966, 1985122, 2153066, 2148602, 2195117, 2180359, 2197215, 1792805, 2133479, 2090657, 2121546, 2121804, 2194963, 2073874, 2122405, 2151834, 1835801, 1792914, 1824536, 1656962, 1761961, 1796429, 1614391, 1614445, 1051288, 1755066, 1755067, 1690102, 1668064, 1700082, 1985200, 1829064, 1835957, 1742552, 1692366, 1830572, 1835845, 1197354, 1835948, 1784091, 1470247, 1470108, 1470514, 1470101, 1527320, 1395035, 1333624, 1557444, 1566984, 1527419, 1570652, 1614928, 1792567, 1949042, 1761950, 1989527, 1761502, 1796342, 1830532, 1429773, 1795266, 1792581, 1663802, 1663818, 1830580, 1762713, 1659351, 1569376, 1659352, 1602906, 1794994, 4381411, 1742737, 1698585, 2188291, 1855444, 1527646, 1695496, 1796095, 1473449, 1667922, 2156644, 1836227, 1811418, 1855443, 1532652, 1791194, 1687921, 1555470, 1613776, 1806648, 1827975, 1863455, 1823071, 1767039, 1833132, 1845778, 1799675, 1830017, 1845568, 1742634, 1795264, 1761402, 1849445, 1821573, 1516744, 1857737, 1773716, 1729235, 2903709, 4377426, 3866804, 1273804, 1404953, 1337370, 4014278, 1611237, 1835841, 1796418, 1668069, 1796494, 1762769, 2956216, 1705315, 3251915, 3337405, 1527532, 1317742, 1684859, 1638186, 1616555, 1326852, 1391427, 4241368, 3549545);

Date: 2025-01-29 17:26:32 Duration: 14ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3652957, 4810389, 4796503, 4782821, 4774671, 4772511, 4771740, 4787044, 4763373, 4795975, 4765881, 4793509, 4804842, 4804144, 4795639, 4792718, 4792210, 4790293, 4789897, 4760455, 4751651, 4810037, 4806906, 4674416, 4512506, 4370311, 3864193, 4787192, 4778597, 4777097, 4772942, 4771589, 4771587, 4767044, 4763548, 4772901, 4797909, 4797009, 4790975, 4790939, 4790767, 4790286, 4787043, 4773935, 4771581, 4771399, 4760076, 4764462, 4804983, 4791866, 4806324, 4777221, 4795210, 4731235, 4848630, 4836587, 4839387, 4831131, 4835157, 4835062, 4826324, 4815460, 4814944, 4773157, 4778857, 4826189, 4810527, 4810511, 4810422, 4801388, 4797669, 4791198, 4828786, 4823451, 4754437, 4840106, 4763382, 4815259, 4826999, 4825150, 4814437, 4815251, 4824998, 4803626, 4797293, 4796471, 4798674, 4796244, 4793186, 4792363, 4823036, 4815624, 4792477, 4809119, 4809107, 4797196, 4804173, 4393775, 3875740, 4470965, 4324608, 4848875, 4760095, 4839381, 4832130, 4829969, 4828932, 4824932, 4821865, 4821604, 4820003, 4819680, 4817480, 4816203, 4810479, 4807653, 4804203, 4793838, 4773832, 4844963, 4778873, 4107391, 4849707, 4849706, 4848610, 4843145, 4841753, 4835509, 4832191, 4831127, 4828796, 4828791, 4828061, 4826185, 4818123, 4816772, 4816664, 4816094, 4802117, 4801992, 4801989, 4798725, 4796155, 4786990, 4784062, 4782827, 4776910, 4775652, 4775468, 4770740, 4762066, 4737524, 4735591, 4830871, 4829338, 4841758, 4799187, 4833765, 4777007, 4828543, 4825077, 4820401, 4820397, 4818004, 4815799, 4814920, 4814915, 4799131, 4706760, 4833176, 4830997, 4827485, 4825779, 4823144, 4820297, 4820289, 4818878, 4818748, 4817958, 4815780, 4815726, 4805083, 4801158, 4793009, 4791736, 4791068, 4782938, 4770911, 4844952, 4835287, 4828476, 4828426, 4822825, 4814435, 4789819, 4789536, 4742812, 4834063, 4829668, 4824950, 4818529, 4817449, 4815144, 4814237, 4812188, 4796529, 4795737, 4794344, 4781698, 4781697, 4752533, 4732311, 4689314, 4803926, 4803086, 4795830, 4787189, 4772328, 4766746, 4760099, 4826619, 4841770, 4831081, 4796840, 4833719, 4828839, 4828089, 4827112, 4823051, 4817633, 4816199, 4816069, 4815752, 4814970, 4801171, 4822834, 4746967, 4822800, 4805897, 4845133, 4835532, 4831087, 4824723, 4844914, 4836211, 4833197, 4831119, 4834055, 4843552, 4839295, 4825809, 4832062, 4819520, 4819396, 4815452, 4830811, 4822934, 4817246, 4816987, 4816688, 4844293, 4776927, 4844822, 4841787, 4821719, 4818430, 4817983, 4813954, 4832122, 4828526, 4827862, 4826903, 4820026, 4816072, 4804347, 4797068, 4796725, 4793194, 4789028, 4839486, 4828093, 4826322, 4821540, 4820333, 4818737, 4817349, 4815149, 4815143, 4810385, 4805143, 4790118, 4827378, 4795226, 4770147, 4766429, 4826946, 4817456, 4777535, 4843149, 4830679, 4805721, 4781407, 4691860, 4835099, 4828785, 4827006, 4822594, 4820001, 4818410, 4815366, 4814848, 4814640, 4797528, 4763523, 4760689, 4795417, 4762680, 4806499, 4797567, 4823038, 4827726, 4791573, 4686200, 4835525, 4826380, 4789692, 4826622, 4844314, 4856538, 4856536, 4825806, 4823886, 4839424, 4834073, 4820431, 4817121, 4815170, 4814908, 4820272, 4827026, 4839441, 4814417, 4821667, 4751589, 4822430, 4789743, 4832134, 4830984, 4804149, 4831308, 4823544, 4828360, 4827763, 4818701, 4816339, 4795831, 4791619, 4816661, 4817694, 4779637, 4820342, 4856526, 4844800, 4827007, 4844021, 4827723, 4844298, 4844808, 4815617, 4772715, 4830509, 4815081, 4774737, 4765626, 4749131, 4748479, 4747890, 4722045, 4700426, 4699115, 4686106, 4612681, 4599840, 4570072, 4532010, 4528659, 4513229, 4465509, 4206332, 4713706, 4843938, 4835361, 4836008, 4834099, 4841735, 4824971, 4823481, 4821003, 4828581, 4833354, 4826480, 4820311, 4820158, 4816063, 4815580, 4794648, 4763546, 4761044, 4789751, 4720250, 4821643, 4793836, 4835094, 4828047, 4796537, 4777304, 4823295, 4814233, 4798519, 4795415, 4782031, 4778162, 4452531, 4797073, 4835982, 4836569, 4844805, 4819122, 4785048, 4852278, 4839392, 4825153, 4825053, 4824708, 4822032, 4821731, 4821652, 4820145, 4819108, 4774648, 4833808, 4817822, 4793512, 4809877, 4764268, 4797082, 4832396, 4832072, 4826433, 4814973, 4849720, 4844832, 4805185, 4843502, 4826618, 4794945, 4828550, 4823624, 4823047, 4817405, 4816632, 4810412, 4802011, 4770700, 4691730, 4849722, 4825105, 4761963, 4841182, 4841089, 4836571, 4834051, 4814220, 4845291, 4841721, 4840085, 4839867, 4824190, 4811263, 4844294, 4801380, 4794545, 4841989, 4839367, 4833310, 4831036, 4830287, 4779749, 4724379, 4836067, 4839451, 4828427, 4827991, 4827216, 4827105, 4824736, 4822678, 4822500, 4820276, 4818385, 4844234, 4713792, 4834146, 4348413, 4862080, 4819983, 4817462, 4815620, 4841750, 4800480, 4833214, 4844768, 4820031, 4833272, 4856533, 4844026, 4835661, 4830905, 4830899, 4826438, 4824993, 4824459, 4822905, 4822838, 4818252, 4817696, 4817141, 4816312, 4815727, 4815724, 4815722, 4806595, 4798754, 4834057, 4848626, 4828412, 4818074, 4818000, 4815044, 4657026, 4802121, 4817998, 4801995, 4802127, 4848625, 4839962, 4837709, 4837209, 4836672, 4835631, 4831616, 4830013, 4828918, 4828794, 4828502, 4826192, 4825363, 4823147, 4822312, 4820876, 4818024, 4817678, 4817240, 4815645, 4815622, 4814221, 4807973, 4798720, 4773126, 4761391, 4746450, 4834915, 4834888, 4829484, 4820393, 4820330, 4818978, 4665129, 4814436, 4824922, 4831038, 4825149, 4770645, 4769344, 4767962, 4732445, 4722199, 4849734, 4828835, 4832143, 4836598, 4808030, 4824704, 4816030, 4828537, 4782545, 4728350, 4822486, 4564115, 4835529, 4772898, 4841794, 4839494, 4835442, 4832393, 4822581, 4819539, 4816371, 4815544, 4801166, 4844306, 4400279, 4710846, 4681533, 4780597, 4742317, 4823066, 4818290, 4789628, 4835999, 4789546, 4816166, 4845473, 4844910, 4843864, 4841035, 4839470, 4836664, 4836513, 4835077, 4831024, 4831002, 4830999, 4830822, 4830421, 4828201, 4823464, 4823325, 4822928, 4819098, 4818118, 4817936, 4815763, 4815472, 4814888, 4810708, 4797006, 4765668, 4815782, 4828009, 4790252, 4836124, 4835286, 4827110, 4834447, 4823872, 4816780, 4826455, 4820373, 4826485, 4817452, 4820305, 4844850, 4835617, 4835538, 4835341, 4833724, 4831313, 4831096, 4828869, 4824052, 4823575, 4815426, 4825403, 4815454, 4843958, 4831039, 4825333, 4822619, 4818104, 4817650, 4816058, 4797576, 4836209, 4844763, 4832165, 4828464, 4822759, 4822270, 4820398, 4819684, 4819066, 4816183, 4795977, 4793682, 4748335, 4836141, 4834194, 4839477, 4827345, 4820038, 4817264, 4794610, 4790241, 4844853, 4657482, 4833329, 4832172, 4832170, 4831033, 4828579, 4828575, 4825262, 4825093, 4819359, 4818458, 4814988, 4813697, 4808028, 4798195, 4797190, 4796296, 4795229, 4775000, 4770856, 4752210, 4722254, 4722240, 4710974, 4710964, 4691553, 4680135, 4822558, 4817079, 4780711, 4792836, 4789408, 4824618, 4844887, 4848628, 4833167, 4831146, 4816368, 4793804, 4400133, 4823137, 4838822, 4830467, 4828367, 4825587, 4824910, 4824732, 4822828, 4820312, 4820063, 4820061, 4817411, 4817148, 4765579, 4834032, 4773812, 4821756, 4820260, 4744148, 4822566, 4801981, 4843850, 4789212, 4844307, 4839432, 4805228, 4765011, 4844777, 4831542, 4826514, 4823574, 4836137, 4834022, 4816728, 4844851, 4804484, 4802439, 4808768, 4829020, 4822870, 4820300, 4818156, 4815391, 4810476, 4810467, 4797421, 4795952, 4792234, 4810827, 4804112, 4659275, 4812204, 4669303, 4789067, 4819190, 4771784, 4825080, 4790534, 4823100, 4790584, 4837206, 4812203, 4848602, 4843301, 4841109, 4840104, 4839984, 4836406, 4833763, 4831777, 4830965, 4828205, 4825397, 4822572, 4821023, 4820155, 4819410, 4818381, 4818056, 4817124, 4816645, 4814884, 4801483, 4800982, 4798689, 4797423, 4796520, 4796311, 4794300, 4793221, 4791490, 4789316, 4777499, 4773816, 4766570, 4684156, 4806997, 4727354, 4746931, 4592122, 4648272, 4386100, 4409174, 4800518, 4849917, 4848604, 4827273, 4826799, 4825267, 4825140, 4825095, 4825055, 4824695, 4823260, 4820315, 4817325, 4806224, 4798574, 4797599, 4797038, 4771860, 4686313, 4504370, 4843847, 4836100, 4775796, 4753016, 4849260, 4839396, 4830893, 4828503, 4827418, 4826483, 4821807, 4821801, 4817641, 4816103, 4815667, 4815665, 4812205, 4797570, 4797403, 4793647, 4788420, 4781442, 4774764, 4763564, 4717551, 4659325, 4848909, 4840141, 4840018, 4822749, 4822739, 4816658, 4815650, 4789509, 4772586, 4808778, 4808067, 4551966, 4844302, 4836013, 4835948, 4824230, 4611358, 4844301, 4843924, 4835653, 4836059, 4824690, 4819164, 4831623, 4817386, 4816038, 4815801, 4813707, 4796496, 4727496, 4746402, 4797933, 4830418, 4815125, 4817391, 4814954);

Date: 2025-01-29 17:22:22 Duration: 12ms

17

166,819

Details

10s389ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,232	64ms	0ms
	01	906	46ms	0ms
	02	762	39ms	0ms
	03	554	28ms	0ms
	04	457	23ms	0ms
	05	636	30ms	0ms
	06	1,233	66ms	0ms
	07	801	40ms	0ms
	08	3,734	190ms	0ms
	09	8,538	506ms	0ms
	10	17,045	1s160ms	0ms
	11	18,910	1s214ms	0ms
	12	15,641	1s41ms	0ms
	13	16,468	979ms	0ms
	14	14,550	859ms	0ms
	15	12,536	775ms	0ms
	16	14,090	970ms	0ms
	17	12,356	905ms	0ms
	18	6,523	383ms	0ms
	19	8,760	488ms	0ms
	20	6,095	321ms	0ms
	21	3,256	167ms	0ms
	22	1,736	85ms	0ms

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

Date: 2025-01-29 12:18:44 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 (21);

Date: 2025-01-29 13:08:33 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 (88, 89);

Date: 2025-01-29 17:44:47 Duration: 0ms

18

159,996

Details

21s498ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,211	135ms	0ms
	01	827	89ms	0ms
	02	726	81ms	0ms
	03	536	58ms	0ms
	04	434	45ms	0ms
	05	597	58ms	0ms
	06	1,209	133ms	0ms
	07	789	85ms	0ms
	08	3,493	377ms	0ms
	09	8,283	1s57ms	0ms
	10	16,369	2s434ms	0ms
	11	18,187	2s520ms	0ms
	12	15,079	2s179ms	0ms
	13	15,617	1s999ms	0ms
	14	14,079	1s779ms	0ms
	15	12,082	1s609ms	0ms
	16	13,552	2s45ms	0ms
	17	11,772	1s899ms	0ms
	18	6,272	789ms	0ms
	19	8,206	964ms	0ms
	20	5,764	629ms	0ms
	21	3,235	350ms	0ms
	22	1,677	174ms	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-29 13:53:41 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-29 17:33:35 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-29 09:52:22 Duration: 1ms

19

152,507

Details

2h3m5s

35ms

336ms

48ms

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 29	00	4,382	3m9s	43ms
	01	2,957	2m8s	43ms
	02	4,277	3m5s	43ms
	03	2,471	1m47s	43ms
	04	2,319	1m40s	43ms
	05	931	40s431ms	43ms
	06	2,705	1m58s	43ms
	07	1,541	1m6s	43ms
	08	2,951	2m7s	43ms
	09	9,476	7m25s	46ms
	10	14,120	12m3s	51ms
	11	14,645	12m15s	50ms
	12	14,529	12m6s	49ms
	13	11,543	9m20s	48ms
	14	9,027	7m1s	46ms
	15	7,788	6m17s	48ms
	16	8,143	7m8s	52ms
	17	8,642	8m1s	55ms
	18	5,944	4m53s	49ms
	19	8,209	6m31s	47ms
	20	7,177	5m36s	46ms
	21	5,395	4m6s	45ms
	22	3,335	2m33s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4848669, 4819887, 4791889)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 15:53:15 Duration: 336ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4870788, 4854671)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 15:54:14 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4705836)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 17:43:05 Duration: 281ms

20

145,096

Details

9h6m4s

170ms

1s550ms

225ms

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,755	5m44s	196ms
	01	1,600	5m11s	194ms
	02	1,965	6m23s	195ms
	03	3,427	11m9s	195ms
	04	2,755	8m55s	194ms
	05	1,836	5m55s	193ms
	06	663	2m10s	196ms
	07	2,505	8m7s	194ms
	08	2,214	7m12s	195ms
	09	5,677	19m44s	208ms
	10	11,666	45m21s	233ms
	11	4,414	16m41s	226ms
	12	11,895	45m4s	227ms
	13	7,596	28m2s	221ms
	14	14,712	52m14s	213ms
	15	22,471	1h29m56s	240ms
	16	25,551	1h41m2s	237ms
	17	17,102	1h9m41s	244ms
	18	4,128	13m37s	198ms
	19	515	1m41s	196ms
	20	242	46s588ms	192ms
	21	286	55s486ms	194ms
	22	121	23s643ms	195ms

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

Date: 2025-01-29 17:50:14 Duration: 1s550ms
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" = '18865')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-29 15:53:56 Duration: 1s474ms
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" = '78181')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-29 17:43:04 Duration: 1s470ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

52m17s

2m42s

70

Details

3h9m52s

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 29	02	1	0ms	0ms
	04	3	37m20s	12m26s
	05	8	17m44s	2m13s
	06	1	51m58s	51m58s
	08	7	7ms	1ms
	09	5	1m17s	15s423ms
	10	4	7ms	1ms
	11	3	2m48s	56s292ms
	12	6	3ms	0ms
	13	9	4ms	0ms
	14	11	1h10m57s	6m27s
	15	3	10ms	3ms
	17	1	1ms	1ms
	18	1	0ms	0ms
	20	1	7m44s	7m44s
	21	3	3ms	1ms
	22	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-29 12:54:03.872327', "last_update" = '2025-01-29 12:09:03.872356', "write_date" = '2025-01-29 12:09:03.439750', "write_uid" = 886 WHERE id IN (886);

Date: 2025-01-29 14:01:21 Duration: 52m17s
UPDATE "res_users" SET "exp_date" = '2025-01-29 04:55:22.122777', "last_update" = '2025-01-29 04:10:22.122811', "write_date" = '2025-01-29 04:10:21.795506', "write_uid" = 1123 WHERE id IN (1123);

Date: 2025-01-29 06:02:20 Duration: 51m58s
UPDATE "res_users" SET "exp_date" = '2025-01-29 03:56:00.755084', "last_update" = '2025-01-29 03:11:00.755110', "write_date" = '2025-01-29 03:11:00.434630', "write_uid" = 1 WHERE id IN (1432);

Date: 2025-01-29 04:48:21 Duration: 37m20s

2

0ms

31m7s

54s19ms

285

Details

4h16m35s

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 29	00	3	0ms	0ms
	01	4	0ms	0ms
	02	6	1ms	0ms
	03	4	2ms	0ms
	04	4	1h8m3s	17m
	05	4	6m41s	1m40s
	06	5	7ms	1ms
	07	3	4ms	1ms
	08	11	9ms	0ms
	09	27	1h21m22s	3m
	10	28	40ms	1ms
	11	14	20ms	1ms
	12	26	13m42s	31s620ms
	13	22	18ms	0ms
	14	21	28ms	1ms
	15	27	29m46s	1m6s
	16	19	1m24s	4s452ms
	17	17	35ms	2ms
	18	11	5ms	0ms
	19	8	18m32s	2m19s
	20	12	37m3s	3m5s
	21	1	0ms	0ms
	22	8	5ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-29 04:02:13.413569', "last_update" = '2025-01-29 03:17:13.413597', "sid" = 'a9ac041633ec30e279f63703a222f7e49d31bafb', "write_date" = '2025-01-29 03:17:13.092496', "write_uid" = 1 WHERE id IN (1432);

Date: 2025-01-29 04:48:21 Duration: 31m7s
UPDATE "res_users" SET "exp_date" = '2025-01-29 14:50:34.477151', "last_update" = '2025-01-29 14:05:34.477184', "sid" = '791f1578f5242d7219292180e9e15f3a4fd4130e', "write_date" = '2025-01-29 14:05:34.044946', "write_uid" = 1 WHERE id IN (886);

Date: 2025-01-29 15:35:20 Duration: 29m46s
UPDATE "res_users" SET "exp_date" = '2025-01-29 04:05:08.410371', "last_update" = '2025-01-29 03:20:08.410393', "sid" = 'aafd0f0986575e3576a622788f5072aa311230ff', "write_date" = '2025-01-29 03:20:08.076806', "write_uid" = 1 WHERE id IN (1432);

Date: 2025-01-29 04:48:21 Duration: 28m12s

3

0ms

59m59s

5s882ms

68,010

Details

4d15h8m12s

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 29	00	894	59m58s	4s25ms
	01	876	183ms	0ms
	02	989	209ms	0ms
	03	1,068	225ms	0ms
	04	752	9h57m34s	47s679ms
	05	339	3h15m25s	34s589ms
	06	698	14h32m37s	1m15s
	07	553	42s343ms	76ms
	08	1,750	376ms	0ms
	09	4,530	6h45m51s	5s375ms
	10	7,233	3h40m31s	1s829ms
	11	7,016	9h42m39s	4s982ms
	12	6,519	9h58m35s	5s509ms
	13	6,182	1m7s	10ms
	14	4,987	20h44m59s	14s978ms
	15	4,786	5h10m29s	3s892ms
	16	4,783	5h22m43s	4s48ms
	17	4,300	5m44s	80ms
	18	3,106	2m57s	57ms
	19	2,746	10h20m39s	13s561ms
	20	1,830	10h25m31s	20s509ms
	21	1,271	294ms	0ms
	22	802	183ms	0ms

update res_users set sid = '3ebf5ebeb746a4e25349326bf231c4e9986c992e', last_update = '2025-01-29 07:21:06.933263', exp_date = '2025-01-29 08:06:06.933265', logged_in = 'TRUE' where id = 1197;

Date: 2025-01-29 09:21:06 Duration: 59m59s
update res_users set sid = '3ebf5ebeb746a4e25349326bf231c4e9986c992e', last_update = '2025-01-28 22:09:46.369494', exp_date = '2025-01-28 22:54:46.369499', logged_in = 'TRUE' where id = 1197;

Date: 2025-01-29 00:09:45 Duration: 59m58s
update res_users set sid = '9dd472d2ed106a4c3634700384ee14881ab72f39', last_update = '2025-01-29 04:10:35.565819', exp_date = '2025-01-29 04:55:35.565822', logged_in = 'TRUE' where id = 1123;

Date: 2025-01-29 06:02:20 Duration: 51m45s

4

219ms

2s75ms

932ms

11,436

Details

2h57m42s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 29	00	788	12m	913ms
	01	218	3m14s	890ms
	02	404	6m2s	898ms
	05	4	3s651ms	912ms
	08	23	20s749ms	902ms
	09	29	27s110ms	934ms
	10	36	38s450ms	1s68ms
	11	43	49s41ms	1s140ms
	12	1	1s1ms	1s1ms
	13	110	1m45s	956ms
	14	242	4m11s	1s41ms
	15	450	7m52s	1s49ms
	16	926	17m6s	1s108ms
	17	1,318	23m26s	1s67ms
	18	820	12m18s	900ms
	19	1,713	24m42s	865ms
	20	2,348	34m41s	886ms
	21	991	13m37s	824ms
	22	972	14m24s	888ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '114552')) 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 (26))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-29 17:50:28 Duration: 2s75ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '92551')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-29 17:50:32 Duration: 2s18ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '92202')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-29 17:50:27 Duration: 2s9ms

5

517ms

4s921ms

650ms

45,645

Details

8h14m57s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 29	00	206	2m7s	618ms
	01	140	1m30s	649ms
	02	197	2m7s	649ms
	03	206	2m14s	651ms
	04	163	1m44s	643ms
	05	137	1m20s	589ms
	06	393	3m49s	582ms
	07	176	1m42s	580ms
	08	1,165	10m50s	558ms
	09	3,506	35m51s	613ms
	10	4,520	51m27s	683ms
	11	5,039	55m15s	658ms
	12	4,700	52m3s	664ms
	13	4,871	52m17s	644ms
	14	3,090	31m42s	615ms
	15	3,162	33m54s	643ms
	16	3,164	36m56s	700ms
	17	3,324	40m56s	738ms
	18	2,606	27m25s	631ms
	19	2,145	22m3s	617ms
	20	1,397	14m10s	609ms
	21	867	8m42s	602ms
	22	471	4m41s	598ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4874821, 4873427, 4873330, 4870323, 4870180, 4867921, 4867864, 4867846, 4866709, 4865976, 4863768, 4863647, 4863521, 4862624, 4862143, 4862048, 4861015, 4859194, 4857660, 4856995, 4856673, 4855198, 4844038, 4841922, 4830444, 4797472)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 11:08:31 Duration: 4s921ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4828023, 4828019, 4823455, 4823035, 4810484, 4795776)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 15:53:32 Duration: 4s715ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4873840)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:50:17 Duration: 4s561ms

6

512ms

5s843ms

629ms

267,625

Details

1d22h47m29s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 29	00	8,441	1h19m40s	566ms
	01	7,632	1h11m11s	559ms
	02	9,434	1h28m57s	565ms
	03	7,846	1h12m41s	555ms
	04	8,383	1h18m18s	560ms
	05	3,747	35m43s	571ms
	06	8,220	1h18m17s	571ms
	07	3,000	27m8s	542ms
	08	4,969	45m28s	549ms
	09	12,179	2h1m32s	598ms
	10	20,646	3h45m17s	654ms
	11	18,005	3h13m17s	644ms
	12	17,340	3h4m53s	639ms
	13	14,664	2h33m8s	626ms
	14	11,732	1h58m30s	606ms
	15	11,563	2h3m22s	640ms
	16	21,655	4h6m14s	682ms
	17	23,448	4h47m31s	735ms
	18	17,028	3h2m20s	642ms
	19	11,853	2h4m49s	631ms
	20	11,669	2h3m1s	632ms
	21	8,227	1h24m3s	613ms
	22	5,944	1h1m59s	625ms

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

Date: 2025-01-29 17:50:03 Duration: 5s843ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4885741)) AND (("shipping_track"."id" not in (40503074, 40503074)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:49:49 Duration: 5s466ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4885800)) AND (("shipping_track"."id" not in (40503327, 40503327)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-29 17:50:22 Duration: 5s181ms

7

183ms

1s433ms

331ms

25,054

Details

2h18m20s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 29	07	82	20s510ms	250ms
	08	175	44s10ms	251ms
	09	2,017	13m2s	388ms
	10	3,333	20m10s	363ms
	11	933	4m50s	311ms
	12	4,145	21m37s	313ms
	13	3,899	19m37s	302ms
	14	3,869	19m3s	295ms
	15	2,752	14m29s	315ms
	16	2,575	16m23s	381ms
	17	1,177	7m14s	369ms
	18	65	30s942ms	476ms
	19	32	14s820ms	463ms

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

Date: 2025-01-29 15:53:11 Duration: 1s433ms
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" = '9638738')))) ORDER BY "collection_policy"."id";

Date: 2025-01-29 15:52:39 Duration: 1s384ms
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" = '34639')))) ORDER BY "collection_policy"."id";

Date: 2025-01-29 13:11:52 Duration: 1s263ms

8

220ms

1s805ms

285ms

17,376

Details

1h22m45s

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	455	2m1s	267ms
	01	496	2m14s	270ms
	02	1,024	4m30s	264ms
	03	488	2m9s	264ms
	04	1,036	4m34s	265ms
	05	992	4m16s	258ms
	06	1,717	7m33s	263ms
	07	3	796ms	265ms
	08	29	7s646ms	263ms
	09	92	27s913ms	303ms
	10	155	48s38ms	309ms
	11	139	43s234ms	311ms
	12	45	16s919ms	375ms
	13	377	1m51s	296ms
	14	221	1m2s	283ms
	15	103	34s99ms	331ms
	16	1,039	5m52s	339ms
	17	1,667	9m51s	354ms
	18	1,178	5m52s	299ms
	19	1,483	7m1s	284ms
	20	1,683	7m43s	275ms
	21	1,537	6m46s	264ms
	22	1,417	6m25s	271ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '178421')) 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-29 17:43:30 Duration: 1s805ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '44269')) 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-29 17:50:04 Duration: 1s788ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '176996')) 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-29 17:43:38 Duration: 1s630ms

9

14ms

2s627ms

280ms

2,584

Details

12m6s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 29	00	4	1s346ms	336ms
	01	1	426ms	426ms
	07	16	2s70ms	129ms
	08	51	7s780ms	152ms
	09	123	27s899ms	226ms
	10	203	53s117ms	261ms
	11	346	1m37s	281ms
	12	275	1m23s	302ms
	13	327	1m36s	294ms
	14	294	1m1s	209ms
	15	237	1m9s	294ms
	16	237	1m16s	324ms
	17	172	58s439ms	339ms
	18	115	34s775ms	302ms
	19	66	19s568ms	296ms
	20	63	21s106ms	335ms
	21	30	11s554ms	385ms
	22	24	2s601ms	108ms

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

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

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

Date: 2025-01-29 15:54:19 Duration: 1s791ms

10

96ms

894ms

245ms

56,980

Details

3h53m9s

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	2,466	9m12s	223ms
	01	1,426	5m1s	211ms
	02	2,834	10m45s	227ms
	03	966	3m58s	247ms
	04	2,050	7m28s	218ms
	05	1,980	7m35s	230ms
	06	3,403	12m30s	220ms
	07	2	250ms	125ms
	08	100	21s619ms	216ms
	09	232	1m1s	266ms
	10	374	1m25s	229ms
	11	358	1m35s	267ms
	12	82	23s992ms	292ms
	13	934	3m35s	230ms
	14	880	3m6s	212ms
	15	1,079	4m31s	252ms
	16	3,851	18m16s	284ms
	17	5,936	29m14s	295ms
	18	3,964	16m34s	250ms
	19	6,331	25m23s	240ms
	20	8,017	31m26s	235ms
	21	5,000	19m17s	231ms
	22	4,715	20m18s	258ms

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-29 17:50:27 Duration: 894ms
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-29 17:50:28 Duration: 877ms
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-29 19:38:30 Duration: 877ms

11

170ms

1s550ms

225ms

145,096

Details

9h6m4s

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,755	5m44s	196ms
	01	1,600	5m11s	194ms
	02	1,965	6m23s	195ms
	03	3,427	11m9s	195ms
	04	2,755	8m55s	194ms
	05	1,836	5m55s	193ms
	06	663	2m10s	196ms
	07	2,505	8m7s	194ms
	08	2,214	7m12s	195ms
	09	5,677	19m44s	208ms
	10	11,666	45m21s	233ms
	11	4,414	16m41s	226ms
	12	11,895	45m4s	227ms
	13	7,596	28m2s	221ms
	14	14,712	52m14s	213ms
	15	22,471	1h29m56s	240ms
	16	25,551	1h41m2s	237ms
	17	17,102	1h9m41s	244ms
	18	4,128	13m37s	198ms
	19	515	1m41s	196ms
	20	242	46s588ms	192ms
	21	286	55s486ms	194ms
	22	121	23s643ms	195ms

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

Date: 2025-01-29 17:50:14 Duration: 1s550ms
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" = '18865')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-29 15:53:56 Duration: 1s474ms
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" = '78181')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-29 17:43:04 Duration: 1s470ms

12

174ms

459ms

225ms

4,377

Details

16m27s

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

Day	Hour	Count	Duration	Avg duration
Jan 29	05	749	2m24s	192ms
	09	826	2m56s	213ms
	10	2,473	9m43s	236ms
	11	121	30s156ms	249ms
	12	34	9s658ms	284ms
	13	105	28s438ms	270ms
	15	38	8s385ms	220ms
	20	31	5s920ms	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" = '9946855')) 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-29 10:51:49 Duration: 459ms
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" = '8888067')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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-29 12:48:47 Duration: 418ms
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" = '9605072')) 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, 12, 20)))) 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, 12, 20))))) 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, 12, 20))))) 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-29 13:11:49 Duration: 388ms

13

174ms

1s66ms

213ms

18,192

Details

1h4m44s

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	154	29s790ms	193ms
	03	354	1m9s	196ms
	04	9	1s725ms	191ms
	05	441	1m25s	193ms
	06	663	2m10s	196ms
	07	2,395	7m46s	194ms
	08	1,810	5m54s	195ms
	09	1,701	6m3s	213ms
	10	3,405	12m50s	226ms
	11	1,857	7m5s	229ms
	12	846	3m7s	221ms
	13	1,215	4m29s	221ms
	14	806	2m51s	213ms
	15	66	15s660ms	237ms
	16	672	2m36s	233ms
	17	700	2m47s	239ms
	18	145	31s702ms	218ms
	19	335	1m5s	194ms
	20	211	40s896ms	193ms
	21	286	55s675ms	194ms
	22	121	23s649ms	195ms

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" = '9504291')) 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 (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) 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-29 10:45:24 Duration: 1s66ms
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" = '9348288')) 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 (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) 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-29 11:08:16 Duration: 551ms
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" = '118221')) 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 (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) 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-29 11:08:13 Duration: 536ms

14

173ms

253ms

195ms

10,336

Details

33m38s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,494	4m53s	196ms
	01	1,600	5m11s	194ms
	02	1,599	5m11s	194ms
	03	2,263	7m23s	196ms
	04	2,734	8m52s	194ms
	05	646	2m5s	194ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9779792')) 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-29 00:13:30 Duration: 253ms
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" = '9703897')) 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-29 00:13:29 Duration: 243ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '72862')) 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-29 00:13:34 Duration: 240ms

15

119ms

1s99ms

156ms

6,100

Details

15m53s

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

Day	Hour	Count	Duration	Avg duration
Jan 29	00	44	5s922ms	134ms
	06	5	685ms	137ms
	07	5	662ms	132ms
	08	79	10s599ms	134ms
	09	468	1m7s	143ms
	10	1,103	2m59s	162ms
	11	1,247	3m20s	160ms
	12	948	2m33s	162ms
	13	572	1m28s	155ms
	14	642	1m33s	145ms
	15	216	33s732ms	156ms
	16	140	24s236ms	173ms
	17	236	40s466ms	171ms
	18	103	14s820ms	143ms
	19	83	11s616ms	139ms
	20	54	7s601ms	140ms
	21	114	14s694ms	128ms
	22	41	5s428ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 11)) 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-29 12:49:19 Duration: 1s99ms
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-29 11:07:39 Duration: 956ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-29 15:55:17 Duration: 914ms

16

94ms

794ms

127ms

17,729

Details

37m47s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 29	05	21	2s433ms	115ms
	06	33	3s894ms	118ms
	08	272	31s336ms	115ms
	09	808	1m40s	124ms
	10	1,950	4m21s	133ms
	11	2,232	4m46s	128ms
	12	1,880	4m7s	131ms
	13	2,255	4m42s	125ms
	14	1,523	3m8s	123ms
	15	1,664	3m30s	126ms
	16	1,609	3m35s	133ms
	17	961	2m16s	142ms
	18	905	1m50s	122ms
	19	472	56s949ms	120ms
	20	437	51s514ms	117ms
	21	187	21s454ms	114ms
	22	520	59s956ms	115ms

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

Date: 2025-01-29 13:07:41 Duration: 794ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8054705)) AND (("cash_track"."id" not in (7477622)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-29 11:08:27 Duration: 787ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8056077)) AND (("cash_track"."id" not in (7484324)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-29 13:11:28 Duration: 646ms

17

44ms

332ms

60ms

40,951

Details

41m15s

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

Day	Hour	Count	Duration	Avg duration
Jan 29	07	52	2s768ms	53ms
	08	410	21s753ms	53ms
	09	3,125	3m2s	58ms
	10	3,173	3m22s	63ms
	11	3,325	3m18s	59ms
	12	6,888	6m58s	60ms
	13	4,201	4m10s	59ms
	14	6,030	5m42s	56ms
	15	5,675	5m36s	59ms
	16	5,152	5m25s	63ms
	17	2,515	2m48s	66ms
	18	167	9s886ms	59ms
	19	165	9s547ms	57ms
	20	53	3s19ms	56ms
	21	14	768ms	54ms
	22	6	315ms	52ms

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

Date: 2025-01-29 15:53:24 Duration: 332ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4855999) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-29 17:51:07 Duration: 331ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4768877) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-29 17:43:05 Duration: 323ms

18

40ms

277ms

54ms

19,619

Details

17m53s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 29	07	26	1s249ms	48ms
	08	202	9s944ms	49ms
	09	1,514	1m16s	50ms
	10	1,537	1m25s	55ms
	11	1,401	1m20s	57ms
	12	4,181	4m2s	58ms
	13	2,923	2m34s	52ms
	14	2,814	2m23s	51ms
	15	2,356	2m12s	56ms
	16	1,635	1m29s	55ms
	17	915	51s612ms	56ms
	18	83	4s245ms	51ms
	19	32	1s530ms	47ms

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

Date: 2025-01-29 15:52:41 Duration: 277ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4797163) ORDER BY "collection_policy"."id";

Date: 2025-01-29 16:11:10 Duration: 266ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4831616) ORDER BY "collection_policy"."id";

Date: 2025-01-29 15:49:45 Duration: 261ms

19

35ms

336ms

48ms

152,507

Details

2h3m5s

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 29	00	4,382	3m9s	43ms
	01	2,957	2m8s	43ms
	02	4,277	3m5s	43ms
	03	2,471	1m47s	43ms
	04	2,319	1m40s	43ms
	05	931	40s431ms	43ms
	06	2,705	1m58s	43ms
	07	1,541	1m6s	43ms
	08	2,951	2m7s	43ms
	09	9,476	7m25s	46ms
	10	14,120	12m3s	51ms
	11	14,645	12m15s	50ms
	12	14,529	12m6s	49ms
	13	11,543	9m20s	48ms
	14	9,027	7m1s	46ms
	15	7,788	6m17s	48ms
	16	8,143	7m8s	52ms
	17	8,642	8m1s	55ms
	18	5,944	4m53s	49ms
	19	8,209	6m31s	47ms
	20	7,177	5m36s	46ms
	21	5,395	4m6s	45ms
	22	3,335	2m33s	45ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4848669, 4819887, 4791889)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 15:53:15 Duration: 336ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4870788, 4854671)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 15:54:14 Duration: 331ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4705836)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-29 17:43:05 Duration: 281ms

20

0ms

5m44s

46ms

29,058

Details

22m39s

update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 29	00	1,232	245ms	0ms
	01	712	135ms	0ms
	02	1,416	269ms	0ms
	03	483	79ms	0ms
	04	1,025	227ms	0ms
	05	990	2m58s	180ms
	06	1,703	16m14s	572ms
	07	1	0ms	0ms
	08	70	21ms	0ms
	09	177	62ms	0ms
	10	252	94ms	0ms
	11	245	85ms	0ms
	12	96	46ms	0ms
	13	522	149ms	0ms
	14	477	124ms	0ms
	15	587	184ms	0ms
	16	1,951	2m31s	77ms
	17	3,007	992ms	0ms
	18	2,019	537ms	0ms
	19	3,194	812ms	0ms
	20	4,026	1s7ms	0ms
	21	2,510	551ms	0ms
	22	2,363	49s43ms	20ms

UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-29 05:09:36.649374', "write_uid" = 1088 WHERE id IN (32217550);

Date: 2025-01-29 06:15:22 Duration: 5m44s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-29 05:07:55.629266', "write_uid" = 1088 WHERE id IN (32217550);

Date: 2025-01-29 06:12:15 Duration: 4m18s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-29 04:38:20.213911', "write_uid" = 1088 WHERE id IN (32217550);

Date: 2025-01-29 05:41:20 Duration: 2m58s

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

19,064,058 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	15	0.00%
DETAIL	35	0.00%
ERROR	3,851	0.02%
EVENTLOG	1,148	0.01%
FATAL	929	0.00%
HINT	9	0.00%
LOG	19,054,182	99.95%
STATEMENT	3,889	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
929 FATAL entries
3851 ERROR entries
0 WARNING entries
1148 EVENTLOG entries

Most Frequent Errors/Events

Key values

2,061 Max number of times the same event was reported
5,928 Total events found

Rank

Times reported

Error

1

2,061

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 29	00	31
	01	9
	02	8
	03	6
	04	6
	05	23
	06	30
	07	11
	08	41
	09	74
	10	224
	11	294
	12	154
	13	156
	14	107
	15	157
	16	297
	17	201
	18	94
	19	52
	20	36
	21	32
	22	18

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,760

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 29	00	30
	01	5
	02	5
	03	3
	04	1
	05	17
	06	23
	07	10
	08	40
	09	67
	10	203
	11	279
	12	139
	13	136
	14	92
	15	121
	16	231
	17	153
	18	72
	19	49
	20	36
	21	32
	22	16

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

746

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 29	04	32
	05	26
	06	54
	09	27
	10	70
	11	84
	12	72
	14	74
	15	66
	16	95
	19	70
	20	76

4

746

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 29	04	32
	05	26
	06	54
	09	27
	10	70
	11	84
	12	72
	14	74
	15	66
	16	95
	19	70
	20	76

5

272

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 29	00	1
	04	4
	05	8
	06	11
	09	13
	10	25
	11	46
	12	25
	14	23
	15	29
	16	34
	19	29
	20	24

6

129

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 29	05	1
	06	4
	09	4
	10	12
	11	26
	12	15
	14	13
	15	15
	16	19
	19	12
	20	8

7

110

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 29	17	110

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

8

20

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 29	17	20

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

9

18

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 29	18	2
	19	16

FATAL: password authentication failed for user "postgres"

10

15

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 29	17	15

11

9

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 29	10	2
	12	2
	13	1
	14	1
	15	2
	17	1

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

12

8

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 29	10	4
	11	1
	12	1
	13	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

13

7

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 29	10	2
	12	5

ERROR: syntax error at or near ")" at character 162
ERROR: syntax error at or near ")" at character 300
ERROR: syntax error at or near ")" at character 164

14

5

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 29	03	1
	11	1
	12	1
	15	1
	21	1

15

4

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 29	17	4

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

16

4

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 29	03	1
	11	1
	12	1
	15	1

17

4

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 29	03	1
	11	1
	12	1
	15	1

18

4

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 29	09	1
	11	1
	14	2

19

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 29	11	1
	13	1

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

20

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 29	17	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 29	00	1

22

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 29	17	1

23

1

Details

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

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 29	18	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